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
|