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: TableSQLAP.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: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_1099_TAPE_DATA_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnVENDOR_ID
Columns
Name Datatype Length Mandatory 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:

SchemaAP
ViewAP_1099_TAPE_DATA_ALL#