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

CREATE TABLE ap_contract_detail(
  APC_ID 				varchar(20) 	NOT NULL 		COMMENT '合同详情编号',
  APC_SPECS_ID 			varchar(20) 			 		COMMENT '产品规格编号',
  APC_CONTRACT_ID  		varchar(20)						comment '合同编号ap_contract_inf.ACI_ID',
  APC_BRAND_ID 			varchar(20) 			 		COMMENT '品牌ID',
  APC_PRICE				varchar(15)						COMMENT '价格',
  APC_WEIGHT			varchar(20)						COMMENT '重量',
  APC_CREATE_USER 		varchar(20)  					COMMENT '创建人',
  APC_CREATE_TIME 		varchar(14)  					COMMENT '创建时间',
  APC_MODIFY_USER 		varchar(20)  					COMMENT '最后修改人',
  APC_MODIFY_TIME 		varchar(14)  					COMMENT '最后修改时间',
  APC_STATE				varchar(2)						COMMENT'状态00正常01删除',
  APC_WARE_ID			varchar(20)						COMMENT'仓库编号',
  APC_DIFFERENCE		varchar(10)						COMMENT'平均价差额',
  APC_ORIGINAL_PRICE	varchar(20)						COMMENT'原币单价-新增',
  APC_ORIGINAL_AMOUNT	varchar(20)						COMMENT'原币金额',
  APC_LOCAL_PRICE		varchar(20)						COMMENT'本币单价',
  APC_LOCAL_AMOUNT		varchar(20)						COMMENT'本币金额',
  APC_UNIT_PRICE_COST	varchar(20)						COMMENT'单价成本',
  APC_EXPECTED_TARIFF	varchar(20)						COMMENT'预计关税',
  APC_VAT				varchar(20)						COMMENT'预计增值税',
  APC_PLACE_DELIVERY	varchar(20)						COMMENT'交货地点',
  APC_AMOUNT_EXCLUDING_TAX	varchar(20)					COMMENT'不含税金额',
  APC_REMARK			varchar(20)						COMMENT'备注',
  APC_HISTORY_PRICE		text							COMMENT '价格变动信息',
  PRIMARY KEY (APC_ID)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='合同详情表';