	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

64 COLUMNS | 5 INDEXES | 920 | 70 | F704002P TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
70: Multi-National Products
1	920	F704002P	PF	64	5	Payment WH Info Purge - COMM - 04	Files	70: Multi-National Products

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 PFK70BTXC, PFPYID, PFDCTM, PFDOCM, PFOKCO, PFODCT, PFODOC, PFOSFX, PFKCO, PFDCT, PFDOC, PFSFX, PFSFXE, PFCO, PFTX2, PFK70BCNC, PFK70BJRD, PFAN8, PFTAX, PFCTRY, PFFY, PFPN, PFK70BORB, PFK70BREB, PFK70BSRB, PFK70BPRB, PFK70BPOB, PFK70BAAB, PFK70BCAB, PFK70BRT1, PFK70BORW, PFK70BAAW, PFK70BREW, PFK70BSRW, PFK70BPRW, PFK70BATW, PFK70BPOW, PFK70BCAW, PFDMTJ, PFVDGJ, PFVR01, PFFYR, PFK70ACEM, PFN001, PFAN80, PFFCO, PFK70UEMF, PFK70PSPI, PFCRRM, PFBCRC, PFCRCD, PFCRR, PFCRR1, PFCRR2, PFCRCM, PFURC1, PFURDT, PFURRF, PFURAT, PFUSER, PFPID, PFJOBN, PFUPMJ, PFUPMT FROM F704002P

TOP 920 | 70 | F704002P COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PFK70BTXC	Tax Code	String	UDC (70 TX)	10	0	Allow NULL?
2	PFPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
3	PFDCTM	Document Type - Matching	String	UDC (00 DT)	2	0	Allow NULL?
4	PFDOCM	Document - Matching(Payment or Item)	Numeric	Generic Edit	8	0	Allow NULL?
5	PFOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
6	PFODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
7	PFODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
8	PFOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
9	PFKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
10	PFDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
11	PFDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
12	PFSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
13	PFSFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0	Allow NULL?
14	PFCO	Company	String	Generic Edit	5	0	Allow NULL?
15	PFTX2	Tax ID - Additional - Individual	String	Generic Edit	20	0	Allow NULL?
16	PFK70BCNC	Concept	String	Generic Edit	10	0	Allow NULL?
17	PFK70BJRD	Tax/Withholding Jurisdiction	String	Generic Edit	4	0	Allow NULL?
18	PFAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
19	PFTAX	Tax ID	String	Generic Edit	20	0	Allow NULL?
20	PFCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
21	PFFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
22	PFPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
23	PFK70BORB	Original Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
24	PFK70BREB	Reduction Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
25	PFK70BSRB	Supplier Reduction Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
26	PFK70BPRB	Precedents Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
27	PFK70BPOB	Payments to Other Co Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
28	PFK70BAAB	Accumulated Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
29	PFK70BCAB	Calculated Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
30	PFK70BRT1	Percentage	Numeric	Generic Edit	5	2	Allow NULL?
31	PFK70BORW	Original Tax Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
32	PFK70BAAW	Accumulated Tax Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
33	PFK70BREW	Reduction Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
34	PFK70BSRW	Supplier Reduct Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
35	PFK70BPRW	Precedents Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
36	PFK70BATW	Addition to Tax Withholding	Numeric	Generic Edit	15	2	Allow NULL?
37	PFK70BPOW	Payments Other Co Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
38	PFK70BCAW	Calculated Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
39	PFDMTJ	Date - Matching Check or Item - Julian	Date	Generic Edit	6	0
40	PFVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
41	PFVR01	Reference	String	Generic Edit	25	0	Allow NULL?
42	PFFYR	Fiscal Year	Numeric	Generic Edit	4	0	Allow NULL?
43	PFK70ACEM	Issue Place	String	Generic Edit	4	0	Allow NULL?
44	PFN001	Next Number Range 1	Numeric	Generic Edit	8	0	Allow NULL?
45	PFAN80	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
46	PFFCO	Company From	String	Generic Edit	5	0	Allow NULL?
47	PFK70UEMF	Under Equal Minimum Flag	Character	Generic Edit	1	0	Allow NULL?
48	PFK70PSPI	Flag Payment In Spice	Character	Generic Edit	1	0	Allow NULL?
49	PFCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
50	PFBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
51	PFCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
52	PFCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
53	PFCRR1	Triangulation Leg 1	Numeric	Generic Edit	15	0	Allow NULL?
54	PFCRR2	Triangulation Leg 2	Numeric	Generic Edit	15	0	Allow NULL?
55	PFCRCM	Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
56	PFURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
57	PFURDT	User Reserved Date	Date	Generic Edit	6	0
58	PFURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
59	PFURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
60	PFUSER	User ID	String	Generic Edit	10	0	Allow NULL?
61	PFPID	Program ID	String	Generic Edit	10	0	Allow NULL?
62	PFJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
63	PFUPMJ	Date - Updated	Date	Generic Edit	6	0
64	PFUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 70 | F704002P INDEXES

Number

Description

BTXC PYID DCTM DOCM OKCO +... (Primary/Unique)

Element	Alias	Description	Sequence
1	K70BTXC	Tax Code	Ascending
2	PYID	Payment ID (Internal)	Ascending
3	DCTM	Document Type - Matching	Ascending
4	DOCM	Document - Matching(Payment or Item)	Ascending
5	OKCO	Document Company (Original Order)	Ascending
6	ODCT	Document Type - Original	Ascending
7	ODOC	Document - Original	Ascending
8	OSFX	Document Pay Item - Original	Ascending
9	KCO	Document Company	Ascending
10	DCT	Document Type	Ascending
11	DOC	Document (Voucher Invoice etc.)	Ascending
12	SFX	Document Pay Item	Ascending
13	SFXE	Pay Item Extension Number	Ascending

BTXC KCO DCT DOC SFX SFXE

Element	Alias	Description	Sequence
1	K70BTXC	Tax Code	Ascending
2	KCO	Document Company	Ascending
3	DCT	Document Type	Ascending
4	DOC	Document (Voucher Invoice etc.)	Ascending
5	SFX	Document Pay Item	Ascending
6	SFXE	Pay Item Extension Number	Ascending

BTXC OKCO ODCT ODOC OSFX ..

Element	Alias	Description	Sequence
1	K70BTXC	Tax Code	Ascending
2	OKCO	Document Company (Original Order)	Ascending
3	ODCT	Document Type - Original	Ascending
4	ODOC	Document - Original	Ascending
5	OSFX	Document Pay Item - Original	Ascending

BTXC PYID

Element	Alias	Description	Sequence
1	K70BTXC	Tax Code	Ascending
2	PYID	Payment ID (Internal)	Ascending

PYID

Element	Alias	Description	Sequence
1	PYID	Payment ID (Internal)	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

64 COLUMNS | 5 INDEXES | 920 | 70 | F704002P TABLE

TOP 920 | 70 | F704002P COLUMNS

TOP 920 | 70 | F704002P 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

64 COLUMNS | 5 INDEXES | 920 | 70 | F704002P TABLE

TOP920 | 70 | F704002P COLUMNS

TOP920 | 70 | F704002P INDEXES

TOP 920 | 70 | F704002P COLUMNS

TOP 920 | 70 | F704002P INDEXES