Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --account statement
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450146','T','MODULE_ACCOUNT_STATEMENT',0,'accountNo','account number','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450147','T','MODULE_ACCOUNT_STATEMENT',1,'currency','currency','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450148','T','MODULE_ACCOUNT_STATEMENT',2,'branchName','account branch','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450149','T','MODULE_ACCOUNT_STATEMENT',3,'transactionDate','transaction date','DAT','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014a','T','MODULE_ACCOUNT_STATEMENT',4,'transactionTime','transaction time','DAT','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014b','T','MODULE_ACCOUNT_STATEMENT',5,'postDate','posting date','DAT','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014c','T','MODULE_ACCOUNT_STATEMENT',6,'description','description','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014d','T','MODULE_ACCOUNT_STATEMENT',7,'refNo','reference number','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014e','T','MODULE_ACCOUNT_STATEMENT',8,'beneRefNo','beneficiary reference number','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014f','T','MODULE_ACCOUNT_STATEMENT',9,'totAmount','amount','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450150','T','MODULE_ACCOUNT_STATEMENT',10,'availableBalance','balance','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450151','T','MODULE_ACCOUNT_STATEMENT',11,'totalTransaction','total transaction','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450152','T','MODULE_ACCOUNT_STATEMENT',12,'openingBalance','opening balance','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450153','T','MODULE_ACCOUNT_STATEMENT',13,'closingBalance','closing balance','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450154','T','MODULE_ACCOUNT_STATEMENT',14,'totalDb','total debit','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450155','T','MODULE_ACCOUNT_STATEMENT',15,'totalCrd','total credit','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450156','T','MODULE_ACCOUNT_STATEMENT',16,'accountNoHeader','account No Header','ANM','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450157','T','MODULE_ACCOUNT_STATEMENT',17,'currencyHeader','currency Header','ANM','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450158','T','MODULE_ACCOUNT_STATEMENT',18,'branchNameHeader','branch Name Header','ANM','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450159','T','MODULE_ACCOUNT_STATEMENT',19,'openingBalanceHeader','opening Balance Header','DEC','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45015a','T','MODULE_ACCOUNT_STATEMENT',20,'closingBalanceHeader','closing Balance Header','DEC','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45015b','T','MODULE_ACCOUNT_STATEMENT',21,'totalTransactionFooter','total Transaction Header','ANM','N','F:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45015c','T','MODULE_ACCOUNT_STATEMENT',22,'totalDbFooter','total Debit Footer','DEC','N','F:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45015d','T','MODULE_ACCOUNT_STATEMENT',23,'totalCrdFooter','total Credit Footer','DEC','N','F:',null,null,null,null);
- --transaction inquiry
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001b','T','MODULE_TRANSACTION_INQUIRY',0,'accountNo','accountNo','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001c','T','MODULE_TRANSACTION_INQUIRY',1,'currency','currency','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001d','T','MODULE_TRANSACTION_INQUIRY',2,'branchName','account branch','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001e','T','MODULE_TRANSACTION_INQUIRY',3,'transactionDate','transaction date','DAT','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001f','T','MODULE_TRANSACTION_INQUIRY',4,'transactionTime','transaction time','DAT','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230020','T','MODULE_TRANSACTION_INQUIRY',5,'postDate','posting date','DAT','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230021','T','MODULE_TRANSACTION_INQUIRY',6,'description','description','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230022','T','MODULE_TRANSACTION_INQUIRY',7,'refNo','reference number','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230023','T','MODULE_TRANSACTION_INQUIRY',8,'beneRefNo','beneficiary reference number','ANM','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230024','T','MODULE_TRANSACTION_INQUIRY',9,'totAmount','amount','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230025','T','MODULE_TRANSACTION_INQUIRY',10,'availableBalance','balance','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230026','T','MODULE_TRANSACTION_INQUIRY',11,'totalTransaction','total transaction','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230027','T','MODULE_TRANSACTION_INQUIRY',12,'openingBalance','opening balance','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230028','T','MODULE_TRANSACTION_INQUIRY',13,'closingBalance','closing balance','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230029','T','MODULE_TRANSACTION_INQUIRY',14,'totalDb','total debit','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002a','T','MODULE_TRANSACTION_INQUIRY',15,'totalCrd','total credit','DEC','N','D:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002b','T','MODULE_TRANSACTION_INQUIRY',16,'accountNoHeader','account No Header','ANM','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002c','T','MODULE_TRANSACTION_INQUIRY',17,'currencyHeader','currency Header','ANM','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002d','T','MODULE_TRANSACTION_INQUIRY',18,'branchNameHeader','branch Name Header','ANM','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002e','T','MODULE_TRANSACTION_INQUIRY',19,'openingBalanceHeader','opening Balance Header','DEC','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002f','T','MODULE_TRANSACTION_INQUIRY',20,'closingBalanceHeader','closing Balance Header','DEC','N','H:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230030','T','MODULE_TRANSACTION_INQUIRY',21,'totalTransactionFooter','total Transaction Footer','ANM','N','F:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230031','T','MODULE_TRANSACTION_INQUIRY',22,'totalDbFooter','total Debit Footer','DEC','N','F:',null,null,null,null);
- insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230032','T','MODULE_TRANSACTION_INQUIRY',23,'totalCrdFooter','total Credit Footer','DEC','N','F:',null,null,null,null);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement