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
   [Document Type]
   ,[Buy-from Vendor No_]
   ,[Document No_]
   ,[Line 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]
   ,[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]
   ,[Version No_]
   ,[Doc_ No_ Occurrence]
   ,[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)]
   ,[Non-Deductible VAT _]
   ,[Non-Deductible VAT Base]
   ,[Non-Deductible VAT Amount]
   ,[Non-Deductible VAT Diff_]
   ,[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_$Sales Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header]
      ON
         [Purchase Line Archive].[Document Type] = [Sales Header].[Document Type]
      AND
         [Purchase Line Archive].[Document No_] = [Sales Header].[No_]
LEFT JOIN
   [CRONUS UK Ltd_$Sales Header Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Sales Header Archive]
      ON
         [Purchase Line Archive].[Document Type] = [Sales Header Archive].[Document Type]
      AND
         [Purchase Line Archive].[Document No_] = [Sales Header Archive].[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_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
      ON
         [Purchase Line Archive].[Posting Group] = [Customer Posting Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Purchase Line Archive].[Unit of Measure] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purchase Line Archive].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Purchase Line Archive].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
      ON
         [Purchase Line Archive].[Transaction Type] = [Transaction Type].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
      ON
         [Purchase Line Archive].[Transport Method] = [Transport Method].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
      ON
         [Purchase Line Archive].[Entry Point] = [Entry/Exit Point].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
      ON
         [Purchase Line Archive].[Area] = [Area].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
      ON
         [Purchase Line Archive].[Transaction Specification] = [Transaction Specification].[Code]
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_$Tax Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Tax Area]
      ON
         [Purchase Line Archive].[Prepayment 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].[Prepayment Tax Group Code] = [Tax Group].[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_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Purchase Line Archive].[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
         [Purchase Line Archive].[Deferral Code] = [Deferral Template].[Deferral Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Purchase Line Archive].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Purchase Line Archive].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Purchase Line Archive].[Depreciation Book Code] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
      ON
         [Purchase Line Archive].[Maintenance Code] = [Maintenance].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
      ON
         [Purchase Line Archive].[Duplicate in Depreciation Book] = [Depreciation Book].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
      ON
         [Purchase Line Archive].[Responsibility Center] = [Responsibility Center].[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_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Purchase Line Archive].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
      ON
         [Purchase Line Archive].[Return Reason Code] = [Return Reason].[Code]
LEFT JOIN
   [User] AS [User]
      ON
         [Purchase Line Archive].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Purchase Line Archive].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Purchase Line Archive table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Document Type Primary Key SearchDocument TypeNormalOption4Document Typeint
Available options are:
  • “Quote”
  • “Order”
  • “Invoice”
  • “Credit Memo”
  • “Blanket Order”
  • “Return Order”
2Buy-from Vendor No. SearchBuy-from Vendor No.NormalCode20Buy-from Vendor No_nvarchar(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_]
3Document No. Primary Key SearchDocument No.NormalCode20Document No_nvarchar(40)
4Line No. Primary Key SearchLine No.NormalInteger4Line No_int
5Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “G/L Account”
  • “Item”
  • “Resource”
  • “Fixed Asset”
  • “Charge (Item)”
  • “Allocation Account”
6No. SearchNo.NormalCode20No_nvarchar(40)
7Location Code SearchLocation CodeNormalCode10Location Codenvarchar(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]
8Posting Group SearchPosting GroupNormalCode20Posting Groupnvarchar(40)
Key to join to the Customer Posting Group table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Posting Group]
       ,[Customer Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Customer Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer Posting Group]
              ON
                     [Purchase Line Archive].[Posting Group] = [Customer Posting Group].[Code]
10Expected Receipt Date SearchExpected Receipt DateNormalDate4Expected Receipt Datedatetime
11Description SearchDescriptionNormalText100Descriptionnvarchar(200)
12Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
13Unit of Measure SearchUnit of MeasureNormalText50Unit of Measurenvarchar(100)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Unit of Measure]
       ,[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] = [Unit of Measure].[Code]
15Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
16Outstanding Quantity SearchOutstanding QuantityNormalDecimal12Outstanding Quantitydecimal(38,38)
17Qty. to Invoice SearchQty. to InvoiceNormalDecimal12Qty_ to Invoicedecimal(38,38)
18Qty. to Receive SearchQty. to ReceiveNormalDecimal12Qty_ to Receivedecimal(38,38)
22Direct Unit Cost SearchDirect Unit CostNormalDecimal12Direct Unit Costdecimal(38,38)
23Unit Cost (LCY) SearchUnit Cost ($)NormalDecimal12Unit Cost (LCY)decimal(38,38)
25VAT % SearchTax %NormalDecimal12VAT _decimal(38,38)
26Quantity Disc. % SearchQuantity Disc. %NormalDecimal12Quantity Disc_ _decimal(38,38)
27Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
28Line Discount Amount SearchLine Discount AmountNormalDecimal12Line Discount Amountdecimal(38,38)
29Amount SearchAmountNormalDecimal12Amountdecimal(38,38)
30Amount Including VAT SearchAmount Including TaxNormalDecimal12Amount Including VATdecimal(38,38)
31Unit Price (LCY) SearchUnit Price ($)NormalDecimal12Unit Price (LCY)decimal(38,38)
32Allow Invoice Disc. SearchAllow Invoice Disc.NormalBoolean4Allow Invoice Disc_tinyint
34Gross Weight SearchGross WeightNormalDecimal12Gross Weightdecimal(38,38)
35Net Weight SearchNet WeightNormalDecimal12Net Weightdecimal(38,38)
36Units per Parcel SearchUnits per ParcelNormalDecimal12Units per Parceldecimal(38,38)
37Unit Volume SearchUnit VolumeNormalDecimal12Unit Volumedecimal(38,38)
38Appl.-to Item Entry SearchAppl.-to Item EntryNormalInteger4Appl_-to Item Entryint
40Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Shortcut Dimension 1 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Purchase Line Archive].[Shortcut Dimension 1 Code] = [Dimension].[Code]
41Shortcut Dimension 2 Code SearchShortcut Dimension 2 CodeNormalCode20Shortcut Dimension 2 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Purchase Line Archive].[Shortcut Dimension 2 Code] = [Dimension].[Code]
45Job No. SearchJob No.NormalCode20Job No_nvarchar(40)
Key to join to the Job table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Job No_]
       ,[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].[No_]
54Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
57Outstanding Amount SearchOutstanding AmountNormalDecimal12Outstanding Amountdecimal(38,38)
58Qty. Rcd. Not Invoiced SearchQty. Rcd. Not InvoicedNormalDecimal12Qty_ Rcd_ Not Invoiceddecimal(38,38)
59Amt. Rcd. Not Invoiced SearchAmt. Rcd. Not InvoicedNormalDecimal12Amt_ Rcd_ Not Invoiceddecimal(38,38)
60Quantity Received SearchQuantity ReceivedNormalDecimal12Quantity Receiveddecimal(38,38)
61Quantity Invoiced SearchQuantity InvoicedNormalDecimal12Quantity Invoiceddecimal(38,38)
63Receipt No. SearchReceipt No.NormalCode20Receipt No_nvarchar(40)
64Receipt Line No. SearchReceipt Line No.NormalInteger4Receipt Line No_int
67Profit % SearchProfit %NormalDecimal12Profit _decimal(38,38)
68Pay-to Vendor No. SearchVendor No.NormalCode20Pay-to Vendor No_nvarchar(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_]
69Inv. Discount Amount SearchInv. Discount AmountNormalDecimal12Inv_ Discount Amountdecimal(38,38)
70Vendor Item No. SearchVendor Item No.NormalText50Vendor Item No_nvarchar(100)
71Sales Order No. SearchSales Order No.NormalCode20Sales Order No_nvarchar(40)
72Sales Order Line No. SearchSales Order Line No.NormalInteger4Sales Order Line No_int
73Drop Shipment SearchDrop ShipmentNormalBoolean4Drop Shipmenttinyint
74Gen. Bus. Posting Group SearchGen. Bus. Posting GroupNormalCode20Gen_ Bus_ Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Gen_ Bus_ Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Purchase Line Archive].[Gen_ Bus_ Posting Group] = [Gen. Business Posting Group].[Code]
75Gen. Prod. Posting Group SearchGen. Prod. Posting GroupNormalCode20Gen_ Prod_ Posting Groupnvarchar(40)
Key to join to the Gen. Product Posting Group table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Purchase Line Archive].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
77VAT Calculation Type SearchVAT Calculation TypeNormalOption4VAT Calculation Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
78Transaction Type SearchTransaction TypeNormalCode10Transaction Typenvarchar(20)
Key to join to the Transaction Type table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Transaction Type]
       ,[Transaction Type].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Type$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Type]
              ON
                     [Purchase Line Archive].[Transaction Type] = [Transaction Type].[Code]
79Transport Method SearchTransport MethodNormalCode10Transport Methodnvarchar(20)
Key to join to the Transport Method table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Transport Method]
       ,[Transport Method].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Transport Method$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transport Method]
              ON
                     [Purchase Line Archive].[Transport Method] = [Transport Method].[Code]
80Attached to Line No. SearchAttached to Line No.NormalInteger4Attached to Line No_int
81Entry Point SearchEntry PointNormalCode10Entry Pointnvarchar(20)
Key to join to the Entry/Exit Point table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Entry Point]
       ,[Entry/Exit Point].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Entry_Exit Point$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Entry/Exit Point]
              ON
                     [Purchase Line Archive].[Entry Point] = [Entry/Exit Point].[Code]
82Area SearchAreaNormalCode10Areanvarchar(20)
Key to join to the Area table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Area]
       ,[Area].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Area$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Area]
              ON
                     [Purchase Line Archive].[Area] = [Area].[Code]
83Transaction Specification SearchTransaction SpecificationNormalCode10Transaction Specificationnvarchar(20)
Key to join to the Transaction Specification table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Transaction Specification]
       ,[Transaction Specification].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Transaction Specification$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Transaction Specification]
              ON
                     [Purchase Line Archive].[Transaction Specification] = [Transaction Specification].[Code]
85Tax Area Code SearchTax Area CodeNormalCode20Tax Area Codenvarchar(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]
86Tax Liable SearchTax LiableNormalBoolean4Tax Liabletinyint
87Tax Group Code SearchTax Group CodeNormalCode20Tax Group Codenvarchar(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]
88Use Tax SearchUse TaxNormalBoolean4Use Taxtinyint
89VAT Bus. Posting Group SearchVAT Bus. Posting GroupNormalCode20VAT Bus_ Posting Groupnvarchar(40)
Key to join to the VAT Business Posting Group table.

Show/hide example query

SELECT
       [Purchase Line Archive].[VAT Bus_ Posting Group]
       ,[VAT Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Business Posting Group]
              ON
                     [Purchase Line Archive].[VAT Bus_ Posting Group] = [VAT Business Posting Group].[Code]
90VAT Prod. Posting Group SearchVAT Prod. Posting GroupNormalCode20VAT Prod_ Posting Groupnvarchar(40)
Key to join to the VAT Product Posting Group table.

Show/hide example query

SELECT
       [Purchase Line Archive].[VAT Prod_ Posting Group]
       ,[VAT Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$VAT Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [VAT Product Posting Group]
              ON
                     [Purchase Line Archive].[VAT Prod_ Posting Group] = [VAT Product Posting Group].[Code]
91Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(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]
92Outstanding Amount (LCY) SearchOutstanding Amount ($)NormalDecimal12Outstanding Amount (LCY)decimal(38,38)
93Amt. Rcd. Not Invoiced (LCY) SearchAmt. Rcd. Not Invoiced ($)NormalDecimal12Amt_ Rcd_ Not Invoiced (LCY)decimal(38,38)
97Blanket Order No. SearchBlanket Order No.NormalCode20Blanket Order No_nvarchar(40)
98Blanket Order Line No. SearchBlanket Order Line No.NormalInteger4Blanket Order Line No_int
99VAT Base Amount SearchTax Base AmountNormalDecimal12VAT Base Amountdecimal(38,38)
100Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
101System-Created Entry SearchSystem-Created EntryNormalBoolean4
103Line Amount SearchLine AmountNormalDecimal12Line Amountdecimal(38,38)
104VAT Difference SearchTax DifferenceNormalDecimal12VAT Differencedecimal(38,38)
105Inv. Disc. Amount to Invoice SearchInv. Disc. Amount to InvoiceNormalDecimal12Inv_ Disc_ Amount to Invoicedecimal(38,38)
106VAT Identifier SearchTax IdentifierNormalCode20VAT Identifiernvarchar(40)
107IC Partner Ref. Type SearchIC Partner Ref. TypeNormalOption4IC Partner Ref_ Typeint
Available options are:
  • ” “
  • “G/L Account”
  • “Item”
  • “Charge (Item)”
  • “Cross Reference”
  • “Common Item No.”
  • “Vendor Item No.”
108IC Partner Reference SearchIC Partner ReferenceNormalCode20IC Partner Referencenvarchar(40)
109Prepayment % SearchPrepayment %NormalDecimal12Prepayment _decimal(38,38)
110Prepmt. Line Amount SearchPrepmt. Line AmountNormalDecimal12Prepmt_ Line Amountdecimal(38,38)
111Prepmt. Amt. Inv. SearchPrepmt. Amt. Inv.NormalDecimal12Prepmt_ Amt_ Inv_decimal(38,38)
112Prepmt. Amt. Incl. VAT SearchPrepmt. Amt. Incl. TaxNormalDecimal12Prepmt_ Amt_ Incl_ VATdecimal(38,38)
113Prepayment Amount SearchPrepayment AmountNormalDecimal12Prepayment Amountdecimal(38,38)
114Prepmt. VAT Base Amt. SearchPrepmt. Tax Base Amt.NormalDecimal12Prepmt_ VAT Base Amt_decimal(38,38)
115Prepayment VAT % SearchPrepayment Tax %NormalDecimal12Prepayment VAT _decimal(38,38)
116Prepmt. VAT Calc. Type SearchPrepmt. Tax Calc. TypeNormalOption4Prepmt_ VAT Calc_ Typeint
Available options are:
  • “Normal VAT”
  • “Reverse Charge VAT”
  • “Full VAT”
  • “Sales Tax”
117Prepayment VAT Identifier SearchPrepayment Tax IdentifierNormalCode20Prepayment VAT Identifiernvarchar(40)
118Prepayment Tax Area Code SearchPrepayment Tax Area CodeNormalCode20Prepayment Tax Area Codenvarchar(40)
Key to join to the Tax Area table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Prepayment 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].[Prepayment Tax Area Code] = [Tax Area].[Code]
119Prepayment Tax Liable SearchPrepayment Tax LiableNormalBoolean4Prepayment Tax Liabletinyint
120Prepayment Tax Group Code SearchPrepayment Tax Group CodeNormalCode20Prepayment Tax Group Codenvarchar(40)
Key to join to the Tax Group table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Prepayment 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].[Prepayment Tax Group Code] = [Tax Group].[Code]
121Prepmt Amt to Deduct SearchPrepmt Amt to DeductNormalDecimal12Prepmt Amt to Deductdecimal(38,38)
122Prepmt Amt Deducted SearchPrepmt Amt DeductedNormalDecimal12Prepmt Amt Deducteddecimal(38,38)
123Prepayment Line SearchPrepayment LineNormalBoolean4Prepayment Linetinyint
124Prepmt. Amount Inv. Incl. VAT SearchPrepmt. Amount Inv. Incl. TaxNormalDecimal12Prepmt_ Amount Inv_ Incl_ VATdecimal(38,38)
130IC Partner Code SearchIC Partner CodeNormalCode20IC Partner Codenvarchar(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]
138IC Item Reference No. SearchIC Item Reference No.NormalCode50IC Item Reference No_nvarchar(100)
145Pmt. Discount Amount SearchPmt. Discount AmountNormalDecimal12Pmt_ Discount Amountdecimal(38,38)
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Purchase Line Archive].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
1001Job Task No. SearchJob Task No.NormalCode20Job Task No_nvarchar(40)
1002Job Line Type SearchJob Line TypeNormalOption4Job Line Typeint
Available options are:
  • ” “
  • “Budget”
  • “Billable”
  • “Both Budget and Billable”
1003Job Unit Price SearchJob Unit PriceNormalDecimal12Job Unit Pricedecimal(38,38)
1004Job Total Price SearchJob Total PriceNormalDecimal12Job Total Pricedecimal(38,38)
1005Job Line Amount SearchJob Line AmountNormalDecimal12Job Line Amountdecimal(38,38)
1006Job Line Discount Amount SearchJob Line Discount AmountNormalDecimal12Job Line Discount Amountdecimal(38,38)
1007Job Line Discount % SearchJob Line Discount %NormalDecimal12Job Line Discount _decimal(38,38)
1008Job Unit Price (LCY) SearchJob Unit Price ($)NormalDecimal12Job Unit Price (LCY)decimal(38,38)
1009Job Total Price (LCY) SearchJob Total Price ($)NormalDecimal12Job Total Price (LCY)decimal(38,38)
1010Job Line Amount (LCY) SearchJob Line Amount ($)NormalDecimal12Job Line Amount (LCY)decimal(38,38)
1011Job Line Disc. Amount (LCY) SearchJob Line Disc. Amount ($)NormalDecimal12Job Line Disc_ Amount (LCY)decimal(38,38)
1012Job Currency Factor SearchJob Currency FactorNormalDecimal12Job Currency Factordecimal(38,38)
1013Job Currency Code SearchJob Currency CodeNormalCode20Job Currency Codenvarchar(40)
1019Job Planning Line No. SearchJob Planning Line No.NormalInteger4Job Planning Line No_int
1030Job Remaining Qty. SearchJob Remaining Qty.NormalDecimal12Job Remaining Qty_decimal(38,38)
1031Job Remaining Qty. (Base) SearchJob Remaining Qty. (Base)NormalDecimal12Job Remaining Qty_ (Base)decimal(38,38)
1700Deferral Code SearchDeferral CodeNormalCode10Deferral Codenvarchar(20)
Key to join to the Deferral Template table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Deferral Code]
       ,[Deferral Template].[Deferral Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Deferral Template$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Deferral Template]
              ON
                     [Purchase Line Archive].[Deferral Code] = [Deferral Template].[Deferral Code]
1702Returns Deferral Start Date SearchReturns Deferral Start DateNormalDate4Returns Deferral Start Datedatetime
5047Version No. Primary Key SearchVersion No.NormalInteger4Version No_int
5048Doc. No. Occurrence Primary Key SearchDoc. No. OccurrenceNormalInteger4Doc_ No_ Occurrenceint
5401Prod. Order No. SearchProd. Order No.NormalCode20Prod_ Order No_nvarchar(40)
5402Variant Code SearchVariant CodeNormalCode10Variant Codenvarchar(20)
Key to join to the Item Variant table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Purchase Line Archive].[Variant Code] = [Item Variant].[Code]
5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Purchase Line Archive].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5415Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5416Outstanding Qty. (Base) SearchOutstanding Qty. (Base)NormalDecimal12Outstanding Qty_ (Base)decimal(38,38)
5417Qty. to Invoice (Base) SearchQty. to Invoice (Base)NormalDecimal12Qty_ to Invoice (Base)decimal(38,38)
5418Qty. to Receive (Base) SearchQty. to Receive (Base)NormalDecimal12Qty_ to Receive (Base)decimal(38,38)
5458Qty. Rcd. Not Invoiced (Base) SearchQty. Rcd. Not Invoiced (Base)NormalDecimal12Qty_ Rcd_ Not Invoiced (Base)decimal(38,38)
5460Qty. Received (Base) SearchQty. Received (Base)NormalDecimal12Qty_ Received (Base)decimal(38,38)
5461Qty. Invoiced (Base) SearchQty. Invoiced (Base)NormalDecimal12Qty_ Invoiced (Base)decimal(38,38)
5600FA Posting Date SearchFA Posting DateNormalDate4FA Posting Datedatetime
5601FA Posting Type SearchFA Posting TypeNormalOption4FA Posting Typeint
Available options are:
  • ” “
  • “Acquisition Cost”
  • “Maintenance”
  • “Appreciation”
5602Depreciation Book Code SearchDepreciation Book CodeNormalCode10Depreciation Book Codenvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Depreciation Book Code]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [Purchase Line Archive].[Depreciation Book Code] = [Depreciation Book].[Code]
5603Salvage Value SearchSalvage ValueNormalDecimal12Salvage Valuedecimal(38,38)
5605Depr. until FA Posting Date SearchDepr. until FA Posting DateNormalBoolean4Depr_ until FA Posting Datetinyint
5606Depr. Acquisition Cost SearchDepr. Acquisition CostNormalBoolean4Depr_ Acquisition Costtinyint
5609Maintenance Code SearchMaintenance CodeNormalCode10Maintenance Codenvarchar(20)
Key to join to the Maintenance table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Maintenance Code]
       ,[Maintenance].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Maintenance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Maintenance]
              ON
                     [Purchase Line Archive].[Maintenance Code] = [Maintenance].[Code]
5610Insurance No. SearchInsurance No.NormalCode20Insurance No_nvarchar(40)
Key to join to the Insurance table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Insurance No_]
       ,[Insurance].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Insurance$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Insurance]
              ON
                     [Purchase Line Archive].[Insurance No_] = [Insurance].[No_]
5611Budgeted FA No. SearchBudgeted FA No.NormalCode20Budgeted FA No_nvarchar(40)
Key to join to the Fixed Asset table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Budgeted FA No_]
       ,[Fixed Asset].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Fixed Asset$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Fixed Asset]
              ON
                     [Purchase Line Archive].[Budgeted FA No_] = [Fixed Asset].[No_]
5612Duplicate in Depreciation Book SearchDuplicate in Depreciation BookNormalCode10Duplicate in Depreciation Booknvarchar(20)
Key to join to the Depreciation Book table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Duplicate in Depreciation Book]
       ,[Depreciation Book].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Depreciation Book$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Depreciation Book]
              ON
                     [Purchase Line Archive].[Duplicate in Depreciation Book] = [Depreciation Book].[Code]
5613Use Duplication List SearchUse Duplication ListNormalBoolean4Use Duplication Listtinyint
5700Responsibility Center SearchResponsibility CenterNormalCode10Responsibility Centernvarchar(20)
Key to join to the Responsibility Center table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Responsibility Center]
       ,[Responsibility Center].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Responsibility Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Responsibility Center]
              ON
                     [Purchase Line Archive].[Responsibility Center] = [Responsibility Center].[Code]
5705Cross-Reference No. SearchCross-Reference No.NormalCode20Cross-Reference No_nvarchar(40)
5706Unit of Measure (Cross Ref.) SearchUnit of Measure (Cross Ref.)NormalCode10Unit of Measure (Cross Ref_)nvarchar(20)
5707Cross-Reference Type SearchCross-Reference TypeNormalOption4Cross-Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5708Cross-Reference Type No. SearchCross-Reference Type No.NormalCode30Cross-Reference Type No_nvarchar(60)
5709Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(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]
5710Nonstock SearchCatalogNormalBoolean4Nonstocktinyint
5711Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Purchasing Code]
       ,[Purchasing].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
              ON
                     [Purchase Line Archive].[Purchasing Code] = [Purchasing].[Code]
5712Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5713Special Order SearchSpecial OrderNormalBoolean4Special Ordertinyint
5714Special Order Sales No. SearchSpecial Order Sales No.NormalCode20Special Order Sales No_nvarchar(40)
5715Special Order Sales Line No. SearchSpecial Order Sales Line No.NormalInteger4Special Order Sales Line No_int
5725Item Reference No. SearchItem Reference No.NormalCode50Item Reference No_nvarchar(100)
5726Item Reference Unit of Measure SearchReference Unit of MeasureNormalCode10Item Reference Unit of Measurenvarchar(20)
5727Item Reference Type SearchItem Reference TypeNormalOption4Item Reference Typeint
Available options are:
  • ” “
  • “Customer”
  • “Vendor”
  • “Bar Code”
5728Item Reference Type No. SearchItem Reference Type No.NormalCode30Item Reference Type No_nvarchar(60)
5752Completely Received SearchCompletely ReceivedNormalBoolean4Completely Receivedtinyint
5790Requested Receipt Date SearchRequested Receipt DateNormalDate4Requested Receipt Datedatetime
5791Promised Receipt Date SearchPromised Receipt DateNormalDate4Promised Receipt Datedatetime
5792Lead Time Calculation SearchLead Time CalculationNormalDateFormula32Lead Time Calculationvarchar(32)
5793Inbound Whse. Handling Time SearchInbound Whse. Handling TimeNormalDateFormula32Inbound Whse_ Handling Timevarchar(32)
5794Planned Receipt Date SearchPlanned Receipt DateNormalDate4Planned Receipt Datedatetime
5795Order Date SearchOrder DateNormalDate4Order Datedatetime
5800Allow Item Charge Assignment SearchAllow Item Charge AssignmentNormalBoolean4Allow Item Charge Assignmenttinyint
5803Return Qty. to Ship SearchReturn Qty. to ShipNormalDecimal12Return Qty_ to Shipdecimal(38,38)
5804Return Qty. to Ship (Base) SearchReturn Qty. to Ship (Base)NormalDecimal12Return Qty_ to Ship (Base)decimal(38,38)
5805Return Qty. Shipped Not Invd. SearchReturn Qty. Shipped Not Invd.NormalDecimal12Return Qty_ Shipped Not Invd_decimal(38,38)
5806Ret. Qty. Shpd Not Invd.(Base) SearchRet. Qty. Shpd Not Invd.(Base)NormalDecimal12Ret_ Qty_ Shpd Not Invd_(Base)decimal(38,38)
5807Return Shpd. Not Invd. SearchReturn Shpd. Not Invd.NormalDecimal12Return Shpd_ Not Invd_decimal(38,38)
5808Return Shpd. Not Invd. (LCY) SearchReturn Shpd. Not Invd. ($)NormalDecimal12Return Shpd_ Not Invd_ (LCY)decimal(38,38)
5809Return Qty. Shipped SearchReturn Qty. ShippedNormalDecimal12Return Qty_ Shippeddecimal(38,38)
5810Return Qty. Shipped (Base) SearchReturn Qty. Shipped (Base)NormalDecimal12Return Qty_ Shipped (Base)decimal(38,38)
6200Non-Deductible VAT % SearchNon-Deductible Tax %NormalDecimal12Non-Deductible VAT _decimal(38,38)
6201Non-Deductible VAT Base SearchNon-Deductible Tax BaseNormalDecimal12Non-Deductible VAT Basedecimal(38,38)
6202Non-Deductible VAT Amount SearchNon-Deductible Tax AmountNormalDecimal12Non-Deductible VAT Amountdecimal(38,38)
6203Non-Deductible VAT Diff. SearchNon-Deductible Tax DifferenceNormalDecimal12Non-Deductible VAT Diff_decimal(38,38)
6600Return Shipment No. SearchReturn Shipment No.NormalCode20Return Shipment No_nvarchar(40)
6601Return Shipment Line No. SearchReturn Shipment Line No.NormalInteger4Return Shipment Line No_int
6608Return Reason Code SearchReturn Reason CodeNormalCode10Return Reason Codenvarchar(20)
Key to join to the Return Reason table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Return Reason Code]
       ,[Return Reason].[Code]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Return Reason$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Return Reason]
              ON
                     [Purchase Line Archive].[Return Reason Code] = [Return Reason].[Code]
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
10017Provincial Tax Area Code SearchProvincial Tax Area CodeNormalCode20
10022IRS 1099 Liable SearchIRS 1099 LiableNormalBoolean4
99000750Routing No. SearchRouting No.NormalCode20Routing No_nvarchar(40)
Key to join to the Routing Header table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Routing No_]
       ,[Routing Header].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header]
              ON
                     [Purchase Line Archive].[Routing No_] = [Routing Header].[No_]
99000751Operation No. SearchOperation No.NormalCode10Operation No_nvarchar(20)
99000752Work Center No. SearchWork Center No.NormalCode20Work Center No_nvarchar(40)
Key to join to the Work Center table.

Show/hide example query

SELECT
       [Purchase Line Archive].[Work Center No_]
       ,[Work Center].[No_]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
              ON
                     [Purchase Line Archive].[Work Center No_] = [Work Center].[No_]
99000753Finished SearchFinishedNormalBoolean4Finishedtinyint
99000754Prod. Order Line No. SearchProd. Order Line No.NormalInteger4Prod_ Order Line No_int
99000755Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
99000756MPS Order SearchMPS OrderNormalBoolean4MPS Ordertinyint
99000757Planning Flexibility SearchPlanning FlexibilityNormalOption4Planning Flexibilityint
Available options are:
  • “Unlimited”
  • “None”
99000758Safety Lead Time SearchSafety Lead TimeNormalDateFormula32Safety Lead Timevarchar(32)
99000759Routing Reference No. SearchRouting Reference No.NormalInteger4Routing Reference No_int
2000000000$systemId SearchSystem IDNormalGUID16$systemIduniqueidentifier
2000000001SystemCreatedAt SearchCreated AtNormalDateTime8$systemCreatedAtdatetime
2000000002SystemCreatedBy SearchCreated ByNormalGUID16$systemCreatedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Purchase Line Archive].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [User] AS [User]
              ON
                     [Purchase Line Archive].[$systemCreatedBy] = [User].[User Security ID]
2000000003SystemModifiedAt SearchModified AtNormalDateTime8$systemModifiedAtdatetime
2000000004SystemModifiedBy SearchModified ByNormalGUID16$systemModifiedByuniqueidentifier
Key to join to the User table.

Show/hide example query

SELECT
       [Purchase Line Archive].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Purchase Line Archive$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchase Line Archive]
LEFT JOIN
       [User] AS [User]
              ON
                     [Purchase Line Archive].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Purchase Line Archive table

Leave a Reply

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