AP_OTHER_PERIODS
AP_OTHER_PERIODS contains information about the time periods you define for use in recurring invoices, withholding taxes, key indicators and payment terms. Each row includes a start date and an end date to define the length of the period. There is one row for each period you use to create key indicators, withholding tax payments, recurring invoices or payment schedules. Your Oracle Payables application uses this information to determine if periods are available when you define and create recurring invoices or submit a Key Indicators report.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
AP_OTHER_PERIODS_PK |
PERIOD_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments | Flexfield-mapping |
|---|---|---|---|---|---|---|
| APPLICATION_ID | NUMBER | 18 | Yes | Identifier of the application in the period set up. | ||
| PERIOD_NAME | VARCHAR2 | 15 | Yes | Period used for withholding tax calculation or payment terms. | ||
| CALENDAR_TYPE | VARCHAR2 | 30 | Yes | Name of module for which periods are created (GENERAL or PAYMENT TERMS) | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | |||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | ||
| START_DATE | DATE | Yes | Date from when a record is not available for transacting. Use date enabled entities when history is not stored. | |||
| END_DATE | DATE | Yes | Date from when a record is not available for transacting. Use date enabled entities when history is not stored. | |||
| CALENDAR_NAME | VARCHAR2 | 15 | Yes | Name of period (for example, Month) | ||
| PERIOD_YEAR | NUMBER | 18 | Yes | Calendar year in which period occurs | ||
| PERIOD_NUM | NUMBER | 18 | Yes | Order of periods within a payables calendar. | ||
| ENTERED_PERIOD_NAME | VARCHAR2 | 15 | Yes | Period name that Payables creates by automatically appending last two numbers of START DATE to PERIOD NAME | ||
| DESCRIPTION | VARCHAR2 | 240 | Description of the period definition. | |||
| ATTRIBUTE_CATEGORY | VARCHAR2 | 150 | Descriptive Flexfield: structure definition of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE1 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE2 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE3 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE4 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE5 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE6 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE7 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE8 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE9 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE10 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE11 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE12 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE13 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE14 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| ATTRIBUTE15 | VARCHAR2 | 150 | Descriptive Flexfield: segment of the user descriptive flexfield. | Periods for Payables modules (AP_OTHER_PERIODS) | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | |||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | |||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | ||
| DUE_DATE | DATE | Date associated with a payables calendar period that indicates when an invoice payment is due. This is only applicable to payables calendars with a type of payment terms. | ||||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | ||
| PERIOD_ID | NUMBER | 18 | Yes | Identifier of the created period. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_OTHER_PERIODS | ap_other_period_types | CALENDAR_NAME, CALENDAR_TYPE |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_OTHER_PERIODS_U1 | Unique | Default | APPLICATION_ID, CALENDAR_NAME, PERIOD_NAME, CALENDAR_TYPE |
| AP_OTHER_PERIODS_U2 | Unique | Default | APPLICATION_ID, CALENDAR_TYPE, CALENDAR_NAME, PERIOD_YEAR, PERIOD_NUM |
| AP_OTHER_PERIODS_U3 | Unique | Default | PERIOD_ID |