	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

83 COLUMNS | 1 INDEXES | 920 | 03B | F03B119 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	920	F03B119	RN	83	1	Revenue Recognition GL Info Audit	Files	03B: Enhanced Accounts Receivable

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 RNKCO, RNDCT, RNDOC, RNDGJ, RNJELN, RNEXTL, RNLT, RNSLNE, RNTORG, RNTXA1, RNTXITM, RNU, RNUM, RNVINV, RNWR01, RNEXR1, RNFY, RNGLC, RNDRR, RNODGJ, RNOJELN, RNOEXTL, RNICU, RNICUT, RNITM, RNIVD, RNLNID, RNMCU, RNOBJ, RNPN, RNPO, RNPSFX, RNPOST, RNR1, RNR2, RNRE, RNSBL, RNSBLT, RNSFX, RNSUB, RNAA, RNABR1, RNABR2, RNABR3, RNABR4, RNABT1, RNABT2, RNABT3, RNABT4, RNACR, RNAID, RNAM, RNAN8, RNANI, RNASID, RNBC, RNBCRC, RNCO, RNCRCD, RNCRR, RNCRRM, RNCTRY, RNDCTO, RNDICJ, RNDSVJ, RNDSYJ, RNEXA, RNUPMJ, RNUPMT, RNUSER, RNJOBN, RNPID, RNAAR, RNAARE, RNAARN, RNRRC, RNFAAR, RNFAARE, RNCH7, RNFAARN, RNRRCOGS, RNDJ7, RNEXR FROM F03B119

TOP 920 | 03B | F03B119 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	RNKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
2	RNDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
3	RNDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
4	RNDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
5	RNJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
6	RNEXTL	Line Extension Code	String	Generic Edit	2	0	Allow NULL?
7	RNLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
8	RNSLNE	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
9	RNTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
10	RNTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
11	RNTXITM	Tax - Short Item Number	Numeric	Generic Edit	8	0	Allow NULL?
12	RNU	Units	Numeric	Generic Edit	15	2	Allow NULL?
13	RNUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
14	RNVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
15	RNWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
16	RNEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
17	RNFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
18	RNGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
19	RNDRR	Revenue Recognition Date	Date	Generic Edit	6	0
20	RNODGJ	Original G/L Date	Date	Generic Edit	6	0
21	RNOJELN	Original Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
22	RNOEXTL	Original Line Extension Code	String	Generic Edit	2	0	Allow NULL?
23	RNICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
24	RNICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
25	RNITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
26	RNIVD	Date - Invoice	Date	Generic Edit	6	0
27	RNLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
28	RNMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
29	RNOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
30	RNPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
31	RNPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
32	RNPSFX	Purchase Order Suffix	String	Generic Edit	3	0	Allow NULL?
33	RNPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
34	RNR1	Reference 1 - JE Voucher Invoice etc.	String	Generic Edit	8	0	Allow NULL?
35	RNR2	Reference 2	String	Generic Edit	8	0	Allow NULL?
36	RNRE	Reverse or Void (R/V)	Character	UDC (H09 RE)	1	0	Allow NULL?
37	RNSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
38	RNSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
39	RNSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
40	RNSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
41	RNAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
42	RNABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
43	RNABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
44	RNABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
45	RNABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
46	RNABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
47	RNABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
48	RNABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
49	RNABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
50	RNACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
51	RNAID	Account ID	String	Generic Edit	8	0	Allow NULL?
52	RNAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
53	RNAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
54	RNANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
55	RNASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
56	RNBC	Bill Code	Character	UDC (98 BC)	1	0	Allow NULL?
57	RNBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
58	RNCO	Company	String	Generic Edit	5	0	Allow NULL?
59	RNCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
60	RNCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
61	RNCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
62	RNCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
63	RNDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
64	RNDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
65	RNDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
66	RNDSYJ	Date - Batch System Date	Date	Generic Edit	6	0
67	RNEXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
68	RNUPMJ	Date - Updated	Date	Generic Edit	6	0
69	RNUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
70	RNUSER	User ID	String	Generic Edit	10	0	Allow NULL?
71	RNJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
72	RNPID	Program ID	String	Generic Edit	10	0	Allow NULL?
73	RNAAR	Recognized Revenue Amount	Numeric	Generic Edit	15	2	Allow NULL?
74	RNAARE	Remaining Amount	Numeric	Generic Edit	15	2	Allow NULL?
75	RNAARN	Amount not Recognized	Numeric	Generic Edit	15	2	Allow NULL?
76	RNRRC	Recognition Reason Code	Character	UDC (03B RR)	1	0	Allow NULL?
77	RNFAAR	Foreign Recognized Revenue Amount	Numeric	Generic Edit	15	2	Allow NULL?
78	RNFAARE	Foreign Remaining Amount	Numeric	Generic Edit	15	2	Allow NULL?
79	RNCH7	Future Use Character	Character	Generic Edit	1	0	Allow NULL?
80	RNFAARN	Foreign Amount not Recognized	Numeric	Generic Edit	15	2	Allow NULL?
81	RNRRCOGS	Revenue Recognition COGS	Character	Generic Edit	1	0	Allow NULL?
82	RNDJ7	Future Use Date	Date	Generic Edit	6	0
83	RNEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?

TOP 920 | 03B | F03B119 INDEXES

Number

Description

Primary (Primary/Unique)

Element	Alias	Description	Sequence
1	KCO	Document Company	Ascending
2	DCT	Document Type	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	DGJ	Date - For G/L (and Voucher) - Julian	Ascending
5	JELN	Journal Entry Line Number	Ascending
6	EXTL	Line Extension Code	Ascending
7	LT	Ledger Types	Ascending
8	SLNE	Line 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

83 COLUMNS | 1 INDEXES | 920 | 03B | F03B119 TABLE

TOP 920 | 03B | F03B119 COLUMNS

TOP 920 | 03B | F03B119 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

83 COLUMNS | 1 INDEXES | 920 | 03B | F03B119 TABLE

TOP920 | 03B | F03B119 COLUMNS

TOP920 | 03B | F03B119 INDEXES

TOP 920 | 03B | F03B119 COLUMNS

TOP 920 | 03B | F03B119 INDEXES