# Table: Sales History

Table: OESHHD
View: OE0690
Record length: 143
Flags: A R

## Keys: 2

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

## Fields: 18

Field | Type | Title | Presentation
--- | --- | --- | ---
CUSTOMER | String*12 | Customer Number | Mask: %-12C
ITEM | String*24 | Unformatted Item Number | Mask: %-24C
YR | String*4 | Year |
PERIOD | Integer | Period |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
SCURN | String*3 | Currency | Mask: %-3N
QTYSOLD | BCD*10.4 | Quantity Sold |
FTOTSALES | BCD*10.3 | Func. Sales Amount |
STOTSALES | BCD*10.3 | Srce. Sales Amount |
FCSTSALES | BCD*10.3 | Func. Cost of Sales |
SCSTSALES | BCD*10.3 | Srce. Cost of Sales |
SALESCNT | Integer | Sales Count |
RETCNT | Integer | Returns Count |
FRETSALES | BCD*10.3 | Func. Return Amount |
SRETSALES | BCD*10.3 | Srce. Return Amount |

This page was generated on 2008-May-01

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