tableInventoryofficial - Microsoftderived - from the source, no model text

Table 14 "Location"

Base Application · Microsoft.Inventory.Location

Across versions

  1. BC23present
  2. BC243 fields changed
  3. BC251 procedures added, 1 events added
  4. BC262 fields removed, 1 fields changed
  5. BC271 fields changed
  6. BC2847 fields changed, 2 fields removed
  7. BC29-30unchanged

Neighbourhood 244 connected objects and pages

Table 7354 "Bin" (relates to, 10 links)BinTable 225 "Post Code" (relates to, 2 links)Page 15 "Location List" (pages and codeunits on it, 3 links)Location ListCodeunit 5714 "Copy Location" (pages and codeunits on it)Table extension 6102 "E-Doc. Location" (extended by)Table extension 6614 "FS Location" (extended by)Codeunit 99000795 "Mfg. Item Integration" (event subscribers, 6 links)Mfg. Item IntegrationCodeunit 5996 "Prod. Order Warehouse Mgt." (event subscribers)Codeunit 408 "DimensionManagement" (calls, 2 links)DimensionManagementCodeunit 5773 "Whse.-Transfer Release" (calls, 2 links)Codeunit 7600 "Calendar Management" (calls, 2 links)Table 4763 "Whse Demo Data Setup" (referenced by, 4 links)Whse Demo Data SetupTable 4764 "Warehouse Module Setup" (referenced by, 4 links)Warehouse Module SetupTable 5740 "Transfer Header" (referenced by, 4 links)Transfer HeaderTable 246 "Requisition Line" (referenced by, 3 links)Table 5700 "Stockkeeping Unit" (referenced by, 3 links)Table 5741 "Transfer Line" (referenced by, 3 links)Transfer LineTable 5742 "Transfer Route" (referenced by, 3 links)Transfer RouteTable 5744 "Transfer Shipment Header" (referenced by, 3 links)Transfer Shipment HeaderTable 5745 "Transfer Shipment Line" (referenced by, 3 links)Table 5746 "Transfer Receipt Header" (referenced by, 3 links)Table 5747 "Transfer Receipt Line" (referenced by, 3 links)Transfer Receipt LineTable 5766 "Warehouse Activity Header" (referenced by, 3 links)Warehouse Activity HeaderTable 5771 "Warehouse Source Filter" (referenced by, 3 links)Table 36 "Sales Header" (referenced by, 2 links)Sales HeaderTable 38 "Purchase Header" (referenced by, 2 links)Table 4766 "Manufacturing Module Setup" (referenced by, 2 links)Manufacturing Module SetupTable 5107 "Sales Header Archive" (referenced by, 2 links)Table 5109 "Purchase Header Archive" (referenced by, 2 links)Table 5765 "Warehouse Request" (referenced by, 2 links)Table 5767 "Warehouse Activity Line" (referenced by, 2 links)Table 5773 "Registered Whse. Activity Line" (referenced by, 2 links)Table 5856 "Direct Trans. Header" (referenced by, 2 links)Table 5857 "Direct Trans. Line" (referenced by, 2 links)Table 5952 "Resource Location" (referenced by, 2 links)Table 7340 "Posted Invt. Put-away Header" (referenced by, 2 links)Table 7341 "Posted Invt. Put-away Line" (referenced by, 2 links)Table 7342 "Posted Invt. Pick Header" (referenced by, 2 links)Breaking Bulk with Directed Put-away and Pick (Learn pages)Configure warehouse processes (Learn pages)

Open in the neighbourhood explorer

One hop out, from the extracted relations and call graph. Up to 40 shown; the sections below list them all.

Base Application · Microsoft.Inventory.Location · BC23-30 · source at ea08af5e · facts from BC29

Learn documents this table through its pages: Page 30076 “APIV2 - Locations” (5 Learn pages), Page 5703 “Location Card” (4), Page 15 “Location List” (2), Page 515 “Item Avail. by Location Lines” (1), Page 7347 “Locations with Warehouse List” (1).

Properties

Property Value
Caption Location
DataClassification CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No. Name Type Explanation Notes
1 Code Δ BC28 Code[10] Specifies a location code for the warehouse or distribution center where your items are handled and stored before being sold. NotBlank
2 Name Δ BC28 Text[100] Specifies the name or address of the location.
130 Default Bin Code Code[20] — TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
5700 Name 2 Text[50] —
5701 Address Δ BC28 Text[100] Specifies the location address.
5702 Address 2 Δ BC28 Text[50] Specifies additional address information.
5703 City Δ BC28 Text[30] Specifies the city of the location. TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code”.City else if (“Country/Region Code” = filter(<> ‘’)) “Post Code”.City where(“Country/Region Code” = field(“Country/Region Code”)))
5704 Phone No. Δ BC28 Text[30] Specifies the telephone number of the location.
5705 Phone No. 2 Text[30] —
5706 Telex No. Text[30] —
5707 Fax No. Δ BC28 Text[30] Specifies the fax number of the location.
5713 Contact Δ BC28 Text[100] Specifies the name of the contact person at the location
5714 Post Code Δ BC28 Code[20] Specifies the postal code. TableRelation Table 225 “Post Code” (if (“Country/Region Code” = const(‘’)) “Post Code” else if (“Country/Region Code” = filter(<> ‘’)) “Post Code” where(“Country/Region Code” = field(“Country/Region Code”)))
5715 County Δ BC28 Text[30] Specifies the state, province or county as a part of the address.
5718 E-Mail Δ BC28 Text[80] Specifies the email address of the location.
5719 Home Page Δ BC24 Δ BC27 Δ BC28 Text[255] Specifies the location’s web site.
5720 Country/Region Code Δ BC28 Code[10] Specifies the country/region of the address. TableRelation Table 9 “Country/Region” (Country/Region)
5724 Use As In-Transit Δ BC28 Boolean Specifies that this location is an in-transit location.
5726 Require Put-away Δ BC28 Boolean Specifies if the location requires a dedicated warehouse activity when putting items away.
5727 Require Pick Δ BC28 Boolean Specifies if the location requires a dedicated warehouse activity when picking items.
5728 Cross-Dock Due Date Calc. Δ BC28 DateFormula Specifies the cross-dock due date calculation.
5729 Use Cross-Docking Δ BC28 Boolean Specifies if the location supports movement of items directly from the receiving dock to the shipping dock.
5730 Require Receive Δ BC28 Boolean Specifies if the location requires a receipt document when receiving items.
5731 Require Shipment Δ BC28 Boolean Specifies if the location requires a shipment document when shipping items.
5732 Bin Mandatory Δ BC28 Boolean Specifies if the location requires that a bin code is specified on all item transactions.
5733 Directed Put-away and Pick Δ BC28 Boolean Specifies if the location requires advanced warehouse functionality, such as calculated bin suggestion.
5734 Default Bin Selection Δ BC28 Enum “Location Default Bin Selection” Specifies the method used to select the default bin. enum Enum 14 “Location Default Bin Selection”
5790 Outbound Whse. Handling Time Δ BC28 DateFormula Specifies a date formula for the time it takes to get items ready to ship from this location. The time element is used in the calculation of the delivery date as follows: Shipment Date + Outbound Warehouse Handling Time = Planned Shipment Date + Shipping Time = Planned Delivery Date.
5791 Inbound Whse. Handling Time Δ BC28 DateFormula Specifies the time it takes to make items part of available inventory, after the items have been posted as received.
7305 Put-away Template Code Δ BC28 Code[10] Specifies the put-away template to be used at this location. TableRelation Table 7307 “Put-away Template Header” (Put-away Template Header)
7306 Use Put-away Worksheet Δ BC28 Boolean Specifies if put-aways for posted warehouse receipts must be created with the put-away worksheet. If the check box is not selected, put-aways are created directly when you post a warehouse receipt or production output.
7307 Pick According to FEFO Δ BC28 Boolean Specifies whether to use the First-Expired-First-Out (FEFO) method to determine which items to pick, according to expiration dates.
7308 Allow Breakbulk Δ BC26 Boolean Specifies that an order can be fulfilled with items stored in alternate units of measure, if an item stored in the requested unit of measure is not found. This feature is applicable only with directed put-away and pick locations.
7309 Bin Capacity Policy Δ BC28 Option Specifies how bins are automatically filled, according to their capacity. OptionCaption: Never Check Capacity,Allow More Than Max. Capacity,Prohibit More Than Max. Cap.
7310 Pick Bin Policy Δ BC28 Enum “Pick Bin Policy” Specifies how bins are automatically selected for inventory picks. enum Enum 5700 “Pick Bin Policy”
7311 Check Whse. Class Δ BC28 Boolean Specifies if the warehouse class should be checked.
7312 Put-away Bin Policy Enum “Put-away Bin Policy” Specifies how bins are automatically selected for inventory put-away. via Page 5703 “Location Card” enum Enum 5701 “Put-away Bin Policy”
7313 Open Shop Floor Bin Code Δ BC28 Code[20] Specifies the bin that functions as the default open shop floor bin. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
7317 Adjustment Bin Code Δ BC28 Code[20] Specifies the code of the bin in which you record observed differences in inventory quantities. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
7319 Always Create Put-away Line Δ BC28 Boolean Specifies that a put-away line is created, even if an appropriate zone and bin in which to place the items cannot be found.
7320 Always Create Pick Line Δ BC28 Boolean Specifies that a pick line is created, even if an appropriate zone and bin from which to pick the item cannot be found.
7321 Special Equipment Δ BC28 Option Specifies where the program will first looks for special equipment designated for warehouse activities. OptionCaption: ,According to Bin,According to SKU/Item
7323 Receipt Bin Code Δ BC28 Code[20] Specifies the default receipt bin code. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
7325 Shipment Bin Code Δ BC28 Code[20] Specifies the default shipment bin code. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
7326 Cross-Dock Bin Code Δ BC28 Code[20] Specifies the bin code that is used by default for the receipt of items to be cross-docked. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
7330 To-Assembly Bin Code Δ BC28 Code[20] Specifies the bin in the assembly area where components are placed by default before they can be consumed in assembly. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
7331 From-Assembly Bin Code Δ BC28 Code[20] Specifies the bin in the assembly area where finished assembly items are posted to when they are assembled to stock. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
7332 Asm.-to-Order Shpt. Bin Code Δ BC28 Code[20] Specifies the bin where finished assembly items are posted to when they are assembled to a linked sales order. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
7333 To-Job Bin Code Δ BC24 Δ BC28 Code[20] Specifies the bin where an item will be put away or picked in warehouse and inventory processes at this location. For example, when you choose this location on a project planning line, this bin will be suggested. TableRelation Table 7354 “Bin” (Bin.Code where(“Location Code” = field(Code)))
7334 Asm. Consump. Whse. Handling Δ BC28 Enum “Asm. Consump. Whse. Handling” Specifies the warehouse handling for consumption in assembly scenarios. enum Enum 900 “Asm. Consump. Whse. Handling”
7335 Job Consump. Whse. Handling Δ BC24 Δ BC28 Enum “Job Consump. Whse. Handling” Specifies the warehouse handling for consumption in project scenarios. enum Enum 1000 “Job Consump. Whse. Handling”
7600 Base Calendar Code Δ BC28 Code[10] Specifies a customizable calendar for planning that holds the location’s working days and holidays. TableRelation Table 7600 “Base Calendar” (Base Calendar)
7700 Use ADCS Δ BC28 Boolean Specifies the automatic data capture system that warehouse employees must use to keep track of items within the warehouse.

Keys

  • Key1: Code (clustered)
  • Key2: Name
  • Key3: Use As In-Transit, Bin Mandatory

Events published

  • OnAfterLookupCity(var Location: Record Location; var PostCode: Record "Post Code") (integration)
  • OnAfterLookupPostCode(var Location: Record Location; var PostCode: Record "Post Code") (integration)
  • OnAfterValidateCity(var Location: Record Location; var PostCode: Record "Post Code") (integration)
  • OnAfterValidatePostCode(var Location: Record Location; var PostCode: Record "Post Code") (integration)
  • OnBeforeValidateUseCrossDocking(var Location: Record Location; xLocation: Record Location; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnGetLocationSetupOnAfterInitLocation(var Location: Record Location; var Location2: Record Location) (integration)
  • OnBeforeWMSCheckWarehouse(var Location: Record Location; var IsHandled: Boolean) (integration)
  • OnValidateBinMandatoryOnBeforeItemLedgEntrySetFilters(var Location: Record Location) (integration)
  • OnValidateBinMandatoryOnAfterItemLedgEntrySetFilters(var Location: Record Location) (integration)
  • OnValidateBinMandatoryOnAfterWhseEntrySetFilters(var Location: Record Location; var WhseEntry: Record "Warehouse Entry") (integration)
  • OnBeforeValidateCity(var Location: Record Location; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnBeforeValidatePostCode(var Location: Record Location; var PostCode: Record "Post Code"; CurrentFieldNo: Integer; var IsHandled: Boolean) (integration)
  • OnBeforeIsBinBWReceiveOrShip(Location: Record Location; BinCode: Code[20]; var Result: Boolean; var IsHandled: Boolean) (integration)
  • OnValidateBinMandatoryOnAfterCheckBins(var Location: Record Location) + BC25 Δ BC28 (integration)
  • OnIsProdConsumpWhseHandlingTypeWarehousePick(var Location: Record Location; var Result: Boolean) + BC28 (internal)

Trigger event subscribers

Procedures

  • RequireShipment(LocationCode: Code[10]): Boolean
  • RequirePicking(LocationCode: Code[10]): Boolean
  • RequireReceive(LocationCode: Code[10]): Boolean
  • RequirePutaway(LocationCode: Code[10]): Boolean
  • BinMandatory(LocationCode: Code[10]): Boolean
  • GetLocationSetup(LocationCode: Code[10]; var Location2: Record Location): Boolean
  • CheckEmptyBin(LocationCode: Code[10]; BinCode: Code[20]; CaptionOfField: Text[30])
  • GetRequirementText(FieldNumber: Integer): Text[50]
  • DisplayMap()
  • IsBWReceive(): Boolean
  • IsBWShip(): Boolean
  • IsBinBWReceiveOrShip(BinCode: Code[20]): Boolean
  • IsInTransit(LocationCode: Code[10]): Boolean
  • IsProdConsumpWhseHandlingTypeWarehousePick(): Boolean + BC28
  • GetLocationsIncludingUnspecifiedLocation(IncludeOnlyUnspecifiedLocation: Boolean; ExcludeInTransitLocations: Boolean)
  • PickAccordingToFEFO(): Boolean
  • SelectMultipleLocations(): Text
  • CheckInventoryActivityExists(LocationCode: Code[10]; SourceType: Integer; FieldCaption: Text) Δ BC26
  • CheckBinCode(LocationCode: Code[10]; BinCode: Code[20]; BinCaption: Text; Number: Code[20]) + BC25

Plus 3 local procedures.

Triggers

OnDelete, OnRename

Relations

Referenced by

251 fields in 204 objects relate to this table (TableRelation or CalcFormula).

Pages and codeunits on this table

Extended by

Calls

From the extracted call graph of BC29 (graphify-al on the snapshot checkout): calls whose target is known from a declared type or an Object::"Name" argument. Interface dispatch and calls through events are not counted, so the list is not complete.

Recent changes

Ask your agent

Procedure bodies are not stored here (D10). The call sections above are our own, per object, from the BC29 call graph. For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Location"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

Evidence 1 sources