View: Shipment Details

RotoID: OE0691
Table: OESHID
Protocol: Detail, Sequenced revisions, Key auto generate
DLL:OESHID

Compositions: 7

RotoID Tables Title DLL
OE0692 OESHIH Shipments OESHIH
OE0697 OESHTD Shipment Day End Details OESHTD
OE0702 OESHIDO Shipment Detail Optional Fields OESHIDO
OE0705 OESHIDB Shipment BOM Details OESHIDB
OE0703 OESHIDD Shipment Kitting Details OESHIDD
OE0709 OESHIDS Shipment Detail Serial Numbers OESHIDS
OE0708 OESHIDL Shipment Detail Lot Numbers OESHIDL

Keys: 4

Title Fields
Uniq./Line Number SHIUNIQ, LINENUM
Uniq./Detail Number SHIUNIQ, DETAILNUM
Ord No./Ord Dtl No./Uniq./Dtl No ORDNUMBER, ORDDTLNUM, SHIUNIQ, DETAILNUM
Item No./Uniq./Line Number ITEM, SHIUNIQ, LINENUM

Fields: 224

Field Index Type Title Attributes Presentation
SHIUNIQ 1 BCD*10.0 Shipment 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 Shipment Date E A X 
STOCKITEM 14 Boolean Stock Item E A X 
ORDQTYORD 15 BCD*10.4 Order Quantity Ordered E A C 
ORDQTYBKOR 16 BCD*10.4 Order Quantity Backordered E A C 
ORDQTYCOMM 17 BCD*10.4 Order Quantity Committed E A C 
ORDQTYTCOM 18 BCD*10.4 Order True Quantity Committed E A C 
ORDQTYSTD 19 BCD*10.4 Order Quantity Shipped-to-date E A C 
ORDUNIT 20 String*10 Order Unit of Measure E A C 
ORDUNITCON 21 BCD*10.6 Order Unit Conversion E A C 
QTYORDERED 22 BCD*10.4 Current Quantity Outstanding E A C 
QTYSHIPPED 23 BCD*10.4 Quantity Shipped E A X 
QTYBACKORD 24 BCD*10.4 Quantity Backordered E A X 
QTYCOMMIT 25 BCD*10.4 Quantity Committed E A C 
QTYTRUECOM 26 BCD*10.4 True Quantity Committed E A C 
SHIUNIT 27 String*10 Shipment Unit of Measure E A X  Mask: %-10c
UNITCONV 28 BCD*10.6 Shipment Unit Conversion E A C 
UNITPRICE 29 BCD*10.6 Shipment Unit Price E A C 
PRICEOVER 30 Boolean Price Override E A C  List:2 entries
0 = No
1 = Yes
UNITCOST 31 BCD*10.6 Shipment Unit Cost E A C 
MOSTREC 32 BCD*10.6 Most Recent Unit Cost E A C 
STDCOST 33 BCD*10.6 Standard Unit Cost E A C 
COST1 34 BCD*10.6 Alternate Unit Cost 1 E A C 
COST2 35 BCD*10.6 Alternate Unit Cost 2 E A C 
AVGCOST 36 BCD*10.6 Average Cost E A C 
LASTCOST 37 BCD*10.6 Last Cost E A C 
UNITPRCDEC 38 Integer Unit Price No. of Decimals E A C 
PRICEUNIT 39 String*10 Pricing Unit of Measure E A C  Mask: %-10c
PRIUNTPRC 40 BCD*10.6 Pricing Unit Price E A X 
PRIUNTCONV 41 BCD*10.6 Pricing Unit Conversion E A C 
PRIPERCENT 42 BCD*5.5 Price Discount Percentage E A C 
PRIAMOUNT 43 BCD*10.3 Price Discount Amount E A C 
BASEUNIT 44 String*10 Pricing Base Unit E A C  Mask: %-10c
PRIBASPRC 45 BCD*10.6 Pricing Base Unit Price E A C 
PRIBASCONV 46 BCD*10.6 Pricing Base Unit Conversion E A C 
COSTUNIT 47 String*10 Costing Unit of Measure E A C  Mask: %-10c
COSUNTCST 48 BCD*10.6 Costing Unit Cost E A X 
COSUNTCONV 49 BCD*10.6 Costing Unit Conversion E A C 
EXTSHIMISC 50 BCD*10.3 Extended Amount E A X 
SHIDISC 51 BCD*10.3 Shipment Discount Amount E A X 
EXTSCOST 52 BCD*10.3 Extended Shipment Cost E A C X 
EXTOVER 53 Boolean Extended Shipped Amt. Override E A C 
UNITWEIGHT 54 BCD*10.4 Unit Weight E A X 
EXTWEIGHT 55 BCD*10.4 Extended Weight E A X 
COMPLETE 56 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
FINISHORD 57 Boolean Shipment Completes Order Detail E A X  List:2 entries
0 = No
1 = Yes
ADDTOILOC 58 Boolean Recognized In Item/Location E A C 
SALESLOST 59 BCD*10.3 Lost Sales Amount E A C 
TAUTH1 60 String*12 Tax Authority 1 E A C  Mask: %-12N
TAUTH2 61 String*12 Tax Authority 2 E A C  Mask: %-12N
TAUTH3 62 String*12 Tax Authority 3 E A C  Mask: %-12N
TAUTH4 63 String*12 Tax Authority 4 E A C  Mask: %-12N
TAUTH5 64 String*12 Tax Authority 5 E A C  Mask: %-12N
TCLASS1 65 Integer Tax Class 1 E A X 
TCLASS2 66 Integer Tax Class 2 E A X 
TCLASS3 67 Integer Tax Class 3 E A X 
TCLASS4 68 Integer Tax Class 4 E A X 
TCLASS5 69 Integer Tax Class 5 E A X 
TINCLUDED1 70 Boolean Tax Included 1 E A X 
TINCLUDED2 71 Boolean Tax Included 2 E A X 
TINCLUDED3 72 Boolean Tax Included 3 E A X 
TINCLUDED4 73 Boolean Tax Included 4 E A X 
TINCLUDED5 74 Boolean Tax Included 5 E A X 
TBASE1 75 BCD*10.3 Tax Base 1 E A X 
TBASE2 76 BCD*10.3 Tax Base 2 E A X 
TBASE3 77 BCD*10.3 Tax Base 3 E A X 
TBASE4 78 BCD*10.3 Tax Base 4 E A X 
TBASE5 79 BCD*10.3 Tax Base 5 E A X 
TAMOUNT1 80 BCD*10.3 Tax Amount 1 E A X 
TAMOUNT2 81 BCD*10.3 Tax Amount 2 E A X 
TAMOUNT3 82 BCD*10.3 Tax Amount 3 E A X 
TAMOUNT4 83 BCD*10.3 Tax Amount 4 E A X 
TAMOUNT5 84 BCD*10.3 Tax Amount 5 E A X 
TRATE1 85 BCD*8.5 Tax Rate 1 E A C 
TRATE2 86 BCD*8.5 Tax Rate 2 E A C 
TRATE3 87 BCD*8.5 Tax Rate 3 E A C 
TRATE4 88 BCD*8.5 Tax Rate 4 E A C 
TRATE5 89 BCD*8.5 Tax Rate 5 E A C 
DETAILNUM 91 Integer Detail Number E A 
COMMINST 93 Boolean Use Comments/Instructions E A X  List:2 entries
0 = No
1 = Yes
GLNONSTKCR 94 String*45 Non-stock Clearing Account E A X  Mask: %-45C
ORDNUMBER 95 String*22 Order Number E A  Mask: %-22C
ORDDTLNUM 96 Integer Order Detail Number E A 
INDBTABLE 97 Boolean Stored in Database Table E A X  List:2 entries
0 = No
1 = Yes
REFRESH 98 Boolean Refresh Order Qty. at Update E A X  List:2 entries
0 = No
1 = Yes
SHIPTRACK 99 String*36 Shipment Tracking Number E A X 
SHIPVIA 100 String*6 Ship-Via Code E A X  Mask: %-6N
VIADESC 101 String*60 Ship-Via Code Description E A X 
DISCPER 102 BCD*5.5 Discount Percent E A X 
MANITEMNO 103 String*24 Manufacturer's ItemNumber E A X  Mask: %-24C
CUSTITEMNO 104 String*24 Customer Item Number E A X  Mask: %-24C
VALUES 105 Long Optional Fields E A C 
DDTLTYPE 106 Integer Kitting/BOM E A C  List:3 entries
0 = None
1 = Kitting
2 = BOM
DDTLNO 107 String*6 Kit/BOM Number E A X  Mask: %-6N
BUILDQTY 108 BCD*10.4 BOM Build Qty. E A C 
BUILDUNIT 109 String*10 BOM Build Unit E A C  Mask: %-10c
BLDUNTCONV 110 BCD*10.6 BOM Build Unit Conversion E A C 
NEXTCMPNUM 111 Long Next Component Number E A C 
EPOSPROMID 112 Integer ePOS Promotion ID E A 
BASEWUNIT 113 String*10 Pricing Base Weight Unit E A C 
WEIGHTUNIT 114 String*10 Weight Unit of Measure E A X 
WEIGHTCONV 115 BCD*10.6 Weight Conversion Factor E A C 
PRWGHTUNIT 116 String*10 Pricing Weight UOM E A X 
PRWGHTCONV 117 BCD*10.6 Pricing Weight Conversion Factor E A C 
PRIBASWCNV 118 BCD*10.6 Pricing Base Weight Conv. Factor E A C 
DEFUWEIGHT 119 BCD*10.4 Def. Weight UOM Unit Weight E A C 
DEFEXTWGHT 120 BCD*10.4 Def. Weight UOM Ext. Unit Weight E A C 
PRPRICEBY 121 Integer Price By E A C  List:2 entries
1 = Quantity
2 = Weight
NEEDPCHECK 122 Boolean Price Check Pending E A X 
CAPPROVEBY 123 String*8 Price Approved By E A X  Mask: %-8N
HDRDISC 124 BCD*10.3 Header Discount E A C 
STRAMOUNT1 125 BCD*10.3 TR Tax Amount 1 E A X 
STRAMOUNT2 126 BCD*10.3 TR Tax Amount 2 E A X 
STRAMOUNT3 127 BCD*10.3 TR Tax Amount 3 E A X 
STRAMOUNT4 128 BCD*10.3 TR Tax Amount 4 E A X 
STRAMOUNT5 129 BCD*10.3 TR Tax Amount 5 E A X 
PSPRINTED 130 Boolean Picking Slip Printed E A 
COG 131 BCD*10.3 Cost of Goods E A C 
JOBRELATED 132 Boolean Job Related E A C 
CONTRACT 133 String*16 Contract Code E A X  Mask: %-16C
PROJECT 134 String*16 Project Code E A X  Mask: %-16N
CCATEGORY 135 String*16 Category Code E A X  Mask: %-16N
COSTCLASS 136 Integer Cost Class E A C X  List:7 entries
0 =
1 = Labor
2 = Material
3 = Equipment
4 = Subcontractor
5 = Overhead
6 = Miscellaneous
PROJSTYLE 137 Integer Project Style E A  List:3 entries
0 =
1 = Standard
2 = Basic
PROJTYPE 138 Integer Project Type E A  List:4 entries
0 =
1 = Time and Materials
2 = Fixed Price
3 = Cost Plus
REVREC 139 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 140 Integer Billing Type E A P X  List:4 entries
0 =
1 = Non-billable
2 = Billable
3 = No Charge
REVBILL 141 String*45 Revenue/Billing Account E A X  Mask: %-45C
COGSWIP 142 String*45 COGS/WIP Account E A X  Mask: %-45C
RTGAMOUNT 143 BCD*10.3 Retainage Amount E A C X 
RTGPERCENT 144 BCD*5.5 Retainage Percent E A X 
RTGDAYS 145 Integer Retainage Days E A X 
RTGAMTOVR 146 Boolean Retainage Amount Override E A C X 
RTGTXBASE1 147 BCD*10.3 Retainage Tax Base 1 E A 
RTGTXBASE2 148 BCD*10.3 Retainage Tax Base 2 E A 
RTGTXBASE3 149 BCD*10.3 Retainage Tax Base 3 E A 
RTGTXBASE4 150 BCD*10.3 Retainage Tax Base 4 E A 
RTGTXBASE5 151 BCD*10.3 Retainage Tax Base 5 E A 
RTGTXAMT1 152 BCD*10.3 Retainage Tax Amount 1 E A 
RTGTXAMT2 153 BCD*10.3 Retainage Tax Amount 2 E A 
RTGTXAMT3 154 BCD*10.3 Retainage Tax Amount 3 E A 
RTGTXAMT4 155 BCD*10.3 Retainage Tax Amount 4 E A 
RTGTXAMT5 156 BCD*10.3 Retainage Tax Amount 5 E A 
PMTRANSNBR 157 Long PM Transaction Number E A 
PRICEOPT 158 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 159 String*16 A/R Item Number E A X  Mask: %-16C
ARUNIT 160 String*10 A/R Item Unit E A X  Mask: %-10C
PAYMNTDIST 161 BCD*10.3 Prepayment Distributed E A X 
SERIALQTY 162 Long Serial Quantity E A C X 
LOTQTY 163 BCD*10.4 Lot Quantity E A C X 
SLITEM 164 Integer Item Serialized/Lotted? E A C P  List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
COMPANYID 165 Long Sage CRM Company ID E A 
OPPOID 166 Long Sage CRM Opportunity ID E A 
EXTSMOSTRE 200 BCD*10.3 Total Shipment Most Recent Cost A C 
EXTSSTDCOS 201 BCD*10.3 Total Shipment Standard Cost A C 
EXTSCOST1 202 BCD*10.3 Total Shipment Cost 1 A C 
EXTSCOST2 203 BCD*10.3 Total Shipment Cost 2 A C 
EXTSAVGCST 204 BCD*10.3 Total Shipment Average Cost A C 
EXTSLSTCST 205 BCD*10.3 Total Shipment Last Cost A C 
PCODDESC 206 String*60 Price List Description E A 
CATGDESC 207 String*60 Category Description E A 
LOCDESC 208 String*60 Location Description E A 
TAUTH1DESC 209 String*60 Tax Authority 1 Description E A C 
TAUTH2DESC 210 String*60 Tax Authority 2 Description E A C 
TAUTH3DESC 211 String*60 Tax Authority 3 Description E A C 
TAUTH4DESC 212 String*60 Tax Authority 4 Description E A C 
TAUTH5DESC 213 String*60 Tax Authority 5 Description E A C 
TCLAS1DESC 214 String*60 Tax Class 1 Description E A C 
TCLAS2DESC 215 String*60 Tax Class 2 Description E A C 
TCLAS3DESC 216 String*60 Tax Class 3 Description E A C 
TCLAS4DESC 217 String*60 Tax Class 4 Description E A C 
TCLAS5DESC 218 String*60 Tax Class 5 Description E A C 
DRIVENBYUI 219 Boolean Driven by UI E A 
NEGINVENT 220 Boolean Found Negative Inventory E A 
NEGINVDEL 221 Boolean Negative Inventory Level On Delete E A 
GLNONSTKCD 222 String*60 Non-stock Clearing Acct. Desc. E A 
EDCSHIMISC 223 BCD*10.3 Extended Discounted Price A C 
ACTION 224 Integer Action E A 
IPCID 225 Long Inter-process Comm. ID E A 
FPOPSNQO 226 Boolean Force Pop-up SN on Qty. Ordered E A  List:2 entries
0 = No
1 = Yes
FPOPSNQS 227 Boolean Force Pop-up SN on Qty. Shipped E A  List:2 entries
0 = No
1 = Yes
POPUPSN 228 Integer Pop-up SN E A  List:2 entries
0 = No
1 = Yes
CLOSESN 229 Boolean Close SN E A  List:2 entries
0 = No
1 = Yes
LTSETID 230 Long LT Set ID E A 
FPOPLTQO 231 Boolean Force Pop-up LT on Qty. Ordered E A  List:2 entries
0 = No
1 = Yes
FPOPLTQS 232 Boolean Force Pop-up LT on Qty. Shipped E A  List:2 entries
0 = No
1 = Yes
POPUPLT 233 Integer Pop-up LT E A  List:2 entries
0 = No
1 = Yes
CLOSELT 234 Boolean Close LT E A  List:2 entries
0 = No
1 = Yes
ORDUNIQ 235 BCD*10.0 Order Uniquifier E A 
SERIALITEM 236 Boolean Item Serialized E A 
UNFMTITEM 237 String*24 Unformatted Item Number E A  Mask: %-24C
ORDLINENUM 238 Integer Order Line Number E A 
PROCESSCMD 239 Integer Process Command E A C  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
CAPPRPWORD 240 String*64 Approving User's Password E A X 
NEEDCAPP 241 Boolean Price Approval Needed A C  List:2 entries
0 = No
1 = Yes
WUOMDESC 242 String*60 Weight UOM Description A C 
EXTNETPRI 243 BCD*10.3 Extended Amount Net of Tax E A C 
DISSHIMISC 244 BCD*10.3 Discounted Extended Amount A C 
TAXTOTAL 245 BCD*10.3 Tax Total E A C 
STRTOTAL 246 BCD*10.3 TR Tax Total E A C 
LVL1NAME 247 String*30 Level 1 Name A C 
LVL2NAME 248 String*30 Level 2 Name A C 
LVL3NAME 249 String*30 Level 3 Name A C 
UFMTCONTNO 250 String*16 Unformatted Contract Code A C  Mask: %-16C
NETPRIWTX 251 BCD*10.3 Ext. Price Net of Disc. Inc. Tax E A C 
SHIDUE 252 BCD*10.3 Detail Amount Due A C 
XGENALCQTY 253 BCD*10.4 Serial/Lot Quantity to Process E A C 
XLOTMAKQTY 254 BCD*10.4 Number of Lots to Generate E A C 
XPERLOTQTY 255 BCD*10.4 Quantity per Lot E A C 
SALLOCFROM 256 String*40 Allocate from Serial E A C 
LALLOCFROM 257 String*40 Allocate from Lot E A C 
METERHWND 258 Long Serial/Lot Window Handle E A C 
SETCAPPR 259 Boolean Non-interactive Price Approval E A X  List:2 entries
0 = No
1 = Yes

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