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

Purchasing - PO_WF_DEBUG	This table is reserved for use by Oracle only
Column Name	Descritpion
DOCUMENT_ID	Document identifier of the document submitted to this workflow
DOCUMENT_NUMBER	Document number of the document submitted to this workflow
PREPARER_ID	Preparer identifier for the document submitted to this workflow
APPROVER_EMPID	Employee ID of the approver of the document submitted to this workflow
FORWARD_TO_ID	Identifier of the forward-to person for the document submitted to this workflow
EXECUTION_SEQUENCE	Sequence in which the debugging messages were logged
FORWARD_TO_USERNAME	Username of the forward-to person for the document submitted to this workflow
FORWARD_FROM_ID	Identifier of the person who has forwarded this document
FORWARD_FROM_USERNAME	Username of the person who has forwarded this document
AUTHORIZATION_STATUS	Approval status of the document
DEBUG_MESSAGE	The message logged with this entry in the debugging table. Has important debugging information.
EXECUTION_DATE	Date on which the debug message was logged
ITEMTYPE	Workflow item type
ITEMKEY	Workflow item key

Purchasing - RCV_HEADERS_INTERFACE	RCV_HEADERS_INTERFACE is the interface table that stores receiving header information.
Column Name	Descritpion
RECEIPT_SOURCE_CODE	Source type of the shipment
HAZARD_CLASS	Hazardous material class of the shipment
HAZARD_DESCRIPTION	Hazardous material description
FREIGHT_TERMS	Freight Payment Method (user defined, e.g. Prepaid, Collect)
FREIGHT_BILL_NUMBER	Freight bill (PRO invoice) number
INVOICE_NUM	EDI transaction 857 invoice number associated with the shipment/billing notice (ASN with billing information)
INVOICE_DATE	EDI transaction 857 invoice date associated with the shipment/billing notice
TOTAL_INVOICE_AMOUNT	EDI transaction 857 invoice amount associated with the shipment/billing notice
TAX_NAME	EDI transaction 857 tax name associated with the shipment/billing notice
TAX_AMOUNT	EDI transaction 857 tax amount associated with the shipment/billing notice name indicated at the header level
FREIGHT_AMOUNT	EDI transaction 857 freight bill amount associated with the shipment/billing notice
ASN_TYPE	The document type: values are ASN, ASBN, or RECEIVE
CURRENCY_CODE	EDI transaction 857 currency code
CONVERSION_RATE_TYPE	EDI transaction 857 exchange rate type
CONVERSION_RATE	EDI transaction 857 exchange rate
CONVERSION_RATE_DATE	EDI transaction 857 exchange rate date
PAYMENT_TERMS_NAME	EDI transaction 857 payment terms name
PAYMENT_TERMS_ID	EDI transaction 857 payment terms unique identifier
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
TRANSACTION_TYPE	The transaction purpose code: values are NEW, REPLACE, ADD, or CANCEL
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
AUTO_TRANSACT_CODE	Automatic transaction creation code of the shipment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
USGGL_TRANSACTION_CODE	United States standard general ledger transaction code
EMPLOYEE_NAME	Employee's name
EMPLOYEE_ID	Employee's unique identifier
INVOICE_STATUS_CODE	For ASN with billing information (ASBN) only, indicates when line items were rejected
VALIDATION_FLAG	Marked after open interface validation
PROCESSING_REQUEST_ID	Unique identifier for the request
CUSTOMER_ACCOUNT_NUMBER	Unique identifier for the request
TEST_FLAG	Flag indicating transaction is in test mode
CUSTOMER_ID	Unique identifier for the request
CUSTOMER_SITE_ID	Unique identifier for the request
CUSTOMER_PARTY_NAME	Customer Name
REMIT_TO_SITE_ID	Remit To Site Id
HEADER_INTERFACE_ID	Interface EDI header unique identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ORG_ID	Organization identifier
OPERATING_UNIT	Operating Unit Name used to derive ORG_ID
SHIP_FROM_LOCATION_ID	Ship From Location Unique Identifier
PERFORMANCE_PERIOD_FROM	Work Confirmation's Performance period from
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PERFORMANCE_PERIOD_TO	Work Confirmation's Performance period to
REQUEST_DATE	Work Confirmation Request date
SHIP_FROM_LOCATION_CODE	Ship from location code
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).
TRANSACTION_DATE	Transaction date
NOTICE_CREATION_DATE	EDI transaction creation date/time at source if importing data via EDI
SHIPMENT_NUM	Shipment number assigned by the shipment's source
RECEIPT_NUM	Receipt number
RECEIPT_HEADER_ID	Receipt system ID
VENDOR_NAME	Supplier name from ASN; used to derive VENDOR_ID
GROUP_ID	Interface group for set processing
VENDOR_NUM	Supplier Num from ASN; used to derive VENDOR_ID
VENDOR_ID	Source supplier unique ID
VENDOR_SITE_CODE	Supplier site code from ASN; used to derive VENDOR_SITE_ID
VENDOR_SITE_ID	Source supplier site unique identifier
FROM_ORGANIZATION_CODE	Source organization code; used to derive from ORGANIZATION_ID
FROM_ORGANIZATION_ID	Source organization unique identifier (internal transfers only)
SHIP_TO_ORGANIZATION_CODE	Ship-to organization code
SHIP_TO_ORGANIZATION_ID	Ship-to organization unique identifier
LOCATION_CODE	Ship-to/receiving location code
LOCATION_ID	Receiving location unique identifier
EDI_CONTROL_NUM	EDI transaction control number if data is sent via EDI
BILL_OF_LADING	Bill of lading number
PACKING_SLIP	Packing slip number
SHIPPED_DATE	Shipped date
FREIGHT_CARRIER_CODE	Carrier responsible for shipment
EXPECTED_RECEIPT_DATE	Expected arrival date of the shipment
RECEIVER_ID	Employee unique identifier
NUM_OF_CONTAINERS	Number of containers in the shipment
WAYBILL_AIRBILL_NUM	Waybill or airbill number
COMMENTS	Receiver's comments
GROSS_WEIGHT	Shipment gross weight from ASN
PROCESSING_STATUS_CODE	Processing status of the interface header row
GROSS_WEIGHT_UOM_CODE	Shipment gross weight unit of measure from ASN
NET_WEIGHT	Shipment net weight from ASN
NET_WEIGHT_UOM_CODE	Shipment net weight unit of measure from ASN
TAR_WEIGHT	Shipment tar (container) weight from ASN
TAR_WEIGHT_UOM_CODE	Shipment tar (container) weight unit of measure from ASN
PACKAGING_CODE	Shipment packing code
CARRIER_METHOD	Carrier transportation method code
CARRIER_EQUIPMENT	Carrier equipment description code
SPECIAL_HANDLING_CODE	Special handling code
HAZARD_CODE	Hazardous material qualifier code of the shipment

Purchasing - RCV_LOTS_INTERFACE	Receiving lots interface table
Column Name	Descritpion
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).
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).
LOT_NUM	Lot number
QUANTITY	Lot quantity in transaction unit of measure
TRANSACTION_DATE	Transaction date
EXPIRATION_DATE	Lot number expiration date
PRIMARY_QUANTITY	Lot quantity in terms of the item's primary unit of measure
ITEM_ID	Item unique identifier
SHIPMENT_LINE_ID	Unique identifier of receipt shipment line
SUBLOT_NUM	Sublot number
INTERFACE_TRANSACTION_ID	Interface transaction unique identifier
SECONDARY_QUANTITY	Transaction lot quantity in transaction secondary unit of measure
QC_GRADE	Lot quality grade of the item received
REASON_CODE	Reason Code
PARENT_LOT_NUMBER	Parent Lot Number
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.

Purchasing - RCV_LOTS_SUPPLY	Receiving lots supply
Column Name	Descritpion
PRIMARY_QUANTITY	Lot quantity in terms of the item's primary unit of measure
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).
SUPPLY_TYPE_CODE	Lot number supply context
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).
SHIPMENT_LINE_ID	Receipt shipment line unique identifier
TRANSACTION_ID	Receiving transaction unique identifier
EXPIRATION_DATE	Lot expiration date
LOT_NUM	Lot number
SECONDARY_QUANTITY	Receiving transaction unique identifier
SUBLOT_NUM	Sublot Number
REASON_CODE	Reason Code
REASON_ID	Reason Identifier
QUANTITY	Lot quantity in terms of the item's primary unit of measure

Purchasing - RCV_LOT_TRANSACTIONS	Receiving lots transactions
Column Name	Descritpion
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).
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).
LOT_TRANSACTION_TYPE	Lot transaction context
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).
SHIPMENT_LINE_ID	Receipt shipment line unique identifier
TRANSACTION_ID	Transaction unique identifier
TRANSACTION_DATE	Transaction date
EXPIRATION_DATE	Lot number expiration date
SOURCE_TRANSACTION_ID	Source transaction unique identifier
CORRECTION_TRANSACTION_ID	Correction transaction unique identifier
ITEM_ID	Unique inventory item identifier
LOT_NUM	Lot number
SUBLOT_NUM	Sublot number
SECONDARY_QUANTITY	Lot quantity in secondary unit of measure
QC_GRADE	Lot level quality grade
REASON_CODE	Reason Code
QUANTITY	Lot quantity
PRIMARY_QUANTITY	Lot quantity in terms of the item's primary unit of measure
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).

Purchasing - RCV_MC_REC_SUB_LEDGER	MRC sub-table of RCV_RECEIVING_SUB_LEDGER
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
JE_CATEGORY_NAME	Journal entry category
SET_OF_BOOKS_ID	Accounting books defining column
ACCOUNTING_DATE	Effective transaction date
CODE_COMBINATION_ID	GL account unique identifier
ACCOUNTED_DR	Debit amount in base currency
ACCOUNTED_CR	Credit amount in base currency
ENCUMBRANCE_TYPE_ID	Encumbrance batch defining column
ENTERED_DR	Debit amount in entered currency
ENTERED_CR	Credit amount in entered currency
BUDGET_VERSION_ID	Budget version defining column
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CURRENCY_CONVERSION_DATE	Currency conversion date
USER_CURRENCY_CONVERSION_TYPE	Currency exchange rate type
CURRENCY_CONVERSION_RATE	Currency exchange rate
TRANSACTION_DATE	Transaction date
PERIOD_NAME	Accounting period name
CHART_OF_ACCOUNTS_ID	Chart of accounts unique identifier
FUNCTIONAL_CURRENCY_CODE	Base currency unique identifier
DATE_CREATED_IN_GL	Effective date of accounting entry
JE_BATCH_NAME	Journal entry batch name
JE_BATCH_DESCRIPTION	Journal entry batch description
CREATION_DATE	Standard who column - date when this row was created.
JE_HEADER_NAME	Journal entry header name
JE_LINE_DESCRIPTION	Journal entry line description
REVERSE_JOURNAL_FLAG	Indicates that this journal should be reversed
REVERSAL_PERIOD_NAME	Accounting period for reversing journal entry
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
CREATED_BY	Standard who column - user who created 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
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).
SUBLEDGER_DOC_SEQUENCE_ID	Subledger document sequence identifier
SUBLEDGER_DOC_SEQUENCE_VALUE	Subledger document sequence value
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
REFERENCE1	Subledger reference column
REFERENCE2	Subledger reference column
REFERENCE3	Subledger reference column
RCV_TRANSACTION_ID	Receiving transaction unique identifier
REFERENCE4	Subledger reference column
REFERENCE5	Subledger reference column
REFERENCE6	Subledger reference column
REFERENCE7	Subledger reference column
REFERENCE8	Subledger reference column
REFERENCE9	Subledger reference column
REFERENCE10	Subledger reference column
SOURCE_DOC_QUANTITY	Quantity from source document
RECOVERABLE_TAX	Recoverable tax amount on the document
NONRECOVERABLE_TAX	Nonrecoverable tax amount on the document
CURRENCY_CODE	Currency unique identifier
ACCRUAL_METHOD_FLAG	Indicator of whether an accrual method was specified
GL_SL_LINK_ID	Unique identifier for the link between the general ledger and the subledger
ENTERED_REC_TAX	Recoverable tax in entered currency
ENTERED_NR_TAX	Nonrecoverable tax amount in entered currency
ACCOUNTED_REC_TAX	Accounted recoverable tax amount
ACCOUNTED_NR_TAX	Accounted nonrecoverable tax amount
RCV_SUB_LEDGER_ID	Receiving subledger unique identifier
ACCOUNTING_EVENT_ID	accounting event id
ACCOUNTING_LINE_TYPE	Accounting Line Type
PA_ADDITION_FLAG	Flag that indicates if project related receipts have been transferred to Oracle Projects
ACTUAL_FLAG	Balance type (ACTUAL, BUDGET or ENCUMBRANCE)
JE_SOURCE_NAME	Journal entry source

Purchasing - RCV_MC_SHIPMENT_HEADERS	MRC sub-table of RCV_SHIPMENT_HEADERS
Column Name	Descritpion
SET_OF_BOOKS_ID	Set of Books identifier
SHIPMENT_HEADER_ID	Receipt header identifier
CONVERSION_RATE_TYPE	Conversion type for the exchange rate
CONVERSION_DATE	Conversion date for the exchange rate
CONVERSION_RATE	Currency conversion rate used to convert the transactional currency amount to reporting currency amount

Purchasing - RCV_MC_SHIPMENT_LINES	MRC sub-table of RCV_SHIPMENT_LINES
Column Name	Descritpion
SHIPMENT_LINE_ID	Receipt line identifier
SET_OF_BOOKS_ID	Set of Books identifier
SHIPMENT_UNIT_PRICE	Item unit price
TRANSFER_COST	Intransit transfer cost
TRANSPORTATION_COST	Intransit transportation cost
NOTICE_UNIT_PRICE	EDI transaction 857 unit price of this item

Purchasing - RCV_MC_TRANSACTIONS	MRC sub-table of RCV_TRANSACTIONS
Column Name	Descritpion
SET_OF_BOOKS_ID	Set of Books identifier
TRANSACTION_ID	Receipt transaction identifier
CURRENCY_CONVERSION_TYPE	Conversion type for the exchange rate
CURRENCY_CONVERSION_DATE	Conversion date for the exchange rate
CURRENCY_CONVERSION_RATE	Currency conversion rate used to convert the transactional currency amount to reporting currency amount

Purchasing - RCV_PARAMETERS	Organization-level receiving controls
Column Name	Descritpion
QTY_RCV_EXCEPTION_CODE	Receiving quantity tolerance exception level
CLEARING_ACCOUNT_ID	Clearing Account Identifier
RETROPRICE_ADJ_ACCOUNT_ID	Retroactive pricing account identifier
ENFORCE_RMA_SERIAL_NUM	Enforce Serial Numbers as on RMA
ENFORCE_SHIP_TO_LOCATION_CODE	Ship-to location control exception level
RMA_RECEIPT_ROUTING_ID	Receipt Routing Id for RMA's
ENFORCE_RMA_LOT_NUM	Enforce Lot Numbers as on RMA
ADVANCED_PRICING	Flag to identify if Advanced Pricing is used to capture Charges.
TRANSPORTATION_EXECUTION	Flag to identify if Transportation Execution is used to estimate charges.
ALLOW_EXPRESS_DELIVERY_FLAG	Allow express delivery of items
PRE_RECEIVE	Flag to indicate if pre-receive lcm flow is allowed or not.
LCM_ACCOUNT_ID	Landed Cost Absorption Account Identifier
INV_VARIANCE_ACCOUNT_ID	Invoice Variance Account Identifier
EXCHANGE_VARIANCE_ACCOUNT_ID	Exchange Variance Account Identifier
DAYS_EARLY_RECEIPT_ALLOWED	Number of days allowed for an early receipt
TAX_VARIANCE_ACCOUNT_ID	Tax Variance Account Identifier
DEF_CHARGES_ACCOUNT_ID	Default Charges Account Identifier
DAYS_LATE_RECEIPT_ALLOWED	Number of days allowed for a late receipt
ORGANIZATION_ID	Organization identifier
RECEIPT_DAYS_EXCEPTION_CODE	Receipt days exception level
RECEIVING_ROUTING_ID	Routing header identifier
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	Allow receipt of substitute items
ALLOW_UNORDERED_RECEIPTS_FLAG	Allow receipt of unordered items
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
BLIND_RECEIVING_FLAG	Use blind receiving
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).
RECEIVING_ACCOUNT_ID	Receiving account identifier
ALLOW_CASCADE_TRANSACTIONS	Allow cascade delivery of items
GLOBAL_ATTRIBUTE1	Reserved for country-specific functionality
GLOBAL_ATTRIBUTE2	Reserved for country-specific functionality
CREATION_DATE	Standard who column - date when this row was created.
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
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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
LAST_UPDATED_LOGIN	Standard Who column
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
QTY_RCV_TOLERANCE	Receiving quantity tolerance
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
RECEIPT_ASN_EXISTS_CODE	This field holds the action to be taken when the user selects a purchase order shipment even though an Advance Shipment Notice (ASN) exists
USER_DEFINED_RECEIPT_NUM_CODE	Code for receipt number generation - Manual or Automatic
MANUAL_RECEIPT_NUM_TYPE	Type of numbers being generated for manual setting - Numeric or Alphanumeric
NEXT_RECEIPT_NUM	Number for the next receipt

Purchasing - RCV_RECEIVING_SUB_LEDGER	Receiving subledger
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
ACTUAL_FLAG	Balance type (ACTUAL, BUDGET, or ENCUMBRANCE)
JE_SOURCE_NAME	Journal entry source
JE_CATEGORY_NAME	Journal entry category
SET_OF_BOOKS_ID	Accounting books defining column
ACCOUNTING_DATE	Effective transaction date
CODE_COMBINATION_ID	GL account unique identifier
ACCOUNTED_DR	Debit amount in base currency
ACCOUNTED_CR	Credit amount in base currency
ENCUMBRANCE_TYPE_ID	Encumbrance batch defining column
ENTERED_DR	Debit amount in entered currency
ENTERED_CR	Credit amount in entered currency
BUDGET_VERSION_ID	Budget version defining column
CURRENCY_CONVERSION_DATE	Currency conversion date
USER_CURRENCY_CONVERSION_TYPE	Currency exchange rate type
CURRENCY_CONVERSION_RATE	Currency exchange rate
TRANSACTION_DATE	Transaction date
PERIOD_NAME	Accounting period name
CHART_OF_ACCOUNTS_ID	Chart of accounts unique identifier
FUNCTIONAL_CURRENCY_CODE	Base currency unique identifier
DATE_CREATED_IN_GL	Effective date of accounting entry
JE_BATCH_NAME	Journal entry batch name
JE_BATCH_DESCRIPTION	Journal entry batch description
JE_HEADER_NAME	Journal entry header name
JE_LINE_DESCRIPTION	Journal entry line description
REVERSE_JOURNAL_FLAG	Indicates that this journal should be reversed
REVERSAL_PERIOD_NAME	Accounting period for reversing journal entry
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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
RCV_SUB_LEDGER_ID	Receiving subledger unique identifier
CREATION_DATE	Standard who column - date when this row was created.
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).
SUBLEDGER_DOC_SEQUENCE_ID	Subledger document sequence identifier
SUBLEDGER_DOC_SEQUENCE_VALUE	Subledger document sequence value
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
REFERENCE1	Subledger reference column
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
REFERENCE2	Subledger reference column
REFERENCE3	Subledger reference column
REFERENCE4	Subledger reference column
REFERENCE5	Subledger reference column
REFERENCE6	Subledger reference column
REFERENCE7	Subledger reference column
REFERENCE8	Subledger reference column
REFERENCE9	Subledger reference column
REFERENCE10	Subledger reference column
SOURCE_DOC_QUANTITY	Quantity from source document
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
ACCRUAL_METHOD_FLAG	Indicator of whether an accrual method was specified
GL_SL_LINK_ID	Unique identifier for the link between the general ledger and the subledger
ENTERED_REC_TAX	Recoverable tax amount on the document
ENTERED_NR_TAX	Nonrecoverable tax amount on the document
ACCOUNTED_REC_TAX	Accounted recoverable tax
ACCOUNTED_NR_TAX	Accounted nonrecoverable tax
ACCOUNTING_EVENT_ID	Accounting Event Identifier
ACCOUNTING_LINE_TYPE	Accounting Line Type
PA_ADDITION_FLAG	Flag that indicates if project related receipts have been transferred to Oracle Projects
RCV_TRANSACTION_ID	Receiving transaction unique identifier
CURRENCY_CODE	Currency unique identifier

Purchasing - RCV_ROUTING_HEADERS	Receiving routing headers
Column Name	Descritpion
ATTRIBUTE_CATEGORY	Descriptive flexfield segment
ROUTING_HEADER_ID	Receiving routing unique identifier
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
ATTRIBUTE5	Descriptive flexfield segment
LAST_UPDATE_DATE	Standard Who column
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
LAST_UPDATED_BY	Standard Who column
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
CREATION_DATE	Standard Who column
REQUEST_ID	Standard Who column
PROGRAM_APPLICATION_ID	Standard Who column
PROGRAM_ID	Standard Who column
PROGRAM_UPDATE_DATE	Standard Who column
DESCRIPTION	Receiving routing description
CREATED_BY	Standard Who column
LAST_UPDATE_LOGIN	Standard Who column
ROUTING_NAME	Receiving routing name

Purchasing - RCV_ROUTING_STEPS	Receiving routing steps
Column Name	Descritpion
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).
ROUTING_STEP_ID	Not currently used
TRANSACTION_TYPE_CODE	Identifies the type of transaction
DESCRIPTION	Description
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
ROUTING_HEADER_ID	Receiving routing unique identifier
ATTRIBUTE6	Descriptive flexfield segment
ATTRIBUTE7	Descriptive flexfield segment
ATTRIBUTE8	Descriptive flexfield segment
ATTRIBUTE9	Descriptive flexfield segment
ATTRIBUTE10	Descriptive flexfield segment
STEP_NAME	Upgrade step unique identifier
ATTRIBUTE11	Descriptive flexfield segment
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
STEP_NUM	Sequence number in the formula
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 - RCV_SERIALS_INTERFACE	Receiving serial interface table
Column Name	Descritpion
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).
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).
INTERFACE_TRANSACTION_ID	Interface transaction unique identifier
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
TRANSACTION_DATE	Serial transaction date
FM_SERIAL_NUM	Start of serial number range
TO_SERIAL_NUM	End of serial number range
SERIAL_PREFIX	Total serial numbers entered
LOT_NUM	Lot number that serial numbers belong to
VENDOR_SERIAL_NUM	Not currently used
VENDOR_LOT_NUM	Not currently used
ITEM_ID	Item that serial number is assigned to
ORGANIZATION_ID	Organization that serial number is assigned to
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.

Purchasing - RCV_SERIALS_SUPPLY	Receiving serial supply
Column Name	Descritpion
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).
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).
SUPPLY_TYPE_CODE	Serial number supply context
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).
SHIPMENT_LINE_ID	Receipt shipment line unique identifier
TRANSACTION_ID	Receiving transaction unique identifier
LOT_NUM	Lot number
VENDOR_SERIAL_NUM	Not currently used
SERIAL_NUM	Serial number
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).

Purchasing - RCV_SERIAL_TRANSACTIONS	Receiving serial transactions
Column Name	Descritpion
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).
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).
SERIAL_TRANSACTION_TYPE	Serial transaction context
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).
SHIPMENT_LINE_ID	Receipt shipment line unique identifier
TRANSACTION_ID	Transaction unique identifier
LOT_NUM	Lot number
TRANSACTION_DATE	Transaction date
SOURCE_TRANSACTION_ID	Source transaction unique identifier
CORRECTION_TRANSACTION_ID	Correction transaction unique identifier
VENDOR_SERIAL_NUM	Not currently used
SERIAL_NUM	Serial number
VENDOR_LOT_NUM	Not currently used
USAGE_STATUS_CODE	Serial transaction status
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.

Purchasing - RCV_SHIPMENT_HEADERS	Shipment and receipt header information
Column Name	Descritpion
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
NET_WEIGHT	Shipment net weight from ASN
NET_WEIGHT_UOM_CODE	Shipment net weight unit of measure from ASN
TAR_WEIGHT	Shipment tar (container) weight from ASN
TAR_WEIGHT_UOM_CODE	Shipment tar (container) weight unit of measure from ASN
PACKAGING_CODE	Shipment packaging code
CARRIER_METHOD	Carrier transportation method code
CARRIER_EQUIPMENT	Carrier equipment description method
CARRIER_EQUIPMENT_NUM	Carrier equipment identification number
CARRIER_EQUIPMENT_ALPHA	Carrier equipment identification initials
SPECIAL_HANDLING_CODE	Special handling code
HAZARD_CODE	Hazardous material qualifier code of the shipment
HAZARD_CLASS	Hazardous material class of shipment
HAZARD_DESCRIPTION	Hazardous material description
FREIGHT_TERMS	Freight payment method (user defined, e.g. PREPAID, COLLECT)
FREIGHT_BILL_NUMBER	Freight bill (PRO invoice) number
INVOICE_NUM	EDI transaction 857 invoice number
INVOICE_DATE	EDI transaction 857 invoice date
INVOICE_AMOUNT	EDI transaction 857 invoice amount
TAX_NAME	EDI transaction 857 tax name indicated at the header level
TAX_AMOUNT	EDI transaction 857 tax amount indicated at the header level
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
FREIGHT_AMOUNT	EDI transaction 857 freight bill amount
INVOICE_STATUS_CODE	Eligibility status for automated Oracle Payables invoice creation
ASN_STATUS	ASN shipment status
CURRENCY_CODE	Code from purchase order currency code or PO_VENDOR_SITE.INVOICE_CURRENCY_CODE. Used for ASN with billing information (ASBN) only.
CONVERSION_RATE_TYPE	Purchase order rate type. Used for ASBN only.
RECEIPT_SOURCE_CODE	Source type of the shipment
CONVERSION_RATE	Purchase order rate. Used for ASBN only.
CONVERSION_DATE	Purchase order rate date. Used for ASBN only.
PAYMENT_TERMS_ID	EDI transaction 857 payment terms
MRC_CONVERSION_RATE_TYPE	Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID. Used for ASBN only. Taken from purchase order rate type pairs.
MRC_CONVERSION_DATE	Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID. Used for ASBN only. Taken from purchase order rate date pairs.
VENDOR_ID	Source supplier unique identifier
MRC_CONVERSION_RATE	Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID. Used for ASBN only. Taken from purchase order rate pairs.
SHIP_TO_ORG_ID	Ship-to organization unique identifier
CUSTOMER_ID	Customer unique identifier
CUSTOMER_SITE_ID	Customer site unique identifier
REMIT_TO_SITE_ID	Remit To Site Id
VENDOR_SITE_ID	Source supplier site unique identifier
SHIP_FROM_LOCATION_ID	Ship From Location unique identifier
WF_ITEM_TYPE	item type used in the Work Confirmation Approval
WF_ITEM_KEY	item key used in the Work Confirmation Approval
APPROVAL_STATUS	Approval status of the work confirmation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='APPROVAL_STATUS')
SHIPMENT_HEADER_ID	Receipt header unique identifier
ORGANIZATION_ID	Source organization unique identifier
PERFORMANCE_PERIOD_FROM	Work Confirmation Period from
PERFORMANCE_PERIOD_TO	Work Confirmation Period To
REQUEST_DATE	Work Confirmation request date
SHIPMENT_NUM	Shipment number assigned by the shipment's source
RECEIPT_NUM	Receipt number
SHIP_TO_LOCATION_ID	Ship-to location unique identifier
BILL_OF_LADING	Bill of lading number
PACKING_SLIP	Packing slip number
SHIPPED_DATE	Shipping date
FREIGHT_CARRIER_CODE	Carrier responsible for shipping
EXPECTED_RECEIPT_DATE	Expected arrival date of the shipment
EMPLOYEE_ID	Employee unique identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
NUM_OF_CONTAINERS	Number of containers in the shipment
WAYBILL_AIRBILL_NUM	Waybill or airbill number
COMMENTS	Receiver's or Approver's comments
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
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
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
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.
ASN_TYPE	The document type: ASN, ASBN or Receive
EDI_CONTROL_NUM	EDI transaction control number if data is imported via EDI
NOTICE_CREATION_DATE	EDI transaction create date/time at source if data is imported via EDI
GROSS_WEIGHT	Shipment gross weight from Advance Shipment Notice (ASN)
GROSS_WEIGHT_UOM_CODE	Shipment gross weight unit of measure from ASN

Purchasing - RCV_SHIPMENT_LINES	Receiving shipment line information
Column Name	Descritpion
SHIPMENT_HEADER_ID	Shipment header unique identifier
ATTRIBUTE12	Descriptive flexfield segment
ATTRIBUTE13	Descriptive flexfield segment
ATTRIBUTE14	Descriptive flexfield segment
ATTRIBUTE15	Descriptive flexfield segment
REASON_ID	Transaction reason unique identifier
LINE_NUM	Shipment line number
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).
CATEGORY_ID	Item category unique identifier
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
DESTINATION_CONTEXT	Destination descriptive flexfield context
PRIMARY_UNIT_OF_MEASURE	Primary unit of measure for the item
EXCESS_TRANSPORT_REASON	Excess transportation reason code
EXCESS_TRANSPORT_RESPONSIBLE	Excess transportation responsibility code
EXCESS_TRANSPORT_AUTH_NUM	Excess transportation authorization number
ASN_LINE_FLAG	Indicates whether item is on an Advance Shipment Notice (ASN). Used by missing ASN Items Processor to determine whether shipped items were received.
ORIGINAL_ASN_PARENT_LINE_ID	Reference to original ASN Line
ORIGINAL_ASN_LINE_FLAG	Original ASN line flag
VENDOR_CUM_SHIPPED_QUANTITY	Supplier's quantity shipped specified on the ASN - populated for parent lines only
QUANTITY_SHIPPED	Number of items shipped
NOTICE_UNIT_PRICE	EDI transaction 857 unit price of this item
TAX_NAME	EDI transaction 857 tax name indicated at the detail level
TAX_AMOUNT	EDI transaction 857 tax amount indicated at the detail level
INVOICE_STATUS_CODE	EDI transaction 857 status code to determine which line has been transferred to Oracle Payables
CUM_COMPARISON_FLAG	Not used
QUANTITY_RECEIVED	Number of items received
CONTAINER_NUM	Unique container identifier for the line
TRUCK_NUM	Number of the truck
BAR_CODE_LABEL	Label for the barcode
TRANSFER_PERCENTAGE	Transfer percentage for costing
UNIT_OF_MEASURE	Unit of measure of the shipment
SHIP_TO_LOCATION_ID	Unique identifier for the ship-to location
ITEM_DESCRIPTION	Item description
COUNTRY_OF_ORIGIN_CODE	Code for the country of manufacture
OE_ORDER_HEADER_ID	Sales order unique identifier
OE_ORDER_LINE_ID	Sales order line unique identifier
CUSTOMER_ITEM_NUM	Customer's item number
COST_GROUP_ID	Cost Group Identifier for the material on the shipment line for Oracle WMS
SECONDARY_QUANTITY_SHIPPED	Quantity of item shipped in secondary unit of measure
SHIPMENT_LINE_ID	Shipment line unique identifier
ITEM_ID	Item identifier
SECONDARY_QUANTITY_RECEIVED	Quantity received in secondary unit of measure
SECONDARY_UNIT_OF_MEASURE	Secondary unit of measure of the shipment
ITEM_REVISION	Item revision number
QC_GRADE	Quality grade of the shipment line
MMT_TRANSACTION_ID	Inventory Transaction Identifier
VENDOR_ITEM_NUM	Supplier's item number
ASN_LPN_ID	The lpn_id for ASNs only
AMOUNT	Reserved for future use
AMOUNT_RECEIVED	Amount Received in purchase order currency
JOB_ID	Job identifier
TIMECARD_ID	Timecard Identifier
VENDOR_LOT_NUM	Supplier's lot number
TIMECARD_OVN	Timecard version number
OSA_FLAG	Indicates if this shipment line is a shikyu item
REQUESTED_AMOUNT	requested amount for a Work Confirmation
MATERIAL_STORED_AMOUNT	material stored amount for a work confirmation
APPROVAL_STATUS	Approval status of the work confirmation (References PO_LOOKUP_CODES.lookup_code with LOOKUP_TYPE='APPROVAL_STATUS')
AMOUNT_SHIPPED	amount shipped
LCM_SHIPMENT_LINE_ID	LCM Shipment line identifier
UNIT_LANDED_COST	LCM unit landed cost
UOM_CONVERSION_RATE	Not currently used
SHIPMENT_LINE_STATUS_CODE	Receipt status of the shipment line
SOURCE_DOCUMENT_CODE	Source document type
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
PO_HEADER_ID	Purchase order header unique identifier
PO_RELEASE_ID	Purchase order release unique identifier
PO_LINE_ID	Purchase order line unique identifier
PO_LINE_LOCATION_ID	Purchase order shipment unique identifier
PO_DISTRIBUTION_ID	Purchase order distribution unique identifier
REQUISITION_LINE_ID	Requisition line unique identifier
REQ_DISTRIBUTION_ID	Requisition distribution unique identifier
ROUTING_HEADER_ID	Receiving routing unique identifier
PACKING_SLIP	Packing slip number
FROM_ORGANIZATION_ID	Source organization unique identifier
DELIVER_TO_PERSON_ID	Requester unique identifier
EMPLOYEE_ID	Receiver unique identifier
DESTINATION_TYPE_CODE	Destination type for items
TO_ORGANIZATION_ID	Destination organization unique identifier
TO_SUBINVENTORY	Default destination subinventory
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LOCATOR_ID	Not currently used
DELIVER_TO_LOCATION_ID	Deliver-to location unique identifier
CHARGE_ACCOUNT_ID	Intransit charge account unique identifier
TRANSPORTATION_ACCOUNT_ID	Intransit transportation account unique identifier
SHIPMENT_UNIT_PRICE	Item unit price
CREATION_DATE	Standard who column - date when this row was created.
TRANSFER_COST	Intransit transfer cost
TRANSPORTATION_COST	Intransit transportation cost
COMMENTS	Receiver or Approver comments
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
CREATED_BY	Standard who column - user who created 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

Purchasing - RCV_SUB_LEDGER_DETAILS	Detailed accounting lines for the receiving transaction
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
JE_CATEGORY_NAME	Journal entry category
SET_OF_BOOKS_ID	Unique identifier for the accounting Set of Books
ACCOUNTING_DATE	Accounting transaction effective date
PO_LINE_LOCATION_ID	Unique identifier for the document shipment schedule
CODE_COMBINATION_ID	Unique identifier for the General Ledger account
ACCOUNTED_DR	Debit amount in base currency
ACCOUNTED_CR	Credit amount in base currency
ENCUMBRANCE_TYPE_ID	Unique identifier for encumbrance batch
ENTERED_DR	Debit amount in entered currency
ENTERED_CR	Credit amount in entered currency
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
BUDGET_VERSION_ID	Unique identifier for budget version
CURRENCY_CONVERSION_DATE	Currency conversion date
USER_CURRENCY_CONVERSION_TYPE	Currency exchange rate type
CURRENCY_CONVERSION_RATE	Currency exchange rate
TRANSACTION_DATE	Transaction date
PERIOD_NAME	Accounting period name
CHART_OF_ACCOUNTS_ID	Unique identifier for the chart of accounts
FUNCTIONAL_CURRENCY_CODE	Unique identifier for the base currency
DATE_CREATED_IN_GL	Effective date of accounting entry
JE_BATCH_NAME	Journal entry batch name
CREATION_DATE	Standard who column - date when this row was created.
JE_BATCH_DESCRIPTION	Journal entry batch description
JE_HEADER_NAME	Journal entry header name
JE_LINE_DESCRIPTION	Journal entry line description
REVERSE_JOURNAL_FLAG	Indicator that this journal should be reversed
REVERSAL_PERIOD_NAME	Accounting period for reversing journal entry
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
CREATED_BY	Standard who column - user who created 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
RCV_SL_DETAILS_ID	Subledger details 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).
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).
SUBLEDGER_DOC_SEQUENCE_ID	Unique identifier for the subledger document
SUBLEDGER_DOC_SEQUENCE_VALUE	Sub ledger document sequence
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
REFERENCE1	Subledger reference column
REFERENCE2	Subledger reference column
RCV_TRANSACTION_ID	Unique identifier for the receiving transaction
REFERENCE3	Subledger reference column
REFERENCE4	Subledger reference column
REFERENCE5	Subledger reference column
REFERENCE6	Subledger reference column
REFERENCE7	Subledger reference column
REFERENCE8	Subledger reference column
REFERENCE9	Subledger reference column
REFERENCE10	Subledger reference column
SOURCE_DOC_QUANTITY	Quantity on the source document
CURRENCY_CODE	Currency unique identifier
ACCRUAL_METHOD_FLAG	Indicator of whether an accrual method was specified
GL_SL_LINK_ID	Unique identifier for the link between the general ledger and the subledger
ENTERED_REC_TAX	Recoverable tax
ENTERED_NR_TAX	Nonrecoverable tax
ACCOUNTED_REC_TAX	Accounted recoverable tax
ACCOUNTED_NR_TAX	Accounted nonrecoverable tax
ACTUAL_FLAG	Balance type (ACTUAL, BUDGET, or ENCUMBRANCE)
JE_SOURCE_NAME	Journal entry source

Purchasing - RCV_SUPPLY	Summary information about items in receiving/inspection
Column Name	Descritpion
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
SECONDARY_UNIT_OF_MEASURE	Secondary unit of measure
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.
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).
SUPPLY_TYPE_CODE	Identifies the stage in the Purchasing cycle
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).
REQ_HEADER_ID	Requisition header identifier
REQ_LINE_ID	Requisition line identifier
PO_HEADER_ID	Purchase order header identifier
PO_RELEASE_ID	Purchase order release identifier
PO_LINE_ID	Purchase order line identifier
PO_LINE_LOCATION_ID	Purchase order shipment schedule identifier
PO_DISTRIBUTION_ID	Purchase order distribution identifier
SHIPMENT_HEADER_ID	Shipment header Identifier
SUPPLY_SOURCE_ID	Supply unique identifier
SHIPMENT_LINE_ID	Shipment line Identifier
RCV_TRANSACTION_ID	Receiving transactions Identifier
ITEM_ID	Inventory item identifier
ITEM_REVISION	Item revision number
QUANTITY	Supply quantity stored in the transaction unit of measure
UNIT_OF_MEASURE	Transaction unit of measure
TO_ORG_PRIMARY_QUANTITY	Supply quantity in the primary unit of measure for the Item
TO_ORG_PRIMARY_UOM	Primary unit of measure for the Item
RECEIPT_DATE	Date of receipt
DESTINATION_TYPE_CODE	Destination type of shipment lines
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LOCATION_ID	Location identifier
FROM_ORGANIZATION_ID	Sending organization identifier
FROM_SUBINVENTORY	Sending subinventory identifier
TO_ORGANIZATION_ID	Destination organization identifier
TO_SUBINVENTORY	Destination subinventory identifier
INTRANSIT_OWNING_ORG_ID	Owner organization identifier for Inter-organization shipment
CHANGE_FLAG	Flags records to be processed by the supply update function
CHANGE_TYPE	Flags records to be omitted by MRP processing
OE_ORDER_HEADER_ID	Sales order unique identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
OE_ORDER_LINE_ID	Sales order unique identifier
TO_LOCATOR_ID	Sales order unique identifier
LPN_ID	Sales order unique identifier
SECONDARY_QUANTITY	Quantity in the secondary unit of measure

Purchasing - RCV_TRANSACTIONS	Receiving transactions
Column Name	Descritpion
TRANSACTION_ID	Receiving transaction unique identifier
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
QUANTITY_BILLED	Quantity billed
MATCH_FLAG	Indicator of whether the purchase order or receipt must be matched to an invoice
AMOUNT_BILLED	Amount billed by Payable.
MATCH_OPTION	Indicator of whether the invoice for this transaction should be matched to the purchase order or the receipt
OE_ORDER_HEADER_ID	Sales order unique identifier
OE_ORDER_LINE_ID	Sales order line unique identifier
CUSTOMER_ID	Customer unique identifier
CUSTOMER_SITE_ID	Customer site unique identifier
LPN_ID	License Plate Number Identifier in which the material was received through Oracle WMS
TRANSFER_LPN_ID	Transfer License Plate Number Identifier in which the material was transfered to during the receiving process through Oracle WMS
MOBILE_TXN	Y/N for a row created through Oracle WMS mobile form
SECONDARY_QUANTITY	Transaction quantity in terms of the item's secondary unit of measure
SECONDARY_UNIT_OF_MEASURE	Transaction secondary unit of measure
QC_GRADE	Quality grade of the Item received
SECONDARY_UOM_CODE	Abbreviated secondary unit of measure code
TRANSACTION_TYPE	Receiving transaction type
PA_ADDITION_FLAG	Flag that indicates if project related receipts have been transferred to Oracle Projects
CONSIGNED_FLAG	Indicates receipt is consigned
SOURCE_TRANSACTION_NUM	Source Transaction Number
FROM_SUBINVENTORY	Parent Subinventory name
FROM_LOCATOR_ID	Parent locator id
AMOUNT	Amount for services
DROPSHIP_TYPE_CODE	Dropship type for global procurement
LPN_GROUP_ID	Iinterface lpn group identifier
JOB_ID	Job Identifier for services
TIMECARD_ID	Timecard Identifier
TIMECARD_OVN	Timecard revision
PROJECT_ID	Project Identifier for timecards
TASK_ID	Task identifier for timecards
REQUESTED_AMOUNT	Requested amount in a Work Confirmation line
MATERIAL_STORED_AMOUNT	material stored amount in a Work Confirmation line.
REPLENISH_ORDER_LINE_ID	Replenishment sales order line unique identifier for chargeable subcontracting component
LCM_SHIPMENT_LINE_ID	LCM Shipment Line Identifier
UNIT_LANDED_COST	LCM Unit Landed Cost
RECEIPT_CONFIRMATION_EXTRACTED
LCM_ADJUSTMENT_NUM
TRANSACTION_DATE	Transaction date
XML_DOCUMENT_ID
QUANTITY	Transaction quantity
UNIT_OF_MEASURE	Transaction unit of measure
SHIPMENT_HEADER_ID	Receipt shipment header unique identifier
SHIPMENT_LINE_ID	Receipt shipment line unique identifier
USER_ENTERED_FLAG	User-entered or automatically generated transaction
INTERFACE_SOURCE_CODE	Interface transaction source
INTERFACE_SOURCE_LINE_ID	Interface transaction source line
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
INV_TRANSACTION_ID	Inventory transaction unique identifier
SOURCE_DOCUMENT_CODE	Source document type
DESTINATION_TYPE_CODE	Destination type
PRIMARY_QUANTITY	Transaction quantity in terms of the item's primary unit of measure
PRIMARY_UNIT_OF_MEASURE	Item primary unit of measure
UOM_CODE	Abbreviated unit of measure code
EMPLOYEE_ID	Receiver unique identifier
PARENT_TRANSACTION_ID	Parent receiving transaction unique identifier
PO_HEADER_ID	Purchase order header unique identifier
PO_RELEASE_ID	Purchase order release unique identifier
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PO_LINE_ID	Purchase order line unique identifier
PO_LINE_LOCATION_ID	Purchase order shipment unique identifier
PO_DISTRIBUTION_ID	Purchase order distribution unique identifier
PO_REVISION_NUM	Purchase order revision number
REQUISITION_LINE_ID	Requisition line unique identifier
PO_UNIT_PRICE	Unit price at time of receipt
CURRENCY_CODE	Source document foreign currency
CURRENCY_CONVERSION_TYPE	Foreign currency conversion type
CURRENCY_CONVERSION_RATE	Currency conversion rate
CURRENCY_CONVERSION_DATE	Currency conversion date
CREATION_DATE	Standard who column - date when this row was created.
ROUTING_HEADER_ID	Receiving routing unique identifier
ROUTING_STEP_ID	Not currently used
DELIVER_TO_PERSON_ID	Requester unique identifier
DELIVER_TO_LOCATION_ID	Deliver-to location unique identifier
VENDOR_ID	Supplier unique identifier
VENDOR_SITE_ID	Supplier site unique identifier
ORGANIZATION_ID	Destination organization unique identifier
SUBINVENTORY	Destination subinventory name
LOCATOR_ID	Destination locator unique identifier
WIP_ENTITY_ID	WIP job or repetitive assembly identifier
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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
BOM_RESOURCE_ID	BOM resource unique identifier
LOCATION_ID	Receiving location unique identifier
SUBSTITUTE_UNORDERED_CODE	Substitute or unordered receipt indicator
RECEIPT_EXCEPTION_FLAG	Receipt exception indicator
INSPECTION_STATUS_CODE	Quality inspection status
ACCRUAL_STATUS_CODE	Receiving transaction accrual status
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
INSPECTION_QUALITY_CODE	Quality inspection code
VENDOR_LOT_NUM	Supplier lot number
RMA_REFERENCE	RMA reference number
COMMENTS	Receiver comments
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
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).
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
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
REQ_DISTRIBUTION_ID	Requisition distribution unique identifier
DEPARTMENT_CODE	WIP department name
REASON_ID	Transaction reason unique identifier
DESTINATION_CONTEXT	Destination descriptive flexfield context
LOCATOR_ATTRIBUTE	Locator flexfield context
CHILD_INSPECTION_FLAG	Release 9 inspection transaction indicator
SOURCE_DOC_UNIT_OF_MEASURE	Source document unit of measure
SOURCE_DOC_QUANTITY	Transaction quantity in terms of the source document's unit of measure
INTERFACE_TRANSACTION_ID	Original interface transaction unique identifier
GROUP_ID	Original interface group 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).
MOVEMENT_ID	Movement identification number
INVOICE_ID	Transaction 857 Invoice unique identifier
INVOICE_STATUS_CODE	Eligibility status for automated Oracle Payables invoice creation
QA_COLLECTION_ID	Primary key for Oracle Quality results
MRC_CURRENCY_CONVERSION_TYPE	Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, foreign currency conversion type pairs
MRC_CURRENCY_CONVERSION_DATE	Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion date pairs
MRC_CURRENCY_CONVERSION_RATE	Multiple Reporting Currencies only: Concatenated string of reporting Set of Books ID, currency conversion rate pairs
COUNTRY_OF_ORIGIN_CODE	Code for the country of manufacture
MVT_STAT_STATUS	Indicator of whether the transaction has been processed by the Movement Statistics concurrent program

Purchasing - RCV_TRANSACTIONS_INTERFACE	Receiving transactions interface table
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
PO_RELEASE_ID	Purchase order Release unique identifier
PO_LINE_ID	Purchase order line unique identifier
PO_LINE_LOCATION_ID	Purchase order shipment unique identifier
PO_UNIT_PRICE	Unit price at time of receipt
CURRENCY_CODE	Source document currency code
CURRENCY_CONVERSION_TYPE	Currency conversion type
CURRENCY_CONVERSION_RATE	Currency conversion rate
CURRENCY_CONVERSION_DATE	Currency conversion date
PO_DISTRIBUTION_ID	Purchase order distribution unique identifier
REQUISITION_LINE_ID	Requisition line unique identifier
REQ_DISTRIBUTION_ID	Requisition distribution unique identifier
CHARGE_ACCOUNT_ID	Charge account identifier
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
SUBSTITUTE_UNORDERED_CODE	Substitute or unordered receipt indicator
RECEIPT_EXCEPTION_FLAG	Receipt exception indicator
ACCRUAL_STATUS_CODE	Accrual status of the items
INSPECTION_STATUS_CODE	Quality inspection status
INSPECTION_QUALITY_CODE	Quality inspection result code
DESTINATION_TYPE_CODE	Destination type
DELIVER_TO_PERSON_ID	Requester unique identifier
LOCATION_ID	Receiving location unique identifier
DELIVER_TO_LOCATION_ID	Deliver-to location unique identifier
SUBINVENTORY	Destination subinventory name
CREATION_DATE	Standard who column - date when this row was created.
LOCATOR_ID	Destination locator unique identifier
WIP_ENTITY_ID	WIP job or repetitive assembly identifier
WIP_LINE_ID	WIP line identifier
DEPARTMENT_CODE	WIP department name
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
BOM_RESOURCE_ID	BOM resource unique identifier
SHIPMENT_NUM	Supplier or source organization shipment number
FREIGHT_CARRIER_CODE	Freight carrier used to ship items
CREATED_BY	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
BILL_OF_LADING	Bill of lading number
PACKING_SLIP	Packing slip number
SHIPPED_DATE	Date of shipping
EXPECTED_RECEIPT_DATE	Expected arrival date
ACTUAL_COST	Actual cost
TRANSFER_COST	Cost of transferring items between organizations
TRANSPORTATION_COST	Cost of shipping items between organizations
TRANSPORTATION_ACCOUNT_ID	Account to be charged for transportation costs
NUM_OF_CONTAINERS	Number of containers in the shipment
WAYBILL_AIRBILL_NUM	Waybill or airbill number
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
VENDOR_ITEM_NUM	Supplier's item number
VENDOR_LOT_NUM	Supplier's lot number
RMA_REFERENCE	RMA reference number for return-to-supplier items
COMMENTS	Receiver comments
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
INTERFACE_TRANSACTION_ID	Interface transaction 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).
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
PROGRAM_APPLICATION_ID	Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
SHIP_HEAD_ATTRIBUTE_CATEGORY	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE1	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE2	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE3	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE4	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE5	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE6	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE7	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE8	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE9	Shipment header descriptive flexfield segment column
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).
SHIP_HEAD_ATTRIBUTE10	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE11	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE12	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE13	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE14	Shipment header descriptive flexfield segment column
SHIP_HEAD_ATTRIBUTE15	Shipment header descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE_CATEGORY	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE1	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE2	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE3	Shipment line descriptive flexfield segment column
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
SHIP_LINE_ATTRIBUTE4	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE5	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE6	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE7	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE8	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE9	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE10	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE11	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE12	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE13	Shipment line descriptive flexfield segment column
TRANSACTION_TYPE	Receiving transaction type
SHIP_LINE_ATTRIBUTE14	Shipment line descriptive flexfield segment column
SHIP_LINE_ATTRIBUTE15	Shipment line descriptive flexfield segment column
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GOVERNMENT_CONTEXT	USSGL descriptive flexfield context column
REASON_ID	Transaction reason unique identifier
DESTINATION_CONTEXT	Destination descriptive flexfield context
SOURCE_DOC_QUANTITY	Transaction quantity in terms of the source document's unit of measure
SOURCE_DOC_UNIT_OF_MEASURE	Source document's unit of measure
MOVEMENT_ID	Movement identifier
HEADER_INTERFACE_ID	Interface header unique identifier if it exists
VENDOR_CUM_SHIPPED_QTY	Supplier's CUM quantity shipped specified on the Advance Shipment Notice (ASN)
TRANSACTION_DATE	Transaction date
ITEM_NUM	Buyer's item number specified on the ASN
DOCUMENT_NUM	Purchase order number specified on the ASN
DOCUMENT_LINE_NUM	Purchase order line number specified on the ASN
TRUCK_NUM	Truck number
SHIP_TO_LOCATION_CODE	Ship-to location specified at the item level on the ASN
CONTAINER_NUM	Container number
SUBSTITUTE_ITEM_NUM	Buyer's substitute item number specified on ASN
NOTICE_UNIT_PRICE	EDI transaction 857 unit price
ITEM_CATEGORY	Item category code - key flexfield all segments
LOCATION_CODE	Ship-to/receiving location
PROCESSING_STATUS_CODE	Processing status for the interface row
VENDOR_NAME	Supplier name
VENDOR_NUM	Supplier number
VENDOR_SITE_CODE	Supplier site code
FROM_ORGANIZATION_CODE	From organization code for inter-organization transfers
TO_ORGANIZATION_CODE	Ship-to organization code
INTRANSIT_OWNING_ORG_CODE	In-transit owning organization code for inter-organization transfers
ROUTING_CODE	Receiving routing name
ROUTING_STEP	Upgrade step unique identifier
RELEASE_NUM	Release number
DOCUMENT_SHIPMENT_LINE_NUM	Document shipment line number
PROCESSING_MODE_CODE	Processing mode to be used when the interface row is processed
DOCUMENT_DISTRIBUTION_NUM	Document distribution number
DELIVER_TO_PERSON_NAME	Employee full name
DELIVER_TO_LOCATION_CODE	Deliver-to location code
USE_MTL_LOT	Flag used in lot processing
USE_MTL_SERIAL	Flag used in serial processing
LOCATOR	Stock locator description
REASON_NAME	Transaction reason name
VALIDATION_FLAG	Marked after open interface validation
SUBSTITUTE_ITEM_ID	Buyer's substitute item unique identifier
PROCESSING_REQUEST_ID	Identifier of the concurrent request that is processing the interface row. Set by the Receiving Transaction Processor
QUANTITY_SHIPPED	Shipped Quantity
QUANTITY_INVOICED	Invoiced quantity
TAX_NAME	EDI transaction 857 tax name
TAX_AMOUNT	EDI transaction 857 tax amount
REQ_NUM	Requisition number
REQ_LINE_NUM	For the REQ_LINE_ID on ASNs
REQ_DISTRIBUTION_NUM	For the REQ_DISTRIBUTION_ID on ASNs
WIP_ENTITY_NAME	For the WIP_ENTITY_ID on ASNs
WIP_LINE_CODE	For the WIP_LINE_ID on ASNs
RESOURCE_CODE	For the REASON_ID on ASNs
TRANSACTION_STATUS_CODE	Transaction status of the interface row
SHIPMENT_LINE_STATUS_CODE	Status code for shipment line
BARCODE_LABEL	Barcoded detail label serial number if indicated on ASN for inner packaging of this item; to be matched for barcode-scanned receipts updating
TRANSFER_PERCENTAGE	Transfer percentage for costing
QA_COLLECTION_ID	Primary key for Oracle Quality results
COUNTRY_OF_ORIGIN_CODE	Code for the country of manufacture
OE_ORDER_HEADER_ID	Sales order unique identifier
GROUP_ID	Interface processing group identifier
CATEGORY_ID	Item category unique identifier
OE_ORDER_LINE_ID	Sales order line unique identifier
CUSTOMER_ID	Customer unique identifier
CUSTOMER_SITE_ID	Customer unique identifier
CUSTOMER_ITEM_NUM	Customer's item number
QUANTITY	Transaction quantity
CREATE_DEBIT_MEMO_FLAG	Flag which determines if a debit memo has to be created or not.
PUT_AWAY_RULE_ID	Inserted for WMS functionality
PUT_AWAY_STRATEGY_ID	Part of WMS enhancement
LPN_ID	License plate number Identifier (for WMS use)
UNIT_OF_MEASURE	Transaction unit of measure
TRANSFER_LPN_ID	Transfer license plate number Identifier
COST_GROUP_ID	Cost Group Identifier for WMS
MOBILE_TXN	Y/N for a row created through Mobile form (WMS)
MMTT_TEMP_ID	Reference to original inventory transaction for WMS
INTERFACE_SOURCE_CODE	Source of the interface row
TRANSFER_COST_GROUP_ID	Transfer Cost Group Identifier for Oracle WMS
SECONDARY_QUANTITY	Transaction quantity in secondary unit of measure
SECONDARY_UNIT_OF_MEASURE	Transaction secondary unit of measure
SECONDARY_UOM_CODE	Abbreviated secondary unit of measure
INTERFACE_SOURCE_LINE_ID	Source line identifier of the interface row
QC_GRADE	Quality grade of the item received
FROM_LOCATOR	Parent locator
INV_TRANSACTION_ID	Inventory transaction unique identifier
FROM_LOCATOR_ID	Parent locator id
PARENT_SOURCE_TRANSACTION_NUM	Parent source transaction num
INTERFACE_AVAILABLE_QTY	Available qty for the children rti rows
INTERFACE_TRANSACTION_QTY	Available transaction quantity.
INTERFACE_AVAILABLE_AMT	Available amount for the children rti rows
INTERFACE_TRANSACTION_AMT	Available transaction quantity.
LICENSE_PLATE_NUMBER	Licence plate number
SOURCE_TRANSACTION_NUM	Source Transaction Number
TRANSFER_LICENSE_PLATE_NUMBER	Parent Licence plate number
LPN_GROUP_ID	Lpn group identifier
ORDER_TRANSACTION_ID	Order Transaction Identifier
ITEM_ID	Item unique identifier
CUSTOMER_ACCOUNT_NUMBER	Customer Account Number
CUSTOMER_PARTY_NAME	Customer Party Name
OE_ORDER_LINE_NUM	Order Line Number
OE_ORDER_NUM	Order Number
PARENT_INTERFACE_TXN_ID	Parent rti id for the current rti row
CUSTOMER_ITEM_ID	Customer Item Identifier
AMOUNT	Amount
ITEM_DESCRIPTION	Item description
JOB_ID	Job Identifier for services
TIMECARD_ID	Timecard Identifier
ITEM_REVISION	Item revision number
TIMECARD_OVN	Timecard revision
ERECORD_ID	eRecord Identifier
PROJECT_ID	Project identifier for timecard
TASK_ID	Task identifier for timecard
UOM_CODE	Transaction unit of measure code
ASN_ATTACH_ID	Asn Attach Id
ORG_ID	Organization identifier
OPERATING_UNIT	Operation Unit Name used to derive ORG_ID
REQUESTED_AMOUNT	requested_amount for a work confirmation line
EMPLOYEE_ID	Receiver unique identifier
MATERIAL_STORED_AMOUNT	material stored amont for a work confirmation line
AMOUNT_SHIPPED	Amount shipped for a work confirmation line
MATCHING_BASIS	PO shipment Matching basis
AUTO_TRANSACT_CODE	Automatic transaction creation code
REPLENISH_ORDER_LINE_ID	Replenishment sales order line unique identifier for chargeable subcontracting component
EXPRESS_TRANSACTION	Flag of Mobile Express Transaction
LCM_SHIPMENT_LINE_ID	LCM Shipment Line Identifier
SHIPMENT_HEADER_ID	Receipt shipment header unique identifier
UNIT_LANDED_COST	LCM Unit Landed Cost
LCM_ADJUSTMENT_NUM
SHIPMENT_LINE_ID	Receipt shipment line unique identifier
SHIP_TO_LOCATION_ID	Ship-to location unique identifier
PRIMARY_QUANTITY	Transaction quantity in terms of the item's primary unit of measure
PRIMARY_UNIT_OF_MEASURE	Primary unit of measure of the item
RECEIPT_SOURCE_CODE	Source of the receipt
VENDOR_ID	Supplier unique identifier
VENDOR_SITE_ID	Supplier site unique identifier
FROM_ORGANIZATION_ID	Source organization unique identifier
FROM_SUBINVENTORY	Source subinventory name
TO_ORGANIZATION_ID	Destination organization unique identifier
INTRANSIT_OWNING_ORG_ID	Organization that owns the items while they are in transit
ROUTING_HEADER_ID	Receiving routing unique identifier
ROUTING_STEP_ID	Not currently used
SOURCE_DOCUMENT_CODE	Source document type
PARENT_TRANSACTION_ID	Parent receiving transaction unique identifier
PO_HEADER_ID	Purchase order header unique identifier
PO_REVISION_NUM	Purchase order revision number

Purchasing - RCV_UPGRADE_STEPS	Temporary table for tracking a receiving upgrade from Release 9 to Release 10
Column Name	Descritpion
STEP_NAME	Upgrade step unique identifier
MAX_ROW_TO_PROCESS	The greatest unique ID of the table that is being upgraded
LAST_COMMITTED_ID	The last unique ID that has been processed in the upgrade
MIN_ROW_TO_PROCESS	The lowest unique ID of the table that is being upgraded

Purchasing - RCV_SHIPMENT_LINES_EFC	archive for euro functional currency project
Column Name	Descritpion
TRANSPORTATION_COST	transportation cost
SHIPMENT_LINE_ID	shipment line identifier
TRANSFER_COST	transfer costs
SET_OF_BOOKS_ID	set of books identifier
SECURITY_GROUP_ID	Security Group Identifier

Purchasing - RCV_MC_SUB_LEDGER_DETAILS	MRC sub-table of RCV_SUB_LEDGER_DETAILS
Column Name	Descritpion
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
JE_CATEGORY_NAME	JE Category
SET_OF_BOOKS_ID	Set of books Identifier
ACCOUNTING_DATE	Accounting Date
PO_LINE_LOCATION_ID	PO Line Location Identifier
CODE_COMBINATION_ID	Code Combination identifier
ACCOUNTED_DR	Debit amount in base currency
ACCOUNTED_CR	Credit amount in base currency
ENCUMBRANCE_TYPE_ID	Encumbrance type identifier
ENTERED_DR	Debit amount in base currency
ENTERED_CR	Credit amount on entered currency
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
BUDGET_VERSION_ID	Budget Version Identifier
CURRENCY_CONVERSION_DATE	Currency Conversion Date
USER_CURRENCY_CONVERSION_TYPE	Currency Exchange type
CURRENCY_CONVERSION_RATE	Currency exchange rate
TRANSACTION_DATE	Transaction Date
PERIOD_NAME	Accounting Period Name
CHART_OF_ACCOUNTS_ID	Chart of accounts unique identifier
FUNCTIONAL_CURRENCY_CODE	Functional currency code
DATE_CREATED_IN_GL	Effective date of accounting entry
JE_BATCH_NAME	Journal Entry Batch Name
CREATION_DATE	Standard who column - date when this row was created.
JE_BATCH_DESCRIPTION	Journal Entry Batch description
JE_HEADER_NAME	Journal Entry Header name
JE_LINE_DESCRIPTION	Journal Entry line description
REVERSE_JOURNAL_FLAG	This journal entry has to be reversed
REVERSAL_PERIOD_NAME	Name of the reversal period
ATTRIBUTE_CATEGORY	Descriptive flexfield structure definition column.
ATTRIBUTE1	Descriptive flexfield segment
ATTRIBUTE2	Descriptive flexfield segment
ATTRIBUTE3	Descriptive flexfield segment
ATTRIBUTE4	Descriptive flexfield segment
CREATED_BY	Standard who column - user who created 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
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
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).
SUBLEDGER_DOC_SEQUENCE_ID	Subledger Document Sequence identifier
SUBLEDGER_DOC_SEQUENCE_VALUE	Subledger Documents sequence value
USSGL_TRANSACTION_CODE	United States Standard General Ledger transaction Code
REFERENCE1	Subledger reference column
REFERENCE2	Subledger reference column
RCV_TRANSACTION_ID	Receiving transaction Identifier
REFERENCE3	Subledger reference column
REFERENCE4	Subledger reference column
REFERENCE5	Subledger reference column
REFERENCE6	Subledger reference column
REFERENCE7	Subledger reference column
REFERENCE8	Subledger reference column
REFERENCE9	Subledger reference column
REFERENCE10	Subledger reference column
SOURCE_DOC_QUANTITY	Quantity from the source document
CURRENCY_CODE	Currency Code
ACCRUAL_METHOD_FLAG	Indicator whether the accrual method was specified
GL_SL_LINK_ID	Unique identifier for the link between general ledger and the subledger
ENTERED_REC_TAX	Recoverable tax in the entered currency
ENTERED_NR_TAX	Nonrecoverable tax in the entered currency
ACCOUNTED_REC_TAX	Accounted Recoverable tax
ACCOUNTED_NR_TAX	Accounted Non Recoverable Tax
RCV_SL_DETAILS_ID	RCV subledger details unique identifer
ACTUAL_FLAG	Balance type-actual,budget or encumbrance
JE_SOURCE_NAME	JE Source

Purchasing - RCV_ROUTING_HEADERS_OLD	Receiving routing headers
Column Name	Descritpion
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).
ROUTING_NAME	Receiving routing name
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
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).
ROUTING_HEADER_ID	Receiving routing unique identifier
PROGRAM_UPDATE_DATE	Concurrent Program who column - date when a program last updated this row).
DESCRIPTION	Receiving routing description
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.

Purchasing - RCV_ACCOUNTING_EVENTS	Receiving Accounting Events
Column Name	Descritpion
ACCOUNTING_EVENT_ID	Accounting Event Unique Identifier
PROGRAM_UDPATE_DATE	Standard Who column
RCV_TRANSACTION_ID	Receiving Transaction Unique Identifier
EVENT_TYPE_ID	Accounting Event Type Identifier
EVENT_SOURCE	Event source - Receiving, Retroprice or InvoiceMatch
EVENT_SOURCE_ID	Event Source Identifier. For event source of Receiving or Retroprice, this column represents rcv_transaction_id. For event source of InvoiceMatch, this column represents the invoice distribution_id.
SET_OF_BOOKS_ID	Set Of Books Identifier
ORG_ID	Organization identifier
TRANSFER_ORG_ID	Transfer Operating Unit. Only applicable for Shared Services scenarios
ORGANIZATION_ID	Organization in which the accounting event is being generated
TRANSFER_ORGANIZATION_ID	Transfer Organization Identifier. Only applicable in Shared Services scenarios
DEBIT_ACCOUNT_ID	Debit Account Identifier
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.
CREDIT_ACCOUNT_ID	Credit Account Identifier
TRANSACTION_DATE	Transaction date
TRANSACTION_QUANTITY	Transaction Quantity
TRANSACTION_UNIT_OF_MEASURE	Transaction Unit of Measure
SOURCE_DOC_QUANTITY	Quantity in source document's unit of measure
SOURCE_DOC_UNIT_OF_MEASURE	Source document's unit of measure
PRIMARY_QUANTITY	Transaction quantity in item's primary unit of measure.
PRIMARY_UNIT_OF_MEASURE	Item primary unit of measure
INVENTORY_ITEM_ID	Inventory Item Identifier
PO_HEADER_ID	Purchase Order Header Unique Identifier
PO_RELEASE_ID	Purchase Order Release Unique Identifier
PO_LINE_ID	Purchase Order Line Unique Identifier
PO_LINE_LOCATION_ID	Purchase Order Line Location Unique Identifier
PO_DISTRIBUTION_ID	Purchase Order Distribution Unique Identifier
INTERCOMPANY_PRICING_OPTION	Flag that indicates if Unit Price is at PO price or Transfer Price. 1-PO price 2-Transfer price
UNIT_PRICE	Unit Price in PO unit of measure. Could be PO price or transfer price
TRANSACTION_AMOUNT	Transaction Amount. Used only for service line types
LAST_UPDATED_BY	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PRIOR_UNIT_PRICE	Prior unit price. Used only for retroactive pricing adjustment events
NR_TAX	Non-recoverable Tax
REC_TAX	Recoverable Tax
NR_TAX_AMOUNT	Nonrecoverable tax amount. Used for service line types.
REC_TAX_AMOUNT	Recoverable tax amount. Used only for service line types.
PRIOR_NR_TAX	Prior non-recoverable tax. Only applicable for retroactive pricing.
PRIOR_REC_TAX	Prior recoverable tax. Only applicable for retroactive pricing.
CURRENCY_CODE	Currency Code
CURRENCY_CONVERSION_TYPE	Currency Conversion Type
CURRENCY_CONVERSION_RATE	Currency Conversion Rate
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CURRENCY_CONVERSION_DATE	Currency Conversion date
ACCOUNTED_FLAG	Flag that indicates if accounting entries have been created for the accounting event
PROCUREMENT_ORG_FLAG	Flag that indicates if event is for the supplier facing operating unit
CROSS_OU_FLAG	Flag that indicates if transaction is for a PO that crosses operating units
TRX_FLOW_HEADER_ID	Identifier of the transaction flow being used for the event. Only applicable for Shared Services scenarios.
INVOICED_FLAG	Flag that indicates if the event has been processed by the Intercompany invoicing program. Only applicable to invoice match and invoice reversal events.
PA_ADDITION_FLAG	Flag that indicates if project related receipts have been transferred to projects
USSGL_TRANSACTION_CODE	United States standard general ledger transaction code
GL_GROUP_ID	GL Group Identifier
CREATION_DATE	Standard who column - date when this row was created.
QUANTITY_RECEIVED	Quantity Received, only applicable to Period End Accrual event
QUANTITY_INVOICED	Quantity Invoiced, only applicable to Period End Accrual event
AMOUNT_RECEIVED	Amount Received, only applicable to Period End Accrual event
AMOUNT_INVOICED	Amount Invoiced, only applicable to Period End Accrual event
LCM_ACCOUNT_ID	Landed cost absorption account
UNIT_LANDED_COST	Landed cost of the LCM shipment
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).

Purchasing - RCV_ACCOUNTING_EVENT_TYPES	Receiving Accounting Event Types
Column Name	Descritpion
EVENT_TYPE_ID	Event Type 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_UDPATE_DATE	Standard Who column
EVENT_TYPE_NAME	Event Type Name
DESCRIPTION	Description
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 - RCV_FTE_TRANSACTION_LINES	Receiving logistics transaction lines
Column Name	Descritpion
HEADER_ID	Header Identifier
LAST_UPDATE_LOGIN	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
LINE_ID	Line Identifier
ACTION	Action flag
REPORTED_FLAG	Reported Flag
TRANSACTION_ID	Transaction 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).
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).

Purchasing - RCV_GAPLESS_INVOICE_NUMBERS	Gapless Invoice Numbers for Self Billing Invoices
Column Name	Descritpion
BUYING_COMPANY_CODE	Buying Company Code
SELLING_COMPANY_CODE	Selling Company Code
INVOICE_TYPE	Invoice Type
NEXT_SEQUENCE_NUMBER	Next Sequence Number
PREFIX	Prefix

Purchasing - PO_WF_USER_TMP
Column Name	Descritpion
USER_NAME

Purchasing - RCV_STAGING_TABLE	Receiving transactions for subcontracted items
Column Name	Descritpion
TEAM	Three letter team name
STATUS	Indicates whether row is PENDING or ERROR
TRANSACTION_REQUEST_ID	Maps to the value of RCV_TRANSACTIONS.REQUEST_ID
TRANSACTION_GROUP_ID	Maps to the value of RCV_TRANSACTIONS.GROUP_ID
CREATION_DATE	Standard who column - date when this row was created.
TRANSACTION_ID	Maps to rcv_transactions.transaction_id
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).
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).
LAST_UPDATE_DATE	Standard Who column - date when a user last updated this row.

Purchasing - RCV_CHARGES_INTERFACE	Interface table for charges
Column Name	Descritpion
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).
GROUP_ID	Interface processig group identifier
AMOUNT	Charge amount
CURRENCY_CODE	Currency code of the charge
CURRENCY_CONVERSION_TYPE	Currency conversion type
INTERFACE_CHARGE_ID	Entity identifier
CURRENCY_CONVERSION_RATE	Currency conversion rate
CURRENCY_CONVERSION_DATE	Currency conversion date
COST_FACTOR_ID	Idenditier of the type of cost factor
COST_FACTOR_CODE	Cost Factor Code for specifying the type of the charge.
PARENT_HEADER_INTERFACE_ID	Identifier of the parent item transaction header interface. Required for header level charges.
PARENT_INTERFACE_ID	Identifier of the parent item transaction interface. Required for line level charges.
VENDOR_ID	Identifier of the charge providor
VENDOR_SITE_ID	Identifier of the charge providor site
PROCESSING_STATUS_CODE	The status of preprocessing this charge
TRANSACTION_STATUS_CODE	The status code of processing this charge