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_INT

Object Details

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

Interface Table to store the Party Tax Profile Records

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
ZX_PARTY_TAX_PROFILE_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)		User Identifier for PTP Records
PARTY_TYPE_CODE	VARCHAR2	(30)	Yes	Lookup code for party type
RECORD_STATUS	NUMBER	(2)		Interface record status
INTF_PARTY_REFERENCE	VARCHAR2	(240)		Column to store Party reference
INTF_PARTY_SITE_REFERENCE	VARCHAR2	(240)		Column to store Party's address reference
PARTY_ID	NUMBER	(22)		Column to store party identifier.
PARTY_NAME	VARCHAR2	(240)		Column to store party name
ERROR_NUMBER	NUMBER	(22)		This column is used to store the error number whenever an error is flashed
PARTY_TAX_PROFILE_ID	NUMBER	(22)		Unique identifier
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.
COUNTRY_CODE	VARCHAR2	(2)		Country code used to validate the tax registration number for this party tax profile
COUNTRY_NAME	VARCHAR2	(80)		Country name used to validate the tax registration number for this party tax profile
PROG_INT_CHAR1	VARCHAR2	(30)		For program internal use only
PROG_INT_NUM1	NUMBER	(22)		For program internal use only
REGISTRATION_TYPE_CODE	VARCHAR2	(30)		Lookup code to indicate registration type
REGISTRATION_TYPE_NAME	VARCHAR2	(80)		Lookup name to indicate registration type
PROCESS_FOR_APPLICABILITY_FLAG	VARCHAR2	(1)		Y or N indicates whether taxes should be automatically calculated for this party tax profile.This column is applicable only for suppliers.
ROUNDING_LEVEL_CODE	VARCHAR2	(30)		Rounding level code to be used for rounding of taxes calculated for this party tax profile
ROUNDING_LEVEL_NAME	VARCHAR2	(80)		Lookup name to indicate the default level of rounding for this party tax profile. Possible values are Line and Header. This is the level used to round calculated tax
ROUNDING_RULE_CODE	VARCHAR2	(30)		Rounding rule code to be used for rounding taxes of this party tax profile. 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 party tax profile. Possible values are Up, Down and Nearest. Rounding rule is the method to use to round off taxes to the minimum accountable unit.
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.
TAX_CLASSIFICATION_CODE	VARCHAR2	(30)		Default tax classification code for this party tax profile. System defaults a tax classification code to the transaction line according to the application tax options defaulting hierarchy.
TAX_CLASSIFICATION_NAME	VARCHAR2	(240)		Default tax classification Name for this party tax profile. System defaults a tax classification code to the transaction line according to the application tax options defaulting hierarchy.
ALLOW_OFFSET_TAX_FLAG	VARCHAR2	(1)		Y or N indicates whether offset taxes are allowed for this party tax profile. This column is applicable for only suppliers.

Query Text

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


SELECT BATCH_ID
,      REQUEST_ID
,      DML_TYPE
,      INTF_PTP_REFERENCE
,      PARTY_TYPE_CODE
,      RECORD_STATUS
,      INTF_PARTY_REFERENCE
,      INTF_PARTY_SITE_REFERENCE
,      PARTY_ID
,      PARTY_NAME
,      ERROR_NUMBER
,      PARTY_TAX_PROFILE_ID
,      REGISTRATION_NUMBER
,      COUNTRY_CODE
,      COUNTRY_NAME
,      PROG_INT_CHAR1
,      PROG_INT_NUM1
,      REGISTRATION_TYPE_CODE
,      REGISTRATION_TYPE_NAME
,      PROCESS_FOR_APPLICABILITY_FLAG
,      ROUNDING_LEVEL_CODE
,      ROUNDING_LEVEL_NAME
,      ROUNDING_RULE_CODE
,      ROUNDING_RULE_NAME
,      INCLUSIVE_TAX_FLAG
,      TAX_CLASSIFICATION_CODE
,      TAX_CLASSIFICATION_NAME
,      ALLOW_OFFSET_TAX_FLAG
FROM ZX.ZX_PARTY_TAX_PROFILE_INT;

Dependencies

[top of page]

ZX.ZX_PARTY_TAX_PROFILE_INT does not reference any database object

ZX.ZX_PARTY_TAX_PROFILE_INT is referenced by following:

ZX: ZX_PARTY_TAX_PROFILE_INT#