# View: Credit/Debit Note Audit Lines

RotoID: PO0305
Table: POCRNAL
DLL: POCRNAL

## Compositions: 2

RotoID | Table | Title | DLL
--- | --- | --- | ---
PO0304 | POCRNAH | Credit/Debit Note Audit Headers | POCRNAH
PO0332 | POCRALO | CR/DR Note Audit Line Opt. Flds | POCRALO

## Keys: 1

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

## 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 |
CRNALSEQ | 3 | BCD*10.0 | Line Number | E A K R |
TRANSTYPE | 4 | Integer | Transaction Type | E A |
OEONUMBER | 5 | String*22 | Order Number | E A | Mask: %-22C
ITEMEXISTS | 6 | Boolean | Item Exists | E A | List: 2 entries
0 | = | No
1 | = | Yes
ITEMNO | 7 | String*24 | Item Number | E A | Mask: %-24C
LOCATION | 8 | String*6 | Location | E A | Mask: %-6N
ITEMDESC | 9 | String*60 | Item Description | E A |
CNTLACCT | 10 | String*6 | Control Account | E A |
TAXCLASS1 | 11 | Integer | Tax Class 1 | E A |
TAXCLASS2 | 12 | Integer | Tax Class 2 | E A |
TAXCLASS3 | 13 | Integer | Tax Class 3 | E A |
TAXCLASS4 | 14 | Integer | Tax Class 4 | E A |
TAXCLASS5 | 15 | Integer | Tax Class 5 | E A |
RQRETURNED | 16 | BCD*10.4 | Quantity Returned | E A |
RETUNIT | 17 | String*10 | Unit of Measure | E A | Mask: %-10c
CONVERSION | 18 | BCD*10.6 | Conversion Factor to Stocking | E A |
COSTCONV | 19 | BCD*10.6 | Cost unit conversion | E A |
SQRETURNED | 20 | BCD*10.4 | (S) Quantity Returned | E A |
STOCKUNIT | 21 | String*10 | Unit of Measure | E A | Mask: %-10c
COSTUNIT | 22 | String*10 | Costing unit of measure | E A | Mask: %-10c
UNITCOST | 23 | BCD*10.6 | Unit Cost | E A |
PRUNITCOST | 24 | BCD*10.6 | Unit Cost | E A |
LOADEDCOST | 25 | BCD*10.6 | Fully-loaded cost | E A |
FCEXTENDED | 26 | BCD*10.3 | (FC) Extended Amount | E A |
SCEXTENDED | 27 | BCD*10.3 | Extended Amount | E A |
FCBASEALLO | 28 | BCD*10.3 | (FC) Base to Allocate | E A |
SCBASEALLO | 29 | BCD*10.3 | Base to Allocate | E A |
FCTAXALLO | 30 | BCD*10.3 | (FC) Total Tax Allocated | E A |
SCTAXALLO | 31 | BCD*10.3 | Total Tax Allocated | E A |
FCPRORATED | 32 | BCD*10.3 | (FC) Total Prorate Allocated | E A |
SCPRORATED | 33 | BCD*10.3 | Total Prorate Allocated | E A |
FCTAXINCL | 34 | BCD*10.3 | (FC) Tax Included in Price | E A |
SCTAXINCL | 35 | BCD*10.3 | Tax Included in Price | E A |
FCTAXEXCL | 36 | BCD*10.3 | (FC) Tax Excluded from Price | E A |
SCTAXEXCL | 37 | BCD*10.3 | Tax Excluded from Price | E A |
TAXBASE1 | 38 | BCD*10.3 | Tax Base 1 | E A |
TAXBASE2 | 39 | BCD*10.3 | Tax Base 2 | E A |
TAXBASE3 | 40 | BCD*10.3 | Tax Base 3 | E A |
TAXBASE4 | 41 | BCD*10.3 | Tax Base 4 | E A |
TAXBASE5 | 42 | BCD*10.3 | Tax Base 5 | E A |
TAXINCLUD1 | 43 | Boolean | Tax Includable 1 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD2 | 44 | Boolean | Tax Includable 2 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD3 | 45 | Boolean | Tax Includable 3 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD4 | 46 | Boolean | Tax Includable 4 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXINCLUD5 | 47 | Boolean | Tax Includable 5 | E A | List: 2 entries
0 | = | No
1 | = | Yes
TAXAMOUNT1 | 48 | BCD*10.3 | Tax Amount 1 | E A |
TAXAMOUNT2 | 49 | BCD*10.3 | Tax Amount 2 | E A |
TAXAMOUNT3 | 50 | BCD*10.3 | Tax Amount 3 | E A |
TAXAMOUNT4 | 51 | BCD*10.3 | Tax Amount 4 | E A |
TAXAMOUNT5 | 52 | BCD*10.3 | Tax Amount 5 | E A |
TXRECVAMT1 | 53 | BCD*10.3 | Tax Recoverable Amount 1 | E A |
TXRECVAMT2 | 54 | BCD*10.3 | Tax Recoverable Amount 2 | E A |
TXRECVAMT3 | 55 | BCD*10.3 | Tax Recoverable Amount 3 | E A |
TXRECVAMT4 | 56 | BCD*10.3 | Tax Recoverable Amount 4 | E A |
TXRECVAMT5 | 57 | BCD*10.3 | Tax Recoverable Amount 5 | E A |
TXEXPSAMT1 | 58 | BCD*10.3 | Tax Expense Amount 1 | E A |
TXEXPSAMT2 | 59 | BCD*10.3 | Tax Expense Amount 2 | E A |
TXEXPSAMT3 | 60 | BCD*10.3 | Tax Expense Amount 3 | E A |
TXEXPSAMT4 | 61 | BCD*10.3 | Tax Expense Amount 4 | E A |
TXEXPSAMT5 | 62 | BCD*10.3 | Tax Expense Amount 5 | E A |
GLCLEARING | 63 | String*45 | Receipt Clearing Account | E A | Mask: %-45C
GLITEM | 64 | String*45 | G/L Item | E A | Mask: %-45C
GLISPOSTED | 65 | Boolean | G/L data to be posted? | E A | List: 2 entries
0 | = | No
1 | = | Yes
GLISDEBIT | 66 | Boolean | Normal G/L debit convention? | E A | List: 2 entries
0 | = | No
1 | = | Yes
RQRETTOTAL | 67 | BCD*10.4 | Total Quantity Returned | E A |
SQRETTOTAL | 68 | BCD*10.4 | Total Stock Quantity Returned | E A |
FCEXTTOTAL | 69 | BCD*10.3 | Total Cost (Functional) | E A |
SCEXTTOTAL | 70 | BCD*10.3 | Total Cost | E A |
STOCKITEM | 71 | Boolean | Stock Item | E A | List: 2 entries
0 | = | No
1 | = | Yes
PONUMBER | 72 | String*22 | Purchase Order Number | E A | Mask: %-22C
RCPNUMBER | 73 | String*22 | Receipt Number | E A | Mask: %-22C
DISCPCT | 74 | BCD*5.5 | Discount Percentage | E A |
FCDISCOUNT | 75 | BCD*10.3 | (FC) Discount Amount | E A |
SCDISCOUNT | 76 | BCD*10.3 | Discount Amount | E A |
FCDISCTOT | 77 | BCD*10.3 | Total Discount (Functional) | E A |
SCDISCTOT | 78 | BCD*10.3 | Total Discount | E A |
VALUES | 79 | Long | Optional Fields | E A C |
RCPLSEQ | 80 | BCD*10.0 | Receipt Line Sequence | E A |
RETLSEQ | 81 | BCD*10.0 | Return Line Sequence | E A |
INVLSEQ | 82 | BCD*10.0 | Invoice Line Sequence | E A |
CRNLSEQ | 83 | BCD*10.0 | Credit/Debit Note Line Sequence | E A |
FCTAXRECV | 84 | BCD*10.3 | (FC) Total Tax Recoverable | E A |
SCTAXRECV | 85 | BCD*10.3 | Total Tax Recoverable | E A |
FCTAXEXPS | 86 | BCD*10.3 | (FC) Total Tax Expensed | E A |
SCTAXEXPS | 87 | BCD*10.3 | Total Tax Expensed | E A |
FCTAXAMT1 | 88 | BCD*10.3 | (FC) Tax Amount 1 | E A |
FCTAXAMT2 | 89 | BCD*10.3 | (FC) Tax Amount 2 | E A |
FCTAXAMT3 | 90 | BCD*10.3 | (FC) Tax Amount 3 | E A |
FCTAXAMT4 | 91 | BCD*10.3 | (FC) Tax Amount 4 | E A |
FCTAXAMT5 | 92 | BCD*10.3 | (FC) Tax Amount 5 | E A |
COMMENT | 93 | String*250 | Comment | E A |
CONTRACT | 94 | String*16 | Contract | E A | Mask: %-16C
PROJECT | 95 | String*16 | Project | E A | Mask: %-16N
CCATEGORY | 96 | String*16 | (Cost) Category | E A | Mask: %-16N
COSTCLASS | 97 | Integer | Cost Class | E A | List: 7 entries
0 | = |
1 | = | Labor
2 | = | Material
3 | = | Equipment
4 | = | Subcontractor
5 | = | Overhead
6 | = | Miscellaneous
BILLTYPE | 98 | Integer | Billing Type | E A | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
BILLRATE | 99 | BCD*10.6 | Billing Rate | E A |
BILLCURR | 100 | String*3 | Billing Currency | E A | Mask: %-3N
ARITEMNO | 101 | String*16 | A/R Item Number | E A | Mask: %-16C
ARUNIT | 102 | String*10 | A/R Unit of Measure | E A | Mask: %-10C
RTGPERCENT | 103 | BCD*5.5 | Retainage Percentage | E A |
RTGDAYS | 104 | Integer | Retention Period | E A |
SCRTGAMT | 105 | BCD*10.3 | Retainage Amount | E A |
FCRTGAMTOT | 106 | BCD*10.3 | (FC) Total Retainage Amount | E A |
SCRTGAMTOT | 107 | BCD*10.3 | Total Retainage Amount | E A |
RTGDATEDUE | 108 | Date | Retainage Due Date | E A |
RTGAMTOVER | 109 | Boolean | Retainage Amount Overridden | E A | List: 2 entries
0 | = | No
1 | = | Yes
RTGDDTOVER | 110 | Boolean | Retainage Due Date Overridden | E A | List: 2 entries
0 | = | No
1 | = | Yes
GLOVERHEAD | 111 | String*45 | Overhead Account | E A | Mask: %-45C
GLLABOR | 112 | String*45 | Labor Burden Account | E A | Mask: %-45C
FCOVRHDAMT | 113 | BCD*10.3 | (FC) Overhead Amount | E A |
SCOVRHDAMT | 114 | BCD*10.3 | Overhead Amount | E A |
FCLABORAMT | 115 | BCD*10.3 | (FC) Labor Burden Amount | E A |
SCLABORAMT | 116 | BCD*10.3 | Labor Burden Amount | E A |
DFCUNITCST | 117 | BCD*10.6 | (FC) Unit Cost Difference | E A |
DSCUNITCST | 118 | BCD*10.6 | Unit Cost Difference | E A |
DBILLRATE | 119 | BCD*10.6 | Billing Rate Difference | 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.