 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Store Inventory Management |
Version 13.0.1 |
XML-Schema or Node Name:VendorDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| VendorHdrDesc | * | * | * | * |
| VendorAddrDesc | * | * | * | * |
| Application Name: Store Inventory Management |
Version 13.0.1 |
XML-Schema or Node Name:VendorHdrDesc |
| Tag Name | Table Name | Column Name | API Req | Description |
| supplier | PA_SPR | ID_SPR | Yes | Not Yet Available |
| sup_name | PA_SPR | NM_SPR | No | Not Yet Available |
| contact_name | ||||
| contact_phone | ||||
| contact_fax | ||||
| contact_pager | ||||
| sup_status | PA_SPR | STATUS | No | Not Yet Available |
| qc_ind | ||||
| qc_pct | ||||
| qc_freq | ||||
| vc_ind | PA_SPR | VC_IND | No | Not Yet Available |
| vc_pct | PA_SPR | VC_PCT | No | Not Yet Available |
| vc_freq | ||||
| currency_code | PA_SPR | CURRENCY_CODE | No | Not Yet Available |
| lang | ||||
| terms | ||||
| freight_terms | ||||
| ret_allow_ind | PA_SPR | ST_RETURNS_ALLOWED | No | Not Yet Available |
| ret_auth_req | PA_SPR | ST_RETURN_NUM_IND | No | Not Yet Available |
| ret_min_dol_amt | ||||
| ret_courier | ||||
| handling_pct | ||||
| edi_po_ind | ||||
| edi_po_chg | ||||
| edi_po_confirm | ||||
| edi_asn | ||||
| edi_sales_rpt_freq | ||||
| edi_supp_available_ind | ||||
| edi_contract_ind | ||||
| edi_invc_ind | ||||
| cost_chg_pct_var | ||||
| cost_chg_amt_var | ||||
| replen_approval_ind | ||||
| ship_method | ||||
| payment_method | ||||
| contact_telex | ||||
| contact_email | ||||
| settlement_code | ||||
| pre_mark_ind | ||||
| auto_appr_invc_ind | ||||
| dbt_memo_code | ||||
| freight_charge_ind | ||||
| auto_appr_dbt_memo_ind | ||||
| inv_mgmt_lvl | ||||
| backorder_ind | ||||
| vat_region | ||||
| prepay_invc_ind | ||||
| service_perf_req_ind | ||||
| invc_pay_loc | ||||
| invc_receive_loc | ||||
| addinvc_gross_net | ||||
| delivery_policy | ||||
| comment_desc | ||||
| default_item_lead_time | ||||
| duns_number | PA_SPR | DU_SPR | No | Not Yet Available |
| duns_loc | ||||
| bracket_costing_ind | ||||
| vmi_order_status | ||||
| end_date_active | PA_RO_PRTY | DC_RO_PRTY_EP | No | Not Yet Available |
| dsd_supplier_ind | PA_SPR | ST_CRT_PO_IND | No | Not Yet Available |
| Application Name: Store Inventory Management |
Version 13.0.1 |
XML-Schema or Node Name:VendorAddrDesc |
| Tag Name | Table Name | Column Name | API Req | Description |
| module | ||||
| key_value_1 | ||||
| key_value_2 | ||||
| seq_no | ||||
| addr_type | ||||
| primary_addr_ind | ||||
| add_1 | LO_ADS_NSTD | A1_ADS | No | Not Yet Available |
| add_2 | LO_ADS_NSTD | A2_ADS | No | Not Yet Available |
| add_3 | LO_ADS_NSTD | A2_ADS | No | Not Yet Available |
| city | LO_ADS_NSTD | CITY | No | Not Yet Available |
| state | LO_ADS_NSTD | TE_NM | No | Not Yet Available |
| country_id | LO_ADS_NSTD | CO_NM | No | Not Yet Available |
| post | LO_ADS_NSTD | PC_NM | No | Not Yet Available |
| contact_name | PA_PRS | LN_PRS | Yes | Not Yet Available |
| contact_phone | LO_PH | TA_PH | No | Mapped to TL_PH, PH_EXTN as well. Not Yet Available |
| contact_telex | ||||
| contact_fax | LO_PH | TA_PH | No | Mapped to TL_PH, PH_EXTN as well. Not Yet Available |
| contact_email | LO_EML_ADS | EM_ADS | Yes | Not Yet Available |
| oracle_vendor_site_id | ||||
| OracleOUDesc | * | * | * | * |
| Application Name: Store Inventory Management |
Version 13.0.1 |
XML-Schema or Node Name:OracleOUDesc |
| Tag Name | Table Name | Column Name | API Req | Description |
| OUDtlDesc | * | * | * | * |
| Application Name: Store Inventory Management |
Version 13.0.1 |
XML-Schema or Node Name:OUDtlDesc |
| Tag Name | Table Name | Column Name | API Req | Description |
| ou_id | ||||
| site_id |