920: Top 10 requests

	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

910: Top 10 requests

	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

812: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
52G: Proj & Gov Contract Accounting
1	920	F4822H	IH	113	1	Invoice Summary History	History Files	52G: Proj & Gov Contract Accounting

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	IHDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	IHDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	IHKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	IHPCTN	Parent Contract Number	Numeric	Generic Edit	8	0	Allow NULL?
5	IHPCTT	Parent Contract Type	String	UDC (00 DT)	2	0	Allow NULL?
6	IHPCKO	Parent Contract Document Company	String	Generic Edit	5	0	Allow NULL?
7	IHAPPL	Application Number	Numeric	Generic Edit	5	0	Allow NULL?
8	IHADJN	Adjustment Number	Numeric	Generic Edit	3	0	Allow NULL?
9	IHCOCH	Contract Change Number	String	Generic Edit	3	0	Allow NULL?
10	IHLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
11	IHOPIM	Owner Pay Item	String	Generic Edit	15	0	Allow NULL?
12	IHPRTP	Pricing Type - Contracts	Character	UDC (52 PT)	1	0	Allow NULL?
13	IHBLSP	Bill Suspend	Character	UDC (52 BS)	1	0	Allow NULL?
14	IHAN8O	Address Number - Job A/R	Numeric	Generic Edit	8	0	Allow NULL?
15	IHAN8J	Address Number - Alternate Payee	Numeric	Generic Edit	8	0	Allow NULL?
16	IHPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
17	IHCO	Company	String	Generic Edit	5	0	Allow NULL?
18	IHMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
19	IHSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
20	IHSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
21	IHGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
22	IHBTFR	Date - Bill From	Date	Generic Edit	6	0
23	IHBTDT	Billed Through	Date	Generic Edit	6	0
24	IHDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
25	IHDDJ	Date - Net Due	Date	Generic Edit	6	0
26	IHDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
27	IHICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
28	IHDOCZ	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
29	IHDCTI	Document Type - Invoice Only	String	UDC (00 DI)	2	0	Allow NULL?
30	IHKCOI	Document Company (Invoice)	String	Generic Edit	5	0	Allow NULL?
31	IHSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
32	IHAPDT	Application Date	Date	Generic Edit	6	0
33	IHAPPO	Application Posted Code	Character	Generic Edit	1	0	Allow NULL?
34	IHVOID	Void (V)	Character	UDC (H09 VO)	1	0	Allow NULL?
35	IHINVF	Invoice Format Code	String	Generic Edit	10	0	Allow NULL?
36	IHINTY	Invoice Type	Character	UDC (48 IT)	1	0	Allow NULL?
37	IHU	Units	Numeric	Generic Edit	15	2	Allow NULL?
38	IHUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
39	IHUP	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
40	IHFUP	Amount - Foreign Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
41	IHPUHP	Previous Billed This Period - Units	Numeric	Generic Edit	15	2	Allow NULL?
42	IHAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
43	IHACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
44	IHTHPD	This Period	Numeric	Generic Edit	15	2	Allow NULL?
45	IHFHPD	This Period - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
46	IHRTHP	This Period - Restated	Numeric	Generic Edit	15	2	Allow NULL?
47	IHPTHP	Previous Billed This Period	Numeric	Generic Edit	15	2	Allow NULL?
48	IHFTHP	Previous Billed This Period - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
49	IHTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
50	IHEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
51	IHSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
52	IHCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
53	IHPTAM	Amount - Tax - Prior	Numeric	Generic Edit	15	2	Allow NULL?
54	IHFPTA	Amount - Tax - Prior - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
55	IHATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
56	IHCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
57	IHPATX	Amount - Taxable - Previous	Numeric	Generic Edit	15	2	Allow NULL?
58	IHFATX	Amount - Taxable - Previous Foreign	Numeric	Generic Edit	15	2	Allow NULL?
59	IHATXN	Amount - Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
60	IHCTXN	Amount - Foreign Non-Taxable	Numeric	Generic Edit	15	2	Allow NULL?
61	IHRTRE	Retainage Release Only	Character	UDC (48 RR)	1	0	Allow NULL?
62	IHRGLC	Retention G/L Offset	String	Generic Edit	4	0	Allow NULL?
63	IHPRET	Percent Retainage	Numeric	Generic Edit	5	2	Allow NULL?
64	IHRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
65	IHRCTL	Retainage Control Flag	Character	UDC (48S RC)	1	0	Allow NULL?
66	IHRTNG	Retainage	Numeric	Generic Edit	15	2	Allow NULL?
67	IHFTNG	Retainage - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
68	IHRTNP	Retainage - Prior	Numeric	Generic Edit	15	2	Allow NULL?
69	IHFTNP	Retainage - Prior - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
70	IHDDTR	Deferred Tax - Domestic	Numeric	Generic Edit	15	2	Allow NULL?
71	IHFDTR	Deferred Tax - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
72	IHSTML	Accrual/Deferral (Stored Materials)	Numeric	Generic Edit	15	2	Allow NULL?
73	IHFTML	Acc/Def (Stored Materials) - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
74	IHPSMA	Previous Billed Stored Material	Numeric	Generic Edit	15	2	Allow NULL?
75	IHFSMA	Prev. Billed Stored Material - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
76	IHRTN1	Retainage Rule - Stored Material	String	Generic Edit	3	0	Allow NULL?
77	IHSMRT	Stored Materials Retainage	Numeric	Generic Edit	15	2	Allow NULL?
78	IHSMRF	Stored Materials Retainage - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
79	IHSMRP	Stored Materials Retainage - Prior Amt	Numeric	Generic Edit	15	2	Allow NULL?
80	IHSMPF	Stored Materials Retainage - Prior-For	Numeric	Generic Edit	15	2	Allow NULL?
81	IHTLAB	Amount - Total Labor	Numeric	Generic Edit	15	2	Allow NULL?
82	IHFLAB	Amount - Foreign Total Labor	Numeric	Generic Edit	15	2	Allow NULL?
83	IHTBUR	Amount - Total Burden	Numeric	Generic Edit	15	2	Allow NULL?
84	IHFBUR	Amount - Foreign Total Burden	Numeric	Generic Edit	15	2	Allow NULL?
85	IHADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
86	IHCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
87	IHCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
88	IHCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
89	IHCRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
90	IHCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
91	IHCRRD	Currency Conversion Rate - Divisor	Numeric	Generic Edit	15	0	Allow NULL?
92	IHRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
93	IHMIVL	Mode of Input - Values	Character	Generic Edit	1	0	Allow NULL?
94	IHMISM	Mode of Input - SM	Character	Generic Edit	1	0	Allow NULL?
95	IHPID	Program ID	String	Generic Edit	10	0	Allow NULL?
96	IHJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
97	IHUSER	User ID	String	Generic Edit	10	0	Allow NULL?
98	IHMUPM	Date - Updated	Date	Generic Edit	6	0
99	IHUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
100	IHVGCSF	GeoCode Ship From	String	Generic Edit	10	0	Allow NULL?
101	IHVGCOA	GeoCode Order Accept	String	Generic Edit	10	0	Allow NULL?
102	IHVVTY	Vertex Transaction Type	String	UDC (73 TY)	6	0	Allow NULL?
103	IHVVTC	Vertex Product Category	String	UDC (73 PC)	10	0	Allow NULL?
104	IHPYWP	Pay When Paid	Character	Generic Edit	1	0	Allow NULL?
105	IHDTIPTF	Date - Invoice (Inv Lvl) Print From	Date	Generic Edit	6	0
106	IHDTIPTT	Date - Invoice (Inv Lvl) Print Thru	Date	Generic Edit	6	0
107	IHDTFPTF	Date - Invoice (Fnd Lvl) Print From	Date	Generic Edit	6	0
108	IHDTFPTT	Date - Invoice (FndLvl) Print Thru	Date	Generic Edit	6	0
109	IHCLNU	Contract Level Number	Numeric	Generic Edit	8	0	Allow NULL?
110	IHCLTT	Contract Level Type	String	UDC (00 DT)	2	0	Allow NULL?
111	IHCLKO	Contract Level Company	String	Generic Edit	5	0	Allow NULL?
112	IHGCSC	Advanced Contract Structure Chg	Character	Generic Edit	1	0	Allow NULL?
113	IHUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?

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 | 1 INDEXES | 920 | 52G | F4822H TABLE

TOP 920 | 52G | F4822H COLUMNS

TOP 920 | 52G | F4822H 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 | 1 INDEXES | 920 | 52G | F4822H TABLE

TOP920 | 52G | F4822H COLUMNS

TOP920 | 52G | F4822H INDEXES

TOP 920 | 52G | F4822H COLUMNS

TOP 920 | 52G | F4822H INDEXES