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

TABLE: PO.RCV_SUB_LEDGER_DETAILS

Object Details
Object Name: RCV_SUB_LEDGER_DETAILS
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.RCV_SUB_LEDGER_DETAILS
Subobject Name:
Status: VALID


RCV_SUB_LEDGER_DETAILS stores information about accounting entries generated within the receiving business unit. RCV_SUB_LEDGER_DETAILS 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. This table is used only for period-end accruals.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RCV_SUB_LEDGER_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRCV_TRANSACTION_ID
RCV_SUB_LEDGER_DETAILS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_LOCATION_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 Unique identifier for the receiving transaction
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 Unique identifier for the accounting Set of Books
ACCOUNTING_DATE DATE
Yes Accounting transaction effective date
PO_LINE_LOCATION_ID NUMBER
Yes Unique identifier for the document shipment schedule
CODE_COMBINATION_ID NUMBER

Unique identifier for the General Ledger account
ACCOUNTED_DR NUMBER

Debit amount in base currency
ACCOUNTED_CR NUMBER

Credit amount in base currency
ENCUMBRANCE_TYPE_ID NUMBER

Unique identifier for encumbrance batch
ENTERED_DR NUMBER

Debit amount in entered currency
ENTERED_CR NUMBER

Credit amount in entered currency
BUDGET_VERSION_ID NUMBER

Unique identifier for budget version
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

Unique identifier for the chart of accounts
FUNCTIONAL_CURRENCY_CODE VARCHAR2 (15)
Unique identifier for the base currency
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)
Indicator 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

Unique identifier for the subledger document
SUBLEDGER_DOC_SEQUENCE_VALUE NUMBER

Sub ledger document sequence
USSGL_TRANSACTION_CODE VARCHAR2 (30)
United States standard general ledger transaction code
REFERENCE1 VARCHAR2 (30)
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 on the 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
ENTERED_NR_TAX NUMBER

Nonrecoverable tax
ACCOUNTED_REC_TAX NUMBER

Accounted recoverable tax
ACCOUNTED_NR_TAX NUMBER

Accounted nonrecoverable tax
RCV_SL_DETAILS_ID NUMBER

Subledger details unique identifier
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
,      PO_LINE_LOCATION_ID
,      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_SL_DETAILS_ID
FROM PO.RCV_SUB_LEDGER_DETAILS;

Dependencies

[top of page]

PO.RCV_SUB_LEDGER_DETAILS does not reference any database object

PO.RCV_SUB_LEDGER_DETAILS is referenced by following:

SchemaAPPS
SynonymRCV_SUB_LEDGER_DETAILS