[Home] [Help]
[Dependency Information]
Object Name: | FII_AP_TRANS_BACKLOG_SUMMARY |
---|---|
Object Type: | TABLE |
Owner: | FII |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
This summary table holds Open Payments information. It is used to support Procure to Pay portlets.
Tablespace: | ![]() |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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;
FII.FII_AP_TRANS_BACKLOG_SUMMARY does not reference any database object
FII.FII_AP_TRANS_BACKLOG_SUMMARY is referenced by following:
|
|
|