新增文章

文章标题分类内容

if object_id('[tempdb].[dbo].[TempChar]') Is Not Null 
   truncate table TempChar
else 
begin 
create table TempChar ( 
   FIndex  int not null,   --关联TempBomOpenDest 的Findex字段
   FCharID int null,       --特性ID
   FCharValID  int null )   --特性值 
end

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

if exists (select name from sysobjects where name = 'aTmp_ICMO')
   truncate table aTmp_ICMO  
else 
begin 
   Create Table aTmp_ICMO ( 
      FIndex int IDENTITY, 
      FItemID int null, 
      FICMOInterID int null 
   ) 
end

if  exists (select * from sys.objects where object_id = object_id(N'dbo.T_PUR_PoOrderUse') and type in (N'U'))
            drop     table                                          dbo.T_PUR_PoOrderUse
go

create table t_PUR_PoOrderUse(
   
   FEntryIdUse      int  identity(1,1) primary key , -- 自动递增
      
   FID            int default(0) null ,
   FEntryId       int default(0) null ,
   FSeq           int default(0) null ,

FID_PPBom      int default(0) null ,
   FEntryId_PPBom int default(0) null ,
   FEntryIdWk     int default(0) null ,

FBillNo_PPBom  nvarchar(30) default('') null ,
   FSeq_PPBom     int default(0) null ,

FWeek_PPBom    int default(0) null ,
   FQtyUse_PPBom  decimal(23, 10) default(0) null ,
);