JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 
Column 
Searchbeta 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

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

920: Top 10 requests

TablePrefixDescription
1F4211SDSales Order Detail File
2F0101ABAddress Book Master
3F4101IMItem Master
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

135 columns | Print definition?920 | EXDJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F01505Tier Descriptions6TDEXDJDate - ExpiredDateGeneric Edit60
TOP09E: Expense Reimbursment
2F09E108Policy Edit Rules8PREXDJDate - ExpiredDateGeneric Edit60
TOP37: Quality Management
3F37014Test Result Conversions5RCEXDJDate - ExpiredDateGeneric Edit60
4F37015Test Result Conversion Tables6CTEXDJDate - ExpiredDateGeneric Edit60
5F40318Preference Profile - Quality Management6QCEXDJDate - ExpiredDateGeneric Edit60
TOP38: Agreement Management
6F38010Agreement Master17DNEXDJDate - ExpiredDateGeneric Edit60
7F38011Agreement Quantities15DFEXDJDate - ExpiredDateGeneric Edit60
8F38012Product Source/Destination Master20DPEXDJDate - ExpiredDateGeneric Edit60
9F38013Agreement Quantities Schedule7DQEXDJDate - ExpiredDateGeneric Edit60
10F38014Agreement Formulas and Factors22DREXDJDate - ExpiredDateGeneric Edit60
TOP40: Inventory/OP Base
11F4015Order Templates12OTEXDJDate - ExpiredDateGeneric Edit60
12F4016Print Messages4TUEXDJDate - ExpiredDateGeneric Edit60
13F40301Preference Profile - Payment Terms6PTEXDJDate - ExpiredDateGeneric Edit60
14F40301RPreference Resolution Ledger - Payment Terms8PTEXDJDate - ExpiredDateGeneric Edit60
15F40302Preference Profile - Unit of Measure6PUEXDJDate - ExpiredDateGeneric Edit60
16F40302RPreference Resolution Ledger - Pricing Unit Of Measure8PUEXDJDate - ExpiredDateGeneric Edit60
17F40303Preference Profile - Revenue Cost Center6RVEXDJDate - ExpiredDateGeneric Edit60
18F40303RPreference Resolution Ledger - Revenue Business Unit8RVEXDJDate - ExpiredDateGeneric Edit60
19F40304Preference Profile - End Use6PEEXDJDate - ExpiredDateGeneric Edit60
20F40304RPreference Resolution Ledger - End Use8PEEXDJDate - ExpiredDateGeneric Edit60
21F40305Preference Profile - Print Messages6RMEXDJDate - ExpiredDateGeneric Edit60
22F40305RPreference Resolution Ledger - Print Messages8RMEXDJDate - ExpiredDateGeneric Edit60
23F40306Preference Profile - Inventory Sourcing6SREXDJDate - ExpiredDateGeneric Edit60
24F40307Preference Profile - Product Allocations6LAEXDJDate - ExpiredDateGeneric Edit60
25F40308Preference Profile - Grade and Potency6GSEXDJDate - ExpiredDateGeneric Edit60
26F40308RPreference Resolution Ledger - Grade and Potency8GSEXDJDate - ExpiredDateGeneric Edit60
27F40309Preference Profile - Delivery Date6DYEXDJDate - ExpiredDateGeneric Edit60
28F40309RPreference Resolution Ledger - Delivery Date8DYEXDJDate - ExpiredDateGeneric Edit60
29F40310Preference Profile - Line of Business6LBEXDJDate - ExpiredDateGeneric Edit60
30F40310RPreference Resolution Ledger - Line Of Business8LBEXDJDate - ExpiredDateGeneric Edit60
31F40311Preference Profile - Price Code 16P1EXDJDate - ExpiredDateGeneric Edit60
32F40311RPreference Resolution Ledger - User Defined Price Code #18P1EXDJDate - ExpiredDateGeneric Edit60
33F40312Preference Profile - Price Code 26P2EXDJDate - ExpiredDateGeneric Edit60
34F40312RPreference Resolution Ledger - User Defined Price Code #28P2EXDJDate - ExpiredDateGeneric Edit60
35F40313Preference Profile - Price Code 36P3EXDJDate - ExpiredDateGeneric Edit60
36F40313RPreference Resolution Ledger - User Defined Price Code #38P3EXDJDate - ExpiredDateGeneric Edit60
37F40314Preference Profile - Price Adjustment Schedule6PJEXDJDate - ExpiredDateGeneric Edit60
38F40314RPreference Resolution Ledger - Price Adjustment Schedule8PJEXDJDate - ExpiredDateGeneric Edit60
39F40315Preference Profile - Invoice Cycling6PIEXDJDate - ExpiredDateGeneric Edit60
40F40315RPreference Resolution Ledger - Invoice Cycle8PIEXDJDate - ExpiredDateGeneric Edit60
41F40316Preference Profile - Order Preparation6OPEXDJDate - ExpiredDateGeneric Edit60
42F40316RPreference Resolution Ledger - Order Preparation Days8OPEXDJDate - ExpiredDateGeneric Edit60
43F40318RPreference Resolution Ledger - Quality Management8QCEXDJDate - ExpiredDateGeneric Edit60
44F40320Preference Profile - Multi Shipping/Receiving Locations6LPEXDJDate - ExpiredDateGeneric Edit60
45F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations7LPEXDJDate - ExpiredDateGeneric Edit60
46F40329Preference Profile - Document Distribution6DDEXDJDate - ExpiredDateGeneric Edit60
47F40330Preference Profile - Document Set6DGEXDJDate - ExpiredDateGeneric Edit60
48F40331Preference Profile - Options and Equipment6OEEXDJDate - ExpiredDateGeneric Edit60
49F40332Preference Profile - Customer Freight6CFEXDJDate - ExpiredDateGeneric Edit60
50F40333Preference Profile - Carrier6CAEXDJDate - ExpiredDateGeneric Edit60
51F40334Preference Profile - Mode of Transport6MTEXDJDate - ExpiredDateGeneric Edit60
52F40338Preference Profile - Payment Terms (Branch)6PTEXDJDate - ExpiredDateGeneric Edit60
53F40338RPreference Resolution Ledger - Payment Terms (Branch)8PTEXDJDate - ExpiredDateGeneric Edit60
54F40339Preference Profile - Product Allocations (Branch)6LAEXDJDate - ExpiredDateGeneric Edit60
55F40341Preference Profile - Next Order Status6NSEXDJDate - ExpiredDateGeneric Edit60
56F40341RPreference Resolution Ledger - Next Order Status8NSEXDJDate - ExpiredDateGeneric Edit60
57F40344Preference Profile - Sales Commission6SAEXDJDate - ExpiredDateGeneric Edit60
58F40344RPreference Resolution Ledger - Sales Commission8SAEXDJDate - ExpiredDateGeneric Edit60
59F40345Preference Profile - Customer Currency6CREXDJDate - ExpiredDateGeneric Edit60
60F40345RPreference Resolution Ledger - Customer Currency8CREXDJDate - ExpiredDateGeneric Edit60
61F40347Preference Profile - Pricing UOM (Branch)6RIEXDJDate - ExpiredDateGeneric Edit60
62F40347RPreference Resolution Ledger - Pricing UOM (Branch)8RIEXDJDate - ExpiredDateGeneric Edit60
63F40349Preference Profile - Revenue Business Unit (Branch)6RVEXDJDate - ExpiredDateGeneric Edit60
64F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)8RVEXDJDate - ExpiredDateGeneric Edit60
65F40350Preference Profiles - Conatiner Deposit/Rental6OQEXDJDate - ExpiredDateGeneric Edit60
66F40P01Promotion Header File7PHEXDJDate - ExpiredDateGeneric Edit60
67F40P011Promotion Deal Detail File24PDEXDJDate - ExpiredDateGeneric Edit60
68F40UI002Supplier History Rebuild -workfile12UTEXDJDate - ExpiredDateGeneric Edit60
69F40UI17Allocation Work File16ZGEXDJDate - ExpiredDateGeneric Edit60
70F4104Item Cross Reference File4IVEXDJDate - ExpiredDateGeneric Edit60
71F4106Item Base Price File15BPEXDJDate - ExpiredDateGeneric Edit60
72F4106NCBase Price Extraction21SZEXDJDate - ExpiredDateGeneric Edit60
73F49085Scheduled Invoice Date4IDEXDJDate - ExpiredDateGeneric Edit60
TOP41F: Apparel Management
74FCW11Item Base Price File Work File14WPEXDJDate - ExpiredDateGeneric Edit60
75FCW16Work File F40166WFEXDJDate - ExpiredDateGeneric Edit60
76FCW33Price List Header11PHEXDJDate - ExpiredDateGeneric Edit60
77FCW70Supplier Price/Catalog File - Header7CBEXDJDate - ExpiredDateGeneric Edit60
78FCW71Supplier Price/Catalog File - Detail29CBEXDJDate - ExpiredDateGeneric Edit60
79FCW93Copy to Outsource Operations for Style Items14STEXDJDate - ExpiredDateGeneric Edit60
TOP42: Sales Management
80F42430Customer Set4CSEXDJDate - ExpiredDateGeneric Edit60
TOP42B: Sales Order Entry
81F42440Customer Segment Items10CSEXDJDate - ExpiredDateGeneric Edit60
82F42UI440Customer Segment Items - Work File11CSEXDJDate - ExpiredDateGeneric Edit60
TOP42I: Outbound Inventory Management
83F42I06Outbound Inventory Agreement Master Change History18OHEXDJDate - ExpiredDateGeneric Edit60
84F42I07Outbound Inventory Agreement Details Change History16OQEXDJDate - ExpiredDateGeneric Edit60
TOP42W: Fulfilment Management
85F4277760Service Level Rule Setup8SREXDJDate - ExpiredDateGeneric Edit60
TOP43: Procurement
86F41061Supplier Price/Catalog File18CBEXDJDate - ExpiredDateGeneric Edit60
87F4340Purchase Rebate Master File6RDEXDJDate - ExpiredDateGeneric Edit60
TOP45: Advanced Pricing
88F4070Price Adjustment Schedule11SNEXDJDate - ExpiredDateGeneric Edit60
89F4070PPrice Adjustment Schedule Purge12SNEXDJDate - ExpiredDateGeneric Edit60
90F4072Price Adjustment Detail13ADEXDJDate - ExpiredDateGeneric Edit60
91F4072PPrice Adjustment Detail Purge14ADEXDJDate - ExpiredDateGeneric Edit60
92F4072WPrice Adjustment Detail Work File13ADEXDJDate - ExpiredDateGeneric Edit60
93F4075Price Variable Table6VBEXDJDate - ExpiredDateGeneric Edit60
94F4077Rebate Thresholds9RTEXDJDate - ExpiredDateGeneric Edit60
95F4077PRebate Thresholds Purge10RTEXDJDate - ExpiredDateGeneric Edit60
96F4078Rebate Transaction Summary9RHEXDJDate - ExpiredDateGeneric Edit60
97F4079Rebate Transaction Detail8SVEXDJDate - ExpiredDateGeneric Edit60
98F4501Master Schedule Adjustment6MSEXDJDate - ExpiredDateGeneric Edit60
99F4502Free Goods Catalog4FGEXDJDate - ExpiredDateGeneric Edit60
100F4511WPricing Structure View50APEXDJDate - ExpiredDateGeneric Edit60
101F4551Basket Master Detail5BDEXDJDate - ExpiredDateGeneric Edit60
102F45520Price List Header6PHEXDJDate - ExpiredDateGeneric Edit60
103F45715Adjustment Balances11ABEXDJDate - ExpiredDateGeneric Edit60
104F4572Live Promotions X-Reference by Cost Type8XREXDJDate - ExpiredDateGeneric Edit60
105F4572Z1Live Promotions Interface - Inbound / Outbound22LPEXDJDate - ExpiredDateGeneric Edit60
106F4572ZPPurge Live Promotions Interface22PGEXDJDate - ExpiredDateGeneric Edit60
107F4574Key Reference Table19KREXDJDate - ExpiredDateGeneric Edit60
108F4575Ship and Debit History40AHEXDJDate - ExpiredDateGeneric Edit60
109F4575TMPShip and Debit History - Temp Table40AHEXDJDate - ExpiredDateGeneric Edit60
110F4576Z1Ship and Debit Claims Unedited Transaction Table118Z1EXDJDate - ExpiredDateGeneric Edit60
TOP46: Warehouse Management
111F4625Label Next Numbers2LNEXDJDate - ExpiredDateGeneric Edit60
TOP47: Electronic Commerce
112F47082EDI Price Sales Catalog Detail - Inbound71FYEXDJDate - ExpiredDateGeneric Edit60
113F4780Address Cross-Reference4AXEXDJDate - ExpiredDateGeneric Edit60
TOP49: Transportation Management
114F490052Generate Tracking Segment Next Number5YGEXDJDate - ExpiredDateGeneric Edit60
115F49015Vehicle Status4STEXDJDate - ExpiredDateGeneric Edit60
116F49020Vehicle/Staff License Information9VLEXDJDate - ExpiredDateGeneric Edit60
117F49025Connected Vehicles (Conversion from World File)8CVEXDJDate - ExpiredDateGeneric Edit60
118F49030Vehicle Equipment (Conversion from World File)5VEEXDJDate - ExpiredDateGeneric Edit60
119F49040Vehicle Staff (Conversion from World File)5VSEXDJDate - ExpiredDateGeneric Edit60
120F49041Depot/Vehicle Staff4VSEXDJDate - ExpiredDateGeneric Edit60
121F49160Document Next Number6NNEXDJDate - ExpiredDateGeneric Edit60
122F49302Vehicle Equipment5VEEXDJDate - ExpiredDateGeneric Edit60
123F4935Connected Vehicle Header3VHEXDJDate - ExpiredDateGeneric Edit60
124F4936Connected Vehicle Detail7CWEXDJDate - ExpiredDateGeneric Edit60
125F4950Routing Entries33RTEXDJDate - ExpiredDateGeneric Edit60
126F49501Intermodal Detail Routing Entries19RDEXDJDate - ExpiredDateGeneric Edit60
127F4956Option and Equipment Inclusions/Exclusions6IXEXDJDate - ExpiredDateGeneric Edit60
128F4972Rate Detail12RXEXDJDate - ExpiredDateGeneric Edit60
129F4974RateWare XL Rate Constants24RWEXDJDate - ExpiredDateGeneric Edit60
130F4977Rate Parameters20MREXDJDate - ExpiredDateGeneric Edit60
TOP75C: China
131F75C4106Chinese Free Goods VAT base price - F75C4106 - 419IBEXDJDate - ExpiredDateGeneric Edit60
TOP75I: India
132F75I072Tax Rules Setup - IND - 457TSEXDJDate - ExpiredDateGeneric Edit60
TOP89: Conversion Programs
133F40344ATemporay Preference Profile - Sales Commission6SAEXDJDate - ExpiredDateGeneric Edit60
134F4072TEMPrice Adjustment Detail - Temp for Upgrade15ADEXDJDate - ExpiredDateGeneric Edit60
TOPH92: Interactive Engine/OL
135F00165TMedia Object Conversion Table12GDEXDJDate - ExpiredDateGeneric Edit60