Field 
Value 
Order Number 

Order Line Number 

Product # 

Product 

Qty 

Price 

Quantity Ordered 

Customer Number 

Purchase Order # 

Order Date 

Ship Date 

Order Type 

Order Status 

Order Amount 

Ship Via 

Ship Type 

Company Number 

Customer Name 

Customer Address Line 1 

Customer Address Line 2 

Customer Address Line 3 

Customer Address Line 4 

Customer state 

Customer zipcode 

Country 

Contact Name 

Phone Number 

Corporate Customer Number 

Customer Type 

Credit Limit in dollars 

Outstanding A/R Balance 

Total open orders in dollars 

Month to date discount lost 

Year to date discount lost 

Month to date taxes 

Year to date taxes 

Period 1 Sales  last year 

Period 2 Sales  last year 

Period 3 Sales  last year 

Period 4 Sales  last year 

Period 5 Sales  last year 

Period 6 Sales  last year 

Period 7 Sales  last year 

Period 8 Sales  last year 

Period 9 Sales  last year 

Period 10 Sales  last year 

Period 11 Sales  last year 

Period 12 Sales  last year 

Period 13 Sales  last year 

Sales Region 

Salesman Number 

Ship Via 

YTD Sales 

CR 

CPHONI 

Extended Price 
