Inicio Explorar
Iniciar sesión
zhangg
/
MES_Client
1
0
Fork 0
Archivos Incidencias 0 Pull Requests 0 Wiki
Árbol: c937fdab63
Ramas Etiquetas
MES_Client
/
TGMES
/
Core.StlMes.Client.Sale.Common
/
Script
/
ColumnsDefine.txt

ColumnsDefine.txt 14 KB
Histórico Raw

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186 
  1. hs.Add(1,new string[]{"INPUT_WGT","录入重量","System.Double","60"});
    2. 

  2. hs.Add(2,new string[]{"PROD_LINE","产线编码","System.String","60"});
    3. 

  3. hs.Add(3,new string[]{"SPEC_ABBSYM","标准号","System.String","60"});
    4. 

  4. hs.Add(4,new string[]{"STEEL_CODE","牌号","System.String","60"});
    5. 

  5. hs.Add(5,new string[]{"USED_CD","用途","System.String","60"});
    6. 

  6. hs.Add(6,new string[]{"PRDNM_CD","交货状态","System.String","60"});
    7. 

  7. hs.Add(7,new string[]{"ISALPHA","是否Alpha(N/Y)","System.String","60"});
    8. 

  8. hs.Add(8,new string[]{"CUST_ALPHA_NO","客户Alpha编号","System.String","60"});
    9. 

  9. hs.Add(9,new string[]{"QUALITY_DESIGH_RESULT","品质设计结果","System.String","60"});
    10. 

  10. hs.Add(10,new string[]{"QUALITY_DESIGH_ERRMSG","品质设计错误信息","System.String","60"});
    11. 

  11. hs.Add(11,new string[]{"QUALITY_DESIGH_NAME","品质设计人","System.String","60"});
    12. 

  12. hs.Add(12,new string[]{"QUALITY_DESIGH_DATE","品质设计时间","System.DateTime","60"});
    13. 

  13. hs.Add(13,new string[]{"ORD_SEND_WGT","发货量","System.Double","60"});
    14. 

  14. hs.Add(14,new string[]{"ORD_INVOICE_WGT","结算量","System.Double","60"});
    15. 

  15. hs.Add(15,new string[]{"DELVRY_DATE","交货日期","System.DateTime","60"});
    16. 

  16. hs.Add(16,new string[]{"INDEX_SEQ","顺序号","System.String","60"});
    17. 

  17. hs.Add(17,new string[]{"AGENCY_FL","代办标识","System.String","60"});
    18. 

  18. hs.Add(18,new string[]{"LV_FACTY_TYP","运输方式","System.String","60"});
    19. 

  19. hs.Add(19,new string[]{"TRANSIT_TYP","运输方式","System.String","60"});
    20. 

  20. hs.Add(20,new string[]{"DESTINATION","目的地","System.String","60"});
    21. 

  21. hs.Add(21,new string[]{"STATION_NO","到站编码","System.String","60"});
    22. 

  22. hs.Add(22,new string[]{"STATION_NM","到站名称","System.String","60"});
    23. 

  23. hs.Add(23,new string[]{"SPCL_LN_NO","专用线编码","System.String","60"});
    24. 

  24. hs.Add(24,new string[]{"SPCL_LN_NM","专用线名称","System.String","60"});
    25. 

  25. hs.Add(25,new string[]{"ISOWNEDCAR","是否自备","System.String","60"});
    26. 

  26. hs.Add(26,new string[]{"ISSHIPPING","是否船运","System.String","60"});
    27. 

  27. hs.Add(27,new string[]{"PORT_NO","港口/码头","System.String","60"});
    28. 

  28. hs.Add(28,new string[]{"PORT_DESC","港口/码头描述","System.String","60"});
    29. 

  29. hs.Add(29,new string[]{"CARRIER_UNIT","承运单位","System.String","60"});
    30. 

  30. hs.Add(30,new string[]{"INCEPTCORPCODE","收货单位","System.String","60"});
    31. 

  31. hs.Add(31,new string[]{"REINCEPTCORP","代收单位","System.String","60"});
    32. 

  32. hs.Add(32,new string[]{"RECEIVOR","接货人","System.String","60"});
    33. 

  33. hs.Add(33,new string[]{"TRANSIT_LN_MNY","总费用","System.Double","60"});
    34. 

  34. hs.Add(34,new string[]{"CUSTM_ORDER_NO","客户合同号","System.String","60"});
    35. 

  35. hs.Add(35,new string[]{"ORDER_TYP","合同类型","System.String","60"});
    36. 

  36. hs.Add(36,new string[]{"ORDER_TYP_DESC","合同类型描述","System.String","60"});
    37. 

  37. hs.Add(37,new string[]{"PROTCL_NO","协议号","System.String","60"});
    38. 

  38. hs.Add(38,new string[]{"CUSTOMER_NO","客户编码","System.String","60"});
    39. 

  39. hs.Add(39,new string[]{"CUSTOMER_NM","客户名称","System.String","60"});
    40. 

  40. hs.Add(40,new string[]{"MARKET_SYS","市场系统","System.String","60"});
    41. 

  41. hs.Add(41,new string[]{"MARKET_SYS_DESC","市场系统描述","System.String","60"});
    42. 

  42. hs.Add(42,new string[]{"ABRVITION","简称","System.String","60"});
    43. 

  43. hs.Add(43,new string[]{"SUPPLY_UNIT","供货单位","System.String","60"});
    44. 

  44. hs.Add(44,new string[]{"PRICE_FL","计价方式","System.String","60"});
    45. 

  45. hs.Add(45,new string[]{"CURRENCY","币种","System.String","60"});
    46. 

  46. hs.Add(46,new string[]{"MNY_ASK_TYP","付款方式","System.String","60"});
    47. 

  47. hs.Add(47,new string[]{"ADVANCEMONEY","预付款金额","System.Double","60"});
    48. 

  48. hs.Add(48,new string[]{"ADVANCESCALE","预付款比例","System.Double","60"});
    49. 

  49. hs.Add(49,new string[]{"STLMT_UNIT_NO","结算单位编码","System.String","60"});
    50. 

  50. hs.Add(50,new string[]{"STLMT_UNIT_NM","结算单位名称","System.String","60"});
    51. 

  51. hs.Add(51,new string[]{"FST_DRAWEE_UNIT","首次受票人","System.String","60"});
    52. 

  52. hs.Add(52,new string[]{"LEGAL_PSN","法人","System.String","60"});
    53. 

  53. hs.Add(53,new string[]{"AGENT","委托代理人","System.String","60"});
    54. 

  54. hs.Add(54,new string[]{"ADDRESS","地址","System.String","60"});
    55. 

  55. hs.Add(55,new string[]{"ZIP_CODE","邮编","System.String","60"});
    56. 

  56. hs.Add(56,new string[]{"BANK","开户银行","System.String","60"});
    57. 

  57. hs.Add(57,new string[]{"ACCOUNT","帐号","System.String","60"});
    58. 

  58. hs.Add(58,new string[]{"TAX_ID","税号","System.String","60"});
    59. 

  59. hs.Add(59,new string[]{"PHONE","电话","System.String","60"});
    60. 

  60. hs.Add(60,new string[]{"FAX","传真","System.String","60"});
    61. 

  61. hs.Add(61,new string[]{"ORDER_WGT","合同量","System.Double","60"});
    62. 

  62. hs.Add(62,new string[]{"ORDER_MNY_TAX","合同总价(含税)","System.Double","60"});
    63. 

  63. hs.Add(63,new string[]{"ORDER_MNY_NTAX","合同总价(不含税)","System.Double","60"});
    64. 

  64. hs.Add(64,new string[]{"MNY_ASK_DESC","付款要求描述","System.String","60"});
    65. 

  65. hs.Add(65,new string[]{"SIGN_PERSON","签订人","System.String","60"});
    66. 

  66. hs.Add(66,new string[]{"SIGN_DATE","签订日期","System.DateTime","60"});
    67. 

  67. hs.Add(67,new string[]{"SIGN_ADDRESS","签订地点","System.String","60"});
    68. 

  68. hs.Add(68,new string[]{"ORDER_YEAR","合同年度","System.String","60"});
    69. 

  69. hs.Add(69,new string[]{"ORDER_BDATE","合同开始时间","System.DateTime","60"});
    70. 

  70. hs.Add(70,new string[]{"ORDER_EDATE","合同结束时间","System.DateTime","60"});
    71. 

  71. hs.Add(71,new string[]{"ORDER_SCAN_NO","合同扫描件编号","System.String","60"});
    72. 

  72. hs.Add(72,new string[]{"CUSTOMER_MODEL_FL","是否客户范本","System.String","60"});
    73. 

  73. hs.Add(73,new string[]{"ORDER_MODEL_NO","合同范本编号","System.String","60"});
    74. 

  74. hs.Add(74,new string[]{"ORDER_MODEL_DESC","合同范本描述","System.String","60"});
    75. 

  75. hs.Add(75,new string[]{"SALE_ORG","销售组织","System.String","60"});
    76. 

  76. hs.Add(76,new string[]{"SALE_ORG_DESC","销售组织描述","System.String","60"});
    77. 

  77. hs.Add(77,new string[]{"SALE_AREA_NO","销售区域编码","System.String","60"});
    78. 

  78. hs.Add(78,new string[]{"SALE_AREA_DESC","销售区域描述","System.String","60"});
    79. 

  79. hs.Add(79,new string[]{"ORDER_STS","合同状态","System.String","60"});
    80. 

  80. hs.Add(80,new string[]{"ORDER_STS_DESC","合同状态描述","System.String","60"});
    81. 

  81. hs.Add(81,new string[]{"APPROVAL_MAN","审批人","System.String","60"});
    82. 

  82. hs.Add(82,new string[]{"APPROVAL_TIME","审批时间","System.DateTime","60"});
    83. 

  83. hs.Add(83,new string[]{"EFFECT_MAN","生效人","System.String","60"});
    84. 

  84. hs.Add(84,new string[]{"EFFECT_TIME","生效时间","System.DateTime","60"});
    85. 

  85. hs.Add(85,new string[]{"CLOSE_MAN","结案人","System.String","60"});
    86. 

  86. hs.Add(86,new string[]{"CLOSE_TIME","结案时间","System.DateTime","60"});
    87. 

  87. hs.Add(87,new string[]{"CREATE_DEPT","创建人部门","System.String","60"});
    88. 

  88. hs.Add(88,new string[]{"REGION_NO","地域片区","System.String","60"});
    89. 

  89. hs.Add(89,new string[]{"TRANSFEE","运费","System.Double","60"});
    90. 

  90. hs.Add(90,new string[]{"CARTYPE","车种","System.String","60"});
    91. 

  91. hs.Add(91,new string[]{"KILOMETERS","公里数","System.String","60"});
    92. 

  92. hs.Add(92,new string[]{"PRAILWAYADMIN","所属路局","System.String","60"});
    93. 

  93. hs.Add(93,new string[]{"TELEGRAPHCODE","电报码","System.String","60"});
    94. 

  94. hs.Add(94,new string[]{"GODIRECTCODE","运行方向","System.String","60"});
    95. 

  95. hs.Add(95,new string[]{"LOADDOCK","装货码头","System.String","60"});
    96. 

  96. hs.Add(96,new string[]{"UNLOADDOCK","卸货码头","System.String","60"});
    97. 

  97. hs.Add(97,new string[]{"SERVICECHARGE","劳务费","System.Double","60"});
    98. 

  98. hs.Add(98,new string[]{"W_TRAN_LINE","水运线路","System.String","60"});
    99. 

  99. hs.Add(99,new string[]{"C_TRAN_LINE","汽运线路","System.String","60"});
    100. 

  100. hs.Add(100,new string[]{"ACCEPT_PERSON","收货人","System.String","60"});
    101. 

  101. hs.Add(101,new string[]{"OWNED_CITY","所属城市","System.String","60"});
    102. 

  102. hs.Add(102,new string[]{"REMARK","备注","System.String","60"});
    103. 

  103. hs.Add(103,new string[]{"PERCODE","身份证","System.String","60"});
    104. 

  104. hs.Add(104,new string[]{"TELCODE","收货人电话","System.String","60"});
    105. 

  105. hs.Add(105,new string[]{"FORECORPCODE","子公司编码","System.String","60"});
    106. 

  106. hs.Add(106,new string[]{"FORECORPNAME","驻外公司名称","System.String","60"});
    107. 

  107. hs.Add(107,new string[]{"PRINCIPAL","负责人","System.String","60"});
    108. 

  108. hs.Add(108,new string[]{"FORE_TP","类型区分","System.String","60"});
    109. 

  109. hs.Add(109,new string[]{"REGION_LVL_NO","行政区域级别编码","System.String","60"});
    110. 

  110. hs.Add(110,new string[]{"REGION_LVL_NM","行政区域级别名称","System.String","60"});
    111. 

  111. hs.Add(111,new string[]{"REGION_TYPE_NO","行政区域属性编码","System.String","60"});
    112. 

  112. hs.Add(112,new string[]{"REGION_TYPE_NM","行政区域属性名称","System.String","60"});
    113. 

  113. hs.Add(113,new string[]{"REGION_NM","行政区域名称","System.String","60"});
    114. 

  114. hs.Add(114,new string[]{"P_REGION_NO","上级行政区域编码","System.String","60"});
    115. 

  115. hs.Add(115,new string[]{"REGION_TYPE","行政区域属性","System.String","60"});
    116. 

  116. hs.Add(116,new string[]{"CAPITAL_FL","是否首都","System.String","60"});
    117. 

  117. hs.Add(117,new string[]{"PR_CAPITAL_FL","是否省会","System.String","60"});
    118. 

  118. hs.Add(118,new string[]{"REGION_SEQ","行政区域顺序","System.String","60"});
    119. 

  119. hs.Add(119,new string[]{"BIGAREA","行政片区","System.String","60"});
    120. 

  120. hs.Add(120,new string[]{"CUSTM_LVL","客户等级","System.String","60"});
    121. 

  121. hs.Add(121,new string[]{"ORG","组织机构","System.String","60"});
    122. 

  122. hs.Add(122,new string[]{"PY","拼音助记","System.String","60"});
    123. 

  123. hs.Add(123,new string[]{"CUSTM_USE","用途类型","System.String","60"});
    124. 

  124. hs.Add(124,new string[]{"CHN_FL","国内/国外","System.String","60"});
    125. 

  125. hs.Add(125,new string[]{"CUSTM_CTGRY","客户类别","System.String","60"});
    126. 

  126. hs.Add(126,new string[]{"CUSTM_PRPTY","客户性质","System.String","60"});
    127. 

  127. hs.Add(127,new string[]{"SALECARD","营业执照","System.String","60"});
    128. 

  128. hs.Add(128,new string[]{"CUSTM_DATA","客户资质材料","System.String","60"});
    129. 

  129. hs.Add(129,new string[]{"TRANS_TYP","运输方式","System.String","60"});
    130. 

  130. hs.Add(130,new string[]{"INCERPTCODE","收货单位","System.String","60"});
    131. 

  131. hs.Add(131,new string[]{"SHIP_DESTINATION","船运港口","System.String","60"});
    132. 

  132. hs.Add(132,new string[]{"ORDER_NO","合同号","System.String","60"});
    133. 

  133. hs.Add(133,new string[]{"ORDER_SEQ","合同行号","System.String","60"});
    134. 

  134. hs.Add(134,new string[]{"HEIGHT","厚度","System.Double","60"});
    135. 

  135. hs.Add(135,new string[]{"WIDTH","宽度","System.Double","60"});
    136. 

  136. hs.Add(136,new string[]{"LENGTH","长度","System.Double","60"});
    137. 

  137. hs.Add(137,new string[]{"FIXSIZE","定尺方式","System.String","60"});
    138. 

  138. hs.Add(138,new string[]{"LEN_MIN","下限","System.Double","60"});
    139. 

  139. hs.Add(139,new string[]{"LEN_MAX","上限","System.Double","60"});
    140. 

  140. hs.Add(140,new string[]{"WIDTH_MIN","宽度下限","System.Double","60"});
    141. 

  141. hs.Add(141,new string[]{"WIDTH_MAX","宽度上限","System.Double","60"});
    142. 

  142. hs.Add(142,new string[]{"SENDSTATUS","切边方式","System.String","60"});
    143. 

  143. hs.Add(143,new string[]{"ORDER_UNIT","订货计量单位","System.String","60"});
    144. 

  144. hs.Add(144,new string[]{"ORDER_QTY","订货件数","System.Double","60"});
    145. 

  145. hs.Add(145,new string[]{"WEIGHT","订货重量","System.Double","60"});
    146. 

  146. hs.Add(146,new string[]{"DELVRY_RANGE_TPE","交货量差方式","System.String","60"});
    147. 

  147. hs.Add(147,new string[]{"DELVRY_RANGE_MIN","交货量差下限","System.Double","60"});
    148. 

  148. hs.Add(148,new string[]{"DELVRY_RANGE_MAX","交货量差上限","System.Double","60"});
    149. 

  149. hs.Add(149,new string[]{"ISWELDED_HEAT","是否模拟焊后","System.String","60"});
    150. 

  150. hs.Add(150,new string[]{"NUCLEARSTEEL","核电钢要求","System.String","60"});
    151. 

  151. hs.Add(151,new string[]{"KHIC","抗HIC试验","System.String","60"});
    152. 

  152. hs.Add(152,new string[]{"ISPOSTER","保性能判别","System.String","60"});
    153. 

  153. hs.Add(153,new string[]{"FINAL_USER","最终用户","System.String","60"});
    154. 

  154. hs.Add(154,new string[]{"FINAL_USER_DESC","最终用户描述","System.String","60"});
    155. 

  155. hs.Add(155,new string[]{"DELVRY_BDATE","交货开始日期","System.DateTime","60"});
    156. 

  156. hs.Add(156,new string[]{"DELVRY_EDATE","交货结束日期","System.DateTime","60"});
    157. 

  157. hs.Add(157,new string[]{"DELVRY_DESC","交货信息描述","System.String","60"});
    158. 

  158. hs.Add(158,new string[]{"TRANS_DESC","运输信息描述","System.String","60"});
    159. 

  159. hs.Add(159,new string[]{"ADD_ASK_NO","附加要求编码","System.String","60"});
    160. 

  160. hs.Add(160,new string[]{"ORDER_ADD_DESC","订货附加要求描述","System.String","60"});
    161. 

  161. hs.Add(161,new string[]{"ORDER_SPECIAL_FL","产品特殊要求标识","System.String","60"});
    162. 

  162. hs.Add(162,new string[]{"ORDER_SPECIAL_HEAD","特殊要求技术规范说明","System.String","60"});
    163. 

  163. hs.Add(163,new string[]{"ORDER_SPECIAL_PATH","技术规范文件路径","System.String","60"});
    164. 

  164. hs.Add(164,new string[]{"ORDER_SPECIAL_DESC","产品特殊要求描述","System.String","60"});
    165. 

  165. hs.Add(165,new string[]{"ZBS","质保书","System.String","60"});
    166. 

  166. hs.Add(166,new string[]{"ORDER_PRICE","订货价","System.Double","60"});
    167. 

  167. hs.Add(167,new string[]{"TRANS_PRICE","运费","System.Double","60"});
    168. 

  168. hs.Add(168,new string[]{"TEST_ID","测价序号","System.String","60"});
    169. 

  169. hs.Add(169,new string[]{"TEST_PRICE","测算价","System.Double","60"});
    170. 

  170. hs.Add(170,new string[]{"OUT_PRICE","出厂价","System.Double","60"});
    171. 

  171. hs.Add(171,new string[]{"BALNCE_PRICE","结算价","System.Double","60"});
    172. 

  172. hs.Add(172,new string[]{"ORDER_LN_STATUS","合同行状态","System.String","60"});
    173. 

  173. hs.Add(173,new string[]{"REVIEW_STATUS","评审状态","System.String","60"});
    174. 

  174. hs.Add(174,new string[]{"REVIEW_MSG","评审信息","System.String","60"});
    175. 

  175. hs.Add(175,new string[]{"REVIEW_DATE","评审时间","System.DateTime","60"});
    176. 

  176. hs.Add(176,new string[]{"REVIEW_ENTRYDATE","评审结果录入时间","System.DateTime","60"});
    177. 

  177. hs.Add(177,new string[]{"MEMO","备注","System.String","60"});
    178. 

  178. hs.Add(178,new string[]{"VALIDFLAG","有效标志","System.String","60"});
    179. 

  179. hs.Add(179,new string[]{"CREATE_NAME","创建人","System.String","60"});
    180. 

  180. hs.Add(180,new string[]{"CREATE_TIME","创建时间","System.DateTime","60"});
    181. 

  181. hs.Add(181,new string[]{"UPDATE_NAME","修改人","System.String","60"});
    182. 

  182. hs.Add(182,new string[]{"UPDATE_TIME","修改时间","System.DateTime","60"});
    183. 

  183. hs.Add(183,new string[]{"DELETE_NAME","删除人","System.String","60"});
    184. 

  184. hs.Add(184,new string[]{"DELETE_TIME","删除时间","System.DateTime","60"});
    185. 

  185. 

  186. select ' /// <summary>'||chr(13)||'///'|| a.columncaption||chr(13)|| ' /// </summary>'||chr(13)|| 'private static string '||a.columnname || ' ;' from SLM_COL_COLUMNDEFINE a order by a.columnname 
    187.