| 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 | |||||
| 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 | |||||||
| 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 |
|
60 | 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 | 60 | 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 | |||||||||||
| 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 | |||||||||||
| 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 | ||||||||||