Purchase Line

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

Table Type: Company

Table Name: Purchase Line
Database Table Name: CRONUS UK Ltd_$Purchase 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 Purchase Line can be queried.

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Line No_]
   ,[Buy-from Vendor No_]
   ,[Type]
   ,[No_]
   ,[Location Code]
   ,[Posting Group]
   ,[Expected Receipt Date]
   ,[Description]
   ,[Description 2]
   ,[Unit of Measure]
   ,[Quantity]
   ,[Outstanding Quantity]
   ,[Qty_ to Invoice]
   ,[Qty_ to Receive]
   ,[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 _]
   ,[Recalculate Invoice Disc_]
   ,[Outstanding Amount]
   ,[Qty_ Rcd_ Not Invoiced]
   ,[Amt_ Rcd_ Not Invoiced]
   ,[Quantity Received]
   ,[Quantity Invoiced]
   ,[Receipt No_]
   ,[Receipt Line No_]
   ,[Order No_]
   ,[Order Line No_]
   ,[Profit _]
   ,[Pay-to Vendor No_]
   ,[Inv_ Discount Amount]
   ,[Vendor Item No_]
   ,[Sales Order No_]
   ,[Sales Order Line No_]
   ,[Drop Shipment]
   ,[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]
   ,[Currency Code]
   ,[Outstanding Amount (LCY)]
   ,[Amt_ Rcd_ Not Invoiced (LCY)]
   ,[Blanket Order No_]
   ,[Blanket Order Line No_]
   ,[VAT Base Amount]
   ,[Unit Cost]
   ,[System-Created Entry]
   ,[Line Amount]
   ,[VAT Difference]
   ,[Inv_ Disc_ Amount to Invoice]
   ,[VAT Identifier]
   ,[IC Partner Ref_ Type]
   ,[IC Partner Reference]
   ,[Prepayment _]
   ,[Prepmt_ Line Amount]
   ,[Prepmt_ Amt_ Inv_]
   ,[Prepmt_ Amt_ Incl_ VAT]
   ,[Prepayment Amount]
   ,[Prepmt_ VAT Base Amt_]
   ,[Prepayment VAT _]
   ,[Prepmt_ VAT Calc_ Type]
   ,[Prepayment VAT Identifier]
   ,[Prepayment Tax Area Code]
   ,[Prepayment Tax Liable]
   ,[Prepayment Tax Group Code]
   ,[Prepmt Amt to Deduct]
   ,[Prepmt Amt Deducted]
   ,[Prepayment Line]
   ,[Prepmt_ Amount Inv_ Incl_ VAT]
   ,[Prepmt_ Amount Inv_ (LCY)]
   ,[IC Partner Code]
   ,[Prepmt_ VAT Amount Inv_ (LCY)]
   ,[Prepayment VAT Difference]
   ,[Prepmt VAT Diff_ to Deduct]
   ,[Prepmt VAT Diff_ Deducted]
   ,[IC Item Reference No_]
   ,[Outstanding Amt_ Ex_ VAT (LCY)]
   ,[A_ Rcd_ Not Inv_ Ex_ VAT (LCY)]
   ,[Pmt_ Discount Amount]
   ,[Prepmt_ 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]
   ,[Job Planning Line No_]
   ,[Job Remaining Qty_]
   ,[Job Remaining Qty_ (Base)]
   ,[Deferral Code]
   ,[Returns Deferral Start Date]
   ,[Prod_ Order No_]
   ,[Variant Code]
   ,[Bin Code]
   ,[Qty_ per Unit of Measure]
   ,[Qty_ Rounding Precision]
   ,[Qty_ Rounding Precision (Base)]
   ,[Unit of Measure Code]
   ,[Quantity (Base)]
   ,[Outstanding Qty_ (Base)]
   ,[Qty_ to Invoice (Base)]
   ,[Qty_ to Receive (Base)]
   ,[Qty_ Rcd_ Not Invoiced (Base)]
   ,[Qty_ Received (Base)]
   ,[Qty_ Invoiced (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]
   ,[Special Order]
   ,[Special Order Sales No_]
   ,[Special Order Sales Line No_]
   ,[Item Reference No_]
   ,[Item Reference Unit of Measure]
   ,[Item Reference Type]
   ,[Item Reference Type No_]
   ,[Completely Received]
   ,[Requested Receipt Date]
   ,[Promised Receipt Date]
   ,[Lead Time Calculation]
   ,[Inbound Whse_ Handling Time]
   ,[Planned Receipt Date]
   ,[Order Date]
   ,[Allow Item Charge Assignment]
   ,[Return Qty_ to Ship]
   ,[Return Qty_ to Ship (Base)]
   ,[Return Qty_ Shipped Not Invd_]
   ,[Ret_ Qty_ Shpd Not Invd_(Base)]
   ,[Return Shpd_ Not Invd_]
   ,[Return Shpd_ Not Invd_ (LCY)]
   ,[Return Qty_ Shipped]
   ,[Return Qty_ Shipped (Base)]
   ,[Return Shipment No_]
   ,[Return Shipment Line No_]
   ,[Return Reason Code]
   ,[Subtype]
   ,[Copied From Posted Doc_]
   ,[Price Calculation Method]
   ,[Over-Receipt Quantity]
   ,[Over-Receipt Code]
   ,[Over-Receipt Approval Status]
   ,[Reverse Charge Item]
   ,[Routing No_]
   ,[Operation No_]
   ,[Work Center No_]
   ,[Finished]
   ,[Prod_ Order Line No_]
   ,[Overhead Rate]
   ,[MPS Order]
   ,[Planning Flexibility]
   ,[Safety Lead Time]
   ,[Routing Reference No_]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]
FROM
   [CRONUS UK Ltd_$Purchase 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_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Line].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purchase Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Purchase Line].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Line].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purchase Line].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Purchase Line].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purchase Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Purchase Line].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Purchase 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
         [Purchase 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
         [Purchase Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Purchase Line].[Product Group Code] = [Product Group].[Code]

Show/hide columns in Purchase Line table

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

Show/hide example query

SELECT
       [Purchase Line].[Buy-from Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Line].[Buy-from Vendor No_] = [Vendor].[No_]
6Type Searchint
7No_ Searchnvarchar(40)
8Location Code Searchnvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Purchase Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Purchase Line].[Location Code] = [Location].[Code]
9Posting Group Searchnvarchar(40)
10Expected Receipt Date Searchdatetime
11Description Searchnvarchar(200)
12Description 2 Searchnvarchar(100)
13Unit of Measure Searchnvarchar(100)
14Quantity Searchdecimal(38,38)
15Outstanding Quantity Searchdecimal(38,38)
16Qty_ to Invoice Searchdecimal(38,38)
17Qty_ to Receive Searchdecimal(38,38)
18Direct Unit Cost Searchdecimal(38,38)
19Unit Cost (LCY) Searchdecimal(38,38)
20VAT _ Searchdecimal(38,38)
21Line Discount _ Searchdecimal(38,38)
22Line Discount Amount Searchdecimal(38,38)
23Amount Searchdecimal(38,38)
24Amount Including VAT Searchdecimal(38,38)
25Unit Price (LCY) Searchdecimal(38,38)
26Allow Invoice Disc_ Searchtinyint
27Gross Weight Searchdecimal(38,38)
28Net Weight Searchdecimal(38,38)
29Units per Parcel Searchdecimal(38,38)
30Unit Volume Searchdecimal(38,38)
31Appl_-to Item Entry Searchint
32Shortcut Dimension 1 Code Searchnvarchar(40)
33Shortcut Dimension 2 Code Searchnvarchar(40)
34Job No_ Searchnvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Purchase Line].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Purchase Line].[Job No_] = [Job].[Job No_]
35Indirect Cost _ Searchdecimal(38,38)
36Recalculate Invoice Disc_ Searchtinyint
37Outstanding Amount Searchdecimal(38,38)
38Qty_ Rcd_ Not Invoiced Searchdecimal(38,38)
39Amt_ Rcd_ Not Invoiced Searchdecimal(38,38)
40Quantity Received Searchdecimal(38,38)
41Quantity Invoiced Searchdecimal(38,38)
42Receipt No_ Searchnvarchar(40)
43Receipt Line No_ Searchint
44Order No_ Searchnvarchar(40)
45Order Line No_ Searchint
46Profit _ Searchdecimal(38,38)
47Pay-to Vendor No_ Searchnvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Purchase Line].[Pay-to Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Line].[Pay-to Vendor No_] = [Vendor].[No_]
48Inv_ Discount Amount Searchdecimal(38,38)
49Vendor Item No_ Searchnvarchar(100)
50Sales Order No_ Searchnvarchar(40)
51Sales Order Line No_ Searchint
52Drop Shipment Searchtinyint
53Gen_ Bus_ Posting Group Searchnvarchar(40)
54Gen_ Prod_ Posting Group Searchnvarchar(40)
55VAT Calculation Type Searchint
56Transaction Type Searchnvarchar(20)
57Transport Method Searchnvarchar(20)
58Attached to Line No_ Searchint
59Entry Point Searchnvarchar(20)
60Area Searchnvarchar(20)
61Transaction Specification Searchnvarchar(20)
62Tax Area Code Searchnvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Purchase Line].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Purchase Line].[Tax Area Code] = [Tax Area].[Code]
63Tax Liable Searchtinyint
64Tax Group Code Searchnvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Purchase Line].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Purchase Line].[Tax Group Code] = [Tax Group].[Code]
65Use Tax Searchtinyint
66VAT Bus_ Posting Group Searchnvarchar(40)
67VAT Prod_ Posting Group Searchnvarchar(40)
68Currency Code Searchnvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Purchase Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Purchase Line].[Currency Code] = [Currency].[Code]
69Outstanding Amount (LCY) Searchdecimal(38,38)
70Amt_ Rcd_ Not Invoiced (LCY) Searchdecimal(38,38)
71Blanket Order No_ Searchnvarchar(40)
72Blanket Order Line No_ Searchint
73VAT Base Amount Searchdecimal(38,38)
74Unit Cost Searchdecimal(38,38)
75System-Created Entry Searchtinyint
76Line Amount Searchdecimal(38,38)
77VAT Difference Searchdecimal(38,38)
78Inv_ Disc_ Amount to Invoice Searchdecimal(38,38)
79VAT Identifier Searchnvarchar(40)
80IC Partner Ref_ Type Searchint
81IC Partner Reference Searchnvarchar(40)
82Prepayment _ Searchdecimal(38,38)
83Prepmt_ Line Amount Searchdecimal(38,38)
84Prepmt_ Amt_ Inv_ Searchdecimal(38,38)
85Prepmt_ Amt_ Incl_ VAT Searchdecimal(38,38)
86Prepayment Amount Searchdecimal(38,38)
87Prepmt_ VAT Base Amt_ Searchdecimal(38,38)
88Prepayment VAT _ Searchdecimal(38,38)
89Prepmt_ VAT Calc_ Type Searchint
90Prepayment VAT Identifier Searchnvarchar(40)
91Prepayment Tax Area Code Searchnvarchar(40)
92Prepayment Tax Liable Searchtinyint
93Prepayment Tax Group Code Searchnvarchar(40)
94Prepmt Amt to Deduct Searchdecimal(38,38)
95Prepmt Amt Deducted Searchdecimal(38,38)
96Prepayment Line Searchtinyint
97Prepmt_ Amount Inv_ Incl_ VAT Searchdecimal(38,38)
98Prepmt_ Amount Inv_ (LCY) Searchdecimal(38,38)
99IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Purchase Line].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Purchase Line].[IC Partner Code] = [IC Partner].[Code]
100Prepmt_ VAT Amount Inv_ (LCY) Searchdecimal(38,38)
101Prepayment VAT Difference Searchdecimal(38,38)
102Prepmt VAT Diff_ to Deduct Searchdecimal(38,38)
103Prepmt VAT Diff_ Deducted Searchdecimal(38,38)
104IC Item Reference No_ Searchnvarchar(100)
105Outstanding Amt_ Ex_ VAT (LCY) Searchdecimal(38,38)
106A_ Rcd_ Not Inv_ Ex_ VAT (LCY) Searchdecimal(38,38)
107Pmt_ Discount Amount Searchdecimal(38,38)
108Prepmt_ Pmt_ Discount Amount Searchdecimal(38,38)
109Dimension Set ID Searchint
110Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

SELECT
       [Purchase Line].[Job Task No_]
       ,[Job Task].[Job Task No_]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
              ON
                     [Purchase Line].[Job Task No_] = [Job Task].[Job Task No_]
111Job Line Type Searchint
112Job Unit Price Searchdecimal(38,38)
113Job Total Price Searchdecimal(38,38)
114Job Line Amount Searchdecimal(38,38)
115Job Line Discount Amount Searchdecimal(38,38)
116Job Line Discount _ Searchdecimal(38,38)
117Job Unit Price (LCY) Searchdecimal(38,38)
118Job Total Price (LCY) Searchdecimal(38,38)
119Job Line Amount (LCY) Searchdecimal(38,38)
120Job Line Disc_ Amount (LCY) Searchdecimal(38,38)
121Job Currency Factor Searchdecimal(38,38)
122Job Currency Code Searchnvarchar(40)
123Job Planning Line No_ Searchint
124Job Remaining Qty_ Searchdecimal(38,38)
125Job Remaining Qty_ (Base) Searchdecimal(38,38)
126Deferral Code Searchnvarchar(20)
127Returns Deferral Start Date Searchdatetime
128Prod_ Order No_ Searchnvarchar(40)
129Variant Code Searchnvarchar(20)
130Bin Code Searchnvarchar(40)
131Qty_ per Unit of Measure Searchdecimal(38,38)
132Qty_ Rounding Precision Searchdecimal(38,38)
133Qty_ Rounding Precision (Base) Searchdecimal(38,38)
134Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Purchase Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Purchase Line].[Unit of Measure Code] = [Unit of Measure].[Code]
135Quantity (Base) Searchdecimal(38,38)
136Outstanding Qty_ (Base) Searchdecimal(38,38)
137Qty_ to Invoice (Base) Searchdecimal(38,38)
138Qty_ to Receive (Base) Searchdecimal(38,38)
139Qty_ Rcd_ Not Invoiced (Base) Searchdecimal(38,38)
140Qty_ Received (Base) Searchdecimal(38,38)
141Qty_ Invoiced (Base) Searchdecimal(38,38)
142FA Posting Date Searchdatetime
143FA Posting Type Searchint
144Depreciation Book Code Searchnvarchar(20)
145Salvage Value Searchdecimal(38,38)
146Depr_ until FA Posting Date Searchtinyint
147Depr_ Acquisition Cost Searchtinyint
148Maintenance Code Searchnvarchar(20)
149Insurance No_ Searchnvarchar(40)
150Budgeted FA No_ Searchnvarchar(40)
151Duplicate in Depreciation Book Searchnvarchar(20)
152Use Duplication List Searchtinyint
153Responsibility Center Searchnvarchar(20)
154Cross-Reference No_ Searchnvarchar(40)
155Unit of Measure (Cross Ref_) Searchnvarchar(20)
156Cross-Reference Type Searchint
157Cross-Reference Type No_ Searchnvarchar(60)
158Item Category Code Searchnvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Purchase Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Purchase Line].[Item Category Code] = [Item Category].[Code]
159Nonstock Searchtinyint
160Purchasing Code Searchnvarchar(20)
161Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Purchase Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Purchase Line].[Product Group Code] = [Product Group].[Code]
162Special Order Searchtinyint
163Special Order Sales No_ Searchnvarchar(40)
164Special Order Sales Line No_ Searchint
165Item Reference No_ Searchnvarchar(100)
166Item Reference Unit of Measure Searchnvarchar(20)
167Item Reference Type Searchint
168Item Reference Type No_ Searchnvarchar(60)
169Completely Received Searchtinyint
170Requested Receipt Date Searchdatetime
171Promised Receipt Date Searchdatetime
172Lead Time Calculation Searchvarchar(32)
173Inbound Whse_ Handling Time Searchvarchar(32)
174Planned Receipt Date Searchdatetime
175Order Date Searchdatetime
176Allow Item Charge Assignment Searchtinyint
177Return Qty_ to Ship Searchdecimal(38,38)
178Return Qty_ to Ship (Base) Searchdecimal(38,38)
179Return Qty_ Shipped Not Invd_ Searchdecimal(38,38)
180Ret_ Qty_ Shpd Not Invd_(Base) Searchdecimal(38,38)
181Return Shpd_ Not Invd_ Searchdecimal(38,38)
182Return Shpd_ Not Invd_ (LCY) Searchdecimal(38,38)
183Return Qty_ Shipped Searchdecimal(38,38)
184Return Qty_ Shipped (Base) Searchdecimal(38,38)
185Return Shipment No_ Searchnvarchar(40)
186Return Shipment Line No_ Searchint
187Return Reason Code Searchnvarchar(20)
188Subtype Searchint
189Copied From Posted Doc_ Searchtinyint
190Price Calculation Method Searchint
191Over-Receipt Quantity Searchdecimal(38,38)
192Over-Receipt Code Searchnvarchar(40)
193Over-Receipt Approval Status Searchint
194Reverse Charge Item Searchtinyint
195Routing No_ Searchnvarchar(40)
196Operation No_ Searchnvarchar(20)
197Work Center No_ Searchnvarchar(40)
198Finished Searchtinyint
199Prod_ Order Line No_ Searchint
200Overhead Rate Searchdecimal(38,38)
201MPS Order Searchtinyint
202Planning Flexibility Searchint
203Safety Lead Time Searchvarchar(32)
204Routing Reference No_ Searchint
205$systemId Searchuniqueidentifier
206$systemCreatedAt Searchdatetime
207$systemCreatedBy Searchuniqueidentifier
208$systemModifiedAt Searchdatetime
209$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purchase Line table

Leave a Reply

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