Location – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables LLocation

Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/14

Table Type: Company

Table Name: Location
Database Table Name: CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 14

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Location can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Code]
   ,[Name]
   ,[Default Bin Code]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Phone No_]
   ,[Phone No_ 2]
   ,[Telex No_]
   ,[Fax No_]
   ,[Contact]
   ,[Post Code]
   ,[County]
   ,[E-Mail]
   ,[Home Page]
   ,[Country_Region Code]
   ,[Use As In-Transit]
   ,[Require Put-away]
   ,[Require Pick]
   ,[Cross-Dock Due Date Calc_]
   ,[Use Cross-Docking]
   ,[Require Receive]
   ,[Require Shipment]
   ,[Bin Mandatory]
   ,[Directed Put-away and Pick]
   ,[Default Bin Selection]
   ,[Outbound Whse_ Handling Time]
   ,[Inbound Whse_ Handling Time]
   ,[Put-away Template Code]
   ,[Use Put-away Worksheet]
   ,[Pick According to FEFO]
   ,[Allow Breakbulk]
   ,[Bin Capacity Policy]
   ,[Pick Bin Policy]
   ,[Check Whse_ Class]
   ,[Put-away Bin Policy]
   ,[Open Shop Floor Bin Code]
   ,[To-Production Bin Code]
   ,[From-Production Bin Code]
   ,[Prod_ Consump_ Whse_ Handling]
   ,[Adjustment Bin Code]
   ,[Prod_ Output Whse_ Handling]
   ,[Always Create Put-away Line]
   ,[Always Create Pick Line]
   ,[Special Equipment]
   ,[Receipt Bin Code]
   ,[Shipment Bin Code]
   ,[Cross-Dock Bin Code]
   ,[To-Assembly Bin Code]
   ,[From-Assembly Bin Code]
   ,[Asm_-to-Order Shpt_ Bin Code]
   ,[To-Job Bin Code]
   ,[Asm_ Consump_ Whse_ Handling]
   ,[Job Consump_ Whse_ Handling]
   ,[Base Calendar Code]
   ,[Use ADCS]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Location].[City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Location].[Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Put-away Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Header]
      ON
         [Location].[Put-away Template Code] = [Put-away Template Header].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar]
      ON
         [Location].[Base Calendar Code] = [Base Calendar].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Location].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Location].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Location].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Location table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Code	Code	Normal	Code	10	Code	nvarchar(20)
2	Name	Name	Normal	Text	100	Name	nvarchar(200)
130	Default Bin Code	Default Bin Code	Normal	Code	20	Default Bin Code	nvarchar(40)
5700	Name 2	Name 2	Normal	Text	50	Name 2	nvarchar(100)
5701	Address	Address	Normal	Text	100	Address	nvarchar(200)
5702	Address 2	Address 2	Normal	Text	50	Address 2	nvarchar(100)
5703	City	City	Normal	Text	30	City	nvarchar(60)
	Key to join to the Post Code table. Show/hide example query SELECT [Location].[City] ,[Post Code].[City] FROM [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Location].[City] = [Post Code].[City]
5704	Phone No.	Phone No.	Normal	Text	30	Phone No_	nvarchar(60)
5705	Phone No. 2	Phone No. 2	Normal	Text	30	Phone No_ 2	nvarchar(60)
5706	Telex No.	Telex No.	Normal	Text	30	Telex No_	nvarchar(60)
5707	Fax No.	Fax No.	Normal	Text	30	Fax No_	nvarchar(60)
5713	Contact	Contact	Normal	Text	100	Contact	nvarchar(200)
5714	Post Code	ZIP Code	Normal	Code	20	Post Code	nvarchar(40)
	Key to join to the Post Code table. Show/hide example query SELECT [Location].[Post Code] ,[Post Code].[Code] FROM [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] LEFT JOIN [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code] ON [Location].[Post Code] = [Post Code].[Code]
5715	County	State	Normal	Text	30	County	nvarchar(60)
5718	E-Mail	Email	Normal	Text	80	E-Mail	nvarchar(160)
5719	Home Page	Home Page	Normal	Text	90	Home Page	nvarchar(180)
5720	Country/Region Code	Country/Region Code	Normal	Code	10	Country_Region Code	nvarchar(20)
5724	Use As In-Transit	Use As In-Transit	Normal	Boolean	4	Use As In-Transit	tinyint
5726	Require Put-away	Require Put-away	Normal	Boolean	4	Require Put-away	tinyint
5727	Require Pick	Require Pick	Normal	Boolean	4	Require Pick	tinyint
5728	Cross-Dock Due Date Calc.	Cross-Dock Due Date Calc.	Normal	DateFormula	32	Cross-Dock Due Date Calc_	varchar(32)
5729	Use Cross-Docking	Use Cross-Docking	Normal	Boolean	4	Use Cross-Docking	tinyint
5730	Require Receive	Require Receive	Normal	Boolean	4	Require Receive	tinyint
5731	Require Shipment	Require Shipment	Normal	Boolean	4	Require Shipment	tinyint
5732	Bin Mandatory	Bin Mandatory	Normal	Boolean	4	Bin Mandatory	tinyint
5733	Directed Put-away and Pick	Directed Put-away and Pick	Normal	Boolean	4	Directed Put-away and Pick	tinyint
5734	Default Bin Selection	Default Bin Selection	Normal	Option	4	Default Bin Selection	int
	Available options are: ” “ “Fixed Bin” “Last-Used Bin”
5790	Outbound Whse. Handling Time	Outbound Whse. Handling Time	Normal	DateFormula	32	Outbound Whse_ Handling Time	varchar(32)
5791	Inbound Whse. Handling Time	Inbound Whse. Handling Time	Normal	DateFormula	32	Inbound Whse_ Handling Time	varchar(32)
7305	Put-away Template Code	Put-away Template Code	Normal	Code	10	Put-away Template Code	nvarchar(20)
	Key to join to the Put-away Template Header table. Show/hide example query SELECT [Location].[Put-away Template Code] ,[Put-away Template Header].[Code] FROM [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] LEFT JOIN [CRONUS UK Ltd_$Put-away Template Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Put-away Template Header] ON [Location].[Put-away Template Code] = [Put-away Template Header].[Code]
7306	Use Put-away Worksheet	Use Put-away Worksheet	Normal	Boolean	4	Use Put-away Worksheet	tinyint
7307	Pick According to FEFO	Pick According to FEFO	Normal	Boolean	4	Pick According to FEFO	tinyint
7308	Allow Breakbulk	Allow Breakbulk	Normal	Boolean	4	Allow Breakbulk	tinyint
7309	Bin Capacity Policy	Bin Capacity Policy	Normal	Option	4	Bin Capacity Policy	int
	Available options are: “Never Check Capacity” “Allow More Than Max. Capacity” “Prohibit More Than Max. Cap.”
7310	Pick Bin Policy	Pick Bin Policy	Normal	Option	4	Pick Bin Policy	int
	Available options are: “Default Bin” “Bin Ranking”
7311	Check Whse. Class	Check Warehouse Class	Normal	Boolean	4	Check Whse_ Class	tinyint
7312	Put-away Bin Policy	Put-away Bin Policy	Normal	Option	4	Put-away Bin Policy	int
	Available options are: “Default Bin” “Put-away Template”
7313	Open Shop Floor Bin Code	Open Shop Floor Bin Code	Normal	Code	20	Open Shop Floor Bin Code	nvarchar(40)
7314	To-Production Bin Code	To-Production Bin Code	Normal	Code	20	To-Production Bin Code	nvarchar(40)
7315	From-Production Bin Code	From-Production Bin Code	Normal	Code	20	From-Production Bin Code	nvarchar(40)
7316	Prod. Consump. Whse. Handling	Prod. Consump. Whse. Handling	Normal	Option	4	Prod_ Consump_ Whse_ Handling	int
	Available options are: “No Warehouse Handling” “Warehouse Pick (optional)” “Inventory Pick/Movement” “Warehouse Pick (mandatory)”
7317	Adjustment Bin Code	Adjustment Bin Code	Normal	Code	20	Adjustment Bin Code	nvarchar(40)
7318	Prod. Output Whse. Handling	Prod. Output Whse. Handling	Normal	Option	4	Prod_ Output Whse_ Handling	int
	Available options are: “No Warehouse Handling” “Inventory Put-away”
7319	Always Create Put-away Line	Always Create Put-away Line	Normal	Boolean	4	Always Create Put-away Line	tinyint
7320	Always Create Pick Line	Always Create Pick Line	Normal	Boolean	4	Always Create Pick Line	tinyint
7321	Special Equipment	Special Equipment	Normal	Option	4	Special Equipment	int
	Available options are: ” “ “According to Bin” “According to SKU/Item”
7323	Receipt Bin Code	Receipt Bin Code	Normal	Code	20	Receipt Bin Code	nvarchar(40)
7325	Shipment Bin Code	Shipment Bin Code	Normal	Code	20	Shipment Bin Code	nvarchar(40)
7326	Cross-Dock Bin Code	Cross-Dock Bin Code	Normal	Code	20	Cross-Dock Bin Code	nvarchar(40)
7330	To-Assembly Bin Code	To-Assembly Bin Code	Normal	Code	20	To-Assembly Bin Code	nvarchar(40)
7331	From-Assembly Bin Code	From-Assembly Bin Code	Normal	Code	20	From-Assembly Bin Code	nvarchar(40)
7332	Asm.-to-Order Shpt. Bin Code	Asm.-to-Order Shpt. Bin Code	Normal	Code	20	Asm_-to-Order Shpt_ Bin Code	nvarchar(40)
7333	To-Job Bin Code	To-Job Bin Code	Normal	Code	20	To-Job Bin Code	nvarchar(40)
7334	Asm. Consump. Whse. Handling	Asm. Consump. Whse. Handling	Normal	Option	4	Asm_ Consump_ Whse_ Handling	int
	Available options are: “No Warehouse Handling” “Warehouse Pick (optional)” “Inventory Movement” “Warehouse Pick (mandatory)”
7335	Job Consump. Whse. Handling	Job Consump. Whse. Handling	Normal	Option	4	Job Consump_ Whse_ Handling	int
	Available options are: “No Warehouse Handling” “Warehouse Pick (optional)” “Inventory Pick” “Warehouse Pick (mandatory)”
7600	Base Calendar Code	Base Calendar Code	Normal	Code	10	Base Calendar Code	nvarchar(20)
	Key to join to the Base Calendar table. Show/hide example query SELECT [Location].[Base Calendar Code] ,[Base Calendar].[Code] FROM [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] LEFT JOIN [CRONUS UK Ltd_$Base Calendar$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Base Calendar] ON [Location].[Base Calendar Code] = [Base Calendar].[Code]
7700	Use ADCS	Use ADCS	Normal	Boolean	4	Use ADCS	tinyint
10010	Tax Area Code	Tax Area Code	Normal	Code	20
	Key to join to the Tax Area table. Show/hide example query SELECT [Location].[] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Location].[] = [Tax Area].[Code]
10015	Tax Exemption No.	Tax Exemption No.	Normal	Text	30
10016	Do Not Use For Tax Calculation	Do Not Use For Tax Calculation	Normal	Boolean	4
10017	Provincial Tax Area Code	Provincial Tax Area Code	Normal	Code	20
27009	SAT Address ID	SAT Address ID	Normal	Integer	4
27026	SAT State Code	SAT State Code	Normal	Code	10
27027	SAT Municipality Code	SAT Municipality Code	Normal	Code	10
27028	SAT Locality Code	SAT Locality Code	Normal	Code	10
27029	SAT Suburb ID	SAT Suburb ID	Normal	Integer	4
27030	ID Ubicacion	ID Ubicacion	Normal	Integer	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	Key to join to the User table. Show/hide example query SELECT [Location].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] LEFT JOIN [User] AS [User] ON [Location].[$systemCreatedBy] = [User].[User Security ID]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Location table

Dynamics 365 BC Table Reference Tables Company Tables LLocation

Leave a Reply Cancel reply