	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

79 COLUMNS | 3 INDEXES | 910 | 37 | F3701 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
37: Quality Management
1	910	F3701	QA	79	3	Test Definitions Master File	Master Files	37: Quality Management	Business Data

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT QAQTST, QAMCU, QASTAW, QAEFFT, QAQTSN, QAEFFF, QADSC1, QATTTY, QANUMT, QASY, QART, QACDEC, QAQPRP, QAASTM, QAAMIN, QAPMIN, QAAMAX, QAPMAX, QAQTRG, QAQSSZ, QAQUM, QAQSMP, QAAVG, QATSDP, QAPTTS, QAPTTX, QAQTC1, QAQTC2, QAQTC3, QAQTC4, QAQTC5, QASMPC, QAACQT, QAACPC, QAQREV, QATMHD, QARSUM, QANUMB, QAQM01, QAQM02, QAQM03, QAQM04, QAQM05, QAQM06, QAQM07, QAQM08, QAQM09, QAQM10, QAMMCU, QADERC, QAURCD, QAURDT, QAURAT, QAURRF, QAURAB, QAACTN, QAUKID, QAUSER, QAPID, QAUPMJ, QATDAY, QAJOBN, QATSTRSNM, QARSCONVID, QARSDURDY, QATSTDURDY, QACHGTHRES, QAQMRF1, QAQMCD1, QAQMAB1, QAQMNUM1, QAQMDT1, QACRTLBTSK, QASMPMTHD, QASMPCNSL, QASMPCNTR, QASMPCLSR, QADLAB, QASCUKID FROM F3701

TOP 910 | 37 | F3701 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	QAQTST	Test ID	String	Generic Edit	25	0	Allow NULL?
2	QAMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
3	QASTAW	Status	Character	UDC (00 WS)	1	0	Allow NULL?
4	QAEFFT	Effective - Thru Date	Date	Generic Edit	6	0
5	QAQTSN	Quality Table Sequence Number	Numeric	Generic Edit	8	0	Allow NULL?
6	QAEFFF	Effective - From Date	Date	Generic Edit	6	0
7	QADSC1	Description	String	Generic Edit	30	0	Allow NULL?
8	QATTTY	Test Type	Character	UDC (37 TY)	1	0	Allow NULL?
9	QANUMT	Numeric (1/0)	Character	Generic Edit	1	0	Allow NULL?
10	QASY	Product Code	String	UDC (98 SY)	4	0	Allow NULL?
11	QART	User Defined Codes	String	Generic Edit	2	0	Allow NULL?
12	QACDEC	Display Decimals	Character	Generic Edit	1	0	Allow NULL?
13	QAQPRP	Property	String	UDC (37 PR)	10	0	Allow NULL?
14	QAASTM	ASTM Reference	String	Generic Edit	30	0	Allow NULL?
15	QAAMIN	Allowed Minimum Value	String	Generic Edit	15	0	Allow NULL?
16	QAPMIN	Preferred Minimum Value (future use)	String	Generic Edit	15	0	Allow NULL?
17	QAAMAX	Allowed Maximum Value	String	Generic Edit	15	0	Allow NULL?
18	QAPMAX	Preferred Maximum Value (future use)	String	Generic Edit	15	0	Allow NULL?
19	QAQTRG	Target Value	String	Generic Edit	15	0	Allow NULL?
20	QAQSSZ	Sample Size	Numeric	Generic Edit	15	0	Allow NULL?
21	QAQUM	Sample Size Unit of Measure	String	UDC (37 UM)	3	0	Allow NULL?
22	QAQSMP	Number of Samples	Numeric	Generic Edit	15	0	Allow NULL?
23	QAAVG	Average	Character	Generic Edit	1	0	Allow NULL?
24	QATSDP	Display/Evaluate Test	Character	UDC (37 DP)	1	0	Allow NULL?
25	QAPTTS	Print Test	Character	UDC (37 PT)	1	0	Allow NULL?
26	QAPTTX	Print Text (1/0)	Character	Generic Edit	1	0	Allow NULL?
27	QAQTC1	Test Category Code 1	String	UDC (37 T1)	3	0	Allow NULL?
28	QAQTC2	Test Category Code 2	String	UDC (37 T2)	3	0	Allow NULL?
29	QAQTC3	Test Category Code 3	String	UDC (37 T3)	3	0	Allow NULL?
30	QAQTC4	Test Category Code 4	String	UDC (37 T4)	3	0	Allow NULL?
31	QAQTC5	Test Category Code 5	String	UDC (37 T5)	3	0	Allow NULL?
32	QASMPC	Sample Percentage	Numeric	Generic Edit	5	2	Allow NULL?
33	QAACQT	Accept Quantity	Numeric	Generic Edit	15	0	Allow NULL?
34	QAACPC	Accept Percentage	Numeric	Generic Edit	5	2	Allow NULL?
35	QAQREV	Specification Revision Level	String	Generic Edit	3	0	Allow NULL?
36	QATMHD	Test Method	String	Generic Edit	30	0	Allow NULL?
37	QARSUM	Results Unit of Measure	String	UDC (37 UM)	3	0	Allow NULL?
38	QANUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
39	QAQM01	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
40	QAQM02	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
41	QAQM03	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
42	QAQM04	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
43	QAQM05	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
44	QAQM06	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
45	QAQM07	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
46	QAQM08	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
47	QAQM09	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
48	QAQM10	Quality Management Status	Character	Generic Edit	1	0	Allow NULL?
49	QAMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
50	QADERC	Derived Calculation	String	Generic Edit	80	0	Allow NULL?
51	QAURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
52	QAURDT	User Reserved Date	Date	Generic Edit	6	0
53	QAURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
54	QAURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
55	QAURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
56	QAACTN	Action Code	Character	Generic Edit	1	0	Allow NULL?
57	QAUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
58	QAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
59	QAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
60	QAUPMJ	Date - Updated	Date	Generic Edit	6	0
61	QATDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
62	QAJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
63	QATSTRSNM	Test Result Name	String	Generic Edit	30	0	Allow NULL?
64	QARSCONVID	Result Conversion ID	String	Generic Edit	30	0	Allow NULL?
65	QARSDURDY	Result Duration Days	Numeric	Generic Edit	3	0	Allow NULL?
66	QATSTDURDY	Test Duration Days	Numeric	Generic Edit	3	0	Allow NULL?
67	QACHGTHRES	Change Threshold	Numeric	Generic Edit	15	4	Allow NULL?
68	QAQMRF1	Quality Mgmt Reference 1	String	Generic Edit	30	0	Allow NULL?
69	QAQMCD1	Quality Mgmt Code 1	String	Generic Edit	3	0	Allow NULL?
70	QAQMAB1	Quality Mgmt Number 1	Numeric	Generic Edit	8	0	Allow NULL?
71	QAQMNUM1	Quality Mgmt Numeric 1	Numeric	Generic Edit	15	0	Allow NULL?
72	QAQMDT1	Quality Mgmt Date 1	Date	Generic Edit	6	0
73	QACRTLBTSK	Create Lab Task Flag	Character	Generic Edit	1	0	Allow NULL?
74	QASMPMTHD	Sample Method	String	UDC (37 SM)	10	0	Allow NULL?
75	QASMPCNSL	Sample Consolidation	String	UDC (37 CN)	2	0	Allow NULL?
76	QASMPCNTR	Sample Container	String	Generic Edit	10	0	Allow NULL?
77	QASMPCLSR	Sample Closure	String	UDC (37 CL)	10	0	Allow NULL?
78	QADLAB	Default Lab	Numeric	Generic Edit	8	0	Allow NULL?
79	QASCUKID	SampleContainerUKID	Numeric	Generic Edit	15	0	Allow NULL?

TOP 910 | 37 | F3701 INDEXES

Number

Description

Test ID Cost Center (Primary/Unique)

Element	Alias	Description	Sequence
1	QTST	Test ID	Ascending
2	MCU	Business Unit	Ascending
3	STAW	Status	Ascending
4	EFFT	Effective - Thru Date	Ascending
5	QTSN	Quality Table Sequence Number	Ascending

UKID

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

Sample Container

Element	Alias	Description	Sequence
1	SMPCNTR	Sample Container	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

79 COLUMNS | 3 INDEXES | 910 | 37 | F3701 TABLE

TOP 910 | 37 | F3701 COLUMNS

TOP 910 | 37 | F3701 INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

79 COLUMNS | 3 INDEXES | 910 | 37 | F3701 TABLE

TOP910 | 37 | F3701 COLUMNS

TOP910 | 37 | F3701 INDEXES

TOP 910 | 37 | F3701 COLUMNS

TOP 910 | 37 | F3701 INDEXES