Entity ItemAssortment
Key property Assortment


Property starting with A
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
AllowInCatalog Allow Allow Boolean
AllowNewContract Allow Allow Boolean
AllowNewDocument Allow Allow Boolean
AllowNewItem Allow Allow Boolean
Assortment Assortment Assortment Number

Property starting with C
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
CatalogClass1 Group by Group by Number
CatalogClass2 Group by Group by Number
CatalogClass3 Property Property Number
CatalogItemSelection Catalog Catalog String
CatalogOrder Catalog Catalog Number
Code Code Code String
ContractComponentParameter Parameter Parameter String
ContractComponentProgramID Program Program String
ContractDocumentCategory Document Document String
ContractDocumentGroup Document Document Number
ContractDocumentSecurity Document Document Number
ContractDocumentSubcategory Document Document String
ContractItemSelection Item Item String
ContractReleaseMandatory Release Release Boolean
Costunit String
CostunitDescription String
CreatedDate created created Date
Creator creator creator Number
CreatorName String

Property starting with D
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Description Description Description String
Description0 String
Description1 String
Description2 String
Description3 String
Description4 String

Property starting with G
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
GLAccountDiscount Discount Discount String
GLCostOfGoodsSold Cost of goods sold Cost of goods sold String
GLCostOfGoodsSoldDescription String
GLDeferredCost Deferred cost Deferred cost String
GLDeferredCostDescription String
GLDeferredRevenue Deferred revenue Deferred revenue String
GLDeferredRevenueDescription String
GLDiscount Discount Discount String
GLDiscountDescription String
GLPriceDifference Price differences Price differences String
GLPriceDifferenceDescription String
GLPurchase Purchase Purchase String
GLPurchaseDescription String
GLRecognizeCosts Recognized cost Recognized cost String
GLRecognizeCostsDescription String
GLRevenue Revenue Revenue String
GLRevenueDescription String
GLStockChange Stock change Stock change String
GLStockCoverage Stock coverage Stock coverage String

Property starting with I
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ItemDateFreeFieldLabel1 Date Date String
ItemDateFreeFieldLabel2 Date Date String
ItemDateFreeFieldLabel3 Date Date String
ItemDateFreeFieldLabel4 Date Date String
ItemDateFreeFieldLabel5 Date Date String
ItemNumberFreeFieldLabel1 Number Number String
ItemNumberFreeFieldLabel2 Number Number String
ItemNumberFreeFieldLabel3 Number Number String
ItemNumberFreeFieldLabel4 Number Number String
ItemNumberFreeFieldLabel5 Number Number String
ItemTextFreeFieldLabel1 Text Text String
ItemTextFreeFieldLabel10 Text Text String
ItemTextFreeFieldLabel2 Text Text String
ItemTextFreeFieldLabel3 Text Text String
ItemTextFreeFieldLabel4 Text Text String
ItemTextFreeFieldLabel5 Text Text String
ItemTextFreeFieldLabel6 Text Text String
ItemTextFreeFieldLabel7 Text Text String
ItemTextFreeFieldLabel8 Text Text String
ItemTextFreeFieldLabel9 Text Text String
ItemToBeReceivedLedger Invoices / items to be received Invoices / items to be received String
ItemYesNoFreeFieldLabel1 Yes/No Yes/No String
ItemYesNoFreeFieldLabel2 Yes/No Yes/No String
ItemYesNoFreeFieldLabel3 Yes/No Yes/No String
ItemYesNoFreeFieldLabel4 Yes/No Yes/No String
ItemYesNoFreeFieldLabel5 Yes/No Yes/No String

Property starting with M
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
ModifiedDate Modified Modified Date
Modifier modifier modifier Number
ModifierName String

Property starting with N
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
Note Remarks Remarks String

Property starting with O
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
OwnerPerson Resource Resource Number
OwnerPersonName Resource Resource String

Property starting with P
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
PictureFileName File File String
PriceSecurityLevel Number

Property starting with R
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
RoundOffMethod Rounding Methods Rounding Methods String

Property starting with S
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
SecurityLevel Security level Security level Number
SerialNumberDateFreeFieldLabel1 Date Date String
SerialNumberDateFreeFieldLabel2 Date Date String
SerialNumberDateFreeFieldLabel3 Date Date String
SerialNumberDateFreeFieldLabel4 Date Date String
SerialNumberDateFreeFieldLabel5 Date Date String
SerialNumberNumberFreeFieldLabel1 Number Number String
SerialNumberNumberFreeFieldLabel2 Number Number String
SerialNumberNumberFreeFieldLabel3 Number Number String
SerialNumberNumberFreeFieldLabel4 Number Number String
SerialNumberNumberFreeFieldLabel5 Number Number String
SerialNumberTextFreeFieldLabel1 Test Test String
SerialNumberTextFreeFieldLabel10 text text String
SerialNumberTextFreeFieldLabel2 text text String
SerialNumberTextFreeFieldLabel3 text text String
SerialNumberTextFreeFieldLabel4 text text String
SerialNumberTextFreeFieldLabel5 text text String
SerialNumberTextFreeFieldLabel6 text text String
SerialNumberTextFreeFieldLabel7 text text String
SerialNumberTextFreeFieldLabel8 text text String
SerialNumberTextFreeFieldLabel9 text text String
SerialNumberYesNoFreeFieldLabel1 Yes/no Yes/no String
SerialNumberYesNoFreeFieldLabel2 Yes/no Yes/no String
SerialNumberYesNoFreeFieldLabel3 Yes/no Yes/no String
SerialNumberYesNoFreeFieldLabel4 Yes/no Yes/no String
SerialNumberYesNoFreeFieldLabel5 Yes/no Yes/no String
StatisticalNumber Statistical code Statistical code String

Property starting with U
Name Caption Description Type Mandatory Available since release Introduced by which team Introduced for which project Additional remarks
UseCatalog Catalog Catalog Boolean
UseContract Contract Contract Boolean
UseCountries Countries Countries Boolean
UseReleases Releases Releases Boolean
UseTranslations Translations Translations Boolean

Detail information of properties

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