CAPI_TAX_PARAMETER

Definition


The CAPI_TAX_PARAMETER table describes the parameters of a Charge Plan tax parameter set

Technical Data


Schema Version 4.5.13
Segment CATALOG_DATA
Partitioned No

Summary


The CAPI_TAX_PARAMETER table is defined by the following columns. See the column details for more information.

Name PK FK IX Uses Used by
NAME          
VALUE_TYPE          
TPS_OID       CAPI_TAX_PARAMETER_SET (OID)
 
 
STRING_VALUE          
NUMBER_VALUE          
DATE_VALUE          
PROPERTY_NAME          

Column Details


NAME

Definition 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 containing 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 parameter when it is a date
Type DATETIME, NULL

PROPERTY_NAME

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