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
08AD: ADP Integration
1	920	F051371	AD	128	1	ADP Employee DBA Instructions	Transaction Files	08AD: ADP Integration	Business Data

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ADCHGF	Change Flag	Character	Generic Edit	1	0	Allow NULL?
2	ADPAYBN	Payroll Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
3	ADAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
4	ADEST	Employment Status	Character	UDC (06 ES)	1	0	Allow NULL?
5	ADMCU3	Business Unit	String	Generic Edit	12	0	Allow NULL?
6	ADPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
7	ADEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
8	ADPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
9	ADDISO	DBA Type	Character	UDC (05 DI)	1	0	Allow NULL?
10	ADPGRP	Deduct/Benefit Override Code	String	Generic Edit	2	0	Allow NULL?
11	ADPSDT	Date - Pay Starts	Date	Generic Edit	6	0
12	ADPTDT	Date - Pay Stops	Date	Generic Edit	6	0
13	ADSFLG	Void Flag (Y/N)	Character	Generic Edit	1	0	Allow NULL?
14	ADDTAB	Table Code	String	Generic Edit	5	0	Allow NULL?
15	ADPB	Source of Pay	Character	UDC (06 PB)	1	0	Allow NULL?
16	ADDESQ	Source of Calculation	Character	UDC (06 DB)	1	0	Allow NULL?
17	ADSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
18	ADAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
19	ADMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
20	ADOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
21	ADSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
22	ADSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
23	ADTARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
24	ADWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
25	ADLMTH	Labor Distribution Method	Character	UDC (07 LT)	1	0	Allow NULL?
26	ADLF	Labor Distribution Multiplier	Numeric	Generic Edit	5	4	Allow NULL?
27	ADPHRW	Hours Worked	Numeric	Generic Edit	9	2	Allow NULL?
28	ADPCUN	Units - Pieces	Numeric	Generic Edit	9	2	Allow NULL?
29	ADUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
30	ADPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
31	ADPPRT	Rate - Piecework	Numeric	Generic Edit	9	3	Allow NULL?
32	ADBHRT	Rate - Base Hourly	Numeric	Generic Edit	9	3	Allow NULL?
33	ADPBRT	Rate - Distribution (or Billing)	Numeric	Generic Edit	9	3	Allow NULL?
34	ADBDRT	Rate - Recharge Burden	Numeric	Generic Edit	9	3	Allow NULL?
35	ADB2RT	Rate - Burden	Numeric	Generic Edit	9	3	Allow NULL?
36	ADRBOB	Burden Obj. Account - Recharge	String	Generic Edit	6	0	Allow NULL?
37	ADRBO2	Burden Obj. Account - Recharge 2	String	Generic Edit	6	0	Allow NULL?
38	ADRTAM	Amount or Rate	Numeric	Generic Edit	9	4	Allow NULL?
39	ADPAYM	Multiplier - Pay Type Multiplier	Numeric	Generic Edit	5	2	Allow NULL?
40	ADSHD	Amount - Shift Differential	Numeric	Generic Edit	9	3	Allow NULL?
41	ADCMTH	Shift Diff Calc Sequence	Character	UDC (07 CO)	1	0	Allow NULL?
42	ADGPA	Amount - Gross Pay	Numeric	Generic Edit	9	2	Allow NULL?
43	ADPPDL	Pay Period Limit	Numeric	Generic Edit	15	2	Allow NULL?
44	ADMDL	Monthly Limit	Numeric	Generic Edit	15	2	Allow NULL?
45	ADADL	Annual Limit	Numeric	Generic Edit	15	2	Allow NULL?
46	ADPPPL	Limit on Pay Period Percent	Numeric	Generic Edit	15	4	Allow NULL?
47	ADNP	Number of Deduction Periods	Numeric	Generic Edit	4	0	Allow NULL?
48	ADAD	Amount - Due	Numeric	Generic Edit	15	2	Allow NULL?
49	ADAI	Type - Sales	Character	UDC	1	0	Allow NULL?
50	ADLD	Percent or Amount	Character	UDC (07 LD)	1	0	Allow NULL?
51	ADSEC$	Security Indicator	Character	Generic Edit	1	0	Allow NULL?
52	ADANN8	Address Number-Provider/Trustee	Numeric	Generic Edit	8	0	Allow NULL?
53	ADDEP1	Deduction Period 1	Character	UDC (05A DD)	1	0	Allow NULL?
54	ADDEP2	Deduction Period 2	Character	UDC (05A DD)	1	0	Allow NULL?
55	ADDEP3	Deduction Period 3	Character	UDC (05A DD)	1	0	Allow NULL?
56	ADDEP4	Deduction Period 4	Character	UDC (05A DD)	1	0	Allow NULL?
57	ADDEP5	Deduction Period 5	Character	UDC (05A DD)	1	0	Allow NULL?
58	ADDEP6	Deduction Period 6	Character	UDC (05A DD)	1	0	Allow NULL?
59	ADP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
60	ADP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
61	ADP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
62	ADP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
63	ADJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
64	ADJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
65	ADHMIN	Hours - Minimum	Numeric	Generic Edit	15	2	Allow NULL?
66	ADHMAX	Hours - Maximum	Numeric	Generic Edit	15	2	Allow NULL?
67	ADWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
68	ADEQCG	Equipment Worked	String	Generic Edit	9	0	Allow NULL?
69	ADEQHR	Hours - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
70	ADERC	Equipment Rate Code	String	UDC (00 RC)	2	0	Allow NULL?
71	ADQOBJ	Equipment Object Account	String	Generic Edit	6	0	Allow NULL?
72	ADEQRT	Billing Rate - Equipment	Numeric	Generic Edit	9	2	Allow NULL?
73	ADPDED	DBA For Prior Limit	Numeric	Generic Edit	5	0	Allow NULL?
74	ADDGRP	Group Limit Code	String	UDC (06 GR)	2	0	Allow NULL?
75	ADDPRI	Order To Adjust Ded	Numeric	Generic Edit	5	0	Allow NULL?
76	ADARRR	Arrearage Method	Character	UDC (05A AR)	1	0	Allow NULL?
77	ADQDL	Quarterly Limit	Numeric	Generic Edit	15	2	Allow NULL?
78	ADDW	Day of the Week	Character	UDC (06 DW)	1	0	Allow NULL?
79	ADPRTR	Transaction No. - Payroll	Numeric	Generic Edit	9	0	Allow NULL?
80	ADSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
81	ADAAF	Vacation Factor	Character	UDC (07 AA)	1	0	Allow NULL?
82	ADDAAF	Deduction Factor	Character	UDC	1	0	Allow NULL?
83	ADUDBA	Include in Union Plan (Y N)	Character	UDC (05 YN)	1	0	Allow NULL?
84	ADACEQ	Accrual Equivalent	Numeric	Generic Edit	5	0	Allow NULL?
85	ADALHR	Hours Worked - Annual Leave	Numeric	Generic Edit	7	2	Allow NULL?
86	ADUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
87	ADAMTS	Amount or Rate - Secondary	Numeric	Generic Edit	15	4	Allow NULL?
88	ADSADL	Annual Limit (Level 2)	Numeric	Generic Edit	15	2	Allow NULL?
89	ADWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
90	ADCOVA	Amount - Coverage	Numeric	Generic Edit	15	2	Allow NULL?
91	ADZOVR	Override Flag	Character	UDC (05 YB)	1	0	Allow NULL?
92	ADCMAX	Inception to Date Limit	Numeric	Generic Edit	9	2	Allow NULL?
93	ADUAMT	Amount - Uprate	Numeric	Generic Edit	9	3	Allow NULL?
94	ADAR1Y	Accrual Rollover - First Year	Character	UDC (07 AU)	1	0	Allow NULL?
95	ADARSY	Accrual Rollover - Subsequent Years	Character	UDC	1	0	Allow NULL?
96	ADRTAB	Rollover Table	String	Generic Edit	5	0	Allow NULL?
97	ADCTAB	Rollover Table -Subsequent Year	String	Generic Edit	5	0	Allow NULL?
98	ADRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
99	ADPCNO	Payroll Control Number	Numeric	Generic Edit	8	0	Allow NULL?
100	ADODBA	Optional DBA Processing Flag	Character	UDC (05 YN)	1	0	Allow NULL?
101	ADGVCH	A/P Voucher (Y N)	Character	UDC (05 YB)	1	0	Allow NULL?
102	ADPLAN	Plan ID	String	Generic Edit	8	0	Allow NULL?
103	ADAOPT	Plan Additional Option	String	Generic Edit	3	0	Allow NULL?
104	ADUSER	User ID	String	Generic Edit	10	0	Allow NULL?
105	ADPID	Program ID	String	Generic Edit	10	0	Allow NULL?
106	ADUPMJ	Date - Updated	Date	Generic Edit	6	0
107	ADPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
108	ADHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
109	ADADP06	ADP User Defined Cat Code - 06	Character	UDC (05 J1)	1	0	Allow NULL?
110	ADADP07	ADP User Defined Cat Code - 07	Character	UDC (05 J2)	1	0	Allow NULL?
111	ADADP08	ADP User Defined Cat Code - 08	Character	UDC (05 J3)	1	0	Allow NULL?
112	ADADP09	ADP User Defined Cat Code - 09	Character	UDC (05 J4)	1	0	Allow NULL?
113	ADADP10	ADP User Defined Cat Code - 10	Character	UDC (05 J5)	1	0	Allow NULL?
114	ADADP16	ADP User Defined Date - 06	Date	Generic Edit	6	0
115	ADADP17	ADP User Defined Date - 07	Date	Generic Edit	6	0
116	ADADP18	ADP User Defined Date - 08	Date	Generic Edit	6	0
117	ADADP19	ADP User Defined Date - 09	Date	Generic Edit	6	0
118	ADADP20	ADP User Defined Date - 10	Date	Generic Edit	6	0
119	ADADP26	ADP User Defined Data - 06	String	Generic Edit	20	0	Allow NULL?
120	ADADP27	ADP User Defined Data - 07	String	Generic Edit	20	0	Allow NULL?
121	ADADP28	ADP User Defined Data - 08	String	Generic Edit	20	0	Allow NULL?
122	ADADP29	ADP User Defined Data - 09	String	Generic Edit	20	0	Allow NULL?
123	ADADP30	ADP User Defined Data - 10	String	Generic Edit	20	0	Allow NULL?
124	ADADP36	ADP User Defined Numeric - 06	Numeric	Generic Edit	15	0	Allow NULL?
125	ADADP37	ADP User Defined Numeric - 07	Numeric	Generic Edit	15	0	Allow NULL?
126	ADADP38	ADP User Defined Numeric - 08	Numeric	Generic Edit	15	0	Allow NULL?
127	ADADP39	ADP User Defined Numeric - 09	Numeric	Generic Edit	15	0	Allow NULL?
128	ADADP40	ADP User Defined Numeric - 10	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

128 COLUMNS | 1 INDEXES | 920 | 08AD | F051371 TABLE

TOP 920 | 08AD | F051371 COLUMNS

TOP 920 | 08AD | F051371 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

128 COLUMNS | 1 INDEXES | 920 | 08AD | F051371 TABLE

TOP920 | 08AD | F051371 COLUMNS

TOP920 | 08AD | F051371 INDEXES

TOP 920 | 08AD | F051371 COLUMNS

TOP 920 | 08AD | F051371 INDEXES