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 2023-Aug-31

© 2023 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).