Send Purchase Order Service

This service is in the WmOAPRC1227 package and has the following fully-qualified service name: purchasing1227.fromOA.PO:sendPO.

This service retrieves all new or changed approved PO data, and presents it in a logical structure (a business document) that can be sent to a trading partner.

POs, once defined in Oracle Applications, cannot be deleted. Thus, business documents with the document status of INSERT or UPDATE (but not DELETE) will be created.

Approved POs may be updated and re-approved, and then closed or cancelled. The combination of Document Status, Status (PO Status), and Authorization Status defines the actual status of the PO at the polling instance. The decision to transfer the PO to a trading partner or to an internal organization must be made at implementation, based on the three statuses.

For example: A PO is created, approved, and then cancelled. One record of INSERT and one record of UPDATE are added to the Track Changes table. The sendPO service will retrieve the business document that has Autorization_status = APPROVED, Status = APPROVED, CLOSED, CANCELLED, and Transaction_status = INSERT. This document cannot be sent to the trading partner.

Database Scripts

This service uses the following database scripts:

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.

For more information about using database scripts, see Database Scripts.

Supporting Transaction Definitions

This service was built from the configured services defined in the following transaction definition:

getPOTxn1227.txp

For information about using the transaction definition files to customize this service, see Transaction Definitions.

Flow Control

The main flow sendPO executes as follows:

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
lockTxnCtrl determines whether the sendPO service is ready for execution. That is, it determines whether there is no other instance of this service already in process.
- If lockTxnCtrl service returns False, that means another instance of this service is already in progress. The service exits and waits for the next scheduled execution.
- If lockTxnCtrl service returns True, that means the service is ready to execute. The PO row in the control table is locked and updated so that the status is changed to INPROCESS, which prevents other PO services from executing.
getPOTxn service queries the Oracle Applications database for any PO transaction to be processed. The number of records returned depends on the parameter value specified in the above map.
processBizDoc is the customizable step that sends the business document to the trading partner by looping against each document. This step also needs to be customized to receive a SUCCESS or an ERROR status of the document transfer, along with the error information. The transfer status and any error information are logged against each document.
Loops against each document. Based on the Debug Mode specified during execution, it either purges or updates the records in the WM_TRACKCHANGES custom table.
- If the Debug Mode is TRUE, the records in the WM_TRACKCHANGES table are updated and the PROCESSED_FLAG is set to Y. This ensures that the same sets of records are not picked up during the next polling interval. The updateTrackChanges service updates the PROCESSED_FLAG in the WM_TRACKCHANGES table to Y, and updates the Processed_Date to sysdate so that same information is not picked up again during next polling instance.
- If the Debug Mode is FALSE, the records in the WM_TRACKCHANGES table are deleted. The purgeTrackChanges service purges the records from the WM_TRACKCHANGES table.
Loops against each document. Based on the transfer status, the insertTransferERRInfo service inserts a new record in the WM_TRACKCHANGES table so that same document can be picked up during the next polling interval.
unlockTxnCtrl service releases the lock on the Custom Control table so that the next polling instance of sendVendor service can begin.
getLastError service logs any errors that occur in the above steps.
unlockTxnCtrl releases the lock on the Custom Control table.

For more details on send transactions, see Overview of Send Service Transaction Processing.

Business Document Structure

This service uses the following business document structure:

1.0. PO_HEADERS
- 1.1. PO_LINES
- 1.1.1. PO_LINE_LOCATIONS
  - 1.1.1.1. PO_DISTRIBUTIONS

1.0. PO_HEADERS

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.

1.1. PO_LINES

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

1.1.1. PO_LINE_LOCATIONS

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

1.1.1.1. PO_DISTRIBUTIONS

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.