Shipping Agent

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

Table Type: Company

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

Table Number: 291

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Code]
   ,[Name]
   ,[Internet Address]
   ,[Account No_]
   ,[Coupled to CRM]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide columns in Shipping Agent table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Code Primary Key Searchnvarchar(20)
3Name Searchnvarchar(100)
4Internet Address Searchnvarchar(500)
5Account No_ Searchnvarchar(60)
6Coupled to CRM Searchtinyint
7$systemId Searchuniqueidentifier
8$systemCreatedAt Searchdatetime
9$systemCreatedBy Searchuniqueidentifier
10$systemModifiedAt Searchdatetime
11$systemModifiedBy Searchuniqueidentifier

Show/hide tables related to Shipping Agent table

Leave a Reply

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