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