Table: Credit/Debit Note Audit Headers

Table: POCRNAH
View: PO0304
Record Length: 638

Flags: A R 

Keys: 4

Title Flags Fields
Master Key DAYENDSEQ, CRNAHSEQ
Vendor VENDOR, DAYENDSEQ, CRNAHSEQ
Transaction Date TRANSDATE, DAYENDSEQ, CRNAHSEQ
Document Number CRNNUMBER, DAYENDSEQ, CRNAHSEQ

Fields: 71

Field Type Title Presentation
DAYENDSEQ BCD*10.0 Day End Number
CRNAHSEQ BCD*10.0 Processing Sequence
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
ISPRINTED Boolean Printed List:2 entries
0 = No
1 = Yes
CRNHSEQ BCD*10.0 Credit/Debit Note Sequence Key
POSTDATE Date Last Posting Date
DAYENDDATE Date Day End Processing Date
TRANSDATE Date Transaction Date
REFERENCE String*60 Reference
FISCYEAR String*4 Fiscal Year Mask: %4D
FISCPERIOD Integer Fiscal Period
DESCRIPTIO String*60 Description
TRANSTYPE Integer Transaction Type List:3 entries
1 = Credit
2 = Debit
6 = Adjustment
FROMDOC Integer From Document List:2 entries
4 = Return
5 = Invoice
VENDOR String*12 Vendor Mask: %-12C
VENDORNAME String*60 Name
TAXGROUP String*12 Tax Group Mask: %-12N
TAXAUTH1 String*12 Tax Authority 1 Mask: %-12N
TAXAUTH2 String*12 Tax Authority 2 Mask: %-12N
TAXAUTH3 String*12 Tax Authority 3 Mask: %-12N
TAXAUTH4 String*12 Tax Authority 4 Mask: %-12N
TAXAUTH5 String*12 Tax Authority 5 Mask: %-12N
TAXCLASS1 Integer Tax Class 1
TAXCLASS2 Integer Tax Class 2
TAXCLASS3 Integer Tax Class 3
TAXCLASS4 Integer Tax Class 4
TAXCLASS5 Integer Tax Class 5
CRNNUMBER String*22 Credit/Debit Note Number
PONUMBER String*22 Purchase Order Number
RCPNUMBER String*22 Receipt Number
RETNUMBER String*22 Return Number
INVNUMBER String*22 Invoice Number
RETCURR String*3 Currency Mask: %-3N
EXRATE BCD*8.7 Exchange Rate
RATEDATE Date Rate Date
RATETYPE String*2 Rate Type Mask: %-2N
RATEOPER Integer Rate Operation List:2 entries
1 = Multiply
2 = Divide
RATEOVER Boolean Rate Overridden List:2 entries
0 = No
1 = Yes
SCURNDECML Integer Decimal Places
FCDOCTOTAL BCD*10.3 Functional Total Cost
SCDOCTOTAL BCD*10.3 Source Document Total
FCAPTOTAL BCD*10.3 Functional Transferred Cost
SCAPTOTAL BCD*10.3 Transferred Cost
F1099CLASS String*6 1099/CPRS Class
F1099AMT BCD*10.3 The 1099/CPRS Amount
COMPLETE Boolean Completed List:2 entries
0 = No
1 = Yes
PRINTED Boolean Printed List:2 entries
0 = No
1 = Yes
VALUES Long Optional Fields
ONHOLD Boolean On Hold List:2 entries
0 = No
1 = Yes
PGMVER String*3 Program Version
VERPRORATE Integer Proration Version List:2 entries
1 = 3.0A
2 = 5.3B
HASRTG Boolean Has Retainage List:2 entries
0 = No
1 = Yes
RTGRATE Integer Retainage Exchange Rate List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGBASE Integer Retainage Base List:2 entries
0 = Total After Taxes
1 = Total Before Taxes
SCRTGAMT BCD*10.3 Retainage Amount
SCAPRTGAMT BCD*10.3 Transferred Retainage Amount
RTGPERCENT BCD*5.5 Retainage Percentage
HASJOB Boolean Job Related List:2 entries
0 = No
1 = Yes
FCAPRTGAMT BCD*10.3 Func. Transferred Rtg. Amount
TRCURRENCY String*3 Tax Reporting Currency Mask: %-3N
EXRATERC BCD*8.7 Tax Reporting Exchange Rate
RATEDATERC Date Tax Reporting Rate Date
RATETYPERC String*2 Tax Reporting Rate Type Mask: %-2N
RATEOPERRC Integer Tax Reporting Rate Operation List:2 entries
1 = Multiply
2 = Divide
RATERCOVER Boolean Tax Reporting Rate Overridden List:2 entries
0 = No
1 = Yes
RCURNDECML Integer Tax Reporting Decimal Places
DATEBUS Date Posting Date
VDACCTSET String*6 Vendor Account Set Mask: %-6N

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