CST_COST_PROFILES_B
This table contains the cost profiles setup by the user. Cost profiles are created in context of Reference Data Sets which can be derived using Cost Organizations.
Details
-
Schema: FUSION
-
Object owner: CST
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
CST_COST_PROFILES_B_PK |
COST_PROFILE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping | Status |
|---|---|---|---|---|---|---|---|
| COST_PROFILE_ID | NUMBER | 18 | Yes | Surrogate key that identifies a row in this table. | |||
| PROPAGATE_COST_ADJ_FLAG | VARCHAR2 | 1 | Identifies if the cost propagation is enabled. This flag is applicable only for Actual cost method and valid values are Y and N. | ||||
| RECEIPT_WITHOUT_COST_CODE | VARCHAR2 | 30 | Identifies the logic to derive a cost for receipts that do not have a cost (includes unreferenced RMA). | ||||
| REFERENCED_RMA_COST_CODE | VARCHAR2 | 30 | Identifies the logic to derive the cost for referenced RMA receipts. | ||||
| 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_SOURCE | VARCHAR2 | 30 | Indicates source of cost used for costing with the cost profile. | ||||
| COST_PROFILE_CODE | VARCHAR2 | 30 | Yes | A unique code given for a particular cost profile. Usually named to indicate the usage of the cost profile. | |||
| SET_ID | NUMBER | 18 | Yes | Identifies a set of reference data shared across business units and other entities. Also known as Reference Data Sets, they are used to filter reference data in transactional UIs. | |||
| COST_METHOD_CODE | VARCHAR2 | 30 | Yes | A unique code given to identify the cost method. Options include Average, Actual, Standard and Periodic Average. | |||
| COST_ADJUSTMENT_LEVEL_CODE | VARCHAR2 | 30 | Yes | A unique code given to identify the cost adjustment level. Options include VALUATION_UNIT, INVENTORY_ORG and SUB_INVENTORY. | |||
| NEGATIVE_QTY_CODE | VARCHAR2 | 30 | Yes | Indicates the logic to be used to process issue transactions when there is insufficient quantity available in costing. Options include Always, Never and To Zero. | |||
| QUANTITY_FLOW_CODE | VARCHAR2 | 30 | Yes | Indicates the depletion logic used to process issue transactions. The default option is FIFO for Standard, Actual and Average cost methods. This flag is not applicable for Periodic Average cost method. | |||
| ENFORCE_TXN_DATE_ORDER_FLAG | VARCHAR2 | 5 | Profile option to ensure that cost date is always in the same order as transaction date. This option is always available if negative inventory code is ALWAYS and propagate cost adjustment is set to No. Possible values are (Y)es and (N)o. | ||||
| VAL_STRUCTURE_ID | NUMBER | 18 | Yes | Single column FK: Identifies the Valuation Structure. | |||
| COST_BY_UOM_TYPE | VARCHAR2 | 30 | Yes | Indicates if the Primary or Secondary Unit of Measure is to be used for calculating item costs. | |||
| COMPONENT_GROUP_ID | NUMBER | 18 | Yes | Identifies the Cost Component mapped to the cost profile. | |||
| ANALYSIS_MAPPING_ID | NUMBER | 18 | Identifies the Analysis Mapping that is associated with the cost profile. | ||||
| CONSIGNED_ACCT_DIST_BASIS | VARCHAR2 | 30 | Indicates the Consigned Accounting Distribution basis for the cost profile. | ||||
| CREATE_ACCT_FOR_CONS_TXNS | VARCHAR2 | 1 | Indicates if accounting entries are to be created for consigned transactions. Valid values are Y and N. | ||||
| PROVISIONAL_COMPLETION_TYPE | VARCHAR2 | 30 | Setup option for valuing partial completions of discrete manufacturing work orders. Possible values: Value at standard cost Value at last actual cost Value at perpetual average cost Value using accumulated work in process balances. | ||||
| PROCESS_PROV_COMPLETION_TYPE | VARCHAR2 | 30 | Setup option for valuing partial completions of process manufacturing work orders. Possible values: Value at standard cost Value at last actual cost Value at perpetual average cost. | ||||
| OPERATION_SCRAP_COST_TYPE | VARCHAR2 | 30 | Indicates the accounting treatment for scrap transactions. The scrap value can be expensed or can be included in inventory. | ||||
| OPERATION_SCRAP_VALUATION_TYPE | VARCHAR2 | 30 | Indicates the timing of creation of scrap transactions. The scrap transactions can be created at: -Value at WO close. -Value immediately and at WO close. -Value at cost cutoff date and WO close. | ||||
| 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. | ||||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 30 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | Active | ||
| ATTRIBUTE_CHAR1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR16 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR17 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR18 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR19 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_CHAR20 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | |||
| ATTRIBUTE_NUMBER1 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_NUMBER2 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_NUMBER3 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_NUMBER4 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_NUMBER5 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_NUMBER6 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_NUMBER7 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_NUMBER8 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_NUMBER9 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_NUMBER10 | NUMBER | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_DATE1 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_DATE2 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_DATE3 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_DATE4 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_DATE5 | DATE | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_TIMESTAMP1 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_TIMESTAMP2 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_TIMESTAMP3 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_TIMESTAMP4 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| ATTRIBUTE_TIMESTAMP5 | TIMESTAMP | Descriptive Flexfield: segment of the user descriptive flexfield. | Cost Profile (CST_COST_PROFILES_B) | ||||
| IGNORE_INTRA_VU_XFER_FLAG | VARCHAR2 | 5 | Column to indicate if intra-vu transfers need to be ignored or costed and accounted. Y means ignore, N means cost and account all transfers including subinventory and locator transfers. | ||||
| ACCT_INTRA_VU_PICK_TXN_FLAG | VARCHAR2 | 1 | Indicates if pick transactions that belong to the same valuation unit need to be processed. | ||||
| SUMMARIZE_SERIALS_FLAG | VARCHAR2 | 5 | Summarize transactions for items that are serial controlled but the valuation unit does not include serial. | ||||
| SUMMARIZE_LOTS_FLAG | VARCHAR2 | 5 | Summarize transactions for items that are lot controlled but the valuation unit does not include lot. | ||||
| UNREFERENCED_RMA_COST_CODE | VARCHAR2 | 30 | Cost option to value sales returns without any reference to the original sales order, which can be the existing item cost or the price on RMA order. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| CST_COST_PROFILES_B | cst_val_structures_b | VAL_STRUCTURE_ID |
| CST_COST_PROFILES_B | cst_component_groups_b | COMPONENT_GROUP_ID |
| cst_cost_profiles_tl | cst_cost_profiles_b | COST_PROFILE_ID |
| cst_transactions | cst_cost_profiles_b | COST_PROFILE_ID |
| cst_item_cost_profiles | cst_cost_profiles_b | ASSET_COST_PROFILE_ID |
| cst_item_cost_profiles | cst_cost_profiles_b | EXPENSE_COST_PROFILE_ID |
| cst_default_cost_profiles | cst_cost_profiles_b | ASSET_COST_PROFILE_ID |
| cst_default_cost_profiles | cst_cost_profiles_b | EXPENSE_COST_PROFILE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CST_COST_PROFILES_B_PK | Unique | Default | COST_PROFILE_ID |
| CST_COST_PROFILES_B_U1 | Unique | Default | COST_PROFILE_CODE, SET_ID |