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
using System;
using System.Collections.Generic;
using System.Text;
 
namespace WebAPI.Models
{
    public class ClsKf_ICStockBillSub:DBUtility.ClsXt_BaseBillSub
    {
        public Int64 HInterID;
        public Int64 HEntryID;
        public Int64 HMaterID;              //        int                --ÎïÁÏID
        public Int64 HPropertyID;           //        int                --¸¨ÖúÊôÐÔ
        public Int64 HSecUnitID;            //        int                --¸¨Öú¼ÆÁ¿µ¥Î»
        public Single HSecUnitRate;         //        money            --»»ËãÂÊ 
        public Int64 HUnitID;               //        int                --¼ÆÁ¿µ¥Î»
        public double HQtyMust;             //        dec(18,8)        --Ó¦ÊÕÊýÁ¿
        public double HQty;                 //        dec(18,8)        --ʵÊÕÊýÁ¿    
        public double HPrice;               //        dec(18,8)        --µ¥¼Û
        public double HMoney;               //        dec(18,8)        --½ð¶î
        public double HOrderPrice;          //        dec(18,8)        --²É¹º½ð¶î    --addnew
        public Int64 HWHID;                 //        int                --ÊÕÁϲֿâ
        public Int64 HSCWHID;               //        int             --µ÷³ö²Ö¿âID£¨½çÃæÉϲ»ÐèÒªÏÔʾ£¬´æ0½øÈ¥£©
        public Int64 HSPID;                 //        int                --²ÖλID
        public Int64 HSCSPID;               //        int                --µ÷³ö²ÖλID£¨½çÃæÉϲ»ÐèÒªÏÔʾ£¬´æ0½øÈ¥£©
        public Int64 HSPGroupID;            //        int                --²Öλ×éID(²Ö¿âÑ¡ÔñÍê×Ô¶¯´ø³ö)
        public string HBatchNo;             //        varchar(50)        --Åú´Î
        public Int64 HPOOrderInterID;       //        int                --²É¹º¶©µ¥Ö÷ÄÚÂë
        public Int64 HPOOrderEntryID;       //        int                --²É¹º¶©µ¥×ÓÄÚÂë
        public string HPOOrderBillNo;       //        varchar(50)        --²É¹º¶©µ¥ºÅ
        public Int64 HSeOrderInterID;       //        int                --ÏúÊÛ¶©µ¥Ö÷ÄÚÂë
        public Int64 HSeOrderEntryID;       //        int                --ÏúÊÛ¶©µ¥×ÓÄÚÂë
        public string HSeOrderBillNo;       //        varchar(50)        --ÏúÊÛ¶©µ¥ºÅ
        public Int64 HICMOInterID;          //        int                --Éú²ú¶©µ¥Ö÷ÄÚÂë
        public Int64 HICMOEntryID;          //        int                --Éú²ú¶©µ¥×ÓÄÚÂë
        public string HICMOBillNo;          //        varchar(50)        --Éú²ú¶©µ¥ºÅ
        public Int64 HWWOrderInterID;       //        int             --ίÍâ¶©µ¥Ö÷ÄÚÂë
        public Int64 HWWOrderEntryID;       //        int             --ίÍâ¶©µ¥×ÓÄÚÂë
        public string HWWOrderBillNo;       //        varchar(50)     --ίÍâ¶©µ¥ºÅ
        public string HEngineNum;           //        varchar(100)    --·¢¶¯»úºÅ£¨Òþ²Ø£©
        public string HUnderPanNum;         //        varchar(100)    --µØÅ̺ţ¨Òþ²Ø£©
        public string HLeaveFactCard;       //        varchar(100)    --³ö³§Ö¤£¨Òþ²Ø£©    
        public double HSalePrice;           //        dec(18,8)        --ÏúÊÛµ¥¼Û    --addnew
        public Single HCostPrice;           //        money            --³É±¾µ¥¼Û    --addnew
        public Single HCostMoney;           //        money            --³É±¾½ð¶î    --addnew
        public double HQtyRel;              //        dec(18,8)        --ʵ¼ÊÊýÁ¿
        public DateTime HEndDate;           //        datetime        --½áÊøÈÕÆÚ
        public bool HOldMaterBackFlag;      //        bit                --¾É¼þ·µ»Ø±ê¼Ç
        public Int64 HProcID;               //      int             --¹¤Ðò£¨Gy_Process£©
        public double HHookQty;             //        dec(18,8)        --¹´»üÊýÁ¿
        public string HHookType;            //        varchar(50)        --¹´»üÀàÐÍ
        public double HTaxPrice;            //        dec(18,8)        --º¬Ë°µ¥¼Û
        public double HTaxMoney;            //        dec(18,8)        --º¬Ë°½ð¶î
        public Int64 HPackMaterID;          //        int                --°ü×°²ÄÁÏ
        public double HPackQty;             //        dec(18,8)        --°ü×°ÊýÁ¿
        public Int64 HBottleMaterID;        //        int                --ÎÞÓÃ
        public double HBottleLackQty;       //        dec(18,8)        --ÎÞÓÃ
        public double HBottleQty;           //        dec(18,8)        --ÎÞÓÃ
        public string HMTONo;               //        varchar(50)        --¼Æ»®¸ú×ÙºÅ
        public Int64 HPlanMode;             //        int                --¼Æ»®Ä£Ê½
        public Int64 HEOWNERSUPPLIERID;     //      int                --¹©Ó¦×éÖ¯»õÖ÷
        public Int64 HOWNERID;              //        int                --»õÖ÷
        public Int64 HKEEPERID;             //        int                --±£¹ÜÕß
        public Int64 HPARENTOWNERID;        //        int                --²úÆ·»õÖ÷
        public Int64 HRECEIVEOWNERID;       //        int                --ÊÕÁÏ×éÖ¯
        public string HOWNERTYPEID;         //        varchar(100)    --»õÖ÷ÀàÐÍ
        public string HKEEPERTYPEID;        //        varchar(100)    --±£¹ÜÀàÐÍ
        public string HPARENTOWNERTYPEID;   //        varchar(100)    --²úÆ·»õÖ÷ÀàÐÍ
        public string HRECEIVEOWNERTYPEID;  //        varchar(100)    --ÊÕÁÏ»õÖ÷ÀàÐÍ
        public Single HTaxRate;             //        money           --˰ÂÊ
        public Int64 HSTOCKORGID;           //        int             --¿â´æ×éÖ¯
        public string HSourceBillNo;
        public string HSourceBillType;
        public string HBatchNO;
        public Int64 HSourceInterID;
        public Int64 HSourceEntryID;
        public Int64 HSourceSEQ;            //  Ô´µ¥ÐкÅ
        public Int64 HAuxPropID;
        public double HlineTotal;
 
        public object HContainerNum { get; internal set; }
        public object HPVC { get; internal set; }
        public object HViscosity { get; internal set; }
        public object HImpurity { get; internal set; }
        public object HIron { get; internal set; }
        public object HGrossQty { get; internal set; }
        public object HMembrane { get; internal set; }
        public object HAluminum { get; internal set; }
        public object HPackWeight { get; internal set; }
        public object HPaper { get; internal set; }
        public object HLoss { get; internal set; }
        public object HWater { get; internal set; }
        public object HPowder { get; internal set; }
        public object HCap { get; internal set; }
        public object HNetQty { get; internal set; }
 
        public string HExpressNumber; // ¿ìµÝµ¥ºÅ
        public Int64 HERPInterID; // ERPÖ÷±íÄÚÂë
        public Int64 HERPEntryID; // ERP×Ó±íÄÚÂë
        public Int64 HSTOCKERGROUPID; // ²Ö¿â×éID
        public Int64 HPROVIDERCONTACTID; // ¹©Ó¦ÉÌÁªÏµÈËID
        public Int64 HSUPPLYID; // ¹©Ó¦ID
        public Int64 HSETTLEID; // ½áËãID
        public Int64 HCHARGEID; // ¸ºÔðÈËID
        public Int64 HPURCHASEDEPTID; // ²É¹º²¿ÃÅID
        public string HPRILSTENTRYID; // ¼Û¸ñ±íÌõÄ¿ID
        public double HPURBASENUM; // ²É¹º»ùÊý
        public double HSTOCKBASEDEN; // ¿â´æ»ù×¼
        public string HBFLOWID; // ÒµÎñÁ÷³ÌID
        public Int64 HSTOCKSTATUSID; // ¿â´æ×´Ì¬ID
        public Int64 HPRICEUNITID; // ¼Û¸ñµ¥Î»ID
        public Int64 HBASEUNITID; // »ù±¾µ¥Î»ID
        public Int64 HSNUNITID; // ÐòÁкŵ¥Î»ID
        public Int64 HREMAININSTOCKUNITID; // Ê£Óà¿â´æµ¥Î»ID
        public Int64 HEXTAUXUNITID; // À©Õ¹¸¨Öúµ¥Î»ID
        public Int64 HTAXRATEID; // Ë°ÂÊID
 
        public string HERPBillNo_Sub; // ERP×Ó±íµ¥¾ÝºÅ
        public string HSUPPLIERLOT; // ¹©Ó¦ÉÌÅú´ÎºÅ
        public string HREQTRACENO; // ÐèÇó¸ú×ÙºÅ
        public string HPROJECTNO; // ÏîÄ¿±àºÅ
        public string HGIVEAWAY; // ÔùÆ·±êʶ
        public string HROWTYPE; // ÐÐÀàÐÍ
        public string HPARENTMATID; // ¸¸ÎïÁÏID
 
        public decimal HSYSPRICE; // ÏµÍ³¼Û¸ñ
        public decimal HPRICECOEFFICIENT; // ¼Û¸ñϵÊý
        public decimal HDISCOUNTRATE; // ÕÛ¿ÛÂÊ
        public decimal HBASEUNITPRICE; // »ù±¾µ¥Î»¼Û¸ñ
        public decimal HTAXCOMBINATION; // Ë°ÖÖ×éºÏ£¬
        public decimal HPRICELISTENTRY; // ¼Û¸ñ±íÌõÄ¿
        public decimal HCOSTPRICE; // ³É±¾¼Û¸ñ
        public decimal HSEQ; // ÐòºÅ
        public decimal HTAXRATE_TAX; // Ë°ÂÊÖµ
        public decimal HTAXAMOUNT; // Ë°¶î
        public decimal HCOSTPERCENT; // ³É±¾°Ù·Ö±È
        public decimal HCOSTAMOUNT; // ³É±¾½ð¶î
 
        public string HProduceDate; // Éú²úÈÕÆÚ
        public string HExpiryDate; // ¹ýÆÚÈÕÆÚ
 
        public string HVAT; // Ôöֵ˰±êʶ
        public string HSELLERWITHHOLDING; // ÏúÊÛ·½¿Û½É
        public string HBUYERWITHHOLDING; // ²É¹º·½¿Û½É
    }
}