| 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. |
| tdCInvoiceBalanceCC | decimal(4) | |
| tdCInvoiceBalanceLC | decimal(4) | |
| tdCInvoiceBalanceTC | decimal(4) | |
| ttCInvoiceDate | date | Invoice 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. |
| tcCInvoiceDescription | character | |
| ttCInvoiceDiscountDueDate | 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.
User can modify this field without affecting the credit terms. |
| ttCInvoiceDueDate | date | |
| tdCInvoiceOriginalCreditCC | decimal(4) | |
| tdCInvoiceOriginalCreditLC | decimal(4) | |
| tdCInvoiceOriginalCreditTC | decimal(4) | |
| tdCInvoiceOriginalDebitCC | decimal(4) | |
| tdCInvoiceOriginalDebitLC | decimal(4) | |
| tdCInvoiceOriginalDebitTC | decimal(4) | |
| ttCInvoicePostingDate | date | |
| tcCInvoiceType | character | |
| tiCInvoiceVoucher | integer | |
| tcCnControlGLCode | character | |
| tcCnControlGLDescription | character | |
| tcControlGLCode | character | |
| tcControlGLDescription | character | |
| tcCreditorCode | character | |
| tcCurrencyCode | character | |
| tcCurrencyDescription | character | |
| tiCurrencyNumberOfDecimals | integer | |
| tcDivisionCode | character | |
| tcDivisionDescription | character | |
| tcInvControlGLCode | character | |
| tcInvControlGLDescription | character | |
| tcJournalCode | character | |
| tiPeriodPeriod | integer | |
| tiPeriodYear | integer | |
| tiPostingVoucher | integer | Voucher is a sequential number that uniquely identifies the journal entry (within the combination of an entity and a daybook code). |
| api annotation: | In create mode,enter 0 in this field - the voucher number is generated by the system. In Modify/Delete, the correct voucher number must be entered because this identifies the record. |
| tdPrepaymentAllocatedCC | decimal(4) | |
| tdPrepaymentAllocatedLC | decimal(4) | |
| tdPrepaymentAllocatedTC | decimal(4) | |
| tcPrepaymentStatus | character | |
| tdPrepaymentUnallocatedCC | decimal(4) | |
| tdPrepaymentUnallocatedLC | decimal(4) | |
| tdPrepaymentUnallocatedTC | decimal(4) | |
| tcPurchaseCode | character | |
| tcPurchaseCodeDescription | character | |
| tcReportingInfo | 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 | |
QadFinancials