1. Tables and Views for SCM
  2. CST_TRADE_EVENTS_S_GT

CST_TRADE_EVENTS_S_GT

This table is used to temporarily store a subset of supporting data from cst_trade_events table to support internal processing within the Cost Processor

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

CST_TRADE_EVENTS_S_GT_PK

TRADE_EVENT_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TRADE_EVENT_ID NUMBER 18 Yes Surrogate key that uniquely identifies the trade event record Active
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Yes Reference Information from an External system (external to Cost Management). Active
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Yes Stores a value that uniquely identifies a certain instance of an object within the external system Active
TRANSFER_ORDER_DIST_ID NUMBER 18 Indicates Transfer Order Distribution in the Trade Event
ACCRUAL_TRANSACTION_ID NUMBER 18 For an in-transit receipt., this refers to the associated Accrual Transaction event Active
PRIOR_TRANSACTION_ID NUMBER 18 Prior event that is the source of the cost for this event. Active
LEGAL_ENTITY_ID NUMBER 18 Yes Indicates Legal entity of the trade event. Active
BUSINESS_UNIT_ID NUMBER 18 Indicates Profit Center BU of the trade event. Active
BILL_TO_BU_ID NUMBER 18 Bill to AP BU for the accrual events. Active
INVENTORY_ORG_ID NUMBER 18 Yes Inventory organization of the trade event. Active
CUSTODY_INVENTORY_ORG_ID NUMBER 18 Inventory org where the goods are physically present. This attribute would have a value for scenarios when purchased goods are transferred without ownership change and ownership change happens in transferee org. Stamped on Inter org issue transactions. Populated for TII and TIR for Inter org flows.
CONSIGNED_FLAG VARCHAR2 1 Yes Indicates whether the transaction is consigned or owned.
OWNERSHIP_CHANGE_TXN_ID VARCHAR2 100 The transaction that triggered the ownership change. e.g. ASN, Customer Clearance, Supplier Acceptance, Transfer to Regular transaction etc. Active
OWNERSHIP_CHANGE_EVENT_TYPE VARCHAR2 100 The type of event associated to the ownership change transaction. Active
OWNERSHIP_CHANGE_DOC_TYPE VARCHAR2 50 Trade events ownership change doc type e.g. PO, SO, TO, Intransit Shipment Number.
OWNERSHIP_CHANGE_DOC_NUMBER VARCHAR2 240 The ownership change document number as displayed on the UI for the event.
PARENT_OWNER_CHANGE_SYSTEM_REF VARCHAR2 100 The source system that created the parent ownership change transaction.
PARENT_OWNER_CHANGE_EVENT_TYPE VARCHAR2 100 The type of the event associated to the parent ownership change transaction.
PARENT_OWNERSHIP_CHANGE_TXN_ID VARCHAR2 100 Identifies the parent ownership change transaction which will be used in costing the correction and return flows. Active
SUCCESSOR_BU_ID NUMBER 18 Successor profit center Business Unit of Trade Event Active
SUCCESSOR_INV_ORG_ID NUMBER 18 Successor Inventory organization of the Trade Event Active
PRIOR_BU_ID NUMBER 18 Indicates Prior profit center Business Unit of the Trade Event Active
PRIOR_INVENTORY_ORG_ID NUMBER 18 Indicates Prior Inventory organization of the Trade Event Active
AGREEMENT_TYPE VARCHAR2 20 Agreement type for flows like global procurement, internal material transfer and all drop shipments. Active
AGREEMENT_NUMBER VARCHAR2 100 Indicates FOS Agreement number for Trade Event Active
AGREEMENT_HEADER_ID NUMBER 18 Indicates FOS Agreement Header Id for Trade Event Active
PTR_ID NUMBER 18 Identifies the of primary trade relationship of this trade event Active
PTR_INSTANCE_ID NUMBER 18 Identifies the instance of primary trade relationship of this trade event. Active
FTR_ID NUMBER 18 Identifies the financial trade relationship of this trade event Active
OWNERSHIP_CHANGE_SYSTEM_REF VARCHAR2 100 The source system that created the ownership change transaction. E.g. Fusion, EBS, 3rd party system etc. Active
TXN_SOURCE_DOC_TYPE VARCHAR2 50 Trade events doc type e.g. PO, SO, TO, Intransit Shipment Number. Active
TXN_SOURCE_DOC_NUMBER VARCHAR2 240 The Document number as displayed on the UI for the event. Active
TXN_SOURCE_REF_DOC_TYPE VARCHAR2 50 Reference document. E.g. Notional PO, Notional SO Active
TXN_SOURCE_REF_DOC_NUMBER VARCHAR2 240 Reference document number corresponding to trade event E.g. PO Number etc. Active
PO_LINE_LOCATION_ID NUMBER 18 Indicates Purchase Order Line location of the Trade Event Active
WSH_DELIVERY_DETAIL_ID NUMBER 18 Indicates Shipping delivery detail of Trade Event Active
DOO_FULLFILL_LINE_ID NUMBER 18 Indicates DOO fulfilment line information in Trade Event Active
TRANSFER_ORDER_LINE_ID NUMBER 18 Indicates Transfer order line information Active
ROOT_OWNERSHIP_CHANGE_TXN_ID NUMBER 18 Identifies the ownership change event corresponding to this Trade Event. E.g. an ownership change can be ASN, Custom clearance, Supplier acceptance etc. Active
TRANSACTION_TYPE VARCHAR2 30 Yes trade event transaction type. Example: Trade Receipt Accrual, Trade In-transit Receipt Active
EXPENSE_TRANSACTION_FLAG VARCHAR2 1 Yes Identifies whether a transaction is an asset or expense transaction Active
INTERCOMPANY_INVOICING_FLAG VARCHAR2 1 Indicates whether the transaction is eligible for intercompany invoicing or not Active
PRICING_OPTION VARCHAR2 100 Indicates Pricing Option details of Trade Event Active
INVENTORY_ITEM_ID NUMBER 18 Identifies Inventory Item for Trade Event record Active
TRANSACTION_DATE TIMESTAMP Yes Date when the transaction was done Active
TRANSACTION_CREATION_DATE TIMESTAMP Yes Date on which the trade event transaction was created Active
TRANSACTION_QTY NUMBER Transaction Quantity of Trade Event Active
TRANSACTION_UOM_CODE VARCHAR2 3 Transaction UOM code for the trade event Active
PRIMARY_QTY NUMBER Transaction Quantity in primary UOM Active
PRIMARY_UOM_CODE VARCHAR2 3 Primary UOM code for the trade event Active
SECONDARY_TRANSACTION_QTY NUMBER Transaction quantity in secondary UOM Active
SECONDARY_UOM_CODE VARCHAR2 3 Secondary UOM Code for the trade event Active
TRANSACTION_AMOUNT NUMBER Stores the transaction amount for service line type Purchase orders
TXN_AMOUNT_CURRENCY_CODE VARCHAR2 15 Currency code represents transaction amount currency for service line type POs
SOURCE_DOC_QUANTITY NUMBER Source document quantity. e.g. PO Quantity Active
SOURCE_DOC_UOM_CODE VARCHAR2 3 Source document Unit of Measure code. Active
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Conversion type that should be used for currency conversion. Active
INVOICE_CURRENCY_CODE VARCHAR2 15 Intercompany accrual invoice currency. Active
ASSESSABLE_VALUE NUMBER Total assessable value for the event which should be used for Tax calculation. Active
TXN_DOCUMENT_SOURCE_SYSTEM VARCHAR2 100 Identifies the system from which the document is originated Active
TXN_SOURCE_DOC_LINE VARCHAR2 40 Indicates Transaction Source Document Line information Active
TXN_SOURCE_DOC_LINE_DETAIL VARCHAR2 40 Trade event Source Document Line Details if applicable Active
TXN_SOURCE_REF_DOC_LINE VARCHAR2 240 Indicates Transaction Trade Event Document Line Reference information Active
TXN_SOURCE_REF_DOC_LINE_DETAIL VARCHAR2 40 Indicates Transaction Trade Event Document Line Reference Detail Active
SOURCE_DOCUMENT_ID VARCHAR2 100 Identifies the source document of the trade event flow. For Procurement Flow - it is PO Line location, also referred as PO Schedule For Transfer Order - it is Transfer Order Line Active
INV_TRANSACTION_ID NUMBER 18 Transaction Identifier for Inter-Org Issue transaction for Inter-Org transfer flows. Active
TRACK_PROFIT_FLAG VARCHAR2 1 Indicates tracking of internal profit in costing Active
DEFAULT_TAX_COUNTRY VARCHAR2 2 Taxation Country - it is one of tax identifier attribute Active
TRX_BUSINESS_CATEGORY VARCHAR2 240 Transaction Business Category - it is one of tax identifier attribute Active
DOCUMENT_SUB_TYPE VARCHAR2 240 Document Fiscal Classification - it is one of tax identifier attribute Active
USER_DEFINED_FISC_CLASS VARCHAR2 30 User-defined Fiscal Classification - it is one of tax identifier attribute Active
FIRST_PTY_REG_ID NUMBER 18 First Party Tax Registration - it is one of tax identifier attribute Active
THIRD_PTY_REG_ID NUMBER 18 Third Party Tax Registration - it is one of tax identifier attribute Active
PRODUCT_FISC_CLASSIF VARCHAR2 240 Product Fiscal Classification - it is one of tax identifier attribute Active
PRODUCT_CATEGORY VARCHAR2 240 Product Category - it is one of tax identifier attribute Active
INTEND_USE_CLASSIF_ID NUMBER 18 Indicates intend use classification of Trade Event Active
PROCESS_BY_CA_FLAG VARCHAR2 5 Indicates Trade Events are error, non processed or processed. Active
PROCESS_BY_RA_FLAG VARCHAR2 5 Indicates CMR process rows are error, non processed or processed. Active
TAX_CALCULATED_FLAG VARCHAR2 30 Identifies if the Tax is calculated for the trade event Active
CALLBACK_STATUS VARCHAR2 20 Indicates the call back status sent to SFO after cost processing of the row. Values are SUCCESS, FAILURE. Call back is not done for rows having a null item id, receipt accrual transaction type, or external system reference not equal to Fusion.
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
REQUEST_ID NUMBER 18 Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. Active
JOB_DEFINITION_NAME VARCHAR2 100 Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. Active
JOB_DEFINITION_PACKAGE VARCHAR2 900 Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. Active
ERROR_CODE VARCHAR2 30 Error code associated with the transaction Active
CMR_TRANSACTION_TYPE_CODE VARCHAR2 40 Receipt accounting transaction type.
RCV_TRANSACTION_ID NUMBER 18 Receiving transaction identifier for Trade Event
MANUAL_RECEIPT_REQD_FLAG VARCHAR2 1 Flag to denote Manual receipt is created or not for transfer order expense destination flow.
CODE_COMBINATION_ID NUMBER 18 Code Combination Identifier for Trade Event
LE_TIMEZONE_CODE VARCHAR2 50 Legal Entity time zone. If NULL, then LE time zone is not enabled for the data in the row and the dates are assumed to be in database time zone.
SO_NEEDED_FLAG VARCHAR2 5 Flag that indicates whether Sales Order details need to be pulled in for these trade events. For CDS trade events, there are no physical transactions, so Sales Order details need to be interfaced here. The possible values are Y when SO details need to be pulled in, else it is NULL.
SHIPPING_INV_ORG_ID NUMBER 18 Original Shipping Inventory Org. Only populated for forward and return IDS and CDS flows.
SHIPPING_BU_ID NUMBER 18 Profit Center Business Unit of Original Shipping Inventory Org. Only populated for forward and return IDS and CDS flows.
RETURN_INV_ORG_ID NUMBER 18 Inventory organization of return receipt
RETURN_BU_ID NUMBER 18 Profit Center Business Unit of Inventory Org where the return receipt.
TRANSACTION_EVENT_ID NUMBER 18 This is a unique key which identifies AP Invoice Match events from SFO
PRIOR_TRADE_EVENT_ID NUMBER 18 Trade event id of the prior trade event
ACCRUAL_TRADE_EVENT_ID NUMBER 18 Trade event id of the accrual transaction
QPP_TXN_GROUPS_UPDATED_FLAG VARCHAR2 1 Processing flag to support the update of the TRANSACTION_GROUP_ID and TRANSFER_TRANSACTION_GROUP_ID columns. Values are Y - Yes, N - No.
INV_STRIPING_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for Inventory striping attributes
PROJECT_ID NUMBER 18 Identifier of the project used to stripe Inventory transactions
TASK_ID NUMBER 18 Identifier of the task used to stripe Inventory transactions
COUNTRY_OF_ORIGIN_CODE VARCHAR2 2 Code for the country of manufacture used to stripe Inventory transactions
PJC_CONTEXT_CATEGORY VARCHAR2 40 Segment used to identify the descriptive flexfield application context for project-related standardized cost collection.
PJC_PROJECT_ID NUMBER 18 Identifier of the project used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJECTS_ALL_B.PROJECT_ID.
PJC_TASK_ID NUMBER 18 Identifier of the task used to build the transaction descriptive flexfield for project-related transaction distributions. Foreign key to PJF_PROJ_ELEMENTS_B.PROJ_ELEMENT_ID (however uses an alias of TASK_ID).
PJC_EXPENDITURE_TYPE_ID NUMBER 18 Expenditure type used to build the transaction descriptive flexfield for project-related transaction distributions.
PJC_EXPENDITURE_ITEM_DATE DATE Date on which a project-related transaction is incurred.
PJC_ORGANIZATION_ID NUMBER 18 Identifier for expenditure organization used to build the transaction descriptive flexfield for project-related transaction distributions.
PJC_BILLABLE_FLAG VARCHAR2 1 Flag that indicates if a project-related item is available to be billed to customers. Valid values are Y or N.
PJC_CAPITALIZABLE_FLAG VARCHAR2 1 Flag that indicates if a project-related item is eligible for capitalization. Valid values are Y or N.
PJC_WORK_TYPE_ID NUMBER 18 Identifier for project-related classification of the worked performed.
PJC_CONTRACT_ID NUMBER 18 Identifier of contract. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed.
PJC_CONTRACT_LINE_ID NUMBER 18 Tracks contract line information. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed.
PJC_FUNDING_ALLOCATION_ID NUMBER 18 Specifies the name of the project funding override. This attribute is used when Oracle Contract Billing or Oracle Grants Accounting is installed.
PJC_RESERVED_ATTRIBUTE1 VARCHAR2 150 Reserved for project-related functionality.
PJC_RESERVED_ATTRIBUTE2 VARCHAR2 150 Reserved for future project-related functionality.
PJC_RESERVED_ATTRIBUTE3 VARCHAR2 150 Reserved for future project-related functionality.
PJC_RESERVED_ATTRIBUTE4 VARCHAR2 150 Reserved for future project-related functionality.
PJC_RESERVED_ATTRIBUTE5 VARCHAR2 150 Reserved for future project-related functionality.
PJC_RESERVED_ATTRIBUTE6 VARCHAR2 150 Reserved for future project-related functionality.
PJC_RESERVED_ATTRIBUTE7 VARCHAR2 150 Reserved for future project-related functionality.
PJC_RESERVED_ATTRIBUTE8 VARCHAR2 150 Reserved for future project-related functionality.
PJC_RESERVED_ATTRIBUTE9 VARCHAR2 150 Reserved for future project-related functionality.
PJC_RESERVED_ATTRIBUTE10 VARCHAR2 150 Reserved for future project-related functionality.
PJC_USER_DEF_ATTRIBUTE1 VARCHAR2 150 Reserved for user-definable project information.
PJC_USER_DEF_ATTRIBUTE2 VARCHAR2 150 Reserved for user-definable project information.
PJC_USER_DEF_ATTRIBUTE3 VARCHAR2 150 Reserved for user-definable project information.
PJC_USER_DEF_ATTRIBUTE4 VARCHAR2 150 Reserved for user-definable project information.
PJC_USER_DEF_ATTRIBUTE5 VARCHAR2 150 Reserved for user-definable project information.
PJC_USER_DEF_ATTRIBUTE6 VARCHAR2 150 Reserved for user-definable project information.
PJC_USER_DEF_ATTRIBUTE7 VARCHAR2 150 Reserved for user-definable project information.
PJC_USER_DEF_ATTRIBUTE8 VARCHAR2 150 Reserved for user-definable project information.
PJC_USER_DEF_ATTRIBUTE9 VARCHAR2 150 Reserved for user-definable project information.
PJC_USER_DEF_ATTRIBUTE10 VARCHAR2 150 Reserved for user-definable project information.
TXN_COST_CALLBACK_FLAG VARCHAR2 1 Interface the transaction cost to financial orchestration system or not.
REF_FLOW_INSTANCE_ID NUMBER 18 Identifier of the forward flow trade event that is the source of the cost for this return trade event.

Indexes

Index Uniqueness Columns Status
CST_TRADE_EVENTS_S_GT_U1 Unique TRADE_EVENT_ID Active