[Home] [Help] [Dependency Information]
Object Name: | AP_INTEREST_PERIODS |
---|---|
Object Type: | TABLE |
Owner: | AP |
FND Design Data: | SQLAP.AP_INTEREST_PERIODS |
Subobject Name: | |
Status: | VALID |
AP_INTEREST_PERIODS contains information about interest rates and
periods that Payables uses to create invoices to pay interest owed on
overdue invoices. This interest is calculated in accordance with the
U.S. Prompt Payment Act.
.
There is one row for each period for which interest accrues
on an invoice.
.
This table has no foreign keys.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTEREST_PERIOD_ID | NUMBER | (15) | Yes | Interest period identifier |
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. | |
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). | |
ANNUAL_INTEREST_RATE | NUMBER | Yes | Annual interest rate | |
START_DATE | DATE | Yes | Start date | |
END_DATE | DATE | Yes | End date |
Cut, paste (and edit) the following text to query this object:
SELECT INTEREST_PERIOD_ID
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ANNUAL_INTEREST_RATE
, START_DATE
, END_DATE
FROM AP.AP_INTEREST_PERIODS;
AP.AP_INTEREST_PERIODS does not reference any database object
AP.AP_INTEREST_PERIODS is referenced by following:
|
|
|