View: CR/DR Note Audit Costs

RotoID: PO0307
Table: POCRNAS
Protocol: Detail
DLL:POCRNAS

Compositions: 2

RotoID Tables Title DLL
PO0304 POCRNAH Credit/Debit Note Audit Headers POCRNAH
PO0333 POCRASO CR/DR Note Audit Cost Opt. Flds POCRASO

Keys: 1

Title Fields
Detail Key DAYENDSEQ, CRNAHSEQ, CRNASSEQ

Fields: 148

Field Index Type Title Attributes Presentation
DAYENDSEQ 1 BCD*10.0 Day End Number E A K R 
CRNAHSEQ 2 BCD*10.0 Processing Sequence E A K R 
CRNASSEQ 3 BCD*10.0 Cost Number E A K R 
TRANSTYPE 4 Integer Transaction Type E A 
INVNUMBER 5 String*22 Invoice Number E A  Mask: %-22C
PONUMBER 6 String*22 Purchase Order Number E A  Mask: %-22C
RCPNUMBER 7 String*22 Receipt Number E A  Mask: %-22C
CRNNUMBER 8 String*22 Credit/Debit Note Number E A  Mask: %-22C
ADDCOST 9 String*6 Additional Cost E A  Mask: %-6N
DESCRIPTIO 10 String*60 Description E A 
PRORMETHOD 11 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 12 Integer Reproration Method E A  List:3 entries
1 = Leave
2 = Prorate
3 = Expense
VENDOR 13 String*12 Vendor E A  Mask: %-12C
VENDORNAME 14 String*60 Name E A 
TAXGROUP 15 String*12 Tax Group E A  Mask: %-12N
TAXAUTH1 16 String*12 Tax Authority 1 E A 
TAXAUTH2 17 String*12 Tax Authority 2 E A 
TAXAUTH3 18 String*12 Tax Authority 3 E A 
TAXAUTH4 19 String*12 Tax Authority 4 E A 
TAXAUTH5 20 String*12 Tax Authority 5 E A 
TAXVCLASS1 21 Integer Vendor Tax Class 1 E A 
TAXVCLASS2 22 Integer Vendor Tax Class 2 E A 
TAXVCLASS3 23 Integer Vendor Tax Class 3 E A 
TAXVCLASS4 24 Integer Vendor Tax Class 4 E A 
TAXVCLASS5 25 Integer Vendor Tax Class 5 E A 
TAXICLASS1 26 Integer Cost Tax Class 1 E A 
TAXICLASS2 27 Integer Cost Tax Class 2 E A 
TAXICLASS3 28 Integer Cost Tax Class 3 E A 
TAXICLASS4 29 Integer Cost Tax Class 4 E A 
TAXICLASS5 30 Integer Cost Tax Class 5 E A 
CURRENCY 31 String*3 Currency E A  Mask: %-3N
EXRATE 32 BCD*8.7 Exchange Rate E A 
RATEDATE 33 Date Rate Date E A 
RATETYPE 34 String*2 Rate Type E A  Mask: %-2N
RATEOPER 35 Integer Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 36 Boolean Rate Overridden E A  List:2 entries
0 = No
1 = Yes
SCURNDECML 37 Integer Decimal Places E A 
GLEXPACCT 38 String*45 Expense Account E A  Mask: %-45C
GLRETACCT 39 String*45 Return Account E A  Mask: %-45C
FCAMOUNT 40 BCD*10.3 Conversion Functional Amount E A 
SCAMOUNT 41 BCD*10.3 Conversion Source Amount E A 
FCBASEALLO 42 BCD*10.3 Func. Base to Allocate E A 
SCBASEALLO 43 BCD*10.3 Base to Allocate E A 
FCTAXALLO 44 BCD*10.3 Func. Total Tax Allocated E A 
SCTAXALLO 45 BCD*10.3 Total Tax Allocated E A 
FCTAXINCL 46 BCD*10.3 Func. Tax Included in Price E A 
SCTAXINCL 47 BCD*10.3 Tax Included in Price E A 
FCTAXEXCL 48 BCD*10.3 Func. Tax Excluded from Price E A 
SCTAXEXCL 49 BCD*10.3 Tax Excluded from Price E A 
TAXBASE1 50 BCD*10.3 Tax Base 1 E A 
TAXBASE2 51 BCD*10.3 Tax Base 2 E A 
TAXBASE3 52 BCD*10.3 Tax Base 3 E A 
TAXBASE4 53 BCD*10.3 Tax Base 4 E A 
TAXBASE5 54 BCD*10.3 Tax Base 5 E A 
TAXINCLUD1 55 Boolean Tax Includable 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 56 Boolean Tax Includable 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 57 Boolean Tax Includable 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 58 Boolean Tax Includable 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 59 Boolean Tax Includable 5 E A  List:2 entries
0 = No
1 = Yes
TAXAMOUNT1 60 BCD*10.3 Tax Amount 1 E A 
TAXAMOUNT2 61 BCD*10.3 Tax Amount 2 E A 
TAXAMOUNT3 62 BCD*10.3 Tax Amount 3 E A 
TAXAMOUNT4 63 BCD*10.3 Tax Amount 4 E A 
TAXAMOUNT5 64 BCD*10.3 Tax Amount 5 E A 
TXRECVAMT1 65 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 66 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 67 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 68 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 69 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 70 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 71 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 72 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 73 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 74 BCD*10.3 Tax Expense Amount 5 E A 
INVSSEQG 75 BCD*10.0 Invoice Cost Group Sequence E A 
VALUES 76 Long Optional Fields E A C 
RCPSSEQ 77 BCD*10.0 Receipt Cost Sequence E A 
INVSSEQ 78 BCD*10.0 Invoice Cost Sequence E A 
CRNSSEQ 79 BCD*10.0 Credit/Debit Note Cost Sequence E A 
FCTAXRECV 80 BCD*10.3 Func. Total Tax Recoverable E A 
SCTAXRECV 81 BCD*10.3 Total Tax Recoverable E A 
FCTAXEXPS 82 BCD*10.3 Func. Total Tax Expensed E A 
SCTAXEXPS 83 BCD*10.3 Total Tax Expensed E A 
FCTAXAMT1 84 BCD*10.3 Func. Tax Amount 1 E A 
FCTAXAMT2 85 BCD*10.3 Func. Tax Amount 2 E A 
FCTAXAMT3 86 BCD*10.3 Func. Tax Amount 3 E A 
FCTAXAMT4 87 BCD*10.3 Func. Tax Amount 4 E A 
FCTAXAMT5 88 BCD*10.3 Func. Tax Amount 5 E A 
GLNOPRORCR 89 String*45 Expensed Add'l Cost Clr. Acct. E A  Mask: %-45C
NOPRORTOGL 90 Boolean Exp. Add'l Cost G/L data posted? E A  List:2 entries
0 = No
1 = Yes
COMMENT 91 String*250 Comment E A 
CONTRACT 92 String*16 Contract E A  Mask: %-16C
PROJECT 93 String*16 Project E A  Mask: %-16N
CCATEGORY 94 String*16 (Cost) Category E A  Mask: %-16N
COSTCLASS 95 Integer Cost Class E A  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE 96 String*24 Resource E A  Mask: %-24C
BILLTYPE 97 Integer Billing Type E A  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 98 BCD*10.6 Billing Rate E A 
BILLCURR 99 String*3 Billing Currency E A  Mask: %-3N
ARITEMNO 100 String*16 A/R Item Number E A  Mask: %-16C
ARUNIT 101 String*10 A/R Unit of Measure E A  Mask: %-10C
CALCOVRHD 102 Boolean Calculate Overhead E A  List:2 entries
0 = No
1 = Yes
CALCLABOR 103 Boolean Calculate Labor E A  List:2 entries
0 = No
1 = Yes
HASRTG 104 Boolean Has Retainage E A  List:2 entries
0 = No
1 = Yes
RTGRATE 105 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGPERCENT 106 BCD*5.5 Retainage Percentage E A 
RTGDAYS 107 Integer Retention Period E A 
SCRTGAMT 108 BCD*10.3 Retainage Amount E A 
FCRTGAMTOT 109 BCD*10.3 Func. Total Retainage Amount E A 
SCRTGAMTOT 110 BCD*10.3 Total Retainage Amount E A 
RTGDATEDUE 111 Date Retainage Due Date E A 
RTGAMTOVER 112 Boolean Retainage Amount Overridden E A  List:2 entries
0 = No
1 = Yes
RTGDDTOVER 113 Boolean Retainage Due Date Overridden E A  List:2 entries
0 = No
1 = Yes
GLOVERHEAD 114 String*45 Overhead Account E A  Mask: %-45C
GLLABOR 115 String*45 Labor Burden Account E A  Mask: %-45C
FCOVRHDAMT 116 BCD*10.3 Func. Overhead Amount E A 
SCOVRHDAMT 117 BCD*10.3 Overhead Amount E A 
FCLABORAMT 118 BCD*10.3 Func. Labor Burden Amount E A 
SCLABORAMT 119 BCD*10.3 Labor Burden Amount E A 
PMTRANSNUM 120 Long PJC Transaction Number E A 
TRCURRENCY 121 String*3 Tax Reporting Currency E A  Mask: %-3N
EXRATERC 122 BCD*8.7 Tax Reporting Exchange Rate E A 
RATEDATERC 123 Date Tax Reporting Rate Date E A 
RATETYPERC 124 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEOPERRC 125 Integer Tax Reporting Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATERCOVER 126 Boolean Tax Reporting Rate Overridden E A  List:2 entries
0 = No
1 = Yes
RCURNDECML 127 Integer Tax Reporting Decimal Places E A 
RCTAXALLO 128 BCD*10.3 Rptg. Total Tax Allocated E A 
RCTAXRECV 129 BCD*10.3 Rptg. Total Tax Recoverable E A 
RCTAXEXPS 130 BCD*10.3 Rptg. Total Tax Expensed E A 
RCTAXINCL 131 BCD*10.3 Rptg. Total Tax Included E A 
TARAMOUNT1 132 BCD*10.3 Tax Reporting Amount 1 E A 
TARAMOUNT2 133 BCD*10.3 Tax Reporting Amount 2 E A 
TARAMOUNT3 134 BCD*10.3 Tax Reporting Amount 3 E A 
TARAMOUNT4 135 BCD*10.3 Tax Reporting Amount 4 E A 
TARAMOUNT5 136 BCD*10.3 Tax Reporting Amount 5 E A 
FCAPAMOUNT 137 BCD*10.3 Func. A/P Amount E A 
SCRAXALLO 138 BCD*10.3 Total Rtg. Tax Allocated E A 
FCRAXALLO 139 BCD*10.3 Func. Total Rtg. Tax Allocated E A 
SCRAXEXPS 140 BCD*10.3 Total Rtg. Tax Expensed E A 
FCRAXEXPS 141 BCD*10.3 Func. Total Rtg. Tax Expensed E A 
RFAPALLO 142 BCD*10.3 Func. A/P Retainage Tax Allocd. E A 
RFAPEXPS 143 BCD*10.3 Func. A/P Retainage Tax Expensed E A 
RFAPAMT1 144 BCD*10.3 Func. A/P Retainage Tax Amount 1 E A 
RFAPAMT2 145 BCD*10.3 Func. A/P Retainage Tax Amount 2 E A 
RFAPAMT3 146 BCD*10.3 Func. A/P Retainage Tax Amount 3 E A 
RFAPAMT4 147 BCD*10.3 Func. A/P Retainage Tax Amount 4 E A 
RFAPAMT5 148 BCD*10.3 Func. A/P Retainage Tax Amount 5 E A 

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