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

CREATE TABLE ap_related_invoice (
  ARI_ID           		VARCHAR(20) NOT NULL 			COMMENT '出入库发票关联编号',
  ARI_AIT_ID        	VARCHAR(20)                    	COMMENT '发票汇总编号(AIT_ID)',
  ARI_AWD_ID        	VARCHAR(20)                    	COMMENT '出入库编号',
  ARI_AMOUNT			VARCHAR(20)						COMMENT '抵消不含税金额',
  ARI_WEIGHT			VARCHAR(20)						COMMENT '抵消重量',
  ARI_TOTAL_PRICE		VARCHAR(20)						COMMENT '抵消价税合计',
  ARI_TAX				VARCHAR(20)						COMMENT '抵消税额',
  ARI_CREATE_USER  		VARCHAR(20)   	   	 			COMMENT '创建人',
  ARI_CREATE_TIME  		VARCHAR(14)   	   	 			COMMENT '创建时间',
  ARI_MODIFY_USER   	VARCHAR(20)   	   	 			COMMENT '最后修改人',
  ARI_MODIFY_TIME   	VARCHAR(14)   	   	 			COMMENT '最后修改时间',
  ARI_STATE      		VARCHAR(2)   DEFAULT '00'      	COMMENT '状态:00正常01失效',
  ARI_PUSH_STATE      	VARCHAR(2)   DEFAULT '00'      	COMMENT '推送状态:00已推送01未推送',
  PRIMARY KEY (ARI_ID)
) ENGINE=INNODB DEFAULT CHARSET=UTF8 COMMENT='出入库关联发票表';