	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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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	F4311	PD	Purchase Order Detail File
10	F4111	IL	Item Ledger File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0411	RP	Accounts Payable Ledger
5	F0006	MC	Business Unit Master
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

72 COLUMNS | 3 INDEXES | 812 | 00 | F004201 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
00: Foundation Environment
1	812	F004201	PT	72	3	Prepayment Transaction Table	Transaction Files	42: Sales Management	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 PTDOCO, PTDCTO, PTKCOO, PTSFXO, PTLNID, PTSEQ, PTPOF, PTRYIN, PTATS, PTPERE, PTATRD, PTATRM, PTABTM, PTATRI, PTAEXD, PTSETD, PTSTRM, PTSBTM, PTSEMD, PTTRFC, PTTFEE, PTALPH, PTAN8, PTADD1, PTADD2, PTCTY1, PTADDS, PTMSZC, PTCTR, PTCBNK, PTCEXP, PTCARD, PTDL01, PTCRCI, PTCASP, PTCHKP, PTCKNU, PTOPY1, PTOPY2, PTCRCD, PTSHAN, PTEMCU, PTMCU, PTTRDJ, PTITM, PTLNTY, PTUORG, PTPTC, PTTXA1, PTTAX1, PTEXR1, PTSTAM, PTFUT1, PTFUT2, PTFUT3, PTFUT4, PTFUT5, PTFFG1, PTFFG2, PTURCD, PTURDT, PTURAT, PTURAB, PTURRF, PTTORG, PTUSER, PTPID, PTJOBN, PTUPMJ, PTTDAY, PTFFG3, PTFFG4 FROM F004201

TOP 812 | 00 | F004201 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	PTDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
2	PTDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
3	PTKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
4	PTSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
5	PTLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
6	PTSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
7	PTPOF	PrepaymentOriginationFlag	String	UDC (00 PO)	2	0	Allow NULL?
8	PTRYIN	Payment Instrument	Character	UDC (00 PY)	1	0	Allow NULL?
9	PTATS	Prepayment Transaction Status	String	UDC (00 SP)	2	0	Allow NULL?
10	PTPERE	Prepayment Error Reason Code	String	UDC (00 RP)	3	0	Allow NULL?
11	PTATRD	Authorization Transaction Date	Date	Generic Edit	6	0
12	PTATRM	Authorize - Transaction Amount	Numeric	Generic Edit	15	4	Allow NULL?
13	PTABTM	Authorize - Batch Number	String	Generic Edit	30	0	Allow NULL?
14	PTATRI	Authorize - Transaction ID	String	Generic Edit	25	0	Allow NULL?
15	PTAEXD	Authorization Expiry Date	Date	Generic Edit	6	0
16	PTSETD	Settle - Transaction Date	Date	Generic Edit	6	0
17	PTSTRM	Settle - Transaction Amount	Numeric	Generic Edit	15	4	Allow NULL?
18	PTSBTM	Settle - Batch Number	Numeric	Generic Edit	30	0	Allow NULL?
19	PTSEMD	Settlement Date	Date	Generic Edit	6	0
20	PTTRFC	Transaction Fee Code	String	UDC (00 FC)	10	0	Allow NULL?
21	PTTFEE	Transaction Fee	Numeric	Generic Edit	15	4	Allow NULL?
22	PTALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
23	PTAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
24	PTADD1	Address Line 1	String	Generic Edit	40	0	Allow NULL?
25	PTADD2	Address Line 2	String	Generic Edit	40	0	Allow NULL?
26	PTCTY1	City	String	Generic Edit	25	0	Allow NULL?
27	PTADDS	State	String	UDC (00 S)	3	0	Allow NULL?
28	PTMSZC	Zip Code	String	Generic Edit	5	0	Allow NULL?
29	PTCTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
30	PTCBNK	Bank Account Number - Customer	String	Generic Edit	20	0	Allow NULL?
31	PTCEXP	Date - Expired (Julian)	Date	Generic Edit	6	0
32	PTCARD	Credit Card Type	String	UDC (00 CA)	4	0	Allow NULL?
33	PTDL01	Description	String	Generic Edit	30	0	Allow NULL?
34	PTCRCI	Credit Card Account Number	String	Generic Edit	25	0	Allow NULL?
35	PTCASP	Cash Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
36	PTCHKP	Check Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
37	PTCKNU	Receipt Number	String	Generic Edit	25	0	Allow NULL?
38	PTOPY1	Other Payment Amount 1	Numeric	Generic Edit	15	2	Allow NULL?
39	PTOPY2	Other Payment Amount 2	Numeric	Generic Edit	15	2	Allow NULL?
40	PTCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
41	PTSHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
42	PTEMCU	Business Unit - Header	String	Generic Edit	12	0	Allow NULL?
43	PTMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
44	PTTRDJ	Date - Order/Transaction	Date	Generic Edit	6	0
45	PTITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
46	PTLNTY	Line Type	String	Generic Edit	2	0	Allow NULL?
47	PTUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
48	PTPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
49	PTTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
50	PTTAX1	Sales Taxable (Y/N)	Character	UDC (H00 TV)	1	0	Allow NULL?
51	PTEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
52	PTSTAM	Amount - Tax	Numeric	Generic Edit	15	2	Allow NULL?
53	PTFUT1	Future Use 1	Numeric	Generic Edit	15	2	Allow NULL?
54	PTFUT2	Future Use 2	Numeric	Generic Edit	15	2	Allow NULL?
55	PTFUT3	Future Use 3 - Description	String	Generic Edit	30	0	Allow NULL?
56	PTFUT4	Future Use 4 - Reference	String	Generic Edit	25	0	Allow NULL?
57	PTFUT5	Future Use 5 - Reference	String	Generic Edit	25	0	Allow NULL?
58	PTFFG1	Flag for Future 01	Character	Generic Edit	1	0	Allow NULL?
59	PTFFG2	Flag for Future 02	Character	Generic Edit	1	0	Allow NULL?
60	PTURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
61	PTURDT	User Reserved Date	Date	Generic Edit	6	0
62	PTURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
63	PTURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
64	PTURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
65	PTTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
66	PTUSER	User ID	String	Generic Edit	10	0	Allow NULL?
67	PTPID	Program ID	String	Generic Edit	10	0	Allow NULL?
68	PTJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
69	PTUPMJ	Date - Updated	Date	Generic Edit	6	0
70	PTTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
71	PTFFG3	Flag for Future 03	Character	Generic Edit	1	0	Allow NULL?
72	PTFFG4	Flag for Future 04	Character	Generic Edit	1	0	Allow NULL?

TOP 812 | 00 | F004201 INDEXES

Number

Description

DOCO DCTO KCOO + (Primary/Unique)

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	SEQ	Sequence Number	Ascending
7	POF	PrepaymentOriginationFlag	Ascending

DOCO DCTO KCOO +

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	SEQ	Sequence Number	Ascending
6	POF	PrepaymentOriginationFlag	Ascending

RYIN DOCO DCTY +

Element	Alias	Description	Sequence
1	RYIN	Payment Instrument	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	POF	PrepaymentOriginationFlag	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

72 COLUMNS | 3 INDEXES | 812 | 00 | F004201 TABLE

TOP 812 | 00 | F004201 COLUMNS

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

72 COLUMNS | 3 INDEXES | 812 | 00 | F004201 TABLE

TOP812 | 00 | F004201 COLUMNS

TOP812 | 00 | F004201 INDEXES

TOP 812 | 00 | F004201 COLUMNS

TOP 812 | 00 | F004201 INDEXES