joyce.lee@hkthewell.com JL112299 VDBXvlm786#@343#M frankie.wong@hkthewell.com FW133331 frank.leung@ms.hkthewell.com R24061305408990 Leosamu1825 F345979015840 90347 http://172.16.100.21:8081/ aa https://codepen.io/vaskopetrov/pen/yVEXjz https://vos.vlmbd.com/format/deptrequisn/returns/NO23101190 B@ngladesh321 Baf54513 bi10@ms.hkthewell.com SHOW FULL PROCESSLIST; kill USER vlmbd; mch.fpjoypurhat@gmail.com HDGD^%$ert666 Gacutil -i C:\Users\pc\Downloads\Mysqldata.dll composer global require "laravel/installer=~1.1" composer create-project laravel/laravel laravelapp exec GetCheckInOutData '2024-02-25','2024-02-27','%' PI NUMBER:: NO24061407P Dear Sir, Good morning! Please see the attached information, this PI qty will mention BD and purchase qty will be 0. Please know and update it accordingly. Thank you! ALTER TABLE [BD_PMO_2020] ADD SampleQty int NOT NULL DEFAULT(0); DROP TABLE tbl_enquery_letter; CREATE TABLE [dbo].[tbl_enquery_letter]( [id] [bigint] IDENTITY(1,1) NOT NULL, [status] [nvarchar](50) NULL, enquery_no [nvarchar](50) NULL, [showcase_no] [nvarchar](50) NULL, [complain_no] [nvarchar](50) NULL, [date] [nvarchar](50) NULL, [emp_code] [nvarchar](50) NULL, [emp_name] [nvarchar](250) NULL, [Position_name] [nvarchar](250) NULL, [section] [nvarchar](250) NULL, [floor] [nvarchar](50) NULL, [line_no] [nvarchar](50) NULL, [subject] [nvarchar](350) NULL, [body_content] nvarchar(4000) NULL, [committeeid1] [nvarchar](20) NULL, [committeeid2] [nvarchar](20) NULL, [committeeid3] [nvarchar](20) NULL, [committeeid4] [nvarchar](20) NULL, [committeename1] [nvarchar](20) NULL, [committeename2] [nvarchar](20) NULL, [committeename3] [nvarchar](20) NULL, [committeename4] [nvarchar](20) NULL, attachment [nvarchar](250) NULL, attachment2 [nvarchar](250) NULL, attachment3 [nvarchar](250) NULL, [create_date] [nvarchar](20) NULL, [create_byid] [nvarchar](20) NULL, [create_by] [nvarchar](100) NULL, [hod_byid] [nvarchar](20) NULL, [hod_by] [nvarchar](100) NULL, [hod_date] [nvarchar](20) NULL, [received_by] [nvarchar](100) NULL, [received_date] [nvarchar](20) NULL, [enquery_date] [nvarchar](20) NULL, [completed_status] [nvarchar](100) NULL, [completed_date] [nvarchar](30) NULL, [completed_note] [nvarchar](1000) NULL, [time_create] [datetime] NULL, [time_update] [datetime] NULL, [plant_code] [nvarchar](50) NULL, ); DROP TABLE tbl_commitee_request_letter; CREATE TABLE [dbo].[tbl_commitee_request_letter]( [id] [bigint] IDENTITY(1,1) NOT NULL, [status] [nvarchar](50) NULL, request_no [nvarchar](50) NULL, [showcase_no] [nvarchar](50) NULL, [complain_no] [nvarchar](50) NULL, [date] [nvarchar](50) NULL, [emp_code] [nvarchar](50) NULL, [emp_name] [nvarchar](250) NULL, [Position_name] [nvarchar](250) NULL, [section] [nvarchar](250) NULL, [floor] [nvarchar](50) NULL, [line_no] [nvarchar](50) NULL, [subject] [nvarchar](350) NULL, [body_content] nvarchar(4000) NULL, [request_date] [nvarchar](20) NULL, attachment [nvarchar](250) NULL, [create_date] [nvarchar](20) NULL, [create_byid] [nvarchar](20) NULL, [create_by] [nvarchar](100) NULL, [hod_byid] [nvarchar](20) NULL, [hod_by] [nvarchar](100) NULL, [hod_date] [nvarchar](20) NULL, [received_by] [nvarchar](100) NULL, [received_date] [nvarchar](20) NULL, [completed_status] [nvarchar](100) NULL, [completed_date] [nvarchar](30) NULL, [completed_note] [nvarchar](1000) NULL, [time_create] [datetime] NULL, [time_update] [datetime] NULL, [plant_code] [nvarchar](50) NULL, ); DROP TABLE tbl_decision_letter; CREATE TABLE [dbo].[tbl_decision_letter]( [id] [bigint] IDENTITY(1,1) NOT NULL, [status] [nvarchar](50) NULL, decision_no [nvarchar](50) NULL, enquery_no [nvarchar](50) NULL, [showcase_no] [nvarchar](50) NULL, [complain_no] [nvarchar](50) NULL, [action_type] [nvarchar](50) NULL, [case_completion_date] [nvarchar](20) NULL, [case_status] [nvarchar](30) NULL, [date] [nvarchar](50) NULL, [emp_code] [nvarchar](50) NULL, [emp_name] [nvarchar](250) NULL, [Position_name] [nvarchar](250) NULL, [section] [nvarchar](250) NULL, [floor] [nvarchar](50) NULL, [line_no] [nvarchar](50) NULL, [subject] [nvarchar](350) NULL, [body_content] nvarchar(4000) NULL, attachment [nvarchar](250) NULL, attachment2 [nvarchar](250) NULL, attachment3 [nvarchar](250) NULL, [create_date] [nvarchar](20) NULL, [create_byid] [nvarchar](20) NULL, [create_by] [nvarchar](100) NULL, [hod_byid] [nvarchar](20) NULL, [hod_by] [nvarchar](100) NULL, [hod_date] [nvarchar](20) NULL, [received_by] [nvarchar](100) NULL, [received_date] [nvarchar](20) NULL, [completed_status] [nvarchar](100) NULL, [completed_date] [nvarchar](30) NULL, [completed_note] [nvarchar](1000) NULL, [time_create] [datetime] NULL, [time_update] [datetime] NULL, [plant_code] [nvarchar](50) NULL, ); DROP TABLE tbl_complain_letter; CREATE TABLE [dbo].[tbl_complain_letter]( [id] [bigint] IDENTITY(1,1) NOT NULL, [status] [nvarchar](50) NULL, created_dept [nvarchar](50) NULL, received_dept [nvarchar](50) NULL, [complain_no] [nvarchar](50) NULL, [comp_for] int NULL, [comp_type] int NULL, [subject] [nvarchar](350) NULL, [emp_code] [nvarchar](50) NULL, [emp_name] [nvarchar](250) NULL, [Position_name] [nvarchar](250) NULL, [section] [nvarchar](250) NULL, [date] [nvarchar](50) NULL, [body_content] nvarchar(4000) NULL, [complainer_id] [nvarchar](20) NULL, [complainer_name] [nvarchar](200) NULL, [complain_date] [nvarchar](20) NULL, attachment [nvarchar](250) NULL, [create_date] [nvarchar](20) NULL, [create_byid] [nvarchar](20) NULL, [create_by] [nvarchar](100) NULL, [hod_byid] [nvarchar](20) NULL, [hod_by] [nvarchar](100) NULL, [hod_date] [nvarchar](20) NULL, [divhod_by] [nvarchar](100) NULL, [divhod_date] [nvarchar](20) NULL, [hcm_no] [nvarchar](30) NULL, [hcm_by] [nvarchar](100) NULL, [hcm_date] [nvarchar](20) NULL, [completed_status] [nvarchar](100) NULL, [completed_date] [nvarchar](30) NULL, [completed_note] [nvarchar](1000) NULL, [time_create] [datetime] NULL, [time_update] [datetime] NULL, [plant_code] [nvarchar](50) NULL, ); DROP TABLE tbl_showcase_letter; CREATE TABLE [dbo].[tbl_showcase_letter]( [id] [bigint] IDENTITY(1,1) NOT NULL, [status] [nvarchar](50) NULL, [showcase_no] [nvarchar](50) NULL, [complain_no] [nvarchar](50) NULL, [date] [nvarchar](50) NULL, [emp_code] [nvarchar](50) NULL, [emp_name] [nvarchar](250) NULL, [Position_name] [nvarchar](250) NULL, [section] [nvarchar](250) NULL, [floor] [nvarchar](50) NULL, [line_no] [nvarchar](50) NULL, [subject] [nvarchar](350) NULL, [body_content] nvarchar(4000) NULL, [showcaser_id] [nvarchar](20) NULL, [showcaser_name] [nvarchar](200) NULL, [showcase_date] [nvarchar](20) NULL, [showcase1_date] [nvarchar](20) NULL, [showcase2_date] [nvarchar](20) NULL, [showcase3_date] [nvarchar](20) NULL, attachment [nvarchar](250) NULL, attachment2 [nvarchar](250) NULL, attachment3 [nvarchar](250) NULL, [create_date] [nvarchar](20) NULL, [create_byid] [nvarchar](20) NULL, [create_by] [nvarchar](100) NULL, [hod_byid] [nvarchar](20) NULL, [hod_by] [nvarchar](100) NULL, [hod_date] [nvarchar](20) NULL, [received_by] [nvarchar](100) NULL, [received_date] [nvarchar](20) NULL, suspension_date [nvarchar](20) NULL, [completed_status] [nvarchar](100) NULL, [completed_date] [nvarchar](30) NULL, [completed_note] [nvarchar](1000) NULL, [time_create] [datetime] NULL, [time_update] [datetime] NULL, [plant_code] [nvarchar](50) NULL, ); CREATE TABLE finish_goods_handover( id [uniqueidentifier] NOT NULL, [serial_no] [varchar](50) NOT NULL, [department_id] [int] NULL, [date] [date] NULL, this_status INT, [pmo] [int] NOT NULL, [file_no] [nvarchar](100) NOT NULL, [style_no] [nvarchar](100) NOT NULL, [color_code] [nvarchar](100) NOT NULL, [color_name] [nvarchar](100) NOT NULL, [customer_style] [nvarchar](100) NOT NULL, [line] [nvarchar](50) NULL, [floor] [nvarchar](50) NULL, [ctn_number_from] [nvarchar](50) NOT NULL, [ctn_number_to] [nvarchar](50) NOT NULL, [PO_NUMBER] [nvarchar](50) NOT NULL, [location] [nvarchar](50) NULL, [ttl_ctns] [nvarchar](50) NULL, [bag_qty] [nvarchar](50) NULL, [wh_in_date] [nvarchar](50) NULL, [creator_id] [int] NULL, [creator_name] [varchar](50) NULL, [created_date] [date] NULL, [approved_by] [int] NULL, [approved_name] [varchar](50) NULL, [approved_date] [nvarchar](25) NULL, [received_by] [int] NULL, [received_name] [varchar](50) NULL, [received_date] [nvarchar](25) NULL, [create_datetime] [varchar](50) NULL, [update_datetime] [varchar](50) NULL ); ALTER TABLE [dbo].[finish_goods_handover] ADD DEFAULT (newid()) FOR [id] DROP TABLE tbl_pension_scheme_survey; CREATE TABLE tbl_pension_scheme_survey( [id] [bigint] IDENTITY(1,1) NOT NULL, emp_code nvarchar(20) NULL, emp_name nvarchar(150) NULL, response nvarchar(200) NULL, dept_name nvarchar(150) NULL, cposition_name nvarchar(150) NULL, consent_and_authorize nvarchar(100) NULL, start_date nvarchar(20) NULL, amount nvarchar(10) NULL, notes nvarchar(1000) NULL, create_by [nvarchar](100) NULL, status [nvarchar](20) NULL, received_by [nvarchar](100) NULL, time_create [datetime] NULL, time_update [datetime] NULL, plant_code [nvarchar](50) NULL ); CREATE TABLE reward_position_percent( [id] [bigint] IDENTITY(1,1) NOT NULL, years nvarchar(20) NULL, position nvarchar(20) NULL, position_name nvarchar(150) NULL, abudget_per nvarchar(20) NULL, create_by [nvarchar](100) NULL, time_create [datetime] NULL, time_update [datetime] NULL, plant_code [nvarchar](50) NULL ); CREATE TABLE reward_position_percent( [id] [bigint] IDENTITY(1,1) NOT NULL, years nvarchar(20) NULL, position nvarchar(100) NULL, position_name nvarchar(150) NULL, abudget_per nvarchar(20) NULL, create_by [nvarchar](100) NULL, time_create [datetime] NULL, time_update [datetime] NULL, plant_code [nvarchar](50) NULL ); CREATE TABLE reward_project_amount( [id] [bigint] IDENTITY(1,1) NOT NULL, years nvarchar(20) NULL, totalbudget nvarchar(20) NULL, totalbudget_per nvarchar(20) NULL, create_by [nvarchar](100) NULL, time_create [datetime] NULL, time_update [datetime] NULL, plant_code [nvarchar](50) NULL ); DROP TABLE reward_project_budget; CREATE TABLE reward_project_budget( [id] [bigint] IDENTITY(1,1) NOT NULL, years nvarchar(20) NULL, project_name nvarchar(350) NULL, budget nvarchar(20) NULL, budget_per nvarchar(20) NULL, prank nvarchar(20) NULL, project_leader nvarchar(100) NULL, remarks nvarchar(500) NULL, create_by [nvarchar](100) NULL, update_by [nvarchar](100) NULL, time_create [datetime] NULL, time_update [datetime] NULL, plant_code [nvarchar](50) NULL ); DROP TABLE reward_department_amount; CREATE TABLE reward_department_amount( [id] [bigint] IDENTITY(1,1) NOT NULL, years nvarchar(20) NULL, dept_code nvarchar(20) NULL, dept_name nvarchar(20) NULL, first_budget DECIMAL(11) DEFAULT '0', second_budget DECIMAL(11) DEFAULT '0', third_budget DECIMAL(11) DEFAULT '0', four_budget DECIMAL(11) DEFAULT '0', five_budget DECIMAL(11) DEFAULT '0', six_budget DECIMAL(11) DEFAULT '0', seven_budget DECIMAL(11) DEFAULT '0', eight_budget DECIMAL(11) DEFAULT '0', nine_budget DECIMAL(11) DEFAULT '0', ten_budget DECIMAL(11) DEFAULT '0', first_per DECIMAL(11,2) DEFAULT '0', second_per DECIMAL(11,2) DEFAULT '0', third_per DECIMAL(11,2) DEFAULT '0', four_per DECIMAL(11,2) DEFAULT '0', five_per DECIMAL(11,2) DEFAULT '0', six_per DECIMAL(11,2) DEFAULT '0', seven_per DECIMAL(11,2) DEFAULT '0', eight_per DECIMAL(11,2) DEFAULT '0', nine_per DECIMAL(11,2) DEFAULT '0', ten_per DECIMAL(11,2) DEFAULT '0', bbudget_per DECIMAL(11) DEFAULT '0', bbudget_amount DECIMAL(11) DEFAULT '0', remarks nvarchar(500) NULL, create_by [nvarchar](100) NULL, update_by [nvarchar](100) NULL, time_create [datetime] NULL, time_update [datetime] NULL, plant_code [nvarchar](50) NULL ); CREATE TABLE reward_previous_history( [id] [bigint] IDENTITY(1,1) NOT NULL, emp_code nvarchar(20) NULL, years nvarchar(20) NULL, reward_amount nvarchar(20) NULL, reward_per nvarchar(20) NULL, create_by [nvarchar](100) NULL, time_create [datetime] NULL, time_update [datetime] NULL, plant_code [nvarchar](50) NULL ); DROP TABLE reward_master_table; CREATE TABLE reward_master_table( [id] [bigint] IDENTITY(1,1) NOT NULL, this_status int NOT NULL DEFAULT '1', a_status int NOT NULL DEFAULT '1', b_status int NOT NULL DEFAULT '1', emp_code nvarchar(20) NULL, emp_name nvarchar(200) NULL, years nvarchar(20) NULL, designation nvarchar(150) NULL, emp_category nvarchar(150) NULL, dept_code nvarchar(20) NULL, dept_name nvarchar(150) NULL, div_code nvarchar(20) NULL, div_name nvarchar(150) NULL, floor nvarchar(150) NULL, join_date nvarchar(20) NULL, april_basic nvarchar(20) NULL, april_gross nvarchar(20) NULL, present_basic nvarchar(20) NULL, present_gross nvarchar(20) NULL, budget nvarchar(20) NULL, budget_a nvarchar(20) NULL, budget_a_stry_div nvarchar(20) NULL, hod_budget_a_amount nvarchar(20) NULL, hod_budget_a_per nvarchar(20) NULL, hod_budget_b_amount nvarchar(20) NULL, hod_budget_b_per nvarchar(20) NULL, dih_budget_a_amount nvarchar(20) NULL, dih_budget_a_per nvarchar(20) NULL, dih_budget_b_amount nvarchar(20) NULL, dih_budget_b_per nvarchar(20) NULL, dih_budget_c_amount nvarchar(20) NULL, dih_budget_c_per nvarchar(20) NULL, hcm_budget_a_amount nvarchar(20) NULL, hcm_budget_b_amount nvarchar(20) NULL, hcm_budget_c_amount nvarchar(20) NULL, coo_budget_a_amount nvarchar(20) NULL, coo_budget_a_per nvarchar(20) NULL, coo_budget_b_amount nvarchar(20) NULL, coo_budget_b_per nvarchar(20) NULL, coo_budget_c_amount nvarchar(20) NULL, total_abc_amount nvarchar(20) NULL, total_abc_per nvarchar(20) NULL, warning_no int NOT NULL DEFAULT '0', warning_deduction_amount nvarchar(20) NULL, net_pay_amount nvarchar(20) NULL, net_pay_amount_per nvarchar(20) NULL, net_pay_amount_hidden nvarchar(20) NULL, coo_reserve_amount nvarchar(20) NULL, remarks nvarchar(200) NULL, div_emp_code nvarchar(20) NULL, hod_emp_code nvarchar(20) NULL, hod_by [nvarchar](100) NULL, hod_by_date [nvarchar](20) NULL, hod_submit_date [nvarchar](20) NULL, div_by [nvarchar](100) NULL, div_by_date [nvarchar](20) NULL, div_submit_date [nvarchar](20) NULL, hcm_by [nvarchar](100) NULL, hcm_by_date [nvarchar](20) NULL, hcm_submit_date [nvarchar](20) NULL, coo_by [nvarchar](100) NULL, coo_by_date [nvarchar](20) NULL, coo_final_date [nvarchar](20) NULL, create_by [nvarchar](100) NULL, time_create [datetime] NULL, time_update [datetime] NULL, hcm_update_time NVARCHAR(50), hcm_submit_time NVARCHAR(50), hod_update_time NVARCHAR(50), div_update_time NVARCHAR(50), coo_update_time NVARCHAR(50), plant_code [nvarchar](50) NULL ); CREATE TABLE reward_previou_table( [id] [bigint] IDENTITY(1,1) NOT NULL, this_status int NOT NULL DEFAULT '5', emp_code nvarchar(20) NULL, emp_name nvarchar(200) NULL, years nvarchar(20) NULL, designation nvarchar(150) NULL, emp_category nvarchar(150) NULL, dept_name nvarchar(150) NULL, div_name nvarchar(150) NULL, net_pay_amount nvarchar(20) NULL, create_by [nvarchar](100) NULL, time_create [datetime] NULL, time_update [datetime] NULL, plant_code [nvarchar](50) NULL ); ALTER TABLE leftover_bag_management ADD Email varchar(255); ALTER TABLE input_hours_employee ADD sub_section varchar(255); ALTER TABLE [material_return_info] ADD consumption_rate varchar(20); CREATE TABLE [dbo].[leftover_bag_management]( [id] [bigint] IDENTITY(1,1) NOT NULL, [serial_no] [varchar](50) NOT NULL, [send_serial_no] [varchar](50) NULL, [department_id] [int] NULL, [add_department_id] [int] NULL, [send_department_id] [int] NULL, [item_type] [varchar](50) NOT NULL, [entry_date] [date] NULL, [first_received_date] [date] NULL, [customer] [nvarchar](100) NULL, [customer_style] [nvarchar](100) NULL, [file_no] [nvarchar](100) NOT NULL, [style_no] [nvarchar](100) NOT NULL, [color_code] [nvarchar](100) NOT NULL, [color_name] [nvarchar](100) NOT NULL, [color_chinese] [nvarchar](100) NOT NULL, [pmo] [int] NULL, [season] [nvarchar](100) NULL, [years] [nvarchar](100) NULL, [test_number] [nvarchar](50) NULL, [sample_category] [nvarchar](100) NULL, [location] [nvarchar](100) NULL, [bag_qty] [int] NULL, [unit_name] [nvarchar](100) NULL, [creator_id] [int] NULL, [creator_name] [varchar](50) NULL, [created_date] [date] NULL, [approved_by] [int] NULL, [approved_name] [varchar](50) NULL, [approved_date] [date] NULL, [received_name] [varchar](50) NULL, [received_date] [date] NULL, [send_date] [date] NULL, [leftover_status] [int] NOT NULL, [image_link] [nvarchar](200) NULL, [diff_notes] [nvarchar](1000) NULL, [create_datetime] [varchar](50) NULL, [update_datetime] [varchar](50) NULL, [approved_status] [int] NULL, [stock_or_not] [int] NULL, [iqc_no] [nvarchar](50) NULL, [group_name] [nvarchar](50) NULL, [style_name] [nvarchar](50) NULL, [type_of_brand] [nvarchar](50) NULL, [material_code] [nvarchar](50) NULL, [material_name] [nvarchar](150) NULL, [expire_date] [nvarchar](20) NULL, [standard_category] [nvarchar](100) NULL, [video_link] [nvarchar](200) NULL, [bag_receive_by] [nvarchar](150) NULL, [standard_approved_by] [nvarchar](150) NULL, PRIMARY KEY CLUSTERED ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] CREATE TABLE [dbo].[BDV_Section_output]( [OptDHUID] [uniqueidentifier] NOT NULL, [AppShtUID] [nvarchar](20) NULL, [FactoryCode] [nvarchar](20) NOT NULL, [OptDate] [date] NULL, [Workshop] [nvarchar](80) NULL, [Line] [nvarchar](80) NULL, [PMONo] [int] NULL, [FileNo] [nvarchar](80) NULL, [StyleNo] [nvarchar](80) NULL, [ColorName] [nvarchar](100) NULL, [LinePlanned] [nvarchar](80) NULL, [cutting_qty] DECIMAL(11,2) NULL, [preas_qty] DECIMAL(11,2) NULL, [gluing_qty] DECIMAL(11,2) NULL, [painting_qty] DECIMAL(11,2) NULL, [QualityGroup] [nvarchar](80) NULL, [DateCreated] [datetime] NULL, [LastModified] [datetime] NULL ); ALTER TABLE [dbo].[BDV_Section_output] ADD DEFAULT (newid()) FOR [OptDHUID] CREATE VIEW [dbo].[vBDV_SectionOutputTTL] AS SELECT [StyleNo], sum([preas_qty]) as "completedqty0",sum([preas_qty]) as "completedqty",sum([gluing_qty]) as "completedqty2",sum([painting_qty]) as "completedqty3" FROM BDV_Section_output group by [StyleNo]; DROP TABLE weigth_confirmation; CREATE TABLE weigth_confirmation( id [uniqueidentifier] NOT NULL, [serial_no] [varchar](50) NOT NULL, [fg_serial_no] [varchar](50) NOT NULL, [department_id] [int] NULL, [date] [date] NULL, this_status INT, [file_no] [nvarchar](100) NOT NULL, [PO_NUMBER] [nvarchar](50) NOT NULL, [style_no] [nvarchar](100) NOT NULL, [color_code] [nvarchar](100) NOT NULL, [color_name] [nvarchar](100) NOT NULL, [floor] [nvarchar](100) NULL, [customer_style] [nvarchar](100) NOT NULL, [qty_per_ctn] [nvarchar](20) NULL, [nw_per_bag] [nvarchar](50) NULL, [gross_weight] [nvarchar](50) NULL, [ctn_number_from] [nvarchar](50) NOT NULL, [ctn_number_to] [nvarchar](50) NOT NULL, [ttl_ctns] [nvarchar](50) NULL, [bag_qty] [nvarchar](50) NULL, [wh_in_date] [nvarchar](50) NULL, [creator_id] [int] NULL, [creator_name] [varchar](50) NULL, [created_date] [date] NULL, [approved_by] [int] NULL, [approved_name] [varchar](50) NULL, [approved_date] [nvarchar](25) NULL, [qa_by] [int] NULL, [qa_name] [varchar](50) NULL, [qa_date] [nvarchar](25) NULL, [create_datetime] [varchar](50) NULL, [update_datetime] [varchar](50) NULL ); ALTER TABLE [dbo].[weigth_confirmation] ADD DEFAULT (newid()) FOR [id] DROP TABLE weigth_confirmation_deatils; CREATE TABLE weigth_confirmation_deatils( id [uniqueidentifier] NOT NULL, [serial_no] [varchar](50) NOT NULL, [department_id] [int] NULL, [date] [date] NULL, this_status INT, [ctn_no] [nvarchar](100) NOT NULL, [invoice_no] [nvarchar](50) NULL, [gross_weight_packing] [nvarchar](40) NOT NULL, [gross_weight_wh] [nvarchar](20) NULL, [remarks] [nvarchar](200) NULL, [creator_id] [int] NULL, [creator_name] [varchar](50) NULL, [created_date] [date] NULL, [create_datetime] [varchar](50) NULL, [update_datetime] [varchar](50) NULL ); ALTER TABLE [dbo].[weigth_confirmation_deatils] ADD DEFAULT (newid()) FOR [id] v_hrInjob ,[cutting_qty] ,[assembly_qty] ,[gluing_qty] ,[painting_qty] ALTER TABLE BDV_Section_output RENAME COLUMN preas_qty to assembly_qty; EXEC sp_rename 'BDV_Section_output.preas_qty', 'assembly_qty', 'COLUMN'; DROP TABLE [dbo].[ot_application] CREATE TABLE [dbo].[ot_application]( [rowids] [bigint] IDENTITY(1,1) NOT NULL, [serial_no] [nvarchar](20) NULL, [department_id] [nvarchar](200) NULL, [floor_name] [nvarchar](50) NULL, [line_no] [nvarchar](30) NULL, [shift] [nvarchar](30) NULL, total_tm int, one_hours int, two_hours int, three_hours int, four_hours int, total_person int, [application_date] [nvarchar](30) NULL, [ot_type] [nvarchar](100) NULL, [ot_reason] [nvarchar](200) NULL, [ot_hours] [nvarchar](200) NULL, [applicant_name] [nvarchar](50) NULL, [approved_bybd] [int] NULL, [approved_bybd_name] [nvarchar](60) NULL, [approved_bd_date] [nvarchar](30) NULL, [approved_by] [int] NULL, [approved_by_name] [nvarchar](30) NULL, [approved_date] [nvarchar](30) NULL, [ie_approval] [nvarchar](60) NULL, [ie_approval_date] [nvarchar](30) NULL, [pc_approval] [nvarchar](60) NULL, [pc_approval_date] [nvarchar](30) NULL, [factory_approval] [nvarchar](60) NULL, [factory_approval_date] [nvarchar](20) NULL, [remarks] [nvarchar](250) NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](30) NULL, [update_by] [varchar](30) NULL, [time_create] [datetime] NULL, [time_update] [datetime] NULL ) ALTER TABLE ot_application ADD return_note varchar(500); ALTER TABLE ot_application ADD pc_ varchar(500); Edge Paint 油边 Edge Paint 油边 24051904363598 DROP TABLE [dbo].[tbl_ipqc_edge_paint_record] CREATE TABLE [dbo].[tbl_ipqc_edge_paint_record]( [rowids] [uniqueidentifier] NOT NULL, [serial_no] [nvarchar](20) NULL, [date] [nvarchar](30) NULL, [PMONo] [nvarchar](50) NULL, [FileNo] [nvarchar](30) NULL, [StyleNo] [nvarchar](30) NULL, [ColorName] [nvarchar](100) NULL, [Workshop] [nvarchar](30) NULL, [Line] [nvarchar](30) NULL, [customer] [nvarchar](30) NULL, [ipqc_id] [nvarchar](15) NULL, [check_type] [nvarchar](100) NULL, [checkqty] int NULL, [passqty] int NULL, [painting] [nvarchar](150) NULL, [paintdefect] [nvarchar](150) NULL, [paintdefectqty] int NULL, [paintdefect2] [nvarchar](150) NULL, [paintdefectqty2] int NULL, [paintdefect3] [nvarchar](150) NULL, [paintdefectqty3] int NULL, [cleaning] [nvarchar](150) NULL, [cleandefect] [nvarchar](150) NULL, [cleandefectqty] int NULL, [cleandefect2] [nvarchar](150) NULL, [cleandefectqty2] int NULL, [cleandefect3] [nvarchar](150) NULL, [cleandefectqty3] int NULL, [stitching] [nvarchar](150) NULL, [stitchdefect] [nvarchar](150) NULL, [stitchdefectqty] int NULL, [stitchdefect2] [nvarchar](150) NULL, [stitchdefectqty2] int NULL, [stitchdefect3] [nvarchar](150) NULL, [stitchdefectqty3] int NULL, [check_by] [nvarchar](60) NULL, [check_date] [nvarchar](30) NULL, [approved_by] [int] NULL, [approved_by_name] [nvarchar](60) NULL, [approved_date] [nvarchar](30) NULL, [check_by2] [nvarchar](60) NULL, [check_date2] [nvarchar](30) NULL, [remarks] [nvarchar](250) NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](30) NULL, [update_by] [varchar](30) NULL, [time_create] [datetime] NULL, [time_update] [datetime] NULL ); 25748 BWSO3194 ALTER TABLE [dbo].[tbl_ipqc_edge_paint_record] ADD DEFAULT (newid()) FOR [rowids] DROP TABLE [dbo].[tbl_color_spray] CREATE TABLE [dbo].[tbl_color_spray]( [rowid] [uniqueidentifier] NOT NULL, [serial_no] [nvarchar](20) NULL, [department_id] [nvarchar](200) NULL, [date] [nvarchar](20) NULL, [shipment_date] [nvarchar](20) NULL, [prepared_by] [nvarchar](50) NULL, [prepared_id] [int] NULL, [prepared_date] [nvarchar](30) NULL, [floor_incharge] [nvarchar](30) NULL, [floor_incharge_date] [nvarchar](30) NULL, [approved_by] [int] NULL, [approved_by_name] [nvarchar](30) NULL, [approved_date] [nvarchar](30) NULL, [cse_approval] [nvarchar](60) NULL, [cse_approval_date] [nvarchar](30) NULL, [quality_approval] [nvarchar](60) NULL, [quality_approval_date] [nvarchar](30) NULL, [merch_approval] [nvarchar](60) NULL, [merch_approval_date] [nvarchar](30) NULL, [remarks] [nvarchar](250) NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](30) NULL, [update_by] [varchar](30) NULL, [time_create] [varchar](30) NULL, [time_update] [varchar](30) NULL ); ALTER TABLE [dbo].[tbl_color_spray] ADD DEFAULT (newid()) FOR [rowid] DROP TABLE [dbo].[tbl_color_spray_detail] CREATE TABLE [dbo].[tbl_color_spray_detail]( [rowids] [uniqueidentifier] NOT NULL, [serial_no] [nvarchar](20) NULL, [date] [nvarchar](20) NULL, [pmo] [nvarchar](15) NULL, [file_no] [nvarchar](30) NULL, [style_no] [nvarchar](30) NULL, [color_name] [nvarchar](150) NULL, [floor_name] [nvarchar](50) NULL, [line_no] [nvarchar](30) NULL, [customer] [nvarchar](30) NULL, [labtest] [nvarchar](50) NULL, [labtest_attach] [nvarchar](150) NULL, [material_code] [nvarchar](150) NULL, [material_name] [nvarchar](250) NULL, [bag_qty] int NULL, [name_of_part] [nvarchar](1000) NULL, [issues] [nvarchar](1000) NULL, [finding_pic] [nvarchar](150) NULL, [improve_pic] [nvarchar](150) NULL, [improve_method] [nvarchar](150) NULL, [chemical1] [nvarchar](500) NULL, [chemical2] [nvarchar](500) NULL, [chemical3] [nvarchar](500) NULL, [chemical4] [nvarchar](500) NULL, [reason] [nvarchar](300) NULL, [remarks] [nvarchar](300) NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](30) NULL, [update_by] [varchar](30) NULL, [time_create] [varchar](30) NULL, [time_update] [varchar](30) NULL ); ALTER TABLE [dbo].[tbl_color_spray_detail] ADD DEFAULT (newid()) FOR [rowids] ALTER TABLE [material_pi_master_merch] ADD return_note varchar(500); DROP TABLE [dbo].[ssixs_audit_schedule] CREATE TABLE [dbo].[ssixs_audit_schedule]( [rowid] [uniqueidentifier] NOT NULL, [serial_no] [nvarchar](20) NULL, [date] [nvarchar](20) NULL, [subzone_name] NVARCHAR(100), [email_address] [nvarchar](100) NULL, [remarks] [nvarchar](250) NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](30) NULL, [update_by] [varchar](30) NULL, [time_create] [varchar](30) NULL, [time_update] [varchar](30) NULL ); ALTER TABLE [dbo].[ssixs_audit_schedule] ADD DEFAULT (newid()) FOR [rowid] ALTER TABLE [material_return_info] ADD order_qty int; DROP TABLE [dbo].[logo_defect] CREATE TABLE [dbo].[logo_defect]( [rowid] [uniqueidentifier] NOT NULL, [defect_name] NVARCHAR(100) ); ALTER TABLE [dbo].[logo_defect] ADD DEFAULT (newid()) FOR [rowid] DROP TABLE [dbo].[tbl_logo_checking] CREATE TABLE [dbo].[tbl_logo_checking]( [rowid] [uniqueidentifier] NOT NULL, [serial_no] [nvarchar](20) NULL, [department_id] [nvarchar](200) NULL, [date] [nvarchar](20) NULL, [shipment_date] [nvarchar](20) NULL, [prepared_id] [int] NULL, [prepared_by] [nvarchar](50) NULL, [prepared_date] [nvarchar](30) NULL, [checked_id] int NULL, [checked_by] [nvarchar](100) NULL, [checked_date] [nvarchar](30) NULL, [approved_id] int NULL, [approved_by] [nvarchar](90) NULL, [approved_date] [nvarchar](30) NULL, [remarks] [nvarchar](250) NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](30) NULL, [update_by] [varchar](30) NULL, [time_create] [varchar](30) NULL, [time_update] [varchar](30) NULL ); ALTER TABLE [dbo].[tbl_logo_checking] ADD DEFAULT (newid()) FOR [rowid] DROP TABLE [dbo].[tbl_logo_checking_detail] CREATE TABLE [dbo].[tbl_logo_checking_detail]( [rowids] [uniqueidentifier] NOT NULL, [serial_no] [nvarchar](20) NULL, [serial_no2] [nvarchar](20) NULL, [date] [nvarchar](20) NULL, [pmo] [nvarchar](15) NULL, [file_no] [nvarchar](30) NULL, [style_no] [nvarchar](30) NULL, [color_name] [nvarchar](150) NULL, [floor_name] [nvarchar](50) NULL, [line_no] [nvarchar](30) NULL, [customer] [nvarchar](30) NULL, [ipqc_id] [nvarchar](15) NULL, [ipqc_name] [nvarchar](150) NULL, [logo_type] [nvarchar](60) NULL, [hours] int NULL, [checked_qty] int NULL, [passqty] int NULL, [defect_qty] int NULL, [remarks] [nvarchar](300) NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](30) NULL, [update_by] [varchar](30) NULL, [time_create] [varchar](30) NULL, [time_update] [varchar](30) NULL ); ALTER TABLE [dbo].[tbl_logo_checking_detail] ADD DEFAULT (newid()) FOR [rowids] DROP TABLE [dbo].[tbl_logo_checking_defect] CREATE TABLE [dbo].[tbl_logo_checking_defect]( [rowids] [uniqueidentifier] NOT NULL, [pmo] [nvarchar](15) NULL, [serial_no] [nvarchar](50) NULL, [serial_no2] [nvarchar](50) NULL, [date] [nvarchar](20) NULL, [defect_name] [nvarchar](200) NULL, [issue_qty] int NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](100) NULL, [update_by] [varchar](100) NULL, [time_create] [varchar](40) NULL, [time_update] [varchar](40) NULL ); ALTER TABLE [dbo].[tbl_logo_checking_defect] ADD DEFAULT (newid()) FOR [rowids] DROP TABLE [dbo].[tbl_pcd_schedule] CREATE TABLE [dbo].[tbl_pcd_schedule]( [rowid] [uniqueidentifier] NOT NULL, [serial_no] [nvarchar](20) NULL, [department_id] [nvarchar](200) NULL, [date] [nvarchar](20) NULL, [shipment_date] [nvarchar](20) NULL, [prepared_id] [int] NULL, [prepared_by] [nvarchar](50) NULL, [prepared_date] [nvarchar](30) NULL, [checked_id] int NULL, [checked_by] [nvarchar](100) NULL, [checked_date] [nvarchar](30) NULL, [approved_id] int NULL, [approved_by] [nvarchar](90) NULL, [approved_date] [nvarchar](30) NULL, [remarks] [nvarchar](250) NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](30) NULL, [update_by] [varchar](30) NULL, [time_create] [varchar](30) NULL, [time_update] [varchar](30) NULL ); ALTER TABLE [dbo].[tbl_pcd_schedule] ADD DEFAULT (newid()) FOR [rowid] DROP TABLE [dbo].[tbl_pcd_schedule_detail] CREATE TABLE [dbo].[tbl_pcd_schedule_detail]( [rowids] [uniqueidentifier] NOT NULL, [serial_no] [nvarchar](20) NULL, [serial_no2] [nvarchar](20) NULL, [date] [nvarchar](20) NULL, [pmo] [nvarchar](15) NULL, [file_no] [nvarchar](30) NULL, [style_no] [nvarchar](30) NULL, [color_name] [nvarchar](150) NULL, [floor_name] [nvarchar](50) NULL, [line_no] [nvarchar](30) NULL, [customer] [nvarchar](30) NULL, [ipqc_id] [nvarchar](15) NULL, [ipqc_name] [nvarchar](150) NULL, [logo_type] [nvarchar](60) NULL, [hours] int NULL, [checked_qty] int NULL, [passqty] int NULL, [defect_qty] int NULL, [remarks] [nvarchar](300) NULL, [status] [int] NULL, [user_id] [int] NULL, [create_by] [varchar](30) NULL, [update_by] [varchar](30) NULL, [time_create] [varchar](30) NULL, [time_update] [varchar](30) NULL ); ALTER TABLE [dbo].[tbl_pcd_schedule_detail] ADD DEFAULT (newid()) FOR [rowids]