# Table: CR/DR Note Audit Prorate Lines

Table: POCRNAQ
View: PO0306
Record length: 1574
Flags: A R

## Keys: 2

Title | Flags | Fields
--- | --- | ---
Detail |  | DAYENDSEQ, CRNAHSEQ, CRNALSEQ, CRNASSEQ
Currency |  | DAYENDSEQ, CRNAHSEQ, CRNALSEQ, CURRENCY, CRNASSEQ

## Fields: 148

Field | Type | Title | Presentation
--- | --- | --- | ---
DAYENDSEQ | BCD*10.0 | Day End Number |
CRNAHSEQ | BCD*10.0 | Processing Sequence |
CRNALSEQ | BCD*10.0 | Line Number |
CRNASSEQ | 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 |
FCAMOUNT | BCD*10.3 | Conversion Functional Amount |
SCAMOUNT | BCD*10.3 | Conversion Source 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 |
TXBASETOT1 | BCD*10.3 | Total Tax Base 1 |
TXBASETOT2 | BCD*10.3 | Total Tax Base 2 |
TXBASETOT3 | BCD*10.3 | Total Tax Base 3 |
TXBASETOT4 | BCD*10.3 | Total Tax Base 4 |
TXBASETOT5 | BCD*10.3 | Total Tax Base 5 |
TXALLOAMT1 | BCD*10.3 | Tax Allocated Amount 1 |
TXALLOAMT2 | BCD*10.3 | Tax Allocated Amount 2 |
TXALLOAMT3 | BCD*10.3 | Tax Allocated Amount 3 |
TXALLOAMT4 | BCD*10.3 | Tax Allocated Amount 4 |
TXALLOAMT5 | BCD*10.3 | Tax Allocated Amount 5 |
TXRECVAMT1 | BCD*10.3 | Tax Recoverable Amount 1 |
TXRECVAMT2 | BCD*10.3 | Tax Recoverable Amount 2 |
TXRECVAMT3 | BCD*10.3 | Tax Recoverable Amount 3 |
TXRECVAMT4 | BCD*10.3 | Tax Recoverable Amount 4 |
TXRECVAMT5 | BCD*10.3 | Tax Recoverable Amount 5 |
TXEXPSAMT1 | BCD*10.3 | Tax Expense Amount 1 |
TXEXPSAMT2 | BCD*10.3 | Tax Expense Amount 2 |
TXEXPSAMT3 | BCD*10.3 | Tax Expense Amount 3 |
TXEXPSAMT4 | BCD*10.3 | Tax Expense Amount 4 |
TXEXPSAMT5 | BCD*10.3 | Tax Expense Amount 5 |
BLRTTOT | BCD*10.6 | Total Billing Rate |
BCBLRTTOT | BCD*10.6 | (BC) Total Billing Rate |
FCRTGAMTOT | BCD*10.3 | Func. Total Retainage Amount |
SCRTGAMTOT | BCD*10.3 | Total Retainage Amount |
RTGPERCENT | BCD*5.5 | Retainage Percentage |
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 | = | *
2 | = | /
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 |
TFALLOAMT1 | BCD*10.3 | Func. Tax Allocated Amount 1 |
TFALLOAMT2 | BCD*10.3 | Func. Tax Allocated Amount 2 |
TFALLOAMT3 | BCD*10.3 | Func. Tax Allocated Amount 3 |
TFALLOAMT4 | BCD*10.3 | Func. Tax Allocated Amount 4 |
TFALLOAMT5 | BCD*10.3 | Func. Tax Allocated Amount 5 |
TFRECVAMT1 | BCD*10.3 | Func. Tax Recoverable Amount 1 |
TFRECVAMT2 | BCD*10.3 | Func. Tax Recoverable Amount 2 |
TFRECVAMT3 | BCD*10.3 | Func. Tax Recoverable Amount 3 |
TFRECVAMT4 | BCD*10.3 | Func. Tax Recoverable Amount 4 |
TFRECVAMT5 | BCD*10.3 | Func. Tax Recoverable Amount 5 |
TFEXPSAMT1 | BCD*10.3 | Func. Tax Expense Amount 1 |
TFEXPSAMT2 | BCD*10.3 | Func. Tax Expense Amount 2 |
TFEXPSAMT3 | BCD*10.3 | Func. Tax Expense Amount 3 |
TFEXPSAMT4 | BCD*10.3 | Func. Tax Expense Amount 4 |
TFEXPSAMT5 | BCD*10.3 | Func. Tax Expense Amount 5 |
TRALLOAMT1 | BCD*10.3 | Tax Reporting Allocated Amount 1 |
TRALLOAMT2 | BCD*10.3 | Tax Reporting Allocated Amount 2 |
TRALLOAMT3 | BCD*10.3 | Tax Reporting Allocated Amount 3 |
TRALLOAMT4 | BCD*10.3 | Tax Reporting Allocated Amount 4 |
TRALLOAMT5 | BCD*10.3 | Tax Reporting Allocated Amount 5 |
TRRECVAMT1 | BCD*10.3 | Tax Reporting Recoverable Amt. 1 |
TRRECVAMT2 | BCD*10.3 | Tax Reporting Recoverable Amt. 2 |
TRRECVAMT3 | BCD*10.3 | Tax Reporting Recoverable Amt. 3 |
TRRECVAMT4 | BCD*10.3 | Tax Reporting Recoverable Amt. 4 |
TRRECVAMT5 | BCD*10.3 | Tax Reporting Recoverable Amt. 5 |
TREXPSAMT1 | BCD*10.3 | Tax Reporting Expense Amount 1 |
TREXPSAMT2 | BCD*10.3 | Tax Reporting Expense Amount 2 |
TREXPSAMT3 | BCD*10.3 | Tax Reporting Expense Amount 3 |
TREXPSAMT4 | BCD*10.3 | Tax Reporting Expense Amount 4 |
TREXPSAMT5 | BCD*10.3 | Tax Reporting Expense Amount 5 |
SCAPAMOUNT | BCD*10.3 | A/P Amount |
FCAPAMOUNT | BCD*10.3 | Func. A/P Amount |
RXAPALLO | BCD*10.3 | A/P Retainage Tax Allocated |
RFAPALLO | BCD*10.3 | Func. A/P Retainage Tax Allocd. |
RXAPEXPS | BCD*10.3 | A/P Retainage Tax Expensed |
RFAPEXPS | BCD*10.3 | Func. A/P Retainage Tax Expensed |
RXAPBASE1 | BCD*10.3 | A/P Retainage Tax Base 1 |
RXAPBASE2 | BCD*10.3 | A/P Retainage Tax Base 2 |
RXAPBASE3 | BCD*10.3 | A/P Retainage Tax Base 3 |
RXAPBASE4 | BCD*10.3 | A/P Retainage Tax Base 4 |
RXAPBASE5 | BCD*10.3 | A/P Retainage Tax Base 5 |
RXAPAMT1 | BCD*10.3 | A/P Retainage Tax Amount 1 |
RXAPAMT2 | BCD*10.3 | A/P Retainage Tax Amount 2 |
RXAPAMT3 | BCD*10.3 | A/P Retainage Tax Amount 3 |
RXAPAMT4 | BCD*10.3 | A/P Retainage Tax Amount 4 |
RXAPAMT5 | BCD*10.3 | A/P Retainage Tax Amount 5 |
RFAPAMT1 | BCD*10.3 | Func. A/P Retainage Tax Amount 1 |
RFAPAMT2 | BCD*10.3 | Func. A/P Retainage Tax Amount 2 |
RFAPAMT3 | BCD*10.3 | Func. A/P Retainage Tax Amount 3 |
RFAPAMT4 | BCD*10.3 | Func. A/P Retainage Tax Amount 4 |
RFAPAMT5 | BCD*10.3 | Func. A/P Retainage Tax Amount 5 |

This page was generated on 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.