CST_WO_TRANSACTION_LAYERS
This table will be used to layer the WIP transactions in FIFO/LIFO order so that we can identify the source of cost for component returns and possibly product returns. The layering logic ensures that the validity and stability of the cost.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
| Name | Columns |
|---|---|
|
CST_WO_TRANSACTION_LAYERS_PK |
WO_TRANSACTION_LAYER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| WO_TRANSACTION_LAYER_ID | NUMBER | 18 | Yes | Surrogate ID identifying a layer. | |
| TRANSACTION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the inventory transaction in CST_TRANSACTIONS. | |
| WIP_REC_TRXN_ID | NUMBER | 18 | Yes | Identifies the receipt layer eg. Component issue which acts like a WIP receipt. | |
| WIP_DEP_TRXN_ID | NUMBER | 18 | Yes | Identifies the depletion transaction (e.g. Component Return) in case this row represents the depletion layer. For Component issues this value will remain as 0. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost organization associated to the Plant. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Surrogate ID identifying the cost book associated to the cost organization. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order in costing. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate ID identifying the work order operation in costing. | |
| OPERATION_SEQ_NUMBER | NUMBER | Operation Sequence Number of the Work Order Operation. | |||
| VAL_UNIT_ID | NUMBER | 18 | Surrogate ID identifying the valuation unit of the transaction. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Surrogate ID identifying the item which was transacted via this transaction. | |
| WIP_ITEM_TYPE | VARCHAR2 | 30 | Yes | Indicates if the layer is for component or end items. Possible values: COMPONENT/PRODUCT | |
| TRANSACTION_TYPE | VARCHAR2 | 30 | Yes | Transaction type of the transaction .e.g. RECEIPT/ISSUE. | |
| TRANSACTION_DATE | TIMESTAMP | Yes | Indicates the layer date. Currently proposing to use TRANSACTION_DATE to create these layers. | ||
| QUANTITY | NUMBER | Yes | Indicates the layer quantity. | ||
| UOM_CODE | VARCHAR2 | 3 | Yes | Identifies the unit of measure for this transaction. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_WO_TRANSACTION_LAYERS_N1 | Non Unique | Default | COST_ORG_ID, COST_BOOK_ID, CST_WORK_ORDER_ID, CST_WORK_ORDER_OPERATION_ID, INVENTORY_ITEM_ID, WIP_ITEM_TYPE |
| CST_WO_TRANSACTION_LAYERS_PK | Unique | Default | WO_TRANSACTION_LAYER_ID |
| CST_WO_TRANSACTION_LAYERS_U1 | Unique | Default | TRANSACTION_ID, WIP_REC_TRXN_ID, WIP_DEP_TRXN_ID |