truncate table licl_mst
GO
truncate table licl_det
GO
truncate table licl_ls1
GO
truncate table licl_ls2
GO
truncate table licl_ls3
GO
truncate table licl_ls4
GO
truncate table licl_ls5
GO
truncate table licl_ls6
GO
truncate table licl_ref
GO

drop table licl_mst
GO
drop table licl_det
GO
drop table licl_ls1
GO
drop table licl_ls2
GO
drop table licl_ls3
GO
drop table licl_ls4
GO
drop table licl_ls5
GO
drop table licl_ls6
GO
drop table licl_ref
GO

CREATE TABLE [dbo].[licl_mst](
	[site_cd] [varchar](4) NOT NULL,
	[licl_mst_licl_no] [varchar](11) NOT NULL,
	[licl_mst_licl_period] [varchar](20) NOT NULL,
	[licl_mst_licl_date_frm] [datetime] NULL,
	[licl_mst_licl_date_to] [datetime] NULL,
	[licl_mst_status] [varchar](3) NULL,
	[licl_mst_routine_date] datetime NULL,
	[licl_mst_desc] [varchar](255) NULL,
	[licl_mst_remark] [varchar](255) NULL,
	[licl_mst_create_by] [varchar](50) NULL,
	[licl_mst_create_date] [datetime] NULL,
	[audit_user] [varchar](50) NULL,
	[audit_date] [datetime] NOT NULL,
	[mbl_audit_user] [varchar](50) NULL,
	[mbl_audit_date] [datetime] 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 from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_licl_no'			
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, 'licl_mst', 'licl_mst_licl_no', 'Inventory Checklist No.:', 'Inventory Checklist No.:', 'Inventory Checklist No.:', 'Inventory Checklist No.', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_licl_period'			
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, 'licl_mst', 'licl_mst_licl_period', 'Period:', 'Period:', 'Period:', 'Period', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_licl_date_frm'			
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, 'licl_mst', 'licl_mst_licl_date_frm', 'From Date:', 'From Date:', 'From Date:', 'From Date', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_licl_date_to'			
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, 'licl_mst', 'licl_mst_licl_date_to', 'To Date:', 'To Date:', 'To Date:', 'To Date', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_status'			
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, 'licl_mst', 'licl_mst_status', 'Status:', 'Status:', 'Status:', 'Status', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_routine_date'			
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, 'licl_mst', 'licl_mst_routine_date', 'Routine Date:', 'Routine Date:', 'Routine Date:', 'Routine Date', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_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, 'licl_mst', 'licl_mst_desc', 'Description:', 'Description:', 'Description:', 'Description', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_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, 'licl_mst', 'licl_mst_remark', 'Remark:', 'Remark:', 'Remark:', 'Remark', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_create_by'			
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, 'licl_mst', 'licl_mst_create_by', 'Create By:', 'Create By:', 'Create By:', 'Create By', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_mst' AND column_name = 'licl_mst_create_date'			
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, 'licl_mst', 'licl_mst_create_date', 'Create Date:', 'Create Date:', 'Create Date:', 'Create Date', '0', '0', 'admin', getdate() FROM cf_language
GO




CREATE TABLE [dbo].[licl_det](
	[site_cd] [varchar](4) NOT NULL,
	[mst_RowID] [numeric](12, 0) NULL,
	[licl_det_sign_by] [varchar](100) NULL,
	[licl_det_sign_by_id] [varchar](100) NULL,
	[licl_det_sign_by_contact] [varchar](100) NULL,
	[licl_det_sign_by_title] [varchar](100) NULL,
	[licl_det_sign_date] [datetime] NULL,
	[licl_det_varchar1] [varchar](100) NULL,
	[licl_det_varchar2] [varchar](100) NULL,
	[licl_det_varchar3] [varchar](100) NULL,
	[licl_det_varchar4] [varchar](100) NULL,
	[licl_det_varchar5] [varchar](100) NULL,
	[licl_det_varchar6] [varchar](100) NULL,
	[licl_det_varchar7] [varchar](100) NULL,
	[licl_det_varchar8] [varchar](100) NULL,
	[licl_det_varchar9] [varchar](100) NULL,
	[licl_det_varchar10] [varchar](100) NULL,
	[licl_det_numeric1] [numeric](21, 4) NULL,
	[licl_det_numeric2] [numeric](21, 4) NULL,
	[licl_det_numeric3] [numeric](21, 4) NULL,
	[licl_det_numeric4] [numeric](21, 4) NULL,
	[licl_det_numeric5] [numeric](21, 4) NULL,
	[licl_det_datetime1] [datetime] NULL,
	[licl_det_datetime2] [datetime] NULL,
	[licl_det_datetime3] [datetime] NULL,
	[licl_det_datetime4] [datetime] NULL,
	[licl_det_datetime5] [datetime] NULL,
	[licl_det_note1] [varchar](1000) NULL,
	[audit_user] [varchar](50) NULL,
	[audit_date] [datetime] NOT NULL,
	[mbl_audit_user] [varchar](50) NULL,
	[mbl_audit_date] [datetime] 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 from cf_label where table_name = 'licl_det	licl_det' AND column_name = 'licl_det_sign_by'			
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, 'licl_det', 'licl_det_sign_by', 'Sign By:', 'Sign By:', 'Sign By:', 'Sign By', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_sign_by_id'			
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, 'licl_det', 'licl_det_sign_by_id', 'Sign By ID:', 'Sign By ID:', 'Sign By ID:', 'Sign By ID', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_sign_by_contact'			
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, 'licl_det', 'licl_det_sign_by_contact', 'Contact Number:', 'Contact Number:', 'Contact Number:', 'Contact Number', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_sign_by_title'			
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, 'licl_det', 'licl_det_sign_by_title', 'Sign By Title:', 'Sign By Title:', 'Sign By Title:', 'Sign By Title', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_sign_date'			
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, 'licl_det', 'licl_det_sign_date', 'Sign Date:', 'Sign Date:', 'Sign Date:', 'Sign Date', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_varchar1'			
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, 'licl_det', 'licl_det_varchar1', 'Varchar1:', 'Varchar1:', 'Varchar1:', 'Varchar1', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_varchar2'			
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, 'licl_det', 'licl_det_varchar2', 'Varchar2:', 'Varchar2:', 'Varchar2:', 'Varchar2', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_varchar3'			
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, 'licl_det', 'licl_det_varchar3', 'Varchar3:', 'Varchar3:', 'Varchar3:', 'Varchar3', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_varchar4'			
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, 'licl_det', 'licl_det_varchar4', 'Varchar4:', 'Varchar4:', 'Varchar4:', 'Varchar4', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_varchar5'			
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, 'licl_det', 'licl_det_varchar5', 'Varchar5:', 'Varchar5:', 'Varchar5:', 'Varchar5', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_datetime1'			
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, 'licl_det', 'licl_det_datetime1', 'Datetime1:', 'Datetime1:', 'Datetime1:', 'Datetime1', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_datetime2'			
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, 'licl_det', 'licl_det_datetime2', 'Datetime2:', 'Datetime2:', 'Datetime2:', 'Datetime2', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_datetime3'			
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, 'licl_det', 'licl_det_datetime3', 'Datetime3:', 'Datetime3:', 'Datetime3:', 'Datetime3', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_datetime4'			
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, 'licl_det', 'licl_det_datetime4', 'Datetime4:', 'Datetime4:', 'Datetime4:', 'Datetime4', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_datetime5'			
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, 'licl_det', 'licl_det_datetime5', 'Datetime5:', 'Datetime5:', 'Datetime5:', 'Datetime5', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_numeric1'			
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, 'licl_det', 'licl_det_numeric1', 'Numeric1:', 'Numeric1:', 'Numeric1:', 'Numeric1', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_numeric2'			
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, 'licl_det', 'licl_det_numeric2', 'Numeric2:', 'Numeric2:', 'Numeric2:', 'Numeric2', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_numeric3'			
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, 'licl_det', 'licl_det_numeric3', 'Numeric3:', 'Numeric3:', 'Numeric3:', 'Numeric3', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_numeric4'			
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, 'licl_det', 'licl_det_numeric4', 'Numeric4:', 'Numeric4:', 'Numeric4:', 'Numeric4', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_det' AND column_name = 'licl_det_numeric5'			
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, 'licl_det', 'licl_det_numeric5', 'Numeric5:', 'Numeric5:', 'Numeric5:', 'Numeric5', '0', '0', 'admin', getdate() FROM cf_language
GO

-- New Linen
CREATE TABLE [dbo].[licl_ls1](
	[site_cd] [varchar](4) NOT NULL,
	[mst_RowID] [numeric](12, 0) NULL,
	[licl_ls1_doc_no] [varchar](11) NULL,
	[licl_ls1_linen] [varchar](50) NULL,
	[licl_ls1_qty] [numeric](21, 4) NULL,
	[licl_ls1_remark] [varchar](255) NULL,
	[licl_ls1_varchar1] [varchar](100) NULL,
	[licl_ls1_varchar2] [varchar](100) NULL,
	[licl_ls1_varchar3] [varchar](100) NULL,
	[licl_ls1_varchar4] [varchar](100) NULL,
	[licl_ls1_varchar5] [varchar](100) NULL,
	[licl_ls1_numeric1] [numeric](21, 4) NULL,
	[licl_ls1_numeric2] [numeric](21, 4) NULL,
	[licl_ls1_numeric3] [numeric](21, 4) NULL,
	[licl_ls1_numeric4] [numeric](21, 4) NULL,
	[licl_ls1_numeric5] [numeric](21, 4) NULL,
	[licl_ls1_datetime1] [datetime] NULL,
	[licl_ls1_datetime2] [datetime] NULL,
	[licl_ls1_datetime3] [datetime] NULL,
	[licl_ls1_datetime4] [datetime] NULL,
	[licl_ls1_datetime5] [datetime] NULL,
	[audit_user] [varchar](50) NULL,
	[audit_date] [datetime] NOT NULL,
	[mbl_audit_user] [varchar](50) NULL,
	[mbl_audit_date] [datetime] 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 from cf_label where table_name = 'licl_ls1' AND column_name = 'licl_ls1_doc_no'			
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, 'licl_ls1', 'licl_ls1_doc_no', 'Document Number:', 'Document Number:', 'Document Number:', 'Document Number', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls1' AND column_name = 'licl_ls1_linen'			
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, 'licl_ls1', 'licl_ls1_linen', 'Linen:', 'Linen:', 'Linen:', 'Linen', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls1' AND column_name = 'licl_ls1_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, 'licl_ls1', 'licl_ls1_qty', 'Quantity:', 'Quantity:', 'Quantity:', 'Quantity', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls1' AND column_name = 'licl_ls1_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, 'licl_ls1', 'licl_ls1_remark', 'Remark:', 'Remark:', 'Remark:', 'Remark', '0', '0', 'admin', getdate() FROM cf_language
GO

-- CCLS Count
CREATE TABLE [dbo].[licl_ls3](
	[site_cd] [varchar](4) NOT NULL,
	[mst_RowID] [numeric](12, 0) NULL,
	[licl_ls3_doc_no] [varchar](11) NULL,
	[licl_ls3_department] [varchar](50) NULL,
	[licl_ls3_linen] [varchar](50) NULL,
	[licl_ls3_qty] [numeric](21, 4) NULL,
	[licl_ls3_remark] [varchar](255) NULL,
	[licl_ls3_varchar1] [varchar](100) NULL,
	[licl_ls3_varchar2] [varchar](100) NULL,
	[licl_ls3_varchar3] [varchar](100) NULL,
	[licl_ls3_varchar4] [varchar](100) NULL,
	[licl_ls3_varchar5] [varchar](100) NULL,
	[licl_ls3_numeric1] [numeric](21, 4) NULL,
	[licl_ls3_numeric2] [numeric](21, 4) NULL,
	[licl_ls3_numeric3] [numeric](21, 4) NULL,
	[licl_ls3_numeric4] [numeric](21, 4) NULL,
	[licl_ls3_numeric5] [numeric](21, 4) NULL,
	[licl_ls3_datetime1] [datetime] NULL,
	[licl_ls3_datetime2] [datetime] NULL,
	[licl_ls3_datetime3] [datetime] NULL,
	[licl_ls3_datetime4] [datetime] NULL,
	[licl_ls3_datetime5] [datetime] NULL,
	[audit_user] [varchar](50) NULL,
	[audit_date] [datetime] NOT NULL,
	[mbl_audit_user] [varchar](50) NULL,
	[mbl_audit_date] [datetime] 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 from cf_label where table_name = 'licl_ls3' AND column_name = 'licl_ls3_doc_no'			
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, 'licl_ls3', 'licl_ls3_doc_no', 'Document Number:', 'Document Number:', 'Document Number:', 'Document Number', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls3' AND column_name = 'licl_ls3_department'			
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, 'licl_ls3', 'licl_ls3_department', 'Department:', 'Department:', 'Department:', 'Department', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls3' AND column_name = 'licl_ls3_linen'			
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, 'licl_ls3', 'licl_ls3_linen', 'Linen:', 'Linen:', 'Linen:', 'Linen', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls3' AND column_name = 'licl_ls3_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, 'licl_ls3', 'licl_ls3_qty', 'Quantity:', 'Quantity:', 'Quantity:', 'Quantity', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls3' AND column_name = 'licl_ls3_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, 'licl_ls3', 'licl_ls3_remark', 'Remark:', 'Remark:', 'Remark:', 'Remark', '0', '0', 'admin', getdate() FROM cf_language
GO

-- IN USE Count
CREATE TABLE [dbo].[licl_ls4](
	[site_cd] [varchar](4) NOT NULL,
	[mst_RowID] [numeric](12, 0) NULL,
	[licl_ls4_doc_no] [varchar](11) NULL,
	[licl_ls4_department] [varchar](50) NULL,
	[licl_ls4_linen] [varchar](50) NULL,
	[licl_ls4_qty] [numeric](21, 4) NULL,
	[licl_ls4_remark] [varchar](255) NULL,
	[licl_ls4_varchar1] [varchar](100) NULL,
	[licl_ls4_varchar2] [varchar](100) NULL,
	[licl_ls4_varchar3] [varchar](100) NULL,
	[licl_ls4_varchar4] [varchar](100) NULL,
	[licl_ls4_varchar5] [varchar](100) NULL,
	[licl_ls4_numeric1] [numeric](21, 4) NULL,
	[licl_ls4_numeric2] [numeric](21, 4) NULL,
	[licl_ls4_numeric3] [numeric](21, 4) NULL,
	[licl_ls4_numeric4] [numeric](21, 4) NULL,
	[licl_ls4_numeric5] [numeric](21, 4) NULL,
	[licl_ls4_datetime1] [datetime] NULL,
	[licl_ls4_datetime2] [datetime] NULL,
	[licl_ls4_datetime3] [datetime] NULL,
	[licl_ls4_datetime4] [datetime] NULL,
	[licl_ls4_datetime5] [datetime] NULL,
	[audit_user] [varchar](50) NULL,
	[audit_date] [datetime] NOT NULL,
	[mbl_audit_user] [varchar](50) NULL,
	[mbl_audit_date] [datetime] 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 from cf_label where table_name = 'licl_ls4' AND column_name = 'licl_ls4_doc_no'			
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, 'licl_ls4', 'licl_ls4_doc_no', 'Document Number:', 'Document Number:', 'Document Number:', 'Document Number', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls4' AND column_name = 'licl_ls4_department'			
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, 'licl_ls4', 'licl_ls4_department', 'Department:', 'Department:', 'Department:', 'Department', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls4' AND column_name = 'licl_ls4_linen'			
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, 'licl_ls4', 'licl_ls4_linen', 'Linen:', 'Linen:', 'Linen:', 'Linen', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls4' AND column_name = 'licl_ls4_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, 'licl_ls4', 'licl_ls4_qty', 'Quantity:', 'Quantity:', 'Quantity:', 'Quantity', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls4' AND column_name = 'licl_ls4_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, 'licl_ls4', 'licl_ls4_remark', 'Remark:', 'Remark:', 'Remark:', 'Remark', '0', '0', 'admin', getdate() FROM cf_language
GO


-- USE STORE Count
CREATE TABLE [dbo].[licl_ls5](
	[site_cd] [varchar](4) NOT NULL,
	[mst_RowID] [numeric](12, 0) NULL,
	[licl_ls5_doc_no] [varchar](11) NULL,
	[licl_ls5_department] [varchar](50) NULL,
	[licl_ls5_linen] [varchar](50) NULL,
	[licl_ls5_qty] [numeric](21, 4) NULL,
	[licl_ls5_remark] [varchar](255) NULL,
	[licl_ls5_varchar1] [varchar](100) NULL,
	[licl_ls5_varchar2] [varchar](100) NULL,
	[licl_ls5_varchar3] [varchar](100) NULL,
	[licl_ls5_varchar4] [varchar](100) NULL,
	[licl_ls5_varchar5] [varchar](100) NULL,
	[licl_ls5_numeric1] [numeric](21, 4) NULL,
	[licl_ls5_numeric2] [numeric](21, 4) NULL,
	[licl_ls5_numeric3] [numeric](21, 4) NULL,
	[licl_ls5_numeric4] [numeric](21, 4) NULL,
	[licl_ls5_numeric5] [numeric](21, 4) NULL,
	[licl_ls5_datetime1] [datetime] NULL,
	[licl_ls5_datetime2] [datetime] NULL,
	[licl_ls5_datetime3] [datetime] NULL,
	[licl_ls5_datetime4] [datetime] NULL,
	[licl_ls5_datetime5] [datetime] NULL,
	[audit_user] [varchar](50) NULL,
	[audit_date] [datetime] NOT NULL,
	[mbl_audit_user] [varchar](50) NULL,
	[mbl_audit_date] [datetime] 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 from cf_label where table_name = 'licl_ls5' AND column_name = 'licl_ls5_doc_no'			
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, 'licl_ls5', 'licl_ls5_doc_no', 'Document Number:', 'Document Number:', 'Document Number:', 'Document Number', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls5' AND column_name = 'licl_ls5_department'			
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, 'licl_ls5', 'licl_ls5_department', 'Department:', 'Department:', 'Department:', 'Department', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls5' AND column_name = 'licl_ls5_linen'			
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, 'licl_ls5', 'licl_ls5_linen', 'Linen:', 'Linen:', 'Linen:', 'Linen', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls5' AND column_name = 'licl_ls5_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, 'licl_ls5', 'licl_ls5_qty', 'Quantity:', 'Quantity:', 'Quantity:', 'Quantity', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls5' AND column_name = 'licl_ls5_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, 'licl_ls5', 'licl_ls5_remark', 'Remark:', 'Remark:', 'Remark:', 'Remark', '0', '0', 'admin', getdate() FROM cf_language
GO


-- Laundry Count
CREATE TABLE [dbo].[licl_ls6](
	[site_cd] [varchar](4) NOT NULL,
	[mst_RowID] [numeric](12, 0) NULL,
	[licl_ls6_doc_no] [varchar](11) NULL,
	[licl_ls6_linen] [varchar](50) NULL,
	[licl_ls6_qty] [numeric](21, 4) NULL,
	[licl_ls6_remark] [varchar](255) NULL,
	[licl_ls6_varchar1] [varchar](100) NULL,
	[licl_ls6_varchar2] [varchar](100) NULL,
	[licl_ls6_varchar3] [varchar](100) NULL,
	[licl_ls6_varchar4] [varchar](100) NULL,
	[licl_ls6_varchar5] [varchar](100) NULL,
	[licl_ls6_numeric1] [numeric](21, 4) NULL,
	[licl_ls6_numeric2] [numeric](21, 4) NULL,
	[licl_ls6_numeric3] [numeric](21, 4) NULL,
	[licl_ls6_numeric4] [numeric](21, 4) NULL,
	[licl_ls6_numeric5] [numeric](21, 4) NULL,
	[licl_ls6_datetime1] [datetime] NULL,
	[licl_ls6_datetime2] [datetime] NULL,
	[licl_ls6_datetime3] [datetime] NULL,
	[licl_ls6_datetime4] [datetime] NULL,
	[licl_ls6_datetime5] [datetime] NULL,
	[audit_user] [varchar](50) NULL,
	[audit_date] [datetime] NOT NULL,
	[mbl_audit_user] [varchar](50) NULL,
	[mbl_audit_date] [datetime] 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 from cf_label where table_name = 'licl_ls6' AND column_name = 'licl_ls6_doc_no'			
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, 'licl_ls6', 'licl_ls6_doc_no', 'Document Number:', 'Document Number:', 'Document Number:', 'Document Number', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls6' AND column_name = 'licl_ls6_linen'			
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, 'licl_ls6', 'licl_ls6_linen', 'Linen:', 'Linen:', 'Linen:', 'Linen', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls6' AND column_name = 'licl_ls6_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, 'licl_ls6', 'licl_ls6_qty', 'Quantity:', 'Quantity:', 'Quantity:', 'Quantity', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls6' AND column_name = 'licl_ls6_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, 'licl_ls6', 'licl_ls6_remark', 'Remark:', 'Remark:', 'Remark:', 'Remark', '0', '0', 'admin', getdate() FROM cf_language
GO


CREATE TABLE [dbo].[licl_ls2](
	[site_cd] [varchar](4) NOT NULL,
	[mst_RowID] [numeric](12, 0) NULL,
	[licl_ls2_varchar1] [varchar](100) NULL,
	[licl_ls2_varchar2] [varchar](100) NULL,
	[licl_ls2_varchar3] [varchar](100) NULL,
	[licl_ls2_varchar4] [varchar](100) NULL,
	[licl_ls2_varchar5] [varchar](100) NULL,
	[licl_ls2_varchar6] [varchar](100) NULL,
	[licl_ls2_varchar7] [varchar](100) NULL,
	[licl_ls2_varchar8] [varchar](100) NULL,
	[licl_ls2_varchar9] [varchar](100) NULL,
	[licl_ls2_varchar10] [varchar](100) NULL,
	[licl_ls2_numeric1] [numeric](21, 4) NULL,
	[licl_ls2_numeric2] [numeric](21, 4) NULL,
	[licl_ls2_numeric3] [numeric](21, 4) NULL,
	[licl_ls2_numeric4] [numeric](21, 4) NULL,
	[licl_ls2_numeric5] [numeric](21, 4) NULL,
	[licl_ls2_numeric6] [numeric](21, 4) NULL,
	[licl_ls2_numeric7] [numeric](21, 4) NULL,
	[licl_ls2_numeric8] [numeric](21, 4) NULL,
	[licl_ls2_numeric9] [numeric](21, 4) NULL,
	[licl_ls2_numeric10] [numeric](21, 4) NULL,
	[licl_ls2_datetime1] [datetime] NULL,
	[licl_ls2_datetime2] [datetime] NULL,
	[licl_ls2_datetime3] [datetime] NULL,
	[licl_ls2_datetime4] [datetime] NULL,
	[licl_ls2_datetime5] [datetime] NULL,
	[licl_ls2_datetime6] [datetime] NULL,
	[licl_ls2_datetime7] [datetime] NULL,
	[licl_ls2_datetime8] [datetime] NULL,
	[licl_ls2_datetime9] [datetime] NULL,
	[licl_ls2_datetime10] [datetime] NULL,
	[audit_user] [varchar](50) NULL,
	[audit_date] [datetime] NOT NULL,
	[mbl_audit_user] [varchar](50) NULL,
	[mbl_audit_date] [datetime] 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 from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_varchar1'			
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, 'licl_ls2', 'licl_ls2_varchar1', 'Varchar1:', 'Varchar1:', 'Varchar1:', 'Varchar1', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_varchar2'			
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, 'licl_ls2', 'licl_ls2_varchar2', 'Varchar2:', 'Varchar2:', 'Varchar2:', 'Varchar2', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_varchar3'			
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, 'licl_ls2', 'licl_ls2_varchar3', 'Varchar3:', 'Varchar3:', 'Varchar3:', 'Varchar3', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_varchar4'			
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, 'licl_ls2', 'licl_ls2_varchar4', 'Varchar4:', 'Varchar4:', 'Varchar4:', 'Varchar4', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_varchar5'			
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, 'licl_ls2', 'licl_ls2_varchar5', 'Varchar5:', 'Varchar5:', 'Varchar5:', 'Varchar5', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_datetime1'			
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, 'licl_ls2', 'licl_ls2_datetime1', 'Datetime1:', 'Datetime1:', 'Datetime1:', 'Datetime1', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_datetime2'			
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, 'licl_ls2', 'licl_ls2_datetime2', 'Datetime2:', 'Datetime2:', 'Datetime2:', 'Datetime2', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_datetime3'			
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, 'licl_ls2', 'licl_ls2_datetime3', 'Datetime3:', 'Datetime3:', 'Datetime3:', 'Datetime3', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_datetime4'			
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, 'licl_ls2', 'licl_ls2_datetime4', 'Datetime4:', 'Datetime4:', 'Datetime4:', 'Datetime4', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_datetime5'			
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, 'licl_ls2', 'licl_ls2_datetime5', 'Datetime5:', 'Datetime5:', 'Datetime5:', 'Datetime5', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_numeric1'			
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, 'licl_ls2', 'licl_ls2_numeric1', 'Numeric1:', 'Numeric1:', 'Numeric1:', 'Numeric1', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_numeric2'			
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, 'licl_ls2', 'licl_ls2_numeric2', 'Numeric2:', 'Numeric2:', 'Numeric2:', 'Numeric2', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_numeric3'			
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, 'licl_ls2', 'licl_ls2_numeric3', 'Numeric3:', 'Numeric3:', 'Numeric3:', 'Numeric3', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_numeric4'			
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, 'licl_ls2', 'licl_ls2_numeric4', 'Numeric4:', 'Numeric4:', 'Numeric4:', 'Numeric4', '0', '0', 'admin', getdate() FROM cf_language
GO
Delete from cf_label where table_name = 'licl_ls2' AND column_name = 'licl_ls2_numeric5'			
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, 'licl_ls2', 'licl_ls2_numeric5', 'Numeric5:', 'Numeric5:', 'Numeric5:', 'Numeric5', '0', '0', 'admin', getdate() FROM cf_language
GO

CREATE TABLE [dbo].[licl_ref](
	[site_cd] [varchar](4) NOT NULL,
	[mst_RowID] [numeric](12, 0) NULL,
	[file_name] [varchar](200) NULL,
	[type] [varchar](10) NULL,
	[status] [varchar](10) NULL,
	[attachment] [image] NULL,
	[category] [varchar](30) NULL,
	[audit_user] [varchar](50) NULL,
	[audit_date] [datetime] NOT NULL,
	[mbl_audit_user] [varchar](50) NULL,
	[mbl_audit_date] [datetime] 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] TEXTIMAGE_ON [PRIMARY]
GO
