Table: Invoice Audit Headers

Table: POINVAH
View: PO0409
Record Length: 644

Flags: A R 

Keys: 4

Title Flags Fields

Master Key DAYENDSEQINVAHSEQ
Vendor VENDORDAYENDSEQINVAHSEQ
Transaction Date TRANSDATEDAYENDSEQINVAHSEQ
Document Number INVNUMBERDAYENDSEQINVAHSEQ

Fields: 72

Field Type Title Presentation

DAYENDSEQ BCD*10.0 Day End Number
INVAHSEQ 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
INVHSEQ BCD*10.0 Invoice 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 = Invoice
2 = Invoice Adjustment
99 = Sequence Placeholder (?)
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
INVNUMBER String*22 Invoice Number
PONUMBER String*22 Purchase Order Number
RCPNUMBER String*22 Receipt Number
RCPCURR 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
MULTIRCP Boolean Multiple Receipts 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
TRANSNUM BCD*10.0 Transaction Number
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
IDN String*30 Import Declaration Number
CAXAMOUNT BCD*10.3 Reverse Charges Total Amount