	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

107 COLUMNS | 4 INDEXES | 920 | 75I | F75I701 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
75I: India
1	920	F75I701	QH	107	4	Bill of Entry - Header	Files	75I: India

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 QHUKID, QHUK01, QHUK02, QHYSFX, QHYSFL, QHDOCO, QHDCTO, QHKCOO, QHSFXO, QHYBTP, QHYRTN, QHYRTD, QHYBED, QHYLNO, QHYREF, QHMCU, QHCO, QHMOT, QHYPES, QHYISN, QHYISD, QHYCNO, QHYICO, QHYVNM, QHYPOS, QHYPOD, QHYPCD, QHYBLN, QHYBLD, QHYSUM, QHYSQT, QHTMPS, QHDNST, QHSTPU, QHDNTP, QHYNQT, QHYNUM, QHYNTM, QHYNDN, QHYTUM, QHYTQT, QHYCC, QHYCCC, QHYCDT, QHYUTD, QHYASS, QHYUAV, QHYDTF, QHYDTT, QHVINV, QHDIVJ, QHYBID, QHA107, QHA108, QHYSNO, QHYSDT, QHYMOA, QHYCBN, QHYPDN, QHYPAC, QHYBPD, QHYBDT, QHTMCU, QHSHAN, QHRMK, QHPAGM, QHCNTD, QHYTRB, QHYTPN, QHYGPM, QHYIPM, QHYLPM, QHYDPM, QHYWHL, QHTHD1, QHYPMT, QHGPSP, QHYCR, QHYCCN, QHYFWH, QHYTWH, QHBPFG, QHPRTF, QHRCOP, QHFLAG, QHLTTR, QHNXTR, QHSNTO, QHAPDJ, QHSLCR, QHRUM, QHQYOA, QHYQT, QHCRR, QHCHD, QHURAB, QHURAT, QHURCD, QHURDT, QHURRF, QHAUSR, QHMJOB, QHUSER, QHJOBN, QHUPMJ, QHPID, QHTDAY FROM F75I701

TOP 920 | 75I | F75I701 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	QHUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	QHUK01	Unique Key ID 01 (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
3	QHUK02	Unique Key ID 02 (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
4	QHYSFX	Order Suffix Current	String	Generic Edit	3	0	Allow NULL?
5	QHYSFL	Order Suffix Last	String	Generic Edit	3	0	Allow NULL?
6	QHDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
7	QHDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
8	QHKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
9	QHSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
10	QHYBTP	Bill of Entry Type	String	Generic Edit	2	0	Allow NULL?
11	QHYRTN	IGM / Rotation Number	String	Generic Edit	25	0	Allow NULL?
12	QHYRTD	Date - Rotation Julian	Date	Generic Edit	6	0
13	QHYBED	Date - Bill of Entry	Date	Generic Edit	6	0
14	QHYLNO	Line Number	String	Generic Edit	10	0	Allow NULL?
15	QHYREF	Reference Number	String	Generic Edit	40	0	Allow NULL?
16	QHMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
17	QHCO	Company	String	Generic Edit	5	0	Allow NULL?
18	QHMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
19	QHYPES	Prior Entry Stamp	String	Generic Edit	25	0	Allow NULL?
20	QHYISN	Serial Number - Import Department	String	Generic Edit	25	0	Allow NULL?
21	QHYISD	Date - Import Department	Date	Generic Edit	6	0
22	QHYCNO	Custom House Agent	Numeric	Generic Edit	8	0	Allow NULL?
23	QHYICO	Importer Company	Numeric	Generic Edit	8	0	Allow NULL?
24	QHYVNM	Vessel Code	String	Generic Edit	4	0	Allow NULL?
25	QHYPOS	Port of Shipment	String	Generic Edit	3	0	Allow NULL?
26	QHYPOD	Port of Destination	String	Generic Edit	3	0	Allow NULL?
27	QHYPCD	Part Code	String	Generic Edit	5	0	Allow NULL?
28	QHYBLN	Bill of Lading Number	String	Generic Edit	25	0	Allow NULL?
29	QHYBLD	Date - Bill of Lading	Date	Generic Edit	6	0
30	QHYSUM	Standard Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
31	QHYSQT	Standard Quantity	Numeric	Generic Edit	15	0	Allow NULL?
32	QHTMPS	Temperature - Standard	Numeric	Generic Edit	7	2	Allow NULL?
33	QHDNST	Density At Standard Temperature	Numeric	Generic Edit	7	2	Allow NULL?
34	QHSTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
35	QHDNTP	Density Type - At Standard Temperature	Character	UDC (41B DT)	1	0	Allow NULL?
36	QHYNQT	Natural Quantity	Numeric	Generic Edit	15	0	Allow NULL?
37	QHYNUM	Natural - Unit Of Measure	String	UDC (00 UM)	2	0	Allow NULL?
38	QHYNTM	Natural Temperature	Numeric	Generic Edit	7	2	Allow NULL?
39	QHYNDN	Natural Density	Numeric	Generic Edit	7	2	Allow NULL?
40	QHYTUM	Customs Unit Of Measure	String	UDC (00 UM)	2	0	Allow NULL?
41	QHYTQT	Customs Quantity	Numeric	Generic Edit	15	0	Allow NULL?
42	QHYCC	Currency Code	String	Generic Edit	3	0	Allow NULL?
43	QHYCCC	Currency Code - Customs	String	Generic Edit	3	0	Allow NULL?
44	QHYCDT	Customs Duty	Numeric	Generic Edit	15	2	Allow NULL?
45	QHYUTD	Unit Rate - Customs Duty	Numeric	Generic Edit	15	4	Allow NULL?
46	QHYASS	Assessable Value	Numeric	Generic Edit	15	2	Allow NULL?
47	QHYUAV	Unit Rate - AssessableValue	Numeric	Generic Edit	15	4	Allow NULL?
48	QHYDTF	Date - BOE Valid From	Date	Generic Edit	6	0
49	QHYDTT	Date - BOE Valid Thru	Date	Generic Edit	6	0
50	QHVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
51	QHDIVJ	Date - Invoice - Julian	Date	Generic Edit	6	0
52	QHYBID	BOE Serial No	String	Generic Edit	25	0	Allow NULL?
53	QHA107	Generic Character 7	Character	Generic Edit	1	0	Allow NULL?
54	QHA108	Generic Character 8	Character	Generic Edit	1	0	Allow NULL?
55	QHYSNO	Cash Serial No	String	Generic Edit	25	0	Allow NULL?
56	QHYSDT	Date - CashSerialNo	Date	Generic Edit	6	0
57	QHYMOA	Master Of Agents	String	Generic Edit	25	0	Allow NULL?
58	QHYCBN	Continuity W/H Bond No	String	Generic Edit	22	0	Allow NULL?
59	QHYPDN	PD BondNo	String	Generic Edit	22	0	Allow NULL?
60	QHYPAC	PD Account Number	String	Generic Edit	10	0	Allow NULL?
61	QHYBPD	Into Bond PD Number	String	Generic Edit	25	0	Allow NULL?
62	QHYBDT	Date - Into Bond PD	Date	Generic Edit	6	0
63	QHTMCU	Business Unit - Transfer	String	Generic Edit	12	0	Allow NULL?
64	QHSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
65	QHRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
66	QHPAGM	Parent Agreement Number	String	Generic Edit	12	0	Allow NULL?
67	QHCNTD	Date - Signed	Date	Generic Edit	6	0
68	QHYTRB	Transit Bond Number	String	Generic Edit	22	0	Allow NULL?
69	QHYTPN	Transfer Permission Number	String	Generic Edit	22	0	Allow NULL?
70	QHYGPM	Goods Print Message	String	UDC (40 PM)	10	0	Allow NULL?
71	QHYIPM	Invoice Print Message	String	UDC (40 PM)	10	0	Allow NULL?
72	QHYLPM	License Print Message	String	UDC (40 PM)	10	0	Allow NULL?
73	QHYDPM	Duty Print Message	String	UDC (40 PM)	10	0	Allow NULL?
74	QHYWHL	WareHouse - Location	String	Generic Edit	22	0	Allow NULL?
75	QHTHD1	Threshold 1 Days	Numeric	Generic Edit	3	0	Allow NULL?
76	QHYPMT	Per Metric Ton	String	Generic Edit	3	0	Allow NULL?
77	QHGPSP	Processed Flag	Character	Generic Edit	1	0	Allow NULL?
78	QHYCR	Commisionerate	Numeric	Generic Edit	8	0	Allow NULL?
79	QHYCCN	The fiels that specifies the collector n	Numeric	Generic Edit	8	0	Allow NULL?
80	QHYFWH	From Warehouse	String	Generic Edit	40	0	Allow NULL?
81	QHYTWH	To Warehouse	String	Generic Edit	40	0	Allow NULL?
82	QHBPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
83	QHPRTF	Printed Flag	Character	UDC (48 PS)	1	0	Allow NULL?
84	QHRCOP	Number of Report Copies	Numeric	Generic Edit	3	0	Allow NULL?
85	QHFLAG	Journaling Flag	Character	Generic Edit	1	0	Allow NULL?
86	QHLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
87	QHNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
88	QHSNTO	Address Number - Approver	Numeric	Generic Edit	8	0	Allow NULL?
89	QHAPDJ	Date - Approved	Date	Generic Edit	6	0
90	QHSLCR	Flag - Selection Criteria	Character	UDC	1	0	Allow NULL?
91	QHRUM	Related Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
92	QHQYOA	Units - Quantity Open/Available	Numeric	Generic Edit	15	0	Allow NULL?
93	QHYQT	Quantity Open - Turn	Numeric	Generic Edit	15	0	Allow NULL?
94	QHCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
95	QHCHD	Change Date	Date	Generic Edit	6	0
96	QHURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
97	QHURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
98	QHURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
99	QHURDT	User Reserved Date	Date	Generic Edit	6	0
100	QHURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
101	QHAUSR	Authorized User ID	String	Generic Edit	10	0	Allow NULL?
102	QHMJOB	Work Station ID	String	Generic Edit	10	0	Allow NULL?
103	QHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
104	QHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
105	QHUPMJ	Date - Updated	Date	Generic Edit	6	0
106	QHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
107	QHTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 75I | F75I701 INDEXES

Number

Description

UKID (Primary/Unique)

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

UK02 YPMT

Element	Alias	Description	Sequence
1	UK02	Unique Key ID 02 (Internal)	Ascending
2	YPMT	Per Metric Ton	Ascending

UK01

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

YRTN GPSP

Element	Alias	Description	Sequence
1	YRTN	IGM / Rotation Number	Ascending
2	GPSP	Processed Flag	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

107 COLUMNS | 4 INDEXES | 920 | 75I | F75I701 TABLE

TOP 920 | 75I | F75I701 COLUMNS

TOP 920 | 75I | F75I701 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

107 COLUMNS | 4 INDEXES | 920 | 75I | F75I701 TABLE

TOP920 | 75I | F75I701 COLUMNS

TOP920 | 75I | F75I701 INDEXES

TOP 920 | 75I | F75I701 COLUMNS

TOP 920 | 75I | F75I701 INDEXES