Table: Purchase Order Lines

Table: POPORL
View: PO0630
Record Length: 2290

Flags: A R 

Keys: 10

Title Flags Fields

Detail Key PORHSEQPORLREV
Sequence Key PORHSEQPORLSEQ
Order Number Key M  OEONUMBERPORHSEQPORLSEQ
Item/Exp. Arrival Key M  ITEMNOEXPARRIVALPORHSEQPORLSEQ
Exp. Arrival/Qty. Ordered Key D M  EXPARRIVALOQORDEREDITEMNOLOCATION
Exp. Arrival/Item No./Completion D M  EXPARRIVALITEMNOCOMPLETION
Exp. Arrival/Qty. Outstanding D M  EXPARRIVALOQOUTSTANDITEMNO
Item/ExpArrival/Loc./Completion D M  ITEMNOEXPARRIVALLOCATIONCOMPLETION
Detail Number M  PORHSEQDETAILNUMPORLSEQ
Item/ExpArrival/Loc./Completion D M  PORHSEQEXPARRIVALLOCATIONCOMPLETION

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