# Table: Shipment Details

Table: OESHID
View: OE0691
Record length: 1115
Flags: A R

## Keys: 2

Title | Flags | Fields
--- | --- | ---
Uniq./Line Number |  | SHIUNIQ, LINENUM
Uniq./Detail Number |  | SHIUNIQ, DETAILNUM

## Fields: 116

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 | Shipment 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 |
MISCACCT | String*45 | Misc. Charges G/L Account | Mask: %-45C
DETAILNUM | Integer | Detail Number |
HAVESERIAL | Boolean | Use Item Serial Numbers | List: 2 entries
0 | = | No
1 | = | Yes
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 |
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 |

This page was generated on 2004-Oct-28

Copyright © 2000–2004 ACCPAC International, Inc. All rights reserved.