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: AP.AP_1099_TAPE_DATA_ALL

Object Details

Object Name:	AP_1099_TAPE_DATA_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_1099_TAPE_DATA_ALL
Subobject Name:
Status:	VALID

AP_1099_TAPE_DATA_ALL is a temporary table that holds 1099 supplier
payment totals used for creating K records during the 1099 Electronic Media
process. The APXTRCMT report creates a row in the
table for each unique region code for a supplier after the report
calculates the total 1099 payments (MISC1, MISC2, etc.) for
the supplier's region codes.
.
The report then determines if the totals for a region code for
a supplier exceed the reporting limit for the region. If the
totals do not exceed the limit, the report updates the region code
to null for the vendor ID in this table and sums the 1099 totals for rows
with remaining region codes to produce the summary K records for
each region.

Storage Details

Tablespace:	APPS_TS_NOLOGGING
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_1099_TAPE_DATA_N1	NORMAL	NONUNIQUE	APPS_TS_NOLOGGING	VENDOR_ID

Columns

Name	Datatype	Length	Comments
VENDOR_ID	NUMBER		Supplier identifier
REGION_CODE	NUMBER	(15)	Code used for reporting 1099 payments to income tax regions
MISC1	NUMBER		Total of MISC1 payments (rent) for supplier
MISC2	NUMBER		Total of MISC2 (Royalties) payments for supplier
MISC3	NUMBER		Total of MISC3 (Prizes and awards) payments for supplier
MISC4	NUMBER		Total of MISC4 (Federal income tax withheld) payments for supplier (Not used in this release)
MISC5	NUMBER		Total of MISC5 (Fishing boat proceeds) payments for supplier
MISC6	NUMBER		Total of MISC6 (Medical and health care payments) payments for supplier
MISC7	NUMBER		Total of MISC7 (Non-employee compensation) payments for supplier
MISC8	NUMBER		Total of MISC8 (Payments in lieu of dividend or interest) payments for supplier
MISC9	NUMBER		Total of MISC9 (Excess Golden Parachute) payments for supplier
MISC10	NUMBER		Total of MISC10 (Crop insurance proceeds) payments for supplier
ORG_ID	NUMBER	(15)	Organization identifier
MISC13	NUMBER		Total of MISC13 (Excess Golden Parachute) payments for supplier
MISC13E	NUMBER		No longer used.
MISC14	NUMBER		Total of MISC14 (Gross attorney proceeds) payments for supplier
MISC15AT	NUMBER		Total of MISC15a T (Section 409A taxable deferrals) payments for supplier
MISC15ANT	NUMBER		Total of MISC15a NT (Section 409A non-taxable deferrals) payments for supplier
MISC15B	NUMBER		Total of MISC15b (Section 409A income) payments for supplier

Query Text

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


SELECT VENDOR_ID
,      REGION_CODE
,      MISC1
,      MISC2
,      MISC3
,      MISC4
,      MISC5
,      MISC6
,      MISC7
,      MISC8
,      MISC9
,      MISC10
,      ORG_ID
,      MISC13
,      MISC13E
,      MISC14
,      MISC15AT
,      MISC15ANT
,      MISC15B
FROM AP.AP_1099_TAPE_DATA_ALL;

Dependencies

[top of page]

AP.AP_1099_TAPE_DATA_ALL does not reference any database object

AP.AP_1099_TAPE_DATA_ALL is referenced by following:

APPS: AP_1099_TAPE_DATA; AP_1099_TAPE_DATA_ALL