View: Credit/Debit Note Posting Lines

RotoID: PO0316
Table: POCRNM
Protocol: Detail, Ordered revisions
DLL:POCRNM

Compositions: 7

RotoID Tables Title DLL
PO0312 POCRNI Credit/Debit Note Postings POCRNI
PO0310 Credit/Debit Note Functions POCRNG
PO0311 POCRNH1POCRNH2 Credit/Debit Notes POCRNH
PO0315 POCRNL Credit/Debit Note Lines POCRNL
PO0730 Return Functions PORETG
PO0731 PORETH1PORETH2 Returns PORETH
PO0735 PORETL Return Lines PORETL

Keys: 1

Title Fields
Detail Key CRNISEQ, CRNHSEQ, CRNLSEQ

Fields: 148

Field Index Type Title Attributes Presentation
CRNISEQ 1 BCD*10.0 Header Sequence E A K R 
CRNHSEQ 2 BCD*10.0 Credit/Debit Note Sequence Key E A K R 
CRNLSEQ 3 BCD*10.0 Credit/Debit Note Line Sequence E A K R 
OPERATION 4 Integer Operation To Post E A 
RCPHSEQ 5 BCD*10.0 Receipt Sequence Key E A 
RCPLSEQ 6 BCD*10.0 Receipt Line Sequence E A 
RETHSEQ 7 BCD*10.0 Return Sequence Key E A 
RETLSEQ 8 BCD*10.0 Return Line Sequence E A 
INVHSEQ 9 BCD*10.0 Invoice Sequence Key E A 
INVLSEQ 10 BCD*10.0 Invoice Line Sequence E A 
ITEMDESC 11 String*60 Item Description E A 
STOCKUNIT 12 String*10 Unit of Measure E A 
RETUNIT 13 String*10 Unit of Measure E A 
RETCONV 14 BCD*10.6 Returning Conversion Factor E A 
RETDECML 15 Integer Returning Unit Decimals E A 
STOCKDECML 16 Integer Stock Unit Decimals E A 
RQRETURNED 17 BCD*10.4 Quantity Returned E A 
SQRETURNED 18 BCD*10.4 Stocking Quantity Returned E A 
UNITCOST 19 BCD*10.6 Unit Cost E A 
EXTENDED 20 BCD*10.3 Extended Cost E A 
UNITWEIGHT 21 BCD*10.4 Unit Weight E A 
EXTWEIGHT 22 BCD*10.3 Extended Weight E A 
TAXBASE1 23 BCD*10.3 Tax Base 1 E A 
TAXBASE2 24 BCD*10.3 Tax Base 2 E A 
TAXBASE3 25 BCD*10.3 Tax Base 3 E A 
TAXBASE4 26 BCD*10.3 Tax Base 4 E A 
TAXBASE5 27 BCD*10.3 Tax Base 5 E A 
TAXCLASS1 28 Integer Tax Class 1 E A 
TAXCLASS2 29 Integer Tax Class 2 E A 
TAXCLASS3 30 Integer Tax Class 3 E A 
TAXCLASS4 31 Integer Tax Class 4 E A 
TAXCLASS5 32 Integer Tax Class 5 E A 
TAXINCLUD1 33 Boolean Tax Includable 1 E A 
TAXINCLUD2 34 Boolean Tax Includable 2 E A 
TAXINCLUD3 35 Boolean Tax Includable 3 E A 
TAXINCLUD4 36 Boolean Tax Includable 4 E A 
TAXINCLUD5 37 Boolean Tax Includable 5 E A 
TAXAMOUNT1 38 BCD*10.3 Tax Amount 1 E A 
TAXAMOUNT2 39 BCD*10.3 Tax Amount 2 E A 
TAXAMOUNT3 40 BCD*10.3 Tax Amount 3 E A 
TAXAMOUNT4 41 BCD*10.3 Tax Amount 4 E A 
TAXAMOUNT5 42 BCD*10.3 Tax Amount 5 E A 
TXINCLUDE1 43 BCD*10.3 Included Tax Amount 1 E A 
TXINCLUDE2 44 BCD*10.3 Included Tax Amount 2 E A 
TXINCLUDE3 45 BCD*10.3 Included Tax Amount 3 E A 
TXINCLUDE4 46 BCD*10.3 Included Tax Amount 4 E A 
TXINCLUDE5 47 BCD*10.3 Included Tax Amount 5 E A 
TXRECVAMT1 48 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 49 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 50 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 51 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 52 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 53 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 54 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 55 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 56 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 57 BCD*10.3 Tax Expense Amount 5 E A 
TXALLOAMT1 58 BCD*10.3 Tax Allocated Amount 1 E A 
TXALLOAMT2 59 BCD*10.3 Tax Allocated Amount 2 E A 
TXALLOAMT3 60 BCD*10.3 Tax Allocated Amount 3 E A 
TXALLOAMT4 61 BCD*10.3 Tax Allocated Amount 4 E A 
TXALLOAMT5 62 BCD*10.3 Tax Allocated Amount 5 E A 
TXBASEALLO 63 BCD*10.3 Net of Tax E A 
TXINCLUDED 64 BCD*10.3 Tax Included E A 
TXEXCLUDED 65 BCD*10.3 Tax Excluded E A 
TAXAMOUNT 66 BCD*10.3 Total Tax E A 
TXRECVAMT 67 BCD*10.3 Total Tax Recoverable E A 
TXEXPSAMT 68 BCD*10.3 Total Tax Expensed E A 
TXALLOAMT 69 BCD*10.3 Total Tax Allocated E A 
TFBASEALLO 70 BCD*10.3 Func. Net of Tax A C 
TFINCLUDE1 71 BCD*10.3 Func. Tax Included Amount 1 A C 
TFINCLUDE2 72 BCD*10.3 Func. Tax Included Amount 2 A C 
TFINCLUDE3 73 BCD*10.3 Func. Tax Included Amount 3 A C 
TFINCLUDE4 74 BCD*10.3 Func. Tax Included Amount 4 A C 
TFINCLUDE5 75 BCD*10.3 Func. Tax Included Amount 5 A C 
TFALLOAMT1 76 BCD*10.3 Func. Tax Allocated Amount 1 A C 
TFALLOAMT2 77 BCD*10.3 Func. Tax Allocated Amount 2 A C 
TFALLOAMT3 78 BCD*10.3 Func. Tax Allocated Amount 3 A C 
TFALLOAMT4 79 BCD*10.3 Func. Tax Allocated Amount 4 A C 
TFALLOAMT5 80 BCD*10.3 Func. Tax Allocated Amount 5 A C 
TFRECVAMT1 81 BCD*10.3 Func. Tax Recoverable Amount 1 A C 
TFRECVAMT2 82 BCD*10.3 Func. Tax Recoverable Amount 2 A C 
TFRECVAMT3 83 BCD*10.3 Func. Tax Recoverable Amount 3 A C 
TFRECVAMT4 84 BCD*10.3 Func. Tax Recoverable Amount 4 A C 
TFRECVAMT5 85 BCD*10.3 Func. Tax Recoverable Amount 5 A C 
TFEXPSAMT1 86 BCD*10.3 Func. Tax Expense Amount 1 A C 
TFEXPSAMT2 87 BCD*10.3 Func. Tax Expense Amount 2 A C 
TFEXPSAMT3 88 BCD*10.3 Func. Tax Expense Amount 3 A C 
TFEXPSAMT4 89 BCD*10.3 Func. Tax Expense Amount 4 A C 
TFEXPSAMT5 90 BCD*10.3 Func. Tax Expense Amount 5 A C 
GLACEXPENS 91 String*45 Expense Account E A 
GLNONSTKCR 92 String*45 Non-Stock Clearing Account E A 
DISCPCT 93 BCD*5.5 Discount Percentage E A 
DISCOUNT 94 BCD*10.3 Discount Amount E A 
DISCOUNTF 95 BCD*10.3 Func. Discount Amount E A 
BILLRATE 96 BCD*10.6 Billing Rate E A 
RTGPERCENT 97 BCD*5.5 Retainage Percentage E A 
RTGDAYS 98 Integer Retention Period E A 
RTGAMOUNT 99 BCD*10.3 Retainage Amount E A 
RTGDATEDUE 100 Date Retainage Due Date E A 
RTGAMTOVER 101 Boolean Retainage Amount Overridden E A 
RTGDDTOVER 102 Boolean Retainage Due Date Overridden E A 
TRINCLUDE1 103 BCD*10.3 Tax Reporting Included Amount 1 E A 
TRINCLUDE2 104 BCD*10.3 Tax Reporting Included Amount 2 E A 
TRINCLUDE3 105 BCD*10.3 Tax Reporting Included Amount 3 E A 
TRINCLUDE4 106 BCD*10.3 Tax Reporting Included Amount 4 E A 
TRINCLUDE5 107 BCD*10.3 Tax Reporting Included Amount 5 E A 
TRRECVAMT1 108 BCD*10.3 Tax Reporting Recoverable Amt. 1 E A 
TRRECVAMT2 109 BCD*10.3 Tax Reporting Recoverable Amt. 2 E A 
TRRECVAMT3 110 BCD*10.3 Tax Reporting Recoverable Amt. 3 E A 
TRRECVAMT4 111 BCD*10.3 Tax Reporting Recoverable Amt. 4 E A 
TRRECVAMT5 112 BCD*10.3 Tax Reporting Recoverable Amt. 5 E A 
TREXPSAMT1 113 BCD*10.3 Tax Reporting Expense Amount 1 E A 
TREXPSAMT2 114 BCD*10.3 Tax Reporting Expense Amount 2 E A 
TREXPSAMT3 115 BCD*10.3 Tax Reporting Expense Amount 3 E A 
TREXPSAMT4 116 BCD*10.3 Tax Reporting Expense Amount 4 E A 
TREXPSAMT5 117 BCD*10.3 Tax Reporting Expense Amount 5 E A 
TRALLOAMT1 118 BCD*10.3 Tax Reporting Allocated Amount 1 E A 
TRALLOAMT2 119 BCD*10.3 Tax Reporting Allocated Amount 2 E A 
TRALLOAMT3 120 BCD*10.3 Tax Reporting Allocated Amount 3 E A 
TRALLOAMT4 121 BCD*10.3 Tax Reporting Allocated Amount 4 E A 
TRALLOAMT5 122 BCD*10.3 Tax Reporting Allocated Amount 5 E A 
RAXBASE1 123 BCD*10.3 Retainage Tax Base 1 E A 
RAXBASE2 124 BCD*10.3 Retainage Tax Base 2 E A 
RAXBASE3 125 BCD*10.3 Retainage Tax Base 3 E A 
RAXBASE4 126 BCD*10.3 Retainage Tax Base 4 E A 
RAXBASE5 127 BCD*10.3 Retainage Tax Base 5 E A 
RXRECVAMT1 128 BCD*10.3 Retainage Tax Recoverable Amt. 1 E A 
RXRECVAMT2 129 BCD*10.3 Retainage Tax Recoverable Amt. 2 E A 
RXRECVAMT3 130 BCD*10.3 Retainage Tax Recoverable Amt. 3 E A 
RXRECVAMT4 131 BCD*10.3 Retainage Tax Recoverable Amt. 4 E A 
RXRECVAMT5 132 BCD*10.3 Retainage Tax Recoverable Amt. 5 E A 
RXEXPSAMT1 133 BCD*10.3 Retainage Tax Expense Amount 1 E A 
RXEXPSAMT2 134 BCD*10.3 Retainage Tax Expense Amount 2 E A 
RXEXPSAMT3 135 BCD*10.3 Retainage Tax Expense Amount 3 E A 
RXEXPSAMT4 136 BCD*10.3 Retainage Tax Expense Amount 4 E A 
RXEXPSAMT5 137 BCD*10.3 Retainage Tax Expense Amount 5 E A 
RXALLOAMT1 138 BCD*10.3 Retainage Tax Allocated Amount 1 E A 
RXALLOAMT2 139 BCD*10.3 Retainage Tax Allocated Amount 2 E A 
RXALLOAMT3 140 BCD*10.3 Retainage Tax Allocated Amount 3 E A 
RXALLOAMT4 141 BCD*10.3 Retainage Tax Allocated Amount 4 E A 
RXALLOAMT5 142 BCD*10.3 Retainage Tax Allocated Amount 5 E A 
WEIGHTUNIT 143 String*10 Weight Unit of Measure E A 
WEIGHTCONV 144 BCD*10.6 Weight Conversion E A 
DEFUWEIGHT 145 BCD*10.4 Default Unit Weight E A 
DEFEXTWGHT 146 BCD*10.4 Default Extended Weight E A 
QTYPOSTED 147 Boolean Is Quantity Posted? E A 
LAST 150 Boolean Last 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).