project QadFinancials > class BCInvoice > dataset tqApiSelectCInvoiceByPayRef


copy of query resultset tqSelectCInvoiceOpen

table tqApiSelectCInvoiceByPayRef


field namedata typedescription
tdAbsoluteBalanceTCdecimal(4)
tiCInvoice_IDinteger
tcCInvoiceAllocationStatuscharacter
tdCInvoiceBalanceTCdecimal(4)
tcCInvoiceCITextcharacter
ttCInvoiceDatedate
tcCInvoiceDescriptioncharacter
ttCInvoiceDueDatedate
tlCInvoiceIsOpenlogical
tdCInvoiceOriginalCreditTCdecimal(4)
tdCInvoiceOriginalDebitTCdecimal(4)
tcCInvoicePoNbrcharacter
ttCInvoicePostingDatedate
tiCInvoicePostingPeriodinteger
tiCInvoicePostingYearinteger
tiCInvoicePostingYearPeriodinteger
tcCInvoiceReferencecharacter
tiCInvoiceRegistrationNrinteger
tiCInvoiceStage_IDinteger
tdCInvoiceStageAmountTCdecimal(4)
tdCInvoiceStageAmtAppliedTCdecimal(4)
ttCInvoiceStageDueDatedate
tcCInvoiceStageTSMNumbercharacter
tcCInvoiceTSMNumbercharacter
tcCInvoiceTypecharacter
tiCInvoiceVoucherinteger
tcCreditorCodecharacter
tcCurrencyCodecharacter
tcPaymentConditionPaymentTypcharacter
CInvoiceCustomcharacter
CurrencyCustomcharacter
CreditorCustomcharacter
PaymentConditionCustomcharacter
CInvoiceStageCustomcharacter
ti_sequenceinteger
tc_rowidcharacter


Internal usage


QadFinancials
method BCInvoice.ApiSelectCInvoiceByPayRef
method BCInvoice.UpdateCInvoicesPaymentReference
method BCInvoice.VerifyBankPaymentDataSet