View: Receipt Audit Headers

RotoID: PO0686
Table: PORCPAH
Protocol: Header
DLL:PORCPAH

Compositions: 4

RotoID Tables Title DLL
PO0688 PORCPAL Receipt Audit Lines PORCPAL
PO0690 PORCPAQ Receipt Audit Prorate Lines PORCPAQ
PO0692 PORCPAS Receipt Audit Costs PORCPAS
PO0681 PORCAHO Receipt Audit Hdr. Opt. Fields PORCAHO

Keys: 4

Title Fields
Master Key DAYENDSEQ, RCPAHSEQ
Vendor VENDOR, DAYENDSEQ, RCPAHSEQ
Transaction Date TRANSDATE, DAYENDSEQ, RCPAHSEQ
Document Number RCPNUMBER, DAYENDSEQ, RCPAHSEQ

Fields: 58

Field Index Type Title Attributes Presentation
DAYENDSEQ 1 BCD*10.0 Day End Number E A K R 
RCPAHSEQ 2 BCD*10.0 Processing Sequence E A K R 
ISPRINTED 3 Boolean Printed E A  List:2 entries
0 = No
1 = Yes
RCPHSEQ 4 BCD*10.0 Receipt Sequence Key E A 
POSTDATE 5 Date Last Posting Date E A 
DAYENDDATE 6 Date Day End Processing Date E A 
TRANSDATE 7 Date Transaction Date E A 
REFERENCE 8 String*60 Reference E A 
FISCYEAR 9 String*4 Fiscal Year E A  Mask: %4D
FISCPERIOD 10 Integer Fiscal Period E A 
DESCRIPTIO 11 String*60 Description E A 
TRANSTYPE 12 Integer Transaction Type E A  List:3 entries
1 = Receipt
2 = Receipt Adjustment
99 = Sequence Placeholder (?)
VENDOR 13 String*12 Vendor E A  Mask: %-12C
VENDORNAME 14 String*60 Name E A 
TAXGROUP 15 String*12 Tax Group E A  Mask: %-12N
TAXAUTH1 16 String*12 Tax Authority 1 E A  Mask: %-12N
TAXAUTH2 17 String*12 Tax Authority 2 E A  Mask: %-12N
TAXAUTH3 18 String*12 Tax Authority 3 E A  Mask: %-12N
TAXAUTH4 19 String*12 Tax Authority 4 E A  Mask: %-12N
TAXAUTH5 20 String*12 Tax Authority 5 E A  Mask: %-12N
TAXCLASS1 21 Integer Tax Class 1 E A 
TAXCLASS2 22 Integer Tax Class 2 E A 
TAXCLASS3 23 Integer Tax Class 3 E A 
TAXCLASS4 24 Integer Tax Class 4 E A 
TAXCLASS5 25 Integer Tax Class 5 E A 
PONUMBER 26 String*22 Purchase Order Number E A  Mask: %-22C
RCPNUMBER 27 String*22 Receipt Number E A  Mask: %-22C
RCPCURR 28 String*3 Currency E A  Mask: %-3N
EXRATE 29 BCD*8.7 Exchange Rate E A 
RATEDATE 30 Date Rate Date E A 
RATETYPE 31 String*2 Rate Type E A  Mask: %-2N
RATEOPER 32 Integer Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 33 Boolean Rate Overridden E A  List:2 entries
0 = No
1 = Yes
SCURNDECML 34 Integer Decimal Places E A 
FCDOCTOTAL 35 BCD*10.3 Functional Total Cost E A 
SCDOCTOTAL 36 BCD*10.3 Source Document Total E A 
COMPLETE 37 Boolean Completed E A  List:2 entries
0 = No
1 = Yes
PRINTED 38 Boolean Printed E A  List:2 entries
0 = No
1 = Yes
MULTIPOR 39 Boolean Multiple Purchase Orders E A  List:2 entries
0 = No
1 = Yes
VALUES 40 Long Optional Fields E A C 
PGMVER 41 String*3 Program Version E A 
TRANSNUM 42 BCD*10.0 Transaction Number E A 
VERPRORATE 43 Integer Proration Version E A  List:2 entries
1 = 3.0A
2 = 5.3B
HASRTG 44 Boolean Has Retainage E A  List:2 entries
0 = No
1 = Yes
RTGRATE 45 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGBASE 46 Integer Retainage Base E A  List:2 entries
0 = Total After Taxes
1 = Total Before Taxes
SCRTGAMT 47 BCD*10.3 Retainage Amount E A 
HASJOB 48 Boolean Job Related E A  List:2 entries
0 = No
1 = Yes
TRCURRENCY 49 String*3 Tax Reporting Currency E A  Mask: %-3N
EXRATERC 50 BCD*8.7 Tax Reporting Exchange Rate E A 
RATEDATERC 51 Date Tax Reporting Rate Date E A 
RATETYPERC 52 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEOPERRC 53 Integer Tax Reporting Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATERCOVER 54 Boolean Tax Reporting Rate Overridden E A  List:2 entries
0 = No
1 = Yes
RCURNDECML 55 Integer Tax Reporting Decimal Places E A 
DATEBUS 56 Date Posting Date E A 
VDACCTSET 57 String*6 Vendor Account Set E A  Mask: %-6N
CAXAMOUNT 58 BCD*10.3 Reverse Charges Total Amount E A 

This page was generated on 2021-Nov-24

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