JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

124 columns | Print definition?920 | NUMB

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03: Accounts Receivable
1F0311Accounts Receivable Ledger90RPNUMBAsset Item NumberNumericGeneric Edit80
TOP03B: Enhanced Accounts Receivable
2F03B14Receipts Detail74RZNUMBAsset Item NumberNumericGeneric Edit80
3F03B14PReceipts Detail Purge File74RZNUMBAsset Item NumberNumericGeneric Edit80
4F03B14Z2F03B14 Interoperability Table87SZNUMBAsset Item NumberNumericGeneric Edit80
TOP12: Fixed Assets
5F1201Asset Master File2FANUMBAsset Item NumberNumericGeneric Edit80
6F1201DAsset Master - Alternate Description1LJNUMBAsset Item NumberNumericGeneric Edit80
7F1201PAsset Master Purge Table2FANUMBAsset Item NumberNumericGeneric Edit80
8F1201Z1Unedited Asset Master Transactions15FANUMBAsset Item NumberNumericGeneric Edit80
9F1202Asset Account Balances File34FLNUMBAsset Item NumberNumericGeneric Edit80
10F1202PAsset Account Balances Purge Table34FLNUMBAsset Item NumberNumericGeneric Edit80
11F1204Location Tracking Table1FMNUMBAsset Item NumberNumericGeneric Edit80
12F1204PLocation Tracking Purge Table1FMNUMBAsset Item NumberNumericGeneric Edit80
13F1205Equipment Messages1FTNUMBAsset Item NumberNumericGeneric Edit80
14F1205PEquipment Messages Purge Table1FTNUMBAsset Item NumberNumericGeneric Edit80
15F12092Fixed Assets Supplemental Data Codes Type2F3NUMBAsset Item NumberNumericGeneric Edit80
16F1212Parent History1FYNUMBAsset Item NumberNumericGeneric Edit80
17F1212PParent History Purge Table1FYNUMBAsset Item NumberNumericGeneric Edit80
18F1216Specification Data1GZNUMBAsset Item NumberNumericGeneric Edit80
19F1217Equipment Master Extension1WRNUMBAsset Item NumberNumericGeneric Edit80
20F1217PEquipment Master Extension Purge Table1WRNUMBAsset Item NumberNumericGeneric Edit80
21F1217Z1Unedited Equipment Tag Transactions14WRNUMBAsset Item NumberNumericGeneric Edit80
22F1217Z2Unedited Equipment Tag Transactions14WRNUMBAsset Item NumberNumericGeneric Edit80
23F1301Equipment Rates3FGNUMBAsset Item NumberNumericGeneric Edit80
24F1301PEquipment Rates Purge Table3FGNUMBAsset Item NumberNumericGeneric Edit80
TOP13: Plant/Equipment Management
25F1206Equipment License Master1FHNUMBAsset Item NumberNumericGeneric Edit80
26F1206PEquipment License Master Purge Table1FHNUMBAsset Item NumberNumericGeneric Edit80
27F1207Maintenance Schedule File1FWNUMBAsset Item NumberNumericGeneric Edit80
28F12071Equipment PM Schedule (Model)29FZNUMBAsset Item NumberNumericGeneric Edit80
29F1207PMaintenance Schedule Purge Table1FWNUMBAsset Item NumberNumericGeneric Edit80
30F12120Z1Unedited Meter Reading Transactions15SZNUMBAsset Item NumberNumericGeneric Edit80
31F12122Equipment Template Listing2ELNUMBAsset Item NumberNumericGeneric Edit80
32F13017Equipment Parts List1PLNUMBAsset Item NumberNumericGeneric Edit80
33F1304Equipment Location Billing4FNNUMBAsset Item NumberNumericGeneric Edit80
34F1305Equipment Distribution Rules4FVNUMBAsset Item NumberNumericGeneric Edit80
35F1306Meter Reading Estimates1F5NUMBAsset Item NumberNumericGeneric Edit80
36F1306PMeter Reading Estimates Purge Table1F5NUMBAsset Item NumberNumericGeneric Edit80
37F1308Equipment Routes Table1F0NUMBAsset Item NumberNumericGeneric Edit80
38F1308PEquipment Routes Purge Table1F0NUMBAsset Item NumberNumericGeneric Edit80
39F13411PM Projections1RXNUMBAsset Item NumberNumericGeneric Edit80
40F13907Associated Service Types1FCNUMBAsset Item NumberNumericGeneric Edit80
41F13907PAssociated Service Types Purge Table1FCNUMBAsset Item NumberNumericGeneric Edit80
42F1393Maintenance Rules1GONUMBAsset Item NumberNumericGeneric Edit80
TOP13C: Condition-Base Maintenance
43F1310Condition-Based Alerts2CANUMBAsset Item NumberNumericGeneric Edit80
44F1310Z1Unedited Condition-Based Alerts15CBNUMBAsset Item NumberNumericGeneric Edit80
45F1316Condition-Based Maintenance Message Rules8CMNUMBAsset Item NumberNumericGeneric Edit80
46F1318Condition-Based Maintenance Alert Action Rules7ARNUMBAsset Item NumberNumericGeneric Edit80
TOP13E: Equipment Cost Analysis
47F1381Equipment Analysis Filters14EFNUMBAsset Item NumberNumericGeneric Edit80
48F1382Equipment Analysis Listing4ELNUMBAsset Item NumberNumericGeneric Edit80
49F1383Equipment Analysis Costs4ECNUMBAsset Item NumberNumericGeneric Edit80
TOP15L: Adv Real Estate Forecasting
50F15L101AREF Unit Master63UMNUMBAsset Item NumberNumericGeneric Edit80
TOP17: Customer Service Management
51F1721Contract Detail38CDNUMBAsset Item NumberNumericGeneric Edit80
52F3112Z2Warranty Claim/Supplier Recovery processing100WLNUMBAsset Item NumberNumericGeneric Edit80
53F4801Z2Warranty Claim/Supplier Recovery processing80WSNUMBAsset Item NumberNumericGeneric Edit80
54F48162Failure Analysis Tree Names30KNNUMBAsset Item NumberNumericGeneric Edit80
55F48164Failure Analysis Detail35KBNUMBAsset Item NumberNumericGeneric Edit80
TOP17C: Call Management
56F1713ECOs Applied to Equipment1EENUMBAsset Item NumberNumericGeneric Edit80
57F1731Equipment Master Location History3LQNUMBAsset Item NumberNumericGeneric Edit80
58F1755Case Master67ZANUMBAsset Item NumberNumericGeneric Edit80
TOP30: Product Data Management
59F3003TRouting Tag File - not used in B9, obsolete in B1012IRNUMBAsset Item NumberNumericGeneric Edit80
60F3003Z1Routing Transactions File71SZNUMBAsset Item NumberNumericGeneric Edit80
TOP31: Shop Floor Control
61F3112Work Order Routing88WLNUMBAsset Item NumberNumericGeneric Edit80
62F31122Work Order Time Transactions47WTNUMBAsset Item NumberNumericGeneric Edit80
63F31122SPurge Work Order Time Transactions47WTNUMBAsset Item NumberNumericGeneric Edit80
64F31122TWork Order Time Transactions Tag Table -- Needed for upgrade5WTNUMBAsset Item NumberNumericGeneric Edit80
65F31122Z1Work Order Time Transactions Unedited Transaction Table61SZNUMBAsset Item NumberNumericGeneric Edit80
66F3112SPurge Shop Floor Control Routing Instructions88WLNUMBAsset Item NumberNumericGeneric Edit80
67F3112TShop Floor Control Routing Instructions Tag Table - Needed f13WLNUMBAsset Item NumberNumericGeneric Edit80
68F3112Z1Outbound Work Order Routings100SZNUMBAsset Item NumberNumericGeneric Edit80
TOP37: Quality Management
69F3701Test Definitions Master File38QANUMBAsset Item NumberNumericGeneric Edit80
70F37011Test Equipment3TENUMBAsset Item NumberNumericGeneric Edit80
71F3711Test Results76TRNUMBAsset Item NumberNumericGeneric Edit80
72F3711Z1Test Results Unedited Transaction Table89SZNUMBAsset Item NumberNumericGeneric Edit80
73F37900Certificate of Analysis (COA) Extract82TRNUMBAsset Item NumberNumericGeneric Edit80
74F40318Preference Profile - Quality Management51QCNUMBAsset Item NumberNumericGeneric Edit80
TOP40: Inventory/OP Base
75F3003Routing Master File59IRNUMBAsset Item NumberNumericGeneric Edit80
76F40051Return Material Authorization36RDNUMBAsset Item NumberNumericGeneric Edit80
77F40318RPreference Resolution Ledger - Quality Management53QCNUMBAsset Item NumberNumericGeneric Edit80
78F4211Z1Sales Order Detail Unedited Transaction File252SZNUMBAsset Item NumberNumericGeneric Edit80
TOP42: Sales Management
79F4211Sales Order Detail File244SDNUMBAsset Item NumberNumericGeneric Edit80
80F42119Sales Order History File244SDNUMBAsset Item NumberNumericGeneric Edit80
81F42199S.O. Detail Ledger File244SLNUMBAsset Item NumberNumericGeneric Edit80
82F42UI11SO Detail Cache File (MBF)175ZDNUMBAsset Item NumberNumericGeneric Edit80
83F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound25UZNUMBAsset Item NumberNumericGeneric Edit80
84F470371TTag for F470371- EDI shipping Notice Detail - Outbound39UZNUMBAsset Item NumberNumericGeneric Edit80
85F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound25UZNUMBAsset Item NumberNumericGeneric Edit80
86F47107TTag for F47107- EDI Response to RFQ Detail - Outbound25UZNUMBAsset Item NumberNumericGeneric Edit80
87F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound25UZNUMBAsset Item NumberNumericGeneric Edit80
TOP42B: Sales Order Entry
88F4011ZTBatch Receiver File - Order Details Tag53UZNUMBAsset Item NumberNumericGeneric Edit80
89F47012TEDI Purchase Order Detail Tag - Inbound53UZNUMBAsset Item NumberNumericGeneric Edit80
90F47092TEDI Request for Quote Detail Tag - Inbound53UZNUMBAsset Item NumberNumericGeneric Edit80
91F47132TEDI Purchase Order Change Detail Tag - Inbound53UZNUMBAsset Item NumberNumericGeneric Edit80
TOP46: Warehouse Management
92F4611T1Warehouse Suggestions Tag File10R2NUMBAsset Item NumberNumericGeneric Edit80
93F4611TP1Warehouse Suggestions Tag File - Purged10R2NUMBAsset Item NumberNumericGeneric Edit80
TOP48: Work Order Processing
94F4801Work Order Master File61WANUMBAsset Item NumberNumericGeneric Edit80
95F4801SPurge - Work Order Master file61WANUMBAsset Item NumberNumericGeneric Edit80
96F4801Z1Outbound Work Order Header80SYNUMBAsset Item NumberNumericGeneric Edit80
97F48UI001X4801 Master Business Function Workfile64WANUMBAsset Item NumberNumericGeneric Edit80
TOP48S: Service Billing
98F48096Billing Rate / Mark up Table20WQNUMBAsset Item NumberNumericGeneric Edit80
TOP54HS: Health & Safety Incident Mgt
99F54HS03Incident Equipment3S4NUMBAsset Item NumberNumericGeneric Edit80
100F54HS03MIncident Equipment Change History6I4NUMBAsset Item NumberNumericGeneric Edit80
TOP54R: Rental Management
101F54R11Rental Contract Detail7CDNUMBAsset Item NumberNumericGeneric Edit80
102F54R199Rental Contract Detail Ledger9DLNUMBAsset Item NumberNumericGeneric Edit80
TOP74H: Hungary
103F741202Work File Accumulated Asset Movement Dep - HUN - 748WFNUMBAsset Item NumberNumericGeneric Edit80
TOP74R: Russia
104F74R5110F1201 Tag File - RUS - 12 - 74R2TFNUMBAsset Item NumberNumericGeneric Edit80
TOP75C: China
105F75C201Modification Methods Information - CHINA1MMNUMBAsset Item NumberNumericGeneric Edit80
106F75C202Asset Disposal Amounts - CHINA1DANUMBAsset Item NumberNumericGeneric Edit80
107F75C203Fixed Assets Card Usage Information - CHINA1FANUMBAsset Item NumberNumericGeneric Edit80
108F75C204Asset Master History File - CHINA2AHNUMBAsset Item NumberNumericGeneric Edit80
TOP76B: Brazil
109F76B0804Asset number - SPED Fiscal Brazilian Workfile4ANNUMBAsset Item NumberNumericGeneric Edit80
110F76B1201Brazilian Fixed Asset Additional Information - BRA - 76B1FANUMBAsset Item NumberNumericGeneric Edit80
111F76B8200IN86-Work Table for Fixed Assets - 121FANUMBAsset Item NumberNumericGeneric Edit80
TOP76C: Colombia
112F76C034AA/R Check Detail file As Of - COL - 03B72RZNUMBAsset Item NumberNumericGeneric Edit80
TOP76P: Peru
113F76P503Regional Constants by Asset Number - PER - 12 - 76P1RCNUMBAsset Item NumberNumericGeneric Edit80
TOP79A: Greenhouse Gas Accounting
114F79A04GHG Items4GFNUMBAsset Item NumberNumericGeneric Edit80
115F79A08GHG Assets1GSNUMBAsset Item NumberNumericGeneric Edit80
116F79A09GHG Energy Rates6ERNUMBAsset Item NumberNumericGeneric Edit80
117F79A10GHG Rates6ERNUMBAsset Item NumberNumericGeneric Edit80
118F79A11GHG Ledger35GRNUMBAsset Item NumberNumericGeneric Edit80
119F79A11Z1GHG Ledger - Batch File53GLNUMBAsset Item NumberNumericGeneric Edit80
120F79A12GHG Ledger Audit36GRNUMBAsset Item NumberNumericGeneric Edit80
121F79AU11GHG Ledger Work Table38GRNUMBAsset Item NumberNumericGeneric Edit80
TOPF31: Lean Transactions
122FF31113Lean Transaction Labor Detail39LDNUMBAsset Item NumberNumericGeneric Edit80
123FF31113SPurge - Lean Transaction Labor Detail39LRNUMBAsset Item NumberNumericGeneric Edit80
TOPH95: Object and Environment Tech
124F00166Media Object Categories31GTNUMBAsset Item NumberNumericGeneric Edit80