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
31: Shop Floor Control
1	812	F3112Z1	SZ	124	1	Outbound Work Order Routings	Batch Input Files	31: Shop Floor Control	No

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SZEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	SZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	SZEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	SZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	SZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SZTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	SZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	SZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	SZDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	SZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	SZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	SZPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	SZTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	SZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
15	SZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
16	SZSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
17	SZTRT	Type of Routing	String	UDC (40 TR)	3	0	Allow NULL?
18	SZKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
19	SZKITL	Kit - 2nd Item Number	String	Generic Edit	25	0	Allow NULL?
20	SZKITA	3rd Item Number - Kit	String	Generic Edit	25	0	Allow NULL?
21	SZMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
22	SZLINE	Line/Cell Identifier	String	Generic Edit	12	0	Allow NULL?
23	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
24	SZALD	Auto Load Description	String	UDC (30 AL)	4	0	Allow NULL?
25	SZDSC1	Description	String	Generic Edit	30	0	Allow NULL?
26	SZOPSQ	Sequence Number - Operations	Numeric	Generic Edit	5	2	Allow NULL?
27	SZOPSC	Type Operation Code	String	UDC (30 OT)	2	0	Allow NULL?
28	SZOPST	Operation Status Code W.O.	String	UDC (31 OS)	2	0	Allow NULL?
29	SZINPE	Inspection Code	String	Generic Edit	2	0	Allow NULL?
30	SZTIMB	Time Basis Code	Character	UDC (30 TB)	1	0	Allow NULL?
31	SZLAMC	Labor or Machine	Character	UDC (H40 LA)	1	0	Allow NULL?
32	SZBFPF	Pay Point Code	Character	UDC (30 BF)	1	0	Allow NULL?
33	SZPPRF	Pay Point Status	Character	UDC (31 PP)	1	0	Allow NULL?
34	SZJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
35	SZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
36	SZCRTR	Critical Ratio	Numeric	Generic Edit	7	4	Allow NULL?
37	SZSLTR	Slack Time Ratio	Numeric	Generic Edit	7	4	Allow NULL?
38	SZTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
39	SZDRQJ	Date - Requested	Date	Generic Edit	6	0
40	SZSTRT	Date - Start (Julian)	Date	Generic Edit	6	0
41	SZRSFT	Shift Code - Requested	Character	UDC	1	0	Allow NULL?
42	SZSSFT	Shift Code - Start	Character	UDC	1	0	Allow NULL?
43	SZCSFT	Shift Code - Completed	Character	UDC	1	0	Allow NULL?
44	SZLTPC	Percent - Leadtime Overlap	Numeric	Generic Edit	5	2	Allow NULL?
45	SZPOVR	Percent - Overlap	Numeric	Generic Edit	5	2	Allow NULL?
46	SZOPYP	Percent - Operational Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
47	SZCPYP	Percent - Cumulative Planned Yield	Numeric	Generic Edit	5	2	Allow NULL?
48	SZNXOP	Sequence Number - Next Operation	Numeric	Generic Edit	5	2	Allow NULL?
49	SZSETC	Crew Size	Numeric	Generic Edit	5	1	Allow NULL?
50	SZMOVD	Move Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
51	SZQUED	Queue Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
52	SZRUNM	Run Machine - Standard	Numeric	Generic Edit	15	2	Allow NULL?
53	SZRUNL	Run Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
54	SZSETL	Setup Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
55	SZMACA	Run Machine - Actual	Numeric	Generic Edit	15	2	Allow NULL?
56	SZLABA	Run Labor - Actual	Numeric	Generic Edit	15	2	Allow NULL?
57	SZSETA	Hours - Setup Labor Hours - Actual	Numeric	Generic Edit	15	2	Allow NULL?
58	SZOPSR	Factor - Operation Shrinkage Factor	Numeric	Generic Edit	15	4	Allow NULL?
59	SZUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
60	SZSOCN	Units - Quantity Canceled/Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
61	SZSOQS	Quantity Shipped	Numeric	Generic Edit	15	2	Allow NULL?
62	SZQMTO	Units - Quantity at Operation	Numeric	Generic Edit	15	2	Allow NULL?
63	SZPWRT	Rate - Piecework	Numeric	Generic Edit	15	3	Allow NULL?
64	SZUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
65	SZCTS2	Hours - Unaccounted Setup Labor	Numeric	Generic Edit	15	2	Allow NULL?
66	SZCTS3	Hours - Unaccounted Machine Hours	Numeric	Generic Edit	15	2	Allow NULL?
67	SZCTS4	Amount - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
68	SZCTS5	Amount - Unaccounted Setup Labor	Numeric	Generic Edit	15	2	Allow NULL?
69	SZCTS6	Amount - Unaccounted Machine	Numeric	Generic Edit	15	2	Allow NULL?
70	SZAPID	Unit or Tag Number	String	UDC	12	0	Allow NULL?
71	SZSHNO	Message Number	String	Generic Edit	10	0	Allow NULL?
72	SZOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
73	SZOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
74	SZSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
75	SZVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
76	SZRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
77	SZRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
78	SZRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
79	SZRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
80	SZDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
81	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
82	SZURDT	User Reserved Date	Date	Generic Edit	6	0
83	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
84	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
85	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
86	SZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
87	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
88	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
89	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
90	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
91	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
92	SZCAPU	Capacity Unit of measure	String	UDC (00 UM)	2	0	Allow NULL?
93	SZCLHR	Run Labor - Current	Numeric	Generic Edit	15	2	Allow NULL?
94	SZCMHR	Run Machine - Current	Numeric	Generic Edit	15	2	Allow NULL?
95	SZCOST	Cost Component	String	UDC (30 CA)	3	0	Allow NULL?
96	SZCSHR	Setup Labor - Current	Numeric	Generic Edit	15	2	Allow NULL?
97	SZLOCN	Location	String	Generic Edit	20	0	Allow NULL?
98	SZRUC	Resource units consumed	Numeric	Generic Edit	15	2	Allow NULL?
99	SZWMCU	Workcenter Branch	String	Generic Edit	12	0	Allow NULL?
100	SZNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
101	SZCTS7	Amount - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
102	SZCTS8	Units - Unaccounted Scrap	Numeric	Generic Edit	15	2	Allow NULL?
103	SZSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
104	SZACTB	Activity-Based Costing Activity Code	String	Generic Edit	10	0	Allow NULL?
105	SZCTS9	Hours - Unaccounted Direct Labor	Numeric	Generic Edit	15	2	Allow NULL?
106	SZLABP	Run Labor - Rate	Numeric	Generic Edit	15	2	Allow NULL?
107	SZMACR	Run Machine - Rate	Numeric	Generic Edit	15	2	Allow NULL?
108	SZSETR	Setup Labor - Rate	Numeric	Generic Edit	15	2	Allow NULL?
109	SZAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
110	SZSEST	Time - Scheduled Start (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
111	SZSEET	Time - Scheduled End (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
112	SZTMCO	Time - Completed	Numeric	Generic Edit	6	0	Allow NULL?
113	SZD2J	Date - Actual Start	Date	Generic Edit	6	0
114	SZSTTI	Time - Start (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
115	SZCMPE	Competency Type	String	UDC (05 CY)	3	0	Allow NULL?
116	SZCMPC	Competency Code	String	Generic Edit	10	0	Allow NULL?
117	SZCPLVLFR	Competency Level From	Numeric	Generic Edit	6	3	Allow NULL?
118	SZCPLVLTO	Competency Level To	Numeric	Generic Edit	6	3	Allow NULL?
119	SZCMRQ	Rule Match Flag	Character	Generic Edit	1	0	Allow NULL?
120	SZANSA	Address Number - Manager	Numeric	Generic Edit	8	0	Allow NULL?
121	SZANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
122	SZANP	Address Number - Assigned To	Numeric	Generic Edit	8	0	Allow NULL?
123	SZWSCHF	Maintenance Schedule Flag	Character	UDC (13 WS)	1	0	Allow NULL?
124	SZTRAF	Resources Assigned	Character	UDC (00 ZO)	1	0	Allow NULL?

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

124 COLUMNS | 1 INDEXES | 812 | 31 | F3112Z1 TABLE

TOP 812 | 31 | F3112Z1 COLUMNS

TOP 812 | 31 | F3112Z1 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

124 COLUMNS | 1 INDEXES | 812 | 31 | F3112Z1 TABLE

TOP812 | 31 | F3112Z1 COLUMNS

TOP812 | 31 | F3112Z1 INDEXES

TOP 812 | 31 | F3112Z1 COLUMNS

TOP 812 | 31 | F3112Z1 INDEXES