[Home] [Help] [Dependency Information]
Object Name: | FII_AP_LIA_B_MV |
---|---|
Object Type: | TABLE |
Owner: | APPS |
FND Design Data: | FND.FII_AP_LIA_B_MV |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MARKER | NUMBER | H for Hold placed and R for Hold Released | ||
ROW_ID | ROWID | (10) | Row identifier from the fii_ap_inv_holds_b summary table | |
PS_ROW_ID | ROWID | (10) | Row identifier from the fii_ap_pay_sched_b table | |
ORG_ID | NUMBER | (15) | Operating Unit Identifier | |
SUPPLIER_ID | NUMBER | (15) | Supplier Identifier | |
TIME_ID | NUMBER | Time identifier | ||
UNPAID_AMT_B | NUMBER | Total unpaid invoice amounts in base currency | ||
PRIM_UNPAID_AMT | NUMBER | Total unpaid invoice amounts in primary currency | ||
SEC_UNPAID_AMT | NUMBER | Total unpaid invoice amounts in secondary currency | ||
UNPAID_COUNT | NUMBER | Total number of unpaid invoices | ||
DUE_COUNT | NUMBER | Total number of unpaid invoices which are due | ||
PAST_DUE_AMT_B | NUMBER | Total past due invoice amounts in base currency | ||
PRIM_PAST_DUE_AMT | NUMBER | Total past due invoice amounts in primary currency | ||
SEC_PAST_DUE_AMT | NUMBER | Toal past due invoice amounts in secondary currency | ||
PAST_DUE_COUNT | NUMBER | Total number of invoices entered which are past due | ||
PAYMENT_AMT_B | NUMBER | Total payment amount in base currency | ||
PRIM_PAYMENT_AMT | NUMBER | Total payment amount in primary currency | ||
SEC_PAYMENT_AMT | NUMBER | Total payment amount in secondary currency | ||
DISCOUNT_OFFERED_B | NUMBER | Total discounts offered in base currency | ||
PRIM_DISCOUNT_OFFERED | NUMBER | Total discounts in primary currency | ||
SEC_DISCOUNT_OFFERED | NUMBER | Total discounts offered in secondary currency | ||
DISCOUNT_REMAINING_B | NUMBER | Total discounts remaining in base currency | ||
PRIM_DISCOUNT_REMAINING | NUMBER | Total discounts remaining in primary currency | ||
SEC_DISCOUNT_REMAINING | NUMBER | Total discounts remaining in secondary currency | ||
DISCOUNT_TAKEN_B | NUMBER | Total discounts taken in base currency | ||
PRIM_DISCOUNT_TAKEN | NUMBER | Total discounts taken in primary currency | ||
SEC_DISCOUNT_TAKEN | NUMBER | Total discounts taken in secondary currency | ||
DISCOUNT_LOST_B | NUMBER | Total discounts lost in base currency | ||
PRIM_DISCOUNT_LOST | NUMBER | Total discounts lost in primary currency | ||
SEC_DISCOUNT_LOST | NUMBER | Total discounts lost in secondary currency | ||
DUE_BUCKET1_B | NUMBER | Total invoice amounts Due After 30 Days in base currency | ||
PRIM_DUE_BUCKET1 | NUMBER | Total invoice amounts Due After 30 Days in primary currency | ||
SEC_DUE_BUCKET1 | NUMBER | Total invoice amounts Due After 30 Days in secondary currency | ||
DUE_BUCKET1_COUNT | NUMBER | Total number of invoices Due After 30 Days | ||
DUE_BUCKET2_B | NUMBER | Total invoice amounts Due in 16 - 30 Days in base currency | ||
PRIM_DUE_BUCKET2 | NUMBER | Total invoice amounts Due in 16 - 30 Days in primary currency | ||
SEC_DUE_BUCKET2 | NUMBER | Total invoice amounts Due in 16 - 30 Days in secondary currency | ||
DUE_BUCKET2_COUNT | NUMBER | Total number of invoices Due in 16 - 30 Days | ||
DUE_BUCKET3_B | NUMBER | Total invoice amounts Due in 1 - 15 Days in base currency | ||
PRIM_DUE_BUCKET3 | NUMBER | Total invoice amounts Due in 1 - 15 Days in primary currency | ||
SEC_DUE_BUCKET3 | NUMBER | Total invoice amounts Due in 1 - 15 Days in secondary currency | ||
DUE_BUCKET3_COUNT | NUMBER | Total number of invoices Due in 1 - 15 Days | ||
PAST_DUE_BUCKET1_B | NUMBER | Total invoice amounts Past Due After 30 Days in base currency | ||
PRIM_PAST_DUE_BUCKET1 | NUMBER | Total invoice amounts Past Due After 30 Days in primary currency | ||
SEC_PAST_DUE_BUCKET1 | NUMBER | Total invoice amounts Past Due After 30 Days in secondary currency | ||
PAST_DUE_BUCKET1_COUNT | NUMBER | Total number of invoices Past Due After 30 Days | ||
PAST_DUE_BUCKET2_B | NUMBER | Total invoice amounts Past Due in 16 - 30 Days in base currency | ||
PRIM_PAST_DUE_BUCKET2 | NUMBER | Total invoice amounts Past Due in 16 - 30 Days in primary currency | ||
SEC_PAST_DUE_BUCKET2 | NUMBER | Total invoice amounts Past Due in 16 - 30 Days in secondary currency | ||
PAST_DUE_BUCKET2_COUNT | NUMBER | Total number of invoices Past Due in 16 - 30 Days | ||
PAST_DUE_BUCKET3_B | NUMBER | Total invoice amounts Past Due in 1 - 15 Days in base currency | ||
PRIM_PAST_DUE_BUCKET3 | NUMBER | Total invoice amounts Past Due in 1 - 15 Days in primary currency | ||
SEC_PAST_DUE_BUCKET3 | NUMBER | Total invoice amounts Past Due in 1 - 15 Days in secondary currency | ||
PAST_DUE_BUCKET3_COUNT | NUMBER | Total number of invoices Past Due in 1 - 15 Days | ||
ON_TIME_PAYMENT_AMT_B | NUMBER | Total on time payment amounts in base currency | ||
PRIM_ON_TIME_PAYMENT_AMT | NUMBER | Total on time payment amounts in primary currency | ||
SEC_ON_TIME_PAYMENT_AMT | NUMBER | Total on time payment amounts in secondary currency | ||
LATE_PAYMENT_AMT_B | NUMBER | Total late payment amounts in base currency | ||
PRIM_LATE_PAYMENT_AMT | NUMBER | Total late payment amounts in primary currency | ||
SEC_LATE_PAYMENT_AMT | NUMBER | Total late payment amounts in secondary currency | ||
WT_OPEN_DUE_AMT_B | NUMBER | Total weighted due amount in base currency | ||
WT_OPEN_DUE_AMT_PRIM_G | NUMBER | Total weighted due amount in primary currency | ||
WT_OPEN_DUE_AMT_SEC_G | NUMBER | Total weighted due amount in secondary currency | ||
WT_OPEN_PAST_DUE_AMT_B | NUMBER | Total weighted past due amount in base currency | ||
WT_OPEN_PAST_DUE_AMT_PRIM_G | NUMBER | Total weighted past due amount in primary currency | ||
WT_OPEN_PAST_DUE_AMT_SEC_G | NUMBER | Total weighted past due amount in secondary currency |
Cut, paste (and edit) the following text to query this object:
SELECT MARKER
, ROW_ID
, PS_ROW_ID
, ORG_ID
, SUPPLIER_ID
, TIME_ID
, UNPAID_AMT_B
, PRIM_UNPAID_AMT
, SEC_UNPAID_AMT
, UNPAID_COUNT
, DUE_COUNT
, PAST_DUE_AMT_B
, PRIM_PAST_DUE_AMT
, SEC_PAST_DUE_AMT
, PAST_DUE_COUNT
, PAYMENT_AMT_B
, PRIM_PAYMENT_AMT
, SEC_PAYMENT_AMT
, DISCOUNT_OFFERED_B
, PRIM_DISCOUNT_OFFERED
, SEC_DISCOUNT_OFFERED
, DISCOUNT_REMAINING_B
, PRIM_DISCOUNT_REMAINING
, SEC_DISCOUNT_REMAINING
, DISCOUNT_TAKEN_B
, PRIM_DISCOUNT_TAKEN
, SEC_DISCOUNT_TAKEN
, DISCOUNT_LOST_B
, PRIM_DISCOUNT_LOST
, SEC_DISCOUNT_LOST
, DUE_BUCKET1_B
, PRIM_DUE_BUCKET1
, SEC_DUE_BUCKET1
, DUE_BUCKET1_COUNT
, DUE_BUCKET2_B
, PRIM_DUE_BUCKET2
, SEC_DUE_BUCKET2
, DUE_BUCKET2_COUNT
, DUE_BUCKET3_B
, PRIM_DUE_BUCKET3
, SEC_DUE_BUCKET3
, DUE_BUCKET3_COUNT
, PAST_DUE_BUCKET1_B
, PRIM_PAST_DUE_BUCKET1
, SEC_PAST_DUE_BUCKET1
, PAST_DUE_BUCKET1_COUNT
, PAST_DUE_BUCKET2_B
, PRIM_PAST_DUE_BUCKET2
, SEC_PAST_DUE_BUCKET2
, PAST_DUE_BUCKET2_COUNT
, PAST_DUE_BUCKET3_B
, PRIM_PAST_DUE_BUCKET3
, SEC_PAST_DUE_BUCKET3
, PAST_DUE_BUCKET3_COUNT
, ON_TIME_PAYMENT_AMT_B
, PRIM_ON_TIME_PAYMENT_AMT
, SEC_ON_TIME_PAYMENT_AMT
, LATE_PAYMENT_AMT_B
, PRIM_LATE_PAYMENT_AMT
, SEC_LATE_PAYMENT_AMT
, WT_OPEN_DUE_AMT_B
, WT_OPEN_DUE_AMT_PRIM_G
, WT_OPEN_DUE_AMT_SEC_G
, WT_OPEN_PAST_DUE_AMT_B
, WT_OPEN_PAST_DUE_AMT_PRIM_G
, WT_OPEN_PAST_DUE_AMT_SEC_G
FROM APPS.FII_AP_LIA_B_MV;
APPS.FII_AP_LIA_B_MV does not reference any database object
APPS.FII_AP_LIA_B_MV is referenced by following:
|
|
|