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 |