Handled IC Outbox Sales Header

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

Table Type: Company

Table Name: Handled IC Outbox Sales Header
Database Table Name: CRONUS UK Ltd_$Handled IC Outbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 430

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 Handled IC Outbox Sales Header can be queried.

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Handled IC Outbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[IC Transaction No_]
   ,[IC Partner Code]
   ,[Transaction Source]
   ,[Document Type]
   ,[Sell-to Customer No_]
   ,[No_]
   ,[Bill-to Customer No_]
   ,[Ship-to Name]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Posting Date]
   ,[Due Date]
   ,[Payment Discount _]
   ,[Pmt_ Discount Date]
   ,[Currency Code]
   ,[Prices Including VAT]
   ,[Order No_]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[Document Date]
   ,[External Document No_]
   ,[Requested Delivery Date]
   ,[Promised Delivery Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Handled IC Outbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

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

SELECT
   *
FROM
   [CRONUS UK Ltd_$Handled IC Outbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Sales Header]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Handled IC Outbox Sales Header].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Handled IC Outbox Sales Header].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Handled IC Outbox Sales Header].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Handled IC Outbox Sales Header].[Currency Code] = [Currency].[Code]

Show/hide columns in Handled IC Outbox Sales Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2IC Transaction No_ Primary Key Searchint
3IC Partner Code Primary Key Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Handled IC Outbox Sales Header].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Sales Header]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Handled IC Outbox Sales Header].[IC Partner Code] = [IC Partner].[Code]
4Transaction Source Primary Key Searchint
5Document Type Searchint
6Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Handled IC Outbox Sales Header].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Sales Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Handled IC Outbox Sales Header].[Sell-to Customer No_] = [Customer].[No_]
7No_ Searchnvarchar(40)
8Bill-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Handled IC Outbox Sales Header].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Sales Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Handled IC Outbox Sales Header].[Bill-to Customer No_] = [Customer].[No_]
9Ship-to Name Searchnvarchar(200)
10Ship-to Address Searchnvarchar(200)
11Ship-to Address 2 Searchnvarchar(100)
12Ship-to City Searchnvarchar(60)
13Posting Date Searchdatetime
14Due Date Searchdatetime
15Payment Discount _ Searchdecimal(38,38)
16Pmt_ Discount Date Searchdatetime
17Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Handled IC Outbox Sales Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Sales Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Handled IC Outbox Sales Header].[Currency Code] = [Currency].[Code]
18Prices Including VAT Searchtinyint
19Order No_ Searchnvarchar(40)
20Ship-to Post Code Searchnvarchar(40)
21Ship-to County Searchnvarchar(60)
22Ship-to Country_Region Code Searchnvarchar(20)
23Document Date Searchdatetime
24External Document No_ Searchnvarchar(70)
25Requested Delivery Date Searchdatetime
26Promised Delivery Date Searchdatetime
27$systemId Searchuniqueidentifier
28$systemCreatedAt Searchdatetime
29$systemCreatedBy Searchuniqueidentifier
30$systemModifiedAt Searchdatetime
31$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Handled IC Outbox Sales Header table

Leave a Reply

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