Retail Integration Bus Mappings Report Release:13.1

(Retail Warehouse Management System)

Application Retail Warehouse Management System Target Name Space http://www.oracle.com/retail/integration/base/bo/VendorDesc/v1 Version 1.0 Description This is root element of this document which contains name space definitions for the document elements. VendorDesc VendorHdrDesc ExtOfVendorHdrDesc VendorAddrDesc ExtOfVendorAddrDesc VendorOUDesc ExtOfVendorOUDesc ExtOfVendorDesc

XML-Schema Name:VendorDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For VendorDesc Table Name Column Name API Type Column Length API Required API Description VendorHdrDesc:VendorHdrDesc * 1 1 It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA VendorAddrDesc:VendorAddrDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA VendorOUDesc:VendorOUDesc * 0 unbounded It's a referenced element. For detailed description, please refer referenced element doc. NA NA NA NA NA NA ExtOfVendorDesc:ExtOfVendorDesc * 0 1 Provide an extension hook to customize VendorDesc. NA NA NA NA NA NA

XML-Schema Name:VendorHdrDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For VendorHdrDesc Table Name Column Name API Type Column Length API Required API Description supplier varchar210 1 1 Not Yet Available vendor vendor_nbr varchar2 10 Yes * sup_name varchar2240 1 1 Not Yet Available vendor vendor_name varchar2 32 Yes * contact_name varchar2120 1 1 Contains the name of the supplier's representative contact. n/a n/a varchar2 20 Yes Not used in RWMS. contact_phone varchar220 1 1 Contains a telephone number for the supplier's representative contact. n/a n/a varchar2 20 Yes Not used in RWMS. contact_fax varchar220 0 1 Contains a fax number for the supplier's representative contact. n/a n/a varchar2 20 No Not used in RWMS. contact_pager varchar220 0 1 Contains a pager number for the supplier's representative contact. n/a n/a varchar2 20 No Not used in RWMS. sup_status varchar21 1 1 Valid values include: 'A' for an active supplier or 'I' for an inactive supplier. The status of a supplier will be checked when an order is being created to make certain the supplier is active. vendor sup_status varchar2 1 Yes * qc_ind varchar21 0 1 Determines whether orders from this supplier will default as requiring quality control. n/a n/a varchar2 1 No Not used in RWMS. qc_pct number12_4 0 1 The percentage of items per receipt that will be marked for quality checking. vendor percent_qa_sampling number 12 No * qc_freq number2 0 1 The frequency for which items per receipt will be marked for quality checking. vendor freq_qa_audit number 2 No * vc_ind varchar21 1 1 Determines whether orders from this supplier will default as requiring vendor control. n/a * varchar2 1 Yes Not used in RWMS. vc_pct number12_4 0 1 The percentage of items per receipt that will be marked for vendor checking. vendor percent_va_sampling number 12 No * vc_freq number2 0 1 The frequency for which items per receipt that will be marked for vendor checking. vendor freq_va_audit number 2 No * currency_code varchar23 1 1 A code identifying the currency the supplier uses for business transactions. n/a n/a varchar2 3 Yes Not used in RWMS. lang number6 0 1 NA n/a n/a number 6 No Not used in RWMS. terms varchar215 0 1 Indicator identifying the sales terms that will default when an order is created for the supplier. These terms specify when payment is due and if any discounts exist for early payment. n/a n/a varchar2 15 No Not used in RWMS. freight_terms varchar230 0 1 A code indicating what freight terms will default when an order is created for the supplier. n/a n/a varchar2 30 No Not used in RWMS. ret_allow_ind varchar21 0 1 Not Yet Available n/a n/a varchar2 1 No Not used in RWMS. ret_auth_req varchar21 0 1 Indicates if returns must be accompanied by an authorization number when sent back to the vendor. n/a n/a varchar2 1 No Not used in RWMS. ret_min_dol_amt number20_4 0 1 Contains a value if the supplier requires a minimum dollar amount to be returned in order to accept the return. Returns of less than this amount will not be processed by the system. This field is stored in the supplier's currency. n/a n/a number 20 No Not used in RWMS. ret_courier varchar2250 0 1 Contains the name of the courier that should be used for returns to the supplier. n/a n/a varchar2 20 No Not used in RWMS. handling_pct number12_4 0 1 The percent to be multiplied by an order's total cost to determine the handling cost for the return. n/a n/a number 12 No Not used in RWMS. edi_po_ind varchar21 1 1 Indicates whether purchase orders will be sent to the supplier via Electronic Data Interchange. n/a n/a varchar2 1 Yes Not used in RWMS. edi_po_chg varchar21 0 1 Indicates whether purchase order changes will be sent to the supplier via EDI. n/a n/a varchar2 1 No Not used in RWMS. edi_po_confirm varchar21 0 1 Indicates whether acknowledgements of purchase orders will be sent to the supplier via EDI. n/a n/a varchar2 1 No Not used in RWMS. edi_asn varchar21 0 1 Indicates whether the supplier will send Advance Shipment Notifications electronically. n/a n/a varchar2 1 No Not used in RWMS. edi_sales_rpt_freq varchar21 0 1 This field contains the EDI sales report frequency for the supplier. Valid values are 'D' or 'W', specifying that sales and stock information will be downloaded daily or weekly. n/a n/a varchar2 1 No Not used in RWMS. edi_supp_available_ind varchar21 1 1 Indicates whether the supplier will send availability via EDI. n/a n/a varchar2 1 Yes Not used in RWMS. edi_contract_ind varchar21 0 1 Indicates whether contracts will be sent to the supplier via EDI. n/a n/a varchar2 1 No Not used in RWMS. edi_invc_ind varchar21 0 1 Indicates whether invoices, debit memos and credit note requests will be sent to/from the supplier via EDI. n/a n/a varchar2 1 No Not used in RWMS. cost_chg_pct_var number12_4 0 1 Contains the cost change variance by percent. If an EDI cost change is accepted and falls within these boundaries, it will be approved when inserted into the cost change dialog. n/a n/a number 12 No Not used in RWMS. cost_chg_amt_var number20_4 0 1 Contains the cost change variance by amount. If an EDI cost change is accepted and falls within these boundaries, it will be approved when inserted into the cost change dialog. n/a n/a number 20 No Not used in RWMS. replen_approval_ind varchar21 0 1 Indicates whether contract orders for the supplier should be created in Approved status. n/a n/a varchar2 1 No Not used in RWMS. ship_method varchar26 0 1 The method used to ship the items on the purchase order from the country of origin to the country of import. Check the RMS data model for valid values. n/a n/a varchar2 6 No Not used in RWMS. payment_method varchar26 0 1 Indicates how the purchase order will be paid. Valid options are: LC (Letter of Credit), WT (Wire Transfer), OA (Open Account). n/a n/a varchar2 6 No Not used in RWMS. contact_telex varchar220 0 1 Contains a telex number for the supplier's representative contact. n/a n/a varchar2 20 No Not used in RWMS. contact_email varchar2100 0 1 Contains an email address for the supplier's representative contact. n/a n/a varchar2 100 No Not used in RWMS. settlement_code varchar21 0 1 Indicates which payment process method is used for the supplier. Check the RMS data model for valid values. n/a n/a varchar2 1 No Not used in RWMS. pre_mark_ind varchar21 0 1 Indicates whether or not the supplier has agreed to break an order into separate boxes (and mark them) that can be shipped directly to the stores. n/a n/a varchar2 1 No Not used in RWMS. auto_appr_invc_ind varchar21 0 1 Indicates whether or not the supplier's invoice matches can be automatically approved for payment. * * varchar2 1 * * dbt_memo_code varchar21 0 1 Indicates when a debit memo will be sent to the supplier to resolve a discrepancy. Valid values are Y if debit memos are always to be sent, L if debit memos are used only if a credit note is not sent by the invoice due date, or N if debit memos are neve * * varchar2 1 * * freight_charge_ind varchar21 0 1 Indicates whether a supplier is allowed to charge freight costs to the client. * * varchar2 1 * * auto_appr_dbt_memo_ind varchar21 0 1 Indicates whether debit memos sent to the supplier can be automatically approved on creation. n/a n/a varchar2 1 No Not used in RWMS. inv_mgmt_lvl varchar26 0 1 Indicates whether supplier inventory management information can be set up at the supplier/deparment level or just at the supplier level. n/a n/a varchar2 6 No Not used in RWMS. backorder_ind varchar21 0 1 Indicates if backorders or partial shipments will be accepted. n/a n/a varchar2 1 No Not used in RWMS. vat_region number4 0 1 Contains the unique identifying number for the VAT region in the system. n/a n/a number 4 No Not used in RWMS. prepay_invc_ind varchar21 0 1 Indicates whether or not all invoices for the supplier can be pre-paid invoices. n/a n/a varchar2 1 No Not used in RWMS. service_perf_req_ind varchar21 0 1 Indicates if the supplier's services must be confirmed as performed before paying an invoice from that supplier. n/a n/a varchar2 1 No Not used in RWMS. invc_pay_loc varchar26 0 1 Indicates where invoices from this supplier are paid - at the store ('S') or centrally through corporate accounting ('C'). n/a n/a varchar2 6 No Not used in RWMS. invc_receive_loc varchar26 0 1 Indicates where invoices from this supplier are received - at the store ('S') or centrally through corporate accounting ('C'). n/a n/a varchar2 6 No Not used in RWMS. addinvc_gross_net varchar26 0 1 Indicates if the supplier invoice lists items at gross cost ('G') or net cost ('N'). n/a n/a varchar2 6 No Not used in RWMS. delivery_policy varchar26 0 1 Contains the delivery policy of the supplier. Valid values come from the DLVY code on code_head/code_detail. n/a n/a varchar2 6 No Not used in RWMS. comment_desc varchar22000 0 1 Any miscellaneous comments associated with the supplier. n/a n/a varchar2 2000 No Not used in RWMS. default_item_lead_time number4 0 1 Holds the default lead time for the supplier. The lead time is the time the supplier needs between receiving an order and having the order ready to ship. This value will be defaulted to item/supplier relationships. n/a n/a number 4 No Not used in RWMS. duns_number varchar29 0 1 This type can hold a number of digits count umber. n/a n/a varchar2 9 No Not used in RWMS. duns_loc varchar24 0 1 The Dun and Bradstreet number of the location of the supplier. n/a n/a varchar2 4 No Not used in RWMS. bracket_costing_ind varchar21 0 1 This field will determine if the supplier uses bracket costing pricing structures. n/a n/a varchar2 1 No Not used in RWMS. vmi_order_status varchar26 0 1 Determines the status in which any inbound PO's from this supplier are created. A NULL value indicates that the supplier is not a VMI supplier. n/a n/a varchar2 6 No Not used in RWMS. end_date_active xs:dateTime 0 1 Not Yet Available n/a end_date_active RIBDate * No Not used in RWMS. dsd_supplier_ind varchar21 0 1 Specifies whether or not DSD shipments can be created for the supplier. * * varchar2 1 * * sup_qty_level varchar26 0 1 Indicates the supplier order quantity level - 'CA' for cases, 'EA' for eaches. NA NA NA NA NA NA supplier_parent varchar210 0 1 Description is not available. NA NA NA NA NA NA ExtOfVendorHdrDesc:ExtOfVendorHdrDesc * 0 1 Provide an extension hook to customize VendorHdrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfVendorHdrDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfVendorHdrDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:VendorAddrDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For VendorAddrDesc Table Name Column Name API Type Column Length API Required API Description module varchar24 1 1 Indicates the data type that the address is attached to. In this case, it will always be 'SUPP'. * * varchar2 4 Yes Not used in RWMS. key_value_1 varchar220 1 1 Holds the id the address is attached to. In this case, it will be the supplier number. n/a n/a varchar2 20 Yes Not used in RWMS. key_value_2 varchar220 0 1 NA n/a n/a varchar2 20 No Not used in RWMS. seq_no number4 1 1 Number indicating the sequence that addresses within the same type were entered. vendor_address seq_no number 4 Yes * addr_type varchar22 1 1 The address type. Valid values (e.g. 01 - Business, 02 - Postal, etc.) are on the add_type table. vendor_address addr_type varchar2 2 Yes * primary_addr_ind varchar21 1 1 Indicates whether the address is the primary address for the address type. vendor_address primary_addr_ind varchar2 1 Yes * add_1 varchar2240 1 1 Not Yet Available vendor_address address1 varchar2 240 Yes * add_2 varchar2240 0 1 Not Yet Available vendor_address address2 varchar2 240 No * add_3 varchar2240 0 1 Not Yet Available vendor_address address3 varchar2 240 No * city varchar2120 1 1 Not Yet Available vendor_address city varchar2 120 Yes * state varchar23 0 1 Not Yet Available vendor_address state varchar2 3 Yes * country_id varchar23 1 1 Not Yet Available vendor_address country varchar2 3 Yes * post varchar230 0 1 Not Yet Available vendor_address shipto_zip varchar2 30 Yes * contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. n/a n/a varchar2 120 No Not used in RWMS. contact_phone varchar220 0 1 Mapped to TL_PH, PH_EXTN as well. Not Yet Available n/a n/a varchar2 20 No Not used in RWMS. contact_telex varchar220 0 1 Contains the telex number of the partner or supplier's representative contact. n/a n/a varchar2 20 No Not used in RWMS. contact_fax varchar220 0 1 Mapped to TL_PH, PH_EXTN as well. Not Yet Available n/a n/a varchar2 20 No Not used in RWMS. contact_email varchar2100 0 1 Contains the email address of the partner or supplier's representative contact. n/a n/a varchar2 100 No Not used in RWMS. ExtOfVendorAddrDesc:ExtOfVendorAddrDesc * 0 1 Provide an extension hook to customize VendorAddrDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfVendorAddrDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfVendorAddrDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:VendorOUDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For VendorOUDesc Table Name Column Name API Type Column Length API Required API Description org_unit_id number15 1 1 Description is not available. NA NA NA NA NA NA primary_pay_site_ind varchar210 0 1 Description is not available. NA NA NA NA NA NA ExtOfVendorOUDesc:ExtOfVendorOUDesc * 0 1 Provide an extension hook to customize VendorOUDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfVendorOUDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfVendorOUDesc Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:ExtOfVendorDesc Version:13.1 Return to Top Tag Name Type Min Occurs Max Occurs Description rwms Mapping For ExtOfVendorDesc Table Name Column Name API Type Column Length API Required API Description