 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:PODesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| doc_type | po | doc_type | Yes | * |
| order_no | po | po_nbr | Yes | * |
| order_type | n/a | n/a | Yes | Not used in RWMS. |
| order_type_desc | n/a | n/a | Yes | Not used in RWMS. |
| dept | n/a | n/a | No | Not used in RWMS. |
| dept_name | n/a | n/a | No | Not used in RWMS. |
| buyer | * | buyer | No | * |
| buyer_name | po | buyer_code | No | * |
| supplier | po | vendor_nbr | Yes | * |
| promotion | n/a | n/a | No | Not used in RWMS. |
| prom_desc | n/a | n/a | No | Not used in RWMS. |
| qc_ind | n/a | n/a | Yes | Not used in RWMS. |
| not_before_date | po | deliv_not_before_date | No | * |
| not_after_date | po | deliv_not_after_date | No | * |
| otb_eow_date | n/a | n/a | No | Not used in RWMS. |
| earliest_ship_date | n/a | n/a | No | Not used in RWMS. |
| latest_ship_date | n/a | n/a | No | Not used in RWMS. |
| close_date | n/a | n/a | No | Not used in RWMS. |
| terms | n/a | n/a | Yes | Not used in RWMS. |
| terms_code | n/a | n/a | Yes | Not used in RWMS. |
| freight_terms | * | * | * | * |
| cust_order | n/a | n/a | Yes | Not used in RWMS. |
| payment_method | n/a | n/a | No | Not used in RWMS. |
| payment_method_desc | n/a | n/a | No | Not used in RWMS. |
| backhaul_type | n/a | n/a | No | Not used in RWMS. |
| backhaul_type_desc | n/a | n/a | No | Not used in RWMS. |
| backhaul_allowance | n/a | n/a | No | Not used in RWMS. |
| ship_method | po | transportation_mode | No | * |
| ship_method_desc | n/a | n/a | No | * |
| purchase_type | n/a | n/a | No | * |
| purchase_type_desc | n/a | n/a | No | * |
| status | po | status | Yes | * |
| ship_pay_method | n/a | n/a | No | Not used in RWMS. |
| ship_pay_method_desc | n/a | n/a | No | Not used in RWMS. |
| fob_trans_res | n/a | n/a | No | Not used in RWMS. |
| fob_trans_res_code_desc | n/a | n/a | No | Not used in RWMS. |
| fob_trans_res_desc | n/a | n/a | No | Not used in RWMS. |
| fob_title_pass | n/a | n/a | No | Not used in RWMS. |
| fob_title_pass_code_desc | n/a | n/a | No | Not used in RWMS. |
| fob_title_pass_desc | n/a | n/a | No | Not used in RWMS. |
| vendor_order_no | n/a | n/a | No | Not used in RWMS. |
| exchange_rate | n/a | n/a | No | Not used in RWMS. |
| factory | n/a | n/a | No | Not used in RWMS. |
| factory_desc | n/a | n/a | No | Not used in RWMS. |
| agent | n/a | n/a | No | Not used in RWMS. |
| agent_desc | n/a | n/a | No | Not used in RWMS. |
| discharge_port | n/a | n/a | No | Not used in RWMS. |
| discharge_port_desc | n/a | n/a | No | Not used in RWMS. |
| lading_port | n/a | n/a | No | Not used in RWMS. |
| lading_port_desc | n/a | n/a | No | Not used in RWMS. |
| bill_to_id | n/a | n/a | No | Not used in RWMS. |
| freight_contract_no | n/a | n/a | No | Not used in RWMS. |
| po_type | n/a | n/a | No | Not used in RWMS. |
| po_type_desc | po | po_type | No | * |
| pre_mark_ind | n/a | n/a | Yes | * |
| currency_code | n/a | n/a | Yes | Not used in RWMS. |
| contract_no | n/a | n/a | No | Not used in RWMS. |
| pickup_loc | n/a | n/a | No | Not used in RWMS. |
| pickup_no | n/a | n/a | No | Not used in RWMS. |
| pickup_date | n/a | n/a | No | Not used in RWMS. |
| app_datetime | n/a | n/a | No | Not used in RWMS. |
| comment_desc | po | po_comments | No | * |
| PODtl | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:PODtl |
| Tag Name | Table Name | Column Name | API Req | Description |
| item | po_detail | item_id | Yes | * |
| ref_item | n/a | n/a | No | Not used in RWMS. |
| physical_location_type | n/a | n/a | Yes | Not used in RWMS. |
| physical_location | n/a | n/a | Yes | Not used in RWMS. |
| physical_qty_ordered | po_detail | requested_unit_qty | No | * |
| unit_cost | n/a | n/a | No | Not used in RWMS. |
| origin_country_id | po_detail | country_code | No | * |
| supp_pack_size | po_detail | order_casepack | No | * |
| earliest_ship_date | n/a | n/a | No | Not used in RWMS. |
| latest_ship_date | n/a | n/a | No | Not used in RWMS. |
| pickup_loc | n/a | n/a | No | Not used in RWMS. |
| pickup_no | n/a | n/a | No | Not used in RWMS. |
| packing_method | n/a | n/a | No | Not used in RWMS. |
| round_lvl | po_detail | round_lvl | No | * |
| door_ind | po_detail | door_ind | No | * |
| priority_level | po_detail | priority_level | No | * |
| new_item | po_detail | new_item | No | * |
| quarantine | po_detail | quarantine | No | * |
| rcvd_unit_qty | po_detail | rcvd_unit_qty | No | * |
| tsf_po_link_id | n/a | n/a | No | Not used in RWMS. |
| POVirtualDtl | * | * | * | * |
| cost_source | * | * | * | * |
| est_in_stock_date | * | * | * | * |
| Application Name: Retail Warehouse Management System |
|
XML-Schema or Node Name:POVirtualDtl |
| Tag Name | Table Name | Column Name | API Req | Description |
| location_type | n/a | n/a | Yes | Not used in RWMS. |
| location | n/a | n/a | Yes | Not used in RWMS. |
| qty_ordered | n/a | n/a | No | Not used in RWMS. |