[Home] [Help] [Dependency Information]
Object Name: | FII_AP_PAY_SCHED_TEMP |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | FII.FII_AP_PAY_SCHED_TEMP |
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_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FII_AP_PAY_SCHED_TEMP_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | INVOICE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
TIME_ID | NUMBER | |||
PERIOD_TYPE_ID | NUMBER | |||
ACTION_DATE | DATE | |||
ACTION | VARCHAR2 | (30) | ||
UPDATE_SEQUENCE | NUMBER | (15) | ||
ORG_ID | NUMBER | (15) | Organization identifier | |
SUPPLIER_ID | NUMBER | (15) | ||
INVOICE_ID | NUMBER | (15) | ||
BASE_CURRENCY_CODE | VARCHAR2 | (25) | ||
TRX_DATE | DATE | |||
PAYMENT_NUM | NUMBER | (15) | ||
DUE_DATE | DATE | |||
CREATED_BY | NUMBER | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | ||
AMOUNT_REMAINING | NUMBER | |||
PAST_DUE_AMOUNT | NUMBER | |||
DISCOUNT_AVAILABLE | NUMBER | |||
DISCOUNT_TAKEN | NUMBER | |||
DISCOUNT_LOST | NUMBER | |||
PAYMENT_AMOUNT | NUMBER | |||
ON_TIME_PAYMENT_AMT | NUMBER | |||
LATE_PAYMENT_AMT | NUMBER | |||
NO_DAYS_LATE | NUMBER | (15) | ||
DUE_BUCKET1 | NUMBER | |||
DUE_BUCKET2 | NUMBER | |||
DUE_BUCKET3 | NUMBER | |||
PAST_DUE_BUCKET1 | NUMBER | |||
PAST_DUE_BUCKET2 | NUMBER | |||
PAST_DUE_BUCKET3 | NUMBER | |||
FULLY_PAID_DATE | DATE | |||
CHECK_ID | NUMBER | (15) | ||
PAYMENT_METHOD | VARCHAR2 | (1) | ||
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
, CREATED_BY
, 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
, FULLY_PAID_DATE
, CHECK_ID
, PAYMENT_METHOD
, CHECK_DATE
, INV_PYMT_FLAG
, UNIQUE_ID
FROM FII.FII_AP_PAY_SCHED_TEMP;
FII.FII_AP_PAY_SCHED_TEMP does not reference any database object
FII.FII_AP_PAY_SCHED_TEMP is referenced by following:
|
|
|