TAX_PARAMETER

Definition


The TAX_PARAMETER table describes the parameter of a tax parameter set

Technical Data


Schema Version 5.0.6
Partitioned No

Summary


The TAX_PARAMETER table is defined by the following columns in your back-end database. See the column details for more information.

Name PK FK IX Uses Used by Definition
NAME        

    The name of the tax parameter

    More...

    VALUE_TYPE        

      The type of the parameter

      More...

      TPS_OID       TAX_PARAMETER_SET (OID)
       

        The OID of the tax parameter set having this parameter
        STRING_VALUE        

          The value of the parameter when it is a string
          NUMBER_VALUE        

            The value of the parameter when it is a number
            DATE_VALUE        

              The value of the field when it is a date
              PROPERTY_NAME        

                The name of the property to map

                Column Details

                The database schema defines the following columns. Check the definitions, types, available indexes, and formats:

                NAME

                Definition The name of the tax parameter
                Description

                The name of the tax parameter. It must be unique for a tax parameter set

                Type NVARCHAR(256), NOT NULL

                VALUE_TYPE

                Definition The type of the parameter
                Format

                The possible values are:

                • 0: number
                • 1: string
                • 2: date

                Type DECIMAL(1), NOT NULL

                TPS_OID

                Definition The OID of the tax parameter set having this parameter
                Type DECIMAL(28), NOT NULL

                STRING_VALUE

                Definition The value of the parameter when it is a string
                Type NVARCHAR(64), NULL

                NUMBER_VALUE

                Definition The value of the parameter when it is a number
                Type DECIMAL(28,6), NULL

                DATE_VALUE

                Definition The value of the field when it is a date
                Type SECONDDATE, NULL

                PROPERTY_NAME

                Definition The name of the property to map
                Type NVARCHAR(256), NULL