Lot No. Information #6505

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

19
Fields
0
Records
3
Primary key
3
FlowFields
7
Relations
Open in Data Explorer →

Primary key

The primary key uniquely identifies each record in this table. It consists of: Item No., Variant Code, Lot No..

All fields (19)

Lot No. Information — FIELDS
NO.FIELDTYPECLASSRELATION
1 Item No. PK Code Normal → Item #27
2 Variant Code PK Code Normal → Item Variant #5401
3 Lot No. PK Code Normal
10 Description Text Normal
11 Test Quality Option Normal
12 Certificate Number Code Normal
13 Blocked Boolean Normal
14 Comment ⚡ FLOW Boolean FlowField
20 Inventory ⚡ FLOW Decimal FlowField
21 Date Filter Date FlowFilter
22 Location Filter Code FlowFilter → Location #14
23 Bin Filter Code FlowFilter → Bin #7354
24 Expired Inventory ⚡ FLOW Decimal FlowField
4810 Country/Region Code Code Normal → Country/Region #9
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 (6)

Tables referenced by fields on the Lot No. Information table through TableRelation properties.

Item
#27 · Inventory · via Item No.
Item Variant
#5401 · Other · via Variant Code
Location
#14 · General Ledger · via Location Filter
Bin
#7354 · Warehouse · via Bin Filter
Country/Region
#9 · General Ledger · via Country/Region Code