*
1
*
1
1
*
1
*
*
1
1
*
*
1
1
*
1
*
1
*
1
*
1
*
*
1
1
*
1
*
1
*
1
*
1
*
1
*
1
*
*
1
1
*
1
*
1
*
1
*
1
*
1
*
1
*
1
*
1
*
*
1
*
1
1
*
contactMechId
shipmentContactMechTypeId*
shipmentId*
ShipmentContactMech
ShipmentContactMech
description
shipmentContactMechTypeId*
ShipmentContactMechType
quantity
issuedByUserLoginId
issuedDateTime
maintHistSeqId
fixedAssetId
shipmentItemSeqId
shipmentId
inventoryItemId
shipGroupSeqId
orderItemSeqId
orderId
itemIssuanceId*
ItemIssuanceRole
ItemIssuance
roleTypeId *
partyId *
itemIssuanceId*
ItemIssuanceRole
invoiceItemSeqId *
invoiceId *
shipmentItemSeqId*
shipmentId*
ShipmentItemBilling
ShipmentItemFeature
ShippingDocuments
ItemIssuance
ShipmentItemBilling
shipmentContentDescription
quantity
productId
shipmentItemSeqId*
shipmentId*
ShipmentPackageContent
ShipmentItem
productFeatureId *
shipmentItemSeqId*
shipmentId*
ShipmentItemFeature
subProductQuantity
subProductId
quantity
shipmentPackageSeqId*
shipmentId*
shipmentItemSeqId*
ShipmentPackageContent
insuredAmount
codAmount
packageOtherCost
packageServiceCost
packageTransportCost
labelPrinted
labelHtml
labelIntlSignImage
labelImage
boxNumber
trackingCode
shipmentRouteSegmentId*
shipmentPackageSeqId*
shipmentId*
currencyUomId
ShipmentPackageRouteSeg
attrValue
attrName*
shipmentId*
ShipmentAttribute
ShipmentItem
ShipmentContactMech
ShipmentRouteSegment
ShipmentPackage
ShipmentAttribute
lastModifiedByUserLogin
lastModifiedDate
createdByUserLogin
createdDate
addtlShippingChargeDesc
additionalShippingCharge
partyIdFrom
partyIdTo
destinationTelecomNumberId
destinationContactMechId
originTelecomNumberId
originContactMechId
destinationFacilityId
originFacilityId
handlingInstructions
currencyUomId
estimatedShipCost
latestCancelDate
estimatedArrivalWorkEffId
estimatedArrivalDate
estimatedShipWorkEffId
estimatedShipDate
estimatedReadyDate
picklistBinId
primaryShipGroupSeqId
primaryOrderId
statusId
shipmentTypeId
shipmentId*
ShipmentStatus
Shipment
statusDate
shipmentId*
statusId*
ShipmentStatus
ChildShipmentType
Shipment
description
hasTable
parentTypeId
shipmentTypeId*
ShipmentTypeAttr
ShipmentType
attrName*
shipmentTypeId*
ShipmentTypeAttr
thirdPartyCountryGeoCode
thirdPartyPostalCode
thirdPartyAccountNumber
homeDeliveryDate
homeDeliveryType
lastUpdatedDate
updatedByUserLoginId
trackingDigest
trackingIdNumber
estimatedArrivalDate
estimatedStartDate
actualArrivalDate
actualStartDate
currencyUomId
actualCost
actualOtherCost
actualServiceCost
actualTransportCost
billingWeightUomId
billingWeight
carrierRestrictionDesc
carrierRestrictionCodes
carrierDeliveryZone
carrierServiceStatusId
shipmentMethodTypeId
carrierPartyId
destTelecomNumberId
destContactMechId
originTelecomNumberId
originContactMechId
destFacilityId
originFacilityId
deliveryId
shipmentRouteSegmentId*
shipmentId*
ShipmentPackageRouteSeg
Shipment:shipmentId
ShipmentRouteSegment
ShipmentCostEstimate
carrierServiceCode
sequenceNumber
partyId *
shipmentMethodTypeId*
roleTypeId *
CarrierShipmentMethod
fuelUsed
endMileage
startMileage
fixedAssetId
estimatedArrivalDate
estimatedStartDate
actualArrivalDate
actualStartDate
destFacilityId
originFacilityId
deliveryId*
ShipmentRouteSegment
Delivery
PicklistRole
PicklistBin
lastModifiedByUserLogin
createdByUserLogin
picklistDate
statusId
shipmentMethodTypeId
facilityId
description
picklistId*
PicklistStatusHistory
Picklist
PicklistItem
primaryShipGroupSeqId
primaryOrderId
binLocationNumber
picklistId
picklistBinId*
Shipment
PicklistBin
createdByUserLogin
thruDate
fromDate*
roleTypeId *
partyId *
picklistId*
lastModifiedByUserLogin
PicklistRole
statusIdTo
statusId
changeUserLoginId
changeDate*
picklistId*
PicklistStatusHistory
oversizeCode
packagingTypeCode
partyId *
shipmentBoxTypeId*
CarrierShipmentBoxType
CarrierShipmentBoxType
boxHeight
boxWidth
boxLength
dimensionUomId
description
shipmentBoxTypeId*
ShipmentPackage
ShipmentBoxType
featurePercent
oversizePrice
oversizeUnit
productFeatureGroupId
shippingPricePercent
orderItemFlatPrice
orderPricePercent
orderFlatPrice
priceUnitPrice
priceUomId
priceBreakId
quantityUnitPrice
quantityUomId
quantityBreakId
weightUnitPrice
weightUomId
weightBreakId
geoIdFrom
geoIdTo
roleTypeId
partyId
productStoreId
carrierRoleTypeId
carrierPartyId
shipmentMethodTypeId
shipmentCostEstimateId*
featurePrice
ShipmentCostEstimate
ShipmentRouteSegment
Picklist
CarrierShipmentMethod
description
shipmentMethodTypeId*
sequenceNum
ShipmentMethodType
description
shipmentPackageSeqId
shipmentItemSeqId
shipmentId
documentId *
ShippingDocument
1
*
1
*
ShippingDocument
ShipmentReceipt
ShipmentPackageRouteSeg
ShipmentPackageContent
insuredValue
weightUomId
weight
dateCreated
shipmentBoxTypeId
shipmentPackageSeqId*
shipmentId*
Shipment:shipmentId
ShipmentPackage
ShipmentReceipt
description
rejectionId*
RejectionReason
roleTypeId *
partyId *
receiptId*
ShipmentReceiptRole
quantityRejected
quantityAccepted
itemDescription
datetimeReceived
receivedByUserLoginId
rejectionId
returnItemSeqId
returnId
orderItemSeqId
orderId
shipmentPackageSeqId
shipmentId
productId
inventoryItemId
receiptId*
ShipmentReceiptRole
Shipment:shipmentId
ShipmentReceipt
DROP_SHIPMENT Drop Shipment
INCOMING_SHIPMENT Incoming
OUTGOING_SHIPMENT Outgoing
PURCHASE_RETURN Purchase Return
PURCHASE_SHIPMENT Purchase Shipment
SALES_RETURN Sales Return
SALES_SHIPMENT Sales Shipment
TRANSFER Transfer
SHIP_FROM_ADDRESS Ship-From Address
SHIP_FROM_EMAIL Ship-From E-Mail
SHIP_FROM_TELECOM Ship-From Telecom Number
SHIP_TO_ADDRESS Ship-To Address
SHIP_TO_TELECOM Ship-To Telecom Number
SHIP_TO-EMAIL Ship-To E-Mail
PICKLIST_STATUS
PICKLIST_ASSIGNED Assigned
PICKLIST_CANCELLED Cancelled
PICKLIST_INPUT Input
PICKLIST_PICKED Picked
PICKLIST_PRINTED Printed
SHIPMENT_STATUS
SHIPMENT_DELIVERED Delivered
SHIPMENT_INPUT Input
SHIPMENT_PACKED Packed
SHIPMENT_PICKED Picked
SHIPMENT_SCHEDULED Scheduled
SHIPMENT_SHIPPED Shipped
SHPRTSG_CS_STATUS
SHRSCS_ACCEPTED Accepted
SHRSCS_CONFIRMED Confirmed
SHRSCS_NOT_STARTED Not Started
SHRSCS_VOIDED Voided
PURCH_SHIP_STATUS
PURCH_SHIP_CREATED Created
PURCH_SHIP_RECEIVED Received
PURCH_SHIP_SHIPPED Shipped
itemStatusId
inventoryItemId *
shipGroupSeqId *
orderItemSeqId *
orderId *
picklistBinId*
quantity
PicklistItem
PICKITEM_STATUS
PICKITEM_CANCELLED Cancelled
PICKITEM_COMPLETED Completed
PICKITEM_PENDING Pending
SHIPMENT_CANCELLED Cancelled
Detail Facility: Shipment Entities
Page 18