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 2021-Nov-24

© 2021 Sage Software, Inc. All rights reserved. Reproduction of part or all of the contents in any form is prohibited unless for personal use. None of the content of this article may be copied or otherwise incorporated into any other document, publication or other work in any form (whether written, electronic or other format).

Sage Software, Inc. makes no warranties, representations or undertakings about any of the content of articles (including, without limitation, any as to the quality, accuracy, completeness or fitness for any particular purpose of such content).