Powered by InfoCaptor


Previous Page   Next Page

Deliveries
More Folder Details
Dependent FoldersFolder ComponentsTable ComponentsAnalyzed
NoneNone.WSHFG_DELIVERIESUnknown
NoneNone.WSHFG_DELIVERIESUnknown
Folder Items
Item NameItem DescriptionItem Depends OnIt Ext ColumnItem KeyItem Id
Acceptance Flag Deliveries.Acceptance FlagACCEPTANCE_FLAGACCEPTANCE_FLAG272791
Accepted By Deliveries.Accepted ByACCEPTED_BYACCEPTED_BY114042
Accepted Date Deliveries.Accepted DateACCEPTED_DATEACCEPTED_DATE114043
Accepted Date - Day Deliveries.Accepted Date ACCEPTED_DATE_DAY168303
Accepted Date - Month Deliveries.Accepted Date ACCEPTED_DATE_MONTH168305
Accepted Date - Quarter Deliveries.Accepted Date ACCEPTED_DATE_QUARTER168307
Accepted Date - Year Deliveries.Accepted Date ACCEPTED_DATE_YEAR168309
Acknowledged By Deliveries.Acknowledged ByACKNOWLEDGED_BYACKNOWLEDGED_BY114471
Additional Shipment Information Deliveries.Additional Shipment InformationADDITIONAL_SHIPMENT_INFOADDITIONAL_SHIPMENT_INFO114990
Advance Shipment Notice Date Sent Deliveries.Advance Shipment Notice Date SentASN_DATE_SENTASN_DATE_SENT116504
Advance Shipment Notice Date Sent - Day Deliveries.Advance Shipment Notice Date Sent ASN_DATE_SENT_DAY169267
Advance Shipment Notice Date Sent - Month Deliveries.Advance Shipment Notice Date Sent ASN_DATE_SENT_MONTH169269
Advance Shipment Notice Date Sent - Quarter Deliveries.Advance Shipment Notice Date Sent ASN_DATE_SENT_QUARTER169271
Advance Shipment Notice Date Sent - Year Deliveries.Advance Shipment Notice Date Sent ASN_DATE_SENT_YEAR169273
Advance Shipment Notice Seq Number Deliveries.Advance Shipment Notice Seq NumberASN_SEQ_NUMBERASN_SEQ_NUMBER116509
Bill Freight To Deliveries.Bill Freight ToBILL_FREIGHT_TOBILL_FREIGHT_TO119826
Booking Number Deliveries.Booking NumberBOOKING_NUMBERBOOKING_NUMBER120159
Carried By Deliveries.Carried ByCARRIED_BYCARRIED_BY121563
Carrier ID Deliveries.Carrier IDCARRIER_IDCARRIER_ID121596
Cash On Delivery Amount Deliveries.Cash On Delivery AmountCOD_AMOUNTCOD_AMOUNT122423
Cash On Delivery Charge Paid By Deliveries.Cash On Delivery Charge Paid ByCOD_CHARGE_PAID_BYCOD_CHARGE_PAID_BY122426
Cash On Delivery Currency Code Deliveries.Cash On Delivery Currency CodeCOD_CURRENCY_CODECOD_CURRENCY_CODE122429
Cash On Delivery Remit To Deliveries.Cash On Delivery Remit ToCOD_REMIT_TOCOD_REMIT_TO122432
Confirm Date Deliveries.Confirm DateCONFIRM_DATECONFIRM_DATE123102
Confirm Date - Day Deliveries.Confirm Date CONFIRM_DATE_DAY170906
Confirm Date - Month Deliveries.Confirm Date CONFIRM_DATE_MONTH170908
Confirm Date - Quarter Deliveries.Confirm Date CONFIRM_DATE_QUARTER170910
Confirm Date - Year Deliveries.Confirm Date CONFIRM_DATE_YEAR170912
Confirmed By Deliveries.Confirmed ByCONFIRMED_BYCONFIRMED_BY123085
Context Value Deliveries.Context ValueDELIVERY_CONTEXT_VALUEDELIVERY_CONTEXT_VALUE272794
Context Value 1 Deliveries.Context Value 1GLOBAL_CONTEXT_VALUEGLOBAL_CONTEXT_VALUE272797
Created By Deliveries.Created ByCREATED_BYCREATED_BY124667
Creation Date Deliveries.Creation DateCREATION_DATECREATION_DATE126093
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Deliveries.Currency CodeCURRENCY_CODECURRENCY_CODE127017
Customer Broker Deliveries.Customer BrokerDELIVERY_CUSTOMER_BROKERDELIVERY_CUSTOMER_BROKER272796
Customer IDUnique identifier for this customer.Deliveries.Customer IDCUSTOMER_IDCUSTOMER_ID127629
Customer Name Deliveries.Customer NameCUSTOMER_NAMECUSTOMER_NAME127678
Customer Number Deliveries.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127719
Delivery ID Deliveries.Delivery IDDELIVERY_IDDELIVERY_ID128964
Delivery Type Deliveries.Delivery TypeDELIVERY_TYPEDELIVERY_TYPE128982
DescriptionThe accounting period description.Deliveries.DescriptionDESCRIPTIONDESCRIPTION129598
Dock Code Deliveries.Dock CodeDOCK_CODEDOCK_CODE130315
Fob Code Deliveries.Fob CodeFOB_CODEFOB_CODE272793
Freight On Board Location Deliveries.Freight On Board LocationFOB_LOCATIONFOB_LOCATION134459
Freight On Board Location ID Deliveries.Freight On Board Location IDFOB_LOCATION_IDFOB_LOCATION_ID134460
Freight Terms Code Deliveries.Freight Terms CodeFREIGHT_TERMS_CODEFREIGHT_TERMS_CODE134686
Gross Weight Deliveries.Gross WeightGROSS_WEIGHTGROSS_WEIGHT135502
Initial Pickup Date Deliveries.Initial Pickup DateINITIAL_PICKUP_DATEINITIAL_PICKUP_DATE136897
Initial Pickup Date - Day Deliveries.Initial Pickup Date INITIAL_PICKUP_DATE_DAY181495
Initial Pickup Date - Month Deliveries.Initial Pickup Date INITIAL_PICKUP_DATE_MONTH181497
Initial Pickup Date - Quarter Deliveries.Initial Pickup Date INITIAL_PICKUP_DATE_QUARTER181499
Initial Pickup Date - Year Deliveries.Initial Pickup Date INITIAL_PICKUP_DATE_YEAR181501
Initial Pickup Location Deliveries.Initial Pickup LocationINIT_PICKUP_LOCATIONINIT_PICKUP_LOCATION136902
Initial Pickup Location ID Deliveries.Initial Pickup Location IDINITIAL_PICKUP_LOCATION_IDINITIAL_PICKUP_LOCATION_ID136898
Intermediate Ship To Description Deliveries.Intermediate Ship To DescriptionINTMED_SHIP_TO_DESCRIPTIONINTMED_SHIP_TO_DESCRIPTION137121
Intermediate Ship To Location ID Deliveries.Intermediate Ship To Location IDINTMED_SHIP_TO_LOCATION_IDINTMED_SHIP_TO_LOCATION_ID137124
Last Update Date Deliveries.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140629
Last Update Login Deliveries.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN141447
Last Updated By Deliveries.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139292
Loading Order Flag Deliveries.Loading Order FlagLOADING_ORDER_FLAGLOADING_ORDER_FLAG144910
Loading Sequence Deliveries.Loading SequenceLOADING_SEQUENCELOADING_SEQUENCE144912
NameName of the resource.Deliveries.NameNAMENAME147728
Net Weight Deliveries.Net WeightNET_WEIGHTNET_WEIGHT148019
Number Of License Place Number Deliveries.Number Of License Place NumberNUMBER_OF_LPNNUMBER_OF_LPN148716
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Deliveries.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150066
Organization ID Deliveries.Organization IDORGANIZATION_IDORGANIZATION_ID150321
Organization Name Deliveries.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150620
Pallet Count Deliveries.Pallet CountDELIVERY_PALLET_COUNTDELIVERY_PALLET_COUNT272795
Planned Flag Deliveries.Planned FlagPLANNED_FLAGPLANNED_FLAG272790
Pooled Ship To Description Deliveries.Pooled Ship To DescriptionPOOLED_SHIP_TO_DESCRIPTIONPOOLED_SHIP_TO_DESCRIPTION154712
Pooled Ship To Location ID Deliveries.Pooled Ship To Location IDPOOLED_SHIP_TO_LOCATION_IDPOOLED_SHIP_TO_LOCATION_ID154713
Port Of Discharge Deliveries.Port Of DischargePORT_OF_DISCHARGEPORT_OF_DISCHARGE154739
Port Of Loading Deliveries.Port Of LoadingPORT_OF_LOADINGPORT_OF_LOADING154742
Problem Contact Reference Deliveries.Problem Contact ReferencePROBLEM_CONTACT_REFERENCEPROBLEM_CONTACT_REFERENCE155762
Reason Of Transport Deliveries.Reason Of TransportREASON_OF_TRANSPORTREASON_OF_TRANSPORT157963
Service Contract Deliveries.Service ContractSERVICE_CONTRACTSERVICE_CONTRACT161400
Ship Method Code Deliveries.Ship Method CodeSHIP_METHOD_CODESHIP_METHOD_CODE272792
Status Code Deliveries.Status CodeSTATUS_CODESTATUS_CODE272789
Ultimate Dropoff Date Deliveries.Ultimate Dropoff DateULTIMATE_DROPOFF_DATEULTIMATE_DROPOFF_DATE166203
Ultimate Dropoff Date - Day Deliveries.Ultimate Dropoff Date ULTIMATE_DROPOFF_DATE_DAY192643
Ultimate Dropoff Date - Month Deliveries.Ultimate Dropoff Date ULTIMATE_DROPOFF_DATE_MONTH192645
Ultimate Dropoff Date - Quarter Deliveries.Ultimate Dropoff Date ULTIMATE_DROPOFF_DATE_QUARTER192647
Ultimate Dropoff Date - Year Deliveries.Ultimate Dropoff Date ULTIMATE_DROPOFF_DATE_YEAR192649
Ultimate Dropoff Description Deliveries.Ultimate Dropoff DescriptionULTIMATE_DROPOFF_DESCRIPTIONULTIMATE_DROPOFF_DESCRIPTION166204
Ultimate Dropoff Location ID Deliveries.Ultimate Dropoff Location IDULTIMATE_DROPOFF_LOCATION_IDULTIMATE_DROPOFF_LOCATION_ID166205
Volume Deliveries.VolumeVOLUMEVOLUME167548
Volume Number Deliveries.Volume NumberGLOBAL_VOLUME_NUMBER_2GLOBAL_VOLUME_NUMBER_2272799
Volume Quantity Deliveries.Volume QuantityGLOBAL_VOLUME_QUANTITY_2GLOBAL_VOLUME_QUANTITY_2272800
Volume Type Deliveries.Volume TypeGLOBAL_VOLUME_TYPE_2GLOBAL_VOLUME_TYPE_2272798
Volume UOM Code Deliveries.Volume UOM CodeVOLUME_UOM_CODEVOLUME_UOM_CODE167557
Waybill Deliveries.WaybillWAYBILLWAYBILL167718
Weight UOM Code Deliveries.Weight UOM CodeWEIGHT_UOM_CODEWEIGHT_UOM_CODE167748
Acceptance Flag Deliveries.Acceptance FlagACCEPTANCE_FLAGACCEPTANCE_FLAG272791
Accepted By Deliveries.Accepted ByACCEPTED_BYACCEPTED_BY114042
Accepted Date Deliveries.Accepted DateACCEPTED_DATEACCEPTED_DATE114043
Accepted Date - Day Deliveries.Accepted Date ACCEPTED_DATE_DAY168303
Accepted Date - Month Deliveries.Accepted Date ACCEPTED_DATE_MONTH168305
Accepted Date - Quarter Deliveries.Accepted Date ACCEPTED_DATE_QUARTER168307
Accepted Date - Year Deliveries.Accepted Date ACCEPTED_DATE_YEAR168309
Acknowledged By Deliveries.Acknowledged ByACKNOWLEDGED_BYACKNOWLEDGED_BY114471
Additional Shipment Information Deliveries.Additional Shipment InformationADDITIONAL_SHIPMENT_INFOADDITIONAL_SHIPMENT_INFO114990
Advance Shipment Notice Date Sent Deliveries.Advance Shipment Notice Date SentASN_DATE_SENTASN_DATE_SENT116504
Advance Shipment Notice Date Sent - Day Deliveries.Advance Shipment Notice Date Sent ASN_DATE_SENT_DAY169267
Advance Shipment Notice Date Sent - Month Deliveries.Advance Shipment Notice Date Sent ASN_DATE_SENT_MONTH169269
Advance Shipment Notice Date Sent - Quarter Deliveries.Advance Shipment Notice Date Sent ASN_DATE_SENT_QUARTER169271
Advance Shipment Notice Date Sent - Year Deliveries.Advance Shipment Notice Date Sent ASN_DATE_SENT_YEAR169273
Advance Shipment Notice Seq Number Deliveries.Advance Shipment Notice Seq NumberASN_SEQ_NUMBERASN_SEQ_NUMBER116509
Bill Freight To Deliveries.Bill Freight ToBILL_FREIGHT_TOBILL_FREIGHT_TO119826
Booking Number Deliveries.Booking NumberBOOKING_NUMBERBOOKING_NUMBER120159
Carried By Deliveries.Carried ByCARRIED_BYCARRIED_BY121563
Carrier ID Deliveries.Carrier IDCARRIER_IDCARRIER_ID121596
Cash On Delivery Amount Deliveries.Cash On Delivery AmountCOD_AMOUNTCOD_AMOUNT122423
Cash On Delivery Charge Paid By Deliveries.Cash On Delivery Charge Paid ByCOD_CHARGE_PAID_BYCOD_CHARGE_PAID_BY122426
Cash On Delivery Currency Code Deliveries.Cash On Delivery Currency CodeCOD_CURRENCY_CODECOD_CURRENCY_CODE122429
Cash On Delivery Remit To Deliveries.Cash On Delivery Remit ToCOD_REMIT_TOCOD_REMIT_TO122432
Confirm Date Deliveries.Confirm DateCONFIRM_DATECONFIRM_DATE123102
Confirm Date - Day Deliveries.Confirm Date CONFIRM_DATE_DAY170906
Confirm Date - Month Deliveries.Confirm Date CONFIRM_DATE_MONTH170908
Confirm Date - Quarter Deliveries.Confirm Date CONFIRM_DATE_QUARTER170910
Confirm Date - Year Deliveries.Confirm Date CONFIRM_DATE_YEAR170912
Confirmed By Deliveries.Confirmed ByCONFIRMED_BYCONFIRMED_BY123085
Context Value Deliveries.Context ValueDELIVERY_CONTEXT_VALUEDELIVERY_CONTEXT_VALUE272794
Context Value 1 Deliveries.Context Value 1GLOBAL_CONTEXT_VALUEGLOBAL_CONTEXT_VALUE272797
Created By Deliveries.Created ByCREATED_BYCREATED_BY124667
Creation Date Deliveries.Creation DateCREATION_DATECREATION_DATE126093
Currency CodeCurrency code for pricelist; FK to gl_curr_mst.Deliveries.Currency CodeCURRENCY_CODECURRENCY_CODE127017
Customer Broker Deliveries.Customer BrokerDELIVERY_CUSTOMER_BROKERDELIVERY_CUSTOMER_BROKER272796
Customer IDUnique identifier for this customer.Deliveries.Customer IDCUSTOMER_IDCUSTOMER_ID127629
Customer Name Deliveries.Customer NameCUSTOMER_NAMECUSTOMER_NAME127678
Customer Number Deliveries.Customer NumberCUSTOMER_NUMBERCUSTOMER_NUMBER127719
Delivery ID Deliveries.Delivery IDDELIVERY_IDDELIVERY_ID128964
Delivery Type Deliveries.Delivery TypeDELIVERY_TYPEDELIVERY_TYPE128982
DescriptionThe accounting period description.Deliveries.DescriptionDESCRIPTIONDESCRIPTION129598
Dock Code Deliveries.Dock CodeDOCK_CODEDOCK_CODE130315
Fob Code Deliveries.Fob CodeFOB_CODEFOB_CODE272793
Freight On Board Location Deliveries.Freight On Board LocationFOB_LOCATIONFOB_LOCATION134459
Freight On Board Location ID Deliveries.Freight On Board Location IDFOB_LOCATION_IDFOB_LOCATION_ID134460
Freight Terms Code Deliveries.Freight Terms CodeFREIGHT_TERMS_CODEFREIGHT_TERMS_CODE134686
Gross Weight Deliveries.Gross WeightGROSS_WEIGHTGROSS_WEIGHT135502
Initial Pickup Date Deliveries.Initial Pickup DateINITIAL_PICKUP_DATEINITIAL_PICKUP_DATE136897
Initial Pickup Date - Day Deliveries.Initial Pickup Date INITIAL_PICKUP_DATE_DAY181495
Initial Pickup Date - Month Deliveries.Initial Pickup Date INITIAL_PICKUP_DATE_MONTH181497
Initial Pickup Date - Quarter Deliveries.Initial Pickup Date INITIAL_PICKUP_DATE_QUARTER181499
Initial Pickup Date - Year Deliveries.Initial Pickup Date INITIAL_PICKUP_DATE_YEAR181501
Initial Pickup Location Deliveries.Initial Pickup LocationINIT_PICKUP_LOCATIONINIT_PICKUP_LOCATION136902
Initial Pickup Location ID Deliveries.Initial Pickup Location IDINITIAL_PICKUP_LOCATION_IDINITIAL_PICKUP_LOCATION_ID136898
Intermediate Ship To Description Deliveries.Intermediate Ship To DescriptionINTMED_SHIP_TO_DESCRIPTIONINTMED_SHIP_TO_DESCRIPTION137121
Intermediate Ship To Location ID Deliveries.Intermediate Ship To Location IDINTMED_SHIP_TO_LOCATION_IDINTMED_SHIP_TO_LOCATION_ID137124
Last Update Date Deliveries.Last Update DateLAST_UPDATE_DATELAST_UPDATE_DATE140629
Last Update Login Deliveries.Last Update LoginLAST_UPDATE_LOGINLAST_UPDATE_LOGIN141447
Last Updated By Deliveries.Last Updated ByLAST_UPDATED_BYLAST_UPDATED_BY139292
Loading Order Flag Deliveries.Loading Order FlagLOADING_ORDER_FLAGLOADING_ORDER_FLAG144910
Loading Sequence Deliveries.Loading SequenceLOADING_SEQUENCELOADING_SEQUENCE144912
NameName of the resource.Deliveries.NameNAMENAME147728
Net Weight Deliveries.Net WeightNET_WEIGHTNET_WEIGHT148019
Number Of License Place Number Deliveries.Number Of License Place NumberNUMBER_OF_LPNNUMBER_OF_LPN148716
Organization CodeThe organization which can use the formula/routing. This is blank if all organizations can use the formula/routing.Deliveries.Organization CodeORGANIZATION_CODEORGANIZATION_CODE150066
Organization ID Deliveries.Organization IDORGANIZATION_IDORGANIZATION_ID150321
Organization Name Deliveries.Organization NameORGANIZATION_NAMEORGANIZATION_NAME150620
Pallet Count Deliveries.Pallet CountDELIVERY_PALLET_COUNTDELIVERY_PALLET_COUNT272795
Planned Flag Deliveries.Planned FlagPLANNED_FLAGPLANNED_FLAG272790
Pooled Ship To Description Deliveries.Pooled Ship To DescriptionPOOLED_SHIP_TO_DESCRIPTIONPOOLED_SHIP_TO_DESCRIPTION154712
Pooled Ship To Location ID Deliveries.Pooled Ship To Location IDPOOLED_SHIP_TO_LOCATION_IDPOOLED_SHIP_TO_LOCATION_ID154713
Port Of Discharge Deliveries.Port Of DischargePORT_OF_DISCHARGEPORT_OF_DISCHARGE154739
Port Of Loading Deliveries.Port Of LoadingPORT_OF_LOADINGPORT_OF_LOADING154742
Problem Contact Reference Deliveries.Problem Contact ReferencePROBLEM_CONTACT_REFERENCEPROBLEM_CONTACT_REFERENCE155762
Reason Of Transport Deliveries.Reason Of TransportREASON_OF_TRANSPORTREASON_OF_TRANSPORT157963
Service Contract Deliveries.Service ContractSERVICE_CONTRACTSERVICE_CONTRACT161400
Ship Method Code Deliveries.Ship Method CodeSHIP_METHOD_CODESHIP_METHOD_CODE272792
Status Code Deliveries.Status CodeSTATUS_CODESTATUS_CODE272789
Ultimate Dropoff Date Deliveries.Ultimate Dropoff DateULTIMATE_DROPOFF_DATEULTIMATE_DROPOFF_DATE166203
Ultimate Dropoff Date - Day Deliveries.Ultimate Dropoff Date ULTIMATE_DROPOFF_DATE_DAY192643
Ultimate Dropoff Date - Month Deliveries.Ultimate Dropoff Date ULTIMATE_DROPOFF_DATE_MONTH192645
Ultimate Dropoff Date - Quarter Deliveries.Ultimate Dropoff Date ULTIMATE_DROPOFF_DATE_QUARTER192647
Ultimate Dropoff Date - Year Deliveries.Ultimate Dropoff Date ULTIMATE_DROPOFF_DATE_YEAR192649
Ultimate Dropoff Description Deliveries.Ultimate Dropoff DescriptionULTIMATE_DROPOFF_DESCRIPTIONULTIMATE_DROPOFF_DESCRIPTION166204
Ultimate Dropoff Location ID Deliveries.Ultimate Dropoff Location IDULTIMATE_DROPOFF_LOCATION_IDULTIMATE_DROPOFF_LOCATION_ID166205
Volume Deliveries.VolumeVOLUMEVOLUME167548
Volume Number Deliveries.Volume NumberGLOBAL_VOLUME_NUMBER_2GLOBAL_VOLUME_NUMBER_2272799
Volume Quantity Deliveries.Volume QuantityGLOBAL_VOLUME_QUANTITY_2GLOBAL_VOLUME_QUANTITY_2272800
Volume Type Deliveries.Volume TypeGLOBAL_VOLUME_TYPE_2GLOBAL_VOLUME_TYPE_2272798
Volume UOM Code Deliveries.Volume UOM CodeVOLUME_UOM_CODEVOLUME_UOM_CODE167557
Waybill Deliveries.WaybillWAYBILLWAYBILL167718
Weight UOM Code Deliveries.Weight UOM CodeWEIGHT_UOM_CODEWEIGHT_UOM_CODE167748
Folder Joins
Join NameJoin ConditionJoin DetailsOptional Join ConfigurationAuto
Deliveries -> Batch Picking InformationDeliveries.Delivery ID = Batch Picking Information.Delivery IDAlways exist in master folderNoneNo
Deliveries -> Delivery AssignmentsDeliveries.Delivery ID = Delivery Assignments.Delivery IDAlways exist in master folderNoneNo
Deliveries -> Delivery LegsDeliveries.Delivery ID = Delivery Legs.Delivery IDAlways exist in master folderNoneNo
Deliveries -> Freight CostsDeliveries.Delivery ID = Freight Costs.Delivery IDAlways exist in master folderNoneNo