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
06: Payroll (old) - Obsolete-do not reuse
1	812	F06210	YD	81	3	Payroll Cycle Parameters	Work Files	06: Payroll (old) - Obsolete-do not reuse	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	YDPRID	Payroll ID	Numeric	Generic Edit	5	0	Allow NULL?
2	YDVERS	Version History	String	Generic Edit	10	0	Allow NULL?
3	YDPCCD	Pay Cycle Code	String	UDC (06 PY)	5	0	Allow NULL?
4	YDDTEY	Date - YR	Numeric	Generic Edit	2	0	Allow NULL?
5	YDCO	Company	String	Generic Edit	5	0	Allow NULL?
6	YDPPED	Date - Pay Period Ending	Date	Generic Edit	6	0
7	YDPCTC	Pay Categories/DBA Print Group	Character	UDC (06 ST)	1	0	Allow NULL?
8	YDJCTY	Payroll Expense Type	Character	UDC (07 PJ)	1	0	Allow NULL?
9	YDEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
10	YDEFTE	Date - Ending Effective	Date	Generic Edit	6	0
11	YDCKDT	Date - Pay Check	Date	Generic Edit	6	0
12	YDAGDT	Date - Payroll Journals	Date	Generic Edit	6	0
13	YDGLBA	G/L Bank Account	String	Generic Edit	8	0	Allow NULL?
14	YDCYGR	Pay Cycle Group Code	String	UDC (06 PG)	2	0	Allow NULL?
15	YDWHRW	Standard Hours-Weekly	Numeric	Generic Edit	9	2	Allow NULL?
16	YDBHRW	Standard Hours-Biweekly	Numeric	Generic Edit	9	2	Allow NULL?
17	YDSHRW	Standard Hours-Semi	Numeric	Generic Edit	9	2	Allow NULL?
18	YDMHRW	Standard Hours-Monthly	Numeric	Generic Edit	9	2	Allow NULL?
19	YDAHRW	Standard Hours-Annually	Numeric	Generic Edit	9	2	Allow NULL?
20	YDOHRW	Standard Hours-Other	Numeric	Generic Edit	9	2	Allow NULL?
21	YDPPM1	Pay Period Number - Weekly	Character	UDC (05 PN)	1	0	Allow NULL?
22	YDPPM2	Pay Period Number - Biweekly	Character	UDC (05 PN)	1	0	Allow NULL?
23	YDPPM3	Pay Period Number - Semimonthly	Character	UDC (05 PN)	1	0	Allow NULL?
24	YDPPM4	Pay Period Number - Monthly	Character	UDC (05 PN)	1	0	Allow NULL?
25	YDPPM5	Pay Period Number - Annually	Character	UDC (05 PN)	1	0	Allow NULL?
26	YDPPM6	Pay Period Number - Other	Character	UDC (05 PN)	1	0	Allow NULL?
27	YDACCF	Rate - Accrual Factor	Numeric	Generic Edit	9	4	Allow NULL?
28	YDVER1	Version 1	String	Generic Edit	10	0	Allow NULL?
29	YDVER2	Version 2	String	Generic Edit	10	0	Allow NULL?
30	YDVER3	Version 3	String	Generic Edit	10	0	Allow NULL?
31	YDVER4	Version 4	String	Generic Edit	10	0	Allow NULL?
32	YDVER5	Version 5	String	Generic Edit	10	0	Allow NULL?
33	YDVER6	Fiscal & Anniv. Rollover	String	Generic Edit	10	0	Allow NULL?
34	YDVER7	Version 7	String	Generic Edit	10	0	Allow NULL?
35	YDVER8	Version 8	String	Generic Edit	10	0	Allow NULL?
36	YDVER9	Payroll Voucher Batch 2	String	Generic Edit	10	0	Allow NULL?
37	YDSEQC	Sequence Code	Character	UDC (07 SR)	1	0	Allow NULL?
38	YDNMAX	Amount - Maximum Net Pay	Numeric	Generic Edit	15	2	Allow NULL?
39	YDPPST	Status - Pre payroll Processing	Character	UDC (07 PP)	1	0	Allow NULL?
40	YDCKST	Status - Print Payroll Checks	Character	UDC (07 CK)	1	0	Allow NULL?
41	YDJEST	Status - Payroll Journal Entries	Character	UDC (07 JE)	1	0	Allow NULL?
42	YDROST	Status - Reports Only	Character	UDC	1	0	Allow NULL?
43	YDFUST	Status - Final Update	Character	UDC (07 FV)	1	0	Allow NULL?
44	YDYST1	Status- Payroll 01	Character	UDC (07 YS)	1	0	Allow NULL?
45	YDYST2	Status- Payroll 02	Character	UDC	1	0	Allow NULL?
46	YDYST3	Status- Payroll 03	Character	UDC	1	0	Allow NULL?
47	YDICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
48	YDDNMN	Denomination Minimum	Numeric	Generic Edit	7	2	Allow NULL?
49	YDPYDT	Date - Pay Cycle Processed	Date	Generic Edit	6	0
50	YDPCCT	Pay Cycle Count	Numeric	Generic Edit	2	0	Allow NULL?
51	YDPPMB	Pay Period Number	Character	UDC (05 YB)	1	0	Allow NULL?
52	YDRNUM	Number of Reports to Run	Numeric	Generic Edit	3	0	Allow NULL?
53	YDPYMH	Method - Employee Payment	Character	UDC	1	0	Allow NULL?
54	YDMANB	Mandatory Benefit Flag	Character	UDC (05 YN)	1	0	Allow NULL?
55	YDCCPR	Country Code	String	UDC (00 CN)	3	0	Allow NULL?
56	YDDL02	Description 02	String	Generic Edit	30	0	Allow NULL?
57	YDADOF	Auto Deposit Override Flag	Character	UDC (05 YN)	1	0	Allow NULL?
58	YDMNAF	Minimum Check Adjustment Flag	Character	UDC	1	0	Allow NULL?
59	YDADRF	Auto Deposit Reconcilation Flag	Character	UDC (05 YN)	1	0	Allow NULL?
60	YDARST	Wage Attachment Invoice Date	Character	UDC (07 WI)	1	0	Allow NULL?
61	YDPEF1	Execution Flag 1	Character	Generic Edit	1	0	Allow NULL?
62	YDPEF2	Execution Flag 2	Character	Generic Edit	1	0	Allow NULL?
63	YDPEF3	Execution Flag 3	Character	Generic Edit	1	0	Allow NULL?
64	YDPEF4	Execution Flag 4	Character	Generic Edit	1	0	Allow NULL?
65	YDPEF5	Execution Flag 5	Character	Generic Edit	1	0	Allow NULL?
66	YDPCGT	Pay Cycle Group Type	Character	UDC (07 PH)	1	0	Allow NULL?
67	YDCKPF	Check Stock Processing Flag	Character	UDC (05 YN)	1	0	Allow NULL?
68	YDASF	Accelerated Submission Flag	Character	UDC (05 YN)	1	0	Allow NULL?
69	YDCCUF	Step Progression Automation	Character	UDC (07 JP)	1	0	Allow NULL?
70	YDWCUF	Workers Comp. Update Flag	Character	UDC (05 YN)	1	0	Allow NULL?
71	YDADEF	Status - Auto Deposit Processing	Character	UDC	1	0	Allow NULL?
72	YDADDT	Date - Auto Deposit	Date	Generic Edit	6	0
73	YDADPC	Type Process - Auto Deposit	Character	Generic Edit	1	0	Allow NULL?
74	YDADPO	Pre-Note Option Code	Character	UDC (05 YN)	1	0	Allow NULL?
75	YDGPOR	Code - Group Plan Override	Character	UDC (05 YN)	1	0	Allow NULL?
76	YDELCT	Code - Employee Lockout Control	Character	UDC (05 YN)	1	0	Allow NULL?
77	YDACUS	Active Users	Numeric	Generic Edit	3	0	Allow NULL?
78	YDODBA	Optional DBA Processing Flag	Character	UDC (05 YN)	1	0	Allow NULL?
79	YDVICU	Payroll Voucher Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
80	YDDTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
81	YDUSER	User ID	String	Generic Edit	10	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

81 COLUMNS | 3 INDEXES | 812 | 06 | F06210 TABLE

TOP 812 | 06 | F06210 COLUMNS

TOP 812 | 06 | F06210 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

81 COLUMNS | 3 INDEXES | 812 | 06 | F06210 TABLE

TOP812 | 06 | F06210 COLUMNS

TOP812 | 06 | F06210 INDEXES

TOP 812 | 06 | F06210 COLUMNS

TOP 812 | 06 | F06210 INDEXES