List of properties

Entity ItemNumber
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
AccountCode Account Account String AccountCode
AccountGuidID Account Account GUID AccountGuidID
AccountName Account Account String AccountName
Active Active Active Boolean Active

Property starting with B
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
BatchItem Batch Batch Boolean BatchItem
Blocked Blocked Blocked Boolean Blocked

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
Classification Classification Classification String Classification
CompanyCountryCode String CompanyCountryCode
CountryCode Country Country String CountryCode
CountryDescription Country Country String CountryDescription
CountryOfAssembly Country Of Assembly Country Of Assembly String CountryOfAssembly
CreatedDate Created Created Date CreatedDate
CreateStockTransaction StockTransaction StockTransaction Boolean CreateStockTransaction
Creator Creator Creator Number Creator

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
DateEnd End date End date Date DateEnd
DateFreeField1 date date Date DateFreeField1
DateFreeField2 date date Date DateFreeField2
DateFreeField3 date date Date DateFreeField3
DateFreeField4 date date Date DateFreeField4
DateFreeField5 date date Date DateFreeField5
DateStart Start date Start date Date DateStart
Description Description Description String Description
DocumentCreatedDate Date DocumentCreatedDate
DocumentCreatedName String DocumentCreatedName
DocumentID Document Document GUID DocumentID
DocumentSubject String DocumentSubject

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 GUID ID
IsServiceItem Service Service Boolean IsServiceItem
ItemCode Item Item String ItemCode
ItemDescription Description Description String ItemDescription

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
LotNumber Lot Number Lot Number String LotNumber

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
ModifiedDate Modified Modified Date ModifiedDate
Modifier Modifier Modifier Number Modifier

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
Number Number Number String Number
NumberFreeField1 Number Number Number NumberFreeField1
NumberFreeField2 Number Number Number NumberFreeField2
NumberFreeField3 Number Number Number NumberFreeField3
NumberFreeField4 Number Number Number NumberFreeField4
NumberFreeField5 Number Number Number NumberFreeField5
NumberInBatch Batch Batch Number NumberInBatch

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
OwnerCompany Division Division String OwnerCompany
OwnerCompanyName Division Division String OwnerCompanyName

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
ParentID GUID ParentID
PreviousNumber Number Number String PreviousNumber
PurchaseCurrency Currency Currency String PurchaseCurrency
PurchasePrice Purchase price Purchase price Number PurchasePrice
PurchasePriceLocal Purchase price Purchase price Number PurchasePriceLocal

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

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
Resource Resource Resource Number Resource
ResourceName Resource Resource String ResourceName

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
Status Status Status String Status
SupplierCode Supplier Supplier GUID SupplierCode
SupplierName Supplier Supplier String SupplierName
SupplierNumber Supplier number Supplier number String SupplierNumber

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
TextFreeField1 text text String TextFreeField1
TextFreeField10 text text String TextFreeField10
TextFreeField2 text text String TextFreeField2
TextFreeField3 text text String TextFreeField3
TextFreeField4 text text String TextFreeField4
TextFreeField5 text text String TextFreeField5
TextFreeField6 text text String TextFreeField6
TextFreeField7 text text String TextFreeField7
TextFreeField8 text text String TextFreeField8
TextFreeField9 text text String TextFreeField9
Type Type Type Number Type

Property starting with W
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
Warehouse Warehouse Warehouse String Warehouse
WarehouseLocation String WarehouseLocation
WarehouseLocationName String WarehouseLocationName
WarehouseName String WarehouseName

Property starting with Y
Name Caption Description Type Mandatory Name (known in REST) Available since release Introduced by which team Introduced for which project Additional remarks
YesNoFreeField1 Yes/no Yes/no Boolean YesNoFreeField1
YesNoFreeField2 Yes/no Yes/no Boolean YesNoFreeField2
YesNoFreeField3 Yes/no Yes/no Boolean YesNoFreeField3
YesNoFreeField4 Yes/no Yes/no Boolean YesNoFreeField4
YesNoFreeField5 Yes/no Yes/no Boolean YesNoFreeField5

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 AccountCode2 String 20 0
AccountGuidID AccountCode GUID 16 0
AccountName AccountName String 50 0
Active Active Boolean 1 0 1 0 1

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
BatchItem BatchItem Boolean 1 0 0 0 1
Blocked Blocked Boolean 1 0 0 0 1

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
Classification Classification String 1 0 B
CompanyCountryCode CompanyCountryCode String 3 0 select top 1 landcode from bedryf where active = 1
CountryCode CountryCode String 3 0
CountryDescription CountryDescription String 60 0
CountryOfAssembly CountryOfAssembly String 3 0
NL,0,Netherlands
CreatedDate Created Date 0 0 NOW
CreateStockTransaction CreateStockTransaction Boolean 1 0 1 0 1
Creator Creator Number 10 0 HUMRESID

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
DateEnd DateEnd Date 8 0
DateFreeField1 UserDate_01 Date 8 0
DateFreeField2 UserDate_02 Date 8 0
DateFreeField3 UserDate_03 Date 8 0
DateFreeField4 UserDate_04 Date 8 0
DateFreeField5 UserDate_05 Date 8 0
DateStart DateStart Date 8 0 NOW
Description Description String 60 0
DocumentCreatedDate DocumentCreatedDate Date 8 0
DocumentCreatedName DocumentCreatedName String 64 0
DocumentID DocumentID GUID 16 0
DocumentSubject DocumentSubject String 255 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
IsServiceItem IsServiceItem Boolean 1 0 0 0 1
ItemCode ItemCode String 30 0
ItemDescription ItemDescription 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
LotNumber LotNumber 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
ModifiedDate Modified Date 0 0 NOW
Modifier Modifier Number 10 0 HUMRESID

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
Number Number String 20 0
NumberFreeField1 UserNumber_01 Number 8 2
NumberFreeField2 UserNumber_02 Number 8 2
NumberFreeField3 UserNumber_03 Number 8 2
NumberFreeField4 UserNumber_04 Number 8 2
NumberFreeField5 UserNumber_05 Number 8 2
NumberInBatch NumberInBatch Number 10 0 1

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
OwnerCompany OwnerCompany String 3 0
OwnerCompanyName OwnerCompanyName String 60 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
PreviousNumber PreviousNumber String 30 0
PurchaseCurrency PurchaseCurrency String 3 0 DefaultCurrency
PurchasePrice PurchasePrice Number 16 4
PurchasePriceLocal PurchasePriceLocal Number 16 4 0

Property starting with Q
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
Quantity Quantity Number 12 3 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
Resource Resource Number 10 0 HUMRESID
ResourceName ResourceName String 64 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
Status Status String 1 0 A
A,2212,Active
B,1267,Blocked
C,5639,Depreciated
D,29544,Inactive
G,29,Not validated
S,6437,Sold
SupplierCode SupplierCode GUID 16 0
SupplierName SupplierName String 50 0
SupplierNumber SupplierNumber String 6 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
TextFreeField1 UserField_01 String 255 0
TextFreeField10 UserField_10 String 255 0
TextFreeField2 UserField_02 String 255 0
TextFreeField3 UserField_03 String 255 0
TextFreeField4 UserField_04 String 255 0
TextFreeField5 UserField_05 String 255 0
TextFreeField6 UserField_06 String 255 0
TextFreeField7 UserField_07 String 255 0
TextFreeField8 UserField_08 String 255 0
TextFreeField9 UserField_09 String 255 0
Type Type Number 10 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 SELECT StringValue FROM settings WHERE SettingGroup = 'orders' AND SettingName = 'magazcode'
WarehouseLocation WarehouseLocation String 30 0
WarehouseLocationName WarehouseLocationName String 30 0
WarehouseName WarehouseName String 30 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 UserYesNo_01 Boolean 1 0 0 0 1
YesNoFreeField2 UserYesNo_02 Boolean 1 0 0 0 1
YesNoFreeField3 UserYesNo_03 Boolean 1 0 0 0 1
YesNoFreeField4 UserYesNo_04 Boolean 1 0 0 0 1
YesNoFreeField5 UserYesNo_05 Boolean 1 0 0 0 1

List of obsolete properties
There is no obsolete property