
CREATE TABLE [dbo].[dept_par](
	[site_cd] [varchar](4) NOT NULL,
	[mst_RowID] [numeric](12, 0) NULL,
	[dept_par_lin_cd] [varchar](30) NOT NULL,
	[dept_par_desc] [varchar](80) NULL,
	[dept_par_qty] [numeric](12, 0) NULL,
	[dept_par_remark] [varchar](255) NULL,
	[audit_user] [varchar](50) NOT NULL,
	[audit_date] [datetime] NOT NULL,
	[column1] [varchar](60) NULL,
	[column2] [varchar](60) NULL,
	[column3] [varchar](60) NULL,
	[column4] [varchar](60) NULL,
	[column5] [varchar](60) NULL,
	[RowID] [numeric](12, 0) IDENTITY(1,1) NOT NULL
) ON [PRIMARY]
GO


DELETE	cf_label
WHERE	table_name = 'dept_par'
AND 	column_name = 'dept_par_lin_cd'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'dept_par', 'dept_par_lin_cd', 
		'Linen Code:', 
		'Linen Code:', 
		'Linen Code', 
		'Linen Code', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


DELETE	cf_label
WHERE	table_name = 'dept_par'
AND 	column_name = 'dept_par_desc'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'dept_par', 'dept_par_desc', 
		'Linen Description:', 
		'Linen Description:', 
		'Linen Description', 
		'Linen Description', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


DELETE	cf_label
WHERE	table_name = 'dept_par'
AND 	column_name = 'dept_par_qty'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'dept_par', 'dept_par_qty', 
		'PAR Level:', 
		'PAR Level:', 
		'PAR Level', 
		'PAR Level', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO


DELETE	cf_label
WHERE	table_name = 'dept_par'
AND 	column_name = 'dept_par_remark'
GO

INSERT 	cf_label (language_cd, table_name, column_name, 
		default_label,
		customize_label, 
		default_header, 
		customize_header, 
		cfr_flag, cf_label_required, audit_user, audit_date ) 
SELECT 	language_cd, 'dept_par', 'dept_par_remark', 
		'Remark:', 
		'Remark:', 
		'Remark', 
		'Remark', 
		'0', '0', 'admin', getdate() 
FROM	cf_language 
GO
