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

CREATE TABLE ap_finance_bill_stock_rel (
  AFBSR_BILL_ID 					varchar(20) 	NOT NULL 		COMMENT '财务入库单主键ap_finance_bill.id',
  AFBSR_STOCK_ID 					varchar(20) 	NOT NULL		COMMENT 'ap_warehouse_stock.id',
  AFBSR_INVOICE_NUM 				varchar(10) 					COMMENT '发票份数',
  AFBSR_SPEC_ID 					varchar(20) 					COMMENT '规格id',
  AFBSR_WEIGHT 						varchar(20) 		 			COMMENT '数量',
  AFBSR_PRICE 						varchar(20) 		 			COMMENT '含税单价',
  AFBSR_EXCLUDING_TAX 				varchar(20) 		 			COMMENT '不含税金额',
  AFBSR_TAX 						varchar(20) 		 			COMMENT '税额',
  AFBSR_AMOUNT 						varchar(20) 		 			COMMENT '价税合计',
  PRIMARY KEY (AFBSR_BILL_ID,AFBSR_STOCK_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='财务出入库单关联表 ';