Purchase 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: 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 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
   [timestamp]
   ,[Document Type]
   ,[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 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 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]
   ,[Journal Templ_ Name]
   ,[Dimension Set ID]
   ,[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]
   ,[Type of Supply Code]
   ,[Invoice Receipt Date]
   ,[$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_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Header].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Header].[Pay-to Vendor No_] = [Vendor].[No_]
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_$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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Purchase Header].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] 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_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
      ON
         [Purchase Header].[Type of Supply Code] = [Type of Supply].[Code]

Show/hide columns in Purchase Header table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Buy-from Vendor No_ Searchnvarchar(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_]
5Pay-to Vendor No_ Searchnvarchar(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_]
6Pay-to Name Searchnvarchar(200)
7Pay-to Name 2 Searchnvarchar(100)
8Pay-to Address Searchnvarchar(200)
9Pay-to Address 2 Searchnvarchar(100)
10Pay-to City Searchnvarchar(60)
11Pay-to Contact Searchnvarchar(200)
12Your Reference Searchnvarchar(70)
13Ship-to Code Searchnvarchar(20)
14Ship-to Name Searchnvarchar(200)
15Ship-to Name 2 Searchnvarchar(100)
16Ship-to Address Searchnvarchar(200)
17Ship-to Address 2 Searchnvarchar(100)
18Ship-to City Searchnvarchar(60)
19Ship-to Contact Searchnvarchar(200)
20Order Date Searchdatetime
21Posting Date Searchdatetime
22Expected Receipt Date Searchdatetime
23Posting Description Searchnvarchar(200)
24Payment Terms Code Searchnvarchar(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]
25Due Date Searchdatetime
26Payment Discount _ Searchdecimal(38,38)
27Pmt_ Discount Date Searchdatetime
28Shipment Method Code Searchnvarchar(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]
29Location Code Searchnvarchar(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]
30Shortcut Dimension 1 Code Searchnvarchar(40)
31Shortcut Dimension 2 Code Searchnvarchar(40)
32Vendor Posting Group Searchnvarchar(40)
33Currency Code Searchnvarchar(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]
34Currency Factor Searchdecimal(38,38)
35Prices Including VAT Searchtinyint
36Invoice Disc_ Code Searchnvarchar(40)
37Language Code Searchnvarchar(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]
38Purchaser Code Searchnvarchar(40)
39Order Class Searchnvarchar(20)
40No_ Printed Searchint
41On Hold Searchnvarchar(6)
42Applies-to Doc_ Type Searchint
43Applies-to Doc_ No_ Searchnvarchar(40)
44Bal_ Account No_ Searchnvarchar(40)
45Receive Searchtinyint
46Invoice Searchtinyint
47Print Posted Documents Searchtinyint
48Receiving No_ Searchnvarchar(40)
49Posting No_ Searchnvarchar(40)
50Last Receiving No_ Searchnvarchar(40)
51Last Posting No_ Searchnvarchar(40)
52Vendor Order No_ Searchnvarchar(70)
53Vendor Shipment No_ Searchnvarchar(70)
54Vendor Invoice No_ Searchnvarchar(70)
55Vendor Cr_ Memo No_ Searchnvarchar(70)
56VAT Registration No_ Searchnvarchar(40)
57Sell-to Customer No_ Searchnvarchar(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_]
58Reason Code Searchnvarchar(20)
59Gen_ Bus_ Posting Group Searchnvarchar(40)
60Transaction Type Searchnvarchar(20)
61Transport Method Searchnvarchar(20)
62VAT Country_Region Code Searchnvarchar(20)
63Buy-from Vendor Name Searchnvarchar(200)
64Buy-from Vendor Name 2 Searchnvarchar(100)
65Buy-from Address Searchnvarchar(200)
66Buy-from Address 2 Searchnvarchar(100)
67Buy-from City Searchnvarchar(60)
68Buy-from Contact Searchnvarchar(200)
69Pay-to Post Code Searchnvarchar(40)
70Pay-to County Searchnvarchar(60)
71Pay-to Country_Region Code Searchnvarchar(20)
72Buy-from Post Code Searchnvarchar(40)
73Buy-from County Searchnvarchar(60)
74Buy-from Country_Region Code Searchnvarchar(20)
75Ship-to Post Code Searchnvarchar(40)
76Ship-to County Searchnvarchar(60)
77Ship-to Country_Region Code Searchnvarchar(20)
78Bal_ Account Type Searchint
79Order Address Code Searchnvarchar(20)
80Entry Point Searchnvarchar(20)
81Correction Searchtinyint
82Document Date Searchdatetime
83Area Searchnvarchar(20)
84Transaction Specification Searchnvarchar(20)
85Payment Method Code Searchnvarchar(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] AS [Payment Method]
              ON
                     [Purchase Header].[Payment Method Code] = [Payment Method].[Code]
86No_ Series Searchnvarchar(40)
87Posting No_ Series Searchnvarchar(40)
88Receiving No_ Series Searchnvarchar(40)
89Tax Area Code Searchnvarchar(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]
90Tax Liable Searchtinyint
91VAT Bus_ Posting Group Searchnvarchar(40)
92Applies-to ID Searchnvarchar(100)
93VAT Base Discount _ Searchdecimal(38,38)
94Status Searchint
95Invoice Discount Calculation Searchint
96Invoice Discount Value Searchdecimal(38,38)
97Send IC Document Searchtinyint
98IC Status Searchint
99Buy-from IC Partner Code Searchnvarchar(40)
100Pay-to IC Partner Code Searchnvarchar(40)
101IC Direction Searchint
102Prepayment No_ Searchnvarchar(40)
103Last Prepayment No_ Searchnvarchar(40)
104Prepmt_ Cr_ Memo No_ Searchnvarchar(40)
105Last Prepmt_ Cr_ Memo No_ Searchnvarchar(40)
106Prepayment _ Searchdecimal(38,38)
107Prepayment No_ Series Searchnvarchar(40)
108Compress Prepayment Searchtinyint
109Prepayment Due Date Searchdatetime
110Prepmt_ Cr_ Memo No_ Series Searchnvarchar(40)
111Prepmt_ Posting Description Searchnvarchar(200)
112Prepmt_ Pmt_ Discount Date Searchdatetime
113Prepmt_ Payment Terms Code Searchnvarchar(20)
114Prepmt_ Payment Discount _ Searchdecimal(38,38)
115Quote No_ Searchnvarchar(40)
116Job Queue Status Searchint
117Job Queue Entry ID Searchuniqueidentifier
118Incoming Document Entry No_ Searchint
119Creditor No_ Searchnvarchar(40)
120Payment Reference Searchnvarchar(100)
121Journal Templ_ Name Searchnvarchar(20)
122Dimension Set ID Searchint
123Doc_ No_ Occurrence Searchint
124Campaign No_ Searchnvarchar(40)
125Buy-from Contact No_ Searchnvarchar(40)
126Pay-to Contact No_ Searchnvarchar(40)
127Responsibility Center Searchnvarchar(20)
128Posting from Whse_ Ref_ Searchint
129Requested Receipt Date Searchdatetime
130Promised Receipt Date Searchdatetime
131Lead Time Calculation Searchvarchar(32)
132Inbound Whse_ Handling Time Searchvarchar(32)
133Vendor Authorization No_ Searchnvarchar(70)
134Return Shipment No_ Searchnvarchar(40)
135Return Shipment No_ Series Searchnvarchar(40)
136Ship Searchtinyint
137Last Return Shipment No_ Searchnvarchar(40)
138Price Calculation Method Searchint
139Id Searchuniqueidentifier
140Assigned User ID Searchnvarchar(100)
141Type of Supply Code Searchnvarchar(20)
Key to join to the Type of Supply table.

Show/hide example query

SELECT
       [Purchase Header].[Type of Supply Code]
       ,[Type of Supply].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header]
LEFT JOIN
       [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
              ON
                     [Purchase Header].[Type of Supply Code] = [Type of Supply].[Code]
142Invoice Receipt Date Searchdatetime
143$systemId Searchuniqueidentifier
144$systemCreatedAt Searchdatetime
145$systemCreatedBy Searchuniqueidentifier
146$systemModifiedAt Searchdatetime
147$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purchase Header table

Leave a Reply

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