PROPERTIES

CDR Custom Properties

Definition

The PROPERTIES table contains the name of the properties used in the CDR

Description

The PROPERTIES table contains the name of the properties used in the consumption detail records (CDRs). The values of CDR properties are stored in the properties field of the CDR table.

Technical Data

Schema Version	5.0.5
Filegroup	BART_DATA
Partitioned	No

Summary

The PROPERTIES 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
OID						The unique ID of properties
NAME						The name of properties
TYPE						The type of properties More...

Column Details

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

OID

Definition	The unique ID of properties
Type	DECIMAL(3), NULL

NAME

Definition	The name of properties
Type	NVARCHAR(256), NULL

TYPE

Definition	The type of properties
Format	The possible values are: 0: String 1: Number 2: Date
Type	DECIMAL(1), NULL