Table: Purchase Order Lines

Table: POPORL
View: PO0630
Record Length: 2290

Flags: A R 

Keys: 10

Title Flags Fields
Detail Key PORHSEQ, PORLREV
Sequence Key PORHSEQ, PORLSEQ
Order Number Key M  OEONUMBER, PORHSEQ, PORLSEQ
Item/Exp. Arrival Key M  ITEMNO, EXPARRIVAL, PORHSEQ, PORLSEQ
Exp. Arrival/Qty. Ordered Key D M  EXPARRIVAL, OQORDERED, ITEMNO, LOCATION
Exp. Arrival/Item No./Completion D M  EXPARRIVAL, ITEMNO, COMPLETION
Exp. Arrival/Qty. Outstanding D M  EXPARRIVAL, OQOUTSTAND, ITEMNO
Item/ExpArrival/Loc./Completion D M  ITEMNO, EXPARRIVAL, LOCATION, COMPLETION
Detail Number M  PORHSEQ, DETAILNUM, PORLSEQ
Item/ExpArrival/Loc./Completion D M  PORHSEQ, EXPARRIVAL, LOCATION, COMPLETION

Fields: 189

Field Type Title Presentation
PORHSEQ BCD*10.0 Purchase Order Sequence Key
PORLREV BCD*10.0 Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
PORLSEQ BCD*10.0 Purchase Order Line Sequence
PORCSEQ BCD*10.0 Purchase Order Comment Sequence
INDBTABLE Boolean Stored in Database Table List:2 entries
0 = No
1 = Yes
CONSOLSEQ BCD*10.0 Consolidated to line
RQNHSEQ BCD*10.0 Requisition Sequence Key
RQNLSEQ BCD*10.0 Requisition Line Sequence
OEONUMBER String*22 Order Number Mask: %-22C
POSTEDTOIC Boolean Posted to I/C List:2 entries
0 = No
1 = Yes
TOPOSTTOIC Boolean To Post to I/C List:2 entries
0 = No
1 = Yes
STPRINT Boolean Print Status List:2 entries
0 = No
1 = Yes
COMPLETION Integer Completion Status List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE Date Date Completed
ITEMEXISTS Boolean Item Exists List:2 entries
0 = No
1 = Yes
ITEMNO String*24 Item Number Mask: %-24C
LOCATION String*6 Location Mask: %-6N
ITEMDESC String*60 Item Description
EXPARRIVAL Date Expected Arrival Date
VENDITEMNO String*24 Vendor Item Number
HASCOMMENT Boolean Comments/Instructions List:2 entries
0 = No
1 = Yes
ORDERUNIT String*10 Unit of Measure Mask: %-10c
ORDERCONV BCD*10.6 Order Unit Conversion
ORDERDECML Integer Order Unit Decimals
STOCKDECML Integer Stock Unit Decimals
OQORDERED BCD*10.4 Quantity Ordered
OQRECEIVED BCD*10.4 Quantity Received
OQCANCELED BCD*10.4 Quantity Canceled
OQRCPEXTRA BCD*10.4 Received Extra
OQOUTSTAND BCD*10.4 Quantity Outstanding
SQORDERED BCD*10.4 Stocking Quantity Ordered
SQRECEIVED BCD*10.4 Stocking Quantity Received
SQCANCELED BCD*10.4 Stocking Quantity Canceled
SQRCPEXTRA BCD*10.4 Stocking Quantity Received Extra
SQSETTLED BCD*10.4 Stocking Quantity Settled
SQOUTSTAND BCD*10.4 Stocking Quantity Outstanding
UNITWEIGHT BCD*10.4 Unit Weight
EXTWEIGHT BCD*10.4 Extended Weight
OQRCPDAYS BCD*10.4 Days * Quantity Received
EXTRECEIVE BCD*10.3 Extended Received Amount
EXTCANCEL BCD*10.3 Extended Canceled Amount
SRRECEIVED BCD*10.3 Amount Received To Date
UNITCOST BCD*10.6 Unit Cost
EXTENDED BCD*10.3 Extended Cost
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
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
TAXRATE1 BCD*8.5 Tax Rate 1
TAXRATE2 BCD*8.5 Tax Rate 2
TAXRATE3 BCD*8.5 Tax Rate 3
TAXRATE4 BCD*8.5 Tax Rate 4
TAXRATE5 BCD*8.5 Tax Rate 5
TAXINCLUD1 Boolean Tax Includable 1 List:2 entries
0 = No
1 = Yes
TAXINCLUD2 Boolean Tax Includable 2 List:2 entries
0 = No
1 = Yes
TAXINCLUD3 Boolean Tax Includable 3 List:2 entries
0 = No
1 = Yes
TAXINCLUD4 Boolean Tax Includable 4 List:2 entries
0 = No
1 = Yes
TAXINCLUD5 Boolean Tax Includable 5 List:2 entries
0 = No
1 = Yes
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
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
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
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 Recoverable Tax
TXEXPSAMT BCD*10.3 Expensed Tax
TXALLOAMT BCD*10.3 Allocated Tax
FCEXTENDED BCD*10.3 Rcp. Ext. Amt.
GLACEXPENS String*45 Expense Account Mask: %-45C
HASDROPSHI Boolean Drop-Ship List:2 entries
0 = No
1 = Yes
DROPTYPE Integer Drop-Ship Type List:4 entries
2 = Address Entered
3 = Inventory Location Address
4 = Customer Address
5 = Customer Ship-To Address
IDCUST String*12 Drop-Ship Customer Mask: %-12C
IDCUSTSHPT String*6 Customer Ship-To Address Mask: %-6C
DLOCATION String*6 Drop-Ship Location Mask: %-6N
DESC String*60 Drop-Ship Description
ADDRESS1 String*60 Drop-Ship Address 1
ADDRESS2 String*60 Drop-Ship Address 2
ADDRESS3 String*60 Drop-Ship Address 3
ADDRESS4 String*60 Drop-Ship Address 4
CITY String*30 Drop-Ship City
STATE String*30 Drop-Ship State/Province
ZIP String*20 Drop-Ship Zip/Postal Code
COUNTRY String*30 Drop-Ship Country
PHONE String*30 Drop-Ship Phone Number Mask: (%-3C) %-3C-%-24C
FAX String*30 Drop-Ship Fax Number Mask: (%-3C) %-3C-%-24C
CONTACT String*60 Drop-Ship Contact
STOCKITEM Boolean Stock Item List:2 entries
0 = No
1 = Yes
EMAIL String*50 Drop-Ship E-mail
PHONEC String*30 Drop-Ship Contact Phone Mask: (%-3C) %-3C-%-24C
FAXC String*30 Drop-Ship Contact Fax Mask: (%-3C) %-3C-%-24C
EMAILC String*50 Drop-Ship Contact E-mail
GLNONSTKCR String*45 Non-Stock Clearing Account Mask: %-45C
MANITEMNO String*24 Manufacturer's Item Number Mask: %-24C
DISCPCT BCD*5.5 Discount Percentage
DISCOUNT BCD*10.3 Discount Amount
VALUES Long Optional Fields
DISCOUNTF BCD*10.3 Func. Discount Amount
ISRECEIVED Boolean Received List:2 entries
0 = No
1 = Yes
AGENTLSEQ BCD*10.0 Agent Line Sequence
CONTRACT String*16 Contract Mask: %-16C
PROJECT String*16 Project Mask: %-16N
CCATEGORY String*16 (Cost) Category Mask: %-16N
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE Integer Billing Type List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE BCD*10.6 Billing Rate
BILLCURR String*3 Billing Currency Mask: %-3N
ARITEMNO String*16 A/R Item Number Mask: %-16C
ARUNIT String*10 A/R Unit of Measure Mask: %-10C
TFBASEALLO BCD*10.3 Func. Net of Tax
TFINCLUDE1 BCD*10.3 Func. Tax Included Amount 1
TFINCLUDE2 BCD*10.3 Func. Tax Included Amount 2
TFINCLUDE3 BCD*10.3 Func. Tax Included Amount 3
TFINCLUDE4 BCD*10.3 Func. Tax Included Amount 4
TFINCLUDE5 BCD*10.3 Func. Tax Included Amount 5
TFALLOAMT1 BCD*10.3 Func. Tax Allocated Amount 1
TFALLOAMT2 BCD*10.3 Func. Tax Allocated Amount 2
TFALLOAMT3 BCD*10.3 Func. Tax Allocated Amount 3
TFALLOAMT4 BCD*10.3 Func. Tax Allocated Amount 4
TFALLOAMT5 BCD*10.3 Func. Tax Allocated Amount 5
TFRECVAMT1 BCD*10.3 Func. Tax Recoverable Amount 1
TFRECVAMT2 BCD*10.3 Func. Tax Recoverable Amount 2
TFRECVAMT3 BCD*10.3 Func. Tax Recoverable Amount 3
TFRECVAMT4 BCD*10.3 Func. Tax Recoverable Amount 4
TFRECVAMT5 BCD*10.3 Func. Tax Recoverable Amount 5
TFEXPSAMT1 BCD*10.3 Func. Tax Expense Amount 1
TFEXPSAMT2 BCD*10.3 Func. Tax Expense Amount 2
TFEXPSAMT3 BCD*10.3 Func. Tax Expense Amount 3
TFEXPSAMT4 BCD*10.3 Func. Tax Expense Amount 4
TFEXPSAMT5 BCD*10.3 Func. Tax Expense Amount 5
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
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
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
UCISMANUAL Boolean Unit Cost is Manual List:2 entries
0 = No
1 = Yes
WEIGHTUNIT String*10 Weight Unit of Measure
WEIGHTCONV BCD*10.6 Weight Conversion
DEFUWEIGHT BCD*10.4 Default Unit Weight
DEFEXTWGHT BCD*10.4 Default Extended Weight
COPYDETAIL Boolean Copy This Detail Line? List:2 entries
0 = No
1 = Yes
DETAILNUM Integer Detail Number
CAXABLE1 Boolean Reverse Chargeable 1 List:2 entries
0 = No
1 = Yes
CAXABLE2 Boolean Reverse Chargeable 2 List:2 entries
0 = No
1 = Yes
CAXABLE3 Boolean Reverse Chargeable 3 List:2 entries
0 = No
1 = Yes
CAXABLE4 Boolean Reverse Chargeable 4 List:2 entries
0 = No
1 = Yes
CAXABLE5 Boolean Reverse Chargeable 5 List:2 entries
0 = No
1 = Yes

This page was generated on 2023-Aug-31

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