Receive Purchase Order Service

Field Name	Maps to Column	Description
WEB_TRANSACTION_ ID		Not used for Receive Purchase Order Service (PO Inbound Transaction).
DOCUMENT_TYPE		Required. Not used for Receive Purchase Order Service (PO Inbound Transaction).
DOCUMENT_STATUS	ACTION	Required.
ORG_ID
ORGANIZATION_ NAME	ORG_ID	Organization name for which the PO is generated.
CREATION_DATE
COMMENTS	COMMENTS	Comments on the PO.
ACCEPTANCE_ REQUIRED_FLAG	ACCEPTANCE_ REQUIRED_FLAG	Indicates whether acceptance from the supplier is required.
ACCEPTANCE_ DUE_DATE	ACCEPTANCE_ DUE_DATE	Date by which the supplier should accept the PO.
USER_HOLD_FLAG
CANCEL_FLAG
FIRM_STATUS_ LOOKUP_CODE	FIRM_FLAG	Indicates whether the PO should be prevented from being automatically rescheduled by the manufacturing application.
FROZEN_FLAG	FROZEN_FLAG	Indicates whether the PO is frozen.
AMOUNT_LIMIT	AMOUNT_LIMIT	Maximum amount that can be released against the PO.
MIN_RELEASE_ AMOUNT	MIN_RELEASE_ AMOUNT	Minimum amount that can be released against a PO.
QUOTATION_ CLASS_CODE		Class of quotation.
APPROVAL_ REQUIRED_FLAG	APPROVAL_ REQUIRED_FLAG	Indicates whether a PO requires approval.
CLOSED_CODE	CLOSED_CODE	Indicates whether a PO has a closed status.
SHIP_VIA_ LOOKUP_CODE	FREIGHT_CARRIER	Type of carrier for the RFQ or quotation shipment.
FREIGHT_TERMS_ LOOKUP_CODE	FREIGHT_TERMS	Type of freight terms for the PO.
RATE_TYPE	RATE_TYPE	Rate type for the PO.
RATE	RATE	Rate applicable for the PO.
FROM_TYPE_ LOOKUP_CODE	FROM_TYPE_ LOOKUP_CODE	Document type used to auto create.
END_DATE	EXPIRATION_DATE	Conditionally required. Expiration date of the document. This is required when replacing an existing purchasing document.
AUTHORIZATION_ STATUS	APPROVAL_STATUS	Approval status of the PO.
REVISED_DATE	REVISED_DATE	Date when the PO has been revised.
NOTE_TO_ AUTHORIZER
NOTE_TO_VENDOR	NOTE_TO_VENDOR
PRINT_COUNT	PRINTCOUNT
VENDOR_ORDER_NUM
REPLY_DATE	REPLY_DATE	Date when the supplier replied to the PO.
DOCUMENT_NUM	DOCUMENT_NUM	PO number.
END_DATE_ACTIVE
SHIP_TO_ ADDRESS_LINE_1	SHIP_TO_ LOCATION_ID	Address where the shipment for the PO must be done. Used for deriving the SHIP_TO_LOCATION_ID.
SHIP_TO_ ADDRESS_LINE_2
SHIP_TO_ ADDRESS_LINE_3
SHIP_TO_ TOWN_OR_CITY
SHIP_TO_ COUNTRY
SHIP_TO_ POSTAL_CODE
SHIP_TO_ REGION_1
SHIP_TO_ REGION_2
SHIP_TO_ REGION_3
BILL_TO_ ADDRESS_LINE_1	BILL_TO_ LOCATION_ID	Address of where to the bill the PO. Used for deriving the BILL_TO_LOCATION_ID.
BILL_TO_ ADDRESS_LINE_2
BILL_TO_ ADDRESS_LINE_3
BILL_TO_ TOWN_OR_CITY
BILL_TO_ COUNTRY
BILL_TO_ POSTAL_CODE
BILL_TO_ REGION_1
BILL_TO_ REGION_2
FOB_LOOKUP_ CODE	FOB	Type of free on board terms for the shipment.
STATUS_LOOKUP_ CODE
CURRENCY_CODE	CURRENCY_CODE
RATE_DATE	RATE_DATE
FROM_HEADER_ID
START_DATE	EFFECTIVE_DATE	Required. Effective date of the price break.
BLANKET_TOTAL_ AMOUNT	AMOUNT_AGREED	Amount agreed for the PO.
REVISION_NUM	REVISION_NUM	PO revision number.
APPROVED_FLAG
APPROVED_DATE	APPROVED_DATE	Date for approval.
NOTE_TO_ RECEIVER	NOTE_TO_ RECEIVER
PRINTED_DATE	PRINTED_DATE	Date when PO is printed.
CONFIRMING_ ORDER_FLAG	CONFIRMING_ORDER_ FLAG	Indicates whether the PO is a confirmed order.
REPLY_METHOD_ LOOKUP_CODE	REPLY_METHOD	Method the supplier should reply to the PO.
PO_HEADER_ID
TYPE_LOOKUP_ CODE	DOCUMENT_TYPE_ CODE	Required. Valid values are STANDARD, BLANKET, and QUOTATION. Maps directly.
SUMMARY_FLAG
ENABLED_FLAG
START_DATE_ ACTIVE
GOVERNMENT_ CONTEXT
USSGL_ TRANSACTION_ CODE	USSGL_TRANSACTION_ CODE	US standard general ledger transaction code.
CLOSED_DATE	CLOSED_DATE	Date when the PO is closed.
FIRM_DATE
RFQ_CLOSE_DATE	RFQ_CLOSE_DATE	Date when the request for quotation closes.
QUOTE_TYPE_ LOOKUP_CODE
QUOTE_WARNING_ DELAY_UNIT
QUOTE_WARNING_ DELAY	QUOTE_WARNING_ DELAY	Number of days before the expiration of the quotation.
QUOTE_VENDOR_ QUOTE_NUMBER	VENDOR_DOC_NUM	Required. Supplier document number.
AGENT_NAME	AGENT_NAME	Buyer’s name.
DOC_TYPE_NAME
DOC_TYPE_CODE
DOC_SUBTYPE	DOCUMENT_SUBTYPE	PO document subtype. This must be “CATALOG” if TYPE_LOOKUP_CODE is “QUOTATION”. For other cases, it should be blank.
CAN_PREPARER_ APPROVE_FLAG
SECURITY_LEVEL_ CODE
VENDOR_NAME	VENDOR_NAME	Required. Supplier’s name.
TYPE_1099
VAT_CODE
ADDRESS_LINE1	VENDOR_SITE_ID	Required. Address of the supplier.
ADDRESS_LINE2
ADDRESS_LINE3
CITY
STATE
ZIP
COUNTRY
PHONE
FAX
VENDOR_CONTACT	VENDOR_CONTACT	Supplier contact name.
PAYMENT_TERMS	PAYMENT_TERMS
DISP_RATE_TYPE
PCARD_NUM	PCARD_ID	Credit card number.
PAY_ON_CODE	PAY_ON_CODE	Indicates whether the PO will be paid upon receipt.
RELEASE_NUM	RELEASE_NUM	PO release number.
FROM_PO_NUM
INTERFACE_ SOURCE_CODE	INTERFACE_ SOURCE_CODE	Indicates the source from where the PO has to be imported.

Field Name	Maps to Column	Description
LINE_NUM	LINE_NUM	Conditionally required. PO line number. It is required for standard purchase orders only.
LINE_TYPE	LINE_TYPE	PO line type.
ITEM_REVISION	ITEM_REVISION	PO item revision.
ITEM_DESCRIPTION	ITEM_DESCRIPTION	Item description. Either ITEM_DESCRIPTION or ITEM is required.
UNIT_MEAS_ LOOKUP_CODE	UNIT_OF_MEASURE	Unit of measure for the items.
QUANTITY_COMMITTED
COMMITTED_AMOUNT	COMMITTED_AMOUNT	Amount for the items agreed by the supplier.
ALLOW_PRICE_ OVERRIDE_FLAG	ALLOW_PRICE_ OVERRIDE_FLAG	Indicates whether the price can be changed for a PO release.
NOT_TO_EXCEED_ PRICE	NOT_TO_EXCEED_ PRICE	Price limit that cannot be exceeded for a PO release.
LIST_PRICE_PER_UNIT	LIST_PRICE_PER_UNIT	Price list’s price of each item.
UNIT_PRICE	UNIT_PRICE	Price per unit.
QUANTITY	QUANTITY	Quantity of each item ordered.
VENDOR_PRODUCT_ NUM	VENDOR_PRODUCT_ NUM	Supplier’s item number ordered.
UN_NUMBER	UN_NUMBER	UN number.
HAZARD_CLASS	HAZARD_CLASS	Class of the hazard item.
MIN_ORDER_ QUANTITY	MIN_ORDER_ QUANTITY	Minimum order quantity for the PO.
MAX_ORDER_ QUANTITY	MAX_ORDER_ QUANTITY	Maximum order quantity for the PO.
QTY_RCV_ TOLERANCE	QTY_RCV_ TOLERANCE	Maximum over-receipt tolerance percentage for the quantity of the items received.
OVER_TOLERANCE_ ERROR_FLAG	OVER_TOLERANCE_ ERROR_FLAG	Percentage tolerance within which a shipment is automatically closed for invoicing when billed.
MARKET_PRICE	MARKET_PRICE	Market price for the item ordered in the PO.
UNORDERED_FLAG
CLOSED_FLAG
USER_HOLD_FLAG
CANCEL_FLAG
FIRM_STATUS_ LOOKUP_CODE	FIRM_FLAG	Indicates whether the PO should be prevented from being automatically rescheduled by the manufacturing application.
FIRM_DATE
CONTRACT_NUM
NOTE_TO_VENDOR	NOTE_TO_VENDOR	Note to the supplier.
FROM_HEADER_ID
FROM_LINE_ID
TAXABLE_FLAG	TAXABLE_FLAG	Indicates whether the item is taxable.
TAX_NAME	TAX_NAME	Name of the tax applied to the item.
TYPE_1099	TYPE_1099	1099 type for the purchase order item.
CAPITAL_EXPENSE_ FLAG	CAPITAL_EXPENSE_ FLAG	Indicates whether the item cost is a capital expense.
NEGOTIATED_BY_ PREPARER_FLAG	NEGOTIATED_BY_ PREPARER_FLAG	Indicates whether the buyer negotiated the price.
MIN_RELEASE_ AMOUNT	MIN_RELEASE_ AMOUNT	Minimum release amount.
PRICE_TYPE_ LOOKUP_CODE	PRICE_TYPE	Default price type for a PO.
PRICE_BREAK_ LOOKUP_CODE	PRICE_BREAK_ LOOKUP_CODE	Default price break type for catalog for PO.
ALLOW_ITEM_ DESC_UPDATE_ FLAG
ORDER_TYPE_ LOOKUP_CODE
OUTSIDE_OPERATION_ FLAG
TRANSACTION_REASON_ CODE	TRANSACTION_REASON_ CODE	Nature of the transaction.
USSGL_TRANSACTION_ CODE	USSGL_TRANSACTION_ CODE	US standard general ledger transaction code.
ITEM	ITEM	Either ITEM or ITEM_DESCRIPTION is required.
UOM_CODE	UOM_CODE	Unit of measurement.
PO_LINE_ID
PO_HEADER_ID
CATEGORY	CATEGORY	Category of the item in the PO.
FROM_HEADER_ NUM	FROM_PO_NUM	Unique PO header number that automatically creates the PO.
LINE_REFERENCE_ NUM	LINE_REFERENCE_ NUM	Unique PO line number that automatically creates the PO.
UNIT_WEIGHT	UNIT_WEIGHT	Units for weight.
WEIGHT_UOM_CODE	WEIGHT_UOM_CODE	Weight measurement unit.
VOLUME_UOM_CODE	VOLUME_UOM_CODE	Volume measurement unit.
UNIT_VOLUME	UNIT_VOLUME	Units for volume.
PRICE_UPDATE_ TOLERANCE	PRICE_UPDATE_ TOLERANCE	Maximum percentage increase allowed to price, without buyer approval in price or sale catalog update sends by supplier.
TEMPLATE_NAME	TEMPLATE_NAME	Template of the item used for PO.
SOURCING_RULE_ NAME	SOURCING_RULE_ NAME	Name of the sourcing rule created by purchasing documents open interface.
ACTION	ACTION	Action to be completed on the PO line. Use: NEW for a new PO. ADDED for a new PO line to add to an existing PO header.

Field Name	Maps to Column	Description
SHIPMENT_NUM	SHIPMENT_NUM	Conditionally required. PO shipment number. It is required for standard purchase orders only.
SHIPMENT_TYPE	SHIPMENT_TYPE
SHIP_TO_ ORGANIZATION_CODE	SHIP_TO_ ORGANIZATION_ID	Where the item in PO will be shipped. Either the code or the name can be mapped to the ID.
SHIP_TO_ ORGANIZATION_NAME	SHIP_TO_ ORGANIZATION_ID
SHIP_TO_ LOCATION	SHIP_TO_ LOCATION	Alternative to supplying the SHIP_TO_LOCATION_item details below.
SHIP_TO_ LOC_ADDRESS_LINE_1	SHIP_TO_ LOCATION_ID	Address of the location where the item in the PO will be shipped.
SHIP_TO_ LOC_ADDRESS_LINE_2
SHIP_TO_ LOC_ADDRESS_LINE_3
SHIP_TO_ LOC_TOWN_OR_CITY
SHIP_TO_ LOCATION_COUNTRY
SHIP_TO_ LOCATION_POSTAL_CODE
SHIP_TO_ LOCATION_REGION_1
SHIP_TO_ LOCATION_REGION_2
SHIP_TO_ LOCATION_REGION_3
QUANTITY	QUANTITY
NEED_BY_DATE	NEED_BY_DATE	Date by which the item in the PO must be shipped.
PROMISED_DATE	PROMISED_DATE	Date promised by the supplier by which the item would be delivered.
PRICE_DISCOUNT	PRICE_DISCOUNT	Discount percentage for price break.
EFFECTIVE_START_ DATE	EFFECTIVE_DATE	Effective date for the price break.
EXPIRATION_END_ DATE	EXPIRATION_DATE	Expiration date for the price break.
LEAD_TIME	LEAD_TIME	Lead time for the price break.
LEAD_TIME_UNIT	LEAD_TIME_UNIT	Unit of measure for the lead time.
FREIGHT_TERMS_ LOOKUP_CODE	FREIGHT_TERMS	Type of freight terms for the RFQ or quotation shipment.
FOB_LOOKUP_CODE	FOB	Type of free-on-board terms for the shipment.
SHIP_VIA_ LOOKUP_CODE	FREIGHT_CARRIER
INSPECTION_REQUIRED_ FLAG	INSPECTION_REQUIRED_ FLAG	Whether the shipment should be inspected before the invoice should be paid.
RECEIPT_REQUIRED_ FLAG	RECEIPT_REQUIRED_ FLAG	Whether the shipment must be received before the invoice is paid.
RECEIVE_CLOSE_ TOLERANCE	RECEIVE_CLOSE_ TOLERANCE	Percentage tolerance within which a shipment is automatically closed for receiving.
INVOICE_CLOSE_ TOLERANCE	INVOICE_CLOSE_ TOLERANCE	Percentage tolerance within which a shipment is automatically closed for invoicing before billing.
QTY_RCV_ EXCEPTION_CODE	QTY_RCV_ EXCEPTION_CODE	Describes what action is taken when the quantity-received tolerance is exceeded.
DAYS_EARLY_ RECEIPT_ALLOWED	DAYS_EARLY_ RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early.
DAYS_LATE_ RECEIPT_ALLOWED	DAYS_LATE_ RECEIPT_ALLOWED	Minimum acceptable number of days items can be received late.
ENFORCE_SHIP_TO_ LOCATION_CODE	ENFORCE_SHIP_TO_ LOCATION_CODE	Describes what action is taken when the receiving location differs from the ship to location.
RECEIPT_DAYS_ EXCEPTION_CODE	RECEIPT_DAYS_ EXCEPTION_CODE	Describes what action is taken when items are received earlier or later than the allowed number of days.
ACCRUE_ON_ RECEIPT_FLAG	ACCRUE_ON_ RECEIPT_FLAG	Indicates whether items are accrued upon receipt.
ALLOW_SUBSTITUTE_ RECEIPTS_FLAG	ALLOW_SUBSTITUTE_ RECEIPTS_FLAG	Indicates whether substitute items can be received in place of ordered items.
TAX_USER_ OVERRIDE_FLAG	TAX_USER_ OVERRIDE_FLAG	Indicates whether the default tax was overridden.
ROUTING_NAME	RECEIVING_ROUTING

Field Name	Maps to Column	Description
PO_DISTRIBUTION_ ID
REQ_DISTRIBUTION_ ID
ON_LINE_REQ
RATE_DATE	RATE_DATE	Currency conversion date.
AMOUNT_BILLED	AMOUNT_BILLED	Amount invoiced against distribution.
ENCUMBERED_ AMOUNT	ENCUMBERED_AMOUNT	Distribution encumbered amount.
FAILED_FUNDS_ LOOKUP_CODE
GL_ENCUMBERED_ PERIOD_NAME	GL_ENCUMBERED_ PERIOD_NAME	Period in which the distribution was encumbered.
DESTINATION_ ORGANIZATION_ID
WIP_ENTITY_ID
WIP_RESOURCE_ SEQ_NUM	WIP_RESOURCE_ SEQ_NUM	Work In Process resource sequence number.
BOM_RESOURCE_ID
VARIANCE_ACCOUNT_ ID
DESTINATION_CONTEXT	DESTINATION_CONTEXT	Destination details description.
PROGRAM_APPLICATION_ ID
GOVERNMENT_CONTEXT	GOVERNMENT_CONTEXT
USSGL_TRANSACTION_ CODE	USSGL_TRANSACTION_ CODE	US standard general ledger transaction code.
WIP_LINE_ID
PROJECT_ID
TASK_ID
EXPENDITURE_TYPE	EXPENDITURE_TYPE	Project accounting expenditure type.
PROJECT_ACCOUNTING_ CONTEXT	PROJECT_ACCOUNTING_ CONTEXT	Project accounting context.
EXPENDITURE_ ORGANIZATION_ID
GL_CLOSED_DATE	GL_CLOSED_DATE	Date when the distribution was closed.
ACCRUE_ON_ RECEIPT_FLAG	ACCRUE_ON_ RECEIPT_FLAG	Indicates whether the items are accrued on receipt.
EXPENDITURE_ ITEM_DATE	EXPENDITURE_ ITEM_DATE	Project accounting expenditure item date.
LAST_UPDATED_BY
LINE_LOCATION_ID
QUANTITY_ORDERED	QUANTITY_ORDERED	Required. Quantity ordered on the distribution.
CREATION_DATE
QUANTITY_DELIVERED	QUANTITY_DELIVERED	Quantity delivered against the distribution.
QUANTITY_CANCELLED	QUANTITY_CANCELLED	Quantity cancelled for the distribution.
LAST_UPDATE_ DATE
PO_HEADER_ID
PO_LINE_ID
SET_OF_BOOKS_ID
CODE_COMBINATION_ ID	CHARGE_ACCOUNT_ID
LAST_UPDATE_ LOGIN
CREATED_BY
PO_RELEASE_ID
QUANTITY_BILLED	QUANTITY_BILLED	Quantity invoiced against the distribution.
REQ_HEADER_ REFERENCE_NUM	REQ_HEADER_ REFERENCE_NUM	Requisition number of the requisition line placed on the distribution.
REQ_LINE_ REFERENCE_NUM	REQ_LINE_ REFERENCE_NUM	Paper requisition line number.
DELIVER_TO_ LOCATION_ID
DELIVER_TO_ PERSON_ID
RATE	RATE	Currency conversion rate.
ACCRUED_FLAG	ACCRUED_FLAG	Indicates whether distribution was accrued.
ENCUMBERED_FLAG	ENCUMBERED_FLAG	Distribution encumbered amount.
UNENCUMBERED_ QUANTITY	UNENCUMBERED_ QUANTITY	Quantity unencumbered on the distribution.
UNENCUMBERED_ AMOUNT	UNENCUMBERED_ AMOUNT	Amount unencumbered on the distribution.
GL_ENCUMBERED_ DATE	GL_ENCUMBERED_ DATE	Date the distribution was encumbered.
GL_CANCELLED_ DATE	GL_CANCELLED_ DATE	Date the distribution was cancelled.
DESTINATION_ TYPE_CODE	DESTINATION_TYPE_ CODE	Final destination name of the purchase item.
DESTINATION_ SUBINVENTORY	DESTINATION_ SUBINVENTORY	Final destination sub inventory for inventory purchases.
WIP_OPERATION_ SEQ_NUM	WIP_OPERATION_ SEQ_NUM	WIP operations sequence number with routing.
WIP_REPETITIVE_ SCHEDULE_ID
BUDGET_ACCOUNT_ID
ACCRUAL_ACCOUNT_ID
SOURCE_ DISTRIBUTION_NUM
SOURCE_ DISTRIBUTION_ID
DISTRIBUTION_NUM	DISTRIBUTION_NUM	Required. Document distribution number.
REQUEST_ID
PROGRAM_ID
PROGRAM_ UPDATE_DATE
PREVENT_ ENCUMBRANCE_FLAG	PREVENT_ ENCUMBRANCE_FLAG	Indicates whether distribution should be encumbered.
REQUISITION_LINE_ ID
REQUISITION_HEADER_ ID
LINE_NUM
SEGMENT1
END_ITEM_ UNIT_NUMBER
RECOVERABLE_TAX	RECOVERABLE_TAX	Recoverable tax amount.
NONRECOVERABLE_ TAX	NONRECOVERABLE_ TAX	Non-recoverable tax amount.
RECOVERY_RATE	RECOVERY_RATE	Percentage of tax that can be recovered.
TAX_RECOVERY_ OVERRIDE_FLAG	TAX_RECOVERY_ OVERRIDE_FLAG	Indicator if tax-recovery should be used or not.
AWARD_ID
OKE_CONTRACT_ LINE_ID
OKE_CONTRACT_ DELIVERABLE_ID
ORG_ID
DELIVERY_TO_ LOCATION	DELIVERY_TO_ LOCATION	Location to which the delivery must be made.
DELIVERY_TO_ PERSON_FULL_NAME	DELIVERY_TO_ PERSON_FULL_NAME	Person who receives the delivery.
DESTINATION_TYPE
DESTINATION_ ORGANIZATION	DESTINATION_ ORGANIZATION	Organization that receives the deliver.
SET_OF_BOOKS	SET_OF_BOOKS	Set of GL books.
CHARGE_ACCOUNT	CHARGE_ACCOUNT	Required.
BUDGET_ACCOUNT	BUDGET_ACCOUNT
ACCURAL_ACCOUNT	ACCURAL_ACCOUNT
VARIANCE_ACCOUNT	VARIANCE_ACCOUNT
FAILED_FUNDS_ LOOKUP_CODE
WIP_ENTITY	WIP_ENTITY	WIP job.
WIP_REPETITIVE_ SCHEDULE	WIP_REPETITIVE_ SCHEDULE
WIP_LINE_CODE	WIP_LINE_CODE
BOM_RESOURCE	BOM_RESOURCE_ CODE	Bill of material resource.
PROJECT_NAME	PROJECT	Project name.
TASK_NAME	TASK	Task name.
EXPENDITURE	EXPENDITURE	Project accounting expenditure.
EXPENDITURE_ORG_ NAME	EXPENDITURE_ ORGANIZATION	Project accounting expenditure organization name.
PROJECT_RELATED_ FLAG	PROJECT_RELATED_ FLAG	Project accounting project related.
AWARD_FULL_NAME	AWARD_ID	Award name.

Script	Description
wm_install_into_ po.sql	Runs the scripts listed below, except the uninstall script.
wm_into_po_pkg.sql	Installs WM_OPENPO_IMP_HANDLER_PKG.WM_HANDLE_REQ, which calls the WM_CONC_REQUEST.WM_REQUEST_SUBMIT to submit the PO Open Document interface concurrent program.
wm_into_po_seq.sql	Creates the WM_PO_BATCH_S component, which creates the unique BATCH_ID sequence.
wm_drop_into_po.sql	Uninstalls all components created by wm_install_into_po.sql.