Table: CR/DR Note Audit Costs

Table: POCRNAS
View: PO0307
Record length: 1770
Flags: A R 

Keys: 1

Title  Flags  Fields

Detail Key  DAYENDSEQ, CRNAHSEQ, CRNASSEQ

Fields: 152

Field  Type  Title  Presentation 

DAYENDSEQ  BCD*10.0  Day End Number   
CRNAHSEQ  BCD*10.0  Processing Sequence   
CRNASSEQ  BCD*10.0  Cost Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
TRANSTYPE  Integer  Transaction Type   
INVNUMBER  String*22  Invoice Number  Mask: %-22C
PONUMBER  String*22  Purchase Order Number  Mask: %-22C
RCPNUMBER  String*22  Receipt Number  Mask: %-22C
CRNNUMBER  String*22  Credit/Debit Note Number  Mask: %-22C
ADDCOST  String*6  Additional Cost  Mask: %-6N
DESCRIPTIO  String*60  Description   
PRORMETHOD  Integer  Proration Method  List: 5 entries
1=No Proration
2=Prorate by Quantity
3=Prorate by Cost
4=Prorate by Weight
5=Prorate Manually
REPRORATE  Integer  Reproration Method  List: 3 entries
1=Leave
2=Prorate
3=Expense
VENDOR  String*12  Vendor  Mask: %-12C
VENDORNAME  String*60  Name   
TAXGROUP  String*12  Tax Group  Mask: %-12N
TAXAUTH1  String*12  Tax Authority 1   
TAXAUTH2  String*12  Tax Authority 2   
TAXAUTH3  String*12  Tax Authority 3   
TAXAUTH4  String*12  Tax Authority 4   
TAXAUTH5  String*12  Tax Authority 5   
TAXVCLASS1  Integer  Vendor Tax Class 1   
TAXVCLASS2  Integer  Vendor Tax Class 2   
TAXVCLASS3  Integer  Vendor Tax Class 3   
TAXVCLASS4  Integer  Vendor Tax Class 4   
TAXVCLASS5  Integer  Vendor Tax Class 5   
TAXICLASS1  Integer  Cost Tax Class 1   
TAXICLASS2  Integer  Cost Tax Class 2   
TAXICLASS3  Integer  Cost Tax Class 3   
TAXICLASS4  Integer  Cost Tax Class 4   
TAXICLASS5  Integer  Cost Tax Class 5   
CURRENCY  String*3  Currency  Mask: %-3N
EXRATE  BCD*8.7  Exchange Rate   
RATEDATE  Date  Rate Date   
RATETYPE  String*2  Rate Type  Mask: %-2N
RATEOPER  Integer  Rate Operation  List: 2 entries
1=*
2=/
RATEOVER  Boolean  Rate Overridden  List: 2 entries
0=No
1=Yes
SCURNDECML  Integer  Decimal Places   
GLEXPACCT  String*45  Expense Account  Mask: %-45C
GLRETACCT  String*45  Return Account  Mask: %-45C
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   
FCTAXINCL  BCD*10.3  Func. Tax Included in Price   
SCTAXINCL  BCD*10.3  Tax Included in Price   
FCTAXEXCL  BCD*10.3  Func. Tax Excluded from Price   
SCTAXEXCL  BCD*10.3  Tax Excluded from 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   
TAXINCLUD1  Boolean  Tax Includable 1  List: 2 entries
0=No
1=Yes
TAXINCLUD2  Boolean  Tax Includable 2  List: 2 entries
0=No
1=Yes
TAXINCLUD3  Boolean  Tax Includable 3  List: 2 entries
0=No
1=Yes
TAXINCLUD4  Boolean  Tax Includable 4  List: 2 entries
0=No
1=Yes
TAXINCLUD5  Boolean  Tax Includable 5  List: 2 entries
0=No
1=Yes
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   
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   
INVSSEQG  BCD*10.0  Invoice Cost Group Sequence   
VALUES  Long  Optional Fields   
RCPSSEQ  BCD*10.0  Receipt Cost Sequence   
INVSSEQ  BCD*10.0  Invoice Cost Sequence   
CRNSSEQ  BCD*10.0  Credit/Debit Note Cost Sequence   
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   
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   
GLNOPRORCR  String*45  Expensed Add'l Cost Clr. Acct.  Mask: %-45C
NOPRORTOGL  Boolean  Exp. Add'l Cost G/L data posted?  List: 2 entries
0=No
1=Yes
COMMENT  String*250  Comment   
CONTRACT  String*16  Contract  Mask: %-16C
PROJECT  String*16  Project  Mask: %-16N
CCATEGORY  String*16  (Cost) Category  Mask: %-16N
COSTCLASS  Integer  Cost Class  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
RESOURCE  String*24  Resource  Mask: %-24C
BILLTYPE  Integer  Billing Type  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
BILLRATE  BCD*10.6  Billing Rate   
BILLCURR  String*3  Billing Currency  Mask: %-3N
ARITEMNO  String*16  A/R Item Number  Mask: %-16C
ARUNIT  String*10  A/R Unit of Measure  Mask: %-10C
CALCOVRHD  Boolean  Calculate Overhead  List: 2 entries
0=No
1=Yes
CALCLABOR  Boolean  Calculate Labor  List: 2 entries
0=No
1=Yes
HASRTG  Boolean  Has Retainage  List: 2 entries
0=No
1=Yes
RTGRATE  Integer  Retainage Exchange Rate  List: 2 entries
0=Use Original Document Exchange Rate
1=Use Current Exchange Rate
RTGPERCENT  BCD*5.5  Retainage Percentage   
RTGDAYS  Integer  Retention Period   
SCRTGAMT  BCD*10.3  Retainage Amount   
FCRTGAMTOT  BCD*10.3  Func. Total Retainage Amount   
SCRTGAMTOT  BCD*10.3  Total Retainage Amount   
RTGDATEDUE  Date  Retainage Due Date   
RTGAMTOVER  Boolean  Retainage Amount Overridden  List: 2 entries
0=No
1=Yes
RTGDDTOVER  Boolean  Retainage Due Date Overridden  List: 2 entries
0=No
1=Yes
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   
PMTRANSNUM  Long  PJC Transaction Number   
TRCURRENCY  String*3  Tax Reporting Currency  Mask: %-3N
EXRATERC  BCD*8.7  Tax Reporting Exchange Rate   
RATEDATERC  Date  Tax Reporting Rate Date   
RATETYPERC  String*2  Tax Reporting Rate Type  Mask: %-2N
RATEOPERRC  Integer  Tax Reporting Rate Operation  List: 2 entries
1=*
2=/
RATERCOVER  Boolean  Tax Reporting Rate Overridden  List: 2 entries
0=No
1=Yes
RCURNDECML  Integer  Tax Reporting Decimal Places   
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   
FCAPAMOUNT  BCD*10.3  Func. A/P Amount   
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   
RFAPALLO  BCD*10.3  Func. A/P Retainage Tax Allocd.   
RFAPEXPS  BCD*10.3  Func. A/P Retainage Tax Expensed   
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 2009-Nov-19

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