JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

110 columns | Print definition?812 | NUMB

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03: Accounts Receivable
1F0311Accounts Receivable Ledger90RPNUMBAsset Item NumberNumericGeneric Edit80
TOP03B: Enhanced Accounts Receivable
2F03B14A/R Check Detail File74RZNUMBAsset 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
TOP17C: Call Management
54F1713ECOs Applied to Equipment1EENUMBAsset Item NumberNumericGeneric Edit80
55F1731Installed Base Location History3LQNUMBAsset Item NumberNumericGeneric Edit80
56F1755Customer Call Master67ZANUMBAsset Item NumberNumericGeneric Edit80
57F48162Knowledge Base Tree Names30KNNUMBAsset Item NumberNumericGeneric Edit80
58F48164Knowledge Base Detail35KBNUMBAsset Item NumberNumericGeneric Edit80
TOP30: Product Data Management
59F3003Z1Routing Transactions File71SZNUMBAsset Item NumberNumericGeneric Edit80
TOP31: Shop Floor Control
60F3112Work Order Routing88WLNUMBAsset Item NumberNumericGeneric Edit80
61F31122Work Order Time Transactions47WTNUMBAsset Item NumberNumericGeneric Edit80
62F31122SPurge Work Order Time Transactions47WTNUMBAsset Item NumberNumericGeneric Edit80
63F31122TWork Order Time Transactions Tag Table5WTNUMBAsset Item NumberNumericGeneric Edit80
64F31122Z1Work Order Time Transactions Unedited Transaction Table61SZNUMBAsset Item NumberNumericGeneric Edit80
65F3112SPurge Shop Floor Control Routing Instructions88WLNUMBAsset Item NumberNumericGeneric Edit80
66F3112TShop Floor Control Routing Instructions Tag Table13WLNUMBAsset Item NumberNumericGeneric Edit80
67F3112Z1Outbound Work Order Routings100SZNUMBAsset Item NumberNumericGeneric Edit80
68F4801SPurge - Work Order Master file61WANUMBAsset Item NumberNumericGeneric Edit80
69F4801Z1Outbound Work Order Header80SYNUMBAsset Item NumberNumericGeneric Edit80
TOP37: Quality Management
70F3701Test Definitions Master File38QANUMBAsset Item NumberNumericGeneric Edit80
71F37011Test Equipment3TENUMBAsset Item NumberNumericGeneric Edit80
72F3711Test Results76TRNUMBAsset Item NumberNumericGeneric Edit80
73F3711Z1Test Results Unedited Transaction Table89SZNUMBAsset Item NumberNumericGeneric Edit80
74F37900Certificate of Analysis (COA) Extract82TRNUMBAsset Item NumberNumericGeneric Edit80
75F40318Preference Profile - Quality Management51QCNUMBAsset Item NumberNumericGeneric Edit80
TOP40: Inventory/OP Base
76F3003Routing Master File59IRNUMBAsset Item NumberNumericGeneric Edit80
77F3003TRouting Tag File12IRNUMBAsset Item NumberNumericGeneric Edit80
78F40051Return Material Authorization36RDNUMBAsset Item NumberNumericGeneric Edit80
79F40318RPreference Resolution Ledger - Quality Management53QCNUMBAsset Item NumberNumericGeneric Edit80
80F4211Z1Sales Order Detail Unedited Transaction File252SZNUMBAsset Item NumberNumericGeneric Edit80
TOP42: Sales Management
81F4211Sales Order Detail File244SDNUMBAsset Item NumberNumericGeneric Edit80
82F42119Sales Order History File244SDNUMBAsset Item NumberNumericGeneric Edit80
83F42199S.O. Detail Ledger File244SLNUMBAsset Item NumberNumericGeneric Edit80
84F42UI11SO Detail Cache File (MBF)175ZDNUMBAsset Item NumberNumericGeneric Edit80
85F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound25UZNUMBAsset Item NumberNumericGeneric Edit80
86F470371TTag for F470371- EDI shipping Notice Detail - Outbound39UZNUMBAsset Item NumberNumericGeneric Edit80
87F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound25UZNUMBAsset Item NumberNumericGeneric Edit80
88F47107TTag for F47107- EDI Response to RFQ Detail - Outbound25UZNUMBAsset Item NumberNumericGeneric Edit80
89F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound25UZNUMBAsset Item NumberNumericGeneric Edit80
TOP42B: Sales Order Entry
90F4011ZTBatch Receiver File - Order Details Tag53UZNUMBAsset Item NumberNumericGeneric Edit80
91F47012TEDI Purchase Order Detail Tag - Inbound53UZNUMBAsset Item NumberNumericGeneric Edit80
92F47092TEDI Request for Quote Detail Tag - Inbound53UZNUMBAsset Item NumberNumericGeneric Edit80
93F47132TEDI Purchase Order Change Detail Tag - Inbound53UZNUMBAsset Item NumberNumericGeneric Edit80
TOP48: Work Order Processing
94F4801Work Order Master File61WANUMBAsset Item NumberNumericGeneric Edit80
95F48UI001X4801 Master Business Function Workfile64WANUMBAsset Item NumberNumericGeneric Edit80
TOP48S: Service Billing
96F48096Billing Rate / Mark up Table20WQNUMBAsset Item NumberNumericGeneric Edit80
TOP55: Reserved for Clients
97F55W0100Correction Invoice Print - WF1245SDNUMBAsset Item NumberNumericGeneric Edit80
TOP74H: Hungary
98F741202Work File Accumulated Asset Movement Dep - HUN - 748WFNUMBAsset Item NumberNumericGeneric Edit80
TOP74R: CIS
99F74R5110F1201 Tag File - RUS - 12 - 74R2TFNUMBAsset Item NumberNumericGeneric Edit80
TOP76B: Brazil - Reporting System Only
100F76B8200IN86-Work Table for Fixed Assets - 121FANUMBAsset Item NumberNumericGeneric Edit80
TOP76C: Colombia
101F76C034AA/R Check Detail file As Of - COL - 76C72RZNUMBAsset Item NumberNumericGeneric Edit80
TOP76P: Peru
102F76P503Regional Constants by Asset Number - PER - 12 - 76P1RCNUMBAsset Item NumberNumericGeneric Edit80
TOPD3N: dcLINK (data collection) - DSI
103FD3N0001dcLINK Xpress Check Out6ZZNUMBAsset Item NumberNumericGeneric Edit80
104FD3N120PPost Report Table1FANUMBAsset Item NumberNumericGeneric Edit80
105FD3N120TAsset Number Work File2FANUMBAsset Item NumberNumericGeneric Edit80
106FD3N120WAsset Field Counts1FANUMBAsset Item NumberNumericGeneric Edit80
107FD3N120XFixed Asset Confirmation Find/Browse1FANUMBAsset Item NumberNumericGeneric Edit80
TOPF31: Lean Transactions
108FF31113Lean Transaction Labor Detail39LDNUMBAsset Item NumberNumericGeneric Edit80
109FF31113SPurge - Lean Transaction Labor Detail39LRNUMBAsset Item NumberNumericGeneric Edit80
TOPH95: Tech Resources/Applications
110F00166Media Object Categories31GTNUMBAsset Item NumberNumericGeneric Edit80