XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for VendorHdrDesc 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 |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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. |
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). |
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. |
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. |
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. |
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. |
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. |
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 |
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. |
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. |
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. |
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. |
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 |
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. |
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. |
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'). |
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'). |
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. |
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. |
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 |
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 |
The Dun and Bradstreet number of the location of the supplier. |
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. |
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. |
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. |
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. |
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. |
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. |
sups |
SUP_NAME |
varchar2 |
240 |
Yes |
Contains the suppliers trading name. |
final_dest_ind |
varchar21 |
0 |
1 |
Final Destination Indicator. |
sups |
FINAL_DEST_IND |
varchar2 |
1 |
Yes |
Final Destination Indicator. |