hao
2025-06-04 d7bf5fce0a442c858d02675a2c71a8af49937ae2
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
{
    /// <summary>
    /// 调拨申请单明细表
    ///</summary>
    [SugarTable("MES_INV_ITEM_DBSQ_ITEMS")]
    public class MesInvItemDbsqItems
    {
        /// <summary>
        /// SEQ_MOVE_DETAIL 
        ///</summary>
 
        [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_DBSQ_DETAIL")]
        //[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
        public decimal Id { get; set; }
        /// <summary>
        /// 主表id 
        ///</summary>
        [SugarColumn(ColumnName = "ITEM_MOVE_ID")]
        public decimal? ItemMoveId { get; set; }
        /// <summary>
        /// 物料内码 
        ///</summary>
        [SugarColumn(ColumnName = "ITEM_ID")]
        public decimal? ItemId { get; set; }
        /// <summary>
        /// 物料编码 
        ///</summary>
        [SugarColumn(ColumnName = "ITEM_NO")]
        public string? ItemNo { get; set; }
        /// <summary>
        /// 申请数量 
        ///</summary>
        [SugarColumn(ColumnName = "SQ_NUM")]
        public decimal? SqNum { get; set; }
        /// <summary>
        /// 调出数量 
        ///</summary>
        [SugarColumn(ColumnName = "DC_NUM")]
        public decimal? DcNum { get; set; }
        /// <summary>
        /// 调入数量 
        ///</summary>
        [SugarColumn(ColumnName = "DR_NUM")]
        public decimal? DrNum { get; set; }
        /// <summary>
        /// 当前库存数 
        ///</summary>
        [SugarColumn(ColumnName = "KC")]
        public decimal? Kc { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
        [SugarColumn(ColumnName = "REMARK")]
        public string? Remark { get; set; }
        /// <summary>
        /// 项次 
        ///</summary>
        [SugarColumn(ColumnName = "LINE_NO")]
        public decimal? LineNo { get; set; }
        /// <summary>
        /// 调拨申请单号 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_NO")]
        public string? BillNo { get; set; }
        /// <summary>
        /// 调出状态 
        ///</summary>
        [SugarColumn(ColumnName = "MOVE_OUT")]
        public decimal? MoveOut { get; set; }
        /// <summary>
        /// 调入状态 
        ///</summary>
        [SugarColumn(ColumnName = "MOVE_IN")]
        public decimal? MoveIn { get; set; }
        /// <summary>
        /// 创建人 
        ///</summary>
        [SugarColumn(ColumnName = "CREATE_BY")]
        public string? CreateBy { get; set; }
        /// <summary>
        /// 创建时间 
        ///</summary>
        [SugarColumn(ColumnName = "CREATE_DATE")]
        public DateTime? CreateDate { get; set; }
        /// <summary>
        /// 最后更新人 
        ///</summary>
        [SugarColumn(ColumnName = "LASTUPDATE_BY")]
        public string? LastupdateBy { get; set; }
        /// <summary>
        /// 最后更新时间 
        ///</summary>
        [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
        public DateTime? LastupdateDate { get; set; }
        /// <summary>
        /// 单位 
        ///</summary>
        [SugarColumn(ColumnName = "ITEM_UNIT")]
        public decimal? ItemUnit { get; set; }
        /// <summary>
        /// 是否同步ERP 
        ///</summary>
        [SugarColumn(ColumnName = "IS_TB")]
        public decimal? IsTb { get; set; }
        /// <summary>
        /// 调出组织 
        ///</summary>
        [SugarColumn(ColumnName = "DC_ORG")]
        public string? DcOrg { get; set; }
        /// <summary>
        /// 调出仓库 
        ///</summary>
        [SugarColumn(ColumnName = "DC_DEPOT")]
        public string? DcDepot { get; set; }
        /// <summary>
        /// 调入组织 
        ///</summary>
        [SugarColumn(ColumnName = "DR_ORG")]
        public string? DrOrg { get; set; }
        /// <summary>
        /// 调入仓库 
        ///</summary>
        [SugarColumn(ColumnName = "DR_DEPOT")]
        public string? DrDepot { get; set; }
        /// <summary>
        /// 调出货主 
        ///</summary>
        [SugarColumn(ColumnName = "DC_HZ")]
        public string? DcHz { get; set; }
        /// <summary>
        /// 调入货主 
        ///</summary>
        [SugarColumn(ColumnName = "DR_HZ")]
        public string? DrHz { get; set; }
        /// <summary>
        /// erpid 
        ///</summary>
        [SugarColumn(ColumnName = "ERPID")]
        public string? Erpid { get; set; }
        /// <summary>
        /// erp头id 
        ///</summary>
        [SugarColumn(ColumnName = "EID")]
        public string? Eid { get; set; }
    }
}