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 |
GLAccountDiscount | Discount | Discount | String | GLAccountDiscount | |||||
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 | |||||||
GLRecognizeCosts | Recognized cost | Recognized cost | String | GLRecognizeCosts | |||||
GLRecognizeCostsDescription | String | GLRecognizeCostsDescription | |||||||
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 | |||||
ItemToBeReceivedLedger | Invoices / items to be received | Invoices / items to be received | String | ItemToBeReceivedLedger | |||||
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 |
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 |
|
|||||||||||||||||||||||
CatalogClass2 | CatalogClass_2 | Number | 10 | 0 |
|
|||||||||||||||||||||||
CatalogClass3 | CatalogClass_3 | Number | 10 | 0 |
|
|||||||||||||||||||||||
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 |
|
|||||||||||||||||||||||
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 |