# View: CR/DR Note Audit Costs

RotoID: PO0307
Table: POCRNAS
DLL: POCRNAS

## Compositions: 2

RotoID | Table | Title | DLL
--- | --- | --- | ---
PO0304 | POCRNAH | Credit/Debit Note Audit Headers | POCRNAH
PO0333 | POCRASO | CR/DR Note Audit Cost Opt. Flds | POCRASO

## Keys: 1

Title | Fields
--- | ---
Detail Key | DAYENDSEQ, CRNAHSEQ, CRNASSEQ

## Fields: 120

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
DAYENDSEQ | 1 | BCD*10.0 | Day End Number | E A K R |
CRNAHSEQ | 2 | BCD*10.0 | Processing Sequence | E A K R |
CRNASSEQ | 3 | BCD*10.0 | Cost Number | E A K R |
TRANSTYPE | 4 | Integer | Transaction Type | E A |
INVNUMBER | 5 | String*22 | Invoice Number | E A | Mask: %-22C
PONUMBER | 6 | String*22 | Purchase Order Number | E A | Mask: %-22C
RCPNUMBER | 7 | String*22 | Receipt Number | E A | Mask: %-22C
CRNNUMBER | 8 | String*22 | Credit/Debit Note Number | E A | Mask: %-22C
ADDCOST | 9 | String*6 | Additional Cost | E A | Mask: %-6N
DESCRIPTIO | 10 | String*60 | Description | E A |
PRORMETHOD | 11 | Integer | Proration Method | E A | List: 5 entries
1 | = | No Proration
2 | = | Prorate by Quantity
3 | = | Prorate by Cost
4 | = | Prorate by Weight
5 | = | Prorate Manually
REPRORATE | 12 | Integer | Reproration Method | E A | List: 3 entries
1 | = | Leave
2 | = | Prorate
3 | = | Expense
VENDOR | 13 | String*12 | Vendor | E A | Mask: %-12C
VENDORNAME | 14 | String*60 | Name | E A |
TAXGROUP | 15 | String*12 | Tax Group | E A | Mask: %-12N
TAXAUTH1 | 16 | String*12 | Tax Authority 1 | E A |
TAXAUTH2 | 17 | String*12 | Tax Authority 2 | E A |
TAXAUTH3 | 18 | String*12 | Tax Authority 3 | E A |
TAXAUTH4 | 19 | String*12 | Tax Authority 4 | E A |
TAXAUTH5 | 20 | String*12 | Tax Authority 5 | E A |
TAXVCLASS1 | 21 | Integer | Vendor Tax Class 1 | E A |
TAXVCLASS2 | 22 | Integer | Vendor Tax Class 2 | E A |
TAXVCLASS3 | 23 | Integer | Vendor Tax Class 3 | E A |
TAXVCLASS4 | 24 | Integer | Vendor Tax Class 4 | E A |
TAXVCLASS5 | 25 | Integer | Vendor Tax Class 5 | E A |
TAXICLASS1 | 26 | Integer | Cost Tax Class 1 | E A |
TAXICLASS2 | 27 | Integer | Cost Tax Class 2 | E A |
TAXICLASS3 | 28 | Integer | Cost Tax Class 3 | E A |
TAXICLASS4 | 29 | Integer | Cost Tax Class 4 | E A |
TAXICLASS5 | 30 | Integer | Cost Tax Class 5 | E A |
CURRENCY | 31 | String*3 | Currency | E A | Mask: %-3N
EXRATE | 32 | BCD*8.7 | Exchange Rate | E A |
RATEDATE | 33 | Date | Rate Date | E A |
RATETYPE | 34 | String*2 | Rate Type | E A | Mask: %-2N
RATEOPER | 35 | Integer | Rate Operation | E A | List: 2 entries
1 | = | *
2 | = | /
RATEOVER | 36 | Boolean | Rate Overridden | E A | List: 2 entries
0 | = | No
1 | = | Yes
SCURNDECML | 37 | Integer | Decimal Places | E A |
GLEXPACCT | 38 | String*45 | Expense Account | E A | Mask: %-45C
GLRETACCT | 39 | String*45 | Return Account | E A | Mask: %-45C
FCAMOUNT | 40 | BCD*10.3 | Conversion Functional Amount | E A |
SCAMOUNT | 41 | BCD*10.3 | Conversion Source Amount | E A |
FCBASEALLO | 42 | BCD*10.3 | (FC) Base to Allocate | E A |
SCBASEALLO | 43 | BCD*10.3 | Base to Allocate | E A |
FCTAXALLO | 44 | BCD*10.3 | (FC) Total Tax Allocated | E A |
SCTAXALLO | 45 | BCD*10.3 | Total Tax Allocated | E A |
FCTAXINCL | 46 | BCD*10.3 | (FC) Tax Included in Price | E A |
SCTAXINCL | 47 | BCD*10.3 | Tax Included in Price | E A |
FCTAXEXCL | 48 | BCD*10.3 | (FC) Tax Excluded from Price | E A |
SCTAXEXCL | 49 | BCD*10.3 | Tax Excluded from Price | E A |
TAXBASE1 | 50 | BCD*10.3 | Tax Base 1 | E A |
TAXBASE2 | 51 | BCD*10.3 | Tax Base 2 | E A |
TAXBASE3 | 52 | BCD*10.3 | Tax Base 3 | E A |
TAXBASE4 | 53 | BCD*10.3 | Tax Base 4 | E A |
TAXBASE5 | 54 | BCD*10.3 | Tax Base 5 | E A |
TAXINCLUD1 | 55 | Boolean | Tax Includable 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD2 | 56 | Boolean | Tax Includable 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD3 | 57 | Boolean | Tax Includable 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD4 | 58 | Boolean | Tax Includable 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD5 | 59 | Boolean | Tax Includable 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXAMOUNT1 | 60 | BCD*10.3 | Tax Amount 1 | E A |
TAXAMOUNT2 | 61 | BCD*10.3 | Tax Amount 2 | E A |
TAXAMOUNT3 | 62 | BCD*10.3 | Tax Amount 3 | E A |
TAXAMOUNT4 | 63 | BCD*10.3 | Tax Amount 4 | E A |
TAXAMOUNT5 | 64 | BCD*10.3 | Tax Amount 5 | E A |
TXRECVAMT1 | 65 | BCD*10.3 | Tax Recoverable Amount 1 | E A |
TXRECVAMT2 | 66 | BCD*10.3 | Tax Recoverable Amount 2 | E A |
TXRECVAMT3 | 67 | BCD*10.3 | Tax Recoverable Amount 3 | E A |
TXRECVAMT4 | 68 | BCD*10.3 | Tax Recoverable Amount 4 | E A |
TXRECVAMT5 | 69 | BCD*10.3 | Tax Recoverable Amount 5 | E A |
TXEXPSAMT1 | 70 | BCD*10.3 | Tax Expense Amount 1 | E A |
TXEXPSAMT2 | 71 | BCD*10.3 | Tax Expense Amount 2 | E A |
TXEXPSAMT3 | 72 | BCD*10.3 | Tax Expense Amount 3 | E A |
TXEXPSAMT4 | 73 | BCD*10.3 | Tax Expense Amount 4 | E A |
TXEXPSAMT5 | 74 | BCD*10.3 | Tax Expense Amount 5 | E A |
INVSSEQG | 75 | BCD*10.0 | Invoice Cost Group Sequence | E A |
VALUES | 76 | Long | Optional Fields | E A C |
RCPSSEQ | 77 | BCD*10.0 | Receipt Cost Sequence | E A |
INVSSEQ | 78 | BCD*10.0 | Invoice Cost Sequence | E A |
CRNSSEQ | 79 | BCD*10.0 | Credit/Debit Note Cost Sequence | E A |
FCTAXRECV | 80 | BCD*10.3 | (FC) Total Tax Recoverable | E A |
SCTAXRECV | 81 | BCD*10.3 | Total Tax Recoverable | E A |
FCTAXEXPS | 82 | BCD*10.3 | (FC) Total Tax Expensed | E A |
SCTAXEXPS | 83 | BCD*10.3 | Total Tax Expensed | E A |
FCTAXAMT1 | 84 | BCD*10.3 | (FC) Tax Amount 1 | E A |
FCTAXAMT2 | 85 | BCD*10.3 | (FC) Tax Amount 2 | E A |
FCTAXAMT3 | 86 | BCD*10.3 | (FC) Tax Amount 3 | E A |
FCTAXAMT4 | 87 | BCD*10.3 | (FC) Tax Amount 4 | E A |
FCTAXAMT5 | 88 | BCD*10.3 | (FC) Tax Amount 5 | E A |
GLNOPRORCR | 89 | String*45 | Expensed Add'l Cost Clr. Acct. | E A | Mask: %-45C
NOPRORTOGL | 90 | Boolean | Exp. Add'l Cost G/L data posted? | E A | List: 2 entries
0 | = | No
1 | = | Yes
COMMENT | 91 | String*250 | Comment | E A |
CONTRACT | 92 | String*16 | Contract | E A | Mask: %-16C
PROJECT | 93 | String*16 | Project | E A | Mask: %-16N
CCATEGORY | 94 | String*16 | (Cost) Category | E A | Mask: %-16N
COSTCLASS | 95 | Integer | Cost Class | E A | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
RESOURCE | 96 | String*24 | Resource | E A | Mask: %-24C
BILLTYPE | 97 | Integer | Billing Type | E A | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | 98 | BCD*10.6 | Billing Rate | E A |
BILLCURR | 99 | String*3 | Billing Currency | E A | Mask: %-3N
ARITEMNO | 100 | String*16 | A/R Item Number | E A | Mask: %-16C
ARUNIT | 101 | String*10 | A/R Unit of Measure | E A | Mask: %-10C
CALCOVRHD | 102 | Boolean | Calculate Overhead | E A | List: 2 entries
0 | = | No
1 | = | Yes
CALCLABOR | 103 | Boolean | Calculate Labor | E A | List: 2 entries
0 | = | No
1 | = | Yes
HASRTG | 104 | Boolean | Has Retainage | E A | List: 2 entries
0 | = | No
1 | = | Yes
RTGRATE | 105 | Integer | Retainage Exchange Rate | E A | List: 2 entries
0 | = | Use Original Document Exchange Rate
1 | = | Use Current Exchange Rate
RTGPERCENT | 106 | BCD*5.5 | Retainage Percentage | E A |
RTGDAYS | 107 | Integer | Retention Period | E A |
SCRTGAMT | 108 | BCD*10.3 | Retainage Amount | E A |
FCRTGAMTOT | 109 | BCD*10.3 | (FC) Total Retainage Amount | E A |
SCRTGAMTOT | 110 | BCD*10.3 | Total Retainage Amount | E A |
RTGDATEDUE | 111 | Date | Retainage Due Date | E A |
RTGAMTOVER | 112 | Boolean | Retainage Amount Overridden | E A | List: 2 entries
0 | = | No
1 | = | Yes
RTGDDTOVER | 113 | Boolean | Retainage Due Date Overridden | E A | List: 2 entries
0 | = | No
1 | = | Yes
GLOVERHEAD | 114 | String*45 | Overhead Account | E A | Mask: %-45C
GLLABOR | 115 | String*45 | Labor Burden Account | E A | Mask: %-45C
FCOVRHDAMT | 116 | BCD*10.3 | (FC) Overhead Amount | E A |
SCOVRHDAMT | 117 | BCD*10.3 | Overhead Amount | E A |
FCLABORAMT | 118 | BCD*10.3 | (FC) Labor Burden Amount | E A |
SCLABORAMT | 119 | BCD*10.3 | Labor Burden Amount | E A |
PMTRANSNUM | 120 | Long | PJC Transaction Number | E A |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.