920: Top 10 requests

	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

910: Top 10 requests

	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

812: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
34A: Advanced Planning & Scheduling
1	812	F34A40	N0	62	1	APS Integration Group Setup Table	Constants Files	34A: Advanced Planning & Scheduling	Business Data

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	N0SY	Product Code	String	UDC (98 SY)	4	Allow NULL?
2	N0MMCU	Branch	String	Generic Edit	12	Allow NULL?
3	N0SRP1	Sales Rpt 01 - Product Family	String	UDC (41 S1)	3	Allow NULL?
4	N0SRP2	Sales Rpt 02 - Family Section	String	UDC (41 S2)	3	Allow NULL?
5	N0SRP3	Sales Category Code 3	String	UDC (41 S3)	3	Allow NULL?
6	N0SRP4	Sales Category Code 4	String	UDC (41 S4)	3	Allow NULL?
7	N0SRP5	Sales Category Code 5	String	UDC (41 S5)	3	Allow NULL?
8	N0SRP6	Sales Rpt 06 - Product Line (Revenue)	String	UDC (41 06)	6	Allow NULL?
9	N0SRP7	Category Code 7	String	UDC (41 07)	6	Allow NULL?
10	N0SRP8	Sales Rpt 08 - Product Discount Group	String	UDC (41 08)	6	Allow NULL?
11	N0SRP9	Category Code 9	String	UDC (41 09)	6	Allow NULL?
12	N0SRP0	Category Code 10	String	UDC (41 10)	6	Allow NULL?
13	N0PRP1	Commodity Class	String	UDC (41 P1)	3	Allow NULL?
14	N0PRP2	Commodity Sub Class	String	UDC (41 P2)	3	Allow NULL?
15	N0PRP3	Supplier Rebate Code	String	UDC (41 P3)	3	Allow NULL?
16	N0PRP4	Master Planning Family	String	UDC (41 P4)	3	Allow NULL?
17	N0PRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	Allow NULL?
18	N0PRP6	Group - Item Dimension	String	UDC (41 01)	6	Allow NULL?
19	N0PRP7	Group - Warehouse Process 1	String	UDC (41 02)	6	Allow NULL?
20	N0PRP8	Group - Warehouse Process 2	String	UDC (41 02)	6	Allow NULL?
21	N0PRP9	Group - Warehouse Process 3	String	UDC (41 02)	6	Allow NULL?
22	N0PRP0	Item Pool	String	UDC (41 05)	6	Allow NULL?
23	N0CARP	Preferred Carrier - Purchasing	Numeric	Generic Edit	8	Allow NULL?
24	N0CARS	Carrier Number	Numeric	Generic Edit	8	Allow NULL?
25	N0SHCN	Shipping Conditions Code	String	UDC (41 C)	3	Allow NULL?
26	N0SHCM	Shipping Commodity Class	String	UDC (41 E)	3	Allow NULL?
27	N0CYCL	Cycle Count Category	String	UDC (41 8)	3	Allow NULL?
28	N0RP01	Division	String	UDC (00 01)	3	Allow NULL?
29	N0RP02	Region	String	UDC (00 02)	3	Allow NULL?
30	N0RP03	Group	String	UDC (00 03)	3	Allow NULL?
31	N0RP04	Branch Office	String	UDC (00 04)	3	Allow NULL?
32	N0RP05	Department Type	String	UDC (00 05)	3	Allow NULL?
33	N0RP06	Person Responsible	String	UDC (00 06)	3	Allow NULL?
34	N0RP07	Line of Business	String	UDC (00 07)	3	Allow NULL?
35	N0RP08	Category Code - Business Unit 08	String	UDC (00 08)	3	Allow NULL?
36	N0RP09	Category Code - Business Unit 09	String	UDC (00 09)	3	Allow NULL?
37	N0RP10	Category Code - Business Unit 10	String	UDC (00 10)	3	Allow NULL?
38	N0RP11	Category Code - Business Unit 11	String	UDC (00 11)	3	Allow NULL?
39	N0RP12	Category Code - Business Unit 12	String	UDC (00 12)	3	Allow NULL?
40	N0RP13	Category Code - Business Unit 13	String	UDC (00 13)	3	Allow NULL?
41	N0RP14	Category Code - Business Unit 14	String	UDC (00 14)	3	Allow NULL?
42	N0RP15	Category Code - Business Unit 15	String	UDC (00 15)	3	Allow NULL?
43	N0RP16	Category Code - Business Unit 16	String	UDC (00 16)	3	Allow NULL?
44	N0RP17	Category Code - Business Unit 17	String	UDC (00 17)	3	Allow NULL?
45	N0RP18	Category Code - Business Unit 18	String	UDC (00 18)	3	Allow NULL?
46	N0RP19	Category Code - Business Unit 19	String	UDC (00 19)	3	Allow NULL?
47	N0RP20	Category Code - Business Unit 20	String	UDC (00 20)	3	Allow NULL?
48	N0RP21	Category Code - Business Unit 21	String	UDC (00 21)	10	Allow NULL?
49	N0RP22	Category Code - Business Unit 22	String	UDC (00 22)	10	Allow NULL?
50	N0RP23	Category Code - Business Unit 23	String	UDC (00 23)	10	Allow NULL?
51	N0RP24	Category Code - Business Unit 24	String	UDC (00 24)	10	Allow NULL?
52	N0RP25	Category Code - Business Unit 25	String	UDC (00 25)	10	Allow NULL?
53	N0RP26	Category Code - Business Unit 26	String	UDC (00 26)	10	Allow NULL?
54	N0RP27	Category Code - Business Unit 27	String	UDC (00 27)	10	Allow NULL?
55	N0RP28	Category Code - Business Unit 28	String	UDC (00 28)	10	Allow NULL?
56	N0RP29	Category Code - Business Unit 29	String	UDC (00 29)	10	Allow NULL?
57	N0RP30	Category Code - Business Unit 30	String	UDC (00 30)	10	Allow NULL?
58	N0USER	User ID	String	Generic Edit	10	Allow NULL?
59	N0PID	Program ID	String	Generic Edit	10	Allow NULL?
60	N0JOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
61	N0UPMJ	Date - Updated	Date	Generic Edit	6
62	N0TICU	Batch Time	Numeric	Generic Edit	6	Allow NULL?

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

62 COLUMNS | 1 INDEXES | 812 | 34A | F34A40 TABLE

TOP 812 | 34A | F34A40 COLUMNS

TOP 812 | 34A | F34A40 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

62 COLUMNS | 1 INDEXES | 812 | 34A | F34A40 TABLE

TOP812 | 34A | F34A40 COLUMNS

TOP812 | 34A | F34A40 INDEXES

TOP 812 | 34A | F34A40 COLUMNS

TOP 812 | 34A | F34A40 INDEXES