//`N SQL Oݤ@쩳 
//`N *tablename=columnname1,columnname1 //קR\׬0rݩ(Oiť)
//eCMS ĤG //l 990104
//`N[ add

[Data]

ALTER TABLE Employee ALTER COLUMN EPRMNAME VARCHAR(80)

[Public]

Update TnsFmt Set TFEmptyFg = 0 Where TFType = 'SRDef' and TFFldNameWK = 'WKBKIN'

Delete From TnsFmt Where TFType = 'SRDef' and TFFldNameWK = 'WKAMT'
Delete From TnsFmt Where TFType = 'SRDef' and TFFldNameWK = 'WKFEEFISC'
Delete From TnsFmt Where TFType = 'SRDef' and TFFldNameWK = 'WKFEEBK'

Delete From TnsFmt Where TFType = 'RMDef' and TFFldNameWK = 'WKAMT'
Delete From TnsFmt Where TFType = 'RMDef' and TFFldNameWK = 'WKFEEFISC'
Delete From TnsFmt Where TFType = 'RMDef' and TFFldNameWK = 'WKFEEBK'

Update TnsDef Set TDEmptyFg = 0 Where TDType = 'SRDefIn' and TDFldName = 'WKBKIN'
Update TnsDef Set TDEmptyFg = 0 Where TDType = 'SRDefOut' and TDFldName = 'WKBKIN'

Delete From TnsDef Where TDType = 'SRDefIn' and TDFldName = 'WKAMT'
Delete From TnsDef Where TDType = 'SRDefIn' and TDFldName = 'WKFEEFISC'
Delete From TnsDef Where TDType = 'SRDefIn' and TDFldName = 'WKFEEBK'

Delete From TnsDef Where TDType = 'SRDefOut' and TDFldName = 'WKAMT'
Delete From TnsDef Where TDType = 'SRDefOut' and TDFldName = 'WKFEEFISC'
Delete From TnsDef Where TDType = 'SRDefOut' and TDFldName = 'WKFEEBK'

Delete From TnsDef Where TDType = 'RMDefIn' and TDFldName = 'WKAMT'
Delete From TnsDef Where TDType = 'RMDefIn' and TDFldName = 'WKFEEFISC'
Delete From TnsDef Where TDType = 'RMDefIn' and TDFldName = 'WKFEEBK'

Delete From TnsDef Where TDType = 'RMDefOut' and TDFldName = 'WKAMT'
Delete From TnsDef Where TDType = 'RMDefOut' and TDFldName = 'WKFEEFISC'
Delete From TnsDef Where TDType = 'RMDefOut' and TDFldName = 'WKFEEBK'

Update TnsDef Set TDSNo = 9  Where TDType = 'SRDefIn' and TDFldName = 'WKSTATMSG'
Update TnsDef Set TDSNo = 10 Where TDType = 'SRDefIn' and TDFldName = 'WKREMARK'
Update TnsDef Set TDSNo = 11 Where TDType = 'SRDefIn' and TDFldName = 'WKADDRNOT'
Update TnsDef Set TDSNo = 12 Where TDType = 'SRDefIn' and TDFldName = 'WKTEL'
Update TnsDef Set TDSNo = 13 Where TDType = 'SRDefIn' and TDFldName = 'WKADDRNOM'
Update TnsDef Set TDSNo = 14 Where TDType = 'SRDefIn' and TDFldName = 'WKADDRMAIL'
Update TnsDef Set TDSNo = 15 Where TDType = 'SRDefIn' and TDFldName = 'WKIDNO'
Update TnsDef Set TDSNo = 16 Where TDType = 'SRDefIn' and TDFldName = 'WKDIGEST1'

Update TnsDef Set TDSNo = 9  Where TDType = 'SRDefOut' and TDFldName = 'WKSTATMSG'
Update TnsDef Set TDSNo = 10 Where TDType = 'SRDefOut' and TDFldName = 'WKREMARK'
Update TnsDef Set TDSNo = 11 Where TDType = 'SRDefOut' and TDFldName = 'WKADDRNOT'
Update TnsDef Set TDSNo = 12 Where TDType = 'SRDefOut' and TDFldName = 'WKTEL'
Update TnsDef Set TDSNo = 13 Where TDType = 'SRDefOut' and TDFldName = 'WKADDRNOM'
Update TnsDef Set TDSNo = 14 Where TDType = 'SRDefOut' and TDFldName = 'WKADDRMAIL'
Update TnsDef Set TDSNo = 15 Where TDType = 'SRDefOut' and TDFldName = 'WKIDNO'
Update TnsDef Set TDSNo = 16 Where TDType = 'SRDefOut' and TDFldName = 'WKDIGEST1'

Update TnsDef Set TDSNo = 9  Where TDType = 'RMDefIn' and TDFldName = 'WKSTATMSG'
Update TnsDef Set TDSNo = 10 Where TDType = 'RMDefIn' and TDFldName = 'WKREMARK'
Update TnsDef Set TDSNo = 11 Where TDType = 'RMDefIn' and TDFldName = 'WKADDRNOT'
Update TnsDef Set TDSNo = 12 Where TDType = 'RMDefIn' and TDFldName = 'WKTEL'
Update TnsDef Set TDSNo = 13 Where TDType = 'RMDefIn' and TDFldName = 'WKADDRNOM'
Update TnsDef Set TDSNo = 14 Where TDType = 'RMDefIn' and TDFldName = 'WKADDRMAIL'
Update TnsDef Set TDSNo = 15 Where TDType = 'RMDefIn' and TDFldName = 'WKIDNO'

Update TnsDef Set TDSNo = 9  Where TDType = 'RMDefOut' and TDFldName = 'WKSTATMSG'
Update TnsDef Set TDSNo = 10 Where TDType = 'RMDefOut' and TDFldName = 'WKREMARK'
Update TnsDef Set TDSNo = 11 Where TDType = 'RMDefOut' and TDFldName = 'WKADDRNOT'
Update TnsDef Set TDSNo = 12 Where TDType = 'RMDefOut' and TDFldName = 'WKTEL'
Update TnsDef Set TDSNo = 13 Where TDType = 'RMDefOut' and TDFldName = 'WKADDRNOM'
Update TnsDef Set TDSNo = 14 Where TDType = 'RMDefOut' and TDFldName = 'WKADDRMAIL'
Update TnsDef Set TDSNo = 15 Where TDType = 'RMDefOut' and TDFldName = 'WKIDNO'

//990422
Update RMRate Set RRAMTMAX = 50000000

[Work]

ALTER TABLE WKSalaryTns ALTER COLUMN WKRMNAME VARCHAR(80)