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
90CB: CRM Sales Force Automation
1	920	F90CB010	LD	97	3	Lead Table	Files	90CB: CRM Sales Force Automation

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	LDLEADID	Lead Id	Numeric	Generic Edit	15	0	Allow NULL?
2	LDSRCHTY	Search Type F0005 Drky	String	UDC (01 ST)	10	0	Allow NULL?
3	LDFNAME	First Name	Variable String	Generic Edit	25	0	Allow NULL?
4	LDLNAME	Last Name	Variable String	Generic Edit	25	0	Allow NULL?
5	LDCOMNY	Company	Variable String	Generic Edit	40	0	Allow NULL?
6	LDMDNAM	Middle Name	Variable String	Generic Edit	30	0	Allow NULL?
7	LDCAAN8	Converted Address Number	Numeric	Generic Edit	8	0	Allow NULL?
8	LDTLE	Title	Variable String	Generic Edit	50	0	Allow NULL?
9	LDINDTRY	Industry Drky	String	UDC (01 SC)	10	0	Allow NULL?
10	LDUURL	Url	Variable String	Generic Edit	75	0	Allow NULL?
11	LDLDAR1	Lead Phone Area Code	String	Generic Edit	6	0	Allow NULL?
12	LDLDPH1	Lead Phone Number	String	Generic Edit	20	0	Allow NULL?
13	LDLDFAX	Lead Fax Area Code	String	Generic Edit	6	0	Allow NULL?
14	LDLDFAXN	Lead Fax Number	String	Generic Edit	20	0	Allow NULL?
15	LDEMAIL	Email	Variable String	Generic Edit	75	0	Allow NULL?
16	LDSTAS	Status	Variable String	UDC (90CB ST)	5	0	Allow NULL?
17	LDSTSDES	Status Desc	Variable String	Generic Edit	255	0	Allow NULL?
18	LDEVTID	Event Id	Numeric	Generic Edit	15	0	Allow NULL?
19	LDEMAN8	Employee Address Number	Numeric	Generic Edit	8	0	Allow NULL?
20	LDLEADSRC	Lead Source	Variable String	UDC (90CB LS)	3	0	Allow NULL?
21	LDQUFID	Qualification Id	Numeric	Generic Edit	15	0	Allow NULL?
22	LDQUFSCR	Qualification Score	Numeric	Generic Edit	15	0	Allow NULL?
23	LDDTREC	Date Received	JDE UTime	Generic Edit	11	0
24	LDFUNSCD	Function Code	Variable String	UDC (01 FC)	10	0	Allow NULL?
25	LDCAMPID	Campaign Id	Numeric	Generic Edit	15	0	Allow NULL?
26	LDPMADD	Primary Address Id	Numeric	Generic Edit	15	0	Allow NULL?
27	LDQUFGL	Qualification Goal	Numeric	Generic Edit	9	0	Allow NULL?
28	LDBILLTY	Billing Addr Type F0005 DRKY	String	Generic Edit	10	0	Allow NULL?
29	LDENTDBY	Entered By	Numeric	Generic Edit	8	0	Allow NULL?
30	LDEDATE	Date Entered	JDE UTime	Generic Edit	11	0
31	LDCRMCT01	Category Code01 F0005 Drky	Variable String	UDC (01 01)	10	0	Allow NULL?
32	LDCRMCT02	Category Code02 F0005 Drky	String	UDC (01 02)	10	0	Allow NULL?
33	LDCRMCT03	Category Code03 F0005 Drky	String	UDC (01 03)	10	0	Allow NULL?
34	LDCRMCT04	Category Code04 F0005 Drky	String	UDC (01 04)	10	0	Allow NULL?
35	LDCRMCT05	Category Code05 F0005 Drky	String	UDC (01 05)	10	0	Allow NULL?
36	LDCRMCT06	Category Code06 F0005 Drky	String	UDC (01 06)	10	0	Allow NULL?
37	LDCRMCT07	Category Code07 F0005 Drky	String	UDC (01 07)	10	0	Allow NULL?
38	LDCRMCT08	Category Code08 F0005 Drky	String	UDC (01 08)	10	0	Allow NULL?
39	LDCRMCT09	Category Code09 F0005 Drky	String	UDC (01 09)	10	0	Allow NULL?
40	LDCRMCT10	Category Code10 F0005 Drky	String	UDC (01 10)	10	0	Allow NULL?
41	LDCRMCT11	Category Code11 F0005 Drky	String	UDC (01 11)	10	0	Allow NULL?
42	LDCRMCT12	Category Code12 F0005 Drky	String	UDC (01 12)	10	0	Allow NULL?
43	LDCRMCT13	Category Code13 F0005 Drky	String	UDC (01 13)	10	0	Allow NULL?
44	LDCRMCT14	Category Code14 F0005 Drky	String	UDC (01 14)	10	0	Allow NULL?
45	LDCRMCT15	Category Code15 F0005 Drky	String	UDC (01 15)	10	0	Allow NULL?
46	LDCRMCT16	Category Code16 F0005 Drky	String	UDC (01 16)	10	0	Allow NULL?
47	LDCRMCT17	Category Code17 F0005 Drky	String	UDC (01 17)	10	0	Allow NULL?
48	LDCRMCT18	Category Code18 F0005 Drky	String	UDC (01 18)	10	0	Allow NULL?
49	LDCRMCT19	Category Code19 F0005 Drky	String	UDC (01 19)	10	0	Allow NULL?
50	LDCRMCT20	Category Code20 F0005 Drky	String	UDC (01 20)	10	0	Allow NULL?
51	LDCRMCT21	Category Code21 F0005 Drky	String	UDC (01 21)	10	0	Allow NULL?
52	LDCRMCT22	Category Code22 F0005 Drky	String	UDC (01 22)	10	0	Allow NULL?
53	LDCRMCT23	Category Code23 F0005 Drky	String	UDC (01 23)	10	0	Allow NULL?
54	LDCRMCT24	Category Code24 F0005 Drky	String	UDC (01 24)	10	0	Allow NULL?
55	LDCRMCT25	Category Code25 F0005 Drky	String	UDC (01 25)	10	0	Allow NULL?
56	LDCRMCT26	Category Code26 F0005 Drky	String	UDC (01 26)	10	0	Allow NULL?
57	LDCRMCT27	Category Code27 F0005 Drky	String	UDC (01 27)	10	0	Allow NULL?
58	LDCRMCT28	Category Code28 F0005 Drky	String	UDC (01 28)	10	0	Allow NULL?
59	LDCRMCT29	Category Code29 F0005 Drky	String	UDC (01 29)	10	0	Allow NULL?
60	LDCRMCT30	Category Code30 F0005 Drky	String	UDC (01 30)	10	0	Allow NULL?
61	LDEXVAR0	Ext Varchar0	Variable String	Generic Edit	255	0	Allow NULL?
62	LDEXVAR1	Ext Varchar1	Variable String	Generic Edit	255	0	Allow NULL?
63	LDEXVAR2	Ext Varchar2	Variable String	Generic Edit	255	0	Allow NULL?
64	LDEXVAR3	Ext Varchar3	Variable String	Generic Edit	255	0	Allow NULL?
65	LDEXVAR4	Ext Varchar4	Variable String	Generic Edit	50	0	Allow NULL?
66	LDEXVAR5	Ext Varchar5	Variable String	Generic Edit	50	0	Allow NULL?
67	LDEXVAR6	Ext Varchar6	Variable String	Generic Edit	50	0	Allow NULL?
68	LDEXVAR7	Ext Varchar7	Variable String	Generic Edit	50	0	Allow NULL?
69	LDEXVAR8	Ext Varchar8	Variable String	Generic Edit	50	0	Allow NULL?
70	LDEXVAR9	Ext Varchar9	Variable String	Generic Edit	50	0	Allow NULL?
71	LDEXVAR10	Ext Varchar10	Variable String	Generic Edit	50	0	Allow NULL?
72	LDEXVAR11	Ext Varchar11	Variable String	Generic Edit	50	0	Allow NULL?
73	LDEXVAR12	Ext Varchar12	Variable String	Generic Edit	25	0	Allow NULL?
74	LDEXVAR13	Ext Varchar13	Variable String	Generic Edit	25	0	Allow NULL?
75	LDEXVAR14	Ext Varchar14	Variable String	Generic Edit	25	0	Allow NULL?
76	LDEXNM0	Ext Numeric0	Numeric	Generic Edit	15	0	Allow NULL?
77	LDEXNM1	Ext Numeric1	Numeric	Generic Edit	15	0	Allow NULL?
78	LDEXNM2	Ext Numeric2	Numeric	Generic Edit	15	0	Allow NULL?
79	LDEXNM3	Ext Numeric3	Numeric	Generic Edit	15	0	Allow NULL?
80	LDEXNM4	Ext Numeric4	Numeric	Generic Edit	15	0	Allow NULL?
81	LDEXNMP0	Ext Numericp0	Numeric	Generic Edit	15	4	Allow NULL?
82	LDEXNMP1	Ext Numericp1	Numeric	Generic Edit	15	4	Allow NULL?
83	LDEXNMP2	Ext Numericp2	Numeric	Generic Edit	15	4	Allow NULL?
84	LDEXNMP3	Ext Numericp3	Numeric	Generic Edit	15	4	Allow NULL?
85	LDEXNMP4	Ext Numericp4	Numeric	Generic Edit	15	4	Allow NULL?
86	LDEXDT0	Ext Date0	JDE UTime	Generic Edit	11	0
87	LDEXDT1	Ext Date1	JDE UTime	Generic Edit	11	0
88	LDEXDT2	Ext Date2	JDE UTime	Generic Edit	11	0
89	LDEXDT3	Ext Date3	JDE UTime	Generic Edit	11	0
90	LDEXDT4	Ext Date4	JDE UTime	Generic Edit	11	0
91	LDSTSUDT	Status Updated Date	JDE UTime	Generic Edit	11	0
92	LDACTIND	Active Indicator	Character	Generic Edit	1	0	Allow NULL?
93	LDUSER	User ID	String	Generic Edit	10	0	Allow NULL?
94	LDPID	Program ID	String	Generic Edit	10	0	Allow NULL?
95	LDVID	Version Id	String	Generic Edit	10	0	Allow NULL?
96	LDMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
97	LDUDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0

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

97 COLUMNS | 3 INDEXES | 920 | 90CB | F90CB010 TABLE

TOP 920 | 90CB | F90CB010 COLUMNS

TOP 920 | 90CB | F90CB010 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

97 COLUMNS | 3 INDEXES | 920 | 90CB | F90CB010 TABLE

TOP920 | 90CB | F90CB010 COLUMNS

TOP920 | 90CB | F90CB010 INDEXES

TOP 920 | 90CB | F90CB010 COLUMNS

TOP 920 | 90CB | F90CB010 INDEXES