[Home] [Help] [Dependency Information]
Object Name: | FII_AR_SCHEDULED_DISC_F |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AR_SCHEDULED_DISC_F |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_AR_SCHEDULED_DISC_F_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TERM_ID
SEQUENCE_NUM |
FII_AR_SCHEDULED_DISC_F_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SEQUENCE_NUM |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TERM_ID | NUMBER | (15) | Yes | Term identifier |
SEQUENCE_NUM | NUMBER | Yes | Payment schedule sequence number | |
DISCOUNT1_PERCENT | NUMBER | A percent to indicate the first discount rate that customers with this payment term can take for this installment if they pay on or before this payment schedule line's due date | ||
DISCOUNT1_DAYS | NUMBER | The number of days after the invoice's transaction date that the first discount is available to your customer | ||
DISCOUNT1_DATE | DATE | The date that the first discount for this installment's discount line expires | ||
DISCOUNT1_DAY_OF_MONTH | NUMBER | The day of the month that the first discount expires | ||
DISCOUNT1_MONTHS_FORWARD | NUMBER | The number of months ahead that the first discount day of month refers to | ||
DISCOUNT2_PERCENT | NUMBER | A percent to indicate the second discount rate that customers with this payment term can take for this installment if they pay on or before this payment schedule line's due date | ||
DISCOUNT2_DAYS | NUMBER | The number of days after the invoice's transaction date that the second discount is available to your customer | ||
DISCOUNT2_DATE | DATE | The date that the second discount for this installment's discount line expires | ||
DISCOUNT2_DAY_OF_MONTH | NUMBER | The day of the month that the second discount expires | ||
DISCOUNT2_MONTHS_FORWARD | NUMBER | The number of months ahead that the second discount day of month refers to | ||
DISCOUNT3_PERCENT | NUMBER | A percent to indicate the third discount rate that customers with this payment term can take for this installment if they pay on or before this payment schedule line's due date | ||
DISCOUNT3_DAYS | NUMBER | The number of days after the invoice's transaction date that the third discount is available to your customer | ||
DISCOUNT3_DATE | DATE | The date that the third discount for this installment's discount line expires | ||
DISCOUNT3_DAY_OF_MONTH | NUMBER | The day of the month that the third discount expires | ||
DISCOUNT3_MONTHS_FORWARD | NUMBER | The number of months ahead that the third discount day of month refers to | ||
CREATION_DATE | DATE | Yes | Standard who columns | |
CREATED_BY | NUMBER | (15) | Yes | Standard who columns |
LAST_UPDATE_DATE | DATE | Yes | Standard who columns | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who columns |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who columns |
Cut, paste (and edit) the following text to query this object:
SELECT TERM_ID
, SEQUENCE_NUM
, DISCOUNT1_PERCENT
, DISCOUNT1_DAYS
, DISCOUNT1_DATE
, DISCOUNT1_DAY_OF_MONTH
, DISCOUNT1_MONTHS_FORWARD
, DISCOUNT2_PERCENT
, DISCOUNT2_DAYS
, DISCOUNT2_DATE
, DISCOUNT2_DAY_OF_MONTH
, DISCOUNT2_MONTHS_FORWARD
, DISCOUNT3_PERCENT
, DISCOUNT3_DAYS
, DISCOUNT3_DATE
, DISCOUNT3_DAY_OF_MONTH
, DISCOUNT3_MONTHS_FORWARD
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM FII.FII_AR_SCHEDULED_DISC_F;
FII.FII_AR_SCHEDULED_DISC_F does not reference any database object
FII.FII_AR_SCHEDULED_DISC_F is referenced by following:
|
|
|