表描述.docx
- 文档编号:4295528
- 上传时间:2022-11-29
- 格式:DOCX
- 页数:34
- 大小:21.90KB
表描述.docx
《表描述.docx》由会员分享,可在线阅读,更多相关《表描述.docx(34页珍藏版)》请在冰豆网上搜索。
表描述
公司名录
[dbo].[COMPANY](
[CODE][varchar](10)NOTNULL,
[CMPDPT][varchar](6)NULL,
[TYPE][smallint]NULL,
[NAME][varchar](50)NULL,
[ADDR1][varchar](50)NULL,
[ADDR2][varchar](50)NULL,
[ADDR3][varchar](50)NULL,
[ZIP][varchar](8)NULL,
[PHONE][varchar](20)NULL,
[FAX][varchar](20)NULL,
[LEADTIME][smallint]NULL,
[PAYTERM][smallint]NULL,
[CONTACT][varchar](30)NULL,
[AREA][varchar](20)NULL,
[COUNTRY][varchar](20)NULL,
[TXNTYPE][smallint]NOTNULLCONSTRAINT[DF_COMPANY_TXNTYPE]DEFAULT((0)),
[DISCOUNT][real]NULL,
[DISCTYPE][smallint]NULL,
[LASTTALK][datetime]NULL,
[SHORTNAME][varchar](20)NOTNULL,
[ACCT][varchar](10)NULL,
[ACCT1][varchar](50)NULL,
[ACCT2][varchar](50)NULL,
[ACCT3][varchar](50)NULL,
[PROFILE][text]NULL,
[FUNC][text]NULL,
[ACHV][text]NULL,
[CHAIRPERSON][varchar](20)NULL,
[CHIEFEDITOR][varchar](20)NULL,
[EMAILADDR][varchar](50)NULL,
[CMPPAYMENT][varchar](6)NULL,
[CMPCSDAYS][smallint]NULL,
[SEQ][int]NULL,
[ISEQ][int]NOTNULLCONSTRAINT[DF_COMPANY_ISEQ]DEFAULT((0)),
[JP][varchar](50)NULL,
[ISACTIVE][smallint]NULL,
[HighStore][varchar](20)NULL,
单号
CREATETABLE[dbo].[NUMBERS](
[ID][int]IDENTITY(1,1)NOTNULL,
[PO][smallint]NULL,
[MPO][varchar](6)NULL,
[RCV][smallint]NULL,
[MRCV][varchar](6)NULL,
[SM][smallint]NULL,
[MSM][varchar](6)NULL,
[DN][smallint]NULL,
[MSH][varchar](50)NULL,
[SH][bigint]NULL,
[MDN][varchar](6)NULL,
[CRT][bigint]NULL,
[MCRT][varchar](6)NULL,
[IN_][bigint]NULL,
[MIN_][varchar](6)NULL,
[OUT][bigint]NULL,
[MOUT][varchar](6)NULL,
[TXF][bigint]NULL,
[MTXF][varchar](6)NULL,
[CNT][bigint]NULL,
[MCNT][varchar](6)NULL,
[BAT][bigint]NULL,
[MBAT][varchar](6)NULL,
[TXN][bigint]NULL,
[MTXN][varchar](6)NULL,
[IBAT][bigint]NULL,
[MIBAT][varchar](6)NULL,
[PAY][bigint]NULL,
[MPAY][varchar](6)NULL,
[ULDATE][datetime]NULL,
[NBSDATE][datetime]NULL,
[MDDATE][datetime]NULL,
[HLD][bigint]NULL,
[MHLD][varchar](6)NULL,
[NBSTKDATE][datetime]NULL,
[NBSTKTS][bigint]NULL,
[NBSTS][bigint]NULL,
[MSPLUTS][bigint]NULL,
[MPRT][varchar](6)NULL,
[PRT][bigint]NULL,
[DITMP][bigint]NULL,
[MDITMP][varchar](6)NULL,
[PKDN][bigint]NULL,
[MPKDN][varchar](6)NULL,
[CMONTHS][bigint]NULL
仓数
CREATETABLE[dbo].[TXNRACK](
[RACK][varchar](12)NOTNULL,
[PLUCODE][varchar](20)NOTNULL,
[QTY][int]NULL,
[GRNBAT][int]NOTNULLCONSTRAINT[DF_TXNRACK_GRNBAT]DEFAULT((0)),
[ZTQTY][int]NULL,
CONSTRAINT[PK_TXNRACK]PRIMARYKEYCLUSTERED
(
[RACK]ASC,
[PLUCODE]ASC,
[GRNBAT]ASC
CREATETABLE[dbo].[STKLEDGER](
[PLUCODE][varchar](20)NOTNULL,
[TXNDATE][datetime]NULL,
[TXNTYPE][smallint]NOTNULL,
[NUMBER][int]NOTNULL,
[SEQ][smallint]NULLCONSTRAINT[DF_STKLEDGER_SEQ]DEFAULT((0)),
[QTY][int]NULL,
[LNKNUM][int]NOTNULL,
[PRICE][money]NULL,
[DISC][real]NULL,
[APV][smallint]NOTNULLCONSTRAINT[DF_STKLEDGER_APV]DEFAULT((0)),
[TORACK][varchar](12)NOTNULL,
[FROMRACK][varchar](12)NOTNULL,
[UNICODE][varchar](20)NULL,
[ODATE][datetime]NULL,
[GRNBAT][int]NOTNULLCONSTRAINT[DF_STKLEDGER_GRNBAT]DEFAULT((0)),
[SPLT][smallint]NOTNULLCONSTRAINT[DF_STKLEDGER_SPLT]DEFAULT((0)),
[PAID][datetime]NULL,
[ORGPRICE][money]NULL,
[STATUS][tinyint]NULL,
[RCVQTY][int]NULL,
CONSTRAINT[PK_STKLEDGER]PRIMARYKEYCLUSTERED
(
[PLUCODE]ASC,
[TXNTYPE]ASC,
[NUMBER]ASC,
[LNKNUM]ASC,
[TORACK]ASC,
[FROMRACK]ASC,
[GRNBAT]ASC,
[SPLT]ASC
类型
[dbo].[PKSTYLE](
[STYLE][varchar]
(2)NOTNULL,
[DESCRIPT][varchar](10)NULL,
[PIECES][smallint]NULL,
图书资料
CREATETABLE[dbo].[PLU](
[ISBN][varchar](20)NOTNULL,
[TITLE][varchar](160)NOTNULL,
[AUTHOR][varchar](80)NULL,
[TRANSLATOR][varchar](80)NULL,
[SERIES][varchar](160)NULL,
[PRICE][money]NOTNULL,
[EDITION][smallint]NULL,
[NPRINT][smallint]NULL,
[CLSCODE][varchar](10)NOTNULL,
[CATEGORY][varchar](6)NULL,
[PUBLISHER][varchar](10)NOTNULL,
[PUBDATE][datetime]NULL,
[PAGES][smallint]NULL,
[WORDS][int]NULL,
[BINDING][varchar](6)NULL,
[CREDATE][datetime]NOTNULL,
[CREATBY][varchar](6)NULL,
[SIJIAOHAO][varchar](20)NULL,
[ISISBN][smallint]NULL,
[PLUCODE][varchar](20)NOTNULL,
[ISABOOK][smallint]NOTNULL,
[EXTCODE][varchar](8)NULL,
[BKSIZE][varchar](6)NULL,
[FULLCAT][varchar](12)NULL,
[PYSTYPE][smallint]NOTNULL,
[MODDATE][datetime]NULL,
[MODBY][varchar](6)NULL,
[JP][varchar](160)NULL,
[HIPRICE][money]NULL,
[AVPRICE][money]NULL,
[LSPRICE][money]NULL,
[LDATE][datetime]NULL,
[DPTCODE][varchar](6)NULL,
[PKSTYLE][varchar]
(2)NULL,
[PKPC][smallint]NULL,
[PKQTY][smallint]NULL,
[PKWT][smallint]NULL,
[WSDISC][real]NULL,
[RTNABLE][smallint]NULL,
[CMMUSE][smallint]NULL,
[APRICE][money]NULL,
[BPRICE][money]NULL,
[CPRICE][money]NULL,
[ISBN10][varchar](20)NULL
订单明细
CREATETABLE[dbo].[PODTL](
[UNICODE][varchar](20)NULL,
[PLUCODE][varchar](20)NOTNULL,
[SEQ][smallint]NOTNULLCONSTRAINT[DF_PODTL_SEQ]DEFAULT((0)),
[NUMBER][int]NOTNULL,
[STATUS][smallint]NULL,
[DISC][real]NULL,
[PODATE][datetime]NULL,
[QTY][int]NULL,
[RCVQTY][int]NULL,
[APV][smallint]NULLCONSTRAINT[DF_PODTL_APV]DEFAULT((0)),
[RCVDATE][datetime]NULL,
[PRICE][money]NULL,
[TQTY][int]NULLCONSTRAINT[DF_PODTL_TQTY]DEFAULT((0)),
[PAIDQTY][int]NULLCONSTRAINT[DF_PODTL_PAIDQTY]DEFAULT((0)),
[PAIDAMT][float]NULLCONSTRAINT[DF_PODTL_PAIDAMT]DEFAULT((0)),
[TXFNUM][varchar](20)NULL,
装帧
CREATETABLE[dbo].[BINDING](
[CODE][int]NOTNULL,
[BINDING][varchar](50)NULL,
[STATUS][int]NOTNULLCONSTRAINT[DF_BINDING_STATUS]DEFAULT((0)),
订单单头
CREATETABLE[dbo].[POHDR](
[VENDOR][varchar](10)NULL,
[PHONE][varchar](20)NULL,
[FAX][varchar](20)NULL,
[CONTACT][varchar](30)NULL,
[CREDATE][datetime]NULL,
[CREATEDBY][varchar](10)NULL,
[NUMBER][int]NOTNULL,
[DLVYDATE][datetime]NULL,
[REMARKS][varchar](100)NULL,
[SENDDATE][datetime]NULL,
[STATUS][smallint]NULL,
[APVBY][varchar](10)NULL,
[REASON][smallint]NULL,
[DISCOUNT][real]NULL,
[PAIDAMT][money]NULL,
[PAID][datetime]NULL,
[RECEIPT][varchar](20)NULL,
[DLVYNUM][int]NULL,
[ISTBPO][tinyint]NULLCONSTRAINT[DF_POHDR_ISTBPO]DEFAULT((0)),
[ISCSM][tinyint]NULLCONSTRAINT[DF_POHDR_ISCSM]DEFAULT((0)),
[DPTCODE][varchar](6)NULL,
CREATETABLE[dbo].[BOOKS](
[UNICODE][varchar](20)NOTNULL,
[BCODE][varchar](20)NOTNULL,
[BTYPE][int]NOTNULLCONSTRAINT[DF_BOOKS_BTYPE]DEFAULT((0)),
[LUNICODE][varchar](20)NULL,
[TITLE][varchar](200)NULL,
[ASSESSMENT][money]NOTNULLCONSTRAINT[DF_BOOKS_ASSESSMENT]DEFAULT((0)),
[PRICE][money]NOTNULLCONSTRAINT[DF_BOOKS_PRICE]DEFAULT((0)),
[GRADE][int]NULL,
[SUBJECTS][int]NULL,
[PUBLISHER][varchar](10)NULL,
[PUBDATE][datetime]NULL,
[CREATBY][varchar](8)NULL,
[CREDATE][datetime]NULL,
[TEXTTYPE][int]NOTNULLCONSTRAINT[DF_BOOKS_TEXTTYPE]DEFAULT((0)),
[SEM][varchar](10)NULL,
[SDISC][int]NOTNULLCONSTRAINT[DF_BOOKS_SDISC]DEFAULT((100)),
[STATUS][int]NOTNULLCONSTRAINT[DF_BOOKS_STATUS]DEFAULT((0)),
商品类型
CREATETABLE[dbo].[BTYPE](
[CODE][int]NOTNULL,
[BTYPE][varchar](50)NULL,
[STATUS][int]NOTNULLCONSTRAINT[DF_BTYPE_STATUS]DEFAULT((0)),
开本
CREATETABLE[dbo].[FORMAT](
[CODE][int]NOTNULL,
[FORMAT][varchar](50)NULL,
[STATUS][int]NOTNULLCONSTRAINT[DF_FORMAT_STATUS]DEFAULT((0)),
年级
CREATETABLE[dbo].[GRADE](
[CODE][int]NOTNULL,
[GRADE][varchar](50)NULL,
[STATUS][int]NOTNULLCONSTRAINT[DF_GRADE_STATUS]DEFAULT((0)),
教材类型
CREATETABLE[dbo].[TEXTTYPE](
[CODE][int]NOTNULL,
[TEXTTYPE][varchar](50)NULL,
[STATUS][int]NOTNULLCONSTRAINT[DF_TEXTTYPE_STATUS]DEFAULT((0)),
退货单
CREATETABLE[dbo].[PRET](
[NUMBER][int]NOTNULL,
[CREDATE][datetime]NULL,
[CREATEBY][varchar](10)NULL,
[RETDATE][datetime]NULL,
[REMARK][varchar](200)NULL,
[HANDLEBY][varchar](20)NULL,
[VENDOR][varchar](10)NULL,
[APVBY][varchar](10)NULL,
[REASON][smallint]NULL,
[PAID][datetime]NULL,
[WAREHOUSE][varchar](8)NULL,
[VALBY][varchar](6)NULL,
[PKBY][varchar](6)NULL,
[DLVBY][varchar](6)NULL,
[TXFBY][varchar](6)NULL,
[TXFDATE][datetime]NULL,
[DLVYDATE][datetime]NULL,
[TRAMT][float]NULL,
[TRNET][float]NULL,
[TRCNT][int]NULL,
[TRQTY][int]NULL,
[LTERM][varchar](6)NULL,
[LMEANS][varchar]
(2)NULL,
[LDSTRB][varchar](10)NULL,
[L2DSTRB][varchar](10)NULL,
[FIX][smallint]NULL,
[SEL][smallint]NULL,
[PWS][real]NULL,
[PKS][smallint]NULL,
[DNUM][int]NULL,
[CHK][smallint]NULL,
[ADDR][varchar](100)NULL,
[ZIP][varchar](10)NULL,
[PHONE][varchar](20)NULL,
[CONTACT][varchar](30)NULL,
[STKMOVENUM][int]NULL,
架号
CREATETABLE[dbo].[RACK](
[WAREHOUSE][varchar](8)NULL,
[RACK][varchar](12)NOTNULL,
[STKCNT][smallint]NOTNULL,
[COUNTED][smallint]NOTNULL,
[LVL][varchar](8)NULL,
[CNTDATE][datetime]NULL,
批销单
CREATETABLE[dbo].[SALEHDR](
[CUSTOMER][varchar](10)NULL,
[CREDATE][datetime]NULL,
[CREATEBY][varchar](10)NULL,
[NUMBER][int]NOTNULL,
[TXNTYPE][smallint]NULL,
[APVBY][varchar](10)NULL,
[WAREHOUSE][varchar](8)NULL,
[PAYMENT][varchar](6)NULL,
[TAX][real]NULL,
[PAID][datetime]NULL,
[TXNTIME][char](4)NULL,
[ISTBPO][tinyint]NULLCONSTRAINT[DF_SALEHDR_ISTBPO]DEFAULT((0)),
[PDAYS][smallint]NULL,
[CSDAYS][smallint]NULL,
[URGENT][smallint]NULL,
[INUM][int]NULL,
[REMARKS][varchar](40)
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 描述