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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

37 columns | Print definition?812 | APID

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP12: Fixed Assets
1F1201Asset Master File3FAAPIDUnit or Tag NumberStringUDC120
2F1201PAsset Master Purge Table3FAAPIDUnit or Tag NumberStringUDC120
3F1201Z1Unedited Asset Master Transactions16FAAPIDUnit or Tag NumberStringUDC120
TOP13: Plant/Equipment Management
4F1207Maintenance Schedule File2FWAPIDUnit or Tag NumberStringUDC120
5F12071Equipment PM Schedule (Model)61FZAPIDUnit or Tag NumberStringUDC120
6F1207PMaintenance Schedule Purge Table2FWAPIDUnit or Tag NumberStringUDC120
7F12120Z1Unedited Meter Reading Transactions16SZAPIDUnit or Tag NumberStringUDC120
8F1306Meter Reading Estimates2F5APIDUnit or Tag NumberStringUDC120
9F1306PMeter Reading Estimates Purge Table2F5APIDUnit or Tag NumberStringUDC120
10F1393Maintenance Rules13GOAPIDUnit or Tag NumberStringUDC120
TOP13C: Condition-Base Maintenance
11F1310Condition-Based Alerts3CAAPIDUnit or Tag NumberStringUDC120
12F1310Z1Unedited Condition-Based Alerts16CBAPIDUnit or Tag NumberStringUDC120
TOP13E: Equipment Cost Analysis
13F1382Equipment Analysis Listing6ELAPIDUnit or Tag NumberStringUDC120
14F1383Equipment Analysis Costs11ECAPIDUnit or Tag NumberStringUDC120
TOP17: Customer Service Management
15F3112Z2Warranty Claim/Supplier Recovery processing70WLAPIDUnit or Tag NumberStringUDC120
16F4801Z2Warranty Claim/Supplier Recovery processing81WSAPIDUnit or Tag NumberStringUDC120
TOP30: Product Data Management
17F300311Lean Multi Level Routing Detail File29EHAPIDUnit or Tag NumberStringUDC120
18F3003Z1Routing Transactions File44SZAPIDUnit or Tag NumberStringUDC120
TOP31: Shop Floor Control
19F3112Work Order Routing58WLAPIDUnit or Tag NumberStringUDC120
20F31122Work Order Time Transactions22WTAPIDUnit or Tag NumberStringUDC120
21F31122SPurge Work Order Time Transactions22WTAPIDUnit or Tag NumberStringUDC120
22F31122Z1Work Order Time Transactions Unedited Transaction Table35SZAPIDUnit or Tag NumberStringUDC120
23F3112SPurge Shop Floor Control Routing Instructions58WLAPIDUnit or Tag NumberStringUDC120
24F3112Z1Outbound Work Order Routings70SZAPIDUnit or Tag NumberStringUDC120
25F4801SPurge - Work Order Master file62WAAPIDUnit or Tag NumberStringUDC120
26F4801Z1Outbound Work Order Header81SYAPIDUnit or Tag NumberStringUDC120
TOP40: Inventory/OP Base
27F3003Routing Master File31IRAPIDUnit or Tag NumberStringUDC120
TOP48: Work Order Processing
28F4801Work Order Master File62WAAPIDUnit or Tag NumberStringUDC120
29F48UI001X4801 Master Business Function Workfile65WAAPIDUnit or Tag NumberStringUDC120
TOPD3N: dcLINK (data collection) - DSI
30FD3N0001dcLINK Xpress Check Out7ZZAPIDUnit or Tag NumberStringUDC120
31FD3N120PPost Report Table2FAAPIDUnit or Tag NumberStringUDC120
32FD3N120TAsset Number Work File3FAAPIDUnit or Tag NumberStringUDC120
33FD3N120WAsset Field Counts2FAAPIDUnit or Tag NumberStringUDC120
34FD3N120XFixed Asset Confirmation Find/Browse2FAAPIDUnit or Tag NumberStringUDC120
TOPF30L: DFM Line Design
35FF30L930DFM Routings32LRAPIDUnit or Tag NumberStringUDC120
TOPF31: Lean Transactions
36FF31112Routing Transaction Table42EHAPIDUnit or Tag NumberStringUDC120
37FF31112SPurge - Routing Transaction Table42ETAPIDUnit or Tag NumberStringUDC120