Electronic Journal table

EJ table is used to store the EJ records. All the transaction share the same table regardless of the types of the transaction. Five fields are fixed as the following table shows:
Table 1.
  Key Fields ID Type Non-NULL
1 Yes UserID CHAR(32) Yes
2 Yes Date CHAR(8) Yes
3 Yes RecordSeqNum INT Yes
4   RestoreData VARCHAR(200)  
5   RestoreDetailData BLOB  
The UserID, Date and RecordSeqNum are the primary keys. The RestoreData is the transaction data and RestoreDetailData is the GUI information. Both of them are needed for Electronic Journal Viewer's recurrence. The RestoreDetailData can be the path of the BTT XUI file, the content of the XUI, the snapshot of the transaction UI, or some other kinds of GUI information.
In addition to the five fixed fields above, user can self-defined fields of journal in table. Please see the following table for details:
Table 2.
Header Header Header Non_Null
1 BankID CHAR(20)  
2 BranchID CHAR(20)  
3 SectionID CHAR(20)  
4 AdminID CHAR(20)  
5 TxnType CHAR(2)  
6 TxnID CHAR(12) Yes
7 Status CHAR(8)  
8 StartTime CHAR(16)  
9 EndTime CHAR(16)  
10 ErrorCode CHAR(8)  
11 ACCOUNT CHAR(26)  
12 ACCOUNT2 CHAR(26)  
13 AMOUNT DECIMAL(15,2)  
14 AMOUNT2 DECIMAL(15,2)  
15 CurrencyType CHAR(8)  
16 REMARK CHAR(32)  
17 Reserve1 CHAR(32)  
18 Reserve2 CHAR(64)