 |
Retail Integration Bus Mappings Report
|
 |
|
| Application Name: Store Inventory Management |
|
XML-Schema or Node Name:PODesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| order_no | RK_ORDERS | ORDER_ID | No | Not Yet Available |
| supplier | RK_ORDERS | SOURCE_ID | Yes | Not Yet Available |
| order_type_desc | ||||
| dept | ||||
| dept_name | ||||
| buyer | ||||
| buyer_name | ||||
| supplier | ||||
| promotion | ||||
| prom_desc | ||||
| qc_ind | ||||
| not_before_date | RK_ORDERS | NOT_BEFORE_DATE | No | Not Yet Available |
| not_after_date | RK_ORDERS | NOT_AFTER_DATE | No | Not Yet Available |
| otb_eow_date | ||||
| earliest_ship_date | ||||
| latest_ship_date | ||||
| close_date | ||||
| terms | ||||
| terms_code | ||||
| freight_terms | ||||
| cust_order | ||||
| payment_method | ||||
| payment_method_desc | ||||
| backhaul_type | ||||
| backhaul_type_desc | ||||
| backhaul_allowance | ||||
| ship_method | ||||
| ship_method_desc | ||||
| purchase_type | ||||
| purchase_type_desc | ||||
| status | RK_ORDERS | STATUS | No | Not Yet Available |
| ship_pay_method | ||||
| ship_pay_method_desc | ||||
| fob_trans_res | ||||
| fob_trans_res_code_desc | ||||
| fob_trans_res_desc | ||||
| fob_title_pass | ||||
| fob_title_pass_code_desc | ||||
| fob_title_pass_desc | ||||
| vendor_order_novendor_order_no | ||||
| exchange_rate | ||||
| factory | ||||
| factory_desc | ||||
| agent | ||||
| agent_desc | ||||
| discharge_port | ||||
| discharge_port_desc | ||||
| lading_port | ||||
| lading_port_desc | ||||
| bill_to_id | ||||
| freight_contract_no | ||||
| po_type | ||||
| po_type_desc | ||||
| pre_mark_ind | ||||
| currency_code | ||||
| contract_no | ||||
| pickup_loc | ||||
| pickup_no | ||||
| pickup_date | ||||
| app_datetime | ||||
| comment_desc | RK_ORDERS | COMMENT_DESC | No | Not Yet Available |
| PODtl | * | * | * | * |
| Application Name: Store Inventory Management |
|
XML-Schema or Node Name:PODtl |
| Tag Name | Table Name | Column Name | API Req | Description |
| item | RK_ORDER_ITM | ID_ITM | No | Not Yet Available |
| ref_item | ||||
| physical_location_type | ||||
| physical_location | RK_ORDER_ITM | ID_STR_RT | No | Not Yet Available |
| physical_qty_ordered | RK_ORDER_ITM | QUANTITY_EXPECTED | No | Not Yet Available |
| unit_cost | RK_ORDER_ITM | UNIT_COST | No | Not Yet Available |
| origin_country_id | ||||
| supp_pack_size | ||||
| earliest_ship_date | ||||
| latest_ship_date | ||||
| pickup_loc | ||||
| pickup_no | ||||
| packing_method | ||||
| round_lvl | ||||
| door_ind | ||||
| priority_level | ||||
| new_item | ||||
| quarantine | ||||
| rcvd_unit_qty | RK_ORDER_ITM | QUANTITY_RECEIVED | No | Not Yet Available |
| tsf_po_link_id | ||||
| POVirtualDtl | * | * | * | * |
| cost_source | ||||
| est_in_stock_date |
| Application Name: Store Inventory Management |
|
XML-Schema or Node Name:POVirtualDtl |
| Tag Name | Table Name | Column Name | API Req | Description |
| location_type | ||||
| location | ||||
| qty_ordered |