	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

97 COLUMNS | 8 INDEXES | 910 | 45 | F4574 TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
45: Advanced Pricing
1	910	F4574	KR	97	8	Key Reference Table	Transaction Files	45: Advanced Pricing	Business Data

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 KRUKID, KRKTPE, KRAPPRACT, KRACTN, KRITM, KRLITM, KRAITM, KRMCU, KRLOCN, KRLOTN, KRLOTG, KRFRMP, KRAN8, KRIGID, KRCGID, KRCRCD, KRUOM, KREFTJ, KREXDJ, KRAST, KRATID, KRITMR, KRFRMN, KRVBT, KRRTF4, KRTHRV, KRCATN, KRDMCT, KRCRDJ, KRTMCR, KRDMCS, KRAGSQ, KRXR01, KRXR02, KRXR03, KRXR04, KRXR05, KRXR06, KRXR07, KRXR08, KRXR09, KRXR10, KRXR11, KRXR12, KRXR13, KRXR14, KRXR15, KRBFAF, KRDENT, KRRQDJ, KRAPRD, KRASN, KROSEQ, KRDOCO, KRDCTO, KRKCOO, KRSFXO, KRLNID, KRUPRC, KRACRD, KRLEDG, KRFVTR, KROGID, KRMNQ, KRUORG, KRANO, KRDTX1, KRDTX2, KRPRFR, KRHYID, KRTQTY, KRTAMT, KROBJ, KRSUB, KRPDP, KRCO, KRSEQ, KRPSR, KRPSRY, KRDTO, KRGPTY, KRGPC, KRCPGP, KRCGP1, KRCGP2, KRCGP3, KRCGP4, KRPRGR, KRIGP1, KRIGP2, KRIGP3, KRIGP4, KRJOBN, KRUSER, KRPID, KRTDAY, KRUPMJ FROM F4574

TOP 910 | 45 | F4574 COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	KRUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	KRKTPE	Key Type	Character	Generic Edit	1	0	Allow NULL?
3	KRAPPRACT	Approval Action Code	Character	Generic Edit	1	0	Allow NULL?
4	KRACTN	Action Code	Character	Generic Edit	1	0	Allow NULL?
5	KRITM	Item Number - Short	Numeric	Generic Edit	8	0	Allow NULL?
6	KRLITM	2nd Item Number	String	Generic Edit	25	0	Allow NULL?
7	KRAITM	3rd Item Number	String	Generic Edit	25	0	Allow NULL?
8	KRMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
9	KRLOCN	Location	String	Generic Edit	20	0	Allow NULL?
10	KRLOTN	Lot/Serial Number	String	Generic Edit	30	0	Allow NULL?
11	KRLOTG	Lot Grade	String	UDC (40 LG)	3	0	Allow NULL?
12	KRFRMP	From Potency	Numeric	Generic Edit	7	3	Allow NULL?
13	KRAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
14	KRIGID	Item Group Key ID	Numeric	Generic Edit	8	0	Allow NULL?
15	KRCGID	Customer Group Key ID	Numeric	Generic Edit	8	0	Allow NULL?
16	KRCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
17	KRUOM	Unit of Measure as Input	String	UDC (00 UM)	2	0	Allow NULL?
18	KREFTJ	Date - Effective	Date	Generic Edit	6	0
19	KREXDJ	Date - Expired	Date	Generic Edit	6	0
20	KRAST	Price Adjustment Name	String	UDC (40 TY)	8	0	Allow NULL?
21	KRATID	Price Adjustment Key ID	Numeric	Generic Edit	8	0	Allow NULL?
22	KRITMR	Item Number - Short - Related	Numeric	Generic Edit	8	0	Allow NULL?
23	KRFRMN	Price Formula Name	String	UDC (40 FM)	10	0	Allow NULL?
24	KRVBT	Price Adjustment Variable Table	String	UDC (40 VT)	10	0	Allow NULL?
25	KRRTF4	Threshold Code 4 (8A) - Future	String	Generic Edit	8	0	Allow NULL?
26	KRTHRV	Threshold Value	Numeric	Generic Edit	15	0	Allow NULL?
27	KRCATN	Catalog	String	UDC (40 CN)	8	0	Allow NULL?
28	KRDMCT	Agreement Number - Distribution	String	Generic Edit	12	0	Allow NULL?
29	KRCRDJ	Date - Created (Julian)	Date	Generic Edit	6	0
30	KRTMCR	Time - Created	Numeric	Generic Edit	6	0	Allow NULL?
31	KRDMCS	Agreement Supplement - Distribution	Numeric	Generic Edit	3	0	Allow NULL?
32	KRAGSQ	Agreement Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
33	KRXR01	Cross Reference - 01 Char (Future)	Character	Generic Edit	1	0	Allow NULL?
34	KRXR02	Cross Reference - 02 Char (Future)	Character	Generic Edit	1	0	Allow NULL?
35	KRXR03	Cross Reference - 03 Char (Future)	Character	Generic Edit	1	0	Allow NULL?
36	KRXR04	Cross Reference - 04 Char (Future)	Character	Generic Edit	1	0	Allow NULL?
37	KRXR05	Cross Reference - 05 Char (Future)	Character	Generic Edit	1	0	Allow NULL?
38	KRXR06	Cross Reference - 06 Alpha (Future)	String	Generic Edit	10	0	Allow NULL?
39	KRXR07	Cross Reference - 07 Alpha (Future)	String	Generic Edit	10	0	Allow NULL?
40	KRXR08	Cross Reference - 08 Alpha (Future)	String	Generic Edit	10	0	Allow NULL?
41	KRXR09	Cross Reference - 09 Alpha (Future)	String	Generic Edit	10	0	Allow NULL?
42	KRXR10	Cross Reference - 10 Alpha (Future)	String	Generic Edit	10	0	Allow NULL?
43	KRXR11	Cross Reference - 11 Num (Future)	Numeric	Generic Edit	15	0	Allow NULL?
44	KRXR12	Cross Reference - 12 Num (Future)	Numeric	Generic Edit	15	0	Allow NULL?
45	KRXR13	Cross Reference - 13 Num (Future)	Numeric	Generic Edit	15	0	Allow NULL?
46	KRXR14	Cross Reference - 14 Num (Future)	Numeric	Generic Edit	15	0	Allow NULL?
47	KRXR15	Cross Reference - 15 Num (Future)	Numeric	Generic Edit	15	0	Allow NULL?
48	KRBFAF	Before/After Flag	Character	Generic Edit	1	0	Allow NULL?
49	KRDENT	Date - Entered	Date	Generic Edit	6	0
50	KRRQDJ	Date Approval Requested - Julian	Date	Generic Edit	6	0
51	KRAPRD	Date - Approved (Julian)	Date	Generic Edit	6	0
52	KRASN	Price and Adjustment Schedule	String	UDC (40 AS)	8	0	Allow NULL?
53	KROSEQ	Sequence Number	Numeric	Generic Edit	4	0	Allow NULL?
54	KRDOCO	Document (Order No Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
55	KRDCTO	Order Type	String	UDC (00 DT)	2	0	Allow NULL?
56	KRKCOO	Order Company (Order Number)	String	Generic Edit	5	0	Allow NULL?
57	KRSFXO	Order Suffix	String	Generic Edit	3	0	Allow NULL?
58	KRLNID	Line Number	Numeric	Generic Edit	6	3	Allow NULL?
59	KRUPRC	Amount - Price per Unit	Numeric	Generic Edit	15	4	Allow NULL?
60	KRACRD	Amount - Credit Price	Numeric	Generic Edit	15	4	Allow NULL?
61	KRLEDG	Cost Method	String	UDC (40 CM)	2	0	Allow NULL?
62	KRFVTR	Factor Value	Numeric	Generic Edit	15	5	Allow NULL?
63	KROGID	Order Group Key ID	Numeric	Generic Edit	8	0	Allow NULL?
64	KRMNQ	Quantity - From	Numeric	Generic Edit	15	2	Allow NULL?
65	KRUORG	Units - Order/Transaction Quantity	Numeric	Generic Edit	15	2	Allow NULL?
66	KRANO	Address Number - Originator	Numeric	Generic Edit	8	0	Allow NULL?
67	KRDTX1	Description - Descriptive Text 1	String	Generic Edit	75	0	Allow NULL?
68	KRDTX2	Description - Descriptive Text 2	String	Generic Edit	75	0	Allow NULL?
69	KRPRFR	Preference Type	String	UDC (40 PR)	2	0	Allow NULL?
70	KRHYID	Hierarchy Identifier	String	Generic Edit	10	0	Allow NULL?
71	KRTQTY	Quantity -Total	Numeric	Generic Edit	15	2	Allow NULL?
72	KRTAMT	Threshold Amount/Quantity	Numeric	Generic Edit	15	0	Allow NULL?
73	KROBJ	Object Account	String	Generic Edit	6	0	Allow NULL?
74	KRSUB	Subsidiary	String	Generic Edit	8	0	Allow NULL?
75	KRPDP	Category Code Value	String	Generic Edit	3	0	Allow NULL?
76	KRCO	Company	String	Generic Edit	5	0	Allow NULL?
77	KRSEQ	Sequence Number	Numeric	Generic Edit	6	0	Allow NULL?
78	KRPSR	Source	String	Generic Edit	12	0	Allow NULL?
79	KRPSRY	Source Type	String	UDC (38 DY)	2	0	Allow NULL?
80	KRDTO	Due To	Character	UDC (38 DT)	1	0	Allow NULL?
81	KRGPTY	Type - Group Code	Character	Generic Edit	1	0	Allow NULL?
82	KRGPC	Code - Group	String	Generic Edit	8	0	Allow NULL?
83	KRCPGP	Customer Price Group	String	UDC (40 PC)	8	0	Allow NULL?
84	KRCGP1	Customer Group Category Code 01	String	Generic Edit	3	0	Allow NULL?
85	KRCGP2	Customer Group Category Code 02	String	Generic Edit	3	0	Allow NULL?
86	KRCGP3	Customer Group Category Code 03	String	Generic Edit	3	0	Allow NULL?
87	KRCGP4	Customer Group Category Code 04	String	Generic Edit	3	0	Allow NULL?
88	KRPRGR	Item Price Group	String	UDC (40 PI)	8	0	Allow NULL?
89	KRIGP1	Item Group Category Code 01	String	Generic Edit	6	0	Allow NULL?
90	KRIGP2	Item Group Category Code 02	String	Generic Edit	6	0	Allow NULL?
91	KRIGP3	Item Group Category Code 03	String	Generic Edit	6	0	Allow NULL?
92	KRIGP4	Item Group Category Code 04	String	Generic Edit	6	0	Allow NULL?
93	KRJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
94	KRUSER	User ID	String	Generic Edit	10	0	Allow NULL?
95	KRPID	Program ID	String	Generic Edit	10	0	Allow NULL?
96	KRTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
97	KRUPMJ	Date - Updated	Date	Generic Edit	6	0

TOP 910 | 45 | F4574 INDEXES

Number

Description

Unique key ID Internal (Primary/Unique)

Element	Alias	Description	Sequence
1	UKID	Unique Key ID (Internal)	Ascending
2	BFAF	Before/After Flag	Descending

F4106 - KTPE ITM +

Element	Alias	Description	Sequence
1	KTPE	Key Type	Ascending
2	ITM	Item Number - Short	Ascending
3	MCU	Business Unit	Ascending
4	LOCN	Location	Ascending
5	LOTN	Lot/Serial Number	Ascending
6	AN8	Address Number	Ascending
7	IGID	Item Group Key ID	Ascending
8	CGID	Customer Group Key ID	Ascending
9	LOTG	Lot Grade	Ascending
10	FRMP	From Potency	Ascending
11	CRCD	Currency Code - From	Ascending
12	UOM	Unit of Measure as Input	Ascending
13	EXDJ	Date - Expired	Ascending
14	UPMJ	Date - Updated	Descending
15	TDAY	Time of Day	Descending

F4071 - KTPE AST +

Element	Alias	Description	Sequence
1	KTPE	Key Type	Ascending
2	AST	Price Adjustment Name	Ascending
3	UPMJ	Date - Updated	Descending
4	TDAY	Time of Day	Descending

F4072 - KTPE AST +

Element	Alias	Description	Sequence
1	KTPE	Key Type	Ascending
2	AST	Price Adjustment Name	Ascending
3	ITM	Item Number - Short	Ascending
4	AN8	Address Number	Ascending
5	IGID	Item Group Key ID	Ascending
6	CGID	Customer Group Key ID	Ascending
7	OGID	Order Group Key ID	Ascending
8	CRCD	Currency Code - From	Ascending
9	UOM	Unit of Measure as Input	Ascending
10	MNQ	Quantity - From	Ascending
11	EXDJ	Date - Expired	Ascending
12	UPMJ	Date - Updated	Descending
13	TDAY	Time of Day	Descending

F4073 - KTPE AST +

Element	Alias	Description	Sequence
1	KTPE	Key Type	Ascending
2	AST	Price Adjustment Name	Ascending
3	ATID	Price Adjustment Key ID	Ascending
4	LITM	2nd Item Number	Ascending
5	UPMJ	Date - Updated	Descending
6	TDAY	Time of Day	Descending

F4075 - KTPE VBT +

Element	Alias	Description	Sequence
1	KTPE	Key Type	Ascending
2	VBT	Price Adjustment Variable Table	Ascending
3	EFTJ	Date - Effective	Descending
4	UPMJ	Date - Updated	Descending
5	TDAY	Time of Day	Descending

F4076 - KTPE FRMN +

Element	Alias	Description	Sequence
1	KTPE	Key Type	Ascending
2	FRMN	Price Formula Name	Ascending
3	UPMJ	Date - Updated	Descending
4	TDAY	Time of Day	Descending

F4077 - KTPE AST +

Element	Alias	Description	Sequence
1	KTPE	Key Type	Ascending
2	AST	Price Adjustment Name	Ascending
3	AN8	Address Number	Ascending
4	ITM	Item Number - Short	Ascending
5	IGID	Item Group Key ID	Ascending
6	CGID	Customer Group Key ID	Ascending
7	EFTJ	Date - Effective	Ascending
8	THRV	Threshold Value	Ascending
9	UPMJ	Date - Updated	Descending
10	TDAY	Time of Day	Descending

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

97 COLUMNS | 8 INDEXES | 910 | 45 | F4574 TABLE

TOP 910 | 45 | F4574 COLUMNS

TOP 910 | 45 | F4574 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

97 COLUMNS | 8 INDEXES | 910 | 45 | F4574 TABLE

TOP910 | 45 | F4574 COLUMNS

TOP910 | 45 | F4574 INDEXES

TOP 910 | 45 | F4574 COLUMNS

TOP 910 | 45 | F4574 INDEXES