銷售管理圖書銷售管理系統(tǒng)簡介

{銷售管理}圖書銷售管理項工作。在單機版的基礎上可以針對規(guī)模較大的圖書銷售商開發(fā)網(wǎng)模塊，而前臺則使用銷售管理模塊。容易被經(jīng)營者所接受。u根據(jù)顧客選取的書目完成收款業(yè)務。u提供上下班結(jié)款、提示上架、密碼修改等輔助功能。2.1.3查詢模塊◆書目查詢◆入庫查詢◆銷售記錄查詢◆庫存查詢例如：總經(jīng)理查詢子模塊可直接查詢各種業(yè)務數(shù)據(jù)，包括銷售情況、字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性書編號,no,Char,13,,N作者,author,Char,100,,Y出版社名稱,publishing,Char,50,,Y價格,price,Decimal,9,2,N簡介,introduction,Varchar,1024,,Y書類型,type,int,4,,N打折起始期,discount_sdate,Char,10,,N打折終止期,Discount_edate,char,10,,N打折度,Discount_rate,Decima,9,2,N會員是否有效,Card_Discount,int,4,,N庫編號,no,Char,4,,N庫地點,addr,Char,100,,Y負責人,pri_name,Char,100,,Y電話,Tele_no,Char,100,,Y字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性廠商編號,no,Char,13,,N地點,addr,Char,100,,Y電話,telenum,Char,20,,Y負責人,pri_name,Char,50,,Y員工編號,No,Char,4,,N性別,Sex,bit,1,,Y年齡,Age,int,4,,Y權(quán)限,privilege,int,4,,N卡編號,no,Char,4,,N卡類型,type,Char,4,,Y卡積分,integral,int,4,,Y字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性編號,no,Char,4,,N地點,addr,Char,100,,Y性別,sex,bit,1,,Y年齡,age,int,4,,Y職業(yè),vocation,Char,5,,Y行為：書編號,book_no,Char,13,,N上架書數(shù)量,bookshell_num,int,4,,Y書編號,book_no,Char,13,,N進貨日期,stock_date,char,10,,N員工編號,worker_no,Char,4,,Y數(shù)量,stock_number,int,4,,N是否結(jié)款,Ifreckoning,bit,1,,Y廠商負責人,pri_name,Char,100,,Y備注,remark,Varchar,1024,,Y字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性銷售編號,seq,Int(增量),4,,N書編號,book_no,Char,13,,N卡類型,Card_style,Char,4,,Y數(shù)量,Sell_num,int,4,,N出售日期,Sell_date,char,10,,N字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性書編號,Book_no,Char,13,,N退換日期,date,char,10,,N備注,remark,Varchar,1024,,Y書編號,Book_no,Char,13,,N預定數(shù)量,number,int,4,,Y預定時間,date,Char,10,,Y預定人號,credit_no,Char,8,,Y預定金,earnest,money,8,4,Y電話,tele_num,Char,100,,Y字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性書編號,Book_no,Char,13,,N結(jié)款日期,date,char,10,,N數(shù)量,number,int,4,,N字段信息,字段名稱,類型,寬度,小數(shù)位數(shù),空特性書編號,Book_no,Char,13,,N卡類型,Card_style,Char,4,,Y打折起始期,sdate,char,10,,N打折終止期,edate,char,10,,N書類型,type,in