Purch. Cr. Memo Hdr.

Dynamics 365 BC Table ReferenceTablesCompany TablesPPurch. Cr. Memo Hdr.

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

Table Number: 124

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

   [Buy-from Vendor No_]
   ,[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]
   ,[Format Region]
   ,[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_]
   ,[VAT Reporting Date]
   ,[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]
   ,[$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.].[Pay-to Name] = [Vendor].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Cr. Memo Hdr.].[Pay-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Purch. Cr. Memo Hdr.].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Cr. Memo Hdr.].[Ship-to City] = [Post Code].[City]
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_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purch. Cr. Memo Hdr.].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purch. Cr. Memo Hdr.].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
      ON
         [Purch. Cr. Memo Hdr.].[Vendor Posting Group] = [Vendor Posting Group].[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_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Purch. Cr. Memo Hdr.].[Purchaser Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Purch. Cr. Memo Hdr.].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Purch. Cr. Memo Hdr.].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Purch. Cr. Memo Hdr.].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch. Cr. Memo Hdr.].[Buy-from Vendor Name] = [Vendor].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Cr. Memo Hdr.].[Buy-from City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Cr. Memo Hdr.].[Pay-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Cr. Memo Hdr.].[Buy-from Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Cr. Memo Hdr.].[Ship-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
      ON
         [Purch. Cr. Memo Hdr.].[Entry Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Purch. Cr. Memo Hdr.].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Purch. Cr. Memo Hdr.].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Purch. Cr. Memo Hdr.].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
      ON
         [Purch. Cr. Memo Hdr.].[Source Code] = [Source Code].[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_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Purch. Cr. Memo Hdr.].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Purch. Cr. Memo Hdr.].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Purch. Cr. Memo Hdr.].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Purch. Cr. Memo Hdr.].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Purch. Cr. Memo Hdr. table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
2Buy-from Vendor No. SearchBuy-from Vendor No.NormalCode20Buy-from Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [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_]
3No. Primary Key SearchNo.NormalCode20No_nvarchar(40)
4Pay-to Vendor No. SearchVendor No.NormalCode20Pay-to Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [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_]
5Pay-to Name SearchNameNormalText100Pay-to Namenvarchar(200)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Pay-to Name]
       ,[Vendor].[Name]
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 Name] = [Vendor].[Name]
6Pay-to Name 2 SearchName 2NormalText50Pay-to Name 2nvarchar(100)
7Pay-to Address SearchAddressNormalText100Pay-to Addressnvarchar(200)
8Pay-to Address 2 SearchAddress 2NormalText50Pay-to Address 2nvarchar(100)
9Pay-to City SearchCityNormalText30Pay-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Pay-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purch. Cr. Memo Hdr.].[Pay-to City] = [Post Code].[City]
10Pay-to Contact SearchContactNormalText100Pay-to Contactnvarchar(200)
11Your Reference SearchYour ReferenceNormalText35Your Referencenvarchar(70)
12Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Purch. Cr. Memo Hdr.].[Ship-to Code] = [Ship-to Address].[Code]
13Ship-to Name SearchShip-to NameNormalText100Ship-to Namenvarchar(200)
14Ship-to Name 2 SearchShip-to Name 2NormalText50Ship-to Name 2nvarchar(100)
15Ship-to Address SearchShip-to AddressNormalText100Ship-to Addressnvarchar(200)
16Ship-to Address 2 SearchShip-to Address 2NormalText50Ship-to Address 2nvarchar(100)
17Ship-to City SearchShip-to CityNormalText30Ship-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Ship-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purch. Cr. Memo Hdr.].[Ship-to City] = [Post Code].[City]
18Ship-to Contact SearchShip-to ContactNormalText100Ship-to Contactnvarchar(200)
20Posting Date SearchPosting DateNormalDate4Posting Datedatetime
21Expected Receipt Date SearchExpected Receipt DateNormalDate4Expected Receipt Datedatetime
22Posting Description SearchPosting DescriptionNormalText100Posting Descriptionnvarchar(200)
23Payment Terms Code SearchPayment Terms CodeNormalCode10Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [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]
24Due Date SearchDue DateNormalDate4Due Datedatetime
25Payment Discount % SearchPayment Discount %NormalDecimal12Payment Discount _decimal(38,38)
26Pmt. Discount Date SearchPmt. Discount DateNormalDate4Pmt_ Discount Datedatetime
27Shipment Method Code SearchShipment Method CodeNormalCode10Shipment Method Codenvarchar(20)
Key to join to the Shipment Method table.

Show/hide example query

SELECT
       [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]
28Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [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]
29Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Purch. Cr. Memo Hdr.].[Shortcut Dimension 1 Code] = [Dimension].[Code]
30Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Purch. Cr. Memo Hdr.].[Shortcut Dimension 2 Code] = [Dimension].[Code]
31Vendor Posting Group SearchVendor Posting GroupNormalCode20Vendor Posting Groupnvarchar(40)
Key to join to the Vendor Posting Group table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Vendor Posting Group]
       ,[Vendor Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
              ON
                     [Purch. Cr. Memo Hdr.].[Vendor Posting Group] = [Vendor Posting Group].[Code]
32Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [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]
33Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
35Prices Including VAT SearchPrices Including TaxNormalBoolean4Prices Including VATtinyint
37Invoice Disc. Code SearchInvoice Disc. CodeNormalCode20Invoice Disc_ Codenvarchar(40)
41Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [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]
42Format Region SearchFormat RegionNormalText80Format Regionnvarchar(160)
43Purchaser Code SearchPurchaser CodeNormalCode20Purchaser Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Purchaser Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Purch. Cr. Memo Hdr.].[Purchaser Code] = [Salesperson/Purchaser].[Code]
46Comment SearchCommentFlowFieldBoolean4
47No. Printed SearchNo. PrintedNormalInteger4No_ Printedint
51On Hold SearchOn HoldNormalCode3On Holdnvarchar(6)
52Applies-to Doc. Type SearchApplies-to Doc. TypeNormalOption4Applies-to Doc_ Typeint
Available options are:
  • ” “
  • “Payment”
  • “Invoice”
  • “Credit Memo”
  • “Finance Charge Memo”
  • “Reminder”
  • “Refund”
53Applies-to Doc. No. SearchApplies-to Doc. No.NormalCode20Applies-to Doc_ No_nvarchar(40)
55Bal. Account No. SearchBal. Account No.NormalCode20Bal_ Account No_nvarchar(40)
60Amount SearchAmountFlowFieldDecimal12
61Amount Including VAT SearchAmount Including TaxFlowFieldDecimal12
69Vendor Cr. Memo No. SearchVendor Cr. Memo No.NormalCode35Vendor Cr_ Memo No_nvarchar(70)
70VAT Registration No. SearchTax Registration No.NormalText20VAT Registration No_nvarchar(40)
72Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [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_]
73Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Purch. Cr. Memo Hdr.].[Reason Code] = [Reason Code].[Code]
74Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Purch. Cr. Memo Hdr.].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
76Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Purch. Cr. Memo Hdr.].[Transaction Type] = [Transaction Type].[Code]
77Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Transport Method]
       ,[Transport 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_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Purch. Cr. Memo Hdr.].[Transport Method] = [Transport Method].[Code]
78VAT Country/Region Code SearchTax Country/Region CodeNormalCode10VAT Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[VAT Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purch. Cr. Memo Hdr.].[VAT Country_Region Code] = [Country/Region].[Code]
79Buy-from Vendor Name SearchBuy-from Vendor NameNormalText100Buy-from Vendor Namenvarchar(200)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Buy-from Vendor Name]
       ,[Vendor].[Name]
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 Name] = [Vendor].[Name]
80Buy-from Vendor Name 2 SearchBuy-from Vendor Name 2NormalText50Buy-from Vendor Name 2nvarchar(100)
81Buy-from Address SearchBuy-from AddressNormalText100Buy-from Addressnvarchar(200)
82Buy-from Address 2 SearchBuy-from Address 2NormalText50Buy-from Address 2nvarchar(100)
83Buy-from City SearchBuy-from CityNormalText30Buy-from Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Buy-from City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purch. Cr. Memo Hdr.].[Buy-from City] = [Post Code].[City]
84Buy-from Contact SearchBuy-from ContactNormalText100Buy-from Contactnvarchar(200)
85Pay-to Post Code SearchZIP CodeNormalCode20Pay-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Pay-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purch. Cr. Memo Hdr.].[Pay-to Post Code] = [Post Code].[Code]
86Pay-to County SearchStateNormalText30Pay-to Countynvarchar(60)
87Pay-to Country/Region Code SearchCountry/Region CodeNormalCode10Pay-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Pay-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purch. Cr. Memo Hdr.].[Pay-to Country_Region Code] = [Country/Region].[Code]
88Buy-from Post Code SearchBuy-from ZIP CodeNormalCode20Buy-from Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Buy-from Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purch. Cr. Memo Hdr.].[Buy-from Post Code] = [Post Code].[Code]
89Buy-from County SearchBuy-from StateNormalText30Buy-from Countynvarchar(60)
90Buy-from Country/Region Code SearchBuy-from Country/Region CodeNormalCode10Buy-from Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Buy-from Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purch. Cr. Memo Hdr.].[Buy-from Country_Region Code] = [Country/Region].[Code]
91Ship-to Post Code SearchShip-to ZIP CodeNormalCode20Ship-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Ship-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purch. Cr. Memo Hdr.].[Ship-to Post Code] = [Post Code].[Code]
92Ship-to County SearchShip-to StateNormalText30Ship-to Countynvarchar(60)
93Ship-to Country/Region Code SearchShip-to Country/Region CodeNormalCode10Ship-to Country_Region Codenvarchar(20)
Key to join to the Country/Region table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Ship-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purch. Cr. Memo Hdr.].[Ship-to Country_Region Code] = [Country/Region].[Code]
94Bal. Account Type SearchBal. Account TypeNormalOption4Bal_ Account Typeint
Available options are:
  • “G/L Account”
  • “Bank Account”
95Order Address Code SearchOrder Address CodeNormalCode10Order Address Codenvarchar(20)
97Entry Point SearchEntry PointNormalCode10Entry Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Entry Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Purch. Cr. Memo Hdr.].[Entry Point] = [Entry/Exit Point].[Code]
98Correction SearchCorrectionNormalBoolean4Correctiontinyint
99Document Date SearchDocument DateNormalDate4Document Datedatetime
101Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Area]
       ,[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_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Purch. Cr. Memo Hdr.].[Area] = [Area].[Code]
102Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Purch. Cr. Memo Hdr.].[Transaction Specification] = [Transaction Specification].[Code]
104Payment Method Code SearchPayment Method CodeNormalCode10Payment Method Codenvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [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$ext] AS [Payment Method]
              ON
                     [Purch. Cr. Memo Hdr.].[Payment Method Code] = [Payment Method].[Code]
107Pre-Assigned No. Series SearchPre-Assigned No. SeriesNormalCode20Pre-Assigned No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Pre-Assigned No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purch. Cr. Memo Hdr.].[Pre-Assigned No_ Series] = [No. Series].[Code]
108No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purch. Cr. Memo Hdr.].[No_ Series] = [No. Series].[Code]
111Pre-Assigned No. SearchPre-Assigned No.NormalCode20Pre-Assigned No_nvarchar(40)
112User ID SearchUser IDNormalCode50User IDnvarchar(100)
113Source Code SearchSource CodeNormalCode10Source Codenvarchar(20)
Key to join to the Source Code table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Source Code]
       ,[Source Code].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Source Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Source Code]
              ON
                     [Purch. Cr. Memo Hdr.].[Source Code] = [Source Code].[Code]
114Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [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]
115Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
116VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Purch. Cr. Memo Hdr.].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
119VAT Base Discount % SearchVAT Base Discount %NormalDecimal12VAT Base Discount _decimal(38,38)
138Prepmt. Cr. Memo No. Series SearchPrepmt. Cr. Memo No. SeriesNormalCode20Prepmt_ Cr_ Memo No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Prepmt_ Cr_ Memo No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purch. Cr. Memo Hdr.].[Prepmt_ Cr_ Memo No_ Series] = [No. Series].[Code]
140Prepayment Credit Memo SearchPrepayment Credit MemoNormalBoolean4Prepayment Credit Memotinyint
141Prepayment Order No. SearchPrepayment Order No.NormalCode20Prepayment Order No_nvarchar(40)
179VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Purch. Cr. Memo Hdr.].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
1302Paid SearchPaidFlowFieldBoolean4
1303Remaining Amount SearchRemaining AmountFlowFieldDecimal12
1304Vendor Ledger Entry No. SearchVendor Ledger Entry No.NormalInteger4Vendor Ledger Entry No_int
Key to join to the Vendor Ledger Entry table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Vendor Ledger Entry No_]
       ,[Vendor Ledger Entry].[Entry 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 Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry]
              ON
                     [Purch. Cr. Memo Hdr.].[Vendor Ledger Entry No_] = [Vendor Ledger Entry].[Entry No_]
1305Invoice Discount Amount SearchInvoice Discount AmountFlowFieldDecimal12
1310Cancelled SearchCanceledFlowFieldBoolean4
1311Corrective SearchCorrectiveFlowFieldBoolean4
5050Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Campaign No_]
       ,[Campaign].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
              ON
                     [Purch. Cr. Memo Hdr.].[Campaign No_] = [Campaign].[No_]
5052Buy-from Contact No. SearchBuy-from Contact No.NormalCode20Buy-from Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Buy-from Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Purch. Cr. Memo Hdr.].[Buy-from Contact No_] = [Contact].[No_]
5053Pay-to Contact No. SearchContact No.NormalCode20Pay-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Pay-to Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Purch. Cr. Memo Hdr.].[Pay-to Contact No_] = [Contact].[No_]
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Purch. Cr. Memo Hdr.].[Responsibility Center] = [Responsibility Center].[Code]
6601Return Order No. SearchReturn Order No.NormalCode20Return Order No_nvarchar(40)
6602Return Order No. Series SearchReturn Order No. SeriesNormalCode20Return Order No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[Return Order No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purch. Cr. Memo Hdr.].[Return Order No_ Series] = [No. Series].[Code]
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
8001Draft Cr. Memo SystemId SearchDraft Cr. Memo System IdNormalGUID16
10005Ship-to UPS Zone SearchShip-to UPS ZoneNormalCode2
10015Tax Exemption No. SearchTax Exemption No.NormalText30
10017Provincial Tax Area Code SearchProvincial Tax Area CodeNormalCode20
10018STE Transaction ID SearchSTE Transaction IDNormalText20
10020IRS 1099 Code SearchIRS 1099 CodeNormalCode10
10042Fiscal Invoice Number PAC SearchFiscal Invoice Number PACNormalText50
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [User] AS [User]
              ON
                     [Purch. Cr. Memo Hdr.].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Purch. Cr. Memo Hdr.].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Purch_ Cr_ Memo Hdr_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Hdr.]
LEFT JOIN
       [User] AS [User]
              ON
                     [Purch. Cr. Memo Hdr.].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Purch. Cr. Memo Hdr. table

CurrencyLanguageLocationPayment MethodPayment TermsResponsibility CenterSalesperson/PurchaserSalesperson/PurchaserShip-to AddressShipment MethodTax AreaVendor Posting Group
Dynamics 365 BC Table ReferenceTablesCompany TablesPPurch. Cr. Memo Hdr.

Leave a Reply

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