YLEISIMMÄT:
Project:
long Number
string Name
ProjectType Type
Address Address
int ProjectStateId
ProjectState State
ICollection<Order> Orders
ICollection<House> Houses
ICollection<StyleCollection> StyleCollections
ICollection<VariableValue> VariableValue
ICollection<DeliveryBatch> Deliveries
---
Order:
string Name
OrderStage Stage
long Number
string Site
string SiteNumber
bool IsExtraOrder
bool IsActive
int ProjectId
Project Project
int CustomerId
Customer Customer
int? CustomerUnitId
CustomerUnit CustomerUnit
ICollection<Design> Designs
ICollection<PricingRow> PricingRows
List<ApartmentDesign> ApartmentDesigns
List<Apartment> Apartments
List<UnitsWithQuantity> UnitsWithQuantity
List<Unit> Units
List<Style> Styles
---
Design:
string Name
int? Quantity
bool IsAutoQuantity
string Comment
int OrderId
Order Order
int? StyleCollectionId
StyleCollection StyleCollection
ICollection<ApartmentDesign> ApartmentsForDesign
ICollection<Unit> Units
ICollection<TagDesign> TagDesigns
int? RomFileId
FileData RomFile
int? ImageFileId
FileData ImageFile
ICollection<DesignImage> DesignImages
int? LockedById
User LockedBy
ManyToManyCollection<Design, TagDesign, Tag> Tags
ManyToManyCollection<Design, DesignImage, FileData> OtherImages
int CurrentQuantity
UnitsWithQuantity UnitsWithQuantity
List<Style> PrivateStyles
string TagNames
int Count
List<Apartment> Apartments
List<Style> Styles
---
DeliveryBatch:
DateTime DateTimeFrom
DateTime DateTimeTo
int PlannedApartments
bool IsDelivered
string Comment
string Color
int ProjectId
Project Project
ICollection<ApartmentDesign> ApartmentDesigns
List<Unit> Units
List<ApartmentUnit> UnitsByApartment
List<Apartment> Apartments
string StartTimeYearWeekDay
List<UnitsWithQuantity> UnitsWithQuantity
---
Customer:
string Name
Address Address
string UnitName
string CompanyId
bool IsUserCompany
ICollection<Order> Orders
ICollection<CustomerUnit> Units
ICollection<User> Users
---
Unit:
string Name
string Index
string OrderCode
string Description
Coordinates Coordinates
double Width
double Length
double Height
bool SpecialDimensions
int Amount
decimal UnitPrice
string Handedness
ReportCategory ReportCategory
int AnnotationNumber
int DesignId
Design Design
int StyleId
Style Style
int? ParentId
Unit Parent
int UnitTypeId
UnitType UnitType
ICollection<Unit> Children
int TotalAmount
SelectedSelectionValue PricingTypeSelectedValue
SelectionValue PricingTypeValue
List<Color> PricingTypeColors
List<SelectedSelectionValueColor> SelectedSelectionValueColors
List<ApartmentDesign> ApartmentDesigns
string Dimensions2Text
string Dimensions3Text
---
UnitType:
string Name
string Code
double InstallUnits
double ManufacturingUnits
double CargoUnits
int GeneralNumber
int? PricingTypeId
SelectionType PricingType
int? IconId
ImageData Icon
int FusionCatalogueId
FusionCatalogueVersion FusionCatalogue
int? TypeId
SecondaryType Type
---
VÄHEMMÄN YLEISET AAKKOSJÄRJESTYKSESSÄ:
Apartment:
int Floor
string Stair
string Identifier
DateTime? InitialDeliveryDate
int HouseId
House House
ICollection<ApartmentDesign> ApartmentsForDesign
int NumberInt
int Count
---
ApartmentDesign:
int ApartmentId
Apartment Apartment
int DesignId
Design Design
int? DeliveryBatchId
DeliveryBatch DeliveryBatch
---
Color:
string Name
string Description
byte Red
byte Green
byte Blue
int FusionId
int FusionMaterialId
ICollection<ColorSelectionValueColorLink> ColorSelectionValueColorLinks
ManyToManyCollection<Color, ColorSelectionValueColorLink, SelectionValueColorLink> ValueColorLinks
---
ColorLink:
string Name
int LinkedColorRef
ICollection<SelectionValueColorLink> SelectedSelectionValueColorLinks
ICollection<SelectedSelectionValueColor> SelectedSelectionValueColors
---
ColorSelectionValueColorLink:
int SelectionValueColorLink_Id
SelectionValueColorLink SelectionValueColorLink
int Color_Id
Color Color
---
CustomerUnit:
string Name
Address Address
Customer Customer
ICollection<Order> Orders
int CustomerId
---
CustomField:
string Key
string Text
string LocalizationUid
string TableTypeText
string ValueTypeText
int Order
string DefaultValue
bool ShowInGrids
ICollection<CustomFieldValue> Values
ICollection<CustomFieldEnumValue> EnumValues
Type TableType
Type ValueType
---
CustomFieldEnumValue:
string Text
string Value
string LocalizationUid
int Order
int CustomFieldId
---
CustomFieldValue:
string Value
int CustomFieldId
CustomField CustomField
int ReferenceId
---
DesignImage:
int DesignId
Design Design
int ImageId
FileData Image
---
FileData:
string FileName
string FileDirectory
string Hash
byte[] Data
ICollection<Design> DesignsWithImageFiles
ICollection<Design> DesignsWithRomFiles
ICollection<DesignImage> DesignImages
ICollection<ReportTemplate> ReportTemplates
ICollection<ImageData> Images
---
FusionCatalogue:
string Name
int Id
ICollection<FusionCatalogueVersion> Catalogues
List<FusionCatalogueVersion> ActiveCatalogues
FusionCatalogueVersion LatestActiveCatalogue
---
FusionCatalogueVersion:
string Name
string Version
bool IsArchived
int UniqueCatalogueId
FusionCatalogue UniqueCatalogue
ICollection<SelectionType> FusionSelectionTypes
ICollection<Style> Styles
ICollection<UnitType> UnitTypes
ICollection<PrimaryType> PrimaryTypes
ICollection<ImageData> Icons
SelectionType this[int index]
int VersionAsNumber
Dictionary<string, UnitType> UnitTypeDict
---
FusionCustomField:
string GeneralTextTitle
string ValueSource
string ValueProperty
---
House:
string Name
Address Address
int ProjectId
Project Project
ICollection<Apartment> Apartments
---
ImageData:
string Description
ImageType Type
int FusionCatalogueVersionId
FusionCatalogueVersion FusionCatalogueVersion
int FileId
FileData File
---
PricingColumn:
PricingColumnType Type
string Text
---
PricingGroup:
string Name
decimal PurchaseDiscountPercent
decimal GrossProfitPercent
int Order
bool IsCategoryOnly
int? ParentId
PricingGroup Parent
ICollection<PricingGroup> Children
int? ScriptId
Script Script
ICollection<PricingGroupCondition> Conditions
ICollection<PricingRow> PricingRows
---
PricingGroupCondition:
string Description
int GeneralNumber
ReportCategory ReportCategory
int Priority
string OrderCodeRegex
int UniqueCatalogueId
FusionCatalogue UniqueCatalogue
int PricingGroupId
PricingGroup PricingGroup
int? DltTypeId
int? DltEntryId
int? PrimaryTypeFusionId
int? SecondaryTypeFusionId
---
PricingRow:
decimal PurchaseDiscountPercent
decimal GrossProfitPercent
decimal SaleDiscountPercent
int OrderId
Order Order
int? PricingGroupId
PricingGroup PricingGroup
---
PrimaryType:
string Name
int FusionId
int FusionCatalogueVersionId
FusionCatalogueVersion FusionCatalogueVersion
ICollection<SecondaryType> SecondaryTypes
---
ProjectState:
int Index
string Name
ICollection<Project> Projects
---
ReportTemplate:
string Name
string RibbonGroup
string RequiredSelectionType
FileFormat FileFormat
int FileId
FileData File
---
Script:
string Code
string HashCode
---
ScriptVariable:
string Name
string VariableName
string TypeFullName
string Value
ICollection<VariableValue> Values
Type Type
---
SecondaryType:
string Name
int FusionId
int PrimaryTypeId
PrimaryType PrimaryType
ICollection<UnitType> UnitTypes
---
SelectedSelectionValue:
int StyleId
Style Style
int ValueId
SelectionValue Value
ICollection<SelectedSelectionValueColor> SelectedColors
List<int> OrderedColorIds
---
SelectedSelectionValueColor:
int SelectedSelectionValueId
SelectedSelectionValue SelectedSelectionValue
int ColorLinkId
ColorLink ColorLink
int ColorId
Color Color
---
SelectionType:
string Name
double SortSequence
int DltTypeId
ICollection<SelectionValue> SelectionValues
ICollection<UnitType> UnitTypes
int FusionCatalogueId
FusionCatalogueVersion FusionCatalogue
SelectionValue this[int index]
---
SelectionValue:
string Value
double? FixedPrice
string PriceGroupName
int DltEntryId
ICollection<SelectedSelectionValue> SelectedSelectionValues
ICollection<SelectionValueColorLink> ColorLinks
SelectionTypeId
SelectionType SelectionType
ICollection<SelectionValueDependency> Dependencies
ICollection<SelectionValueDependency> DependenciesAsTarget
---
SelectionValueColorLink:
int SelectionValueId
SelectionValue SelectionValue
int ColorLinkId
ColorLink ColorLink
ICollection<ColorSelectionValueColorLink> ColorSelectionValueColorLinks
ManyToManyCollection<SelectionValueColorLink, ColorSelectionValueColorLink, Color> Colors
---
SelectionValueDependency:
int SourceId
SelectionValue Source
int TargetId
SelectionValue Target
---
Settings:
string Key
string Value
SettingType SettingType
---
Style:
int Order
int FusionCatalogueId
FusionCatalogueVersion FusionCatalogue
int? StyleCollectionId
StyleCollection StyleCollection
ICollection<SelectedSelectionValue> SelectedSelectionValues
ICollection<Unit> Units
string Name
---
StyleCollection:
string Name
int ProjectId
Project Project
ICollection<Design> Designs
ICollection<Style> Styles
---
Tag:
string Text
ICollection<TagDesign> TagDesigns
ManyToManyCollection<Tag, TagDesign, Design> Designs
---
TagDesign:
int Tag_Id
Tag Tag
int Design_Id
Design Design
---
User:
int Timeout
string Username
string PasswordHash
string Email
DateTime LastActivity
bool IsLoggedIn
int CustomerId
Customer Customer
IsLoggedInValidly
---
VariableValue:
string Value
int ProjectId
Project Project
int VariableId
ScriptVariable Variable