Expense Clearing Amounts

The Expense Clearing Amounts view object contains expense values corresponding to accrual clearing events

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrExpenseClrAmtsExtractPVO

Primary Keys : CmrExpenseClrAmtsPEOCmrExpenseClrAmtsId

Initial Extract Date : CmrExpenseClrAmtsPEOCreationDate

Incremental Extract Date : CmrExpenseClrAmtsPEOLastUpdateDate

Attributes

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

Name	Description
CmrExpenseClrAmtsPEOAccrualClrGroupId	Value that uniquely identifies the accrual clearing event that's used while performing accrual reversal.
CmrExpenseClrAmtsPEOApInvoiceDistributionType	Value that identifies the invoice distribution type of the expense line.
CmrExpenseClrAmtsPEOCmrExpenseClrAmtsId	Value that uniquely identifies the expense amounts calculated and stored during accrual clearing.
CmrExpenseClrAmtsPEOCmrPoDistributionId	Value that identifies the reference to purchase order distributions that are associated with clearing amounts.
CmrExpenseClrAmtsPEOCreatedBy	User who created the row.
CmrExpenseClrAmtsPEOCreationDate	Date and time the row was created.
CmrExpenseClrAmtsPEOExpPoDistCostId	Value that identifies the reference to expense distribution costs table that's associated with clearing amounts.
CmrExpenseClrAmtsPEOInclusiveFlag	Value that identifies the inclusive tax line. Valid values are Y and N or Null. Y indicates inclusive tax and NULL or N indicates exclusive tax.
CmrExpenseClrAmtsPEOInvoiceAmt	Value that identifies the invoiced amount for the purchase order distribution.
CmrExpenseClrAmtsPEOInvoiceAmtEnteredCurr	Value that identifies the invoiced amount for purchase order distribution in purchase order currency.
CmrExpenseClrAmtsPEOLastUpdateDate	Date and time the row was last updated.
CmrExpenseClrAmtsPEOLastUpdateLogin	Session login associated with the user who last updated the row.
CmrExpenseClrAmtsPEOLastUpdatedBy	User who last updated the row.
CmrExpenseClrAmtsPEONetExpAdjAmtRounded	Value that identifies the net expense adjustment amount rounded to functional currency precision.
CmrExpenseClrAmtsPEONetExpAdjAmtRoundedEc	Value that identifies the net expense adjustment amount in entered currency and rounded to the entered currency precision.