	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

86 COLUMNS | 6 INDEXES | 910 | 09E | F20112 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
09E: Expense Reimbursment
1	910	F20112	ED	86	6	Expense Report Detail	Transaction Files	09E: Expense Reimbursment

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 EDEXRPTTYP, EDEXRPTNUM, EDEMPLOYID, EDWRKSTNID, EDLIN, EDDTECRT, EDEXPTYPE, EDEXPDATE, EDEXPDAMT, EDEXPFAMT, EDPMTMETH, EDCHRGTO, EDBUSPURP, EDADDLCMT, EDEXPSTAT, EDCRCD, EDREIMCRCY, EDCACTION, EDRCPTLBL, EDERRREAS, EDHOTELCH, EDNUMNITES, EDHOTELLOC, EDCRCRDNUM, EDTICKNUM, EDTICKSTA, EDCARVEND, EDMILESDR, EDMILERT, EDTRIPDES, EDNUMCOEMP, EDNUMNCOEM, EDSCHLNAM, EDCRSNUM, EDCRSTITL, EDFCLTYNM, EDBENFTPD, EDTXR1, EDTXA1, EDFNLGRD, EDNUMERIC1, EDNUMERIC2, EDNUMERIC3, EDTEXT1, EDTEXT2, EDTEXT3, EDDATE1, EDDATE2, EDDATE3, EDMCU0, EDRECTYPE, EDLNID, EDCRR, EDEXR1, EDLOCATN, EDBILLBLE, EDALTVEND, EDPREFSUPP, EDSBL, EDSBLT, EDAIRLINE, EDRCND, EDTYDA, EDREIMAMT, EDUNITS, EDRATE1, EDPOLICYEX, EDCO, EDCRDC, EDCCTN, EDRECSRC, EDCCAN8, EDREF2, EDREF3, EDREFDTE, EDREFDTE2, EDAPPRID, EDUSER, EDPID, EDJOBN, EDUPMJ, EDUPMT, EDTAPDA, EDPDIEMCAT, EDGOVTAMT, EDGOVTUAMT FROM F20112

TOP 910 | 09E | F20112 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	EDEXRPTTYP	Expense Report Type	Character	UDC (09E RT)	1	0	Allow NULL?
2	EDEXRPTNUM	Expense Report Number	String	Generic Edit	10	0	Allow NULL?
3	EDEMPLOYID	Employee ID	Numeric	Generic Edit	8	0	Allow NULL?
4	EDWRKSTNID	Original Work Station ID	String	Generic Edit	10	0	Allow NULL?
5	EDLIN	Line Number - General	Numeric	Generic Edit	7	2	Allow NULL?
6	EDDTECRT	Date Created	Date	Generic Edit	6	0
7	EDEXPTYPE	Expense Category	String	UDC (09E EC)	4	0	Allow NULL?
8	EDEXPDATE	Expense Date	Date	Generic Edit	6	0
9	EDEXPDAMT	Reimbursement Amount	Numeric	Generic Edit	15	2	Allow NULL?
10	EDEXPFAMT	Expense Amount	Numeric	Generic Edit	15	2	Allow NULL?
11	EDPMTMETH	Payment Method	String	UDC (09E PM)	3	0	Allow NULL?
12	EDCHRGTO	Charge To	String	UDC (09E CT)	30	0	Allow NULL?
13	EDBUSPURP	Business Purpose	String	Generic Edit	40	0	Allow NULL?
14	EDADDLCMT	Additional Comments	String	Generic Edit	60	0	Allow NULL?
15	EDEXPSTAT	Expense Status	String	UDC (09E ES)	2	0	Allow NULL?
16	EDCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
17	EDREIMCRCY	Reimbursement Currency	String	Generic Edit	3	0	Allow NULL?
18	EDCACTION	CourseOfAction	String	Generic Edit	2	0	Allow NULL?
19	EDRCPTLBL	Receipt Label	Numeric	Generic Edit	3	0	Allow NULL?
20	EDERRREAS	Error Reason	String	Generic Edit	2	0	Allow NULL?
21	EDHOTELCH	Hotel Chain	String	UDC (09E PH)	8	0	Allow NULL?
22	EDNUMNITES	Number of Nights	Numeric	Generic Edit	3	0	Allow NULL?
23	EDHOTELLOC	Hotel Location	String	Generic Edit	25	0	Allow NULL?
24	EDCRCRDNUM	Credit Card Number	String	Generic Edit	25	0	Allow NULL?
25	EDTICKNUM	Airline Ticket Number	String	Generic Edit	15	0	Allow NULL?
26	EDTICKSTA	Airline Ticket Status	String	UDC (09E TS)	3	0	Allow NULL?
27	EDCARVEND	Car Rental Vendor	String	UDC (09E PC)	8	0	Allow NULL?
28	EDMILESDR	Miles Driven	Numeric	Generic Edit	15	2	Allow NULL?
29	EDMILERT	Mile Rate	Numeric	Generic Edit	15	2	Allow NULL?
30	EDTRIPDES	Trip Description	String	Generic Edit	25	2	Allow NULL?
31	EDNUMCOEMP	Number of Company Guests	Numeric	Generic Edit	5	0	Allow NULL?
32	EDNUMNCOEM	Number of Non Company Guests	Numeric	Generic Edit	5	0	Allow NULL?
33	EDSCHLNAM	School Name	String	Generic Edit	25	0	Allow NULL?
34	EDCRSNUM	Course Number	String	Generic Edit	10	0	Allow NULL?
35	EDCRSTITL	Course Title	String	Generic Edit	30	0	Allow NULL?
36	EDFCLTYNM	Facility Name	String	Generic Edit	25	0	Allow NULL?
37	EDBENFTPD	Benefit Period	Character	Generic Edit	1	0	Allow NULL?
38	EDTXR1	Tax Rate 1	Numeric	Generic Edit	7	3	Allow NULL?
39	EDTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
40	EDFNLGRD	Final Grade	String	Generic Edit	2	0	Allow NULL?
41	EDNUMERIC1	Numeric 01	Numeric	Generic Edit	15	2	Allow NULL?
42	EDNUMERIC2	Numeric 02	Numeric	Generic Edit	15	2	Allow NULL?
43	EDNUMERIC3	Numeric 03	Numeric	Generic Edit	15	2	Allow NULL?
44	EDTEXT1	Text Field	String	Generic Edit	40	0	Allow NULL?
45	EDTEXT2	Text Field	String	Generic Edit	40	0	Allow NULL?
46	EDTEXT3	Text Field	String	Generic Edit	40	0	Allow NULL?
47	EDDATE1	Date Field	Date	Generic Edit	6	0
48	EDDATE2	Date Field	Date	Generic Edit	6	0
49	EDDATE3	Date Field	Date	Generic Edit	6	0
50	EDMCU0	Business Unit	String	Generic Edit	12	0	Allow NULL?
51	EDRECTYPE	Record Type	Character	Generic Edit	1	0	Allow NULL?
52	EDLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
53	EDCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
54	EDEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
55	EDLOCATN	Location	String	UDC (09E EL)	10	0	Allow NULL?
56	EDBILLBLE	Billable	Character	Generic Edit	1	0	Allow NULL?
57	EDALTVEND	Alternate Vendor	String	Generic Edit	15	0	Allow NULL?
58	EDPREFSUPP	Preferred Supplier	String	UDC (09E PS)	8	0	Allow NULL?
59	EDSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
60	EDSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
61	EDAIRLINE	Airline	String	UDC (09E PA)	8	0	Allow NULL?
62	EDRCND	Reconciled Code	Character	UDC (09 RC)	1	0	Allow NULL?
63	EDTYDA	Type Data	String	Generic Edit	2	0	Allow NULL?
64	EDREIMAMT	Reimbursable Amount	Numeric	Generic Edit	15	2	Allow NULL?
65	EDUNITS	Units	Numeric	Generic Edit	6	2	Allow NULL?
66	EDRATE1	Rate	Numeric	Generic Edit	15	3	Allow NULL?
67	EDPOLICYEX	Policy Exception	String	Generic Edit	3	0	Allow NULL?
68	EDCO	Company	String	Generic Edit	5	0	Allow NULL?
69	EDCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
70	EDCCTN	Credit Card Transaction Number	String	Generic Edit	20	0	Allow NULL?
71	EDRECSRC	Record Source	Character	Generic Edit	1	0	Allow NULL?
72	EDCCAN8	Credit Card Address Number	Numeric	Generic Edit	8	0	Allow NULL?
73	EDREF2	Reference Numeric	Numeric	Generic Edit	15	2	Allow NULL?
74	EDREF3	Reference	String	Generic Edit	15	0	Allow NULL?
75	EDREFDTE	Reference Date	Date	Generic Edit	6	0
76	EDREFDTE2	Reference Date	Date	Generic Edit	6	0
77	EDAPPRID	Approver ID	Numeric	Generic Edit	8	0	Allow NULL?
78	EDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
79	EDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
80	EDJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
81	EDUPMJ	Date - Updated	Date	Generic Edit	6	0
82	EDUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
83	EDTAPDA	Total Available Per Diem Amount	Numeric	Generic Edit	15	2	Allow NULL?
84	EDPDIEMCAT	Per Diem Expense Category	String	UDC (09E EC)	4	0	Allow NULL?
85	EDGOVTAMT	Allowable Amount	Numeric	Generic Edit	15	2	Allow NULL?
86	EDGOVTUAMT	Unallowable Amount	Numeric	Generic Edit	15	2	Allow NULL?

TOP 910 | 09E | F20112 INDEXES

Number

Description

F20112_1 (Primary/Unique)

Element	Alias	Description	Sequence
1	EXRPTTYP	Expense Report Type	Ascending
2	EXRPTNUM	Expense Report Number	Ascending
3	EMPLOYID	Employee ID	Ascending
4	WRKSTNID	Original Work Station ID	Ascending
5	DTECRT	Date Created	Ascending
6	LIN	Line Number - General	Ascending
7	RECTYPE	Record Type	Ascending
8	LNID	Line Number	Ascending

F20112_2

Element	Alias	Description	Sequence
1	PMTMETH	Payment Method	Ascending
2	CRCD	Currency Code - From	Ascending

F20112_3

Element	Alias	Description	Sequence
1	EXPDATE	Expense Date	Ascending

F20112_4

Element	Alias	Description	Sequence
1	MCU0	Business Unit	Ascending
2	SBL	Subledger - G/L	Ascending
3	CRCD	Currency Code - From	Ascending
4	LIN	Line Number - General	Ascending

F20112_5

Element	Alias	Description	Sequence
1	EXRPTTYP	Expense Report Type	Ascending
2	EXRPTNUM	Expense Report Number	Ascending
3	EMPLOYID	Employee ID	Ascending
4	WRKSTNID	Original Work Station ID	Ascending
5	DTECRT	Date Created	Ascending
6	RECTYPE	Record Type	Ascending
7	LIN	Line Number - General	Descending
8	LNID	Line Number	Descending

F20112_6

Element	Alias	Description	Sequence
1	CCTN	Credit Card Transaction Number	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

86 COLUMNS | 6 INDEXES | 910 | 09E | F20112 TABLE

TOP 910 | 09E | F20112 COLUMNS

TOP 910 | 09E | F20112 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

86 COLUMNS | 6 INDEXES | 910 | 09E | F20112 TABLE

TOP910 | 09E | F20112 COLUMNS

TOP910 | 09E | F20112 INDEXES

TOP 910 | 09E | F20112 COLUMNS

TOP 910 | 09E | F20112 INDEXES