AP_1099_TAPE_DATA_ALL
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.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: SUMMARY
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| VENDOR_ID | NUMBER | Unique supplier identifier from the supplier tables. | |||
| REGION_CODE | NUMBER | 18 | 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 | |||
| MISC11 | NUMBER | Total payments to supplier for Fish purchased for resale | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| MISC13 | NUMBER | Total of MISC13 (Excess Golden Parachute) payments for supplier | |||
| 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 MISC15ANT (Section 409A non-taxable deferrals) payments for supplier | |||
| MISC15B | NUMBER | Total of MISC15b (Section 409A income) payments for supplier | |||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| NEC4 | NUMBER | Federal income tax withheld on payments reported under Form 1099-NEC | |||
| INT1 | NUMBER | Total of INT1 (Interest Income) payments for the supplier. | |||
| INT1A | NUMBER | Total of INT1A (Interest Income) payments for the Financial Institution. | |||
| INT3 | NUMBER | Total of INT3 (Interest on U.S. Savings Bonds and Treasury Obligations) payments for the supplier. | |||
| INT4 | NUMBER | Federal income tax withheld on payments reported under Form 1099-INT. | |||
| INT6 | NUMBER | Total of INT6 (Foreign Tax Paid) payments for the supplier | |||
| INT7 | NUMBER | Total of INT7 (Foreign Country or U.S. Territory) payments for the supplier | |||
| INT8 | NUMBER | Total of INT8 (Tax-Exempt Interest) payments for the the supplier. | |||
| GOV1 | NUMBER | Total of GOV1 (Unemployment compensation) payments for supplier | |||
| GOV4 | NUMBER | Total of GOV4 (Federal income tax withheld) payments for supplier. | |||
| GOV6 | NUMBER | Total of GOV6 (Taxable grants) payments for supplier | |||
| GOV6A | NUMBER | Total of GOV6A (Energy grants) payments for supplier | |||
| GOV7 | NUMBER | Total of GOV7 (Agriculture payments) payments for supplier | |||
| REQUEST_ID | NUMBER | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| BATCH_NUMBER | NUMBER | 5 | Batch number for generating CSV and XML format. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_1099_TAPE_DATA_ALL | poz_suppliers | VENDOR_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_1099_TAPE_DATA_N1 | Non Unique | Default | VENDOR_ID |