{"?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.tblCampaignTypes\",\"ProvSys.Models.tblCampaignTypes\"],[\"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.tblTransactionImporterDiscounts\",\"ProvSys.Models.tblTransactionImporterDiscounts\"],[\"ProvSysModel.tblTransactions\",\"ProvSys.Models.tblTransactions\"],[\"ProvSysModel.tblVehicleModels\",\"ProvSys.Models.tblVehicleModels\"],[\"ProvSysModel.webpages_Membership\",\"ProvSys.Models.webpages_Membership\"],[\"ProvSysModel.webpages_OAuthMembership\",\"ProvSys.Models.webpages_OAuthMembership\"],[\"ProvSysModel.webpages_Roles\",\"ProvSys.Models.webpages_Roles\"],[\"ProvSysModel.tblGlobalSettings\",\"ProvSys.Models.tblGlobalSettings\"]]","entityContainer":{"name":"ProvSysEntities","p1:LazyLoadingEnabled":"true","entitySet":[{"name":"tblBonuses","entityType":"ProvSysModel.tblBonuses"},{"name":"tblCampaignTypes","entityType":"ProvSysModel.tblCampaignTypes"},{"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":"tblTransactionImporterDiscounts","entityType":"ProvSysModel.tblTransactionImporterDiscounts"},{"name":"tblTransactions","entityType":"ProvSysModel.tblTransactions"},{"name":"tblVehicleModels","entityType":"ProvSysModel.tblVehicleModels"},{"name":"webpages_Membership","entityType":"ProvSysModel.webpages_Membership"},{"name":"webpages_OAuthMembership","entityType":"ProvSysModel.webpages_OAuthMembership"},{"name":"webpages_Roles","entityType":"ProvSysModel.webpages_Roles"},{"name":"tblGlobalSettings","entityType":"ProvSysModel.tblGlobalSettings"}],"associationSet":[{"name":"FK_tblBonuses_tblEmployees","association":"ProvSysModel.FK_tblBonuses_tblEmployees","end":[{"role":"tblEmployees","entitySet":"tblEmployees"},{"role":"tblBonuses","entitySet":"tblBonuses"}]},{"name":"FK_tblTransactionDiscounts_tblCampainTypes","association":"ProvSysModel.FK_tblTransactionDiscounts_tblCampainTypes","end":[{"role":"tblCampaignTypes","entitySet":"tblCampaignTypes"},{"role":"tblTransactionImporterDiscounts","entitySet":"tblTransactionImporterDiscounts"}]},{"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_tblTransactions_tblDiscountTypes","association":"ProvSysModel.FK_tblTransactions_tblDiscountTypes","end":[{"role":"tblDiscountTypes","entitySet":"tblDiscountTypes"},{"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_tblTransactionDiscounts_tblImporterDiscounts","association":"ProvSysModel.FK_tblTransactionDiscounts_tblImporterDiscounts","end":[{"role":"tblImporterDiscounts","entitySet":"tblImporterDiscounts"},{"role":"tblTransactionImporterDiscounts","entitySet":"tblTransactionImporterDiscounts"}]},{"name":"FK_tblTransactions_tblSalesChannels","association":"ProvSysModel.FK_tblTransactions_tblSalesChannels","end":[{"role":"tblSalesChannels","entitySet":"tblSalesChannels"},{"role":"tblTransactions","entitySet":"tblTransactions"}]},{"name":"FK_tblTransactionImporterDiscounts_tblTransactions","association":"ProvSysModel.FK_tblTransactionImporterDiscounts_tblTransactions","end":[{"role":"tblTransactions","entitySet":"tblTransactions"},{"role":"tblTransactionImporterDiscounts","entitySet":"tblTransactionImporterDiscounts"}]},{"name":"webpages_UsersInRoles","association":"ProvSysModel.webpages_UsersInRoles","end":[{"role":"webpages_Roles","entitySet":"webpages_Roles"},{"role":"tblEmployees","entitySet":"tblEmployees"}]},{"name":"FK_tblTransactions_tblVehicleModels","association":"ProvSysModel.FK_tblTransactions_tblVehicleModels","end":[{"role":"tblVehicleModels","entitySet":"tblVehicleModels"},{"role":"tblTransactions","entitySet":"tblTransactions"}]}]},"entityType":[{"name":"tblBonuses","key":{"propertyRef":{"name":"IDBonus"}},"property":[{"type":"Edm.Int32","name":"IDBonus","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Decimal","name":"BonusValue","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.String","name":"BonusDescription","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.Int32","name":"IDEmployee","nullable":"false"},{"type":"Edm.Int32","name":"Month","nullable":"false"},{"type":"Edm.Int32","name":"Year","nullable":"false"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblBonuses_tblEmployees","fromRole":"tblBonuses","toRole":"tblEmployees"}},{"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":"tblCompensations","key":{"propertyRef":{"name":"IDCompensation"}},"property":[{"type":"Edm.Int32","name":"IDCompensation","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Int32","name":"IDEmployee","nullable":"false"},{"type":"Edm.Int32","name":"Month","nullable":"false"},{"type":"Edm.Int32","name":"Year","nullable":"false"},{"type":"Edm.Int32","name":"NrOfDaysHoliday","nullable":"false"},{"type":"Edm.Int32","name":"NrOfDaysIlness","nullable":"false"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblCompensations_tblEmployees","fromRole":"tblCompensations","toRole":"tblEmployees"}},{"name":"tblConditions","key":{"propertyRef":{"name":"IDCondition"}},"property":[{"type":"Edm.Int32","name":"IDCondition","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Int32","name":"IDEmployee","nullable":"false"},{"type":"Edm.Int32","name":"FromYear","nullable":"false"},{"type":"Edm.Decimal","name":"A_MinNewVehicle","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"A_MinUsedVehicle","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_MaxTargetRatio","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_MaxProvision","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_BonusBase","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_Exponent","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_ZeroOffset","nullable":"false","precision":"19","scale":"6"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblConditions_tblEmployees","fromRole":"tblConditions","toRole":"tblEmployees"}},{"name":"tblCustomerTypes","key":{"propertyRef":{"name":"IDCustomerType"}},"property":[{"type":"Edm.Int32","name":"IDCustomerType","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.String","name":"CustomerType","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"false"}],"navigationProperty":{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactions_tblCustomerTypes","fromRole":"tblCustomerTypes","toRole":"tblTransactions"}},{"name":"tblDiscountTypes","key":{"propertyRef":{"name":"IDDiscountType"}},"property":[{"type":"Edm.Int32","name":"IDDiscountType","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.String","name":"DiscountType","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"false"}],"navigationProperty":{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactions_tblDiscountTypes","fromRole":"tblDiscountTypes","toRole":"tblTransactions"}},{"name":"tblEmployees","key":{"propertyRef":{"name":"IDEmployee"}},"property":[{"type":"Edm.Int32","name":"IDEmployee","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.String","name":"IDEmpNoCompany","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"FirstName","maxLength":"50","fixedLength":"false","unicode":"true","nullable":"false"},{"type":"Edm.String","name":"LastName","maxLength":"50","fixedLength":"false","unicode":"true","nullable":"false"},{"type":"Edm.String","name":"ResetPassword","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"Role","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"CalculationMethod","nullable":"false","maxLength":"2","fixedLength":"false","unicode":"true"},{"type":"Edm.Boolean","name":"Deleted","nullable":"false"}],"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":"webpages_Roles","relationship":"ProvSysModel.webpages_UsersInRoles","fromRole":"tblEmployees","toRole":"webpages_Roles"}]},{"name":"tblImporterDiscounts","key":{"propertyRef":{"name":"IDImporterDiscount"}},"property":[{"type":"Edm.Int32","name":"IDImporterDiscount","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Boolean","name":"IsSpecialDiscount","nullable":"false"},{"type":"Edm.String","name":"ImporterDiscount","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"true"}],"navigationProperty":{"name":"tblTransactionImporterDiscounts","relationship":"ProvSysModel.FK_tblTransactionDiscounts_tblImporterDiscounts","fromRole":"tblImporterDiscounts","toRole":"tblTransactionImporterDiscounts"}},{"name":"tblSalarySettings","key":{"propertyRef":{"name":"IDSalarySetting"}},"property":[{"type":"Edm.Int32","name":"IDSalarySetting","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Int32","name":"FromMonth","nullable":"false"},{"type":"Edm.Int32","name":"FromYear","nullable":"false"},{"type":"Edm.Int32","name":"IDEmployee","nullable":"false"},{"type":"Edm.Decimal","name":"BaseSalary","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"MinimumSalary","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"CompensationValue","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":[{"type":"Edm.Int32","name":"IDSalesChannel","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":[{"type":"Edm.Int32","name":"IDSpecialBonus","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Int32","name":"IDEmployee","nullable":"false"},{"type":"Edm.Decimal","name":"SpecialBonusValue","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.String","name":"SpecialBonusDescription","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.Int32","name":"Month","nullable":"false"},{"type":"Edm.Int32","name":"Year","nullable":"false"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblSpecialBonuses_tblEmployees","fromRole":"tblSpecialBonuses","toRole":"tblEmployees"}},{"name":"tblTargets","key":{"propertyRef":{"name":"IDTarget"}},"property":[{"type":"Edm.Int32","name":"IDTarget","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Int32","name":"IDEmployee","nullable":"false"},{"type":"Edm.Int32","name":"Month","nullable":"false"},{"type":"Edm.Int32","name":"Year","nullable":"false"},{"type":"Edm.Decimal","name":"QuantityNewVehicles","precision":"19","scale":"6","nullable":"false"},{"type":"Edm.Decimal","name":"QuantityUsedVehicles","precision":"19","scale":"6","nullable":"false"},{"type":"Edm.Decimal","name":"Revenue","precision":"19","scale":"6","nullable":"false"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblTargets_tblEmployees","fromRole":"tblTargets","toRole":"tblEmployees"}},{"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","nullable":"false","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"}]},{"name":"tblTransactions","key":{"propertyRef":{"name":"IDTransaction"}},"property":[{"type":"Edm.Int32","name":"IDTransaction","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Int32","name":"IDEmployee","nullable":"false"},{"type":"Edm.String","name":"CustomerFirstName","maxLength":"50","fixedLength":"false","unicode":"true","nullable":"false"},{"type":"Edm.String","name":"CustomerLastName","maxLength":"50","fixedLength":"false","unicode":"true","nullable":"false"},{"type":"Edm.Int32","name":"IDCustomerType","nullable":"false"},{"type":"Edm.String","name":"VehicleType","nullable":"false","maxLength":"3","fixedLength":"false","unicode":"true"},{"type":"Edm.Int32","name":"IDVehicleModel","nullable":"false"},{"type":"Edm.String","name":"VehicleFreeText","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.Int32","name":"IDSalesChannel","nullable":"false"},{"type":"Edm.String","name":"ChassisNumber","maxLength":"50","fixedLength":"false","unicode":"true","nullable":"false"},{"type":"Edm.String","name":"OrderNumber","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.DateTime","name":"ContractDate","nullable":"false","precision":"0"},{"type":"Edm.DateTime","name":"DeliveryDate","precision":"0"},{"type":"Edm.DateTime","name":"PaymentDate","precision":"0"},{"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.String","name":"PriceModel","maxLength":"2","fixedLength":"false","unicode":"true"},{"type":"Edm.Decimal","name":"ListPrice","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"Extras","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"OtherExtras","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.String","name":"OtherExtrasDescription","maxLength":"250","fixedLength":"false","unicode":"true"},{"type":"Edm.Decimal","name":"DeliveryFixPrice","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"Discount","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Int32","name":"IDDiscountType","nullable":"false"},{"type":"Edm.Decimal","name":"FreeExtras","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.String","name":"FreeExtrasDescription","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"ExchangedVehicleType","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"ExchangedChassisNumber","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.Decimal","name":"ExchangedVehiclePrice","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"ExchangedVehicleSalesPrice","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Int32","name":"IDParticipator"},{"type":"Edm.String","name":"TypeOfParticipation","maxLength":"2","fixedLength":"false","unicode":"true"},{"type":"Edm.Boolean","name":"AffectsProvision","nullable":"false"},{"type":"Edm.Boolean","name":"AffectsQuantity","nullable":"false"},{"type":"Edm.Boolean","name":"DocumentsReceived","nullable":"false"},{"type":"Edm.Decimal","name":"C_ImportDiscountTotal","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Boolean","name":"ProvisionChecked","nullable":"false"},{"type":"Edm.Decimal","name":"C_ImportSpecialDiscountTotal","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"C_CompletePrice","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"C_EstimateExceeded","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"C_TotalDiscountValue","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"C_GrossPrice","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"C_TotalDiscountPercent","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_TurnoverCorrectionFactor","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_ProvisionRelevantTurnoverVehicle","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_TotalTurnoverExtras","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_TotalDiscountExtrasPercent","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_TurnoverMultiplicator","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_ProvisionRelevantTurnoverExtras","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_ProvisionRelevantTurnoverTotal","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"A_ProvisionFactor","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"A_ProvisionTurnover","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"A_ProvisionTotal","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_TotalDiscountVehiclePercent","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"M_TotalTurnoverVehicle","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Boolean","name":"Deleted","nullable":"false"},{"type":"Edm.Decimal","name":"C_ProvisionParticipation","nullable":"false","precision":"19","scale":"6"}],"navigationProperty":[{"name":"tblCustomerTypes","relationship":"ProvSysModel.FK_tblTransactions_tblCustomerTypes","fromRole":"tblTransactions","toRole":"tblCustomerTypes"},{"name":"tblDiscountTypes","relationship":"ProvSysModel.FK_tblTransactions_tblDiscountTypes","fromRole":"tblTransactions","toRole":"tblDiscountTypes"},{"name":"tblEmployees","relationship":"ProvSysModel.FK_tblTransactions_tblEmployees","fromRole":"tblTransactions","toRole":"tblEmployees"},{"name":"tblEmployees1","relationship":"ProvSysModel.FK_tblTransactions_tblEmployees1","fromRole":"tblTransactions","toRole":"tblEmployees"},{"name":"tblSalesChannels","relationship":"ProvSysModel.FK_tblTransactions_tblSalesChannels","fromRole":"tblTransactions","toRole":"tblSalesChannels"},{"name":"tblTransactionImporterDiscounts","relationship":"ProvSysModel.FK_tblTransactionImporterDiscounts_tblTransactions","fromRole":"tblTransactions","toRole":"tblTransactionImporterDiscounts"},{"name":"tblVehicleModels","relationship":"ProvSysModel.FK_tblTransactions_tblVehicleModels","fromRole":"tblTransactions","toRole":"tblVehicleModels"}]},{"name":"tblVehicleModels","key":{"propertyRef":{"name":"IDVehicleModel"}},"property":[{"type":"Edm.Int32","name":"IDVehicleModel","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.String","name":"Category","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"Brand","nullable":"false","maxLength":"50","fixedLength":"false","unicode":"true"}],"navigationProperty":{"name":"tblTransactions","relationship":"ProvSysModel.FK_tblTransactions_tblVehicleModels","fromRole":"tblVehicleModels","toRole":"tblTransactions"}},{"name":"webpages_Membership","key":{"propertyRef":{"name":"UserId"}},"property":[{"type":"Edm.Int32","name":"UserId","nullable":"false"},{"type":"Edm.DateTime","name":"CreateDate","precision":"3"},{"type":"Edm.String","name":"ConfirmationToken","maxLength":"128","fixedLength":"false","unicode":"true"},{"type":"Edm.Boolean","name":"IsConfirmed"},{"type":"Edm.DateTime","name":"LastPasswordFailureDate","precision":"3"},{"type":"Edm.Int32","name":"PasswordFailuresSinceLastSuccess","nullable":"false"},{"type":"Edm.String","name":"Password","nullable":"false","maxLength":"128","fixedLength":"false","unicode":"true"},{"type":"Edm.DateTime","name":"PasswordChangedDate","precision":"3"},{"type":"Edm.String","name":"PasswordSalt","nullable":"false","maxLength":"128","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"PasswordVerificationToken","maxLength":"128","fixedLength":"false","unicode":"true"},{"type":"Edm.DateTime","name":"PasswordVerificationTokenExpirationDate","precision":"3"}]},{"name":"webpages_OAuthMembership","key":{"propertyRef":[{"name":"Provider"},{"name":"ProviderUserId"}]},"property":[{"type":"Edm.String","name":"Provider","nullable":"false","maxLength":"30","fixedLength":"false","unicode":"true"},{"type":"Edm.String","name":"ProviderUserId","nullable":"false","maxLength":"100","fixedLength":"false","unicode":"true"},{"type":"Edm.Int32","name":"UserId","nullable":"false"}]},{"name":"webpages_Roles","key":{"propertyRef":{"name":"RoleId"}},"property":[{"type":"Edm.Int32","name":"RoleId","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.String","name":"RoleName","nullable":"false","maxLength":"256","fixedLength":"false","unicode":"true"}],"navigationProperty":{"name":"tblEmployees","relationship":"ProvSysModel.webpages_UsersInRoles","fromRole":"webpages_Roles","toRole":"tblEmployees"}},{"name":"tblGlobalSettings","key":{"propertyRef":{"name":"IDGlobalSetting"}},"property":[{"type":"Edm.Decimal","name":"DiscountNet","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"WritingFee","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Int32","name":"IDGlobalSetting","nullable":"false","p1:StoreGeneratedPattern":"Identity"},{"type":"Edm.Decimal","name":"TurnoverCorrectionFactorBMWHO","nullable":"false","precision":"19","scale":"6"},{"type":"Edm.Decimal","name":"FixProvisionEmployeeSale","nullable":"false","precision":"19","scale":"6"}]}],"association":[{"name":"FK_tblBonuses_tblEmployees","end":[{"type":"Edm.ProvSysModel.tblEmployees","role":"tblEmployees","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblBonuses","role":"tblBonuses","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblBonuses","propertyRef":{"name":"IDEmployee"}}}},{"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_tblCompensations_tblEmployees","end":[{"type":"Edm.ProvSysModel.tblEmployees","role":"tblEmployees","multiplicity":"1","onDelete":{"action":"Cascade"}},{"type":"Edm.ProvSysModel.tblCompensations","role":"tblCompensations","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblCompensations","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblConditions_tblEmployees","end":[{"type":"Edm.ProvSysModel.tblEmployees","role":"tblEmployees","multiplicity":"1","onDelete":{"action":"Cascade"}},{"type":"Edm.ProvSysModel.tblConditions","role":"tblConditions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblConditions","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblTransactions_tblCustomerTypes","end":[{"type":"Edm.ProvSysModel.tblCustomerTypes","role":"tblCustomerTypes","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblTransactions","role":"tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblCustomerTypes","propertyRef":{"name":"IDCustomerType"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDCustomerType"}}}},{"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_tblSalarySettings_tblEmployees","end":[{"type":"Edm.ProvSysModel.tblEmployees","role":"tblEmployees","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblSalarySettings","role":"tblSalarySettings","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblSalarySettings","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblSpecialBonuses_tblEmployees","end":[{"type":"Edm.ProvSysModel.tblEmployees","role":"tblEmployees","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblSpecialBonuses","role":"tblSpecialBonuses","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblSpecialBonuses","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblTargets_tblEmployees","end":[{"type":"Edm.ProvSysModel.tblEmployees","role":"tblEmployees","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblTargets","role":"tblTargets","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblTargets","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblTransactions_tblEmployees","end":[{"type":"Edm.ProvSysModel.tblEmployees","role":"tblEmployees","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblTransactions","role":"tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDEmployee"}}}},{"name":"FK_tblTransactions_tblEmployees1","end":[{"type":"Edm.ProvSysModel.tblEmployees","role":"tblEmployees","multiplicity":"0..1"},{"type":"Edm.ProvSysModel.tblTransactions","role":"tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblEmployees","propertyRef":{"name":"IDEmployee"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDParticipator"}}}},{"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_tblTransactions_tblSalesChannels","end":[{"type":"Edm.ProvSysModel.tblSalesChannels","role":"tblSalesChannels","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblTransactions","role":"tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblSalesChannels","propertyRef":{"name":"IDSalesChannel"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDSalesChannel"}}}},{"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"}}}},{"name":"webpages_UsersInRoles","end":[{"type":"Edm.ProvSysModel.webpages_Roles","role":"webpages_Roles","multiplicity":"*"},{"type":"Edm.ProvSysModel.tblEmployees","role":"tblEmployees","multiplicity":"*"}]},{"name":"FK_tblTransactions_tblVehicleModels","end":[{"type":"Edm.ProvSysModel.tblVehicleModels","role":"tblVehicleModels","multiplicity":"1"},{"type":"Edm.ProvSysModel.tblTransactions","role":"tblTransactions","multiplicity":"*"}],"referentialConstraint":{"principal":{"role":"tblVehicleModels","propertyRef":{"name":"IDVehicleModel"}},"dependent":{"role":"tblTransactions","propertyRef":{"name":"IDVehicleModel"}}}}]}}