API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Jan 17th, 2017
119
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.24 KB | None | 0 0
raw download clone embed print report
  1. --account statement
  2. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450146','T','MODULE_ACCOUNT_STATEMENT',0,'accountNo','account number','ANM','N','D:',null,null,null,null);
  3. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450147','T','MODULE_ACCOUNT_STATEMENT',1,'currency','currency','ANM','N','D:',null,null,null,null);
  4. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450148','T','MODULE_ACCOUNT_STATEMENT',2,'branchName','account branch','ANM','N','D:',null,null,null,null);
  5. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450149','T','MODULE_ACCOUNT_STATEMENT',3,'transactionDate','transaction date','DAT','N','D:',null,null,null,null);
  6. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014a','T','MODULE_ACCOUNT_STATEMENT',4,'transactionTime','transaction time','DAT','N','D:',null,null,null,null);
  7. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014b','T','MODULE_ACCOUNT_STATEMENT',5,'postDate','posting date','DAT','N','D:',null,null,null,null);
  8. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014c','T','MODULE_ACCOUNT_STATEMENT',6,'description','description','ANM','N','D:',null,null,null,null);
  9. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014d','T','MODULE_ACCOUNT_STATEMENT',7,'refNo','reference number','ANM','N','D:',null,null,null,null);
  10. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014e','T','MODULE_ACCOUNT_STATEMENT',8,'beneRefNo','beneficiary reference number','ANM','N','D:',null,null,null,null);
  11. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45014f','T','MODULE_ACCOUNT_STATEMENT',9,'totAmount','amount','DEC','N','D:',null,null,null,null);
  12. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450150','T','MODULE_ACCOUNT_STATEMENT',10,'availableBalance','balance','DEC','N','D:',null,null,null,null);
  13. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450151','T','MODULE_ACCOUNT_STATEMENT',11,'totalTransaction','total transaction','DEC','N','D:',null,null,null,null);
  14. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450152','T','MODULE_ACCOUNT_STATEMENT',12,'openingBalance','opening balance','DEC','N','D:',null,null,null,null);
  15. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450153','T','MODULE_ACCOUNT_STATEMENT',13,'closingBalance','closing balance','DEC','N','D:',null,null,null,null);
  16. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450154','T','MODULE_ACCOUNT_STATEMENT',14,'totalDb','total debit','DEC','N','D:',null,null,null,null);
  17. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450155','T','MODULE_ACCOUNT_STATEMENT',15,'totalCrd','total credit','DEC','N','D:',null,null,null,null);
  18. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450156','T','MODULE_ACCOUNT_STATEMENT',16,'accountNoHeader','account No Header','ANM','N','H:',null,null,null,null);
  19. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450157','T','MODULE_ACCOUNT_STATEMENT',17,'currencyHeader','currency Header','ANM','N','H:',null,null,null,null);
  20. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450158','T','MODULE_ACCOUNT_STATEMENT',18,'branchNameHeader','branch Name Header','ANM','N','H:',null,null,null,null);
  21. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c450159','T','MODULE_ACCOUNT_STATEMENT',19,'openingBalanceHeader','opening Balance Header','DEC','N','H:',null,null,null,null);
  22. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45015a','T','MODULE_ACCOUNT_STATEMENT',20,'closingBalanceHeader','closing Balance Header','DEC','N','H:',null,null,null,null);
  23. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45015b','T','MODULE_ACCOUNT_STATEMENT',21,'totalTransactionFooter','total Transaction Header','ANM','N','F:',null,null,null,null);
  24. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45015c','T','MODULE_ACCOUNT_STATEMENT',22,'totalDbFooter','total Debit Footer','DEC','N','F:',null,null,null,null);
  25. insert into FILE_UPLD_FLD values('8a8a688258fcbd020158fd618c45015d','T','MODULE_ACCOUNT_STATEMENT',23,'totalCrdFooter','total Credit Footer','DEC','N','F:',null,null,null,null);
  26.  
  27. --transaction inquiry
  28. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001b','T','MODULE_TRANSACTION_INQUIRY',0,'accountNo','accountNo','ANM','N','D:',null,null,null,null);
  29. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001c','T','MODULE_TRANSACTION_INQUIRY',1,'currency','currency','ANM','N','D:',null,null,null,null);
  30. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001d','T','MODULE_TRANSACTION_INQUIRY',2,'branchName','account branch','ANM','N','D:',null,null,null,null);
  31. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001e','T','MODULE_TRANSACTION_INQUIRY',3,'transactionDate','transaction date','DAT','N','D:',null,null,null,null);
  32. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223001f','T','MODULE_TRANSACTION_INQUIRY',4,'transactionTime','transaction time','DAT','N','D:',null,null,null,null);
  33. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230020','T','MODULE_TRANSACTION_INQUIRY',5,'postDate','posting date','DAT','N','D:',null,null,null,null);
  34. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230021','T','MODULE_TRANSACTION_INQUIRY',6,'description','description','ANM','N','D:',null,null,null,null);
  35. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230022','T','MODULE_TRANSACTION_INQUIRY',7,'refNo','reference number','ANM','N','D:',null,null,null,null);
  36. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230023','T','MODULE_TRANSACTION_INQUIRY',8,'beneRefNo','beneficiary reference number','ANM','N','D:',null,null,null,null);
  37. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230024','T','MODULE_TRANSACTION_INQUIRY',9,'totAmount','amount','DEC','N','D:',null,null,null,null);
  38. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230025','T','MODULE_TRANSACTION_INQUIRY',10,'availableBalance','balance','DEC','N','D:',null,null,null,null);
  39. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230026','T','MODULE_TRANSACTION_INQUIRY',11,'totalTransaction','total transaction','DEC','N','D:',null,null,null,null);
  40. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230027','T','MODULE_TRANSACTION_INQUIRY',12,'openingBalance','opening balance','DEC','N','D:',null,null,null,null);
  41. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230028','T','MODULE_TRANSACTION_INQUIRY',13,'closingBalance','closing balance','DEC','N','D:',null,null,null,null);
  42. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230029','T','MODULE_TRANSACTION_INQUIRY',14,'totalDb','total debit','DEC','N','D:',null,null,null,null);
  43. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002a','T','MODULE_TRANSACTION_INQUIRY',15,'totalCrd','total credit','DEC','N','D:',null,null,null,null);
  44. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002b','T','MODULE_TRANSACTION_INQUIRY',16,'accountNoHeader','account No Header','ANM','N','H:',null,null,null,null);
  45. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002c','T','MODULE_TRANSACTION_INQUIRY',17,'currencyHeader','currency Header','ANM','N','H:',null,null,null,null);
  46. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002d','T','MODULE_TRANSACTION_INQUIRY',18,'branchNameHeader','branch Name Header','ANM','N','H:',null,null,null,null);
  47. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002e','T','MODULE_TRANSACTION_INQUIRY',19,'openingBalanceHeader','opening Balance Header','DEC','N','H:',null,null,null,null);
  48. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e63223002f','T','MODULE_TRANSACTION_INQUIRY',20,'closingBalanceHeader','closing Balance Header','DEC','N','H:',null,null,null,null);
  49. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230030','T','MODULE_TRANSACTION_INQUIRY',21,'totalTransactionFooter','total Transaction Footer','ANM','N','F:',null,null,null,null);
  50. insert into FILE_UPLD_FLD values('8a8a688258d3da060158d3e632230031','T','MODULE_TRANSACTION_INQUIRY',22,'totalDbFooter','total Debit Footer','DEC','N','F:',null,null,null,null);
  51. 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
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!