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
76C: Colombia
1	910	F76C034A	RZ	115	2	A/R Check Detail file As Of - COL - 03B	Balance Files	76C: Colombia

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	RZPYID	Payment ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
2	RZCKNU	Receipt Number	String	Generic Edit	25	0	Allow NULL?
3	RZRC5	File Line Identifier 5.0	Numeric	Generic Edit	5	0	Allow NULL?
4	RZDOC	Document (Voucher Invoice etc.)	Numeric	Generic Edit	8	0	Allow NULL?
5	RZDCT	Document Type	String	UDC (00 DT)	2	0	Allow NULL?
6	RZKCO	Document Company	String	Generic Edit	5	0	Allow NULL?
7	RZSFX	Document Pay Item	String	Generic Edit	3	0	Allow NULL?
8	RZAN8	Address Number	Numeric	UDC	8	0	Allow NULL?
9	RZDCTM	Document Type - Matching	String	UDC (00 DT)	2	0	Allow NULL?
10	RZDMTJ	Date - Matching Check or Item - Julian	Date	Generic Edit	6	0
11	RZDGJ	Date - For G/L (and Voucher) - Julian	Date	Generic Edit	6	0
12	RZPOST	G/L Posted Code	Character	Generic Edit	1	0	Allow NULL?
13	RZGLC	G/L Offset	String	Generic Edit	4	0	Allow NULL?
14	RZAID	Account ID	String	Generic Edit	8	0	Allow NULL?
15	RZCTRY	Century	Numeric	Generic Edit	2	0	Allow NULL?
16	RZFY	Fiscal Year	Numeric	Generic Edit	2	0	Allow NULL?
17	RZPN	Period Number - General Ledger	Numeric	Generic Edit	2	0	Allow NULL?
18	RZCO	Company	String	Generic Edit	5	0	Allow NULL?
19	RZICUT	Batch Type	String	UDC (98 IT)	2	0	Allow NULL?
20	RZICU	Batch Number	Numeric	Generic Edit	8	0	Allow NULL?
21	RZDICJ	Date - Batch (Julian)	Date	Generic Edit	6	0
22	RZPA8	Address Number - Parent	Numeric	Generic Edit	8	0	Allow NULL?
23	RZRPID	Related Payment ID	Numeric	Generic Edit	15	0	Allow NULL?
24	RZRLIN	Related Payment Line ID	Numeric	Generic Edit	5	0	Allow NULL?
25	RZPAAP	Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
26	RZADSC	Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
27	RZAAAJ	Amount - Write Off	Numeric	Generic Edit	15	2	Allow NULL?
28	RZADSA	Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
29	RZBCRC	Currency Code - Base	String	Generic Edit	3	0	Allow NULL?
30	RZDDA	Amount - Deduction	Numeric	Generic Edit	15	2	Allow NULL?
31	RZECBA	Amount - Chargeback	Numeric	Generic Edit	15	2	Allow NULL?
32	RZCRCD	Currency Code - From	String	Generic Edit	3	0	Allow NULL?
33	RZCRRM	Currency Mode-Foreign or Domestic Entry	Character	UDC (H00 CY)	1	0	Allow NULL?
34	RZPFAP	Payment Amount - Foreign	Numeric	Generic Edit	15	2	Allow NULL?
35	RZCDS	Amount - Foreign Discount Available	Numeric	Generic Edit	15	2	Allow NULL?
36	RZCDSA	Amount - Foreign Discount Taken	Numeric	Generic Edit	15	2	Allow NULL?
37	RZFCHG	Amount - Foreign Changed Amount	Numeric	Generic Edit	15	2	Allow NULL?
38	RZECBF	Amount - Foreign Chargeback	Numeric	Generic Edit	15	2	Allow NULL?
39	RZCRR	Currency Conversion Rate - Spot Rate	Numeric	Generic Edit	15	0	Allow NULL?
40	RZAGL	Amount Gain/Loss	Numeric	Generic Edit	15	2	Allow NULL?
41	RZAIDT	Gain/Loss Account ID	String	Generic Edit	8	0	Allow NULL?
42	RZTAAP	Transaction Payment Amount	Numeric	Generic Edit	15	2	Allow NULL?
43	RZTCRC	Transaction Currency Code	String	Generic Edit	3	0	Allow NULL?
44	RZTADA	Transaction Discount Amount	Numeric	Generic Edit	15	2	Allow NULL?
45	RZTAAJ	Transaction Write Off Amount	Numeric	Generic Edit	15	2	Allow NULL?
46	RZTCBA	Transaction Charge Back Amount	Numeric	Generic Edit	15	2	Allow NULL?
47	RZTDA	Transaction Deduction Amount	Numeric	Generic Edit	15	2	Allow NULL?
48	RZACR2	Alternate Currency Rate 2	Numeric	Generic Edit	15	0	Allow NULL?
49	RZACR1	Alternate Currency Rate 1	Numeric	Generic Edit	15	0	Allow NULL?
50	RZACRM	Alt Currency Conversion Y/Z	Character	Generic Edit	1	0	Allow NULL?
51	RZAGLA	Alternate Currency Gain/Loss	Numeric	Generic Edit	15	2	Allow NULL?
52	RZACRR	Alternate Currency Exchange Rate	Numeric	Generic Edit	15	0	Allow NULL?
53	RZAIDA	Alt Curr Gain/Loss Account ID	String	Generic Edit	8	0	Allow NULL?
54	RZECBR	Chargeback Reason Code	String	UDC (03B CB)	2	0	Allow NULL?
55	RZRSCO	Write-Off Reason Code	String	UDC (03B RC)	2	0	Allow NULL?
56	RZAIDW	Write-Off Account ID	String	Generic Edit	8	0	Allow NULL?
57	RZAIDD	Discount Account ID	String	Generic Edit	8	0	Allow NULL?
58	RZAIDC	Chargeback Account ID	String	Generic Edit	8	0	Allow NULL?
59	RZDAID	Deduction Account ID	String	Generic Edit	8	0	Allow NULL?
60	RZDDEX	Deduction Reason Code	String	UDC (03B CR)	2	0	Allow NULL?
61	RZTYIN	Receipt Type Code	Character	UDC (03B TI)	1	0	Allow NULL?
62	RZGLCC	G/L Offset Chargebacks	String	Generic Edit	4	0	Allow NULL?
63	RZUCTF	Unapplied Cash Transfer	Character	Generic Edit	1	0	Allow NULL?
64	RZUTIC	User Type Input Code	String	UDC (03B RE)	2	0	Allow NULL?
65	RZAID2	Account ID	String	Generic Edit	8	0	Allow NULL?
66	RZAM2	Account Mode - G/L	Character	UDC (H09 AM)	1	0	Allow NULL?
67	RZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
68	RZSBL	Subledger - G/L	String	Generic Edit	8	0	Allow NULL?
69	RZFDA	Amount - Foreign Deduction	Numeric	Generic Edit	15	2	Allow NULL?
70	RZPKCO	Document Company (Purchase Order)	String	Generic Edit	5	0	Allow NULL?
71	RZPO	Purchase Order	String	Generic Edit	8	0	Allow NULL?
72	RZNUMB	Asset Item Number	Numeric	Generic Edit	8	0	Allow NULL?
73	RZPDCT	Document Type - Purchase Order	String	UDC (00 DT)	2	0	Allow NULL?
74	RZRMK	Name - Remark	String	Generic Edit	30	0	Allow NULL?
75	RZMCU2	Business Unit 2	String	Generic Edit	12	0	Allow NULL?
76	RZUNIT	Unit	String	Generic Edit	8	0	Allow NULL?
77	RZALT6	G/L Posting Code - Cash Basis Acct	Character	Generic Edit	1	0	Allow NULL?
78	RZFNLP	Closed Item - As Of Processing	Character	Generic Edit	1	0	Allow NULL?
79	RZODOC	Document - Original	Numeric	Generic Edit	8	0	Allow NULL?
80	RZGDOC	Deduction Document Number	Numeric	Generic Edit	8	0	Allow NULL?
81	RZODCT	Document Type - Original	String	UDC (00 DT)	2	0	Allow NULL?
82	RZGDCT	Deduction Document Type	String	UDC (00 DT)	2	0	Allow NULL?
83	RZOKCO	Document Company (Original Order)	String	Generic Edit	5	0	Allow NULL?
84	RZOSFX	Document Pay Item - Original	String	Generic Edit	3	0	Allow NULL?
85	RZGKCO	Deduction Document Company	String	Generic Edit	5	0	Allow NULL?
86	RZGSFX	Deduction Document Pay Item	String	Generic Edit	3	0	Allow NULL?
87	RZKCOG	Document Company - JE	String	Generic Edit	5	0	Allow NULL?
88	RZDOCG	Document Number - JE	Numeric	Generic Edit	8	0	Allow NULL?
89	RZCTL	Control/Statement Field	String	Generic Edit	13	0	Allow NULL?
90	RZDCTG	Document Type - JE	String	UDC (00 DT)	2	0	Allow NULL?
91	RZSMTJ	Date - Statement	Date	Generic Edit	6	0
92	RZVDGJ	Void Date - For G/L - Julian	Date	Generic Edit	6	0
93	RZVRE	Void Reason Code	String	UDC (03B VR)	3	0	Allow NULL?
94	RZNFVD	Receipt NSF/Void Code	Character	Generic Edit	1	0	Allow NULL?
95	RZISTC	A/R Post to Cash Management	Character	Generic Edit	1	0	Allow NULL?
96	RZHCRR	Historical Currency Conversion Rate	Numeric	Generic Edit	15	0	Allow NULL?
97	RZLFCJ	Date - Last Fee Calculated (Julian)	Date	Generic Edit	6	0
98	RZPDLT	Partial Payment	Character	UDC (03B PL)	1	0	Allow NULL?
99	RZDDNJ	Date - Discount Due - Julian	Date	Generic Edit	6	0
100	RZDDST	Draft Status	Character	UDC (03B DS)	1	0	Allow NULL?
101	RZIDGJ	Date - Invoice Journal Date - Julian	Date	Generic Edit	6	0
102	RZDDJ	Date - Net Due	Date	Generic Edit	6	0
103	RZRFID	Reference ID (Internal)	Numeric	Generic Edit	15	0	Allow NULL?
104	RZVR01	Reference	String	Generic Edit	25	0	Allow NULL?
105	RZRIDC	Reference ID Code	Character	Generic Edit	1	0	Allow NULL?
106	RZRNID	Batch Run ID (Internal)	Numeric	Generic Edit	3	0	Allow NULL?
107	RZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
108	RZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
109	RZGFL1	Generic Flag 1	Character	Generic Edit	1	0	Allow NULL?
110	RZPRGF	Purge Flag	Character	Generic Edit	1	0	Allow NULL?
111	RZUPMJ	Date - Updated	Date	Generic Edit	6	0
112	RZUPMT	Time - Last Updated	Numeric	Generic Edit	6	0	Allow NULL?
113	RZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
114	RZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
115	RZSBLT	Subledger Type	Character	UDC (00 ST)	1	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

115 COLUMNS | 2 INDEXES | 910 | 76C | F76C034A TABLE

TOP 910 | 76C | F76C034A COLUMNS

TOP 910 | 76C | F76C034A 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

115 COLUMNS | 2 INDEXES | 910 | 76C | F76C034A TABLE

TOP910 | 76C | F76C034A COLUMNS

TOP910 | 76C | F76C034A INDEXES

TOP 910 | 76C | F76C034A COLUMNS

TOP 910 | 76C | F76C034A INDEXES