Easily find this page again using the shortlink: https://bct.azrcrv.co.uk/124
Table Type: Company
Table Name: Purch_ Cr_ Memo Hdr_
Database Table Name: CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972
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 Purch_ Cr_ Memo Hdr_ can be queried.
Show/hide an example select of all columns
SELECT
*
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$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]
,[Prices Including VAT]
,[Invoice Disc_ Code]
,[Language Code]
,[Purchaser Code]
,[No_ Printed]
,[On Hold]
,[Applies-to Doc_ Type]
,[Applies-to Doc_ No_]
,[Bal_ Account No_]
,[Vendor Cr_ Memo 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]
,[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 _]
,[Prepmt_ Cr_ Memo No_ Series]
,[Prepayment Credit Memo]
,[Prepayment Order No_]
,[Dimension Set ID]
,[Vendor Ledger Entry No_]
,[Campaign No_]
,[Buy-from Contact No_]
,[Pay-to Contact No_]
,[Responsibility Center]
,[Return Order No_]
,[Return Order No_ Series]
,[Price Calculation Method]
,[Type of Supply Code]
,[$systemId]
,[$systemCreatedAt]
,[$systemCreatedBy]
,[$systemModifiedAt]
,[$systemModifiedBy]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972]Show/hide an example select of all columns including those from all joined tables
SELECT
*
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
ON
[Purch_ Cr_ Memo Hdr_].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
ON
[Purch_ Cr_ Memo Hdr_].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Purch_ Cr_ Memo Hdr_].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
ON
[Purch_ Cr_ Memo Hdr_].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Purch_ Cr_ Memo Hdr_].[Location Code] = [Location].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Purch_ Cr_ Memo Hdr_].[Currency Code] = [Currency].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Purch_ Cr_ Memo Hdr_].[Language Code] = [Language].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Purch_ Cr_ Memo Hdr_].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
[CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
ON
[Purch_ Cr_ Memo Hdr_].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Purch_ Cr_ Memo Hdr_].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
[CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
ON
[Purch_ Cr_ Memo Hdr_].[Type of Supply Code] = [Type of Supply].[Code]Show/hide columns in Purch_ Cr_ Memo Hdr_ 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 querySELECT
[Purch_ Cr_ Memo Hdr_].[Buy-from Vendor No_]
,[Vendor].[No_]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
ON
[Purch_ Cr_ Memo Hdr_].[Buy-from Vendor No_] = [Vendor].[No_] | ||||||
| 4 | Pay-to Vendor No_ | nvarchar(40) | ||||
Key to join to the Vendor table.Show/hide example querySELECT
[Purch_ Cr_ Memo Hdr_].[Pay-to Vendor No_]
,[Vendor].[No_]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
ON
[Purch_ Cr_ Memo Hdr_].[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 querySELECT
[Purch_ Cr_ Memo Hdr_].[Payment Terms Code]
,[Payment Terms].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
ON
[Purch_ Cr_ Memo Hdr_].[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 querySELECT
[Purch_ Cr_ Memo Hdr_].[Shipment Method Code]
,[Shipment Method].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
ON
[Purch_ Cr_ Memo Hdr_].[Shipment Method Code] = [Shipment Method].[Code] | ||||||
| 27 | Location Code | nvarchar(20) | ||||
Key to join to the Location table.Show/hide example querySELECT
[Purch_ Cr_ Memo Hdr_].[Location Code]
,[Location].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
ON
[Purch_ Cr_ Memo Hdr_].[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 querySELECT
[Purch_ Cr_ Memo Hdr_].[Currency Code]
,[Currency].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
ON
[Purch_ Cr_ Memo Hdr_].[Currency Code] = [Currency].[Code] | ||||||
| 32 | Currency Factor | decimal(38,38) | ||||
| 33 | Prices Including VAT | tinyint | ||||
| 34 | Invoice Disc_ Code | nvarchar(40) | ||||
| 35 | Language Code | nvarchar(20) | ||||
Key to join to the Language table.Show/hide example querySELECT
[Purch_ Cr_ Memo Hdr_].[Language Code]
,[Language].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
ON
[Purch_ Cr_ Memo Hdr_].[Language Code] = [Language].[Code] | ||||||
| 36 | Purchaser Code | nvarchar(40) | ||||
| 37 | No_ Printed | int | ||||
| 38 | On Hold | nvarchar(6) | ||||
| 39 | Applies-to Doc_ Type | int | ||||
| 40 | Applies-to Doc_ No_ | nvarchar(40) | ||||
| 41 | Bal_ Account No_ | nvarchar(40) | ||||
| 42 | Vendor Cr_ Memo No_ | nvarchar(70) | ||||
| 43 | VAT Registration No_ | nvarchar(40) | ||||
| 44 | Sell-to Customer No_ | nvarchar(40) | ||||
Key to join to the Customer table.Show/hide example querySELECT
[Purch_ Cr_ Memo Hdr_].[Sell-to Customer No_]
,[Customer].[No_]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
ON
[Purch_ Cr_ Memo Hdr_].[Sell-to Customer No_] = [Customer].[No_] | ||||||
| 45 | Reason Code | nvarchar(20) | ||||
| 46 | Gen_ Bus_ Posting Group | nvarchar(40) | ||||
| 47 | Transaction Type | nvarchar(20) | ||||
| 48 | Transport Method | nvarchar(20) | ||||
| 49 | VAT Country_Region Code | nvarchar(20) | ||||
| 50 | Buy-from Vendor Name | nvarchar(200) | ||||
| 51 | Buy-from Vendor Name 2 | nvarchar(100) | ||||
| 52 | Buy-from Address | nvarchar(200) | ||||
| 53 | Buy-from Address 2 | nvarchar(100) | ||||
| 54 | Buy-from City | nvarchar(60) | ||||
| 55 | Buy-from Contact | nvarchar(200) | ||||
| 56 | Pay-to Post Code | nvarchar(40) | ||||
| 57 | Pay-to County | nvarchar(60) | ||||
| 58 | Pay-to Country_Region Code | nvarchar(20) | ||||
| 59 | Buy-from Post Code | nvarchar(40) | ||||
| 60 | Buy-from County | nvarchar(60) | ||||
| 61 | Buy-from Country_Region Code | nvarchar(20) | ||||
| 62 | Ship-to Post Code | nvarchar(40) | ||||
| 63 | Ship-to County | nvarchar(60) | ||||
| 64 | Ship-to Country_Region Code | nvarchar(20) | ||||
| 65 | Bal_ Account Type | int | ||||
| 66 | Order Address Code | nvarchar(20) | ||||
| 67 | Entry Point | nvarchar(20) | ||||
| 68 | Correction | tinyint | ||||
| 69 | Document Date | datetime | ||||
| 70 | Area | nvarchar(20) | ||||
| 71 | Transaction Specification | nvarchar(20) | ||||
| 72 | Payment Method Code | nvarchar(20) | ||||
Key to join to the Payment Method table.Show/hide example querySELECT
[Purch_ Cr_ Memo Hdr_].[Payment Method Code]
,[Payment Method].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
ON
[Purch_ Cr_ Memo Hdr_].[Payment Method Code] = [Payment Method].[Code] | ||||||
| 73 | Pre-Assigned No_ Series | nvarchar(40) | ||||
| 74 | No_ Series | nvarchar(40) | ||||
| 75 | Pre-Assigned No_ | nvarchar(40) | ||||
| 76 | User ID | nvarchar(100) | ||||
| 77 | Source Code | nvarchar(20) | ||||
| 78 | Tax Area Code | nvarchar(40) | ||||
Key to join to the Tax Area table.Show/hide example querySELECT
[Purch_ Cr_ Memo Hdr_].[Tax Area Code]
,[Tax Area].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
ON
[Purch_ Cr_ Memo Hdr_].[Tax Area Code] = [Tax Area].[Code] | ||||||
| 79 | Tax Liable | tinyint | ||||
| 80 | VAT Bus_ Posting Group | nvarchar(40) | ||||
| 81 | VAT Base Discount _ | decimal(38,38) | ||||
| 82 | Prepmt_ Cr_ Memo No_ Series | nvarchar(40) | ||||
| 83 | Prepayment Credit Memo | tinyint | ||||
| 84 | Prepayment Order No_ | nvarchar(40) | ||||
| 85 | Dimension Set ID | int | ||||
| 86 | Vendor Ledger Entry No_ | int | ||||
| 87 | Campaign No_ | nvarchar(40) | ||||
| 88 | Buy-from Contact No_ | nvarchar(40) | ||||
| 89 | Pay-to Contact No_ | nvarchar(40) | ||||
| 90 | Responsibility Center | nvarchar(20) | ||||
| 91 | Return Order No_ | nvarchar(40) | ||||
| 92 | Return Order No_ Series | nvarchar(40) | ||||
| 93 | Price Calculation Method | int | ||||
| 94 | Type of Supply Code | nvarchar(20) | ||||
Key to join to the Type of Supply table.Show/hide example querySELECT
[Purch_ Cr_ Memo Hdr_].[Type of Supply Code]
,[Type of Supply].[Code]
FROM
[CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Cr_ Memo Hdr_]
LEFT JOIN
[CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
ON
[Purch_ Cr_ Memo Hdr_].[Type of Supply Code] = [Type of Supply].[Code] | ||||||
| 95 | $systemId | uniqueidentifier | ||||
| 96 | $systemCreatedAt | datetime | ||||
| 97 | $systemCreatedBy | uniqueidentifier | ||||
| 98 | $systemModifiedAt | datetime | ||||
| 99 | $systemModifiedBy | uniqueidentifier | ||||