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 |
AddExtraReceiptToOrder
|
Add extra receipt to sales order
|
Add extra receipt to sales order
|
Boolean
|
|
AddExtraReceiptToOrder
|
|
|
|
|
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
|
|
|
|
|
CommissionMethod
|
Commission method
|
Commission method
|
String
|
|
CommissionMethod
|
|
|
|
|
CommissionValue
|
Commission value
|
Commission value
|
Number
|
|
CommissionValue
|
|
|
|
|
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 |
ESFCountryDescLeading
|
|
|
Boolean
|
|
ESFCountryDescLeading
|
|
|
|
|
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
|
|
|
|
|
GLAccountDiscount
|
Discount
|
Discount
|
String
|
|
GLAccountDiscount
|
|
|
|
|
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
|
|
|
|
|
GTIN
|
GTIN
|
GTIN
|
String
|
|
GTIN
|
405
|
CMDM
|
EDI
|
|
Property starting with H |
Name |
Caption |
Description |
Type |
Mandatory |
Name (known in REST) |
Available since release |
Introduced by which team |
Introduced for which project |
Additional remarks |
HTSCode
|
HTS code
|
HTS code
|
String
|
|
HTSCode
|
|
|
|
|
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 |
IncrementFactor
|
|
|
Number
|
|
IncrementFactor
|
|
|
|
|
IsAssembled
|
Make
|
Make
|
Boolean
|
|
IsAssembled
|
|
|
|
|
IsBackOrderItem
|
From stock
|
From stock
|
Boolean
|
|
IsBackOrderItem
|
|
|
|
|
IsBackToBackOrder
|
Buy
|
Buy
|
Boolean
|
|
IsBackToBackOrder
|
|
|
|
|
IsBatchItem
|
Batch
|
Batch
|
Boolean
|
|
IsBatchItem
|
|
|
|
|
IsBinaryServiceEnabled
|
|
|
Boolean
|
|
IsBinaryServiceEnabled
|
|
|
|
|
IsCommissionable
|
Commissionable
|
Commissionable
|
Boolean
|
|
IsCommissionable
|
|
|
|
|
IsDiscount
|
No discount
|
No discount
|
Boolean
|
|
IsDiscount
|
|
|
|
|
IsExplode
|
Explode
|
Explode
|
Boolean
|
|
IsExplode
|
|
|
|
|
IsFractionAllowedItem
|
Divisible
|
Divisible
|
Boolean
|
|
IsFractionAllowedItem
|
|
|
|
|
IsIntrastatEnabled
|
Intrastat
|
Intrastat
|
Boolean
|
|
IsIntrastatEnabled
|
|
|
|
|
IsOutsourcedItem
|
Outsourced Item
|
Outsourced Item
|
Boolean
|
|
IsOutsourcedItem
|
|
|
|
|
IsPriceRegulationItem
|
Policy
|
Policy
|
Boolean
|
|
IsPriceRegulationItem
|
|
|
|
|
IsPrintItem
|
Print
|
Print
|
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
|
|
|
|
|
IsTaxItem
|
Environmental tax
|
Environmental tax
|
Boolean
|
|
IsTaxItem
|
|
|
|
|
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
|
|
|
|
|
ItemToBeReceivedLedger
|
Invoices / items to be received
|
Invoices / items to be received
|
String
|
|
ItemToBeReceivedLedger
|
|
|
|
|
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
|
|
|
|
|
LinkItemCode
|
|
|
String
|
|
LinkItemCode
|
|
|
|
|
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
|
|
|
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
|
|
|
|
|
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
|
|
|
Number
|
|
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
|
Sales VAT Code
|
Sales VAT Code
|
String
|
|
SalesVATCode
|
|
|
|
|
SalesVATCodeDescription
|
|
|
String
|
|
SalesVATCodeDescription
|
|
|
|
|
SearchCode
|
|
|
String
|
|
SearchCode
|
|
|
|
|
SecurityLevel
|
Security level
|
Security level
|
Number
|
|
SecurityLevel
|
|
|
|
|
SerialBatchItem
|
|
|
String
|
|
SerialBatchItem
|
|
|
|
|
SerialBatchMask
|
|
|
String
|
|
SerialBatchMask
|
|
|
|
|
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 |
AddExtraReceiptToOrder
|
AddExtraReceiptToOrder
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
Assortment
|
Assortment
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
9,0,9 | 3,0,Accessoires | 6,0,Halffabrikaten | 2,0,Interne producten | 5,0,Onbewerkte materialen | 1,0,Producten | 4,0,Service | 0,0,Standaard | 8,0,Toeslagen | 7,0,Uren |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
B,1267,Blocked | D,19669,Discontinued |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
CommissionMethod
|
CommissionMethod
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CommissionValue
|
CommissionValue
|
Number
|
|
8
|
2
|
0.00
|
|
|
|
|
|
|
|
|
|
|
|
CompanyCode
|
OwnerCompany
|
String
|
|
3
|
0
|
Company
|
|
|
|
|
|
|
|
|
|
|
|
CompanyName
|
OwnerCompanyName
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Condition
|
Condition
|
String
|
|
1
|
0
|
A
|
|
|
|
|
|
|
|
|
|
|
A,2212,Active | B,1267,Blocked | D,19669,Discontinued | E,29544,Inactive | F,47,Future |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
AR,0,Argentina | BE,0,Belgie | BQ,0,Bonaire, Sint Eustatius and Saba | BR,0,Brazilie | CA,0,Canada | CO,0,Colombia | CW,0,Curaao | EC,0,Ecuador | SV,0,El Salvador | GB,0,Engeland | FR,0,Frankrijk | LU,0,Luxemburg | MY,0,Malaysia | MX,0,Mexico | NL,0,Nederland | PE,0,Peru | MF,0,Saint Martin (France) | SX,0,Sint Maarten (Dutch part) | US,0,Verenigde Staten |
|
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
|
|
8191
|
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 |
ESFCountryDescLeading
|
ESFCountryDescLeading
|
Boolean
|
|
0
|
0
|
0
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
GLAccountDiscount
|
GLAccountDiscount
|
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
|
|
|
|
|
|
|
|
|
|
|
|
GTIN
|
GTIN
|
String
|
|
20
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with H |
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 |
HTSCode
|
HTSCode
|
String
|
|
14
|
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 |
IncrementFactor
|
IncrementFactor
|
Number
|
|
5
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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
|
|
|
|
|
|
|
|
|
|
IsBinaryServiceEnabled
|
IsBinaryServiceEnabled
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
IsCommissionable
|
IsCommissionable
|
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
|
|
|
|
|
|
|
|
|
|
IsIntrastatEnabled
|
IsIntrastatEnabled
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
IsOutsourcedItem
|
IsOutsourcedItem
|
Boolean
|
|
1
|
0
|
0
|
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
|
|
|
|
|
|
|
|
|
|
IsTaxItem
|
IsTaxItem
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemToBeReceivedLedger
|
ItemToBeReceivedLedger
|
String
|
|
9
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
LinkItemCode
|
LinkItemCode
|
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 |
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
|
|
|
|
|
|
|
|
|
|
|
|
|
ProductLine
|
ProductLine
|
String
|
|
1
|
0
|
G
|
|
|
|
|
|
|
|
|
|
|
G,0,Exact globe 2003 | S,0,e-Synergy | N,0,Not defined |
|
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
|
Number
|
|
10
|
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
|
|
|
|
|
|
|
|
|
|
|
|
0,17765,Discounts | 1,310,Variants |
|
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
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialBatchMask
|
SerialBatchMask
|
String
|
|
20
|
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
|
|
|
|
|
|
|
|
|
|
|
S,8836,Standard | P,32404,Phantom | B,32360,Bulk issue | L,12737,Labor hour | M,653,Machine hour | C,10421,Contract | R,13148,Reason codes |
|
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
|
|
|
|
|
|
|
|
|
|