	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

104 COLUMNS | 5 INDEXES | 812 | 43 | F4301Z TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	812	F4301Z	PA	104	5	PO Header Work File	Work Files	43: Procurement	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 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 FROM F4301Z

TOP 812 | 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	UDC	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?

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

104 COLUMNS | 5 INDEXES | 812 | 43 | F4301Z TABLE

TOP 812 | 43 | F4301Z COLUMNS

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

104 COLUMNS | 5 INDEXES | 812 | 43 | F4301Z TABLE

TOP812 | 43 | F4301Z COLUMNS

TOP812 | 43 | F4301Z INDEXES

TOP 812 | 43 | F4301Z COLUMNS

TOP 812 | 43 | F4301Z INDEXES