View: Return Audit Prorate Lines

RotoID: PO0727
Table: PORETAQ
Protocol: Detail
DLL:PORETAQ

Compositions: 1

RotoID Tables Title DLL
PO0724 PORETAH Return Audit Headers PORETAH

Keys: 2

Title Fields
Detail DAYENDSEQ, RETAHSEQ, RETALSEQ, RETASSEQ
Currency DAYENDSEQ, RETAHSEQ, RETALSEQ, CURRENCY, RETASSEQ

Fields: 66

Field Index Type Title Attributes Presentation
DAYENDSEQ 1 BCD*10.0 Day End Number E A K R 
RETAHSEQ 2 BCD*10.0 Processing Sequence E A K R 
RETALSEQ 3 BCD*10.0 Line Number E A K R 
RETASSEQ 4 BCD*10.0 Cost Number E A K R 
GLITEM 5 String*45 G/L Item E A  Mask: %-45C
GLEXPENSE 6 String*45 Return Account E A  Mask: %-45C
GLCLEARING 7 String*45 Receipt Clearing Account E A  Mask: %-45C
POSTCLEARI 8 Boolean Post to clearing account? E A  List:2 entries
0 = No
1 = Yes
CURRENCY 9 String*3 Currency E A  Mask: %-3N
SCURNDECML 10 Integer Decimal Places E A 
FCITEM 11 BCD*10.3 Func. Item Amount E A 
SCITEM 12 BCD*10.3 Item amount E A 
FCEXPENSE 13 BCD*10.3 Func. Expensed Amount E A 
SCEXPENSE 14 BCD*10.3 Expensed amount E A 
FCBASEALLO 15 BCD*10.3 Func. Base to Allocate E A 
SCBASEALLO 16 BCD*10.3 Base to Allocate E A 
FCTAXALLO 17 BCD*10.3 Func. Total Tax Allocated E A 
SCTAXALLO 18 BCD*10.3 Total Tax Allocated E A 
FCTAXRECV 19 BCD*10.3 Func. Total Tax Recoverable E A 
SCTAXRECV 20 BCD*10.3 Total Tax Recoverable E A 
FCTAXEXPS 21 BCD*10.3 Func. Total Tax Expensed E A 
SCTAXEXPS 22 BCD*10.3 Total Tax Expensed E A 
FCTAXINCL 23 BCD*10.3 Func. Tax Included in Price E A 
SCTAXINCL 24 BCD*10.3 Tax Included in Price E A 
TAXBASE1 25 BCD*10.3 Tax Base 1 E A 
TAXBASE2 26 BCD*10.3 Tax Base 2 E A 
TAXBASE3 27 BCD*10.3 Tax Base 3 E A 
TAXBASE4 28 BCD*10.3 Tax Base 4 E A 
TAXBASE5 29 BCD*10.3 Tax Base 5 E A 
TAXAMOUNT1 30 BCD*10.3 Tax Amount 1 E A 
TAXAMOUNT2 31 BCD*10.3 Tax Amount 2 E A 
TAXAMOUNT3 32 BCD*10.3 Tax Amount 3 E A 
TAXAMOUNT4 33 BCD*10.3 Tax Amount 4 E A 
TAXAMOUNT5 34 BCD*10.3 Tax Amount 5 E A 
FCTAXAMT1 35 BCD*10.3 Func. Tax Amount 1 E A 
FCTAXAMT2 36 BCD*10.3 Func. Tax Amount 2 E A 
FCTAXAMT3 37 BCD*10.3 Func. Tax Amount 3 E A 
FCTAXAMT4 38 BCD*10.3 Func. Tax Amount 4 E A 
FCTAXAMT5 39 BCD*10.3 Func. Tax Amount 5 E A 
BILLRATE 40 BCD*10.6 Billing Rate E A 
BCBILLRATE 41 BCD*10.6 (BC) Billing Rate E A 
GLOVERHEAD 42 String*45 Overhead Account E A  Mask: %-45C
GLLABOR 43 String*45 Labor Burden Account E A  Mask: %-45C
FCOVRHDAMT 44 BCD*10.3 Func. Overhead Amount E A 
SCOVRHDAMT 45 BCD*10.3 Overhead Amount E A 
FCLABORAMT 46 BCD*10.3 Func. Labor Burden Amount E A 
SCLABORAMT 47 BCD*10.3 Labor Burden Amount E A 
BCRATE 48 BCD*8.7 Billing Currency Conversion Rate E A 
BCRATEDATE 49 Date Billing Currency Conv. Rate Date E A 
BCRATETYPE 50 String*2 Billing Currency Conv. Rate Type E A  Mask: %-2N
BCRATEOPER 51 Integer Billing Curr. Cv. Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
BCRATEXIST 52 Boolean Billing Curr. Conv. Rate Exists E A  List:2 entries
0 = No
1 = Yes
PMTRANSNUM 53 Long PJC Transaction Number E A 
RCTAXALLO 54 BCD*10.3 Rptg. Total Tax Allocated E A 
RCTAXRECV 55 BCD*10.3 Rptg. Total Tax Recoverable E A 
RCTAXEXPS 56 BCD*10.3 Rptg. Total Tax Expensed E A 
RCTAXINCL 57 BCD*10.3 Rptg. Total Tax Included E A 
TARAMOUNT1 58 BCD*10.3 Tax Reporting Amount 1 E A 
TARAMOUNT2 59 BCD*10.3 Tax Reporting Amount 2 E A 
TARAMOUNT3 60 BCD*10.3 Tax Reporting Amount 3 E A 
TARAMOUNT4 61 BCD*10.3 Tax Reporting Amount 4 E A 
TARAMOUNT5 62 BCD*10.3 Tax Reporting Amount 5 E A 
SCRAXALLO 63 BCD*10.3 Total Rtg. Tax Allocated E A 
FCRAXALLO 64 BCD*10.3 Func. Total Rtg. Tax Allocated E A 
SCRAXEXPS 65 BCD*10.3 Total Rtg. Tax Expensed E A 
FCRAXEXPS 66 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).