Kezdőlap Felfedezés Súgó
Bejelentkezés
libf
/
odbtools
1
0
Másolás 0
Fájlok Problémák 0 Beolvasztási kérések 0 Wiki
Fa: b3c0cac917
Branch-ok Tag-ek
odbtools
/
odbctest
/
mql
/
problem
/
basic
/
local
/
03insert.mql

03insert.mql 10 KB
Előzmények Nyers

1234 
  1. 

  2. insert into /zhongjie_logistics/gdwz_order id='zhongjie_logistics_gdwz_order:1461978352968777728', biz_id='1461978352968777728', creator_id='-1', creator_name='系统管理员', confirm_id=NULL, confirm_name=NULL, create_time='2026-01-17 07:00:02', update_time='2026-01-17 07:00:01', create_year='2026', delete_flag='0', status='0', state='1', cancel_status='1', org_id='90000322566460', basic_project_code='XM00517', basic_project_name='广东电信集约化物流项目', basic_project_id='1187343964416905216', supplier_code=NULL, supplier_name=NULL, type='1', order_type='5', order_type_name='入库需求单', order_attr='BHSJS', order_attr_name='拆旧料退库需求', create_way='0', create_way_name='MSS', logistics_order_type=NULL, logistics_order_type_name=NULL, order_no='XCJ/GDZJ/202601/00326', out_affair_code=NULL, out_affair_name=NULL, out_process=NULL, out_process_name=NULL, entry_affair_code=NULL, entry_affair_name=NULL, entry_process=NULL, entry_process_name=NULL, emergency_degree_code=NULL, emergency_degree_name=NULL, appoint_arrive_time=NULL, deliver_store=NULL, deliver_store_name=NULL, deliver_address=NULL, deliver_person=NULL, deliver_phone=NULL, deliver_area=NULL, deliver_area_name=NULL, deliver_city=NULL, deliver_city_name=NULL, deliver_province=NULL, deliver_province_name=NULL, reciever_store=NULL, reciever_store_name=NULL, reciever_address=NULL, reciever_person=NULL, reciever_phone=NULL, reciever_area=NULL, reciever_area_name=NULL, reciever_city=NULL, reciever_city_name=NULL, reciever_province=NULL, reciever_province_name=NULL, remark='998943899621165381(海安营业厅购销暂存点(回收))', total_qty=NULL, total_gw=NULL, total_vol=NULL, purchase_order_no=NULL, purchase_order_name=NULL, order_create_data=NULL, accept_org=NULL, accept_org_name=NULL, project_code=NULL, project_name=NULL, project_manage_depart='A019', project_manage_depart_name=NULL, purchase_accept_depart='0900003583', purchase_accept_depart_name='湛江分公司', company_code='A019', company_name='股份', accept_company_code='0900003583A019', accept_company_name='湛江分公司股份', transport_org=NULL, transport_org_name=NULL, single_project_name=NULL, profession_code=NULL, profession_name=NULL, substation=NULL, store_type=NULL, store_type_name=NULL, application_type=NULL, application_type_name=NULL, vmi_order_no=NULL, purchase_type=NULL, purchase_type_name=NULL, first_deliver_center=NULL, first_deliver_center_name=NULL, order_create_time=NULL, purchase_manager=NULL, ext_str1=NULL, ext_str2=NULL, ext_str3=NULL, updator_name=NULL, ext_num1=NULL, ext_num2=NULL, ext_num3=NULL, ext_num4=NULL, ext_num5=NULL, ext_num6=NULL, ext_num7=NULL, ext_num8=NULL, ext_num9=NULL, ext_num10=NULL, contact_order_no=NULL, carrier_phone=NULL, carrier_name=NULL, order_serial_no=NULL, material_req_unit=NULL, material_req_unit_name=NULL, call_type=NULL, call_type_name=NULL, relation_id=NULL, waybill_no=NULL, deliver_date=NULL, cost_center=NULL, return_transfer_flag=NULL, jingcang_flag=NULL, refrom=NULL, refrom_name=NULL, order_status=NULL, project_out_code=NULL, project_out_name=NULL, link_person=NULL, shipping_address=NULL, link_phone=NULL, pick_person=NULL, pick_phone=NULL, mss_store_in_code=NULL, belong_project_code=NULL, belong_project_name=NULL, meet_conditions='1', back_remark=NULL, back_user_id=NULL, back_user_name=NULL, back_type=NULL, back_status=NULL, back_return=NULL, emergency_degree=NULL, receive_unit_name=NULL, project_tag='N', service_area_code=NULL, service_area_name=NULL, construction_unit_name=NULL, construction_unit_code=NULL;
    3. 

  3. insert into /zhongjie_logistics/gdwz_order id='zhongjie_logistics_gdwz_order:1461978355355336704', biz_id='1461978355355336704', creator_id='-1', creator_name='系统管理员', confirm_id=NULL, confirm_name=NULL, create_time='2026-01-17 07:00:02', update_time='2026-01-17 07:00:02', create_year='2026', delete_flag='0', status='0', state='1', cancel_status='1', org_id='90000322566560', basic_project_code='XM00517', basic_project_name='广东电信集约化物流项目', basic_project_id='1187343964416905216', supplier_code=NULL, supplier_name=NULL, type='1', order_type='5', order_type_name='入库需求单', order_attr='BHSJS', order_attr_name='拆旧料退库需求', create_way='0', create_way_name='MSS', logistics_order_type=NULL, logistics_order_type_name=NULL, order_no='XCJ/GDZJ/202601/00327', out_affair_code=NULL, out_affair_name=NULL, out_process=NULL, out_process_name=NULL, entry_affair_code=NULL, entry_affair_name=NULL, entry_process=NULL, entry_process_name=NULL, emergency_degree_code=NULL, emergency_degree_name=NULL, appoint_arrive_time=NULL, deliver_store=NULL, deliver_store_name=NULL, deliver_address=NULL, deliver_person=NULL, deliver_phone=NULL, deliver_area=NULL, deliver_area_name=NULL, deliver_city=NULL, deliver_city_name=NULL, deliver_province=NULL, deliver_province_name=NULL, reciever_store=NULL, reciever_store_name=NULL, reciever_address=NULL, reciever_person=NULL, reciever_phone=NULL, reciever_area=NULL, reciever_area_name=NULL, reciever_city=NULL, reciever_city_name=NULL, reciever_province=NULL, reciever_province_name=NULL, remark='181677577486913536(城北营业厅购销暂存点（回收）)', total_qty=NULL, total_gw=NULL, total_vol=NULL, purchase_order_no=NULL, purchase_order_name=NULL, order_create_data=NULL, accept_org=NULL, accept_org_name=NULL, project_code=NULL, project_name=NULL, project_manage_depart='A019', project_manage_depart_name=NULL, purchase_accept_depart='0900003583', purchase_accept_depart_name='湛江分公司', company_code='A019', company_name='股份', accept_company_code='0900003583A019', accept_company_name='湛江分公司股份', transport_org=NULL, transport_org_name=NULL, single_project_name=NULL, profession_code=NULL, profession_name=NULL, substation=NULL, store_type=NULL, store_type_name=NULL, application_type=NULL, application_type_name=NULL, vmi_order_no=NULL, purchase_type=NULL, purchase_type_name=NULL, first_deliver_center=NULL, first_deliver_center_name=NULL, order_create_time=NULL, purchase_manager=NULL, ext_str1=NULL, ext_str2=NULL, ext_str3=NULL, updator_name=NULL, ext_num1=NULL, ext_num2=NULL, ext_num3=NULL, ext_num4=NULL, ext_num5=NULL, ext_num6=NULL, ext_num7=NULL, ext_num8=NULL, ext_num9=NULL, ext_num10=NULL, contact_order_no=NULL, carrier_phone=NULL, carrier_name=NULL, order_serial_no=NULL, material_req_unit=NULL, material_req_unit_name=NULL, call_type=NULL, call_type_name=NULL, relation_id=NULL, waybill_no=NULL, deliver_date=NULL, cost_center=NULL, return_transfer_flag=NULL, jingcang_flag=NULL, refrom=NULL, refrom_name=NULL, order_status=NULL, project_out_code=NULL, project_out_name=NULL, link_person=NULL, shipping_address=NULL, link_phone=NULL, pick_person=NULL, pick_phone=NULL, mss_store_in_code=NULL, belong_project_code=NULL, belong_project_name=NULL, meet_conditions='1', back_remark=NULL, back_user_id=NULL, back_user_name=NULL, back_type=NULL, back_status=NULL, back_return=NULL, emergency_degree=NULL, receive_unit_name=NULL, project_tag='N', service_area_code=NULL, service_area_name=NULL, construction_unit_name=NULL, construction_unit_code=NULL;
    4. 

  4. insert into /zhongjie_logistics/gdwz_order id='zhongjie_logistics_gdwz_order:1462008046455865344', biz_id='1462008046455865344', creator_id='-1', creator_name='系统管理员', confirm_id=NULL, confirm_name=NULL, create_time='2026-01-17 08:58:01', update_time='2026-01-17 08:58:01', create_year='2026', delete_flag='0', status='0', state='1', cancel_status='1', org_id='90000322568460', basic_project_code='XM00517', basic_project_name='广东电信集约化物流项目', basic_project_id='1187343964416905216', supplier_code=NULL, supplier_name=NULL, type='1', order_type='5', order_type_name='入库需求单', order_attr='BHSJS', order_attr_name='拆旧料退库需求', create_way='0', create_way_name='MSS', logistics_order_type=NULL, logistics_order_type_name=NULL, order_no='XCJ/GDMM/202601/00537', out_affair_code=NULL, out_affair_name=NULL, out_process=NULL, out_process_name=NULL, entry_affair_code=NULL, entry_affair_name=NULL, entry_process=NULL, entry_process_name=NULL, emergency_degree_code=NULL, emergency_degree_name=NULL, appoint_arrive_time=NULL, deliver_store=NULL, deliver_store_name=NULL, deliver_address=NULL, deliver_person=NULL, deliver_phone=NULL, deliver_area=NULL, deliver_area_name=NULL, deliver_city=NULL, deliver_city_name=NULL, deliver_province=NULL, deliver_province_name=NULL, reciever_store=NULL, reciever_store_name=NULL, reciever_address=NULL, reciever_person=NULL, reciever_phone=NULL, reciever_area=NULL, reciever_area_name=NULL, reciever_city=NULL, reciever_city_name=NULL, reciever_province=NULL, reciever_province_name=NULL, remark='256562255401299986(杨梅支局营业厅购销暂存点(回收))', total_qty=NULL, total_gw=NULL, total_vol=NULL, purchase_order_no=NULL, purchase_order_name=NULL, order_create_data=NULL, accept_org=NULL, accept_org_name=NULL, project_code=NULL, project_name=NULL, project_manage_depart='A019', project_manage_depart_name=NULL, purchase_accept_depart='0900004232', purchase_accept_depart_name='茂名分公司', company_code='A019', company_name='股份', accept_company_code='0900004232A019', accept_company_name='茂名分公司股份', transport_org=NULL, transport_org_name=NULL, single_project_name=NULL, profession_code=NULL, profession_name=NULL, substation=NULL, store_type=NULL, store_type_name=NULL, application_type=NULL, application_type_name=NULL, vmi_order_no=NULL, purchase_type=NULL, purchase_type_name=NULL, first_deliver_center=NULL, first_deliver_center_name=NULL, order_create_time=NULL, purchase_manager=NULL, ext_str1=NULL, ext_str2=NULL, ext_str3=NULL, updator_name=NULL, ext_num1=NULL, ext_num2=NULL, ext_num3=NULL, ext_num4=NULL, ext_num5=NULL, ext_num6=NULL, ext_num7=NULL, ext_num8=NULL, ext_num9=NULL, ext_num10=NULL, contact_order_no=NULL, carrier_phone=NULL, carrier_name=NULL, order_serial_no=NULL, material_req_unit=NULL, material_req_unit_name=NULL, call_type=NULL, call_type_name=NULL, relation_id=NULL, waybill_no=NULL, deliver_date=NULL, cost_center=NULL, return_transfer_flag=NULL, jingcang_flag=NULL, refrom=NULL, refrom_name=NULL, order_status=NULL, project_out_code=NULL, project_out_name=NULL, link_person=NULL, shipping_address=NULL, link_phone=NULL, pick_person=NULL, pick_phone=NULL, mss_store_in_code=NULL, belong_project_code=NULL, belong_project_name=NULL, meet_conditions='1', back_remark=NULL, back_user_id=NULL, back_user_name=NULL, back_type=NULL, back_status=NULL, back_return=NULL, emergency_degree=NULL, receive_unit_name=NULL, project_tag='N', service_area_code=NULL, service_area_name=NULL, construction_unit_name=NULL, construction_unit_code=NULL;
    5.