Export (0) Print
Expand All
Expand Minimize

WMSTransport Table

The WMSTransport table contains information about pallet transports.

ID: 689

Configuration Key: WMSPallet

Security Key: InventTables

Method

Description

Activate

Marks the current transport as activated.

activateRefill

Creates refills of picking locations if needed.

aosValidateDelete

(Inherited from xRecord.)

aosValidateInsert

(Inherited from xRecord.)

aosValidateRead

(Inherited from xRecord.)

aosValidateUpdate

(Inherited from xRecord.)

Cancel

Cancels a request to transport a pallet.

cancelTimeOut

Cancels a previous method call to the Object::setTimeOut Method. (Inherited from Object.)

canFromDimensionsBeChanged

Determines whether the From inventory dimensions of the transport can be changed by the user.

canToDimensionsBeChanged

Determines whether the destination inventory dimensions of the transport can be changed by the user.

canToPalletBeChanged

Indicates whether the destination pallet of the transport can be changed.

caption

(Inherited from xRecord.)

ChangeToLocation

Changes the location to which to transport the pallet.

checkFix

checkRecord

(Inherited from xRecord.)

checkRestrictedDeleteActions

(Inherited from xRecord.)

cleanupDelete

Deletes all completed transports from the table.

clear

(Inherited from xRecord.)

company

(Inherited from xRecord.)

concurrencyModel

(Inherited from xRecord.)

context

(Inherited from xRecord.)

createInTransportLineArrived

createInTransportLinePhysical

createInTransportLineReservPhysical

createNewPalletAtToLocation

Creates a new pallet at destination location of this transport.

createRefillTransportLinePhysical

createTransportLine

data

(Inherited from xRecord.)

dataSource

(Inherited from xRecord.)

dbOpInTransaction

(Inherited from xRecord.)

delete

(Inherited from xRecord.)

deleteRefillTransport

disableCache

(Inherited from xRecord.)

doClear

(Inherited from xRecord.)

doDelete

(Inherited from xRecord.)

doInsert

(Inherited from xRecord.)

doUpdate

(Inherited from xRecord.)

doValidateDelete

(Inherited from xRecord.)

equal

(Inherited from xRecord.)

executeCachedDisplayMethods

(Inherited from xRecord.)

Finish

Completes the transport and updates related wmsOrderTrans records.

FromLocation

Gets or sets the originating location of a transport.

getPresenceFieldData

(Inherited from xRecord.)

getTimeOutTimerHandle

Returns the timer handle for the object. (Inherited from Object.)

getToPalletIdFromLines

This method can be used to get the to pallet ID of a transport line that has not yet been delivered.

handle

Retrieves the handle of the class of the object. (Inherited from Object.)

handlePalletAtToDestination

Ensures that a valid pallet is used if a pallet different from the transport pallet is needed at the destination location.

helpField

(Inherited from xRecord.)

infoOnLocationBlocking

Shows Infolog messages if involved locations are blocked.

initHeights

initValue

(Inherited from xRecord.)

insert

(Inherited from xRecord.)

isFormDataSource

(Inherited from xRecord.)

isFullPallet

Indicates whether the transport is moving the whole pallet quantity.

isNewToPalletRequired

Indicates whether a new destination pallet must be specified for this transport.

isNewToPalletRequiredDisplay

Indicates whether a new destination pallet must be specified for this transport.

isPhysicalUpdated

isTmp

(Inherited from xRecord.)

itemId

Retrieves the item ID of the related record in the WMSOrderTrans table.

itemQty

joinChild

(Inherited from xRecord.)

joinParent

(Inherited from xRecord.)

LockOperator

makeRefillTransport

merge

(Inherited from xRecord.)

modifiedField

(Inherited from xRecord.)

mustActivateRefill

Determines whether refills should be activated automatically.

new

Initializes a new instance of the Object class.. (Inherited from Object.)

notify

Releases the hold on an object that has called a wait method on this object. (Inherited from Object.)

notifyAll

Releases a lock on the object that was issued by a wait method on this object. (Inherited from Object.)

numberOfLines

objectOnServer

Determines whether the object is on a server. (Inherited from Object.)

orig

(Inherited from xRecord.)

overwriteSystemfields

(Inherited from xRecord.)

owner

Returns the instance that owns the object. (Inherited from Object.)

postLoad

(Inherited from xRecord.)

queryTimedOut

(Inherited from xRecord.)

queryTimeout

(Inherited from xRecord.)

readPast

(Inherited from xRecord.)

recordLevelSecurity

(Inherited from xRecord.)

renamePrimaryKey

(Inherited from xRecord.)

reread

(Inherited from xRecord.)

RowCount

(Inherited from xRecord.)

selectForUpdate

(Inherited from xRecord.)

selectLocked

(Inherited from xRecord.)

selectRefRecord

(Inherited from xRecord.)

selectWithRepeatableRead

(Inherited from xRecord.)

setConnection

(Inherited from xRecord.)

setTimeOut

Sets up the scheduled execution of a specified method. (Inherited from Object.)

setTmp

(Inherited from xRecord.)

setTmpData

(Inherited from xRecord.)

skipAosValidation

(Inherited from xRecord.)

skipDatabaseLog

(Inherited from xRecord.)

skipDataMethods

(Inherited from xRecord.)

skipDeleteActions

(Inherited from xRecord.)

skipDeleteMethod

(Inherited from xRecord.)

skipEvents

Provides an option to turn off calling the Application.event* methods for the life time of the xRecord instance. (Inherited from xRecord.)

skipTTSCheck

(Inherited from xRecord.)

Start

Starts the transport.

sumUpLines

suppressWarnings

(Inherited from xRecord.)

ToLocation

Retrieves the location in a warehouse to which to send the pallet.

toolTipField

(Inherited from xRecord.)

toolTipRecord

(Inherited from xRecord.)

toString

Returns a string that represents the current object. (Inherited from Object.)

ttsabort

(Inherited from xRecord.)

ttsbegin

(Inherited from xRecord.)

ttscommit

(Inherited from xRecord.)

update

(Inherited from xRecord.)

usageCount

(Inherited from xRecord.)

validateDelete

(Inherited from xRecord.)

validateField

(Inherited from xRecord.)

validateWrite

(Inherited from xRecord.)

wait

Pauses a process. (Inherited from Object.)

wasCached

(Inherited from xRecord.)

WMSPallet

Retrieves the pallet that is described by this transport record.

write

(Inherited from xRecord.)

xml

(Inherited from xRecord.)

::cleanup

::createEmptyInTransport

::createEmptyOutTransport

::createInTransport

::createRefillTransport

::find

Finds the specified record in the WMSTransport table.

::findPalletTransport

::lookupStartable

::transportsEnabled

Field

ID

Type

Configuration key

Description

wMSPalletId

1

Extended Data Type: WMSPalletId

Type: str

WMSPallet

Unique ID for the pallet (Serial Shipping Container Code)

fromLocation

2

Extended Data Type: WMSLocationId

Type: str

WMSBasic

Location in a warehouse.

toLocation

3

Extended Data Type: WMSLocationId

Type: str

WMSBasic

Location in a warehouse.

inputLocation

4

Extended Data Type: WMSLocationId

Type: str

WMSBasic

Destination location, normally the location itself.

operator

5

Extended Data Type: EmplId

Type: str

None

Employee number.

expeditionStatus

6

Enumeration: WMSExpeditionStatus

None

Handling status in the warehouse system

transportType

7

Enumeration: WMSTransportType

None

Transport type

DEL_startDate

8

Extended Data Type: StartDate

Type: date

SysDeletedObjects41

Date on which the handling is started

DEL_startTime

9

System Data Type: timeOfDay

Type: int

SysDeletedObjects41

Start time of the transport

DEL_endDate

10

Extended Data Type: EndDate

Type: date

SysDeletedObjects41

Date on which the handling is ended

DEL_endTime

11

System Data Type: timeOfDay

Type: int

SysDeletedObjects41

End time of the transport

transportPriority

12

Extended Data Type: WMSTransportPriority

Type: int

WMSPallet

Priority for transport

shipmentId

13

Extended Data Type: WMSShipmentId

Type: str

LogisticsAdvanced

Shipment ID in the warehouse system.

startDateTime

14

Extended Data Type: StartDateTime

Type: utcdatetime

None

Start DateTime help text

forkLiftId

15

Extended Data Type: WMSForkLiftId

Type: str

WMSAdvanced

Identification of the forklift.

fromInventLocationId

16

Extended Data Type: InventLocationId

Type: str

LogisticsAdvanced

Identify the warehouse.

toInventLocationId

17

Extended Data Type: InventLocationId

Type: str

LogisticsAdvanced

Identify the warehouse.

transportId

18

Extended Data Type: WMSTransportId

Type: str

WMSPallet

Identification of pallet transport

DEL_activationDate

19

Extended Data Type: DEL_ActivationDate

Type: date

SysDeletedObjects41

Activation date of the transport

DEL_activationTime

20

Extended Data Type: DEL_ActivationTime

Type: int

SysDeletedObjects41

Time when the transport was activated

totalQty

21

Extended Data Type: InventQty

Type: real

None

Total item quantity to be moved

toHeight

22

Extended Data Type: WMSHeight

Type: real

WMSBasic

Height of the location where the transport is to end

fromHeight

23

Extended Data Type: WMSHeight

Type: real

WMSBasic

Height of the location where the transport starts

endDateTime

24

Extended Data Type: EndDateTime

Type: utcdatetime

None

End Datetime help text

activationDateTime

25

Extended Data Type: ActivationDateTime

Type: utcdatetime

None

Start DateTime help text

modifiedDateTime

61440

System Data Type: modifiedDateTime

Type: utcdatetime

None

modifiedBy

61442

System Data Type: modifiedBy

Type: str

None

createdDateTime

61444

System Data Type: createdDateTime

Type: utcdatetime

None

createdBy

61446

System Data Type: createdBy

Type: str

None

dataAreaId

61448

System Data Type: dataAreaId

Type: str

None

recVersion

61450

System Data Type: recVersion

Type: int

None

RecId

65534

System Data Type: recId

Type: int64

None

Field Group

Fields

Activation

activationDateTime

AutoReport

wMSPalletId

transportType

fromLocation

toLocation

expeditionStatus

FromGroup

fromInventLocationId

fromLocation

fromHeight

Identification

transportId

wMSPalletId

transportType

expeditionStatus

Other

transportPriority

shipmentId

totalQty

Statistics

operator

forkLiftId

activationDateTime

startDateTime

endDateTime

To

toInventLocationId

toLocation

inputLocation

toHeight

Relation

Table

Lines

DataArea

DataArea Table

WMSTransport.dataAreaId == DataArea.id

EmplTable

EmplTable Table

WMSTransport.operator == EmplTable.EmplId

FromLocation

WMSLocation Table

WMSTransport.fromInventLocationId == WMSLocation.inventLocationId

WMSTransport.fromLocation == WMSLocation.wMSLocationId

InputLocation

WMSLocation Table

WMSTransport.toInventLocationId == WMSLocation.inventLocationId

WMSTransport.inputLocation == WMSLocation.wMSLocationId

InventLocation

InventLocation Table

WMSTransport.toInventLocationId == InventLocation.InventLocationId

ToLocation

WMSLocation Table

WMSTransport.toInventLocationId == WMSLocation.inventLocationId

WMSTransport.toLocation == WMSLocation.wMSLocationId

WMSForkLift

WMSForkLift Table

WMSTransport.forkLiftId == WMSForkLift.forkLiftId

WMSPallet

WMSPallet Table

WMSTransport.wMSPalletId == WMSPallet.wMSPalletId

WMSShipment

WMSShipment Table

WMSTransport.shipmentId == WMSShipment.shipmentId

WMSTransport

WMSTransport Table

WMSTransport.transportId == WMSTransport.transportId

Index

AllowDuplicates

Enabled

Fields

LocationIdx

Yes

Yes

toLocation

toInventLocationId

expeditionStatus

OperatorStatusIdx

Yes

Yes

operator

expeditionStatus

transportType

fromHeight

PalletIdx

Yes

Yes

wMSPalletId

expeditionStatus

RecId

No

Yes

RecId

ShipmentIdx

Yes

Yes

shipmentId

TransportIdx

No

Yes

transportId

Community Additions

ADD
Show:
© 2014 Microsoft