Table: Invoices

Table: POINVH1
View: PO0420
Record Length: 2641

Flags: A R 

Keys: 7

Title Flags Fields
Master Key INVHSEQ
Invoices D  INVNUMBER
Receipts D  RCPNUMBER
Vendor VDCODE, INVHSEQ
Returns D  RETNUMBER
Receipt Sequence D  RCPHSEQ
Vendor Document Number D M  VDCODE, INVNUMBER

Fields: 210

Field Type Title Presentation
INVHSEQ BCD*10.0 Invoice Sequence Key
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
NEXTLSEQ BCD*10.0 Next Line Sequence
LINES Long Lines
LINESCMPL Long Lines Complete
COSTS Long Costs
COSTSCMPL Long Costs Complete
PAYMENTS Long Payments
TAXLINES Long Lines Tax Calculation Sees
TAXAUTOCAL Boolean Auto. tax calculation on save List:2 entries
0 = No
1 = Yes
ISCOMPLETE Boolean Completed List:2 entries
0 = No
1 = Yes
DTCOMPLETE Date Date Completed
POSTDATE Date Last Posting Date
PORHSEQ BCD*10.0 Purchase Order Sequence Key
PONUMBER String*22 Purchase Order Number Mask: %-22C
DATE Date Invoice Date
FISCYEAR String*4 Fiscal Year Mask: %4D
FISCPERIOD Integer Fiscal Period List:12 entries
1 = 1
2 = 2
3 = 3
4 = 4
5 = 5
6 = 6
7 = 7
8 = 8
9 = 9
10 = 10
11 = 11
12 = 12
INVNUMBER String*22 Invoice Number Mask: %-22C
VDCODE String*12 Vendor Mask: %-12C
VDEXISTS Boolean Vendor Exists List:2 entries
0 = No
1 = Yes
VDNAME String*60 Name
VDADDRESS1 String*60 Address 1
VDADDRESS2 String*60 Address 2
VDADDRESS3 String*60 Address 3
VDADDRESS4 String*60 Address 4
VDCITY String*30 City
VDSTATE String*30 State/Province
VDZIP String*20 Zip/Postal Code
VDCOUNTRY String*30 Country
VDPHONE String*30 Phone Number Mask: (%-3C) %-3C-%-24C
VDFAX String*30 Fax Number Mask: (%-3C) %-3C-%-24C
VDCONTACT String*60 Contact
TERMSCODE String*6 Terms Code Mask: %-6N
FROMDOC Integer From Document List:2 entries
3 = Receipt
4 = Return
FORPRIMARY Integer Primary Vendor List:3 entries
1 = Primary Vendor
2 = Secondary Vendor
3 = New Vendor
RCPHSEQ BCD*10.0 Receipt Sequence Key
RCPNUMBER String*22 Receipt Number Mask: %-22C
RCPDATE Date Receipt Date
RETHSEQ BCD*10.0 Return Sequence Key
RETNUMBER String*22 Return Number Mask: %-22C
RETDATE Date Return Date
DESCRIPTIO String*60 Description
REFERENCE String*60 Reference
COMMENT String*250 Comment
CURRENCY String*3 Currency Mask: %-3N
RATE BCD*8.7 Exchange Rate
SPREAD BCD*8.7 Rate Spread
RATETYPE String*2 Rate Type Mask: %-2N
RATEMATCH Integer Rate Match Type
RATEDATE Date Rate Date
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
DTPYMTASOF Date Payment As Of Date
TERMDUEAMT BCD*10.3 Total Terms Amount Due
EXTWEIGHT BCD*10.4 Extended Weight
EXTENDED BCD*10.3 Extended Cost
DOCTOTAL BCD*10.3 Total
AMOUNT BCD*10.3 Additional Costs
RQRECEIVED BCD*10.4 Quantity Received
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
TAXBASE1 BCD*10.3 Tax Base 1
TAXBASE2 BCD*10.3 Tax Base 2
TAXBASE3 BCD*10.3 Tax Base 3
TAXBASE4 BCD*10.3 Tax Base 4
TAXBASE5 BCD*10.3 Tax Base 5
TXINCLUDE1 BCD*10.3 Included Tax Amount 1
TXINCLUDE2 BCD*10.3 Included Tax Amount 2
TXINCLUDE3 BCD*10.3 Included Tax Amount 3
TXINCLUDE4 BCD*10.3 Included Tax Amount 4
TXINCLUDE5 BCD*10.3 Included Tax Amount 5
TXEXCLUDE1 BCD*10.3 Excluded Tax Amount 1
TXEXCLUDE2 BCD*10.3 Excluded Tax Amount 2
TXEXCLUDE3 BCD*10.3 Excluded Tax Amount 3
TXEXCLUDE4 BCD*10.3 Excluded Tax Amount 4
TXEXCLUDE5 BCD*10.3 Excluded Tax Amount 5
TAXAMOUNT1 BCD*10.3 Tax Amount 1
TAXAMOUNT2 BCD*10.3 Tax Amount 2
TAXAMOUNT3 BCD*10.3 Tax Amount 3
TAXAMOUNT4 BCD*10.3 Tax Amount 4
TAXAMOUNT5 BCD*10.3 Tax Amount 5
TXRECVAMT1 BCD*10.3 Tax Recoverable Amount 1
TXRECVAMT2 BCD*10.3 Tax Recoverable Amount 2
TXRECVAMT3 BCD*10.3 Tax Recoverable Amount 3
TXRECVAMT4 BCD*10.3 Tax Recoverable Amount 4
TXRECVAMT5 BCD*10.3 Tax Recoverable Amount 5
TXEXPSAMT1 BCD*10.3 Tax Expense Amount 1
TXEXPSAMT2 BCD*10.3 Tax Expense Amount 2
TXEXPSAMT3 BCD*10.3 Tax Expense Amount 3
TXEXPSAMT4 BCD*10.3 Tax Expense Amount 4
TXEXPSAMT5 BCD*10.3 Tax Expense Amount 5
TXALLOAMT1 BCD*10.3 Tax Allocated Amount 1
TXALLOAMT2 BCD*10.3 Tax Allocated Amount 2
TXALLOAMT3 BCD*10.3 Tax Allocated Amount 3
TXALLOAMT4 BCD*10.3 Tax Allocated Amount 4
TXALLOAMT5 BCD*10.3 Tax Allocated Amount 5
TXBASEALLO BCD*10.3 Net of Tax
TXINCLUDED BCD*10.3 Tax Included
TXEXCLUDED BCD*10.3 Tax Excluded
TAXAMOUNT BCD*10.3 Total Tax
TXRECVAMT BCD*10.3 Total Tax Recoverable
TXEXPSAMT BCD*10.3 Total Tax Expensed
TXALLOAMT BCD*10.3 Total Tax Allocated
F1099CLASS String*6 1099/CPRS Class Mask: %-6N
F1099AMT BCD*10.3 The 1099/CPRS Amount
MPRORATED BCD*10.3 Manual Proration Total
MTOPRORATE BCD*10.3 Manual To Prorate
MEXPENSED BCD*10.3 Manual Proration Expensed
SCAMOUNT BCD*10.3 Conversion Source Amount
FCAMOUNT BCD*10.3 Conversion Functional Amount
MULTIRCP Boolean Multiple Receipts List:2 entries
0 = No
1 = Yes
RCPS Long Receipts
VDEMAIL String*50 E-mail
VDPHONEC String*30 Contact Phone Mask: (%-3C) %-3C-%-24C
VDFAXC String*30 Contact Fax Mask: (%-3C) %-3C-%-24C
VDEMAILC String*50 Contact E-mail
DISCPCT BCD*5.5 Discount Percentage
DISCOUNT BCD*10.3 Discount Amount
VALUES Long Optional Fields
ONHOLD Boolean On Hold List:2 entries
0 = No
1 = Yes
TERMDBWT BCD*10.3 Payment Discount Base With Tax
TERMDBNT BCD*10.3 Payment Discount Base Without Tax
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
RTGTERMS String*6 Retainage Terms Code Mask: %-6N
RTGAMOUNT BCD*10.3 Retainage Amount
JOBLINES Long Job Related Lines
JOBCOSTS Long Job Related Costs
TRCURRENCY String*3 Tax Reporting Currency Mask: %-3N
RATERC BCD*8.7 Tax Reporting Exchange Rate
SPREADRC BCD*8.7 Tax Reporting Rate Spread
RATETYPERC String*2 Tax Reporting Rate Type Mask: %-2N
RATEMTCHRC Integer Tax Reporting Rate Match Type
RATEDATERC Date Tax Reporting Rate Date
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
TARAMOUNT1 BCD*10.3 Tax Reporting Amount 1
TARAMOUNT2 BCD*10.3 Tax Reporting Amount 2
TARAMOUNT3 BCD*10.3 Tax Reporting Amount 3
TARAMOUNT4 BCD*10.3 Tax Reporting Amount 4
TARAMOUNT5 BCD*10.3 Tax Reporting Amount 5
TRINCLUDE1 BCD*10.3 Tax Reporting Included Amount 1
TRINCLUDE2 BCD*10.3 Tax Reporting Included Amount 2
TRINCLUDE3 BCD*10.3 Tax Reporting Included Amount 3
TRINCLUDE4 BCD*10.3 Tax Reporting Included Amount 4
TRINCLUDE5 BCD*10.3 Tax Reporting Included Amount 5
TREXCLUDE1 BCD*10.3 Tax Reporting Excluded Amount 1
TREXCLUDE2 BCD*10.3 Tax Reporting Excluded Amount 2
TREXCLUDE3 BCD*10.3 Tax Reporting Excluded Amount 3
TREXCLUDE4 BCD*10.3 Tax Reporting Excluded Amount 4
TREXCLUDE5 BCD*10.3 Tax Reporting Excluded Amount 5
TRRECVAMT1 BCD*10.3 Tax Reporting Recoverable Amt. 1
TRRECVAMT2 BCD*10.3 Tax Reporting Recoverable Amt. 2
TRRECVAMT3 BCD*10.3 Tax Reporting Recoverable Amt. 3
TRRECVAMT4 BCD*10.3 Tax Reporting Recoverable Amt. 4
TRRECVAMT5 BCD*10.3 Tax Reporting Recoverable Amt. 5
TREXPSAMT1 BCD*10.3 Tax Reporting Expense Amount 1
TREXPSAMT2 BCD*10.3 Tax Reporting Expense Amount 2
TREXPSAMT3 BCD*10.3 Tax Reporting Expense Amount 3
TREXPSAMT4 BCD*10.3 Tax Reporting Expense Amount 4
TREXPSAMT5 BCD*10.3 Tax Reporting Expense Amount 5
TRALLOAMT1 BCD*10.3 Tax Reporting Allocated Amount 1
TRALLOAMT2 BCD*10.3 Tax Reporting Allocated Amount 2
TRALLOAMT3 BCD*10.3 Tax Reporting Allocated Amount 3
TRALLOAMT4 BCD*10.3 Tax Reporting Allocated Amount 4
TRALLOAMT5 BCD*10.3 Tax Reporting Allocated Amount 5
RTGTAXREP Integer Report Retainage Tax List:2 entries
0 = At Time of Original Document
1 = As Per Tax Authority
TAXVERSION Long Tax State Version
RAXBASE1 BCD*10.3 Retainage Tax Base 1
RAXBASE2 BCD*10.3 Retainage Tax Base 2
RAXBASE3 BCD*10.3 Retainage Tax Base 3
RAXBASE4 BCD*10.3 Retainage Tax Base 4
RAXBASE5 BCD*10.3 Retainage Tax Base 5
RAXAMOUNT1 BCD*10.3 Retainage Tax Amount 1
RAXAMOUNT2 BCD*10.3 Retainage Tax Amount 2
RAXAMOUNT3 BCD*10.3 Retainage Tax Amount 3
RAXAMOUNT4 BCD*10.3 Retainage Tax Amount 4
RAXAMOUNT5 BCD*10.3 Retainage Tax Amount 5
RXRECVAMT1 BCD*10.3 Retainage Tax Recoverable Amt. 1
RXRECVAMT2 BCD*10.3 Retainage Tax Recoverable Amt. 2
RXRECVAMT3 BCD*10.3 Retainage Tax Recoverable Amt. 3
RXRECVAMT4 BCD*10.3 Retainage Tax Recoverable Amt. 4
RXRECVAMT5 BCD*10.3 Retainage Tax Recoverable Amt. 5
RXEXPSAMT1 BCD*10.3 Retainage Tax Expense Amount 1
RXEXPSAMT2 BCD*10.3 Retainage Tax Expense Amount 2
RXEXPSAMT3 BCD*10.3 Retainage Tax Expense Amount 3
RXEXPSAMT4 BCD*10.3 Retainage Tax Expense Amount 4
RXEXPSAMT5 BCD*10.3 Retainage Tax Expense Amount 5
RXALLOAMT1 BCD*10.3 Retainage Tax Allocated Amount 1
RXALLOAMT2 BCD*10.3 Retainage Tax Allocated Amount 2
RXALLOAMT3 BCD*10.3 Retainage Tax Allocated Amount 3
RXALLOAMT4 BCD*10.3 Retainage Tax Allocated Amount 4
RXALLOAMT5 BCD*10.3 Retainage Tax Allocated Amount 5

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