JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | Schema: System Table Column Search^beta

JDE TABLESv3

SAPTables.Net - the webs number one SAP Tables Definition reference

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	F4102	IB	Item Branch File
7	F9671	SD	Software Update Detail Table
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

12 columns | 910 | ASN4 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP17: Customer Service Management
1	F1775	Claim Temporary Table	32	TC	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
2	F3111Z2	Warranty Claim/Supplier Recovery processing	123	WP	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
3	F3112Z2	Warranty Claim/Supplier Recovery processing	140	WL	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
4	F31171	Parts List - Extension	30	WS	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
5	F31171S	Purge Parts List - Extension	30	WS	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
6	F31172	Routing Instructions - Extension	33	WS	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
7	F31172S	Purge Routing Instructions - Extension	33	WS	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
8	F4801TZ2	Warranty Claim/Supplier Recovery processing	81	WQ	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
TOP17C: Call Management
9	F1797	S/WM Address Book Information	6	CS	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
TOP48: Work Order Processing
10	F4801ST	Purge - Work Order Master Tag File	68	WA	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
11	F4801T	Work Order Master Tag File	68	WA	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0
12	F4817	Service Order Extension	34	SR	ASN4	Price and Adjustment Schedule-Four	String	UDC	8	0

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 40 / AS (Adjustment Schedule Name) stock values

	Value	Description	Special Handling Code	Hard Coded
1	3480	SHIP AND DEBIT 2
2	4343	Ship and Debit Agreement 4343
3	BRAZIL	Brazil Co. Pricing Schedule
4	C	Customer Discount
5	CP	Customer + Product Discount
6	D2	Euro conversion
7	FG	Free Goods
8	FMDEMO	Fulfillment Demo Schedule		Y
9	MFG	Manufacturing
10	NATIONAL	National Pricing
11	P	Product discount
12	PURCHSCH	Purchasing Catalog Schedule
13	SCHCALL	Schedule for calls
14	SCHCLM	Schedule for Claims
15	SCHCON	Schedule for Contracts
16	SCHSVO	Schedule for CSMS Serv. Ord.
17	SPRING	Spring Sale (Exercises)		N
18	WHLSDIST	Wholesale/Distributor