View: Sales History

RotoID: OE0690
Table: OESHHD
Protocol: Flat
DLL:OESHHD

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 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 2022-Aug-18

© 2021 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).