You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
53 lines
2.8 KiB
53 lines
2.8 KiB
|
|
CREATE TABLE `invoice_pf_nc_info` (
|
|
`id` int(11) NOT NULL AUTO_INCREMENT,
|
|
`billmaker` varchar(20) DEFAULT NULL COMMENT '提交人',
|
|
`corigcurrencyid` varchar(20) DEFAULT NULL COMMENT '币种',
|
|
`ntotalorigmny` varchar(20) DEFAULT NULL COMMENT '头入账金额',
|
|
`vbillcode` varchar(30) DEFAULT NULL COMMENT '发票号-nc号？',
|
|
`vmemo` varchar(255) DEFAULT NULL COMMENT '备注-是否需要处理？',
|
|
`vsourcecode` varchar(50) DEFAULT NULL COMMENT '收获单据号',
|
|
`vordercode` varchar(50) DEFAULT NULL COMMENT 'po号',
|
|
`vfirstrowno` varchar(10) DEFAULT NULL COMMENT 'Po行号',
|
|
`nastorigprice` varchar(20) DEFAULT NULL COMMENT '无税单价',
|
|
`nshouldnum` varchar(20) DEFAULT NULL COMMENT '供应商发货数量',
|
|
`nnum` varchar(20) DEFAULT NULL COMMENT '开票数量',
|
|
`norigmny` varchar(20) DEFAULT NULL COMMENT '无税金额',
|
|
`ntaxrate` varchar(20) DEFAULT NULL COMMENT '税率',
|
|
`pk_material_code` varchar(50) DEFAULT NULL COMMENT '物料编码',
|
|
`pk_material_name` varchar(255) DEFAULT NULL COMMENT '物料名称',
|
|
`pk_material_graphid` varchar(50) DEFAULT NULL COMMENT '物料图号',
|
|
`pk_material_materialspec` varchar(50) DEFAULT NULL COMMENT '物料规格',
|
|
`pk_material_materialtype` varchar(50) DEFAULT NULL COMMENT '物料型号',
|
|
`pk_supplier_name` varchar(255) DEFAULT NULL COMMENT '供应商名称',
|
|
`pk_supplier_code` varchar(20) DEFAULT NULL COMMENT '供应商编码',
|
|
`pk_supplier_taxpayerid` varchar(50) DEFAULT NULL COMMENT '供应商税号',
|
|
`ext01` varchar(255) DEFAULT NULL,
|
|
`ext02` varchar(255) DEFAULT NULL,
|
|
`ext03` varchar(255) DEFAULT NULL,
|
|
`ext04` varchar(255) DEFAULT NULL,
|
|
`ext05` varchar(255) DEFAULT NULL,
|
|
`ext06` varchar(255) DEFAULT NULL,
|
|
`ext07` varchar(255) DEFAULT NULL,
|
|
`ext08` varchar(255) DEFAULT NULL,
|
|
`ext09` varchar(255) DEFAULT NULL,
|
|
`ext10` varchar(255) DEFAULT NULL,
|
|
`create_date` datetime DEFAULT NULL,
|
|
`update_date` datetime DEFAULT NULL,
|
|
`flag` varchar(1) DEFAULT NULL,
|
|
`status` varchar(255) DEFAULT NULL,
|
|
PRIMARY KEY (`id`)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
|
|
|
|
|
|
ALTER TABLE `invoice_pf_nc_info`
|
|
CHANGE COLUMN `ext09` `invoiceNumber` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `ext08`;
|
|
|
|
ALTER TABLE `invoice_pf_nc_info`
|
|
CHANGE COLUMN `ext10` `vdef21` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
|
|
|
|
ALTER TABLE `invoice_pf_nc_info`
|
|
CHANGE COLUMN `ext07` `dbilldate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `ext06`,
|
|
CHANGE COLUMN `ext08` `pkorg` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `dbilldate`;
|
|
ALTER TABLE `invoice_pf_nc_info`
|
|
CHANGE COLUMN `ext06` `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL AFTER `ext05`;
|