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: JG.JG_ZZ_VAT_REP_ENTITIES

Object Details

Object Name:	JG_ZZ_VAT_REP_ENTITIES
Object Type:	TABLE
Owner:	JG
FND Design Data:	JG.JG_ZZ_VAT_REP_ENTITIES
Subobject Name:
Status:	VALID

This is a key table which stores VAT reporting entities configuration setup. A combination of legal entity, tax regime and tax registration number uniquely identifies record in this table. Configuration information also includes details regarding tax colander, threshold amount for reporting and flags to indicate reporting method used like Allocation Rules or VAT Registers

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
JG_ZZ_VAT_REP_ENTITIES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	VAT_REPORTING_ENTITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
VAT_REPORTING_ENTITY_ID	NUMBER	(15)	Yes	VAT Reporting Entity configuration Identifier
LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity Identifier
PARTY_ID	NUMBER	(15)		Party Identifier
TAX_REGIME_CODE	VARCHAR2	(30)		Tax Regime Code
TAX_REGISTRATION_NUMBER	VARCHAR2	(50)		First Party Tax Registration Number. Also know as TRN
TAX_CALENDAR_NAME	VARCHAR2	(15)		Accounting Calender used for Tax Reporting
ENABLE_REGISTERS_FLAG	VARCHAR2	(1)		Possible values Y or N. Value Y indicates VAT Registers method is enabled
ENABLE_REPORT_SEQUENCE_FLAG	VARCHAR2	(1)		Possible values Y or N. Value Y indicates report sequence is enabled
ENABLE_ALLOCATIONS_FLAG	VARCHAR2	(1)		Possible values Y or N. Value Y indicates Allocation Rules method is enabled
ENABLE_ANNUAL_ALLOCATION_FLAG	VARCHAR2	(1)		Possible values Y or N. Value Y indicates Annual Allocations are enabled
THRESHOLD_AMOUNT	NUMBER			Indicates minimum transaction amount for VAT Reporting
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
ENTITY_LEVEL_CODE	VARCHAR2	(30)	Yes	Reporting entity level. Possible values are:Legal Entity, Ledger, BSV.
ENTITY_TYPE_CODE	VARCHAR2	(30)	Yes	Reporting entity type. Possible values are:Legal, Accounting.
LEDGER_ID	NUMBER	(15)		Ledger Identifier
BALANCING_SEGMENT_VALUE	VARCHAR2	(25)		Balancing segment value
MAPPING_VAT_REP_ENTITY_ID	NUMBER	(15)		Mapping VAT Reporting Entity Identifier
ENTITY_IDENTIFIER	VARCHAR2	(600)		Reporting Entity Identifier
DRIVING_DATE_CODE	VARCHAR2	(30)		This column will hold the value for driving date for the relevant calendar/TRN
LAST_REPORTED_PERIOD	VARCHAR2	(15)		Last reported period in 11i

Query Text

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


SELECT VAT_REPORTING_ENTITY_ID
,      LEGAL_ENTITY_ID
,      PARTY_ID
,      TAX_REGIME_CODE
,      TAX_REGISTRATION_NUMBER
,      TAX_CALENDAR_NAME
,      ENABLE_REGISTERS_FLAG
,      ENABLE_REPORT_SEQUENCE_FLAG
,      ENABLE_ALLOCATIONS_FLAG
,      ENABLE_ANNUAL_ALLOCATION_FLAG
,      THRESHOLD_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ENTITY_LEVEL_CODE
,      ENTITY_TYPE_CODE
,      LEDGER_ID
,      BALANCING_SEGMENT_VALUE
,      MAPPING_VAT_REP_ENTITY_ID
,      ENTITY_IDENTIFIER
,      DRIVING_DATE_CODE
,      LAST_REPORTED_PERIOD
FROM JG.JG_ZZ_VAT_REP_ENTITIES;

Dependencies

[top of page]

JG.JG_ZZ_VAT_REP_ENTITIES does not reference any database object

JG.JG_ZZ_VAT_REP_ENTITIES is referenced by following:

JG: JG_ZZ_VAT_REP_ENTITIES#