eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: FV.FV_1096_DATA_ALL

Object Details

Object Name:	FV_1096_DATA_ALL
Object Type:	TABLE
Owner:	FV
FND Design Data:	FV.FV_1096_DATA_ALL
Subobject Name:
Status:	VALID

This table stores temporary records required for the generation of the 1096 report. Records are deleted from this table each time the 1099-GOV or 1099-INT reports are run.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
NUMBER_OF_DOCUMENTS	NUMBER			Number of documents created in the last 1099-GOV or 1099-INT run
TOTAL_WITHHELD	NUMBER			Not currently used
TOTAL_REPORTED	NUMBER			Total amount reported on the last 1099-GOV or 1099-INT run
TAX_ENTITY_ID	NUMBER			Identifier for tax reporting entity on last 1099-GOV or 1099-INT run
ORG_ID	NUMBER	(15)	Yes	Organization identifier
REPORTING_TYPE	VARCHAR2	(30)		Indicates the type of 1099 reporting, 1099G or 1099 INT

Query Text

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


SELECT NUMBER_OF_DOCUMENTS
,      TOTAL_WITHHELD
,      TOTAL_REPORTED
,      TAX_ENTITY_ID
,      ORG_ID
,      REPORTING_TYPE
FROM FV.FV_1096_DATA_ALL;

Dependencies

[top of page]

FV.FV_1096_DATA_ALL does not reference any database object

FV.FV_1096_DATA_ALL is referenced by following:

APPS: FV_1096_DATA; FV_1096_DATA_ALL