CST_UPG_INTERCO_TXNS

Table to capture the work done on any partially processed transfer flows requiring in-flight upgrade processing from Release 8 to the current release.

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: TABLE

  • Tablespace: FUSION_TS_TX_DATA

Primary Key

Name Columns

CST_UPG_INTERCO_TXNS_PK

CST_INV_TRANSACTION_ID

Columns

Name Datatype Length Precision Not-null Comments
CST_INV_TRANSACTION_ID NUMBER 18 Yes Identifies the inventory transaction within the costing system.
EXTERNAL_SYSTEM_REFERENCE VARCHAR2 60 Yes Identifies the external source system.
EXTERNAL_SYSTEM_REF_ID VARCHAR2 30 Yes Stores a value that uniquely identifies a certain instance of an object within the external system.
PARENT_CST_INV_TXN_ID NUMBER 18 Identifies the parent physical costing inventory transaction for a given logical transaction.
BASE_TXN_TYPE_ID NUMBER 18 Inventory transaction type identifier.
BASE_TXN_SOURCE_TYPE_ID NUMBER 18 Inventory transaction source type identifier.
BASE_TXN_ACTION_ID NUMBER 18 Inventory transaction action identifier.
LOGICAL_FLAG VARCHAR2 1 Identifies whether or not this is a logical transaction.
INTRANSIT_FLAG VARCHAR2 1 Identifies whether or not this is an intransit transaction.
INACTIVE_FLAG VARCHAR2 1 Identifies inactive transaction types.
TRANSACTION_FLOW_TYPE NUMBER 18 Transaction Flow Identifier, 1 - Internal Drop Shipment, 2 - Global Procurement, 3 - Customer Drop Shipment, 4 - Intransit Interorg Transfer, 5 - Direct Interorg Transfer, 6 - Intraorg Transfer, 7 - Transfer Order Intransit Interorg Transfer, 8 - Transfer Order Direct Interorg Transfer, 9 - Transfer Order Intraorg Transfer, 10 - TIR/TIRR at ownership change in procuring org for consigned PO, 11 - TIRR of TO Return with Scrap or null for others.
PRICING_OPTION NUMBER 18 Pricing option indicator. Obsolete as of Release 9.
INTERCOMPANY_INVOICING_FLAG VARCHAR2 1 Indicates whether the transaction is eligible for intercompany invoicing or not.
INTERCO_COST_STG_FLAG VARCHAR2 1 Indicates whether the intercompany cost has been interfaced to Inventory.
UPGRADE_REASON_CODE VARCHAR2 30 Indicates the reason the transaction was captured in this table. Values are: PENDING_COST_ACCTG, INCOMPLETE_INTERORG, PARENT_PHYSICAL, COMPLETED_LOGICAL, COMPLETED_INTRANSIT.
PRESENT_IN_SFO_REPO_FLAG VARCHAR2 1 Indicates whether the intercompany transaction is present in the SFO repository.
EVENT_ID VARCHAR2 100 Event identifier. Required attribute for SFO Event Capture Service.
EVENT_SYSTEM VARCHAR2 100 Event system indicator. Required attribute for SFO Event Capture Service.
EVENT_TYPE VARCHAR2 100 Event type indicator. Required attribute for SFO Event Capture Service.
EVENT_DATA_ID VARCHAR2 100 Event data identifier. Required attribute for SFO Event Capture Service.
SYSTEM_CODE VARCHAR2 100 System code indicator. Required attribute for SFO Event Capture Service.
DOCUMENT_SOURCE_SYSTEM_CODE VARCHAR2 100 Document source system code indicator.
SOURCE_DOCUMENT_ID VARCHAR2 100 Source document identifier. Required attribute for SFO Event Capture Service.
DOCUMENT_TYPE VARCHAR2 30 Document type indicator. Required attribute for SFO Event Capture Service.
TRADE_AGREEMENT_PTR_ID NUMBER 18 Primary trade relationship identifier.
RAISED_AS_INFLIGHT_FLAG VARCHAR2 1 Processing flag to indicate whether the partially processed intercompany transfer transaction has been interfaced to SFO. Valid values are: 'N' - Not yet processed, 'Y' - Yes, 'E' - general error in service call due to service down, inaccessible, or other unexpected issue, and NULL - not applicable for the row.
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.

Foreign Keys

Table Foreign Table Foreign Key Column
CST_UPG_INTERCO_TXNS cst_inv_transactions CST_INV_TRANSACTION_ID

Indexes

Index Uniqueness Tablespace Columns
CST_UPG_INTERCO_TXNS_U1 Unique FUSION_TS_TX_DATA EXTERNAL_SYSTEM_REFERENCE, EXTERNAL_SYSTEM_REF_ID
CST_UPG_INTERCO_TXNS_U2 Unique Default CST_INV_TRANSACTION_ID