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

103 columns | Print definition?920 | CRTU

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F17001Service/Warranty Constants Table - F1700130CSCRTUCreated by userStringGeneric Edit100
TOP12: Fixed Assets
2F1217Equipment Master Extension47WRCRTUCreated by userStringGeneric Edit100
3F1217PEquipment Master Extension Purge Table47WRCRTUCreated by userStringGeneric Edit100
4F1217Z1Unedited Equipment Tag Transactions55WRCRTUCreated by userStringGeneric Edit100
5F1217Z2Unedited Equipment Tag Transactions55WRCRTUCreated by userStringGeneric Edit100
TOP13E: Equipment Cost Analysis
6F1380Equipment Analysis Groups9EACRTUCreated by userStringGeneric Edit100
TOP13R: Resource Assignments
7F48316Maintenance Rescheduling Metrics14RSCRTUCreated by userStringGeneric Edit100
TOP17: Customer Service Management
8F1720Contract Header68CHCRTUCreated by userStringGeneric Edit100
9F1721Contract Detail122CDCRTUCreated by userStringGeneric Edit100
10F1724Service Contract Coverage26CTCRTUCreated by userStringGeneric Edit100
11F1725Service Contract Services14STCRTUCreated by userStringGeneric Edit100
12F1726Contract Duration Ranges4DRCRTUCreated by userStringGeneric Edit100
13F1729Service Contract Service Package7SPCRTUCreated by userStringGeneric Edit100
14F1791Entitlement Dates8EMCRTUCreated by userStringGeneric Edit100
15F1792Cost Code Percentages4CPCRTUCreated by userStringGeneric Edit100
16F1793S/WM Line Type Constants8LFCRTUCreated by userStringGeneric Edit100
17F1794Billing/Amort Control Master37NKCRTUCreated by userStringGeneric Edit100
18F4117Item Master - Service/Warranty Extension10PRCRTUCreated by userStringGeneric Edit100
19F41171Item Branch Master - Service/Warranty Extension11PBCRTUCreated by userStringGeneric Edit100
20F4801TZ2Warranty Claim/Supplier Recovery processing134WQCRTUCreated by userStringGeneric Edit100
21F48161Failure Analysis Codes18KCCRTUCreated by userStringGeneric Edit100
22F48162Failure Analysis Tree Names24KNCRTUCreated by userStringGeneric Edit100
23F48163Failure Analysis Tree Definition6KTCRTUCreated by userStringGeneric Edit100
24F48164Failure Analysis Detail19KBCRTUCreated by userStringGeneric Edit100
25F48165Maintenance Request/Work Order Failure Analysis6KXCRTUCreated by userStringGeneric Edit100
26F48166Failure Analysis Pareto Table6KPCRTUCreated by userStringGeneric Edit100
TOP17C: Call Management
27F17111Base Warranty Defaults20BCCRTUCreated by userStringGeneric Edit100
28F17311Equipment Master Location Details22LDCRTUCreated by userStringGeneric Edit100
29F1755Case Master169ZACRTUCreated by userStringGeneric Edit100
30F1757Task Master33ZACRTUCreated by userStringGeneric Edit100
31F1759Case Required Fields7CLCRTUCreated by userStringGeneric Edit100
32F1760Time Entry41ZBCRTUCreated by userStringGeneric Edit100
33F1790Product Family/Model Master4PMCRTUCreated by userStringGeneric Edit100
34F1797S/WM Address Book Information43CSCRTUCreated by userStringGeneric Edit100
TOP40: Inventory/OP Base
35F40051Return Material Authorization55RDCRTUCreated by userStringGeneric Edit100
36F40052Return Material Authorization Defaults26RVCRTUCreated by userStringGeneric Edit100
TOP40G: Grower Management
37F40G02Grower Block114GBCRTUCreated by userStringGeneric Edit100
TOP41: Inventory Management
38F4101FItem Customer Service Data18IMCRTUCreated by userStringGeneric Edit100
39F4101Z1AF4101 Detail Item Master Unedited Transaction74SZCRTUCreated by userStringGeneric Edit100
TOP42B: Sales Order Entry
40F90CA24AProposal generation templates8DTCRTUCreated by userStringGeneric Edit100
TOP44H: Homebuilder Management
41F44H001HomeBuilder Constants20HCCRTUCreated by userStringGeneric Edit100
42F44H0011HomeBuilder Constants Lot Start Documents8LDCRTUCreated by userStringGeneric Edit100
43F44H002HomeBuilder Activity Rules16ARCRTUCreated by userStringGeneric Edit100
44F44H0920Extended Homebuilder Data Template10STCRTUCreated by userStringGeneric Edit100
45F44H0921Extended Homebuilder Data Headings9EHCRTUCreated by userStringGeneric Edit100
46F44H0929Extended Homebuilder Data34EDCRTUCreated by userStringGeneric Edit100
47F44H092HExtended Homebuilder Data Headings8EHCRTUCreated by userStringGeneric Edit100
48F44H092TExtended Homebuilder Data Template7STCRTUCreated by userStringGeneric Edit100
49F44H101Community Phase Master93CMCRTUCreated by userStringGeneric Edit100
50F44H101ZHB Community Master Unedited Transaction File106SZCRTUCreated by userStringGeneric Edit100
51F44H201Lot Master116LMCRTUCreated by userStringGeneric Edit100
52F44H201HLot Master History117LMCRTUCreated by userStringGeneric Edit100
53F44H201ZHB Lot Master Unedited Transaction File129SZCRTUCreated by userStringGeneric Edit100
54F44H301Plan Master68PMCRTUCreated by userStringGeneric Edit100
55F44H401Option Master74OCCRTUCreated by userStringGeneric Edit100
56F44H4011Option by Community69OCCRTUCreated by userStringGeneric Edit100
57F44H401WOption Master Work File80OWCRTUCreated by userStringGeneric Edit100
58F44H402Option Relationships28PKCRTUCreated by userStringGeneric Edit100
59F44H403Option Preferences12OPCRTUCreated by userStringGeneric Edit100
60F44H4031Option Preferences - Valid Values13OVCRTUCreated by userStringGeneric Edit100
61F44H4101Item Master HomeBuilder Extension13HICRTUCreated by userStringGeneric Edit100
62F44H501Sales Master Table165SMCRTUCreated by userStringGeneric Edit100
63F44H501HLot Sales History175LSCRTUCreated by userStringGeneric Edit100
64F44H501SSales Statistics History94SSCRTUCreated by userStringGeneric Edit100
65F44H501WSales Statistics Work Table74SSCRTUCreated by userStringGeneric Edit100
66F44H501ZHB Sales Master Unedited Transaction File178SZCRTUCreated by userStringGeneric Edit100
67F44H511Option Selections32OSCRTUCreated by userStringGeneric Edit100
68F44H511HOption Selection History34OHCRTUCreated by userStringGeneric Edit100
69F44H512Option Preference Selections10PSCRTUCreated by userStringGeneric Edit100
70F44H590Closing Worksheet Accounting Instructions17CICRTUCreated by userStringGeneric Edit100
71F44H591Closing Worksheet Entries20CWCRTUCreated by userStringGeneric Edit100
72F44H592Closing Worksheet Extended Data Mapping9EMCRTUCreated by userStringGeneric Edit100
73F44H599Closing Worksheet Data Mapping6CMCRTUCreated by userStringGeneric Edit100
74F44H601Bid Header49BHCRTUCreated by userStringGeneric Edit100
75F44H602Takeoff Master File22TOCRTUCreated by userStringGeneric Edit100
76F44H602HTakeoff History File23THCRTUCreated by userStringGeneric Edit100
77F44H603Material Item Pricing43MPCRTUCreated by userStringGeneric Edit100
78F44H604Vendor Assignment20VACRTUCreated by userStringGeneric Edit100
79F44H604WVendor Assignment Workfile22VWCRTUCreated by userStringGeneric Edit100
80F44H604ZHB Vendor Assignment Unedited Transaction File33SZCRTUCreated by userStringGeneric Edit100
81F44H611Bid Details80BDCRTUCreated by userStringGeneric Edit100
82F44H611WBid Details Work File84BWCRTUCreated by userStringGeneric Edit100
83F44H711Lot Start Workfile96SWCRTUCreated by userStringGeneric Edit100
84F44H711PAfter Start Purchasing50TPCRTUCreated by userStringGeneric Edit100
85F44H711ZHB Lot Start Unedited Transaction File108SZCRTUCreated by userStringGeneric Edit100
86F44H712Lot Start Workfile Takeoff Detail15STCRTUCreated by userStringGeneric Edit100
87F44H71W1Lot Start Generation Workfile95GWCRTUCreated by userStringGeneric Edit100
88F44H790Construction Milestones38HMCRTUCreated by userStringGeneric Edit100
TOP48: Work Order Processing
89F4801STPurge - Work Order Master Tag File121WACRTUCreated by userStringGeneric Edit100
90F4801TWork Order Master Tag File121WACRTUCreated by userStringGeneric Edit100
91F4817Service Order Extension27SRCRTUCreated by userStringGeneric Edit100
TOP54HS: Health & Safety Incident Mgt
92F54HS01Incident Master88S1CRTUCreated by userStringGeneric Edit100
93F54HS01MIncident Master Change History91I1CRTUCreated by userStringGeneric Edit100
TOP54R: Rental Management
94F54R41TRental Item Details Table42RICRTUCreated by userStringGeneric Edit100
TOP90CG: CRM Case Management
95F1755URF1755 - CRM User Reserved Tag File32CACRTUCreated by userStringGeneric Edit100
96F90CG503Case Association Table11CACRTUCreated by userStringGeneric Edit100
97F90CG506Provider Group Employees6ZCCRTUCreated by userStringGeneric Edit100
TOPH92: Interactive Engine/OL
98F00165TMedia Object Conversion Table5GDCRTUCreated by userStringGeneric Edit100
99F98306Processing Option Text6PTCRTUCreated by userStringGeneric Edit100
TOPH95: Object and Environment Tech
100F952400User Generated Contents Detail22UCCRTUCreated by userStringGeneric Edit100
101F980045Mail Merge Simple Template Header3STCRTUCreated by userStringGeneric Edit100
102F980046Composite Template Header3CTCRTUCreated by userStringGeneric Edit100
103F980047Mail Merge Data Set Header3DTCRTUCreated by userStringGeneric Edit100