Table: Orders

Table: OEORDH1
View: OE0520
Record length: 668
Flags: A R 

Keys: 1

Title  Flags  Fields
Order Uniquifier Key  ORDUNIQ

Fields: 53

Field  Type  Title  Presentation 
ORDUNIQ  BCD*10.0  Order Uniquifier   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
AUTOTAXCAL  Boolean  Auto-Tax Calculation Status   
QUONUMBER  String*22  Originating Quote Number  Mask: %-22C
BILEMAIL  String*50  Bill-To E-mail   
BILPHONEC  String*30  Bill-To Contact Phone  Mask: %-30c
BILFAXC  String*30  Bill-To Contact Fax  Mask: %-30c
BILEMAILC  String*50  Bill-To Contact E-mail   
SHPEMAIL  String*50  Ship-To E-mail   
SHPPHONEC  String*30  Ship-To Contact Phone  Mask: %-30c
SHPFAXC  String*30  Ship-To Contact Fax  Mask: %-30c
SHPEMAILC  String*50  Ship-To Contact E-mail   
MULTIQUO  Boolean  Multiple Quotes  List: 2 entries
0=No
1=Yes
QUOS  Integer  Number of Quotes   
LASTSHINUM  String*22  Last Shipment Number  Mask: %-22C
NUMSHPMENT  Integer  Number of Shipments   
SHIPTRACK  String*36  Shipment Tracking Number   
VALUES  Long  Optional Fields   
FRMUNIQ  BCD*10.0  Predecessor Uniquifier   
FRMNUMBER  String*22  Predecessor Number  Mask: %-22C
ITEMDISTOT  BCD*10.3  Item Detail Discount Total   
MISCDISTOT  BCD*10.3  Misc. Charge Detail Discount Total   
OTRMETHOD  Integer  Auto-Calc. Tax Reporting Amounts   
OTRCURRNCY  String*3  Tax Reporting (TR) Currency  Mask: %-3N
OTRRATTYPE  String*2  TR Rate Type  Mask: %-2N
OTRRATDATE  Date  TR Rate Date   
OTRRATE  BCD*8.7  TR Rate   
OTRSPREAD  BCD*8.7  TR Spread   
OTRDATMTCH  Integer  TR Rate Date Matching   
OTRRATEOP  Integer  TR Rate Operator   
OTRRATOVER  Boolean  TR Rate Override Flag   
OTREAMNT1  BCD*10.3  TR Excluded Tax Amount 1   
OTREAMNT2  BCD*10.3  TR Excluded Tax Amount 2   
OTREAMNT3  BCD*10.3  TR Excluded Tax Amount 3   
OTREAMNT4  BCD*10.3  TR Excluded Tax Amount 4   
OTREAMNT5  BCD*10.3  TR Excluded Tax Amount 5   
OTRIAMNT1  BCD*10.3  TR Included Tax Amount 1   
OTRIAMNT2  BCD*10.3  TR Included Tax Amount 2   
OTRIAMNT3  BCD*10.3  TR Included Tax Amount 3   
OTRIAMNT4  BCD*10.3  TR Included Tax Amount 4   
OTRIAMNT5  BCD*10.3  TR Included Tax Amount 5   
DISAMTOVER  Boolean  Order Discount Amount Override   
JOBLINES  Long  Job Related Detail Lines   
LNINVABLE  Long  Invoiceable Detail Lines   
HASRTG  Boolean  Has Retainage  List: 2 entries
0=No
1=Yes
RTGTERMS  String*6  Retainage Terms  Mask: %-6N
RTGRATE  Integer  Retainage Exchange Rate  List: 2 entries
0=Use Original Document Exchange Rate
1=Use Current Exchange Rate
CUSACCTSET  String*6  Customer Account Set  Mask: %-6N
ENTEREDBY  String*8  Entered By  Mask: %-8N
PFSEGLEN  Integer  ePOS Segment Length   

This page was generated on 2009-Nov-19

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