# Table: Purchase History Detail

Table: POHSTL
View: PO0384
Record length: 324
Flags: A R

## Keys: 5

Title | Flags | Fields
--- | --- | ---
Vendor |  | VENDOR, ITEMNO, FISCYEAR, FISCPERIOD, TRANSDATE, POSTSEQNUM, ENTRYNUM, LINESEQ
Item Number |  | ITEMNO, VENDOR, FISCYEAR, FISCPERIOD, TRANSDATE, POSTSEQNUM, ENTRYNUM, LINESEQ
Vendor |  | VENDOR, ITEMNO, TRANSDATE, FISCYEAR, FISCPERIOD, POSTSEQNUM, ENTRYNUM, LINESEQ
Item Number |  | ITEMNO, VENDOR, TRANSDATE, FISCYEAR, FISCPERIOD, POSTSEQNUM, ENTRYNUM, LINESEQ
Detail Number |  | ITEMNO, VENDOR, TRANSDATE, FISCYEAR, FISCPERIOD, POSTSEQNUM, ENTRYNUM, DETAILNUM, LINESEQ

## Fields: 36

Field | Type | Title | Presentation
--- | --- | --- | ---
VENDOR | String*12 | Vendor | Mask: %-12C
ITEMNO | String*24 | Item Number | Mask: %-24C
FISCYEAR | String*4 | Fiscal Year | Mask: %4D
FISCPERIOD | Integer | Fiscal Period |
TRANSDATE | Date | Transaction Date |
POSTSEQNUM | Long | Day End Number |
ENTRYNUM | Long | Transaction Sequence |
LINESEQ | BCD*10.0 | Line Number |
AUDTDATE | Date |  |
AUDTTIME | Time |  |
AUDTUSER | String*8 |  |
AUDTORG | String*6 |  |
HEADSEQ | BCD*10.0 | Header Sequence |
CURRENCY | String*3 | Currency | Mask: %-3N
TRANSTYPE | Integer | Transaction Type | List: 7 entries
1 | = | Requisition
2 | = | Purchase Order
3 | = | Receipt
4 | = | Return
5 | = | Invoice
6 | = | Credit Note
7 | = | Debit Note
DOCNUMBER | String*22 | Document Number | Mask: %-22C
LOCATION | String*6 | Location | Mask: %-6N
RQPOSTED | BCD*10.4 | Quantity |
SQPOSTED | BCD*10.4 | Stocking Quantity |
UNIT | String*10 | Unit of Measure | Mask: %-10c
CONV | BCD*10.6 | Conversion Factor |
SCEXTENDED | BCD*10.3 | Srce. Cost |
FCEXTENDED | BCD*10.3 | Func. Cost |
RCPDAYS | Integer | Days To Receive |
RQTOTAL | BCD*10.4 | Total Quantity |
SQTOTAL | BCD*10.4 | Stocking Total Quantity |
SCTOTAL | BCD*10.3 | Srce. Total Cost |
FCTOTAL | BCD*10.3 | Func. Total Cost |
SCDISCOUNT | BCD*10.3 | Discount Amount |
FCDISCOUNT | BCD*10.3 | Func. Discount Amount |
SCDISCTOT | BCD*10.3 | Total Discount |
FCDISCTOT | BCD*10.3 | Functional Total Discount |
CONTRACT | String*16 | Contract | Mask: %-16C
PROJECT | String*16 | Project | Mask: %-16N
CCATEGORY | String*16 | (Cost) Category | Mask: %-16N
DETAILNUM | Integer | Detail Number |

This page was generated on 2009-Nov-19

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