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 D M  VDCODE, DATE, PORTYPE, ONHOLD

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 = Multiply
2 = Divide
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 = Multiply
2 = Divide
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 2022-Aug-18

© 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).