| 1234567891011121314151617 |
- 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='订单传输流水表';
|
