Table: Order Details

Table: OEORDD
View: OE0500
Record Length: 1450

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: 152

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
REQUESDATE Date Date Requested

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