hs
/
jsgkj


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354
							truncate table GK_BASIC_JSJY_JYR_CK;

--仓库
prompt Importing table GK_BASIC_JSJY_JYR_CK...
set feedback off
set define off
insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('DD494B6E39DD4F44B79C12C57F6C819D', '90015', '1A37524DE288418DBB8DF1C627913B25', null, '50713A44D8DD46978CB107E71FAE05F5', '南通千红石化港储有限公司', '201', null, null, null, null, null, null, null, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000017', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('F4AAD8AD50A14F8398F81928DA4C3E4C', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '油罐A区', '202', null, null, 7, null, 4150, null, 24900, 24900, 24900, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000062', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('0F63C46FF38B42DCBD4A85C06DF9BB05', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '油罐B区', '201', null, null, 6, null, 4150, null, 24900, 24900, 24900, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000061', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('CCA1945F3AE34EC5836E64D7BFFE2563', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '浅园仓', '202', null, null, 13, null, 25065, null, 120000, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000014', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('DA979FE1788D4B4E86F8B6C75739E3DB', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '立筒仓', '201', null, null, 12, null, 2820, null, 30000, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000013', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('7CDA2BA95B1440DA9DCAA26D3632926D', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '平房仓E', '202', null, null, 1, null, 4032, null, 18000, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000012', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('F944E55E4CA042F28E6CD5D7F62564A3', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '平房仓D', '201', null, null, 1, null, 4032, null, 18000, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000011', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('5492C24C568548E7956AA11D2BA5151B', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '平房仓C', '202', null, null, 1, null, 3456, null, 15000, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000010', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('367720F19B8540B8A3F97A99F5D57A4D', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '平房仓B', '202', null, null, 1, null, 2880, null, 12000, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000009', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('FB897F46A7D144369C30BFA5EC4F8B69', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '平房仓A', '202', null, null, 1, null, 5760, null, 30000, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000008', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('0BE90A4E44EE4FE3AFD11F393BE6BF78', '90015', '7B11CC5FFAAB4466B1EB62C23FC3C84F', null, '8672418D65D2444AAE324A02278C9D08', '在建立筒仓', '202', null, null, 33, null, 21749, null, 120000, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000015', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('344B5112AD8B48EA8F71EFA0E24C4F22', '90015', '06B26661CA604CA18F179EFB0B899015', null, '2977A4999F79443C9CC404374AEB6914', '南通嘉达自备仓库', '201', null, null, 3, null, 4800, null, null, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000021', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('12E3B6F1B0904C5EBC92A9E645845DA2', '90015', '3635991522664C259151E9443DAC0310', null, '88991C7ACC29482B90110ABF5F8B0299', '拆装箱库', '202', null, null, 1, null, 9062, null, null, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000003', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('1E885FF96B974208B3160CA152CF7664', '90015', '570BF99297274562B6C2038D26A64CD1', null, '87AF435561EE480C922CCFBFB982F7A4', '焯晟石化罐区', '201', null, null, null, 25.4, null, null, null, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000022', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

insert into GK_BASIC_JSJY_JYR_CK (ID, SZD, SZGQ, SSMT, SSJYR, CKMC, WXPCK, CKYT, CKYTMC, CKGS, YTHGCGRJ, SCYCKMJ, WXPCKMJ, SCYCKRJ, YKRJ, CPYRJ, JTJID, JD, WD, CREATE_USER, UPDATE_USER, CREATE_DATE_TIME, UPDATE_DATE_TIME, RECORD_STATUS, SZGK, SSGKGLBM, AQID, SFTB, TBZT, CKLX, YCKID, XKZID, SZZYQ, SSBW, KCSCLX, CKZMJ, CKRL, YGRJ, YGRL, YTCRJ, LSTCRJ, SNTCRJ, QTSCYCKRJ)
values ('1563C2622B65422AA179CD4E3AEFF578', '90015', '570BF99297274562B6C2038D26A64CD1', null, '2E0E7A985B944BC49FAE6627676A48EB', '阳鸿油库', '201', null, null, 1, 226000, null, null, null, 226000, null, null, '120.32.09', '32.03.44', 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '7000000002', 'Y', 'N', null, null, null, null, null, null, null, null, null, null, null, null, null, null);

prompt Done.

commit;