# View: Sales Statistics

RotoID: IC0710
Table: ICSTATI
Protocol: Flat
DLL: ICSTATI

## Compositions: 2

RotoID | Tables | Title | DLL
--- | --- | --- | ---
IC0310 | ICITEM | Items | ICITEM
IC0370 | ICLOC | Locations | ICLOC

## Keys: 1

Title | Fields
--- | ---
Statistics | ITEMNO, LOCATION, YEAR, PERIOD

## Fields: 16

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
ITEMNO | 1 | String*24 | Item Number | E A K R | Mask: %-24C
LOCATION | 2 | String*6 | Location | E A K R | Mask: %-6N
YEAR | 3 | String*4 | Year | E A K R | Mask: %4D
PERIOD | 4 | Integer | Period | E A K R |
SALESAMT | 6 | BCD*10.3 | Sales Amount | A |
SALESCOUNT | 7 | Long | Sales Count | A |
SALESQTY | 8 | BCD*10.4 | Sales Quantity | A |
COGS | 9 | BCD*10.3 | Cost of Goods Sold | A |
SALERTNAMT | 10 | BCD*10.3 | Sales Return Amount | A |
SALERTNCNT | 11 | Long | Sales Return Count | A |
SALERTNQTY | 12 | BCD*10.4 | Sales Return Quantity | A |
COGSRTN | 13 | BCD*10.3 | Cost of Goods Returned | A |
MARGIN | 22 | BCD*10.3 | Gross Margin | A C |
ITEMDESC | 23 | String*60 | Item Description | A C |
LOCDESC | 24 | String*60 | Location Description | A C |
STOCKUNIT | 25 | String*10 | Stocking Unit of Measure | A C |

This page was generated on 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.