financialManagement.sql 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386
  1. /*
  2. ===================================粮食财务 预算填报表 start=========================================
  3. */
  4. CREATE TABLE "BUSINESS"."BIZ_FINANCIAL_BUDGET_FILLING"
  5. ( "ID" VARCHAR2(36) NOT NULL ENABLE,
  6. "CREATE_BY" VARCHAR2(36) DEFAULT -1,
  7. "CREATE_TIME" TIMESTAMP (6) DEFAULT null,
  8. "DELETE_BY" VARCHAR2(36) DEFAULT -1,
  9. "DELETE_TIME" TIMESTAMP (6),
  10. "UPDATE_BY" VARCHAR2(36) DEFAULT -1,
  11. "UPDATE_TIME" TIMESTAMP (6) DEFAULT null,
  12. "ORG_ID" VARCHAR2(50),
  13. "DEPT_ID" VARCHAR2(50),
  14. "AREA_CODE" VARCHAR2(50),
  15. "PROJECT_NAME" VARCHAR2(200),
  16. "DEPARTMENTS_CODES" VARCHAR2(200),
  17. "IMPLEMENTATION_UNIT" VARCHAR2(200),
  18. "PROJECT_ATTRIBUTES" VARCHAR2(200),
  19. "PROJECT_PERIOD" VARCHAR2(200),
  20. "TOTAL_ANNUAL_FUNDS" VARCHAR2(200),
  21. "FINANCIAL_ALLOCATION" VARCHAR2(200),
  22. "OTHER_FUNDS" VARCHAR2(200),
  23. "TOTAL_MEDIUM-TERM _FUNDS" VARCHAR2(200),
  24. "MEDIUM-TERM_FINANCIAL_ALLOCATI" VARCHAR2(200),
  25. "MEDIUM-TERM_OTHER_FUNDS" VARCHAR2(200),
  26. "PROJECT_CONTENT" VARCHAR2(200),
  27. "BASIS_APPLICATION" VARCHAR2(200),
  28. "CALCULATING_PROCESS" VARCHAR2(200),
  29. "ANNUAL_TARGET" VARCHAR2(200),
  30. "MEDIUM-TERM_OBJECTIVES" VARCHAR2(200),
  31. "QUANTITY-INDICATOR_CONTENT" VARCHAR2(200),
  32. "QUANTITY-ANNUAL_INDICATOR" VARCHAR2(200),
  33. "QUANTITY-MEDIUM_TERM" VARCHAR2(200),
  34. "QUALITY_INDICATOR_CONTENT" VARCHAR2(200),
  35. "QUALITY-ANNUAL_INDICATOR" VARCHAR2(200),
  36. "QUALITY-MEDIUM_TERM" VARCHAR2(200),
  37. "PRESCRIPTION-INDICATOR_CONTENT" VARCHAR2(200),
  38. "PRESCRIPTION-ANNUAL_INDICATOR" VARCHAR2(200),
  39. "PRESCRIPTION-MEDIUM_TERM" VARCHAR2(200),
  40. "COST-INDICATOR_CONTENT" VARCHAR2(200),
  41. "COST-ANNUAL_INDICATOR" VARCHAR2(200),
  42. "COST-MEDIUM_TERM" VARCHAR2(200),
  43. "ECONOMICS-INDICATOR_CONTENT" VARCHAR2(200),
  44. "ECONOMICS-ANNUAL_INDICATOR" VARCHAR2(200),
  45. "ECONOMICS-MEDIUM_TERM" VARCHAR2(200),
  46. "SOCIOLOGY-INDICATOR_CONTENT" VARCHAR2(200),
  47. "SOCIOLOGY-ANNUAL_INDICATOR" VARCHAR2(200),
  48. "SOCIOLOGY-MEDIUM_TERM" VARCHAR2(200),
  49. "ENVIRONMENTAL-INDICATOR_CONTEN" VARCHAR2(200),
  50. "ENVIRONMENTAL-ANNUAL_INDICATOR" VARCHAR2(200),
  51. "ENVIRONMENTAL-MEDIUM_TERM" VARCHAR2(200),
  52. "SUSTAINABILI-INDICATOR_CONTENT" VARCHAR2(200),
  53. "SUSTAINABILIT-ANNUAL_INDICATOR" VARCHAR2(200),
  54. "SUSTAINABILITY-MEDIUM_TERM" VARCHAR2(200),
  55. "SERVICE-INDICATOR_CONTENT" VARCHAR2(200),
  56. "SERVICE-ANNUAL_INDICATOR" VARCHAR2(200),
  57. "SERVICE-MEDIUM_TERM" VARCHAR2(200),
  58. "APPLICATION_OFFICE" VARCHAR2(200),
  59. "APPLICATION_DATE" TIMESTAMP (6),
  60. "AUDIT_OPINIONS" VARCHAR2(200),
  61. "FINDINGS_AUDIT" VARCHAR2(200),
  62. "AUDITOR" VARCHAR2(200),
  63. "AUDIT_DATE" TIMESTAMP (6),
  64. "ATTACH_ID" VARCHAR2(36),
  65. "ATTACH_NAME" VARCHAR2(36),
  66. "IS_IMPORT_PERFORMANCE" VARCHAR2(20 CHAR) DEFAULT 0,
  67. "PROJECT_ID" VARCHAR2(36)
  68. ) SEGMENT CREATION IMMEDIATE
  69. PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  70. NOCOMPRESS LOGGING
  71. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  72. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  73. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  74. TABLESPACE "TS_BUSINESS";
  75. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. SERVICE-MEDIUM_TERM is '服务对象满意度指标-中期指标值';
  76. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. APPLICATION_OFFICE is '申请处室';
  77. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. APPLICATION_DATE is '申请日期';
  78. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. AUDIT_OPINIONS is '审核意见';
  79. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. FINDINGS_AUDIT is '审核结果';
  80. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. AUDITOR is '审核人';
  81. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. AUDIT_DATE is '审核日期';
  82. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. PROJECT_NAME is '项目名称';
  83. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. DEPARTMENTS_CODES is '本级部门及代码';
  84. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. IMPLEMENTATION_UNIT is '实施单位';
  85. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. PROJECT_ATTRIBUTES is '项目属性';
  86. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. PROJECT_PERIOD is '项目期';
  87. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. TOTAL_ANNUAL_FUNDS is '年度资金总额';
  88. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. FINANCIAL_ALLOCATION is '其中:财政拨款';
  89. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. OTHER_FUNDS is '其他资金';
  90. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. TOTAL_MEDIUM-TERM _FUNDS is '中期资金总额';
  91. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. MEDIUM-TERM_FINANCIAL_ALLOCATI is '中期资金总额-其中财政拨款';
  92. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. MEDIUM-TERM_OTHER_FUNDS is '中期资金总额-其他资金';
  93. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. PROJECT_CONTENT is '项目内容';
  94. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. BASIS_APPLICATION is '申请依据';
  95. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. CALCULATING_PROCESS is '测算过程';
  96. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. ANNUAL_TARGET is '年度目标';
  97. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. MEDIUM-TERM_OBJECTIVES is '中期目标';
  98. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. QUANTITY-INDICATOR_CONTENT is '数量指标-指标内容';
  99. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. QUANTITY-ANNUAL_INDICATOR is '数量指标-年度指标值';
  100. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. QUANTITY-MEDIUM_TERM is '数量指标-中期指标值';
  101. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. QUALITY_INDICATOR_CONTENT is '质量指标-指标内容';
  102. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. QUALITY-ANNUAL_INDICATOR is '质量指标-年度指标值';
  103. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. QUALITY-MEDIUM_TERM is '质量指标-中期指标值';
  104. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. PRESCRIPTION-INDICATOR_CONTENT is '时效指标-指标内容';
  105. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. PRESCRIPTION-ANNUAL_INDICATOR is '时效指标-年度指标值';
  106. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. PRESCRIPTION-MEDIUM_TERM is '时效指标-中期指标值';
  107. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. COST-INDICATOR_CONTENT is '成本指标-指标内容';
  108. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. COST-ANNUAL_INDICATOR is '成本指标-年度指标值';
  109. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. COST-MEDIUM_TERM is '成本指标-中期指标值';
  110. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. ECONOMICS-INDICATOR_CONTENT is '经济效益指标-指标内容';
  111. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. ECONOMICS-ANNUAL_INDICATOR is '经济效益指标-年度指标值';
  112. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. ECONOMICS-MEDIUM_TERM is '经济效益指标-中期指标值';
  113. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. SOCIOLOGY-INDICATOR_CONTENT is '社会效益指标-指标内容';
  114. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. SOCIOLOGY-ANNUAL_INDICATOR is '社会效益指标-年度指标值';
  115. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. SOCIOLOGY-MEDIUM_TERM is '社会效益指标-中期指标值';
  116. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. ENVIRONMENTAL-INDICATOR_CONTEN is '环境效益指标-指标内容';
  117. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. ENVIRONMENTAL-ANNUAL_INDICATOR is '环境效益指标-年度指标值';
  118. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. ENVIRONMENTAL-MEDIUM_TERM is '环境效益指标-中期指标值';
  119. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. SUSTAINABILI-INDICATOR_CONTENT is '可持续性指标-指标内容';
  120. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. SUSTAINABILIT-ANNUAL_INDICATOR is '可持续性指标-年度指标值';
  121. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. SUSTAINABILITY-MEDIUM_TERM is '可持续性指标-中期指标值';
  122. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. SERVICE-INDICATOR_CONTENT is '服务对象满意度指标-指标内容';
  123. COMMENT ON COLUMN BIZ_FINANCIAL_BUDGET_FILLING. SERVICE-ANNUAL_INDICATOR is '服务对象满意度指标-年度指标';
  124. /*
  125. ===================================粮食财务 预算填报表 end=========================================
  126. */
  127. /*
  128. ===================================粮食财务 绩效管理表 start=========================================
  129. */
  130. CREATE TABLE "BUSINESS"."BIZ_PERFORMANCE_MANAGEMENT"
  131. ( "ID" VARCHAR2(36) NOT NULL ENABLE,
  132. "CREATE_BY" VARCHAR2(36) DEFAULT -1,
  133. "CREATE_TIME" TIMESTAMP (6) DEFAULT null,
  134. "DELETE_BY" VARCHAR2(36) DEFAULT -1,
  135. "DELETE_TIME" TIMESTAMP (6),
  136. "UPDATE_BY" VARCHAR2(36) DEFAULT -1,
  137. "UPDATE_TIME" TIMESTAMP (6) DEFAULT null,
  138. "ORG_ID" VARCHAR2(50),
  139. "DEPT_ID" VARCHAR2(50),
  140. "AREA_CODE" VARCHAR2(50),
  141. "PROJECT_NAME" VARCHAR2(200),
  142. "PROJECT_CONTENT" VARCHAR2(200),
  143. "ANNUAL_TARGET" VARCHAR2(200),
  144. "PROJECT_COMPLETION_SCHEDULE" VARCHAR2(200),
  145. "EXPENDITURE_PROGRESS" VARCHAR2(200),
  146. "FILL_DATE" TIMESTAMP (6),
  147. "AUDIT_OPINIONS" VARCHAR2(200),
  148. "FINDINGS_AUDIT" VARCHAR2(50),
  149. "AUDITOR" VARCHAR2(50),
  150. "AUDIT_DATE" TIMESTAMP (6),
  151. "PROJECT_ID" VARCHAR2(36) NOT NULL ENABLE,
  152. PRIMARY KEY ("ID")
  153. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  154. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  155. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  156. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  157. TABLESPACE "TS_BUSINESS" ENABLE
  158. ) SEGMENT CREATION IMMEDIATE
  159. PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  160. NOCOMPRESS LOGGING
  161. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  162. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  163. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  164. TABLESPACE "TS_BUSINESS";
  165. CREATE UNIQUE INDEX "BUSINESS"."SYS_C0023979" ON "BUSINESS"."BIZ_PERFORMANCE_MANAGEMENT" ("ID")
  166. PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  167. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  168. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  169. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  170. TABLESPACE "TS_BUSINESS";
  171. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. PROJECT_NAME is '项目名称';
  172. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. PROJECT_CONTENT is '项目内容';
  173. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. ANNUAL_TARGET is '年度目标';
  174. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. PROJECT_COMPLETION_SCHEDULE is '项目完成进度';
  175. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. EXPENDITURE_PROGRESS is '支出进度';
  176. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. FILL_DATE is '填写日期';
  177. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. AUDIT_OPINIONS is '审核意见';
  178. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. FINDINGS_AUDIT is '审核结果';
  179. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. AUDITOR is '审核人';
  180. COMMENT ON COLUMN BIZ_PERFORMANCE_MANAGEMENT. AUDIT_DATE is '审核日期';
  181. /*
  182. ===================================粮食财务 绩效管理表 end=========================================
  183. */
  184. /*
  185. ===================================粮食财务 数据提报 start=========================================
  186. */
  187. CREATE TABLE "BUSINESS"."BIZ_FINANCIAL_PRESENTATION"
  188. ( "ID" VARCHAR2(36) NOT NULL ENABLE,
  189. "CREATE_BY" VARCHAR2(36) DEFAULT -1,
  190. "CREATE_TIME" TIMESTAMP (6) DEFAULT null,
  191. "DELETE_BY" VARCHAR2(36) DEFAULT -1,
  192. "DELETE_TIME" TIMESTAMP (6),
  193. "UPDATE_BY" VARCHAR2(36) DEFAULT -1,
  194. "UPDATE_TIME" TIMESTAMP (6) DEFAULT null,
  195. "ORG_ID" VARCHAR2(50),
  196. "DEPT_ID" VARCHAR2(50),
  197. "AREA_CODE" VARCHAR2(50),
  198. "REPORT_YEAR" VARCHAR2(50),
  199. "REPORT_MONTH" VARCHAR2(50),
  200. "REPORT_TITLE" VARCHAR2(50),
  201. "MONETARY_UNIT_YUAN" NUMBER(38,10),
  202. "ESTABLISHMENT_UNIT" VARCHAR2(36),
  203. "ESTABLISHMENT_TIME" TIMESTAMP (6) DEFAULT null,
  204. "ENTERPRISE_CATEGORY" VARCHAR2(36),
  205. "SALES_INCOME" NUMBER(38,10),
  206. "GRAIN_AND_OIL_SALES_INCOME" NUMBER(38,10),
  207. "SALES_COST" NUMBER(38,10),
  208. "GRAIN_AND_OIL_SALES_COST" NUMBER(38,10),
  209. "TOTAL_COST" NUMBER(38,10),
  210. "INTEREST" NUMBER(38,10),
  211. "WAGES_AND_SOCIAL_SECURITY" NUMBER(38,10),
  212. "DEPOSIT_CHARGES" NUMBER(38,10),
  213. "FREIGHT_MISCELLANEOUS_CHARGES" NUMBER(38,10),
  214. "DEPRECIATION_AND_AMORTIZATION" NUMBER(38,10),
  215. "TAXES_AND_SURCHARGES" NUMBER(38,10),
  216. "NET_OUT_OF_BUSINESS_INCOME" NUMBER(38,10),
  217. "GOVERNMENT_GRANTS" NUMBER(38,10),
  218. "GRAIN_OIL_SUBSIDIES_INCOME" NUMBER(38,10),
  219. "OTHER_SUBSIDIES" NUMBER(38,10),
  220. "NET_REVENUE_OF_OTHER_PROJECTS" NUMBER(38,10),
  221. "TOTAL_PROFIT" NUMBER(38,10),
  222. "INCOME_TAX_EXPENSES" NUMBER(38,10),
  223. "NET_PROFIT" NUMBER(38,10),
  224. "TOTAL_ASSETS" NUMBER(38,10),
  225. "CURRENT_ASSETS" NUMBER(38,10),
  226. "STOCK" NUMBER(38,10),
  227. "GRAIN_AND_OIL_INVENTORY" NUMBER(38,10),
  228. "MONETARY_FUNDS" NUMBER(38,10),
  229. "ACCOUNTS_RECEIVABLE_PREPAID" NUMBER(38,10),
  230. "OTHER_RECEIVABLES" NUMBER(38,10),
  231. "SUBSIDIES_RECEIVABLE" NUMBER(38,10),
  232. "TOTAL_LIABILITIES" NUMBER(38,10),
  233. "CURRENT_LIABILITIES" NUMBER(38,10),
  234. "SHORT_TERM_BORROWING" NUMBER(38,10),
  235. "GRAIN_AND_OIL_LOANS" NUMBER(38,10),
  236. "OTHER_ACCOUNTS_PAYABLE" NUMBER(38,10),
  237. "OWNER_RIGHTS_AND_INTERESTS" NUMBER(38,10),
  238. "PAID_IN_CAPITAL" NUMBER(38,10),
  239. "STATE_OWNED_CAPITAL" NUMBER(38,10),
  240. "PAYING_TAX" NUMBER(38,10),
  241. "EXPENSABLE_TAX_PAYABLE" NUMBER(38,10),
  242. "EXPENSABLE_TAXES_PAID" NUMBER(38,10),
  243. "SUPPLEMENTARY_INFORMATION" VARCHAR2(200),
  244. "AMOUNT_OF_PURCHASE_FUNDS" NUMBER(38,10),
  245. "AGRICULTURAL_DEV_BANK_LOAN" NUMBER(38,10),
  246. "POLICY_LOANS" NUMBER(38,10),
  247. "LOANS_UNDER_GUARANTEE_FUND" NUMBER(38,10),
  248. "LOANS_FROM_OTHER_INSTITUTIONS" NUMBER(38,10),
  249. "OTHER_BANKS_NAME" VARCHAR2(50),
  250. "OTHER_BANKS_LOANS" VARCHAR2(50),
  251. "RAISE_INDEPENDENTLY" NUMBER(38,10),
  252. "GROSS_INTEREST_RATE" NUMBER(38,10),
  253. "ASSET_LIABILITY_RATIO" NUMBER(38,10),
  254. "REPORTING_STATUS" VARCHAR2(36),
  255. "ACCOUNTS_PAYABLE_AND_PREPAID" NUMBER(36,10),
  256. PRIMARY KEY ("ID")
  257. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  258. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  259. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  260. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  261. TABLESPACE "TS_BUSINESS" ENABLE
  262. ) SEGMENT CREATION IMMEDIATE
  263. PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  264. NOCOMPRESS LOGGING
  265. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  266. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  267. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  268. TABLESPACE "TS_BUSINESS";
  269. CREATE UNIQUE INDEX "BUSINESS"."SYS_C0028918" ON "BUSINESS"."BIZ_FINANCIAL_PRESENTATION" ("ID")
  270. PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  271. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  272. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  273. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  274. TABLESPACE "TS_BUSINESS";
  275. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. MONETARY_UNIT_YUAN is '金钱单位元';
  276. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. ESTABLISHMENT_UNIT is '编制单位';
  277. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. ESTABLISHMENT_TIME is '编制时间';
  278. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. ENTERPRISE_CATEGORY is '企业类别';
  279. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. SALES_INCOME is '营业收入';
  280. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. GRAIN_AND_OIL_SALES_INCOME is '粮油营业收入';
  281. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. SALES_COST is '营业成本';
  282. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. GRAIN_AND_OIL_SALES_COST is '粮油营业成本';
  283. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. TOTAL_COST is '费用总额';
  284. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. INTEREST is '利息';
  285. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. WAGES_AND_SOCIAL_SECURITY is '工资和社保';
  286. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. DEPOSIT_CHARGES is '保管费';
  287. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. FREIGHT_MISCELLANEOUS_CHARGES is '运杂费';
  288. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. DEPRECIATION_AND_AMORTIZATION is '折旧费及摊销';
  289. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. TAXES_AND_SURCHARGES is '税金及附加';
  290. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. NET_OUT_OF_BUSINESS_INCOME is '营业外收支净额';
  291. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. GOVERNMENT_GRANTS is '政府补助';
  292. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. GRAIN_OIL_SUBSIDIES_INCOME is '粮油补贴收入';
  293. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. OTHER_SUBSIDIES is '其他补助';
  294. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. NET_REVENUE_OF_OTHER_PROJECTS is '其他项目收支净额';
  295. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. TOTAL_PROFIT is '利润总额';
  296. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. INCOME_TAX_EXPENSES is '所得税费用';
  297. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. NET_PROFIT is '净利润';
  298. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. TOTAL_ASSETS is '资产总额';
  299. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. CURRENT_ASSETS is '流动资产';
  300. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. STOCK is '存货';
  301. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. GRAIN_AND_OIL_INVENTORY is '粮油库存';
  302. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. MONETARY_FUNDS is '货币资金';
  303. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. ACCOUNTS_RECEIVABLE_PREPAID is '应收及预付帐款';
  304. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. OTHER_RECEIVABLES is '其他应收款';
  305. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. SUBSIDIES_RECEIVABLE is '应收补贴款';
  306. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. TOTAL_LIABILITIES is '负债总额';
  307. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. CURRENT_LIABILITIES is '流动负债';
  308. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. SHORT_TERM_BORROWING is '短期借款';
  309. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. GRAIN_AND_OIL_LOANS is '粮油借款';
  310. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. OTHER_ACCOUNTS_PAYABLE is '其他应付款';
  311. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. OWNER_RIGHTS_AND_INTERESTS is '所有者权益';
  312. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. PAID_IN_CAPITAL is '实收资本';
  313. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. STATE_OWNED_CAPITAL is '国有资本';
  314. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. PAYING_TAX is '已交税金';
  315. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. EXPENSABLE_TAX_PAYABLE is '应交费用性税金';
  316. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. EXPENSABLE_TAXES_PAID is '已交费用性税金';
  317. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. SUPPLEMENTARY_INFORMATION is '补充资料';
  318. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. AMOUNT_OF_PURCHASE_FUNDS is '本年收购资金累计筹集金额';
  319. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. AGRICULTURAL_DEV_BANK_LOAN is '农发行贷款';
  320. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. POLICY_LOANS is '政策性贷款';
  321. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. LOANS_UNDER_GUARANTEE_FUND is '备用保证基金项下贷款';
  322. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. LOANS_FROM_OTHER_INSTITUTIONS is '其他金融机构贷款';
  323. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. OTHER_BANKS_NAME is '其他银行';
  324. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. OTHER_BANKS_LOANS is '其他银行贷款金额';
  325. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. RAISE_INDEPENDENTLY is '自筹';
  326. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. GROSS_INTEREST_RATE is '毛利率';
  327. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. ASSET_LIABILITY_RATIO is '资产负债率';
  328. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. REPORTING_STATUS is '提报状态';
  329. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. REPORT_YEAR is '上报年份';
  330. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. REPORT_MONTH is '上报月份';
  331. COMMENT ON COLUMN BIZ_FINANCIAL_PRESENTATION. REPORT_TITLE is '提报标题';
  332. /*
  333. ===================================粮食财务 数据提报 end=========================================
  334. */
  335. /*
  336. ===================================粮食财务 项目表 start=========================================
  337. */
  338. CREATE TABLE "BUSINESS"."BUSINESS_PROJECT"
  339. ( "ID" VARCHAR2(36) NOT NULL ENABLE,
  340. "CREATE_BY" VARCHAR2(36) DEFAULT - 1,
  341. "CREATE_TIME" TIMESTAMP (6) DEFAULT NULL,
  342. "DELETE_BY" VARCHAR2(36) DEFAULT - 1,
  343. "DELETE_TIME" TIMESTAMP (6),
  344. "UPDATE_BY" VARCHAR2(36) DEFAULT - 1,
  345. "UPDATE_TIME" TIMESTAMP (6) DEFAULT NULL,
  346. "ORG_ID" VARCHAR2(50),
  347. "DEPT_ID" VARCHAR2(50),
  348. "AREA_CODE" VARCHAR2(50),
  349. "PROJECT_NAME" VARCHAR2(200 CHAR),
  350. "PROJECT_CONTENT" VARCHAR2(200),
  351. "YEAR" VARCHAR2(36),
  352. PRIMARY KEY ("ID")
  353. USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  354. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  355. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  356. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  357. TABLESPACE "TS_BUSINESS" ENABLE
  358. ) SEGMENT CREATION IMMEDIATE
  359. PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
  360. NOCOMPRESS LOGGING
  361. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  362. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  363. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  364. TABLESPACE "TS_BUSINESS";
  365. CREATE UNIQUE INDEX "BUSINESS"."SYS_C0023977" ON "BUSINESS"."BUSINESS_PROJECT" ("ID")
  366. PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  367. STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  368. PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  369. BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  370. TABLESPACE "TS_BUSINESS";
  371. COMMENT ON COLUMN BUSINESS_PROJECT. PROJECT_NAME is '项目名称';
  372. COMMENT ON COLUMN BUSINESS_PROJECT. PROJECT_CONTENT is '项目内容';
  373. COMMENT ON COLUMN BUSINESS_PROJECT. YEAR is '项目所在年份';
  374. /*
  375. ===================================粮食财务 项目表 end=========================================
  376. */