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 |