Return Shipment Header

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

Table Type: Company

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

Table Number: 6650

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Buy-from Vendor No_]
   ,[Pay-to Vendor No_]
   ,[Pay-to Name]
   ,[Pay-to Name 2]
   ,[Pay-to Address]
   ,[Pay-to Address 2]
   ,[Pay-to City]
   ,[Pay-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]
   ,[Posting Date]
   ,[Expected Receipt 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]
   ,[Vendor Posting Group]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Invoice Disc_ Code]
   ,[Language Code]
   ,[Purchaser Code]
   ,[No_ Printed]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account No_]
   ,[VAT Registration No_]
   ,[Sell-to Customer No_]
   ,[Reason Code]
   ,[Gen_ Bus_ Posting Group]
   ,[Transaction Type]
   ,[Transport Method]
   ,[VAT Country_Region Code]
   ,[Buy-from Vendor Name]
   ,[Buy-from Vendor Name 2]
   ,[Buy-from Address]
   ,[Buy-from Address 2]
   ,[Buy-from City]
   ,[Buy-from Contact]
   ,[Pay-to Post Code]
   ,[Pay-to County]
   ,[Pay-to Country_Region Code]
   ,[Buy-from Post Code]
   ,[Buy-from County]
   ,[Buy-from Country_Region Code]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[Bal_ Account Type]
   ,[Order Address Code]
   ,[Entry Point]
   ,[Correction]
   ,[Document Date]
   ,[Area]
   ,[Transaction Specification]
   ,[Payment Method Code]
   ,[No_ Series]
   ,[User ID]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Base Discount _]
   ,[Dimension Set ID]
   ,[Campaign No_]
   ,[Buy-from Contact No_]
   ,[Pay-to Contact No_]
   ,[Responsibility Center]
   ,[Vendor Authorization No_]
   ,[Return Order No_]
   ,[Return Order No_ Series]
   ,[Price Calculation Method]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Return 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_$Return Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Header]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Return Shipment Header].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Return Shipment Header].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Return Shipment Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Return Shipment Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Return Shipment Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Return Shipment Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Return Shipment Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Return Shipment Header].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Return Shipment Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Return Shipment Header].[Tax Area Code] = [Tax Area].[Code]

Show/hide columns in Return Shipment Header table

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

Show/hide example query

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

Show/hide example query

SELECT
       [Return Shipment Header].[Pay-to Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Return Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Return Shipment Header].[Pay-to Vendor No_] = [Vendor].[No_]
5Pay-to Name Searchnvarchar(200)
6Pay-to Name 2 Searchnvarchar(100)
7Pay-to Address Searchnvarchar(200)
8Pay-to Address 2 Searchnvarchar(100)
9Pay-to City Searchnvarchar(60)
10Pay-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)
19Posting Date Searchdatetime
20Expected Receipt Date Searchdatetime
21Posting Description Searchnvarchar(200)
22Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Return Shipment Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Return Shipment Header].[Language Code] = [Language].[Code]
35Purchaser Code Searchnvarchar(40)
36No_ Printed Searchint
37On Hold Searchnvarchar(6)
38Applies-to Doc_ Type Searchint
39Applies-to Doc_ No_ Searchnvarchar(40)
40Bal_ Account No_ Searchnvarchar(40)
41VAT Registration No_ Searchnvarchar(40)
42Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Return Shipment Header].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Return Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Return Shipment Header].[Sell-to Customer No_] = [Customer].[No_]
43Reason Code Searchnvarchar(20)
44Gen_ Bus_ Posting Group Searchnvarchar(40)
45Transaction Type Searchnvarchar(20)
46Transport Method Searchnvarchar(20)
47VAT Country_Region Code Searchnvarchar(20)
48Buy-from Vendor Name Searchnvarchar(200)
49Buy-from Vendor Name 2 Searchnvarchar(100)
50Buy-from Address Searchnvarchar(200)
51Buy-from Address 2 Searchnvarchar(100)
52Buy-from City Searchnvarchar(60)
53Buy-from Contact Searchnvarchar(200)
54Pay-to Post Code Searchnvarchar(40)
55Pay-to County Searchnvarchar(60)
56Pay-to Country_Region Code Searchnvarchar(20)
57Buy-from Post Code Searchnvarchar(40)
58Buy-from County Searchnvarchar(60)
59Buy-from Country_Region Code Searchnvarchar(20)
60Ship-to Post Code Searchnvarchar(40)
61Ship-to County Searchnvarchar(60)
62Ship-to Country_Region Code Searchnvarchar(20)
63Bal_ Account Type Searchint
64Order Address Code Searchnvarchar(20)
65Entry Point Searchnvarchar(20)
66Correction Searchtinyint
67Document Date Searchdatetime
68Area Searchnvarchar(20)
69Transaction Specification Searchnvarchar(20)
70Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Return Shipment Header].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Return Shipment Header].[Payment Method Code] = [Payment Method].[Code]
71No_ Series Searchnvarchar(40)
72User ID Searchnvarchar(100)
73Source Code Searchnvarchar(20)
74Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Return Shipment Header].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Return Shipment Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Shipment Header]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Return Shipment Header].[Tax Area Code] = [Tax Area].[Code]
75Tax Liable Searchtinyint
76VAT Bus_ Posting Group Searchnvarchar(40)
77VAT Base Discount _ Searchdecimal(38,38)
78Dimension Set ID Searchint
79Campaign No_ Searchnvarchar(40)
80Buy-from Contact No_ Searchnvarchar(40)
81Pay-to Contact No_ Searchnvarchar(40)
82Responsibility Center Searchnvarchar(20)
83Vendor Authorization No_ Searchnvarchar(70)
84Return Order No_ Searchnvarchar(40)
85Return Order No_ Series Searchnvarchar(40)
86Price Calculation Method Searchint
87$systemId Searchuniqueidentifier
88$systemCreatedAt Searchdatetime
89$systemCreatedBy Searchuniqueidentifier
90$systemModifiedAt Searchdatetime
91$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Return Shipment Header table

Leave a Reply

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