Table: CR/DR Note Additional Costs

Table: POCRNS
View: PO0320
Record Length: 1848

Flags: A R 

Keys: 3

Title Flags Fields
Master Key CRNHSEQ, CRNSREV
Second Key CRNHSEQ, CRNSSEQ
Detail Locator Key CRNSSEQ, CRNHSEQ

Fields: 162

Field Type Title Presentation
CRNHSEQ BCD*10.0 Credit/Debit Note Sequence Key
CRNSREV BCD*10.0 Line Number
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
CRNSSEQ BCD*10.0 Credit/Debit Note Cost Sequence
COMPLETION Integer Completion Status List:3 entries
1 = No
2 = Yes
3 = Yes
DTCOMPLETE Date Date Completed
INDBTABLE Boolean Stored in Database Table List:2 entries
0 = No
1 = Yes
RCPHSEQ BCD*10.0 Receipt Sequence Key
RCPSSEQ BCD*10.0 Receipt Cost Sequence
INVHSEQ BCD*10.0 Invoice Sequence Key
INVSSEQ BCD*10.0 Invoice Cost Sequence
ADDCOST String*6 Additional Cost Mask: %-6N
GLEXPACCT String*45 Expense Account Mask: %-45C
GLRETACCT String*45 Return Account Mask: %-45C
AMOUNT BCD*10.3 Amount
PRORMETHOD Integer Proration Method List:1 entries
1 = No Proration
REPRORATE Integer Reproration Method List:3 entries
1 = Leave
2 = Prorate
3 = Expense
DESCRIPTIO String*60 Description
REFERENCE String*60 Reference
COMMENT String*250 Comment
TAXICLASS1 Integer Cost Tax Class 1
TAXICLASS2 Integer Cost Tax Class 2
TAXICLASS3 Integer Cost Tax Class 3
TAXICLASS4 Integer Cost Tax Class 4
TAXICLASS5 Integer Cost Tax Class 5
TAXBASE1 BCD*10.3 Tax Base 1
TAXBASE2 BCD*10.3 Tax Base 2
TAXBASE3 BCD*10.3 Tax Base 3
TAXBASE4 BCD*10.3 Tax Base 4
TAXBASE5 BCD*10.3 Tax Base 5
TAXRATE1 BCD*8.5 Tax Rate 1
TAXRATE2 BCD*8.5 Tax Rate 2
TAXRATE3 BCD*8.5 Tax Rate 3
TAXRATE4 BCD*8.5 Tax Rate 4
TAXRATE5 BCD*8.5 Tax Rate 5
TAXAMOUNT1 BCD*10.3 Tax Amount 1
TAXAMOUNT2 BCD*10.3 Tax Amount 2
TAXAMOUNT3 BCD*10.3 Tax Amount 3
TAXAMOUNT4 BCD*10.3 Tax Amount 4
TAXAMOUNT5 BCD*10.3 Tax Amount 5
TAXINCLUD1 Boolean Tax Includable 1 List:2 entries
0 = No
1 = Yes
TAXINCLUD2 Boolean Tax Includable 2 List:2 entries
0 = No
1 = Yes
TAXINCLUD3 Boolean Tax Includable 3 List:2 entries
0 = No
1 = Yes
TAXINCLUD4 Boolean Tax Includable 4 List:2 entries
0 = No
1 = Yes
TAXINCLUD5 Boolean Tax Includable 5 List:2 entries
0 = No
1 = Yes
TXALLOAMT1 BCD*10.3 Tax Allocated Amount 1
TXALLOAMT2 BCD*10.3 Tax Allocated Amount 2
TXALLOAMT3 BCD*10.3 Tax Allocated Amount 3
TXALLOAMT4 BCD*10.3 Tax Allocated Amount 4
TXALLOAMT5 BCD*10.3 Tax Allocated Amount 5
TXRECVAMT1 BCD*10.3 Tax Recoverable Amount 1
TXRECVAMT2 BCD*10.3 Tax Recoverable Amount 2
TXRECVAMT3 BCD*10.3 Tax Recoverable Amount 3
TXRECVAMT4 BCD*10.3 Tax Recoverable Amount 4
TXRECVAMT5 BCD*10.3 Tax Recoverable Amount 5
TXEXPSAMT1 BCD*10.3 Tax Expense Amount 1
TXEXPSAMT2 BCD*10.3 Tax Expense Amount 2
TXEXPSAMT3 BCD*10.3 Tax Expense Amount 3
TXEXPSAMT4 BCD*10.3 Tax Expense Amount 4
TXEXPSAMT5 BCD*10.3 Tax Expense Amount 5
TXBASEALLO BCD*10.3 Net of Tax
TXINCLUDED BCD*10.3 Tax Included
TXEXCLUDED BCD*10.3 Tax Excluded
TAXAMOUNT BCD*10.3 Total Tax
TXRECVAMT BCD*10.3 Total Tax Recoverable
TXEXPSAMT BCD*10.3 Total Tax Expensed
TXALLOAMT BCD*10.3 Total Tax Allocated
TFBASEALLO BCD*10.3 Func. Net of Tax
TFINCLUDE1 BCD*10.3 Func. Tax Included Amount 1
TFINCLUDE2 BCD*10.3 Func. Tax Included Amount 2
TFINCLUDE3 BCD*10.3 Func. Tax Included Amount 3
TFINCLUDE4 BCD*10.3 Func. Tax Included Amount 4
TFINCLUDE5 BCD*10.3 Func. Tax Included Amount 5
TFALLOAMT1 BCD*10.3 Func. Tax Allocated Amount 1
TFALLOAMT2 BCD*10.3 Func. Tax Allocated Amount 2
TFALLOAMT3 BCD*10.3 Func. Tax Allocated Amount 3
TFALLOAMT4 BCD*10.3 Func. Tax Allocated Amount 4
TFALLOAMT5 BCD*10.3 Func. Tax Allocated Amount 5
TFRECVAMT1 BCD*10.3 Func. Tax Recoverable Amount 1
TFRECVAMT2 BCD*10.3 Func. Tax Recoverable Amount 2
TFRECVAMT3 BCD*10.3 Func. Tax Recoverable Amount 3
TFRECVAMT4 BCD*10.3 Func. Tax Recoverable Amount 4
TFRECVAMT5 BCD*10.3 Func. Tax Recoverable Amount 5
TFEXPSAMT1 BCD*10.3 Func. Tax Expense Amount 1
TFEXPSAMT2 BCD*10.3 Func. Tax Expense Amount 2
TFEXPSAMT3 BCD*10.3 Func. Tax Expense Amount 3
TFEXPSAMT4 BCD*10.3 Func. Tax Expense Amount 4
TFEXPSAMT5 BCD*10.3 Func. Tax Expense Amount 5
RCPNUMBER String*22 Receipt Number Mask: %-22C
RCPHSEQA BCD*10.0 Apply To Receipt Sequence Key
RCPNUMBERA String*22 Apply To Receipt Number Mask: %-22C
INVSSEQG BCD*10.0 Invoice Cost Group Sequence
VALUES Long Optional Fields
CONTRACT String*16 Contract Mask: %-16C
PROJECT String*16 Project Mask: %-16N
CCATEGORY String*16 (Cost) Category Mask: %-16N
COSTCLASS Integer Cost Class List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
RESOURCE String*24 Resource Mask: %-16N
BILLTYPE Integer Billing Type List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
BILLRATE BCD*10.6 Billing Rate
BILLCURR String*3 Billing Currency Mask: %-3N
ARITEMNO String*16 A/R Item Number Mask: %-16C
ARUNIT String*10 A/R Unit of Measure Mask: %-10C
CALCOVRHD Boolean Calculate Overhead List:2 entries
0 = No
1 = Yes
CALCLABOR Boolean Calculate Labor List:2 entries
0 = No
1 = Yes
RTGPERCENT BCD*5.5 Retainage Percentage
RTGDAYS Integer Retention Period
RTGAMOUNT BCD*10.3 Retainage Amount
RTGDATEDUE Date Retainage Due Date
RTGAMTOVER Boolean Retainage Amount Overridden List:2 entries
0 = No
1 = Yes
RTGDDTOVER Boolean Retainage Due Date Overridden List:2 entries
0 = No
1 = Yes
COSTDISTS Long Cost Distributions
MANDISTS Long Manual Cost Distributions
EXTDISTS Long Extraneous Cost Distributions
TARAMOUNT1 BCD*10.3 Tax Reporting Amount 1
TARAMOUNT2 BCD*10.3 Tax Reporting Amount 2
TARAMOUNT3 BCD*10.3 Tax Reporting Amount 3
TARAMOUNT4 BCD*10.3 Tax Reporting Amount 4
TARAMOUNT5 BCD*10.3 Tax Reporting Amount 5
TRALLOAMT1 BCD*10.3 Tax Reporting Allocated Amount 1
TRALLOAMT2 BCD*10.3 Tax Reporting Allocated Amount 2
TRALLOAMT3 BCD*10.3 Tax Reporting Allocated Amount 3
TRALLOAMT4 BCD*10.3 Tax Reporting Allocated Amount 4
TRALLOAMT5 BCD*10.3 Tax Reporting Allocated Amount 5
TRRECVAMT1 BCD*10.3 Tax Reporting Recoverable Amt. 1
TRRECVAMT2 BCD*10.3 Tax Reporting Recoverable Amt. 2
TRRECVAMT3 BCD*10.3 Tax Reporting Recoverable Amt. 3
TRRECVAMT4 BCD*10.3 Tax Reporting Recoverable Amt. 4
TRRECVAMT5 BCD*10.3 Tax Reporting Recoverable Amt. 5
TREXPSAMT1 BCD*10.3 Tax Reporting Expense Amount 1
TREXPSAMT2 BCD*10.3 Tax Reporting Expense Amount 2
TREXPSAMT3 BCD*10.3 Tax Reporting Expense Amount 3
TREXPSAMT4 BCD*10.3 Tax Reporting Expense Amount 4
TREXPSAMT5 BCD*10.3 Tax Reporting Expense Amount 5
RAXBASE1 BCD*10.3 Retainage Tax Base 1
RAXBASE2 BCD*10.3 Retainage Tax Base 2
RAXBASE3 BCD*10.3 Retainage Tax Base 3
RAXBASE4 BCD*10.3 Retainage Tax Base 4
RAXBASE5 BCD*10.3 Retainage Tax Base 5
RAXAMOUNT1 BCD*10.3 Retainage Tax Amount 1
RAXAMOUNT2 BCD*10.3 Retainage Tax Amount 2
RAXAMOUNT3 BCD*10.3 Retainage Tax Amount 3
RAXAMOUNT4 BCD*10.3 Retainage Tax Amount 4
RAXAMOUNT5 BCD*10.3 Retainage Tax Amount 5
RXRECVAMT1 BCD*10.3 Retainage Tax Recoverable Amt. 1
RXRECVAMT2 BCD*10.3 Retainage Tax Recoverable Amt. 2
RXRECVAMT3 BCD*10.3 Retainage Tax Recoverable Amt. 3
RXRECVAMT4 BCD*10.3 Retainage Tax Recoverable Amt. 4
RXRECVAMT5 BCD*10.3 Retainage Tax Recoverable Amt. 5
RXEXPSAMT1 BCD*10.3 Retainage Tax Expense Amount 1
RXEXPSAMT2 BCD*10.3 Retainage Tax Expense Amount 2
RXEXPSAMT3 BCD*10.3 Retainage Tax Expense Amount 3
RXEXPSAMT4 BCD*10.3 Retainage Tax Expense Amount 4
RXEXPSAMT5 BCD*10.3 Retainage Tax Expense Amount 5
RXALLOAMT1 BCD*10.3 Retainage Tax Allocated Amount 1
RXALLOAMT2 BCD*10.3 Retainage Tax Allocated Amount 2
RXALLOAMT3 BCD*10.3 Retainage Tax Allocated Amount 3
RXALLOAMT4 BCD*10.3 Retainage Tax Allocated Amount 4
RXALLOAMT5 BCD*10.3 Retainage Tax Allocated Amount 5

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