project QadFinancials > class BBankImportLine > dataset tDInvoiceByDebtorRef


copy of query resultset tqDInvoiceByDebtorRef

table tDInvoiceByDebtorRef

Description

This temp-table contains all matched customer invoice based on Debtor Reference information, which is only used in NI-Customization.

field namedata typedescription
tcBankNumbercharacter
tiBankNumber_IDinteger
tiCurrency_IDinteger
tcCurrencyCodecharacter
tiDebtor_IDinteger
tcDebtorCodecharacter
tiDInvoice_IDinteger
tdDInvoiceBalanceCreditTCdecimal(4)
tdDInvoiceBalanceDebitTCdecimal(4)
tiDInvoiceBank_IDinteger
tdDInvoiceBankToPayTCdecimal(4)
tiDInvoiceCurrency_IDinteger
tcDInvoiceDescriptioncharacter
ttDInvoiceDiscountDueDatedate
tdDInvoiceDiscPercentagedecimal(2)
tcDInvoiceDITextcharacter
ttDInvoiceDueDatedate
tlDInvoiceIsDiscTaxAtPaymlogical
tlDInvoiceIsOpenlogical
tdDInvoiceOriginalCreditTCdecimal(4)
tdDInvoiceOriginalDebitTCdecimal(4)
tiDInvoicePostingYearinteger
tcDInvoiceTSMNumbercharacter
tdDInvoiceVatCreditTCdecimal(4)
tdDInvoiceVatDebitTCdecimal(4)
tiDInvoiceVoucherinteger
tcJournalCodecharacter
tiNormalPaymentCondition_IDinteger
tdPaymentConditionPercentagedecimal(3)


Internal usage


unused