Table: Sales Statistics

Table: OESTATS
View: OE0700
Record Length: 391

Flags: A R 

Keys: 1

Title Flags Fields
Currency\Year\Period YR, PERIOD, CURRENCY

Fields: 44

Field Type Title Presentation
YR String*4 Year Mask: %-4d
PERIOD Integer Period
CURRENCY String*3 Currency Mask: %-3N
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
NUMORD Long Number of Orders
QTYSOLD BCD*10.4 Net Quantity Sold
SALESAMTF BCD*10.3 Net Sales Amount (Func.)
SALESAMTS BCD*10.3 Net Sales Amount (Srce.)
INVAMTF BCD*10.3 Net Invoice Amount (Func.)
INVAMTS BCD*10.3 Net Invoice Amount (Srce.)
COGSF BCD*10.3 Cost of Sales (Func.)
COGSS BCD*10.3 Cost of Sales (Srce.)
INVCOUNT Long Number of Invoices
AVGINVF BCD*10.3 Average Invoice (Func.)
AVGINVS BCD*10.3 Average Invoice (Srce.)
LARGSTINF BCD*10.3 Largest Invoice (Func.)
LARGSTINS BCD*10.3 Largest Invoice (Srce.)
LINVCUST String*12 Customer (Largest Invoice) Mask: %-12C
SMALSTINF BCD*10.3 Smallest Invoice (Func.)
SMALSTINS BCD*10.3 Smallest Invoice (Srce.)
SINVCUST String*12 Customer (Smallest Invoice) Mask: %-12C
CNCOUNT Long Number of Credit Notes
AVGCNF BCD*10.3 Average Credit Note (Func.)
AVGCNS BCD*10.3 Average Credit Note (Srce.)
LARGSTCNF BCD*10.3 Largest Credit Note (Func.)
LARGSTCNS BCD*10.3 Largest Credit Note (Srce.)
LCNCUST String*12 Customer (Largest Credit Note) Mask: %-12C
SMALSTCNF BCD*10.3 Smallest Credit Note (Func.)
SMALSTCNS BCD*10.3 Smallest Credit Note (Srce.)
TSLELOSTF BCD*10.3 Total Sales Lost (Func.)
TSLELOSTS BCD*10.3 Total Sales Lost (Srce.)
SCNCUST String*12 Customer (Smallest Credit Note) Mask: %-12C
DNCOUNT Long Number of Debit Notes
AVGDNF BCD*10.3 Average Debit Note (Func.)
AVGDNS BCD*10.3 Average Debit Note (Srce.)
LARGSTDNF BCD*10.3 Largest Debit Note (Func.)
LARGSTDNS BCD*10.3 Largest Debit Note (Srce.)
LDNCUST String*12 Customer (Largest Debit Note) Mask: %-12C
SMALSTDNF BCD*10.3 Smallest Debit Note (Func.)
SMALSTDNS BCD*10.3 Smallest Debit Note (Srce.)
SDNCUST String*12 Customer (Smallest Debit Note) Mask: %-12C

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