Requisition Line

Dynamics 365 BC Table ReferenceTablesCompany TablesRRequisition Line

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

Table Type: Company

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

Table Number: 246

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

Show/hide an example select of all columns

SELECT

   *

FROM

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

Show/hide an example select of all columns by name

SELECT

   [Worksheet Template Name]
   ,[Journal Batch Name]
   ,[Line No_]
   ,[Type]
   ,[No_]
   ,[Description]
   ,[Description 2]
   ,[Quantity]
   ,[Vendor No_]
   ,[Direct Unit Cost]
   ,[Due Date]
   ,[Requester ID]
   ,[Confirmed]
   ,[Shortcut Dimension 1 Code]
   ,[Shortcut Dimension 2 Code]
   ,[Location Code]
   ,[Recurring Method]
   ,[Expiration Date]
   ,[Recurring Frequency]
   ,[Order Date]
   ,[Vendor Item No_]
   ,[Sales Order No_]
   ,[Sales Order Line No_]
   ,[Sell-to Customer No_]
   ,[Ship-to Code]
   ,[Order Address Code]
   ,[Currency Code]
   ,[Currency Factor]
   ,[Purchaser Code]
   ,[Drop Shipment]
   ,[Dimension Set ID]
   ,[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)]
   ,[Demand Type]
   ,[Demand Subtype]
   ,[Demand Order No_]
   ,[Demand Line No_]
   ,[Demand Ref_ No_]
   ,[Status]
   ,[Demand Date]
   ,[Demand Quantity]
   ,[Demand Quantity (Base)]
   ,[Needed Quantity]
   ,[Needed Quantity (Base)]
   ,[Reserve]
   ,[Qty_ per UOM (Demand)]
   ,[Unit Of Measure Code (Demand)]
   ,[Supply From]
   ,[Original Item No_]
   ,[Original Variant Code]
   ,[Level]
   ,[Demand Qty_ Available]
   ,[User ID]
   ,[Item Category Code]
   ,[Nonstock]
   ,[Purchasing Code]
   ,[Product Group Code]
   ,[Transfer-from Code]
   ,[Transfer Shipment Date]
   ,[Price Calculation Method]
   ,[Line Discount _]
   ,[Custom Sorting Order]
   ,[Routing No_]
   ,[Operation No_]
   ,[Work Center No_]
   ,[Prod_ Order Line No_]
   ,[MPS Order]
   ,[Planning Flexibility]
   ,[Routing Reference No_]
   ,[Gen_ Prod_ Posting Group]
   ,[Gen_ Business Posting Group]
   ,[Low-Level Code]
   ,[Production BOM Version Code]
   ,[Routing Version Code]
   ,[Routing Type]
   ,[Original Quantity]
   ,[Finished Quantity]
   ,[Remaining Quantity]
   ,[Original Due Date]
   ,[Scrap _]
   ,[Starting Date]
   ,[Starting Time]
   ,[Ending Date]
   ,[Ending Time]
   ,[Production BOM No_]
   ,[Indirect Cost _]
   ,[Overhead Rate]
   ,[Unit Cost]
   ,[Cost Amount]
   ,[Ref_ Order No_]
   ,[Ref_ Order Type]
   ,[Ref_ Order Status]
   ,[Ref_ Line No_]
   ,[No_ Series]
   ,[Finished Qty_ (Base)]
   ,[Remaining Qty_ (Base)]
   ,[Related to Planning Line]
   ,[Planning Level]
   ,[Planning Line Origin]
   ,[Action Message]
   ,[Accept Action Message]
   ,[Net Quantity (Base)]
   ,[Starting Date-Time]
   ,[Ending Date-Time]
   ,[Order Promising ID]
   ,[Order Promising Line No_]
   ,[Order Promising Line ID]
   ,[$systemId]
   ,[$systemCreatedAt]
   ,[$systemCreatedBy]
   ,[$systemModifiedAt]
   ,[$systemModifiedBy]

FROM

   [CRONUS UK Ltd_$Requisition 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_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
   [User] AS [User]
      ON
         [Requisition Line].[Requester ID] = [User].[User Name]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Requisition Line].[Shortcut Dimension 1 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
      ON
         [Requisition Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Requisition Line].[Location Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
      ON
         [Requisition Line].[Ship-to Code] = [Ship-to Address].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
      ON
         [Requisition Line].[Currency Code] = [Currency].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
      ON
         [Requisition Line].[Purchaser Code] = [Salesperson/Purchaser].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
      ON
         [Requisition Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
LEFT JOIN
   [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
      ON
         [Requisition Line].[Variant Code] = [Item Variant].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
      ON
         [Requisition Line].[Bin Code] = [Bin].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Requisition Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
      ON
         [Requisition Line].[Purchasing Code] = [Purchasing].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
      ON
         [Requisition Line].[Transfer-from Code] = [Location].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
      ON
         [Requisition Line].[Ending Date] = [Inventory Period].[Ending Date]
LEFT JOIN
   [User] AS [User]
      ON
         [Requisition Line].[SystemCreatedBy] = [User].[User Security ID]
LEFT JOIN
   [User] AS [User]
      ON
         [Requisition Line].[SystemModifiedBy] = [User].[User Security ID]

Show/hide columns in Requisition Line table

Field No.Field NameField CaptionClassTypeLengthSQL Column NameSQL DataType
1Worksheet Template Name Primary Key SearchWorksheet Template NameNormalCode10Worksheet Template Namenvarchar(20)
2Journal Batch Name Primary Key SearchJournal Batch NameNormalCode10Journal Batch Namenvarchar(20)
3Line No. Primary Key SearchLine No.NormalInteger4Line No_int
4Type SearchTypeNormalOption4Typeint
Available options are:
  • ” “
  • “G/L Account”
  • “Item”
5No. SearchNo.NormalCode20No_nvarchar(40)
6Description SearchDescriptionNormalText100Descriptionnvarchar(200)
7Description 2 SearchDescription 2NormalText50Description 2nvarchar(100)
8Quantity SearchQuantityNormalDecimal12Quantitydecimal(38,38)
9Vendor No. SearchVendor No.NormalCode20Vendor No_nvarchar(40)
Key to join to the Vendor table.

Show/hide example query

SELECT
       [Requisition Line].[Vendor No_]
       ,[Vendor].[No_]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
              ON
                     [Requisition Line].[Vendor No_] = [Vendor].[No_]
10Direct Unit Cost SearchDirect Unit CostNormalDecimal12Direct Unit Costdecimal(38,38)
12Due Date SearchDue DateNormalDate4Due Datedatetime
13Requester ID SearchRequester IDNormalCode50Requester IDnvarchar(100)
Key to join to the User table.

Show/hide example query

SELECT
       [Requisition Line].[Requester ID]
       ,[User].[User Name]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Requisition Line].[Requester ID] = [User].[User Name]
14Confirmed SearchConfirmedNormalBoolean4Confirmedtinyint
15Shortcut Dimension 1 Code SearchShortcut Dimension 1 CodeNormalCode20Shortcut Dimension 1 Codenvarchar(40)
Key to join to the Dimension table.

Show/hide example query

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

Show/hide example query

SELECT
       [Requisition Line].[Shortcut Dimension 2 Code]
       ,[Dimension].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension]
              ON
                     [Requisition Line].[Shortcut Dimension 2 Code] = [Dimension].[Code]
17Location Code SearchLocation CodeNormalCode10Location Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Requisition Line].[Location Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Requisition Line].[Location Code] = [Location].[Code]
18Recurring Method SearchRecurring MethodNormalOption4Recurring Methodint
Available options are:
  • “”
  • “Fixed”
  • “Variable”
19Expiration Date SearchExpiration DateNormalDate4Expiration Datedatetime
20Recurring Frequency SearchRecurring FrequencyNormalDateFormula32Recurring Frequencyvarchar(32)
21Order Date SearchOrder DateNormalDate4Order Datedatetime
22Vendor Item No. SearchVendor Item No.NormalText50Vendor Item No_nvarchar(100)
23Sales Order No. SearchSales Order No.NormalCode20Sales Order No_nvarchar(40)
24Sales Order Line No. SearchSales Order Line No.NormalInteger4Sales Order Line No_int
25Sell-to Customer No. SearchSell-to Customer No.NormalCode20Sell-to Customer No_nvarchar(40)
Key to join to the Customer table.

Show/hide example query

SELECT
       [Requisition Line].[Sell-to Customer No_]
       ,[Customer].[No_]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
              ON
                     [Requisition Line].[Sell-to Customer No_] = [Customer].[No_]
26Ship-to Code SearchShip-to CodeNormalCode10Ship-to Codenvarchar(20)
Key to join to the Ship-to Address table.

Show/hide example query

SELECT
       [Requisition Line].[Ship-to Code]
       ,[Ship-to Address].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Ship-to Address$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Ship-to Address]
              ON
                     [Requisition Line].[Ship-to Code] = [Ship-to Address].[Code]
28Order Address Code SearchOrder Address CodeNormalCode10Order Address Codenvarchar(20)
29Currency Code SearchCurrency CodeNormalCode10Currency Codenvarchar(20)
Key to join to the Currency table.

Show/hide example query

SELECT
       [Requisition Line].[Currency Code]
       ,[Currency].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Currency$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Currency]
              ON
                     [Requisition Line].[Currency Code] = [Currency].[Code]
30Currency Factor SearchCurrency FactorNormalDecimal12Currency Factordecimal(38,38)
31Reserved Quantity SearchReserved QuantityFlowFieldDecimal12
43Purchaser Code SearchPurchaser CodeNormalCode20Purchaser Codenvarchar(40)
Key to join to the Salesperson/Purchaser table.

Show/hide example query

SELECT
       [Requisition Line].[Purchaser Code]
       ,[Salesperson/Purchaser].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Salesperson_Purchaser$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Salesperson/Purchaser]
              ON
                     [Requisition Line].[Purchaser Code] = [Salesperson/Purchaser].[Code]
73Drop Shipment SearchDrop ShipmentNormalBoolean4Drop Shipmenttinyint
480Dimension Set ID SearchDimension Set IDNormalInteger4Dimension Set IDint
Key to join to the Dimension Set Entry table.

Show/hide example query

SELECT
       [Requisition Line].[Dimension Set ID]
       ,[Dimension Set Entry].[Dimension Set ID]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Dimension Set Entry$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Dimension Set Entry]
              ON
                     [Requisition Line].[Dimension Set ID] = [Dimension Set Entry].[Dimension Set ID]
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
       [Requisition Line].[Variant Code]
       ,[Item Variant].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Variant$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Variant]
              ON
                     [Requisition Line].[Variant Code] = [Item Variant].[Code]
5403Bin Code SearchBin CodeNormalCode20Bin Codenvarchar(40)
Key to join to the Bin table.

Show/hide example query

SELECT
       [Requisition Line].[Bin Code]
       ,[Bin].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Bin$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Bin]
              ON
                     [Requisition Line].[Bin Code] = [Bin].[Code]
5404Qty. per Unit of Measure SearchQty. per Unit of MeasureNormalDecimal12Qty_ per Unit of Measuredecimal(38,38)
5405Qty. Rounding Precision SearchQty. Rounding PrecisionNormalDecimal12Qty_ Rounding Precisiondecimal(38,38)
5406Qty. Rounding Precision (Base) SearchQty. Rounding Precision (Base)NormalDecimal12Qty_ Rounding Precision (Base)decimal(38,38)
5407Unit of Measure Code SearchUnit of Measure CodeNormalCode10Unit of Measure Codenvarchar(20)
5408Quantity (Base) SearchQuantity (Base)NormalDecimal12Quantity (Base)decimal(38,38)
5431Reserved Qty. (Base) SearchReserved Qty. (Base)FlowFieldDecimal12
5520Demand Type SearchDemand TypeNormalInteger4Demand Typeint
5521Demand Subtype SearchDemand SubtypeNormalOption4Demand Subtypeint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
5522Demand Order No. SearchDemand Order No.NormalCode20Demand Order No_nvarchar(40)
5525Demand Line No. SearchDemand Line No.NormalInteger4Demand Line No_int
5526Demand Ref. No. SearchDemand Ref. No.NormalInteger4Demand Ref_ No_int
5527Status SearchStatusNormalOption4Statusint
Available options are:
  • “0”
  • “1”
  • “2”
  • “3”
  • “4”
  • “5”
  • “6”
  • “7”
  • “8”
  • “9”
  • “10”
5530Demand Date SearchDemand DateNormalDate4Demand Datedatetime
5532Demand Quantity SearchDemand QuantityNormalDecimal12Demand Quantitydecimal(38,38)
5533Demand Quantity (Base) SearchDemand Quantity (Base)NormalDecimal12Demand Quantity (Base)decimal(38,38)
5538Needed Quantity SearchNeeded QuantityNormalDecimal12Needed Quantitydecimal(38,38)
5539Needed Quantity (Base) SearchNeeded Quantity (Base)NormalDecimal12Needed Quantity (Base)decimal(38,38)
5540Reserve SearchReserveNormalBoolean4Reservetinyint
5541Qty. per UOM (Demand) SearchQty. per UOM (Demand)NormalDecimal12Qty_ per UOM (Demand)decimal(38,38)
5542Unit Of Measure Code (Demand) SearchUnit Of Measure Code (Demand)NormalCode10Unit Of Measure Code (Demand)nvarchar(20)
5552Supply From SearchSupply FromNormalCode20Supply Fromnvarchar(40)
5553Original Item No. SearchOriginal Item No.NormalCode20Original Item No_nvarchar(40)
Key to join to the Item table.

Show/hide example query

SELECT
       [Requisition Line].[Original Item No_]
       ,[Item].[No_]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item$437dbf0e-84ff-417a-965d-ed2bb9650972$ext] AS [Item]
              ON
                     [Requisition Line].[Original Item No_] = [Item].[No_]
5554Original Variant Code SearchOriginal Variant CodeNormalCode10Original Variant Codenvarchar(20)
5560Level SearchLevelNormalInteger4Levelint
5563Demand Qty. Available SearchDemand Qty. AvailableNormalDecimal12Demand Qty_ Availabledecimal(38,38)
5590User ID SearchUser IDNormalCode50User IDnvarchar(100)
5701Item Category Code SearchItem Category CodeNormalCode20Item Category Codenvarchar(40)
Key to join to the Item Category table.

Show/hide example query

SELECT
       [Requisition Line].[Item Category Code]
       ,[Item Category].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
              ON
                     [Requisition Line].[Item Category Code] = [Item Category].[Code]
5702Nonstock SearchCatalogNormalBoolean4Nonstocktinyint
5703Purchasing Code SearchPurchasing CodeNormalCode10Purchasing Codenvarchar(20)
Key to join to the Purchasing table.

Show/hide example query

SELECT
       [Requisition Line].[Purchasing Code]
       ,[Purchasing].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Purchasing$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Purchasing]
              ON
                     [Requisition Line].[Purchasing Code] = [Purchasing].[Code]
5705Product Group Code SearchProduct Group CodeNormalCode10Product Group Codenvarchar(20)
5706Transfer-from Code SearchTransfer-from CodeNormalCode10Transfer-from Codenvarchar(20)
Key to join to the Location table.

Show/hide example query

SELECT
       [Requisition Line].[Transfer-from Code]
       ,[Location].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Location$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Location]
              ON
                     [Requisition Line].[Transfer-from Code] = [Location].[Code]
5707Transfer Shipment Date SearchTransfer Shipment DateNormalDate4Transfer Shipment Datedatetime
7000Price Calculation Method SearchPrice Calculation MethodNormalOption4Price Calculation Methodint
Available options are:
  • ” “
  • “Lowest Price”
7002Line Discount % SearchLine Discount %NormalDecimal12Line Discount _decimal(38,38)
7100Blanket Purch. Order Exists SearchBlanket Purch. Order ExistsFlowFieldBoolean4
7110Custom Sorting Order SearchCustom Sorting OrderNormalCode50Custom Sorting Ordernvarchar(100)
99000750Routing No. SearchRouting No.NormalCode20Routing No_nvarchar(40)
Key to join to the Routing Header table.

Show/hide example query

SELECT
       [Requisition Line].[Routing No_]
       ,[Routing Header].[No_]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Routing Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Routing Header]
              ON
                     [Requisition Line].[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
       [Requisition Line].[Work Center No_]
       ,[Work Center].[No_]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Work Center$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Work Center]
              ON
                     [Requisition Line].[Work Center No_] = [Work Center].[No_]
99000754Prod. Order Line No. SearchProd. Order Line No.NormalInteger4Prod_ Order Line No_int
99000755MPS Order SearchMPS OrderNormalBoolean4MPS Ordertinyint
99000756Planning Flexibility SearchPlanning FlexibilityNormalOption4Planning Flexibilityint
Available options are:
  • “Unlimited”
  • “None”
99000757Routing Reference No. SearchRouting Reference No.NormalInteger4Routing Reference No_int
99000882Gen. 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
       [Requisition Line].[Gen_ Prod_ Posting Group]
       ,[Gen. Product Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Product Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Product Posting Group]
              ON
                     [Requisition Line].[Gen_ Prod_ Posting Group] = [Gen. Product Posting Group].[Code]
99000883Gen. Business Posting Group SearchGen. Business Posting GroupNormalCode20Gen_ Business Posting Groupnvarchar(40)
Key to join to the Gen. Business Posting Group table.

Show/hide example query

SELECT
       [Requisition Line].[Gen_ Business Posting Group]
       ,[Gen. Business Posting Group].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Gen_ Business Posting Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Gen. Business Posting Group]
              ON
                     [Requisition Line].[Gen_ Business Posting Group] = [Gen. Business Posting Group].[Code]
99000884Low-Level Code SearchLow-Level CodeNormalInteger4Low-Level Codeint
99000885Production BOM Version Code SearchProduction BOM Version CodeNormalCode20Production BOM Version Codenvarchar(40)
99000886Routing Version Code SearchRouting Version CodeNormalCode20Routing Version Codenvarchar(40)
99000887Routing Type SearchRouting TypeNormalOption4Routing Typeint
Available options are:
  • “Serial”
  • “Parallel”
99000888Original Quantity SearchOriginal QuantityNormalDecimal12Original Quantitydecimal(38,38)
99000889Finished Quantity SearchFinished QuantityNormalDecimal12Finished Quantitydecimal(38,38)
99000890Remaining Quantity SearchRemaining QuantityNormalDecimal12Remaining Quantitydecimal(38,38)
99000891Original Due Date SearchOriginal Due DateNormalDate4Original Due Datedatetime
99000892Scrap % SearchScrap %NormalDecimal12Scrap _decimal(38,38)
99000894Starting Date SearchStarting DateNormalDate4Starting Datedatetime
99000895Starting Time SearchStarting TimeNormalTime4Starting Timedatetime
99000896Ending Date SearchEnding DateNormalDate4Ending Datedatetime
Key to join to the Inventory Period table.

Show/hide example query

SELECT
       [Requisition Line].[Ending Date]
       ,[Inventory Period].[Ending Date]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Inventory Period$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Inventory Period]
              ON
                     [Requisition Line].[Ending Date] = [Inventory Period].[Ending Date]
99000897Ending Time SearchEnding TimeNormalTime4Ending Timedatetime
99000898Production BOM No. SearchProduction BOM No.NormalCode20Production BOM No_nvarchar(40)
Key to join to the Production BOM Header table.

Show/hide example query

SELECT
       [Requisition Line].[Production BOM No_]
       ,[Production BOM Header].[No_]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Production BOM Header$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Header]
              ON
                     [Requisition Line].[Production BOM No_] = [Production BOM Header].[No_]
Part of multi-key to join to the Production BOM Line table.

Show/hide example query

SELECT
       [Requisition Line].[Production BOM No_]
       ,[Production BOM Line].[Production BOM No_]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
              ON
                     [Requisition Line].[Production BOM No_] = [Production BOM Line].[Production BOM No_]
              AND
                     [Requisition Line].[BOM Line No_] = [Production BOM Line].[Line No_]
99000899Indirect Cost % SearchIndirect Cost %NormalDecimal12Indirect Cost _decimal(38,38)
99000900Overhead Rate SearchOverhead RateNormalDecimal12Overhead Ratedecimal(38,38)
99000901Unit Cost SearchUnit CostNormalDecimal12Unit Costdecimal(38,38)
99000902Cost Amount SearchCost AmountNormalDecimal12Cost Amountdecimal(38,38)
99000903Replenishment System SearchReplenishment SystemNormalOption4
99000904Ref. Order No. SearchRef. Order No.NormalCode20Ref_ Order No_nvarchar(40)
99000905Ref. Order Type SearchRef. Order TypeNormalOption4Ref_ Order Typeint
Available options are:
  • ” “
  • “Purchase”
  • “Prod. Order”
  • “Transfer”
  • “Assembly”
99000906Ref. Order Status SearchRef. Order StatusNormalOption4Ref_ Order Statusint
Available options are:
  • “”
  • “Planned”
  • “Firm Planned”
  • “Released”
99000907Ref. Line No. SearchRef. Line No.NormalInteger4Ref_ Line No_int
99000908No. Series SearchNo. SeriesNormalCode20No_ Seriesnvarchar(40)
Key to join to the No. Series table.

Show/hide example query

SELECT
       [Requisition Line].[No_ Series]
       ,[No. Series].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$No_ Series$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [No. Series]
              ON
                     [Requisition Line].[No_ Series] = [No. Series].[Code]
99000909Expected Operation Cost Amt. SearchExpected Operation Cost Amt.FlowFieldDecimal12
99000910Expected Component Cost Amt. SearchExpected Component Cost Amt.FlowFieldDecimal12
99000911Finished Qty. (Base) SearchFinished Qty. (Base)NormalDecimal12Finished Qty_ (Base)decimal(38,38)
99000912Remaining Qty. (Base) SearchRemaining Qty. (Base)NormalDecimal12Remaining Qty_ (Base)decimal(38,38)
99000913Related to Planning Line SearchRelated to Planning LineNormalInteger4Related to Planning Lineint
99000914Planning Level SearchPlanning LevelNormalInteger4Planning Levelint
99000915Planning Line Origin SearchPlanning Line OriginNormalOption4Planning Line Originint
Available options are:
  • ” “
  • “Action Message”
  • “Planning”
  • “Order Planning”
99000916Action Message SearchAction MessageNormalOption4Action Messageint
Available options are:
  • ” “
  • “New”
  • “Change Qty.”
  • “Reschedule”
  • “Resched. & Chg. Qty.”
  • “Cancel”
99000917Accept Action Message SearchAccept Action MessageNormalBoolean4Accept Action Messagetinyint
99000918Net Quantity (Base) SearchNet Quantity (Base)NormalDecimal12Net Quantity (Base)decimal(38,38)
99000919Starting Date-Time SearchStarting Date-TimeNormalDateTime8Starting Date-Timedatetime
99000920Ending Date-Time SearchEnding Date-TimeNormalDateTime8Ending Date-Timedatetime
99000921Order Promising ID SearchOrder Promising IDNormalCode20Order Promising IDnvarchar(40)
99000922Order Promising Line No. SearchOrder Promising Line No.NormalInteger4Order Promising Line No_int
99000923Order Promising Line ID SearchOrder Promising Line IDNormalInteger4Order Promising Line IDint
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
       [Requisition Line].[$systemCreatedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Requisition Line].[$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
       [Requisition Line].[$systemModifiedBy]
       ,[User].[User Security ID]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [User] AS [User]
              ON
                     [Requisition Line].[$systemModifiedBy] = [User].[User Security ID]

Show/hide tables related from Requisition Line table

CurrencyItem CategoryLocationProduct GroupSalesperson/PurchaserSalesperson/PurchaserShip-to AddressUnit of Measure
Dynamics 365 BC Table ReferenceTablesCompany TablesRRequisition Line

Leave a Reply

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