# Table: Shipment Details

Table: OESHID
View: OE0691
Record length: 1559
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: 166

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

This page was generated on 2009-Nov-19

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