WHSLoadTable Table
This table holds the loads.
Configuration Key: WHSandTMS
Methods
Method | Description | |
---|---|---|
addInboundTransferLineToShipment | Adds an inbound transfer line to the shipment to create a new shipment for the transfer line. | |
addOutboundTransferLineToShipment | Adds an outbound transfer line to a shipment or creates a new shipment for the line. | |
addPurchLineToShipment | Adds a purchase line to a shipment or creates a new shipment for the purchase line. | |
addSalesLineToShipment | Adds a sales line to a shipment or creates a new shipment for the sales line. | |
aosValidateDelete | Validates on the server that the specified record can be deleted from a table. (Inherited from xRecord.) | |
aosValidateInsert | Validates on the server that the specified record can be inserted. (Inherited from xRecord.) | |
aosValidateRead | Validates on the server that the specified record can be read. (Inherited from xRecord.) | |
aosValidateUpdate | Validates on the server that the specified record can be updated. (Inherited from xRecord.) | |
assignCarrierOnOrigin_Purch | Assign Carrier information based on the TMSPurchTable record. | |
assignCarrierOnOrigin_Sales | Assign the Carrier information based on the SalesLine record. | |
assignCarrierOnOrigin_Transfer | Assign the Carrier information based on the TMSInventTransferTable record. | |
assignEarliestSchedShipDateTime | Assign a scheduled ship date and time if the specified ship date and time is earlier than the current scheduled ship date and time on the current load. | |
assignInventDim | Assign Warehouse dimensions based on the InventDim record. | |
assignLoadWeights | Assign the aggregated weight on the load based on a change in inventory quantity on a load line. | |
assignOriginInfo | Assign the origin information on the load header. | |
assignTransTemplate | Assign the transportation template Id on the load based on related source document. | |
buf2con | Packs the table buffers of an xRecord instance into an X++ container. (Inherited from xRecord.) | |
cancelTimeOut | Cancels a previous method call to the setTimeOut method. (Inherited from Object.) | |
canShipConfirm | Checks if load can be ship confirmed | |
canSubmitToWorkflow | Indicates whether submission to workflow is possible. (Inherited from xRecord.) | |
caption | Gets and sets the caption property of a table. (Inherited from xRecord.) | |
changeCarrierOnPurch | Updates the purchase order data with the carrier referred by the current instance of WHSLoadTable buffer. | |
changeCarrierOnSales | Updates the sales order data with the carrier referred by the current instance of WHSLoadTable buffer. | |
changeCarrierOnTransfer | Updates the transfer order data with the carrier referred by the current instance of WHSLoadTable buffer. | |
changeRouteConfigCodeOnOrigin | Updates the order data with the route plan referred by the current instance of WHSLoadTable buffer. | |
changeRouteConfigCodeOnPurch | Updates the purchase order data with the route plan referred by the current instance of WHSLoadTable buffer. | |
changeRouteConfigCodeOnSales | Updates the sales order data with the route plan referred by the current instance of WHSLoadTable buffer. | |
checkCarrierServiceLoadTemplate | ||
checkInvalidFieldAccess | Gets and sets invalid field access. (Inherited from xRecord.) | |
checkRecord | Gets and sets the property that indicates whether to check mandatory fields. (Inherited from xRecord.) | |
checkRestrictedDeleteActions | Gets and sets the property that indicates whether a record can be deleted. (Inherited from xRecord.) | |
clear | Removes all rows from the table buffer. (Inherited from xRecord.) | |
commonPurchAccountTable | Retrieves a purchase order which represents common purchase order information across all load lines. | |
commonSalesAccountTable | Retrieves a sales order which represents common sales order information across all load lines. | |
company | Gets and sets the property that indicates a legal entity for the record. (Inherited from xRecord.) | |
con2buf | Unpacks a container into the table buffers. (Inherited from xRecord.) | |
concurrencyModel | Gets and sets the default concurrency model to use to update records. (Inherited from xRecord.) | |
context | Gets and sets the context property. (Inherited from xRecord.) | |
countNonCancelledWork | ||
data | Retrieves a row from the table. (Inherited from xRecord.) | |
dataSource | Retrieves the data source of the table. (Inherited from xRecord.) | |
defaultField | Populates default values in a field in the table. (Inherited from xRecord.) | |
defaultRow | Populates default values in fields in the table in the non-interactive case. (Inherited from xRecord.) | |
delete | Deletes the current record from the database. | |
destinationAddress | Gets a TMSAddressPhone object to be used when passing address information | |
disableCache | Gets and sets the property that indicates whether caching is disabled. (Inherited from xRecord.) | |
displayAccountName | ||
displayActualWeightRemaining | Method to display the actual weight remaining of a load. | |
displayContainerSize | ||
displayCurrentWave | ||
displayDropOffLoc | Display the address of the drop off location. | |
displayHasUnreservedQty | Displays an image if the load line quantity is not on hand physically reserved. | |
displayLoadCapacityPercent | ||
displayLoadLines | ||
displayLoadNotes | Creates a concatenated string of external notes associated with the current record and of the load note type specified in the TMSParameters | |
displayNumberOfContainers | Display the number of containers in current load. | |
displayNumberOfShipments | ||
displayPickUpLoc | Display the address of the pick up location. | |
displayShipment | Displays the shipment that is tied to a load. | |
displayStagedWork | Displays an image if all the work that is tied to a load is staged. | |
displayTotalAmount | Method to display total amount of a load. | |
displayTotalMiles | ||
displayTotalPieceCount | ||
displayTotalValue | Displays the total value of a load. | |
displayTotalVolume | Displays the total volume of a load. | |
displayTotalWeight | Displays the total weight of a load. | |
displayVolumeRemaining | Displays the volume remained on the load | |
displayWave | Displays the wave that is tied to a load. | |
displayWeightRemaining | ||
displayWorkStatus | Method to display work status of a load. | |
dispose | Releases resources that are used by the xRecord object. (Inherited from xRecord.) | |
doClear | Removes all rows from the table buffer and bypasses any additional logic in the clear method of the table. (Inherited from xRecord.) | |
doDelete | Deletes the current record from the table and bypasses any additional logic in the delete method of the table. (Inherited from xRecord.) | |
doInsert | Inserts the record into the table and bypasses any additional logic in the insert method of the table. (Inherited from xRecord.) | |
doUpdate | Updates the current record and bypasses any additional logic in the update method of the table. (Inherited from xRecord.) | |
doValidateDelete | Performs the action to validate that a record can be deleted. (Inherited from xRecord.) | |
equal | Determines whether the specified object is equal to the current one. (Inherited from xRecord.) | |
fieldAccessRight | Returns the field access right. (Inherited from xRecord.) | |
fieldBufferAccessRight | Returns the field access right for the current record. (Inherited from xRecord.) | |
fieldState | Sets or returns the state of a field in the table buffer. (Inherited from xRecord.) | |
findStatus | ||
getAllowRedefault | Returns the list of fields that are allowed to re-default. (Inherited from xRecord.) | |
getDefaultingDependencies | Returns the container that holds defaulting dependencies. (Inherited from xRecord.) | |
getExtension | Returns the table extension. (Inherited from xRecord.) | |
getFieldValue | Gets the value of the specified field from a table buffer. (Inherited from xRecord.) | |
getFinalLoc | Gets the final location of a load. | |
getInstanceRelationType | Returns the table name that corresponds to the InstanceRelationType ID. (Inherited from xRecord.) | |
getLoadTemplate | ||
getPhysicalTableName | Return the physical table name, which, in the case of the SQL Temp DB table, is the table instance name. (Inherited from xRecord.) | |
getPresenceFieldData | Retrieves the PresenceInfo value from the specified field. (Inherited from xRecord.) | |
getSQLStatement | Gets the SQL statement that is used to return records from the database. (Inherited from xRecord.) | |
getStagingLoc | Gets the staging location ofa load. | |
getTableInInstanceHierarchy | (Inherited from xRecord.) | |
getTableType | Indicates the type of the table. (Inherited from xRecord.) | |
getTimeOutTimerHandle | Returns the timer handle for the object. (Inherited from Object.) | |
handle | Retrieves the handle of the class of the object. (Inherited from Object.) | |
hasPacking | ||
hasRelatedTable | Indicates whether a foreign key constraint buffer is linked with the table. (Inherited from xRecord.) | |
hasWork | ||
helpField | Retrieves a string that contains the Help text for the specified field. (Inherited from xRecord.) | |
imageIdx | ||
initDestinationAddress | Sets the destination address reference information | |
initFromItem | ||
initFromLoadTemplateId | ||
initOriginAddress | Establishes origin address information | |
initPurchOriginDestination | Initializes origin and destination address information based on a purchase order and purchase order line. | |
initSalesOriginDestination | Initializes origin and destination address information based on a sales order and sales order line. | |
initTransferOriginDestination | Initializes origin and destination address information based on a transfer order. | |
initTransportRequestOriginDestination | Initializes origin and destination address information based on a transport request. | |
initValue | Initializes a field to the default value. (Inherited from xRecord.) | |
inputStatus | Sets or returns the current input status of the table buffer. (Inherited from xRecord.) | |
insert | Inserts the record into the table. (Inherited from xRecord.) | |
interactiveContext | Sets or returns the current interactive context of the table buffer. (Inherited from xRecord.) | |
isFieldDataRetrieved | Checks whether the data of the given field has been retrieved. (Inherited from xRecord.) | |
isFieldSet | Checks whether a field has a Set or Defaulted state. (Inherited from xRecord.) | |
isFormDataSource | Indicates whether the data source is a form. (Inherited from xRecord.) | |
isLoadShipped | Validate the shipped status of the load. | |
isNewRecord | Returns true if the record is a new record that hasn't been persisted yet. (Inherited from xRecord.) | |
isPartOfUOWSaveChanges | (Inherited from xRecord.) | |
isTempDb | Indicates whether the type of the table is SQL TempDB. (Inherited from xRecord.) | |
isTmp | Indicates whether this is a temporary table. (Inherited from xRecord.) | |
isTransportRequest | ||
joinChild | Finds the join child of the current record. (Inherited from xRecord.) | |
joinParent | Finds the join parent of the current record. (Inherited from xRecord.) | |
linkPhysicalTableInstance | Checks whether there is a link for the physical table instance for the record. (Inherited from xRecord.) | |
loadArrivalDate | Calculates the arrival date only from the arrival date and time. | |
loadSchedShipDate | Calculates the scheduled shipping date only from the scheduled shipping date and time. | |
merge | Merges the current table with the specified table. (Inherited from xRecord.) | |
modifiedField | ||
modifiedFieldValue | ||
new | Initializes a new instance of the Object class. (Inherited from Object.) | |
notify | Releases the hold on an object that has called the wait method on this object. (Inherited from Object.) | |
notifyAll | Releases a lock on the object that was issued by the wait method on this object. (Inherited from Object.) | |
objectOnServer | Determines whether the object is on a server. (Inherited from Object.) | |
orig | Retrieves the original values of the current record. (Inherited from xRecord.) | |
originAddress | Establishes object to return address information | |
overwriteSystemfields | Gets and sets the property that indicates whether system fields can be overwritten. (Inherited from xRecord.) | |
owner | Returns the instance that owns the object. (Inherited from Object.) | |
postCacheLoad | Is executed after data is hit from the cache for the select operation on the table. (Inherited from xRecord.) | |
postLoad | Is executed after a record is read. (Inherited from xRecord.) | |
preRemoting | Is executed before a cross-tier call is about to be executed for the table that would pack its state to the other tier. (Inherited from xRecord.) | |
queryTimedOut | Indicates whether the query exceeded the time limit for execution. (Inherited from xRecord.) | |
queryTimeout | Gets and sets the property that indicates the time limit for the execution of a query. (Inherited from xRecord.) | |
readCommittedLock | (Inherited from xRecord.) | |
readPast | Gets and sets the property that indicates whether to skip rows that are locked by other processes when a record is read. (Inherited from xRecord.) | |
recordLevelSecurity | Gets and sets the property that indicates whether to apply security on a record level. (Inherited from xRecord.) | |
relatedTable | Sets or returns the related buffer of a link of a table buffer. (Inherited from xRecord.) | |
renamePrimaryKey | Renames the foreign keys in other tables according to the change of the corresponding primary key value in this table. (Inherited from xRecord.) | |
reread | Rereads the record from the table. (Inherited from xRecord.) | |
RowCount | Retrieves the number of rows in the table. (Inherited from xRecord.) | |
selectForUpdate | Gets and sets the property that indicates whether to select records for update when they are read. (Inherited from xRecord.) | |
selectLocked | Indicates whether to select locked records. (Inherited from xRecord.) | |
selectRefRecord | Selects the record by referenced field ID. (Inherited from xRecord.) | |
selectWithRepeatableRead | Gets and sets the property that indicates whether repeatable read is enabled. (Inherited from xRecord.) | |
setConnection | Sets the user connection for this table. (Inherited from xRecord.) | |
setCrossPartition | Sets or resets cross-partitioning for the table. (Inherited from xRecord.) | |
setFieldValue | Sets the field value in the record buffer. (Inherited from xRecord.) | |
setLoadId | ||
setSQLTracing | Enables or disables SQL tracing mode. (Inherited from xRecord.) | |
setTimeOut | Sets up the scheduled execution of a specified method. (Inherited from Object.) | |
setTmp | Sets the table so that it is not persisted to the database. (Inherited from xRecord.) | |
setTmpData | Sets the contents of the temporary table to the specified data. (Inherited from xRecord.) | |
setXDSContext | Sets new XDS context. (Inherited from xRecord.) | |
skipAosValidation | Gets and sets the property that indicates whether to skip validation of Microsoft Dynamics AX Application Object Server (AOS). (Inherited from xRecord.) | |
skipDatabaseLog | Gets and sets the property that indicates whether to skip database log requests. (Inherited from xRecord.) | |
skipDataMethods | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) | |
skipDeleteActions | Gets and sets the property that indicates whether to skip delete actions on the table. (Inherited from xRecord.) | |
skipDeleteMethod | Gets and sets the property that indicates whether to discard overloaded methods. (Inherited from xRecord.) | |
skipEvents | Provides an option to turn off calling the Application.event* methods for the lifetime of an xRecord object. (Inherited from xRecord.) | |
skipPostLoad | Gets and sets the property that indicates whether to skip executing the xRecord.postLoad method on the table. (Inherited from xRecord.) | |
skipTTSCheck | Gets and sets the property that indicates whether to skip the check to determine whether the record is selected for update. (Inherited from xRecord.) | |
skipWorkLines | Updates open work lines to skipped where the work lines are associated with the current load. | |
suppressWarnings | Gets and sets the property that indicates whether to suppress warnings for this pointer. (Inherited from xRecord.) | |
tableAccessRight | Returns the table access right. (Inherited from xRecord.) | |
tableBufferAccessRight | Returns the table access right for the current record. (Inherited from xRecord.) | |
takeOwnershipOfTempDBTable | (Inherited from xRecord.) | |
timeZoneSite | Retrieves the time zone associated with the site on the current load. | |
tmsCancelAppointment | ||
tmsChangeBrokerOnAppt | ||
tmsChangeBrokerOnSales | ||
tmsChangeBrokerOnShipments | ||
tmsChangeCarrierOnAppt | ||
tmsChangeCarrierOnOrigin | ||
tmsChangeCarrierServiceOnShipments | ||
tmsChangeModeOnOrigin | ||
tmsDisplayAppointmentId | ||
tmsDisplayEquipmentCode | ||
tmsDisplayRouteCode | ||
toolTipField | Retrieves the HelpText value for the specified field. (Inherited from xRecord.) | |
toolTipRecord | Retrieves the ToolTip value for the current record. (Inherited from xRecord.) | |
toString | Returns a string that represents the current object. (Inherited from Object.) | |
ttsabort | Aborts a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) | |
ttsbegin | Starts a transaction that can be either committed by the ttscommit method or aborted by the ttsabort method. (Inherited from xRecord.) | |
ttscommit | Commits a transaction that was started by a call to the ttsbegin method. (Inherited from xRecord.) | |
update | Updates the current record in the database. | |
updateActualTareWeight | ||
updateLoadTareWeight | ||
usageCount | Retrieves the current number of references (the value of the reference counter) that the object has. (Inherited from xRecord.) | |
useExistingTempDBTable | (Inherited from xRecord.) | |
validateDelete | Determines whether the current record is valid and ready to be deleted from the database. | |
validateField | Determines whether the _fieldIdToCheck field is valid. | |
validateFieldValue | (Inherited from xRecord.) | |
validateTransportationTender | Validates tender is in correct status for order to be ship confirmed. Load tender must be accepted or denied if it exists. | |
validateWrite | Determines whether the current record is valid and ready to be written to the database. | |
validTimeStateUpdateMode | Sets a valid time state update mode on the cursor. (Inherited from xRecord.) | |
wait | Pauses a process. (Inherited from Object.) | |
wasCached | Specifies the location from which the data was retrieved. (Inherited from xRecord.) | |
write | Updates a record if it exists; otherwise, inserts a record. (Inherited from xRecord.) | |
xml | Retrieves an XML string that represents the current object. (Inherited from xRecord.) | |
::addLoadWeights | Updates the aggregated weight on the load based on a change in inventory quantity on a load line. | |
::changeLocation | Changes the location of either the stagging or final location, based on parameters, for all non-executed work that is associated with the load. | |
::changeWorkPriority | ||
::changeWorkUser | ||
::containsWHSItems | Checks if the load contains any lines for items that are WHS process enabled | |
::evaluateLoadPaysFreight | Evaluates the freights for order in regards with delivery terms. | |
::exist | ||
::existsOrderNum | Checks if a load for a given order number exists. | |
::find | ||
::findByRecId | ||
::hasLoadInvalidLines | Determines if a given load has one or more invalid lines. | |
::hasOpenContainer | ||
::hasQuantityNotPhysicallyReserved | Determines if a given load has quantities that are not physically reserved. | |
::isAllQtyPicked | Determines if all qty on the load is in a picked status. | |
::jumpRefAccountNum | ||
::jumpRefOrderNum | ||
::jumpRefWaveId | ||
::lookupLoadItems | ||
::nextStopNum | ||
::numberOfLoadsForOrderNum | Counts the amount of loads an order is associated with. | |
::setLoadLinesShipConfirmInfo | Sets additional load lines fields during ship confirm process. | |
::setLoadShipConfirmInfo | Sets additional load fields during ship confirm process. | |
::setOriginInfo | Sets the origin information on the load header. | |
::setShipConfirmInfo | Sets additional load, load lines and shipments fields during ship confirm process. | |
::setShipmentsShipConfirmInfo | Sets shipments fields during ship confirm process | |
::tmsOverrideLocation | ||
::tmsSetTransTemplate | Update the transportation template Id on the load based on related source document. | |
::unfreezeWork | ||
::updateLoadStatus | ||
::validateInventTransTypeMatches | Validates that lines being added to the load are not of a different order type then lines currently on the load. | |
::validateLoadIsLoaded | Validates that the load should be in a loaded status. |
Top
Fields
Field | Type | Configuration key | Description |
---|---|---|---|
AccountNum | Extended Data Type: WHSAccountNum Type: String |
WHSandTMS | The vendor account number for the purchase order, or the customer account number for the sales order (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ActualGrossWeight | Extended Data Type: TMSActualGrossWeight Type: Real |
WHSandTMS | The actual gross weight (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ActualNetWeight | Extended Data Type: TMSActualWeight Type: Real |
WHSandTMS | The final weight of an object (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ActualTareWeight | Extended Data Type: TMSActualTareWeight Type: Real |
WHSandTMS | The actual tare weight (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
BillOfLadingId | Extended Data Type: WHSBillOfLadingId Type: String |
WHSandTMS | The bill of lading identification number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
BookingNum | Extended Data Type: TMSBookingNum Type: String |
WHSandTMS | The unique booking number for a load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
BrokerCode | Extended Data Type: TMSBrokerCode Type: String |
WHSandTMS | The unique identifier for the broker who booked the transportation (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CarNumber | Extended Data Type: TMSCarNumber Type: String |
WHSandTMS | The identifier for a car (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CarrierCode | Extended Data Type: TMSCarrierCode Type: String |
WHSandTMS | The unique identifier for the shipping carrier (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CarrierGroupCode | Extended Data Type: TMSCarrierGroupCode Type: String |
WHSandTMS | The unique identifier for the carrier group (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CarrierServiceCode | Extended Data Type: TMSCarrierServiceCode Type: String |
WHSandTMS | The unique identifier for the carrier service (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
createdBy | Extended Data Type: CreatedBy Type: String |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
createdDateTime | Extended Data Type: CreatedDateTime Type: UtcDateTime |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CustVendRef | Extended Data Type: WHSCustVendRef Type: String |
WHSandTMS | Either a customer reference or vendor reference number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
CutOffUTCDateTime | Extended Data Type: TMSCutoffUTCDateTime Type: UtcDateTime |
WHSandTMS | The cut off date and time (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
dataAreaId | Extended Data Type: DataAreaId Type: String |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DestinationHubCode | Extended Data Type: TMSHubMasterCode Type: String |
WHSandTMS | The unique identifier for the hub master (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DestinationName | Extended Data Type: TMSName Type: String |
WHSandTMS | The description of the object (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
DestinationPostalAddress | Extended Data Type: LogisticsPostalAddressRecId Type: Int64 |
None | Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ETA | Extended Data Type: TMSETA Type: UtcDateTime |
WHSandTMS | The items estimated time of arrival (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ETD | Extended Data Type: TMSETD Type: UtcDateTime |
WHSandTMS | The estimated time of departure for the item (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
FinalDestination | Extended Data Type: TMSFinalDestination Type: Enum |
WHSandTMS | The final destination for the load. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
HouseBill | Extended Data Type: TMSHouseBill Type: String |
WHSandTMS | The unique identifier for the house bill (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InspectionSeal | Extended Data Type: TMSInspectionSeal Type: String |
WHSandTMS | The unique seal for the inspection (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Invalid | Extended Data Type: WHSInvalid Type: Enum |
WHSandTMS | Indicates if the load is invalid. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventLocationId | Extended Data Type: InventLocationId Type: String |
LogisticsBasic | Identify the warehouse. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
InventSiteId | Extended Data Type: InventSiteId Type: String |
LogisticsBasic | Identify the site (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LastUpdateUTCDateTime | Extended Data Type: WHSLastUpdateUTCDateTime Type: UtcDateTime |
WHSandTMS | The date and time the record was last updated (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LateShipReasonCode | Extended Data Type: TMSLateShipReasonCode Type: String |
WHSandTMS | The reason the shipment is late (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadArrivalUTCDateTime | Extended Data Type: WHSLoadArrivalUTCDateTime Type: UtcDateTime |
WHSandTMS | The arrival date and time of the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadDepth | Extended Data Type: WHSLoadDepth Type: Real |
WHSandTMS | The depth of the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadDirection | Enumeration: WHSLoadDirection |
WHSandTMS | The direction of the record for the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Loader | Extended Data Type: TMSLoader Type: String |
WHSandTMS | Person responsible for loading (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadFloorStack | Extended Data Type: WHSLoadFloorStack Type: Enum |
WHSandTMS | Specify if the load floor is stacked (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadHeight | Extended Data Type: WHSLoadHeight Type: Real |
WHSandTMS | The height of the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadId | Extended Data Type: WHSLoadId Type: String |
WHSandTMS | The identification number for the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadNetWeight | Extended Data Type: WHSLoadNetWeight Type: Real |
WHSandTMS | The net weight of the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadPaysFreight | Extended Data Type: TMSLoadPaysFreight Type: Enum |
WHSandTMS | Specify whether the load will write off freight charges (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadReferenceNum | Extended Data Type: WHSLoadReferenceNum Type: String |
WHSandTMS | The external reference number on the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadSchedShipUTCDateTime | Extended Data Type: WHSLoadSchedShipUTCDateTime Type: UtcDateTime |
WHSandTMS | The scheduled shipping date and time for the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadShipConfirmUTCDateTime | Extended Data Type: WHSLoadShipConfirmUTCDateTime Type: UtcDateTime |
WHSandTMS | The date and time the load was ship confirmed (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadStatus | Enumeration: WHSLoadStatus |
WHSandTMS | The status of the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadTemplateId | Extended Data Type: WHSLoadTemplateId Type: String |
WHSandTMS | The load template ID (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadTipVolume | Extended Data Type: WHSLoadTipVolume Type: Real |
WHSandTMS | The load tip volume (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadTipWeight | Extended Data Type: WHSLoadTipWeight Type: Real |
WHSandTMS | The load tip weight (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadTypeId | Extended Data Type: WHSLoadTypeId Type: String |
WHSandTMS | The load type (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadUserDef1 | Extended Data Type: WHSLoadUserDef1 Type: String |
WHSandTMS | User defined field 1. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadUserDef2 | Extended Data Type: WHSLoadUserDef2 Type: String |
WHSandTMS | User defined field 2. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadUserDef3 | Extended Data Type: WHSLoadUserDef3 Type: String |
WHSandTMS | User defined field 3. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadWeight | Extended Data Type: WHSLoadWeight Type: Real |
WHSandTMS | The weight of the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
LoadWidth | Extended Data Type: WHSLoadWidth Type: Real |
WHSandTMS | The width of the load (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
MaxFreightPieces | Extended Data Type: TMSMaxFreightPieces Type: Integer |
WHSandTMS | The maximum number of freight pieces allowed (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ModeCode | Extended Data Type: TMSModeCode Type: String |
WHSandTMS | The unique identifier for the mode (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
modifiedBy | Extended Data Type: ModifiedBy Type: String |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
modifiedDateTime | Extended Data Type: ModifiedDateTime Type: UtcDateTime |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
OrderNum | Extended Data Type: WHSOrderNum Type: String |
WHSandTMS | The order number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
OriginHubCode | Extended Data Type: TMSHubMasterCode Type: String |
WHSandTMS | The unique identifier for the hub master (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
OriginName | Extended Data Type: TMSName Type: String |
WHSandTMS | The description of the object (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
OriginPostalAddress | Extended Data Type: LogisticsPostalAddressRecId Type: Int64 |
None | Reference field in a different table (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Partition | Extended Data Type: Partition Type: Int64 |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
ProNum | Extended Data Type: WHSProNum Type: String |
WHSandTMS | The pro number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
RecId | Extended Data Type: RecId Type: Int64 |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
recVersion | Extended Data Type: RecVersion Type: Integer |
None | (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
RequiredSailUTCDateTime | Extended Data Type: TMSRequiredSailUTCDateTime Type: UtcDateTime |
WHSandTMS | The date and time the vessel is required to sail (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
RouteCode | Extended Data Type: TMSRouteCode Type: String |
WHSandTMS | The unique identifier for the planned freight route (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SailUTCDateTime | Extended Data Type: TMSSailUTCDateTime Type: UtcDateTime |
WHSandTMS | The Sail UTCdate time for the route. (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SealNum | Extended Data Type: WHSSealNum Type: String |
WHSandTMS | The seal number (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
SystemTareWeight | Extended Data Type: TMSSystemTareWeight Type: Real |
WHSandTMS | The system generated tare weight (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TractorNumber | Extended Data Type: TMSTractorNumber Type: String |
WHSandTMS | The unique identifier for the tractor (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TrailerNumber | Extended Data Type: WHSTrailerNumber Type: String |
WHSandTMS | The unique identifier for the trailer (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
TransportationTemplateId | Extended Data Type: TMSTransportationTemplateId Type: String |
WHSandTMS | The unique identifier for the transportation template (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
VesselName | Extended Data Type: TMSVesselName Type: String |
WHSandTMS | The name of the vessel (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
VoyageNum | Extended Data Type: TMSVoyageNum Type: String |
WHSandTMS | The unique identifier for a voyage (This field applies only to the following version(s): Microsoft Dynamics AX 2012 R3) |
Top
Field Groups
Field Group | Fields |
---|---|
All | |
AutoReport |
Top
Relations
Relation | Table | Lines |
---|---|---|
dataAreaId | DataArea | |
InventLocation | InventLocation | |
InventSite | InventSite | |
LogisitcsPostalAddressOrigin | LogisticsPostalAddress | |
LogisticsPostalAddressDestination | LogisticsPostalAddress | |
Partition | Partitions | |
TMSBroker | TMSCarrier | |
TMSCarrier | TMSCarrier | |
TMSCarrierGroup | TMSCarrierGroup | |
TMSCarrierService | TMSCarrierService | |
TMSHubMasterDest | TMSHubMaster | |
TMSHubMasterOrigin | TMSHubMaster | |
TMSLateShipReason | TMSLateShipReason | |
TMSMode | TMSMode | |
TMSRoute | TMSRoute | |
TMSTransportationTemplate | TMSTransportationTemplate | |
WHSLoadTemplate | WHSLoadTemplate | |
WHSLoadTypeTable | WHSLoadTypeTable | |
WHSSealTrans | WHSSealTrans |
Top
Indexes
Index | AllowDuplicates | Enabled | Fields |
---|---|---|---|
LoadIdIdx | No | Yes | |
LoadStatusIds | Yes | Yes | |
RecId | No | Yes |
Top
Inheritance Hierarchy
xRecord Class
Common Table
WHSLoadTable Table