DBA Data[Home] [Help] [Dependency Information]


TABLE: AP.AP_INCOME_TAX_REGIONS

Object Details
Object Name: AP_INCOME_TAX_REGIONS
Object Type: TABLE
Owner: AP
FND Design Data: TableSQLAP.AP_INCOME_TAX_REGIONS
Subobject Name:
Status: VALID


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.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
AP_INCOME_TAX_REGIONS_U1 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnREGION_SHORT_NAME
AP_INCOME_TAX_REGIONS_U2 NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnREGION_CODE
Columns
Name Datatype Length Mandatory Comments
REGION_SHORT_NAME VARCHAR2 (10) Yes Abbreviated income tax region name (identifies income tax region for 1099 supplier sites)
REGION_LONG_NAME VARCHAR2 (25)
Name of income tax region
REGION_CODE NUMBER (15)
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
ACTIVE_DATE DATE

Date income tax region active
INACTIVE_DATE DATE

Date income tax region inactive
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER (15) Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
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_TOTAL13E NUMBER

No longer used.
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
Query Text

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


SELECT REGION_SHORT_NAME
,      REGION_LONG_NAME
,      REGION_CODE
,      REPORTING_LIMIT
,      NUM_OF_PAYEES
,      CONTROL_TOTAL1
,      CONTROL_TOTAL2
,      CONTROL_TOTAL3
,      CONTROL_TOTAL4
,      CONTROL_TOTAL5
,      CONTROL_TOTAL6
,      CONTROL_TOTAL7
,      CONTROL_TOTAL8
,      CONTROL_TOTAL9
,      CONTROL_TOTAL10
,      ACTIVE_DATE
,      INACTIVE_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      REPORTING_LIMIT_METHOD_CODE
,      CONTROL_TOTAL13
,      CONTROL_TOTAL13E
,      CONTROL_TOTAL14
,      CONTROL_TOTAL15A
,      CONTROL_TOTAL15B
FROM AP.AP_INCOME_TAX_REGIONS;

Dependencies

[top of page]

AP.AP_INCOME_TAX_REGIONS does not reference any database object

AP.AP_INCOME_TAX_REGIONS is referenced by following:

SchemaAPPS
SynonymAP_INCOME_TAX_REGIONS