Purchase Header Archive

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

Table Type: Company

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

Table Number: 5109

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[No_]
   ,[Doc_ No_ Occurrence]
   ,[Version 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]
   ,[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 _]
   ,[Purchase Quote No_]
   ,[Dimension Set ID]
   ,[Interaction Exist]
   ,[Time Archived]
   ,[Date Archived]
   ,[Archived By]
   ,[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]
   ,[Assigned User ID]
   ,[Type of Supply Code]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Purchase Header Archive$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 Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header Archive]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Header Archive].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Header Archive].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Terms$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Terms]
      ON
         [Purchase Header Archive].[Payment Terms Code] = [Payment Terms].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Shipment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Shipment Method]
      ON
         [Purchase Header Archive].[Shipment Method Code] = [Shipment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purchase Header Archive].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purchase Header Archive].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
      ON
         [Purchase Header Archive].[Language Code] = [Language].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Purchase Header Archive].[Sell-to Customer No_] = [Customer].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
      ON
         [Purchase Header Archive].[Payment Method Code] = [Payment Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purchase Header Archive].[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 Archive].[Type of Supply Code] = [Type of Supply].[Code]

Show/hide columns in Purchase Header Archive table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document Type Primary Key Searchint
3No_ Primary Key Searchnvarchar(40)
4Doc_ No_ Occurrence Primary Key Searchint
5Version No_ Primary Key Searchint
6Buy-from Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Purchase Header Archive].[Language Code]
       ,[Language].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Language$63ca2fa4-4f03-4f2b-a480-172fef340d3f] AS [Language]
              ON
                     [Purchase Header Archive].[Language Code] = [Language].[Code]
40Purchaser Code Searchnvarchar(40)
41Order Class Searchnvarchar(20)
42No_ Printed Searchint
43On Hold Searchnvarchar(6)
44Applies-to Doc_ Type Searchint
45Applies-to Doc_ No_ Searchnvarchar(40)
46Bal_ Account No_ Searchnvarchar(40)
47Receive Searchtinyint
48Invoice Searchtinyint
49Receiving No_ Searchnvarchar(40)
50Posting No_ Searchnvarchar(40)
51Last Receiving No_ Searchnvarchar(40)
52Last Posting No_ Searchnvarchar(40)
53Vendor Order No_ Searchnvarchar(70)
54Vendor Shipment No_ Searchnvarchar(70)
55Vendor Invoice No_ Searchnvarchar(70)
56Vendor Cr_ Memo No_ Searchnvarchar(70)
57VAT Registration No_ Searchnvarchar(40)
58Sell-to Customer No_ Searchnvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Purchase Header Archive].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Purchase Header Archive].[Sell-to Customer No_] = [Customer].[No_]
59Reason Code Searchnvarchar(20)
60Gen_ Bus_ Posting Group Searchnvarchar(40)
61Transaction Type Searchnvarchar(20)
62Transport Method Searchnvarchar(20)
63VAT Country_Region Code Searchnvarchar(20)
64Buy-from Vendor Name Searchnvarchar(200)
65Buy-from Vendor Name 2 Searchnvarchar(100)
66Buy-from Address Searchnvarchar(200)
67Buy-from Address 2 Searchnvarchar(100)
68Buy-from City Searchnvarchar(60)
69Buy-from Contact Searchnvarchar(200)
70Pay-to Post Code Searchnvarchar(40)
71Pay-to County Searchnvarchar(60)
72Pay-to Country_Region Code Searchnvarchar(20)
73Buy-from Post Code Searchnvarchar(40)
74Buy-from County Searchnvarchar(60)
75Buy-from Country_Region Code Searchnvarchar(20)
76Ship-to Post Code Searchnvarchar(40)
77Ship-to County Searchnvarchar(60)
78Ship-to Country_Region Code Searchnvarchar(20)
79Bal_ Account Type Searchint
80Order Address Code Searchnvarchar(20)
81Entry Point Searchnvarchar(20)
82Correction Searchtinyint
83Document Date Searchdatetime
84Area Searchnvarchar(20)
85Transaction Specification Searchnvarchar(20)
86Payment Method Code Searchnvarchar(20)
Key to join to the Payment Method table.

Show/hide example query

SELECT
       [Purchase Header Archive].[Payment Method Code]
       ,[Payment Method].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Payment Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Payment Method]
              ON
                     [Purchase Header Archive].[Payment Method Code] = [Payment Method].[Code]
87No_ Series Searchnvarchar(40)
88Posting No_ Series Searchnvarchar(40)
89Receiving No_ Series Searchnvarchar(40)
90Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Purchase Header Archive].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Purchase Header Archive].[Tax Area Code] = [Tax Area].[Code]
91Tax Liable Searchtinyint
92VAT Bus_ Posting Group Searchnvarchar(40)
93Applies-to ID Searchnvarchar(100)
94VAT Base Discount _ Searchdecimal(38,38)
95Status Searchint
96Invoice Discount Calculation Searchint
97Invoice Discount Value Searchdecimal(38,38)
98Send IC Document Searchtinyint
99IC Status Searchint
100Buy-from IC Partner Code Searchnvarchar(40)
101Pay-to IC Partner Code Searchnvarchar(40)
102IC Direction Searchint
103Prepayment No_ Searchnvarchar(40)
104Last Prepayment No_ Searchnvarchar(40)
105Prepmt_ Cr_ Memo No_ Searchnvarchar(40)
106Last Prepmt_ Cr_ Memo No_ Searchnvarchar(40)
107Prepayment _ Searchdecimal(38,38)
108Prepayment No_ Series Searchnvarchar(40)
109Compress Prepayment Searchtinyint
110Prepayment Due Date Searchdatetime
111Prepmt_ Cr_ Memo No_ Series Searchnvarchar(40)
112Prepmt_ Posting Description Searchnvarchar(200)
113Prepmt_ Pmt_ Discount Date Searchdatetime
114Prepmt_ Payment Terms Code Searchnvarchar(20)
115Prepmt_ Payment Discount _ Searchdecimal(38,38)
116Purchase Quote No_ Searchnvarchar(40)
117Dimension Set ID Searchint
118Interaction Exist Searchtinyint
119Time Archived Searchdatetime
120Date Archived Searchdatetime
121Archived By Searchnvarchar(100)
122Campaign No_ Searchnvarchar(40)
123Buy-from Contact No_ Searchnvarchar(40)
124Pay-to Contact No_ Searchnvarchar(40)
125Responsibility Center Searchnvarchar(20)
126Posting from Whse_ Ref_ Searchint
127Requested Receipt Date Searchdatetime
128Promised Receipt Date Searchdatetime
129Lead Time Calculation Searchvarchar(32)
130Inbound Whse_ Handling Time Searchvarchar(32)
131Vendor Authorization No_ Searchnvarchar(70)
132Return Shipment No_ Searchnvarchar(40)
133Return Shipment No_ Series Searchnvarchar(40)
134Ship Searchtinyint
135Last Return Shipment No_ Searchnvarchar(40)
136Price Calculation Method Searchint
137Assigned User ID Searchnvarchar(100)
138Type of Supply Code Searchnvarchar(20)
Key to join to the Type of Supply table.

Show/hide example query

SELECT
       [Purchase Header Archive].[Type of Supply Code]
       ,[Type of Supply].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Header Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Type of Supply$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Type of Supply]
              ON
                     [Purchase Header Archive].[Type of Supply Code] = [Type of Supply].[Code]
139$systemId Searchuniqueidentifier
140$systemCreatedAt Searchdatetime
141$systemCreatedBy Searchuniqueidentifier
142$systemModifiedAt Searchdatetime
143$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purchase Header Archive table

Leave a Reply

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