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

TABLE: PO.RCV_MC_SUB_LEDGER_DETAILS

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


RCV_MC_SUB_LEDGER_DETAILS stores currency information about
the receiving subledger details for
each reporting Set of Books associated with the parent record in
RCV_SUB_LEDGER_DETAILS.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
RCV_MC_SUB_LEDGER_DETAILS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnRCV_TRANSACTION_ID
RCV_MC_SUB_LEDGER_DETAILS_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPO_LINE_LOCATION_ID
RCV_MC_SUB_LEDGER_DETAILS_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSET_OF_BOOKS_ID
ColumnRCV_SL_DETAILS_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 Identifier
CURRENCY_CODE VARCHAR2 (15) Yes Currency Code
ACTUAL_FLAG VARCHAR2 (1) Yes Balance type-actual,budget or encumbrance
JE_SOURCE_NAME VARCHAR2 (25) Yes JE Source
JE_CATEGORY_NAME VARCHAR2 (25) Yes JE Category
SET_OF_BOOKS_ID NUMBER
Yes Set of books Identifier
ACCOUNTING_DATE DATE
Yes Accounting Date
PO_LINE_LOCATION_ID NUMBER
Yes PO Line Location Identifier
CODE_COMBINATION_ID NUMBER

Code Combination identifier
ACCOUNTED_DR NUMBER

Debit amount in base currency
ACCOUNTED_CR NUMBER

Credit amount in base currency
ENCUMBRANCE_TYPE_ID NUMBER

Encumbrance type identifier
ENTERED_DR NUMBER

Debit amount in base currency
ENTERED_CR NUMBER

Credit amount on entered currency
BUDGET_VERSION_ID NUMBER

Budget Version Identifier
CURRENCY_CONVERSION_DATE DATE

Currency Conversion Date
USER_CURRENCY_CONVERSION_TYPE VARCHAR2 (30)
Currency Exchange 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)
Functional currency code
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)
This journal entry has to be reversed
REVERSAL_PERIOD_NAME VARCHAR2 (15)
Name of the reversal period
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 Documents sequence value
USSGL_TRANSACTION_CODE NUMBER

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 from the source document
ACCRUAL_METHOD_FLAG VARCHAR2 (1)
Indicator whether the accrual method was specified
GL_SL_LINK_ID NUMBER

Unique identifier for the link between general ledger and the subledger
ENTERED_REC_TAX NUMBER

Recoverable tax in the entered currency
ENTERED_NR_TAX NUMBER

Nonrecoverable tax in the entered currency
ACCOUNTED_REC_TAX NUMBER

Accounted Recoverable tax
ACCOUNTED_NR_TAX NUMBER

Accounted Non Recoverable Tax
RCV_SL_DETAILS_ID NUMBER

RCV subledger details unique identifer
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_MC_SUB_LEDGER_DETAILS;

Dependencies

[top of page]

PO.RCV_MC_SUB_LEDGER_DETAILS does not reference any database object

PO.RCV_MC_SUB_LEDGER_DETAILS is referenced by following:

SchemaPO
ViewRCV_MC_SUB_LEDGER_DETAILS#