Return Shipment Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RReturn 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 ID	Column Name	Data Type
1	timestamp	timestamp
2	No_	nvarchar(40)
3	Buy-from Vendor No_	nvarchar(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_]
4	Pay-to Vendor No_	nvarchar(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_]
5	Pay-to Name	nvarchar(200)
6	Pay-to Name 2	nvarchar(100)
7	Pay-to Address	nvarchar(200)
8	Pay-to Address 2	nvarchar(100)
9	Pay-to City	nvarchar(60)
10	Pay-to Contact	nvarchar(200)
11	Your Reference	nvarchar(70)
12	Ship-to Code	nvarchar(20)
13	Ship-to Name	nvarchar(200)
14	Ship-to Name 2	nvarchar(100)
15	Ship-to Address	nvarchar(200)
16	Ship-to Address 2	nvarchar(100)
17	Ship-to City	nvarchar(60)
18	Ship-to Contact	nvarchar(200)
19	Posting Date	datetime
20	Expected Receipt Date	datetime
21	Posting Description	nvarchar(200)
22	Payment Terms Code	nvarchar(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]
23	Due Date	datetime
24	Payment Discount _	decimal(38,38)
25	Pmt_ Discount Date	datetime
26	Shipment Method Code	nvarchar(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]
27	Location Code	nvarchar(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]
28	Shortcut Dimension 1 Code	nvarchar(40)
29	Shortcut Dimension 2 Code	nvarchar(40)
30	Vendor Posting Group	nvarchar(40)
31	Currency Code	nvarchar(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]
32	Currency Factor	decimal(38,38)
33	Invoice Disc_ Code	nvarchar(40)
34	Language Code	nvarchar(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]
35	Purchaser Code	nvarchar(40)
36	No_ Printed	int
37	On Hold	nvarchar(6)
38	Applies-to Doc_ Type	int
39	Applies-to Doc_ No_	nvarchar(40)
40	Bal_ Account No_	nvarchar(40)
41	VAT Registration No_	nvarchar(40)
42	Sell-to Customer No_	nvarchar(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_]
43	Reason Code	nvarchar(20)
44	Gen_ Bus_ Posting Group	nvarchar(40)
45	Transaction Type	nvarchar(20)
46	Transport Method	nvarchar(20)
47	VAT Country_Region Code	nvarchar(20)
48	Buy-from Vendor Name	nvarchar(200)
49	Buy-from Vendor Name 2	nvarchar(100)
50	Buy-from Address	nvarchar(200)
51	Buy-from Address 2	nvarchar(100)
52	Buy-from City	nvarchar(60)
53	Buy-from Contact	nvarchar(200)
54	Pay-to Post Code	nvarchar(40)
55	Pay-to County	nvarchar(60)
56	Pay-to Country_Region Code	nvarchar(20)
57	Buy-from Post Code	nvarchar(40)
58	Buy-from County	nvarchar(60)
59	Buy-from Country_Region Code	nvarchar(20)
60	Ship-to Post Code	nvarchar(40)
61	Ship-to County	nvarchar(60)
62	Ship-to Country_Region Code	nvarchar(20)
63	Bal_ Account Type	int
64	Order Address Code	nvarchar(20)
65	Entry Point	nvarchar(20)
66	Correction	tinyint
67	Document Date	datetime
68	Area	nvarchar(20)
69	Transaction Specification	nvarchar(20)
70	Payment Method Code	nvarchar(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]
71	No_ Series	nvarchar(40)
72	User ID	nvarchar(100)
73	Source Code	nvarchar(20)
74	Tax Area Code	nvarchar(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]
75	Tax Liable	tinyint
76	VAT Bus_ Posting Group	nvarchar(40)
77	VAT Base Discount _	decimal(38,38)
78	Dimension Set ID	int
79	Campaign No_	nvarchar(40)
80	Buy-from Contact No_	nvarchar(40)
81	Pay-to Contact No_	nvarchar(40)
82	Responsibility Center	nvarchar(20)
83	Vendor Authorization No_	nvarchar(70)
84	Return Order No_	nvarchar(40)
85	Return Order No_ Series	nvarchar(40)
86	Price Calculation Method	int
87	$systemId	uniqueidentifier
88	$systemCreatedAt	datetime
89	$systemCreatedBy	uniqueidentifier
90	$systemModifiedAt	datetime
91	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Return Shipment Header table

Currency Customer Language Location Payment Method Payment Terms Shipment Method Tax Area Vendor

Dynamics 365 BC Table Reference Tables Company Tables RReturn Shipment Header

Leave a Reply Cancel reply