[Home] [Help] [Dependency Information]
Object Name: | AR_PERIODS |
---|---|
Object Type: | TABLE |
Owner: | AR |
FND Design Data: | AR.AR_PERIODS |
Subobject Name: | |
Status: | VALID |
The AR_PERIODS table is a denormalized table that Receivables uses to improve performance in the AutoInvoice and Revenue Recognition programs. This table is populated from the GL_PERIOD_STATUSES table, and includes rows where the ADJUSTMENT_PERIOD_FLAG column in the GL_PERIOD_STATUSES table is N.
.
The NEW_PERIOD_NUM column stores the sequence of the period if ordered by accounting period start date within an accounting period type.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AR_PERIODS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_SET_NAME
PERIOD_TYPE NEW_PERIOD_NUM |
AR_PERIODS_U2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_SET_NAME
PERIOD_TYPE END_DATE START_DATE |
AR_PERIODS_U3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_SET_NAME
PERIOD_NAME |
AR_PERIODS_U4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PERIOD_TYPE
PERIOD_SET_NAME START_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_SET_NAME | VARCHAR2 | (30) | Yes | Accounting set name |
PERIOD_TYPE | VARCHAR2 | (30) | Yes | Accounting period type |
START_DATE | DATE | Yes | Date when accounting period begins | |
END_DATE | DATE | Yes | Date when accounting period ends | |
NEW_PERIOD_NUM | NUMBER | Maintains the next nonadjusting period within the same period set name and period type | ||
PERIOD_NAME | VARCHAR2 | (30) | Yes | System-generated accounting period name |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_SET_NAME
, PERIOD_TYPE
, START_DATE
, END_DATE
, NEW_PERIOD_NUM
, PERIOD_NAME
FROM AR.AR_PERIODS;
AR.AR_PERIODS does not reference any database object
AR.AR_PERIODS is referenced by following:
|
|
|