Location

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 NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Code Primary Key SearchCodeNormalCode10Codenvarchar(20)
2Name SearchNameNormalText100Namenvarchar(200)
130Default Bin Code SearchDefault Bin CodeNormalCode20Default Bin Codenvarchar(40)
5700Name 2 SearchName 2NormalText50Name 2nvarchar(100)
5701Address SearchAddressNormalText100Addressnvarchar(200)
5702Address 2 SearchAddress 2NormalText50Address 2nvarchar(100)
5703City SearchCityNormalText30Citynvarchar(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]
5704Phone No. SearchPhone No.NormalText30Phone No_nvarchar(60)
5705Phone No. 2 SearchPhone No. 2NormalText30Phone No_ 2nvarchar(60)
5706Telex No. SearchTelex No.NormalText30Telex No_nvarchar(60)
5707Fax No. SearchFax No.NormalText30Fax No_nvarchar(60)
5713Contact SearchContactNormalText100Contactnvarchar(200)
5714Post Code SearchZIP CodeNormalCode20Post Codenvarchar(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]
5715County SearchStateNormalText30Countynvarchar(60)
5718E-Mail SearchEmailNormalText80E-Mailnvarchar(160)
5719Home Page SearchHome PageNormalText90Home Pagenvarchar(180)
5720Country/Region Code SearchCountry/Region CodeNormalCode10Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Location].[Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Location].[Country_Region Code] = [Country/Region].[Code]
5724Use As In-Transit SearchUse As In-TransitNormalBoolean4Use As In-Transittinyint
5726Require Put-away SearchRequire Put-awayNormalBoolean4Require Put-awaytinyint
5727Require Pick SearchRequire PickNormalBoolean4Require Picktinyint
5728Cross-Dock Due Date Calc. SearchCross-Dock Due Date Calc.NormalDateFormula32Cross-Dock Due Date Calc_varchar(32)
5729Use Cross-Docking SearchUse Cross-DockingNormalBoolean4Use Cross-Dockingtinyint
5730Require Receive SearchRequire ReceiveNormalBoolean4Require Receivetinyint
5731Require Shipment SearchRequire ShipmentNormalBoolean4Require Shipmenttinyint
5732Bin Mandatory SearchBin MandatoryNormalBoolean4Bin Mandatorytinyint
5733Directed Put-away and Pick SearchDirected Put-away and PickNormalBoolean4Directed Put-away and Picktinyint
5734Default Bin Selection SearchDefault Bin SelectionNormalOption4Default Bin Selectionint
Available options are:
  • ” “
  • “Fixed Bin”
  • “Last-Used Bin”
5790Outbound Whse. Handling Time SearchOutbound Whse. Handling TimeNormalDateFormula32Outbound Whse_ Handling Timevarchar(32)
5791Inbound Whse. Handling Time SearchInbound Whse. Handling TimeNormalDateFormula32Inbound Whse_ Handling Timevarchar(32)
7305Put-away Template Code SearchPut-away Template CodeNormalCode10Put-away Template Codenvarchar(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]
7306Use Put-away Worksheet SearchUse Put-away WorksheetNormalBoolean4Use Put-away Worksheettinyint
7307Pick According to FEFO SearchPick According to FEFONormalBoolean4Pick According to FEFOtinyint
7308Allow Breakbulk SearchAllow BreakbulkNormalBoolean4Allow Breakbulktinyint
7309Bin Capacity Policy SearchBin Capacity PolicyNormalOption4Bin Capacity Policyint
Available options are:
  • “Never Check Capacity”
  • “Allow More Than Max. Capacity”
  • “Prohibit More Than Max. Cap.”
7310Pick Bin Policy SearchPick Bin PolicyNormalOption4Pick Bin Policyint
Available options are:
  • “Default Bin”
  • “Bin Ranking”
7311Check Whse. Class SearchCheck Warehouse ClassNormalBoolean4Check Whse_ Classtinyint
7312Put-away Bin Policy SearchPut-away Bin PolicyNormalOption4Put-away Bin Policyint
Available options are:
  • “Default Bin”
  • “Put-away Template”
7313Open Shop Floor Bin Code SearchOpen Shop Floor Bin CodeNormalCode20Open Shop Floor Bin Codenvarchar(40)
7314To-Production Bin Code SearchTo-Production Bin CodeNormalCode20To-Production Bin Codenvarchar(40)
7315From-Production Bin Code SearchFrom-Production Bin CodeNormalCode20From-Production Bin Codenvarchar(40)
7316Prod. Consump. Whse. Handling SearchProd. Consump. Whse. HandlingNormalOption4Prod_ Consump_ Whse_ Handlingint
Available options are:
  • “No Warehouse Handling”
  • “Warehouse Pick (optional)”
  • “Inventory Pick/Movement”
  • “Warehouse Pick (mandatory)”
7317Adjustment Bin Code SearchAdjustment Bin CodeNormalCode20Adjustment Bin Codenvarchar(40)
7318Prod. Output Whse. Handling SearchProd. Output Whse. HandlingNormalOption4Prod_ Output Whse_ Handlingint
Available options are:
  • “No Warehouse Handling”
  • “Inventory Put-away”
7319Always Create Put-away Line SearchAlways Create Put-away LineNormalBoolean4Always Create Put-away Linetinyint
7320Always Create Pick Line SearchAlways Create Pick LineNormalBoolean4Always Create Pick Linetinyint
7321Special Equipment SearchSpecial EquipmentNormalOption4Special Equipmentint
Available options are:
  • ” “
  • “According to Bin”
  • “According to SKU/Item”
7323Receipt Bin Code SearchReceipt Bin CodeNormalCode20Receipt Bin Codenvarchar(40)
7325Shipment Bin Code SearchShipment Bin CodeNormalCode20Shipment Bin Codenvarchar(40)
7326Cross-Dock Bin Code SearchCross-Dock Bin CodeNormalCode20Cross-Dock Bin Codenvarchar(40)
7330To-Assembly Bin Code SearchTo-Assembly Bin CodeNormalCode20To-Assembly Bin Codenvarchar(40)
7331From-Assembly Bin Code SearchFrom-Assembly Bin CodeNormalCode20From-Assembly Bin Codenvarchar(40)
7332Asm.-to-Order Shpt. Bin Code SearchAsm.-to-Order Shpt. Bin CodeNormalCode20Asm_-to-Order Shpt_ Bin Codenvarchar(40)
7333To-Job Bin Code SearchTo-Job Bin CodeNormalCode20To-Job Bin Codenvarchar(40)
7334Asm. Consump. Whse. Handling SearchAsm. Consump. Whse. HandlingNormalOption4Asm_ Consump_ Whse_ Handlingint
Available options are:
  • “No Warehouse Handling”
  • “Warehouse Pick (optional)”
  • “Inventory Movement”
  • “Warehouse Pick (mandatory)”
7335Job Consump. Whse. Handling SearchJob Consump. Whse. HandlingNormalOption4Job Consump_ Whse_ Handlingint
Available options are:
  • “No Warehouse Handling”
  • “Warehouse Pick (optional)”
  • “Inventory Pick”
  • “Warehouse Pick (mandatory)”
7600Base Calendar Code SearchBase Calendar CodeNormalCode10Base Calendar Codenvarchar(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]
7700Use ADCS SearchUse ADCSNormalBoolean4Use ADCStinyint
10010Tax Area Code SearchTax Area CodeNormalCode20
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10016Do Not Use For Tax Calculation SearchDo Not Use For Tax CalculationNormalBoolean4
10017Provincial Tax Area Code SearchProvincial Tax Area CodeNormalCode20
27009SAT Address ID SearchSAT Address IDNormalInteger4
27026SAT State Code SearchSAT State CodeNormalCode10
27027SAT Municipality Code SearchSAT Municipality CodeNormalCode10
27028SAT Locality Code SearchSAT Locality CodeNormalCode10
27029SAT Suburb ID SearchSAT Suburb IDNormalInteger4
27030ID Ubicacion SearchID UbicacionNormalInteger4
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
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]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Location].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
LEFT JOIN
       [User] AS [User]
              ON
                     [Location].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Location table

Leave a Reply

Your email address will not be published. Required fields are marked *