View: Invoice Posting Lines

RotoID: PO0431
Table: POINVM
Protocol: Detail, Ordered revisions
DLL:POINVM

Compositions: 10

RotoID Tables Title DLL
PO0421 POINVI Invoice Postings POINVI
PO0420 POINVH1POINVH2 Invoices POINVH
PO0430 POINVL Invoice Lines POINVL
PO0610 POPORC Purchase Order Comments POPORC
PO0620 POPORH1POPORH2 Purchase Orders POPORH
PO0630 POPORL Purchase Order Lines POPORL
PO0700 PORCPH1PORCPH2 Receipts PORCPH
PO0710 PORCPL Receipt Lines PORCPL
PO0619 Purchase Order Functions POPORG
PO0419 Invoice Functions POINVG

Keys: 1

Title Fields
Detail Key INVISEQ, INVHSEQ, INVLSEQ

Fields: 145

Field Index Type Title Attributes Presentation
INVISEQ 1 BCD*10.0 Invoice Sequence Key E A K R 
INVHSEQ 2 BCD*10.0 Invoice Sequence Key E A K R 
INVLSEQ 3 BCD*10.0 Invoice Line Sequence E A K R 
OPERATION 4 Integer Operation To Post E A 
RCPHSEQ 5 BCD*10.0 Receipt Sequence Key E A 
RCPLSEQ 6 BCD*10.0 Receipt Line Sequence E A 
ITEMDESC 7 String*60 Item Description E A 
STOCKUNIT 8 String*10 Unit of Measure E A 
RCPUNIT 9 String*10 Unit of Measure E A 
RCPCONV 10 BCD*10.6 Receiving Conversion Factor E A 
RCPDECML 11 Integer Receiving Unit Decimals E A 
RQRECEIVED 12 BCD*10.4 Receiving Quantity Received E A 
SQRECEIVED 13 BCD*10.4 Stocking Quantity Received E A 
OQRECEIVED 14 BCD*10.4 Ordered Quantity Received E A 
UNITCOST 15 BCD*10.6 Unit Cost E A 
EXTENDED 16 BCD*10.3 Extended Cost E A 
UNITWEIGHT 17 BCD*10.4 Unit Weight E A 
EXTWEIGHT 18 BCD*10.4 Extended Weight E A 
TAXBASE1 19 BCD*10.3 Tax Base 1 E A 
TAXBASE2 20 BCD*10.3 Tax Base 2 E A 
TAXBASE3 21 BCD*10.3 Tax Base 3 E A 
TAXBASE4 22 BCD*10.3 Tax Base 4 E A 
TAXBASE5 23 BCD*10.3 Tax Base 5 E A 
TAXCLASS1 24 Integer Tax Class 1 E A 
TAXCLASS2 25 Integer Tax Class 2 E A 
TAXCLASS3 26 Integer Tax Class 3 E A 
TAXCLASS4 27 Integer Tax Class 4 E A 
TAXCLASS5 28 Integer Tax Class 5 E A 
TAXINCLUD1 29 Boolean Tax Includable 1 E A 
TAXINCLUD2 30 Boolean Tax Includable 2 E A 
TAXINCLUD3 31 Boolean Tax Includable 3 E A 
TAXINCLUD4 32 Boolean Tax Includable 4 E A 
TAXINCLUD5 33 Boolean Tax Includable 5 E A 
TAXAMOUNT1 34 BCD*10.3 Tax Amount 1 E A 
TAXAMOUNT2 35 BCD*10.3 Tax Amount 2 E A 
TAXAMOUNT3 36 BCD*10.3 Tax Amount 3 E A 
TAXAMOUNT4 37 BCD*10.3 Tax Amount 4 E A 
TAXAMOUNT5 38 BCD*10.3 Tax Amount 5 E A 
TXINCLUDE1 39 BCD*10.3 Included Tax Amount 1 E A 
TXINCLUDE2 40 BCD*10.3 Included Tax Amount 2 E A 
TXINCLUDE3 41 BCD*10.3 Included Tax Amount 3 E A 
TXINCLUDE4 42 BCD*10.3 Included Tax Amount 4 E A 
TXINCLUDE5 43 BCD*10.3 Included Tax Amount 5 E A 
TXRECVAMT1 44 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 45 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 46 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 47 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 48 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 49 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 50 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 51 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 52 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 53 BCD*10.3 Tax Expense Amount 5 E A 
TXALLOAMT1 54 BCD*10.3 Tax Allocated Amount 1 E A 
TXALLOAMT2 55 BCD*10.3 Tax Allocated Amount 2 E A 
TXALLOAMT3 56 BCD*10.3 Tax Allocated Amount 3 E A 
TXALLOAMT4 57 BCD*10.3 Tax Allocated Amount 4 E A 
TXALLOAMT5 58 BCD*10.3 Tax Allocated Amount 5 E A 
TXBASEALLO 59 BCD*10.3 Net of Tax E A 
TXINCLUDED 60 BCD*10.3 Tax Included E A 
TXEXCLUDED 61 BCD*10.3 Tax Excluded E A 
TAXAMOUNT 62 BCD*10.3 Total Tax E A 
TXRECVAMT 63 BCD*10.3 Total Tax Recoverable E A 
TXEXPSAMT 64 BCD*10.3 Total Tax Expensed E A 
TXALLOAMT 65 BCD*10.3 Total Tax Allocated E A 
TFBASEALLO 66 BCD*10.3 Func. Net of Tax E A 
TFINCLUDE1 67 BCD*10.3 Func. Tax Included Amount 1 E A 
TFINCLUDE2 68 BCD*10.3 Func. Tax Included Amount 2 E A 
TFINCLUDE3 69 BCD*10.3 Func. Tax Included Amount 3 E A 
TFINCLUDE4 70 BCD*10.3 Func. Tax Included Amount 4 E A 
TFINCLUDE5 71 BCD*10.3 Func. Tax Included Amount 5 E A 
TFALLOAMT1 72 BCD*10.3 Func. Tax Allocated Amount 1 E A 
TFALLOAMT2 73 BCD*10.3 Func. Tax Allocated Amount 2 E A 
TFALLOAMT3 74 BCD*10.3 Func. Tax Allocated Amount 3 E A 
TFALLOAMT4 75 BCD*10.3 Func. Tax Allocated Amount 4 E A 
TFALLOAMT5 76 BCD*10.3 Func. Tax Allocated Amount 5 E A 
TFRECVAMT1 77 BCD*10.3 Func. Tax Recoverable Amount 1 E A 
TFRECVAMT2 78 BCD*10.3 Func. Tax Recoverable Amount 2 E A 
TFRECVAMT3 79 BCD*10.3 Func. Tax Recoverable Amount 3 E A 
TFRECVAMT4 80 BCD*10.3 Func. Tax Recoverable Amount 4 E A 
TFRECVAMT5 81 BCD*10.3 Func. Tax Recoverable Amount 5 E A 
TFEXPSAMT1 82 BCD*10.3 Func. Tax Expense Amount 1 E A 
TFEXPSAMT2 83 BCD*10.3 Func. Tax Expense Amount 2 E A 
TFEXPSAMT3 84 BCD*10.3 Func. Tax Expense Amount 3 E A 
TFEXPSAMT4 85 BCD*10.3 Func. Tax Expense Amount 4 E A 
TFEXPSAMT5 86 BCD*10.3 Func. Tax Expense Amount 5 E A 
GLACEXPENS 87 String*45 Expense Account E A 
GLNONSTKCR 88 String*45 Non-Stock Clearing Account E A  Mask: %-45C
DISCPCT 89 BCD*5.5 Discount Percentage E A 
DISCOUNT 90 BCD*10.3 Discount Amount E A 
DISCOUNTF 91 BCD*10.3 Func. Discount Amount E A 
FULLYINV 92 Boolean Fully Invoiced E A 
BILLRATE 93 BCD*10.6 Billing Rate E A 
RTGPERCENT 94 BCD*5.5 Retainage Percentage E A 
RTGDAYS 95 Integer Retention Period E A 
RTGAMOUNT 96 BCD*10.3 Retainage Amount E A 
RTGDATEDUE 97 Date Retainage Due Date E A 
RTGAMTOVER 98 Boolean Retainage Amount Overridden E A 
RTGDDTOVER 99 Boolean Retainage Due Date Overridden E A 
TRINCLUDE1 100 BCD*10.3 Tax Reporting Included Amount 1 E A 
TRINCLUDE2 101 BCD*10.3 Tax Reporting Included Amount 2 E A 
TRINCLUDE3 102 BCD*10.3 Tax Reporting Included Amount 3 E A 
TRINCLUDE4 103 BCD*10.3 Tax Reporting Included Amount 4 E A 
TRINCLUDE5 104 BCD*10.3 Tax Reporting Included Amount 5 E A 
TRRECVAMT1 105 BCD*10.3 Tax Reporting Recoverable Amt. 1 E A 
TRRECVAMT2 106 BCD*10.3 Tax Reporting Recoverable Amt. 2 E A 
TRRECVAMT3 107 BCD*10.3 Tax Reporting Recoverable Amt. 3 E A 
TRRECVAMT4 108 BCD*10.3 Tax Reporting Recoverable Amt. 4 E A 
TRRECVAMT5 109 BCD*10.3 Tax Reporting Recoverable Amt. 5 E A 
TREXPSAMT1 110 BCD*10.3 Tax Reporting Expense Amount 1 E A 
TREXPSAMT2 111 BCD*10.3 Tax Reporting Expense Amount 2 E A 
TREXPSAMT3 112 BCD*10.3 Tax Reporting Expense Amount 3 E A 
TREXPSAMT4 113 BCD*10.3 Tax Reporting Expense Amount 4 E A 
TREXPSAMT5 114 BCD*10.3 Tax Reporting Expense Amount 5 E A 
TRALLOAMT1 115 BCD*10.3 Tax Reporting Allocated Amount 1 E A 
TRALLOAMT2 116 BCD*10.3 Tax Reporting Allocated Amount 2 E A 
TRALLOAMT3 117 BCD*10.3 Tax Reporting Allocated Amount 3 E A 
TRALLOAMT4 118 BCD*10.3 Tax Reporting Allocated Amount 4 E A 
TRALLOAMT5 119 BCD*10.3 Tax Reporting Allocated Amount 5 E A 
RAXBASE1 120 BCD*10.3 Retainage Tax Base 1 E A 
RAXBASE2 121 BCD*10.3 Retainage Tax Base 2 E A 
RAXBASE3 122 BCD*10.3 Retainage Tax Base 3 E A 
RAXBASE4 123 BCD*10.3 Retainage Tax Base 4 E A 
RAXBASE5 124 BCD*10.3 Retainage Tax Base 5 E A 
RXRECVAMT1 125 BCD*10.3 Retainage Tax Recoverable Amt. 1 E A 
RXRECVAMT2 126 BCD*10.3 Retainage Tax Recoverable Amt. 2 E A 
RXRECVAMT3 127 BCD*10.3 Retainage Tax Recoverable Amt. 3 E A 
RXRECVAMT4 128 BCD*10.3 Retainage Tax Recoverable Amt. 4 E A 
RXRECVAMT5 129 BCD*10.3 Retainage Tax Recoverable Amt. 5 E A 
RXEXPSAMT1 130 BCD*10.3 Retainage Tax Expense Amount 1 E A 
RXEXPSAMT2 131 BCD*10.3 Retainage Tax Expense Amount 2 E A 
RXEXPSAMT3 132 BCD*10.3 Retainage Tax Expense Amount 3 E A 
RXEXPSAMT4 133 BCD*10.3 Retainage Tax Expense Amount 4 E A 
RXEXPSAMT5 134 BCD*10.3 Retainage Tax Expense Amount 5 E A 
RXALLOAMT1 135 BCD*10.3 Retainage Tax Allocated Amount 1 E A 
RXALLOAMT2 136 BCD*10.3 Retainage Tax Allocated Amount 2 E A 
RXALLOAMT3 137 BCD*10.3 Retainage Tax Allocated Amount 3 E A 
RXALLOAMT4 138 BCD*10.3 Retainage Tax Allocated Amount 4 E A 
RXALLOAMT5 139 BCD*10.3 Retainage Tax Allocated Amount 5 E A 
WEIGHTUNIT 140 String*10 Weight Unit of Measure E A 
WEIGHTCONV 141 BCD*10.6 Weight Conversion E A 
DEFUWEIGHT 142 BCD*10.4 Default Unit Weight E A 
DEFEXTWGHT 143 BCD*10.4 Default Extended Weight E A 
QTYPOSTED 144 Boolean Is Quantity Posted? E A 
LAST 150 Boolean Last E A 

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