CST_PAC_WO_INPUTS_INT
This interface table will be used by PAC Processor to store the details work order input transactions that are processed in the current period.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_PAC_WO_INPUTS_INT_PK |
MAX_TRANSACTION_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| MAX_TRANSACTION_ID | NUMBER | 18 | Yes | Unique transaction identifier for the set of work order input transactions grouped by cost organization, cost book, inventory item, valuation unit, period name, inventory organization, costing work order identifier, costing work order operation identifier, cost transaction type, transaction source type, transaction action and transaction type. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Identifies the cost organization associated with the inventory organization. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the cost book assigned to the cost organization. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifier for the inventory item. | |
| VAL_UNIT_ID | NUMBER | 18 | Yes | Identifier for the valuation unit. | |
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Period in which the transaction is processed. This value is populated for the transactions in periodic average cost method. | |
| INVENTORY_ORG_ID | NUMBER | 18 | Yes | Identifier for the inventory organization to which the item belongs. | |
| CST_WORK_ORDER_ID | NUMBER | 18 | Yes | Surrogate identifying a work order uniquely in costing. | |
| CST_WORK_ORDER_OPERATION_ID | NUMBER | 18 | Yes | Surrogate identifying a work order operation associated with the transaction in costing. | |
| COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Yes | Indicates the costing transaction type: ISSUE or RECEIPT. | |
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Yes | Inventory transaction source type identifier. | |
| BASE_TXN_ACTION_ID | NUMBER | 18 | Yes | Inventory transaction action identifier. | |
| BASE_TXN_TYPE_ID | NUMBER | 18 | Yes | Inventory transaction type identifier. | |
| MAX_COST_DATE | TIMESTAMP | Maximum cost date for the set of work order input transactions grouped by cost organization, cost book, inventory item, valuation unit, period name, inventory organization, costing work order identifier, costing work order operation identifier, cost transaction type, transaction source type, transaction action and transaction type. | |||
| QUANTITY | NUMBER | Sum of quantity for the set of work order input transactions grouped by cost organization, cost book, inventory item, valuation unit, period name, inventory organization, costing work order identifier, costing work order operation identifier, cost transaction type, transaction source type, transaction action and transaction type. | |||
| COUNT_OF_TXNS | NUMBER | 18 | Indicates the count of work order input transactions grouped by cost organization, cost book, inventory item, valuation unit, period name, inventory organization, costing work order identifier, costing work order operation identifier, cost transaction type, transaction source type, transaction action and transaction type. | ||
| PAC_TXN_GROUP_ID_1 | NUMBER | 18 | Unique identifier for the set of transactions for incremental processing. | ||
| PAC_TXN_GROUP_ID_2 | NUMBER | 18 | Unique identifier for the set of transactions for incremental processing. | ||
| PAC_TXN_GROUP_ID_3 | NUMBER | 18 | Unique identifier for the set of transactions for incremental processing. | ||
| COST_PROFILE_ID | NUMBER | 18 | Identifies Cost Profile associated with the transaction. | ||
| DEFAULT_COST_ELEMENT_ID | NUMBER | 18 | Cost element corresponding to the cost of the 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_PAC_WO_INPUTS_INT_N1 | Non Unique | Default | REQUEST_ID |
| CST_PAC_WO_INPUTS_INT_N2 | Non Unique | Default | PAC_TXN_GROUP_ID_1 |
| CST_PAC_WO_INPUTS_INT_U1 | Unique | Default | MAX_TRANSACTION_ID |
| CST_PAC_WO_INPUTS_INT_U2 | Unique | Default | COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID, PERIOD_NAME, INVENTORY_ORG_ID, CST_WORK_ORDER_ID, CST_WORK_ORDER_OPERATION_ID, COST_TRANSACTION_TYPE, BASE_TXN_SOURCE_TYPE_ID, BASE_TXN_ACTION_ID, BASE_TXN_TYPE_ID |