	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

104 COLUMNS | 4 INDEXES | 920 | 74U | F74U0425 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
74U: United Kingdom Localizations
1	920	F74U0425	SF	104	4	SPC - Certificate 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 SFUKCENM, SFUKCEDT, SF74UACR, SFDOCO, SFDCTO, SFKCOO, SFSFXO, SF74UCLN, SFMATC, SFLNID, SF74USPCS, SFUKAPNM, SF74UALN, SFAN8, SFCO, SFMCU, SFOBJ, SFSUB, SFSBL, SFSBLT, SFGLC, SFDGL, SFDDJ, SFDSVJ, SFCTRY, SFFY, SFPN, SFDOC, SFICU, SFICUT, SFDOCZ, SFDCTI, SFKCOI, SFSFX, SFTXA1, SFEXR1, SFPTC, SFAG, SF74UNT, SFUKCEAM, SFATXA, SF74UCVAT, SFADSC, SFUKCEQT, SFUKCEPE, SF74UCG, SF74UCN, SFUKCECA, SF74UCCVAT, SFUKCECQ, SFUKCECP, SFCRRM, SFCRCD, SFCRCF, SFCRR, SFACR, SF74UFNT, SFUKCEFA, SFCTXA, SF74UFVAT, SFCDS, SF74UFCG, SF74UFCN, SFUKCEFC, SF74UFCVAT, SF74UPRET, SFRTNG, SF74UCR, SFFTNG, SF74UFCR, SF74UMCDR, SF74UMCDA, SF74UMCDCA, SF74UFMCDA, SF74UFMCDC, SFRMK, SFUKCEPD, SF74UARP, SF74UARR, SF74UCCC1, SF74UCCC2, SF74UCCC3, SF74UCCC4, SF74UCCC5, SFURAT, SFURCD, SFURDT, SFURAB, SFURRF, SFPID, SFJOBN, SFUSER, SFUPMJ, SFUPMT, SFOMCU, SFANI, SFAID, SFNLIN, SF74UPLAD, SF74UPMAD, SF74UPLAF, SF74UPMAF, SF74ULMSP, SF74UMLMS FROM F74U0425

TOP 920 | 74U | F74U0425 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SFUKCENM	Certificate Number	Numeric	Generic Edit	6	0	Allow NULL?
2	SFUKCEDT	Certificate Date	Date	Generic Edit	6	0
3	SF74UACR	Alternate Certificate Reference	String	Generic Edit	15	0	Allow NULL?
4	SFDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
5	SFDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
6	SFKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
7	SFSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
8	SF74UCLN	Certificate Line Number	Numeric	Generic Edit	6	3	Allow NULL?
9	SFMATC	Type - Match Record Type	Character	Generic Edit	1	0	Allow NULL?
10	SFLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
11	SF74USPCS	SPC Status	String	UDC (74U SS)	3	0	Allow NULL?
12	SFUKAPNM	Application Number	Numeric	Generic Edit	6	0	Allow NULL?
13	SF74UALN	Application Line Number	Numeric	Generic Edit	6	3	Allow NULL?
14	SFAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
15	SFCO	Company	String	Generic Edit	5	0	Allow NULL?
16	SFMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
17	SFOBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
18	SFSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
19	SFSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
20	SFSBLT	Subledger Type	Character	UDC (00 ST)	1	0	Allow NULL?
21	SFGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
22	SFDGL	Date - For G/L (and Voucher)	Date	Generic Edit	6	0
23	SFDDJ	Date - Net Due	Date	Generic Edit	6	0
24	SFDSVJ	Date - Service/Tax	Date	Generic Edit	6	0
25	SFCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
26	SFFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
27	SFPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
28	SFDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
29	SFICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
30	SFICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
31	SFDOCZ	Document (Order # Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
32	SFDCTI	Document Type - Invoice Only	String	UDC (00 DI)	2	0	Allow NULL?
33	SFKCOI	Document Company (Invoice)	String	Generic Edit	5	0	Allow NULL?
34	SFSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
35	SFTXA1	Tax Rate/Area	String	Generic Edit	10	0	Allow NULL?
36	SFEXR1	Tax Expl Code 1	String	UDC (00 EX)	2	0	Allow NULL?
37	SFPTC	Payment Terms Code	String	Generic Edit	3	0	Allow NULL?
38	SFAG	Amount - Gross	Numeric	Generic Edit	15	2	Allow NULL?
39	SF74UNT	Net Amount	Numeric	Generic Edit	15	2	Allow NULL?
40	SFUKCEAM	Certificate Amount	Numeric	Generic Edit	15	2	Allow NULL?
41	SFATXA	Amount - Taxable	Numeric	Generic Edit	15	2	Allow NULL?
42	SF74UCVAT	Certified VAT	Numeric	Generic Edit	15	2	Allow NULL?
43	SFADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
44	SFUKCEQT	Certificate Quantity	Numeric	Generic Edit	15	0	Allow NULL?
45	SFUKCEPE	Certificate Percentage	Numeric	Generic Edit	5	2	Allow NULL?
46	SF74UCG	Cumulative Gross Amount	Numeric	Generic Edit	15	2	Allow NULL?
47	SF74UCN	Cumulative Net Amount	Numeric	Generic Edit	15	2	Allow NULL?
48	SFUKCECA	Certificate Cumulative Amount	Numeric	Generic Edit	15	2	Allow NULL?
49	SF74UCCVAT	Cumulative Certified VAT	Numeric	Generic Edit	15	2	Allow NULL?
50	SFUKCECQ	Certificate Cumulative Quantity	Numeric	Generic Edit	15	0	Allow NULL?
51	SFUKCECP	Certificate Cumulative Percentage	Numeric	Generic Edit	5	2	Allow NULL?
52	SFCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
53	SFCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
54	SFCRCF	Currency Code - Origin	String	Generic Edit	3	0	Allow NULL?
55	SFCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
56	SFACR	Amount - Currency	Numeric	Generic Edit	15	2	Allow NULL?
57	SF74UFNT	Currency Net Amount	Numeric	Generic Edit	15	2	Allow NULL?
58	SFUKCEFA	Certificate Foreign Currency ( Period )	Numeric	Generic Edit	15	2	Allow NULL?
59	SFCTXA	Amount - Foreign Taxable	Numeric	Generic Edit	15	2	Allow NULL?
60	SF74UFVAT	Foreign Certified VAT	Numeric	Generic Edit	15	2	Allow NULL?
61	SFCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
62	SF74UFCG	Currency Cumulative Gross Amount	Numeric	Generic Edit	15	2	Allow NULL?
63	SF74UFCN	Currency Cumulative Net Amount	Numeric	Generic Edit	15	2	Allow NULL?
64	SFUKCEFC	Certificate Foreign Currency Cumulative	Numeric	Generic Edit	15	2	Allow NULL?
65	SF74UFCVAT	Foreign Cumulative Certified VAT	Numeric	Generic Edit	15	2	Allow NULL?
66	SF74UPRET	Retention Percentage	Numeric	Generic Edit	5	2	Allow NULL?
67	SFRTNG	Retainage	Numeric	Generic Edit	15	2	Allow NULL?
68	SF74UCR	Cumulative Retention	Numeric	Generic Edit	15	2	Allow NULL?
69	SFFTNG	Retainage - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
70	SF74UFCR	Foreign Cumulative Retention	Numeric	Generic Edit	15	2	Allow NULL?
71	SF74UMCDR	MCD Rate	Numeric	Generic Edit	5	2	Allow NULL?
72	SF74UMCDA	MCD Amount	Numeric	Generic Edit	15	2	Allow NULL?
73	SF74UMCDCA	MCD Amount Cumulative	Numeric	Generic Edit	15	2	Allow NULL?
74	SF74UFMCDA	MCD Foreign Amount	Numeric	Generic Edit	15	2	Allow NULL?
75	SF74UFMCDC	Foreign Cumulative MCD Amount	Numeric	Generic Edit	15	2	Allow NULL?
76	SFRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
77	SFUKCEPD	Certificate Print Date	Date	Generic Edit	6	0
78	SF74UARP	Authenticated Receipt Print Date	Date	Generic Edit	6	0
79	SF74UARR	Date Authenticated Receipt Returned	Date	Generic Edit	6	0
80	SF74UCCC1	Certificate Catagory Code 1	String	Generic Edit	3	0	Allow NULL?
81	SF74UCCC2	Certificate Catagory Code 2	String	Generic Edit	3	0	Allow NULL?
82	SF74UCCC3	Certificate Catagory Code 3	String	Generic Edit	10	0	Allow NULL?
83	SF74UCCC4	Certificate Catagory Code 4	String	Generic Edit	10	0	Allow NULL?
84	SF74UCCC5	Certificate Catagory Code 5	Numeric	Generic Edit	15	2	Allow NULL?
85	SFURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
86	SFURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
87	SFURDT	User Reserved Date	Date	Generic Edit	6	0
88	SFURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
89	SFURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
90	SFPID	Program ID	String	Generic Edit	10	0	Allow NULL?
91	SFJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
92	SFUSER	User ID	String	Generic Edit	10	0	Allow NULL?
93	SFUPMJ	Date - Updated	Date	Generic Edit	6	0
94	SFUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
95	SFOMCU	Project Business Unit	String	Generic Edit	12	0	Allow NULL?
96	SFANI	Account Number - Input (Mode Unknown)	String	Generic Edit	29	0	Allow NULL?
97	SFAID	Account ID	String	Generic Edit	8	0	Allow NULL?
98	SFNLIN	Number of Lines	Numeric	Generic Edit	5	0	Allow NULL?
99	SF74UPLAD	SPC Period Labour Amount Domestic	Numeric	Generic Edit	15	2	Allow NULL?
100	SF74UPMAD	SPC Period Materials Amount Domestic	Numeric	Generic Edit	15	2	Allow NULL?
101	SF74UPLAF	SPC Period Labour Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
102	SF74UPMAF	SPC Period Materials Amount Foreign	Numeric	Generic Edit	15	2	Allow NULL?
103	SF74ULMSP	Labour Materials Split Percentage	Numeric	Generic Edit	5	2	Allow NULL?
104	SF74UMLMS	SPC Mandatory Labour Materials Split	Character	Generic Edit	1	0	Allow NULL?

TOP 920 | 74U | F74U0425 INDEXES

Number

Description

Cert No Ord No A+ (Primary/Unique)

Element	Alias	Description	Sequence
1	UKCENM	Certificate 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	74UCLN	Certificate Line Number	Ascending
7	MATC	Type - Match Record Type	Ascending

Doc No Co No A+

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

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	UKCENM	Certificate Number	Ascending
5	74UCLN	Certificate Line Number	Ascending

Cert No Ord No B+

Element	Alias	Description	Sequence
1	UKCENM	Certificate 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	74UCLN	Certificate Line 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

104 COLUMNS | 4 INDEXES | 920 | 74U | F74U0425 TABLE

TOP 920 | 74U | F74U0425 COLUMNS

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

104 COLUMNS | 4 INDEXES | 920 | 74U | F74U0425 TABLE

TOP920 | 74U | F74U0425 COLUMNS

TOP920 | 74U | F74U0425 INDEXES

TOP 920 | 74U | F74U0425 COLUMNS

TOP 920 | 74U | F74U0425 INDEXES