Retail Integration Mappings Report Release:15.0.0 (Retail Merchandising System)
Application Retail Merchandising System
Target Name Space http://www.oracle.com/retail/integration/base/bo/SupplierDesc/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:SupplierDesc 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 SupplierDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
sup_xref_key varchar232 1 1 This column holds the ID for the supplier used in the external financial system. It is populated by the integration that brings suppliers from external financial systems into RMS. This ID and the supplier site ID can be used to join to information about the supplier in the external system. * sup_xref_key varchar2 32 Yes Fill this description.
supplier_id number10 0 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. * supplier_id number 10 No Fill this description.
SupAttr * 1 1 Description is not available.
SupSite * 0 unbounded Description is not available.
ExtOfSupplierDesc:ExtOfSupplierDesc * 0 1 Provide an extension hook to customize SupplierDesc. NA NA NA NA NA NA
LocOfSupplierDesc:LocOfSupplierDesc * 0 unbounded Provide an extension hook to localize SupplierDesc. NA NA NA NA NA NA

XML-Schema Name:SupAttr 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 SupAttr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
sup_name varchar2240 1 1 Contains the suppliers trading name. sups sup_name varchar2 240 Yes Contains the suppliers trading name.
sup_name_secondary varchar2240 0 1 Description is not 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 suppliers representative contact. SUPS CONTACT_NAME varchar2 120 Yes Contains the name of the suppliers representative contact.
contact_phone varchar220 0 1 Contains a telephone number for the suppliers representative contact. 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 suppliers representative contact. SUPS CONTACT_FAX varchar2 20 No Contains a fax number for the suppliers representative contact.
contact_pager varchar220 0 1 Contains the number for the pager of the suppliers representative contact. SUPS CONTACT_PAGER varchar2 20 No Contains the number for the pager of the suppliers representative contact.
sup_status varchar21 1 1 Determines whether the supplier is currently active. Valid values include 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 Determines whether the supplier is currently active. Valid values include
qc_ind varchar21 0 1 Determines whether orders from this supplier will default as requiring quality control. A value of Y means that all orders from this supplier will require quality control unless overridden by the user when the order is created. An N in this field means that quality control will not be required unless indicated by the user during order creation. sups qc_ind varchar2 1 Yes Determines whether orders from this supplier will default as requiring quality control. A value of Y means that all orders from this supplier will require quality control unless overridden by the user when the order is created. An N in this field means that quality control will not be required unless indicated by the user during order creation.
qc_pct number12_4 0 1 Indicates the percentage of items per receipt that will be marked for quality checking. sups qc_pct number 12,4 No Indicates the percentage of items per receipt that will be marked for quality checking.
qc_freq varchar22 0 1 Indicates the frequency in which items per receipt will be marked for quality checking. sups qc_freq number 2,0 No Indicates the frequency in which items per receipt will be marked for quality checking.
vc_ind varchar21 0 1 Determines whether orders from this supplier will default as requiring vendor control. A value of Y means that all orders from this supplier will require vendor control. An N in this field means that vendor control will not be required. sups vc_ind varchar2 1 Yes Determines whether orders from this supplier will default as requiring vendor control. A value of Y means that all orders from this supplier will require vendor control. An N in this field means that vendor control will not be required.
vc_pct number12_4 0 1 Indicates the percentage of items per receipt that will be marked for vendor checking. sups vc_pct number 12,4 No Indicates the percentage of items per receipt that will be marked for vendor checking.
vc_freq number2 0 1 Indicates the frequency in which items per receipt will be marked for vendor checking. sups vc_freq number 2,0 No Indicates the frequency in which items per receipt will be marked for vendor checking.
currency_code varchar23 1 1 Contains a code identifying the currency the supplier uses for business transactions. SUPS CURRENCY_CODE varchar2 3 Yes Contains a code identifying the currency the supplier uses for business transactions.
lang number6 1 1 This field contains the suppliers preferred language. This field is provided for custom purchase orders in a specified language. sups lang number 6,0 No This field contains the suppliers preferred language. This field is provided for custom purchase orders in a specified language.
terms varchar215 1 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. 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 1 1 Indicator that references what freight terms will default when a order is created for the supplier. sups freight_terms varchar2 30 Yes Indicator that references what freight terms will default when a 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. 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. Valid values are Y and N. sups ret_auth_req varchar2 1 Yes Indicates if returns must be accompanied by an authorization number when sent back to the vendor. Valid values are Y and N.
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 suppliers currency. sups ret_min_dol_amt number 20,4 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 suppliers currency.
ret_courier varchar2250 0 1 Contains the name of the courier that should be used for all returns to the supplier. sups ret_courier varchar2 250 No Contains the name of the courier that should be used for all returns to the supplier.
handling_pct number12_4 0 1 Percentage multiplied by the total order cost to determine the handling cost for the return. sups handling_pct number 12,4 No Percentage multiplied by the total order cost to determine the handling cost for the return.
edi_po_ind varchar21 0 1 Indicates whether purchase orders will be sent to the supplier via Electronic Data Interchange. Valid values are Y and N. sups edi_po_ind varchar2 1 Yes Indicates whether purchase orders will be sent to the supplier via Electronic Data Interchange. Valid values are Y and N.
edi_po_chg varchar21 0 1 Indicates whether purchase order changes will be sent to the supplier via Electronic Data Interchange. Valid values are Y and N. sups edi_po_chg varchar2 1 Yes Indicates whether purchase order changes will be sent to the supplier via Electronic Data Interchange. Valid values are Y and N.
edi_po_confirm varchar21 0 1 Indicates whether this supplier will send acknowledgment of a purchase orders sent via Electronic Data Interchange. Valid values are Y and N. sups edi_po_confirm varchar2 1 Yes Indicates whether this supplier will send acknowledgment of a purchase orders sent via Electronic Data Interchange. Valid values are Y and N.
edi_asn varchar21 0 1 Indicates whether this supplier will send Advance Shipment Notifications electronically. Valid values are Y and N. sups edi_asn varchar2 1 Yes Indicates whether this supplier will send Advance Shipment Notifications electronically. Valid values are Y and N.
edi_sales_rpt_freq varchar21 0 1 This field contains the EDI sales report frequency for this supplier. Valid values are sups edi_sales_rpt_freq varchar2 1 No This field contains the EDI sales report frequency for this supplier. Valid values are
edi_supp_available_ind varchar21 0 1 This field indicates whether the supplier will send availability via EDI. sups edi_supp_available_ind varchar2 1 Yes This field indicates whether the supplier will send availability via EDI.
edi_contract_ind varchar21 0 1 This field indicates whether contracts will be sent to the supplier via EDI. sups edi_contract_ind varchar2 1 Yes This field 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 Electronic Data Interchange. Valid values are Y and N. sups edi_invc_ind varchar2 1 Yes Indicates whether invoices, debit memos and credit note requests will be sent to/from the supplier via Electronic Data Interchange. Valid values are Y and N.
edi_channel_ind number4 0 1 If the supplier is an EDI supplier and supports vendor initiated ordering, this field will contain the channel ID for the channel to which all inventory for these types of orders will flow. This field is used when a vendor initiated order is created for a physical warehouse to determine the virtual warehouse within the physical warehouse to which the inventory will flow. The virtual warehouse belonging to the indicated channel will be used. This will only be used in a multichannel environment supp_attr_tbl edi_channel_ind Number 4 No If the supplier is an EDI supplier and supports vendor initiated ordering, this field will contain the channel ID for the channel to which all inventory for these types of orders will flow. This field is used when a vendor initiated order is created for a physical warehouse to determine the virtual warehouse within the physical warehouse to which the inventory will flow. The virtual warehouse belonging to the indicated channel will be used. This will only be used in a multichannel environment
cost_chg_pct_var number12_4 0 1 This field 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. SUPS COST_CHG_PCT_VAR Number 12,4 No This field 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 This field 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 dialogue. SUPS COST_CHG_AMT_VAR NUMBER 20,4 No This field 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 dialogue.
replen_approval_ind varchar21 0 1 Indicates whether contract orders for the supplier should be created in Approved status. Valid values are Y and N. sups replen_approval_ind varchar2 1 Yes Indicates whether contract orders for the supplier should be created in Approved status. Valid values are Y and N.
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. 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.
payment_method varchar26 0 1 This field indicates the method of payment.LC(Letter of Credit). sups payment_method varchar2 6 No This field indicates the method of payment.LC(Letter of Credit).
contact_telex varchar220 0 1 This field contains the telex number of the partner or suppliers representative contact. SUPS CONTACT_TELEX varchar2 20 No This field contains the telex number of the partner or suppliers representative contact.
contact_email varchar2100 0 1 This field contains the email address of the partner or suppliers representative contact. SUPS CONTACT_EMAIL varchar2 100 No This field contains the email address of the partner or suppliers representative contact.
settlement_code varchar21 0 1 "This field indicates which payment process method is used for this supplier. Valid values are sups settlement_code varchar2 1 Yes "This field indicates which payment process method is used for this supplier. Valid values are
pre_mark_ind varchar21 0 1 This field 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. Valid values are Y and N. sups pre_mark_ind varchar2 1 Yes This field 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. Valid values are Y and N.
auto_appr_invc_ind varchar21 0 1 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. 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 never to be sent. This field will only be populated if invoice matching is installed. Debit memo codes will be held on the codes table under the code type IMDC. 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 never to be sent. This field will only be populated if invoice matching is installed. Debit memo codes will be held on the codes table under the code type IMDC.
freight_charge_ind varchar21 0 1 Indicates if a supplier is allowed to charge freight costs to the client. This field will only be populated if invoice matching is installed. Valid values are Y and N. sups freight_charge_ind varchar2 1 Yes Indicates if a supplier is allowed to charge freight costs to the client. This field will only be populated if invoice matching is installed. Valid values are Y and N.
auto_appr_dbt_memo_ind varchar21 0 1 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. 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.
prepay_invc_ind varchar21 0 1 Indicates whether or not all invoices for the supplier can be considered pre-paid invoices. This field will only be populated if invoice matching is installed. Valid values are Y and N. sups prepay_invc_ind varchar2 1 Yes Indicates whether or not all invoices for the supplier can be considered pre-paid invoices. This field will only be populated if invoice matching is installed. Valid values are Y and N.
backorder_ind varchar21 0 1 Indicates if backorders or partial shipments will be accepted. 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. sups vat_region number 4,0 No Contains the unique identifying number for the VAT region in the system.
inv_mgmt_lvl varchar26 0 1 Indicator that determines whether supplier inventory management information can be set up at the supplier/department level or just at the supplier level. Also determines if orders created through replenishment for this supplier should be split by department or not. If the supplier is returns-only, this field will be null. Otherwise, this field must have value. Values include sups inv_mgmt_lvl varchar2 D - Department. Split orders by department. S - Supplier. Split orders by supplier. No Indicator that determines whether supplier inventory management information can be set up at the supplier/department level or just at the supplier level. Also determines if orders created through replenishment for this supplier should be split by department or not. If the supplier is returns-only, this field will be null. Otherwise, this field must have value. Values include
service_perf_req_ind varchar21 0 1 Indicates if the suppliers services (e.g. shelf stocking) must be confirmed as performed before paying an invoice from that supplier. Valid values are Y (all service non-merchandise lines on an invoice from this supplier must be confirmed before the invoice can be paid) and N (services do not need to be confirmed). sups service_perf_req_ind varchar2 1 Yes Indicates if the suppliers services (e.g. shelf stocking) must be confirmed as performed before paying an invoice from that supplier. Valid values are Y (all service non-merchandise lines on an invoice from this supplier must be confirmed before the invoice can be paid) and N (services do not need to be confirmed).
invc_pay_loc varchar26 0 1 Indicates where invoices from this supplier are paid - at the store or centrally through corporate accounting. Valid values are S (paid at the store) and C (paid centrally). This field should only be S if using ReSA to accept payment at the store, and only populated when using invoice matching. sups invc_pay_loc varchar2 6 No Indicates where invoices from this supplier are paid - at the store or centrally through corporate accounting. Valid values are S (paid at the store) and C (paid centrally). This field should only be S if using ReSA to accept payment at the store, and only populated when using invoice matching.
invc_receive_loc varchar26 0 1 Indicates where invoices from this supplier are received - at the store or centrally through corporate accounting. Valid values are S (received at the store) and C (received centrally). This field should only be populated when using invoice matching. sups invc_receive_loc varchar2 6 No Indicates where invoices from this supplier are received - at the store or centrally through corporate accounting. Valid values are S (received at the store) and C (received centrally). This field should only be populated when using invoice matching.
addinvc_gross_net varchar26 0 1 Indicates if the supplier invoice lists items at gross cost instead of net (off-invoice discounts subtracted). Valid values are G (invoices at gross) or N (invoices at net). These are stored on the code table under a code type of INGN. SUPS ADDINVC_GROSS_NET varchar2 6 No Indicates if the supplier invoice lists items at gross cost instead of net (off-invoice discounts subtracted). Valid values are G (invoices at gross) or N (invoices at net). These are stored on the code table under a code type of INGN.
delivery_policy varchar26 0 1 Contains the delivery policy of the supplier. Next Day indicates that the if a location is closed, the supplier will deliver on the next day. Next Valid Delivery Day indicates that the supplier will wait until the next scheduled delivery day before delivering. Valid values come from the DLVY code on code_head/code_detail. sups delivery_policy varchar2 6 Yes Contains the delivery policy of the supplier. Next Day indicates that the if a location is closed, the supplier will deliver on the next day. Next Valid Delivery Day indicates that the supplier will wait until the next scheduled delivery day before delivering. Valid values come from the DLVY code on code_head/code_detail.
comment_desc varchar22000 0 1 Any miscellaneous comments associated with the supplier. 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. sups default_item_lead_time number 4,0 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. sups duns_number varchar2 9 No This field holds the Dun and Bradstreet number to identify the supplier.
duns_loc varchar24 0 1 This field holds the Dun and Bradstreet number to identify the location of the supplier. sups duns_loc varchar2 4 No This field holds the Dun and Bradstreet number to identify the location of the supplier.
bracket_costing_ind varchar21 0 1 This field will determine if the supplier uses bracket costing pricing structures. Valid values SUPS BRACKET_COSTING_IND varchar2 Y = Yes, N = No. Yes This field will determine if the supplier uses bracket costing pricing structures. Valid values
vmi_order_status varchar26 0 1 This column determines the status in which any inbound POs from this supplier are created. A NULL value indicates that the supplier is not a VMI supplier. Orders from these suppliers will be still be created in worksheet status. sups vmi_order_status varchar2 6 No This column determines the status in which any inbound POs from this supplier are created. A NULL value indicates that the supplier is not a VMI supplier. Orders from these suppliers will be still be created in worksheet status.
dsd_ind varchar21 0 1 Indicates whether the supplier can ship direct to store. Valid values are Y and N. sups dsd_ind varchar2 1 Yes Indicates whether the supplier can ship direct to store. Valid values are Y and N.
scale_aip_orders varchar21 0 1 Depending upon the value in this column, scaling is done for AIP orders. Default value is N. sups scale_aip_orders varchar2 1 Yes Depending upon the value in this column, scaling is done for AIP orders. Default value is N.
sup_qty_level varchar26 0 1 Indicates the supplier order quantity level - 'CA' for cases, 'EA' for eaches. sups sup_qty_level varchar2 6 Yes This will hold the level at which quantity is ordered at. Valid values are CA for cases; EA for eaches. Default value if NULL is EA.
ExtOfSupplierDesc:ExtOfSupAttr * 0 1 Provide an extension hook to customize SupAttr. NA NA NA NA NA NA
LocOfSupplierDesc:LocOfSupAttr * 0 unbounded Provide an extension hook to localize SupAttr. NA NA NA NA NA NA

XML-Schema Name:ExtOfSupAttr 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 ExtOfSupAttr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description

XML-Schema Name:LocOfSupAttr 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 LocOfSupAttr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
InSupplierDesc:InSupAttr * 0 unbounded India Localization. NA NA NA NA NA NA
BrSupplierDesc:BrSupAttr * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:SupSite 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 SupSite in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
supsite_xref_key varchar232 1 1 Description is not available. * supsite_xref_key varchar2 32 Yes Fill this description.
supplier_site_id number10 0 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. * supplier_site_id number 10 No Fill this description.
SupAttr * 1 1 Description is not available.
SupSiteOrgUnit * 1 unbounded Description is not available.
SupSiteAddr * 1 unbounded Description is not available.
ExtOfSupplierDesc:ExtOfSupSite * 0 1 Provide an extension hook to customize SupSite. NA NA NA NA NA NA
LocOfSupplierDesc:LocOfSupSite * 0 unbounded Provide an extension hook to localize SupSite. NA NA NA NA NA NA

XML-Schema Name:SupAttr 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 SupAttr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
sup_name varchar2240 1 1 Contains the suppliers trading name. sups sup_name varchar2 240 Yes Contains the suppliers trading name.
sup_name_secondary varchar2240 0 1 Description is not 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 suppliers representative contact. SUPS CONTACT_NAME varchar2 120 Yes Contains the name of the suppliers representative contact.
contact_phone varchar220 0 1 Contains a telephone number for the suppliers representative contact. 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 suppliers representative contact. SUPS CONTACT_FAX varchar2 20 No Contains a fax number for the suppliers representative contact.
contact_pager varchar220 0 1 Contains the number for the pager of the suppliers representative contact. SUPS CONTACT_PAGER varchar2 20 No Contains the number for the pager of the suppliers representative contact.
sup_status varchar21 1 1 Determines whether the supplier is currently active. Valid values include 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 Determines whether the supplier is currently active. Valid values include
qc_ind varchar21 0 1 Determines whether orders from this supplier will default as requiring quality control. A value of Y means that all orders from this supplier will require quality control unless overridden by the user when the order is created. An N in this field means that quality control will not be required unless indicated by the user during order creation. sups qc_ind varchar2 1 Yes Determines whether orders from this supplier will default as requiring quality control. A value of Y means that all orders from this supplier will require quality control unless overridden by the user when the order is created. An N in this field means that quality control will not be required unless indicated by the user during order creation.
qc_pct number12_4 0 1 Indicates the percentage of items per receipt that will be marked for quality checking. sups qc_pct number 12,4 No Indicates the percentage of items per receipt that will be marked for quality checking.
qc_freq varchar22 0 1 Indicates the frequency in which items per receipt will be marked for quality checking. sups qc_freq number 2,0 No Indicates the frequency in which items per receipt will be marked for quality checking.
vc_ind varchar21 0 1 Determines whether orders from this supplier will default as requiring vendor control. A value of Y means that all orders from this supplier will require vendor control. An N in this field means that vendor control will not be required. sups vc_ind varchar2 1 Yes Determines whether orders from this supplier will default as requiring vendor control. A value of Y means that all orders from this supplier will require vendor control. An N in this field means that vendor control will not be required.
vc_pct number12_4 0 1 Indicates the percentage of items per receipt that will be marked for vendor checking. sups vc_pct number 12,4 No Indicates the percentage of items per receipt that will be marked for vendor checking.
vc_freq number2 0 1 Indicates the frequency in which items per receipt will be marked for vendor checking. sups vc_freq number 2,0 No Indicates the frequency in which items per receipt will be marked for vendor checking.
currency_code varchar23 1 1 Contains a code identifying the currency the supplier uses for business transactions. SUPS CURRENCY_CODE varchar2 3 Yes Contains a code identifying the currency the supplier uses for business transactions.
lang number6 1 1 This field contains the suppliers preferred language. This field is provided for custom purchase orders in a specified language. sups lang number 6,0 No This field contains the suppliers preferred language. This field is provided for custom purchase orders in a specified language.
terms varchar215 1 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. 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 1 1 Indicator that references what freight terms will default when a order is created for the supplier. sups freight_terms varchar2 30 Yes Indicator that references what freight terms will default when a 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. 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. Valid values are Y and N. sups ret_auth_req varchar2 1 Yes Indicates if returns must be accompanied by an authorization number when sent back to the vendor. Valid values are Y and N.
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 suppliers currency. sups ret_min_dol_amt number 20,4 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 suppliers currency.
ret_courier varchar2250 0 1 Contains the name of the courier that should be used for all returns to the supplier. sups ret_courier varchar2 250 No Contains the name of the courier that should be used for all returns to the supplier.
handling_pct number12_4 0 1 Percentage multiplied by the total order cost to determine the handling cost for the return. sups handling_pct number 12,4 No Percentage multiplied by the total order cost to determine the handling cost for the return.
edi_po_ind varchar21 0 1 Indicates whether purchase orders will be sent to the supplier via Electronic Data Interchange. Valid values are Y and N. sups edi_po_ind varchar2 1 Yes Indicates whether purchase orders will be sent to the supplier via Electronic Data Interchange. Valid values are Y and N.
edi_po_chg varchar21 0 1 Indicates whether purchase order changes will be sent to the supplier via Electronic Data Interchange. Valid values are Y and N. sups edi_po_chg varchar2 1 Yes Indicates whether purchase order changes will be sent to the supplier via Electronic Data Interchange. Valid values are Y and N.
edi_po_confirm varchar21 0 1 Indicates whether this supplier will send acknowledgment of a purchase orders sent via Electronic Data Interchange. Valid values are Y and N. sups edi_po_confirm varchar2 1 Yes Indicates whether this supplier will send acknowledgment of a purchase orders sent via Electronic Data Interchange. Valid values are Y and N.
edi_asn varchar21 0 1 Indicates whether this supplier will send Advance Shipment Notifications electronically. Valid values are Y and N. sups edi_asn varchar2 1 Yes Indicates whether this supplier will send Advance Shipment Notifications electronically. Valid values are Y and N.
edi_sales_rpt_freq varchar21 0 1 This field contains the EDI sales report frequency for this supplier. Valid values are sups edi_sales_rpt_freq varchar2 1 No This field contains the EDI sales report frequency for this supplier. Valid values are
edi_supp_available_ind varchar21 0 1 This field indicates whether the supplier will send availability via EDI. sups edi_supp_available_ind varchar2 1 Yes This field indicates whether the supplier will send availability via EDI.
edi_contract_ind varchar21 0 1 This field indicates whether contracts will be sent to the supplier via EDI. sups edi_contract_ind varchar2 1 Yes This field 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 Electronic Data Interchange. Valid values are Y and N. sups edi_invc_ind varchar2 1 Yes Indicates whether invoices, debit memos and credit note requests will be sent to/from the supplier via Electronic Data Interchange. Valid values are Y and N.
edi_channel_ind number4 0 1 If the supplier is an EDI supplier and supports vendor initiated ordering, this field will contain the channel ID for the channel to which all inventory for these types of orders will flow. This field is used when a vendor initiated order is created for a physical warehouse to determine the virtual warehouse within the physical warehouse to which the inventory will flow. The virtual warehouse belonging to the indicated channel will be used. This will only be used in a multichannel environment supp_attr_tbl edi_channel_ind Number 4 No If the supplier is an EDI supplier and supports vendor initiated ordering, this field will contain the channel ID for the channel to which all inventory for these types of orders will flow. This field is used when a vendor initiated order is created for a physical warehouse to determine the virtual warehouse within the physical warehouse to which the inventory will flow. The virtual warehouse belonging to the indicated channel will be used. This will only be used in a multichannel environment
cost_chg_pct_var number12_4 0 1 This field 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. SUPS COST_CHG_PCT_VAR Number 12,4 No This field 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 This field 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 dialogue. SUPS COST_CHG_AMT_VAR NUMBER 20,4 No This field 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 dialogue.
replen_approval_ind varchar21 0 1 Indicates whether contract orders for the supplier should be created in Approved status. Valid values are Y and N. sups replen_approval_ind varchar2 1 Yes Indicates whether contract orders for the supplier should be created in Approved status. Valid values are Y and N.
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. 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.
payment_method varchar26 0 1 This field indicates the method of payment.LC(Letter of Credit). sups payment_method varchar2 6 No This field indicates the method of payment.LC(Letter of Credit).
contact_telex varchar220 0 1 This field contains the telex number of the partner or suppliers representative contact. SUPS CONTACT_TELEX varchar2 20 No This field contains the telex number of the partner or suppliers representative contact.
contact_email varchar2100 0 1 This field contains the email address of the partner or suppliers representative contact. SUPS CONTACT_EMAIL varchar2 100 No This field contains the email address of the partner or suppliers representative contact.
settlement_code varchar21 0 1 "This field indicates which payment process method is used for this supplier. Valid values are sups settlement_code varchar2 1 Yes "This field indicates which payment process method is used for this supplier. Valid values are
pre_mark_ind varchar21 0 1 This field 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. Valid values are Y and N. sups pre_mark_ind varchar2 1 Yes This field 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. Valid values are Y and N.
auto_appr_invc_ind varchar21 0 1 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. 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 never to be sent. This field will only be populated if invoice matching is installed. Debit memo codes will be held on the codes table under the code type IMDC. 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 never to be sent. This field will only be populated if invoice matching is installed. Debit memo codes will be held on the codes table under the code type IMDC.
freight_charge_ind varchar21 0 1 Indicates if a supplier is allowed to charge freight costs to the client. This field will only be populated if invoice matching is installed. Valid values are Y and N. sups freight_charge_ind varchar2 1 Yes Indicates if a supplier is allowed to charge freight costs to the client. This field will only be populated if invoice matching is installed. Valid values are Y and N.
auto_appr_dbt_memo_ind varchar21 0 1 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. 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.
prepay_invc_ind varchar21 0 1 Indicates whether or not all invoices for the supplier can be considered pre-paid invoices. This field will only be populated if invoice matching is installed. Valid values are Y and N. sups prepay_invc_ind varchar2 1 Yes Indicates whether or not all invoices for the supplier can be considered pre-paid invoices. This field will only be populated if invoice matching is installed. Valid values are Y and N.
backorder_ind varchar21 0 1 Indicates if backorders or partial shipments will be accepted. 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. sups vat_region number 4,0 No Contains the unique identifying number for the VAT region in the system.
inv_mgmt_lvl varchar26 0 1 Indicator that determines whether supplier inventory management information can be set up at the supplier/department level or just at the supplier level. Also determines if orders created through replenishment for this supplier should be split by department or not. If the supplier is returns-only, this field will be null. Otherwise, this field must have value. Values include sups inv_mgmt_lvl varchar2 D - Department. Split orders by department. S - Supplier. Split orders by supplier. No Indicator that determines whether supplier inventory management information can be set up at the supplier/department level or just at the supplier level. Also determines if orders created through replenishment for this supplier should be split by department or not. If the supplier is returns-only, this field will be null. Otherwise, this field must have value. Values include
service_perf_req_ind varchar21 0 1 Indicates if the suppliers services (e.g. shelf stocking) must be confirmed as performed before paying an invoice from that supplier. Valid values are Y (all service non-merchandise lines on an invoice from this supplier must be confirmed before the invoice can be paid) and N (services do not need to be confirmed). sups service_perf_req_ind varchar2 1 Yes Indicates if the suppliers services (e.g. shelf stocking) must be confirmed as performed before paying an invoice from that supplier. Valid values are Y (all service non-merchandise lines on an invoice from this supplier must be confirmed before the invoice can be paid) and N (services do not need to be confirmed).
invc_pay_loc varchar26 0 1 Indicates where invoices from this supplier are paid - at the store or centrally through corporate accounting. Valid values are S (paid at the store) and C (paid centrally). This field should only be S if using ReSA to accept payment at the store, and only populated when using invoice matching. sups invc_pay_loc varchar2 6 No Indicates where invoices from this supplier are paid - at the store or centrally through corporate accounting. Valid values are S (paid at the store) and C (paid centrally). This field should only be S if using ReSA to accept payment at the store, and only populated when using invoice matching.
invc_receive_loc varchar26 0 1 Indicates where invoices from this supplier are received - at the store or centrally through corporate accounting. Valid values are S (received at the store) and C (received centrally). This field should only be populated when using invoice matching. sups invc_receive_loc varchar2 6 No Indicates where invoices from this supplier are received - at the store or centrally through corporate accounting. Valid values are S (received at the store) and C (received centrally). This field should only be populated when using invoice matching.
addinvc_gross_net varchar26 0 1 Indicates if the supplier invoice lists items at gross cost instead of net (off-invoice discounts subtracted). Valid values are G (invoices at gross) or N (invoices at net). These are stored on the code table under a code type of INGN. SUPS ADDINVC_GROSS_NET varchar2 6 No Indicates if the supplier invoice lists items at gross cost instead of net (off-invoice discounts subtracted). Valid values are G (invoices at gross) or N (invoices at net). These are stored on the code table under a code type of INGN.
delivery_policy varchar26 0 1 Contains the delivery policy of the supplier. Next Day indicates that the if a location is closed, the supplier will deliver on the next day. Next Valid Delivery Day indicates that the supplier will wait until the next scheduled delivery day before delivering. Valid values come from the DLVY code on code_head/code_detail. sups delivery_policy varchar2 6 Yes Contains the delivery policy of the supplier. Next Day indicates that the if a location is closed, the supplier will deliver on the next day. Next Valid Delivery Day indicates that the supplier will wait until the next scheduled delivery day before delivering. Valid values come from the DLVY code on code_head/code_detail.
comment_desc varchar22000 0 1 Any miscellaneous comments associated with the supplier. 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. sups default_item_lead_time number 4,0 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. sups duns_number varchar2 9 No This field holds the Dun and Bradstreet number to identify the supplier.
duns_loc varchar24 0 1 This field holds the Dun and Bradstreet number to identify the location of the supplier. sups duns_loc varchar2 4 No This field holds the Dun and Bradstreet number to identify the location of the supplier.
bracket_costing_ind varchar21 0 1 This field will determine if the supplier uses bracket costing pricing structures. Valid values SUPS BRACKET_COSTING_IND varchar2 Y = Yes, N = No. Yes This field will determine if the supplier uses bracket costing pricing structures. Valid values
vmi_order_status varchar26 0 1 This column determines the status in which any inbound POs from this supplier are created. A NULL value indicates that the supplier is not a VMI supplier. Orders from these suppliers will be still be created in worksheet status. sups vmi_order_status varchar2 6 No This column determines the status in which any inbound POs from this supplier are created. A NULL value indicates that the supplier is not a VMI supplier. Orders from these suppliers will be still be created in worksheet status.
dsd_ind varchar21 0 1 Indicates whether the supplier can ship direct to store. Valid values are Y and N. sups dsd_ind varchar2 1 Yes Indicates whether the supplier can ship direct to store. Valid values are Y and N.
scale_aip_orders varchar21 0 1 Depending upon the value in this column, scaling is done for AIP orders. Default value is N. sups scale_aip_orders varchar2 1 Yes Depending upon the value in this column, scaling is done for AIP orders. Default value is N.
sup_qty_level varchar26 0 1 Indicates the supplier order quantity level - 'CA' for cases, 'EA' for eaches. sups sup_qty_level varchar2 6 Yes This will hold the level at which quantity is ordered at. Valid values are CA for cases; EA for eaches. Default value if NULL is EA.
ExtOfSupplierDesc:ExtOfSupAttr * 0 1 Provide an extension hook to customize SupAttr. NA NA NA NA NA NA
LocOfSupplierDesc:LocOfSupAttr * 0 unbounded Provide an extension hook to localize SupAttr. NA NA NA NA NA NA

XML-Schema Name:ExtOfSupAttr 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 ExtOfSupAttr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description

XML-Schema Name:LocOfSupAttr 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 LocOfSupAttr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
InSupplierDesc:InSupAttr * 0 unbounded India Localization. NA NA NA NA NA NA
BrSupplierDesc:BrSupAttr * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:SupSiteOrgUnit 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 SupSiteOrgUnit in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
org_unit_id number15 1 1 This column holds the oracle organizational unit ID org_unit org_unit_id number 15 Yes This column holds the oracle organizational unit ID
primary_pay_site varchar21 0 1 Primary payment site indicator. partner_org_unit primary_pay_site varchar2 1 No Primary payment site indicator.
ExtOfSupplierDesc:ExtOfSupSiteOrgUnit * 0 1 Provide an extension hook to customize SupSiteOrgUnit. NA NA NA NA NA NA
LocOfSupplierDesc:LocOfSupSiteOrgUnit * 0 unbounded Provide an extension hook to localize SupSiteOrgUnit. NA NA NA NA NA NA

XML-Schema Name:ExtOfSupSiteOrgUnit 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 ExtOfSupSiteOrgUnit in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description

XML-Schema Name:LocOfSupSiteOrgUnit 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 LocOfSupSiteOrgUnit in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
InSupplierDesc:InSupSiteOrgUnit * 0 unbounded India Localization. NA NA NA NA NA NA
BrSupplierDesc:BrSupSiteOrgUnit * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:SupSiteAddr 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 SupSiteAddr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
addr_xref_key varchar232 0 1 This column contains a unique number used to distinguish between different addresses. * addr_xref_key varchar2 32 No Fill this description.
addr_key number11 0 1 This column contains a unique number used to distinguish between different addresses. addr addr_key number 11,0 Yes This column contains a unique number used to distinguish between different addresses.
Addr * 1 1 Description is not available.
ExtOfSupplierDesc:ExtOfSupSiteAddr * 0 1 Provide an extension hook to customize SupSiteAddr. NA NA NA NA NA NA
LocOfSupplierDesc:LocOfSupSiteAddr * 0 unbounded Provide an extension hook to localize SupSiteAddr. NA NA NA NA NA NA

XML-Schema Name:Addr 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 Addr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
addr_type varchar22 1 1 This column indicates the type for the address. Valid values are addr addr_type varchar2 01 - Business, 02 - Postal, 03 - Returns, 04 - Order, 05 - Invoice, 06 - Remittance Yes This column indicates the type for the address. Valid values are
primary_addr_ind varchar21 0 1 This column indicates whether the address is the primary address for the address type. addr primary_addr_ind varchar2 1 Yes This column indicates whether the address is the primary address for the address type.
add_1 varchar2240 1 1 This column contains the first line of the address. addr add_1 varchar2 240 Yes This column contains the first line of the address.
add_2 varchar2240 0 1 This column contains the second line of the address. addr add_2 varchar2 240 No This column contains the second line of the address.
add_3 varchar2240 0 1 This column contains the third line of the address. addr add_3 varchar2 240 No This column contains the third line of the address.
city varchar2120 1 1 This column contains the name of the city that is associated with the address. addr city varchar2 120 Yes This column contains the name of the city that is associated with the address.
state varchar23 0 1 This column contains the state abbreviation for the address. addr 3 varchar2 3 No This column contains the state abbreviation for the address.
country_id varchar23 1 1 This column contains the country where the address exists. addr country_id varchar2 3 Yes This column contains the country where the address exists.
post varchar230 0 1 This column contains the zip code for the address. addr post varchar2 30 No This column contains the zip code for the address.
contact_name varchar2120 0 1 This column contains the name of the contact for the supplier at this address. addr contact_name varchar2 120 No This column contains the name of the contact for the supplier at this address.
contact_phone varchar220 0 1 This column contains the phone number of the contact person at this address. addr contact_phone varchar2 20 No This column contains the phone number of the contact person at this address.
contact_fax varchar220 0 1 This column contains the fax number of the contact person at this address. addr contact_fax varchar2 20 No This column contains the fax number of the contact person at this address.
contact_email varchar2100 0 1 This column contains the email address of the partner or suppliers representative contact. addr contact_email varchar2 100 No This column contains the email address of the partner or suppliers representative contact.
jurisdiction_code varchar210 0 1 ID associated to the tax jurisdiction of the country-state relationship. addr jurisdiction_code varchar2 10 Yes Identifies the jurisdiction code for the country-state relationship.
ExtOfSupplierDesc:ExtOfAddr * 0 1 Provide an extension hook to customize Addr. NA NA NA NA NA NA
LocOfSupplierDesc:LocOfAddr * 0 unbounded Provide an extension hook to localize Addr. NA NA NA NA NA NA

XML-Schema Name:ExtOfAddr 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 ExtOfAddr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description

XML-Schema Name:LocOfAddr 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 LocOfAddr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
InSupplierDesc:InAddr * 0 unbounded India Localization. NA NA NA NA NA NA
BrSupplierDesc:BrAddr * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfSupSiteAddr 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 ExtOfSupSiteAddr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description

XML-Schema Name:LocOfSupSiteAddr 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 LocOfSupSiteAddr in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
InSupplierDesc:InSupSiteAddr * 0 unbounded India Localization. NA NA NA NA NA NA
BrSupplierDesc:BrSupSiteAddr * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfSupSite 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 ExtOfSupSite in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description

XML-Schema Name:LocOfSupSite 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 LocOfSupSite in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
InSupplierDesc:InSupSite * 0 unbounded India Localization. NA NA NA NA NA NA
BrSupplierDesc:BrSupSite * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfSupplierDesc 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 ExtOfSupplierDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description

XML-Schema Name:LocOfSupplierDesc 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 LocOfSupplierDesc in RMS application.
RMS's Table Name RMS's Column Name Integration API(RIB or/and RSB or/and RSL) RMS's Column Length Is Column Required in RMS's API? RMS's API Description
InSupplierDesc:InSupplierDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrSupplierDesc:BrSupplierDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA