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	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

12 columns | 812 | ASN2 | STOCK UDC

	Table	Table Description	Column#	Prefix	Alias	Column Description	Data Type	Edit Type	Length	Decimals
TOP17: Customer Service Management
1	F1721	Contract Detail	129	CD	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
2	F3111Z2	Warranty Claim/Supplier Recovery processing	124	WP	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
3	F3112Z2	Warranty Claim/Supplier Recovery processing	141	WL	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
4	F31171	Parts List - Extension	31	WS	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
5	F31171S	Purge Parts List - Extension	31	WS	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
6	F31172	Routing Instructions - Extension	34	WS	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
7	F31172S	Purge Routing Instructions - Extension	34	WS	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
8	F4801TZ2	Warranty Claim/Supplier Recovery processing	82	WQ	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
TOP17C: Call Management
9	F1797	CSMS Address Book Information	4	CS	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
TOP48: Work Order Processing
10	F4801ST	Purge - Work Order Master Tag File	69	WA	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
11	F4801T	Work Order Master Tag File	69	WA	ASN2	Price and Adjustment Schedule-Service	String	UDC	8	0
12	F4817	Service Order Extension	35	SR	ASN2	Price and Adjustment Schedule-Service	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	MFG	Manufacturing
9	NATIONAL	National Pricing
10	P	Product discount
11	PURCHSCH	Purchasing Catalog Schedule
12	SCHCALL	Schedule for calls
13	SCHCLM	Schedule for Claims
14	SCHCON	Schedule for Contracts
15	SCHSVO	Schedule for CSMS Serv. Ord.
16	SPRING	Spring Sale (Exercises)		N
17	WHLSDIST	Wholesale/Distributor