Table: Order Details

Table: OEORDD
View: OE0500
Record length: 1445
Flags: A R 

Keys: 7

Title  Flags  Fields
Uniq./Line Number  ORDUNIQ, LINENUM
Uniq./Detail Number  ORDUNIQ, DETAILNUM
Item/Exp. Shipment Date  M  ITEM, EXPDATE, ORDUNIQ, DETAILNUM
Exp. Shipment Date/Qty Ordered  D M  EXPDATE, DDTLTYPE, QTYORDERED, QTYBACKORD, ITEM, LOCATION
Exp. Shipment Date/Qty Committed  D M  EXPDATE, DDTLTYPE, QTYCOMMIT, ITEM, LOCATION
Item/DtlType/ExpDate/Loc/LineTyp  D M  ITEM, DDTLTYPE, EXPDATE, LOCATION, LINETYPE, COMPLETE
OrdUniq/Item/DtlType/ExpDate/Loc  D M  ORDUNIQ, ITEM, DDTLTYPE, EXPDATE, LOCATION, LINETYPE, COMPLETE

Fields: 151

Field  Type  Title  Presentation 
ORDUNIQ  BCD*10.0  Order Uniquifier   
LINENUM  Integer  Line Number   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
LINETYPE  Integer  Line Type  List: 2 entries
1=Item
2=Miscellaneous
ITEM  String*24  Item  Mask: %-24C
MISCCHARGE  String*6  Miscellaneous Charges Code  Mask: %-6N
DESC  String*60  Description   
ACCTSET  String*6  Item Account Set  Mask: %-6N
USERCOSTMD  Boolean  User-Specified Costing Method   
PRICELIST  String*6  Price List  Mask: %-6N
CATEGORY  String*6  Category  Mask: %-6N
LOCATION  String*6  Location  Mask: %-6N
PICKSEQ  String*10  Picking Sequence   
EXPDATE  Date  Expected Shipment Date   
STOCKITEM  Boolean  Stock Item   
QTYORDERED  BCD*10.4  Quantity Ordered   
QTYSHIPPED  BCD*10.4  Quantity Shipped   
QTYBACKORD  BCD*10.4  Quantity Backordered   
QTYSHPTODT  BCD*10.4  Quantity Shipped-to-date   
ORIGQTY  BCD*10.4  Original Quantity Ordered   
QTYPO  BCD*10.4  P/O Quantity Ordered   
ORDUNIT  String*10  Order Unit of Measure  Mask: %-10c
UNITCONV  BCD*10.6  Order Unit Conversion   
UNITPRICE  BCD*10.6  Order Unit Price   
PRICEOVER  Boolean  Price Override  List: 2 entries
0=No
1=Yes
UNITCOST  BCD*10.6  Order Unit Cost   
MOSTREC  BCD*10.6  Most Recent Unit Cost   
STDCOST  BCD*10.6  Standard Unit Cost   
COST1  BCD*10.6  Alternate Unit Cost 1   
COST2  BCD*10.6  Alternate Unit Cost 2   
UNITPRCDEC  Integer  Unit Price No. of Decimals   
PRICEUNIT  String*10  Pricing Unit of Measure  Mask: %-10c
PRIUNTPRC  BCD*10.6  Pricing Unit Price   
PRIUNTCONV  BCD*10.6  Pricing Unit Conversion   
PRIPERCENT  BCD*5.5  Price Discount Percentage   
PRIAMOUNT  BCD*10.3  Price Discount Amount   
BASEUNIT  String*10  Pricing Base Unit  Mask: %-10c
PRIBASPRC  BCD*10.6  Pricing Base Unit Price   
PRIBASCONV  BCD*10.6  Pricing Base Unit Conversion   
COSTUNIT  String*10  Costing Unit of Measure  Mask: %-10c
COSUNTCST  BCD*10.6  Costing Unit Cost   
COSUNTCONV  BCD*10.6  Costing Unit Conversion   
EXTOPRICE  BCD*10.3  Extended Order Amount   
EXTOCOST  BCD*10.3  Extended Order Cost   
EXTINVMISC  BCD*10.3  Extended Amount   
INVDISC  BCD*10.3  Order Discount Amount   
EXTICOST  BCD*10.3  Extended Detail Cost   
EXTOVER  Boolean  Extended Shipped Amt. Override   
UNITWEIGHT  BCD*10.4  Unit Weight   
EXTWEIGHT  BCD*10.4  Extended Weight   
COMPLETE  Integer  Detail Completed  List: 4 entries
0=Not completed
1=Completed/Not In Database
2=Completed
3=Processed by day end
ADDTOILOC  Boolean  Recognized In Item/Location   
SALESLOST  BCD*10.3  Lost Sales Amount   
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   
TINCLUDED1  Boolean  Tax Included 1   
TINCLUDED2  Boolean  Tax Included 2   
TINCLUDED3  Boolean  Tax Included 3   
TINCLUDED4  Boolean  Tax Included 4   
TINCLUDED5  Boolean  Tax Included 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   
TAMOUNT1  BCD*10.3  Tax Amount 1   
TAMOUNT2  BCD*10.3  Tax Amount 2   
TAMOUNT3  BCD*10.3  Tax Amount 3   
TAMOUNT4  BCD*10.3  Tax Amount 4   
TAMOUNT5  BCD*10.3  Tax Amount 5   
TRATE1  BCD*8.5  Tax Rate 1   
TRATE2  BCD*8.5  Tax Rate 2   
TRATE3  BCD*8.5  Tax Rate 3   
TRATE4  BCD*8.5  Tax Rate 4   
TRATE5  BCD*8.5  Tax Rate 5   
DETAILNUM  Integer  Detail Number   
COMMINST  Boolean  Use Comments/Instructions  List: 2 entries
0=No
1=Yes
GLNONSTKCR  String*45  Non-stock Clearing Account  Mask: %-45C
AVGCOST  BCD*10.6  Average Unit Cost   
LASTCOST  BCD*10.6  Last Unit Cost   
COPYDETAIL  Boolean  Copy This Detail Line  List: 2 entries
0=No
1=Yes
QUONUMBER  String*22  Quote Number  Mask: %-22C
QUODTLNUM  Integer  Quote Detail Line Number   
SHIPTRACK  String*36  Shipment Tracking Number   
SHIPVIA  String*6  Ship-Via Code  Mask: %-6N
VIADESC  String*60  Ship-Via Code Description   
DISCPER  BCD*5.5  Discount Percent   
QTYCOMMIT  BCD*10.4  Quantity Committed   
MANITEMNO  String*24  Manufacturer's Item Number  Mask: %-24C
CUSTITEMNO  String*24  Customer Item Number  Mask: %-24C
QTYTRUECOM  BCD*10.4  True Quantity Committed   
VALUES  Long  Optional Fields   
DDTLTYPE  Integer  Kitting/BOM  List: 3 entries
0=None
1=Kitting
2=BOM
DDTLNO  String*6  Kit/BOM Number  Mask: %-6N
BUILDQTY  BCD*10.4  BOM Build Qty.   
BUILDUNIT  String*10  BOM Build Unit  Mask: %-10c
BLDUNTCONV  BCD*10.6  BOM Build Unit Conversion   
FRMNUMBER  String*22  Predecessor Number  Mask: %-22C
NEXTCMPNUM  Long  Next Component Number   
EPOSPROMID  Integer  ePOS Promotion ID   
BASEWUNIT  String*10  Pricing Base Weight Unit   
WEIGHTUNIT  String*10  Order Weight UOM   
WEIGHTCONV  BCD*10.6  Order Weight Conversion Factor   
PRWGHTUNIT  String*10  Pricing Weight UOM   
PRWGHTCONV  BCD*10.6  Pricing Weight Conversion Factor   
PRIBASWCNV  BCD*10.6  Pricing Base Weight Conv. Factor   
DEFUWEIGHT  BCD*10.4  Def. Weight UOM Unit Weight   
DEFEXTWGHT  BCD*10.4  Def. Weight UOM Ext. Unit Weight   
PRPRICEBY  Integer  Price By  List: 2 entries
1=Quantity
2=Weight
NEEDPCHECK  Boolean  Price Check Pending   
CAPPROVEBY  String*8  Price Approved By  Mask: %-8N
HDRDISC  BCD*10.3  Header Discount   
OTRAMOUNT1  BCD*10.3  TR Tax Amount 1   
OTRAMOUNT2  BCD*10.3  TR Tax Amount 2   
OTRAMOUNT3  BCD*10.3  TR Tax Amount 3   
OTRAMOUNT4  BCD*10.3  TR Tax Amount 4   
OTRAMOUNT5  BCD*10.3  TR Tax Amount 5   
PSPRINTED  Boolean  Picking Slip Printed   
JOBRELATED  Boolean  Job Related   
CONTRACT  String*16  Contract Code  Mask: %-16C
PROJECT  String*16  Project Code  Mask: %-16N
CCATEGORY  String*16  Category Code  Mask: %-16N
COSTCLASS  Integer  Cost Class  List: 7 entries
0=
1=Labor
2=Material
3=Equipment
4=Subcontractor
5=Overhead
6=Miscellaneous
PROJSTYLE  Integer  Project Style  List: 3 entries
0=
1=Standard
2=Basic
PROJTYPE  Integer  Project Type  List: 4 entries
0=
1=Time and Materials
2=Fixed Price
3=Cost Plus
REVREC  Integer  Accounting Method  List: 9 entries
0=
1=Completed Project
2=Total Cost Percentage Complete
3=Labor Hours Percentage Complete
4=Billings and Costs
5=Project Percentage Complete
6=Category Percentage Complete
7=Completed Contract
8=Accrual-Basis
BILLTYPE  Integer  Billing Type  List: 4 entries
0=
1=Non-billable
2=Billable
3=No Charge
REVBILL  String*45  Revenue/Billing Account  Mask: %-45C
COGSWIP  String*45  COGS/WIP Account  Mask: %-45C
RTGPERCENT  BCD*5.5  Retainage Percent   
RTGDAYS  Integer  Retainage Days   
PRICEOPT  Integer  Default O/E Price  List: 4 entries
0=
1=Billing Rate
2=Use Customer Price List
3=Use Specified Price List
ARITEMNO  String*16  A/R Item Number  Mask: %-16C
ARUNIT  String*10  A/R Item Unit  Mask: %-10C
PAYMNTDIST  BCD*10.3  Prepayment Distributed   
SERIALQTY  Long  Serial Quantity   
LOTQTY  BCD*10.4  Lot Quantity   
SQTYMOVED  Long  Serial Qty. Shipped   
LQTYMOVED  BCD*10.4  Lot Qty. Shipped   
SLITEM  Integer  Item Serialized/Lotted?  List: 4 entries
0=None
1=Serialized
2=Lotted
3=Both

This page was generated on 2009-Nov-19

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