	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

73 COLUMNS | 5 INDEXES | 920 | F31 | FF31111 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
F31: Lean Transactions
1	920	FF31111	PL	73	5	Lean Transaction Parts List	Files	F31: Lean Transactions

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 PLUKID, PLMTID, PLPRODF31, PLTRSID, PLDFMLINE, PLKIT, PLMMCU, PLITM, PLCMCU, PLCPNB, PLTRQTY, PLLTRQT, PLSOCN, PLUOM, PLUM, PLFORQ, PLITC, PLRORN, PLRCTO, PLRLLN, PLRKCO, PLOPSQ, PLBSEQ, PLRSCP, PLSCRP, PLREWP, PLASIP, PLCPYP, PLSTPP, PLLITM, PLAITM, PLDSC1, PLDSC2, PLLOCN, PLLOTN, PLAN8, PLLNTY, PLSERN, PLLTDATE, PLUCNDJ, PLLRDATE, PLCTS1, PLCTS4, PLCTS8, PLCTS7, PLEA, PLDCT, PLMCU, PLOMCU, PLOBJ, PLSUB, PLCMRV, PLVEND, PLPOC, PLLGLDATE, PLPSN, PLLLEDATE, PLTRQT, PLTRSTS, PLCOST, PLCHPP, PLBSEQAN, PLTUSER, PLCUSER, PLURCD, PLURDT, PLURAT, PLURRF, PLURAB, PLUSER, PLUUPMJ, PLMKEY, PLPID FROM FF31111

TOP 920 | F31 | FF31111 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PLUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	PLMTID	Master Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
3	PLPRODF31	Production Plan ID	Numeric	Generic Edit	8	0	Allow NULL?
4	PLTRSID	Transaction ID	Numeric	Generic Edit	8	0	Allow NULL?
5	PLDFMLINE	DFM Line Identifier	String	Generic Edit	12	0	Allow NULL?
6	PLKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
7	PLMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
8	PLITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
9	PLCMCU	Component Branch	String	Generic Edit	12	0	Allow NULL?
10	PLCPNB	Component Line Number BOM	Numeric	Generic Edit	8	2	Allow NULL?
11	PLTRQTY	Units - Transaction Quantity Primary	Numeric	Generic Edit	15	0	Allow NULL?
12	PLLTRQT	Lean Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
13	PLSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
14	PLUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
15	PLUM	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
16	PLFORQ	Fixed or Variable Quantity	Character	UDC (H40 FO)	1	0	Allow NULL?
17	PLITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
18	PLRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
19	PLRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
20	PLRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
21	PLRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
22	PLOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
23	PLBSEQ	Sequence - Bubble Sequence	Numeric	Generic Edit	5	0	Allow NULL?
24	PLRSCP	Resource Percent	Numeric	Generic Edit	5	2	Allow NULL?
25	PLSCRP	Percent - Percent of Scrap	Numeric	Generic Edit	5	2	Allow NULL?
26	PLREWP	Percent - Rework	Numeric	Generic Edit	5	2	Allow NULL?
27	PLASIP	Percent - As is	Numeric	Generic Edit	5	2	Allow NULL?
28	PLCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
29	PLSTPP	Operation Scrap Percent	Numeric	Generic Edit	5	2	Allow NULL?
30	PLLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
31	PLAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
32	PLDSC1	Description	String	Generic Edit	30	0	Allow NULL?
33	PLDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
34	PLLOCN	Location	String	Generic Edit	20	0	Allow NULL?
35	PLLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
36	PLAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
37	PLLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
38	PLSERN	Serial Number - Lot	String	Generic Edit	30	0	Allow NULL?
39	PLLTDATE	Transaction Date Lean	JDE UTime	Generic Edit	11	0
40	PLUCNDJ	Date - Cancel	JDE UTime	Generic Edit	11	0
41	PLLRDATE	Requested Date Lean	JDE UTime	Generic Edit	11	0
42	PLCTS1	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
43	PLCTS4	Amount - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
44	PLCTS8	Units - Unaccounted Scrap	Numeric	Generic Edit	15	0	Allow NULL?
45	PLCTS7	Amount - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
46	PLEA	Amount - Estimated Cost	Numeric	Generic Edit	15	2	Allow NULL?
47	PLDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
48	PLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
49	PLOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
50	PLOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
51	PLSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
52	PLCMRV	Component Revision Level	String	Generic Edit	3	0	Allow NULL?
53	PLVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
54	PLPOC	Issue and Receipt	Character	UDC (43 IR)	1	0	Allow NULL?
55	PLLGLDATE	G/L Date Lean	JDE UTime	Generic Edit	11	0
56	PLPSN	Pick Slip Number	Numeric	Generic Edit	8	0	Allow NULL?
57	PLLLEDATE	Lot Effective Date Lean	JDE UTime	Generic Edit	11	0
58	PLTRQT	Quantity Available	Numeric	Generic Edit	15	0	Allow NULL?
59	PLTRSTS	Transaction Status	String	UDC (F31 TS)	2	0	Allow NULL?
60	PLCOST	Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
61	PLCHPP	Critical Hold Propagation	Character	Generic Edit	1	0	Allow NULL?
62	PLBSEQAN	Bubble Sequence Alpha Numeric	String	Generic Edit	5	0	Allow NULL?
63	PLTUSER	Transaction User ID	String	Generic Edit	10	0	Allow NULL?
64	PLCUSER	Cancellation User ID	String	Generic Edit	10	0	Allow NULL?
65	PLURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
66	PLURDT	User Reserved Date	Date	Generic Edit	6	0
67	PLURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
68	PLURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
69	PLURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
70	PLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
71	PLUUPMJ	Universal Date Updated	JDE UTime	Generic Edit	11	0
72	PLMKEY	Machine Key	String	Generic Edit	15	0	Allow NULL?
73	PLPID	Program ID	String	Generic Edit	10	0	Allow NULL?

TOP 920 | F31 | FF31111 INDEXES

Number

Description

UKID (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

ITM CMCU LTRQT

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	CMCU	Component Branch	Ascending
3	LTRQT	Lean Transaction Quantity	Ascending

MTID PRODF31 +

Element	Alias	Description	Sequence
1	MTID	Master Transaction ID	Ascending
2	PRODF31	Production Plan ID	Ascending
3	TRSID	Transaction ID	Ascending

PRODF31 TRSID +

Element	Alias	Description	Sequence
1	PRODF31	Production Plan ID	Ascending
2	TRSID	Transaction ID	Ascending
3	OPSQ	Sequence Number - Operations	Ascending

ITM CMCU +

Element	Alias	Description	Sequence
1	ITM	Item Number - Short	Ascending
2	CMCU	Component Branch	Ascending
3	LOCN	Location	Ascending
4	LOTN	Lot/Serial Number	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

73 COLUMNS | 5 INDEXES | 920 | F31 | FF31111 TABLE

TOP 920 | F31 | FF31111 COLUMNS

TOP 920 | F31 | FF31111 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

73 COLUMNS | 5 INDEXES | 920 | F31 | FF31111 TABLE

TOP920 | F31 | FF31111 COLUMNS

TOP920 | F31 | FF31111 INDEXES

TOP 920 | F31 | FF31111 COLUMNS

TOP 920 | F31 | FF31111 INDEXES