| Column | Description | Data Type | Length | Tables This Field Is In | In Query () | 
| aaGLWorkHdrID | aaGLWorkHdrID  | 
									Long Integer | 4 | View | |
| aaGLWorkDistID | aaGLWorkDistID  | 
									Long Integer | 4 | View | |
| aaGLWorkAssignID | aaGLWorkAssignID  | 
									Long Integer | 4 | View | |
| JRNENTRY | Journal Entry  | 
									Long Integer | 4 | View | |
| RCTRXSEQ | Recurring TRX Sequence  | 
									Currency | 10 | View | |
| aaTRXType | aaTRXType  | 
									Integer | 2 | View | |
| GLPOSTDT | GL Posting Date  | 
									Date | 4 | View | |
| aaTrxDimID | aaTrxDimID  | 
									Long Integer | 4 | View | |
| aaTrxCodeID | aaTrxCodeID  | 
									Long Integer | 4 | View | |
| aaTrxDimCode | aaTrxDimCode  | 
									String | 32 | View | |
| INTERID | Intercompany ID  | 
									String | 6 | View | |
| ACTINDX | Account Index  | 
									Long Integer | 4 | View | |
| ACCTTYPE | Account Type Field values:  | 
									Integer | 2 | View | |
| DEBITAMT | Debit Amount  | 
									Currency | 10 | View | |
| CRDTAMNT | Credit Amount  | 
									Currency | 10 | View | |
| CURNCYID | Currency ID  | 
									String | 16 | View | |
| SQNCLINE | Sequence Line  | 
									Currency | 10 | View |