project QadFinancials > class BBill > dataset tDInvoiceToBill


copy of dataset tInnerQueryDinvoiceForBill

table tDInvoiceToBill


field namedata typedescription
tiBillTotalWithTaxinteger
tcDInvoiceBalanceCrDtcharacter
tcDInvoiceReferencecharacter
tdDInvoiceBalancedecimal
tdDeductionTCdecimal
tcDeductionCatCodecharacter
tcDInvoiceDeductionStatuscharacter
tdVatBaseTCdecimal
tcVatBaseCrDtcharacter
tdVatTCdecimal
tcVatCrDtcharacter
tdDefaultDiscountAmountdecimal
tdDefaultPaymentAmountdecimal
tdDInvoiceOriginalAmountdecimal
tcDInvoiceOriginalCrDtcharacter
tdDInvoiceBalanceTCSigneddecimal
tcBillGroupcharacter
tiBankNumber_IDinteger
tiBill_IDinteger
ttBillDueDatedate
tiBillNumberinteger
tiBillSchedule_IDinteger
tcBillScheduleCodecharacter
tlBillScheduleIsUpdInvByBilllogical
tcBillStatuscharacter
tiBusinessRelation_ID1integer
tcBusinessRelationCodecharacter
tcBusinessRelationName1character
tiCompany_IDinteger
tcCompanyCodecharacter
tcCorporateGroupCodecharacter
tcCostCentreCodecharacter
tiCurrency_IDinteger
tcCurrencyCodecharacter
tiCurrencyNumberOfDecimalsinteger
tiDebtor_ID1integer
tcDebtorCodecharacter
tiDInvoice_IDinteger
tdDInvoiceBalanceCreditTCdecimal(4)
tdDInvoiceBalanceDebitTCdecimal(4)
tiDInvoiceBank_IDinteger
tdDInvoiceBankToPayTCdecimal(4)
ttDInvoiceBillDatedate
tiDInvoiceCurrency_IDinteger
ttDInvoiceDatedate
tcDInvoiceDescriptioncharacter
ttDInvoiceDiscountDueDatedate
tcDInvoiceDITextcharacter
ttDInvoiceDueDatedate
tdDInvoiceExchangeRatedecimal(10)
tlDInvoiceIsDiscTaxAtPaymlogical
tlDInvoiceIsOpenlogical
tlDInvoiceIsSelectedlogical
tdDInvoiceNonDiscAmtTCdecimal(4)
tdDInvoiceOriginalCreditTCdecimal(4)
tdDInvoiceOriginalDebitTCdecimal(4)
tiDInvoicePostingYearinteger
tdDInvoiceRateScaledecimal(10)
tcDInvoiceTSMNumbercharacter
tcDInvoiceTypecharacter
tdDInvoiceVatBaseCreditTCdecimal(4)
tdDInvoiceVatBaseDebitTCdecimal(4)
tdDInvoiceVatCreditTCdecimal(4)
tdDInvoiceVatDebitTCdecimal(4)
tiDInvoiceVoucherinteger
tiDivision_IDinteger
tcDivisionCodecharacter
tiEmployee_IDinteger
tiEmployee_ID1integer
tcEmployeeCodecharacter
tiJournal_IDinteger
tcJournalCodecharacter
tiNormalPaymentCondition_IDinteger
tcPaymentConditionPaymentTypcharacter
tdPaymentConditionPercentagedecimal(3)
tiPeriod_IDinteger
tiPeriodPeriodinteger
tiPeriodYearinteger
tcProjectCodecharacter
DInvoiceCustomcharacter
DebtorCustomcharacter
BillScheduleCustomcharacter
CurrencyCustomcharacter
EmployeeCustomcharacter
BusinessRelationCustomcharacter
CompanyCustomcharacter
JournalCustomcharacter
PaymentConditionCustomcharacter
PeriodCustomcharacter
CorporateGroupCustomcharacter
DInvoiceBankCustomcharacter
DivisionCustomcharacter
CostCentreCustomcharacter
ProjectCustomcharacter
BillCustomcharacter
ti_sequenceinteger
tc_rowidcharacter


Internal usage


QadFinancials
method BBill.GetToBillDInvoice