Sales Shipment Header

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Sell-to Customer No_]
   ,[Bill-to Customer No_]
   ,[Bill-to Name]
   ,[Bill-to Name 2]
   ,[Bill-to Address]
   ,[Bill-to Address 2]
   ,[Bill-to City]
   ,[Bill-to Contact]
   ,[Your Reference]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Name 2]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[Order Date]
   ,[Posting Date]
   ,[Shipment Date]
   ,[Posting Description]
   ,[Payment Terms Code]
   ,[Due Date]
   ,[Payment Discount _]
   ,[Pmt_ Discount Date]
   ,[Shipment Method Code]
   ,[Location Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Customer Posting Group]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Customer Price Group]
   ,[Prices Including VAT]
   ,[Invoice Disc_ Code]
   ,[Customer Disc_ Group]
   ,[Language Code]
   ,[Salesperson Code]
   ,[Order No_]
   ,[No_ Printed]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account No_]
   ,[VAT Registration No_]
   ,[Reason Code]
   ,[Gen_ Bus_ Posting Group]
   ,[EU 3-Party Trade]
   ,[Transaction Type]
   ,[Transport Method]
   ,[VAT Country_Region Code]
   ,[Sell-to Customer Name]
   ,[Sell-to Customer Name 2]
   ,[Sell-to Address]
   ,[Sell-to Address 2]
   ,[Sell-to City]
   ,[Sell-to Contact]
   ,[Bill-to Post Code]
   ,[Bill-to County]
   ,[Bill-to Country_Region Code]
   ,[Sell-to Post Code]
   ,[Sell-to County]
   ,[Sell-to Country_Region Code]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[Bal_ Account Type]
   ,[Exit Point]
   ,[Correction]
   ,[Document Date]
   ,[External Document No_]
   ,[Area]
   ,[Transaction Specification]
   ,[Payment Method Code]
   ,[Shipping Agent Code]
   ,[Package Tracking No_]
   ,[No_ Series]
   ,[Order No_ Series]
   ,[User ID]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Base Discount _]
   ,[Quote No_]
   ,[Company Bank Account Code]
   ,[Sell-to Phone No_]
   ,[Sell-to E-Mail]
   ,[Work Description]
   ,[Dimension Set ID]
   ,[Campaign No_]
   ,[Sell-to Contact No_]
   ,[Bill-to Contact No_]
   ,[Opportunity No_]
   ,[Responsibility Center]
   ,[Requested Delivery Date]
   ,[Promised Delivery Date]
   ,[Shipping Time]
   ,[Outbound Whse_ Handling Time]
   ,[Shipping Agent Service Code]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Sales Shipment 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_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Shipment Header].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Sales Shipment Header].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Sales Shipment Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Sales Shipment Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Sales Shipment Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Sales Shipment Header].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Sales Shipment Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Sales Shipment Header].[Customer Price Group] = [Customer Price Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
      ON
         [Sales Shipment Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Sales Shipment Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Sales Shipment Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Sales Shipment Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Sales Shipment Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Sales Shipment Header].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
      ON
         [Sales Shipment Header].[Opportunity No_] = [Opportunity].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
      ON
         [Sales Shipment Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]

Show/hide columns in Sales Shipment Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2No_ Primary Key Searchnvarchar(40)
3Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

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

Show/hide example query

SELECT
       [Sales Shipment Header].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Sales Shipment Header].[Bill-to Customer No_] = [Customer].[No_]
5Bill-to Name Searchnvarchar(200)
6Bill-to Name 2 Searchnvarchar(100)
7Bill-to Address Searchnvarchar(200)
8Bill-to Address 2 Searchnvarchar(100)
9Bill-to City Searchnvarchar(60)
10Bill-to Contact Searchnvarchar(200)
11Your Reference Searchnvarchar(70)
12Ship-to Code Searchnvarchar(20)
13Ship-to Name Searchnvarchar(200)
14Ship-to Name 2 Searchnvarchar(100)
15Ship-to Address Searchnvarchar(200)
16Ship-to Address 2 Searchnvarchar(100)
17Ship-to City Searchnvarchar(60)
18Ship-to Contact Searchnvarchar(200)
19Order Date Searchdatetime
20Posting Date Searchdatetime
21Shipment Date Searchdatetime
22Posting Description Searchnvarchar(200)
23Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Sales Shipment Header].[Payment Terms Code] = [Payment Terms].[Code]
24Due Date Searchdatetime
25Payment Discount _ Searchdecimal(38,38)
26Pmt_ Discount Date Searchdatetime
27Shipment Method Code Searchnvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Sales Shipment Header].[Shipment Method Code] = [Shipment Method].[Code]
28Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Sales Shipment Header].[Location Code] = [Location].[Code]
29Shortcut Dimension 1 Code Searchnvarchar(40)
30Shortcut Dimension 2 Code Searchnvarchar(40)
31Customer Posting Group Searchnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Customer Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Sales Shipment Header].[Customer Posting Group] = [Customer Posting Group].[Code]
32Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Sales Shipment Header].[Currency Code] = [Currency].[Code]
33Currency Factor Searchdecimal(38,38)
34Customer Price Group Searchnvarchar(20)
Key to join to the Customer Price Group table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Sales Shipment Header].[Customer Price Group] = [Customer Price Group].[Code]
35Prices Including VAT Searchtinyint
36Invoice Disc_ Code Searchnvarchar(40)
37Customer Disc_ Group Searchnvarchar(40)
Key to join to the Customer Discount Group table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Sales Shipment Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
38Language Code Searchnvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Sales Shipment Header].[Language Code] = [Language].[Code]
39Salesperson Code Searchnvarchar(40)
Key to join to the Salesperson_Purchaser table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Sales Shipment Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
40Order No_ Searchnvarchar(40)
41No_ Printed Searchint
42On Hold Searchnvarchar(6)
43Applies-to Doc_ Type Searchint
44Applies-to Doc_ No_ Searchnvarchar(40)
45Bal_ Account No_ Searchnvarchar(40)
46VAT Registration No_ Searchnvarchar(40)
47Reason Code Searchnvarchar(20)
48Gen_ Bus_ Posting Group Searchnvarchar(40)
49EU 3-Party Trade Searchtinyint
50Transaction Type Searchnvarchar(20)
51Transport Method Searchnvarchar(20)
52VAT Country_Region Code Searchnvarchar(20)
53Sell-to Customer Name Searchnvarchar(200)
54Sell-to Customer Name 2 Searchnvarchar(100)
55Sell-to Address Searchnvarchar(200)
56Sell-to Address 2 Searchnvarchar(100)
57Sell-to City Searchnvarchar(60)
58Sell-to Contact Searchnvarchar(200)
59Bill-to Post Code Searchnvarchar(40)
60Bill-to County Searchnvarchar(60)
61Bill-to Country_Region Code Searchnvarchar(20)
62Sell-to Post Code Searchnvarchar(40)
63Sell-to County Searchnvarchar(60)
64Sell-to Country_Region Code Searchnvarchar(20)
65Ship-to Post Code Searchnvarchar(40)
66Ship-to County Searchnvarchar(60)
67Ship-to Country_Region Code Searchnvarchar(20)
68Bal_ Account Type Searchint
69Exit Point Searchnvarchar(20)
70Correction Searchtinyint
71Document Date Searchdatetime
72External Document No_ Searchnvarchar(70)
73Area Searchnvarchar(20)
74Transaction Specification Searchnvarchar(20)
75Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Sales Shipment Header].[Payment Method Code] = [Payment Method].[Code]
76Shipping Agent Code Searchnvarchar(20)
Key to join to the Shipping Agent table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Shipping Agent Code]
       ,[Shipping Agent].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
              ON
                     [Sales Shipment Header].[Shipping Agent Code] = [Shipping Agent].[Code]
77Package Tracking No_ Searchnvarchar(60)
78No_ Series Searchnvarchar(40)
79Order No_ Series Searchnvarchar(40)
80User ID Searchnvarchar(100)
81Source Code Searchnvarchar(20)
82Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Sales Shipment Header].[Tax Area Code] = [Tax Area].[Code]
83Tax Liable Searchtinyint
84VAT Bus_ Posting Group Searchnvarchar(40)
85VAT Base Discount _ Searchdecimal(38,38)
86Quote No_ Searchnvarchar(40)
87Company Bank Account Code Searchnvarchar(40)
88Sell-to Phone No_ Searchnvarchar(60)
89Sell-to E-Mail Searchnvarchar(160)
90Work Description Searchimage
91Dimension Set ID Searchint
92Campaign No_ Searchnvarchar(40)
93Sell-to Contact No_ Searchnvarchar(40)
94Bill-to Contact No_ Searchnvarchar(40)
95Opportunity No_ Searchnvarchar(40)
Key to join to the Opportunity table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Opportunity No_]
       ,[Opportunity].[No_]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
              ON
                     [Sales Shipment Header].[Opportunity No_] = [Opportunity].[No_]
96Responsibility Center Searchnvarchar(20)
97Requested Delivery Date Searchdatetime
98Promised Delivery Date Searchdatetime
99Shipping Time Searchvarchar(32)
100Outbound Whse_ Handling Time Searchvarchar(32)
101Shipping Agent Service Code Searchnvarchar(20)
Key to join to the Shipping Agent Services table.

Show/hide example query

SELECT
       [Sales Shipment Header].[Shipping Agent Service Code]
       ,[Shipping Agent Services].[Code]
FROM
       [CRONUS UK Ltd_$Sales Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipping Agent Services$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent Services]
              ON
                     [Sales Shipment Header].[Shipping Agent Service Code] = [Shipping Agent Services].[Code]
102Price Calculation Method Searchint
103Allow Line Disc_ Searchtinyint
104$systemId Searchuniqueidentifier
105$systemCreatedAt Searchdatetime
106$systemCreatedBy Searchuniqueidentifier
107$systemModifiedAt Searchdatetime
108$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Sales Shipment Header table

Leave a Reply

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