 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:VendorDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| VendorHdrDesc | * | vendorhdrdesc | Yes | * |
| VendorAddrDesc | * | vendoraddrdesc | Yes | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:VendorHdrDesc |
| Tag Name | Table Name | Column Name | API Req | Description |
| supplier | vendor | vendor_nbr | Yes | * |
| sup_name | vendor | vendor_name | Yes | * |
| contact_name | n/a | n/a | Yes | Not used in RWMS. |
| contact_phone | n/a | n/a | Yes | Not used in RWMS. |
| contact_fax | n/a | n/a | No | Not used in RWMS. |
| contact_pager | n/a | n/a | No | Not used in RWMS. |
| sup_status | vendor | sup_status | Yes | * |
| qc_ind | n/a | n/a | No | Not used in RWMS. |
| qc_pct | vendor | percent_qa_sampling | No | * |
| qc_freq | vendor | freq_qa_audit | No | * |
| vc_ind | n/a | * | Yes | Not used in RWMS. |
| vc_pct | vendor | percent_va_sampling | No | * |
| vc_freq | vendor | freq_va_audit | No | * |
| currency_code | n/a | n/a | Yes | Not used in RWMS. |
| lang | n/a | n/a | No | Not used in RWMS. |
| terms | n/a | n/a | No | Not used in RWMS. |
| freight_terms | n/a | n/a | No | Not used in RWMS. |
| ret_allow_ind | n/a | n/a | No | Not used in RWMS. |
| ret_auth_req | n/a | n/a | No | Not used in RWMS. |
| ret_min_dol_amt | n/a | n/a | No | Not used in RWMS. |
| ret_courier | n/a | n/a | No | Not used in RWMS. |
| handling_pct | n/a | n/a | No | Not used in RWMS. |
| edi_po_ind | n/a | n/a | Yes | Not used in RWMS. |
| edi_po_chg | n/a | n/a | No | Not used in RWMS. |
| edi_po_confirm | n/a | n/a | No | Not used in RWMS. |
| edi_asn | n/a | n/a | No | Not used in RWMS. |
| edi_sales_rpt_freq | n/a | n/a | No | Not used in RWMS. |
| edi_supp_available_ind | n/a | n/a | Yes | Not used in RWMS. |
| edi_contract_ind | n/a | n/a | No | Not used in RWMS. |
| edi_invc_ind | n/a | n/a | No | Not used in RWMS. |
| cost_chg_pct_var | n/a | n/a | No | Not used in RWMS. |
| cost_chg_amt_var | n/a | n/a | No | Not used in RWMS. |
| replen_approval_ind | n/a | n/a | No | Not used in RWMS. |
| ship_method | n/a | n/a | No | Not used in RWMS. |
| payment_method | n/a | n/a | No | Not used in RWMS. |
| contact_telex | n/a | n/a | No | Not used in RWMS. |
| contact_email | n/a | n/a | No | Not used in RWMS. |
| settlement_code | n/a | n/a | No | Not used in RWMS. |
| pre_mark_ind | n/a | n/a | No | Not used in RWMS. |
| auto_appr_invc_ind | * | * | * | * |
| dbt_memo_code | * | * | * | * |
| freight_charge_ind | * | * | * | * |
| auto_appr_dbt_memo_ind | n/a | n/a | No | Not used in RWMS. |
| inv_mgmt_lvl | n/a | n/a | No | Not used in RWMS. |
| backorder_ind | n/a | n/a | No | Not used in RWMS. |
| vat_region | n/a | n/a | No | Not used in RWMS. |
| prepay_invc_ind | n/a | n/a | No | Not used in RWMS. |
| service_perf_req_ind | n/a | n/a | No | Not used in RWMS. |
| invc_pay_loc | n/a | n/a | No | Not used in RWMS. |
| invc_receive_loc | n/a | n/a | No | Not used in RWMS. |
| addinvc_gross_net | n/a | n/a | No | Not used in RWMS. |
| delivery_policy | n/a | n/a | No | Not used in RWMS. |
| comment_desc | n/a | n/a | No | Not used in RWMS. |
| default_item_lead_time | n/a | n/a | No | Not used in RWMS. |
| duns_number | n/a | n/a | No | Not used in RWMS. |
| duns_loc | n/a | n/a | No | Not used in RWMS. |
| bracket_costing_ind | n/a | n/a | No | Not used in RWMS. |
| vmi_order_status | n/a | n/a | No | Not used in RWMS. |
| end_date_active | n/a | end_date_active | No | Not used in RWMS. |
| dsd_supplier_ind | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:VendorAddrDesc |
| Tag Name | Table Name | Column Name | API Req | Description |
| module | * | * | Yes | Not used in RWMS. |
| key_value_1 | n/a | n/a | Yes | Not used in RWMS. |
| key_value_2 | n/a | n/a | No | Not used in RWMS. |
| seq_no | vendor_address | seq_no | Yes | * |
| addr_type | vendor_address | addr_type | Yes | * |
| primary_addr_ind | vendor_address | primary_addr_ind | Yes | * |
| add_1 | vendor_address | address1 | Yes | * |
| add_2 | vendor_address | address2 | No | * |
| add_3 | vendor_address | address3 | No | * |
| city | vendor_address | city | Yes | * |
| state | vendor_address | state | Yes | * |
| country_id | vendor_address | country | Yes | * |
| post | vendor_address | shipto_zip | Yes | * |
| contact_name | n/a | n/a | No | Not used in RWMS. |
| contact_phone | n/a | n/a | No | Not used in RWMS. |
| contact_telex | n/a | n/a | No | Not used in RWMS. |
| contact_fax | n/a | n/a | No | Not used in RWMS. |
| contact_email | n/a | n/a | No | Not used in RWMS. |
| oracle_vendor_site_id | n/a | n/a | No | Not used in RWMS. |
| OracleOUDesc | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:OracleOUDesc |
| Tag Name | Table Name | Column Name | API Req | Description |
| OUDtlDesc | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:OUDtlDesc |
| Tag Name | Table Name | Column Name | API Req | Description |
| ou_id | * | * | * | * |
| site_id | * | * | * | * |