| field name | data type | description |
|---|
| tiBusinessRelation_ID | integer | |
| tcBusinessRelationCode | character | |
| tcBusinessRelationName1 | character | |
| tcBusinessRelationName2 | character | |
| tcBusinessRelationSearchName | character | |
| tiCostCentre_ID | integer | |
| tcCostCentreCode | character | |
| tcCostCentreDescription | character | |
| tiCurrency_ID | integer | |
| tcCurrencyCode | character | |
| tcCurrencyDescription | character | |
| tiCurrencyNumberOfDecimals | integer | |
| tiDebtor_ID | integer | |
| tcDebtorCode | character | |
| tcDebtorCurrency | character | |
| tdDebtorFixedCredLimTC | decimal(4) | |
| tdDebtorPercTurnOverCredLim | decimal(2) | |
| tiDebtorType_ID | integer | |
| tcDebtorTypeCode | character | |
| tcDebtorTypeDescription | character | |
| tiDInvoice_ID | integer | |
| tdDInvoiceBalanceCreditCC | decimal(4) | |
| tdDInvoiceBalanceCreditLC | decimal(4) | |
| tdDInvoiceBalanceCreditTC | decimal(4) | |
| tdDInvoiceBalanceDebitCC | decimal(4) | |
| tdDInvoiceBalanceDebitLC | decimal(4) | |
| tdDInvoiceBalanceDebitTC | decimal(4) | |
| ttDInvoiceBillDate | date | |
| tiDInvoiceCompany_ID | integer | |
| tcDInvoiceCompanyCode | character | |
| ttDInvoiceDate | date | |
| tcDInvoiceDescription | character | |
| ttDInvoiceDiscountDueDate | date | |
| tcDInvoiceDIText | character | |
| ttDInvoiceDueDate | date | |
| tcDInvoiceGoldenTaxInvoiceList | character | |
| tcDInvoiceLegalDocumentList | character | |
| tdDInvoiceOriginalCreditCC | decimal(4) | |
| tdDInvoiceOriginalCreditLC | decimal(4) | |
| tdDInvoiceOriginalCreditTC | decimal(4) | |
| tdDInvoiceOriginalDebitCC | decimal(4) | |
| tdDInvoiceOriginalDebitLC | decimal(4) | |
| tdDInvoiceOriginalDebitTC | decimal(4) | |
| ttDInvoicePostingDate | date | |
| tcDInvoiceSalesOrderList | character | |
| tcDInvoiceShipperList | character | |
| tcDInvoiceSlsPsn1 | character | |
| tcDInvoiceType | character | |
| tiDInvoiceVoucher | integer | |
| tiDivision_ID | integer | |
| tcDivisionCode | character | |
| tcDivisionDescription | character | |
| tiGL_ID | integer | |
| tcGLCode | character | |
| tcGLDescription | character | |
| tcJournalCode | character | |
| tcPaymentConditionPaymentTyp | character | |
| tiPaymentGroup_ID | integer | |
| tcPaymentGroupCode | character | |
| tcPaymentGroupDescription | character | |
| tiPeriodPeriod | integer | |
| tiPeriodYear | integer | |
| tdPostingLineCreditCC | decimal(4) | |
| tdPostingLineCreditLC | decimal(4) | |
| tdPostingLineCreditTC | decimal(4) | |
| tdPostingLineDebitCC | decimal(4) | |
| tdPostingLineDebitLC | decimal(4) | |
| tdPostingLineDebitTC | decimal(4) | |
| tiProject_ID | integer | |
| tcProjectCode | character | |
| tcProjectDescription | character | |
| ti_sequence | integer | |
| tc_rowid | character | |