XPT / Schema / Requisition Line

Requisition Line #246

Other table in Microsoft Dynamics 365 Business Central. 123 fields, 0 records in Cronus demo.

123
Fields
0
Records
3
Primary key
5
FlowFields
34
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Worksheet Template Name, Journal Batch Name, Line No..

All fields (123)

Requisition Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Worksheet Template Name PK Code Normal → Req. Wksh. Template #244
2 Journal Batch Name PK Code Normal → Requisition Wksh. Name #245
3 Line No. PK Integer Normal
4 Type Option Normal
5 No. Code Normal
6 Description Text Normal
7 Description 2 Text Normal
8 Quantity Decimal Normal
9 Vendor No. Code Normal → Vendor #23
10 Direct Unit Cost Decimal Normal
12 Due Date Date Normal
13 Requester ID Code Normal
14 Confirmed Boolean Normal
15 Shortcut Dimension 1 Code Code Normal → Dimension Value #349
16 Shortcut Dimension 2 Code Code Normal → Dimension Value #349
17 Location Code Code Normal → Location #14
18 Recurring Method Option Normal
19 Expiration Date Date Normal
20 Recurring Frequency DateFormula Normal
21 Order Date Date Normal
22 Vendor Item No. Text Normal
23 Sales Order No. Code Normal → Sales Header #36
24 Sales Order Line No. Integer Normal
25 Sell-to Customer No. Code Normal → Customer #18
26 Ship-to Code Code Normal → Ship-to Address #222
28 Order Address Code Code Normal → Order Address #224
29 Currency Code Code Normal → Currency #4
30 Currency Factor Decimal Normal
31 Reserved Quantity ⚡ FLOW Decimal FlowField
43 Purchaser Code Code Normal → Salesperson/Purchaser #13
73 Drop Shipment Boolean Normal
480 Dimension Set ID Integer Normal → Dimension Set Entry #480
5401 Prod. Order No. Code Normal → Production Order #5405
5402 Variant Code Code Normal
5403 Bin Code Code Normal → Bin #7354
5404 Qty. per Unit of Measure Decimal Normal
5405 Qty. Rounding Precision Decimal Normal
5406 Qty. Rounding Precision (Base) Decimal Normal
5407 Unit of Measure Code Code Normal
5408 Quantity (Base) Decimal Normal
5431 Reserved Qty. (Base) ⚡ FLOW Decimal FlowField
5520 Demand Type Integer Normal
5521 Demand Subtype Option Normal
5522 Demand Order No. Code Normal
5525 Demand Line No. Integer Normal
5526 Demand Ref. No. Integer Normal
5527 Status Option Normal
5530 Demand Date Date Normal
5532 Demand Quantity Decimal Normal
5533 Demand Quantity (Base) Decimal Normal
5538 Needed Quantity Decimal Normal
5539 Needed Quantity (Base) Decimal Normal
5540 Reserve Boolean Normal
5541 Qty. per UOM (Demand) Decimal Normal
5542 Unit Of Measure Code (Demand) Code Normal
5552 Supply From Code Normal
5553 Original Item No. Code Normal → Item #27
5554 Original Variant Code Code Normal → Item Variant #5401
5560 Level Integer Normal
5563 Demand Qty. Available Decimal Normal
5590 User ID Code Normal
5701 Item Category Code Code Normal
5702 Catalog Boolean Normal
5703 Purchasing Code Code Normal → Purchasing #5721
5706 Transfer-from Code Code Normal → Location #14
5707 Transfer Shipment Date Date Normal
7000 Price Calculation Method Option Normal
7002 Line Discount % Decimal Normal
7100 Blanket Purch. Order Exists ⚡ FLOW Boolean FlowField
7110 Custom Sorting Order Code Normal
99000750 Routing No. Code Normal → Routing Header #99000763
99000751 Operation No. Code Normal → Prod. Order Routing Line #5409
99000752 Work Center No. Code Normal → Work Center #99000754
99000754 Prod. Order Line No. Integer Normal → Prod. Order Line #5406
99000755 MPS Order Boolean Normal
99000756 Planning Flexibility Option Normal
99000757 Routing Reference No. Integer Normal
99000882 Gen. Prod. Posting Group Code Normal → Gen. Product Posting Group #251
99000883 Gen. Business Posting Group Code Normal → Gen. Business Posting Group #250
99000884 Low-Level Code Integer Normal
99000885 Production BOM Version Code Code Normal → Production BOM Version #99000779
99000886 Routing Version Code Code Normal → Routing Version #99000786
99000887 Routing Type Option Normal
99000888 Original Quantity Decimal Normal
99000889 Finished Quantity Decimal Normal
99000890 Remaining Quantity Decimal Normal
99000891 Original Due Date Date Normal
99000892 Scrap % Decimal Normal
99000894 Starting Date Date Normal
99000895 Starting Time Time Normal
99000896 Ending Date Date Normal
99000897 Ending Time Time Normal
99000898 Production BOM No. Code Normal → Production BOM Header #99000771
99000899 Indirect Cost % Decimal Normal
99000900 Overhead Rate Decimal Normal
99000901 Unit Cost Decimal Normal
99000902 Cost Amount Decimal Normal
99000903 Replenishment System Option Normal
99000904 Ref. Order No. Code Normal
99000905 Ref. Order Type Option Normal
99000906 Ref. Order Status Option Normal
99000907 Ref. Line No. Integer Normal
99000908 No. Series Code Normal → No. Series #308
99000909 Expected Operation Cost Amt. ⚡ FLOW Decimal FlowField
99000910 Expected Component Cost Amt. ⚡ FLOW Decimal FlowField
99000911 Finished Qty. (Base) Decimal Normal
99000912 Remaining Qty. (Base) Decimal Normal
99000913 Related to Planning Line Integer Normal
99000914 Planning Level Integer Normal
99000915 Planning Line Origin Option Normal
99000916 Action Message Option Normal
99000917 Accept Action Message Boolean Normal
99000918 Net Quantity (Base) Decimal Normal
99000919 Starting Date-Time DateTime Normal
99000920 Ending Date-Time DateTime Normal
99000921 Order Promising ID Code Normal
99000922 Order Promising Line No. Integer Normal
99000923 Order Promising Line ID Integer Normal
2000000000 System ID GUID Normal
2000000001 Created At DateTime Normal
2000000002 Created By GUID Normal
2000000003 Modified At DateTime Normal
2000000004 Modified By GUID Normal

Related tables (29)

Tables referenced by fields on the Requisition Line table through TableRelation properties.

Req. Wksh. Template
#244 · Setup · via Worksheet Template Name
Requisition Wksh. Name
#245 · Other · via Journal Batch Name
Vendor
#23 · Purchasing · via Vendor No.
Dimension Value
#349 · Dimensions · via Shortcut Dimension 1 Code, Shortcut Dimension 2 Code
Location
#14 · General Ledger · via Location Code, Transfer-from Code
Sales Header
#36 · Sales Documents · via Sales Order No.
Customer
#18 · Sales · via Sell-to Customer No.
Ship-to Address
#222 · Other · via Ship-to Code
Order Address
#224 · Other · via Order Address Code
Currency
#4 · General Ledger · via Currency Code
Salesperson/Purchaser
#13 · General Ledger · via Purchaser Code
Dimension Set Entry
#480 · Dimensions · via Dimension Set ID
Production Order
#5405 · Other · via Prod. Order No.
Bin
#7354 · Warehouse · via Bin Code
Item
#27 · Inventory · via Original Item No.
Item Variant
#5401 · Other · via Original Variant Code
Purchasing
#5721 · Other · via Purchasing Code
Routing Header
#99000763 · Manufacturing · via Routing No.
Prod. Order Routing Line
#5409 · Other · via Operation No.
Work Center
#99000754 · Manufacturing · via Work Center No.
Prod. Order Line
#5406 · Other · via Prod. Order Line No.
Gen. Product Posting Group
#251 · Other · via Gen. Prod. Posting Group
Gen. Business Posting Group
#250 · Other · via Gen. Business Posting Group
Production BOM Version
#99000779 · Manufacturing · via Production BOM Version Code
Routing Version
#99000786 · Manufacturing · via Routing Version Code
Production BOM Header
#99000771 · Manufacturing · via Production BOM No.
No. Series
#308 · Other · via No. Series

© 2026 Xpertly Ltd · Company No. 14753894 · VAT No. 452840787

HomeData ExplorerPricingPrivacyTerms