Click or drag to resize

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