Property starting with A |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
AccountLabel
|
Ac_Label
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountSelection
|
Ac_Selection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
AccountType
|
Ac_Type
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
A,24820,Associate | B,8371,Bank | C,14006,Customer | D,64,Division | E,9551,Employee | L,25454,Lead | N,29,Not Validated | P,24822,Prospect | R,24870,Reseller | S,5098,Supplier | T,15235,Suspect |
|
Active
|
Active
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowApproval
|
Ap_Use
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowAttachment
|
Attachment
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowEditSecurityLevel
|
EditSecurity
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowPublish
|
UsePublish
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowRating
|
UseRating
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AssortmentDefault
|
As_Default
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
3,0,Accessoires | 6,0,Halffabrikaten | 2,0,Interne producten | 5,0,Onbewerkte materialen | 1,0,Producten | 4,0,Service | 0,0,Standaard | 7,0,Uren |
|
Property starting with C |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
CreatedDate
|
CreatedDate
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
CreatedBy
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRole1
|
Cr_Role1
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRole2
|
Cr_Role2
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRole3
|
Cr_Role3
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRoleLevel1
|
Cr_Level1
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,30798,Corporate | 2,2560,Strategic group | 3,64,Division | 4,32869,Cost center group | 5,8494,Cost center | 10,24870,Reseller |
|
CreatorRoleLevel1Description
|
Cr_Role1Desc
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRoleLevel2
|
Cr_Level2
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,30798,Corporate | 2,2560,Strategic group | 3,64,Division | 4,32869,Cost center group | 5,8494,Cost center | 10,24870,Reseller |
|
CreatorRoleLevel2Description
|
Cr_Role2Desc
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRoleLevel3
|
Cr_Level3
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,30798,Corporate | 2,2560,Strategic group | 3,64,Division | 4,32869,Cost center group | 5,8494,Cost center | 10,24870,Reseller |
|
CreatorRoleLevel3Description
|
Cr_Role3Desc
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorSecurityLevel
|
Cr_Security
|
Number
|
|
10
|
0
|
10
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with D |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
DaysBeforeDeletion
|
DaysToExpiry
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
DefaultCategory
|
DefCategory
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DefaultGroupID
|
DefGroupID
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
0,0,Attachments & notes | 1,0,Employees | 2,0,Discussions | 3,0,Management | 4,0,Policies and Procedures | 5,0,Support | 6,0,Sales | 7,0,Marketing | 9,0,Research and Development | 10,0,Finance and Administration |
|
DefaultSecurityLevel
|
DefSecurity
|
Number
|
|
10
|
0
|
10
|
|
|
|
|
|
|
|
|
|
|
|
DefaultSubCategory
|
DefSubCategory
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DeleteRights
|
DeleteRights
|
String
|
|
1
|
0
|
Y
|
|
|
|
|
|
|
|
|
|
|
Y,1014,Yes | N,1015,No | C,32890,No only creator | A,32891,No only approver |
|
Property starting with E |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
EditRights
|
EditRights
|
String
|
|
1
|
0
|
Y
|
|
|
|
|
|
|
|
|
|
|
Y,1014,Yes | I,13434,Yes check in/out | N,1015,No | C,32890,No only creator | A,32891,No only approver |
|
Property starting with F |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
FinancialOurReference
|
Fi_OurRef
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
FinancialSelection
|
Fi_Selection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
FinancialYourReference
|
Fi_YourRef
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
Property starting with G |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
GroupID
|
GroupID
|
GUID
|
|
16
|
0
|
SELECT ID FROM BacoDiscussionFixedGroups WHERE Description='Miscellaneous' AND SystemType=1
|
|
|
|
|
|
|
|
|
|
|
|
GroupName
|
GroupName
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with I |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ID
|
ID
|
Number
|
|
10
|
0
|
SELECT TypeID = CASE WHEN MAX(TypeID) IS NULL THEN 101 WHEN MAX(TypeID) > 100 THEN MAX(TypeID) + 1 END FROM BacoDiscussionFixedTypes WHERE TypeID > 100
|
|
|
|
|
|
|
|
|
|
|
|
IsSystemGenerated
|
Cr_SystemGen
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
ItemDefault
|
It_Default
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemDescription
|
It_Name
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemLabel
|
It_Label
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemSelection
|
It_Selection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemStatus
|
It_Status
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
A,2212,Active | F,2212,Active |
|
Property starting with L |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Layout
|
TemplateID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
LayoutSubject
|
TemplateSubject
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with M |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Manager
|
Manager
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ManagerFullName
|
ManagerName
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ModifiedDate
|
ModifiedDate
|
Date
|
|
0
|
0
|
Select GetDate() as ModifiedDate
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
ModifiedBy
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with P |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
Policy
|
Policy
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PolicyDescription
|
PolicyName
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ProjectDefault
|
Pr_Default
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ProjectDescription
|
Pr_Name
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ProjectSelection
|
Pr_Selection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with R |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ResourceLabel
|
Re_Label
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceSelection
|
Re_Selection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ResourceStatus
|
Re_Status
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
A,2212,Active | H,2212,Active |
|
ResourceType
|
Re_Type
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
A,35,Applicant | C,24081,Contractor | E,9551,Employee | R,24870,Reseller | S,29493,Student | T,29542,Temporary |
|
Property starting with S |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
SystemType
|
SystemType
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
Property starting with T |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
TypeDescription
|
Description
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with U |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
UseAccount
|
Ac_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UseAssortment
|
As_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UsedInStatisticReports
|
UseStatistics
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseItem
|
It_Use
|
Number
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UseOrderNumber
|
OrderNumber_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UseOwner
|
UseOwner
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UsePaymentReference
|
PaymentReference_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UseProject
|
Pr_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UseResource
|
Re_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UseSecurityApproval
|
Sec_Ap_Use
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseSerialNumber
|
It_UseNumber
|
Number
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UseShipmentMethod
|
ShipmentMethod_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UseTransaction
|
Fi_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
UseWarehouse
|
Warehouse_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
0,1015,No | 1,1014,Yes | 2,1014,Yes |
|
Property starting with V |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
VersionType
|
VersionType
|
String
|
|
1
|
0
|
N
|
|
|
|
|
|
|
|
|
|
|
N,8872,None | S,0,1 2 3 ... | U,1853,User-defined |
|