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

CREATE TABLE ap_invoice_detail (
  AID_ID 				varchar(20) 	NOT NULL 		COMMENT '发票详情ID',
  AID_INVOICE_ID 		varchar(20) 		 			COMMENT '所属其他部门发票ID',
  AID_INVOICE_LV_ID 	varchar(20) 		 			COMMENT '所属铝产品部门发票ID',
  AID_NAME 				varchar(300) 		 			COMMENT '货物/服务名称',
  AID_SPECIFICATION 	varchar(10) 		 			COMMENT '规格',
  AID_WEIGHT 			varchar(20) 		 			COMMENT '重量',
  AID_UNIT 				varchar(10) 		 			COMMENT '单位',
  AID_PRICE 			varchar(20) 		 			COMMENT '单价',
  AID_AMOUNT 			varchar(20) 		 			COMMENT '不含税金额',
  AID_TAX_RATE 			varchar(20) 		 			COMMENT '税率',
  AID_TAX 				varchar(20) 		 			COMMENT '税额',
  AID_HAS_AMOUNT 		varchar(20) 		 			COMMENT '已抵消不含税额',
  AID_STATE 			varchar(2) 		DEFAULT '00'	COMMENT '状态：00正常01失效',
  AID_NUMBER 			varchar(50) 					COMMENT '所属发票编号',
  AID_TotalPriceAndTax	varchar(20) 					COMMENT '价税合计',
  PRIMARY KEY (AID_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='扫描发票详情表';