| # | Name | Type | Key | Nullable | Default | Comment |
|---|---|---|---|---|---|---|
| 1 | shipmentid | varchar(30) | PRI | NO | - | - |
| 2 | itemnumber | int | PRI | NO | - | - |
| 3 | partid | varchar(30) | MUL | NO | - | - |
| 4 | partdescription | varchar(255) | - | YES | - | - |
| 5 | partrevisionid | varchar(30) | - | YES | - | - |
| 6 | orderid | varchar(30) | MUL | YES | - | - |
| 7 | orderitemnumber | int | - | YES | - | - |
| 8 | ordertype | varchar(2) | - | YES | - | - |
| 9 | stockedquantity | double | - | NO | - | - |
| 10 | traderquantityadvised | double | - | NO | - | - |
| 11 | traderuom | varchar(30) | - | YES | - | - |
| 12 | grossweight | double | - | NO | - | - |
| 13 | nettweight | double | - | NO | - | - |
| 14 | eutransactiontype | smallint | - | YES | - | - |
| 15 | eucommoditycode | varchar(10) | - | YES | - | - |
| 16 | eusupplementaryunits | double | - | YES | - | - |
| 17 | currentunitcost | double | - | NO | 0 | - |
| 18 | standardunitcost | double | - | NO | 0 | - |
| 19 | actualunitcost | double | - | NO | 0 | - |
| 20 | certificateofconformity | varchar(30) | - | YES | - | - |
| 21 | originalshipmentid | varchar(30) | MUL | YES | - | - |
| 22 | originalshipmentitemnumber | int | - | YES | - | - |
| 23 | originalshipmenttype | varchar(2) | - | YES | - | - |
| 24 | reasonforreturn | varchar(20) | - | YES | - | - |
| 25 | iscreditnoterequired | tinyint(1) | - | NO | 0 | - |
| 26 | shipmenttype | varchar(2) | PRI | NO | - | - |
| 27 | traderquantity | double | - | NO | 0 | - |
| 28 | createdby | varchar(36) | - | YES | - | - |
| 29 | createddate | timestamp | - | YES | CURRENT_TIMESTAMP | - |
| 30 | modifiedby | varchar(36) | - | YES | - | - |
| 31 | modifieddate | datetime(6) | - | YES | - | - |
| 32 | auditoperation | varchar(8) | - | YES | - | - |
| 33 | modifiedtimestamp | binary(8) | - | NO | - | - |
| 34 | status | varchar(20) | MUL | NO | NEW | - |
| 35 | isinvoiced | tinyint(1) | - | NO | - | - |
| 36 | loadreference | varchar(30) | - | YES | - | - |
| 37 | companyid | varchar(30) | - | YES | - | - |
| 38 | isconsignment | tinyint(1) | - | NO | 0 | - |
| 39 | olversionnumber | int | - | NO | 0 | - |
| 40 | itemtype | varchar(11) | - | NO | - | - |
| 41 | packsize | double | - | YES | - | - |
| 42 | datasheetrequired | tinyint(1) | - | NO | 0 | - |
| 43 | debitnote | varchar(20) | - | YES | - | - |
| 44 | rmaitemid | int | - | YES | - | - |
| 45 | qualityconcernid | int | - | YES | - | - |
| 46 | allocationnumber | int | MUL | YES | - | - |
| 47 | shipmentallocationid | int | MUL | YES | - | - |
| 48 | standardlandedcost | double | - | YES | - | - |
| 49 | pickstatus | varchar(15) | - | YES | - | - |
| 50 | isavailabletopick | tinyint(1) | - | NO | - | - |
| 51 | countryoforiginid | varchar(3) | - | YES | - | - |
| 52 | notinvoiceddate | date | - | YES | - | - |
| Name | Unique | Columns |
|---|---|---|
| PRIMARY | Yes | shipmentid, shipmenttype, itemnumber |
| ix_shipit_alloc | No | shipmentid, itemnumber, shipmenttype, shipmentallocationid |
| ix_shipit_alloc2 | No | shipmentallocationid |
| ix_shipit_alloc3 | No | allocationnumber |
| ix_shipitem_alloc4 | No | shipmenttype, shipmentallocationid, shipmentid, itemnumber |
| ix_shpitem_orditem | No | orderid, ordertype, orderitemnumber |
| ix_shpitem_shpall | No | shipmenttype, shipmentallocationid |
| ix_shpitem_shpitem | No | originalshipmentid, originalshipmenttype, originalshipmentitemnumber |
| ix_shpitem_stocksum | No | partid, stockedquantity, status, shipmentid, itemnumber, shipmenttype, orderid, orderitemnumber |
| ix_shpitm_shpall | No | shipmenttype, shipmentallocationid |
| ix_shpitms_clust | No | shipmentid, shipmenttype, status |
| status | No | status |
| Status | Count |
|---|---|
| COMPLETE | 544,982 |
| CANCELLED | 8,834 |
| NEW | 1,573 |
| Column | References |
|---|---|
| orderid | orderitems_20260303.orderid |
| orderitemnumber | orderitems_20260303.itemnumber |
| ordertype | orderitems_20260303.ordertype |
| originalshipmentid | shipmentitems.shipmentid |
| originalshipmentitemnumber | shipmentitems.itemnumber |
| originalshipmenttype | shipmentitems.shipmenttype |
| shipmentid | shipments.id |
| shipmenttype | shipments.shipmenttype |