JG Tables (49)

JG - Regional Localizations — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
`JE_PARENT_CHILD_GT`	4
`JE_PROFIT_LOSS_RPT_GT`	3
`JG_ZZ_AP_BALANCES`	19	Sub-ledger balances for Payables
`JG_ZZ_AP_IR_REP_ITF`	26	Interim table for 'RXi/RX-only: Payables Invoice Register by Detail' Report
`JG_ZZ_AP_TMP_ACCOUNT`	19	Contains information of each contra account
`JG_ZZ_AP_TMP_BAL`	19	Temporary sub-ledger balances for Payables
`JG_ZZ_AP_TMP_DETAIL`	25	Used for calculating sub-ledger balances and holding detailed reporting data for Payables
`JG_ZZ_AP_WHT_ITF`	262	Korean Withholding Tax Extract Table
`JG_ZZ_AR_BALANCES`	19	Sub-ledger balances for Receivables
`JG_ZZ_AR_SRC_TRX_TY_ALL`	27	This table stores associations of transaction sources and transaction types. This table restricts you to using only associated transaction t
`JG_ZZ_AR_TMP_ACCOUNT`	26	Table containing information about each contra account
`JG_ZZ_AR_TMP_BAL`	19	Temporary sub-ledger balances for Receivables
`JG_ZZ_AR_TMP_DETAIL`	29	Used for calculating sub-ledger balances and holding detailed reporting data for Receivables
`JG_ZZ_ENTITY_ASSOC`	34	Business Entity Relationships information
`JG_ZZ_FA_REG_ITF`	76	JG_ZZ_FA_REG_ITF holds data needed for Fixed Assets Register Report
`JG_ZZ_GL_RECON_TRX`	19	A RXi Interface Table for the RXi report General Ledger Reconciled Transactions Report.
`JG_ZZ_GL_UNREC_TRX`	16	A RXi Interface Table for the RXi report General Ledger Unreconciled Transactions Report.
`JG_ZZ_II_INT_RATES_ALL`	13
`JG_ZZ_INTEREST_BATCHES_ALL`	11	Interest invoice batch details
`JG_ZZ_INTEREST_INVOICES_ALL`	15	Invoice header information for interest invoices
`JG_ZZ_INT_INV_LINES_ALL`	18	Detail invoice lines for interest invoices
`JG_ZZ_INVOICE_INFO`	37	Additional country-specific payment information for invoices
`JG_ZZ_JGZZCSLP_MESSAGES`	1	Holds status messages of Customer Account Balance Maintenance program
`JG_ZZ_JGZZVSLP_MESSAGES`	1	Holds status messages of Vendor Account Balance Maintenance program
`JG_ZZ_PAY_FORMAT_INFO`	37	Holds Country Specific Format Data
`JG_ZZ_PAY_SCHED_INFO`	38	Additional country-specific information for payment schedules
`JG_ZZ_SYS_FORMATS_ALL_B`	39	EFT Payments Table Data
`JG_ZZ_SYS_FORMATS_ALL_TL`	11	Holds additional country specific information for EFT Payment Formats.
`JG_ZZ_TA_ACCOUNT_RANGES`	26	Stores the journal allocation natural account ranges
`JG_ZZ_TA_ALLOCATED_LINES`	12	Stores the information on the original journal line used to allocate new journal line
`JG_ZZ_TA_CC_RANGES`	26	Holds Cost Center Range for Rules.
`JG_ZZ_TA_RULE_LINES`	26	Stores the Journal Allocation Lines
`JG_ZZ_TA_RULE_SETS`	27	Stores the header information for each Journal Allocation Rule Set.
`JG_ZZ_TMP_RPT_HEADERS`	2	Statutory Report Header
`JG_ZZ_VAT_ALLOC_RULES`	28	Captures rules for allocating VAT boxes to transaction during allocation process
`JG_ZZ_VAT_BOX_ALLOCS`	17	Stores VAT box allocation information for tax and taxable amounts by period type
`JG_ZZ_VAT_BOX_ERRORS`	8	Stores the errors that are generated during VAT box allocation processing
`JG_ZZ_VAT_DOC_SEQUENCES`	8	Captures document sequences associated with VAT register for reporting purpose
`JG_ZZ_VAT_FINAL_REPORTS`	16	Stores details of final print generation of reports, by entity and period
`JG_ZZ_VAT_REGISTERS_B`	10	Base table for storing VAT Registers association with reporting entity
`JG_ZZ_VAT_REGISTERS_TL`	9	Captures translatable columns for table JG_ZZ_VAT_REGISTERS_B
`JG_ZZ_VAT_REP_ENTITIES`	24	Captures configuration information for legal entities for VAT reporting.
`JG_ZZ_VAT_REP_STATUS`	33	Stores the reporting status of the Tax Registration Number by period and source.
`JG_ZZ_VAT_TRX_DETAILS`	233	Contains AP, AR and GL Transactions selected for VAT reporting
`JG_ZZ_VAT_TRX_GT`	85
`JG_ZZ_VAT_TRX_UPG_STG`	19	Consolidates all transactions from R11i final reporting tables migrated to R12
`JG_ZZ_VAT_UPG_STG`	17	Stores mapping information of Legal Entity, Ledgers, OUs, and Country Codes
`JG_ZZ_VAT_UPG_STG_TMP`	7	A table to store unique Ledger ID values from table JG_ZZ_VAT_UPG_STG .
`JG_ZZ_VEND_SITE_INFO`	38	Additional country-specific information for vendor sites