	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

66 COLUMNS | 4 INDEXES | 920 | 70 | F704001 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
70: Multi-National Products
1	920	F704001	PT	66	4	Payment WH Info TEMP - 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 PTK70BTXC, PTHDC, PTCKC, PTDCTM, PTDOCM, PTOKCO, PTODCT, PTODOC, PTOSFX, PTKCO, PTDCT, PTDOC, PTSFX, PTSFXE, PTCO, PTTX2, PTK70BCNC, PTK70BJRD, PTAN8, PTTAX, PTCTRY, PTFY, PTPN, PTK70BORB, PTK70BREB, PTK70BSRB, PTK70BPRB, PTK70BPOB, PTK70BAAB, PTK70BCAB, PTK70BRT1, PTK70BORW, PTK70BAAW, PTK70BREW, PTK70BSRW, PTK70BPRW, PTK70BATW, PTK70BPOW, PTK70BCAW, PTDMTJ, PTVDGJ, PTVR01, PTFYR, PTK70ACEM, PTN001, PTAN80, PTFCO, PTK70UEMF, PTK70PSPI, PTCRRM, PTBCRC, PTCRCD, PTCRR, PTCRR1, PTCRR2, PTCRCM, PTURC1, PTURDT, PTURAT, PTURAB, PTURRF, PTUSER, PTPID, PTJOBN, PTUPMJ, PTUPMT FROM F704001

TOP 920 | 70 | F704001 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PTK70BTXC	Tax Code	String	UDC (70 TX)	10	0	Allow NULL?
2	PTHDC	Payment Group Control Nbr - A/P Checks	Numeric	Generic Edit	8	0	Allow NULL?
3	PTCKC	Check Control Number - A/P Checks	Numeric	Generic Edit	8	0	Allow NULL?
4	PTDCTM	Document Type - Matching	String	UDC (00 DT)	2	0	Allow NULL?
5	PTDOCM	Document - Matching(Payment or Item)	Numeric	Generic Edit	8	0	Allow NULL?
6	PTOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
7	PTODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
8	PTODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
9	PTOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
10	PTKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
11	PTDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
12	PTDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
13	PTSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
14	PTSFXE	Pay Item Extension Number	Numeric	Generic Edit	2	0	Allow NULL?
15	PTCO	Company	String	Generic Edit	5	0	Allow NULL?
16	PTTX2	Tax ID - Additional - Individual	String	Generic Edit	20	0	Allow NULL?
17	PTK70BCNC	Concept	String	Generic Edit	10	0	Allow NULL?
18	PTK70BJRD	Tax/Withholding Jurisdiction	String	Generic Edit	4	0	Allow NULL?
19	PTAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
20	PTTAX	Tax ID	String	Generic Edit	20	0	Allow NULL?
21	PTCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
22	PTFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
23	PTPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
24	PTK70BORB	Original Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
25	PTK70BREB	Reduction Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
26	PTK70BSRB	Supplier Reduction Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
27	PTK70BPRB	Precedents Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
28	PTK70BPOB	Payments to Other Co Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
29	PTK70BAAB	Accumulated Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
30	PTK70BCAB	Calculated Base Amount	Numeric	Generic Edit	15	2	Allow NULL?
31	PTK70BRT1	Percentage	Numeric	Generic Edit	5	2	Allow NULL?
32	PTK70BORW	Original Tax Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
33	PTK70BAAW	Accumulated Tax Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
34	PTK70BREW	Reduction Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
35	PTK70BSRW	Supplier Reduct Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
36	PTK70BPRW	Precedents Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
37	PTK70BATW	Addition to Tax Withholding	Numeric	Generic Edit	15	2	Allow NULL?
38	PTK70BPOW	Payments Other Co Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
39	PTK70BCAW	Calculated Tax/Withholding Amount	Numeric	Generic Edit	15	2	Allow NULL?
40	PTDMTJ	Date - Matching Check or Item - Julian	Date	Generic Edit	6	0
41	PTVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
42	PTVR01	Reference	String	Generic Edit	25	0	Allow NULL?
43	PTFYR	Fiscal Year	Numeric	Generic Edit	4	0	Allow NULL?
44	PTK70ACEM	Issue Place	String	Generic Edit	4	0	Allow NULL?
45	PTN001	Next Number Range 1	Numeric	Generic Edit	8	0	Allow NULL?
46	PTAN80	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
47	PTFCO	Company From	String	Generic Edit	5	0	Allow NULL?
48	PTK70UEMF	Under Equal Minimum Flag	Character	Generic Edit	1	0	Allow NULL?
49	PTK70PSPI	Flag Payment In Spice	Character	Generic Edit	1	0	Allow NULL?
50	PTCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
51	PTBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
52	PTCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
53	PTCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
54	PTCRR1	Triangulation Leg 1	Numeric	Generic Edit	15	0	Allow NULL?
55	PTCRR2	Triangulation Leg 2	Numeric	Generic Edit	15	0	Allow NULL?
56	PTCRCM	Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
57	PTURC1	User Reserved Code	String	Generic Edit	3	0	Allow NULL?
58	PTURDT	User Reserved Date	Date	Generic Edit	6	0
59	PTURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
60	PTURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
61	PTURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
62	PTUSER	User ID	String	Generic Edit	10	0	Allow NULL?
63	PTPID	Program ID	String	Generic Edit	10	0	Allow NULL?
64	PTJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
65	PTUPMJ	Date - Updated	Date	Generic Edit	6	0
66	PTUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?

TOP 920 | 70 | F704001 INDEXES

Number

Description

K70BTXC HDC CKC DCTM DOCM + (Primary/Unique)

Element	Alias	Description	Sequence
1	K70BTXC	Tax Code	Ascending
2	HDC	Payment Group Control Nbr - A/P Checks	Ascending
3	CKC	Check Control Number - A/P Checks	Ascending
4	DCTM	Document Type - Matching	Ascending
5	DOCM	Document - Matching(Payment or Item)	Ascending
6	OKCO	Document Company (Original Order)	Ascending
7	ODCT	Document Type - Original	Ascending
8	ODOC	Document - Original	Ascending
9	OSFX	Document Pay Item - Original	Ascending
10	KCO	Document Company	Ascending
11	DCT	Document Type	Ascending
12	DOC	Document (Voucher Invoice etc.)	Ascending
13	SFX	Document Pay Item	Ascending
14	SFXE	Pay Item Extension Number	Ascending

B70TXC HDC CKC

Element	Alias	Description	Sequence
1	K70BTXC	Tax Code	Ascending
2	HDC	Payment Group Control Nbr - A/P Checks	Ascending
3	CKC	Check Control Number - A/P Checks	Ascending

K70BTXC 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

K70BTXC 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

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

66 COLUMNS | 4 INDEXES | 920 | 70 | F704001 TABLE

TOP 920 | 70 | F704001 COLUMNS

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

66 COLUMNS | 4 INDEXES | 920 | 70 | F704001 TABLE

TOP920 | 70 | F704001 COLUMNS

TOP920 | 70 | F704001 INDEXES

TOP 920 | 70 | F704001 COLUMNS

TOP 920 | 70 | F704001 INDEXES