	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

99 COLUMNS | 4 INDEXES | 920 | 74U | F74U0420 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
74U: United Kingdom Localizations
1	920	F74U0420	SE	99	4	SPC - Application Master - UK - 43	Master Files	74U: United Kingdom Localizations

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 SEUKAPNM, SEUKAPDT, SEUKAPRF, SEDOCO, SEDCTO, SEKCOO, SESFXO, SE74UALN, SELNID, SEUKCENM, SE74UCLN, SE74USPCS, SEAN8, SECO, SEMCU, SEOBJ, SESUB, SESBL, SESBLT, SEGLC, SEDGL, SEDDJ, SEDSVJ, SECTRY, SEFY, SEPN, SEICU, SEICUT, SEDOCZ, SEDCTI, SEKCOI, SESFX, SETXA1, SEEXR1, SEPTC, SEAG, SE74UNT, SEUKAPAM, SEATXA, SE74UAVAT, SEADSC, SEUKAPQT, SEUKAPPE, SE74UCG, SE74UCN, SEUKAPCA, SE74UACVAT, SEUKAPCQ, SEUKAPCP, SECRRM, SECRCD, SECRCF, SECRR, SEACR, SE74UFNT, SEUKAPFA, SECTXA, SE74UFAVAT, SECDS, SE74UFCG, SE74UFCN, SEUKAPFC, SE74UFCAV, SE74UPRET, SERTNG, SE74UCR, SEFTNG, SE74UFCR, SE74UMCDR, SE74UMCDA, SE74UMCDCA, SE74UFMCDA, SE74UFMCDC, SERMK, SEUKURRF, SEUKURDT, SE74UACC1, SE74UACC2, SE74UACC3, SE74UACC4, SE74UACC5, SEURAT, SEURCD, SEURDT, SEURAB, SEURRF, SEPID, SEJOBN, SEUSER, SEUPMJ, SEUPMT, SEOMCU, SEAID, SEANI, SE74UPLAD, SE74UPMAD, SE74UPLAF, SE74UPMAF, SE74ULMSP FROM F74U0420

TOP 920 | 74U | F74U0420 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SEUKAPNM	Application Number	Numeric	Generic Edit	6	0	Allow NULL?
2	SEUKAPDT	Application Date	Date	Generic Edit	6	0
3	SEUKAPRF	Application Reference	String	Generic Edit	30	0	Allow NULL?
4	SEDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
5	SEDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
6	SEKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
7	SESFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
8	SE74UALN	Application Line Number	Numeric	Generic Edit	6	3	Allow NULL?
9	SELNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
10	SEUKCENM	Certificate Number	Numeric	Generic Edit	6	0	Allow NULL?
11	SE74UCLN	Certificate Line Number	Numeric	Generic Edit	6	3	Allow NULL?
12	SE74USPCS	SPC Status	String	UDC (74U SS)	3	0	Allow NULL?
13	SEAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
14	SECO	Company	String	Generic Edit	5	0	Allow NULL?
15	SEMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
16	SEOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
17	SESUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
18	SESBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
19	SESBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
20	SEGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
21	SEDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
22	SEDDJ	Date - Net Due	Date	Generic Edit	6	0
23	SEDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
24	SECTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
25	SEFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
26	SEPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
27	SEICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
28	SEICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
29	SEDOCZ	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
30	SEDCTI	Document Type - Invoice Only	String	UDC (00 DI)	2	0	Allow NULL?
31	SEKCOI	Document Company (Invoice)	String	Generic Edit	5	0	Allow NULL?
32	SESFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
33	SETXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
34	SEEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
35	SEPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
36	SEAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
37	SE74UNT	Net Amount	Numeric	Generic Edit	15	2	Allow NULL?
38	SEUKAPAM	Application Amount	Numeric	Generic Edit	15	2	Allow NULL?
39	SEATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
40	SE74UAVAT	Application VAT	Numeric	Generic Edit	15	2	Allow NULL?
41	SEADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
42	SEUKAPQT	Application Quantity	Numeric	Generic Edit	15	0	Allow NULL?
43	SEUKAPPE	Application Percentage	Numeric	Generic Edit	5	2	Allow NULL?
44	SE74UCG	Cumulative Gross Amount	Numeric	Generic Edit	15	2	Allow NULL?
45	SE74UCN	Cumulative Net Amount	Numeric	Generic Edit	15	2	Allow NULL?
46	SEUKAPCA	Application Cumulative Amount	Numeric	Generic Edit	15	2	Allow NULL?
47	SE74UACVAT	Cumulative Application VAT	Numeric	Generic Edit	15	2	Allow NULL?
48	SEUKAPCQ	Application Cumulative Quantity	Numeric	Generic Edit	15	0	Allow NULL?
49	SEUKAPCP	Application Cumulative Percentage	Numeric	Generic Edit	5	2	Allow NULL?
50	SECRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
51	SECRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
52	SECRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
53	SECRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
54	SEACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
55	SE74UFNT	Currency Net Amount	Numeric	Generic Edit	15	2	Allow NULL?
56	SEUKAPFA	Application Foreign Currency ( Period )	Numeric	Generic Edit	15	2	Allow NULL?
57	SECTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
58	SE74UFAVAT	Foreign Application VAT	Numeric	Generic Edit	15	2	Allow NULL?
59	SECDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
60	SE74UFCG	Currency Cumulative Gross Amount	Numeric	Generic Edit	15	2	Allow NULL?
61	SE74UFCN	Currency Cumulative Net Amount	Numeric	Generic Edit	15	2	Allow NULL?
62	SEUKAPFC	Application Foreign Currency-Cumulative	Numeric	Generic Edit	15	2	Allow NULL?
63	SE74UFCAV	Foreign Cumulative Application VAT	Numeric	Generic Edit	15	2	Allow NULL?
64	SE74UPRET	Retention Percentage	Numeric	Generic Edit	5	2	Allow NULL?
65	SERTNG	Retainage	Numeric	Generic Edit	15	2	Allow NULL?
66	SE74UCR	Cumulative Retention	Numeric	Generic Edit	15	2	Allow NULL?
67	SEFTNG	Retainage - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
68	SE74UFCR	Foreign Cumulative Retention	Numeric	Generic Edit	15	2	Allow NULL?
69	SE74UMCDR	MCD Rate	Numeric	Generic Edit	5	2	Allow NULL?
70	SE74UMCDA	MCD Amount	Numeric	Generic Edit	15	2	Allow NULL?
71	SE74UMCDCA	MCD Amount Cumulative	Numeric	Generic Edit	15	2	Allow NULL?
72	SE74UFMCDA	MCD Foreign Amount	Numeric	Generic Edit	15	2	Allow NULL?
73	SE74UFMCDC	Foreign Cumulative MCD Amount	Numeric	Generic Edit	15	2	Allow NULL?
74	SERMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
75	SEUKURRF	PreCertificateIssuedTo	String	Generic Edit	15	0	Allow NULL?
76	SEUKURDT	Pre Certificate Print Date	Date	Generic Edit	6	0
77	SE74UACC1	Application Catagory Code 1	String	Generic Edit	3	0	Allow NULL?
78	SE74UACC2	Application Catagory Code 2	String	Generic Edit	3	0	Allow NULL?
79	SE74UACC3	Application Catagory Code 3	String	Generic Edit	10	0	Allow NULL?
80	SE74UACC4	Application Catagory Code 4	String	Generic Edit	10	0	Allow NULL?
81	SE74UACC5	Application Catagory Code 5	Numeric	Generic Edit	15	2	Allow NULL?
82	SEURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
83	SEURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
84	SEURDT	User Reserved Date	Date	Generic Edit	6	0
85	SEURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
86	SEURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
87	SEPID	Program ID	String	Generic Edit	10	0	Allow NULL?
88	SEJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
89	SEUSER	User ID	String	Generic Edit	10	0	Allow NULL?
90	SEUPMJ	Date - Updated	Date	Generic Edit	6	0
91	SEUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
92	SEOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
93	SEAID	Account ID	String	Generic Edit	8	0	Allow NULL?
94	SEANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
95	SE74UPLAD	SPC Period Labour Amount Domestic	Numeric	Generic Edit	15	2	Allow NULL?
96	SE74UPMAD	SPC Period Materials Amount Domestic	Numeric	Generic Edit	15	2	Allow NULL?
97	SE74UPLAF	SPC Period Labour Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
98	SE74UPMAF	SPC Period Materials Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
99	SE74ULMSP	Labour Materials Split Percentage	Numeric	Generic Edit	5	2	Allow NULL?

TOP 920 | 74U | F74U0420 INDEXES

Number

Description

Appl No Ord No A+ (Primary/Unique)

Element	Alias	Description	Sequence
1	UKAPNM	Application Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	SFXO	Order Suffix	Ascending
6	74UALN	Application Line Number	Ascending

Co No Doc No A+

Element	Alias	Description	Sequence
1	KCOO	Order Company (Order Number)	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	UKAPNM	Application Number	Ascending
5	74UALN	Application Line Number	Ascending

Appl No Ord No B+

Element	Alias	Description	Sequence
1	UKAPNM	Application Number	Ascending
2	DOCO	Document (Order No Invoice etc.)	Ascending
3	DCTO	Order Type	Ascending
4	KCOO	Order Company (Order Number)	Ascending
5	SFXO	Order Suffix	Ascending
6	LNID	Line Number	Ascending

Cost Cen

Element	Alias	Description	Sequence
1	MCU	Business Unit	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

99 COLUMNS | 4 INDEXES | 920 | 74U | F74U0420 TABLE

TOP 920 | 74U | F74U0420 COLUMNS

TOP 920 | 74U | F74U0420 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

99 COLUMNS | 4 INDEXES | 920 | 74U | F74U0420 TABLE

TOP920 | 74U | F74U0420 COLUMNS

TOP920 | 74U | F74U0420 INDEXES

TOP 920 | 74U | F74U0420 COLUMNS

TOP 920 | 74U | F74U0420 INDEXES