Purchase Header – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPurchase 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$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_$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_$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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Document Type	Document Type	Normal	Option	4	Document Type	int
	Available options are: “Quote” “Order” “Invoice” “Credit Memo” “Blanket Order” “Return Order”
2	Buy-from Vendor No.	Buy-from Vendor No.	Normal	Code	20	Buy-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_]
3	No.	No.	Normal	Code	20	No_	nvarchar(40)
4	Pay-to Vendor No.	Vendor No.	Normal	Code	20	Pay-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_]
5	Pay-to Name	Name	Normal	Text	100	Pay-to Name	nvarchar(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]
6	Pay-to Name 2	Name 2	Normal	Text	50	Pay-to Name 2	nvarchar(100)
7	Pay-to Address	Address	Normal	Text	100	Pay-to Address	nvarchar(200)
8	Pay-to Address 2	Address 2	Normal	Text	50	Pay-to Address 2	nvarchar(100)
9	Pay-to City	City	Normal	Text	30	Pay-to City	nvarchar(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]
10	Pay-to Contact	Contact	Normal	Text	100	Pay-to Contact	nvarchar(200)
11	Your Reference	Your Reference	Normal	Text	35	Your Reference	nvarchar(70)
12	Ship-to Code	Ship-to Code	Normal	Code	10	Ship-to Code	nvarchar(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]
13	Ship-to Name	Ship-to Name	Normal	Text	100	Ship-to Name	nvarchar(200)
14	Ship-to Name 2	Ship-to Name 2	Normal	Text	50	Ship-to Name 2	nvarchar(100)
15	Ship-to Address	Ship-to Address	Normal	Text	100	Ship-to Address	nvarchar(200)
16	Ship-to Address 2	Ship-to Address 2	Normal	Text	50	Ship-to Address 2	nvarchar(100)
17	Ship-to City	Ship-to City	Normal	Text	30	Ship-to City	nvarchar(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]
18	Ship-to Contact	Ship-to Contact	Normal	Text	100	Ship-to Contact	nvarchar(200)
19	Order Date	Order Date	Normal	Date	4	Order Date	datetime
20	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
21	Expected Receipt Date	Expected Receipt Date	Normal	Date	4	Expected Receipt Date	datetime
22	Posting Description	Posting Description	Normal	Text	100	Posting Description	nvarchar(200)
23	Payment Terms Code	Payment Terms Code	Normal	Code	10	Payment Terms Code	nvarchar(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]
24	Due Date	Due Date	Normal	Date	4	Due Date	datetime
25	Payment Discount %	Payment Discount %	Normal	Decimal	12	Payment Discount _	decimal(38,38)
26	Pmt. Discount Date	Pmt. Discount Date	Normal	Date	4	Pmt_ Discount Date	datetime
27	Shipment Method Code	Shipment Method Code	Normal	Code	10	Shipment Method Code	nvarchar(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]
28	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(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]
29	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(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]
30	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(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]
31	Vendor Posting Group	Vendor Posting Group	Normal	Code	20	Vendor Posting Group	nvarchar(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]
32	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
33	Currency Factor	Currency Factor	Normal	Decimal	12	Currency Factor	decimal(38,38)
35	Prices Including VAT	Prices Including Tax	Normal	Boolean	4	Prices Including VAT	tinyint
37	Invoice Disc. Code	Invoice Disc. Code	Normal	Code	20	Invoice Disc_ Code	nvarchar(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]
41	Language Code	Language Code	Normal	Code	10	Language Code	nvarchar(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]
42	Format Region	Format Region	Normal	Text	80	Format Region	nvarchar(160)
43	Purchaser Code	Purchaser Code	Normal	Code	20	Purchaser Code	nvarchar(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]
45	Order Class	Order Class	Normal	Code	10	Order Class	nvarchar(20)
46	Comment	Comment	FlowField	Boolean	4
47	No. Printed	No. Printed	Normal	Integer	4	No_ Printed	int
51	On Hold	On Hold	Normal	Code	3	On Hold	nvarchar(6)
52	Applies-to Doc. Type	Applies-to Doc. Type	Normal	Option	4	Applies-to Doc_ Type	int
	Available options are: ” “ “Payment” “Invoice” “Credit Memo” “Finance Charge Memo” “Reminder” “Refund”
53	Applies-to Doc. No.	Applies-to Doc. No.	Normal	Code	20	Applies-to Doc_ No_	nvarchar(40)
55	Bal. Account No.	Bal. Account No.	Normal	Code	20	Bal_ Account No_	nvarchar(40)
56	Recalculate Invoice Disc.	Recalculate Invoice Disc.	FlowField	Boolean	4
57	Receive	Receive	Normal	Boolean	4	Receive	tinyint
58	Invoice	Invoice	Normal	Boolean	4	Invoice	tinyint
59	Print Posted Documents	Print Posted Documents	Normal	Boolean	4	Print Posted Documents	tinyint
60	Amount	Amount	FlowField	Decimal	12
61	Amount Including VAT	Amount Including Tax	FlowField	Decimal	12
62	Receiving No.	Receiving No.	Normal	Code	20	Receiving No_	nvarchar(40)
63	Posting No.	Posting No.	Normal	Code	20	Posting No_	nvarchar(40)
64	Last Receiving No.	Last Receiving No.	Normal	Code	20	Last 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_]
65	Last Posting No.	Last Posting No.	Normal	Code	20	Last Posting No_	nvarchar(40)
66	Vendor Order No.	Vendor Order No.	Normal	Code	35	Vendor Order No_	nvarchar(70)
67	Vendor Shipment No.	Vendor Shipment No.	Normal	Code	35	Vendor Shipment No_	nvarchar(70)
68	Vendor Invoice No.	Vendor Invoice No.	Normal	Code	35	Vendor Invoice No_	nvarchar(70)
69	Vendor Cr. Memo No.	Vendor Cr. Memo No.	Normal	Code	35	Vendor Cr_ Memo No_	nvarchar(70)
70	VAT Registration No.	Tax Registration No.	Normal	Text	20	VAT Registration No_	nvarchar(40)
72	Sell-to Customer No.	Sell-to Customer No.	Normal	Code	20	Sell-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_]
73	Reason Code	Reason Code	Normal	Code	10	Reason Code	nvarchar(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]
74	Gen. Bus. Posting Group	Gen. Bus. Posting Group	Normal	Code	20	Gen_ Bus_ Posting Group	nvarchar(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]
76	Transaction Type	Transaction Type	Normal	Code	10	Transaction Type	nvarchar(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]
77	Transport Method	Transport Method	Normal	Code	10	Transport Method	nvarchar(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]
78	VAT Country/Region Code	Tax Country/Region Code	Normal	Code	10	VAT Country_Region Code	nvarchar(20)
79	Buy-from Vendor Name	Buy-from Vendor Name	Normal	Text	100	Buy-from Vendor Name	nvarchar(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]
80	Buy-from Vendor Name 2	Buy-from Vendor Name 2	Normal	Text	50	Buy-from Vendor Name 2	nvarchar(100)
81	Buy-from Address	Buy-from Address	Normal	Text	100	Buy-from Address	nvarchar(200)
82	Buy-from Address 2	Buy-from Address 2	Normal	Text	50	Buy-from Address 2	nvarchar(100)
83	Buy-from City	Buy-from City	Normal	Text	30	Buy-from City	nvarchar(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]
84	Buy-from Contact	Buy-from Contact	Normal	Text	100	Buy-from Contact	nvarchar(200)
85	Pay-to Post Code	ZIP Code	Normal	Code	20	Pay-to Post Code	nvarchar(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]
86	Pay-to County	State	Normal	Text	30	Pay-to County	nvarchar(60)
87	Pay-to Country/Region Code	Country/Region Code	Normal	Code	10	Pay-to Country_Region Code	nvarchar(20)
88	Buy-from Post Code	Buy-from ZIP Code	Normal	Code	20	Buy-from Post Code	nvarchar(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]
89	Buy-from County	Buy-from State	Normal	Text	30	Buy-from County	nvarchar(60)
90	Buy-from Country/Region Code	Buy-from Country/Region Code	Normal	Code	10	Buy-from Country_Region Code	nvarchar(20)
91	Ship-to Post Code	Ship-to ZIP Code	Normal	Code	20	Ship-to Post Code	nvarchar(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]
92	Ship-to County	Ship-to State	Normal	Text	30	Ship-to County	nvarchar(60)
93	Ship-to Country/Region Code	Ship-to Country/Region Code	Normal	Code	10	Ship-to Country_Region Code	nvarchar(20)
94	Bal. Account Type	Bal. Account Type	Normal	Option	4	Bal_ Account Type	int
	Available options are: “G/L Account” “Bank Account”
95	Order Address Code	Order Address Code	Normal	Code	10	Order Address Code	nvarchar(20)
97	Entry Point	Entry Point	Normal	Code	10	Entry Point	nvarchar(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]
98	Correction	Correction	Normal	Boolean	4	Correction	tinyint
99	Document Date	Document Date	Normal	Date	4	Document Date	datetime
101	Area	Area	Normal	Code	10	Area	nvarchar(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]
102	Transaction Specification	Transaction Specification	Normal	Code	10	Transaction Specification	nvarchar(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]
104	Payment Method Code	Payment Method Code	Normal	Code	10	Payment Method Code	nvarchar(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]
107	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(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]
108	Posting No. Series	Posting No. Series	Normal	Code	20	Posting No_ Series	nvarchar(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]
109	Receiving No. Series	Receiving No. Series	Normal	Code	20	Receiving No_ Series	nvarchar(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]
114	Tax Area Code	Tax Area Code	Normal	Code	20	Tax Area Code	nvarchar(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]
115	Tax Liable	Tax Liable	Normal	Boolean	4	Tax Liable	tinyint
116	VAT Bus. Posting Group	VAT Bus. Posting Group	Normal	Code	20	VAT Bus_ Posting Group	nvarchar(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]
118	Applies-to ID	Applies-to ID	Normal	Code	50	Applies-to ID	nvarchar(100)
119	VAT Base Discount %	VAT Base Discount %	Normal	Decimal	12	VAT Base Discount _	decimal(38,38)
120	Status	Status	Normal	Option	4	Status	int
	Available options are: “Open” “Released” “Pending Approval” “Pending Prepayment”
121	Invoice Discount Calculation	Invoice Discount Calculation	Normal	Option	4	Invoice Discount Calculation	int
	Available options are: “None” “%” “Amount”
122	Invoice Discount Value	Invoice Discount Value	Normal	Decimal	12	Invoice Discount Value	decimal(38,38)
123	Send IC Document	Send IC Document	Normal	Boolean	4	Send IC Document	tinyint
124	IC Status	IC Status	Normal	Option	4	IC Status	int
	Available options are: “New” “Pending” “Sent”
125	Buy-from IC Partner Code	Buy-from IC Partner Code	Normal	Code	20	Buy-from IC Partner Code	nvarchar(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]
126	Pay-to IC Partner Code	IC Partner Code	Normal	Code	20	Pay-to IC Partner Code	nvarchar(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]
127	IC Reference Document No.	IC Reference Document No.	Normal	Code	20	IC Reference Document No_	nvarchar(40)
129	IC Direction	IC Direction	Normal	Option	4	IC Direction	int
	Available options are: “Outgoing” “Incoming”
130	Prepayment No.	Prepayment No.	Normal	Code	20	Prepayment No_	nvarchar(40)
131	Last Prepayment No.	Last Prepayment No.	Normal	Code	20	Last Prepayment No_	nvarchar(40)
132	Prepmt. Cr. Memo No.	Prepmt. Cr. Memo No.	Normal	Code	20	Prepmt_ Cr_ Memo No_	nvarchar(40)
133	Last Prepmt. Cr. Memo No.	Last Prepmt. Cr. Memo No.	Normal	Code	20	Last Prepmt_ Cr_ Memo No_	nvarchar(40)
134	Prepayment %	Prepayment %	Normal	Decimal	12	Prepayment _	decimal(38,38)
135	Prepayment No. Series	Prepayment No. Series	Normal	Code	20	Prepayment No_ Series	nvarchar(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]
136	Compress Prepayment	Compress Prepayment	Normal	Boolean	4	Compress Prepayment	tinyint
137	Prepayment Due Date	Prepayment Due Date	Normal	Date	4	Prepayment Due Date	datetime
138	Prepmt. Cr. Memo No. Series	Prepmt. Cr. Memo No. Series	Normal	Code	20	Prepmt_ Cr_ Memo No_ Series	nvarchar(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]
139	Prepmt. Posting Description	Prepmt. Posting Description	Normal	Text	100	Prepmt_ Posting Description	nvarchar(200)
142	Prepmt. Pmt. Discount Date	Prepmt. Pmt. Discount Date	Normal	Date	4	Prepmt_ Pmt_ Discount Date	datetime
143	Prepmt. Payment Terms Code	Prepmt. Payment Terms Code	Normal	Code	10	Prepmt_ Payment Terms Code	nvarchar(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]
144	Prepmt. Payment Discount %	Prepmt. Payment Discount %	Normal	Decimal	12	Prepmt_ Payment Discount _	decimal(38,38)
151	Quote No.	Quote No.	Normal	Code	20	Quote No_	nvarchar(40)
160	Job Queue Status	Job Queue Status	Normal	Option	4	Job Queue Status	int
	Available options are: ” “ “Scheduled for Posting” “Error” “Posting”
161	Job Queue Entry ID	Job Queue Entry ID	Normal	GUID	16	Job Queue Entry ID	uniqueidentifier
165	Incoming Document Entry No.	Incoming Document Entry No.	Normal	Integer	4	Incoming 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_]
170	Creditor No.	Creditor No.	Normal	Code	20	Creditor No_	nvarchar(40)
171	Payment Reference	Payment Reference	Normal	Code	50	Payment Reference	nvarchar(100)
175	Invoice Received Date	Invoice Received Date	Normal	Date	4	Invoice Received Date	datetime
178	Journal Templ. Name	Journal Template Name	Normal	Code	10	Journal Templ_ Name	nvarchar(20)
179	VAT Reporting Date	Tax Date	Normal	Date	4	VAT Reporting Date	datetime
300	A. Rcd. Not Inv. Ex. VAT (LCY)	Amount Received Not Invoiced ($)	FlowField	Decimal	12
301	Amt. Rcd. Not Invoiced (LCY)	Amount Received Not Invoiced ($) Incl. Tax	FlowField	Decimal	12
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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]
1000	Remit-to Code	Remit-to Code	Normal	Code	20	Remit-to Code	nvarchar(40)
1305	Invoice Discount Amount	Invoice Discount Amount	FlowField	Decimal	12
5043	No. of Archived Versions	No. of Archived Versions	FlowField	Integer	4
5048	Doc. No. Occurrence	Doc. No. Occurrence	Normal	Integer	4	Doc_ No_ Occurrence	int
5050	Campaign No.	Campaign No.	Normal	Code	20	Campaign 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_]
5052	Buy-from Contact No.	Buy-from Contact No.	Normal	Code	20	Buy-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_]
5053	Pay-to Contact No.	Pay-to Contact No.	Normal	Code	20	Pay-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_]
5700	Responsibility Center	Responsibility Center	Normal	Code	10	Responsibility Center	nvarchar(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]
5751	Partially Invoiced	Partially Invoiced	FlowField	Boolean	4
5752	Completely Received	Completely Received	FlowField	Boolean	4
5753	Posting from Whse. Ref.	Posting from Whse. Ref.	Normal	Integer	4	Posting from Whse_ Ref_	int
5754	Location Filter	Location Filter	FlowFilter	Code	10
	Key to join to the Location table. Show/hide example query SELECT [Purchase Header].[] ,[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]
5790	Requested Receipt Date	Requested Receipt Date	Normal	Date	4	Requested Receipt Date	datetime
5791	Promised Receipt Date	Promised Receipt Date	Normal	Date	4	Promised Receipt Date	datetime
5792	Lead Time Calculation	Lead Time Calculation	Normal	DateFormula	32	Lead Time Calculation	varchar(32)
5793	Inbound Whse. Handling Time	Inbound Whse. Handling Time	Normal	DateFormula	32	Inbound Whse_ Handling Time	varchar(32)
5796	Date Filter	Date Filter	FlowFilter	Date	4
5800	Vendor Authorization No.	Vendor Authorization No.	Normal	Code	35	Vendor Authorization No_	nvarchar(70)
5801	Return Shipment No.	Return Shipment No.	Normal	Code	20	Return Shipment No_	nvarchar(40)
5802	Return Shipment No. Series	Return Shipment No. Series	Normal	Code	20	Return Shipment No_ Series	nvarchar(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]
5803	Ship	Ship	Normal	Boolean	4	Ship	tinyint
5804	Last Return Shipment No.	Last Return Shipment No.	Normal	Code	20	Last Return Shipment No_	nvarchar(40)
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
8000	Id	Id	Normal	GUID	16	Id	uniqueidentifier
9000	Assigned User ID	Assigned User ID	Normal	Code	50	Assigned User ID	nvarchar(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]
9001	Pending Approvals	Pending Approvals	FlowField	Integer	4
10005	Ship-to UPS Zone	Ship-to UPS Zone	Normal	Code	2
10015	Tax Exemption No.	Tax Exemption No.	Normal	Text	30
10017	Provincial Tax Area Code	Provincial Tax Area Code	Normal	Code	20
10018	STE Transaction ID	STE Transaction ID	Normal	Text	20
10019	GST/HST Tax Type	GST HST Tax Type	Normal	Option	4
10020	IRS 1099 Code	IRS 1099 Code	Normal	Code	10
10021	IRS 1099 Amount	IRS 1099 Amount	Normal	Decimal	12
10042	Fiscal Invoice Number PAC	Fiscal Invoice Number PAC	Normal	Text	50
12600	Prepmt. Include Tax	Prepmt. Include Tax	Normal	Boolean	4
27030	DIOT Type of Operation	DIOT Type of Operation	Normal	Option	4
27040	DIOT-Type of Operation	DIOT Type of Operation	Normal	Option	4
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Purchase Header table

Dynamics 365 BC Table Reference Tables Company Tables PPurchase Header

Leave a Reply Cancel reply