View: Receipt Audit Costs

RotoID: PO0692
Table: PORCPAS
Protocol: Detail
DLL:PORCPAS

Compositions: 2

RotoID Tables Title DLL
PO0686 PORCPAH Receipt Audit Headers PORCPAH
PO0683 PORCASO Receipt Audit Cost Opt. Fields PORCASO

Keys: 1

Title Fields
Detail Key DAYENDSEQ, RCPAHSEQ, RCPASSEQ

Fields: 133

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