	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

23 COLUMNS | 9 INDEXES | 812 | H92 | F98250 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
H92: Interactive Engine/OL
1	812	F98250	BP	23	9	BPU Setup	Files	H92: Interactive Engine/OL

TOP 812 | H92 | F98250 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	BPBPUGRP	BPU Group Name	String	Generic Edit	30	Allow NULL?
2	BPBPUSGRP	BPU Subgroup Name	String	Generic Edit	30	Allow NULL?
3	BPOMWPRJID	Object Management Project Name	String	Generic Edit	30	Allow NULL?
4	BPBPUID	BPU ID	Integer	Generic Edit	11	Allow NULL?
5	BPBPUSACT	BPU Subgroup Active Flag	String	UDC (H92 BA)	10	Allow NULL?
6	BPBPUPACT	BPU Project Active Flag	String	UDC (H92 BA)	10	Allow NULL?
7	BPBPUSSUC	BPU Subgroup Success Flag	String	UDC (H92 BS)	10	Allow NULL?
8	BPBPUPSUC	BPU Project Success Flag	String	UDC (H92 BS)	10	Allow NULL?
9	BPBPUFRST	BPU From Status	String	Generic Edit	5	Allow NULL?
10	BPBPUTOST	BPU To Status	String	Generic Edit	5	Allow NULL?
11	BPBPUSORD	BPU Subgroup Order	Integer	Generic Edit	11	Allow NULL?
12	BPBPUPORD	BPU Project Order	Integer	Generic Edit	11	Allow NULL?
13	BPBPUFUS1	BPU Future Use Str1	String	Generic Edit	30	Allow NULL?
14	BPBPUFUS2	BPU Future Use Str2	String	Generic Edit	30	Allow NULL?
15	BPBPUFUMN1	BPU Future Use MN1	Numeric	Generic Edit	10	Allow NULL?
16	BPBPUFUMN2	BPU Future Use MN2	Numeric	Generic Edit	10	Allow NULL?
17	BPBPUFUD1	BPU Future Use Date1	Date	Generic Edit	6
18	BPBPUFUD2	BPU Future Use Date2	Date	Generic Edit	6
19	BPPID	Program ID	String	Generic Edit	10	Allow NULL?
20	BPMKEY	Machine Key	String	Generic Edit	15	Allow NULL?
21	BPUSER	User ID	String	Generic Edit	10	Allow NULL?
22	BPUPMJ	Date - Updated	Date	Generic Edit	6
23	BPUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?

TOP 812 | H92 | F98250 INDEXES

Number

Description

Grp Sub

Element	Alias	Description	Sequence
1	BPUGRP	BPU Group Name	Ascending
2	BPUSGRP	BPU Subgroup Name	Ascending

Sub Proj

Element	Alias	Description	Sequence
1	BPUSGRP	BPU Subgroup Name	Ascending
2	OMWPRJID	Object Management Project Name	Ascending

ID PAct PSuc POrd

Element	Alias	Description	Sequence
1	BPUID	BPU ID	Ascending
2	BPUPACT	BPU Project Active Flag	Ascending
3	BPUPSUC	BPU Project Success Flag	Ascending
4	BPUPORD	BPU Project Order	Ascending

Grp

Element	Alias	Description	Sequence
1	BPUGRP	BPU Group Name	Ascending

Grp Sub Proj

Element	Alias	Description	Sequence
1	BPUGRP	BPU Group Name	Ascending
2	BPUSGRP	BPU Subgroup Name	Ascending
3	OMWPRJID	Object Management Project Name	Ascending

Grp Sub Proj ID (Primary/Unique)

Element	Alias	Description	Sequence
1	BPUGRP	BPU Group Name	Ascending
2	BPUSGRP	BPU Subgroup Name	Ascending
3	OMWPRJID	Object Management Project Name	Ascending
4	BPUID	BPU ID	Ascending

Grp Sub SOrd

Element	Alias	Description	Sequence
1	BPUGRP	BPU Group Name	Ascending
2	BPUSGRP	BPU Subgroup Name	Ascending
3	BPUSORD	BPU Subgroup Order	Ascending

Grp Sub Proj POrd ID

Element	Alias	Description	Sequence
1	BPUGRP	BPU Group Name	Ascending
2	BPUSGRP	BPU Subgroup Name	Ascending
3	OMWPRJID	Object Management Project Name	Ascending
4	BPUPORD	BPU Project Order	Ascending
5	BPUID	BPU ID	Ascending

Grp Sub Proj From To (Unique)

Element	Alias	Description	Sequence
1	BPUGRP	BPU Group Name	Ascending
2	BPUSGRP	BPU Subgroup Name	Ascending
3	OMWPRJID	Object Management Project Name	Ascending
4	BPUFRST	BPU From Status	Ascending
5	BPUTOST	BPU To Status	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

23 COLUMNS | 9 INDEXES | 812 | H92 | F98250 TABLE

TOP 812 | H92 | F98250 COLUMNS

TOP 812 | H92 | F98250 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

23 COLUMNS | 9 INDEXES | 812 | H92 | F98250 TABLE

TOP812 | H92 | F98250 COLUMNS

TOP812 | H92 | F98250 INDEXES

TOP 812 | H92 | F98250 COLUMNS

TOP 812 | H92 | F98250 INDEXES