| 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 |