DBA Data[Home] [Help] [Dependency Information]

TABLE: FII.FII_AP_PAY_SCHED_B

Object Details
Object Name: FII_AP_PAY_SCHED_B
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AP_PAY_SCHED_B
Subobject Name:
Status: VALID


Base Summary Table for Invoice Payment Schedules. It is used to support Payables portlets.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
FII_AP_PAY_SCHED_B_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnINVOICE_ID
ColumnPAYMENT_NUM
FII_AP_PAY_SCHED_B_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_SUMMARY ColumnORG_ID
ColumnSUPPLIER_ID
ColumnACTION_DATE
ColumnDUE_DATE
Columns
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
Query Text

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;

Dependencies

[top of page]

FII.FII_AP_PAY_SCHED_B does not reference any database object

FII.FII_AP_PAY_SCHED_B is referenced by following:

SchemaAPPS
Materialized ViewFII_AP_HLIA_IB_MV
Materialized ViewFII_AP_HLIA_I_MV
Materialized ViewFII_AP_INV_B_MV
Materialized ViewFII_AP_INV_PAYMENTS_MV
Materialized ViewFII_AP_LIA_B_MV
Materialized ViewFII_AP_PAID_XB_MV
Materialized ViewFII_AP_PAYOL_XB_MV
SynonymFII_AP_PAY_SCHED_B
Materialized ViewFII_AP_PMT_SCHEDULES_MV
Materialized ViewISC_TRN_004_MV