Send Purchase Order Service

Field Name	Oracle Applications Table/View Name	Column Name	Description
WEB_TRANSACTION_ ID
DOCUMENT_TYPE			Use PO.
DOCUMENT_STATUS			Use INSERT or UPDATE.
ORGANIZATION_ NAME	HR_ ORGANIZATION_ UNITS	NAME	Organization name for which the PO is generated.
DOC_SUBTYPE	PO_ DOCUMENT_ TYPES_ALL	DOCUMENT_ SUBTYPE	PO document subtype.
DOCUMENT_NUM	PO_HEADERS_ALL	SEGMENT1	PO number.
REVISION_NUM	PO_HEADERS_ALL	REVISION_NUM	PO revision number.
CREATION_DATE	PO_HEADERS_ALL	CREATION_DATE	Date PO was created.
VENDOR_NAME	AP_SUPPLIERS	VENDOR_NAME	Supplier’s name.
STATUS	PO_HEADERS_ALL	AUTHORIZATION_ STATUS	PO status.
AUTHORIZATION_ STATUS	PO_HEADERS_ALL	AUTHORIZATION_ STATUS	Approval status of the PO.
COMMENTS	PO_HEADERS_ALL	COMMENTS	Comments for the PO.
ACCEPTANCE_ REQUIRED_FLAG	PO_HEADERS_ALL	ACCEPTANCE_ REQUIRED_FLAG	Indicates whether acceptance from the supplier is required.
ACCEPTANCE_ DUE_DATE	PO_HEADERS_ALL	ACCEPTANCE_ DUE_DATE	Last date when the supplier should accept the PO.
FIRM_STATUS_ LOOKUP_CODE	PO_HEADERS_ALL	FIRM_STATUS_ LOOKUP_CODE	Indicates whether the PO should be prevented from being automatically rescheduled by the manufacturing application.
FROZEN_FLAG	PO_HEADERS_ALL	FROZEN_FLAG	Indicates whether the PO is frozen.
AMOUNT_LIMIT	PO_HEADERS_ALL	AMOUNT_LIMIT	Maximum amount that can be released against the PO.
MIN_RELEASE_ AMOUNT	PO_HEADERS_ALL	MIN_RELEASE_ AMOUNT	Minimum amount that can be released against the PO.
APPROVAL_ REQUIRED_ FLAG	PO_HEADERS_ALL	APPROVAL_ REQUIRED_ FLAG	Indicates whether a PO requires approval.
CLOSED_CODE	PO_HEADERS_ALL	CLOSED_CODE	Indicates whether a PO has a closed status.
SHIP_VIA_ LOOKUP_CODE	PO_HEADERS_ALL	SHIP_VIA_ LOOKUP_CODE	Freight carrier.
FREIGHT_TERMS_ LOOKUP_CODE	PO_HEADERS_ALL	FREIGHT_TERMS_ LOOKUP_CODE	Type of freight terms for the PO.
RATE_TYPE	PO_HEADERS_ALL	RATE_TYPE	Rate type for the PO.
RATE	PO_HEADERS_ALL	RATE	Rate for the PO.
FROM_TYPE_ LOOKUP_CODE	PO_HEADERS_ALL	FROM_TYPE_ LOOKUP_CODE	PO used to auto create.
END_DATE	PO_HEADERS_ALL	END_DATE	Expiration date of the document.
REVISED_DATE	PO_HEADERS_ALL	REVISED_DATE	Date when the PO has been revised.
NOTE_TO_ VENDOR	PO_HEADERS_ALL	NOTE_TO_VENDOR	Note sent to the vendor.
PRINT_COUNT	PO_HEADERS_ALL	PRINT_COUNT
REPLY_DATE	PO_HEADERS_ALL	REPLY_DATE	Date when the supplier replied to the PO.
SHIP_TO_ ADDRESS_LINE_1	HR_LOCATIONS	ADDRESS_LINE_1	Address that will receive the PO items. Derives the SHIP_TO_LOCATION_ID.
SHIP_TO_ ADDRESS_LINE_2	HR_LOCATIONS	ADDRESS_LINE_2
SHIP_TO_ ADDRESS_LINE_3	HR_LOCATIONS	ADDRESS_LINE_3
SHIP_TO_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
SHIP_TO_ COUNTRY	HR_LOCATIONS	COUNTRY
SHIP_TO_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
SHIP_TO_ REGION_1	HR_LOCATIONS	REGION_1
SHIP_TO_ REGION_2	HR_LOCATIONS	REGION_2
SHIP_TO_ REGION_3	HR_LOCATIONS	REGION_3
BILL_TO_ ADDRESS_LINE_1	HR_LOCATIONS	ADDRESS_LINE_1	Address that will receive the bill for the PO items. Derives the BILL_TO_LOCATION_ID.
BILL_TO_ ADDRESS_LINE_2	HR_LOCATIONS	ADDRESS_LINE_2
BILL_TO_ ADDRESS_LINE_3	HR_LOCATIONS	ADDRESS_LINE_3
BILL_TO_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
BILL_TO_ COUNTRY	HR_LOCATIONS	COUNTRY
BILL_TO_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
BILL_TO_ REGION_1	HR_LOCATIONS	REGION_1
BILL_TO_ REGION_2	HR_LOCATIONS	REGION_2
BILL_TO_ REGION_3	HR_LOCATIONS	REGION_3
FOB_LOOKUP_ CODE	PO_HEADERS_ALL	FOB_LOOKUP_ CODE	Type of free on board terms for the shipment.
CURRENCY_CODE	PO_HEADERS_ALL	CURRENCY_CODE
RATE_DATE	PO_HEADERS_ALL	RATE_DATE
START_DATE	PO_HEADERS_ALL	START_DATE	Effective date of the price break.
BLANKET_ TOTAL_AMOUNT	PO_HEADERS_ALL	BLANKET_ TOTAL_AMOUNT	Agreed amount for the PO.
APPROVED_DATE	PO_HEADERS_ALL	APPROVED_DATE
NOTE_TO_ RECEIVER	PO_HEADERS_ALL	NOTE_TO_ RECEIVER
PRINTED_DATE	PO_HEADERS_ALL	PRINTED_DATE	Date when the PO is printed.
CONFIRMING_ ORDER_FLAG	PO_HEADERS_ALL	CONFIRMING_ ORDER_FLAG	Indicates whether the PO is a confirmed order.
REPLY_METHOD_ LOOKUP_CODE	PO_HEADERS_ALL	REPLY_METHOD_ LOOKUP_CODE	Method the supplier should reply to the PO.
TYPE_ LOOKUP_CODE	PO_HEADERS_ALL	TYPE_ LOOKUP_CODE	Required. Use STANDARD, BLANKET, or QUOTATION. Maps directly.
USSGL_ TRANSACTION_ CODE	PO_HEADERS_ALL	USSGL_ TRANSACTION_ CODE	USA standard general ledger transaction code.
CLOSED_DATE	PO_HEADERS_ALL	CLOSED_DATE	Date when the PO is closed.
RFQ_CLOSE_DATE	PO_HEADERS_ALL	RFQ_CLOSE_DATE	Date when the Request For Quotation (RFQ) closes.
QUOTE_WARNING_ DELAY	PO_HEADERS_ALL	QUOTE_WARNING_ DELAY	Number of days before the quotation expires.
QUOTE_VENDOR_ QUOTE_NUMBER	VENDOR_DOC_NUM	QUOTE_VENDOR_ QUOTE_NUMBER	Supplier document number.
AGENT_NAME	PER_ALL_PEOPLE_F	NAME	Buyer’s name.
ADDRESS_LINE1	AP_SUPPLIER_ SITES_ALL	ADDRESS_ LINE1	Supplier’s address line 1.
ADDRESS_LINE2	AP_SUPPLIER_ SITES_ALL	ADDRESS_ LINE2	Supplier’s address line 2.
ADDRESS_LINE3	AP_SUPPLIER_ SITES_ALL	ADDRESS_ LINE3	Supplier’s address line 3.
CITY	AP_SUPPLIER_ SITES_ALL	CITY
STATE	AP_SUPPLIER_ SITES_ALL	STATE
ZIP	AP_SUPPLIER_ SITES_ALL	ZIP
COUNTRY	AP_SUPPLIER_ SITES_ALL	COUNTRY
PHONE	AP_SUPPLIER_ SITES_ALL	PHONE
FAX	AP_SUPPLIER_ SITES_ALL	FAX
VENDOR_CONTACT	PO_VENDOR_ CONTACTS	PERSON_LAST_NAME, PERSON_FIRST_NAME	Supplier’s contact name.
PAYMENT_TERMS	AP_TERMS	NAME
PCARD_NUM	AP_CARDS_ALL	CARD_NUMBER	Credit card number.
PAY_ON_CODE	PO_HEADERS_ALL	PAY_ON_CODE	Indicates whether the PO will be paid on receipt.
RELEASE_NUM	PO_RELEASES_ALL	RELEASE_NUM	PO release number.
INTERFACE_ SOURCE_CODE	PO_HEADERS_ALL	INTERFACE_ SOURCE_CODE	Indicates the source where Oracle Applications gets the PO.
PO_HEADER_ID	PO_HEADERS_ALL	PO_HEADER_ID	Required for outbound transactions. Unique identifier for PO header.

Field Name	Oracle Applications Table/View Name	Column Name	Description
LINE_NUM	PO_LINES_ALL	LINE_NUM	PO line number.
LINE_TYPE	PO_LINE_TYPES	LINE_TYPE	PO line type.
ITEM_REVISION	PO_LINES_ALL	ITEM_ REVISION	PO item revision.
ITEM_DESCRIPTION	PO_LINES_ALL	ITEM_ DESCRIPTION
UNIT_MEAS_ LOOKUP_CODE	PO_LINES_ALL	UNIT_MEAS_ LOOKUP_CODE	Unit of measure for the items.
COMMITTED_ AMOUNT	PO_LINES_ALL	COMMITTED_AMOUNT	Supplier’s agreed amount for the items.
ALLOW_PRICE_ OVERRIDE_FLAG	PO_LINES_ALL	ALLOW_PRICE_ OVERRIDE_FLAG	Indicates whether the price can be changed for a PO release.
NOT_TO_ EXCEED_PRICE	PO_LINES_ALL	NOT_TO_ EXCEED_PRICE	Maximum price limit for a PO release.
LIST_PRICE_ PER_UNIT	PO_LINES_ALL	LIST_PRICE_ PER_UNIT
UNIT_PRICE	PO_LINES_ALL	UNIT_PRICE
QUANTITY	PO_LINES_ALL	QUANTITY	Quantity for each item ordered.
VENDOR_ PRODUCT_NUM	PO_LINES_ALL	VENDOR_ PRODUCT_NUM	Supplier’s item number.
UN_NUMBER	PO_UN_ NUMBERS	UN_NUMBER
HAZARD_CLASS	PO_HAZARD_CLASSES	HAZARD_CLASS
MIN_ORDER_ QUANTITY	PO_LINES_ALL	MIN_ORDER_ QUANTITY	Minimum order quantity for the PO.
MAX_ORDER_ QUANTITY	PO_LINES_ALL	MAX_ORDER_ QUANTITY	Maximum order quantity for the PO.
QTY_RCV_ TOLERANCE	PO_LINES_ALL	QTY_RCV_ TOLERANCE	Maximum over-receipt tolerance percentage for the quantity of the items received.
OVER_TOLERANCE_ ERROR_FLAG	PO_LINES_ALL	OVER_TOLERANCE_ ERROR_FLAG	A shipment is automatically closed for invoicing if this tolerance percentage is reached when billed.
MARKET_PRICE	PO_LINES_ALL	MARKET_PRICE	Market price for the item ordered in the PO.
FIRM_STATUS_ LOOKUP_CODE	PO_LINES_ALL	FIRM_STATUS_ LOOKUP_CODE	Indicates whether the PO should be prevented from being automatically rescheduled by the manufacturing application.
NOTE_TO_VENDOR	PO_LINES_ALL	NOTE_TO_VENDOR	Note to the supplier.
TAXABLE_FLAG	PO_LINES_ALL	TAXABLE_FLAG	Indicates whether the item is taxable.
TAX_NAME	AP_TAX_CODES_ALL	NAME	Name of the tax applied to the item.
TYPE_1099	PO_LINES_ALL	TYPE_1099	1099 type for the purchase order item.
CAPITAL_EXPENSE_ FLAG	PO_LINES_ALL	CAPITAL_EXPENSE_ FLAG	Indicates whether the item cost is a capital expense.
NEGOTIATED_BY_ PREPARER_FLAG	PO_LINES_ALL	NEGOTIATED_BY_ PREPARER_FLAG	Indicates whether the buyer negotiated the price.
MIN_RELEASE_ AMOUNT	PO_LINES_ALL	MIN_RELEASE_ AMOUNT	Minimum release amount.
PRICE_TYPE_ LOOKUP_CODE	PO_LINES_ALL	PRICE_TYPE_ LOOKUP_CODE	Default price type for a PO.
PRICE_BREAK_ LOOKUP_CODE	PO_LINES_ALL	PRICE_BREAK_ LOOKUP_CODE	Default price break type for catalog.
TRANSACTION_ REASON_CODE	PO_LINES_ALL	TRANSACTION_ REASON_CODE
USSGL_ TRANSACTION_ CODE	PO_LINES_ALL	USSGL_TRANSACTION_ CODE	USA standard general ledger transaction code.
ITEM	MTL_SYSTEM_ITEMS	SEGMENT1
UOM_CODE	MTL_UNITS_OF_ MEASURE	UOM_CODE	Unit of measurement.
CATEGORY	MTL_CATEGORIES_ B_KFV	CONCATENATED_ SEGMENTS	Category of the item in the PO.
FROM_HEADER_NUM	PO_HEADERS_ALL	SEGMENT1	Unique header number to automatically create the PO.
LINE_REFERENCE_NUM	PO_LINES_ALL	LINE_REFERENCE_NUM	Unique PO line number to automatically create the PO.
UNIT_WEIGHT	MTL_SYSTEM_ITEMS	UNIT_WEIGHT	Units for weight.
WEIGHT_UOM_CODE	MTL_SYSTEM_ITEMS	WEIGHT_UOM_CODE	Weight unit of measurement.
VOLUME_UOM_CODE	MTL_SYSTEM_ITEMS	VOLUME_UOM_CODE	Volume unit of measurement.
UNIT_VOLUME	MTL_SYSTEM_ITEMS	UNIT_VOLUME
PRICE_UPDATE_ TOLERANCE	PO_HEADERS_ALL	PRICE_UPDATE_ TOLERANCE	Maximum percentage increase without buyer approval for price or sale catalog update sent by supplier.
TEMPLATE_NAME			For inbound transactions.
SOURCING_RULE_ NAME	MRP_SOURCING_RULES	SOURCING_RULE_ NAME	Name of the sourcing rule created by purchasing documents.
ACTION			Action to be completed on the purchase order line for inbound transactions. Use: NEW for a new PO. ADDED to add a line to an existing PO.
PO_HEADER_ID	PO_HEADERS_ALL	PO_HEADER_ID	Required for outbound transactions. Unique identifier for PO headers.
PO_LINE_ID	PO_LINES_ALL	PO_LINE_ID	Required for outbound transactions. Unique identifier for PO lines.
CANCEL_FLAG	PO_LINES_ALL	CANCEL_FLAG	Indicates whether the PO was cancelled.
CANCEL_REASON	PO_LINES_ALL	CANCEL_REASON
CANCEL_DATE	PO_LINES_ALL	CANCEL_DATE
CLOSED_FLAG	PO_LINES_ALL	CLOSED_FLAG	Indicates whether the PO is closed.
CLOSED_REASON	PO_LINES_ALL	CLOSED_REASON
CLOSED_DATE	PO_LINES_ALL	CLOSED_DATE

Field Name	Oracle Applications Table/View Name	Column Name	Description
SHIPMENT_NUM	PO_LINE_LOCATIONS	SHIPMENT_NUM	PO shipment number.
SHIP_TO_ ORGANIZATION_ NAME	HR_LOCATIONS	DESCRIPTION	Organization that will receive PO items.
SHIP_TO_ LOCATION	HR_LOCATIONS	SHIP_TO_ LOCATION
SHIP_TO_LOC_ ADDRESS_LINE_1	HR_LOCATIONS	ADDRESS_LINE_1	Indicates where to ship the PO items.
SHIP_TO_LOC_ ADDRESS_LINE_2	HR_LOCATIONS	ADDRESS_LINE_2	Indicates where to ship the PO items.
SHIP_TO_LOC_ ADDRESS_LINE_3	HR_LOCATIONS	ADDRESS_LINE_3	Indicates where to ship the PO items.
SHIP_TO_LOC_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
SHIP_TO_ LOCATION_ COUNTRY	HR_LOCATIONS	COUNTRY
SHIP_TO_ LOCATION_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
SHIP_TO_ LOCATION_ REGION_1	HR_LOCATIONS	REGION_1
SHIP_TO_ LOCATION_ REGION_2	HR_LOCATIONS	REGION_2
SHIP_TO_ LOCATION_ REGION_3	HR_LOCATIONS	REGION_3
NEED_BY_DATE	PO_LINE_ LOCATIONS	NEED_BY_DATE	Due date when the PO item needs to be shipped.
PROMISED_DATE	PO_LINE_ LOCATIONS	PROMISED_DATE	Date promised by the supplier when the item would be delivered.
PRICE_DISCOUNT	PO_LINE_ LOCATIONS	PRICE_DISCOUNT	Discount percentage for price break.
EFFECTIVE_ START_DATE	PO_LINE_ LOCATIONS	START_DATE	Effective date for the price break.
EXPIRATION_ END_DATE	PO_LINE_ LOCATIONS	END_DATE	Expiration date for the price break.
LEAD_TIME	PO_LINE_ LOCATIONS	LEAD_TIME	Lead time for the price break.
LEAD_TIME_UNIT	PO_LINE_ LOCATIONS	LEAD_TIME_UNIT	Unit of measurement for the lead time.
INSPECTION_ REQUIRED_FLAG	PO_LINE_ LOCATIONS	INSPECTION_ REQUIRED_FLAG	Indicates whether the shipment should be inspected before the invoice should be paid.
RECEIPT_ REQUIRED_FLAG	PO_LINE_ LOCATIONS	RECEIPT_ REQUIRED_FLAG	Indicates whether the shipment must be received before the invoice is paid.
RECEIVE_ CLOSE_ TOLERANCE	PO_LINE_ LOCATIONS	RECEIVE_ CLOSE_ TOLERANCE	Percentage tolerance within which a shipment is automatically closed for receiving.
INVOICE_ CLOSE_ TOLERANCE	PO_LINE_ LOCATIONS	INVOICE_ CLOSE_ TOLERANCE	Percentage tolerance within which a shipment is automatically closed for invoicing before billing.
QTY_RCV_ EXCEPTION_CODE	PO_LINE_ LOCATIONS	QTY_RCV_ EXCEPTION_CODE	Describes the action taken when the quantity- received tolerance is exceeded.
DAYS_EARLY_ RECEIPT_ALLOWED	PO_LINE_ LOCATIONS	DAYS_EARLY_ RECEIPT_ALLOWED	Maximum acceptable number of days that items can be received early.
DAYS_LATE_ RECEIPT_ALLOWED	PO_LINE_ LOCATIONS	DAYS_LATE_ RECEIPT_ALLOWED	Minimum acceptable number of days that items can be received late.
ENFORCE_SHIP_ TO_LOCATION_CODE	PO_LINE_ LOCATIONS	ENFORCE_SHIP_ TO_LOCATION_CODE	Describes the action taken when the receiving location differs from the Ship To location.
RECEIPT_DAYS_ EXCEPTION_CODE	PO_LINE_ LOCATIONS	RECEIPT_DAYS_ EXCEPTION_CODE	Describes the action taken when items are received earlier or later than the allowed number of days.
ACCRUE_ON_ RECEIPT_FLAG	PO_LINE_ LOCATIONS	ACCRUE_ON_ RECEIPT_FLAG	Indicates whether items are accrued upon receipt.
ALLOW_SUBSTITUTE_ RECEIPTS_FLAG	PO_LINE_ LOCATIONS	ALLOW_SUBSTITUTE_ RECEIPTS_FLAG	Indicates whether substitute items can be received in place of ordered items.
TAX_USER_ OVERRIDE_FLAG	PO_LINE_ LOCATIONS	TAX_USER_ OVERRIDE_FLAG	Indicates whether someone overrode the default tax.
LINE_LOCATION_ID	PO_LINE_ LOCATIONS	LINE_LOCATION_I D	Required for outbound transactions. Unique identifier for PO Line Locations.
PO_LINE_ID	PO_LINES_ ALL	PO_LINE_ID	Required for outbound transactions. Unique identifier for PO lines.
CANCEL_FLAG	PO_LINES_ ALL	CANCEL_FLAG	Indicates whether the PO was cancelled.
CANCEL_REASON	PO_LINES_ ALL	CANCEL_REASON
CANCEL_DATE	PO_LINES_ ALL	CANCEL_DATE
CLOSED_FLAG	PO_LINES_ ALL	CLOSED_FLAG	Indicates whether the PO was closed.
CLOSED_REASON	PO_LINES_ ALL	CLOSED_REASON
CLOSED_DATE	PO_LINES_ ALL	CLOSED_DATE

Field Name	Oracle Applications Table/View Name	Column Name	Description
RATE_DATE	PO_DISTRIBUTIONS_ ALL	RATE_DATE	Currency conversion date.
AMOUNT_BILLED	PO_DISTRIBUTIONS_ ALL	AMOUNT_BILLED	Amount invoiced against distribution.
ENCUMBERED_ AMOUNT	PO_DISTRIBUTIONS_ ALL	ENCUMBERED_ AMOUNT	Distribution encumbered amount.
GL_ENCUMBERED_ PERIOD_NAME	PO_DISTRIBUTIONS_ ALL	GL_ENCUMBERED_ PERIOD_NAME	Period when the distribution was encumbered.
WIP_RESOURCE_ SEQ_NUM	PO_DISTRIBUTIONS_ ALL	WIP_RESOURCE_ SEQ_NUM	Work In Process resource sequence number.
DESTINATION_CONTEXT	PO_DISTRIBUTIONS_ ALL	DESTINATION_CONTEXT	Destination details description.
USSGL_ TRANSACTION_ CODE	PO_DISTRIBUTIONS_ ALL	USSGL_ TRANSACTION_ CODE	USA standard general ledger transaction code.
EXPENDITURE_ TYPE	PO_DISTRIBUTIONS_ ALL	EXPENDITURE_ TYPE	Project accounting expenditure type.
PROJECT_ ACCOUNTING_ CONTEXT	PO_DISTRIBUTIONS_ ALL	PROJECT_ ACCOUNTING_ CONTEXT	Project accounting context.
GL_CLOSED_DATE	PO_DISTRIBUTIONS_ ALL	GL_CLOSED_DATE	Date when the distribution is closed.
ACCRUE_ON_ RECEIPT_FLAG	PO_DISTRIBUTIONS_ ALL	ACCRUE_ON_ RECEIPT_FLAG	Indicates whether the items are accrued on receipt.
EXPENDITURE_ ITEM_DATE	PO_DISTRIBUTIONS_ ALL	EXPENDITURE_ ITEM_DATE	Project accounting expenditure item date.
QUANTITY_ ORDERED	PO_DISTRIBUTIONS_ ALL	QUANTITY_ ORDERED	Quantity ordered on the distribution.
QUANTITY_ DELIVERED	PO_DISTRIBUTIONS_ ALL	QUANTITY_ DELIVERED	Quantity delivered against the distribution.
QUANTITY_ CANCELLED	PO_DISTRIBUTIONS_ ALL	QUANTITY_ CANCELLED	Quantity cancelled for the distribution.
QUANTITY_ BILLED	PO_DISTRIBUTIONS_ ALL	QUANTITY_ BILLED	Quantity invoiced against the distribution.
REQ_HEADER_ REFERENCE_NUM	PO_DISTRIBUTIONS_ ALL	REQ_HEADER_ REFERENCE_NUM	Requisition number of the requisition line placed on the distribution.
REQ_LINE_ REFERENCE_NUM	PO_DISTRIBUTIONS_ ALL	REQ_LINE_ REFERENCE_NUM	Paper requisition line number.
RATE	PO_DISTRIBUTIONS_ ALL	RATE	Currency conversion rate.
ACCRUED_FLAG	PO_DISTRIBUTIONS_ ALL	ACCRUED_FLAG	Indicates whether distribution was accrued.
ENCUMBERED_ FLAG	PO_DISTRIBUTIONS_ ALL	ENCUMBERED_ FLAG	Distribution encumbered amount.
UNENCUMBERED_ QUANTITY	PO_DISTRIBUTIONS_ ALL	UNENCUMBERED_ QUANTITY	Quantity unencumbered on the distribution.
UNENCUMBERED_ AMOUNT	PO_DISTRIBUTIONS_ ALL	UNENCUMBERED_ AMOUNT	Amount unencumbered on the distribution.
GL_ENCUMBERED_ DATE	PO_DISTRIBUTIONS_ ALL	GL_ENCUMBERED_ DATE	Date the distribution was encumbered.
GL_CANCELLED_ DATE	PO_DISTRIBUTIONS_ ALL	GL_CANCELLED_ DATE	Date the distribution was cancelled.
DESTINATION_ TYPE_CODE	PO_DISTRIBUTIONS_ ALL	DESTINATION_ TYPE_CODE	Final destination name of the purchase item.
DESTINATION_ SUBINVENTORY	PO_DISTRIBUTIONS_ ALL	DESTINATION_ SUBINVENTORY	Final destination subinventory for inventory purchases.
WIP_OPERATION_ SEQ_NUM	PO_DISTRIBUTIONS_ ALL	WIP_OPERATION_ SEQ_NUM	Work In Process operations sequence number.
DISTRIBUTION_NUM	PO_DISTRIBUTIONS_ ALL	DISTRIBUTION_NUM	Document distribution number.
PREVENT_ ENCUMBRANCE_ FLAG	PO_DISTRIBUTIONS_ ALL	PREVENT_ ENCUMBRANCE_ FLAG	Indicates whether distribution should be encumbered.
RECOVERABLE_ TAX	PO_DISTRIBUTIONS_ ALL	RECOVERABLE_ TAX	Recoverable tax amount.
NONRECOVERABLE_ TAX	PO_DISTRIBUTIONS_ ALL	NONRECOVERABLE_ TAX	Non-recoverable tax amount.
RECOVERY_RATE	PO_DISTRIBUTIONS_ ALL	RECOVERY_RATE	Percentage of tax that can be recovered.
TAX_RECOVERY_ OVERRIDE_FLAG	PO_DISTRIBUTIONS_ ALL	TAX_RECOVERY_ OVERRIDE_FLAG	Indicates whether tax-recovery should be used.
DELIVERY_TO_ LOCATION	HR_LOCATIONS_ ALL	LOCATION_CODE	Location for the delivery.
DELIVERY_TO_ PERSON_FULL_NAME	PER_PEOPLE_ F	FULL_NAME	Person who will receive delivery.
DESTINATION_ ORGANIZATION	HR_ALL_ ORGANIZATION_UNITS		Organization that will receive the distribution.
SET_OF_BOOKS	GL_SET_OF_BOOKS	NAME	Set of General Ledger books.
CHARGE_ACCOUNT	GL_CODE_ COMBINATIONS_KFV	CONCATENATED_ SEGMENTS	Charge account number.
BUDGET_ACCOUNT	GL_CODE_ COMBINATIONS_KFV	CONCATENATED_ SEGMENTS	Budget account number.
ACCURAL_ACCOUNT	GL_CODE_ COMBINATIONS_KFV	CONCATENATED_ SEGMENTS	Accrual account number.
VARIANCE_ACCOUNT	GL_CODE_ COMBINATIONS_KFV	CONCATENATED_ SEGMENTS	Variance account number.
WIP_ENTITY	WIP_ENTITIES	WIP_ENTITY_NAME	Work In Process job.
WIP_REPETITIVE_ SCHEDULE	WIP_REPETITIVE_ SCHEDULES	DESCRIPTION	Work In Process repetitive schedule.
WIP_LINE_CODE	WIP_LINES	LINE_CODE	Work In Process line.
BOM_RESOURCE	BOM_RESOURCES	RESOURCE_CODE	Bill of Material resource.
PROJECT_NAME	PA_PROJECTS_ALL	NAME
TASK_NAME	PA_TASKS	TASK_NAME
EXPENDITURE	PA_EXPENDITURE_ TYPES	DESCRIPTION	Project accounting expenditure.
EXPENDITURE_ ORG_NAME	HR_ALL_ ORGANIZATION_ UNITS	NAME	Project accounting expenditure organization name.
PROJECT_ RELATED_FLAG	PO_DISTRIBUTIONS_ ALL	EXPENDITURE_ TYPE	Project accounting’s project related flag that uses N when NULL.
AWARD_FULL_ NAME	GMS_AWARDS_ ALL	AWARD_FULL_ NAME
LINE_LOCATION_ ID	PO_LINE_ LOCATIONS_ALL	LINE_LOCATION_ ID	Required for outbound transactions. Unique identifier for PO line locations.

Script	Description
wm_install_from_po.sql	Runs the scripts listed below, except the uninstall script.
wm_from_po_vw.sql	Creates the following required view components for PO outbound transactions: WM_PO_DISTRIBUTIONS_VW WM_PO_LINE_LOCATIONS_VW WM_PO_LINES_VW WM_PO_HEADERS_VW WM_PO_QRY_VW
wm_from_po_trg.sql	Creates the following trigger component to be used for writing to wm_trackchanges to indicate a new or updated document: WM_PO_HEADERS_ALL_IU_TRG
wm_disable_from_po.sql	Disables the triggers installed by wm_from_po_trg.sql.
wm_enable_from_po.sql	Re-enables the triggers installed by wm_from_po_trg.sql.
wm_drop_from_po.sql	Uninstalls all components created by wm_install_from_po.sql.