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


TABLE: FII.FII_AP_TRANS_BACKLOG_SUMMARY

Object Details
Object Name: FII_AP_TRANS_BACKLOG_SUMMARY
Object Type: TABLE
Owner: FII
FND Design Data: TableFII.FII_AP_TRANS_BACKLOG_SUMMARY
Subobject Name:
Status: VALID


This summary table holds Open Payments information. It is used to support Procure to Pay portlets.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
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
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
SCH_PAYMENT_ID NUMBER

Unique identifier for this scheduled payment
OPEN_PAYMENT_AMOUNT NUMBER

Payment amount in functional currency for this scheduled payment
INVOICE_PK_KEY NUMBER

Foreign key to the scheduled payment invoice of the Scheduled Payment fact
INVOICE_NUM VARCHAR2 (50)
Invoice number of the invoice this scheduled payment is for
INVOICE_AMOUNT NUMBER

Invoice amount of the invoice this scheduled payment is for
PAYMENT_DUE_DATE DATE

Due date of this scheduled payment
INVOICE_DATE DATE

Invoice date of the invoice this scheduled payment is for
DAYS_OUTSTANDING NUMBER

Number of days this scheduled payment is over dued
Query Text

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


SELECT OPERATING_UNIT_PK_KEY
,      OPERATING_UNIT_NAME
,      TRADING_PARTNER_PK_KEY
,      TRADING_PARTNER_NAME
,      SCH_PAYMENT_ID
,      OPEN_PAYMENT_AMOUNT
,      INVOICE_PK_KEY
,      INVOICE_NUM
,      INVOICE_AMOUNT
,      PAYMENT_DUE_DATE
,      INVOICE_DATE
,      DAYS_OUTSTANDING
FROM FII.FII_AP_TRANS_BACKLOG_SUMMARY;

Dependencies

[top of page]

FII.FII_AP_TRANS_BACKLOG_SUMMARY does not reference any database object

FII.FII_AP_TRANS_BACKLOG_SUMMARY is referenced by following:

SchemaAPPS
SynonymFII_AP_TRANS_BACKLOG_SUMMARY