project QadFinancials > class BDebtorReport > dataset tqBaseDebtorAgeingAnalysisCurr


copy of query resultset tqDebtorAgeingAnalysisCurrMR

table tqBaseDebtorAgeingAnalysisCurr


field namedata typedescription
tiBusinessRelation_IDinteger
tcBusinessRelationCodecharacter
tcBusinessRelationName1character
tcBusinessRelationName2character
tcBusinessRelationSearchNamecharacter
tiControlGL_IDinteger
tiCostCentre_IDinteger
tcCostCentreCodecharacter
tcCostCentreDescriptioncharacter
tiCurrency_IDinteger
tcCurrencyCodecharacter
tcCurrencyDescriptioncharacter
tiCurrencyNumberOfDecimalsinteger
tiDebtor_IDinteger
tcDebtorCodecharacter
tcDebtorCommentNotecharacter
tcDebtorCurrencycharacter
tdDebtorFixedCredLimTCdecimal(4)
tdDebtorPercTurnOverCredLimdecimal(2)
tiDebtorType_IDinteger
tcDebtorTypeCodecharacter
tcDebtorTypeDescriptioncharacter
tiDInvoice_IDinteger
tiDInvoice_ID2integer
tdDInvoiceBalanceCreditCCdecimal(4)
tdDInvoiceBalanceCreditLCdecimal(4)
tdDInvoiceBalanceCreditTCdecimal(4)
tdDInvoiceBalanceDebitCCdecimal(4)
tdDInvoiceBalanceDebitLCdecimal(4)
tdDInvoiceBalanceDebitTCdecimal(4)
tcDInvoiceCommentNotecharacter
ttDInvoiceDatedate
tcDInvoiceDescriptioncharacter
ttDInvoiceDiscountDueDatedate
tcDInvoiceDITextcharacter
ttDInvoiceDueDatedate
tcDInvoiceGoldenTaxInvoiceListcharacter
tcDInvoiceLegalDocumentListcharacter
tdDInvoiceOriginalCreditCCdecimal(4)
tdDInvoiceOriginalCreditLCdecimal(4)
tdDInvoiceOriginalCreditTCdecimal(4)
tdDInvoiceOriginalDebitCCdecimal(4)
tdDInvoiceOriginalDebitLCdecimal(4)
tdDInvoiceOriginalDebitTCdecimal(4)
ttDInvoicePostingDatedate
tcDInvoiceSalesOrderListcharacter
tcDInvoiceShipperListcharacter
tcDInvoiceSlsPsn1character
tiDInvoiceStage_IDinteger
tdDInvoiceStageAmountCCdecimal(4)
tdDInvoiceStageAmountLCdecimal(4)
tdDInvoiceStageAmountTCdecimal(4)
tdDInvoiceStageAmtAppliedTCdecimal(4)
ttDInvoiceStageDiscDatedate
ttDInvoiceStageDueDatedate
tcDInvoiceTypecharacter
tiDInvoiceVoucherinteger
tiDivision_IDinteger
tcDivisionCodecharacter
tcDivisionDescriptioncharacter
tcGLCodecharacter
tcGLDescriptioncharacter
tcJournalCodecharacter
tcPaymentConditionPaymentTypcharacter
tiPaymentGroup_IDinteger
tcPaymentGroupCodecharacter
tcPaymentGroupDescriptioncharacter
tiPeriodPeriodinteger
tiPeriodYearinteger
tiProject_IDinteger
tcProjectCodecharacter
tcProjectDescriptioncharacter
tlReasonIsInitialStatuslogical


Internal usage


unused