Table: Shipment Details

Table: OESHID
View: OE0691
Record length: 1545
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: 164

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

This page was generated on 2008-May-01

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