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: ZX.ZX_REGISTRATIONS

Object Details

Object Name:	ZX_REGISTRATIONS
Object Type:	TABLE
Owner:	ZX
FND Design Data:	ZX.ZX_REGISTRATIONS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_REGISTRATIONS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	REGISTRATION_ID
ZX_REGISTRATIONS_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_TAX_PROFILE_ID TAX_REGIME_CODE TAX TAX_JURISDICTION_CODE EFFECTIVE_FROM
ZX_REGISTRATIONS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REGISTRATION_NUMBER TAX_REGIME_CODE TAX TAX_JURISDICTION_CODE PARTY_TAX_PROFILE_ID

Columns

Name	Datatype	Length	Mandatory	Comments
REGISTRATION_TYPE_CODE	VARCHAR2	(30)		Lookup code for registration type
REGISTRATION_NUMBER	VARCHAR2	(50)		Tax registration number
VALIDATION_RULE	VARCHAR2	(30)		Not currently used
ROUNDING_RULE_CODE	VARCHAR2	(30)		Rounding rule code
TAX_JURISDICTION_CODE	VARCHAR2	(30)		Tax jurisdiction code
SELF_ASSESS_FLAG	VARCHAR2	(1)		Y or N indicates whether the tax of this registration is to be self-assessed
REGISTRATION_STATUS_CODE	VARCHAR2	(30)		Lookup code for party registration status
REGISTRATION_SOURCE_CODE	VARCHAR2	(30)		This column will be used to distinguish between formal registration numbers from logical tax registrations, which will not have a formal number assigned to it but will indicate that the party has a logical registration such as Nexus.
REGISTRATION_REASON_CODE	VARCHAR2	(30)		This column will explain the reason for the registration such as "minimum presence" or "revenue threshold".
TAX	VARCHAR2	(30)		Tax
TAX_REGIME_CODE	VARCHAR2	(30)		Tax regime code
INCLUSIVE_TAX_FLAG	VARCHAR2	(1)		Y or N indicates whether the tax of this registration is inclusive
HAS_TAX_EXEMPTIONS_FLAG	VARCHAR2	(1)		Y or N indicates whether theparty of this tax registration has tax exemptions
EFFECTIVE_FROM	DATE			Effective from date
EFFECTIVE_TO	DATE			Effective to date
REP_PARTY_TAX_NAME	VARCHAR2	(80)		Name of the party that is recognized by the tax authority for this tax registration
DEFAULT_REGISTRATION_FLAG	VARCHAR2	(1)		Y or N indicates whether this is the default registration for the party
BANK_ACCOUNT_NUM	VARCHAR2	(30)		Bank account number
LEGAL_LOCATION_ID	NUMBER	(15)		Location identifier for the legal registration address
RECORD_TYPE_CODE	VARCHAR2	(30)		Lookup code to indicate whether the record is migrated, seeded or defined by the user
CREATED_BY	NUMBER	(15)	Yes	Standard Who column
CREATION_DATE	DATE		Yes	Standard Who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who column
LAST_UPDATE_DATE	DATE		Yes	Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
REQUEST_ID	NUMBER			Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID	NUMBER			Application identifier of last concurrent program to update this record
PROGRAM_ID	NUMBER			Program identifier of last concurrent program to update this record
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment column
ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Descriptive flexfield structure defining column
TAX_CLASSIFICATION_CODE	VARCHAR2	(30)		Default tax classification code for this tax registration
PROGRAM_LOGIN_ID	NUMBER			Login user identifier of last concurrent program to update this record
REGISTRATION_ID	NUMBER	(15)	Yes	Unique identifier
TAX_AUTHORITY_ID	NUMBER	(15)		Party tax profile identifier for the tax authority of this registration
REP_TAX_AUTHORITY_ID	NUMBER	(15)		Party tax profile identifier for the reporting tax authority
COLL_TAX_AUTHORITY_ID	NUMBER	(15)		Party tax profile identifier for the collecting tax authority
PARTY_TAX_PROFILE_ID	NUMBER	(15)	Yes	Party tax profile identifier of the party with this tax registration
LEGAL_REGISTRATION_ID	NUMBER	(15)		Identifier of the legal registration that is the source for the tax registration number for this tax registration
BANK_ID	NUMBER	(15)		Bank party identifier
BANK_BRANCH_ID	NUMBER	(15)		Bank branch identifier
ACCOUNT_ID	NUMBER	(15)		Supplier identifier or Customer account identifier
ACCOUNT_SITE_ID	NUMBER	(15)		Supplier site identifier or Customer account site identifier
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
ROUNDING_LEVEL_CODE	VARCHAR2	(30)		Rounding level code
ACCOUNT_TYPE_CODE	VARCHAR2	(30)		Lookup code to indicate whether the registration is for supplier or customer
MERGED_TO_REGISTRATION_ID	NUMBER	(15)		Identifier of the registration into which this tax registration is merged

Query Text

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


SELECT REGISTRATION_TYPE_CODE
,      REGISTRATION_NUMBER
,      VALIDATION_RULE
,      ROUNDING_RULE_CODE
,      TAX_JURISDICTION_CODE
,      SELF_ASSESS_FLAG
,      REGISTRATION_STATUS_CODE
,      REGISTRATION_SOURCE_CODE
,      REGISTRATION_REASON_CODE
,      TAX
,      TAX_REGIME_CODE
,      INCLUSIVE_TAX_FLAG
,      HAS_TAX_EXEMPTIONS_FLAG
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      REP_PARTY_TAX_NAME
,      DEFAULT_REGISTRATION_FLAG
,      BANK_ACCOUNT_NUM
,      LEGAL_LOCATION_ID
,      RECORD_TYPE_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      TAX_CLASSIFICATION_CODE
,      PROGRAM_LOGIN_ID
,      REGISTRATION_ID
,      TAX_AUTHORITY_ID
,      REP_TAX_AUTHORITY_ID
,      COLL_TAX_AUTHORITY_ID
,      PARTY_TAX_PROFILE_ID
,      LEGAL_REGISTRATION_ID
,      BANK_ID
,      BANK_BRANCH_ID
,      ACCOUNT_ID
,      ACCOUNT_SITE_ID
,      OBJECT_VERSION_NUMBER
,      ROUNDING_LEVEL_CODE
,      ACCOUNT_TYPE_CODE
,      MERGED_TO_REGISTRATION_ID
FROM ZX.ZX_REGISTRATIONS;

Dependencies

[top of page]

ZX.ZX_REGISTRATIONS does not reference any database object

ZX.ZX_REGISTRATIONS is referenced by following:

APPS: ZX_REGISTRATIONS