Purchase Line Archive

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

Table Type: Company

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

Table Number: 5110

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

Show/hide an example select of all columns

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

Show/hide an example select of all columns by name

SELECT
   [timestamp]
   ,[Document Type]
   ,[Document No_]
   ,[Doc_ No_ Occurrence]
   ,[Version 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 _]
   ,[Quantity Disc_ _]
   ,[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 _]
   ,[Outstanding Amount]
   ,[Qty_ Rcd_ Not Invoiced]
   ,[Amt_ Rcd_ Not Invoiced]
   ,[Quantity Received]
   ,[Quantity Invoiced]
   ,[Receipt No_]
   ,[Receipt 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]
   ,[IC Partner Code]
   ,[IC Item 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]
   ,[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]
   ,[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]
   ,[Price Calculation Method]
   ,[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 Archive$437dbf0e-84ff-417a-965d-ed2bb9650972]

Show/hide an example select of all columns including those from all joined tables

SELECT
   *
FROM
   [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Line Archive].[Buy-from Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Purchase Line Archive].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
      ON
         [Purchase Line Archive].[Job No_] = [Job].[Job No_]
LEFT JOIN
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Purchase Line Archive].[Pay-to Vendor No_] = [Vendor].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purchase Line Archive].[Tax Area Code] = [Tax Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
      ON
         [Purchase Line Archive].[Tax Group Code] = [Tax Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Purchase Line Archive].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
      ON
         [Purchase Line Archive].[IC Partner Code] = [IC Partner].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Job Task$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job Task]
      ON
         [Purchase Line Archive].[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 Archive].[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 Archive].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Purchase Line Archive].[Product Group Code] = [Product Group].[Code]

Show/hide columns in Purchase Line Archive table

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Purchase Line Archive].[Job No_]
       ,[Job].[Job No_]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Job$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Job]
              ON
                     [Purchase Line Archive].[Job No_] = [Job].[Job No_]
38Indirect Cost _ Searchdecimal(38,38)
39Outstanding Amount Searchdecimal(38,38)
40Qty_ Rcd_ Not Invoiced Searchdecimal(38,38)
41Amt_ Rcd_ Not Invoiced Searchdecimal(38,38)
42Quantity Received Searchdecimal(38,38)
43Quantity Invoiced Searchdecimal(38,38)
44Receipt No_ Searchnvarchar(40)
45Receipt 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 Archive].[Pay-to Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Purchase Line Archive].[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 Archive].[Tax Area Code]
       ,[Tax Area].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
              ON
                     [Purchase Line Archive].[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 Archive].[Tax Group Code]
       ,[Tax Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Tax Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Group]
              ON
                     [Purchase Line Archive].[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 Archive].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Purchase Line Archive].[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)
98IC Partner Code Searchnvarchar(40)
Key to join to the IC Partner table.

Show/hide example query

SELECT
       [Purchase Line Archive].[IC Partner Code]
       ,[IC Partner].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$IC Partner$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [IC Partner]
              ON
                     [Purchase Line Archive].[IC Partner Code] = [IC Partner].[Code]
99IC Item Reference No_ Searchnvarchar(100)
100Pmt_ Discount Amount Searchdecimal(38,38)
101Dimension Set ID Searchint
102Job Task No_ Searchnvarchar(40)
Key to join to the Job Task table.

Show/hide example query

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

Show/hide example query

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

Show/hide example query

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

Show/hide example query

SELECT
       [Purchase Line Archive].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Purchase Line Archive].[Product Group Code] = [Product Group].[Code]
152Special Order Searchtinyint
153Special Order Sales No_ Searchnvarchar(40)
154Special Order Sales Line No_ Searchint
155Item Reference No_ Searchnvarchar(100)
156Item Reference Unit of Measure Searchnvarchar(20)
157Item Reference Type Searchint
158Item Reference Type No_ Searchnvarchar(60)
159Completely Received Searchtinyint
160Requested Receipt Date Searchdatetime
161Promised Receipt Date Searchdatetime
162Lead Time Calculation Searchvarchar(32)
163Inbound Whse_ Handling Time Searchvarchar(32)
164Planned Receipt Date Searchdatetime
165Order Date Searchdatetime
166Allow Item Charge Assignment Searchtinyint
167Return Qty_ to Ship Searchdecimal(38,38)
168Return Qty_ to Ship (Base) Searchdecimal(38,38)
169Return Qty_ Shipped Not Invd_ Searchdecimal(38,38)
170Ret_ Qty_ Shpd Not Invd_(Base) Searchdecimal(38,38)
171Return Shpd_ Not Invd_ Searchdecimal(38,38)
172Return Shpd_ Not Invd_ (LCY) Searchdecimal(38,38)
173Return Qty_ Shipped Searchdecimal(38,38)
174Return Qty_ Shipped (Base) Searchdecimal(38,38)
175Return Shipment No_ Searchnvarchar(40)
176Return Shipment Line No_ Searchint
177Return Reason Code Searchnvarchar(20)
178Price Calculation Method Searchint
179Routing No_ Searchnvarchar(40)
180Operation No_ Searchnvarchar(20)
181Work Center No_ Searchnvarchar(40)
182Finished Searchtinyint
183Prod_ Order Line No_ Searchint
184Overhead Rate Searchdecimal(38,38)
185MPS Order Searchtinyint
186Planning Flexibility Searchint
187Safety Lead Time Searchvarchar(32)
188Routing Reference No_ Searchint
189$systemId Searchuniqueidentifier
190$systemCreatedAt Searchdatetime
191$systemCreatedBy Searchuniqueidentifier
192$systemModifiedAt Searchdatetime
193$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Purchase Line Archive table

Leave a Reply

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