CST_INTERFACE_STD_HDRS_GT
Transaction temporary table used to hold the standard cost headers by the standard cost bulk desktop integration process.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: Default
Primary Key
Name | Columns |
---|---|
CST_INTERFACE_STD_HDRS_GT_PK |
STD_COST_INT_HDR_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
STD_COST_INT_HDR_ID | NUMBER | 18 | Yes | Generated identifier for bulk desktop integration interface standard cost header record. | |
SCENARIO_NUMBER | VARCHAR2 | 30 | Identifies the scenario for which the standard cost is entered. | ||
COST_ORG_CODE | VARCHAR2 | 30 | Identifies the cost organization for which the standard cost is entered. | ||
COST_BOOK_CODE | VARCHAR2 | 30 | Identifies the cost book for which the standard cost is entered. | ||
VAL_UNIT_CODE | VARCHAR2 | 1000 | Indicates the valuation unit of the standard cost record. | ||
ITEM_NUMBER | VARCHAR2 | 300 | Indicates the item identifier of the standard cost record. | ||
STATUS | VARCHAR2 | 1 | Processing status: N=New, E=Error,S=Successful. | ||
BUY_COST_FLAG | VARCHAR2 | 1 | Indicates the buy cost type. This can be either Y or N. | ||
BATCH_ID | NUMBER | 18 | Identifies the Batch identifier in which the standard cost is entered. |
Indexes
Index | Uniqueness | Columns |
---|---|---|
CST_INTFC_STD_HDRS_GT_U1 | Unique | STD_COST_INT_HDR_ID |