field name | data type | description |
tcBusinessRelationName1 | character | |
tiCompany_ID | integer | |
tcCompanyCode | character | |
tcCurrencyCode | character | |
tcDebtorCode | character | |
tcDeductionCatCode | character | |
tcDeductionCatDescription | character | |
tiDeductionCatLine_ID | integer | |
tcDeductionCatType | character | |
tiDInvoice_ID | integer | |
tdDInvoiceBalanceTC | decimal(4) | |
ttDInvoiceDate | date | |
tiDInvoiceDeduction_ID | integer | |
tcDInvoiceDeductionApRejCom | character | |
ttDInvoiceDeductionApRejDate | date | |
tdDInvoiceDeductionCC | decimal(4) | |
tcDInvoiceDeductionComment | character | |
ttDInvoiceDeductionCreateDate | date | |
tcDInvoiceDeductionCustRef | character | |
tdDInvoiceDeductionLC | decimal(4) | |
tcDInvoiceDeductionPromotionCode | character | |
tiDInvoiceDeductionSequence | integer | |
tcDInvoiceDeductionStatus | character | |
tdDInvoiceDeductionTC | decimal(4) | |
tcDInvoiceDescription | character | |
tlDInvoiceIsOpen | logical | |
tdDInvoiceOriginalDebitCC | decimal(4) | |
tdDInvoiceOriginalDebitLC | decimal(4) | |
tdDInvoiceOriginalDebitTC | decimal(4) | |
ttDInvoicePostingDate | date | |
tiDInvoicePostingYear | integer | |
tiDInvoiceVoucher | integer | |
tiExpenseCompany_ID | integer | |
tcExpenseCompanyCode | character | |
tcJournalCode | character | |
tiPaidDInvoice_ID | integer | |
DInvoice1Custom | character | |
Company1Custom | character | |
DebtorCustom | character | |
DInvoiceDeductionCustom | character | |
DeductionCatLineCustom | character | |
DeductionCatCustom | character | |
CurrencyCustom | character | |
Company2Custom | character | |
JournalCustom | character | |
BusinessRelationCustom | character | |
ti_sequence | integer | |
tc_rowid | character | |