	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

76 COLUMNS | 1 INDEXES | 812 | 13 | F12071 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
13: Plant/Equipment Management
1	812	F12071	FZ	76	1	Equipment PM Schedule (Model)	Secondary Master Files	13: Plant/Equipment Management	AS400 Coexistence Tables

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 FZSRVT, FZTDT, FZUPMJ, FZUPMT, FZUSER, FZWONA, FZACL0, FZACL1, FZACL2, FZACL3, FZACL4, FZACL5, FZACL6, FZACL7, FZACL8, FZACL9, FZCPLF, FZCPLH, FZCPLM, FZDOCO, FZKY, FZJOBN, FZLCPD, FZLSTF, FZLSTH, FZLSTM, FZMPC, FZMPRI, FZNUMB, FZMSTS, FZPID, FZRMK, FZSRVD, FZSRVF, FZSRVH, FZSRVM, FZWK, FZUKID, FZTOLU, FZTOLL, FZSPWK, FZSPMN, FZSPHR, FZSPDW, FZPNST, FZPMC2, FZPMC1, FZPDFL, FZORGM, FZORGH, FZORGF, FZOCCU, FZMLTW, FZHLDD, FZMCU, FZDNHR, FZCRTL, FZFRIN, FZCPLD, FZASID, FZAPID, FZAAID, FZANP, FZPDFG, FZSRVM4, FZLSTM4, FZCPLM4, FZORGM4, FZSRVM5, FZLSTM5, FZCPLM5, FZORGM5, FZSRVM6, FZLSTM6, FZCPLM6, FZORGM6 FROM F12071

TOP 812 | 13 | F12071 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	FZSRVT	Service Type	String	UDC (12 ST)	8	0	Allow NULL?
2	FZTDT	Date - Scheduled Tickler	Date	Generic Edit	6	0
3	FZUPMJ	Date - Updated	Date	Generic Edit	6	0
4	FZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
5	FZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
6	FZWONA	Work Order Number Assigned	Numeric	Generic Edit	8	0	Allow NULL?
7	FZACL0	Category Code - F/A 10 (Rate Group)	String	UDC (12 C0)	3	0	Allow NULL?
8	FZACL1	Major Accounting Class	String	UDC (12 C1)	3	0	Allow NULL?
9	FZACL2	Major Equipment Class	String	UDC (12 C2)	3	0	Allow NULL?
10	FZACL3	Manufacturer	String	UDC (12 C3)	3	0	Allow NULL?
11	FZACL4	Model Year	String	UDC (12 C4)	3	0	Allow NULL?
12	FZACL5	Usage Miles or Hours	String	UDC (12 C5)	3	0	Allow NULL?
13	FZACL6	Category Code - F/A 6	String	UDC (12 C6)	3	0	Allow NULL?
14	FZACL7	Category Code - F/A 7	String	UDC (12 C7)	3	0	Allow NULL?
15	FZACL8	Category Code - F/A 8	String	UDC (12 C8)	3	0	Allow NULL?
16	FZACL9	Category Code - F/A 9	String	UDC (12 C9)	3	0	Allow NULL?
17	FZCPLF	Completed Hours	Numeric	Generic Edit	15	2	Allow NULL?
18	FZCPLH	Consumed Fuel	Numeric	Generic Edit	15	2	Allow NULL?
19	FZCPLM	Completed Miles	Numeric	Generic Edit	15	2	Allow NULL?
20	FZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
21	FZKY	User Defined Code	String	Generic Edit	10	0	Allow NULL?
22	FZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
23	FZLCPD	Date - Last Completed Date	Date	Generic Edit	6	0
24	FZLSTF	Last Completed Hours	Numeric	Generic Edit	15	2	Allow NULL?
25	FZLSTH	Last Completed Fuel Consumed	Numeric	Generic Edit	15	2	Allow NULL?
26	FZLSTM	Last Completed Miles	Numeric	Generic Edit	15	2	Allow NULL?
27	FZMPC	Percent - Maintenance Due	Numeric	Generic Edit	3	0	Allow NULL?
28	FZMPRI	Maintenance Priority	Character	UDC (00 PR)	1	0	Allow NULL?
29	FZNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
30	FZMSTS	Maintenance Status	String	UDC (12 MS)	2	0	Allow NULL?
31	FZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
32	FZRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
33	FZSRVD	Service Days	Numeric	Generic Edit	15	0	Allow NULL?
34	FZSRVF	Service Hours	Numeric	Generic Edit	15	2	Allow NULL?
35	FZSRVH	Service Fuel	Numeric	Generic Edit	15	2	Allow NULL?
36	FZSRVM	Service Miles	Numeric	Generic Edit	15	2	Allow NULL?
37	FZWK	Week Number	Numeric	Generic Edit	2	0	Allow NULL?
38	FZUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
39	FZTOLU	Tolerance Limit - Upper	Numeric	Generic Edit	15	2	Allow NULL?
40	FZTOLL	Tolerance Limit - Lower	Numeric	Generic Edit	15	2	Allow NULL?
41	FZSPWK	Weeks - Specific	Numeric	Generic Edit	15	2	Allow NULL?
42	FZSPMN	Months - Specific	Numeric	Generic Edit	15	2	Allow NULL?
43	FZSPHR	Hours - Specific	Numeric	Generic Edit	15	2	Allow NULL?
44	FZSPDW	Day of the Week	Character	Generic Edit	1	0	Allow NULL?
45	FZPNST	Date - Planned Start (Julian)	Date	Generic Edit	6	0
46	FZPMC2	PM Category Code 2	String	UDC (13 P2)	3	0	Allow NULL?
47	FZPMC1	PM Category Code 1	String	UDC (13 P1)	3	0	Allow NULL?
48	FZPDFL	Alert Level	Character	UDC (13 AL)	1	0	Allow NULL?
49	FZORGM	Original Miles	Numeric	Generic Edit	15	2	Allow NULL?
50	FZORGH	Original Hours	Numeric	Generic Edit	15	2	Allow NULL?
51	FZORGF	Original Fuel	Numeric	Generic Edit	15	2	Allow NULL?
52	FZOCCU	Occurrences	Numeric	Generic Edit	5	2	Allow NULL?
53	FZMLTW	Multiple Work Order Code	Character	UDC (13 ML)	1	0	Allow NULL?
54	FZHLDD	Date - Hold	Date	Generic Edit	6	0
55	FZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
56	FZDNHR	Downtime Required	Numeric	Generic Edit	15	2	Allow NULL?
57	FZCRTL	Criticality	Numeric	Generic Edit	2	0	Allow NULL?
58	FZFRIN	Frequency Indicator	Character	UDC (13 FR)	1	0	Allow NULL?
59	FZCPLD	Date - Completed Date	Date	Generic Edit	6	0
60	FZASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
61	FZAPID	Unit or Tag Number	String	UDC	12	0	Allow NULL?
62	FZAAID	Parent Number	Numeric	Generic Edit	8	0	Allow NULL?
63	FZANP	Address Number - Assigned To	Numeric	Generic Edit	8	0	Allow NULL?
64	FZPDFG	Schedule Type	Character	UDC (13 ST)	1	0	Allow NULL?
65	FZSRVM4	Service Meter 4	Numeric	Generic Edit	15	2	Allow NULL?
66	FZLSTM4	Last Completed Meter 4	Numeric	Generic Edit	15	2	Allow NULL?
67	FZCPLM4	Completed Meter 4	Numeric	Generic Edit	15	2	Allow NULL?
68	FZORGM4	Original Meter 4	Numeric	Generic Edit	15	2	Allow NULL?
69	FZSRVM5	Service Meter 5	Numeric	Generic Edit	15	2	Allow NULL?
70	FZLSTM5	Last Completed Meter 5	Numeric	Generic Edit	15	2	Allow NULL?
71	FZCPLM5	Completed Meter 5	Numeric	Generic Edit	15	2	Allow NULL?
72	FZORGM5	Original Meter 5	Numeric	Generic Edit	15	2	Allow NULL?
73	FZSRVM6	Service Meter 6	Numeric	Generic Edit	15	2	Allow NULL?
74	FZLSTM6	Last Completed Meter 6	Numeric	Generic Edit	15	2	Allow NULL?
75	FZCPLM6	Completed Meter 6	Numeric	Generic Edit	15	2	Allow NULL?
76	FZORGM6	Original Meter 6	Numeric	Generic Edit	15	2	Allow NULL?

TOP 812 | 13 | F12071 INDEXES

Number

Description

AssetNum Acc+ (Primary/Unique)

Element	Alias	Description	Sequence
1	NUMB	Asset Item Number	Ascending
2	ACL1	Major Accounting Class	Ascending
3	ACL2	Major Equipment Class	Ascending
4	ACL3	Manufacturer	Ascending
5	ACL4	Model Year	Ascending
6	ACL5	Usage Miles or Hours	Ascending
7	ACL6	Category Code - F/A 6	Ascending
8	ACL7	Category Code - F/A 7	Ascending
9	ACL8	Category Code - F/A 8	Ascending
10	ACL9	Category Code - F/A 9	Ascending
11	ACL0	Category Code - F/A 10 (Rate Group)	Ascending
12	SRVT	Service Type	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

76 COLUMNS | 1 INDEXES | 812 | 13 | F12071 TABLE

TOP 812 | 13 | F12071 COLUMNS

TOP 812 | 13 | F12071 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

76 COLUMNS | 1 INDEXES | 812 | 13 | F12071 TABLE

TOP812 | 13 | F12071 COLUMNS

TOP812 | 13 | F12071 INDEXES

TOP 812 | 13 | F12071 COLUMNS

TOP 812 | 13 | F12071 INDEXES