	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

213 COLUMNS | 2 INDEXES | 920 | 43 | F4314Z TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
43: Procurement
1	920	F4314Z	PN	213	2	Voucher Match Selection File	Regular Work Files	43B: Voucher Match and Landed Cost

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 PNCTID, PNJOBS, PNXTLN, PNDLNID, PNACTN, PNEDFL, PNMAPR, PNPCR, PNDSC1, PNDSC2, PNUITM, PNFLSH, PNCITM, PNIVI, PNSTKT, PNCLEV, PNCONV, PNCNV2, PNJEL1, PNRWT1, PNJEL2, PNRWT2, PNJEL3, PNRWT3, PNJEL4, PNRWT4, PNJEL5, PNRWT5, PNJEL6, PNRWT6, PNJEL7, PNRWT7, PNRWT8, PNJEL8, PNRWT9, PNJEL9, PNRWTA, PNRWTB, PNRWTD, PNRWTE, PNRWTF, PNRWTG, PNACIT, PNBANI, PNSTAM, PNSTA1, PNSTA2, PNDDNJ, PNAC07, PNDDJ, PNADSC, PNATXA, PNAG, PNACR, PNCDS, PNCTAM, PNCTXA, PNCRC, PNPYE, PNAPC, PNRMK, PNTNN, PNATAD, PNCTAD, PNUPAD, PNCRRD, PNUNCS, PNFUC, PNAEXP, PNFEA, PNPCRT, PNRETA, PNRETT, PNREFA, PNREFT, PNU, PNAA, PNFAA, PNAA1, PNAA2, PNAN01, PNAN02, PNBCT1, PNBCT2, PNTRR1, PNTRR2, PNTRD1, PNTRD2, PNCRCM, PNABR1, PNABT1, PNABR2, PNABT2, PNABR3, PNABT3, PNABR4, PNABT4, PNRTNP, PNFTNP, PNMATC, PNAN8, PNKCOO, PNDOCO, PNDCTO, PNSFXO, PNLNID, PNNLIN, PNALIN, PNRTBY, PNDMCT, PNDMCS, PNBALU, PNITM, PNLITM, PNAITM, PNIMCU, PNLOCN, PNLOTN, PNLOTG, PNLOTP, PNVRMK, PNCNID, PNNXTR, PNLTTR, PNTRDJ, PNRCDJ, PNDRQJ, PNPDDJ, PNOPDJ, PNRCD, PNVINV, PNPTC, PNPST, PNLAND, PNPRP5, PNLVLA, PNILOG, PNDLOG, PNRTGC, PNRCPF, PNAVCH, PNLNTY, PNGLC, PNMCU, PNCO, PNAID, PNANI, PNMACT, PNOMCU, PNOBJ, PNSUB, PNASID, PNSBL, PNSBLT, PNKCO, PNDOC, PNDCT, PNSFX, PNDGL, PNJELN, PNVANI, PNTX, PNEXR1, PNTXA1, PNUOM, PNUORG, PNUPTD, PNUOPN, PNUREC, PNUCLO, PNQTYS, PNQTYR, PNQTYW, PNQTYC, PNQTYJ, PNQTYA, PNUOM3, PNPRRC, PNECST, PNAPTD, PNAOPN, PNAREC, PNACLO, PNAVCO, PNVARC, PNCRCD, PNCRR, PNFRRC, PNFEC, PNFAP, PNFAPT, PNFREC, PNFCLO, PNADWT, PNURCD, PNURDT, PNURAT, PNURAB, PNURRF, PNTORG, PNPEID, PNTCID, PNUSER, PNPID, PNJOBN, PNTERM, PNUPMJ, PNTDAY, PNJBCD, PNSRQTY, PNSRUOM, PNNBRU, PNNEWR FROM F4314Z

TOP 920 | 43 | F4314Z COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PNCTID	Computer ID	String	Generic Edit	15	0	Allow NULL?
2	PNJOBS	Job Number	Numeric	Generic Edit	8	0	Allow NULL?
3	PNXTLN	Transaction Line Number	Numeric	Generic Edit	5	0	Allow NULL?
4	PNDLNID	DistributionLine Number	Numeric	Generic Edit	6	3	Allow NULL?
5	PNACTN	Action Code	Character	Generic Edit	1	0	Allow NULL?
6	PNEDFL	Flag - Transaction Edit	Character	Generic Edit	1	0	Allow NULL?
7	PNMAPR	Match Processing	Character	Generic Edit	1	0	Allow NULL?
8	PNPCR	Percent Retainage	Numeric	Generic Edit	5	0	Allow NULL?
9	PNDSC1	Description	String	Generic Edit	30	0	Allow NULL?
10	PNDSC2	Description - Line 2	String	Generic Edit	30	0	Allow NULL?
11	PNUITM	Item Number - Unknown Format Entered	String	Generic Edit	26	0	Allow NULL?
12	PNFLSH	Flash Message	String	Generic Edit	40	0	Allow NULL?
13	PNCITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
14	PNIVI	Inventory Interface Y/N - Distribution	Character	UDC (H40 IV)	1	0	Allow NULL?
15	PNSTKT	Stocking Type	Character	UDC (41 I)	1	0	Allow NULL?
16	PNCLEV	Level - Inventory Cost	Character	UDC (H40 CL)	1	0	Allow NULL?
17	PNCONV	Conversion Factor	Numeric	Generic Edit	15	7	Allow NULL?
18	PNCNV2	Conversion Factor - Purchasing to Primar	Numeric	Generic Edit	15	7	Allow NULL?
19	PNJEL1	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
20	PNRWT1	Record Written Control 1	Character	Generic Edit	1	0	Allow NULL?
21	PNJEL2	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
22	PNRWT2	Record Written Control 2	Character	Generic Edit	1	0	Allow NULL?
23	PNJEL3	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
24	PNRWT3	Record Written Control 3	Character	Generic Edit	1	0	Allow NULL?
25	PNJEL4	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
26	PNRWT4	Record Written Control 4	Character	Generic Edit	1	0	Allow NULL?
27	PNJEL5	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
28	PNRWT5	Record Written Control 5	Character	Generic Edit	1	0	Allow NULL?
29	PNJEL6	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
30	PNRWT6	Record Written Control 6	Character	Generic Edit	1	0	Allow NULL?
31	PNJEL7	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
32	PNRWT7	Record Written Control 7	Character	Generic Edit	1	0	Allow NULL?
33	PNRWT8	Record Written Control 8	Character	Generic Edit	1	0	Allow NULL?
34	PNJEL8	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
35	PNRWT9	Record Written Control 9	Character	Generic Edit	1	0	Allow NULL?
36	PNJEL9	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
37	PNRWTA	Record Written Control 10	Character	Generic Edit	1	0	Allow NULL?
38	PNRWTB	Record Written Control 11	Character	Generic Edit	1	0	Allow NULL?
39	PNRWTD	Record Written Control 12	Character	Generic Edit	1	0	Allow NULL?
40	PNRWTE	Record Written Control 13	Character	Generic Edit	1	0	Allow NULL?
41	PNRWTF	Record Written Control 14	Character	Generic Edit	1	0	Allow NULL?
42	PNRWTG	Record Written Control 15	Character	Generic Edit	1	0	Allow NULL?
43	PNACIT	Action Item	Character	Generic Edit	1	0	Allow NULL?
44	PNBANI	Bank Account Number - Input Mode	String	Generic Edit	29	0	Allow NULL?
45	PNSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
46	PNSTA1	Amount - Sales Tax Tax Authority 1	Numeric	Generic Edit	15	2	Allow NULL?
47	PNSTA2	Amount - Sales Tax Tax Authority 2	Numeric	Generic Edit	15	2	Allow NULL?
48	PNDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
49	PNAC07	Category Code - Address Book 07	String	UDC (01 07)	3	0	Allow NULL?
50	PNDDJ	Date - Net Due	Date	Generic Edit	6	0
51	PNADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
52	PNATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
53	PNAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
54	PNACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
55	PNCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
56	PNCTAM	Amount - Foreign Tax	Numeric	Generic Edit	15	2	Allow NULL?
57	PNCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
58	PNCRC	Payment Handling Code	String	UDC (00 HC)	3	0	Allow NULL?
59	PNPYE	Payee Address Number	Numeric	Generic Edit	8	0	Allow NULL?
60	PNAPC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
61	PNRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
62	PNTNN	Flag for 1099	Character	Generic Edit	1	0	Allow NULL?
63	PNATAD	Amount - To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
64	PNCTAD	Amount - Currency To Distribute	Numeric	Generic Edit	15	2	Allow NULL?
65	PNUPAD	Units - Paid	Numeric	Generic Edit	15	0	Allow NULL?
66	PNCRRD	Currency Conversion Rate - Divisor	Numeric	Generic Edit	15	0	Allow NULL?
67	PNUNCS	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
68	PNFUC	Amount - Foreign Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
69	PNAEXP	Amount - Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
70	PNFEA	Amount - Foreign Extended Price	Numeric	Generic Edit	15	2	Allow NULL?
71	PNPCRT	Percent - Retainage	Numeric	Generic Edit	7	3	Allow NULL?
72	PNRETA	Amount - Retained	Numeric	Generic Edit	15	2	Allow NULL?
73	PNRETT	Amount - Deferred Tax On Retainage	Numeric	Generic Edit	15	2	Allow NULL?
74	PNREFA	Amount - Foreign Retained	Numeric	Generic Edit	15	2	Allow NULL?
75	PNREFT	Amount - Foreign Def Tax On Retainage	Numeric	Generic Edit	15	2	Allow NULL?
76	PNU	Units	Numeric	Generic Edit	15	2	Allow NULL?
77	PNAA	Amount	Numeric	Generic Edit	15	2	Allow NULL?
78	PNFAA	Foreign Amount	Numeric	Generic Edit	15	2	Allow NULL?
79	PNAA1	Amount	Numeric	Generic Edit	15	2	Allow NULL?
80	PNAA2	Amount	Numeric	Generic Edit	15	2	Allow NULL?
81	PNAN01	Amount - Net Posting 01	Numeric	Generic Edit	15	2	Allow NULL?
82	PNAN02	Amount - Net Posting 02	Numeric	Generic Edit	15	2	Allow NULL?
83	PNBCT1	Not To Exceed Processing Flag	Character	Generic Edit	1	0	Allow NULL?
84	PNBCT2	Control Flag 2	Character	UDC (48 BD)	1	0	Allow NULL?
85	PNTRR1	Triangulation Rate - From Currency	Numeric	Generic Edit	15	0	Allow NULL?
86	PNTRR2	Triangulation Rate - To Currency	Numeric	Generic Edit	15	0	Allow NULL?
87	PNTRD1	Triangulation Rate - From Currency	Numeric	Generic Edit	15	0	Allow NULL?
88	PNTRD2	Triangulation Rate - To Currency	Numeric	Generic Edit	15	0	Allow NULL?
89	PNCRCM	Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
90	PNABR1	Managerial Analysis Code 1	String	Generic Edit	12	0	Allow NULL?
91	PNABT1	Managerial Analysis Type 1	Character	UDC	1	0	Allow NULL?
92	PNABR2	Managerial Analysis Code 2	String	Generic Edit	12	0	Allow NULL?
93	PNABT2	Managerial Analysis Type 2	Character	UDC	1	0	Allow NULL?
94	PNABR3	Managerial Analysis Code 3	String	Generic Edit	12	0	Allow NULL?
95	PNABT3	Managerial Analysis Type 3	Character	UDC	1	0	Allow NULL?
96	PNABR4	Managerial Analysis Code 4	String	Generic Edit	12	0	Allow NULL?
97	PNABT4	Managerial Analysis Type 4	Character	UDC	1	0	Allow NULL?
98	PNRTNP	Retainage - Prior	Numeric	Generic Edit	15	2	Allow NULL?
99	PNFTNP	Retainage - Prior - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
100	PNMATC	Type - Match Record Type	Character	Generic Edit	1	0	Allow NULL?
101	PNAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
102	PNKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
103	PNDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
104	PNDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
105	PNSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
106	PNLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
107	PNNLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
108	PNALIN	Line - Associated	Numeric	Generic Edit	5	0	Allow NULL?
109	PNRTBY	Written By Program	String	Generic Edit	2	0	Allow NULL?
110	PNDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
111	PNDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
112	PNBALU	Contract Balances Updated Y/N	Character	Generic Edit	1	0	Allow NULL?
113	PNITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
114	PNLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
115	PNAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
116	PNIMCU	Item Business Unit	String	Generic Edit	12	0	Allow NULL?
117	PNLOCN	Location	String	Generic Edit	20	0	Allow NULL?
118	PNLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
119	PNLOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
120	PNLOTP	Lot Potency	Numeric	Generic Edit	15	3	Allow NULL?
121	PNVRMK	Supplier Remark	String	Generic Edit	30	0	Allow NULL?
122	PNCNID	Container I.D.	String	Generic Edit	20	0	Allow NULL?
123	PNNXTR	Status Code - Next	String	UDC (40 AT)	3	0	Allow NULL?
124	PNLTTR	Status Code - Last	String	UDC (40 AT)	3	0	Allow NULL?
125	PNTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
126	PNRCDJ	Date - Received	Date	Generic Edit	6	0
127	PNDRQJ	Date - Requested	Date	Generic Edit	6	0
128	PNPDDJ	Date - Scheduled Pick	Date	Generic Edit	6	0
129	PNOPDJ	Date - Original Promised Delivery	Date	Generic Edit	6	0
130	PNRCD	Reason Code	String	UDC (42 RC)	3	0	Allow NULL?
131	PNVINV	Supplier Invoice Number	String	Generic Edit	25	0	Allow NULL?
132	PNPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
133	PNPST	Pay Status Code	Character	UDC (00 PS)	1	0	Allow NULL?
134	PNLAND	Code - Landed Cost	Character	Generic Edit	1	0	Allow NULL?
135	PNPRP5	Purchasing Category Code 5	String	UDC (41 P5)	3	0	Allow NULL?
136	PNLVLA	Level Cost	String	UDC (40 CA)	3	0	Allow NULL?
137	PNILOG	Code - Invoice Logging	Character	Generic Edit	1	0	Allow NULL?
138	PNDLOG	Final Receipt Flag (Y or BLANK)	Character	Generic Edit	1	0	Allow NULL?
139	PNRTGC	Routing Process (Y/N)	Character	Generic Edit	1	0	Allow NULL?
140	PNRCPF	Leadtime Recalculated (Y/N)	Character	Generic Edit	1	0	Allow NULL?
141	PNAVCH	Code - Evaluated Receipt Settlement	Character	UDC (40 ER)	1	0	Allow NULL?
142	PNLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
143	PNGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
144	PNMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
145	PNCO	Company	String	Generic Edit	5	0	Allow NULL?
146	PNAID	Account ID	String	Generic Edit	8	0	Allow NULL?
147	PNANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
148	PNMACT	Multiple Accounts	Character	UDC (40 MU)	1	0	Allow NULL?
149	PNOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
150	PNOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
151	PNSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
152	PNASID	Serial Number	String	Generic Edit	25	0	Allow NULL?
153	PNSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
154	PNSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
155	PNKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
156	PNDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
157	PNDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
158	PNSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
159	PNDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
160	PNJELN	Journal Entry Line Number	Numeric	Generic Edit	7	0	Allow NULL?
161	PNVANI	Account Number - Received Not Vouchered	String	Generic Edit	29	0	Allow NULL?
162	PNTX	Purchasing Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
163	PNEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
164	PNTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
165	PNUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
166	PNUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	0	Allow NULL?
167	PNUPTD	Units - Paid to Date	Numeric	Generic Edit	15	0	Allow NULL?
168	PNUOPN	Units - Open	Numeric	Generic Edit	15	0	Allow NULL?
169	PNUREC	Units - Received	Numeric	Generic Edit	15	0	Allow NULL?
170	PNUCLO	Units - Closed	Numeric	Generic Edit	15	0	Allow NULL?
171	PNQTYS	Units - Stocked	Numeric	Generic Edit	15	0	Allow NULL?
172	PNQTYR	Units - Returned	Numeric	Generic Edit	15	0	Allow NULL?
173	PNQTYW	Units - Reworked	Numeric	Generic Edit	15	0	Allow NULL?
174	PNQTYC	Units - Scrapped	Numeric	Generic Edit	15	0	Allow NULL?
175	PNQTYJ	Units - Rejected	Numeric	Generic Edit	15	0	Allow NULL?
176	PNQTYA	Units - Adjusted	Numeric	Generic Edit	15	0	Allow NULL?
177	PNUOM3	Unit of Measure - Purchasing	String	UDC (00 UM)	2	0	Allow NULL?
178	PNPRRC	Amount - Unit Cost	Numeric	Generic Edit	15	4	Allow NULL?
179	PNECST	Amount - Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
180	PNAPTD	Amount - Paid to Date	Numeric	Generic Edit	15	2	Allow NULL?
181	PNAOPN	Amount - Open	Numeric	Generic Edit	15	2	Allow NULL?
182	PNAREC	Amount - Received	Numeric	Generic Edit	15	2	Allow NULL?
183	PNACLO	Amount - Closed	Numeric	Generic Edit	15	2	Allow NULL?
184	PNAVCO	Amount - Average Cost Difference	Numeric	Generic Edit	15	2	Allow NULL?
185	PNVARC	Amount - Cost Variance	Numeric	Generic Edit	15	2	Allow NULL?
186	PNCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
187	PNCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
188	PNFRRC	Amount - Foreign Unit Price	Numeric	Generic Edit	15	4	Allow NULL?
189	PNFEC	Amount - Foreign Extended Cost	Numeric	Generic Edit	15	2	Allow NULL?
190	PNFAP	Amount - Foreign Open	Numeric	Generic Edit	15	2	Allow NULL?
191	PNFAPT	Amount - Foreign Amount Paid to Date	Numeric	Generic Edit	15	2	Allow NULL?
192	PNFREC	Amount - Received Foreign	Numeric	Generic Edit	15	2	Allow NULL?
193	PNFCLO	Amount - Foreign Closed	Numeric	Generic Edit	15	2	Allow NULL?
194	PNADWT	Additional Work Tax	Numeric	Generic Edit	7	0	Allow NULL?
195	PNURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
196	PNURDT	User Reserved Date	Date	Generic Edit	6	0
197	PNURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
198	PNURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
199	PNURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
200	PNTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
201	PNPEID	Process ID	Numeric	Generic Edit	15	0	Allow NULL?
202	PNTCID	Transaction ID	Numeric	Generic Edit	15	0	Allow NULL?
203	PNUSER	User ID	String	Generic Edit	10	0	Allow NULL?
204	PNPID	Program ID	String	Generic Edit	10	0	Allow NULL?
205	PNJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
206	PNTERM	terminal identification	String	Generic Edit	10	0	Allow NULL?
207	PNUPMJ	Date - Updated	Date	Generic Edit	6	0
208	PNTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
209	PNJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
210	PNSRQTY	Service Quantity	Numeric	Generic Edit	15	4	Allow NULL?
211	PNSRUOM	Service Unit of Measure	String	UDC (00 UM)	2	0	Allow NULL?
212	PNNBRU	Non-Billable Retainage Used	Character	Generic Edit	1	0	Allow NULL?
213	PNNEWR	Expense At Voucher	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 43 | F4314Z INDEXES

Number

Description

ComID JobN Line No (Primary/Unique)

Element	Alias	Description	Sequence
1	CTID	Computer ID	Ascending
2	JOBS	Job Number	Ascending
3	XTLN	Transaction Line Number	Ascending
4	DLNID	DistributionLine Number	Ascending

DocNo OTy OrCo

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	MATC	Type - Match Record Type	Ascending
7	NLIN	Number of Lines	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

213 COLUMNS | 2 INDEXES | 920 | 43 | F4314Z TABLE

TOP 920 | 43 | F4314Z COLUMNS

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

213 COLUMNS | 2 INDEXES | 920 | 43 | F4314Z TABLE

TOP920 | 43 | F4314Z COLUMNS

TOP920 | 43 | F4314Z INDEXES

TOP 920 | 43 | F4314Z COLUMNS

TOP 920 | 43 | F4314Z INDEXES