metadata

{"?xml":{"version":"1.0","encoding":"utf-8"},"schema":{"namespace":"ProvSysModel","alias":"Self","p1:UseStrongSpatialTypes":"false","xmlns:annotation":"http://schemas.microsoft.com/ado/2009/02/edm/annotation","xmlns:p1":"http://schemas.microsoft.com/ado/2009/02/edm/annotation","xmlns":"http://schemas.microsoft.com/ado/2009/11/edm","cSpaceOSpaceMapping":"[[\"ProvSysModel.tblBonuses\",\"ProvSys.Models.tblBonuses\"],[\"ProvSysModel.tblCompensations\",\"ProvSys.Models.tblCompensations\"],[\"ProvSysModel.tblConditions\",\"ProvSys.Models.tblConditions\"],[\"ProvSysModel.tblCustomerTypes\",\"ProvSys.Models.tblCustomerTypes\"],[\"ProvSysModel.tblDiscountTypes\",\"ProvSys.Models.tblDiscountTypes\"],[\"ProvSysModel.tblEmployees\",\"ProvSys.Models.tblEmployees\"],[\"ProvSysModel.tblImporterDiscounts\",\"ProvSys.Models.tblImporterDiscounts\"],[\"ProvSysModel.tblSalarySettings\",\"ProvSys.Models.tblSalarySettings\"],[\"ProvSysModel.tblSalesChannels\",\"ProvSys.Models.tblSalesChannels\"],[\"ProvSysModel.tblSpecialBonuses\",\"ProvSys.Models.tblSpecialBonuses\"],[\"ProvSysModel.tblTargets\",\"ProvSys.Models.tblTargets\"],[\"ProvSysModel.tblTransactions\",\"ProvSys.Models.tblTransactions\"],[\"ProvSysModel.tblVehicleModels\",\"ProvSys.Models.tblVehicleModels\"],[\"ProvSysModel.tblVehicleTypes\",\"ProvSys.Models.tblVehicleTypes\"],[\"ProvSysModel.tblCampaignTypes\",\"ProvSys.Models.tblCampaignTypes\"],[\"ProvSysModel.tblTransactionImporterDiscounts\",\"ProvSys.Models.tblTransactionImporterDiscounts\"]]","entityContainer":{"name":"ProvSysEntities","p1:LazyLoadingEnabled":"true","entitySet":[{"name":"tblBonuses","entityType":"ProvSysModel.tblBonuses"},{"name":"tblCompensations","entityType":"ProvSysModel.tblCompensations"},{"name":"tblConditions","entityType":"ProvSysModel.tblConditions"},{"name":"tblCustomerTypes","entityType":"ProvSysModel.tblCustomerTypes"},{"name":"tblDiscountTypes","entityType":"ProvSysModel.tblDiscountTypes"},{"name":"tblEmployees","entityType":"ProvSysModel.tblEmployees"},{"name":"tblImporterDiscounts","entityType":"ProvSysModel.tblImporterDiscounts"},{"name":"tblSalarySettings","entityType":"ProvSysModel.tblSalarySettings"},{"name":"tblSalesChannels","entityType":"ProvSysModel.tblSalesChannels"},{"name":"tblSpecialBonuses","entityType":"ProvSysModel.tblSpecialBonuses"},{"name":"tblTargets","entityType":"ProvSysModel.tblTargets"},{"name":"tblTransactions","entityType":"ProvSysModel.tblTransactions"},{"name":"tblVehicleModels","entityType":"ProvSysModel.tblVehicleModels"},{"name":"tblVehicleTypes","entityType":"ProvSysModel.tblVehicleTypes"},{"name":"tblCampaignTypes","entityType":"ProvSysModel.tblCampaignTypes"},{"name":"tblTransactionImporterDiscounts","entityType":"ProvSysModel.tblTransactionImporterDiscounts"}],"associationSet":[{"name":"FK_tblBonuses_tblEmployees","association":"ProvSysModel.FK_tblBonuses_tblEmployees","end":[{"role":"tblEmployees","entitySet":"tblEmployees"},{"role":"tblBonuses","entitySet":"tblBonuses"}]},{"name":"FK_tblCompensations_tblEmployees","association":"ProvSysModel.FK_tblCompensations_tblEmployees","end":[{"role":"tblEmployees","entitySet":"tblEmployees"},{"role":"tblCompensations","entitySet":"tblCompensations"}]},{"name":"FK_tblConditions_tblEmployees","association":"ProvSysModel.FK_tblConditions_tblEmployees","end":[{"role":"tblEmployees","entitySet":"tblEmployees"},{"role":"tblConditions","entitySet":"tblConditions"}]},{"name":"FK_tblTransactions_tblCustomerTypes","association":"ProvSysModel.FK_tblTransactions_tblCustomerTypes","end":[{"role":"tblCustomerTypes","entitySet":"tblCustomerTypes"},{"role":"tblTransactions","entitySet":"tblTransactions"}]},{"name":"FK_tblSalarySettings_tblEmployees","association":"ProvSysModel.FK_tblSalarySettings_tblEmployees","end":[{"role":"tblEmployees","entitySet":"tblEmployees"},{"role":"tblSalarySettings","entitySet":"tblSalarySettings"}]},{"name":"FK_tblSpecialBonuses_tblEmployees","association":"ProvSysModel.FK_tblSpecialBonuses_tblEmployees","end":[{"role":"tblEmployees","entitySet":"tblEmployees"},{"role":"tblSpecialBonuses","entitySet":"tblSpecialBonuses"}]},{"name":"FK_tblTargets_tblEmployees","association":"ProvSysModel.FK_tblTargets_tblEmployees","end":[{"role":"tblEmployees","entitySet":"tblEmployees"},{"role":"tblTargets","entitySet":"tblTargets"}]},{"name":"FK_tblTransactions_tblEmployees","association":"ProvSysModel.FK_tblTransactions_tblEmployees","end":[{"role":"tblEmployees","entitySet":"tblEmployees"},{"role":"tblTransactions","entitySet":"tblTransactions"}]},{"name":"FK_tblTransactions_tblEmployees1","association":"ProvSysModel.FK_tblTransactions_tblEmployees1","end":[{"role":"tblEmployees","entitySet":"tblEmployees"},{"role":"tblTransactions","entitySet":"tblTransactions"}]},{"name":"FK_tblTransactions_tblSalesChannels","association":"ProvSysModel.FK_tblTransactions_tblSalesChannels","end":[{"role":"tblSalesChannels","entitySet":"tblSalesChannels"},{"role":"tblTransactions","entitySet":"tblTransactions"}]},{"name":"FK_tblTransactions_tblVehicleModels","association":"ProvSysModel.FK_tblTransactions_tblVehicleModels","end":[{"role":"tblVehicleModels","entitySet":"tblVehicleModels"},{"role":"tblTransactions","entitySet":"tblTransactions"}]},{"name":"FK_tblTransactions_tblVehicleTypes","association":"ProvSysModel.FK_tblTransactions_tblVehicleTypes","end":[{"role":"tblVehicleTypes","entitySet":"tblVehicleTypes"},{"role":"tblTransactions","entitySet":"tblTransactions"}]},{"name":"FK_tblTransactions_tblDiscountTypes","association":"ProvSysModel.FK_tblTransactions_tblDiscountTypes","end":[{"role":"tblDiscountTypes","entitySet":"tblDiscountTypes"},{"role":"tblTransactions","entitySet":"tblTransactions"}]},{"name":"FK_tblTransactionDiscounts_tblCampainTypes","association":"ProvSysModel.FK_tblTransactionDiscounts_tblCampainTypes","end":[{"role":"tblCampaignTypes","entitySet":"tblCampaignTypes"},{"role":"tblTransactionImporterDiscounts","entitySet":"tblTransactionImporterDiscounts"}]},{"name":"FK_tblTransactionDiscounts_tblImporterDiscounts","association":"ProvSysModel.FK_tblTransactionDiscounts_tblImporterDiscounts","end":[{"role":"tblImporterDiscounts","entitySet":"tblImporterDiscounts"},{"role":"tblTransactionImporterDiscounts","entitySet":"tblTransactionImporterDiscounts"}]},{"name":"FK_tblTransactionImporterDiscounts_tblTransactions","association":"ProvSysModel.FK_tblTransactionImporterDiscounts_tblTransactions","end":[{"role":"tblTransactions","entitySet":"tblTransactions"},{"role":"tblTransactionImporterDiscounts","entitySet":"tblTransactionImporterDiscounts"}]}]},"entityType":[{"name":"tblBonuses","key":{"propertyRef":{"name":"IDBonus"}},"property":[{"name":"IDBonus","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"BonusValue","type":"Edm.Decimal","nullable":"false","precision":"19","scale":"6"},{"name":"BonusDescription","type":"Edm.String","nullable":"false","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"IDEmployee","type":"Edm.Int32","nullable":"false"},{"name":"Month","type":"Edm.Int32","nullable":"false"},{"name":"Year","type":"Edm.Int32","nullable":"false"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblBonuses_tblEmployees","fromRole":"tblBonuses","toRole":"tblEmployees"}},{"name":"tblCompensations","key":{"propertyRef":{"name":"IDCompensation"}},"property":[{"name":"IDCompensation","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"IDEmployee","type":"Edm.Int32","nullable":"false"},{"name":"Month","type":"Edm.Int32","nullable":"false"},{"name":"Year","type":"Edm.Int32","nullable":"false"},{"name":"NrOfDaysHoliday","type":"Edm.Int32","nullable":"false"},{"name":"NrOfDaysIlness","type":"Edm.Int32","nullable":"false"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblCompensations_tblEmployees","fromRole":"tblCompensations","toRole":"tblEmployees"}},{"name":"tblConditions","key":{"propertyRef":{"name":"IDCondition"}},"property":[{"name":"IDCondition","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"IDEmployee","type":"Edm.Int32","nullable":"false"},{"name":"Value1","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"Value2","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"Value3","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"Value4","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"Value5","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"Value6","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"FromYear","type":"Edm.Int32","nullable":"false"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblConditions_tblEmployees","fromRole":"tblConditions","toRole":"tblEmployees"}},{"name":"tblCustomerTypes","key":{"propertyRef":{"name":"IDCustomerType"}},"property":[{"name":"IDCustomerType","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"CustomerType","type":"Edm.String","nullable":"false","maxLength":"50","unicode":"false","fixedLength":"false"},{"name":"FixProvision","type":"Edm.Decimal","nullable":"false","precision":"19","scale":"6"}],"navigationProperty":{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactions_tblCustomerTypes","fromRole":"tblCustomerTypes","toRole":"tblTransactions"}},{"name":"tblDiscountTypes","key":{"propertyRef":{"name":"IDDiscountType"}},"property":[{"name":"IDDiscountType","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"DiscountType","type":"Edm.String","nullable":"false","maxLength":"50","unicode":"false","fixedLength":"false"}],"navigationProperty":{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactions_tblDiscountTypes","fromRole":"tblDiscountTypes","toRole":"tblTransactions"}},{"name":"tblEmployees","key":{"propertyRef":{"name":"IDEmployee"}},"property":[{"name":"IDEmployee","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"IDEmpNoCompany","type":"Edm.String","nullable":"false","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"FirstName","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false","defaultValue":"admin: Vorname","concurrencyMode":"None","p1:StoreGeneratedPattern":"Computed"},{"name":"LastName","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false","defaultValue":"admin: Nachname"},{"type":"Edm.String","name":"ResetPassword","maxLength":"50","fixedLength":"false","unicode":"true","defaultValue":""},{"type":"Edm.String","name":"Role","maxLength":"50","fixedLength":"false","unicode":"true","nullable":"false","defaultValue":"sales"},{"type":"Edm.String","name":"CalculationMethod","nullable":"false","maxLength":"2","fixedLength":"false","unicode":"true"}],"navigationProperty":[{"name":"tblBonuses","relationship":"ProvSysModel.FK_tblBonuses_tblEmployees","fromRole":"tblEmployees","toRole":"tblBonuses"},{"name":"tblCompensations","relationship":"ProvSysModel.FK_tblCompensations_tblEmployees","fromRole":"tblEmployees","toRole":"tblCompensations"},{"name":"tblConditions","relationship":"ProvSysModel.FK_tblConditions_tblEmployees","fromRole":"tblEmployees","toRole":"tblConditions"},{"name":"tblSalarySettings","relationship":"ProvSysModel.FK_tblSalarySettings_tblEmployees","fromRole":"tblEmployees","toRole":"tblSalarySettings"},{"name":"tblSpecialBonuses","relationship":"ProvSysModel.FK_tblSpecialBonuses_tblEmployees","fromRole":"tblEmployees","toRole":"tblSpecialBonuses"},{"name":"tblTargets","relationship":"ProvSysModel.FK_tblTargets_tblEmployees","fromRole":"tblEmployees","toRole":"tblTargets"},{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactions_tblEmployees","fromRole":"tblEmployees","toRole":"tblTransactions"},{"name":"tblTransactions1","relationship":"ProvSysModel.FK_tblTransactions_tblEmployees1","fromRole":"tblEmployees","toRole":"tblTransactions"}]},{"name":"tblImporterDiscounts","key":{"propertyRef":{"name":"IDImporterDiscount"}},"property":[{"name":"IDImporterDiscount","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"ImporterDiscount","type":"Edm.String","nullable":"false","maxLength":"50","unicode":"true","fixedLength":"false"},{"type":"Edm.Boolean","name":"IsSpecialDiscount","nullable":"false"}],"navigationProperty":{"name":"tblTransactionImporterDiscounts","relationship":"ProvSysModel.FK_tblTransactionDiscounts_tblImporterDiscounts","fromRole":"tblImporterDiscounts","toRole":"tblTransactionImporterDiscounts"}},{"name":"tblSalarySettings","key":{"propertyRef":{"name":"IDSalarySetting"}},"property":[{"name":"IDSalarySetting","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"FromMonth","type":"Edm.Int32","nullable":"false"},{"name":"FromYear","type":"Edm.Int32","nullable":"false"},{"name":"IDEmployee","type":"Edm.Int32","nullable":"false"},{"name":"BaseSalary","type":"Edm.Decimal","nullable":"false","precision":"19","scale":"6"},{"name":"MinimumSalary","type":"Edm.Decimal","nullable":"false","precision":"19","scale":"6"},{"name":"CompensationValue","type":"Edm.Decimal","nullable":"false","precision":"19","scale":"6"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblSalarySettings_tblEmployees","fromRole":"tblSalarySettings","toRole":"tblEmployees"}},{"name":"tblSalesChannels","key":{"propertyRef":{"name":"IDSalesChannel"}},"property":[{"name":"IDSalesChannel","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.String","name":"SalesChannel","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"true"}],"navigationProperty":{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactions_tblSalesChannels","fromRole":"tblSalesChannels","toRole":"tblTransactions"}},{"name":"tblSpecialBonuses","key":{"propertyRef":{"name":"IDSpecialBonus"}},"property":[{"name":"IDSpecialBonus","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"IDEmployee","type":"Edm.Int32","nullable":"false"},{"name":"SpecialBonusValue","type":"Edm.Decimal","nullable":"false","precision":"19","scale":"6"},{"name":"SpecialBonusDescription","type":"Edm.String","nullable":"false","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"Month","type":"Edm.Int32","nullable":"false"},{"name":"Year","type":"Edm.Int32","nullable":"false"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblSpecialBonuses_tblEmployees","fromRole":"tblSpecialBonuses","toRole":"tblEmployees"}},{"name":"tblTargets","key":{"propertyRef":{"name":"IDTarget"}},"property":[{"name":"IDTarget","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"IDEmployee","type":"Edm.Int32","nullable":"false"},{"name":"Month","type":"Edm.Int32","nullable":"false"},{"name":"Year","type":"Edm.Int32","nullable":"false"},{"name":"QuantityNewVehicles","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"QuantityUsedVehicles","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"Revenue","type":"Edm.Decimal","precision":"19","scale":"6"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblTargets_tblEmployees","fromRole":"tblTargets","toRole":"tblEmployees"}},{"name":"tblTransactions","key":{"propertyRef":{"name":"IDTransaction"}},"property":[{"name":"IDTransaction","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"IDEmployee","type":"Edm.Int32","nullable":"false"},{"name":"CustomerFirstName","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"CustomerLastName","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"IDCustomerType","type":"Edm.Int32","nullable":"false"},{"name":"IDVehicleType","type":"Edm.Int32","nullable":"false"},{"name":"IDVehicleModel","type":"Edm.Int32","nullable":"false"},{"name":"VehicleFreeText","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"IDSalesChannel","type":"Edm.Int32","nullable":"false"},{"name":"ChassisNumber","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"OrderNumber","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"ContractDate","type":"Edm.DateTime","nullable":"false","precision":"0"},{"name":"DeliveryDate","type":"Edm.DateTime","precision":"0"},{"name":"PaymentDate","type":"Edm.DateTime","precision":"0"},{"name":"PriceModel","type":"Edm.String","maxLength":"2","unicode":"true","fixedLength":"false"},{"name":"ListPrice","type":"Edm.Decimal","nullable":"false","precision":"19","scale":"6"},{"name":"Extras","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"OtherExtras","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"OtherExtrasDescription","type":"Edm.String","maxLength":"250","unicode":"true","fixedLength":"false"},{"name":"DeliveryFixPrice","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"Discount","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"FreeExtras","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"FreeExtrasDescription","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"ExchangedVehicleType","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"ExchangedChassisNumber","type":"Edm.String","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"ExchangedVehicleSalesPrice","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"IDParticipator","type":"Edm.Int32"},{"name":"TypeOfParticipation","type":"Edm.String","maxLength":"2","unicode":"true","fixedLength":"false"},{"name":"AffectsProvision","type":"Edm.Boolean"},{"name":"AffectsQuantity","type":"Edm.Boolean"},{"name":"DocumentsReceived","type":"Edm.Boolean"},{"name":"C_CompletePrice","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"C_EstimateExceeded","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"C_TotalDiscountValue","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"C_GrossPrice","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"C_TotalDiscountPercent","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"M_TurnoverCorrectionFactor","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"M_ProvisionRelevantTurnoverVehicle","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"M_TotalTurnoverExtras","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"M_TotalDiscountExtrasPercent","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"M_TurnoverMultiplicator","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"M_ProvisionRelevantTurnoverExtras","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"M_ProvisionRelevantTurnoverTotal","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"A_ProvisionParticipation","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"A_ProvisionFactor","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"A_ProvisionTurnover","type":"Edm.Decimal","precision":"19","scale":"6"},{"name":"A_ProvisionTotal","type":"Edm.Decimal","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"ExchangedVehiclePrice","precision":"19","scale":"6"},{"type":"Edm.String","name":"ExCustomer","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"Comments","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"EuroplusNumber","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"Financing","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.Boolean","name":"ProvisionChecked"},{"type":"Edm.Int32","name":"IDDiscountType","nullable":"false"},{"type":"Edm.Decimal","name":"C_ImportDiscountTotal","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"C_ImportSpecialDiscountTotal","precision":"19","scale":"6"}],"navigationProperty":[{"name":"tblCustomerTypes","relationship":"ProvSysModel.FK_tblTransactions_tblCustomerTypes","fromRole":"tblTransactions","toRole":"tblCustomerTypes"},{"name":"tblEmployees1","relationship":"ProvSysModel.FK_tblTransactions_tblEmployees","fromRole":"tblTransactions","toRole":"tblEmployees"},{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblTransactions_tblEmployees1","fromRole":"tblTransactions","toRole":"tblEmployees"},{"name":"tblSalesChannels","relationship":"ProvSysModel.FK_tblTransactions_tblSalesChannels","fromRole":"tblTransactions","toRole":"tblSalesChannels"},{"name":"tblVehicleModels","relationship":"ProvSysModel.FK_tblTransactions_tblVehicleModels","fromRole":"tblTransactions","toRole":"tblVehicleModels"},{"name":"tblVehicleTypes","relationship":"ProvSysModel.FK_tblTransactions_tblVehicleTypes","fromRole":"tblTransactions","toRole":"tblVehicleTypes"},{"name":"tblDiscountTypes","relationship":"ProvSysModel.FK_tblTransactions_tblDiscountTypes","fromRole":"tblTransactions","toRole":"tblDiscountTypes"},{"name":"tblTransactionImporterDiscounts","relationship":"ProvSysModel.FK_tblTransactionImporterDiscounts_tblTransactions","fromRole":"tblTransactions","toRole":"tblTransactionImporterDiscounts"}]},{"name":"tblVehicleModels","key":{"propertyRef":{"name":"IDVehicleModel"}},"property":[{"name":"IDVehicleModel","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"Category","type":"Edm.String","nullable":"false","maxLength":"50","unicode":"true","fixedLength":"false"},{"name":"Brand","type":"Edm.String","nullable":"false","maxLength":"50","unicode":"true","fixedLength":"false"}],"navigationProperty":{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactions_tblVehicleModels","fromRole":"tblVehicleModels","toRole":"tblTransactions"}},{"name":"tblVehicleTypes","key":{"propertyRef":{"name":"IDVehicleType"}},"property":[{"name":"IDVehicleType","type":"Edm.Int32","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"name":"Type","type":"Edm.String","nullable":"false","maxLength":"50","unicode":"true","fixedLength":"false"}],"navigationProperty":{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactions_tblVehicleTypes","fromRole":"tblVehicleTypes","toRole":"tblTransactions"}},{"name":"tblCampaignTypes","key":{"propertyRef":{"name":"IDCampaignType"}},"property":[{"type":"Edm.Int32","name":"IDCampaignType","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.String","name":"CampaignType","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"true"}],"navigationProperty":{"name":"tblTransactionImporterDiscounts","relationship":"ProvSysModel.FK_tblTransactionDiscounts_tblCampainTypes","fromRole":"tblCampaignTypes","toRole":"tblTransactionImporterDiscounts"}},{"name":"tblTransactionImporterDiscounts","key":{"propertyRef":{"name":"IDTransactionImporterDiscount"}},"property":[{"type":"Edm.Int32","name":"IDTransactionImporterDiscount","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Int32","name":"IDImporterDiscount","nullable":"false"},{"type":"Edm.Int32","name":"IDCampaignType","nullable":"false"},{"type":"Edm.String","name":"CampaignText","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.Decimal","name":"Discount","precision":"19","scale":"6"},{"type":"Edm.Int32","name":"IDTransaction","nullable":"false"},{"type":"Edm.DateTime","name":"ReceivedOn","precision":"0"}],"navigationProperty":[{"name":"tblCampaignTypes","relationship":"ProvSysModel.FK_tblTransactionDiscounts_tblCampainTypes","fromRole":"tblTransactionImporterDiscounts","toRole":"tblCampaignTypes"},{"name":"tblImporterDiscounts","relationship":"ProvSysModel.FK_tblTransactionDiscounts_tblImporterDiscounts","fromRole":"tblTransactionImporterDiscounts","toRole":"tblImporterDiscounts"},{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactionImporterDiscounts_tblTransactions","fromRole":"tblTransactionImporterDiscounts","toRole":"tblTransactions"}]}],"association":[{"name":"FK_tblBonuses_tblEmployees","end":[{"role":"tblEmployees","type":"Edm.ProvSysModel.tblEmployees","multiplicity":"1"},{"role":"tblBonuses","type":"Edm.ProvSysModel.tblBonuses","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblBonuses","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblCompensations_tblEmployees","end":[{"role":"tblEmployees","type":"Edm.ProvSysModel.tblEmployees","multiplicity":"1"},{"role":"tblCompensations","type":"Edm.ProvSysModel.tblCompensations","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblCompensations","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblConditions_tblEmployees","end":[{"role":"tblEmployees","type":"Edm.ProvSysModel.tblEmployees","multiplicity":"1"},{"role":"tblConditions","type":"Edm.ProvSysModel.tblConditions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblConditions","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblTransactions_tblCustomerTypes","end":[{"role":"tblCustomerTypes","type":"Edm.ProvSysModel.tblCustomerTypes","multiplicity":"1"},{"role":"tblTransactions","type":"Edm.ProvSysModel.tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblCustomerTypes","propertyRef":{"name":"IDCustomerType"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDCustomerType"}}}},{"name":"FK_tblSalarySettings_tblEmployees","end":[{"role":"tblEmployees","type":"Edm.ProvSysModel.tblEmployees","multiplicity":"1"},{"role":"tblSalarySettings","type":"Edm.ProvSysModel.tblSalarySettings","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblSalarySettings","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblSpecialBonuses_tblEmployees","end":[{"role":"tblEmployees","type":"Edm.ProvSysModel.tblEmployees","multiplicity":"1"},{"role":"tblSpecialBonuses","type":"Edm.ProvSysModel.tblSpecialBonuses","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblSpecialBonuses","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblTargets_tblEmployees","end":[{"role":"tblEmployees","type":"Edm.ProvSysModel.tblEmployees","multiplicity":"1"},{"role":"tblTargets","type":"Edm.ProvSysModel.tblTargets","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblTargets","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblTransactions_tblEmployees","end":[{"role":"tblEmployees","type":"Edm.ProvSysModel.tblEmployees","multiplicity":"0..1"},{"role":"tblTransactions","type":"Edm.ProvSysModel.tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDParticipator"}}}},{"name":"FK_tblTransactions_tblEmployees1","end":[{"role":"tblEmployees","type":"Edm.ProvSysModel.tblEmployees","multiplicity":"1"},{"role":"tblTransactions","type":"Edm.ProvSysModel.tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblTransactions_tblSalesChannels","end":[{"role":"tblSalesChannels","type":"Edm.ProvSysModel.tblSalesChannels","multiplicity":"1"},{"role":"tblTransactions","type":"Edm.ProvSysModel.tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblSalesChannels","propertyRef":{"name":"IDSalesChannel"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDSalesChannel"}}}},{"name":"FK_tblTransactions_tblVehicleModels","end":[{"role":"tblVehicleModels","type":"Edm.ProvSysModel.tblVehicleModels","multiplicity":"1"},{"role":"tblTransactions","type":"Edm.ProvSysModel.tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblVehicleModels","propertyRef":{"name":"IDVehicleModel"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDVehicleModel"}}}},{"name":"FK_tblTransactions_tblVehicleTypes","end":[{"role":"tblVehicleTypes","type":"Edm.ProvSysModel.tblVehicleTypes","multiplicity":"1"},{"role":"tblTransactions","type":"Edm.ProvSysModel.tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblVehicleTypes","propertyRef":{"name":"IDVehicleType"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDVehicleType"}}}},{"name":"FK_tblTransactions_tblDiscountTypes","end":[{"type":"Edm.ProvSysModel.tblDiscountTypes","role":"tblDiscountTypes","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblTransactions","role":"tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblDiscountTypes","propertyRef":{"name":"IDDiscountType"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDDiscountType"}}}},{"name":"FK_tblTransactionDiscounts_tblCampainTypes","end":[{"type":"Edm.ProvSysModel.tblCampaignTypes","role":"tblCampaignTypes","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblTransactionImporterDiscounts","role":"tblTransactionImporterDiscounts","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblCampaignTypes","propertyRef":{"name":"IDCampaignType"}},"dependent":{"role":"tblTransactionImporterDiscounts","propertyRef":{"name":"IDCampaignType"}}}},{"name":"FK_tblTransactionDiscounts_tblImporterDiscounts","end":[{"type":"Edm.ProvSysModel.tblImporterDiscounts","role":"tblImporterDiscounts","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblTransactionImporterDiscounts","role":"tblTransactionImporterDiscounts","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblImporterDiscounts","propertyRef":{"name":"IDImporterDiscount"}},"dependent":{"role":"tblTransactionImporterDiscounts","propertyRef":{"name":"IDImporterDiscount"}}}},{"name":"FK_tblTransactionImporterDiscounts_tblTransactions","end":[{"type":"Edm.ProvSysModel.tblTransactions","role":"tblTransactions","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblTransactionImporterDiscounts","role":"tblTransactionImporterDiscounts","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblTransactions","propertyRef":{"name":"IDTransaction"}},"dependent":{"role":"tblTransactionImporterDiscounts","propertyRef":{"name":"IDTransaction"}}}}]}}