DBA Data[Home] [Help] [Dependency Information]

TABLE: JG.JG_ZZ_VAT_REP_STATUS

Object Details
Object Name: JG_ZZ_VAT_REP_STATUS
Object Type: TABLE
Owner: JG
FND Design Data: TableJG.JG_ZZ_VAT_REP_STATUS
Subobject Name:
Status: VALID


Stores the reporting status of the Tax Registration Number by period and source.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
JG_ZZ_VAT_REP_STATUS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORTING_STATUS_ID
JG_ZZ_VAT_REP_STATUS_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnVAT_REPORTING_ENTITY_ID
ColumnTAX_CALENDAR_PERIOD
ColumnSOURCE
Columns
Name Datatype Length Mandatory Comments
REPORTING_STATUS_ID NUMBER (15) Yes Reporting status Identifier
VAT_REPORTING_ENTITY_ID NUMBER (15) Yes Indentifier of VAT reporting entity
TAX_REGISTRATION_NUMBER VARCHAR2 (30) Yes Indicates the VAT registration number of reporting entity
TAX_CALENDAR_NAME VARCHAR2 (15) Yes Indicates the tax calendar
TAX_CALENDAR_YEAR NUMBER (15) Yes Indicates the tax calendar year
TAX_CALENDAR_PERIOD VARCHAR2 (15) Yes Indicates the tax calendar period
PERIOD_START_DATE DATE
Yes Indicates the start date of period
PERIOD_END_DATE DATE
Yes Indicates the end date of period
SOURCE VARCHAR2 (30) Yes Indicates source of the transaction. Possible values AP, AR and GL
SELECTION_STATUS_FLAG VARCHAR2 (1)
Indicates the selection status.
ALLOCATION_STATUS_FLAG VARCHAR2 (1)
Indicates the allocation status.
FINAL_REPORTING_STATUS_FLAG VARCHAR2 (1)
Indicates the selection status.
ARCHIVAL_STATUS_FLAG VARCHAR2 (1)
Indicates the selection status.
SELECTION_PROCESS_ID NUMBER (15)
Identifier stamped by the selection process.
ALLOCATION_PROCESS_ID NUMBER (15)
Identifier stamped by allocation.
FINAL_REPORTING_PROCESS_ID NUMBER (15)
Identifier of the final reporting process.
ARCHIVAL_PROCESS_ID NUMBER (15)
Identifier of the archival process.
SELECTION_PROCESS_DATE DATE

Date on which selection process was run
ALLOCATION_PROCESS_DATE DATE

Date on which allocation process was run
FINAL_REPORTING_PROCESS_DATE DATE

Date on which final process was run
ARCHIVAL_PROCESS_DATE DATE

Date on which archival process was run
REQUEST_ID NUMBER (15)
Enhanced Who column
PROGRAM_ID NUMBER (15)
Enhanced Who column
PROGRAM_APPLICATION_ID NUMBER (15)
Enhanced Who column
PROGRAM_UPDATE_DATE DATE

Enhanced Who column
PROGRAM_LOGIN_ID NUMBER (15)
Enhanced Who column
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
MAPPING_VAT_REP_ENTITY_ID NUMBER (15) Yes Mapping VAT Reporting Entity Identifier
CREDIT_BALANCE_AMT NUMBER

Credit VAT balance amount used by Italian VATregisters.
Query Text

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


SELECT REPORTING_STATUS_ID
,      VAT_REPORTING_ENTITY_ID
,      TAX_REGISTRATION_NUMBER
,      TAX_CALENDAR_NAME
,      TAX_CALENDAR_YEAR
,      TAX_CALENDAR_PERIOD
,      PERIOD_START_DATE
,      PERIOD_END_DATE
,      SOURCE
,      SELECTION_STATUS_FLAG
,      ALLOCATION_STATUS_FLAG
,      FINAL_REPORTING_STATUS_FLAG
,      ARCHIVAL_STATUS_FLAG
,      SELECTION_PROCESS_ID
,      ALLOCATION_PROCESS_ID
,      FINAL_REPORTING_PROCESS_ID
,      ARCHIVAL_PROCESS_ID
,      SELECTION_PROCESS_DATE
,      ALLOCATION_PROCESS_DATE
,      FINAL_REPORTING_PROCESS_DATE
,      ARCHIVAL_PROCESS_DATE
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      PROGRAM_LOGIN_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      MAPPING_VAT_REP_ENTITY_ID
,      CREDIT_BALANCE_AMT
FROM JG.JG_ZZ_VAT_REP_STATUS;

Dependencies

[top of page]

JG.JG_ZZ_VAT_REP_STATUS does not reference any database object

JG.JG_ZZ_VAT_REP_STATUS is referenced by following:

SchemaJG
ViewJG_ZZ_VAT_REP_STATUS#