field name | data type | description |
tiBusinessRelation_ID | integer | |
tcBusinessRelationCode | character | |
tcBusinessRelationName1 | character | |
tcBusinessRelationName2 | character | |
tcBusinessRelationSearchName | character | |
tiControlGL_ID | integer | |
tiCostCentre_ID | integer | |
tcCostCentreCode | character | |
tcCostCentreDescription | character | |
tiCurrency_ID | integer | |
tcCurrencyCode | character | |
tcCurrencyDescription | character | |
tiCurrencyNumberOfDecimals | integer | |
tiDebtor_ID | integer | |
tcDebtorCode | character | |
tcDebtorCommentNote | character | |
tcDebtorCurrency | character | |
tdDebtorFixedCredLimTC | decimal(4) | |
tdDebtorPercTurnOverCredLim | decimal(2) | |
tiDebtorType_ID | integer | |
tcDebtorTypeCode | character | |
tcDebtorTypeDescription | character | |
tiDInvoice_ID | integer | |
tiDInvoice_ID2 | integer | |
tdDInvoiceBalanceCreditCC | decimal(4) | |
tdDInvoiceBalanceCreditLC | decimal(4) | |
tdDInvoiceBalanceCreditTC | decimal(4) | |
tdDInvoiceBalanceDebitCC | decimal(4) | |
tdDInvoiceBalanceDebitLC | decimal(4) | |
tdDInvoiceBalanceDebitTC | decimal(4) | |
tcDInvoiceCommentNote | 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 | |
tiDInvoiceStage_ID | integer | |
tdDInvoiceStageAmountCC | decimal(4) | |
tdDInvoiceStageAmountLC | decimal(4) | |
tdDInvoiceStageAmountTC | decimal(4) | |
tdDInvoiceStageAmtAppliedTC | decimal(4) | |
ttDInvoiceStageDiscDate | date | |
ttDInvoiceStageDueDate | date | |
tcDInvoiceType | character | |
tiDInvoiceVoucher | integer | |
tiDivision_ID | integer | |
tcDivisionCode | character | |
tcDivisionDescription | character | |
tcGLCode | character | |
tcGLDescription | character | |
tcJournalCode | character | |
tcPaymentConditionPaymentTyp | character | |
tiPaymentGroup_ID | integer | |
tcPaymentGroupCode | character | |
tcPaymentGroupDescription | character | |
tiPeriodPeriod | integer | |
tiPeriodYear | integer | |
tiProject_ID | integer | |
tcProjectCode | character | |
tcProjectDescription | character | |
tlReasonIsInitialStatus | logical | |