銷售管理系統(tǒng)相關(guān)代碼(編輯修改稿)
2025-05-05 06:09 本頁面
【文章內(nèi)容簡(jiǎn)介】 (60) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[客戶基礎(chǔ)信息表] ( [客戶編號(hào)] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [客戶全稱] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [簡(jiǎn)稱] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [地址] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [傳真] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [聯(lián)系人] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [聯(lián)系人電話] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [開戶銀行] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [納稅人] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [郵箱網(wǎng)址] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [郵政編碼] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [銀行賬號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[操作員信息表] ( [操作員編號(hào)] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [操作員姓名] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [操作員密碼] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [操作員級(jí)別] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [時(shí)間] [datetime] NOT NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[訂貨票號(hào)表] ( [訂單號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [品種數(shù)] [int] NULL , [數(shù)量] [int] NULL , [應(yīng)付金額] [money] NULL , [訂貨時(shí)間] [datetime] NULL , [經(jīng)手人] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [操作員] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [是否可用] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[銷售票號(hào)表] ( [銷售票號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [品種數(shù)] [int] NULL , [數(shù)量] [int] NULL , [應(yīng)付金額] [money] NULL , [付款方式] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [實(shí)付金額] [money] NULL , [銷售時(shí)間] [datetime] NULL , [經(jīng)手人] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [操作員] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[銷售退單票號(hào)表] ( [銷售退單票號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [品種數(shù)] [int] NULL , [數(shù)量] [int] NULL , [應(yīng)付金額] [money] NULL , [付款方式] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [實(shí)付金額] [money] NULL , [退貨時(shí)間] [datetime] NOT NULL , [經(jīng)手人] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [操作員] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[客戶結(jié)款表] ( [客戶編號(hào)] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [客戶全稱] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [金額小計(jì)] [money] NULL , [欠款記賬] [money] NULL , [付款合計(jì)] [money] NULL , [結(jié)款時(shí)間] [datetime] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[客戶訂貨表] ( [客戶編號(hào)] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [客戶名稱] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [商品編號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [商品名稱] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [數(shù)量] [int] NULL , [金額] [money] NULL , [折扣] [float] NULL , [訂貨票號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[庫存表] ( [商品編號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [商品名稱] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [庫存數(shù)量] [int] NULL , [庫存金額] [money] NULL , [盤點(diǎn)] [int] NULL ) ON [PRIMARY]GOCREATE TABLE [dbo].[銷售表] ( [商品編號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [商品名稱] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [客戶編號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [客戶全稱] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [數(shù)量] [int] NULL , [金額] [money] NULL , [折扣] [float] NULL , [銷售票號(hào)] [varchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ) ON [PRIMARY]GOCREATE T
公司管理相關(guān)推薦
鄂ICP備17016276號(hào)-1