JG_ZZ_VAT_UPG_STG
JG_ZZ_VAT_UPG_STG stores mapping information of Legal Entities, Ledgers, Operating Units, and Country Codes. The table is populated by the upgrade script, which extracts all Operating Units belonging to countries that use the EMEA VAT solution, and identifies the corresponding Ledgers, GRE/LEs, and country codes.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
JG_ZZ_VAT_UPG_STG_PK |
VAT_HEADER_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| VAT_HEADER_ID | NUMBER | 18 | Yes | VAT header identifier. System generated key column | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | Organization identifier | |
| LEDGER_ID | NUMBER | 18 | Ledger identifier for an organization | ||
| LEGAL_ENTITY_ID | NUMBER | 18 | Legal entity identifier associated with ORGANIZATION_ID | ||
| COUNTRY_CODE | VARCHAR2 | 2 | Yes | Country code associated with ORGANIZATION_ID | |
| LOCATION_ID | NUMBER | 18 | Yes | Location identifier for the combination of ORGANIZATION_ID and COUNTRY_CODE | |
| GEOGRAPHY_ID | NUMBER | 18 | Yes | Geography identifier of the country | |
| PARTY_ID | NUMBER | 18 | Party identifier for a legal entity | ||
| TAX_REGISTRATION_NUMBER | VARCHAR2 | 50 | Tax registration number for a legal entity | ||
| TAX_CALENDER | VARCHAR2 | 30 | Tax calendar; dependent on the country and ledger | ||
| REPORT_SEQUENCE_FLAG | VARCHAR2 | 1 | Report sequence flag for ECE countries | ||
| 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. | ||
| 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. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| jg_zz_vat_trx_upg_stg | jg_zz_vat_upg_stg | VAT_HEADER_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| JG_ZZ_VAT_UPG_STG_N1 | Non Unique | Default | ORGANIZATION_ID, LEDGER_ID, LEGAL_ENTITY_ID, COUNTRY_CODE |
| JG_ZZ_VAT_UPG_STG_U1 | Unique | Default | VAT_HEADER_ID |