sryang/thinkyu
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
Files
master
thinkyu/DB/SQL.txt
T
sryang 577060bc78 chore: 首次簽入 Thinkyu ASP.NET 專案 
- 加入 Visual Studio / ASP.NET .gitignore
- 排除建置輸出、IDE 設定、NuGet packages、大型 MSI 安裝檔
2026-09-10 09:42:37 +08:00

2209 lines
139 KiB
Plaintext
Raw Permalink Blame History

This file contains invisible Unicode characters
This file contains invisible Unicode characters that are indistinguishable to humans but may be processed differently by a computer. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
-- 2/4 §ó§ï
ALTER TABLE BPAB ADD BPDOC NVARCHAR(100) NULL ;
ALTER TABLE SACD ADD SADOC NVARCHAR(100) NULL ;
-- 2/5 §ó§ï
ALTER TABLE BPAA ADD BPMSD DATETIME NULL;
-- 2/12 §ó§ï
ALTER TABLE BPSN ADD BPSWY INT DEFAULT 0 ;
ALTER TABLE BPSN ADD BPBNK INT DEFAULT 0 ;
ALTER TABLE BPSN ADD BPACC INT DEFAULT 0 ;
CREATE TABLE ROWK
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,ROENO NVARCHAR( 10) not NULL
,ROYMM DATETIME not NULL
,ROPYN NVARCHAR( 10) NULL
,ROT01 INT DEFAULT 0
,ROT02 INT DEFAULT 0
,ROT03 INT DEFAULT 0
,ROA01 INT DEFAULT 0
,ROA02 INT DEFAULT 0
,ROA03 INT DEFAULT 0
,APPNO INT DEFAULT 0
);
ALTER TABLE ROWK ADD CONSTRAINT PK_ROWK PRIMARY KEY (ROENO,ROYMM);
-- 2/15 §ó§ï
ALTER TABLE BPSN ADD BPDPT VARCHAR( 10) NULL ;
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0040750', BPACC='075004824095' WHERE BPENO='00010'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060081', BPACC='0081765980739' WHERE BPENO='00011'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060620', BPACC='0620872110958' WHERE BPENO='00012'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0040875', BPACC='087004703596' WHERE BPENO='00013'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060110', BPACC='0110872282157' WHERE BPENO='00014'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065207', BPACC='012004745003' WHERE BPENO='00015'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060100', BPACC='0100765188215' WHERE BPENO='00016'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0050197', BPACC='019005542998' WHERE BPENO='00017'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060580', BPACC='0580765346327' WHERE BPENO='00018'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060120', BPACC='0120765592254' WHERE BPENO='00019'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060992', BPACC='0992765622762' WHERE BPENO='00020'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065311', BPACC='5311765806350' WHERE BPENO='00181'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060210', BPACC='0210872168944' WHERE BPENO='00183'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065207', BPACC='5207765901610' WHERE BPENO='00214'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061025', BPACC='0914765725676' WHERE BPENO='00215'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065436', BPACC='5436872499378' WHERE BPENO='00021'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061379', BPACC='0151765645334' WHERE BPENO='00022'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065436', BPACC='5436765479216' WHERE BPENO='00023'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0040417', BPACC='041008114683' WHERE BPENO='00024'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065447', BPACC='5447765961397' WHERE BPENO='00025'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061243', BPACC='1243765712797' WHERE BPENO='00026'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065632', BPACC='5632765227326' WHERE BPENO='00027'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061313', BPACC='1313765545228' WHERE BPENO='00028'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061243', BPACC='1243765552820' WHERE BPENO='00029'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065528', BPACC='5528765646017' WHERE BPENO='00030'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060187', BPACC='0180765700904' WHERE BPENO='00031'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065528', BPACC='5528765643735' WHERE BPENO='00032'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060039', BPACC='0030765874340' WHERE BPENO='00178'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061210', BPACC='1210872331717' WHERE BPENO='00185'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060190', BPACC='0190765996612' WHERE BPENO='00186'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060170', BPACC='0170765539563' WHERE BPENO='00198'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060150', BPACC='0150872130936' WHERE BPENO='00199'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065528', BPACC='5528765724271' WHERE BPENO='00202'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872138951' WHERE BPENO='00033'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872140646' WHERE BPENO='00034'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0040303', BPACC='030004632339' WHERE BPENO='00035'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061139', BPACC='1139765274933' WHERE BPENO='00036'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060210', BPACC='0210765736492' WHERE BPENO='00037'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060250', BPACC='0250765465903' WHERE BPENO='00038'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240872059751' WHERE BPENO='00040'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060230', BPACC='0230872096049' WHERE BPENO='00182'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060570', BPACC='0570765456577' WHERE BPENO='00196'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065850', BPACC='5850765299278' WHERE BPENO='00210'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065207', BPACC='5207765901253' WHERE BPENO='00212'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065436', BPACC='5436765479348' WHERE BPENO='00179'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0077017', BPACC='70151082961' WHERE BPENO='00180'
UPDATE BPSN SET BPDPT='X', BPSWY='2', BPBNK='', BPACC='' WHERE BPENO='00184'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065436', BPACC='5436765480010' WHERE BPENO='00187'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065436', BPACC='5436765502391' WHERE BPENO='00188'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060170', BPACC='0170765540669' WHERE BPENO='00206'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0040107', BPACC='010008006605' WHERE BPENO='00041'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065160', BPACC='5160765550276' WHERE BPENO='00042'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230872096049' WHERE BPENO='00044'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061173', BPACC='1173765093746' WHERE BPENO='00177'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872140875' WHERE BPENO='00195'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065160', BPACC='5160765553275' WHERE BPENO='00234'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060230', BPACC='0230766009439' WHERE BPENO='00235'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220765082544' WHERE BPENO='00236'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0063029', BPACC='3029872005471' WHERE BPENO='00039'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220765082102' WHERE BPENO='00043'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061438', BPACC='1438872067611' WHERE BPENO='00133'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872138871' WHERE BPENO='00134'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061715', BPACC='1715765601455' WHERE BPENO='00135'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065160', BPACC='5160765549316' WHERE BPENO='00136'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065160', BPACC='5160765549324' WHERE BPENO='00137'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065160', BPACC='5160765549332' WHERE BPENO='00138'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065160', BPACC='5160765549308' WHERE BPENO='00139'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872138498' WHERE BPENO='00140'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065160', BPACC='5160765549286' WHERE BPENO='00141'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220765516579' WHERE BPENO='00142'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872138447' WHERE BPENO='00143'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061128', BPACC='1128872003941' WHERE BPENO='00144'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065160', BPACC='5160765549294' WHERE BPENO='00145'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060578', BPACC='0570765457191' WHERE BPENO='00146'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060578', BPACC='0570765457158' WHERE BPENO='00147'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060578', BPACC='0570765457182' WHERE BPENO='00148'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060578', BPACC='0570765457174' WHERE BPENO='00149'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061656', BPACC='1656872208263' WHERE BPENO='00150'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060578', BPACC='0570765457166' WHERE BPENO='00151'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065540', BPACC='5540872001819' WHERE BPENO='00152'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060210', BPACC='0210872127717' WHERE BPENO='00153'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060202', BPACC='0200872039880' WHERE BPENO='00154'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872127636' WHERE BPENO='00155'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872188031' WHERE BPENO='00156'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872127709' WHERE BPENO='00157'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872127644' WHERE BPENO='00158'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872100098' WHERE BPENO='00159'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872100161' WHERE BPENO='00160'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872100403' WHERE BPENO='00161'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872102546' WHERE BPENO='00162'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099715' WHERE BPENO='00163'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210765121471' WHERE BPENO='00164'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230872096502' WHERE BPENO='00165'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230765266781' WHERE BPENO='00166'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230872096022' WHERE BPENO='00167'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230872096014' WHERE BPENO='00168'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061139', BPACC='1139872015851' WHERE BPENO='00169'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230872095981' WHERE BPENO='00170'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765476438' WHERE BPENO='00171'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065609', BPACC='5609765548562' WHERE BPENO='00172'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765476471' WHERE BPENO='00173'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765476501' WHERE BPENO='00174'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061184', BPACC='1184765300743' WHERE BPENO='00175'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765476519' WHERE BPENO='00176'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220765956102' WHERE BPENO='00191'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765477965' WHERE BPENO='00192'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065610', BPACC='5610872001345' WHERE BPENO='00213'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060570', BPACC='0570765460493' WHERE BPENO='00216'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872149511' WHERE BPENO='00217'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060210', BPACC='0210765767584' WHERE BPENO='00218'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060250', BPACC='0250872100098' WHERE BPENO='00219'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060690', BPACC='0690765667689' WHERE BPENO='00220'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065562', BPACC='5562765516109' WHERE BPENO='00221'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065160', BPACC='5160765553313' WHERE BPENO='00222'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872149325' WHERE BPENO='00223'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060690', BPACC='0690765767110' WHERE BPENO='00224'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065540', BPACC='5540766022301' WHERE BPENO='00225'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060250', BPACC='0250872109575' WHERE BPENO='00226'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0062033', BPACC='2033765212564' WHERE BPENO='00227'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060250', BPACC='0250872109605' WHERE BPENO='00228'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061140', BPACC='1140872020578' WHERE BPENO='00229'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0063029', BPACC='3029872009832' WHERE BPENO='00230'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765552983' WHERE BPENO='00231'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060570', BPACC='0570872829785' WHERE BPENO='00237'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765145032' WHERE BPENO='00238'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060693', BPACC='0690765755324' WHERE BPENO='00045'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065171', BPACC='5171765378475' WHERE BPENO='00046'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061162', BPACC='1162765226108' WHERE BPENO='00047'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0062044', BPACC='2044765015531' WHERE BPENO='00048'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061128', BPACC='1128765237513' WHERE BPENO='00049'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061438', BPACC='1438765117266' WHERE BPENO='00050'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061438', BPACC='1438765608260' WHERE BPENO='00051'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060693', BPACC='0690766024374' WHERE BPENO='00052'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061807', BPACC='1807765177116' WHERE BPENO='00053'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872138722' WHERE BPENO='00054'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061494', BPACC='1494765803540' WHERE BPENO='00055'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061070', BPACC='1070765302368' WHERE BPENO='00056'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065551', BPACC='5551765027611' WHERE BPENO='00057'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872138714' WHERE BPENO='00058'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061162', BPACC='1162765233210' WHERE BPENO='00059'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061601', BPACC='1601717279899' WHERE BPENO='00060'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220765618754' WHERE BPENO='00061'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060578', BPACC='0570872828797' WHERE BPENO='00062'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060578', BPACC='0570872065297' WHERE BPENO='00063'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060578', BPACC='0570765378908' WHERE BPENO='00064'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065942', BPACC='5942765074871' WHERE BPENO='00065'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060578', BPACC='0570765419205' WHERE BPENO='00066'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060202', BPACC='0200872126146' WHERE BPENO='00067'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060202', BPACC='0200872126162' WHERE BPENO='00068'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0062077', BPACC='2077765709784' WHERE BPENO='00069'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060202', BPACC='0200872126171' WHERE BPENO='00070'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061715', BPACC='1715872533071' WHERE BPENO='00071'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065540', BPACC='5540766006151' WHERE BPENO='00072'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060202', BPACC='0200872126189' WHERE BPENO='00073'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210765857966' WHERE BPENO='00074'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872128161' WHERE BPENO='00075'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872127903' WHERE BPENO='00076'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210765120891' WHERE BPENO='00077'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061715', BPACC='1715872533021' WHERE BPENO='00078'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061715', BPACC='1715872533039' WHERE BPENO='00079'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210717038481' WHERE BPENO='00080'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872086395' WHERE BPENO='00081'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872128179' WHERE BPENO='00082'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210765718371' WHERE BPENO='00083'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065562', BPACC='5562765540409' WHERE BPENO='00084'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210765588361' WHERE BPENO='00085'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872128993' WHERE BPENO='00086'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060213', BPACC='0210872128187' WHERE BPENO='00087'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220872119205' WHERE BPENO='00088'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061438', BPACC='1438765697149' WHERE BPENO='00089'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230765695011' WHERE BPENO='00090'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230872096251' WHERE BPENO='00091'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230765937880' WHERE BPENO='00092'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230765643738' WHERE BPENO='00093'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0063029', BPACC='3029765057182' WHERE BPENO='00094'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230765451928' WHERE BPENO='00095'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230765678086' WHERE BPENO='00096'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0063395', BPACC='3395765032241' WHERE BPENO='00097'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230872096201' WHERE BPENO='00098'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0063395', BPACC='3395765032283' WHERE BPENO='00099'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0063029', BPACC='3029765801124' WHERE BPENO='00100'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060235', BPACC='0230765981277' WHERE BPENO='00101'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061139', BPACC='1139765169340' WHERE BPENO='00102'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061139', BPACC='1139765275263' WHERE BPENO='00103'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061139', BPACC='1139765502901' WHERE BPENO='00104'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060693', BPACC='0690765139127' WHERE BPENO='00105'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765499489' WHERE BPENO='00106'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765476683' WHERE BPENO='00107'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765499519' WHERE BPENO='00108'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765499543' WHERE BPENO='00109'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765499497' WHERE BPENO='00110'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065621', BPACC='5621765083268' WHERE BPENO='00111'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765499535' WHERE BPENO='00112'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065609', BPACC='5609765614000' WHERE BPENO='00113'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061184', BPACC='1184765300859' WHERE BPENO='00114'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765499551' WHERE BPENO='00115'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061184', BPACC='1184765300832' WHERE BPENO='00116'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765476675' WHERE BPENO='00117'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240765476713' WHERE BPENO='00118'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099863' WHERE BPENO='00119'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065573', BPACC='5573765428210' WHERE BPENO='00120'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099928' WHERE BPENO='00121'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099855' WHERE BPENO='00122'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060707', BPACC='0700717600080' WHERE BPENO='00123'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099910' WHERE BPENO='00124'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872094667' WHERE BPENO='00125'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099871' WHERE BPENO='00126'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099880' WHERE BPENO='00127'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099839' WHERE BPENO='00128'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250765418832' WHERE BPENO='00129'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099901' WHERE BPENO='00130'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060707', BPACC='0700765260282' WHERE BPENO='00131'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060257', BPACC='0250872099847' WHERE BPENO='00132'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061070', BPACC='1070765619779' WHERE BPENO='00189'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060210', BPACC='0210717091251' WHERE BPENO='00190'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061726', BPACC='1726766001119' WHERE BPENO='00194'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060220', BPACC='0220765081921' WHERE BPENO='00201'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065621', BPACC='5621872081189' WHERE BPENO='00203'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060230', BPACC='0230765610848' WHERE BPENO='00204'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061184', BPACC='1184765302169' WHERE BPENO='00205'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060200', BPACC='0200872014291' WHERE BPENO='00207'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060210', BPACC='0210872184630' WHERE BPENO='00208'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0060240', BPACC='0240872072552' WHERE BPENO='00209'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0061025', BPACC='1025765112253' WHERE BPENO='00211'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0062055', BPACC='2055765231635' WHERE BPENO='00233'
UPDATE BPSN SET BPDPT='X', BPSWY='1', BPBNK='0065414', BPACC='5414765556853' WHERE BPENO='00197'
UPDATE BPSN SET BPDPT='TY', BPSWY='1', BPBNK='0065344', BPACC='5344765169410' WHERE BPENO='00003'
UPDATE BPSN SET BPDPT='TY', BPSWY='2', BPBNK='', BPACC='' WHERE BPENO='00008'
UPDATE BPSN SET BPDPT='TY', BPSWY='1', BPBNK='0040668', BPACC='066004969354' WHERE BPENO='00009'
UPDATE BPSN SET BPDPT='TY', BPSWY='1', BPBNK='0060450', BPACC='0450765344871' WHERE BPENO='00193'
UPDATE BPSN SET BPDPT='TY1', BPSWY='1', BPBNK='0060811', BPACC='0811765694343' WHERE BPENO='00004'
UPDATE BPSN SET BPDPT='TY2', BPSWY='1', BPBNK='0065447', BPACC='5447765961885' WHERE BPENO='00002'
UPDATE BPSN SET BPDPT='TY2', BPSWY='1', BPBNK='0060165', BPACC='0160872152650' WHERE BPENO='00005'
UPDATE BPSN SET BPDPT='TY3', BPSWY='1', BPBNK='0061405', BPACC='1405872979623' WHERE BPENO='00001'
UPDATE BPSN SET BPDPT='TY3', BPSWY='1', BPBNK='0060220', BPACC='0220872139001' WHERE BPENO='00006'
UPDATE BPSN SET BPDPT='TY3', BPSWY='1', BPBNK='0065160', BPACC='5160765422073' WHERE BPENO='00007'
UPDATE BPSN SET BPDPT='TY3', BPSWY='1', BPBNK='0060220', BPACC='0220872118381' WHERE BPENO='00232'
CREATE TABLE [dbo].[BRML] (
[BCNUM] [varchar] (13) NOT NULL ,
[BCNAM] [varchar] (47) NULL ,
[BCSNM] [varchar] (13) NULL ,
[BCCJ5] [varchar] (7) NULL ,
[BCCOD] [varchar] (9) NULL ,
[BCADR] [varchar] (49) NULL ,
[BCTEL] [varchar] (40) NULL ,
[BLOCK] [varchar] (8) NULL ,
[BCENA] [varchar] (50) NULL ,
[BCENM] [varchar] (50) NULL ,
[BCEAD] [varchar] (100) NULL ,
[BCSWI] [varchar] (20) NULL ,
[BCBNT] [varchar] (16) NULL ,
[BCBUS] [varchar] (16) NULL ,
[BCBJP] [varchar] (16) NULL ,
[BCBEP] [varchar] (16) NULL ,
[TRDAT] [datetime] NULL ,
[TRUSR] [varchar] (10) NULL ,
[TRMOD] [varchar] (12) NULL
) ON [PRIMARY]
INSERT INTO BDPT (BDNUM, BDNAM, BDSNM) VALUES ('TY','¥x¥_Á`¤½¥q','¥x¥_')
INSERT INTO BDPT (BDNUM, BDNAM, BDSNM) VALUES ('TY1','¥_°ò¤À¤½¥q','¥_°ò')
INSERT INTO BDPT (BDNUM, BDNAM, BDSNM) VALUES ('TY2','®ç¶é¤À¤½¥q','®ç¶é')
INSERT INTO BDPT (BDNUM, BDNAM, BDSNM) VALUES ('TY3','¥x¤¤¤À¤½¥q','¥x¤¤')
INSERT INTO BDPT (BDNUM, BDNAM, BDSNM) VALUES ('X','¨ä¥L','¨ä¥L')
-- 2/19 §ó·s­û¤u¸ê®Æ»È¦æ¥N¸¹¿ù»~³¡¥÷
UPDATE BPSN SET BPBNK = '0061324' WHERE BPBNK = '0060081'
UPDATE BPSN SET BPBNK = '0060109' WHERE BPBNK = '0060100'
UPDATE BPSN SET BPBNK = '0060121' WHERE BPBNK = '0060120'
UPDATE BPSN SET BPBNK = '0060154' WHERE BPBNK = '0060150'
UPDATE BPSN SET BPBNK = '0060176' WHERE BPBNK = '0060170'
UPDATE BPSN SET BPBNK = '0060198' WHERE BPBNK = '0060190'
UPDATE BPSN SET BPBNK = '0060202' WHERE BPBNK = '0060200'
UPDATE BPSN SET BPBNK = '0060213' WHERE BPBNK = '0060210'
UPDATE BPSN SET BPBNK = '0060224' WHERE BPBNK = '0060220'
UPDATE BPSN SET BPBNK = '0060235' WHERE BPBNK = '0060230'
UPDATE BPSN SET BPBNK = '0060246' WHERE BPBNK = '0060240'
UPDATE BPSN SET BPBNK = '0060257' WHERE BPBNK = '0060250'
UPDATE BPSN SET BPBNK = '0060453' WHERE BPBNK = '0060450'
UPDATE BPSN SET BPBNK = '0060578' WHERE BPBNK = '0060570'
UPDATE BPSN SET BPBNK = '0060589' WHERE BPBNK = '0060580'
UPDATE BPSN SET BPBNK = '0060626' WHERE BPBNK = '0060620'
UPDATE BPSN SET BPBNK = '0060693' WHERE BPBNK = '0060690'
-- 2/19 §ó·s¨­»ÙÃþ§O¡A§ï¬°´î§K¤ñ¨Ò
UPDATE BCLS SET BSSCR = 'µL' WHERE BSPAR = 'BPSNDIS' AND BSCLS = '0'
UPDATE BCLS SET BSSCR = '25%' WHERE BSPAR = 'BPSNDIS' AND BSCLS = '1'
UPDATE BCLS SET BSSCR = '50%' WHERE BSPAR = 'BPSNDIS' AND BSCLS = '2'
UPDATE BCLS SET BSSCR = '100%' WHERE BSPAR = 'BPSNDIS' AND BSCLS = '3'
DELETE BCLS WHERE BSPAR = 'BPSNDIS' AND BSCLS = '4'
-- 2/19 ¥[«O¬ö¿ý¼W¥[¤T­ÓÄæ¦ì
ALTER TABLE RPIR ADD RPFM1 INT DEFAULT 0;
ALTER TABLE RPIR ADD RPFM2 INT DEFAULT 0;
ALTER TABLE RPIR ADD RPFM3 INT DEFAULT 0;
UPDATE RPIR SET RPFM1=0, RPFM2=0, RPFM3=0;
-- 2/22 ¼W¥[ BPRM TABLE
CREATE TABLE BPRM
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,BPPNM NVARCHAR( 10) not NULL
,BPENO NVARCHAR( 10) not NULL
,APPNO INT DEFAULT 0
);
ALTER TABLE BPRM ADD CONSTRAINT PK_BPRM PRIMARY KEY (BPPNM,BPENO);
-- 2/25 ROWK ¼W¥[Äæ¦ì
ALTER TABLE ROWK ADD ROT04 INT DEFAULT 0 ;
UPDATE ROWK SET ROT04=0;
-- 2/25 SSMS ¼W¥[Äæ¦ì
ALTER TABLE SSMS ADD SSC01 NVARCHAR(254) NULL ;
ALTER TABLE SSMS ADD SSC02 NVARCHAR(254) NULL ;
ALTER TABLE SSMS ADD SSC03 NVARCHAR(254) NULL ;
ALTER TABLE SSMS ADD SSC04 NVARCHAR(254) NULL ;
ALTER TABLE SSMS ADD SSC05 NVARCHAR(254) NULL ;
ALTER TABLE SSMS ADD SSC06 NVARCHAR(254) NULL ;
ALTER TABLE SSMS ADD SSC07 NVARCHAR(254) NULL ;
ALTER TABLE SSMS ADD SSC08 NVARCHAR(254) NULL ;
ALTER TABLE SSMS ADD SSC09 NVARCHAR(254) NULL ;
ALTER TABLE SSMS ADD SSC10 NVARCHAR(254) NULL ;
-- 2/27 ¼W¥[ BFRT ºÖ§Qª÷¤ñ¨Ò TABLE
CREATE TABLE BFRT
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,BFIDN VARCHAR( 4) not NULL
,BFRTE INT DEFAULT 0
,BFSDT DATETIME NULL
,BFEDT DATETIME NULL
,APPNO INT DEFAULT 0
);
ALTER TABLE BFRT ADD CONSTRAINT PK_BFRT PRIMARY KEY (BFIDN);
INSERT INTO BFRT (TRDAT, TRMOD, TRUSR, BFIDN, BFRTE, BFSDT, BFEDT, APPNO)
VALUES ('2008/2/1', 'INSERT', 'X002', '0001', 5, '2008/2/1', NULL, 1)
-- 3/4 ¼W¥[Ãþ§O¸ê®Æ
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNSWY', '1', '»È¦æÂà±b')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNSWY', '2', '²{ª÷')
-- 3/14 BPSN ¤Î RPIR ¥[³Æµù
ALTER TABLE BPSN ADD BPDOC NVARCHAR(254) NULL ;
ALTER TABLE RPIR ADD RPDOC NVARCHAR(254) NULL ;
-- 3/28 RPIR ¼W¥[Äæ¦ì
ALTER TABLE RPIR ADD RPDIH VARCHAR( 1) NULL ;
UPDATE RPIR SET RPDIH=RPDIS;
-- 4/3 RPIR ¼W¥[Äæ¦ì
ALTER TABLE RPIR ADD RPSLY INT DEFAULT 0 ;
UPDATE RPIR SET RPSLY=RPAMT;
-- 4/3 ¼W¥[ RPIB ªí®æ
CREATE TABLE RPIB
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,RPREN NVARCHAR( 10) not NULL
,RPITM INT not NULL
,RPENO NVARCHAR( 10) NULL
,RPBDT DATETIME NULL
,RPSDT DATETIME NULL
,RPEDT DATETIME NULL
,RPSLY INT DEFAULT 0
,RPAMT INT DEFAULT 0
,RPFMY INT DEFAULT 0
,RPFM1 INT DEFAULT 0
,RPFM2 INT DEFAULT 0
,RPFM3 INT DEFAULT 0
,RPSLA INT DEFAULT 0
,RPDIS VARCHAR( 1) NULL
,RPDIH VARCHAR( 1) NULL
,RPOLD VARCHAR( 1) NULL
,RPNAT VARCHAR( 1) NULL
,RPPTP VARCHAR( 1) NULL
,RPLIS VARCHAR( 1) NULL
,RPHIS VARCHAR( 1) NULL
,RPDOC NVARCHAR(254) NULL
,APPNO INT DEFAULT 0
);
ALTER TABLE RPIB ADD CONSTRAINT PK_RPIB PRIMARY KEY (RPREN,RPITM);
CREATE TABLE RPIBBAKD
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,RPREN NVARCHAR( 10) not NULL
,RPITM INT not NULL
,RPENO NVARCHAR( 10) NULL
,RPBDT DATETIME NULL
,RPSDT DATETIME NULL
,RPEDT DATETIME NULL
,RPSLY INT DEFAULT 0
,RPAMT INT DEFAULT 0
,RPFMY INT DEFAULT 0
,RPFM1 INT DEFAULT 0
,RPFM2 INT DEFAULT 0
,RPFM3 INT DEFAULT 0
,RPSLA INT DEFAULT 0
,RPDIS VARCHAR( 1) NULL
,RPDIH VARCHAR( 1) NULL
,RPOLD VARCHAR( 1) NULL
,RPNAT VARCHAR( 1) NULL
,RPPTP VARCHAR( 1) NULL
,RPLIS VARCHAR( 1) NULL
,RPHIS VARCHAR( 1) NULL
,RPDOC NVARCHAR(254) NULL
,APPNO INT DEFAULT 0
);
-- ¼W¥[Á~¸ê±ø¾ú¥vÀÉ
CREATE TABLE [dbo].[SSMB](
[TRDAT] [datetime] NULL,
[TRMOD] [varchar](12) NULL,
[TRUSR] [varchar](10) NULL,
[SSYMM] [datetime] NOT NULL,
[SSENO] [nvarchar](10) NOT NULL,
[SSNUM] [nvarchar](10) NULL,
[SSPYN] [nvarchar](10) NOT NULL,
[SSJNO] [varchar](2) NULL,
[SSCNO] [varchar](2) NULL,
[SSBRH] [nvarchar](50) NULL,
[SSD01] [int] NOT NULL DEFAULT (0),
[SSD02] [int] NOT NULL DEFAULT (0),
[SSSRD] [int] NOT NULL DEFAULT (0),
[SSP00] [int] NOT NULL DEFAULT (0),
[SSP01] [int] NOT NULL DEFAULT (0),
[SSP02] [int] NOT NULL DEFAULT (0),
[SSP03] [int] NOT NULL DEFAULT (0),
[SSP04] [int] NOT NULL DEFAULT (0),
[SSP05] [int] NOT NULL DEFAULT (0),
[SSP06] [int] NOT NULL DEFAULT (0),
[SSP07] [int] NOT NULL DEFAULT (0),
[SSP08] [int] NOT NULL DEFAULT (0),
[SSP09] [int] NOT NULL DEFAULT (0),
[SSP10] [int] NOT NULL DEFAULT (0),
[SSP11] [int] NOT NULL DEFAULT (0),
[SSP12] [int] NOT NULL DEFAULT (0),
[SSP13] [int] NOT NULL DEFAULT (0),
[SSP14] [int] NOT NULL DEFAULT (0),
[SSP15] [int] NOT NULL DEFAULT (0),
[SSP99] [int] NOT NULL DEFAULT (0),
[SSS01] [int] NOT NULL DEFAULT (0),
[SSS02] [int] NOT NULL DEFAULT (0),
[SSS03] [int] NOT NULL DEFAULT (0),
[SSS04] [int] NOT NULL DEFAULT (0),
[SSS05] [int] NOT NULL DEFAULT (0),
[SSS06] [int] NOT NULL DEFAULT (0),
[SSS07] [int] NOT NULL DEFAULT (0),
[SSS08] [int] NOT NULL DEFAULT (0),
[SSS09] [int] NOT NULL DEFAULT (0),
[SSS10] [int] NOT NULL DEFAULT (0),
[SSS11] [int] NOT NULL DEFAULT (0),
[SSS12] [int] NOT NULL DEFAULT (0),
[SSS13] [int] NOT NULL DEFAULT (0),
[SSS14] [int] NOT NULL DEFAULT (0),
[SSS15] [int] NOT NULL DEFAULT (0),
[SSS99] [int] NOT NULL DEFAULT (0),
[SSH01] [int] NOT NULL DEFAULT (0),
[SSH02] [int] NOT NULL DEFAULT (0),
[SSH03] [int] NOT NULL DEFAULT (0),
[SSH04] [int] NOT NULL DEFAULT (0),
[SSH05] [int] NOT NULL DEFAULT (0),
[SSH06] [int] NOT NULL DEFAULT (0),
[SSH07] [int] NOT NULL DEFAULT (0),
[SSH08] [int] NOT NULL DEFAULT (0),
[SSH09] [int] NOT NULL DEFAULT (0),
[SSH10] [int] NOT NULL DEFAULT (0),
[SST01] [int] NOT NULL DEFAULT (0),
[SST02] [int] NOT NULL DEFAULT (0),
[SST03] [int] NOT NULL DEFAULT (0),
[SST04] [int] NOT NULL DEFAULT (0),
[SST05] [int] NOT NULL DEFAULT (0),
[SST06] [int] NOT NULL DEFAULT (0),
[SST07] [int] NOT NULL DEFAULT (0),
[SST08] [int] NOT NULL DEFAULT (0),
[SST09] [int] NOT NULL DEFAULT (0),
[SST10] [int] NOT NULL DEFAULT (0),
[SST11] [int] NOT NULL DEFAULT (0),
[SST12] [int] NOT NULL DEFAULT (0),
[SST13] [int] NOT NULL DEFAULT (0),
[SST14] [int] NOT NULL DEFAULT (0),
[SST15] [int] NOT NULL DEFAULT (0),
[SST16] [int] NOT NULL DEFAULT (0),
[SST17] [int] NOT NULL DEFAULT (0),
[SST18] [int] NOT NULL DEFAULT (0),
[SST19] [int] NOT NULL DEFAULT (0),
[SST20] [int] NOT NULL DEFAULT (0),
[SSL01] [int] NOT NULL DEFAULT (0),
[SSL02] [int] NOT NULL DEFAULT (0),
[SSL03] [int] NOT NULL DEFAULT (0),
[SSL04] [int] NOT NULL DEFAULT (0),
[SSL05] [int] NOT NULL DEFAULT (0),
[SSC01] [nvarchar](254) NULL,
[SSC02] [nvarchar](254) NULL,
[SSC03] [nvarchar](254) NULL,
[SSC04] [nvarchar](254) NULL,
[SSC05] [nvarchar](254) NULL,
[SSC06] [nvarchar](254) NULL,
[SSC07] [nvarchar](254) NULL,
[SSC08] [nvarchar](254) NULL,
[SSC09] [nvarchar](254) NULL,
[SSC10] [nvarchar](254) NULL,
CONSTRAINT [PK_SSMB] PRIMARY KEY CLUSTERED
(
[SSYMM] ASC,
[SSENO] ASC,
[SSPYN] ASC
) ON [PRIMARY]
) ON [PRIMARY]
ALTER TABLE UBWCPI ADD TRDAT DATETIME NULL ;
ALTER TABLE UBWCPI ADD TRMOD VARCHAR(12) NULL ;
ALTER TABLE UBWCPI ADD TRUSR VARCHAR(10) NULL ;
ALTER TABLE UBWCPI ADD TRVER INT DEFAULT 0 ;
ALTER TABLE UBWCPT ADD TRDAT DATETIME NULL ;
ALTER TABLE UBWCPT ADD TRMOD VARCHAR(12) NULL ;
ALTER TABLE UBWCPT ADD TRUSR VARCHAR(10) NULL ;
ALTER TABLE UBWCPT ADD TRVER INT DEFAULT 0 ;
-- 4/11 §ó¥¿ ¦Ü 9612 ¤î­û¤u¦Û´£²Ö­p
UPDATE SSMS SET SSS06=16819 WHERE SSYMM='2007/12/31' AND SSENO='00045' AND SSPYN='TY' --§d«Ø»Ê
UPDATE SSMS SET SSS06=19080 WHERE SSYMM='2007/12/31' AND SSENO='00025' AND SSPYN='TY' --¬_¬ü¥É
UPDATE SSMS SET SSS06=10081 WHERE SSYMM='2007/12/31' AND SSENO='00138' AND SSPYN='TY' --¬x«TµÓ
UPDATE SSMS SET SSS06=8459 WHERE SSYMM='2007/12/31' AND SSENO='00181' AND SSPYN='TY' --§d¬Õ¦p
UPDATE SSMS SET SSS06=10081 WHERE SSYMM='2007/12/31' AND SSENO='00145' AND SSPYN='TY' --¤ý¸ÖµÓ
UPDATE SSMS SET SSS06=21112 WHERE SSYMM='2007/12/31' AND SSENO='00144' AND SSPYN='TY' --ªL¶²Ä«
UPDATE SSMS SET SSS06=0 WHERE SSYMM='2007/12/31' AND SSENO='00147' AND SSPYN='TY' --¾G¯Àªâ
UPDATE SSMS SET SSS06=0 WHERE SSYMM='2007/12/31' AND SSENO='00227' AND SSPYN='TY' --§õ®Ñʹ
UPDATE SSMS SET SSS06=0 WHERE SSYMM='2007/12/31' AND SSENO='00153' AND SSPYN='TY' --¤ý¨`­^
UPDATE SSMS SET SSS06=0 WHERE SSYMM='2007/12/31' AND SSENO='00244' AND SSPYN='TY' --ªL¤ë¶³
UPDATE SSMB SET SSS06=16819 WHERE SSYMM='2007/12/31' AND SSENO='00045' AND SSPYN='TY' --§d«Ø»Ê
UPDATE SSMB SET SSS06=19080 WHERE SSYMM='2007/12/31' AND SSENO='00025' AND SSPYN='TY' --¬_¬ü¥É
UPDATE SSMB SET SSS06=10081 WHERE SSYMM='2007/12/31' AND SSENO='00138' AND SSPYN='TY' --¬x«TµÓ
UPDATE SSMB SET SSS06=8459 WHERE SSYMM='2007/12/31' AND SSENO='00181' AND SSPYN='TY' --§d¬Õ¦p
UPDATE SSMB SET SSS06=10081 WHERE SSYMM='2007/12/31' AND SSENO='00145' AND SSPYN='TY' --¤ý¸ÖµÓ
UPDATE SSMB SET SSS06=21112 WHERE SSYMM='2007/12/31' AND SSENO='00144' AND SSPYN='TY' --ªL¶²Ä«
UPDATE SSMB SET SSS06=0 WHERE SSYMM='2007/12/31' AND SSENO='00147' AND SSPYN='TY' --¾G¯Àªâ
UPDATE SSMB SET SSS06=0 WHERE SSYMM='2007/12/31' AND SSENO='00227' AND SSPYN='TY' --§õ®Ñʹ
UPDATE SSMB SET SSS06=0 WHERE SSYMM='2007/12/31' AND SSENO='00153' AND SSPYN='TY' --¤ý¨`­^
UPDATE SSMB SET SSS06=0 WHERE SSYMM='2007/12/31' AND SSENO='00244' AND SSPYN='TY' --ªL¤ë¶³
-- 4/22 ¼W¥[¥[¯Z¶O­pºâ¤è¦¡Äæ¦ì
ALTER TABLE BPRJ ADD BPOVR VARCHAR( 1) NOT NULL DEFAULT '1';
UPDATE BPRJ SET BPOVR='1';
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPRJOVR','1','¥|±Ë¤­¤J')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPRJOVR','2','µL±ø¥ó±Ë¥h')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPRJOVR','3','µL±ø¥ó¶i¦ì')
-- 4/29 ¼W¥[¥[¯Z¶O­pºâ¤è¦¡Ãþ§O
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPRJOVR','4','«O«ù­ì¼Æ')
-- 5/4 ¼W¥[­û¤uÁ~¸ê¸ê®Æªí¡A¥H¤Î­û¤uÁ~¸ê¸ê®Æ²§°Êªí
CREATE TABLE BPSL
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,BPENO NVARCHAR( 10) not NULL
,BPSRM INT DEFAULT 0
,BPSRD INT DEFAULT 0
,BPP01 INT DEFAULT 0
,BPP02 INT DEFAULT 0
,BPP03 INT DEFAULT 0
,BPP04 INT DEFAULT 0
,BPP05 INT DEFAULT 0
,APPNO INT DEFAULT 0
);
ALTER TABLE BPSL ADD CONSTRAINT PK_BPSL PRIMARY KEY (BPENO);
CREATE TABLE RPSL
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,RPENO NVARCHAR( 10) not NULL
,RPITM INT not NULL
,RPBDT DATETIME NULL
,RPSRM INT DEFAULT 0
,RPSRD INT DEFAULT 0
,RPP01 INT DEFAULT 0
,RPP02 INT DEFAULT 0
,RPP03 INT DEFAULT 0
,RPP04 INT DEFAULT 0
,RPP05 INT DEFAULT 0
,APPNO INT DEFAULT 0
);
ALTER TABLE RPSL ADD CONSTRAINT PK_RPSL PRIMARY KEY (RPENO,RPITM);
-- 5/9 ¥[¤jÁ~¸ê¶×Á`¥H¤ÎÁ~¸ê±ø³Æ¥÷ÀɳƵùÄæ¦ì
ALTER TABLE SSMS ALTER COLUMN SSC01 NVARCHAR(4000)
ALTER TABLE SSMS ALTER COLUMN SSC02 NVARCHAR(4000)
ALTER TABLE SSMS ALTER COLUMN SSC03 NVARCHAR(4000)
ALTER TABLE SSMS ALTER COLUMN SSC04 NVARCHAR(4000)
ALTER TABLE SSMS ALTER COLUMN SSC05 NVARCHAR(4000)
ALTER TABLE SSMS ALTER COLUMN SSC06 NVARCHAR(4000)
ALTER TABLE SSMS ALTER COLUMN SSC07 NVARCHAR(4000)
ALTER TABLE SSMS ALTER COLUMN SSC08 NVARCHAR(4000)
ALTER TABLE SSMS ALTER COLUMN SSC09 NVARCHAR(4000)
ALTER TABLE SSMS ALTER COLUMN SSC10 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC01 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC02 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC03 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC04 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC05 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC06 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC07 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC08 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC09 NVARCHAR(4000)
ALTER TABLE SSMB ALTER COLUMN SSC10 NVARCHAR(4000)
-- 6/3 ¥[¤j±M®×ÀÉ¥[¯Z¶O­pºâ¥H¤Î¼W¥[½Ð°²¦©´Ú­pºâ¤½¦¡Äæ¦ì
ALTER TABLE BPRJ ALTER COLUMN BPOVR VARCHAR(4) ;
ALTER TABLE BPRJ ADD BPLVE VARCHAR(4) NOT NULL DEFAULT '';
CREATE TABLE BFRM
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,BFNUM VARCHAR( 4) not NULL
,BFNAM NVARCHAR( 50) NULL
,BFFRM NVARCHAR(254) NULL
,APPNO INT DEFAULT 0
);
ALTER TABLE BFRM ADD CONSTRAINT PK_BFRM PRIMARY KEY (BFNUM);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/3','INSERT','X001','A001','¥[¯Z¶O (¥|±Ë¤­¤J«á¦A¥[Á`)','ROUND(ROUND(ROUND(@¥»Á~/240, 0) + @¥ë­¹¶O/240, 0) * @¥[¯Z¶O¤ñ¨Ò * @®É¼Æ, 0)',1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/3','INSERT','X001','A002','¥[¯Z¶O (¥[Á`«á¦A¥|±Ë¤­¤J)','ROUND(ROUND(@¥»Á~/240, 0) + @¥ë­¹¶O/240, 0) * @¥[¯Z¶O¤ñ¨Ò * @®É¼Æ',1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/3','INSERT','X001','B001','½Ð°²¦©´Ú (®ÉÁ~¥|±Ë¤­¤J)','ROUND(ROUND(ROUND(@¥»Á~/240, 0) + @¥ë­¹¶O/240, 0) * @®É¼Æ, 0)',1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/3','INSERT','X001','B002','½Ð°²¦©´Ú (®ÉÁ~¤£¥|±Ë¤­¤J)','ROUND((ROUND(@¥»Á~/240, 0) + @¥ë­¹¶O/240) * @®É¼Æ, 0)',1);
UPDATE BPRJ SET BPLVE='B001';
UPDATE BPRJ SET BPOVR='A001' WHERE BPOVR='1';
UPDATE BPRJ SET BPOVR='A002' WHERE BPOVR='4';
-- 6/4 ­×§ï¤½¦¡
DELETE FROM BFRM
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/4','INSERT','X001','A001','¥_°ò¥[¯Z¶O','ROUND((@¥»Á~/240 + @¥ë­¹¶O/240) * @¥[¯Z¶O¤ñ¨Ò, 0) * @®É¼Æ', 1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/4','INSERT','X001','A002','®ç¦Ë­]¥[¯Z¶O','ROUND((@¥»Á~/240 + @¥ë­¹¶O/240) * @¥[¯Z¶O¤ñ¨Ò, 0) * @®É¼Æ', 1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/4','INSERT','X001','A003','¤¤¹ü¥[¯Z¶O','ROUND(CEILING(@¥»Á~/240 + @¥ë­¹¶O/240) * @¥[¯Z¶O¤ñ¨Ò * @®É¼Æ, 0)',1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/4','INSERT','X001','B001','¥_°ò½Ð°²¦©´Ú','ROUND(CEILING(@¥»Á~/240 + @¥ë­¹¶O/240) * @®É¼Æ, 0)',1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/4','INSERT','X001','B002','®ç¦Ë­]½Ð°²¦©´Ú','ROUND((@¥»Á~/240 + @¥ë­¹¶O/240) * @®É¼Æ, 0)',1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/4','INSERT','X001','B003','¤¤¹ü½Ð°²¦©´Ú','ROUND(CEILING(@¥»Á~/240 + @¥ë­¹¶O/240) * @®É¼Æ, 0)',1);
-- 7/1 ­×§ï 96/12 ¤½¥q²Ö­p³Ò°hª÷ÃB
DELETE FROM SSMS WHERE SSYMM='2007/12/31' AND SSPYN='TY'
DELETE FROM SSMB WHERE SSYMM='2007/12/31' AND SSPYN='TY'
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00001', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00002', 34113, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00003', 34113, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00005', 25682, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00006', 34686, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00007', 19189, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00011', 45621, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00012', 45821, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00014', 33962, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00016', 41467, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00017', 37015, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00018', 31037, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00019', 20976, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00021', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00023', 21560, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00025', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00026', 39941, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00027', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00028', 25628, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00030', 41976, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00033', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00034', 47798, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00036', 44329, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00037', 45728, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00038', 42683, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00039', 47438, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00040', 44838, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00043', 42593, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00045', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00046', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00047', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00048', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00049', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00050', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00053', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00054', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00055', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00057', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00058', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00059', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00060', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00061', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00062', 22684, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00063', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00064', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00065', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00066', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00067', 24259, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00068', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00069', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00070', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00072', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00073', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00074', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00075', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00076', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00077', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00080', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00081', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00082', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00083', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00084', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00085', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00087', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00088', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00089', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00090', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00091', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00092', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00093', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00094', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00095', 26816, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00096', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00097', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00098', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00101', 22594, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00102', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00103', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00106', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00107', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00109', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00111', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00112', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00113', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00114', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00115', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00116', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00118', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00119', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00121', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00122', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00124', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00126', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00127', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00128', 23377, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00129', 21118, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00130', 22324, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00132', 20218, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00133', 23976, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00134', 23976, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00135', 21751, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00138', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00139', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00144', 23976, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00145', 46042, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00146', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00147', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00148', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00152', 23976, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00153', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00154', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00155', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00157', 21816, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00158', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00160', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00163', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00164', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00165', 21497, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00166', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00170', 23976, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00173', 22896, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00174', 19872, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00176', 23976, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00178', 24031, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00179', 15840, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00181', 20734, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00182', 12207, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00183', 19080, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00185', 17299, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00186', 17808, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00187', 14566, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00188', 13860, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00190', 16646, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00191', 17108, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00193', 16661, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00195', 14544, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00196', 14882, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00198', 15264, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00199', 15264, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00201', 17648, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00202', 13165, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00203', 12096, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00204', 13986, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00205', 13356, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00206', 12542, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00207', 10939, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00208', 10856, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00209', 9476, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00210', 9095, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00212', 6970, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00215', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00216', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00217', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00218', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00219', 5851, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00220', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00222', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00223', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00224', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00225', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00226', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00227', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00228', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00229', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00230', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00231', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00232', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00233', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00234', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00235', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00236', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00238', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00240', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00241', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00242', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00243', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00244', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00246', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00247', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00248', 0, 0)
INSERT INTO SSMS (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00249', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00001', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00002', 34113, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00003', 34113, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00005', 25682, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00006', 34686, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00007', 19189, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00011', 45621, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00012', 45821, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00014', 33962, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00016', 41467, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00017', 37015, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00018', 31037, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00019', 20976, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00021', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00023', 21560, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00025', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00026', 39941, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00027', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00028', 25628, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00030', 41976, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00033', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00034', 47798, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00036', 44329, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00037', 45728, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00038', 42683, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00039', 47438, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00040', 44838, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00043', 42593, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00045', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00046', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00047', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00048', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00049', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00050', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00053', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00054', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00055', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00057', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00058', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00059', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00060', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00061', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00062', 22684, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00063', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00064', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00065', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00066', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00067', 24259, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00068', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00069', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00070', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00072', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00073', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00074', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00075', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00076', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00077', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00080', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00081', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00082', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00083', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00084', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00085', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00087', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00088', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00089', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00090', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00091', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00092', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00093', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00094', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00095', 26816, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00096', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00097', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00098', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00101', 22594, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00102', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00103', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00106', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00107', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00109', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00111', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00112', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00113', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00114', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00115', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00116', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00118', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00119', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00121', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00122', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00124', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00126', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00127', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00128', 23377, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00129', 21118, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00130', 22324, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00132', 20218, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00133', 23976, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00134', 23976, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00135', 21751, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00138', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00139', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00144', 23976, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00145', 46042, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00146', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00147', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00148', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00152', 23976, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00153', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00154', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00155', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00157', 21816, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00158', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00160', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00163', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00164', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00165', 21497, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00166', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00170', 23976, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00173', 22896, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00174', 19872, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00176', 23976, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00178', 24031, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00179', 15840, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00181', 20734, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00182', 12207, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00183', 19080, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00185', 17299, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00186', 17808, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00187', 14566, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00188', 13860, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00190', 16646, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00191', 17108, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00193', 16661, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00195', 14544, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00196', 14882, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00198', 15264, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00199', 15264, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00201', 17648, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00202', 13165, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00203', 12096, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00204', 13986, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00205', 13356, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00206', 12542, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00207', 10939, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00208', 10856, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00209', 9476, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00210', 9095, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00212', 6970, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00215', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00216', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00217', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00218', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00219', 5851, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00220', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00222', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00223', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00224', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00225', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00226', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00227', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00228', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00229', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00230', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00231', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00232', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00233', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00234', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00235', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00236', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00238', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00240', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00241', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00242', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00243', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00244', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00246', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00247', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00248', 0, 0)
INSERT INTO SSMB (SSYMM, SSPYN, SSENO, SSH06, SSS06) VALUES ('2007/12/31', 'TY', '00249', 0, 0)
-- 7/2 ¼W¥[¤H­û¬£»º²§°Ê¸ê®Æ
CREATE TABLE RASB
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,RANUM NVARCHAR( 10) not NULL
,RAITM INT not NULL
,RBITM INT not NULL
,RBBDT DATETIME NULL
,RACNM NVARCHAR( 10) NULL
,RAPYN NVARCHAR( 10) NULL
,RASDT DATETIME NULL
,RAEDT DATETIME NULL
,RAJNO VARCHAR( 2) NULL
,RACNO VARCHAR( 2) NULL
,RABRH NVARCHAR( 4) NULL
,RAS01 FLOAT DEFAULT 0
,APPNO INT DEFAULT 0
);
ALTER TABLE RASB ADD CONSTRAINT PK_RASB PRIMARY KEY (RANUM,RAITM,RBITM);
-- 7/7 ¼W¥[¾¨a«O¶O¶O²v³]©w¸ê®Æ
CREATE TABLE BIJT
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,BIIDN VARCHAR( 4) not NULL
,BIRTE FLOAT DEFAULT 0
,BISDT DATETIME NULL
,BIEDT DATETIME NULL
,APPNO INT DEFAULT 0
);
ALTER TABLE BIJT ADD CONSTRAINT PK_BIJT PRIMARY KEY (BIIDN);
INSERT INTO BIJT (BIIDN, BIRTE, BISDT, BIEDT, APPNO) VALUES ('0001', 0.001, '1899/12/31', '2008/6/30', 1)
INSERT INTO BIJT (BIIDN, BIRTE, BISDT, BIEDT, APPNO) VALUES ('0002', 0.0009, '2008/7/1', NULL, 1)
-- 7/25 ¼W¥[­û¤u¸ê®Æ¾Ç¾úÄæ¦ì
ALTER TABLE BPSN ADD BPSTP VARCHAR( 1) NULL;
ALTER TABLE BPSN ADD BPST2 VARCHAR( 1) NULL;
ALTER TABLE BPSN ADD BPSC2 NVARCHAR( 20) NULL;
ALTER TABLE BPSN ADD BPSU2 NVARCHAR( 20) NULL;
ALTER TABLE BPSN ADD BPSG2 VARCHAR( 1) NULL;
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BPSNSTP', '3', '°ª¤¤Â¾', '2008/7/25', 'INSERT', 'X001')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BPSNSTP', '4', '±M¬ì', '2008/7/25', 'INSERT', 'X001')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BPSNSTP', '5', '¤j¾Ç', '2008/7/25', 'INSERT', 'X001')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BPSNSTP', '6', '¬ã¨s©Ò', '2008/7/25', 'INSERT', 'X001')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BPSNSTP', '7', '³Õ¤h¯Z', '2008/7/25', 'INSERT', 'X001')
-- 12/23 ¯Å¶Zª©¥»ªí BFDT ¼W¥[³ÆµùÄæ¦ì
ALTER TABLE BFDT ADD BFRMK VARCHAR(20)
GO
UPDATE BFDT SET BFRMK='³Ò«O¶O' WHERE BFTYP=1
UPDATE BFDT SET BFRMK='°·«O¶O' WHERE BFTYP=2
UPDATE BFDT SET BFRMK='³Ò°h¦Û´£' WHERE BFTYP=3
-- 12/31 ¼W¥[¶O²vªí¬[ºc
CREATE TABLE BRTE
(
TRDAT DATETIME NULL,
TRMOD VARCHAR(12) NULL,
TRUSR VARCHAR(10) NULL,
BRTYP VARCHAR(30) NOT NULL,
BRVER SMALLINT NOT NULL,
BRRTE NUMERIC(10, 8) NOT NULL,
BRSDT DATETIME NULL,
BREDT DATETIME NULL,
APPNO INT NOT NULL
);
ALTER TABLE BRTE ADD CONSTRAINT PK_BRTE PRIMARY KEY (BRTYP, BRVER);
GO
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2008/12/31', 'INSERT', 'X001', 'ºÖ§Qª÷', 1, 0.005, '2008/02/01', NULL, 1)
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2008/12/31', 'INSERT', 'X001', '³Ò«O¾·~¨a®`', 1, 0.001, '1899/12/31', '2008/06/30', 1)
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2008/12/31', 'INSERT', 'X001', '³Ò«O¾·~¨a®`', 2, 0.0009, '2008/07/01', NULL, 1)
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2008/12/31', 'INSERT', 'X001', '³Ò«O´¶³q¶Ë¯f', 1, 0.055, '1899/12/31', '2008/12/31', 1)
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2008/12/31', 'INSERT', 'X001', '³Ò«O´¶³q¶Ë¯f', 2, 0.065, '2009/01/01', NULL, 1)
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2008/12/31', 'INSERT', 'X001', '³Ò«O´N·~«OÀI', 1, 0.01, '1899/12/31', NULL, 1)
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2008/12/31', 'INSERT', 'X001', '³Ò«O¤u¸ê¹ÔÀv', 1, 0.00025, '1899/12/31', NULL, 1)
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2008/12/31', 'INSERT', 'X001', '°·«O', 1, 0.0455, '1899/12/31', NULL, 1)
-- 1/12 §R°£¤£¥²­nªº BWEX ¸ê®Æ¡A¨Ã¥[¤J§Kµ|ÃB«×³]©w
DELETE FROM BWEX WHERE BSNUM<>'UNMWETA'
INSERT INTO BWEX (BSNUM, BSITM, BSNAM) VALUES ('UNBONUSTAXFREE', ' 1', '2000')
-- 1/20 ½Æ»s 97 ¦~±M®×¦Ü 98 ¦~
-- BPAA
INSERT INTO BPAA
(BPPNM, BPYER, BPPYN, BPPYM, BPBGT, BPCSD, BPMSD, BPS01, BPS02, BPS03,
BPS04, BPS05, BPS06, BPS07, BPS08, BPS09, BPS10, BPS11, BPS12, BPS13,
BPS14, BPS15, BPS16, BPS17, BPS18, BPS19, BPS20, BPS21, BPS22, BPS23,
BPS24, BPS25, BPS26, BPS27, BPS28, BPS29, BPS30, BPFED, APPNO, TRDAT,
TRMOD, TRUSR)
SELECT
BPPNM, 98, '098AGJ001', '¤E¤Q¤K¦~­Ó®×ºÞ²zº[¯S©w¹ï¶H´N·~ªA°È¬ÛÃö¤u§@³Ò°È»Ý¨D­pµe', BPBGT, BPCSD, BPMSD, BPS01, BPS02, BPS03,
BPS04, BPS05, BPS06, BPS07, BPS08, BPS09, BPS10, BPS11, BPS12, BPS13,
BPS14, BPS15, BPS16, BPS17, BPS18, BPS19, BPS20, BPS21, BPS22, BPS23,
BPS24, BPS25, BPS26, BPS27, BPS28, BPS29, BPS30, BPFED, APPNO, TRDAT,
TRMOD, TRUSR
FROM BPAA
WHERE BPPYN='097AGJ001'
INSERT INTO BPAA
(BPPNM, BPYER, BPPYN, BPPYM, BPBGT, BPCSD, BPMSD, BPS01, BPS02, BPS03,
BPS04, BPS05, BPS06, BPS07, BPS08, BPS09, BPS10, BPS11, BPS12, BPS13,
BPS14, BPS15, BPS16, BPS17, BPS18, BPS19, BPS20, BPS21, BPS22, BPS23,
BPS24, BPS25, BPS26, BPS27, BPS28, BPS29, BPS30, BPFED, APPNO, TRDAT,
TRMOD, TRUSR)
SELECT
BPPNM, 98, '098CGJ001', '¤E¤Q¤K¦~¯S©w¹ï¶H´N·~ªA°È­û³Ò°È»Ý¨D­pµe', BPBGT, BPCSD, BPMSD, BPS01, BPS02, BPS03,
BPS04, BPS05, BPS06, BPS07, BPS08, BPS09, BPS10, BPS11, BPS12, BPS13,
BPS14, BPS15, BPS16, BPS17, BPS18, BPS19, BPS20, BPS21, BPS22, BPS23,
BPS24, BPS25, BPS26, BPS27, BPS28, BPS29, BPS30, BPFED, APPNO, TRDAT,
TRMOD, TRUSR
FROM BPAA
WHERE BPPYN='097CGJ001'
INSERT INTO BPAA
(BPPNM, BPYER, BPPYN, BPPYM, BPBGT, BPCSD, BPMSD, BPS01, BPS02, BPS03,
BPS04, BPS05, BPS06, BPS07, BPS08, BPS09, BPS10, BPS11, BPS12, BPS13,
BPS14, BPS15, BPS16, BPS17, BPS18, BPS19, BPS20, BPS21, BPS22, BPS23,
BPS24, BPS25, BPS26, BPS27, BPS28, BPS29, BPS30, BPFED, APPNO, TRDAT,
TRMOD, TRUSR)
SELECT
BPPNM, 98, '098CGJ003', '¤E¤Q¤K¦~´N·~ªA°È¬ÛÃö¤u§@³Ò°È»Ý¨D­pµe', BPBGT, BPCSD, BPMSD, BPS01, BPS02, BPS03,
BPS04, BPS05, BPS06, BPS07, BPS08, BPS09, BPS10, BPS11, BPS12, BPS13,
BPS14, BPS15, BPS16, BPS17, BPS18, BPS19, BPS20, BPS21, BPS22, BPS23,
BPS24, BPS25, BPS26, BPS27, BPS28, BPS29, BPS30, BPFED, APPNO, TRDAT,
TRMOD, TRUSR
FROM BPAA
WHERE BPPYN='097CGJ003'
INSERT INTO BPAA
(BPPNM, BPYER, BPPYN, BPPYM, BPBGT, BPCSD, BPMSD, BPS01, BPS02, BPS03,
BPS04, BPS05, BPS06, BPS07, BPS08, BPS09, BPS10, BPS11, BPS12, BPS13,
BPS14, BPS15, BPS16, BPS17, BPS18, BPS19, BPS20, BPS21, BPS22, BPS23,
BPS24, BPS25, BPS26, BPS27, BPS28, BPS29, BPS30, BPFED, APPNO, TRDAT,
TRMOD, TRUSR)
SELECT
BPPNM, 98, '098CGJ004', '¤E¤Q¤K¦~´N·~ªA°È¥~®i¤u§@­pµe(´N·~¦h¶ý¶ý)', BPBGT, BPCSD, BPMSD, BPS01, BPS02, BPS03,
BPS04, BPS05, BPS06, BPS07, BPS08, BPS09, BPS10, BPS11, BPS12, BPS13,
BPS14, BPS15, BPS16, BPS17, BPS18, BPS19, BPS20, BPS21, BPS22, BPS23,
BPS24, BPS25, BPS26, BPS27, BPS28, BPS29, BPS30, BPFED, APPNO, TRDAT,
TRMOD, TRUSR
FROM BPAA
WHERE BPPYN='097CGJ004'
-- BPAB
INSERT INTO BPAB
(BPPYN, BPACC, BPAME, BPBGT, BPCLS, BPORD, BPDOC, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098AGJ001', BPACC, BPAME, BPBGT, BPCLS, BPORD, BPDOC, APPNO, TRDAT, TRMOD, TRUSR
FROM BPAB
WHERE BPPYN='097AGJ001'
INSERT INTO BPAB
(BPPYN, BPACC, BPAME, BPBGT, BPCLS, BPORD, BPDOC, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098CGJ001', BPACC, BPAME, BPBGT, BPCLS, BPORD, BPDOC, APPNO, TRDAT, TRMOD, TRUSR
FROM BPAB
WHERE BPPYN='097CGJ001'
INSERT INTO BPAB
(BPPYN, BPACC, BPAME, BPBGT, BPCLS, BPORD, BPDOC, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098CGJ003', BPACC, BPAME, BPBGT, BPCLS, BPORD, BPDOC, APPNO, TRDAT, TRMOD, TRUSR
FROM BPAB
WHERE BPPYN='097CGJ003'
INSERT INTO BPAB
(BPPYN, BPACC, BPAME, BPBGT, BPCLS, BPORD, BPDOC, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098CGJ004', BPACC, BPAME, BPBGT, BPCLS, BPORD, BPDOC, APPNO, TRDAT, TRMOD, TRUSR
FROM BPAB
WHERE BPPYN='097CGJ004'
-- BPJA
INSERT INTO BPJA
(BPPYN, BPJNO, BPJME, BPQTY, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098AGJ001', BPJNO, BPJME, BPQTY, APPNO, TRDAT, TRMOD, TRUSR
FROM BPJA
WHERE BPPYN='097AGJ001'
INSERT INTO BPJA
(BPPYN, BPJNO, BPJME, BPQTY, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098CGJ001', BPJNO, BPJME, BPQTY, APPNO, TRDAT, TRMOD, TRUSR
FROM BPJA
WHERE BPPYN='097CGJ001'
INSERT INTO BPJA
(BPPYN, BPJNO, BPJME, BPQTY, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098CGJ003', BPJNO, BPJME, BPQTY, APPNO, TRDAT, TRMOD, TRUSR
FROM BPJA
WHERE BPPYN='097CGJ003'
INSERT INTO BPJA
(BPPYN, BPJNO, BPJME, BPQTY, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098CGJ004', BPJNO, BPJME, BPQTY, APPNO, TRDAT, TRMOD, TRUSR
FROM BPJA
WHERE BPPYN='097CGJ004'
-- BPJB
INSERT INTO BPJB
(BPPYN, BPJNO, BPCNO, BPCME, BPSRM, BPSRD, BPP01, BPP02, BPP03, BPP04, BPP05, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098AGJ001', BPJNO, BPCNO, BPCME, BPSRM, BPSRD, BPP01, BPP02, BPP03, BPP04, BPP05, APPNO, TRDAT, TRMOD, TRUSR
FROM BPJB
WHERE BPPYN='097AGJ001'
INSERT INTO BPJB
(BPPYN, BPJNO, BPCNO, BPCME, BPSRM, BPSRD, BPP01, BPP02, BPP03, BPP04, BPP05, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098CGJ001', BPJNO, BPCNO, BPCME, BPSRM, BPSRD, BPP01, BPP02, BPP03, BPP04, BPP05, APPNO, TRDAT, TRMOD, TRUSR
FROM BPJB
WHERE BPPYN='097CGJ001'
INSERT INTO BPJB
(BPPYN, BPJNO, BPCNO, BPCME, BPSRM, BPSRD, BPP01, BPP02, BPP03, BPP04, BPP05, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098CGJ003', BPJNO, BPCNO, BPCME, BPSRM, BPSRD, BPP01, BPP02, BPP03, BPP04, BPP05, APPNO, TRDAT, TRMOD, TRUSR
FROM BPJB
WHERE BPPYN='097CGJ003'
INSERT INTO BPJB
(BPPYN, BPJNO, BPCNO, BPCME, BPSRM, BPSRD, BPP01, BPP02, BPP03, BPP04, BPP05, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
'098CGJ004', BPJNO, BPCNO, BPCME, BPSRM, BPSRD, BPP01, BPP02, BPP03, BPP04, BPP05, APPNO, TRDAT, TRMOD, TRUSR
FROM BPJB
WHERE BPPYN='097CGJ004'
-- RASN
INSERT INTO dbo.RASN
(RANUM, RAITM, RACNM, RAPYN, RASDT, RAEDT, RAJNO, RACNO, RABRH, RAS01, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
A.RANUM, (SELECT MAX(B.RAITM) + 1 FROM RASN B WHERE B.RANUM=A.RANUM) RAITM, A.RACNM,
'098AGJ001', '2009/01/01', NULL, A.RAJNO, A.RACNO, A.RABRH, A.RAS01, A.APPNO, A.TRDAT, A.TRMOD, A.TRUSR
FROM RASN A
WHERE RAPYN='097AGJ001' AND A.RAEDT IS NULL
INSERT INTO dbo.RASN
(RANUM, RAITM, RACNM, RAPYN, RASDT, RAEDT, RAJNO, RACNO, RABRH, RAS01, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
A.RANUM, (SELECT MAX(B.RAITM) + 1 FROM RASN B WHERE B.RANUM=A.RANUM) RAITM, A.RACNM,
'098CGJ001', '2009/01/01', NULL, A.RAJNO, A.RACNO, A.RABRH, A.RAS01, A.APPNO, A.TRDAT, A.TRMOD, A.TRUSR
FROM RASN A
WHERE RAPYN='097CGJ001' AND A.RAEDT IS NULL
INSERT INTO dbo.RASN
(RANUM, RAITM, RACNM, RAPYN, RASDT, RAEDT, RAJNO, RACNO, RABRH, RAS01, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
A.RANUM, (SELECT MAX(B.RAITM) + 1 FROM RASN B WHERE B.RANUM=A.RANUM) RAITM, A.RACNM,
'098CGJ003', '2009/01/01', NULL, A.RAJNO, A.RACNO, A.RABRH, A.RAS01, A.APPNO, A.TRDAT, A.TRMOD, A.TRUSR
FROM RASN A
WHERE RAPYN='097CGJ003' AND A.RAEDT IS NULL
INSERT INTO dbo.RASN
(RANUM, RAITM, RACNM, RAPYN, RASDT, RAEDT, RAJNO, RACNO, RABRH, RAS01, APPNO, TRDAT, TRMOD, TRUSR)
SELECT
A.RANUM, (SELECT MAX(B.RAITM) + 1 FROM RASN B WHERE B.RANUM=A.RANUM) RAITM, A.RACNM,
'098CGJ004', '2009/01/01', NULL, A.RAJNO, A.RACNO, A.RABRH, A.RAS01, A.APPNO, A.TRDAT, A.TRMOD, A.TRUSR
FROM RASN A
WHERE RAPYN='097CGJ004' AND A.RAEDT IS NULL
UPDATE RASN SET RAEDT='2008/12/31' WHERE RAPYN='097AGJ001' AND RAEDT IS NULL
UPDATE RASN SET RAEDT='2008/12/31' WHERE RAPYN='097CGJ001' AND RAEDT IS NULL
UPDATE RASN SET RAEDT='2008/12/31' WHERE RAPYN='097CGJ003' AND RAEDT IS NULL
UPDATE RASN SET RAEDT='2008/12/31' WHERE RAPYN='097CGJ004' AND RAEDT IS NULL
-- 2/2 ¼W¥[¾°V§½³æ¦ì
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0001', '¾·~°V½m§½')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0002', '®õ¤s¾·~°V½m¤¤¤ß')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0003', '¥_°Ï¾·~°V½m¤¤¤ß')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0004', '¤¤°Ï¾·~°V½m¤¤¤ß')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0005', '«n°Ï¾·~°V½m¤¤¤ß')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0006', '®ç¶é¾·~°V½m¤¤¤ß')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0007', '¥x«n¾·~°V½m¤¤¤ß')
-- 98/2/27 ¼W¥[ SSMS Äæ¦ì
ALTER TABLE SSMS ADD SSITM VARCHAR(3)
UPDATE SSMS SET SSITM='001'
USE [THINKYU_WEB_TY]
GO
/****** ª«¥ó: UserDefinedFunction [dbo].[SSMS_COMMENT] «ü¥O½X¤é´Á: 02/27/2009 09:48:57 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[SSMS_COMMENT]
(
@SSYMM DATETIME,
@SSENO NVARCHAR(10),
@SSPYN NVARCHAR(10),
@FIELDNAME VARCHAR(10)
)
RETURNS NVARCHAR(4000)
AS
BEGIN
DECLARE @RESULT NVARCHAR(4000)
SET @RESULT = ''
SELECT @RESULT =
CASE @FIELDNAME
WHEN 'SSC01' THEN @RESULT + ISNULL(SSC01, '')
WHEN 'SSC02' THEN @RESULT + ISNULL(SSC02, '')
WHEN 'SSC03' THEN @RESULT + ISNULL(SSC03, '')
WHEN 'SSC04' THEN @RESULT + ISNULL(SSC04, '')
WHEN 'SSC05' THEN @RESULT + ISNULL(SSC05, '')
WHEN 'SSC06' THEN @RESULT + ISNULL(SSC06, '')
WHEN 'SSC07' THEN @RESULT + ISNULL(SSC07, '')
WHEN 'SSC08' THEN @RESULT + ISNULL(SSC08, '')
WHEN 'SSC09' THEN @RESULT + ISNULL(SSC09, '')
WHEN 'SSC10' THEN @RESULT + ISNULL(SSC10, '')
END
FROM dbo.SSMS
WHERE SSYMM=@SSYMM
AND SSENO=@SSENO
AND SSPYN=@SSPYN
RETURN @RESULT
END
USE [THINKYU_WEB_TY]
GO
/****** ª«¥ó: UserDefinedFunction [dbo].[SSMS_DATETIMEFIELD] «ü¥O½X¤é´Á: 02/27/2009 09:49:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date, ,>
-- Description: <Description, ,>
-- =============================================
CREATE FUNCTION [dbo].[SSMS_DATETIMEFIELD]
(
@SSYMM DATETIME,
@SSENO NVARCHAR(10),
@SSPYN NVARCHAR(10),
@FIELDNAME VARCHAR(10)
)
RETURNS DATETIME
AS
BEGIN
DECLARE @RESULT DATETIME
SELECT @RESULT =
CASE @FIELDNAME
WHEN 'TRDAT' THEN (SELECT TOP 1 TRDAT FROM SSMS WHERE SSYMM=@SSYMM AND SSENO=@SSENO AND SSPYN=@SSPYN ORDER BY SSITM DESC)
END
RETURN @RESULT
END
USE [THINKYU_WEB_TY]
GO
/****** ª«¥ó: UserDefinedFunction [dbo].[SSMS_STRINGFIELD] «ü¥O½X¤é´Á: 02/27/2009 09:49:21 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author: <Author,,Name>
-- Create date: <Create Date, ,>
-- Description: <Description, ,>
-- =============================================
CREATE FUNCTION [dbo].[SSMS_STRINGFIELD]
(
@SSYMM DATETIME,
@SSENO NVARCHAR(10),
@SSPYN NVARCHAR(10),
@FIELDNAME VARCHAR(10)
)
RETURNS NVARCHAR(50)
AS
BEGIN
DECLARE @RESULT NVARCHAR(50)
SELECT @RESULT =
CASE @FIELDNAME
WHEN 'TRMOD' THEN (SELECT TOP 1 TRMOD FROM SSMS WHERE SSYMM=@SSYMM AND SSENO=@SSENO AND SSPYN=@SSPYN ORDER BY SSITM DESC)
WHEN 'TRUSR' THEN (SELECT TOP 1 TRUSR FROM SSMS WHERE SSYMM=@SSYMM AND SSENO=@SSENO AND SSPYN=@SSPYN ORDER BY SSITM DESC)
WHEN 'SSNUM' THEN (SELECT TOP 1 SSNUM FROM SSMS WHERE SSYMM=@SSYMM AND SSENO=@SSENO AND SSPYN=@SSPYN ORDER BY SSITM DESC)
WHEN 'SSJNO' THEN (SELECT TOP 1 SSJNO FROM SSMS WHERE SSYMM=@SSYMM AND SSENO=@SSENO AND SSPYN=@SSPYN ORDER BY SSITM DESC)
WHEN 'SSCNO' THEN (SELECT TOP 1 SSCNO FROM SSMS WHERE SSYMM=@SSYMM AND SSENO=@SSENO AND SSPYN=@SSPYN ORDER BY SSITM DESC)
WHEN 'SSBRH' THEN (SELECT TOP 1 SSBRH FROM SSMS WHERE SSYMM=@SSYMM AND SSENO=@SSENO AND SSPYN=@SSPYN ORDER BY SSITM DESC)
END
RETURN @RESULT
END
USE [THINKYU_WEB_TY]
GO
/****** ª«¥ó: View [dbo].[SSMS_VIEW] «ü¥O½X¤é´Á: 02/27/2009 09:44:27 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE VIEW [dbo].[SSMS_VIEW]
AS
SELECT DISTINCT
SSYMM, SSENO, SSPYN,
dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'SSNUM') AS SSNUM,
dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'SSJNO') AS SSJNO,
dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'SSCNO') AS SSCNO,
dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'SSBRH') AS SSBRH,
SUM(SSD01) AS SSD01,
SUM(SSD02) AS SSD02,
(SELECT TOP 1 SSSRD FROM SSMS B WHERE B.SSYMM=SSYMM AND B.SSENO=SSENO AND B.SSPYN=SSPYN ORDER BY B.SSITM DESC) AS SSSRD,
SUM(SSP00) - dbo.SSMS_SSP00_ADJUST(SSYMM, SSENO, SSPYN, 'SSP00') AS SSP00,
SUM(SSP01) AS SSP01,
CASE WHEN SUM(SSP02) > 1800 THEN 1800 ELSE SUM(SSP02) END AS SSP02,
SUM(SSP03) AS SSP03,
SUM(SSP04) AS SSP04,
SUM(SSP05) AS SSP05,
SUM(SSP06) AS SSP06,
SUM(SSP07) AS SSP07,
SUM(SSP08) AS SSP08,
SUM(SSP09) AS SSP09,
SUM(SSP10) AS SSP10,
SUM(SSP11) AS SSP11,
SUM(SSP12) AS SSP12,
SUM(SSP13) AS SSP13,
SUM(SSP14) AS SSP14,
SUM(SSP15) AS SSP15,
SUM(SSP99) AS SSP99,
SUM(SSS01) AS SSS01,
SUM(SSS02) AS SSS02,
SUM(SSS03) AS SSS03,
SUM(SSS04) AS SSS04,
SUM(SSS05) AS SSS05,
SUM(SSS06) AS SSS06,
SUM(SSS07) - dbo.SSMS_SSP00_ADJUST(SSYMM, SSENO, SSPYN, 'SSS07') AS SSS07,
SUM(SSS08) AS SSS08,
SUM(SSS09) AS SSS09,
SUM(SSS10) AS SSS10,
SUM(SSS11) AS SSS11,
SUM(SSS12) AS SSS12,
SUM(SSS13) AS SSS13,
SUM(SSS14) AS SSS14,
SUM(SSS15) AS SSS15,
SUM(SSS99) AS SSS99,
SUM(SSH01) AS SSH01,
SUM(SSH02) AS SSH02,
SUM(SSH03) AS SSH03,
SUM(SSH04) AS SSH04,
SUM(SSH05) AS SSH05,
SUM(SSH06) AS SSH06,
SUM(SSH07) AS SSH07,
SUM(SSH08) AS SSH08,
SUM(SSH09) AS SSH09,
SUM(SSH10) AS SSH10,
SUM(SST01) AS SST01,
SUM(SST02) AS SST02,
SUM(SST03) AS SST03,
SUM(SST04) AS SST04,
SUM(SST05) AS SST05,
SUM(SST06) AS SST06,
SUM(SST07) AS SST07,
SUM(SST08) AS SST08,
SUM(SST09) AS SST09,
SUM(SST10) AS SST10,
SUM(SST11) AS SST11,
SUM(SST12) AS SST12,
SUM(SST13) AS SST13,
SUM(SST14) AS SST14,
SUM(SST15) AS SST15,
SUM(SST16) AS SST16,
SUM(SST17) AS SST17,
SUM(SST18) AS SST18,
SUM(SST19) AS SST19,
SUM(SST20) AS SST20,
SUM(SSL01) AS SSL01,
SUM(SSL02) AS SSL02,
SUM(SSL03) AS SSL03,
SUM(SSL04) AS SSL04,
SUM(SSL05) AS SSL05,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC01') AS SSC01,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC02') AS SSC02,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC03') AS SSC03,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC04') AS SSC04,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC05') AS SSC05,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC06') AS SSC06,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC07') AS SSC07,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC08') AS SSC08,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC09') AS SSC09,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC10') AS SSC10,
dbo.SSMS_DATETIMEFIELD(SSYMM, SSENO, SSPYN, 'TRDAT') AS TRDAT,
dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'TRMOD') AS TRMOD,
dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'TRUSR') AS TRUSR
FROM dbo.SSMS
GROUP BY SSYMM, SSENO, SSPYN
GO
-- ¼W¥[Á~¸ê­pºâ¤è¦¡Äæ¦ì¡A¥H¤Î¬°¦U±M®×¦~«×±µ³æ¶ñ­È
ALTER TABLE BPAA ADD BPSAL CHAR(1)
UPDATE BPAA SET BPSAL='1'
UPDATE BPSS SET BPSAL='2' WHERE BPYER=98 AND BPPNM IN ('CGJ001', 'CGJ002', 'CGJ003', 'CGJ004')
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE FUNCTION [dbo].[SSMS_SSP00_ADJUST]
(
@SSYMM DATETIME,
@SSENO NVARCHAR(10),
@SSPYN NVARCHAR(10),
@FIELDNAME NVARCHAR(10)
)
RETURNS INT
AS
BEGIN
DECLARE @RESULT FLOAT
DECLARE @RECCOUNT INT
DECLARE @DAYS INT
DECLARE @MONTHDAYS INT
SET @RESULT = 0
SELECT @RECCOUNT = COUNT(1), @DAYS = SUM(SSD01)
FROM dbo.SSMS
WHERE SSYMM = @SSYMM
AND SSENO = @SSENO
AND SSPYN = @SSPYN
IF @RECCOUNT > 1
BEGIN
SELECT
@MONTHDAYS = CASE
WHEN BPSAL = '1' THEN 30
WHEN BPSAL = '2' THEN DAY(DATEADD(DAY, -1, DATEADD(MONTH, 1, DATEADD(DAY, -(DAY(@SSYMM) - 1), @SSYMM))))
END
FROM BPAA
WHERE BPPYN=@SSPYN
IF @DAYS > @MONTHDAYS
BEGIN
SET @RESULT =
CASE @FIELDNAME
WHEN 'SSP00' THEN
(SELECT TOP 1 CAST(SSP00 AS FLOAT) / CAST(SSD01 AS FLOAT)
FROM SSMS
WHERE SSYMM = @SSYMM
AND SSENO = @SSENO
AND SSPYN = @SSPYN
ORDER BY SSITM DESC)
WHEN 'SSS07' THEN
(SELECT TOP 1 CAST(SSS07 AS FLOAT) / CAST(SSD01 AS FLOAT)
FROM SSMS
WHERE SSYMM = @SSYMM
AND SSENO = @SSENO
AND SSPYN = @SSPYN
ORDER BY SSITM DESC)
END
END
END
RETURN ROUND(@RESULT, 0)
END
--
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2009/3/3','INSERT','X001','A005','®ç¦Ë­]­ÓºÞ¥[¯Z¶O','ROUND((@¥»Á~/240 + @¥ë­¹¶O/240) * @¥[¯Z¶O¤ñ¨Ò * @®É¼Æ, 0)',1);
-- 98/8/10 ¼W¥[«È¤á±M®×·~ºA§O
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BCUSTRD', 'C', '¸gÀÙ³¡°Ó·~¥q', '2009/08/10', 'INSERT', 'X002')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BCUSTRD', 'G', '¥«¬F©²³Ò¤u³B', '2009/08/10', 'INSERT', 'X002')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BCUSTRD', 'S', '¿¤¬F©²³Ò¤u³B', '2009/08/10', 'INSERT', 'X002')
-- 98/9/3 ¼W¥[¦~«×±µ³æ¯}¤ëÁ~¸ê­pºâ¤è¦¡Ãþ§O
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BPAAMSD', '1', '°£¥H 30', '2009/09/03', 'INSERT', 'X002')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BPAAMSD', '2', '°£¥H¹ê»Ú¤é¼Æ', '2009/09/03', 'INSERT', 'X002')
-- 99/2/1 §R°£¿ù»~¸ê®Æ
SELECT A.RANUM, B.BPNME FROM RASN A INNER JOIN BPSN B ON A.RANUM=B.BPENO WHERE A.RAPYN='099AGJ001'
SELECT A.RANUM, B.BPNME FROM RASN A INNER JOIN BPSN B ON A.RANUM=B.BPENO WHERE A.RAPYN='099CGJ002'
DELETE FROM RASN WHERE RAPYN='099AGJ001'
DELETE FROM RASN WHERE RAPYN='099CGJ002'
-- 99/3/19 ·s¼W³Ò«O¾¨a¶O²v
UPDATE BRTE SET TRDAT='2010/3/19', TRMOD='UPDATE', BREDT='2009/12/31', APPNO=2 WHERE BRTYP='³Ò«O¾·~¨a®`' AND BRVER=2
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2010/3/19', 'INSERT', 'X001', '³Ò«O¾·~¨a®`', 3, 0.0011, '2010/01/01', NULL, 1)
-- 99/3/19 ·s¼W°·«O¶O²vªí
-- ¥H²{¦³¸ê®Æ«Ø¥ß SQL ±Ô­z
SELECT 'INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES ('
+ '2, '
+ CONVERT(VARCHAR(2), BSLVL) + ', '
+ CONVERT(VARCHAR(10), BSLOW) + ', '
+ CONVERT(VARCHAR(10), BSHIH) + ', '
+ CONVERT(VARCHAR(10), BSAMT) + ')'
FROM BHIF
WHERE BSVER = 1
UPDATE BRTE SET TRDAT='2010/3/19', TRMOD='UPDATE', BREDT='2010/3/31', APPNO=2 WHERE BRTYP='°·«O' AND BRVER=1
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2010/3/19', 'INSERT', 'X002', '°·«O', 2, 0.0517, '2010/4/1', NULL, 1)
UPDATE BFDT SET BFEDT='2010/3/31' WHERE BFTYP=2 AND BFVER=1
INSERT INTO BFDT (BFTYP, BFVER, BFSDT, BFEDT) VALUES (2, 2, '2010/4/1', NULL)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 1, 0, 17280, 17280)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 2, 17281, 17400, 17400)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 3, 17401, 18300, 18300)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 4, 18301, 19200, 19200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 5, 19201, 20100, 20100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 6, 20101, 21000, 21000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 7, 21001, 21900, 21900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 8, 21901, 22800, 22800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 9, 22801, 24000, 24000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 10, 24001, 25200, 25200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 11, 25201, 26400, 26400)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 12, 26401, 27600, 27600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 13, 27601, 28800, 28800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 14, 28801, 30300, 30300)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 15, 30301, 31800, 31800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 16, 31801, 33300, 33300)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 17, 33301, 34800, 34800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 18, 34801, 36300, 36300)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 19, 36301, 38200, 38200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 20, 38201, 40100, 40100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 21, 40101, 42000, 42000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 22, 42001, 43900, 43900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 23, 43901, 45800, 45800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 24, 45801, 48200, 48200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 25, 48201, 50600, 50600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 26, 50601, 53000, 53000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 27, 53001, 55400, 55400)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 28, 55401, 57800, 57800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 29, 57801, 60800, 60800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 30, 60801, 63800, 63800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 31, 63801, 66800, 66800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 32, 66801, 69800, 69800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 33, 69801, 72800, 72800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 34, 72801, 76500, 76500)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 35, 76501, 80200, 80200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 36, 80201, 83900, 83900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 37, 83901, 87600, 87600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 38, 87601, 92100, 92100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 39, 92101, 96600, 96600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 40, 96601, 101100, 101100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 41, 101101, 105600, 105600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 42, 105601, 110100, 110100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 43, 110101, 115500, 115500)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 44, 115501, 120900, 120900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 45, 120901, 126300, 126300)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 46, 126301, 131700, 131700)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 47, 131701, 137100, 137100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 48, 137101, 142500, 142500)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 49, 142501, 147900, 147900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 50, 147901, 150000, 150000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 51, 150001, 156400, 156400)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 52, 156401, 162800, 162800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 53, 162801, 169200, 169200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 54, 169201, 175600, 175600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 55, 175601, 2147483647, 182000)
-- 99/7/2 ¼W¥[«D±M®×¤H­û«e¤G¥[¯Z¡B«á¤G¥[¯Z¡B°²¤é¥[¯Zªº¥[¯Z¶O¤ñ¨Ò
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2010/7/2', 'INSERT', 'X002', '«D±M®×¤H­û«e¤G¥[¯Z', 1, 1.3333, '1899/12/31', NULL, 1)
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2010/7/2', 'INSERT', 'X002', '«D±M®×¤H­û«á¤G¥[¯Z', 1, 1.6666, '1899/12/31', NULL, 1)
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2010/7/2', 'INSERT', 'X002', '«D±M®×¤H­û°²¤é¥[¯Z', 1, 1.0, '1899/12/31', NULL, 1)
-- 100/1/9 ¿¤¥«¦X¨Ö¤É¯Å§ó§ï¦a§}¸ê®Æ
UPDATE BPSN SET BPACY=SUBSTRING(BPACY, 1, LEN(BPACY) - 1) + '°Ï' WHERE BPACT IN ('¥x¥_¿¤', '¥x¤¤¿¤', '¥x«n¿¤', '°ª¶¯¿¤')
UPDATE BPSN SET BPACT='·s¥_¥«' WHERE BPACT='¥x¥_¿¤'
UPDATE BPSN SET BPACT='¥x¤¤¥«' WHERE BPACT='¥x¤¤¿¤'
UPDATE BPSN SET BPACT='¥x«n¥«' WHERE BPACT='¥x«n¿¤'
UPDATE BPSN SET BPACT='°ª¶¯¥«' WHERE BPACT='°ª¶¯¿¤'
UPDATE BPSN SET BPASA='¯«©£¨½¢±¢°¾F¤¤¥¿«nµó¢²¢·«Ñ¢°¢°§Ë¢²¸¹' WHERE BPENO='00063'
UPDATE BPSN SET BPASA='ªFÄ_¨½¤j´I¸ô¢°¬q¢²«Ñ¢°¢¶¸¹' WHERE BPENO='00065'
UPDATE BPSN SET BPASA='©M²±¨½©M²±µó©M²±«Ñ¢²¢·¡Ð¢°¢°¸¹' WHERE BPENO='00067'
UPDATE BPSN SET BPASA='ÃU³½¼æ¨½¸t¤ý±T¤U¢±¢±¸¹' WHERE BPENO='00068'
UPDATE BPSN SET BPASA='¦`«e¨½¦`«e¸ô¢²¢´¡Ð¢´¸¹' WHERE BPENO='00069'
UPDATE BPSN SET BPASA='¥Ã·½¨½¤¤©Mµó¢°¬q¢¶¢¶«Ñ¢µ¢¯¡Ð¢±¢¶¸¹' WHERE BPENO='00073'
UPDATE BPSN SET BPASA='ªF®ü¨½¢³¾F»·ªFµó¢°¢³¢²«Ñ¢°§Ë¢³¸¹' WHERE BPENO='00079'
UPDATE BPSN SET BPASA='¤ý¥Ð¨½¿³©M¸ô¢±¢´¢³¸¹' WHERE BPENO='00083'
UPDATE BPSN SET BPASA='Às©£¨½¢´¾F¦Ë®v¸ô¢±¬q¢¸¢°«Ñ¢°¢´¸¹' WHERE BPENO='00085'
UPDATE BPSN SET BPASA='³»µó¨½ºaµØµó¢°¢¯¢±«Ñ¢°¢´§Ë¢¶¸¹' WHERE BPENO='00086'
UPDATE BPSN SET BPASA='·sÉܨ½·s¿³¸ô¢°¢±¢¸«Ñ¢±¢·¸¹' WHERE BPENO='00089'
UPDATE BPSN SET BPASA='ÀY®aªF¨½¤j¦¨µó¢²«Ñ¢°¤§¢°¸¹' WHERE BPENO='00137'
UPDATE BPSN SET BPASA='ÀY®a¨½ÀY®a¸ô¢°¢¸¢±«Ñ¢°¢°¸¹¢¶¼Ó' WHERE BPENO='00149'
UPDATE BPSN SET BPASA='·sÉܨ½¢±¢³¾F·sÉܵó¤@¬q¢¸¢µ«Ñ¢¸¢µ§Ë¢·¢°¸¹¢·¼Ó' WHERE BPENO='00153'
UPDATE BPSN SET BPASA='¸q¨½¨½¥Ò¦Z¸ô¢±¢²¢²«Ñ¢µ¢²¸¹' WHERE BPENO='00154'
UPDATE BPSN SET BPASA='©¾©M¨½10¾F¤¤¤s¤¤¸ô2¬q120¸¹' WHERE BPENO='00190'
UPDATE BPSN SET BPASA='¸q¾Ç¨½5¾F©ú§Ó¸ô¤G¬q70¸¹7¼Ó' WHERE BPENO='00242'
UPDATE BPSN SET BPASA='©¾¸q¨½2¾F¤¯·R¦è¸ô52¸¹' WHERE BPENO='00261'
UPDATE BPSN SET BPASA='ªø¨F¨½¥Ý¥Ð«Ñ335¸¹' WHERE BPENO='00270'
UPDATE BPSN SET BPASA='ÀY®a¨½ÀY®a¸ô192«Ñ11¸¹7¼Ó' WHERE BPENO='00324'
UPDATE BPSN SET BPASA='¤T©M¨½¬K«F¤Tµó13¸¹' WHERE BPENO='00454'
UPDATE BPSN SET BPLCY=SUBSTRING(BPLCY, 1, LEN(BPLCY) - 1) + '°Ï' WHERE BPLCT IN ('¥x¥_¿¤', '¥x¤¤¿¤', '¥x«n¿¤', '°ª¶¯¿¤')
UPDATE BPSN SET BPLCT='·s¥_¥«' WHERE BPLCT='¥x¥_¿¤'
UPDATE BPSN SET BPLCT='¥x¤¤¥«' WHERE BPLCT='¥x¤¤¿¤'
UPDATE BPSN SET BPLCT='¥x«n¥«' WHERE BPLCT='¥x«n¿¤'
UPDATE BPSN SET BPLCT='°ª¶¯¥«' WHERE BPLCT='°ª¶¯¿¤'
UPDATE BPSN SET BPLSA='¯«©£§ø¢±¢°¾F¤¤¥¿«nµó¢²¢·«Ñ¢°¢°§Ë¢²¸¹' WHERE BPENO='00063'
UPDATE BPSN SET BPLSA='ªFÄ_§ø¤j´I¸ô¢°¬q¢²«Ñ¢°¢¶¸¹' WHERE BPENO='00065'
UPDATE BPSN SET BPLSA='©M²±§ø©M²±µó©M²±«Ñ¢²¢·¡Ð¢°¢°¸¹' WHERE BPENO='00067'
UPDATE BPSN SET BPLSA='¦`«e§ø¦`«e¸ô¢²¢´¡Ð¢´¸¹' WHERE BPENO='00069'
UPDATE BPSN SET BPLSA='¥Ã·½§ø¤¤©Mµó¢°¬q¢¶¢¶«Ñ¢µ¢¯¡Ð¢±¢¶¸¹' WHERE BPENO='00073'
UPDATE BPSN SET BPLSA='ªF®ü§ø¢³¾F»·ªFµó¢°¢³¢²«Ñ¢°§Ë¢³¸¹' WHERE BPENO='00079'
UPDATE BPSN SET BPLSA='¤ý¥Ð§ø¿³©M¸ô¢±¢´¢³¸¹' WHERE BPENO='00083'
UPDATE BPSN SET BPLSA='Às©£§ø¢´¾F¦Ë®v¸ô¢±¬q¢¸¢°«Ñ¢°¢´¸¹' WHERE BPENO='00085'
UPDATE BPSN SET BPLSA='³»µó§øºaµØµó¢°¢¯¢±«Ñ¢°¢´§Ë¢¶¸¹' WHERE BPENO='00086'
UPDATE BPSN SET BPLSA='·sÉܧø·s¿³¸ô¢°¢±¢¸«Ñ¢±¢·¸¹' WHERE BPENO='00089'
UPDATE BPSN SET BPLSA='ÀY®aªF§ø¤j¦¨µó¢²«Ñ¢°¤§¢°¸¹' WHERE BPENO='00137'
UPDATE BPSN SET BPLSA='ÀY®a§øÀY®a¸ô¢°¢¸¢±«Ñ¢°¢°¸¹¢¶¼Ó' WHERE BPENO='00149'
UPDATE BPSN SET BPLSA='·sÉܧø¢±¢³¾F·sÉܵó¤@¬q¢¸¢µ«Ñ¢¸¢µ§Ë¢·¢°¸¹¢·¼Ó' WHERE BPENO='00153'
UPDATE BPSN SET BPLSA='¸q¨½§ø¥Ò¦Z¸ô¢±¢²¢²«Ñ¢µ¢²¸¹' WHERE BPENO='00154'
UPDATE BPSN SET BPLSA='©¾©M§ø10¾F¤¤¤s¤¤¸ô2¬q120¸¹' WHERE BPENO='00190'
UPDATE BPSN SET BPLSA='¸q¾Ç§ø5¾F©ú§Ó¸ô¤G¬q70¸¹7¼Ó' WHERE BPENO='00242'
UPDATE BPSN SET BPLSA='©¾¸q§ø2¾F¤¯·R¦è¸ô52¸¹' WHERE BPENO='00261'
UPDATE BPSN SET BPLSA='ÀY®a§øÀY®a¸ô192«Ñ11¸¹7¼Ó' WHERE BPENO='00324'
UPDATE BPSN SET BPLSA='¤T©M§ø¬K«F¤Tµó13¸¹' WHERE BPENO='00454'
UPDATE BPSN SET BPLSA='¥x¤¤¥«¦Z¨½°Ï¥|§ø¸ô16¸¹' WHERE BPENO='00547'
-- 100 ¦~ 1 ¤ë 1 ¤é³Ò«O¶O²v½Õ¾ã¥H¤Î¯Å¶Zªí½Õ¾ã
UPDATE BRTE SET BREDT='2010/12/31', TRDAT='2011/1/9', TRMOD='UPDATE', TRUSR='X001' WHERE BRTYP='³Ò«O´¶³q¶Ë¯f' AND BRVER=2
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2011/01/09', 'INSERT', 'X001', '³Ò«O´¶³q¶Ë¯f', 3, 0.07, '2011/01/01', NULL, 1)
UPDATE BFDT SET BFEDT='2010/12/31' WHERE BFTYP=1 AND BFVER=1
INSERT INTO BFDT (BFTYP, BFVER, BFSDT, BFEDT) VALUES (1, 2, '2011/1/1', NULL)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 1, 0, 17880, 17880)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 2, 17881, 18300, 18300)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 3, 18301, 19200, 19200)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 4, 19201, 20100, 20100)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 5, 20101, 21000, 21000)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 6, 21001, 21900, 21900)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 7, 21901, 22800, 22800)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 8, 22801, 24000, 24000)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 9, 24001, 25200, 25200)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 10, 25201, 26400, 26400)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 11, 26401, 27600, 27600)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 12, 27601, 28800, 28800)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 13, 28801, 30300, 30300)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 14, 30301, 31800, 31800)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 15, 31801, 33300, 33300)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 16, 33301, 34800, 34800)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 17, 34801, 36300, 36300)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 18, 36301, 38200, 38200)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 19, 38201, 40100, 40100)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 20, 40101, 42000, 42000)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 21, 42001, 2147483647, 43900)
-- 100/01/17 ­×§ï¼úª÷§Kµ|ªùÂe
DELETE FROM BWEX WHERE BSNUM='UNBONUSTAXFREE' AND BSITM=' 1'
INSERT INTO BWEX (BSNUM, BSITM, BSNAM) VALUES ('UNBONUSTAXFREE', ' 1', '68500')
-- 100/3/19 ·s¼W³Ò«O¾¨a¶O²v
UPDATE BRTE SET TRDAT='2011/3/9', TRMOD='UPDATE', BREDT='2011/03/10', APPNO=2 WHERE BRTYP='³Ò«O¾·~¨a®`' AND BRVER=3
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES
('2010/3/19', 'INSERT', 'X001', '³Ò«O¾·~¨a®`', 4, 0.001, '2011/03/11', NULL, 1)
-- 101 ¦~ 1 ¤ë 1 ¤é³Ò«O¶O²v½Õ¾ã¥H¤Î¯Å¶Zªí½Õ¾ã
UPDATE BRTE SET BREDT='2011/12/31', TRDAT='2012/2/3', TRMOD='UPDATE', TRUSR='X001' WHERE BRTYP='³Ò«O´¶³q¶Ë¯f' AND BRVER=3
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2011/02/03', 'INSERT', 'X001', '³Ò«O´¶³q¶Ë¯f', 4, 0.075, '2012/01/01', NULL, 1)
===========================================
¡I¡I¡I¡I¡I ¥Á°ê 101 ¦~·s¦~§Ö¼Ö ¡I¡I¡I¡I¡I
===========================================
-- ¼W¥[Ãþ§O¸ê®Æ
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('RPARTYP', '0D', '­ì¥Á²½»ö°²');
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('RPARTYP', '33', '¤½¥X');
-- RPAR ¤H­û¶O¥Î¬ö¿ý Äæ¦ì¼W¥[
ALTER TABLE RPAR ADD RPADT DATETIME NULL ;
ALTER TABLE RPAR ADD RPAPN VARCHAR( 1) NULL ;
ALTER TABLE RPAR ADD RPANO VARCHAR( 1) NULL ;
ALTER TABLE RPAR ADD RPAPP VARCHAR( 1) NULL ;
ALTER TABLE RPAR ADD RPAPD DATETIME NULL ;
ALTER TABLE RPAR ADD RPAPU NVARCHAR( 10) NULL ;
ALTER TABLE RPAR ADD RPAGT NVARCHAR( 10) NULL ;
ALTER TABLE RPAR ADD RPAGM NVARCHAR( 30) NULL ;
ALTER TABLE RPAR ADD RPRTM NVARCHAR( 5) NULL ;
ALTER TABLE RPAR ADD RPETM NVARCHAR( 5) NULL ;
ALTER TABLE RPAR ADD RPUST INT DEFAULT 0 ;
ALTER TABLE RPAR ADD RPTC1 INT DEFAULT 0 ;
ALTER TABLE RPAR ADD RPTC2 INT DEFAULT 0 ;
ALTER TABLE RPAR ADD RPTC3 INT DEFAULT 0 ;
ALTER TABLE RPAR ADD RPRSN NVARCHAR( 70) NULL ;
-- RPAB ¤H­û¶O¥Îñ®Ö¬ö¿ý ¸ê®Æªí·s¼W
CREATE TABLE RPAB
(TRDAT DATETIME NULL
,TRMOD VARCHAR( 12) NULL
,TRUSR VARCHAR( 10) NULL
,RPREN NVARCHAR( 12) not NULL
,RPITM INT not NULL
,RPGLP NVARCHAR( 12) NULL
,RPENO NVARCHAR( 12) NULL
,RPDAT DATETIME NULL
,RPAPP NVARCHAR( 1) NULL
,RPDOC NVARCHAR(200) NULL
);
ALTER TABLE RPAB ADD CONSTRAINT PK_RPAB PRIMARY KEY (RPREN,RPITM);
--¤º³¡¤H­û¿é¤J®É¡AÀ³Ã±Ãö¥d¶ñ 0
--¥~³¡¤H­û¿é¤J®É¡AÀ³Ã±Ãö¥d¶ñ¹ê»ÚÀ³Ã±Ãö¥d¼Æ
-- ¼W¥[¸ê®Æªí RPAC ¸É¥ð¨R¾PÀÉ
CREATE TABLE RPAC
(TRDAT DATETIME NULL
,TRMOD NVARCHAR( 12) NULL
,TRUSR NVARCHAR( 10) NULL
,RPREN NVARCHAR( 10) not NULL
,RPREX NVARCHAR( 10) not NULL
,RPTCT INT DEFAULT 0
);
ALTER TABLE RPAC ADD CONSTRAINT PK_RPAC PRIMARY KEY (RPREN,RPREX);
-- ·s¼W¤W¤U¯Z®É¶¡»P¤¤¤È¥ð®§®É¶¡³]©w
INSERT INTO BWEX (BSNUM, BSITM, BSNAM) VALUES ('UNRPARTIME', ' 1', '08:00');
INSERT INTO BWEX (BSNUM, BSITM, BSNAM) VALUES ('UNRPARTIME', ' 2', '17:00');
INSERT INTO BWEX (BSNUM, BSITM, BSNAM) VALUES ('UNRPARTIME', ' 3', '12:00');
INSERT INTO BWEX (BSNUM, BSITM, BSNAM) VALUES ('UNRPARTIME', ' 4', '13:00');
-- ·s¼W¤H­û¯S¥ð¸ê®ÆÀÉ
CREATE TABLE RASD
(TRDAT DATETIME NULL
,TRMOD NVARCHAR( 12) NULL
,TRUSR NVARCHAR( 10) NULL
,RANUM NVARCHAR( 10) not NULL
,RAYER INT not NULL
,RATCT INT DEFAULT 0
,RAUST INT DEFAULT 0
);
ALTER TABLE RASD ADD CONSTRAINT PK_RASD PRIMARY KEY (RANUM,RAYER);
-- ·s¼W¥X®t¶O¥ÎÀÉ
CREATE TABLE RPAD
(TRDAT DATETIME NULL
,TRMOD NVARCHAR( 12) NULL
,TRUSR NVARCHAR( 10) NULL
,RPREN NVARCHAR( 10) not NULL
,RPITM INT not NULL
,RPSTP NVARCHAR( 20) NULL
,RPEDP NVARCHAR( 20) NULL
,RPF01 INT DEFAULT 0
,RPF02 INT DEFAULT 0
,RPF03 INT DEFAULT 0
,RPF04 INT DEFAULT 0
,RPF05 INT DEFAULT 0
,RPF06 INT DEFAULT 0
,RPF07 INT DEFAULT 0
,RPF08 INT DEFAULT 0
,RPF09 INT DEFAULT 0
,RPF10 INT DEFAULT 0
,RPSUM INT DEFAULT 0
);
ALTER TABLE RPAD ADD CONSTRAINT PK_RPAD PRIMARY KEY (RPREN,RPITM);
-- 2012-02-18 ·s¼W¯Á¤Þ
CREATE NONCLUSTERED INDEX [IDX_RPAR_01] ON [dbo].[RPAR]
(
[RPNUM] ASC,
[RPTYP] ASC,
[RPRDT] ASC
) WITH (PAD_INDEX = OFF,
STATISTICS_NORECOMPUTE = OFF,
SORT_IN_TEMPDB = OFF,
IGNORE_DUP_KEY = OFF,
DROP_EXISTING = OFF,
ONLINE = OFF,
ALLOW_ROW_LOCKS = ON,
ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
-- ¥[ªø³ÆµùÄæ¦ì
ALTER TABLE RPAR ALTER COLUMN RPDOC NVARCHAR(2000)
---- 2012-02-18 ¤W­z SQL §¡¤w°õ¦æ§¹²¦
--- 2012/2/21 ·s¼W¥~³¡¤H­û±b¸¹ÀÉ
CREATE TABLE BPAP
(TRDAT DATETIME NULL
,TRMOD NVARCHAR( 12) NULL
,TRUSR NVARCHAR( 10) NULL
,BPENO NVARCHAR( 10) not NULL
,BPNME NVARCHAR( 20) NULL
,BPPWD NVARCHAR( 30) NULL
,BPEML NVARCHAR( 30) NULL
,BPZON NVARCHAR( 10) NULL
,BPBRH NVARCHAR( 10) NULL
);
ALTER TABLE BPAP ADD CONSTRAINT PK_BPAP PRIMARY KEY (BPENO);
--- 2012/2/22 ·s¼Wñ®Ö¤H­ûÀÉ
CREATE TABLE BSGP
(TRDAT DATETIME NULL
,TRMOD NVARCHAR( 12) NULL
,TRUSR NVARCHAR( 10) NULL
,BSPYN NVARCHAR( 20) not NULL
,BSFLW NVARCHAR( 10) not NULL
,BSLVL INT not NULL
,BSENO NVARCHAR( 10) not NULL
);
ALTER TABLE BSGP ADD CONSTRAINT PK_BSGP PRIMARY KEY (BSPYN,BSFLW,BSLVL,BSENO);
---- ¤W­z SQL ¤w¸g°õ¦æ§¹²¦
-- 2012/4/14 ¦]À³ RPAR.RPTCT ¥Ñ®É¼Æ§ï¬°¤ÀÄÁ¼Æ¡A¥²¶·°µ¥H¤Uªº SQL
-- 1. RPAR.RPTCT «Dªo®Æ¶OªÌ¡A§¡­¼¥H 60
UPDATE RPAR SET RPTCT = RPTCT * 60, RPTC1 = RPTC1 * 60, RPTC2 = RPTC2 * 60, RPTC3 = RPTC3 * 60 WHERE RPTYP<>'22'
-- 2. SSMS SST01 ¨ì SST17 ­¼¥H 60
UPDATE SSMS SET SST01=SST01*60, SST02=SST02*60, SST03=SST03*60, SST04=SST04*60, SST05=SST05*60, SST06=SST06*60,
SST07=SST07*60, SST08=SST08*60, SST09=SST09*60, SST10=SST10*60, SST11=SST11*60, SST12=SST12*60,
SST13=SST13*60, SST14=SST14*60, SST15=SST15*60, SST16=SST16*60, SST17=SST17*60
-- 3. SSMB SST01 ¨ì SST17 ­¼¥H 60
UPDATE SSMB SET SST01=SST01*60, SST02=SST02*60, SST03=SST03*60, SST04=SST04*60, SST05=SST05*60, SST06=SST06*60,
SST07=SST07*60, SST08=SST08*60, SST09=SST09*60, SST10=SST10*60, SST11=SST11*60, SST12=SST12*60,
SST13=SST13*60, SST14=SST14*60, SST15=SST15*60, SST16=SST16*60, SST17=SST17*60
-- 4. ROWK ªº®É¼ÆÄæ¦ì­¼¥H 60
UPDATE ROWK SET ROT01=ROT01*60, ROT02=ROT02*60, ROT03=ROT03*60, ROT04=ROT04*60
-- 5. ­×§ï SSMSVIEW¡A§â SST01 ¦Ü SST17 Åã¥Ü®É°£¥H 60
SELECT DISTINCT
SSYMM, SSENO, SSPYN, dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'SSNUM') AS SSNUM, dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'SSJNO')
AS SSJNO, dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'SSCNO') AS SSCNO, dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'SSBRH') AS SSBRH,
SUM(SSD01) AS SSD01, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSD02') AS SSD02,
(SELECT TOP (1) SSSRD
FROM dbo.SSMS AS B
WHERE (SSYMM = SSYMM) AND (SSENO = SSENO) AND (SSPYN = SSPYN)
ORDER BY SSITM DESC) AS SSSRD, SUM(SSP00) - dbo.SSMS_SSP00_ADJUST(SSYMM, SSENO, SSPYN, N'SSP00') AS SSP00, SUM(SSP01) AS SSP01,
SUM(SSP02) - dbo.SSMS_SSP00_ADJUST(SSYMM, SSENO, SSPYN, N'SSP02') AS SSP02, SUM(SSP03) AS SSP03, SUM(SSP04) AS SSP04, SUM(SSP05) AS SSP05,
SUM(SSP06) AS SSP06, SUM(SSP07) AS SSP07, SUM(SSP08) AS SSP08, SUM(SSP09) AS SSP09, SUM(SSP10) AS SSP10, SUM(SSP11) AS SSP11, SUM(SSP12)
AS SSP12, SUM(SSP13) AS SSP13, SUM(SSP14) AS SSP14, SUM(SSP15) AS SSP15, SUM(SSP99) AS SSP99, SUM(SSS01) AS SSS01, SUM(SSS02) AS SSS02,
SUM(SSS03) AS SSS03, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSS04') AS SSS04, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSS05') AS SSS05,
dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSS06') AS SSS06, SUM(SSS07) - dbo.SSMS_SSP00_ADJUST(SSYMM, SSENO, SSPYN, N'SSS07') AS SSS07,
SUM(SSS08) AS SSS08, SUM(SSS09) AS SSS09, SUM(SSS10) AS SSS10, SUM(SSS11) AS SSS11, SUM(SSS12) AS SSS12, SUM(SSS13) AS SSS13, SUM(SSS14)
AS SSS14, SUM(SSS15) AS SSS15, SUM(SSS99) AS SSS99, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSH01') AS SSH01, dbo.SSMS_INTFIELD(SSYMM,
SSENO, SSPYN, 'SSH02') AS SSH02, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSH03') AS SSH03, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSH04')
AS SSH04, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSH05') AS SSH05, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSH06') AS SSH06, SUM(SSH07)
AS SSH07, SUM(SSH08) AS SSH08, SUM(SSH09) AS SSH09, SUM(SSH10) AS SSH10, SUM(SST01) / 60 AS SST01, SUM(SST02) / 60 AS SST02, SUM(SST03) / 60 AS SST03,
SUM(SST04) / 60 AS SST04, SUM(SST05) / 60 AS SST05, SUM(SST06) / 60 AS SST06, SUM(SST07) / 60 AS SST07, SUM(SST08) / 60 AS SST08, SUM(SST09) / 60 AS SST09,
SUM(SST10) / 60 AS SST10, SUM(SST11) / 60 AS SST11, SUM(SST12) / 60 AS SST12, SUM(SST13) / 60 AS SST13, SUM(SST14) / 60 AS SST14, SUM(SST15) / 60 AS SST15,
SUM(SST16) / 60 AS SST16, SUM(SST17) / 60 AS SST17, SUM(SST18) AS SST18, SUM(SST19) AS SST19, SUM(SST20) AS SST20, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSL01') AS SSL01,
dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSL02') AS SSL02, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSL03') AS SSL03, dbo.SSMS_INTFIELD(SSYMM,
SSENO, SSPYN, 'SSL04') AS SSL04, dbo.SSMS_INTFIELD(SSYMM, SSENO, SSPYN, 'SSL05') AS SSL05, dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC01')
AS SSC01, dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC02') AS SSC02, dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC03') AS SSC03,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC04') AS SSC04, dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC05') AS SSC05,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC06') AS SSC06, dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC07') AS SSC07,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC08') AS SSC08, dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC09') AS SSC09,
dbo.SSMS_COMMENT(SSYMM, SSENO, SSPYN, 'SSC10') AS SSC10, dbo.SSMS_DATETIMEFIELD(SSYMM, SSENO, SSPYN, 'TRDAT') AS TRDAT,
dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'TRMOD') AS TRMOD, dbo.SSMS_STRINGFIELD(SSYMM, SSENO, SSPYN, 'TRUSR') AS TRUSR
FROM dbo.SSMS
GROUP BY SSYMM, SSENO, SSPYN
-- 2012/05/22 ¥´¥d¸ê®Æªí¼W¥[ IP ¬ö¿ýÄæ¦ì
ALTER TABLE RCRD ADD
RCP01 NVARCHAR( 40) NULL,
RCP02 NVARCHAR( 40) NULL,
RCP03 NVARCHAR( 40) NULL,
RCP04 NVARCHAR( 40) NULL,
RCP05 NVARCHAR( 40) NULL,
RCP06 NVARCHAR( 40) NULL
-- 2012/05/24 ·s¼W RLOG ¸ê®Æªí
CREATE TABLE RLOG
(TRDAT DATETIME NULL
,TRMOD NVARCHAR( 12) NULL
,TRUSR NVARCHAR( 10) NULL
,RLDAT DATETIME NULL
,RLTIM VARCHAR( 8) NULL
,RLPRG VARCHAR( 20) NULL
,RLCIP VARCHAR( 40) NULL
,RLCNT VARCHAR(100) NULL
);
-- 2012/06/01 RPAR ·s¼W®t®È¦aÂI RPPLC
ALTER TABLE RPAR ADD RPPLC NVARCHAR( 20) NULL ;
-- 2012/06/04 ·s¼W¦~«×¯S¥ðÀÉ RYER
CREATE TABLE RYER
(TRDAT DATETIME NULL
,TRMOD NVARCHAR( 12) NULL
,TRUSR NVARCHAR( 10) NULL
,RYENO VARCHAR( 10) not NULL
,RYYER INT not NULL
,RYTOT INT DEFAULT 0
,RYUST INT DEFAULT 0
);
ALTER TABLE RYER ADD CONSTRAINT PK_RYER PRIMARY KEY (RYENO,RYYER);
---- ¤W­z SQL ¤w¸g°õ¦æ§¹²¦
-- ½Õ¾ãñ®ÖÀɬ[ºc¡A¸É¸ê®Æ
SELECT *, (SELECT RPAPN FROM RPAR WHERE RPAB.RPREN=RPAR.RPREN) FROM RPAB
--SET RPAPN = (SELECT RPAPN FROM RPAR WHERE RPAB.RPREN=RPAR.RPREN)
--UPDATE RPAB
--SET RPAPN = (SELECT RPAPN FROM RPAR WHERE RPAB.RPREN=RPAR.RPREN)
---³Ò«O¯Å¶Z¶iª©
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 1, 0, 19047, 19047)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 2, 19048, 19200, 19200)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 3, 19201, 20100, 20100)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 4, 20101, 21000, 21000)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 5, 21001, 21900, 21900)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 6, 21901, 22800, 22800)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 7, 22801, 24000, 24000)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 8, 24001, 25200, 25200)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 9, 25201, 26400, 26400)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 10, 26401, 27600, 27600)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 11, 27601, 28800, 28800)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 12, 28801, 30300, 30300)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 13, 30301, 31800, 31800)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 14, 31801, 33300, 33300)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 15, 33301, 34800, 34800)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 16, 34801, 36300, 36300)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 17, 36301, 38200, 38200)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 18, 38201, 40100, 40100)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 19, 40101, 42000, 42000)
INSERT INTO BLIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 20, 42001, 2147483647, 43900)
-- °·«O¯Å¶Z¶iª©
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 1, 0, 18780, 18780)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 2, 18781, 19200, 19200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 3, 19201, 20100, 20100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 4, 20101, 21000, 21000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 5, 21001, 21900, 21900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 6, 21901, 22800, 22800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 7, 22801, 24000, 24000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 8, 24001, 25200, 25200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 9, 25201, 26400, 26400)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 10, 26401, 27600, 27600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 11, 27601, 28800, 28800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 12, 28801, 30300, 30300)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 13, 30301, 31800, 31800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 14, 31801, 33300, 33300)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 15, 33301, 34800, 34800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 16, 34801, 36300, 36300)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 17, 36301, 38200, 38200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 18, 38201, 40100, 40100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 19, 40101, 42000, 42000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 20, 42001, 43900, 43900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 21, 43901, 45800, 45800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 22, 45801, 48200, 48200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 23, 48201, 50600, 50600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 24, 50601, 53000, 53000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 25, 53001, 55400, 55400)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 26, 55401, 57800, 57800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 27, 57801, 60800, 60800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 28, 60801, 63800, 63800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 29, 63801, 66800, 66800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 30, 66801, 69800, 69800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 31, 69801, 72800, 72800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 32, 72801, 76500, 76500)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 33, 76501, 80200, 80200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 34, 80201, 83900, 83900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 35, 83901, 87600, 87600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 36, 87601, 92100, 92100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 37, 92101, 96600, 96600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 38, 96601, 101100, 101100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 39, 101101, 105600, 105600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 40, 105601, 110100, 110100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 41, 110101, 115500, 115500)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 42, 115501, 120900, 120900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 43, 120901, 126300, 126300)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 44, 126301, 131700, 131700)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 45, 131701, 137100, 137100)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 46, 137101, 142500, 142500)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 47, 142501, 147900, 147900)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 48, 147901, 150000, 150000)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 49, 150001, 156400, 156400)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 50, 156401, 162800, 162800)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 51, 162801, 169200, 169200)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 52, 169201, 175600, 175600)
INSERT INTO BHIF (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (3, 53, 175601, 2147483647, 182000)
--- ³Ò°h¯Å¶Z¶iª©
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 1, 0, 1500, 1500)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 2, 1501, 3000, 3000)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 3, 3001, 4500, 4500)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 4, 4501, 6000, 6000)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 5, 6001, 7500, 7500)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 6, 7501, 8700, 8700)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 7, 8701, 9900, 9900)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 8, 9901, 11100, 11100)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 9, 11101, 12540, 12540)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 10, 12541, 13500, 13500)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 11, 13501, 15840, 15840)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 12, 15841, 16500, 16500)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 13, 16501, 17280, 17280)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 14, 17281, 17880, 17880)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 15, 17881, 19047, 19047)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 16, 19048, 19200, 19200)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 17, 19201, 20100, 20100)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 18, 20101, 21000, 21000)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 19, 21001, 21900, 21900)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 20, 21901, 22800, 22800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 21, 22801, 24000, 24000)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 22, 24001, 25200, 25200)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 23, 25201, 26400, 26400)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 24, 26401, 27600, 27600)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 25, 27601, 28800, 28800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 26, 28801, 30300, 30300)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 27, 30301, 31800, 31800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 28, 31801, 33300, 33300)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 29, 33301, 34800, 34800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 30, 34801, 36300, 36300)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 31, 36301, 38200, 38200)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 32, 38201, 40100, 40100)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 33, 40101, 42000, 42000)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 34, 42001, 43900, 43900)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 35, 43901, 45800, 45800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 36, 45801, 48200, 48200)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 37, 48201, 50600, 50600)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 38, 50601, 53000, 53000)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 39, 53001, 55400, 55400)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 40, 55401, 57800, 57800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 41, 57801, 60800, 60800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 42, 60801, 63800, 63800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 43, 63801, 66800, 66800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 44, 66801, 69800, 69800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 45, 69801, 72800, 72800)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 46, 72801, 76500, 76500)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 47, 76501, 80200, 80200)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 48, 80201, 83900, 83900)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 49, 83901, 87600, 87600)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 50, 87601, 92100, 92100)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 51, 92101, 96600, 96600)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 52, 96601, 101100, 101100)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 53,101101, 105600, 105600)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 54,105601, 110100, 110100)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 55,110101, 115500, 115500)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 56,115501, 120900, 120900)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 57,120901, 126300, 126300)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 58,126301, 131700, 131700)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 59,131701, 137100, 137100)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 60,137101, 142500, 142500)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 61,142501, 147900, 147900)
INSERT INTO BLRA (BSVER, BSLVL, BSLOW, BSHIH, BSAMT) VALUES (2, 62,147901, 2147483647, 150000)
-- ·s¼W¯¸¥x 2014-01-04
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '1109', '¤»°ô¤À¯¸');
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '1306', '·s²ø°Æ³£¤ß¤À¯¸');
Reference in New Issue View Git Blame Copy Permalink