	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

220 COLUMNS | 8 INDEXES | 812 | 43 | F43199 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	812	F43199	OL	220	8	P.O. Detail Ledger File - Flexible Version	History Files	43: Procurement	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 OLKCOO, OLDOCO, OLDCTO, OLSFXO, OLLNID, OLMCU, OLCO, OLOKCO, OLOORN, OLOCTO, OLOGNO, OLRKCO, OLRORN, OLRCTO, OLRLLN, OLDMCT, OLDMCS, OLBALU, OLAN8, OLSHAN, OLDRQJ, OLTRDJ, OLPDDJ, OLOPDJ, OLADDJ, OLCNDJ, OLPEFJ, OLPPDJ, OLPSDJ, OLDSVJ, OLDGL, OLPN, OLVR01, OLVR02, OLITM, OLLITM, OLAITM, OLLOCN, OLLOTN, OLFRGD, OLTHGD, OLFRMP, OLTHRP, OLDSC1, OLDSC2, OLLNTY, OLNXTR, OLLTTR, OLRLIT, OLPDS1, OLPDS2, OLPDS3, OLPDS4, OLPDS5, OLPDP1, OLPDP2, OLPDP3, OLPDP4, OLPDP5, OLUOM, OLUORG, OLUCHG, OLUOPN, OLUREC, OLCREC, OLURLV, OLOTQY, OLPRRC, OLAEXP, OLACHG, OLAOPN, OLAREC, OLARLV, OLFTN1, OLTRLV, OLPROV, OLAMC3, OLECST, OLCSTO, OLCSMP, OLINMG, OLASN, OLPRGR, OLCLVL, OLCATN, OLDSPR, OLPTC, OLTX, OLEXR1, OLTXA1, OLATXT, OLCNID, OLCDCD, OLNTR, OLFRTH, OLFRTC, OLZON, OLFRAT, OLRATT, OLANBY, OLANCR, OLMOT, OLCOT, OLSHCM, OLSHCN, OLUOM1, OLPQOR, OLUOM2, OLSQOR, OLUOM3, OLITWT, OLWTUM, OLITVL, OLVLUM, OLGLC, OLCTRY, OLFY, OLSTTS, OLRCD, OLFUF1, OLFUF2, OLGRWT, OLGWUM, OLLT, OLANI, OLAID, OLOMCU, OLOBJ, OLSUB, OLSBLT, OLSBL, OLASID, OLCCMP, OLTAG, OLWR01, OLPL, OLELEV, OLR001, OLRTNR, OLLCOD, OLPURG, OLPROM, OLFNLP, OLAVCH, OLPRPY, OLUNCD, OLMATY, OLRTGC, OLRCPF, OLPS01, OLPS02, OLPS03, OLPS04, OLPS05, OLPS06, OLPS07, OLPS08, OLPS09, OLPS10, OLCRMD, OLARTG, OLCORD, OLCHDT, OLDOCC, OLCHLN, OLCRCD, OLCRR, OLFRRC, OLFEA, OLFUC, OLFEC, OLFCHG, OLFAP, OLFREC, OLURCD, OLURDT, OLURAT, OLURAB, OLURRF, OLTORG, OLUSER, OLPID, OLJOBN, OLUPMJ, OLTDAY, OLVR05, OLVR04, OLSHPN, OLSHMT, OLRSHT, OLPRJM, OLDLEJ, OLOSFX, OLMERL, OLMCLN, OLMACT, OLKTLN, OLFTRL, OLDRQT, OLCTAM, OLCPNT, OLCHT, OLPMTN, OLCHRT, OLCHRS, OLCHMJ, OLBCRC, OLDUAL, OLUKID, OLLDNM, OLMKFR, OLMFLG, OLDLNID, OLCMDCDE, OLUNSPSC, OLRSFX, OLWVID, OLCNTRTID, OLCNTRTDID, OLMOADJ FROM F43199

TOP 812 | 43 | F43199 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	OLKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
2	OLDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
3	OLDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
4	OLSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
5	OLLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
6	OLMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
7	OLCO	Company	String	Generic Edit	5	0	Allow NULL?
8	OLOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
9	OLOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
10	OLOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
11	OLOGNO	Original Line Number	Numeric	Generic Edit	7	3	Allow NULL?
12	OLRKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
13	OLRORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
14	OLRCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
15	OLRLLN	Related PO/SO Line Number	Numeric	Generic Edit	7	3	Allow NULL?
16	OLDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
17	OLDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
18	OLBALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
19	OLAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
20	OLSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
21	OLDRQJ	Date - Requested	Date	Generic Edit	6	0
22	OLTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
23	OLPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
24	OLOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
25	OLADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
26	OLCNDJ	Date - Cancel	Date	Generic Edit	6	0
27	OLPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
28	OLPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
29	OLPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
30	OLDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
31	OLDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
32	OLPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
33	OLVR01	Reference	String	Generic Edit	25	0	Allow NULL?
34	OLVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
35	OLITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
36	OLLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
37	OLAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
38	OLLOCN	Location	String	Generic Edit	20	0	Allow NULL?
39	OLLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
40	OLFRGD	From Grade	String	UDC (40 LG)	3	0	Allow NULL?
41	OLTHGD	Thru Grade	String	UDC (40 LG)	3	0	Allow NULL?
42	OLFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
43	OLTHRP	Thru Potency	Numeric	Generic Edit	7	3	Allow NULL?
44	OLDSC1	Description	String	Generic Edit	30	0	Allow NULL?
45	OLDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
46	OLLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
47	OLNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
48	OLLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
49	OLRLIT	Item Number - Related (Kit)	String	Generic Edit	8	0	Allow NULL?
50	OLPDS1	Reporting Code 1 - Sales	String	Generic Edit	3	0	Allow NULL?
51	OLPDS2	Reporting Code 2 - Sales	String	Generic Edit	3	0	Allow NULL?
52	OLPDS3	Reporting Code 3 - Sales	String	Generic Edit	3	0	Allow NULL?
53	OLPDS4	Reporting Code 4 - Sales	String	Generic Edit	3	0	Allow NULL?
54	OLPDS5	Reporting Code 5 - Sales	String	Generic Edit	3	0	Allow NULL?
55	OLPDP1	Reporting Code 1 - Purchasing	String	UDC (41 P1)	3	0	Allow NULL?
56	OLPDP2	Reporting Code 2 - Purchasing	String	UDC (41 P2)	3	0	Allow NULL?
57	OLPDP3	Reporting Code 3 - Purchasing	String	UDC (41 P3)	3	0	Allow NULL?
58	OLPDP4	Reporting Code 4 - Purchasing	String	UDC (41 P4)	3	0	Allow NULL?
59	OLPDP5	Reporting Code 5 - Purchasing	String	UDC (41 P5)	3	0	Allow NULL?
60	OLUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
61	OLUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
62	OLUCHG	Units - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
63	OLUOPN	Units - Open	Numeric	Generic Edit	15	2	Allow NULL?
64	OLUREC	Units - Received	Numeric	Generic Edit	15	2	Allow NULL?
65	OLCREC	Units - Cumulative Received	Numeric	Generic Edit	15	2	Allow NULL?
66	OLURLV	Units - Relieved	Numeric	Generic Edit	15	2	Allow NULL?
67	OLOTQY	Other Quantity (1/2)	Character	UDC	1	0	Allow NULL?
68	OLPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
69	OLAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
70	OLACHG	Amount - On Hold	Numeric	Generic Edit	15	2	Allow NULL?
71	OLAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
72	OLAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
73	OLARLV	Amount - Relieved	Numeric	Generic Edit	15	2	Allow NULL?
74	OLFTN1	Amount - Tax Commitment	Numeric	Generic Edit	15	2	Allow NULL?
75	OLTRLV	Amount - Tax Relieved	Numeric	Generic Edit	15	2	Allow NULL?
76	OLPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
77	OLAMC3	Unit Cost - Purchasing	Numeric	Generic Edit	15	4	Allow NULL?
78	OLECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
79	OLCSTO	Cost Override Code	Character	Generic Edit	1	0	Allow NULL?
80	OLCSMP	Costing Method - Purchasing	Character	Generic Edit	1	0	Allow NULL?
81	OLINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
82	OLASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
83	OLPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
84	OLCLVL	Pricing Category Level	String	Generic Edit	3	0	Allow NULL?
85	OLCATN	Catalog	String	UDC (40 CN)	8	0	Allow NULL?
86	OLDSPR	Discount Factor	Numeric	Generic Edit	7	4	Allow NULL?
87	OLPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
88	OLTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
89	OLEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
90	OLTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
91	OLATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
92	OLCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
93	OLCDCD	Commodity Code	String	Generic Edit	15	0	Allow NULL?
94	OLNTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
95	OLFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
96	OLFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
97	OLZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
98	OLFRAT	Rate Code - Frieght/Misc	String	UDC (41 RT)	10	0	Allow NULL?
99	OLRATT	Rate Type - Freight/Misc	Character	Generic Edit	1	0	Allow NULL?
100	OLANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
101	OLANCR	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
102	OLMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
103	OLCOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
104	OLSHCM	Shipping Commodity Class	String	UDC (41 E)	3	0	Allow NULL?
105	OLSHCN	Shipping Conditions Code	String	UDC (41 C)	3	0	Allow NULL?
106	OLUOM1	Unit of Measure - Primary	String	UDC (00 UM)	2	0	Allow NULL?
107	OLPQOR	Units - Primary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
108	OLUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
109	OLSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
110	OLUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
111	OLITWT	Unit Weight	Numeric	Generic Edit	15	4	Allow NULL?
112	OLWTUM	Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
113	OLITVL	Unit Volume	Numeric	Generic Edit	15	4	Allow NULL?
114	OLVLUM	Volume Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
115	OLGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
116	OLCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
117	OLFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
118	OLSTTS	Line Status	String	Generic Edit	2	0	Allow NULL?
119	OLRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
120	OLFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
121	OLFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
122	OLGRWT	Gross Weight	Numeric	Generic Edit	15	4	Allow NULL?
123	OLGWUM	Gross Weight Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
124	OLLT	Ledger Types	String	UDC (09 LT)	2	0	Allow NULL?
125	OLANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
126	OLAID	Account ID	String	Generic Edit	8	0	Allow NULL?
127	OLOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
128	OLOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
129	OLSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
130	OLSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
131	OLSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
132	OLASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
133	OLCCMP	Cost Component Number	Numeric	Generic Edit	3	0	Allow NULL?
134	OLTAG	Tag - Reference	String	Generic Edit	8	0	Allow NULL?
135	OLWR01	Categories - Work Order 01	String	UDC (00 W1)	4	0	Allow NULL?
136	OLPL	Plan Number	String	Generic Edit	4	0	Allow NULL?
137	OLELEV	Elevation	String	Generic Edit	3	0	Allow NULL?
138	OLR001	Category Code - G/L1	String	UDC (09 01)	3	0	Allow NULL?
139	OLRTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
140	OLLCOD	Code - Location Tax Status	String	UDC (46 LT)	2	0	Allow NULL?
141	OLPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
142	OLPROM	Processing Mode	Character	UDC (H40 PQ)	1	0	Allow NULL?
143	OLFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
144	OLAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
145	OLPRPY	Pre-Payment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
146	OLUNCD	Work Order Freeze Code	Character	UDC (H00 UN)	1	0	Allow NULL?
147	OLMATY	Type - Match Type	Character	UDC (H40 MB)	1	0	Allow NULL?
148	OLRTGC	Routing Process (Y/N)	Character	Generic Edit	1	0	Allow NULL?
149	OLRCPF	Leadtime Recalculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
150	OLPS01	Transfer/Direct Ship Flag	Character	Generic Edit	1	0	Allow NULL?
151	OLPS02	Purchase Order Status 02	Character	Generic Edit	1	0	Allow NULL?
152	OLPS03	Purchase Order Status 03	Character	Generic Edit	1	0	Allow NULL?
153	OLPS04	Purchase Order Status 04	Character	Generic Edit	1	0	Allow NULL?
154	OLPS05	Purchase Order Status 05	Character	Generic Edit	1	0	Allow NULL?
155	OLPS06	Purchase Order Status 06	Character	Generic Edit	1	0	Allow NULL?
156	OLPS07	Purchase Order Status 07	Character	Generic Edit	1	0	Allow NULL?
157	OLPS08	Purchase Order Status 08	Character	Generic Edit	1	0	Allow NULL?
158	OLPS09	Purchase Order Status 09	Character	Generic Edit	1	0	Allow NULL?
159	OLPS10	Purchase Order Status 10	Character	UDC (00 XS)	1	0	Allow NULL?
160	OLCRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
161	OLARTG	Code - Approval Routing	String	Generic Edit	12	0	Allow NULL?
162	OLCORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
163	OLCHDT	Change Order Type	String	UDC (00 DT)	2	0	Allow NULL?
164	OLDOCC	Document (Change Order #)	Numeric	Generic Edit	8	0	Allow NULL?
165	OLCHLN	Change Order Line Number	Numeric	Generic Edit	7	3	Allow NULL?
166	OLCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
167	OLCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
168	OLFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
169	OLFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
170	OLFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
171	OLFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
172	OLFCHG	Amount - Foreign Changed Amount	Numeric	Generic Edit	15	2	Allow NULL?
173	OLFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
174	OLFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
175	OLURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
176	OLURDT	User Reserved Date	Date	Generic Edit	6	0
177	OLURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
178	OLURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
179	OLURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
180	OLTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
181	OLUSER	User ID	String	Generic Edit	10	0	Allow NULL?
182	OLPID	Program ID	String	Generic Edit	10	0	Allow NULL?
183	OLJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
184	OLUPMJ	Date - Updated	Date	Generic Edit	6	0
185	OLTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
186	OLVR05	Outside Reference 2	String	Generic Edit	25	0	Allow NULL?
187	OLVR04	Outside Reference 1	String	Generic Edit	25	0	Allow NULL?
188	OLSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
189	OLSHMT	Shipment number (ITLS)	String	Generic Edit	15	0	Allow NULL?
190	OLRSHT	Requested Ship Time	Numeric	Generic Edit	6	0	Allow NULL?
191	OLPRJM	Project Number	Numeric	Generic Edit	8	0	Allow NULL?
192	OLDLEJ	Lot Effectivity Date	Date	Generic Edit	6	0
193	OLOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
194	OLMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
195	OLMCLN	Matrix Control Line Number	Numeric	Generic Edit	6	3	Allow NULL?
196	OLMACT	Multiple Accounts	Character	UDC (40 MU)	1	0	Allow NULL?
197	OLKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
198	OLFTRL	Amount - Foreign Tax Relieved	Numeric	Generic Edit	15	2	Allow NULL?
199	OLDRQT	Requested Delivery Time	Numeric	Generic Edit	6	0	Allow NULL?
200	OLCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
201	OLCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
202	OLCHT	Change Order Time of Day	Numeric	Generic Edit	7	0	Allow NULL?
203	OLPMTN	Promotion ID	String	Generic Edit	12	0	Allow NULL?
204	OLCHRT	Time - Scheduled Required (HH/MM/SS)	Numeric	Generic Edit	6	0	Allow NULL?
205	OLCHRS	Shift Code - Scheduled Required	Character	UDC (00 SH)	1	0	Allow NULL?
206	OLCHMJ	Change Order Date - Updated	Date	Generic Edit	6	0
207	OLBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
208	OLDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
209	OLUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
210	OLLDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
211	OLMKFR	Address Number - Mark-for	Numeric	Generic Edit	8	0	Allow NULL?
212	OLMFLG	Manufacturing Work Order Flag	Character	Generic Edit	1	0	Allow NULL?
213	OLDLNID	DistributionLine Number	Numeric	Generic Edit	6	3	Allow NULL?
214	OLCMDCDE	Commodity Code	String	Generic Edit	15	0	Allow NULL?
215	OLUNSPSC	UNSPSC Commodity Code	String	Generic Edit	8	0	Allow NULL?
216	OLRSFX	Related Order Suffix	String	Generic Edit	3	0	Allow NULL?
217	OLWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
218	OLCNTRTID	Contract ID	Numeric	Generic Edit	8	0	Allow NULL?
219	OLCNTRTDID	Contract Detail ID	Numeric	Generic Edit	15	0	Allow NULL?
220	OLMOADJ	Manual Override Adjustment Flag	Character	Check Box	1	0	Allow NULL?

TOP 812 | 43 | F43199 INDEXES

Number

Description

Doc Company Order No + A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	SFXO	Order Suffix	Ascending
5	LNID	Line Number	Ascending
6	LT	Ledger Types	Ascending
7	CORD	Change Order Number	Ascending
8	UPMJ	Date - Updated	Ascending
9	TDAY	Time of Day	Ascending

OrderNum OrderType +A

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	SFXO	Order Suffix	Ascending
5	CORD	Change Order Number	Ascending

doco dcto kcoo sfxo lnid chln

Element	Alias	Description	Sequence
1	DOCO	Document (Order No Invoice etc.)	Ascending
2	DCTO	Order Type	Ascending
3	KCOO	Order Company (Order Number)	Ascending
4	SFXO	Order Suffix	Ascending
5	LNID	Line Number	Ascending
6	LT	Ledger Types	Ascending
7	CHLN	Change Order Line Number	Ascending

LedgerTy AcctID GLDate

Element	Alias	Description	Sequence
1	LT	Ledger Types	Ascending
2	AID	Account ID	Ascending
3	DGL	Date - For G/L (and Voucher)	Ascending

mcu nxtr doco dcto +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	NXTR	Status Code - Next	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	DCTO	Order Type	Ascending
5	KCOO	Order Company (Order Number)	Ascending
6	SFXO	Order Suffix	Ascending
7	LNID	Line Number	Ascending

mcu lttr doco dcto +A

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	LTTR	Status Code - Last	Ascending
3	DOCO	Document (Order No Invoice etc.)	Ascending
4	DCTO	Order Type	Ascending
5	KCOO	Order Company (Order Number)	Ascending
6	SFXO	Order Suffix	Ascending
7	LNID	Line Number	Ascending

UniqueKeyID (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending

POKeys dlnid

Element	Alias	Description	Sequence
1	KCOO	Order Company (Order Number)	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	SFXO	Order Suffix	Ascending
5	LNID	Line Number	Ascending
6	DLNID	DistributionLine 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

220 COLUMNS | 8 INDEXES | 812 | 43 | F43199 TABLE

TOP 812 | 43 | F43199 COLUMNS

TOP 812 | 43 | F43199 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

220 COLUMNS | 8 INDEXES | 812 | 43 | F43199 TABLE

TOP812 | 43 | F43199 COLUMNS

TOP812 | 43 | F43199 INDEXES

TOP 812 | 43 | F43199 COLUMNS

TOP 812 | 43 | F43199 INDEXES