Purchase Order Accrual Amounts

The Purchase Order Accrual Amounts view object contains purchase order accrual amounts.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrPoAccrualAmtsExtractPVO

Primary Keys : CmrPoAccrualAmtsPEORunId, CmrPoAccrualAmtsPEOCmrPoDistributionId, CmrPoAccrualAmtsPEORunPeriodId

Initial Extract Date : CmrPoAccrualAmtsPEOCreationDate

Incremental Extract Date : CmrPoAccrualAmtsPEOLastUpdateDate

Attributes

This table provides the list of exposed attributes and their descriptions.

Name Description
CmrPoAccrualAmtsPEOAccrualAmt Value that identifies the uninvoiced accrual amount of purchase order distribution for a specific run.
CmrPoAccrualAmtsPEOAccrualQty Value that identifies the uninvoiced accrual quantity of purchase order distribution for a specific run.
CmrPoAccrualAmtsPEOBillToBuId Value that identifies the business unit that will create the invoice for the purchase.
CmrPoAccrualAmtsPEOBusinessUnitId Value that identifies the business unit where the invoice is created and the accrual is accounted.
CmrPoAccrualAmtsPEOCmrPoDistributionId Value that identifies the entity in receipt accounting PO distributions. This value will exist for a match to PO as well as a match to receipt cases.
CmrPoAccrualAmtsPEOCreatedBy User who created the row.
CmrPoAccrualAmtsPEOCreationDate Date and time the row was created.
CmrPoAccrualAmtsPEOEncumbranceReversalEntrAmt Value that identifies the encumbrance reversal amount for the purchase order and is used for encumbrance accounting only.
CmrPoAccrualAmtsPEOLastUpdateDate User who most recently updated the row.
CmrPoAccrualAmtsPEOLastUpdateLogin Date and time the row was most recently updated.
CmrPoAccrualAmtsPEOLastUpdatedBy Session login associated with the user who last updated the row.
CmrPoAccrualAmtsPEONonrecoverableTax Value that identifies the nonrecoverable tax amount for a purchase order distribution.
CmrPoAccrualAmtsPEOPeriodEndAccrualAdjDate Value that identifies the period end accrual cut off and accounting date.
CmrPoAccrualAmtsPEORunId Value that uniquely identifies the process run and the surrogate key column.
CmrPoAccrualAmtsPEORunPeriodId Value that identifies the period of the GL period and refers to GL_PERIOD_STATUSES.EFFECTIVE_PERIOD_NUM.
CmrPoAccrualAmtsPEOTaxExcludeAccrualAmount Value that identifies the accrual amount without the nonrecoverable taxes.