1. Tables and Views for Financials
  2. ZX_THREHLDS_SCHDL_CNTRLS_F

ZX_THREHLDS_SCHDL_CNTRLS_F

This table contains detail information about thresholds for tax and jurisdictions.

Details

  • Schema: FUSION

  • Object owner: ZX

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

ZX_THREHLDS_SCHDL_CNTRLS_F_PK

TAX_THREHLDS_SCHDL_CNTRL_ID

Columns

Name Datatype Length Precision Not-null Comments Status
TAX_THREHLDS_SCHDL_CNTRL_ID NUMBER 18 Yes Column to uniquely identify the tax threshold and schedule controls. Active
CONTENT_OWNER_ID NUMBER 18 Yes Configuration owner of the tax detail record. Active
TAX VARCHAR2 30 Yes Tax code for the classification of a charge imposed by a government through a fiscal or tax authority. Active
TAX_THREHLDS_SCHDL_CNTRL_CODE VARCHAR2 30 Code to identify the tax threshold and schedules control record.
MIN_TAXABLE_THRSHLD NUMBER Minimum taxable threshold limit of the tax threshold controls. Active
MAX_TAXABLE_THRSHLD NUMBER Maximum taxable threshold limit of the tax threshold controls. Active
MIN_TAX_THRSHLD NUMBER Minimum tax threshold limit of the tax threshold controls. Active
MAX_TAX_THRSHLD NUMBER Maximum tax threshold limit of the tax threshold controls. Active
MIN_RATE_THRSHLD NUMBER Minimum rate threshold limit of the tax threshold controls. Active
MAX_RATE_THRSHLD NUMBER Maximum rate threshold limit of the tax threshold controls. Active
EFFECTIVE_START_DATE DATE Yes Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective. Active
EFFECTIVE_END_DATE DATE Yes Date Effective Entity: indicates the date at the end of the date range within which the row is effective. Active
TAX_REGIME_CODE VARCHAR2 30 Yes Tax regime code on the tax threshold controls. Active
TAX_JURISDICTION_CODE VARCHAR2 30 Tax jurisdiction code for the tax detail. Active
THRSHLD_SCHEDULE_GRP_LVL_FLAG VARCHAR2 1 Threshold schedule group level. Possible values are: L (line for transaction tax), D (document for transaction tax or withholding tax), P (period for withholding tax), U (per unit) and S (set). Active
CALENDAR_NAME VARCHAR2 30 Name of tax calendar defined in ZX_CALENDARS. Used when the schedule basis is set to "period". Active
SCHEDULE_APPLICATION_FLAG VARCHAR2 1 Schedule application. Possible values are M (multiple rates depending upon amount ranges) and S (single rate on entire taxable basis). Active
TXBL_BSIS_THRSHLD_HNDLNG_FLAG VARCHAR2 1 Taxable basis threshold handling. Possible values are E (amount exceeding minimum taxable threshold) and F (full amount). Active
ATTRIBUTE_CATEGORY VARCHAR2 150 Descriptive Flexfield: structure definition of the user descriptive flexfield. Active
ATTRIBUTE1 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE2 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE3 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE4 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE5 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE6 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE7 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE8 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE9 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE10 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE11 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE12 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE13 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE14 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE15 VARCHAR2 150 Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER1 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER2 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER3 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER4 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_NUMBER5 NUMBER Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE1 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE2 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE3 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE4 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
ATTRIBUTE_DATE5 DATE Descriptive Flexfield: segment of the user descriptive flexfield. Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
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. Active
DEDUCTION_AMT_PER_DEPENDENT NUMBER Fixed amount for deduction based on the number of dependents.
THRESHOLD_TYPE_CODE VARCHAR2 30 Indicates the type of threshold. Possible values are TAX_RATE for tax rate, TAXABLE_AMOUNT for taxable amount, and TAX_AMOUNT for tax amount.
OPERATOR_CODE VARCHAR2 30 Operator used for defining the condition on which tax thresholds are applied. Possible values are Equals, Not Equal To.
CLASSIFICATION_TYPE_CODE VARCHAR2 30 Product fiscal classification type code that drives the threshold.
CLASSIFICATION_CODE VARCHAR2 240 Product classification code that drives the thresholds.
PARENT_GEOGRAPHY_ID NUMBER 18 Parent geography within which the tax lines are grouped for evaluating document level taxable amount thresholds.

Foreign Keys

Table Foreign Table Foreign Key Column
ZX_THREHLDS_SCHDL_CNTRLS_F hz_geographies TAX_THREHLDS_SCHDL_CNTRL_ID

Indexes

Index Uniqueness Tablespace Columns Status
ZX_THREHLDS_SCHDL_CNTRLS_F_U1 Unique FUSION_TS_TX_IDX TAX_THREHLDS_SCHDL_CNTRL_ID Active
ZX_THREHLDS_SCHDL_CNTRLS_F_U2 Unique Default TAX_REGIME_CODE, TAX, TAX_JURISDICTION_CODE, THRESHOLD_TYPE_CODE, CALENDAR_NAME, CONTENT_OWNER_ID, TAX_THREHLDS_SCHDL_CNTRL_CODE, EFFECTIVE_START_DATE, CLASSIFICATION_TYPE_CODE, CLASSIFICATION_CODE