| RotoID | Tables | Title | DLL |
|---|---|---|---|
| IC0310 | ICITEM | Items | ICITEM |
| IC0370 | ICLOC | Locations | ICLOC |
| Title | Fields |
|---|---|
| Statistics | ITEMNO, LOCATION, YEAR, PERIOD |
| 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.