[Home] [Help] [Dependency Information]
Object Name: | ZX_TAXES_B |
---|---|
Object Type: | TABLE |
Owner: | ZX |
FND Design Data: | ZX.ZX_TAXES_B |
Subobject Name: | |
Status: | VALID |
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ZX_TAXES_B_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | TAX_ID |
ZX_TAXES_B_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
TAX_REGIME_CODE
TAX CONTENT_OWNER_ID |
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 |
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;
ZX.ZX_TAXES_B does not reference any database object
ZX.ZX_TAXES_B is referenced by following:
|
|
|