Standard PO |
The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.
po_headers_interfaceUltriva Field Name | Oracle Lookup Table | Lookup Field | Field/Value | Oracle Open Interface Field Name |
|---|---|---|---|---|
NA | NA | NA | NA | interface_header_id |
NA | NA | NA | PO | interface_source_code |
NA | NA | NA | NA | batch_id |
NA | NA | NA | PENDING | process_code |
NA | NA | NA | 'ORIGINAL' | action |
NA | NA | NA | 'STANDARD' | document_type_code |
GID | NA | NA | NA | reference_num |
VENDOR_CODE | NA | NA | NA | vendor_id |
VENDOR_SITE_CODE | NA | NA | NA | vendor_site_id |
BUYER_LOGIN_NAME | APPS.FND_USER | UPPER(user_name) = UPPER(p_user_name) | USER_ID | agent_id |
NA | NA | NA | NA | currency_code |
NA | NA | NA | NULL | rate_type_code |
NA | NA | NA | NULL | rate_date |
NA | NA | NA | NULL | rate |
NA | NA | NA | NA | terms_id |
BUS_CODE | NA | NA | ORG_ID | org_id |
NA | NA | NA | SYSDATE | creation_date |
BUYER_LOGIN_NAME | APPS.FND_USER | UPPER(user_name) = UPPER(p_user_name) | USER_ID | created_by |
NA | NA | NA | SYSDATE | last_update_date |
BUYER_LOGIN_NAME | APPS.FND_USER | UPPER(user_name) = UPPER(p_user_name) | USER_ID | last_updated_by |
kanban_release_id | NA | NA | NA | attribute1 |
po_lines_interfaceUltriva Field Name | Oracle Lookup Table | Lookup Field | Field/Value | Oracle Open Interface Field Name |
|---|---|---|---|---|
NA | NA | NA | po_lines_interface_s.NEXTVAL | interface_line_id |
NA | NA | NA | NA | interface_header_id |
ITEM_NUM | NA | NA | NA | item_id |
UNIT_MEASURE | NA | NA | NA | unit_of_measure |
QUANTITY | NA | NA | NA | quantity |
BUS_CODE | org_organization_definitions | ood.set_of_books_id = fsp.set_of_books_id AND fsp.org_id = p_org_id AND SYSDATE < NVL(ood.disable_date, SYSDATE +1) AND ood.organization_code = TRIM(p_dest_org_code) | organization_id | ship_to_organization_id |
LOCATIONCODE | apps.hr_locations | location_code = TRIM(p_ship_to_location_code) | locator_id | ship_to_location_id |
RequiredReceiveDate | NA | NA | NA | need_by_date |
NA | NA | NA | SYSDATE | last_update_date |
BUYER_LOGIN_NAME | APPS.FND_USER | UPPER(user_name) = UPPER(p_user_name) | USER_ID | last_updated_by |
NA | NA | NA | SYSDATE | creation_date |
BUYER_LOGIN_NAME | APPS.FND_USER | UPPER(user_name) = UPPER(p_user_name) | USER_ID | created_by |
ORG_ID | NA | NA | NA | organization_id |
GID | NA | NA | NA | line_reference_num |
Kanban_release_id | NA | NA | NA | line_attribute1 |
ITEM_REVISION | NA | NA | NA | ITEM_REVISION |