Shipping Agent Services

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

Table Type: Company

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

Table Number: 5790

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 Shipping Agent Services can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Shipping Agent Code]
   ,[Code]
   ,[Description]
   ,[Shipping Time]
   ,[Base Calendar Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Shipping Agent Services].[Shipping Agent Code] = [Shipping Agent].[Code]

Show/hide columns in Shipping Agent Services table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Shipping Agent Code Primary Key Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Shipping Agent Services].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Shipping Agent Services].[Shipping Agent Code] = [Shipping Agent].[Code]
3Code Primary Key Searchnvarchar(20)
4Description Searchnvarchar(200)
5Shipping Time Searchvarchar(32)
6Base Calendar Code Searchnvarchar(20)
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Shipping Agent Services table

Show/hide tables related to Shipping Agent Services table

Leave a Reply

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