	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

113 COLUMNS | 11 INDEXES | 920 | 37 | F37900 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
37: Quality Management
1	920	F37900	TR	113	11	Certificate of Analysis (COA) Extract	Work 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 TRDOCO, TRDCTO, TRKCOO, TRLNID, TRRCTO, TRRORN, TRRKCO, TRRLLN, TRMCU, TRLOTN, TRLOCN, TRAN8, TRCS18, TRITM, TRIT18, TRQTST, TRMCU2, TRQSPC, TRHMCU, TRTSRT, TRQREV, TRQVAL, TRQPF, TRTOVR, TRMUSE, TRANO, TRQDAT, TRQTIM, TRQDSP, TRSNBR, TRQSMP, TRSMPC, TRACQT, TRACPC, TRSY, TRRT, TRAMIN, TRAMAX, TRPMIN, TRPMAX, TREFFF, TREFFT, TRQTRG, TRQSSZ, TRQASZ, TRQUM, TRPTTS, TRQTC1, TRQTC2, TRQTC3, TRQTC4, TRQTC5, TRTTTY, TRMFGR, TRMRRR, TRMFGC, TRPRCR, TRPRER, TRSHPR, TRBLKR, TROPSQ, TROPRS, TRBSEQ, TRTRT, TRTRP, TRTRPL, TRLCMP, TRVEHI, TRVMCU, TRRSQQ, TRTTST, TRDFCW, TRQPCD, TRDOC, TRPPDJ, TRSOQS, TRUOM, TRDRQJ, TRQTID, TRTMHD, TRRSUM, TRNUMB, TRASTM, TRQPRP, TRQDFC, TRQRTC, TRMMCU, TRCDEC, TRDERC, TRURCD, TRURDT, TRURAT, TRURRF, TRURAB, TRUSER, TRPID, TRUPMJ, TRTDAY, TRJOBN, TRUKID, TRRSEXPD, TRTSTRSNM, TRRSSTS, TRWLOTN, TRWBID, TRWOPID, TRWVID, TRWVTY, TRWSVT, TRWVNUM, TRRSCONVID, TRFRMRSVAL, TRFRMRSUM FROM F37900

TOP 920 | 37 | F37900 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	TRDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	TRDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	TRKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	TRLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
5	TRRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
6	TRRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
7	TRRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
8	TRRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
9	TRMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
10	TRLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
11	TRLOCN	Location	String	Generic Edit	20	0	Allow NULL?
12	TRAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
13	TRCS18	Customer Group - Quality Management	String	UDC (40 18)	8	0	Allow NULL?
14	TRITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
15	TRIT18	Item Group - Quality Management	String	UDC (40 68)	8	0	Allow NULL?
16	TRQTST	Test ID	String	Generic Edit	25	0	Allow NULL?
17	TRMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
18	TRQSPC	Specification	String	Generic Edit	25	0	Allow NULL?
19	TRHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
20	TRTSRT	Test Sort Sequence Number	Numeric	Generic Edit	5	0	Allow NULL?
21	TRQREV	Specification Revision Level	String	Generic Edit	3	0	Allow NULL?
22	TRQVAL	Test Value	String	Generic Edit	15	0	Allow NULL?
23	TRQPF	Pass/Fail (P/F)	Character	Generic Edit	1	0	Allow NULL?
24	TRTOVR	Test override flag	Character	Generic Edit	1	0	Allow NULL?
25	TRMUSE	User ID	String	Generic Edit	10	0	Allow NULL?
26	TRANO	Address Number - Originator	Numeric	Generic Edit	8	0	Allow NULL?
27	TRQDAT	Date tested	Date	Generic Edit	6	0
28	TRQTIM	Time tested	Numeric	Generic Edit	6	0	Allow NULL?
29	TRQDSP	Disposition Code	String	UDC (37 DS)	3	0	Allow NULL?
30	TRSNBR	Sample Number	Numeric	Generic Edit	15	0	Allow NULL?
31	TRQSMP	Number of Samples	Numeric	Generic Edit	15	0	Allow NULL?
32	TRSMPC	Sample Percentage	Numeric	Generic Edit	5	2	Allow NULL?
33	TRACQT	Accept Quantity	Numeric	Generic Edit	15	0	Allow NULL?
34	TRACPC	Accept Percentage	Numeric	Generic Edit	5	2	Allow NULL?
35	TRSY	Product Code	String	UDC (98 SY)	4	0	Allow NULL?
36	TRRT	User Defined Codes	String	Generic Edit	2	0	Allow NULL?
37	TRAMIN	Allowed Minimum Value	String	Generic Edit	15	0	Allow NULL?
38	TRAMAX	Allowed Maximum Value	String	Generic Edit	15	0	Allow NULL?
39	TRPMIN	Preferred Minimum Value (future use)	String	Generic Edit	15	0	Allow NULL?
40	TRPMAX	Preferred Maximum Value (future use)	String	Generic Edit	15	0	Allow NULL?
41	TREFFF	Effective - From Date	Date	Generic Edit	6	0
42	TREFFT	Effective - Thru Date	Date	Generic Edit	6	0
43	TRQTRG	Target Value	String	Generic Edit	15	0	Allow NULL?
44	TRQSSZ	Sample Size	Numeric	Generic Edit	15	0	Allow NULL?
45	TRQASZ	Actual Sample Size	Numeric	Generic Edit	15	0	Allow NULL?
46	TRQUM	Sample Size Unit of Measure	String	UDC (37 UM)	3	0	Allow NULL?
47	TRPTTS	Print Test	Character	UDC (37 PT)	1	0	Allow NULL?
48	TRQTC1	Test Category Code 1	String	UDC (37 T1)	3	0	Allow NULL?
49	TRQTC2	Test Category Code 2	String	UDC (37 T2)	3	0	Allow NULL?
50	TRQTC3	Test Category Code 3	String	UDC (37 T3)	3	0	Allow NULL?
51	TRQTC4	Test Category Code 4	String	UDC (37 T4)	3	0	Allow NULL?
52	TRQTC5	Test Category Code 5	String	UDC (37 T5)	3	0	Allow NULL?
53	TRTTTY	Test Type	Character	UDC (37 TY)	1	0	Allow NULL?
54	TRMFGR	Manufacturing Operations	Character	Generic Edit	1	0	Allow NULL?
55	TRMRRR	Manufacturing Receipt Routing	Character	Generic Edit	1	0	Allow NULL?
56	TRMFGC	Manufacturing Completions	Character	Generic Edit	1	0	Allow NULL?
57	TRPRCR	Purchasing Receipts	Character	Generic Edit	1	0	Allow NULL?
58	TRPRER	Purchasing Receipt Routing	Character	Generic Edit	1	0	Allow NULL?
59	TRSHPR	Ship Confirm	Character	Generic Edit	1	0	Allow NULL?
60	TRBLKR	Bulk Confirm	Character	Generic Edit	1	0	Allow NULL?
61	TROPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
62	TROPRS	Sequence Number - Operations	Numeric	Generic Edit	3	0	Allow NULL?
63	TRBSEQ	Sequence - Bubble Sequence	Numeric	Generic Edit	5	0	Allow NULL?
64	TRTRT	Type of Routing	String	UDC (40 TR)	3	0	Allow NULL?
65	TRTRP	Trip Number	Numeric	Generic Edit	8	0	Allow NULL?
66	TRTRPL	Load Leg Number	Numeric	Generic Edit	3	0	Allow NULL?
67	TRLCMP	Logical Compartment Number	Numeric	Generic Edit	5	0	Allow NULL?
68	TRVEHI	Vehicle ID	String	Generic Edit	12	0	Allow NULL?
69	TRVMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
70	TRRSQQ	Result Sort Sequence Number	Numeric	Generic Edit	5	0	Allow NULL?
71	TRTTST	Timing of Test (Future Use)	Character	Generic Edit	1	0	Allow NULL?
72	TRDFCW	Defect Write Code	Character	Generic Edit	1	0	Allow NULL?
73	TRQPCD	Quality Application Code	String	UDC (37 AC)	2	0	Allow NULL?
74	TRDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
75	TRPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
76	TRSOQS	Quantity Shipped	Numeric	Generic Edit	15	0	Allow NULL?
77	TRUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
78	TRDRQJ	Date - Requested	Date	Generic Edit	6	0
79	TRQTID	Quality Text ID Number	Numeric	Generic Edit	8	0	Allow NULL?
80	TRTMHD	Test Method	String	Generic Edit	30	0	Allow NULL?
81	TRRSUM	Results Unit of Measure	String	UDC (37 UM)	3	0	Allow NULL?
82	TRNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
83	TRASTM	ASTM Reference	String	Generic Edit	30	0	Allow NULL?
84	TRQPRP	Property	String	UDC (37 PR)	10	0	Allow NULL?
85	TRQDFC	Defect Source	String	UDC (37 SR)	3	0	Allow NULL?
86	TRQRTC	Root Cause	String	UDC (37 RC)	3	0	Allow NULL?
87	TRMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
88	TRCDEC	Display Decimals	Character	Generic Edit	1	0	Allow NULL?
89	TRDERC	Derived Calculation	String	Generic Edit	80	0	Allow NULL?
90	TRURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
91	TRURDT	User Reserved Date	Date	Generic Edit	6	0
92	TRURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
93	TRURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
94	TRURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
95	TRUSER	User ID	String	Generic Edit	10	0	Allow NULL?
96	TRPID	Program ID	String	Generic Edit	10	0	Allow NULL?
97	TRUPMJ	Date - Updated	Date	Generic Edit	6	0
98	TRTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
99	TRJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
100	TRUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
101	TRRSEXPD	Result Expiration Date	Date	Generic Edit	6	0
102	TRTSTRSNM	Test Result Name	String	Generic Edit	30	0	Allow NULL?
103	TRRSSTS	Result Status	Character	UDC (37 RS)	1	0	Allow NULL?
104	TRWLOTN	Blend Lot Number	String	Generic Edit	30	0	Allow NULL?
105	TRWBID	Blend ID	String	Generic Edit	30	0	Allow NULL?
106	TRWOPID	Operation ID	Integer	Generic Edit	11	0	Allow NULL?
107	TRWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
108	TRWVTY	Vessel Class	Character	Generic Edit	1	0	Allow NULL?
109	TRWSVT	Vessel Type	String	Generic Edit	4	0	Allow NULL?
110	TRWVNUM	Vessel Number	String	Generic Edit	30	0	Allow NULL?
111	TRRSCONVID	Result Conversion ID	String	Generic Edit	30	0	Allow NULL?
112	TRFRMRSVAL	From Result Value	String	Generic Edit	15	0	Allow NULL?
113	TRFRMRSUM	From Result UM	String	UDC (37 UM)	3	0	Allow NULL?

TOP 920 | 37 | F37900 INDEXES

Number

Description

Document Number Type +

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	LNID	Line Number	Ascending
5	ITM	Item Number - Short	Ascending
6	MCU	Business Unit	Ascending
7	LOTN	Lot/Serial Number	Ascending
8	LOCN	Location	Ascending
9	QTST	Test ID	Ascending
10	MCU2	Business Unit 2	Ascending

Trip Number Cost Center +

Element	Alias	Description	Sequence
1	TRP	Trip Number	Ascending
2	TRPL	Load Leg Number	Ascending
3	MCU	Business Unit	Ascending
4	LCMP	Logical Compartment Number	Ascending
5	QTST	Test ID	Ascending
6	MCU2	Business Unit 2	Ascending

RelatedPoSoNumber

Element	Alias	Description	Sequence
1	RORN	Related PO/SO/WO Number	Ascending

Unique Key ID (Primary/Unique)

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

Lot Sample DESC Location +

Element	Alias	Description	Sequence
1	LOTN	Lot/Serial Number	Ascending
2	LOCN	Location	Ascending
3	ITM	Item Number - Short	Ascending
4	MCU	Business Unit	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending
6	DCTO	Order Type	Ascending
7	KCOO	Order Company (Order Number)	Ascending
8	LNID	Line Number	Ascending
9	QTST	Test ID	Ascending
10	MCU2	Business Unit 2	Ascending
11	SNBR	Sample Number	Descending

Trip Sample DESC TripLeg +

Element	Alias	Description	Sequence
1	TRP	Trip Number	Ascending
2	TRPL	Load Leg Number	Ascending
3	MCU	Business Unit	Ascending
4	LCMP	Logical Compartment Number	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending
6	DCTO	Order Type	Ascending
7	KCOO	Order Company (Order Number)	Ascending
8	LNID	Line Number	Ascending
9	QTST	Test ID	Ascending
10	MCU2	Business Unit 2	Ascending
11	SNBR	Sample Number	Descending

RelatedPoSoLineNo

Element	Alias	Description	Sequence
1	RLLN	Related PO/SO Line Number	Descending

Lot Location Item +

Element	Alias	Description	Sequence
1	LOTN	Lot/Serial Number	Ascending
2	LOCN	Location	Ascending
3	ITM	Item Number - Short	Ascending
4	MCU	Business Unit	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending
6	DCTO	Order Type	Ascending
7	KCOO	Order Company (Order Number)	Ascending
8	LNID	Line Number	Ascending
9	QTST	Test ID	Ascending
10	MCU2	Business Unit 2	Ascending

Trip Leg Compartment +

Element	Alias	Description	Sequence
1	TRP	Trip Number	Ascending
2	TRPL	Load Leg Number	Ascending
3	MCU	Business Unit	Ascending
4	LCMP	Logical Compartment Number	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending
6	DCTO	Order Type	Ascending
7	KCOO	Order Company (Order Number)	Ascending
8	LNID	Line Number	Ascending
9	QTST	Test ID	Ascending
10	MCU2	Business Unit 2	Ascending

Lot Test Sort DESC +

Element	Alias	Description	Sequence
1	LOTN	Lot/Serial Number	Ascending
2	LOCN	Location	Ascending
3	ITM	Item Number - Short	Ascending
4	MCU	Business Unit	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending
6	DCTO	Order Type	Ascending
7	KCOO	Order Company (Order Number)	Ascending
8	LNID	Line Number	Ascending
9	QTST	Test ID	Ascending
10	MCU2	Business Unit 2	Ascending
11	TSRT	Test Sort Sequence Number	Descending

Trip Test Sort DESC +

Element	Alias	Description	Sequence
1	TRP	Trip Number	Ascending
2	TRPL	Load Leg Number	Ascending
3	MCU	Business Unit	Ascending
4	LCMP	Logical Compartment Number	Ascending
5	DOCO	Document (Order No Invoice etc.)	Ascending
6	DCTO	Order Type	Ascending
7	KCOO	Order Company (Order Number)	Ascending
8	LNID	Line Number	Ascending
9	QTST	Test ID	Ascending
10	MCU2	Business Unit 2	Ascending
11	TSRT	Test Sort Sequence Number	Descending

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

113 COLUMNS | 11 INDEXES | 920 | 37 | F37900 TABLE

TOP 920 | 37 | F37900 COLUMNS

TOP 920 | 37 | F37900 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

113 COLUMNS | 11 INDEXES | 920 | 37 | F37900 TABLE

TOP920 | 37 | F37900 COLUMNS

TOP920 | 37 | F37900 INDEXES

TOP 920 | 37 | F37900 COLUMNS

TOP 920 | 37 | F37900 INDEXES