Send Request For Quotation Service

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

This service notifies and delivers Request For Quotation (RFQ) changes. Because RFQs cannot be deleted, the document status of DELETE does not apply in this case.

Database Scripts

This service uses the following database scripts:

Script	Description
wm_install_from_rfq.sql	Runs the scripts listed below, except the uninstall script.
wm_from_rfq_vw.sql	Creates the following required view components for RFQ outbound transactions: WM_RFQ_HEADERS_VW WM_RFQ_LINES_VW WM_RFQ_PRICE_BREAKS_VW WM_RFQ_QRY_VW
wm_from_rfq_trg.sql	Creates the following trigger component to be used for writing to wm_trackchanges to indicate a new or updated document: WM_PO_RFQ_VENDORS_IU_TRG
wm_disable_from_rfq.sql	Disables the triggers installed by wm_from_rfq_trg.sql.
wm_enable_from_rfq.sql	Re-enables the triggers installed by wm_from_rfq_trg.sql.
wm_drop_from_rfq.sql	Uninstalls all components created by wm_install_from_rfq.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:

getRFQTxn1227.txp

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

Flow Control

The main flow sendRFQ executes as follows:

specifyDefaultSettings specifies the default parameter settings required for service execution. You should change these settings accordingly.
lockTxnCtrl determines whether the sendRFQ 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 next scheduled execution.
- If lockTxnCtrl service returns True, that means the service is ready to execute. The RFQ row in the control table is locked and updated so that the status is changed to INPROCESS, which prevents other RFQ services from executing.
getRFQTxn service queries the Oracle Applications database for any RFQ 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. You must customize this step to receive a SUCCESS or an ERROR status of the document transfer, along with the error information. 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 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 Processed_Date to sysdate so that same information is not picked up again during the 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 the same document can be picked up during the next polling interval.
getLastError service logs any errors so that the next polling instance of sendVendor service can begin.
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. RFQ_HEADERS
- 1.1. RFQ_LINES
  - 1.1.1. RFQ_PRICE_BREAKS

1.0. RFQ_HEADERS

Field Name	Oracle Applications Table/View Name	Column Name	Description
WEB_ TRANSACTION_ ID
DOCUMENT_TYPE			Use RFQ.
DOCUMENT_ STATUS			Use INSERT or UPDATE.
RFQ_ID	PO_HEADERS_ ALL PO_RFQ_VENDORS	PO_HEADER_ ID PO_HEADER_ID	Request For Quotation (RFQ) identifier.
PO_HEADER_ID	PO_HEADERS_ ALL	PO_HEADER_ ID	Required for outbound transactions. Unique identifier for the RFQ header.
RFQ_NUMBER	PO_HEADERS_ ALL	SEGMENT1
VENDOR_NAME	PO_HEADERS_ ALL	VENDOR_ NAME
VENDOR_ ADDRESS_LINE1	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE1
VENDOR_ ADDRESS_LINE2	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE2
VENDOR_ ADDRESS_LINE3	AP_SUPPLIER_ SITES_ALL	ADDRESS_LINE3
VENDOR_CITY	AP_SUPPLIER_ SITES_ALL	CITY
VENDOR_STATE	AP_SUPPLIER_ SITES_ALL	STATE
VENDOR_ZIP	AP_SUPPLIER_ SITES_ALL	ZIP
VENDOR_COUNTRY	AP_SUPPLIER_ SITES_ALL	COUNTRY
VENDOR_PHONE	AP_SUPPLIER_ SITES_ALL	AREA_CODE + PHONE
VENDOR_FAX	AP_SUPPLIER_ SITES_ALL	FAX_AREA_CODE + FAX
VENDOR_ CONTACT_NAME	PO_VENDOR_ CONTACTS	PERSON_LAST_NAME + PERSON_FIRST_NAME
VENDOR_ PRINT_FLAG	PO_RFQ_ VENDORS	PRINT_FLAG
VENDOR_ PRINT_COUNT	PO_RFQ_ VENDORS	PRINT_COUNT	Vendor RFQ print count.
VENDOR_ PRINTED_DATE	PO_RFQ_ VENDORS	PRINTED_DATE	RFQ printed date.
HOLD_FLAG	AP_SUPPLIERS	HOLD_FLAG
DOCUMENT_ TYPE_NAME	PO_DOCUMENT_ TYPES	NAME	Name of the RFQ document type.
CREATED	PO_HEADERS_ALL	CREATION_ DATE	Date the RFQ was created.
TYPE_LOOKUP_ CODE	PO_HEADERS_ALL	TYPE_LOOKUP_ CODE	Type of the document.
RFQ_STATUS	PO_HEADERS_ALL	STATUS_LOOKUP_ CODE	Status of the RFQ: In Process, Active, or Closed.
REVISION_NUM	PO_HEADERS_ALL	REVISION_NUM	RFQ revision number.
SHIP_TO_ LOCATION_ADD_LINE_1	HR_LOCATIONS	ADDRESS_LINE_1	Address where the PO items will be shipped. Derives the SHIP_TO_LOCATION_ID.
SHIP_TO_ LOCATION_ADD_ LINE_2	HR_LOCATIONS	ADDRESS_LINE_2
SHIP_TO_ LOCATION_ ADD_LINE_3	HR_LOCATIONS	ADDRESS_LINE_3
SHIP_TO_ LOCATION_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
SHIP_TO_ LOCATION_ COUNTY	HR_LOCATIONS	REGION_1
SHIP_TO_ LOCATION_STATE	HR_LOCATIONS	REGION_2
SHIP_TO_ LOCATION_ REGION_3	HR_LOCATIONS	REGION_3
SHIP_TO_ LOCATION_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
SHIP_TO_ LOCATION_ COUNTRY	HR_LOCATIONS	COUNTRY
BILL_TO_ LOCATION_ ADD_LINE_1	HR_LOCATIONS	ADDRESS_LINE_1	Address where the bill will be sent. Derives the BILL_TO_LOCATION_ID.
BILL_TO_ LOCATION_ ADD_LINE_2	HR_LOCATIONS	ADDRESS_LINE_2
BILL_TO_ LOCATION_ ADD_LINE_3	HR_LOCATIONS	ADDRESS_LINE_3
BILL_TO_ LOCATION_ TOWN_OR_CITY	HR_LOCATIONS	TOWN_OR_CITY
BILL_TO_ LOCATION_ COUNTY	HR_LOCATIONS	REGION_1
BILL_TO_ LOCATION_ STATE	HR_LOCATIONS	REGION_2
BILL_TO_ LOCATION_ REGION_3	HR_LOCATIONS	REGION_3
BILL_TO_ LOCATION_ POSTAL_CODE	HR_LOCATIONS	POSTAL_CODE
BILL_TO_ LOCATION_ COUNTRY	HR_LOCATIONS	COUNTRY
AGENT_NAME	PER_ALL_ PEOPLE_F	NAME	Buyer’s name.
COMMENTS	PO_HEADERS_ALL	COMMENTS	Comments about the RFQ.
QUOTE_VENDOR_ QUOTE_NUMBER	VENDOR_ DOC_NUM	QUOTE_VENDOR_ QUOTE_NUMBER	Supplier document number.
FROM_TYPE_ LOOKUP_CODE	PO_HEADERS_ ALL	FROM_TYPE_ LOOKUP_CODE
FROM_RFQ_ NUMBER	PO_HEADERS_ ALL	SEGMENT1
RFQ_CLOSE_DATE	PO_HEADERS_ ALL	RFQ_CLOSE_DATE
REPLY_VIA	PO_HEADERS_ ALL	REPLY_METHOD_ LOOKUP_CODE	Method the supplier should use to reply to the RFQ.
REPLY_DATE	PO_HEADERS_ ALL	REPLY_DATE	Due date of reply for the RFQ.
START_DATE	PO_HEADERS_ ALL	START_DATE	Effective date for the RFQ.
END_DATE	PO_HEADERS_ ALL	END_DATE	Expiration date for the RFQ.
APPROVAL_ REQUIRED_ FLAG	PO_HEADERS_ ALL	APPROVAL_ REQUIRED_ FLAG	Indicates whether approval is required for the RFQ.
CURRENCY_CODE	PO_HEADERS_ ALL	CURRENCY_CODE	Currency code for the RFQ.
USER_ CONVERSION_ TYPE	PO_HEADERS_ ALL	USER_ CONVERSION_ TYPE	Conversion type used.
RATE_TYPE	PO_HEADERS_ ALL	RATE_TYPE	Currency conversion rate type.
RATE_DATE	PO_HEADERS_ ALL	RATE_DATE	Currency conversion rate date.
RATE	PO_HEADERS_ ALL	RATE	Currency conversion rate.
TERMS_NAME	AP_TERMS	NAME	Payment terms for the RFQ.
FREIGHT_TERMS	PO_HEADERS_ ALL	FREIGHT_TERMS	Freight payment terms.
SHIP_VIA_ LOOKUP_CODE	PO_HEADERS_ ALL	SHIP_VIA_ LOOKUP_CODE	Code indicating the shipping medium, such as UPS or FEDEX.
FOB	PO_HEADERS_ ALL	FOB	Type of Free On Board terms for the document.
NOTE_TO_VENDOR	PO_HEADERS_ ALL	NOTE_TO_VENDOR
QUOTE_ WARNING_ DELAY	PO_HEADERS_ ALL	QUOTE_ WARNING_ DELAY	Number of days before the expiration of the quotation.
QUOTATION_ CLASS_CODE	PO_HEADERS_ ALL	QUOTATION_ CLASS_CODE
REVISED_DATE	PO_HEADERS_ ALL	REVISED_DATE	Date the document was last revised.
CLOSED_DATE	PO_HEADERS_ ALL	CLOSED_DATE	Date when the document was closed.
QUOTE_TYPE_ LOOKUP_CODE	PO_HEADERS_ ALL	QUOTE_TYPE_ LOOKUP_CODE

1.1. RFQ_LINES

Field Name	Oracle Applications Table/View Name	Column Name	Description
PO_LINE_ID	PO_LINES_ALL	PO_LINE_ID	Required for outbound transactions. Unique identifier for RFQ line.
LINE_NUM	PO_LINES_ALL	LINE_NUM	Line number.
LINE_TYPE	PO_LINES_ALL	LINE_TYPE
ITEM_NUMBER	MTL_SYSTEM_ ITEMS	SEGMENT1
ITEM_REVISION	PO_LINES_ALL	ITEM_REVISION
ITEM_CATEGORY	MTL_CATEGORIES_ KFV	CONCATENATED_ SEGMENTS
ITEM_DESCRIPTION	PO_LINES_ALL	ITEM_DESCRIPTION
UNIT_MEAS_ LOOKUP_CODE	PO_LINES_ALL	UNIT_MEAS_ LOOKUP_CODE	Unit of measurement for the items.
UOM_CLASS	MTL_UNITS_OF_ MEASURE_TL	UOM_CLASS	Unit of measurement class.
UNIT_PRICE	PO_LINES_ALL	UNIT_PRICE
VENDOR_ PRODUCT_ NUM	PO_LINES_ALL	VENDOR_ PRODUCT_ NUM	Supplier’s item number ordered.
UN_NUMBER	PO_LINES_ALL	UN_NUMBER
HAZARD_CLASS	PO_LINES_ALL	HAZARD_ CLASS
MIN_ORDER_ QUANTITY	PO_UN_NUMBERS	MIN_ORDER_ QUANTITY	Minimum order quantity for the RFQ.
MAX_ORDER_ QUANTITY	PO_HAZARD_ CLASSES	MAX_ORDER_ QUANTITY	Maximum order quantity for the RFQ.
NOTE_TO_ VENDOR	PO_LINES_ALL	NOTE_TO_ VENDOR	Note to the supplier.
FROM_RFQ_ NUMBER	PO_LINES_ALL	FROM_RFQ_ NUMBER
FROM_LINE_ NUMBER	PO_LINES_ALL	FROM_LINE_ NUMBER
TAXABLE_FLAG	PO_LINES_ALL	TAXABLE_FLAG
QUANTITY	PO_LINES_ALL	QUANTITY
ALLOW_ITEM_ DESC_UPDATE_ FLAG	MTL_CATEGORIES_ KFV	ALLOW_ITEM_ DESC_UPDATE_ FLAG	Indicates whether item description update is allowed.
ALLOWED_ UNITS_LOOKUP_ CODE	MTL_ CATEGORIES_ KFV	ALLOWED_ UNITS_LOOKUP_ CODE	Code for allowed units of the items in the RFQ.
ORDER_TYPE_ LOOKUP_CODE	PO_LINE_TYPES	ORDER_TYPE_ LOOKUP_CODE
OUTSIDE_ OPERATION_ FLAG	PO_LINE_TYPES	OUTSIDE_ OPERATION_ FLAG
PROJECT_NAME	PA_PROJECTS_ ALL	PROJECT_NAME
TASK_NAME	PA_TASKS	TASK_NAME
QC_GRADE	PO_LINES_ALL	QC_GRADE
BASE_UOM	PO_LINES_ALL	BASE_UOM	Base unit of measurement.
BASE_QTY	PO_LINES_ALL	BASE_QTY	Base quantity.
SECONDARY_ UOM	PO_LINES_ALL	SECONDARY_ UOM	Stores the dual unit of measure for the item ordered.
SECONDARY_ QTY	PO_LINES_ALL	SECONDARY_ QTY	Converted quantity from BASE unit of measurement to DUAL unit of measurement for the item ordered.

1.1.1. RFQ_PRICE_BREAKS

Field Name	Oracle Applications Table/View Name	Column Name	Description
SHIPMENT_TYPE	PO_LINE_ LOCATIONS_ALL	SHIPMENT_TYPE	RFQ shipment type.
SHIP_TO_ ORG_NAME	ORG_ ORGANIZATION_ DEFINITIONS	ORGANIZATION_ NAME	Organization that will receive the shipped items.
QUANTITY	PO_LINE_ LOCATIONS_ALL	QUANTITY
QUANTITY_ ACCEPTED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ ACCEPTED
QUANTITY_ BILLED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ BILLED
QUANTITY_ CANCELLED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ CANCELLED
QUANTITY_ RECEIVED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ RECEIVED
QUANTITY_ REJECTED	PO_LINE_ LOCATIONS_ALL	QUANTITY_ REJECTED
UOM	PO_LINE_ LOCATIONS_ALL	UOM	Unit of measurement.
PRICE_OVERRIDE	PO_LINE_ LOCATIONS_ALL	PRICE_OVERRIDE
UNIT_PRICE	PO_LINES_ALL	UNIT_PRICE	Unit price of the item in RFQ.
NOT_TO_ EXCEED_PRICE	PO_LINES_ALL	NOT_TO_ EXCEED_PRICE	Maximum price of the item.
ALLOW_PRICE_ OVERRIDE_FLAG	PO_LINES_ALL	ALLOW_PRICE_ OVERRIDE_FLAG	Indicates whether price override is allowed.
PRICE_BREAK_ LOOKUP_CODE	PO_LINES_ALL	PRICE_BREAK_ LOOKUP_CODE
PRICE	PO_LINE_ LOCATIONS_ALL	PRICE	Price of the item in the RFQ.
LAST_ACCEPT_ DATE	PO_LINE_ LOCATIONS_ALL	LAST_ACCEPT_ DATE	Date when the item can be last accepted.
NEED_BY_DATE	PO_LINE_ LOCATIONS_ALL	NEED_BY_DATE	Date by which the item in the RFQ needs to be shipped.
PROMISED_DATE	PO_LINE_ LOCATIONS_ALL	PROMISED_DATE	Date promised by the supplier when the item would be delivered.
FIRM_STATUS_ LOOKUP_CODE	PO_LINE_ LOCATIONS_ALL	FIRM_STATUS_ LOOKUP_CODE	Firming status of the line.
PRICE_DISCOUNT	PO_LINE_ LOCATIONS_ALL	PRICE_DISCOUNT	Discount percentage for price break.
START_DATE	PO_LINE_ LOCATIONS_ALL	START_DATE	Effective date.
END_DATE	PO_LINE_ LOCATIONS_ALL	END_DATE	Expiration date.
LEAD_TIME	PO_LINE_ LOCATIONS_ALL	LEAD_TIME	Lead time for the price break.
LEAD_TIME_UNIT	PO_LINE_ LOCATIONS_ALL	LEAD_TIME_UNIT
TERMS_NAME	AP_TERMS	NAME
FREIGHT_TERMS_ LOOKUP_CODE	PO_LINE_ LOCATIONS_ALL	FREIGHT_TERMS_ LOOKUP_CODE	Lookup code for freight terms.
FOB_ LOOKUP_CODE	PO_LINE_ LOCATIONS_ALL	FOB_ LOOKUP_CODE	Free on Board lookup code.
SHIP_VIA_ LOOKUP_CODE	PO_LINE_ LOCATIONS_ALL	SHIP_VIA_ LOOKUP_CODE	Type of carrier for the RFQ or quotation shipment.
TAX_NAME	AP_TAX_CODES_ALL	NAME
TAXABLE_FLAG	PO_LINE_ LOCATIONS_ALL	TAXABLE_FLAG	Indicates whether the price break is taxable.
INSPECTION_ REQUIRED_ FLAG	PO_LINE_ LOCATIONS_ALL	INSPECTION_ REQUIRED_ FLAG	Indicates whether shipment must be inspected before the invoice is paid.
RECEIPT_ REQUIRED_ FLAG	PO_LINE_ LOCATIONS_ALL	RECEIPT_ REQUIRED_ FLAG	Indicates whether shipment must be received before the invoice is paid.
RECEIVE_ CLOSE_ TOLERANCE	PO_LINE_ LOCATIONS_ALL	RECEIVE_ CLOSE_ TOLERANCE	Percentage tolerance within which the shipment is automatically closed for receiving.
INVOICE_ CLOSE_ TOLERANCE	PO_LINE_ LOCATIONS_ALL	INVOICE_ CLOSE_ TOLERANCE	Percentage tolerance within which the shipment is automatically closed for invoicing when billed.
QTY_RCV_ EXCEPTION_CODE	PO_LINE_ LOCATIONS_ALL	QTY_RCV_ EXCEPTION_CODE	Describes the action taken when the quantity received tolerance is exceeded.
DAYS_EARLY_ RECEIPT_ ALLOWED	PO_LINE_ LOCATIONS_ALL	DAYS_EARLY_ RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early.
DAYS_LATE_ RECEIPT_ ALLOWED	PO_LINE_ LOCATIONS_ALL	DAYS_LATE_ RECEIPT_ALLOWED	Maximum acceptable number of days items can be received late.
QTY_RCV_ TOLERANCE	PO_LINE_ LOCATIONS_ALL	QTY_RCV_ TOLERANCE	Maximum over–receipt tolerance percentage.
ROUTING_NAME	RCV_ROUTING_HEADERS	NAME
ENFORCE_ SHIP_TO_ LOCATION_CODE	PO_LINE_ LOCATIONS_ALL	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_ALL	RECEIPT_DAYS_ EXCEPTION_CODE	Describes what action is taken when items are received earlier or later than the allowed number of days specified.
ACCRUE_ON_ RECEIPT_FLAG	PO_LINE_ LOCATIONS_ALL	ACCRUE_ON_ RECEIPT_FLAG	Indicates whether items are accrued upon receipt.
ALLOW_ SUBSTITUTE_ RECEIPTS_FLAG	PO_LINE_ LOCATIONS_ALL	ALLOW_ SUBSTITUTE_ RECEIPTS_FLAG	Indicates whether substitute items can be received in place of the ordered items.
FROM_PO_ HEADER_NUM	PO_HEADERS_ ALL	SEGMENT1	Unique identifier of the RFQ to automatically create the quotation.
FROM_PO_ LINE_NUM	PO_LINES_ALL	LINE_NUM	Unique identifier of the RFQ line used to automatically create the quotation line.
ENCUMBERED_ FLAG	PO_LINE_ LOCATIONS_ALL	ENCUMBERED_ FLAG	Indicates whether the shipment is encumbered.
ENCUMBERED_ DATE	PO_LINE_ LOCATIONS_ALL	ENCUMBERED_ DATE	Date of encumbrance for the shipment.
APPROVED_FLAG	PO_LINE_ LOCATIONS_ALL	APPROVED_FLAG	Indicates whether the shipment is approved.
CLOSED_CODE	PO_LINE_ LOCATIONS_ALL	CLOSED_CODE	Closure status of the shipment.
CANCEL_FLAG	PO_LINE_ LOCATIONS_ALL	CANCEL_FLAG	Indicates whether the shipment is cancelled.
CANCEL_DATE	PO_LINE_ LOCATIONS_ALL	CANCEL_DATE
CANCEL_REASON	PO_LINE_ LOCATIONS_ALL	CANCEL_REASON	Cancellation reason provided by the employee.
CLOSED_BY_ PERSON_NAME	PER_ALL_ PEOPLE_F	PERSON_LAST_NAME. PERSON_FIRST_NAME	Employee who closed the shipment.
CLOSED_DATE	PO_LINE_ LOCATIONS_ALL	CLOSED_DATE	Date the shipment closed.
CLOSED_REASON	PO_LINE_ LOCATIONS_ALL	CLOSED_REASON	Why the shipment closed.
USSGL_ TRANSACTION_ CODE	PO_LINE_ LOCATIONS_ALL	USSGL_ TRANSACTION_ CODE	United States standard general ledger transaction code.
GOVERNMENT_ CONTEXT	PO_LINE_ LOCATIONS_ALL	GOVERNMENT_ CONTEXT	United States standard general ledger descriptive flexfield context column.
LINE_TYPE	PO_LINE_TYPES	LINE_TYPE	Document line type.
OUTSIDE_ OPERATION_ FLAG	PO_LINE_TYPES	OUTSIDE_ OPERATION_ FLAG	Indicates whether the line type is an outside operation.
RECEIVING_FLAG	PO_LINE_TYPES	RECEIVING_FLAG	Default receipt required flag.
ITEM_NUMBER	MTL_SYSTEM_ITEMS	SEGMENT1
ITEM_DESCRIPTION	PO_LINE_ LOCATIONS_ALL	ITEM_DESCRIPTION
ITEM_REVISION	PO_LINE_ LOCATIONS_ALL	ITEM_REVISION
PLANNING_CODE	MTL_SYSTEM_ ITEMS	MRP_PLANNING_ CODE / INVENTORY_ PLANNING_ CODE
STOCK_ ENABLED_FLAG	MTL_SYSTEM_ ITEMS	STOCK_ ENABLED_FLAG	Indicates whether the item is in stock.
OUTSIDE_ OPERATION_ UOM_TYPE	MTL_SYSTEM_ ITEMS	OUTSIDE_ OPERATION_ UOM_TYPE	Outside operation unit of measurement.
CATEGORY_NAME	MTL_CATEGORIES_ KFV	CONCATENATED_ SEGMENTS	Item category name.
VENDOR_ PRODUCT_ NUM	PO_LINES_ALL	VENDOR_ PRODUCT_ NUM	Supplier product number.
COUNTRY_OF_ ORIGIN_CODE	PO_LINE_ LOCATIONS_ALL	COUNTRY_OF_ ORIGIN_CODE	Country of manufacture for this shipment.
TAX_USER_ OVERRIDE_FLAG	PO_LINE_ LOCATIONS_ALL	TAX_USER_ OVERRIDE_FLAG	Indicates whether someone overrode the default tax.
MATCH_OPTION	PO_LINE_ LOCATIONS_ALL	MATCH_OPTION	Indicates whether the invoice for the shipment should be matched to the purchase order or the receipt.
CALCULATE_ TAX_FLAG	PO_LINE_ LOCATIONS_ALL	CALCULATE_ TAX_FLAG	Indicates whether tax needs to be calculated.
NOTE_TO_ RECEIVER	PO_LINE_ LOCATIONS_ALL	NOTE_TO_ RECEIVER
SECONDARY_ UNIT_OF_MEASURE	PO_LINES_ALL	SECONDARY_ UNIT_OF_MEASURE	Stores the dual unit of measure for the item ordered.
SECONDARY_ QUANTITY	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY	Stores the dual quantity for the item ordered.
PREFERRED_ GRADE	PO_LINE_ LOCATIONS_ALL	PREFERRED_ GRADE	Preferred grade of the item ordered.
SECONDARY_ QUANTITY_ RECEIVED	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY_ RECEIVED	Stores the dual quantity received for the item ordered.
SECONDARY_ QUANTITY_ ACCEPTED	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY_ ACCEPTED	Stores the dual quantity accepted for the item ordered.
SECONDARY_ QUANTITY_ REJECTED	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY_ REJECTED	Stores the dual quantity rejected for the item ordered.
SECONDARY_ QUANTITY_ CANCELLED	PO_LINE_ LOCATIONS_ALL	SECONDARY_ QUANTITY_ CANCELLED	Stores the dual quantity cancelled for the item ordered.