| | |
| | | /// <summary> |
| | | /// SEQ_sales |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales", |
| | | IsPrimaryKey = true)] |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales", IsPrimaryKey = true)] |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单据行号 |
| | | /// 物料编码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LINE_NUMBER")] |
| | | public long? LineNumber { get; set; } |
| | | [SugarColumn(ColumnName = "MATERIAL_ID")] |
| | | public string MaterialId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产品代码 |
| | | /// 销售单位 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRODUCT_CODE")] |
| | | public string ProductCode { get; set; } |
| | | [SugarColumn(ColumnName = "SALES_UNIT_ID")] |
| | | public string SalesUnitId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产品名称 |
| | | /// 销售数量 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRODUCT_NAME")] |
| | | public string ProductName { get; set; } |
| | | [SugarColumn(ColumnName = "SALES_QUANTITY")] |
| | | public decimal SalesQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产品规格 |
| | | /// 是否赠品 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "PRODUCT_SPEC")] |
| | | public string ProductSpec { get; set; } |
| | | [SugarColumn(ColumnName = "IS_FREE")] |
| | | public string IsFree { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 金额 |
| | | /// 退货日期 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "AMOUNT")] |
| | | public decimal? Amount { get; set; } |
| | | [SugarColumn(ColumnName = "RETURN_DATE")] |
| | | public DateTime? ReturnDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单价 |
| | | /// 仓库 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "UNIT_PRICE")] |
| | | public decimal? UnitPrice { get; set; } |
| | | [SugarColumn(ColumnName = "WAREHOUSE")] |
| | | public string Warehouse { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 数量 |
| | | /// 计划跟踪号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "QUANTITY")] |
| | | public decimal? Quantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 出库数量 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "OUT_QUANTITY")] |
| | | public decimal? OutQuantity { get; set; } |
| | | [SugarColumn(ColumnName = "PLAN_TRACKING_NUMBER")] |
| | | public string PlanTrackingNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 批号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BATCH_NUMBER")] |
| | | public string BatchNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 退货数量 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RETURN_QUANTITY")] |
| | | public decimal? ReturnQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 发货数量 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DELIVERY_QUANTITY")] |
| | | public decimal? DeliveryQuantity { get; set; } |
| | | [SugarColumn(ColumnName = "LOT_NUMBER")] |
| | | public string LotNumber { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 备注 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARKS")] |
| | | public string Remarks { get; set; } |
| | | [SugarColumn(ColumnName = "NOTE")] |
| | | public string Note { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 销售订单单号 |
| | | /// 退货类型 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_ORDER_ID")] |
| | | public string SalesOrderId { get; set; } |
| | | [SugarColumn(ColumnName = "RETURN_TYPE")] |
| | | public string ReturnType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 销售订单分录 |
| | | /// 库存单位 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_ORDER_ENTRY")] |
| | | public string SalesOrderEntry { get; set; } |
| | | [SugarColumn(ColumnName = "INVENTORY_UNIT")] |
| | | public string InventoryUnit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 销售订单ID |
| | | /// 库存数量 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SALES_ORDER_DETAIL_ID")] |
| | | public string SalesOrderDetailId { get; set; } |
| | | [SugarColumn(ColumnName = "INVENTORY_QUANTITY")] |
| | | public decimal InventoryQuantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 基本单价 |
| | | /// 货主类型 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASE_UNIT_PRICE")] |
| | | public decimal? BaseUnitPrice { get; set; } |
| | | [SugarColumn(ColumnName = "OWNER_TYPE_ID")] |
| | | public string OwnerTypeId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 基本单位数量 |
| | | /// 货主 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASE_UNIT_QUANTITY")] |
| | | public decimal? BaseUnitQuantity { get; set; } |
| | | [SugarColumn(ColumnName = "OWNER_ID")] |
| | | public string OwnerId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库代码 |
| | | /// 源单类型 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WAREHOUSE_CODE")] |
| | | public string WarehouseCode { get; set; } |
| | | [SugarColumn(ColumnName = "SOURCE_BILL_TYPE")] |
| | | public string SourceBillType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库名称 |
| | | /// 源单单号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WAREHOUSE_NAME")] |
| | | public string WarehouseName { get; set; } |
| | | [SugarColumn(ColumnName = "SOURCE_BILL_NO")] |
| | | public string SourceBillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 基本单位出库数量 |
| | | /// 订单单号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BASE_UNIT_OUT_QUANTITY")] |
| | | public decimal? BaseUnitOutQuantity { get; set; } |
| | | [SugarColumn(ColumnName = "ORDER_BILL_NO")] |
| | | public string OrderBillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单位 |
| | | /// ERP行ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "UNIT")] |
| | | public string Unit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERPID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_ID")] |
| | | public string ErpId { get; set; } |
| | | [SugarColumn(ColumnName = "ERP_LINE_ID")] |
| | | public string ErpLineId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// ERP头ID |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ERP_HEAD_ID")] |
| | | public string ErpHeadId { get; set; } |
| | | |
| | | } |