View: Invoice Posting Cost Lines

RotoID: PO0441
Table: POINVT
Protocol: Detail, Ordered revisions
DLL:POINVT

Compositions: 7

RotoID Tables Title DLL
PO0421 POINVI Invoice Postings POINVI
PO0420 POINVH1POINVH2 Invoices POINVH
PO0440 POINVS Invoice Additional Costs POINVS
PO0700 PORCPH1PORCPH2 Receipts PORCPH
PO0718 PORCPV Receipt Vendors PORCPV
PO0714 PORCPS Receipt Additional Costs PORCPS
PO0419 Invoice Functions POINVG

Keys: 1

Title Fields
Master Key INVISEQ, INVHSEQ, INVSSEQ

Fields: 119

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 
INVSSEQ 3 BCD*10.0 Invoice Cost Sequence E A K R 
OPERATION 4 Integer Operation To Post E A 
RCPHSEQ 5 BCD*10.0 Receipt Sequence Key E A 
RCPSSEQ 6 BCD*10.0 Receipt Cost Sequence E A 
ADDCOST 7 String*6 Additional Cost E A  Mask: %-6N
DESCRIPTIO 8 String*60 Description E A 
GLEXPACCT 9 String*45 Expense Account E A  Mask: %-45C
GLRETACCT 10 String*45 Return Account E A  Mask: %-45C
AMOUNT 11 BCD*10.3 Amount E A 
PRORMETHOD 12 Integer Proration Method E A  List:5 entries
1 = No Proration
2 = Prorate by Quantity
3 = Prorate by Cost
4 = Prorate by Weight
5 = Prorate Manually
REPRORATE 13 Integer Reproration Method E A 
TAXICLASS1 14 Integer Cost Tax Class 1 E A 
TAXICLASS2 15 Integer Cost Tax Class 2 E A 
TAXICLASS3 16 Integer Cost Tax Class 3 E A 
TAXICLASS4 17 Integer Cost Tax Class 4 E A 
TAXICLASS5 18 Integer Cost Tax Class 5 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 
TAXINCLUD1 24 Boolean Tax Includable 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 25 Boolean Tax Includable 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 26 Boolean Tax Includable 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 27 Boolean Tax Includable 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 28 Boolean Tax Includable 5 E A  List:2 entries
0 = No
1 = Yes
TXINCLUDE1 29 BCD*10.3 Included Tax Amount 1 E A 
TXINCLUDE2 30 BCD*10.3 Included Tax Amount 2 E A 
TXINCLUDE3 31 BCD*10.3 Included Tax Amount 3 E A 
TXINCLUDE4 32 BCD*10.3 Included Tax Amount 4 E A 
TXINCLUDE5 33 BCD*10.3 Included Tax Amount 5 E A 
TXRECVAMT1 34 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 35 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 36 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 37 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 38 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 39 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 40 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 41 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 42 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 43 BCD*10.3 Tax Expense Amount 5 E A 
TXALLOAMT1 44 BCD*10.3 Tax Allocated Amount 1 E A 
TXALLOAMT2 45 BCD*10.3 Tax Allocated Amount 2 E A 
TXALLOAMT3 46 BCD*10.3 Tax Allocated Amount 3 E A 
TXALLOAMT4 47 BCD*10.3 Tax Allocated Amount 4 E A 
TXALLOAMT5 48 BCD*10.3 Tax Allocated Amount 5 E A 
TXBASEALLO 49 BCD*10.3 Net of Tax E A 
TFBASEALLO 50 BCD*10.3 Func. Net of Tax A C 
TFINCLUDE1 51 BCD*10.3 Func. Tax Included Amount 1 A C 
TFINCLUDE2 52 BCD*10.3 Func. Tax Included Amount 2 A C 
TFINCLUDE3 53 BCD*10.3 Func. Tax Included Amount 3 A C 
TFINCLUDE4 54 BCD*10.3 Func. Tax Included Amount 4 A C 
TFINCLUDE5 55 BCD*10.3 Func. Tax Included Amount 5 A C 
TFALLOAMT1 56 BCD*10.3 Func. Tax Allocated Amount 1 A C 
TFALLOAMT2 57 BCD*10.3 Func. Tax Allocated Amount 2 A C 
TFALLOAMT3 58 BCD*10.3 Func. Tax Allocated Amount 3 A C 
TFALLOAMT4 59 BCD*10.3 Func. Tax Allocated Amount 4 A C 
TFALLOAMT5 60 BCD*10.3 Func. Tax Allocated Amount 5 A C 
TFRECVAMT1 61 BCD*10.3 Func. Tax Recoverable Amount 1 A C 
TFRECVAMT2 62 BCD*10.3 Func. Tax Recoverable Amount 2 A C 
TFRECVAMT3 63 BCD*10.3 Func. Tax Recoverable Amount 3 A C 
TFRECVAMT4 64 BCD*10.3 Func. Tax Recoverable Amount 4 A C 
TFRECVAMT5 65 BCD*10.3 Func. Tax Recoverable Amount 5 A C 
TFEXPSAMT1 66 BCD*10.3 Func. Tax Expense Amount 1 A C 
TFEXPSAMT2 67 BCD*10.3 Func. Tax Expense Amount 2 A C 
TFEXPSAMT3 68 BCD*10.3 Func. Tax Expense Amount 3 A C 
TFEXPSAMT4 69 BCD*10.3 Func. Tax Expense Amount 4 A C 
TFEXPSAMT5 70 BCD*10.3 Func. Tax Expense Amount 5 A C 
MTOPRORATE 71 BCD*10.3 Manual To Prorate A C 
RCPHSEQC 72 BCD*10.0 Receipt/Apply To Receipt Seq Key E A 
BILLRATE 73 BCD*10.6 Billing Rate E A 
RTGPERCENT 74 BCD*5.5 Retainage Percentage E A 
RTGDAYS 75 Integer Retention Period E A 
RTGAMOUNT 76 BCD*10.3 Retainage Amount E A 
RTGDATEDUE 77 Date Retainage Due Date E A 
RTGAMTOVER 78 Boolean Retainage Amount Overridden E A 
RTGDDTOVER 79 Boolean Retainage Due Date Overridden E A 
TRINCLUDE1 80 BCD*10.3 Tax Reporting Included Amount 1 E A 
TRINCLUDE2 81 BCD*10.3 Tax Reporting Included Amount 2 E A 
TRINCLUDE3 82 BCD*10.3 Tax Reporting Included Amount 3 E A 
TRINCLUDE4 83 BCD*10.3 Tax Reporting Included Amount 4 E A 
TRINCLUDE5 84 BCD*10.3 Tax Reporting Included Amount 5 E A 
TRRECVAMT1 85 BCD*10.3 Tax Reporting Recoverable Amt. 1 E A 
TRRECVAMT2 86 BCD*10.3 Tax Reporting Recoverable Amt. 2 E A 
TRRECVAMT3 87 BCD*10.3 Tax Reporting Recoverable Amt. 3 E A 
TRRECVAMT4 88 BCD*10.3 Tax Reporting Recoverable Amt. 4 E A 
TRRECVAMT5 89 BCD*10.3 Tax Reporting Recoverable Amt. 5 E A 
TREXPSAMT1 90 BCD*10.3 Tax Reporting Expense Amount 1 E A 
TREXPSAMT2 91 BCD*10.3 Tax Reporting Expense Amount 2 E A 
TREXPSAMT3 92 BCD*10.3 Tax Reporting Expense Amount 3 E A 
TREXPSAMT4 93 BCD*10.3 Tax Reporting Expense Amount 4 E A 
TREXPSAMT5 94 BCD*10.3 Tax Reporting Expense Amount 5 E A 
TRALLOAMT1 95 BCD*10.3 Tax Reporting Allocated Amount 1 E A 
TRALLOAMT2 96 BCD*10.3 Tax Reporting Allocated Amount 2 E A 
TRALLOAMT3 97 BCD*10.3 Tax Reporting Allocated Amount 3 E A 
TRALLOAMT4 98 BCD*10.3 Tax Reporting Allocated Amount 4 E A 
TRALLOAMT5 99 BCD*10.3 Tax Reporting Allocated Amount 5 E A 
RAXBASE1 100 BCD*10.3 Retainage Tax Base 1 E A 
RAXBASE2 101 BCD*10.3 Retainage Tax Base 2 E A 
RAXBASE3 102 BCD*10.3 Retainage Tax Base 3 E A 
RAXBASE4 103 BCD*10.3 Retainage Tax Base 4 E A 
RAXBASE5 104 BCD*10.3 Retainage Tax Base 5 E A 
RXRECVAMT1 105 BCD*10.3 Retainage Tax Recoverable Amt. 1 E A 
RXRECVAMT2 106 BCD*10.3 Retainage Tax Recoverable Amt. 2 E A 
RXRECVAMT3 107 BCD*10.3 Retainage Tax Recoverable Amt. 3 E A 
RXRECVAMT4 108 BCD*10.3 Retainage Tax Recoverable Amt. 4 E A 
RXRECVAMT5 109 BCD*10.3 Retainage Tax Recoverable Amt. 5 E A 
RXEXPSAMT1 110 BCD*10.3 Retainage Tax Expense Amount 1 E A 
RXEXPSAMT2 111 BCD*10.3 Retainage Tax Expense Amount 2 E A 
RXEXPSAMT3 112 BCD*10.3 Retainage Tax Expense Amount 3 E A 
RXEXPSAMT4 113 BCD*10.3 Retainage Tax Expense Amount 4 E A 
RXEXPSAMT5 114 BCD*10.3 Retainage Tax Expense Amount 5 E A 
RXALLOAMT1 115 BCD*10.3 Retainage Tax Allocated Amount 1 E A 
RXALLOAMT2 116 BCD*10.3 Retainage Tax Allocated Amount 2 E A 
RXALLOAMT3 117 BCD*10.3 Retainage Tax Allocated Amount 3 E A 
RXALLOAMT4 118 BCD*10.3 Retainage Tax Allocated Amount 4 E A 
RXALLOAMT5 119 BCD*10.3 Retainage Tax Allocated Amount 5 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).