	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

98 COLUMNS | 6 INDEXES | 812 | 41B | F41511 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
41B: Bulk Stock Management
1	812	F41511	PA	98	6	Bulk Product Transaction File	Transaction Files	41B: Bulk Stock Management	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 PADOC, PADCT, PAKCO, PAJELN, PADOCO, PADCTO, PAKCOO, PALNID, PANLIN, PADGL, PATRDJ, PAICU, PATRCD, PAMCU, PATKID, PAITM, PATRNO, PATEMP, PASTPU, PADNTY, PADNTP, PADETP, PADTPU, PAAMBR, PABUM3, PAAMBI, PAAMBU, PAVCF, PASTOK, PABUM4, PAWGTR, PABUM5, PASTUM, PABUM6, PARCD, PAUPCF, PALOTN, PALOTS, PAMMEJ, PAUNCS, PAECST, PATREX, PAAN8, PADMCT, PADMCS, PAACOR, PAHCOR, PADIPT, PAGDIP, PAWDIP, PAVAPP, PAPREU, PALPGV, PATPU1, PASLIP, PAVAPW, PABUM0, PAVAPV, PABUM9, PALIQW, PABUM7, PALIQV, PABUM8, PAOVOL, PABUM2, PARDTM, PADTE, PAMETN, PAOPNR, PAPNCR, PAVEHI, PAVMCU, PATRP, PACMPN, PABFWT, PABWTU, PAAFWT, PAAWTU, PATHDT, PAOPDT, PALRST, PARECS, PAPGMS, PAGLRN, PAPTNR, PAURCD, PAURAT, PAURAB, PAURRF, PAURDT, PAUSER, PAPID, PAJOBN, PAUPMJ, PATDAY, PAUKID, PABPAS, PALOTC FROM F41511

TOP 812 | 41B | F41511 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PADOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	PADCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
3	PAKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
4	PAJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
5	PADOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
6	PADCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
7	PAKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
8	PALNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
9	PANLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
10	PADGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
11	PATRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
12	PAICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
13	PATRCD	Record Type	Character	Generic Edit	1	0	Allow NULL?
14	PAMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
15	PATKID	Tank ID	String	Generic Edit	8	0	Allow NULL?
16	PAITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
17	PATRNO	Transaction Line Number	Numeric	Generic Edit	5	0	Allow NULL?
18	PATEMP	Temperature	Numeric	Generic Edit	7	2	Allow NULL?
19	PASTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
20	PADNTY	Density	Numeric	Generic Edit	7	2	Allow NULL?
21	PADNTP	Density Type - At Standard Temperature	Character	UDC (41B DT)	1	0	Allow NULL?
22	PADETP	Density Temperature	Numeric	Generic Edit	7	2	Allow NULL?
23	PADTPU	Temperature Type	Character	UDC (41B TP)	1	0	Allow NULL?
24	PAAMBR	Volume - Ambient	Numeric	Generic Edit	15	2	Allow NULL?
25	PABUM3	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
26	PAAMBI	Quantity - Ambient In Inventory Units	Numeric	Generic Edit	15	2	Allow NULL?
27	PAAMBU	Unit of Measure - Ambient Volume	String	UDC (00 UM)	2	0	Allow NULL?
28	PAVCF	Volume Correction Factor	Numeric	Generic Edit	7	4	Allow NULL?
29	PASTOK	Volume - Standard	Numeric	Generic Edit	15	2	Allow NULL?
30	PABUM4	Unit of Measure 4	String	UDC (00 UM)	2	0	Allow NULL?
31	PAWGTR	Weight Result	Numeric	Generic Edit	15	2	Allow NULL?
32	PABUM5	Unit of Measure 5	String	UDC (00 UM)	2	0	Allow NULL?
33	PASTUM	Quantity - Primary Stock Accounting Unit	Numeric	Generic Edit	15	2	Allow NULL?
34	PABUM6	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
35	PARCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
36	PAUPCF	Update Control Flag	Character	Generic Edit	1	0	Allow NULL?
37	PALOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
38	PALOTS	Lot Status Code	Character	UDC (41 L)	1	0	Allow NULL?
39	PAMMEJ	Date - Lot Expiration	Date	Generic Edit	6	0
40	PAUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
41	PAECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
42	PATREX	Explanation - Transaction	String	Generic Edit	30	0	Allow NULL?
43	PAAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
44	PADMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
45	PADMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
46	PAACOR	Air Correction	Character	Generic Edit	1	0	Allow NULL?
47	PAHCOR	Hydrometer Correction	Character	Generic Edit	1	0	Allow NULL?
48	PADIPT	Dip Type	Character	UDC (41B DP)	1	0	Allow NULL?
49	PAGDIP	Gross Dip	Numeric	Generic Edit	15	2	Allow NULL?
50	PAWDIP	Water Dip	Numeric	Generic Edit	15	2	Allow NULL?
51	PAVAPP	Vapour Pressure	Numeric	Generic Edit	15	2	Allow NULL?
52	PAPREU	Pressure Unit of Measure	String	UDC (41B PT)	2	0	Allow NULL?
53	PALPGV	LPG Vapor Temperature	Numeric	Generic Edit	7	0	Allow NULL?
54	PATPU1	Temperature Type - LPG Vapour	Character	UDC (41B TP)	1	0	Allow NULL?
55	PASLIP	Slip Tube Reading Type	Character	UDC (41B SL)	1	0	Allow NULL?
56	PAVAPW	Vapour Weight	Numeric	Generic Edit	15	2	Allow NULL?
57	PABUM0	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
58	PAVAPV	Vapour Volume	Numeric	Generic Edit	15	2	Allow NULL?
59	PABUM9	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
60	PALIQW	Liquid Weight	Numeric	Generic Edit	15	2	Allow NULL?
61	PABUM7	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
62	PALIQV	Liquid Volume	Numeric	Generic Edit	15	2	Allow NULL?
63	PABUM8	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
64	PAOVOL	Other Volume	Numeric	Generic Edit	15	2	Allow NULL?
65	PABUM2	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
66	PARDTM	Time - Reading	Numeric	Generic Edit	6	0	Allow NULL?
67	PADTE	Date	Date	Generic Edit	6	0
68	PAMETN	Meter Number	String	Generic Edit	10	0	Allow NULL?
69	PAOPNR	Units - Beginning Throughput Qty.	Numeric	Generic Edit	15	0	Allow NULL?
70	PAPNCR	Closing Reading	Numeric	Generic Edit	15	0	Allow NULL?
71	PAVEHI	Vehicle ID	String	Generic Edit	12	0	Allow NULL?
72	PAVMCU	Depot - Trip	String	Generic Edit	12	0	Allow NULL?
73	PATRP	Trip Number	Numeric	Generic Edit	8	0	Allow NULL?
74	PACMPN	Compartment Number	Numeric	Generic Edit	2	0	Allow NULL?
75	PABFWT	Weight - Before Loading	Numeric	Generic Edit	15	2	Allow NULL?
76	PABWTU	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
77	PAAFWT	Weight - After Loading	Numeric	Generic Edit	15	2	Allow NULL?
78	PAAWTU	Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
79	PATHDT	Throughput Reconciled Date	Date	Generic Edit	6	0
80	PAOPDT	Operational Reconciled Date	Date	Generic Edit	6	0
81	PALRST	Reconciliation Status - Current	Numeric	UDC (41B RC)	3	0	Allow NULL?
82	PARECS	Reconciled (Y/N)	Character	UDC (41B RP)	1	0	Allow NULL?
83	PAPGMS	Program Status	Character	UDC (41B PS)	1	0	Allow NULL?
84	PAGLRN	Gain/Loss Record Number	Numeric	Generic Edit	8	0	Allow NULL?
85	PAPTNR	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
86	PAURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
87	PAURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
88	PAURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
89	PAURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
90	PAURDT	User Reserved Date	Date	Generic Edit	6	0
91	PAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
92	PAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
93	PAJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
94	PAUPMJ	Date - Updated	Date	Generic Edit	6	0
95	PATDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
96	PAUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
97	PABPAS	Flag - Quantity Entered	Character	Generic Edit	1	0	Allow NULL?
98	PALOTC	Lot Status Code Expanded	String	Generic Edit	3	0	Allow NULL?

TOP 812 | 41B | F41511 INDEXES

Number

Description

Unique Key ID (Primary/Unique)

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

Doc Dct Kco Trno Trcd Tkid Met

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending
4	TRNO	Transaction Line Number	Ascending
5	TRCD	Record Type	Ascending
6	TKID	Tank ID	Ascending
7	METN	Meter Number	Ascending

Trcd Mcu Tkid Itm Dte Rdtm

Element	Alias	Description	Sequence
1	TRCD	Record Type	Ascending
2	MCU	Business Unit	Ascending
3	TKID	Tank ID	Ascending
4	ITM	Item Number - Short	Ascending
5	DTE	Date	Ascending
6	RDTM	Time - Reading	Ascending

Mcu Itm Opdt(decending)

Element	Alias	Description	Sequence
1	MCU	Business Unit	Descending
2	ITM	Item Number - Short	Descending
3	OPDT	Operational Reconciled Date	Descending

Mcu Itm Tkid Trcd Dte Rdtm

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	ITM	Item Number - Short	Ascending
3	TKID	Tank ID	Ascending
4	TRCD	Record Type	Ascending
5	DTE	Date	Descending
6	RDTM	Time - Reading	Descending

Mcu Tkid Trcd Opdt Rdtm Recs

Element	Alias	Description	Sequence
1	MCU	Business Unit	Ascending
2	TKID	Tank ID	Ascending
3	TRCD	Record Type	Ascending
4	OPDT	Operational Reconciled Date	Descending
5	RECS	Reconciled (Y/N)	Ascending
6	RDTM	Time - Reading	Descending

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

98 COLUMNS | 6 INDEXES | 812 | 41B | F41511 TABLE

TOP 812 | 41B | F41511 COLUMNS

TOP 812 | 41B | F41511 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

98 COLUMNS | 6 INDEXES | 812 | 41B | F41511 TABLE

TOP812 | 41B | F41511 COLUMNS

TOP812 | 41B | F41511 INDEXES

TOP 812 | 41B | F41511 COLUMNS

TOP 812 | 41B | F41511 INDEXES