CREATE TABLE ap_transfer_flow (
  ATF_ID 						varchar(20) 	NOT NULL 						COMMENT '编号',
  ATF_ORDER_ID 					varchar(20) 	NOT NULL		 				COMMENT '订单编号',
  ATF_GUID 						varchar(50) 	NOT NULL	 					COMMENT 'GUID',
  ATF_ERP_DATE					varchar(8)		NOT NULL						COMMENT 'ERP过帐日期',
  ATF_TRANSFERRED_NUM			varchar(20)		NOT NULL						COMMENT '已传输数量',
  ATF_TRANSFER_NUM				varchar(20)		NOT NULL						COMMENT '本次传输数量',
  ATF_REMAINING_TRANS_NUM		varchar(20)		NOT NULL						COMMENT '剩余传输数量',
  ATF_PRE_PRICE					varchar(20)		NOT NULL						COMMENT '预结算单价',
  ATF_REAL_TOTAL				varchar(20)		NOT NULL						COMMENT '本次实际结算总价',
  ATF_PRE_TOTAL					varchar(20)		NOT NULL						COMMENT '本次预结算总价',
  ATF_ERP_NO					varchar(20)		NOT NULL						COMMENT 'ERP单号',
  ATF_CREATE_USER 				varchar(20)  									COMMENT '创建人',
  ATF_CREATE_TIME 				varchar(14)  									COMMENT '创建时间',
  PRIMARY KEY (ATF_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单传输流水表';

