Supplier |
The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.
Ultriva Field Name | Oracle Table | Oracle Mapping | Description |
---|---|---|---|
Plant Code | MTL_SYSTEM_ITEMS_B, MTL_PARAMETERS | ORGANIZATION_ID | NA |
Supplier Code | PO_APPROVED_SUPPLIER_LIST/PO_VENDORS | VENDOR_ID | NA |
Supplier Name | PO_APPROVED_SUPPLIER_LIST/PO_VENDORS | VENDOR_NAME | NA |
Address 1 | PO_VENDORS/PO_VENDOR_SITES_ALL | ADDRESS_LINE1 | NA |
Address 2 | PO_VENDORS/PO_VENDOR_SITES_ALL | ADDRESS_LINE2 | NA |
Address 3 | PO_VENDORS/PO_VENDOR_SITES_ALL | ADDRESS_LINE3 | NA |
City | PO_VENDORS/PO_VENDOR_SITES_ALL | CITY | NA |
State | PO_VENDORS/PO_VENDOR_SITES_ALL | STATE | NA |
Zip | PO_VENDORS/PO_VENDOR_SITES_ALL | ZIP | NA |
Country | PO_VENDORS/PO_VENDOR_SITES_ALL | COUNTRY | NA |