CST_USER_ADJUSTMENTS_I_GT
Stores the cost of user entered adjustment transactions for each cost organization.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: DEFAULT
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| USER_ADJUSTMENT_ID | NUMBER | 18 | Yes | User adjustment transaction identifier. | |
| TRANSACTION_ID | NUMBER | 18 | Transaction identifier which uniquely identifies a transaction in costing. | ||
| CST_INV_TRANSACTION_ID | NUMBER | 18 | The inventory transaction identifier that references costing's inventory transaction table. | ||
| COST_ORG_ID | NUMBER | 18 | Identifies the cost organization associated with the inventory organization. | ||
| COST_BOOK_ID | NUMBER | 18 | Identifies the cost book assigned to the cost organization. | ||
| COST_METHOD_CODE | VARCHAR2 | 30 | The costing method for the item. | ||
| INVENTORY_ITEM_ID | NUMBER | 18 | 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 | Cost element corresponding to the cost of the transaction. | ||
| EXPENSE_POOL_ID | NUMBER | 18 | Identifies the expense pool of the cost adjustment. | ||
| BASE_TXN_TYPE_ID | NUMBER | 18 | Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. | ||
| CT_TXN_TYPE_ID | NUMBER | 18 | Base inventory transaction type identifier from costing transaction 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. | ||
| CT_TXN_SOURCE_TYPE_ID | NUMBER | 18 | Base inventory transaction source type identifier from costing transaction table. | ||
| 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. | ||
| CT_TXN_ACTION_ID | NUMBER | 18 | Base inventory transaction action identifier from costing transaction table. | ||
| ADJUSTMENT_NUMBER | VARCHAR2 | 50 | Document number for this adjustment. | ||
| ADJUSTMENT_DATE | TIMESTAMP | User entered adjustment date on the adjustment transaction. | |||
| COST_DATE | TIMESTAMP | Date to be used for transaction sequencing. This field is populated by the cost processor during background processing. | |||
| EFF_DATE | TIMESTAMP | Indicates the user entered date of the cost adjustment. | |||
| POSTED_FLAG | VARCHAR2 | 1 | Indicates if the cost adjustment has been processed by the cost processor and posted to the CST_TRANSACTION_COSTS table. N - No, Y - Yes. | ||
| CURRENCY_CODE | VARCHAR2 | 15 | Identifies the currency of the transaction cost. | ||
| NEW_COST | NUMBER | Indicates the new cost specified by the user. | |||
| ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 240 | Code specifying what kind of processing needs to be done. The value is defined in CST_INTERNAL_TXN_TYPE for the transaction type and is used by Cost Processors for additional processing. | ||
| STATUS_CODE | VARCHAR2 | 30 | Indicates the status of the adjustment detail. P-pending, C-canceled, S-submitted. | ||
| ORIGINAL_EFF_DATE | TIMESTAMP | Original adjustment effective date for a user adjustment number. | |||
| MIN_EFF_DATE | TIMESTAMP | Minimum adjustment effective date for a user adjustment number. | |||
| CT_COST_DATE | TIMESTAMP | Cost date of a cost transaction. |
Indexes
| Index | Uniqueness | Columns |
|---|---|---|
| CST_USER_ADJUSTMENTS_I_GT_U1 | Unique | USER_ADJUSTMENT_ID |