Script | Description |
wm_install_into_rcv.sql | Runs the scripts listed below, except the uninstall script. |
wm_into_rcv_pkg.sql | Installs WM_RECEIVING_IMP_HANDLER_PKG.WM_HANDLE_RECEIVING, which calls the WM_CONC_REQUEST.WM_REQUEST_SUBMIT to submit the Receiving Transactions Import Concurrent request program. |
wm_into_rcv_seq.sql | Create the WM_RCV_GROUP_S component, which creates the unique GROUP_ID sequence. |
wm_drop_into_rcv.sql | Uninstalls all components created by wm_install_into_rcv.sql. |
Field Name | Maps to Column | Description |
WEB_TRANSACTION_ ID | Not used for this service. | |
DOCUMENT_TYPE | Not used for this service. | |
DOCUMENT_STATUS | Not used for this service. | |
EDI_CONTROL_NUM | EDI_CONTROL_NUM | EDI transaction control number. |
ASN_TYPE | ASN_TYPE | The document type value are: ASN for an ASN ASBN for an ASN with billing information blank for RECEIPT |
ACCOUNTING_DATE | Not used for this service. | |
TRANSACTION_TYPE | TRANSACTION_TYPE | Required. The transaction purpose code values are NEW or CANCEL. |
AUTO_TRANSACT_ CODE | AUTO_TRANSACT_ CODE | Required. Automatic transaction creation code of the shipment values are SHIP, RECEIVE, or DELIVER. |
NOTICE_CREATION_ DATE | NOTICE_CREATION_ DATE | EDI transaction creation date and time at the source. |
SHIPMENT_NUM | SHIPMENT_NUM | Shipment number assigned by the shipment’s source. |
RECEIPT_NUM | RECEIPT_NUM | Required if AUTO_TRANSACT_CODE is not SHIP and receipt numbering method in purchasing’s receiving options is Manual. |
VENDOR_NAME | VENDOR_NAME | Required. |
VENDOR_NUM | VENDOR_NUM | Required if the vendor name is not provided. |
VENDOR_SITE_ ADDRESS_LINE1 | VENDOR_SITE_ ID | Address of the vendor site, which derives the Vendor Site ID in the Interface table. See the transformer commonOA1227.utils: getVendorSiteId. |
VENDOR_SITE_ ADDRESS_LINE2 | ||
VENDOR_SITE_ ADDRESS_LINE3 | ||
VENDOR_TOWN_ OR_CITY | ||
VENDOR_COUNTY | ||
VENDOR_STATE | ||
VENDOR_POSTAL_ CODE | ||
VENDOR_COUNTRY | ||
SHIP_TO_ ORGANIZATION_NAME | SHIP_TO_ ORGANIZATION_ID | Derives the Ship To Organization ID. See the transformer commonOA1227.utils: getOrgId. |
LOCATION_ADDRESS_ LINE1 | LOCATION_ID | Derives the Location ID based on the Ship To Location Address. See the transformer commonOA1227.utils: getLocationId. |
LOCATION_ADDRESS_ LINE2 | ||
LOCATION_SITE_ ADDRESS_LINE3 | ||
LOCATION_TOWN_ OR_CITY | ||
LOCATION_COUNTY | ||
LOCATION_STATE | ||
LOCATION_POSTAL_ CODE | ||
LOCATION_COUNTRY | ||
PACKING_SLIP | PACKING_SLIP | Packing slip number. |
FREIGHT_CARRIER_ CODE | FREIGHT_CARRIER_ CODE | Carrier responsible for shipment. |
EXPECTED_RECEIPT_ DATE | EXPECTED_RECEIPT_ DATE | |
NUMBER_OF_ CONTAINERS | NUMBER_OF_ CONTAINERS | Number of containers in the shipment. |
WAYBILL_AIRBILL_ NUM | WAYBILL_AIRBILL_ NUM | Waybill or air bill number. |
COMMENTS | COMMENTS | |
GROSS_WEIGHT | GROSS_WEIGHT | |
GROSS_WEIGHT_ UOM_CODE | GROSS_WEIGHT_ UOM_CODE | Shipment gross weight unit of Measure from ASN. |
NET_WEIGHT | NET_WEIGHT | |
NET_WEIGHT_ UOM_CODE | NET_WEIGHT_ UOM_CODE | Shipment net weight unit of measure from ASN. |
TAR_WEIGHT | TAR_WEIGHT | Shipment tar (container) weight from ASN. |
TAR_WEIGHT_ UOM_CODE | TAR_WEIGHT_ UOM_CODE | Shipment tar (container) weight unit from ASN. |
PACKAGING_CODE | PACKAGING_CODE | |
CARRIER_METHOD | CARRIER_METHOD | Carrier method code. |
CARRIER_EQUIPMENT | CARRIER_EQUIPMENT | |
SPECIAL_HANDLING_ CODE | SPECIAL_HANDLING_ CODE | |
HAZARD_CODE | HAZARD_CODE | |
HAZARD_CLASS | HAZARD_CLASS | |
HAZARD_ DESCRIPTION | HAZARD_DESCRIPTION | |
FREIGHT_TERMS | FREIGHT_TERMS | |
FREIGHT_BILL_ NUMBER | FREIGHT_BILL_ NUMBER | |
INVOICE_NUM | INVOICE_NUM | EDI transaction 857 invoice number associated with the shipment or billing notice (ASN with billing information). |
INVOICE_DATE | INVOICE_DATE | Invoice date for the invoice number. |
TOTAL_INVOICE_ AMOUNT | TOTAL_INVOICE_ AMOUNT | Total invoice amount for the invoice number. |
TAX_NAME | TAX_NAME | EDI transaction 857 tax name associated with the shipment or billing notice. |
TAX_AMOUNT | TAX_AMOUNT | Tax amount for the tax name. |
FREIGHT_AMOUNT | FREIGHT_AMOUNT | EDI transaction 857 freight bill amount associated with the shipment or billing notice. |
CURRENCY_CODE | CURRENCY_CODE | EDI transaction 857 currency code. |
CONVERSION_RATE | CONVERSION_RATE | EDI transaction 857 exchange rate. |
CONVERSION_RATE_ TYPE | CONVERSION_RATE_ TYPE | EDI transaction 857 exchange rate type. |
CONVERSION_RATE_ DATE | CONVERSION_RATE_ DATE | EDI transaction 857 exchange rate date. |
PAYMENT_TERMS_ NAME | PAYMENT_TERMS_ NAME | EDI transaction 857 payment terms name. |
USSGL_TRANSACTION_ CODE | USSGL_TRANSACTION_ CODE | US standard general ledger transaction code. |
EMPLOYEE_NAME | EMPLOYEE_NAME | |
INVOICE_STATUS_ CODE | INVOICE_STATUS_ CODE | Indicates when line items were rejected for ASN with billing information (ASBN). |
VALIDATION_FLAG | VALIDATION_FLAG | Required. Marked after open interface validation. |
Field Name | Maps to Column | Description |
TRANSACTION_TYPE | TRANSACTION_TYPE | Required. Accepts values as SHIP for ASN and RECEIVE for standard receipt. |
TRANSACTION_DATE | TRANSACTION_DATE | Required. Date must be in an open Purchasing and Inventory period. |
ITEM_CATEGORY | ITEM_CATEGORY | |
QUANTITY | QUANTITY | Required. Number of items. |
UNIT_OF_MEASURE | UNIT_OF_MEASURE | Required. Transaction unit of measure. |
UOM_CODE | ||
INTERFACE_SOURCE_ CODE | INTERFACE_SOURCE_ CODE | Identifies the source of the transaction. |
ITEM_NUMBER | ITEM_NUM | Item number. |
ITEM_DESCRIPTION | ITEM_DESCRIPTION | Required. |
ITEM_REVISION | ITEM_REVISION | |
EMPLOYEE_NAME | EMPLOYEE_ID | |
AUTO_TRANSACT_ CODE | AUTO_TRANSACT_ CODE | Required. Use: RECEIPT for a standard receipt DELIVER for a receipt and deliver transaction type. |
SHIP_TO_LOCATION_ ADDRESS_LINE1 | SHIP_TO_ LOCATION_ID | Address of the Vendor Site. Derives the Vendor Site ID in the Interface table. See the transformer commonOA1227. utils:getVendorSiteId. |
SHIP_TO_LOCATION_ ADDRESS_LINE2 | ||
SHIP_TO_LOCATION_ ADDRESS_LINE3 | ||
SHIP_TO_LOCATION_ TOWN_OR_CITY | ||
SHIP_TO_LOCATION_ COUNTY | ||
SHIP_TO_LOCATION_ STATE | ||
SHIP_TO_LOCATION_ POSTAL_CODE | ||
SHIP_TO_LOCATION_ COUNTRY | ||
TO_ORGANIZATION_ NAME | TO_ORGANIZATION_ ID | Derives the To Organization ID. See the transformer commonOA1227. utils:getOrg Id. |
DOCUMENT_NUM | DOCUMENT_NUM | Required. PO number. |
PO_REVISION_NUM | PO_REVISION_NUM | Purchase order revision number. |
RELEASE_NUM | RELEASE_NUM | PO release number. |
DOCUMENT_LINE_ NUM | DOCUMENT_LINE_ NUM | Purchase order line number. |
DOCUMENT_ SHIPMENT_LINE_ NUM | DOCUMENT_ SHIPMENT_LINE_ NUM | Shipment line number. |
PO_UNIT_PRICE | PO_UNIT_PRICE | Unit price at time of receipt. |
CURRENCY_CODE | CURRENCY_CODE | |
CURRENCY_ CONVERSION_TYPE | CURRENCY_ CONVERSION_TYPE | |
CURRENCY_ CONVERSION_RATE | CURRENCY_ CONVERSION_RATE | |
CONVERSION_ RATE_DATE | CURRENCY_ CONVERSION_DATE | EDI transaction 857 exchange rate date. |
DOCUMENT_ DISTRIBUTION_NUM | DOCUMENT_ DISTRIBUTION_NUM | Distribution number. |
DESTINATION_ TYPE_CODE | DESTINATION_ TYPE_CODE | Required if the AUTO_TRANSACT_CODE is DELIVER. |
SUBINVENTORY | SUBINVENTORY | |
FREIGHT_CARRIER_ CODE | FREIGHT_CARRIER_ CODE | |
BILL_OF_LADING | BILL_OF_LADING | |
PACKING_SLIP | PACKING_SLIP | |
EXPECTED_RECEIPT_ DATE | EXPECTED_RECEIPT_ DATE | Required if not provided as part of the header information. Expected arrival date. |
WAYBILL_AIRBILL_ NUM | WAYBILL_AIRBILL_ NUM | Waybill or airbill number. |
VENDOR_ITEM_ NUM | VENDOR_ITEM_NUM | Item number for the vendor. |
RMA_REFERENCE | RMA_REFERENCE | Returned material authorization reference. |
COMMENTS | COMMENTS | |
REASON_NAME | REASON_ID | Transaction reason. See the transformer commonOA1227. utils:getReasonId. |
TAX_NAME | TAX_NAME | |
TAX_AMOUNT | TAX_AMOUNT | |
NOTICE_UNIT_ PRICE | NOTICE_UNIT_PRICE | EDI transaction 857 unit price. |
VENDOR_CUM_ SHIPPED_QUANTITY | VENDOR_CUM_ SHIPPED_QUANTITY | Supplier’s CUM quantity shipped specified on the Advance Shipment Notice (ASN). |
TRUCK_NUM | TRUCK_NUM | Truck number. |
CONTAINER_NUM | CONTAINER_NUM | Container number. |
LOCATION_ ADDRESS_LINE1 | LOCATION_ID | Derives the Location ID based on the Ship To location address. See the transformer commonOA1227. utils:getLocationId. |
LOCATION_ ADDRESS_LINE2 | ||
LOCATION_ ADDRESS_LINE3 | ||
LOCATION_ TOWN_OR_CITY | ||
LOCATION_COUNTY | ||
LOCATION_STATE | ||
LOCATION_POSTAL_CODE | ||
LOCATION_COUNTRY | ||
DELIVER_TO_ PERSON_NAME | DELIVER_TO_ PERSON_NAME | |
DELIVER_TO_ LOCATION_ADDRESS_LINE1 | DELIVER_TO_ LOCATION_ID | Derives the Deliver To location ID based on the location address. See the transformer commonOA1227. utils:getLocationId. |
DELIVER_TO_ LOCATION_ADDRESS_LINE2 | ||
DELIVER_TO_ LOCATION_ADDRESS_LINE3 | ||
DELIVER_TO_ LOCATION_TOWN_OR_CITY | ||
DELIVER_TO_ LOCATION_COUNTY | ||
DELIVER_TO_ LOCATION_STATE | ||
DELIVER_TO_ LOCATION_POSTAL_CODE | ||
DELIVER_TO_ LOCATION_COUNTRY | ||
LOCATOR | LOCATOR | Locator name within the subinventory. |
VALIDATION_FLAG | VALIDATION_FLAG | Required. |
SUBSTITUTE_ ITEM_NUM | SUBSTITUTE_ ITEM_NUM | Substitute item number. |
BARCODE_LABEL | BARCODE_LABEL | Label on the barcode. |
COUNTRY_OF_ ORIGIN_CODE | COUNTRY_OF_ ORIGIN_CODE |