JG — Regional Localizations
49 documented tables · 33 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
JG_ZZ_VAT_REP_ENTITIES |
Captures configuration information for legal entities for VAT reporting. | hub-leaning |
JG_ZZ_VAT_REP_STATUS |
Stores the reporting status of the Tax Registration Number by period and source. | satellite-leaning |
JG_ZZ_INTEREST_BATCHES_ALL |
Interest invoice batch details | hub-leaning |
JG_ZZ_VAT_REGISTERS_B |
Base table for storing VAT Registers association with reporting entity | hub-leaning |
JG_ZZ_INTEREST_INVOICES_ALL |
Invoice header information for interest invoices | satellite-leaning |
JG_ZZ_SYS_FORMATS_ALL_B |
EFT Payments Table Data | hub-leaning |
JG_ZZ_VAT_TRX_DETAILS |
Contains AP, AR and GL Transactions selected for VAT reporting | hub-leaning |
JG_ZZ_VAT_ALLOC_RULES |
Captures rules for allocating VAT boxes to transaction during allocation process | satellite-leaning |
JG_ZZ_VAT_UPG_STG |
Stores mapping information of Legal Entity, Ledgers, OUs, and Country Codes | satellite-leaning |
JG_ZZ_VAT_BOX_ERRORS |
Stores the errors that are generated during VAT box allocation processing | standalone |
JG_ZZ_AR_TMP_BAL |
Temporary sub-ledger balances for Receivables | standalone |
JG_ZZ_AP_BALANCES |
Sub-ledger balances for Payables | standalone |
JG_ZZ_VAT_FINAL_REPORTS |
Stores details of final print generation of reports, by entity and period | satellite-leaning |
JG_ZZ_INVOICE_INFO |
Additional country-specific payment information for invoices | standalone |
JG_ZZ_PAY_SCHED_INFO |
Additional country-specific information for payment schedules | standalone |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.