	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

142 COLUMNS | 5 INDEXES | 920 | 43 | F4301Z TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	920	F4301Z	PA	142	5	PO Header Work File	Work Files	43: Procurement	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 PACTID, PAJOBS, PAACTN, PAEDFL, PAKCOO, PADOCO, PADCTO, PASFXO, PAMCU, PAOKCO, PAOORN, PAOCTO, PARKCO, PARORN, PARCTO, PAAN8, PASHAN, PADRQJ, PATRDJ, PAPDDJ, PAOPDJ, PAADDJ, PACNDJ, PAPEFJ, PAPPDJ, PAPSDJ, PAVR01, PAVR02, PADEL1, PADEL2, PARMK, PADESC, PAINMG, PAASN, PAPRGP, PAPTC, PAEXR1, PATXA1, PATXCT, PAHOLD, PAATXT, PAINVC, PANTR, PACNID, PAFRTH, PAZON, PAANBY, PAANCR, PAMOT, PACOT, PARCD, PAFRTC, PAFUF1, PAFUF2, PAOTOT, PAPCRT, PARTNR, PAWUMD, PAVUMD, PAPURG, PALGCT, PAPROM, PAMATY, PAOSTS, PAAVCH, PAPRPY, PACRMD, PAPRP5, PAARTG, PACORD, PACRRM, PACRCD, PACRR, PALNGP, PAFAP, PAORBY, PATKBY, PAURCD, PAURDT, PAURAT, PAURAB, PAURRF, PAUSER, PAPID, PAJOBN, PAUPMJ, PATDAY, PACRDC, PAORNN, PABUMC, PACP06, PAEDF2, PAMINO, PAMAXO, PALNID, PACRCM, PATRR1, PATRR2, PAVVTX, PAPEID, PATCID, PADOC1, PADCT4, PAATVF, PAPOHP01, PAPOHP02, PAPOHP03, PAPOHP04, PAPOHP05, PAPOHP06, PAPOHP07, PAPOHP08, PAPOHP09, PAPOHP10, PAPOHP11, PAPOHP12, PAPOHC01, PAPOHC02, PAPOHC03, PAPOHC04, PAPOHC05, PAPOHC06, PAPOHC07, PAPOHC08, PAPOHC09, PAPOHC10, PAPOHC11, PAPOHC12, PAPOHD01, PAPOHD02, PAPOHAB01, PAPOHAB02, PACUKID, PAPOHP13, PAPOHU01, PAPOHU02, PARETI, PACLASS01, PACLASS02, PACLASS03, PACLASS04, PACLASS05 FROM F4301Z

TOP 920 | 43 | F4301Z COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PACTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	PAJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	PAACTN	Action Code	Character	Generic Edit	1	0	Allow NULL?
4	PAEDFL	Flag - Transaction Edit	Character	Generic Edit	1	0	Allow NULL?
5	PAKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
6	PADOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
7	PADCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
8	PASFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
9	PAMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
10	PAOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
11	PAOORN	Original Order Number	String	Generic Edit	8	0	Allow NULL?
12	PAOCTO	Original Order Type	String	UDC (00 DT)	2	0	Allow NULL?
13	PARKCO	Company - Key (Related Order)	String	Generic Edit	5	0	Allow NULL?
14	PARORN	Related PO/SO/WO Number	String	Generic Edit	8	0	Allow NULL?
15	PARCTO	Related PO/SO/WO Order Type	String	UDC (00 DT)	2	0	Allow NULL?
16	PAAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
17	PASHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
18	PADRQJ	Date - Requested	Date	Generic Edit	6	0
19	PATRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
20	PAPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
21	PAOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
22	PAADDJ	Date - Actual Ship Date	Date	Generic Edit	6	0
23	PACNDJ	Date - Cancel	Date	Generic Edit	6	0
24	PAPEFJ	Date - Price Effective Date	Date	Generic Edit	6	0
25	PAPPDJ	Date - Promised Shipment	Date	Generic Edit	6	0
26	PAPSDJ	Date - Future Date 2	Date	Generic Edit	6	0
27	PAVR01	Reference	String	Generic Edit	25	0	Allow NULL?
28	PAVR02	Reference 2	String	Generic Edit	25	0	Allow NULL?
29	PADEL1	Delivery Instructions Line 1	String	Generic Edit	30	0	Allow NULL?
30	PADEL2	Delivery Instructions Line 2	String	Generic Edit	30	0	Allow NULL?
31	PARMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
32	PADESC	Description	String	Generic Edit	30	0	Allow NULL?
33	PAINMG	Print Message	String	UDC (40 PM)	10	0	Allow NULL?
34	PAASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
35	PAPRGP	Pricing Group	String	UDC (40 PC)	8	0	Allow NULL?
36	PAPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
37	PAEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
38	PATXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
39	PATXCT	Certificate Tax Exemption	String	Generic Edit	20	0	Allow NULL?
40	PAHOLD	Hold Orders Code	String	UDC (42 HC)	2	0	Allow NULL?
41	PAATXT	Associated Text	Character	Generic Edit	1	0	Allow NULL?
42	PAINVC	Invoice Copies	Numeric	Generic Edit	2	0	Allow NULL?
43	PANTR	Nature of Transaction	String	UDC (00 NT)	2	0	Allow NULL?
44	PACNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
45	PAFRTH	Freight Handling Code	String	UDC (42 FR)	3	0	Allow NULL?
46	PAZON	Zone Number	String	UDC (40 ZN)	3	0	Allow NULL?
47	PAANBY	Buyer Number	Numeric	Generic Edit	8	0	Allow NULL?
48	PAANCR	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
49	PAMOT	Mode of Transport	String	UDC (00 TM)	3	0	Allow NULL?
50	PACOT	Conditions of Transport	String	UDC (00 TC)	3	0	Allow NULL?
51	PARCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
52	PAFRTC	Freight Calculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
53	PAFUF1	AIA Document Flag	Character	UDC (H40 FU)	1	0	Allow NULL?
54	PAFUF2	Post Quantities	Character	Generic Edit	1	0	Allow NULL?
55	PAOTOT	Amount - Order Gross	Numeric	Generic Edit	15	2	Allow NULL?
56	PAPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
57	PARTNR	Retainage Rule	String	Generic Edit	3	0	Allow NULL?
58	PAWUMD	Unit of Measure - Weight Display	String	UDC (00 UM)	2	0	Allow NULL?
59	PAVUMD	Unit of Measure - Volume Display	String	UDC (00 UM)	2	0	Allow NULL?
60	PAPURG	Purge Code	Character	Generic Edit	1	0	Allow NULL?
61	PALGCT	Logic Control	Character	Generic Edit	1	0	Allow NULL?
62	PAPROM	Processing Mode	Character	UDC (H40 PQ)	1	0	Allow NULL?
63	PAMATY	Type - Match Type	Character	UDC (H40 MB)	1	0	Allow NULL?
64	PAOSTS	Status - Purchase Order	Character	Generic Edit	1	0	Allow NULL?
65	PAAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
66	PAPRPY	Pre-Payment (Y/N)	Character	Generic Edit	1	0	Allow NULL?
67	PACRMD	Send Method	Character	UDC (00 SM)	1	0	Allow NULL?
68	PAPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
69	PAARTG	Code - Approval Routing	String	Generic Edit	12	0	Allow NULL?
70	PACORD	Change Order Number	Numeric	Generic Edit	3	0	Allow NULL?
71	PACRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
72	PACRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
73	PACRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
74	PALNGP	Language	String	UDC (01 LP)	2	0	Allow NULL?
75	PAFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
76	PAORBY	Ordered By	String	Generic Edit	10	0	Allow NULL?
77	PATKBY	Order Taken By	String	Generic Edit	10	0	Allow NULL?
78	PAURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
79	PAURDT	User Reserved Date	Date	Generic Edit	6	0
80	PAURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
81	PAURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
82	PAURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
83	PAUSER	User ID	String	Generic Edit	10	0	Allow NULL?
84	PAPID	Program ID	String	Generic Edit	10	0	Allow NULL?
85	PAJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
86	PAUPMJ	Date - Updated	Date	Generic Edit	6	0
87	PATDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
88	PACRDC	Currency Code - To	String	Generic Edit	3	0	Allow NULL?
89	PAORNN	Order Type Next Number	Numeric	Generic Edit	2	0	Allow NULL?
90	PABUMC	Process UOM Conversions by Branch	Character	Generic Edit	1	0	Allow NULL?
91	PACP06	Purchase Price Retrieval UOM	Character	UDC (40 PU)	1	0	Allow NULL?
92	PAEDF2	Item Restrictions	Character	UDC (H40 ED)	1	0	Allow NULL?
93	PAMINO	Minimum Order Value	Numeric	Generic Edit	15	0	Allow NULL?
94	PAMAXO	Maximum Order Value	Numeric	Generic Edit	15	0	Allow NULL?
95	PALNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
96	PACRCM	Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
97	PATRR1	Triangulation Rate - From Currency	Numeric	Generic Edit	15	0	Allow NULL?
98	PATRR2	Triangulation Rate - To Currency	Numeric	Generic Edit	15	0	Allow NULL?
99	PAVVTX	Activate Vertex Tax Compliance System	Character	Generic Edit	1	0	Allow NULL?
100	PAPEID	Process ID	Numeric	Generic Edit	15	0	Allow NULL?
101	PATCID	Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
102	PADOC1	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
103	PADCT4	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
104	PAATVF	Active Flag	Character	UDC (34A AF)	1	0	Allow NULL?
105	PAPOHP01	Purchase Order Property 01	Character	Generic Edit	1	0	Allow NULL?
106	PAPOHP02	Purchase Order Property 02	Character	Generic Edit	1	0	Allow NULL?
107	PAPOHP03	Purchase Order Property 03	Character	Generic Edit	1	0	Allow NULL?
108	PAPOHP04	Purchase Order Property 04	Character	Generic Edit	1	0	Allow NULL?
109	PAPOHP05	Purchase Order Property 05	Character	Generic Edit	1	0	Allow NULL?
110	PAPOHP06	Purchase Order Property 06	Character	Generic Edit	1	0	Allow NULL?
111	PAPOHP07	Purchase Order Property 07	Character	Generic Edit	1	0	Allow NULL?
112	PAPOHP08	Purchase Order Property 08	Character	Generic Edit	1	0	Allow NULL?
113	PAPOHP09	Purchase Order Property 09	Character	Generic Edit	1	0	Allow NULL?
114	PAPOHP10	Purchase Order Property 10	Character	Generic Edit	1	0	Allow NULL?
115	PAPOHP11	Purchase Order Property 11	Character	Generic Edit	1	0	Allow NULL?
116	PAPOHP12	Purchase Order Property 12	Character	Generic Edit	1	0	Allow NULL?
117	PAPOHC01	Purchase Order Code 01	String	UDC (43 C1)	3	0	Allow NULL?
118	PAPOHC02	Purchase Order Code 02	String	UDC (43 C2)	3	0	Allow NULL?
119	PAPOHC03	Purchase Order Code 03	String	UDC (43 C3)	3	0	Allow NULL?
120	PAPOHC04	Purchase Order Code 04	String	UDC (43 C4)	3	0	Allow NULL?
121	PAPOHC05	Purchase Order Code 05	String	UDC (43 C5)	3	0	Allow NULL?
122	PAPOHC06	Purchase Order Code 06	String	UDC (43 C6)	3	0	Allow NULL?
123	PAPOHC07	Purchase Order Code 07	String	UDC (43 L1)	10	0	Allow NULL?
124	PAPOHC08	Purchase Order Code 08	String	UDC (43 L2)	10	0	Allow NULL?
125	PAPOHC09	Purchase Order Code 09	String	UDC (43 L3)	10	0	Allow NULL?
126	PAPOHC10	Purchase Order Code 10	String	UDC (43 L4)	10	0	Allow NULL?
127	PAPOHC11	Purchase Order Code 11	String	UDC (43 L5)	10	0	Allow NULL?
128	PAPOHC12	Purchase Order Code 12	String	UDC (43 L6)	10	0	Allow NULL?
129	PAPOHD01	Purchase Order Date 01	Date	Generic Edit	6	0
130	PAPOHD02	Purchase Order Date 02	Date	Generic Edit	6	0
131	PAPOHAB01	Purchase Order Address Book 01	Numeric	Generic Edit	8	0	Allow NULL?
132	PAPOHAB02	Purchase Order Address Book 02	Numeric	Generic Edit	8	0	Allow NULL?
133	PACUKID	Clause Unique ID	Numeric	Generic Edit	15	0	Allow NULL?
134	PAPOHP13	Purchase Order Property 13	String	Generic Edit	30	0	Allow NULL?
135	PAPOHU01	Purchase Order Universal Date 01	JDE UTime	Generic Edit	11	0
136	PAPOHU02	Purchase Order Universal Date 02	JDE UTime	Generic Edit	11	0
137	PARETI	Retainage Indicator	Character	Generic Edit	1	0	Allow NULL?
138	PACLASS01	Classification Code 01	String	UDC (01 CA)	3	0	Allow NULL?
139	PACLASS02	Classification Code 02	String	UDC (01 CB)	3	0	Allow NULL?
140	PACLASS03	Classification Code 03	String	UDC (01 CC)	3	0	Allow NULL?
141	PACLASS04	Classification Code 04	String	UDC (01 CD)	3	0	Allow NULL?
142	PACLASS05	Classification Code 05	String	UDC (01 CE)	3	0	Allow NULL?

TOP 920 | 43 | F4301Z INDEXES

Number

Description

MachineKey JobNumber A (Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	SFXO	Order Suffix	Ascending

BranchPlant Supplier +A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	AN8	Address Number	Ascending
3	CRCD	Currency Code - From	Ascending

CTID PEID TCID JOBS A+ (Primary/Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	PEID	Process ID	Ascending
3	TCID	Transaction ID	Ascending
4	JOBS	Job Number	Ascending
5	SFXO	Order Suffix	Ascending

CTID PEID TCID AN8 CRCD

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	PEID	Process ID	Ascending
3	TCID	Transaction ID	Ascending
4	AN8	Address Number	Ascending
5	CRCD	Currency Code - From	Ascending

CTID PEID A

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	PEID	Process ID	Ascending
3	TCID	Transaction ID	Ascending
4	AN8	Address Number	Ascending
5	CRCD	Currency Code - From	Ascending
6	DCTO	Order Type	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

142 COLUMNS | 5 INDEXES | 920 | 43 | F4301Z TABLE

TOP 920 | 43 | F4301Z COLUMNS

TOP 920 | 43 | F4301Z 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

142 COLUMNS | 5 INDEXES | 920 | 43 | F4301Z TABLE

TOP920 | 43 | F4301Z COLUMNS

TOP920 | 43 | F4301Z INDEXES

TOP 920 | 43 | F4301Z COLUMNS

TOP 920 | 43 | F4301Z INDEXES