[Home] [Help] [Dependency Information]
Object Name: | FII_AP_PAY_SCHED_B |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AP_PAY_SCHED_B |
Subobject Name: | |
Status: | VALID |
Base Summary Table for Invoice Payment Schedules. It is used to support Payables portlets.
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_AP_PAY_SCHED_B_N1 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
INVOICE_ID
PAYMENT_NUM |
FII_AP_PAY_SCHED_B_N2 | NORMAL | NONUNIQUE | APPS_TS_SUMMARY |
ORG_ID
SUPPLIER_ID ACTION_DATE DUE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | Forign key to time levels | ||
PERIOD_TYPE_ID | NUMBER | Type of the period | ||
ACTION_DATE | DATE | Date an action happened | ||
ACTION | VARCHAR2 | (30) | Action happened on the payment schedule | |
UPDATE_SEQUENCE | NUMBER | (15) | Sequence to identify the invoices to be updated | |
ORG_ID | NUMBER | (15) | Organization identifier | |
SUPPLIER_ID | NUMBER | (15) | Supplier identifier | |
INVOICE_ID | NUMBER | (15) | Invoice identifier | |
BASE_CURRENCY_CODE | VARCHAR2 | (25) | Functional currency code of invoice | |
TRX_DATE | DATE | Invoice date | ||
PAYMENT_NUM | NUMBER | (15) | Payment number | |
DUE_DATE | DATE | Due date | ||
AMOUNT_REMAINING | NUMBER | Invoice amount remaining for payment | ||
PAST_DUE_AMOUNT | NUMBER | Invoice amount past due | ||
DISCOUNT_AVAILABLE | NUMBER | Discount amount available | ||
DISCOUNT_TAKEN | NUMBER | Amount of discount taken | ||
DISCOUNT_LOST | NUMBER | Amount of discount lost | ||
PAYMENT_AMOUNT | NUMBER | Payment amount | ||
ON_TIME_PAYMENT_AMT | NUMBER | Amount paid on time | ||
LATE_PAYMENT_AMT | NUMBER | Amount paid late | ||
NO_DAYS_LATE | NUMBER | (15) | Number of days paid late | |
DUE_BUCKET1 | NUMBER | Amount due in bucket1 | ||
DUE_BUCKET2 | NUMBER | Amount due in bucket2 | ||
DUE_BUCKET3 | NUMBER | Amount due in bucket3 | ||
PAST_DUE_BUCKET1 | NUMBER | Amount past due in bucket1 | ||
PAST_DUE_BUCKET2 | NUMBER | Amount past due in bucket2 | ||
PAST_DUE_BUCKET3 | NUMBER | Amount past due in bucket3 | ||
AMOUNT_REMAINING_B | NUMBER | Invoice amount remaining for payment in functional currency | ||
PAST_DUE_AMOUNT_B | NUMBER | Invoice amount past due in functional currency | ||
DISCOUNT_AVAILABLE_B | NUMBER | Discount amount available in functional currency | ||
DISCOUNT_TAKEN_B | NUMBER | Amount of discount taken in functional currency | ||
DISCOUNT_LOST_B | NUMBER | Amount of discount lost in functional currency | ||
PAYMENT_AMOUNT_B | NUMBER | Payment amount in functional currency | ||
ON_TIME_PAYMENT_AMT_B | NUMBER | Amount paid on time in functional currency | ||
LATE_PAYMENT_AMT_B | NUMBER | Amount paid late in functional currency | ||
DUE_BUCKET1_B | NUMBER | Amount due in bucket1 in functional currency | ||
DUE_BUCKET2_B | NUMBER | Amount due in bucket2 in functional currency | ||
DUE_BUCKET3_B | NUMBER | Amount due in bucket3 in functional currency | ||
PAST_DUE_BUCKET1_B | NUMBER | Amount past due in bucket1 in functional currency | ||
PAST_DUE_BUCKET2_B | NUMBER | Amount past due in bucket2 in functional currency | ||
PAST_DUE_BUCKET3_B | NUMBER | Amount past due in bucket3 in functional currency | ||
PRIM_AMOUNT_REMAINING | NUMBER | Invoice amount remaining for payment in primary global currency | ||
PRIM_PAST_DUE_AMOUNT | NUMBER | Invoice amount past due in primary global currency | ||
PRIM_DISCOUNT_AVAILABLE | NUMBER | Discount amount available in primary global currency | ||
PRIM_DISCOUNT_TAKEN | NUMBER | Amount of discount taken in primary global currency | ||
PRIM_DISCOUNT_LOST | NUMBER | Amount of discount lost in primary global currency | ||
PRIM_PAYMENT_AMOUNT | NUMBER | Payment amount in primary global currency | ||
PRIM_ON_TIME_PAYMENT_AMT | NUMBER | Amount paid on time in primary global currency | ||
PRIM_LATE_PAYMENT_AMT | NUMBER | Amount paid late in primary global currency | ||
PRIM_DUE_BUCKET1 | NUMBER | Amount due in bucket1 in primary global currency | ||
PRIM_DUE_BUCKET2 | NUMBER | Amount due in bucket2 in primary global currency | ||
PRIM_DUE_BUCKET3 | NUMBER | Amount due in bucket3 in primary global currency | ||
PRIM_PAST_DUE_BUCKET1 | NUMBER | Amount past due in bucket1 in primary global currency | ||
PRIM_PAST_DUE_BUCKET2 | NUMBER | Amount past due in bucket2 in primary global currency | ||
PRIM_PAST_DUE_BUCKET3 | NUMBER | Amount past due in bucket3 in primary global currency | ||
SEC_AMOUNT_REMAINING | NUMBER | Invoice amount remaining for payment in sec global currency | ||
SEC_PAST_DUE_AMOUNT | NUMBER | Invoice amount past due in sec global currency | ||
SEC_DISCOUNT_AVAILABLE | NUMBER | Discount amount available in sec global currency | ||
SEC_DISCOUNT_TAKEN | NUMBER | Amount of discount taken in sec global currency | ||
SEC_DISCOUNT_LOST | NUMBER | Amount of discount lost in sec global currency | ||
SEC_PAYMENT_AMOUNT | NUMBER | Payment amount in sec global currency | ||
SEC_ON_TIME_PAYMENT_AMT | NUMBER | Amount paid on time in sec global currency | ||
SEC_LATE_PAYMENT_AMT | NUMBER | Amount paid late in sec global currency | ||
SEC_DUE_BUCKET1 | NUMBER | Amount due in bucket1 in sec global currency | ||
SEC_DUE_BUCKET2 | NUMBER | Amount due in bucket2 in sec global currency | ||
SEC_DUE_BUCKET3 | NUMBER | Amount due in bucket3 in sec global currency | ||
SEC_PAST_DUE_BUCKET1 | NUMBER | Amount past due in bucket1 in sec global currency | ||
SEC_PAST_DUE_BUCKET2 | NUMBER | Amount past due in bucket2 in sec global currency | ||
SEC_PAST_DUE_BUCKET3 | NUMBER | Amount past due in bucket3 in sec global currency | ||
FULLY_PAID_DATE | DATE | Date the payment schedule is fully paid | ||
CHECK_ID | NUMBER | (15) | Payment identifier | |
PAYMENT_METHOD | VARCHAR2 | (1) | Name of payment method | |
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). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
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). | |
CHECK_DATE | DATE | Payment Date | ||
INV_PYMT_FLAG | VARCHAR2 | (1) | Flag to indicate type of Payment | |
UNIQUE_ID | NUMBER | Identifier to distinguish record |
Cut, paste (and edit) the following text to query this object:
SELECT TIME_ID
, PERIOD_TYPE_ID
, ACTION_DATE
, ACTION
, UPDATE_SEQUENCE
, ORG_ID
, SUPPLIER_ID
, INVOICE_ID
, BASE_CURRENCY_CODE
, TRX_DATE
, PAYMENT_NUM
, DUE_DATE
, AMOUNT_REMAINING
, PAST_DUE_AMOUNT
, DISCOUNT_AVAILABLE
, DISCOUNT_TAKEN
, DISCOUNT_LOST
, PAYMENT_AMOUNT
, ON_TIME_PAYMENT_AMT
, LATE_PAYMENT_AMT
, NO_DAYS_LATE
, DUE_BUCKET1
, DUE_BUCKET2
, DUE_BUCKET3
, PAST_DUE_BUCKET1
, PAST_DUE_BUCKET2
, PAST_DUE_BUCKET3
, AMOUNT_REMAINING_B
, PAST_DUE_AMOUNT_B
, DISCOUNT_AVAILABLE_B
, DISCOUNT_TAKEN_B
, DISCOUNT_LOST_B
, PAYMENT_AMOUNT_B
, ON_TIME_PAYMENT_AMT_B
, LATE_PAYMENT_AMT_B
, DUE_BUCKET1_B
, DUE_BUCKET2_B
, DUE_BUCKET3_B
, PAST_DUE_BUCKET1_B
, PAST_DUE_BUCKET2_B
, PAST_DUE_BUCKET3_B
, PRIM_AMOUNT_REMAINING
, PRIM_PAST_DUE_AMOUNT
, PRIM_DISCOUNT_AVAILABLE
, PRIM_DISCOUNT_TAKEN
, PRIM_DISCOUNT_LOST
, PRIM_PAYMENT_AMOUNT
, PRIM_ON_TIME_PAYMENT_AMT
, PRIM_LATE_PAYMENT_AMT
, PRIM_DUE_BUCKET1
, PRIM_DUE_BUCKET2
, PRIM_DUE_BUCKET3
, PRIM_PAST_DUE_BUCKET1
, PRIM_PAST_DUE_BUCKET2
, PRIM_PAST_DUE_BUCKET3
, SEC_AMOUNT_REMAINING
, SEC_PAST_DUE_AMOUNT
, SEC_DISCOUNT_AVAILABLE
, SEC_DISCOUNT_TAKEN
, SEC_DISCOUNT_LOST
, SEC_PAYMENT_AMOUNT
, SEC_ON_TIME_PAYMENT_AMT
, SEC_LATE_PAYMENT_AMT
, SEC_DUE_BUCKET1
, SEC_DUE_BUCKET2
, SEC_DUE_BUCKET3
, SEC_PAST_DUE_BUCKET1
, SEC_PAST_DUE_BUCKET2
, SEC_PAST_DUE_BUCKET3
, FULLY_PAID_DATE
, CHECK_ID
, PAYMENT_METHOD
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CHECK_DATE
, INV_PYMT_FLAG
, UNIQUE_ID
FROM FII.FII_AP_PAY_SCHED_B;
FII.FII_AP_PAY_SCHED_B does not reference any database object
FII.FII_AP_PAY_SCHED_B is referenced by following:
|
|
|