Table: Purchase History Detail

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

Keys: 2


Title  Flags  Fields
Vendor   VENDOR, ITEMNO, FISCYEAR, FISCPERIOD, TRANSDATE, POSTSEQNUM, ENTRYNUM, LINESEQ
Item Number   ITEMNO, VENDOR, FISCYEAR, FISCPERIOD, TRANSDATE, POSTSEQNUM, ENTRYNUM, LINESEQ

Fields: 28


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*15  Document Number  Mask: %-16C
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  Cost (S)   
FCEXTENDED  BCD*10.3  Cost (F)   
RCPDAYS  Integer  Days To Receive   
RQTOTAL  BCD*10.4  Total Quantity   
SQTOTAL  BCD*10.4  Stocking Total Quantity   
SCTOTAL  BCD*10.3  Total Cost (S)   
FCTOTAL  BCD*10.3  Total Cost (F)   

This page was generated on 2002-Oct-04

Copyright © 2002 ACCPAC International, Inc. All rights reserved.