B Context File Table Reference

The following table maps CSV data files to internal tables for the purpose of creating Context Files. The first parameter on the Context file is a TABLE property containing the table name into which the CSV data will be loaded. For legacy context file usage, the name of the context file itself should match the internal table name.

File Type Filenames Internal Tables

Product

PRODUCT.csv

W_PRODUCT_DTS

Organization

ORGANIZATION.csv

W_INT_ORG_DTS

Calendar

CALENDAR.csv

W_MCAL_PERIODS_DTS

Exchange Rates

EXCH_RATE.csv

W_EXCH_RATE_DTS

Attributes

ATTR.csv

W_ATTR_DTS

Diff Groups

DIFF_GROUP.csv

W_DIFF_GROUP_DTS

Product Attribute Assignments

PROD_ATTR.csv

W_PRODUCT_ATTR_DTS

Employee

EMPLOYEE.csv

W_EMPLOYEE_DTS

Application Codes

CODES.csv

W_RTL_CODE_DTS

Pack Items

PROD_PACK.csv

W_RTL_ITEM_GRP2_DTS

Promotions

PROMOTION.csv

W_RTL_PROMO_EXT_DTS

Supplier

SUPPLIER.csv

W_SUPPLIER_DTS

Item Loc Attributes

PROD_LOC_ATTR.csv

W_PROD_LOC_ATTR_DTS

Replenishment Attributes

PROD_LOC_REPL.csv

W_INVENTORY_PRODUCT_ATTR_DTS

Season Phase

SEASON.csv

W_RTL_SEASON_PHASE_DTS

Season Phase Item Mapping

PROD_SEASON.csv

W_RTL_SEASON_PHASE_IT_DTS

Comp Stores

STORE_COMP.csv

W_RTL_LOC_COMP_MTX_DTS

Item Deletes

PROD_DELETE.csv

W_RTL_ITEM_DEL_TMPS

Item Loc Deletes

PROD_LOC_DELETE.csv

W_RTL_IT_LC_DEL_TMPS

Item Reclass

PROD_RECLASS.csv

W_PROD_RECLASS_TMPS

Sales

SALES.csv

W_RTL_SLS_TRX_IT_LC_DY_FTS

Sales Pack

SALES_PACK.csv

W_RTL_SLSPK_IT_LC_DY_FTS

Inventory

INVENTORY.csv

W_RTL_INV_IT_LC_DY_FTS

Markdown

MARKDOWN.csv

W_MARKDOWN_FTS

On Order

ORDER_HEAD.csv

W_ORDER_HEAD_FTS

On Order Detail

ORDER_DETAIL.csv

W_ORDER_DETAIL_FTS

PO Receipts

RECEIPT.csv

W_RECEIPT_FTS

Transfers

TRANSFER.csv

W_RTL_INVTSF_IT_LC_DY_FTS

Adjustments

ADJUSTMENT.csv

W_ADJUSTMENT_FTS

RTVs

RTV.csv

W_RTL_INVRTV_IT_LC_DY_FTS

Costs

COST.csv

W_COST_FTS

Prices

PRICE.csv

W_RTL_PRICE_IT_LC_DY_FTS

W/F Sales and Fees

SALES_WF.csv

W_RTL_SLSWF_IT_LC_DY_FTS

Vendor Funds

DEAL_INCOME.csv

W_RTL_DEALINC_IT_LC_DY_FTS

Reclass In/Out

INV_RECLASS.csv

W_RTL_INVRECLASS_IT_LC_DY_FTS

Intercompany Margin

IC_MARGIN.csv

W_RTL_ICM_IT_LC_DY_FTS