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