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 |
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 |
![]() |
|
|||||||||||||||||
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 |
|
|||||||||||||||||
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 |