freepeople性欧美熟妇, 色戒完整版无删减158分钟hd, 无码精品国产vα在线观看DVD, 丰满少妇伦精品无码专区在线观看,艾栗栗与纹身男宾馆3p50分钟,国产AV片在线观看,黑人与美女高潮,18岁女RAPPERDISSSUBS,国产手机在机看影片

正文內(nèi)容

銷售管理系統(tǒng)相關(guān)代碼-wenkub

2023-04-23 06:09:56 本頁面
　

【正文】 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 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 TABLE [dbo].[客戶結(jié)款記錄表] ( [客戶編號(hào)] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL , [客戶全稱] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL , [結(jié)款金額] [money] NULL , [結(jié)款時(shí)間] [datetime] NULL , [操作員] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY]GO創(chuàng)建主鍵約束ALTER TABLE [dbo].[商品基礎(chǔ)信息表] WITH NOCHECK ADD CONSTRAINT [PK_商品基礎(chǔ)信息表] PRIMARY KEY CLUSTERED ( [商品編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[客戶基礎(chǔ)信息表] WITH NOCHECK ADD CONSTRAINT [PK_客戶基礎(chǔ)信息表] PRIMARY KEY CLUSTERED ( [客戶編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[操作員信息表] WITH NOCHECK ADD CONSTRAINT [PK_操作員信息表] PRIMARY KEY CLUSTERED ( [操作員編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[訂貨票號(hào)表] WITH NOCHECK ADD CONSTRAINT [PK_訂貨票號(hào)表] PRIMARY KEY CLUSTERED ( [訂單號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[銷售票號(hào)表] WITH NOCHECK ADD CONSTRAINT [PK_銷售票號(hào)表] PRIMARY KEY CLUSTERED ( [銷售票號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[銷售退單票號(hào)表] WITH NOCHECK ADD CONSTRAINT [PK_銷售退單票號(hào)表] PRIMARY KEY CLUSTERED ( [銷售退單票號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[客戶結(jié)款表] WITH NOCHECK ADD CONSTRAINT [PK_客戶結(jié)款表] PRIMARY KEY CLUSTERED ( [客戶編號(hào)] ) ON [PRIMARY] GOALTER TABLE [dbo].[客戶訂貨表] WITH NOCHECK ADD CONSTRAINT [PK_客戶訂貨表] PRIMARY KEY CLUSTERED ( [
點(diǎn)擊復(fù)制文檔內(nèi)容
公司管理相關(guān)推薦
文庫吧　www.dybbs8.com
備案圖片鄂ICP備17016276號(hào)-1