	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

246 COLUMNS | 2 INDEXES | 812 | 41 | F41UI001 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
41: Inventory Management
1	812	F41UI001	IT	246	2	Inventory Transactions Detail File	"T" Work Files	41: Inventory Management	No

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 ITCTID, ITJOBS, ITLNID, ITNLIN, ITACTN, ITDOC, ITDCT, ITKCO, ITSFX, ITICU, ITICUT, ITIST, ITITM, ITLITM, ITAITM, ITMCU, ITLOCN, ITLOTN, ITTRQT, ITUNCS, ITPAID, ITPRRC, ITTRUM, ITTRDJ, ITDGL, ITGLPT, ITPLOT, ITLDSQ, ITTRNO, ITFRTO, ITLMCX, ITLOTS, ITLOTP, ITLOTG, ITKIT, ITMMCU, ITDMCT, ITDMCS, ITBALU, ITDCTO, ITDOCO, ITKCOO, ITSFXO, ITIPCD, ITAN8, ITTREF, ITTREX, ITRCD, ITSRP1, ITSRP2, ITSRP3, ITSRP4, ITSRP5, ITSRP6, ITSRP7, ITSRP8, ITSRP9, ITSRP0, ITPRP1, ITPRP2, ITPRP3, ITPRP4, ITPRP5, ITPRP6, ITPRP7, ITPRP8, ITPRP9, ITPRP0, ITFIFO, ITBUYR, ITPRGR, ITRPRC, ITORPR, ITCARP, ITCARS, ITSHCN, ITSHCM, ITCYCL, ITSTKT, ITBACK, ITINMG, ITABCS, ITABCM, ITABCI, ITOVR, ITSRNR, ITTAX1, ITLTLV, ITLTMF, ITLTCM, ITANPL, ITOPC, ITOPV, ITACQ, ITMLQ, ITLLX, ITLTPU, ITMPST, ITMPSP, ITMRPP, ITSLD, ITITC, ITSNS, ITPCTM, ITMMPC, ITCDCD, ITSTDP, ITFRMP, ITCOTY, ITTHRP, ITOT1Y, ITOT2Y, ITFRGD, ITTHGD, ITSTDG, ITORDW, ITMTF1, ITMTF2, ITMTF3, ITMTF4, ITMTF5, ITEXPD, ITDEFD, ITSFLT, ITMAKE, ITSRCE, ITPBIN, ITPQOH, ITPBCK, ITPREQ, ITQWBO, ITOT1P, ITOT2P, ITOT1A, ITHCOM, ITPCOM, ITFCOM, ITFUN1, ITQOWO, ITQTTR, ITQTIN, ITQTO1, ITQTO2, ITQONL, ITQTRI, ITQTRO, ITQTY1, ITQTY2, ITLRCJ, ITNCDJ, ITURCD, ITURDT, ITURAT, ITURAB, ITURRF, ITLDSC, ITMMEJ, ITPN, ITFY, ITDSC1, ITCLEV, ITPLEV, ITUOM1, ITLEDG, ITANI, ITSBL, ITSBLT, ITWR01, ITASII, ITICOS, ITLQOH, ITTQOH, ITTVIA, ITLINN, ITVARA, ITCSMT, ITPCSM, ITCSMF, ITPCSF, ITABRN, ITALON, ITACOS, ITAPRI, ITRLOT, ITLOT1, ITLOT2, ITLOT3, ITMCUF, ITLOTF, ITLOCF, ITFTRN, ITENTC, ITAEXP, ITCYNO, ITTGG, ITSLAT, ITSDCT, ITJEL1, ITJEL2, ITJEL3, ITJEL4, ITJEL5, ITJEL6, ITVUIL, ITBPFG, ITOT5Y, ITAGSQ, ITMODE, ITDTO, ITPSR, ITPSRY, ITSHAN, ITDSC2, ITDUAL, ITSREQ, ITSQWO, ITHCMS, ITSCMS, ITSWSC, ITSWHC, ITSIBW, ITSOBW, ITUOM2, ITBODJ, ITOHDJ, ITDLEJ, ITSBDJ, ITBBDJ, ITU1DJ, ITU2DJ, ITU3DJ, ITU4DJ, ITU5DJ, ITLOTC, ITPJCM, ITPRJM, ITCFGSID, ITPJDM, ITCCFL, ITDOC1, ITCONV, ITCNV1, ITJEL7, ITJEL8, ITTGN, ITRFLN FROM F41UI001

TOP 812 | 41 | F41UI001 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	ITCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	ITJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	ITLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
4	ITNLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
5	ITACTN	Action Code	Character	Generic Edit	1	0	Allow NULL?
6	ITDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
7	ITDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
8	ITKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
9	ITSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
10	ITICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
11	ITICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
12	ITIST	Batch Status	Character	UDC (98 IC)	1	0	Allow NULL?
13	ITITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
14	ITLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
15	ITAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
16	ITMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
17	ITLOCN	Location	String	Generic Edit	20	0	Allow NULL?
18	ITLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
19	ITTRQT	Quantity Available	Numeric	Generic Edit	15	2	Allow NULL?
20	ITUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
21	ITPAID	Amount - Extended Cost/Price	Numeric	Generic Edit	15	2	Allow NULL?
22	ITPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
23	ITTRUM	Unit of Measure - Transaction	String	UDC (00 UM)	2	0	Allow NULL?
24	ITTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
25	ITDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
26	ITGLPT	Category - G/L	String	UDC (41 9)	4	0	Allow NULL?
27	ITPLOT	Parent Lot	String	Generic Edit	30	0	Allow NULL?
28	ITLDSQ	Sequence Number - Location Detail	Numeric	Generic Edit	8	0	Allow NULL?
29	ITTRNO	Transaction Line Number	Numeric	Generic Edit	5	0	Allow NULL?
30	ITFRTO	From/To	Character	Generic Edit	1	0	Allow NULL?
31	ITLMCX	Lot Master Cardex (Y/N)	Character	Generic Edit	1	0	Allow NULL?
32	ITLOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
33	ITLOTP	Lot Potency	Numeric	Generic Edit	15	3	Allow NULL?
34	ITLOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
35	ITKIT	Parent (short) Item Number	Numeric	Generic Edit	8	0	Allow NULL?
36	ITMMCU	Branch	String	Generic Edit	12	0	Allow NULL?
37	ITDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
38	ITDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
39	ITBALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
40	ITDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
41	ITDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
42	ITKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
43	ITSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
44	ITIPCD	As Of Posted Code	Character	UDC (H41 IP)	1	0	Allow NULL?
45	ITAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
46	ITTREF	Transaction Reference	String	Generic Edit	8	0	Allow NULL?
47	ITTREX	Explanation - Transaction	String	Generic Edit	30	0	Allow NULL?
48	ITRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
49	ITSRP1	Sales Rpt 01 - Product Family	String	UDC (41 S1)	3	0	Allow NULL?
50	ITSRP2	Sales Rpt 02 - Family Section	String	UDC (41 S2)	3	0	Allow NULL?
51	ITSRP3	Sales Category Code 3	String	UDC (41 S3)	3	0	Allow NULL?
52	ITSRP4	Sales Category Code 4	String	UDC (41 S4)	3	0	Allow NULL?
53	ITSRP5	Sales Category Code 5	String	UDC (41 S5)	3	0	Allow NULL?
54	ITSRP6	Sales Rpt 06 - Product Line (Revenue)	String	UDC (41 06)	6	0	Allow NULL?
55	ITSRP7	Category Code 7	String	UDC (41 07)	6	0	Allow NULL?
56	ITSRP8	Sales Rpt 08 - Product Discount Group	String	UDC (41 08)	6	0	Allow NULL?
57	ITSRP9	Category Code 9	String	UDC (41 09)	6	0	Allow NULL?
58	ITSRP0	Category Code 10	String	UDC (41 10)	6	0	Allow NULL?
59	ITPRP1	Commodity Class	String	UDC (41 P1)	3	0	Allow NULL?
60	ITPRP2	Commodity Sub Class	String	UDC (41 P2)	3	0	Allow NULL?
61	ITPRP3	Supplier Rebate Code	String	UDC (41 P3)	3	0	Allow NULL?
62	ITPRP4	Master Planning Family	String	UDC (41 P4)	3	0	Allow NULL?
63	ITPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
64	ITPRP6	Group - Item Dimension	String	UDC (41 01)	6	0	Allow NULL?
65	ITPRP7	Group - Warehouse Process 1	String	UDC (41 02)	6	0	Allow NULL?
66	ITPRP8	Group - Warehouse Process 2	String	UDC (41 02)	6	0	Allow NULL?
67	ITPRP9	Group - Warehouse Process 3	String	UDC (41 02)	6	0	Allow NULL?
68	ITPRP0	Item Pool	String	UDC (41 05)	6	0	Allow NULL?
69	ITFIFO	FIFO Processing	Character	Generic Edit	1	0	Allow NULL?
70	ITBUYR	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
71	ITPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
72	ITRPRC	Reprice (Basket Price) Category	String	UDC (40 PI)	8	0	Allow NULL?
73	ITORPR	Order Reprice Category	String	UDC (40 PI)	8	0	Allow NULL?
74	ITCARP	Preferred Carrier - Purchasing	Numeric	Generic Edit	8	0	Allow NULL?
75	ITCARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
76	ITSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
77	ITSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
78	ITCYCL	Cycle Count Category	String	UDC (41 8)	3	0	Allow NULL?
79	ITSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
80	ITBACK	Backorders Allowed (Y/N)	Character	Generic Edit	1	0	Allow NULL?
81	ITINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
82	ITABCS	ABC Code 1 - Sales - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
83	ITABCM	ABC Code 1 - Margin - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
84	ITABCI	ABC Code 3 - Investment - Inventory	Character	UDC (H41 AB)	1	0	Allow NULL?
85	ITOVR	ABC Code Override Indicator	Character	Generic Edit	1	0	Allow NULL?
86	ITSRNR	Serial Number Required	Character	UDC (H41 NR)	1	0	Allow NULL?
87	ITTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
88	ITLTLV	Leadtime Level	Numeric	Generic Edit	5	0	Allow NULL?
89	ITLTMF	Leadtime MFG	Numeric	Generic Edit	5	0	Allow NULL?
90	ITLTCM	Leadtime Cumulative	Numeric	Generic Edit	5	0	Allow NULL?
91	ITANPL	Planner Number	Numeric	Generic Edit	8	0	Allow NULL?
92	ITOPC	Order Policy Code	Character	UDC (H41 OP)	1	0	Allow NULL?
93	ITOPV	Value - Order Policy	Numeric	Generic Edit	15	0	Allow NULL?
94	ITACQ	Quantity - Accounting Cost	Numeric	Generic Edit	15	2	Allow NULL?
95	ITMLQ	Quantity - MFG Leadtime	Numeric	Generic Edit	15	2	Allow NULL?
96	ITLLX	Low Level Code	Numeric	Generic Edit	3	0	Allow NULL?
97	ITLTPU	Leadtime Per Unit	Numeric	Generic Edit	5	2	Allow NULL?
98	ITMPST	Planning Code	Character	UDC (H41 MP)	1	0	Allow NULL?
99	ITMPSP	Planning Time Fence Rule	Character	UDC (34 TF)	1	0	Allow NULL?
100	ITMRPP	Fixed or Variable Leadtime	Character	UDC (H41 MS)	1	0	Allow NULL?
101	ITSLD	Days - Shelf Life Days	Numeric	Generic Edit	6	0	Allow NULL?
102	ITITC	Issue Type Code	Character	UDC (41 IT)	1	0	Allow NULL?
103	ITSNS	Round to Whole Number	Character	UDC (H41 SN)	1	0	Allow NULL?
104	ITPCTM	Percent Margin	Numeric	Generic Edit	7	3	Allow NULL?
105	ITMMPC	Margin Maintenance (%)	Numeric	Generic Edit	7	3	Allow NULL?
106	ITCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
107	ITSTDP	Standard Potency	Numeric	Generic Edit	7	3	Allow NULL?
108	ITFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
109	ITCOTY	Component Type	Character	UDC (H40 CP)	1	0	Allow NULL?
110	ITTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
111	ITOT1Y	Potency Control	Character	Generic Edit	1	0	Allow NULL?
112	ITOT2Y	Grade Control	Character	Generic Edit	1	0	Allow NULL?
113	ITFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
114	ITTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
115	ITSTDG	Standard Grade	String	UDC (40 LG)	3	0	Allow NULL?
116	ITORDW	Order With	Character	Generic Edit	1	0	Allow NULL?
117	ITMTF1	Planning Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
118	ITMTF2	Freeze Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
119	ITMTF3	Message Time Fence Days	Numeric	Generic Edit	5	0	Allow NULL?
120	ITMTF4	MPS/MRP Time Fence 4	Numeric	Generic Edit	5	0	Allow NULL?
121	ITMTF5	Shipment Leadtime Offset	Numeric	Generic Edit	5	0	Allow NULL?
122	ITEXPD	Expedite Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
123	ITDEFD	Defer Damper Days	Numeric	Generic Edit	5	0	Allow NULL?
124	ITSFLT	Safety Leadtime	Numeric	Generic Edit	5	0	Allow NULL?
125	ITMAKE	Make/Buy Code	Character	UDC (H40 MA)	1	0	Allow NULL?
126	ITSRCE	Layer Code - Source	Character	UDC (H41 SR)	1	0	Allow NULL?
127	ITPBIN	Primary Location (P/S)	Character	Generic Edit	1	0	Allow NULL?
128	ITPQOH	Quantity on Hand - Primary units	Numeric	Generic Edit	15	2	Allow NULL?
129	ITPBCK	Quantity on Backorder	Numeric	Generic Edit	15	2	Allow NULL?
130	ITPREQ	Quantity on Purchase Order-primary units	Numeric	Generic Edit	15	2	Allow NULL?
131	ITQWBO	Quantity on Work Order Receipt	Numeric	Generic Edit	15	2	Allow NULL?
132	ITOT1P	Quantity 1 - Other primary units	Numeric	Generic Edit	15	2	Allow NULL?
133	ITOT2P	Quantity 2 - Other primary units	Numeric	Generic Edit	15	2	Allow NULL?
134	ITOT1A	Quantity - Other Purchasing 1	Numeric	Generic Edit	15	2	Allow NULL?
135	ITHCOM	Quantity - Hard Committed	Numeric	Generic Edit	15	2	Allow NULL?
136	ITPCOM	Quantity Soft Committed	Numeric	Generic Edit	15	2	Allow NULL?
137	ITFCOM	Quantity on Future Commit	Numeric	Generic Edit	15	2	Allow NULL?
138	ITFUN1	Quantity - Work Order Soft Commit	Numeric	Generic Edit	15	2	Allow NULL?
139	ITQOWO	Quantity - Work Order Hard Commit	Numeric	Generic Edit	15	2	Allow NULL?
140	ITQTTR	Units - In Transit - Primary units	Numeric	Generic Edit	15	2	Allow NULL?
141	ITQTIN	Units - In Inspection - Primary units	Numeric	Generic Edit	15	2	Allow NULL?
142	ITQTO1	Units - In Operation 1 - Primary units	Numeric	Generic Edit	15	2	Allow NULL?
143	ITQTO2	Units - In Operation 2 - Primary units	Numeric	Generic Edit	15	2	Allow NULL?
144	ITQONL	Quantity - On Loan to Manufacturing	Numeric	Generic Edit	15	2	Allow NULL?
145	ITQTRI	Quantity Inbound - Warehouse	Numeric	Generic Edit	15	2	Allow NULL?
146	ITQTRO	Quantity Outbound - Warehouse	Numeric	Generic Edit	15	2	Allow NULL?
147	ITQTY1	Future Use Quantity	Numeric	Generic Edit	15	0	Allow NULL?
148	ITQTY2	Future Use Quantity 2	Numeric	Generic Edit	15	0	Allow NULL?
149	ITLRCJ	Date - Last Receipt (Julian)	Date	Generic Edit	6	0
150	ITNCDJ	Date - Next Count (Julian)	Date	Generic Edit	6	0
151	ITURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
152	ITURDT	User Reserved Date	Date	Generic Edit	6	0
153	ITURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
154	ITURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
155	ITURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
156	ITLDSC	Description - Lot	String	Generic Edit	30	0	Allow NULL?
157	ITMMEJ	Date - Lot Expiration	Date	Generic Edit	6	0
158	ITPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
159	ITFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
160	ITDSC1	Description	String	Generic Edit	30	0	Allow NULL?
161	ITCLEV	Level - Inventory Cost	Character	UDC (H40 CL)	1	0	Allow NULL?
162	ITPLEV	Level - Sales Base Price	Character	UDC (H40 PL)	1	0	Allow NULL?
163	ITUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
164	ITLEDG	Cost Method	String	UDC (40 CM)	2	0	Allow NULL?
165	ITANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
166	ITSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
167	ITSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
168	ITWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
169	ITASII	Asset Number-Input	String	Generic Edit	26	0	Allow NULL?
170	ITICOS	Amount - Inventory Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
171	ITLQOH	Quantity on Hand - Location	Numeric	Generic Edit	15	2	Allow NULL?
172	ITTQOH	Quantity - Total Primary on Hand	Numeric	Generic Edit	15	2	Allow NULL?
173	ITTVIA	Amount - Variance	Numeric	Generic Edit	15	2	Allow NULL?
174	ITLINN	Line Number	Numeric	Generic Edit	7	3	Allow NULL?
175	ITVARA	Amount - Variance	Numeric	Generic Edit	15	2	Allow NULL?
176	ITCSMT	Costing Method - Sales	String	UDC (40 CM)	2	0	Allow NULL?
177	ITPCSM	Costing Method - Purchasing	String	UDC (40 CM)	2	0	Allow NULL?
178	ITCSMF	Costing Method - Sales - From	String	UDC (40 CM)	2	0	Allow NULL?
179	ITPCSF	Costing Method - Purchasing - From	String	UDC (40 CM)	2	0	Allow NULL?
180	ITABRN	Add Branch Record	Character	Generic Edit	1	0	Allow NULL?
181	ITALON	Add Location Record	Character	Generic Edit	1	0	Allow NULL?
182	ITACOS	Add Cost Record	Character	Generic Edit	1	0	Allow NULL?
183	ITAPRI	Add Base Price Record	Character	Generic Edit	1	0	Allow NULL?
184	ITRLOT	Supplier Lot Number	String	Generic Edit	30	0	Allow NULL?
185	ITLOT1	Memo Lot 1	String	Generic Edit	30	0	Allow NULL?
186	ITLOT2	Memo Lot 2	String	Generic Edit	30	0	Allow NULL?
187	ITLOT3	Memo Lot 3	String	Generic Edit	30	0	Allow NULL?
188	ITMCUF	BU - From	String	Generic Edit	12	0	Allow NULL?
189	ITLOTF	Lot - From	String	Generic Edit	30	0	Allow NULL?
190	ITLOCF	Location - From	String	Generic Edit	20	0	Allow NULL?
191	ITFTRN	From Transaction	Character	Generic Edit	1	0	Allow NULL?
192	ITENTC	Cost Entered	Character	Generic Edit	1	0	Allow NULL?
193	ITAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
194	ITCYNO	Cycle Count Number	Numeric	Generic Edit	8	0	Allow NULL?
195	ITTGG	Tag Number	Numeric	Generic Edit	8	0	Allow NULL?
196	ITSLAT	Scrapped Amount	Numeric	Generic Edit	15	4	Allow NULL?
197	ITSDCT	Sales Document Type	String	UDC (00 DT)	2	0	Allow NULL?
198	ITJEL1	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
199	ITJEL2	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
200	ITJEL3	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
201	ITJEL4	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
202	ITJEL5	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
203	ITJEL6	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
204	ITVUIL	Void Update Item ledger	Character	Generic Edit	1	0	Allow NULL?
205	ITBPFG	Bulk/Packed Flag	Character	UDC (41B BF)	1	0	Allow NULL?
206	ITOT5Y	Detail Costing Flag	Character	Generic Edit	1	0	Allow NULL?
207	ITAGSQ	Agreement Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
208	ITMODE	Mode - Processing	Character	Generic Edit	1	0	Allow NULL?
209	ITDTO	Due To	Character	UDC (38 DT)	1	0	Allow NULL?
210	ITPSR	Source	String	Generic Edit	12	0	Allow NULL?
211	ITPSRY	Source Type	String	UDC (38 DY)	2	0	Allow NULL?
212	ITSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
213	ITDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
214	ITDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
215	ITSREQ	Quantity on Purchase Order - Secondary	Numeric	Generic Edit	15	0	Allow NULL?
216	ITSQWO	Secondary Quantity on Work Order Receipt	Numeric	Generic Edit	15	0	Allow NULL?
217	ITHCMS	Secondary Quantity Hard Committed	Numeric	Generic Edit	15	0	Allow NULL?
218	ITSCMS	Secondary Quantity Soft Committed	Numeric	Generic Edit	15	0	Allow NULL?
219	ITSWSC	SecondaryQuantity W.O. Soft Commit	Numeric	Generic Edit	15	0	Allow NULL?
220	ITSWHC	Secondary Quantity WO Hard Commit	Numeric	Generic Edit	15	0	Allow NULL?
221	ITSIBW	Secondary Quantity Inbound - Warehouse	Numeric	Generic Edit	15	0	Allow NULL?
222	ITSOBW	Secondary Quantity Outbound - Warehouse	Numeric	Generic Edit	15	0	Allow NULL?
223	ITUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
224	ITBODJ	Based On Date	Date	Generic Edit	6	0
225	ITOHDJ	On Hand Date	Date	Generic Edit	6	0
226	ITDLEJ	Lot Effectivity Date	Date	Generic Edit	6	0
227	ITSBDJ	Sell By Date	Date	Generic Edit	6	0
228	ITBBDJ	Best Before Date	Date	Generic Edit	6	0
229	ITU1DJ	User Lot Date 1	Date	Generic Edit	6	0
230	ITU2DJ	User Lot Date 2	Date	Generic Edit	6	0
231	ITU3DJ	User Lot Date 3	Date	Generic Edit	6	0
232	ITU4DJ	User Lot Date 4	Date	Generic Edit	6	0
233	ITU5DJ	User Lot Date 5	Date	Generic Edit	6	0
234	ITLOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?
235	ITPJCM	Project Hard Committed Quantity in Prima	Numeric	Generic Edit	15	0	Allow NULL?
236	ITPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
237	ITCFGSID	Unique Configuration ID	String	Generic Edit	32	0	Allow NULL?
238	ITPJDM	Project Hard Committed Quantity in Secon	Numeric	Generic Edit	15	0	Allow NULL?
239	ITCCFL	Cost Changed Flag	Character	Generic Edit	1	0	Allow NULL?
240	ITDOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
241	ITCONV	Conversion Factor	Numeric	Generic Edit	15	7	Allow NULL?
242	ITCNV1	Conversion Factor - Secondary to Primary	Numeric	Generic Edit	15	7	Allow NULL?
243	ITJEL7	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
244	ITJEL8	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
245	ITTGN	Transaction Group Number	Numeric	Generic Edit	7	3	Allow NULL?
246	ITRFLN	Related From Line Number	Numeric	Generic Edit	7	3	Allow NULL?

TOP 812 | 41 | F41UI001 INDEXES

Number

Description

Computer Job Line (Primary/Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	LNID	Line Number	Ascending
4	NLIN	Number of Lines	Ascending
5	DCTO	Order Type	Ascending
6	DOCO	Document (Order No Invoice etc.)	Ascending
7	KCOO	Order Company (Order Number)	Ascending
8	SFXO	Order Suffix	Ascending

Job Number

Element	Alias	Description	Sequence
1	JOBS	Job 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

246 COLUMNS | 2 INDEXES | 812 | 41 | F41UI001 TABLE

TOP 812 | 41 | F41UI001 COLUMNS

TOP 812 | 41 | F41UI001 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

246 COLUMNS | 2 INDEXES | 812 | 41 | F41UI001 TABLE

TOP812 | 41 | F41UI001 COLUMNS

TOP812 | 41 | F41UI001 INDEXES

TOP 812 | 41 | F41UI001 COLUMNS

TOP 812 | 41 | F41UI001 INDEXES