CST_USER_ADJUSTMENTS
Contains user cost adjustments entered from the cost adjustments UI. Cost adjustments are staged here for processing by the Cost Process program.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: FUSION_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_USER_ADJUSTMENTS_PK |
USER_ADJUSTMENT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Status |
|---|---|---|---|---|---|---|
| USER_ADJUSTMENT_ID | NUMBER | 18 | Yes | Surrogate key that identifies a row in this table. | ||
| ADJUSTMENT_NUMBER | VARCHAR2 | 50 | Document number for this adjustment. | |||
| ADJUSTMENT_HEADER_ID | NUMBER | 18 | FK to CST_USER_ADJ_HEADERS | |||
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the adjustment detail. P-???pending???, C-???canceled???, S-???submitted??? | |||
| ADJUSTMENT_DATE | TIMESTAMP | Time stamp that the adjustment is made. | ||||
| USER_ADJ_DATE_FLAG | VARCHAR2 | 5 | Indicating if the adjustment date is specified by the user. Two values: Yes-- user specified, adjustment date cannot be null; No--adjustment date is null. Default value for this flag is No. | |||
| USER_DEFINED_FLAG | VARCHAR2 | 5 | Indicating the adjustment is added by the user via adjustment UI. User can delete this row if the status is ???Pending???. This is not a lookup code. | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | ||
| COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Identifies the Inventory Item for which this user adjustment is created. | ||
| VAL_UNIT_ID | NUMBER | 18 | Identifies the Valuation Unit for which this user adjustment is created. | |||
| COST_ELEMENT_ID | NUMBER | 18 | Yes | Cost element corresponding to the cost of the transaction. | ||
| EFF_DATE | TIMESTAMP | Yes | Indicates the user entered date of the cost adjustment. | |||
| EXPENSE_POOL_ID | NUMBER | 18 | Identifies the expense pool of the cost adjustment. | |||
| UNIT_COST | NUMBER | indicates the old unit cost before adjustment | ||||
| NEW_COST | NUMBER | Yes | Indicates the new cost specified by the user. | |||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency of the transaction / cost. | |||
| REASON_CODE | VARCHAR2 | 30 | Identifies the reason code for the user cost adjustment transaction. | |||
| USER_COMMENT | VARCHAR2 | 240 | Identifies any optional comments entered by the user for the cost adjustment transaction. | |||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. | |||
| BASE_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Inventory transaction source type identifier. For origin as INV the value comes from INV_TXN_SOURCE_TYPES_TL table, and for CST it comes from Lookup_type CST_BASE_TXN_SOURCE_TYPES | |||
| BASE_TXN_ACTION_ID | NUMBER | 18 | Inventory transaction action identifier. For Origin as INV, the value comes from lookup INV_TRANSACTION_ACTIONS and for Origin as CST the value is from lookup_type CST_BASE_TXN_ACTIONS. | |||
| TRANSACTION_ID | NUMBER | 18 | For item cost adjustments only, this column holds the reference to the logical transaction in CST_TRANSACTIONS; otherwise, the value is 0. | |||
| PREPROCESSED_FLAG | VARCHAR2 | 1 | Yes | For item cost adjustments only, indicates if the cost adjustment has been preprocessed by the Quantity Preprocessor and a logical transaction inserted into the CST_TRANSACTIONS table. N - No, Y - Yes, X - Not applicable. There is no LOOKUP_TYPE for these codes. | ||
| COST_DATE | TIMESTAMP | Date to be used for transaction sequencing. This field is populated by the cost processor during background processing. | ||||
| POSTED_FLAG | VARCHAR2 | 1 | Yes | Indicates if the cost adjustment has been processed by the cost processor and posted to the CST_TRANSACTION_COSTS table. N - No, Y - Yes. There is no LOOKUP_TYPE for these codes. | ||
| SOURCE_TRANSACTION_ID | NUMBER | 18 | Single column FK: Identifies the costing transaction. | |||
| SOURCE_TRANSACTION_COST_ID | NUMBER | 18 | Single column FK: Identifies the transaction cost. | |||
| 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. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Active | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_USER_ADJUSTMENTS | cst_transaction_costs | SOURCE_TRANSACTION_COST_ID |
| CST_USER_ADJUSTMENTS | cst_cost_books_b | COST_BOOK_ID |
| CST_USER_ADJUSTMENTS | cst_transactions | SOURCE_TRANSACTION_ID |
| CST_USER_ADJUSTMENTS | cst_val_units_b | VAL_UNIT_ID |
| CST_USER_ADJUSTMENTS | cst_cost_elements_b | COST_ELEMENT_ID |
| cst_transaction_costs | cst_user_adjustments | USER_ADJUSTMENT_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_USER_ADJUSTMENTS_N1 | Non Unique | FUSION_TS_TX_DATA | POSTED_FLAG, COST_ORG_ID, COST_BOOK_ID |
| CST_USER_ADJUSTMENTS_N2 | Non Unique | Default | ADJUSTMENT_NUMBER |
| CST_USER_ADJUSTMENTS_U1 | Unique | FUSION_TS_TX_DATA | SOURCE_TRANSACTION_ID, EFF_DATE, COST_ELEMENT_ID, EXPENSE_POOL_ID |
| CST_USER_ADJUSTMENTS_U2 | Unique | FUSION_TS_TX_DATA | USER_ADJUSTMENT_ID |