| Table Name: | ship_parts |
| Table Number: | 315 |
| Group: | Logistics |
| Description: | Information about a parts shipment |
| Flags: | |
| Baseline/Custom: | Baseline |
| Field Name | Common Type | Database Type | Generic Field ID | Array Size | Default | Flags | Comment | Field Used in Views |
|---|---|---|---|---|---|---|---|---|
| dev | LONG | int | 151 | 1 | DIRECT, ALLOW_NULL | Row version number for mobile distribution purposes | ||
| objid | LONG | int | 3 | DIRECT | Internal record number | Search (1) | ||
| packing_list | CHAR | varchar | 30 | The shipment packing list number | ||||
| pieces | LONG | int | 0 | DIRECT | Quantity of pieces in the shipment | Search (1) | ||
| ship_address | CHAR | varchar | 30 | Local copy of the ship address; line 1 | Search (1) | |||
| ship_address2 | CHAR | varchar | 30 | Local copy of the ship address; line 2 | Search (1) | |||
| ship_attn | CHAR | varchar | 30 | The first name of the person that is to receive the shipment. Defaulted from demand_hdr.ship_attn | ||||
| ship_attn2 | CHAR | varchar | 40 | Last name of the person that is to receive the shipment. Defaulted from demand_hdr.ship_attn2 | ||||
| ship_city | CHAR | varchar | 30 | Local copy of the ship city | Search (1) | |||
| ship_country | CHAR | varchar | 30 | Local copy of the ship country | ||||
| ship_date | CLK_TIME | datetime | Date shipper was created | Search (1) | ||||
| ship_state | CHAR | varchar | 30 | Local copy of the ship state | Search (1) | |||
| ship_to_name | CHAR | varchar | 2 | 40 | Name of the location being shipped to | Search (1) | ||
| ship_zip | CHAR | varchar | 10 | Local copy of the ship zip code | Search (1) | |||
| shipper_user | CHAR | varchar | 30 | Login name of user who created the ship parts | Search (1) | |||
| total_weight | FLOAT | real | Total shipment weight | Search (1) | ||||
| waybill | CHAR | varchar | 40 | The shipment waybill number | Search (1) |
| Relation | Type | Target Object | Inverse Relation | Comment | Flags | MTM Table | Used in Views |
|---|---|---|---|---|---|---|---|
| shipper2contr_itm | OTM | contr_itm | contr_itm2ship_parts | Related contr_itm for the shipment | |||
| shipment2demand_dtl | MTO | demand_dtl | demand_dtl2ship_parts | Reserved; not used. Use shipper2demand_dtl | |||
| shipper2demand_dtl | MTM | demand_dtl | demand_dtl2shipper | Related parts requests for the shipment | mtm_demand_dtl24_ ship_parts4 | ||
| shipment2part_trans | OTM | part_trans | fulf_trans2ship_parts | The related fulfill part_trans for the shipment | |||
| ship_parts2ship_dtl | OTM | ship_dtl | ship_dtl2ship_parts | Parts shipped | |||
| shpr2shp_sit_role | OTM | shp_sit_role | shp_role2ship_parts | Site roles for the ship_parts | |||
| carrier2vendor | MTO | site | carrier2ship_parts | The carrier for the shipment | Search (1) | ||
| shipped_by2user | MTO | user | shipped_by2ship_parts | User that created the shipment entry. Reserved |
| Index Name | Fields | Flags |
|---|
| Index Name | Fields | Additional Information |
|---|---|---|
| ind_carrier2vendor | carrier2vendor | nonclustered located on PRIMARY |
| objindex | objid | clustered, unique located on PRIMARY |
| View ID | View Name | Tables |
|---|---|---|
| 3 | ship_sum | condition, demand_dtl, gbst_elm, ship_dtl, ship_parts, site |
| ship_parts | |||