DBA Data[Home] [Help] [Dependency Information]

TABLE: ZX.ZX_TAXES_B

Object Details
Object Name: ZX_TAXES_B
Object Type: TABLE
Owner: ZX
FND Design Data: TableZX.ZX_TAXES_B
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
ZX_TAXES_B_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_ID
ZX_TAXES_B_U2 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_REGIME_CODE
ColumnTAX
ColumnCONTENT_OWNER_ID
Columns
Name Datatype Length Mandatory Comments
TAX VARCHAR2 (30) Yes Tax code
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 (15)
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 NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
REQUEST_ID NUMBER

Request identifier of last concurrent program to update this record
PROGRAM_APPLICATION_ID NUMBER

Application identifier of last concurrent program to update this record
PROGRAM_ID NUMBER

Program identifier of last concurrent program to update this record
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 column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment column
ATTRIBUTE_CATEGORY VARCHAR2 (150)
Descriptive flexfield structure defining column
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 (15) Yes Unique identifier
CONTENT_OWNER_ID NUMBER (15) Yes Party tax profile identifier for configuration owner of this tax
REP_TAX_AUTHORITY_ID NUMBER (15)
Party tax profile identifier for the tax authority to whom this tax is reported
COLL_TAX_AUTHORITY_ID NUMBER (15)
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
Yes Object version number
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
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT TAX
,      EFFECTIVE_FROM
,      EFFECTIVE_TO
,      TAX_REGIME_CODE
,      TAX_TYPE_CODE
,      ALLOW_MANUAL_ENTRY_FLAG
,      ALLOW_TAX_OVERRIDE_FLAG
,      MIN_TXBL_BSIS_THRSHLD
,      MAX_TXBL_BSIS_THRSHLD
,      MIN_TAX_RATE_THRSHLD
,      MAX_TAX_RATE_THRSHLD
,      MIN_TAX_AMT_THRSHLD
,      MAX_TAX_AMT_THRSHLD
,      COMPOUNDING_PRECEDENCE
,      PERIOD_SET_NAME
,      EXCHANGE_RATE_TYPE
,      TAX_CURRENCY_CODE
,      TAX_PRECISION
,      MINIMUM_ACCOUNTABLE_UNIT
,      ROUNDING_RULE_CODE
,      TAX_STATUS_RULE_FLAG
,      TAX_RATE_RULE_FLAG
,      DEF_PLACE_OF_SUPPLY_TYPE_CODE
,      PLACE_OF_SUPPLY_RULE_FLAG
,      DIRECT_RATE_RULE_FLAG
,      APPLICABILITY_RULE_FLAG
,      TAX_CALC_RULE_FLAG
,      TXBL_BSIS_THRSHLD_FLAG
,      TAX_RATE_THRSHLD_FLAG
,      TAX_AMT_THRSHLD_FLAG
,      TAXABLE_BASIS_RULE_FLAG
,      DEF_INCLUSIVE_TAX_FLAG
,      THRSHLD_GROUPING_LVL_CODE
,      HAS_OTHER_JURISDICTIONS_FLAG
,      ALLOW_EXEMPTIONS_FLAG
,      ALLOW_EXCEPTIONS_FLAG
,      ALLOW_RECOVERABILITY_FLAG
,      DEF_TAX_CALC_FORMULA
,      TAX_INCLUSIVE_OVERRIDE_FLAG
,      DEF_TAXABLE_BASIS_FORMULA
,      DEF_REGISTR_PARTY_TYPE_CODE
,      REGISTRATION_TYPE_RULE_FLAG
,      REPORTING_ONLY_FLAG
,      AUTO_PRVN_FLAG
,      LIVE_FOR_PROCESSING_FLAG
,      HAS_DETAIL_TB_THRSHLD_FLAG
,      HAS_TAX_DET_DATE_RULE_FLAG
,      HAS_EXCH_RATE_DATE_RULE_FLAG
,      HAS_TAX_POINT_DATE_RULE_FLAG
,      PRINT_ON_INVOICE_FLAG
,      USE_LEGAL_MSG_FLAG
,      CALC_ONLY_FLAG
,      PRIMARY_RECOVERY_TYPE_CODE
,      PRIMARY_REC_TYPE_RULE_FLAG
,      SECONDARY_RECOVERY_TYPE_CODE
,      SECONDARY_REC_TYPE_RULE_FLAG
,      PRIMARY_REC_RATE_DET_RULE_FLAG
,      SEC_REC_RATE_DET_RULE_FLAG
,      OFFSET_TAX_FLAG
,      RECOVERY_RATE_OVERRIDE_FLAG
,      ZONE_GEOGRAPHY_TYPE
,      REGN_NUM_SAME_AS_LE_FLAG
,      DEF_REC_SETTLEMENT_OPTION_CODE
,      PARENT_GEOGRAPHY_TYPE
,      PARENT_GEOGRAPHY_ID
,      ALLOW_MASS_CREATE_FLAG
,      APPLIED_AMT_HANDLING_FLAG
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      RECORD_TYPE_CODE
,      ALLOW_ROUNDING_OVERRIDE_FLAG
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      SOURCE_TAX_FLAG
,      DEF_PRIMARY_REC_RATE_CODE
,      ALLOW_DUP_REGN_NUM_FLAG
,      DEF_SECONDARY_REC_RATE_CODE
,      SPECIAL_INCLUSIVE_TAX_FLAG
,      PROGRAM_LOGIN_ID
,      TAX_ID
,      CONTENT_OWNER_ID
,      REP_TAX_AUTHORITY_ID
,      COLL_TAX_AUTHORITY_ID
,      THRSHLD_CHK_TMPLT_CODE
,      TAX_ACCOUNT_SOURCE_TAX
,      TAX_ACCOUNT_CREATE_METHOD_CODE
,      OVERRIDE_GEOGRAPHY_TYPE
,      LIVE_FOR_APPLICABILITY_FLAG
,      OBJECT_VERSION_NUMBER
,      TAX_EXMPT_CR_METHOD_CODE
,      TAX_EXMPT_SOURCE_TAX
,      APPLICABLE_BY_DEFAULT_FLAG
,      LEGAL_REPORTING_STATUS_DEF_VAL
FROM ZX.ZX_TAXES_B;

Dependencies

[top of page]

ZX.ZX_TAXES_B does not reference any database object

ZX.ZX_TAXES_B is referenced by following:

SchemaAPPS
SynonymZX_TAXES_B
SynonymZX_TAXES_B_TMP