| field name | data type | description |
|---|
| tc_Rowid | character | Use this data item to add as a field in public temp-tables (with index). |
| ti_Sequence | integer | Use this data item to add as a field in public temp-tables. |
| tcCustomer | character | |
| tcCustDescription | character | |
| tcCustomerName | character | |
| tcCustomerAddress | character | |
| tcCustomerCity | character | |
| tcCustomerState | character | |
| tcCustomerZip | character | |
| tcCustomerTelephone | character | |
| tcEntity | character | |
| tcCompanyName | character | |
| tcCompanyAddress | character | |
| tcCompanyCity | character | |
| tcCompanyState | character | |
| tcCompanyZip | character | |
| tcCompanyTelephone | character | |
| tcInvoiceReference | character | |
| tcInvoiceType | character | |
| tcReasonCode | character | |
| ttDueDate | date | |
| tdInvoiceAmount | decimal(4) | |
| tdInvoiceVat | decimal(4) | |
| tiChargedDays | integer | |
| tcSalesJournalReference | character | |
| tcARBatchNumber | character | |
| tcSalesAccountGL | character | |
| tcSalesAccountSubAccount | character | |
| tcSalesAccountCC | character | |
| tcControlAccountGL | character | |
| tcControlAccountSubAccount | character | |
| tcControlAccountCC | character | |
| tcDayBook | character | |
| tcInvoiceVoucher | character | |
| ttDinvoiceTaxPointDate | date | |
| ttDInvoiceDiscountDueDate | date | Discount Due Date. This field displays the last date a discount applies, calculated by the system based on the credit terms and the invoice date.
You can modify the due date without affecting the credit terms.
If the credit terms have a base date specified, this is used in the due date calculations rather than the invoice creation date. |
| tcDebtorCredittermDesc | character | |
| tcDInvoiceDescription | character | Description. A brief description of the invoice. This field is mandatory. |
| tcDinvoiceSalespns | character | |
| tcDinvoiceShiptoCode | character | |
| tcDinvoiceSO | character | |
| tlDinvoiceisTaxable | logical | |
| ttDInvoiceDate | date | DInvoiceDate |
| tcCurrencyCode | character | |
| tcDebtorBillTo | character | |
| tcDebtorShipTo | character | |
| tcCompanyStateTaxID | character | |
| tcDebtorStateTaxID | character | |
| tiDInvoiceReminderCount | integer | DInvoiceReminderCount |
| tcBillToDescription | character | |
| tcBillToName | character | |
| tcBillToAddress | character | |
| tcBillToCity | character | |
| tcBillToState | character | |
| tcBillToZip | character | |
| tcBillToTelephone | character | |
| tcSoldToDescription | character | |
| tcSoldToName | character | |
| tcSoldToAddress | character | |
| tcSoldToCity | character | |
| tcSoldToState | character | |
| tcSoldToZip | character | |
| tcSoldToTelephone | character | |
| tcDebtorSoldTo | character | |
| tcBillToAddress2 | character | |
| tcBillToAddress3 | character | |
| tcSoldToAddress2 | character | |
| tcSoldToAddress3 | character | |
| tcCompanyAddress2 | character | |
| tcCompanyAddress3 | character | |
| tcShipToName | character | |
| tcBillToStateTaxID | character | |
| tcShipToStateTaxID | character | |
| tcDebtorCreditRatingCode | character | |
| tcCustomCombo0 | character | |
| tcCustomCombo1 | character | |
| tcCustomCombo2 | character | |
| tcCustomCombo3 | character | |
| tcCustomCombo4 | character | |
| tcCustomCombo5 | character | |
| tcCustomCombo6 | character | |
| tcCustomCombo7 | character | |
| tcCustomCombo8 | character | |
| tcCustomCombo9 | character | |
| ttCustomDate0 | date | |
| ttCustomDate1 | date | |
| ttCustomDate2 | date | |
| ttCustomDate3 | date | |
| ttCustomDate4 | date | |
| tdCustomDecimal0 | decimal(4) | |
| tdCustomDecimal1 | decimal(4) | |
| tdCustomDecimal2 | decimal(4) | |
| tdCustomDecimal3 | decimal(4) | |
| tdCustomDecimal4 | decimal(4) | |
| tiCustomInteger0 | integer | |
| tiCustomInteger1 | integer | |
| tiCustomInteger2 | integer | |
| tiCustomInteger3 | integer | |
| tiCustomInteger4 | integer | |
| tcCustomLong0 | character | |
| tcCustomLong1 | character | |
| tcCustomNote | character | |
| tcCustomShort0 | character | |
| tcCustomShort1 | character | |
| tcCustomShort2 | character | |
| tcCustomShort3 | character | |
| tcCustomShort4 | character | |
| tcCustomShort5 | character | |
| tcCustomShort6 | character | |
| tcCustomShort7 | character | |
| tcCustomShort8 | character | |
| tcCustomShort9 | character | |
| tdInvoiceBaseAmount | decimal | |
| tdDInvoiceVatVatBaseCreditLC | decimal | |
| tdDInvoiceVatVatBaseCreditTC | decimal | |
| tcTaxRateDesc | character | |
| tcTaxClass | character | |
| tiTaxRate | integer | |
| tlDInvoiceVatIsTaxable | logical | |
| tcDInvoiceInvCertCertificate | character | |
| tcDInvoiceInvCertSignatureCurr | character | |
| tcBankNumber | character | |
| tcDInvoiceTSMNumber | character | |
| tcDInvoiceDIText | character | |
| tcBillToCountry | character | |
| tcSoldToCountry | character | |
| tcDebtorCreditTermCode | character | |
QadFinancials