FILE_PRODUCT_COST_LINE_FS Dataset

The FILE_PRODUCT_COST_LINE_FS inline dataset loads product cost transactions into the W_PRODUCT_COST_LINE_F fact table.

Columns are categorized into four types, as follows:

• • Integration_I — this is a unique identifier to the individual rows in the file.

  • FK_ID — this should be the integration ID of the corresponding Dimension. For example, PRODUCT_ID, which should be populated by the Integration ID of the Product dimension.

  • Amount Columns — for example, CUST_COST_AMT, Amount for the particular transaction line.

  • Attribute Columns — for example, COST_LINE_DOC_ITEM, COST_LINE_DOC_SUB_ITEM, EXPENSED_ON_DT and so on. While inserting data for the _DT columns, we need to make sure that the data is entered in YYYY-MM-DD HH24:MI:SS format. For example: 2026-02-11 14:20:00