Raporttimuuttujat

YLEISIMMÄT:

Project:

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
Dictionary<string, CustomFieldValue?> CF - Tilauksen lisäkentät

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