Transaction Taxes

The Transaction Taxes view object contains the taxes applicable for all the receipt transactions.

Data Store Key : FscmTopModelAM.ScmExtractAM.CmrBiccExtractAM.CmrTransactionTaxesExtractPVO

Primary Keys : CmrTransactionTaxesPEOTransactionTaxId

Initial Extract Date : CmrTransactionTaxesPEOCreationDate

Incremental Extract Date : CmrTransactionTaxesPEOLastUpdateDate

Attributes

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

Name	Description
CmrTransactionTaxesPEOAccountCcid	Value that identifies the account identifier associated with the item distribution line.
CmrTransactionTaxesPEOActiveFlag	Value that indicates whether this is the latest active transaction tax.
CmrTransactionTaxesPEOCreatedBy	User who created the row.
CmrTransactionTaxesPEOCreationDate	Date and time the row was created.
CmrTransactionTaxesPEOEffectiveDate	Date when the row was created and used by the cost accounting process.
CmrTransactionTaxesPEOEventDate	Value that identifies the purchase order event date and maps to CMR_PURCHASE_ORDER_DTLS.EVENT_DATE.
CmrTransactionTaxesPEOFiscalProcessOptionCode	Value that identifies the process code of the associated fiscal document.
CmrTransactionTaxesPEOInclusiveFlag	Value that identifies the inclusive tax line indicator for the line amount. Valid values are Y and N or Null. Y indicates inclusive tax and NULL or N indicates exclusive tax.
CmrTransactionTaxesPEOLastUpdateDate	Date and time the row was most recently updated.
CmrTransactionTaxesPEOLastUpdateLogin	Session login associated to the user who most recently updated the row.
CmrTransactionTaxesPEOLastUpdatedBy	User who last updated the row.
CmrTransactionTaxesPEOLatestCorrectTxnId	Value that identifies the latest correction transaction ID.
CmrTransactionTaxesPEOParentTransactionId	Value that identifies the parent receiving transaction and maps to CMR_TRANSACTIONS.PARENT_TRANSACTION_ID.
CmrTransactionTaxesPEOPerUnitTaxAmt	Value that identifies the per unit tax amount for this tax line.
CmrTransactionTaxesPEOPoTaxFlag	Value that indicates if taxes are copied from the purchase order instead of a new calculation.
CmrTransactionTaxesPEOProcessedByCaFlag	Value that indicates whether the distribution was processed by the cost accounting processor.
CmrTransactionTaxesPEOProcessedByRaFlag	Value that indicates if the tax line was processed by the receipt accounting processor.
CmrTransactionTaxesPEORecNrecTaxAmt	Value that identifies the calculated tax amount of the tax line.
CmrTransactionTaxesPEORecoverableFlag	Value that indicates whether it's a recoverable or nonrecoverable tax.
CmrTransactionTaxesPEORecoveryRateCode	Value that identifies the recovery rate code defined on the tax.
CmrTransactionTaxesPEORecoveryTypeCode	Value that identifies the tax recovery type code based on the tax setup and is returned by the TAX call API.
CmrTransactionTaxesPEOSelfAssessedFlag	Value that indicates if the tax is self assessed.
CmrTransactionTaxesPEOTax	Value that identifies the tax of the tax regime that applies to the tax line.
CmrTransactionTaxesPEOTaxApportionmentLineNumber	Value that identifies the apportionment line number for this tax line when multiple tax lines are created for the same tax during migration from previous releases.
CmrTransactionTaxesPEOTaxJurisdictionId	Value that identifies the tax jurisdiction for this tax line.
CmrTransactionTaxesPEOTaxLiabilityAccountId	Value that identifies the tax liability accounting associated with the item distribution line.
CmrTransactionTaxesPEOTaxLineNumber	Value that identifies the number of the tax line.
CmrTransactionTaxesPEOTaxOnlyLineFlag	Value that indicates this is a tax only line.
CmrTransactionTaxesPEOTaxPointBasis	Value that identifies the tax point basis applicable to the tax line..
CmrTransactionTaxesPEOTaxPointDate	Value that identifies the tax point date that's applicable to the tax line.
CmrTransactionTaxesPEOTaxRate	Value that identifies the tax rate for the tax line based on TAX setup for the transaction.
CmrTransactionTaxesPEOTaxRateCode	Value that identifies the tax rate code and references to ZX_TAX_RATES_B.TAX_RATE_CODE.
CmrTransactionTaxesPEOTaxRateId	Value that identifies the tax rate of the tax line on the transaction.
CmrTransactionTaxesPEOTaxRegimeCode	Value that identifies if the tax regime for the tax line is available in tax repository.
CmrTransactionTaxesPEOTaxStatusCode	Value that identifies the tax status for the tax line.
CmrTransactionTaxesPEOTaxableAmt	Value that identifies the calculated taxable basis amount.
CmrTransactionTaxesPEOTransactionId	Value that identifies the foreign key reference to CMR_TRANSACTIONS.TRANSACTION_ID.
CmrTransactionTaxesPEOTransactionTaxId	Value that uniquely identifies the transaction tax.
CmrTransactionTaxesPEOTrxId	Value that identifies the transaction line for which the tax is created.
CmrTransactionTaxesPEOTrxQuantity	Value that identifies the transaction quantity for the tax line.