Table: Orders

Table: OEORDH
View: OE0520
Record length: 2501
Flags: A R 

Keys: 8

Title  Flags  Fields

Order Uniquifier Key  ORDUNIQ
Order Number Key  ORDNUMBER
Customer Number  D M  CUSTOMER
Type/Complete  M  TYPE, COMPLETE, ORDUNIQ
Customer/Order  CUSTOMER, ORDNUMBER
Reference/Order  M  REFERENCE, ORDNUMBER
Customer/PO No.  D M  CUSTOMER, PONUMBER
Customer/Type  D M  CUSTOMER, TYPE

Fields: 162

Field  Type  Title  Presentation 

ORDUNIQ  BCD*10.0  Order Uniquifier   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
ORDNUMBER  String*22  Order Number  Mask: %-22C
CUSTOMER  String*12  Customer Number  Mask: %-12C
CUSTGROUP  String*6  Customer Group Code  Mask: %-6C
BILNAME  String*60  Bill-To Name   
BILADDR1  String*60  Bill-To Address Line 1   
BILADDR2  String*60  Bill-To Address Line 2   
BILADDR3  String*60  Bill-To Address Line 3   
BILADDR4  String*60  Bill-To Address Line 4   
BILCITY  String*30  Bill-To City   
BILSTATE  String*30  Bill-To State/Province   
BILZIP  String*20  Bill-To Zip/Postal Code   
BILCOUNTRY  String*30  Bill-To Country   
BILPHONE  String*30  Bill-To Phone Number  Mask: (%-3C) %-3C-%-24C
BILFAX  String*30  Bill-To Fax Number  Mask: (%-3C) %-3C-%-24C
BILCONTACT  String*60  Bill-To Contact   
SHIPTO  String*6  Ship-To Location Code  Mask: %-6C
SHPNAME  String*60  Ship-To Name   
SHPADDR1  String*60  Ship-To Address Line 1   
SHPADDR2  String*60  Ship-To Address Line 2   
SHPADDR3  String*60  Ship-To Address Line 3   
SHPADDR4  String*60  Ship-To Address Line 4   
SHPCITY  String*30  Ship-To City   
SHPSTATE  String*30  Ship-To State/Province   
SHPZIP  String*20  Ship-To Zip/Postal Code   
SHPCOUNTRY  String*30  Ship-To Country   
SHPPHONE  String*30  Ship-To Phone Number  Mask: (%-3C) %-3C-%-24C
SHPFAX  String*30  Ship-To Fax Number  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  Default 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   
DISCAVAIL  BCD*10.3  Discount Available   
TERMOVERRD  Boolean  Terms Rate Override   
REFERENCE  String*60  Order Reference   
TYPE  Integer  Order Type  List: 4 entries
1=Active
2=Future
3=Standing
4=Quote
ORDDATE  Date  Order Date   
EXPDATE  Date  Expected Ship Date   
QTEXPDATE  Date  Quote Expiration Date   
ORDFISCYR  String*4  Order Fiscal Year  Mask: %-4d
ORDFISCPER  Integer  Order 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
SHIPVIA  String*6  Ship-Via Code  Mask: %-6N
VIADESC  String*60  Ship-Via Code Description   
LASTINVNUM  String*22  Last Invoice Number  Mask: %-22C
NUMINVOICE  Integer  Number of Invoices   
FOB  String*60  Free On Board Point   
TEMPLATE  String*6  Template Code  Mask: %-6N
LOCATION  String*6  Default Location Code  Mask: %-6N
ONHOLD  Boolean  On Hold  List: 2 entries
0=No
1=Yes
DESC  String*60  Order Description   
COMMENT  String*250  Order Comment   
PRINTSTAT  Integer  Order Print Status  List: 5 entries
1=
2=Quote printed
3=Picking slip printed
0=Internet
-1=Electronic Commerce
LASTPOST  Date  Last Posting Date   
ORNOPREPAY  Integer  Order No. of Prepayments   
OVERCREDIT  Boolean  Over Credit Limit   
APPROVELMT  BCD*10.3  Approved Limit   
APPROVEBY  String*8  Authorizing User ID  Mask: %-8N
SHIPLABEL  Boolean  Requires Shipping Labels   
LBLPRINTED  Boolean  Shipping Labels Printed   
ORHOMECURR  String*3  Order Home Currency  Mask: %-3N
ORRATETYPE  String*2  Order Rate Type  Mask: %-2N
ORSOURCURR  String*3  Order Source Currency  Mask: %-3N
ORRATEDATE  Date  Order Rate Date   
ORRATE  BCD*8.7  Order Rate   
ORSPREAD  BCD*8.7  Order Spread   
ORDATEMTCH  Integer  Order Rate Date Matching   
ORRATEREP  Integer  Order Rate Operator   
ORRATEOVER  Boolean  Order Rate Override Flag   
ORDTOTAL  BCD*10.3  Total Amt. Items   
ORDMTOTAL  BCD*10.3  Total Amt. Misc. Charges   
ORDLINES  Integer  Number of Lines on Order   
NUMLABELS  Integer  Number of Labels   
ORDPAYTOT  BCD*10.3  Prev. Payments Total   
ORDPYDSTOT  BCD*10.3  Prev. Payment Disc. Total   
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   
RECALCTAX  Boolean  Recalculate Tax   
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   
COMPLETE  Integer  Order Completed  List: 5 entries
1=Incomplete/Not Included
2=Incomplete/Included
3=Complete/Not Included
4=Complete/Included
5=Complete/Day End
COMPDATE  Date  Order Completion Date   
INVNUMBER  String*22  Invoice Number  Mask: %-22C
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
NUMPAYMENT  BCD*3.0  No. of Terms Payments   
PAYMNTASOF  Date  Terms Payments As Of Date   
INVWEIGHT  BCD*10.4  Order Total Est. Weight   
NEXTDTLNUM  Integer  Next Detail Number   
POSTINV  Boolean  Post Invoice   
IDISONMISC  Boolean  Invoice Disc. Misc. Charges   
INNOPREPAY  Integer  Invoice No. of Prepayments   
NOSHIPLINE  Integer  No. Lines Qty. Shipped   
NOMISCLINE  Integer  No. Misc. Charges Lines   
INVNETNOTX  BCD*10.3  Order Total Before Tax   
INVITAXTOT  BCD*10.3  Order Incl. Tax Total   
INVITMTOT  BCD*10.3  Order Item Total Amount   
INVDISCBAS  BCD*10.3  Order Discount Base   
INVDISCPER  BCD*5.5  Order Discount Percentage   
INVDISCAMT  BCD*10.3  Order Discount Amount   
INVMISC  BCD*10.3  Order Total Misc. Charges   
INVSUBTOT  BCD*10.3  Order Subtotal Amount   
INVNET  BCD*10.3  Order Total With Inv. Disc.   
INVETAXTOT  BCD*10.3  Order Excl. Tax Total   
INVNETWTX  BCD*10.3  Order Total   
INVAMTDUE  BCD*10.3  Order Amount Due   
INHOMECURR  String*3  Order Home Currency  Mask: %-3N
INRATETYPE  String*2  Order Rate Type  Mask: %-2N
INSOURCURR  String*3  Order Source Currency  Mask: %-3N
INRATEDATE  Date  Order Rate Date   
INRATE  BCD*8.7  Order Rate   
INSPREAD  BCD*8.7  Order Spread   
INDATEMTCH  Integer  Order Rate Date Matching   
INRATEREP  Integer  Order Rate Operator   
INRATEOVER  Boolean  Order Rate Override Flag   
ORDERSOURC  Integer  Order Source  List: 4 entries
0=Entered
1=Internet
2=Electronic Commerce
3=ePOS

This page was generated on 2008-May-01

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