# View: Shipments

RotoID: OE0434
Tables:
DLL: OEISHIH

## Compositions: 4

RotoID | Title | Tables | DLL
--- | --- | --- | ---
OE0433 | Shipment Details |  | OEISHID
OE0429 | Shipment Serial Numbers |  | OEISELS
OE0273 | Shipment Comments/Instructions |  | OEICOIS
OE0432 | Shipment Optional Fields |  | OEISHHO

## Keys: 1

Title | Fields
--- | ---
Shipment Uniquifier Key | SHIUNIQ

## Fields: 235

Field | Index | Type | Title | Attributes | Presentation
--- | --- | --- | --- | --- | ---
SHIUNIQ | 1 | BCD*10.0 | Shipment Uniquifier | E A K R |
SHINUMBER | 2 | String*22 | Shipment Number | E A | Mask: %-22C
ORDNUMBER | 3 | String*22 | Order Number | E A | Mask: %-22C
DAYENDNUM | 4 | BCD*10.0 | I/C Day End Trans. Number | E A C |
CUSTOMER | 5 | String*12 | Customer Number | E A | Mask: %-12C
CUSTGROUP | 6 | String*6 | Customer Group Code | E A | Mask: %-6C
BILNAME | 7 | String*60 | Bill-To Name | E A |
BILADDR1 | 8 | String*60 | Bill-To Address Line 1 | E A |
BILADDR2 | 9 | String*60 | Bill-To Address Line 2 | E A |
BILADDR3 | 10 | String*60 | Bill-To Address Line 3 | E A |
BILADDR4 | 11 | String*60 | Bill-To Address Line 4 | E A |
BILCITY | 12 | String*30 | Bill-To City | E A |
BILSTATE | 13 | String*30 | Bill-To State/Province | E A |
BILZIP | 14 | String*20 | Bill-To Zip/Postal Code | E A |
BILCOUNTRY | 15 | String*30 | Bill-To Country | E A |
BILPHONE | 16 | String*30 | Bill-To Phone Number | E A | Mask: (%-3C) %-3C-%-24C
BILFAX | 17 | String*30 | Bill-To Fax Number | E A | Mask: (%-3C) %-3C-%-24C
BILCONTACT | 18 | String*60 | Bill-To Contact | E A |
BILEMAIL | 19 | String*50 | Bill-To E-mail | E A |
BILPHONEC | 20 | String*30 | Bill-To Contact Phone | E A | Mask: (%-3C) %-3C-%-24C
BILFAXC | 21 | String*30 | Bill-To Contact Fax | E A | Mask: (%-3C) %-3C-%-24C
BILEMAILC | 22 | String*50 | Bill-To Contact E-mail | E A |
SHIPTO | 23 | String*6 | Ship-To Location Code | E A | Mask: %-6C
SHPNAME | 24 | String*60 | Ship-To Name | E A |
SHPADDR1 | 25 | String*60 | Ship-To Address Line 1 | E A |
SHPADDR2 | 26 | String*60 | Ship-To Address Line 2 | E A |
SHPADDR3 | 27 | String*60 | Ship-To Address Line 3 | E A |
SHPADDR4 | 28 | String*60 | Ship-To Address Line 4 | E A |
SHPCITY | 29 | String*30 | Ship-To City | E A |
SHPSTATE | 30 | String*30 | Ship-To State/Province | E A |
SHPZIP | 31 | String*20 | Ship-To Zip/Postal Code | E A |
SHPCOUNTRY | 32 | String*30 | Ship-To Country | E A |
SHPPHONE | 33 | String*30 | Ship-To Phone Number | E A | Mask: (%-3C) %-3C-%-24C
SHPFAX | 34 | String*30 | Ship-To Fax Number | E A | Mask: (%-3C) %-3C-%-24C
SHPCONTACT | 35 | String*60 | Ship-To Contact | E A |
SHPEMAIL | 36 | String*50 | Ship-To E-mail | E A |
SHPPHONEC | 37 | String*30 | Ship-To Contact Phone | E A | Mask: (%-3C) %-3C-%-24C
SHPFAXC | 38 | String*30 | Ship-To Contact Fax | E A | Mask: (%-3C) %-3C-%-24C
SHPEMAILC | 39 | String*50 | Ship-To Contact E-mail | E A |
CUSTDISC | 40 | Integer | Customer Discount Level | E A | List: 6 entries
0 | = | Base
1 | = | A
2 | = | B
3 | = | C
4 | = | D
5 | = | E
PRICELIST | 41 | String*6 | Default Price List Code | E A | Mask: %-6N
PONUMBER | 42 | String*22 | Purchase Order Number | E A | Mask: %-22C
TERRITORY | 43 | String*6 | Territory | E A | Mask: %-6N
TERMS | 44 | String*6 | Terms Code | E A | Mask: %-6N
REFERENCE | 45 | String*60 | Shipment Reference | E A |
SHIDATE | 46 | Date | Shipment Date | E A |
EXPDATE | 47 | Date | Expected Ship Date | E A |
SHIPVIA | 48 | String*6 | Ship-Via Code | E A | Mask: %-6N
VIADESC | 49 | String*60 | Ship-Via Code Description | E A |
SHIFISCYR | 50 | String*4 | Shipment Fiscal Year | E A | Mask: %-4d
SHIFISCPER | 51 | Integer | Shipment Fiscal Period | E A P |
LASTINVNUM | 52 | String*22 | Last Invoice Number | E A | Mask: %-22C
NUMINVOICE | 53 | Integer | Number of Invoices | E A |
FOB | 54 | String*60 | Free On Board Point | E A |
TEMPLATE | 55 | String*6 | Template Code | E A | Mask: %-6N
LOCATION | 56 | String*6 | Default Location Code | E A | Mask: %-6N
DESC | 57 | String*60 | Shipment Description | E A |
COMMENT | 58 | String*250 | Shipment Comment | E A |
OVERCREDIT | 59 | Boolean | Over Credit Limit | E A C |
APPROVELMT | 60 | BCD*10.3 | Approved Limit | E A C |
APPROVEBY | 61 | String*8 | Authorizing User ID | E A C | Mask: %-8N
PRINTSTAT | 62 | Integer | Order Print Status | E A C P |
LASTPOST | 63 | Date | Last Posting Date | E A C |
SHIPLABEL | 64 | Boolean | Requires Shipping Labels | E A C |
LBLPRINTED | 65 | Boolean | Shipping Labels Printed | E A C |
SHHOMECURR | 66 | String*3 | Shipment Home Currency | E A C | Mask: %-3N
SHRATETYPE | 67 | String*2 | Shipment Rate Type | E A X | Mask: %-2N
SHSOURCURR | 68 | String*3 | Shipment Source Currency | E A | Mask: %-3N
SHRATEDATE | 69 | Date | Shipment Rate Date | E A X |
SHRATE | 70 | BCD*8.7 | Shipment Rate | E A X |
SHSPREAD | 71 | BCD*8.7 | Shipment Spread | E A C |
SHDATEMTCH | 72 | Integer | Shipment Rate Date Matching | E A C |
SHRATEREP | 73 | Integer | Shipment Rate Representation | E A C |
SHRATEOVER | 74 | Boolean | Shipment Rate Override Flag | E A C |
SHITOTAL | 75 | BCD*10.3 | Total Amt. Items | E A C |
SHIMTOTAL | 76 | BCD*10.3 | Total Amt. Misc. Charges | E A C |
SHILINES | 77 | Integer | Number of Lines on Shipment | E A C |
NUMLABELS | 78 | Integer | Number of Labels | E A |
SHIPAYTOT | 79 | BCD*10.3 | Prev. Payments Total | E A C |
SHIPYDSTOT | 80 | BCD*10.3 | Prev. Payment Disc. Total | E A C |
SALESPER1 | 81 | String*8 | Salesperson 1 | E A | Mask: %-8N
SALESPER2 | 82 | String*8 | Salesperson 2 | E A | Mask: %-8N
SALESPER3 | 83 | String*8 | Salesperson 3 | E A | Mask: %-8N
SALESPER4 | 84 | String*8 | Salesperson 4 | E A | Mask: %-8N
SALESPER5 | 85 | String*8 | Salesperson 5 | E A | Mask: %-8N
SALESPLT1 | 86 | BCD*5.5 | Sales Percentage 1 | E A |
SALESPLT2 | 87 | BCD*5.5 | Sales Percentage 2 | E A |
SALESPLT3 | 88 | BCD*5.5 | Sales Percentage 3 | E A |
SALESPLT4 | 89 | BCD*5.5 | Sales Percentage 4 | E A |
SALESPLT5 | 90 | BCD*5.5 | Sales Percentage 5 | E A |
RECALCTAX | 91 | Boolean | Recalculate Tax | E A C |
TAXOVERRD | 92 | Boolean | Tax Overridden | E A C |
TAXGROUP | 93 | String*12 | Tax Group | E A | Mask: %-12N
TAUTH1 | 94 | String*12 | Tax Authority 1 | E A | Mask: %-12N
TAUTH2 | 95 | String*12 | Tax Authority 2 | E A | Mask: %-12N
TAUTH3 | 96 | String*12 | Tax Authority 3 | E A | Mask: %-12N
TAUTH4 | 97 | String*12 | Tax Authority 4 | E A | Mask: %-12N
TAUTH5 | 98 | String*12 | Tax Authority 5 | E A | Mask: %-12N
TCLASS1 | 99 | Integer | Tax Class 1 | E A |
TCLASS2 | 100 | Integer | Tax Class 2 | E A |
TCLASS3 | 101 | Integer | Tax Class 3 | E A |
TCLASS4 | 102 | Integer | Tax Class 4 | E A |
TCLASS5 | 103 | Integer | Tax Class 5 | E A |
TBASE1 | 104 | BCD*10.3 | Tax Base 1 | E A C |
TBASE2 | 105 | BCD*10.3 | Tax Base 2 | E A C |
TBASE3 | 106 | BCD*10.3 | Tax Base 3 | E A C |
TBASE4 | 107 | BCD*10.3 | Tax Base 4 | E A C |
TBASE5 | 108 | BCD*10.3 | Tax Base 5 | E A C |
TEAMOUNT1 | 109 | BCD*10.3 | Excluded Tax Amount 1 | E A C |
TEAMOUNT2 | 110 | BCD*10.3 | Excluded Tax Amount 2 | E A C |
TEAMOUNT3 | 111 | BCD*10.3 | Excluded Tax Amount 3 | E A C |
TEAMOUNT4 | 112 | BCD*10.3 | Excluded Tax Amount 4 | E A C |
TEAMOUNT5 | 113 | BCD*10.3 | Excluded Tax Amount 5 | E A C |
TIAMOUNT1 | 114 | BCD*10.3 | Included Tax Amount 1 | E A C |
TIAMOUNT2 | 115 | BCD*10.3 | Included Tax Amount 2 | E A C |
TIAMOUNT3 | 116 | BCD*10.3 | Included Tax Amount 3 | E A C |
TIAMOUNT4 | 117 | BCD*10.3 | Included Tax Amount 4 | E A C |
TIAMOUNT5 | 118 | BCD*10.3 | Included Tax Amount 5 | E A C |
TEXEMPT1 | 119 | String*20 | Registration 1 | E A |
TEXEMPT2 | 120 | String*20 | Registration 2 | E A |
TEXEMPT3 | 121 | String*20 | Registration 3 | E A |
TEXEMPT4 | 122 | String*20 | Registration 4 | E A |
TEXEMPT5 | 123 | String*20 | Registration 5 | E A |
COMPLETE | 132 | Integer | Shipment Completed | E A C | List: 5 entries
1 | = | Incomplete/Not Included
2 | = | Incomplete/Included
3 | = | Complete/Not Included
4 | = | Complete/Included
5 | = | Complete/Day End
COMPDATE | 133 | Date | Shipment Completion Date | E A C |
SHIWEIGHT | 134 | BCD*10.4 | Shipment Total Est. Weight | E A C |
NEXTDTLNUM | 135 | Integer | Next Detail Number | E A C |
SDISONMISC | 136 | Boolean | Shipment Disc. Misc. Charges | E A |
NOSHIPLINE | 137 | Integer | No. Lines Qty. Shipped | E A C |
NOMISCLINE | 138 | Integer | No. Misc. Charges Lines | E A C |
SHINETNOTX | 139 | BCD*10.3 | Shipment Total Before Tax | E A C |
SHIITAXTOT | 140 | BCD*10.3 | Shipment Incl. Tax Total | E A C |
SHIITMTOT | 141 | BCD*10.3 | Shipment Item Total Amount | E A C |
SHIDISCBAS | 142 | BCD*10.3 | Shipment Discount Base | E A C |
SHIDISCPER | 143 | BCD*5.5 | Shipment Discount Percentage | E A |
SHIDISCAMT | 144 | BCD*10.3 | Shipment Discount Amount | E A |
SHIMISC | 145 | BCD*10.3 | Shipment Total Misc. Charges | E A C |
SHISUBTOT | 146 | BCD*10.3 | Shipment Subtotal Amount | E A C |
SHINET | 147 | BCD*10.3 | Shipment Total With Inv. Disc. | E A C |
SHIETAXTOT | 148 | BCD*10.3 | Shipment Excl. Tax Total | E A C |
SHINETWTX | 149 | BCD*10.3 | Shipment Total | E A C |
ORDDATE | 150 | Date |  | E A C |
ORHOMECURR | 151 | String*3 | Order Home Currency | E A C | Mask: %-3N
ORRATETYPE | 152 | String*2 | Order Rate Type | E A X | Mask: %-2N
ORSOURCURR | 153 | String*3 | Order Source Currency | E A C | Mask: %-3N
ORRATEDATE | 154 | Date | Order Rate Date | E A X |
ORRATE | 155 | BCD*8.7 | Order Rate | E A X |
ORSPREAD | 156 | BCD*8.7 | Order Spread | E A C |
ORDATEMTCH | 157 | Integer | Order Rate Date Matching | E A C |
ORRATEREP | 158 | Integer | Order Rate Representation | E A C |
ORRATEOVER | 159 | Boolean | Order Rate Override Flag | E A C |
AUTOTAXCAL | 160 | Boolean | Auto-Tax Calculation Status | E A |
MULTIORD | 161 | Boolean | Generate From Multiple Orders? |  |
ORDS | 162 | Integer | From How Many Orders |  |
SHIPTRACK | 163 | String*36 | Shipment Tracking Number | E A |
NUMSHPMENT | 164 | Integer | Number of Shipments | E A |
VALUES | 165 | Long | Optional Fields | E A C |
ORDUNIQ | 166 | BCD*10.0 | Order Uniquifier | E A |
PCODDESC | 400 | String*60 | Price List Code Desc. | E A |
TERMDESC | 401 | String*60 | Terms Code Description | E A |
TXGRPDESC | 402 | String*60 | Tax Group Code Desc. | E A |
LOCDESC | 403 | String*60 | Location Code Desc. | E A |
SALES1NAME | 404 | String*60 | Salesperson Name 1 | E A |
SALES2NAME | 405 | String*60 | Salesperson Name 2 | E A |
SALES3NAME | 406 | String*60 | Salesperson Name 3 | E A |
SALES4NAME | 407 | String*60 | Salesperson Name 4 | E A |
SALES5NAME | 408 | String*60 | Salesperson Name 5 | E A |
TAUTH1DESC | 409 | String*60 | Tax Authority 1 Desc. | E A |
TAUTH2DESC | 410 | String*60 | Tax Authority 2 Desc. | E A |
TAUTH3DESC | 411 | String*60 | Tax Authority 3 Desc. | E A |
TAUTH4DESC | 412 | String*60 | Tax Authority 4 Desc. | E A |
TAUTH5DESC | 413 | String*60 | Tax Authority 5 Desc. | E A |
TCLAS1DESC | 414 | String*60 | Tax Class 1 Description | E A |
TCLAS2DESC | 415 | String*60 | Tax Class 2 Description | E A |
TCLAS3DESC | 416 | String*60 | Tax Class 3 Description | E A |
TCLAS4DESC | 417 | String*60 | Tax Class 4 Description | E A |
TCLAS5DESC | 418 | String*60 | Tax Class 5 Description | E A |
SHSRCDESC | 419 | String*60 | Shipment Source Curr. Desc. | E A |
SHHOMDESC | 420 | String*60 | Shipment Home Currency Desc. | E A |
SHRTTYDESC | 421 | String*60 | Shipment Rate Type Desc. | E A |
ORSRCDESC | 422 | String*60 | Shipment Source Currency Desc. | E A |
ORHOMDESC | 423 | String*60 | Shipment Home Currency Desc. | E A |
ORRTTYDESC | 424 | String*60 | Shipment Rate Type Description | E A |
TAMOUNT1 | 425 | BCD*10.3 | Total Tax Amount 1 | E A |
TAMOUNT2 | 426 | BCD*10.3 | Total Tax Amount 2 | E A |
TAMOUNT3 | 427 | BCD*10.3 | Total Tax Amount 3 | E A |
TAMOUNT4 | 428 | BCD*10.3 | Total Tax Amount 4 | E A |
TAMOUNT5 | 429 | BCD*10.3 | Total Tax Amount 5 | E A |
SHITAXTOT | 430 | BCD*10.3 | Total Tax Amount | E A |
RUNNINGTOT | 431 | BCD*10.3 | Shipment Running Total | E A |
GOCALCTAX | 432 | Boolean | Perform Tax Calculation | E A |
GOSHIPALL | 433 | Boolean | Perform Ship All | E A |
DOSCONVERT | 434 | Boolean | DOS Conversion in Progress | E A | List: 2 entries
0 | = | No
1 | = | Yes
GOFCALCTAX | 435 | Boolean | Perform Forced Tax Calculation | E A |
GODISTTAX | 436 | Boolean | Perform Distribution of Manual T | E A |
TXCALCINPG | 437 | Boolean | Tax Calculation in Progress | E A C |
EDTBASE1 | 438 | BCD*10.3 | Total Manual Tax Base 1 | A X |
EDTBASE2 | 439 | BCD*10.3 | Total Manual Tax Base 2 | A X |
EDTBASE3 | 440 | BCD*10.3 | Total Manual Tax Base 3 | A X |
EDTBASE4 | 441 | BCD*10.3 | Total Manual Tax Base 4 | A X |
EDTBASE5 | 442 | BCD*10.3 | Total Manual Tax Base 5 | A X |
EDTAMOUNT1 | 443 | BCD*10.3 | Total Manual Tax Amount 1 | A X |
EDTAMOUNT2 | 444 | BCD*10.3 | Total Manual Tax Amount 2 | A X |
EDTAMOUNT3 | 445 | BCD*10.3 | Total Manual Tax Amount 3 | A X |
EDTAMOUNT4 | 446 | BCD*10.3 | Total Manual Tax Amount 4 | A X |
EDTAMOUNT5 | 447 | BCD*10.3 | Total Manual Tax Amount 5 | A X |
RTWARNMSG | 448 | Boolean | Display Rate Warning | E A |
CUSTEXIST | 449 | Boolean | Customer Exists | E A |
SECENABLED | 450 | Boolean | Security Enabled | E A |
GOAPPROSEC | 451 | Boolean | User Can Approve Credit Lift | E A |
GOCHKCRDT | 452 | Boolean | Check Customer Credit Limit | E A |
APPPASSWRD | 453 | String*64 | Authorizing User Password | E A |
SWPARTSHIP | 454 | Integer | Allow partial shipments | E A | List: 2 entries
0 | = | No
1 | = | Yes
SHIP1ORDER | 455 | Boolean | Generate Shipmemt from Single Or | E A |
SHIPORDERS | 456 | Boolean | Generate Shipment from Multiple | E A |
CREATEINV | 457 | Boolean | Create Invoice from Shipment? | E A X |
INVNUMBER | 458 | String*22 | Invoice Number | E A | Mask: %-22C
EDDISCAMT | 459 | BCD*10.3 | Shipment Discount Amount | E A X |
POSTSEQNUM | 460 | Long | Post Sequence Number | A C |
INVUNIQ | 461 | BCD*10.0 | Invoice Uniquifier | E A |
INVDATE | 462 | Date | Invoice Date | E A |
INHOMECURR | 463 | String*3 | Invoice Home Currency | E A C | Mask: %-3N
INRATETYPE | 464 | String*2 | Invoice Rate Type | E A X | Mask: %-2N
INSOURCURR | 465 | String*3 | Invoice Source Currency | E A C | Mask: %-3N
INRATEDATE | 466 | Date | Invoice Rate Date | E A X |
INRATE | 467 | BCD*8.7 | Invoice Rate | E A X |
INSPREAD | 468 | BCD*8.7 | Invoice Spread | E A C |
INDATEMTCH | 469 | Integer | Invoice Rate Date Matching | E A C |
INRATEREP | 470 | Integer | Invoice Rate Operator | E A C |
INRATEOVER | 471 | Boolean | Invoice Rate Override Flag | E A C |
INSRCDESC | 472 | String*60 | Invoice Source Currency Desc. | E A |
INHOMDESC | 473 | String*60 | Invoice Home Currency Desc. | E A |
INRTTYDESC | 474 | String*60 | Invoice Rate Type Description | E A |
FROMORDER | 475 | Boolean | Created from Order? | E A |
PROCESSCMD | 476 | Integer | Process Command | E A C | List: 6 entries
0 | = | Nothing to Process
1 | = | Insert Optional Fields
2 | = | Default and Tranfer Optional Fields
3 | = | Default Opt. Fields During Record Generation
4 | = | Remove Optional Fields
5 | = | Transfer Opt. Fields from Standing Document

This page was generated on 2004-Oct-28

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