CST_INCOMING_TXN_COSTS
This table holds the inventory transaction cost details coming in from external systems. It holds the costs that come in from the transaction cost interface as well as the acquisition costs computed for purchase order related inventory transactions by the preprocessor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_INCOMING_TXN_COSTS_PK |
CST_INV_TRANSACTION_ID, COST_COMPONENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Identifier of the source inventory transaction | |
| USE_ITEM_COST_FLAG | VARCHAR2 | 1 | Yes | Indicates whether this table holds any costs for this transaction. A value of 'Y' indicates that the cost processor should use the current item cost and not expect and transaction cost from an external system. | |
| COST_COMPONENT_CODE | VARCHAR2 | 30 | OBSOLETE: Identifies the cost component. Values are based on the seeded cost components in the lookup type CST_COMPONENT_CODES | ||
| COST_COMPONENT_ID | NUMBER | 18 | Yes | Identifies the cost component of the incoming transaction cost. | |
| COST | NUMBER | Unit cost in the primary uom of the item | |||
| ACQUISITION_AMOUNT | NUMBER | Total Acquisition Amount from Purchase Orders. | |||
| ENTERED_AMOUNT | NUMBER | Acquisition amount in purchase order currency. | |||
| PRIMARY_NET_DEL_QTY | NUMBER | Net delivered quantity in item primary unit of measure and is used to derive the unit cost in transaction unit cost table. | |||
| SECONDARY_NET_DEL_QTY | NUMBER | Net delivered quantity in item secondary unit of measure and used to derive the unit cost into transaction cost table. | |||
| PO_NET_DEL_QTY | NUMBER | Net delivered quantity in Purchase Order unit of measure. | |||
| PO_RCPT_QTY | NUMBER | Purchase order net received quantity. | |||
| PRIMARY_RCPT_QTY | NUMBER | The net received quantity in primary unit of measure. | |||
| SECONDARY_RCPT_QTY | NUMBER | The net received quantity in secondary unit of measure. | |||
| CALCULATED_COST_FLAG | VARCHAR2 | 1 | Indicates whether the cost was computed by the cost preprocessor as opposed to something that came in from the transaction cost interface. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies currency of the unit cost | ||
| CURRENCY_CONVERSION_TYPE | VARCHAR2 | 30 | Conversion type that should be used for currency conversion | ||
| CURRENCY_CONVERSION_DATE | TIMESTAMP | The date to be used to determine the exchange rates for currency conversion | |||
| CURRENCY_CONVERSION_RATE | NUMBER | Optional user specified currency conversion rate. | |||
| COMPLETE_COST_FLAG | VARCHAR2 | 1 | Indicates whether the incoming cost records for the transaction represent whole or part of the total transaction cost. This is mainly required for interorg transfers with 'At Cost' pricing option where the incoming cost records will be limited to transfer credit, freight charge etc. Note that overheads are never a part of incoming costs and are not considered in determining the value of this flag. | ||
| LOAD_REQUEST_ID | NUMBER | 18 | Used by Enterprise Service Scheduler: indicates the request ID of the interface load job that created the row. | ||
| EXTERNAL_SYSTEM_REFERENCE | VARCHAR2 | 60 | Identifies the external source system. In case of inventory transfers it is CST with parent transaction identifier relating to original row. | ||
| EXTERNAL_SYSTEM_REF_ID | VARCHAR2 | 30 | Stores a value that uniquely identifies a certain instance of an object within the external system | ||
| EXTERNAL_SYSTEM_SOURCE | VARCHAR2 | 30 | This column identifies the source of the incoming costs. It could have 3 possible values: C - SAAS Inventory Transactions import. I - Inventory Transactions import. U - Inserted via the Miscellaneous Transactions User Interface. | ||
| 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. | ||
| CODE_COMBINATION_ID | NUMBER | 18 | Contains the Code combination of the account entered by the users while creating costs (IMT outbound taxes). | ||
| SOURCE_DOC_CURR_CODE | VARCHAR2 | 15 | Indicates the transaction source document currency code. | ||
| SOURCE_DOC_CURR_CONV_TYPE | VARCHAR2 | 30 | Indicates the transaction source document currency conversion type. | ||
| SOURCE_DOC_CURR_CONV_RATE | NUMBER | Indicates the transaction source document currency conversion rate. | |||
| SOURCE_DOC_CURR_CONV_DATE | TIMESTAMP | Indicates the transaction source document currency conversion date. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_INCOMING_TXN_COSTS | cst_inv_transactions | CST_INV_TRANSACTION_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_INCOMING_TXN_COSTS_N1 | Non Unique | FUSION_TS_TX_DATA | REQUEST_ID |
| CST_INCOMING_TXN_COSTS_UK1 | Unique | FUSION_TS_TX_DATA | CST_INV_TRANSACTION_ID, COST_COMPONENT_ID |