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 |
Product Alternates |
PRODUCT_ALT.csv |
W_PRODUCT_ALT_DTS |
Organization |
ORGANIZATION.csv |
W_INT_ORG_DTS |
Organization Alternates |
ORGANIZATION_ALT.csv |
W_ORGANIZATION_ALT_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 |
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 |
Inventory Packs |
INVENTORY_PACK.csv |
W_RTL_INVPK_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 |