	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

82 COLUMNS | 5 INDEXES | 920 | 03B | F03B117 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
03B: Enhanced Accounts Receivable
1	920	F03B117	RL	82	5	Revenue Recognition GL Info	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 RLKCO, RLDCT, RLDOC, RLDGJ, RLJELN, RLEXTL, RLDRR, RLODGJ, RLOJELN, RLOEXTL, RLICU, RLICUT, RLDICJ, RLDSYJ, RLCO, RLMCU, RLOBJ, RLSUB, RLSBL, RLSBLT, RLTORG, RLTXA1, RLTXITM, RLU, RLUM, RLVINV, RLWR01, RLEXR1, RLFY, RLGLC, RLITM, RLIVD, RLLNID, RLLT, RLPN, RLPO, RLPOST, RLPSFX, RLR1, RLR2, RLRE, RLSFX, RLAA, RLABR1, RLABR2, RLABR3, RLABR4, RLABT1, RLABT2, RLABT3, RLABT4, RLACR, RLAID, RLAM, RLAN8, RLANI, RLASID, RLBC, RLBCRC, RLCRCD, RLCRR, RLCRRM, RLCTRY, RLDCTO, RLDSVJ, RLEXA, RLUPMJ, RLUPMT, RLUSER, RLJOBN, RLPID, RLAAR, RLAARE, RLAARN, RLRRC, RLFAAR, RLFAARE, RLFAARN, RLEXR, RLRRCOGS, RLCH7, RLDJ7 FROM F03B117

TOP 920 | 03B | F03B117 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	RLKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
2	RLDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
3	RLDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
4	RLDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
5	RLJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
6	RLEXTL	Line Extension Code	String	Generic Edit	2	0	Allow NULL?
7	RLDRR	Revenue Recognition Date	Date	Generic Edit	6	0
8	RLODGJ	Original G/L Date	Date	Generic Edit	6	0
9	RLOJELN	Original Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
10	RLOEXTL	Original Line Extension Code	String	Generic Edit	2	0	Allow NULL?
11	RLICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
12	RLICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
13	RLDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
14	RLDSYJ	Date - Batch System Date	Date	Generic Edit	6	0
15	RLCO	Company	String	Generic Edit	5	0	Allow NULL?
16	RLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
17	RLOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
18	RLSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
19	RLSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
20	RLSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
21	RLTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
22	RLTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
23	RLTXITM	Tax - Short Item Number	Numeric	Generic Edit	8	0	Allow NULL?
24	RLU	Units	Numeric	Generic Edit	15	2	Allow NULL?
25	RLUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
26	RLVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
27	RLWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
28	RLEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
29	RLFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
30	RLGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
31	RLITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
32	RLIVD	Date - Invoice	Date	Generic Edit	6	0
33	RLLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
34	RLLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
35	RLPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
36	RLPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
37	RLPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
38	RLPSFX	Purchase Order Suffix	String	Generic Edit	3	0	Allow NULL?
39	RLR1	Reference 1 - JE Voucher Invoice etc.	String	Generic Edit	8	0	Allow NULL?
40	RLR2	Reference 2	String	Generic Edit	8	0	Allow NULL?
41	RLRE	Reverse or Void (R/V)	Character	UDC (H09 RE)	1	0	Allow NULL?
42	RLSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
43	RLAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
44	RLABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
45	RLABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
46	RLABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
47	RLABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
48	RLABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
49	RLABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
50	RLABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
51	RLABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
52	RLACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
53	RLAID	Account ID	String	Generic Edit	8	0	Allow NULL?
54	RLAM	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
55	RLAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
56	RLANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
57	RLASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
58	RLBC	Bill Code	Character	UDC (98 BC)	1	0	Allow NULL?
59	RLBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
60	RLCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
61	RLCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
62	RLCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
63	RLCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
64	RLDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
65	RLDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
66	RLEXA	Name - Alpha Explanation	String	Generic Edit	30	0	Allow NULL?
67	RLUPMJ	Date - Updated	Date	Generic Edit	6	0
68	RLUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
69	RLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
70	RLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
71	RLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
72	RLAAR	Recognized Revenue Amount	Numeric	Generic Edit	15	2	Allow NULL?
73	RLAARE	Remaining Amount	Numeric	Generic Edit	15	2	Allow NULL?
74	RLAARN	Amount not Recognized	Numeric	Generic Edit	15	2	Allow NULL?
75	RLRRC	Recognition Reason Code	Character	UDC (03B RR)	1	0	Allow NULL?
76	RLFAAR	Foreign Recognized Revenue Amount	Numeric	Generic Edit	15	2	Allow NULL?
77	RLFAARE	Foreign Remaining Amount	Numeric	Generic Edit	15	2	Allow NULL?
78	RLFAARN	Foreign Amount not Recognized	Numeric	Generic Edit	15	2	Allow NULL?
79	RLEXR	Name - Remark Explanation	String	Generic Edit	30	0	Allow NULL?
80	RLRRCOGS	Revenue Recognition COGS	Character	Generic Edit	1	0	Allow NULL?
81	RLCH7	Future Use Character	Character	Generic Edit	1	0	Allow NULL?
82	RLDJ7	Future Use Date	Date	Generic Edit	6	0

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

Sec Index

Element	Alias	Description	Sequence
1	KCO	Document Company	Ascending
2	DCT	Document Type	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	LT	Ledger Types	Ascending

Account ID

Element	Alias	Description	Sequence
1	AID	Account ID	Ascending

Sec Index1

Element	Alias	Description	Sequence
1	KCO	Document Company	Ascending
2	DCT	Document Type	Ascending
3	DOC	Document (Voucher Invoice etc.)	Ascending
4	ODGJ	Original G/L Date	Ascending
5	OJELN	Original Journal Entry Line Number	Ascending
6	OEXTL	Original Line Extension Code	Ascending

Cogs Index

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	RRCOGS	Revenue Recognition COGS	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

82 COLUMNS | 5 INDEXES | 920 | 03B | F03B117 TABLE

TOP 920 | 03B | F03B117 COLUMNS

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

82 COLUMNS | 5 INDEXES | 920 | 03B | F03B117 TABLE

TOP920 | 03B | F03B117 COLUMNS

TOP920 | 03B | F03B117 INDEXES

TOP 920 | 03B | F03B117 COLUMNS

TOP 920 | 03B | F03B117 INDEXES