DW_EB_X_EBS_PR_W_PRODUCT_COST_LINE_F
This table stores cost details by products. The total cost by products include bothDirect Cost that is captured in the financial system by products, and the allocated costs that arecaptured in the costing system. The table also stores the source of allocations. For example, theSales and Marketing costs are not captured as direct costs by products. However, at a later point intime, the costs are allocated from a combination of General Ledger accounts and Cost Centers intovarious products. This table also stores the source cost centers and General Ledger accounts. Theproduct costs can be categorized by Sales, Marketing, Service, and Operating costs. These could befurther broken down into Salaries, Events, and Promotions. Siebel Customer-Centric EnterpriseWarehouse provides a set of common categories, and these can be changed depending on the userneeds and cost components by which products are tracked. The actual cost lines are also tracked inthis table. Apart from products, there are number of other dimensions by which the costs are trackedsuch as Sales Region, Sales Geography, Company, Business Area, and the associated hierarchies.The different cost lines such as Sales, Marketing, and Operating costs, have different details andmany dimensions are included in this table. Some of
Details
Module: Profitability (EBS_PR)
Business Name: Product Cost Lines
Key Columns
Key column information is not documented in the supplied metadata.
Columns
| Name | Datatype | Length | Precision | Not Null | Comments | Referred Table |
|---|---|---|---|---|---|---|
| INTEGRATION_ID | VARCHAR2 | 80 CHAR | True | This column is the unique identifier of a dimension or fact entity in its source system. In case of composite keys, the value in this column can consist of concatenated parts. | ||
| ALLOC_TYPE_WID | NUMBER | 38 | Identify the allocation type, there could be further sub-classifications to these allocation type.The column is populated by DW_EB_X_EBS_COMMON_W_XACT_TYPE_D. Example: 'Direct Cost Line', 'Allocated Cost Line'. | |||
| AUX1_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX2_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX3_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| AUX4_CHANGED_ON_DT | TIMESTAMP | 6 | Siebel System field. This column identifies the last modified date and time of the auxiliary table's record which acts as a source for the current table. | |||
| BALANCING_SEGMENT_WID | NUMBER | 38 | BALANCING_SEGMENT_WID | |||
| BUSN_AREA_ORG_WID | NUMBER | 38 | Identify the business area incurring this cost. This column is populated by DW_EB_X_EBS_COMMON_W_INT_ORG_D with class type as 'BUSN_AREA'. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| CHANGED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who last modified the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CHANGED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was last modified in the source system. | |||
| CHNL_TYPE_WID | NUMBER | 38 | Identify the sales channel type which the cost allocation is associated to, sales channel can be indirect or direct. This column is populated by DW_EB_X_EBS_COMMON_W_CHNL_TYPE_D. | |||
| CMPGN_EPISODE_WID | NUMBER | 38 | Identify the campaign episode which the cost allocation is associated to. This column is populated by W_SOURCE_D. | |||
| CNTCT_REP_ORG_WID | NUMBER | 38 | Identify the contact representative incurring this cost. The column is populated by DW_EB_X_EBS_COMMON_W_INT_ORG_D with class type as 'CNTCT_GRP'. | |||
| COMPANY_ORG_WID | NUMBER | 38 | Identify the company organization incurring this cost. This column is populated by DW_EB_X_EBS_COMMON_W_INT_ORG_D with class type as 'COMPANY' | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| COST_CENTER_WID | NUMBER | 38 | Identify the cost center which the cost is allocated to. This column is populated by DW_EB_X_EBS_COMMON_W_COST_CENTER_D. | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| COST_LINE_DOC_ITEM | NUMBER | 15 | Identify the document item number associated with this cost. | |||
| COST_LINE_DOC_NUM | VARCHAR2 | 30 CHAR | Identify the document header number associated with this cost. | |||
| COST_LINE_DOC_SUB_ITEM | NUMBER | 15 | Identify the document sub item number associated with this cost. | |||
| COST_LINE_STATUS_WID | NUMBER | 38 | Identify the status of this cost allocation. This column is populated by DW_EB_X_EBS_COMMON_W_STATUS_D. | DW_EB_X_EBS_COMMON_W_STATUS_D | ||
| COST_LINE_XACT_TYPE_WID | NUMBER | 38 | Identify the cost expenditure type, there could be further sub- classifications to these cost expenditure type. The column is populated by DW_EB_X_EBS_COMMON_W_XACT_TYPE_D. Example: 'Marketing Related Costs', 'Sales Related Costs' etc. | DW_EB_X_EBS_COMMON_W_XACT_TYPE_D | ||
| CREATED_BY_WID | NUMBER | 38 | This is a foreign key to the DW_EB_X_EBS_COMMON_W_USER_D dimension indicating the user who created the record in the source system. | DW_EB_X_EBS_COMMON_W_USER_D | ||
| CREATED_ON_DT | TIMESTAMP | 6 | Identifies the date and time when the record was initially created in the source system. | |||
| CTRL_AREA_ORG_WID | NUMBER | 38 | Identify the control area incurring this cost. This column is populated by DW_EB_X_EBS_COMMON_W_INT_ORG_D with class type as 'CTRL_AREA'. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| DATASOURCE_NUM_ID | NUMBER | 10 | This column is the unique identifier of the source system from which data was extracted. In order to be able to trace the data back to its source, Siebel recommends that you define separate unique source IDs for each of your different source instances. | |||
| DELETE_FLG | VARCHAR2 | 1 CHAR | This flag indicates the deletion status of the record in the source system. A value of "Y" indicates that the record is deleted from the source system and logically deleted from the data warehouse; a value of "N" indicates that the record is active. | |||
| DOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the document currency. This typically is the currency in which the transaction occurred. Amounts will be stored in this currency. | |||
| ETL_PROC_WID | NUMBER | 38 | Siebel System Field. This column is the unique identifier for the specific ETL process used to create or update this data. | |||
| EXPENSED_ON_DT_WID | NUMBER | 38 | Identify the date, in Julian format, on which this cost occurred. This column is populated by DW_EB_X_EBS_COMMON_W_DAY_D. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| FSCL_PERIOD_END_DT_WID | NUMBER | 38 | Identify the end date of the period, in Julian format, in which the cost occurred. This column is populated by DW_EB_X_EBS_COMMON_W_DAY_D. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| FSCL_PERIOD_START_DT_WID | NUMBER | 38 | Identify the start date of the period, in Julian format, in which the cost occurred. This column is populated by DW_EB_X_EBS_COMMON_W_DAY_D. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| GLOBAL1_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the first Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL2_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the second Global Currency. The Global currencies are defined in global currency master table. | ||||
| GLOBAL3_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the third Global Currency. The Global currencies are defined in global currency master table. | ||||
| GL_ACCOUNT_WID | NUMBER | 38 | Identify the GL Account which the cost is allocated to. This column is populated by DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D. | |||
| GL_DATASET_SEC_WID | NUMBER | 38 | GL_DATASET_SEC_WID | |||
| LEDGER_WID | NUMBER | 38 | Key to Ledger Dimension | DW_EB_X_EBS_COMMON_W_LEDGER_D | ||
| LOC_CURR_CODE | VARCHAR2 | 30 CHAR | This code corresponds to the local currency. The local currency typically is the one in which the transaction will be posted to meet legal requirements for Company's Financial reporting. Alternatively, it may be linked to the currency used by local/regional business units for reporting purposes. | |||
| LOC_EXCHANGE_RATE | NUMBER | This is the exchange rate from Document Currency to the Local Currency. | ||||
| MCAL_CAL_WID | NUMBER | 38 | Identify fiscal calendars. | DW_EB_X_EBS_COMMON_W_MCAL_CAL_D | ||
| NATURAL_ACCOUNT_WID | NUMBER | 38 | ||||
| POSTED_ON_DT_WID | NUMBER | 38 | Identify the date, in Julian format, on which this cost is posted. This column is populated by DW_EB_X_EBS_COMMON_W_DAY_D. | DW_EB_X_EBS_COMMON_W_DAY_D | ||
| PRODUCT_SCD1_WID | NUMBER | 38 | ||||
| PRODUCT_WID | NUMBER | 38 | Identify the product for which we're tracking the cost. This column is populated by DW_EB_X_EBS_COMMON_W_PRODUCT_D. | DW_EB_X_EBS_COMMON_W_PRODUCT_D | ||
| PROD_COST_AMT | NUMBER | 38,10 | Identify the product cost amount in document currency. | |||
| PROFIT_CENTER_WID | NUMBER | 38 | Identify the profit center which is associated with this cost. This column is populated by DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D. | DW_EB_X_EBS_COMMON_W_PROFIT_CENTER_D | ||
| PURCH_INVOICE_ITEM | NUMBER | 15 | Identify the purchase invoice item number associated with this cost. | |||
| PURCH_INVOICE_NUM | VARCHAR2 | 30 CHAR | Identify the purchase invoice number associated with this cost. | |||
| PURCH_ORDER_ITEM | NUMBER | 15 | Identify the purchase order item number associated with this cost. | |||
| PURCH_ORDER_NUM | NUMBER | 15 | Identify the purchase order number associated with this cost. | |||
| PURCH_ORG_WID | NUMBER | 38 | Identify the Purchasing Organization incurring this cost. This column is populated by DW_EB_X_EBS_COMMON_W_INT_ORG_D with class type as 'PURCH'. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SALES_GROUP_ORG_WID | NUMBER | 38 | Identify the sales group incurring this cost. The column is populated by DW_EB_X_EBS_COMMON_W_INT_ORG_D with class type as 'SALES_GROUP'. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SALES_OFC_LOC_WID | NUMBER | 38 | Identify the sales office location incurring this cost. The column is populated by W_BUSN_LOCATION with class type as 'SALES_OFFICE'. | DW_EB_X_EBS_COMMON_W_BUSN_LOCATION_D | ||
| SALES_ORG_WID | NUMBER | 38 | Identify the sales organization incurring this cost. The column is populated by DW_EB_X_EBS_COMMON_W_INT_ORG_D with class type as 'SALES_ORG'. | DW_EB_X_EBS_COMMON_W_INT_ORG_D | ||
| SEGMENT_WID | NUMBER | 38 | Identify the customer segment which the cost allocation is associated to. This column is populated by W_SEGMENT_D. | |||
| SRC_COST_CENTER_WID | NUMBER | 38 | Identify the cost center which the cost is allocated from. This column is populated by DW_EB_X_EBS_COMMON_W_COST_CENTER_D. | DW_EB_X_EBS_COMMON_W_COST_CENTER_D | ||
| SRC_GL_ACCOUNT_WID | NUMBER | 38 | Identify the GL Account which the cost allocated from. This column is populated by DW_EB_X_EBS_COMMON_W_GL_ACCOUNT_D. | |||
| SUPPLIER_WID | NUMBER | 38 | Identify the supplier supplying the material. This column is populated by W_SUPPLIER_D. | |||
| TENANT_ID | VARCHAR2 | 80 CHAR | This column is the unique identifier for a Tenant in a multi-tenant environment. This would typically be used in an Application Service Provider (ASP) / Software As a Service (SOAS) model. | |||
| TERR_WID | NUMBER | 38 | Identify the sales region incurring this cost. The column is populated by DW_EB_X_EBS_COMMON_W_INT_ORG_D with class type as 'SALES_REGION'. | DW_EB_X_EBS_PR_W_TERR_D | ||
| UOM_CODE | VARCHAR2 | 50 CHAR | Identify the Unit of Measure of the quantity. | |||
| XACT_QTY | NUMBER | 28,10 | Identify the quantity associated with this cost. | |||
| X_CUSTOM | VARCHAR2 | 10 CHAR | This column is used as a generic field for customer extensions. | |||
| W$_INSERT_DT | TIMESTAMP | 6 | ||||
| W$_UPDATE_DT | TIMESTAMP | 6 |