Retail Integration Mappings Report Release:15.0.0 (Integration Gateway Services)
Application Integration Gateway Services
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.
XSD Structure

XML-Schema Name:VendorDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VendorDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's 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

XML-Schema Name:VendorHdrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VendorHdrDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
supplier varchar210 1 1 Unique identifying number for a supplier within the system. The user determines this number when a new supplier is first added to the system. RMS.sups SUPPLIER number 10 Yes Unique identifying number for a supplier within the system. The user determines this number when a new supplier is first added to the system.
sup_name varchar2240 1 1 Contains the suppliers trading name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
sup_name_secondary varchar2240 0 1 This type can hold a string of max length of 240 characters. RMS.sups SUP_NAME_SECONDARY varchar2 240 No This type can hold a string of max length of 240 characters.
contact_name varchar2120 1 1 Contains the name of the supplier's representative contact. RMS.sups CONTACT_NAME varchar2 120 Yes Contains the name of the suppliers representative contact.
contact_phone varchar220 1 1 Contains a telephone number for the supplier's representative contact. RMS.sups CONTACT_PHONE varchar2 20 Yes Contains a telephone number for the suppliers representative contact.
contact_fax varchar220 0 1 Contains a fax number for the supplier's representative contact. RMS.sups CONTACT_FAX varchar2 20 No Contains a fax number for the suppliers representative contact.
contact_pager varchar220 0 1 Contains a pager number for the supplier's representative contact. RMS.sups CONTACT_PAGER varchar2 20 No Contains the number for the pager of the suppliers representative contact.
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. RMS.sups SUP_STATUS varchar2 '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. Yes Valid values include
qc_ind varchar21 0 1 Determines whether orders from this supplier will default as requiring quality control. RMS.sups QC_IND varchar2 1 Yes Determines whether orders from this supplier will default as requiring quality control.
qc_pct number12_4 0 1 The percentage of items per receipt that will be marked for quality checking. RMS.sups QC_PCT number 12 No The percentage of items per receipt that will be marked for quality checking.
qc_freq number2 0 1 The frequency for which items per receipt will be marked for quality checking. RMS.sups QC_FREQ number 2 No The frequency for which items per receipt will be marked for quality checking.
vc_ind varchar21 1 1 Determines whether orders from this supplier will default as requiring vendor control. RMS.sups VC_IND varchar2 1 Yes Determines whether orders from this supplier will default as requiring vendor control.
vc_pct number12_4 0 1 The percentage of items per receipt that will be marked for vendor checking. RMS.sups VC_PCT number 12 No The percentage of items per receipt that will be marked for vendor checking.
vc_freq number2 0 1 The frequency for which items per receipt that will be marked for vendor checking. RMS.sups VC_FREQ number 2 No The frequency for which items per receipt that will be marked for vendor checking.
currency_code varchar23 1 1 A code identifying the currency the supplier uses for business transactions. RMS.sups CURRENCY_CODE varchar2 3 Yes A code identifying the currency the supplier uses for business transactions.
lang number6 0 1 This field contains the suppliers preferred language. This field is provided for custom purchase orders in a specified language. RMS.sups LANG number 6 No This field contains the suppliers preferred language. This field is provided for custom purchase orders in a specified language.
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. RMS.sups TERMS varchar2 15 Yes 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.
freight_terms varchar230 0 1 A code indicating what freight terms will default when an order is created for the supplier. RMS.sups FREIGHT_TERMS varchar2 30 Yes A code indicating what freight terms will default when an order is created for the supplier.
ret_allow_ind varchar21 0 1 Indicates whether or not the supplier will accept returns. Valid values are Y and N. RMS.sups RET_ALLOW_IND varchar2 1 Yes Indicates whether or not the supplier will accept returns. Valid values are Y and N.
ret_auth_req varchar21 0 1 Indicates if returns must be accompanied by an authorization number when sent back to the vendor. RMS.sups RET_AUTH_REQ varchar2 1 Yes Indicates if returns must be accompanied by an authorization number when sent back to the vendor.
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. RMS.sups RET_MIN_DOL_AMT number 20 No 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.
ret_courier varchar2250 0 1 Contains the name of the courier that should be used for returns to the supplier. RMS.sups RET_COURIER varchar2 250 No Contains the name of the courier that should be used for returns to the supplier.
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. RMS.sups HANDLING_PCT number 12 No The percent to be multiplied by an order's total cost to determine the handling cost for the return.
edi_po_ind varchar21 1 1 Indicates whether purchase orders will be sent to the supplier via Electronic Data Interchange. RMS.sups EDI_PO_IND varchar2 1 Yes Indicates whether purchase orders will be sent to the supplier via Electronic Data Interchange.
edi_po_chg varchar21 0 1 Indicates whether purchase order changes will be sent to the supplier via EDI. RMS.sups EDI_PO_CHG varchar2 1 Yes Indicates whether purchase order changes will be sent to the supplier via EDI.
edi_po_confirm varchar21 0 1 Indicates whether acknowledgements of purchase orders will be sent to the supplier via EDI. RMS.sups EDI_PO_CONFIRM varchar2 1 Yes Indicates whether acknowledgements of purchase orders will be sent to the supplier via EDI.
edi_asn varchar21 0 1 Indicates whether the supplier will send Advance Shipment Notifications electronically. RMS.sups EDI_ASN varchar2 1 Yes Indicates whether the supplier will send Advance Shipment Notifications electronically.
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. RMS.sups EDI_SALES_RPT_FREQ varchar2 1 Yes 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.
edi_supp_available_ind varchar21 1 1 Indicates whether the supplier will send availability via EDI. RMS.sups EDI_SUPP_AVAILABLE_IND varchar2 1 Yes Indicates whether the supplier will send availability via EDI.
edi_contract_ind varchar21 0 1 Indicates whether contracts will be sent to the supplier via EDI. RMS.sups EDI_CONTRACT_IND varchar2 1 Yes Indicates whether contracts will be sent to the supplier via EDI.
edi_invc_ind varchar21 0 1 Indicates whether invoices, debit memos and credit note requests will be sent to/from the supplier via EDI. RMS.sups EDI_INVC_IND varchar2 1 Yes Indicates whether invoices, debit memos and credit note requests will be sent to/from the supplier via EDI.
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. RMS.sups COST_CHG_PCT_VAR number 12 No 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 dialogue.
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. RMS.sups COST_CHG_AMT_VAR number 20 No 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.
replen_approval_ind varchar21 0 1 Indicates whether contract orders for the supplier should be created in Approved status. RMS.sups REPLEN_APPROVAL_IND varchar2 1 Yes Indicates whether contract orders for the supplier should be created in Approved status.
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. RMS.sups SHIP_METHOD varchar2 6 No 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.
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). RMS.sups PAYMENT_METHOD varchar2 LC (Letter of Credit), WT (Wire Transfer), OA (Open Account). No Indicates how the purchase order will be paid. Valid options are
contact_telex varchar220 0 1 Contains a telex number for the supplier's representative contact. RMS.sups CONTACT_TELEX varchar2 20 No This field contains the telex number of the partner or suppliers representative contact.
contact_email varchar2100 0 1 Contains an email address for the supplier's representative contact. RMS.sups CONTACT_EMAIL varchar2 100 No This field contains the email address of the partner or suppliers representative contact.
settlement_code varchar21 0 1 Indicates which payment process method is used for the supplier. Check the RMS data model for valid values. RMS.sups SETTLEMENT_CODE varchar2 1 Yes Indicates which payment process method is used for the supplier. Check the RMS data model for valid values.
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. RMS.sups PRE_MARK_IND varchar2 1 Yes 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.
auto_appr_invc_ind varchar21 0 1 Indicates whether or not the supplier's invoice matches can be automatically approved for payment. RMS.sups AUTO_APPR_INVC_IND varchar2 1 Yes Indicates whether or not the suppliers invoice matches can be automatically approved for payment. Valid values are Y or N. This field will only be populated if invoice matching is installed.
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 RMS.sups DBT_MEMO_CODE varchar2 1 No 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
freight_charge_ind varchar21 0 1 Indicates whether a supplier is allowed to charge freight costs to the client. RMS.sups FREIGHT_CHARGE_IND varchar2 1 Yes Indicates whether a supplier is allowed to charge freight costs to the client.
auto_appr_dbt_memo_ind varchar21 0 1 Indicates whether debit memos sent to the supplier can be automatically approved on creation. RMS.sups AUTO_APPR_DBT_MEMO_IND varchar2 1 Yes Indicates whether or not debit memos sent to the supplier can be automatically approved on creation. Valid values are Y or N. This field will only be populated if invoice matching is installed.
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. RMS.sups INV_MGMT_LVL varchar2 6 No Indicates whether supplier inventory management information can be set up at the supplier/deparment level or just at the supplier level.
backorder_ind varchar21 0 1 Indicates if backorders or partial shipments will be accepted. RMS.sups BACKORDER_IND varchar2 1 Yes Indicates if backorders or partial shipments will be accepted.
vat_region number4 0 1 Contains the unique identifying number for the VAT region in the system. RMS.sups VAT_REGION number 4 No Contains the unique identifying number for the VAT region in the system.
prepay_invc_ind varchar21 0 1 Indicates whether or not all invoices for the supplier can be pre-paid invoices. RMS.sups PREPAY_INVC_IND varchar2 1 Yes Indicates whether or not all invoices for the supplier can be pre-paid invoices.
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. RMS.sups SERVICE_PERF_REQ_IND varchar2 1 Yes Indicates if the supplier's services must be confirmed as performed before paying an invoice from that supplier.
invc_pay_loc varchar26 0 1 Indicates where invoices from this supplier are paid - at the store ('S') or centrally through corporate accounting ('C'). RMS.sups INVC_PAY_LOC varchar2 6 No Indicates where invoices from this supplier are paid - at the store ('S') or centrally through corporate accounting ('C').
invc_receive_loc varchar26 0 1 Indicates where invoices from this supplier are received - at the store ('S') or centrally through corporate accounting ('C'). RMS.sups INVC_RECEIVE_LOC varchar2 6 No Indicates where invoices from this supplier are received - at the store ('S') or centrally through corporate accounting ('C').
addinvc_gross_net varchar26 0 1 Indicates if the supplier invoice lists items at gross cost ('G') or net cost ('N'). Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
delivery_policy varchar26 0 1 Contains the delivery policy of the supplier. Valid values come from the DLVY code on code_head/code_detail. RMS.sups DELIVERY_POLICY varchar2 6 Yes Contains the delivery policy of the supplier. Valid values come from the DLVY code on code_head/code_detail.
comment_desc varchar22000 0 1 Any miscellaneous comments associated with the supplier. RMS.sups COMMENT_DESC varchar2 2000 No Any miscellaneous comments associated with the supplier.
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. RMS.sups DEFAULT_ITEM_LEAD_TIME number 4 No 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.
duns_number varchar29 0 1 This type can hold a number of digits count umber. RMS.sups DUNS_NUMBER varchar2 9 No This field holds the Dun and Bradstreet number to identify the supplier.
duns_loc varchar24 0 1 The Dun and Bradstreet number of the location of the supplier. RMS.sups DUNS_LOC varchar2 4 No The Dun and Bradstreet number of the location of the supplier.
bracket_costing_ind varchar21 0 1 This field will determine if the supplier uses bracket costing pricing structures. RMS.sups BRACKET_COSTING_IND varchar2 1 Yes This field will determine if the supplier uses bracket costing pricing structures. Valid values
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. RMS.sups VMI_ORDER_STATUS varchar2 6 No 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.
end_date_active xs:dateTime 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
dsd_supplier_ind varchar21 0 1 Specifies whether or not DSD shipments can be created for the supplier. RMS.sups DSD_IND varchar2 1 Yes Specifies whether or not DSD shipments can be created for the supplier.
sup_qty_level varchar26 0 1 Indicates the supplier order quantity level - 'CA' for cases, 'EA' for eaches. RMS.sups SUP_QTY_LEVEL varchar2 6 Yes Indicates the supplier order quantity level - 'CA' for cases, 'EA' for eaches.
supplier_parent varchar210 0 1 This is the supplier number for the supplier sites. For Suppliers, this field will be NULL. RMS.sups SUPPLIER_PARENT number 10 No This is the supplier number for the supplier sites. For Suppliers, this field will be NULL.
store_delivery_discrepancy varchar26 0 1 Description is not available. RMS.sups SUP_NAME varchar2 240 Yes Contains the suppliers trading name.
final_dest_ind varchar21 0 1 Final Destination Indicator. RMS.sups FINAL_DEST_IND varchar2 1 Yes Final Destination Indicator.

XML-Schema Name:VendorAddrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VendorAddrDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
module varchar24 1 1 Indicates the data type that the address is attached to. In this case, it will always be 'SUPP'. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
key_value_1 varchar220 1 1 Holds the id the address is attached to. In this case, it will be the supplier number. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
key_value_2 varchar220 0 1 NA Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
seq_no number4 1 1 Number indicating the sequence that addresses within the same type were entered. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
addr_type varchar22 1 1 The address type. Valid values (e.g. 01 - Business, 02 - Postal, etc.) are on the add_type table. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
primary_addr_ind varchar21 1 1 Indicates whether the address is the primary address for the address type. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
add_1 varchar2240 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
add_2 varchar2240 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
add_3 varchar2240 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
city varchar2120 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
city_id varchar210 0 1 This will contain a city id Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
state varchar23 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
country_id varchar23 1 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
post varchar230 0 1 Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_name varchar2120 0 1 Contains the name of the contact for the supplier at this address. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_phone varchar220 0 1 Mapped to TL_PH, PH_EXTN as well. Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_telex varchar220 0 1 Contains the telex number of the partner or supplier's representative contact. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_fax varchar220 0 1 Mapped to TL_PH, PH_EXTN as well. Not Yet Available Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
contact_email varchar2100 0 1 Contains the email address of the partner or supplier's representative contact. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:VendorOUDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for VendorOUDesc in IGS application.
IGS's Table Name IGS's Column Name Integration API(RIB or/and RSB or/and RSL) IGS's Column Length Is Column Required in IGS's API? IGS's API Description
org_unit_id number15 1 1 This field contains org_unit_id. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
primary_pay_site_ind varchar210 0 1 Primary payment site indicator. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.