declare @tTrnxType table
(idx int identity, code varchar(10), descrp varchar(100));
/*code is unique*/

insert into @tTrnxType(code, descrp) values('br','baru');
insert into @tTrnxType(code, descrp) values('tm','tambah');
insert into @tTrnxType(code, descrp) values('kr','kurang');
insert into @tTrnxType(code, descrp) values('bh','berhenti');


declare @tTrnxList table
(idx int identity, payer varchar(10), trnxType varchar(10), amt decimal(10,2), crtDte datetime);
/*trnxType is a foreign key to @tTrnxType(code)*/

insert into @tTrnxList(payer,trnxType,amt,crtdte) values('1925','br',200.50,getdate());
insert into @tTrnxList(payer,trnxType,amt,crtdte) values('4474','br',290.50,getdate());
insert into @tTrnxList(payer,trnxType,amt,crtdte) values('1174','br',290.50,getdate());
insert into @tTrnxList(payer,trnxType,amt,crtdte) values('8890','br',290.50,getdate());
insert into @tTrnxList(payer,trnxType,amt,crtdte) values('1925','tm',400.00,getdate());
insert into @tTrnxList(payer,trnxType,amt,crtdte) values('1925','kr',350.00,getdate());
insert into @tTrnxList(payer,trnxType,amt,crtdte) values('4474','kr',190.50,getdate());
insert into @tTrnxList(payer,trnxType,amt,crtdte) values('1925','tm',600.00,getdate());

my latest TrnxList
payer          | trnxType           | amt    | crtdte
----------------------------------------------------------
1925             tm                   600.00   <my datetime>
4474             kr                   190.50   <my datetime>
1174             br                   290.50   <my datetime>
8890             br                   290.50   <my datetime>