# View: Sales History

RotoID: OE0690
Tables: OESHHD
DLL: OESHHD

## Compositions: 0

## Keys: 2

Title | Fields
--- | ---
Customer | CUSTOMER, ITEM, YR, PERIOD
Item Number | ITEM, CUSTOMER, YR, PERIOD

## Fields: 19

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
CUSTOMER | 1 | String*12 | Customer Number | E A K R | Mask: %-12C
ITEM | 2 | String*24 | 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 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.