ASN |
When the supplier is ready with the goods, he uses Ultriva to do his shipment. Ultriva allows the supplier to print the shipping label in which ever format the customer has recommended. This label can contain customized information including the dedicated storage location or the line side where the material should be delivered. Another key information that is included is the bar coded Kanban ID (or Release ID). Supplier sticks the label to the box or pallet and ships it to the customer. Ultriva provides the in transit information to the customer and if necessary can generate the ASN (Advanced Shipment Notice).
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 | rcv_headers_interface_s.NEXTVAL | header_interface_id |
NA | NA | NA | rcv_interface_groups_s.NEXTVAL | group_id |
NA | NA | NA | ''PENDING' | processing_status_code |
NA | NA | NA | ''VENDOR' | receipt_source_code |
NA | NA | NA | ''ASN' | asn_type |
NA | NA | NA | ''SHIP' | auto_transact_code |
NA | NA | NA | ''NEW' | TRANSACTION_TYPE |
NA | NA | NA | SYSDATE | creation_date |
NA | NA | NA | SYSDATE | last_update_date |
NA | NA | NA | 0 | last_update_login |
NA | NA | NA | Y | validation_flag |
BUYER_LOGIN_NAME | APPS.FND_USER | UPPER(user_name) = UPPER(p_user_name) | USER_ID | last_updated_by |
BUYER_LOGIN_NAME | APPS.FND_USER | UPPER(user_name) = UPPER(p_user_name) | USER_ID | created_by |
VENDOR_CODE | apps.po_vendors | segment1 = vendor_code | vendor_id | 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 | vendor_site_id |
SHIPPED_DATE | NA | NA | NA | SHIPPED_DATE |
Expect_Recv_Date | NA | NA | NA | expected_receipt_date |
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 | ship_to_organization_id |
BUYER_LOGIN_NAME | APPS.FND_User | UPPER(user_name) = UPPER(p_user_name) | employee_id | employee_id |
GID | NA | NA | NA | SHIPMENT_NUM |
releaseid | NA | NA | NA | comments |
Ultriva Field Name | Oracle Lookup Table | Lookup Field | Field/Value | Oracle Open Interface Field Name |
---|---|---|---|---|
NA | NA | NA | rcv_transactions_interface_s.NEXTVAL | interface_transaction_id |
NA | NA | NA | rcv_interface_groups_s.currval | group_id |
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 |
NA | NA | NA | 0 | last_update_login |
NA | NA | NA | SHIP | transaction_type |
SHIPPED_DATE | NA | NA | NA | transaction_date |
NA | NA | NA | 'PENDING' | transaction_status_code |
NA | NA | NA | 'PENDING' | processing_status_code |
NA | NA | NA | 'BATCH' | processing_mode_code |
QUANTITY | NA | NA | NA | quantity |
unit_of_measure | mtl_units_of_measure | UOM_CODE = TRIM(p_unit_of_measure) OR unit_of_measure = TRIM(p_unit_of_measure) | unit_of_measure | unit_of_measure |
item_num | mtl_system_items_kfv | concatenated_segments = TRIM(p_item_num) AND organization_id = p_ship_to_organization_id | NA | item_id |
NA | NA | NA | ''SHIP' | auto_transact_code |
NA | NA | ORG_ID | NA | ship_to_location_id |
NA | NA | NA | 'VENDOR' | receipt_source_code |
NA | NA | NA | VENDOR_ID | vendor_id |
NA | NA | NA | VENDOR_SITE_ID | vendor_site_id |
NA | NA | NA | 'PO' | source_document_code |
ERP_PO_NUMBER | NA | NA | NA | po_header_id |
NA | NA | NA | HEADER_INTERFACE_ID | header_interface_id |
ERP_PO_LINE_NUM | NA | NA | NULL OR PO_LINE_ID | po_line_id |
ERP_PO_RELEASE_LINE_NUM | NA | NA | Null or LINE_LOCATION_ID | po_line_location_id |
ERP_PO_RELEASE_NUM | NA | NA | NULL OR PO_RELEASE_ID | po_release_id |
BUYER_LOGIN_NAME | APPS.FND_User | UPPER(user_name) = UPPER(p_user_name) | employee_id | employee_id |
SUBINVENTORY | NA | NA | NA | subinventory |
Expect_Recv_Date | NA | NA | NA | expected_receipt_date |
NA | NA | NA | ''Y' | validation_flag |
NA | NA | NA | ''ASN Interfaced from UEK' | comments |