View: Order Details

RotoID: OE0500
Table: OEORDD
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:OEORDD

Compositions: 6

RotoID Tables Title DLL
OE0520 OEORDHOEORDH1 Orders OEORDH
OE0501 OEORDDO Order Detail Optional Fields OEORDDO
OE0503 OEORDDB Order BOM Details OEORDDB
OE0502 OEORDDD Order Kitting Details OEORDDD
OE0508 OEORDDS Order Detail Serial Numbers OEORDDS
OE0507 OEORDDL Order Detail Lot Numbers OEORDDL

Keys: 7

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

Fields: 213

Field Index Type Title Attributes Presentation
ORDUNIQ 1 BCD*10.0 Order Uniquifier E A K R 
LINENUM 2 Integer Line Number E A K R 
LINETYPE 3 Integer Line Type E A X  List:2 entries
1 = Item
2 = Miscellaneous
ITEM 4 String*24 Item E A P X  Mask: %-24C
MISCCHARGE 5 String*6 Miscellaneous Charges Code E A X  Mask: %-6N
DESC 6 String*60 Description E A X 
ACCTSET 7 String*6 Item Account Set E A X  Mask: %-6N
USERCOSTMD 8 Boolean User-Specified Costing Method E A X 
PRICELIST 9 String*6 Price List E A X  Mask: %-6N
CATEGORY 10 String*6 Category E A X  Mask: %-6N
LOCATION 11 String*6 Location E A X  Mask: %-6N
PICKSEQ 12 String*10 Picking Sequence E A X 
EXPDATE 13 Date Expected Shipment Date E A X 
STOCKITEM 14 Boolean Stock Item E A X 
QTYORDERED 15 BCD*10.4 Quantity Ordered E A X 
QTYSHIPPED 16 BCD*10.4 Quantity Shipped E A X 
QTYBACKORD 17 BCD*10.4 Quantity Backordered E A X 
QTYSHPTODT 18 BCD*10.4 Quantity Shipped-to-date E A C 
ORIGQTY 19 BCD*10.4 Original Quantity Ordered E A C 
QTYPO 20 BCD*10.4 P/O Quantity Ordered E A C 
ORDUNIT 21 String*10 Order Unit of Measure E A X  Mask: %-10c
UNITCONV 22 BCD*10.6 Order Unit Conversion E A C 
UNITPRICE 23 BCD*10.6 Order Unit Price E A C 
PRICEOVER 24 Boolean Price Override E A C  List:2 entries
0 = No
1 = Yes
UNITCOST 25 BCD*10.6 Order Unit Cost E A C 
MOSTREC 26 BCD*10.6 Most Recent Unit Cost E A C 
STDCOST 27 BCD*10.6 Standard Unit Cost E A C 
COST1 28 BCD*10.6 Alternate Unit Cost 1 E A C 
COST2 29 BCD*10.6 Alternate Unit Cost 2 E A C 
UNITPRCDEC 30 Integer Unit Price No. of Decimals E A C 
PRICEUNIT 31 String*10 Pricing Unit of Measure E A C  Mask: %-10c
PRIUNTPRC 32 BCD*10.6 Pricing Unit Price E A X 
PRIUNTCONV 33 BCD*10.6 Pricing Unit Conversion E A C 
PRIPERCENT 34 BCD*5.5 Price Discount Percentage E A C 
PRIAMOUNT 35 BCD*10.3 Price Discount Amount E A C 
BASEUNIT 36 String*10 Pricing Base Unit E A C  Mask: %-10c
PRIBASPRC 37 BCD*10.6 Pricing Base Unit Price E A C 
PRIBASCONV 38 BCD*10.6 Pricing Base Unit Conversion E A C 
COSTUNIT 39 String*10 Costing Unit of Measure E A C  Mask: %-10c
COSUNTCST 40 BCD*10.6 Costing Unit Cost E A X 
COSUNTCONV 41 BCD*10.6 Costing Unit Conversion E A C 
EXTOPRICE 42 BCD*10.3 Extended Order Amount E A C 
EXTOCOST 43 BCD*10.3 Extended Order Cost E A C X 
EXTINVMISC 44 BCD*10.3 Extended Amount E A X 
INVDISC 45 BCD*10.3 Order Discount Amount E A X 
EXTICOST 46 BCD*10.3 Extended Detail Cost E A C 
EXTOVER 47 Boolean Extended Shipped Amt. Override E A C 
UNITWEIGHT 48 BCD*10.4 Unit Weight E A X 
EXTWEIGHT 49 BCD*10.4 Extended Weight E A X 
COMPLETE 50 Integer Detail Completed E A C X  List:4 entries
0 = Not completed
1 = Completed/Not In Database
2 = Completed
3 = Processed by day end
ADDTOILOC 51 Boolean Recognized In Item/Location E A C 
SALESLOST 52 BCD*10.3 Lost Sales Amount E A C 
TAUTH1 53 String*12 Tax Authority 1 E A C  Mask: %-12N
TAUTH2 54 String*12 Tax Authority 2 E A C  Mask: %-12N
TAUTH3 55 String*12 Tax Authority 3 E A C  Mask: %-12N
TAUTH4 56 String*12 Tax Authority 4 E A C  Mask: %-12N
TAUTH5 57 String*12 Tax Authority 5 E A C  Mask: %-12N
TCLASS1 58 Integer Tax Class 1 E A X 
TCLASS2 59 Integer Tax Class 2 E A X 
TCLASS3 60 Integer Tax Class 3 E A X 
TCLASS4 61 Integer Tax Class 4 E A X 
TCLASS5 62 Integer Tax Class 5 E A X 
TINCLUDED1 63 Boolean Tax Included 1 E A X 
TINCLUDED2 64 Boolean Tax Included 2 E A X 
TINCLUDED3 65 Boolean Tax Included 3 E A X 
TINCLUDED4 66 Boolean Tax Included 4 E A X 
TINCLUDED5 67 Boolean Tax Included 5 E A X 
TBASE1 68 BCD*10.3 Tax Base 1 E A X 
TBASE2 69 BCD*10.3 Tax Base 2 E A X 
TBASE3 70 BCD*10.3 Tax Base 3 E A X 
TBASE4 71 BCD*10.3 Tax Base 4 E A X 
TBASE5 72 BCD*10.3 Tax Base 5 E A X 
TAMOUNT1 73 BCD*10.3 Tax Amount 1 E A X 
TAMOUNT2 74 BCD*10.3 Tax Amount 2 E A X 
TAMOUNT3 75 BCD*10.3 Tax Amount 3 E A X 
TAMOUNT4 76 BCD*10.3 Tax Amount 4 E A X 
TAMOUNT5 77 BCD*10.3 Tax Amount 5 E A X 
TRATE1 78 BCD*8.5 Tax Rate 1 E A C 
TRATE2 79 BCD*8.5 Tax Rate 2 E A C 
TRATE3 80 BCD*8.5 Tax Rate 3 E A C 
TRATE4 81 BCD*8.5 Tax Rate 4 E A C 
TRATE5 82 BCD*8.5 Tax Rate 5 E A C 
DETAILNUM 84 Integer Detail Number E A 
COMMINST 86 Boolean Use Comments/Instructions E A X  List:2 entries
0 = No
1 = Yes
EXTOMOSTRE 87 BCD*10.3 Total Order Most Recent Cost A C 
EXTOSTDCOS 88 BCD*10.3 Total Order Standard Cost A C 
EXTOCOST1 89 BCD*10.3 Total Order Cost 1 A C 
EXTOCOST2 90 BCD*10.3 Total Order Cost 2 A C 
EXTIMOSTRE 91 BCD*10.3 Total Invoice Most Recent Cost A C 
EXTISTDCOS 92 BCD*10.3 Total Invoice Standard Cost A C 
EXTICOST1 93 BCD*10.3 Total Invoice Cost 1 A C 
EXTICOST2 94 BCD*10.3 Total Invoice Cost 2 A C 
PCODDESC 95 String*60 Price List Description E A 
CATGDESC 96 String*60 Category Description E A 
LOCDESC 97 String*60 Location Description E A 
TAUTH1DESC 98 String*60 Tax Authority 1 Description E A C 
TAUTH2DESC 99 String*60 Tax Authority 2 Description E A C 
TAUTH3DESC 100 String*60 Tax Authority 3 Description E A C 
TAUTH4DESC 101 String*60 Tax Authority 4 Description E A C 
TAUTH5DESC 102 String*60 Tax Authority 5 Description E A C 
TCLAS1DESC 103 String*60 Tax Class 1 Description E A C 
TCLAS2DESC 104 String*60 Tax Class 2 Description E A C 
TCLAS3DESC 105 String*60 Tax Class 3 Description E A C 
TCLAS4DESC 106 String*60 Tax Class 4 Description E A C 
TCLAS5DESC 107 String*60 Tax Class 5 Description E A C 
DRIVENBYUI 108 Boolean Driven by UI E A 
NEGINVENT 109 Boolean Found Negative Inventory E A 
GLNONSTKCR 110 String*45 Non-stock Clearing Account E A X  Mask: %-45C
GLNONSTKCD 111 String*60 Non-stock Clearing Acct. Desc. E A 
IPCID 112 Long Inter-process Comm. ID E A 
FPOPSNQO 113 Boolean Force Pop-up SN on Qty. Ordered E A  List:2 entries
0 = No
1 = Yes
FPOPSNQS 114 Boolean Force Pop-up SN on Qty. Shipped E A  List:2 entries
0 = No
1 = Yes
POPUPSN 115 Integer Pop-up SN E A  List:2 entries
0 = No
1 = Yes
CLOSESN 116 Boolean Close SN E A  List:2 entries
0 = No
1 = Yes
LTSETID 117 Long LT Set ID E A 
FPOPLTQO 118 Boolean Force Pop-up LT on Qty. Ordered E A  List:2 entries
0 = No
1 = Yes
FPOPLTQS 119 Boolean Force Pop-up LT on Qty. Shipped E A  List:2 entries
0 = No
1 = Yes
POPUPLT 120 Integer Pop-up LT E A  List:2 entries
0 = No
1 = Yes
CLOSELT 121 Boolean Close LT E A  List:2 entries
0 = No
1 = Yes
AVGCOST 122 BCD*10.6 Average Unit Cost E A C 
LASTCOST 123 BCD*10.6 Last Unit Cost E A C 
EXTOAVGCST 124 BCD*10.3 Total Order Average Cost A C 
EXTOLSTCST 125 BCD*10.3 Total Order Last Cost A C 
EXTIAVGCST 126 BCD*10.3 Total Invoice Average Cost A C 
EXTILSTCST 127 BCD*10.3 Total Invoice Last Cost A C 
COPYDETAIL 128 Boolean Copy This Detail Line E A X  List:2 entries
0 = No
1 = Yes
QUONUMBER 129 String*22 Quote Number E A  Mask: %-22C
QUODTLNUM 130 Integer Quote Detail Line Number E A 
SHIPTRACK 131 String*36 Shipment Tracking Number E A X 
SHIPVIA 132 String*6 Ship-Via Code E A X  Mask: %-6N
VIADESC 133 String*60 Ship-Via Code Description E A X 
DISCPER 134 BCD*5.5 Discount Percent E A X 
EDCORDMISC 135 BCD*10.3 Extended Discounted Price A C 
QTYCOMMIT 136 BCD*10.4 Quantity Committed E A X 
MANITEMNO 137 String*24 Manufacturer's Item Number E A X  Mask: %-24C
CUSTITEMNO 138 String*24 Customer Item Number E A X  Mask: %-24C
QTYTRUECOM 139 BCD*10.4 True Quantity Committed E A X 
SERIALITEM 140 Boolean Item Serialized E A 
UNFMTITEM 141 String*24 Unformatted Item Number E A  Mask: %-24C
VALUES 142 Long Optional Fields E A C 
DDTLTYPE 143 Integer Kitting/BOM E A C  List:3 entries
0 = None
1 = Kitting
2 = BOM
DDTLNO 144 String*6 Kit/BOM Number E A X  Mask: %-6N
BUILDQTY 145 BCD*10.4 BOM Build Qty. E A C 
BUILDUNIT 146 String*10 BOM Build Unit E A C  Mask: %-10c
BLDUNTCONV 147 BCD*10.6 BOM Build Unit Conversion E A C 
FRMNUMBER 148 String*22 Predecessor Number E A  Mask: %-22C
FRMUNIQ 149 BCD*10.0 Predecessor Uniquifier E A 
FRMLINENUM 150 Integer Predecessor Line Number E A 
PROCESSCMD 151 Integer Process Command E A C X  List:17 entries
0 = Nothing to Process
1 = Insert Optional Fields
2 = Default and Tranfer Optional Fields
3 = Default Opt. Fields During Record Generation
4 = Remove Optional Fields
5 = Transfer Opt. Fields from Standing Document
21 = Auto-generate Serials
22 = Auto-generate Lots
23 = Auto-allocate Serials
24 = Auto-allocate Lots
25 = Clear Serials
26 = Clear Lots
27 = Auto-assign Serials
28 = Auto-assign Lots
29 = Create List of Existing Serials/Lots
31 = Post Serials/Lots to IC Inventory
32 = Verify Serials/Lots
NEXTCMPNUM 152 Long Next Component Number E A C 
EPOSPROMID 153 Integer ePOS Promotion ID E A 
SHIUNIQ 154 BCD*10.0 Shipment Uniquifier E A C 
BASEWUNIT 155 String*10 Pricing Base Weight Unit E A C 
WEIGHTUNIT 156 String*10 Order Weight UOM E A X 
WEIGHTCONV 157 BCD*10.6 Order Weight Conversion Factor E A C 
PRWGHTUNIT 158 String*10 Pricing Weight UOM E A X 
PRWGHTCONV 159 BCD*10.6 Pricing Weight Conversion Factor E A C 
PRIBASWCNV 160 BCD*10.6 Pricing Base Weight Conv. Factor E A C 
DEFUWEIGHT 161 BCD*10.4 Def. Weight UOM Unit Weight E A C 
DEFEXTWGHT 162 BCD*10.4 Def. Weight UOM Ext. Unit Weight E A C 
PRPRICEBY 163 Integer Price By E A C  List:2 entries
1 = Quantity
2 = Weight
NEEDPCHECK 164 Boolean Price Check Pending E A X 
CAPPROVEBY 165 String*8 Price Approved By E A X  Mask: %-8N
CAPPRPWORD 166 String*64 Approving User's Password E A X 
NEEDCAPP 167 Boolean Price Approval Needed A C  List:2 entries
0 = No
1 = Yes
WUOMDESC 168 String*60 Weight UOM Description A C 
HDRDISC 169 BCD*10.3 Header Discount E A C 
OTRAMOUNT1 170 BCD*10.3 TR Tax Amount 1 E A X 
OTRAMOUNT2 171 BCD*10.3 TR Tax Amount 2 E A X 
OTRAMOUNT3 172 BCD*10.3 TR Tax Amount 3 E A X 
OTRAMOUNT4 173 BCD*10.3 TR Tax Amount 4 E A X 
OTRAMOUNT5 174 BCD*10.3 TR Tax Amount 5 E A X 
EXTNETPRI 175 BCD*10.3 Extended Amount Net of Tax E A C 
DISORDMISC 176 BCD*10.3 Discounted Extended Amount A C 
TAXTOTAL 177 BCD*10.3 Tax Total E A C 
OTRTOTAL 178 BCD*10.3 TR Tax Total E A C 
PSPRINTED 179 Boolean Picking Slip Printed E A 
JOBRELATED 180 Boolean Job Related E A C 
CONTRACT 181 String*16 Contract Code E A X  Mask: %-16C
PROJECT 182 String*16 Project Code E A X  Mask: %-16N
CCATEGORY 183 String*16 Category Code E A X  Mask: %-16N
COSTCLASS 184 Integer Cost Class E A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
PROJSTYLE 185 Integer Project Style E A  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 186 Integer Project Type E A  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 187 Integer Accounting Method E A  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 188 Integer Billing Type E A P  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
REVBILL 189 String*45 Revenue/Billing Account E A X  Mask: %-45C
COGSWIP 190 String*45 COGS/WIP Account E A X  Mask: %-45C
RTGPERCENT 191 BCD*5.5 Retainage Percent E A X 
RTGDAYS 192 Integer Retainage Days E A X 
PRICEOPT 193 Integer Default O/E Price E A  List:4 entries
0 =
1 = Billing Rate
2 = Use Customer Price List
3 = Use Specified Price List
ARITEMNO 194 String*16 A/R Item Number E A X  Mask: %-16C
ARUNIT 195 String*10 A/R Item Unit E A X  Mask: %-10C
LVL1NAME 196 String*30 Level 1 Name A C 
LVL2NAME 197 String*30 Level 2 Name A C 
LVL3NAME 198 String*30 Level 3 Name A C 
UFMTCONTNO 199 String*16 Unformatted Contract Code A C  Mask: %-16C
PAYMNTDIST 200 BCD*10.3 Prepayment Distributed E A X 
NETPRIWTX 201 BCD*10.3 Ext. Price Net of Disc. Inc. Tax E A C 
SERIALQTY 202 Long Serial Quantity E A C X 
LOTQTY 203 BCD*10.4 Lot Quantity E A C X 
SQTYMOVED 204 Long Serial Qty. Shipped E A C X 
LQTYMOVED 205 BCD*10.4 Lot Qty. Shipped E A C X 
XGENALCQTY 206 BCD*10.4 Serial/Lot Quantity to Process E A C 
XLOTMAKQTY 207 BCD*10.4 Number of Lots to Generate E A C 
XPERLOTQTY 208 BCD*10.4 Quantity per Lot E A C 
SALLOCFROM 209 String*40 Allocate from Serial E A C 
LALLOCFROM 210 String*40 Allocate from Lot E A C 
SLITEM 211 Integer Item Serialized/Lotted? E A C P  List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
METERHWND 212 Long Serial/Lot Window Handle E A C 
SIMPLEPCHK 213 Integer Use Simple Price Checking E A 
REQUESDATE 214 Date Date Requested E A X 
SETCAPPR 215 Boolean Non-interactive Price Approval E A X  List:2 entries
0 = No
1 = Yes

This page was generated on 2023-Aug-31

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