[Home] [Help] [Dependency Information]
Object Name: | AP_OTHER_PERIOD_TYPES |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_OTHER_PERIOD_TYPES |
Subobject Name: | |
Status: | VALID |
AP_OTHER_PERIOD_TYPES stores the period type
you define and use to create recurring invoice, automatic
withholding tax, key indicators and payment terms
periods. You need one row for each type of period
you use to create recurring invoice, automatic withholding
tax, key indicators or payment terms periods. You must enter
a row in this table before you can create rows in
AP_OTHER_PERIODS. Examples of period types are
Monthly, Semi-Annual, and Quarterly. Values for
MODULE may be 'KEY INDICATORS', 'RECURRING PAYMENTS',
'AWT' or 'PAYMENT TERMS'.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
AP_OTHER_PERIOD_TYPES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
PERIOD_TYPE
MODULE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PERIOD_TYPE | VARCHAR2 | (15) | Yes | Name of period type |
MODULE | VARCHAR2 | (30) | Yes | Name of module for which period types are created |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
PERIODS_PER_YEAR | NUMBER | Yes | Number of periods in one year | |
DESCRIPTION | VARCHAR2 | (240) | Description | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (150) | 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 | |
CONTEXT | VARCHAR2 | (150) | No longer used | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
CREATION_DATE | DATE | Standard who column - date when this row was created. | ||
CREATED_BY | NUMBER | (15) | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
Cut, paste (and edit) the following text to query this object:
SELECT PERIOD_TYPE
, MODULE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, PERIODS_PER_YEAR
, DESCRIPTION
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, LAST_UPDATE_LOGIN
, CREATION_DATE
, CREATED_BY
FROM AP.AP_OTHER_PERIOD_TYPES;
AP.AP_OTHER_PERIOD_TYPES does not reference any database object
AP.AP_OTHER_PERIOD_TYPES is referenced by following:
|
|
|