List of properties

Entity ItemAssortment
Key property Assortment


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
AllowInCatalog Allow Allow Boolean AllowInCatalog
AllowNewContract Allow Allow Boolean AllowNewContract
AllowNewDocument Allow Allow Boolean AllowNewDocument
AllowNewItem Allow Allow Boolean AllowNewItem
Assortment Assortment Assortment Number Assortment

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
CatalogClass1 Group by Group by Number CatalogClass1
CatalogClass2 Group by Group by Number CatalogClass2
CatalogClass3 Property Property Number CatalogClass3
CatalogItemSelection Catalog Catalog String CatalogItemSelection
CatalogOrder Catalog Catalog Number CatalogOrder
Code Code Code String Code
ContractComponentParameter Parameter Parameter String ContractComponentParameter
ContractComponentProgramID Program Program String ContractComponentProgramID
ContractDocumentCategory Document Document String ContractDocumentCategory
ContractDocumentGroup Document Document Number ContractDocumentGroup
ContractDocumentSecurity Document Document Number ContractDocumentSecurity
ContractDocumentSubcategory Document Document String ContractDocumentSubcategory
ContractItemSelection Item Item String ContractItemSelection
ContractReleaseMandatory Release Release Boolean ContractReleaseMandatory
Costunit String Costunit
CostunitDescription String CostunitDescription
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
Description Description Description String Description
Description0 String Description0
Description1 String Description1
Description2 String Description2
Description3 String Description3
Description4 String Description4

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
GLCostOfGoodsSold Cost of goods sold Cost of goods sold String GLCostOfGoodsSold
GLCostOfGoodsSoldDescription String GLCostOfGoodsSoldDescription
GLDeferredCost Deferred cost Deferred cost String GLDeferredCost
GLDeferredCostDescription String GLDeferredCostDescription
GLDeferredRevenue Deferred revenue Deferred revenue String GLDeferredRevenue
GLDeferredRevenueDescription String GLDeferredRevenueDescription
GLDiscount Discount Discount String GLDiscount
GLDiscountDescription String GLDiscountDescription
GLPriceDifference Price differences Price differences String GLPriceDifference
GLPriceDifferenceDescription String GLPriceDifferenceDescription
GLPurchase Purchase Purchase String GLPurchase
GLPurchaseDescription String GLPurchaseDescription
GLRevenue Revenue Revenue String GLRevenue
GLRevenueDescription String GLRevenueDescription
GLStockChange Stock change Stock change String GLStockChange
GLStockCoverage Stock coverage Stock coverage String GLStockCoverage

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
ItemDateFreeFieldLabel1 Date Date String ItemDateFreeFieldLabel1
ItemDateFreeFieldLabel2 Date Date String ItemDateFreeFieldLabel2
ItemDateFreeFieldLabel3 Date Date String ItemDateFreeFieldLabel3
ItemDateFreeFieldLabel4 Date Date String ItemDateFreeFieldLabel4
ItemDateFreeFieldLabel5 Date Date String ItemDateFreeFieldLabel5
ItemNumberFreeFieldLabel1 Number Number String ItemNumberFreeFieldLabel1
ItemNumberFreeFieldLabel2 Number Number String ItemNumberFreeFieldLabel2
ItemNumberFreeFieldLabel3 Number Number String ItemNumberFreeFieldLabel3
ItemNumberFreeFieldLabel4 Number Number String ItemNumberFreeFieldLabel4
ItemNumberFreeFieldLabel5 Number Number String ItemNumberFreeFieldLabel5
ItemTextFreeFieldLabel1 Text Text String ItemTextFreeFieldLabel1
ItemTextFreeFieldLabel10 Text Text String ItemTextFreeFieldLabel10
ItemTextFreeFieldLabel2 Text Text String ItemTextFreeFieldLabel2
ItemTextFreeFieldLabel3 Text Text String ItemTextFreeFieldLabel3
ItemTextFreeFieldLabel4 Text Text String ItemTextFreeFieldLabel4
ItemTextFreeFieldLabel5 Text Text String ItemTextFreeFieldLabel5
ItemTextFreeFieldLabel6 Text Text String ItemTextFreeFieldLabel6
ItemTextFreeFieldLabel7 Text Text String ItemTextFreeFieldLabel7
ItemTextFreeFieldLabel8 Text Text String ItemTextFreeFieldLabel8
ItemTextFreeFieldLabel9 Text Text String ItemTextFreeFieldLabel9
ItemYesNoFreeFieldLabel1 Yes/No Yes/No String ItemYesNoFreeFieldLabel1
ItemYesNoFreeFieldLabel2 Yes/No Yes/No String ItemYesNoFreeFieldLabel2
ItemYesNoFreeFieldLabel3 Yes/No Yes/No String ItemYesNoFreeFieldLabel3
ItemYesNoFreeFieldLabel4 Yes/No Yes/No String ItemYesNoFreeFieldLabel4
ItemYesNoFreeFieldLabel5 Yes/No Yes/No String ItemYesNoFreeFieldLabel5

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
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
Note Remarks Remarks String Note

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
OwnerPerson Resource Resource Number OwnerPerson
OwnerPersonName Resource Resource 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
PictureFileName File File String PictureFileName
PriceSecurityLevel Number PriceSecurityLevel

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
RoundOffMethod Rounding Methods Rounding Methods String RoundOffMethod

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
SecurityLevel Security level Security level Number SecurityLevel
SerialNumberDateFreeFieldLabel1 Date Date String SerialNumberDateFreeFieldLabel1
SerialNumberDateFreeFieldLabel2 Date Date String SerialNumberDateFreeFieldLabel2
SerialNumberDateFreeFieldLabel3 Date Date String SerialNumberDateFreeFieldLabel3
SerialNumberDateFreeFieldLabel4 Date Date String SerialNumberDateFreeFieldLabel4
SerialNumberDateFreeFieldLabel5 Date Date String SerialNumberDateFreeFieldLabel5
SerialNumberNumberFreeFieldLabel1 Number Number String SerialNumberNumberFreeFieldLabel1
SerialNumberNumberFreeFieldLabel2 Number Number String SerialNumberNumberFreeFieldLabel2
SerialNumberNumberFreeFieldLabel3 Number Number String SerialNumberNumberFreeFieldLabel3
SerialNumberNumberFreeFieldLabel4 Number Number String SerialNumberNumberFreeFieldLabel4
SerialNumberNumberFreeFieldLabel5 Number Number String SerialNumberNumberFreeFieldLabel5
SerialNumberTextFreeFieldLabel1 Test Test String SerialNumberTextFreeFieldLabel1
SerialNumberTextFreeFieldLabel10 text text String SerialNumberTextFreeFieldLabel10
SerialNumberTextFreeFieldLabel2 text text String SerialNumberTextFreeFieldLabel2
SerialNumberTextFreeFieldLabel3 text text String SerialNumberTextFreeFieldLabel3
SerialNumberTextFreeFieldLabel4 text text String SerialNumberTextFreeFieldLabel4
SerialNumberTextFreeFieldLabel5 text text String SerialNumberTextFreeFieldLabel5
SerialNumberTextFreeFieldLabel6 text text String SerialNumberTextFreeFieldLabel6
SerialNumberTextFreeFieldLabel7 text text String SerialNumberTextFreeFieldLabel7
SerialNumberTextFreeFieldLabel8 text text String SerialNumberTextFreeFieldLabel8
SerialNumberTextFreeFieldLabel9 text text String SerialNumberTextFreeFieldLabel9
SerialNumberYesNoFreeFieldLabel1 Yes/no Yes/no String SerialNumberYesNoFreeFieldLabel1
SerialNumberYesNoFreeFieldLabel2 Yes/no Yes/no String SerialNumberYesNoFreeFieldLabel2
SerialNumberYesNoFreeFieldLabel3 Yes/no Yes/no String SerialNumberYesNoFreeFieldLabel3
SerialNumberYesNoFreeFieldLabel4 Yes/no Yes/no String SerialNumberYesNoFreeFieldLabel4
SerialNumberYesNoFreeFieldLabel5 Yes/no Yes/no String SerialNumberYesNoFreeFieldLabel5
StatisticalNumber Statistical code Statistical code String StatisticalNumber

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
UseCatalog Catalog Catalog Boolean UseCatalog
UseContract Contract Contract Boolean UseContract
UseCountries Countries Countries Boolean UseCountries
UseReleases Releases Releases Boolean UseReleases
UseTranslations Translations Translations Boolean UseTranslations

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
Exact.Repository.ERSelectionValue
CatalogClass2 CatalogClass_2 Number 10 0
Exact.Repository.ERSelectionValue
CatalogClass3 CatalogClass_3 Number 10 0
Exact.Repository.ERSelectionValue
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
Exact.Repository.ERSelectionValue
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
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
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
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

List of obsolete properties
There is no obsolete property