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=*
2=/
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=*
2=/
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 2008-May-01

Copyright © 2001–2008 Sage Software, Inc. All rights reserved.