Table: Invoices

Table: OEINVH
View: OE0420
Record length: 3157
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: 210

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   

This page was generated on 2008-May-01

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