	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

154 COLUMNS | 11 INDEXES | 812 | 43 | F43121 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	812	F43121	PR	154	11	Purchase Order Receiver File	Transaction Files	43A: Purchase Order Receipt/Routing	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 PRMATC, PRAN8, PRKCOO, PRDOCO, PRDCTO, PRSFXO, PRLNID, PRNLIN, PRALIN, PRRTBY, PRDMCT, PRDMCS, PRBALU, PRITM, PRLITM, PRAITM, PRIMCU, PRLOCN, PRLOTN, PRLOTG, PRLOTP, PRVRMK, PRCNID, PRNXTR, PRLTTR, PRTRDJ, PRRCDJ, PRDRQJ, PRPDDJ, PROPDJ, PRRCD, PRVINV, PRPTC, PRPST, PRLAND, PRPRP5, PRLVLA, PRILOG, PRDLOG, PRRTGC, PRRCPF, PRAVCH, PRLNTY, PRGLC, PRMCU, PRCO, PRAID, PRANI, PROMCU, PROBJ, PRSUB, PRASID, PRSBL, PRSBLT, PRKCO, PRDOC, PRDCT, PRSFX, PRDGL, PRJELN, PRVANI, PRTX, PREXR1, PRTXA1, PRUOM, PRUORG, PRUPTD, PRUOPN, PRUREC, PRUCLO, PRQTYS, PRQTYR, PRQTYW, PRQTYC, PRQTYJ, PRQTYA, PRUOM3, PRPRRC, PRECST, PRAPTD, PRAOPN, PRAREC, PRACLO, PRAVCO, PRVARC, PRCRCD, PRCRR, PRFRRC, PRFEC, PRFAP, PRFAPT, PRFREC, PRFCLO, PRURCD, PRURDT, PRURAT, PRURAB, PRURRF, PRTORG, PRUSER, PRPID, PRJOBN, PRTERM, PRUPMJ, PRTDAY, PRBCRC, PRSTAM, PRCTAM, PRMACT, PRPLT, PRPAK, PRSCCN, PRSCCQ, PRSCUM, PRUPCN, PRUPQT, PRUPUM, PRSHPN, PRVR01, PRVR02, PRFUF3, PRFUF4, PRFUF5, PRFUF6, PRMERL, PRKTLN, PRCPNT, PRVR04, PRVR05, PRUKID, PRUOM2, PRDUAL, PRSQOR, PRXDCK, PRPOE, PRVR03, PRLDNM, PRCTSN, PRPROV, PRASN, PRPRFLG1, PRPRFLG2, PRMOADJ, PRPS09, PRQTYPY, PRWVID, PRCNTRTID, PRCNTRTDID, PRREVFLG, PRAPPFLG, PRREVAN8, PRAPPAN8, PRWOPID, PRWVTY FROM F43121

TOP 812 | 43 | F43121 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PRMATC	Type - Match Record Type	Character	Generic Edit	1	0	Allow NULL?
2	PRAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
3	PRKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	PRDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
5	PRDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
6	PRSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
7	PRLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
8	PRNLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
9	PRALIN	Line - Associated	Numeric	Generic Edit	5	0	Allow NULL?
10	PRRTBY	Written By Program	String	Generic Edit	2	0	Allow NULL?
11	PRDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
12	PRDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
13	PRBALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
14	PRITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
15	PRLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
16	PRAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
17	PRIMCU	Item Business Unit	String	Generic Edit	12	0	Allow NULL?
18	PRLOCN	Location	String	Generic Edit	20	0	Allow NULL?
19	PRLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
20	PRLOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
21	PRLOTP	Lot Potency	Numeric	Generic Edit	15	3	Allow NULL?
22	PRVRMK	Supplier Remark	String	Generic Edit	30	0	Allow NULL?
23	PRCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
24	PRNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
25	PRLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
26	PRTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
27	PRRCDJ	Date - Received	Date	Generic Edit	6	0
28	PRDRQJ	Date - Requested	Date	Generic Edit	6	0
29	PRPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
30	PROPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
31	PRRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
32	PRVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
33	PRPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
34	PRPST	Pay Status Code	Character	UDC (00 PS)	1	0	Allow NULL?
35	PRLAND	Code - Landed Cost	Character	Generic Edit	1	0	Allow NULL?
36	PRPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
37	PRLVLA	Level Cost	String	UDC (40 CA)	3	0	Allow NULL?
38	PRILOG	Code - Invoice Logging	Character	Generic Edit	1	0	Allow NULL?
39	PRDLOG	Final Receipt Flag (Y or BLANK)	Character	Generic Edit	1	0	Allow NULL?
40	PRRTGC	Routing Process (Y/N)	Character	Generic Edit	1	0	Allow NULL?
41	PRRCPF	Leadtime Recalculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
42	PRAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
43	PRLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
44	PRGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
45	PRMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
46	PRCO	Company	String	Generic Edit	5	0	Allow NULL?
47	PRAID	Account ID	String	Generic Edit	8	0	Allow NULL?
48	PRANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
49	PROMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
50	PROBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
51	PRSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
52	PRASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
53	PRSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
54	PRSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
55	PRKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
56	PRDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
57	PRDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
58	PRSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
59	PRDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
60	PRJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
61	PRVANI	Account Number - Received Not Vouchered	String	Generic Edit	29	0	Allow NULL?
62	PRTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
63	PREXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
64	PRTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
65	PRUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
66	PRUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
67	PRUPTD	Units - Paid to Date	Numeric	Generic Edit	15	2	Allow NULL?
68	PRUOPN	Units - Open	Numeric	Generic Edit	15	2	Allow NULL?
69	PRUREC	Units - Received	Numeric	Generic Edit	15	2	Allow NULL?
70	PRUCLO	Units - Closed	Numeric	Generic Edit	15	2	Allow NULL?
71	PRQTYS	Units - Stocked	Numeric	Generic Edit	15	2	Allow NULL?
72	PRQTYR	Units - Returned	Numeric	Generic Edit	15	2	Allow NULL?
73	PRQTYW	Units - Reworked	Numeric	Generic Edit	15	2	Allow NULL?
74	PRQTYC	Units - Scrapped	Numeric	Generic Edit	15	2	Allow NULL?
75	PRQTYJ	Units - Rejected	Numeric	Generic Edit	15	2	Allow NULL?
76	PRQTYA	Units - Adjusted	Numeric	Generic Edit	15	2	Allow NULL?
77	PRUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
78	PRPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
79	PRECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
80	PRAPTD	Amount - Paid to Date	Numeric	Generic Edit	15	2	Allow NULL?
81	PRAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
82	PRAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
83	PRACLO	Amount - Closed	Numeric	Generic Edit	15	2	Allow NULL?
84	PRAVCO	Amount - Average Cost Difference	Numeric	Generic Edit	15	2	Allow NULL?
85	PRVARC	Amount - Cost Variance	Numeric	Generic Edit	15	2	Allow NULL?
86	PRCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
87	PRCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
88	PRFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
89	PRFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
90	PRFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
91	PRFAPT	Amount - Foreign Amount Paid to Date	Numeric	Generic Edit	15	2	Allow NULL?
92	PRFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
93	PRFCLO	Amount - Foreign Closed	Numeric	Generic Edit	15	2	Allow NULL?
94	PRURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
95	PRURDT	User Reserved Date	Date	Generic Edit	6	0
96	PRURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
97	PRURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
98	PRURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
99	PRTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
100	PRUSER	User ID	String	Generic Edit	10	0	Allow NULL?
101	PRPID	Program ID	String	Generic Edit	10	0	Allow NULL?
102	PRJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
103	PRTERM	terminal identification	String	Generic Edit	10	0	Allow NULL?
104	PRUPMJ	Date - Updated	Date	Generic Edit	6	0
105	PRTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
106	PRBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
107	PRSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
108	PRCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
109	PRMACT	Multiple Accounts	Character	UDC (40 MU)	1	0	Allow NULL?
110	PRPLT	SSCC Number - Tare Level	String	Generic Edit	18	0	Allow NULL?
111	PRPAK	SSCC Number - Pack Level	String	Generic Edit	18	0	Allow NULL?
112	PRSCCN	SCC Number	String	Generic Edit	14	0	Allow NULL?
113	PRSCCQ	SCC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
114	PRSCUM	SCC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
115	PRUPCN	UPC Number	String	Generic Edit	13	0	Allow NULL?
116	PRUPQT	UPC Quantity	Numeric	Generic Edit	15	2	Allow NULL?
117	PRUPUM	UPC Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
118	PRSHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
119	PRVR01	Reference	String	Generic Edit	25	0	Allow NULL?
120	PRVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
121	PRFUF3	Future Use	String	Generic Edit	1	0	Allow NULL?
122	PRFUF4	Future Use	String	Generic Edit	1	0	Allow NULL?
123	PRFUF5	Future Use	String	Generic Edit	1	0	Allow NULL?
124	PRFUF6	Future Use	String	Generic Edit	1	0	Allow NULL?
125	PRMERL	Item Revision Level	String	Generic Edit	3	0	Allow NULL?
126	PRKTLN	Kit Master Line Number	Numeric	Generic Edit	6	3	Allow NULL?
127	PRCPNT	Component Line Number	Numeric	Generic Edit	4	1	Allow NULL?
128	PRVR04	Outside Reference 1	String	Generic Edit	25	0	Allow NULL?
129	PRVR05	Outside Reference 2	String	Generic Edit	25	0	Allow NULL?
130	PRUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
131	PRUOM2	Unit of Measure - Secondary	String	UDC (00 UM)	2	0	Allow NULL?
132	PRDUAL	Dual Unit Of Measure Item	Character	Generic Edit	1	0	Allow NULL?
133	PRSQOR	Units - Secondary Quantity Ordered	Numeric	Generic Edit	15	2	Allow NULL?
134	PRXDCK	Cross-Docking Flag	Character	Generic Edit	1	0	Allow NULL?
135	PRPOE	Port of Entry or Exit	String	UDC (40 PE)	6	0	Allow NULL?
136	PRVR03	Reference	String	Generic Edit	25	0	Allow NULL?
137	PRLDNM	Load Number	Numeric	Generic Edit	8	0	Allow NULL?
138	PRCTSN	Container Serial Number	String	Generic Edit	40	0	Allow NULL?
139	PRPROV	Price Override Code	Character	Generic Edit	1	0	Allow NULL?
140	PRASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
141	PRPRFLG1	Pricing Control 01	Character	UDC (45 PC)	1	0	Allow NULL?
142	PRPRFLG2	Pricing Control 02	Character	UDC (45 PF)	1	0	Allow NULL?
143	PRMOADJ	Manual Override Adjustment Flag	Character	Check Box	1	0	Allow NULL?
144	PRPS09	Purchase Order Status 09	Character	Generic Edit	1	0	Allow NULL?
145	PRQTYPY	Quantity To Pay	Numeric	Generic Edit	15	0	Allow NULL?
146	PRWVID	Vessel ID	Numeric	Generic Edit	8	0	Allow NULL?
147	PRCNTRTID	Contract ID	Numeric	Generic Edit	8	0	Allow NULL?
148	PRCNTRTDID	Contract Detail ID	Numeric	Generic Edit	15	0	Allow NULL?
149	PRREVFLG	Reviewed Flag	Character	Generic Edit	1	0	Allow NULL?
150	PRAPPFLG	Approved Flag	Character	Generic Edit	1	0	Allow NULL?
151	PRREVAN8	Reviewed By Address Number	Numeric	Generic Edit	8	0	Allow NULL?
152	PRAPPAN8	Approved By Address Number	Numeric	Generic Edit	8	0	Allow NULL?
153	PRWOPID	Operation ID	Integer	Generic Edit	11	0	Allow NULL?
154	PRWVTY	Vessel Class	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 43 | F43121 INDEXES

Number

Description

Order Number Order Type + (Primary/Unique)

Element	Alias	Description	Sequence
1	MATC	Type - Match Record Type	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	SFXO	Order Suffix	Ascending
6	LNID	Line Number	Ascending
7	NLIN	Number of Lines	Ascending
8	DOC	Document (Voucher Invoice etc.)	Ascending

Document OrderType +

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

Receipt Doc Receipt Typ +

Element	Alias	Description	Sequence
1	DOC	Document (Voucher Invoice etc.)	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending

MatchType ShortItem +

Element	Alias	Description	Sequence
1	MATC	Type - Match Record Type	Ascending
2	ITM	Item Number - Short	Ascending
3	MCU	Business Unit	Ascending
4	PDDJ	Date - Scheduled Pick	Ascending

MatchType Address +

Element	Alias	Description	Sequence
1	MATC	Type - Match Record Type	Ascending
2	AN8	Address Number	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	MCU	Business Unit	Ascending
8	LNID	Line Number	Ascending
9	NLIN	Number of Lines	Ascending

MatchType Order +

Element	Alias	Description	Sequence
1	MATC	Type - Match Record Type	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	SFXO	Order Suffix	Ascending
6	MCU	Business Unit	Ascending
7	LNID	Line Number	Ascending
8	NLIN	Number of Lines	Ascending
9	DOC	Document (Voucher Invoice etc.)	Ascending

MatchType Order Number +

Element	Alias	Description	Sequence
1	MATC	Type - Match Record Type	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	SFXO	Order Suffix	Ascending
6	LNID	Line Number	Ascending

Invoice No Receipt Type +

Element	Alias	Description	Sequence
1	VINV	Supplier Invoice Number	Ascending
2	DCT	Document Type	Ascending
3	KCO	Document Company	Ascending

SHPN MATC DOCO DCTO KCOO SFXO+

Element	Alias	Description	Sequence
1	SHPN	Shipment Number	Ascending
2	MATC	Type - Match Record Type	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
8	NLIN	Number of Lines	Ascending
9	DOC	Document (Voucher Invoice etc.)	Ascending

MatchType RecDoc RecDocType +

Element	Alias	Description	Sequence
1	MATC	Type - Match Record Type	Ascending
2	DOC	Document (Voucher Invoice etc.)	Ascending
3	DCT	Document Type	Ascending
4	KCO	Document Company	Ascending

OperationID VesselClass

Element	Alias	Description	Sequence
1	WOPID	Operation ID	Ascending
2	WVTY	Vessel Class	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

154 COLUMNS | 11 INDEXES | 812 | 43 | F43121 TABLE

TOP 812 | 43 | F43121 COLUMNS

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

154 COLUMNS | 11 INDEXES | 812 | 43 | F43121 TABLE

TOP812 | 43 | F43121 COLUMNS

TOP812 | 43 | F43121 INDEXES

TOP 812 | 43 | F43121 COLUMNS

TOP 812 | 43 | F43121 INDEXES