Purch. Cr. Memo Entity Buffer

Dynamics 365 BC Table ReferenceTablesCompany TablesPPurch. Cr. Memo Entity Buffer

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

Table Type: Company

Table Name: Purch. Cr. Memo Entity Buffer
Database Table Name: CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972

Table Number: 5508

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 Entity Buffer can be queried.

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$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 Address]
   ,[Pay-to Address 2]
   ,[Pay-to City]
   ,[Pay-to Contact]
   ,[Posting Date]
   ,[Payment Terms Code]
   ,[Due Date]
   ,[Shipment Method Code]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Vendor Posting Group]
   ,[Currency Code]
   ,[Prices Including VAT]
   ,[Purchaser Code]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Amount]
   ,[Amount Including VAT]
   ,[Reason Code]
   ,[Buy-from Vendor Name]
   ,[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]
   ,[Document Date]
   ,[Vendor Ledger Entry No_]
   ,[Invoice Discount Amount]
   ,[Buy-from Contact No_]
   ,[Id]
   ,[Total Tax Amount]
   ,[Status]
   ,[Posted]
   ,[Discount Applied Before Tax]
   ,[Vendor Id]
   ,[Currency Id]
   ,[Payment Terms Id]
   ,[Shipment Method Id]
   ,[Pay-to Vendor Id]
   ,[Reason Code Id]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$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 Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch. Cr. Memo Entity Buffer].[Pay-to Name] = [Vendor].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purch. Cr. Memo Entity Buffer].[Pay-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Purch. Cr. Memo Entity Buffer].[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 Entity Buffer].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purch. Cr. Memo Entity Buffer].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purch. Cr. Memo Entity Buffer].[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 Entity Buffer].[Vendor Posting Group] = [Vendor Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purch. Cr. Memo Entity Buffer].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Purch. Cr. Memo Entity Buffer].[Purchaser Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Purch. Cr. Memo Entity Buffer].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch. Cr. Memo Entity Buffer].[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 Entity Buffer].[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 Entity Buffer].[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 Entity Buffer].[Buy-from Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch. Cr. Memo Entity Buffer].[Vendor Id] = [Vendor].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purch. Cr. Memo Entity Buffer].[Currency Id] = [Currency].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Purch. Cr. Memo Entity Buffer].[Payment Terms Id] = [Payment Terms].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Purch. Cr. Memo Entity Buffer].[Shipment Method Id] = [Shipment Method].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch. Cr. Memo Entity Buffer].[Pay-to Vendor Id] = [Vendor].[$systemId]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Purch. Cr. Memo Entity Buffer].[Reason Code Id] = [Reason Code].[$systemId]
LEFT JOIN
   [User] AS [User]
      ON
         [Purch. Cr. Memo Entity Buffer].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Purch. Cr. Memo Entity Buffer].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Purch. Cr. Memo Entity Buffer 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 Entity Buffer].[Buy-from Vendor No_]
	       ,[Vendor].[No_]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Buy-from Vendor No_] = [Vendor].[No_]
3No. SearchNo.NormalCode20No_nvarchar(40)
4Pay-to Vendor No. Primary Key SearchPay-to Vendor No.NormalCode20Pay-to Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Pay-to Vendor No_]
	       ,[Vendor].[No_]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Pay-to Vendor No_] = [Vendor].[No_]
5Pay-to Name SearchPay-to NameNormalText100Pay-to Namenvarchar(200)
Key to join to the Vendor table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Pay-to Name]
	       ,[Vendor].[Name]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Pay-to Name] = [Vendor].[Name]
7Pay-to Address SearchPay-to AddressNormalText100Pay-to Addressnvarchar(200)
8Pay-to Address 2 SearchPay-to Address 2NormalText50Pay-to Address 2nvarchar(100)
9Pay-to City SearchPay-to CityNormalText30Pay-to Citynvarchar(60)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Pay-to City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Pay-to City] = [Post Code].[City]
10Pay-to Contact SearchPay-to ContactNormalText100Pay-to Contactnvarchar(200)
20Posting Date SearchPosting DateNormalDate4Posting Datedatetime
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 Entity Buffer].[Payment Terms Code]
	       ,[Payment Terms].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Payment Terms Code] = [Payment Terms].[Code]
24Due Date SearchDue DateNormalDate4Due 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 Entity Buffer].[Shipment Method Code]
	       ,[Shipment Method].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Shipment Method Code] = [Shipment Method].[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 Entity Buffer].[Shortcut Dimension 1 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[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 Entity Buffer].[Shortcut Dimension 2 Code]
	       ,[Dimension].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[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 Entity Buffer].[Vendor Posting Group]
	       ,[Vendor Posting Group].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[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 Entity Buffer].[Currency Code]
	       ,[Currency].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Currency Code] = [Currency].[Code]
35Prices Including VAT SearchPrices Including TaxNormalBoolean4Prices Including VATtinyint
43Purchaser Code SearchPurchaser CodeNormalCode20Purchaser Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Purchaser Code]
	       ,[Salesperson/Purchaser].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Purchaser Code] = [Salesperson/Purchaser].[Code]
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)
60Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
61Amount Including VAT SearchAmount Including TaxNormalDecimal12Amount Including VATdecimal(38,38)
73Reason Code SearchReason CodeNormalCode10Reason Codenvarchar(20)
Key to join to the Reason Code table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Reason Code]
	       ,[Reason Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Reason Code] = [Reason Code].[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 Entity Buffer].[Buy-from Vendor Name]
	       ,[Vendor].[Name]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Buy-from Vendor Name] = [Vendor].[Name]
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 Entity Buffer].[Buy-from City]
	       ,[Post Code].[City]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Buy-from City] = [Post Code].[City]
84Buy-from Contact SearchBuy-from ContactNormalText100Buy-from Contactnvarchar(200)
85Pay-to Post Code SearchPay-to ZIP CodeNormalCode20Pay-to Post Codenvarchar(40)
Key to join to the Post Code table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Pay-to Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Pay-to Post Code] = [Post Code].[Code]
86Pay-to County SearchPay-to StateNormalText30Pay-to Countynvarchar(60)
87Pay-to Country/Region Code SearchPay-to Country/Region CodeNormalCode10Pay-to Country_Region Codenvarchar(20)
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 Entity Buffer].[Buy-from Post Code]
	       ,[Post Code].[Code]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[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)
99Document Date SearchDocument DateNormalDate4Document Datedatetime
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 Entity Buffer].[Vendor Ledger Entry No_]
	       ,[Vendor Ledger Entry].[Entry No_]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor Ledger Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Ledger Entry]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Vendor Ledger Entry No_] = [Vendor Ledger Entry].[Entry No_]
1305Invoice Discount Amount SearchInvoice Discount AmountNormalDecimal12Invoice Discount Amountdecimal(38,38)
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 Entity Buffer].[Buy-from Contact No_]
	       ,[Contact].[No_]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Buy-from Contact No_] = [Contact].[No_]
8000Id SearchIdNormalGUID16Iduniqueidentifier
9600Total Tax Amount SearchTotal Tax AmountNormalDecimal12Total Tax Amountdecimal(38,38)
9601Status SearchStatusNormalOption4Statusint
Available options are:
  • “Draft”
  • “In Review”
  • “Open”
  • “Canceled”
  • “Corrective”
  • “Paid”
9602Posted SearchPostedNormalBoolean4Postedtinyint
9624Discount Applied Before Tax Primary Key SearchDiscount Applied Before TaxNormalBoolean4Discount Applied Before Taxtinyint
9631Vendor Id SearchVendor IdNormalGUID16Vendor Iduniqueidentifier
Key to join to the Vendor table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Vendor Id]
	       ,[Vendor].[$systemId]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Vendor Id] = [Vendor].[$systemId]
9634Currency Id SearchCurrency IdNormalGUID16Currency Iduniqueidentifier
Key to join to the Currency table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Currency Id]
	       ,[Currency].[$systemId]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Currency Id] = [Currency].[$systemId]
9635Payment Terms Id SearchPayment Terms IdNormalGUID16Payment Terms Iduniqueidentifier
Key to join to the Payment Terms table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Payment Terms Id]
	       ,[Payment Terms].[$systemId]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Payment Terms Id] = [Payment Terms].[$systemId]
9636Shipment Method Id SearchShipment Method IdNormalGUID16Shipment Method Iduniqueidentifier
Key to join to the Shipment Method table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Shipment Method Id]
	       ,[Shipment Method].[$systemId]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Shipment Method Id] = [Shipment Method].[$systemId]
9638Pay-to Vendor Id SearchPay-to Vendor IdNormalGUID16Pay-to Vendor Iduniqueidentifier
Key to join to the Vendor table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Pay-to Vendor Id]
	       ,[Vendor].[$systemId]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Pay-to Vendor Id] = [Vendor].[$systemId]
9639Reason Code Id SearchReason Code IdNormalGUID16Reason Code Iduniqueidentifier
Key to join to the Reason Code table.

Show/hide example query

SELECT
	       [Purch. Cr. Memo Entity Buffer].[Reason Code Id]
	       ,[Reason Code].[$systemId]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[Reason Code Id] = [Reason Code].[$systemId]
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 Entity Buffer].[$systemCreatedBy]
	       ,[User].[User Security ID]
	FROM
	       [CRONUS UK Ltd_$Purch_ Cr_ Memo Entity Buffer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Cr. Memo Entity Buffer]
	LEFT JOIN
	       [User] AS [User]
	              ON
	                     [Purch. Cr. Memo Entity Buffer].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier

Show/hide tables related from Purch. Cr. Memo Entity Buffer table

CurrencyPayment TermsSalesperson/PurchaserSalesperson/PurchaserShipment MethodVendor Posting Group
Dynamics 365 BC Table ReferenceTablesCompany TablesPPurch. Cr. Memo Entity Buffer

Leave a Reply

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