View: Invoice Audit Headers

RotoID: PO0409
Table: POINVAH
Protocol: Header
DLL:POINVAH

Compositions: 4

RotoID Tables Title DLL
PO0410 POINVAL Invoice Audit Lines POINVAL
PO0411 POINVAQ Invoice Audit Prorate Lines POINVAQ
PO0412 POINVAS Invoice Audit Costs POINVAS
PO0447 POINAHO Invoice Audit Hdr. Opt. Fields POINAHO

Keys: 4

Title Fields
Master Key DAYENDSEQ, INVAHSEQ
Vendor VENDOR, DAYENDSEQ, INVAHSEQ
Transaction Date TRANSDATE, DAYENDSEQ, INVAHSEQ
Document Number INVNUMBER, DAYENDSEQ, INVAHSEQ

Fields: 68

Field Index Type Title Attributes Presentation
DAYENDSEQ 1 BCD*10.0 Day End Number E A K R 
INVAHSEQ 2 BCD*10.0 Processing Sequence E A K R 
ISPRINTED 3 Boolean Printed E A  List:2 entries
0 = No
1 = Yes
INVHSEQ 4 BCD*10.0 Invoice 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 = Invoice
2 = Invoice 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 
INVNUMBER 26 String*22 Invoice Number E A 
PONUMBER 27 String*22 Purchase Order Number E A 
RCPNUMBER 28 String*22 Receipt Number E A 
RCPCURR 29 String*3 Currency E A  Mask: %-3N
EXRATE 30 BCD*8.7 Exchange Rate E A 
RATEDATE 31 Date Rate Date E A 
RATETYPE 32 String*2 Rate Type E A  Mask: %-2N
RATEOPER 33 Integer Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATEOVER 34 Boolean Rate Overridden E A  List:2 entries
0 = No
1 = Yes
SCURNDECML 35 Integer Decimal Places E A 
FCDOCTOTAL 36 BCD*10.3 Functional Total Cost E A 
SCDOCTOTAL 37 BCD*10.3 Source Document Total E A 
FCAPTOTAL 38 BCD*10.3 Functional Transferred Cost E A 
SCAPTOTAL 39 BCD*10.3 Transferred Cost E A 
F1099CLASS 40 String*6 1099/CPRS Class E A 
F1099AMT 41 BCD*10.3 The 1099/CPRS Amount E A 
COMPLETE 42 Boolean Completed E A  List:2 entries
0 = No
1 = Yes
PRINTED 43 Boolean Printed E A  List:2 entries
0 = No
1 = Yes
MULTIRCP 44 Boolean Multiple Receipts E A  List:2 entries
0 = No
1 = Yes
VALUES 45 Long Optional Fields E A C 
ONHOLD 46 Boolean On Hold E A  List:2 entries
0 = No
1 = Yes
PGMVER 47 String*3 Program Version E A 
TRANSNUM 48 BCD*10.0 Transaction Number E A 
VERPRORATE 49 Integer Proration Version E A  List:2 entries
1 = 3.0A
2 = 5.3B
HASRTG 50 Boolean Has Retainage E A  List:2 entries
0 = No
1 = Yes
RTGRATE 51 Integer Retainage Exchange Rate E A  List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGBASE 52 Integer Retainage Base E A  List:2 entries
0 = Total After Taxes
1 = Total Before Taxes
SCRTGAMT 53 BCD*10.3 Retainage Amount E A 
SCAPRTGAMT 54 BCD*10.3 Transferred Retainage Amount E A 
RTGPERCENT 55 BCD*5.5 Retainage Percentage E A 
HASJOB 56 Boolean Job Related E A  List:2 entries
0 = No
1 = Yes
FCAPRTGAMT 57 BCD*10.3 Func. Transferred Rtg. Amount E A 
TRCURRENCY 58 String*3 Tax Reporting Currency E A  Mask: %-3N
EXRATERC 59 BCD*8.7 Tax Reporting Exchange Rate E A 
RATEDATERC 60 Date Tax Reporting Rate Date E A 
RATETYPERC 61 String*2 Tax Reporting Rate Type E A  Mask: %-2N
RATEOPERRC 62 Integer Tax Reporting Rate Operation E A  List:2 entries
1 = Multiply
2 = Divide
RATERCOVER 63 Boolean Tax Reporting Rate Overridden E A  List:2 entries
0 = No
1 = Yes
RCURNDECML 64 Integer Tax Reporting Decimal Places E A 
DATEBUS 65 Date Posting Date E A 
VDACCTSET 66 String*6 Vendor Account Set E A  Mask: %-6N
IDN 67 String*30 Import Declaration Number E A 
CAXAMOUNT 68 BCD*10.3 Reverse Charges Total Amount E A 

This page was generated on 2023-Aug-31

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