Oracle eTRM details of PO Accrual Tables

 Table: PO_ACCRUAL_ACCOUNTS_TEMP_ALL

Description:Accrual accounts temporary table
Comments

PO_ACCRUAL_ACCOUNT_TEMP_ALL is a temporary table used by Oracle
Purchasing to generate the Accrual Reconciliation Report.
.


Indexes
IndexTypeTablespaceColumn
PO_ACCRUAL_ACCOUNTS_TEMP_U1UNIQUEAPPS_TS_NOLOGGINGACCRUAL_ACCOUNT_ID
ORG_ID
Columns
NameDatatypeLengthMandatoryComments
REQUEST_IDNUMBER
YConcurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
ACCRUAL_ACCOUNT_IDNUMBER
YAccrual account unique identifier
ORG_IDNUMBER

Organization identifier

[top of page]

PO.PO_ACCRUAL_ACCOUNTS_TEMP_ALL does not reference any database object

PO.PO_ACCRUAL_ACCOUNTS_TEMP_ALL is referenced by following:

PO
VIEW - PO_ACCRUAL_ACCOUNTS_TEMP_ALL#
PO_ACCRUAL_ACCOUNTS_TEMP_ALL#

[top of page]

Table: PO_ACCRUAL_WRITE_OFFS_ALL

Description:Accrual write-offs
Foreign Keys from this table:
Foreign Key ColumnForeign Table
PO_ACCRUAL_WRITE_OFFS_ALL.ACCRUAL_ACCOUNT_IDGL_CODE_COMBINATIONS
PO_ACCRUAL_WRITE_OFFS_ALL.PO_TRANSACTION_IDRCV_TRANSACTIONS
PO_ACCRUAL_WRITE_OFFS_ALL.INV_TRANSACTION_IDMTL_MATERIAL_TRANSACTIONS
PO_ACCRUAL_WRITE_OFFS_ALL.WIP_TRANSACTION_IDWIP_TRANSACTIONS
PO_ACCRUAL_WRITE_OFFS_ALL.PO_HEADER_IDPO_HEADERS_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.PO_DISTRIBUTION_IDPO_DISTRIBUTIONS_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.PO_LINE_IDPO_LINES_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.VENDOR_IDPO_VENDORS
PO_ACCRUAL_WRITE_OFFS_ALL.INVOICE_IDAP_INVOICES_ALL
PO_ACCRUAL_WRITE_OFFS_ALL.REASON_IDMTL_TRANSACTION_REASONS
Comments

PO_ACCRUAL_WRITE_OFFS_ALL holds the accounts payable write-offs,
created by the Accrual Write-Offs window. You may write off and reverse a
write-off at any time. You never change or remove an existing row, you
always add more rows. The Accrual Reconciliation Report can exclude
written-off transactions, since the underlying table,
PO_ACCRUAL_RECONCILE_TEMP_ALL has the WRITE_OFF_ID, which is the
unique identifier for the PO_ACCRUAL_WRITE_OFFS_ALL table.

Indexes
IndexTypeTablespaceColumn
PO_ACCRUAL_WRITE_OFFS_U1UNIQUEAPPS_TS_TX_IDXWRITE_OFF_ID
PO_ACCRUAL_WRITE_OFFS_N1NONUNIQUEAPPS_TS_TX_IDXPO_DISTRIBUTION_ID
PO_TRANSACTION_ID
PO_ACCRUAL_WRITE_OFFS_N2NONUNIQUEAPPS_TS_TX_IDXINVOICE_ID
INVOICE_LINE_NUM
PO_ACCRUAL_WRITE_OFFS_N3NONUNIQUEAPPS_TS_TX_IDXINV_TRANSACTION_ID
PO_ACCRUAL_WRITE_OFFS_N4NONUNIQUEAPPS_TS_TX_IDXWIP_TRANSACTION_ID
Columns
NameDatatypeLengthMandatoryComments
WRITE_OFF_IDNUMBER
YWrite-off unique identifier
LAST_UPDATE_DATEDATE
YStandard Who column - date when a user last updated this row.
LAST_UPDATED_BYNUMBER
YStandard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATEDATE
YStandard who column - date when this row was created.
CREATED_BYNUMBER
YStandard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGINNUMBER
YStandard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_IDNUMBER

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_IDNUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_IDNUMBER

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_DATEDATE

Concurrent Program who column - date when a program last updated this row).
PERIOD_NAMEVARCHAR2(15)
Accounting period name
WRITE_OFF_GL_DATEDATE
YThe General Ledger date for the manual journal entry
TRANSACTION_ORGANIZATION_IDNUMBER
YOrganization where transaction took place
ITEM_MASTER_ORGANIZATION_IDNUMBER
YItem Master/Purchasing reference organization
ACCRUAL_ACCOUNT_IDNUMBER(25)YAccrual account unique identifier
ACCRUAL_CODEVARCHAR2(80)YType of transaction or A/P match condition
PO_TRANSACTION_TYPEVARCHAR2(25)
Purchasing transaction code
TRANSACTION_DATEDATE
YOriginal transaction date
INVOICE_NUMVARCHAR2(50)
Invoice number
RECEIPT_NUMVARCHAR2(30)
Receipt number
PO_TRANSACTION_IDNUMBER

Receiving transaction unique identifier
INV_TRANSACTION_IDNUMBER

Inventory transaction unique identifier
INV_TRANSACTION_TYPE_IDNUMBER

Inventory transaction type unique identifier
WIP_TRANSACTION_IDNUMBER

WIP transaction unique identifier
WIP_TRANSACTION_TYPE_IDNUMBER

WIP transaction type unique identifier
INVENTORY_ITEM_IDNUMBER

Item unique identifier
PO_UNIT_OF_MEASUREVARCHAR2(25)
Purchasing unit of measure
PRIMARY_UNIT_OF_MEASUREVARCHAR2(25)
Primary unit of measure for the item
TRANSACTION_QUANTITYNUMBER

Quantity for the transaction
NET_PO_LINE_QUANTITYNUMBER

PO line invoice quantity less the receipt quantity
PO_HEADER_IDNUMBER

Document header unique identifier
PO_NUMVARCHAR2(20)
PO number
PO_LINE_NUMNUMBER

Purchase order line number
PO_LINE_IDNUMBER

Document line unique identifier
PO_DISTRIBUTION_IDNUMBER

Document distribution unique identifier
VENDOR_IDNUMBER

Supplier unique identifier
VENDOR_NAMEVARCHAR2(240)
Supplier name
TRANSACTION_UNIT_PRICENUMBER

Unit price for transaction
INVOICE_IDNUMBER

Invoice unique identifier
INVOICE_LINE_NUMNUMBER

Invoice distribution number
AVG_RECEIPT_PRICENUMBER

Average receipt price for the purchase order line
TRANSACTION_AMOUNTNUMBER

Transaction debit or credit
LINE_MATCH_ORDERNUMBER

Line sequence number for printing the Accrual Reconciliation Report
TRANSACTION_SOURCE_CODEVARCHAR2(25)YTransaction source or subledger
REASON_IDNUMBER

Transaction reason unique identifier
COMMENTSVARCHAR2(240)
Comments for the accrual write-off
WRITE_OFF_CODEVARCHAR2(25)
Write-off status for the write-off transaction
DESTINATION_TYPE_CODEVARCHAR2(25)
Destination type for the transaction
INVOICE_PRICE_VARIANCENUMBER

For pre-release 10 transactions, the reported IPV
ORG_IDNUMBER

Organization identifier
ADJUSTMENT_TRANSACTIONNUMBER

Specifies if the transaction is a retroactive price adjustment
ENTERED_TRANSACTION_AMOUNTNUMBER

Transaction amount in the entered currency
CURRENCY_CODEVARCHAR2(15)
Currency code of the entered currency
CURRENCY_CONVERSION_TYPEVARCHAR2(30)
Currency conversion type used
CURRENCY_CONVERSION_RATENUMBER

Currency conversion rate used
CURRENCY_CONVERSION_DATEDATE

Currency conversion date

[top of page]

PO.PO_ACCRUAL_WRITE_OFFS_ALL does not reference any database object

PO.PO_ACCRUAL_WRITE_OFFS_ALL is referenced by following:

PO
VIEW - PO_ACCRUAL_WRITE_OFFS_ALL#
PO_ACCRUAL_WRITE_OFFS_ALL#

[top of page]

Table: PO_ACCRUAL_WRITE_OFFS_ALL_EFC

Description:archive for euro functional currency project
Comments

PO_ACCRUAL_WRITE_OFFS_ALL_EFC holds data in original sob currency before the euro switch

Columns
NameDatatypeLengthMandatoryComments
TRANSACTION_AMOUNTNUMBER

transaction amount
WRITE_OFF_IDNUMBER
Ywrite off identifier
AVG_RECEIPT_PRICENUMBER

average receipt price
TRANSACTION_UNIT_PRICENUMBER

transaction unit price
INVOICE_PRICE_VARIANCENUMBER

invoice price variance
SET_OF_BOOKS_IDNUMBER

set of books identifier
SECURITY_GROUP_IDNUMBER

Security group identifier

[top of page]

PO.PO_ACCRUAL_WRITE_OFFS_ALL_EFC does not reference any database object