Return Receipt Header

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

Table Type: Company

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

Table Number: 6660

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

Show/hide an example select of all columns

SELECT
   *
FROM
   [CRONUS UK Ltd_$Return Receipt 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]
   ,[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]
   ,[User ID]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Base Discount _]
   ,[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]
   ,[Warehouse Handling Time]
   ,[Late Order Shipping]
   ,[Return Order No_]
   ,[Return Order No_ Series]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Return Receipt 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 Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Return Receipt Header].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Return Receipt Header].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Return Receipt Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Return Receipt Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Return Receipt Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Return Receipt Header].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Return Receipt Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Return Receipt 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
         [Return Receipt Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Return Receipt Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Return Receipt Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Return Receipt Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipping Agent$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipping Agent]
      ON
         [Return Receipt Header].[Shipping Agent Code] = [Shipping Agent].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Return Receipt Header].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
      ON
         [Return Receipt Header].[Opportunity No_] = [Opportunity].[No_]

Show/hide columns in Return Receipt 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
       [Return Receipt Header].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Return Receipt 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
       [Return Receipt Header].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Return Receipt 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
       [Return Receipt Header].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Return Receipt 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
       [Return Receipt Header].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Return Receipt Header].[Shipment Method Code] = [Shipment Method].[Code]
28Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Return Receipt Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Return Receipt 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
       [Return Receipt Header].[Customer Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Return Receipt Header].[Customer Posting Group] = [Customer Posting Group].[Code]
32Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Return Receipt Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Return Receipt 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
       [Return Receipt Header].[Customer Price Group]
       ,[Customer Price Group].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
              ON
                     [Return Receipt 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
       [Return Receipt Header].[Customer Disc_ Group]
       ,[Customer Discount Group].[No_]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Discount Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Discount Group]
              ON
                     [Return Receipt Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
38Language Code Searchnvarchar(20)
Key to join to the Language table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Return Receipt Header].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Return Receipt Header].[Tax Area Code] = [Tax Area].[Code]
81Tax Liable Searchtinyint
82VAT Bus_ Posting Group Searchnvarchar(40)
83VAT Base Discount _ Searchdecimal(38,38)
84Dimension Set ID Searchint
85Campaign No_ Searchnvarchar(40)
86Sell-to Contact No_ Searchnvarchar(40)
87Bill-to Contact No_ Searchnvarchar(40)
88Opportunity No_ Searchnvarchar(40)
Key to join to the Opportunity table.

Show/hide example query

SELECT
       [Return Receipt Header].[Opportunity No_]
       ,[Opportunity].[No_]
FROM
       [CRONUS UK Ltd_$Return Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Receipt Header]
LEFT JOIN
       [CRONUS UK Ltd_$Opportunity$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Opportunity]
              ON
                     [Return Receipt Header].[Opportunity No_] = [Opportunity].[No_]
89Responsibility Center Searchnvarchar(20)
90Requested Delivery Date Searchdatetime
91Promised Delivery Date Searchdatetime
92Shipping Time Searchvarchar(32)
93Warehouse Handling Time Searchvarchar(32)
94Late Order Shipping Searchtinyint
95Return Order No_ Searchnvarchar(40)
96Return Order No_ Series Searchnvarchar(40)
97Price Calculation Method Searchint
98Allow Line Disc_ Searchtinyint
99$systemId Searchuniqueidentifier
100$systemCreatedAt Searchdatetime
101$systemCreatedBy Searchuniqueidentifier
102$systemModifiedAt Searchdatetime
103$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Return Receipt Header table

Leave a Reply

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