Requisition Line – Dynamics 365 BC Table Reference

Dynamics 365 BC Table Reference Tables Company Tables RRequisition 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 Name	Field Caption	Class	Type	Length	SQL Column Name	SQL DataType
1	Worksheet Template Name	Worksheet Template Name	Normal	Code	10	Worksheet Template Name	nvarchar(20)
2	Journal Batch Name	Journal Batch Name	Normal	Code	10	Journal Batch Name	nvarchar(20)
3	Line No.	Line No.	Normal	Integer	4	Line No_	int
4	Type	Type	Normal	Option	4	Type	int
	Available options are: ” “ “G/L Account” “Item”
5	No.	No.	Normal	Code	20	No_	nvarchar(40)
6	Description	Description	Normal	Text	100	Description	nvarchar(200)
7	Description 2	Description 2	Normal	Text	50	Description 2	nvarchar(100)
8	Quantity	Quantity	Normal	Decimal	12	Quantity	decimal(38,38)
9	Vendor No.	Vendor No.	Normal	Code	20	Vendor 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_]
10	Direct Unit Cost	Direct Unit Cost	Normal	Decimal	12	Direct Unit Cost	decimal(38,38)
12	Due Date	Due Date	Normal	Date	4	Due Date	datetime
13	Requester ID	Requester ID	Normal	Code	50	Requester ID	nvarchar(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]
14	Confirmed	Confirmed	Normal	Boolean	4	Confirmed	tinyint
15	Shortcut Dimension 1 Code	Shortcut Dimension 1 Code	Normal	Code	20	Shortcut Dimension 1 Code	nvarchar(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]
16	Shortcut Dimension 2 Code	Shortcut Dimension 2 Code	Normal	Code	20	Shortcut Dimension 2 Code	nvarchar(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]
17	Location Code	Location Code	Normal	Code	10	Location Code	nvarchar(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]
18	Recurring Method	Recurring Method	Normal	Option	4	Recurring Method	int
	Available options are: “” “Fixed” “Variable”
19	Expiration Date	Expiration Date	Normal	Date	4	Expiration Date	datetime
20	Recurring Frequency	Recurring Frequency	Normal	DateFormula	32	Recurring Frequency	varchar(32)
21	Order Date	Order Date	Normal	Date	4	Order Date	datetime
22	Vendor Item No.	Vendor Item No.	Normal	Text	50	Vendor Item No_	nvarchar(100)
23	Sales Order No.	Sales Order No.	Normal	Code	20	Sales Order No_	nvarchar(40)
24	Sales Order Line No.	Sales Order Line No.	Normal	Integer	4	Sales Order Line No_	int
25	Sell-to Customer No.	Sell-to Customer No.	Normal	Code	20	Sell-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_]
26	Ship-to Code	Ship-to Code	Normal	Code	10	Ship-to Code	nvarchar(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]
28	Order Address Code	Order Address Code	Normal	Code	10	Order Address Code	nvarchar(20)
29	Currency Code	Currency Code	Normal	Code	10	Currency Code	nvarchar(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]
30	Currency Factor	Currency Factor	Normal	Decimal	12	Currency Factor	decimal(38,38)
31	Reserved Quantity	Reserved Quantity	FlowField	Decimal	12
43	Purchaser Code	Purchaser Code	Normal	Code	20	Purchaser Code	nvarchar(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]
73	Drop Shipment	Drop Shipment	Normal	Boolean	4	Drop Shipment	tinyint
480	Dimension Set ID	Dimension Set ID	Normal	Integer	4	Dimension Set ID	int
	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]
5401	Prod. Order No.	Prod. Order No.	Normal	Code	20	Prod_ Order No_	nvarchar(40)
5402	Variant Code	Variant Code	Normal	Code	10	Variant Code	nvarchar(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]
5403	Bin Code	Bin Code	Normal	Code	20	Bin Code	nvarchar(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]
5404	Qty. per Unit of Measure	Qty. per Unit of Measure	Normal	Decimal	12	Qty_ per Unit of Measure	decimal(38,38)
5405	Qty. Rounding Precision	Qty. Rounding Precision	Normal	Decimal	12	Qty_ Rounding Precision	decimal(38,38)
5406	Qty. Rounding Precision (Base)	Qty. Rounding Precision (Base)	Normal	Decimal	12	Qty_ Rounding Precision (Base)	decimal(38,38)
5407	Unit of Measure Code	Unit of Measure Code	Normal	Code	10	Unit of Measure Code	nvarchar(20)
5408	Quantity (Base)	Quantity (Base)	Normal	Decimal	12	Quantity (Base)	decimal(38,38)
5431	Reserved Qty. (Base)	Reserved Qty. (Base)	FlowField	Decimal	12
5520	Demand Type	Demand Type	Normal	Integer	4	Demand Type	int
5521	Demand Subtype	Demand Subtype	Normal	Option	4	Demand Subtype	int
	Available options are: “0” “1” “2” “3” “4” “5” “6” “7” “8” “9”
5522	Demand Order No.	Demand Order No.	Normal	Code	20	Demand Order No_	nvarchar(40)
5525	Demand Line No.	Demand Line No.	Normal	Integer	4	Demand Line No_	int
5526	Demand Ref. No.	Demand Ref. No.	Normal	Integer	4	Demand Ref_ No_	int
5527	Status	Status	Normal	Option	4	Status	int
	Available options are: “0” “1” “2” “3” “4” “5” “6” “7” “8” “9” “10”
5530	Demand Date	Demand Date	Normal	Date	4	Demand Date	datetime
5532	Demand Quantity	Demand Quantity	Normal	Decimal	12	Demand Quantity	decimal(38,38)
5533	Demand Quantity (Base)	Demand Quantity (Base)	Normal	Decimal	12	Demand Quantity (Base)	decimal(38,38)
5538	Needed Quantity	Needed Quantity	Normal	Decimal	12	Needed Quantity	decimal(38,38)
5539	Needed Quantity (Base)	Needed Quantity (Base)	Normal	Decimal	12	Needed Quantity (Base)	decimal(38,38)
5540	Reserve	Reserve	Normal	Boolean	4	Reserve	tinyint
5541	Qty. per UOM (Demand)	Qty. per UOM (Demand)	Normal	Decimal	12	Qty_ per UOM (Demand)	decimal(38,38)
5542	Unit Of Measure Code (Demand)	Unit Of Measure Code (Demand)	Normal	Code	10	Unit Of Measure Code (Demand)	nvarchar(20)
5552	Supply From	Supply From	Normal	Code	20	Supply From	nvarchar(40)
5553	Original Item No.	Original Item No.	Normal	Code	20	Original 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_]
5554	Original Variant Code	Original Variant Code	Normal	Code	10	Original Variant Code	nvarchar(20)
5560	Level	Level	Normal	Integer	4	Level	int
5563	Demand Qty. Available	Demand Qty. Available	Normal	Decimal	12	Demand Qty_ Available	decimal(38,38)
5590	User ID	User ID	Normal	Code	50	User ID	nvarchar(100)
5701	Item Category Code	Item Category Code	Normal	Code	20	Item Category Code	nvarchar(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]
5702	Nonstock	Catalog	Normal	Boolean	4	Nonstock	tinyint
5703	Purchasing Code	Purchasing Code	Normal	Code	10	Purchasing Code	nvarchar(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]
5705	Product Group Code	Product Group Code	Normal	Code	10	Product Group Code	nvarchar(20)
5706	Transfer-from Code	Transfer-from Code	Normal	Code	10	Transfer-from Code	nvarchar(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]
5707	Transfer Shipment Date	Transfer Shipment Date	Normal	Date	4	Transfer Shipment Date	datetime
7000	Price Calculation Method	Price Calculation Method	Normal	Option	4	Price Calculation Method	int
	Available options are: ” “ “Lowest Price”
7002	Line Discount %	Line Discount %	Normal	Decimal	12	Line Discount _	decimal(38,38)
7100	Blanket Purch. Order Exists	Blanket Purch. Order Exists	FlowField	Boolean	4
7110	Custom Sorting Order	Custom Sorting Order	Normal	Code	50	Custom Sorting Order	nvarchar(100)
99000750	Routing No.	Routing No.	Normal	Code	20	Routing 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_]
99000751	Operation No.	Operation No.	Normal	Code	10	Operation No_	nvarchar(20)
99000752	Work Center No.	Work Center No.	Normal	Code	20	Work 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_]
99000754	Prod. Order Line No.	Prod. Order Line No.	Normal	Integer	4	Prod_ Order Line No_	int
99000755	MPS Order	MPS Order	Normal	Boolean	4	MPS Order	tinyint
99000756	Planning Flexibility	Planning Flexibility	Normal	Option	4	Planning Flexibility	int
	Available options are: “Unlimited” “None”
99000757	Routing Reference No.	Routing Reference No.	Normal	Integer	4	Routing Reference No_	int
99000882	Gen. Prod. Posting Group	Gen. Prod. Posting Group	Normal	Code	20	Gen_ Prod_ Posting Group	nvarchar(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]
99000883	Gen. Business Posting Group	Gen. Business Posting Group	Normal	Code	20	Gen_ Business Posting Group	nvarchar(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]
99000884	Low-Level Code	Low-Level Code	Normal	Integer	4	Low-Level Code	int
99000885	Production BOM Version Code	Production BOM Version Code	Normal	Code	20	Production BOM Version Code	nvarchar(40)
99000886	Routing Version Code	Routing Version Code	Normal	Code	20	Routing Version Code	nvarchar(40)
99000887	Routing Type	Routing Type	Normal	Option	4	Routing Type	int
	Available options are: “Serial” “Parallel”
99000888	Original Quantity	Original Quantity	Normal	Decimal	12	Original Quantity	decimal(38,38)
99000889	Finished Quantity	Finished Quantity	Normal	Decimal	12	Finished Quantity	decimal(38,38)
99000890	Remaining Quantity	Remaining Quantity	Normal	Decimal	12	Remaining Quantity	decimal(38,38)
99000891	Original Due Date	Original Due Date	Normal	Date	4	Original Due Date	datetime
99000892	Scrap %	Scrap %	Normal	Decimal	12	Scrap _	decimal(38,38)
99000894	Starting Date	Starting Date	Normal	Date	4	Starting Date	datetime
99000895	Starting Time	Starting Time	Normal	Time	4	Starting Time	datetime
99000896	Ending Date	Ending Date	Normal	Date	4	Ending Date	datetime
	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]
99000897	Ending Time	Ending Time	Normal	Time	4	Ending Time	datetime
99000898	Production BOM No.	Production BOM No.	Normal	Code	20	Production 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].[Line 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].[Line 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_]
99000899	Indirect Cost %	Indirect Cost %	Normal	Decimal	12	Indirect Cost _	decimal(38,38)
99000900	Overhead Rate	Overhead Rate	Normal	Decimal	12	Overhead Rate	decimal(38,38)
99000901	Unit Cost	Unit Cost	Normal	Decimal	12	Unit Cost	decimal(38,38)
99000902	Cost Amount	Cost Amount	Normal	Decimal	12	Cost Amount	decimal(38,38)
99000903	Replenishment System	Replenishment System	Normal	Option	4
99000904	Ref. Order No.	Ref. Order No.	Normal	Code	20	Ref_ Order No_	nvarchar(40)
99000905	Ref. Order Type	Ref. Order Type	Normal	Option	4	Ref_ Order Type	int
	Available options are: ” “ “Purchase” “Prod. Order” “Transfer” “Assembly”
99000906	Ref. Order Status	Ref. Order Status	Normal	Option	4	Ref_ Order Status	int
	Available options are: “” “Planned” “Firm Planned” “Released”
99000907	Ref. Line No.	Ref. Line No.	Normal	Integer	4	Ref_ Line No_	int
99000908	No. Series	No. Series	Normal	Code	20	No_ Series	nvarchar(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]
99000909	Expected Operation Cost Amt.	Expected Operation Cost Amt.	FlowField	Decimal	12
99000910	Expected Component Cost Amt.	Expected Component Cost Amt.	FlowField	Decimal	12
99000911	Finished Qty. (Base)	Finished Qty. (Base)	Normal	Decimal	12	Finished Qty_ (Base)	decimal(38,38)
99000912	Remaining Qty. (Base)	Remaining Qty. (Base)	Normal	Decimal	12	Remaining Qty_ (Base)	decimal(38,38)
99000913	Related to Planning Line	Related to Planning Line	Normal	Integer	4	Related to Planning Line	int
99000914	Planning Level	Planning Level	Normal	Integer	4	Planning Level	int
99000915	Planning Line Origin	Planning Line Origin	Normal	Option	4	Planning Line Origin	int
	Available options are: ” “ “Action Message” “Planning” “Order Planning”
99000916	Action Message	Action Message	Normal	Option	4	Action Message	int
	Available options are: ” “ “New” “Change Qty.” “Reschedule” “Resched. & Chg. Qty.” “Cancel”
99000917	Accept Action Message	Accept Action Message	Normal	Boolean	4	Accept Action Message	tinyint
99000918	Net Quantity (Base)	Net Quantity (Base)	Normal	Decimal	12	Net Quantity (Base)	decimal(38,38)
99000919	Starting Date-Time	Starting Date-Time	Normal	DateTime	8	Starting Date-Time	datetime
99000920	Ending Date-Time	Ending Date-Time	Normal	DateTime	8	Ending Date-Time	datetime
99000921	Order Promising ID	Order Promising ID	Normal	Code	20	Order Promising ID	nvarchar(40)
99000922	Order Promising Line No.	Order Promising Line No.	Normal	Integer	4	Order Promising Line No_	int
99000923	Order Promising Line ID	Order Promising Line ID	Normal	Integer	4	Order Promising Line ID	int
2000000000	$systemId	System ID	Normal	GUID	16	$systemId	uniqueidentifier
2000000001	SystemCreatedAt	Created At	Normal	DateTime	8	$systemCreatedAt	datetime
2000000002	SystemCreatedBy	Created By	Normal	GUID	16	$systemCreatedBy	uniqueidentifier
	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]
2000000003	SystemModifiedAt	Modified At	Normal	DateTime	8	$systemModifiedAt	datetime
2000000004	SystemModifiedBy	Modified By	Normal	GUID	16	$systemModifiedBy	uniqueidentifier

Show/hide tables related from Requisition Line table

Dynamics 365 BC Table Reference Tables Company Tables RRequisition Line

Leave a Reply Cancel reply