# 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 2009-Nov-19

Copyright © 2001–2009 Sage Software, Inc. All rights reserved.