CST_I_TRADE_EVENTS
This is the interface table receiving the trade event transactions from the FOS system.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_I_TRADE_EVENTS_PK |
EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| TRADE_EVENT_ID | NUMBER | 18 | Unique key to identify Trade Event. Used for Internal processing. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Yes | Reference Information from an External system (external to Cost Management). | |
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Yes | Stores a value that uniquely identifies a certain instance of an object within the external system. | |
| DOO_SPLIT_FULFILL_LINE_ID | NUMBER | 18 | Reference to the distributed order orchestration (DOO) fulfillment line identifier. | ||
| BILL_TO_CUSTOMER_ID | NUMBER | 18 | Value that uniquely identifies the bill to customer. | ||
| ACCRUAL_TRANSACTION_ID | NUMBER | 18 | For an in-transit receipt, this refers to the associated accrual transaction event. | ||
| PRIOR_TRANSACTION_ID | NUMBER | 18 | Prior event that is the source of the cost for this event. | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Yes | Legal entity of the trade event. | |
| BUSINESS_UNIT_ID | NUMBER | 18 | Profit Center BU of the trade event. | ||
| BILL_TO_BU_ID | NUMBER | 18 | Bill to AP BU for the accrual events. | ||
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Inventory organization of the trade event. | |
| SUCCESSOR_BU_ID | NUMBER | 18 | Successor profit center Business Unit. | ||
| SUCCESSOR_INV_ORG_ID | NUMBER | 18 | Successor Inventory organization. | ||
| PRIOR_BU_ID | NUMBER | 18 | Prior profit center Business Unit. | ||
| PRIOR_INVENTORY_ORG_ID | NUMBER | 18 | Prior Inventory organization of Trade Event. | ||
| OWNERSHIP_CHANGE_SYSTEM_REF | VARCHAR2 | 100 | The source system from which the ownership change event originated. | ||
| OWNERSHIP_CHANGE_TXN_ID | VARCHAR2 | 100 | The transaction that triggered the ownership change. e.g. ASN, Customer Clearance, Supplier Acceptance. | ||
| OWNERSHIP_CHANGE_EVENT_TYPE | VARCHAR2 | 100 | The type of event associated to the ownership change transaction. | ||
| 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_OWNERSHIP_CHANGE_TXN_ID | VARCHAR2 | 100 | Identifies the parent ownership change transaction which will be used in costing the correction and return flows. | ||
| PARENT_OWNER_CHANGE_EVENT_TYPE | VARCHAR2 | 100 | The type of event associated to the parent ownership change transaction. | ||
| PARENT_OWNER_CHANGE_SYSTEM_REF | VARCHAR2 | 100 | The source system that created the parent ownership change transaction. | ||
| 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. | ||
| AGREEMENT_TYPE | VARCHAR2 | 20 | Agreement type for flows like global procurement, internal material transfer and all drop shipments. | ||
| AGREEMENT_NUMBER | VARCHAR2 | 100 | FOS Agreement number for Trade Event. | ||
| AGREEMENT_HEADER_ID | NUMBER | 18 | FOS agreement header id for trade event. | ||
| PTR_ID | NUMBER | 18 | Identifies the of primary trade relationship of this trade event. | ||
| FTR_ID | NUMBER | 18 | Identifies the financial trade relationship of this trade event. | ||
| PTR_INSTANCE_ID | NUMBER | 18 | Identifies the instance of primary trade relationship of this trade event. | ||
| TXN_DOCUMENT_SOURCE_SYSTEM | VARCHAR2 | 100 | Identifies the system from which the document is originated. | ||
| TXN_SOURCE_DOC_TYPE | VARCHAR2 | 50 | Trade events doc type e.g. PO, SO, TO, Intransit Shipment Number. | ||
| TXN_SOURCE_DOC_NUMBER | VARCHAR2 | 240 | The Document number as displayed on the UI for the event. | ||
| TXN_SOURCE_DOC_LINE | VARCHAR2 | 40 | Transaction Source Document Line for Trade Event. | ||
| TXN_SOURCE_DOC_LINE_DETAIL | VARCHAR2 | 40 | Trade event Source Document Line Details if applicable. | ||
| TXN_SOURCE_REF_DOC_TYPE | VARCHAR2 | 50 | Reference document. E.g. Notional PO, Notional SO. | ||
| TXN_SOURCE_REF_DOC_NUMBER | VARCHAR2 | 240 | Reference document number corresponding to trade event E.g. PO Number etc. | ||
| TXN_SOURCE_REF_DOC_LINE | VARCHAR2 | 240 | Transaction Source Reference Document Line. | ||
| TXN_SOURCE_REF_DOC_LINE_DETAIL | VARCHAR2 | 40 | Transaction Source Reference Document Line Details. | ||
| 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. | ||
| PO_LINE_LOCATION_ID | NUMBER | 18 | Purchase Order Line location for Trade Event. | ||
| WSH_DELIVERY_DETAIL_ID | NUMBER | 18 | Identifies shipping delivery details for trade event. | ||
| DOO_FULLFILL_LINE_ID | NUMBER | 18 | Reference to the unique identifier of the source fulfillment line in distributed order orchestration (DOO). | ||
| TRANSFER_ORDER_LINE_ID | NUMBER | 18 | Identifies Transfer order line details for Trade Event. | ||
| INV_TRANSACTION_ID | NUMBER | 18 | Transaction Identifier for Inter-Org Issue transaction for Inter-Org transfer flows. | ||
| RCV_TRANSACTION_ID | NUMBER | 18 | Receiving transaction identifier for Trade Event. | ||
| TRANSACTION_TYPE | VARCHAR2 | 30 | Yes | Trade event transaction type. Example: Trade Receipt Accrual, Trade In-transit Receipt. | |
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Yes | Identifies whether a transaction is an asset or expense transaction. | |
| INTERCOMPANY_INVOICING_FLAG | VARCHAR2 | 1 | Indicates whether the transaction is eligible for intercompany invoicing or not. | ||
| PRICING_OPTION | VARCHAR2 | 100 | Pricing Option identifier. It signifies whether the option is to use the PO price (1), transfer price (2) or the cost+markup (3) as the transfer cost. | ||
| TRACK_PROFIT_FLAG | VARCHAR2 | 1 | Indicates tracking of internal profit in costing. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Inventory Item Identifier for Trade Event Transaction. | ||
| TRANSACTION_DATE | TIMESTAMP | Yes | The date when this trade event transaction happened. | ||
| TRANSACTION_CREATION_DATE | TIMESTAMP | Yes | The date when this trade event transaction created. | ||
| TRANSACTION_QTY | NUMBER | Transaction quantity of the trade event transaction. | |||
| TRANSACTION_UOM_CODE | VARCHAR2 | 3 | Transaction Unit of Measure code for Trade Event. | ||
| PRIMARY_QTY | NUMBER | Transaction Quantity in primary Unit of Measure. | |||
| PRIMARY_UOM_CODE | VARCHAR2 | 3 | Primary Quantity Unit of Measure code. | ||
| SECONDARY_TRANSACTION_QTY | NUMBER | Transaction quantity in secondary Unit of Measure. | |||
| SECONDARY_UOM_CODE | VARCHAR2 | 3 | Secondary transaction quantity Unit of Measure Code. | ||
| SOURCE_DOC_QUANTITY | NUMBER | Source document quantity. e.g. Purchase Order Quantity. | |||
| SOURCE_DOC_UOM_CODE | VARCHAR2 | 3 | Source document Unit of Measure code. | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion. | ||
| CURRENCY_CONVERSION_DATE | DATE | Conversion date that should be used for currency conversion. | |||
| INVOICE_CURRENCY_CODE | VARCHAR2 | 15 | Intercompany accrual invoice currency. | ||
| ASSESSABLE_VALUE | NUMBER | Total assessable value for the event which should be used for Tax calculation. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | ||
| JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | ||
| DEFAULT_TAX_COUNTRY | VARCHAR2 | 2 | Taxation Country - it is one of tax identifier attribute. | ||
| TRX_BUSINESS_CATEGORY | VARCHAR2 | 240 | Transaction Business Category - it is one of tax identifier attribute. | ||
| DOCUMENT_SUB_TYPE | VARCHAR2 | 240 | Document Fiscal Classification - it is one of tax identifier attribute. | ||
| USER_DEFINED_FISC_CLASS | VARCHAR2 | 30 | User-defined Fiscal Classification - it is one of tax identifier attribute. | ||
| FIRST_PTY_REG_ID | NUMBER | 18 | First Party Tax Registration - it is one of tax identifier attribute. | ||
| THIRD_PTY_REG_ID | NUMBER | 18 | Third Party Tax Registration - it is one of tax identifier attribute. | ||
| PRODUCT_FISC_CLASSIF | VARCHAR2 | 240 | Product Fiscal Classification - it is one of tax identifier attribute. | ||
| PRODUCT_CATEGORY | VARCHAR2 | 240 | Product Category - it is one of tax identifier attribute. | ||
| INTEND_USE_CLASSIF_ID | NUMBER | 18 | Intended Use - it is one of tax identifier attribute. | ||
| MANUAL_RECEIPT_REQD_FLAG | VARCHAR2 | 1 | Flag to denote Manual receipt is created or not for transfer order expense destination flow. | ||
| SHIPPING_INV_ORG_ID | NUMBER | 18 | 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. | ||
| TRANSACTION_EVENT_ID | NUMBER | 18 | This is a unique key which identifies AP Invoice Match events from SFO. | ||
| 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. | ||
| FISCAL_DOC_HEADER_ID | NUMBER | 18 | The unique identifier of the fiscal document. | ||
| FISCAL_DOC_LINE_ID | NUMBER | 18 | The unique identifier of the line in a fiscal document. | ||
| FISCAL_DOC_SCHEDULE_ID | NUMBER | 18 | The unique identifier of the schedule for the line in a fiscal document. | ||
| FISCAL_DOC_ACCESS_KNUM | VARCHAR2 | 64 | The unique key number available on electronic fiscal document. | ||
| TXN_COST_CALLBACK_FLAG | VARCHAR2 | 1 | Interface the transaction cost to financial orchestration system or not. | ||
| FULFILLMENT_UPDATE_FLAG | VARCHAR2 | 1 | A flag that indicates if the backordered fulfillment line is updated in Fusion Order Management. Possible values are: Y: Indicates that the fulfillment is updated. NULL: Indicates that the fulfillment is not updated. | ||
| REF_FLOW_INSTANCE_ID | NUMBER | 18 | Identifier of the forward transaction from FOS that is the source of the cost for this return trade event. Populated only in case of return flows. | ||
| DELIVERY_DETAIL_ID | NUMBER | 18 | Unique identifier of the delivery detail from shipping. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| cst_i_trade_event_costs | cst_i_trade_events | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_I_TRADE_EVENTS_PK | Unique | FUSION_TS_INTERFACE | EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID |
| CST_I_TRADE_EVENTS_U1 | Unique | Default | TRADE_EVENT_ID |