[Home] [Help] [Dependency Information]

TABLE: AR.AR_PERIOD_TYPES

Object Details

Object Name:	AR_PERIOD_TYPES
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.AR_PERIOD_TYPES
Subobject Name:
Status:	VALID

The AR_PERIOD_TYPES table contains the maximum number of days in a period within a type of period. For example, a fiscal month could be defined as having a maximum of 30 days. This table improves the performance of the AutoInvoice and Revenue Recognition programs.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AR_PERIOD_TYPES_U1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERIOD_TYPE

Columns

Query Text

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

SELECT PERIOD_TYPE
,      MAX_REGULAR_PERIOD_LENGTH
FROM AR.AR_PERIOD_TYPES;

Dependencies

[top of page]

AR.AR_PERIOD_TYPES does not reference any database object

AR.AR_PERIOD_TYPES is referenced by following:

AR

AR_PERIOD_TYPES#