View: CR/DR Note Additional Costs

RotoID: PO0320
Table: POCRNS
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:POCRNS

Compositions: 7

RotoID Tables Title DLL
PO0311 POCRNH1POCRNH2 Credit/Debit Notes POCRNH
PO0310 Credit/Debit Note Functions POCRNG
PO0312 POCRNI Credit/Debit Note Postings POCRNI
PO0321 POCRNT CR/DR Note Posting Add. Costs POCRNT
PO0325 POCRNS CR/DR Add. Costs Superview POCRNW
PO0323 POCRNSO CR/DR Note Add. Cost Opt. Fields POCRNSO
PO0326 POCRND CR/DR Note Cost Distributions POCRND

Keys: 3

Title Fields
Master Key CRNHSEQ, CRNSREV
Second Key CRNHSEQ, CRNSSEQ
Detail Locator Key CRNSSEQ, CRNHSEQ

Fields: 212

Field Index Type Title Attributes Presentation
CRNHSEQ 1 BCD*10.0 Credit/Debit Note Sequence Key E A K R 
CRNSREV 2 BCD*10.0 Line Number E A K R 
CRNSSEQ 3 BCD*10.0 Credit/Debit Note Cost Sequence E A 
COMPLETION 4 Integer Completion Status A X  List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE 5 Date Date Completed A X 
INDBTABLE 6 Boolean Stored in Database Table A C X  List:2 entries
0 = No
1 = Yes
RCPHSEQ 7 BCD*10.0 Receipt Sequence Key A X 
RCPSSEQ 8 BCD*10.0 Receipt Cost Sequence A X 
INVHSEQ 9 BCD*10.0 Invoice Sequence Key A X 
INVSSEQ 10 BCD*10.0 Invoice Cost Sequence A X 
ADDCOST 11 String*6 Additional Cost E A X  Mask: %-6N
GLEXPACCT 12 String*45 Expense Account A X  Mask: %-45C
GLRETACCT 13 String*45 Return Account A X  Mask: %-45C
AMOUNT 14 BCD*10.3 Amount E A X 
PRORMETHOD 15 Integer Proration Method E A P X  List:1 entries
1 = No Proration
REPRORATE 16 Integer Reproration Method A P X  List:3 entries
1 = Leave
2 = Prorate
3 = Expense
DESCRIPTIO 17 String*60 Description E A X 
REFERENCE 18 String*60 Reference E A X 
COMMENT 19 String*250 Comment E A X 
TAXICLASS1 20 Integer Cost Tax Class 1 E A X 
TAXICLASS2 21 Integer Cost Tax Class 2 E A X 
TAXICLASS3 22 Integer Cost Tax Class 3 E A X 
TAXICLASS4 23 Integer Cost Tax Class 4 E A X 
TAXICLASS5 24 Integer Cost Tax Class 5 E A X 
TAXBASE1 25 BCD*10.3 Tax Base 1 A X 
TAXBASE2 26 BCD*10.3 Tax Base 2 A X 
TAXBASE3 27 BCD*10.3 Tax Base 3 A X 
TAXBASE4 28 BCD*10.3 Tax Base 4 A X 
TAXBASE5 29 BCD*10.3 Tax Base 5 A X 
TAXRATE1 30 BCD*8.5 Tax Rate 1 A X 
TAXRATE2 31 BCD*8.5 Tax Rate 2 A X 
TAXRATE3 32 BCD*8.5 Tax Rate 3 A X 
TAXRATE4 33 BCD*8.5 Tax Rate 4 A X 
TAXRATE5 34 BCD*8.5 Tax Rate 5 A X 
TAXAMOUNT1 35 BCD*10.3 Tax Amount 1 A X 
TAXAMOUNT2 36 BCD*10.3 Tax Amount 2 A X 
TAXAMOUNT3 37 BCD*10.3 Tax Amount 3 A X 
TAXAMOUNT4 38 BCD*10.3 Tax Amount 4 A X 
TAXAMOUNT5 39 BCD*10.3 Tax Amount 5 A X 
TAXINCLUD1 40 Boolean Tax Includable 1 E A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 41 Boolean Tax Includable 2 E A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 42 Boolean Tax Includable 3 E A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 43 Boolean Tax Includable 4 E A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 44 Boolean Tax Includable 5 E A X  List:2 entries
0 = No
1 = Yes
TXALLOAMT1 45 BCD*10.3 Tax Allocated Amount 1 A X 
TXALLOAMT2 46 BCD*10.3 Tax Allocated Amount 2 A X 
TXALLOAMT3 47 BCD*10.3 Tax Allocated Amount 3 A X 
TXALLOAMT4 48 BCD*10.3 Tax Allocated Amount 4 A X 
TXALLOAMT5 49 BCD*10.3 Tax Allocated Amount 5 A X 
TXRECVAMT1 50 BCD*10.3 Tax Recoverable Amount 1 A X 
TXRECVAMT2 51 BCD*10.3 Tax Recoverable Amount 2 A X 
TXRECVAMT3 52 BCD*10.3 Tax Recoverable Amount 3 A X 
TXRECVAMT4 53 BCD*10.3 Tax Recoverable Amount 4 A X 
TXRECVAMT5 54 BCD*10.3 Tax Recoverable Amount 5 A X 
TXEXPSAMT1 55 BCD*10.3 Tax Expense Amount 1 A X 
TXEXPSAMT2 56 BCD*10.3 Tax Expense Amount 2 A X 
TXEXPSAMT3 57 BCD*10.3 Tax Expense Amount 3 A X 
TXEXPSAMT4 58 BCD*10.3 Tax Expense Amount 4 A X 
TXEXPSAMT5 59 BCD*10.3 Tax Expense Amount 5 A X 
TXBASEALLO 60 BCD*10.3 Net of Tax A X 
TXINCLUDED 61 BCD*10.3 Tax Included A C X 
TXEXCLUDED 62 BCD*10.3 Tax Excluded A C X 
TAXAMOUNT 63 BCD*10.3 Total Tax A C X 
TXRECVAMT 64 BCD*10.3 Total Tax Recoverable A X 
TXEXPSAMT 65 BCD*10.3 Total Tax Expensed A X 
TXALLOAMT 66 BCD*10.3 Total Tax Allocated A X 
TFBASEALLO 67 BCD*10.3 Func. Net of Tax A C X 
TFINCLUDE1 68 BCD*10.3 Func. Tax Included Amount 1 A C X 
TFINCLUDE2 69 BCD*10.3 Func. Tax Included Amount 2 A C X 
TFINCLUDE3 70 BCD*10.3 Func. Tax Included Amount 3 A C X 
TFINCLUDE4 71 BCD*10.3 Func. Tax Included Amount 4 A C X 
TFINCLUDE5 72 BCD*10.3 Func. Tax Included Amount 5 A C X 
TFALLOAMT1 73 BCD*10.3 Func. Tax Allocated Amount 1 A C X 
TFALLOAMT2 74 BCD*10.3 Func. Tax Allocated Amount 2 A C X 
TFALLOAMT3 75 BCD*10.3 Func. Tax Allocated Amount 3 A C X 
TFALLOAMT4 76 BCD*10.3 Func. Tax Allocated Amount 4 A C X 
TFALLOAMT5 77 BCD*10.3 Func. Tax Allocated Amount 5 A C X 
TFRECVAMT1 78 BCD*10.3 Func. Tax Recoverable Amount 1 A C X 
TFRECVAMT2 79 BCD*10.3 Func. Tax Recoverable Amount 2 A C X 
TFRECVAMT3 80 BCD*10.3 Func. Tax Recoverable Amount 3 A C X 
TFRECVAMT4 81 BCD*10.3 Func. Tax Recoverable Amount 4 A C X 
TFRECVAMT5 82 BCD*10.3 Func. Tax Recoverable Amount 5 A C X 
TFEXPSAMT1 83 BCD*10.3 Func. Tax Expense Amount 1 A C X 
TFEXPSAMT2 84 BCD*10.3 Func. Tax Expense Amount 2 A C X 
TFEXPSAMT3 85 BCD*10.3 Func. Tax Expense Amount 3 A C X 
TFEXPSAMT4 86 BCD*10.3 Func. Tax Expense Amount 4 A C X 
TFEXPSAMT5 87 BCD*10.3 Func. Tax Expense Amount 5 A C X 
RCPNUMBER 88 String*22 Receipt Number A X  Mask: %-22C
RCPHSEQA 89 BCD*10.0 Apply To Receipt Sequence Key A X 
RCPNUMBERA 90 String*22 Apply To Receipt Number A X  Mask: %-22C
INVSSEQG 91 BCD*10.0 Invoice Cost Group Sequence A X 
VALUES 92 Long Optional Fields E A C X 
CONTRACT 93 String*16 Contract A X  Mask: %-16C
PROJECT 94 String*16 Project A X  Mask: %-16N
CCATEGORY 95 String*16 (Cost) Category A X  Mask: %-16N
COSTCLASS 96 Integer Cost Class A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE 97 String*24 Resource A P X  Mask: %-16N
BILLTYPE 98 Integer Billing Type A P X  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 99 BCD*10.6 Billing Rate A X 
BILLCURR 100 String*3 Billing Currency A C X  Mask: %-3N
ARITEMNO 101 String*16 A/R Item Number A X  Mask: %-16C
ARUNIT 102 String*10 A/R Unit of Measure A X  Mask: %-10C
CALCOVRHD 103 Boolean Calculate Overhead A X  List:2 entries
0 = No
1 = Yes
CALCLABOR 104 Boolean Calculate Labor A X  List:2 entries
0 = No
1 = Yes
RTGPERCENT 105 BCD*5.5 Retainage Percentage A X 
RTGDAYS 106 Integer Retention Period A X 
RTGAMOUNT 107 BCD*10.3 Retainage Amount A X 
RTGDATEDUE 108 Date Retainage Due Date A X 
RTGAMTOVER 109 Boolean Retainage Amount Overridden A C X  List:2 entries
0 = No
1 = Yes
RTGDDTOVER 110 Boolean Retainage Due Date Overridden A C X  List:2 entries
0 = No
1 = Yes
COSTDISTS 111 Long Cost Distributions E A C X 
MANDISTS 112 Long Manual Cost Distributions E A C X 
EXTDISTS 113 Long Extraneous Cost Distributions E A C X 
TARAMOUNT1 114 BCD*10.3 Tax Reporting Amount 1 A X 
TARAMOUNT2 115 BCD*10.3 Tax Reporting Amount 2 A X 
TARAMOUNT3 116 BCD*10.3 Tax Reporting Amount 3 A X 
TARAMOUNT4 117 BCD*10.3 Tax Reporting Amount 4 A X 
TARAMOUNT5 118 BCD*10.3 Tax Reporting Amount 5 A X 
TRALLOAMT1 119 BCD*10.3 Tax Reporting Allocated Amount 1 A X 
TRALLOAMT2 120 BCD*10.3 Tax Reporting Allocated Amount 2 A X 
TRALLOAMT3 121 BCD*10.3 Tax Reporting Allocated Amount 3 A X 
TRALLOAMT4 122 BCD*10.3 Tax Reporting Allocated Amount 4 A X 
TRALLOAMT5 123 BCD*10.3 Tax Reporting Allocated Amount 5 A X 
TRRECVAMT1 124 BCD*10.3 Tax Reporting Recoverable Amt. 1 A X 
TRRECVAMT2 125 BCD*10.3 Tax Reporting Recoverable Amt. 2 A X 
TRRECVAMT3 126 BCD*10.3 Tax Reporting Recoverable Amt. 3 A X 
TRRECVAMT4 127 BCD*10.3 Tax Reporting Recoverable Amt. 4 A X 
TRRECVAMT5 128 BCD*10.3 Tax Reporting Recoverable Amt. 5 A X 
TREXPSAMT1 129 BCD*10.3 Tax Reporting Expense Amount 1 A X 
TREXPSAMT2 130 BCD*10.3 Tax Reporting Expense Amount 2 A X 
TREXPSAMT3 131 BCD*10.3 Tax Reporting Expense Amount 3 A X 
TREXPSAMT4 132 BCD*10.3 Tax Reporting Expense Amount 4 A X 
TREXPSAMT5 133 BCD*10.3 Tax Reporting Expense Amount 5 A X 
GLEXPACCTD 141 String*60 Expense Account Description A C X 
GLRETACCTD 142 String*60 Return Expense Account Desc. A C X 
TXICLASS1D 143 String*60 Tax Class 1 Description A C X 
TXICLASS2D 144 String*60 Tax Class 2 Description A C X 
TXICLASS3D 145 String*60 Tax Class 3 Description A C X 
TXICLASS4D 146 String*60 Tax Class 4 Description A C X 
TXICLASS5D 147 String*60 Tax Class 5 Description A C X 
TXINCLUDE1 148 BCD*10.3 Included Tax Amount 1 A X 
TXINCLUDE2 149 BCD*10.3 Included Tax Amount 2 A X 
TXINCLUDE3 150 BCD*10.3 Included Tax Amount 3 A X 
TXINCLUDE4 151 BCD*10.3 Included Tax Amount 4 A X 
TXINCLUDE5 152 BCD*10.3 Included Tax Amount 5 A X 
TXEXCLUDE1 153 BCD*10.3 Excluded Tax Amount 1 A X 
TXEXCLUDE2 154 BCD*10.3 Excluded Tax Amount 2 A X 
TXEXCLUDE3 155 BCD*10.3 Excluded Tax Amount 3 A X 
TXEXCLUDE4 156 BCD*10.3 Excluded Tax Amount 4 A X 
TXEXCLUDE5 157 BCD*10.3 Excluded Tax Amount 5 A X 
MTOPRORATE 158 BCD*10.3 Manual To Prorate A C X 
ISCOMPLETE 159 Boolean Completed E A X  List:2 entries
0 = No
1 = Yes
TAXLINE 160 Long Lines Tax Calculation Sees A X 
COSTCMPL 161 Long Costs Complete A X 
COST 162 Long Costs A X 
INVSREV 163 BCD*10.0 Line Number A C X 
RCPSREV 164 BCD*10.0 Line Number A C X 
PROCESSCMD 165 Integer Command E A C X  List:18 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
6 = Insert Item Serial Optional Fields
7 = Insert Item Lot Optional Fields
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
27 = Auto-assign Serials
28 = Auto-assign Lots
29 = Create Serials/Lots List
31 = Post Serials/Lots to IC Inventory
JOBCOST 166 Long Job Related Cost A X 
AMOUNTC 167 BCD*10.3 Amount Distribution Sum E A C X 
BILLRATEC 168 BCD*10.6 Billing Rate Distribution Sum E A C X 
CONTSTYLE 169 Integer Project Style A C X  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 170 Integer Project Type A C X  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 171 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 172 String*16 Unformatted Contract Code A C X  Mask: %-16C
TRINCLUDE1 173 BCD*10.3 Tax Reporting Included Amount 1 A X 
TRINCLUDE2 174 BCD*10.3 Tax Reporting Included Amount 2 A X 
TRINCLUDE3 175 BCD*10.3 Tax Reporting Included Amount 3 A X 
TRINCLUDE4 176 BCD*10.3 Tax Reporting Included Amount 4 A X 
TRINCLUDE5 177 BCD*10.3 Tax Reporting Included Amount 5 A X 
TREXCLUDE1 178 BCD*10.3 Tax Reporting Excluded Amount 1 A X 
TREXCLUDE2 179 BCD*10.3 Tax Reporting Excluded Amount 2 A X 
TREXCLUDE3 180 BCD*10.3 Tax Reporting Excluded Amount 3 A X 
TREXCLUDE4 181 BCD*10.3 Tax Reporting Excluded Amount 4 A X 
TREXCLUDE5 182 BCD*10.3 Tax Reporting Excluded Amount 5 A X 
TARAMOUNT 183 BCD*10.3 Tax Reporting Total Amount A X 
TRINCLUDED 184 BCD*10.3 Tax Reporting Included Amount A X 
TREXCLUDED 185 BCD*10.3 Tax Reporting Excluded Amount A X 
TRRECVAMT 186 BCD*10.3 Tax Reporting Recoverable Amount A X 
TREXPSAMT 187 BCD*10.3 Tax Reporting Expensed Amount A X 
TRALLOAMT 188 BCD*10.3 Tax Reporting Allocated Amount A X 
RAXBASE1 189 BCD*10.3 Retainage Tax Base 1 A X 
RAXBASE2 190 BCD*10.3 Retainage Tax Base 2 A X 
RAXBASE3 191 BCD*10.3 Retainage Tax Base 3 A X 
RAXBASE4 192 BCD*10.3 Retainage Tax Base 4 A X 
RAXBASE5 193 BCD*10.3 Retainage Tax Base 5 A X 
RAXAMOUNT1 194 BCD*10.3 Retainage Tax Amount 1 A X 
RAXAMOUNT2 195 BCD*10.3 Retainage Tax Amount 2 A X 
RAXAMOUNT3 196 BCD*10.3 Retainage Tax Amount 3 A X 
RAXAMOUNT4 197 BCD*10.3 Retainage Tax Amount 4 A X 
RAXAMOUNT5 198 BCD*10.3 Retainage Tax Amount 5 A X 
RXRECVAMT1 201 BCD*10.3 Retainage Tax Recoverable Amt. 1 A X 
RXRECVAMT2 202 BCD*10.3 Retainage Tax Recoverable Amt. 2 A X 
RXRECVAMT3 203 BCD*10.3 Retainage Tax Recoverable Amt. 3 A X 
RXRECVAMT4 204 BCD*10.3 Retainage Tax Recoverable Amt. 4 A X 
RXRECVAMT5 205 BCD*10.3 Retainage Tax Recoverable Amt. 5 A X 
RXEXPSAMT1 206 BCD*10.3 Retainage Tax Expense Amount 1 A X 
RXEXPSAMT2 207 BCD*10.3 Retainage Tax Expense Amount 2 A X 
RXEXPSAMT3 208 BCD*10.3 Retainage Tax Expense Amount 3 A X 
RXEXPSAMT4 209 BCD*10.3 Retainage Tax Expense Amount 4 A X 
RXEXPSAMT5 210 BCD*10.3 Retainage Tax Expense Amount 5 A X 
RXALLOAMT1 211 BCD*10.3 Retainage Tax Allocated Amount 1 A X 
RXALLOAMT2 212 BCD*10.3 Retainage Tax Allocated Amount 2 A X 
RXALLOAMT3 213 BCD*10.3 Retainage Tax Allocated Amount 3 A X 
RXALLOAMT4 214 BCD*10.3 Retainage Tax Allocated Amount 4 A X 
RXALLOAMT5 215 BCD*10.3 Retainage Tax Allocated Amount 5 A X 
RAXAMOUNT 216 BCD*10.3 Retainage Tax Total Amount A X 
TXRXAMT1 217 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 1 A X 
TXRXAMT2 218 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 2 A X 
TXRXAMT3 219 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 3 A X 
TXRXAMT4 220 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 4 A X 
TXRXAMT5 221 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 5 A X 

This page was generated on 2023-Aug-31

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