View: Receipt Audit Prorate Lines

RotoID: PO0690
Table: PORCPAQ
Protocol: Detail
DLL:PORCPAQ

Compositions: 1

RotoID Tables Title DLL

PO0686 PORCPAH Receipt Audit Headers PORCPAH

Keys: 2

Title Fields

Detail DAYENDSEQRCPAHSEQRCPALSEQRCPASSEQ
Currency DAYENDSEQRCPAHSEQRCPALSEQCURRENCYRCPASSEQ

Fields: 66

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 
RCPALSEQ 3 BCD*10.0 Line Number E A K R 
RCPASSEQ 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