# View: Order Details

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

## Compositions: 4

RotoID | Tables | Title | DLL
--- | --- | --- | ---
OE0520 | OEORDH, OEORDH1 | Orders | OEORDH
OE0501 | OEORDDO | Order Detail Optional Fields | OEORDDO
OE0503 | OEORDDB | Order BOM Details | OEORDDB
OE0502 | OEORDDD | Order Kitting Details | OEORDDD

## Keys: 6

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
Uniq./Exp. Shipment Date/Item/Dt | ORDUNIQ, EXPDATE, ITEM, DDTLTYPE, LOCATION

## Fields: 200

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 |
HAVESERIAL | 85 | Boolean | Use Item Serial Numbers | E A X | List: 2 entries
0 | = | No
1 | = | Yes
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 |
TAUTH2DESC | 99 | String*60 | Tax Authority 2 Description | E A |
TAUTH3DESC | 100 | String*60 | Tax Authority 3 Description | E A |
TAUTH4DESC | 101 | String*60 | Tax Authority 4 Description | E A |
TAUTH5DESC | 102 | String*60 | Tax Authority 5 Description | E A |
TCLAS1DESC | 103 | String*60 | Tax Class 1 Description | E A |
TCLAS2DESC | 104 | String*60 | Tax Class 2 Description | E A |
TCLAS3DESC | 105 | String*60 | Tax Class 3 Description | E A |
TCLAS4DESC | 106 | String*60 | Tax Class 4 Description | E A |
TCLAS5DESC | 107 | String*60 | Tax Class 5 Description | E A |
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 | List: 6 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
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 |

This page was generated on 2008-May-01

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