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

CREATE TABLE ap_order_logistics (
  AOL_ID 				varchar(20) 	NOT NULL 		COMMENT '物流编号',
  AOL_LOGISTICS_NO 		varchar(20) 		 			COMMENT '物流单号',
  AOL_ORDER_ID 			varchar(20) 		 			COMMENT '所属订单ID',
  AOL_CONSIGNEE 		varchar(20) 			 		COMMENT '收货人ID ap_company_inf.ACI_ID',
  AOL_TYPE 				varchar(2) 			 			COMMENT '类型：00铁路敞车01铁路罐车02公路03海运',
  AOL_SITE_ID 			varchar(20) 			 		COMMENT '地址ID ap_company_site.ACS_ID',
  AOL_CAR_NUMBER 		varchar(10) 			 		COMMENT '车号',
  AOL_STANDARD_ID 		varchar(20) 		 			COMMENT '商品规格ID',
  AOL_BRAND_ID 			varchar(20) 		 			COMMENT '品牌编号',
  AOL_TRACKING_NUMBER 	varchar(20) 		 			COMMENT '运单号',
  AOL_FREIGHT_INVOICE 	varchar(20) 		 			COMMENT '货票号',
  AOL_NUMBER 			varchar(10) 		 			COMMENT '件数',
  AOL_BALE 				varchar(10) 		 			COMMENT '捆数',
  AOL_START_PEOPLE 		varchar(100) 		 			COMMENT '发车人',
  AOL_DATE 				varchar(8) 		 				COMMENT '发货日期',
  AOL_ROUGH_WEIGHT 		varchar(20) 		 			COMMENT '毛重',
  AOL_TARE_WEIGHT 		varchar(20) 		 			COMMENT '皮重',
  AOL_WEIGHT 			varchar(20) 		 			COMMENT '重量',
  AOL_REAL_WEIGHT 		varchar(20) 		 			COMMENT '实到重量',
  AOL_CONTAINER_NUMBER 	varchar(10) 		 			COMMENT '集装箱号',
  AOL_DELIVER_ID 		varchar(20) 		 			COMMENT '关联发货计划id',
  AOL_CREATE_USER 		varchar(20)  					COMMENT '创建人',
  AOL_CREATE_TIME 		varchar(14)  					COMMENT '创建时间',
  AOL_MODIFY_USER 		varchar(20)  					COMMENT '最后修改人',
  AOL_MODIFY_TIME 		varchar(14)  					COMMENT '最后修改时间',
  AOL_STATE 			varchar(2) 		DEFAULT '00'	COMMENT '状态：00出库01已发货02运输中03已到货04失效05到港',
  AOL_CARD_NO 			varchar(20) 		 			COMMENT '卡号',
  PRIMARY KEY (AOL_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='订单物流表';