View: Credit/Debit Note Audit Lines

RotoID: PO0305
Table: POCRNAL
Protocol: Detail
DLL:POCRNAL

Compositions: 2

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

Keys: 2

Title Fields
Detail Key DAYENDSEQ, CRNAHSEQ, CRNALSEQ
Detail Number DAYENDSEQ, CRNAHSEQ, DETAILNUM, CRNALSEQ

Fields: 143

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 Stocking 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 Func. Extended Amount E A 
SCEXTENDED 27 BCD*10.3 Extended Amount E A 
FCBASEALLO 28 BCD*10.3 Func. Base to Allocate E A 
SCBASEALLO 29 BCD*10.3 Base to Allocate E A 
FCTAXALLO 30 BCD*10.3 Func. Total Tax Allocated E A 
SCTAXALLO 31 BCD*10.3 Total Tax Allocated E A 
FCPRORATED 32 BCD*10.3 Func. Total Prorate Allocated E A 
SCPRORATED 33 BCD*10.3 Total Prorate Allocated E A 
FCTAXINCL 34 BCD*10.3 Func. Tax Included in Price E A 
SCTAXINCL 35 BCD*10.3 Tax Included in Price E A 
FCTAXEXCL 36 BCD*10.3 Func. 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 Functional Total Cost 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 Func. Discount Amount E A 
SCDISCOUNT 76 BCD*10.3 Discount Amount E A 
FCDISCTOT 77 BCD*10.3 Functional Total Discount 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 Func. Total Tax Recoverable E A 
SCTAXRECV 85 BCD*10.3 Total Tax Recoverable E A 
FCTAXEXPS 86 BCD*10.3 Func. Total Tax Expensed E A 
SCTAXEXPS 87 BCD*10.3 Total Tax Expensed E A 
FCTAXAMT1 88 BCD*10.3 Func. Tax Amount 1 E A 
FCTAXAMT2 89 BCD*10.3 Func. Tax Amount 2 E A 
FCTAXAMT3 90 BCD*10.3 Func. Tax Amount 3 E A 
FCTAXAMT4 91 BCD*10.3 Func. Tax Amount 4 E A 
FCTAXAMT5 92 BCD*10.3 Func. 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 Func. 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 Func. Overhead Amount E A 
SCOVRHDAMT 114 BCD*10.3 Overhead Amount E A 
FCLABORAMT 115 BCD*10.3 Func. Labor Burden Amount E A 
SCLABORAMT 116 BCD*10.3 Labor Burden Amount E A 
DFCUNITCST 117 BCD*10.6 Func. 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 
RCTAXALLO 121 BCD*10.3 Rptg. Total Tax Allocated E A 
RCTAXRECV 122 BCD*10.3 Rptg. Total Tax Recoverable E A 
RCTAXEXPS 123 BCD*10.3 Rptg. Total Tax Expensed E A 
RCTAXINCL 124 BCD*10.3 Rptg. Total Tax Included E A 
TARAMOUNT1 125 BCD*10.3 Tax Reporting Amount 1 E A 
TARAMOUNT2 126 BCD*10.3 Tax Reporting Amount 2 E A 
TARAMOUNT3 127 BCD*10.3 Tax Reporting Amount 3 E A 
TARAMOUNT4 128 BCD*10.3 Tax Reporting Amount 4 E A 
TARAMOUNT5 129 BCD*10.3 Tax Reporting Amount 5 E A 
SCRAXALLO 130 BCD*10.3 Total Rtg. Tax Allocated E A 
FCRAXALLO 131 BCD*10.3 Func. Total Rtg. Tax Allocated E A 
SCRAXEXPS 132 BCD*10.3 Total Rtg. Tax Expensed E A 
FCRAXEXPS 133 BCD*10.3 Func. Total Rtg. Tax Expensed E A 
RFAPALLO 134 BCD*10.3 Func. A/P Retainage Tax Allocd. E A 
RFAPEXPS 135 BCD*10.3 Func. A/P Retainage Tax Expensed E A 
RFAPAMT1 136 BCD*10.3 Func. A/P Retainage Tax Amount 1 E A 
RFAPAMT2 137 BCD*10.3 Func. A/P Retainage Tax Amount 2 E A 
RFAPAMT3 138 BCD*10.3 Func. A/P Retainage Tax Amount 3 E A 
RFAPAMT4 139 BCD*10.3 Func. A/P Retainage Tax Amount 4 E A 
RFAPAMT5 140 BCD*10.3 Func. A/P Retainage Tax Amount 5 E A 
DEFEXTWGHT 141 BCD*10.4 Default Extended Weight E A 
TOTDEFEXWT 142 BCD*10.4 Total Def. Ext. Weight E A 
DETAILNUM 143 Integer Detail Number E A 

This page was generated on 2022-Aug-18

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