Home Explore Help
Register Sign In
hs
/
jsgkj
2
0
Fork 0
Files Issues 0 Pull Requests 0 Wiki
Tree: ccf18e7b6e
Branches Tags
jsgkj
/
gkjsjy
/
trunk
/
WebContent
/
static
/
sql
/
oracle
/
huaian
/
gkjy
/
5.4.3.gkjydata.sql

5.4.3.gkjydata.sql 4.4 KB
History Raw

1234567891011121314151617181920212223 
  1. delete from GK_BASIC_JSJY_JYR_CK;
    2. 

  2. 

  3. --仓库
    4. 

  4. 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)
    5. 

  5. values ('EECA9BDB46FC402988A8016DC7739C37', '90023', '02C1D35E1AEF4F76BD70BA136F9DA929', null, '54D0B7E81A384071840B33CD72BB0585', '淮安新港', '202', null, null, 1, null, 1000, 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, '12000000061', 'Y', 'N', null);
    6. 

  6. 

  7. 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)
    8. 

  8. values ('542E09BFD2D1414F8B70F8314D7C6AB3', '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, 'BAD735E719F74E6A9D7B1118A073C38D', '成品仓库', '202', null, null, 1, null, 5100, 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, '12000000041', 'Y', 'N', null);
    9. 

  9. 

  10. 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)
    11. 

  11. values ('D4A65DA546724E1CA86226FFE615B15A', '90023', '7857596F3DFC4EF38A51F3580BA076F0', null, '4AA6B9F6AAD644B387774748F40C9CDD', '1号仓库', '201', null, null, 12, 3600, 1200, null, 3600, null, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '12000000001', 'Y', 'N', null);
    12. 

  12. 

  13. 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)
    14. 

  14. values ('B8E4208F83A24F3F8AAE69AEE9425CA7', '90023', '78BEF3ED8DAD42349BDC9AE22BB4ECAC', null, '8CC5705A02E94AE0A888E20D40C3D618', '粮食储备库', '201', null, null, 39, null, 28000, 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, '12000000081', 'Y', 'N', null);
    15. 

  15. 

  16. 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)
    17. 

  17. values ('EA247FC6109A4B41A710CE862AEED144', '90023', 'FD44FB26B7064448A023CF51ED9B2F5F', null, 'F6FA9685E57641A8BACDE0B3CA87836E', '运河油库', '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, '12000000021', 'Y', 'N', null);
    18. 

  18. 

  19. 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)
    20. 

  20. values ('5D5F97E6971C404DBF5B1E469CB2D484', '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, '027762BB9D08429D8FAABBEFB32E38E3', '2#', '202', null, null, 1, null, 5000, 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, '12000000042', 'Y', 'N', null);
    21. 

  21. 

  22. 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)
    23. 

  23. values ('52CE793AE3584FBB9B1B43AB54B1F8F7', '90023', 'E4CAAFEFEBAC41AC98D0C1B55A35B41B', null, '952310D0B296438099C5A4F135EAC818', '淮安油库', '201', null, null, 1, null, 66666.67, null, 55000, 55000, null, null, null, null, 'aq', 'aq', '26-11月-15 09.14.09.612000 下午', '26-11月-15 09.14.09.612000 下午', 1, null, null, '12000000083', 'Y', 'N', null);
    24.