| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| DOCTYPE | Document Type |
Integer | 2 | View | |
| INVCNMBR | Invoice Number |
String | 22 | View | |
| SEQNUMBR | Sequence Number |
Long Integer | 4 | View | |
| DISTTYPE | Distribution Type 1 = Cash |
Integer | 2 | View | |
| DistRef | Distribution Reference |
String | 32 | View | |
| ACTINDX | Account Index |
Long Integer | 4 | View | |
| DEBITAMT | Debit Amount |
Currency | 10 | View | |
| CRDTAMNT | Credit Amount |
Currency | 10 | View | |
| TRXSORCE | TRX Source |
String | 14 | View | |
| POSTED | Posted |
Boolean | 2 | View |