-- 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','xq','x')
INSERT INTO BDPT (BDNUM, BDNAM, BDSNM) VALUES ('X','L','L')

-- 2/19 suƻȦ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 sOAאּ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 [OW[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'    --xT
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'    --xT
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[[ZOp覡
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','Li')

-- 4/29 W[[ZOp覡O
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPRJOVR','4','O')

-- 5/4 W[u~ƪAHέ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 [jMɥ[ZOpHμ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','[ZO (|ˤJA[`)','ROUND(ROUND(ROUND(@~/240, 0) + @뭹O/240, 0) * @[ZO * @ɼ, 0)',1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/3','INSERT','X001','A002','[ZO ([`A|ˤJ)','ROUND(ROUND(@~/240, 0) + @뭹O/240, 0) * @[ZO * @ɼ',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','_[ZO','ROUND((@~/240 + @뭹O/240) * @[ZO, 0) * @ɼ', 1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/4','INSERT','X001','A002','˭][ZO','ROUND((@~/240 + @뭹O/240) * @[ZO, 0) * @ɼ', 1);
INSERT INTO BFRM (TRDAT, TRMOD, TRUSR, BFNUM, BFNAM, BFFRM, APPNO) VALUES ('2008/6/4','INSERT','X001','A003','[ZO','ROUND(CEILING(@~/240 + @뭹O/240) * @[ZO * @ɼ, 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ҰhB
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[¾aOOOv]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', 'դhZ', '2008/7/25', 'INSERT', 'X001')

-- 12/23 ŶZ BFDT W[Ƶ
ALTER TABLE BFDT ADD BFRMK VARCHAR(20)
GO

UPDATE BFDT SET BFRMK='ҫOO' WHERE BFTYP=1
UPDATE BFDT SET BFRMK='OO' WHERE BFTYP=2
UPDATE BFDT SET BFRMK='Ұh۴' WHERE BFTYP=3

-- 12/31 W[Ov[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', 'ҫOq˯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', 'ҫOq˯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', 'ҫON~OI', 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', 'ҫOuv', 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 Rn BWEX ơAå[JK|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', 'EQK~Ӯ׺޲z[SwHN~AȬu@ҰȻݨDpe', 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', 'EQK~SwHN~AȭҰȻݨDpe', 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', 'EQK~N~AȬu@ҰȻݨDpe', 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', 'EQK~N~Aȥ~iu@pe(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', '¾~Vm')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0002', 's¾~Vm')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0003', '_¾~Vm')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0004', '¾~Vm')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0005', 'n¾~Vm')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0006', '¾~Vm')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '0007', 'xn¾~Vm')

-- 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]    OX: 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]    OX: 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]    OX: 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]    OX: 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覡AHάUMצ~ױ
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','˭]Ӻޥ[ZO','ROUND((@~/240 + @뭹O/240) * @[ZO * @ɼ, 0)',1);

-- 98/8/10 W[ȤM׷~AO
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ҤuB', '2009/08/10', 'INSERT', 'X002')
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR, TRDAT, TRMOD, TRUSR) VALUES ('BCUSTRD', 'S', 'FҤuB', '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 sWҫO¾aOv
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 sWOOv
-- 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[DMפHeG[ZBG[ZB[Z[ZO
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2010/7/2', 'INSERT', 'X002', 'DMפHeG[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', 'DMפHG[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', 'DMפ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', 'xn', '')
UPDATE BPSN SET BPACT='s_' WHERE BPACT='x_'
UPDATE BPSN SET BPACT='x' WHERE BPACT='x'
UPDATE BPSN SET BPACT='xn' WHERE BPACT='xn'
UPDATE BPSN SET BPACT='' WHERE BPACT=''
UPDATE BPSN SET BPASA='Fn󢲢Ѣˢ'  WHERE BPENO='00063' 
UPDATE BPSN SET BPASA='F_jIqѢ'  WHERE BPENO='00065' 
UPDATE BPSN SET BPASA='MMMѢТ'  WHERE BPENO='00067' 
UPDATE BPSN SET BPASA='U樽tTU'  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='FFF󢰢Ѣˢ'  WHERE BPENO='00079' 
UPDATE BPSN SET BPASA='ШM'  WHERE BPENO='00083' 
UPDATE BPSN SET BPASA='sFˮvqѢ'  WHERE BPENO='00085' 
UPDATE BPSN SET BPASA='󨽺aص󢰢Ѣˢ'  WHERE BPENO='00086' 
UPDATE BPSN SET BPASA='sܨsѢ'  WHERE BPENO='00089' 
UPDATE BPSN SET BPASA='YaFj󢲫Ѣ'  WHERE BPENO='00137' 
UPDATE BPSN SET BPASA='YaYaѢ'  WHERE BPENO='00149' 
UPDATE BPSN SET BPASA='sܨFsܵ@qѢˢ'  WHERE BPENO='00153' 
UPDATE BPSN SET BPASA='qҦZѢ'  WHERE BPENO='00154' 
UPDATE BPSN SET BPASA='M10Fs2q120'  WHERE BPENO='00190' 
UPDATE BPSN SET BPASA='qǨ5FӸGq707'  WHERE BPENO='00242' 
UPDATE BPSN SET BPASA='q2FR52'  WHERE BPENO='00261' 
UPDATE BPSN SET BPASA='FݥЫ335'  WHERE BPENO='00270' 
UPDATE BPSN SET BPASA='YaYa192117'  WHERE BPENO='00324' 
UPDATE BPSN SET BPASA='TMKFT13'  WHERE BPENO='00454' 

UPDATE BPSN SET BPLCY=SUBSTRING(BPLCY, 1, LEN(BPLCY) - 1) + '' WHERE BPLCT IN ('x_', 'x', 'xn', '')
UPDATE BPSN SET BPLCT='s_' WHERE BPLCT='x_'
UPDATE BPSN SET BPLCT='x' WHERE BPLCT='x'
UPDATE BPSN SET BPLCT='xn' WHERE BPLCT='xn'
UPDATE BPSN SET BPLCT='' WHERE BPLCT=''
UPDATE BPSN SET BPLSA='Fn󢲢Ѣˢ'             WHERE BPENO='00063'
UPDATE BPSN SET BPLSA='F_jIqѢ'                       WHERE BPENO='00065'
UPDATE BPSN SET BPLSA='MMMѢТ'                   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='FFF󢰢Ѣˢ'                 WHERE BPENO='00079'
UPDATE BPSN SET BPLSA='ЧM'                             WHERE BPENO='00083'
UPDATE BPSN SET BPLSA='sFˮvqѢ'                 WHERE BPENO='00085'
UPDATE BPSN SET BPLSA='aص󢰢Ѣˢ'                   WHERE BPENO='00086'
UPDATE BPSN SET BPLSA='sܧsѢ'                       WHERE BPENO='00089'
UPDATE BPSN SET BPLSA='YaFj󢲫Ѣ'                       WHERE BPENO='00137'
UPDATE BPSN SET BPLSA='YaYaѢ'                   WHERE BPENO='00149'
UPDATE BPSN SET BPLSA='sܧFsܵ@qѢˢ'     WHERE BPENO='00153'
UPDATE BPSN SET BPLSA='qҦZѢ'                       WHERE BPENO='00154'
UPDATE BPSN SET BPLSA='M10Fs2q120'                       WHERE BPENO='00190'
UPDATE BPSN SET BPLSA='qǧ5FӸGq707'                       WHERE BPENO='00242'
UPDATE BPSN SET BPLSA='q2FR52'                            WHERE BPENO='00261'
UPDATE BPSN SET BPLSA='YaYa192117'                         WHERE BPENO='00324'
UPDATE BPSN SET BPLSA='TMKFT13'                               WHERE BPENO='00454'
UPDATE BPSN SET BPLSA='xZϥ|16'                           WHERE BPENO='00547'


-- 100 ~ 1  1 ҫOOvվHίŶZվ
UPDATE BRTE SET BREDT='2010/12/31', TRDAT='2011/1/9', TRMOD='UPDATE', TRUSR='X001' WHERE BRTYP='ҫOq˯f' AND BRVER=2
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2011/01/09', 'INSERT', 'X001', 'ҫOq˯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 sWҫO¾aOv
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 ҫOOvվHίŶZվ
UPDATE BRTE SET BREDT='2011/12/31', TRDAT='2012/2/3', TRMOD='UPDATE', TRUSR='X001' WHERE BRTYP='ҫOq˯f' AND BRVER=3
INSERT INTO BRTE (TRDAT, TRMOD, TRUSR, BRTYP, BRVER, BRRTE, BRSDT, BREDT, APPNO) VALUES ('2011/02/03', 'INSERT', 'X001', 'ҫOq˯f', 4, 0.075, '2012/01/01', NULL, 1)
                 
===========================================
IIIII   101 ~s~ּ  IIIII
===========================================

-- W[O
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('RPARTYP', '0D', '');
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('RPARTYP', '33', 'X');


-- RPAR HOά 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 HOñ֬ ƪsW
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);

--HJɡAñd 0
--~HJɡAñdñd

-- W[ƪ RPAC ɥRP
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);


-- sWWUZɶ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');

-- sWHS
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);

-- sWXtO
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 sW
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 Wz SQL w槹

--- 2012/2/21 sW~Hb
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 sWñ֤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);


---- Wz SQL wg槹

-- 2012/4/14 ] RPAR.RPTCT ѮɼƧאּơAHU SQL
-- 1. RPAR.RPTCT DoƶO̡AH 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. ק SSMSVIEWA 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 sW 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 sWtȦaI RPPLC
ALTER TABLE RPAR ADD RPPLC        NVARCHAR( 20)         NULL ;

-- 2012/06/04 sW~ׯ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);

---- Wz SQL wg槹

-- վñɬ[cAɸ

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ŶZi
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ŶZi
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ŶZi              
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)

-- sWx 2014-01-04
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '1109', '');
INSERT INTO BCLS (BSPAR, BSCLS, BSSCR) VALUES ('BPSNBRH', '1306', 'sƳߤ');