Get Order Releases
get
/shipments/{shipmentGid}/orderReleases
Request
Path Parameters
-
shipmentGid(required): string
Resource ID
Query Parameters
-
expand: string
Comma-delimited string of child resource names that you want to expand so that the contents return with the parent in the same GET request.
-
fields: string
Comma-delimited string of field names that you wanted returned in a GET request.
-
limit: integer(int32)
Positive integer value that specifies the maximum number of items returned by the server.
-
offset: integer(int32)
Non-negative integer values that specifies the index of the first item to be returned. The offset index begins at 0. By default, the offset is 0, which returns all items starting from the first item in the collection.
-
orderBy: string
Comma-separated string of field names, each optionally followed by asc or desc, that specifies the order of items returned in the response payload.
-
q: string
Filter (a 'where'clause) to restrict the items returned in the collection. By default, no filtering is applied.
-
totalResults: boolean
Boolean value that specifies whether to calculate the totalResults property. By default, this value is set to false indicating that totalResults is not calculated.
There's no request body for this operation.
Back to TopResponse
Supported Media Types
- application/vnd.oracle.resource+json;type=collection
Default Response
Default Response.
Nested Schema : shipments.orderReleases
Type:
Show Source
object-
allocationGroupGid: string
The allocation group that was calculated if the order travels from the plan from to the plan to as a single group order.
-
assignedItineraryGid: string
The buy side itinerary that was selected when planning the order release.
-
assignedSellItineraryGid: string
The sell side itinerary that was selected when planning the order release.
-
attribute1: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute10: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute11: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute12: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute13: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute14: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute15: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute16: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute17: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute18: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute19: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute2: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute20: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute3: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute4: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute5: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute6: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute7: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute8: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attribute9: string
Attribute fields (flexfields) allow you to add additional information about an object. Data type VARCHAR2 (150)
-
attributeCurrency1:
attributeCurrency1
The attribute currency of the shipment.
-
attributeCurrency2:
attributeCurrency2
The attribute currency of the shipment.
-
attributeCurrency3:
attributeCurrency3
The attribute currency of the shipment.
-
attributeDate1:
attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate10:
attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate11:
attributeDate11
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate12:
attributeDate12
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate13:
attributeDate13
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate14:
attributeDate14
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate15:
attributeDate15
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate16:
attributeDate16
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate17:
attributeDate17
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate18:
attributeDate18
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate19:
attributeDate19
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate2:
attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate20:
attributeDate20
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate3:
attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate4:
attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate5:
attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate6:
attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate7:
attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate8:
attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeDate9:
attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
-
attributeNumber1: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber10: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber11: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber12: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber13: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber14: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber15: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber16: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber17: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber18: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber19: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber2: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber20: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber3: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber4: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber5: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber6: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber7: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber8: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
attributeNumber9: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type NUMBER
-
bestDirectCostBuy:
bestDirectCostBuy
The buy side best direct cost that was calculated if the order travels from the plan from to the plan to as a single direct order.
-
bestDirectCostSell:
bestDirectCostSell
The sell side best direct cost that was calculated if the order travels from the plan from to the plan to as a single direct order.
-
bestDirectRateofferGidBuy: string
The buy side rate offering used to calculate the best buy direct cost.
-
bestDirectRateofferGidSell: string
The buy side rate offering used to calculate the best buy direct cost.
-
bufferType: string
Defines the buffer type if this order release is a buffer order that utilizes the buffer locations as points where the order will accumulate prior to moving on.
-
bulkPlanGid: string
If the order was planned onto a buy shipment via the bulk plan process, then the global identifier for the bulk plan.
-
bundlingType: string
AUTOMATIC or MANUAL ONLY allow bundling; they are distinguished only by user defined queries. DO NOT BUNDLE means order will never be bundled with other orders.
-
buyGeneralLedgerGid: string
The buy general ledger GID to be used for the order release costs.
-
buyItineraryProfileGid: string
The buy itinerary profile GID to be used as a constraint while planning the order release onto shipments.
-
commercialPaymentCodeGid: string
The commercial payment terms for the goods on the order release.
-
consolidationTypeGid: string
The type of consol (charter, vessel) to be used when assigning this order to the consol.
-
customerUnitizationRequest: boolean
The customer's request for unitization location.
-
defaultStowageMode: string
The default stowage mode to use for this order when loading onto stowage consol shipments.
-
deliveryIsAppt: boolean
A Y/N indicator for whether the early/late delivery times are appointment times.
-
deliveryRailCarrier: string
The delivery rail carrier used as identification on the shipment execution.
-
destLocationGid: string
The destination location GID.
-
destLocationOverrideGid: string
The destination location override GID used to define a new destination location scheduling the order while still retaining the original destination location.
-
destuffLocationGid: string
The location for destuffing (unloading) the container after the ocean move.
-
dimRateFactorGid: string
The dim factor GID to be used when calculating dimensional rates.
-
domainName: string
Database domain where this data is stored.
-
dropoffRoutingSequenceGid: string
The pickup location routing sequence that controls how the stops can be planned for pickup such as first, absolute first, last.
-
dutyPaid: string
Indicating if duty is to be paid for the order release.
-
earliestEstPickupDate:
earliestEstPickupDate
The earliest estimated pickup that was calculated if the order travels from the plan from to the plan to as a single estimated order.
-
earlyDeliveryDate:
earlyDeliveryDate
The early delivery date and time defined for the order release; can be null.
-
earlyPickupDate:
earlyPickupDate
The early pickup date and time defined for the order release; can be null.
-
earlySailDate:
earlySailDate
No description.
-
emPhoneNumber: string
The emergency phone number when shipping hazardous materials. The 24 hours contact for the shipment.
-
equipmentGroupGid: string
The buy equipment group GID to be used as a constraint while planning the order release onto shipments.
-
equipmentGroupProfileGid: string
The buy equipment group profile GID to be used as a constraint while planning the order release onto shipments.
-
equipmentTypeGid: string
The buy equipment type GID to be used as a constraint while planning the order release onto shipments.
-
externalSystemId: string
The external system ID used for the source of the order release.
-
externalVoyageCode: string
Specifies the number of the voyage as assigned by the carrier.After the voyages are queried from an external voyage service and the user selects a particular voyage result,the voyage number selected for this result will be saved in this column.
This will be used while planning the order for a shipment.
-
finalIncoTerm: string
The final INCO term associated with the order release.
-
finalTextLocation: string
The final text location for the INCO terms.
-
fixedItineraryGid: string
The fixed buy side itinerary can be defined to force the order release to be schedule with a constrained itinerary.
-
fixedSellItineraryGid: string
The fixed sell side itinerary can be defined to force the order release to be schedule with a constrained itinerary.
-
importLicenseExpirationDate:
importLicenseExpirationDate
The date the import license will expire.
-
importLicenseIssueDate:
importLicenseIssueDate
The import license issue date.
-
importLicenseNumber: string
The import license number.
-
importLicenseReceiveDate:
importLicenseReceiveDate
The import license received date.
-
importLicenseRequired: string
A Y/N indicator for whether this order requires an import license.
-
incoTermGid: string
The INCO terms GID.
-
inspectionDate:
inspectionDate
The inspection actual date associated with the inspection number.
-
inspectionNumber: string
An inspection number for the order release for informational purposes.
-
inspectionRequired: string
A Y/N indicator for whether an inspection is required.
-
inspectionScheduleDate:
inspectionScheduleDate
The inspection scheduled date associated with the inspection number.
-
isConsolidateOrEquipment: boolean
Whether to consolidate order release equipment when bundling.
-
isDirectVoyage: boolean
The flag indicates whether only direct voyages, that is voyages without trans-shipments should be retrieved by an external voyage service.
It will be used for querying the voyage based on data from order release.
-
isIgnoreLocationCalendar: boolean
A Y/N field indicating whether the location calendar should be ignored when planning shipments for the order. If NULL, treat it as N.
-
isKnownShipper: boolean
A Y/N indicator for whether the shipper involved party is a known shipper for air travel.
-
isLocRequired: boolean
A Y/N field indicating whether a letter of credit is required for the order release.
-
isLocStale: boolean
A Y/N field indicating whether the letter of credit is stale or expired.
-
isPreEnteredPu: boolean
A Y/N field indicating whether the order release is a pre-entered pickup for customs processing.
-
isSplittable: boolean
A Y/N field that indicates whether the order release can be split when planning during container optimization.
-
isTemplate: boolean
A Y/N indicator specifying this order release as a template if the value is Y.
-
isTopoff: boolean
This field indicates whether the order is a topoff order or not.
-
lateDeliveryDate:
lateDeliveryDate
The late delivery date and time defined for the order release; can be null.
-
latePickupDate:
latePickupDate
The latest pickup date and time defined for the order release; can be null.
-
lateSailDate:
lateSailDate
No description.
-
latestEstDeliveryDate:
latestEstDeliveryDate
The latest estimate delivery date calculated from the last leg shipments.
-
latestEstPickupDate:
latestEstPickupDate
The latest estimated pickup date calculated from the first leg shipments.
-
legConsolidationGroupGid: string
The leg consolidation group set during planning.
-
links: array
links
Read Only:
true -
loadPoint: string
The source load point for loading of the equipment if required.
-
locAdvisingNumber: string
The letter of credit advising number.
-
locAmount:
locAmount
The letter of credit amount.
-
locConfirmingNumber: string
The letter of credit confirming number.
-
locExpirationDate:
locExpirationDate
The letter of credit expiration date.
-
locIssueDate:
locIssueDate
The letter of credit issue date.
-
locLatestShippingDate:
locLatestShippingDate
The letter of credit latest shipping date.
-
locNegotiatedDays: number
(int32)
The letter of credit negotiated days.
-
locNumber: string
The letter of credit number.
-
locReceivedDate:
locReceivedDate
The letter of credit received date.
-
maxHeight: number
(double)
The maximum height calculated from the order release lines.
-
maxHeightBase: number
(double)
The maximum height in the base unit of measure.
-
maxHeightUomCode: string
The maximum height unit of measure.
-
maxLength: number
(double)
The max length calculated from the order release lines.
-
maxLengthBase: number
(double)
The max length in the base unit of measure.
-
maxLengthUomCode: string
The max length unit of measure.
-
maxWidth: number
(double)
The maximum width calculated from the order release lines.
-
maxWidthBase: number
(double)
The maximum width in the base unit of measure.
-
maxWidthUomCode: string
The maximum width unit of measure.
-
modeProfileGid: string
The buy mode profile GID to be used as a constraint while planning the order release onto shipments.
-
movePerspectiveGid: string
The mode perspective GID for the order release.
-
mustShipDirect: boolean
A Y/N indicator for whether this order release must ship direct.
-
mustShipThruPool: boolean
A Y/N indicator for whether this order release must ship through pool.
-
mustShipThruXDock: boolean
A Y/N indicator for whether this order release must ship through cross dock.
-
onRtExecution: boolean
A Y/N field indicating whether that a shipment built from this order release has been assigned to a route instance leg. For migration: old existing order releases migrated to the default value ('N').
-
orderBaseGid: string
The GID for the order base associated with the order release if this order release was generated from an order base.
-
orderReleaseGid: string
The GID for the order release.
-
orderReleaseName: string
An open field for you to enter another identifier (name) for the order release.
-
orderReleaseTypeGid: string
A GID to define the type of the order release. For example: Customer order, Distribution order, Manufacturing order, Purchase order, etc.
-
orderReleaseXid: string
The XID for the order release.
-
otmVersion: string
The OTM version number used when order was created.
-
partitionGid: string
The partition GID used as according to this name, bulk plan partition orders to be planned together in one partition.
-
paymentMethodCodeGid: string
The payment method GID.
-
pickupIsAppt: boolean
A Y/N indicator for whether the early/late pickup times are appointment times
-
pickupRailCarrier: string
The pickup rail carrier used as identification on the shipment execution.
-
pickupRoutingSequenceGid: string
The pickup location routing sequence that controls how the stops can be planned for pickup such as first, absolute first, last.
-
planFromLoadPoint: string
The load point associated with plan from location.
-
planFromLocationGid: string
The plan from location GID. This value can be a different location from the actual source location defined on the order release. The plan from location is where the system will start to plan the shipments for the order release.
-
planFromLocOverrideGid: string
The plan from location override GID used to define a new plan from location scheduling the order while still retaining the original plan from location.
-
planningGroupGid: string
The planning group GID to use when segmenting a large number of order releases into multiple smaller bulk planning runs.
-
planToLocationGid: string
Must be Y or N. Y indicates that the order should not be bundled with any others. Order releasing logic will copy this value from the order base when the order is released.
-
planToLocOverrideGid: string
The plan to location override GID used to define a new plan to location scheduling the order while still retaining the original plan to location.
-
planToUnloadPoint: string
The unload point associated with plan to location.
-
portOfDisLocationGid: string
Location GID of the port of discharge for primary leg carrier.
-
portOfDisLocOverrideGid: string
Location override GID of the port of discharge for primary leg carrier.
-
portOfLoadLocationGid: string
Location GID of the port of load for the primary leg carrier.
-
portOfLoadLocOverrideGid: string
Location override GID of the port of load for the primary leg carrier.
-
predictedOrderRoute: string
Stores the predicted order route path.
-
primaryLegDestLocGid: string
Location GID of destination for primary leg shipment.
-
primaryLegSourceLocGid: string
Location GID of source for primary leg shipment
-
primLegDestOverrideLocGid: string
Location override GID of destination for primary leg shipment.
-
primLegSrcLocOverrideGid: string
Location override GID of source for primary leg shipment
-
priority: number
(int32)
The priority associated with an order release.
-
quoteGid: string
The quote GID generated if this order release went through the quoting process.
-
quoteOptionNumber: number
(int64)
The quote option number for the order release. Informational.
-
railRouteCodeGid: string
The buy itinerary profile GID to be used as a constraint while planning the order release onto shipments.
-
rateGeoGid: string
The buy rate detail GID to be used as a constraint while planning the order release onto shipments.
-
rateOfferingGid: string
The buy rate offering GID to be used as a constraint while planning the order release onto shipments.
-
rateServiceGid: string
The buy rate service GID to be used as a constraint while planning the order release onto shipments.
-
rateServiceProfileGid: string
The buy rate service profile GID to be used as a constraint while planning the order release onto shipments.
-
releaseMethodGid: string
The release method GID is the order configuration rule and this drives the configuration of the order such as ship unit or line as well as various calculations.
-
routingConstraintGid: string
The buy itinerary profile GID to be used as a constraint while planning the order release onto shipments.
-
secondaryTVolume:
secondaryTVolume
The secondary total volume for the order that sums up the secondary weight values from the order release lines.
-
secondaryTWeight:
secondaryTWeight
The secondary total weight for the order that sums up secondary weight values from the order release line.
-
sellBulkPlanGid: string
If the order was planned onto a sell shipment via the bulk plan process, then the global identifier for the bulk plan.
-
sellGeneralLedgerGid: string
The sell general ledger GID to be used for the order release revenue.
-
sellItineraryProfileGid: string
The sell itinerary profile GID to be used as a constraint while planning the order release onto shipments.
-
sellRateGeoGid: string
The sell rate detail GID to be used as a constraint while planning the order release onto shipments.
-
sellRateOfferingGid: string
The sell rate offering GID to be used as a constraint while planning the order release onto shipments.
-
sellServprovGid: string
The sell service provider GID to be used as a constraint while planning the order release onto shipments.
-
sellServprovProfileGid: string
The sell service provider GID to be used as a constraint while planning the order release onto shipments.
-
servprovGid: string
The buy service provider GID to be used as a constraint while planning the order release onto shipments.
-
servprovProfileGid: string
The buy service provider profile GID to be used as a constraint while planning the order release onto shipments.
-
shipUnitDiameter:
shipUnitDiameter
The diameter of the ship unit for cyclindrical objects. This column will show value only if the order release has one ship unit.
-
shipUnitHeight:
shipUnitHeight
The height of the ship unit. This column will show value only if the order release has one ship unit.
-
shipUnitLength:
shipUnitLength
The length of the ship unit. This column will show value only if the order release has one ship unit.
-
shipUnitOrigin: string
Indicates how the ship units were created (BL=order base by line, BS=order base by ship unit, RL=order release by line, RS=order release by ship unit). If this field is not 'RS' (formerly 'U'), the system deletes all existing order ship unit for the given order release, before calling new releasing logic to generate ship unit.
-
shipUnitWidth:
shipUnitWidth
The width of the ship unit. This will show a value only if the order release has one ship unit.
-
shipWithGroup: string
Ship with group tags orders that need to be placed on a shipment together.
-
sourceLocationGid: string
The source location GID.
-
srcLocationOverrideGid: string
The source location override GID used to define a new source location scheduling the order while still retaining the original source location.
-
stuffLocationGid: string
The location for stuffing (loading) the container prior to shipping.
-
surveyLayCanDate:
surveyLayCanDate
The survey lay can date for the order release.
-
templateType: string
Hide template created for customer from other order UI. "Customer" is for customer template.
-
termLocationText: string
Location text that can be entered.
-
timeWindowEmphasisGid: string
The time window emphasis to be used when calculating the best start times for shipment, it can emphasize the pickup or delivery windows.
-
totalDeclaredValue:
totalDeclaredValue
The total declared value calculated from the order release lines.
-
totalItemPackageCount: number
(int32)
The total item package count calculated from the order release lines.
-
totalNetVolume:
totalNetVolume
The total net volume calculated from the order release lines.
-
totalNetWeight:
totalNetWeight
The total net weight calculated from the order release lines.
-
totalPackagingUnitCount: number
(int32)
The total packaging unit count calculated from the order release lines
-
totalShipUnitCount: number
(int32)
The total number of ship units calculated from the order release ship units.
-
totalVolume:
totalVolume
The total volume calculated from the order release lines.
-
totalWeight:
totalWeight
The total weight calculated from the order release lines.
-
transportHandlingUnitGid: string
The transport handling unit associated with the ship unit dimension values. This columns will show value only if the order release has one ship unit.
-
transportModeGid: string
The buy transport mode GID to be used as a constraint while planning the order release onto shipments.
-
ultDestCountryCode3Gid: string
The ultimate destination country code for this order release. It may be beyond the plan to or destination location defined on the order release.
-
unitizationConditionName: string
The unitization (loading of equipment) condition name value.
-
unloadPoint: string
The destination unload point for the unloading of the equipment if required.
-
userDefined1IconGid: string
Can store a user-defined icon that will appear within the user interface to help visually identify attributes of the order release.
-
userDefined2IconGid: string
Can store a user-defined icon that will appear within the user interface to help visually identify attributes of the order release.
-
userDefined3IconGid: string
Can store a user-defined icon that will appear within the user interface to help visually identify attributes of the order release.
-
userDefined4IconGid: string
Can store a user-defined icon that will appear within the user interface to help visually identify attributes of the order release.
-
userDefined5IconGid: string
Can store a user-defined icon that will appear within the user interface to help visually identify attributes of the order release.
-
voyageGid: string
No description.
Nested Schema : attributeCurrency1
The attribute currency of the shipment.
Match All
The attribute currency of the shipment.
Show Source
Nested Schema : attributeCurrency2
The attribute currency of the shipment.
Match All
The attribute currency of the shipment.
Show Source
Nested Schema : attributeCurrency3
The attribute currency of the shipment.
Match All
The attribute currency of the shipment.
Show Source
Nested Schema : attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate11
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate12
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate13
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate14
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate15
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate16
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate17
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate18
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate19
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate20
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Show Source
Nested Schema : bestDirectCostBuy
The buy side best direct cost that was calculated if the order travels from the plan from to the plan to as a single direct order.
Match All
The buy side best direct cost that was calculated if the order travels from the plan from to the plan to as a single direct order.
Show Source
Nested Schema : bestDirectCostSell
The sell side best direct cost that was calculated if the order travels from the plan from to the plan to as a single direct order.
Match All
The sell side best direct cost that was calculated if the order travels from the plan from to the plan to as a single direct order.
Show Source
Nested Schema : earliestEstPickupDate
The earliest estimated pickup that was calculated if the order travels from the plan from to the plan to as a single estimated order.
Match All
The earliest estimated pickup that was calculated if the order travels from the plan from to the plan to as a single estimated order.
Show Source
Nested Schema : earlyDeliveryDate
The early delivery date and time defined for the order release; can be null.
Match All
The early delivery date and time defined for the order release; can be null.
Show Source
Nested Schema : earlyPickupDate
The early pickup date and time defined for the order release; can be null.
Match All
The early pickup date and time defined for the order release; can be null.
Show Source
Nested Schema : importLicenseExpirationDate
The date the import license will expire.
Match All
The date the import license will expire.
Show Source
Nested Schema : importLicenseIssueDate
The import license issue date.
Match All
The import license issue date.
Show Source
Nested Schema : importLicenseReceiveDate
The import license received date.
Match All
The import license received date.
Show Source
Nested Schema : inspectionDate
The inspection actual date associated with the inspection number.
Match All
The inspection actual date associated with the inspection number.
Show Source
Nested Schema : inspectionScheduleDate
The inspection scheduled date associated with the inspection number.
Match All
The inspection scheduled date associated with the inspection number.
Show Source
Nested Schema : lateDeliveryDate
The late delivery date and time defined for the order release; can be null.
Match All
The late delivery date and time defined for the order release; can be null.
Show Source
Nested Schema : latePickupDate
The latest pickup date and time defined for the order release; can be null.
Match All
The latest pickup date and time defined for the order release; can be null.
Show Source
Nested Schema : latestEstDeliveryDate
The latest estimate delivery date calculated from the last leg shipments.
Match All
The latest estimate delivery date calculated from the last leg shipments.
Show Source
Nested Schema : latestEstPickupDate
The latest estimated pickup date calculated from the first leg shipments.
Match All
The latest estimated pickup date calculated from the first leg shipments.
Show Source
Nested Schema : locAmount
The letter of credit amount.
Match All
The letter of credit amount.
Show Source
Nested Schema : locExpirationDate
The letter of credit expiration date.
Match All
The letter of credit expiration date.
Show Source
Nested Schema : locIssueDate
The letter of credit issue date.
Match All
The letter of credit issue date.
Show Source
Nested Schema : locLatestShippingDate
The letter of credit latest shipping date.
Match All
The letter of credit latest shipping date.
Show Source
Nested Schema : locReceivedDate
The letter of credit received date.
Match All
The letter of credit received date.
Show Source
Nested Schema : secondaryTVolume
The secondary total volume for the order that sums up the secondary weight values from the order release lines.
Match All
The secondary total volume for the order that sums up the secondary weight values from the order release lines.
Show Source
Nested Schema : secondaryTWeight
The secondary total weight for the order that sums up secondary weight values from the order release line.
Match All
The secondary total weight for the order that sums up secondary weight values from the order release line.
Show Source
Nested Schema : shipUnitDiameter
The diameter of the ship unit for cyclindrical objects. This column will show value only if the order release has one ship unit.
Match All
The diameter of the ship unit for cyclindrical objects. This column will show value only if the order release has one ship unit.
Show Source
Nested Schema : shipUnitHeight
The height of the ship unit. This column will show value only if the order release has one ship unit.
Match All
The height of the ship unit. This column will show value only if the order release has one ship unit.
Show Source
Nested Schema : shipUnitLength
The length of the ship unit. This column will show value only if the order release has one ship unit.
Match All
The length of the ship unit. This column will show value only if the order release has one ship unit.
Show Source
Nested Schema : shipUnitWidth
The width of the ship unit. This will show a value only if the order release has one ship unit.
Match All
The width of the ship unit. This will show a value only if the order release has one ship unit.
Show Source
Nested Schema : surveyLayCanDate
The survey lay can date for the order release.
Match All
The survey lay can date for the order release.
Show Source
Nested Schema : totalDeclaredValue
The total declared value calculated from the order release lines.
Match All
The total declared value calculated from the order release lines.
Show Source
Nested Schema : totalNetVolume
The total net volume calculated from the order release lines.
Match All
The total net volume calculated from the order release lines.
Show Source
Nested Schema : totalNetWeight
The total net weight calculated from the order release lines.
Match All
The total net weight calculated from the order release lines.
Show Source
Nested Schema : totalVolume
The total volume calculated from the order release lines.
Match All
The total volume calculated from the order release lines.
Show Source
Nested Schema : totalWeight
The total weight calculated from the order release lines.
Match All
The total weight calculated from the order release lines.
Show Source
Nested Schema : currencyType
Type:
Show Source
object-
currency: string
ISO 4217 currency code
-
value: number
Numeric value that specifies a currency
Nested Schema : dateTimeType
Type:
Show Source
object-
timezone: string
Timezone in Olson database format
-
value: string
(date-time)
Date in ISO 8601 format
Nested Schema : amountType
Type:
Show Source
object-
unit: string
Unit of measure
-
value: number
Numeric value that specifies an amount