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 |
Assortment
|
Productline
|
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 |
|
AssortmentName
|
ProductlineDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with B |
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 |
BackFlushing
|
BackFlushing
|
Boolean
|
|
0
|
0
|
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 |
CompanyCode
|
Division
|
String
|
|
3
|
0
|
Company
|
|
|
|
|
|
|
|
|
|
|
|
CompanyName
|
DivisionName
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CompressionSO
|
Compression
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatedDate
|
CreatedDate
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
CreatedBy
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreatorName
|
CreatedByFullName
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CustomerCode
|
CustomerCode
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CustomerCountry
|
CustomerCountry
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CustomerID
|
CustomerID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CustomerName
|
CustomerName
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CustomerStatus
|
CustomerStatus
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CustomerType
|
CustomerType
|
String
|
|
60
|
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 |
DateFreeField1
|
DateField1
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DateFreeField2
|
DateField2
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DateFreeField3
|
DateField3
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DateFreeField4
|
DateField4
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
DateFreeField5
|
DateField5
|
Date
|
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Description
|
Description
|
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 |
EndDate
|
InitialEndDate
|
Date
|
|
8
|
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 |
ImageFileName
|
ImageFilename
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
IsBinaryServiceEnabled
|
IsBinaryServiceEnabled
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
ItemCode
|
Item
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemName
|
ItemDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with J |
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 |
JobGroup
|
JobGroup
|
Number
|
|
4
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
JobGroupName
|
JobGroupDescription
|
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 |
LinkHour
|
LinkHour
|
Boolean
|
|
0
|
0
|
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 |
Material
|
Material
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Member
|
HourMember
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
MemberCompanyCode
|
HumresCompanyCountry
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MemberCompanyName
|
HumresCompanyName
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MemberJobTitle
|
HumresJobtitle
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MemberName
|
HumresFullname
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Memo
|
Memo
|
String
|
|
8191
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
MessageID
|
MessageID
|
GUID
|
|
16
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ModifiedDate
|
ModifiedDate
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
ModifiedBy
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
ModifierName
|
ModifiedByFullName
|
String
|
|
60
|
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 |
NumberFreeField1
|
NumberField1
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField2
|
NumberField2
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField3
|
NumberField3
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField4
|
NumberField4
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
NumberFreeField5
|
NumberField5
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
ParentProject
|
ParentProject
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ParentProjectName
|
ParentProjectName
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PercentCompletion
|
PercentComplete
|
Number
|
|
16
|
4
|
|
|
|
|
|
|
|
|
|
|
|
|
ProjectCostCenter
|
Costcenter
|
String
|
|
8
|
0
|
Costcenter
|
|
|
|
|
|
|
|
|
|
|
|
ProjectCostCenterName
|
CostcenterDescription
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ProjectCostUnit
|
Costunit
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ProjectCostUnitName
|
CostUnitDesc
|
String
|
|
25
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ProjectManager
|
Responsible
|
Number
|
|
10
|
0
|
HumresID
|
|
|
|
|
|
|
|
|
|
|
|
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 |
SecurityLevel
|
Security
|
Number
|
|
10
|
0
|
10
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumber
|
SerialNumber
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberName
|
SerialNumberDescription
|
String
|
|
50
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
StartDate
|
InitialStartDate
|
Date
|
|
8
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Status
|
Status
|
String
|
|
1
|
0
|
P
|
|
|
|
|
|
|
|
|
|
|
A,2212,Active | B,1267,Blocked | C,2359,Completed | P,192,Proposed |
|
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 |
TextFreeField1
|
TextField1
|
String
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField2
|
TextField2
|
String
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField3
|
TextField3
|
String
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField4
|
TextField4
|
String
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TextFreeField5
|
TextField5
|
String
|
|
80
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
TrainingCosts
|
TrainingCosts
|
Number
|
|
17
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
TrainingQuantity
|
TrainingQuantity
|
Number
|
|
17
|
6
|
0
|
|
|
|
|
|
|
|
|
|
|
|
Type
|
Type
|
String
|
|
1
|
0
|
I
|
|
|
|
|
|
|
|
|
|
|
F,24055,Fixed | H,22171,Time & Material | I,6992,Internal | P,22069,Production | T,356,Training |
|
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 |
VisibleMember
|
VisibleMember
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
WarehouseName
|
WarehouseDesc
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
WIPMethod
|
WIPMethod
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
WorkInProgressCost
|
WorkInProgressCost
|
String
|
|
9
|
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 |
YesNoFreeField1
|
YesNoField1
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
YesNoFreeField2
|
YesNoField2
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
YesNoFreeField3
|
YesNoField3
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
YesNoFreeField4
|
YesNoField4
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
YesNoFreeField5
|
YesNoField5
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|