My Purchasing Table Descriptions hand book (I have big hands) part 2

Purchasing - PO_LINE_LOCATIONS_ALL	Document shipment schedules (for purchase orders, purchase agreements, quotations, RFQs)
Column Name	Descritpion
QUANTITY	Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
QUANTITY_ACCEPTED	Quantity accepted after inspection, up until today
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
COUNTRY_OF_ORIGIN_CODE	Country of manufacture for this shipment
TAX_USER_OVERRIDE_FLAG	Indicator of whether somone overrode the default tax
QUANTITY_RECEIVED	Quantity received until today
MATCH_OPTION	Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt
TAX_CODE_ID	Unique identifier for the tax code(References AP_TAX_CODES_ALL.tax_id)
CALCULATE_TAX_FLAG	Indicator of whether tax needs to be calculated
CHANGE_PROMISED_DATE_REASON	Reason for changing the promised-by date
NOTE_TO_RECEIVER	Shipment level Note to receiver, which would hold the note to receiver info coming from req lines.
SECONDARY_QUANTITY	OPM:Secondary Quantity ordered
SECONDARY_UNIT_OF_MEASURE	OPM:Secondary Unit of measure for the ordered item
PREFERRED_GRADE	Preferred quality grade for the ordered item
SECONDARY_QUANTITY_RECEIVED	Quantity in secondary unit of measure received until today
SECONDARY_QUANTITY_ACCEPTED	Quantity accepted in secondary unit of measure after inspection, up until today
QUANTITY_REJECTED	Quantity rejected after inspection, up until today
SECONDARY_QUANTITY_REJECTED	Quantity rejected in secondary unit of measure after inspection, up until today
SECONDARY_QUANTITY_CANCELLED	Quantity cancelled in secondary unit of measure after inspection, up until today
SECONDARY_QUANTITY_SHIPPED	Quantity in secondary unit of measure shipped up until today
VMI_FLAG	Indicates VMI shipment line with value = 'Y'
CONSIGNED_FLAG	Indicates shipment is consigned
RETROACTIVE_DATE	Column used to store the date of a retroactive price change
SUPPLIER_ORDER_LINE_NUMBER	Used to store a supplier change request
AMOUNT	Stores the amount on the shipments for service lines
AMOUNT_RECEIVED	Stores the amount received for service lines
AMOUNT_BILLED	Stores the amount billed for service lines
QUANTITY_BILLED	Quantity invoiced by Oracle Payables, up until today
AMOUNT_CANCELLED	Amount cancelled for service lines
AMOUNT_REJECTED	Amount rejected for service lines
AMOUNT_ACCEPTED	Amount Accepted for service lines
DROP_SHIP_FLAG	Indicates whether the Shipment has a backing Sales Order Line.
SALES_ORDER_UPDATE_DATE	The date/time when any of referenced data elements on the backing Sales Order Line is updated.
TRANSACTION_FLOW_HEADER_ID	Transaction flow header identifier(References MTL_TRANSACTION_FLOW_HEADERS.header_id)
FINAL_MATCH_FLAG	This flag indicates if the shipment is finally matched by AP invoice. This field is not upgraded. Hence may not reflect accurately for old data. This field is only used by AP as of 11.5.10
MANUAL_PRICE_CHANGE_FLAG	Only for Blanket Release shipments: Y if the user has manually entered a price overriding the Blanket Agreement price, N or null otherwise.
SHIPMENT_CLOSED_DATE	Date when the Shipment is closed for both Receiving and Invoice
CLOSED_FOR_RECEIVING_DATE	Date when the Shipment is closed for receiving
QUANTITY_CANCELLED	Quantity cancelled
CLOSED_FOR_INVOICE_DATE	Date when the Shipment is closed for Invoice
VALUE_BASIS	Value basis of the line location
MATCHING_BASIS	Matching basis of the line location
PAYMENT_TYPE	Pay Item type
DESCRIPTION	Pay Item description
WORK_APPROVER_ID	FND User ID of the Pay Item's Work Confirmation Owner
BID_PAYMENT_ID	References the Bid Pay Item if it was negotiated in Sourcing
QUANTITY_FINANCED	For Financing Pay Items, the number of units which have been pre-paid
AMOUNT_FINANCED	For Advances or Financing Pay Items, the amount which has been pre-paid
QUANTITY_RECOUPED	For Financing Pay Items, the number of units for which prepayments have been liquidated
UNIT_MEAS_LOOKUP_CODE	Price break quantity unit of measure (References MTL_UNITS_OF_MEASURE.unit_of_measure.)
AMOUNT_RECOUPED	For Advances or Financing Pay Items, the amount of the prepayments which has been liquidated
RETAINAGE_WITHHELD_AMOUNT	The total amount withheld as Retainage against this Pay Item
RETAINAGE_RELEASED_AMOUNT	The amount of Retainage released for this Pay Item
AMOUNT_SHIPPED	Amount pending for Work Confirmation
OUTSOURCED_ASSEMBLY	This column identifies whether the item is a shikyu item or not
TAX_ATTRIBUTE_UPDATE_CODE	Keeps track of create/update actions on this entity
ORIGINAL_SHIPMENT_ID	Holds the line_location_id of the shipment from which this shipment was copied/split over
LCM_FLAG	LCM Flag
UDA_TEMPLATE_ID
DRAFT_ID
PO_RELEASE_ID	Release unique identifier for a release shipment(References PO_RELEASES_ALL.po_release_id)
SHIP_TO_LOCATION_ID	Unique identifier for the ship-to location (References HR_LOCATIONS_ALL.location_id)
SHIP_VIA_LOOKUP_CODE	Type of carrier for the RFQ or quotation shipment (References ORG_FREIGHT_TL.freight_code)
LINE_LOCATION_ID	Document shipment schedule unique identifier
NEED_BY_DATE	Need-by date for the shipment schedule
PROMISED_DATE	Supplier promised delivery date
LAST_ACCEPT_DATE	Latest acceptable receipt date for the shipment
PRICE_OVERRIDE	Order shipment price or break price for blanket purchase orders, RFQs, and quotations
ENCUMBERED_FLAG	Indicates whether the shipment is encumbered or not
ENCUMBERED_DATE	Date of encumbrance for the shipment
UNENCUMBERED_QUANTITY	Encumbered quantity to date (Unused since release version 7.0)
FOB_LOOKUP_CODE	Type of free-on-board terms for the shipment (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB')
FREIGHT_TERMS_LOOKUP_CODE	Type of freight terms for the RFQ or quotation shipment (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FREIGHT TERMS')
TAXABLE_FLAG	Indicates whether the shipment is taxable
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
TAX_NAME	Tax code for the shipment (References AP_TAX_CODES_ALL.name)
ESTIMATED_TAX_AMOUNT	Estimated tax amount for the purchase order shipment (Unused since release version 6.0)
FROM_HEADER_ID	Unique identifier of the RFQ used to autocreate the quotation. For Standard Purchase Orders referencing Global Agreements, this field captures the unique Identifier of Global Agreements(References: PO_HEADERS_ALL.PO_HEADER_ID)
FROM_LINE_ID	Unique identifier of the RFQ line used to autocreate the quotation line. For Standard PO Lines that reference Global Agreement lines, this field captures the unique identifier of Global Agreement line (References PO_LINES_ALL.po_line_id)
FROM_LINE_LOCATION_ID	Unique identifier of the RFQ shipment used to autocreate a quotation shipment. For Standard POs that reference Global Agreements, this field captures the Global Agreement Price Break Unique Identifier (references PO_LINE_LOCATIONS_ALL.line_
START_DATE	Effective date of the price break (applies to RFQs and quotations only)
END_DATE	Expiration date of the price break (applies to RFQs and quotations only)
LEAD_TIME	Lead time for the price break (applies to RFQs and quotations only)
LEAD_TIME_UNIT	Unit of measure for the lead time
PRICE_DISCOUNT	Discount percentage for price break (applies to RFQs and quotations only)
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
TERMS_ID	Payment terms unique identifier(References AP_TERMS.term_id)
APPROVED_FLAG	Indicates whether the shipment is approved
APPROVED_DATE	Approval date for shipment(No longer used)
CLOSED_FLAG	No longer used
CANCEL_FLAG	Indicates whether the shipment is cancelled or not
CANCELLED_BY	Unique identifier of the employee who cancelled the shipment (References to HR_EMPLOYEES.employee_id)
CANCEL_DATE	Cancellation date
CANCEL_REASON	Cancellation reason provided by the employee
FIRM_STATUS_LOOKUP_CODE	Indicates whether you want to prevent this Shipment from being automatically rescheduled by your manufacturing application.
FIRM_DATE	No longer used
PO_HEADER_ID	Document header unique identifier. (References PO_HEADERS_ALL.po_header_id.). For Release shipments, this references the Unique identifier of Blanket PO
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
PO_LINE_ID	Document line unique identifier (References PO_LINES_ALL.po_line_id). For Release Shipments, this references the unique line identifier of Blanket PO
ATTRIBUTE10	Descriptive flexfield segment
UNIT_OF_MEASURE_CLASS	Unit of measure class (Unused since release version 7.0)
ENCUMBER_NOW	Indicates whether the shipment should be encumbered (Unused since release version 7.0)
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
INSPECTION_REQUIRED_FLAG	Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG	Indicates whether shipment must be received before the invoice is paid
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
QTY_RCV_TOLERANCE	Maximum over-receipt tolerance percentage
QTY_RCV_EXCEPTION_CODE	Describes what action is taken when the quantity received tolerance is exceeded
ENFORCE_SHIP_TO_LOCATION_CODE	Describes what action is taken when the receiving location differs from the ship-to location
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	Indicates whether substitute items can be received in place of the ordered items
DAYS_EARLY_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received late
RECEIPT_DAYS_EXCEPTION_CODE	Describes what action is taken when items are received earlier or later than the allowed number of days specified
INVOICE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for invoicing when billed
RECEIVE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for receiving
SHIP_TO_ORGANIZATION_ID	Ship-to organization unique identifier(References HR_ORGANIZATION_UNITS.organization_id)
CREATION_DATE	Standard who column - date when this row was created.
SHIPMENT_NUM	Shipment line number
SOURCE_SHIPMENT_ID	Unique identifier of the planned purchase order shipment(also stored in PO_LINE_LOCATIONS_ALL) that was referenced when creating this scheduled release shipment
SHIPMENT_TYPE	Type of the shipment
CLOSED_CODE	Closure status of the shipment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code (References GL_USSGL_TRANSACTION_CODES.ussgl_transaction_code)
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
RECEIVING_ROUTING_ID	Receipt routing unique identifier(References RCV_ROUTING_HEADERS.routing_header_id)
ACCRUE_ON_RECEIPT_FLAG	Indicates whether items are accrued upon receipt
CLOSED_REASON	Why the shipment is closed
CLOSED_DATE	Date the shipment is closed
CLOSED_BY	Unique identifier of employee who closed the shipment(References HR_EMPLOYEES.employee_id.)
ORG_ID	Organization identifier
QUANTITY_SHIPPED	Quantity shipped
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality

Purchasing - PO_VENDORS	Suppliers
Column Name	Descritpion
VENDOR_ID	Supplier unique identifier
SEGMENT2	Key flexfield segment
INSPECTION_REQUIRED_FLAG	Indicates whether inspection is required or not
RECEIPT_REQUIRED_FLAG	Indicates whether shipment must be received before the invoice is paid
QTY_RCV_TOLERANCE	Quantity received tolerance percentage
QTY_RCV_EXCEPTION_CODE	Enforces, warns, or ignores quantity receiving tolerance
SEGMENT3	Key flexfield segment
ENFORCE_SHIP_TO_LOCATION_CODE	Action to be taken when the receiving location differs from the ship-to location
DAYS_EARLY_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received late
RECEIPT_DAYS_EXCEPTION_CODE	Action to be taken when items are received earlier or later than the allowed number of days specified
RECEIVING_ROUTING_ID	Receipt routing unique identifier
SEGMENT4	Key flexfield segment
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	Indicates whether substitute items can be received in place of the ordered items
ALLOW_UNORDERED_RECEIPTS_FLAG	Indicates whether unordered receipts are allowed
HOLD_UNMATCHED_INVOICES_FLAG	Indicates whether unmatched invoices should be put on hold
EXCLUSIVE_PAYMENT_FLAG	Indicates exclusive payment
AP_TAX_ROUNDING_RULE	Determines the rounding rule for tax values
SEGMENT5	Key flexfield segment
AUTO_TAX_CALC_FLAG	Supplier level where the tax calculation is done
AUTO_TAX_CALC_OVERRIDE	Allows override of tax calculation at supplier site level
AMOUNT_INCLUDES_TAX_FLAG	Do amounts include tax from this supplier?
TAX_VERIFICATION_DATE	Tax verification date
NAME_CONTROL	Name control
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
STATE_REPORTABLE_FLAG	State reportable flag
FEDERAL_REPORTABLE_FLAG	Federal reportable flag
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
CREATION_DATE	Standard who column - date when this row was created.
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
EMPLOYEE_ID	Employee unique identifier if the supplier is an employee
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
OFFSET_VAT_CODE	No longer used
VENDOR_TYPE_LOOKUP_CODE	Supplier type
VAT_REGISTRATION_NUM	VAT registration number
AUTO_CALCULATE_INTEREST_FLAG	Indicates whether interest is to be automatically calculated
VALIDATION_NUMBER	Validation number
EXCLUDE_FREIGHT_FROM_DISCOUNT	Exclude supplier freight from discount amount
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CUSTOMER_NUM	Customer number with the supplier
TAX_REPORTING_NAME	Tax reporting method name
CHECK_DIGITS	Check number used by Payables
BANK_NUMBER	Bank number for Accounts Payable
ALLOW_AWT_FLAG	Indicator of whether Allow Withholding Tax is enabled
AWT_GROUP_ID	Unique identifier for the withholding tax group
ONE_TIME_FLAG	Indicates whether the supplier is a one-time supplier
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
PARENT_VENDOR_ID	Unique identifier of the parent supplier
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
MIN_ORDER_AMOUNT	Minimum purchase order amount
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
SHIP_TO_LOCATION_ID	Default ship-to location unique identifier
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
BILL_TO_LOCATION_ID	Default bill-to location unique identifier
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
EDI_TRANSACTION_HANDLING	Defines whether this supplier is an EDI partner
EDI_PAYMENT_METHOD	How payment is to be made through EDI. Valid methods are ACH, BOP, CWT, FEW, FWT, and SWT.
EDI_PAYMENT_FORMAT	Type of information being transmitted with the funds if using EDI_PAYMENT_METHOD ACH. Valid values are CCD, CCP, CTP, CTX, PPD, and PPP.
EDI_REMITTANCE_METHOD	How remittance advice will be sent to the supplier
SHIP_VIA_LOOKUP_CODE	Default carrier type
EDI_REMITTANCE_INSTRUCTION	Who will send the remittance advice. Valid values are Bank or payables system.
BANK_CHARGE_BEARER	Indicator of whether this supplier bears bank charges
BANK_BRANCH_TYPE	Which list the bank routing number is on. Valid type are ABA, CHIPS, SWIFT and OTHER.
FREIGHT_TERMS_LOOKUP_CODE	Default freight terms type
MATCH_OPTION	Indicator of whether to match invoices to the purchase order or the receipt for this supplier
FUTURE_DATED_PAYMENT_CCID	Accounting Flexfield identifier for the future dated payment account
FOB_LOOKUP_CODE	Default free-on-board type
CREATE_DEBIT_MEMO_FLAG	Indicator of whether a debit memo should be created
OFFSET_TAX_FLAG	Indicator of whether the supplier uses offset taxes
TERMS_ID	Payment terms unique identifier
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SET_OF_BOOKS_ID	Set of Books unique identifier
CREDIT_STATUS_LOOKUP_CODE	No longer used
CREDIT_LIMIT	Not used
ALWAYS_TAKE_DISC_FLAG	Indicator of whether Oracle Payables should always take a discount for the supplier
PAY_DATE_BASIS_LOOKUP_CODE	Type of payment date basis
PAY_GROUP_LOOKUP_CODE	Payment group type
PAYMENT_PRIORITY	Payment priority
INVOICE_CURRENCY_CODE	Default currency unique identifier
PAYMENT_CURRENCY_CODE	Default payment currency unique identifier
INVOICE_AMOUNT_LIMIT	Maximum amount per invoice
VENDOR_NAME	Supplier name
EXCHANGE_DATE_LOOKUP_CODE	No longer used
HOLD_ALL_PAYMENTS_FLAG	Indicates whether Oracle Payables should place all payments for this supplier on hold or not
HOLD_FUTURE_PAYMENTS_FLAG	Indicates whether Oracle Payables should place upapproved payments for this supplier on hold or not
HOLD_REASON	Reason for placing the supplier on payment hold
DISTRIBUTION_SET_ID	Distribution set unique identifier
ACCTS_PAY_CODE_COMBINATION_ID	Unique identifier for the supplier liability account
DISC_LOST_CODE_COMBINATION_ID	No longer used
DISC_TAKEN_CODE_COMBINATION_ID	No longer used
EXPENSE_CODE_COMBINATION_ID	Not used
PREPAY_CODE_COMBINATION_ID	Unique identifier for the general ledger account for prepayment
NUM_1099	Tax identification number
TYPE_1099	Type of 1099
WITHHOLDING_STATUS_LOOKUP_CODE	Withholding status type
WITHHOLDING_START_DATE	Withholding start date
ORGANIZATION_TYPE_LOOKUP_CODE	IRS organization type
VAT_CODE	VAT code
START_DATE_ACTIVE	Key flexfield start date
END_DATE_ACTIVE	Key flexfield end date
VENDOR_NAME_ALT	Alternate supplier name for kana value
MINORITY_GROUP_LOOKUP_CODE	Type of minority-owned business
PAYMENT_METHOD_LOOKUP_CODE	Default payment method type
BANK_ACCOUNT_NAME	Name of the supplier bank account
BANK_ACCOUNT_NUM	Number of the supplier bank account
BANK_NUM	Bank number for the supplier
BANK_ACCOUNT_TYPE	Type of bank account
WOMEN_OWNED_FLAG	Indicates whether the supplier is a woman-owned business
SMALL_BUSINESS_FLAG	Indicates that the supplier is a small business
STANDARD_INDUSTRY_CLASS	Standard industry classification number
SEGMENT1	Key flexfield segment
HOLD_FLAG	Indicator of whether the supplier is on purchasing hold
PURCHASING_HOLD_REASON	Reason for placing the supplier on purchasing hold
HOLD_BY	Unique identifier for the employee who placed the supplier on hold
HOLD_DATE	Date the supplier was placed on purchasing hold
TERMS_DATE_BASIS	Type of invoice payment schedule basis
SUMMARY_FLAG	Key flexfield summary flag
PRICE_TOLERANCE	Not used
ENABLED_FLAG	Key flexfield summary flag

Purchasing - PO_VENDOR_CONTACTS	Supplier contacts
Column Name	Descritpion
VENDOR_CONTACT_ID	Supplier contact unique identifier
MIDDLE_NAME	Contact middle name
FAX_AREA_CODE	Contact Fax area code
FAX	Contact Fax number
LAST_NAME	Contact last name
PREFIX	Prefix
TITLE	Title
MAIL_STOP	Contact mail stop
AREA_CODE	Contact phone number area code
PHONE	Contact phone number
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
VENDOR_SITE_ID	Supplier site unique identifier
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
CREATION_DATE	Standard who column - date when this row was created.
CONTACT_NAME_ALT	Supplier contact alternate name
FIRST_NAME_ALT	Alternate supplier contact's first name
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_NAME_ALT	Alternate supplier contact's last name
DEPARTMENT	Department
INACTIVE_DATE	Inactive date for record
EMAIL_ADDRESS	Contact Email Address
URL	Contact URL
FIRST_NAME	Contact first name
ALT_AREA_CODE	Contact alternate phone number area code
ALT_PHONE	Contact alternate phone number

Purchasing - PO_VENDOR_SITES_ALL	Supplier sites
Column Name	Descritpion
VENDOR_SITE_CODE	Site code name
ALWAYS_TAKE_DISC_FLAG	Indicator of whether Oracle Payables should always take a discount for the supplier
INVOICE_CURRENCY_CODE	Default currency unique identifier
PAYMENT_CURRENCY_CODE	Default payment currency unique identifier
HOLD_ALL_PAYMENTS_FLAG	Indicates whether Oracle Payables should place all payments for this supplier on hold
HOLD_FUTURE_PAYMENTS_FLAG	Indicates whether Oracle Payables should place unapproved invoices for this supplier on hold
HOLD_REASON	Reason that the Supplier Site has been placed on hold
HOLD_UNMATCHED_INVOICES_FLAG	Indicates whether unmatched invoices should be put on hold
AP_TAX_ROUNDING_RULE	Indicates the rounding rule for tax values
AUTO_TAX_CALC_FLAG	Level for automatic tax calculation for supplier
AUTO_TAX_CALC_OVERRIDE	Allows override of tax calculation at supplier site level
VENDOR_SITE_CODE_ALT	Alternate supplier site code for Kana Value
AMOUNT_INCLUDES_TAX_FLAG	Do amounts include tax from this supplier?
EXCLUSIVE_PAYMENT_FLAG	Exclusive payment flag
TAX_REPORTING_SITE_FLAG	Tax reporting site Flag
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
CREATION_DATE	Standard who column - date when this row was created.
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
PURCHASING_SITE_FLAG	Indicates whether you can purchase from this site
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
VALIDATION_NUMBER	Validation number
RFQ_ONLY_SITE_FLAG	Indicates whether you can only send RFQs to this site
EXCLUDE_FREIGHT_FROM_DISCOUNT	Indicates whether the freight amount is to be excluded from the discount
VAT_REGISTRATION_NUM	VAT registration number
OFFSET_VAT_CODE	Offset VAT code
ORG_ID	Organization identifier
CHECK_DIGITS	Check digits for Accounts Payable
PAY_SITE_FLAG	Indicates whether you can send payments to this site
BANK_NUMBER	Bank number for Accounts Payable
ADDRESS_LINE4	Fourth line of address
COUNTY	Supplier site county
ADDRESS_STYLE	Style of address
LANGUAGE	Site language
ATTENTION_AR_FLAG	Indicates whether the payments should be sent to the Accounts Receivable department
ALLOW_AWT_FLAG	Indicator of whether Allow Withholding Tax is enabled
AWT_GROUP_ID	Unique identifier for the withholding tax group
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
ADDRESS_LINE1	First line of supplier address
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
ADDRESS_LINES_ALT	Alternate address line for Kana Value
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
ADDRESS_LINE2	Second line of supplier address
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
EDI_TRANSACTION_HANDLING	ANSI standard code for EDI transaction type
EDI_ID_NUMBER	EDI trading partner number for the supplier site
ADDRESS_LINE3	Third line of supplier address
EDI_PAYMENT_METHOD	How payment is to be made through EDI. Valid method are ACH and BOP.
EDI_PAYMENT_FORMAT	Type of information being transmitted with the funds if using EDI_PATMENT_METHOD ACH. Valid values are CCD, CCP, CTP, CTX, PPD and PPP.
EDI_REMITTANCE_METHOD	How remittance advice will be sent to the supplier
BANK_CHARGE_BEARER	Indicator of whether this supplier site is a bank charge bearer site
EDI_REMITTANCE_INSTRUCTION	Who will send the remittance advice. Valid values are banks or payables systems.
CITY	City name
BANK_BRANCH_TYPE	Which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, and OTHER.
PAY_ON_CODE	When to create an invoice. Currently, the code 'RECEIPT' is used. Future enhancements could include 'DELIVERY'.
DEFAULT_PAY_SITE_ID	Payment site for the site in which the receipt was entered.
PAY_ON_RECEIPT_SUMMARY_CODE	If the PAY_ON_CODE is 'RECEIPT', then this column identifies how to consolidate the receipts to create invoices. Valid values are PAY_SITE, PACKING_SLIP, and RECEIPT.
TP_HEADER_ID	EDI transaction header unique identifier
STATE	State name or abbreviation
ECE_TP_LOCATION_CODE	Trading partner location code for e-Commerce Gateway
PCARD_SITE_FLAG	Indicator of whether the site allows use of procurement cards
ZIP	Postal code
MATCH_OPTION	Indicator of whether to match the invoices to the purchase order or receipt
COUNTRY_OF_ORIGIN_CODE	Code for the country of manufacture
PROVINCE	Province
FUTURE_DATED_PAYMENT_CCID	Accounting Flexfield identifier for the future dated payment account
CREATE_DEBIT_MEMO_FLAG	Indicator of whether a debit memo should be created
COUNTRY	Country name
OFFSET_TAX_FLAG	Indicator of whether offset tax is used
SUPPLIER_NOTIF_METHOD	The preferred Notification Method for the supplier
AREA_CODE	Area code
EMAIL_ADDRESS	Email Address of the supplier Contact
REMITTANCE_EMAIL	The destination e-mail address for remittance information. Populating this field activates the E-mail Remittance Advice feature in Payables
PHONE	Phone number
PRIMARY_PAY_SITE_FLAG	A value of Y indicates that this is the default pay site for the supplier
SHIPPING_CONTROL	Indicator of who is responsible for arranging transportation
CUSTOMER_NUM	Customer number with the supplier site
SELLING_COMPANY_IDENTIFIER	Selling Company Identifier used in generating invoice numbers when gapless invoice numbering is enabled
GAPLESS_INV_NUM_FLAG	Indicates whether gapless invoice numbering is used
SHIP_TO_LOCATION_ID	Default ship-to location unique identifier
DUNS_NUMBER	DUNS Number
BILL_TO_LOCATION_ID	Ship-to location unique identifier
SHIP_VIA_LOOKUP_CODE	Default carrier type
FREIGHT_TERMS_LOOKUP_CODE	Default freight terms type
FOB_LOOKUP_CODE	Default free-on-board type
INACTIVE_DATE	Inactive date for record
FAX	Customer site facsimile number
FAX_AREA_CODE	Customer site
TELEX	Telex number
PAYMENT_METHOD_LOOKUP_CODE	Default payment method type
BANK_ACCOUNT_NAME	Bank account name
BANK_ACCOUNT_NUM	Bank account number
BANK_NUM	Bank number
BANK_ACCOUNT_TYPE	Bank account type
TERMS_DATE_BASIS	Type of invoice payment schedule basis
TOLERANCE_ID	Tolerance Unique Identifier
VENDOR_SITE_ID	Supplier site unique identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CURRENT_CATALOG_NUM	Not currently used
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
VAT_CODE	Value-added tax code
DISTRIBUTION_SET_ID	Distribution set unique identifier
ACCTS_PAY_CODE_COMBINATION_ID	Unique identifier for the supplier liability account
PREPAY_CODE_COMBINATION_ID	Unique identifier for the general ledger account for prepayment
VENDOR_ID	Supplier unique identifier
PAY_GROUP_LOOKUP_CODE	Payment group type
PAYMENT_PRIORITY	Payment priority
TERMS_ID	Payment terms unique identifier
INVOICE_AMOUNT_LIMIT	Maximum amount per invoice
PAY_DATE_BASIS_LOOKUP_CODE	Type of payment date basis

Purchasing - PO_LINES_ARCHIVE_ALL	Archived purchase order lines
Column Name	Descritpion
PO_LINE_ID	Document line unique identifier
ITEM_ID	Item unique identifier
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
ITEM_REVISION	Item revision
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
CATEGORY_ID	Item category unique identifier
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
ITEM_DESCRIPTION	Item description
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
UNIT_MEAS_LOOKUP_CODE	Unit of measure for the quantity ordered
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
EXPIRATION_DATE	Expiration Date For Catalog Lines
QUANTITY_COMMITTED	Quantity agreed for an agreement line
QC_GRADE	Quality control grade wanted for the purchase order line
BASE_UOM	Base unit of measure (UOM) for the item ordered
COMMITTED_AMOUNT	Amount agreed for an agreement line
BASE_QTY	Ordered quantity converted from transaction UOM to base UOM
SECONDARY_UOM	Dual unit of measure for the item ordered
ALLOW_PRICE_OVERRIDE_FLAG	Indicates whether or not you can change the price on releases
SECONDARY_QTY	Converted quantity from base UOM to dual UOM for the item ordered
LINE_REFERENCE_NUM	Audit Trail Reference (needed for 832 EDI transaction)
NOT_TO_EXCEED_PRICE	Price limit that you cannot exceed on a release shipment
PROJECT_ID	Project accounting project unique identifier
TASK_ID	Project accounting task unique identifier
OKE_CONTRACT_HEADER_ID	Contract identifier from Oracle Contracts. (References OKC_K_HEADERS_B.id.)
OKE_CONTRACT_VERSION_ID	Version identifier for contract.
LIST_PRICE_PER_UNIT	List price for the item on the line
TAX_CODE_ID	Unique identifier for the tax code
SECONDARY_UNIT_OF_MEASURE	Secondary unit of measure for the quantity ordered
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
UNIT_PRICE	Unit price for the line
SECONDARY_QUANTITY	Quantity ordered in secondary unit of measure
PREFERRED_GRADE	Preferred quality grade of the item ordered
QUANTITY	Quantity ordered on the line
AUCTION_HEADER_ID	reference to sourcing auction id
AUCTION_DISPLAY_NUMBER	reference to sourcing auction number
UN_NUMBER_ID	UN number unique identifier
AUCTION_LINE_NUMBER	reference to sourcing auction line number
BID_NUMBER	reference to the sourcing bud number
HAZARD_CLASS_ID	Hazard class unique identifier
BID_LINE_NUMBER	reference to sourcing big line number
RETROACTIVE_DATE	Column used to store the timestamp of a retroactive price change
SUPPLIER_REF_NUMBER	Tracking code that links to a specific configuration of an item. Generated by a configuration engine maintained by suppliers.
NOTE_TO_VENDOR	Short note to supplier
CONTRACT_ID	Contract PA reference of a Line. Apply to Standard PO only. Foreign key to PO_HEADER_ID in PO_HEADERS_ALL
JOB_ID	Reference to HR Job for service lines
FROM_HEADER_ID	Quotation unique identifier
AMOUNT	Amount for service lines
START_DATE	Assignment start date for contractor
FROM_LINE_ID	Quotation line unique identifier
CONTRACTOR_FIRST_NAME	Contractor First Name for Service lines
CONTRACTOR_LAST_NAME	Contractor Last Name for Service lines
MIN_ORDER_QUANTITY	Minimum order quantity for a quotation line
ORDER_TYPE_LOOKUP_CODE	Value Basis of the line type
PURCHASE_BASIS	Purchase Basis of the line type
MAX_ORDER_QUANTITY	Maximum order quantity for a quotation line
MATCHING_BASIS	Matching Basis of the line type
SVC_AMOUNT_NOTIF_SENT	Temp Labor lines only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether an Amount Billed Approaching Budget reminder notification has been sent for this line.
QTY_RCV_TOLERANCE	Quantity received tolerance percentage
SVC_COMPLETION_NOTIF_SENT	Temp Labor lines only (i.e. PURCHASE_BASIS='TEMP LABOR'): Indicates whether a Contractor Assignment Nearing Completion reminder notification has been sent for this line.
BASE_UNIT_PRICE	Base Unit Price
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
OVER_TOLERANCE_ERROR_FLAG	Indicates whether you reject receipts exceeding the tolerance or not
MANUAL_PRICE_CHANGE_FLAG	Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise.
RETAINAGE_RATE	Maximum percentage that can be withheld from an invoice as Retainage
MARKET_PRICE	Market price for the item on the line
MAX_RETAINAGE_AMOUNT	The maximum amount that can be withheld as Retainage against a contract line
PROGRESS_PAYMENT_RATE	Percentage applied to the completed work on a financing Pay Item to determine the amount eligible for payment
UNORDERED_FLAG	Indicates whether the line was created from unordered receipts or not
RECOUPMENT_RATE	Maximum percentage of the invoice amount against which previous prepayments can be applied
CLOSED_FLAG	Indicates whether the line is closed or not
CATALOG_NAME	This is to support the replacement of catalogs for CIF format
USER_HOLD_FLAG	Indicates whether the line is on hold or not (Unused since release version 5.0)
SUPPLIER_PART_AUXID	Supplier Part Auxiliary Id
IP_CATEGORY_ID	IP Category Id for GBPA Lines (-2 stored for null values)
CANCEL_FLAG	Indicates whether the line is cancelled or not
LAST_UPDATED_PROGRAM	The program name that last updated the row.
CANCELLED_BY	Unique identifier of the employee who cancelled the line
CANCEL_DATE	Cancellation date
CANCEL_REASON	Cancellation reason provided by employee
FIRM_STATUS_LOOKUP_CODE	Firming status of the line (Unused since release version 7.0)
PO_HEADER_ID	Document header unique identifier
FIRM_DATE	Date the line becomes firmed (Unused since release version 7.0)
VENDOR_PRODUCT_NUM	Supplier product number
CONTRACT_NUM	Contract number referenced on the line. Obsoleted in PO FPJ 11.5.10
TAXABLE_FLAG	Indicates whether the document line is taxable or not
TAX_NAME	Tax code applying to the line
TYPE_1099	1099 type for the purchase order line
CAPITAL_EXPENSE_FLAG	Indicates whether the line is for a capital expense or not
NEGOTIATED_BY_PREPARER_FLAG	Indicates whether the buyer negotiated the price or not
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
LINE_TYPE_ID	Line type unique identifier
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
REFERENCE_NUM	Reference number (Unused since release version 7.0)
LINE_NUM	Line number
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
MIN_RELEASE_AMOUNT	Minimum amount that can be released against a planned purchase order or blanket agreement lines
PRICE_TYPE_LOOKUP_CODE	Price type of the line
REVISION_NUM	Document revision number
PRICE_BREAK_LOOKUP_CODE	Describes the pricing scheme for blanket agreement line price breaks
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LATEST_EXTERNAL_FLAG	Indicates whether this is the latest archived revision
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
CREATION_DATE	Standard who column - date when this row was created.
CLOSED_CODE	Closure status of the line
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CLOSED_BY	Unique identifier of employee who closed the line
CLOSED_DATE	Date the line is closed
CLOSED_REASON	Why the line is closed
TRANSACTION_REASON_CODE	Transaction reason
ORG_ID	Organization identifier

Purchasing - PO_LINES_INTERFACE	Interface table for purchase order lines
Column Name	Descritpion
INTERFACE_LINE_ID	Interface line unique identifier
REQUISITION_LINE_ID	Requisition line unique identifier
SHIP_TO_ORGANIZATION_CODE	Ship-to organization code
SHIP_TO_ORGANIZATION_ID	Ship-to organization unique identifier
SHIP_TO_LOCATION	Ship-to location
SHIP_TO_LOCATION_ID	Ship-to location unique identifier
NEED_BY_DATE	Date the goods are needed by
PROMISED_DATE	Date the goods are promised by
ACCRUE_ON_RECEIPT_FLAG	Indicates whether items are accrued upon receipt
LEAD_TIME	Lead time for the price break (applies to RFQs and quotations only)
LEAD_TIME_UNIT	Unit of measure for the lead time
PRICE_DISCOUNT	Discount percentage for price break (applies to RFQs and quotations only)
FREIGHT_CARRIER	Type of carrier for the RFQ or quotation shipment
FOB	Type of free-on-board terms for the shipment
FREIGHT_TERMS	Type of freight terms for the RFQ or quotation shipment
DOCUMENT_NUM	Document number
EFFECTIVE_DATE	Effective date of the price break (applies to RFQs and quotations only)
EXPIRATION_DATE	Expiration date of the price break (applies to RFQs and quotations only)
FROM_HEADER_ID	Unique identifier of the RFQ used to autocreate the quotation
FROM_LINE_ID	Unique identifier of the RFQ line used to autocreate the quotation line
FROM_LINE_LOCATION_ID	Unique identifier of the RFQ shipment used to autocreate a quotation shipment
LINE_ATTRIBUTE_CATEGORY_LINES	Descriptive flexfield segment
LINE_ATTRIBUTE1	Descriptive flexfield segment
LINE_ATTRIBUTE2	Descriptive flexfield segment
LINE_ATTRIBUTE3	Descriptive flexfield segment
LINE_ATTRIBUTE4	Descriptive flexfield segment
LINE_ATTRIBUTE5	Descriptive flexfield segment
LINE_ATTRIBUTE6	Descriptive flexfield segment
LINE_ATTRIBUTE7	Descriptive flexfield segment
LINE_ATTRIBUTE8	Descriptive flexfield segment
LINE_ATTRIBUTE9	Descriptive flexfield segment
LINE_ATTRIBUTE10	Descriptive flexfield segment
LINE_ATTRIBUTE11	Descriptive flexfield segment
LINE_ATTRIBUTE12	Descriptive flexfield segment
LINE_ATTRIBUTE13	Descriptive flexfield segment
LINE_ATTRIBUTE14	Descriptive flexfield segment
RELEASE_NUM	Release number
LINE_ATTRIBUTE15	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE_CATEGORY	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE1	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE2	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE3	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE4	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE5	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE6	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE7	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE8	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE9	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE10	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE11	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE12	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE13	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE14	Descriptive flexfield segment
SHIPMENT_ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PO_HEADER_ID	Document header unique identifier
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
ORGANIZATION_ID	Needed for 832 EDI transaction
ITEM_ATTRIBUTE_CATEGORY	Needed for 832 EDI transaction
PO_RELEASE_ID	Release unique identifier
ITEM_ATTRIBUTE1	Needed for 832 EDI transaction
ITEM_ATTRIBUTE2	Needed for 832 EDI transaction
ITEM_ATTRIBUTE3	Needed for 832 EDI transaction
ITEM_ATTRIBUTE4	Needed for 832 EDI transaction
ITEM_ATTRIBUTE5	Needed for 832 EDI transaction
SOURCE_SHIPMENT_ID	Source shipment for scheduled releases
ITEM_ATTRIBUTE6	Needed for 832 EDI transaction
ITEM_ATTRIBUTE7	Needed for 832 EDI transaction
ITEM_ATTRIBUTE8	Needed for 832 EDI transaction
ITEM_ATTRIBUTE9	Needed for 832 EDI transaction
ITEM_ATTRIBUTE10	Needed for the 832 EDI transaction
CONTRACT_NUM	Contract number that the line references. Obsoleted in PO FPJ 11.5.10
ITEM_ATTRIBUTE11	Needed for the 832 EDI transaction
ITEM_ATTRIBUTE12	Needed for the 832 EDI transaction
ITEM_ATTRIBUTE13	Needed for the 832 EDI transaction
ITEM_ATTRIBUTE14	Needed for the 832 EDI transaction
ITEM_ATTRIBUTE15	Needed for 832 EDI transaction
INTERFACE_HEADER_ID	Interface header unique identifier
UNIT_WEIGHT	Needed for 832 EDI transaction
WEIGHT_UOM_CODE	Needed for 832 EDI transaction
VOLUME_UOM_CODE	Needed for 832 EDI transaction
UNIT_VOLUME	Needed for 832 EDI transaction
TEMPLATE_ID	Needed for 832 EDI transaction
LINE_TYPE	Line type
TEMPLATE_NAME	Needed for 832 EDI transaction
LINE_REFERENCE_NUM	Needed for 832 EDI transaction
SOURCING_RULE_NAME	Name of the sourcing rule created by purchasing documents open interface
LINE_TYPE_ID	Line type unique identifier
TAX_STATUS_INDICATOR	Tax status such as nonexempt or exempt
PROCESS_CODE	Line status code for price/sales catalog update action (832 EDI transaction), such as NOTIFIED, ACCEPTED, or REJECTED
ITEM	Item
PRICE_CHG_ACCEPT_FLAG	Indicator of whether the price increase in a price/sales catalog update (832 EDI transaction) has been accepted by the buyer
PRICE_BREAK_FLAG	Indicator of whether the record is a price break for the price/sales catalog update (832 EDI transaction). Both line and price break records are stored in this table.
ITEM_ID	Item unique identifier
PRICE_UPDATE_TOLERANCE	Maximum percentage increase allowed to price , without buyer approval in price/sales catalog update (832 EDI transaction) sent by supplier
TAX_USER_OVERRIDE_FLAG	Indicator of whether someone has overridden the default tax
ITEM_REVISION	Item revision
TAX_CODE_ID	Unique identifier for the tax code
NOTE_TO_RECEIVER	Note to deliverer
CATEGORY	Category
OKE_CONTRACT_HEADER_ID	Oracle project contracts unique id for contract number
CATEGORY_ID	Category unique identifier
OKE_CONTRACT_HEADER_NUM	Oracle project contracts contract number
ITEM_DESCRIPTION	Item description
OKE_CONTRACT_VERSION_ID	Oracle project contracts version number
SECONDARY_UNIT_OF_MEASURE	Secondary unit of measure
SECONDARY_UOM_CODE	Abbreviated secondary unit of measure
ACTION	Action to be completed: New or Add
VENDOR_PRODUCT_NUM	Supplier item number
SECONDARY_QUANTITY	Quantity ordered on shipment in secondary unit of measure
PREFERRED_GRADE	Preferred quality grade of the item ordered
UOM_CODE	3-letter unit of measure code
VMI_FLAG	Indicates VMI shipment line with value = 'Y'
AUCTION_HEADER_ID	Auction Unique identifier from pon_auction_headers, Oracle Sourcing
UNIT_OF_MEASURE	Unit of measure
AUCTION_LINE_NUMBER	Auction line number from pon_auction_item_prices, Oracle Sourcing
AUCTION_DISPLAY_NUMBER	This will be the concatenation of auction_header_id_orig_round and auction_round_number for multiround auctions, These columns are referenced from pon_auction_headers
QUANTITY	Quantity ordered on shipment
BID_NUMBER	Bid unique identifier from pon_bid_headers, Oracle sourcing
BID_LINE_NUMBER	Bid line number from pon_bid_item_prices, Oracle Sourcing
CATALOG_NAME	This is to support the replacement of catalogs for CIF format
ORIG_FROM_REQ_FLAG	Indicates whether this interface record is Originated from a req or not, Oracle sourcing would populate this column with 'N' from excess award negotiations and any negotiations which are directly createad in oracle sourcing.
SUPPLIER_PART_AUXID	Supplier Part Auxiliary Id
CONSIGNED_FLAG	Indicates shipment is consigned
IP_CATEGORY_ID	IP Category Id for GBPA Lines (-2 stored for null values)
SUPPLIER_REF_NUMBER	Tracking code that links to a specific configuration of an item. Generated by a configuration engine maintained by suppliers.
CONTRACT_ID	Contract Reference Information of a Line. Links back to a record with type_lookup_code = 'CONTRACT' in PO_HEADERS_ALL
JOB_ID	Reference to the HR Job for service lines
AMOUNT	Amount Ordered for Service line types
JOB_NAME	HR job name for temporary labor lines
CONTRACTOR_FIRST_NAME	Contractor first name
CONTRACTOR_LAST_NAME	Contractor Last Name for Temporary labor lines
DROP_SHIP_FLAG	Indicates whether the Shipment has a backing Sales Order Line.
BASE_UNIT_PRICE	Base Unit Price
TRANSACTION_FLOW_HEADER_ID	Unique transaction flow identifier for relation between purchasing OU and ship to OU. This column is meant for Internal use only
JOB_BUSINESS_GROUP_ID	ID of the business group to which the job title (HR job for services lines) in the interface table belongs. References PER_BUSINESS_GROUPS_PERF.business_group_id.
GROUP_CODE	Indicates the grouping of the requisition lines
COMMITTED_AMOUNT	Amount agreed for an agreement line
JOB_BUSINESS_GROUP_NAME	Name of the business group to which the job title (HR job for services lines) in the interface table belongs. References PER_BUSINESS_GROUPS_PERF.name.
TRACKING_QUANTITY_IND	Indicator to define whether item is tracked in primary unit of measure or also in secondary unoit of measure
MIN_ORDER_QUANTITY	Minimum order quantity for a quotation line
SECONDARY_DEFAULT_IND	Indicator to define the secondary default of the item.
DUAL_UOM_DEVIATION_HIGH	Deviation allowed at the high end of the item
MAX_ORDER_QUANTITY	Maximum order quantity for a quotation line
DUAL_UOM_DEVIATION_LOW	Deviation allowed at the low end of the item
PROCESSING_ID	Identifier for records to be processed in a caertain PDOI run
UNIT_PRICE	Unit price for the line
LINE_LOC_POPULATED_FLAG	Indicate whether user has already added shipment information to PO_LINE_LOCATIONS_INTERFACE table. NULL or 'N' indicates that no record is populated to PO_LINE_LOCATIONS_INTERFACE for this record
IP_CATEGORY_NAME	IP category name
LIST_PRICE_PER_UNIT	List price for the item on the line
RETAINAGE_RATE	Maximum percentage that can be withheld from invoices for Pay Items
MAX_RETAINAGE_AMOUNT	Maximum retainage to withhold for this line
MARKET_PRICE	Market price for the item on the line
PROGRESS_PAYMENT_RATE	Percentage applied to the completed work on a financing Pay Item to determine the amount eligible for payment
RECOUPMENT_RATE	Maximum percentage of the invoice amount against which previous prepayments can be applied
ALLOW_PRICE_OVERRIDE_FLAG	Indicates whether you can change the price on a release
ADVANCE_AMOUNT	Amount that can be paid as an Advance against this line
FILE_LINE_NUMBER	This column is used by catalog upload. The value indicates the record number in the uploaded file.
NOT_TO_EXCEED_PRICE	Price limit that you cannot exceed on a release shipment
PARENT_INTERFACE_LINE_ID	This column is only used by PDOI to indicate the parent interface line. This is populated when the interface line has UPDATE action against another line in the interface table.
FILE_LINE_LANGUAGE	Internal use only. This column is used by catalog upload to indicate the language of the catalog line. Only the columns supported by catalog upload will honor the value of this flag
NEGOTIATED_BY_PREPARER_FLAG	Indicates whether the buyer negotiated the price
UN_NUMBER	UN number
LINE_NUM	Document line number
UN_NUMBER_ID	UN number unique identifier
HAZARD_CLASS	Hazard class
HAZARD_CLASS_ID	Hazard class unique identifier
NOTE_TO_VENDOR	Short note to supplier
TRANSACTION_REASON_CODE	Nature of transaction
TAXABLE_FLAG	Indicates whether line is taxable
TAX_NAME	Tax name
TYPE_1099	1099 type for the purchase order line
CAPITAL_EXPENSE_FLAG	Indicates whether the line is for a capital expense
PO_LINE_ID	Document line unique identifier
INSPECTION_REQUIRED_FLAG	Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG	Indicates whether shipment must be received before the invoice is paid
PAYMENT_TERMS	Payment terms
TERMS_ID	Payment terms unique identifier
PRICE_TYPE	Price type
MIN_RELEASE_AMOUNT	Minimum release amount for the line
PRICE_BREAK_LOOKUP_CODE	Price break type for blanket agreement line
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
SHIPMENT_NUM	Document shipment number
CLOSED_CODE	Close status
LINE_LOCATION_ID	Document shipment unique identifier
CLOSED_REASON	Close reason
CLOSED_DATE	Close date
CLOSED_BY	This is the user id of the person who closed the document
INVOICE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for invoicing when billed
RECEIVE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for receiving
FIRM_FLAG	Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application
DAYS_EARLY_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received late
SHIPMENT_TYPE	Type of shipment
ENFORCE_SHIP_TO_LOCATION_CODE	Describes what action is taken when the receiving location differs from the ship-to location
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	Indicates whether substitute items can be received in place of the ordered items
RECEIVING_ROUTING	Routing
RECEIVING_ROUTING_ID	Routing unique identifier
QTY_RCV_TOLERANCE	Maximum over-receipt tolerance percentage
OVER_TOLERANCE_ERROR_FLAG	Percentage tolerance within which a shipment is automatically closed for invoicing when billed
QTY_RCV_EXCEPTION_CODE	Action to be taken when the quantity received tolerance is exceeded
RECEIPT_DAYS_EXCEPTION_CODE	Action to be taken when items are received earlier or later than the allowed number of days specified

Purchasing - PO_LINE_LOCATIONS_ARCHIVE_ALL	Archived purchase order shipments
Column Name	Descritpion
LINE_LOCATION_ID	Document shipment schedule unique identifier
QUANTITY_RECEIVED	Quantity received, up until today
INVOICE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for invoicing when billed
RECEIVE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for receiving
ACCRUE_ON_RECEIPT_FLAG	Indicates whether items are accrued upon receipt
CLOSED_BY	Unique identifier of employee who closed the shipment
QUANTITY_ACCEPTED	Quantity accepted after inspection, up until today
CLOSED_DATE	Date the shipment is closed
CLOSED_REASON	Describes why shipment is closed
CLOSED_FLAG	No longer used
ORG_ID	Organization identifier
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
QUANTITY_REJECTED	Quantity rejected after inspection, up until today
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
QUANTITY_BILLED	Quantity invoiced to date by Oracle Payables
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
QUANTITY_CANCELLED	Quantity cancelled
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
UNIT_MEAS_LOOKUP_CODE	Price break quantity unit of measure
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
PO_RELEASE_ID	Release unique identifier for a release shipment
QUANTITY_SHIPPED	Quantity shipped
TAX_USER_OVERRIDE_FLAG	Indicator of whether someone overrode the default tax
SHIP_TO_LOCATION_ID	Unique identifier for the ship-to location
MATCH_OPTION	Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt
TAX_CODE_ID	Unique identifier for the tax code
SHIP_VIA_LOOKUP_CODE	Type of carrier for the RFQ or quotation shipment
CHANGE_PROMISED_DATE_REASON	Reason for changing the promised-by date
COUNTRY_OF_ORIGIN_CODE	Country of manufacture for this shipment
SECONDARY_UNIT_OF_MEASURE	Secondary unit of measure of the item ordered
NEED_BY_DATE	Need-by Date for the shipment schedule
SECONDARY_QUANTITY	Ordered quantity in secondary unit of measure
PREFERRED_GRADE	Preferred quality grade of the item ordered
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
PROMISED_DATE	Supplier promised delivery date
SECONDARY_QUANTITY_RECEIVED	Quantity received till date in secondary unit of measure
CALCULATE_TAX_FLAG	Indicator of whether tax needs to be calculated
SECONDARY_QUANTITY_ACCEPTED	Quantity accepted till date in secondary unit of measure
LAST_ACCEPT_DATE	Latest acceptable receipt date for the shipment
SECONDARY_QUANTITY_REJECTED	Quantity rejected till date in secondary unit of measure
SECONDARY_QUANTITY_CANCELLED	Quantity cancelled till date in secondary unit of measure
PRICE_OVERRIDE	Order shipment price or price break for blanket purchase orders, RFQs and quotations
NOTE_TO_RECEIVER	Shipment level Note to receiver, which would hold the note to receiver info coming from req lines.
CONSIGNED_FLAG	Consigned Flag
SUPPLIER_ORDER_LINE_NUMBER	Used to store the supplier change order number
ENCUMBERED_FLAG	Indicates whether the shipment is encumbered
AMOUNT	Amount for service lines
AMOUNT_RECEIVED	Amount Received
ENCUMBERED_DATE	Date of encumbrance for the shipment
AMOUNT_BILLED	Amount Billed
AMOUNT_CANCELLED	amount Cancelled
UNENCUMBERED_QUANTITY	Encumbered quantity to date (Unused since release version 7.0)
AMOUNT_ACCEPTED	Amount Accepted
AMOUNT_REJECTED	Amount Rejected
FOB_LOOKUP_CODE	Type of free-on-board terms for the shipment
VMI_FLAG	Indicates VMI shipment line with value = 'Y'
FREIGHT_TERMS_LOOKUP_CODE	Type of freight terms for the shipment
RETROACTIVE_DATE	Column used to store the date of a retroactive price change
TAXABLE_FLAG	Indicates whether the shipment is taxable
TAX_NAME	Tax code for the shipment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ESTIMATED_TAX_AMOUNT	Estimated tax amount for the purchase order shipment (Unused since release version 6.0)
FROM_HEADER_ID	Unique identifier of the RFQ used to autocreate the quotation
DROP_SHIP_FLAG	Indicates whether the Shipment has a backing Sales Order Line.
SALES_ORDER_UPDATE_DATE	The date/time when any of referenced data elements on the backing Sales Order Line is updated.
FROM_LINE_ID	Unique identifier of the RFQ line used to autocreate the quotation line
TRANSACTION_FLOW_HEADER_ID	Transaction flow header identifier
FINAL_MATCH_FLAG	This flag indicates if the shipment is finally matched by AP invoice.
FROM_LINE_LOCATION_ID	Unique identifier of the RFQ shipment used to autocreate a quotation shipment
MANUAL_PRICE_CHANGE_FLAG	Only for Blanket Release shipments: Y if the user has manually entered a price overriding the Blanket Agreement price, N or null otherwise.
SHIPMENT_CLOSED_DATE	Date when the Shipment is closed for both Receiving and Invoice
START_DATE	Effective date of the price break (applies to RFQs and quotations only)
CLOSED_FOR_RECEIVING_DATE	Date when the Shipment is closed for Receiving
CLOSED_FOR_INVOICE_DATE	Date when the Shipment is closed for Invoice
END_DATE	Expiration date of the price break information (applies to RFQs and quotations only)
SECONDARY_QUANTITY_SHIPPED	Quantity in the secondary unit of measure shipped till date
VALUE_BASIS	Value basis of the line location
LEAD_TIME	Lead time for the price break (applies to RFQs and quotations only)
MATCHING_BASIS	Matching basis of the line location
PAYMENT_TYPE	Pay Item type
LEAD_TIME_UNIT	Unit of measure for the lead time
DESCRIPTION	Pay Item description
PRICE_DISCOUNT	Discount percentage for price break (applies to RFQs and quotations only)
WORK_APPROVER_ID	FND User ID of the Pay Item's Work Confirmation Owner
BID_PAYMENT_ID	References the Bid Pay Item if it was negotiated in Sourcing
TERMS_ID	Payment terms unique identifier
QUANTITY_FINANCED	For Financing Pay Items, the number of units which have been pre-paid
AMOUNT_FINANCED	For Advances or Financing Pay Items, the amount which has been pre-paid
PO_HEADER_ID	Document header unique identifier
APPROVED_FLAG	Indicates whether the shipment is approved
QUANTITY_RECOUPED	For Financing Pay Items, the number of units for which prepayments have been liquidated
AMOUNT_RECOUPED	For Advances or Financing Pay Items, the amount of the prepayments which has been liquidated
APPROVED_DATE	Approval date for shipment (Unused since release version 6.0)
RETAINAGE_WITHHELD_AMOUNT	The total amount withheld as Retainage against this Pay Item
RETAINAGE_RELEASED_AMOUNT	The amount of Retainage released for this Pay Item
CLOSED_CODE	Closure status of the shipment
OUTSOURCED_ASSEMBLY	This column identifies whether the item is a shikyu item or not
AMOUNT_SHIPPED	Amount of Work Confirmation pending for Approval
CANCEL_FLAG	Indicates whether the shipment is cancelled
CANCELLED_BY	Unique identifier of the employee who cancelled the shipment
CANCEL_DATE	Cancellation date
CANCEL_REASON	Cancellation reason provided by the employee
FIRM_STATUS_LOOKUP_CODE	Indicates whether the shipment is firmed
FIRM_DATE	Date the shipment becomes firmed
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
PO_LINE_ID	Document line unique identifier
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
UNIT_OF_MEASURE_CLASS	Unit of measure class (Unused since release version 7.0)
ENCUMBER_NOW	Indicates whether the shipment should be encumbered (Unused since release version 7.0)
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
INSPECTION_REQUIRED_FLAG	Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG	Indicates whether shipment must be received before the invoice is paid
CREATION_DATE	Standard who column - date when this row was created.
QTY_RCV_TOLERANCE	Maximum over-receipt tolerance percentage
QTY_RCV_EXCEPTION_CODE	Describes what action is taken when the quantity received tolerance is exceeded
ENFORCE_SHIP_TO_LOCATION_CODE	Describes what action is taken when the receiving location differs from the ship-to location
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	Indicates whether substitute items can be received in place of the ordered items
DAYS_EARLY_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received late
RECEIPT_DAYS_EXCEPTION_CODE	Describes what action is taken when items are received earlier or later than the allowed number of days specified
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SHIP_TO_ORGANIZATION_ID	Ship-to organization unique identifier
SHIPMENT_NUM	Shipment line number
SOURCE_SHIPMENT_ID	Unique identifier of the planned purchase order shipment that was referenced when creating this scheduled release shipment
SHIPMENT_TYPE	Type of shipment
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
REVISION_NUM	Document revision number
QUANTITY	Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations
LATEST_EXTERNAL_FLAG	Indicates whether this is the latest archived revision
RECEIVING_ROUTING_ID	Receipt routing unique identifier
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).

Purchasing - PO_LINE_TYPES_B	Line types
Column Name	Descritpion
LINE_TYPE_ID	Line type unique identifier
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CATEGORY_ID	Item class
UNIT_OF_MEASURE	Default unit of measure
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
UNIT_PRICE	Default unit price
RECEIVING_FLAG	Default receipt required flag
INACTIVE_DATE	Inactive date for record
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
OUTSIDE_OPERATION_FLAG	Indicates whether the line type is an outside operation or not
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
RECEIVE_CLOSE_TOLERANCE	Receive close tolerance
ORDER_TYPE_LOOKUP_CODE	Type of order line
PURCHASE_BASIS	Purchase basis lookup type
MATCHING_BASIS	Matching basis lookup type

Purchasing - PO_LINE_TYPES_TL	Translated line types
Column Name	Descritpion
LINE_TYPE_ID	Line type unique identifier
LANGUAGE	Language to which you are translating
SOURCE_LANG	Language from which you are translating
DESCRIPTION	Description
LINE_TYPE	Document line type
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Purchasing - PO_LOCATION_ASSOCIATIONS	Location associations to customers and customer sites
Column Name	Descritpion
LOCATION_ID	Location unique identifier
ORGANIZATION_ID	Organization unique identifier
SUBINVENTORY	Subinventory name (not currently used)
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
LAST_UPDATE_DATE	Standard Who column
VENDOR_ID	Supplier unique identifier
VENDOR_SITE_ID	Supplier site unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield segment
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard Who column
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CREATION_DATE	Standard Who column
CREATED_BY	Standard Who column
CUSTOMER_ID	Customer unique identifier
ADDRESS_ID	Address unique identifier
SITE_USE_ID	Site use type identifier

Purchasing - PO_MASSCANCEL_INCLUDES_ALL	MassCancel rules
Column Name	Descritpion
NAME	Masscancel batch name
SEGMENT1_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT2_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT2_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT3_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT3_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT4_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT4_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT5_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT5_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT6_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
SEGMENT6_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT7_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT7_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT8_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT8_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT9_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT9_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT10_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT10_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT11_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SEGMENT11_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT12_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT12_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT13_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT13_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT14_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT14_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT15_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT15_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT16_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
INCLUDE_LOW	Low accounting flexfield value for the range
SEGMENT16_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT17_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT17_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT18_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT18_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT19_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT19_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT20_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT20_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT21_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
INCLUDE_HIGH	High accounting flexfield value for the range
SEGMENT21_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT22_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT22_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT23_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT23_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT24_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT24_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT25_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT25_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT26_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SEGMENT26_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT27_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT27_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT28_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT28_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT29_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT29_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
SEGMENT30_LOW	Minimum value for the corresponding segment of the Accounting Flexfield
SEGMENT30_HIGH	Maximum value for the corresponding segment of the Accounting Flexfield
CREATION_DATE	Standard who column - date when this row was created.
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
ORG_ID	Organization identifier
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
SEGMENT1_LOW	Minimum value for the corresponding segment of the Accounting Flexfield

Purchasing - PO_MASSCANCEL_INTERIM	MassCancel temporary table
Column Name	Descritpion
NAME	Name of the masscancel batch
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
OBJECT_CREATION_DATE	Creation date for the document
CANNOT_CANCEL_REASON	Reason why the document distribution cannot be cancelled
AUTHORIZATION_STATUS	Authorization status of the document
CURRENCY_CODE	Currency code unique identifier
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
OBJECT_TYPE	Document type
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
PO_VENDOR_ID	Supplier unique identifier
ONLINE_REPORT_ID	Unique identifier of online report. Used only for purchase orders.
OBJECT_ID	Document unique identifier
CANCEL_REQS_ON_PO_CANCEL_FLAG	Indicates whether the backing requisition line(s) of a cancelled purchase order should be cancelled as well
OBJECT_NUMBER	Document number
DISTRIBUTIONS_INCLUDED	Unique identifier of the purchase order or requisition distribution
FULLY_IN_RANGE_FLAG	Indicates whether all distributions on the document fall within a MassCancel range
DEFAULT_CANCEL_FLAG	Indicates whether MassCancel should cancel the document
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.

Purchasing - PO_MC_DISTRIBUTIONS	Multiple Reporting Currencies (MRC) sub-table of PO_DISTRIBUTIONS_ALL
Column Name	Descritpion
SET_OF_BOOKS_ID	Set of Books identifier
PO_DISTRIBUTION_ID	Document distribution unique identifier
RATE_DATE	Conversion date for the exchange rate
RATE	Currency conversion rate used to convert the transactional currency amount to reporting currency amount
ENCUMBERED_AMOUNT	Encumbered amount for the distribution
UNENCUMBERED_AMOUNT	Amount unencumbered on the distribution

Purchasing - PO_MC_HEADERS	MRC sub-table of PO_HEADERS
Column Name	Descritpion
SET_OF_BOOKS_ID	Set of Books identifier
PO_HEADER_ID	Document header identifier
RATE_TYPE	Conversion type for the exchange rate
RATE_DATE	Conversion date for the exchange rate
RATE	Currency conversion rate used to convert the transactional currency amount to reporting currency amount

Purchasing - PO_NOTES	No longer used
Column Name	Descritpion
PO_NOTE_ID	Note unique identifier
NOTE	Note text
DOCUMENT_ID	Document unique identifier
APP_SOURCE_VERSION	Used for Release 10SC and Release 11 attachment feature
START_DATE_ACTIVE	Key flexfield start date
END_DATE_ACTIVE	Key flexfield end date
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
CREATION_DATE	Standard who column - date when this row was created.
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
TITLE	Note title
USAGE_ID	Note usage unique identifier
NOTE_TYPE	Note type

Purchasing - PO_NOTE_ATTRIBUTES	Note attributes
Column Name	Descritpion
NOTE_ATTRIBUTE	Note attribute name
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DESCRIPTION	Description for the attribute
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).

Purchasing - PO_NOTE_REFERENCES	Document/notes references
Column Name	Descritpion
PO_NOTE_REFERENCE_ID	Note reference unique identifier
FOREIGN_ID	Value of the unique identifier of the note owner
SEQUENCE_NUM	Sequence of the note
STORAGE_TYPE	Unused
ATTACHED_DOC_ID	Used for Release 10SC and Release 11 attachment feature
APP_SOURCE_VERSION	Used for Release 10SC and Release 11 attachment feature
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
CREATION_DATE	Standard who column - date when this row was created.
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PO_NOTE_ID	Note unique identifier
TABLE_NAME	Table where the note owner is stored
COLUMN_NAME	Name of the column where the unique identifier of the note owner is stored

Purchasing - PO_NOTIFICATIONS_ALL	Notifications
Column Name	Descritpion
EMPLOYEE_ID	Employee unique identifier
ACTION_LOOKUP_CODE	Action type
START_DATE_ACTIVE	Key flexfield start date
END_DATE_ACTIVE	Key flexfield end date
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
OBJECT_TYPE_LOOKUP_CODE	Document type
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
ORG_ID	Organization identifier
INSERTED_BY_FND	Identify processed notifications
OBJECT_ID	Document unique identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
OBJECT_CREATION_DATE	Creation date for the document

Purchasing - PO_NOTIFICATION_CONTROLS	Blanket agreement and planned purchase order notification controls
Column Name	Descritpion
NOTIFICATION_ID	Notification control unique identifier
NOTIFICATION_CONDITION_CODE	Notification type
NOTIFICATION_QTY_PERCENTAGE	Notification percentage of document total
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PO_HEADER_ID	Blanket, planned and contract purchase order header unique identifier
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
START_DATE_ACTIVE	Effective date of the notification
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
END_DATE_ACTIVE	Expiration date of the notification
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
NOTIFICATION_AMOUNT	Notification amount of document total

Purchasing - PO_ONLINE_REPORT_TEXT	Online report errors
Column Name	Descritpion
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
TEXT_LINE	Online report message
LINE_NUM	Requisition or purchase order line that message references
SHIPMENT_NUM	Purchase orders shipment that message references
DISTRIBUTION_NUM	Requisition or purchase order distribution that message references
ONLINE_REPORT_ID	Online report unique identifier
TRANSACTION_LEVEL	No longer used
QUANTITY	No longer used
TRANSACTION_ID	No longer used
TRANSACTION_DATE	No longer used
SEQUENCE	Sequence of the online report message
TRANSACTION_TYPE	No longer used
TRANSACTION_UOM	No longer used
TRANSACTION_LOCATION	No longer used
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
MESSAGE_TYPE	Indicates whether this message is a warning ('W') or an error ('E' or null).
SHOW_IN_PSA_FLAG	show in psa flag
SEGMENT1	Key flexfield segment
DISTRIBUTION_TYPE	Distribution Type
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Purchasing - PO_POSITION_CONTROLS_ALL	Job/organization and position controls
Column Name	Descritpion
POSITION_ID	Position unique identifier
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
JOB_ID	Job unique identifier
ORGANIZATION_ID	Organization unique identifier
START_DATE	Effective date of the position control
CONTROL_GROUP_ID	Control group unique identifier
END_DATE	Termination date of the position control
CONTROL_FUNCTION_ID	Control function unique identifier
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ORG_ID	Organization identifier
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Purchasing - PO_PURGE_PO_LIST	Purchase order candidates for purging
Column Name	Descritpion
PO_HEADER_ID	Candidate purchase order unique identifier
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
PURGE_NAME	Name of the purge process
DOUBLE_CHECK_FLAG	Indicates whether or not the purchase order is still purgeable during confirmation
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).

Purchasing - PO_PURGE_RECEIPT_LIST	Receiving candidates list for purge process. Temporary table.
Column Name	Descritpion
REQUISITION_HEADER_ID	Requisition header unique identifier
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
REQUEST_ID	Standard Who column
PURGE_NAME	Name of the purge process
DOUBLE_CHECK_FLAG	Indicates whether or not the receipt is still purgeable during confirmation
SHIPMENT_LINE_ID	Receipt shipment line unique identifier
PO_HEADER_ID	PO header unique identifier

Purchasing - PO_PURGE_REQ_LIST	Requisition candidates for purging
Column Name	Descritpion
REQUISITION_HEADER_ID	Candidate requisition header unique identifier
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
PURGE_NAME	Name of the purge process
DOUBLE_CHECK_FLAG	Indicates whether or not the requisition is still purgeable during confirmation
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).

Purchasing - PO_PURGE_VENDOR_LIST	Supplier candidates for purging
Column Name	Descritpion
VENDOR_ID	Candidate supplier unique identifier
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
PURGE_NAME	Name of the purge process
DOUBLE_CHECK_FLAG	Indicates whether or not the supplier is still purgeable during confirmation
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).

Purchasing - PO_QUALITY_CODES	Quality inspection codes
Column Name	Descritpion
CODE	Quality code unique identifier
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
RANKING	Quality ranking value
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DESCRIPTION	Description for the quality code
INACTIVE_DATE	Inactive date for record

Purchasing - PO_QUOTATION_APPROVALS_ALL	Quotation approvals
Column Name	Descritpion
QUOTATION_APPROVAL_ID	Approval unique identifier
APPROVER_ID	Unique identifier of the employee who approved the quotation
COMMENTS	Comments associated with approval
START_DATE_ACTIVE	Key flexfield start date
END_DATE_ACTIVE	Key flexfield end date
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
LINE_LOCATION_ID	Document shipment schedule unique identifier
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
ORG_ID	Organization identifier
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
APPROVAL_TYPE	Type of approval
APPROVAL_REASON	Justification for approval

Purchasing - PO_RELATED_TEMPLATES	Not used in Release 11i
Column Name	Descritpion
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
EXPRESS_NAME	Requisition template name
RELATED_EXPRESS_NAME	Related requisition template name
RELATIONSHIP_TYPE	Type of relationship
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Purchasing - PO_RELEASES_ALL	Purchase order releases
Column Name	Descritpion
RELEASE_NUM	Release number
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
AGENT_ID	Buyer unique identifier
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
RELEASE_DATE	Date of the release
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
WF_ITEM_TYPE	Approval workflow item type
WF_ITEM_KEY	Approval workflow item key
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PCARD_ID	Unique identifier for the procurement card used for the order
PAY_ON_CODE	Indicator of whether the release will be paid upon receipt
CREATION_DATE	Standard who column - date when this row was created.
XML_FLAG	Indicator for the delivery option of the PO document is through XML or not. Y if so.
XML_SEND_DATE	The XML document generation date, if XML delivery option is chosen.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
XML_CHANGE_SEND_DATE	The change XML document generation date, if XML delivery option is chosen.
CONSIGNED_CONSUMPTION_FLAG	Flag indicates that the PO Release is a consumption advice
REVISION_NUM	Release revision number
CBC_ACCOUNTING_DATE	Column used to store the accounting action date for dual budgetary controls
CHANGE_REQUESTED_BY	Column used to store the change request userid
REVISED_DATE	Last revision date
SHIPPING_CONTROL	Indicator of who is responsible for arranging transportation
CHANGE_SUMMARY	Description of changes made. This information is entered by the Buyer when submitting the document for approval and may be used in generating an amendment document.
APPROVED_FLAG	Indicates whether the release is approved or not
VENDOR_ORDER_NUM	Supplier's order number for release
DOCUMENT_CREATION_METHOD	Document Creation Method - Autocreate, Enter PO, copy, etc...
APPROVED_DATE	Date the release was approved
SUBMIT_DATE	Date when release was first submitted for approval
TAX_ATTRIBUTE_UPDATE_CODE	Keeps track of create/update actions on this entity
PRINT_COUNT	Number of times the release was printed
COMM_REV_NUM
OTM_STATUS_CODE	Status of OTM Communication
PRINTED_DATE	Date the release was printed
OTM_RECOVERY_FLAG	Flag to indicate whether OTM communication needs to be recovered
ACCEPTANCE_REQUIRED_FLAG	Indicates whether an acceptance is required or not
ACCEPTANCE_DUE_DATE	Date the acceptance is due
HOLD_BY	Unique identifier of the employee who placed the release on hold (Unused since release version 8.0)
HOLD_DATE	Date the release was placed on hold (Unused since release version 8.0)
HOLD_REASON	Reason the release was placed on hold (Unused since release version 8.0)
HOLD_FLAG	Indicates whether the release is on hold or not
CANCEL_FLAG	Indicates whether the release is cancelled or not
CANCELLED_BY	Unique identifier of the employee who cancelled the release
CANCEL_DATE	Date the release was cancelled
CANCEL_REASON	Reason for cancellation
FIRM_STATUS_LOOKUP_CODE	Firm status
FIRM_DATE	Date the release becomes firmed
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
AUTHORIZATION_STATUS	Authorization status of the release
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
PO_RELEASE_ID	Release unique identifier
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CLOSED_CODE	Describes the closure status of the release
FROZEN_FLAG	Indicates whether the release is frozen or not
RELEASE_TYPE	Describes whether release is for a blanket or planned purchase order
NOTE_TO_VENDOR	Note to the supplier
ORG_ID	Organization identifier
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
EDI_PROCESSED_FLAG	This flag is used by e-Commerce Gateway to identify documents that have been sent via EDI. This flag is updated to Y by the e-Commerce Gateway extraction routines.
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
PO_HEADER_ID	Document header unique identifier
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality

Purchasing - PO_RELEASES_ARCHIVE_ALL	Archived releases
Column Name	Descritpion
PO_RELEASE_ID	Release unique identifier
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
REVISION_NUM	Release revision number
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
PCARD_ID	Unique identifier for the procurement card used on the release
REVISED_DATE	Last revision date
WF_ITEM_TYPE	Approval workflow item type
WF_ITEM_KEY	Approval workflow item key
APPROVED_FLAG	Indicates whether the release is approved
PAY_ON_CODE	Indicator of whether the release will be paid upon receipt.
XML_FLAG	Indicator if the user has chosen XML delivery option for the release PO document. Y if selected.
APPROVED_DATE	Date the release was approved
XML_SEND_DATE	Date on which XML was generated for a new release, if XML delivery was chosen.
XML_CHANGE_SEND_DATE	Date on which XML was generated for the last changed release, if XML delivery was chosen.
PRINT_COUNT	Number of times the release was printed
CONSIGNED_CONSUMPTION_FLAG	Consigned Consumption Flag
SHIPPING_CONTROL	Indicator of who is responsible for arranging transportation
PRINTED_DATE	Date the release was printed
CHANGE_SUMMARY	Description of changes made. This information is entered by the Buyer when submitting the document for approval and may be used in generating an amendment document.
CBC_ACCOUNTING_DATE	Column used to store the accounting action date for dual budgetary controls
ACCEPTANCE_REQUIRED_FLAG	Indicates whether an acceptance is required
CHANGE_REQUESTED_BY	Column used to store the change request userid
ACCEPTANCE_DUE_DATE	Date the acceptance is due
VENDOR_ORDER_NUM	Supplier's order number for release
DOCUMENT_CREATION_METHOD	Document Creation Method - Autocreate, Enter PO, copy, etc...
HOLD_BY	No longer used
SUBMIT_DATE	Date when release was first submitted for approval
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
HOLD_DATE	No longer used
HOLD_REASON	No longer used
HOLD_FLAG	Indicates whether the release is on hold
CANCEL_FLAG	Indicates whether the release is cancelled
CANCELLED_BY	Unique identifier of the employee who cancelled the release
CANCEL_DATE	Date the release was cancelled
CANCEL_REASON	Reason for cancellation
FIRM_STATUS_LOOKUP_CODE	Firm status
FIRM_DATE	Date the release becomes firmed
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
PO_HEADER_ID	Document header unique identifier
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LATEST_EXTERNAL_FLAG	Indicates whether this is the latest archived revision
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
RELEASE_NUM	Release number
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
CLOSED_CODE	Describes the closure status of the release
FROZEN_FLAG	Indicates whether the document is frozen
AGENT_ID	Buyer unique identifier
RELEASE_TYPE	Describes whether release is for a blanket or planned purchase order
AUTHORIZATION_STATUS	Authorization status of the release
NOTE_TO_VENDOR	Note to the supplier
ORG_ID	Organization identifier
EDI_PROCESSED_FLAG	This flag is used by e-Commerce Gateway to identify documents that have been sent via EDI. This flag is updated to Y by the e-Commerce Gateway extraction routines.
RELEASE_DATE	Date of the release
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
CREATION_DATE	Standard who column - date when this row was created.
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality

Purchasing - PO_REQEXPRESS_HEADERS_ALL	Template headers for express requisitions
Column Name	Descritpion
EXPRESS_NAME	Template unique identifier name
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
CREATION_DATE	Standard who column - date when this row was created.
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
ORG_ID	Organization identifier
RESERVE_PO_NUMBER	Standard Who Column
TYPE_LOOKUP_CODE	Requisition type
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DESCRIPTION	Description for template
INACTIVE_DATE	Inactive date for record

Purchasing - PO_REQEXPRESS_LINES_ALL	Template lines for express requisitions
Column Name	Descritpion
EXPRESS_NAME	Template unique identifier and name
ITEM_ID	Item unique identifier
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
AMOUNT	Amount
LINE_TYPE_ID	Line type
SUGGESTED_QUANTITY	The suggested quantity to default into the shopping cart during requisition creation process.
NEGOTIATED_BY_PREPARER_FLAG	Indicates whether the requisition line has a price negotiated by buyer
ITEM_REVISION	Item revision
IP_CATEGORY_ID	IP Category Id. (-2 stored for null value)
LAST_UPDATED_PROGRAM	The program name that last updated the row.
CATEGORY_ID	Item category unique identifier
UNIT_MEAS_LOOKUP_CODE	Unit of measure
UNIT_PRICE	Unit price in functional currency
SUGGESTED_VENDOR_ID	Suggested supplier unique identifier
SUGGESTED_VENDOR_SITE_ID	Suggested supplier site unique identifier
SUGGESTED_VENDOR_CONTACT_ID	Suggested supplier contact unique identifier
SEQUENCE_NUM	Template line number
SUGGESTED_VENDOR_PRODUCT_CODE	Suggested supplier product number
SUGGESTED_BUYER_ID	Suggested buyer unique identifier
RFQ_REQUIRED_FLAG	Indicates whether an RFQ is required prior to placement on a purchase order
VENDOR_SOURCE_CONTEXT	Supplier source descriptive flexfield context column
SOURCE_TYPE_CODE	Source type of item
SOURCE_ORGANIZATION_ID	Inventory source organization unique identifier
SOURCE_SUBINVENTORY	Inventory source subinventory name
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
CREATION_DATE	Standard who column - date when this row was created.
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
ITEM_DESCRIPTION	Item description
ORG_ID	Organization identifier
PO_HEADER_ID	Source document header unique identifier
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
PO_LINE_ID	Source document line unique identifier
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality

Purchasing - PO_REQUISITIONS_INTERFACE_ALL	Requisition Import interface table
Column Name	Descritpion
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
HEADER_ATTRIBUTE10	Descriptive flexfield segment
HEADER_ATTRIBUTE11	Descriptive flexfield segment
HEADER_ATTRIBUTE12	Descriptive flexfield segment
HEADER_ATTRIBUTE13	Descriptive flexfield segment
HEADER_ATTRIBUTE14	Descriptive flexfield segment
URGENT_FLAG	Indicates whether the requisition is urgent or not
HEADER_ATTRIBUTE15	Descriptive flexfield segment
RFQ_REQUIRED_FLAG	Indicates whether an RFQ is required prior to placement on a purchase order
JUSTIFICATION	Purchase justification
NOTE_TO_BUYER	Note to buyer
NOTE_TO_RECEIVER	Note to receiver
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
ITEM_ID	Item unique identifier
ITEM_SEGMENT1	Key flexfield segment
ITEM_SEGMENT2	Key flexfield segment
ITEM_SEGMENT3	Key flexfield segment
ITEM_SEGMENT4	Key flexfield segment
ITEM_SEGMENT5	Key flexfield segment
ITEM_SEGMENT6	Key flexfield segment
ITEM_SEGMENT7	Key flexfield segment
ITEM_SEGMENT8	Key flexfield segment
ITEM_SEGMENT9	Key flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ITEM_SEGMENT10	Key flexfield segment
ITEM_SEGMENT11	Key flexfield segment
ITEM_SEGMENT12	Key flexfield segment
ITEM_SEGMENT13	Key flexfield segment
ITEM_SEGMENT14	Key flexfield segment
ITEM_SEGMENT15	Key flexfield segment
ITEM_SEGMENT16	Key flexfield segment
ITEM_SEGMENT17	Key flexfield segment
ITEM_SEGMENT18	Key flexfield segment
ITEM_SEGMENT19	Key flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ITEM_SEGMENT20	Key flexfield segment
ITEM_REVISION	Item revision
CHARGE_ACCOUNT_ID	Unique Identifier for the General Ledger charge account
CHARGE_ACCOUNT_SEGMENT1	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT2	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT3	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT4	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT5	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT6	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT7	Key flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CHARGE_ACCOUNT_SEGMENT8	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT9	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT10	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT11	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT12	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT13	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT14	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT15	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT16	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT17	Key flexfield segment
TRANSACTION_ID	Transaction unique identifier
CREATION_DATE	Standard who column - date when this row was created.
CHARGE_ACCOUNT_SEGMENT18	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT19	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT20	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT21	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT22	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT23	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT24	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT25	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT26	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT27	Key flexfield segment
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CHARGE_ACCOUNT_SEGMENT28	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT29	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT30	Key flexfield segment
CATEGORY_ID	Category unique identifier
CATEGORY_SEGMENT1	Key flexfield segment
CATEGORY_SEGMENT2	Key flexfield segment
CATEGORY_SEGMENT3	Key flexfield segment
CATEGORY_SEGMENT4	Key flexfield segment
CATEGORY_SEGMENT5	Key flexfield segment
CATEGORY_SEGMENT6	Key flexfield segment
INTERFACE_SOURCE_CODE	Interface transaction source
CATEGORY_SEGMENT7	Key flexfield segment
CATEGORY_SEGMENT8	Key flexfield segment
CATEGORY_SEGMENT9	Key flexfield segment
CATEGORY_SEGMENT10	Key flexfield segment
CATEGORY_SEGMENT11	Key flexfield segment
CATEGORY_SEGMENT12	Key flexfield segment
CATEGORY_SEGMENT13	Key flexfield segment
CATEGORY_SEGMENT14	Key flexfield segment
CATEGORY_SEGMENT15	Key flexfield segment
CATEGORY_SEGMENT16	Key flexfield segment
INTERFACE_SOURCE_LINE_ID	Interface transaction reference column
CATEGORY_SEGMENT17	Key flexfield segment
CATEGORY_SEGMENT18	Key flexfield segment
CATEGORY_SEGMENT19	Key flexfield segment
CATEGORY_SEGMENT20	Key flexfield segment
UNIT_OF_MEASURE	Unit of measure
UOM_CODE	3-letter unit of measure code
LINE_TYPE_ID	Requisition line type unique identifier
LINE_TYPE	Requisition line type name
UN_NUMBER_ID	UN number unique identifier
UN_NUMBER	UN number
SOURCE_TYPE_CODE	Requisition source
HAZARD_CLASS_ID	Hazard class unique identifier
HAZARD_CLASS	Hazard class
MUST_USE_SUGG_VENDOR_FLAG	Unused since release 8.0
REFERENCE_NUM	Reference number
WIP_ENTITY_ID	WIP job or repetitive assembly identifier
WIP_LINE_ID	WIP line identifier
WIP_OPERATION_SEQ_NUM	WIP operation sequence number within a routing
WIP_RESOURCE_SEQ_NUM	WIP resource sequence number
WIP_REPETITIVE_SCHEDULE_ID	WIP repetitive schedule identifier
PROJECT_NUM	Project accounting project number
REQUISITION_HEADER_ID	Requisition header unique identifier
TASK_NUM	Project accounting task number
EXPENDITURE_TYPE	Project accounting expenditure type
SOURCE_ORGANIZATION_ID	Source organization unique identifier
SOURCE_ORGANIZATION_CODE	3-letter source organization code
SOURCE_SUBINVENTORY	Source subinventory
DESTINATION_ORGANIZATION_ID	Destination organization unique identifier
DESTINATION_ORGANIZATION_CODE	3-letter destination organization code
DESTINATION_SUBINVENTORY	Destination subinventory
DELIVER_TO_LOCATION_ID	Deliver-to-location unique identifier
DELIVER_TO_LOCATION_CODE	Deliver-to-location code
REQUISITION_LINE_ID	Requisition line unique identifier
DELIVER_TO_REQUESTOR_ID	Requester unique identifier
DELIVER_TO_REQUESTOR_NAME	Requester name
SUGGESTED_BUYER_ID	Suggested buyer unique identifier
SUGGESTED_BUYER_NAME	Suggested buyer name
SUGGESTED_VENDOR_NAME	Suggested supplier name
SUGGESTED_VENDOR_ID	Suggested supplier unique identifier
SUGGESTED_VENDOR_SITE	Suggested supplier site
SUGGESTED_VENDOR_SITE_ID	Suggested supplier site unique identifier
SUGGESTED_VENDOR_CONTACT	Suggested supplier contact
SUGGESTED_VENDOR_CONTACT_ID	Suggested supplier contact unique identifier
REQ_DISTRIBUTION_ID	Requisition distribution unique identifier
SUGGESTED_VENDOR_PHONE	Suggested supplier phone number
SUGGESTED_VENDOR_ITEM_NUM	Suggested supplier item number
LINE_ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
LINE_ATTRIBUTE1	Descriptive flexfield segment
LINE_ATTRIBUTE2	Descriptive flexfield segment
LINE_ATTRIBUTE3	Descriptive flexfield segment
LINE_ATTRIBUTE4	Descriptive flexfield segment
LINE_ATTRIBUTE5	Descriptive flexfield segment
LINE_ATTRIBUTE6	Descriptive flexfield segment
LINE_ATTRIBUTE7	Descriptive flexfield segment
REQUISITION_TYPE	Type of requisition
LINE_ATTRIBUTE8	Descriptive flexfield segment
LINE_ATTRIBUTE9	Descriptive flexfield segment
LINE_ATTRIBUTE10	Descriptive flexfield segment
LINE_ATTRIBUTE11	Descriptive flexfield segment
LINE_ATTRIBUTE12	Descriptive flexfield segment
LINE_ATTRIBUTE13	Descriptive flexfield segment
LINE_ATTRIBUTE14	Descriptive flexfield segment
LINE_ATTRIBUTE15	Descriptive flexfield segment
NEED_BY_DATE	Date the requisition is needed internally
NOTE1_ID	Note unique identifier
DESTINATION_TYPE_CODE	Requisition destination type
NOTE2_ID	Note unique identifier
NOTE3_ID	Note unique identifier
NOTE4_ID	Note unique identifier
NOTE5_ID	Note unique identifier
NOTE6_ID	Note unique identifier
NOTE7_ID	Note unique identifier
NOTE8_ID	Note unique identifier
NOTE9_ID	Note unique identifier
NOTE10_ID	Note unique identifier
NOTE1_TITLE	Note title
PROCESS_FLAG	Transaction processing state
ITEM_DESCRIPTION	Item description
NOTE2_TITLE	Note title
NOTE3_TITLE	Note title
NOTE4_TITLE	Note title
NOTE5_TITLE	Note title
NOTE6_TITLE	Note title
NOTE7_TITLE	Note title
NOTE8_TITLE	Note title
NOTE9_TITLE	Note title
NOTE10_TITLE	Note title
GL_DATE	Date the distribution should be encumbered
QUANTITY	Quantity ordered
DIST_ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
DISTRIBUTION_ATTRIBUTE1	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE2	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE3	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE4	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE5	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE6	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE7	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE8	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE9	Descriptive flexfield segment
UNIT_PRICE	Unit price
DISTRIBUTION_ATTRIBUTE10	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE11	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE12	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE13	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE14	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE15	Descriptive flexfield segment
PREPARER_NAME	Preparer name
BOM_RESOURCE_ID	BOM resource unique identifier
ACCRUAL_ACCOUNT_ID	Unique identifier for the General Ledger accrual account
AUTHORIZATION_STATUS	Authorization status type
VARIANCE_ACCOUNT_ID	Unique identifier for the General Ledger variance account
BUDGET_ACCOUNT_ID	Unique identifier for the General Ledger budget account
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
CURRENCY_CODE	Currency unique identifier
CURRENCY_UNIT_PRICE	Currency unit price
RATE	Exchange rate
RATE_DATE	Exchange rate date
RATE_TYPE	Exchange rate type
PREVENT_ENCUMBRANCE_FLAG	Indicator of whether or not encumbrance is needed
BATCH_ID	Import batch identifier
AUTOSOURCE_DOC_HEADER_ID	Source document header unique identifier
AUTOSOURCE_DOC_LINE_NUM	Source document line number
PROJECT_ACCOUNTING_CONTEXT	Project accounting descriptive flexfield context column
EXPENDITURE_ORGANIZATION_ID	Project accounting expenditure organization unique identifier
PROJECT_ID	Project accounting project unique identifier
TASK_ID	Project accounting task unique identifier
END_ITEM_UNIT_NUMBER	Project Manufacturing end item unit number
EXPENDITURE_ITEM_DATE	Project accounting expenditure item date
DOCUMENT_TYPE_CODE	Document type
GROUP_CODE	Import grouping code
ORG_ID	Organization identifier
TRANSACTION_REASON_CODE	Transaction reason
ALLOCATION_TYPE	Method of allocation across distributions. Can be PERCENT.
ALLOCATION_VALUE	Allocation Split Value
MULTI_DISTRIBUTIONS	Indicator of whether this requisition should have multiple distributions
REQ_DIST_SEQUENCE_ID	Foreign key to PO_REQ_DIST_INTERFACE table
KANBAN_CARD_ID	Primary key for the kanban card
EMERGENCY_PO_NUM	Purchase order number reserved in advance for an emergency requisition
AWARD_ID	Award identifier
DELETE_ENABLED_FLAG	Unused since release version 7.0
TAX_CODE_ID	Unique identifier for the tax
OKE_CONTRACT_HEADER_ID	Oracle Project Contract Number unique identifier
UPDATE_ENABLED_FLAG	Unused since release version 7.0
OKE_CONTRACT_NUM	Oracle Project Contract Number
OKE_CONTRACT_VERSION_ID	Oracle Project Contract Version Number
APPROVER_ID	Approver unique identifier
OKE_CONTRACT_LINE_ID	Oracle Project Contract Line Unique identifier
OKE_CONTRACT_LINE_NUM	Oracle Project Contract Line Number
OKE_CONTRACT_DELIVERABLE_ID	Oracle Project Contract Deliverable Unique identifier
APPROVER_NAME	Approver name
OKE_CONTRACT_DELIVERABLE_NUM	Oracle Project Contract Deliverable Number
SECONDARY_UNIT_OF_MEASURE	Secondary unit of measure
SECONDARY_UOM_CODE	Abbreviated Secondary unit of meaure
SECONDARY_QUANTITY	Quantity ordered in secondary unit of measure
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
APPROVAL_PATH_ID	Approval path unique identifier
PREFERRED_GRADE	Preferred quality grade of the item ordered
VMI_FLAG	Indicates VMI requisition with value = 'Y'
TAX_USER_OVERRIDE_FLAG	To capture whether the Tax Code was populated by the user. It is used internally to store the status od the tax overide
AMOUNT	Amount for the Fixed Priced Service requisition lines
NOTE_TO_APPROVER	Note to approver
CURRENCY_AMOUNT	Amount for the Fixed Priced Service requisition lines in foreign currency
SHIP_METHOD	Ship method (References WSH_CARRIER_SERVICES.ship_method_code.)
ESTIMATED_PICKUP_DATE	Estimated pickup date.
PREPARER_ID	Preparer unique identifier
BASE_UNIT_PRICE	Base Unit Price
NEGOTIATED_BY_PREPARER_FLAG	Flag to Indicate if the price is negotiated by the preparer
AUTOSOURCE_FLAG	Controls automatic sourcing
TAX_NAME	Overrides the system defaulted tax classification during tax calculation
REQ_NUMBER_SEGMENT1	Requisition number
REQ_NUMBER_SEGMENT2	Key flexfield segment
REQ_NUMBER_SEGMENT3	Key flexfield segment
REQ_NUMBER_SEGMENT4	Key flexfield segment
REQ_NUMBER_SEGMENT5	Key flexfield segment
HEADER_DESCRIPTION	Header description
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
HEADER_ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
HEADER_ATTRIBUTE1	Descriptive flexfield segment
HEADER_ATTRIBUTE2	Descriptive flexfield segment
HEADER_ATTRIBUTE3	Descriptive flexfield segment
HEADER_ATTRIBUTE4	Descriptive flexfield segment
HEADER_ATTRIBUTE5	Descriptive flexfield segment
HEADER_ATTRIBUTE6	Descriptive flexfield segment
HEADER_ATTRIBUTE7	Descriptive flexfield segment
HEADER_ATTRIBUTE8	Descriptive flexfield segment
HEADER_ATTRIBUTE9	Descriptive flexfield segment

Purchasing - PO_REQUISITION_HEADERS_ALL	Requisition headers
Column Name	Descritpion
REQUISITION_HEADER_ID	Requisition header unique identifier
SEGMENT4	Key flexfield segment
CHANGE_PENDING_FLAG	Indicates whether requisition is in Change Order process or not
ACTIVE_SHOPPING_CART_FLAG	Set to 'Y' to indicate that this requisition should be shown to the user when he/she logs into iProcurement.
SEGMENT5	Key flexfield segment
CONTRACTOR_STATUS	The status of the resource finalization process for temp labor reqs
CONTRACTOR_REQUISITION_FLAG	Flag to indicate whether the requisition is a regular req or a temp labor req
START_DATE_ACTIVE	Key flexfield start date
SUPPLIER_NOTIFIED_FLAG	Indicates if a notification is sent to the supplier
EMERGENCY_PO_ORG_ID	The org_id of the operating unit from which the emergency_po_num is derived. This field completely qualifies the emergency_po_num field. (Starting FPJ, it is possible to create an emergency PO in another operating unit.)
END_DATE_ACTIVE	Key flexfield end date
APPROVED_DATE	Date when Requisition is submitted for approval
TAX_ATTRIBUTE_UPDATE_CODE	Keeps track of create/update actions on this entity
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
FIRST_APPROVER_ID	Unique identifier of the first approver in the approval hierarchy.
FIRST_POSITION_ID	Unique identifier of the first position in the position hierarchy.
CREATION_DATE	Standard who column - date when this row was created.
FEDERAL_FLAG
CONFORMED_HEADER_ID
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REVISION_NUM
AMENDMENT_TYPE
DESCRIPTION	Description for requisition
AMENDMENT_STATUS
AMENDMENT_REASON
AUTHORIZATION_STATUS	Authorization status type
UDA_TEMPLATE_ID
UDA_TEMPLATE_DATE
NOTE_TO_AUTHORIZER	Note to approver (Unused since release 8.0)
CLM_ISSUING_OFFICE
CLM_COTR_OFFICE
PREPARER_ID	Unique identifier of the employee who prepared the requisition
TYPE_LOOKUP_CODE	Requisition type
CLM_COTR_CONTACT
CLM_PRIORITY_CODE
TRANSFERRED_TO_OE_FLAG	Indicates whether an internal requisition has been transferred to Order Management
SUGGESTED_AWARD_NO
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ON_LINE_FLAG	Unused since release 7.0
PRELIMINARY_RESEARCH_FLAG	Unused since release 7.0
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
RESEARCH_COMPLETE_FLAG	Unused since release 7.0
PREPARER_FINISHED_FLAG	Unused since release 7.0
PREPARER_FINISHED_DATE	Unused since release 7.0
AGENT_RETURN_FLAG	Unused since release 7.0
AGENT_RETURN_NOTE	Unused since release 7.0
CANCEL_FLAG	Unused since release 7.0
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
SEGMENT1	Key flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
SUMMARY_FLAG	Key flexfield summary flag
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
INTERFACE_SOURCE_CODE	Source of requisition from Requisition Import
ENABLED_FLAG	Key flexfield enabled flag
INTERFACE_SOURCE_LINE_ID	Source requisition line identifier from Requisition Import
CLOSED_CODE	Close status
ORG_ID	Organization identifier
WF_ITEM_TYPE	Approval workflow item type
WF_ITEM_KEY	Approval workflow item key
SEGMENT2	Key flexfield segment
EMERGENCY_PO_NUM	Purchase order number reserved in advance for an emergency requisition
PCARD_ID	Unique dentifer for procurement card used for the order
SEGMENT3	Key flexfield segment
APPS_SOURCE_CODE	Application source code, indicating the creation method for the requisition
CBC_ACCOUNTING_DATE	Column used to store the accounting action date for dual budgetary controls

Purchasing - PO_REQUISITION_LINES_ALL	Requisition lines
Column Name	Descritpion
REQUISITION_LINE_ID	Requisition line unique identifier
DELIVER_TO_LOCATION_ID	Deliver-to location unique identifier
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
CLOSED_REASON	Close reason
TO_PERSON_ID	Requester unique identifier
CLOSED_DATE	Close date
TRANSACTION_REASON_CODE	Transaction reason
QUANTITY_RECEIVED	Quantity received
SOURCE_REQ_LINE_ID	Source requisition line identifier
ORG_ID	Organization identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
SOURCE_TYPE_CODE	Requisition source type of item
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
CREATION_DATE	Standard who column - date when this row was created.
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
KANBAN_CARD_ID	Primary key for the Kanban Card
CATALOG_TYPE	Catalog type
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CATALOG_SOURCE	Catalog source
MANUFACTURER_ID	Manufacturer unique identifier
ITEM_ID	Item unique identifier
MANUFACTURER_NAME	Manufacturer name
MANUFACTURER_PART_NUMBER	Manufacturer part number
ITEM_REVISION	Item revision
REQUESTER_EMAIL	Requester e-mail address
REQUESTER_FAX	Requester facsimile number
REQUISITION_HEADER_ID	Requisition header unique identifier
QUANTITY_DELIVERED	Quantity delivered to date
REQUESTER_PHONE	Requester phone number
UNSPSC_CODE	Standard Product and Service Code
SUGGESTED_BUYER_ID	Suggested buyer unique identifier
OTHER_CATEGORY_CODE	Other category code
SUPPLIER_DUNS	Data Universal Numbering System Code
ENCUMBERED_FLAG	Indicates whether the distribution is encumbered. When encumbrance is not enabled, this column will be used as an internal flag.
TAX_STATUS_INDICATOR	Tax status
PCARD_FLAG	Indicator that this line is ordered using a procurement card
RFQ_REQUIRED_FLAG	Indicates whether an RFQ is required prior to placement on a purchase order
NEW_SUPPLIER_FLAG	Indicator that this is a new supplier
AUTO_RECEIVE_FLAG	Allow auto-receiving
NEED_BY_DATE	Date the requisition is needed internally
TAX_USER_OVERRIDE_FLAG	Indicator of whether someone overrode the default tax
LINE_LOCATION_ID	Document shipment schedule unique identifier
TAX_CODE_ID	Unique identifier for the tax code
NOTE_TO_VENDOR	Note to supplier
MODIFIED_BY_AGENT_FLAG	Indicates whether a buyer modified this line or not
OKE_CONTRACT_VERSION_ID	Stores the contract version number
OKE_CONTRACT_HEADER_ID	Stores the header id of a contract
PARENT_REQ_LINE_ID	Unique identifier of the parent requisition line for a modified requisition line
ITEM_SOURCE_ID	Used only for the reference to item sources table
SUPPLIER_REF_NUMBER	Reference Number for the Supplier
JUSTIFICATION	Purchase justification
SECONDARY_UNIT_OF_MEASURE	Secondary unit of measure of the requisition item
SECONDARY_QUANTITY	Quantity ordered in secondary unit of measure
NOTE_TO_AGENT	Note to buyer
PREFERRED_GRADE	Preferred quality grade of the item ordered
SECONDARY_QUANTITY_RECEIVED	Quantity received till date in secondary unit of measure
LINE_NUM	Line number
NOTE_TO_RECEIVER	Note to deliverer
SECONDARY_QUANTITY_CANCELLED	Quantity cancelled in secondary unit of measure
VMI_FLAG	Indicates VMI requisition with value = 'Y'
PURCHASING_AGENT_ID	Unique identifier of the buyer who modified the requisition line
AUCTION_HEADER_ID	Reference to sourcing auction id
AUCTION_DISPLAY_NUMBER	Reference to sourcing auction number
DOCUMENT_TYPE_CODE	Source document type
AUCTION_LINE_NUMBER	reference to sourcing auction line number
REQS_IN_POOL_FLAG	Flag to indicate if the requisitions are available for PO creation
BLANKET_PO_HEADER_ID	Suggested source blanket agreement or catalog quotation header unique identifier
BID_NUMBER	Reference to sourcing bid number
BID_LINE_NUMBER	Reference to sourcing bid line number
BLANKET_PO_LINE_NUM	Suggested source blanket agreement or catalog quotation line number
NONCAT_TEMPLATE_ID	Non-Catalog Request template identifier
SUGGESTED_VENDOR_CONTACT_FAX	Supplier contact fax number
CURRENCY_CODE	Unique identifier for the currency
SUGGESTED_VENDOR_CONTACT_EMAIL	Supplier email contact information
AMOUNT	Amount on the req line
RATE_TYPE	Currency conversion rate type
CURRENCY_AMOUNT	Foreign currency amount on the req line
LABOR_REQ_LINE_ID	Stored the referenced temp labor requisition line id for an expence line
RATE_DATE	Currency conversion rate date
JOB_ID	Reference to the HR Job
JOB_LONG_DESCRIPTION	Job Detailed Description
RATE	Currency conversion rate
CONTRACTOR_STATUS	Resource finalization status for temp labor req lines
CURRENCY_UNIT_PRICE	Foreign currency unit price
CONTACT_INFORMATION	Job Contact Information
SUGGESTED_SUPPLIER_FLAG	Flag to indicate if the supplier is from an ASL or user suggested
LINE_TYPE_ID	Line type
SUGGESTED_VENDOR_NAME	Suggested supplier name
CANDIDATE_SCREENING_REQD_FLAG	Flag to indicate if candidate screening is required
CANDIDATE_FIRST_NAME	First Name of the Candidate
SUGGESTED_VENDOR_LOCATION	Suggested supplier site name
CANDIDATE_LAST_NAME	Last Name of the Candidate
ASSIGNMENT_END_DATE	End date for the candidate assignment
OVERTIME_ALLOWED_FLAG	Flag to indicate if overtime is allowed
SUGGESTED_VENDOR_CONTACT	Suggested supplier contact name
CONTRACTOR_REQUISITION_FLAG	Indicates if the req is a temp labor req
DROP_SHIP_FLAG	Indicates whether the Shipment has a backing Sales Order Line.
SUGGESTED_VENDOR_PHONE	Suggested supplier phone number
ASSIGNMENT_START_DATE	Assignment start date for the candidate
ORDER_TYPE_LOOKUP_CODE	Value Basis of the line type
SUGGESTED_VENDOR_PRODUCT_CODE	Suggested supplier product number
PURCHASE_BASIS	Value Basis of the line type
MATCHING_BASIS	Matching Basis of the line type
UN_NUMBER_ID	UN number unique identifier
NEGOTIATED_BY_PREPARER_FLAG	Indicates whether price has been negotiated by buyer
SHIP_METHOD	Ship method (References WSH_CARRIER_SERVICES.ship_method_code.)
HAZARD_CLASS_ID	Hazard class unique identifier
ESTIMATED_PICKUP_DATE	Estimated pickup date.
SUPPLIER_NOTIFIED_FOR_CANCEL	Indicates whether a cancellation notification has been sent to the supplier for this requisition line.
MUST_USE_SUGG_VENDOR_FLAG	Unused since release 8.0
BASE_UNIT_PRICE	Base Unit Price
REFERENCE_NUM	Reference number
AT_SOURCING_FLAG	Whether or not this requisition line is part of an active sourcing negotiation. If 'Y', the req line is part of an active negotiation in Oracle Sourcing. If 'N' or 'NULL', the requisition line is not part of an active negotation in Oracle
TAX_ATTRIBUTE_UPDATE_CODE	Keeps track of create/update actions on this entity
ON_RFQ_FLAG	Indicates whether the requisition line was placed on an RFQ
TAX_NAME	Tax Name
CATEGORY_ID	Item category unique identifier
URGENT_FLAG	Indicates whether the requisition is urgent or not
TRANSFERRED_TO_OE_FLAG	Indicates whether an internal requisition line has been transferred to order management
CONFORMED_LINE_ID
CANCEL_FLAG	Indicates whether the requisition is cancelled or not
AMENDMENT_TYPE
AMENDMENT_STATUS
SOURCE_ORGANIZATION_ID	Inventory source organization unique identifier
LINE_NUM_DISPLAY
GROUP_LINE_ID
SOURCE_SUBINVENTORY	Inventory source subinventory name
CLM_INFO_FLAG
CLM_OPTION_INDICATOR
DESTINATION_TYPE_CODE	Destination type
CLM_BASE_LINE_NUM
CLM_OPTION_NUM
DESTINATION_ORGANIZATION_ID	Destination organization unique identifier
CLM_OPTION_FROM_DATE
CLM_OPTION_TO_DATE
DESTINATION_SUBINVENTORY	Destination subinventory name
CLM_FUNDED_FLAG
UDA_TEMPLATE_ID
QUANTITY_CANCELLED	Quantity cancelled
CONTRACT_TYPE
COST_CONSTRAINT
CANCEL_DATE	Cancel date
AMENDMENT_RESPONSE_REASON
CLM_PERIOD_PERF_START_DATE
CANCEL_REASON	Cancel reason
CLM_PERIOD_PERF_END_DATE
CLM_EXTENDED_ITEM_DESCRIPTION
ITEM_DESCRIPTION	Item description
CLOSED_CODE	Close status
CLM_OPTION_EXERCISED
AGENT_RETURN_NOTE	Unused since release 7.0
CHANGED_AFTER_RESEARCH_FLAG	Unused since release 7.0
VENDOR_ID	Supplier unique identifier
VENDOR_SITE_ID	Supplier site unique identifier
VENDOR_CONTACT_ID	Supplier contact unique identifier
RESEARCH_AGENT_ID	Unused since release 7.0
ON_LINE_FLAG	Unused since release 7.0
WIP_ENTITY_ID	WIP job or repetitive assembly identifier
UNIT_MEAS_LOOKUP_CODE	Unit of measure
WIP_LINE_ID	WIP line identifier
WIP_REPETITIVE_SCHEDULE_ID	WIP repetitive schedule identifier
WIP_OPERATION_SEQ_NUM	WIP operation sequence number within a routing
WIP_RESOURCE_SEQ_NUM	WIP resource sequence number
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
DESTINATION_CONTEXT	Destination descriptive flexfield context column
INVENTORY_SOURCE_CONTEXT	Inventory source descriptive flexfield context column
VENDOR_SOURCE_CONTEXT	Supplier source descriptive flexfield context column
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
UNIT_PRICE	Unit price in functional currency
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
QUANTITY	Quantity ordered
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
BOM_RESOURCE_ID	BOM resource unique identifier
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).

Purchasing - PO_REQ_DISTRIBUTIONS_ALL	Requisition distributions
Column Name	Descritpion
DISTRIBUTION_ID	Requisition distribution unique identifier
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
TAX_RECOVERY_OVERRIDE_FLAG	Indicator of whether tax recovery should be used
OKE_CONTRACT_LINE_ID	Stores the line id of a contract
ENCUMBERED_FLAG	Indicates whether the distribution is encumbered or not
OKE_CONTRACT_DELIVERABLE_ID	Stores the deliverable id corresponding to the contract
REQ_LINE_AMOUNT	Amount on the req line
GL_ENCUMBERED_DATE	Date the distribution was encumbered
REQ_LINE_CURRENCY_AMOUNT	Foreign Currency Amount on the requisition distribution
REQ_AWARD_ID	Award ID corresponding to the award on the requisition distribution. References GMS_AWARDS_ALL.award_id.
GL_ENCUMBERED_PERIOD_NAME	Period in which the distribution was encumbered
EVENT_ID	Keeps track of latest SLA event
GL_CANCELLED_DATE	Date the distribution was cancelled
FAILED_FUNDS_LOOKUP_CODE	Type of approval failure for the distribution
ENCUMBERED_AMOUNT	Encumbered amount for distribution
BUDGET_ACCOUNT_ID	Unique identifier for the General Ledger budget account
ACCRUAL_ACCOUNT_ID	Unique identifier for the General Ledger accrual account
VARIANCE_ACCOUNT_ID	Unique identifier for the General Ledger variance account
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
PREVENT_ENCUMBRANCE_FLAG	Indicates whether the distribution requires encumbrance or not
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
REQUISITION_LINE_ID	Requisition line unique identifier
ATTRIBUTE15	Descriptive flexfield segment
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
SET_OF_BOOKS_ID	Set of Books unique identifier
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
PROJECT_ID	Project accounting project unique identifier
TASK_ID	Project accounting task unique identifier
CODE_COMBINATION_ID	Unique identifier for the General Ledger charge account
END_ITEM_UNIT_NUMBER	Project Manufacturing end item unit number
EXPENDITURE_TYPE	Project accounting expenditure type
PROJECT_ACCOUNTING_CONTEXT	Project accounting descriptive flexfield context column
EXPENDITURE_ORGANIZATION_ID	Project accounting expenditure organization unique identifier
GL_CLOSED_DATE	Date the distribution was final-closed
REQ_LINE_QUANTITY	Quantity for the distribution
SOURCE_REQ_DISTRIBUTION_ID	Distribution unique identifier that indicates whether the distribution is encumbered when it is cancelled
DISTRIBUTION_NUM	Distribution number
ALLOCATION_TYPE	Method of allocation across distributions. Can be PERCENT.
ALLOCATION_VALUE	Allocation split value
PROJECT_RELATED_FLAG	Indicates whether the distribution is project related
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
EXPENDITURE_ITEM_DATE	Project accounting expenditure item date
ORG_ID	Organization identifier
AWARD_ID	Award identifier
RECOVERABLE_TAX	Recoverable tax amount
CREATION_DATE	Standard who column - date when this row was created.
NONRECOVERABLE_TAX	Nonrecoverable tax amount
RECOVERY_RATE	Percentage of tax that can be recovered

Purchasing - PO_REQ_DIST_INTERFACE_ALL	Interface table for requisition distributions
Column Name	Descritpion
ACCRUAL_ACCOUNT_ID	Unique identifier for the General Ledger accrual account
CHARGE_ACCOUNT_SEGMENT10	Key flexfield segment
TRANSACTION_ID	Project accounting transaction unique identifier
UPDATE_ENABLED_FLAG	Unused since release 7.0
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
VARIANCE_ACCOUNT_ID	GL variance account unique identifier
CHARGE_ACCOUNT_SEGMENT11	Key flexfield segment
OKE_CONTRACT_LINE_ID	Unique identifier for the project contracts line
CHARGE_ACCOUNT_SEGMENT12	Key flexfield segment
OKE_CONTRACT_LINE_NUM	Project contracts line number
CHARGE_ACCOUNT_SEGMENT13	Key flexfield segment
OKE_CONTRACT_DELIVERABLE_ID	Unique identifier for the project contracts deleverable
CHARGE_ACCOUNT_SEGMENT14	Key flexfield segment
OKE_CONTRACT_DELIVERABLE_NUM	Prject contracts deliverable number
AMOUNT	Amount for fixed price service requisition lines
CHARGE_ACCOUNT_SEGMENT15	Key flexfield segment
CURRENCY_AMOUNT	Amount for fixed price service requisition lines in foreign currency
CHARGE_ACCOUNT_SEGMENT16	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT17	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT18	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT19	Key flexfield segment
ALLOCATION_TYPE	Specifies the method of allocation across distributions. Can be PERCENT.
CHARGE_ACCOUNT_SEGMENT2	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT20	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT21	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT22	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT23	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT24	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT25	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT26	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT27	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT28	Key flexfield segment
ALLOCATION_VALUE	Allocation split value
CHARGE_ACCOUNT_SEGMENT29	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT3	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT30	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT4	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT5	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT6	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT7	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT8	Key flexfield segment
CHARGE_ACCOUNT_SEGMENT9	Key flexfield segment
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
DESTINATION_ORGANIZATION_ID	Destination organization unique identifier
DESTINATION_SUBINVENTORY	Destination subinventory
DESTINATION_TYPE_CODE	Requisition destination type
DISTRIBUTION_ATTRIBUTE1	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE10	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE11	Descriptive flexfield segment
BATCH_ID	Import batch identifier
DISTRIBUTION_ATTRIBUTE12	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE13	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE14	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE15	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE2	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE3	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE4	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE5	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE6	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE7	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE8	Descriptive flexfield segment
DISTRIBUTION_ATTRIBUTE9	Descriptive flexfield segment
DISTRIBUTION_NUMBER	Distribution number
DIST_ATTRIBUTE_CATEGORY	Descriptive flexfield structure defining column
DIST_SEQUENCE_ID	Distribution Sequence unique identifier
EXPENDITURE_ITEM_DATE	Project accounting Expenditure Item date
EXPENDITURE_ORGANIZATION_ID	Project accounting expenditure organization unique identifier
EXPENDITURE_TYPE	Project accounting expenditure type
GL_DATE	Date the distribution should be encumbered
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
BUDGET_ACCOUNT_ID	Unique identifier for the General Ledger budget account
GROUP_CODE	Import grouping code
INTERFACE_SOURCE_CODE	Interface transaction source
INTERFACE_SOURCE_LINE_ID	Interface transaction reference column
ITEM_ID	Item unique identifier
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID	Organization identifier
PREVENT_ENCUMBRANCE_FLAG	Indicates whether distribution should be encumbered
PROCESS_FLAG	Transaction processing state
CHARGE_ACCOUNT_ID	Unique identifier for the General Ledger charge account
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
PROJECT_ACCOUNTING_CONTEXT	Project accounting descriptive flexfield context column
PROJECT_ID	Project accounting unique identifier for the project
PROJECT_NUM	Project accounting project number
QUANTITY	Quantity ordered
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
REQUISITION_HEADER_ID	Requisition header unique identifier
CHARGE_ACCOUNT_SEGMENT1	Key flexfield segment
REQ_NUMBER_SEGMENT1	Requisition number
REQUISITION_LINE_ID	Requisition line unique identifier
REQ_DISTRIBUTION_ID	Requisition distribution unique identifier
TASK_ID	Project accounting task unique identifier
TASK_NUM	Project accounting task number

Purchasing - PO_RESCHEDULE_INTERFACE	Requisition reschedule interface table
Column Name	Descritpion
LINE_ID	Unique identifier for the requisition line
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
QUANTITY	New quantity for the requisition line
ORIG_QUANTITY	Quantity before reschedule
ORIG_NEED_BY_DATE	Need by date before reschedule
NEED_BY_DATE	New need-by date for the requisition line
AUCTION_HEADER_ID	Reference to sourcing auction number
AUCTION_DISPLAY_NUMBER	Reference to sourcing auction number
PROCESS_ID	Number of the reschedule process that processed the record
SHIP_METHOD	Ship method (References WSH_CARRIER_SERVICES.ship_method_code.)
ESTIMATED_PICKUP_DATE	Estimated pickup date.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Purchasing - PO_RFQ_VENDORS	Suppliers on an RFQ
Column Name	Descritpion
PO_HEADER_ID	Document header unique identifier
VENDOR_CONTACT_ID	Supplier contact unique identifier
PRINT_FLAG	Indicates whether the RFQ should be reprinted for the supplier
PRINT_COUNT	Number of times the RFQ was printed for the supplier
PRINTED_DATE	Date the RFQ was last printed for the supplier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
SEQUENCE_NUM	Number of the supplier in the RFQ list
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
VENDOR_ID	Supplier unique identifier
VENDOR_SITE_ID	Supplier site unique identifier

Purchasing - PO_SUPPLIER_ITEM_CAPACITY	Supplier capacity information
Column Name	Descritpion
ASL_ID	Unique identifier for the Approved Supplier List entry with which the supplier capacity is associated
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
USING_ORGANIZATION_ID	Ship-to organization that is using the supplier capacity information
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
FROM_DATE	Date the supplier capacity becomes effective
TO_DATE	End date for the supplier capacity information
CAPACITY_PER_DAY	Daily supplier capacity
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CAPACITY_ID	Unique identifier for the supplier's capacity
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment

Purchasing - PO_SUPPLIER_ITEM_TOLERANCE	Supplier capacity tolerance information
Column Name	Descritpion
USING_ORGANIZATION_ID	Ship-to organization that is using the tolerance information
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
NUMBER_OF_DAYS	Advance notice in number of days that the supplier needs to meet the exceeded capacity
TOLERANCE	Maximum percentage increase in capacity given the number of days of advance notice
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ASL_ID	Unique identifier for the Approved Supplier List entry with which the tolerance information is associated
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment

Purchasing - PO_SYSTEM_PARAMETERS_ALL	Purchasing options
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
INSPECTION_REQUIRED_FLAG	Default value that indicates whether you require inspection for items you order
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
ENFORCE_PRICE_CHANGE_ALLOWANCE	Indicates whether you enforce the requisition price to purchase order price tolerance during purchase order approval
TAX_FROM_SHIP_TO_LOC_FLAG	Default tax code from ship-to location
TAX_FROM_ITEM_FLAG	Default tax code from the inventory item
TAX_FROM_VENDOR_FLAG	Default tax code from the supplier
TAX_FROM_VENDOR_SITE_FLAG	Default tax code from supplier site
TAX_FROM_SYSTEM_FLAG	Default tax code from Financial Options window
DEFAULT_RATE_TYPE	Default currency rate type for your documents
TAX_HIER_SHIP_TO_LOC	Ship-to location position in tax code defaulting hierarchy
TAX_HIER_ITEM	Item position in the tax code defaulting hierarchy
TAX_HIER_VENDOR	Supplier position in the tax code defaulting hierarchy
TAX_HIER_VENDOR_SITE	Supplier Site position in the tax code defaulting hierarchy
TAX_HIER_SYSTEM	Financial Options in the tax code defaulting hierarchy
TAXABLE_FLAG	Default value that indicates whether your purchases are taxable
CREATE_DEBIT_MEMO_FLAG	Indicator of whether a debit memo should be created
ENFORCE_PRICE_CHANGE_AMOUNT	Indicates whether you enforce the requisition price to purchase order price tolerance during purchase order approval
PRICE_CHANGE_AMOUNT	Price difference amount you allow between requisition and purchase order price
USER_DEFINED_RECEIPT_NUM_CODE	Receipt numbering type
AUTO_OFFSET_METHOD	Automatic offset method; determines how to combine the base account (ex. receiving inspection account) and overlay account (ex. PO distribution charge account) to generate the offset account: GL_ACCOUNT, GL_BALANCING, or null.
PO_OUTPUT_FORMAT	The output format for the PO Communication
MANUAL_RECEIPT_NUM_TYPE	Receipt number type
BUYING_COMPANY_IDENTIFIER	Buying company identifier used in generating invoice numbers when gapless invoice numbering is enabled
GAPLESS_INV_NUM_FLAG	Indicates whether gapless invoice numbering is used
USER_DEFINED_QUOTE_NUM_CODE	Quotation numbering type
MAX_ATTACHMENT_SIZE	Indicates maximum allowed size of ZIP attachment file
SUPPLIER_AUTHORING_ACCEPTANCE	Supplier acceptance level for agreement change
MANUAL_QUOTE_NUM_TYPE	Quotation number type
CAT_ADMIN_AUTHORING_ACCEPTANCE	Catalog Administrator acceptance level for agreement change
EMAIL_ATTACHMENT_FILENAME	Email Attachment File name
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
USER_DEFINED_RFQ_NUM_CODE	RFQ numbering type
ACCEPTANCE_REQUIRED_FLAG	Acceptance Required Flag
MANUAL_RFQ_NUM_TYPE	RFQ number type
USER_DEFINED_PO_NUM_CODE	Purchase order numbering type
MANUAL_PO_NUM_TYPE	Purchase order number type
USER_DEFINED_REQ_NUM_CODE	Requisition numbering type
MANUAL_REQ_NUM_TYPE	Requisition number type
DEFAULT_QUOTE_WARNING_DELAY	Default warning delay for quotations
ENFORCE_BUYER_AUTHORITY_FLAG	No longer used
ENFORCE_BUYER_NAME_FLAG	Indicates whether you allow changing the name of the buyer on a purchase order to any name
ENFORCE_VENDOR_HOLD_FLAG	Indicates whether you enforce supplier holds during purchase order approval
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
NOTIFY_IF_BLANKET_FLAG	Indicates whether you want to notify requesters when a blanket purchase order exists for items they request
RFQ_REQUIRED_FLAG	Default value that indicates whether you require RFQs for requisitions
PO_DOCUMENT_REPORT_ID	No longer used
PO_DOCUMENT_PRINT_FLAG	No longer used
RFQ_DOCUMENT_REPORT_ID	No longer used
RFQ_DOCUMENT_PRINT_FLAG	No longer used
LINE_TYPE_ID	Unique identifier of the line type you use on your documents
NEXT_APPROVER_LOOKUP_CODE	Type of next approver logic
RECEIVING_FLAG	Default value that indicates whether you require receipt for items you order or not
CREATION_DATE	Standard who column - date when this row was created.
ALLOW_ITEM_DESC_UPDATE_FLAG	Default value that indicates whether item descriptions can be updated on document lines
DISPOSITION_WARNING_FLAG	Default value that indicates whether disposition messages are displayed for items
ENFORCE_FULL_LOT_QUANTITIES	Default value that indicates whether full lot quantities are enforced
SECURITY_POSITION_STRUCTURE_ID	Security hierarchy for document types with hierarchy security level
MIN_RELEASE_AMOUNT	Default minimum release amount for blanket and planned purchase orders in functional currency
PRICE_TYPE_LOOKUP_CODE	Default price type for purchase orders
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
NOTIFICATION_WARNING_DELAY	Not currently used
PRICE_BREAK_LOOKUP_CODE	Default price break type for catalog quotations and blanket agreements
INVOICE_CLOSE_CODE	Not currently used
RECEIVE_CLOSE_CODE	Default receiving close point
INVOICE_CLOSE_TOLERANCE	Default invoice close tolerance percent
ACCRUED_CODE_COMBINATION_ID	Unique identifier of the Receipt accrual General Ledger account
RECEIVE_CLOSE_TOLERANCE	Default receiving close tolerance percent
CANCEL_REQS_ON_PO_CANCEL_FLAG	Default value that indicates if a requisition is cancelled when the purchase order is cancelled
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PRICE_CHANGE_ALLOWANCE	Price difference percentage you allow between requisition and purchase order price
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
REQIMPORT_GROUP_BY_CODE	Default Requisition Import group-by method
EXPENSE_ACCRUAL_CODE	Accrual option for expense items
INVENTORY_ACCRUAL_CODE	Accrual option for inventory items
ORDER_TYPE_ID	Order type for internal requisitions
REQ_CAN_AUTHORIZE	No longer used
ORDER_SOURCE_ID	Order source for internal requisitions
SALESREP_ID	Not currently used
TERM_ID	Not currently used
ORG_ID	Organization identifier
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality

Purchasing - PO_UNIQUE_IDENTIFIER_CONT_ALL	Purchase order document number control
Column Name	Descritpion
TABLE_NAME	Name of the table for the unique identifier
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
ORG_ID	Organization identifier
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
CURRENT_MAX_UNIQUE_IDENTIFIER	Current value for the unique identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).

Purchasing - PO_UN_NUMBERS_B	United Nations numbers
Column Name	Descritpion
UN_NUMBER_ID	Unique identifier for the United Nations number
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
HAZARD_CLASS_ID	Hazard class unique identifier
INACTIVE_DATE	Inactive date for record
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Purchasing - PO_USAGES	Note usages
Column Name	Descritpion
USAGE_ID	Unique identifier for the note usage
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
USAGE_NAME	Name of the usage
DESCRIPTION	Description of the usage

Purchasing - PO_USAGE_ATTRIBUTES	Note usage attributes
Column Name	Descritpion
USAGE_ID	Unique identifier for the note usage
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
NOTE_ATTRIBUTE	Note attribute
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).

Purchasing - PO_VENDOR_LIST_ENTRIES	RFQ supplier list entries
Column Name	Descritpion
VENDOR_LIST_ENTRY_ID	RFQ list entry unique identifier
VENDOR_CONTACT_ID	Supplier contact unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
VENDOR_LIST_HEADER_ID	RFQ list unique identifier
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
VENDOR_ID	Supplier unique identifier
VENDOR_SITE_ID	Supplier site unique identifier

Purchasing - PO_VENDOR_LIST_HEADERS	RFQ supplier list headers
Column Name	Descritpion
VENDOR_LIST_HEADER_ID	RFQ list unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
VENDOR_LIST_NAME	RFQ list name
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
ORG_ID	Operating Unit
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DESCRIPTION	Description for RFQ list
INACTIVE_DATE	Inactive date for record

Purchasing - PO_WF_CANDIDATE_REQ_LINES_TEMP	Temporary table to store requisition lines that can be automatically created using workflow
Column Name	Descritpion
SUGGESTED_BUYER_ID	Suggested buyer unique identifier
SOURCE_DOC_TYPE_CODE	Source document type
SOURCE_DOC_ID	Source document unique identifier
SOURCE_DOC_LINE	Source document line number
SUGGESTED_VENDOR_ID	Suggested supplier unique identifier
GROUP_ID	Allows multiple requisition lines to be processed in groups
SUGGESTED_VENDOR_SITE_ID	Suggested supplier site unique identifier
CURRENCY_CODE	Unique identifier for the currency
RATE_TYPE	Currency conversion rate type
RATE_DATE	Currency conversion rate date
RATE	Currency conversion rate
PROCESS_CODE	Indicates what processing state the requisition line is in
RELEASE_GENERATION_METHOD	Release generation method tied to the approved supplier list for the item
ITEM_ID	Item unique identifier
PCARD_ID	Unique identifer for the procurement card used on the requisition
REQUISITION_HEADER_ID	Requisition header unique identifier
CONTRACT_ID	Identifier for the Contract Id referenced in the requisition
JOB_ID	Reference to the HR job
REQUISITION_LINE_ID	Requisition line unique identifier
LINE_NUM	Line number

Purchasing - PO_UN_NUMBERS_TL	Translated United Nations numbers
Column Name	Descritpion
LANGUAGE	Language to which you are translating
SOURCE_LANG	Language from which you are translating
UN_NUMBER	United Nations number
DESCRIPTION	Description of United Nations number
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
UN_NUMBER_ID	Unique identifier for the United Nations number
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Purchasing - PO_LOCATION_ASSOCIATIONS_ALL	Location associations to customers and customer sites
Column Name	Descritpion
LOCATION_ID	Location unique identifier
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CUSTOMER_ID	Customer unique identifier
ADDRESS_ID	Address unique identifier
SITE_USE_ID	Site use type identifier
ORGANIZATION_ID	Organization unique identifier
SUBINVENTORY	Subinventory name (not currently used)
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
VENDOR_ID	Supplier unique identifier
VENDOR_SITE_ID	Supplier site unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ORG_ID	Organization identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Purchasing - PO_VENDOR_SITES_ALL_EBS	archive for euro business support project
Column Name	Descritpion
VENDOR_SITE_ID	Vendor Site Identifier
EURO_VENDOR_SITE_ID	Euro Vendor Site Identifier
EURO_VENDOR_ID	Euro Vendor Identifier
SECURITY_GROUP_ID	Security Group Identifier
VENDOR_SITE_CODE	Vendor Site Code
VENDOR_ID	Vendor Identifier
CREATION_DATE	Creation Date
CREATED_BY	Created By
ORG_ID	Organization Identifier
INVOICE_CURRENCY_CODE	Invoice Currency Code
PAYMENT_CURRENCY_CODE	Payment Currency Code
INVOICE_AMOUNT_LIMIT	Invoice Amount Limit

Purchasing - PO_LINE_LOCATIONS_ALL_EBS	archive for euro business support project
Column Name	Descritpion
LINE_LOCATION_ID	Line Location Identifier
QUANTITY_RECEIVED	Quantity Received
QUANTITY_BILLED	Quantity Billed
QUANTITY_CANCELLED	Quantity Cancelled
UNIT_MEAS_LOOKUP_CODE	Unit Of Measure Lookup Code
PRICE_OVERRIDE	Price Override
EURO_LINE_LOCATION_ID	Euro Line Location Identifier
EURO_PO_LINE_ID	Euro PO Line Identifier
EURO_PO_HEADER_ID	Euro PO Header Identifier
EURO_PO_RELEASE_ID	Euro PO Release Identifier
SOURCE_SHIPMENT_ID	Source Shipment Identifier
PO_LINE_ID	PO Line Identifier
EURO_SOURCE_SHIPMENT_ID	Euro Source Shipment Identifier
SECURITY_GROUP_ID	security group identifier
PO_HEADER_ID	PO Header Identifier
PO_RELEASE_ID	PO Release Identifier
CREATION_DATE	Creation Date
CREATED_BY	Created By
SHIPMENT_TYPE	Shipment Type
ORG_ID	Organization Identifier
QUANTITY	Quantity

Purchasing - PO_RELEASES_ALL_EBS	archive for euro business support project
Column Name	Descritpion
PO_RELEASE_ID	PO Release Identifier
PO_HEADER_ID	PO Header Identifier
RELEASE_NUM	Release Number
CREATION_DATE	Creation Date
CREATED_BY	Created By
ORG_ID	Organization Identifier
EURO_PO_RELEASE_ID	Euro_PO_Release_Identifier
EURO_PO_HEADER_ID	Euro_PO_Header_Identifier
SECURITY_GROUP_ID	security group identifier

Purchasing - PO_VENDORS_EBS	archive for euro business support project
Column Name	Descritpion
VENDOR_ID	Vendor Identifier
EURO_SEGMENT1	Euro Segment1
SECURITY_GROUP_ID	Security Group Identifier
SEGMENT1	Segment1
CREATION_DATE	Creation Date
CREATED_BY	Created By
ORG_ID	Organization Identifier
INVOICE_CURRENCY_CODE	Invoice Currency Code
PAYMENT_CURRENCY_CODE	Payment Currency Code
INVOICE_AMOUNT_LIMIT	Invoice Amount Limit
EURO_VENDOR_ID	Euro Vendor Id

Purchasing - PO_REQ_DISTRIBUTIONS_ALL_EFC	archive for euro functional currency project
Column Name	Descritpion
DISTRIBUTION_ID	distribution identifier
ENCUMBERED_AMOUNT	encumbered amount
SET_OF_BOOKS_ID	set of books identifier
SECURITY_GROUP_ID	Securiti group identifier

Purchasing - PO_REQUISITION_LINES_ALL_EFC	archive for euro functional currency project
Column Name	Descritpion
UNIT_PRICE	unit price
CURRENCY_UNIT_PRICE	currency unit price
RATE	rate
CURRENCY_CODE	currency code
REQUISITION_LINE_ID	requsition line id
SET_OF_BOOKS_ID	set of books identifier
SECURITY_GROUP_ID	Security Group Identifier

Purchasing - PO_REQUISITIONS_INT_ALL_EFC	archive for euro functional currency project
Column Name	Descritpion
UNIT_PRICE	unit price
TRANSACTION_ID	transaction identifier
CURRENCY_UNIT_PRICE	currenct unit price
RATE	rate
CURRENCY_CODE	currency code
SET_OF_BOOKS_ID	set of books identifier
SECURITY_GROUP_ID	Security group identifier

Purchasing - PO_RULE_EXPENSE_ACCOUNTS	Expense charge account rules.
Column Name	Descritpion
ACCOUNT_RULE_ID	Unique identifier for the account rule
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ORG_ID	Organization identifier
RULE_TYPE	The Account Rule Type
RULE_VALUE_ID	The account rule value identifier
SEGMENT_NUM	Account Segment number
SEGMENT_VALUE	account Segment Value
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).

Purchasing - PO_PRICE_DIFFERENTIALS_ARCHIVE	Price differentials for rate based lines
Column Name	Descritpion
PRICE_DIFFERENTIAL_NUM	Price differential number
ENTITY_ID	Foreign key to Req line PO line or line location
ENTITY_TYPE	The type of the entity this price differential is tied to
PRICE_TYPE	Price differential type
REVISION_NUM	Revision number
ENABLED_FLAG	Indicates if the price differential is enabled
MIN_MULTIPLIER	Minimum multiplier
LATEST_EXTERNAL_FLAG	Latest External Flag
PRICE_DIFFERENTIAL_ID	The primary key for the price differential table
MAX_MULTIPLIER	Maximum multiplier
MULTIPLIER	Multiplier
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Purchasing - PO_PRICE_DIFF_INTERFACE	Price differentials for rate based lines
Column Name	Descritpion
PRICE_DIFFERENTIAL_NUM	Price differential number
PROCESS_CODE	Processing status
ENTITY_ID	ID of the Req Line, PO Line, Blanket Line, or Price Break to which this price differential belongs. References PO_REQUISITION_LINES_ALL.requisition_line_id, PO_LINES_ALL.po_line_id, OR PO_LINE_LOCATIONS_ALL.line_location_id.
ENTITY_TYPE	The type of the entity this price differential is tied to. Possible values can be: 'REQ LINE', 'PO LINE', 'BLANKET LINE', 'PRICE BREAK'.
PRICE_TYPE	Type of rate for which this price differential will be applied (e.g. STANDARD, HOLIDAY, OVERTIME, WEEKEND). Comes from FND_LOOKUP_VALUES.lookup_code with lookup_type, 'PRICE DIFFERENTIALS'.
ENABLED_FLAG	Indicates if the price differential is enabled or not
MIN_MULTIPLIER	Applicable to Blankets only. Minimum value for the multiplier that can be applied to the regular rate designated on the blanket.
MAX_MULTIPLIER	Applicable to Blankets only. Minimum value for the multiplier that can be applied to the regular rate designated on the blanket.
MULTIPLIER	Actual multiplier that is applied to the regular rate on Standard PO or Requisition.
PRICE_DIFF_INTERFACE_ID	The primary key for the price differential table
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
INTERFACE_LINE_ID	Interface Line id
INTERFACE_HEADER_ID	Interface header id
PROCESS_STATUS	Status of the interface line
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
INTERFACE_LINE_LOCATION_ID	Reference to line location interface
PROCESSING_ID	Identifier for records to be processed by a certain PDOI run

Purchasing - PO_PRICE_DIFFERENTIALS	Price differentials for rate-based lines
Column Name	Descritpion
PRICE_DIFFERENTIAL_NUM	Price differential line number
ENTITY_ID	ID of the Req Line, PO Line, Blanket Line, or Price Break to which this price differential belongs. References PO_REQUISITION_LINES_ALL.requisition_line_id, PO_LINES_ALL.po_line_id, OR PO_LINE_LOCATIONS_ALL.line_location_id.
ENTITY_TYPE	The type of the entity this price differential is tied to. Possible values can be: 'REQ LINE', 'PO LINE', 'BLANKET LINE', 'PRICE BREAK'
PRICE_TYPE	Type of rate for which this price differential will be applied (e.g. STANDARD, HOLIDAY, OVERTIME, WEEKEND). Comes from FND_LOOKUP_VALUES.lookup_code with lookup_type, 'PRICE DIFFERENTIALS'. Also see Note 3.
ENABLED_FLAG	Indicates if the price differential is enabled
MIN_MULTIPLIER	Applicable to Blankets only. Minimum value for the multiplier that can be applied to the regular rate designated on the blanket. Also see Note 1.
MAX_MULTIPLIER	Applicable to Blankets only. Maximum value for the multiplier that can be applied to the regular rate designated on the blanket. Also see Note 1.
MULTIPLIER	Actual multiplier that is applied to the regular rate on Standard PO or Requisition. Also see Note 2.
PRICE_DIFFERENTIAL_ID	Unique identifier for this price differential. Primary key for this table.
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Purchasing - PO_REQUISITION_SUPPLIERS	This table holds the list of suppliers to which the contractor request is sent out
Column Name	Descritpion
REQUISITION_LINE_ID	Requisition Line id
SOURCE_DOC_LINE_NUM	Source document Line Id
UNIT_PRICE	Unit Price on the requisition Line
CURRENCY_UNIT_PRICE	Unit price in the foreign currency
AMOUNT	Req Line Amount
CURRENCY_AMOUNT	Amount in foreign currency
CURRENCY_CODE	Currency Code
RATE_TYPE	Exchange Rate Type
RATE_DATE	Exchange Rate date
RATE	Exchange Rate
PRICE_BREAK_ID	Price break Id : Id of the price break from where the price is returned
VENDOR_ID	supplier Id
NOT_TO_EXCEED_PRICE	Price limit on the source agreement line
ALLOW_PRICE_OVERRIDE_FLAG	Flag on the source document line to indicate if chnaging the price is allowed or not
ALLOW_RATE_DIFFERENTIAL_FLAG	Flag to indicate if price differentials are allowed for the contractor request
SUPPLIER_NOTIFIED_FLAG	Flag to indicate if the supplier has been notified of the contractor request
SUPPLIER_NOTIFIED_DATE	Date on which the supplier is notified about the contractor request
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
VENDOR_SITE_ID	supplier site Id
REQUISITION_SUPPLIER_ID	Requisition supplier Id
CANDIDATE_FIRST_NAME	Candidate First name
CANDIDATE_LAST_NAME	Candidate Last name
UNIT_MEAS_LOOKUP_CODE	Req line unit of measure
VENDOR_CONTACT_ID	Supplier contact Id
NOTE_TO_VENDOR	Note to the supplier
CANDIDATE_FULL_NAME	Cndidate Full name
DOCUMENT_TYPE_CODE	Document Type
SOURCE_DOC_HEADER_ID	Source document Header id
SOURCE_DOC_LINE_ID	Source document Line Id

Purchasing - PO_RETRIEVED_TIMECARDS	Retrieved Timecards
Column Name	Descritpion
TC_END_DATE	End date of the time entry
TC_ENTRY_DATE	Entry date of the time entry
VENDOR_SITE_ID	Vendor Site Id for whom the timecard entry is made.
TC_TIME_RECEIVED	Amount of time received
TC_SUBMISSION_DATE	Date on which the timecard is submitted
TC_APPROVAL_STATUS	Approval status of the timecard
TC_APPROVED_DATE	Date on which the Timecard is approved.
TC_SCOPE	Scope of this time entry
CONTINGENT_WORKER_ID	ID of the worker who made the time entry
TC_COMMENT_TEXT	Comment stored along with the time entry
LINE_RATE_TYPE	Type of the time entry made
LINE_RATE	The agreed rate for the line rate type
LINE_RATE_CURRENCY	Currency in which the line rate is calculated.
VENDOR_CONTACT_ID	Vendor Contact ID for the time entry made
PO_CONTRACTOR_LAST_NAME	Last name of the worker who entered the time.
PO_CONTRACTOR_FIRST_NAME	First name of the worker who entered the time.
INTERFACE_TRANSACTION_ID	Corresponding Recieving transaction id that actually made this entry.
ACTION_FLAG	Can have I, U or D to indicate the row is a result of insertion or update or a delete. This will be null if the transaction is completed.
TC_ENTRY_SEQUENCE	Uses the timecard sequence order
PO_HEADER_ID	HEADER_ID of the PO against which the timeentry is made.
PO_NUMBER	PO Number for wich the time entry is made.
PO_LINE_ID	LINE_ID of the PO for which the time entry is made.
PO_LINE_NUMBER	Line Number for which the time entry is made.
ORG_ID	Organization identifier
PO_CREATION_DATE	Date on which the PO is approved.
PO_CONTRACTOR_FULL_NAME	The full name of the contract for whom the time entry is made.
PROJECT_ID	Project_ID that may be associated with this PO.
VENDOR_ID	Vendor for whom the timecard entry is made.
PROJECT_NAME	Name of the project that the PO may be associated with.
TASK_ID	The task that may be associated with the project
TASK_NAME	The name of the task that may be associated with the PO.
TC_ID	Time card ID which references the timeentry made
TC_DAY_ID	The Day ID in the timecard in which the timeentry is made.
TC_DETAIL_ID	The id in which the timeentry is associated with under the TC_DAY_ID.
TC_UOM	UOM for the time entry
TC_START_DATE	The date on which the time entry is made.

Purchasing - PO_LINE_LOCATIONS_GT	For Internal Use Only: This table is global temporary table based on po_line_locations_all table. It is used for internal processing of data for PO Approval Submission Checks.
Column Name	Descritpion
LINE_LOCATION_ID
QUANTITY_RECEIVED
GLOBAL_ATTRIBUTE7
GLOBAL_ATTRIBUTE8
GLOBAL_ATTRIBUTE9
GLOBAL_ATTRIBUTE10
GLOBAL_ATTRIBUTE11
GLOBAL_ATTRIBUTE12
GLOBAL_ATTRIBUTE13
GLOBAL_ATTRIBUTE14
GLOBAL_ATTRIBUTE15
GLOBAL_ATTRIBUTE16
QUANTITY_ACCEPTED
GLOBAL_ATTRIBUTE17
GLOBAL_ATTRIBUTE18
GLOBAL_ATTRIBUTE19
GLOBAL_ATTRIBUTE20
GLOBAL_ATTRIBUTE_CATEGORY
QUANTITY_SHIPPED
COUNTRY_OF_ORIGIN_CODE
TAX_USER_OVERRIDE_FLAG
MATCH_OPTION
TAX_CODE_ID
QUANTITY_REJECTED
CALCULATE_TAX_FLAG
CHANGE_PROMISED_DATE_REASON
NOTE_TO_RECEIVER
SECONDARY_QUANTITY
SECONDARY_UNIT_OF_MEASURE
PREFERRED_GRADE
SECONDARY_QUANTITY_RECEIVED
SECONDARY_QUANTITY_ACCEPTED
SECONDARY_QUANTITY_REJECTED
SECONDARY_QUANTITY_CANCELLED
QUANTITY_BILLED
VMI_FLAG
CONSIGNED_FLAG
RETROACTIVE_DATE
AMOUNT
AMOUNT_RECEIVED
AMOUNT_ACCEPTED
AMOUNT_REJECTED
AMOUNT_BILLED
AMOUNT_CANCELLED
VALUE_BASIS
QUANTITY_CANCELLED
PAYMENT_TYPE
DESCRIPTION
LCM_FLAG
UNIT_MEAS_LOOKUP_CODE
PO_RELEASE_ID
SHIP_TO_LOCATION_ID
SHIP_VIA_LOOKUP_CODE
NEED_BY_DATE
LAST_UPDATE_DATE
PROMISED_DATE
LAST_ACCEPT_DATE
PRICE_OVERRIDE
ENCUMBERED_FLAG
ENCUMBERED_DATE
UNENCUMBERED_QUANTITY
FOB_LOOKUP_CODE
FREIGHT_TERMS_LOOKUP_CODE
TAXABLE_FLAG
ESTIMATED_TAX_AMOUNT
LAST_UPDATED_BY
FROM_HEADER_ID
FROM_LINE_ID
FROM_LINE_LOCATION_ID
START_DATE
END_DATE
LEAD_TIME
LEAD_TIME_UNIT
PRICE_DISCOUNT
TERMS_ID
APPROVED_FLAG
PO_HEADER_ID
APPROVED_DATE
CLOSED_FLAG
CANCEL_FLAG
CANCELLED_BY
CANCEL_DATE
CANCEL_REASON
FIRM_STATUS_LOOKUP_CODE
FIRM_DATE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
PO_LINE_ID
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
UNIT_OF_MEASURE_CLASS
LAST_UPDATE_LOGIN
ENCUMBER_NOW
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
INSPECTION_REQUIRED_FLAG
RECEIPT_REQUIRED_FLAG
QTY_RCV_TOLERANCE
QTY_RCV_EXCEPTION_CODE
CREATION_DATE
ENFORCE_SHIP_TO_LOCATION_CODE
ALLOW_SUBSTITUTE_RECEIPTS_FLAG
DAYS_EARLY_RECEIPT_ALLOWED
DAYS_LATE_RECEIPT_ALLOWED
RECEIPT_DAYS_EXCEPTION_CODE
INVOICE_CLOSE_TOLERANCE
RECEIVE_CLOSE_TOLERANCE
SHIP_TO_ORGANIZATION_ID
SHIPMENT_NUM
SOURCE_SHIPMENT_ID
CREATED_BY
SHIPMENT_TYPE
CLOSED_CODE
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
USSGL_TRANSACTION_CODE
GOVERNMENT_CONTEXT
RECEIVING_ROUTING_ID
ACCRUE_ON_RECEIPT_FLAG
QUANTITY
CLOSED_REASON
CLOSED_DATE
CLOSED_BY
ORG_ID
GLOBAL_ATTRIBUTE1
GLOBAL_ATTRIBUTE2
GLOBAL_ATTRIBUTE3
GLOBAL_ATTRIBUTE4
GLOBAL_ATTRIBUTE5
GLOBAL_ATTRIBUTE6

Purchasing - PO_VALIDATION_RESULTS_GT
Column Name	Descritpion
RESULT_SET_ID
TOKEN1_NAME
TOKEN1_VALUE
TOKEN2_NAME
TOKEN2_VALUE
TOKEN3_NAME
TOKEN3_VALUE
TOKEN4_NAME
TOKEN4_VALUE
TOKEN5_NAME
TOKEN5_VALUE
RESULT_TYPE
TOKEN6_NAME
TOKEN6_VALUE
VALIDATION_ID
ENTITY_TYPE
ENTITY_ID
ENTITY_INTERFACE_ID
COLUMN_NAME
COLUMN_VAL
MESSAGE_APPLICATION
MESSAGE_NAME

Purchasing - PO_RCV_CHARGES	Table for Freight and Special Charge records
Column Name	Descritpion
SHIPMENT_HEADER_ID	Identifer of the item shipment header that is being charged. All charges must have a backing item shipment header
ESTIMATED_TAX	Estimated tax on this charge
ACTUAL_TAX	Billed tax on this charge
COST_COMPONENT_CLASS_ID	OPM required
COST_ANALYSIS_CODE	OPM required
SHIPMENT_LINE_ID	Identifier of the shipment line that is being charged. For header level charge this field is null.
INTERFACE_CHARGE_ID	Identifier of the Charge Interface row that this charge was created from.
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
COST_FACTOR_ID	Identifier of the Cost Factor of this charge
CURRENCY_CODE	Charge currency code
CHARGE_ID	Entity identifier
CURRENCY_CONVERSION_TYPE	Currency conversion type
CURRENCY_CONVERSION_RATE	Currency conversion rate
CURRENCY_CONVERSION_DATE	Currency conversion date
ALLOCATION_METHOD	Basis of allocation. Possible values are: WEIGHT, VALUE, QUANTITY, VOLUME
UNIT_OF_MEASURE	Reserve for Costing use
ESTIMATED_AMOUNT	Estimated charge amount
ACTUAL_AMOUNT	Actual charge amount
INCLUDE_IN_ACQUISITION_COST	Whether this charge should be included in acqusition cost report
VENDOR_ID	Internal identifier of the charge provider
VENDOR_SITE_ID	Internal identifier of the charge provider site

Purchasing - PO_RCV_CHARGE_ALLOCATIONS	Charge Allocations table
Column Name	Descritpion
CHARGE_ID	Idendifier of the backing charge record
SHIPMENT_LINE_ID	Identifier of the item shipment line agaisnt which the allocation is calculated
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ESTIMATED_AMOUNT	Allocated estimated charge amount
ACTUAL_AMOUNT	Allocated actual charge amount
CHARGE_ALLOCATION_ID	Entity identifier
ORIGINAL_UNIT_PRICE	Reserved for Costing use
ORIGINAL_UNIT_NR_TAX	Reserved for Costing use
EST_RECOVERABLE_TAX	Estimated recoverable tax amount on this charge allocation
EST_NON_RECOVERABLE_TAX	Estimated non_recoverable tax amount on this charge allocation
ACT_RECOVERABLE_TAX	Actual recoverable tax amount on this charge allocation
ACT_NON_RECOVERABLE_TAX	Actual non-recoverable tax amount on this charge allocation

Purchasing - PO_LINE_LOCATIONS_INTERFACE	Interface table for purchase order line locations
Column Name	Descritpion
INTERFACE_LINE_LOCATION_ID	Interface line location unique identifier
SHIP_TO_ORGANIZATION_CODE	Ship-to organization code
BID_PAYMENT_ID	Foreign Key reference to the Pay Item on the Sourcing Bid
PROJECT_ID	Internal use only
SHIP_TO_LOCATION_ID	Ship-to location unique identifier
TASK_ID	Internal use only
AWARD_ID	Internal use only
SHIP_TO_LOCATION	Ship-to location
EXPENDITURE_TYPE	Internal use only
EXPENDITURE_ORGANIZATION_ID	Internal use only
TERMS_ID	Payment terms unique identifier
EXPENDITURE_ITEM_DATE	Internal use only
VALUE_BASIS	Value Basis of the line location
PAYMENT_TERMS	Payment terms
MATCHING_BASIS	Matching Basis for the line location
PREFERRED_GRADE	Preferred Grade
QTY_RCV_EXCEPTION_CODE	Action to be taken when the quantity received tolerance is exceeded
TAX_CODE_ID	Unique identifier for the tax code
TAX_NAME	Tax name (or Tax classification code)
FREIGHT_CARRIER	Type of carrier for the RFQ or quotation shipment
TAXABLE_FLAG	Indicate whether shipment is taxable
QTY_RCV_TOLERANCE	Maximum over-receipt tolerance percentage
FOB	Type of free-on-board terms for the shipment
FREIGHT_TERMS	Type of freight terms for the RFQ or quotation shipment
ENFORCE_SHIP_TO_LOCATION_CODE	Describes what action is taken when the receiving location differs from the ship-to location
INTERFACE_HEADER_ID	Interface header unique identifier
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	Indicates whether substitute items can be received in place of the ordered items
DAYS_EARLY_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received late
RECEIPT_DAYS_EXCEPTION_CODE	Action to be taken when items are received earlier or later than the allowed number of days specified
INVOICE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for invoicing when billed
RECEIVE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for receiving
RECEIVING_ROUTING_ID	Routing unique identifier
RECEIVING_ROUTING	Routing
ACCRUE_ON_RECEIPT_FLAG	Indicates whether items are accrued upon receipt
FIRM_FLAG	Indicates whether you want to prevent this purchase order from being automatically rescheduled by your manufacturing application
INTERFACE_LINE_ID	Interface line unique identifier
NEED_BY_DATE	Date the goods are needed by
PROMISED_DATE	Date the goods are promised by
FROM_LINE_LOCATION_ID	Unique identifier of the RFQ shipment used to autocreate a quotation shipment
INSPECTION_REQUIRED_FLAG	Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG	Indicates whether shipment must be received before the invoice is paid
SOURCE_SHIPMENT_ID	Source shipment for scheduled releases
NOTE_TO_RECEIVER	Note to deliverer
TRANSACTION_FLOW_HEADER_ID	Unique transaction flow identifier for relation between purchasing OU and ship to OU. This column is meant for Internal use only
QUANTITY	Quantity ordered on shipment
PRICE_DISCOUNT	Discount percentage for price break (applies to RFQs and quotations only)
PROCESSING_ID	Identifier for the line locations processed in current request
START_DATE	Effective date of the price break (applies to RFQs and quotations only)
END_DATE	Expiration date of the price break (applies to RFQs and quotations only)
PRICE_OVERRIDE	Order shipment price or break price for blanket purchase orders, RFQs, and quotations
LEAD_TIME	Lead time for the price break (applies to RFQs and quotations only)
LEAD_TIME_UNIT	Unit of measure for the lead time
AMOUNT	Amount Ordered for Service line types
SECONDARY_QUANTITY	Quantity ordered on shipment in secondary unit of measure
SECONDARY_UNIT_OF_MEASURE	Secondary unit of measure
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
PROCESS_CODE	Line status code for price/sales catalog update action (832 EDI transaction), such as NOTIFIED, ACCEPTED, or REJECTED
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
LINE_LOCATION_ID	Document shipment schedule unique identifier
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
SHIPMENT_TYPE	Type of shipment
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
UNIT_OF_MEASURE	Unit of measure
SHIPMENT_NUM	Document shipment number
PAYMENT_TYPE	Type of Pay Item
DESCRIPTION	Pay Item description
SHIP_TO_ORGANIZATION_ID	Ship-to organization unique identifier
WORK_APPROVER_ID	FND User ID of Work Confirmation Owner
AUCTION_PAYMENT_ID	FK Reference to Pay Item in on the Sourcing Negotiation

Purchasing - PO_LINES_DRAFT_ALL	Draft table for purchase document lines (for purchase orders, purchase agreements, quotations, RFQs)
Column Name	Descritpion
PO_LINE_ID	Unique identifier for PO line
ITEM_ID	Item unique identifier. (References MTL_SYSTEM_ITEMS_B.inventory_item_id.)
CLOSED_DATE	Date the line is closed
CLOSED_REASON	Describes why the line is closed
ITEM_REVISION	Item revision. (References MTL_ITEM_REVISIONS_B.revision.)
CLOSED_BY	Unique identifier of the employee who closed the line. (References HR_EMPLOYEES.employee_id.)
TRANSACTION_REASON_CODE	Transaction reason. (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='TRANSACTION REASON'.)
ORG_ID	Organization identifier
QC_GRADE	OPM: Stores the quality control grade wanted on the purchase order line
CATEGORY_ID	Item category unique identifier. (References MTL_CATEGORIES_B.category_id.)
BASE_UOM	OPM: Stores the base unit of measure (UOM) for the item ordered
BASE_QTY	OPM: Ordered quantity converted from transaction UOM to base UOM
SECONDARY_UOM	OPM: Stores the dual unit of measure for the item ordered
SECONDARY_QTY	OPM: Converted quantity from BASE UOM to DUAL UOM for the item ordered
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
ITEM_DESCRIPTION	Item description. (Defaulted from MTL_SYSTEM_ITEMS_TL.description.)
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
UNIT_MEAS_LOOKUP_CODE	Unit of measure for the quantity ordered. (References MTL_UNITS_OF_MEASURE.unit_of_measure.)
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
QUANTITY_COMMITTED	Blankets only: Quantity agreed for an agreement line
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
COMMITTED_AMOUNT	Blankets only: Amount agreed for an agreement line
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
ALLOW_PRICE_OVERRIDE_FLAG	Blankets or planned POs only: Indicates whether you can change the price on release shipments
LINE_REFERENCE_NUM	Audit Trail Reference (needed for 832 EDI transaction)
PROJECT_ID	Project accounting project unique identifier. (References PA_PROJECTS_ALL.project_id or PJM_SEIBAN_NUMBERS.project_id.)
TASK_ID	Project accounting task unique identifier. (References PA_TASKS.task_id.)
NOT_TO_EXCEED_PRICE	Blankets or planned POs only: Price limit that you cannot exceed on a release shipment
EXPIRATION_DATE	Blanket, quotation, or RFQ only: Date after which the item on this catalog line can no longer be ordered
TAX_CODE_ID	Unique identifier for the tax code. (References AP_TAX_CODES.tax_id.)
LIST_PRICE_PER_UNIT	List price for the item on the line. (Defaulted from MTL_SYSTEM_ITEMS_B.list_price_per_unit.)
OKE_CONTRACT_HEADER_ID	Contract identifier from Oracle Contracts. (References OKC_K_HEADERS_B.id.)
OKE_CONTRACT_VERSION_ID	Version identifier for contract.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
UNIT_PRICE	Unit price for the line. (Defaulted from MTL_SYSTEM_ITEMS_B.list_price_per_unit, converted to the document's currency.)
SECONDARY_QUANTITY	OPM: Secondary Quantity ordered on the line
SECONDARY_UNIT_OF_MEASURE	OPM: Secondary unit of measure for the quantity ordered
QUANTITY	Quantity ordered on the line
PREFERRED_GRADE	Preferred quality grade for the item ordered
AUCTION_HEADER_ID	Reference to the negotiation id in sourcing. (References PON_AUCTION_HEADERS_ALL.auction_header_id.)
AUCTION_DISPLAY_NUMBER	Reference to the negotiation number in sourcing
AUCTION_LINE_NUMBER	Reference to the negotiation line number in Sourcing
BID_NUMBER	Reference to the bid number in sourcing
UN_NUMBER_ID	UN number unique identifier. (References PO_UN_NUMBERS_B.un_number_id.)
BID_LINE_NUMBER	Reference to the Bid line in sourcing
RETROACTIVE_DATE	Column used to store the timestamp of a retroactive price change
HAZARD_CLASS_ID	Hazard class unique identifier. (References PO_HAZARD_CLASSES_B.hazard_class_id.)
SUPPLIER_REF_NUMBER	Tracking code for a specific configuration of an item. Generated by a configuration engine maintained by suppliers.
CONTRACT_ID	Standard POs only: Contract PA reference of a line. (References PO_HEADERS_ALL.po_header_id.)
START_DATE	Assignment start Date for the contingent worker
AMOUNT	Budget Amout for temp labor standard PO lines
NOTE_TO_VENDOR	Short note to supplier
JOB_ID	Stores the HR Job identifier
CONTRACTOR_FIRST_NAME	First name of the contingent worker
FROM_HEADER_ID	Unique identifier of the quotation (standard or planned POs only) or global agreement (standard POs only) referenced by this line. (References PO_HEADERS_ALL.po_header_id.)
CONTRACTOR_LAST_NAME	Last name of the contingent worker
ORDER_TYPE_LOOKUP_CODE	Value basis of the line
FROM_LINE_ID	Unique identifier of the quotation line (standard or planned POs only) or global agreement line (standard POs only) referenced by this line. (References PO_LINES_ALL.po_line_id.)
PURCHASE_BASIS	Purchase basis of the line type
MATCHING_BASIS	Matching basis of the line type
SVC_AMOUNT_NOTIF_SENT	Temp Labor lines (i.e. PURCHASE_BASIS='TEMP LABOR') on Standard POs only: Y if an Amount Billed Approaching Budget reminder notification has been sent for this line, NULL otherwise.
SVC_COMPLETION_NOTIF_SENT	Temp Labor lines (i.e. PURCHASE_BASIS='TEMP LABOR') on Standard POs only: Y if a Contractor Assignment Nearing Completion reminder notification has been sent for this line, NULL otherwise.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
FROM_LINE_LOCATION_ID	Unique identifier of the Price Break (standard POs only) referenced by this line. (References PO_LINE_LOCATIONS_ALL.line_location_id.)
BASE_UNIT_PRICE	Base Unit Price
MANUAL_PRICE_CHANGE_FLAG	Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise.
DRAFT_ID	The primary key of PO_DRAFTS table. It may be interpreted as a the version of the draft change
CHANGE_ACCEPTED_FLAG	Acceptance status of the draft record
DELETE_FLAG	Flag to indicate the corresponding record in PO_LINES_ALL table should be deleted
RETAINAGE_RATE	Maximum percentage that can be withheld from an invoice as Retainage
MAX_RETAINAGE_AMOUNT	The maximum amount that can be withheld as Retainage against a contract line
CATALOG_NAME	This is to support the replacement of catalogs for CIF format
PROGRESS_PAYMENT_RATE	Percentage applied to the completed work on a financing Pay Item to determine the amount eligible for payment
MIN_ORDER_QUANTITY	Quotations only: Minimum order quantity for a quotation line
SUPPLIER_PART_AUXID	Supplier Part Auxiliary Id
RECOUPMENT_RATE	Maximum percentage of the invoice amount against which previous prepayments can be applied
IP_CATEGORY_ID	IP Category Id for GBPA Lines (-2 stored for null values)
MAX_ORDER_QUANTITY	Quotations only: Maximum order quantity for a quotation line
TAX_ATTRIBUTE_UPDATE_CODE	Keeps track of create/update actions on this entity
ORIGINAL_INTERFACE_LINE_ID	This column is only used by PDOI to indicate the interface line record that creates the draft line record.
QTY_RCV_TOLERANCE	Quantity received tolerance percentage
CLM_EXERCISED_FLAG
CLM_EXERCISED_DATE
OVER_TOLERANCE_ERROR_FLAG	Indicates whether or not you reject receipts exceeding the tolerance
MARKET_PRICE	Market price for the item on the line. (Defaulted from MTL_SYSTEM_ITEMS_B.market_price.)
UNORDERED_FLAG	Indicates whether or not the line was created from unordered receipts
PO_HEADER_ID	Document header unique identifier. (References PO_HEADERS_ALL.po_header_id.)
CLOSED_FLAG	Indicates whether the line is closed or not
USER_HOLD_FLAG	Indicates whether the line is on hold or not (Unused since release version 5.0)
CANCEL_FLAG	Indicates whether the line is cancelled or not
CANCELLED_BY	Unique identifier of the employee who cancelled the line. (References HR_EMPLOYEES.employee_id.)
CANCEL_DATE	Cancellation date
CANCEL_REASON	Cancellation reason provided by employee
FIRM_STATUS_LOOKUP_CODE	Firming status of the line (Unused since release version 7.0)
FIRM_DATE	Date the line becomes firmed (Unused since release version 7.0)
VENDOR_PRODUCT_NUM	Supplier item number
CONTRACT_NUM	Contract number referenced on the line. (Obsoleted in PO FPJ 11.5.10 - use CONTRACT_ID instead.)
LINE_TYPE_ID	Line type unique identifier (References PO_LINE_TYPES_B.line_type_id.)
TAXABLE_FLAG	Indicates whether the document line is taxable or not
TAX_NAME	Tax code applying to the line. (References AP_TAX_CODES_ALL.name.)
TYPE_1099	1099 type for the purchase order line
CAPITAL_EXPENSE_FLAG	Indicates whether the line is for a capital expense or not
NEGOTIATED_BY_PREPARER_FLAG	Indicates whether the buyer negotiated the price or not
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
LINE_NUM	Line number
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
REFERENCE_NUM	Reference number (Unused since release version 7.0)
ATTRIBUTE11	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
MIN_RELEASE_AMOUNT	Blankets or planned POs only: Minimum amount that can be released against a planned or blanket agreement line.
CREATION_DATE	Standard who column - date when this row was created.
PRICE_TYPE_LOOKUP_CODE	Price type of the line. (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='PRICE TYPE'.)
CLOSED_CODE	Describes closure status of the line
PRICE_BREAK_LOOKUP_CODE	Blankets only: Pricing scheme for the price breaks of this line (cumulative or non-cumulative).
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code. (References GL_USSGL_TRANSACTION_CODES.USSGL_TRANSACTION_CODE.)
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).

Purchasing - PO_LINE_LOCATIONS_DRAFT_ALL	Draft table for PO_LINE_LOCATIONS_ALL
Column Name	Descritpion
LINE_LOCATION_ID	Document shipment schedule unique identifier
QUANTITY_ACCEPTED	Quantity accepted after inspection, up until today
SHIPMENT_NUM	Shipment line number
SOURCE_SHIPMENT_ID	Unique identifier of the planned purchase order shipment(also stored in PO_LINE_LOCATIONS_ALL) that was referenced when creating this scheduled release shipment
SHIPMENT_TYPE	Type of the shipment
CLOSED_CODE	Closure status of the shipment
QUANTITY_RECEIVED	Quantity received until today
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code (References GL_USSGL_TRANSACTION_CODES.ussgl_transaction_code)
QUANTITY_REJECTED	Quantity rejected after inspection, up until today
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
RECEIVING_ROUTING_ID	Receipt routing unique identifier(References RCV_ROUTING_HEADERS.routing_header_id)
ACCRUE_ON_RECEIPT_FLAG	Indicates whether items are accrued upon receipt
QUANTITY_BILLED	Quantity invoiced by Oracle Payables, up until today
CLOSED_REASON	Why the shipment is closed
CLOSED_DATE	Date the shipment is closed
CLOSED_BY	Unique identifier of employee who closed the shipment(References HR_EMPLOYEES.employee_id.)
ORG_ID	Organization identifier
QUANTITY_SHIPPED	Quantity shipped
QUANTITY_CANCELLED	Quantity cancelled
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
UNIT_MEAS_LOOKUP_CODE	Price break quantity unit of measure (References MTL_UNITS_OF_MEASURE.unit_of_measure.)
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
PO_RELEASE_ID	Release unique identifier for a release shipment(References PO_RELEASES_ALL.po_release_id)
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
SHIP_TO_LOCATION_ID	Unique identifier for the ship-to location (References HR_LOCATIONS_ALL.location_id)
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
SHIP_VIA_LOOKUP_CODE	Type of carrier for the RFQ or quotation shipment (References ORG_FREIGHT_TL.freight_code)
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
COUNTRY_OF_ORIGIN_CODE	Country of manufacture for this shipment
NEED_BY_DATE	Need-by date for the shipment schedule
TAX_USER_OVERRIDE_FLAG	Indicator of whether somone overrode the default tax
MATCH_OPTION	Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
PROMISED_DATE	Supplier promised delivery date
TAX_CODE_ID	Unique identifier for the tax code(References AP_TAX_CODES_ALL.tax_id)
CALCULATE_TAX_FLAG	Indicator of whether tax needs to be calculated
LAST_ACCEPT_DATE	Latest acceptable receipt date for the shipment
CHANGE_PROMISED_DATE_REASON	Reason for changing the promised-by date
PRICE_OVERRIDE	Order shipment price or break price for blanket purchase orders, RFQs, and quotations
NOTE_TO_RECEIVER	Shipment level Note to receiver, which would hold the note to receiver info coming from req lines.
SECONDARY_QUANTITY	OPM:Secondary Quantity ordered
ENCUMBERED_FLAG	Indicates whether the shipment is encumbered or not
SECONDARY_UNIT_OF_MEASURE	OPM:Secondary Unit of measure for the ordered item
PREFERRED_GRADE	Preferred quality grade for the ordered item
ENCUMBERED_DATE	Date of encumbrance for the shipment
SECONDARY_QUANTITY_RECEIVED	Quantity in secondary unit of measure received until today
SECONDARY_QUANTITY_ACCEPTED	Quantity accepted in secondary unit of measure after inspection, up until today
UNENCUMBERED_QUANTITY	Encumbered quantity to date (Unused since release version 7.0)
SECONDARY_QUANTITY_REJECTED	Quantity rejected in secondary unit of measure after inspection, up until today
SECONDARY_QUANTITY_CANCELLED	Quantity cancelled in secondary unit of measure after inspection, up until today
FOB_LOOKUP_CODE	Type of free-on-board terms for the shipment (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FOB')
SECONDARY_QUANTITY_SHIPPED	Quantity in secondary unit of measure shipped up until today
VMI_FLAG	Indicates VMI shipment line with value = 'Y'
CONSIGNED_FLAG	Indicates shipment is consigned
FREIGHT_TERMS_LOOKUP_CODE	Type of freight terms for the RFQ or quotation shipment (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='FREIGHT TERMS')
RETROACTIVE_DATE	Column used to store the date of a retroactive price change
SUPPLIER_ORDER_LINE_NUMBER	Used to store a supplier change request
TAXABLE_FLAG	Indicates whether the shipment is taxable
AMOUNT	Stores the amount on the shipments for service lines
AMOUNT_RECEIVED	Stores the amount received for service lines
TAX_NAME	Tax code for the shipment (References AP_TAX_CODES_ALL.name)
AMOUNT_BILLED	Stores the amount billed for service lines
AMOUNT_CANCELLED	Amount cancelled for service lines
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ESTIMATED_TAX_AMOUNT	Estimated tax amount for the purchase order shipment (Unused since release version 6.0)
AMOUNT_REJECTED	Amount rejected for service lines
AMOUNT_ACCEPTED	Amount Accepted for service lines
FROM_HEADER_ID	Unique identifier of the RFQ used to autocreate the quotation. For Standard Purchase Orders referencing Global Agreements, this field captures the unique Identifier of Global Agreements(References: PO_HEADERS_ALL.PO_HEADER_ID)
DROP_SHIP_FLAG	Indicates whether the Shipment has a backing Sales Order Line.
SALES_ORDER_UPDATE_DATE	The date/time when any of referenced data elements on the backing Sales Order Line is updated.
FROM_LINE_ID	Unique identifier of the RFQ line used to autocreate the quotation line. For Standard PO Lines that reference Global Agreement lines, this field captures the unique identifier of Global Agreement line (References PO_LINES_ALL.po_line_id)
TRANSACTION_FLOW_HEADER_ID	Transaction flow header identifier(References MTL_TRANSACTION_FLOW_HEADERS.header_id)
FINAL_MATCH_FLAG	This flag indicates if the shipment is finally matched by AP invoice. This field is not upgraded. Hence may not reflect accurately for old data. This field is only used by AP as of 11.5.10
FROM_LINE_LOCATION_ID	Unique identifier of the RFQ shipment used to autocreate a quotation shipment. For Standard POs that reference Global Agreements, this field captures the Global Agreement Price Break Unique Identifier (references PO_LINE_LOCATIONS_ALL.line_
MANUAL_PRICE_CHANGE_FLAG	Only for Blanket Release shipments: Y if the user has manually entered a price overriding the Blanket Agreement price, N or null otherwise.
SHIPMENT_CLOSED_DATE	Date when the Shipment is closed for both Receiving and Invoice
START_DATE	Effective date of the price break (applies to RFQs and quotations only)
CLOSED_FOR_RECEIVING_DATE	Date when the Shipment is closed for Receiving
CLOSED_FOR_INVOICE_DATE	Date when the Shipment is closed for Invoice
END_DATE	Expiration date of the price break (applies to RFQs and quotations only)
CHANGE_ACCEPTED_FLAG	Indicate whether the draft change has been accepted or not
DELETE_FLAG	Indicate whether this record is used to indicate deletion of the corresponding record in PO_LINE_LOCATIONS_ALL
LEAD_TIME	Lead time for the price break (applies to RFQs and quotations only)
DRAFT_ID	Draft Change Identifier
VALUE_BASIS	Value basis of the line location
LEAD_TIME_UNIT	Unit of measure for the lead time
MATCHING_BASIS	Matching basis of the line location
PAYMENT_TYPE	Pay Item type
PRICE_DISCOUNT	Discount percentage for price break (applies to RFQs and quotations only)
DESCRIPTION	Pay Item description
TERMS_ID	Payment terms unique identifier(References AP_TERMS.term_id)
WORK_APPROVER_ID	FND User ID of the Pay Item's Work Confirmation Owner
BID_PAYMENT_ID	References the Bid Pay Item if it was negotiated in Sourcing
PO_HEADER_ID	Document header unique identifier. (References PO_HEADERS_ALL.po_header_id.). For Release shipments, this references the Unique identifier of Blanket PO
APPROVED_FLAG	Indicates whether the shipment is approved
QUANTITY_FINANCED	For Financing Pay Items, the number of units which have been pre-paid
AMOUNT_FINANCED	For Advances or Financing Pay Items, the amount which has been pre-paid
APPROVED_DATE	Approval date for shipment(No longer used)
QUANTITY_RECOUPED	For Financing Pay Items, the number of units for which prepayments have been liquidated
AMOUNT_RECOUPED	For Advances or Financing Pay Items, the amount of the prepayments which has been liquidated
CLOSED_FLAG	No longer used
RETAINAGE_WITHHELD_AMOUNT	The total amount withheld as Retainage against this Pay Item
RETAINAGE_RELEASED_AMOUNT	The amount of Retainage released for this Pay Item
CANCEL_FLAG	Indicates whether the shipment is cancelled or not
AMOUNT_SHIPPED	Amount pending for Work Confirmation
OUTSOURCED_ASSEMBLY	This column identifies whether the item is a shikyu item or not
CANCELLED_BY	Unique identifier of the employee who cancelled the shipment (References to HR_EMPLOYEES.employee_id)
TAX_ATTRIBUTE_UPDATE_CODE	Keeps track of create/update actions on this entity
CANCEL_DATE	Cancellation date
CANCEL_REASON	Cancellation reason provided by the employee
FIRM_STATUS_LOOKUP_CODE	Indicates whether you want to prevent this Shipment from being automatically rescheduled by your manufacturing application.
FIRM_DATE	No longer used
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
PO_LINE_ID	Document line unique identifier (References PO_LINES_ALL.po_line_id). For Release Shipments, this references the unique line identifier of Blanket PO
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
UNIT_OF_MEASURE_CLASS	Unit of measure class (Unused since release version 7.0)
ENCUMBER_NOW	Indicates whether the shipment should be encumbered (Unused since release version 7.0)
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
CREATION_DATE	Standard who column - date when this row was created.
ATTRIBUTE15	Descriptive flexfield segment
INSPECTION_REQUIRED_FLAG	Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG	Indicates whether shipment must be received before the invoice is paid
QTY_RCV_TOLERANCE	Maximum over-receipt tolerance percentage
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
QTY_RCV_EXCEPTION_CODE	Describes what action is taken when the quantity received tolerance is exceeded
ENFORCE_SHIP_TO_LOCATION_CODE	Describes what action is taken when the receiving location differs from the ship-to location
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	Indicates whether substitute items can be received in place of the ordered items
DAYS_EARLY_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received late
QUANTITY	Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations
RECEIPT_DAYS_EXCEPTION_CODE	Describes what action is taken when items are received earlier or later than the allowed number of days specified
INVOICE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for invoicing when billed
RECEIVE_CLOSE_TOLERANCE	Percentage tolerance within which a shipment is automatically closed for receiving
SHIP_TO_ORGANIZATION_ID	Ship-to organization unique identifier(References HR_ORGANIZATION_UNITS.organization_id)

Purchasing - PO_PRICE_DIFF_DRAFT	Draft Table for price differentials for rate-based lines.
Column Name	Descritpion
CHANGE_ACCEPTED_FLAG	Acceptance status of the draft record.
DELETE_FLAG	Flag indicating whether the corresponding record in transaction table should be deleted when the draft change is accepted.
PRICE_DIFFERENTIAL_ID	Unique identifier for this price differential. Primary key for this table.
PRICE_DIFFERENTIAL_NUM	Price differential line number
ENTITY_ID	ID of the Req Line, PO Line, Blanket Line, or Price Break to which this price differential belongs. References PO_REQUISITION_LINES_ALL.requisition_line_id, PO_LINES_ALL.po_line_id, OR PO_LINE_LOCATIONS_ALL.line_location_id.
ENTITY_TYPE	The type of the entity this price differential is tied to. Possible values can be: 'REQ LINE', 'PO LINE', 'BLANKET LINE', 'PRICE BREAK'
PRICE_TYPE	Type of rate for which this price differential will be applied (e.g. STANDARD, HOLIDAY, OVERTIME, WEEKEND). Comes from FND_LOOKUP_VALUES.lookup_code with lookup_type, 'PRICE DIFFERENTIALS'. Also see Note 3.
ENABLED_FLAG	Indicates if the price differential is enabled
MIN_MULTIPLIER	Applicable to Blankets only. Minimum value for the multiplier that can be applied to the regular rate designated on the blanket. Also see Note 1.
DRAFT_ID	Primary key of the table; Foreign key to PO_DRAFTS table.
MAX_MULTIPLIER	Applicable to Blankets only. Maximum value for the multiplier that can be applied to the regular rate designated on the blanket. Also see Note 1.
MULTIPLIER	Actual multiplier that is applied to the regular rate on Standard PO or Requisition. Also see Note 2.
CREATION_DATE	Standard who column - date when this row was created.
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Purchasing - PO_NOTIFICATION_CTRL_DRAFT	Blanket agreement and planned purchase order notification controls draft table
Column Name	Descritpion
START_DATE_ACTIVE	Effective date of the notification
END_DATE_ACTIVE	Expiration date of the notification
NOTIFICATION_AMOUNT	Notification amount of document total
NOTIFICATION_CONDITION_CODE	Notification type
NOTIFICATION_QTY_PERCENTAGE	Notification percentage of document total
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	Standard who column - date when this row was created.
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
DELETE_FLAG	Flag to indicate the corresponding record in PO_NOTIFICATION_CONTROLS table should be deleted
CHANGE_ACCEPTED_FLAG	Acceptance status of the draft record.
DRAFT_ID	Draft Unique Identifier
NOTIFICATION_ID	Notification control unique identifier
PO_HEADER_ID	Blanket, planned and contract purchase order header unique identifier

Purchasing - PO_VENDORS_OBS	Suppliers
Column Name	Descritpion
INSPECTION_REQUIRED_FLAG	Indicates whether inspection is required or not
VENDOR_NAME_ALT	Alternate supplier name for kana value
RECEIPT_REQUIRED_FLAG	Indicates whether shipment must be received before the invoice is paid
QTY_RCV_TOLERANCE	Quantity received tolerance percentage
QTY_RCV_EXCEPTION_CODE	Enforces, warns, or ignores quantity receiving tolerance
ENFORCE_SHIP_TO_LOCATION_CODE	Action to be taken when the receiving location differs from the ship-to location
DAYS_EARLY_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received early
SEGMENT1	Key flexfield segment
DAYS_LATE_RECEIPT_ALLOWED	Maximum acceptable number of days items can be received late
RECEIPT_DAYS_EXCEPTION_CODE	Action to be taken when items are received earlier or later than the allowed number of days specified
RECEIVING_ROUTING_ID	Receipt routing unique identifier
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	Indicates whether substitute items can be received in place of the ordered items
ALLOW_UNORDERED_RECEIPTS_FLAG	Indicates whether unordered receipts are allowed
SUMMARY_FLAG	Key flexfield summary flag
HOLD_UNMATCHED_INVOICES_FLAG	Indicates whether unmatched invoices should be put on hold
EXCLUSIVE_PAYMENT_FLAG	Indicates exclusive payment
AP_TAX_ROUNDING_RULE	Determines the rounding rule for tax values
AUTO_TAX_CALC_FLAG	Supplier level where the tax calculation is done
AUTO_TAX_CALC_OVERRIDE	Allows override of tax calculation at supplier site level
ENABLED_FLAG	Key flexfield summary flag
AMOUNT_INCLUDES_TAX_FLAG	Do amounts include tax from this supplier?
TAX_VERIFICATION_DATE	Tax verification date
NAME_CONTROL	Name control
STATE_REPORTABLE_FLAG	State reportable flag
FEDERAL_REPORTABLE_FLAG	Federal reportable flag
SEGMENT2	Key flexfield segment
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
SEGMENT3	Key flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
SEGMENT4	Key flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
SEGMENT5	Key flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
OFFSET_VAT_CODE	No longer used
VAT_REGISTRATION_NUM	VAT registration number
CREATION_DATE	Standard who column - date when this row was created.
AUTO_CALCULATE_INTEREST_FLAG	Indicates whether interest is to be automatically calculated
VALIDATION_NUMBER	Validation number
EXCLUDE_FREIGHT_FROM_DISCOUNT	Exclude supplier freight from discount amount
TAX_REPORTING_NAME	Tax reporting method name
CHECK_DIGITS	Check number used by Payables
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
BANK_NUMBER	Bank number for Accounts Payable
ALLOW_AWT_FLAG	Indicator of whether Allow Withholding Tax is enabled
AWT_GROUP_ID	Unique identifier for the withholding tax group
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
EMPLOYEE_ID	Employee unique identifier if the supplier is an employee
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
VENDOR_TYPE_LOOKUP_CODE	Supplier type
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
CUSTOMER_NUM	Customer number with the supplier
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
EDI_TRANSACTION_HANDLING	Defines whether this supplier is an EDI partner
ONE_TIME_FLAG	Indicates whether the supplier is a one-time supplier
EDI_PAYMENT_METHOD	How payment is to be made through EDI. Valid methods are ACH, BOP, CWT, FEW, FWT, and SWT.
EDI_PAYMENT_FORMAT	Type of information being transmitted with the funds if using EDI_PAYMENT_METHOD ACH. Valid values are CCD, CCP, CTP, CTX, PPD, and PPP.
EDI_REMITTANCE_METHOD	How remittance advice will be sent to the supplier
EDI_REMITTANCE_INSTRUCTION	Who will send the remittance advice. Valid values are Bank or payables system.
BANK_CHARGE_BEARER	Indicator of whether this supplier bears bank charges
PARENT_VENDOR_ID	Unique identifier of the parent supplier
BANK_BRANCH_TYPE	Which list the bank routing number is on. Valid type are ABA, CHIPS, SWIFT and OTHER.
MATCH_OPTION	Indicator of whether to match invoices to the purchase order or the receipt for this supplier
MIN_ORDER_AMOUNT	Minimum purchase order amount
FUTURE_DATED_PAYMENT_CCID	Accounting Flexfield identifier for the future dated payment account
CREATE_DEBIT_MEMO_FLAG	Indicator of whether a debit memo should be created
SHIP_TO_LOCATION_ID	Default ship-to location unique identifier
OFFSET_TAX_FLAG	Indicator of whether the supplier uses offset taxes
UNIQUE_TAX_REFERENCE_NUM	Unique Tax Reference Number of the subcontractor
BILL_TO_LOCATION_ID	Default bill-to location unique identifier
PARTNERSHIP_UTR	Unique Tax Reference Number of the partnership
PARTNERSHIP_NAME	Partnership name
SHIP_VIA_LOOKUP_CODE	Default carrier type
CIS_ENABLED_FLAG	CIS enabled flag
FIRST_NAME	First name of the Subcontractor
FREIGHT_TERMS_LOOKUP_CODE	Default freight terms type
SECOND_NAME	Second name of the Subcontractor
LAST_NAME	Last name of the Subcontractor
FOB_LOOKUP_CODE	Default free-on-board type
SALUTATION	Salutation
TRADING_NAME	Trading name of the Subcontractor
TERMS_ID	Payment terms unique identifier
WORK_REFERENCE	Work reference of the Subcontractor
COMPANY_REGISTRATION_NUMBER	Company Registration Number
SET_OF_BOOKS_ID	Set of Books unique identifier
NATIONAL_INSURANCE_NUMBER	National Insurance Number of the subcontractor
VERIFICATION_NUMBER	Verification Number returned by HMRC for the subcontractor
CREDIT_STATUS_LOOKUP_CODE	No longer used
VERIFICATION_REQUEST_ID	Verification concurrent request identifier
MATCH_STATUS_FLAG	Match status code returned by HMRC
CREDIT_LIMIT	Not used
CIS_VERIFICATION_DATE	Date the subcontractor was verified
CIS_PARENT_VENDOR_ID	Parent Vendor id
ALWAYS_TAKE_DISC_FLAG	Indicator of whether Oracle Payables should always take a discount for the supplier
BUS_CLASS_LAST_CERTIFIED_BY	bus class last certified by
BUS_CLASS_LAST_CERTIFIED_DATE	bus class last certified date
PAY_DATE_BASIS_LOOKUP_CODE	Type of payment date basis
PAY_GROUP_LOOKUP_CODE	Payment group type
PAYMENT_PRIORITY	Payment priority
INVOICE_CURRENCY_CODE	Default currency unique identifier
PAYMENT_CURRENCY_CODE	Default payment currency unique identifier
INVOICE_AMOUNT_LIMIT	Maximum amount per invoice
EXCHANGE_DATE_LOOKUP_CODE	No longer used
HOLD_ALL_PAYMENTS_FLAG	Indicates whether Oracle Payables should place all payments for this supplier on hold or not
HOLD_FUTURE_PAYMENTS_FLAG	Indicates whether Oracle Payables should place upapproved payments for this supplier on hold or not
HOLD_REASON	Reason for placing the supplier on payment hold
DISTRIBUTION_SET_ID	Distribution set unique identifier
ACCTS_PAY_CODE_COMBINATION_ID	Unique identifier for the supplier liability account
DISC_LOST_CODE_COMBINATION_ID	No longer used
DISC_TAKEN_CODE_COMBINATION_ID	No longer used
EXPENSE_CODE_COMBINATION_ID	Not used
PREPAY_CODE_COMBINATION_ID	Unique identifier for the general ledger account for prepayment
NUM_1099	Tax identification number
TYPE_1099	Type of 1099
WITHHOLDING_STATUS_LOOKUP_CODE	Withholding status type
WITHHOLDING_START_DATE	Withholding start date
ORGANIZATION_TYPE_LOOKUP_CODE	IRS organization type
VENDOR_ID	Supplier unique identifier
VAT_CODE	VAT code
START_DATE_ACTIVE	Key flexfield start date
END_DATE_ACTIVE	Key flexfield end date
MINORITY_GROUP_LOOKUP_CODE	Type of minority-owned business
PAYMENT_METHOD_LOOKUP_CODE	Default payment method type
BANK_ACCOUNT_NAME	Name of the supplier bank account
BANK_ACCOUNT_NUM	Number of the supplier bank account
BANK_NUM	Bank number for the supplier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
BANK_ACCOUNT_TYPE	Type of bank account
WOMEN_OWNED_FLAG	Indicates whether the supplier is a woman-owned business
SMALL_BUSINESS_FLAG	Indicates that the supplier is a small business
STANDARD_INDUSTRY_CLASS	Standard industry classification number
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
HOLD_FLAG	Indicator of whether the supplier is on purchasing hold
PURCHASING_HOLD_REASON	Reason for placing the supplier on purchasing hold
HOLD_BY	Unique identifier for the employee who placed the supplier on hold
HOLD_DATE	Date the supplier was placed on purchasing hold
TERMS_DATE_BASIS	Type of invoice payment schedule basis
PRICE_TOLERANCE	Not used
VENDOR_NAME	Supplier name

Purchasing - PO_VENDOR_SITES_OBS	Supplier sites
Column Name	Descritpion
VENDOR_ID	Supplier unique identifier
ALWAYS_TAKE_DISC_FLAG	Indicator of whether Oracle Payables should always take a discount for the supplier
INVOICE_CURRENCY_CODE	Default currency unique identifier
PAYMENT_CURRENCY_CODE	Default payment currency unique identifier
HOLD_ALL_PAYMENTS_FLAG	Indicates whether Oracle Payables should place all payments for this supplier on hold
HOLD_FUTURE_PAYMENTS_FLAG	Indicates whether Oracle Payables should place unapproved invoices for this supplier on hold
VENDOR_SITE_CODE	Site code name
HOLD_REASON	Reason that the Supplier Site has been placed on hold
HOLD_UNMATCHED_INVOICES_FLAG	Indicates whether unmatched invoices should be put on hold
AP_TAX_ROUNDING_RULE	Indicates the rounding rule for tax values
AUTO_TAX_CALC_FLAG	Level for automatic tax calculation for supplier
AUTO_TAX_CALC_OVERRIDE	Allows override of tax calculation at supplier site level
AMOUNT_INCLUDES_TAX_FLAG	Do amounts include tax from this supplier?
EXCLUSIVE_PAYMENT_FLAG	Exclusive payment flag
TAX_REPORTING_SITE_FLAG	Tax reporting site Flag
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
VENDOR_SITE_CODE_ALT	Alternate supplier site code for Kana Value
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
CREATION_DATE	Standard who column - date when this row was created.
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
VALIDATION_NUMBER	Validation number
PURCHASING_SITE_FLAG	Indicates whether you can purchase from this site
EXCLUDE_FREIGHT_FROM_DISCOUNT	Indicates whether the freight amount is to be excluded from the discount
VAT_REGISTRATION_NUM	VAT registration number
OFFSET_VAT_CODE	Offset VAT code
ORG_ID	Organization identifier
CHECK_DIGITS	Check digits for Accounts Payable
RFQ_ONLY_SITE_FLAG	Indicates whether you can only send RFQs to this site
BANK_NUMBER	Bank number for Accounts Payable
ADDRESS_LINE4	Fourth line of address
COUNTY	Supplier site county
ADDRESS_STYLE	Style of address
LANGUAGE	Site language
PAY_SITE_FLAG	Indicates whether you can send payments to this site
ALLOW_AWT_FLAG	Indicator of whether Allow Withholding Tax is enabled
AWT_GROUP_ID	Unique identifier for the withholding tax group
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE3	Reserved for country-specific functionality
ATTENTION_AR_FLAG	Indicates whether the payments should be sent to the Accounts Receivable department
GLOBAL_ATTRIBUTE4	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE5	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE6	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE7	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE8	Reserved for country-specific functionality
ADDRESS_LINE1	First line of supplier address
GLOBAL_ATTRIBUTE9	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE10	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE11	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE12	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE13	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE14	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE15	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE16	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE17	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE18	Reserved for country-specific functionality
ADDRESS_LINES_ALT	Alternate address line for Kana Value
GLOBAL_ATTRIBUTE19	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE20	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE_CATEGORY	Reserved for country-specific functionality
EDI_TRANSACTION_HANDLING	ANSI standard code for EDI transaction type
EDI_ID_NUMBER	EDI trading partner number for the supplier site
ADDRESS_LINE2	Second line of supplier address
EDI_PAYMENT_METHOD	How payment is to be made through EDI. Valid method are ACH and BOP.
EDI_PAYMENT_FORMAT	Type of information being transmitted with the funds if using EDI_PATMENT_METHOD ACH. Valid values are CCD, CCP, CTP, CTX, PPD and PPP.
EDI_REMITTANCE_METHOD	How remittance advice will be sent to the supplier
BANK_CHARGE_BEARER	Indicator of whether this supplier site is a bank charge bearer site
EDI_REMITTANCE_INSTRUCTION	Who will send the remittance advice. Valid values are banks or payables systems.
ADDRESS_LINE3	Third line of supplier address
BANK_BRANCH_TYPE	Which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, and OTHER.
PAY_ON_CODE	When to create an invoice. Currently, the code 'RECEIPT' is used. Future enhancements could include 'DELIVERY'.
DEFAULT_PAY_SITE_ID	Payment site for the site in which the receipt was entered.
PAY_ON_RECEIPT_SUMMARY_CODE	If the PAY_ON_CODE is 'RECEIPT', then this column identifies how to consolidate the receipts to create invoices. Valid values are PAY_SITE, PACKING_SLIP, and RECEIPT.
TP_HEADER_ID	EDI transaction header unique identifier
CITY	City name
ECE_TP_LOCATION_CODE	Trading partner location code for e-Commerce Gateway
PCARD_SITE_FLAG	Indicator of whether the site allows use of procurement cards
STATE	State name or abbreviation
MATCH_OPTION	Indicator of whether to match the invoices to the purchase order or receipt
COUNTRY_OF_ORIGIN_CODE	Code for the country of manufacture
ZIP	Postal code
FUTURE_DATED_PAYMENT_CCID	Accounting Flexfield identifier for the future dated payment account
CREATE_DEBIT_MEMO_FLAG	Indicator of whether a debit memo should be created
PROVINCE	Province
OFFSET_TAX_FLAG	Indicator of whether offset tax is used
SUPPLIER_NOTIF_METHOD	The preferred Notification Method for the supplier
COUNTRY	Country name
EMAIL_ADDRESS	Email Address of the supplier Contact
REMITTANCE_EMAIL	The destination e-mail address for remittance information. Populating this field activates the E-mail Remittance Advice feature in Payables
AREA_CODE	Area code
PRIMARY_PAY_SITE_FLAG	A value of Y indicates that this is the default pay site for the supplier
SHIPPING_CONTROL	Indicator of who is responsible for arranging transportation
PHONE	Phone number
SELLING_COMPANY_IDENTIFIER	Selling Company Identifier used in generating invoice numbers when gapless invoice numbering is enabled
GAPLESS_INV_NUM_FLAG	Indicates whether gapless invoice numbering is used
CUSTOMER_NUM	Customer number with the supplier site
DUNS_NUMBER	DUNS Number
SERVICES_TOLERANCE_ID
SHIP_TO_LOCATION_ID	Default ship-to location unique identifier
BILL_TO_LOCATION_ID	Ship-to location unique identifier
SHIP_VIA_LOOKUP_CODE	Default carrier type
FREIGHT_TERMS_LOOKUP_CODE	Default freight terms type
FOB_LOOKUP_CODE	Default free-on-board type
INACTIVE_DATE	Inactive date for record
FAX	Customer site facsimile number
FAX_AREA_CODE	Customer site
TELEX	Telex number
PAYMENT_METHOD_LOOKUP_CODE	Default payment method type
BANK_ACCOUNT_NAME	Bank account name
BANK_ACCOUNT_NUM	Bank account number
BANK_NUM	Bank number
BANK_ACCOUNT_TYPE	Bank account type
TERMS_DATE_BASIS	Type of invoice payment schedule basis
TOLERANCE_ID	Tolerance Unique Identifier
VENDOR_SITE_ID	Supplier site unique identifier
CURRENT_CATALOG_NUM	Not currently used
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
VAT_CODE	Value-added tax code
DISTRIBUTION_SET_ID	Distribution set unique identifier
ACCTS_PAY_CODE_COMBINATION_ID	Unique identifier for the supplier liability account
PREPAY_CODE_COMBINATION_ID	Unique identifier for the general ledger account for prepayment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PAY_GROUP_LOOKUP_CODE	Payment group type
PAYMENT_PRIORITY	Payment priority
TERMS_ID	Payment terms unique identifier
INVOICE_AMOUNT_LIMIT	Maximum amount per invoice
PAY_DATE_BASIS_LOOKUP_CODE	Type of payment date basis

Purchasing - PO_VENDOR_CONTACTS_OBS	Supplier contacts
Column Name	Descritpion
VENDOR_CONTACT_ID	Supplier contact unique identifier
MIDDLE_NAME	Contact middle name
FAX_AREA_CODE	Contact Fax area code
FAX	Contact Fax number
LAST_NAME	Contact last name
PREFIX	Prefix
TITLE	Title
MAIL_STOP	Contact mail stop
AREA_CODE	Contact phone number area code
PHONE	Contact phone number
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
VENDOR_SITE_ID	Supplier site unique identifier
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
CREATION_DATE	Standard who column - date when this row was created.
CONTACT_NAME_ALT	Supplier contact alternate name
FIRST_NAME_ALT	Alternate supplier contact's first name
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_NAME_ALT	Alternate supplier contact's last name
DEPARTMENT	Department
INACTIVE_DATE	Inactive date for record
EMAIL_ADDRESS	Contact Email Address
URL	Contact URL
FIRST_NAME	Contact first name
ALT_AREA_CODE	Contact alternate phone number area code
ALT_PHONE	Contact alternate phone number

Purchasing - PO_RETROPRICE_GT	For Internal Use Only: PO_RETROPRICE_GT is used to write the results of the bulk selects in the procedure PO_RETROACTIVE_PRICING_PVT.MassUpdate_Releases. This is then used later to update the tables using bulk processing.
Column Name	Descritpion
ROW_ID
NEW_PRICE
PO_RELEASE_ID
PO_HEADER_ID
ARCHIVED_REVISION_NUM
AUTHORIZATION_STATUS
NEW_BASE_PRICE

Purchasing - PO_REQ_LINES_GT	For Internal Use Only: This table is global temporary table based on po_requisition_lines_all table. It is used for internal processing of data for PO Approval Submission Checks.
Column Name	Descritpion
REQUEST_ID
QUANTITY_RECEIVED
ENCUMBERED_FLAG
RFQ_REQUIRED_FLAG
NEED_BY_DATE
LINE_LOCATION_ID
MODIFIED_BY_AGENT_FLAG
KANBAN_CARD_ID
CATALOG_TYPE
CATALOG_SOURCE
MANUFACTURER_ID
MANUFACTURER_NAME
SOURCE_REQ_LINE_ID
MANUFACTURER_PART_NUMBER
REQUESTER_EMAIL
REQUESTER_FAX
REQUESTER_PHONE
UNSPSC_CODE
OTHER_CATEGORY_CODE
SUPPLIER_DUNS
TAX_STATUS_INDICATOR
PCARD_FLAG
NEW_SUPPLIER_FLAG
ORG_ID
AUTO_RECEIVE_FLAG
TAX_USER_OVERRIDE_FLAG
TAX_CODE_ID
NOTE_TO_VENDOR
OKE_CONTRACT_HEADER_ID
OKE_CONTRACT_VERSION_ID
ITEM_SOURCE_ID
SUPPLIER_REF_NUMBER
SECONDARY_UNIT_OF_MEASURE
SECONDARY_QUANTITY
CANCEL_REASON
PREFERRED_GRADE
SECONDARY_QUANTITY_RECEIVED
SECONDARY_QUANTITY_CANCELLED
AUCTION_HEADER_ID
AUCTION_DISPLAY_NUMBER
AUCTION_LINE_NUMBER
REQS_IN_POOL_FLAG
VMI_FLAG
BID_NUMBER
BID_LINE_NUMBER
CLOSED_CODE
AMOUNT
AGENT_RETURN_NOTE
CHANGED_AFTER_RESEARCH_FLAG
VENDOR_ID
VENDOR_SITE_ID
VENDOR_CONTACT_ID
PROGRAM_APPLICATION_ID
RESEARCH_AGENT_ID
ON_LINE_FLAG
WIP_ENTITY_ID
WIP_LINE_ID
WIP_REPETITIVE_SCHEDULE_ID
WIP_OPERATION_SEQ_NUM
WIP_RESOURCE_SEQ_NUM
ATTRIBUTE_CATEGORY
DESTINATION_CONTEXT
INVENTORY_SOURCE_CONTEXT
PROGRAM_ID
VENDOR_SOURCE_CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
PROGRAM_UPDATE_DATE
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
BOM_RESOURCE_ID
PARENT_REQ_LINE_ID
JUSTIFICATION
NOTE_TO_AGENT
USSGL_TRANSACTION_CODE
NOTE_TO_RECEIVER
PURCHASING_AGENT_ID
DOCUMENT_TYPE_CODE
BLANKET_PO_HEADER_ID
BLANKET_PO_LINE_NUM
CURRENCY_CODE
RATE_TYPE
RATE_DATE
RATE
CURRENCY_UNIT_PRICE
GOVERNMENT_CONTEXT
SUGGESTED_VENDOR_NAME
SUGGESTED_VENDOR_LOCATION
SUGGESTED_VENDOR_CONTACT
SUGGESTED_VENDOR_PHONE
SUGGESTED_VENDOR_PRODUCT_CODE
UN_NUMBER_ID
HAZARD_CLASS_ID
MUST_USE_SUGG_VENDOR_FLAG
REFERENCE_NUM
ON_RFQ_FLAG
CLOSED_REASON
URGENT_FLAG
CANCEL_FLAG
SOURCE_ORGANIZATION_ID
SOURCE_SUBINVENTORY
DESTINATION_TYPE_CODE
DESTINATION_ORGANIZATION_ID
DESTINATION_SUBINVENTORY
QUANTITY_CANCELLED
CANCEL_DATE
REQUISITION_LINE_ID
CLOSED_DATE
REQUISITION_HEADER_ID
LINE_NUM
LINE_TYPE_ID
CATEGORY_ID
ITEM_DESCRIPTION
UNIT_MEAS_LOOKUP_CODE
UNIT_PRICE
QUANTITY
DELIVER_TO_LOCATION_ID
TO_PERSON_ID
TRANSACTION_REASON_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
SOURCE_TYPE_CODE
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
ITEM_ID
ITEM_REVISION
QUANTITY_DELIVERED
SUGGESTED_BUYER_ID

Purchasing - PO_LINES_GT	For Internal Use Only: This table is global temporary table based on po_lines_all table. It is used for internal processing of data for PO Approval Submission Checks.
Column Name	Descritpion
PO_LINE_ID
ITEM_ID
GLOBAL_ATTRIBUTE15
GLOBAL_ATTRIBUTE16
GLOBAL_ATTRIBUTE17
GLOBAL_ATTRIBUTE18
GLOBAL_ATTRIBUTE19
GLOBAL_ATTRIBUTE20
LINE_REFERENCE_NUM
PROJECT_ID
TASK_ID
EXPIRATION_DATE
ITEM_REVISION
TAX_CODE_ID
OKE_CONTRACT_HEADER_ID
OKE_CONTRACT_VERSION_ID
SECONDARY_QUANTITY
SECONDARY_UNIT_OF_MEASURE
PREFERRED_GRADE
AUCTION_HEADER_ID
AUCTION_DISPLAY_NUMBER
AUCTION_LINE_NUMBER
BID_NUMBER
CATEGORY_ID
BID_LINE_NUMBER
RETROACTIVE_DATE
AMOUNT
CONTRACT_ID
MATCHING_BASIS
ORDER_TYPE_LOOKUP_CODE
PURCHASE_BASIS
START_DATE
ITEM_DESCRIPTION
UNIT_MEAS_LOOKUP_CODE
QUANTITY_COMMITTED
COMMITTED_AMOUNT
ALLOW_PRICE_OVERRIDE_FLAG
NOT_TO_EXCEED_PRICE
LIST_PRICE_PER_UNIT
LAST_UPDATE_DATE
UNIT_PRICE
QUANTITY
UN_NUMBER_ID
HAZARD_CLASS_ID
NOTE_TO_VENDOR
FROM_HEADER_ID
FROM_LINE_ID
MIN_ORDER_QUANTITY
MAX_ORDER_QUANTITY
QTY_RCV_TOLERANCE
LAST_UPDATED_BY
OVER_TOLERANCE_ERROR_FLAG
MARKET_PRICE
UNORDERED_FLAG
CLOSED_FLAG
USER_HOLD_FLAG
CANCEL_FLAG
CANCELLED_BY
CANCEL_DATE
CANCEL_REASON
FIRM_STATUS_LOOKUP_CODE
PO_HEADER_ID
FIRM_DATE
VENDOR_PRODUCT_NUM
CONTRACT_NUM
TAXABLE_FLAG
TAX_NAME
TYPE_1099
CAPITAL_EXPENSE_FLAG
NEGOTIATED_BY_PREPARER_FLAG
ATTRIBUTE_CATEGORY
ATTRIBUTE1
LINE_TYPE_ID
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
REFERENCE_NUM
LINE_NUM
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
MIN_RELEASE_AMOUNT
PRICE_TYPE_LOOKUP_CODE
CLOSED_CODE
PRICE_BREAK_LOOKUP_CODE
USSGL_TRANSACTION_CODE
LAST_UPDATE_LOGIN
GOVERNMENT_CONTEXT
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
CLOSED_DATE
CLOSED_REASON
CLOSED_BY
TRANSACTION_REASON_CODE
ORG_ID
CREATION_DATE
QC_GRADE
BASE_UOM
BASE_QTY
SECONDARY_UOM
SECONDARY_QTY
GLOBAL_ATTRIBUTE_CATEGORY
GLOBAL_ATTRIBUTE1
GLOBAL_ATTRIBUTE2
GLOBAL_ATTRIBUTE3
GLOBAL_ATTRIBUTE4
CREATED_BY
GLOBAL_ATTRIBUTE5
GLOBAL_ATTRIBUTE6
GLOBAL_ATTRIBUTE7
GLOBAL_ATTRIBUTE8
GLOBAL_ATTRIBUTE9
GLOBAL_ATTRIBUTE10
GLOBAL_ATTRIBUTE11
GLOBAL_ATTRIBUTE12
GLOBAL_ATTRIBUTE13
GLOBAL_ATTRIBUTE14

Purchasing - PO_PRICE_ADJ_ATTRIBS_ARCHIVE
Column Name	Descritpion
PRICE_ADJUSTMENT_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
PRICING_ATTR_VALUE_FROM
PRICING_ATTR_VALUE_TO
COMPARISON_OPERATOR
FLEX_TITLE
PRICE_ADJ_ATTRIB_ID
LATEST_EXTERNAL_FLAG
REVISION_NUM
PRICING_CONTEXT
PRICING_ATTRIBUTE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID

Purchasing - PO_PRICE_ADJUSTMENTS_ARCHIVE
Column Name	Descritpion
PRICE_ADJUSTMENT_ID
REQUEST_ID
RETROBILL_REQUEST_ID
TAX_RATE_ID
LATEST_EXTERNAL_FLAG
REVISION_NUM
PO_HEADER_ID
AUTOMATIC_FLAG
PO_LINE_ID
ADJ_LINE_NUM
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
CREATION_DATE
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
CREATED_BY
ATTRIBUTE15
ORIG_SYS_DISCOUNT_REF
CHANGE_SEQUENCE
LIST_HEADER_ID
LIST_TYPE_CODE
LIST_LINE_ID
LIST_LINE_TYPE_CODE
MODIFIED_FROM
MODIFIED_TO
UPDATE_ALLOWED
LAST_UPDATE_DATE
CHANGE_REASON_CODE
CHANGE_REASON_TEXT
UPDATED_FLAG
APPLIED_FLAG
OPERAND
ARITHMETIC_OPERATOR
COST_ID
TAX_CODE
TAX_EXEMPT_FLAG
TAX_EXEMPT_NUMBER
LAST_UPDATED_BY
TAX_EXEMPT_REASON_CODE
PARENT_ADJUSTMENT_ID
INVOICED_FLAG
ESTIMATED_FLAG
INC_IN_SALES_PERFORMANCE
ADJUSTED_AMOUNT
PRICING_PHASE_ID
CHARGE_TYPE_CODE
CHARGE_SUBTYPE_CODE
RANGE_BREAK_QUANTITY
LAST_UPDATE_LOGIN
ACCRUAL_CONVERSION_RATE
PRICING_GROUP_SEQUENCE
ACCRUAL_FLAG
LIST_LINE_NO
SOURCE_SYSTEM_CODE
BENEFIT_QTY
BENEFIT_UOM_CODE
PRINT_ON_INVOICE_FLAG
EXPIRATION_DATE
REBATE_TRANSACTION_TYPE_CODE
PROGRAM_APPLICATION_ID
REBATE_TRANSACTION_REFERENCE
REBATE_PAYMENT_SYSTEM_CODE
REDEEMED_DATE
REDEEMED_FLAG
MODIFIER_LEVEL_CODE
PRICE_BREAK_TYPE_CODE
SUBSTITUTION_ATTRIBUTE
PRORATION_TYPE_CODE
INCLUDE_ON_RETURNS_FLAG
CREDIT_OR_CHARGE_FLAG
PROGRAM_ID
AC_CONTEXT
AC_ATTRIBUTE1
AC_ATTRIBUTE2
AC_ATTRIBUTE3
AC_ATTRIBUTE4
AC_ATTRIBUTE5
AC_ATTRIBUTE6
AC_ATTRIBUTE7
AC_ATTRIBUTE8
AC_ATTRIBUTE9
PROGRAM_UPDATE_DATE
AC_ATTRIBUTE10
AC_ATTRIBUTE11
AC_ATTRIBUTE12
AC_ATTRIBUTE13
AC_ATTRIBUTE14
AC_ATTRIBUTE15
OPERAND_PER_PQTY
ADJUSTED_AMOUNT_PER_PQTY
INTERCO_INVOICED_FLAG
INVOICED_AMOUNT

Purchasing - PO_PRICE_ADJUSTMENTS_DRAFT
Column Name	Descritpion
PRICE_ADJUSTMENT_ID
REQUEST_ID
OPERAND_PER_PQTY
ADJUSTED_AMOUNT_PER_PQTY
INTERCO_INVOICED_FLAG
INVOICED_AMOUNT
RETROBILL_REQUEST_ID
TAX_RATE_ID
PO_HEADER_ID
AUTOMATIC_FLAG
PO_LINE_ID
ADJ_LINE_NUM
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
CREATION_DATE
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
CREATED_BY
ATTRIBUTE15
ORIG_SYS_DISCOUNT_REF
CHANGE_SEQUENCE
LIST_HEADER_ID
LIST_TYPE_CODE
LIST_LINE_ID
LIST_LINE_TYPE_CODE
MODIFIED_FROM
MODIFIED_TO
UPDATE_ALLOWED
LAST_UPDATE_DATE
CHANGE_REASON_CODE
CHANGE_REASON_TEXT
UPDATED_FLAG
APPLIED_FLAG
OPERAND
ARITHMETIC_OPERATOR
COST_ID
TAX_CODE
TAX_EXEMPT_FLAG
TAX_EXEMPT_NUMBER
LAST_UPDATED_BY
TAX_EXEMPT_REASON_CODE
PARENT_ADJUSTMENT_ID
INVOICED_FLAG
ESTIMATED_FLAG
INC_IN_SALES_PERFORMANCE
ADJUSTED_AMOUNT
PRICING_PHASE_ID
CHARGE_TYPE_CODE
CHARGE_SUBTYPE_CODE
RANGE_BREAK_QUANTITY
LAST_UPDATE_LOGIN
ACCRUAL_CONVERSION_RATE
PRICING_GROUP_SEQUENCE
ACCRUAL_FLAG
LIST_LINE_NO
SOURCE_SYSTEM_CODE
BENEFIT_QTY
BENEFIT_UOM_CODE
PRINT_ON_INVOICE_FLAG
EXPIRATION_DATE
REBATE_TRANSACTION_TYPE_CODE
PROGRAM_APPLICATION_ID
REBATE_TRANSACTION_REFERENCE
REBATE_PAYMENT_SYSTEM_CODE
REDEEMED_DATE
REDEEMED_FLAG
MODIFIER_LEVEL_CODE
PRICE_BREAK_TYPE_CODE
SUBSTITUTION_ATTRIBUTE
PRORATION_TYPE_CODE
INCLUDE_ON_RETURNS_FLAG
CREDIT_OR_CHARGE_FLAG
PROGRAM_ID
AC_CONTEXT
AC_ATTRIBUTE1
AC_ATTRIBUTE2
AC_ATTRIBUTE3
AC_ATTRIBUTE4
AC_ATTRIBUTE5
AC_ATTRIBUTE6
AC_ATTRIBUTE7
AC_ATTRIBUTE8
AC_ATTRIBUTE9
PROGRAM_UPDATE_DATE
AC_ATTRIBUTE10
AC_ATTRIBUTE11
AC_ATTRIBUTE12
AC_ATTRIBUTE13
AC_ATTRIBUTE14
AC_ATTRIBUTE15
DRAFT_ID
CHANGE_ACCEPTED_FLAG
DELETE_FLAG
LOCK_CONTROL

Purchasing - PO_PRICE_ADJ_ATTRIBS_DRAFT
Column Name	Descritpion
PRICE_ADJUSTMENT_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
PRICING_ATTR_VALUE_FROM
PRICING_ATTR_VALUE_TO
COMPARISON_OPERATOR
FLEX_TITLE
PRICE_ADJ_ATTRIB_ID
DRAFT_ID
LOCK_CONTROL
PRICING_CONTEXT
PRICING_ATTRIBUTE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID

Purchasing - PO_PRICE_ADJUSTMENTS
Column Name	Descritpion
PRICE_ADJUSTMENT_ID
REQUEST_ID
INVOICED_AMOUNT
RETROBILL_REQUEST_ID
TAX_RATE_ID
PO_HEADER_ID
AUTOMATIC_FLAG
PO_LINE_ID
ADJ_LINE_NUM
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
CREATION_DATE
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
CREATED_BY
ATTRIBUTE15
ORIG_SYS_DISCOUNT_REF
CHANGE_SEQUENCE
LIST_HEADER_ID
LIST_TYPE_CODE
LIST_LINE_ID
LIST_LINE_TYPE_CODE
MODIFIED_FROM
MODIFIED_TO
UPDATE_ALLOWED
LAST_UPDATE_DATE
CHANGE_REASON_CODE
CHANGE_REASON_TEXT
UPDATED_FLAG
APPLIED_FLAG
OPERAND
ARITHMETIC_OPERATOR
COST_ID
TAX_CODE
TAX_EXEMPT_FLAG
TAX_EXEMPT_NUMBER
LAST_UPDATED_BY
TAX_EXEMPT_REASON_CODE
PARENT_ADJUSTMENT_ID
INVOICED_FLAG
ESTIMATED_FLAG
INC_IN_SALES_PERFORMANCE
ADJUSTED_AMOUNT
PRICING_PHASE_ID
CHARGE_TYPE_CODE
CHARGE_SUBTYPE_CODE
RANGE_BREAK_QUANTITY
LAST_UPDATE_LOGIN
ACCRUAL_CONVERSION_RATE
PRICING_GROUP_SEQUENCE
ACCRUAL_FLAG
LIST_LINE_NO
SOURCE_SYSTEM_CODE
BENEFIT_QTY
BENEFIT_UOM_CODE
PRINT_ON_INVOICE_FLAG
EXPIRATION_DATE
REBATE_TRANSACTION_TYPE_CODE
PROGRAM_APPLICATION_ID
REBATE_TRANSACTION_REFERENCE
REBATE_PAYMENT_SYSTEM_CODE
REDEEMED_DATE
REDEEMED_FLAG
MODIFIER_LEVEL_CODE
PRICE_BREAK_TYPE_CODE
SUBSTITUTION_ATTRIBUTE
PRORATION_TYPE_CODE
INCLUDE_ON_RETURNS_FLAG
CREDIT_OR_CHARGE_FLAG
PROGRAM_ID
AC_CONTEXT
AC_ATTRIBUTE1
AC_ATTRIBUTE2
AC_ATTRIBUTE3
AC_ATTRIBUTE4
AC_ATTRIBUTE5
AC_ATTRIBUTE6
AC_ATTRIBUTE7
AC_ATTRIBUTE8
AC_ATTRIBUTE9
PROGRAM_UPDATE_DATE
AC_ATTRIBUTE10
AC_ATTRIBUTE11
AC_ATTRIBUTE12
AC_ATTRIBUTE13
AC_ATTRIBUTE14
AC_ATTRIBUTE15
LOCK_CONTROL
OPERAND_PER_PQTY
ADJUSTED_AMOUNT_PER_PQTY
INTERCO_INVOICED_FLAG

Purchasing - PO_PRICE_ADJ_ATTRIBS
Column Name	Descritpion
PRICE_ADJUSTMENT_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
REQUEST_ID
PRICING_ATTR_VALUE_FROM
PRICING_ATTR_VALUE_TO
COMPARISON_OPERATOR
FLEX_TITLE
PRICE_ADJ_ATTRIB_ID
LOCK_CONTROL
PRICING_CONTEXT
PRICING_ATTRIBUTE
CREATION_DATE
CREATED_BY
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
PROGRAM_APPLICATION_ID

Purchasing - PO_UDA_AG_TEMPLATES
Column Name	Descritpion
TEMPLATE_ID
CREATED_BY
INTERNAL_NAME
ENTITY_CODE
EFFECTIVE_FROM_DATE
EFFECTIVE_TO_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE

Purchasing - PO_UDA_MAPPINGS
Column Name	Descritpion
DUMMY_ATTRIBUTE_GROUP_ID
PON_AUC_HEADER_GROUP_ID
BID_HEADER_GROUP_ID
BID_ITEM_PRICE_GROUP_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
PO_HEADER_GROUP_ID
PO_LINE_GROUP_ID
PO_DISTRIBUTIONS_GROUP_ID
PO_SHIPMENTS_GROUP_ID
REQ_HEADER_GROUP_ID
REQ_LINE_GROUP_ID
REQ_DISTRIBUTION_GROUP_ID
PON_AUC_ITEM_PRICE_GROUP_ID

Purchasing - PO_UDA_DUMMY_ALL
Column Name	Descritpion
DUMMY_ROW_ID

Purchasing - PO_UDA_AG_TEMPLATE_USAGES
Column Name	Descritpion
USAGE_ID
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
TEMPLATE_ID
ATTRIBUTE16
ATTRIBUTE17
ATTRIBUTE18
ATTRIBUTE19
ATTRIBUTE20
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
ATTRIBUTE_GROUP_ID
ASSOCIATION_ID
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5

Purchasing - PO_UDA_AG_TEMPLATES_TL
Column Name	Descritpion
TEMPLATE_ID
DISPLAY_NAME
LANGUAGE
SOURCE_LANG
CREATED_BY
CREATION_DATE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN

Purchasing - PO_REQ_LINES_EXT_TL
Column Name	Descritpion
EXTENSION_ID
CREATION_DATE
TL_EXT_ATTR1
TL_EXT_ATTR2
TL_EXT_ATTR3
TL_EXT_ATTR4
TL_EXT_ATTR5
TL_EXT_ATTR6
TL_EXT_ATTR7
TL_EXT_ATTR8
TL_EXT_ATTR9
ATTR_GROUP_ID
TL_EXT_ATTR10
TL_EXT_ATTR11
TL_EXT_ATTR12
TL_EXT_ATTR13
TL_EXT_ATTR14
TL_EXT_ATTR15
TL_EXT_ATTR16
TL_EXT_ATTR17
TL_EXT_ATTR18
TL_EXT_ATTR19
REQUISITION_LINE_ID
TL_EXT_ATTR20
TL_EXT_ATTR21
TL_EXT_ATTR22
TL_EXT_ATTR23
TL_EXT_ATTR24
TL_EXT_ATTR25
TL_EXT_ATTR26
TL_EXT_ATTR27
TL_EXT_ATTR28
TL_EXT_ATTR29
SOURCE_LANG
TL_EXT_ATTR30
TL_EXT_ATTR31
TL_EXT_ATTR32
TL_EXT_ATTR33
TL_EXT_ATTR34
TL_EXT_ATTR35
TL_EXT_ATTR36
TL_EXT_ATTR37
TL_EXT_ATTR38
TL_EXT_ATTR39
LANGUAGE
TL_EXT_ATTR40
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY

Purchasing - PO_REQ_DISTRIBUTIONS_EXT_TL
Column Name	Descritpion
EXTENSION_ID
CREATION_DATE
TL_EXT_ATTR1
TL_EXT_ATTR2
TL_EXT_ATTR3
TL_EXT_ATTR4
TL_EXT_ATTR5
TL_EXT_ATTR6
TL_EXT_ATTR7
TL_EXT_ATTR8
TL_EXT_ATTR9
ATTR_GROUP_ID
TL_EXT_ATTR10
TL_EXT_ATTR11
TL_EXT_ATTR12
TL_EXT_ATTR13
TL_EXT_ATTR14
TL_EXT_ATTR15
TL_EXT_ATTR16
TL_EXT_ATTR17
TL_EXT_ATTR18
TL_EXT_ATTR19
DISTRIBUTION_ID
TL_EXT_ATTR20
TL_EXT_ATTR21
TL_EXT_ATTR22
TL_EXT_ATTR23
TL_EXT_ATTR24
TL_EXT_ATTR25
TL_EXT_ATTR26
TL_EXT_ATTR27
TL_EXT_ATTR28
TL_EXT_ATTR29
SOURCE_LANG
TL_EXT_ATTR30
TL_EXT_ATTR31
TL_EXT_ATTR32
TL_EXT_ATTR33
TL_EXT_ATTR34
TL_EXT_ATTR35
TL_EXT_ATTR36
TL_EXT_ATTR37
TL_EXT_ATTR38
TL_EXT_ATTR39
LANGUAGE
TL_EXT_ATTR40
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY

Purchasing - PO_LINE_LOCATIONS_ALL_EXT_TL
Column Name	Descritpion
EXTENSION_ID
CREATION_DATE
TL_EXT_ATTR1
TL_EXT_ATTR2
TL_EXT_ATTR3
TL_EXT_ATTR4
TL_EXT_ATTR5
TL_EXT_ATTR6
TL_EXT_ATTR7
TL_EXT_ATTR8
TL_EXT_ATTR9
ATTR_GROUP_ID
TL_EXT_ATTR10
TL_EXT_ATTR11
TL_EXT_ATTR12
TL_EXT_ATTR13
TL_EXT_ATTR14
TL_EXT_ATTR15
TL_EXT_ATTR16
TL_EXT_ATTR17
TL_EXT_ATTR18
TL_EXT_ATTR19
LINE_LOCATION_ID
TL_EXT_ATTR20
TL_EXT_ATTR21
TL_EXT_ATTR22
TL_EXT_ATTR23
TL_EXT_ATTR24
TL_EXT_ATTR25
TL_EXT_ATTR26
TL_EXT_ATTR27
TL_EXT_ATTR28
TL_EXT_ATTR29
SOURCE_LANG
TL_EXT_ATTR30
TL_EXT_ATTR31
TL_EXT_ATTR32
TL_EXT_ATTR33
TL_EXT_ATTR34
TL_EXT_ATTR35
TL_EXT_ATTR36
TL_EXT_ATTR37
TL_EXT_ATTR38
TL_EXT_ATTR39
LANGUAGE
TL_EXT_ATTR40
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY

Purchasing - PO_REQ_HEADERS_EXT_TL
Column Name	Descritpion
EXTENSION_ID
CREATION_DATE
TL_EXT_ATTR1
TL_EXT_ATTR2
TL_EXT_ATTR3
TL_EXT_ATTR4
TL_EXT_ATTR5
TL_EXT_ATTR6
TL_EXT_ATTR7
TL_EXT_ATTR8
TL_EXT_ATTR9
ATTR_GROUP_ID
TL_EXT_ATTR10
TL_EXT_ATTR11
TL_EXT_ATTR12
TL_EXT_ATTR13
TL_EXT_ATTR14
TL_EXT_ATTR15
TL_EXT_ATTR16
TL_EXT_ATTR17
TL_EXT_ATTR18
TL_EXT_ATTR19
REQUISITION_HEADER_ID
TL_EXT_ATTR20
TL_EXT_ATTR21
TL_EXT_ATTR22
TL_EXT_ATTR23
TL_EXT_ATTR24
TL_EXT_ATTR25
TL_EXT_ATTR26
TL_EXT_ATTR27
TL_EXT_ATTR28
TL_EXT_ATTR29
SOURCE_LANG
TL_EXT_ATTR30
TL_EXT_ATTR31
TL_EXT_ATTR32
TL_EXT_ATTR33
TL_EXT_ATTR34
TL_EXT_ATTR35
TL_EXT_ATTR36
TL_EXT_ATTR37
TL_EXT_ATTR38
TL_EXT_ATTR39
LANGUAGE
TL_EXT_ATTR40
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY

Purchasing - PO_REQ_HEADERS_EXT_B
Column Name	Descritpion
EXTENSION_ID
LAST_UPDATE_DATE
D_EXT_ATTR6
D_EXT_ATTR7
D_EXT_ATTR8
D_EXT_ATTR9
D_EXT_ATTR10
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
C_EXT_ATTR1
C_EXT_ATTR2
C_EXT_ATTR3
C_EXT_ATTR4
C_EXT_ATTR5
ATTR_GROUP_ID
C_EXT_ATTR6
C_EXT_ATTR7
C_EXT_ATTR8
C_EXT_ATTR9
C_EXT_ATTR10
C_EXT_ATTR11
C_EXT_ATTR12
C_EXT_ATTR13
C_EXT_ATTR14
C_EXT_ATTR15
REQUISITION_HEADER_ID
C_EXT_ATTR16
C_EXT_ATTR17
C_EXT_ATTR18
C_EXT_ATTR19
C_EXT_ATTR20
C_EXT_ATTR21
C_EXT_ATTR22
C_EXT_ATTR23
C_EXT_ATTR24
C_EXT_ATTR25
DATA_LEVEL_ID
C_EXT_ATTR26
C_EXT_ATTR27
C_EXT_ATTR28
C_EXT_ATTR29
C_EXT_ATTR30
C_EXT_ATTR31
C_EXT_ATTR32
C_EXT_ATTR33
C_EXT_ATTR34
C_EXT_ATTR35
PK1_VALUE
C_EXT_ATTR36
C_EXT_ATTR37
C_EXT_ATTR38
C_EXT_ATTR39
C_EXT_ATTR40
N_EXT_ATTR1
N_EXT_ATTR2
N_EXT_ATTR3
N_EXT_ATTR4
N_EXT_ATTR5
PK2_VALUE
N_EXT_ATTR6
N_EXT_ATTR7
N_EXT_ATTR8
N_EXT_ATTR9
N_EXT_ATTR10
N_EXT_ATTR11
N_EXT_ATTR12
N_EXT_ATTR13
N_EXT_ATTR14
N_EXT_ATTR15
PK3_VALUE
N_EXT_ATTR16
N_EXT_ATTR17
N_EXT_ATTR18
N_EXT_ATTR19
N_EXT_ATTR20
UOM_EXT_ATTR1
UOM_EXT_ATTR2
UOM_EXT_ATTR3
UOM_EXT_ATTR4
UOM_EXT_ATTR5
PK4_VALUE
UOM_EXT_ATTR6
UOM_EXT_ATTR7
UOM_EXT_ATTR8
UOM_EXT_ATTR9
UOM_EXT_ATTR10
UOM_EXT_ATTR11
UOM_EXT_ATTR12
UOM_EXT_ATTR13
UOM_EXT_ATTR14
UOM_EXT_ATTR15
PK5_VALUE
UOM_EXT_ATTR16
UOM_EXT_ATTR17
UOM_EXT_ATTR18
UOM_EXT_ATTR19
UOM_EXT_ATTR20
D_EXT_ATTR1
D_EXT_ATTR2
D_EXT_ATTR3
D_EXT_ATTR4
D_EXT_ATTR5

Purchasing - PO_REQ_LINES_EXT_B
Column Name	Descritpion
EXTENSION_ID
LAST_UPDATE_DATE
D_EXT_ATTR6
D_EXT_ATTR7
D_EXT_ATTR8
D_EXT_ATTR9
D_EXT_ATTR10
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
C_EXT_ATTR1
C_EXT_ATTR2
C_EXT_ATTR3
C_EXT_ATTR4
C_EXT_ATTR5
ATTR_GROUP_ID
C_EXT_ATTR6
C_EXT_ATTR7
C_EXT_ATTR8
C_EXT_ATTR9
C_EXT_ATTR10
C_EXT_ATTR11
C_EXT_ATTR12
C_EXT_ATTR13
C_EXT_ATTR14
C_EXT_ATTR15
REQUISITION_LINE_ID
C_EXT_ATTR16
C_EXT_ATTR17
C_EXT_ATTR18
C_EXT_ATTR19
C_EXT_ATTR20
C_EXT_ATTR21
C_EXT_ATTR22
C_EXT_ATTR23
C_EXT_ATTR24
C_EXT_ATTR25
DATA_LEVEL_ID
C_EXT_ATTR26
C_EXT_ATTR27
C_EXT_ATTR28
C_EXT_ATTR29
C_EXT_ATTR30
C_EXT_ATTR31
C_EXT_ATTR32
C_EXT_ATTR33
C_EXT_ATTR34
C_EXT_ATTR35
PK1_VALUE
C_EXT_ATTR36
C_EXT_ATTR37
C_EXT_ATTR38
C_EXT_ATTR39
C_EXT_ATTR40
N_EXT_ATTR1
N_EXT_ATTR2
N_EXT_ATTR3
N_EXT_ATTR4
N_EXT_ATTR5
PK2_VALUE
N_EXT_ATTR6
N_EXT_ATTR7
N_EXT_ATTR8
N_EXT_ATTR9
N_EXT_ATTR10
N_EXT_ATTR11
N_EXT_ATTR12
N_EXT_ATTR13
N_EXT_ATTR14
N_EXT_ATTR15
PK3_VALUE
N_EXT_ATTR16
N_EXT_ATTR17
N_EXT_ATTR18
N_EXT_ATTR19
N_EXT_ATTR20
UOM_EXT_ATTR1
UOM_EXT_ATTR2
UOM_EXT_ATTR3
UOM_EXT_ATTR4
UOM_EXT_ATTR5
PK4_VALUE
UOM_EXT_ATTR6
UOM_EXT_ATTR7
UOM_EXT_ATTR8
UOM_EXT_ATTR9
UOM_EXT_ATTR10
UOM_EXT_ATTR11
UOM_EXT_ATTR12
UOM_EXT_ATTR13
UOM_EXT_ATTR14
UOM_EXT_ATTR15
PK5_VALUE
UOM_EXT_ATTR16
UOM_EXT_ATTR17
UOM_EXT_ATTR18
UOM_EXT_ATTR19
UOM_EXT_ATTR20
D_EXT_ATTR1
D_EXT_ATTR2
D_EXT_ATTR3
D_EXT_ATTR4
D_EXT_ATTR5

Purchasing - PO_REQ_DISTRIBUTIONS_EXT_B
Column Name	Descritpion
EXTENSION_ID
LAST_UPDATE_DATE
D_EXT_ATTR6
D_EXT_ATTR7
D_EXT_ATTR8
D_EXT_ATTR9
D_EXT_ATTR10
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
C_EXT_ATTR1
C_EXT_ATTR2
C_EXT_ATTR3
C_EXT_ATTR4
C_EXT_ATTR5
ATTR_GROUP_ID
C_EXT_ATTR6
C_EXT_ATTR7
C_EXT_ATTR8
C_EXT_ATTR9
C_EXT_ATTR10
C_EXT_ATTR11
C_EXT_ATTR12
C_EXT_ATTR13
C_EXT_ATTR14
C_EXT_ATTR15
DISTRIBUTION_ID
C_EXT_ATTR16
C_EXT_ATTR17
C_EXT_ATTR18
C_EXT_ATTR19
C_EXT_ATTR20
C_EXT_ATTR21
C_EXT_ATTR22
C_EXT_ATTR23
C_EXT_ATTR24
C_EXT_ATTR25
DATA_LEVEL_ID
C_EXT_ATTR26
C_EXT_ATTR27
C_EXT_ATTR28
C_EXT_ATTR29
C_EXT_ATTR30
C_EXT_ATTR31
C_EXT_ATTR32
C_EXT_ATTR33
C_EXT_ATTR34
C_EXT_ATTR35
PK1_VALUE
C_EXT_ATTR36
C_EXT_ATTR37
C_EXT_ATTR38
C_EXT_ATTR39
C_EXT_ATTR40
N_EXT_ATTR1
N_EXT_ATTR2
N_EXT_ATTR3
N_EXT_ATTR4
N_EXT_ATTR5
PK2_VALUE
N_EXT_ATTR6
N_EXT_ATTR7
N_EXT_ATTR8
N_EXT_ATTR9
N_EXT_ATTR10
N_EXT_ATTR11
N_EXT_ATTR12
N_EXT_ATTR13
N_EXT_ATTR14
N_EXT_ATTR15
PK3_VALUE
N_EXT_ATTR16
N_EXT_ATTR17
N_EXT_ATTR18
N_EXT_ATTR19
N_EXT_ATTR20
UOM_EXT_ATTR1
UOM_EXT_ATTR2
UOM_EXT_ATTR3
UOM_EXT_ATTR4
UOM_EXT_ATTR5
PK4_VALUE
UOM_EXT_ATTR6
UOM_EXT_ATTR7
UOM_EXT_ATTR8
UOM_EXT_ATTR9
UOM_EXT_ATTR10
UOM_EXT_ATTR11
UOM_EXT_ATTR12
UOM_EXT_ATTR13
UOM_EXT_ATTR14
UOM_EXT_ATTR15
PK5_VALUE
UOM_EXT_ATTR16
UOM_EXT_ATTR17
UOM_EXT_ATTR18
UOM_EXT_ATTR19
UOM_EXT_ATTR20
D_EXT_ATTR1
D_EXT_ATTR2
D_EXT_ATTR3
D_EXT_ATTR4
D_EXT_ATTR5

Purchasing - PO_LINE_LOCATIONS_ALL_EXT_B
Column Name	Descritpion
EXTENSION_ID
LAST_UPDATE_DATE
D_EXT_ATTR6
D_EXT_ATTR7
D_EXT_ATTR8
D_EXT_ATTR9
D_EXT_ATTR10
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
C_EXT_ATTR1
C_EXT_ATTR2
C_EXT_ATTR3
C_EXT_ATTR4
C_EXT_ATTR5
ATTR_GROUP_ID
C_EXT_ATTR6
C_EXT_ATTR7
C_EXT_ATTR8
C_EXT_ATTR9
C_EXT_ATTR10
C_EXT_ATTR11
C_EXT_ATTR12
C_EXT_ATTR13
C_EXT_ATTR14
C_EXT_ATTR15
LINE_LOCATION_ID
C_EXT_ATTR16
C_EXT_ATTR17
C_EXT_ATTR18
C_EXT_ATTR19
C_EXT_ATTR20
C_EXT_ATTR21
C_EXT_ATTR22
C_EXT_ATTR23
C_EXT_ATTR24
C_EXT_ATTR25
DATA_LEVEL_ID
C_EXT_ATTR26
C_EXT_ATTR27
C_EXT_ATTR28
C_EXT_ATTR29
C_EXT_ATTR30
C_EXT_ATTR31
C_EXT_ATTR32
C_EXT_ATTR33
C_EXT_ATTR34
C_EXT_ATTR35
PK1_VALUE
C_EXT_ATTR36
C_EXT_ATTR37
C_EXT_ATTR38
C_EXT_ATTR39
C_EXT_ATTR40
N_EXT_ATTR1
N_EXT_ATTR2
N_EXT_ATTR3
N_EXT_ATTR4
N_EXT_ATTR5
PK2_VALUE
N_EXT_ATTR6
N_EXT_ATTR7
N_EXT_ATTR8
N_EXT_ATTR9
N_EXT_ATTR10
N_EXT_ATTR11
N_EXT_ATTR12
N_EXT_ATTR13
N_EXT_ATTR14
N_EXT_ATTR15
PK3_VALUE
N_EXT_ATTR16
N_EXT_ATTR17
N_EXT_ATTR18
N_EXT_ATTR19
N_EXT_ATTR20
UOM_EXT_ATTR1
UOM_EXT_ATTR2
UOM_EXT_ATTR3
UOM_EXT_ATTR4
UOM_EXT_ATTR5
PK4_VALUE
UOM_EXT_ATTR6
UOM_EXT_ATTR7
UOM_EXT_ATTR8
UOM_EXT_ATTR9
UOM_EXT_ATTR10
UOM_EXT_ATTR11
UOM_EXT_ATTR12
UOM_EXT_ATTR13
UOM_EXT_ATTR14
UOM_EXT_ATTR15
PK5_VALUE
UOM_EXT_ATTR16
UOM_EXT_ATTR17
UOM_EXT_ATTR18
UOM_EXT_ATTR19
UOM_EXT_ATTR20
D_EXT_ATTR1
D_EXT_ATTR2
D_EXT_ATTR3
D_EXT_ATTR4
D_EXT_ATTR5

Purchasing - PO_UDA_DUMMY_ALL_EXT_TL
Column Name	Descritpion
EXTENSION_ID
CREATION_DATE
TL_EXT_ATTR1
TL_EXT_ATTR2
TL_EXT_ATTR3
TL_EXT_ATTR4
TL_EXT_ATTR5
TL_EXT_ATTR6
TL_EXT_ATTR7
TL_EXT_ATTR8
TL_EXT_ATTR9
ATTR_GROUP_ID
TL_EXT_ATTR10
TL_EXT_ATTR11
TL_EXT_ATTR12
TL_EXT_ATTR13
TL_EXT_ATTR14
TL_EXT_ATTR15
TL_EXT_ATTR16
TL_EXT_ATTR17
TL_EXT_ATTR18
TL_EXT_ATTR19
DUMMY_ROW_ID
TL_EXT_ATTR20
TL_EXT_ATTR21
TL_EXT_ATTR22
TL_EXT_ATTR23
TL_EXT_ATTR24
TL_EXT_ATTR25
TL_EXT_ATTR26
TL_EXT_ATTR27
TL_EXT_ATTR28
TL_EXT_ATTR29
SOURCE_LANG
TL_EXT_ATTR30
TL_EXT_ATTR31
TL_EXT_ATTR32
TL_EXT_ATTR33
TL_EXT_ATTR34
TL_EXT_ATTR35
TL_EXT_ATTR36
TL_EXT_ATTR37
TL_EXT_ATTR38
TL_EXT_ATTR39
LANGUAGE
TL_EXT_ATTR40
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY

Purchasing - PO_UDA_DUMMY_ALL_EXT_B
Column Name	Descritpion
EXTENSION_ID
LAST_UPDATE_DATE
D_EXT_ATTR6
D_EXT_ATTR7
D_EXT_ATTR8
D_EXT_ATTR9
D_EXT_ATTR10
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATED_BY
CREATION_DATE
C_EXT_ATTR1
C_EXT_ATTR2
C_EXT_ATTR3
C_EXT_ATTR4
C_EXT_ATTR5
ATTR_GROUP_ID
C_EXT_ATTR6
C_EXT_ATTR7
C_EXT_ATTR8
C_EXT_ATTR9
C_EXT_ATTR10
C_EXT_ATTR11
C_EXT_ATTR12
C_EXT_ATTR13
C_EXT_ATTR14
C_EXT_ATTR15
DUMMY_ROW_ID
C_EXT_ATTR16
C_EXT_ATTR17
C_EXT_ATTR18
C_EXT_ATTR19
C_EXT_ATTR20
C_EXT_ATTR21
C_EXT_ATTR22
C_EXT_ATTR23
C_EXT_ATTR24
C_EXT_ATTR25
DATA_LEVEL_ID
C_EXT_ATTR26
C_EXT_ATTR27
C_EXT_ATTR28
C_EXT_ATTR29
C_EXT_ATTR30
C_EXT_ATTR31
C_EXT_ATTR32
C_EXT_ATTR33
C_EXT_ATTR34
C_EXT_ATTR35
PK1_VALUE
C_EXT_ATTR36
C_EXT_ATTR37
C_EXT_ATTR38
C_EXT_ATTR39
C_EXT_ATTR40
N_EXT_ATTR1
N_EXT_ATTR2
N_EXT_ATTR3
N_EXT_ATTR4
N_EXT_ATTR5
PK2_VALUE
N_EXT_ATTR6
N_EXT_ATTR7
N_EXT_ATTR8
N_EXT_ATTR9
N_EXT_ATTR10
N_EXT_ATTR11
N_EXT_ATTR12
N_EXT_ATTR13
N_EXT_ATTR14
N_EXT_ATTR15
PK3_VALUE
N_EXT_ATTR16
N_EXT_ATTR17
N_EXT_ATTR18
N_EXT_ATTR19
N_EXT_ATTR20
UOM_EXT_ATTR1
UOM_EXT_ATTR2
UOM_EXT_ATTR3
UOM_EXT_ATTR4
UOM_EXT_ATTR5
PK4_VALUE
UOM_EXT_ATTR6
UOM_EXT_ATTR7
UOM_EXT_ATTR8
UOM_EXT_ATTR9
UOM_EXT_ATTR10
UOM_EXT_ATTR11
UOM_EXT_ATTR12
UOM_EXT_ATTR13
UOM_EXT_ATTR14
UOM_EXT_ATTR15
PK5_VALUE
UOM_EXT_ATTR16
UOM_EXT_ATTR17
UOM_EXT_ATTR18
UOM_EXT_ATTR19
UOM_EXT_ATTR20
D_EXT_ATTR1
D_EXT_ATTR2
D_EXT_ATTR3
D_EXT_ATTR4
D_EXT_ATTR5