Table: Return Audit Prorate Lines

Table: PORETAQ
View: PO0727
Record Length: 799

Flags: A R 

Keys: 2

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

Fields: 70

Field Type Title Presentation
DAYENDSEQ BCD*10.0 Day End Number
RETAHSEQ BCD*10.0 Processing Sequence
RETALSEQ BCD*10.0 Line Number
RETASSEQ BCD*10.0 Cost Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
GLITEM String*45 G/L Item Mask: %-45C
GLEXPENSE String*45 Return Account Mask: %-45C
GLCLEARING String*45 Receipt Clearing Account Mask: %-45C
POSTCLEARI Boolean Post to clearing account? List:2 entries
0 = No
1 = Yes
CURRENCY String*3 Currency Mask: %-3N
SCURNDECML Integer Decimal Places
FCITEM BCD*10.3 Func. Item Amount
SCITEM BCD*10.3 Item amount
FCEXPENSE BCD*10.3 Func. Expensed Amount
SCEXPENSE BCD*10.3 Expensed amount
FCBASEALLO BCD*10.3 Func. Base to Allocate
SCBASEALLO BCD*10.3 Base to Allocate
FCTAXALLO BCD*10.3 Func. Total Tax Allocated
SCTAXALLO BCD*10.3 Total Tax Allocated
FCTAXRECV BCD*10.3 Func. Total Tax Recoverable
SCTAXRECV BCD*10.3 Total Tax Recoverable
FCTAXEXPS BCD*10.3 Func. Total Tax Expensed
SCTAXEXPS BCD*10.3 Total Tax Expensed
FCTAXINCL BCD*10.3 Func. Tax Included in Price
SCTAXINCL BCD*10.3 Tax Included in Price
TAXBASE1 BCD*10.3 Tax Base 1
TAXBASE2 BCD*10.3 Tax Base 2
TAXBASE3 BCD*10.3 Tax Base 3
TAXBASE4 BCD*10.3 Tax Base 4
TAXBASE5 BCD*10.3 Tax Base 5
TAXAMOUNT1 BCD*10.3 Tax Amount 1
TAXAMOUNT2 BCD*10.3 Tax Amount 2
TAXAMOUNT3 BCD*10.3 Tax Amount 3
TAXAMOUNT4 BCD*10.3 Tax Amount 4
TAXAMOUNT5 BCD*10.3 Tax Amount 5
FCTAXAMT1 BCD*10.3 Func. Tax Amount 1
FCTAXAMT2 BCD*10.3 Func. Tax Amount 2
FCTAXAMT3 BCD*10.3 Func. Tax Amount 3
FCTAXAMT4 BCD*10.3 Func. Tax Amount 4
FCTAXAMT5 BCD*10.3 Func. Tax Amount 5
BILLRATE BCD*10.6 Billing Rate
BCBILLRATE BCD*10.6 (BC) Billing Rate
GLOVERHEAD String*45 Overhead Account Mask: %-45C
GLLABOR String*45 Labor Burden Account Mask: %-45C
FCOVRHDAMT BCD*10.3 Func. Overhead Amount
SCOVRHDAMT BCD*10.3 Overhead Amount
FCLABORAMT BCD*10.3 Func. Labor Burden Amount
SCLABORAMT BCD*10.3 Labor Burden Amount
BCRATE BCD*8.7 Billing Currency Conversion Rate
BCRATEDATE Date Billing Currency Conv. Rate Date
BCRATETYPE String*2 Billing Currency Conv. Rate Type Mask: %-2N
BCRATEOPER Integer Billing Curr. Cv. Rate Operation List:2 entries
1 = Multiply
2 = Divide
BCRATEXIST Boolean Billing Curr. Conv. Rate Exists List:2 entries
0 = No
1 = Yes
PMTRANSNUM Long PJC Transaction Number
RCTAXALLO BCD*10.3 Rptg. Total Tax Allocated
RCTAXRECV BCD*10.3 Rptg. Total Tax Recoverable
RCTAXEXPS BCD*10.3 Rptg. Total Tax Expensed
RCTAXINCL BCD*10.3 Rptg. Total Tax Included
TARAMOUNT1 BCD*10.3 Tax Reporting Amount 1
TARAMOUNT2 BCD*10.3 Tax Reporting Amount 2
TARAMOUNT3 BCD*10.3 Tax Reporting Amount 3
TARAMOUNT4 BCD*10.3 Tax Reporting Amount 4
TARAMOUNT5 BCD*10.3 Tax Reporting Amount 5
SCRAXALLO BCD*10.3 Total Rtg. Tax Allocated
FCRAXALLO BCD*10.3 Func. Total Rtg. Tax Allocated
SCRAXEXPS BCD*10.3 Total Rtg. Tax Expensed
FCRAXEXPS BCD*10.3 Func. Total Rtg. Tax Expensed

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