[Home] [Help] [Dependency Information]
Object Name: | FV_INVOICE_RETURN_DATES_ALL |
---|---|
Object Type: | TABLE |
Owner: | FV |
FND Design Data: | FV.FV_INVOICE_RETURN_DATES_ALL |
Subobject Name: | |
Status: | VALID |
FV_INVOICE_RETURN_DATES_ALL contains invoice information used as part of due date calculation.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FV_INVOICE_RETURN_DATES_ALL_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | RETURN_DATE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INVOICE_ID | NUMBER | (15) | Yes | Invoice identifier |
RETURN_DATE_ID | NUMBER | (15) | Yes | Return date unique identifier |
ORIGINAL_INVOICE_DATE | DATE | Yes | Original invoice date | |
ORIGINAL_INVOICE_RECEIVED_DATE | DATE | Yes | Original date invoice received | |
INVOICE_RETURNED_DATE | DATE | Yes | Date invoice returned | |
SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Set of Books identifier |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
ORG_ID | NUMBER | (15) | Yes | Organization identifier |
COMMENTS | VARCHAR2 | (240) | Comments | |
REASON_CODE | VARCHAR2 | (80) | Reason for Invoice returned |
Cut, paste (and edit) the following text to query this object:
SELECT INVOICE_ID
, RETURN_DATE_ID
, ORIGINAL_INVOICE_DATE
, ORIGINAL_INVOICE_RECEIVED_DATE
, INVOICE_RETURNED_DATE
, SET_OF_BOOKS_ID
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, CREATED_BY
, CREATION_DATE
, ORG_ID
, COMMENTS
, REASON_CODE
FROM FV.FV_INVOICE_RETURN_DATES_ALL;
FV.FV_INVOICE_RETURN_DATES_ALL does not reference any database object
FV.FV_INVOICE_RETURN_DATES_ALL is referenced by following:
|
|
|