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

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