Reservation Wksh. Line #346

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

41
Fields
0
Records
2
Primary key
0
FlowFields
10
Relations
Open in Data Explorer →

Primary key

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

All fields (41)

Reservation Wksh. Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Journal Batch Name PK Code Normal → Reservation Wksh. Batch #345
2 Line No. PK Integer Normal
10 Source Type Integer Normal
11 Source Subtype Integer Normal
12 Source ID Code Normal
13 Source Batch Name Code Normal
14 Source Prod. Order Line Integer Normal
15 Source Ref. No. Integer Normal
17 Record ID RecordID Normal
21 Item No. Code Normal → Item #27
22 Variant Code Code Normal → Item Variant #5401
23 Location Code Code Normal → Location #14
24 Sell-to Customer No. Code Normal → Customer #18
25 Sell-to Customer Name Text Normal → Customer #18
26 Priority Integer Normal
29 Description Text Normal
30 Description 2 Text Normal
31 Demand Date Date Normal
32 Unit of Measure Code Code Normal → Item Unit of Measure #5404
33 Qty. per Unit of Measure Decimal Normal
41 Remaining Qty. to Reserve Decimal Normal
42 Rem. Qty. to Reserve (Base) Decimal Normal
43 Qty. to Reserve Decimal Normal
44 Qty. to Reserve (Base) Decimal Normal
51 Available Qty. to Reserve Decimal Normal
52 Avail. Qty. to Reserve (Base) Decimal Normal
61 Qty. in Stock Decimal Normal
62 Qty. in Stock (Base) Decimal Normal
63 Qty. Reserved from Stock Decimal Normal
64 Qty. Reserved from Stock (Base) Decimal Normal
65 Qty. in Warehouse Handling Decimal Normal
66 Qty. in Warehouse Handling (Base) Decimal Normal
100 Accept Boolean Normal
6501 Serial No. Code Normal
6502 Lot No. Code Normal
6503 Package No. Code 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 (8)

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

Reservation Wksh. Batch
#345 · Other · via Journal Batch Name
Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Location
#14 · General Ledger · via Location Code
Customer
#18 · Sales · via Sell-to Customer No., Sell-to Customer Name
Item Unit of Measure
#5404 · Other · via Unit of Measure Code