project QadFinancials > class BCInvoice > dataset BCInvoice

class dataset

object identification

primary key
CInvoice_ID
object identity
CInvoice_ID
object status
CInvoiceAllocationStatus
CInvoiceIsLockPayment
CInvoiceIsInvoiceApproved
CInvoiceIsLogisticMatching

table tCInvoice

Description

CInvoice - Supplier Invoice

Annotation

<QUERYTYPE=Application Table - Transactions>

field namedata typemnd.description
CInvoice_IDintegeryesRecord ID
Company_IDintegeryesLink to Company
Period_IDintegeryesLink to Period
Creditor_IDintegeryesLink to Creditor
Division_IDintegernoSub-Account
Journal_IDintegeryesDaybook Code
LinkedCInvoice_IDintegernoReference
CInvoiceCurrency_IDintegeryesCurrency Code
Reason_IDintegeryesInvoice Status Code
NormalPaymentCondition_IDintegeryesCredit Terms Code
BLWIGroup_IDintegernoBLWI Group Code
OwnVatNumber_IDintegernoLink to VatNumber
CreditorVatNumber_IDintegernoLink to VatNumber
TransactionStartCountry_IDintegernoCountry Code
TransactionEndCountry_IDintegernoCountry Code
Project_IDintegernoProject
CostCentre_IDintegernoCost Center
Role_IDintegernoRole Name
VatCurrency_IDintegernoCurrency Code
ShipToAddress_IDintegernoCity
PurchaseType_IDintegernoPurchase Type
ControlGL_IDintegeryesAccount
ReplacedCInvoice_IDintegernoLink to CInvoice
CInvoicePostingDatedateyesPosting Date. This filed indicates the date on which the invoice is to be posted.
api annotation:This field defaults from the invoice creation date.
CInvoiceTypecharacter(20)yesInvoice Type. This field identifies the invoice type.
The value can be Invoice Correction and Credit Note Correction type only when the appropriate daybook types have already been defined.
value list:{&INVOICETYPES}
CInvoiceVoucherintegernoVoucher. This field displays the numeric identifier assigned to the posting.
When the daybook of the journal entry is changed (after transfer), the voucher is cleared.
Voucher must be unique in one GL period.
When the user input is zero, the system automatically assign a value not used yet for this field.
CInvoiceDatedateyesInvoice Date. This field indicates the invoice creation date.
The system uses this field with the credit terms to calculate due date and discount date.
api annotation:This field defaults from the system date.
CInvoiceTaxPointDatedateyesTax Point Date.This field indicates the date to be used in tax calculations.
api annotation:This field defaults from the posting date.
CInvoiceReferencecharacter(22)noReference. An alphanumeric reference to help identify the invoice in the system.
This reference is typically the ID number of the invoice received from the supplier.
CInvoiceDescriptioncharacter(40)noDescription. A brief description of the invoice. The system generates a default description based on the Reference and Supplier Code.
CInvoiceOriginalDebitLCdecimal(4)noBC Invoice Amount(DR). This field displays the debit total invoice amount in the base currency.
This field is calculated by the system using the TC Invoice Amount(DR) and the Exchange rate.
CInvoiceOriginalCreditLCdecimal(4)noBC Invoice Amount(CR). This field displays the credit total invoice amount in the base currency.
This field is calculated by the system using the TC Invoice Amount(CR) and the Exchange rate.
CInvoiceOriginalDebitTCdecimal(4)noTC AP Amount. This field displays the debit total invoice amount in the transaction currency.
If you modify this field, the system automatically recalculates the exchange rate to ensure that the TC Invoice Amount remains the same.
CInvoiceOriginalCreditTCdecimal(4)noTC Invoice Amount CR. This field displays the credit total invoice amount in the transaction currency.
If you modify this field, the system automatically recalculates the exchange rate to ensure that the BC Invoice Amount remains the same.
CInvoiceOriginalDebitCCdecimal(4)noSC Invoice Amount (DR). This field displays the debit total invoice amount in the statutory currency.
This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
CInvoiceOriginalCreditCCdecimal(4)noSC Invoice Amount (CR). This field displays the credit total invoice amount in the statutory currency.
This field is calculated by the system using the TC Invoice Amount(CR) and the SC Rate.
CInvoiceExchangeRatedecimal(10)yesExchange Rate. The exchange rate used by the invoice.
The BC Invoice Amount is calculated based on the exchange rate.
If user modify the TC Invoice Amount, the BC invoice amount is automatically adjusted.
CInvoiceRateScaledecimal(10)noScale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments.
CInvoiceCCRatedecimal(10)noSC Rate. The statutory exchange rate used by the invoice.
The SC Invoice Amount is calculated based on the SC rate.
CInvoiceCCScaledecimal(10)noScale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments.
CInvoiceAllocationStatuscharacter(20)yesAllocation Status.This field indicates whether postings occur and if they affect transient or official layers.
User can not delete an invoice which has a non-initial invoice status code.
value list:{&ALLOCSTATUSS}
CInvoiceIsLockPaymentlogicalyesLock Payment. This field indicates if the invoice is locked for payment. The invoice cannot be included in any automatic payment selections if this field is true.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceIsInvoiceApprovedlogicalyesInvoice Approved. This field indicates if the invoice is already approved for payment.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceContactcharacter(40)noContact. This field indicates the name of the purchasing contact in the supplier company.
api annotation:This field defaults from the Contact field of the invoice's supplier.
CInvoiceTSMNumbercharacter(60)noPayment Reference. This field displays a unique reference number to be included in the supplier payment file.
This reference can consist of a Transfer with Structured Message (TSM) number.
This field can be blank.
CInvoiceDueDatedateyesDue Date.This field indicates the date when payment become due.
This field can be modified without affecting the credit terms.
This field is calculated by the system based on the credit terms and the invoice date.
CInvoiceDiscountDueDatedatenoDiscount Due Date.This field indicates the last date a discount applies, calculated by the system based on the credit terms and the invoice date.
User can modify this field without affecting the credit terms.
CInvoiceVatBaseDebitLCdecimal(4)noBC Base Amount DR. This field displays the debit base amount in the base currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
CInvoiceVatBaseCreditLCdecimal(4)noBC Base Amount CR. This field displays the credit base amount in the base currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
CInvoiceVatBaseDebitTCdecimal(4)noTC Base Amount DR. This field displays the debit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatBaseCreditTCdecimal(4)noTC Base Amount CR. This field displays the credit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatBaseDebitCCdecimal(4)noSC Base Amount DR. This field displays the debit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
CInvoiceVatBaseCreditCCdecimal(4)noSC Base Amount CR. This field displays the credit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
CInvoiceVatDebitLCdecimal(4)noBC Tax Amount DR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount DR and the Exchange rate.
CInvoiceVatCreditLCdecimal(4)noBC Tax Amount CR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount CR and the Exchange rate.
CInvoiceVatDebitTCdecimal(4)noTC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatCreditTCdecimal(4)noTC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatDebitCCdecimal(4)noBC Tax Amount DR. This field displays the debit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount DR and the SC rate.
CInvoiceVatCreditCCdecimal(4)noSC Tax Amount CR. This field displays the credit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount CR and the SC rate.
CInvoiceCITextcharacter(40)yesCIDescription. A brief description for the SI posting.
api annotation:This field defaults from the CInvoiceDescription.
CInvoiceMFTextcharacter(40)noMFDescription. A brief description for the Matching posting.
api annotation:This field defaults from the CInvoiceDescription.
CInvoiceBalanceDebitLCdecimal(4)noBC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
CInvoiceBalanceCreditLCdecimal(4)noBC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
CInvoiceBalanceDebitTCdecimal(4)noTC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in transaction currency.
CInvoiceBalanceCreditTCdecimal(4)noTC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
CInvoiceBalanceDebitCCdecimal(4)noSC Balance Amount DR. This field displays the sum of the debit amounts of all posting lines in statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
CInvoiceBalanceCreditCCdecimal(4)noBC Balance Amount CR. This field displays the sum of the credit amounts of all posting lines in transaction currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
CInvoiceCirecClosingDatedatenoSIREC Closing Date.This field displays the date on which the Unallocated Invoices account has been backed out for this invoice.
CInvoiceIsVatDelaylogicalnoTax Delay. This field indicates if the Taxes on purchase orders and supplier invoices or credit notes are delayed.
CInvoiceIsOpenlogicalnoOpen.This field indicates if the invoice has been completely paid.
This field is updated automatically when complete payment is confirmed.
This field is read-only.
api annotation:PartialUpdate = yes - defaults to true
CInvoiceIsSelectedlogicalnoSelected. This field indicates whether the invoice is included in a payment selection.
This field is read-only.
CInvoiceBalanceLCdecimal(4)noBC Balance. This field displays the sum of the debit and credit amounts of all posting lines in base currency.
This field is calculated by the system using the TC Balance and the Exchange rate.
CInvoiceBalanceTCdecimal(4)noBalance. This field displays the sum of the debit and credit amounts of all posting lines in transaction currency.
CInvoiceBalanceCCdecimal(4)noSC Balance. This field displays the sum of the debit and credit amounts of all posting lines in statutory currency.
This field is calculated by the system using the TC Balance and the SC rate.
CInvoiceClosingDatedatenoClosing Date. This field displays the date on which the open balance became zero.
CInvoiceIsLogisticMatchinglogicalyesReceiver Matching.This field indicates If the Receiver Matching function is enabled.
This field is calculated by the system using the invoice status code.
CInvoicePostingPeriodintegeryesGL Period.This field indicates the period when the invoice to be posted.
If this field is modified, the posting and tax dates are changed correspondingly.
api annotation:This field defaults to the period associated with the posting date.
CInvoicePostingYearintegeryesYear.This field indicates the accounting year for the invoice.
If you modify these fields, the posting and tax dates are changed correspondingly.
api annotation:This field defaults to the accounting year associated with the posting date.
CInvoicePostingYearPeriodintegeryesYear/Period. This field indicates the accounting year and period for the invoice.
If you modify these fields, the posting and tax dates are changed correspondingly.
api annotation:This field defaults to the accounting year and period associated with the posting date.
CInvoiceVatExchangeRatedecimal(10)noTax Exchange Rate. The exchange rate used to calculate the tax of the invoice.
The BC Tax amount is calculated using the Tax exchange rate.
CInvoiceVatRateScaledecimal(10)noTax Rate Scale. This field indicates the scale factor applying to the tax exchange rate in use for foreign currency payments.
CInvoiceIsTaxablelogicalyesTaxable. This field indicates if the invoice is taxable.
This field defaults to true if the supplier is taxable.
CInvoiceOwnVatNumbercharacter(40)noOwn Tax Number. This field displays the tax number for the entity in which you are working.
api annotation:The tax number defaults from the headoffice address of the business relation to which the entity is linked.
CInvoiceCreditorVatNumbercharacter(40)noSupplier Tax Number. This field indicates the tax number used by the supplier.
The value for this field is the State Tax ID of the headoffice address of the business relation associated with the supplier.
CInvoiceNonDiscAmtLCdecimal(4)noBC Non-discount Amount. This field display the invoice amount without discount in base currency.
This field is calculated by the system using the TC Non-discount Amount and the Exchange rate.
CInvoiceNonDiscAmtCCdecimal(4)noSC Non-discount Amount. This field display the invoice amount without discount in statutory currency.
This field is calculated by the system using the TC Non-discount Amount and the SC rate.
CInvoiceNonDiscAmtTCdecimal(4)noTC Non-discount Amount. This field display the invoice amount without discount in base currency.
CInvoiceNonRecTaxAmtTCdecimal(4)noNon-Rev Tax Amount. This field displays the percentage of tax that is not recoverable.
Taxes are recoverable whenever your company is eligible to offset a percentage of tax on purchases against tax collected on sales. Recoverable taxes are common in Europe.
CInvoiceHoldAmountTCdecimal(4)noTC Hold Amount. This field displays the amount of the invoice total that is not to be paid.
If this field is not blank, the hold amount is taken into account during payment processing.
Hold amounts must be:
For invoices or correction invoices: Less than the invoice total and greater than zero.
For credit notes or correction credit notes: Greater than the document total and less than zero.
The hold amount for a negative payment must always be set to zero.
CInvoicePoDomaincharacter(8)noPO Domain. This field indicates which domain the purchase order belongs to.
CInvoicePoNbrcharacter(8)noPO Number. This fields identifies the PO receipts which the invoice matches.
CInvoiceIsExternallogicalyesExternal. This field indicates if the daybook used is external.
This field is calculated by the system using the daybook code.
CInvoiceIsTaxConfirmedlogicalyesTax Confirmed. This field indicates if the taxes for the invoice have been confirmed and cannot be changed anymore.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceIsTaxExcludedlogicalyesTax Excluded.This field indicates if the amount specified for Invoice Amount excludes tax.
api annotation:This field defaults from the Customer Invoice Total Excludes Tax field in Global Tax Management Control.
CInvoiceIsWithBanklogicalyesWith Bank. This field indicates if the invoice has a supplier bank number specified for it.
api annotation:PartialUpdate = yes - defaults to true
CInvoiceIsDiscTaxAtInvlogicalyesDiscount Tax at Invoice.This field indicates if the invoice has a discount for tax.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceIsDiscTaxAtPaymlogicalyesDiscount Tax at Payment. This field indicates if the invoice has a discount for tax at the time of payment.
The discount amount at the time of payment only applies to the tax base amount.
api annotation:PartialUpdate = yes - defaults to false
CInvoiceIsInitialStatuslogicalyesInitial Status. This field indicates if the invoice is in initial status.
api annotation:This field defaults from the Initial Status field of the Invoice status code.
CInvoiceRegistrationNrintegeryesRegistration number. This field displays the sequential number assigned to each invoice upon initial entry in the system.
CInvoiceCreationDatedateyesCreation Date.This field indicates the invoice creation date.
Thid fields is read-only.
api annotation:Thid fields defautls from the system date.
CInvoiceCommentNotecharacter(2000)noComment. This field contains user's comment of the invoice.
CInvoiceBatchNumbercharacter(8)noBatch Number. This field is used to identify a group of supplier invoices created at one time using Evaluated Receipts Settlement (ERS) functions.
CInvoiceIsERSlogicalyesERS: This field indicates if the invoice is created using Evaluated Receipts Settlement (ERS) functions.
CInvoiceDayBookSetCodecharacter(8)noDaybook Set Code. This field indicates the daybook set you want to use to number the invoice.
This field defaults form:1. the daybook set associated with the supplier in Supplier Data Maintenance.
2. If you specified a PO number in the PO Number field, the daybook set on the PO overrides the daybook set on the supplier data record if they are different, and defaults instead.
3. If you specify more than one PO in the PO Number grid, the daybook set associated with the first PO defaults in. You can overwrite the default value.
CInvoiceSiteCodecharacter(8)noSite. The site for which you want to use specific invoice numbering. The default value is:1.The site associated with the supplier in Supplier Data Maintenance.
2. If you specified a PO in the PO Number grid, the site on the PO overrides the site on the supplier data record if they are different, and defaults instead.
3. If you specified more than one PO in the PO Number grid, the site associated with the first PO defaults in.
This field is blank if daybook sets by site is not activated.
CInvoiceIsWHTlogicalyesWithholding Tax
CInvoiceWHTTotAmtDebitTCdecimal(4)noTC WHT Total Amount (DR)
CInvoiceWHTTotAmtCreditTCdecimal(4)noTC WHT Total Amount (CR)
CInvoiceWHTBaseAmtDebitTCdecimal(4)noTC WHT Base Amount (DR)
CInvoiceWHTBaseAmtCreditTCdecimal(4)noTC WHT Base Amount (CR)
CInvoiceWHTTotAmtDebitLCdecimal(4)noBC WHT Total Amount (DR)
CInvoiceWHTTotAmtCreditLCdecimal(4)noBC WHT Total Amount (CR)
CInvoiceWHTBaseAmtDebitLCdecimal(4)noBC WHT Base Amount (DR)
CInvoiceWHTBaseAmtCreditLCdecimal(4)noBC WHT Base Amount (CR)
CInvoiceWHTTotAmtDebitCCdecimal(4)noSC WHT Total Amount (DR)
CInvoiceWHTTotAmtCreditCCdecimal(4)noSC WHT Total Amount (CR)
CInvoiceWHTBaseAmtDebitCCdecimal(4)noSC WHT Base Amount (DR)
CInvoiceWHTBaseAmtCreditCCdecimal(4)noSC WHT Base Amount (CR)
tcReasonAllocationStatuscharacter(20)noInvoice Status Code Allocation Status.This field indicates the allocation status defined for the invoice's status code.
This field is calculated using the invoice status code.
value list:{&REASONALLOCSTATUSS}
tcLocalCurrencyCodecharacter(3)noBase Currency. This fields inficates the base currency used by the invoice.
tcStatutoryCurrencyCodecharacter(3)noStatutory Currency. This field indicates the statutory currency used by the invoice.
tdCInvoiceOriginalTCdecimal(4)noOriginal TC Amount
if Type = Invoice => CInvoiceOriginalCreditTC
if Type = CreditNote => CInvoiceOriginalDebitTC
tdCInvoiceOriginalLCdecimal(4)noOriginal LC Amount
if Type = Invoice => CInvoiceOriginalCreditLC
if Type = CreditNote => CInvoiceOriginalDebitLC
tdCInvoiceOriginalCCdecimal(4)noOriginal CC Amount
if Type = Invoice => CInvoiceOriginalCreditCC
if Type = CreditNote => CInvoiceOriginalDebitCC
tdTotalAmountDebitTCdecimal(4)nototal debit amount in TC
=>sum of the CInvoiceVatBaseDebitTC and CInvoiceVatDebitTC
tdTotalAmountCreditTCdecimal(4)nototal credit amount in TC
=>sum of the CInvoiceVatBaseCreditTC and CInvoiceVatCreditTC
tcCAJournalCodecharacter(20)noAdjustment. The Journal Code for the Creditor Adjustment Posting.
tiCAVoucherintegernoSA Voucher. Voucher of Creditor Adjusment Posting.
tcMFJournalCodecharacter(20)noDaybook. The Daybook code of the Matching Daybook used for this invoice.
This field is Calculated by the system.
tcPaymentMeansTranslatedcharacter(20)noPayment Instrument. This field displays the payment instrument defined for payments to this supplier from your bank account.
tdCInvoiceVatBaseTCdecimal(4)noTC Tax Base Amount
if Type = Invoice => CInvoiceVatBaseCreditTC
if Type = CreditNote => CInvoiceVatBaseDebitTC
tdCInvoiceVatBaseLCdecimal(4)noBC Tax Base Amount
if Type = Invoice => CInvoiceVatBaseCreditBC
if Type = CreditNote => CInvoiceVatBaseDebitBC
tcNormalPaymentConditionTypecharacter(20)noCredit Terms. The credit terms that apply to this invoice. Credit terms determine invoice due dates and any settlement discounts on early payments. Credit terms also determine if multiple payments are made in stages based on invoice percentages.
api annotation:This field defaults from the credit term type of the supplier record accosiated with the invoice.
tiVatCurrencyNumDecintegernoTax Currency Number of Decimals. This field displays the deciamls of the tax currency used by the invoice.
tlCreditorIsTaxReportlogicalnoTax Report. This field indicates if the supplier of the invoice authorize generation of a supplier tax activity (1099) report.
This field is calculated by the system using the supplier code.
tcOwnVatNumberCountryCodecharacter(20)noOwn Tax Number Country Code. This field indicates the tax number Country for the entity in which you are working.
This field is calculated by the system according to the Own Tax Number.
tcCredVatNumberCountryCodecharacter(20)noSupplier Tax Number Country Code. This field indicates the tax number Country of the supplier.
This field is calculated by the system according to the supplier Tax Number.
tcCInvoiceNumbercharacter(50)noInvoice Number. The system generate invoice number based on the daybook code.
tdCInvoiceOriginalAmountdecimal(2)noTC Original Amt. Calculated field for the original amount.
tdCInvoiceOpenAmountdecimal(2)noTC Open Amt.Open amount is the total amount of the open item minus any credit to be applied(TC).
This field is calculated by the system.
tiOverdueDaysintegernoOverdue Days. The overdue days are determined using the credit terms, as of date, and grace days you apply to this finance charge.
This field is calculated by the system.
tcShipToTaxZonecharacter(16)noTax Zone. The ship-to tax zone from the purchase order line site.
This field is calculated by the system according to the ship-to address.
tlShipToAddressIsTaxInCitylogicalnoTax in City. This field indicates if the ship-to address from the purchase order line site is Tax in city.
This field is calculated by the system according to the ship-to address.
tdCInvoiceOriginalAmountLCdecimal(2)noBC Original Amount
if Type = Invoice => CInvoiceOriginalCreditBC
if Type = CreditNote => CInvoiceOriginalDebitBC
tdCInvoiceOpenAmountLCdecimal(2)noBC Open Amt.Open amount is the total amount of the open item minus any credit to be applied(BC).
This field is calculated by the system using the tdCInvoiceOpenAmountTC.
tlCInvoiceIsReferencedlogicalnoReferenced. This field indicates if other invoices have linked to this invoice.
This field is calculated by the system.
tlShipToCountryIsEUCountrylogicalnoShip-To is an EU Country. This field indicates if the supplier's Ship-To address is in EU country.
This field is calculated by the system according to the ship-to address.
tiShipToAddressIdintegerno
tiBusinessRelation_IDintegeryes
tcCreditorCodecharacter(8)yesSupplier Code. The code that identifies the supplier to be paid with this invoice.
This field is calculated by the system.
tcBusinessRelationCodecharacter(20)yesBusiness Relation.The business relation code linked to the supplier.
This field is calculated by the system using the supplier code.
tcBusinessRelationName1character(36)yesBusiness Relation Name. Calculated field displays the business relation name linked to the supplier.
tcDivisionCodecharacter(8)noSub-Account Code. This field displays the code of sub-account if the supplier control account is defined with sub-account analysis.
This sub-account applies to all invoice posting lines.
This field can be blank.
tcJournalCodecharacter(8)yesDaybook Code. This field identifies an internal daybook that matches the invoice type: supplier invoice, invoice correction, credit note, or credit note correction.
This field is calculated by the system.
tcCurrencyCodecharacter(3)yesCurrency Code.This filed identifies the currency of the invoice amount entered by the user.
tcReasonCodecharacter(20)yesInvoice Status Code. This field determines the approval, payment, and allocation status of the invoice.
This field is calculated by the system.
api annotation:The initial code defaults from the supplier record.
CInvoiceCreationTimeStringcharacter(10)noSeconds since midnight in HH:MM:SS
tcNormalPaymentConditionCodecharacter(8)yesCredit Terms Code. The calculated code identifies the credit terms that apply to this invoice.
When the credit terms code is changed, the invoice due date is recalculated.
api annotation:Credit terms code defaults from the credit term of the supplier record.
CInvoiceInvCertCertificatecharacter(16)noDuplicate field from SysProperty
tcBLWIGroupCodecharacter(20)noBLWI Group. This field identifies a BLWI group for the subject of this invoice, if valid.
The BLWI status applies to certain trade transactions for organizations in Belgium and Luxemburg only.
CInvoiceInvCertVersioncharacter(8)noVersion of the Certificate
tcTransactionStartCountryCodecharacter(3)noTransactionStart Country Code. This field identifies the start country of the transaction.
This field is calculated by the system.
CInvoiceInvCertKeycharacter(128)noInvoice Certification Key
tcTransactionEndCountryCodecharacter(3)noTransactionEnd Country Code. This field identifies the end country of the transaction.
This field is calculated by the system.
CInvoiceInvCertSignatureCurrcharacter(256)noSignature Current Invoice
tcProjectCodecharacter(8)noProject. The project to which this invoice is to be posted.
CInvoiceInvCertSignaturePrevcharacter(256)noSignature Previous Invoice
tcCostCentreCodecharacter(4)noCost Center Code. The cost center to which this invoice is to be posted.
CInvoiceInvCertSignatureShortcharacter(4)no4-character signature based upon the content of DInvoiceInvCertSignatureCurr
tcRoleNamecharacter(20)noRole Name. This field ensures that approval workflow is applied to the supplier invoice, with an approval request sent to the specified role.
This field is not blank only when automatic ad-hoc workflow is enabled and the Specific SI Approval field is selected in the Maintain System function.
This field is calculated by the system.
tcVatCurrencyCodecharacter(3)noCurrency Code.This field identifies the currency used by the invoice for tax use.
This field is calculated by the system.
tcShipToAddressCitycharacter(30)noCity. The city for the ship-to address.
This field is calculated by the system using the ship-to address city.
tcShipToAddressStatecharacter(20)noState. The state or province for the ship-to address.
This field is calculated by the system using the ship-to address.
tcShipToAddressStreet1character(36)noAddress: Line one of the ship-to address details.
tcShipToAddressStreet2character(36)noAddress: Line two of the ship-to address details.
This field can be blank.
tcShipToAddressStreet3character(36)noAddress: Line three of the ship-to address details.
This field can be blank.
tcShipToAddressTypeCodecharacter(20)noAddress Type: A code that identifies the type of the ship-to address.
This field is calculated by the system.
tcShipToAddressZipcharacter(10)noZip. The postal code or US zip code associated with the ship-to address.
This field is calculated by the system.
tcShipToBusinessRelationCodecharacter(20)noBusiness Relation. This field identifies the Business relation of the ship-to address.
This field is calculated by the system according to the ship-to address.
tcShipToCountryCodecharacter(3)noCounty Code. This field identifies the county for the ship-to address.
This field is calculate by the system.
tcPurchaseTypeCodecharacter(4)noPurchase Type. The Purchase type of the invoice.
Purchase types group invoices together for reporting, letting you track your cash expenditures for different types of expenses.
This field can be blank.
tcControlGLCodecharacter(8)yesAccount.This field identifies the supplier control GL account.
This field is calculated by the system according to the supplier.
tlShipFromCountryIsEUCountrylogicalnoShip-From is an EU Country. This field indicates if the Ship-From address is in EU country.
This field is calculated by the system.
tlControlGLIsDivisionAccountlogicalnoDivision Account. This filed indicates if the supplier control account is defined with sub-account analysis.
This field is calculated by the system.
tlCInvoiceIsReverseBySignlogicalnotlCInvoiceIsReverseBySign. Calculated field for reversing invoices. Depending on a setup parameter in the AP control file, invoices are reversed with negative debits or credits instead of swtiching debit to credit and credit to debit.
tcShipFromTaxClasscharacternoShip From Tax Class. The tax class of the Ship-From business relation, which is associated with the current entity.
This field is calculated by the system according to the supplier record.
tcShipFromTaxUsagecharacter(8)noShip From Tax Usage. The tax Usage of the Ship-From business relation, which is associated with the current entity.
This field is calculated by the system according to the supplier record.
tcShipFromTaxZonecharacternoShip From Tax Zone. Calculated field identifies the tax zone of the Ship-From business relation, which is associated with the current entity.
tcShipFromCountryCodecharacternoShip From Country Code.This field idetifies the country of the Ship-From business relation, which is associated with the current entity.
This field is calculated by the system.
tcCInvoiceReference1character(22)noReference. The reference of other invoice linked to this invoices.
This field is calculated by the system according to the linked invoice.
tiLinkedCInvoiceVoucherintegernoVoucher. The numeric identifier assigned to the posting linked to this invoice.
This field is calculated by the system according to the linked invoice.
tcLinkedJournalCodecharacter(8)noDaybook Code.This field identifies the daybook of other invoice linked to this invoices.
This field is calculated by the system according to the linked invoice.
tiLinkedPeriodYearintegernoGL Calendar Year. The GL Calendar Year of other invoice linked to this invoices.
This field is calculated by the system according to the linked invoice.
tlDaybookOnInvoicelogicalnoDaybookOnInvoice. This field indicates whether or not the user can update the Daybook field on the UI. If it is true the field is editable if not then it is disabled.
This field is calculated by the system.
tcCInvoiceReferenceDuplicatecharacternoCalculated field with the concatenated string holding following fields pipe-delimited:
o iiCompanyID
o icCreditorCode
o icCInvoiceType
o icCInvoiceReference
o ilCInvoiceIsInitialStatus
This is used to make sure we do only once get a warning in case we enter an invoice with a reference that already exists.
tlCInvoiceIsForLegalDoclogicalno
tiShipFromAddressIdintegerno
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
CustomShort10character(20)noCustom Short Field
CustomShort11character(20)noCustom Short Field
CustomShort12character(20)noCustom Short Field
CustomShort13character(20)noCustom Short Field
CustomShort14character(20)noCustom Short Field
CustomShort15character(20)noCustom Short Field
CustomShort16character(20)noCustom Short Field
CustomShort17character(20)noCustom Short Field
CustomShort18character(20)noCustom Short Field
CustomShort19character(20)noCustom Short Field
CustomCombo10character(20)noCustom Combo Field
CustomCombo11character(20)noCustom Combo Field
CustomCombo12character(20)noCustom Combo Field
CustomCombo13character(20)noCustom Combo Field
CustomCombo14character(20)noCustom Combo Field
CustomDecimal5decimal(4)noCustom Decimal Field
CustomDecimal6decimal(4)noCustom Decimal Field
CustomDecimal7decimal(4)noCustom Decimal Field
CustomDecimal8decimal(4)noCustom Decimal Field
CustomDecimal9decimal(4)noCustom Decimal Field
CustomDecimal10decimal(4)noCustom Decimal Field
CustomDecimal11decimal(4)noCustom Decimal Field
CustomDecimal12decimal(4)noCustom Decimal Field
CustomDecimal13decimal(4)noCustom Decimal Field
CustomDecimal14decimal(4)noCustom Decimal Field
CustomDate5datenoCustom Date Field
CustomDate6datenoCustom Date Field
CustomDate7datenoCustom Date Field
CustomDate8datenoCustom Date Field
CustomDate9datenoCustom Date Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacternoempty string
tc_Statuscharacternoupdate status

table tCInvoiceBank

Description

Supplier Invoice: Bank Records

field namedata typemnd.description
CInvoiceBank_IDintegeryesRecord ID
CInvoice_IDintegeryesLink to CInvoice
BankNumber_IDintegeryesBank Number
CInvoiceBankToPayTCdecimal(4)noTC Payment Amount. This field displays the payment amount in the transaction currency.
tcOwnBankNumbercharacter(20)noOwn Bank Number. This field displays the account number that receives payments from this customer.
This number is defined on the supplier record, and is normally the default bank account number for the entity you are currently working in.
tcPayFormatTypeCodecharacter(20)noPayment Format. The payment format you have defined for payments from your bank to this supplier.
The value of the field can only be the formats initially defined for the account.
This field is calculated by the system.
tcPayFormatTypePayInstrumentcharacter(20)noPayment Instrument. The payment instrument defined for payments to this supplier from your bank account.
This field is calculated by the system.
tiBankPayFormat_IDintegerno
tlValidatePaymentlogicalnoValidate Payment: This field validate the payment when the cinvoicebank amount is changed : when you come from payment selection it is false, otherwise true.
tcBankNumbercharacter(40)yesBank Number. The supplier bank account number. This field is mandatory when the payment instrument for the supplier is electronic.
This field is calculated by the system.
tcBankNumberExtensioncharacter(20)yesExtension. This field indicates the bank number extension. The extension defines the currency when an account has amounts in multiple currencies.
This field is calculated by the system.
tcBankNumberFormattedcharacter(40)yesFormatted Number. This field displays the supplier bank account number, formatted according to the validation you applied.
This field is calculated by the system.
tcBankNumberSwiftCodecharacter(40)yesSWIFT Code. This field displays the SWIFT code of the bank.
SWIFT (the Society for Worldwide Interbank Financial Telecommunication) is a banking network for world-wide payments between banks. Also known as the BIC or Bank Identifier Code.
This field is calculated by the system and can be blank.
tcBankNumberValidationcharacter(20)yesValidation. This field identifies the bank format validation for the supplier bank account.
Account number validation ensures that the account number is formatted according to the regulations of the national banking system.
This field is calculated by the system.
tcBusinessRelationCodecharacter(20)yesBusiness Relation Code. This field displays the business relation for the supplier's bank, and contains bank addressing information.
This field is calculated by the system.
tiParentObject_IDintegeryes
tcOwnGLCodecharacter(20)noOwn Gl Account.The default supplier bank account configured for the supplier.
If you have configured multiple accounts for this supplier, you can add these account details by inserting a new row for each account. You can use a maximum of three bank accounts to make the invoice payment,specifying the bank reference and amounts to be paid per account in each case. The total of the separate amounts must equal the total invoice amount.
This field is calculated by the system.
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tCInvoice.tc_Rowid
tc_Statuscharacternoupdate status

table tCInvoiceBankPayCode


field namedata typemnd.description
CInvoiceBankPayCode_IDintegeryesRecord ID
CInvoiceBank_IDintegeryesLink to CInvoiceBank
PayFormatCode_IDintegernoLink to PayFormatCode
PayFormatGroup_IDintegernoLink to PayFormatGroup
CInvoiceBankPayCodeValuecharacter(40)noAttribute Value. A new attribute of the payment Format.
This field is added by the user for bank payment.
api annotation:This field defaults from the value user set in the payment maintance.
tcPayFormatGroupCodecharacter(20)noPayFormat Attribute level. This field indicates which level the new attributes belongs to.
tlPayFormatGroupIsMandatorylogicalnoMandatory. This field indicates if the new field added by the user is mandatory for input.
tcPayFormatGroupDataTypecharacter(20)noData Type. This field indicates the data type of the attribute added by the user.
tcPayFormatGroupInputOptioncharacter(20)noInput Option. This field indicates if a payment attribute value can be entered manually (editable) or has to be selected from a list (selectable).
tcPayFormatGroupDescriptioncharacter(20)noAttribute Name Description. This field displays the description of the Attribute added by the user.
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tCInvoiceBank.tc_Rowid
tc_Statuscharacternoupdate status

table tCInvoiceMovement

Description

Supplier Invoice: Movement records

field namedata typemnd.description
CInvoiceMovement_IDintegeryesRecord ID
CInvoice_IDintegeryesLink to CInvoice
PostingLine_IDintegeryesLink to PostingLine
Company_IDintegernoLink to Company
Period_IDintegernoLink to Period
Creditor_IDintegernoLink to Creditor
CInvoiceMovementTypecharacter(20)yesCInvoiceMovementType. "Initial" indicates that the movement represents the initial creation of the invoice, "movement" stands for all subsequent modifications of the invoice balance (payments, adjustments etc).
value list:{&MOVEMENTTYPES}
CInvoiceMovementYearPeriodintegernoYear/GL Period. This field indicates the accounting year and period for the invoice's movement.
CInvoiceMovementDiscountTCdecimal(4)noCInvoiceMovementDiscountTC. The amount of payment discount in TC.
CInvoiceMovementPostDatedatenoPosting Date. The Posting Date of the Invoice's movement.
CInvoiceMovementIsForDraftlogicalyesFor Draft. This field indicates if the invoice is for draft use.
The invoice is initially saved as a draft. Draft invoices do not generate postings when saved, and so do not affect the AP sub-ledger or general ledger.
tcWHTPostingLineIDscharacternoWHT Posting Line IDs : comma separated list of wht posting line id's, we need that for rolling back everything. for example, when you get error at moment of save of banking entry, then the wht posting lines must be rolled back automatically. method GetPostingInfoOfInstance will be extended
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tCInvoice.tc_Rowid
tc_Statuscharacternoupdate status

table tCInvoicePO


field namedata typemnd.description
CInvoicePO_IDintegeryesRecord ID
CInvoice_IDintegeryesLink to CInvoice
CInvoicePOPoDomaincharacter(8)yesPO Domain. This field indicates which domain the purchase order belongs to.
CInvoicePOPoNbrcharacter(8)yesPO Number. This fields identifies the PO receipts which the invoice matches.
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tCInvoice.tc_Rowid
tc_Statuscharacternoupdate status

table tCInvoicePosting

API annotation

This table can be removed if integrating without Journal Entry, if the integration is BCInvoiceJournalEntry, this table links to the posting records in the JournalEntry component.

Description

Link Creditor Invoice - Posting.

field namedata typemnd.description
CInvoicePosting_IDintegeryesRecord ID
CInvoice_IDintegeryesLink to CInvoice
CIRECPostingLine_IDintegeryesLink to PostingLine
Posting_IDintegeryesLink to Posting
CInvoicePostingTypecharacter(20)noInvoice Type. This field displays the invoice type.
Invoice Correction and Credit Note Correction display as choices only when the appropriate daybook types have already been defined.
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tCInvoice.tc_Rowid
tc_Statuscharacternoupdate status

table tCInvoiceStage


field namedata typemnd.description
CInvoiceStage_IDintegeryesRecord ID
CInvoice_IDintegeryesLink to CInvoice
PaymentConditionStaged_IDintegernoDiscount Percentage
CInvoiceStageDueDatedateyesDue Date. The date when this stage should end.
CInvoiceStagePercentdecimal(10)noCInvoiceStagePercent Staged payments credit terms details of the invoice. The percentage of the invoice total that this stage stands for.
CInvoiceStageAmountTCdecimal(4)yesCInvoiceStageAmountTC Staged payments credit terms details of the invoice. The amount to pay in TC for this stage.
CInvoiceStageAmountLCdecimal(4)yesCInvoiceStageAmountBC Staged payments credit terms details of the invoice. The amount to pay in BC for this stage.
CInvoiceStageAmountCCdecimal(4)noCInvoiceStageAmountSC Staged payments credit terms details of the invoice. The amount to pay in SC for this stage.
CInvoiceStageAmtAppliedTCdecimal(4)noCInvoiceStageAmtAppliedTC Staged payments credit terms details of the invoice. The amount paid in TC for this stage.
CInvoiceStageDiscDatedatenoCInvoiceDiscDate Payment discount due date. When the invoice is paid before this date a payment discount can be given.
CInvoiceStageDiscPercdecimal(3)noCInvoiceDiscPerc Payment discount percent. When the invoice is paid before the discount due date, this is the discount percentage that can be given.
CInvoiceStageTSMNumbercharacter(60)noPayment Reference
tcPaymentConditionCodecharacter(8)noCredit Terms Code. This field idetifies the Credit Term used in this stage.
tcPaymentConditionDescriptcharacter(40)noDescription. This field displays the description of the Credit Term used in this stage.
tdPaymentConditionPercentagedecimal(3)noDiscount Percentage. This field indicates the discount rate used in the stage.
This field is calculated using the Credit Term.
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tCInvoice.tc_Rowid
tc_Statuscharacternoupdate status

table tCInvoiceVat

Description

CInvoiceVat - Supplier Invoice: Tax Records

field namedata typemnd.description
CInvoiceVat_IDintegeryesRecord ID
CInvoice_IDintegeryesLink to CInvoice
Vat_IDintegernoDomain
NormalTaxGL_IDintegernoNormal Tax Account
NormalTaxDivision_IDintegernoNormal Tax Sub-Account
AbsRetTaxGL_IDintegernoRetained Tax Account
AbsRetTaxDivision_IDintegernoRetained Tax Sub-Account
SuspDelTaxGL_IDintegernoDelayed Tax Account
SuspDelTaxDivision_IDintegernoDelayed Tax Sub-Account
PostingVat_IDintegernoLink to PostingVat
CInvoiceVatVatBaseDebitLCdecimal(4)noBC Base Amount DR. This field displays the debit base amount in the base currency.
This field is calculated by the system using the TC Base Amount DR and the Exchange rate.
CInvoiceVatVatBaseCreditLCdecimal(4)noBC Base Amount CR. This field displays the credit base amount in the base currency.
This field is calculated by the system using the TC Base Amount CR and the Exchange rate.
CInvoiceVatVatBaseDebitTCdecimal(4)noTC Base Amount DR. This field displays the debit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatBaseCreditTCdecimal(4)noTC Base Amount CR. This field displays the credit base amount in the transaction currency.
This field is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatBaseDebitCCdecimal(4)noSC Base Amount DR. This field displays the debit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount DR and the SC rate.
CInvoiceVatVatBaseCreditCCdecimal(4)noSC Base Amount CR. This field displays the credit base amount in the statutory currency.
This field is calculated by the system using the TC Base Amount CR and the SC rate.
CInvoiceVatVatDebitLCdecimal(4)noBC Tax Amount DR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount DR and the Exchange rate.
CInvoiceVatVatCreditLCdecimal(4)noBC Tax Amount CR. This field displays the debit tax amount in the base currency.
This field is calculated by the system using the TC Tax Amount CR and the Exchange rate.
CInvoiceVatVatDebitTCdecimal(4)noTC Tax Amount DR. This field displays the debit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatCreditTCdecimal(4)noTC Tax Amount CR. This field displays the credit tax amount (TC) calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatVatDebitCCdecimal(4)noSC Tax Amount DR. This field displays the debit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount DR and the SC rate.
CInvoiceVatVatCreditCCdecimal(4)noSC Tax Amount CR. This field displays the credit tax amount in the statutory currency.
This field is calculated by the system using the TC Tax Amount CR and the SC rate.
CInvoiceVatIsTaxablelogicalyesTaxable. This field indicates if the invoice is taxable.
This field defaults to true if the supplier is taxable.
CInvoiceVatNonRecTaxAmtTCdecimal(4)noNon-Rev Tax Amount. This field displays the percentage of tax that is not recoverable.
Taxes are recoverable whenever your company is eligible to offset a percentage of tax on purchases against tax collected on sales. Recoverable taxes are common in Europe.
CInvoiceVatIsUpdAllowlogicalyesUpdate Tax Allowed. When this is field is true, you can modify the base and tax credit and debit amounts during transaction entry.
This field is useful for overriding the system if there is a need to match amounts on manually issued documents. In some environments, tax authorities require that you cannot modify the calculated tax amounts.
CInvoiceVatIsAbsRetlogicalyesRetained. This field indicates that the tax rate in use has been configured to retain taxes for payment directly to the government.
CInvoiceVatIsAccrRcpUslogicalyesCInvoiceVatIsAccrRcpUS Tax is accrued at receipt. This is a parameter of the tax rate code in GTM.
CInvoiceVatTaxTrTypecharacter(2)noCInvoiceVatTaxTrType Tax transaction type. This is a parameter of the tax rate code in GTM.
CInvoiceVatIsRevChargelogicalyesCInvoiceIsRevCharge.This field indicates if the invoice tax is of type Reverse Charge.
CInvoiceVatUILinkedRowIDcharacter(30)noLinked Row
CInvoiceVatSequenceintegernoCInvoceVatSequence.The sequentiel number of the tax line on the invoice.
CInvoiceVatNTBaseDebitTCdecimal(4)noTC Base Debit Non-taxable. This field displays the Non-taxable debit base amount in the transaction currency.
This is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatNTBaseCreditTCdecimal(4)noTC Base Credit Non-taxable. This field displays the Non-taxable credit base amount in the transaction currency.
This is calculated by the system using the total invoice amount (TC) and the applicable tax rate code.
CInvoiceVatIsSuspDellogicalyesCInvoiceVatIsSuspDel Tax line is for Suspended or Delayed tax. This is a parameter of the tax rate code in GTM.
CInvoiceVatSuspDelTaxAmtTCdecimal(4)noTax Amount on Delayed Account TC. This field display the tax amount in the delayed account of the invoice in Transaction currency.
TxuTaxUsagecharacter(8)noTax Usage. These fields default from the supplier, and can be modified.
TxenvTaxEnvcharacter(16)noTax Environment. This field is automatically calculated based on the supplier and ship-to address details, and can be modified.
TxclTaxClscharacter(3)noTax Class. This field default from the supplier, and can be modified.
TxtyTaxTypecharacter(16)noTax Type. This field displays the tax type, which defaults from the tax environment.
tdCInvoiceVatVatBaseDebitVCdecimal(4)noObsolete field.
tdCInvoiceVatVatBaseCreditVCdecimal(4)noObsolete field.
tdCInvoiceVatVatDebitVCdecimal(4)noObsolete field.
tdCInvoiceVatVatCreditVCdecimal(4)noObsolete field.
tlIsRecalculateTaxlogicalnoRecalc. When you change the tax class, tax usage, tax environment, or the Taxable fields or modify one of the base amounts, this field is automatically set to true,and the system recalculates the amounts when you have completed the line in the grid. You can also manually set this field to true or false.
tcDomainCodecharacter(8)noDomain. This field displays the doamin of the invoice (the current domain).
tcVatInOutcharacter(20)notcVatInOut Indication if the tax in Input (tax on purchases) or Output (tax on sales).
tcVatCodecharacter(20)noTax Code. This field displays the code of the tax rate, based on the tax environment for the combination of supplier and ship-to address.
tcNormalTaxGLCodecharacter(8)noNormal Tax Account. This field indicates the Gl account for tax use.
The Tax accounts are defined for the current domain in Domain/Account Control.
tcNormalTaxDivisionCodecharacter(8)noNormal Tax Sub-Account. This field indicates the sub-account if the supplier control account is defined with sub-account analysis.
tcAbsRetTaxGLCodecharacter(8)noRetained Tax Account. This field indicates the GL account used to retain the tax.
When you have selected the Retained/Absorbed options.
This field is defined in Tax Rate Maintenance.
tcAbsRetTaxDivisionCodecharacter(8)noRetained Tax Sub-Account.This field indicates the sub- Account used to retain the tax.
When you have selected the Retained/Absorbed options.
This field is defined in Tax Rate Maintenance.
tcSuspDelTaxGLCodecharacter(8)noDelayed Tax Account. This field indicates the GL account used to handle the delayed tax.
tcSuspDelTaxDivisionCodecharacter(8)noDelayed Tax Sub-Account. This field indicates the sub-account used to handle the delayed tax.
tlTx2InvDisclogicalnoDiscount invoice at Invoice?
tdCInvoiceVatExchangeRateCCdecimal(10)noSC Exchange Rate
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tCInvoice.tc_Rowid
tc_Statuscharacternoupdate status

table tCInvoiceWHT


field namedata typemnd.description
CInvoiceWHT_IDintegeryesRecord ID
CInvoice_IDintegeryesLink to CInvoice
Vat_IDintegernoLink to Vat
GL_IDintegernoLink to GL
Division_IDintegernoLink to Division
CInvoiceVat_IDintegernoLink To CInvoiceVat
CInvoiceWHTFeeDebitTCdecimal(4)noTC Fee (DR)
CInvoiceWHTFeeCreditTCdecimal(4)noTC Fee (CR)
CInvoiceWHTExpenseDebitTCdecimal(4)noTC Expense (DR)
CInvoiceWHTExpenseCreditTCdecimal(4)noTC Expense (CR)
CInvoiceWHTTaxFeeDebitTCdecimal(4)noTC Taxable Fee (DR)
CInvoiceWHTTaxFeeCreditTCdecimal(4)noTC Taxable Fee (CR)
CInvoiceWHTTaxFeeDebitCCdecimal(4)noSC Taxable Fee (DR)
CInvoiceWHTTaxFeeCreditCCdecimal(4)noSC Taxable Fee (CR)
CInvoiceWHTTaxFeeDebitLCdecimal(4)noBC Taxable Fee (DR)
CInvoiceWHTTaxFeeCreditLCdecimal(4)noBC Taxable Fee (CR)
CInvoiceWHTAmtDebitTCdecimal(4)noTC WHT Amount (DR)
CInvoiceWHTAmtCreditTCdecimal(4)noTC WHT Amount (CR)
CInvoiceWHTAmtDebitCCdecimal(4)noSC WHT Amount (DR)
CInvoiceWHTAmtCreditCCdecimal(4)noSC WHT Amount (CR)
CInvoiceWHTAmtDebitLCdecimal(4)noBC WHT Amount (DR)
CInvoiceWHTAmtCreditLCdecimal(4)noBC WHT Amount (CR)
CInvoiceWHTTaxPctdecimal(2)noTax Percentage
CInvoiceWHTRecovTaxPctdecimal(2)noObsolete - Recoverable Tax Percentage
CInvoiceWHTTaxTypecharacter(20)noTax Type
CInvoiceWHTTaxTrTypecharacter(2)noTransaction Type
CInvoiceWHTIsUpdAllowlogicalyesUpdate Tax Allowed
CInvoiceWHTIsOrigFromAPMlogicalyesOriginated From Receiver Matching
CInvoiceWHTBaseTaxPctdecimal(2)noTax Base Percentage
tcVatCodecharacter(20)no
tcDomainCodecharacter(8)no
tcVatInOutcharacter(20)no
tcVatDescriptioncharacter(40)no
tctx2Desccharacter(24)noTax Rate Description
tdtx2TaxPctdecimal(2)no
tdtx2PctRecvdecimal(2)noTax Percentage Recoverable
tctx2TaxTypecharacter(20)noTax Type
tcGLCodecharacter(8)no
tcDivisionCodecharacter(8)no
CustomShort0character(20)noCustom Short Field
CustomShort1character(20)noCustom Short Field
CustomShort2character(20)noCustom Short Field
CustomShort3character(20)noCustom Short Field
CustomShort4character(20)noCustom Short Field
CustomShort5character(20)noCustom Short Field
CustomShort6character(20)noCustom Short Field
CustomShort7character(20)noCustom Short Field
CustomShort8character(20)noCustom Short Field
CustomShort9character(20)noCustom Short Field
CustomCombo0character(20)noCustom Combo Field
CustomCombo1character(20)noCustom Combo Field
CustomCombo2character(20)noCustom Combo Field
CustomCombo3character(20)noCustom Combo Field
CustomCombo4character(20)noCustom Combo Field
CustomCombo5character(20)noCustom Combo Field
CustomCombo6character(20)noCustom Combo Field
CustomCombo7character(20)noCustom Combo Field
CustomCombo8character(20)noCustom Combo Field
CustomCombo9character(20)noCustom Combo Field
CustomLong0character(255)noCustom Long Field
CustomLong1character(255)noCustom Long Field
CustomNotecharacter(2000)noCustom Note Field
CustomDate0datenoCustom Date Field
CustomDate1datenoCustom Date Field
CustomDate2datenoCustom Date Field
CustomDate3datenoCustom Date Field
CustomDate4datenoCustom Date Field
CustomInteger0integernoCustom Integer Field
CustomInteger1integernoCustom Integer Field
CustomInteger2integernoCustom Integer Field
CustomInteger3integernoCustom Integer Field
CustomInteger4integernoCustom Integer Field
CustomDecimal0decimal(4)noCustom Decimal Field
CustomDecimal1decimal(4)noCustom Decimal Field
CustomDecimal2decimal(4)noCustom Decimal Field
CustomDecimal3decimal(4)noCustom Decimal Field
CustomDecimal4decimal(4)noCustom Decimal Field
LastModifiedDatedatenoLast Modified Date
LastModifiedTimeintegernoLast Modified Time
LastModifiedUsercharacter(20)noLast Modified User
QADC01character(40)nounused QAD reserved field
QADC02characternounused QAD reserved field
QADT01datenounused QAD reserved field
QADD01decimal(10)nounused QAD reserved field
tc_Rowidcharacteryesprimary index
tc_ParentRowidcharacteryes = tCInvoice.tc_Rowid
tc_Statuscharacternoupdate status

table tCustomTable0

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable1

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter

table tCustomTable2

Description

Empty table intended for non-intrusive customization only

field namedata typedescription
tcCustomShort0character
tcCustomShort1character
tcCustomShort2character
tcCustomShort3character
tcCustomShort4character
tcCustomShort5character
tcCustomShort6character
tcCustomShort7character
tcCustomShort8character
tcCustomShort9character
tcCustomCombo0character
tcCustomCombo1character
tcCustomCombo2character
tcCustomCombo3character
tcCustomCombo4character
tcCustomCombo5character
tcCustomCombo6character
tcCustomCombo7character
tcCustomCombo8character
tcCustomCombo9character
tcCustomLong0character
tcCustomLong1character
tcCustomNotecharacter
ttCustomDate0date
ttCustomDate1date
ttCustomDate2date
ttCustomDate3date
ttCustomDate4date
tiCustomInteger0integer
tiCustomInteger1integer
tiCustomInteger2integer
tiCustomInteger3integer
tiCustomInteger4integer
tdCustomDecimal0decimal(4)
tdCustomDecimal1decimal(4)
tdCustomDecimal2decimal(4)
tdCustomDecimal3decimal(4)
tdCustomDecimal4decimal(4)
tc_RowidcharacterUse this data item to add as a field in public temp-tables (with index).
tc_ParentRowidcharacter
tc_Statuscharacter