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_RECEIVING_SUB_LEDGER

Object Details

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

RCV_RECEIVING_SUB_LEDGER stores information about accounting entries
generated within the receiving business unit. This information is a
back-up copy of all receiving inspection journal entries inserted into
the GL_INTERFACE table. RCV_RECEIVING_SUB_LEDGER contains one row for
every debit or credit generated by the receiving process. If you use
online accruals, this table will have actual debit and credit
entries.
If you use purchase order encumbrance, this table will encumber
debit and credit entries.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
RCV_RECEIVING_SUB_LEDGER_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCV_TRANSACTION_ID
RCV_RECEIVING_SUB_LEDGER_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE3 CODE_COMBINATION_ID
RCV_RECEIVING_SUB_LEDGER_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	RCV_SUB_LEDGER_ID
RCV_RECEIVING_SUB_LEDGER_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID TRANSACTION_DATE
RCV_RECEIVING_SUB_LEDGER_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PA_ADDITION_FLAG
RCV_RECEIVING_SUB_LEDGER_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REFERENCE9 ACCOUNTING_EVENT_ID

Columns

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

Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      RCV_TRANSACTION_ID
,      CURRENCY_CODE
,      ACTUAL_FLAG
,      JE_SOURCE_NAME
,      JE_CATEGORY_NAME
,      SET_OF_BOOKS_ID
,      ACCOUNTING_DATE
,      CODE_COMBINATION_ID
,      ACCOUNTED_DR
,      ACCOUNTED_CR
,      ENCUMBRANCE_TYPE_ID
,      ENTERED_DR
,      ENTERED_CR
,      BUDGET_VERSION_ID
,      CURRENCY_CONVERSION_DATE
,      USER_CURRENCY_CONVERSION_TYPE
,      CURRENCY_CONVERSION_RATE
,      TRANSACTION_DATE
,      PERIOD_NAME
,      CHART_OF_ACCOUNTS_ID
,      FUNCTIONAL_CURRENCY_CODE
,      DATE_CREATED_IN_GL
,      JE_BATCH_NAME
,      JE_BATCH_DESCRIPTION
,      JE_HEADER_NAME
,      JE_LINE_DESCRIPTION
,      REVERSE_JOURNAL_FLAG
,      REVERSAL_PERIOD_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      SUBLEDGER_DOC_SEQUENCE_ID
,      SUBLEDGER_DOC_SEQUENCE_VALUE
,      USSGL_TRANSACTION_CODE
,      REFERENCE1
,      REFERENCE2
,      REFERENCE3
,      REFERENCE4
,      REFERENCE5
,      REFERENCE6
,      REFERENCE7
,      REFERENCE8
,      REFERENCE9
,      REFERENCE10
,      SOURCE_DOC_QUANTITY
,      ACCRUAL_METHOD_FLAG
,      GL_SL_LINK_ID
,      ENTERED_REC_TAX
,      ENTERED_NR_TAX
,      ACCOUNTED_REC_TAX
,      ACCOUNTED_NR_TAX
,      RCV_SUB_LEDGER_ID
,      ACCOUNTING_EVENT_ID
,      ACCOUNTING_LINE_TYPE
,      PA_ADDITION_FLAG
FROM PO.RCV_RECEIVING_SUB_LEDGER;

Dependencies

[top of page]

PO.RCV_RECEIVING_SUB_LEDGER does not reference any database object

PO.RCV_RECEIVING_SUB_LEDGER is referenced by following:

APPS: JAI_RCV_RRSL_ARIUD_T1; RCV_RECEIVING_SUB_LEDGER