xwt
8 天以前 65438b8c1f9ec323c3c2ae265561dae4ff536379
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
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
{
    /// <summary>
    /// 采购退货申请主表
    ///</summary>
    [SugarTable("CGTH_SQ")]
    public class CgthSq
    {
        /// <summary>
        /// 单据编码 
        ///</summary>
         [SugarColumn(ColumnName="BILL_NO"    )]
         public string BillNo { get; set; }
        /// <summary>
        /// 创建时间 
        ///</summary>
         [SugarColumn(ColumnName="CREATE_DATE"    )]
         public DateTime? CreateDate { get; set; }
        /// <summary>
        /// 创建人 
        ///</summary>
         [SugarColumn(ColumnName="CREATE_BY"    )]
         public string CreateBy { get; set; }
        /// <summary>
        /// 审核时间 
        ///</summary>
         [SugarColumn(ColumnName="CHECK_DATE"    )]
         public DateTime? CheckDate { get; set; }
        /// <summary>
        /// 审核人 
        ///</summary>
         [SugarColumn(ColumnName="CHECK_USER"    )]
         public string CheckUser { get; set; }
        /// <summary>
        /// 审核状态 
        ///</summary>
         [SugarColumn(ColumnName="STATUS"    )]
         public decimal? Status { get; set; }
        /// <summary>
        /// 仓库编码 
        ///</summary>
         [SugarColumn(ColumnName="DEPOT_CODE"    )]
         public string DepotCode { get; set; }
        /// <summary>
        /// 是否委外 
        ///</summary>
         [SugarColumn(ColumnName="F_TYPE"    )]
         public decimal? FType { get; set; }
        /// <summary>
        /// 供应商编码 
        ///</summary>
         [SugarColumn(ColumnName="SUPP_NO"    )]
         public string SuppNo { get; set; }
        /// <summary>
        /// 组织id 
        ///</summary>
         [SugarColumn(ColumnName="ORG_ID"    )]
         public decimal? OrgId { get; set; }
        /// <summary>
        /// 退货方式 
        ///</summary>
         [SugarColumn(ColumnName="TH_FS"    )]
         public string ThFs { get; set; }
        /// <summary>
        /// 退货原因 
        ///</summary>
         [SugarColumn(ColumnName="TH_YY"    )]
         public string ThYy { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
         [SugarColumn(ColumnName="BZ"    )]
         public string Bz { get; set; }
        /// <summary>
        ///  
        ///</summary>
         [SugarColumn(ColumnName="ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_CGTH_SQ")]
         public decimal? Id { get; set; }
        /// <summary>
        /// 是否完成 
        ///</summary>
         [SugarColumn(ColumnName="IS_WC"    )]
         public decimal? IsWc { get; set; }
        /// <summary>
        /// 供应商ID 
        ///</summary>
         [SugarColumn(ColumnName="SUPP_ID"    )]
         public string SuppId { get; set; }
        /// <summary>
        /// 单据类型 
        ///</summary>
         [SugarColumn(ColumnName="DJ_LX"    )]
         public string DjLx { get; set; }
        /// <summary>
        /// 业务类型 
        ///</summary>
         [SugarColumn(ColumnName="YW_FS"    )]
         public string YwFs { get; set; }
        /// <summary>
        /// ERP创建人 
        ///</summary>
         [SugarColumn(ColumnName="ERP_CREATE_BY"    )]
         public string ErpCreateBy { get; set; }
        /// <summary>
        /// 采购组织 
        ///</summary>
         [SugarColumn(ColumnName="CG_ORG"    )]
         public string CgOrg { get; set; }
        /// <summary>
        /// 退料组织 
        ///</summary>
         [SugarColumn(ColumnName="TL_ORG"    )]
         public string TlOrg { get; set; }
        /// <summary>
        /// 需求组织 
        ///</summary>
         [SugarColumn(ColumnName="XQ_ORG"    )]
         public string XqOrg { get; set; }
        /// <summary>
        /// 采购部门 
        ///</summary>
         [SugarColumn(ColumnName="CG_BM"    )]
         public string CgBm { get; set; }
        /// <summary>
        /// 退料部门 
        ///</summary>
         [SugarColumn(ColumnName="TL_BM"    )]
         public string TlBm { get; set; }
        /// <summary>
        /// 仓管员名称 
        ///</summary>
         [SugarColumn(ColumnName="CGY_MC"    )]
         public string CgyMc { get; set; }
        /// <summary>
        /// 采购员名称 
        ///</summary>
         [SugarColumn(ColumnName="CG_MC"    )]
         public string CgMc { get; set; }
        /// <summary>
        /// 库存组名称 
        ///</summary>
         [SugarColumn(ColumnName="KC_DEPOT"    )]
         public string KcDepot { get; set; }
        /// <summary>
        /// 采购组名称 
        ///</summary>
         [SugarColumn(ColumnName="CG_DEPOT"    )]
         public string CgDepot { get; set; }
        /// <summary>
        /// 验收方式 
        ///</summary>
         [SugarColumn(ColumnName="YS_FS"    )]
         public string YsFs { get; set; }
        /// <summary>
        /// ERPID 
        ///</summary>
        [SugarColumn(ColumnName = "ERPID")]
        public string Erpid { get; set; }
        /// <summary>
        /// ERP源单ID
        ///</summary>
        [SugarColumn(ColumnName = "YDID")]
        public string Ydid { get; set; }
    }
}