JDBC Driver for Oracle SCM

Build 22.0.8462

TransitTimes

The Transit Times resource gets the transit times that indicate how long a package or shipment will be in transit.

Columns

Name Type Description
TransitTimeId [KEY] String The value that uniquely identifies the transit time. It is a value that the application generates when it creates a transit time.
Origin String Origin of TransitTimes
OriginDescription String OriginDescription of TransitTimes
OriginTypeCode String The abbreviation that identifies the type of location for the origin of the shipping lane. This attribute is required. Valid values include LI for Internal Location, R for Geography, Z for Zone, and LE for External Location. A list of accepted values is defined in the lookup type WSH_ORG_DEST_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Carriers Lookups task.
OriginGeographyId String The value that uniquely identifies the selected geography when Origin Type is Geography. The default value is null.
OriginGeographyName String The name of the selected geography when Origin Type is Geography. The default value is null.
OriginGeographyDescription String The comma delimited concatenation of the geography hierarchy when Origin Type is Geography. The default value is null.
OriginZoneId String The value that uniquely identifies the selected zone when Origin Type is Zone. The default value is null.
OriginZoneName String The name of the selected zone when Origin Type is Zone. The default value is null.
OriginInternalLocationId String The value that uniquely identifies the selected warehouse location when Origin Type is Internal Location. The default value is null.
OriginInternalLocationCode String The abbreviation that identifies the selected warehouse location when Origin Type is Internal Location. Location codes are only unique within a location set. The default value is null.
OriginInternalLocationSetName String The name of the set that the selected warehouse location was chosen from when Origin Type is Internal Location. The default value is null.
OriginExternalLocationId String The value that uniquely identifies the selected address from the trading community architecture when Origin Type is External Location. It is the value of the LOCATION_ID column in the HZ_LOCATIONS table. The default value is null.
OriginExternalLocationName String The selected address from the trading community architecture when Origin Type is External Location. It is the value of the ADDRESS1 column in the HZ_LOCATIONS table. The default value is null.
OriginExternalLocationSourceType String The value that uniquely identifies the specific kind of trading community architecture location has is selected. Valid values are SA for Supplier Address, ST for Ship-to Address, and null.
OriginExternalLocationSourceId String The value that uniquely identifies the selected trading community architecture record based upon the type of source used. When the origin is a supplier address, the value represents a party site identifier. When the origin is a ship-to address, the value represents a party site identifier for the customer address. The default value is null.
OriginExternalLocationSourceName String The value that uniquely identifies the selected trading community architecture record based upon the type of source used. When the origin is a supplier address, the value represents a party site name. When the origin is a ship-to address, the value represents a party site name for the customer address. The default value is null.
OriginExternalLocationSupplierId String The value that uniquely identifies the selected supplier when the origin type is a supplier address.
OriginExternalLocationSupplierName String The name of the selected supplier when the origin type is a supplier address.
DestinationTypeCode String The abbreviation that identifies the type of location for the destination of the shipping lane. This attribute is required. Valid values include LI for Internal Location, G for Geography, Z for Zone, and LE for External Location. A list of accepted values is defined in the lookup type WSH_ORG_DEST_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Carriers Lookups task.
Destination String Destination of TransitTimes
DestinationDescription String DestinationDescription of TransitTimes
DestinationGeographyId String The value that uniquely identifies the selected geography when Destination Type is Geography. The default value is null.
DestinationGeographyName String The name of the selected geography when Destination Type is Geography. The default value is null.
DestinationGeographyDescription String The comma delimited concatenation of the geography hierarchy when Destination Type is Geography. The default value is null.
DestinationZoneId String The value that uniquely identifies the selected zone when Destination Type is Zone. The default value is null.
DestinationZoneName String The name of the selected zone when Destination Type is Zone. The default value is null.
DestinationInternalLocationId String The value that uniquely identifies the selected warehouse location when Destination Type is Internal Location. The default value is null.
DestinationInternalLocationCode String The short name that identifies the selected warehouse location when Destination Type is Internal Location. Location Codes are only unique within a Location Set. The default value is null.
DestinationInternalLocationSetName String The name of the set that the selected warehouse location was chosen from when Destination Type is Internal Location. The default value is null.
DestinationExternalLocationId String The value that uniquely identifies the selected address from the trading community architecture when Destination Type is External Location. It is the value of the LOCATION_ID column in the HZ_LOCATIONS table. The default value is null.
DestinationExternalLocationName String The selected address from the trading community architecture when Destination Type is External Location. It is the value of the ADDRESS1 column in the HZ_LOCATIONS table. The default value is null.
DestinationExternalLocationSourceType String The value that uniquely identifies the selected kind of trading community architecture location. Valid values are SA for Supplier Address, ST for Ship-to Address, and null.
DestinationExternalLocationSourceId String The value that uniquely identifies the selected trading community architecture record based upon the type of source used. When Destination is a supplier address, the value represents a party site identifier. When Destination is a ship-to address, the value represents a party site identifier for the customer address. The default value is null.
DestinationExternalLocationSourceName String The value that uniquely identifies the selected trading community architecture record based upon the type of source used. When Destination is a supplier address, the value represents a party site name. When Destination is a ship-to address, the value represents a party site name for the customer address. The default value is null.
DestinationExternalLocationSupplierId String The value that uniquely identifies the selected supplier when the Destination Type is a supplier address.
DestinationExternalLocationSupplierName String The name of the selected supplier when Destination Type is a supplier address.
OriginExternalLocationShipToCustomerId String The value that uniquely identifies the selected trading community architecture record based upon the type of source used. When the origin is a ship-to address, the value represents a party identifier for the selected customer. The default value is null.
OriginExternalLocationCustomerName String The name of the selected customer when the origin type is a ship-to address. The default value is null.
DestinationExternalLocationShipToCustomerId String The value that uniquely identifies the selected trading community architecture record based upon the type of source used. When the destination is a ship-to address, the value represents a party identifier for the selected customer. The default value is null.
DestinationExternalLocationCustomerName String The name of the selected customer when the destination type is a ship-to address. The default value is null.
CreatedBy String CreatedBy of TransitTimes
CreationDate Datetime CreationDate of TransitTimes
LastUpdateDate Datetime LastUpdateDate of TransitTimes
LastUpdatedBy String LastUpdatedBy of TransitTimes

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462