Requisition 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
   [timestamp]
   ,[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]
   ,[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]
   ,[Replenishment System]
   ,[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
   [CRONUS UK Ltd_$Vendor$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Vendor]
      ON
         [Requisition Line].[Vendor No_] = [Vendor].[No_]
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_$Customer$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Customer]
      ON
         [Requisition Line].[Sell-to Customer No_] = [Customer].[No_]
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_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
      ON
         [Requisition Line].[Unit of Measure Code] = [Unit of Measure].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Item Category$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Item Category]
      ON
         [Requisition Line].[Item Category Code] = [Item Category].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
      ON
         [Requisition Line].[Product Group Code] = [Product Group].[Code]
LEFT JOIN
   [CRONUS UK Ltd_$Production BOM Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Production BOM Line]
      ON
         [Requisition Line].[BOM Line No_] = [Production BOM Line].[Line No_]
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_]
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_]

Show/hide columns in Requisition Line table

Column IDColumn NameData Type
1timestamp Searchtimestamp
2Worksheet Template Name Primary Key Searchnvarchar(20)
3Journal Batch Name Primary Key Searchnvarchar(20)
4Line No_ Primary Key Searchint
5Type Searchint
6No_ Searchnvarchar(40)
7Description Searchnvarchar(200)
8Description 2 Searchnvarchar(100)
9Quantity Searchdecimal(38,38)
10Vendor No_ Searchnvarchar(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_]
11Direct Unit Cost Searchdecimal(38,38)
12Due Date Searchdatetime
13Requester ID Searchnvarchar(100)
14Confirmed Searchtinyint
15Shortcut Dimension 1 Code Searchnvarchar(40)
16Shortcut Dimension 2 Code Searchnvarchar(40)
17Location Code Searchnvarchar(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 Searchint
19Expiration Date Searchdatetime
20Recurring Frequency Searchvarchar(32)
21Order Date Searchdatetime
22Vendor Item No_ Searchnvarchar(100)
23Sales Order No_ Searchnvarchar(40)
24Sales Order Line No_ Searchint
25Sell-to Customer No_ Searchnvarchar(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 Searchnvarchar(20)
27Order Address Code Searchnvarchar(20)
28Currency Code Searchnvarchar(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]
29Currency Factor Searchdecimal(38,38)
30Drop Shipment Searchtinyint
31Dimension Set ID Searchint
32Prod_ Order No_ Searchnvarchar(40)
33Variant Code Searchnvarchar(20)
34Bin Code Searchnvarchar(40)
35Qty_ per Unit of Measure Searchdecimal(38,38)
36Qty_ Rounding Precision Searchdecimal(38,38)
37Qty_ Rounding Precision (Base) Searchdecimal(38,38)
38Unit of Measure Code Searchnvarchar(20)
Key to join to the Unit of Measure table.

Show/hide example query

SELECT
       [Requisition Line].[Unit of Measure Code]
       ,[Unit of Measure].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Unit of Measure$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Unit of Measure]
              ON
                     [Requisition Line].[Unit of Measure Code] = [Unit of Measure].[Code]
39Quantity (Base) Searchdecimal(38,38)
40Demand Type Searchint
41Demand Subtype Searchint
42Demand Order No_ Searchnvarchar(40)
43Demand Line No_ Searchint
44Demand Ref_ No_ Searchint
45Status Searchint
46Demand Date Searchdatetime
47Demand Quantity Searchdecimal(38,38)
48Demand Quantity (Base) Searchdecimal(38,38)
49Needed Quantity Searchdecimal(38,38)
50Needed Quantity (Base) Searchdecimal(38,38)
51Reserve Searchtinyint
52Qty_ per UOM (Demand) Searchdecimal(38,38)
53Unit Of Measure Code (Demand) Searchnvarchar(20)
54Supply From Searchnvarchar(40)
55Original Item No_ Searchnvarchar(40)
56Original Variant Code Searchnvarchar(20)
57Level Searchint
58Demand Qty_ Available Searchdecimal(38,38)
59User ID Searchnvarchar(100)
60Item Category Code Searchnvarchar(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]
61Nonstock Searchtinyint
62Purchasing Code Searchnvarchar(20)
63Product Group Code Searchnvarchar(20)
Key to join to the Product Group table.

Show/hide example query

SELECT
       [Requisition Line].[Product Group Code]
       ,[Product Group].[Code]
FROM
       [CRONUS UK Ltd_$Requisition Line$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Requisition Line]
LEFT JOIN
       [CRONUS UK Ltd_$Product Group$437dbf0e-84ff-417a-965d-ed2bb9650972] AS [Product Group]
              ON
                     [Requisition Line].[Product Group Code] = [Product Group].[Code]
64Transfer-from Code Searchnvarchar(20)
65Transfer Shipment Date Searchdatetime
66Price Calculation Method Searchint
67Line Discount _ Searchdecimal(38,38)
68Custom Sorting Order Searchnvarchar(100)
69Routing No_ Searchnvarchar(40)
70Operation No_ Searchnvarchar(20)
71Work Center No_ Searchnvarchar(40)
72Prod_ Order Line No_ Searchint
73MPS Order Searchtinyint
74Planning Flexibility Searchint
75Routing Reference No_ Searchint
76Gen_ Prod_ Posting Group Searchnvarchar(40)
77Gen_ Business Posting Group Searchnvarchar(40)
78Low-Level Code Searchint
79Production BOM Version Code Searchnvarchar(40)
80Routing Version Code Searchnvarchar(40)
81Routing Type Searchint
82Original Quantity Searchdecimal(38,38)
83Finished Quantity Searchdecimal(38,38)
84Remaining Quantity Searchdecimal(38,38)
85Original Due Date Searchdatetime
86Scrap _ Searchdecimal(38,38)
87Starting Date Searchdatetime
88Starting Time Searchdatetime
89Ending Date Searchdatetime
90Ending Time Searchdatetime
91Production BOM No_ Searchnvarchar(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_]
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_]
92Indirect Cost _ Searchdecimal(38,38)
93Overhead Rate Searchdecimal(38,38)
94Unit Cost Searchdecimal(38,38)
95Cost Amount Searchdecimal(38,38)
96Replenishment System Searchint
97Ref_ Order No_ Searchnvarchar(40)
98Ref_ Order Type Searchint
99Ref_ Order Status Searchint
100Ref_ Line No_ Searchint
101No_ Series Searchnvarchar(40)
102Finished Qty_ (Base) Searchdecimal(38,38)
103Remaining Qty_ (Base) Searchdecimal(38,38)
104Related to Planning Line Searchint
105Planning Level Searchint
106Planning Line Origin Searchint
107Action Message Searchint
108Accept Action Message Searchtinyint
109Net Quantity (Base) Searchdecimal(38,38)
110Starting Date-Time Searchdatetime
111Ending Date-Time Searchdatetime
112Order Promising ID Searchnvarchar(40)
113Order Promising Line No_ Searchint
114Order Promising Line ID Searchint
115$systemId Searchuniqueidentifier
116$systemCreatedAt Searchdatetime
117$systemCreatedBy Searchuniqueidentifier
118$systemModifiedAt Searchdatetime
119$systemModifiedBy Searchuniqueidentifier

Show/hide tables related from Requisition Line table

Leave a Reply

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