	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

	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

	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

37 COLUMNS | 4 INDEXES | 920 | 90CB | F90CB05A TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
90CB: CRM Sales Force Automation
1	920	F90CB05A	OP	37	4	Sales_Cycle Table	Files	90CB: CRM Sales Force Automation

TOP 920 | 90CB | F90CB05A COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	OPSMEID	Sales Methodology Id	Numeric	Generic Edit	15	0	Allow NULL?
2	OPPBLTY	Probability	Numeric	Generic Edit	15	0	Allow NULL?
3	OPSLCYID	Sales Cycle Id	Numeric	Generic Edit	15	0	Allow NULL?
4	OPPBRNG	Probability Range Id	Numeric	Generic Edit	15	0	Allow NULL?
5	OPMTCLS	Month To Close	Numeric	Generic Edit	15	0	Allow NULL?
6	OPFUNLVL	Step #	Numeric	Generic Edit	15	0	Allow NULL?
7	OPFUNEXC	Funnel Exclude	Character	Generic Edit	1	0	Allow NULL?
8	OPWONLST	Won Lost	Character	Generic Edit	1	0	Allow NULL?
9	OPRQDSTP	Required Step	Character	Generic Edit	1	0	Allow NULL?
10	OPSCNAME	Sales Cycle Name	Variable String	Generic Edit	50	0	Allow NULL?
11	OPACTPLN	Action Plan	Numeric	Generic Edit	15	0	Allow NULL?
12	OPENTDBY	Entered By	Numeric	Generic Edit	8	0	Allow NULL?
13	OPEDATE	Date Entered	JDE UTime	Generic Edit	11	0
14	OPEXVAR0	Ext Varchar0	Variable String	Generic Edit	255	0	Allow NULL?
15	OPEXVAR1	Ext Varchar1	Variable String	Generic Edit	255	0	Allow NULL?
16	OPEXVAR2	Ext Varchar2	Variable String	Generic Edit	255	0	Allow NULL?
17	OPEXVAR3	Ext Varchar3	Variable String	Generic Edit	255	0	Allow NULL?
18	OPEXVAR4	Ext Varchar4	Variable String	Generic Edit	50	0	Allow NULL?
19	OPEXVAR5	Ext Varchar5	Variable String	Generic Edit	50	0	Allow NULL?
20	OPEXVAR6	Ext Varchar6	Variable String	Generic Edit	50	0	Allow NULL?
21	OPEXVAR7	Ext Varchar7	Variable String	Generic Edit	50	0	Allow NULL?
22	OPEXNM0	Ext Numeric0	Numeric	Generic Edit	15	0	Allow NULL?
23	OPEXNM1	Ext Numeric1	Numeric	Generic Edit	15	0	Allow NULL?
24	OPEXNM2	Ext Numeric2	Numeric	Generic Edit	15	0	Allow NULL?
25	OPEXNMP0	Ext Numericp0	Numeric	Generic Edit	15	4	Allow NULL?
26	OPEXNMP1	Ext Numericp1	Numeric	Generic Edit	15	4	Allow NULL?
27	OPEXNMP2	Ext Numericp2	Numeric	Generic Edit	15	4	Allow NULL?
28	OPEXDT0	Ext Date0	JDE UTime	Generic Edit	11	0
29	OPEXDT1	Ext Date1	JDE UTime	Generic Edit	11	0
30	OPEXDT2	Ext Date2	JDE UTime	Generic Edit	11	0
31	OPSTSUDT	Status Updated Date	JDE UTime	Generic Edit	11	0
32	OPACTIND	Active Indicator	Character	Generic Edit	1	0	Allow NULL?
33	OPUSER	User ID	String	Generic Edit	10	0	Allow NULL?
34	OPPID	Program ID	String	Generic Edit	10	0	Allow NULL?
35	OPVID	Version Id	String	Generic Edit	10	0	Allow NULL?
36	OPMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
37	OPUDTTM	Updated Date Time	JDE UTime	Generic Edit	11	0

TOP 920 | 90CB | F90CB05A INDEXES

Number

Description

SalesCycleId (Primary/Unique)

Element	Alias	Description	Sequence
1	SLCYID	Sales Cycle Id	Ascending

SMID p

Element	Alias	Description	Sequence
1	SMEID	Sales Methodology Id	Ascending
2	PBLTY	Probability	Ascending
3	ACTIND	Active Indicator	Ascending

SMID ACTIND FUN PBLY

Element	Alias	Description	Sequence
1	SMEID	Sales Methodology Id	Ascending
2	ACTIND	Active Indicator	Ascending
3	FUNLVL	Step #	Ascending
4	PBLTY	Probability	Ascending

SMID ACTIND Name

Element	Alias	Description	Sequence
1	SMEID	Sales Methodology Id	Ascending
2	ACTIND	Active Indicator	Ascending
3	SCNAME	Sales Cycle Name	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

37 COLUMNS | 4 INDEXES | 920 | 90CB | F90CB05A TABLE

TOP 920 | 90CB | F90CB05A COLUMNS

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

37 COLUMNS | 4 INDEXES | 920 | 90CB | F90CB05A TABLE

TOP920 | 90CB | F90CB05A COLUMNS

TOP920 | 90CB | F90CB05A INDEXES

TOP 920 | 90CB | F90CB05A COLUMNS

TOP 920 | 90CB | F90CB05A INDEXES