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_DISCOUNTS_SUMMARY

Object Details

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

This summary table holds AP Payment Discount information. It is used to support Procure to Pay portlets.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
TRADING_PARTNER_PK_KEY	NUMBER		Yes	Foreign key to the trading partner level of Trading Partner dimension
TRADING_PARTNER_NAME	VARCHAR2	(120)		Name of the trading partner
OPERATING_UNIT_PK_KEY	NUMBER		Yes	Foreign key to the operating unit level of Organization dimension
OPERATING_UNIT_NAME	VARCHAR2	(150)		Name of the operating unt
RECORD_ID	VARCHAR2	(300)		Unique identifier of this record
RECORD_TYPE	VARCHAR2	(1)		Field to distinguish if this is an invoice payment record or scheduled payment record
INVOICE_NUM	VARCHAR2	(50)		Invoice number of the invoice this scheduled payment is for
INVOICE_DATE	DATE			Invoice date of the invoice this scheduled payment is for
INVOICE_UNIQUE_IDENTIFIER	NUMBER			Unique identifier for the invoice this payment information is for
INVOICE_AMOUNT	NUMBER			Invoice amount in functional currency for the invoice this payment information is for
DISCOUNT_AVAILABLE	NUMBER			Discount available in functional currency for this scheduled payment
DISCOUNT_LOST	NUMBER			Discount lost in functional currency for this invoice payment
DISCOUNT_DATE	DATE			Next upcoming discount date

Query Text

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


SELECT TRADING_PARTNER_PK_KEY
,      TRADING_PARTNER_NAME
,      OPERATING_UNIT_PK_KEY
,      OPERATING_UNIT_NAME
,      RECORD_ID
,      RECORD_TYPE
,      INVOICE_NUM
,      INVOICE_DATE
,      INVOICE_UNIQUE_IDENTIFIER
,      INVOICE_AMOUNT
,      DISCOUNT_AVAILABLE
,      DISCOUNT_LOST
,      DISCOUNT_DATE
FROM FII.FII_AP_DISCOUNTS_SUMMARY;

Dependencies

[top of page]

FII.FII_AP_DISCOUNTS_SUMMARY does not reference any database object

FII.FII_AP_DISCOUNTS_SUMMARY is referenced by following:

APPS: FII_AP_DISCOUNTS_SUMMARY