CAPI_TAX_PARAMETER

Definition

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

Technical Data

Schema Version	5.0.6
Filegroup	CATALOG_DATA
Partitioned	No

Summary

The CAPI_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. It must be unique for a tax parameter set
VALUE_TYPE						The type of the parameter More...
TPS_OID				CAPI_TAX_PARAMETER_SET (OID)		The OID of the tax parameter set containing 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 parameter 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. 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