	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

262 COLUMNS | 1 INDEXES | 920 | 41 | F4101Z1 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
41: Inventory Management
1	920	F4101Z1	SZ	262	1	F4101 Item Master Unedited Transaction Table	Master Files	41: Inventory Management	Business Data

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 SZEDUS, SZEDBT, SZEDTN, SZEDLN, SZEDCT, SZTYTN, SZEDFT, SZEDDT, SZDRIN, SZEDDL, SZEDSP, SZPNID, SZTNAC, SZITBR, SZITM, SZKIT, SZLITM, SZAITM, SZDSC1, SZDSC2, SZSRTX, SZALN, SZSRP1, SZSRP2, SZSRP3, SZSRP4, SZSRP5, SZSRP6, SZSRP7, SZSRP8, SZSRP9, SZSRP0, SZPRP1, SZPRP2, SZPRP3, SZPRP4, SZPRP5, SZPRP6, SZPRP7, SZPRP8, SZPRP9, SZPRP0, SZCDCD, SZPDGR, SZDSGP, SZPRGR, SZRPRC, SZORPR, SZBUYR, SZDRAW, SZRVNO, SZDSZE, SZVCUD, SZCARS, SZCARP, SZSHCN, SZSHCM, SZUOM1, SZUOM2, SZUOM3, SZUOM4, SZUOM6, SZUOM8, SZUOM9, SZUWUM, SZUVM1, SZSUTM, SZUMVW, SZCYCL, SZGLPT, SZPLEV, SZPPLV, SZCLEV, SZPRPO, SZCKAV, SZBPFG, SZSRCE, SZOT1Y, SZOT2Y, SZSTDP, SZFRMP, SZTHRP, SZSTDG, SZFRGD, SZTHGD, SZCOTY, SZSTKT, SZLNTY, SZCONT, SZBACK, SZIFLA, SZTFLA, SZINMG, SZABCS, SZABCM, SZABCI, SZOVR, SZWARR, SZCMCG, SZSRNR, SZPMTH, SZFIFO, SZLOTS, SZSLD, SZANPL, SZMPST, SZPCTM, SZMMPC, SZPTSC, SZSNS, SZLTLV, SZLTMF, SZLTCM, SZOPC, SZOPV, SZACQ, SZMLQ, SZLTPU, SZMPSP, SZMRPP, SZITC, SZORDW, SZMTF1, SZMTF2, SZMTF3, SZMTF4, SZMTF5, SZEXPD, SZDEFD, SZSFLT, SZMAKE, SZCOBY, SZLLX, SZCMGL, SZCOMH, SZAVRT, SZUPCN, SZSCC0, SZUMDF, SZUMS0, SZUMUP, SZUMS1, SZUMS2, SZUMS3, SZUMS4, SZUMS5, SZUMS6, SZUMS7, SZUMS8, SZWTRQ, SZEQTY, SZPOC, SZMCU, SZMMCU, SZVEND, SZORIG, SZROPI, SZROQI, SZRQMX, SZRQMN, SZWOMO, SZSERV, SZSAFE, SZFUF1, SZTX, SZTAX1, SZMRPD, SZMRPC, SZUPC, SZMERL, SZECO, SZECTY, SZECOD, SZMOVD, SZQUED, SZSETL, SZSRNK, SZSRKF, SZTIMB, SZBQTY, SZMULT, SZLFDJ, SZMLOT, SZLOCN, SZLOTN, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZSTAW, SZEFFT, SZDOC, SZDCT, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZTMPL, SZSEG1, SZSEG2, SZSEG3, SZSEG4, SZSEG5, SZSEG6, SZSEG7, SZSEG8, SZSEG9, SZSEG0, SZAING, SZCMDM, SZDPPO, SZDUAL, SZLECM, SZMIC, SZXDCK, SZDLTL, SZLEDD, SZPEFD, SZSBDD, SZU1DD, SZU2DD, SZU3DD, SZU4DD, SZU5DD, SZBBDD, SZLOTC, SZEXPI, SZCONB, SZPRI1, SZPRI2, SZGCMP, SZAPSC, SZCMETH, SZLAF, SZLTFM, SZRWLA, SZLNPA, SZASHL, SZVMINV, SZLTCV, SZOPTH, SZCUTH, SZUMTH, SZLMFG, SZLINE, SZDFTPCT, SZKBIT, SZDFENDITM, SZKANEXLL, SZSCPSELL, SZMOPTH, SZMCUTH, SZCUMTH, SZATPRN, SZATPCA, SZATPAC, SZCOORE, SZVCPFC, SZPNYN FROM F4101Z1

TOP 920 | 41 | F4101Z1 COLUMNS

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	SZITBR	Update Item Branch	Character	Generic Edit	1	0	Allow NULL?
15	SZITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
16	SZKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
17	SZLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
18	SZAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
19	SZDSC1	Description	String	Generic Edit	30	0	Allow NULL?
20	SZDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
21	SZSRTX	Search Text	String	Generic Edit	30	0	Allow NULL?
22	SZALN	Search Text - Compressed	String	Generic Edit	30	0	Allow NULL?
23	SZSRP1	Sales Catalog Section	String	UDC (41 S1)	3	0	Allow NULL?
24	SZSRP2	Sub Section	String	UDC (41 S2)	3	0	Allow NULL?
25	SZSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
26	SZSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
27	SZSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
28	SZSRP6	Category Code 6	String	UDC (41 06)	6	0	Allow NULL?
29	SZSRP7	Category Code 7	String	UDC (41 07)	6	0	Allow NULL?
30	SZSRP8	Category Code 8	String	UDC (41 08)	6	0	Allow NULL?
31	SZSRP9	Category Code 9	String	UDC (41 09)	6	0	Allow NULL?
32	SZSRP0	Category Code 10	String	UDC (41 10)	6	0	Allow NULL?
33	SZPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
34	SZPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
35	SZPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
36	SZPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
37	SZPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
38	SZPRP6	Group - Item Dimension	String	UDC (41 01)	6	0	Allow NULL?
39	SZPRP7	Group - Warehouse Process 1	String	UDC (41 02)	6	0	Allow NULL?
40	SZPRP8	Group - Warehouse Process 2	String	UDC (41 02)	6	0	Allow NULL?
41	SZPRP9	Group - Warehouse Process 3	String	UDC (41 02)	6	0	Allow NULL?
42	SZPRP0	Item Pool	String	UDC (41 05)	6	0	Allow NULL?
43	SZCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
44	SZPDGR	Product Group	String	UDC (41B PG)	3	0	Allow NULL?
45	SZDSGP	Dispatch Group	String	UDC (41B DG)	3	0	Allow NULL?
46	SZPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
47	SZRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
48	SZORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
49	SZBUYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
50	SZDRAW	Drawing Number	String	Generic Edit	20	0	Allow NULL?
51	SZRVNO	Last Revision No.	String	Generic Edit	2	0	Allow NULL?
52	SZDSZE	Drawing Size	Character	Generic Edit	1	0	Allow NULL?
53	SZVCUD	Cubic Dimensions - Volume	Numeric	Generic Edit	15	4	Allow NULL?
54	SZCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
55	SZCARP	Preferred Carrier - Purchasing	Numeric	Generic Edit	8	0	Allow NULL?
56	SZSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
57	SZSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
58	SZUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
59	SZUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
60	SZUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
61	SZUOM4	Unit of Measure - Pricing	String	UDC (00 UM)	2	0	Allow NULL?
62	SZUOM6	Unit of Measure - Shipping	String	UDC (00 UM)	2	0	Allow NULL?
63	SZUOM8	Unit of Measure - Production	String	UDC (00 UM)	2	0	Allow NULL?
64	SZUOM9	Unit of Measure - Component	String	UDC (00 UM)	2	0	Allow NULL?
65	SZUWUM	Unit of Measure - Weight	String	UDC (00 UM)	2	0	Allow NULL?
66	SZUVM1	Unit of Measure - Volume	String	UDC (00 UM)	2	0	Allow NULL?
67	SZSUTM	Unit of Measure - Stocking	String	UDC (00 UM)	2	0	Allow NULL?
68	SZUMVW	Unit of Measure - Volume or Weight	Character	UDC (39 VW)	1	0	Allow NULL?
69	SZCYCL	Cycle Count Category	String	UDC (41 8)	3	0	Allow NULL?
70	SZGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
71	SZPLEV	Level - Sales Base Price	Character	UDC (H40 PL)	1	0	Allow NULL?
72	SZPPLV	Level - Purchase Price	Character	UDC (H40 PP)	1	0	Allow NULL?
73	SZCLEV	Level - Inventory Cost	Character	UDC (H40 CL)	1	0	Allow NULL?
74	SZPRPO	Grade/Potency Pricing	Character	UDC (40 LP)	1	0	Allow NULL?
75	SZCKAV	Check Availability Y/N	Character	Generic Edit	1	0	Allow NULL?
76	SZBPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
77	SZSRCE	Layer Code - Source	Character	UDC (H41 SR)	1	0	Allow NULL?
78	SZOT1Y	Potency Control	Character	Generic Edit	1	0	Allow NULL?
79	SZOT2Y	Grade Control	Character	Generic Edit	1	0	Allow NULL?
80	SZSTDP	Standard Potency	Numeric	Generic Edit	7	3	Allow NULL?
81	SZFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
82	SZTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
83	SZSTDG	Standard Grade	String	UDC (40 LG)	3	0	Allow NULL?
84	SZFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
85	SZTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
86	SZCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
87	SZSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
88	SZLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
89	SZCONT	Contract - Item	Character	Generic Edit	1	0	Allow NULL?
90	SZBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
91	SZIFLA	Item Flash Message	String	UDC (40 FL)	2	0	Allow NULL?
92	SZTFLA	Standard Unit of Measure Conversion	String	UDC (H40 ST)	2	0	Allow NULL?
93	SZINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
94	SZABCS	ABC Code 1 - Sales - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
95	SZABCM	ABC Code 1 - Margin - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
96	SZABCI	ABC Code 3 - Investment - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
97	SZOVR	ABC Code Override Indicator	Character	Generic Edit	1	0	Allow NULL?
98	SZWARR	Type Warranty	String	Generic Edit	8	0	Allow NULL?
99	SZCMCG	Commission Category	String	Generic Edit	8	0	Allow NULL?
100	SZSRNR	Serial Number Required	Character	UDC (H41 NR)	1	0	Allow NULL?
101	SZPMTH	Method - Kit/Configurator Pricing	Character	UDC (H41 PM)	1	0	Allow NULL?
102	SZFIFO	FIFO Processing	Character	Generic Edit	1	0	Allow NULL?
103	SZLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
104	SZSLD	Days - Shelf Life Days	Numeric	Generic Edit	6	0	Allow NULL?
105	SZANPL	Planner Number	Numeric	Generic Edit	8	0	Allow NULL?
106	SZMPST	Planning Code	Character	UDC (H41 MP)	1	0	Allow NULL?
107	SZPCTM	Percent Margin	Numeric	Generic Edit	7	3	Allow NULL?
108	SZMMPC	Margin Maintenance (%)	Numeric	Generic Edit	7	3	Allow NULL?
109	SZPTSC	Material Status	String	UDC (40 PS)	2	0	Allow NULL?
110	SZSNS	Round to Whole Number	Character	UDC (H41 SN)	1	0	Allow NULL?
111	SZLTLV	Leadtime Level	Numeric	Generic Edit	5	0	Allow NULL?
112	SZLTMF	Leadtime MFG	Numeric	Generic Edit	5	0	Allow NULL?
113	SZLTCM	Leadtime Cumulative	Numeric	Generic Edit	5	0	Allow NULL?
114	SZOPC	Order Policy Code	Character	UDC (H41 OP)	1	0	Allow NULL?
115	SZOPV	Value - Order Policy	Numeric	Generic Edit	15	0	Allow NULL?
116	SZACQ	Quantity - Accounting Cost	Numeric	Generic Edit	15	0	Allow NULL?
117	SZMLQ	Quantity - MFG Leadtime	Numeric	Generic Edit	15	0	Allow NULL?
118	SZLTPU	Leadtime Per Unit	Numeric	Generic Edit	5	2	Allow NULL?
119	SZMPSP	Planning Time Fence Rule	Character	UDC (34 TF)	1	0	Allow NULL?
120	SZMRPP	Fixed or Variable Leadtime	Character	UDC (H41 MS)	1	0	Allow NULL?
121	SZITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
122	SZORDW	Order With	Character	Generic Edit	1	0	Allow NULL?
123	SZMTF1	Planning Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
124	SZMTF2	Freeze Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
125	SZMTF3	Message Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
126	SZMTF4	MPS/MRP Time Fence 4	Numeric	Generic Edit	5	0	Allow NULL?
127	SZMTF5	Shipment Leadtime Offset	Numeric	Generic Edit	5	0	Allow NULL?
128	SZEXPD	Expedite Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
129	SZDEFD	Defer Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
130	SZSFLT	Safety Leadtime	Numeric	Generic Edit	5	0	Allow NULL?
131	SZMAKE	Make/Buy Code	Character	UDC (H40 MA)	1	0	Allow NULL?
132	SZCOBY	Co-Products/By-Products/Intermediate	Character	UDC (H40 CO)	1	0	Allow NULL?
133	SZLLX	Low Level Code	Numeric	Generic Edit	3	0	Allow NULL?
134	SZCMGL	Commitment Method	Character	UDC (H40 CM)	1	0	Allow NULL?
135	SZCOMH	Commitment - Specific (Days)	Numeric	Generic Edit	3	0	Allow NULL?
136	SZAVRT	Replenishment Hours - Standard	Numeric	Generic Edit	15	2	Allow NULL?
137	SZUPCN	UPC Number	String	Generic Edit	13	0	Allow NULL?
138	SZSCC0	Aggregate SCC Code (PI=0)	String	Generic Edit	14	0	Allow NULL?
139	SZUMDF	Unit of Measure - Aggregate UPC	String	UDC (00 UM)	2	0	Allow NULL?
140	SZUMS0	Unit of Measure - SCC(PI=0)	String	UDC (00 UM)	2	0	Allow NULL?
141	SZUMUP	Unit of Measure - UPC	String	UDC (00 UM)	2	0	Allow NULL?
142	SZUMS1	Unit of Measure - SCC(PI=1)	String	UDC (00 UM)	2	0	Allow NULL?
143	SZUMS2	Unit of Measure - SCC(PI=2)	String	UDC (00 UM)	2	0	Allow NULL?
144	SZUMS3	Unit of Measure - SCC(PI=3)	String	UDC (00 UM)	2	0	Allow NULL?
145	SZUMS4	Unit of Measure - SCC(PI=4)	String	UDC (00 UM)	2	0	Allow NULL?
146	SZUMS5	Unit of Measure - SCC(PI=5)	String	UDC (00 UM)	2	0	Allow NULL?
147	SZUMS6	Unit of Measure - SCC(PI=6)	String	UDC (00 UM)	2	0	Allow NULL?
148	SZUMS7	Unit of Measure - SCC(PI=7)	String	UDC (00 UM)	2	0	Allow NULL?
149	SZUMS8	Unit of Measure - SCC(PI=8)	String	UDC (00 UM)	2	0	Allow NULL?
150	SZWTRQ	Item Weight Required Y/N	Character	Generic Edit	1	0	Allow NULL?
151	SZEQTY	Container Code	String	UDC (46 EQ)	5	0	Allow NULL?
152	SZPOC	Issue and Receipt	Character	UDC (43 IR)	1	0	Allow NULL?
153	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
154	SZMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
155	SZVEND	Primary / Last Supplier Number	Numeric	Generic Edit	8	0	Allow NULL?
156	SZORIG	Country of Origin	String	UDC (00 CN)	3	0	Allow NULL?
157	SZROPI	Reorder Point - Input	Numeric	Generic Edit	15	0	Allow NULL?
158	SZROQI	Reorder Quantity - Input	Numeric	Generic Edit	15	0	Allow NULL?
159	SZRQMX	Reorder Quantity - Maximum	Numeric	Generic Edit	15	0	Allow NULL?
160	SZRQMN	Reorder Quantity - Minimum	Numeric	Generic Edit	15	0	Allow NULL?
161	SZWOMO	Quantity - Order Multiples (SO/PO)	Numeric	Generic Edit	7	0	Allow NULL?
162	SZSERV	Service Level	Numeric	Generic Edit	7	0	Allow NULL?
163	SZSAFE	Safety Stock	Numeric	Generic Edit	15	0	Allow NULL?
164	SZFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
165	SZTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
166	SZTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
167	SZMRPD	Item Display Code	Character	UDC (H41 MR)	1	0	Allow NULL?
168	SZMRPC	Flag - Net Change	Character	UDC (H41 MQ)	1	0	Allow NULL?
169	SZUPC	Units - Per Container	Numeric	Generic Edit	15	0	Allow NULL?
170	SZMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
171	SZECO	ECO Number	String	Generic Edit	12	0	Allow NULL?
172	SZECTY	Engineering Change Reason	String	UDC (40 CR)	2	0	Allow NULL?
173	SZECOD	Date - Engineering Change Date	Date	Generic Edit	6	0
174	SZMOVD	Move Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
175	SZQUED	Queue Hours - Standard	Numeric	Generic Edit	5	2	Allow NULL?
176	SZSETL	Setup Labor - Standard	Numeric	Generic Edit	15	2	Allow NULL?
177	SZSRNK	Shrink Factor	Numeric	Generic Edit	15	2	Allow NULL?
178	SZSRKF	Shrink Factor Method	Character	UDC (H40 SR)	1	0	Allow NULL?
179	SZTIMB	Time Basis Code	Character	UDC (30 TB)	1	0	Allow NULL?
180	SZBQTY	Units - Batch Quantity	Numeric	Generic Edit	15	0	Allow NULL?
181	SZMULT	Quantity - Order Multiples (MRP)	Numeric	Generic Edit	15	0	Allow NULL?
182	SZLFDJ	Date - Future Use	Date	Generic Edit	6	0
183	SZMLOT	Mix Dates / Lots (Y/N)	Character	Generic Edit	1	0	Allow NULL?
184	SZLOCN	Location	String	Generic Edit	20	0	Allow NULL?
185	SZLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
186	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
187	SZURDT	User Reserved Date	Date	Generic Edit	6	0
188	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
189	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
190	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
191	SZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
192	SZSTAW	Status	Character	UDC (00 WS)	1	0	Allow NULL?
193	SZEFFT	Effective - Thru Date	Date	Generic Edit	6	0
194	SZDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
195	SZDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
196	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
197	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
198	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
199	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
200	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
201	SZTMPL	Template	String	Generic Edit	20	0	Allow NULL?
202	SZSEG1	Segment 1	String	Generic Edit	10	0	Allow NULL?
203	SZSEG2	Segment 2	String	Generic Edit	10	0	Allow NULL?
204	SZSEG3	Segment 3	String	Generic Edit	10	0	Allow NULL?
205	SZSEG4	Segment 4	String	Generic Edit	10	0	Allow NULL?
206	SZSEG5	Segment 5	String	Generic Edit	10	0	Allow NULL?
207	SZSEG6	Segment 6	String	Generic Edit	10	0	Allow NULL?
208	SZSEG7	Segment 7	String	Generic Edit	10	0	Allow NULL?
209	SZSEG8	Segment 8	String	Generic Edit	10	0	Allow NULL?
210	SZSEG9	Segment 9	String	Generic Edit	10	0	Allow NULL?
211	SZSEG0	Segment 10	String	Generic Edit	10	0	Allow NULL?
212	SZAING	Active Ingredient Flag	Character	Generic Edit	1	0	Allow NULL?
213	SZCMDM	Commitment Date Method	Character	UDC (H40 CD)	1	0	Allow NULL?
214	SZDPPO	Dual Picking Process Option	Character	Generic Edit	1	0	Allow NULL?
215	SZDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
216	SZLECM	Lot Expiraton Date Calculation Method	Character	UDC (H41 EC)	1	0	Allow NULL?
217	SZMIC	Matrix Controlled	Character	UDC (41 MA)	1	0	Allow NULL?
218	SZXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
219	SZDLTL	Dual Tolerance	Numeric	Generic Edit	7	2	Allow NULL?
220	SZLEDD	Lot Effective Default Days	Numeric	Generic Edit	6	0	Allow NULL?
221	SZPEFD	Purchasing Effective Days	Numeric	Generic Edit	6	0	Allow NULL?
222	SZSBDD	Sell By Default Days	Numeric	Generic Edit	6	0	Allow NULL?
223	SZU1DD	User Lot Date 1 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
224	SZU2DD	User Lot Date 2 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
225	SZU3DD	User Lot Date 3 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
226	SZU4DD	User Lot Date 4 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
227	SZU5DD	User Lot Date 5 Default Days	Numeric	Generic Edit	6	0	Allow NULL?
228	SZBBDD	Best Before Default Days	Numeric	Generic Edit	6	0	Allow NULL?
229	SZLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
230	SZEXPI	Explode Item (1/0)	Character	Generic Edit	1	0	Allow NULL?
231	SZCONB	Consumable	Character	Generic Edit	1	0	Allow NULL?
232	SZPRI1	Priority One Alert Level	Numeric	Generic Edit	15	4	Allow NULL?
233	SZPRI2	Priority Two Alert Level	Numeric	Generic Edit	15	4	Allow NULL?
234	SZGCMP	Composition	Character	Generic Edit	1	0	Allow NULL?
235	SZAPSC	Constraints Flag	Character	UDC (42 AC)	1	0	Allow NULL?
236	SZCMETH	Method - Configurator Costing	Character	UDC (41 CM)	1	0	Allow NULL?
237	SZLAF	Lot Audit Flag	Character	Generic Edit	1	0	Allow NULL?
238	SZLTFM	Special Lot Format	Character	Generic Edit	1	0	Allow NULL?
239	SZRWLA	Restrict Work Order Lot Assignment	Character	Generic Edit	1	0	Allow NULL?
240	SZLNPA	Lot Number Pre-Assignment	Character	Generic Edit	1	0	Allow NULL?
241	SZASHL	Allow Shipping of Held Lots	Character	Generic Edit	1	0	Allow NULL?
242	SZVMINV	Vendor Managed Inventory	Character	Generic Edit	1	0	Allow NULL?
243	SZLTCV	Leadtime Conversion Factor	Numeric	Generic Edit	15	7	Allow NULL?
244	SZOPTH	Minimum Operational Threshold	Numeric	Generic Edit	15	4	Allow NULL?
245	SZCUTH	Minimum Cumulative Threshold	Numeric	Generic Edit	15	4	Allow NULL?
246	SZUMTH	Operational Threshold Unit of Measure	String	UDC (31B UM)	3	0	Allow NULL?
247	SZLMFG	Lean Manufacturing Flag	Character	Generic Edit	1	0	Allow NULL?
248	SZLINE	Line/Cell Identifier	String	Generic Edit	12	0	Allow NULL?
249	SZDFTPCT	Total Product Cycle Time	Numeric	Generic Edit	20	5	Allow NULL?
250	SZKBIT	Kanban Item	Character	Generic Edit	1	0	Allow NULL?
251	SZDFENDITM	Demand Flow End Item Flag	Character	Generic Edit	1	0	Allow NULL?
252	SZKANEXLL	Kanban Explode to Lower Level	Character	Generic Edit	1	0	Allow NULL?
253	SZSCPSELL	Sellable Item	Character	UDC (34A SA)	1	0	Allow NULL?
254	SZMOPTH	Maximum Operational Threshold	Numeric	Generic Edit	15	4	Allow NULL?
255	SZMCUTH	Maximum Cumulative Threshold	Numeric	Generic Edit	15	4	Allow NULL?
256	SZCUMTH	Cumulative Threshold Unit of Measure	String	UDC (31B UM)	3	0	Allow NULL?
257	SZATPRN	ATP Rule Name	String	Generic Edit	80	0	Allow NULL?
258	SZATPCA	Check ATP	Character	UDC (34A CA)	1	0	Allow NULL?
259	SZATPAC	ATP Components	String	UDC (34A AP)	5	0	Allow NULL?
260	SZCOORE	Country of Origin Required Flag	Character	Generic Edit	1	0	Allow NULL?
261	SZVCPFC	ATO Forecast Control	String	UDC (34A CF)	20	0	Allow NULL?
262	SZPNYN	Production Number Controlled	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 41 | F4101Z1 INDEXES

Number

Description

User Batch Trans No Line No (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line 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

262 COLUMNS | 1 INDEXES | 920 | 41 | F4101Z1 TABLE

TOP 920 | 41 | F4101Z1 COLUMNS

TOP 920 | 41 | F4101Z1 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

262 COLUMNS | 1 INDEXES | 920 | 41 | F4101Z1 TABLE

TOP920 | 41 | F4101Z1 COLUMNS

TOP920 | 41 | F4101Z1 INDEXES

TOP 920 | 41 | F4101Z1 COLUMNS

TOP 920 | 41 | F4101Z1 INDEXES