[Home] [Help] [Dependency Information]
Object Name: | FV_PROMPT_PAY_TEMP |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_PROMPT_PAY_TEMP |
Subobject Name: | |
Status: | VALID |
FV_PROMPT_PAY_TEMP is used to store temporary reporting data during the execution of the Prompt Pay report.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Invoice identifier | |
PAY_INVOICE_ID | NUMBER | (15) | Payment invoice identifier | |
PAY_PAYMENT_NUMBER | NUMBER | (15) | Payment number | |
PAY_DUE_DATE | DATE | Due date | ||
DISCOUNT_AMOUNT_AVAILABLE | NUMBER | Discount amount available | ||
INVOICE_PAYMENT_ID | NUMBER | (15) | Invoice payment identifier | |
DISCOUNT_TAKEN | NUMBER | Discount amount | ||
CHECK_DATE | DATE | Check date | ||
INVOICE_AMOUNT | NUMBER | Invoice amount | ||
INVOICE_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | Invoice type lookup code |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, PAY_INVOICE_ID
, PAY_PAYMENT_NUMBER
, PAY_DUE_DATE
, DISCOUNT_AMOUNT_AVAILABLE
, INVOICE_PAYMENT_ID
, DISCOUNT_TAKEN
, CHECK_DATE
, INVOICE_AMOUNT
, INVOICE_TYPE_LOOKUP_CODE
FROM FV.FV_PROMPT_PAY_TEMP;
FV.FV_PROMPT_PAY_TEMP does not reference any database object
FV.FV_PROMPT_PAY_TEMP is referenced by following:
|
|
|