G Appendix: Tables List
The following table contains list of the entities and the corresponding tables supported by the Data Conversion Tool.
| Entity Name | Table Name |
|---|---|
|
CORE |
|
|
BANNERS_CHANNELS |
BANNER |
|
BANNER_TL |
|
|
CHANNELS |
|
|
CHANNELS_TL |
|
|
TSFZONE |
TSFZONE |
|
TSFZONE_TL |
|
|
COST_COMPONENTS |
ELC_COMP |
|
ELC_COMP_TL |
|
|
ELC_COMP_CFA_EXT |
|
|
HTS_SETUP_DATA |
HTS_IMPORT_COUNTRY_SETUP |
|
OGA |
|
|
OGA_TL |
|
|
TARIFF_TREATMENT |
|
|
TARIFF_TREATMENT_TL |
|
|
COUNTRY_TARIFF_TREATMENT |
|
|
QUOTA_CATEGORY |
|
|
QUOTA_CATEGORY_TL |
|
|
HTS_CHAPTER |
|
|
HTS_CHAPTER_TL |
|
|
HTS_CHAPTER_RESTRAINTS |
|
|
HTS_CHAPTER_RESTRAINTS_TL |
|
|
HTS_DEFINITION_DATA |
HTS |
|
HTS_TL |
|
|
HTS_TARIFF_TREATMENT |
|
|
HTS_TT_EXCLUSIONS |
|
|
HTS_TARIFF_TREATMENT_ZONE |
|
|
HTS_FEE |
|
|
HTS_FEE_ZONE |
|
|
HTS_TAX |
|
|
HTS_TAX_ZONE |
|
|
HTS_AD |
|
|
HTS_CVD |
|
|
HTS_REFERENCE |
|
|
HTS_OGA |
|
|
COMPHEAD |
COMPHEAD |
|
COMPHEAD_TL |
|
|
OUTLOC |
OUTLOC |
|
OUTLOC_TL |
|
|
BUYER_MERCHANT |
BUYER |
|
MERCHANT |
|
|
CVB_HEAD |
CVB_HEAD |
|
CVB_HEAD_TL |
|
|
CVB_DETAIL |
|
|
DIFF_ID |
DIFF_TYPE |
|
DIFF_TYPE_TL |
|
|
DIFF_IDS |
|
|
DIFF_IDS_TL |
|
|
DIFF_TYPE_CFA_EXT |
|
|
FREIGHT_TERMS |
FREIGHT_TERMS |
|
FREIGHT_TERMS_TL |
|
|
TERMS_HEAD |
|
|
TERMS_HEAD_TL |
|
|
TERMS_DETAIL |
|
|
FREIGHT_TYPE |
FREIGHT_SIZE |
|
FREIGHT_SIZE_TL |
|
|
FREIGHT_TYPE |
|
|
FREIGHT_TYPE_TL |
|
|
VAT |
VAT_CODES |
|
VAT_CODES_TL |
|
|
VAT_CODE_RATES |
|
|
VAT_REGION |
|
|
VAT_REGION_TL |
|
|
VAT_CODES_CFA_EXT |
|
|
TICKET_TYPE |
TICKET_TYPE_HEAD |
|
TICKET_TYPE_DETAIL |
|
|
TICKET_TYPE_HEAD_TL |
|
|
FIF_GL_SETUP |
FIF_GL_SETUP |
|
ORG_UNIT |
ORG_UNIT |
|
ORG_UNIT_TL |
|
|
TSF |
TSF_ENTITY |
|
TSF_ENTITY_ORG_UNIT_SOB |
|
|
TSF_ENTITY_TL |
|
|
BRAND |
BRAND |
|
BRAND_TL |
|
|
DIFF_RATIO |
DIFF_RATIO_HEAD |
|
DIFF_RATIO_DETAIL |
|
|
DIFF_GROUP |
DIFF_GROUP_HEAD |
|
DIFF_GROUP_DETAIL |
|
|
DIFF_RANGE |
DIFF_RANGE_HEAD |
|
DIFF_RANGE_DETAIL |
|
|
COUNTRY_ATTRIB |
COUNTRY_ATTRIB |
|
COUNTRY_TL |
|
|
CURRENCY_RATES |
CURRENCIES |
|
CURRENCIES_TL |
|
|
CURRENCY_RATES |
|
|
INV_STATUS_ADJ_REASON |
INV_STATUS_TYPES |
|
INV_STATUS_TYPES_TL |
|
|
INV_STATUS_CODES |
|
|
INV_STATUS_CODES_TL |
|
|
INV_ADJ_REASON |
|
|
FIF_GL_ACCT |
FIF_GL_ACCT |
|
MERCHANDISING HIERARCHY |
|
|
DIVISION |
DIVISION |
|
DIVISION_TL |
|
|
GROUPS |
GROUPS |
|
GROUPS_TL |
|
|
DEPS |
DEPS |
|
VAT_DEPS |
|
|
DEPS_CFA_EXT |
|
|
DEPS_TL |
|
|
CLASS |
CLASS |
|
CLASS_CFA_EXT |
|
|
CLASS_TL |
|
|
SUBCLASS |
SUBCLASS |
|
SUBCLASS_CFA_EXT |
|
|
SUBCLASS_TL |
|
|
ORGANIZATIONAL HIERARCHY |
|
|
CHAIN |
CHAIN |
|
CHAIN_TL |
|
|
AREA |
AREA |
|
AREA_TL |
|
|
REGION |
REGION |
|
REGION_TL |
|
|
DISTRICT |
DISTRICT |
|
DISTRICT_TL |
|
|
STORE_FORMAT |
STORE_FORMAT |
|
STORE_FORMAT_TL |
|
|
STORE_ADD |
STORE_ADD |
|
ADDR |
|
|
STORE_CFA_EXT |
|
|
ADDR_CFA_EXT |
|
|
WAREHOUSE |
WH |
|
ADDR |
|
|
WH_CFA_EXT |
|
|
WH_TL |
|
|
ADDR_CFA_EXT |
|
|
STORE_ADD_WITH_DEFAULT_WH |
STORE_ADD |
|
ADDR |
|
|
STORE_CFA_EXT |
|
|
ADDR_CFA_EXT |
|
|
WAREHOUSE_WT_PRICING_STORE |
WH |
|
ADDR |
|
|
WH_CFA_EXT |
|
|
WH_TL |
|
|
ADDR_CFA_EXT |
|
|
TRANSIT_TIMES |
TRANSIT_TIMES |
|
WH_DEPT |
WH_DEPT |
|
WH_DEPT_EXPL |
|
|
PRICING |
|
|
RPM_ZONE_GROUP |
RPM_ZONE_GROUP |
|
RPM_MERCH_RETAIL_DEF |
RPM_MERCH_RETAIL_DEF |
|
RPM_ZONE |
RPM_ZONE |
|
RPM_ZONE_LOCATION |
RPM_ZONE_LOCATION |
|
MULTIPLE SET OF BOOKS |
|
|
PARTNER_ORG_UNIT |
PARTNER_ORG_UNIT |
|
FIF_GL_CROSS_REF |
FIF_GL_CROSS_REF |
|
SUPPLIERS |
|
|
PARTNER |
PARTNER |
|
PARTNER_TL |
|
|
ADDR |
|
|
PARTNER_CFA_EXT |
|
|
ADDR_CFA_EXT |
|
|
SUPS |
SUPS_TL |
|
SUPS |
|
|
ADDR |
|
|
SUPS_CFA_EXT |
|
|
ADDR_CFA_EXT |
|
|
SUP_IMPORT_ATTR |
SUP_IMPORT_ATTR |
|
SUP_INV_MGMT |
SUP_INV_MGMT |
|
SUP_REPL_DAY |
|
|
SUP_BRACKET_COST |
SUP_BRACKET_COST |
|
SOURCE_DLVRY_SCHED |
SOURCE_DLVRY_SCHED |
|
SOURCE_DLVRY_SCHED_DAYS |
|
|
SOURCE_DLVRY_SCHED_EXC |
|
|
ITEMS |
|
|
ITEM |
ITEM_MASTER |
|
ITEM_SUPPLIER |
|
|
ITEM_SUPP_COUNTRY |
|
|
ITEM_SUPP_COUNTRY_DIM |
|
|
ITEM_SUPP_MANU_COUNTRY |
|
|
ITEM_SUPP_UOM |
|
|
PACKITEM |
|
|
VAT_ITEM |
|
|
UDA_ITEM_LOV |
|
|
UDA_ITEM_DATE |
|
|
UDA_ITEM_FF |
|
|
ITEM_SEASONS |
|
|
ITEM_IMAGE |
|
|
ITEM_MASTER_TL |
|
|
ITEM_IMAGE_TL |
|
|
ITEM_MASTER_CFA_EXT |
|
|
ITEM_SUPPLIER_CFA_EXT |
|
|
ITEM_SUPP_COUNTRY_CFA_EXT |
|
|
ITEM_HTS |
|
|
ITEM_HTS_ASSESS |
|
|
ITEM_EXP |
|
|
RPM_ITEM_ZONE_PRICE |
RPM_ITEM_ZONE_PRICE |
|
ITEM_CHARGES |
ITEM_CHRG_HEAD |
|
ITEM_CHRG_DETAIL |
|
|
DC_ITEM |
ITEM_MASTER |
|
ITEM_SUPPLIER |
|
|
ITEM_SUPP_COUNTRY |
|
|
ITEM_SUPP_COUNTRY_DIM |
|
|
ITEM_SUPP_MANU_COUNTRY |
|
|
ITEM_SUPP_UOM |
|
|
PACKITEM |
|
|
ITEM_MASTER_TL |
|
|
ITEM_MASTER_CFA_EXT |
|
|
ITEM_SUPPLIER_CFA_EXT |
|
|
ITEM_SUPP_COUNTRY_CFA_EXT |
|
|
PACKITEM_BREAKOUT |
|
|
PACKITEM_BREAKOUT |
PACKITEM_BREAKOUT |
|
PRICE_HIST |
PRICE_HIST |
|
INSERT_RIZP |
RPM_ITEM_ZONE_PRICE |
|
ITEM_LOC_RANGING |
NIL_DETAIL |
|
NIL_TRAIT |
|
|
ITEM_LOC |
ITEM_LOC |
|
ITEM_LOC_CFA_EXT |
|
|
ITEM_TICKET |
ITEM_TICKET |
|
RELATED_ITEM |
RELATED_ITEM_HEAD |
|
RELATED_ITEM_DETAIL |
|
|
ITEM_UDA |
UDA_ITEM_DATE |
|
UDA_ITEM_FF |
|
|
UDA_ITEM_LOV |
|
|
VAT_ITEM |
VAT_ITEM |
|
ITEM_IMAGE |
ITEM_IMAGE |
|
ITEM_IMAGE_TL |
|
|
PACK_TEMPLATES |
PACK_TMPL_HEAD |
|
PACK_TMPL_DETAIL |
|
|
ITEM_SEASONS |
ITEM_SEASONS |
|
ITEM_EXPENSES |
ITEM_EXP |
|
SUB_ITEMS |
SUB_ITEMS_HEAD |
|
SUB_ITEMS_DETAIL |
|
|
ITEM_FORECAST |
ITEM_FORECAST |
|
ITEM_HTS |
ITEM_HTS |
|
ITEM_HTS_ASSESS |
|
|
MASTER_REPL_ATTR |
MASTER_REPL_ATTR |
|
ITEM_RANGING |
NIL_DETAIL_R |
|
ITEM_LOC_TRAITS |
ITEM_LOC_TRAITS |
|
ITEM_SUPP_COUNTRY_LOC_CFA_EXT |
ITEM_SUPP_COUNTRY_LOC_CFA_EXT |
|
PURCHASING |
|
|
CREATE_PURCHASE_ORDERS |
ORDHEAD |
|
ORDDETAIL |
|
|
ORDLC |
|
|
ORDLOC_EXP |
|
|
ORDSKU_HTS |
|
|
ORDSKU_HTS_ASSESS |
|
|
ORDHEAD_CFA_EXT |
|
|
ORDLOC_CFA_EXT |
|
|
ORDSKU_CFA_EXT |
|
|
SHIP_PURCHASE_ORDERS |
ASNIN_HEAD |
|
ASNIN_PO |
|
|
ASNIN_CTN |
|
|
ASNIN_ITEM |
|
|
RECEIVE_PURCHASE_ORDERS |
PO_RECEIPT_HEAD |
|
PO_RECEIPT_DETAIL |
|
|
CLOSE_PURCHASE_ORDERS |
ORDHEAD |
|
CREATE_CUSTOMER_ORDERS |
FULFILL_ORD_HEAD |
|
FULFILL_ORD_CUST_DTL |
|
|
FULFILL_ORD_DTL |
|
|
SHIP_CUSTOMER_ORDERS |
ASNOUT_HEAD |
|
ASNOUT_DISTRO |
|
|
ASNOUT_CTN |
|
|
ASNOUT_ITEM |
|
|
RECEIVE_CUSTOMER_ORDERS |
TSF_RECEIPT_HEAD |
|
TSF_RECEIPT_DETAIL |
|
|
TSF_RECEIPT_CTN |
|
|
SALES HISTORY |
|
|
ITEM_LOC_HIST |
ITEM_LOC_HIST |
|
COST CHANGE |
|
|
COST_CHANGE |
COST_SUSP_SUP_HEAD |
|
COST_SUSP_SUP_DETAIL |
|
|
COST_SUSP_SUP_DETAIL_LOC |
|
|
PRICING CLEARANCES |
|
|
RPM_CLEARANCE |
RPM_CLEARANCE_DETAIL |