field name | data type | description |
---|---|---|
APMatchingLn_ID | integer | |
APMatching_ID | integer | |
PvoPostingLine_ID | integer | |
VarRatePostingLine_ID | integer | |
VarUsagePostingLine_ID | integer | |
VarExchRatePostingLine_ID | integer | |
VarExchRatCCPostingLine_ID | integer | |
NewExpensePostingLine_ID | integer | |
RevExpensePostingLine_ID | integer | |
GL_ID | integer | |
Division_ID | integer | |
CostCentre_ID | integer | |
Project_ID | integer | |
PvoDomain | character | |
PvoID | integer | |
PvodLineID | integer | |
APMatchingLnPvodIsLgCharge | logical | |
APMatchingLnPvodLgCharge | character | |
APMatchingLnPvodItemType | character | Possible values: Normal, Memo or Sub-contract |
APMatchingLnPvodCostMtdGL | character | |
APMatchingLnPvodCostMtdCur | character | |
APMatchingLnPvodExchRate | decimal(10) | |
APMatchingLnPvodExchRate2 | decimal(10) | |
APMatchingLnPvodCCRate | decimal(10) | Rate between LC and SC at the moment of the receipt (type: Statutory - optional: accounting) |
APMatchingLnPvodCCScale | decimal(10) | Scale between LC and SC at the moment of the receipt (type: Statutory - optional: accounting) |
APMatchingLnPvodReceiptQty | decimal(10) | |
APMatchingLnPvodUnitPrice | decimal(10) | |
APMatchingLnPvodIsTaxIncl | logical | |
APMatchingLnPvodUnitPrNT | decimal(10) | |
APMatchingLnPvodAccruedTC | decimal(4) | |
APMatchingLnPvodInvoicedTC | decimal(4) | |
APMatchingLnPvodOpenQty | decimal(10) | |
APMatchingLnPvodOpenAmtTC | decimal(4) | |
APMatchingLnPvodGLCode | character | |
APMatchingLnPvodDivCode | character | |
APMatchingLnPvodCCCode | character | |
APMatchingLnPvodPrjCode | character | |
APMatchingLnPvodCurrency | character | |
APMatchingLnPvodIntRef | character | |
APMatchingLnPvodExtRef | character | |
APMatchingLnPvodPackingQty | decimal(10) | |
APMatchingLnPvodSupplItem | character | |
APMatchingLnPvodItem | character | |
APMatchingLnPvodItemDescr1 | character | |
APMatchingLnPvodItemDescr2 | character | |
APMatchingLnPvodUoM | character | |
APMatchingLnPvodUoMConv | decimal(10) | Conversion factor between base UoM and PO UoM |
APMatchingLnPvodSupplier | character | |
APMatchingLnPvodOrderType | character | |
APMatchingLnPvodOrder | character | |
APMatchingLnPvodOrderLnNbr | integer | |
APMatchingLnPvodTransDate | date | |
APMatchingLnPvodSite | character | APMatchingLnPvodSite |
APMatchingLnPvodCompID | integer | APMatchingLnPvodCompID |
APMatchingLnPvodCompCode | character | APMatchingLnPvodCompCode |
APMatchingLnPvodConvFactor | decimal(8) | APMatchingLnPvodConvFactor; The unit of measure conversion factor for a PO receipt. |
APMatchingLnPvodPayCond | character | |
APMatchingLnPvodPLiKeyId | integer | |
APMatchingLnPvodPLidLine | integer | |
APMatchingLnPvodIsTaxable | logical | |
APMatchingLnPvodTaxEnv | character | |
APMatchingLnPvodTaxClass | character | |
APMatchingLnPvodTaxUsage | character | |
APMatchingLnIsPvodFinished | logical | |
APMatchingLnPvodOpAllocCode | character | |
APMatchingLnMatchQty | decimal(10) | |
APMatchingLnPvodFromTaxZone | character | |
APMatchingLnMatchUnitPrice | decimal(10) | |
APMatchingLnPvodToTaxZone | character | |
APMatchingLnMatchIsTaxIncl | logical | |
APMatchingLnMatchUnitPrNT | decimal(10) | |
APMatchingLnMatchAmtTxInTC | decimal(4) | |
APMatchingLnMatchAmtTC | decimal(4) | |
APMatchingLnMatchAmtLC | decimal(4) | |
APMatchingLnMatchAmtCC | decimal(4) | |
APMatchingLnReceiptAmtTC | decimal(4) | |
APMatchingLnReceiptAmtLC | decimal(4) | |
APMatchingLnReceiptAmtCC | decimal(4) | |
APMatchingLnVarRateTC | decimal(4) | |
APMatchingLnVarRateLC | decimal(4) | |
APMatchingLnVarRateCC | decimal(4) | |
APMatchingLnVarUsageTC | decimal(4) | |
APMatchingLnVarUsageLC | decimal(4) | |
APMatchingLnVarUsageCC | decimal(4) | |
APMatchingLnVarExchRateLC | decimal(4) | |
APMatchingLnVarExchRateCC | decimal(4) | |
APMatchingLnIsVarGLPosting | logical | Yes: Use G/L Var account No: Use WIP account |
APMatchingLnIsTaxable | logical | |
APMatchingLnTaxEnv | character | |
APMatchingLnTaxClass | character | |
APMatchingLnTaxUsage | character | |
APMatchingLnOpAllocCode | character | |
tcGLCode | character | |
tcDivisionCode | character | |
tcCostCentreCode | character | |
tcProjectCode | character | |
tdAPMatchingLnPendingMatchAmtTC | decimal(4) | Pending Matched Amt TC of this Pending Voucher Detail on other initial Matchings |
tdAPMatchingLnPendingMatchQty | decimal(10) | Pending Matched Qty of this Pending Voucher Details on other initial Matchings |
tlIsSelected | logical | |
tlIsNeededToRecallGTM | logical | |
tdAPMatchingLnARRecTaxTC | decimal(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. |
tdAPMatchingLnARNRecTaxTC | decimal(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. |
tdAPMatchingLnAIRecTaxTC | decimal(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. |
tdAPMatchingLnAINRecTaxTC | decimal(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. |
tdAPMatchingLnOrigARRetainTaxTC | decimal(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. |
tdAPMatchingLnOrigARRecTaxTC | decimal(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. |
tdAPMatchingLnOrigARNRecTaxTC | decimal(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. |
tcAPMatchingLnCostAdjGLCode | character | For BL purposes only. This field contains GL account used for posting of cost adjustment amount. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnCostAdjDivCode | character | For BL purposes only. This field contains Division used for posting of cost adjustment amount. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnCostAdjCCCode | character | For BL purposes only. This field contains Cost Centre used for posting of cost adjustment amount. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnDiscrpGLCode | character | This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnDiscrpDivCode | character | For BL purposes only. This field contains Division used for posting of discrepancy amount. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnDiscrpCCCode | character | For BL purposes only. This field contains Cost Centre for posting of discrepancy amount. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnRateVarGLCode | character | APMatchingLnRateVarGLCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnRateVarDivCode | character | APMatchingLnRateVarDivCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnRateVarCCCode | character | APMatchingLnRateVarCCCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnPVVGLCode | character | APMatchingLnPVVGLCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnPVVDivCode | character | APMatchingLnPVVDivCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnPVVCCCode | character | APMatchingLnPVVCCCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
tlLogChargeHeaderIsFinished | logical | Field used to hold the IsFinished-property that was stated on the logistic-charge pop-up form |
tlLogChargeHeaderIsSelected | logical | Field used to hold the IsSelected-property that was stated on the logistic-charge pop-up form |
tdLogChargeHeaderMatchedAmountTC | decimal(4) | Field used to hold the MatchedAmount-property that was stated on the logistic-charge pop-up form |
QADC01 | character | unused QAD reserved field |
QADC02 | character | unused QAD reserved field |
QADT01 | date | unused QAD reserved field |
QADD01 | decimal(10) | unused QAD reserved field |
ttAPMatchingLnPvodEffDate | date | Pending voucher effective date |
tcAPMatchingLnUsageVarGLCode | character | APMatchingLnUsageVarGLCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnUsageVarDivCode | character | APMatchingLnUsageVarDivCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
tcAPMatchingLnUsageVarCCCode | character | APMatchingLnUsageVarCCCode: Calc-field only used on BL-side only. This field gets filled in a submethod of AdditionalUpdates. |
tc_Rowid | character | |
tc_ParentRowid | character | |
tc_Status | character |