Purch_ 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: 0

Due to how Dynamics BC tables and columns are named, square brackets need to be wrapped around the table name and column names. Below are example queries showing how Purch_ Inv_ 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
   [timestamp]
   ,[Document No_]
   ,[Line No_]
   ,[Buy-from Vendor 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]
   ,[System-Created Entry]
   ,[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]
   ,[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_]
   ,[Return Reason Code]
   ,[Price Calculation Method]
   ,[Reverse Charge Item]
   ,[Reverse Charge]
   ,[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_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Inv_ Line].[Buy-from Vendor No_] = [Vendor].[No_]
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_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Purch_ Inv_ Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purch_ Inv_ Line].[Pay-to Vendor No_] = [Vendor].[No_]
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_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Purch_ Inv_ Line].[Job Task No_] = [Job Task].[Job Task No_]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Purch_ Inv_ Line].[Unit of Measure Code] = [Unit of Measure].[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_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Purch_ Inv_ Line].[Product Group Code] = [Product Group].[Code]

Show/hide columns in Purch_ Inv_ Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Document No_ Primary Key Searchnvarchar(40)
3Line No_ Primary Key Searchint
4Buy-from Vendor No_ Searchnvarchar(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_]
5Type Searchint
6No_ Searchnvarchar(40)
7Location Code Searchnvarchar(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]
8Posting Group Searchnvarchar(40)
9Expected Receipt Date Searchdatetime
10Description Searchnvarchar(200)
11Description 2 Searchnvarchar(100)
12Unit of Measure Searchnvarchar(100)
13Quantity Searchdecimal(38,38)
14Direct Unit Cost Searchdecimal(38,38)
15Unit Cost (LCY) Searchdecimal(38,38)
16VAT _ Searchdecimal(38,38)
17Line Discount _ Searchdecimal(38,38)
18Line Discount Amount Searchdecimal(38,38)
19Amount Searchdecimal(38,38)
20Amount Including VAT Searchdecimal(38,38)
21Unit Price (LCY) Searchdecimal(38,38)
22Allow Invoice Disc_ Searchtinyint
23Gross Weight Searchdecimal(38,38)
24Net Weight Searchdecimal(38,38)
25Units per Parcel Searchdecimal(38,38)
26Unit Volume Searchdecimal(38,38)
27Appl_-to Item Entry Searchint
28Shortcut Dimension 1 Code Searchnvarchar(40)
29Shortcut Dimension 2 Code Searchnvarchar(40)
30Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Purch_ Inv_ Line].[Job No_]
       ,[Job].[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].[Job No_]
31Indirect Cost _ Searchdecimal(38,38)
32Receipt No_ Searchnvarchar(40)
33Receipt Line No_ Searchint
34Order No_ Searchnvarchar(40)
35Order Line No_ Searchint
36Pay-to Vendor No_ Searchnvarchar(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_]
37Inv_ Discount Amount Searchdecimal(38,38)
38Vendor Item No_ Searchnvarchar(100)
39Gen_ Bus_ Posting Group Searchnvarchar(40)
40Gen_ Prod_ Posting Group Searchnvarchar(40)
41VAT Calculation Type Searchint
42Transaction Type Searchnvarchar(20)
43Transport Method Searchnvarchar(20)
44Attached to Line No_ Searchint
45Entry Point Searchnvarchar(20)
46Area Searchnvarchar(20)
47Transaction Specification Searchnvarchar(20)
48Tax Area Code Searchnvarchar(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]
49Tax Liable Searchtinyint
50Tax Group Code Searchnvarchar(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]
51Use Tax Searchtinyint
52VAT Bus_ Posting Group Searchnvarchar(40)
53VAT Prod_ Posting Group Searchnvarchar(40)
54Blanket Order No_ Searchnvarchar(40)
55Blanket Order Line No_ Searchint
56VAT Base Amount Searchdecimal(38,38)
57Unit Cost Searchdecimal(38,38)
58System-Created Entry Searchtinyint
59Line Amount Searchdecimal(38,38)
60VAT Difference Searchdecimal(38,38)
61VAT Identifier Searchnvarchar(40)
62IC Partner Ref_ Type Searchint
63IC Partner Reference Searchnvarchar(40)
64Prepayment Line Searchtinyint
65IC Partner Code Searchnvarchar(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]
66Posting Date Searchdatetime
67IC Cross-Reference No_ Searchnvarchar(100)
68Pmt_ Discount Amount Searchdecimal(38,38)
69Dimension Set ID Searchint
70Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Purch_ Inv_ Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Purch_ Inv_ Line].[Job Task No_] = [Job Task].[Job Task No_]
71Job Line Type Searchint
72Job Unit Price Searchdecimal(38,38)
73Job Total Price Searchdecimal(38,38)
74Job Line Amount Searchdecimal(38,38)
75Job Line Discount Amount Searchdecimal(38,38)
76Job Line Discount _ Searchdecimal(38,38)
77Job Unit Price (LCY) Searchdecimal(38,38)
78Job Total Price (LCY) Searchdecimal(38,38)
79Job Line Amount (LCY) Searchdecimal(38,38)
80Job Line Disc_ Amount (LCY) Searchdecimal(38,38)
81Job Currency Factor Searchdecimal(38,38)
82Job Currency Code Searchnvarchar(40)
83Deferral Code Searchnvarchar(20)
84Prod_ Order No_ Searchnvarchar(40)
85Variant Code Searchnvarchar(20)
86Bin Code Searchnvarchar(40)
87Qty_ per Unit of Measure Searchdecimal(38,38)
88Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Purch_ Inv_ Line].[Unit of Measure Code]
       ,[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 Code] = [Unit of Measure].[Code]
89Quantity (Base) Searchdecimal(38,38)
90FA Posting Date Searchdatetime
91FA Posting Type Searchint
92Depreciation Book Code Searchnvarchar(20)
93Salvage Value Searchdecimal(38,38)
94Depr_ until FA Posting Date Searchtinyint
95Depr_ Acquisition Cost Searchtinyint
96Maintenance Code Searchnvarchar(20)
97Insurance No_ Searchnvarchar(40)
98Budgeted FA No_ Searchnvarchar(40)
99Duplicate in Depreciation Book Searchnvarchar(20)
100Use Duplication List Searchtinyint
101Responsibility Center Searchnvarchar(20)
102Cross-Reference No_ Searchnvarchar(40)
103Unit of Measure (Cross Ref_) Searchnvarchar(20)
104Cross-Reference Type Searchint
105Cross-Reference Type No_ Searchnvarchar(60)
106Item Category Code Searchnvarchar(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]
107Nonstock Searchtinyint
108Purchasing Code Searchnvarchar(20)
109Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Purch_ Inv_ Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Purch_ Inv_ Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purch_ Inv_ Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Purch_ Inv_ Line].[Product Group Code] = [Product Group].[Code]
110Item Reference No_ Searchnvarchar(100)
111Item Reference Unit of Measure Searchnvarchar(20)
112Item Reference Type Searchint
113Item Reference Type No_ Searchnvarchar(60)
114Return Reason Code Searchnvarchar(20)
115Price Calculation Method Searchint
116Reverse Charge Item Searchtinyint
117Reverse Charge Searchdecimal(38,38)
118Routing No_ Searchnvarchar(40)
119Operation No_ Searchnvarchar(20)
120Work Center No_ Searchnvarchar(40)
121Prod_ Order Line No_ Searchint
122Overhead Rate Searchdecimal(38,38)
123Routing Reference No_ Searchint
124$systemId Searchuniqueidentifier
125$systemCreatedAt Searchdatetime
126$systemCreatedBy Searchuniqueidentifier
127$systemModifiedAt Searchdatetime
128$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purch_ Inv_ Line table

Leave a Reply

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