JG_ZZ_VAT_REP_ENTITIES
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
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JG_ZZ_VAT_REP_ENTITIES_PK |
VAT_REPORTING_ENTITY_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| VAT_REPORTING_ENTITY_ID | NUMBER | 18 | Yes | VAT Reporting Entity configuration Identifier | |
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal Entity Identifier | ||
| PARTY_ID | NUMBER | 18 | Party Identifier | ||
| TAX_REGIME_CODE | VARCHAR2 | 30 | Tax Regime Code | ||
| TAX_REGISTRATION_NUMBER | VARCHAR2 | 50 | First Party Tax Registration Number | ||
| 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 | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| ENTITY_LEVEL_CODE | VARCHAR2 | 30 | Yes | Reporting Entity level. Possible values are Legal Entity, Ledger, Balancing Segment Value | |
| ENTITY_TYPE_CODE | VARCHAR2 | 30 | Yes | Reporting entity type. Possible values are:Legal, Accounting. | |
| LEDGER_ID | NUMBER | 18 | Ledger Identifier | ||
| BALANCING_SEGMENT_VALUE | VARCHAR2 | 25 | Balancing segment value | ||
| MAPPING_VAT_REP_ENTITY_ID | NUMBER | 18 | Mapping VAT Reporting Entity Identifier | ||
| ENTITY_IDENTIFIER | VARCHAR2 | 600 | Reporting Entity Identifier | ||
| DRIVING_DATE_CODE | VARCHAR2 | 30 | Driving date for the relevant calendar and tax registration number | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| START_DATE | DATE | The date the tax reporting entity goes into effect. | |||
| END_DATE | DATE | The date the tax reporting entity expires. | |||
| TAX_REGISTRATION_ID | NUMBER | 18 | Foreign Key to tax registrations table | ||
| TAX_POINT_DATE_CODE | VARCHAR2 | 30 | Specifies driving date of the tax reporting entity is tax point date. | ||
| TAX_POINT_DATE_EFFECTIVE_FROM | DATE | The date from which the tax point date approach is effective for the reporting entity. | |||
| TAX_POINT_DATE_EFFECTIVE_TO | DATE | The date upto which the tax point date approach is effective for the reporting entity. | |||
| DRIVING_DATE_EFFECTIVE_FROM | DATE | The date from which the reporting date approach is effective for the reporting entity. | |||
| DRIVING_DATE_EFFECTIVE_TO | DATE | The date upto which the tax point date approach is effective for the reporting entity. | |||
| ENABLE_FINAL_DATA_VALIDATION | VARCHAR2 | 1 | Indicates whether validation is enabled for new or modified transactions before finalization. Possible values are Y and N. | ||
| ENABLE_SWEEP_PROCESS_FLAG | VARCHAR2 | 1 | Indicates whether new or modified transactions that are identified during finalization process will be swept to next open tax period. Possible values are Y and N. | ||
| TAX_CALENDAR_START_PERIOD | VARCHAR2 | 15 | Start period of tax reporting for entity. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| JG_ZZ_VAT_REP_ENTITIES | hz_parties | PARTY_ID |
| JG_ZZ_VAT_REP_ENTITIES | zx_registrations | TAX_REGISTRATION_ID |
| JG_ZZ_VAT_REP_ENTITIES | gl_ledgers | LEDGER_ID |
| jg_zz_vat_rep_status | jg_zz_vat_rep_entities | VAT_REPORTING_ENTITY_ID |
| jg_zz_vat_registers_b | jg_zz_vat_rep_entities | VAT_REPORTING_ENTITY_ID |
| jg_zz_vat_alloc_rules | jg_zz_vat_rep_entities | VAT_REPORTING_ENTITY_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_ZZ_VAT_REP_ENTITIES_U1 | Unique | Default | VAT_REPORTING_ENTITY_ID |