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_PARTY_TAX_PROFILE

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_PARTY_TAX_PROFILE_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_TAX_PROFILE_ID
ZX_PARTY_TAX_PROFILE_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_ID PARTY_TYPE_CODE
ZX_PARTY_TAX_PROFILE_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REP_REGISTRATION_NUMBER

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_TYPE_CODE	VARCHAR2	(30)		Lookup code for party type
SUPPLIER_FLAG	VARCHAR2	(1)		Y or N indicates whether this party tax profile is for a third party supplier
CUSTOMER_FLAG	VARCHAR2	(1)		Y or N indicates whether this party tax profile is for a third party customer
SITE_FLAG	VARCHAR2	(1)		Y or N indicates whether this party tax profile is for a third party site
PROCESS_FOR_APPLICABILITY_FLAG	VARCHAR2	(1)		Y or N indicates whether taxes should be automatically calculated for this party tax profile
ROUNDING_LEVEL_CODE	VARCHAR2	(30)		Rounding level code to be used for rounding of taxes calculated for this party tax profile
ROUNDING_RULE_CODE	VARCHAR2	(30)		Rounding rule code to be used for rounding of taxes calculated for this party tax profile
WITHHOLDING_START_DATE	DATE			Withholding start date for this party tax profile
INCLUSIVE_TAX_FLAG	VARCHAR2	(1)		Y or N indicates whether transaction line amounts include tax amount for this party tax profile. This column is applicable for only suppliers.
ALLOW_AWT_FLAG	VARCHAR2	(1)		Y or N indicates whether tax withholding is allowed for this party tax profile
USE_LE_AS_SUBSCRIBER_FLAG	VARCHAR2	(1)		Y or N indicates whether Legal Entity should be used for determining taxes for transactions of this party tax profile. This column is applicable only for operating units.
LEGAL_ESTABLISHMENT_FLAG	VARCHAR2	(1)		Y or N indicates whether this party tax profile is for a first party legal establishment
FIRST_PARTY_LE_FLAG	VARCHAR2	(1)		Y or N indicates whether this party tax profile is for a first party legal entity
REPORTING_AUTHORITY_FLAG	VARCHAR2	(1)		Y or N indicates whether this party tax profile is for a reporting tax authority
COLLECTING_AUTHORITY_FLAG	VARCHAR2	(1)		Y or N indicates whether this party tax profile is for a collecting tax authority
PROVIDER_TYPE_CODE	VARCHAR2	(30)		Lookup code that identifies whether the third party provider offers tax content or tax services or both
CREATE_AWT_DISTS_TYPE_CODE	VARCHAR2	(30)		Lookup code to indicate the event when tax is automatically withheld for this party tax profile (Never, Approval, Payment)
CREATE_AWT_INVOICES_TYPE_CODE	VARCHAR2	(30)		Lookup code to indicate the event when withholding tax invoices are automatically created for this party tax profile (Never, Approval, Payment)
TAX_CLASSIFICATION_CODE	VARCHAR2	(30)		Default tax classification code for this party tax profile
SELF_ASSESS_FLAG	VARCHAR2	(1)		Y or N indicates whether taxes are self-assessed for this party tax profile
ALLOW_OFFSET_TAX_FLAG	VARCHAR2	(1)		Y or N indicates whehter offset taxes are allowed for this party tax profile
EFFECTIVE_FROM_USE_LE	DATE			Effective start date from which Legal Entity is used to determine taxes for transactions of this party tax profile. This column is applicable only for operating units.
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
PROGRAM_LOGIN_ID	NUMBER			Login user identifier of this record by a concurrent program
PARTY_TAX_PROFILE_ID	NUMBER	(15)	Yes	Unique identifier
PARTY_ID	NUMBER	(15)	Yes	Party identifier
REP_REGISTRATION_NUMBER	VARCHAR2	(50)		Tax registration number for this party tax profile. This column is applicable only for suppliers, customers and first party legal establishments.
OBJECT_VERSION_NUMBER	NUMBER		Yes	Object version number
REGISTRATION_TYPE_CODE	VARCHAR2	(30)		Lookup code to indicate registration type
COUNTRY_CODE	VARCHAR2	(2)		Country code used to validate the tax registration number for this party tax profile
MERGED_TO_PTP_ID	NUMBER	(15)		Identifier of the party tax profile into which this party tax profile is merged
MERGED_STATUS_CODE	VARCHAR2	(30)		Lookup code to indicate the status of party merge for this party tax profile

Query Text

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


SELECT PARTY_TYPE_CODE
,      SUPPLIER_FLAG
,      CUSTOMER_FLAG
,      SITE_FLAG
,      PROCESS_FOR_APPLICABILITY_FLAG
,      ROUNDING_LEVEL_CODE
,      ROUNDING_RULE_CODE
,      WITHHOLDING_START_DATE
,      INCLUSIVE_TAX_FLAG
,      ALLOW_AWT_FLAG
,      USE_LE_AS_SUBSCRIBER_FLAG
,      LEGAL_ESTABLISHMENT_FLAG
,      FIRST_PARTY_LE_FLAG
,      REPORTING_AUTHORITY_FLAG
,      COLLECTING_AUTHORITY_FLAG
,      PROVIDER_TYPE_CODE
,      CREATE_AWT_DISTS_TYPE_CODE
,      CREATE_AWT_INVOICES_TYPE_CODE
,      TAX_CLASSIFICATION_CODE
,      SELF_ASSESS_FLAG
,      ALLOW_OFFSET_TAX_FLAG
,      EFFECTIVE_FROM_USE_LE
,      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
,      PROGRAM_LOGIN_ID
,      PARTY_TAX_PROFILE_ID
,      PARTY_ID
,      REP_REGISTRATION_NUMBER
,      OBJECT_VERSION_NUMBER
,      REGISTRATION_TYPE_CODE
,      COUNTRY_CODE
,      MERGED_TO_PTP_ID
,      MERGED_STATUS_CODE
FROM ZX.ZX_PARTY_TAX_PROFILE;

Dependencies

[top of page]

ZX.ZX_PARTY_TAX_PROFILE does not reference any database object

ZX.ZX_PARTY_TAX_PROFILE is referenced by following:

ZX: ZX_PARTY_TAX_PROFILE#