Billingcodes_exceptions table

Description

This table is used to store access rights to analytical codes by user and/or group.

 

Schema

Field

Type

Required

Primary key

Description

bceOBJECTNAME

nvarchar(128)

*

*

name of the user or group to which the access right applies.

bceBILLINGCODE

nvarchar(255)

*

*

identifier of the analytical code to which the access right applies

bceOBJECTTYPE

tinyint

*

*

field determining whether the right applies to a user if 0 = nothing, 1 = user, if 2 = group and 3 = user and group

bceALLOWED

bit

*

 

allows you to know if the access right is allowed or denied