CST_INV_VALUATION_BUILD_DATES
This table is used for determining the delta records which need to be picked up for the inventory valuation logic. At the start of the inv val run, the current build date is stamped with current date time. At the end of the inv run, the last build date is stamped with the current build date. Thus, for a run of inv val the records falling between last build date and current build date are used for calculations.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CST_INV_VAL_BUILD_DATES_PK |
COST_ORG_ID, COST_BOOK_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
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. | |
LAST_BUILD_DATE | TIMESTAMP | Timestamp of Last Run of Inventory Valuation | |||
CURRENT_BUILD_DATE | TIMESTAMP | Timestamp of Current Run of Inventory Valuation. | |||
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_INV_VAL_BUILD_DATES_U1 | Unique | Default | COST_ORG_ID, COST_BOOK_ID |