| | | 1 | | using System.ComponentModel.DataAnnotations; |
| | | 2 | | using System.ComponentModel.DataAnnotations.Schema; |
| | | 3 | | |
| | | 4 | | namespace OzonDomains.Models; |
| | | 5 | | |
| | | 6 | | [Table("WarehouseStockSnapshot")] |
| | | 7 | | public class WarehouseStockSnapshot |
| | | 8 | | { |
| | | 9 | | [Key] |
| | | 10 | | [DatabaseGenerated(DatabaseGeneratedOption.Identity)] |
| | 12 | 11 | | public long Id { get; set; } |
| | | 12 | | |
| | | 13 | | [Required] |
| | | 14 | | [MaxLength(128)] |
| | 310 | 15 | | public string RowKey { get; set; } = string.Empty; |
| | | 16 | | |
| | 29 | 17 | | public int SourceRowNumber { get; set; } |
| | | 18 | | |
| | | 19 | | [Required] |
| | | 20 | | [MaxLength(128)] |
| | 520 | 21 | | public string SourceSheetName { get; set; } = string.Empty; |
| | | 22 | | |
| | | 23 | | [Required] |
| | | 24 | | [MaxLength(32)] |
| | 629 | 25 | | public string SourceType { get; set; } = WarehouseStockSyncSourceType.GoogleSheets; |
| | | 26 | | |
| | | 27 | | [MaxLength(255)] |
| | 466 | 28 | | public string? Manufacturer { get; set; } |
| | | 29 | | |
| | | 30 | | [MaxLength(128)] |
| | 767 | 31 | | public string? Article { get; set; } |
| | | 32 | | |
| | | 33 | | [MaxLength(512)] |
| | 258 | 34 | | public string? ProductName { get; set; } |
| | | 35 | | |
| | | 36 | | [MaxLength(128)] |
| | 47 | 37 | | public string? SaleFlag { get; set; } |
| | | 38 | | |
| | 52 | 39 | | public decimal? M2Qty { get; set; } |
| | 240 | 40 | | public decimal? M1Qty { get; set; } |
| | 51 | 41 | | public decimal? M3Qty { get; set; } |
| | 49 | 42 | | public decimal? B1Qty { get; set; } |
| | 49 | 43 | | public decimal? B2Qty { get; set; } |
| | 17 | 44 | | public decimal? UnitCost { get; set; } |
| | 11 | 45 | | public decimal? TotalCost { get; set; } |
| | 17 | 46 | | public decimal? SalePriceUnit { get; set; } |
| | 17 | 47 | | public decimal? AccountingPriceUnit { get; set; } |
| | 17 | 48 | | public decimal? PriceDiffAccountingMinusSale { get; set; } |
| | 270 | 49 | | public decimal? C0 { get; set; } |
| | 10 | 50 | | public decimal? StockAmountByC0 { get; set; } |
| | 17 | 51 | | public decimal? ExistPrice { get; set; } |
| | 17 | 52 | | public decimal? C1ExistMinus5Percent { get; set; } |
| | 17 | 53 | | public decimal? C1PercentToC0 { get; set; } |
| | | 54 | | |
| | | 55 | | [MaxLength(32)] |
| | 12 | 56 | | public string? Warehouse { get; set; } |
| | | 57 | | |
| | 487 | 58 | | public DateTime SourceUpdatedAtUtc { get; set; } = DateTime.UtcNow; |
| | | 59 | | |
| | 304 | 60 | | public DateTime SyncedAtUtc { get; set; } = DateTime.UtcNow; |
| | | 61 | | |
| | 12 | 62 | | public long SyncRunId { get; set; } |
| | | 63 | | |
| | | 64 | | [ForeignKey(nameof(SyncRunId))] |
| | 0 | 65 | | public virtual WarehouseStockSyncRun? SyncRun { get; set; } |
| | | 66 | | } |