This staging table is used by the ep_load_main procedure. Each record corresponds to a unique item entity based on all lowest item levels in the model. For information on the hierarchy, see "Item Levels".
| Name | Type | Purpose |
|---|---|---|
| EQ_UNIT | NUMBER(20,10) | Conversion ratio between units and equivilant units |
| T_EP_I_ATT_1 | VARCHAR2(100) | Item Description |
| T_EP_I_ATT_2 | VARCHAR2(100) | Franchise, not used in PTP model, may have N/A |
| T_EP_I_ATT_3 | VARCHAR2(100) | Genre, not used in PTP model, may have N/A |
| T_EP_I_ATT_4 | VARCHAR2(100) | Platform, not used in PTP model, may have N/A |
| T_EP_I_ATT_5 | VARCHAR2(100) | Rating, not used in PTP model, may have N/A |
| T_EP_I_ATT_6 | VARCHAR2(100) | Release Month, not used in PTP model, may have N/A |
| T_EP_I_ATT_7 | VARCHAR2(100) | UPC Code, not used in PTP model, may have N/A |
| T_EP_I_ATT_8 | VARCHAR2(100) | Media Type, not used in PTP model, may have N/A |
| T_EP_I_ATT_9 | VARCHAR2(100) | Product size, not used in PTP model, may have N/A |
| T_EP_I_ATT_10 | VARCHAR2(100) | Product Weight, not used in PTP model, may have N/A |
| T_EP_P1 | VARCHAR2(100) | Parent model information |
| T_EP_P2 | VARCHAR2(100) | Product Subgroup level information |
| T_EP_P2A | VARCHAR2(100) | Brand level information |
| T_EP_P2A1 | VARCHAR2(100) | Segment level information |
| T_EP_P2A2 | VARCHAR2(100) | Category level information |
| T_EP_P2B | VARCHAR2(100) | Promotion Group level information |
| T_EP_P3 | VARCHAR2(100) | Product Group level information |
| T_EP_P4 | VARCHAR2(100) | Product Line level information |
| DM_ITEM_CODE | VARCHAR2(240) | Item Level Code |
| DM_ITEM_DESC | VARCHAR2(240) | Item Level Description |
| E1_PLANNING_UOM | VARCHAR2(100) | Unit of measure of E1 demand plan |
| E1_SHIPPING_UOM | VARCHAR2(100) | Unit of measure E1 shipped |
| E1_SHIPPING_UOM_MULTIPLE | NUMBER(20,10) | Conversion factor to E1 Shipping UOM |
| E1_WEIGHT_UOM | VARCHAR2(100) | E1 weight of 1 UOM |
| E1_WEIGHT_UOM_MULTIPLE | NUMBER(20,10) | Conversion factor to E1 weight UOM |
| E1_VOLUME_UOM | VARCHAR2(100) | E1 weight of 1 UOM |
| E1_VOLUME_UOM_MULTIPLE | NUMBER(20,10) | Conversion factor to E1 volume UOM |
| E1_PRIMARY_UOM | VARCHAR2(100 | E1 primary UOM |
| E1_PRIMARY_PLANNING_FACTOR | NUMBER(20,10) | Conversion of E1 primary UOM to planning units |
| E1_ITEM_CATEGORY_1 | VARCHAR2(100) | Item Category from E1 to Demantra |
| E1_ITEM_CATEGORY_2 | VARCHAR2(100) | Item Category from E1 to Demantra |
| E1_ITEM_CATEGORY_3 | VARCHAR2(100) | Item Category from E1 to Demantra |
| E1_ITEM_CATEGORY_4 | VARCHAR2(100) | Item Category from E1 to Demantra |
| E1_ITEM_CATEGORY_5 | VARCHAR2(100) | Item Category from E1 to Demantra |
| E1_ITEM_CATEGORY_6 | VARCHAR2(100) | Item Category from E1 to Demantra |
| E1_ITEM_CATEGORY_7 | VARCHAR2(100) | Item Category from E1 to Demantra |
| E1_ITEM_CATEGORY_8 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_9 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_10 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_11 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_12 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_13 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_14 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_15 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_16 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_17 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_18 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_19 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_20 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_21 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_22 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| E1_ITEM_CATEGORY_23 | VARCHAR2(100) | Placeholder for E1 Category code. Currently not loaded |
| EBS_ACCOUNT_DESC | VARCHAR2(240) | EBS Account description |
| EBS_PRODUCT_CATEGORY_CODE | VARCHAR2(240) | Product Category level code |
| EBS_PRODUCT_CATEGORY_DESC | VARCHAR2(240) | Product Category level description |
| EBS_PRODUCT_FAMILY_CODE | VARCHAR2(240) | Product Family level code |
| EBS_PRODUCT_FAMILY_DESC | VARCHAR2(240) | Product Family level description |
| EBS_DEMAND_CLASS_CODE | VARCHAR2(240) | Demand Class code |
| EBS_DEMAND_CLASS_DESC | VARCHAR2(240) | Demand Class Description |
| EBS_ITEM_DEST_KEY | NUMBER(10) | Item Destination Key- Numeric |
| EBS_DEMAND_CLASS_DEST_KEY | NUMBER(10) | Demand Class Destination Key- Numeric |
This staging table is used by the ep_load_main procedure. Each record corresponds to a unique location entity based on all lowest item levels in the model. For information on the hierarchy, see "Location Levels".
| Name | Type | Purpose |
|---|---|---|
| LR1_ATTR1 | VARCHAR2(100) | Generic Retailer Attribute 1 |
| LR1_ATTR2 | VARCHAR2(100) | Generic Retailer Attribute 2 |
| T_EP_L_ATT_1 | VARCHAR2(100) | Store Size, Not used in PTP, default to N/A |
| T_EP_L_ATT_2 | VARCHAR2(100) | Store Classification, Not used in PTP, default to N/A |
| T_EP_L_ATT_3 | VARCHAR2(100) | Store Type, Not used in PTP, default to N/A |
| T_EP_L_ATT_4 | VARCHAR2(100) | Customer Segment, Not used in PTP, default to N/A |
| T_EP_L_ATT_5 | VARCHAR2(100) | Store Manager, Not used in PTP, default to N/A |
| T_EP_L_ATT_6 | VARCHAR2(100) | Store Language, Not used in PTP, default to N/A |
| T_EP_L_ATT_7 | VARCHAR2(100) | Store Revenue Class, Not used in PTP, default to N/A |
| T_EP_L_ATT_8 | VARCHAR2(100) | Site Zip Code, Not used in PTP, default to N/A |
| T_EP_L_ATT_9 | VARCHAR2(100) | Store Demographic, Not used in PTP, default to N/A |
| T_EP_L_ATT_10 | VARCHAR2(100) | Site City - Not used in PTP, default to N/A |
| T_EP_LR1 | VARCHAR2(100) | Supplier Code for RTS |
| T_EP_LR2 | VARCHAR2(100) | Bill-To code |
| T_EP_LR2A | VARCHAR2(100) | Retailer information |
| T_EP_LS1 | VARCHAR2(100) | Territory Information |
| T_EP_LS2 | VARCHAR2(100) | District Information |
| T_EP_LS3 | VARCHAR2(100) | Region Information |
| T_EP_LS4 | VARCHAR2(100) | Sales Area Information |
| T_EP_LS5 | VARCHAR2(100) | Division Information |
| T_EP_LS6 | VARCHAR2(100) | Company Information |
| DM_SITE_CODE | VARCHAR2(240) | Site level code |
| DM_SITE_DESC | VARCHAR2(240) | Site level description |
| DM_ORG_CODE | VARCHAR2(240) | Organization level code |
| DM_ORG_DESC | VARCHAR2(240) | Organization level description |
| E1_BRANCH_CITY | VARCHAR2(100) | E1 Branch information City |
| E1_BRANCH_STATE | VARCHAR2(100) | E1 Branch information State |
| E1_BRANCH_COUNTR | VARCHAR2(100) | E1 Branch information County |
| E1_BRANCH_ZIP_CODE | VARCHAR2(100) | E1 Branch information Zip Code |
| E1_BRANCH_CATEGORY_1 | VARCHAR2(100) | E1 Branch Category Code |
| E1_BRANCH_CATEGORY_2 | VARCHAR2(100) | E1 Branch Category Code |
| E1_BRANCH_CATEGORY_3 | VARCHAR2(100) | E1 Branch Category Code |
| E1_BRANCH_CATEGORY_4 | VARCHAR2(100) | E1 Branch Category Code |
| E1_BRANCH_CATEGORY_5 | VARCHAR2(100) | E1 Branch Category Code |
| E1_BRANCH_CATEGORY_6 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_7 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_8 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_9 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_10 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_11 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_12 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_13 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_14 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_15 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_16 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_17 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_18 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_19 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_20 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_21 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_22 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_23 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_24 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_25 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_26 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_27 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_28 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_29 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_BRANCH_CATEGORY_30 | VARCHAR2(100) | Placeholder for E1 Branch Category code. Not loaded |
| E1_CUSTOMER_CITY | VARCHAR2(100) | E1 Customer information city |
| E1_CUSTOMER_STATE | VARCHAR2(100) | E1 Customer information state |
| E1_CUSTOMER_COUNTRY | VARCHAR2(100) | E1 Customer information county |
| E1_CUSTOMER_BUSINESS_UNIT | VARCHAR2(100) | E1 Customer information business unit |
| E1_CUSTOMER_MAILING_NAME | VARCHAR2(100) | E1 Customer information mailing name |
| E1_CUSTOMER_ZIP_CODE | VARCHAR2(100) | E1 Customer information zip code |
| E1_CUSTOMER_CATEGORY_1 | VARCHAR2(100) | E1 Customer Category Code |
| E1_CUSTOMER_CATEGORY_2 | VARCHAR2(100) | E1 Customer Category Code |
| E1_CUSTOMER_CATEGORY_3 | VARCHAR2(100) | E1 Customer Category Code |
| E1_CUSTOMER_CATEGORY_4 | VARCHAR2(100) | E1 Customer Category Code |
| E1_CUSTOMER_CATEGORY_5 | VARCHAR2(100) | E1 Customer Category Code |
| E1_CUSTOMER_CATEGORY_6 | VARCHAR2(100) | E1 Customer Category Code |
| E1_CUSTOMER_CATEGORY_7 | VARCHAR2(100) | E1 Customer Category Code |
| E1_CUSTOMER_CATEGORY_8 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_9 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_10 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_11 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_12 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_13 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_14 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_15 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_16 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_17 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_18 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_19 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_20 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_21 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_22 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_23 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_24 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_25 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_26 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_27 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_28 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_29 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| E1_CUSTOMER_CATEGORY_30 | VARCHAR2(100) | Placeholder for E1 Customer Category code. Not loaded |
| EBS_TP_ZONE_CODE | VARCHAR2(240) | EBS Trading Partner Zone code |
| EBS_TP_ZONE_DESC | VARCHAR2(240) | EBS Trading Partner Zone description |
| EBS_ZONE_CODE | VARCHAR2(240) | EBS Zone code |
| EBS_ZONE_DESC | VARCHAR2(240) | EBS Zone description |
| EBS_ACCOUNT_CODE | VARCHAR2(240) | EBS Account code |
| EBS_CUSTOMER_CODE | VARCHAR2(240) | EBS Customer code |
| EBS_CUSTOMER_DESC | VARCHAR2(240) | EBS Customer Description |
| EBS_CUSTOMER_CLASS_CODE | VARCHAR2(240) | EBS Customer Class code |
| EBS_CUSTOMER_CLASS_DESC | VARCHAR2(240) | EBS Customer Class Description |
| EBS_OPERATION_UNIT_CODE | VARCHAR2(240) | Unit code for EBS operation |
| EBS_OPERATION_UNIT_DESC | VARCHAR2(240) | Unit description for EBS operation |
| EBS_BUSINESS_GROUP_CODE | VARCHAR2(240) | EBS Business Group code |
| EBS_BUSINESS_GROUP_DESC | VARCHAR2(240) | EBS Business Group description |
| EBS_LEGAL_ENTITY_CODE | VARCHAR2(240) | EBS Legal Entity code |
| EBS_LEGAL_ENTITY_DESC | VARCHAR2(240) | EBS Legal Entity description |
| EBS_SALES_CHANNEL_CODE | VARCHAR2(240) | EBS Sales Channel code |
| EBS_SALES_CHANNEL_DESC | VARCHAR2(240) | EBS Sales Channel description |
| EBS_SITE_DEST_KEY | NUMBER(10) | EBS Site Destination Key - Numeric |
| EBS_ORG_DEST_KEY | NUMBER(10) | EBS Organization Destination Key - Numeric |
| EBS_SALES_CHANNEL_DEST_KEY | NUMBER(10) | EBS Sales Channel Destination Key - Numeric |
| EBS_SUPPLIER_CODE | VARCHAR2(240) | EBS Supplier code |
| EBS_SUPPLIER_DESC | VARCHAR2(240) | EBS Supplier description |
| E1_PARENT_ADDRESS_NUM | VARCHAR2(100 | E1 Parent address information - number |
| T_EP_LR2_DESC | VARCHAR2(200) | Bill-To description |
| E1_PARENT_ADDRESS_NUM_DESC | VARCHAR2(200) | E1 Parent address information - description |
This staging table is used by the ep_load_main procedure. Each record corresponds to sales data for a given item and location combination, based on all lowest item levels in the model. For information on the hierarchy, see "Item Levels" and "Location Levels".
| Name | Type | Purpose |
|---|---|---|
| T_EP_P1 | VARCHAR2(100) | Parent Model |
| T_EP_LR1 | VARCHAR2(100) | Ship To |
| T_EP_LS1 | VARCHAR2(100) | Territory |
| ACTUAL_QTY | NUMBER(20,10) | Populates the Actuals Ttl series |
| BASE_EVT_DOL_RTL | NUMBER(20,10) | Populates the Base Evt $ Rtl sd series |
| INCR_EVT_DOL_RTL | NUMBER(20,10) | Populates the Incr Evt $ Rtl sd series. |
| ITEM_PRICE | NUMBER(20,10) | Populates the Avg Rtl sd series. |
| SALES_DATE | DATE | Date of the sale. |
| SDATA10 | NUMBER(20,10) | Populates the % ACV DISP series. |
| SDATA11 | NUMBER(20,10) | Populates the % ACV FEAT series. |
| SDATA12 | NUMBER(20,10) | Populates the % ACV FEAT series. |
| SDATA13 | NUMBER(20,10) | Populates the % ACV TPR series. |
| SDATA14 | NUMBER(20,10) | Populates the % ACV FREQSHOPPER series. |
| SDATA4 | NUMBER(20,10) | Populates the Shipments series |
| SDATA5 | NUMBER(20,10) | Populates the Actuals Base series. |
| SDATA6 | NUMBER(20,10) | Populates the Actuals Incr series. |
| SDATA7 | NUMBER(20,10) | Populates the COGS series. |
| SDATA8 | NUMBER(20,10) | Populates the List Price series. |
| SDATA9 | NUMBER(20,10) | Populates the % ACV ANY PROMO series. |
| SHELF_PRICE_SD | NUMBER(20,10) | Populates the Shelf Price sd series. |
| T_EP_M1 | VARCHAR2(100) | Not used. |
| T_EP_M2 | VARCHAR2(100) | Not used. |
| SDATA15 | NUMBER(20,10) | Not used. |
| DM_ITEM_CODE | VARCHAR2(240) | Item Code |
| DM_ORG_CODE | VARCHAR2(240) | Organization Code |
| DM_SITE_CODE | VARCHAR2(240) | Site Code |
| E1_ITEM_BRANCH_CATEGORY_1 | VARCHAR2(100) | E1 Item Branch Category Code |
| E1_ITEM_BRANCH_CATEGORY_2 | VARCHAR2(100) | E1 Item Branch Category Code |
| E1_ITEM_BRANCH_CATEGORY_3 | VARCHAR2(100) | E1 Item Branch Category Code |
| E1_ITEM_BRANCH_CATEGORY_4 | VARCHAR2(100) | E1 Item Branch Category Code |
| E1_ITEM_BRANCH_CATEGORY_5 | VARCHAR2(100) | E1 Item Branch Category Code |
| E1_ITEM_BRANCH_CATEGORY_6 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_7 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_8 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_9 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_10 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_11 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_12 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_13 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_14 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_15 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_16 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_17 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_18 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_19 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_20 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_21 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_22 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| E1_ITEM_BRANCH_CATEGORY_23 | VARCHAR2(100) | Placeholder for E1 Item Branch Category code. Not loaded |
| EBS_DEMAND_CLASS_CODE | VARCHAR2(240) | EBS Demand Class level code |
| EBS_SALES_CHANNEL_CODE | VARCHAR2(240) | EBS Sales Channel level code |
| EBS_BOOK_HIST_BOOK_QTY_BD | NUMBER(20,10) | Historical Booking supplied quantity by booking date |
| EBS_BOOK_HIST_REQ_QTY_BD | NUMBER(20,10) | Historical Booking requested quantity by booking date |
| EBS_BOOK_HIST_BOOK_QTY_RD | NUMBER(20,10) | Historical Booking supplied quantity by requested date |
| EBS_BOOK_HIST_REQ_QTY_RD | NUMBER(20,10) | Historical Booking requested quantity by booking date |
| EBS_SHIP_HIST_SHIP_QTY_SD | NUMBER(20,10) | Historical Shipments sent shipment by ship date |
| EBS_SHIP_HIST_SHIP_QTY_RD | NUMBER(20,10) | Historical Shipments sent shipment by requested date |
| EBS_SHIP_HIST_REQ_QTY_RD | NUMBER(20,10) | Historical Shipments requested shipment by requested date |
| EBS_ITEM_SR_PK | NUMBER | EBS item Code |
| EBS_ORG_SR_PK | NUMBER | EBS Organization Code |
| EBS_SITE_SR_PK | NUMBER | EBS Site Code |
| EBS_DEMAND_CLASS_SR_PK | VARCHAR2(100) | EBS Demand Class Code |
| EBS_SALES_CHANNEL_SR_PK | VARCHAR2(100) | EBS Sales Channel Code |
Important: If using text files, they must contain the same fields as the staging tables above contain and in the same order.