using SqlSugar;
|
|
namespace HH.WCS.Mobox3.AnGang.models {
|
/// <summary>
|
/// 物料-容器 关系表
|
/// </summary>
|
/// <remarks>
|
/// CG = Cargo Goods 货物商品
|
/// </remarks>
|
[SugarTable("TN_CG_Detail")]
|
public class TN_CG_Detail : BaseModel
|
{
|
/// <summary>
|
/// 货品 ID
|
/// </summary>
|
public string S_CG_ID { get; set; } = "";
|
|
public string S_CNTR_CODE { get; set; } = "";//容器编码
|
|
public string S_ITEM_CODE { get; set; } = "";//货品编码
|
|
public string S_ITEM_NAME { get; set; } = "";
|
|
public string S_ITEM_SPEC { get; set; } = "";//货品规格
|
|
/// <summary>
|
/// 货品状态：0合格 1待检 2不合格 3正在检验；下线即待检
|
/// </summary>
|
public string S_ITEM_STATE { get; set; } = "待检";
|
|
/// <summary>
|
/// 货品状态_字典：0合格 1待检 2不合格 3正在检验；下线即待检
|
/// </summary>
|
public int N_ITEM_STATE { get; set; } = 1;
|
|
public string S_BATCH_NO { get; set; } = ""; //批次号
|
|
/// <summary>
|
/// 数量：这里当做重量
|
/// </summary>
|
public float F_QTY { get; set; } = 0f;
|
|
public string S_LOC_CODE { get; set; }
|
|
public int N_LOCK_STATE { get; set; } = 0;
|
|
// ------- ERP --------
|
|
/// <summary>
|
/// 物料短描述
|
/// </summary>
|
public string S_ITEM_SHORT_DESC { get; set; }
|
|
/// <summary>
|
/// 库存数量
|
/// </summary>
|
public string S_STOCK_QUANTITY { get; set; }
|
|
/// <summary>
|
/// 入库数量
|
/// </summary>
|
public string S_IN_QUANTITY { get; set; }
|
|
/// <summary>
|
/// 库存总价
|
/// </summary>
|
public string S_TOTAL_PRICE { get; set; }
|
|
///// <summary>
|
///// 入库时间
|
///// </summary>
|
//public string S_STOCK_IN_TIME { get; set; }
|
|
/// <summary>
|
/// 保管员
|
/// </summary>
|
public string S_STORE_KEEPER { get; set; }
|
|
/// <summary>
|
/// 产线部门代码
|
/// </summary>
|
public string S_LINE_CODE { get; set; }
|
|
///// <summary>
|
///// 送货单行号
|
///// </summary>
|
//public string S_DELIVERY_ITEM_NO { get; set; }
|
|
///// <summary>
|
///// 供应商名称
|
///// </summary>
|
//public string S_SUPPLIER_NAME { get; set; }
|
|
///// <summary>
|
///// 库存责任人姓名
|
///// </summary>
|
//public string S_INVENTORY_MAN { get; set; }
|
|
// 修复图片存储的风险：URL存一份到CGDetail表的S_EXT_ATTR5中
|
public string S_EXT_ATTR5 { get; set; } = string.Empty; // FIX: SNAP
|
|
}
|
}
|
