| field name | data type | description |
|---|---|---|
| tcAddressTaxIdState | character | State Tax ID |
| tlCountryIsEUCountry | logical | Is the country an EU Country ? |
| tcCurrencyCode | character | Currency Code |
| tiCurrencyId | integer | |
| tcDAJournalCode | character | |
| tcDebtorCode | character | Customer Code |
| tiDebtorId | integer | Debtor ID |
| tcDebtorVatNumber | character | Debtor Vat Number |
| tiDebtorVatNumberId | integer | Debtor VAT Number ID |
| tcDebVatBusinessRelationCode | character | Business Relation Code for Debtor Vat Number |
| tcDebVatCountryCode | character | Country Code of Debtor VAT Number |
| ttDInvoiceDate | date | Invoice Date. This field indicates the invoice creation date.This field is normallly prior to the posting date and within the same accounting period as the posting date. The date must be within the upper and lower date limits of an open GL period. The system uses the invoice date with the credit terms to calculate due date and discount date. |
| api annotation: | This field defaults to the DInvoicePostingDate. | |
| tcDInvoiceDescription | character | Descirption of debtor invoice |
| tcDInvoiceDIText | character | CI Text |
| ttDInvoiceDueDate | date | Due Date |
| tdDInvoiceExchangeRate | decimal(10) | Exchange Rate of Debtor Invoice |
| tdDInvoiceExchangeRateScale | decimal(10) | |
| tiDInvoiceId | integer | DInvoice ID |
| tdDInvoiceManhourPercentage | decimal | |
| tdDInvoiceOriginalLC | decimal(4) | Invoice Amount in LC |
| tdDInvoiceOriginalTC | decimal(4) | Invoice Amount in TC |
| ttDInvoicePostingDate | date | posting date |
| ttDInvoiceTaxPointDate | date | tax point date |
| tcDInvoiceType | character | Invoice 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. |
| api annotation: | PartialUpdate = yes - defaults to Invoice | |
| tcDiscountPaymentConditionCode | character | Discount Payment Condition Code |
| tiDiscountPaymentConditionId | integer | Discount Payment Condition ID |
| tcDivisionCode | character | Sub-Account Code |
| tiDivisionId | integer | Division ID |
| tcFieldName | character | Field name of a ui field |
| tcFromTaxZone | character | from Tax Zone |
| tcJournalCode | character | Daybook Code |
| tiJournalId | integer | Journal ID |
| tiLinkedDInvoiceVoucher | integer | Linked DInvoice Voucher |
| tcLinkedJournalCode | character | Linked Daybook Code |
| tiLinkedPeriodYear | integer | Linked Period Year |
| tcNormalPaymentConditionCode | character | Normal Payment Condition Code |
| tiNormalPaymentConditionId | integer | Normal Payment Condition ID |
| tcOwnVatBusinessRelationCode | character | Own Vat BusinessRelation Code |
| tcOwnVatCountryCode | character | Own Vat Country Code |
| tcOwnVatCurrencyCode | character | |
| tiOwnVatCurrencyId | integer | |
| tcOwnVatNumber | character | Own Vat Number |
| tiOwnVatNumberId | integer | Own Vat Number ID |
| tiPeriodPeriod | integer | GL Period |
| tiPeriodYear | integer | Period Year |
| tcReasonCode | character | Reason Code |
| tiReasonId | integer | Reason ID |
| tcToTaxZone | character | To Tax Zone |
| tcTransactionEndCountryCode | character | Transaction End Country Code |
| tiTransactionEndCountryId | integer | Transaction End Country ID |
| tcTransactionStartCountryCode | character | TransactionStartCountryCode |
| tiTransactionStartCountryId | integer | Transaction start country ID |
| tcTxclTaxCls | character | Tax Class |
| tcVatCode | character | Tax Code |
| tdVatCurrencyExchangeRate | decimal | |
| tiVatCurrencyNumDec | integer | |
| tdVatCurrencyRateScale | decimal | |
| tcCostCentreCode | character | |
| tcProjectCode | character |
QadFinancials