ZX_REGIMES_B_
This table stores tax regimes and the related attributes. There will be one row per distinct tax regime. There are default entry columns to facilitate data entry process.
Details
-
Schema: FUSION
-
Object owner: ZX
-
Object type: TABLE
-
Tablespace: APPS_TS_TX_DATA
Primary Key
| Name | Columns |
|---|---|
|
ZX_REGIMES_B_PK_ |
LAST_UPDATE_DATE, LAST_UPDATED_BY, TAX_REGIME_CODE |
Columns
| Name | Datatype | Length | Precision | Not-null | 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 | ||
| CONV_ROUNDING_OPTION_CODE | VARCHAR2 | 30 | Indicates the currency types for which rounded tax amounts in transaction currency will be used for currency conversion. Possible values are 'Functional Currency', 'Tax Currency' and 'Both'. If no value is specified, unrounded tax amounts in transaction currency will be used to calculate the tax amounts in both Functional and Tax Currency. | ||
| 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 | VARCHAR2 | 64 | Who column: indicates the user who created the row. | ||
| CREATION_DATE | TIMESTAMP | 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 | 18 | Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row. | ||
| PROGRAM_LOGIN_ID | NUMBER | Login user identifier of last concurrent program to update this record | |||
| 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. | ||
| 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 | 18 | Unique identifier | ||
| GEOGRAPHY_ID | NUMBER | 18 | 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 | 18 | Party tax profile identifier for the tax authority to whom all taxes under this regime are reported | ||
| COLL_TAX_AUTHORITY_ID | NUMBER | 18 | 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 | 9 | 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. | ||
| 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 | ||
| USE_TAX_REPORT_CONFIG_FLAG | VARCHAR2 | 1 | Use Tax Reporting Configuration Flag | ||
| REGIME_TYPE_FLAG | VARCHAR2 | 1 | Lookup code that indicates the type of regime. Possible values are W (withholding), I (indirect) and NULL (indirect). | ||
| 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. | ||
| EXEMPTION_PROCESS_FLAG | VARCHAR2 | 1 | Indicates whether exemptions are defined for customer, supplier, or both. | ||
| BUCKET_LEVEL_FLAG | VARCHAR2 | 1 | Level at which withholding tax buckets are maintained. Possible values are L for legal entity and B for business unit. | ||
| USE_SYSTEM_DEFAULTS_FLAG | VARCHAR2 | 1 | Indicates that application default values of tax status, rate, recovery rate, taxable basis formula, or tax calculation formula are used in tax calculation when an incomplete or inconsistent configuration is found. | ||
| GROSS_NET_FLAG | VARCHAR2 | 1 | Apply regime on the gross or net amount on retainage indicator. | ||
| AUDIT_ACTION_TYPE_ | VARCHAR2 | 10 | Action Type - have values like INSERT, UPDATE and DELETE. | ||
| AUDIT_CHANGE_BIT_MAP_ | VARCHAR2 | 1000 | Used to store a bit map of 1s and 0s for each column in the table. | ||
| AUDIT_IMPERSONATOR_ | VARCHAR2 | 64 | Original Impersonator User. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| ZX_REGIMES_B_N1_ | Non Unique | Default | TAX_REGIME_CODE |
| ZX_REGIMES_B_U1_ | Unique | Default | LAST_UPDATE_DATE, LAST_UPDATED_BY, TAX_REGIME_CODE |