Service Cr_Memo Header

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

Table Type: Company

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

Table Number: 5994

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[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]
   ,[Posting Date]
   ,[Posting Description]
   ,[Payment Terms Code]
   ,[Due Date]
   ,[Payment Discount _]
   ,[Pmt_ Discount Date]
   ,[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]
   ,[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]
   ,[Name]
   ,[Name 2]
   ,[Address]
   ,[Address 2]
   ,[City]
   ,[Contact Name]
   ,[Bill-to Post Code]
   ,[Bill-to County]
   ,[Bill-to Country_Region Code]
   ,[Post Code]
   ,[County]
   ,[Country_Region Code]
   ,[Ship-to Post Code]
   ,[Ship-to County]
   ,[Ship-to Country_Region Code]
   ,[Bal_ Account Type]
   ,[Exit Point]
   ,[Correction]
   ,[Document Date]
   ,[Area]
   ,[Transaction Specification]
   ,[Payment Method Code]
   ,[Pre-Assigned No_ Series]
   ,[No_ Series]
   ,[Pre-Assigned No_]
   ,[User ID]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Base Discount _]
   ,[Company Bank Account Code]
   ,[Dimension Set ID]
   ,[Document Exchange Identifier]
   ,[Document Exchange Status]
   ,[Doc_ Exch_ Original Identifier]
   ,[Contact No_]
   ,[Bill-to Contact No_]
   ,[Responsibility Center]
   ,[Description]
   ,[Service Order Type]
   ,[Link Service to Service Item]
   ,[Priority]
   ,[Phone No_]
   ,[E-Mail]
   ,[Phone No_ 2]
   ,[Fax No_]
   ,[Order Time]
   ,[Default Response Time (Hours)]
   ,[Actual Response Time (Hours)]
   ,[Service Time (Hours)]
   ,[Response Date]
   ,[Response Time]
   ,[Starting Date]
   ,[Starting Time]
   ,[Finishing Date]
   ,[Finishing Time]
   ,[Notify Customer]
   ,[Max_ Labor Unit Price]
   ,[Warning Status]
   ,[Contract No_]
   ,[Ship-to Fax No_]
   ,[Ship-to E-Mail]
   ,[Ship-to Phone]
   ,[Ship-to Phone 2]
   ,[Service Zone Code]
   ,[Expected Finishing Date]
   ,[Price Calculation Method]
   ,[Allow Line Disc_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Service Cr_Memo 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_$Service Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Header]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Cr_Memo Header].[Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Service Cr_Memo Header].[Bill-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Service Cr_Memo Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Service Cr_Memo Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Service Cr_Memo Header].[Customer Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Service Cr_Memo Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Price Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Price Group]
      ON
         [Service Cr_Memo 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
         [Service Cr_Memo Header].[Customer Disc_ Group] = [Customer Discount Group].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Service Cr_Memo Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
      ON
         [Service Cr_Memo Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
      ON
         [Service Cr_Memo Header].[Country_Region Code] = [Country_Region].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Service Cr_Memo Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Service Cr_Memo Header].[Tax Area Code] = [Tax Area].[Code]

Show/hide columns in Service Cr_Memo Header table

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

Show/hide example query

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

Show/hide example query

SELECT
       [Service Cr_Memo Header].[Bill-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Service Cr_Memo 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)
19Posting Date Searchdatetime
20Posting Description Searchnvarchar(200)
21Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Service Cr_Memo Header].[Salesperson Code]
       ,[Salesperson_Purchaser].[No_]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson_Purchaser]
              ON
                     [Service Cr_Memo Header].[Salesperson Code] = [Salesperson_Purchaser].[No_]
37No_ Printed Searchint
38Applies-to Doc_ Type Searchint
39Applies-to Doc_ No_ Searchnvarchar(40)
40Bal_ Account No_ Searchnvarchar(40)
41VAT Registration No_ Searchnvarchar(40)
42Reason Code Searchnvarchar(20)
43Gen_ Bus_ Posting Group Searchnvarchar(40)
44EU 3-Party Trade Searchtinyint
45Transaction Type Searchnvarchar(20)
46Transport Method Searchnvarchar(20)
47VAT Country_Region Code Searchnvarchar(20)
48Name Searchnvarchar(200)
49Name 2 Searchnvarchar(100)
50Address Searchnvarchar(200)
51Address 2 Searchnvarchar(100)
52City Searchnvarchar(60)
53Contact Name Searchnvarchar(200)
54Bill-to Post Code Searchnvarchar(40)
55Bill-to County Searchnvarchar(60)
56Bill-to Country_Region Code Searchnvarchar(20)
57Post Code Searchnvarchar(40)
58County Searchnvarchar(60)
59Country_Region Code Searchnvarchar(20)
Key to join to the Country_Region table.

Show/hide example query

SELECT
       [Service Cr_Memo Header].[Country_Region Code]
       ,[Country_Region].[Code]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country_Region]
              ON
                     [Service Cr_Memo Header].[Country_Region Code] = [Country_Region].[Code]
60Ship-to Post Code Searchnvarchar(40)
61Ship-to County Searchnvarchar(60)
62Ship-to Country_Region Code Searchnvarchar(20)
63Bal_ Account Type Searchint
64Exit Point Searchnvarchar(20)
65Correction Searchtinyint
66Document Date Searchdatetime
67Area Searchnvarchar(20)
68Transaction Specification Searchnvarchar(20)
69Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

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

Show/hide example query

SELECT
       [Service Cr_Memo Header].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Service Cr_Memo Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Service Cr_Memo Header]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Service Cr_Memo Header].[Tax Area Code] = [Tax Area].[Code]
76Tax Liable Searchtinyint
77VAT Bus_ Posting Group Searchnvarchar(40)
78VAT Base Discount _ Searchdecimal(38,38)
79Company Bank Account Code Searchnvarchar(40)
80Dimension Set ID Searchint
81Document Exchange Identifier Searchnvarchar(100)
82Document Exchange Status Searchint
83Doc_ Exch_ Original Identifier Searchnvarchar(100)
84Contact No_ Searchnvarchar(40)
85Bill-to Contact No_ Searchnvarchar(40)
86Responsibility Center Searchnvarchar(20)
87Description Searchnvarchar(200)
88Service Order Type Searchnvarchar(20)
89Link Service to Service Item Searchtinyint
90Priority Searchint
91Phone No_ Searchnvarchar(60)
92E-Mail Searchnvarchar(160)
93Phone No_ 2 Searchnvarchar(60)
94Fax No_ Searchnvarchar(60)
95Order Time Searchdatetime
96Default Response Time (Hours) Searchdecimal(38,38)
97Actual Response Time (Hours) Searchdecimal(38,38)
98Service Time (Hours) Searchdecimal(38,38)
99Response Date Searchdatetime
100Response Time Searchdatetime
101Starting Date Searchdatetime
102Starting Time Searchdatetime
103Finishing Date Searchdatetime
104Finishing Time Searchdatetime
105Notify Customer Searchint
106Max_ Labor Unit Price Searchdecimal(38,38)
107Warning Status Searchint
108Contract No_ Searchnvarchar(40)
109Ship-to Fax No_ Searchnvarchar(60)
110Ship-to E-Mail Searchnvarchar(160)
111Ship-to Phone Searchnvarchar(60)
112Ship-to Phone 2 Searchnvarchar(60)
113Service Zone Code Searchnvarchar(20)
114Expected Finishing Date Searchdatetime
115Price Calculation Method Searchint
116Allow Line Disc_ Searchtinyint
117$systemId Searchuniqueidentifier
118$systemCreatedAt Searchdatetime
119$systemCreatedBy Searchuniqueidentifier
120$systemModifiedAt Searchdatetime
121$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Service Cr_Memo Header table

Leave a Reply

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