View: Sales History Details

RotoID: OE0685
Table: OESHDT
Protocol: Flat
DLL:OESHDT

Keys: 6

Title Fields
Customer CUSTOMER, ITEM, YR, PERIOD, TRANDATE, DAYENDSEQ, TRANSSEQ, LINENO
Item ITEM, CUSTOMER, YR, PERIOD, TRANDATE, DAYENDSEQ, TRANSSEQ, LINENO
Salesperson SALESPER, YR, PERIOD, CUSTOMER, TRANTYPE, TRANNUM
Customer/Transaction Date CUSTOMER, ITEM, TRANDATE, YR, PERIOD, DAYENDSEQ, TRANSSEQ, LINENO
Item/Transaction Date ITEM, CUSTOMER, TRANDATE, YR, PERIOD, DAYENDSEQ, TRANSSEQ, LINENO
Salesperson/Transaction Date SALESPER, TRANDATE, YR, PERIOD, CUSTOMER, TRANTYPE, TRANNUM

Fields: 33

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  Mask: %-4d
PERIOD 4 Integer Period E A K R 
TRANDATE 5 Date Trans. Date E A K R 
DAYENDSEQ 6 Long Day End Number E A K R 
TRANSSEQ 7 Long Entry Number E A K R 
LINENO 8 Integer Line Number E A K R 
TRANNUM 9 String*22 Trans. Number E A  Mask: %-22C
TRANTYPE 10 Integer Trans. Type E A  List:3 entries
1 = Invoice
2 = Credit Note
4 = Debit Note
ORDDATE 11 Date Order Date E A 
ORDNUMBER 12 String*22 Order Number E A  Mask: %-22C
SHIPDATE 13 Date Ship Date E A 
SALESPER 14 String*8 Salesperson E A  Mask: %-8N
TERRITORY 15 String*6 Territory E A  Mask: %-6N
LOCATION 16 String*6 Location E A  Mask: %-6N
CATEGORY 17 String*6 Category E A  Mask: %-6N
QTYSOLD 18 BCD*10.4 Quantity Sold E A 
SCURN 19 String*3 Cust. Currency E A  Mask: %-3N
FCSTSALES 20 BCD*10.3 Func. Cost of Sales E A 
SCSTSALES 21 BCD*10.3 Srce. Cost of Sales E A 
FAMTSALES 22 BCD*10.3 Func. Sales Amount E A 
SAMTSALES 23 BCD*10.3 Srce. Sales Amount E A 
FRETSALES 24 BCD*10.3 Func. Return Amount E A 
SRETSALES 25 BCD*10.3 Srce. Return Amount E A 
PONUMBER 26 String*22 Purchase Order Number E A 
FAMTTRAN 27 BCD*10.3 Functional Amount E A 
SAMTTRAN 28 BCD*10.3 Source Amount E A 
FAMTDISC 29 BCD*10.3 Functional Discount Amount E A 
SAMTDISC 30 BCD*10.3 Source Discount Amount E A 
SHINUMBER 31 String*22 Shipment Number E A  Mask: %-22C
SHIDTLNUM 32 Integer Shipment Detail Number E A 
ITEMFMT 50 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).