# Table: Purchase Order Lines

Table: POPORL
View: PO0630
Record length: 2034
Flags: A R

## Keys: 4

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

## Fields: 157

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 | (S) Quantity Ordered |
SQRECEIVED | BCD*10.4 | (S) Quantity Received |
SQCANCELED | BCD*10.4 | (S) Quantity Canceled |
SQRCPEXTRA | BCD*10.4 | (S) Quantity Received Extra |
SQSETTLED | BCD*10.4 | (S) Quantity Settled |
SQOUTSTAND | BCD*10.4 | (S) 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 | (FC) 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 | 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 | (FC) Net of Tax |
TFINCLUDE1 | BCD*10.3 | (FC) Tax Included Amount 1 |
TFINCLUDE2 | BCD*10.3 | (FC) Tax Included Amount 2 |
TFINCLUDE3 | BCD*10.3 | (FC) Tax Included Amount 3 |
TFINCLUDE4 | BCD*10.3 | (FC) Tax Included Amount 4 |
TFINCLUDE5 | BCD*10.3 | (FC) Tax Included Amount 5 |
TFALLOAMT1 | BCD*10.3 | (FC) Tax Allocated Amount 1 |
TFALLOAMT2 | BCD*10.3 | (FC) Tax Allocated Amount 2 |
TFALLOAMT3 | BCD*10.3 | (FC) Tax Allocated Amount 3 |
TFALLOAMT4 | BCD*10.3 | (FC) Tax Allocated Amount 4 |
TFALLOAMT5 | BCD*10.3 | (FC) Tax Allocated Amount 5 |
TFRECVAMT1 | BCD*10.3 | (FC) Tax Recoverable Amount 1 |
TFRECVAMT2 | BCD*10.3 | (FC) Tax Recoverable Amount 2 |
TFRECVAMT3 | BCD*10.3 | (FC) Tax Recoverable Amount 3 |
TFRECVAMT4 | BCD*10.3 | (FC) Tax Recoverable Amount 4 |
TFRECVAMT5 | BCD*10.3 | (FC) Tax Recoverable Amount 5 |
TFEXPSAMT1 | BCD*10.3 | (FC) Tax Expense Amount 1 |
TFEXPSAMT2 | BCD*10.3 | (FC) Tax Expense Amount 2 |
TFEXPSAMT3 | BCD*10.3 | (FC) Tax Expense Amount 3 |
TFEXPSAMT4 | BCD*10.3 | (FC) Tax Expense Amount 4 |
TFEXPSAMT5 | BCD*10.3 | (FC) Tax Expense Amount 5 |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.