Entity Document
Key property ID


Property starting with A
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
AccountCode AssociateCode AssociateCode String
AccountContactEmail Account Contact Email Account Contact Email String
AccountContactID AccContactID AccContactID GUID
AccountContactName AccContactName AccContactName String
AccountEmail Associate Email Associate Email String
AccountID Associate Associate GUID
AccountName Associate name Associate name String
AllowPublish Allow publish Allow publish Boolean
AllowReplies Allow replies Allow replies Boolean
Assortment Product line Product line Number

Property starting with C
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Category Category Category String
CategoryID GUID
CheckedOut Checked Out Checked Out Date
CheckedOutBy Checked Out By Checked Out By Number
CheckedOutByName Checked Out By Checked Out By String
CompanyCode Company Company String
CompanyName Company name Company name String
CreatedDate Created date Created date Date
Creator Created by Created by String
CreatorName Created by fullname Created by fullname String
CreditorNumber String

Property starting with D
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
DebtorNumber String
Description Product line name Product line name String

Property starting with E
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
EntryKey Transaction Transaction GUID
ExpiryDate Date

Property starting with F
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
FileName File name File name String
FrontPageIntroText String

Property starting with G
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
GroupID Group id Group id Number
GroupName Group name Group name String
GroupTemplate GroupTemplate GroupTemplate GUID

Property starting with H
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
HID HID HID Number

Property starting with I
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ID ID ID GUID
IsBinaryServiceEnabled Boolean
IsMailMerge IsMailMerge IsMailMerge Boolean
IsTemplate Template Template Boolean
ItemCode Item code Item code String
ItemName Item name Item name String
ItemSerialNumber ItemSerialNumber ItemSerialNumber GUID
ItemSerialNumberCode ItemSerialNumberCode ItemSerialNumberCode String
ItemSerialNumberName ItemSerialNumberDesc ItemSerialNumberDesc String

Property starting with L
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
LanguageID Language Language String
LanguageName Language name Language name String

Property starting with M
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
MessageIDBody GUID
MessageIDDocument GUID
ModifiedDate Modified date Modified date Date
Modifier Modified by Modified by String
ModifierName Modified by fullname Modified by fullname String

Property starting with N
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
NeedsApproval Needs approval Needs approval Boolean
NewsType Publish as Publish as Number
Note String

Property starting with O
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
OrderNumber Order number Order number String
OurRef Our ref. Our ref. String
Owner Owner Owner Number
OwnerName OwnerFullname OwnerFullname String
OwnerType Owner Type Owner Type Number
OwnerTypeValue Owner Type Value Owner Type Value String

Property starting with P
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ParentID Parent ID Parent ID GUID
PaymentReference String
PersonEmail Person Email Person Email String
PersonID Person Person Number
PersonName Person name Person name String
ProductReleaseOn Release from Release from String
ProjectCompanyCode Division Division String
ProjectDescription Description Description String
ProjectNumber ProjectNr ProjectNr String

Property starting with S
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Security Security Security Boolean
SecurityLevel Security level Security level Number
ShipmentMethod String
Source String
Status Status Status Number
StatusText Status text Status text String
SubCategory sub-category sub-category String
Subject Subject Subject String

Property starting with T
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Type Type Type Number
TypeAccountLabel Account Label Account Label String
TypeAccountSelection Account Selection Account Selection String
TypeAccountType Account Type Account Type String
TypeAllowAttachment Attachment Attachment Number
TypeDaysToExpiry Number
TypeDefSecurity default security default security Number
TypeDeleteRights String
TypeEditRights String
TypeEditSecurity Edit Security Edit Security Number
TypeFinanceSelection Finance Selection Finance Selection String
TypeItemLabel Item Label Item Label String
TypeItemSelection Item Selection Item Selection String
TypeItemStatus Item Status Item Status String
TypeName Description Description String
TypeProjectSelection Project Selection Project Selection String
TypeResourceLabel Resource Label Resource Label String
TypeResourceSelection Resource Selection Resource Selection String
TypeResourceStatus Resource Status Resource Status String
TypeResourceType Resource Type Resource Type String
TypeTemplate TypeTemplate TypeTemplate GUID
TypeUseAccount Use Account Use Account Number
TypeUseApprove Approve Approve Number
TypeUseAssortment Use Assortment Use Assortment Number
TypeUseFinance Use Finance Use Finance Number
TypeUseItem Use Item Use Item Number
TypeUseItemSerialNumber TypeUseItemSerialNumber TypeUseItemSerialNumber Number
TypeUseOrderNumber Number
TypeUseOurReference Number
TypeUseOwner Use Owner Use Owner Number
TypeUsePaymentReference Number
TypeUseProject Use Project Use Project Number
TypeUsePublish Use Project Use Project Number
TypeUseRating Use Rating Use Rating Number
TypeUseResource Use Resource Use Resource Number
TypeUseShipmentMethod Number
TypeUseWarehouse Number
TypeUseYourReference Number
TypeVersionType String

Property starting with U
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
UseAssociate Use associate Use associate Number
UseClass Use class 01 Use class 01 Number
UseCompany Use company Use company Number
UseEntryKey UseEntryKey UseEntryKey Number
UseItem Use item Use item Number
UseItemSerialNumber UseItemSerialNumber UseItemSerialNumber Number
UseLanguage Use language Use language Number
UsePerson Use person Use person Number
UseProjectNumber UseProjectNr UseProjectNr Number

Property starting with V
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Version Version Version String
VersionActivate Boolean
VersionCheckedOut Checked Out Checked Out Date
VersionCheckedOutBy Checked Out By Checked Out By Number
VersionCheckedOutByName Checked Out By Checked Out By String
VersionCreatedBy String
VersionCreatedDate Date
VersionFilename String
VersionFPIntroText String
VersionHID Number
VersionID GUID
VersionModifiedBy String
VersionModifiedDate Date
VersionNote String
VersionStartDate Date
VersionStatus Number
VersionStatusText String
VersionSubject String
VersionToDealWith String
ViewDate View Date View Date Date

Property starting with W
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Warehouse Warehouse Warehouse String

Property starting with Y
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
YourRef Your ref. Your ref. String

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
AccountCode AssociatCode String 20 0
AccountContactEmail AccContactEmail String 128 0
AccountContactID AccContactID GUID 16 0
AccountContactName AccContactName String 128 0
AccountEmail AssociateEmail String 128 0
AccountID Associate GUID 16 0
AccountName AssociateName String 50 0
AllowPublish AllowPublish Boolean 1 0 0 0 1
AllowReplies AllowReplies Boolean 1 0 0 0 1
Assortment Class_01 Number 10 0

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
Category Category String 30 0
CategoryID CategoryID GUID 16 0
CheckedOut CheckedOut Date 0 0
CheckedOutBy CheckedOutBy Number 10 0
CheckedOutByName CheckedOutByName String 64 0
CompanyCode Company String 3 0
CompanyName CompanyName String 60 0
CreatedDate CreatedDate Date 0 0 NOW
Creator CreatedBy String 30 0
CreatorName CreatedByFullname String 64 0
CreditorNumber CreditorNumber String 6 0

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
DebtorNumber DebtorNumber String 6 0
Description Class_01Name String 60 0

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
EntryKey EntryKey GUID 16 0
ExpiryDate ExpiryDate Date 0 0

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
FileName FileName String 128 0
FrontPageIntroText FPIntroText String 200 0

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 Group Number 10 0
GroupName GroupName String 60 0
GroupTemplate GroupTemplate GUID 16 0

Property starting with H
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
HID HID Number 10 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 GUID 16 0
IsBinaryServiceEnabled IsBinaryServiceEnabled Boolean 1 0 0 0 1
IsMailMerge IsMailMerge Boolean 1 0 0 0 1
IsTemplate IsTemplate Boolean 1 0 0 0 1
ItemCode Item String 30 0
ItemName ItemName String 60 0
ItemSerialNumber ItemSerialNumber GUID 16 0
ItemSerialNumberCode ItemSerialNumbeCode String 30 0
ItemSerialNumberName ItemSerialNumberName String 60 0

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
LanguageID Language String 3 0
LanguageName LanguageName String 30 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
MessageIDBody MessageID_body GUID 16 0
MessageIDDocument MessageID_document GUID 16 0
ModifiedDate ModifiedDate Date 0 0 Select GetDate() as ModifiedDate
Modifier ModifiedBy String 30 0
ModifierName ModifiedByFullName 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
NeedsApproval NeedsApproval Boolean 1 0 0 0 1
NewsType NewsType Number 10 0 0
0,0,Normal
1,0,Frontpage
2,0,Headline
Note Note String 8191 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
OrderNumber OrderNumber String 8 0
OurRef OurRef String 8 0
Owner Owner Number 10 0
OwnerName OwnerFullname String 64 0
OwnerType OwnerType Number 1 0 0
OwnerTypeValue OwnerTypeValue String 50 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
ParentID ParentID GUID 16 0
PaymentReference PaymentReference String 8191 0
PersonEmail PersonEmail String 128 0
PersonID Person Number 10 0
PersonName PersonName String 64 0
ProductReleaseOn Class_02_1 String 30 0
ProjectCompanyCode ProjectNrDiv String 3 0
ProjectDescription ProjectDescription String 60 0
ProjectNumber ProjectNr String 20 0

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
Security Security Boolean 1 0 0 0 1
SecurityLevel SecurityLevel Number 10 0 0
ShipmentMethod ShipmentMethod String 3 0
Source Source String 1 0 S
S,14015,Generated
I,8644,Input
O,8888,Output
Status Status Number 10 0
StatusText StatusText String 1 0
SubCategory SubCategory String 30 0
Subject Subject String 255 0

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
Type Type Number 10 0 0
TypeAccountLabel TypeAccountLabel String 255 0
TypeAccountSelection TypeAccountSelection String 255 0
TypeAccountType TypeAccountType String 1 0
TypeAllowAttachment TypeAllowAttachment Number 1 0
TypeDaysToExpiry TypeDaysToExpiry Number 1 0
TypeDefSecurity TypeDefSecurity Number 2 0
TypeDeleteRights TypeDeleteRights String 1 0
TypeEditRights TypeEditRights String 1 0
TypeEditSecurity TypeEditSecurity Number 1 0
TypeFinanceSelection TypeFinanceSelection String 255 0
TypeItemLabel TypeItemLabel String 255 0
TypeItemSelection TypeItemSelection String 255 0
TypeItemStatus TypeItemStatus String 1 0
TypeName TypeName String 30 0
TypeProjectSelection TypeProjectSelection String 255 0
TypeResourceLabel TypeResourceLabel String 255 0
TypeResourceSelection TypeResourceSelection String 255 0
TypeResourceStatus TypeResourceStatus String 1 0
TypeResourceType TypeResourceType String 1 0
TypeTemplate TypeTemplate GUID 16 0
TypeUseAccount TypeUseAccount Number 1 0
TypeUseApprove TypeUseApprove Number 1 0
TypeUseAssortment TypeUseAssortment Number 1 0
TypeUseFinance TypeUseFinance Number 1 0
TypeUseItem TypeUseItem Number 1 0
TypeUseItemSerialNumber TypeUseItemSerialNumber Number 1 0
TypeUseOrderNumber TypeUseOrderNumber Number 1 0
TypeUseOurReference TypeUseOurRef Number 1 0
TypeUseOwner TypeUseOwner Number 1 0
TypeUsePaymentReference TypeUsePaymentReference Number 1 0
TypeUseProject TypeUseProject Number 1 0
TypeUsePublish TypeUsePublish Number 1 0
TypeUseRating TypeUseRating Number 1 0
TypeUseResource TypeUseResource Number 1 0
TypeUseShipmentMethod TypeUseShipmentMethod Number 1 0
TypeUseWarehouse TypeUseWarehouse Number 1 0
TypeUseYourReference TypeUseYourRef Number 1 0
TypeVersionType TypeVersionType String 1 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
UseAssociate UseAssociate Number 10 0
UseClass UseClass_01 Number 10 0
UseCompany UseCompany Number 10 0
UseEntryKey UseEntryKey Number 1 0
UseItem UseItem Number 10 0
UseItemSerialNumber UseItemSerialNumber Number 10 0
UseLanguage UseLanguage Number 10 0
UsePerson UsePerson Number 10 0
UseProjectNumber UseProjectNr Number 1 0

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
Version Version String 20 0
VersionActivate VersionActivate Boolean 1 0 0 0 1
VersionCheckedOut VersionCheckedOut Date 0 0
VersionCheckedOutBy VersionCheckedOutBy Number 10 0
VersionCheckedOutByName VersionCheckedOutByName String 64 0
VersionCreatedBy VersionCreatedBy String 30 0 HumresID
VersionCreatedDate VersionCreatedDate Date 0 0
VersionFilename VersionFilename String 128 0
VersionFPIntroText VersionFPIntroText String 200 0
VersionHID VersionHID Number 10 0
VersionID VersionID GUID 16 0
VersionModifiedBy VersionModifiedBy String 30 0 HumresID
VersionModifiedDate VersionModifiedDate Date 0 0
VersionNote VersionNote String 8191 0
VersionStartDate VersionStartDate Date 0 0 NOW
VersionStatus VersionStatus Number 10 0
VersionStatusText VersionStatusText String 1 0
VersionSubject VersionSubject String 255 0
VersionToDealWith VersionToDealWith String 20 0
ViewDate ViewDate Date 0 0 Select GetDate() as ViewDate

Property starting with W
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
Warehouse Warehouse String 4 0

Property starting with Y
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
YourRef YourRef String 40 0