Purchase Header

Dynamics 365 BC Table ReferenceTablesCompany TablesPPurchase Header

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

Table Type: Company

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

Table Number: 38

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Document Type]
   ,[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]
   ,[Order Date]
   ,[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]
   ,[Order Class]
   ,[No_ Printed]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account No_]
   ,[Receive]
   ,[Invoice]
   ,[Print Posted Documents]
   ,[Receiving No_]
   ,[Posting No_]
   ,[Last Receiving No_]
   ,[Last Posting No_]
   ,[Vendor Order No_]
   ,[Vendor Shipment No_]
   ,[Vendor Invoice 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]
   ,[No_ Series]
   ,[Posting No_ Series]
   ,[Receiving No_ Series]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[Applies-to ID]
   ,[VAT Base Discount _]
   ,[Status]
   ,[Invoice Discount Calculation]
   ,[Invoice Discount Value]
   ,[Send IC Document]
   ,[IC Status]
   ,[Buy-from IC Partner Code]
   ,[Pay-to IC Partner Code]
   ,[IC Reference Document No_]
   ,[IC Direction]
   ,[Prepayment No_]
   ,[Last Prepayment No_]
   ,[Prepmt_ Cr_ Memo No_]
   ,[Last Prepmt_ Cr_ Memo No_]
   ,[Prepayment _]
   ,[Prepayment No_ Series]
   ,[Compress Prepayment]
   ,[Prepayment Due Date]
   ,[Prepmt_ Cr_ Memo No_ Series]
   ,[Prepmt_ Posting Description]
   ,[Prepmt_ Pmt_ Discount Date]
   ,[Prepmt_ Payment Terms Code]
   ,[Prepmt_ Payment Discount _]
   ,[Quote No_]
   ,[Job Queue Status]
   ,[Job Queue Entry ID]
   ,[Incoming Document Entry No_]
   ,[Creditor No_]
   ,[Payment Reference]
   ,[Invoice Received Date]
   ,[Journal Templ_ Name]
   ,[VAT Reporting Date]
   ,[Dimension Set ID]
   ,[Remit-to Code]
   ,[Doc_ No_ Occurrence]
   ,[Campaign No_]
   ,[Buy-from Contact No_]
   ,[Pay-to Contact No_]
   ,[Responsibility Center]
   ,[Posting from Whse_ Ref_]
   ,[Requested Receipt Date]
   ,[Promised Receipt Date]
   ,[Lead Time Calculation]
   ,[Inbound Whse_ Handling Time]
   ,[Vendor Authorization No_]
   ,[Return Shipment No_]
   ,[Return Shipment No_ Series]
   ,[Ship]
   ,[Last Return Shipment No_]
   ,[Price Calculation Method]
   ,[Id]
   ,[Assigned User ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Purchase 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_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Purchase Header].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Purchase Header].[Document No_] = [Sales Header Archive].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Purchase Header].[Document Type] = [Sales Header].[Document Type]
      AND
         [Purchase Header].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Header].[Pay-to Name] = [Vendor].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Header].[Pay-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Purchase Header].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Header].[Ship-to City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Purchase Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Purchase Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purchase Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purchase Header].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purchase Header].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
      ON
         [Purchase Header].[Vendor Posting Group] = [Vendor Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purchase Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Purchase Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Purchase Header].[Purchaser Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
      ON
         [Purchase Header].[Reason Code] = [Reason Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Purchase Header].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Purchase Header].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Header].[Buy-from Vendor Name] = [Vendor].[Name]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Header].[Buy-from City] = [Post Code].[City]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Header].[Pay-to Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Header].[Buy-from Post Code] = [Post Code].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
      ON
         [Purchase Header].[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
         [Purchase Header].[Entry Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Purchase Header].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Purchase Header].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
      ON
         [Purchase Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purchase Header].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Purchase Header].[Buy-from IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Purchase Header].[Pay-to IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Purchase Header].[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
         [Purchase Header].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purchase Header].[Location Filter] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
      ON
         [Purchase Header].[Assigned User ID] = [User Setup].[User ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Purchase Header].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Purchase Header].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Purchase Header table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
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
       [Purchase Header].[Buy-from Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Pay-to Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Pay-to Name]
       ,[Vendor].[Name]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Pay-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Ship-to City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Header].[Ship-to City] = [Post Code].[City]
18Ship-to Contact SearchShip-to ContactNormalText100Ship-to Contactnvarchar(200)
19Order Date SearchOrder DateNormalDate4Order Datedatetime
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
       [Purchase Header].[Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Purchase Header].[Shipment Method Code] = [Shipment Method].[Code]
28Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Purchase Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Vendor Posting Group]
       ,[Vendor Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Posting Group]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Purchase Header].[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)
Key to join to the Vendor Invoice Disc. table.

Show/hide example query

SELECT
       [Purchase Header].[Invoice Disc_ Code]
       ,[Vendor Invoice Disc.].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor Invoice Disc_$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor Invoice Disc.]
              ON
                     [Purchase Header].[Invoice Disc_ Code] = [Vendor Invoice Disc.].[Code]
41Language Code SearchLanguage CodeNormalCode10Language Codenvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Purchase Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Purchaser Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Purchase Header].[Purchaser Code] = [Salesperson/Purchaser].[Code]
45Order Class SearchOrder ClassNormalCode10Order Classnvarchar(20)
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)
56Recalculate Invoice Disc. SearchRecalculate Invoice Disc.FlowFieldBoolean4
57Receive SearchReceiveNormalBoolean4Receivetinyint
58Invoice SearchInvoiceNormalBoolean4Invoicetinyint
59Print Posted Documents SearchPrint Posted DocumentsNormalBoolean4Print Posted Documentstinyint
60Amount SearchAmountFlowFieldDecimal12
61Amount Including VAT SearchAmount Including TaxFlowFieldDecimal12
62Receiving No. SearchReceiving No.NormalCode20Receiving No_nvarchar(40)
63Posting No. SearchPosting No.NormalCode20Posting No_nvarchar(40)
64Last Receiving No. SearchLast Receiving No.NormalCode20Last Receiving No_nvarchar(40)
Key to join to the Posted Whse. Receipt Header table.

Show/hide example query

SELECT
       [Purchase Header].[Last Receiving No_]
       ,[Posted Whse. Receipt Header].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Posted Whse_ Receipt Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Posted Whse. Receipt Header]
              ON
                     [Purchase Header].[Last Receiving No_] = [Posted Whse. Receipt Header].[No_]
65Last Posting No. SearchLast Posting No.NormalCode20Last Posting No_nvarchar(40)
66Vendor Order No. SearchVendor Order No.NormalCode35Vendor Order No_nvarchar(70)
67Vendor Shipment No. SearchVendor Shipment No.NormalCode35Vendor Shipment No_nvarchar(70)
68Vendor Invoice No. SearchVendor Invoice No.NormalCode35Vendor Invoice No_nvarchar(70)
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
       [Purchase Header].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Reason Code]
       ,[Reason Code].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Reason Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Reason Code]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Purchase Header].[Transaction Type] = [Transaction Type].[Code]
77Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Purchase Header].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Purchase Header].[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
       [Purchase Header].[VAT Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Buy-from Vendor Name]
       ,[Vendor].[Name]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Buy-from City]
       ,[Post Code].[City]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Pay-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Pay-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Buy-from Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Buy-from Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Ship-to Post Code]
       ,[Post Code].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Post Code$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Post Code]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Ship-to Country_Region Code]
       ,[Country/Region].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Country_Region$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Country/Region]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Entry Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Purchase Header].[Area] = [Area].[Code]
102Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Purchase Header].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Payment Method]
              ON
                     [Purchase Header].[Payment Method Code] = [Payment Method].[Code]
107No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Purchase Header].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purchase Header].[No_ Series] = [No. Series].[Code]
108Posting No. Series SearchPosting No. SeriesNormalCode20Posting No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Purchase Header].[Posting No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purchase Header].[Posting No_ Series] = [No. Series].[Code]
109Receiving No. Series SearchReceiving No. SeriesNormalCode20Receiving No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Purchase Header].[Receiving No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purchase Header].[Receiving No_ Series] = [No. Series].[Code]
114Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Purchase Header].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Purchase Header].[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
       [Purchase Header].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Purchase Header].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
118Applies-to ID SearchApplies-to IDNormalCode50Applies-to IDnvarchar(100)
119VAT Base Discount % SearchVAT Base Discount %NormalDecimal12VAT Base Discount _decimal(38,38)
120Status SearchStatusNormalOption4Statusint
Available options are:
  • “Open”
  • “Released”
  • “Pending Approval”
  • “Pending Prepayment”
121Invoice Discount Calculation SearchInvoice Discount CalculationNormalOption4Invoice Discount Calculationint
Available options are:
  • “None”
  • “%”
  • “Amount”
122Invoice Discount Value SearchInvoice Discount ValueNormalDecimal12Invoice Discount Valuedecimal(38,38)
123Send IC Document SearchSend IC DocumentNormalBoolean4Send IC Documenttinyint
124IC Status SearchIC StatusNormalOption4IC Statusint
Available options are:
  • “New”
  • “Pending”
  • “Sent”
125Buy-from IC Partner Code SearchBuy-from IC Partner CodeNormalCode20Buy-from IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Purchase Header].[Buy-from IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Purchase Header].[Buy-from IC Partner Code] = [IC Partner].[Code]
126Pay-to IC Partner Code SearchIC Partner CodeNormalCode20Pay-to IC Partner Codenvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Purchase Header].[Pay-to IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Purchase Header].[Pay-to IC Partner Code] = [IC Partner].[Code]
127IC Reference Document No. SearchIC Reference Document No.NormalCode20IC Reference Document No_nvarchar(40)
129IC Direction SearchIC DirectionNormalOption4IC Directionint
Available options are:
  • “Outgoing”
  • “Incoming”
130Prepayment No. SearchPrepayment No.NormalCode20Prepayment No_nvarchar(40)
131Last Prepayment No. SearchLast Prepayment No.NormalCode20Last Prepayment No_nvarchar(40)
132Prepmt. Cr. Memo No. SearchPrepmt. Cr. Memo No.NormalCode20Prepmt_ Cr_ Memo No_nvarchar(40)
133Last Prepmt. Cr. Memo No. SearchLast Prepmt. Cr. Memo No.NormalCode20Last Prepmt_ Cr_ Memo No_nvarchar(40)
134Prepayment % SearchPrepayment %NormalDecimal12Prepayment _decimal(38,38)
135Prepayment No. Series SearchPrepayment No. SeriesNormalCode20Prepayment No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Purchase Header].[Prepayment No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purchase Header].[Prepayment No_ Series] = [No. Series].[Code]
136Compress Prepayment SearchCompress PrepaymentNormalBoolean4Compress Prepaymenttinyint
137Prepayment Due Date SearchPrepayment Due DateNormalDate4Prepayment Due Datedatetime
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
       [Purchase Header].[Prepmt_ Cr_ Memo No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purchase Header].[Prepmt_ Cr_ Memo No_ Series] = [No. Series].[Code]
139Prepmt. Posting Description SearchPrepmt. Posting DescriptionNormalText100Prepmt_ Posting Descriptionnvarchar(200)
142Prepmt. Pmt. Discount Date SearchPrepmt. Pmt. Discount DateNormalDate4Prepmt_ Pmt_ Discount Datedatetime
143Prepmt. Payment Terms Code SearchPrepmt. Payment Terms CodeNormalCode10Prepmt_ Payment Terms Codenvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

SELECT
       [Purchase Header].[Prepmt_ Payment Terms Code]
       ,[Payment Terms].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
              ON
                     [Purchase Header].[Prepmt_ Payment Terms Code] = [Payment Terms].[Code]
144Prepmt. Payment Discount % SearchPrepmt. Payment Discount %NormalDecimal12Prepmt_ Payment Discount _decimal(38,38)
151Quote No. SearchQuote No.NormalCode20Quote No_nvarchar(40)
160Job Queue Status SearchJob Queue StatusNormalOption4Job Queue Statusint
Available options are:
  • ” “
  • “Scheduled for Posting”
  • “Error”
  • “Posting”
161Job Queue Entry ID SearchJob Queue Entry IDNormalGUID16Job Queue Entry IDuniqueidentifier
165Incoming Document Entry No. SearchIncoming Document Entry No.NormalInteger4Incoming Document Entry No_int
Key to join to the Incoming Document table.

Show/hide example query

SELECT
       [Purchase Header].[Incoming Document Entry No_]
       ,[Incoming Document].[Entry No_]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Incoming Document$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Incoming Document]
              ON
                     [Purchase Header].[Incoming Document Entry No_] = [Incoming Document].[Entry No_]
170Creditor No. SearchCreditor No.NormalCode20Creditor No_nvarchar(40)
171Payment Reference SearchPayment ReferenceNormalCode50Payment Referencenvarchar(100)
175Invoice Received Date SearchInvoice Received DateNormalDate4Invoice Received Datedatetime
178Journal Templ. Name SearchJournal Template NameNormalCode10Journal Templ_ Namenvarchar(20)
179VAT Reporting Date SearchTax DateNormalDate4VAT Reporting Datedatetime
300A. Rcd. Not Inv. Ex. VAT (LCY) SearchAmount Received Not Invoiced ($)FlowFieldDecimal12
301Amt. Rcd. Not Invoiced (LCY) SearchAmount Received Not Invoiced ($) Incl. TaxFlowFieldDecimal12
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Purchase Header].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Purchase Header].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
1000Remit-to Code SearchRemit-to CodeNormalCode20Remit-to Codenvarchar(40)
1305Invoice Discount Amount SearchInvoice Discount AmountFlowFieldDecimal12
5043No. of Archived Versions SearchNo. of Archived VersionsFlowFieldInteger4
5048Doc. No. Occurrence SearchDoc. No. OccurrenceNormalInteger4Doc_ No_ Occurrenceint
5050Campaign No. SearchCampaign No.NormalCode20Campaign No_nvarchar(40)
Key to join to the Campaign table.

Show/hide example query

SELECT
       [Purchase Header].[Campaign No_]
       ,[Campaign].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Campaign$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Campaign]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Buy-from Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Purchase Header].[Buy-from Contact No_] = [Contact].[No_]
5053Pay-to Contact No. SearchPay-to Contact No.NormalCode20Pay-to Contact No_nvarchar(40)
Key to join to the Contact table.

Show/hide example query

SELECT
       [Purchase Header].[Pay-to Contact No_]
       ,[Contact].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Contact$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Contact]
              ON
                     [Purchase Header].[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
       [Purchase Header].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Purchase Header].[Responsibility Center] = [Responsibility Center].[Code]
5751Partially Invoiced SearchPartially InvoicedFlowFieldBoolean4
5752Completely Received SearchCompletely ReceivedFlowFieldBoolean4
5753Posting from Whse. Ref. SearchPosting from Whse. Ref.NormalInteger4Posting from Whse_ Ref_int
5754Location Filter SearchLocation FilterFlowFilterCode10
5790Requested Receipt Date SearchRequested Receipt DateNormalDate4Requested Receipt Datedatetime
5791Promised Receipt Date SearchPromised Receipt DateNormalDate4Promised Receipt Datedatetime
5792Lead Time Calculation SearchLead Time CalculationNormalDateFormula32Lead Time Calculationvarchar(32)
5793Inbound Whse. Handling Time SearchInbound Whse. Handling TimeNormalDateFormula32Inbound Whse_ Handling Timevarchar(32)
5796Date Filter SearchDate FilterFlowFilterDate4
5800Vendor Authorization No. SearchVendor Authorization No.NormalCode35Vendor Authorization No_nvarchar(70)
5801Return Shipment No. SearchReturn Shipment No.NormalCode20Return Shipment No_nvarchar(40)
5802Return Shipment No. Series SearchReturn Shipment No. SeriesNormalCode20Return Shipment No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Purchase Header].[Return Shipment No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Purchase Header].[Return Shipment No_ Series] = [No. Series].[Code]
5803Ship SearchShipNormalBoolean4Shiptinyint
5804Last Return Shipment No. SearchLast Return Shipment No.NormalCode20Last Return Shipment No_nvarchar(40)
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
8000Id SearchIdNormalGUID16Iduniqueidentifier
9000Assigned User ID SearchAssigned User IDNormalCode50Assigned User IDnvarchar(100)
Key to join to the User Setup table.

Show/hide example query

SELECT
       [Purchase Header].[Assigned User ID]
       ,[User Setup].[User ID]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$User Setup$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [User Setup]
              ON
                     [Purchase Header].[Assigned User ID] = [User Setup].[User ID]
9001Pending Approvals SearchPending ApprovalsFlowFieldInteger4
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
10019GST/HST Tax Type SearchGST HST Tax TypeNormalOption4
10020IRS 1099 Code SearchIRS 1099 CodeNormalCode10
10021IRS 1099 Amount SearchIRS 1099 AmountNormalDecimal12
10042Fiscal Invoice Number PAC SearchFiscal Invoice Number PACNormalText50
12600Prepmt. Include Tax SearchPrepmt. Include TaxNormalBoolean4
27030DIOT Type of Operation SearchDIOT Type of OperationNormalOption4
27040DIOT-Type of Operation SearchDIOT Type of OperationNormalOption4
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
       [Purchase Header].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Purchase Header].[$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
       [Purchase Header].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [User] AS [User]
              ON
                     [Purchase Header].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Purchase Header table

CurrencyLanguageLocationPayment MethodPayment TermsResponsibility CenterSales HeaderSales Header ArchiveSalesperson/PurchaserSalesperson/PurchaserShip-to AddressShipment MethodTax AreaVendor Posting Group
Dynamics 365 BC Table ReferenceTablesCompany TablesPPurchase Header

Leave a Reply

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