Qlty. Inspection Line #20406

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

The Qlty. Inspection Line table (ID 20406) is part of the Other area in Microsoft Dynamics 365 Business Central. It contains 23 fields, with a primary key of Inspection No., Re-inspection No., Line No., and includes 2 calculated FlowFields. Use the reference below to explore every field, data type, and table relation.

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

Primary key

The primary key uniquely identifies each record in this table. It consists of: Inspection No., Re-inspection No., Line No..

All fields (23)

Qlty. Inspection Line — FIELDS
NO.FIELDTYPECLASSRELATION
1 Inspection No. PK Code Normal
2 Re-inspection No. PK Integer Normal
3 Line No. PK Integer Normal
4 Template Code Code Normal → Qlty. Inspection Header #20405
5 Quality Inspection Template Line No. Integer Normal → Qlty. Inspection Template Line #20403
12 Test Code Code Normal → Qlty. Test #20401
13 Description Text Normal
14 Test Value Type ⚡ FLOW Option FlowField
16 Allowable Values Text Normal
18 Test Value Text Normal
19 Test Value Blob BLOB Normal
25 Derived Numeric Value Decimal Normal
28 Result Code Code Normal → Qlty. Inspection Result #20411
29 Result ⚡ FLOW Text FlowField
30 Evaluation Sequence Integer Normal
33 Failure State Option Normal
34 Non-Conformance Inspection No. Code Normal
35 Unit of Measure Code Code Normal → Unit of Measure #204
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 Qlty. Inspection Line table through TableRelation properties.

Qlty. Inspection Header
#20405 · Other · via Template Code
Qlty. Inspection Template Line
#20403 · Other · via Quality Inspection Template Line No.
Qlty. Test
#20401 · Other · via Test Code
Qlty. Inspection Result
#20411 · Other · via Result Code
Unit of Measure
#204 · Other · via Unit of Measure Code