Costing Trade Events
The Costing Trade Events view object contains the trade events from the supply chain financial orchestration flow.
Data Store Key : FscmTopModelAM.ScmExtractAM.CstBiccExtractAM.CstTradeEventsExtractPVO
Primary Keys : CstTradeEventsPEOTradeEventId
Initial Extract Date : CstTradeEventsPEOCreationDate
Incremental Extract Date : CstTradeEventsPEOLastUpdateDate
Attributes
This table provides the list of exposed attributes and their descriptions.
Name | Description |
---|---|
CstTradeEventsPEOAccrualTradeEventId | Unique identifier of the accrual trade event. |
CstTradeEventsPEOAccrualTransactionId | Unique identifier of the accrual transaction event associated to an in-transit receipt. |
CstTradeEventsPEOAgreementHeaderId | Unique identifier of the financial orchestration agreement header. |
CstTradeEventsPEOAgreementNumber | Unique identifier of the financial orchestration agreement number. |
CstTradeEventsPEOAgreementType | Indicates the type of trade agreement. |
CstTradeEventsPEOAssessableValue | Indicates the total assessable value for the event which should be used for tax calculation. |
CstTradeEventsPEOBillToBuId | Unique identifier of the bill to AP business unit for the accrual events. |
CstTradeEventsPEOBillToCustomerId | Unique identifier of the bill to customer. |
CstTradeEventsPEOBusinessUnitId | Unique identifier of the profit center business unit of the trade events |
CstTradeEventsPEOCallbackStatus | Indicates the call back status sent to supply chain financial orchestration after cost processing of the row. Possible values are SUCCESS, or FAILURE. |
CstTradeEventsPEOCmrTransactionTypeCode | Indicates the type of receipt accounting transaction. |
CstTradeEventsPEOCodeCombinationId | Unique identifier of the code combination. |
CstTradeEventsPEOConsignedFlag | Indicates whether the transaction is consigned or owned. |
CstTradeEventsPEOCountryOfOriginCode | Identifies the code for the country of manufacture used to stripe inventory transactions. |
CstTradeEventsPEOCreatedBy | User who created the trade event row. |
CstTradeEventsPEOCreationDate | Date and time when the trade event row was created. |
CstTradeEventsPEOCurrencyConversionType | Identifies the type of currency conversion that should be used during conversion. |
CstTradeEventsPEOCustodyInventoryOrgId | Identifies the inventory organization where the goods are physically present. This attribute would have a value for scenarios when purchased goods are transferred without an ownership change and an ownership change happens in transferee org. |
CstTradeEventsPEODefaultTaxCountry | Tax identifier attribute. Taxation country. |
CstTradeEventsPEODocumentSubType | Tax identifier attribute. Document fiscal classification. |
CstTradeEventsPEODooFullfillLineId | Unique identifier of distributed order orchestration fulfillment line. |
CstTradeEventsPEODooSplitFulfillLineId | Unique identifier of the distributed order orchestration fulfillment line in case of split scenario. |
CstTradeEventsPEOErrorCode | Identifies the error code associated with the transaction. |
CstTradeEventsPEOExpenseTransactionFlag | Identifies whether a transaction is an asset or expense transaction. |
CstTradeEventsPEOExternalSystemRefId | Unique identifier of a certain instance of an object within the external system. |
CstTradeEventsPEOExternalSystemReference | Reference Information from an external system, external to Cost Management. |
CstTradeEventsPEOFirstPtyRegId | Tax identifier attributes. First party tax registration. |
CstTradeEventsPEOFtrId | Identifies the financial trade relationship of this trade event. |
CstTradeEventsPEOIntendUseClassifId | Tax identifier attribute. Intended use. |
CstTradeEventsPEOIntercompanyInvoicingFlag | Indicates whether the transaction is eligible for intercompany invoicing or not. |
CstTradeEventsPEOInvStripingCategory | Identifies the descriptive flexfield application context for Inventory striping attributes. |
CstTradeEventsPEOInvTransactionId | Unique identifier for interorganization Issue transaction for interorganization transfer flows. |
CstTradeEventsPEOInventoryItemId | Unique identifier of the item. |
CstTradeEventsPEOInventoryOrgId | Unique identifier of the inventory organization of the trade event. |
CstTradeEventsPEOInvoiceCurrencyCode | Identifies the intercompany accrual invoice currency. |
CstTradeEventsPEOLastUpdateDate | Date when the trade event row was last updated. |
CstTradeEventsPEOLastUpdateLogin | Session login associated with the user who last updated the trade event row. |
CstTradeEventsPEOLastUpdatedBy | User who last updated the trade event row. |
CstTradeEventsPEOLeTimezoneCode | Identifies the legal entity time zone. |
CstTradeEventsPEOLegalEntityId | Unique identifier of the legal entity. |
CstTradeEventsPEOManualReceiptReqdFlag | Indicates whether manual receipt is created or not for transfer order expense destination flow. |
CstTradeEventsPEOOwnershipChangeDocNumber | Identifies the number of ownership change document for the event. |
CstTradeEventsPEOOwnershipChangeDocType | Identifies the type of ownership change document. |
CstTradeEventsPEOOwnershipChangeEventType | Identifies the type of event associated to the ownership change transaction. |
CstTradeEventsPEOOwnershipChangeSystemRef | Identifies the source system that created the ownership change transaction. |
CstTradeEventsPEOOwnershipChangeTxnId | The unique identifier of the transaction that triggered the ownership change. |
CstTradeEventsPEOParentOwnerChangeEventType | Identifies the type of the event associated to the parent ownership change transaction. |
CstTradeEventsPEOParentOwnerChangeSystemRef | Identifies the source system that created the parent ownership change transaction. |
CstTradeEventsPEOParentOwnershipChangeTxnId | Unique identifier of the parent ownership change transaction which will be used in costing the correction and return flows. |
CstTradeEventsPEOPjcBillableFlag | Indicates whether a project-related item is available to be billed to customers. Possible values are Y and N. |
CstTradeEventsPEOPjcCapitalizableFlag | Indicates whether a project-related item is eligible for capitalization. Possible values are Y and N. |
CstTradeEventsPEOPjcContextCategory | Identifies the descriptive flexfield application context for project-related standardized cost collection. |
CstTradeEventsPEOPjcContractId | Unique identifier of the contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
CstTradeEventsPEOPjcContractLineId | Unique identifier of the contract line. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
CstTradeEventsPEOPjcExpenditureItemDate | Date on which a project-related transaction is incurred. |
CstTradeEventsPEOPjcExpenditureTypeId | Unique identifier of the expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions. |
CstTradeEventsPEOPjcFundingAllocationId | Identifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed. |
CstTradeEventsPEOPjcOrganizationId | Unique identifier of the expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions. |
CstTradeEventsPEOPjcProjectId | Unique identifier of the project used to stripe Inventory transactions. |
CstTradeEventsPEOPjcReservedAttribute1 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcReservedAttribute10 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcReservedAttribute2 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcReservedAttribute3 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcReservedAttribute4 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcReservedAttribute5 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcReservedAttribute6 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcReservedAttribute7 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcReservedAttribute8 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcReservedAttribute9 | Reserved for future project-related functionality. |
CstTradeEventsPEOPjcTaskId | Unique identifier of the task used to stripe Inventory transactions. |
CstTradeEventsPEOPjcUserDefAttribute1 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcUserDefAttribute10 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcUserDefAttribute2 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcUserDefAttribute3 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcUserDefAttribute4 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcUserDefAttribute5 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcUserDefAttribute6 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcUserDefAttribute7 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcUserDefAttribute8 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcUserDefAttribute9 | Reserved for user-definable project information. |
CstTradeEventsPEOPjcWorkTypeId | Unique identifier of project-related classification of the work performed. |
CstTradeEventsPEOPoLineLocationId | Unique identifier of purchase order line location. |
CstTradeEventsPEOPricingOption | Unique identifier of the pricing option. |
CstTradeEventsPEOPrimaryQty | Identifies the transaction quantity in primary unit of measure |
CstTradeEventsPEOPrimaryUomCode | Identifies the code of primary unit of measure. |
CstTradeEventsPEOPriorBuId | The unique identifier of the prior profit center business unit. |
CstTradeEventsPEOPriorInventoryOrgId | Unique identifier of the prior inventory organization for trade event. |
CstTradeEventsPEOPriorTradeEventId | Unique identifier of the prior trade event. |
CstTradeEventsPEOPriorTransactionId | Unique identifier of the prior event that's the source of the cost for this event. |
CstTradeEventsPEOProcessByCaFlag | Indicates whether trade events are error, nonprocessed or processed. |
CstTradeEventsPEOProcessByRaFlag | Indicates whether CMR process rows are error, nonprocessed or processed. |
CstTradeEventsPEOProductCategory | Tax identifier attribute. Product category. |
CstTradeEventsPEOProductFiscClassif | Tax identifier attribute. Product fiscal classification. |
CstTradeEventsPEOProjectId | Unique identifier of the project used to stripe Inventory transactions. |
CstTradeEventsPEOPtrId | Unique identifier of the of primary trade relationship of this trade event. |
CstTradeEventsPEOPtrInstanceId | Unique identifier of the instance of primary trade relationship of this trade event. |
CstTradeEventsPEOQppTxnGroupsUpdatedFlag | Indicates whether TRANSACTION_GROUP_ID and TRANSFER_TRANSACTION_GROUP_ID columns are updated or not. Possible values are Y and N. |
CstTradeEventsPEORcvTransactionId | Unique identifier of the receiving transaction for trade event. |
CstTradeEventsPEOReturnBuId | Unique identifier of the profit center business unit of inventory organization for the return receipt. |
CstTradeEventsPEOReturnInvOrgId | Unique identifier of the inventory organization of return receipt. |
CstTradeEventsPEORootOwnershipChangeTxnId | Unique identifier of the ownership change event corresponding to this trade event. |
CstTradeEventsPEOSecondaryTransactionQty | Identifies the transaction quantity in secondary unit of measure. |
CstTradeEventsPEOSecondaryUomCode | Identifies the code of secondary unit of measure. |
CstTradeEventsPEOShippingBuId | Unique identifier of the profit center business unit of original shipping inventory org. |
CstTradeEventsPEOShippingInvOrgId | Unique identifier of the original shipping inventory org. |
CstTradeEventsPEOSoNeededFlag | Indicates whether sales order details need to be pulled in for these trade events. Possible values are Y and NULL. |
CstTradeEventsPEOSourceDocQuantity | Identifies the quantity in source document. |
CstTradeEventsPEOSourceDocUomCode | Identifies the unit of measure code in source document. |
CstTradeEventsPEOSourceDocumentId | Unique identifier of the source document. |
CstTradeEventsPEOSuccessorBuId | Unique identifier of the successor profit center business unit. |
CstTradeEventsPEOSuccessorInvOrgId | Unique identifier of the successor inventory organization ID. |
CstTradeEventsPEOTaskId | Unique identifier of the task used to stripe Inventory transactions. |
CstTradeEventsPEOTaxCalculatedFlag | Indicates whether the tax is calculated for the trade event. |
CstTradeEventsPEOThirdPtyRegId | Tax identifier attributes. Third party tax registration. |
CstTradeEventsPEOTrackProfitFlag | Indicates tracking of internal profit in costing. |
CstTradeEventsPEOTradeEventId | Unique identifier of the trade event. This is the primary key of the Costing Trade Events view object. |
CstTradeEventsPEOTransactionAmount | Transaction amount for service line type purchase orders. |
CstTradeEventsPEOTransactionCreationDate | Date when this trade event transaction is created. |
CstTradeEventsPEOTransactionDate | Date when this trade event transaction happened. |
CstTradeEventsPEOTransactionEventId | Unique identifier of payables invoice match events from financial orchestration flows. |
CstTradeEventsPEOTransactionQty | Identifies the transaction quantity of the trade event transaction. |
CstTradeEventsPEOTransactionType | Identifies the type of trade event. |
CstTradeEventsPEOTransactionUomCode | Identifies the transaction unit of measure of trade event. |
CstTradeEventsPEOTransferOrderDistId | Unique identifier of the transfer order distribution for trade event. |
CstTradeEventsPEOTransferOrderLineId | Unique identifier of the transfer order line for trade event. |
CstTradeEventsPEOTrxBusinessCategory | Tax identifier attribute. Transaction business category. |
CstTradeEventsPEOTxnAmountCurrencyCode | Identifies the currency code of transaction amount for service line type purchase order. |
CstTradeEventsPEOTxnDocumentSourceSystem | Identifies the application from which the document is originated. |
CstTradeEventsPEOTxnSourceDocLine | Identifies the transaction source document line. |
CstTradeEventsPEOTxnSourceDocLineDetail | Identifies the transaction source document line detail. |
CstTradeEventsPEOTxnSourceDocNumber | Identifies the transaction source document number. |
CstTradeEventsPEOTxnSourceDocType | Identifies the transaction source document type. |
CstTradeEventsPEOTxnSourceRefDocLine | Identifies the transaction source reference document line. |
CstTradeEventsPEOTxnSourceRefDocLineDetail | Identifies the transaction source reference document line detail. |
CstTradeEventsPEOTxnSourceRefDocNumber | Identifies the transaction source reference document number. |
CstTradeEventsPEOTxnSourceRefDocType | Identifies the transaction source reference document type. |
CstTradeEventsPEOUserDefinedFiscClass | Tax identifier attribute.- User-defined fiscal classification. |
CstTradeEventsPEOWshDeliveryDetailId | Unique identifier of the shipping delivery detail for trade event. |