AP_INCOME_TAX_REGIONS
AP_INCOME_TAX_REGIONS contains information about the tax regions you use to record payment information for 1099 suppliers when your organization participates in the Combined Filing Program. Each tax region participating in the Combined Filing Program is assigned a region code, reporting limit, and a reporting limit method which is used to determine if the payments to a 1099 supplier exceed the region's reporting limit. . When you enter a site for a 1099 supplier, you enter a tax region from this table in the site address. Your Oracle Payables application assigns either this tax region or a default tax region you define at the system level to each invoice distribution line for the supplier site. . Your Oracle Payables application predefines the tax regions for all U.S. States, the District of Columbia, and some U.S. Territories. Payables has also predefined the region codes for those tax regions that are participating in the Internal Revenue Service's Combined Filing Program. You can define additional tax regions or you can enter region codes for existing regions. . This table corresponds to the Income Tax Regions window.
Details
-
Schema: FUSION
-
Object owner: AP
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
AP_INCOME_TAX_REGIONS_PK |
REGION_SHORT_NAME |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| REGION_SHORT_NAME | VARCHAR2 | 10 | Yes | Abbreviated income tax region name (identifies income tax region for 1099 supplier sites) | |
| REGION_LONG_NAME | VARCHAR2 | 240 | Full name of income tax region applicable for 1099 taxes. | ||
| REGION_CODE | NUMBER | 18 | Region code for income tax regions participating in the Combined Filing Program (CFP) | ||
| REPORTING_LIMIT | NUMBER | Minimum reporting amount for income tax region participating in the CFP | |||
| NUM_OF_PAYEES | NUMBER | Number of suppliers with 1099 payments for a tax region | |||
| CONTROL_TOTAL1 | NUMBER | Total of MISC1 payments for tax region | |||
| CONTROL_TOTAL2 | NUMBER | Total of MISC2 payments for tax region | |||
| CONTROL_TOTAL3 | NUMBER | Total of MISC3 payments for tax region | |||
| CONTROL_TOTAL4 | NUMBER | Total of MISC4 payments for tax region | |||
| CONTROL_TOTAL5 | NUMBER | Total of MISC5 payments for tax region | |||
| CONTROL_TOTAL6 | NUMBER | Total of MISC6 payments for tax region | |||
| CONTROL_TOTAL7 | NUMBER | Total of MISC7 payments for tax region | |||
| CONTROL_TOTAL8 | NUMBER | Total of MISC8 payments for tax region | |||
| CONTROL_TOTAL9 | NUMBER | Total of MISC9 payments for tax region | |||
| CONTROL_TOTAL10 | NUMBER | Total of MISC10 payments for tax region | |||
| CONTROL_TOTAL11 | NUMBER | Total of MISC11 payments for tax region | |||
| ACTIVE_DATE | DATE | Date from when the income tax region is active. | |||
| INACTIVE_DATE | DATE | Date income tax region inactive | |||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| REPORTING_LIMIT_METHOD_CODE | VARCHAR2 | 25 | Yes | Method for calculating reporting limit for region | |
| CONTROL_TOTAL13 | NUMBER | Total of MISC13 payments for tax region | |||
| CONTROL_TOTAL14 | NUMBER | Total of MISC14 payments for tax region | |||
| CONTROL_TOTAL15A | NUMBER | Total of MISC15a payments for tax region | |||
| CONTROL_TOTAL15B | NUMBER | Total of MISC15b payments for tax region | |||
| 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. | |
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| ap_invoice_lines_interface | ap_income_tax_regions | INCOME_TAX_REGION |
| ap_invoice_distributions_all | ap_income_tax_regions | INCOME_TAX_REGION |
| ap_system_parameters_all | ap_income_tax_regions | INCOME_TAX_REGION |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| AP_INCOME_TAX_REGIONS_N1 | Non Unique | FUSION_TS_SEED | UPPER("REGION_SHORT_NAME") |
| AP_INCOME_TAX_REGIONS_U1 | Unique | Default | REGION_SHORT_NAME, ORA_SEED_SET1 |
| AP_INCOME_TAX_REGIONS_U11 | Unique | Default | REGION_SHORT_NAME, ORA_SEED_SET2 |
| AP_INCOME_TAX_REGIONS_U2 | Unique | FUSION_TS_SEED | REGION_CODE, NVL2((TO_CHAR("REGION_CODE")),(TO_CHAR("REGION_CODE")),"REGION_SHORT_NAME"), ORA_SEED_SET1 |
| AP_INCOME_TAX_REGIONS_U21 | Unique | FUSION_TS_SEED | REGION_CODE, NVL2((TO_CHAR("REGION_CODE")),(TO_CHAR("REGION_CODE")),"REGION_SHORT_NAME"), ORA_SEED_SET2 |