[Home] [Help] [Dependency Information]
Object Name: | AR_POSTING_REPORT_INTERIM |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_POSTING_REPORT_INTERIM |
Subobject Name: | |
Status: | VALID |
The AR_POSTING_REPORT_INTERIM table contains posting cycle information that is summarized by category and currency.
.
The Posting Execution report uses this table, which is populated by the GL Transfer Program. The Posting Execution report first extracts information from the table, and then the GL Transfer program deletes table rows.
.
This table was created so that the Posting Execution report does not directly hit the GL_INTERFACE table, as required for distributed applications.
.
The primary keys for this table are POSTING_CONTROL_ID, CURRENCY_CODE, USER_JE_CATEGORY_NAME, and CYCLE_NUMBER.
Tablespace: | APPS_TS_NOLOGGING |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_POSTING_REPORT_INTERIM_U1 | NORMAL | UNIQUE | APPS_TS_NOLOGGING |
POSTING_CONTROL_ID
CURRENCY_CODE USER_JE_CATEGORY_NAME CYCLE_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
POSTING_CONTROL_ID | NUMBER | (15) | Yes | Receivables posting batch identifier |
CURRENCY_CODE | VARCHAR2 | (15) | Yes | Currency code for posting report row |
USER_JE_CATEGORY_NAME | VARCHAR2 | (25) | Yes | General Ledger category of this row |
CYCLE_NUMBER | NUMBER | (15) | Yes | The posting cycle of this row |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
ENTERED_DR | NUMBER | Yes | Sum of entered debits | |
ENTERED_CR | NUMBER | Yes | Sum of entered credits | |
ACCOUNTED_DR | NUMBER | Yes | Sum of accounted debits | |
ACCOUNTED_CR | NUMBER | Yes | Sum of accounted credits | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. |
Cut, paste (and edit) the following text to query this object:
SELECT POSTING_CONTROL_ID
, CURRENCY_CODE
, USER_JE_CATEGORY_NAME
, CYCLE_NUMBER
, SET_OF_BOOKS_ID
, ENTERED_DR
, ENTERED_CR
, ACCOUNTED_DR
, ACCOUNTED_CR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM AR.AR_POSTING_REPORT_INTERIM;
AR.AR_POSTING_REPORT_INTERIM does not reference any database object
AR.AR_POSTING_REPORT_INTERIM is referenced by following:
|
|
|