# View: Sales History Details

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

## Compositions: 0

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

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