View: CR/DR Note Posting Add. Costs

RotoID: PO0321
Table: POCRNT
Protocol: Detail, Ordered revisions
DLL:POCRNT

Compositions: 3

RotoID Tables Title DLL
PO0312 POCRNI Credit/Debit Note Postings POCRNI
PO0311 POCRNH1POCRNH2 Credit/Debit Notes POCRNH
PO0320 POCRNS CR/DR Note Additional Costs POCRNS

Keys: 1

Title Fields
Master Key CRNISEQ, CRNHSEQ, CRNSSEQ

Fields: 120

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 
CRNSSEQ 3 BCD*10.0 Credit/Debit Note Cost Sequence E A K R 
OPERATION 4 Integer Operation To Post E A 
RCPHSEQ 5 BCD*10.0 Receipt Sequence Key E A 
RCPSSEQ 6 BCD*10.0 Receipt Cost Sequence E A 
INVHSEQ 7 BCD*10.0 Invoice Sequence Key E A 
INVSSEQ 8 BCD*10.0 Invoice Cost Sequence E A 
ADDCOST 9 String*6 Additional Cost E A  Mask: %-6N
DESCRIPTIO 10 String*60 Description E A 
GLEXPACCT 11 String*45 Expense Account E A  Mask: %-45C
GLRETACCT 12 String*45 Return Account E A  Mask: %-45C
AMOUNT 13 BCD*10.3 Amount E A 
PRORMETHOD 14 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 15 Integer Reproration Method E A 
TAXICLASS1 16 Integer Cost Tax Class 1 E A 
TAXICLASS2 17 Integer Cost Tax Class 2 E A 
TAXICLASS3 18 Integer Cost Tax Class 3 E A 
TAXICLASS4 19 Integer Cost Tax Class 4 E A 
TAXICLASS5 20 Integer Cost Tax Class 5 E A 
TAXBASE1 21 BCD*10.3 Tax Base 1 E A 
TAXBASE2 22 BCD*10.3 Tax Base 2 E A 
TAXBASE3 23 BCD*10.3 Tax Base 3 E A 
TAXBASE4 24 BCD*10.3 Tax Base 4 E A 
TAXBASE5 25 BCD*10.3 Tax Base 5 E A 
TAXINCLUD1 26 Boolean Tax Includable 1 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD2 27 Boolean Tax Includable 2 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD3 28 Boolean Tax Includable 3 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD4 29 Boolean Tax Includable 4 E A  List:2 entries
0 = No
1 = Yes
TAXINCLUD5 30 Boolean Tax Includable 5 E A  List:2 entries
0 = No
1 = Yes
TXINCLUDE1 31 BCD*10.3 Included Tax Amount 1 E A 
TXINCLUDE2 32 BCD*10.3 Included Tax Amount 2 E A 
TXINCLUDE3 33 BCD*10.3 Included Tax Amount 3 E A 
TXINCLUDE4 34 BCD*10.3 Included Tax Amount 4 E A 
TXINCLUDE5 35 BCD*10.3 Included Tax Amount 5 E A 
TXRECVAMT1 36 BCD*10.3 Tax Recoverable Amount 1 E A 
TXRECVAMT2 37 BCD*10.3 Tax Recoverable Amount 2 E A 
TXRECVAMT3 38 BCD*10.3 Tax Recoverable Amount 3 E A 
TXRECVAMT4 39 BCD*10.3 Tax Recoverable Amount 4 E A 
TXRECVAMT5 40 BCD*10.3 Tax Recoverable Amount 5 E A 
TXEXPSAMT1 41 BCD*10.3 Tax Expense Amount 1 E A 
TXEXPSAMT2 42 BCD*10.3 Tax Expense Amount 2 E A 
TXEXPSAMT3 43 BCD*10.3 Tax Expense Amount 3 E A 
TXEXPSAMT4 44 BCD*10.3 Tax Expense Amount 4 E A 
TXEXPSAMT5 45 BCD*10.3 Tax Expense Amount 5 E A 
TXALLOAMT1 46 BCD*10.3 Tax Allocated Amount 1 E A 
TXALLOAMT2 47 BCD*10.3 Tax Allocated Amount 2 E A 
TXALLOAMT3 48 BCD*10.3 Tax Allocated Amount 3 E A 
TXALLOAMT4 49 BCD*10.3 Tax Allocated Amount 4 E A 
TXALLOAMT5 50 BCD*10.3 Tax Allocated Amount 5 E A 
TXBASEALLO 51 BCD*10.3 Net of Tax E A 
TFBASEALLO 52 BCD*10.3 Func. Net of Tax A C 
TFINCLUDE1 53 BCD*10.3 Func. Tax Included Amount 1 A C 
TFINCLUDE2 54 BCD*10.3 Func. Tax Included Amount 2 A C 
TFINCLUDE3 55 BCD*10.3 Func. Tax Included Amount 3 A C 
TFINCLUDE4 56 BCD*10.3 Func. Tax Included Amount 4 A C 
TFINCLUDE5 57 BCD*10.3 Func. Tax Included Amount 5 A C 
TFALLOAMT1 58 BCD*10.3 Func. Tax Allocated Amount 1 A C 
TFALLOAMT2 59 BCD*10.3 Func. Tax Allocated Amount 2 A C 
TFALLOAMT3 60 BCD*10.3 Func. Tax Allocated Amount 3 A C 
TFALLOAMT4 61 BCD*10.3 Func. Tax Allocated Amount 4 A C 
TFALLOAMT5 62 BCD*10.3 Func. Tax Allocated Amount 5 A C 
TFRECVAMT1 63 BCD*10.3 Func. Tax Recoverable Amount 1 A C 
TFRECVAMT2 64 BCD*10.3 Func. Tax Recoverable Amount 2 A C 
TFRECVAMT3 65 BCD*10.3 Func. Tax Recoverable Amount 3 A C 
TFRECVAMT4 66 BCD*10.3 Func. Tax Recoverable Amount 4 A C 
TFRECVAMT5 67 BCD*10.3 Func. Tax Recoverable Amount 5 A C 
TFEXPSAMT1 68 BCD*10.3 Func. Tax Expense Amount 1 A C 
TFEXPSAMT2 69 BCD*10.3 Func. Tax Expense Amount 2 A C 
TFEXPSAMT3 70 BCD*10.3 Func. Tax Expense Amount 3 A C 
TFEXPSAMT4 71 BCD*10.3 Func. Tax Expense Amount 4 A C 
TFEXPSAMT5 72 BCD*10.3 Func. Tax Expense Amount 5 A C 
RCPHSEQC 73 BCD*10.0 Receipt/Apply To Receipt Seq Key E A 
BILLRATE 74 BCD*10.6 Billing Rate E A 
RTGPERCENT 75 BCD*5.5 Retainage Percentage E A 
RTGDAYS 76 Integer Retention Period E A 
RTGAMOUNT 77 BCD*10.3 Retainage Amount E A 
RTGDATEDUE 78 Date Retainage Due Date E A 
RTGAMTOVER 79 Boolean Retainage Amount Overridden E A 
RTGDDTOVER 80 Boolean Retainage Due Date Overridden E A 
TRINCLUDE1 81 BCD*10.3 Tax Reporting Included Amount 1 E A 
TRINCLUDE2 82 BCD*10.3 Tax Reporting Included Amount 2 E A 
TRINCLUDE3 83 BCD*10.3 Tax Reporting Included Amount 3 E A 
TRINCLUDE4 84 BCD*10.3 Tax Reporting Included Amount 4 E A 
TRINCLUDE5 85 BCD*10.3 Tax Reporting Included Amount 5 E A 
TRRECVAMT1 86 BCD*10.3 Tax Reporting Recoverable Amt. 1 E A 
TRRECVAMT2 87 BCD*10.3 Tax Reporting Recoverable Amt. 2 E A 
TRRECVAMT3 88 BCD*10.3 Tax Reporting Recoverable Amt. 3 E A 
TRRECVAMT4 89 BCD*10.3 Tax Reporting Recoverable Amt. 4 E A 
TRRECVAMT5 90 BCD*10.3 Tax Reporting Recoverable Amt. 5 E A 
TREXPSAMT1 91 BCD*10.3 Tax Reporting Expense Amount 1 E A 
TREXPSAMT2 92 BCD*10.3 Tax Reporting Expense Amount 2 E A 
TREXPSAMT3 93 BCD*10.3 Tax Reporting Expense Amount 3 E A 
TREXPSAMT4 94 BCD*10.3 Tax Reporting Expense Amount 4 E A 
TREXPSAMT5 95 BCD*10.3 Tax Reporting Expense Amount 5 E A 
TRALLOAMT1 96 BCD*10.3 Tax Reporting Allocated Amount 1 E A 
TRALLOAMT2 97 BCD*10.3 Tax Reporting Allocated Amount 2 E A 
TRALLOAMT3 98 BCD*10.3 Tax Reporting Allocated Amount 3 E A 
TRALLOAMT4 99 BCD*10.3 Tax Reporting Allocated Amount 4 E A 
TRALLOAMT5 100 BCD*10.3 Tax Reporting Allocated Amount 5 E A 
RAXBASE1 101 BCD*10.3 Retainage Tax Base 1 E A 
RAXBASE2 102 BCD*10.3 Retainage Tax Base 2 E A 
RAXBASE3 103 BCD*10.3 Retainage Tax Base 3 E A 
RAXBASE4 104 BCD*10.3 Retainage Tax Base 4 E A 
RAXBASE5 105 BCD*10.3 Retainage Tax Base 5 E A 
RXRECVAMT1 106 BCD*10.3 Retainage Tax Recoverable Amt. 1 E A 
RXRECVAMT2 107 BCD*10.3 Retainage Tax Recoverable Amt. 2 E A 
RXRECVAMT3 108 BCD*10.3 Retainage Tax Recoverable Amt. 3 E A 
RXRECVAMT4 109 BCD*10.3 Retainage Tax Recoverable Amt. 4 E A 
RXRECVAMT5 110 BCD*10.3 Retainage Tax Recoverable Amt. 5 E A 
RXEXPSAMT1 111 BCD*10.3 Retainage Tax Expense Amount 1 E A 
RXEXPSAMT2 112 BCD*10.3 Retainage Tax Expense Amount 2 E A 
RXEXPSAMT3 113 BCD*10.3 Retainage Tax Expense Amount 3 E A 
RXEXPSAMT4 114 BCD*10.3 Retainage Tax Expense Amount 4 E A 
RXEXPSAMT5 115 BCD*10.3 Retainage Tax Expense Amount 5 E A 
RXALLOAMT1 116 BCD*10.3 Retainage Tax Allocated Amount 1 E A 
RXALLOAMT2 117 BCD*10.3 Retainage Tax Allocated Amount 2 E A 
RXALLOAMT3 118 BCD*10.3 Retainage Tax Allocated Amount 3 E A 
RXALLOAMT4 119 BCD*10.3 Retainage Tax Allocated Amount 4 E A 
RXALLOAMT5 120 BCD*10.3 Retainage Tax Allocated Amount 5 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).