View: Credit/Debit Note Lines

RotoID: PO0315
Table: POCRNL
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:POCRNL

Compositions: 8

RotoID Tables Title DLL
PO0311 POCRNH1POCRNH2 Credit/Debit Notes POCRNH
PO0309 POCRNC Credit/Debit Note Comments POCRNC
PO0310 Credit/Debit Note Functions POCRNG
PO0312 POCRNI Credit/Debit Note Postings POCRNI
PO0316 POCRNM Credit/Debit Note Posting Lines POCRNM
PO0318 POCRNLO CR/DR Note Line Optional Fields POCRNLO
PO0829 POCRNLL Credit/Debit Note Line Lots POCRNLL
PO0820 POCRNLS Credit/Debit Note Line Serials POCRNLS

Keys: 6

Title Fields
Detail Key CRNHSEQ, CRNLREV
Sequence Key CRNHSEQ, CRNLSEQ
Invoice Line Sequence Key INVLSEQ
Return Line Sequence Key RETLSEQ
Receipt Line Sequence Key RCPLSEQ
Detail Number CRNHSEQ, DETAILNUM, CRNLSEQ

Fields: 249

Field Index Type Title Attributes Presentation
CRNHSEQ 1 BCD*10.0 Credit/Debit Note Sequence Key E A K R 
CRNLREV 2 BCD*10.0 Line Number E A K R 
CRNLSEQ 3 BCD*10.0 Credit/Debit Note Line Sequence E A X 
CRNCSEQ 4 BCD*10.0 CR/DR Note Comment Sequence A X 
OEONUMBER 5 String*22 Order Number A X  Mask: %-22C
INDBTABLE 6 Boolean Stored in Database Table A C X  List:2 entries
0 = No
1 = Yes
COMPLETION 7 Integer Completion Status A X  List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE 8 Date Date Completed A X 
RCPHSEQ 9 BCD*10.0 Receipt Sequence Key A X 
RCPLSEQ 10 BCD*10.0 Receipt Line Sequence A X 
RETHSEQ 11 BCD*10.0 Return Sequence Key A X 
RETLSEQ 12 BCD*10.0 Return Line Sequence A X 
INVHSEQ 13 BCD*10.0 Invoice Sequence Key A X 
INVLSEQ 14 BCD*10.0 Invoice Line Sequence A X 
ITEMEXISTS 15 Boolean Item Exists A C X  List:2 entries
0 = No
1 = Yes
ITEMNO 16 String*24 Item Number A P X  Mask: %-24C
LOCATION 17 String*6 Location A X  Mask: %-6N
ITEMDESC 18 String*60 Item Description A X 
VENDITEMNO 19 String*24 Vendor Item Number A X 
HASCOMMENT 20 Boolean Comments A X  List:2 entries
0 = No
1 = Yes
RETUNIT 21 String*10 Unit of Measure A X  Mask: %-10c
RETCONV 22 BCD*10.6 Returning Conversion Factor A C X 
RETDECML 23 Integer Returning Unit Decimals A C X 
STOCKDECML 24 Integer Stock Unit Decimals A C X 
RQRETURNED 25 BCD*10.4 Quantity A X 
SQRETURNED 26 BCD*10.4 Stocking Quantity Returned A C X 
UNITWEIGHT 27 BCD*10.4 Unit Weight A X 
EXTWEIGHT 28 BCD*10.4 Extended Weight A X 
UNITCOST 29 BCD*10.6 Unit Cost A X 
EXTENDED 30 BCD*10.3 Extended Cost A X 
TAXBASE1 31 BCD*10.3 Tax Base 1 A X 
TAXBASE2 32 BCD*10.3 Tax Base 2 A X 
TAXBASE3 33 BCD*10.3 Tax Base 3 A X 
TAXBASE4 34 BCD*10.3 Tax Base 4 A X 
TAXBASE5 35 BCD*10.3 Tax Base 5 A X 
TAXCLASS1 36 Integer Tax Class 1 A X 
TAXCLASS2 37 Integer Tax Class 2 A X 
TAXCLASS3 38 Integer Tax Class 3 A X 
TAXCLASS4 39 Integer Tax Class 4 A X 
TAXCLASS5 40 Integer Tax Class 5 A X 
TAXRATE1 41 BCD*8.5 Tax Rate 1 A X 
TAXRATE2 42 BCD*8.5 Tax Rate 2 A X 
TAXRATE3 43 BCD*8.5 Tax Rate 3 A X 
TAXRATE4 44 BCD*8.5 Tax Rate 4 A X 
TAXRATE5 45 BCD*8.5 Tax Rate 5 A X 
TAXINCLUD1 46 Boolean Tax Includable 1 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 47 Boolean Tax Includable 2 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 48 Boolean Tax Includable 3 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 49 Boolean Tax Includable 4 A X  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 50 Boolean Tax Includable 5 A X  List:2 entries
0 = No
1 = Yes
TAXAMOUNT1 51 BCD*10.3 Tax Amount 1 A X 
TAXAMOUNT2 52 BCD*10.3 Tax Amount 2 A X 
TAXAMOUNT3 53 BCD*10.3 Tax Amount 3 A X 
TAXAMOUNT4 54 BCD*10.3 Tax Amount 4 A X 
TAXAMOUNT5 55 BCD*10.3 Tax Amount 5 A X 
TXALLOAMT1 56 BCD*10.3 Tax Allocated Amount 1 A X 
TXALLOAMT2 57 BCD*10.3 Tax Allocated Amount 2 A X 
TXALLOAMT3 58 BCD*10.3 Tax Allocated Amount 3 A X 
TXALLOAMT4 59 BCD*10.3 Tax Allocated Amount 4 A X 
TXALLOAMT5 60 BCD*10.3 Tax Allocated Amount 5 A X 
TXRECVAMT1 61 BCD*10.3 Tax Recoverable Amount 1 A X 
TXRECVAMT2 62 BCD*10.3 Tax Recoverable Amount 2 A X 
TXRECVAMT3 63 BCD*10.3 Tax Recoverable Amount 3 A X 
TXRECVAMT4 64 BCD*10.3 Tax Recoverable Amount 4 A X 
TXRECVAMT5 65 BCD*10.3 Tax Recoverable Amount 5 A X 
TXEXPSAMT1 66 BCD*10.3 Tax Expense Amount 1 A X 
TXEXPSAMT2 67 BCD*10.3 Tax Expense Amount 2 A X 
TXEXPSAMT3 68 BCD*10.3 Tax Expense Amount 3 A X 
TXEXPSAMT4 69 BCD*10.3 Tax Expense Amount 4 A X 
TXEXPSAMT5 70 BCD*10.3 Tax Expense Amount 5 A X 
TXBASEALLO 71 BCD*10.3 Net of Tax A X 
TXINCLUDED 72 BCD*10.3 Tax Included A C X 
TXEXCLUDED 73 BCD*10.3 Tax Excluded A C X 
TAXAMOUNT 74 BCD*10.3 Total Tax A C X 
TXRECVAMT 75 BCD*10.3 Recoverable Tax A X 
TXEXPSAMT 76 BCD*10.3 Expensed Tax A X 
TXALLOAMT 77 BCD*10.3 Allocated Tax A X 
TFBASEALLO 78 BCD*10.3 Func. Net of Tax A C X 
TFINCLUDE1 79 BCD*10.3 Func. Tax Included Amount 1 A C X 
TFINCLUDE2 80 BCD*10.3 Func. Tax Included Amount 2 A C X 
TFINCLUDE3 81 BCD*10.3 Func. Tax Included Amount 3 A C X 
TFINCLUDE4 82 BCD*10.3 Func. Tax Included Amount 4 A C X 
TFINCLUDE5 83 BCD*10.3 Func. Tax Included Amount 5 A C X 
TFALLOAMT1 84 BCD*10.3 Func. Tax Allocated Amount 1 A C X 
TFALLOAMT2 85 BCD*10.3 Func. Tax Allocated Amount 2 A C X 
TFALLOAMT3 86 BCD*10.3 Func. Tax Allocated Amount 3 A C X 
TFALLOAMT4 87 BCD*10.3 Func. Tax Allocated Amount 4 A C X 
TFALLOAMT5 88 BCD*10.3 Func. Tax Allocated Amount 5 A C X 
TFRECVAMT1 89 BCD*10.3 Func. Tax Recoverable Amount 1 A C X 
TFRECVAMT2 90 BCD*10.3 Func. Tax Recoverable Amount 2 A C X 
TFRECVAMT3 91 BCD*10.3 Func. Tax Recoverable Amount 3 A C X 
TFRECVAMT4 92 BCD*10.3 Func. Tax Recoverable Amount 4 A C X 
TFRECVAMT5 93 BCD*10.3 Func. Tax Recoverable Amount 5 A C X 
TFEXPSAMT1 94 BCD*10.3 Func. Tax Expense Amount 1 A C X 
TFEXPSAMT2 95 BCD*10.3 Func. Tax Expense Amount 2 A C X 
TFEXPSAMT3 96 BCD*10.3 Func. Tax Expense Amount 3 A C X 
TFEXPSAMT4 97 BCD*10.3 Func. Tax Expense Amount 4 A C X 
TFEXPSAMT5 98 BCD*10.3 Func. Tax Expense Amount 5 A C X 
FCEXTENDED 99 BCD*10.3 Func. Extended Amount A C X 
GLACEXPENS 100 String*45 Expense Account A X  Mask: %-45C
MPRORATED 101 BCD*10.3 Manual Proration A X 
STOCKITEM 102 Boolean Stock Item A C X  List:2 entries
0 = No
1 = Yes
RCPNUMBER 103 String*22 Receipt Number A X  Mask: %-22C
PORHSEQ 104 BCD*10.0 Purchase Order Sequence Key A X 
PORLSEQ 105 BCD*10.0 Purchase Order Line Sequence A X 
PONUMBER 106 String*22 Purchase Order Number A X  Mask: %-22C
GLNONSTKCR 107 String*45 Non-Stock Clearing Account A X  Mask: %-45C
MANITEMNO 108 String*24 Manufacturer's Item Number A X  Mask: %-24C
DISCPCT 109 BCD*5.5 Discount Percentage A X 
DISCOUNT 110 BCD*10.3 Discount Amount A X 
DISCOUNTF 111 BCD*10.3 Func. Discount Amount A X 
VALUES 112 Long Optional Fields A C X 
FIRST 121 Integer (first) A X 
TAXCLASS1D 122 String*60 Tax Class 1 Description A C X 
TAXCLASS2D 123 String*60 Tax Class 2 Description A C X 
TAXCLASS3D 124 String*60 Tax Class 3 Description A C X 
TAXCLASS4D 125 String*60 Tax Class 4 Description A C X 
TAXCLASS5D 126 String*60 Tax Class 5 Description A C X 
GLACEXPNSD 127 String*60 Expense Account Description A C X 
TXINCLUDE1 128 BCD*10.3 Included Tax Amount 1 A X 
TXINCLUDE2 129 BCD*10.3 Included Tax Amount 2 A X 
TXINCLUDE3 130 BCD*10.3 Included Tax Amount 3 A X 
TXINCLUDE4 131 BCD*10.3 Included Tax Amount 4 A X 
TXINCLUDE5 132 BCD*10.3 Included Tax Amount 5 A X 
TXEXCLUDE1 133 BCD*10.3 Excluded Tax Amount 1 A X 
TXEXCLUDE2 134 BCD*10.3 Excluded Tax Amount 2 A X 
TXEXCLUDE3 135 BCD*10.3 Excluded Tax Amount 3 A X 
TXEXCLUDE4 136 BCD*10.3 Excluded Tax Amount 4 A X 
TXEXCLUDE5 137 BCD*10.3 Excluded Tax Amount 5 A X 
ISCOMPLETE 138 Boolean Completed A X  List:2 entries
0 = No
1 = Yes
EXTRANEOUS 139 Long Extraneous Line Count A X 
TAXLINE 140 Long Lines Tax Calculation Sees A X 
LINECMPL 141 Long Lines Complete A X 
LINE 142 Long Line A X 
EXSTDCOST 143 BCD*10.3 Extended Std. Cost in Src Curr A C X 
EXMRCOST 144 BCD*10.3 Extended MR Cost in Src Curr A C X 
EXALT1COST 145 BCD*10.3 Extended Cost 1 in Src Curr A C X 
EXALT2COST 146 BCD*10.3 Extended Cost 2 in Src Curr A C X 
GLNONSTKCD 147 String*60 Non-Stock Clearing Account Desc. A C X 
MAPMANITEM 148 Boolean Map Manufacturer's Item Number E A  List:2 entries
0 = No
1 = Yes
NETXTENDED 149 BCD*10.3 Net Extended Cost A X 
INVLREV 150 BCD*10.0 Line Number A C X 
RETLREV 151 BCD*10.0 Line Number A C X 
PROCESSCMD 152 Integer Command A C X  List:18 entries
0 = Nothing to Process
1 = Insert Optional Fields
2 = Default and Tranfer Optional Fields
3 = Default Opt. Fields During Record Generation
4 = Remove Optional Fields
5 = Transfer Opt. Fields from Standing Document
6 = Insert Item Serial Optional Fields
7 = Insert Item Lot Optional Fields
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
27 = Auto-assign Serials
28 = Auto-assign Lots
29 = Create Serials/Lots List
31 = Post Serials/Lots to IC Inventory
CONTRACT 153 String*16 Contract A X  Mask: %-16C
PROJECT 154 String*16 Project A X  Mask: %-16N
CCATEGORY 155 String*16 (Cost) Category A X  Mask: %-16N
COSTCLASS 156 Integer Cost Class A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
BILLTYPE 157 Integer Billing Type A P X  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE 158 BCD*10.6 Billing Rate A X 
BILLCURR 159 String*3 Billing Currency A C X  Mask: %-3N
ARITEMNO 160 String*16 A/R Item Number A X  Mask: %-16C
ARUNIT 161 String*10 A/R Unit of Measure A X  Mask: %-10C
RTGPERCENT 162 BCD*5.5 Retainage Percentage A X 
RTGDAYS 163 Integer Retention Period A X 
RTGAMOUNT 164 BCD*10.3 Retainage Amount A X 
RTGDATEDUE 165 Date Retainage Due Date A X 
RTGAMTOVER 166 Boolean Retainage Amount Overridden A C X  List:2 entries
0 = No
1 = Yes
RTGDDTOVER 167 Boolean Retainage Due Date Overridden A C X  List:2 entries
0 = No
1 = Yes
CONTSTYLE 168 Integer Project Style A C X  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 169 Integer Project Type A C X  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 170 Integer Accounting Method A C X  List:9 entries
0 =
1 = Completed Project
2 = Total Cost Percentage Complete
3 = Labor Hours Percentage Complete
4 = Billings and Costs
5 = Project Percentage Complete
6 = Category Percentage Complete
7 = Completed Contract
8 = Accrual-Basis
UFMTCONTNO 171 String*16 Unformatted Contract Code A C X  Mask: %-16C
TARAMOUNT1 172 BCD*10.3 Tax Reporting Amount 1 A X 
TARAMOUNT2 173 BCD*10.3 Tax Reporting Amount 2 A X 
TARAMOUNT3 174 BCD*10.3 Tax Reporting Amount 3 A X 
TARAMOUNT4 175 BCD*10.3 Tax Reporting Amount 4 A X 
TARAMOUNT5 176 BCD*10.3 Tax Reporting Amount 5 A X 
TRALLOAMT1 177 BCD*10.3 Tax Reporting Allocated Amount 1 A X 
TRALLOAMT2 178 BCD*10.3 Tax Reporting Allocated Amount 2 A X 
TRALLOAMT3 179 BCD*10.3 Tax Reporting Allocated Amount 3 A X 
TRALLOAMT4 180 BCD*10.3 Tax Reporting Allocated Amount 4 A X 
TRALLOAMT5 181 BCD*10.3 Tax Reporting Allocated Amount 5 A X 
TRRECVAMT1 182 BCD*10.3 Tax Reporting Recoverable Amt. 1 A X 
TRRECVAMT2 183 BCD*10.3 Tax Reporting Recoverable Amt. 2 A X 
TRRECVAMT3 184 BCD*10.3 Tax Reporting Recoverable Amt. 3 A X 
TRRECVAMT4 185 BCD*10.3 Tax Reporting Recoverable Amt. 4 A X 
TRRECVAMT5 186 BCD*10.3 Tax Reporting Recoverable Amt. 5 A X 
TREXPSAMT1 187 BCD*10.3 Tax Reporting Expense Amount 1 A X 
TREXPSAMT2 188 BCD*10.3 Tax Reporting Expense Amount 2 A X 
TREXPSAMT3 189 BCD*10.3 Tax Reporting Expense Amount 3 A X 
TREXPSAMT4 190 BCD*10.3 Tax Reporting Expense Amount 4 A X 
TREXPSAMT5 191 BCD*10.3 Tax Reporting Expense Amount 5 A X 
TRINCLUDE1 192 BCD*10.3 Tax Reporting Included Amount 1 A X 
TRINCLUDE2 193 BCD*10.3 Tax Reporting Included Amount 2 A X 
TRINCLUDE3 194 BCD*10.3 Tax Reporting Included Amount 3 A X 
TRINCLUDE4 195 BCD*10.3 Tax Reporting Included Amount 4 A X 
TRINCLUDE5 196 BCD*10.3 Tax Reporting Included Amount 5 A X 
TREXCLUDE1 197 BCD*10.3 Tax Reporting Excluded Amount 1 A X 
TREXCLUDE2 198 BCD*10.3 Tax Reporting Excluded Amount 2 A X 
TREXCLUDE3 199 BCD*10.3 Tax Reporting Excluded Amount 3 A X 
TREXCLUDE4 200 BCD*10.3 Tax Reporting Excluded Amount 4 A X 
TREXCLUDE5 201 BCD*10.3 Tax Reporting Excluded Amount 5 A X 
TARAMOUNT 202 BCD*10.3 Tax Reporting Total Amount A X 
TRINCLUDED 203 BCD*10.3 Tax Reporting Included Amount A X 
TREXCLUDED 204 BCD*10.3 Tax Reporting Excluded Amount A X 
TRRECVAMT 205 BCD*10.3 Tax Reporting Recoverable Amount A X 
TREXPSAMT 206 BCD*10.3 Tax Reporting Expensed Amount A X 
TRALLOAMT 207 BCD*10.3 Tax Reporting Allocated Amount A X 
RAXBASE1 208 BCD*10.3 Retainage Tax Base 1 A X 
RAXBASE2 209 BCD*10.3 Retainage Tax Base 2 A X 
RAXBASE3 210 BCD*10.3 Retainage Tax Base 3 A X 
RAXBASE4 211 BCD*10.3 Retainage Tax Base 4 A X 
RAXBASE5 212 BCD*10.3 Retainage Tax Base 5 A X 
RAXAMOUNT1 213 BCD*10.3 Retainage Tax Amount 1 A X 
RAXAMOUNT2 214 BCD*10.3 Retainage Tax Amount 2 A X 
RAXAMOUNT3 215 BCD*10.3 Retainage Tax Amount 3 A X 
RAXAMOUNT4 216 BCD*10.3 Retainage Tax Amount 4 A X 
RAXAMOUNT5 217 BCD*10.3 Retainage Tax Amount 5 A X 
RXRECVAMT1 218 BCD*10.3 Retainage Tax Recoverable Amt. 1 A X 
RXRECVAMT2 219 BCD*10.3 Retainage Tax Recoverable Amt. 2 A X 
RXRECVAMT3 220 BCD*10.3 Retainage Tax Recoverable Amt. 3 A X 
RXRECVAMT4 221 BCD*10.3 Retainage Tax Recoverable Amt. 4 A X 
RXRECVAMT5 222 BCD*10.3 Retainage Tax Recoverable Amt. 5 A X 
RXEXPSAMT1 223 BCD*10.3 Retainage Tax Expense Amount 1 A X 
RXEXPSAMT2 224 BCD*10.3 Retainage Tax Expense Amount 2 A X 
RXEXPSAMT3 225 BCD*10.3 Retainage Tax Expense Amount 3 A X 
RXEXPSAMT4 226 BCD*10.3 Retainage Tax Expense Amount 4 A X 
RXEXPSAMT5 227 BCD*10.3 Retainage Tax Expense Amount 5 A X 
RXALLOAMT1 228 BCD*10.3 Retainage Tax Allocated Amount 1 A X 
RXALLOAMT2 229 BCD*10.3 Retainage Tax Allocated Amount 2 A X 
RXALLOAMT3 230 BCD*10.3 Retainage Tax Allocated Amount 3 A X 
RXALLOAMT4 231 BCD*10.3 Retainage Tax Allocated Amount 4 A X 
RXALLOAMT5 232 BCD*10.3 Retainage Tax Allocated Amount 5 A X 
RAXAMOUNT 233 BCD*10.3 Retainage Tax Total Amount A X 
TXRXAMT1 234 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 1 A X 
TXRXAMT2 235 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 2 A X 
TXRXAMT3 236 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 3 A X 
TXRXAMT4 237 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 4 A X 
TXRXAMT5 238 BCD*10.3 Tax Amount Plus Rtg. Tax Amt. 5 A X 
UCISMANUAL 239 Boolean Unit Cost is Manual A X  List:2 entries
0 = No
1 = Yes
WEIGHTUNIT 240 String*10 Weight Unit of Measure A X 
WEIGHTCONV 241 BCD*10.6 Weight Conversion A C X 
DEFUWEIGHT 242 BCD*10.4 Default Unit Weight A C X 
DEFEXTWGHT 243 BCD*10.4 Default Extended Weight A C X 
BILLRATECV 244 BCD*10.6 Billing Rate Conversion Factor A C X 
UNITBILLSR 245 BCD*10.6 Unit Billing Amount A C X 
EXTBILLSR 246 BCD*10.3 Extended Billing Amount A X 
XGENALCQTY 247 BCD*10.4 Serial/Lot Quantity to Process A C X 
XLOTMAKQTY 248 BCD*10.4 Number of Lots to Generate A C X 
XPERLOTQTY 249 BCD*10.4 Quantity per Lot A C X 
SALLOCFROM 250 String*40 Allocate from Serial A C X 
LALLOCFROM 251 String*40 Allocate from Lot A C X 
METERHWND 252 Long Serial/Lot Window Handle A C X 
SERIALQTY 253 Long Serial Quantity A C X 
LOTQTY 254 BCD*10.4 Lot Quantity A C X 
SLITEM 255 Integer Item Serialized/Lotted? A C P X  List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
DETAILNUM 256 Integer Detail Number A C X 
BILLCURDEC 257 Integer Billing Cur. No. Of Decimals A X 

This page was generated on 2023-Aug-31

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