[Home] [Help] [Dependency Information]
Object Name: | FV_INV_SELECTED_DUEDATE_TEMP |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_INV_SELECTED_DUEDATE_TEMP |
Subobject Name: | |
Status: | VALID |
FV_INV_SELECTED_DUEDATE_TEMP is a temporary table that stores information about invoices selected for due date payments.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FV_INV_SELECTED_DUEDATE_TEMP_U | NORMAL | UNIQUE | APPS_TS_INTERFACE | INVOICE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
INVOICE_NUM | VARCHAR2 | (50) | Invoice number | |
TERMS_DATE | DATE | Date used with payment terms to calculate payment schedule of invoice | ||
ORG_DUE_DATE | DATE | Original due date | ||
NEW_DUE_DATE | DATE | Calculated due date | ||
VENDOR_ID | NUMBER | Vendor identifier | ||
SET_OF_BKS_NAME | VARCHAR2 | (30) | Set of Books name | |
ORG_DISCOUNT_DATE | DATE | Original discount date based on terms date | ||
NEW_DISCOUNT_DATE | DATE | Updated discount date based on Due Date Calculation process | ||
ORG_SECOND_DISC_DATE | DATE | Second discount date based on invoice date | ||
NEW_SECOND_DISC_DATE | DATE | Updated second discount date based on Due Date Calculation process | ||
ORG_THIRD_DISC_DATE | DATE | Third discount date based on invoice date | ||
NEW_THIRD_DISC_DATE | DATE | Updated third discount date based on Due Date Calculation process |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, SET_OF_BOOKS_ID
, INVOICE_NUM
, TERMS_DATE
, ORG_DUE_DATE
, NEW_DUE_DATE
, VENDOR_ID
, SET_OF_BKS_NAME
, ORG_DISCOUNT_DATE
, NEW_DISCOUNT_DATE
, ORG_SECOND_DISC_DATE
, NEW_SECOND_DISC_DATE
, ORG_THIRD_DISC_DATE
, NEW_THIRD_DISC_DATE
FROM FV.FV_INV_SELECTED_DUEDATE_TEMP;
FV.FV_INV_SELECTED_DUEDATE_TEMP does not reference any database object
FV.FV_INV_SELECTED_DUEDATE_TEMP is referenced by following:
|
|
|