# View: Shipment Details

RotoID: OE0433
Protocol: Detail
DLL: OEISHID

## Compositions: 3

RotoID | Tables | Title | DLL
--- | --- | --- | ---
OE0434 |  | Shipments | OEISHIH
OE0691 | OESHID | Shipment Details | OESHID
OE0431 |  | Shipment Detail Optional Fields | OEISHDO

## Keys: 2

Title | Fields
--- | ---
Uniq./Detail Number | SHIUNIQ, LINENUM
Posting Journals - Details |

## Fields: 212

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 | List: 2 entries
1 | = | Item
2 | = | Miscellaneous
ITEM | 4 | String*24 | Item | E A | Mask: %-24C
MISCCHARGE | 5 | String*6 | Miscellaneous Charges Code | E A | Mask: %-6N
DESC | 6 | String*60 | Description | E A |
ACCTSET | 7 | String*6 | Item Account Set | E A | Mask: %-6N
USERCOSTMD | 8 | Boolean | User-Specified Costing Method | E A |
PRICELIST | 9 | String*6 | Price List | E A | Mask: %-6N
CATEGORY | 10 | String*6 | Category | E A | Mask: %-6N
LOCATION | 11 | String*6 | Location | E A | Mask: %-6N
PICKSEQ | 12 | String*10 | Picking Sequence | E A |
EXPDATE | 13 | Date | Expected Shipment Date | E A |
STOCKITEM | 14 | Boolean | Stock Item | E A |
ORDQTYORD | 15 | BCD*10.4 | Order Quantity Ordered | E A |
ORDQTYBKOR | 16 | BCD*10.4 | Order Quantity Backordered | E A |
ORDQTYCOMM | 17 | BCD*10.4 | Order Quantity Committed | E A |
ORDQTYTCOM | 18 | BCD*10.4 | Order True Quantity Committed | E A |
ORDQTYSTD | 19 | BCD*10.4 | Order Quantity Shipped-to-date | E A |
ORDUNIT | 20 | String*10 | Order Unit of Measure | E A |
ORDUNITCON | 21 | BCD*10.6 | Order Unit Conversion | E A |
QTYORDERED | 22 | BCD*10.4 | Current Quantity Outstanding | E A |
QTYSHIPPED | 23 | BCD*10.4 | Quantity Shipped | E A |
QTYBACKORD | 24 | BCD*10.4 | Quantity Backordered | E A |
QTYCOMMIT | 25 | BCD*10.4 | Quantity Committed | E A |
QTYTRUECOM | 26 | BCD*10.4 | True Quantity Committed | E A |
SHIUNIT | 27 | String*10 | Shipment Unit of Measure | E A | Mask: %-10c
UNITCONV | 28 | BCD*10.6 | Shipment Unit Conversion | E A |
UNITPRICE | 29 | BCD*10.6 | Shipment Unit Price | E A |
PRICEOVER | 30 | Boolean | Price Override | E A | List: 2 entries
0 | = | No
1 | = | Yes
UNITCOST | 31 | BCD*10.6 | Shipment Unit Cost | E A |
MOSTREC | 32 | BCD*10.6 | Most Recent Unit Cost | E A |
STDCOST | 33 | BCD*10.6 | Standard Unit Cost | E A |
COST1 | 34 | BCD*10.6 | Alternate Unit Cost 1 | E A |
COST2 | 35 | BCD*10.6 | Alternate Unit Cost 2 | E A |
AVGCOST | 36 | BCD*10.6 | Average Cost | E A |
LASTCOST | 37 | BCD*10.6 | Last Cost | E A |
UNITPRCDEC | 38 | Integer | Unit Price No. of Decimals | E A |
PRICEUNIT | 39 | String*10 | Pricing Unit of Measure | E A | Mask: %-10c
PRIUNTPRC | 40 | BCD*10.6 | Pricing Unit Price | E A |
PRIUNTCONV | 41 | BCD*10.6 | Pricing Unit Conversion | E A |
PRIPERCENT | 42 | BCD*5.5 | Price Discount Percentage | E A |
PRIAMOUNT | 43 | BCD*10.3 | Price Discount Amount | E A |
BASEUNIT | 44 | String*10 | Pricing Base Unit | E A | Mask: %-10c
PRIBASPRC | 45 | BCD*10.6 | Pricing Base Unit Price | E A |
PRIBASCONV | 46 | BCD*10.6 | Pricing Base Unit Conversion | E A |
COSTUNIT | 47 | String*10 | Costing Unit of Measure | E A | Mask: %-10c
COSUNTCST | 48 | BCD*10.6 | Costing Unit Cost | E A |
COSUNTCONV | 49 | BCD*10.6 | Costing Unit Conversion | E A |
EXTSHIMISC | 50 | BCD*10.3 | Extended Amount | E A |
SHIDISC | 51 | BCD*10.3 | Shipment Discount Amount | E A |
EXTSCOST | 52 | BCD*10.3 | Extended Shipment Cost | E A |
EXTOVER | 53 | Boolean | Extended Shipped Amt. Override | E A |
UNITWEIGHT | 54 | BCD*10.4 | Unit Weight | E A |
EXTWEIGHT | 55 | BCD*10.4 | Extended Weight | E A |
COMPLETE | 56 | Integer | Shipment Completed | E A | 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 | List: 2 entries
0 | = | No
1 | = | Yes
ADDTOILOC | 58 | Boolean | Recognized In Item/Location | E A |
SALESLOST | 59 | BCD*10.3 | Lost Sales Amount | E A |
TAUTH1 | 60 | String*12 | Tax Authority 1 | E A | Mask: %-12N
TAUTH2 | 61 | String*12 | Tax Authority 2 | E A | Mask: %-12N
TAUTH3 | 62 | String*12 | Tax Authority 3 | E A | Mask: %-12N
TAUTH4 | 63 | String*12 | Tax Authority 4 | E A | Mask: %-12N
TAUTH5 | 64 | String*12 | Tax Authority 5 | E A | Mask: %-12N
TCLASS1 | 65 | Integer | Tax Class 1 | E A |
TCLASS2 | 66 | Integer | Tax Class 2 | E A |
TCLASS3 | 67 | Integer | Tax Class 3 | E A |
TCLASS4 | 68 | Integer | Tax Class 4 | E A |
TCLASS5 | 69 | Integer | Tax Class 5 | E A |
TINCLUDED1 | 70 | Boolean | Tax Included 1 | E A |
TINCLUDED2 | 71 | Boolean | Tax Included 2 | E A |
TINCLUDED3 | 72 | Boolean | Tax Included 3 | E A |
TINCLUDED4 | 73 | Boolean | Tax Included 4 | E A |
TINCLUDED5 | 74 | Boolean | Tax Included 5 | E A |
TBASE1 | 75 | BCD*10.3 | Tax Base 1 | E A |
TBASE2 | 76 | BCD*10.3 | Tax Base 2 | E A |
TBASE3 | 77 | BCD*10.3 | Tax Base 3 | E A |
TBASE4 | 78 | BCD*10.3 | Tax Base 4 | E A |
TBASE5 | 79 | BCD*10.3 | Tax Base 5 | E A |
TAMOUNT1 | 80 | BCD*10.3 | Tax Amount 1 | E A |
TAMOUNT2 | 81 | BCD*10.3 | Tax Amount 2 | E A |
TAMOUNT3 | 82 | BCD*10.3 | Tax Amount 3 | E A |
TAMOUNT4 | 83 | BCD*10.3 | Tax Amount 4 | E A |
TAMOUNT5 | 84 | BCD*10.3 | Tax Amount 5 | E A |
TRATE1 | 85 | BCD*8.5 | Tax Rate 1 | E A |
TRATE2 | 86 | BCD*8.5 | Tax Rate 2 | E A |
TRATE3 | 87 | BCD*8.5 | Tax Rate 3 | E A |
TRATE4 | 88 | BCD*8.5 | Tax Rate 4 | E A |
TRATE5 | 89 | BCD*8.5 | Tax Rate 5 | E A |
DETAILNUM | 91 | Integer | Detail Number | E A |
HAVESERIAL | 92 | Boolean | Use Item Serial Numbers | E A | List: 2 entries
0 | = | No
1 | = | Yes
COMMINST | 93 | Boolean | Use Comments/Instructions | E A | List: 2 entries
0 | = | No
1 | = | Yes
GLNONSTKCR | 94 | String*45 | Non-stock Clearing Account | E A | 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 | List: 2 entries
0 | = | No
1 | = | Yes
REFRESH | 98 | Boolean | Refresh Order Qty. at Update | E A | List: 2 entries
0 | = | No
1 | = | Yes
SHIPTRACK | 99 | String*36 | Shipment Tracking Number | E A |
SHIPVIA | 100 | String*6 | Ship-Via Code | E A | Mask: %-6N
VIADESC | 101 | String*60 | Ship-Via Code Description | E A |
DISCPER | 102 | BCD*5.5 | Discount Percent | E A |
MANITEMNO | 103 | String*24 | Manufacturer's Item Number | E A | Mask: %-24C
CUSTITEMNO | 104 | String*24 | Customer Item Number | E A | Mask: %-24C
VALUES | 105 | Long | Optional Fields | E A |
DDTLTYPE | 106 | Integer | Kitting/BOM | E A | List: 3 entries
0 | = | None
1 | = | Kitting
2 | = | BOM
DDTLNO | 107 | String*6 | Kit/BOM Number | E A | Mask: %-6N
BUILDQTY | 108 | BCD*10.4 | BOM Build Qty. | E A |
BUILDUNIT | 109 | String*10 | BOM Build Unit | E A | Mask: %-10c
BLDUNTCONV | 110 | BCD*10.6 | Build Unit Conversion Factor | E A |
NEXTCMPNUM | 111 | Long | Next Component Number | E A |
EPOSPROMID | 112 | Integer | ePOS Promotion ID | E A |
BASEWUNIT | 113 | String*10 | Pricing Base Weight Unit | E A |
WEIGHTUNIT | 114 | String*10 | Weight Unit of Measure | E A |
WEIGHTCONV | 115 | BCD*10.6 | Weight Conversion Factor | E A |
PRWGHTUNIT | 116 | String*10 | Pricing Weight UOM | E A |
PRWGHTCONV | 117 | BCD*10.6 | Pricing Weight Conversion Factor | E A |
PRIBASWCNV | 118 | BCD*10.6 | Pricing Base Weight Conv. Factor | E A |
DEFUWEIGHT | 119 | BCD*10.4 | Def. Weight UOM Unit Weight | E A |
DEFEXTWGHT | 120 | BCD*10.4 | Def. Weight UOM Ext. Unit Weight | E A |
PRPRICEBY | 121 | Integer | Price By | E A | List: 2 entries
1 | = | Quantity
2 | = | Weight
NEEDPCHECK | 122 | Boolean | Price Check Pending | E A |
CAPPROVEBY | 123 | String*8 | Price Approved By | E A | Mask: %-8N
HDRDISC | 124 | BCD*10.3 | Header Discount | E A |
STRAMOUNT1 | 125 | BCD*10.3 | TR Tax Amount 1 | E A |
STRAMOUNT2 | 126 | BCD*10.3 | TR Tax Amount 2 | E A |
STRAMOUNT3 | 127 | BCD*10.3 | TR Tax Amount 3 | E A |
STRAMOUNT4 | 128 | BCD*10.3 | TR Tax Amount 4 | E A |
STRAMOUNT5 | 129 | BCD*10.3 | TR Tax Amount 5 | E A |
PSPRINTED | 130 | Boolean | Picking Slip Printed | E A |
COG | 131 | BCD*10.3 | Cost of Goods | E A |
JOBRELATED | 132 | Boolean | Job Related | E A |
CONTRACT | 133 | String*16 | Contract Code | E A | Mask: %-16C
PROJECT | 134 | String*16 | Project Code | E A | Mask: %-16N
CCATEGORY | 135 | String*16 | Category Code | E A | Mask: %-16N
COSTCLASS | 136 | Integer | Cost Class | E A | 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 | List: 4 entries
0 | = |
1 | = | Non-billable
2 | = | Billable
3 | = | No Charge
REVBILL | 141 | String*45 | Revenue/Billing Account | E A | Mask: %-45C
COGSWIP | 142 | String*45 | COGS/WIP Account | E A | Mask: %-45C
RTGAMOUNT | 143 | BCD*10.3 | Retainage Amount | E A |
RTGPERCENT | 144 | BCD*5.5 | Retainage Percent | E A |
RTGDAYS | 145 | Integer | Retainage Days | E A |
RTGAMTOVR | 146 | Boolean | Retainage Amount Override | E A |
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 | Mask: %-16C
ARUNIT | 160 | String*10 | A/R Item Unit | E A | Mask: %-10C
PAYMNTDIST | 161 | BCD*10.3 | Prepayment Distributed | E A |
EXTSMOSTRE | 200 | BCD*10.3 | Total Shipment Most Recent Cost | E A |
EXTSSTDCOS | 201 | BCD*10.3 | Total Shipment Standard Cost | E A |
EXTSCOST1 | 202 | BCD*10.3 | Total Shipment Cost 1 | E A |
EXTSCOST2 | 203 | BCD*10.3 | Total Shipment Cost 2 | E A |
EXTSAVGCST | 204 | BCD*10.3 | Total Shipment Average Cost | E A |
EXTSLSTCST | 205 | BCD*10.3 | Total Shipment Last Cost | E A |
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 |
TAUTH2DESC | 210 | String*60 | Tax Authority 2 Description | E A |
TAUTH3DESC | 211 | String*60 | Tax Authority 3 Description | E A |
TAUTH4DESC | 212 | String*60 | Tax Authority 4 Description | E A |
TAUTH5DESC | 213 | String*60 | Tax Authority 5 Description | E A |
TCLAS1DESC | 214 | String*60 | Tax Class 1 Description | E A |
TCLAS2DESC | 215 | String*60 | Tax Class 2 Description | E A |
TCLAS3DESC | 216 | String*60 | Tax Class 3 Description | E A |
TCLAS4DESC | 217 | String*60 | Tax Class 4 Description | E A |
TCLAS5DESC | 218 | String*60 | Tax Class 5 Description | E A |
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 | E A |
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 | 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
CAPPRPWORD | 240 | String*64 | Approving User's Password | E A |
NEEDCAPP | 241 | Boolean | Price Approval Needed | E A | List: 2 entries
0 | = | No
1 | = | Yes
WUOMDESC | 242 | String*60 | Weight UOM Description | E A |
EXTNETPRI | 243 | BCD*10.3 | Extended Amount Net of Tax | E A |
DISSHIMISC | 244 | BCD*10.3 | Discounted Extended Amount | E A |
TAXTOTAL | 245 | BCD*10.3 | Tax Total | E A |
STRTOTAL | 246 | BCD*10.3 | TR Tax Total | E A |
LVL1NAME | 247 | String*30 | Level 1 Name | E A |
LVL2NAME | 248 | String*30 | Level 2 Name | E A |
LVL3NAME | 249 | String*30 | Level 3 Name | E A |
UFMTCONTNO | 250 | String*16 | Unformatted Contract Code | E A | Mask: %-16C
NETPRIWTX | 251 | BCD*10.3 |  | E A |

This page was generated on 2008-May-01

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