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

TABLE: AP.AP_1096_DATA_ALL

Object Details
Object Name: AP_1096_DATA_ALL
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_1096_DATA_ALL
Subobject Name:
Status: VALID


AP_1096_DATA_ALL contains summary payment information for
1099 type suppliers. The Internal Revenue Service
requires that you report this summary information for
any qualifying payments to 1099 suppliers. Your Oracle Payables
application updates this table when you submit the 1099 Forms
Report. Your Oracle Payables application uses the
summary payment information for the 1096 Report.
.
This table contains one record per tax entity ID. It has no
primary key.


Storage Details
Tablespace: TablespaceAPPS_TS_SUMMARY
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
NUMBER_OF_DOCUMENTS NUMBER

Number of documents created in last 1099 run
TOTAL_WITHHELD NUMBER

Not currently used
TOTAL_REPORTED NUMBER

Total amount reported on last 1099 run
TAX_ENTITY_ID NUMBER
Yes Identifier for tax reporting entity on last 1099 run
ORG_ID NUMBER (15)
Organization identifier
Query Text

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


SELECT LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      NUMBER_OF_DOCUMENTS
,      TOTAL_WITHHELD
,      TOTAL_REPORTED
,      TAX_ENTITY_ID
,      ORG_ID
FROM AP.AP_1096_DATA_ALL;

Dependencies

[top of page]

AP.AP_1096_DATA_ALL does not reference any database object

AP.AP_1096_DATA_ALL is referenced by following:

SchemaAPPS
SynonymAP_1096_DATA
SynonymAP_1096_DATA_ALL