Get Order Releases
get
/orderReleases
Request
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 : orderReleases
Type:
Show Source
object
-
accessorials:
accessorials
-
accruals:
accruals
-
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.
-
allocations:
allocations
-
assignedItineraryGid: string
Read Only:
true
The buy side itinerary that was selected when planning the order release. -
assignedSellItineraryGid: string
Read Only:
true
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
Read Only:
true
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
Read Only:
true
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
Read Only:
true
The buy side rate offering used to calculate the best buy direct cost. -
bestDirectRateofferGidSell: string
Read Only:
true
The buy side rate offering used to calculate the best buy direct cost. -
bufferType: string
Read Only:
true
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
Read Only:
true
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.
-
destinationLocation:
destinationLocation
-
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.
-
documents:
documents
-
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
Read Only:
true
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.
-
equipments:
equipments
-
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.
-
insertDate:
insertDate
Read Only:
true
insert date -
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.
-
involvedParties:
involvedParties
-
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
Read Only:
true
The latest estimate delivery date calculated from the last leg shipments. -
latestEstPickupDate:
latestEstPickupDate
Read Only:
true
The latest estimated pickup date calculated from the first leg shipments. -
legConsolidationGroupGid: string
The leg consolidation group set during planning.
-
legConstraints:
legConstraints
-
lines:
lines
-
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
Read Only:
true
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.
-
planToLocation:
planToLocation
-
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
Read Only:
true
The buy rate detail GID to be used as a constraint while planning the order release onto shipments. -
rateOfferingGid: string
Read Only:
true
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.
-
refnums:
refnums
-
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.
-
remarks:
remarks
-
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
Read Only:
true
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
Read Only:
true
The sell rate detail GID to be used as a constraint while planning the order release onto shipments. -
sellRateOfferingGid: string
Read Only:
true
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.
-
services:
services
-
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.
-
shipUnits:
shipUnits
-
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.
-
sourceLocation:
sourceLocation
-
sourceLocationGid: string
The source location GID.
-
specialServices:
specialServices
-
srcLocationOverrideGid: string
The source location override GID used to define a new source location scheduling the order while still retaining the original source location.
-
statuses:
statuses
-
stops:
stops
-
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.
-
texts:
texts
-
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)
Read Only:
true
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)
Read Only:
true
The total packaging unit count calculated from the order release lines -
totalShipUnitCount: number
(int32)
Read Only:
true
The total number of ship units calculated from the order release ship units. -
totalVolume:
totalVolume
Read Only:
true
The total volume calculated from the order release lines. -
totalWeight:
totalWeight
Read Only:
true
The total weight calculated from the order release lines. -
trackingEvents:
trackingEvents
-
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.
-
updateDate:
updateDate
Read Only:
true
update date -
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 : accessorials
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : accruals
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : allocations
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate11
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate12
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate13
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate14
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate15
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate16
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate17
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate18
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate19
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate20
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : bestDirectCostBuy
Read Only:
true
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
Show Source
Nested Schema : bestDirectCostSell
Read Only:
true
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
Show Source
Nested Schema : destinationLocation
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : documents
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : earliestEstPickupDate
Read Only:
true
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
Show Source
Nested Schema : earlyDeliveryDate
The early delivery date and time defined for the order release; can be null.
Match All
Show Source
Nested Schema : earlyPickupDate
The early pickup date and time defined for the order release; can be null.
Match All
Show Source
Nested Schema : equipments
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : importLicenseExpirationDate
The date the import license will expire.
Match All
Show Source
Nested Schema : inspectionDate
The inspection actual date associated with the inspection number.
Match All
Show Source
Nested Schema : inspectionScheduleDate
The inspection scheduled date associated with the inspection number.
Match All
Show Source
Nested Schema : involvedParties
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : lateDeliveryDate
The late delivery date and time defined for the order release; can be null.
Match All
Show Source
Nested Schema : latePickupDate
The latest pickup date and time defined for the order release; can be null.
Match All
Show Source
Nested Schema : latestEstDeliveryDate
Read Only:
true
The latest estimate delivery date calculated from the last leg shipments.
Match All
Show Source
Nested Schema : latestEstPickupDate
Read Only:
true
The latest estimated pickup date calculated from the first leg shipments.
Match All
Show Source
Nested Schema : legConstraints
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : lines
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : locLatestShippingDate
The letter of credit latest shipping date.
Match All
Show Source
Nested Schema : planToLocation
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : refnums
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : remarks
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : secondaryTVolume
The secondary total volume for the order that sums up the secondary weight values from the order release lines.
Match All
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
Show Source
Nested Schema : services
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
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
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
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
Show Source
Nested Schema : shipUnits
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
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
Show Source
Nested Schema : sourceLocation
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : specialServices
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : statuses
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : stops
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : surveyLayCanDate
The survey lay can date for the order release.
Match All
Show Source
Nested Schema : texts
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : totalDeclaredValue
The total declared value calculated from the order release lines.
Match All
Show Source
Nested Schema : totalNetVolume
The total net volume calculated from the order release lines.
Match All
Show Source
Nested Schema : totalNetWeight
The total net weight calculated from the order release lines.
Match All
Show Source
Nested Schema : totalVolume
Read Only:
true
The total volume calculated from the order release lines.
Match All
Show Source
Nested Schema : totalWeight
Read Only:
true
The total weight calculated from the order release lines.
Match All
Show Source
Nested Schema : trackingEvents
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : orderReleases.accessorials
Type:
Show Source
object
-
accessorialCodeGid: string
The accessorial code used to specify that this accessorial needs to be covered when planning the shipment.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
Nested Schema : orderReleases.accruals
Type:
Show Source
object
-
accessorialCodeGid: string
If line accruals are enabled, this will be populated with the accessorial ID for the accrual line.
-
accruedDate:
accruedDate
The date the amount was accrued.
-
costTypeGid: string
If line accruals are enabled, this will be populated with the cost type for the accrual line.
-
delta:
delta
Delta or difference for the accrual calculated as: new amount - amount previously sent.
-
domainName: string
Database domain where this data is stored.
-
exchangeRateDate:
exchangeRateDate
The exchange rate date used for currency conversion calculation.
-
exchangeRateGid: string
The exchange rate GID used for currency conversion calculation.
-
freightCost:
freightCost
The total current allocated freight costs.
-
freightSentCost:
freightSentCost
Total allocated freight cost already sent via the accrual interface.
-
isReversal: boolean
A flag to determine whether the order release accrual is a reversal.
-
links: array
links
Read Only:
true
-
orderReleaseAccrualGid: string
The GID for this accrual entry.
-
orderReleaseAccrualXid: string
The XID for this accrual entry.
-
sentDate:
sentDate
Timestamp of when this accrual was sent from the system. Null means it has not been sent yet.
-
shipmentGid: string
The shipment GID associated to this accrual entry.
-
shipmentStartDate:
shipmentStartDate
The shipment start date used for exchange rate calculations.
Nested Schema : delta
Delta or difference for the accrual calculated as: new amount - amount previously sent.
Match All
Show Source
Nested Schema : exchangeRateDate
The exchange rate date used for currency conversion calculation.
Match All
Show Source
Nested Schema : freightSentCost
Total allocated freight cost already sent via the accrual interface.
Match All
Show Source
Nested Schema : sentDate
Timestamp of when this accrual was sent from the system. Null means it has not been sent yet.
Match All
Show Source
Nested Schema : shipmentStartDate
The shipment start date used for exchange rate calculations.
Match All
Show Source
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 : currencyType
Type:
Show Source
object
-
currency: string
ISO 4217 currency code
-
value: number
Numeric value that specifies a currency
Nested Schema : orderReleases.allocations
Type:
Show Source
object
-
allocationBase:
allocationBase
-
allocSeqNo: number
(int64)
No description.
-
baseCost:
baseCost
No description.
-
details:
details
-
domainName: string
No description.
-
exchangeRateDate:
exchangeRateDate
No description.
-
exchangeRateGid: string
No description.
-
links: array
links
Read Only:
true
-
privateCost:
privateCost
No description.
-
shipmentGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
-
totalAllocCost:
totalAllocCost
No description.
Nested Schema : allocationBase
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : details
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : orderReleases.allocations.allocationBase
Type:
Show Source
object
-
allocatedCost:
allocatedCost
No description.
-
allocSeqNo: number
(int64)
No description.
-
allocTypeQualGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
-
domainName: string
No description.
-
exchangeRateDate:
exchangeRateDate
No description.
-
exchangeRateGid: string
No description.
-
invoiceGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
-
links: array
links
Read Only:
true
-
parentInvoiceGid: string
If populated, the INVOICE_GID indicates that this alllocation is for a child invoice. This column indicates the parent invoice of the entire consolidation that was allocated.
-
shipGroupGid: string
Represents Shipment Group ID. This is populated when allocating a shipment group or a voucher corresponding to an invoice created for a shipment
group. -
shipmentGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
-
timestamp:
timestamp
No description.
-
voucherGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
Nested Schema : orderReleases.allocations.details
Type:
Show Source
object
-
accessorialCodeGid: string
No description.
-
allocCostSeqno: number
(int64)
No description.
-
attribute1: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute10: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute11: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute12: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute13: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute14: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute15: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute16: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute17: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute18: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute19: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute2: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute20: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute3: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute4: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute5: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute6: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute7: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute8: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute9: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attributeCurrency1:
attributeCurrency1
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
-
attributeCurrency2:
attributeCurrency2
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
-
attributeCurrency3:
attributeCurrency3
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
-
attributeDate1:
attributeDate1
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate10:
attributeDate10
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate11:
attributeDate11
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate12:
attributeDate12
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate13:
attributeDate13
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate14:
attributeDate14
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate15:
attributeDate15
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate16:
attributeDate16
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate17:
attributeDate17
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate18:
attributeDate18
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate19:
attributeDate19
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate2:
attributeDate2
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate20:
attributeDate20
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate3:
attributeDate3
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate4:
attributeDate4
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate5:
attributeDate5
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate6:
attributeDate6
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate7:
attributeDate7
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate8:
attributeDate8
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate9:
attributeDate9
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeNumber1: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber10: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber11: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber12: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber13: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber14: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber15: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber16: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber17: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber18: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber19: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber2: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber20: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber3: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber4: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber5: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber6: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber7: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber8: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber9: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
cost:
cost
No description.
-
costDescription: string
No description.
-
costTypeGid: string
cost type for this allocation record
-
domainName: string
No description.
-
exchangeRateDate:
exchangeRateDate
No description.
-
exchangeRateGid: string
No description.
-
generalLedgerGid: string
GL code for the allocation order release record.
-
invoiceGid: string
Invoice/Bill Gid would be stored in this field if allocation is done based on Invoice or Bill
-
lineitemSeqNo: number
(int32)
Voucher/Bill line item seq no would be stored if we perform allocation based on voucher or bill
-
links: array
links
Read Only:
true
-
shipmentCostSeqno: number
(int64)
Shipment cost seq no would be stored if we perform allocation based on shipment
-
shipmentGid: string
Shipment Gid would be stored in this field if allocation is done based on shipment
-
vatCodeGid: string
The GID for the VAT tax that is being allocated from voucher.
-
voucherGid: string
Voucher Gid would be stored in this field if allocation is done based on voucher
Nested Schema : attributeCurrency1
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
Match All
Show Source
Nested Schema : attributeCurrency2
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
Match All
Show Source
Nested Schema : attributeCurrency3
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
Match All
Show Source
Nested Schema : attributeDate1
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate10
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate11
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate12
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate13
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate14
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate15
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate16
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate17
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate18
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate19
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate2
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate20
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate3
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate4
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate5
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate6
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate7
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate8
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate9
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : locations
Type:
Show Source
object
-
accessorials:
accessorials
-
addresses:
addresses
-
addressUpdateDate:
addressUpdateDate
Date on which the details -CITY,COUNTRY,PROVINCE,PROVINCE_CODE,POSTAL_CODE are modified.RPLS checks this date before it starts screening.
-
addressValidationEde: string
Indicates which external distance engine is used to validate the location.
-
allowDriverRest: boolean
Indicates if a driver is allowed to take a rest period at this location if he runs out of available HOS.
-
appointDisplay:
appointDisplay
The duration of appointment display time period.
-
appointDisplayStartTime: number
(int32)
The start time of appointment view display.
-
appointmentActivityType: string
Appointment activity type refers to whether the appointment if for a drop trailer or live unload scenario.
-
apptAfterCutoff:
apptAfterCutoff
Service provider appointment duration after cutoff.
-
apptBeforeCutoff:
apptBeforeCutoff
Service provider appointment duration before cutoff.
-
apptCutoffHours: number
(double)
Service provider appointment cutoff in hours.
-
apptEnforceActTimeSg: boolean
Enforce Activity Time for shipment group appointments.
-
apptObjectType: string
Indicates the types of appointment objects this location handles. Shipments, Shipment Groups or both Shipments and Shipment Groups.
-
apptSearchDays: number
(double)
Use the Appointment Search Days field to override the value of the glog.appointment.searchDays property for this location. Set this field to control the number of days to look forward for the first feasible appointment.
-
apptShowNumberOfOptions: number
(double)
Use the Appointment Show Number Of Options field to override the value of the glog.appointment.scheduleAppointmentShowOptions.numberOfAppointments property for this location. Set this field to control how many appointments are displayed when running the Schedule Appointment - Show Options action on the Appointment Management page.
-
apptStartTimeToleranceSecs: number
(int32)
Stores tolerance value for appointment start time in seconds.
-
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)
-
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
-
attributeDate2:
attributeDate2
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
-
attributeNumber2: 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
-
bbIsNewStore: boolean
Indicates if this location should be treated as a new store by the Batch Balancer logic. New stores can only be assigned by Batch Balancer to a DOOR whose LOAD_NEW_STORE field is set to Y.
-
bbMaxCasesPerBatch: number
(double)
Maximum number of cases allowed in each batch. If blank, the system will assume that there is no limit. If the number of cases in the order exceeds this maximum, then the batch balancer's splitting logic will distribute the cases into multiple batches uniformly while honoring certain rules.
-
bbOrderSplitMethod: string
Value of "CONVEYABLE" causes only conveyable cases to be counted toward max cases, value of "ALL" causes all cases (including non-con and repack) to count toward max cases.
-
capacityGroups:
capacityGroups
-
city: string
The name of the city for the location.
-
contacts:
contacts
-
corporations:
corporations
-
countryCode3Gid: string
A GID to define the three digit country code.
-
countyQualifier: string
County Qualifier is used when calling an external distance engine and using an address type of city instead of postal code. Often, there are two cities or towns with the same name in one state. For example, in Pennsylvania there is more than one town with the name "Newtown". If you do not combine the town with a postal code or a county, you may not get the result you want.
You can manually add values; however, you probably want to import them from the external distance engine that you are using. The county qualifier needs to correspond with the distance engine that you are using. -
deliveryGroupName: string
Another way of grouping the locations.
-
description: string
Free text to capture different location types or classifications like customer, vendor site, or stores etc.
-
destArbLevelOfServiceGid: string
Preferred destination arbitrary level of service when selecting the destination arbitrary for a location during bulkplan.
-
documents:
documents
-
domainName: string
Database domain where this data is stored.
-
dropoffRoutingSequenceGid: string
Pickup Routing Sequence and Dropoff Routing Sequence control the routing sequence; how the system plans the sequence of shipment stops that are built from an order.
-
enforceTimeWindowAppoint: boolean
Whether or not to enforce the pick up or delivery time window during appointment schedule process."USE_APPOINTMENT_PRIORITY" takes precedence of "ENFORCE_TIME_WINDOW_APPOINT".
-
equipmentGroupProfileGid: string
The GID for the equipment group profile. An Equipment Group Profile is used to categorize Equipment groups by some common attribute or grouping scheme. For example, you can create a Group Profile called Dry Vans that include the 28 FT Dry Van and 24 FT Dry Van (and others if you like) Equipment Groups.
An Equipment Group Profile consists of an ID and a Profile Name and a collection of specific Equipment Groups that you associate with the profile. Oracle Transportation Management can use the Profile in planning to limit the Equipment Groups that can be used for shipment planning. When Oracle Transportation Management bundles orders and builds shipments, it checks that there is an intersection between the equipment group values identified on the order bases.
Example: Equipment Group Rule -
erpcGid: string
The Eastern Region Presidents Commission Code for this Location.
-
eruGrouping: string
To indicate orders going to this location will be grouped together for ERU grouping.
-
excludeFromRouteExecution: boolean
When = Y, this location is excluded from any Route Instance Legs.
-
hasMultipleMatches: string
Indicates if we have multiple matches for the location after address validation.
-
insertDate:
insertDate
Read Only:
true
insert date -
isActive: boolean
Used to activate or deactivate location. When the value is 'N', it can restrain user from planning order to or from the inactive location; from tendering shipment with inactive location.
-
isAddressValid: string
Indicates if the address is considered valid (by checking against the POSTAL_CODE_VALIDATE table).
-
isFixedAddress: boolean
Y/N if address is only allowed to be edited by the UI.
-
isLtlSplitable: boolean
The LTL Splittable check box indicates whether orders from or to this location are permitted to apply the LTL splitting logic. If the check box is not selected, the LTL splitting is disallowed for orders associated with this location.
-
isMakeApptBeforePlan: boolean
A true or false flag to identify if an appointment is required at the location for (example) for pickup, delivery etc.
-
isShipperKnown: boolean
The Known Shipper check box indicates if a shipper is known or unknown. Shippers are considered unknown if they have not filed the appropriate paperwork and gained permission to ship goods on passenger flights. Goods transported by these shippers must be placed on cargo flights. Select Known Shipper if orders coming from this location can be qualified as known, and therefore transported on passenger flights.
-
isTemplate: boolean
Identifies if the location record is a template or represents a physical location.
-
isTemporary: boolean
A flag to identify if the location is created temporarily for a certain shipment or order. This location will not be used for other shipments or processes.
-
isWmsFacility: boolean
Indicates if the location is a warehouse management system facility.
-
lat: number
(double)
The latitude for the location.
-
links: array
links
Read Only:
true
-
loadUnloadPoints:
loadUnloadPoints
-
locationGid: string
The GID for the location.
-
locationGroupGid: string
The GID for the location group for the location.
-
locationName: string
The name of the location.
-
locationXid: string
The XID for the location.
-
lon: number
(double)
The longitude of the location.
-
numOfRowsInYard: number
(int32)
The total number of rows in the yard of the location.
-
numOfSlotsPerRowInYard: number
(int32)
The number of slots per row in the yard of the location.
-
operationalLocations:
operationalLocations
-
overallQuality: string
Indicates the overall quality of the location.
-
pickupRoutingSequenceGid: string
Pickup Routing Sequence and Dropoff Routing Sequence control the routing sequence; how the system plans the sequence of shipment stops that are built from an order.
-
postalCode: string
The postal code for the location.
-
postalSplcGid: string
The Postal Standard Point Location Code for this Location.
-
primaryAddressLineSeq: number
(int64)
The Address Line Number or primary address line sequence number designates which line of the address text box contains the actual street address so when using the External Distance Engine, the correct street address is used.
For example, if you had this address in the text box, the line number would be 2.
Care of Someone
1234 Main St. -
province: string
The province (or U.S. state) for the location.
-
provinceCode: string
The abbreviation for the province (or U.S. state) for the location.
-
railJunctionCodeGid: string
The Rail Junction Code for this Location.
-
railSplcGid: string
The Rail Standard Point Location Code for this Location.
-
railStationCodeGid: string
The Rail Station Code for this Location.
-
rateClassificationGid: string
The GID for the rate classification. Examples include: COMMERCIAL and RESIDENTIAL.
-
refnums:
refnums
-
regionGid: string
The GID for the region.
-
remarks:
remarks
-
resourceGroups:
resourceGroups
-
resourceTypes:
resourceTypes
-
roleProfiles:
roleProfiles
-
scheduleInfeasibleAppoint: boolean
Whether or not to schedule appointment if the appointment time available is out of pick up or delivery time window.
-
scheduleLowPriorityAppoint: boolean
Whether or not to schedule appointment for low priority appointment that has been bumped off.
-
servingServprovProfileGid: string
The Serving Service Provider Profile for this Location.
-
servprovPrefs:
servprovPrefs
-
servprovProfileGid: string
The GID for the service provider for the location.
-
shuttleLotEqGrpProfileGid: string
This specifies the equipment group profile for the shuttle or parking lot of a location. When a shipment uses one of the equipment groups in this equipment group profile, the location cannot be directly accessed for pickup/delivery and is accessed only through the shuttle lot. In this case, additional shuttle lot activity time is computed and added to the activity time at the location.
-
slotTimeInterval:
slotTimeInterval
The smallest appointment slot interval for the location.
-
sourcingGroupName: string
Another way of grouping the locations.
-
specialServices:
specialServices
-
srcArbLevelOfServiceGid: string
Preferred source arbitrary level of service when selecting the source arbitrary for a location during bulkplan.
-
standingApptCutoffWindow: number
(int32)
The cutoff window by which unbooked standing appointments to be released.
-
statuses:
statuses
-
substitutes:
substitutes
-
timeZoneGid: string
The GID for the time zone of the location. Examples of time zones include America/Curacao and Europe/Monaco.
-
updateDate:
updateDate
Read Only:
true
update date -
useAppointmentPriority: boolean
Whether or not to consider appointment priority.
-
useSingleServprovRule: string
This specifies the use of single service provider rule at a location. The options are: null - rule is not used, P - for pickups only, D - for deliveries only, B - for both pickups and deliveries.
-
yardRowLabels: string
Comma separated list of labels for rows in a yard.
-
yardSlotLabels: string
Comma separated list of labels for slots in a yard.
-
zone1: string
The zone where the location fits in.
-
zone2: string
The zone where the location fits in.
-
zone3: string
The zone where the location fits in.
-
zone4: string
The zone where the location fits in.
Nested Schema : accessorials
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : addresses
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : addressUpdateDate
Date on which the details -CITY,COUNTRY,PROVINCE,PROVINCE_CODE,POSTAL_CODE are modified.RPLS checks this date before it starts screening.
Match All
Show Source
Nested Schema : appointDisplay
The duration of appointment display time period.
Match All
Show Source
Nested Schema : apptAfterCutoff
Service provider appointment duration after cutoff.
Match All
Show Source
Nested Schema : apptBeforeCutoff
Service provider appointment duration before cutoff.
Match All
Show Source
Nested Schema : attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : capacityGroups
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : contacts
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : corporations
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : documents
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : loadUnloadPoints
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : operationalLocations
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : refnums
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : remarks
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : resourceGroups
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : resourceTypes
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : roleProfiles
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : servprovPrefs
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : slotTimeInterval
The smallest appointment slot interval for the location.
Match All
Show Source
Nested Schema : specialServices
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : statuses
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : substitutes
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : locations.accessorials
Type:
Show Source
object
-
accessorialCodeGid: string
The GID for the accessorial code for the location.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
Nested Schema : locations.addresses
Type:
Show Source
object
-
addressLine: string
Address line data.
-
domainName: string
Database domain where this data is stored.
-
lineSequence: number
(int64)
The line sequence number for the address line.
-
links: array
links
Read Only:
true
Nested Schema : amountType
Type:
Show Source
object
-
unit: string
Unit of measure
-
value: number
Numeric value that specifies an amount
Nested Schema : locations.capacityGroups
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
effectiveDate:
effectiveDate
Effective date for the location capacity group assigned to the location.
-
expirationDate:
expirationDate
Expiration date for the location capacity group assigned to the location.
-
links: array
links
Read Only:
true
-
locCapacityGroupGid: string
The GID for the location capacity group for this location.
Nested Schema : effectiveDate
Effective date for the location capacity group assigned to the location.
Match All
Show Source
Nested Schema : expirationDate
Expiration date for the location capacity group assigned to the location.
Match All
Show Source
Nested Schema : locations.contacts
Type:
Show Source
object
-
alternateName: string
If the contact goes by an alternate name the alternate name should be entered here. For example, real name Laurence Tureaud, alternate name Mr. T.
Note: GTM bases restricted party screening on the party's company name. If the contact has an alternate name, the contact's alternate name is screened instead. -
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)
-
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 as Date
-
attributeDate12:
attributeDate12
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
-
attributeDate13:
attributeDate13
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
-
attributeDate14:
attributeDate14
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
-
attributeDate15:
attributeDate15
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
-
attributeDate16:
attributeDate16
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
-
attributeDate17:
attributeDate17
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
-
attributeDate18:
attributeDate18
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
-
attributeDate19:
attributeDate19
Attribute fields (flexfields) allow you to add additional information about an object. Data type as 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 as 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 as Number
-
attributeNumber12: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Number
-
attributeNumber13: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Number
-
attributeNumber14: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Number
-
attributeNumber15: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Number
-
attributeNumber16: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Number
-
attributeNumber17: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Number
-
attributeNumber18: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Number
-
attributeNumber19: number
(double)
Attribute fields (flexfields) allow you to add additional information about an object. Data type as 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 as 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
-
cellPhone: string
Contains the mobile/cell phone number for the location's contact person. Do not include special characters such as "+" and "-".
-
comMethods:
comMethods
-
companyName: string
Company name for this party.
-
consolidatedNotifyOnly: boolean
Select the Consolidated Notify Only check box if the only notification sent is to be consolidated and the communication method is email, fax or message center.
-
consolidationProfileGid: string
The GID for the consolidation profile. You would enter a Consolidation Profile if you are using consolidated notification. If a consolidation profile is entered, it will apply to all contact notifications that do not have a consolidated notification profile.
-
contactGid: string
The GID for the contact for the location.
-
contactPreferences:
contactPreferences
-
contactType: string
Defines whether a contact is a person or group.
-
contactXid: string
The XID for the contact for the location.
-
description: string
Enter any additional descriptive information for this party/contact.
-
domainName: string
Database domain where this data is stored.
-
ecmUser: string
If the contact is acting as a reviewer or subscriber to documents within Oracle ECM, the ECM user mapping to the contact.
-
emailAddress: string
The email address of the contact person for the location.
-
externalSystemGid: string
The external system GID.
-
fax: string
The facsimile number for the contact person for the location.
-
firstName: string
The given name of the contact person for the location.
-
fromAddrContactGid: string
The GID that contains a contact's 'From-Address' details. Valid only if IS_FROM_ADDRESS is 'N'.
-
glUserGid: string
The GL user GID.
-
groupSavedQueryGid: string
Valid only if the contact_type = 'GROUP'. The saved_query could then define which individual contacts belong to the contact_group.
-
indicator: string
Indicators are icons that can be assigned to business objects that can be displayed in search Results pages and other lists to indicate the condition or state of a business object. You can use indicators to mark the history, status or any other condition of a business object.
-
ippPrinterGid: string
Used to assign an IPP printer as a recipient of notifications, particularly of document or report events.
-
isBroadcast: boolean
Valid only if the contact_type = 'GROUP'. This is a Boolean flag which controls whether GC3 creates a single notification message and broadcasts (i.e. cc) it to each group member or whether GC3 creates a message customized for each member.
-
isEmailVirusProtected: boolean
If Y, document attachments may be sent to the contact without virus checking.
-
isFromAddress: boolean
Indicates if a contact is a 'From-Address' contact.
-
isNotificationOn: boolean
No notification will be sent to the contact if this field is set to false ('N').
-
isPrimaryContact: boolean
Indicates if this contact person at the location is the primary contact person (if so Y) or not (if not N). This attribute is marked as Create-Only.
-
jobTitle: string
The title for the contact person at the location.
-
languageSpoken: string
The language the contact person at the location speaks.
-
lastName: string
The surname of the contact person for the location.
-
links: array
links
Read Only:
true
-
locationGid: string
The GID for the location.
-
messageProfileGid: string
The GID for the message profile. A message profile provides a grouping of stylesheet profiles for inbound message processing. It represents the different formats a device can send to the system. A message profile is assigned to a contact. If the message type for an incoming message, the system attempts to apply the stylesheet profiles listed in the message profile. They are applied to the incoming message in the order of the Attempt Sequence of the message profile.
-
middleName: string
The middle name of the contact.
-
nameAddressUpdateDate:
nameAddressUpdateDate
Date on which the details - FIRST_NAME,LAST_NAME,COMPANY_NAME,ALTERNATE_NAME,LOCATION_GID are modified.RPLS checks this date before it starts screening.
-
notes: string
Text describing something regarding the contact person for the location or the location itself.
-
phone1: string
The primary telephone number for the location's contact person.
-
phone2: string
The secondary telephone number for the location's contact person.
-
recipientDomainName: string
The domain of a message recipient.
-
routeThroughLocation: boolean
Indicates if the notification should use location.
-
sendAsMessage: boolean
Indicates that messages should be sent to message center.
-
telex: string
The telephone number for telex communications for the location's contact person.
-
timeZoneGid: string
Time zone for the contact.
-
userDefined1IconGid: string
The GID for the user defined image/icon. Up to five User-Defined Image fields can be configured to appear on the Search and Results page that let you query and review the images that are assigned to a business object. Images can be assigned to business objects to visually emphasize certain characteristics such as shipments containing hazardous material, orders for hot commodities, or shipments with over dimensional freight.
-
userDefined2IconGid: string
The GID for the user defined image/icon. Up to five User-Defined Image fields can be configured to appear on the Search and Results page that let you query and review the images that are assigned to a business object. Images can be assigned to business objects to visually emphasize certain characteristics such as shipments containing hazardous material, orders for hot commodities, or shipments with over dimensional freight.
-
userDefined3IconGid: string
The GID for the user defined image/icon. Up to five User-Defined Image fields can be configured to appear on the Search and Results page that let you query and review the images that are assigned to a business object. Images can be assigned to business objects to visually emphasize certain characteristics such as shipments containing hazardous material, orders for hot commodities, or shipments with over dimensional freight.
-
userDefined4IconGid: string
The GID for the user defined image/icon. Up to five User-Defined Image fields can be configured to appear on the Search and Results page that let you query and review the images that are assigned to a business object. Images can be assigned to business objects to visually emphasize certain characteristics such as shipments containing hazardous material, orders for hot commodities, or shipments with over dimensional freight.
-
userDefined5IconGid: string
The GID for the user defined image/icon. Up to five User-Defined Image fields can be configured to appear on the Search and Results page that let you query and review the images that are assigned to a business object. Images can be assigned to business objects to visually emphasize certain characteristics such as shipments containing hazardous material, orders for hot commodities, or shipments with over dimensional freight.
Nested Schema : attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate11
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate12
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate13
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate14
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate15
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate16
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate17
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate18
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate19
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate20
Attribute fields (flexfields) allow you to add additional information about an object. Data type as Date
Match All
Show Source
Nested Schema : attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : comMethods
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : contactPreferences
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : nameAddressUpdateDate
Date on which the details - FIRST_NAME,LAST_NAME,COMPANY_NAME,ALTERNATE_NAME,LOCATION_GID are modified.RPLS checks this date before it starts screening.
Match All
Show Source
Nested Schema : locations.contacts.comMethods
Type:
Show Source
object
-
calendarGid: string
The calendar GID.
-
comMethodGid: string
The communication method GID.
-
comMethodRank: number
(int32)
A numeric value to rank the communication methods at the location. For example a location may have E-Mail, Fax and Phone as preferred communication methods in that rank.
-
domainName: string
Database domain where this data is stored.
-
expectedResponseTime:
expectedResponseTime
This value is used when the location represents the service provider. It specifies the response time for a shipment tender.
-
links: array
links
Read Only:
true
Nested Schema : expectedResponseTime
This value is used when the location represents the service provider. It specifies the response time for a shipment tender.
Match All
Show Source
Nested Schema : locations.contacts.contactPreferences
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
preferenceGid: string
The preference GID.
-
value: string
The value or Rank for the communication method. The value (Rank) prioritizes the saved communication methods. The highest priority is 1. If the rank between two companies does not match, the method preferred by the source company (shipper) is used.
Nested Schema : locations.corporations
Type:
Show Source
object
-
corporationGid: string
CORPORATION_GID contains the unique identifier for the location's corporation.
-
domainName: string
No description.
-
links: array
links
Read Only:
true
Nested Schema : locations.documents
Type:
Show Source
object
-
contentManagementSystemGid: string
No description.
-
documentCmsId: string
A GUID to associate the document with content stored on its remote CMS. Valid when document_type=CMS.
-
documentDefGid: string
No description.
-
documentFilename: string
No description.
-
documentGid: string
No description.
-
documentMimeType: string
No description.
-
documentTrackingNum: string
No description.
-
documentType: string
No description.
-
documentUrl: string
No description.
-
documentXid: string
No description.
-
domainName: string
No description.
-
effectiveDate:
effectiveDate
represents effective date for a document
-
expirationDate:
expirationDate
Represents expiration date for a document.
-
generatedAt:
generatedAt
If preparation, date/time content was last generated
-
links: array
links
Read Only:
true
-
ownerDataQueryTypeGid: string
No description.
- relatedDocumentGid: string
-
reportGid: string
The report associated with the document attachment, if content was generated by the report subsystem.
-
uploadedAt:
uploadedAt
If attachment, date/time content was last updated
-
usedAs: string
Represents the classification of a document.(C/I/L/T)
-
userDefined1IconGid: string
No description.
-
userDefined2IconGid: string
No description.
-
userDefined3IconGid: string
No description.
-
userDefined4IconGid: string
No description.
-
userDefined5IconGid: string
No description.
Nested Schema : generatedAt
If preparation, date/time content was last generated
Match All
Show Source
Nested Schema : locations.loadUnloadPoints
Type:
Show Source
object
-
description: string
Description for the load/unload point.
-
domainName: string
Database domain where this data is stored.
-
equipmentGroupProfileGid: string
Equipment group profile for the load/unload point; overrides any at the location.
-
isLoad: boolean
Indicates if this dock or point make be used for loading.
-
isUnload: boolean
Indicates if this dock or point make be used for loading.
-
links: array
links
Read Only:
true
-
loadSequence: number
(int32)
Indicates where dock should be in a load sequence.
-
loadUnloadPoint: string
Load/unload point such as a loading dock.
-
unloadSequence: number
(int32)
Indicates where dock should be in an unload sequence.
Nested Schema : locations.operationalLocations
Type:
Show Source
object
-
details:
details
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
operationalLocationGid: string
Sub location belonging to a main location. Sub location may only belong to one location.
Nested Schema : details
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : locations.operationalLocations.details
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
exclusionRegionGid: string
If set, this operational location is not applicable when the opposite endpoint of the shipment is within the region.
-
inboundOutboundType: string
Indicates whether this operational location for the mapping of the service provider and location profile is used for importing (I), exporting (E), or both (B).
-
inclusionRegionGid: string
If set, this operational location is applicable only when the opposite endpoint of the shipment is within the region.
-
links: array
links
Read Only:
true
-
primaryLegLocProfileGid: string
The location on the main leg which will help indicate which operational location applies; usually Port of Exit or Port of Discharge.
-
primaryLegServprovGid: string
The service provider of the main leg which will help indicate which operational location applies.
-
seqNo: number
(int64)
Sequence to allow multiple data records for the same operational location.
Nested Schema : locations.refnums
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
locationRefnumQualGid: string
The GID for the location reference number qualifier.
-
locationRefnumValue: string
The value associated with the location reference number qualifier.
Nested Schema : locations.remarks
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
remarkQualGid: string
The GID for the remark qualifier for the location.
-
remarkSequence: number
(int64)
The sequence number for the remark for this location.
-
remarkText: string
The text of the remark for the location.
Nested Schema : locations.resourceGroups
Type:
Show Source
object
-
calendarGid: string
The calendar GID that will be applied to the location of the location resource group.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
locationResourceGroupGid: string
The GID for the location resource group. Option here is to link a calendar and preference level for a location resource group.
-
preferenceLevel: number
(int32)
Used to get preference level of location resource group for Appointment scheduling
Nested Schema : locations.resourceTypes
Type:
Show Source
object
-
autoScheduleAppointment: boolean
Indicate whether appointment should be automatically scheduled for the resource type.
-
calendarGid: string
The calendar GID that applies to the location resource type.
-
constraintAppointment: boolean
Whether the location resource type constraints scheduling appointments.
-
description: string
The description of the location resource type.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
resources:
resources
-
resourceTypeGid: string
Resource Type GID for the location.
Nested Schema : resources
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : locations.resourceTypes.resources
Type:
Show Source
object
-
appointmentActivityType: string
Specify if the trailer that is scheduled for the appointment is attached to the truck by selecting Live from the Appointment Activity Type field. If the trailer is being dropped off, select Drop.
-
apptRuleSets:
apptRuleSets
-
calendarGid: string
The calendar GID that will be applied to the resource.
-
contactProfileGid: string
The contact profile GID.
-
description: string
The description of the resource.
-
domainName: string
Database domain where this data is stored.
-
equipmentGroupProfileGid: string
The equipment group profile ID that associates to the location resource.
-
flexCommodityCheckOption: string
Flex Commodify check option, such as CHECK ALL, CHECK BY LARGEST WEIGHT and CHECK BY LARGEST VOLUME.
-
flexCommodityProfileGid: string
The flex commodity profile ID that associates to the location resource.
-
links: array
links
Read Only:
true
-
locationResourceGid: string
The location resource GID.
-
locationResourceGroupGid: string
The XID for the location resource group. A location resource group allows you to group location resources such as dock door1, dock door2, and dock door3 into a location resource group such as frozen goods into a group called frozen. Similarly, you can group location resources into a location resource group such as dry goods into a group called dry. While you create a location resource group, you can also assign locations. For each location, you can assign multiple appointment rule sets. These rules sets are applicable to all the resources which are under the location resource group. A location resource group enables you to avoid duplicate configurations for each resource.
-
locationResourceName: string
The name of the resource.
-
locationResourceXid: string
The XID of the location resource.
-
modeProfileGid: string
The mode profile ID that associates to the location resource.
-
preferenceLevel: number
(int32)
Gets the preference level of resource for Appointment scheduling
-
servprovProfileGid: string
The service provider profile ID that associates to the location resource.
Nested Schema : apptRuleSets
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : locations.resourceTypes.resources.apptRuleSets
Type:
Show Source
object
-
apptRuleSetGid: string
The GID for the appointment rule set.
-
domainName: string
Database domain where this data is stored.
-
flexFields:
flexFields
-
links: array
links
Read Only:
true
-
refnums:
refnums
Nested Schema : flexFields
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : refnums
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : locations.resourceTypes.resources.apptRuleSets.flexFields
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
flexFieldName: string
Flex field name
-
flexFieldValue: string
Flex field value.
-
isCompatible: boolean
If the flex field details on the shipment contain all the flex field details defined on the appointment rule set, when the Compatible check box is selected for each appointment rule set, then the shipment is compatible.
If you do not specify any shipment flex fields on your appointment rule set, the shipment is considered as compatible. -
links: array
links
Read Only:
true
Nested Schema : locations.resourceTypes.resources.apptRuleSets.refnums
Type:
Show Source
object
-
apptRefnumQualGid: string
The appointment reference number qualifier. The qualifier related to shipment is used.
-
apptRefnumValue: string
The appointment reference number value.
-
domainName: string
Database domain where this data is stored.
-
isCompatible: boolean
If the reference number details on the shipment contain all the reference number details defined on the appointment rule set, when the Compatible check box is selected for each appointment rule set, then the shipment is compatible.
If you do not specify any shipment reference numbers on your appointment rule set, the shipment is considered as compatible.
For example, the following table contains reference number details on the shipment and appointment rule sets along with the status of compatible check box of individual rule sets.
Shipment Reference Number Qualifier and Value
Appointment Rule Set Reference Number Qualifier and Value
Q1 V1 Q1 V1, selected
Q2 V2 Q2 V2, selected
Q3 V3
Q4 V4
In this example, the shipment is compatible as the reference numbers on the shipment contain reference numbers (Q1 V1), (Q2 V2) that are defined in the appointment rule set with the compatible check box as selected.
To define shipment reference numbers constraints, enter or select the following fields, which are optional:
Reference Number Qualifier ID.
Reference Number. -
links: array
links
Read Only:
true
Nested Schema : locations.roleProfiles
Type:
Show Source
object
-
activityTimeDefs:
activityTimeDefs
-
calendarGid: string
The GID for the calendar used for the location role profile.
-
calendars:
calendars
-
createPoolHandlingShipment: boolean
Creates pool handling shipments.
-
createXdockHandlingShipment: boolean
Using the Create Crossdock Handling Shipment field creates handling shipments as part of the cross-dock building process. Clear the check box to bulk plan cross-docks without handling shipments.
Fixed Handling Time: Same as above.
The Variable Handling Time and the Variable Handling Weight: Same as above.
Max Freight Idle Time: Same as above. -
domainName: string
Database domain where this data is stored.
-
fixedHandlingTime:
fixedHandlingTime
Fixed amount of time. No matter the size of the shipment required for handling.
-
handlings:
handlings
-
isAllowMixedFreight: boolean
Check box option used to indicate if mixed freight (e.g., a rainbow pallet) will be allowed, is so then select the Allow Mixed Freight option.
-
links: array
links
Read Only:
true
-
locationRoleGid: string
The GID for the location role.
-
maxFreightIdleTime:
maxFreightIdleTime
Maximum time freight can sit idle at the cross-dock.
-
pctActivityAfterLocClose: number
(double)
This value will be divided by 100 in the application to be used as a percentage. The valid value for this column is >= 0 and <= 100 100. when null, treat as for location role shipping receiving< div> =>
-
pctActivityBeforeLocOpen: number
(double)
This value will be divided by 100 in the application to be used as a percentage. The valid value for this column is >= 0 and <= 0 100. when it is null, treat as for location role shipping receiving< div> =>
-
thuCapacities:
thuCapacities
-
thuProfileGid: string
The GID for the transport profile.
To handle mixed items you need to include the THU profile here and on the order release line. You also need to attach appropriate packaging reference unit (PRU) to the THU to indicate that it is a mixed THU that takes only mixed items but does not take SAME or LIKE items. See Order Release Line help for details. -
varHandlingTime:
varHandlingTime
Amount of time required to handle the amount of weight defined by the variable handling weight value.
-
varHandlingWeight:
varHandlingWeight
Variable handling time weight defines rate of handling defined by weight.
-
varHndcstVol:
varHndcstVol
The planning handling cost volume at this location.
-
varHndcstVolCost:
varHndcstVolCost
The variable handling cost per volume at this location.
-
varHndcstWgt:
varHndcstWgt
The planning handling cost weight at this location.
-
varHndcstWgtCost:
varHndcstWgtCost
Variable Handling Cost Per Weight at this location.
-
xDockIsInboundBias: boolean
The inbound bias flag for the cross-dock should be selected if you want to emphasize optimization inbound to the cross-dock. If you clear the check box, then the system will optimize outbound from the cross-dock instead.
Nested Schema : activityTimeDefs
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : calendars
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : fixedHandlingTime
Fixed amount of time. No matter the size of the shipment required for handling.
Match All
Show Source
Nested Schema : handlings
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : maxFreightIdleTime
Maximum time freight can sit idle at the cross-dock.
Match All
Show Source
Nested Schema : thuCapacities
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : varHandlingTime
Amount of time required to handle the amount of weight defined by the variable handling weight value.
Match All
Show Source
Nested Schema : varHandlingWeight
Variable handling time weight defines rate of handling defined by weight.
Match All
Show Source
Nested Schema : varHndcstVol
The planning handling cost volume at this location.
Match All
Show Source
Nested Schema : varHndcstVolCost
The variable handling cost per volume at this location.
Match All
Show Source
Nested Schema : varHndcstWgt
The planning handling cost weight at this location.
Match All
Show Source
Nested Schema : varHndcstWgtCost
Variable Handling Cost Per Weight at this location.
Match All
Show Source
Nested Schema : locations.roleProfiles.activityTimeDefs
Type:
Show Source
object
-
activityTimeDefGid: string
The GID for the activity time definition for this location and location role combination.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
Nested Schema : locations.roleProfiles.calendars
Type:
Show Source
object
-
calendarGid: string
The GID for the calendar entry associated with each row of the location role profile calendar entry.
-
domainName: string
Database domain where this data is stored.
-
flexCommodityProfileGid: string
The GID for the flex commodity profile. Used to specify when commodity specific activities can occur at the location.
-
inboundLocationProfileGid: string
The GID for the inbound location profile. Used to specify when shipments from locations in the inbound location profile can be received at the location.
-
links: array
links
Read Only:
true
-
locationRoleProfCalSeq: number
(int32)
The internal sequence number for the location role profile calendar combination.
-
modeProfileGid: string
The GID for the mode profile. Used to specify when shipments of a certain mode can be shipped or received from the location.
-
outboundLocationProfileGid: string
The GID for the outbound location profile. Used to specify when shipments to locations in the outbound location profile can be shipped to.
Nested Schema : locations.roleProfiles.handlings
Type:
Show Source
object
-
destRegionGid: string
The GID for the destination region. Used to match an order to an entry.
-
domainName: string
Database domain where this data is stored.
-
fixedHandlingTime:
fixedHandlingTime
Amount fixed handling time to add. Days, hours, and minutes.
-
links: array
links
Read Only:
true
-
locationRoleProfHandSeq: number
(int32)
Internal key for the 1 to n location role profile handling time entries.
-
sourceRegionGid: string
The GID for the source region. Used to match an order to an entry.
Nested Schema : fixedHandlingTime
Amount fixed handling time to add. Days, hours, and minutes.
Match All
Show Source
Nested Schema : locations.roleProfiles.thuCapacities
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
isFullyLayered: boolean
You should select the Fully Layered check box if this location only takes a full-layered ship unit based on the TiHi definition. A full-layered ship unit has no partial layers. For example, you are packing 23 boxes into a given PALLET (THU) and the TiHi specified for the pallet is 6 x 4. Normally, you would pack them onto one pallet with 3 full layers and one partial layer of 5 boxes. However, if you allow only full layers, you would pack only 3 full layers and leave the remaining 5 to pack with other items.
Building a full layered ship unit, when required, would only be honored when a ship unit is building from a single order release line using the AUTO CALC ship unit building method. It will not be honored when ship unit is built from multiple order release lines even when those lines have the same packaged item. -
links: array
links
Read Only:
true
-
maxHeight:
maxHeight
Value for the maximum height of the transportation handling unit. Note: The Max Width field (as well as the Max Length and Max Height fields) are different from the Max Weight and Max Volume fields that are used to constrain the ship unit. The Max Width (and Length and Height) are used to check against each packaging unit or packaged item, not the ship unit.
-
maxLength:
maxLength
Value for the maximum length of the transportation handling unit. Note: The Max Width field (as well as the Max Length and Max Height fields) are different from the Max Weight and Max Volume fields that are used to constrain the ship unit. The Max Width (and Length and Height) are used to check against each packaging unit or packaged item, not the ship unit.
-
maxVolume:
maxVolume
Value for the maximum volume of the transportation handling unit.
-
maxWeight:
maxWeight
Value for the maximum weight of the transportation handling unit.
-
maxWidth:
maxWidth
Value for the maximum width of the transportation handling unit. Note: The Max Width field (as well as the Max Length and Max Height fields) are different from the Max Weight and Max Volume fields that are used to constrain the ship unit. The Max Width (and Length and Height) are used to check against each packaging unit or packaged item, not the ship unit.
-
pruCapacities:
pruCapacities
-
transportHandlingUnitGid: string
The GID for the transport handling unit.
Nested Schema : maxHeight
Value for the maximum height of the transportation handling unit. Note: The Max Width field (as well as the Max Length and Max Height fields) are different from the Max Weight and Max Volume fields that are used to constrain the ship unit. The Max Width (and Length and Height) are used to check against each packaging unit or packaged item, not the ship unit.
Match All
Show Source
Nested Schema : maxLength
Value for the maximum length of the transportation handling unit. Note: The Max Width field (as well as the Max Length and Max Height fields) are different from the Max Weight and Max Volume fields that are used to constrain the ship unit. The Max Width (and Length and Height) are used to check against each packaging unit or packaged item, not the ship unit.
Match All
Show Source
Nested Schema : maxVolume
Value for the maximum volume of the transportation handling unit.
Match All
Show Source
Nested Schema : maxWeight
Value for the maximum weight of the transportation handling unit.
Match All
Show Source
Nested Schema : maxWidth
Value for the maximum width of the transportation handling unit. Note: The Max Width field (as well as the Max Length and Max Height fields) are different from the Max Weight and Max Volume fields that are used to constrain the ship unit. The Max Width (and Length and Height) are used to check against each packaging unit or packaged item, not the ship unit.
Match All
Show Source
Nested Schema : pruCapacities
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : locations.roleProfiles.thuCapacities.pruCapacities
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
limitPruCount: number
(double)
Enter a Total Packaging Reference Unit Count. This total represents by volume the amount of packaging reference units that can fill the space. It does not take into account the actual shape and dimensions of the packaging reference unit, but rather how many packaging reference units can fit in the space based on the volume of each packaging reference unit.
-
links: array
links
Read Only:
true
-
packagingReferenceUnitGid: string
The GID for the package unit reference unit.
-
totalPruCount: number
(double)
Enter a Limit Packaging Reference Unit Count. This represents the number of package references units that can fill the usable space in the location. The area of a location may suggest more packaging reference units can fit, but due to the actual dimensions of the packaged reference units, a lower limit may be reached.
Nested Schema : locations.servprovPrefs
Type:
Show Source
object
-
details:
details
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
locationServprovPrefGid: string
The unique identifier of location service provider preference.
-
locationServprovPrefXid: string
The XID of location service provider preference.
-
maxSlotsPerDay: number
(int32)
The maximum number of slots per day.
-
serviceLocationGid: string
Unique key constraint will be created on (location_gid, servprov_gid, service_location_gid) in CU5.
-
servprovGid: string
The Service Provider GID.
Nested Schema : details
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : locations.servprovPrefs.details
Type:
Show Source
object
-
begin: number
(int32)
The begin time.
-
dayOfWeek: number
(int32)
The day of week.
-
domainName: string
Database domain where this data is stored.
-
duration: number
(int32)
The duration of the time window.
-
isStanding: boolean
Indicates if the defined preference is for standing appointment.
-
links: array
links
Read Only:
true
-
locationResourceGid: string
Indicates the resource that preference defined on.
-
locationServprovPrefDSeq: number
(int64)
Sequence with in a particular location service provider preference GID.
-
maxSlot: number
(int32)
The maximum number of slots during this time.
-
preferenceLevel: number
(int32)
The preference level.
Nested Schema : locations.specialServices
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
specialServiceCodeGid: string
The GID for the special service code for the location.
Nested Schema : locations.statuses
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
statusTypeGid: string
Status type for the location status.
-
statusValueGid: string
Status value for the status type.
Nested Schema : locations.substitutes
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
substituteLocationGid: string
The GID for the substitute location. Use this field to define ONE alternate location from which an order is picked up for transportation purposes. For example, for any ship unit or line item on an order, you can record a Source Location and Destination Location that would typically be used to plan a shipment. However, if you record a Substitute Location for any location that is used as a Source Location on an order, Oracle Transportation Management automatically uses the Substitute Location and populates it on the order release. Oracle Transportation Management also uses the Substitute Location on the order release as the source location when building a shipment; however you can override this location on the order base and order release.
Nested Schema : orderReleases.documents
Type:
Show Source
object
-
contentManagementSystemGid: string
No description.
-
documentCmsId: string
A GUID to associate the document with content stored on its remote CMS. Valid when document_type=CMS.
-
documentDefGid: string
No description.
-
documentFilename: string
No description.
-
documentGid: string
No description.
-
documentMimeType: string
No description.
-
documentTrackingNum: string
No description.
-
documentType: string
No description.
-
documentUrl: string
No description.
-
documentXid: string
No description.
-
domainName: string
No description.
-
effectiveDate:
effectiveDate
represents effective date for a document
-
expirationDate:
expirationDate
Represents expiration date for a document.
-
generatedAt:
generatedAt
If preparation, date/time content was last generated
-
links: array
links
Read Only:
true
-
ownerDataQueryTypeGid: string
No description.
- relatedDocumentGid: string
-
reportGid: string
The report associated with the document attachment, if content was generated by the report subsystem.
-
uploadedAt:
uploadedAt
If attachment, date/time content was last updated
-
usedAs: string
Represents the classification of a document.(C/I/L/T)
-
userDefined1IconGid: string
No description.
-
userDefined2IconGid: string
No description.
-
userDefined3IconGid: string
No description.
-
userDefined4IconGid: string
No description.
-
userDefined5IconGid: string
No description.
Nested Schema : generatedAt
If preparation, date/time content was last generated
Match All
Show Source
Nested Schema : orderReleases.equipments
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
equipmentGid: string
The actual equipment GID if the equipment is managed in the database.
-
equipmentGroupGid: string
The seal sequence to allow for multiple seals to be defined.
-
equipmentInitial: string
The equipment initial as an identifier specified for this order release equipment.
-
equipmentInitialNumber: string
The equipment initial and number as an identifier specified for this order release equipment.
-
equipmentNumber: string
The equipment number as an identifier specified for this order release equipment.
-
equipmentTypeGid: string
The equipment seal number for the order release ordered equipment.
-
links: array
links
Read Only:
true
-
orEquipmentSeq: number
(int32)
The equipment sequence to allow for multiple equipment request to be specified on the order release.
-
seals:
seals
Nested Schema : seals
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : orderReleases.equipments.seals
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
sealNumber: string
The equipment seal number for the order release ordered equipment.
-
sealSequence: number
(int32)
The seal sequence to allow for multiple seals to be defined.
Nested Schema : orderReleases.involvedParties
Type:
Show Source
object
-
comMethodGid: string
The communication method for the involved party listed on the order release.
-
domainName: string
Database domain where this data is stored.
-
involvedPartyContactGid: string
The involved party contact for the qualifier listed on the order release.
-
involvedPartyQualGid: string
The involved party qualifier identifier.
-
links: array
links
Read Only:
true
-
overrideAddresses:
overrideAddresses
-
overrideCity: string
The location city that is to be used for this involved party on an order release in place of (overridden) the one on the location table.
-
overrideCountryCode3Gid: string
The location country code that is to be used for this involved party on an order release in place of (overridden) the one on the location table.
-
overrideLocationName: string
The location name that is to be used for this involved party on an order release in place of (overridden) the one on the location table.
-
overridePostalCode: string
The location postal code that is to be used for this involved party on an order release in place of (overridden) the one on the location table
-
overrideProvince: string
The location providence that is to be used for this involved party on an order release in place of (overridden) the one on the location table.
-
overrideProvinceCode: string
The location providence code that is to be used for this involved party on an order release in place of (overridden) the one on the location table.
Nested Schema : overrideAddresses
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : orderReleases.involvedParties.overrideAddresses
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
lineSequence: number
(int64)
The line sequence (key) for the involved party on the order release.
-
links: array
links
Read Only:
true
-
overrideAddressLine: string
The address line that is to be used for this involved party on an order release in place (Overridden) of the one on the contact table for the involved party.
Nested Schema : orderReleases.legConstraints
Type:
Show Source
object
-
buyRateGeoGid: string
The buy rate detail GID used as a planning constraint.
-
buyRateOfferingGid: string
The buy rate offering GID used as a planning constraint.
-
domainName: string
Database domain where this data is stored.
-
equipmentGroupGid: string
The equipment group GID used as a planning constraint.
-
equipmentGroupProfileGid: string
The equipment group profile GID used as a planning constraint.
-
legClassificationGid: string
The leg classification identifier. The leg classification on the order matches to a leg classification on the itinerary leg. The constraints defined here apply to that leg's shipment.
-
legConsolidationGroupGid: string
The load consolidation group set through network planning while managing leg classifications.
-
links: array
links
Read Only:
true
-
modeProfileGid: string
The mode profile GID used as a planning constraint.
-
rateServiceProfileGid: string
The rate service profile GID used as a planning constraint.
-
sellRateGeoGid: string
The sell rate detail GID used as a planning constraint.
-
sellRateOfferingGid: string
The sell rate offering GID used as a planning constraint.
-
servprovGid: string
The service provider GID used as a planning constraint.
-
servprovProfileGid: string
The service provider profile GID used as a planning constraint.
-
shipWithGroup: string
The ship with group for applied to this leg classification.
-
transportModeGid: string
The transport mode GID used as a planning constraint.
Nested Schema : orderReleases.lines
Type:
Show Source
object
-
allocations:
allocations
-
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)
-
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
-
attributes:
attributes
-
billedQuantity: number
(double)
The billed quantity for order release line goods.
-
billedQuantityUomCode: string
The billed quantity unit of measure.
-
billedQuantityUomType: string
The billed quantity unit of measure type.
-
brandName: string
The brand name. For informational purposes.
-
buyGeneralLedgerGid: string
The general ledger code for the order release line for the buy side (cost).
-
commercialInvoiceDescription: string
A description field for the commercial invoice.
-
commercialInvoiceGid: string
The commercial invoice GID for the object that is associated with this order release line.
-
declaredValue:
declaredValue
The declared cost of the item.
-
domainName: string
Database domain where this data is stored.
-
equipmentRefUnits:
equipmentRefUnits
-
freeAlongSide:
freeAlongSide
Refers to the seller's price quote for the goods, including the charge for delivery of the goods alongside a vessel at the named port of export.
-
hazActivity: string
The hazardous activity field indicates the level of radioactivity of the product.
-
hazAllPacked: boolean
Flag to indicate the package is "All packed in one".
-
hazApprovalExemptionGid: string
The hazardous approval exemption GID.
-
hazardousClassificationGid: string
The hazardous classification GID.
-
hazAuthorization: string
The authorization for the dangerous goods shipment. The authorization field is only required to state special governmental authorizations that are required because of the provisions or packing materials shipped with.
-
hazChemicalFormula: string
The basic chemical description of the substance.
-
hazCompatibilityGroup: string
The hazardous material compatibility group associated to the order release line.
-
hazConcentrationPercent: number
(double)
Required if the dangerous goods UN number is 2031, 1796, 1826, or 1873. Enter the percentage of dangerous goods concentration if the above condition applies.
-
hazControlTemp:
hazControlTemp
The hazardous control temperature to report for this order release line.
-
hazCritSafetyIndex: number
(double)
A measurement for packages containing fissile material that is determined by dividing the number 50 by the smaller of the numbers determined using the rules in section 10.6.2.4.3 of the IATA Dangerous Goods Regulation Guide.
-
hazEmergencyResponseInfo: string
The emergency response information is a number associated with the International Maritime Organization (IMO), which promulgates, encourages, and enforces the highest standards of marine safety in vessel transport. Enter an IMDG emergency response number for this hazardous material.
-
hazEmergencyTemp:
hazEmergencyTemp
The emergency temperature at which the product will begin the process of self-destructing or breaking down.
-
hazEms: string
The EMS (Emergency aboard Ship) field. The page number is required for documentation.
-
hazErg: string
The ERG (Emergency Response Guide) field. The page number is required for documentation purposes.
-
hazErgAir: string
The ERG (Emergency Response Guide) field for air. The page number is required for documentation purposes.
-
hazExtCode: string
The item hazmat code as configured in the TNT EM. (For carrier TNT).
-
hazFlashPoint:
hazFlashPoint
The hazardous flash point for this material is the lowest temperature at which the vapor of the material (if it is a combustible liquid) can be made to ignite momentarily in air. Enter a numeric value if applicable and select K for Kelvin, F for Fahrenheit, or C for Centigrade as the temperature type.
-
hazHazardousDescription: string
A hazardous description for documentation.
-
hazHazmatGenericGid: string
The hazmat generic GID is the link between a hazardous material and a hazardous item.
-
hazHazmatItemGid: string
The hazmat item GID defines the entry in the hazmat table that contains attributes associated to this order release line.
-
hazIdentificationNumber: string
The hazardous classification ID is the numeric class of the hazardous material as specified by Department of Transportation regulations. Enter the hazard class in this field.
-
hazIdgAddDescInfo: string
The hazmat IDG additional description information.
-
hazInhalationHazardZone: string
This zone indicates the area of a toxicity hazard based on the concentration of the hazardous material.
-
hazIsCommercialAircraftFor: boolean
A Y/N indicator specifying the commercial aircraft forbidden indicator if the material cannot be transported on passenger aircraft.
-
hazIsLimitedQuantity: boolean
A Y/N indicator for the limited quantity residual amounts.
-
hazIsMarinePollutant: boolean
A Y/N indicator defining this order as a marine pollutant.
-
hazIsNos: boolean
A Y/N indicator defining this order release line as a hazardous not otherwise specified.
-
hazIsOilContained: boolean
A Y/N indicator that the check hazardous is oil contained field if the material is an oil-based product.
-
hazIsOverpack: boolean
Flag to indicate the package is an "overpack".
-
hazIsPassengerAircraftForb: boolean
A Y/N indicator specifying the passenger aircraft forbidden indicator if the material cannot be transported on passenger aircraft.
-
hazIsReportableQuantity: boolean
A Y/N indicator, the reportable quantity (RQ) indicator if the material is composed of quantities of other chemicals that are hazardous and must be reported by concentration percentage. RQs are the chemical components of a hazardous item that have reached a threshold in a shipping container that make them reportable as hazardous items.
-
hazIsToxicInhalation: boolean
A Y/N indicator defining the hazardous toxic inhalation value.
-
hazMaxQuantity: number
(double)
The maximum passenger volume or the maximum cargo volume for the item. Used in Q- Value calculation.
-
hazMpTechnicalName: string
The marine pollutant technical name for this hazardous substance.
-
hazMpTechnicalName2: string
The marine pollutant technical name for this hazardous substance. You can specify up to 2.
-
hazNetExplosvContentWeight:
hazNetExplosvContentWeight
The hazardous net explosive content weight is the net weight of the explosive contents of the order release line.
-
hazNosTechnicalName: string
The Not Otherwise Specified (NOS) indicator if the material is composed of other chemicals not specified add the technical name.
-
hazNosTechnicalName2: string
The not otherwise specified (NOS) field if the material is composed of other chemicals not specified add the technical name. You can specify up to 2.
-
hazOuterPackagingType: string
Outer packaging type if packing type = All packed in one.
-
hazOuterPackingCount: number
(double)
The outer packing count.
-
hazPackageType: string
The hazmat package type of the dangerous goods shipment.
-
hazPackagingGroup: string
The packaging group denotes the classification of hazardous packaging for this material based on the reportable quantity of the material.
-
hazPackingCount: number
(double)
The packing count (number of packaged units).
-
hazPackingInstructions: string
Required for dangerous goods shipments, unless the dangerous goods class is radioactive or not restricted. See Table 4.2 columns G, I, or K of the IATA Dangerous Goods Regulation Guide.
-
hazPhysicalForm: string
A description of the physical form of the radioactive substance: S(p)ecial, (S)olid, (L)iquid, (G)as.
-
hazProperShippingName: string
The hazardous proper shipping name for the hazardous material is similar, but not identical to, the hazardous technical name of the material.
-
hazPsaSingaporeGroup: string
For the hazardous PSA Singapore Group enter a I, II, OR III. This regulates the cost of hazardous charge/cost at the Singapore destination.
-
hazQuantity: number
(double)
The hazmat item quantity.
-
hazQValue: number
(double)
The ratio used to indicate that the combined quantities in "all packed in one" package are within the maximum allowable limits.
-
hazRadioactiveLabel: string
The type of label on the shipment. W1 (White I), Y2 (Yellow II), Y3 (Yellow III).
-
hazRadioactivity: number
(double)
A measurement of the activity of the shipment. For fissile material, the weight of the material in grams or kilograms may be substituted for the activity measurement.
-
hazRadioactivityUnits: string
The units that the activity were measured in. This must be in Becquerel units (or multiples thereof): Bq (Becquerel), kBq (kilobecquerel), MBq (megabecquerel), GBq (gigabecquerel), TBq (terabecquerel), PBq (petabecquerel).
-
hazRadionuclide: string
The radionuclide assigned to the substance being shipped. A table of basic radionuclides is available in the IATA Dangerous Goods Regulation Guide section 10.4.A. For example, aluminum (13) has a radionuclide Al-26.
-
hazRadPackaging: string
A description of the type of packaging the substance is contained in. Acceptable package types are listed in section 10.5 of the dangerous goods regulations guide: Expected (Expected), Industrial ip1 (Industrial Type 1(IP-1)), Industrial ip2 (Industrial Type 2(IP-2)), Industrial ip3 (Industrial Type 3(IP-3)), Type a (Type A), Type b(m) ( Type B(M)), Type b(u) ( Type B(U)), Type c ( Type C ).
-
hazRqTechnicalName: string
The reportable quantity technical name.
-
hazRqTechnicalName2: string
The reportable quantity technical name. You can specify up to 2.
-
hazSpecialProvisions: string
Indicates dangerous goods (DG) are being shipped under one of the special provisions listed in the IATA Dangerous Goods Regulation Guide, section 4.4. There appear to be 146 different provisions, and multiple provisions may apply to a single item in some cases.
-
hazSubsidiaryHazard: string
The subsidiary hazard represents a Department of Transportation-specified code pertaining to the cleanup of a spill of a hazardous material.
-
hazSubstanceNumber: string
The hazardous materials substance number.
-
hazSurfaceReading: number
(double)
The surface reading of the radiation exposure for the package. This reading must be measured in mrem/h.
-
hazTransportIndex: number
(double)
A number based on the radiation exposure of a package. This is determined based on the maximum measurement of the radiation in mrem/h at a distance of 1 meter from the package surface.
-
hazType: string
The hazardous materials type. Valid values are: l = Limited Quantities, e = 500 KG Exemption, f = Fully Regulated (Purolater).
-
hazUnits: string
IATA units for non UPS shipments (L=>Liters g=>Grams kg=>Kilograms kg G=>Kilograms Gross).
-
initialItemGid: string
Can be used to define the substitution.
-
involvedParties:
involvedParties
-
isDrawback: boolean
A Y/N indicator defining if this order release line is part of the duty drawback program.
-
isHazardous: boolean
A Y/N indicator defining if the order release line is a hazardous goods. This is a transactional setting instead of looking at the item master definitions.
-
isSplitAllowed: boolean
Indicates if the order release ship units that are created can be split into multiple pieces of equipment.
-
itemPackageCount: number
(int64)
The packaging unit count associated to the packaging unit for this order release line.
-
links: array
links
Read Only:
true
-
manufacturedCountryCodeGid: string
The country code GID where this order release line was manufactured.
-
numLayersPerShipUnit: number
(int64)
The number of layers for the transportation handling unit defined here on the order base line. This allows the user to define the TiHi date used to build ship units on the order release per each transactional line passed in, instead of looking to the static TiHi data on the packaged item table.
-
obLineGid: string
Read Only:
true
The order base line from which this order release line was built. -
obLineRelInstrSeq: number
(int64)
The order base line release instruction sequence number, carried over from column OB_RELEASE_INSTRUCTION_SEQ in table OB_RELEASE_INSTRUCTION when the order release line is created from an order base line.
-
orderBaseGid: string
The order base from which this order release line was built.
-
orderReleaseLineGid: string
The GID for the order base line.
-
orderReleaseLineXid: string
The XID for the order base line.
-
packageCoreDiameter:
packageCoreDiameter
The package core diameter for order release line; overrides core diameter on packaged item. Used for products such as roll of paper that have different dimensions.
-
packageDiameter:
packageDiameter
The package diameter for order release line; overrides diameter on packaged item.
-
packagedItemGid: string
The packaged item GID defining the item associated to this order release line.
-
packageHeight:
packageHeight
The package height for order release line; overrides height on packaged item.
-
packageLength:
packageLength
The package length for order release line; overrides length on packaged item.
-
packageWidth:
packageWidth
The package width for order release line; overrides width on packaged item.
-
packagingUnitCount: number
(int64)
The packaging unit count associated to the packaging unit for this order base line.
-
packagingUnitGid: string
The packaging unit (considered an inner pack to the packaged item level) for this order release line.
-
packWithGroup: string
Lines with different Pack with Groups cannot be packed into the same ship unit.
-
pricePerUnit:
pricePerUnit
The price per unit for the order release line to indicate the amount billed.
-
pricePerUnitUomCode: string
The unit of measurement this unit price is based on.
-
pruDetails:
pruDetails
-
quantityPerLayer: number
(int64)
The quantity per layer for the transportation handling unit defined here on the order base line. This allows the user to define the TiHi date used to build ship units on the order release per each transactional line passed in, instead of looking to the static TiHi data on the packaged item table.
-
refnums:
refnums
-
remarks:
remarks
-
secondaryVolume:
secondaryVolume
The order release line can be specified in a secondary volume value for informational purposes.
-
secondaryWeight:
secondaryWeight
The order release line can be specified in a secondary weight value for informational purposes.
-
sellGeneralLedgerGid: string
The general ledger code for the order release line for the sell side (revenue).
-
specialServices:
specialServices
-
tag1: string
Additional information about the item. Like the color, size, or code.
-
tag2: string
Additional information about the item. Like the color, size, or code.
-
tag3: string
Additional information about the item. Like the color, size, or code.
-
tag4: string
Additional information about the item. Like the color, size, or code.
-
texts:
texts
-
thuProfileGid: string
The transport handling unit profile (list of valid THUs for this order line) that is to be used when building the order release ship unit. If defined here it will take precedence to the data that is defined on the static packaged item table.
-
totalBilledAmt:
totalBilledAmt
The total billed amount to the customer for the line. It can contain handling and additional costs beyond goods.
-
transportHandlingUnitGid: string
The transport handling unit that is to be used when building the order release ship unit. If defined here it will take precedence to the data that is defined on the static packaged item table.
-
volume:
volume
The volume of the item.
-
weight:
weight
The weight of the item.
Nested Schema : allocations
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate11
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate12
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate13
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate14
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate15
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate16
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate17
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate18
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate19
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate20
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data Type Date
Match All
Show Source
Nested Schema : attributes
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : equipmentRefUnits
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : freeAlongSide
Refers to the seller's price quote for the goods, including the charge for delivery of the goods alongside a vessel at the named port of export.
Match All
Show Source
Nested Schema : hazControlTemp
The hazardous control temperature to report for this order release line.
Match All
Show Source
Nested Schema : hazEmergencyTemp
The emergency temperature at which the product will begin the process of self-destructing or breaking down.
Match All
Show Source
Nested Schema : hazFlashPoint
The hazardous flash point for this material is the lowest temperature at which the vapor of the material (if it is a combustible liquid) can be made to ignite momentarily in air. Enter a numeric value if applicable and select K for Kelvin, F for Fahrenheit, or C for Centigrade as the temperature type.
Match All
Show Source
Nested Schema : hazNetExplosvContentWeight
The hazardous net explosive content weight is the net weight of the explosive contents of the order release line.
Match All
Show Source
Nested Schema : involvedParties
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : packageCoreDiameter
The package core diameter for order release line; overrides core diameter on packaged item. Used for products such as roll of paper that have different dimensions.
Match All
Show Source
Nested Schema : packageDiameter
The package diameter for order release line; overrides diameter on packaged item.
Match All
Show Source
Nested Schema : packageHeight
The package height for order release line; overrides height on packaged item.
Match All
Show Source
Nested Schema : packageLength
The package length for order release line; overrides length on packaged item.
Match All
Show Source
Nested Schema : packageWidth
The package width for order release line; overrides width on packaged item.
Match All
Show Source
Nested Schema : pricePerUnit
The price per unit for the order release line to indicate the amount billed.
Match All
Show Source
Nested Schema : pruDetails
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : refnums
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : remarks
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : secondaryVolume
The order release line can be specified in a secondary volume value for informational purposes.
Match All
Show Source
Nested Schema : secondaryWeight
The order release line can be specified in a secondary weight value for informational purposes.
Match All
Show Source
Nested Schema : specialServices
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : texts
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : totalBilledAmt
The total billed amount to the customer for the line. It can contain handling and additional costs beyond goods.
Match All
Show Source
Nested Schema : orderReleases.lines.allocations
Type:
Show Source
object
-
allocationBase:
allocationBase
-
allocSeqNo: number
(int64)
No description.
-
baseCost:
baseCost
No description.
-
details:
details
-
domainName: string
No description.
-
exchangeRateDate:
exchangeRateDate
No description.
-
exchangeRateGid: string
No description.
-
links: array
links
Read Only:
true
-
orderReleaseGid: string
A unique identifier created by the system for the order release. the gid contains the domain portion.
-
packagedItemGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
-
privateCost:
privateCost
No description.
-
shipmentGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
-
totalAllocLineCost:
totalAllocLineCost
No description.
Nested Schema : allocationBase
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : details
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : orderReleases.lines.allocations.allocationBase
Type:
Show Source
object
-
allocatedCost:
allocatedCost
No description.
-
allocSeqNo: number
(int64)
No description.
-
allocTypeQualGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
-
domainName: string
No description.
-
exchangeRateDate:
exchangeRateDate
No description.
-
exchangeRateGid: string
No description.
-
invoiceGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
-
links: array
links
Read Only:
true
-
parentInvoiceGid: string
If populated, the INVOICE_GID indicates that this alllocation is for a child invoice. This column indicates the parent invoice of the entire consolidation that was allocated.
-
shipGroupGid: string
Represents Shipment Group ID. This is populated when allocating a shipment group or a voucher corresponding to an invoice created for a shipment
group. -
shipmentGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
-
timestamp:
timestamp
No description.
-
voucherGid: string
GC3 Global identifier for the entity. Is created by concatenating Domain Name,"." and XID.
Nested Schema : orderReleases.lines.allocations.details
Type:
Show Source
object
-
accessorialCodeGid: string
No description.
-
allocCostSeqno: number
(int64)
No description.
-
attribute1: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute10: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute11: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute12: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute13: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute14: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute15: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute16: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute17: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute18: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute19: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute2: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute20: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute3: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute4: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute5: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute6: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute7: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute8: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attribute9: string
Attribute (flex)fields allow you to add additional information about an object. Data type is VARCHAR2 (150).
-
attributeCurrency1:
attributeCurrency1
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
-
attributeCurrency2:
attributeCurrency2
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
-
attributeCurrency3:
attributeCurrency3
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
-
attributeDate1:
attributeDate1
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate10:
attributeDate10
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate11:
attributeDate11
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate12:
attributeDate12
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate13:
attributeDate13
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate14:
attributeDate14
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate15:
attributeDate15
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate16:
attributeDate16
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate17:
attributeDate17
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate18:
attributeDate18
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate19:
attributeDate19
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate2:
attributeDate2
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate20:
attributeDate20
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate3:
attributeDate3
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate4:
attributeDate4
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate5:
attributeDate5
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate6:
attributeDate6
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate7:
attributeDate7
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate8:
attributeDate8
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeDate9:
attributeDate9
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
-
attributeNumber1: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber10: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber11: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber12: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber13: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber14: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber15: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber16: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber17: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber18: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber19: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber2: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber20: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber3: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber4: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber5: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber6: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber7: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber8: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
attributeNumber9: number
(double)
Attribute (flex)fields allow you to add additional information about an object. Data type is NUMBER.
-
cost:
cost
No description.
-
costDescription: string
No description.
-
costTypeGid: string
cost type for this allocation record
-
domainName: string
No description.
-
exchangeRateDate:
exchangeRateDate
No description.
-
exchangeRateGid: string
No description.
-
generalLedgerGid: string
GL code for the allocation order release line record.
-
invoiceGid: string
No description.
-
lineitemSeqNo: number
(int32)
No description.
-
links: array
links
Read Only:
true
-
shipmentCostSeqno: number
(int64)
Shipment cost seq no would be stored if we perform allocation based on shipment
-
shipmentGid: string
Shipment Gid would be stored in this field if allocation is done based Shipment.
-
vatCodeGid: string
The GID for the VAT tax that is being allocated from voucher.
-
voucherGid: string
Voucher Gid would be stored in this field if allocation is done based on voucher or invoice
Nested Schema : attributeCurrency1
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
Match All
Show Source
Nested Schema : attributeCurrency2
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
Match All
Show Source
Nested Schema : attributeCurrency3
Attribute (flex)fields allow you to add additional information about an object. Data type is Currency.
Match All
Show Source
Nested Schema : attributeDate1
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate10
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate11
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate12
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate13
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate14
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate15
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate16
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate17
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate18
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate19
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate2
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate20
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate3
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate4
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate5
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate6
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate7
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate8
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : attributeDate9
Attribute (flex)fields allow you to add additional information about an object. Data type is DATE.
Match All
Show Source
Nested Schema : orderReleases.lines.attributes
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
itemFeatureQualGid: string
The item feature qualifier GID defining what type of feature with which this value is associated.
-
itemFeatureValue: string
The item feature value for the order release line. This allows for future structural definition of an item such as size and color.
-
links: array
links
Read Only:
true
Nested Schema : orderReleases.lines.equipmentRefUnits
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
equipmentReferenceUnitGid: string
The equipment reference unit GID for the order line.
-
links: array
links
Read Only:
true
-
numReferenceUnits: number
(double)
The number of ref units per package for the equipment reference unit GID on this line.
-
totalNumReferenceUnits: number
(double)
The total number of reference units for the equipment reference unit on this line.
Nested Schema : orderReleases.lines.involvedParties
Type:
Show Source
object
-
comMethodGid: string
The communication method ID for the involved party.
-
domainName: string
Database domain where this data is stored.
-
involvedPartyContactGid: string
The contact ID for the involved party.
-
involvedPartyQualGid: string
The qualifier ID for the involved party.
-
links: array
links
Read Only:
true
Nested Schema : orderReleases.lines.pruDetails
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
packagingReferenceUnitGid: string
The packaging reference unit GID. The package reference unit (PRU) defines another dimension to describe the consumption and capacity associated to building the order release ship units for transport. An example could be value of goods, loading meters, etc.
-
totalPruCount: number
(double)
The total packaging unit reference (PRU) count being described as how much of the PRU does this line consume against the upper limit.
-
unitPruCount: number
(double)
The packaging unit reference (PRU) count being described as how much of the PRU does this line consume.
Nested Schema : orderReleases.lines.refnums
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
orderReleaseRefnumQualGid: string
The reference number qualifier GID defining the reference code.
-
orlRefnumValue: string
The text associated to the remark code.
Nested Schema : orderReleases.lines.remarks
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
remarkQualGid: string
The remark qualifier GID defining the remark code.
-
remarkSequence: number
(int64)
The sequence identifier for the remark associated with the order base line.
-
remarkText: string
The text associated to the remark code.
Nested Schema : orderReleases.lines.specialServices
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
specialServiceCodeGid: string
The special service code GID.
Nested Schema : orderReleases.lines.texts
Type:
Show Source
object
-
documentDefGid: string
A document that should hold text.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
textOverride: string
The transactional override for the template on the specific document.
-
textTemplateGid: string
The text template qualifier GID defining the text.
Nested Schema : orderReleases.refnums
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
orderReleaseRefnumQualGid: string
The reference qualifier GID defining the reference code.
-
orderReleaseRefnumValue: string
The value associated to the reference code.
Nested Schema : orderReleases.remarks
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
remarkQualGid: string
A pointer to the remark type. For example: Service provider assigned equipment number, service provider tender decline reason code, etc.
-
remarkSequence: number
(int64)
The remark sequence (key) associated with the order release remarks.
-
remarkText: string
A user-entered remark on the order release.
Nested Schema : orderReleases.services
Type:
Show Source
object
-
customerServiceGid: string
The customer service GID for this customer service.
-
domainName: string
Database domain where this data is stored.
-
executedDate:
executedDate
It will be reset to the date when this service template is applied last time.
-
isProrityOverwrite: boolean
If this field is Y, this customer service will be treated as the highest priority. It will be reset to N after the service template is applied.
-
links: array
links
Read Only:
true
Nested Schema : executedDate
It will be reset to the date when this service template is applied last time.
Match All
Show Source
Nested Schema : orderReleases.shipUnits
Type:
Show Source
object
-
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)
-
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
-
coreDiameter:
coreDiameter
For cylindrical objects, this defines the diameter of the core
-
domainName: string
Database domain where this data is stored.
-
dropoffOrStopGid: string
This ship unit is going to be dropped off at this stop. If this field is empty, this ship unit is dropped off at the order's destination location.
-
equipmentRefUnits:
equipmentRefUnits
-
flexCommodityCode: string
The user defined commodity code for the item. E.g.. the HTS, NMFC, SITC, STCC codes for the item.
-
flexCommodityQualGid: string
A unique identifier to define the type of the code. E.g.. HTS, SITC, STCC, NMFC etc.
-
isAllowRepack: boolean
A Y/N field, if this flag is set to false, when planning order movement that contains this shipment ship unit or combine shipments that contains this shipment ship unit, the shipment ship unit building process will not repack this s ship unit.
-
isCountSplittable: boolean
A Y/N indicator for whether the ship unit can be split on the count boundaries when planning during container optimization.
-
isExclusiveUse: boolean
Used to specify if the ship unit is EXCLUSIVE USE. Ship unit is not mixed with anything even if they belong to the same MIXING family if its marked as EXCLUSIVE USE.
-
isSplitable: boolean
A Y/N flag to identify if the ship unit can be split when creating an order.
-
isSystemGenerated: boolean
A Y/N indicator to define if the record is generated by the system for the order base or copied (may be from XML).
-
lines:
lines
-
links: array
links
Read Only:
true
-
loadConfigSetupGid: string
A load configurator set up identifier to be used by the load configuration engine as the input rules for how the ship unit was built.
-
loadingSplits:
loadingSplits
-
obShipUnitGid: string
Read Only:
true
The order base ship unit associated with the order release ship unit if it was created from an order base and the releasing logic. -
obSuReleaseInstrSeq: number
(int64)
Read Only:
true
The release instruction associated to the order base if the order release was created from an order base through the releasing logic. -
orEquipmentSeq: number
(int32)
Associates equipment of the order release to this particular ship unit.
-
pickupOrStopGid: string
This ship unit is going to be picked up at this stop. If this field is empty, this ship unit is picked up at the order's source location.
-
priority: number
(int32)
This column defines the priority associated with a ship unit.
-
refnums:
refnums
-
remarks:
remarks
-
seals:
seals
-
secondaryUnitVolume:
secondaryUnitVolume
An additional value for the secondary gross volume of the ship unit.
-
secondaryUnitWeight:
secondaryUnitWeight
An additional value for the secondary gross weight of the ship unit.
-
secondryUnitNetVol:
secondryUnitNetVol
An additional value for the secondary net volume of the ship unit.
-
secondryUnitNetWt:
secondryUnitNetWt
An additional value for the secondary net weight of the ship unit.
-
shipUnitCount: number
(int64)
Ship units that have the same dimension/weight and contents are represented as one row in the SHIP_UNIT table. The ship unit count is the number of these ship units.
-
shipUnitGid: string
The GID for the ship unit associated to an order release.
-
shipUnitXid: string
The XID for the ship unit associated to a order release.
-
specialServices:
specialServices
-
tag1: string
A flexible field to contain informational data that has been copied from the order to the shipment.
-
tag2: string
A flexible field to contain informational data that has been copied from the order to the shipment.
-
tag3: string
A flexible field to contain informational data that has been copied from the order to the shipment.
-
tag4: string
A flexible field to contain informational data that has been copied from the order to the shipment.
-
texts:
texts
-
totalGrossVolume:
totalGrossVolume
The total gross volume of the order release ship unit (transport handling unit + lines).
-
totalGrossWeight:
totalGrossWeight
The total gross weight of the order release ship unit (transport handling unit + lines).
-
transportHandlingUnitGid: string
The transport handling unit identifier defined for the ship unit. Examples are a box and a pallet.
-
unitDiameter:
unitDiameter
The unit diameter of the ship unit.
-
unitHeight:
unitHeight
The height of each order release ship unit. If this row represents the 20 same ship units, the total height is 20 x unit height.
-
unitLength:
unitLength
The length of each order release ship unit. If this row represents 20 of the same ship units, the total length is 20 x unit length.
-
unitNetVolume:
unitNetVolume
The net volume of the ship unit.
-
unitNetWeight:
unitNetWeight
The net weight of the ship unit.
-
unitVolume:
unitVolume
The volume of each order release ship unit. Each row may represent the ship unit count number of same ship units. If this field is null or is 0, the volume of this shipment ship unit is computed as the total of container volume from its ship unit specification and the volume of its shipment ship unit lines.
-
unitWeight:
unitWeight
The weight of the ship unit.
-
unitWidth:
unitWidth
The width of each order release ship unit. Each row may represent the ship unit count number of same ship units. If this field is null or is 0, the weight of this order release ship unit is computed as the total of container weight from its ship unit specification and the weight of its shipment ship unit lines.
Nested Schema : attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate11
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate12
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate13
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate14
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate15
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate16
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate17
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate18
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate19
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate20
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : coreDiameter
For cylindrical objects, this defines the diameter of the core
Match All
Show Source
Nested Schema : equipmentRefUnits
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : lines
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : loadingSplits
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : refnums
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : remarks
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : seals
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : secondaryUnitVolume
An additional value for the secondary gross volume of the ship unit.
Match All
Show Source
Nested Schema : secondaryUnitWeight
An additional value for the secondary gross weight of the ship unit.
Match All
Show Source
Nested Schema : secondryUnitNetVol
An additional value for the secondary net volume of the ship unit.
Match All
Show Source
Nested Schema : secondryUnitNetWt
An additional value for the secondary net weight of the ship unit.
Match All
Show Source
Nested Schema : specialServices
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : texts
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : totalGrossVolume
The total gross volume of the order release ship unit (transport handling unit + lines).
Match All
Show Source
Nested Schema : totalGrossWeight
The total gross weight of the order release ship unit (transport handling unit + lines).
Match All
Show Source
Nested Schema : unitHeight
The height of each order release ship unit. If this row represents the 20 same ship units, the total height is 20 x unit height.
Match All
Show Source
Nested Schema : unitLength
The length of each order release ship unit. If this row represents 20 of the same ship units, the total length is 20 x unit length.
Match All
Show Source
Nested Schema : unitVolume
The volume of each order release ship unit. Each row may represent the ship unit count number of same ship units. If this field is null or is 0, the volume of this shipment ship unit is computed as the total of container volume from its ship unit specification and the volume of its shipment ship unit lines.
Match All
Show Source
Nested Schema : unitWidth
The width of each order release ship unit. Each row may represent the ship unit count number of same ship units. If this field is null or is 0, the weight of this order release ship unit is computed as the total of container weight from its ship unit specification and the weight of its shipment ship unit lines.
Match All
Show Source
Nested Schema : orderReleases.shipUnits.equipmentRefUnits
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
equipmentReferenceUnitGid: string
The equipment reference unit, such as loading meter, that is referring to the equipment consumption value.
-
links: array
links
Read Only:
true
-
numReferenceUnits: number
(double)
The number of equipment reference units this ship unit will consume when loading onto the equipment.
-
totalNumReferenceUnits: number
(double)
The total equipment reference units max consumption demand for this ship unit.
Nested Schema : orderReleases.shipUnits.lines
Type:
Show Source
object
-
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)
-
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
-
attributeDate2:
attributeDate2
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
-
attributeNumber2: 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
-
countPerShipUnit: number
(int64)
The count per ship unit.
-
domainName: string
Database domain where this data is stored.
-
itemPackageCount: number
(int64)
The number of packages in this order release ship unit line for one ship unit. Its ship unit may represent more than one same ship units. E.g., for 20 ship units that contains 4 cases of 24 cans of cocoa, each order release ship unit line row will have an item GID: cocoa, item count 4x24, item package specification: case-of-24-cans, item package count: 4. The ship unit count will be 20.
-
links: array
links
Read Only:
true
-
netVolume:
netVolume
The net volume of the item.
-
netWeight:
netWeight
The net weight of the item.
-
obLineGid: string
Read Only:
true
The order base line associated with this ship unit line content line items if the order release was built from the order base. -
obLineReleaseInstrSeq: number
(int64)
Read Only:
true
The release instruction identifier from the order base line if the ship unit line was constructed through the order base releasing logic. -
orderReleaseLineGid: string
The order release line associated with this ship unit line content line items. This attribute is marked as Create-Only.
-
packagedItemGid: string
The packaged item GID defining the line for the ship unit.
-
packagingUnitCount: number
(int64)
The packaging unit count for the packaged unit that is being shipped.
-
packagingUnitGid: string
The GID for the packaging unit that is related to the shipment line.
-
refnums:
refnums
-
remarks:
remarks
-
secondaryVolume:
secondaryVolume
As additional value for the secondary volume of the item.
-
secondaryWeight:
secondaryWeight
An additional value for the secondary weight of the item.
-
secondryNetVolume:
secondryNetVolume
As additional value for the net secondary volume of the item.
-
secondryNetWeight:
secondryNetWeight
An additional value for the secondary net weight of the item.
-
shipUnitLineNo: number
(int32)
The unique sequence within the ship unit to define the individual line items.
-
volume:
volume
The gross volume of the item.
-
volumePerShipUnit:
volumePerShipUnit
The weight per shipping line count to handle shipping a multiple count.
-
weight:
weight
The gross weight of the item.
-
weightPerShipUnit:
weightPerShipUnit
The weight per shipping line count to handle shipping a multiple count.
Nested Schema : attributeDate1
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate10
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate2
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate3
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate4
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate5
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate6
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate7
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate8
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : attributeDate9
Attribute fields (flexfields) allow you to add additional information about an object. Data type date
Match All
Show Source
Nested Schema : refnums
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : remarks
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : secondaryVolume
As additional value for the secondary volume of the item.
Match All
Show Source
Nested Schema : secondaryWeight
An additional value for the secondary weight of the item.
Match All
Show Source
Nested Schema : secondryNetVolume
As additional value for the net secondary volume of the item.
Match All
Show Source
Nested Schema : secondryNetWeight
An additional value for the secondary net weight of the item.
Match All
Show Source
Nested Schema : volumePerShipUnit
The weight per shipping line count to handle shipping a multiple count.
Match All
Show Source
Nested Schema : weightPerShipUnit
The weight per shipping line count to handle shipping a multiple count.
Match All
Show Source
Nested Schema : orderReleases.shipUnits.lines.refnums
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
shipUnitRefnumQualGid: string
The reference number qualifier GID defining the reference code.
-
shipUnitRefnumValue: string
The text associated to the reference code.
Nested Schema : orderReleases.shipUnits.lines.remarks
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
remarkQualGid: string
The remark qualifier identifier defining the remark code.
-
remarkSequence: number
(int64)
The sequence identifier for the remark associated with the order release.
-
remarkText: string
The text associated to the remark code.
Nested Schema : orderReleases.shipUnits.loadingSplits
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
height:
height
The height for the this part of the ship unit split.
-
length:
length
The length for the this part of the ship unit split.
-
links: array
links
Read Only:
true
-
splitNo: number
(int32)
The split number for the ship unit.
-
volume:
volume
The volume for the this part of the ship unit split.
-
weight:
weight
The weight for the this part of the ship unit split.
-
width:
width
The width for the this part of the ship unit split.
Nested Schema : orderReleases.shipUnits.refnums
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
shipUnitRefnumQualGid: string
The reference number qualifier identifier defining the reference code.
-
shipUnitRefnumValue: string
The text associated to the reference number code.
Nested Schema : orderReleases.shipUnits.remarks
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
remarkQualGid: string
The remark qualifier identifier defining the remark code.
-
remarkSequence: number
(int64)
The sequence identifier for the remark associated with the order release.
-
remarkText: string
The text associated to the remark code.
Nested Schema : orderReleases.shipUnits.seals
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
shipUnitSealNum: string
The ship unit seal number for the order release ship unit.
Nested Schema : orderReleases.shipUnits.specialServices
Type:
Show Source
object
-
domainName: string
The special service associated with the remark.
-
links: array
links
Read Only:
true
-
specialServiceGid: string
The special service identifier defining the special service that needs to be performed for the ship unit.
Nested Schema : orderReleases.shipUnits.texts
Type:
Show Source
object
-
documentDefGid: string
Document that should hold text.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
textOverride: string
Transactional override for the template on the specific document.
-
textTemplateGid: string
The GID for the text template. A text template is a predefined, formatted selection of text that is identified by a business object. Use text templates to attach a short paragraph of text to a document, XML transmission, or notification (via XSL stylesheet).
Nested Schema : orderReleases.specialServices
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
forSourceDest: string
Define if this special service is required for source and/or destination location of this order.
-
links: array
links
Read Only:
true
-
specialServiceCodeGid: string
The special service code GID defining the service required.
-
time:
time
The duration required for the special service.
Nested Schema : orderReleases.statuses
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
statusTypeGid: string
The status type GID for the status value on the order release.
-
statusValueGid: string
The status value for the order release status.
Nested Schema : orderReleases.stops
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
earlyArrivalTime:
earlyArrivalTime
The arrival date and time for the stop, and when IS_APPT is Y, this field is early appointment time.
-
isAppt: boolean
A Y/N field indicating that the times are for appointments, when IS_APPT is Y, EARLY/LATE_ARRIVAL_TIME are appointment times.
-
isApptConfirmed: boolean
A Y/N field to indicate the appointment is confirmed.
-
isApptConfirmRequired: boolean
A Y/N field to indicate if appointment confirmation is required.
-
isApptRequired: boolean
A Y/N field to indicate if appointment is required.
-
lateArrivalTime:
lateArrivalTime
The late arrival date and time for the stop, and when IS_APPT is Y, this field is late appointment time.
-
legPosition: string
Define where to insert this stop in a multi-stop situation.
-
links: array
links
Read Only:
true
-
locationGid: string
The location GID for the shipment stop.
-
orStopGid: string
The GID for the stop associated to the order release for multi-stop orders.
-
orStopSeq: number
(int32)
The stop number within the order release. Stop number = 1 is the pickup stop, and the max (stop number) for a shipment is the delivery stop.
-
orStopXid: string
The XID for the stop associated to the order release for multi-stop orders.
-
remarks:
remarks
-
specialServices:
specialServices
Nested Schema : earlyArrivalTime
The arrival date and time for the stop, and when IS_APPT is Y, this field is early appointment time.
Match All
Show Source
Nested Schema : lateArrivalTime
The late arrival date and time for the stop, and when IS_APPT is Y, this field is late appointment time.
Match All
Show Source
Nested Schema : remarks
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : specialServices
Type:
Show Source
object
-
items: array
items
-
links: array
links
Read Only:
true
Nested Schema : orderReleases.stops.remarks
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
remarkQualGid: string
A pointer to the remark type. For example: Service provider assigned equipment number, service provider tender decline reason code, etc.
-
remarkSequence: number
(int64)
The sequence (key) for the remark.
-
remarkText: string
A user-entered remark.
Nested Schema : orderReleases.stops.specialServices
Type:
Show Source
object
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
specialServiceGid: string
The special service code identifier defining the service required.
-
time:
time
The duration required for the special service at the stop.
Nested Schema : time
The duration required for the special service at the stop.
Match All
Show Source
Nested Schema : orderReleases.texts
Type:
Show Source
object
-
documentDefGid: string
A document that should hold text.
-
domainName: string
Database domain where this data is stored.
-
links: array
links
Read Only:
true
-
textOverride: string
Transactional override for the template on the specific document.
-
textTemplateGid: string
The foreign key to the text template table, in order to include fixed text with this order release.
Nested Schema : orderReleases.trackingEvents
Type:
Show Source
object
-
bsContactFunctionCode: string
This indicates the shipment stop number for a stop based event.
-
bsContactName: string
The reporting method that links into the communication methods defined for OTM.
-
bsReasonCodeGid: string
The reason code from the tracking event that was matched to the order releases.
-
bsResponsiblePartyGid: string
The responsible party identifier of the source of the tracking event.
-
bsStatusCodeGid: string
A Y/N indicator to display the status history.
-
description: string
A description of the tracking event.
-
domainName: string
Database domain where this data is stored.
-
eventDate:
eventDate
The location identifier of an location based event. This will be null for non-location based events.
-
iTransactionNo: number
(int64)
The transaction identifier for the order release data of the tracking event.
-
links: array
links
Read Only:
true
-
orderReleaseRefnumQualGid: string
The order release reference number qualifier identifier.
-
orderReleaseRefnumValue: string
The order release reference number value associated with the order release qualifier that came on the tracking event.
-
reportingGluser: string
The service provider associated with generating the tracking event.
-
statusLevel: string
A descriptor code for the status level of the tracking event.
-
timeZoneGid: string
The monthly range partition to manage purging status messages.
Nested Schema : eventDate
The location identifier of an location based event. This will be null for non-location based events.
Match All
Show Source