34,576
社区成员
发帖
与我相关
我的任务
分享
CREATE PROCEDURE check_in_confirm_return
@ctn_no character(12),
@in_date datetime,
@id_no character(10)
AS
update load_ctn_details
set load_ctn_details.goods_reach='1'
from load_ctn_details,load_ctn_head,load_ctn_ctns
where load_ctn_head.detail_no = load_ctn_details.detail_no and
load_ctn_ctns.ctn_key_id=load_ctn_details.ctn_key_id and
load_ctn_ctns.ctn_no = @ctn_no and load_ctn_head.dept_id='C' and
(load_ctn_details.goods_reach='0')
GO
表结构如下
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[load_ctn_details]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[load_ctn_details]
GO
CREATE TABLE [dbo].[load_ctn_details] (
[load_key_id] [numeric](18, 0) IDENTITY (1, 1) NOT NULL ,
[detail_no] [varchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[bl_key_id] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[ctn_bl_weight] [decimal](18, 3) NULL ,
[ctn_bl_package] [int] NULL ,
[ctn_real_package] [int] NULL ,
[ctn_bl_size] [decimal](18, 3) NULL ,
[input_seq] [int] NOT NULL ,
[ctn_key_id] [varchar] (12) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[po_no] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[item_no] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[cargo_no] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[guobie] [varchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[batch_seq_no] [varchar] (12) COLLATE Chinese_PRC_CI_AS NULL ,
[goods_reach] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[import_id] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[plan_match_id] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[goods_match] [char] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[load_ctn_details] WITH NOCHECK ADD
CONSTRAINT [PK_load_ctn_details] PRIMARY KEY CLUSTERED
(
[load_key_id]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[load_ctn_details] ADD
CONSTRAINT [f_bl_id] FOREIGN KEY
(
[bl_key_id]
) REFERENCES [dbo].[load_ctn_bls] (
[bl_key_id]
)
GO