Billingcodes table

 

Description

This table contains the analytical codes and uses the nested set model.

Modifying the data in this table may make it impossible to use the "Analytical codes" function. The latter must be managed from the Supervision Console (WSC).

 

Schema

Field

Type

Required

Primary key

Description

bcVALUE

nvarchar(255)

*

*

 internal identifier of the analytical code

bcLABEL

nvarchar(255)

*

 

label of the analytical code (displayed and used for selection from the WES and in reports).

bcDELETED

bit

*

 

indicates if the field has been logically deleted, but kept for historical purposes

bcHASANYPARENTDELETED

bit

*

 

indicates if the parent field/container has been logically deleted, but kept for historical purposes (to avoid recursive queries).

bcSELECTABLE

bit

*

 

allows to distinguish a container from a usable analytical code.

bcLEFT

int

*

 

(left value in the nested set model hierarchy)

bcRIGHT

int

*

 

 (right value in the nested set model hierarchy)

bcDEPTH

int

*

 

level of depth within the hierarchy

bcRESERVED1 - 5

nvarchar(255)

 

 

field reserved for future use (not used for the moment)

bcLOGINCREATION

nvarchar(255)

*

 

name of the user who created the code

bcDATECREATION

datetime

*

 

code creation date

bcLOGINLASTUPDATE

nvarchar(255)

 

 

name of the user who last modified the code

bcDATELASTUPDATE

datetime

 

 

date of last modification of the code

bcMOVED

tinyint

 

 

 if NULL or 0, "local" code, if >= 254 code replicated on another base (to be kept)