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
|
|
|
|
|
ActionOldMajorVersion
|
Action on old major version.
|
Action on old major version.
|
String
|
|
ActionOldMajorVersion
|
|
|
|
|
Active
|
Active
|
Active
|
Boolean
|
|
Active
|
|
|
|
|
AllowApproval
|
Approval
|
Approval
|
Boolean
|
|
AllowApproval
|
|
|
|
|
AllowAttachment
|
Attachment
|
Attachment
|
Boolean
|
|
AllowAttachment
|
|
|
|
|
AllowCheckoutDays
|
Maximum days of check out allowed.
|
Maximum days of check out allowed.
|
Number
|
|
AllowCheckoutDays
|
|
|
|
|
AllowEditSecurityLevel
|
Security Edit
|
Security Edit
|
Boolean
|
|
AllowEditSecurityLevel
|
|
|
|
|
AllowPublish
|
Use Publish
|
Use Publish
|
Boolean
|
|
AllowPublish
|
|
|
|
|
AllowRating
|
Use Rating
|
Use Rating
|
Boolean
|
|
AllowRating
|
|
|
|
|
AllowReplies
|
Allow replies
|
Allow replies
|
Boolean
|
|
AllowReplies
|
|
|
|
|
AllowScripting
|
Allow scripting
|
Allow scripting
|
Boolean
|
|
AllowScripting
|
|
|
|
|
ApplicationID
|
|
|
GUID
|
|
ApplicationID
|
|
|
|
|
ApprovalRole
|
Document approval role
|
Document approval role
|
Number
|
|
ApprovalRole
|
|
|
|
|
ApprovalRoleLevel
|
Approval role level
|
Approval role level
|
Number
|
|
ApprovalRoleLevel
|
|
|
|
|
ApprovalRoleReferencePoint
|
Approval role reference point
|
Approval role reference point
|
String
|
|
ApprovalRoleReferencePoint
|
|
|
|
|
ArchiveDays
|
Scheduled for archiving
|
Scheduled for archiving
|
Number
|
|
ArchiveDays
|
|
|
|
|
ArchiveMethods
|
Archiving method
|
Archiving method
|
String
|
|
ArchiveMethods
|
|
|
|
|
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
|
|
|
|
|
CreatorFullName
|
|
|
String
|
|
CreatorFullName
|
|
|
|
|
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
|
Scheduled for deletion
|
Scheduled for deletion
|
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
|
|
|
|
|
DefaultSecurityLevelTo
|
Upper range of the security level
|
Upper range of the security level
|
Number
|
|
DefaultSecurityLevelTo
|
|
|
|
|
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
|
|
|
|
|
EditRightsOwner
|
Owner edit rights
|
Owner edit rights
|
Number
|
|
EditRightsOwner
|
|
|
|
|
EditRightsType
|
Document editing rights type.
|
Document editing rights type.
|
Number
|
|
EditRightsType
|
|
|
|
|
EditRightsTypeValue
|
Editing rights type value
|
Editing rights type value
|
String
|
|
EditRightsTypeValue
|
|
|
|
|
EditRightTypeRoleLevel
|
Role level
|
Role level
|
Number
|
|
EditRightTypeRoleLevel
|
|
|
|
|
EditRightTypeRoleReferencePoint
|
Edit rights role reference point
|
Edit rights role reference point
|
String
|
|
EditRightTypeRoleReferencePoint
|
|
|
|
|
EditViewRights
|
|
|
Boolean
|
|
EditViewRights
|
|
|
|
|
EnableTagging
|
Allow tagging
|
Allow tagging
|
Boolean
|
|
EnableTagging
|
|
|
|
|
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
|
|
|
|
|
FullText
|
|
|
Number
|
|
FullText
|
|
|
|
|
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
|
|
|
|
|
ManualEntry
|
Usage mode
|
Usage mode
|
String
|
|
ManualEntry
|
|
|
|
|
ModifiedDate
|
Modified Date
|
Modified Date
|
Date
|
|
ModifiedDate
|
|
|
|
|
Modifier
|
Modified By
|
Modified By
|
Number
|
|
Modifier
|
|
|
|
|
ModifierFullName
|
|
|
String
|
|
ModifierFullName
|
|
|
|
|
Property starting with N |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
NumberMajorVersionAllow
|
Maximum number of major version allowed
|
Maximum number of major version allowed
|
Number
|
|
NumberMajorVersionAllow
|
|
|
|
|
Property starting with O |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
OpportunityDefault
|
Default
|
Default
|
Number
|
|
OpportunityDefault
|
|
|
|
|
OpportunityDescription
|
|
|
String
|
|
OpportunityDescription
|
|
|
|
|
OpportunitySelection
|
Selection
|
Selection
|
String
|
|
OpportunitySelection
|
|
|
|
|
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 |
ShowEditRightsInformation
|
Show document viewing and editing details
|
Show document viewing and editing details
|
Boolean
|
|
ShowEditRightsInformation
|
|
|
|
|
SMS_Config_Code
|
|
|
String
|
|
SMS_Config_Code
|
|
|
|
|
Sms_Config_Default
|
Default
|
Default
|
GUID
|
|
Sms_Config_Default
|
|
|
|
|
Sms_Config_Selection
|
Selection
|
Selection
|
String
|
|
Sms_Config_Selection
|
|
|
|
|
Sms_Config_Use
|
Use
|
Use
|
Number
|
|
Sms_Config_Use
|
|
|
|
|
Sms_Contract_Default
|
Default
|
Default
|
GUID
|
|
Sms_Contract_Default
|
|
|
|
|
SMS_Contract_Number
|
|
|
String
|
|
SMS_Contract_Number
|
|
|
|
|
Sms_Contract_Selection
|
Selection
|
Selection
|
String
|
|
Sms_Contract_Selection
|
|
|
|
|
Sms_Contract_Use
|
Use
|
Use
|
Number
|
|
Sms_Contract_Use
|
|
|
|
|
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
|
|
|
|
|
UseCompany
|
Division
|
Division
|
Number
|
|
UseCompany
|
|
|
|
|
UsedInStatisticReports
|
Use Statistics
|
Use Statistics
|
Boolean
|
|
UsedInStatisticReports
|
|
|
|
|
UseItem
|
Use
|
Use
|
Number
|
|
UseItem
|
|
|
|
|
UseLanguageID
|
Language
|
Language
|
Number
|
|
UseLanguageID
|
|
|
|
|
UseOpportunity
|
Use
|
Use
|
Number
|
|
UseOpportunity
|
|
|
|
|
UseOrderNumber
|
Use
|
Use
|
Number
|
|
UseOrderNumber
|
|
|
|
|
UseOwner
|
Use Owner
|
Use Owner
|
Boolean
|
|
UseOwner
|
|
|
|
|
UsePaymentReference
|
Use
|
Use
|
Number
|
|
UsePaymentReference
|
|
|
|
|
UseProject
|
Use
|
Use
|
Number
|
|
UseProject
|
|
|
|
|
UseReports
|
Use reports
|
Use reports
|
Boolean
|
|
UseReports
|
|
|
|
|
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
|
|
|
|
|
UseVote
|
Allow Voting
|
Allow Voting
|
Boolean
|
|
UseVote
|
|
|
|
|
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
|
|
|
|
|
ViewRightsOwner
|
Owner view rights
|
Owner view rights
|
Number
|
|
ViewRightsOwner
|
|
|
|
|
ViewRightsType
|
Document viewing rights type.
|
Document viewing rights type.
|
Number
|
|
ViewRightsType
|
|
|
|
|
ViewRightsTypeValue
|
Viewing rights type value
|
Viewing rights type value
|
String
|
|
ViewRightsTypeValue
|
|
|
|
|
ViewRightTypeRoleLevel
|
Role level
|
Role level
|
Number
|
|
ViewRightTypeRoleLevel
|
|
|
|
|
ViewRightTypeRoleReferencePoint
|
View rights role reference point
|
View rights role reference point
|
String
|
|
ViewRightTypeRoleReferencePoint
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ActionOldMajorVersion
|
ActionOldMajorVersion
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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
|
|
|
|
|
|
|
|
|
|
AllowCheckoutDays
|
AllowCheckoutDays
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
AllowEditSecurityLevel
|
EditSecurity
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowPublish
|
UsePublish
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowRating
|
UseRating
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowReplies
|
AllowReplies
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowScripting
|
AllowScripting
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
ApplicationID
|
ApplicationID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ApprovalRole
|
ApprovalRole
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ApprovalRoleLevel
|
ApprovalRoleLevel
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ApprovalRoleReferencePoint
|
ApprovalRoleRefPoint
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ArchiveDays
|
ArchiveDays
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ArchiveMethods
|
ArchiveMethods
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
AssortmentDefault
|
As_Default
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
CreatorFullName
|
Creator
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRole1
|
Cr_Role1
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRole2
|
Cr_Role2
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRole3
|
Cr_Role3
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRoleLevel1
|
Cr_Level1
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CreatorRoleLevel1Description
|
Cr_Role1Desc
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRoleLevel2
|
Cr_Level2
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
CreatorRoleLevel2Description
|
Cr_Role2Desc
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatorRoleLevel3
|
Cr_Level3
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
DefaultSecurityLevel
|
DefSecurity
|
Number
|
|
10
|
0
|
10
|
|
|
|
|
|
|
|
|
|
|
|
DefaultSecurityLevelTo
|
DefSecurityTo
|
Number
|
|
10
|
0
|
DefSecurity
|
|
|
|
|
|
|
|
|
|
|
|
DefaultSubCategory
|
DefSubCategory
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DeleteRights
|
DeleteRights
|
String
|
|
1
|
0
|
Y
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
EditRightsOwner
|
EditRightsOwner
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
EditRightsType
|
EditRightsType
|
Number
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
EditRightsTypeValue
|
EditRightsTypeValue
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
EditRightTypeRoleLevel
|
EditRightTypeRoleLevel
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
EditRightTypeRoleReferencePoint
|
EditRightTypeRoleRefPoint
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
EditViewRights
|
EditViewRights
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
EnableTagging
|
EnableTagging
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
FinancialSelection
|
Fi_Selection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
FinancialYourReference
|
Fi_YourRef
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
FullText
|
FullText
|
Number
|
|
2
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
ManualEntry
|
BlockHiddenManEntry
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ModifiedDate
|
ModifiedDate
|
Date
|
|
0
|
0
|
Select GetDate() as ModifiedDate
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
ModifiedBy
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
ModifierFullName
|
Modifier
|
String
|
|
64
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with N |
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 |
NumberMajorVersionAllow
|
NumMajorVersionAllow
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with O |
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 |
OpportunityDefault
|
Opportunity_Default
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
OpportunityDescription
|
Opportunity_Name
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
OpportunitySelection
|
Opportunity_Selection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ResourceType
|
Re_Type
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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 |
ShowEditRightsInformation
|
ShowEditRightsInfo
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
SMS_Config_Code
|
SMS_Config_Code
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Sms_Config_Default
|
Sms_Config_Default
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Sms_Config_Selection
|
Sms_Config_Selection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Sms_Config_Use
|
Sms_Config_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
Sms_Contract_Default
|
Sms_Contract_Default
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SMS_Contract_Number
|
SMS_Contract_Number
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Sms_Contract_Selection
|
Sms_Contract_Selection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Sms_Contract_Use
|
Sms_Contract_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseAssortment
|
As_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseCompany
|
UseCompany
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UsedInStatisticReports
|
UseStatistics
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseItem
|
It_Use
|
Number
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseLanguageID
|
UseLanguageID
|
Number
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseOpportunity
|
Opportunity_Use
|
Number
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseOrderNumber
|
OrderNumber_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseOwner
|
UseOwner
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UsePaymentReference
|
PaymentReference_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseProject
|
Pr_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseReports
|
UseReports
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseResource
|
Re_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseSecurityApproval
|
Sec_Ap_Use
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseSerialNumber
|
It_UseNumber
|
Number
|
|
2
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseShipmentMethod
|
ShipmentMethod_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseTransaction
|
Fi_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
UseVote
|
UseVote
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseWarehouse
|
Warehouse_Use
|
Number
|
|
10
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
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
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ViewRightsOwner
|
ViewRightsOwner
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ViewRightsType
|
ViewRightsType
|
Number
|
|
1
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
ViewRightsTypeValue
|
ViewRightsTypeValue
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ViewRightTypeRoleLevel
|
ViewRightTypeRoleLevel
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|
ViewRightTypeRoleReferencePoint
|
ViewRightTypeRoleRefPoint
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Exact.Repository.ERSelectionValue |
|