[Home] [Help] [Dependency Information]
Object Name: | FII_AP_PAY_SCHED_UI_GT |
---|---|
Object Type: | TABLE |
Owner: | FII |
Subobject Name: | |
Status: | VALID |
FII.FII_AP_PAY_SCHED_UI_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
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) | ||
SUPPLIER_ID | NUMBER | (15) | ||
INVOICE_ID | NUMBER | (15) | ||
BASE_CURRENCY_CODE | VARCHAR2 | (25) | ||
TRX_DATE | DATE | |||
PAYMENT_NUM | NUMBER | (15) | ||
DUE_DATE | DATE | |||
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 | |||
AMOUNT_REMAINING_B | NUMBER | |||
PAST_DUE_AMOUNT_B | NUMBER | |||
DISCOUNT_AVAILABLE_B | NUMBER | |||
DISCOUNT_TAKEN_B | NUMBER | |||
DISCOUNT_LOST_B | NUMBER | |||
PAYMENT_AMOUNT_B | NUMBER | |||
ON_TIME_PAYMENT_AMT_B | NUMBER | |||
LATE_PAYMENT_AMT_B | NUMBER | |||
DUE_BUCKET1_B | NUMBER | |||
DUE_BUCKET2_B | NUMBER | |||
DUE_BUCKET3_B | NUMBER | |||
PAST_DUE_BUCKET1_B | NUMBER | |||
PAST_DUE_BUCKET2_B | NUMBER | |||
PAST_DUE_BUCKET3_B | NUMBER | |||
PRIM_AMOUNT_REMAINING | NUMBER | |||
PRIM_PAST_DUE_AMOUNT | NUMBER | |||
PRIM_DISCOUNT_AVAILABLE | NUMBER | |||
PRIM_DISCOUNT_TAKEN | NUMBER | |||
PRIM_DISCOUNT_LOST | NUMBER | |||
PRIM_PAYMENT_AMOUNT | NUMBER | |||
PRIM_ON_TIME_PAYMENT_AMT | NUMBER | |||
PRIM_LATE_PAYMENT_AMT | NUMBER | |||
PRIM_DUE_BUCKET1 | NUMBER | |||
PRIM_DUE_BUCKET2 | NUMBER | |||
PRIM_DUE_BUCKET3 | NUMBER | |||
PRIM_PAST_DUE_BUCKET1 | NUMBER | |||
PRIM_PAST_DUE_BUCKET2 | NUMBER | |||
PRIM_PAST_DUE_BUCKET3 | NUMBER | |||
SEC_AMOUNT_REMAINING | NUMBER | |||
SEC_PAST_DUE_AMOUNT | NUMBER | |||
SEC_DISCOUNT_AVAILABLE | NUMBER | |||
SEC_DISCOUNT_TAKEN | NUMBER | |||
SEC_DISCOUNT_LOST | NUMBER | |||
SEC_PAYMENT_AMOUNT | NUMBER | |||
SEC_ON_TIME_PAYMENT_AMT | NUMBER | |||
SEC_LATE_PAYMENT_AMT | NUMBER | |||
SEC_DUE_BUCKET1 | NUMBER | |||
SEC_DUE_BUCKET2 | NUMBER | |||
SEC_DUE_BUCKET3 | NUMBER | |||
SEC_PAST_DUE_BUCKET1 | NUMBER | |||
SEC_PAST_DUE_BUCKET2 | NUMBER | |||
SEC_PAST_DUE_BUCKET3 | NUMBER | |||
FULLY_PAID_DATE | DATE | |||
CHECK_ID | NUMBER | (15) | ||
PAYMENT_METHOD | VARCHAR2 | (1) | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
CHECK_DATE | DATE | |||
INV_PYMT_FLAG | VARCHAR2 | (1) | ||
UNIQUE_ID | NUMBER |
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_UI_GT;
FII.FII_AP_PAY_SCHED_UI_GT does not reference any database object
FII.FII_AP_PAY_SCHED_UI_GT is referenced by following:
|
|
|