API tools faq
paste
Advertisement
Guest User

Untitled

a guest
May 27th, 2019
149
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PostgreSQL 19.41 KB | None | 0 0
raw download clone embed print report
  1.  
  2. DELETE FROM GM_MAS059 WHERE SERVID='TblEssDisplayHistoryApprovalEss' AND SERVID='TblEssDisplayHistoryApprovalEss';
  3.  
  4. DELETE FROM GM_MAS058 WHERE SERVID='TblEssDisplayHistoryApprovalEss' AND SERVID='TblEssDisplayHistoryApprovalEss';
  5.  
  6. DELETE FROM GM_MAS057 WHERE SERVID='TblEssDisplayHistoryApprovalEss' AND SERVID='TblEssDisplayHistoryApprovalEss';
  7.  
  8. DELETE FROM GM_MAS056 WHERE SERVID='TblEssDisplayHistoryApprovalEss' AND SERVID='TblEssDisplayHistoryApprovalEss';
  9.  
  10. INSERT INTO GM_MAS056(SERVID,STMT,DESCRIPTION,TITLEKEY,TYPE,BALLOONKEY,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','SELECT  Y.SOPT, Y.JnsTransaksi, Y.NoTransaksi, Y.ThBlnTransaksi, Y.TglTransaksi,
  11.        Y.KdJnsAbsensi, Y.FlgJnsAbsensi, Y.Nik, Y.NikNm,
  12.        Y.TanggalAwal, Y.TanggalAkhir, Y.Keterangan,
  13.        Y.JmlHariAtauJam, Y.JmlHari, Y.JmlJam, Y.JmlMenit, Y.Hari, Y.Jam, Y.Menit,
  14.        Y.JamAwl, Y.MskHari, Y.PlgHari, Y.JamAkhr,
  15.        Y.SOPTRef, Y.JnsTransaksiRef, Y.NoTransaksiRef, Y.HeaderVersion,
  16.        Y.KetDelete,
  17.        Y.KetStatus,
  18.        Y.AlasanTolak, Y.NmUserTolakTerima,
  19.        Y.IdxNumber, Y.TotalRecord
  20. FROM
  21.    (SELECT  A.sopt AS SOPT, A.jentrn AS JnsTransaksi, A.nortrn AS NoTransaksi, A.thbltr AS ThBlnTransaksi, A.tgltrn AS TglTransaksi,
  22.            A.abscd AS KdJnsAbsensi, A.flgabs AS FlgJnsAbsensi, A.nik AS Nik, B.niknm AS NikNm,
  23.            A.tglawal AS TanggalAwal, A.tglakhir AS TanggalAkhir, A.ketrng AS Keterangan,
  24.            CASE WHEN A.jentrnref IN (:JnsTransaksiRefIjinHalfDay, :JnsTransaksiRefTugasHalfDay) THEN ROUND((A.jummnt-(A.jummnt % 60))/ 60) || '' Jam '' || ROUND(A.jummnt % 60) || '' Menit'' ELSE ROUND(A.jumhr) ||'' Hari''  END AS JmlHariAtauJam,
  25.            CASE WHEN A.jentrnref IN (:JnsTransaksiRefIjinHalfDay, :JnsTransaksiRefTugasHalfDay) THEN ROUND((A.jummnt-(A.jummnt % 60))/ 60) END AS JmlJam,
  26.            CASE WHEN A.jentrnref IN (:JnsTransaksiRefIjinHalfDay, :JnsTransaksiRefTugasHalfDay) THEN '' Jam '' END AS Jam,
  27.            CASE WHEN A.jentrnref IN (:JnsTransaksiRefIjinHalfDay, :JnsTransaksiRefTugasHalfDay) THEN ROUND(A.jummnt % 60) END AS JmlMenit,
  28.            CASE WHEN A.jentrnref IN (:JnsTransaksiRefIjinHalfDay, :JnsTransaksiRefTugasHalfDay) THEN '' Menit'' END AS Menit,
  29.            CASE WHEN A.jentrnref NOT IN (:JnsTransaksiRefIjinHalfDay, :JnsTransaksiRefTugasHalfDay) THEN ROUND(A.jumhr) END AS JmlHari,
  30.            CASE WHEN A.jentrnref NOT IN (:JnsTransaksiRefIjinHalfDay, :JnsTransaksiRefTugasHalfDay) THEN '' Hari'' END AS Hari,
  31.            A.jamawl AS JamAwl, A.mskhari AS MskHari, A.plghari AS PlgHari, A.jamakhr AS JamAkhr,
  32.            A.soptref AS SOPTRef, A.jentrnref AS JnsTransaksiRef, A.nortrnref AS NoTransaksiRef, A.version AS HeaderVersion,
  33.            CASE WHEN A.flgconfess = ''P'' AND A.useridconfess <> ''HRD'' THEN ''Delete'' ELSE '''' END AS KetDelete,
  34.            CASE WHEN A.flgconfess = ''P'' THEN ''Pending''
  35.                 WHEN A.flgconfess = ''Y'' THEN ''Disetujui''
  36.                 WHEN A.flgconfess = ''T'' THEN ''Ditolak'' ELSE '''' END AS KetStatus,
  37.            A.alasantolak AS AlasanTolak, CASE WHEN A.useridconfess = ''HRD'' THEN ''HRD'' ELSE COALESCE(E.niknm,'''') END AS NmUserTolakTerima,
  38.            ROW_NUMBER() OVER (ORDER BY A.tglawal, A.tglakhir) AS IdxNumber, F.TotalRecord AS TotalRecord
  39.    FROM    hm_est001 A JOIN
  40.            hm_dbo020 B ON A.sopt = B.sopt AND A.nik = B.nik LEFT JOIN
  41.            hm_esa001 D On A.useridconfess = D.essuserid LEFT JOIN
  42.            hm_dbo020 E On D.sopt = E.sopt AND D.nik = E.nik, (
  43.                SELECT  COUNT(*) AS TotalRecord
  44.                FROM    hm_est001 A JOIN
  45.                        hm_dbo020 B ON A.sopt = B.sopt AND A.nik = B.nik LEFT JOIN
  46.                        hm_esa001 D On A.useridconfess = D.essuserid LEFT JOIN
  47.                        hm_dbo020 E On D.sopt = E.sopt AND D.nik = E.nik
  48.                WHERE   A.sopt = :SOPT AND
  49.                        A.useridconfess = :EssUserId AND
  50.                        A.jentrn LIKE :JnsTransaksi AND
  51.                        A.flgconfess LIKE :FlagKonfirmasiEss AND
  52.                        (A.tglawal BETWEEN :TanggalAwal AND :TanggalAkhir OR
  53.                         A.tglakhir BETWEEN :TanggalAwal AND :TanggalAkhir))F
  54.    WHERE   A.sopt = :SOPT AND
  55.            A.useridconfess = :EssUserId AND
  56.            A.jentrn LIKE :JnsTransaksi AND
  57.            A.flgconfess LIKE :FlagKonfirmasiEss AND
  58.            (A.tglawal BETWEEN :TanggalAwal AND :TanggalAkhir OR
  59.            A.tglakhir BETWEEN :TanggalAwal AND :TanggalAkhir))Y
  60. WHERE Y.IdxNumber Between (CAST(:PageNumber AS NUMERIC)-1) * CAST(:RowsPerPage AS NUMERIC) + 1 And CAST(:PageNumber AS NUMERIC) * CAST(:RowsPerPage AS NUMERIC)','History Approval Ess','HistoryApprovalEss','default','','HR_INDONET','AT','ORDER BY Y.IdxNumber','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  61.  
  62. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','SOPT','EMPTY',0,10.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  63. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','JnsTransaksi','EMPTY',0,20.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  64. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','NoTransaksi','EMPTY',0,30.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  65. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','ThBlnTransaksi','EMPTY',0,40.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  66. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','TglTransaksi','EMPTY',0,50.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  67. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','KdJnsAbsensi','EMPTY',0,60.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  68. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','FlgJnsAbsensi','EMPTY',0,70.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  69. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','Nik','EMPTY',0,80.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  70. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','NikNm','EMPTY',0,90.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  71. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','TanggalAwal','EMPTY',0,100.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  72. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','TanggalAkhir','EMPTY',0,110.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  73. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','Keterangan','EMPTY',0,120.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  74. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','JmlHariAtauJam','EMPTY',0,130.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  75. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','JmlJam','EMPTY',0,140.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  76. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','Jam','EMPTY',0,150.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  77. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','JmlMenit','EMPTY',0,160.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  78. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','Menit','EMPTY',0,170.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  79. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','JmlHari','EMPTY',0,180.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  80. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','Hari','EMPTY',0,190.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  81. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','JamAwl','EMPTY',0,200.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  82. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','MskHari','EMPTY',0,210.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  83. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','PlgHari','EMPTY',0,220.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  84. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','JamAkhr','EMPTY',0,230.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  85. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','SOPTRef','EMPTY',0,240.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  86. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','JnsTransaksiRef','EMPTY',0,250.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  87. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','NoTransaksiRef','EMPTY',0,260.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  88. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','HeaderVersion','EMPTY',0,270.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  89. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','KetDelete','EMPTY',0,280.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  90. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','KetStatus','EMPTY',0,290.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  91. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','AlasanTolak','EMPTY',0,300.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  92. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','NmUserTolakTerima','EMPTY',0,310.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  93. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','IdxNumber','EMPTY',0,320.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
  94. INSERT INTO GM_MAS057(SERVID,FIELD,HEADERKEY,FREEZED,SHOWPOS,FIELD1,FIELD2,FIELD3,FIELD4,FIELD5,FIELDNUM1,FIELDNUM2,FIELDNUM3,FIELDNUM4,FIELDNUM5,FIELDFLG1,FIELDFLG2,FIELDFLG3,FIELDFLG4,FIELDFLG5, VERSION, TGLCRT, JAMCRT, USERCRT, TGLUPD, JAMUPD, USERUPD) VALUES('TblEssDisplayHistoryApprovalEss','TotalRecord','EMPTY',0,330.0,'','','','','',0.0,0.0,0.0,0.0,0.0,'','','','','',1,'22092001','030007','SofcoGraha','22092001','030007','SofcoGraha');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!