MichelangeloSalesCondition

Condizioni di vendita nell'Erp Michelangelo

Chiavi

• Id

• SalesConditionTypeId, SalesConditionKey, StartDate, EndDate, CurrencyId, SalesUomId, UnitsPerPack, SalesAgentId

Campo	Descrizione	Tipo	Dimensione
Commission	Provvigione	dec
ConditionPrefixType	Tipo prefisso condizione	text	50
CurrencyId	Id della valuta	text	50
CustomerGroup1_Discount1	Sconto	dec
CustomerGroup1_Discount2	Sconto	dec
CustomerGroup1_Discount3	Sconto	dec
CustomerGroup1_FixedDiscount	Sconto importo	dec
CustomerGroup10_Discount1	Sconto	dec
CustomerGroup10_Discount2	Sconto	dec
CustomerGroup10_Discount3	Sconto	dec
CustomerGroup10_FixedDiscount	Sconto importo	dec
CustomerGroup11_Discount1	Sconto	dec
CustomerGroup11_Discount2	Sconto	dec
CustomerGroup11_Discount3	Sconto	dec
CustomerGroup11_FixedDiscount	Sconto importo	dec
CustomerGroup12_Discount1	Sconto	dec
CustomerGroup12_Discount2	Sconto	dec
CustomerGroup12_Discount3	Sconto	dec
CustomerGroup12_FixedDiscount	Sconto importo	dec
CustomerGroup13_Discount1	Sconto	dec
CustomerGroup13_Discount2	Sconto	dec
CustomerGroup13_Discount3	Sconto	dec
CustomerGroup13_FixedDiscount	Sconto importo	dec
CustomerGroup14_Discount1	Sconto	dec
CustomerGroup14_Discount2	Sconto	dec
CustomerGroup14_Discount3	Sconto	dec
CustomerGroup14_FixedDiscount	Sconto importo	dec
CustomerGroup15_Discount1	Sconto	dec
CustomerGroup15_Discount2	Sconto	dec
CustomerGroup15_Discount3	Sconto	dec
CustomerGroup15_FixedDiscount	Sconto importo	dec
CustomerGroup2_Discount1	Sconto	dec
CustomerGroup2_Discount2	Sconto	dec
CustomerGroup2_Discount3	Sconto	dec
CustomerGroup2_FixedDiscount	Sconto importo	dec
CustomerGroup3_Discount1	Sconto	dec
CustomerGroup3_Discount2	Sconto	dec
CustomerGroup3_Discount3	Sconto	dec
CustomerGroup3_FixedDiscount	Sconto importo	dec
CustomerGroup4_Discount1	Sconto	dec
CustomerGroup4_Discount2	Sconto	dec
CustomerGroup4_Discount3	Sconto	dec
CustomerGroup4_FixedDiscount	Sconto importo	dec
CustomerGroup5_Discount1	Sconto	dec
CustomerGroup5_Discount2	Sconto	dec
CustomerGroup5_Discount3	Sconto	dec
CustomerGroup5_FixedDiscount	Sconto importo	dec
CustomerGroup6_Discount1	Sconto	dec
CustomerGroup6_Discount2	Sconto	dec
CustomerGroup6_Discount3	Sconto	dec
CustomerGroup6_FixedDiscount	Sconto importo	dec
CustomerGroup7_Discount1	Sconto	dec
CustomerGroup7_Discount2	Sconto	dec
CustomerGroup7_Discount3	Sconto	dec
CustomerGroup7_FixedDiscount	Sconto importo	dec
CustomerGroup8_Discount1	Sconto	dec
CustomerGroup8_Discount2	Sconto	dec
CustomerGroup8_Discount3	Sconto	dec
CustomerGroup8_FixedDiscount	Sconto importo	dec
CustomerGroup9_Discount1	Sconto	dec
CustomerGroup9_Discount2	Sconto	dec
CustomerGroup9_Discount3	Sconto	dec
CustomerGroup9_FixedDiscount	Sconto importo	dec
EndDate	Data fine validità	date
Id	Id	text	50
ImposedUnitPrice	Prezzo unitario imposto	dec
ItemCostReferenceDate	Data riferimento costi	date
JumpStringByCustomerGroup	Fascia	text	30
Multiplier	Ricarico	dec
MultiplierCode	Codice ricarico	text	50
QuantityRange1_Discount	Sconto	dec
QuantityRange1_ImposedUnitPrice	Prezzo unitario imposto	dec
QuantityRange1_Quantity	Quantità	dec
QuantityRange2_Discount	Sconto	dec
QuantityRange2_ImposedUnitPrice	Prezzo unitario imposto	dec
QuantityRange2_Quantity	Quantità	dec
QuantityRange3_Discount	Sconto	dec
QuantityRange3_ImposedUnitPrice	Prezzo unitario imposto	dec
QuantityRange3_Quantity	Quantità	dec
QuantityRange4_Discount	Sconto	dec
QuantityRange4_ImposedUnitPrice	Prezzo unitario imposto	dec
QuantityRange4_Quantity	Quantità	dec
ReferenceCostTypeId	Id del costo di riferimento	text	50
SalesAgentId	Id dell'agente	text	50
SalesConditionKey	Chiave della condizione di vendita	text	30
SalesConditionTypeId	Id del tipo di condizione	text	30
SalesUomId	Id unità di misura di vendita	text	50
StartDate	Data inizio validità	date
Status	Stato	text	1
UnitsPerPack	Unità per confezione	dec
UseMultiplier	Indica se usare il ricarico	bool