Qlty. Inspection Header #20405

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

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

Fields

Records

Primary key

FlowFields

Relations

Open in Data Explorer →

Primary key

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

All fields (55)

Qlty. Inspection Header — FIELDS

NO.	FIELD	TYPE	CLASS	RELATION
1	No. PK	Code	Normal
2	Re-inspection No. PK	Integer	Normal
4	Most Recent Re-inspection	Boolean	Normal
5	Template Code	Code	Normal	→ Qlty. Inspection Template Hdr. #20402
6	Description	Text	Normal
8	Status	Option	Normal
11	Quantity (Base)	Decimal	Normal
13	Pass Quantity	Decimal	Normal
15	Fail Quantity	Decimal	Normal
17	Sample Size	Integer	Normal
21	Assigned User ID	Code	Normal
23	Planned Start Date	DateTime	Normal
25	Finished Date	DateTime	Normal
26	Finished By User ID	Code	Normal
31	Result Code	Code	Normal	→ Qlty. Inspection Result #20411
32	Result ⚡ FLOW	Text	FlowField
33	Evaluation Sequence	Integer	Normal
35	Location Code	Code	Normal	→ Location #14
41	Most Recent Picture	Media	Normal
45	Existing Inspections (this record) ⚡ FLOW	Integer	FlowField
46	Existing Inspections (this item) ⚡ FLOW	Integer	FlowField
51	Source Table No.	Integer	Normal
52	Source Table Name ⚡ FLOW	Text	FlowField
53	Source Type	Integer	Normal
54	Source Sub Type	Integer	Normal
55	Document No.	Code	Normal
56	Document Line No.	Integer	Normal
58	Task No.	Code	Normal
61	Item No.	Code	Normal	→ Item #27
62	Variant Code	Code	Normal	→ Item Variant #5401
65	Serial No.	Code	Normal
66	Lot No.	Code	Normal
67	Package No.	Code	Normal
71	Trigger Record Table No.	Integer	Normal
72	Trigger Record	RecordID	Normal
75	Source Record Table No.	Integer	Normal
76	Source Record	RecordID	Normal
78	Source Record 2	RecordID	Normal
79	Source Record 3	RecordID	Normal
80	Source Record 4	RecordID	Normal
90	Source Custom 1	Text	Normal
91	Source Custom 2	Text	Normal
92	Source Custom 3	Text	Normal
93	Source Custom 4	Text	Normal
94	Source Custom 5	Text	Normal
95	Source Custom 6	Text	Normal
96	Source Custom 7	Integer	Normal
97	Source Custom 8	Integer	Normal
98	Source Custom 9	Decimal	Normal
99	Source Custom 10	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 (7)

Tables referenced by fields on the Qlty. Inspection Header table through TableRelation properties.

Qlty. Inspection Template Hdr.

#20402 · Other · via Template Code

Qlty. Inspection Result

#20411 · Other · via Result Code

Location

#14 · General Ledger · via Location Code

Item

#27 · Inventory · via Item No.

Item Variant

#5401 · Other · via Variant Code