	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

69 COLUMNS | 8 INDEXES | 920 | 07 | F055011W TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	920	F055011W	AD	69	8	Auto Deposit Instructions Work File	Files	07: Payroll

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 ADAN8, ADSSN, ADALPH, ADHMCO, ADTAX, ADSEC, ADSCC, ADPSDT, ADPTDT, ADFPCD, ADPREN, ADDEP1, ADDEP2, ADDEP3, ADDEP4, ADDEP5, ADDEP6, ADUSER, ADPID, ADUPMJ, ADEV01, ADSEQ, ADSEQN2, ADBDM, ADBDM2, ADFOA#, ADFOA#2, ADOFO#, ADIFO#, ADTCOD, ADGPAY, ADEV02, ADSEQN3, ADSEQN4, ADBDM3, ADBDM4, ADFOA#3, ADFOA#4, ADOFO#2, ADIFO#2, ADTCOD2, ADGPAY2, ADEV03, ADSEQN5, ADSEQN6, ADBDM5, ADBDM6, ADFOA#5, ADFOA#6, ADOFO#3, ADIFO#3, ADTCOD3, ADGPAY3, ADEV04, ADSEQN7, ADSEQN8, ADBDM7, ADBDM8, ADFOA#7, ADFOA#8, ADOFO#4, ADIFO#4, ADTCOD4, ADGPAY4, ADDL30, ADFPCD2, ADFPCD3, ADFPCD4, ADFPCD5 FROM F055011W

TOP 920 | 07 | F055011W COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ADAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
2	ADSSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
3	ADALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
4	ADHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
5	ADTAX	Tax ID	String	Generic Edit	20	0	Allow NULL?
6	ADSEC	Standard Entry Class	String	UDC (07 SE)	3	0	Allow NULL?
7	ADSCC	Service Class Code	String	UDC (07 SI)	3	0	Allow NULL?
8	ADPSDT	Date - Pay Starts	Date	Generic Edit	6	0
9	ADPTDT	Date - Pay Stops	Date	Generic Edit	6	0
10	ADFPCD	Full/Partial Code	Character	UDC (07 FP)	1	0	Allow NULL?
11	ADPREN	Pre Notification Code	String	UDC (07 NT)	2	0	Allow NULL?
12	ADDEP1	Deduction Period 1	Character	UDC (05A DD)	1	0	Allow NULL?
13	ADDEP2	Deduction Period 2	Character	UDC (05A DD)	1	0	Allow NULL?
14	ADDEP3	Deduction Period 3	Character	UDC (05A DD)	1	0	Allow NULL?
15	ADDEP4	Deduction Period 4	Character	UDC (05A DD)	1	0	Allow NULL?
16	ADDEP5	Deduction Period 5	Character	UDC (05A DD)	1	0	Allow NULL?
17	ADDEP6	Deduction Period 6	Character	UDC (05A DD)	1	0	Allow NULL?
18	ADUSER	User ID	String	Generic Edit	10	0	Allow NULL?
19	ADPID	Program ID	String	Generic Edit	10	0	Allow NULL?
20	ADUPMJ	Date - Updated	Date	Generic Edit	6	0
21	ADEV01	J.D. EnterpriseOne Event Point 01	Character	Generic Edit	1	0	Allow NULL?
22	ADSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
23	ADSEQN2	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
24	ADBDM	Method Code - Bank Deposits	Character	UDC (07 MC)	1	0	Allow NULL?
25	ADBDM2	Method Code - Bank Deposits	Character	UDC (07 MC)	1	0	Allow NULL?
26	ADFOA#	Financial Organization Account Number	String	Generic Edit	17	0	Allow NULL?
27	ADFOA#2	Financial Organization Account Number	String	Generic Edit	17	0	Allow NULL?
28	ADOFO#	Originating Financial Organization No.	String	UDC (06 BC)	9	0	Allow NULL?
29	ADIFO#	Individuals Financial Organization No.	String	UDC (06 BC)	9	0	Allow NULL?
30	ADTCOD	Transaction Code	String	UDC (06 AD)	2	0	Allow NULL?
31	ADGPAY	Amount - Gross Pay	Numeric	Generic Edit	15	2	Allow NULL?
32	ADEV02	J.D. EnterpriseOne Event Point 02	Character	Generic Edit	1	0	Allow NULL?
33	ADSEQN3	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
34	ADSEQN4	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
35	ADBDM3	Method Code - Bank Deposits	Character	UDC (07 MC)	1	0	Allow NULL?
36	ADBDM4	Method Code - Bank Deposits	Character	UDC (07 MC)	1	0	Allow NULL?
37	ADFOA#3	Financial Organization Account Number	String	Generic Edit	17	0	Allow NULL?
38	ADFOA#4	Financial Organization Account Number	String	Generic Edit	17	0	Allow NULL?
39	ADOFO#2	Originating Financial Organization No.	String	UDC (06 BC)	9	0	Allow NULL?
40	ADIFO#2	Individuals Financial Organization No.	String	Generic Edit	9	0	Allow NULL?
41	ADTCOD2	Transaction Code	String	UDC (06 AD)	2	0	Allow NULL?
42	ADGPAY2	Amount - Gross Pay	Numeric	Generic Edit	15	2	Allow NULL?
43	ADEV03	J.D. EnterpriseOne Point 03	Character	Generic Edit	1	0	Allow NULL?
44	ADSEQN5	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
45	ADSEQN6	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
46	ADBDM5	Method Code - Bank Deposits	Character	UDC (07 MC)	1	0	Allow NULL?
47	ADBDM6	Method Code - Bank Deposits	Character	UDC (07 MC)	1	0	Allow NULL?
48	ADFOA#5	Financial Organization Account Number	String	Generic Edit	17	0	Allow NULL?
49	ADFOA#6	Financial Organization Account Number	String	Generic Edit	17	0	Allow NULL?
50	ADOFO#3	Originating Financial Organization No.	String	UDC (06 BC)	9	0	Allow NULL?
51	ADIFO#3	Individuals Financial Organization No.	String	UDC (06 BC)	9	0	Allow NULL?
52	ADTCOD3	Transaction Code	String	UDC (06 AD)	2	0	Allow NULL?
53	ADGPAY3	Amount - Gross Pay	Numeric	Generic Edit	15	2	Allow NULL?
54	ADEV04	EnterpriseOne Point 04	Character	Generic Edit	1	0	Allow NULL?
55	ADSEQN7	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
56	ADSEQN8	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
57	ADBDM7	Method Code - Bank Deposits	Character	UDC (07 MC)	1	0	Allow NULL?
58	ADBDM8	Method Code - Bank Deposits	Character	UDC (07 MC)	1	0	Allow NULL?
59	ADFOA#7	Financial Organization Account Number	String	Generic Edit	17	0	Allow NULL?
60	ADFOA#8	Financial Organization Account Number	String	Generic Edit	17	0	Allow NULL?
61	ADOFO#4	Originating Financial Organization No.	String	UDC (06 BC)	9	0	Allow NULL?
62	ADIFO#4	Individuals Financial Organization No.	String	UDC (06 BC)	9	0	Allow NULL?
63	ADTCOD4	Transaction Code	String	UDC (06 AD)	2	0	Allow NULL?
64	ADGPAY4	Amount - Gross Pay	Numeric	Generic Edit	15	2	Allow NULL?
65	ADDL30	Description 30	String	Generic Edit	30	0	Allow NULL?
66	ADFPCD2	Full/Partial Code	Character	UDC (07 FP)	1	0	Allow NULL?
67	ADFPCD3	Full/Partial Code	Character	UDC (07 FP)	1	0	Allow NULL?
68	ADFPCD4	Full/Partial Code	Character	UDC (07 FP)	1	0	Allow NULL?
69	ADFPCD5	Full/Partial Code	Character	UDC (07 FP)	1	0	Allow NULL?

TOP 920 | 07 | F055011W INDEXES

Number

Description

Address No (Primary/Unique)

Element	Alias	Description	Sequence
1	ALPH	Name - Alpha	Ascending
2	AN8	Address Number	Ascending

Emp Details

Element	Alias	Description	Sequence
1	SSN	Employee Tax ID	Ascending
2	HMCO	Company - Home	Ascending
3	TAX	Tax ID	Ascending
4	SEC	Standard Entry Class	Ascending
5	SCC	Service Class Code	Ascending
6	PSDT	Date - Pay Starts	Ascending
7	PTDT	Date - Pay Stops	Ascending
8	FPCD	Full/Partial Code	Ascending
9	PREN	Pre Notification Code	Ascending
10	DEP1	Deduction Period 1	Ascending
11	DEP2	Deduction Period 2	Ascending
12	DEP3	Deduction Period 3	Ascending
13	DEP4	Deduction Period 4	Ascending
14	DEP5	Deduction Period 5	Ascending
15	DEP6	Deduction Period 6	Ascending

Audit Fields

Element	Alias	Description	Sequence
1	USER	User ID	Ascending
2	PID	Program ID	Ascending
3	UPMJ	Date - Updated	Ascending

Set 1

Element	Alias	Description	Sequence
1	EV01	J.D. EnterpriseOne Event Point 01	Ascending
2	SEQ	Sequence Number	Ascending
3	SEQN2	Sequence Number	Ascending
4	BDM	Method Code - Bank Deposits	Ascending
5	BDM2	Method Code - Bank Deposits	Ascending
6	FOA#	Financial Organization Account Number	Ascending
7	FOA#2	Financial Organization Account Number	Ascending
8	OFO#	Originating Financial Organization No.	Ascending
9	IFO#	Individuals Financial Organization No.	Ascending
10	TCOD	Transaction Code	Ascending
11	GPAY	Amount - Gross Pay	Ascending

Set 2

Element	Alias	Description	Sequence
1	EV02	J.D. EnterpriseOne Event Point 02	Ascending
2	SEQN3	Sequence Number	Ascending
3	SEQN4	Sequence Number	Ascending
4	BDM3	Method Code - Bank Deposits	Ascending
5	BDM4	Method Code - Bank Deposits	Ascending
6	FOA#3	Financial Organization Account Number	Ascending
7	FOA#4	Financial Organization Account Number	Ascending
8	OFO#2	Originating Financial Organization No.	Ascending
9	IFO#2	Individuals Financial Organization No.	Ascending
10	TCOD2	Transaction Code	Ascending
11	GPAY2	Amount - Gross Pay	Ascending

Set 3

Element	Alias	Description	Sequence
1	EV03	J.D. EnterpriseOne Point 03	Ascending
2	SEQN5	Sequence Number	Ascending
3	SEQN6	Sequence Number	Ascending
4	BDM5	Method Code - Bank Deposits	Ascending
5	BDM6	Method Code - Bank Deposits	Ascending
6	FOA#5	Financial Organization Account Number	Ascending
7	FOA#6	Financial Organization Account Number	Ascending
8	OFO#3	Originating Financial Organization No.	Ascending
9	IFO#3	Individuals Financial Organization No.	Ascending
10	TCOD3	Transaction Code	Ascending
11	GPAY3	Amount - Gross Pay	Ascending

Set 4

Element	Alias	Description	Sequence
1	EV04	EnterpriseOne Point 04	Ascending
2	SEQN7	Sequence Number	Ascending
3	SEQN8	Sequence Number	Ascending
4	BDM7	Method Code - Bank Deposits	Ascending
5	BDM8	Method Code - Bank Deposits	Ascending
6	FOA#7	Financial Organization Account Number	Ascending
7	FOA#8	Financial Organization Account Number	Ascending
8	OFO#4	Originating Financial Organization No.	Ascending
9	IFO#4	Individuals Financial Organization No.	Ascending
10	TCOD4	Transaction Code	Ascending
11	GPAY4	Amount - Gross Pay	Ascending

Set 5

Element	Alias	Description	Sequence
1	DL30	Description 30	Ascending
2	FPCD2	Full/Partial Code	Ascending
3	FPCD3	Full/Partial Code	Ascending
4	FPCD4	Full/Partial Code	Ascending
5	FPCD5	Full/Partial Code	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

69 COLUMNS | 8 INDEXES | 920 | 07 | F055011W TABLE

TOP 920 | 07 | F055011W COLUMNS

TOP 920 | 07 | F055011W 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

69 COLUMNS | 8 INDEXES | 920 | 07 | F055011W TABLE

TOP920 | 07 | F055011W COLUMNS

TOP920 | 07 | F055011W INDEXES

TOP 920 | 07 | F055011W COLUMNS

TOP 920 | 07 | F055011W INDEXES