| 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 |
| 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
|
|||||||||
| 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 | ||||||||||
| ITEMFMT | 50 | String*24 | Item Number | A C | Mask: %-24C | |||||||||
This page was generated on 2008-May-01
Copyright © 2001–2008 Sage Software, Inc. All rights reserved.