eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	SQLAP.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:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_INCOME_TAX_REGIONS_U1	NORMAL	UNIQUE	APPS_TS_SEED	REGION_SHORT_NAME
AP_INCOME_TAX_REGIONS_U2	NORMAL	UNIQUE	APPS_TS_SEED	REGION_CODE REGION_SHORT_NAME

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:

AP: AP_INCOME_TAX_REGIONS#