1. Tables and Views for Financials
  2. ZX_TAXES_B

ZX_TAXES_B

This table stores taxes and the related attributes for multiple configuration owners. Each row stores a tax for a specific regime and configuration owner.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: APPS_TS_TX_DATA

Primary Key

Name Columns

ZX_TAXES_B_PK

TAX_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TAX VARCHAR2 30 Yes Tax code
TAX_EXCPT_CREATE_METHOD_CODE VARCHAR2 30 Indicates whether, for this tax, the user will define exceptions specific to this tax or use the exceptions specified for another tax if an exception specific to this tax is not found.
TAX_EXCPT_SOURCE_TAX VARCHAR2 30 Indicates the source tax from which the application picks up the exception if a specific exception is not found for this tax.
EFFECTIVE_FROM DATE Effective from date
EFFECTIVE_TO DATE Effective to date
TAX_REGIME_CODE VARCHAR2 30 Yes Tax regime code for this tax
TAX_TYPE_CODE VARCHAR2 30 Lookup code to idnicate the classification of this tax
ALLOW_MANUAL_ENTRY_FLAG VARCHAR2 1 Y or N indicates if the user is allowed to manually enter tax lines for this tax
ALLOW_TAX_OVERRIDE_FLAG VARCHAR2 1 Y or N indicates if the user is allowed to override tax calculated by the system for this tax
MIN_TXBL_BSIS_THRSHLD NUMBER Minimum taxable basis threshold amount
MAX_TXBL_BSIS_THRSHLD NUMBER Maximum taxable basis threshold amount
MIN_TAX_RATE_THRSHLD NUMBER Minimum tax rate threshold
MAX_TAX_RATE_THRSHLD NUMBER Maximum tax rate threshold
MIN_TAX_AMT_THRSHLD NUMBER Minimum tax amount threshold
MAX_TAX_AMT_THRSHLD NUMBER Maximum tax amount threshold
COMPOUNDING_PRECEDENCE NUMBER Column to store the sequence in which this tax is detemined when taxes are compounded
PERIOD_SET_NAME VARCHAR2 15 Accounting calendar name
EXCHANGE_RATE_TYPE VARCHAR2 30 Exchange rate type for transaction currency to tax currency conversion
TAX_CURRENCY_CODE VARCHAR2 15 Tax currency code
TAX_PRECISION NUMBER Tax currency precision
MINIMUM_ACCOUNTABLE_UNIT NUMBER Tax currency minimum accountable unit
ROUNDING_RULE_CODE VARCHAR2 30 Rounding rule code to be used for rounding this tax. Possible values are UP, DOWN and NEAREST.
TAX_STATUS_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to determine tax status
TAX_RATE_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to determine tax rate
DEF_PLACE_OF_SUPPLY_TYPE_CODE VARCHAR2 30 Default place of supply type for this tax
PLACE_OF_SUPPLY_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to determine place of supply type
DIRECT_RATE_RULE_FLAG VARCHAR2 1 Y or N indicates whether direct tax rate determination rate rules can be defined for a given tax
APPLICABILITY_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined to determine applicability of this tax
TAX_CALC_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to calculate tax amount
TXBL_BSIS_THRSHLD_FLAG VARCHAR2 1 Y or N indicates whether taxable basis threshold is applicable for this tax
TAX_RATE_THRSHLD_FLAG VARCHAR2 1 Y or N indicates whether tax rate threshold is applicable for this tax
TAX_AMT_THRSHLD_FLAG VARCHAR2 1 Y or N indicates whether tax amount threshold is applicable for this tax
TAXABLE_BASIS_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to determine taxable basis
DEF_INCLUSIVE_TAX_FLAG VARCHAR2 1 Y or N indicates whether this tax is tax inclusive by default
THRSHLD_GROUPING_LVL_CODE VARCHAR2 30 Lookup code to indicate grouping level for applying thresholds across or within documents or lines or calendar periods
HAS_OTHER_JURISDICTIONS_FLAG VARCHAR2 1 Y or N indicates whether this tax has more than one jurisdiction
ALLOW_EXEMPTIONS_FLAG VARCHAR2 1 Y or N indicates whether exemptions are allowed for this tax
ALLOW_EXCEPTIONS_FLAG VARCHAR2 1 Y or N indicates whether exceptions are allowed for this tax
ALLOW_RECOVERABILITY_FLAG VARCHAR2 1 Y or N indicates whether this tax is recoverable
DEF_TAX_CALC_FORMULA VARCHAR2 30 Default formula code used to determine tax amount for this tax
TAX_INCLUSIVE_OVERRIDE_FLAG VARCHAR2 1 Y or N indicates whether the user can override the inclusiveness/exclusiveness nature of a tax line determined by the application for this tax. Only if this flag is set to Y, this control can further be overridden at the rate level.
DEF_TAXABLE_BASIS_FORMULA VARCHAR2 30 Default formula code used to determine taxable basis amount for this tax
DEF_REGISTR_PARTY_TYPE_CODE VARCHAR2 30 Lookup code to indicate default registration party type for this tax
REGISTRATION_TYPE_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to determine registration party type.
REPORTING_ONLY_FLAG VARCHAR2 1 Y or N indicates whether this a reporting only tax
AUTO_PRVN_FLAG VARCHAR2 1 Not currently used
LIVE_FOR_PROCESSING_FLAG VARCHAR2 1 Y or N indicates whether this tax is ready to be processed during tax calculation. Before this flag can be set to Y, the application validates that the basic configuration like default status, etc. for this tax is complete.
HAS_DETAIL_TB_THRSHLD_FLAG VARCHAR2 1 Not currently used
HAS_TAX_DET_DATE_RULE_FLAG VARCHAR2 1 Not currently used
HAS_EXCH_RATE_DATE_RULE_FLAG VARCHAR2 1 Not currently used
HAS_TAX_POINT_DATE_RULE_FLAG VARCHAR2 1 Not currently used
PRINT_ON_INVOICE_FLAG VARCHAR2 1 Y or N indicates whether this tax will be displayed on the printed document
USE_LEGAL_MSG_FLAG VARCHAR2 1 Y or N indicates whether legal messages are applicable for this tax
CALC_ONLY_FLAG VARCHAR2 1 Y or N indicates that this tax is used only by calculation, and is neither reported nor returned to the product
PRIMARY_RECOVERY_TYPE_CODE VARCHAR2 30 Primary recovery type code that is applicable for this tax
PRIMARY_REC_TYPE_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to determine primary recovery type code
SECONDARY_RECOVERY_TYPE_CODE VARCHAR2 30 Secondary recovery type code that is applicable for this tax when more than one recovery types is needed
SECONDARY_REC_TYPE_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to determine secondary recovery type code
PRIMARY_REC_RATE_DET_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to determine primary recovery rate
SEC_REC_RATE_DET_RULE_FLAG VARCHAR2 1 Y or N indicates whether rules are defined for this tax to determine secondary recovery rate
OFFSET_TAX_FLAG VARCHAR2 1 Y or N indicates if this tax is used to offset another tax
RECOVERY_RATE_OVERRIDE_FLAG VARCHAR2 1 Y or N indicates if the tax recovery rate can be overridden for this tax
ZONE_GEOGRAPHY_TYPE VARCHAR2 30 Primary geography type for which jurisdicitons of this tax are created. This referes to either a master or a tax geography type.
REGN_NUM_SAME_AS_LE_FLAG VARCHAR2 1 Y or N indicates whether the registration number of the tax registration for this tax should be same as the legal entity registration number
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.
PARENT_GEOGRAPHY_TYPE VARCHAR2 30 Column to store the georgaphy type of the georaphical area that confines all tax jurisdictions created for this tax when the primary geography type refers to a master geography type
PARENT_GEOGRAPHY_ID NUMBER 18 Column to store the Id of the georaphical area that confines all tax jurisdictions created for this tax when the primary geography type refers to a master geography type
ALLOW_MASS_CREATE_FLAG VARCHAR2 1 Y or N to indicate whether tax jurisdictions can be automatically created for this tax based on the primary geography type and optionally, the parent geography Id/Type
APPLIED_AMT_HANDLING_FLAG VARCHAR2 1 Lookup code to indicate how the tax amount of a prepayment in Payables is to be handled when it is applied to an invoice
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row.
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row.
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row.
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row.
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row.
REQUEST_ID NUMBER Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
RECORD_TYPE_CODE VARCHAR2 30 Lookup code to indicate whether the record is migrated, seeded or defined by the user
ALLOW_ROUNDING_OVERRIDE_FLAG VARCHAR2 1 This indicates whether the rounding rule can be verridden at Tax Registration level. Needs to be included.
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield.
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield.
SOURCE_TAX_FLAG VARCHAR2 1 Y or N indicates if this tax can be used as a source tax for creating other taxes. If this is a source tax, then it can not be created based on any other tax.
DEF_PRIMARY_REC_RATE_CODE VARCHAR2 50 Default primary recovery rate code for this tax
ALLOW_DUP_REGN_NUM_FLAG VARCHAR2 1 Y or N indicates whether duplicate tax registration numbers are allowed for this tax
DEF_SECONDARY_REC_RATE_CODE VARCHAR2 50 Default secondary recovery rate code for this tax
SPECIAL_INCLUSIVE_TAX_FLAG VARCHAR2 1 Y or N indicates if special inclusive tax handling is applicable for this tax
PROGRAM_LOGIN_ID NUMBER Login user identifier of last concurrent program to update this record
TAX_ID NUMBER 18 Yes Unique identifier
CONTENT_OWNER_ID NUMBER 18 Yes Party tax profile identifier for configuration owner of this tax
REP_TAX_AUTHORITY_ID NUMBER 18 Party tax profile identifier for the tax authority to whom this tax is reported
COLL_TAX_AUTHORITY_ID NUMBER 18 Party tax profile identifier for the tax authority to whom this tax is remitted
THRSHLD_CHK_TMPLT_CODE VARCHAR2 30 Determining factor template to be used for sub-grouping of total thresholds
TAX_ACCOUNT_SOURCE_TAX VARCHAR2 30 Column to record the source tax from which the application picks up the default GL accounts for this tax
TAX_ACCOUNT_CREATE_METHOD_CODE VARCHAR2 30 Lookup code to indicate whether for this tax, the user will define GL account defaults specific to this tax, or will make use of the defaults specified for another tax
OVERRIDE_GEOGRAPHY_TYPE VARCHAR2 30 Column to store the type of georaphical area that can override the tax rate specified for a tax jurisdiction of primary geography type
LIVE_FOR_APPLICABILITY_FLAG VARCHAR2 1 For internal use to handle location based taxes migrated from prior releases for Receivables
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.
TAX_EXMPT_CR_METHOD_CODE VARCHAR2 30 Lookup code to indicate whether for this tax, the user will define exemptions specific to this tax, or will also make use of the exemptions specified for another tax if an exemption specific to this tax is not found
TAX_EXMPT_SOURCE_TAX VARCHAR2 30 Column to record the source tax from which the application picks up the exemption for this tax, if a specific exemption fis not found for this tax
APPLICABLE_BY_DEFAULT_FLAG VARCHAR2 1 Y or N indicates if this tax is applicable by default or not
LEGAL_REPORTING_STATUS_DEF_VAL VARCHAR2 15 Legal reporting status
PROGRAM_NAME VARCHAR2 30 Program name of last concurrent program to update this record
PROGRAM_APP_NAME VARCHAR2 50 Application name of last concurrent program to update this record
TAX_POINT_BASIS VARCHAR2 30 Tax Point Basis for this tax
SELF_ASSESS_DIFF_TAX VARCHAR2 30 Column to store self assessed differential tax.
WHT_BUCKET_LEVEL_FLAG VARCHAR2 1 Values P (Party) or A (All) indicate the withholding accumulations level for transactions.
PROCESS_WHT_FLAG VARCHAR2 1 Yes or No indicates withholding calculation on indirect tax.
WHT_CALC_POINT_FLAG VARCHAR2 1 Point of withholding application. Possible values are P (payment) and I (invoice).
VALIDATION_TYPE VARCHAR2 30 Reporting type defined for registration Number validation.
VALIDATION_LEVEL VARCHAR2 30 Lookup code to indicate whether validation is based on an error or a warning.
UNIQUENESS_VALIDATION_LEVEL VARCHAR2 30 Lookup code to indicate whether validation is for all parties or a specific party.
TAX_AUTH_INV_CREATION_POINT VARCHAR2 30 Point at which a withholding tax authority invoice is created. Possible values are INVOICE for invoice and PAYMENT for payment.
TAXABLE_AMT_MAU NUMBER Minimum accountable unit for rounding the taxable amount.
CHARGE_LINE_HANDLING_CODE VARCHAR2 30 Code to indicate whether tax rules should be processed on charge lines, or tax lines should be copied from corresponding item lines.
THRSHLD_SCHEDULE_GRP_LVL_FLAG VARCHAR2 1 Threshold schedule group level indicator. Possible values are L for line, D for document, P for period, and S for set.
WHT_DATE_BASIS VARCHAR2 30 To indicate whether the withholding date basis to be adopted for the tax is invoice date or accounting date.
ALLOW_ZERO_AMT_WHT_INV_FLAG VARCHAR2 1 Indicates whether zero amount withholding invoices and accounting can be created. Valid values: Y and N.
INVOICE_AMOUNT_WHT_FLAG VARCHAR2 1 Indicates whether withholding tax is calculated on the invoice amount or on partial payment amount when an invoice is paid partially.
PAYMENT_AMOUNT_WHT_FLAG VARCHAR2 1 Indicates if threshold and schedules are applied on a group of installments in a payment or on individual installments.
TAXABLE_BASIS_EXEMPTION_FLAG VARCHAR2 1 Indicates whether taxable basis exemption rates are defined for this tax.
THRSHLD_PRODUCT_CATEGORY_FLAG VARCHAR2 1 Indicates whether withholding thresholds and schedules are defined by product category or product fiscal classification for this tax.
DEF_RECOVERY_SPL_HANDLING_FLAG VARCHAR2 1 Indicates whether the accounting to move the tax recoverable amount from the interim account to the final recoverable account is to be deferred till the point when additional events (such as proof of payment of customs duty) have occurred. (The standard handling for deferred recovery will move the amount from interim to recoverable based on the amount paid for the invoice.) Valid values are Y for "Yes" and "N" for "No". Active
DEFAULT_TAX_STATUS_CODE VARCHAR2 30 Default tax status code for this tax.
DEFAULT_TAX_RATE_CODE VARCHAR2 50 Default tax rate code for this tax.

Foreign Keys

Table Foreign Table Foreign Key Column
ZX_TAXES_B zx_regimes_b TAX_REGIME_CODE
ZX_TAXES_B zx_party_tax_profile CONTENT_OWNER_ID
ZX_TAXES_B gl_daily_conversion_types EXCHANGE_RATE_TYPE
ZX_TAXES_B zx_party_tax_profile REP_TAX_AUTHORITY_ID
ZX_TAXES_B zx_party_tax_profile COLL_TAX_AUTHORITY_ID
ZX_TAXES_B zx_det_factor_templ_b THRSHLD_CHK_TMPLT_CODE
zx_rec_nrec_dist zx_taxes_b TAX_ID
zx_lines zx_taxes_b TAX_ID
jg_zz_vat_alloc_rules zx_taxes_b TAX_ID
zx_taxes_tl zx_taxes_b TAX_ID

Indexes

Index Uniqueness Tablespace Columns
ZX_TAXES_B_N1 Non Unique Default UPPER("TAX_REGIME_CODE"), UPPER("TAX")
ZX_TAXES_B_U1 Unique Default TAX_ID
ZX_TAXES_B_U2 Unique Default TAX_REGIME_CODE, TAX, CONTENT_OWNER_ID