Table: Orders

Table: OEORDH
View: OE0520
Record Length: 2549

Flags: A R 

Keys: 9

Title Flags Fields
Order Uniquifier Key ORDUNIQ
Order Number Key ORDNUMBER
Customer Number D M  CUSTOMER
Type/Complete M  TYPE, COMPLETE, ORDUNIQ
Customer/Order M  CUSTOMER, ORDNUMBER
Reference/Order M  REFERENCE, ORDNUMBER
Customer/PO No. D M  CUSTOMER, PONUMBER
Customer/OnHold/Type D M  CUSTOMER, ONHOLD, TYPE
Sage CRM Opportunity D M  COMPANYID, OPPOID

Fields: 169

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
COMPANYID Long Sage CRM Company ID
OPPOID Long Sage CRM Opportunity ID
PERSONID Long Sage CRM Person ID
INCOPPOTOT Boolean Include In CRM Opportunity Total
QTEXPIRED Boolean Quote Expired List:2 entries
0 = No
1 = Yes
QUOORDUNIQ BCD*10.0 Order Uniq. Activated From Quote
QUOORDNUM String*22 Order Number Activated From Quote Mask: %-22C

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