| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| JRNENTRY | Journal Entry |
Long Integer | 4 | View | |
| SQNCLINE | Sequence Line |
Currency | 10 | View | |
| DTAControlNum | DTA Control Number |
String | 22 | View | |
| DTATRXType | DTA TRX Type |
Integer | 2 | View | |
| ACTINDX | Account Index |
Long Integer | 4 | View | |
| DEBITAMT | Debit Amount |
Currency | 10 | View | |
| CRDTAMNT | Credit Amount |
Currency | 10 | View | |
| TRXDATE | TRX Date |
Date | 4 | View | |
| YEAR1 | Year |
Integer | 2 | View | |
| PERIODID | Period ID |
Integer | 2 | View | |
| BACHNUMB | Batch Number |
String | 16 | View | |
| BCHSOURC | Batch Source |
String | 16 | View | |
| SOURCDOC | Source Document 1= Invoice |
String | 12 | View | |
| REFRENCE | Reference |
String | 32 | View |