	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

95 COLUMNS | 15 INDEXES | 920 | 01 | F0101 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
01: Address Book
1	920	F0101	AB	95	15	Address Book Master	Master Files	01: Address Book

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 ABAN8, ABALKY, ABTAX, ABALPH, ABDC, ABMCU, ABSIC, ABLNGP, ABAT1, ABCM, ABTAXC, ABAT2, ABAT3, ABAT4, ABAT5, ABATP, ABATR, ABATPR, ABAB3, ABATE, ABSBLI, ABEFTB, ABAN81, ABAN82, ABAN83, ABAN84, ABAN86, ABAN85, ABAC01, ABAC02, ABAC03, ABAC04, ABAC05, ABAC06, ABAC07, ABAC08, ABAC09, ABAC10, ABAC11, ABAC12, ABAC13, ABAC14, ABAC15, ABAC16, ABAC17, ABAC18, ABAC19, ABAC20, ABAC21, ABAC22, ABAC23, ABAC24, ABAC25, ABAC26, ABAC27, ABAC28, ABAC29, ABAC30, ABGLBA, ABPTI, ABPDI, ABMSGA, ABRMK, ABTXCT, ABTX2, ABALP1, ABURCD, ABURDT, ABURAT, ABURAB, ABURRF, ABUSER, ABPID, ABUPMJ, ABJOBN, ABUPMT, ABPRGF, ABSCCLTP, ABTICKER, ABEXCHG, ABDUNS, ABCLASS01, ABCLASS02, ABCLASS03, ABCLASS04, ABCLASS05, ABNOE, ABGROWTHR, ABYEARSTAR, ABAEMPGP, ABACTIN, ABREVRNG, ABSYNCS, ABPERRS, ABCAAD FROM F0101

TOP 920 | 01 | F0101 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ABAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
2	ABALKY	Long Address Number	String	Generic Edit	20	0	Allow NULL?
3	ABTAX	Tax ID	String	Generic Edit	20	0	Allow NULL?
4	ABALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
5	ABDC	Description - Compressed	String	Generic Edit	40	0	Allow NULL?
6	ABMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
7	ABSIC	Industry Classification Code	String	UDC (01 SC)	10	0	Allow NULL?
8	ABLNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
9	ABAT1	Search Type	String	UDC (01 ST)	3	0	Allow NULL?
10	ABCM	Credit Message	String	UDC (00 CM)	2	0	Allow NULL?
11	ABTAXC	Person/Corporation Code	Character	UDC (H00 TA)	1	0	Allow NULL?
12	ABAT2	AR/AP Netting Indicator	Character	UDC (H01 AV)	1	0	Allow NULL?
13	ABAT3	HRM Records Exist	Character	UDC (H01 AV)	1	0	Allow NULL?
14	ABAT4	Address Type - 4	Character	UDC (H01 AV)	1	0	Allow NULL?
15	ABAT5	Address Type - 5	Character	UDC (H01 AV)	1	0	Allow NULL?
16	ABATP	Address Type - Payables	Character	UDC (H01 AS)	1	0	Allow NULL?
17	ABATR	Address Type - Receivables	Character	UDC (H01 AR)	1	0	Allow NULL?
18	ABATPR	Address Type - Code Purchaser	Character	Generic Edit	1	0	Allow NULL?
19	ABAB3	Address Book - MiscellaneousCode(future)	Character	UDC (01 EP)	1	0	Allow NULL?
20	ABATE	Address Type - Employee	Character	UDC (H01 AR)	1	0	Allow NULL?
21	ABSBLI	Subledger Inactive Code	Character	UDC (00 SI)	1	0	Allow NULL?
22	ABEFTB	Date - Beginning Effective	Date	Generic Edit	6	0
23	ABAN81	Address Number - 1st	Numeric	Generic Edit	8	0	Allow NULL?
24	ABAN82	Address Number - 2nd	Numeric	Generic Edit	8	0	Allow NULL?
25	ABAN83	Address Number - 3rd	Numeric	Generic Edit	8	0	Allow NULL?
26	ABAN84	Address Number - 4th	Numeric	Generic Edit	8	0	Allow NULL?
27	ABAN86	Address Number - 5th	Numeric	Generic Edit	8	0	Allow NULL?
28	ABAN85	Factor/Special Payee	Numeric	Generic Edit	8	0	Allow NULL?
29	ABAC01	Category Code - Address Book 01	String	UDC (01 01)	3	0	Allow NULL?
30	ABAC02	Category Code - Address Book 02	String	UDC (01 02)	3	0	Allow NULL?
31	ABAC03	Category Code - Address Book 03	String	UDC (01 03)	3	0	Allow NULL?
32	ABAC04	Category Code - Address Book 04	String	UDC (01 04)	3	0	Allow NULL?
33	ABAC05	Category Code - Address Book 05	String	UDC (01 05)	3	0	Allow NULL?
34	ABAC06	Category Code - Address Book 06	String	UDC (01 06)	3	0	Allow NULL?
35	ABAC07	Category Code - Address Book 07	String	UDC (01 07)	3	0	Allow NULL?
36	ABAC08	Category Code - Address Book 08	String	UDC (01 08)	3	0	Allow NULL?
37	ABAC09	Category Code - Address Book 09	String	UDC (01 09)	3	0	Allow NULL?
38	ABAC10	Category Code - Address Book 10	String	UDC (01 10)	3	0	Allow NULL?
39	ABAC11	Sales Region	String	UDC (01 11)	3	0	Allow NULL?
40	ABAC12	Category Code - Address Book 12	String	UDC (01 12)	3	0	Allow NULL?
41	ABAC13	Category Code - Address Book 13	String	UDC (01 13)	3	0	Allow NULL?
42	ABAC14	Category Code - Address Book 14	String	UDC (01 14)	3	0	Allow NULL?
43	ABAC15	Category Code - Address Book 15	String	UDC (01 15)	3	0	Allow NULL?
44	ABAC16	Category Code - Address Book 16	String	UDC (01 16)	3	0	Allow NULL?
45	ABAC17	Category Code - Address Book 17	String	UDC (01 17)	3	0	Allow NULL?
46	ABAC18	Category Code - Address Book 18	String	UDC (01 18)	3	0	Allow NULL?
47	ABAC19	Category Code - Address Book 19	String	UDC (01 19)	3	0	Allow NULL?
48	ABAC20	Category Code - Address Book 20	String	UDC (01 20)	3	0	Allow NULL?
49	ABAC21	Category Code - Address Book 21	String	UDC (01 21)	3	0	Allow NULL?
50	ABAC22	Category Code - Address Book 22	String	UDC (01 22)	3	0	Allow NULL?
51	ABAC23	Category Code - Address Book 23	String	UDC (01 23)	3	0	Allow NULL?
52	ABAC24	Category Code - Address Book 24	String	UDC (01 24)	3	0	Allow NULL?
53	ABAC25	Category Code - Address Book 25	String	UDC (01 25)	3	0	Allow NULL?
54	ABAC26	Category Code - Address Book 26	String	UDC (01 26)	3	0	Allow NULL?
55	ABAC27	Category Code - Address Book 27	String	UDC (01 27)	3	0	Allow NULL?
56	ABAC28	Category Code - Address Book 28	String	UDC (01 28)	3	0	Allow NULL?
57	ABAC29	Category Code - Address Book 29	String	UDC (01 29)	3	0	Allow NULL?
58	ABAC30	Category Code - Address Book 30	String	UDC (01 30)	3	0	Allow NULL?
59	ABGLBA	G/L Bank Account	String	Generic Edit	8	0	Allow NULL?
60	ABPTI	Time - Scheduled In	Numeric	Generic Edit	6	0	Allow NULL?
61	ABPDI	Date - Scheduled In	Date	Generic Edit	6	0
62	ABMSGA	Action - Message Control	Character	UDC (H01 MR)	1	0	Allow NULL?
63	ABRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
64	ABTXCT	Certificate Tax Exemption	String	Generic Edit	20	0	Allow NULL?
65	ABTX2	Tax ID - Additional - Individual	String	Generic Edit	20	0	Allow NULL?
66	ABALP1	Secondary Alpha Name	String	Generic Edit	40	0	Allow NULL?
67	ABURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
68	ABURDT	User Reserved Date	Date	Generic Edit	6	0
69	ABURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
70	ABURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
71	ABURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
72	ABUSER	User ID	String	Generic Edit	10	0	Allow NULL?
73	ABPID	Program ID	String	Generic Edit	10	0	Allow NULL?
74	ABUPMJ	Date - Updated	Date	Generic Edit	6	0
75	ABJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
76	ABUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
77	ABPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
78	ABSCCLTP	Shortcut Client Type (future)	String	UDC (98 CL)	2	0	Allow NULL?
79	ABTICKER	Ticker	String	Generic Edit	10	0	Allow NULL?
80	ABEXCHG	Stock Exchange	String	Generic Edit	10	0	Allow NULL?
81	ABDUNS	DUNS Number	String	Generic Edit	13	0	Allow NULL?
82	ABCLASS01	Classification Code 01	String	UDC (01 CA)	3	0	Allow NULL?
83	ABCLASS02	Classification Code 02	String	UDC (01 CB)	3	0	Allow NULL?
84	ABCLASS03	Classification Code 03	String	UDC (01 CC)	3	0	Allow NULL?
85	ABCLASS04	Classification Code 04	String	UDC (01 CD)	3	0	Allow NULL?
86	ABCLASS05	Classification Code 05	String	UDC (01 CE)	3	0	Allow NULL?
87	ABNOE	Number Of Employee	Numeric	Generic Edit	15	0	Allow NULL?
88	ABGROWTHR	Growth Rate	Numeric	Generic Edit	8	0	Allow NULL?
89	ABYEARSTAR	Year Started	String	Generic Edit	15	0	Allow NULL?
90	ABAEMPGP	Employee Group Approvals	String	UDC (43E AA)	5	0	Allow NULL?
91	ABACTIN	Future Use Indicator	Character	Generic Edit	1	0	Allow NULL?
92	ABREVRNG	Revenue range	String	UDC (01 RR)	5	0	Allow NULL?
93	ABSYNCS	Synchronization Status	Numeric	UDC (90CA SY)	2	0	Allow NULL?
94	ABPERRS	Previous Error Status	Numeric	UDC (90CA SS)	2	0	Allow NULL?
95	ABCAAD	Server Status	Numeric	UDC (90CA SE)	2	0	Allow NULL?

TOP 920 | 01 | F0101 INDEXES

Number

Description

Address # (Primary/Unique)

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

Compressed Description

Element	Alias	Description	Sequence
1	DC	Description - Compressed	Ascending

Long Address Number

Element	Alias	Description	Sequence
1	ALKY	Long Address Number	Ascending

Tax Id

Element	Alias	Description	Sequence
1	TAX	Tax ID	Ascending

Address Type 1 Desc Compresse

Element	Alias	Description	Sequence
1	AT1	Search Type	Ascending
2	DC	Description - Compressed	Ascending

Reportin Codes 1n4 Desc Compr

Element	Alias	Description	Sequence
1	AC01	Category Code - Address Book 01	Ascending
2	AC04	Category Code - Address Book 04	Ascending
3	DC	Description - Compressed	Ascending

Reporting Codes 1n3 Desc Comp

Element	Alias	Description	Sequence
1	AC01	Category Code - Address Book 01	Ascending
2	AC03	Category Code - Address Book 03	Ascending
3	DC	Description - Compressed	Ascending

Reporting Codes 1n2 Desc Comp

Element	Alias	Description	Sequence
1	AC01	Category Code - Address Book 01	Ascending
2	AC02	Category Code - Address Book 02	Ascending
3	DC	Description - Compressed	Ascending

Reporting Code 1 Desc Comp.

Element	Alias	Description	Sequence
1	AC01	Category Code - Address Book 01	Ascending
2	DC	Description - Compressed	Ascending

Add Type 1 Rpt Cde 1n4 DC

Element	Alias	Description	Sequence
1	AT1	Search Type	Ascending
2	AC01	Category Code - Address Book 01	Ascending
3	AC04	Category Code - Address Book 04	Ascending
4	DC	Description - Compressed	Ascending

Add Type 1 Rpt Cde 1n3 DC

Element	Alias	Description	Sequence
1	AT1	Search Type	Ascending
2	AC01	Category Code - Address Book 01	Ascending
3	AC03	Category Code - Address Book 03	Ascending
4	DC	Description - Compressed	Ascending

Add Type 1 Rpt Cde 1n2 DC

Element	Alias	Description	Sequence
1	AT1	Search Type	Ascending
2	AC01	Category Code - Address Book 01	Ascending
3	AC02	Category Code - Address Book 02	Ascending
4	DC	Description - Compressed	Ascending

Add Type 1 Rpt Cde 1 Desc Com

Element	Alias	Description	Sequence
1	AT1	Search Type	Ascending
2	AC01	Category Code - Address Book 01	Ascending
3	DC	Description - Compressed	Ascending

Address No Tax Id2

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending
2	TX2	Tax ID - Additional - Individual	Ascending

Name Alpha

Element	Alias	Description	Sequence
1	ALPH	Name - Alpha	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

95 COLUMNS | 15 INDEXES | 920 | 01 | F0101 TABLE

TOP 920 | 01 | F0101 COLUMNS

TOP 920 | 01 | F0101 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

95 COLUMNS | 15 INDEXES | 920 | 01 | F0101 TABLE

TOP920 | 01 | F0101 COLUMNS

TOP920 | 01 | F0101 INDEXES

TOP 920 | 01 | F0101 COLUMNS

TOP 920 | 01 | F0101 INDEXES