Table: Shipments

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

Keys: 6

Title  Flags  Fields

Shipment Uniquifier Key   SHIUNIQ
Shipment Number Key   SHINUMBER
Order/Shipment   ORDNUMBER, SHINUMBER
Customer/Shipment   CUSTOMER, SHINUMBER
Reference/Shipment   M  REFERENCE, SHINUMBER
  M  COMPLETE, SHIUNIQ

Fields: 162

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   

This page was generated on 2004-Oct-28

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