| | |
| | | public class MesDepots |
| | | { |
| | | /// <summary> |
| | | /// 默认值: (newid()) |
| | | /// </summary> |
| | | /// |
| | | /// 默认值: (newid()) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] |
| | | public string Guid { get; set; } |
| | | public Guid Guid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ID(SEQ_INV_ID) |
| | | /// </summary> |
| | | /// 仓库ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "depot_id")] |
| | | public decimal DepotId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库类别编码 |
| | | /// </summary> |
| | | /// 仓库编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "depot_code")] |
| | | public string? DepotCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库类别名称 |
| | | /// </summary> |
| | | /// 仓库名称 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "depot_name")] |
| | | public string? DepotName { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备注 |
| | | /// </summary> |
| | | /// 备注 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "description")] |
| | | public string? Description { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库负责人 |
| | | /// </summary> |
| | | /// 仓库负责人 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "create_by")] |
| | | public string? CreateBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 创建时间 |
| | | /// </summary> |
| | | /// 创建时间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "create_date")] |
| | | public DateTime? CreateDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 最后更新人 |
| | | /// </summary> |
| | | /// 最后更新人 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "lastupdate_by")] |
| | | public string? LastupdateBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 最后更新时间 |
| | | /// </summary> |
| | | /// 最后更新时间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "lastupdate_date")] |
| | | public DateTime? LastupdateDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库类型 |
| | | /// </summary> |
| | | /// 仓库类型 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "depottype")] |
| | | public string? Depottype { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 分厂编码 |
| | | /// </summary> |
| | | /// 分厂编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "factory")] |
| | | public string? Factory { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料使用 |
| | | /// 默认值: ((0)) |
| | | /// </summary> |
| | | /// 物料使用 |
| | | /// 默认值: ((0)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "type_1")] |
| | | public int? Type1 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 成品使用 |
| | | /// 默认值: ((0)) |
| | | /// </summary> |
| | | /// 成品使用 |
| | | /// 默认值: ((0)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "type_2")] |
| | | public int? Type2 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库类型编码 |
| | | /// </summary> |
| | | /// 仓库类型编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "depottypecode")] |
| | | public int? Depottypecode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 公司代码 |
| | | /// </summary> |
| | | /// 公司代码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "company")] |
| | | public string? Company { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 看板图标样式 |
| | | /// </summary> |
| | | /// 看板图标样式 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "icon_type")] |
| | | public int? IconType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 是否委外仓库 |
| | | /// 默认值: ((0)) |
| | | /// </summary> |
| | | /// 是否委外仓库 |
| | | /// 默认值: ((0)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "is_wy")] |
| | | public int? IsWy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 是否不良品仓 |
| | | /// 默认值: ((0)) |
| | | /// </summary> |
| | | /// 禁用状态 |
| | | /// 默认值: ((0)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "is_ng")] |
| | | public string? IsNg { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库地址 |
| | | /// </summary> |
| | | /// 仓库地址 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "cwhaddress")] |
| | | public string? Cwhaddress { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 看板显示区域编号 |
| | | /// 默认值: ((1)) |
| | | /// </summary> |
| | | /// 看板显示区域编号 |
| | | /// 默认值: ((1)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "pi_type")] |
| | | public string? PiType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 分组 |
| | | /// </summary> |
| | | /// 分组 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "zuid")] |
| | | public string? Zuid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 允许即时库存负库存 |
| | | /// </summary> |
| | | /// 允许即时库存负库存 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "is_fkc")] |
| | | public string? IsFkc { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 生产车间 |
| | | /// </summary> |
| | | /// 生产车间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "production_workshop")] |
| | | public string? ProductionWorkshop { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料属性 |
| | | /// </summary> |
| | | /// 物料属性 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "material_properti")] |
| | | public string? MaterialProperti { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 自定义字段3 |
| | | /// </summary> |
| | | /// 自定义字段3 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "remark3")] |
| | | public string? Remark3 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 自定义字段4 |
| | | /// </summary> |
| | | /// 自定义字段4 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "remark4")] |
| | | public string? Remark4 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 自定义字段5 |
| | | /// </summary> |
| | | /// 自定义字段5,仓库属性 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "remark5")] |
| | | public string? Remark5 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// </summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "check_date")] |
| | | public DateTime? CheckDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// </summary> |
| | | /// |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "check_by")] |
| | | public string? CheckBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 默认值: ((0)) |
| | | /// </summary> |
| | | /// |
| | | /// 默认值: ((0)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "check_status")] |
| | | public bool? CheckStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 创建组织 |
| | | /// </summary> |
| | | /// 创建组织 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Fumbrella")] |
| | | public string? Fumbrella { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 使用组织 |
| | | /// </summary> |
| | | /// 使用组织 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "FSubsidiary")] |
| | | public string? FSubsidiary { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 供应商 |
| | | /// </summary> |
| | | /// 供应商 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "SUPPLIER_ID")] |
| | | public string? SupplierId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客户 |
| | | /// </summary> |
| | | /// 客户 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Client_Id")] |
| | | public string? ClientId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 部门 |
| | | /// </summary> |
| | | /// 部门 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "department")] |
| | | public string? Department { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 联系电话 |
| | | /// </summary> |
| | | /// 联系电话 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "Phone")] |
| | | public string? Phone { get; set; } |
| | | |
| | | /// <summary> |
| | | /// Z=暂存,A=创建,B=审核中,C=已审核,D=重新审核 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "DOCUMENT_STATUS")] |
| | | public string? DocumentStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 0=可用,4=在途,6=废品,2=冻结,5=收货冻结,1=待检,8=不参与核算,3=退回冻结,7=不良 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName = "STOCK_STATUS_TYPE")] |
| | | public string? StockStatusType { get; set; } |
| | | |
| | | |
| | | [SugarColumn(IsIgnore = true)] public string? Type { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客户 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FCustomerId")] |
| | | public string? FCustomerId { get; set; } |
| | | /// <summary> |
| | | /// 数据状态 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FDocumentStatus")] |
| | | public string? FDocumentStatus { get; set; } |
| | | /// <summary> |
| | | /// 库存状态类型 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FStockStatusType")] |
| | | public string? FStockStatusType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 启用仓位管理 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FISOPENLOCATION")] |
| | | public string? FISOPENLOCATION { get; set; } |
| | | |
| | | |
| | | |
| | | } |