Table: Sales History Details

Table: OESHDT
View: OE0685
Record Length: 322

Flags: A R 

Keys: 6

Title Flags Fields
Customer CUSTOMER, ITEM, YR, PERIOD, TRANDATE, DAYENDSEQ, TRANSSEQ, LINENO
Item ITEM, CUSTOMER, YR, PERIOD, TRANDATE, DAYENDSEQ, TRANSSEQ, LINENO
Salesperson D M  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 D M  SALESPER, TRANDATE, YR, PERIOD, CUSTOMER, TRANTYPE, TRANNUM

Fields: 36

Field Type Title Presentation
CUSTOMER String*12 Customer Number Mask: %-12C
ITEM String*24 Item Number Mask: %-24C
YR String*4 Year Mask: %-4d
PERIOD Integer Period
TRANDATE Date Trans. Date
DAYENDSEQ Long Day End Number
TRANSSEQ Long Entry Number
LINENO Integer Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
TRANNUM String*22 Trans. Number Mask: %-22C
TRANTYPE Integer Trans. Type List:3 entries
1 = Invoice
2 = Credit Note
4 = Debit Note
ORDDATE Date Order Date
ORDNUMBER String*22 Order Number Mask: %-22C
SHIPDATE Date Ship Date
SALESPER String*8 Salesperson Mask: %-8N
TERRITORY String*6 Territory Mask: %-6N
LOCATION String*6 Location Mask: %-6N
CATEGORY String*6 Category Mask: %-6N
QTYSOLD BCD*10.4 Quantity Sold
SCURN String*3 Cust. Currency Mask: %-3N
FCSTSALES BCD*10.3 Func. Cost of Sales
SCSTSALES BCD*10.3 Srce. Cost of Sales
FAMTSALES BCD*10.3 Func. Sales Amount
SAMTSALES BCD*10.3 Srce. Sales Amount
FRETSALES BCD*10.3 Func. Return Amount
SRETSALES BCD*10.3 Srce. Return Amount
PONUMBER String*22 Purchase Order Number
FAMTTRAN BCD*10.3 Functional Amount
SAMTTRAN BCD*10.3 Source Amount
FAMTDISC BCD*10.3 Functional Discount Amount
SAMTDISC BCD*10.3 Source Discount Amount
SHINUMBER String*22 Shipment Number Mask: %-22C
SHIDTLNUM Integer Shipment Detail Number

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