速達(dá)SQL數(shù)據(jù)庫(kù)表結(jié)構(gòu)

1、PHONE電話 VARCHAR(20)速達(dá) 3000 及 3000Pro數(shù)據(jù)庫(kù)結(jié)構(gòu)分析表名：描述：記錄帳套的詳細(xì)資料字段名中文描述字段類(lèi)型/字段長(zhǎng)度CORPID公司 IDSMALLINTNOTTAXTYPE稅務(wù)類(lèi)型VARCHAR(l)STARTDATE啟用日期DATECURRYEAR當(dāng)前年份SMAL LINTCURRMON當(dāng)前月份SMAL LINTMUSTCHECK登帳是否審核VARCHAR(1)SAMEUSER審核是杏口J冋人VARCHAR(1)LAWPERSON法人代表VARCHAR(20)BANK開(kāi)戶行VARCHAR(20)ACCOUNTS帳號(hào)VARCHAR(20)TAXNUMBER稅號(hào)

2、VARCHAR(20)BIND進(jìn)銷(xiāo)存財(cái)務(wù)捆綁VARCHAR(1)STEPO一級(jí)科目長(zhǎng)度SMALLINTSTEP1二級(jí)科目長(zhǎng)度SMALLINTSTEP2三級(jí)科目長(zhǎng)度SMALLINTSTEP3四級(jí)科目長(zhǎng)度SMALLINTSTEP4五級(jí)科目長(zhǎng)度SMALLINTSTEP5六級(jí)科目長(zhǎng)度SMALLINT帳套信息表SMALLINT是否為空說(shuō)明Primary;UBACKUPOPTION表名：ABNORMALSALE 描述:字段名中文描述字段類(lèi)型/長(zhǎng)度是否為空說(shuō)明ID順序號(hào)INTEGERNOTPrimary; Un1 1 1 BILLID單據(jù)IDSMAL LINTNOTBILLTIME開(kāi)單日期DATEGOODS

3、ID貨品IDVARCHAR(20)AMOUNT數(shù)量DOUBLE PRECISIONPRICE單價(jià)DOUBLE PRECISIONRETURNTAG退貨標(biāo)志SMAL LINTLASTDATEDATESTATUS啟用狀態(tài)SMAL LINTVERSION帳套版本號(hào)VARCHAR(4)MAXLOGRECOUNTSMALLINTMAXLOGDAYSMALLINTADDRESS地址VARCHAR(IOO)POSYEARPOSMONPOSSTOREIDGUID逬銷(xiāo)存年份進(jìn) 銷(xiāo)存月份SMALLINT,站著祚一矩耳SMALLINTSMALLINTVARCHAR(40)帳套選項(xiàng)表表名：ACCOPTIONS字段名中

4、文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明OPTIONID順序號(hào)SMALLINTNOT NULL,OPTIONNAME名稱VARCHAR(20)NOT NULL,OPTIONVALUE 值VARCHAR(20),MEMO備注VARCHAR(40)調(diào)價(jià)單表名:ADJAP描述:記錄調(diào)價(jià)的詳細(xì)資料字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明ADJAPID順序號(hào)INTEGERNOTPrimary;Ur 11 1CODE單據(jù)編號(hào)VARCHAR(25)NOTBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10)TO

5、TALAMT總金額DOUBLE PRECISIONMEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式ID INTEGERSHOPID分支機(jī)構(gòu)ID SMALLINTSFLAG傳輸標(biāo)志SMALLINT表名:ALLOT字段名描述:記錄貨品調(diào)撥的詳細(xì)資斜中文描述字段類(lèi)型/字段長(zhǎng)度是否為空ALLOTID順序號(hào)INTEGERNOTCODE單據(jù)號(hào)VARCHAR(25)NOTBILLDATE單據(jù)日期DATEFLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10)OUTSID調(diào)出倉(cāng)庫(kù)號(hào)INTEGERNOTINS

6、ID調(diào)進(jìn)倉(cāng)庫(kù)號(hào)INTEGERNOTTOTALAMT總金額DOUBLE PRECISIONMEMO備注VARCHAR(40)調(diào)撥單說(shuō)明Primary;UUn ique;UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT地區(qū)資料表名：AREA描述:記錄地區(qū)的詳細(xì)資料字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明AREAID地區(qū)IDINTEGERNOTPrimary;U nique;LCODE地區(qū)編號(hào)VARCHAR(10)NOTNAME地區(qū)名稱VARCHAR(12)NOTUPFLAG發(fā)送標(biāo)志ARCHAR(1

7、)固定資產(chǎn)卡片表名：ASSETCARD描述:企業(yè)固定佈產(chǎn)詳細(xì)佈料字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明ID順序號(hào)INTEGERNOTPrimary; UnI d i iCODE編號(hào)VARCHAR(10)NOTNAME名稱VARCHAR(40)SPECTYPE規(guī)格型號(hào)VARCHAR(20)ASSETTYPEID類(lèi)別IDINTEGERDEPTID所屬部門(mén)IDINTEGERINCRDECRID固定資產(chǎn)增加減少I(mǎi)NTEGERLOCATION地址VARCHAR(60)USEDTYPEID使用方式INTEGERDEPRECIATEID折舊 IDINTEGERSTARTDATE入帳日期DATEWORK

8、LOAD預(yù)計(jì)使用月份INTEGERUSEDAGOINTEGERUSEDALL已計(jì)使用月份INTEGERUNIT工作量單位VARCHAR(10)RAWVALUE入帳原值DOUBLE PRECISIONUSEDVALUE累計(jì)折舊DOUBLE PRECISIONUSEDVALUEAGODOUBLE PRECISIONREMAINRATE預(yù)計(jì)凈殘值率DOUBLE PRECISIONREMAINVALUE預(yù)計(jì)凈殘值DOUBLE PRECISIONDEPRRATE月折舊率DOUBLE PRECISIONDEPRVALUE月折舊額DOUBLE PRECISIONSUBID折舊科目VARCHAR(18)CLE

9、ARFLAG清除標(biāo)志VARCHAR(1)INITFLAG初始化標(biāo)志VARCHAR(1)CREDID憑證IDVARCHAR(10)固定資產(chǎn)類(lèi)別表名：ASSETTYPE 描述:固定資產(chǎn)類(lèi)別的明細(xì)資料字段名中文描述ID順序號(hào)NAME類(lèi)別名稱DEPRECIATED JffH IDREMAINRATE預(yù)i+凈珪值率字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明INTEGER NOTVARCHAR(20) NOTSMALLINT,Primary;Un ique;DOUBLE PRECISION固定資產(chǎn)清除表名：ASTCLEAR字段描述：記錄被清除固定資產(chǎn)的詳細(xì)資料名中文描述ID順序號(hào)CLEARDATE清除日期INCRDE

10、CRID 增減 IDEARING DOUBLE# 理收 入PAYOUT 清理費(fèi)用MEMO標(biāo)志說(shuō)明Primary;字段類(lèi)型/字段長(zhǎng)度是否為空INTEGERNOTDATE,INTEGER,PRECISION,DOUBLE PRECISION,VARCHAR(40)附屬設(shè)備表表名:ATTACHAST字是否為空字段類(lèi)型/字段長(zhǎng)度說(shuō)明段名中文描述INTEGERNOTPrimary;ID順序號(hào)INTEGERNOTPrimary;固定資產(chǎn)及累計(jì)折舊余額表表名：ASTBALANCE描述:字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明YEARMON地區(qū)IDVARCHAR(6)NOTPrimary ；ID順序號(hào)IN

11、TEGERNOTPrimary ；TOTALWL總工作量INTEGERCURRWL本月工作量INTEGERUSEDVALUE累計(jì)折舊DOUBLE PRECISIONDEPRRATE月折舊率DOUBLE PRECISIONDEPRVALUE月折舊額DOUBLE PRECISIONBASTDEBIT（余額方向?yàn)榻璺剑?期初余額Z-T- /卄丿 jDOUBLE PRECISIONYASTDEBIT（余額方向?yàn)榻璺剑﹟本牛借力示額DOUBLE PRECISIONYASTCREDITa rx r r i t-（余額方向?yàn)榻璺剑?本年貸方余額DOUBLE PRECISIONASTDEBIT（余額方向?yàn)榻璺?/p>

12、）1本期借力示額DOUBLE PRECISIONASTCREDIT（余額方向?yàn)榻璺剑﹟本期貸方余額DOUBLE PRECISIONBDPRCREDIT（余額方向?yàn)橘J方）1期初余額DOUBLE PRECISIONYDPRDEBIT（余額方向?yàn)橘J方）1本年借方DOUBLE PRECISIONYDPRCREDIT（余額方向?yàn)橘J方）1本年貸方DOUBLE PRECISIONDPRDEBIT（余額方向?yàn)橘J方）1本期借方DOUBLE PRECISIONDPRCREDIT（余額方向?yàn)橘J方）1本期貸方DOUBLE PRECISIONNAME名稱VARCHAR(20),SPECTYPE規(guī)格VARCHAR(20)

13、,UNIT計(jì)量單位VARCHAR(10),AMOUNT數(shù)量DOUBLE PRECISIONATTACHSUM金額DOUBLE PRECISIONSTARTDATE使用日期DATE,MEMO備注VARCHAR(40)退貨明細(xì)表（從表）表名：BACKDETAIL描述:記錄所退貨品的詳細(xì)資料字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明BACKDRAWIDITEMNO主表ID明細(xì)號(hào)INTEGERNOTSMALLINTNOTPrimary;GOODSID貨品IDVARCHAR(20),QUANTITY數(shù)量DOUBLE PRECISION,APRICE單價(jià)DOUBLE PRECISION退貨單（主表）表名

14、：BACKDRAW字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明BACKDRAWID單據(jù)IDINTEGERNOTPrimaryCODEBILLDATE單據(jù)號(hào) 單據(jù)日期VARCHAR(25)NOTDATE,Un ique;FLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10),BACKMANID退貨員INTEGER,INSID退入倉(cāng)庫(kù)號(hào)INTEGER,TOTALAMT總金額DOUBLE PRECISION,MEMO備注VARCHAR(40),UPDATETIME修改日期DATE,RPTID打印樣式IDINTEGERSHOPID分支機(jī)

15、構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT表名：描述：字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明YEARMON年月份VARCHAR(6)NOTPrimary;MONEYID貨幣IDSMALLINTNOT NULL,Primary;SUBID會(huì)計(jì)科目VARCHAR(18)NOT NULL,RATE匯率DOUBLE PRECISION,YBRAWDEBIT年初借方原幣金額DOUBLE PRECISION,YBRAWCREDIT年初貸方原幣金額DOUBLE PRECISION,BRAWDEBIT期初借方原幣金額DOUBLE PRECISION,BRAWCREDIT期初貸方原幣金額DO

16、UBLE PRECISION,RAWDEBIT本期累計(jì)借方原幣金額DOUBLE PRECISION,RAWCREDIT本期累計(jì)貸方原幣金額DOUBLE PRECISION,ERAWDEBIT期末借方原幣金額DOUBLE PRECISION,ERAWCREDIT期末貸方原幣金額DOUBLE PRECISION,YRAWDEBIT本年借方原幣金額DOUBLE PRECISION,YRAWCREDIT本年貸方原幣金額DOUBLE PRECISION,YBDEBIT本年借方本位幣金額DOUBLE PRECISION,YBCREDIT本年貸方本位幣金額DOUBLE PRECISION,BDEBIT期初借

17、方本位幣金額DOUBLE PRECISION,BCREDIT期初貸方本位幣金額DOUBLE PRECISION,DEBIT本期累計(jì)借方本位幣金額DOUBLE PRECISION,CREDIT本期累計(jì)貸方本位幣金額DOUBLE PRECISION,EDEBIT期末借方本位幣金額DOUBLE PRECISION,ECREDIT期末貸方本位幣金額DOUBLE PRECISION,YDEBIT本年借方本位幣金額DOUBLE PRECISION,YCREDIT本年貸方本位幣金額DOUBLE PRECISION倉(cāng)庫(kù)盤(pán)點(diǎn)單（明細(xì)）表名：BALDETAIL字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明BALIT

18、EMID盤(pán)點(diǎn)單IDINTEGERNOTPrimary;ITEMNO明細(xì)號(hào)SMALLINTNOTPrimary;GOODSID貨品IDVARCHAR(20),QUANTITY數(shù)量DOUBLE PRECISION,APRICE單價(jià)DOUBLE PRECISION倉(cāng)庫(kù)盤(pán)點(diǎn)單表名：BALITEM字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明BALITEMID盤(pán)點(diǎn)單IDINTEGERNOTPrimary;CODE單據(jù)編號(hào)VARCHAR(25)NOTUn iqueBILLDATE單據(jù)日期DATE,FLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGERBALSID倉(cāng)庫(kù)IDINTEGERO

19、PERATOR操作員VARCHAR(10),TOTALAMT總金額DOUBLE PRECISION,MEMO備注VARCHAR(40),UPDATETIME修改日期DATE,RPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT現(xiàn)金銀行表名：BANK字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明BANKID銀行編號(hào)SMALLINTNOTPrimaryNAME名稱VARCHAR(20)NOTUn ique;SUBID會(huì)計(jì)科目編號(hào)VARCHAR(18),BANKNAME銀行全稱VARCHAR(40),BANKCODE銀行帳戶VARCHAR(20

20、),BALANCE開(kāi)帳金額DOUBLE PRECISION,BALINIT存款余額DOUBLE PRECISION,FLAG存款類(lèi)別VARCHAR(1),UPFLAG發(fā)送標(biāo)志VARCHAR(1)基本資料查詢(主表表名：BCFIND字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明TABLEID表IDSMALLINTNOTPrimary;TABLECNAME表中文名VARCHAR(50),TABLENAME表英文名VARCHAR(20)NOT基本資料査詢(從表)表名：BCFINDDETAILLOOKUPKEYFIELDVARCHAR(20)字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明TABLEID表I

21、DSMALLINTNOTPrimary;FIELDID字段名IDSMAL LINTNOTPrimaryFIELDENAME字段英文名VARCHAR(20)NOTFIELDCNAME字段中文名VARCHAR(40),FIELDTYPE字段類(lèi)型SMALLINTNOTDEFAULT 0ISLOOKUP是否 LookUp VARCHAR(1)DEFAULT T,LOOKUPTBLNAMELookUp 表VARCHAR(20),LOOKUPRESULTFIELDVARCHAR(20),表名：BILLFLOWQUEUE(不用)字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明ID順序號(hào)INTEGERNOTPri

22、maryBILLDATE單據(jù)日期DATENOTBILLTYPE單據(jù)類(lèi)型SMALLINTNOTBILLID單據(jù)IDINTEGERNOTBILLCODE單據(jù)編號(hào)VARCHAR(25)NOTITEMNO明細(xì)號(hào)INTEGERNOTGOODSID貨品IDVARCHAR(20)NOTQUEUEINDEX INTEGER NOT NULL,INQTY DOUBLE PRECISION,INPRICE DOUBLE PRECISION,OUTQTY DOUBLE PRECISION,OUTPRICE DOUBLE PRECISION,EQTY DOUBLE PRECISION,EPRICE DOUBLE PR

23、ECISION,STOREID INTEGER,CACULATEFLAG VARCHAR(l) NOT NULL,INOUTFLAG INTEGER,VALIDQUEUE VARCHAR(l)表名：BILLFLOWQUEUE_TMP(不用)字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明ID順序號(hào) INTEGERNOTPrimary;BILLDATE DATE NOT NULL,BILLTYPE SMALLINT NOT NULL,BIL LID INTEGER NOT NULL,BILLCODE VARCHAR(25) NOT NULL,ITEMNO INTEGER NOT NULL,GOODS

24、ID VARCHAR(20) NOT NULL,QUEUEINDEX INTEGER NOT NULL,INQTY DOUBLE PRECISION,INPRICE DOUBLE PRECISION,OUTQTY DOUBLE PRECISION,OUTPRICE DOUBLE PRECISION,EQTY DOUBLE PRECISION,EPRICE DOUBLE PRECISION,STOREID INTEGER,CACULATEFLAG VARCHAR(1) NOT NULL,INOUTFLAG INTEGER單據(jù)打印表名：BILLPRINT描述:單據(jù)打印設(shè)置表字段名中文描述字段類(lèi)型/

25、字段長(zhǎng)度是否為空說(shuō)明BILLID單據(jù)類(lèi)型SMALLINTNOTPrimary; Uniq ue;NAME單據(jù)名稱VARCHAR(10)OLDNAME原單據(jù)名稱VARCHAR(10)MASTNAME單據(jù)正標(biāo)題VARCHAR(40)OLDMASTNAME原單據(jù)正標(biāo)題VARCHAR(40)ROWHIGHT行咼SMALLINTDETAILNAME單據(jù)副標(biāo)題VARCHAR(40)OLDDETAILNAME原單據(jù)副標(biāo)題VARCHAR(40)MASTFONTNAME單據(jù)正標(biāo)題字體名稱VARCHAR (20)OLDMASTFONTNAME原單據(jù)正標(biāo)題字體名稱VARCHAR(20)MASTFONTSTYLE單據(jù)

26、正標(biāo)題字體字形VARCHAR(1)OLDMASTFONTSTYLE原單據(jù)正標(biāo)題字體字形VARCHAR (1)MASTFONTSIZE單據(jù)正標(biāo)題字體大小SMALLINTOLDMASTFONTSIZE原單據(jù)正標(biāo)題字體大小SMALLINTMASTFONTCOLOR單據(jù)正標(biāo)題顏色FLOATOLDMASTFONTCOLOR原單據(jù)帀標(biāo)題顏色FLOATDETAILFONTNAME單據(jù)副標(biāo)題字體名稱VARCHAR(20)OLDDETAILFONTNAME原單據(jù)副標(biāo)題字體名稱VARCHAR(20)DETAILFONTSTYLE單據(jù)副標(biāo)題字體字形VARCHAR(1)OLDDETAILFONTSTYLE原單據(jù)副標(biāo)題

27、字體字形VARCHAR(1)DETAILFONTSIZE單據(jù)副標(biāo)題字體大小SMALLINTOLDDETAILFONTSIZE原單據(jù)副標(biāo)題字體大小SMALLINTDETAILFONTCOLOR單據(jù)副標(biāo)題顏色FLOATOLDDETAILFONTCOLOR原單據(jù)副標(biāo)題顏色FLOATBILLFONTNAME單據(jù)內(nèi)容字體名稱VARCHAR(20)OLDBILLFONTNAME原單據(jù)內(nèi)容字體名稱VARCHAR(20)BILLFONTSTYLE單據(jù)內(nèi)容字體字形VARCHAR(1)OLDBILLFONTSTYLE原單據(jù)內(nèi)容字體字形VARCHAR(1)BILLFONTSIZE單據(jù)內(nèi)容字體大小SMALLINTOL

28、DBILLFONTSIZE原單據(jù)內(nèi)容字體大小SMALLINTBILLFONTCOLOR單據(jù)內(nèi)容字體顏色FLOATOLDBILLFONTCOLOR原單據(jù)內(nèi)容字體顏色FLOATHEADFONTNAME其他單據(jù)頭字體名稱VARCHAR(20)OLDHEADFONTNAME原其他單據(jù)頭字體名稱VARCHAR(20)HEADFONTSTYLE其他單據(jù)頭字體字形VARCHAR(1)OLDHEADFONTSTYLE原其他單據(jù)頭字體字形VARCHAR(1)HEADFONTSIZE其他單據(jù)頭字體大小SMALLINTOLDHEADFONTSIZE原其他單據(jù)頭字體大小SMALLINTHEADFONTCOLOR其他單

29、據(jù)頭顏色FLOATOLDHEADFONTCOLOR原其他單據(jù)頭顏色FLOATFOOTFONTNAME單據(jù)底部字體名稱VARCHAR(20)OLDFOOTFONTNAME原單據(jù)底部字體名稱VARCHAR(20)FOOTFONTSTYLE單據(jù)底部字體字形VARCHAR(1)OLDFOOTFONTSTYLE原單據(jù)底部字體字形VARCHAR(1)FOOTFONTSIZE單據(jù)底部字體大小SMALLINTOLDFOOTFONTSIZE原單據(jù)底部字體大小SMALLINTFOOTFONTCOLOR單據(jù)底部顏色FLOATOLDFOOTFONTCOLOR原單據(jù)底部顏色FLOATOPNAME單據(jù)標(biāo)題1VARCHAR

30、(10)OLDOPNAME原單據(jù)標(biāo)題1VARCHAR(10)REPNAME單據(jù)標(biāo)題2VARCHAR(10)原單據(jù)標(biāo)題2OLDREPNAMEVARCHAR(10)是否由系統(tǒng)按比例縮放VARCHAR(I)是否需要行線VARCHAR(1)是否需要列線VARCHAR(1)0THERNAME1 0LD0THERNAME1 0THERNAME20LD0THERNAME2PRINTEMPTYISAUTOISROWLINEISCOLLINE單據(jù)標(biāo)題3原單據(jù)標(biāo)題3單據(jù)標(biāo)題4原單據(jù)標(biāo)題4行數(shù)不夠是否補(bǔ)行VARCHAR(IO)VARCHAR(IO)VARCHAR(10)VARCHAR(10)VARCHAR(1)單據(jù)

31、類(lèi)型表名：BILLTYPE字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明BILLTYPEID單據(jù)類(lèi)型IDSMALLINTNOTPrimaryNAME單據(jù)類(lèi)型名稱VARCHAR(20)NOTUniqueA布爾表(用于查詢)表名：BOOLTABLE字段名IDNAME中文描述順序號(hào)名稱字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明PrimaryVARCHAR(l)VARCHAR(10)NOT憑證摘要表名：BRIEF字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明BRIEFTYPEID摘要類(lèi)型IDINTEGERNOTPrimary;BRIEFID摘要IDINTEGERNOTPrimary;BRIEFNAME摘要名稱VARC

32、HAR(32)NOTUn ique;HELPCODE幫助編碼VARCHAR(10)憑證摘要類(lèi)型表名:BRIEFTYPE字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明BRIEFTYPEID摘要類(lèi)型IDINTEGERNOTPrimaryTYPENAME摘要名稱VARCHAR(32)NOTUn ique;現(xiàn)金流量金額分配表表名:CASHITEM字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明CREDID CASHID憑證ID代碼VARCHAR(10)VARCHAR(12)NOT NULL,PrimaryNOT NULL,PrimaryDEBIT流入DOUBLE PRECISION,CREDIT流出銷(xiāo)售收款

33、主表DOUBLE PRECISION表名：CHARGE字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明CHARGEID順序號(hào)INTEGERNOTPrimary;CODE BILLDATE單號(hào) 單據(jù)日期VARCHAR(25)NOTDATEUn ique;FLAG沖紅標(biāo)志INTEGERREFERBILLID沖紅單IDINTEGEROPERATOR操作員VARCHAR(10)CLIENTID客戶編號(hào)INTEGER,AMOUNT總金額DOUBLE PRECISION收款方式（現(xiàn)金/支票/本票/匯票），PAYTYPEID收付款方式ID SMALLINTCHECKNO票號(hào)VARCHAR(20),BANKID銀

34、行IDSMAL LINT,ISPC是否預(yù)付款VARCHAR(1)收款類(lèi)型（F應(yīng)收款/T預(yù)收款）MEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT銷(xiāo)售收款從表表名：CHARGEDETAIL字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明CHARGEID主表IDINTEGERNOTPrimaryITEMNO從表IDSMALLINTNOTPrimaryINVOICEID銷(xiāo)售單IDINTEGERAMOUNT總金額FLOAT表名：CHARTABLE字段名中文描述字母表CHARS字

35、母符號(hào)VARCHAR(2)NOT班次（POS用）表名:CLASS字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明CLASSID順序號(hào)INTEGERNOTPrimary ;CLASSCODE編號(hào)VARCHAR(2)NOTUnique ;CLASSNAME名稱VARCHAR(20)NOTUnique ;UPFLAG發(fā)送標(biāo)志VARCHAR(1)字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明客戶資料表名：CLIENT字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明CLIENTID編號(hào)INTEGERNOTPrimarySHORTNAME簡(jiǎn)稱VARCHAR(20)NOTUniqueNAME全稱VARCHAR(40),AREAID

36、地區(qū)編碼SMALLINT,CONTATOR聯(lián)系人VARCHAR(16),PHONE電話VARCHAR(20),FAX傳真VARCHAR(20),ADDRESS地址VARCHAR(40),ZIP郵編VARCHAR(12),BANK開(kāi)戶銀行VARCHAR(30),BANKID銀行帳號(hào)VARCHAR(20),TAX ID納稅號(hào)VARCHAR(20),SURAMT預(yù)收金額DOUBLE PRECISION,BALANCE應(yīng)收金額DOUBLE PRECISION,CREDIT信譽(yù)額度DOUBLE PRECISION,INITBILLIDINTEGER,CLOSED禁用標(biāo)志VARCHAR(1),MEMO備注

37、VARCHAR(40),EMAIL電子郵箱VARCHAR(40),URL公司主頁(yè)地址VARCHAR(50),PAGERCall 機(jī)VARCHAR(20),MOBILEPHONE手機(jī)號(hào)碼VARCHAR(20),SCAMT實(shí)際欠款DOUBLE PRECISION,UPFLAG發(fā)送標(biāo)志VARCHAR(1)表名：COMBIN字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空COMBINID單據(jù)IDINTEGERNOTCODE單據(jù)編號(hào)VARCHAR(25)NOTBILLDATE開(kāi)單日期DATE,STOREID倉(cāng)庫(kù)IDINTEGER,GOODSID貨品IDVARCHAR(20),QUANTITY數(shù)量DOUBLE P

38、RECISION,PRICE單價(jià)DOUBLE PRECISION,FLAG組裝拆卸標(biāo)志VARCHAR(1),OPERATOR操作員VARCHAR(10),MEMO備注VARCHAR(40)UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT組裝拆卸主表說(shuō)明Primary Un ique組裝拆卸從表表名：COMBIND字段名中文描菰字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明COMBINID單據(jù)IDINTEGERNOTPrimary;ITEMNO明細(xì)號(hào)SMALLINTNOTPrimaryGOODSID貨品IDVARC

39、HAR(20),QUANTITY數(shù)量DOUBLE PRECISION,PRICE單價(jià)DOUBLE PRECISION,憑證主表表名:CREDENCE字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明CREDID憑證IDVARCHAR(10)NOTPrimaryCREDNO憑證編號(hào)SMALLINT,CREDDATE生成憑證日期DATE,BILLNUMBER憑證附件數(shù)SMALLINT,BILLMAKER憑證制做人VARCHAR(10),BILLCHECK憑證審核人VARCHAR(10),BILLPOST憑證提交VARCHAR(10),CHECKFLAG審核標(biāo)志VARCHAR(1),POSTFLAG提交標(biāo)

40、志VARCHAR(1),CREDTYPE憑證類(lèi)型SMALLINT,RELEVANTBILLID；中紅單據(jù) ID INTEGER,UPDATETIME修改日期DATERPTID打印樣式IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT憑證從表表名：CREDITEM字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明CREDID憑證IDVARCHAR(10)NOTPrimaryFENLUNO分錄號(hào)SMAL LINTNOTPrimarySUBID會(huì)計(jì)科目號(hào)VARCHAR(18),BRIEF憑證摘要VARCHAR(40),MONEYID貨幣號(hào)SMAL LINT,RAT

41、E貨幣匯率DOUBLE PRECISION,RAWDEBIT借方匯率DOUBLE PRECISION,RAWCREDIT貸方匯率DOUBLE PRECISION,DEBIT借方金額DOUBLE PRECISION,CREDIT貸方金額DOUBLE PRECISION,ATTRFLAGSMALLINT,READONLY是否只讀VARCHAR(1)憑證從表中間表表名：CREDITEM_TMP是否為空說(shuō)明Primary字段名SUBIDDEBITCREDIT中文描述科目ID借方金額貸方金額字段類(lèi)型/字段長(zhǎng)度VARCHAR(18)NOTDOUBLE PRECISION,DOUBLE PRECISION,

42、零售開(kāi)單主表表名：CSALE字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明CSALEID順序號(hào)INTEGERNOTPrimary;llnique;CODE單據(jù)編號(hào)VARCHAR(22)NOTBILLDATE開(kāi)單日期DATEFLAG標(biāo)志INTEGERREFERBILLID相矢單IDINTEGEROPERATOR操作員姓名VARCHAR(10)當(dāng)前系統(tǒng)用戶EXEMANID經(jīng)辦人IDINTEGER業(yè)務(wù)員（售貨員、收銀員）BILLTYPEID單據(jù)類(lèi)型IDSMALLINT1收據(jù)/2普通發(fā)票/3增值稅發(fā)票STOREID倉(cāng)庫(kù)IDINTEGERCLIENTID客戶IDINTEGER為特定的零售帳戶SHIPTO送

43、貨地址VARCHAR(40)TOTALAMT總金額DOUBLE PRECISIONPAYTYPEID付款類(lèi)型SMALLINT收款方式（現(xiàn)金/支票/本票/匯票）BANKID銀行IDSMAL LINTCHECKNO票號(hào)VARCHAR(20)MEMO備注VARCHAR(40)TOTALRETURN退貨金額DOUBLE PRECISIONUPDATETIME更新時(shí)間DATERPTID打印樣式IDINTEGERDISCID折扣IDINTEGERSHOPID分支機(jī)構(gòu)IDSMALLINTSFLAG傳輸標(biāo)志SMALLINT零售開(kāi)單從表表名：CSALEDETAIL字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明CS

44、ALEID主表IDINTEGERNOTPrimary;ITEMNO明細(xì)號(hào)SMALLINTNOTPrimary;GOODSID貨物IDVARCHAR(20)QUANTITY數(shù)量DOUBLE PRECISIONRETURNQTY退貨數(shù)量DOUBLE PRECISIONPRICE銷(xiāo)售價(jià)格DOUBLE PRECISIONAPRICE成本價(jià)格DOUBLE PRECISIONTAXRATE稅率DOUBLE PRECISIONDISC折扣DOUBLE PRECISION貨幣資料表名:CURRENCY字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明MONEYID貨幣編號(hào)SMAL LINTNOTPrimaryNAME貨幣名稱VARCHAR(IO)NOTUn iqueRATE匯率DOUBLE PRECISION,UPFLAG發(fā)送標(biāo)志VARCHAR(l)自定義報(bào)表表名：CUSTOMREP字段名中文描述字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明FILENAME報(bào)表名VARCHAR(40)NOTPrimaryFILEBLOB存儲(chǔ)文件流BLOB SUB TYPE 0 SEGMENT SIZE 80客戶供應(yīng)商平衡表初始化表名：CVBALANCEINIT字段類(lèi)型/字段長(zhǎng)度是否為空說(shuō)明YEAR年份INTEGERMONTH月份INTEGERCVTYPE客戶供應(yīng)商標(biāo)志VARCHA