| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| USERID | User ID |
String | 16 | View | |
| BCHSOURC | Batch Source |
String | 16 | View | |
| BACHNUMB | Batch Number |
String | 16 | View | |
| JRNENTRY | Journal Entry |
Long Integer | 4 | View | |
| SQNCLINE | Sequence Line |
Currency | 10 | View | |
| ACTINDX | Account Index |
Long Integer | 4 | View | |
| OFFINDX | Offset Account Index |
Long Integer | 4 | View | |
| TRXAMNT | TRX Amount |
Currency | 10 | View | |
| GLLINMSG | GL LINE Messages |
Long Integer | 4 | View | |
| GLLINMS2 | GL LINE Messages2 |
Long Integer | 4 | View | |
| TRXDATE | TRX Date |
Date | 4 | View | |
| ACCTTYPE | Account Type Field values: |
Integer | 2 | View | |
| DSCRIPTN | Description |
String | 32 | View | |
| CURNCYID | Currency ID |
String | 16 | View | |
| CURRNIDX | Currency Index |
Integer | 2 | View | |
| FUNCRIDX | Functional Currency Index |
Integer | 2 | View | |
| ORIGAMT | Originating Amount |
Currency | 10 | View | |
| DOCNUMBR | Document Number |
String | 22 | View | |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| CUSTNAME | Customer Name |
String | 66 | View | |
| DOCDATE | Document Date |
Date | 4 | View |