KS_SHIPMENTS
|
Ordinal |
Data |
Data Type |
Data Length |
Required |
Check
|
Comments |
|---|---|---|---|---|---|---|
|
1 |
Shipper Number |
string |
30 |
Y |
|
Used to lookup and either update or insert the delivery_no PK field |
|
2 |
Ship Line No |
integer |
4 |
Y |
|
|
|
3 |
Order Number |
string |
30 |
Y |
|
This is the RMA or Sales Order Number (refer to Order Type) |
|
4 |
Order Item |
integer |
4 |
Y |
|
This is the RMA or Sales Order line item number (may not correspond with the Shipment Line Item number |
|
5 |
Part Number |
string |
25 |
|
|
If the item exists in item_master, the FK will be updated. Regardless the delivery_item_xref_id will be updated as well from this field. |
|
6 |
Ship Date |
datetime |
|
|
|
|
|
7 |
Ship Quantity |
integer |
4 |
|
|
|
|
8 |
Ship Via |
string |
50 |
|
|
|
|
9 |
Ship Tracking No |
string |
50 |
|
|
The Shipment Tracking Number is used to locate in transit or delivered packages via the carrier's website (e.g. 'UPS','FEDEX'). The specific carrier's tracking URL is defined within KommerceServer and will automatically be linked in the WebPortal if properly defined. The carrier is determined based on the Ship Via for this shipment which should match one of the Ship Via codes sent up with the KS_FREIGHT export. |
|
10 |
Status |
string |
1 |
|
|
Any character is valid however recognized statuses include: S=shipped, X=canceled. If updated with "D" then this shipment will be considered deleted and will not be selected for display. |
|
11 |
Order Type |
string |
1 |
Y |
'S'
Sales order |
This field determines what type of order produced the shipment for lookup purposes only. |
|
12 |
Delivery Line Desc |
string |
50 |
|
|
This is a description of the delivery line item. In the case where a standard product is shipped, the product description is usually customary. This field is displayed in the Shipment Detail page |
|
13 |
Ship UOM |
string |
10 |
Y |
|
The shipping unit of measure for this shipment item. |
|
14 |
Deliver to Name |
string |
50 |
|
|
The name of the entity for the shipping destination (e.g. customer name or branch location) |
|
15 |
Deliver to Address 1 |
string |
75 |
|
|
Delivered to address line 1 of 3 |
|
16 |
Deliver to Address 2 |
string |
75 |
|
|
Delivered to address line 2 of 3 |
|
17 |
Deliver to Address 3 |
string |
75 |
|
|
Delivered to address line 3 of 3 |
|
18 |
Deliver to City |
string |
50 |
|
|
The city in which the shipment landed |
|
19 |
Deliver to State |
string |
50 |
|
|
The state in which the shipment landed |
|
20 |
Deliver to Postal |
string |
20 |
|
|
The postal code (zip) in which the shipment landed |
|
21 |
Deliver to Country |
string |
50 |
|
|
The country in which the shipment landed |
|
22 |
Deliver to Attention |
string |
50 |
|
|
The person receiving the shipment |
|
23 |
Deliver to Phone |
string |
20 |
|
|
The phone number to contact (required by some carriers) |