Purch_ Inv_ Header

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

Table Type: Company

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

Table Number: 0

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[No_]
   ,[Buy-from Vendor No_]
   ,[Pay-to Vendor No_]
   ,[Pay-to Name]
   ,[Pay-to Name 2]
   ,[Pay-to Address]
   ,[Pay-to Address 2]
   ,[Pay-to City]
   ,[Pay-to Contact]
   ,[Your Reference]
   ,[Ship-to Code]
   ,[Ship-to Name]
   ,[Ship-to Name 2]
   ,[Ship-to Address]
   ,[Ship-to Address 2]
   ,[Ship-to City]
   ,[Ship-to Contact]
   ,[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]
   ,[Purchaser Code]
   ,[Order No_]
   ,[No_ Printed]
   ,[On Hold]
   ,[Applies-to Doc_ Type]
   ,[Applies-to Doc_ No_]
   ,[Bal_ Account No_]
   ,[Vendor Order No_]
   ,[Vendor Invoice 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]
   ,[Order No_ Series]
   ,[Pre-Assigned No_]
   ,[User ID]
   ,[Source Code]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[VAT Bus_ Posting Group]
   ,[VAT Base Discount _]
   ,[Prepayment No_ Series]
   ,[Prepayment Invoice]
   ,[Prepayment Order No_]
   ,[Quote No_]
   ,[Creditor No_]
   ,[Payment Reference]
   ,[Dimension Set ID]
   ,[Vendor Ledger Entry No_]
   ,[Campaign No_]
   ,[Buy-from Contact No_]
   ,[Pay-to Contact No_]
   ,[Responsibility Center]
   ,[Price Calculation Method]
   ,[Id]
   ,[Draft Invoice SystemId]
   ,[Type of Supply Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Purch_ Inv_ 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_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Inv_ Header].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Inv_ Header].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Purch_ Inv_ Header].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Purch_ Inv_ Header].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purch_ Inv_ Header].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purch_ Inv_ Header].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Purch_ Inv_ Header].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Purch_ Inv_ Header].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Purch_ Inv_ Header].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purch_ Inv_ Header].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
      ON
         [Purch_ Inv_ Header].[Type of Supply Code] = [Type of Supply].[Code]

Show/hide columns in Purch_ Inv_ Header table

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

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Buy-from Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purch_ Inv_ Header].[Buy-from Vendor No_] = [Vendor].[No_]
4Pay-to Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Pay-to Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purch_ Inv_ Header].[Pay-to Vendor No_] = [Vendor].[No_]
5Pay-to Name Searchnvarchar(200)
6Pay-to Name 2 Searchnvarchar(100)
7Pay-to Address Searchnvarchar(200)
8Pay-to Address 2 Searchnvarchar(100)
9Pay-to City Searchnvarchar(60)
10Pay-to Contact Searchnvarchar(200)
11Your Reference Searchnvarchar(70)
12Ship-to Code Searchnvarchar(20)
13Ship-to Name Searchnvarchar(200)
14Ship-to Name 2 Searchnvarchar(100)
15Ship-to Address Searchnvarchar(200)
16Ship-to Address 2 Searchnvarchar(100)
17Ship-to City Searchnvarchar(60)
18Ship-to Contact Searchnvarchar(200)
19Order Date Searchdatetime
20Posting Date Searchdatetime
21Expected Receipt Date Searchdatetime
22Posting Description Searchnvarchar(200)
23Payment Terms Code Searchnvarchar(20)
Key to join to the Payment Terms table.

Show/hide example query

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

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Shipment Method Code]
       ,[Shipment Method].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
              ON
                     [Purch_ Inv_ Header].[Shipment Method Code] = [Shipment Method].[Code]
28Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Purch_ Inv_ Header].[Location Code] = [Location].[Code]
29Shortcut Dimension 1 Code Searchnvarchar(40)
30Shortcut Dimension 2 Code Searchnvarchar(40)
31Vendor Posting Group Searchnvarchar(40)
32Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Purch_ Inv_ Header].[Currency Code] = [Currency].[Code]
33Currency Factor Searchdecimal(38,38)
34Prices Including VAT Searchtinyint
35Invoice Disc_ Code Searchnvarchar(40)
36Language Code Searchnvarchar(20)
Key to join to the Language table.

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Purch_ Inv_ Header].[Language Code] = [Language].[Code]
37Purchaser Code Searchnvarchar(40)
38Order No_ Searchnvarchar(40)
39No_ Printed Searchint
40On Hold Searchnvarchar(6)
41Applies-to Doc_ Type Searchint
42Applies-to Doc_ No_ Searchnvarchar(40)
43Bal_ Account No_ Searchnvarchar(40)
44Vendor Order No_ Searchnvarchar(70)
45Vendor Invoice No_ Searchnvarchar(70)
46VAT Registration No_ Searchnvarchar(40)
47Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Purch_ Inv_ Header].[Sell-to Customer No_] = [Customer].[No_]
48Reason Code Searchnvarchar(20)
49Gen_ Bus_ Posting Group Searchnvarchar(40)
50Transaction Type Searchnvarchar(20)
51Transport Method Searchnvarchar(20)
52VAT Country_Region Code Searchnvarchar(20)
53Buy-from Vendor Name Searchnvarchar(200)
54Buy-from Vendor Name 2 Searchnvarchar(100)
55Buy-from Address Searchnvarchar(200)
56Buy-from Address 2 Searchnvarchar(100)
57Buy-from City Searchnvarchar(60)
58Buy-from Contact Searchnvarchar(200)
59Pay-to Post Code Searchnvarchar(40)
60Pay-to County Searchnvarchar(60)
61Pay-to Country_Region Code Searchnvarchar(20)
62Buy-from Post Code Searchnvarchar(40)
63Buy-from County Searchnvarchar(60)
64Buy-from Country_Region Code Searchnvarchar(20)
65Ship-to Post Code Searchnvarchar(40)
66Ship-to County Searchnvarchar(60)
67Ship-to Country_Region Code Searchnvarchar(20)
68Bal_ Account Type Searchint
69Order Address Code Searchnvarchar(20)
70Entry Point Searchnvarchar(20)
71Correction Searchtinyint
72Document Date Searchdatetime
73Area Searchnvarchar(20)
74Transaction Specification Searchnvarchar(20)
75Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Purch_ Inv_ Header].[Payment Method Code] = [Payment Method].[Code]
76Pre-Assigned No_ Series Searchnvarchar(40)
77No_ Series Searchnvarchar(40)
78Order No_ Series Searchnvarchar(40)
79Pre-Assigned No_ Searchnvarchar(40)
80User ID Searchnvarchar(100)
81Source Code Searchnvarchar(20)
82Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Purch_ Inv_ Header].[Tax Area Code] = [Tax Area].[Code]
83Tax Liable Searchtinyint
84VAT Bus_ Posting Group Searchnvarchar(40)
85VAT Base Discount _ Searchdecimal(38,38)
86Prepayment No_ Series Searchnvarchar(40)
87Prepayment Invoice Searchtinyint
88Prepayment Order No_ Searchnvarchar(40)
89Quote No_ Searchnvarchar(40)
90Creditor No_ Searchnvarchar(40)
91Payment Reference Searchnvarchar(100)
92Dimension Set ID Searchint
93Vendor Ledger Entry No_ Searchint
94Campaign No_ Searchnvarchar(40)
95Buy-from Contact No_ Searchnvarchar(40)
96Pay-to Contact No_ Searchnvarchar(40)
97Responsibility Center Searchnvarchar(20)
98Price Calculation Method Searchint
99Id Searchuniqueidentifier
100Draft Invoice SystemId Searchuniqueidentifier
101Type of Supply Code Searchnvarchar(20)
Key to join to the Type of Supply table.

Show/hide example query

SELECT
       [Purch_ Inv_ Header].[Type of Supply Code]
       ,[Type of Supply].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Header]
LEFT JOIN
       [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
              ON
                     [Purch_ Inv_ Header].[Type of Supply Code] = [Type of Supply].[Code]
102$systemId Searchuniqueidentifier
103$systemCreatedAt Searchdatetime
104$systemCreatedBy Searchuniqueidentifier
105$systemModifiedAt Searchdatetime
106$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purch_ Inv_ Header table

Leave a Reply

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