Table: Shipments

Table: OESHIH
View: OE0692
Record length: 3163
Flags: A R 

Keys: 7

Title  Flags  Fields

Shipment Uniquifier Key  SHIUNIQ
Shipment Number Key  SHINUMBER
Order/Shipment  ORDNUMBER, SHINUMBER
Customer/Shipment  CUSTOMER, SHINUMBER
Reference/Shipment  M  REFERENCE, SHINUMBER
Shipment Completed  M  COMPLETE, SHIUNIQ
Customer/PO No./Order No.  D M  CUSTOMER, PONUMBER, ORDNUMBER

Fields: 213

Field  Type  Title  Presentation 

SHIUNIQ  BCD*10.0  Shipment Uniquifier   
AUDTDATE  Date     
AUDTTIME  Time     
AUDTUSER  String*8     
AUDTORG  String*6     
SHINUMBER  String*22  Shipment Number  Mask: %-22C
ORDNUMBER  String*22  Order Number  Mask: %-22C
DAYENDNUM  BCD*10.0  I/C Day End Trans. Number   
CUSTOMER  String*12  Customer Number  Mask: %-12C
CUSTGROUP  String*6  Customer Group Code  Mask: %-6C
BILNAME  String*60  Bill-To Name   
BILADDR1  String*60  Bill-To Address Line 1   
BILADDR2  String*60  Bill-To Address Line 2   
BILADDR3  String*60  Bill-To Address Line 3   
BILADDR4  String*60  Bill-To Address Line 4   
BILCITY  String*30  Bill-To City   
BILSTATE  String*30  Bill-To State/Province   
BILZIP  String*20  Bill-To Zip/Postal Code   
BILCOUNTRY  String*30  Bill-To Country   
BILPHONE  String*30  Bill-To Phone Number  Mask: (%-3C) %-3C-%-24C
BILFAX  String*30  Bill-To Fax Number  Mask: (%-3C) %-3C-%-24C
BILCONTACT  String*60  Bill-To Contact   
BILEMAIL  String*50  Bill-To E-mail   
BILPHONEC  String*30  Bill-To Contact Phone  Mask: (%-3C) %-3C-%-24C
BILFAXC  String*30  Bill-To Contact Fax  Mask: (%-3C) %-3C-%-24C
BILEMAILC  String*50  Bill-To Contact E-mail   
SHIPTO  String*6  Ship-To Location Code  Mask: %-6C
SHPNAME  String*60  Ship-To Name   
SHPADDR1  String*60  Ship-To Address Line 1   
SHPADDR2  String*60  Ship-To Address Line 2   
SHPADDR3  String*60  Ship-To Address Line 3   
SHPADDR4  String*60  Ship-To Address Line 4   
SHPCITY  String*30  Ship-To City   
SHPSTATE  String*30  Ship-To State/Province   
SHPZIP  String*20  Ship-To Zip/Postal Code   
SHPCOUNTRY  String*30  Ship-To Country   
SHPPHONE  String*30  Ship-To Phone Number  Mask: (%-3C) %-3C-%-24C
SHPFAX  String*30  Ship-To Fax Number  Mask: (%-3C) %-3C-%-24C
SHPCONTACT  String*60  Ship-To Contact   
SHPEMAIL  String*50  Ship-To E-mail   
SHPPHONEC  String*30  Ship-To Contact Phone  Mask: (%-3C) %-3C-%-24C
SHPFAXC  String*30  Ship-To Contact Fax  Mask: (%-3C) %-3C-%-24C
SHPEMAILC  String*50  Ship-To Contact E-mail   
CUSTDISC  Integer  Customer Discount Level  List: 6 entries
0=Base
1=A
2=B
3=C
4=D
5=E
PRICELIST  String*6  Default Price List Code  Mask: %-6N
PONUMBER  String*22  Purchase Order Number  Mask: %-22C
TERRITORY  String*6  Territory  Mask: %-6N
TERMS  String*6  Terms Code  Mask: %-6N
REFERENCE  String*60  Shipment Reference   
SHIDATE  Date  Shipment Date   
EXPDATE  Date  Expected Ship Date   
SHIPVIA  String*6  Ship-Via Code  Mask: %-6N
VIADESC  String*60  Ship-Via Code Description   
SHIFISCYR  String*4  Shipment Fiscal Year  Mask: %-4d
SHIFISCPER  Integer  Shipment Fiscal Period  List: 12 entries
1=1
2=2
3=3
4=4
5=5
6=6
7=7
8=8
9=9
10=10
11=11
12=12
LASTINVNUM  String*22  Last Invoice Number  Mask: %-22C
NUMINVOICE  Integer  Number of Invoices   
FOB  String*60  Free On Board Point   
TEMPLATE  String*6  Template Code  Mask: %-6N
LOCATION  String*6  Default Location Code  Mask: %-6N
DESC  String*60  Shipment Description   
COMMENT  String*250  Shipment Comment   
OVERCREDIT  Boolean  Over Credit Limit   
APPROVELMT  BCD*10.3  Approved Limit   
APPROVEBY  String*8  Authorizing User ID  Mask: %-8N
PRINTSTAT  Integer  Order Print Status  List: 5 entries
1=
2=Quote printed
3=Picking slip printed
0=Internet
-1=Electronic Commerce
LASTPOST  Date  Last Posting Date   
SHIPLABEL  Boolean  Requires Shipping Labels   
LBLPRINTED  Boolean  Shipping Labels Printed   
SHHOMECURR  String*3  Shipment Home Currency  Mask: %-3N
SHRATETYPE  String*2  Shipment Rate Type  Mask: %-2N
SHSOURCURR  String*3  Shipment Source Currency  Mask: %-3N
SHRATEDATE  Date  Shipment Rate Date   
SHRATE  BCD*8.7  Shipment Rate   
SHSPREAD  BCD*8.7  Shipment Spread   
SHDATEMTCH  Integer  Shipment Rate Date Matching   
SHRATEREP  Integer  Shipment Rate Operator   
SHRATEOVER  Boolean  Shipment Rate Override Flag   
SHITOTAL  BCD*10.3  Total Amt. Items   
SHIMTOTAL  BCD*10.3  Total Amt. Misc. Charges   
SHILINES  Integer  Number of Lines on Shipment   
NUMLABELS  Integer  Number of Labels   
SHIPAYTOT  BCD*10.3  Prev. Payments Total   
SHIPYDSTOT  BCD*10.3  Prev. Payment Disc. Total   
SALESPER1  String*8  Salesperson 1  Mask: %-8N
SALESPER2  String*8  Salesperson 2  Mask: %-8N
SALESPER3  String*8  Salesperson 3  Mask: %-8N
SALESPER4  String*8  Salesperson 4  Mask: %-8N
SALESPER5  String*8  Salesperson 5  Mask: %-8N
SALESPLT1  BCD*5.5  Sales Percentage 1   
SALESPLT2  BCD*5.5  Sales Percentage 2   
SALESPLT3  BCD*5.5  Sales Percentage 3   
SALESPLT4  BCD*5.5  Sales Percentage 4   
SALESPLT5  BCD*5.5  Sales Percentage 5   
RECALCTAX  Boolean  Recalculate Tax   
TAXOVERRD  Boolean  Tax Overridden   
TAXGROUP  String*12  Tax Group  Mask: %-12N
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   
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   
TEAMOUNT1  BCD*10.3  Excluded Tax Amount 1   
TEAMOUNT2  BCD*10.3  Excluded Tax Amount 2   
TEAMOUNT3  BCD*10.3  Excluded Tax Amount 3   
TEAMOUNT4  BCD*10.3  Excluded Tax Amount 4   
TEAMOUNT5  BCD*10.3  Excluded Tax Amount 5   
TIAMOUNT1  BCD*10.3  Included Tax Amount 1   
TIAMOUNT2  BCD*10.3  Included Tax Amount 2   
TIAMOUNT3  BCD*10.3  Included Tax Amount 3   
TIAMOUNT4  BCD*10.3  Included Tax Amount 4   
TIAMOUNT5  BCD*10.3  Included Tax Amount 5   
TEXEMPT1  String*20  Registration 1   
TEXEMPT2  String*20  Registration 2   
TEXEMPT3  String*20  Registration 3   
TEXEMPT4  String*20  Registration 4   
TEXEMPT5  String*20  Registration 5   
COMPLETE  Integer  Shipment Completed  List: 5 entries
1=Incomplete/Not Included
2=Incomplete/Included
3=Complete/Not Included
4=Complete/Included
5=Complete/Day End
COMPDATE  Date  Shipment Completion Date   
SHIWEIGHT  BCD*10.4  Shipment Total Est. Weight   
NEXTDTLNUM  Integer  Next Detail Number   
SDISONMISC  Boolean  Shipment Disc. Misc. Charges   
NOSHIPLINE  Integer  No. Lines Qty. Shipped   
NOMISCLINE  Integer  No. Misc. Charges Lines   
SHINETNOTX  BCD*10.3  Shipment Total Before Tax   
SHIITAXTOT  BCD*10.3  Shipment Incl. Tax Total   
SHIITMTOT  BCD*10.3  Shipment Item Total Amount   
SHIDISCBAS  BCD*10.3  Shipment Discount Base   
SHIDISCPER  BCD*5.5  Shipment Discount Percentage   
SHIDISCAMT  BCD*10.3  Shipment Discount Amount   
SHIMISC  BCD*10.3  Shipment Total Misc. Charges   
SHISUBTOT  BCD*10.3  Shipment Subtotal Amount   
SHINET  BCD*10.3  Shipment Total With Inv. Disc.   
SHIETAXTOT  BCD*10.3  Shipment Excl. Tax Total   
SHINETWTX  BCD*10.3  Shipment Total   
ORDDATE  Date  Order Date   
ORHOMECURR  String*3  Order Home Currency  Mask: %-3N
ORRATETYPE  String*2  Order Rate Type  Mask: %-2N
ORSOURCURR  String*3  Order Source Currency  Mask: %-3N
ORRATEDATE  Date  Order Rate Date   
ORRATE  BCD*8.7  Order Rate   
ORSPREAD  BCD*8.7  Order Spread   
ORDATEMTCH  Integer  Order Rate Date Matching   
ORRATEREP  Integer  Order Rate Operator   
ORRATEOVER  Boolean  Order Rate Override Flag   
AUTOTAXCAL  Boolean  Auto-Tax Calculation Status   
MULTIORD  Boolean  Generate From Multiple Orders  List: 2 entries
0=No
1=Yes
ORDS  Integer  From How Many Orders   
SHIPTRACK  String*36  Shipment Tracking Number   
NUMSHPMENT  Integer  Number of Shipments   
VALUES  Long  Optional Fields   
ORDUNIQ  BCD*10.0  Order Uniquifier   
ITEMDISTOT  BCD*10.3  Item Detail Discount Total   
MISCDISTOT  BCD*10.3  Misc. Charge Detail Discount Total   
STRMETHOD  Integer  Auto-Calc. Tax Reporting Amounts   
STRCURRNCY  String*3  Tax Reporting (TR) Currency  Mask: %-3N
STRRATTYPE  String*2  TR Rate Type  Mask: %-2N
STRRATDATE  Date  TR Rate Date   
STRRATE  BCD*8.7  TR Rate   
STRSPREAD  BCD*8.7  TR Spread   
STRDATMTCH  Integer  TR Rate Date Matching   
STRRATEOP  Integer  TR Rate Operator   
STRRATOVER  Boolean  TR Rate Override Flag   
STREAMNT1  BCD*10.3  TR Excluded Tax Amount 1   
STREAMNT2  BCD*10.3  TR Excluded Tax Amount 2   
STREAMNT3  BCD*10.3  TR Excluded Tax Amount 3   
STREAMNT4  BCD*10.3  TR Excluded Tax Amount 4   
STREAMNT5  BCD*10.3  TR Excluded Tax Amount 5   
STRIAMNT1  BCD*10.3  TR Included Tax Amount 1   
STRIAMNT2  BCD*10.3  TR Included Tax Amount 2   
STRIAMNT3  BCD*10.3  TR Included Tax Amount 3   
STRIAMNT4  BCD*10.3  TR Included Tax Amount 4   
STRIAMNT5  BCD*10.3  TR Included Tax Amount 5   
OTRCURRNCY  String*3  Tax Reporting (TR) Order Currency  Mask: %-3N
OTRRATTYPE  String*2  TR Order Rate Type  Mask: %-2N
OTRRATDATE  Date  TR Order Rate Date   
OTRRATE  BCD*8.7  TR Order Rate   
OTRSPREAD  BCD*8.7  TR Order Spread   
OTRDATMTCH  Integer  TR Order Rate Date Matching   
OTRRATEOP  Integer  TR Order Rate Operator   
OTRRATOVER  Boolean  TR Order Rate Override Flag   
DISAMTOVER  Boolean  Shipment Discount Amount Override   
SHNOPREPAY  Integer  Shipment No. of Prepayments   
JOBLINES  Long  Job Related Detail Lines   
LNINVABLE  Long  Invoiceable Detail Lines   
HASRTG  Boolean  Has Retainage  List: 2 entries
0=No
1=Yes
RTGTERMS  String*6  Retainage Terms  Mask: %-6N
RTGAMOUNT  BCD*10.3  Retainage Amount   
RTGPERCENT  BCD*5.5  Retainage Percent   
RTGRATE  Integer  Retainage Exchange Rate  List: 2 entries
0=Use Original Document Exchange Rate
1=Use Current Exchange Rate
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   
CUSACCTSET  String*6  Customer Account Set  Mask: %-6N
ENTEREDBY  String*8  Entered By  Mask: %-8N
DATEBUS  Date  Posting Date   

This page was generated on 2008-May-01

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