| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CMRECNUM | Record Number |
Currency | 10 | View | |
| SEQUENCE1 | Sequence |
Currency | 10 | View | |
| JRNENTRY | Journal Entry |
Long Integer | 4 | View | |
| TRXDATE | TRX Date |
Date | 4 | View | |
| SOURCDOC | Source Document 1= Invoice |
String | 12 | View | |
| REFRENCE | Reference |
String | 32 | View | |
| ACTNUMBR_1 | Account Number:Account_Segment_Pool1 |
String | 10 | View | |
| ACTNUMBR_2 | Account Number:Account_Segment_Pool2 |
String | 10 | View | |
| ACTNUMBR_3 | Account Number:Account_Segment_Pool3 |
String | 10 | View | |
| ACTNUMBR_4 | Account Number:Account_Segment_Pool4 |
String | 10 | View | |
| ACTNUMBR_5 | Account Number:Account_Segment_Pool5 |
String | 10 | View | |
| ACTINDX | Account Index |
Long Integer | 4 | View | |
| ACTDESCR | Account Description |
String | 52 | View | |
| ACCATNUM | Account Category Number 1 = Cash |
Integer | 2 | View | |
| ACCTTYPE | Account Type Field values: |
Integer | 2 | View | |
| DEBITAMT | Debit Amount |
Currency | 10 | View | |
| CRDTAMNT | Credit Amount |
Currency | 10 | View | |
| DSCRIPTN | Description |
String | 32 | View |