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 |
AllowInCatalog
|
AllowInCatalog
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowNewContract
|
AllowNewContract
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowNewDocument
|
AllowNewDocument
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
AllowNewItem
|
AllowNewItem
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
Assortment
|
Assortment
|
Number
|
|
10
|
0
|
SELECT TOP 1 i1.Assortment + 1 FROM (SELECT Assortment FROM ItemAssortment UNION SELECT -1) AS i1 INNER JOIN (SELECT Assortment FROM ItemAssortment UNION SELECT -1) AS i2 ON i1.Assortment >= i2.Assortment GROUP BY i1.Assortment HAVING COUNT(*) - 2 = i1.Assortment ORDER BY i1.Assortment DESC
|
|
|
|
|
|
|
|
|
|
|
|
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 |
CatalogClass1
|
CatalogClass_1
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,0,Productlijn | 2,0,Productgroep | 3,0,Oplossingsrichting | 4,0,Doelgroep | 5,0,Interne producten | 6,0,Size | 7,0,Assortment 7 | 8,0,Assortment 8 | 9,0,Assortment 9 | 10,0,Assortment 10 |
|
CatalogClass2
|
CatalogClass_2
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,0,Productlijn | 2,0,Productgroep | 3,0,Oplossingsrichting | 4,0,Doelgroep | 5,0,Interne producten | 6,0,Size | 7,0,Assortment 7 | 8,0,Assortment 8 | 9,0,Assortment 9 | 10,0,Assortment 10 |
|
CatalogClass3
|
CatalogClass_3
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
1,0,Productlijn | 2,0,Productgroep | 3,0,Oplossingsrichting | 4,0,Doelgroep | 5,0,Interne producten | 6,0,Size | 7,0,Assortment 7 | 8,0,Assortment 8 | 9,0,Assortment 9 | 10,0,Assortment 10 |
|
CatalogItemSelection
|
CatalogItemSelection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CatalogOrder
|
CatalogOrder
|
Number
|
|
10
|
0
|
1
|
|
|
|
|
|
|
|
|
|
|
|
Code
|
Code
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractComponentParameter
|
ContractComponentParameter
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractComponentProgramID
|
ContractComponentProgID
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractDocumentCategory
|
ContractDocCategory
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractDocumentGroup
|
ContractDocGroup
|
Number
|
|
10
|
0
|
|
|
|
|
|
|
|
|
|
|
|
0,0,Attachments & notes | 1,0,Employees | 2,0,Discussions | 3,0,Management | 4,0,Policies and Procedures | 5,0,Support | 6,0,Sales | 7,0,Marketing | 8,0,Purchasing | 9,0,Research and Development | 10,0,Finance and Administration |
|
ContractDocumentSecurity
|
ContractDocSecurity
|
Number
|
|
2
|
0
|
10
|
|
|
|
|
|
|
|
|
|
|
|
ContractDocumentSubcategory
|
ContractDocSubcategory
|
String
|
|
30
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractItemSelection
|
ContractItemSelection
|
String
|
|
255
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ContractReleaseMandatory
|
ContractReleaseMandatory
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
Costunit
|
Costunit
|
String
|
|
8
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CostunitDescription
|
CostunitDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
CreatedDate
|
SysCreated
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Creator
|
SysCreator
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
CreatorName
|
SysCreatorName
|
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 |
Description
|
Description
|
String
|
|
60
|
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 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 |
GLAccountDiscount
|
GLAccountDiscount
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLCostOfGoodsSold
|
GLCostOfGoodsSold
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLCostOfGoodsSoldDescription
|
GLCostOfGoodsSoldDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLDeferredCost
|
GLDeferredCost
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLDeferredCostDescription
|
GLDeferredCostDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLDeferredRevenue
|
GLDeferredRevenue
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLDeferredRevenueDescription
|
GLDeferredRevenueDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLDiscount
|
GLDiscount
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLDiscountDescription
|
GLDiscountDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLPriceDifference
|
GLPriceDifference
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLPriceDifferenceDescription
|
GLPriceDifferenceDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLPurchase
|
GLStock
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLPurchaseDescription
|
GLStockDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLRecognizeCosts
|
GLRecognizeCosts
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLRecognizeCostsDescription
|
GLRecognizeCostsDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLRevenue
|
GLRevenue
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLRevenueDescription
|
GLRevenueDescription
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLStockChange
|
GLStkChange
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
GLStockCoverage
|
GLStkCoverage
|
String
|
|
9
|
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 |
ItemDateFreeFieldLabel1
|
LabelUserDate_01
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemDateFreeFieldLabel2
|
LabelUserDate_02
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemDateFreeFieldLabel3
|
LabelUserDate_03
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemDateFreeFieldLabel4
|
LabelUserDate_04
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemDateFreeFieldLabel5
|
LabelUserDate_05
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemNumberFreeFieldLabel1
|
LabelUserNumber_01
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemNumberFreeFieldLabel2
|
LabelUserNumber_02
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemNumberFreeFieldLabel3
|
LabelUserNumber_03
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemNumberFreeFieldLabel4
|
LabelUserNumber_04
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemNumberFreeFieldLabel5
|
LabelUserNumber_05
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel1
|
LabelUserField_01
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel10
|
LabelUserField_10
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel2
|
LabelUserField_02
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel3
|
LabelUserField_03
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel4
|
LabelUserField_04
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel5
|
LabelUserField_05
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel6
|
LabelUserField_06
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel7
|
LabelUserField_07
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel8
|
LabelUserField_08
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemTextFreeFieldLabel9
|
LabelUserField_09
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemToBeReceivedLedger
|
ItemToBeReceivedLedger
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemYesNoFreeFieldLabel1
|
LabelUserYesNo_01
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemYesNoFreeFieldLabel2
|
LabelUserYesNo_02
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemYesNoFreeFieldLabel3
|
LabelUserYesNo_03
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemYesNoFreeFieldLabel4
|
LabelUserYesNo_04
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
ItemYesNoFreeFieldLabel5
|
LabelUserYesNo_05
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with M |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
ModifiedDate
|
SysModified
|
Date
|
|
0
|
0
|
NOW
|
|
|
|
|
|
|
|
|
|
|
|
Modifier
|
SysModifier
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
ModifierName
|
SysModifierName
|
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 |
Note
|
Note
|
String
|
|
8191
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
OwnerPerson
|
OwnerPerson
|
Number
|
|
10
|
0
|
HUMRESID
|
|
|
|
|
|
|
|
|
|
|
|
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 |
PictureFileName
|
PictureFileName
|
String
|
|
128
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
PriceSecurityLevel
|
PriceSecurityLevel
|
Number
|
|
2
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with R |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
RoundOffMethod
|
RoundOffMethod
|
String
|
|
1
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
Property starting with S |
Name |
Source name |
Type |
Mandatory |
Length |
Scale |
Default value |
Lower range |
Upper range |
Allowed characters |
Auto increment |
Numeric string |
Right aligned |
Unsigned |
Upper case |
Zero equals null |
Zero fill |
Selection values |
SecurityLevel
|
SecurityLevel
|
Number
|
|
2
|
0
|
10
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberDateFreeFieldLabel1
|
LabelNUserDate_01
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberDateFreeFieldLabel2
|
LabelNUserDate_02
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberDateFreeFieldLabel3
|
LabelNUserDate_03
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberDateFreeFieldLabel4
|
LabelNUserDate_04
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberDateFreeFieldLabel5
|
LabelNUserDate_05
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberNumberFreeFieldLabel1
|
LabelNUserNumber_01
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberNumberFreeFieldLabel2
|
LabelNUserNumber_02
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberNumberFreeFieldLabel3
|
LabelNUserNumber_03
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberNumberFreeFieldLabel4
|
LabelNUserNumber_04
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberNumberFreeFieldLabel5
|
LabelNUserNumber_05
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel1
|
LabelNUserField_01
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel10
|
LabelNUserField_10
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel2
|
LabelNUserField_02
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel3
|
LabelNUserField_03
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel4
|
LabelNUserField_04
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel5
|
LabelNUserField_05
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel6
|
LabelNUserField_06
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel7
|
LabelNUserField_07
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel8
|
LabelNUserField_08
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberTextFreeFieldLabel9
|
LabelNUserField_09
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberYesNoFreeFieldLabel1
|
LabelNUserYesNo_01
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberYesNoFreeFieldLabel2
|
LabelNUserYesNo_02
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberYesNoFreeFieldLabel3
|
LabelNUserYesNo_03
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberYesNoFreeFieldLabel4
|
LabelNUserYesNo_04
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
SerialNumberYesNoFreeFieldLabel5
|
LabelNUserYesNo_05
|
String
|
|
60
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
StatisticalNumber
|
StatNumber
|
String
|
|
9
|
0
|
|
|
|
|
|
|
|
|
|
|
|
|
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 |
UseCatalog
|
UseCatalog
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseContract
|
UseContract
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseCountries
|
UseCountries
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseReleases
|
UseReleases
|
Boolean
|
|
1
|
0
|
0
|
0
|
1
|
|
|
|
|
|
|
|
|
|
UseTranslations
|
UseTranslations
|
Boolean
|
|
1
|
0
|
1
|
0
|
1
|
|
|
|
|
|
|
|
|
|