Table: Shipment Details

Table: OESHID
View: OE0691
Record Length: 1567

Flags: A R 

Keys: 4

Title Flags 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 D M  ITEM, SHIUNIQ, LINENUM

Fields: 168

Field Type Title Presentation
SHIUNIQ BCD*10.0 Shipment 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 Shipment Date
STOCKITEM Boolean Stock Item
ORDQTYORD BCD*10.4 Order Quantity Ordered
ORDQTYBKOR BCD*10.4 Order Quantity Backordered
ORDQTYCOMM BCD*10.4 Order Quantity Committed
ORDQTYTCOM BCD*10.4 Order True Quantity Committed
ORDQTYSTD BCD*10.4 Order Quantity Shipped-to-date
ORDUNIT String*10 Order Unit of Measure
ORDUNITCON BCD*10.6 Order Unit Conversion
QTYORDERED BCD*10.4 Current Quantity Outstanding
QTYSHIPPED BCD*10.4 Quantity Shipped
QTYBACKORD BCD*10.4 Quantity Backordered
QTYCOMMIT BCD*10.4 Quantity Committed
QTYTRUECOM BCD*10.4 True Quantity Committed
SHIUNIT String*10 Shipment Unit of Measure Mask: %-10c
UNITCONV BCD*10.6 Shipment Unit Conversion
UNITPRICE BCD*10.6 Shipment Unit Price
PRICEOVER Boolean Price Override List:2 entries
0 = No
1 = Yes
UNITCOST BCD*10.6 Shipment 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
AVGCOST BCD*10.6 Average Cost
LASTCOST BCD*10.6 Last Cost
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
EXTSHIMISC BCD*10.3 Extended Amount
SHIDISC BCD*10.3 Shipment Discount Amount
EXTSCOST BCD*10.3 Extended Shipment 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
FINISHORD Boolean Shipment Completes Order Detail List:2 entries
0 = No
1 = Yes
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
ORDNUMBER String*22 Order Number Mask: %-22C
ORDDTLNUM Integer Order Detail Number
INDBTABLE Boolean Stored in Database Table List:2 entries
0 = No
1 = Yes
REFRESH Boolean Refresh Order Qty. at Update List:2 entries
0 = No
1 = Yes
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
MANITEMNO String*24 Manufacturer's ItemNumber Mask: %-24C
CUSTITEMNO String*24 Customer Item Number Mask: %-24C
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
NEXTCMPNUM Long Next Component Number
EPOSPROMID Integer ePOS Promotion ID
BASEWUNIT String*10 Pricing Base Weight Unit
WEIGHTUNIT String*10 Weight Unit of Measure
WEIGHTCONV BCD*10.6 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
STRAMOUNT1 BCD*10.3 TR Tax Amount 1
STRAMOUNT2 BCD*10.3 TR Tax Amount 2
STRAMOUNT3 BCD*10.3 TR Tax Amount 3
STRAMOUNT4 BCD*10.3 TR Tax Amount 4
STRAMOUNT5 BCD*10.3 TR Tax Amount 5
PSPRINTED Boolean Picking Slip Printed
COG BCD*10.3 Cost of Goods
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
RTGAMOUNT BCD*10.3 Retainage Amount
RTGPERCENT BCD*5.5 Retainage Percent
RTGDAYS Integer Retainage Days
RTGAMTOVR Boolean Retainage Amount Override
RTGTXBASE1 BCD*10.3 Retainage Tax Base 1
RTGTXBASE2 BCD*10.3 Retainage Tax Base 2
RTGTXBASE3 BCD*10.3 Retainage Tax Base 3
RTGTXBASE4 BCD*10.3 Retainage Tax Base 4
RTGTXBASE5 BCD*10.3 Retainage Tax Base 5
RTGTXAMT1 BCD*10.3 Retainage Tax Amount 1
RTGTXAMT2 BCD*10.3 Retainage Tax Amount 2
RTGTXAMT3 BCD*10.3 Retainage Tax Amount 3
RTGTXAMT4 BCD*10.3 Retainage Tax Amount 4
RTGTXAMT5 BCD*10.3 Retainage Tax Amount 5
PMTRANSNBR Long PM Transaction Number
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
SLITEM Integer Item Serialized/Lotted? List:4 entries
0 = None
1 = Serialized
2 = Lotted
3 = Both
COMPANYID Long Sage CRM Company ID
OPPOID Long Sage CRM Opportunity ID

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