[Home] [Help] [Dependency Information]
Object Name: | MLOG$_FII_AP_PAY_SCHED_B |
---|---|
Object Type: | TABLE |
Owner: | FII |
Subobject Name: | |
Status: | VALID |
snapshot log for master table FII.FII_AP_PAY_SCHED_B
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ACTION | VARCHAR2 | (30) | ||
AMOUNT_REMAINING_B | NUMBER | |||
CHECK_ID | NUMBER | (15) | ||
DISCOUNT_AVAILABLE_B | NUMBER | |||
DISCOUNT_LOST_B | NUMBER | |||
DISCOUNT_TAKEN_B | NUMBER | |||
DUE_BUCKET1_B | NUMBER | |||
DUE_BUCKET2_B | NUMBER | |||
DUE_BUCKET3_B | NUMBER | |||
DUE_DATE | DATE | |||
LATE_PAYMENT_AMT_B | NUMBER | |||
ON_TIME_PAYMENT_AMT_B | NUMBER | |||
ORG_ID | NUMBER | (15) | ||
PAST_DUE_AMOUNT_B | NUMBER | |||
PAST_DUE_BUCKET1_B | NUMBER | |||
PAST_DUE_BUCKET2_B | NUMBER | |||
PAST_DUE_BUCKET3_B | NUMBER | |||
PAYMENT_AMOUNT_B | NUMBER | |||
PAYMENT_METHOD | VARCHAR2 | (1) | ||
PERIOD_TYPE_ID | NUMBER | |||
PRIM_AMOUNT_REMAINING | NUMBER | |||
PRIM_DISCOUNT_AVAILABLE | NUMBER | |||
PRIM_DISCOUNT_LOST | NUMBER | |||
PRIM_DISCOUNT_TAKEN | NUMBER | |||
PRIM_DUE_BUCKET1 | NUMBER | |||
PRIM_DUE_BUCKET2 | NUMBER | |||
PRIM_DUE_BUCKET3 | NUMBER | |||
PRIM_LATE_PAYMENT_AMT | NUMBER | |||
PRIM_ON_TIME_PAYMENT_AMT | NUMBER | |||
PRIM_PAST_DUE_AMOUNT | NUMBER | |||
PRIM_PAST_DUE_BUCKET1 | NUMBER | |||
PRIM_PAST_DUE_BUCKET2 | NUMBER | |||
PRIM_PAST_DUE_BUCKET3 | NUMBER | |||
PRIM_PAYMENT_AMOUNT | NUMBER | |||
SEC_AMOUNT_REMAINING | NUMBER | |||
SEC_DISCOUNT_AVAILABLE | NUMBER | |||
SEC_DISCOUNT_LOST | NUMBER | |||
SEC_DISCOUNT_TAKEN | NUMBER | |||
SEC_DUE_BUCKET1 | NUMBER | |||
SEC_DUE_BUCKET2 | NUMBER | |||
SEC_DUE_BUCKET3 | NUMBER | |||
SEC_LATE_PAYMENT_AMT | NUMBER | |||
SEC_ON_TIME_PAYMENT_AMT | NUMBER | |||
SEC_PAST_DUE_AMOUNT | NUMBER | |||
SEC_PAST_DUE_BUCKET1 | NUMBER | |||
SEC_PAST_DUE_BUCKET2 | NUMBER | |||
SEC_PAST_DUE_BUCKET3 | NUMBER | |||
SEC_PAYMENT_AMOUNT | NUMBER | |||
SUPPLIER_ID | NUMBER | (15) | ||
TIME_ID | NUMBER | |||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) | ||
INVOICE_ID | NUMBER | (15) | ||
ACTION_DATE | DATE | |||
AMOUNT_REMAINING | NUMBER | |||
BASE_CURRENCY_CODE | VARCHAR2 | (25) | ||
CHECK_DATE | DATE | |||
DISCOUNT_AVAILABLE | NUMBER | |||
DISCOUNT_LOST | NUMBER | |||
DISCOUNT_TAKEN | NUMBER | |||
INV_PYMT_FLAG | VARCHAR2 | (1) | ||
LATE_PAYMENT_AMT | NUMBER | |||
NO_DAYS_LATE | NUMBER | (15) | ||
ON_TIME_PAYMENT_AMT | NUMBER | |||
PAST_DUE_AMOUNT | NUMBER | |||
PAYMENT_AMOUNT | NUMBER | |||
PAYMENT_NUM | NUMBER | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT ACTION
, AMOUNT_REMAINING_B
, CHECK_ID
, DISCOUNT_AVAILABLE_B
, DISCOUNT_LOST_B
, DISCOUNT_TAKEN_B
, DUE_BUCKET1_B
, DUE_BUCKET2_B
, DUE_BUCKET3_B
, DUE_DATE
, LATE_PAYMENT_AMT_B
, ON_TIME_PAYMENT_AMT_B
, ORG_ID
, PAST_DUE_AMOUNT_B
, PAST_DUE_BUCKET1_B
, PAST_DUE_BUCKET2_B
, PAST_DUE_BUCKET3_B
, PAYMENT_AMOUNT_B
, PAYMENT_METHOD
, PERIOD_TYPE_ID
, PRIM_AMOUNT_REMAINING
, PRIM_DISCOUNT_AVAILABLE
, PRIM_DISCOUNT_LOST
, PRIM_DISCOUNT_TAKEN
, PRIM_DUE_BUCKET1
, PRIM_DUE_BUCKET2
, PRIM_DUE_BUCKET3
, PRIM_LATE_PAYMENT_AMT
, PRIM_ON_TIME_PAYMENT_AMT
, PRIM_PAST_DUE_AMOUNT
, PRIM_PAST_DUE_BUCKET1
, PRIM_PAST_DUE_BUCKET2
, PRIM_PAST_DUE_BUCKET3
, PRIM_PAYMENT_AMOUNT
, SEC_AMOUNT_REMAINING
, SEC_DISCOUNT_AVAILABLE
, SEC_DISCOUNT_LOST
, SEC_DISCOUNT_TAKEN
, SEC_DUE_BUCKET1
, SEC_DUE_BUCKET2
, SEC_DUE_BUCKET3
, SEC_LATE_PAYMENT_AMT
, SEC_ON_TIME_PAYMENT_AMT
, SEC_PAST_DUE_AMOUNT
, SEC_PAST_DUE_BUCKET1
, SEC_PAST_DUE_BUCKET2
, SEC_PAST_DUE_BUCKET3
, SEC_PAYMENT_AMOUNT
, SUPPLIER_ID
, TIME_ID
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
, INVOICE_ID
, ACTION_DATE
, AMOUNT_REMAINING
, BASE_CURRENCY_CODE
, CHECK_DATE
, DISCOUNT_AVAILABLE
, DISCOUNT_LOST
, DISCOUNT_TAKEN
, INV_PYMT_FLAG
, LATE_PAYMENT_AMT
, NO_DAYS_LATE
, ON_TIME_PAYMENT_AMT
, PAST_DUE_AMOUNT
, PAYMENT_AMOUNT
, PAYMENT_NUM
FROM FII.MLOG$_FII_AP_PAY_SCHED_B;
FII.MLOG$_FII_AP_PAY_SCHED_B does not reference any database object
FII.MLOG$_FII_AP_PAY_SCHED_B is referenced by following:
|
|
|