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_INT

Object Details

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

Interface Table to store the Registration Records

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_REGISTRATIONS_INT_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INTF_PTP_REFERENCE

Columns

Name	Datatype	Length	Mandatory	Comments
BATCH_ID	NUMBER	(22)		Identifier to identify a set of records to be processed as a batch.
REQUEST_ID	NUMBER	(22)		Request identifier of last concurrent program to update this record
DML_TYPE	VARCHAR2	(10)	Yes	Indicates whether the record is for insert or for update.
INTF_PTP_REFERENCE	VARCHAR2	(40)	Yes	User Identifier to associate to the corresponding Party Tax Profile
RECORD_STATUS	NUMBER	(2)		Interface record status
PARTY_TAX_PROFILE_ID	NUMBER	(22)		Unique identifier
ERROR_NUMBER	NUMBER	(22)		This column is used to store the error number whenever an error is flashed
PROG_INT_RECORD_REF	NUMBER	(22)		Unique Identifier populated for the record in context of batch being processed by program internally for errored records.
PROG_INT_CHAR1	VARCHAR2	(30)		Place holder column to store temporary values
PROG_INT_NUM1	NUMBER	(22)		For program internal use only
REGISTRATION_ID	NUMBER	(22)		Unique identifier
REGISTRATION_TYPE_CODE	VARCHAR2	(30)		Lookup code for registration type. System uses this in tax registration number validation and reporting based on the type, where applicable.
REGISTRATION_TYPE_NAME	VARCHAR2	(80)		Lookup Name for registration type.
REGISTRATION_NUMBER	VARCHAR2	(50)		Column to store tax registration number. System validates the number according to tax authority validation rules, where applicable.
ROUNDING_RULE_CODE	VARCHAR2	(30)		Rounding rule code to be used for rounding taxes of this regime. Possible values are UP, DOWN and NEAREST. Rounding rule is the method to use to round off taxes to the minimum accountable unit.
ROUNDING_RULE_NAME	VARCHAR2	(80)		Rounding rule name to be used for rounding taxes of this regime. Possible values are Up, Down and Nearest. Rounding rule is the method to use to round off taxes to the minimum accountable unit.
TAX_JURISDICTION_CODE	VARCHAR2	(30)		Column to store tax jurisdiction code.
TAX_JURISDICTION_NAME	VARCHAR2	(240)		Column to store tax jurisdiction name.
REGISTRATION_STATUS_CODE	VARCHAR2	(30)		Lookup code for party registration status. System uses tax registration status as a determining factor in tax rules.
REGISTRATION_STATUS_NAME	VARCHAR2	(80)		Lookup Name for party registration status. System uses tax registration status as a determining factor in tax rules.
REGISTRATION_SOURCE_CODE	VARCHAR2	(30)		Column to store registration source code and used to distinguish between formal registration numbers from logical tax registrations. Logical tax registrations do not have a formal number assigned to it but indicate that the party is considered to meet one or more requirements for reports.
REGISTRATION_SOURCE_NAME	VARCHAR2	(80)		Column to store registration source name and used to distinguish between formal registration numbers from logical tax registrations. Logical tax registrations do not have a formal number assigned to it but indicate that the party is considered to meet one or more requirements for reports.
REGISTRATION_REASON_CODE	VARCHAR2	(30)		This column indicates the reason for the registration such as "minimum presence" or "revenue threshold".
REGISTRATION_REASON_NAME	VARCHAR2	(80)		This column indicates the reason for the registration such as "minimum presence" or "revenue threshold".
TAX_REGIME_CODE	VARCHAR2	(30)		Column to store tax regime code for this registration.
TAX_REGIME_NAME	VARCHAR2	(80)		Column to store tax regime name for this registration.
TAX_CODE	VARCHAR2	(30)		Column to store tax for this registration.
TAX_NAME	VARCHAR2	(80)		Column to store tax for this registration.
INCLUSIVE_TAX_FLAG	VARCHAR2	(1)		Y or N indicates whether the tax of this registration is inclusive.
EFFECTIVE_FROM	DATE		Yes	Effective from date
EFFECTIVE_TO	DATE			Effective to date
DEFAULT_REGISTRATION_FLAG	VARCHAR2	(1)		Y or N indicates whether this is the default registration for the party. The tax registration number associated with this registration is used as the default tax registration number on all tax reports.
LEGAL_LOCATION_ID	NUMBER	(22)		Location identifier for the legal registration address. To complete the LE flow for an establishment requires to have an address. There are some cases that the only registration for the Establishment will be the tax registration.
LEGAL_LOCATION_CODE	VARCHAR2	(60)		Location name for location identifier for the legal registration address
ADDRESS_LINE_1	VARCHAR2	(240)		1st line of location address for location identifier for the legal registration address
TOWN_OR_CITY	VARCHAR2	(30)		Town or city for location identifier for the legal registration address
REGION_1	VARCHAR2	(120)		County (US, UK); Province (CA) for location identifier for the legal registration address.
TAX_AUTHORITY_ID	NUMBER	(22)		Party tax profile identifier for the tax authority of this registration who is responsible for issuing tax registration numbers for this registration.
TAX_AUTHORITY_NAME	VARCHAR2	(360)		Name of tax authority as seen in hz_parties
LEGAL_REGISTRATION_ID	NUMBER	(22)		Identifier of the legal registration that is the source for the tax registration number for this tax registration

Query Text

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


SELECT BATCH_ID
,      REQUEST_ID
,      DML_TYPE
,      INTF_PTP_REFERENCE
,      RECORD_STATUS
,      PARTY_TAX_PROFILE_ID
,      ERROR_NUMBER
,      PROG_INT_RECORD_REF
,      PROG_INT_CHAR1
,      PROG_INT_NUM1
,      REGISTRATION_ID
,      REGISTRATION_TYPE_CODE
,      REGISTRATION_TYPE_NAME
,      REGISTRATION_NUMBER
,      ROUNDING_RULE_CODE
,      ROUNDING_RULE_NAME
,      TAX_JURISDICTION_CODE
,      TAX_JURISDICTION_NAME
,      REGISTRATION_STATUS_CODE
,      REGISTRATION_STATUS_NAME
,      REGISTRATION_SOURCE_CODE
,      REGISTRATION_SOURCE_NAME
,      REGISTRATION_REASON_CODE
,      REGISTRATION_REASON_NAME
,      TAX_REGIME_CODE
,      TAX_REGIME_NAME
,      TAX_CODE
,      TAX_NAME
,      INCLUSIVE_TAX_FLAG
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      DEFAULT_REGISTRATION_FLAG
,      LEGAL_LOCATION_ID
,      LEGAL_LOCATION_CODE
,      ADDRESS_LINE_1
,      TOWN_OR_CITY
,      REGION_1
,      TAX_AUTHORITY_ID
,      TAX_AUTHORITY_NAME
,      LEGAL_REGISTRATION_ID
FROM ZX.ZX_REGISTRATIONS_INT;

Dependencies

[top of page]

ZX.ZX_REGISTRATIONS_INT does not reference any database object

ZX.ZX_REGISTRATIONS_INT is referenced by following:

ZX: ZX_REGISTRATIONS_INT#