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_REPORTING_ENTITIES_ALL

Object Details

Object Name:	AP_REPORTING_ENTITIES_ALL
Object Type:	TABLE
Owner:	AP
FND Design Data:	SQLAP.AP_REPORTING_ENTITIES_ALL
Subobject Name:
Status:	VALID

AP_REPORTING_ENTITIES_ALL contains information about the reporting
entities you define for 1099 reporting. You must define at
least one reporting entity for your company or agency;
however, you can define as many reporting entities as you require
to satisfy your multi-organization reporting needs. Each tax
reporting entity you define must have a unique Tax Identification
Number. When you submit your 1099 reports, you submit the reports
once for each tax reporting entity you define.
This table corresponds to the Reporting Entity window.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AP_REPORTING_ENTITIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENTITY_NAME ORG_ID
AP_REPORTING_ENTITIES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	TAX_IDENTIFICATION_NUM ORG_ID
AP_REPORTING_ENTITIES_U3	NORMAL	UNIQUE	APPS_TS_TX_IDX	TAX_ENTITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TAX_ENTITY_ID	NUMBER	(15)	Yes	Unique internal Identifier for the Reporting entity record. Generated using a database sequence.
TAX_IDENTIFICATION_NUM	VARCHAR2	(20)	Yes	Tax identification number for reporting entity
ENTITY_NAME	VARCHAR2	(20)	Yes	Name of reporting entity
LOCATION_ID	NUMBER	(15)	Yes	Unique identifier of Location for reporting entity. Foreign key to the LOCATION_ID of the HR_LOCATIONS_ALL table.
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 - unique internal identifier user who last updated this row. Foreign key to the USER_ID column of the FND_USER table.
LAST_UPDATE_LOGIN	NUMBER	(15)	Yes	Standard who column - operating system login of user who last updated this row. Foreign key to the LOGIN_ID column of the FND_LOGINS table.
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Yes	Standard who column - unique internal identifier of user who created this row. Foreign key to the USER_ID column of the FND_USER table.
PRIMARY_ENTITY_FLAG	VARCHAR2	(1)		Indicates primary reporting entity
ORG_ID	NUMBER	(15)		Unique internal identifier of the Operating Unit.
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Global Descriptive Flexfield structure defining column
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Global Descriptive Flexfield segment
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Global Descriptive Flexfield segment
UNIQUE_TAX_REFERENCE_NUM	NUMBER	(15)		Unique Tax Reference Number of the Reporting entity. Used for Construction Industry Scheme (CIS), this is a UK withholding tax scheme applied to contractors and subcontracotrs.
ACCOUNTS_OFFICE_REFERENCE	VARCHAR2	(30)		Account office reference. Used for Construction Industry Scheme (CIS), this is a UK withholding tax scheme applied to contractors and subcontracotrs.
TAX_OFFICE_NUMBER	NUMBER	(15)		Tax offfice number. Used for Construction Industry Scheme (CIS), this is a UK withholding tax scheme applied to contractors and subcontracotrs.
PAYE_REFERENCE	VARCHAR2	(30)		PAYE (Pay As You Earn) reference of the Reporting Entity. Used for Construction Industry Scheme (CIS), this is a UK withholding tax scheme applied to contractors and subcontracotrs.
CIS_SENDER_ID	VARCHAR2	(30)		CIS Sender id to be used in the XML submissions. Used for Construction Industry Scheme (CIS), this is a UK withholding tax scheme applied to contractors and subcontracotrs.

Query Text

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


SELECT TAX_ENTITY_ID
,      TAX_IDENTIFICATION_NUM
,      ENTITY_NAME
,      LOCATION_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PRIMARY_ENTITY_FLAG
,      ORG_ID
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      UNIQUE_TAX_REFERENCE_NUM
,      ACCOUNTS_OFFICE_REFERENCE
,      TAX_OFFICE_NUMBER
,      PAYE_REFERENCE
,      CIS_SENDER_ID
FROM AP.AP_REPORTING_ENTITIES_ALL;

Dependencies

[top of page]

AP.AP_REPORTING_ENTITIES_ALL does not reference any database object

AP.AP_REPORTING_ENTITIES_ALL is referenced by following:

APPS: AP_REPORTING_ENTITIES; AP_REPORTING_ENTITIES_ALL