📄 table
字号:
GSREGCODE VARCHAR(50), /*工商号*/
TAXCODE VARCHAR(50),/*税号*/
MOSTLYOPERATION VARCHAR(50), /*主营业务*/
MAXTICKSUM DECIMAL(9, 2), /*最大赊销金额*/
PROVIDERTYPE VARCHAR(20), /*供应商类型*/
DEL CHAR(1), /*是否可删除*/
MEMO VARCHAR(200), /*备注*/
PRIMARY KEY(CODE)
);
/*退货单子表*/
CREATE TABLE REIMBURSEBILLBODY
(
BILLCODE CHAR(20) NOT NULL, /*单号*/
ID INTEGER NOT NULL, /*单据ID号*/
PARTCODE VARCHAR(50), /*商品编号*/
PARTNAME VARCHAR(100), /*商品名称*/
BORNCODE VARCHAR(50), /*原厂编号*/
CARMODEL VARCHAR(50), /*适用车型*/
PRODUCING VARCHAR(50), /*产地*/
UNITS VARCHAR(10), /*单位*/
DEPOTPLACE VARCHAR(20),/*仓位*/
QUANTITY DECIMAL(9, 2), /*数量*/
PRICE DECIMAL(9, 2), /*单价*/
CESS DECIMAL(9, 2), /*税率*/
AGIO DECIMAL(9, 2), /*折扣*/
TOTALSUM DECIMAL(9, 2), /*金额*/
REIMBURSEQRY DECIMAL(9, 2), /*退货数量*/
ORDERID INTEGER, /*原单据ID号*/
OUTPUTQRY DECIMAL(9, 2), /*出/入库数量*/
PRIMARY KEY (BILLCODE, ID)
);
/*退货单主表*/
CREATE TABLE REIMBURSEBILLHAND
(
BILLCODE VARCHAR(20) NOT NULL, /*单号*/
BILLDATE TIMESTAMP, /*日期*/
PROVIDERCODE VARCHAR(50), /*供应商/客户编号*/
PROVIDERNAME VARCHAR(100), /*供应商/客户名称*/
DEPOTCODE VARCHAR(20), /*仓库编号*/
DEPOTNAME VARCHAR(50), /*仓库名称*/
CAUSE VARCHAR(100), /* 退货原因*/
ORDERBILLNO VARCHAR(20), /*原单号*/
TOTALSUM DECIMAL(9, 2), /*总金额*/
BIGSUM VARCHAR(50), /*总金额大写*/
ACCEPTSUM DECIMAL(9, 2), /*收款金额*/
AGIOSUM DECIMAL(9, 2), /*折扣金额*/
ISACCEPT CHAR(1), /*是否已收款*/
ISAUDITING CHAR(1), /*是否已审核*/
AUDITINGMAN VARCHAR(50), /*审核人*/
AUDITINGDATE TIMESTAMP, /*审核日期*/
ISEXECUTE CHAR(1), /*是否已执行*/
EXECUTEMAN VARCHAR(50), /*执行人*/
EXECUTEDATE TIMESTAMP, /*执行日期*/
MEMO VARCHAR(100), /*备注*/
REIMBURSETYPE CHAR(1), /*退货类型*/
OPERATIONMAN VARCHAR(50), /*业务员*/
OPERATOR VARCHAR(50), /*操作员*/
PRIMARY KEY (BILLCODE)
);
/*库存商品*/
CREATE TABLE STOCKPART
(
PARTCODE VARCHAR(50) NOT NULL, /*商品编号*/
DEPOTCODE VARCHAR(20) NOT NULL, /*仓库编号*/
DEPOTNAME VARCHAR(50) , /*仓库名称*/
BILLQUANTITY DECIMAL(9, 2), /*开票数量*/
STOCKQUANTITY DECIMAL(9, 2), /*库存数量*/
PRIMARY KEY (PARTCODE, DEPOTCODE)
);
CREATE TABLE SYSINFO
(
CORPCODE CHAR(3), /*公司编号*/
CORPNAME VARCHAR(100), /*公司名称*/
ENGNAME VARCHAR(100), /*英文名称*/
ADDRESS VARCHAR(100), /*地址*/
POSTCODE CHAR(6), /*邮政编码*/
PHONECODE VARCHAR(24), /*电话*/
FAX VARCHAR(24), /*传真*/
EMAIL VARCHAR(50), /*电子邮件*/
URL VARCHAR(50), /*网址*/
BANKNAME VARCHAR(50), /*开户银行*/
BANKCODE VARCHAR(50), /*银行帐号*/
BANKUSERNAME VARCHAR(50), /*银行开户名称*/
TAXCODE VARCHAR(50), /*税号*/
REPMODE CHAR(1), /*维修方式*/
ISINSIDERSYS CHAR(1), /*是否使用会员制*/
COSTPRICEMODE CHAR(1), /*成本价核算类型*/
ISSTOCKNEG CHAR(1), /*是否可库存为负数*/
PARTCESS DECIMAL(9, 2),/*商品税率*/
WORKTIMECESS DECIMAL(9, 2),/*工时费税率*/
INSIDERSTR CHAR(3),/*会员号前缀*/
INSIDERSIZE CHAR(15),/*会员号位数*/
BALANCECURRENCY VARCHAR(20),/*结算币种*/
ISNEW CHAR(1), /*是否新帐套*/
MaxAGIOSUM DECIMAL(9, 2), /*收付款时最大让利金额*/
MEMO VARCHAR(200) /*备注*/
);
/*数据表索引*/
CREATE TABLE TABLEINDEX
(
INDEXNO INTEGER NOT NULL, /*索引号*/
TABLENAME VARCHAR(50), /*表名*/
FIELDNAME VARCHAR(50), /*字段名称*/
CNNAME VARCHAR(50), /*中文名称*/
PRIMARY KEY(INDEXNO)
);
/*用户权限*/
CREATE TABLE USERKEY
(
USERCODE VARCHAR(50),
USERNAME VARCHAR(50),
USERPASSWORD VARCHAR(50),
ISSYS CHAR(1),
USERKEY VARCHAR(50)
);
/*订货单索引*/
CREATE DESC INDEX ORDERBILLHANDKEY ON ORDERBILLHAND(BILLCODE);
/*进货单索引*/
CREATE DESC INDEX PARTSINPUTHANDKEY ON PARTSINPUTHAND(BILLCODE);
/*销售单索引*/
CREATE DESC INDEX PARTSOUTPUTHANDKEY ON PARTSOUTPUTHAND(BILLCODE);
/*收付款单索引*/
CREATE DESC INDEX PAYMENTHANDKEY ON PAYMENTHAND(BILLCODE);
/*退货单索引*/
CREATE DESC INDEX REIMBURSEBILLHANDKEY ON REIMBURSEBILLHAND(BILLCODE);
/*商品出库单索引*/
CREATE DESC INDEX OUTPUTSTOCKHANDKEY ON OUTPUTSTOCKHAND(BILLCODE);
/*仓库盘点单索引*/
CREATE DESC INDEX DEPOTCHECKHANDKEY ON DEPOTCHECKHAND(BILLCODE);
/*仓库盘点单子表索引*/
CREATE INDEX DEPOTCHECKBODYKEY ON DEPOTCHECKBODY(BILLCODE, ID);
/*商品移仓单索引*/
CREATE DESC INDEX DEPOTPARTSMOVEHANDKEY ON DEPOTPARTSMOVEHAND(BILLCODE);
/*商品信息索引*/
CREATE DESC INDEX PARTINFOKEY ON PARTINFO(CODE);
/*客户资料索引*/
CREATE DESC INDEX CLIENTINFOKEY ON CLIENTINFO(CODE);
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (1, 'Partinfo', 'CODE', '商品编号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (2, 'Partinfo', 'Preferential', '优惠价');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (3, 'Partinfo', 'BornCode', '原厂编号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (4, 'Partinfo', 'Name', '名称规格');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (5, 'Partinfo', 'Producing', '产地');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (7, 'Partinfo', 'Units', '计量单位');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (8, 'Partinfo', 'Maxstock', '最高库存');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (9, 'Partinfo', 'MinStock', '最小库存');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (10, 'Partinfo', 'InPutPrice', '入库价');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (11, 'Partinfo', 'OutPutPrice', '出库价');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (12, 'Partinfo', 'Traderpice', '批发价');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (13, 'Partinfo', 'Foreignprice', '外币价');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (14, 'Partinfo', 'Foreigntype', '结算币种');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (15, 'Partinfo', 'DepotPlace', '仓位');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (16, 'Partinfo', 'Helpnoteno', '助记码');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (17, 'Partinfo', 'Memo', '备注');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (18, 'Sysinfo', 'DepotCode', '部门编号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (19, 'Sysinfo', 'CorpName', '公司名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (20, 'Sysinfo', 'EngName', '英文名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (21, 'Sysinfo', 'AddRess', '公司地址');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (22, 'Sysinfo', 'PostCode', '邮政编码');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (23, 'Sysinfo', 'PhoneCode', '联系电话');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (24, 'Sysinfo', 'Fax', '传真');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (25, 'Sysinfo', 'EMail', '电子邮箱');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (26, 'Sysinfo', 'Url', '公司网址');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (27, 'Sysinfo', 'BankName', '开户银行');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (28, 'Sysinfo', 'BankCode', '银行帐号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (29, 'Sysinfo', 'BankUserName', '银行开户名');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (30, 'Sysinfo', 'TaxCode', '税号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (31, 'Sysinfo', 'Memo', '备注');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (32, 'Depot', 'DepotCode', '仓库编号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (33, 'Depot', 'DepotName', '仓库名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (34, 'Depot', 'Address', '地址');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (35, 'Depot', 'Phone', '联系电话');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (36, 'Depot', 'LinkMan', '联系人');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (37, 'Depot', 'Memo', '备注');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (38, 'Department', 'DeptCode', '部门编号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (39, 'Department', 'DeptName', '部门名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (40, 'Department', 'Address', '地址');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (41, 'Department', 'Phone', '联系电话');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (42, 'Department', 'LinkMan', '联系人');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (43, 'Department', 'Memo', '备注');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (44, 'Employee', 'CODE', '员工编号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (45, 'Employee', 'NAME', '员工姓名');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (46, 'Employee', 'IDcard', '身份证号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (47, 'Employee', 'Nativeplace', '籍贯');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (48, 'Employee', 'Literacy', '学历');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (49, 'Employee', 'DEPT', '所在部门');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (50, 'Employee', 'BASICLABORAGE', '基本工资');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (51, 'Employee', 'Sex', '性别');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (52, 'Employee', 'Job', '职务');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (53, 'Employee', 'Birthday', '出生日期');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (54, 'Employee', 'BJOBLABORAGE', '计件提成');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (55, 'Employee', 'Dwelling', '住址');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (56, 'Employee', 'LinkPhone', '电话');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (57, 'Employee', 'Handset', '手机');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (58, 'Employee', 'MEMO', '备注');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (59, 'Clientinfo', 'CODE', '客户编号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (60, 'Clientinfo', 'CLIENTNAME', '客户名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (61, 'Clientinfo', 'ENGNAME', '英文名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (62, 'Clientinfo', 'LINKMAN', '联系人');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (63, 'Clientinfo', 'LINKPHONE', '联系电话');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (64, 'Clientinfo', 'FAX', '传真');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (65, 'Clientinfo', 'HANDSET', '手机');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (66, 'Clientinfo', 'ADDRESS', '联系地址');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (67, 'Clientinfo', 'POSTCODE', '邮政编码');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (68, 'Clientinfo', 'EMAIL', '电子邮箱');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (69, 'Clientinfo', 'URL', '网址');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (70, 'Clientinfo', 'BANK', '开户银行');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (71, 'Clientinfo', 'BANKCODE', '银行帐号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (72, 'Clientinfo', 'BANKACCOUNTNAME', '银行开户名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (73, 'Clientinfo', 'GSREGCODE', '工商号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (74, 'Clientinfo', 'TAXCODE', '税号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (75, 'Clientinfo', 'CLIENTTYPE', '客户类别');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (76, 'Clientinfo', 'MOSTLYOPERATION', '主营业务');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (78, 'Providerinfo', 'CODE', '供应商编号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (79, 'Providerinfo', 'PROVIDERNAME', '供应商名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (80, 'Providerinfo', 'ENGNAME', '英文名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (81, 'Providerinfo', 'LINKMAN', '联系人');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (82, 'Providerinfo', 'LINKPHONE', '联系电话');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (83, 'Providerinfo', 'FAX', '传真');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (84, 'Providerinfo', 'HANDSET', '手机');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (85, 'Providerinfo', 'ADDRESS', '联系地址');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (86, 'Providerinfo', 'POSTCODE', '邮政编码');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (87, 'Providerinfo', 'EMAIL', '电子邮箱');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (88, 'Providerinfo', 'URL', '网址');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (89, 'Providerinfo', 'BANK', '开户银行');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (90, 'Providerinfo', 'BANKCODE', '银行帐号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (91, 'Providerinfo', 'BANKACCOUNTNAME', '银行开户名称');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (92, 'Providerinfo', 'GSREGCODE', '工商号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (93, 'Providerinfo', 'TAXCODE', '税号');
INSERT INTO TABLEINDEX (INDEXNO, TABLENAME, FIELDNAME, CNNAME) VALUES (94, 'Providerinfo', 'MOSTLYOPERATION', '主营业务');
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -