szb_purinlist.txt

来自「二次开发模块 一、条形码的批量生成」· 文本 代码 · 共 25 行

CREATE TABLE [Szb_PurInList] (
	[ID] [int] IDENTITY (1, 1) NOT NULL ,
	[PCID] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[iPurID] [int] NULL ,
	[cVouchType] [varchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
	[cInvCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cInvName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[cInvStd] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
	[cBarCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[iQuantity] [float] NULL ,
	[iUnitCost] [float] NULL ,
	[iPrice] [money] NULL ,
	[iPosID] [int] NULL ,
	[iArrsId] [int] NULL ,
	[iDLsID] [int] NULL ,
	[cTrueBarCode] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
	[cFree1] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[cFree2] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[iBox] [int] NULL CONSTRAINT [DF_Szb_PurInList_iBox] DEFAULT (0),
	[iBundle] [int] NULL CONSTRAINT [DF_Szb_PurInList_iBundle] DEFAULT (0),
	CONSTRAINT [PK_Szb_PurInList] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
) ON [PRIMARY]