View: Invoice Day-end Additional Costs

RotoID: PO0442
Table: POINVU
Protocol: Flat
DLL:POINVU

Keys: 1

Title Fields
Master Key INVHSEQ, INVSSEQ

Fields: 109

Field Index Type Title Attributes Presentation
INVHSEQ 1 BCD*10.0 Invoice Sequence Key E A K R 
INVSSEQ 2 BCD*10.0 Invoice Cost Sequence E A K R 
ADDCOST 3 String*6 Additional Cost E A 
DESCRIPTIO 4 String*60 Description E A 
GLEXPACCT 5 String*45 Expense Account E A 
GLRETACCT 6 String*45 Return Account E A 
AMOUNT 7 BCD*10.3 Amount E A 
PRORMETHOD 8 Integer Proration Method E A 
REPRORATE 9 Integer Reproration Method E A 
MTOPRORATE 10 BCD*10.3 Manual To Prorate E A 
TAXBASE1 11 BCD*10.3 Tax Base 1 E A 
TAXBASE2 12 BCD*10.3 Tax Base 2 E A 
TAXBASE3 13 BCD*10.3 Tax Base 3 E A 
TAXBASE4 14 BCD*10.3 Tax Base 4 E A 
TAXBASE5 15 BCD*10.3 Tax Base 5 E A 
TAXINCLUD1 16 Boolean Tax Includable 1 E A 
TAXINCLUD2 17 Boolean Tax Includable 2 E A 
TAXINCLUD3 18 Boolean Tax Includable 3 E A 
TAXINCLUD4 19 Boolean Tax Includable 4 E A 
TAXINCLUD5 20 Boolean Tax Includable 5 E A 
TXBASEALLO 21 BCD*10.3 Net of Tax E A 
TXINCLUDE1 22 BCD*10.3 Included Tax Amount 1 E A 
TXINCLUDE2 23 BCD*10.3 Included Tax Amount 2 E A 
TXINCLUDE3 24 BCD*10.3 Included Tax Amount 3 E A 
TXINCLUDE4 25 BCD*10.3 Included Tax Amount 4 E A 
TXINCLUDE5 26 BCD*10.3 Included Tax Amount 5 E A 
TXRECVAMT1 27 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 28 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 29 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 30 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 31 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 32 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 33 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 34 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 35 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 36 BCD*10.3 Tax Expense Amount 5 E A 
TXALLOAMT1 37 BCD*10.3 Tax Allocated Amount 1 E A 
TXALLOAMT2 38 BCD*10.3 Tax Allocated Amount 2 E A 
TXALLOAMT3 39 BCD*10.3 Tax Allocated Amount 3 E A 
TXALLOAMT4 40 BCD*10.3 Tax Allocated Amount 4 E A 
TXALLOAMT5 41 BCD*10.3 Tax Allocated Amount 5 E A 
TFBASEALLO 42 BCD*10.3 Func. Net of Tax E A 
TFINCLUDE1 43 BCD*10.3 Func. Tax Included Amount 1 E A 
TFINCLUDE2 44 BCD*10.3 Func. Tax Included Amount 2 E A 
TFINCLUDE3 45 BCD*10.3 Func. Tax Included Amount 3 E A 
TFINCLUDE4 46 BCD*10.3 Func. Tax Included Amount 4 E A 
TFINCLUDE5 47 BCD*10.3 Func. Tax Included Amount 5 E A 
TFALLOAMT1 48 BCD*10.3 Func. Tax Allocated Amount 1 E A 
TFALLOAMT2 49 BCD*10.3 Func. Tax Allocated Amount 2 E A 
TFALLOAMT3 50 BCD*10.3 Func. Tax Allocated Amount 3 E A 
TFALLOAMT4 51 BCD*10.3 Func. Tax Allocated Amount 4 E A 
TFALLOAMT5 52 BCD*10.3 Func. Tax Allocated Amount 5 E A 
TFRECVAMT1 53 BCD*10.3 Func. Tax Recoverable Amount 1 E A 
TFRECVAMT2 54 BCD*10.3 Func. Tax Recoverable Amount 2 E A 
TFRECVAMT3 55 BCD*10.3 Func. Tax Recoverable Amount 3 E A 
TFRECVAMT4 56 BCD*10.3 Func. Tax Recoverable Amount 4 E A 
TFRECVAMT5 57 BCD*10.3 Func. Tax Recoverable Amount 5 E A 
TFEXPSAMT1 58 BCD*10.3 Func. Tax Expense Amount 1 E A 
TFEXPSAMT2 59 BCD*10.3 Func. Tax Expense Amount 2 E A 
TFEXPSAMT3 60 BCD*10.3 Func. Tax Expense Amount 3 E A 
TFEXPSAMT4 61 BCD*10.3 Func. Tax Expense Amount 4 E A 
TFEXPSAMT5 62 BCD*10.3 Func. Tax Expense Amount 5 E A 
BILLRATE 63 BCD*10.6 Billing Rate E A 
RTGPERCENT 64 BCD*5.5 Retainage Percentage E A 
RTGDAYS 65 Integer Retention Period E A 
RTGAMOUNT 66 BCD*10.3 Retainage Amount E A 
RTGDATEDUE 67 Date Retainage Due Date E A 
RTGAMTOVER 68 Boolean Retainage Amount Overridden E A 
RTGDDTOVER 69 Boolean Retainage Due Date Overridden E A 
TRINCLUDE1 70 BCD*10.3 Tax Reporting Included Amount 1 E A 
TRINCLUDE2 71 BCD*10.3 Tax Reporting Included Amount 2 E A 
TRINCLUDE3 72 BCD*10.3 Tax Reporting Included Amount 3 E A 
TRINCLUDE4 73 BCD*10.3 Tax Reporting Included Amount 4 E A 
TRINCLUDE5 74 BCD*10.3 Tax Reporting Included Amount 5 E A 
TRRECVAMT1 75 BCD*10.3 Tax Reporting Recoverable Amt. 1 E A 
TRRECVAMT2 76 BCD*10.3 Tax Reporting Recoverable Amt. 2 E A 
TRRECVAMT3 77 BCD*10.3 Tax Reporting Recoverable Amt. 3 E A 
TRRECVAMT4 78 BCD*10.3 Tax Reporting Recoverable Amt. 4 E A 
TRRECVAMT5 79 BCD*10.3 Tax Reporting Recoverable Amt. 5 E A 
TREXPSAMT1 80 BCD*10.3 Tax Reporting Expense Amount 1 E A 
TREXPSAMT2 81 BCD*10.3 Tax Reporting Expense Amount 2 E A 
TREXPSAMT3 82 BCD*10.3 Tax Reporting Expense Amount 3 E A 
TREXPSAMT4 83 BCD*10.3 Tax Reporting Expense Amount 4 E A 
TREXPSAMT5 84 BCD*10.3 Tax Reporting Expense Amount 5 E A 
TRALLOAMT1 85 BCD*10.3 Tax Reporting Allocated Amount 1 E A 
TRALLOAMT2 86 BCD*10.3 Tax Reporting Allocated Amount 2 E A 
TRALLOAMT3 87 BCD*10.3 Tax Reporting Allocated Amount 3 E A 
TRALLOAMT4 88 BCD*10.3 Tax Reporting Allocated Amount 4 E A 
TRALLOAMT5 89 BCD*10.3 Tax Reporting Allocated Amount 5 E A 
RAXBASE1 90 BCD*10.3 Retainage Tax Base 1 E A 
RAXBASE2 91 BCD*10.3 Retainage Tax Base 2 E A 
RAXBASE3 92 BCD*10.3 Retainage Tax Base 3 E A 
RAXBASE4 93 BCD*10.3 Retainage Tax Base 4 E A 
RAXBASE5 94 BCD*10.3 Retainage Tax Base 5 E A 
RXRECVAMT1 95 BCD*10.3 Retainage Tax Recoverable Amt. 1 E A 
RXRECVAMT2 96 BCD*10.3 Retainage Tax Recoverable Amt. 2 E A 
RXRECVAMT3 97 BCD*10.3 Retainage Tax Recoverable Amt. 3 E A 
RXRECVAMT4 98 BCD*10.3 Retainage Tax Recoverable Amt. 4 E A 
RXRECVAMT5 99 BCD*10.3 Retainage Tax Recoverable Amt. 5 E A 
RXEXPSAMT1 100 BCD*10.3 Retainage Tax Expense Amount 1 E A 
RXEXPSAMT2 101 BCD*10.3 Retainage Tax Expense Amount 2 E A 
RXEXPSAMT3 102 BCD*10.3 Retainage Tax Expense Amount 3 E A 
RXEXPSAMT4 103 BCD*10.3 Retainage Tax Expense Amount 4 E A 
RXEXPSAMT5 104 BCD*10.3 Retainage Tax Expense Amount 5 E A 
RXALLOAMT1 105 BCD*10.3 Retainage Tax Allocated Amount 1 E A 
RXALLOAMT2 106 BCD*10.3 Retainage Tax Allocated Amount 2 E A 
RXALLOAMT3 107 BCD*10.3 Retainage Tax Allocated Amount 3 E A 
RXALLOAMT4 108 BCD*10.3 Retainage Tax Allocated Amount 4 E A 
RXALLOAMT5 109 BCD*10.3 Retainage Tax Allocated Amount 5 E A 

This page was generated on 2021-Nov-24

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