AP_1099G_DATA_ALL
AP_1099G_DATA_ALL contains 1099 supplier payment totals made for Certain Government Payments. The 1099-G report calculates the total amounts of 1099 government payments (GOV1, GOV6, and so on) for the supplier's region codes. Then it creates a row in the table for each unique region code for a supplier. The report then determines whether the totals for a region code for a supplier exceed the reporting limit for the region. If the totals don't exceed the limit, the report updates the region code to null for the vendor ID column in this table, and sums the 1099 totals for rows with remaining region codes.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: SUMMARY
Primary Key
| Name | Columns |
|---|---|
|
AP_1099G_DATA_ALL_PK |
GOV_1099G_DATA_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| GOV_1099G_DATA_ID | NUMBER | Yes | Indicates the unique identifier associated to the row. | ||
| VENDOR_ID | NUMBER | Unique supplier identifier from the supplier tables. | |||
| REGION_CODE | NUMBER | Code used for reporting 1099 payments to income tax regions. | |||
| 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(Agricultural) payments for supplier. | |||
| ORG_ID | NUMBER | 18 | Yes | Indicates the identifier of the business unit associated to the row. | |
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| AP_1099G_DATA_ALL | POZ_SUPPLIERS_PK | VENDOR_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_1099G_DATA_ALL_N1 | Non Unique | Default | VENDOR_ID |
| AP_1099G_DATA_ALL_U1 | Unique | Default | GOV_1099G_DATA_ID |