guomao/DOC/DB/00_table/ap_finance_bill.sql

CREATE TABLE ap_finance_bill (
  AFB_ID 						varchar(20) 	NOT NULL 		COMMENT '主键',
  AFB_NUMBER 					varchar(50) 	 				COMMENT '编号',
  AFB_DATE 						varchar(8) 		 				COMMENT '日期',
  AFB_CONTRACT_ID 				varchar(8) 		 				COMMENT '合同Id',
  AFB_PAY_AMOUNT 				varchar(20) 		 			COMMENT '已结金额',
  AFB_REMARK 					varchar(50) 		 			COMMENT '备注',
  AFB_EXCHANGE_RATE 			varchar(10) 		 			COMMENT '汇率',
  AFB_WEIGHT 					varchar(20) 		 			COMMENT '合计数量',
  AFB_EXCLUDING_TAX 			varchar(20) 		 			COMMENT '合计不含税金额',
  AFB_TAX 						varchar(20) 		 			COMMENT '合计税额',
  AFB_AMOUNT 					varchar(20) 		 			COMMENT '价税合计',
  AFB_BRANCH_ID 				varchar(20)  					COMMENT '所属部门',
  AFB_STATE 					varchar(2)  	DEFAULT '00'	COMMENT '状态00待审核01正常02拒绝03失效',
  AFB_CREATE_USER_ID 			varchar(20)  					COMMENT '创建人',
  PRIMARY KEY (AFB_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='财务出入库单';