USE [SFIS_PTD]
GO
/****** Object:  Table [dbo].[RecordTypeInfo]    Script Date: 2024/5/28 02:48:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[RecordTypeInfo](
	[RBU] [nvarchar](10) NULL,
	[ID] [nvarchar](10) NOT NULL,
	[TypeName] [nvarchar](25) NULL,
	[TypeDesc] [nvarchar](50) NULL,
	[Source] [nvarchar](10) NULL,
	[PrefixCode] [nvarchar](20) NULL,
	[Length] [int] NULL,
	[Status] [nvarchar](10) NULL,
 CONSTRAINT [PK__RecordTy__3214EC278D1558A2] PRIMARY KEY CLUSTERED 
(
	[ID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'101', N'成品入庫', N'工單/外購品 入庫', N'SAP', N'5', 10, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'101R', N'成品整新入庫', N'同序號，同料號或不同料號', N'SAP', N'9', 10, N'WI')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'201', N'部門費領', N'部門費用化領料', N'FLOW', N'IR', 11, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'202', N'費退入庫', N'費用化領用後再退回', N'FLOW', N'RT', 11, N'WI')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'261', N'工單發料', N'工單生產發料', N'SAP', N'9', 10, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'262', N'工單退料', N'工單生產退料', N'SAP', N'9', 10, N'WI')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'291', N'部門費領(專案)', N'部門費用化領料', N'FLOW', N'IR', 11, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'292', N'費退入庫(專案)', N'PM 專案費退入庫', N'FLOW', N'RT', 11, N'WI')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'601', N'出貨', N'出貨', N'SAP', N'00800', 10, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'601DB', N'DOA 換貨', N'DOA 換貨', N'SAP', N'00800', 10, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'631', N'客戶暫借', N'客戶借貨', N'SAP', N'00800', 10, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'632', N'暫借退回', N'客戶借貨退回', N'FLOW', N'SR', 11, N'WI')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'633', N'借貨轉銷', N'客戶借貨轉銷貨', N'SAP', N'00800', 10, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'634', N'借貨轉銷貨退回', N'客戶借貨轉銷貨退回', N'FLOW', N'SR', 11, N'WI')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'653', N'訂單退貨', N'客戶一般訂單退貨', N'FLOW', N'RS', 11, N'WI')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'657', N'DOA 還回 ', N'DOA 還回 ', N'FLOW', N'SR', 11, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'951', N'樣品', N'樣品出貨', N'SAP', N'00800', 10, N'WO')
INSERT [dbo].[RecordTypeInfo] ([RBU], [ID], [TypeName], [TypeDesc], [Source], [PrefixCode], [Length], [Status]) VALUES (N'EV01', N'952', N'樣品退回', N'樣品出貨退回', N'FLOW', N'SR', 11, N'WI')
GO