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	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail 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	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

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
74: EMEA Localization
1	920	F74030H	NL	39	2	Dutch-Payments Bank Information	Secondary Master Files	04: Accounts Payable	Business Data

Column	Field	Description	Data Type	Edit Type	Length	SQL Create Statement
1	NLAN8	Address Number	Numeric	Generic Edit	8	Allow NULL?
2	NLBNK	Bank Account Number	String	Generic Edit	34	Allow NULL?
3	NLCRC	Payment Handling Code	String	UDC (00 HC)	3	Allow NULL?
4	NLBRK	Payment Account	Character	Generic Edit	1	Allow NULL?
5	NLBKT	Bank Account Type	Character	UDC (74 BK)	1	Allow NULL?
6	NLDL01	Description	String	Generic Edit	30	Allow NULL?
7	NLBKA	Bank Address Number	Numeric	Generic Edit	8	Allow NULL?
8	NLSWF	Transit Number - Bank	String	Generic Edit	34	Allow NULL?
9	NLGPN	Payment Category Code	Character	UDC (74 GP)	1	Allow NULL?
10	NLKCP	Domestic Cost Code	Character	UDC (74 DC)	1	Allow NULL?
11	NLKGV	Correspondant Cost	Character	UDC (74 KC)	1	Allow NULL?
12	NLNOC	Normal or cheque	Character	UDC (74 NO)	1	Allow NULL?
13	NLSDD	Type of receipt	String	Generic Edit	3	Allow NULL?
14	NLDDT	Customer Number	String	Generic Edit	30	Allow NULL?
15	NLCRCD	Currency Code - From	String	Generic Edit	3	Allow NULL?
16	NLSWFT	SWIFT Code	String	Generic Edit	15	Allow NULL?
17	NLCSU	Processing Code	Character	UDC (74 SU)	1	Allow NULL?
18	NLCCX	Check Crossing Code	Character	UDC (74 CC)	1	Allow NULL?
19	NLCVC	Check Forwarding Code	Character	UDC (74 CV)	1	Allow NULL?
20	NLCB1	Payment Instruction code 1	String	UDC (74 I1)	2	Allow NULL?
21	NLCB2	Payment Instruction code 2	String	UDC (74 I1)	2	Allow NULL?
22	NLCB3	Payment Instruction code 3	String	UDC (74 I1)	2	Allow NULL?
23	NLCB4	Payment Instruction code 4	String	UDC (74 I1)	2	Allow NULL?
24	NLCGG	Goods code	String	UDC (74 CG)	2	Allow NULL?
25	NLARTN	Article Number	String	UDC (74 AN)	2	Allow NULL?
26	NLA1	Nature of Payment Code 1	String	Generic Edit	40	Allow NULL?
27	NLA2	Nature of Payment Code 2	String	Generic Edit	40	Allow NULL?
28	NLHAN	Trader Number	String	Generic Edit	4	Allow NULL?
29	NLMTB	Maximum to pay	Numeric	Generic Edit	15	Allow NULL?
30	NLAGB	Number of remittance letters	Character	Generic Edit	1	Allow NULL?
31	NLTTP	Transit type	String	UDC (74 TT)	2	Allow NULL?
32	NLUSER	User ID	String	Generic Edit	10	Allow NULL?
33	NLUPMJ	Date - Updated	Date	Generic Edit	6
34	NLUPMT	Time - Last Updated	Numeric	Generic Edit	6	Allow NULL?
35	NLPID	Program ID	String	Generic Edit	10	Allow NULL?
36	NLJOBN	Work Station ID	String	Generic Edit	10	Allow NULL?
37	NLUKID	Unique Key ID (Internal)	Numeric	Generic Edit	15	Allow NULL?
38	NLACTN	Action Code	Character	Generic Edit	1	Allow NULL?
39	NLSRID	System Identification	String	Generic Edit	8	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

39 COLUMNS | 2 INDEXES | 920 | 74 | F74030H TABLE

TOP 920 | 74 | F74030H COLUMNS

TOP 920 | 74 | F74030H 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

39 COLUMNS | 2 INDEXES | 920 | 74 | F74030H TABLE

TOP920 | 74 | F74030H COLUMNS

TOP920 | 74 | F74030H INDEXES

TOP 920 | 74 | F74030H COLUMNS

TOP 920 | 74 | F74030H INDEXES