eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: PO.RCV_ACCOUNTING_EVENTS

Object Details

Object Name:	RCV_ACCOUNTING_EVENTS
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.RCV_ACCOUNTING_EVENTS
Subobject Name:
Status:	VALID

RCV_Accounting_Events stores accounting events for the Receiving Subledger. The corresponding accounting entries are stored in the RCV_Receving_Sub_Ledger table. Accounting entries may be generated when a receiving transaction is performed, when a retroactive price change is approved on a PO, and when Invoices are validated for period-end accruals in a Shared Services procurement scenario. You can only delete rows from this table using the Purge feature of Oracle Purchasing.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_ACCOUNTING_EVENTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACCOUNTING_EVENT_ID
RCV_ACCOUNTING_EVENTS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCV_TRANSACTION_ID
RCV_ACCOUNTING_EVENTS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVOICED_FLAG
RCV_ACCOUNTING_EVENTS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TRANSACTION_DATE INVENTORY_ITEM_ID ORGANIZATION_ID
RCV_ACCOUNTING_EVENTS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_HEADER_ID

Columns

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

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ACCOUNTING_EVENT_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UDPATE_DATE
,      RCV_TRANSACTION_ID
,      EVENT_TYPE_ID
,      EVENT_SOURCE
,      EVENT_SOURCE_ID
,      SET_OF_BOOKS_ID
,      ORG_ID
,      TRANSFER_ORG_ID
,      ORGANIZATION_ID
,      TRANSFER_ORGANIZATION_ID
,      DEBIT_ACCOUNT_ID
,      CREDIT_ACCOUNT_ID
,      TRANSACTION_DATE
,      TRANSACTION_QUANTITY
,      TRANSACTION_UNIT_OF_MEASURE
,      SOURCE_DOC_QUANTITY
,      SOURCE_DOC_UNIT_OF_MEASURE
,      PRIMARY_QUANTITY
,      PRIMARY_UNIT_OF_MEASURE
,      INVENTORY_ITEM_ID
,      PO_HEADER_ID
,      PO_RELEASE_ID
,      PO_LINE_ID
,      PO_LINE_LOCATION_ID
,      PO_DISTRIBUTION_ID
,      INTERCOMPANY_PRICING_OPTION
,      UNIT_PRICE
,      TRANSACTION_AMOUNT
,      PRIOR_UNIT_PRICE
,      NR_TAX
,      REC_TAX
,      NR_TAX_AMOUNT
,      REC_TAX_AMOUNT
,      PRIOR_NR_TAX
,      PRIOR_REC_TAX
,      CURRENCY_CODE
,      CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      CURRENCY_CONVERSION_DATE
,      ACCOUNTED_FLAG
,      PROCUREMENT_ORG_FLAG
,      CROSS_OU_FLAG
,      TRX_FLOW_HEADER_ID
,      INVOICED_FLAG
,      PA_ADDITION_FLAG
,      USSGL_TRANSACTION_CODE
,      GL_GROUP_ID
,      QUANTITY_RECEIVED
,      QUANTITY_INVOICED
,      AMOUNT_RECEIVED
,      AMOUNT_INVOICED
,      LCM_ACCOUNT_ID
,      UNIT_LANDED_COST
FROM PO.RCV_ACCOUNTING_EVENTS;

Dependencies

[top of page]

PO.RCV_ACCOUNTING_EVENTS does not reference any database object

PO.RCV_ACCOUNTING_EVENTS is referenced by following:

PO: RCV_ACCOUNTING_EVENTS#