/*発注タイプ*/
UPDATE master_app_production.code_masters set disp_name="有効期限延長", j_name="有効期限延長",disp_sort=16 where id=99;
UPDATE master_app_production.code_masters set disp_sort=15 where id=267;

/*在庫預りを上に*/
UPDATE master_app_production.code_masters set disp_sort=5 where id=268;
UPDATE master_app_production.code_masters set disp_name="有効期限延長出庫", j_name="有効期限延長出庫",disp_sort=6 where id=104;
INSERT INTO master_app_production.code_masters SET code_type_id=22, code_number=7, disp_name="有効期限延長入庫", disp_sort=7, j_name="有効期限延長入庫", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();

INSERT INTO master_app_production.code_masters SET code_type_id=21, code_number=17, disp_name="加工出庫", disp_sort=17, j_name="加工出庫", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();
INSERT INTO master_app_production.code_masters SET code_type_id=21, code_number=18, disp_name="加工仕入", disp_sort=18, j_name="加工仕入", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();
INSERT INTO master_app_production.code_masters SET code_type_id=22, code_number=8, disp_name="加工出庫", disp_sort=8, j_name="加工出庫", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();
INSERT INTO master_app_production.code_masters SET code_type_id=22, code_number=9, disp_name="加工仕入", disp_sort=9, j_name="加工仕入", invalid_flag_code=0, created_at=NOW(), updated_at=NOW();

/*orbusneich固有*/
UPDATE purchases set purchase_type_code=7 where purchase_type_code=5 and sign_type_code=1;

