Purch. Inv. Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables PPurch. Inv. Line

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

Table Type: Company

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

Table Number: 123

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

Show/hide an example select of all columns

SELECT

   *

FROM

   [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns by name

SELECT

   [Buy-from Vendor No_]
   ,[Document No_]
   ,[Line No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Expected Receipt Date]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Direct Unit Cost]
   ,[Unit Cost (LCY)]
   ,[VAT _]
   ,[Line Discount _]
   ,[Line Discount Amount]
   ,[Amount]
   ,[Amount Including VAT]
   ,[Unit Price (LCY)]
   ,[Allow Invoice Disc_]
   ,[Gross Weight]
   ,[Net Weight]
   ,[Units per Parcel]
   ,[Unit Volume]
   ,[Appl_-to Item Entry]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Job No_]
   ,[Indirect Cost _]
   ,[Receipt No_]
   ,[Receipt Line No_]
   ,[Order No_]
   ,[Order Line No_]
   ,[Pay-to Vendor No_]
   ,[Inv_ Discount Amount]
   ,[Vendor Item No_]
   ,[Gen_ Bus_ Posting Group]
   ,[Gen_ Prod_ Posting Group]
   ,[VAT Calculation Type]
   ,[Transaction Type]
   ,[Transport Method]
   ,[Attached to Line No_]
   ,[Entry Point]
   ,[Area]
   ,[Transaction Specification]
   ,[Tax Area Code]
   ,[Tax Liable]
   ,[Tax Group Code]
   ,[Use Tax]
   ,[VAT Bus_ Posting Group]
   ,[VAT Prod_ Posting Group]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[Line Amount]
   ,[VAT Difference]
   ,[VAT Identifier]
   ,[IC Partner Ref_ Type]
   ,[IC Partner Reference]
   ,[Prepayment Line]
   ,[IC Partner Code]
   ,[Posting Date]
   ,[IC Cross-Reference No_]
   ,[Pmt_ Discount Amount]
   ,[Dimension Set ID]
   ,[Job Task No_]
   ,[Job Line Type]
   ,[Job Unit Price]
   ,[Job Total Price]
   ,[Job Line Amount]
   ,[Job Line Discount Amount]
   ,[Job Line Discount _]
   ,[Job Unit Price (LCY)]
   ,[Job Total Price (LCY)]
   ,[Job Line Amount (LCY)]
   ,[Job Line Disc_ Amount (LCY)]
   ,[Job Currency Factor]
   ,[Job Currency Code]
   ,[Deferral Code]
   ,[Allocation Account No_]
   ,[Prod_ Order No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[FA Posting Date]
   ,[FA Posting Type]
   ,[Depreciation Book Code]
   ,[Salvage Value]
   ,[Depr_ until FA Posting Date]
   ,[Depr_ Acquisition Cost]
   ,[Maintenance Code]
   ,[Insurance No_]
   ,[Budgeted FA No_]
   ,[Duplicate in Depreciation Book]
   ,[Use Duplication List]
   ,[Responsibility Center]
   ,[Cross-Reference No_]
   ,[Unit of Measure (Cross Ref_)]
   ,[Cross-Reference Type]
   ,[Cross-Reference Type No_]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Non-Deductible VAT _]
   ,[Non-Deductible VAT Base]
   ,[Non-Deductible VAT Amount]
   ,[Non-Deductible VAT Diff_]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Routing No_]
   ,[Operation No_]
   ,[Work Center No_]
   ,[Prod_ Order Line No_]
   ,[Overhead Rate]
   ,[Routing Reference No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Purch_ Inv_ Line$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_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purch. Inv. Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Purch. Inv. Line].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Purch. Inv. Line].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purch. Inv. Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purch. Inv. Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Purch. Inv. Line].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Purch. Inv. Line].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
      ON
         [Purch. Inv. Line].[Entry Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Purch. Inv. Line].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Purch. Inv. Line].[Transaction Specification] = [Transaction Specification].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purch. Inv. Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Purch. Inv. Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Purch. Inv. Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Purch. Inv. Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
      ON
         [Purch. Inv. Line].[Deferral Code] = [Deferral Template].[Deferral Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Purch. Inv. Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Purch. Inv. Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Purch. Inv. Line].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
      ON
         [Purch. Inv. Line].[Maintenance Code] = [Maintenance].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Purch. Inv. Line].[Duplicate in Depreciation Book] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Purch. Inv. Line].[Responsibility Center] = [Responsibility Center].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Purch. Inv. Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Purch. Inv. Line].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
      ON
         [Purch. Inv. Line].[Return Reason Code] = [Return Reason].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Purch. Inv. Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Purch. Inv. Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Purch. Inv. Line table

Field No.	Field Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
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 [Purch. Inv. Line].[Buy-from Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch. Inv. Line].[Buy-from Vendor No_] = [Vendor].[No_]
3	Document No.	Document No.	Normal	Code	20	Document No_	nvarchar(40)
4	Line No.	Line No.	Normal	Integer	4	Line No_	int
5	Type	Type	Normal	Option	4	Type	int
	Available options are: ” “ “G/L Account” “Item” “Resource” “Fixed Asset” “Charge (Item)” “Allocation Account”
6	No.	No.	Normal	Code	20	No_	nvarchar(40)
7	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(20)
	Key to join to the Location table. Show/hide example query SELECT [Purch. Inv. Line].[Location Code] ,[Location].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location] ON [Purch. Inv. Line].[Location Code] = [Location].[Code]
8	Posting Group	Posting Group	Normal	Code	20	Posting Group	nvarchar(40)
	Key to join to the Customer Posting Group table. Show/hide example query SELECT [Purch. Inv. Line].[Posting Group] ,[Customer Posting Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group] ON [Purch. Inv. Line].[Posting Group] = [Customer Posting Group].[Code]
10	Expected Receipt Date	Expected Receipt Date	Normal	Date	4	Expected Receipt Date	datetime
11	Description	Description	Normal	Text	100	Description	nvarchar(200)
12	Description 2	Description 2	Normal	Text	50	Description 2	nvarchar(100)
13	Unit of Measure	Unit of Measure	Normal	Text	50	Unit of Measure	nvarchar(100)
	Key to join to the Unit of Measure table. Show/hide example query SELECT [Purch. Inv. Line].[Unit of Measure] ,[Unit of Measure].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure] ON [Purch. Inv. Line].[Unit of Measure] = [Unit of Measure].[Code]
15	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
22	Direct Unit Cost	Direct Unit Cost	Normal	Decimal	12	Direct Unit Cost	decimal(38,38)
23	Unit Cost (LCY)	Unit Cost ($)	Normal	Decimal	12	Unit Cost (LCY)	decimal(38,38)
25	VAT %	Tax %	Normal	Decimal	12	VAT _	decimal(38,38)
27	Line Discount %	Line Discount %	Normal	Decimal	12	Line Discount _	decimal(38,38)
28	Line Discount Amount	Line Discount Amount	Normal	Decimal	12	Line Discount Amount	decimal(38,38)
29	Amount	Amount	Normal	Decimal	12	Amount	decimal(38,38)
30	Amount Including VAT	Amount Including Tax	Normal	Decimal	12	Amount Including VAT	decimal(38,38)
31	Unit Price (LCY)	Unit Price ($)	Normal	Decimal	12	Unit Price (LCY)	decimal(38,38)
32	Allow Invoice Disc.	Allow Invoice Disc.	Normal	Boolean	4	Allow Invoice Disc_	tinyint
34	Gross Weight	Gross Weight	Normal	Decimal	12	Gross Weight	decimal(38,38)
35	Net Weight	Net Weight	Normal	Decimal	12	Net Weight	decimal(38,38)
36	Units per Parcel	Units per Parcel	Normal	Decimal	12	Units per Parcel	decimal(38,38)
37	Unit Volume	Unit Volume	Normal	Decimal	12	Unit Volume	decimal(38,38)
38	Appl.-to Item Entry	Appl.-to Item Entry	Normal	Integer	4	Appl_-to Item Entry	int
40	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 [Purch. Inv. Line].[Shortcut Dimension 1 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Purch. Inv. Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
41	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 [Purch. Inv. Line].[Shortcut Dimension 2 Code] ,[Dimension].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension] ON [Purch. Inv. Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
45	Job No.	Job No.	Normal	Code	20	Job No_	nvarchar(40)
	Key to join to the Job table. Show/hide example query SELECT [Purch. Inv. Line].[Job No_] ,[Job].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job] ON [Purch. Inv. Line].[Job No_] = [Job].[No_]
54	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
63	Receipt No.	Receipt No.	Normal	Code	20	Receipt No_	nvarchar(40)
64	Receipt Line No.	Receipt Line No.	Normal	Integer	4	Receipt Line No_	int
65	Order No.	Order No.	Normal	Code	20	Order No_	nvarchar(40)
66	Order Line No.	Order Line No.	Normal	Integer	4	Order Line No_	int
68	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 [Purch. Inv. Line].[Pay-to Vendor No_] ,[Vendor].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor] ON [Purch. Inv. Line].[Pay-to Vendor No_] = [Vendor].[No_]
69	Inv. Discount Amount	Inv. Discount Amount	Normal	Decimal	12	Inv_ Discount Amount	decimal(38,38)
70	Vendor Item No.	Vendor Item No.	Normal	Text	50	Vendor Item No_	nvarchar(100)
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 [Purch. Inv. Line].[Gen_ Bus_ Posting Group] ,[Gen. Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group] ON [Purch. Inv. Line].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
75	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(40)
	Key to join to the Gen. Product Posting Group table. Show/hide example query SELECT [Purch. Inv. Line].[Gen_ Prod_ Posting Group] ,[Gen. Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group] ON [Purch. Inv. Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
77	VAT Calculation Type	VAT Calculation Type	Normal	Option	4	VAT Calculation Type	int
	Available options are: “Normal VAT” “Reverse Charge VAT” “Full VAT” “Sales Tax”
78	Transaction Type	Transaction Type	Normal	Code	10	Transaction Type	nvarchar(20)
	Key to join to the Transaction Type table. Show/hide example query SELECT [Purch. Inv. Line].[Transaction Type] ,[Transaction Type].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type] ON [Purch. Inv. Line].[Transaction Type] = [Transaction Type].[Code]
79	Transport Method	Transport Method	Normal	Code	10	Transport Method	nvarchar(20)
	Key to join to the Transport Method table. Show/hide example query SELECT [Purch. Inv. Line].[Transport Method] ,[Transport Method].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method] ON [Purch. Inv. Line].[Transport Method] = [Transport Method].[Code]
80	Attached to Line No.	Attached to Line No.	Normal	Integer	4	Attached to Line No_	int
81	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 [Purch. Inv. Line].[Entry Point] ,[Entry/Exit Point].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point] ON [Purch. Inv. Line].[Entry Point] = [Entry/Exit Point].[Code]
82	Area	Area	Normal	Code	10	Area	nvarchar(20)
	Key to join to the Area table. Show/hide example query SELECT [Purch. Inv. Line].[Area] ,[Area].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area] ON [Purch. Inv. Line].[Area] = [Area].[Code]
83	Transaction Specification	Transaction Specification	Normal	Code	10	Transaction Specification	nvarchar(20)
	Key to join to the Transaction Specification table. Show/hide example query SELECT [Purch. Inv. Line].[Transaction Specification] ,[Transaction Specification].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification] ON [Purch. Inv. Line].[Transaction Specification] = [Transaction Specification].[Code]
85	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 [Purch. Inv. Line].[Tax Area Code] ,[Tax Area].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area] ON [Purch. Inv. Line].[Tax Area Code] = [Tax Area].[Code]
86	Tax Liable	Tax Liable	Normal	Boolean	4	Tax Liable	tinyint
87	Tax Group Code	Tax Group Code	Normal	Code	20	Tax Group Code	nvarchar(40)
	Key to join to the Tax Group table. Show/hide example query SELECT [Purch. Inv. Line].[Tax Group Code] ,[Tax Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group] ON [Purch. Inv. Line].[Tax Group Code] = [Tax Group].[Code]
88	Use Tax	Use Tax	Normal	Boolean	4	Use Tax	tinyint
89	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 [Purch. Inv. Line].[VAT Bus_ Posting Group] ,[VAT Business Posting Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group] ON [Purch. Inv. Line].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
90	VAT Prod. Posting Group	VAT Prod. Posting Group	Normal	Code	20	VAT Prod_ Posting Group	nvarchar(40)
	Key to join to the VAT Product Posting Group table. Show/hide example query SELECT [Purch. Inv. Line].[VAT Prod_ Posting Group] ,[VAT Product Posting Group].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group] ON [Purch. Inv. Line].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
97	Blanket Order No.	Blanket Order No.	Normal	Code	20	Blanket Order No_	nvarchar(40)
98	Blanket Order Line No.	Blanket Order Line No.	Normal	Integer	4	Blanket Order Line No_	int
99	VAT Base Amount	Tax Base Amount	Normal	Decimal	12	VAT Base Amount	decimal(38,38)
100	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
101	System-Created Entry	System-Created Entry	Normal	Boolean	4
103	Line Amount	Line Amount	Normal	Decimal	12	Line Amount	decimal(38,38)
104	VAT Difference	Tax Difference	Normal	Decimal	12	VAT Difference	decimal(38,38)
106	VAT Identifier	Tax Identifier	Normal	Code	20	VAT Identifier	nvarchar(40)
107	IC Partner Ref. Type	IC Partner Ref. Type	Normal	Option	4	IC Partner Ref_ Type	int
	Available options are: ” “ “G/L Account” “Item” “Charge (Item)” “Cross Reference” “Common Item No.” “Vendor Item No.”
108	IC Partner Reference	IC Partner Reference	Normal	Code	20	IC Partner Reference	nvarchar(40)
123	Prepayment Line	Prepayment Line	Normal	Boolean	4	Prepayment Line	tinyint
130	IC Partner Code	IC Partner Code	Normal	Code	20	IC Partner Code	nvarchar(40)
	Key to join to the IC Partner table. Show/hide example query SELECT [Purch. Inv. Line].[IC Partner Code] ,[IC Partner].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner] ON [Purch. Inv. Line].[IC Partner Code] = [IC Partner].[Code]
131	Posting Date	Posting Date	Normal	Date	4	Posting Date	datetime
138	IC Cross-Reference No.	IC Item Reference No.	Normal	Code	50	IC Cross-Reference No_	nvarchar(100)
145	Pmt. Discount Amount	Pmt. Discount Amount	Normal	Decimal	12	Pmt_ Discount Amount	decimal(38,38)
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 [Purch. Inv. Line].[Dimension Set ID] ,[Dimension Set Entry].[Dimension Set ID] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry] ON [Purch. Inv. Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
1001	Job Task No.	Job Task No.	Normal	Code	20	Job Task No_	nvarchar(40)
1002	Job Line Type	Job Line Type	Normal	Option	4	Job Line Type	int
	Available options are: ” “ “Budget” “Billable” “Both Budget and Billable”
1003	Job Unit Price	Job Unit Price	Normal	Decimal	12	Job Unit Price	decimal(38,38)
1004	Job Total Price	Job Total Price	Normal	Decimal	12	Job Total Price	decimal(38,38)
1005	Job Line Amount	Job Line Amount	Normal	Decimal	12	Job Line Amount	decimal(38,38)
1006	Job Line Discount Amount	Job Line Discount Amount	Normal	Decimal	12	Job Line Discount Amount	decimal(38,38)
1007	Job Line Discount %	Job Line Discount %	Normal	Decimal	12	Job Line Discount _	decimal(38,38)
1008	Job Unit Price (LCY)	Job Unit Price ($)	Normal	Decimal	12	Job Unit Price (LCY)	decimal(38,38)
1009	Job Total Price (LCY)	Job Total Price ($)	Normal	Decimal	12	Job Total Price (LCY)	decimal(38,38)
1010	Job Line Amount (LCY)	Job Line Amount ($)	Normal	Decimal	12	Job Line Amount (LCY)	decimal(38,38)
1011	Job Line Disc. Amount (LCY)	Job Line Disc. Amount ($)	Normal	Decimal	12	Job Line Disc_ Amount (LCY)	decimal(38,38)
1012	Job Currency Factor	Job Currency Factor	Normal	Decimal	12	Job Currency Factor	decimal(38,38)
1013	Job Currency Code	Job Currency Code	Normal	Code	20	Job Currency Code	nvarchar(40)
1700	Deferral Code	Deferral Code	Normal	Code	10	Deferral Code	nvarchar(20)
	Key to join to the Deferral Template table. Show/hide example query SELECT [Purch. Inv. Line].[Deferral Code] ,[Deferral Template].[Deferral Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template] ON [Purch. Inv. Line].[Deferral Code] = [Deferral Template].[Deferral Code]
2678	Allocation Account No.	Allocation Account No.	Normal	Code	20	Allocation Account No_	nvarchar(40)
	Key to join to the Allocation Account table. Show/hide example query SELECT [Purch. Inv. Line].[Allocation Account No_] ,[Allocation Account].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Allocation Account$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Allocation Account] ON [Purch. Inv. Line].[Allocation Account No_] = [Allocation Account].[No_]
5401	Prod. Order No.	Prod. Order No.	Normal	Code	20	Prod_ Order No_	nvarchar(40)
5402	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(20)
	Key to join to the Item Variant table. Show/hide example query SELECT [Purch. Inv. Line].[Variant Code] ,[Item Variant].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant] ON [Purch. Inv. Line].[Variant Code] = [Item Variant].[Code]
5403	Bin Code	Bin Code	Normal	Code	20	Bin Code	nvarchar(40)
	Key to join to the Bin table. Show/hide example query SELECT [Purch. Inv. Line].[Bin Code] ,[Bin].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin] ON [Purch. Inv. Line].[Bin Code] = [Bin].[Code]
5404	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
5407	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
5415	Quantity (Base)	Quantity (Base)	Normal	Decimal	12	Quantity (Base)	decimal(38,38)
5600	FA Posting Date	FA Posting Date	Normal	Date	4	FA Posting Date	datetime
5601	FA Posting Type	FA Posting Type	Normal	Option	4	FA Posting Type	int
	Available options are: ” “ “Acquisition Cost” “Maintenance” “Appreciation”
5602	Depreciation Book Code	Depreciation Book Code	Normal	Code	10	Depreciation Book Code	nvarchar(20)
	Key to join to the Depreciation Book table. Show/hide example query SELECT [Purch. Inv. Line].[Depreciation Book Code] ,[Depreciation Book].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book] ON [Purch. Inv. Line].[Depreciation Book Code] = [Depreciation Book].[Code]
5603	Salvage Value	Salvage Value	Normal	Decimal	12	Salvage Value	decimal(38,38)
5605	Depr. until FA Posting Date	Depr. until FA Posting Date	Normal	Boolean	4	Depr_ until FA Posting Date	tinyint
5606	Depr. Acquisition Cost	Depr. Acquisition Cost	Normal	Boolean	4	Depr_ Acquisition Cost	tinyint
5609	Maintenance Code	Maintenance Code	Normal	Code	10	Maintenance Code	nvarchar(20)
	Key to join to the Maintenance table. Show/hide example query SELECT [Purch. Inv. Line].[Maintenance Code] ,[Maintenance].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance] ON [Purch. Inv. Line].[Maintenance Code] = [Maintenance].[Code]
5610	Insurance No.	Insurance No.	Normal	Code	20	Insurance No_	nvarchar(40)
	Key to join to the Insurance table. Show/hide example query SELECT [Purch. Inv. Line].[Insurance No_] ,[Insurance].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance] ON [Purch. Inv. Line].[Insurance No_] = [Insurance].[No_]
5611	Budgeted FA No.	Budgeted FA No.	Normal	Code	20	Budgeted FA No_	nvarchar(40)
	Key to join to the Fixed Asset table. Show/hide example query SELECT [Purch. Inv. Line].[Budgeted FA No_] ,[Fixed Asset].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset] ON [Purch. Inv. Line].[Budgeted FA No_] = [Fixed Asset].[No_]
5612	Duplicate in Depreciation Book	Duplicate in Depreciation Book	Normal	Code	10	Duplicate in Depreciation Book	nvarchar(20)
	Key to join to the Depreciation Book table. Show/hide example query SELECT [Purch. Inv. Line].[Duplicate in Depreciation Book] ,[Depreciation Book].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book] ON [Purch. Inv. Line].[Duplicate in Depreciation Book] = [Depreciation Book].[Code]
5613	Use Duplication List	Use Duplication List	Normal	Boolean	4	Use Duplication List	tinyint
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 [Purch. Inv. Line].[Responsibility Center] ,[Responsibility Center].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center] ON [Purch. Inv. Line].[Responsibility Center] = [Responsibility Center].[Code]
5705	Cross-Reference No.	Cross-Reference No.	Normal	Code	20	Cross-Reference No_	nvarchar(40)
5706	Unit of Measure (Cross Ref.)	Unit of Measure (Cross Ref.)	Normal	Code	10	Unit of Measure (Cross Ref_)	nvarchar(20)
5707	Cross-Reference Type	Cross-Reference Type	Normal	Option	4	Cross-Reference Type	int
	Available options are: ” “ “Customer” “Vendor” “Bar Code”
5708	Cross-Reference Type No.	Cross-Reference Type No.	Normal	Code	30	Cross-Reference Type No_	nvarchar(60)
5709	Item Category Code	Item Category Code	Normal	Code	20	Item Category Code	nvarchar(40)
	Key to join to the Item Category table. Show/hide example query SELECT [Purch. Inv. Line].[Item Category Code] ,[Item Category].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category] ON [Purch. Inv. Line].[Item Category Code] = [Item Category].[Code]
5710	Nonstock	Catalog	Normal	Boolean	4	Nonstock	tinyint
5711	Purchasing Code	Purchasing Code	Normal	Code	10	Purchasing Code	nvarchar(20)
	Key to join to the Purchasing table. Show/hide example query SELECT [Purch. Inv. Line].[Purchasing Code] ,[Purchasing].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing] ON [Purch. Inv. Line].[Purchasing Code] = [Purchasing].[Code]
5712	Product Group Code	Product Group Code	Normal	Code	10	Product Group Code	nvarchar(20)
5725	Item Reference No.	Item Reference No.	Normal	Code	50	Item Reference No_	nvarchar(100)
5726	Item Reference Unit of Measure	Unit of Measure (Item Ref.)	Normal	Code	10	Item Reference Unit of Measure	nvarchar(20)
5727	Item Reference Type	Item Reference Type	Normal	Option	4	Item Reference Type	int
	Available options are: ” “ “Customer” “Vendor” “Bar Code”
5728	Item Reference Type No.	Item Reference Type No.	Normal	Code	30	Item Reference Type No_	nvarchar(60)
6200	Non-Deductible VAT %	Non-Deductible Tax %	Normal	Decimal	12	Non-Deductible VAT _	decimal(38,38)
6201	Non-Deductible VAT Base	Non-Deductible Tax Base	Normal	Decimal	12	Non-Deductible VAT Base	decimal(38,38)
6202	Non-Deductible VAT Amount	Non-Deductible Tax Amount	Normal	Decimal	12	Non-Deductible VAT Amount	decimal(38,38)
6203	Non-Deductible VAT Diff.	Non-Deductible Tax Difference	Normal	Decimal	12	Non-Deductible VAT Diff_	decimal(38,38)
6608	Return Reason Code	Return Reason Code	Normal	Code	10	Return Reason Code	nvarchar(20)
	Key to join to the Return Reason table. Show/hide example query SELECT [Purch. Inv. Line].[Return Reason Code] ,[Return Reason].[Code] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason] ON [Purch. Inv. Line].[Return Reason Code] = [Return Reason].[Code]
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
10017	Provincial Tax Area Code	Provincial Tax Area Code	Normal	Code	20
10022	IRS 1099 Liable	IRS 1099 Liable	Normal	Boolean	4
99000750	Routing No.	Routing No.	Normal	Code	20	Routing No_	nvarchar(40)
	Key to join to the Routing Header table. Show/hide example query SELECT [Purch. Inv. Line].[Routing No_] ,[Routing Header].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header] ON [Purch. Inv. Line].[Routing No_] = [Routing Header].[No_]
99000751	Operation No.	Operation No.	Normal	Code	10	Operation No_	nvarchar(20)
99000752	Work Center No.	Work Center No.	Normal	Code	20	Work Center No_	nvarchar(40)
	Key to join to the Work Center table. Show/hide example query SELECT [Purch. Inv. Line].[Work Center No_] ,[Work Center].[No_] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center] ON [Purch. Inv. Line].[Work Center No_] = [Work Center].[No_]
99000754	Prod. Order Line No.	Prod. Order Line No.	Normal	Integer	4	Prod_ Order Line No_	int
99000755	Overhead Rate	Overhead Rate	Normal	Decimal	12	Overhead Rate	decimal(38,38)
99000759	Routing Reference No.	Routing Reference No.	Normal	Integer	4	Routing Reference No_	int
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 [Purch. Inv. Line].[$systemCreatedBy] ,[User].[User Security ID] FROM [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch. Inv. Line] LEFT JOIN [User] AS [User] ON [Purch. Inv. Line].[$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 Purch. Inv. Line table

Dynamics 365 BC Table Reference Tables Company Tables PPurch. Inv. Line

Leave a Reply Cancel reply