update20240131.sql 88 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138
  1. CREATE TABLE `zh_change_project_history` (
  2. `id` int(11) NOT NULL AUTO_INCREMENT,
  3. `tid` int(11) NOT NULL COMMENT '标段id',
  4. `cpid` int(11) NOT NULL COMMENT '变更立项id',
  5. `info_json` json DEFAULT NULL COMMENT '内容json值',
  6. PRIMARY KEY (`id`)
  7. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='变更立项内容临时保存表,用于修订撤销与撤回';
  8. CREATE TABLE `zh_change_apply_history` (
  9. `id` int(11) NOT NULL AUTO_INCREMENT,
  10. `tid` int(11) NOT NULL COMMENT '标段id',
  11. `caid` int(11) NOT NULL COMMENT '变更申请id',
  12. `info_json` json DEFAULT NULL COMMENT '内容json值',
  13. `list_json` json DEFAULT NULL COMMENT '清单json值',
  14. PRIMARY KEY (`id`)
  15. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='变更申请内容临时保存表,用于修订撤销与撤回';
  16. CREATE TABLE `zh_change_plan_history` (
  17. `id` int(11) NOT NULL AUTO_INCREMENT,
  18. `tid` int(11) NOT NULL COMMENT '标段id',
  19. `cpid` int(11) NOT NULL COMMENT '变更方案id',
  20. `info_json` json DEFAULT NULL COMMENT '内容json值',
  21. `list_json` json DEFAULT NULL COMMENT '清单json值',
  22. PRIMARY KEY (`id`)
  23. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='变更方案内容临时保存表,用于修订撤销与撤回';
  24. ALTER TABLE `zh_ledger_tag`
  25. ADD COLUMN `settle_id` int(11) NOT NULL DEFAULT -1 AFTER `sorder`,
  26. ADD COLUMN `settle_order` tinyint(4) NOT NULL DEFAULT -1 AFTER `settle_id`;
  27. ALTER TABLE `zh_ledger_attachment`
  28. ADD COLUMN `settle_id` int(11) NOT NULL DEFAULT -1 COMMENT '结算id' AFTER `tid`,
  29. ADD COLUMN `settle_order` tinyint(4) NOT NULL DEFAULT -1 COMMENT '结算期序号' AFTER `settle_id`;
  30. ALTER TABLE `zh_s2b_spec_msg`
  31. ADD COLUMN `advance_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '预付款期id' AFTER `rid`,
  32. ADD COLUMN `material_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '材差期id' AFTER `advance_id`,
  33. ADD COLUMN `c_apply_id` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '变更申请id' AFTER `material_id`,
  34. ADD COLUMN `c_proj_id` int(11) UNSIGNED NOT NULL COMMENT '变更立项id' AFTER `c_apply_id`,
  35. ADD COLUMN `c_plan_id` int(11) UNSIGNED NOT NULL COMMENT '变更方案id' AFTER `c_proj_id`,
  36. ADD COLUMN `extra_info` varchar(1000) NOT NULL DEFAULT '' COMMENT '附加信息(主要用于报表)' AFTER `timing`;
  37. ALTER TABLE `zh_s2b_spec_push_log`
  38. ADD COLUMN `push_3f_id` varchar(255) NOT NULL DEFAULT '' COMMENT '3方交互key(对方id)' AFTER `multi_content`,
  39. ADD COLUMN `push_3f_res` text NULL COMMENT '3方交互,确认结果(对方推送)' AFTER `push_3f_id`,
  40. ADD COLUMN `push_3f_tag` varchar(50) NOT NULL DEFAULT '' COMMENT '3方交互标记(关键信息,通过/拒签/过期等)' AFTER `push_3f_res`;
  41. CREATE TABLE `zh_settle` (
  42. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'id',
  43. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  44. `add_sid` int(11) unsigned NOT NULL COMMENT '新增时的期id',
  45. `add_sorder` tinyint(4) unsigned NOT NULL COMMENT '新增时的期序号',
  46. `user_id` int(11) unsigned NOT NULL COMMENT '创建人id',
  47. `final_sid` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '上报时,结算数据管理的最大期id',
  48. `final_sorder` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上报时,结算数据管理的最大期序号',
  49. `settle_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算期序号',
  50. `settle_time` varchar(20) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '结算年月',
  51. `settle_period` varchar(40) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '结算周期',
  52. `audit_times` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '审批次',
  53. `audit_status` tinyint(4) unsigned NOT NULL DEFAULT '1' COMMENT '审批状态',
  54. `audit_start_time` timestamp NULL DEFAULT NULL COMMENT '上报时间(最新一次审批)',
  55. `audit_finsih_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '审批完成时间',
  56. `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  57. `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  58. `contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同金额',
  59. `positive_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-正变更金额',
  60. `negative_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-负变更金额',
  61. `qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-变更金额',
  62. `tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期金额',
  63. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同金额',
  64. `pre_positive_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-正变更金额',
  65. `pre_negative_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-负变更金额',
  66. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-变更金额',
  67. `pre_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期金额',
  68. PRIMARY KEY (`id`)
  69. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='过程结算';
  70. CREATE TABLE `zh_settle_audit` (
  71. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  72. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  73. `settle_id` bigint(20) unsigned NOT NULL COMMENT '结算id',
  74. `audit_id` int(11) unsigned NOT NULL COMMENT '流程参与人id(含原报)',
  75. `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '参与人-姓名',
  76. `company` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '参与人-单位',
  77. `role` varchar(30) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '参与人-角色',
  78. `mobile` varchar(15) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '参与人-电话',
  79. `audit_times` int(11) unsigned NOT NULL DEFAULT '1' COMMENT '审批次数',
  80. `audit_order` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '预定流程顺序',
  81. `audit_type` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '流程类型',
  82. `active_order` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '实际流程顺序',
  83. `audit_status` int(11) unsigned NOT NULL DEFAULT '0' COMMENT '流程状态',
  84. `audit_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '流程结束时间',
  85. `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  86. `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '最后更新时间',
  87. `opinion` varchar(1000) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '意见',
  88. PRIMARY KEY (`id`)
  89. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  90. CREATE TABLE `zh_settle_select` (
  91. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  92. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  93. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  94. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  95. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '结算台账节点id',
  96. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '结算计量单元节点id',
  97. `user_id` int(11) unsigned NOT NULL COMMENT '添加人',
  98. PRIMARY KEY (`id`)
  99. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  100. CREATE TABLE `zh_settle_bills_0` (
  101. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  102. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  103. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  104. `settle_order` tinyint(4) NOT NULL,
  105. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  106. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  107. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  108. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  109. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  110. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  111. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  112. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  113. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  114. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  115. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  116. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  117. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  118. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  119. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  120. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  121. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  122. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  123. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  124. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  125. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  126. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  127. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  128. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  129. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  130. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  131. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  132. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  133. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  134. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  135. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  136. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  137. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  138. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  139. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  140. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  141. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  142. PRIMARY KEY (`id`)
  143. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  144. CREATE TABLE `zh_settle_bills_1` (
  145. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  146. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  147. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  148. `settle_order` tinyint(4) NOT NULL,
  149. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  150. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  151. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  152. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  153. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  154. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  155. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  156. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  157. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  158. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  159. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  160. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  161. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  162. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  163. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  164. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  165. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  166. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  167. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  168. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  169. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  170. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  171. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  172. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  173. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  174. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  175. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  176. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  177. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  178. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  179. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  180. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  181. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  182. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  183. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  184. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  185. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  186. PRIMARY KEY (`id`)
  187. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  188. CREATE TABLE `zh_settle_bills_2` (
  189. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  190. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  191. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  192. `settle_order` tinyint(4) NOT NULL,
  193. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  194. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  195. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  196. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  197. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  198. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  199. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  200. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  201. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  202. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  203. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  204. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  205. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  206. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  207. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  208. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  209. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  210. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  211. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  212. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  213. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  214. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  215. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  216. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  217. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  218. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  219. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  220. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  221. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  222. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  223. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  224. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  225. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  226. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  227. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  228. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  229. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  230. PRIMARY KEY (`id`)
  231. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  232. CREATE TABLE `zh_settle_bills_3` (
  233. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  234. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  235. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  236. `settle_order` tinyint(4) NOT NULL,
  237. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  238. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  239. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  240. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  241. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  242. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  243. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  244. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  245. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  246. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  247. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  248. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  249. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  250. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  251. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  252. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  253. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  254. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  255. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  256. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  257. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  258. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  259. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  260. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  261. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  262. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  263. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  264. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  265. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  266. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  267. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  268. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  269. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  270. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  271. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  272. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  273. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  274. PRIMARY KEY (`id`)
  275. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  276. CREATE TABLE `zh_settle_bills_4` (
  277. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  278. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  279. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  280. `settle_order` tinyint(4) NOT NULL,
  281. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  282. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  283. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  284. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  285. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  286. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  287. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  288. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  289. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  290. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  291. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  292. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  293. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  294. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  295. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  296. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  297. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  298. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  299. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  300. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  301. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  302. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  303. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  304. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  305. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  306. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  307. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  308. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  309. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  310. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  311. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  312. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  313. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  314. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  315. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  316. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  317. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  318. PRIMARY KEY (`id`)
  319. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  320. CREATE TABLE `zh_settle_bills_5` (
  321. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  322. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  323. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  324. `settle_order` tinyint(4) NOT NULL,
  325. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  326. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  327. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  328. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  329. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  330. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  331. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  332. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  333. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  334. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  335. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  336. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  337. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  338. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  339. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  340. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  341. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  342. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  343. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  344. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  345. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  346. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  347. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  348. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  349. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  350. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  351. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  352. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  353. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  354. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  355. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  356. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  357. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  358. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  359. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  360. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  361. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  362. PRIMARY KEY (`id`)
  363. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  364. CREATE TABLE `zh_settle_bills_6` (
  365. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  366. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  367. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  368. `settle_order` tinyint(4) NOT NULL,
  369. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  370. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  371. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  372. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  373. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  374. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  375. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  376. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  377. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  378. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  379. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  380. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  381. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  382. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  383. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  384. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  385. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  386. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  387. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  388. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  389. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  390. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  391. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  392. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  393. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  394. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  395. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  396. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  397. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  398. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  399. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  400. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  401. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  402. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  403. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  404. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  405. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  406. PRIMARY KEY (`id`)
  407. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  408. CREATE TABLE `zh_settle_bills_7` (
  409. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  410. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  411. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  412. `settle_order` tinyint(4) NOT NULL,
  413. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  414. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  415. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  416. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  417. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  418. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  419. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  420. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  421. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  422. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  423. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  424. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  425. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  426. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  427. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  428. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  429. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  430. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  431. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  432. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  433. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  434. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  435. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  436. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  437. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  438. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  439. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  440. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  441. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  442. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  443. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  444. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  445. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  446. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  447. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  448. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  449. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  450. PRIMARY KEY (`id`)
  451. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  452. CREATE TABLE `zh_settle_bills_8` (
  453. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  454. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  455. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  456. `settle_order` tinyint(4) NOT NULL,
  457. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  458. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  459. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  460. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  461. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  462. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  463. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  464. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  465. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  466. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  467. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  468. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  469. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  470. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  471. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  472. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  473. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  474. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  475. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  476. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  477. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  478. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  479. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  480. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  481. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  482. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  483. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  484. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  485. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  486. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  487. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  488. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  489. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  490. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  491. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  492. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  493. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  494. PRIMARY KEY (`id`)
  495. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  496. CREATE TABLE `zh_settle_bills_9` (
  497. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  498. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  499. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  500. `settle_order` tinyint(4) NOT NULL,
  501. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  502. `tree_id` int(11) unsigned NOT NULL COMMENT '树结构-id',
  503. `tree_pid` int(11) NOT NULL COMMENT '树结构-父id',
  504. `tree_full_path` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT '树结构-完整路径',
  505. `tree_is_leaf` tinyint(4) unsigned NOT NULL COMMENT '树结构-是否最底层',
  506. `tree_level` tinyint(4) unsigned NOT NULL COMMENT '树结构-层次',
  507. `tree_order` tinyint(4) unsigned NOT NULL COMMENT '树结构-同层排序',
  508. `code` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT '项目节编号',
  509. `b_code` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '清单编号',
  510. `name` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  511. `unit` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '单位',
  512. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  513. `unit_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '单价',
  514. `total_price` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '金额',
  515. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  516. `memo` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '备注',
  517. `node_type` int(4) unsigned NOT NULL DEFAULT '0' COMMENT '节点类别',
  518. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-数量',
  519. `cur_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-合同-金额',
  520. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  521. `cur_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-金额',
  522. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-不计价',
  523. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  524. `pre_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-金额',
  525. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  526. `pre_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-金额',
  527. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  528. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  529. `end_contract_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-金额',
  530. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  531. `end_qc_tp` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-金额',
  532. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  533. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  534. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  535. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  536. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  537. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  538. PRIMARY KEY (`id`)
  539. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  540. CREATE TABLE `zh_settle_pos_0` (
  541. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  542. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  543. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  544. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  545. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  546. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  547. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  548. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  549. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  550. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  551. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  552. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  553. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  554. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  555. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  556. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  557. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  558. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  559. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  560. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  561. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  562. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  563. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  564. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  565. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  566. PRIMARY KEY (`id`)
  567. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  568. CREATE TABLE `zh_settle_pos_1` (
  569. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  570. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  571. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  572. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  573. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  574. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  575. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  576. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  577. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  578. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  579. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  580. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  581. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  582. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  583. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  584. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  585. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  586. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  587. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  588. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  589. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  590. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  591. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  592. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  593. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  594. PRIMARY KEY (`id`)
  595. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  596. CREATE TABLE `zh_settle_pos_2` (
  597. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  598. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  599. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  600. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  601. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  602. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  603. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  604. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  605. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  606. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  607. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  608. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  609. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  610. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  611. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  612. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  613. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  614. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  615. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  616. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  617. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  618. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  619. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  620. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  621. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  622. PRIMARY KEY (`id`)
  623. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  624. CREATE TABLE `zh_settle_pos_3` (
  625. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  626. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  627. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  628. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  629. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  630. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  631. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  632. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  633. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  634. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  635. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  636. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  637. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  638. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  639. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  640. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  641. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  642. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  643. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  644. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  645. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  646. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  647. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  648. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  649. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  650. PRIMARY KEY (`id`)
  651. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  652. CREATE TABLE `zh_settle_pos_4` (
  653. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  654. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  655. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  656. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  657. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  658. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  659. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  660. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  661. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  662. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  663. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  664. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  665. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  666. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  667. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  668. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  669. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  670. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  671. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  672. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  673. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  674. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  675. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  676. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  677. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  678. PRIMARY KEY (`id`)
  679. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  680. CREATE TABLE `zh_settle_pos_5` (
  681. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  682. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  683. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  684. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  685. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  686. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  687. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  688. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  689. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  690. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  691. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  692. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  693. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  694. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  695. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  696. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  697. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  698. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  699. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  700. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  701. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  702. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  703. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  704. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  705. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  706. PRIMARY KEY (`id`)
  707. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  708. CREATE TABLE `zh_settle_pos_6` (
  709. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  710. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  711. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  712. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  713. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  714. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  715. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  716. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  717. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  718. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  719. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  720. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  721. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  722. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  723. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  724. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  725. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  726. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  727. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  728. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  729. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  730. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  731. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  732. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  733. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  734. PRIMARY KEY (`id`)
  735. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  736. CREATE TABLE `zh_settle_pos_7` (
  737. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  738. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  739. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  740. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  741. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  742. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  743. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  744. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  745. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  746. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  747. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  748. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  749. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  750. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  751. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  752. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  753. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  754. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  755. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  756. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  757. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  758. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  759. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  760. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  761. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  762. PRIMARY KEY (`id`)
  763. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  764. CREATE TABLE `zh_settle_pos_8` (
  765. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  766. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  767. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  768. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  769. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  770. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  771. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  772. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  773. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  774. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  775. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  776. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  777. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  778. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  779. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  780. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  781. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  782. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  783. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  784. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  785. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  786. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  787. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  788. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  789. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  790. PRIMARY KEY (`id`)
  791. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  792. CREATE TABLE `zh_settle_pos_9` (
  793. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  794. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  795. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  796. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  797. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  798. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  799. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  800. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  801. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  802. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  803. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  804. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  805. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  806. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  807. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  808. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  809. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  810. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  811. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  812. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  813. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  814. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  815. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  816. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  817. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  818. PRIMARY KEY (`id`)
  819. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  820. CREATE TABLE `zh_settle_pos_10` (
  821. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  822. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  823. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  824. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  825. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  826. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  827. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  828. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  829. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  830. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  831. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  832. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  833. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  834. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  835. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  836. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  837. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  838. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  839. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  840. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  841. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  842. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  843. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  844. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  845. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  846. PRIMARY KEY (`id`)
  847. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  848. CREATE TABLE `zh_settle_pos_11` (
  849. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  850. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  851. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  852. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  853. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  854. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  855. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  856. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  857. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  858. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  859. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  860. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  861. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  862. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  863. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  864. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  865. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  866. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  867. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  868. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  869. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  870. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  871. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  872. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  873. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  874. PRIMARY KEY (`id`)
  875. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  876. CREATE TABLE `zh_settle_pos_12` (
  877. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  878. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  879. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  880. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  881. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  882. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  883. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  884. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  885. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  886. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  887. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  888. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  889. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  890. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  891. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  892. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  893. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  894. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  895. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  896. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  897. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  898. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  899. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  900. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  901. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  902. PRIMARY KEY (`id`)
  903. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  904. CREATE TABLE `zh_settle_pos_13` (
  905. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  906. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  907. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  908. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  909. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  910. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  911. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  912. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  913. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  914. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  915. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  916. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  917. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  918. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  919. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  920. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  921. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  922. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  923. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  924. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  925. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  926. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  927. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  928. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  929. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  930. PRIMARY KEY (`id`)
  931. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  932. CREATE TABLE `zh_settle_pos_14` (
  933. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  934. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  935. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  936. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  937. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  938. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  939. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  940. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  941. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  942. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  943. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  944. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  945. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  946. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  947. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  948. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  949. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  950. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  951. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  952. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  953. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  954. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  955. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  956. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  957. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  958. PRIMARY KEY (`id`)
  959. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  960. CREATE TABLE `zh_settle_pos_15` (
  961. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  962. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  963. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  964. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  965. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  966. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  967. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  968. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  969. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  970. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  971. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  972. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  973. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  974. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  975. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  976. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  977. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  978. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  979. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  980. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  981. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  982. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  983. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  984. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  985. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  986. PRIMARY KEY (`id`)
  987. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  988. CREATE TABLE `zh_settle_pos_16` (
  989. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  990. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  991. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  992. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  993. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  994. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  995. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  996. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  997. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  998. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  999. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  1000. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  1001. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  1002. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  1003. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  1004. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  1005. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  1006. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  1007. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  1008. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  1009. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  1010. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  1011. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  1012. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  1013. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  1014. PRIMARY KEY (`id`)
  1015. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1016. CREATE TABLE `zh_settle_pos_17` (
  1017. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  1018. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  1019. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  1020. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  1021. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  1022. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  1023. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  1024. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  1025. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  1026. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  1027. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  1028. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  1029. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  1030. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  1031. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  1032. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  1033. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  1034. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  1035. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  1036. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  1037. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  1038. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  1039. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  1040. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  1041. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  1042. PRIMARY KEY (`id`)
  1043. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1044. CREATE TABLE `zh_settle_pos_18` (
  1045. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  1046. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  1047. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  1048. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  1049. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  1050. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  1051. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  1052. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  1053. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  1054. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  1055. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  1056. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  1057. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  1058. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  1059. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  1060. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  1061. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  1062. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  1063. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  1064. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  1065. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  1066. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  1067. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  1068. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  1069. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  1070. PRIMARY KEY (`id`)
  1071. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
  1072. CREATE TABLE `zh_settle_pos_19` (
  1073. `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  1074. `tid` int(11) unsigned NOT NULL COMMENT '标段id',
  1075. `settle_id` int(11) unsigned NOT NULL COMMENT '结算期id',
  1076. `settle_order` tinyint(4) unsigned NOT NULL COMMENT '结算期序号',
  1077. `lid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_ledger.id',
  1078. `pid` varchar(36) COLLATE utf8_unicode_ci NOT NULL COMMENT 'zh_pos.id',
  1079. `name` varchar(1000) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '名称',
  1080. `drawing_code` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '图册号',
  1081. `quantity` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '数量',
  1082. `cur_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期计算-合同-数量',
  1083. `cur_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期结算-数量变更-数量',
  1084. `cur_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '本期变更-不计价',
  1085. `pre_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-合同-数量',
  1086. `pre_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-数量变更-数量',
  1087. `pre_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止上期结算-不计价',
  1088. `end_contract_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-合同-数量',
  1089. `end_qc_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-数量变更-数量',
  1090. `end_qc_minus_qty` decimal(24,8) NOT NULL DEFAULT '0.00000000' COMMENT '截止本期结算-不计价',
  1091. `is_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否结算',
  1092. `pre_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '上期是否结算',
  1093. `settle_status` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算状态',
  1094. `settle_done_order` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '结算完成期',
  1095. `is_org_settle` tinyint(4) unsigned NOT NULL DEFAULT '0' COMMENT '是否原始勾选台账',
  1096. `porder` int(11) unsigned NOT NULL DEFAULT '1',
  1097. `position` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '位置',
  1098. PRIMARY KEY (`id`)
  1099. ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;