920: Top 10 requests

	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

910: Top 10 requests

	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

812: Top 10 requests

	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
47: Electronic Commerce
1	920	F470472	S6	85	1	EDI Invoice Expanded Detail (Sales)	Files	42: Sales Management

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	S6EDTY	Type Record	Character	UDC (00 RD)	1	0	Allow NULL?
2	S6EDSQ	Record Sequence	Numeric	Generic Edit	2	0	Allow NULL?
3	S6EKCO	Company - Key (EDI - Document Key Co)	String	Generic Edit	5	0	Allow NULL?
4	S6EDOC	EDI - Document Number	Numeric	Generic Edit	9	0	Allow NULL?
5	S6EDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	S6EDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
7	S6EDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
8	S6EDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
9	S6SHAN	Address Number - Ship To	Numeric	Generic Edit	8	0	Allow NULL?
10	S6ALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
11	S6CARS	Carrier Number	Numeric	Generic Edit	8	0	Allow NULL?
12	S6SHPN	Shipment Number	Numeric	Generic Edit	8	0	Allow NULL?
13	S6DEID	Demand Unique Key ID	Numeric	Generic Edit	15	0	Allow NULL?
14	S6CIRV	Item Revision Level - Customer/Supplier	String	Generic Edit	20	0	Allow NULL?
15	S6CITM	Item Number - Customer/Supplier	String	Generic Edit	25	0	Allow NULL?
16	S6SCAC	Standard Carrier Alpha Code	String	Generic Edit	4	0	Allow NULL?
17	S6ORIG	Country of Origin	String	UDC (00 CN)	3	0	Allow NULL?
18	S6DLDT	Delivery Date	Date	Generic Edit	6	0
19	S6DLTM	Time - Delivery	Numeric	Generic Edit	6	0	Allow NULL?
20	S6NPCS	Number of Pieces	Numeric	Generic Edit	5	0	Allow NULL?
21	S6CBNK	Bank Account Number - Customer	String	Generic Edit	20	0	Allow NULL?
22	S6ETRSC	Excess Reason Code	String	UDC (49 ES)	3	0	Allow NULL?
23	S6ETRC	Excess Responsibility	String	UDC (49 EC)	3	0	Allow NULL?
24	S6AETC	Authorization Code	String	Generic Edit	10	0	Allow NULL?
25	S6DKID	Dock ID	String	Generic Edit	20	0	Allow NULL?
26	S6RFQ1	Reference Number Qualifier 1	String	UDC (41 X6)	2	0	Allow NULL?
27	S6RFQ2	Reference Number Qualifier 2	String	UDC (41 X6)	2	0	Allow NULL?
28	S6RFQ3	Reference Number Qualifier 3	String	UDC (41 X6)	2	0	Allow NULL?
29	S6RFQ4	Reference Number Qualifier 4	String	UDC (41 X6)	2	0	Allow NULL?
30	S6RFQ5	Reference Number Qualifier 5	String	UDC (41 X6)	2	0	Allow NULL?
31	S6RF1	Reference Number 1	String	Generic Edit	30	0	Allow NULL?
32	S6RF2	Reference Number 2	String	Generic Edit	30	0	Allow NULL?
33	S6RF3	Reference Number 3	String	Generic Edit	30	0	Allow NULL?
34	S6RF4	Reference Number 4	String	Generic Edit	30	0	Allow NULL?
35	S6RF5	Reference Number 5	String	Generic Edit	30	0	Allow NULL?
36	S6PRTY1	Party Type-1	String	UDC (40R ST)	2	0	Allow NULL?
37	S6PRTY2	Party Type-2	String	UDC (40R ST)	2	0	Allow NULL?
38	S6PRTY3	Party Type-3	String	UDC (40R ST)	2	0	Allow NULL?
39	S6PRTY4	Party Type-4	String	UDC (40R ST)	2	0	Allow NULL?
40	S6PRTY5	Party Type-5	String	UDC (40R ST)	2	0	Allow NULL?
41	S6PRNA1	Party Name 1	String	Generic Edit	35	0	Allow NULL?
42	S6PRNA2	Party Name 2	String	Generic Edit	35	0	Allow NULL?
43	S6PRNA3	Party Name 3	String	Generic Edit	35	0	Allow NULL?
44	S6PRNA4	Party Name 4	String	Generic Edit	35	0	Allow NULL?
45	S6PRNA5	Party Name 5	String	Generic Edit	35	0	Allow NULL?
46	S6IDTYP1	ID Type-1	String	UDC (40R ID)	2	0	Allow NULL?
47	S6IDTYP2	ID Type-2	String	UDC (40R ID)	2	0	Allow NULL?
48	S6IDTYP3	ID Type-3	String	UDC (40R ID)	2	0	Allow NULL?
49	S6IDTYP4	ID Type-4	String	UDC (40R ID)	2	0	Allow NULL?
50	S6IDTYP5	ID Type-5	String	UDC (40R ID)	2	0	Allow NULL?
51	S6IDNUM1	ID Number 1	String	Generic Edit	20	0	Allow NULL?
52	S6IDNUM2	ID Number 2	String	Generic Edit	20	0	Allow NULL?
53	S6IDNUM3	ID Number 3	String	Generic Edit	20	0	Allow NULL?
54	S6IDNUM4	ID Number 4	String	Generic Edit	20	0	Allow NULL?
55	S6IDNUM5	ID Number 5	String	Generic Edit	20	0	Allow NULL?
56	S6RFTY1	Reference Type-1	String	UDC (40R QF)	3	0	Allow NULL?
57	S6RFTY2	Reference Type-2	String	UDC (40R QF)	3	0	Allow NULL?
58	S6RFTY3	Reference Type-3	String	UDC (40R QF)	3	0	Allow NULL?
59	S6RFTY4	Reference Type-4	String	UDC (40R QF)	3	0	Allow NULL?
60	S6RFTY5	Reference Type-5	String	UDC (40R QF)	3	0	Allow NULL?
61	S6RFNUM1	Reference Number 1	String	Generic Edit	30	0	Allow NULL?
62	S6RFNUM2	Reference Number 2	String	Generic Edit	30	0	Allow NULL?
63	S6RFNUM3	Reference Number 3	String	Generic Edit	30	0	Allow NULL?
64	S6RFNUM4	Reference Number 4	String	Generic Edit	30	0	Allow NULL?
65	S6RFNUM5	Reference Number 5	String	Generic Edit	30	0	Allow NULL?
66	S6FUT1	Future Use 1	Numeric	Generic Edit	15	2	Allow NULL?
67	S6FUT2	Future Use 2	Numeric	Generic Edit	15	2	Allow NULL?
68	S6FUT4	Future Use 4 - Reference	String	Generic Edit	25	0	Allow NULL?
69	S6FUT5	Future Use 5 - Reference	String	Generic Edit	25	0	Allow NULL?
70	S6X1	For Future Use - Flag 1	Character	Generic Edit	1	0	Allow NULL?
71	S6X2	For Future Use - Flag 2	Character	Generic Edit	1	0	Allow NULL?
72	S6D1FU	Future Use - Date 1	Date	Generic Edit	6	0
73	S6D2FU	Future Use - Date 2	Date	Generic Edit	6	0
74	S6TORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
75	S6USER	User ID	String	Generic Edit	10	0	Allow NULL?
76	S6PID	Program ID	String	Generic Edit	10	0	Allow NULL?
77	S6JOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
78	S6UPMJ	Date - Updated	Date	Generic Edit	6	0
79	S6UPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
80	S6JOBSQ	Job Sequence Number	String	Generic Edit	15	0	Allow NULL?
81	S6PSJOBNO	Production Sequencing Job Number	String	Generic Edit	15	0	Allow NULL?
82	S6CARDNO	Card Number	String	UDC (40R CD)	4	0	Allow NULL?
83	S6CIRVQ	Item Revision Level Qualifier	String	UDC (40R IQ)	2	0	Allow NULL?
84	S6GSHAN	Ship To GLN	Numeric	Generic Edit	13	0	Allow NULL?
85	S6GCARS	Carrier Number GLN	Numeric	Generic Edit	13	0	Allow NULL?

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

85 COLUMNS | 1 INDEXES | 920 | 47 | F470472 TABLE

TOP 920 | 47 | F470472 COLUMNS

TOP 920 | 47 | F470472 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

85 COLUMNS | 1 INDEXES | 920 | 47 | F470472 TABLE

TOP920 | 47 | F470472 COLUMNS

TOP920 | 47 | F470472 INDEXES

TOP 920 | 47 | F470472 COLUMNS

TOP 920 | 47 | F470472 INDEXES