[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ZX_REGIMES_B |
|---|---|
| Object Type: | TABLE |
| Owner: | ZX |
| FND Design Data: |  ZX.ZX_REGIMES_B
|
| Subobject Name: | |
| Status: | VALID |
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| ZX_REGIMES_B_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 TAX_REGIME_ID
|
| ZX_REGIMES_B_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
TAX_REGIME_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| TAX_REGIME_CODE | VARCHAR2 | (30) | Yes | Tax regime code |
| PARENT_REGIME_CODE | VARCHAR2 | (30) | Parent regime code for this regime | |
| HAS_SUB_REGIME_FLAG | VARCHAR2 | (1) | Y or N indicates whether this regime is a parent regime with one or more child regimes defined under it | |
| COUNTRY_OR_GROUP_CODE | VARCHAR2 | (30) | Lookup code to indicate whether this regime is defined for a country or for a group of countries | |
| COUNTRY_CODE | VARCHAR2 | (2) | Country code for which this regime is defined | |
| GEOGRAPHY_TYPE | VARCHAR2 | (30) | Lookup code to indicate geography type of the group of countries for which this regime is defined | |
| EFFECTIVE_FROM | DATE | Effective from date | ||
| EFFECTIVE_TO | DATE | Effective to date | ||
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange rate type for transaction currency to tax currency conversion | |
| TAX_CURRENCY_CODE | VARCHAR2 | (15) | Tax currency code | |
| THRSHLD_GROUPING_LVL_CODE | VARCHAR2 | (30) | Lookup code to indicate grouping level for applying thresholds across or within documents or lines or calendar periods | |
| ROUNDING_RULE_CODE | VARCHAR2 | (30) | Rounding rule code to be used for rounding taxes of this regime. Possible values are UP, DOWN and NEAREST. | |
| TAX_PRECISION | NUMBER | Tax currency precision | ||
| MINIMUM_ACCOUNTABLE_UNIT | NUMBER | Tax currency minimum accountable unit | ||
| TAX_STATUS_RULE_FLAG | VARCHAR2 | (1) | Y or N indicates whether rules are defined for taxes of this regime to determine tax status. This setting can be overriden at the tax level. | |
| DEF_PLACE_OF_SUPPLY_TYPE_CODE | VARCHAR2 | (30) | Default place of supply type for this regime | |
| APPLICABILITY_RULE_FLAG | VARCHAR2 | (1) | Y or N indicates whether rules are defined for this regime to determine tax applicability | |
| PLACE_OF_SUPPLY_RULE_FLAG | VARCHAR2 | (1) | Y or N indicates whether rules are defined for taxes of this regime to determine place of supply type. This setting can be overriden at the tax level. | |
| TAX_CALC_RULE_FLAG | VARCHAR2 | (1) | Y or N indicates whether rules are defined for taxes of this regime to calculate tax amount. This setting can be overriden at the tax level. | |
| TAXABLE_BASIS_THRSHLD_FLAG | VARCHAR2 | (1) | Y or N indicates whether taxable basis threshold is applicable for this regime | |
| TAX_RATE_THRSHLD_FLAG | VARCHAR2 | (1) | Y or N indicates whether tax rate threshold is applicable for this regime | |
| TAX_AMT_THRSHLD_FLAG | VARCHAR2 | (1) | Y or N indicates whether tax amount threshold is applicable for this regime | |
| TAX_RATE_RULE_FLAG | VARCHAR2 | (1) | Y or N indicates whether rules are defined for taxes of this regime to determine tax rate. This setting can be overriden at the tax level. | |
| TAXABLE_BASIS_RULE_FLAG | VARCHAR2 | (1) | Y or N indicates whether rules are defined for taxes of this regime to determine taxable basis. This setting can be overriden at the tax level. | |
| DEF_INCLUSIVE_TAX_FLAG | VARCHAR2 | (1) | Y or N indicates whether all the tax types within this regime are tax inclusive by default | |
| HAS_OTHER_JURISDICTIONS_FLAG | VARCHAR2 | (1) | Y or N indicates whether taxes of this regime can have more than one jurisdiction | |
| ALLOW_ROUNDING_OVERRIDE_FLAG | VARCHAR2 | (1) | Y or N indicates whether the rounding rules can be overridden for taxes of this regime | |
| ALLOW_EXEMPTIONS_FLAG | VARCHAR2 | (1) | Y or N indicates whether exemptions are allowed for this tax regime | |
| ALLOW_EXCEPTIONS_FLAG | VARCHAR2 | (1) | Y or N indicates whether exceptions are allowed for this tax regime | |
| ALLOW_RECOVERABILITY_FLAG | VARCHAR2 | (1) | Y or N indicates whether taxes of this regime are recoverable | |
| AUTO_PRVN_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 | |
| USE_LEGAL_MSG_FLAG | VARCHAR2 | (1) | Y or N indicates whether legal messages are applicable for this regime | |
| REGN_NUM_SAME_AS_LE_FLAG | VARCHAR2 | (1) | Y or N indicates whether the registration number of the tax registration for this regime 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. | |
| RECORD_TYPE_CODE | VARCHAR2 | (30) | Lookup code to indicate whether the record is migrated, seeded or defined by the user | |
| 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 | ||
| PROGRAM_LOGIN_ID | NUMBER | Login user identifier of last concurrent program to update this record | ||
| 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 | |
| DEF_REGISTR_PARTY_TYPE_CODE | VARCHAR2 | (30) | Lookup code to indicate default registration party type for taxes of this regime | |
| REGISTRATION_TYPE_RULE_FLAG | VARCHAR2 | (1) | Y or N indicates whether rules are defined for taxes of this regime to determine registration party type. This setting can be overriden at the tax level. | |
| TAX_INCLUSIVE_OVERRIDE_FLAG | VARCHAR2 | (1) | Y or N indicates whether the tax inclusive flag can be overridden at tax line | |
| REGIME_PRECEDENCE | NUMBER | Column to indicate the precedence level at which taxes of this regime are determined when taxes are compounded across regimes | ||
| CROSS_REGIME_COMPOUNDING_FLAG | VARCHAR2 | (1) | Y or N indicates whether cross regime compounding is allowed for this regime | |
| TAX_REGIME_ID | NUMBER | (15) | Yes | Unique identifier |
| GEOGRAPHY_ID | NUMBER | (15) | Geography Id of the group of countries for which this regime is defined | |
| THRSHLD_CHK_TMPLT_CODE | VARCHAR2 | (30) | Determining factor template to be used for sub-grouping of total thresholds | |
| PERIOD_SET_NAME | VARCHAR2 | (15) | Accounting calendar name | |
| REP_TAX_AUTHORITY_ID | NUMBER | (15) | Party tax profile identifier for the tax authority to whom all taxes under this regime are reported | |
| COLL_TAX_AUTHORITY_ID | NUMBER | (15) | Party tax profile identifier for the tax authority to whom all taxes under this regime are remitted | |
| TAX_ACCOUNT_PRECEDENCE_CODE | VARCHAR2 | (30) | Column to store lowest level used to define tax accounts for this regime | |
| OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number |
Cut, paste (and edit) the following text to query this object:
SELECT TAX_REGIME_CODE
, PARENT_REGIME_CODE
, HAS_SUB_REGIME_FLAG
, COUNTRY_OR_GROUP_CODE
, COUNTRY_CODE
, GEOGRAPHY_TYPE
, EFFECTIVE_FROM
, EFFECTIVE_TO
, EXCHANGE_RATE_TYPE
, TAX_CURRENCY_CODE
, THRSHLD_GROUPING_LVL_CODE
, ROUNDING_RULE_CODE
, TAX_PRECISION
, MINIMUM_ACCOUNTABLE_UNIT
, TAX_STATUS_RULE_FLAG
, DEF_PLACE_OF_SUPPLY_TYPE_CODE
, APPLICABILITY_RULE_FLAG
, PLACE_OF_SUPPLY_RULE_FLAG
, TAX_CALC_RULE_FLAG
, TAXABLE_BASIS_THRSHLD_FLAG
, TAX_RATE_THRSHLD_FLAG
, TAX_AMT_THRSHLD_FLAG
, TAX_RATE_RULE_FLAG
, TAXABLE_BASIS_RULE_FLAG
, DEF_INCLUSIVE_TAX_FLAG
, HAS_OTHER_JURISDICTIONS_FLAG
, ALLOW_ROUNDING_OVERRIDE_FLAG
, ALLOW_EXEMPTIONS_FLAG
, ALLOW_EXCEPTIONS_FLAG
, ALLOW_RECOVERABILITY_FLAG
, AUTO_PRVN_FLAG
, HAS_TAX_DET_DATE_RULE_FLAG
, HAS_EXCH_RATE_DATE_RULE_FLAG
, HAS_TAX_POINT_DATE_RULE_FLAG
, USE_LEGAL_MSG_FLAG
, REGN_NUM_SAME_AS_LE_FLAG
, DEF_REC_SETTLEMENT_OPTION_CODE
, RECORD_TYPE_CODE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE_CATEGORY
, DEF_REGISTR_PARTY_TYPE_CODE
, REGISTRATION_TYPE_RULE_FLAG
, TAX_INCLUSIVE_OVERRIDE_FLAG
, REGIME_PRECEDENCE
, CROSS_REGIME_COMPOUNDING_FLAG
, TAX_REGIME_ID
, GEOGRAPHY_ID
, THRSHLD_CHK_TMPLT_CODE
, PERIOD_SET_NAME
, REP_TAX_AUTHORITY_ID
, COLL_TAX_AUTHORITY_ID
, TAX_ACCOUNT_PRECEDENCE_CODE
, OBJECT_VERSION_NUMBER
FROM ZX.ZX_REGIMES_B;
ZX.ZX_REGIMES_B does not reference any database object
ZX.ZX_REGIMES_B is referenced by following:
ZX
ZX_REGIMES_B#
|
|
|
|