# View: Invoice Lines

RotoID: PO0430
Table: POINVL
DLL: POINVL

## Compositions: 5

RotoID | Table | Title | DLL
--- | --- | --- | ---
PO0420 | POINVH1 | Invoices | POINVH
PO0419 |  | Invoice Functions | POINVG
PO0421 | POINVI | Invoice Postings | POINVI
PO0431 | POINVM | Invoice Posting Lines | POINVM
PO0433 | POINVLO | Invoice Detail Optional Fields | POINVLO

## Keys: 3

Title | Fields
--- | ---
Detail Key | INVHSEQ, INVLREV
Sequence Key | INVHSEQ, INVLSEQ
Receipt Line Sequence Key | RCPLSEQ

## Fields: 172

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
INVHSEQ | 1 | BCD*10.0 | Invoice Sequence Key | E A K R |
INVLREV | 2 | BCD*10.0 | Line Number | E A K R |
INVLSEQ | 3 | BCD*10.0 | Invoice Line Sequence | E A X |
INVCSEQ | 4 | BCD*10.0 | Invoice Comment Sequence | A X |
OEONUMBER | 5 | String*22 | Order Number | A X | Mask: %-22C
INDBTABLE | 6 | Boolean | Stored in Database Table | A C X | List: 2 entries
0 | = | No
1 | = | Yes
POSTEDTOIC | 7 | Boolean | Posted to I/C | A C X | List: 2 entries
0 | = | No
1 | = | Yes
COMPLETION | 8 | Integer | Completion Status | A X | List: 3 entries
1 | = | No
2 | = | Yes
3 | = | Yes
DTCOMPLETE | 9 | Date | Date Completed | A X |
RCPHSEQ | 10 | BCD*10.0 | Receipt Sequence Key | A X |
RCPLSEQ | 11 | BCD*10.0 | Receipt Line Sequence | A X |
ITEMEXISTS | 12 | Boolean | Item Exists | A C X | List: 2 entries
0 | = | No
1 | = | Yes
ITEMNO | 13 | String*24 | Item Number | A P X | Mask: %-24C
LOCATION | 14 | String*6 | Location | A X | Mask: %-6N
ITEMDESC | 15 | String*60 | Item Description | A X |
VENDITEMNO | 16 | String*24 | Vendor Item Number | A X |
HASCOMMENT | 17 | Boolean | Comments | A X | List: 2 entries
0 | = | No
1 | = | Yes
ORDERUNIT | 18 | String*10 | Unit of Measure | A X | Mask: %-10c
ORDERCONV | 19 | BCD*10.6 | Order Unit Conversion | A C X |
ORDERDECML | 20 | Integer | Order Unit Decimals | A C X |
RCPUNIT | 21 | String*10 | Unit of Measure | A X | Mask: %-10c
RCPCONV | 22 | BCD*10.6 | Receiving Conversion Factor | A C X |
RCPDECML | 23 | Integer | Receiving Unit Decimals | A C X |
STOCKDECML | 24 | Integer | Stock Unit Decimals | A C X |
RQRECEIVED | 25 | BCD*10.4 | Quantity Received | A X |
SQRECEIVED | 26 | BCD*10.4 | (S) Quantity Received | A C X |
OQRECEIVED | 27 | BCD*10.4 | (O) Quantity Received | A C X |
UNITWEIGHT | 28 | BCD*10.4 | Unit Weight | A X |
EXTWEIGHT | 29 | BCD*10.4 | Extended Weight | A X |
UNITCOST | 30 | BCD*10.6 | Unit Cost | A X |
EXTENDED | 31 | BCD*10.3 | Extended Cost | A X |
TAXBASE1 | 32 | BCD*10.3 | Tax Base 1 | A X |
TAXBASE2 | 33 | BCD*10.3 | Tax Base 2 | A X |
TAXBASE3 | 34 | BCD*10.3 | Tax Base 3 | A X |
TAXBASE4 | 35 | BCD*10.3 | Tax Base 4 | A X |
TAXBASE5 | 36 | BCD*10.3 | Tax Base 5 | A X |
TAXCLASS1 | 37 | Integer | Tax Class 1 | A X |
TAXCLASS2 | 38 | Integer | Tax Class 2 | A X |
TAXCLASS3 | 39 | Integer | Tax Class 3 | A X |
TAXCLASS4 | 40 | Integer | Tax Class 4 | A X |
TAXCLASS5 | 41 | Integer | Tax Class 5 | A X |
TAXRATE1 | 42 | BCD*8.5 | Tax Rate 1 | A X |
TAXRATE2 | 43 | BCD*8.5 | Tax Rate 2 | A X |
TAXRATE3 | 44 | BCD*8.5 | Tax Rate 3 | A X |
TAXRATE4 | 45 | BCD*8.5 | Tax Rate 4 | A X |
TAXRATE5 | 46 | BCD*8.5 | Tax Rate 5 | A X |
TAXINCLUD1 | 47 | Boolean | Tax Includable 1 | A X | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD2 | 48 | Boolean | Tax Includable 2 | A X | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD3 | 49 | Boolean | Tax Includable 3 | A X | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD4 | 50 | Boolean | Tax Includable 4 | A X | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD5 | 51 | Boolean | Tax Includable 5 | A X | List: 2 entries
0 | = | No
1 | = | Yes
TAXAMOUNT1 | 52 | BCD*10.3 | Tax Amount 1 | A X |
TAXAMOUNT2 | 53 | BCD*10.3 | Tax Amount 2 | A X |
TAXAMOUNT3 | 54 | BCD*10.3 | Tax Amount 3 | A X |
TAXAMOUNT4 | 55 | BCD*10.3 | Tax Amount 4 | A X |
TAXAMOUNT5 | 56 | BCD*10.3 | Tax Amount 5 | A X |
TXRECVAMT1 | 57 | BCD*10.3 | Tax Recoverable Amount 1 | A X |
TXRECVAMT2 | 58 | BCD*10.3 | Tax Recoverable Amount 2 | A X |
TXRECVAMT3 | 59 | BCD*10.3 | Tax Recoverable Amount 3 | A X |
TXRECVAMT4 | 60 | BCD*10.3 | Tax Recoverable Amount 4 | A X |
TXRECVAMT5 | 61 | BCD*10.3 | Tax Recoverable Amount 5 | A X |
TXEXPSAMT1 | 62 | BCD*10.3 | Tax Expense Amount 1 | A X |
TXEXPSAMT2 | 63 | BCD*10.3 | Tax Expense Amount 2 | A X |
TXEXPSAMT3 | 64 | BCD*10.3 | Tax Expense Amount 3 | A X |
TXEXPSAMT4 | 65 | BCD*10.3 | Tax Expense Amount 4 | A X |
TXEXPSAMT5 | 66 | BCD*10.3 | Tax Expense Amount 5 | A X |
TXALLOAMT1 | 67 | BCD*10.3 | Tax Allocated Amount 1 | A X |
TXALLOAMT2 | 68 | BCD*10.3 | Tax Allocated Amount 2 | A X |
TXALLOAMT3 | 69 | BCD*10.3 | Tax Allocated Amount 3 | A X |
TXALLOAMT4 | 70 | BCD*10.3 | Tax Allocated Amount 4 | A X |
TXALLOAMT5 | 71 | BCD*10.3 | Tax Allocated Amount 5 | A X |
TXBASEALLO | 72 | BCD*10.3 | Net of Tax | A X |
TXINCLUDED | 73 | BCD*10.3 | Tax Included | A C X |
TXEXCLUDED | 74 | BCD*10.3 | Tax Excluded | A C X |
TAXAMOUNT | 75 | BCD*10.3 | Total Tax | A C X |
TXRECVAMT | 76 | BCD*10.3 | Recoverable Tax | A X |
TXEXPSAMT | 77 | BCD*10.3 | Expensed Tax | A X |
TXALLOAMT | 78 | BCD*10.3 | Allocated Tax | A X |
TFBASEALLO | 79 | BCD*10.3 | (FC) Net of Tax | A C X |
TFINCLUDE1 | 80 | BCD*10.3 | (FC) Tax Included Amount 1 | A C X |
TFINCLUDE2 | 81 | BCD*10.3 | (FC) Tax Included Amount 2 | A C X |
TFINCLUDE3 | 82 | BCD*10.3 | (FC) Tax Included Amount 3 | A C X |
TFINCLUDE4 | 83 | BCD*10.3 | (FC) Tax Included Amount 4 | A C X |
TFINCLUDE5 | 84 | BCD*10.3 | (FC) Tax Included Amount 5 | A C X |
TFRECVAMT1 | 85 | BCD*10.3 | (FC) Tax Recoverable Amount 1 | A C X |
TFRECVAMT2 | 86 | BCD*10.3 | (FC) Tax Recoverable Amount 2 | A C X |
TFRECVAMT3 | 87 | BCD*10.3 | (FC) Tax Recoverable Amount 3 | A C X |
TFRECVAMT4 | 88 | BCD*10.3 | (FC) Tax Recoverable Amount 4 | A C X |
TFRECVAMT5 | 89 | BCD*10.3 | (FC) Tax Recoverable Amount 5 | A C X |
TFEXPSAMT1 | 90 | BCD*10.3 | (FC) Tax Expense Amount 1 | A C X |
TFEXPSAMT2 | 91 | BCD*10.3 | (FC) Tax Expense Amount 2 | A C X |
TFEXPSAMT3 | 92 | BCD*10.3 | (FC) Tax Expense Amount 3 | A C X |
TFEXPSAMT4 | 93 | BCD*10.3 | (FC) Tax Expense Amount 4 | A C X |
TFEXPSAMT5 | 94 | BCD*10.3 | (FC) Tax Expense Amount 5 | A C X |
TFALLOAMT1 | 95 | BCD*10.3 | (FC) Tax Allocated Amount 1 | A C X |
TFALLOAMT2 | 96 | BCD*10.3 | (FC) Tax Allocated Amount 2 | A C X |
TFALLOAMT3 | 97 | BCD*10.3 | (FC) Tax Allocated Amount 3 | A C X |
TFALLOAMT4 | 98 | BCD*10.3 | (FC) Tax Allocated Amount 4 | A C X |
TFALLOAMT5 | 99 | BCD*10.3 | (FC) Tax Allocated Amount 5 | A C X |
FCEXTENDED | 100 | BCD*10.3 | (FC) Extended Amount | A C X |
GLACEXPENS | 101 | String*45 | Expense Account | A X | Mask: %-45C
MPRORATED | 102 | BCD*10.3 | Manual Proration | A X |
STOCKITEM | 103 | Boolean | Stock Item | A C X | List: 2 entries
0 | = | No
1 | = | Yes
RCPNUMBER | 104 | String*22 | Receipt Number | A X | Mask: %-22C
PORHSEQ | 105 | BCD*10.0 | Purchase Order Sequence Key | A X |
PORLSEQ | 106 | BCD*10.0 | Purchase Order Line Sequence | A X |
PONUMBER | 107 | String*22 | Purchase Order Number | A X | Mask: %-22C
GLNONSTKCR | 108 | String*45 | Non-Stock Clearing Account | A X | Mask: %-45C
MANITEMNO | 109 | String*24 | Manufacturer's Item Number | A X | Mask: %-24C
DISCPCT | 110 | BCD*5.5 | Discount Percentage | A X |
DISCOUNT | 111 | BCD*10.3 | Discount Amount | A X |
DISCOUNTF | 112 | BCD*10.3 | (FC) Discount Amount | A X |
XRRQRECEVD | 113 | BCD*10.4 | Part. Inv. Orig. Qty. Received | A X |
XIRQRECEVD | 114 | BCD*10.4 | Part. Inv. Pv. Quantity Invoiced | A X |
PVINVLINES | 115 | Long | Previous Invoice Lines | A X |
FULLYINV | 116 | Boolean | Fully Invoiced | A X | List: 2 entries
0 | = | No
1 | = | Yes
VALUES | 117 | Long | Optional Fields | A C X |
TERMDISCBL | 118 | Integer | Payment Discountable | A X | List: 2 entries
0 | = | No
1 | = | Yes
CONTRACT | 119 | String*16 | Contract | A X | Mask: %-16C
PROJECT | 120 | String*16 | Project | A X | Mask: %-16N
CCATEGORY | 121 | String*16 | Category | A X | Mask: %-16N
COSTCLASS | 122 | Integer | Cost Class | A C X | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
BILLTYPE | 123 | Integer | Billing Type | A P X | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | 124 | BCD*10.6 | Billing Rate | A X |
BILLCURR | 125 | String*3 | Billing Currency | A C X | Mask: %-3N
ARITEMNO | 126 | String*16 | A/R Item Number | A X | Mask: %-16C
ARUNIT | 127 | String*10 | A/R Unit of Measure | A X | Mask: %-10C
RTGPERCENT | 128 | BCD*5.5 | Retainage Percentage | A X |
RTGDAYS | 129 | Integer | Retention Period | A X |
RTGAMOUNT | 130 | BCD*10.3 | Retainage Amount | A X |
RTGDATEDUE | 131 | Date | Retainage Due Date | A X |
RTGAMTOVER | 132 | Boolean | Retainage Amount Overridden | A C X | List: 2 entries
0 | = | No
1 | = | Yes
RTGDDTOVER | 133 | Boolean | Retainage Due Date Overridden | A C X | List: 2 entries
0 | = | No
1 | = | Yes
FIRST | 161 | Integer | (first) | A X |
TAXCLASS1D | 162 | String*60 | Tax Class 1 Description | A C X |
TAXCLASS2D | 163 | String*60 | Tax Class 2 Description | A C X |
TAXCLASS3D | 164 | String*60 | Tax Class 3 Description | A C X |
TAXCLASS4D | 165 | String*60 | Tax Class 4 Description | A C X |
TAXCLASS5D | 166 | String*60 | Tax Class 5 Description | A C X |
GLACEXPNSD | 167 | String*60 | Expense Account Description | A C X |
TXINCLUDE1 | 168 | BCD*10.3 | Included Tax Amount 1 | A X |
TXINCLUDE2 | 169 | BCD*10.3 | Included Tax Amount 2 | A X |
TXINCLUDE3 | 170 | BCD*10.3 | Included Tax Amount 3 | A X |
TXINCLUDE4 | 171 | BCD*10.3 | Included Tax Amount 4 | A X |
TXINCLUDE5 | 172 | BCD*10.3 | Included Tax Amount 5 | A X |
TXEXCLUDE1 | 173 | BCD*10.3 | Excluded Tax Amount 1 | A X |
TXEXCLUDE2 | 174 | BCD*10.3 | Excluded Tax Amount 2 | A X |
TXEXCLUDE3 | 175 | BCD*10.3 | Excluded Tax Amount 3 | A X |
TXEXCLUDE4 | 176 | BCD*10.3 | Excluded Tax Amount 4 | A X |
TXEXCLUDE5 | 177 | BCD*10.3 | Excluded Tax Amount 5 | A X |
ISCOMPLETE | 178 | Boolean | Completed | A X | List: 2 entries
0 | = | No
1 | = | Yes
TAXLINE | 179 | Long | Lines Tax Calculation Sees | A X |
LINECMPL | 180 | Long | Lines Complete | A X |
LINE | 181 | Long | Line | A X |
EXSTDCOST | 182 | BCD*10.3 | Extended Std. Cost in Src Curr | A C X |
EXMRCOST | 183 | BCD*10.3 | Extended MR Cost in Src Curr | A C X |
EXALT1COST | 184 | BCD*10.3 | Extended Cost 1 in Src Curr | A C X |
EXALT2COST | 185 | BCD*10.3 | Extended Cost 2 in Src Curr | A C X |
GLNONSTKCD | 186 | String*60 | Non-Stock Clearing Account Desc. | A C X |
NETXTENDED | 187 | BCD*10.3 | Net Extended Cost | A X |
XRSQRECEVD | 188 | BCD*10.4 | Part. Inv. Orig. (S) Qty. Recvd. | A X |
XISQRECEVD | 189 | BCD*10.4 | Part. Inv. (S) Pv. Qty. Invoiced | A X |
XIOQRECEVD | 190 | BCD*10.4 | Part. Inv. (O) Pv. Qty. Invoiced | A X |
XSQICADJ | 191 | BCD*10.4 | Part. Inv. (S) I/C Qty. Adjstmt. | A X |
RCPLREV | 192 | BCD*10.0 | Line Number | A C X |
PROCESSCMD | 193 | Integer | Command | A C X | List: 6 entries
0 | = | Nothing to Process
1 | = | Insert Optional Fields
2 | = | Default and Tranfer Optional Fields
3 | = | Default Opt. Fields During Record Generation
4 | = | Remove Optional Fields
5 | = | Transfer Opt. Fields from Standing Document
TERMDBWT | 194 | BCD*10.3 | Payment Discount Base With Tax | A X |
TERMDBNT | 195 | BCD*10.3 | Payment Discount Base Without Ta | A X |
CONTSTYLE | 196 | Integer | Contract Style | A C X | List: 3 entries
0 | = |
1 | = | Standard
2 | = | Basic
PROJTYPE | 197 | Integer | Project Type | A C X | List: 4 entries
0 | = |
1 | = | Time and Materials
2 | = | Fixed Price
3 | = | Cost Plus
REVREC | 198 | Integer | Accounting Method | A C X | List: 9 entries
0 | = |
1 | = | Completed Project
2 | = | Total Cost Percentage Complete
3 | = | Labor Hours Percentage Complete
4 | = | Billings and Costs
5 | = | Project Percentage Complete
6 | = | Category Percentage Complete
7 | = | Completed Contract
8 | = | Accrual-Basis
UFMTCONTNO | 199 | String*16 | Unformatted Contract Code | A C X | Mask: %-16C

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.