Table: Invoices

Table: OEINVH
View: OE0420
Record Length: 3325

Flags: A R 

Keys: 8

Title Flags Fields
Invoice Uniquifier INVUNIQ
Order Number/Invoice Number ORDNUMBER, INVNUMBER
I/C Day End Trans. Number DAYENDNUM
Customer Number D M  CUSTOMER
Customer/Invoice CUSTOMER, INVNUMBER
Reference/Invoice M  REFERENCE, INVNUMBER
Invoice Number INVNUMBER
Shipment Number/Invoice Number SHINUMBER, INVNUMBER

Fields: 214

Field Type Title Presentation
INVUNIQ BCD*10.0 Invoice Uniquifier
AUDTDATE Date
AUDTTIME Time
AUDTUSER String*8
AUDTORG String*6
ORDNUMBER String*22 Order Number Mask: %-22C
DAYENDNUM BCD*10.0 I/C Day End Trans. Number
CUSTOMER String*12 Customer Number Mask: %-12C
BILNAME String*60 Bill To
BILADDR1 String*60 Bill-To Address 1
BILADDR2 String*60 Bill-To Address 2
BILADDR3 String*60 Bill-To Address 3
BILADDR4 String*60 Bill-To Address 4
BILCITY String*30 Bill-To City
BILSTATE String*30 Bill-To State
BILZIP String*20 Bill-To Zip Code
BILCOUNTRY String*30 Bill-To Country
BILPHONE String*30 Bill-To Phone Mask: (%-3C) %-3C-%-24C
BILFAX String*30 Bill-To Fax Mask: (%-3C) %-3C-%-24C
BILCONTACT String*60 Bill-To Contact
SHIPTO String*6 Ship to Address Code Mask: %-6C
SHPNAME String*60 Ship To
SHPADDR1 String*60 Ship-To Address 1
SHPADDR2 String*60 Ship-To Address 2
SHPADDR3 String*60 Ship-To Address 3
SHPADDR4 String*60 Ship-To Address 4
SHPCITY String*30 Ship-To City
SHPSTATE String*30 Ship-To State
SHPZIP String*20 Ship-To Zip Code
SHPCOUNTRY String*30 Ship-To Country
SHPPHONE String*30 Ship-To Phone Mask: (%-3C) %-3C-%-24C
SHPFAX String*30 Ship-To Fax Mask: (%-3C) %-3C-%-24C
SHPCONTACT String*60 Ship-To Contact
CUSTDISC Integer Customer Discount Level List:6 entries
0 = Base
1 = A
2 = B
3 = C
4 = D
5 = E
PRICELIST String*6 Price List Code Mask: %-6N
PONUMBER String*22 Purchase Order Number Mask: %-22C
TERRITORY String*6 Territory Mask: %-6N
TERMS String*6 Terms Code Mask: %-6N
TERMTTLDUE BCD*10.3 Total Terms Amount Due
TERMOVERRD Boolean Terms Rate Override
REFERENCE String*60 Reference
ORDDATE Date Order Date
SHIPVIA String*6 Ship-Via Code Mask: %-6N
VIADESC String*60 Ship-Via Code Description
FOB String*60 Free On Board Point
TEMPLATE String*6 Template Code Mask: %-6N
LOCATION String*6 Location Mask: %-6N
DESC String*60 Description
COMMENT String*250 Comment
SHIPDATE Date Shipment Date
INVDATE Date Invoice Date
INVFISCYR String*4 Invoice Fiscal Year Mask: %-4d
INVFISCPER Integer Invoice 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
INVLINES Integer Number of Lines in Invoice
NUMLABELS Integer Number of Labels
NUMPAYMENT BCD*3.0 Number of Terms Payments
PAYMNTASOF Date Terms Payments As Of Date
INVWEIGHT BCD*10.4 Invoice Total Estimated Weight
NEXTDTLNUM Integer Next Detail Number
INVSTATUS Integer Invoice Status List:2 entries
1 = Document shipped not costed
2 = Document costed
INVPRINTED Boolean Invoice Printed List:2 entries
0 = No
1 = Yes
IDISONMISC Boolean Invoice Disc. on Misc. Charges
POSTDATE Date Posting Date
COMPDATE Date Completion Date
SHIPLABEL Boolean Requires Shipping Labels
LBLPRINTED Boolean Shipping Labels Printed
INVNETNOTX BCD*10.3 Invoice Total Before Tax
INVITAXTOT BCD*10.3 Invoice Included Tax Tot. Amount
INVITMTOT BCD*10.3 Invoice Item Total Amount
INVDISCBAS BCD*10.3 Invoice Discount Base
INVDISCPER BCD*5.5 Invoice Discount Percentage
INVDISCAMT BCD*10.3 Invoice Discount Amount
INVMISC BCD*10.3 Invoice Total Misc. Charges
INVSUBTOT BCD*10.3 Invoice Subtotal Amount
INVNET BCD*10.3 Invoice Total With Invoice Disc.
INVETAXTOT BCD*10.3 Invoice Excluded Tax Tot. Amount
INVNETWTX BCD*10.3 Invoice Total With Tax
INHOMECURR String*3 Invoice Home Currency Mask: %-3N
INRATETYPE String*2 Invoice Rate Type Mask: %-2N
INSOURCURR String*3 Invoice Source Currency Mask: %-3N
INRATEDATE Date Invoice Rate Date
INRATE BCD*8.7 Invoice Rate
INSPREAD BCD*8.7 Invoice Spread
INDATEMTCH Integer Invoice Rate Date Matching
INRATEREP Integer Invoice Rate Operator
INRATEOVER Boolean Invoice Rate Override Flag
SALESPER1 String*8 Salesperson 1 Mask: %-8N
SALESPER2 String*8 Salesperson 2 Mask: %-8N
SALESPER3 String*8 Salesperson 3 Mask: %-8N
SALESPER4 String*8 Salesperson 4 Mask: %-8N
SALESPER5 String*8 Salesperson 5 Mask: %-8N
SALESPLT1 BCD*5.5 Sales Percentage 1
SALESPLT2 BCD*5.5 Sales Percentage 2
SALESPLT3 BCD*5.5 Sales Percentage 3
SALESPLT4 BCD*5.5 Sales Percentage 4
SALESPLT5 BCD*5.5 Sales Percentage 5
TAXOVERRD Boolean Tax Overridden
TAXGROUP String*12 Tax Group Mask: %-12N
TAUTH1 String*12 Tax Authority 1 Mask: %-12N
TAUTH2 String*12 Tax Authority 2 Mask: %-12N
TAUTH3 String*12 Tax Authority 3 Mask: %-12N
TAUTH4 String*12 Tax Authority 4 Mask: %-12N
TAUTH5 String*12 Tax Authority 5 Mask: %-12N
TCLASS1 Integer Tax Class 1
TCLASS2 Integer Tax Class 2
TCLASS3 Integer Tax Class 3
TCLASS4 Integer Tax Class 4
TCLASS5 Integer Tax Class 5
TBASE1 BCD*10.3 Tax Base 1
TBASE2 BCD*10.3 Tax Base 2
TBASE3 BCD*10.3 Tax Base 3
TBASE4 BCD*10.3 Tax Base 4
TBASE5 BCD*10.3 Tax Base 5
TEAMOUNT1 BCD*10.3 Excluded Tax Amount 1
TEAMOUNT2 BCD*10.3 Excluded Tax Amount 2
TEAMOUNT3 BCD*10.3 Excluded Tax Amount 3
TEAMOUNT4 BCD*10.3 Excluded Tax Amount 4
TEAMOUNT5 BCD*10.3 Excluded Tax Amount 5
TIAMOUNT1 BCD*10.3 Included Tax Amount 1
TIAMOUNT2 BCD*10.3 Included Tax Amount 2
TIAMOUNT3 BCD*10.3 Included Tax Amount 3
TIAMOUNT4 BCD*10.3 Included Tax Amount 4
TIAMOUNT5 BCD*10.3 Included Tax Amount 5
TEXEMPT1 String*20 Registration 1
TEXEMPT2 String*20 Registration 2
TEXEMPT3 String*20 Registration 3
TEXEMPT4 String*20 Registration 4
TEXEMPT5 String*20 Registration 5
AUTOTAXCAL Boolean Auto-Tax Calculation Status
BILEMAIL String*50 Bill-To E-mail
BILPHONEC String*30 Bill-To Contact Phone Mask: (%-3C) %-3C-%-24C
BILFAXC String*30 Bill-To Contact Fax Mask: (%-3C) %-3C-%-24C
BILEMAILC String*50 Bill-To Contact E-mail
SHPEMAIL String*50 Ship-To E-mail
SHPPHONEC String*30 Ship-To Contact Phone Mask: (%-3C) %-3C-%-24C
SHPFAXC String*30 Ship-To Contact Fax Mask: (%-3C) %-3C-%-24C
SHPEMAILC String*50 Ship-To Contact E-mail
RECALCTAX Boolean Recalculate Tax
DISCAVAIL BCD*10.3 Discount Available
SHHOMECURR String*3 Shipment Home Currency Mask: %-3N
SHRATETYPE String*2 Shipment Rate Type Mask: %-2N
SHSOURCURR String*3 Shipment Source Currency Mask: %-3N
SHRATEDATE Date Shipment Rate Date
SHRATE BCD*8.7 Shipment Rate
SHSPREAD BCD*8.7 Shipment Spread
SHDATEMTCH Integer Shipment Rate Date Matching
SHRATEREP Integer Shipment Rate Operator
SHRATEOVER Boolean Shipment Rate Override Flag
SHINUMBER String*22 Shipment Number Mask: %-22C
MULTISHI Boolean Generate From Multiple Shipments List:2 entries
0 = No
1 = Yes
SHIS Integer From How Many Shipments
INVNUMBER String*22 Invoice Number Mask: %-22C
SHIPTRACK String*36 Shipment Tracking Number
OVERCREDIT Boolean Over Credit Limit
APPROVELMT BCD*10.3 Approved Limit
APPROVEBY String*8 Authorizing User ID Mask: %-8N
VALUES Long Optional Fields
SHIUNIQ BCD*10.0 Shipment Uniquifier
TERMDBWT BCD*10.3 Document Discount Base With Tax
TERMDBNT BCD*10.3 Document Discount Base w/o Tax
ITEMDISTOT BCD*10.3 Item Detail Discount Total
MISCDISTOT BCD*10.3 Misc. Charge Detail Discount Total
ITRMETHOD Integer Auto-Calc. Tax Reporting Amounts
ITRCURRNCY String*3 Tax Reporting (TR) Currency Mask: %-3N
ITRRATTYPE String*2 TR Rate Type Mask: %-2N
ITRRATDATE Date TR Rate Date
ITRRATE BCD*8.7 TR Rate
ITRSPREAD BCD*8.7 TR Spread
ITRDATMTCH Integer TR Rate Date Matching
ITRRATEOP Integer TR Rate Operator
ITRRATOVER Boolean TR Rate Override Flag
ITREAMNT1 BCD*10.3 TR Excluded Tax Amount 1
ITREAMNT2 BCD*10.3 TR Excluded Tax Amount 2
ITREAMNT3 BCD*10.3 TR Excluded Tax Amount 3
ITREAMNT4 BCD*10.3 TR Excluded Tax Amount 4
ITREAMNT5 BCD*10.3 TR Excluded Tax Amount 5
ITRIAMNT1 BCD*10.3 TR Included Tax Amount 1
ITRIAMNT2 BCD*10.3 TR Included Tax Amount 2
ITRIAMNT3 BCD*10.3 TR Included Tax Amount 3
ITRIAMNT4 BCD*10.3 TR Included Tax Amount 4
ITRIAMNT5 BCD*10.3 TR Included Tax Amount 5
STRCURRNCY String*3 Tax Reporting Shipment (TR) Currency Mask: %-3N
STRRATTYPE String*2 TR Shipment Rate Type Mask: %-2N
STRRATDATE Date TR Shipment Rate Date
STRRATE BCD*8.7 TR Shipment Rate
STRSPREAD BCD*8.7 TR Shipment Spread
STRDATMTCH Integer TR Shipment Rate Date Matching
STRRATEOP Integer TR Shipment Rate Operator
STRRATOVER Boolean TR Shipment Rate Override Flag
TAXVERSION Long Tax Version
DISAMTOVER Boolean Invoice Discount Amount Override
JOBLINES Long Job Related Detail Lines
HASRTG Boolean Has Retainage List:2 entries
0 = No
1 = Yes
RTGTERMS String*6 Retainage Terms Mask: %-6N
RTGAMOUNT BCD*10.3 Retainage Amount
RTGPERCENT BCD*5.5 Retainage Percent
RTGRATE Integer Retainage Exchange Rate List:2 entries
0 = Use Original Document Exchange Rate
1 = Use Current Exchange Rate
RTGTXBASE1 BCD*10.3 Retainage Tax Base 1
RTGTXBASE2 BCD*10.3 Retainage Tax Base 2
RTGTXBASE3 BCD*10.3 Retainage Tax Base 3
RTGTXBASE4 BCD*10.3 Retainage Tax Base 4
RTGTXBASE5 BCD*10.3 Retainage Tax Base 5
RTGTXAMT1 BCD*10.3 Retainage Tax Amount 1
RTGTXAMT2 BCD*10.3 Retainage Tax Amount 2
RTGTXAMT3 BCD*10.3 Retainage Tax Amount 3
RTGTXAMT4 BCD*10.3 Retainage Tax Amount 4
RTGTXAMT5 BCD*10.3 Retainage Tax Amount 5
CUSACCTSET String*6 Customer Account Set Mask: %-6N
ENTEREDBY String*8 Entered By Mask: %-8N
DATEBUS Date Posting Date
OPPOLINES Integer Sage CRM Opportunity Lines
EDN String*30 Export Declaration Number
SFPAURL String*100 Payments Acceptance URL
SFPAID String*36 Payments Acceptance ID

This page was generated on 2022-Aug-18

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