CST_INV_TXNS_ICP2_GT
The second intermediate table used while creation of cost transaction which holds the transaction with item cost profile information and explodes the transaction using the lot/serial information
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | Costing inventory transaction identifier | |
| CST_INV_TRANSACTION_DTL_ID | NUMBER | 18 | Costing inventory transaction lot/serial detail identifier | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Cost organization identifier | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Cost book identifier | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory item identifier | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Inventory organization identifier | |
| ITEM_COST_PROFILE_ID | NUMBER | 18 | Item cost profile identifier | ||
| COST_PROFILE_ID | NUMBER | 18 | Cost profile identifier | ||
| STATUS | VARCHAR2 | 30 | Status of the transaction | ||
| ERROR_CODE | VARCHAR2 | 30 | Error code associated with the transaction | ||
| VU_STATUS | VARCHAR2 | 30 | Whether or not an existing valuation unit was found for the transaction | ||
| LOGICAL_FLAG | VARCHAR2 | 1 | Whether a transaction is logical (not physical) or not | ||
| INTRANSIT_FLAG | VARCHAR2 | 1 | Whether a transaction affects in-transit or physical inventory | ||
| UOM_CODE | VARCHAR2 | 3 | Costing unit of measure as specified on the item cost profile | ||
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Costing transaction type which is either RECIPT or ISSUE | ||
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 240 | Specifies the transactions that are further classified with the cost transaction type. It can either be null or TRANSFER | ||
| USE_ITEM_COST_FLAG | VARCHAR2 | 1 | Specifies whether to use the current item cost or the incoming cost | ||
| VAL_STRUCTURE_ID | NUMBER | 18 | Valuation structure identifier | ||
| STRUCTURE_INSTANCE_NUMBER | NUMBER | 18 | Structure instance number for the valuation unit | ||
| VAL_UNIT_ID | NUMBER | 18 | Valuation unit identifier | ||
| VAL_UNIT_DETAIL_ID | NUMBER | 18 | Valuation uni detail identifier | ||
| VAL_UNIT_COMBINATION_ID | NUMBER | 18 | Valuation unit code combination identifier | ||
| EXPENSE_TRANSACTION_FLAG | VARCHAR2 | 1 | Whether a transaction is asset or expense | ||
| SUBINVENTORY_CODE | VARCHAR2 | 10 | Subinventory code | ||
| LOCATOR_ID | NUMBER | 18 | Locator identifier | ||
| LOT_NUMBER | VARCHAR2 | 80 | Lot number | ||
| SERIAL_NUMBER | VARCHAR2 | 80 | Serial number | ||
| GRADE_CODE | VARCHAR2 | 150 | Grade of the lot | ||
| 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 | ||
| TOKEN1_NAME | VARCHAR2 | 30 | The name of the token if needed in the error message | ||
| TOKEN1_VALUE | VARCHAR2 | 240 | The value of the token which will be replaced in the error message | ||
| CONSIGNED_FLAG | VARCHAR2 | 1 | Yes | Indicates whether the transaction is consigned or owned. | |
| OWNER_TYPE | NUMBER | 18 | This is the party that transfers the ownership to the org where the ownership change happens. Values: 1 is SUPPLIER, 2 is INVENTORY_ORG amd Null is when the transaction is not consigned | ||
| OWNING_ENTITY_ID | NUMBER | 18 | This is the party that transfers the ownership to the org where the ownership change happens. Owner Type = SUPPLIER, represents the supplier site ID; Owner type = INVENTORY_ORG, represents the inventory org id | ||
| OWNER_NAME | VARCHAR2 | 30 | The owner code used for valuation unit generation | ||
| ORIGINAL_RECEIPT_TXN_ID | NUMBER | 18 | Reference of the original receipt txn ID (Deliver txn ID) on the inter org receipt transactions. This is required to find the purchase order delivery to which the inter org receipt is linked to. | ||
| ORIGINAL_RECEIPT_NUMBER | VARCHAR2 | 50 | This column is used for valuation unit generation and is the combination of receipt number and the inventory org code. | ||
| VU_STRUCTURE_COMPARE_FLAG | VARCHAR2 | 1 | Contains C if the VU structure is at Cost Org only or I if VU structure is at Cost Org & Inventory Org (and no other attributes) | ||
| VU_REQUIRED_FLAG | VARCHAR2 | 1 | This flag indicates that the transaction mandatorily requires a valuation unit. Currently valuation unit derivation is not done for logical transactions. To enable OSP transactions to have a VU we will populate a value of Y. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_INV_TXNS_ICP2_GT_N1 | Non Unique | CST_INV_TRANSACTION_ID |