Entity | Item |
Key property | ItemCode |
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 |
Assortment | Assortment | Assortment | Number | Assortment | |||||
AssortmentCode | Assortment | Assortment | String | AssortmentCode | |||||
AssortmentDescription | Assortment | Assortment | String | AssortmentDescription | |||||
AssortmentOriginal | Number | AssortmentOriginal | |||||||
AssortmentSecurityLevel | Assortment | Assortment | Number | AssortmentSecurityLevel | |||||
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 |
Blocked | Status | Status | String | 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 |
Class01Code | Property | Property | String | Class01Code | |||||
Class02Code | Property | Property | String | Class02Code | |||||
Class03Code | Property | Property | String | Class03Code | |||||
Class04Code | Property | Property | String | Class04Code | |||||
Class05Code | Property | Property | String | Class05Code | |||||
Class06Code | Property | Property | String | Class06Code | |||||
Class07Code | Property | Property | String | Class07Code | |||||
Class08Code | Property | Property | String | Class08Code | |||||
Class09Code | Property | Property | String | Class09Code | |||||
Class10Code | Property | Property | String | Class10Code | |||||
CompanyCode | Division | Division | String |
![]() |
CompanyCode | ||||
CompanyName | String | CompanyName | |||||||
Condition | Status | Status | String | Condition | |||||
ConfigurationClass | ConfigurationClass | ConfigurationClass | String | ConfigurationClass | |||||
CostPriceCalculated | Cost price | Cost price | Number |
![]() |
CostPriceCalculated | ||||
CostPriceCalculatedManually | Cost price | Cost price | Number |
![]() |
CostPriceCalculatedManually | ||||
CostPriceCurrency | Cost price | Cost price | String |
![]() |
CostPriceCurrency | ||||
CostPriceStandard | Cost price | Cost price | Number |
![]() |
CostPriceStandard | ||||
CountingCycle | Counting cycle | Counting cycle | Number | CountingCycle | |||||
CountryCode | Country | Country | String | CountryCode | |||||
CountryDescription | Country | Country | String | CountryDescription | |||||
CountrySpecificAvailableFrom | Active from | Active from | Date |
![]() |
CountrySpecificAvailableFrom | ||||
CountrySpecificAvailableUntil | Active to | Active to | Date | CountrySpecificAvailableUntil | |||||
CountrySpecificDescription | Description | Description | String |
![]() |
CountrySpecificDescription | ||||
CountrySpecificID | GUID | CountrySpecificID | |||||||
CountrySpecificNote | Remark | Remark | String | CountrySpecificNote | |||||
CountrySpecificOwnerPerson | Resource | Resource | Number |
![]() |
CountrySpecificOwnerPerson | ||||
CreatedDate | Created | Created | Date | CreatedDate | |||||
Creator | Creator | Creator | Number | Creator | |||||
CreatorName | String | CreatorName | |||||||
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 |
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 | |||||
DeleteMode | Number | DeleteMode | |||||||
DeleteReplacement | String | DeleteReplacement | |||||||
Description0 | Description | Description | String | Description0 | |||||
Description1 | Description | Description | String | Description1 | |||||
Description2 | Description | Description | String | Description2 | |||||
Description3 | Description | Description | String | Description3 | |||||
Description4 | Description | Description | String | Description4 | |||||
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 |
ESFItemCountriesID | String | ESFItemCountriesID | |||||||
ExtraDutyVATCode | String | ExtraDutyVATCode | |||||||
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 |
GLAccountAsset | Asset account | Asset account | String | GLAccountAsset | |||||
GLAccountAssetDescription | String | GLAccountAssetDescription | |||||||
GLAccountCost | G/L Account | G/L Account | String | GLAccountCost | |||||
GLAccountCostDescription | String | GLAccountCostDescription | |||||||
GLAccountCostOld | Account costs (Old) | Account costs (Old) | String | GLAccountCostOld | |||||
GLAccountDistribution | Stock account | Stock account | String | GLAccountDistribution | |||||
GLAccountDistributionDescription | String | GLAccountDistributionDescription | |||||||
GLAccountDistributionOld | Account distribution (Old) | Account distribution (Old) | String | GLAccountDistributionOld | |||||
GLAccountRevenue | Revenue account | Revenue account | String | GLAccountRevenue | |||||
GLAccountRevenueDescription | String | GLAccountRevenueDescription | |||||||
GLAccountRevenueOld | Account revenue (Old) | Account revenue (Old) | String | GLAccountRevenueOld | |||||
GLAccountStkChange | Stock change | Stock change | String | GLAccountStkChange | |||||
GLAccountStkCoverage | Stock coverage | Stock coverage | String | GLAccountStkCoverage | |||||
GrossWeight | Number | GrossWeight | |||||||
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 |
IsAssembled | Make | Make | Boolean | IsAssembled | |||||
IsBackOrderItem | From stock | From stock | Boolean | IsBackOrderItem | |||||
IsBackToBackOrder | Buy | Buy | Boolean | IsBackToBackOrder | |||||
IsBatchItem | Batch | Batch | Boolean | IsBatchItem | |||||
IsBillableItem | Billable | Billable | Boolean | IsBillableItem | |||||
IsDiscount | No discount | No discount | Boolean | IsDiscount | |||||
IsExplode | Explode | Explode | Boolean |
![]() |
IsExplode | ||||
IsFractionAllowedItem | Divisible | Divisible | Boolean | IsFractionAllowedItem | |||||
IsPriceRegulationItem | Policy | Policy | Boolean | IsPriceRegulationItem | |||||
IsPrintItem | Boolean | IsPrintItem | |||||||
IsProductiveItem | Productive | Productive | Boolean | IsProductiveItem | |||||
IsPurchaseItem | Purchase | Purchase | Boolean |
![]() |
IsPurchaseItem | ||||
IsSalesItem | Sales | Sales | Boolean |
![]() |
IsSalesItem | ||||
IsSerialNumberItem | Serial number | Serial number | Boolean |
![]() |
IsSerialNumberItem | ||||
IsServiceItem | Service | Service | Boolean | IsServiceItem | |||||
IsStockItem | Stock controlled | Stock controlled | Boolean |
![]() |
IsStockItem | ||||
IsSubAssemblyItem | Part | Part | Boolean |
![]() |
IsSubAssemblyItem | ||||
IsTextItem | Text | Text | Boolean | IsTextItem | |||||
ItemCode | Code | Code | String |
![]() |
ItemCode | ||||
ItemGroup | String | ItemGroup | |||||||
ItemReplacementCode | Replacement | Replacement | String | ItemReplacementCode | |||||
ItemReplacementDescription | Replacement item | Replacement item | String | ItemReplacementDescription | |||||
ItemType | Type | Type | String | ItemType | |||||
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 |
LevCreditorNumber | Main supplier | Main supplier | String | LevCreditorNumber | |||||
LevelCode | Level | Level | Number | LevelCode | |||||
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 |
MessageID | MessageID | MessageID | GUID | MessageID | |||||
ModifiedDate | Modified | Modified | Date | ModifiedDate | |||||
Modifier | Modifier | Modifier | Number | Modifier | |||||
ModifierName | String | ModifierName | |||||||
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 |
NetWeight | Number |
![]() |
NetWeight | ||||||
NewCountry | Boolean | NewCountry | |||||||
NewMode | Boolean | NewMode | |||||||
NumberFreeField1 | Number | Number | Number | NumberFreeField1 | |||||
NumberFreeField10 | Number | Number | Number | NumberFreeField10 | |||||
NumberFreeField11 | Number | Number | Number | NumberFreeField11 | |||||
NumberFreeField12 | Number | Number | Number | NumberFreeField12 | |||||
NumberFreeField13 | Number | Number | Number | NumberFreeField13 | |||||
NumberFreeField2 | Number | Number | Number | NumberFreeField2 | |||||
NumberFreeField3 | Number | Number | Number | NumberFreeField3 | |||||
NumberFreeField4 | Number | Number | Number | NumberFreeField4 | |||||
NumberFreeField5 | Number | Number | Number | NumberFreeField5 | |||||
NumberFreeField6 | Number | NumberFreeField6 | |||||||
NumberFreeField7 | Free value 1 | Free value 1 | Number | NumberFreeField7 | |||||
NumberFreeField8 | Free value 2 | Free value 2 | Number | NumberFreeField8 | |||||
NumberFreeField9 | Number | Number | Number | NumberFreeField9 | |||||
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 |
OrderPolicyCode | Order Policy Code | Order Policy Code | String | OrderPolicyCode | |||||
OwnerPersonName | String | OwnerPersonName | |||||||
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 |
PackageDescription | Sales unit | Sales unit | String |
![]() |
PackageDescription | ||||
PackageDescriptionOld | Sales unit | Sales unit | String | PackageDescriptionOld | |||||
Percentage1 | Percentage 1 | Percentage 1 | Double | Percentage1 | |||||
Percentage2 | Percentage 2 | Percentage 2 | Double | Percentage2 | |||||
PeriodOrderDays | Period Order Days | Period Order Days | Number | PeriodOrderDays | |||||
PictureFilename | File | File | String | PictureFilename | |||||
PrepareDownload | PrepareDownload | PrepareDownload | Boolean | PrepareDownload | |||||
ProductLine | Product line | Product line | String | ProductLine | |||||
PurchaseRequestDescription | String | PurchaseRequestDescription | |||||||
PurchaseRequestID | GUID | PurchaseRequestID | |||||||
PurchaseRequestType | Purchase | Purchase | Number | PurchaseRequestType | |||||
PurchaseVATCode | String | PurchaseVATCode | |||||||
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 |
QuantityPerSalesPackage | Number | QuantityPerSalesPackage | |||||||
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 |
RepairAccountsNeeded | Repair needed of accounts | Repair needed of accounts | String | RepairAccountsNeeded | |||||
RepairUnitNeeded | Repair needed of unit | Repair needed of unit | String | RepairUnitNeeded | |||||
RequiresApprovedSupplier | Requires approved supplier | Requires approved supplier | Boolean |
![]() |
RequiresApprovedSupplier | ||||
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 |
SalesCurrency | Sales | Sales | String |
![]() |
SalesCurrency | ||||
SalesID | GUID | SalesID | |||||||
SalesMarginPercent | Number | SalesMarginPercent | |||||||
SalesPackagePrice | Number | SalesPackagePrice | |||||||
SalesPrice | Sales price | Sales price | Number |
![]() |
SalesPrice | ||||
SalesPriceOriginal | Number | SalesPriceOriginal | |||||||
SalesPriceType | Sales price | Sales price | Number |
![]() |
SalesPriceType | ||||
SalesRequestDescription | String | SalesRequestDescription | |||||||
SalesRequestID | GUID | SalesRequestID | |||||||
SalesRequestType | Sales | Sales | Number | SalesRequestType | |||||
SalesUnit | String | SalesUnit | |||||||
SalesValidFrom | Sales | Sales | Date | SalesValidFrom | |||||
SalesVATCode | String |
![]() |
SalesVATCode | ||||||
SalesVATCodeDescription | String | SalesVATCodeDescription | |||||||
SearchCode | String | SearchCode | |||||||
SecurityLevel | Security level | Security level | Number |
![]() |
SecurityLevel | ||||
SerialBatchItem | String | SerialBatchItem | |||||||
ShelfLife | Shelf life | Shelf life | Number | ShelfLife | |||||
StatisticalFactorPurchase | Purchase statistical factor | Purchase statistical factor | Number | StatisticalFactorPurchase | |||||
StatisticalFactorSales | Sales statistical factor | Sales statistical factor | Number | StatisticalFactorSales | |||||
StatisticalNumber | Statistical code | Statistical code | String | StatisticalNumber | |||||
StatisticalUnits | Number | StatisticalUnits | |||||||
Status | String | Status | |||||||
SyncAvailableFrom | Boolean | SyncAvailableFrom | |||||||
SyncAvailableUntil | Boolean | SyncAvailableUntil | |||||||
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 |
TaxItemClassification | TaxItemClassification | TaxItemClassification | Number | TaxItemClassification | |||||
TextDescription | String | TextDescription | |||||||
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 | String |
![]() |
Type | ||||
TypeOriginal | String | TypeOriginal | |||||||
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 |
UnitFactor1 | Factor | Factor | Number | UnitFactor1 | |||||
UnitFactor2 | Factor | Factor | Number | UnitFactor2 | |||||
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 |
ValuationMethod | ValuationMethod | ValuationMethod | String | ValuationMethod | |||||
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 | |||||
WarehouseDescription | String | WarehouseDescription | |||||||
Warranty | Warranty | Warranty | Number | Warranty | |||||
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 | |
Assortment | Assortment | Number | 10 | 0 |
![]() |
|
||||||||||||
AssortmentCode | AssortmentCode | String | 30 | 0 | ||||||||||||||
AssortmentDescription | AssortmentDescription | String | 60 | 0 | ||||||||||||||
AssortmentOriginal | AssortmentOriginal | Number | 10 | 0 | Assortment |
![]() |
||||||||||||
AssortmentSecurityLevel | AssortmentLevel | Number | 10 | 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 | |
Blocked | Blocked | String | 1 | 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 | |
Class01Code | Class_01 | String | 30 | 0 | ||||||||||||||
Class02Code | Class_02 | String | 30 | 0 | ||||||||||||||
Class03Code | Class_03 | String | 30 | 0 | ||||||||||||||
Class04Code | Class_04 | String | 30 | 0 | ||||||||||||||
Class05Code | Class_05 | String | 30 | 0 | ||||||||||||||
Class06Code | Class_06 | String | 30 | 0 | ||||||||||||||
Class07Code | Class_07 | String | 30 | 0 | ||||||||||||||
Class08Code | Class_08 | String | 30 | 0 | ||||||||||||||
Class09Code | Class_09 | String | 30 | 0 | ||||||||||||||
Class10Code | Class_10 | String | 30 | 0 | ||||||||||||||
CompanyCode | OwnerCompany | String |
![]() |
3 | 0 | Company |
![]() |
![]() |
||||||||||
CompanyName | OwnerCompanyName | String | 60 | 0 | ||||||||||||||
Condition | Condition | String | 1 | 0 | A |
|
||||||||||||
ConfigurationClass | ConfigurationClass | String | 255 | 0 | ||||||||||||||
CostPriceCalculated | CostPriceCalculated | Number |
![]() |
16 | 4 | 0 |
![]() |
|||||||||||
CostPriceCalculatedManually | CostPriceCalculatedManually | Number |
![]() |
16 | 4 | 0 |
![]() |
|||||||||||
CostPriceCurrency | CostPriceCurrency | String |
![]() |
3 | 0 |
![]() |
||||||||||||
CostPriceStandard | CostPriceStandard | Number |
![]() |
16 | 4 | 0 |
![]() |
|||||||||||
CountingCycle | CountingCycle | Number | 3 | 0 | 0 |
![]() |
![]() |
|||||||||||
CountryCode | CountryCode | String | 3 | 0 |
![]() |
|
||||||||||||
CountryDescription | CountryDescription | String | 60 | 0 | ||||||||||||||
CountrySpecificAvailableFrom | AvailableFrom | Date |
![]() |
8 | 0 | |||||||||||||
CountrySpecificAvailableUntil | AvailableUntil | Date | 8 | 0 | ||||||||||||||
CountrySpecificDescription | Description | String |
![]() |
255 | 0 | |||||||||||||
CountrySpecificID | ID | GUID | 16 | 0 | ||||||||||||||
CountrySpecificNote | Note | String | 0 | 0 | ||||||||||||||
CountrySpecificOwnerPerson | OwnerPerson | Number |
![]() |
10 | 0 | humresid |
![]() |
|||||||||||
CreatedDate | Created | Date | 0 | 0 | NOW | |||||||||||||
Creator | Creator | Number | 10 | 0 | HUMRESID |
![]() |
||||||||||||
CreatorName | CreatorName | String | 64 | 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 | 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 | ||||||||||||||
DeleteMode | DeleteMode | Number | 4 | 0 | ||||||||||||||
DeleteReplacement | DeleteReplacement | String | 30 | 0 | ||||||||||||||
Description0 | Description_0 | String | 255 | 0 | ||||||||||||||
Description1 | Description_1 | String | 60 | 0 | ||||||||||||||
Description2 | Description_2 | String | 60 | 0 | ||||||||||||||
Description3 | Description_3 | String | 60 | 0 | ||||||||||||||
Description4 | Description_4 | 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 | |
ESFItemCountriesID | ESFItemCountriesID | String | 8191 | 0 | ||||||||||||||
ExtraDutyVATCode | ExtraDutyVATCode | String | 3 | 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 | |
GLAccountAsset | GLAccountAsset | String | 9 | 0 |
![]() |
![]() |
||||||||||||
GLAccountAssetDescription | GLAccountAssetDescription | String | 60 | 0 | ||||||||||||||
GLAccountCost | GLAccountCost | String | 9 | 0 |
![]() |
![]() |
||||||||||||
GLAccountCostDescription | GLAccountCostDescription | String | 60 | 0 | ||||||||||||||
GLAccountCostOld | GLAccountCostOld | String | 9 | 0 |
![]() |
![]() |
||||||||||||
GLAccountDistribution | GLAccountDistribution | String | 9 | 0 |
![]() |
![]() |
||||||||||||
GLAccountDistributionDescription | GLAccountDistributionDescription | String | 60 | 0 | ||||||||||||||
GLAccountDistributionOld | GLAccountDistributionOld | String | 9 | 0 |
![]() |
![]() |
||||||||||||
GLAccountRevenue | GLAccountRevenue | String | 9 | 0 |
![]() |
![]() |
||||||||||||
GLAccountRevenueDescription | GLAccountRevenueDescription | String | 60 | 0 | ||||||||||||||
GLAccountRevenueOld | GLAccountRevenueOld | String | 9 | 0 |
![]() |
![]() |
||||||||||||
GLAccountStkChange | GLAccountStkChange | String | 9 | 0 |
![]() |
![]() |
||||||||||||
GLAccountStkCoverage | GLAccountStkCoverage | String | 9 | 0 |
![]() |
![]() |
||||||||||||
GrossWeight | GrossWeight | Number | 8 | 2 | 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 | |
IsAssembled | IsAssembled | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsBackOrderItem | IsBackOrderItem | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsBackToBackOrder | IsBackToBackOrder | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsBatchItem | IsBatchItem | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsBillableItem | IsBillableItem | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsDiscount | IsDiscount | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsExplode | IsExplode | Boolean |
![]() |
1 | 0 | 0 | 0 | 1 | ||||||||||
IsFractionAllowedItem | IsFractionAllowedItem | Boolean | 1 | 0 | SELECT (CASE WHEN opt_200 = 1 THEN 1 ELSE 0 END) FROM ExactOptions | 0 | 1 | |||||||||||
IsPriceRegulationItem | IsPriceRegulationItem | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsPrintItem | IsPrintItem | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsProductiveItem | IsProductiveItem | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsPurchaseItem | IsPurchaseItem | Boolean |
![]() |
1 | 0 | 0 | 0 | 1 | ||||||||||
IsSalesItem | IsSalesItem | Boolean |
![]() |
1 | 0 | 0 | 0 | 1 | ||||||||||
IsSerialNumberItem | IsSerialNumberItem | Boolean |
![]() |
1 | 0 | 0 | 0 | 1 | ||||||||||
IsServiceItem | IsServiceItem | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
IsStockItem | IsStockItem | Boolean |
![]() |
1 | 0 | 0 | 0 | 1 | ||||||||||
IsSubAssemblyItem | IsSubAssemblyItem | Boolean |
![]() |
1 | 0 | 0 | 0 | 1 | ||||||||||
IsTextItem | IsTextItem | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
ItemCode | ItemCode | String |
![]() |
30 | 0 | |||||||||||||
ItemGroup | ItemGroup | String | 4 | 0 | ||||||||||||||
ItemReplacementCode | ItemReplacementCode | String | 30 | 0 | ||||||||||||||
ItemReplacementDescription | ItemReplacementDescription | String | 60 | 0 | ||||||||||||||
ItemType | ItemType | String | 1 | 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 | |
LevCreditorNumber | lev_crdnr | String | 6 | 0 |
![]() |
![]() |
||||||||||||
LevelCode | LevelCode | Number | 4 | 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 | |
MessageID | MessageID | GUID | 16 | 0 | ||||||||||||||
ModifiedDate | Modified | Date | 0 | 0 | NOW | |||||||||||||
Modifier | Modifier | Number | 10 | 0 | HUMRESID |
![]() |
||||||||||||
ModifierName | ModifierName | 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 | |
NetWeight | NetWeight | Number |
![]() |
8 | 2 | 0 |
![]() |
![]() |
||||||||||
NewCountry | NewCountry | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
NewMode | NewMode | Boolean | 1 | 0 | 1 | 0 | 1 | |||||||||||
NumberFreeField1 | UserNumber_01 | Number | 8 | 2 |
![]() |
|||||||||||||
NumberFreeField10 | UserNumber_10 | Number | 8 | 2 |
![]() |
|||||||||||||
NumberFreeField11 | UserNumber_11 | Number | 8 | 2 |
![]() |
|||||||||||||
NumberFreeField12 | UserNumber_12 | Number | 8 | 2 |
![]() |
|||||||||||||
NumberFreeField13 | UserNumber_13 | 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 |
![]() |
|||||||||||||
NumberFreeField6 | UserNumber_06 | Number | 8 | 2 |
![]() |
|||||||||||||
NumberFreeField7 | UserNumber_07 | Number | 8 | 2 |
![]() |
|||||||||||||
NumberFreeField8 | UserNumber_08 | Number | 8 | 2 |
![]() |
|||||||||||||
NumberFreeField9 | UserNumber_09 | Number | 8 | 2 |
![]() |
|||||||||||||
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 | |
OrderPolicyCode | OrderPolicyCode | String | 1 | 0 | ||||||||||||||
OwnerPersonName | OwnerPersonName | String | 64 | 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 | |
PackageDescription | PackageDescription | String |
![]() |
8 | 0 | - | ||||||||||||
PackageDescriptionOld | PackageDescriptionOld | String | 8 | 0 | ||||||||||||||
Percentage1 | Percentage_1 | Double | 10 | 2 | 0 | 0 | 1 | |||||||||||
Percentage2 | Percentage_2 | Double | 10 | 2 | 0 | 0 | 1 | |||||||||||
PeriodOrderDays | PeriodOrderDays | Number | 3 | 0 | 0 |
![]() |
![]() |
|||||||||||
PictureFilename | PictureFilename | String | 128 | 0 | ||||||||||||||
PrepareDownload | PrepareDownload | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
ProductLine | ProductLine | String | 1 | 0 | G |
|
||||||||||||
PurchaseRequestDescription | PurchaseRequestDescription | String | 60 | 0 | ||||||||||||||
PurchaseRequestID | PurchaseRequestID | GUID | 16 | 0 | ||||||||||||||
PurchaseRequestType | PurchaseRequestType | Number | 10 | 0 | ||||||||||||||
PurchaseVATCode | PurchaseVATCode | String | 3 | 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 | |
QuantityPerSalesPackage | aant_verp | Number | 8 | 2 | 1 |
![]() |
![]() |
|||||||||||
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 | |
RepairAccountsNeeded | RepairAccountsNeeded | String | 1 | 0 | ||||||||||||||
RepairUnitNeeded | RepairUnitNeeded | String | 1 | 0 | ||||||||||||||
RequiresApprovedSupplier | RequiresApprovedSupplier | Boolean |
![]() |
1 | 0 | 0 | 0 | 1 | ||||||||||
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 | |
SalesCurrency | SalesCurrency | String |
![]() |
3 | 0 |
![]() |
||||||||||||
SalesID | SalesID | GUID | 16 | 0 | ||||||||||||||
SalesMarginPercent | SalesMarginPercent | Number | 8 | 2 | 0 |
![]() |
![]() |
|||||||||||
SalesPackagePrice | SalesPackagePrice | Number | 16 | 4 | SalesPrice |
![]() |
||||||||||||
SalesPrice | SalesPrice | Number |
![]() |
16 | 4 | 0 |
![]() |
|||||||||||
SalesPriceOriginal | SalesPriceOriginal | Number | 16 | 4 | SalesPrice |
![]() |
||||||||||||
SalesPriceType | SalesPriceType | Number |
![]() |
4 | 0 |
|
||||||||||||
SalesRequestDescription | SalesRequestDescription | String | 60 | 0 | ||||||||||||||
SalesRequestID | SalesRequestID | GUID | 16 | 0 | ||||||||||||||
SalesRequestType | SalesRequestType | Number | 10 | 0 | ||||||||||||||
SalesUnit | eenh_verk | String | 5 | 0 | ||||||||||||||
SalesValidFrom | SalesValidFrom | Date | 8 | 0 | ||||||||||||||
SalesVATCode | SalesVATCode | String |
![]() |
3 | 0 | 0 |
![]() |
|||||||||||
SalesVATCodeDescription | SalesVATCodeDescription | String | 30 | 0 | ||||||||||||||
SearchCode | SearchCode | String | 13 | 0 | ItemCode | |||||||||||||
SecurityLevel | SecurityLevel | Number |
![]() |
10 | 0 | |||||||||||||
SerialBatchItem | SerialBatchItem | String | 1 | 0 | ||||||||||||||
ShelfLife | Shelflife | Number | 3 | 0 | 0 |
![]() |
![]() |
|||||||||||
StatisticalFactorPurchase | StatisticalFactorPurchase | Number | 11 | 2 | 1 |
![]() |
![]() |
|||||||||||
StatisticalFactorSales | StatisticalFactorSales | Number | 11 | 2 | 1 |
![]() |
![]() |
|||||||||||
StatisticalNumber | StatisticalNumber | String | 9 | 0 |
![]() |
![]() |
||||||||||||
StatisticalUnits | StatisticalUnits | Number | 8 | 2 | 0 |
![]() |
![]() |
|||||||||||
Status | Status | String | 1 | 0 | ||||||||||||||
SyncAvailableFrom | SyncAvailableFrom | Boolean | 1 | 0 | 0 | 0 | 1 | |||||||||||
SyncAvailableUntil | SyncAvailableUntil | 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 | |
TaxItemClassification | TaxItemClassification | Number | 8 | 0 | 0 |
![]() |
||||||||||||
TextDescription | TextDescription | String | 8191 | 0 | ||||||||||||||
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 | String |
![]() |
1 | 0 | S |
![]() |
|
||||||||||
TypeOriginal | TypeOriginal | String | 1 | 0 | Type |
![]() |
||||||||||||
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 | |
UnitFactor1 | UnitFactor1 | Number | 12 | 3 | 1.000 | |||||||||||||
UnitFactor2 | UnitFactor2 | Number | 12 | 3 | 1.000 | |||||||||||||
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 | |
ValuationMethod | ValuationMethod | String | 1 | 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 | ||||||||||||||
WarehouseDescription | WarehouseDescription | String | 30 | 0 | ||||||||||||||
Warranty | Warranty | Number | 3 | 0 | 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 |