CST_UPG_NEW_BOOK_ADJS_INT
This table stores all the upgrade eligible acquisition cost adjustments for the new cost organization and cost book. All the successfully upgraded records are deleted by cost process after adjustment transactions are created for this new cost book.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: INTERFACE
Primary Key
| Name | Columns |
|---|---|
|
CST_UPG_NEW_BOOK_ADJS_INT_PK |
UPG_ADJ_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| UPG_ADJ_ID | NUMBER | 18 | Yes | Acquisition cost adjustment transaction upgrade tracking identifier. | |
| CST_INV_TRANSACTION_ID | NUMBER | 18 | Yes | The inventory transaction identifier that references costing inventory transaction table. | |
| ADJUSTMENT_TRANSACTION_ID | NUMBER | 18 | Yes | Acquisition cost adjustment identifier for the transaction and this links to acquisition cost adjustment transaction in cst_acq_cost_adjustments. | |
| COST_ORG_ID | NUMBER | 18 | Yes | Identifies the Cost Organization of the transactions. | |
| COST_BOOK_ID | NUMBER | 18 | Yes | Identifies the Cost Book assigned to the Cost Organization. | |
| 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_UPG_NEW_BOOK_ADJS_INT_N1 | Non Unique | Default | CST_INV_TRANSACTION_ID |
| CST_UPG_NEW_BOOK_ADJS_INT_N2 | Non Unique | Default | ADJUSTMENT_TRANSACTION_ID |
| CST_UPG_NEW_BOOK_ADJS_INT_N3 | Non Unique | Default | COST_ORG_ID, COST_BOOK_ID |
| CST_UPG_NEW_BOOK_ADJS_INT_U1 | Unique | Default | UPG_ADJ_ID |