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	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

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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger 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	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
47: Electronic Commerce
1	812	F47032	SZ	175	1	EDI Shipping Notice Detail - Inbound	Batch Input Files	43: Procurement	AS400 Coexistence Tables

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SZEDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
2	SZEDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
3	SZEKCO	Company - Key (EDI - Document Key Co)	String	Generic Edit	5	0	Allow NULL?
4	SZEDOC	EDI - Document Number	Numeric	Generic Edit	9	0	Allow NULL?
5	SZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
7	SZEDST	EDI - Transaction Set Number	String	UDC (40 ST)	6	0	Allow NULL?
8	SZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
9	SZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
10	SZEDER	EDI - Send/Receive Indicator	Character	UDC (H00 ED)	1	0	Allow NULL?
11	SZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
12	SZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
13	SZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
14	SZPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
15	SZSPID	Shipment I.D.	String	Generic Edit	20	0	Allow NULL?
16	SZHLVL	Hierarchical Level	Numeric	Generic Edit	1	0	Allow NULL?
17	SZHL03	Hierarchical Level Code	String	Generic Edit	2	0	Allow NULL?
18	SZKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
19	SZDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
20	SZDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
21	SZSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
22	SZLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
23	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
24	SZCO	Company	String	Generic Edit	5	0	Allow NULL?
25	SZOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
26	SZOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
27	SZOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
28	SZOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
29	SZRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
30	SZRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
31	SZRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
32	SZRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
33	SZDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
34	SZDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
35	SZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
36	SZSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
37	SZDRQJ	Date - Requested	Date	Generic Edit	6	0
38	SZTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
39	SZPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
40	SZADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
41	SZCNDJ	Date - Cancel	Date	Generic Edit	6	0
42	SZPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
43	SZDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
44	SZDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
45	SZVR01	Reference	String	Generic Edit	25	0	Allow NULL?
46	SZVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
47	SZITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
48	SZLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
49	SZAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
50	SZCITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
51	SZLOCN	Location	String	Generic Edit	20	0	Allow NULL?
52	SZLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
53	SZDSC1	Description	String	Generic Edit	30	0	Allow NULL?
54	SZDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
55	SZLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
56	SZRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
57	SZUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
58	SZUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
59	SZUCHG	Units - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
60	SZUOPN	Units - Open	Numeric	Generic Edit	15	2	Allow NULL?
61	SZUREC	Units - Received	Numeric	Generic Edit	15	2	Allow NULL?
62	SZPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
63	SZACHG	Amount - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
64	SZAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
65	SZAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
66	SZAMC3	Unit Cost - Purchasing	Numeric	Generic Edit	15	4	Allow NULL?
67	SZECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
68	SZCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
69	SZCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
70	SZCATN	Catalog	String	UDC (40 CN)	8	0	Allow NULL?
71	SZDSPR	Discount Factor	Numeric	Generic Edit	7	4	Allow NULL?
72	SZPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
73	SZTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
74	SZEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
75	SZTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
76	SZATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
77	SZCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
78	SZNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
79	SZFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
80	SZFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
81	SZZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
82	SZFRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
83	SZRATT	Rate Type - Freight/Misc	Character	Generic Edit	1	0	Allow NULL?
84	SZANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
85	SZANCR	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
86	SZMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
87	SZCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
88	SZSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
89	SZSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
90	SZUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
91	SZPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
92	SZUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
93	SZITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
94	SZWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
95	SZITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
96	SZVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
97	SZCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
98	SZFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
99	SZSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
100	SZRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
101	SZGRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
102	SZGWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
103	SZASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
104	SZTAG	Tag - Reference	String	Generic Edit	8	0	Allow NULL?
105	SZPL	Plan Number	String	Generic Edit	4	0	Allow NULL?
106	SZELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
107	SZAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
108	SZPRPY	Pre-Payment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
109	SZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
110	SZCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
111	SZFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
112	SZFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
113	SZFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
114	SZFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
115	SZFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
116	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
117	SZURDT	User Reserved Date	Date	Generic Edit	6	0
118	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
119	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
120	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
121	SZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
122	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
123	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
124	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
125	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
126	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
127	SZHLCF	Hierarchical Configuration	String	Generic Edit	18	0	Allow NULL?
128	SZHLSC	Hierarchical Structure Code	String	Generic Edit	4	0	Allow NULL?
129	SZPKCD	Packaging Code	String	UDC (41 X1)	5	0	Allow NULL?
130	SZWGQ	Weight Qualifier	String	UDC (41 X2)	2	0	Allow NULL?
131	SZWGTS	Shipment Weight	Numeric	Generic Edit	15	4	Allow NULL?
132	SZWGTU	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
133	SZIDQ1	Identifier Code Qualifier 1	String	UDC (41 X3)	2	0	Allow NULL?
134	SZID1	Identifier Code 1	String	Generic Edit	17	0	Allow NULL?
135	SZIDQ2	Identifier Code Qualifier 2	String	UDC (41 X3)	2	0	Allow NULL?
136	SZID2	Identifier Code 2	String	Generic Edit	17	0	Allow NULL?
137	SZROTE	Routing	String	Generic Edit	35	0	Allow NULL?
138	SZEQCD	Equipment Description Code	String	UDC (41 X5)	2	0	Allow NULL?
139	SZEQIN	Equipment Initial	String	Generic Edit	4	0	Allow NULL?
140	SZEQNB	Equipment Number	String	Generic Edit	10	0	Allow NULL?
141	SZRFQ1	Reference Number Qualifier 1	String	UDC (41 X6)	2	0	Allow NULL?
142	SZRF1	Reference Number 1	String	Generic Edit	30	0	Allow NULL?
143	SZRFQ2	Reference Number Qualifier 2	String	UDC (41 X6)	2	0	Allow NULL?
144	SZRF2	Reference Number 2	String	Generic Edit	30	0	Allow NULL?
145	SZPLT	SSCC Number - Tare Level	String	Generic Edit	18	0	Allow NULL?
146	SZPAK	SSCC Number - Pack Level	String	Generic Edit	18	0	Allow NULL?
147	SZSCCN	SCC Number	String	Generic Edit	14	0	Allow NULL?
148	SZSCCQ	SCC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
149	SZSCUM	SCC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
150	SZUPCN	UPC Number	String	Generic Edit	13	0	Allow NULL?
151	SZUPQT	UPC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
152	SZUPUM	UPC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
153	SZTXLN	Message Text Line	String	Generic Edit	60	0	Allow NULL?
154	SZDVAN	Address Number - Deliver To	Numeric	Generic Edit	8	0	Allow NULL?
155	SZBTAN	Address Number - Bill To	Numeric	Generic Edit	8	0	Allow NULL?
156	SZMKFR	Address Number - Mark-for	Numeric	Generic Edit	8	0	Allow NULL?
157	SZLDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
158	SZVR03	Reference	String	Generic Edit	25	0	Allow NULL?
159	SZMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
160	SZSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
161	SZADTM	Actual Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
162	SZOPTT	Time - Original Promised Delivery	Numeric	Generic Edit	6	0	Allow NULL?
163	SZPDTT	Time - Scheduled Pick	Numeric	Generic Edit	6	0	Allow NULL?
164	SZPMDT	Scheduled Shipment Time	Numeric	Generic Edit	6	0	Allow NULL?
165	SZPSTM	Time - Future Time 2	Numeric	Generic Edit	6	0	Allow NULL?
166	SZVRMK	Supplier Remark	String	Generic Edit	30	0	Allow NULL?
167	SZLOT1	Memo Lot 1	String	Generic Edit	30	0	Allow NULL?
168	SZLOT2	Memo Lot 2	String	Generic Edit	30	0	Allow NULL?
169	SZRLOT	Supplier Lot Number	String	Generic Edit	30	0	Allow NULL?
170	SZLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
171	SZMMEJ	Date - Lot Expiration	Date	Generic Edit	6	0
172	SZOUOM	Unit of Measure - Override	String	UDC (00 UM)	2	0	Allow NULL?
173	SZAUREC	Actual Quantity - Received	Numeric	Generic Edit	15	0	Allow NULL?
174	SZLDSC	Description - Lot	String	Generic Edit	30	0	Allow NULL?
175	SZCTSN	Container Serial Number	String	Generic Edit	40	0	Allow NULL?

Su	Mo	Tu	We	Th	Fr	Sa
		1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30

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

175 COLUMNS | 1 INDEXES | 812 | 47 | F47032 TABLE

TOP 812 | 47 | F47032 COLUMNS

TOP 812 | 47 | F47032 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

175 COLUMNS | 1 INDEXES | 812 | 47 | F47032 TABLE

TOP812 | 47 | F47032 COLUMNS

TOP812 | 47 | F47032 INDEXES

TOP 812 | 47 | F47032 COLUMNS

TOP 812 | 47 | F47032 INDEXES