project QadFinancials > class BAPMatching > dataset tPendingVoucherAPM


copy of class table tAPMatchingLn

table tPendingVoucherAPM

Description

Instanceless temp-table used as output param for method GetPendingVouchers

field namedata typedescription
APMatchingLn_IDinteger
APMatching_IDinteger
PvoPostingLine_IDinteger
VarRatePostingLine_IDinteger
VarUsagePostingLine_IDinteger
VarExchRatePostingLine_IDinteger
VarExchRatCCPostingLine_IDinteger
NewExpensePostingLine_IDinteger
RevExpensePostingLine_IDinteger
GL_IDinteger
Division_IDinteger
CostCentre_IDinteger
Project_IDinteger
PvoDomaincharacter
PvoIDinteger
PvodLineIDinteger
APMatchingLnPvodIsLgChargelogical
APMatchingLnPvodLgChargecharacter
APMatchingLnPvodItemTypecharacterPossible values: Normal, Memo or Sub-contract
APMatchingLnPvodCostMtdGLcharacter
APMatchingLnPvodCostMtdCurcharacter
APMatchingLnPvodExchRatedecimal(10)
APMatchingLnPvodExchRate2decimal(10)
APMatchingLnPvodCCRatedecimal(10)Rate between LC and SC at the moment of the receipt (type: Statutory - optional: accounting)
APMatchingLnPvodCCScaledecimal(10)Scale between LC and SC at the moment of the receipt (type: Statutory - optional: accounting)
APMatchingLnPvodReceiptQtydecimal(10)
APMatchingLnPvodUnitPricedecimal(10)
APMatchingLnPvodIsTaxIncllogical
APMatchingLnPvodUnitPrNTdecimal(10)
APMatchingLnPvodAccruedTCdecimal(4)
APMatchingLnPvodInvoicedTCdecimal(4)
APMatchingLnPvodOpenQtydecimal(10)
APMatchingLnPvodOpenAmtTCdecimal(4)
APMatchingLnPvodGLCodecharacter
APMatchingLnPvodDivCodecharacter
APMatchingLnPvodCCCodecharacter
APMatchingLnPvodPrjCodecharacter
APMatchingLnPvodCurrencycharacter
APMatchingLnPvodIntRefcharacter
APMatchingLnPvodExtRefcharacter
APMatchingLnPvodPackingQtydecimal(10)
APMatchingLnPvodSupplItemcharacter
APMatchingLnPvodItemcharacter
APMatchingLnPvodItemDescr1character
APMatchingLnPvodItemDescr2character
APMatchingLnPvodUoMcharacter
APMatchingLnPvodUoMConvdecimal(10)Conversion factor between base UoM and PO UoM
APMatchingLnPvodSuppliercharacter
APMatchingLnPvodOrderTypecharacter
APMatchingLnPvodOrdercharacter
APMatchingLnPvodOrderLnNbrinteger
APMatchingLnPvodTransDatedate
APMatchingLnPvodSitecharacterAPMatchingLnPvodSite
APMatchingLnPvodCompIDintegerAPMatchingLnPvodCompID
APMatchingLnPvodCompCodecharacterAPMatchingLnPvodCompCode
APMatchingLnPvodConvFactordecimal(8)APMatchingLnPvodConvFactor;
The unit of measure conversion factor for a PO receipt.
APMatchingLnPvodPayCondcharacter
APMatchingLnPvodPLiKeyIdinteger
APMatchingLnPvodPLidLineinteger
APMatchingLnPvodIsTaxablelogical
APMatchingLnPvodTaxEnvcharacter
APMatchingLnPvodTaxClasscharacter
APMatchingLnPvodTaxUsagecharacter
APMatchingLnIsPvodFinishedlogical
APMatchingLnPvodOpAllocCodecharacter
APMatchingLnMatchQtydecimal(10)
APMatchingLnPvodFromTaxZonecharacter
APMatchingLnMatchUnitPricedecimal(10)
APMatchingLnPvodToTaxZonecharacter
APMatchingLnMatchIsTaxIncllogical
APMatchingLnMatchUnitPrNTdecimal(10)
APMatchingLnMatchAmtTxInTCdecimal(4)
APMatchingLnMatchAmtTCdecimal(4)
APMatchingLnMatchAmtLCdecimal(4)
APMatchingLnMatchAmtCCdecimal(4)
APMatchingLnReceiptAmtTCdecimal(4)
APMatchingLnReceiptAmtLCdecimal(4)
APMatchingLnReceiptAmtCCdecimal(4)
APMatchingLnVarRateTCdecimal(4)
APMatchingLnVarRateLCdecimal(4)
APMatchingLnVarRateCCdecimal(4)
APMatchingLnVarUsageTCdecimal(4)
APMatchingLnVarUsageLCdecimal(4)
APMatchingLnVarUsageCCdecimal(4)
APMatchingLnVarExchRateLCdecimal(4)
APMatchingLnVarExchRateCCdecimal(4)
APMatchingLnIsVarGLPostinglogicalYes: Use G/L Var account
No: Use WIP account
APMatchingLnIsTaxablelogical
APMatchingLnTaxEnvcharacter
APMatchingLnTaxClasscharacter
APMatchingLnTaxUsagecharacter
APMatchingLnOpAllocCodecharacter
tcGLCodecharacter
tcDivisionCodecharacter
tcCostCentreCodecharacter
tcProjectCodecharacter
tdAPMatchingLnPendingMatchAmtTCdecimal(4)Pending Matched Amt TC of this Pending Voucher Detail on other initial Matchings
tdAPMatchingLnPendingMatchQtydecimal(10)Pending Matched Qty of this Pending Voucher Details on other initial Matchings
tlIsSelectedlogical
tlIsNeededToRecallGTMlogical
tdAPMatchingLnARRecTaxTCdecimal(4)APMatchingLnARRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the associated field in the underlaying APMatchignLnTax records.
This field gets filled in a submethod of ValidateComponent.
tdAPMatchingLnARNRecTaxTCdecimal(4)APMatchingLnARNRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the associated field in the underlaying APMathcignLnTax records.
This field gets filled in a submethod of ValidateComponent.
tdAPMatchingLnAIRecTaxTCdecimal(4)APMatchingLnAIRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the associated field in the underlaying APMathcignLnTax records.
This field gets filled in a submethod of ValidateComponent.
tdAPMatchingLnAINRecTaxTCdecimal(4)APMatchingLnAINRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the associated field in the underlaying APMathcignLnTax records.
This field gets filled in a submethod of ValidateComponent.
tdAPMatchingLnOrigARRetainTaxTCdecimal(4)APMatchingLnOrigARRetainTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the TaxTC fields on the tax-details of the pvo that have the Retained on.
This field is not based upon the data in tAPMatchingLnTax but based upon the taxes of the pending-voucher.
This field gets filled in a submethod of ValidateComponent.
tdAPMatchingLnOrigARRecTaxTCdecimal(4)APMatchingLnOrigARRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the Recoverable TaxTC fields on the tax-details of the pvo that are marked as AccrueAtReceipt.
This field is not based upon the data in tAPMatchingLnTax but based upon the taxes of the pending-voucher.
This field gets filled in a submethod of ValidateComponent.
tdAPMatchingLnOrigARNRecTaxTCdecimal(4)APMatchingLnOrigARNRecTaxTC: calculated field only used internaly on the BL-side. This field is the sum of the non-rRecoverable TaxTC fields on the tax-details of the pvo that are marked as AccrueAtReceipt.
This field is not based upon the data in tAPMatchingLnTax but based upon the taxes of the pending-voucher.
This field gets filled in a submethod of ValidateComponent.
tcAPMatchingLnCostAdjGLCodecharacterFor BL purposes only.
This field contains GL account used for posting of cost adjustment amount.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnCostAdjDivCodecharacterFor BL purposes only.
This field contains Division used for posting of cost adjustment amount.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnCostAdjCCCodecharacterFor BL purposes only.
This field contains Cost Centre used for posting of cost adjustment amount.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnDiscrpGLCodecharacterThis field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnDiscrpDivCodecharacterFor BL purposes only.
This field contains Division used for posting of discrepancy amount.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnDiscrpCCCodecharacterFor BL purposes only.
This field contains Cost Centre for posting of discrepancy amount.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnRateVarGLCodecharacterAPMatchingLnRateVarGLCode: Calc-field only used on BL-side only.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnRateVarDivCodecharacterAPMatchingLnRateVarDivCode: Calc-field only used on BL-side only.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnRateVarCCCodecharacterAPMatchingLnRateVarCCCode: Calc-field only used on BL-side only.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnPVVGLCodecharacterAPMatchingLnPVVGLCode: Calc-field only used on BL-side only.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnPVVDivCodecharacterAPMatchingLnPVVDivCode: Calc-field only used on BL-side only.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnPVVCCCodecharacterAPMatchingLnPVVCCCode: Calc-field only used on BL-side only.
This field gets filled in a submethod of AdditionalUpdates.
tlLogChargeHeaderIsFinishedlogicalField used to hold the IsFinished-property that was stated on the logistic-charge pop-up form
tlLogChargeHeaderIsSelectedlogicalField used to hold the IsSelected-property that was stated on the logistic-charge pop-up form
tdLogChargeHeaderMatchedAmountTCdecimal(4)Field used to hold the MatchedAmount-property that was stated on the logistic-charge pop-up form
QADC01characterunused QAD reserved field
QADC02characterunused QAD reserved field
QADT01dateunused QAD reserved field
QADD01decimal(10)unused QAD reserved field
ttAPMatchingLnPvodEffDatedatePending voucher effective date
tcAPMatchingLnUsageVarGLCodecharacterAPMatchingLnUsageVarGLCode: Calc-field only used on BL-side only.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnUsageVarDivCodecharacterAPMatchingLnUsageVarDivCode: Calc-field only used on BL-side only.
This field gets filled in a submethod of AdditionalUpdates.
tcAPMatchingLnUsageVarCCCodecharacterAPMatchingLnUsageVarCCCode: Calc-field only used on BL-side only.
This field gets filled in a submethod of AdditionalUpdates.
tc_Rowidcharacter
tc_ParentRowidcharacter
tc_Statuscharacter


Internal usage


QadFinancials
method BAPMatching.GetLogChargesPVOFromHeaderInfo
method BAPMatching.GetPendingVouchers