project QadFinancials > class BAPMatchingReport > dataset tGetMatchingVariance


copy of query resultset tqCInvoiceForMatchingVariance

table tGetMatchingVariance


field namedata typedescription
ttAPMatchingDatedate
tiAPMatchingLn_IDinteger
tlAPMatchingLnIsPvodFinishedlogical
tdAPMatchingLnMatchQtydecimal(10)
tdAPMatchingLnMatchUnitPricedecimal(10)
tdAPMatchingLnPvodExchRatedecimal(10)
tdAPMatchingLnPvodExchRate2decimal(10)
tlAPMatchingLnPvodIsLgChargelogical
tcAPMatchingLnPvodItemcharacter
tcAPMatchingLnPvodItemDescr1character
tcAPMatchingLnPvodItemTypecharacter
tcAPMatchingLnPvodLgChargecharacter
tdAPMatchingLnPvodOpenQtydecimal(10)
tcAPMatchingLnPvodOrdercharacter
tiAPMatchingLnPvodOrderLnNbrinteger
tdAPMatchingLnPvodReceiptQtydecimal(10)
tcAPMatchingLnPvodSitecharacter
tcAPMatchingLnPvodUoMcharacter
tdAPMatchingLnReceiptAmtLCdecimal(4)
tdAPMatchingLnVarExchRateLCdecimal(4)
tdAPMatchingLnVarRateLCdecimal(4)
tdAPMatchingLnVarRateTCdecimal(4)
tdAPMatchingLnVarUsageLCdecimal(4)
tdAPMatchingLnVarUsageTCdecimal(4)
tcAPMatchingStatuscharacter
tiCInvoice_IDinteger
ttCInvoiceDatedate
tdCInvoiceExchangeRatedecimal(10)
tlCInvoiceIsLogisticMatchinglogical
tcCinvoiceJournalcharacter
ttCInvoicePostingDatedate
tdCInvoiceRateScaledecimal(10)
tcCInvoiceReferencecharacter
tiCInvoiceVoucherinteger
tcCompanyCodecharacter
tcCreditorCodecharacter
tcCurrencyCodecharacter
tcMatchingTypecharacter
tiPeriodYearinteger
tiPvodLineIDinteger
tcPvoDomaincharacter
tiPvoIDinteger
tiPvoPostingLine_IDinteger
tiVarExchRatePostingLine_IDinteger
tiVarRatePostingLine_IDinteger
tiVarUsagePostingLine_IDinteger


Internal usage


unused