1. Tables and Views for Financials
  2. ZX_REC_NREC_DIST

ZX_REC_NREC_DIST

This table stores tax distributions for tax lines on an invoice. Each record stores a recoverable or nonrecoverable tax distribution line.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

ZX_REC_NREC_DIST_PK

REC_NREC_TAX_DIST_ID

Columns

Name Datatype Length Precision Not-null Comments Status
REC_NREC_TAX_DIST_ID NUMBER 18 Yes Unique identifier Active
APPLICATION_ID NUMBER Yes Application identifier for this tax distribution Active
ENTITY_CODE VARCHAR2 30 Yes Entity code for this tax distribution Active
EVENT_CLASS_CODE VARCHAR2 30 Yes Event class code for this tax distribution Active
EVENT_TYPE_CODE VARCHAR2 30 Yes Event type code for this tax distribution Active
TAX_EVENT_CLASS_CODE VARCHAR2 30 Tax event class code of this tax distribution Active
TAX_EVENT_TYPE_CODE VARCHAR2 30 Tax event type code of this tax distribution Active
TRX_ID NUMBER Yes Transaction identifier for this tax distribution Active
TRX_LINE_ID NUMBER Yes Transaction line identifier for this tax distribution Active
TRX_LINE_NUMBER NUMBER Transaction line number for this tax distribution Active
TAX_LINE_ID NUMBER 18 Yes Tax line identifier for this tax distribution Active
TAX_LINE_NUMBER NUMBER Yes Tax line number for this tax distribution Active
TRX_LINE_DIST_ID NUMBER Yes Item distribution identifier for this tax distribution Active
ITEM_DIST_NUMBER NUMBER Item distribution number for this tax distribution Active
CONTENT_OWNER_ID NUMBER 18 Party tax profile identifier for the first party organization of the transaction Active
REC_NREC_TAX_DIST_NUMBER NUMBER Yes Line number generated for this tax distribution Active
TAX_REGIME_ID NUMBER 18 Tax regime identifier Active
TAX_REGIME_CODE VARCHAR2 30 Tax regime code Active
TAX_ID NUMBER 18 Tax identifier Active
TAX VARCHAR2 30 Tax Active
TAX_STATUS_ID NUMBER 18 Tax status identifier Active
TAX_STATUS_CODE VARCHAR2 30 Tax status code Active
TAX_RATE_ID NUMBER 18 Tax rate identifier Active
TAX_RATE_CODE VARCHAR2 150 Tax rate code Active
TAX_RATE NUMBER Tax rate Active
INCLUSIVE_FLAG VARCHAR2 1 Y on N indicates if this tax distribution amount is included in transaction line amount. Active
RECOVERY_TYPE_ID NUMBER 18 Recovery type Identifier Active
RECOVERY_TYPE_CODE VARCHAR2 30 Recovery type code Active
RECOVERY_RATE_ID NUMBER 18 Recovery rate identifier Active
RECOVERY_RATE_CODE VARCHAR2 150 Recovery rate code Active
REC_NREC_RATE NUMBER Yes Tax distribution rate used for determining the distribution amount Active
REC_TYPE_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are used for recovery type determination Active
NEW_REC_RATE_CODE_FLAG VARCHAR2 1 Y or N indicates if the recovery rate code is new Active
RECOVERABLE_FLAG VARCHAR2 1 Yes Y or N indicates whether this tax distribution is recoverable or non-recoverable Active
REVERSE_FLAG VARCHAR2 1 Y or N indicates that this tax distribution either reverses another tax distribution or is reversed by another tax distribution Active
HISTORICAL_FLAG VARCHAR2 1 Y or N indicates whether this tax distribution is migrated from prior releases Active
REVERSED_TAX_DIST_ID NUMBER Identifier of tax distribution that is reversed by this tax distribution Active
REC_NREC_TAX_AMT NUMBER Yes Tax distribution amount in transaction currency Active
REC_NREC_TAX_AMT_TAX_CURR NUMBER Tax distribution amount in tax currency Active
REC_NREC_TAX_AMT_FUNCL_CURR NUMBER Tax distribution amount in functional currency Active
INTENDED_USE VARCHAR2 30 Fiscal classification code that indicates the purpose for which the product of this tax distribution is used Active
PROJECT_ID NUMBER Identifier for project used to build Accounting Flexfield for project-related item distribution line Active
TASK_ID NUMBER Identifier for project task used to build Accounting Flexfield for project-related item distribution line Active
AWARD_ID NUMBER Reserved for use by Oracle Grants Management Active
EXPENDITURE_TYPE VARCHAR2 30 Project expenditure type used to build Accounting Flexfield for project-related item distribution line Active
EXPENDITURE_ORGANIZATION_ID NUMBER Identifier for project organization used to build Accounting Flexfield for project-related item distribution line Active
EXPENDITURE_ITEM_DATE DATE Date for project expenditure item used to build Accounting Flexfield for project-related item distribution line Active
REC_RATE_DET_RULE_FLAG VARCHAR2 1 Y or N indicates if rules are used for recovery rate determination Active
LEDGER_ID NUMBER 18 Ledger defining column Active
SUMMARY_TAX_LINE_ID NUMBER 18 Summary tax line identifier corresponding to this tax distribution Active
RECORD_TYPE_CODE VARCHAR2 30 Lookup code to indicate whether the record is migrated, seeded or defined by the user Active
CURRENCY_CONVERSION_DATE DATE Date of the exchange rate for transaction currency to functional currency conversion Active
CURRENCY_CONVERSION_TYPE VARCHAR2 30 Exchange rate type for transaction currency to functional currency conversion Active
CURRENCY_CONVERSION_RATE NUMBER Exchange rate for transaction currency to functional currency conversion Active
TAX_CURRENCY_CONVERSION_DATE DATE Date of the exchange rate for transaction currency to tax currency conversion Active
TAX_CURRENCY_CONVERSION_TYPE VARCHAR2 30 Exchange rate type for transaction currency to tax currency conversion Active
TAX_CURRENCY_CONVERSION_RATE NUMBER Exchange rate for transaction currency to tax currency conversion Active
TRX_CURRENCY_CODE VARCHAR2 15 Transaction currency code Active
TAX_CURRENCY_CODE VARCHAR2 15 Tax currency code Active
TRX_LINE_DIST_AMT NUMBER Item distribution line amount Active
TRX_LINE_DIST_TAX_AMT NUMBER Tax amount pertaining to the current item distribution in transaction currency Active
ORIG_REC_NREC_RATE NUMBER Tax distribution rate prior to user override Active
ORIG_REC_RATE_CODE VARCHAR2 150 Tax distribution rate code prior to user override Active
ORIG_REC_NREC_TAX_AMT NUMBER Tax distribution amount prior to user override Active
ORIG_REC_NREC_TAX_AMT_TAX_CURR NUMBER Tax distribution amount in tax currency prior to user override Active
UNROUNDED_REC_NREC_TAX_AMT NUMBER Tax distribution amount in transaction currency before rounding Active
APPLICABILITY_RESULT_ID NUMBER 18 Column to record identifier of the process result obtained from tax recovery type applicability process for this tax distribution Active
REC_RATE_RESULT_ID NUMBER 18 Column to record identifier of the process result obtained from tax recovery rate determination process for this tax distribution Active
BACKWARD_COMPATIBILITY_FLAG VARCHAR2 1 Y or N indicates if the recovery rate is derived from the default recovery rate defined for tax rate code Active
OVERRIDDEN_FLAG VARCHAR2 1 Y or N indicates whether user has overridden this tax distribution Active
SELF_ASSESSED_FLAG VARCHAR2 1 Y or N indicates whether this is distribution is for a self-assessed tax Active
FREEZE_FLAG VARCHAR2 1 Y or N indicates if this tax distribution is frozen Active
POSTING_FLAG VARCHAR2 1 Y or N indicates if this tax distribution is posted to General Ledger Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 150 Global Descriptive Flexfield: structure definition of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE1 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE2 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE3 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE4 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE5 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE6 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE7 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE8 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE9 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE10 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE11 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE12 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE13 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE14 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE15 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GL_DATE DATE Accounting Date Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
REF_DOC_APPLICATION_ID NUMBER Reference document application identifier Active
REF_DOC_ENTITY_CODE VARCHAR2 30 Reference document entity code Active
REF_DOC_EVENT_CLASS_CODE VARCHAR2 30 Reference document event class code Active
REF_DOC_TRX_ID NUMBER Reference document transaction identifier Active
REF_DOC_LINE_ID NUMBER Reference document transaction line identifier Active
REF_DOC_DIST_ID NUMBER Reference document item distribution identifier Active
MINIMUM_ACCOUNTABLE_UNIT NUMBER Minimum accountable unit Active
PRECISION NUMBER Precision Active
ROUNDING_RULE_CODE VARCHAR2 30 Rounding Rule for the tax of this distribution Active
TAXABLE_AMT NUMBER Taxable amount on this tax distribution Active
TAXABLE_AMT_TAX_CURR NUMBER Taxable amount on this tax distribution in tax currency Active
TAXABLE_AMT_FUNCL_CURR NUMBER Taxable amount on this tax distribution in funcitonal currency Active
TAX_ONLY_LINE_FLAG VARCHAR2 1 Y or N indicates whether this tax distribution is for a tax only line Active
UNROUNDED_TAXABLE_AMT NUMBER Unrounded taxable amount on this tax distribution Active
LEGAL_ENTITY_ID NUMBER Legal entity identifier for the transaction Active
ACCOUNT_CCID NUMBER Account identifier associated with the item distribution line Active
ACCOUNT_STRING VARCHAR2 2000 Account string associated with the item distribution line Active
PRD_TAX_AMT NUMBER Prorated tax amount Active
PRD_TAX_AMT_TAX_CURR NUMBER Prorated tax amount in tax currency Active
PRD_TAX_AMT_FUNCL_CURR NUMBER Prorated tax amount in functional currency Active
PRD_TOTAL_TAX_AMT NUMBER Prorated total tax amount Active
PRD_TOTAL_TAX_AMT_TAX_CURR NUMBER Prorated total tax amount in tax currency Active
PRD_TOTAL_TAX_AMT_FUNCL_CURR NUMBER Prorated total tax amount in functional currency Active
APPLIED_FROM_TAX_DIST_ID NUMBER Applied from document tax distribution identifier Active
ADJUSTED_DOC_TAX_DIST_ID NUMBER Adjusted document tax distribution identifier Active
FUNC_CURR_ROUNDING_ADJUSTMENT NUMBER Functional currency rounding adjustment Active
GLOBAL_ATTRIBUTE16 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE17 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE18 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE19 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
GLOBAL_ATTRIBUTE20 VARCHAR2 150 Global Descriptive Flexfield: segment of the global descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield.
LAST_MANUAL_ENTRY VARCHAR2 30 Column to indicate which column is last overridden by the user Active
TAX_APPORTIONMENT_LINE_NUMBER NUMBER Apportionment line number for the tax line of this tax distribution when multiple tax lines are created for the same tax during migration from prior releases Active
REF_DOC_TAX_DIST_ID NUMBER Reference document tax distribution identifier Active
MRC_TAX_DIST_FLAG VARCHAR2 1 Y or N indicates if this tax distribution is for one of the multiple reporting currencies (MRC) Active
MRC_LINK_TO_TAX_DIST_ID NUMBER Identifier of the source tax disttribution in transaction currency corresponding to which this tax distribution is created if this tax distribution is in one of the multiple reporting currencies Active
TAX_APPORTIONMENT_FLAG VARCHAR2 1 Y or N indicates whether there are multiple tax lines created for the tax of this tax distribution during migration from prior releases Active
RATE_TAX_FACTOR NUMBER 1 for percentage based taxes; 0 for all others Active
REF_DOC_PER_UNIT_NREC_TAX_AMT NUMBER Per-unit non recoverable tax amount for the reference document Active
PER_UNIT_NREC_TAX_AMT NUMBER Per-unit non recoverable tax amount for the current transaction Active
TRX_LINE_DIST_QTY NUMBER Transaction line distribution quantity Active
REF_DOC_TRX_LINE_DIST_QTY NUMBER Reference document transaction line distribution quantity Active
PRICE_DIFF NUMBER Price difference. This column is applicable only for price correction invoices. Active
QTY_DIFF NUMBER Quantity difference Active
PER_TRX_CURR_UNIT_NR_AMT NUMBER Amount derived by dividing non-recoverable tax amount by quantity and price of the current document Active
REF_PER_TRX_CURR_UNIT_NR_AMT NUMBER Amount derived by dividing non-recoverable tax amount by quantity and price of the reference document Active
REF_DOC_CURR_CONV_RATE NUMBER Exchange rate for transaction to functional currecy conversion in reference document Active
UNIT_PRICE NUMBER Unit price of the current transaction line Active
REF_DOC_UNIT_PRICE NUMBER Unit price of the reference document line Active
APPLIED_TO_DOC_CURR_CONV_RATE NUMBER Applied to document exchange rate Active
TRX_NUMBER VARCHAR2 150 Transaction number for this tax distribution Active
TRX_LEVEL_TYPE VARCHAR2 30 Column to record the level at which the transaction line identifier is stored for this tax distribution. Possible values are LINE, SHIPMENT and FREIGHT. Active
REF_DOC_TRX_LEVEL_TYPE VARCHAR2 30 Column to record the level at which the reference document line identifier is stored. Possible values are LINE, SHIPMENT and FREIGHT. Active
OBJECT_VERSION_NUMBER NUMBER 9 Yes Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. Active
ORIG_AP_CHRG_DIST_NUM NUMBER Column to store INVOICE_DISTRIBUTION_ID of AP_INVOICE_DISTRIBUTIONS_ALL for the taxable line correponding to this tax distribuion if it is migrated from prior releases Active
ORIG_AP_CHRG_DIST_ID NUMBER Column to store DISTRIBUTION_LINE_NUMBER of AP_INVOICE_DISTRIBUTIONS_ALL for the taxable line correponding to this tax distribuion if it is migrated from prior releases Active
ORIG_AP_TAX_DIST_NUM NUMBER Column to store INVOICE_DISTRIBUTION_ID of AP_INVOICE_DISTRIBUTIONS_ALL for the tax line correponding to this tax distribuion if it is migrated from prior releases Active
ORIG_AP_TAX_DIST_ID NUMBER Column to store DISTRIBUTION_LINE_NUMBER of AP_INVOICE_DISTRIBUTIONS_ALL for the tax line correponding to this tax distribuion if it is migrated from prior releases Active
INTERNAL_ORGANIZATION_ID NUMBER Internal organization identifier of the transaction Active
TAX_JURISDICTION_ID NUMBER 18 Internal identifier of Tax Jurisdiction Active
DEF_REC_SETTLEMENT_OPTION_CODE VARCHAR2 30 Lookup code to indicate whether an input tax can be recovered when an invoice is recorded or only when the invoice is paid and whether an output tax is due for settlement when the invoice is issued or only when the payment is received against it Active
ACCOUNT_SOURCE_TAX_RATE_ID NUMBER 18 Tax Rate from which the GL account should be derived. If the tax derives its GL account from another tax, this column store the tax rate id of that tax, i.e., the source tax for accounts Active
INTENDED_USE_CLASSIF_ID NUMBER Default intended use code for transactions for a specified country.
TAX_POINT_BASIS VARCHAR2 30 Tax point basis for the tax distribution.
TAX_POINT_DATE DATE Date on which the taxpayer becomes liable for paying the tax to the tax authority.
REPORTABLE_FLAG VARCHAR2 1 Y or N indicates whether this tax distribution is reportable.
LEGAL_REPORTING_STATUS VARCHAR2 15 Status for legal reporting.
APPLIED_TO_TAX_DIST_ID NUMBER 18 Applied to document tax distribution identifier.
APPLIED_TO_ENTITY_CODE VARCHAR2 30 Entity code for the document to which this transaction will be applied.
ACCOUNTING_EVENT_ID NUMBER 18 Identifier for an accounting event record in a table.
POSTED_TO_SLA_FLAG VARCHAR2 1 Yes or No indicates whether an item distribution has been posted to SLA.
TRANSFERRED_TO_GL_FLAG VARCHAR2 1 To indicate if this distribution is transferred to GL.
ACCOUNTING_REQUEST_ID NUMBER 18 To store request identifier of the accounting program.
APPLIED_TO_APPLICATION_ID NUMBER 18 Application identifier for the document to which this transaction will be applied.
APPLIED_TO_EVENT_CLASS_CODE VARCHAR2 30 Event class for the document to which this transaction will be applied.
APPLIED_TO_TRX_ID NUMBER 18 Internal identifier for the document to which this transaction will be applied.
APPLIED_TO_LINE_ID NUMBER 18 Transaction line identifier for the document to which this transaction will be applied.
APPLIED_TO_TRX_LEVEL_TYPE VARCHAR2 30 Transaction level type of the document to which this transaction will be applied.
APPL_TO_TRX_CURR_UNIT_NR_AMT NUMBER Nonrecoverable tax amount by quantity and price of the document to which this transaction will be applied.
APPL_TO_PER_UNIT_NREC_TAX_AMT NUMBER Nonrecoverable tax amount per unit for the document to which this transaction will be applied.
APPLIED_TO_UNIT_PRICE NUMBER Unit price for the document line to which this transaction will be applied.
APPLIED_TO_TRX_LINE_DIST_QTY NUMBER Quantity of the transaction line distribution of the document to which this transaction will be applied.
APPLIED_TO_DIST_ID NUMBER 18 Transaction distribution identifier for the document to which this transaction will be applied.
MATCH_TYPE VARCHAR2 25 To identify other charges matched to receipt.
CREDIT_ACCOUNT_CCID NUMBER 18 Credit account identifier for the transaction line.
DEBIT_ACCOUNT_CCID NUMBER 18 Debit account identifier for the transaction line.
REPORTING_BATCH_ID NUMBER 18 Selection process batch identifier.
ACCRUE_ON_RECEIPT_FLAG VARCHAR2 1 Yes or No indicates whether the underlying procure-to-pay transaction allows accrual on receipt.
EXPENDITURE_TYPE_ID NUMBER 18 Project expenditure type identifier.
ASSET_FLAG VARCHAR2 1 Indicates if distribution is tracked in Assets. Possible values are Y or N.
PROCESS_FINAL_RECOVERY_CODE VARCHAR2 30 Indicates whether distribution is processed for final recovery. Valid values are I (incomplete) or P (processed). Active

Foreign Keys

Table Foreign Table Foreign Key Column
ZX_REC_NREC_DIST zx_regimes_b TAX_REGIME_CODE
ZX_REC_NREC_DIST zx_lines_summary SUMMARY_TAX_LINE_ID
ZX_REC_NREC_DIST zx_process_results APPLICABILITY_RESULT_ID
ZX_REC_NREC_DIST zx_rec_nrec_dist APPLIED_FROM_TAX_DIST_ID
ZX_REC_NREC_DIST zx_taxes_b TAX_ID
ZX_REC_NREC_DIST zx_event_classes_b TAX_EVENT_CLASS_CODE
ZX_REC_NREC_DIST zx_party_tax_profile CONTENT_OWNER_ID
ZX_REC_NREC_DIST gl_code_combinations ACCOUNT_CCID
ZX_REC_NREC_DIST zx_rec_nrec_dist ADJUSTED_DOC_TAX_DIST_ID
ZX_REC_NREC_DIST zx_status_b TAX_STATUS_ID
ZX_REC_NREC_DIST zx_rates_b TAX_RATE_ID
ZX_REC_NREC_DIST zx_recovery_types_b RECOVERY_TYPE_ID
ZX_REC_NREC_DIST zx_rates_b RECOVERY_RATE_ID
ZX_REC_NREC_DIST zx_rec_nrec_dist REVERSED_TAX_DIST_ID
ZX_REC_NREC_DIST pjf_projects_all_b PROJECT_ID
ZX_REC_NREC_DIST pjf_proj_elements_b TASK_ID
zx_rec_nrec_dist zx_rec_nrec_dist APPLIED_FROM_TAX_DIST_ID
zx_rec_nrec_dist zx_rec_nrec_dist ADJUSTED_DOC_TAX_DIST_ID
zx_rec_nrec_dist zx_rec_nrec_dist REVERSED_TAX_DIST_ID

Indexes

Index Uniqueness Tablespace Columns Status
ZX_REC_NREC_DIST_N1 Non Unique Default PROCESS_FINAL_RECOVERY_CODE, ACCOUNTING_EVENT_ID
ZX_REC_NREC_DIST_N3 Non Unique Default POSTING_FLAG, GL_DATE
ZX_REC_NREC_DIST_U1 Unique FUSION_TS_TX_DATA REC_NREC_TAX_DIST_ID Active
ZX_REC_NREC_DIST_U2 Unique FUSION_TS_TX_DATA TAX_LINE_ID, TRX_LINE_DIST_ID, REC_NREC_TAX_DIST_NUMBER Active
ZX_REC_NREC_DIST_U3 Unique FUSION_TS_TX_DATA APPLICATION_ID, ENTITY_CODE, EVENT_CLASS_CODE, TRX_ID, TAX_LINE_NUMBER, TRX_LINE_DIST_ID, REC_NREC_TAX_DIST_NUMBER Active