| Column | Description | Data Type | Length | Tables This Field Is In | In Query () |
| CUSTNMBR | Customer Number |
String | 16 | View | |
| PERIODID | Period ID |
Integer | 2 | View | |
| YEAR1 | Year |
Integer | 2 | View | |
| HISTTYPE | History Type |
Integer | 2 | View | |
| NUMOFINV | Number of Invoices |
Long Integer | 4 | View | |
| SMRYSALS | Summary Sales |
Currency | 10 | View | |
| SMRYCRCD | Summary Cash Received |
Currency | 10 | View | |
| SMRYCOST | Summary Costs |
Currency | 10 | View | |
| SMRYWROF | Summary Writoffs |
Currency | 10 | View | |
| SMRYDISC | Summary Discounts |
Currency | 10 | View | |
| SMRYRTNG | Summary Retainage |
Currency | 10 | View | |
| SMRYFCHR | Summary Finance Charges |
Currency | 10 | View | |
| SMRYWFCH | Summary Waived Fin Chrg |
Currency | 10 | View | |
| SMRYRTRN | Summary Returns |
Currency | 10 | View |