Table: Purchase Orders

Table: POPORH1
View: PO0620
Record length: 2395
Flags: A R 

Keys: 5

Title  Flags  Fields

Master Key  PORHSEQ
Purchase Orders  PONUMBER
Vendor  M  VDCODE, PORHSEQ
Vendor Document Number  M  VDCODE, PONUMBER
Pending Receipts Inquiry  M  PORHSEQ, VDCODE, DATE

Fields: 172

Field  Type  Title  Presentation 

PORHSEQ  BCD*10.0  Purchase Order Sequence Key   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
NEXTLSEQ  BCD*10.0  Next Line Sequence   
LINES  Long  Lines   
LINESCMPL  Long  Lines Complete   
TAXLINES  Long  Lines Tax Calculation Sees   
RQNS  Long  Requisitions   
RQNSCMPL  Long  Requisitions Completed   
ISPRINTED  Boolean  Printed  List: 2 entries
0=No
1=Yes
TAXAUTOCAL  Boolean  Auto. tax calculation on save  List: 2 entries
0=No
1=Yes
LABELPRINT  Boolean  Labels Printed  List: 2 entries
0=No
1=Yes
LABELCOUNT  Integer  Number of Labels   
ISCOMPLETE  Boolean  Completed  List: 2 entries
0=No
1=Yes
DTCOMPLETE  Date  Date Completed   
POSTDATE  Date  Last Posting Date   
DATE  Date  Purchase Order Date   
PONUMBER  String*22  Purchase Order Number  Mask: %-22C
TEMPLATE  String*6  Template Code  Mask: %-6N
FOBPOINT  String*60  FOB Point   
VDCODE  String*12  Vendor  Mask: %-12C
VDEXISTS  Boolean  Vendor Exists  List: 2 entries
0=No
1=Yes
VDNAME  String*60  Name   
VDADDRESS1  String*60  Address 1   
VDADDRESS2  String*60  Address 2   
VDADDRESS3  String*60  Address 3   
VDADDRESS4  String*60  Address 4   
VDCITY  String*30  City   
VDSTATE  String*30  State/Province   
VDZIP  String*20  Zip/Postal Code   
VDCOUNTRY  String*30  Country   
VDPHONE  String*30  Phone Number  Mask: (%-3C) %-3C-%-24C
VDFAX  String*30  Fax Number  Mask: (%-3C) %-3C-%-24C
VDCONTACT  String*60  Contact   
TERMSCODE  String*6  Terms Code  Mask: %-6N
HASRQNDATA  Boolean  Requisitions  List: 2 entries
0=No
1=Yes
PORTYPE  Integer  Purchase Order Type  List: 4 entries
1=Active
2=Standing
3=Future
4=Blanket
ONHOLD  Boolean  On Hold  List: 2 entries
0=No
1=Yes
ORDEREDON  Date  Order Date   
EXPARRIVAL  Date  Expected Arrival Date   
VCORIGINAL  BCD*10.3  Amount Originally Authorized   
VCAVAILABL  BCD*10.3  Amount Remaining   
DESCRIPTIO  String*60  Description   
REFERENCE  String*60  Reference   
COMMENT  String*250  Comment   
VIACODE  String*6  Ship-Via  Mask: %-6N
VIANAME  String*60  Ship-Via Name   
LASTRECEIP  String*22  Last Receipt Number  Mask: %-22C
RCPDATE  Date  Receipt Date   
RCPCOUNT  Integer  Number of Posted Receipts   
CURRENCY  String*3  Currency  Mask: %-3N
RATE  BCD*8.7  Exchange Rate   
SPREAD  BCD*8.7  Rate Spread   
RATETYPE  String*2  Rate Type  Mask: %-2N
RATEMATCH  Integer  Rate Match Type   
RATEDATE  Date  Rate Date   
RATEOPER  Integer  Rate Operation  List: 2 entries
1=*
2=/
RATEOVER  Boolean  Rate Overridden  List: 2 entries
0=No
1=Yes
SCURNDECML  Integer  Decimal Places   
EXTWEIGHT  BCD*10.4  Extended Weight   
EXTENDED  BCD*10.3  Extended Cost   
DOCTOTAL  BCD*10.3  Total   
EXTRECEIVE  BCD*10.3  Extended Received Amount   
EXTCANCEL  BCD*10.3  Extended Canceled Amount   
OQORDERED  BCD*10.4  Quantity Ordered   
TAXGROUP  String*12  Tax Group  Mask: %-12N
TAXAUTH1  String*12  Tax Authority 1  Mask: %-12N
TAXAUTH2  String*12  Tax Authority 2  Mask: %-12N
TAXAUTH3  String*12  Tax Authority 3  Mask: %-12N
TAXAUTH4  String*12  Tax Authority 4  Mask: %-12N
TAXAUTH5  String*12  Tax Authority 5  Mask: %-12N
TAXCLASS1  Integer  Tax Class 1   
TAXCLASS2  Integer  Tax Class 2   
TAXCLASS3  Integer  Tax Class 3   
TAXCLASS4  Integer  Tax Class 4   
TAXCLASS5  Integer  Tax Class 5   
TAXBASE1  BCD*10.3  Tax Base 1   
TAXBASE2  BCD*10.3  Tax Base 2   
TAXBASE3  BCD*10.3  Tax Base 3   
TAXBASE4  BCD*10.3  Tax Base 4   
TAXBASE5  BCD*10.3  Tax Base 5   
TXINCLUDE1  BCD*10.3  Included Tax Amount 1   
TXINCLUDE2  BCD*10.3  Included Tax Amount 2   
TXINCLUDE3  BCD*10.3  Included Tax Amount 3   
TXINCLUDE4  BCD*10.3  Included Tax Amount 4   
TXINCLUDE5  BCD*10.3  Included Tax Amount 5   
TXEXCLUDE1  BCD*10.3  Excluded Tax Amount 1   
TXEXCLUDE2  BCD*10.3  Excluded Tax Amount 2   
TXEXCLUDE3  BCD*10.3  Excluded Tax Amount 3   
TXEXCLUDE4  BCD*10.3  Excluded Tax Amount 4   
TXEXCLUDE5  BCD*10.3  Excluded Tax Amount 5   
TAXAMOUNT1  BCD*10.3  Tax Amount 1   
TAXAMOUNT2  BCD*10.3  Tax Amount 2   
TAXAMOUNT3  BCD*10.3  Tax Amount 3   
TAXAMOUNT4  BCD*10.3  Tax Amount 4   
TAXAMOUNT5  BCD*10.3  Tax Amount 5   
TXRECVAMT1  BCD*10.3  Tax Recoverable Amount 1   
TXRECVAMT2  BCD*10.3  Tax Recoverable Amount 2   
TXRECVAMT3  BCD*10.3  Tax Recoverable Amount 3   
TXRECVAMT4  BCD*10.3  Tax Recoverable Amount 4   
TXRECVAMT5  BCD*10.3  Tax Recoverable Amount 5   
TXEXPSAMT1  BCD*10.3  Tax Expense Amount 1   
TXEXPSAMT2  BCD*10.3  Tax Expense Amount 2   
TXEXPSAMT3  BCD*10.3  Tax Expense Amount 3   
TXEXPSAMT4  BCD*10.3  Tax Expense Amount 4   
TXEXPSAMT5  BCD*10.3  Tax Expense Amount 5   
TXALLOAMT1  BCD*10.3  Tax Allocated Amount 1   
TXALLOAMT2  BCD*10.3  Tax Allocated Amount 2   
TXALLOAMT3  BCD*10.3  Tax Allocated Amount 3   
TXALLOAMT4  BCD*10.3  Tax Allocated Amount 4   
TXALLOAMT5  BCD*10.3  Tax Allocated Amount 5   
TXBASEALLO  BCD*10.3  Net of Tax   
TXINCLUDED  BCD*10.3  Tax Included   
TXEXCLUDED  BCD*10.3  Tax Excluded   
TAXAMOUNT  BCD*10.3  Total Tax   
TXRECVAMT  BCD*10.3  Total Tax Recoverable   
TXEXPSAMT  BCD*10.3  Total Tax Expensed   
TXALLOAMT  BCD*10.3  Total Tax Allocated   
DOCSOURCE  Integer  Document Source  List: 2 entries
0=Entered
1=Internet
VDEMAIL  String*50  E-mail   
VDPHONEC  String*30  Contact Phone  Mask: (%-3C) %-3C-%-24C
VDFAXC  String*30  Contact Fax  Mask: (%-3C) %-3C-%-24C
VDEMAILC  String*50  Contact E-mail   
DISCPCT  BCD*5.5  Discount Percentage   
DISCOUNT  BCD*10.3  Discount Amount   
VALUES  Long  Optional Fields   
RQNNUMBER  String*22  Requisition Number  Mask: %-22C
RQNHSEQ  BCD*10.0  Requisition Sequence Key   
SCAMOUNT  BCD*10.3  Conversion Source Amount   
FCAMOUNT  BCD*10.3  Conversion Functional Amount   
JOBLINES  Long  Job Related Lines   
TRCURRENCY  String*3  Tax Reporting Currency  Mask: %-3N
RATERC  BCD*8.7  Tax Reporting Exchange Rate   
SPREADRC  BCD*8.7  Tax Reporting Rate Spread   
RATETYPERC  String*2  Tax Reporting Rate Type  Mask: %-2N
RATEMTCHRC  Integer  Tax Reporting Rate Match Type   
RATEDATERC  Date  Tax Reporting Rate Date   
RATEOPERRC  Integer  Tax Reporting Rate Operation  List: 2 entries
1=*
2=/
RATERCOVER  Boolean  Tax Reporting Rate Overridden  List: 2 entries
0=No
1=Yes
RCURNDECML  Integer  Tax Reporting Decimal Places   
TARAMOUNT1  BCD*10.3  Tax Reporting Amount 1   
TARAMOUNT2  BCD*10.3  Tax Reporting Amount 2   
TARAMOUNT3  BCD*10.3  Tax Reporting Amount 3   
TARAMOUNT4  BCD*10.3  Tax Reporting Amount 4   
TARAMOUNT5  BCD*10.3  Tax Reporting Amount 5   
TRINCLUDE1  BCD*10.3  Tax Reporting Included Amount 1   
TRINCLUDE2  BCD*10.3  Tax Reporting Included Amount 2   
TRINCLUDE3  BCD*10.3  Tax Reporting Included Amount 3   
TRINCLUDE4  BCD*10.3  Tax Reporting Included Amount 4   
TRINCLUDE5  BCD*10.3  Tax Reporting Included Amount 5   
TREXCLUDE1  BCD*10.3  Tax Reporting Excluded Amount 1   
TREXCLUDE2  BCD*10.3  Tax Reporting Excluded Amount 2   
TREXCLUDE3  BCD*10.3  Tax Reporting Excluded Amount 3   
TREXCLUDE4  BCD*10.3  Tax Reporting Excluded Amount 4   
TREXCLUDE5  BCD*10.3  Tax Reporting Excluded Amount 5   
TRRECVAMT1  BCD*10.3  Tax Reporting Recoverable Amt. 1   
TRRECVAMT2  BCD*10.3  Tax Reporting Recoverable Amt. 2   
TRRECVAMT3  BCD*10.3  Tax Reporting Recoverable Amt. 3   
TRRECVAMT4  BCD*10.3  Tax Reporting Recoverable Amt. 4   
TRRECVAMT5  BCD*10.3  Tax Reporting Recoverable Amt. 5   
TREXPSAMT1  BCD*10.3  Tax Reporting Expense Amount 1   
TREXPSAMT2  BCD*10.3  Tax Reporting Expense Amount 2   
TREXPSAMT3  BCD*10.3  Tax Reporting Expense Amount 3   
TREXPSAMT4  BCD*10.3  Tax Reporting Expense Amount 4   
TREXPSAMT5  BCD*10.3  Tax Reporting Expense Amount 5   
TRALLOAMT1  BCD*10.3  Tax Reporting Allocated Amount 1   
TRALLOAMT2  BCD*10.3  Tax Reporting Allocated Amount 2   
TRALLOAMT3  BCD*10.3  Tax Reporting Allocated Amount 3   
TRALLOAMT4  BCD*10.3  Tax Reporting Allocated Amount 4   
TRALLOAMT5  BCD*10.3  Tax Reporting Allocated Amount 5   

This page was generated on 2008-May-01

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