Share via

Table Location

  • Reference
ID 14
Namespace: Microsoft.Inventory.Location

Properties

Name Value
Caption Location
DataCaptionFields 1,2
DrillDownPageID Microsoft.Inventory.Location."Location List"
LookupPageID Microsoft.Inventory.Location."Location List"
DataClassification CustomerContent

Fields

Name Type Description
Code Code[10]
Name Text[100]
"Default Bin Code" Code[20]
"Name 2" Text[50]
Address Text[100]
"Address 2" Text[50]
City Text[30]
"Phone No." Text[30]
"Phone No. 2" Text[30]
"Telex No." Text[30]
"Fax No." Text[30]
Contact Text[100]
"Post Code" Code[20]
County Text[30]
"E-Mail" Text[80]
"Home Page" Text[90]
"Country/Region Code" Code[10]
"Use As In-Transit" Boolean
"Require Put-away" Boolean
"Require Pick" Boolean
"Cross-Dock Due Date Calc." DateFormula
"Use Cross-Docking" Boolean
"Require Receive" Boolean
"Require Shipment" Boolean
"Bin Mandatory" Boolean
"Directed Put-away and Pick" Boolean
"Default Bin Selection" Microsoft.Warehouse.Structure."Location Default Bin Selection"
"Outbound Whse. Handling Time" DateFormula
"Inbound Whse. Handling Time" DateFormula
"Put-away Template Code" Code[10]
"Use Put-away Worksheet" Boolean
"Pick According to FEFO" Boolean
"Allow Breakbulk" Boolean
"Bin Capacity Policy" Option
"Pick Bin Policy" Microsoft.Warehouse.Activity."Pick Bin Policy"
"Check Whse. Class" Boolean
"Put-away Bin Policy" Microsoft.Warehouse.Activity."Put-away Bin Policy"
"Open Shop Floor Bin Code" Code[20]
"To-Production Bin Code" Code[20]
"From-Production Bin Code" Code[20]
"Prod. Consump. Whse. Handling" Microsoft.Manufacturing.Setup."Prod. Consump. Whse. Handling"
"Adjustment Bin Code" Code[20]
"Prod. Output Whse. Handling" Microsoft.Manufacturing.Setup."Prod. Output Whse. Handling"
"Always Create Put-away Line" Boolean
"Always Create Pick Line" Boolean
"Special Equipment" Option
"Receipt Bin Code" Code[20]
"Shipment Bin Code" Code[20]
"Cross-Dock Bin Code" Code[20]
"To-Assembly Bin Code" Code[20]
"From-Assembly Bin Code" Code[20]
"Asm.-to-Order Shpt. Bin Code" Code[20]
"To-Job Bin Code" Code[20]
"Asm. Consump. Whse. Handling" Microsoft.Assembly.Document."Asm. Consump. Whse. Handling"
"Job Consump. Whse. Handling" Microsoft.Projects.Project.Setup."Job Consump. Whse. Handling"
"Base Calendar Code" Code[10]
"Use ADCS" Boolean
SystemId Guid
SystemCreatedAt DateTime
SystemCreatedBy Guid
SystemModifiedAt DateTime
SystemModifiedBy Guid
SystemRowVersion BigInteger

Methods

RequireShipment

procedure RequireShipment(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

RequirePicking

procedure RequirePicking(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

RequireReceive

procedure RequireReceive(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

RequirePutaway

procedure RequirePutaway(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

BinMandatory

procedure BinMandatory(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

GetLocationSetup

procedure GetLocationSetup(LocationCode: Code[10], var Location2: Record Location): Boolean

Parameters

Name Type Description
LocationCode Code[10]
Location2 Record Location

Returns

Type Description
Boolean

CheckEmptyBin

procedure CheckEmptyBin(LocationCode: Code[10], BinCode: Code[20], CaptionOfField: Text[30])

Parameters

Name Type Description
LocationCode Code[10]
BinCode Code[20]
CaptionOfField Text[30]

GetRequirementText

procedure GetRequirementText(FieldNumber: Integer): Text[50]

Parameters

Name Type Description
FieldNumber Integer

Returns

Type Description
Text[50]

DisplayMap

procedure DisplayMap()

IsBWReceive

procedure IsBWReceive(): Boolean

Returns

Type Description
Boolean

IsBWShip

procedure IsBWShip(): Boolean

Returns

Type Description
Boolean

IsBinBWReceiveOrShip

procedure IsBinBWReceiveOrShip(BinCode: Code[20]): Boolean

Parameters

Name Type Description
BinCode Code[20]

Returns

Type Description
Boolean

IsInTransit

procedure IsInTransit(LocationCode: Code[10]): Boolean

Parameters

Name Type Description
LocationCode Code[10]

Returns

Type Description
Boolean

GetLocationsIncludingUnspecifiedLocation

procedure GetLocationsIncludingUnspecifiedLocation(IncludeOnlyUnspecifiedLocation: Boolean, ExcludeInTransitLocations: Boolean)

Parameters

Name Type Description
IncludeOnlyUnspecifiedLocation Boolean
ExcludeInTransitLocations Boolean

PickAccordingToFEFO

procedure PickAccordingToFEFO(): Boolean

Returns

Type Description
Boolean

SelectMultipleLocations

procedure SelectMultipleLocations(): Text

Returns

Type Description
Text

See also