Whse. Cross-Dock Opportunity #5768

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

41
Fields
0
Records
4
Primary key
4
FlowFields
7
Relations
Open in Data Explorer →

Primary key

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

All fields (41)

Whse. Cross-Dock Opportunity — FIELDS
NO.FIELDTYPECLASSRELATION
1 Source Template Name PK Code Normal
2 Source Name/No. PK Code Normal
3 Source Line No. PK Integer Normal
4 Line No. PK Integer Normal
5 From Source Type Integer Normal
6 From Source Subtype Option Normal
7 From Source No. Code Normal
8 From Source Line No. Integer Normal
9 From Source Subline No. Integer Normal
10 From Source Document Option Normal
11 To Source Type Integer Normal
12 To Source Subtype Option Normal
13 To Source No. Code Normal
14 To Source Line No. Integer Normal
15 To Source Subline No. Integer Normal
16 To Source Document Option Normal
17 Item No. Code Normal → Item #27
18 Variant Code Code Normal → Item Variant #5401
19 Unit of Measure Code Code Normal → Item Unit of Measure #5404
20 Qty. per Unit of Measure Decimal Normal
21 Location Code Code Normal → Location #14
24 Qty. Needed Decimal Normal
25 Qty. Needed (Base) Decimal Normal
26 Qty. to Cross-Dock Decimal Normal
27 Qty. to Cross-Dock (Base) Decimal Normal
28 Qty. Cross-Docked (Base) ⚡ FLOW Decimal FlowField
29 Total Qty. Needed (Base) ⚡ FLOW Decimal FlowField
36 Reserved Quantity ⚡ FLOW Decimal FlowField
37 Reserved Qty. (Base) ⚡ FLOW Decimal FlowField
39 To-Src. Unit of Measure Code Code Normal → Item Unit of Measure #5404
40 To-Src. Qty. per Unit of Meas. Decimal Normal
41 Due Date Date Normal
42 Pick Qty. Decimal Normal
43 Pick Qty. (Base) Decimal Normal
44 Picked Qty. Decimal Normal
45 Picked Qty. (Base) Decimal 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 (5)

Tables referenced by fields on the Whse. Cross-Dock Opportunity table through TableRelation properties.

Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Item Unit of Measure
#5404 · Other · via Unit of Measure Code, To-Src. Unit of Measure Code
Location
#14 · General Ledger · via Location Code