CST_LAYER_COSTS_I_GT
This table is used to temporarily store a subset of the data from cst_layer_costs table for internal processing within the cost processor.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CST_LAYER_COSTS_I_GT_PK |
LAYER_COST_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments | Status |
---|---|---|---|---|---|---|
LAYER_COST_ID | NUMBER | 18 | Yes | Unique identifier for a layer cost. | Active | |
TRANSACTION_ID | NUMBER | 18 | Yes | Single column FK: Identifies the costing transaction. | Active | |
REC_TRXN_ID | NUMBER | 18 | Yes | Transaction identifier of a receipt transaction. | Active | |
DEP_TRXN_ID | NUMBER | 18 | Yes | Transaction identifier of a depleting transaction. | Active | |
COST_ELEMENT_ID | NUMBER | 18 | Yes | Cost element corresponding to the cost of the transaction. | Active | |
EXPENSE_POOL_ID | NUMBER | 18 | Yes | Identifies the expense pool of cost. | Active | |
EFF_DATE | TIMESTAMP | Yes | Date from which the cost is effective. | Active | ||
TRANSACTION_COST_ID | NUMBER | 18 | Yes | Single column FK: Identifies the transaction cost. | Active | |
COST_ORG_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Organization associated with the inventory organization. | Active | |
COST_BOOK_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Cost Book assigned to the Cost Organization. | Active | |
INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory item identifier associated with cost. | Active | |
VAL_UNIT_ID | NUMBER | 18 | Yes | Valuation unit identifier associated with cost. | Active | |
COST_DATE | TIMESTAMP | Cost date used for processing transaction. | Active | |||
BASE_TXN_TYPE_ID | NUMBER | 18 | Inventory transaction type identifier. For origin as INV the value comes from INV_TRANSACTION_TYPES_TL table. | Active | ||
COST_SOURCE | VARCHAR2 | 30 | Identifies the source of the cost, such as Purchase Order (PO) or Accounts Payable (AP). The LOOKUP_TYPE for these values is CST_COST_SOURCES. | |||
COST_REFERENCE | VARCHAR2 | 100 | Identifies a specific business object or value that further refines the cost source information, such as the source cost organization identifier or an effective date. | |||
COST_TRANSACTION_TYPE | VARCHAR2 | 10 | Cost Transaction Type is used by the costing engine to categorize group processing. Set to 'ADJUST' for adjustments. | Active | ||
ADDITIONAL_PROCESSING_CODE | VARCHAR2 | 240 | Additional Processing Code is an optional further definition of the Cost Transaction Type. It is used on adjustment transactions (Cost Transaction Type is set to 'ADJUST') and is set to 'USER' when the adjustment was done by the user; otherwise, it is set to null. | Active | ||
ABSORPTION_TYPE | VARCHAR2 | 30 | Overhead Absorption Rule: 1=Include In Inventory Value, 2=Expense | Active | ||
QUANTITY | NUMBER | Quantity of the transaction layer. | Active | |||
UOM_CODE | VARCHAR2 | 25 | Unit of measure for the transaction quantity. | Active | ||
UNIT_COST | NUMBER | Current transaction cost for one quantity. | Active | |||
CURRENCY_CODE | VARCHAR2 | 30 | Yes | Identifies the currency of the transaction / cost. | Active | |
ADJ_POSTED_FLAG | VARCHAR2 | 5 | Yes | Indicates if the status of adjustment propagation: 'X' = Not applicable, 'N' = Adjustment not propagated, 'Y' = Adjustment Propagated. | ||
WO_COST_POSTED_FLAG | VARCHAR2 | 1 | Yes | Indicates if costs related to WIP have been transferred to CST_WORK_ORDER_COSTS. Possible values N - No, Y - Yes, X- Not required. | ||
POSTED_FLAG | VARCHAR2 | 5 | Posted Flag indicating if the distributions have been created for this rows. | Active | ||
DISTRIBUTION_ID | NUMBER | 18 | Single column FK: Identifies the cost distribution header record. | Active | ||
PERPAVG_COST_ID | NUMBER | 18 | Identifies the perpetual cost used for this row. | |||
STD_COST_ID | NUMBER | 18 | Identifies the standard cost used for this row. | |||
ONHAND_VALUE | NUMBER | Contains the onhand value for the inventory at the time this layer was costed. The value is stored at the item/cost element level. | ||||
ONHAND_QUANTITY | NUMBER | Contains the onhand quantity of the inventory at the time this layer was costed. | ||||
ONHAND_VALUE_STATUS_FLAG | VARCHAR2 | 1 | Indicates onhand value status. U-Unprocessed, P-Processed, X-Exclude, L-Latest. | |||
CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | Active | |
CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | Active | ||
LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | Active | |
LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | Active | ||
LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | Active | ||
REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | Active | ||
JOB_DEFINITION_NAME | VARCHAR2 | 100 | Enterprise Service Scheduler: indicates the name of the job that created or last updated the row. | Active | ||
JOB_DEFINITION_PACKAGE | VARCHAR2 | 900 | Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row. | Active | ||
DISTRIBUTION_TYPE | VARCHAR2 | 30 | Indicates the distribution type. Useful if the same event type may go into different accounting line types; depending on some attribute on the cost. | |||
PERIOD_NAME | VARCHAR2 | 15 | Period in which the inventory valuation will be calculated. | |||
START_DATE | DATE | Indicates Costing Period start date. | ||||
END_DATE | DATE | Indicates Costing Period end date. | ||||
PERIODIC_COST_ID | NUMBER | 18 | Unique identifier for a periodic average cost row. |
Indexes
Index | Uniqueness | Columns | Status |
---|---|---|---|
CST_LAYER_COSTS_I_GT_U1 | Unique | LAYER_COST_ID | Active |