| 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 | |
QadFinancials