eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FII.FII_AP_INVOICE_B

Object Details

Object Name:	FII_AP_INVOICE_B
Object Type:	TABLE
Owner:	FII
FND Design Data:	FII.FII_AP_INVOICE_B
Subobject Name:
Status:	VALID

Base Summary Table for Payables Invoices. It is used to support Payables portlets.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
FII_AP_INVOICE_B_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	INVOICE_ID
FII_AP_INVOICE_B_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_ID SUPPLIER_ID INVOICE_TYPE ENTERED_DATE
FII_AP_INVOICE_B_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_ID SUPPLIER_ID SOURCE ENTERED_DATE
FII_AP_INVOICE_B_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORG_ID SUPPLIER_ID ENTERED_DATE FULLY_PAID_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)		Organization identifier
SUPPLIER_ID	NUMBER	(15)		Supplier identifier
INVOICE_ID	NUMBER	(15)		Invoice identifier
INVOICE_TYPE	VARCHAR2	(25)		Type of invoice
INVOICE_NUMBER	VARCHAR2	(50)		Invoice number
INVOICE_DATE	DATE			Invoice date
INVOICE_AMOUNT	NUMBER			Invoice amount
BASE_AMOUNT	NUMBER			Invoice amount in functional currency
PRIM_AMOUNT	NUMBER			Invoice amount in primary global currency
SEC_AMOUNT	NUMBER			Invoice amount in sec global currency
INVOICE_CURRENCY_CODE	VARCHAR2	(25)		Currency code of invoice
BASE_CURRENCY_CODE	VARCHAR2	(25)		Currency code of the operating unit
ENTERED_DATE	DATE			Creation date of invoice
PAYMENT_CURRENCY_CODE	VARCHAR2	(25)		Currency code of payment
FULLY_PAID_DATE	DATE			Date invoice is paid fully
TERMS_ID	NUMBER	(15)		Payment terms identifier
SOURCE	VARCHAR2	(25)		Source of invoice
E_INVOICES_FLAG	VARCHAR2	(1)		Flag indicating that the invoice is received electronically
CANCEL_FLAG	VARCHAR2	(1)		Flag indicating that the invoice is cancelled
CANCEL_DATE	DATE			Date invoice is cancelled
DIST_COUNT	NUMBER	(15)		Count of invoice distributions
DUE_DATE	DATE			Maximum due date of invoice
DISCOUNT_OFFERED	NUMBER			Maximum discount offered on invoice
DISCOUNT_OFFERED_B	NUMBER			Maximum discount offered on invoice in functional currency
PRIM_DISCOUNT_OFFERED	NUMBER			Maximum discount offered on invoice in primary global currency
SEC_DISCOUNT_OFFERED	NUMBER			Maximum discount offered on invoice in sec global currency
FIRST_HOLD_DATE	DATE			Date the invoice is first placed on hold
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).
EXCHANGE_DATE	DATE			Date exchange rate is effective
EXCHANGE_RATE	NUMBER			Exchange rate for foreign currency invoice
EXCHANGE_RATE_TYPE	VARCHAR2	(30)		Exchange rate type for foreign currency invoice
PAYMENT_STATUS_FLAG	VARCHAR2	(1)		Flag that indicates if invoice has been paid (Y, N, or P)
PAYMENT_CROSS_RATE	NUMBER			Payment cross rate
FULLY_PAID_AMOUNT	NUMBER			Total of prepayments and invoice payments
FULLY_PAID_AMOUNT_B	NUMBER			Total of prepayments and invoice payments in functional currency
PRIM_FULLY_PAID_AMOUNT	NUMBER			Total of prepayments and invoice payments in primary global currency
SEC_FULLY_PAID_AMOUNT	NUMBER			Total of prepayments and invoice payments in secondary global currency

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ORG_ID
,      SUPPLIER_ID
,      INVOICE_ID
,      INVOICE_TYPE
,      INVOICE_NUMBER
,      INVOICE_DATE
,      INVOICE_AMOUNT
,      BASE_AMOUNT
,      PRIM_AMOUNT
,      SEC_AMOUNT
,      INVOICE_CURRENCY_CODE
,      BASE_CURRENCY_CODE
,      ENTERED_DATE
,      PAYMENT_CURRENCY_CODE
,      FULLY_PAID_DATE
,      TERMS_ID
,      SOURCE
,      E_INVOICES_FLAG
,      CANCEL_FLAG
,      CANCEL_DATE
,      DIST_COUNT
,      DUE_DATE
,      DISCOUNT_OFFERED
,      DISCOUNT_OFFERED_B
,      PRIM_DISCOUNT_OFFERED
,      SEC_DISCOUNT_OFFERED
,      FIRST_HOLD_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      EXCHANGE_DATE
,      EXCHANGE_RATE
,      EXCHANGE_RATE_TYPE
,      PAYMENT_STATUS_FLAG
,      PAYMENT_CROSS_RATE
,      FULLY_PAID_AMOUNT
,      FULLY_PAID_AMOUNT_B
,      PRIM_FULLY_PAID_AMOUNT
,      SEC_FULLY_PAID_AMOUNT
FROM FII.FII_AP_INVOICE_B;

Dependencies

[top of page]

FII.FII_AP_INVOICE_B does not reference any database object

FII.FII_AP_INVOICE_B is referenced by following:

APPS: FII_AP_HATY_XB_MV; FII_AP_INVOICE_B; FII_AP_INV_B_MV; FII_AP_INV_PAYMENTS_MV; FII_AP_IVATY_B_MV; FII_AP_LIA_B_MV; FII_AP_PAID_XB_MV; FII_AP_PMT_SCHEDULES_MV; ISC_TRN_003_MV; ISC_TRN_004_MV