CST_PAC_RECOMPUTE_INT
This interface table will be used by PAC Preprocessor to store the details of cost organization, cost book, item, valuation unit and period combination for which periodic average cost needs to be recomputed. Later PAC Processor consumes this information to recompute periodic average cost. Post recomputation of periodic average cost, corresponding rows from this table will be deleted by PAC Processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_PAC_RECOMPUTE_INT_PK |
PERIOD_NAME, COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Indicates the costing period in which the transaction is processed. | |
| 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. | |
| PAC_TXN_GROUP_ID | NUMBER | 18 | Unique identifier for the set of rows. | ||
| 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. | ||
| PRIOR_PERIOD_ONHAND | NUMBER | On-hand quantity of prior period. | |||
| COST_OWNED_TXN_QUANTITY | NUMBER | Quantity of cost owned transactions. | |||
| TOTAL_PAC_COST | NUMBER | Indicates total period average cost for a combination of period, cost organization, cost book, inventory item and valuation unit. | |||
| VARIANCE_ADJ_FLAG | VARCHAR2 | 1 | A flag that indicates whether periodic average cost adjustment variance transaction is supposed to be created or not. P: Periodic average cost adjustment variance transaction is supposed to be created. Y: Periodic average cost adjustment variance transaction is created. NULL: Periodic average cost adjustment variance transaction need not be created. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_PAC_RECOMPUTE_INT_N1 | Non Unique | Default | REQUEST_ID |
| CST_PAC_RECOMPUTE_INT_U1 | Unique | DEFAULT | PERIOD_NAME, COST_ORG_ID, COST_BOOK_ID, INVENTORY_ITEM_ID, VAL_UNIT_ID |