Powered by InfoCaptor


Previous Page   Next Page

Drop Off Stops
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.WSHFG_TRIP_STOPSUnknown
NoneNone.WSHFG_TRIP_STOPSUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Actual Arrival Date Drop Off Stops.Actual Arrival DateACTUAL_ARRIVAL_DATEACTUAL_ARRIVAL_DATE114847
Actual Arrival Date - Day Drop Off Stops.Actual Arrival Date ACTUAL_ARRIVAL_DATE_DAY168612
Actual Arrival Date - Month Drop Off Stops.Actual Arrival Date ACTUAL_ARRIVAL_DATE_MONTH168616
Actual Arrival Date - Quarter Drop Off Stops.Actual Arrival Date ACTUAL_ARRIVAL_DATE_QUARTER168620
Actual Arrival Date - Year Drop Off Stops.Actual Arrival Date ACTUAL_ARRIVAL_DATE_YEAR168624
Actual Departure Date Drop Off Stops.Actual Departure DateACTUAL_DEPARTURE_DATEACTUAL_DEPARTURE_DATE114867
Actual Departure Date - Day Drop Off Stops.Actual Departure Date ACTUAL_DEPARTURE_DATE_DAY168641
Actual Departure Date - Month Drop Off Stops.Actual Departure Date ACTUAL_DEPARTURE_DATE_MONTH168645
Actual Departure Date - Quarter Drop Off Stops.Actual Departure Date ACTUAL_DEPARTURE_DATE_QUARTER168649
Actual Departure Date - Year Drop Off Stops.Actual Departure Date ACTUAL_DEPARTURE_DATE_YEAR168653
Created By Drop Off Stops.Created ByCREATED_BYCREATED_BY124671
Creation Date Drop Off Stops.Creation DateCREATION_DATECREATION_DATE126097
Departure Fill Percent Drop Off Stops.Departure Fill PercentDEPARTURE_FILL_PERCENTDEPARTURE_FILL_PERCENT129189
Departure Gross Weight Drop Off Stops.Departure Gross WeightDEPARTURE_GROSS_WEIGHTDEPARTURE_GROSS_WEIGHT129191
Departure Net Weight Drop Off Stops.Departure Net WeightDEPARTURE_NET_WEIGHTDEPARTURE_NET_WEIGHT129193
Departure Seal Code Drop Off Stops.Departure Seal CodeDEPARTURE_SEAL_CODEDEPARTURE_SEAL_CODE129195
Departure Volume Drop Off Stops.Departure VolumeDEPARTURE_VOLUMEDEPARTURE_VOLUME129197
Last Update Date Drop Off Stops.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140633
Last Update Login Drop Off Stops.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN141449
Last Updated By Drop Off Stops.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139296
Location DescriptionDescription of the location.Drop Off Stops.Location DescriptionLOCATION_DESCRIPTIONLOCATION_DESCRIPTION145040
Pending Interface Flag Drop Off Stops.Pending Interface FlagPENDING_INTERFACE_FLAGPENDING_INTERFACE_FLAG272835
Planned Arrival Date Drop Off Stops.Planned Arrival DatePLANNED_ARRIVAL_DATEPLANNED_ARRIVAL_DATE154189
Planned Arrival Date - Day Drop Off Stops.Planned Arrival Date PLANNED_ARRIVAL_DATE_DAY188470
Planned Arrival Date - Month Drop Off Stops.Planned Arrival Date PLANNED_ARRIVAL_DATE_MONTH188474
Planned Arrival Date - Quarter Drop Off Stops.Planned Arrival Date PLANNED_ARRIVAL_DATE_QUARTER188478
Planned Arrival Date - Year Drop Off Stops.Planned Arrival Date PLANNED_ARRIVAL_DATE_YEAR188482
Planned Departure Date Drop Off Stops.Planned Departure DatePLANNED_DEPARTURE_DATEPLANNED_DEPARTURE_DATE154194
Planned Departure Date - Day Drop Off Stops.Planned Departure Date PLANNED_DEPARTURE_DATE_DAY188486
Planned Departure Date - Month Drop Off Stops.Planned Departure Date PLANNED_DEPARTURE_DATE_MONTH188490
Planned Departure Date - Quarter Drop Off Stops.Planned Departure Date PLANNED_DEPARTURE_DATE_QUARTER188494
Planned Departure Date - Year Drop Off Stops.Planned Departure Date PLANNED_DEPARTURE_DATE_YEAR188498
Shipments Type Flag Drop Off Stops.Shipments Type FlagSHIPMENTS_TYPE_FLAGSHIPMENTS_TYPE_FLAG272836
Status Code Drop Off Stops.Status CodeSTATUS_CODESTATUS_CODE272834
Stop ID Drop Off Stops.Stop IDSTOP_IDSTOP_ID163687
Stop Location ID Drop Off Stops.Stop Location IDSTOP_LOCATION_IDSTOP_LOCATION_ID163691
Stop Sequence Number Drop Off Stops.Stop Sequence NumberSTOP_SEQUENCE_NUMBERSTOP_SEQUENCE_NUMBER163698
Trip ID Drop Off Stops.Trip IDTRIP_IDTRIP_ID166019
Trip Name Drop Off Stops.Trip NameTRIP_NAMETRIP_NAME166024
Volume UOM Code Drop Off Stops.Volume UOM CodeVOLUME_UOM_CODEVOLUME_UOM_CODE167560
Weight UOM Code Drop Off Stops.Weight UOM CodeWEIGHT_UOM_CODEWEIGHT_UOM_CODE167751
Actual Arrival Date Drop Off Stops.Actual Arrival DateACTUAL_ARRIVAL_DATEACTUAL_ARRIVAL_DATE114847
Actual Arrival Date - Day Drop Off Stops.Actual Arrival Date ACTUAL_ARRIVAL_DATE_DAY168612
Actual Arrival Date - Month Drop Off Stops.Actual Arrival Date ACTUAL_ARRIVAL_DATE_MONTH168616
Actual Arrival Date - Quarter Drop Off Stops.Actual Arrival Date ACTUAL_ARRIVAL_DATE_QUARTER168620
Actual Arrival Date - Year Drop Off Stops.Actual Arrival Date ACTUAL_ARRIVAL_DATE_YEAR168624
Actual Departure Date Drop Off Stops.Actual Departure DateACTUAL_DEPARTURE_DATEACTUAL_DEPARTURE_DATE114867
Actual Departure Date - Day Drop Off Stops.Actual Departure Date ACTUAL_DEPARTURE_DATE_DAY168641
Actual Departure Date - Month Drop Off Stops.Actual Departure Date ACTUAL_DEPARTURE_DATE_MONTH168645
Actual Departure Date - Quarter Drop Off Stops.Actual Departure Date ACTUAL_DEPARTURE_DATE_QUARTER168649
Actual Departure Date - Year Drop Off Stops.Actual Departure Date ACTUAL_DEPARTURE_DATE_YEAR168653
Created By Drop Off Stops.Created ByCREATED_BYCREATED_BY124671
Creation Date Drop Off Stops.Creation DateCREATION_DATECREATION_DATE126097
Departure Fill Percent Drop Off Stops.Departure Fill PercentDEPARTURE_FILL_PERCENTDEPARTURE_FILL_PERCENT129189
Departure Gross Weight Drop Off Stops.Departure Gross WeightDEPARTURE_GROSS_WEIGHTDEPARTURE_GROSS_WEIGHT129191
Departure Net Weight Drop Off Stops.Departure Net WeightDEPARTURE_NET_WEIGHTDEPARTURE_NET_WEIGHT129193
Departure Seal Code Drop Off Stops.Departure Seal CodeDEPARTURE_SEAL_CODEDEPARTURE_SEAL_CODE129195
Departure Volume Drop Off Stops.Departure VolumeDEPARTURE_VOLUMEDEPARTURE_VOLUME129197
Last Update Date Drop Off Stops.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140633
Last Update Login Drop Off Stops.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN141449
Last Updated By Drop Off Stops.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139296
Location DescriptionDescription of the location.Drop Off Stops.Location DescriptionLOCATION_DESCRIPTIONLOCATION_DESCRIPTION145040
Pending Interface Flag Drop Off Stops.Pending Interface FlagPENDING_INTERFACE_FLAGPENDING_INTERFACE_FLAG272835
Planned Arrival Date Drop Off Stops.Planned Arrival DatePLANNED_ARRIVAL_DATEPLANNED_ARRIVAL_DATE154189
Planned Arrival Date - Day Drop Off Stops.Planned Arrival Date PLANNED_ARRIVAL_DATE_DAY188470
Planned Arrival Date - Month Drop Off Stops.Planned Arrival Date PLANNED_ARRIVAL_DATE_MONTH188474
Planned Arrival Date - Quarter Drop Off Stops.Planned Arrival Date PLANNED_ARRIVAL_DATE_QUARTER188478
Planned Arrival Date - Year Drop Off Stops.Planned Arrival Date PLANNED_ARRIVAL_DATE_YEAR188482
Planned Departure Date Drop Off Stops.Planned Departure DatePLANNED_DEPARTURE_DATEPLANNED_DEPARTURE_DATE154194
Planned Departure Date - Day Drop Off Stops.Planned Departure Date PLANNED_DEPARTURE_DATE_DAY188486
Planned Departure Date - Month Drop Off Stops.Planned Departure Date PLANNED_DEPARTURE_DATE_MONTH188490
Planned Departure Date - Quarter Drop Off Stops.Planned Departure Date PLANNED_DEPARTURE_DATE_QUARTER188494
Planned Departure Date - Year Drop Off Stops.Planned Departure Date PLANNED_DEPARTURE_DATE_YEAR188498
Shipments Type Flag Drop Off Stops.Shipments Type FlagSHIPMENTS_TYPE_FLAGSHIPMENTS_TYPE_FLAG272836
Status Code Drop Off Stops.Status CodeSTATUS_CODESTATUS_CODE272834
Stop ID Drop Off Stops.Stop IDSTOP_IDSTOP_ID163687
Stop Location ID Drop Off Stops.Stop Location IDSTOP_LOCATION_IDSTOP_LOCATION_ID163691
Stop Sequence Number Drop Off Stops.Stop Sequence NumberSTOP_SEQUENCE_NUMBERSTOP_SEQUENCE_NUMBER163698
Trip ID Drop Off Stops.Trip IDTRIP_IDTRIP_ID166019
Trip Name Drop Off Stops.Trip NameTRIP_NAMETRIP_NAME166024
Volume UOM Code Drop Off Stops.Volume UOM CodeVOLUME_UOM_CODEVOLUME_UOM_CODE167560
Weight UOM Code Drop Off Stops.Weight UOM CodeWEIGHT_UOM_CODEWEIGHT_UOM_CODE167751
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Drop Off Stops -> Batch Picking InformationDrop Off Stops.Stop ID = Batch Picking Information.Trip Stop IDAlways exist in master folderNoneNo
Drop Off Stops -> Delivery LegsDrop Off Stops.Stop ID = Delivery Legs.Drop Off Stop IDAlways exist in master folderNoneNo
Drop Off Stops -> Freight CostsDrop Off Stops.Stop ID = Freight Costs.Stop IDAlways exist in master folderNoneNo