	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

70 COLUMNS | 2 INDEXES | 920 | 07 | F05290 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
07: Payroll
1	920	F05290	JR	70	2	WF - Payroll Journal (Detail)	Extra Features Files	07: Payroll	Business Data

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 JRPOST, JRUSER, JRANI, JRCTRY, JRFY, JRCO, JRLT, JRSBL, JRAM, JRR1, JRR2, JRDCT, JRAN8, JRASID, JRDGJ, JRPN, JREXA, JREXR, JRAA, JRU, JRJELN, JRMCU, JROBJ, JRSUB, JRSBLT, JRWR01, JRJBCD, JRJBST, JRHMCU, JRCRCD, JRCRR, JRPID, JRUPMJ, JRKCO, JRICU, JROLND, JRPDBA, JRPRJE, JRACR, JRCRDC, JRCRRM, JRLDED, JREPGC, JRJPGC, JRPJRDT01, JRPJRDT02, JRPJRDT03, JRPJRMN01, JRPJRMN02, JRPJRMN03, JRPJRMN04, JRPJRST01, JRPJRST02, JRPJRST03, JRPJRST04, JRPJRST05, JRPJRST06, JRPJRCH01, JRPJRCH02, JRPJRCH03, JRPJRCH04, JRACTB, JRABR1, JRABR2, JRABR3, JRABR4, JRABT1, JRABT2, JRABT3, JRABT4 FROM F05290

TOP 920 | 07 | F05290 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	JRPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
2	JRUSER	User ID	String	Generic Edit	10	0	Allow NULL?
3	JRANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
4	JRCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
5	JRFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
6	JRCO	Company	String	Generic Edit	5	0	Allow NULL?
7	JRLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
8	JRSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
9	JRAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
10	JRR1	Reference 1 - JE Voucher Invoice etc.	String	Generic Edit	8	0	Allow NULL?
11	JRR2	Reference 2	String	Generic Edit	8	0	Allow NULL?
12	JRDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
13	JRAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
14	JRASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
15	JRDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
16	JRPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
17	JREXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
18	JREXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
19	JRAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
20	JRU	Units	Numeric	Generic Edit	15	2	Allow NULL?
21	JRJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
22	JRMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
23	JROBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
24	JRSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
25	JRSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
26	JRWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
27	JRJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
28	JRJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
29	JRHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
30	JRCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
31	JRCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
32	JRPID	Program ID	String	Generic Edit	10	0	Allow NULL?
33	JRUPMJ	Date - Updated	Date	Generic Edit	6	0
34	JRKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
35	JRICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
36	JROLND	Line Number - Overall Report	Numeric	Generic Edit	15	2	Allow NULL?
37	JRPDBA	DBA Code	Numeric	Generic Edit	5	0	Allow NULL?
38	JRPRJE	Code - Payroll Journal Error	String	UDC	2	0	Allow NULL?
39	JRACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
40	JRCRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
41	JRCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
42	JRLDED	Labor Period Ending Date	Date	Generic Edit	6	0
43	JREPGC	Employee Pool Grouping Code	String	UDC (00 12)	3	0	Allow NULL?
44	JRJPGC	Job Pool Grouping Code	String	UDC (00 12)	3	0	Allow NULL?
45	JRPJRDT01	Payroll Journal Generic Date 01	Date	Generic Edit	6	0
46	JRPJRDT02	Payroll Journal Generic Date 02	Date	Generic Edit	6	0
47	JRPJRDT03	Payroll Journal Generic Date 03	Date	Generic Edit	6	0
48	JRPJRMN01	Journal Entry Payroll Transaction Number	Numeric	Generic Edit	15	2	Allow NULL?
49	JRPJRMN02	Payroll Journal Generic Math Numeric 02	Numeric	Generic Edit	15	2	Allow NULL?
50	JRPJRMN03	Payroll Journal Generic Math Numeric 03	Numeric	Generic Edit	15	2	Allow NULL?
51	JRPJRMN04	Payroll Journal Generic Math Numeric 04	Numeric	Generic Edit	15	2	Allow NULL?
52	JRPJRST01	Recharge Currency Code Sequencer	String	Generic Edit	10	0	Allow NULL?
53	JRPJRST02	Payroll Journal Generic String 02	String	Generic Edit	10	0	Allow NULL?
54	JRPJRST03	Payroll Journal Generic String 03	String	Generic Edit	10	0	Allow NULL?
55	JRPJRST04	Payroll Journal Generic String 04	String	Generic Edit	10	0	Allow NULL?
56	JRPJRST05	Payroll Journal Generic String 05	String	Generic Edit	20	0	Allow NULL?
57	JRPJRST06	Payroll Journal Generic String 06	String	Generic Edit	20	0	Allow NULL?
58	JRPJRCH01	Payroll Journal Generic Character 01	Character	Generic Edit	1	0	Allow NULL?
59	JRPJRCH02	Payroll Journal Generic Character 02	Character	Generic Edit	1	0	Allow NULL?
60	JRPJRCH03	Payroll Journal Generic Character 03	Character	Generic Edit	1	0	Allow NULL?
61	JRPJRCH04	Payroll Journal Generic Character 04	Character	Generic Edit	1	0	Allow NULL?
62	JRACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
63	JRABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
64	JRABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
65	JRABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
66	JRABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
67	JRABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
68	JRABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
69	JRABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
70	JRABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?

TOP 920 | 07 | F05290 INDEXES

Number

Description

Batch Number Line Number (Primary/Unique)

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	OLND	Line Number - Overall Report	Ascending

Batch Co Ctry FY PN Dct Prje

Element	Alias	Description	Sequence
1	ICU	Batch Number	Ascending
2	CO	Company	Ascending
3	CTRY	Century	Ascending
4	FY	Fiscal Year	Ascending
5	PN	Period Number - General Ledger	Ascending
6	DCT	Document Type	Ascending
7	PRJE	Code - Payroll Journal Error	Ascending
8	OLND	Line Number - Overall Report	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

70 COLUMNS | 2 INDEXES | 920 | 07 | F05290 TABLE

TOP 920 | 07 | F05290 COLUMNS

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

70 COLUMNS | 2 INDEXES | 920 | 07 | F05290 TABLE

TOP920 | 07 | F05290 COLUMNS

TOP920 | 07 | F05290 INDEXES

TOP 920 | 07 | F05290 COLUMNS

TOP 920 | 07 | F05290 INDEXES