Blanket PO Release |
 Note |
|---|
The Oracle interface table for this transaction is INSERT |
The following table(s) illustrate(s) the data mapping between Ultriva and Oracle.
Ultriva Field Name | Oracle Lookup Table | Lookup Field | Field/Value | Oracle Open Interface Field Name |
|---|---|---|---|---|
NA | NA | NA | UEK_ORACLE_PO_BATCH_S.NEXTVAL | batch_id |
NA | NA | NA | 'UEK BPA' | interface_source_code |
NA | NA | NA | 'PENDING' | process_flag |
NA | NA | NA | 'INVENTORY' | destination_type_code |
NA | NA | NA | 'APPROVED' | authorization_status |
GID | NA | NA | GID | req_number_segment1 |
NA | NA | NA | GID | reference_num |
NA | apps.mtl_parameters_view | cost_organization_id = ship_to_organization_id (resolved using DESTINATION_ORGANIZATION_CODE) | material_account | charge_account_id |
NA | apps.gl_sets_of_books | fsp.set_of_books_id = sob.set_of_books_id and fsp.org_id = org_id | currency_code | currency_code |
ITEM_NUM | APPS.MTL_SYSTEM_ITEMS_KFV | concatenated_segments = ITEM_NUM AND organization_id = l_ship_to_organization_id | INVENTORY_ITEM_ID | item_id |
QUANTITY | NA | NA | QUANTITY | quantity |
UNIT_OF_MEASURE | apps.mtl_units_of_measure | unit_of_measure = UNIT_OF_MEASURE | uom_code | uom_code |
DESTINATION_ORGANIZATION_CODE | apps.org_organization_definitions | organization_code = DESTINATION_ORGANIZATION_CODE AND apps.financials_system_params_all.set_of_books_id = apps.org_organization_definitions.set_of_books_id AND apps.financials_system_params_all.ORG_ID = ORG_ID | organization_id | destination_organization_id |
DESTINATION_SUBINVENTORY | NA | NA | DESTINATION_SUBINVENTORY | destination_subinventory |
DELIVER_TO_LOCATION_CODE | apps.hr_locations | location_code = TRIM(deliver_to_location_code) and inventory_organization_id = l_ship_to_organization_id and ship_to_site_flag = 'Y' | location_id | deliver_to_location_id |
[BUYER_CODE] | NA | NA | EMPlOYEE_ID (Buyer) | deliver_to_requestor_id |
NA | NA | NA | NULL | unit_price |
NA | NA | NA | 'VENDOR' | source_type_code |
NEED_BY_DATE (Required Receive Date) | NA | NA | NEED_BY_DATE | NEED_BY_DATE |
ORG_ID | apps.hr_operating_units | organization_id = ORG_ID | organization_id | ORG_ID |
VENDOR_CODE | apps.po_vendors | segment1 = vendor_code | vendor_id | suggested_vendor_id |
VENDOR_SITE_CODE | apps.po_vendor_sites_all | vendor_site_code = vendor_site_code AND org_id = ORG_ID AND vendor_id = vendor_id | VENDOR_SITE_ID | suggested_vendor_site_id |
BUYER_CODE | APPS.FND_uSER | user_name = buyer_code | EMPlOYEE_ID (Buyer) | preparer_id |
ERP_PO_NUMBER | APPS.PO_HEADERS_ALL | SEGment1 = ERP_PO_NUMBER | PO_HEADER_ID | autosource_doc_header_id |
ERP_PO_LINE_NUMBER | NA | NA | ERP_PO_LINE_NUMBER | autosource_doc_line_num |
ERP_PO_RELEASE_NUM | NA | NA | NA | NA |
ERP_PO_RELEASE_LINE_NUM | NA | NA | NA | NA |
NA | NA | NA | 'BLANKET' | document_type_code |
NA | NA | NA | buyer_employee_id | created_by |
NA | NA | NA | sysdate | last_update_date |
NA | NA | NA | buyer_employee_id | last_updated_by |
NA | NA | NA | sysdate | creation_date |
NA | NA | NA | 'PURCHASE' | requisition_type |
NA | NA | NA | NA | NA |
NA | NA | NA | NA | NA |
NA | NA | NA | 'VENDOR' | source_type_code |