field name | data type | description |
tiBillTotalWithTax | integer | |
tcDInvoiceBalanceCrDt | character | |
tcDInvoiceReference | character | |
tdDInvoiceBalance | decimal | |
tdDeductionTC | decimal | |
tcDeductionCatCode | character | |
tcDInvoiceDeductionStatus | character | |
tdVatBaseTC | decimal | |
tcVatBaseCrDt | character | |
tdVatTC | decimal | |
tcVatCrDt | character | |
tdDefaultDiscountAmount | decimal | |
tdDefaultPaymentAmount | decimal | |
tdDInvoiceOriginalAmount | decimal | |
tcDInvoiceOriginalCrDt | character | |
tdDInvoiceBalanceTCSigned | decimal | |
tcBillGroup | character | |
tiBankNumber_ID | integer | |
tiBill_ID | integer | |
ttBillDueDate | date | |
tiBillNumber | integer | |
tiBillSchedule_ID | integer | |
tcBillScheduleCode | character | |
tlBillScheduleIsUpdInvByBill | logical | |
tcBillStatus | character | |
tiBusinessRelation_ID1 | integer | |
tcBusinessRelationCode | character | |
tcBusinessRelationName1 | character | |
tiCompany_ID | integer | |
tcCompanyCode | character | |
tcCorporateGroupCode | character | |
tcCostCentreCode | character | |
tiCurrency_ID | integer | |
tcCurrencyCode | character | |
tiCurrencyNumberOfDecimals | integer | |
tiDebtor_ID1 | integer | |
tcDebtorCode | character | |
tiDInvoice_ID | integer | |
tdDInvoiceBalanceCreditTC | decimal(4) | |
tdDInvoiceBalanceDebitTC | decimal(4) | |
tiDInvoiceBank_ID | integer | |
tdDInvoiceBankToPayTC | decimal(4) | |
ttDInvoiceBillDate | date | |
tiDInvoiceCurrency_ID | integer | |
ttDInvoiceDate | date | |
tcDInvoiceDescription | character | |
ttDInvoiceDiscountDueDate | date | |
tcDInvoiceDIText | character | |
ttDInvoiceDueDate | date | |
tdDInvoiceExchangeRate | decimal(10) | |
tlDInvoiceIsDiscTaxAtPaym | logical | |
tlDInvoiceIsOpen | logical | |
tlDInvoiceIsSelected | logical | |
tdDInvoiceNonDiscAmtTC | decimal(4) | |
tdDInvoiceOriginalCreditTC | decimal(4) | |
tdDInvoiceOriginalDebitTC | decimal(4) | |
tiDInvoicePostingYear | integer | |
tdDInvoiceRateScale | decimal(10) | |
tcDInvoiceTSMNumber | character | |
tcDInvoiceType | character | |
tdDInvoiceVatBaseCreditTC | decimal(4) | |
tdDInvoiceVatBaseDebitTC | decimal(4) | |
tdDInvoiceVatCreditTC | decimal(4) | |
tdDInvoiceVatDebitTC | decimal(4) | |
tiDInvoiceVoucher | integer | |
tiDivision_ID | integer | |
tcDivisionCode | character | |
tiEmployee_ID | integer | |
tiEmployee_ID1 | integer | |
tcEmployeeCode | character | |
tiJournal_ID | integer | |
tcJournalCode | character | |
tiNormalPaymentCondition_ID | integer | |
tcPaymentConditionPaymentTyp | character | |
tdPaymentConditionPercentage | decimal(3) | |
tiPeriod_ID | integer | |
tiPeriodPeriod | integer | |
tiPeriodYear | integer | |
tcProjectCode | character | |
DInvoiceCustom | character | |
DebtorCustom | character | |
BillScheduleCustom | character | |
CurrencyCustom | character | |
EmployeeCustom | character | |
BusinessRelationCustom | character | |
CompanyCustom | character | |
JournalCustom | character | |
PaymentConditionCustom | character | |
PeriodCustom | character | |
CorporateGroupCustom | character | |
DInvoiceBankCustom | character | |
DivisionCustom | character | |
CostCentreCustom | character | |
ProjectCustom | character | |
BillCustom | character | |
ti_sequence | integer | |
tc_rowid | character | |