|
Ordinal
|
Data
Description
|
Data Type
|
Data Length
|
Required
|
Check
Constraints
|
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
Number
|
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
'C' Credit
Sales Order
'R' Return
Material
Authorization
|
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)
|