	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

133 COLUMNS | 19 INDEXES | 920 | 37 | F3711 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
37: Quality Management
1	920	F3711	TR	133	19	Test Results	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 TRDOCO, TRDCTO, TRKCOO, TRLNID, TRRCTO, TRRORN, TRRKCO, TRRLLN, TRMCU, TRLOCN, TRLOTN, 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, TRRSQQ, TRTTST, TRDFCW, TRQPCD, TRQTID, TRTMHD, TRRSUM, TRNUMB, TRASTM, TRQPRP, TRQDFC, TRQRTC, TRMMCU, TRCDEC, TRUKID, TRDERC, TRURCD, TRURDT, TRURAT, TRURRF, TRURAB, TRUSER, TRPID, TRUPMJ, TRTDAY, TRJOBN, TRWLOTN, TRWOPID, TRRSEXPD, TRWVID, TRWVTY, TRTSTRSNM, TRRSSTS, TRRSCONVID, TRFRMRSVAL, TRFRMRSUM, TRQMRF3, TRQMCD3, TRQMAB3, TRQMNUM3, TRQMDT3, TRQABLRUL, TRCDEC2, TRPRVQVAL, TRPRVQDAT, TRPRVRSNM, TRNUMT, TRNUMT3, TRPRVRSUM, TRDLAB, TRMELC, TRRNAMAX, TRRNAMIN, TRRNPMAX, TRRNPMIN, TRRNQTRG, TRBLUID, TRSBLUID, TRSY1, TRRT1, TRTSTRTY, TRWVNUM, TRSMPCNSL, TRBSNBR, TRWTBID FROM F3711

TOP 920 | 37 | F3711 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	TRLOCN	Location	String	Generic Edit	20	0	Allow NULL?
11	TRLOTN	Lot/Serial Number	String	Generic Edit	30	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	TRRSQQ	Result Sort Sequence Number	Numeric	Generic Edit	5	0	Allow NULL?
70	TRTTST	Timing of Test (Future Use)	Character	Generic Edit	1	0	Allow NULL?
71	TRDFCW	Defect Write Code	Character	Generic Edit	1	0	Allow NULL?
72	TRQPCD	Quality Application Code	String	UDC (37 AC)	2	0	Allow NULL?
73	TRQTID	Quality Text ID Number	Numeric	Generic Edit	8	0	Allow NULL?
74	TRTMHD	Test Method	String	Generic Edit	30	0	Allow NULL?
75	TRRSUM	Results Unit of Measure	String	UDC (37 UM)	3	0	Allow NULL?
76	TRNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
77	TRASTM	ASTM Reference	String	Generic Edit	30	0	Allow NULL?
78	TRQPRP	Property	String	UDC (37 PR)	10	0	Allow NULL?
79	TRQDFC	Defect Source	String	UDC (37 SR)	3	0	Allow NULL?
80	TRQRTC	Root Cause	String	UDC (37 RC)	3	0	Allow NULL?
81	TRMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
82	TRCDEC	Display Decimals	Character	Generic Edit	1	0	Allow NULL?
83	TRUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
84	TRDERC	Derived Calculation	String	Generic Edit	80	0	Allow NULL?
85	TRURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
86	TRURDT	User Reserved Date	Date	Generic Edit	6	0
87	TRURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
88	TRURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
89	TRURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
90	TRUSER	User ID	String	Generic Edit	10	0	Allow NULL?
91	TRPID	Program ID	String	Generic Edit	10	0	Allow NULL?
92	TRUPMJ	Date - Updated	Date	Generic Edit	6	0
93	TRTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
94	TRJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
95	TRWLOTN	Blend Lot Number	String	Generic Edit	30	0	Allow NULL?
96	TRWOPID	Operation ID	Integer	Generic Edit	11	0	Allow NULL?
97	TRRSEXPD	Result Expiration Date	Date	Generic Edit	6	0
98	TRWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
99	TRWVTY	Vessel Class	Character	Generic Edit	1	0	Allow NULL?
100	TRTSTRSNM	Test Result Name	String	Generic Edit	30	0	Allow NULL?
101	TRRSSTS	Result Status	Character	UDC (37 RS)	1	0	Allow NULL?
102	TRRSCONVID	Result Conversion ID	String	Generic Edit	30	0	Allow NULL?
103	TRFRMRSVAL	From Result Value	String	Generic Edit	15	0	Allow NULL?
104	TRFRMRSUM	From Result UM	String	UDC (37 UM)	3	0	Allow NULL?
105	TRQMRF3	Quality Mgmt Reference 3	String	Generic Edit	30	0	Allow NULL?
106	TRQMCD3	Quality Mgmt Code 3	String	Generic Edit	3	0	Allow NULL?
107	TRQMAB3	Quality Mgmt Number 3	Numeric	Generic Edit	8	0	Allow NULL?
108	TRQMNUM3	Quality Mgmt Numeric 3	Numeric	Generic Edit	15	0	Allow NULL?
109	TRQMDT3	Quality Mgmt Date 3	Date	Generic Edit	6	0
110	TRQABLRUL	Quality Assurance Blending Rule	String	UDC (31B QB)	5	0	Allow NULL?
111	TRCDEC2	Display Decimals	Character	Generic Edit	1	0	Allow NULL?
112	TRPRVQVAL	Previous Test Value	String	Generic Edit	15	0	Allow NULL?
113	TRPRVQDAT	Previous Date Tested	Date	Generic Edit	6	0
114	TRPRVRSNM	Previous Result Name Value	String	Generic Edit	15	0	Allow NULL?
115	TRNUMT	Numeric (1/0)	Character	Generic Edit	1	0	Allow NULL?
116	TRNUMT3	Numeric (1/0)	Character	Generic Edit	1	0	Allow NULL?
117	TRPRVRSUM	Previous Result UOM	String	UDC (37 UM)	3	0	Allow NULL?
118	TRDLAB	Default Lab	Numeric	Generic Edit	8	0	Allow NULL?
119	TRMELC	Measurement Location	String	UDC (13 LC)	10	0	Allow NULL?
120	TRRNAMAX	Result Name Allowed Maximum Value	String	Generic Edit	15	0	Allow NULL?
121	TRRNAMIN	Result Name Allowed Minimum Value	String	Generic Edit	15	0	Allow NULL?
122	TRRNPMAX	Result Name Preferred Maximum Value	String	Generic Edit	15	0	Allow NULL?
123	TRRNPMIN	Result Name Preferred Minimum Value	String	Generic Edit	15	0	Allow NULL?
124	TRRNQTRG	Result Name Target Value	String	Generic Edit	15	0	Allow NULL?
125	TRBLUID	Block Identifier	Numeric	Generic Edit	8	0	Allow NULL?
126	TRSBLUID	Block Descriptor ID	Numeric	Generic Edit	5	0	Allow NULL?
127	TRSY1	System Code	String	UDC (98 SY)	4	0	Allow NULL?
128	TRRT1	User Defined Codes	String	Generic Edit	2	0	Allow NULL?
129	TRTSTRTY	Test Reading Type	String	Generic Edit	3	0	Allow NULL?
130	TRWVNUM	Vessel Number	String	Generic Edit	30	0	Allow NULL?
131	TRSMPCNSL	Sample Consolidation	String	UDC (37 CN)	2	0	Allow NULL?
132	TRBSNBR	Blend Sample Number	Integer	Generic Edit	11	0	Allow NULL?
133	TRWTBID	Trial Blend ID	Integer	Generic Edit	11	0	Allow NULL?

TOP 920 | 37 | F3711 INDEXES

Number

Description

UniqueKeyID (Primary/Unique)

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

Document Document Type A

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	LOTN	Lot/Serial Number	Ascending
6	LOCN	Location	Ascending
7	ITM	Item Number - Short	Ascending
8	MCU	Business Unit	Ascending
9	SNBR	Sample Number	Ascending
10	TSRT	Test Sort Sequence Number	Ascending

Lot Location Item Branch

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

Document Document Type B

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	LOTN	Lot/Serial Number	Ascending
6	LOCN	Location	Ascending
7	ITM	Item Number - Short	Ascending
8	MCU	Business Unit	Ascending
9	TSRT	Test Sort Sequence Number	Ascending
10	SNBR	Sample Number	Ascending

TripNumber LegNumber A

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	SNBR	Sample Number	Ascending
10	TSRT	Test Sort Sequence Number	Ascending

TripNumber LegNumber B

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

TestID ShortItem Branch

Element	Alias	Description	Sequence
1	QTST	Test ID	Ascending
2	ITM	Item Number - Short	Ascending
3	MCU2	Business Unit 2	Ascending
4	MCU	Business Unit	Ascending
5	LOTN	Lot/Serial Number	Ascending
6	LOCN	Location	Ascending
7	QPCD	Quality Application Code	Ascending

Document Document Type C

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	SNBR	Sample Number	Descending
6	TSRT	Test Sort Sequence Number	Ascending

TestID Detail Branch

Element	Alias	Description	Sequence
1	QTST	Test ID	Ascending
2	MCU2	Business Unit 2	Ascending

Branch Item TestID

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

TripNumber LegNumber C

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	TSRT	Test Sort Sequence Number	Ascending
10	SNBR	Sample Number	Ascending

Lot Test Sort Seq 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	TSRT	Test Sort Sequence Number	Descending

Trip Test Sort Seq 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	TSRT	Test Sort Sequence Number	Descending

Document Document Type Full

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	LOTN	Lot/Serial Number	Ascending
6	LOCN	Location	Ascending
7	MCU	Business Unit	Ascending
8	ITM	Item Number - Short	Ascending
9	TRP	Trip Number	Ascending
10	TRPL	Load Leg Number	Ascending
11	LCMP	Logical Compartment Number	Ascending
12	TSRT	Test Sort Sequence Number	Ascending

Branch WineLot

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	WLOTN	Blend Lot Number	Ascending
3	TSTRSNM	Test Result Name	Ascending

Opid CostCenter BlendLot

Element	Alias	Description	Sequence
1	WOPID	Operation ID	Ascending
2	MCU	Business Unit	Ascending
3	WLOTN	Blend Lot Number	Ascending
4	TSTRSNM	Test Result Name	Ascending

Equip Location Test ID +

Element	Alias	Description	Sequence
1	NUMB	Asset Item Number	Ascending
2	MELC	Measurement Location	Ascending
3	QTST	Test ID	Ascending
4	TSRT	Test Sort Sequence Number	Ascending
5	MCU2	Business Unit 2	Ascending
6	QDAT	Date tested	Ascending
7	QTIM	Time tested	Ascending

Sample

Element	Alias	Description	Sequence
1	BSNBR	Blend Sample Number	Ascending

TrialBlendID CostCenter +

Element	Alias	Description	Sequence
1	WTBID	Trial Blend ID	Ascending
2	MCU	Business Unit	Ascending
3	WLOTN	Blend Lot Number	Ascending
4	TSTRSNM	Test Result Name	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

133 COLUMNS | 19 INDEXES | 920 | 37 | F3711 TABLE

TOP 920 | 37 | F3711 COLUMNS

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

133 COLUMNS | 19 INDEXES | 920 | 37 | F3711 TABLE

TOP920 | 37 | F3711 COLUMNS

TOP920 | 37 | F3711 INDEXES

TOP 920 | 37 | F3711 COLUMNS

TOP 920 | 37 | F3711 INDEXES