Handled IC Outbox Purch_ Hdr

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

Table Type: Company

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

Table Number: 432

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Handled IC Outbox Purch_ Hdr$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]
   ,[Buy-from Vendor No_]
   ,[No_]
   ,[Pay-to Vendor No_]
   ,[Your Reference]
   ,[Ship-to Name]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Posting Date]
   ,[Expected Receipt Date]
   ,[Due Date]
   ,[Payment Discount _]
   ,[Pmt_ Discount Date]
   ,[Currency Code]
   ,[Prices Including VAT]
   ,[Vendor Invoice No_]
   ,[Vendor Cr_ Memo No_]
   ,[Sell-to Customer No_]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[Document Date]
   ,[Requested Receipt Date]
   ,[Promised Receipt Date]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Handled IC Outbox Purch_ Hdr$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 Purch_ Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Purch_ Hdr]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Handled IC Outbox Purch_ Hdr].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Handled IC Outbox Purch_ Hdr].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Handled IC Outbox Purch_ Hdr].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Handled IC Outbox Purch_ Hdr].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Handled IC Outbox Purch_ Hdr].[Sell-to Customer No_] = [Customer].[No_]

Show/hide columns in Handled IC Outbox Purch_ Hdr 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 Purch_ Hdr].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Purch_ Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Purch_ Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Handled IC Outbox Purch_ Hdr].[IC Partner Code] = [IC Partner].[Code]
4Transaction Source Primary Key Searchint
5Document Type Searchint
6Buy-from Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Handled IC Outbox Purch_ Hdr].[Buy-from Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Purch_ Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Purch_ Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Handled IC Outbox Purch_ Hdr].[Buy-from Vendor No_] = [Vendor].[No_]
7No_ Searchnvarchar(40)
8Pay-to Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

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

Show/hide example query

SELECT
       [Handled IC Outbox Purch_ Hdr].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Purch_ Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Purch_ Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Handled IC Outbox Purch_ Hdr].[Currency Code] = [Currency].[Code]
20Prices Including VAT Searchtinyint
21Vendor Invoice No_ Searchnvarchar(70)
22Vendor Cr_ Memo No_ Searchnvarchar(70)
23Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Handled IC Outbox Purch_ Hdr].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Handled IC Outbox Purch_ Hdr$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Handled IC Outbox Purch_ Hdr]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Handled IC Outbox Purch_ Hdr].[Sell-to Customer No_] = [Customer].[No_]
24Ship-to Post Code Searchnvarchar(40)
25Ship-to County Searchnvarchar(60)
26Ship-to Country_Region Code Searchnvarchar(20)
27Document Date Searchdatetime
28Requested Receipt Date Searchdatetime
29Promised Receipt Date Searchdatetime
30$systemId Searchuniqueidentifier
31$systemCreatedAt Searchdatetime
32$systemCreatedBy Searchuniqueidentifier
33$systemModifiedAt Searchdatetime
34$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Handled IC Outbox Purch_ Hdr table

Leave a Reply

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