List of properties

Entity DocumentType
Key property ID


Property starting with A
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
AccountLabel Label Label String AccountLabel
AccountSelection Selection Selection String AccountSelection
AccountType Type Type String AccountType
Active Active Active Boolean Active
AllowApproval Approval Approval Boolean AllowApproval
AllowAttachment Attachment Attachment Boolean AllowAttachment
AllowEditSecurityLevel Security Edit Security Edit Boolean AllowEditSecurityLevel
AllowPublish Use Publish Use Publish Boolean AllowPublish
AllowRating Use Rating Use Rating Boolean AllowRating
AssortmentDefault Default Default Number AssortmentDefault

Property starting with C
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
CreatedDate Created Date Created Date Date CreatedDate
Creator Created By Created By Number Creator
CreatorRole1 Creator Role 1 Creator Role 1 Number CreatorRole1
CreatorRole2 Creator Role 2 Creator Role 2 Number CreatorRole2
CreatorRole3 Creator Role 3 Creator Role 3 Number CreatorRole3
CreatorRoleLevel1 Creator Security Level 1 Creator Security Level 1 Number CreatorRoleLevel1
CreatorRoleLevel1Description String CreatorRoleLevel1Description
CreatorRoleLevel2 Creator Security Level 2 Creator Security Level 2 Number CreatorRoleLevel2
CreatorRoleLevel2Description String CreatorRoleLevel2Description
CreatorRoleLevel3 Creator Security Level 3 Creator Security Level 3 Number CreatorRoleLevel3
CreatorRoleLevel3Description String CreatorRoleLevel3Description
CreatorSecurityLevel Security Level Security Level Number CreatorSecurityLevel

Property starting with D
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
DaysBeforeDeletion Number DaysBeforeDeletion
DefaultCategory Default Category Default Category GUID DefaultCategory
DefaultGroupID Default Main Category Default Main Category Number DefaultGroupID
DefaultSecurityLevel Default Security Default Security Number DefaultSecurityLevel
DefaultSubCategory Default Sub Category Default Sub Category GUID DefaultSubCategory
DeleteRights Delete Delete String DeleteRights

Property starting with E
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
EditRights Edit Edit String EditRights

Property starting with F
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
FinancialOurReference Our Ref. Our Ref. Number FinancialOurReference
FinancialSelection Selection Selection String FinancialSelection
FinancialYourReference Your Ref Your Ref Number FinancialYourReference

Property starting with G
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
GroupID Group Group GUID GroupID
GroupName Description Description String GroupName

Property starting with I
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
ID ID ID Number ID
IsSystemGenerated System Generate System Generate Boolean IsSystemGenerated
ItemDefault Default Default String ItemDefault
ItemDescription String ItemDescription
ItemLabel Label Label String ItemLabel
ItemSelection Selection Selection String ItemSelection
ItemStatus Status Status String ItemStatus

Property starting with L
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Layout GUID Layout
LayoutSubject String LayoutSubject

Property starting with M
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Manager Manager Manager Number Manager
ManagerFullName Manager Manager String ManagerFullName
ModifiedDate Modified Date Modified Date Date ModifiedDate
Modifier Modified By Modified By Number Modifier

Property starting with P
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Policy Policy Policy GUID Policy
PolicyDescription Policy Policy String PolicyDescription
ProjectDefault Default Default String ProjectDefault
ProjectDescription String ProjectDescription
ProjectSelection Selection Selection String ProjectSelection

Property starting with R
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
ResourceLabel Label Label String ResourceLabel
ResourceSelection Selection Selection String ResourceSelection
ResourceStatus Status Status String ResourceStatus
ResourceType Type Type String ResourceType

Property starting with S
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
SystemType System type System type Boolean SystemType

Property starting with T
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
TypeDescription Description Description String TypeDescription

Property starting with U
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
UseAccount Use Use Number UseAccount
UseAssortment Use Use Number UseAssortment
UsedInStatisticReports Use Statistics Use Statistics Boolean UsedInStatisticReports
UseItem Use Use Number UseItem
UseOrderNumber Use Use Number UseOrderNumber
UseOwner Use Owner Use Owner Boolean UseOwner
UsePaymentReference Use Use Number UsePaymentReference
UseProject Use Use Number UseProject
UseResource Use Use Number UseResource
UseSecurityApproval Boolean UseSecurityApproval
UseSerialNumber Serial Number Serial Number Number UseSerialNumber
UseShipmentMethod Use Use Number UseShipmentMethod
UseTransaction Use Use Number UseTransaction
UseWarehouse Use Use Number UseWarehouse

Property starting with V
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
VersionType Versions Versions String VersionType

Detail information of properties

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

List of obsolete properties
There is no obsolete property