Title | Fields |
---|---|
Customer | CUSTOMER, ITEM, YR, PERIOD |
Item Number | ITEM, CUSTOMER, YR, PERIOD |
Field | Index | Type | Title | Attributes | Presentation |
---|---|---|---|---|---|
CUSTOMER | 1 | String*12 | Customer Number | E A K R | Mask: %-12C |
ITEM | 2 | String*24 | Unformatted Item Number | E A K R | Mask: %-24C |
YR | 3 | String*4 | Year | E A K R | |
PERIOD | 4 | Integer | Period | E A K R | |
SCURN | 5 | String*3 | Currency | E A | Mask: %-3N |
QTYSOLD | 6 | BCD*10.4 | Quantity Sold | E A | |
FTOTSALES | 7 | BCD*10.3 | Func. Sales Amount | E A | |
STOTSALES | 8 | BCD*10.3 | Srce. Sales Amount | E A | |
FCSTSALES | 9 | BCD*10.3 | Func. Cost of Sales | E A | |
SCSTSALES | 10 | BCD*10.3 | Srce. Cost of Sales | E A | |
SALESCNT | 11 | Integer | Sales Count | E A | |
RETCNT | 12 | Integer | Returns Count | E A | |
FRETSALES | 13 | BCD*10.3 | Func. Return Amount | E A | |
SRETSALES | 14 | BCD*10.3 | Srce. Return Amount | E A | |
ITEMDESC | 50 | String*60 | Item Description | A C | |
CUSTDESC | 51 | String*60 | Customer Name | A C | |
MARGINF | 52 | BCD*5.5 | Func. Profit Margin | A C | |
MARGINS | 53 | BCD*5.5 | Srce. Profit Margin | A C | |
ITEMFMT | 54 | String*24 | Item Number | A C | Mask: %-24C |
This page was generated on 2009-Nov-19
Copyright © 2001–2009 Sage Software, Inc. All rights reserved.