[Home] [Help] [Dependency Information]
Object Name: | JG_ZZ_VAT_UPG_STG |
---|---|
Object Type: | TABLE |
Owner: | JG |
FND Design Data: | JG.JG_ZZ_VAT_UPG_STG |
Subobject Name: | |
Status: | VALID |
This table 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. Other upgrade processes, including Stamping of Tax Invoice Date, Migration of Finally Reported transactions, and Country Specific Setup migration also refer to this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
JG_ZZ_VAT_UPG_STG_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | VAT_HEADER_ID |
JG_ZZ_VAT_UPG_STG_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ORGANIZATION_ID
LEDGER_ID LEGAL_ENTITY_ID COUNTRY_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
VAT_HEADER_ID | NUMBER | (15) | Yes | VAT header identifier. System generated key column |
ORGANIZATION_ID | NUMBER | (15) | Yes | Organization identifier |
LEDGER_ID | NUMBER | (15) | Ledger identifier for an organization | |
LEGAL_ENTITY_ID | NUMBER | (15) | Legal entity identifier associated with ORGANIZATION_ID | |
COUNTRY_CODE | VARCHAR2 | (2) | Yes | Country code associated with ORGANIZATION_ID |
LOCATION_ID | NUMBER | (15) | Yes | Location identifier for the combination of ORGANIZATION_ID and COUNTRY_CODE |
GEOGRAPHY_ID | NUMBER | (15) | Yes | Geography identifier of the country |
PARTY_ID | NUMBER | (15) | 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 | 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 | |
OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT VAT_HEADER_ID
, ORGANIZATION_ID
, LEDGER_ID
, LEGAL_ENTITY_ID
, COUNTRY_CODE
, LOCATION_ID
, GEOGRAPHY_ID
, PARTY_ID
, TAX_REGISTRATION_NUMBER
, TAX_CALENDER
, REPORT_SEQUENCE_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER
FROM JG.JG_ZZ_VAT_UPG_STG;
JG.JG_ZZ_VAT_UPG_STG does not reference any database object
JG.JG_ZZ_VAT_UPG_STG is referenced by following:
|
|
|