Mirror of Oracle documentation
Converted for search and offline reading. Authoritative source: Oracle. Diagrams and some complex tables are simplified — check the PDF when in doubt.
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 |
June 3, 2026 Appendix G-1 of G-7
Appendix G
| Entity Name | Table Name |
|---|---|
| HTS_REFERENCE | |
| HTS_OGA | |
| COMPHEAD | COMPHEAD |
| COMPHEAD_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 | |
| OUTLOC | OUTLOC |
| OUTLOC_TL | |
| 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 |
June 3, 2026 Appendix G-2 of G-7
Appendix G
| Entity Name | Table Name |
|---|---|
| BRAND_TL | |
| DIFF_RATIO | DIFF_RATIO_HEAD |
| DIFF_RATIO_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 |
June 3, 2026 Appendix G-3 of G-7
Appendix G
| Entity Name | Table Name |
|---|---|
| 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 | |
| DIFF_GROUP | DIFF_GROUP_HEAD |
| DIFF_GROUP_DETAIL | |
| DIFF_RANGE | DIFF_RANGE_HEAD |
| DIFF_RANGE_DETAIL | |
| 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 |
June 3, 2026 Appendix G-4 of G-7
Appendix G
| Entity Name | Table Name |
|---|---|
| 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 | |
| COND_TARIFF_TREATMENT | |
| 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 |
June 3, 2026 Appendix G-5 of G-7
Appendix G
| Entity Name | Table Name |
|---|---|
| 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 | |
| COND_TARIFF_TREATMENT | |
| MASTER_REPL_ATTR | MASTER_REPL_ATTR |
| ITEM_RANGING | NIL_DETAIL_R |
| ITEM_LOC_TRAITS | ITEM_LOC_TRAITS |
| ITEM_SUPP_COUNTRY_LOC_CFA_EXT PURCHASING | ITEM_SUPP_COUNTRY_LOC_CFA_EXT |
June 3, 2026 Appendix G-6 of G-7
Appendix G
| Entity Name | Table Name |
|---|---|
| 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 |
June 3, 2026 Appendix G-7 of G-7
In this guide
- Guide: Merchandising Cloud Services Data Conversion Implementation Guide
- Previous: F Appendix: Publication Tables and Triggers
- Next: H Appendix: Uploaded Files
Related chapters
- 3 Custom Validation Rules — Merchandising Cloud Services Customization and Extension Guide · shares
CLASS_CFA_EXT,DEPS_CFA_EXT,ITEM_CHRG_DETAIL,ITEM_CHRG_HEAD - F Appendix: Publication Tables and Triggers — Merchandising Cloud Services Data Conversion Implementation Guide · shares
ADDR_CFA_EXT,CLASS_CFA_EXT,DEPS_CFA_EXT,DIFF_GROUP_DETAIL - D Appendix: Best Practices — Merchandising Cloud Services Data Conversion Implementation Guide · shares
DC_ITEM,INSERT_RIZP,ITEM_EXPENSES,ITEM_HTS - 5 ReSTful Web Services — Inbound and Outbound Integration Guide · shares
ADDR_CFA_EXT,CLASS_CFA_EXT,COST_SUSP_SUP_DETAIL,COST_SUSP_SUP_DETAIL_LOC - 3 Foundation Data Maintenance — Batch Operations Guide · shares
COUNTRY_ATTRIB,CURRENCY_RATES,DIFF_RATIO_DETAIL,ITEM_HTS_ASSESS - 2 Administration Batch — Batch Operations Guide · shares
COND_TARIFF_TREATMENT,COST_SUSP_SUP_DETAIL,DIFF_RATIO_DETAIL,DIFF_RATIO_HEAD