ZX Tables (124)

ZX - E-Business Tax — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

TableColumnsDescription
ZX_ACCOUNTS 43 This table contains default tax accounts for jurisdictions and rates. Each record represents default tax accounts defined by the internal or
ZX_ACCOUNT_RATES 38 This table contains tax options for a ledger or an account segment value. Each record represents input or output tax options defined by a co
ZX_ACCT_TX_CLS_DEFS_ALL 28 This table contains tax classification code defaults for account segment values. Each record represents a default tax classification code de
ZX_API_CODE_COMBINATIONS 28 This table stores valid context combinations for each Context Key Flexfiled structure, using which third party or custom APIs can be registe
ZX_API_OWNER_STATUSES 8 This table stores the status of APIs registration for an API owner. Each record represents the status of APIs registration of a API owner f
ZX_API_REGISTRATIONS 17 This table stores the registration of a set of APIs required to support third party tax service providers. Each record represents registrati
ZX_COMPOUND_ERRORS 11 This table stores errors found during tax groups migration from ZX_TAX_PRIORITIES_T.
ZX_COMPOUND_ERRORS_T 13
ZX_CONDITIONS 25 This table stores a set of conditions for each condition group defined in ZX_CONDITION_GROUPS_B. Each record represents one condition in the
ZX_CONDITION_GROUPS_B 130 This table associates the multiple conditions defined in Conditions to a Result.
ZX_CONDITION_GROUPS_TL 10 This table provides multilingual support (MLS) for each tax condition group. MLS enables you to store and print data that you define in mult
ZX_CONTENT_CHOICES_TMP 8 This table is for future use.
ZX_CONTENT_SOURCES 18 This table stores multiple sources from which tax configuration content can be loaded. Each row stores details about a content source for a
ZX_DATA_UPLOAD_DISCARD 56 This is an intermediate table used by data upload program to hold the content not used by e-business tax from third party content provider t
ZX_DATA_UPLOAD_INTERFACE 56 This is an intermediate table used by data upload program to hold the content from third party content provider temporarily.
ZX_DETAIL_TAX_LINES_GT 310 This global temporary table is used to cache tax lines during tax processing for transactions.
ZX_DETERMINING_FACTORS_B 26 This table stores the determining factors used to define conditions for tax rules. Each record represents one determining factor.
ZX_DET_FACTORS_TL 11 This table provides multilingual support (MLS) for each determining factor. MLS enables you to store and print data that you define in multi
ZX_DET_FACTOR_TEMPL_B 18 This table stores templates for usage of determining factors. Each record represents one determining factor template.
ZX_DET_FACTOR_TEMPL_DTL 20 This table stores a set of determining factors for each determining factor template defined in ZX_DET_FACTOR_TEMPL_B. Each record represents
ZX_DET_FACTOR_TEMPL_TL 11 This table provides multilingual support (MLS) for each determining factor template. MLS enables you to store and print data that you define
ZX_ERRORS_GT 10 This global temporary table is used to return errors encountered during tax processing for transactions.
ZX_ERRORS_INT 7 Interface Table to store the Tax Error Records
ZX_EVENT_CLASSES_B 9 This table stores tax event classes. This table contains seeded data only.
ZX_EVENT_CLASSES_TL 10 This table provides multilingual support (MLS) for each tax event class. MLS enables you to store and print data that you define in multiple
ZX_EVENT_CLASS_PARAMS 8 This table stores the list of parameters not passed by applications, which is used to skip conditions during rules processing. Each row deno
ZX_EVNT_CLS_MAPPINGS 84 ZX_EVNT_CLS_MAPPINGS stores mappings of tax event classes to event classes of Oracle Applications.
ZX_EVNT_CLS_OPTIONS 38 This table stores tax options for application event classes. Each row contains tax options defined by a first party organization for an appl
ZX_EVNT_CLS_TYPS 9 This table stores tax event types. Each row in this table stores a tax event type for a tax event class. This table contains seeded data onl
ZX_EVNT_TYP_MAPPINGS 15 This table stores mappings of application event types to tax event types for all event classes mapped to tax event classes in ZX_EVNT_CLS_MA
ZX_EXCEPTIONS 50 This table stores tax rate exceptions for items and product fiscal classifications.Each row specifies the percentage of original tax rate to
ZX_EXEMPTIONS 50 This table stores tax exemptions for parties, party sites and items. Each record contains an exemption percentage of a specific tax rate for
ZX_EXEMPTIONS_INT 56 Interface Table to store the Exemption Records
ZX_FC_CODES_B 37 This table stores fiscal classification code hierarchies for types of Document Sub Type, Intended Use, User Defined Fiscal Classification, P
ZX_FC_CODES_CATEG_ASSOC 34 This table stores the association of the classification codes of transaction fiscal classification category with the classification codes of
ZX_FC_CODES_DENORM_B 49 This table stores relations data for fiscal classification code hierarchies in denormalized form. There is one row for each classification c
ZX_FC_CODES_TL 10 This table provides multilingual support (MLS) for each fiscal classification code. MLS enables you to store and print data that you define
ZX_FC_COUNTRY_DEFAULTS 46 This table stores tax defaults and controls for multiple countries. Each record contains tax defaults and controls for a specific country.
ZX_FC_TYPES_B 41 This table stores the fiscal classification types defined for all classification categories. Each row records a fiscal classification type f
ZX_FC_TYPES_REG_ASSOC 33 This table stores association of fiscal classification types to multiple tax regimes. Each row stores an association of a specific fiscal cl
ZX_FC_TYPES_TL 10 This table provides multilingual support (MLS) for each fiscal classification type. MLS enables you to store and print data that you define
ZX_FORMULA_B 51 This table stores formulas that will be used to calculate taxable basis and tax amounts. Each row stores a formula to determine taxable basi
ZX_FORMULA_DETAILS 38 For Taxable Basis formulas, this table stores compounding taxes or taxes for which the current tax is a surcharge. For Tax Calculation formu
ZX_FORMULA_TL 11 This table provides multilingual support (MLS) for each tax formula. MLS enables you to store and print data that you define in
ZX_ID_TCC_MAPPING_ALL 20 This table stores the list of tax classification codes applicable for an internal organization. This table also stores the mapping of migrat
ZX_IMPORT_TAX_LINES_GT 48 This global temporary table is used to pass summary or detail tax lines when importing documents with tax.
ZX_ITM_DISTRIBUTIONS_GT 144 This global temporary table is used to pass document item distributions for calculating recoverable and/or non-recoverable tax distributions
ZX_JURISDICTIONS_B 44 This table stores the Tax Jurisdictions for a Tax.
ZX_JURISDICTIONS_GT 5 This global temporary table is used to cache tax jurisdictions during tax processing for transactions when there are multiple jurisdictions
ZX_JURISDICTIONS_TL 9 This table provides multilingual support (MLS) for each tax jurisdiction. MLS enables you to store and print data that you define in
ZX_LINES 310 This table stores detail tax lines for transactions of multiple event classes.
ZX_LINES_DET_FACTORS 349 This table stores transaction related attributes used for tax calculation and reporting. Each row stores a trasnaction line of an event clas
ZX_LINES_SUMMARY 147 This table stores the summarized tax lines for transactions of multiple event classes.
ZX_PARAMETERS_B 14 This table stores definitions of all tax parameters.
ZX_PARAMETERS_TL 10 This table provides multilingual support (MLS) for each tax parameter. MLS enables you to store and print data that you define in multiple l
ZX_PARAM_DETAILS 10 This table stores elements for structured tax parameters.
ZX_PARTY_TAX_PROFILE 56 This table stores tax profiles for third parties, third party sites, third party providers, first party legal entities, first party legal es
ZX_PARTY_TAX_PROFILE_INT 28 Interface Table to store the Party Tax Profile Records
ZX_PARTY_TYPES 13 This table stores party types.
ZX_PO_REC_DIST 10 This table stores the calculated recovery rate for purcahse orders. This table is used for purchase order tax lines and distributions migrat
ZX_PROCESS_RESULTS 36 This table stores the outcome of evaluation for tax rules. Each record stores the process result for evaluation of a specific condition grou
ZX_PRODUCT_OPTIONS_ALL 33 This table store the tax system options for multiple applications. Each record stores tax options of an operating unit for a specific applic
ZX_PRVDR_HDR_EXTNS_GT 56 This table stores the user extensible attributes that need to be passed to the partner service at the transaction level for the purpose of t
ZX_PRVDR_LINE_EXTNS_GT 58 This table stores the extensible attributes required/ need to be passed to the partner service at the line level for the purpose of tax proc
ZX_PTNR_LOCATION_INFO_GT 132 This table stores flattened location structure for partner reference.
ZX_PTNR_NEG_LINE_GT 219 This global temporary table is used to cache copy of the transaction lines before user modifies them. This copying is carried only for upgra
ZX_PTNR_NEG_TAX_LINE_GT 29 This global temporary table is used to cache copy of the tax lines before user modifies them. This copying is carried only for upgraded tax
ZX_PURGE_TRANSACTIONS_GT 4 This global temporary table is used by the application products to pass the identifiers of the transactions to be purged from the tax reposi
ZX_RATES_B 64 This table stores rates for multiple configuration owners. Each row stores a rate that is effective for a specific period and is applicable
ZX_RATES_TL 10 This table provides multilingual support (MLS) for each tax rate. MLS enables you to store and print data that you define in multiple langua
ZX_RECOVERY_TYPES_B 32 This table stores the recovery types. Each row stores a recovry type corresponding to a tax.
ZX_RECOVERY_TYPES_TL 10 This table provides multilingual support (MLS) for each recovery type. MLS enables you to store and print data that you define in multiple l
ZX_REC_NREC_DIST 174 This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line.
ZX_REC_NREC_DIST_GT 174 This global temporary table is used to cache tax distributions during tax processing for transactions.
ZX_REGIMES_B 76 This table defines and describes Tax Regime and related attributes. There will be one row per distinct tax regime. There are default entry
ZX_REGIMES_TL 9 This table provides multilingual support (MLS) for each tax regime. MLS enables you to store and print data that you define in multiple lang
ZX_REGIMES_USAGES 11 This table stores the list of regimes for each first party organization, where the transactions of that first party organization can have ta
ZX_REGIME_RELATIONS 32 This table stores hierarchical relationships between tax regimes.
ZX_REGISTRATIONS 60 This table stores tax registrations.
ZX_REGISTRATIONS_INT 40 Interface Table to store the Registration Records
ZX_REPORTING_CODES_B 20 This table stores reporting codes.
ZX_REPORTING_CODES_TL 10 This table provides multilingual support (MLS) for each reporting code. MLS enables you to store and print data that you define in multiple
ZX_REPORTING_TYPES_B 24 This table stores tax reporting types.
ZX_REPORTING_TYPES_TL 10 This table provides multilingual support (MLS) for each reporting type. MLS enables you to store and print data that you define in multiple
ZX_REPORT_CODES_ASSOC 17 This table stores associate of reporting types and codes with entities like taxes, statuses and rates. Each row stores the association of a
ZX_REPORT_CODES_ASSOC_INT 22 Interface Table to store the Reporting Code Association Records
ZX_REPORT_TYPES_USAGES 11 This table stores information about the usage of reporting types for specific entities.
ZX_REP_ACTG_EXT_T 55 This table stores the accounting information extarcted by the tax extract program from each product transaction table. This table contains o
ZX_REP_CONTEXT_T 40 This table stores context information for tax reports. Each row contains operating unit address information for reports run at the ledger or
ZX_REP_MATRIX_EXT_T 109 This table stores tax information for matrix reporting. This table contains one row for every row present in ZX_REP_TRX_DETAIL_T.
ZX_REP_TRX_DETAIL_T 327 This table stores the tax lines information from Payables, Receivables and General Ledger.
ZX_REP_TRX_JX_EXT_T 92 This table stores additional information for tax lines present in ZX_REP_TRX_DETAIL_T. This table contains one row for every row present in
ZX_REVERSE_DIST_GT 54 This global temporary table is used to pass transaction line distribution identifiers of reversing and reversed documents.
ZX_REVERSE_TRX_LINES_GT 42
ZX_RULES_B 33 This table stores the tax rules that are used to detrermine the outcome of multiple tax determination processes. Each row stores a rule for
ZX_RULES_TL 11 This table provides multilingual support (MLS) for each tax rule. MLS enables you to store and print data that you define in multiple langua
ZX_SERVICE_TYPES 11 This table stores tax service types.
ZX_SIM_CONDITIONS 29 This table is for future use.
ZX_SIM_PROCESS_RESULTS 18 This table is for future use.
ZX_SIM_PURGE 9 This table is used to store information which will be used later for purging data created through tax simulator.
ZX_SIM_RULES_B 22 This table is for future use.
ZX_SIM_RULES_TL 9 This table is for future use.
ZX_SIM_RULE_CONDITIONS 20 This table is for future use.
ZX_SIM_TRX_DISTS 150 This table stores item distribution information for transactions created through tax simulator.
ZX_SRVC_SBSCRPTN_EXCLS 11 This table stores the list of event classes and applications that do not call the services of the tax service provider corresponding to a se
ZX_SRVC_SUBSCRIPTIONS 14 This table stores the list of service subscriptions for each regime of a first party organization defined in ZX_REGIMES_USAGE table.
ZX_SRVC_TYP_PARAMS 13 This table stores parameters for the service types.
ZX_STATUS_B 42 This table stores tax statuses for multiple configuration owners. Each row stores a status for a tax and configuration owner.
ZX_STATUS_TL 9 This table provides multilingual support (MLS) for each tax status. MLS enables you to store and print data that you define in multiple lang
ZX_SUBSCRIPTION_DETAILS 14 This table stores the detailed interpretations for each enabled content subscription option defined in ZX_SUBSCRIPTION_OPTIONS table.
ZX_SUBSCRIPTION_OPTIONS 15 This table stores the list of date effective content subscription options for each regime of a first party organization defined in ZX_REGIME
ZX_TAXES_B 113 This table stores taxes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner.
ZX_TAXES_TL 9 This table provides multilingual support (MLS) for each tax. MLS enables you to store and print data that you define in multiple languages.
ZX_TAX_PRIORITIES_T 18 This table stores priorities of taxes and regimes. Each row records the priority for either a tax or a regime. This table is used for tax gr
ZX_TAX_RELATIONS_T 26 This table stores parent child relationships of tax codes within tax groups. This table is used for tax groups migration from prior releases
ZX_TRANSACTION 80 This table stores transactions entered by the user through tax simulator.
ZX_TRANSACTION_LINES 117 This table stores transaction lines entered by the user through tax simulator.
ZX_TRANSACTION_LINES_GT 292 This global temporary table is used to pass transaction lines information for tax calculation.
ZX_TRX_HEADERS_GT 91 This global temporary table is used to pass transaction information for tax calculation.
ZX_TRX_LINE_APP_REGIMES 17 This table stores the applicable regimes for transactions. Each row stores one applicable regime for a specific transaction line.
ZX_TRX_PRE_PROC_OPTIONS_GT 24 This table stores the various provider pre-processing options for the applicable regime of the transaction under consideration before callin
ZX_TRX_TAX_LINK_GT 24 This global temporary table is used to pass information about allocation of imported tax lines to transaction lines during tax processing fo
ZX_UPDATE_CRITERIA_RESULTS 20 This table stores tax definition information like tax regime, tax and tax status for tax codes. This table is used for tax definition migrat
ZX_VALIDATION_ERRORS_GT 17 This global temporary table is used to return validation errors for imported transactions from tax perspective.