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.