# Table: Shipments

Table: OESHIH
View: OE0692
Record length: 3009
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: 192

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 Tot |
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 Currenc | 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 Overrid |

This page was generated on 2006-Sep-07

Copyright © 2001–2005 Sage Accpac International, Inc.