| field name | data type | description |
|---|---|---|
| DDocumentInvoiceXref_ID | integer | |
| DDocument_ID | integer | |
| DInvoice_ID | integer | |
| DDocumentInvoiceXrefAlloTC | decimal(4) | TC Allocated Amount. This field indicates the invocie amount already Allocated in transaction currency. |
| DDocumentInvoiceXrefDiscTC | decimal(4) | TC Discount Amount. This field indicates the discount amount of the invoice already allocated by transaction currency. |
| DDocumentInvoiceXrefIntTC | decimal(4) | |
| DDocumentInvoiceXrefPaidAmtTC | decimal(4) | |
| tcAllocAmountCrDt | character | AllocateAmountCrDt. This field indicates that the payment is a credit or debit. |
| tcBusinessRelationCode | character | Business Relation.The business relation code linked to the customer. This field is calculated by the system using the customer code. |
| tcDInvoiceBalanceCrDt | character | Invoice Balance DR/CR. This field indicates that the customer invocie is a credit or debit before the payment. |
| tcDInvoiceReference | character | Reference. An alphanumeric reference to help identify the invoice in the system. This reference is typically the ID number of the invoice received from the customer. |
| tcShipperCode | character | Shipper. A shipper number to select invoices related to a specific shipment. This field applies to automatically created salesrelated invoices. |
| tcDInvoiceType | character | Invoice Type. This field identifies the invoice type. |
| tcCompanyCode | character | Entity Code. This field identifies the entity of the invocie. |
| tcCurrencyCode | character | Currency Code.This filed identifies the currency used by the customer invoice. |
| tcNewBalanceCrDt | character | New Invoice Balance DR/CR. This field indicates that the customer invocie is a credit or debit after the payment. |
| tdDInvoiceBalance | decimal(4) | Invoice Balance. This field holds the balance of the customer invoice before the payment. |
| tdDiscountPercentage | decimal(2) | Discount Percentage. When the invoice is paid before the discount due date, this is the discount percentage that can be given. |
| tdNewBalance | decimal(4) | Invoice Balance. This field holds the balance of the customer invoice after the payment. |
| tlUIFullAllocation | logical | Full. This field indicates if the payment is already completely paid or not. |
| ttDInvoiceDate | date | Invoice Date. This field indicates the invoice creation date. |
| ttDInvoiceDiscountDueDate | date | Discount Due Date.This field indicates the last date a discount applies, calculated by the system based on the credit terms and the invoice date. |
| ttDInvoiceDueDate | date | Due 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. |
| tdDefaultDiscountAmount | decimal(4) | Default discount Amount. This field holds the discount amount of the customer invoice calculated using the default discount rate. |
| tdDefaultPaymentAmount | decimal(4) | Default payment Amount. The Default payment Amount of the invoice. |
| tcDebtorCode | character | Customer Code. The code that identifies the customer to be paid with this invoice. This field is calculated by the system. |
| tcDivisionCode | character | Sub-Account Code. This field displays the code of sub-account if the customer control account is defined with sub-account analysis. This sub-account applies to all invoice posting lines. This field can be blank. |
| tdVatBaseTC | decimal(4) | if tdDInvoiceVatBaseDebitTC <> 0 =>tdDInvoiceVatBaseDebitTC if tdDInvoiceVatBaseDebitTC = 0 =>tdDInvoiceVatBaseCreditTC |
| tdVatTC | decimal(4) | if tdDInvoiceVatDebitTC <> 0 => tdDInvoiceVatDebitTC if tdDInvoiceVatDebitTC = 0 => tdDInvoiceVatCreditTC |
| tcVatBaseCrDt | character | VatBaseCrDt. This field indicates if the Tax base amount is a credit or debit. |
| tcVatCrDt | character | Tax CR/CR. This field indicates if the Tax amount of the customer invoice is a credit or debit. |
| tiDInvoicePostingId | integer | Invoice Posting ID. This field hold the posting ID(s) which handle(s) the payment of the invoices. |
| tcVatCountryCode | character | Invoice Tax Country Code. This field indicates the tax Country of the invoice. |
| tlDiscountTaxAtPayment | logical | Discount Tax at payment. This field holds the discount tax amount when the invoice is paid. |
| tcCostCentreCode | character | Cost Center Code. The cost center to which this invoice is to be posted. |
| tcProjectCode | character | Project. The project to which this invoice is to be posted. |
| tcCorporateGroupCode | character | Group Name. This field indicates the group the corporation belongs to. |
| tcBusinessRelationName1 | character | Business Relation Name.The business relation name associated with the customer. |
| tcDInvoiceDIText | character | Legacy Invoice Number |
| tdDDocumentInvoiceXrefPaidTC | decimal(4) | Obsolete field (replaced by CDocumentInvoiceXrefPayTC) |
| tdNonDiscAmtTC | decimal(4) | Invoice Non Discountable Amount. This field display the invoice amount without discount in transaction currency. |
| tdLCExchangeRate | decimal(10) | Exchange Rate. The exchange rate used by the invoice. |
| tdLCExchangeRateScale | decimal(10) | Scale Factor. This field indicates the scale factor applying to the exchange rate in use for foreign currency payments. |
| tdCCExchangeRate | decimal(10) | SC Rate. The statutory exchange rate used by the invoice. |
| tdCCExchangeRateScale | decimal(10) | Scale Factor. This field indicates the scale factor applying to the SC rate in use for foreign currency payments. |
| tcDeductionCatCode | character | Deduction Catagory Code |
| tiDeductionCatLine_ID | integer | |
| tcDInvoiceDeductionStatus | character | |
| tdDeductionTC | decimal(2) | |
| tcDInvoiceDeductionParentRowID | character | |
| tcDInoviceDeductionCusReference | character | |
| tcDInvoiceTSMNumber | character | contains the customer TSM Number |
| tiBillNumber | integer | |
| tcBillStatus | character | |
| tiBillYear | integer | |
| LastModifiedDate | date | |
| LastModifiedTime | integer | |
| LastModifiedUser | character | |
| QADC01 | character | unused QAD reserved field |
| QADC02 | character | unused QAD reserved field |
| QADT01 | date | unused QAD reserved field |
| QADD01 | decimal(10) | unused QAD reserved field |
| tc_Rowid | character | |
| tc_ParentRowid | character | |
| tc_Status | character |
QadFinancials