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

104 columns | Print definition?920 | RKCO

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03B: Enhanced Accounts Receivable
1F03B116Revenue Recognition Invoice1RKCOCompanyStringGeneric Edit50
TOP17: Customer Service Management
2F3111Z2Warranty Claim/Supplier Recovery processing27WPRKCOCompany - Key (Related Order)StringGeneric Edit50
3F3112Z2Warranty Claim/Supplier Recovery processing76WLRKCOCompany - Key (Related Order)StringGeneric Edit50
4F4801Z2Warranty Claim/Supplier Recovery processing115WSRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP17C: Call Management
5F1755Case Master78ZARKCOCompany - Key (Related Order)StringGeneric Edit50
TOP31: Shop Floor Control
6F3111Work Order Parts List14WMRKCOCompany - Key (Related Order)StringGeneric Edit50
7F3111SPurge - Shop Floor Parts List14WMRKCOCompany - Key (Related Order)StringGeneric Edit50
8F3111Z1Outbound Work Order Parts List27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
9F3112Work Order Routing64WLRKCOCompany - Key (Related Order)StringGeneric Edit50
10F3112SPurge Shop Floor Control Routing Instructions64WLRKCOCompany - Key (Related Order)StringGeneric Edit50
11F3112Z1Outbound Work Order Routings76SZRKCOCompany - Key (Related Order)StringGeneric Edit50
12F3118Shortage Maintenance Master File10WNRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP31P: Engineer To Order
13F31P10Project Quote Header23PQRKCOCompany - Key (Related Order)StringGeneric Edit50
14F31P11Project Quote Detail32QPRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP34: Requirements Planning
15F3412MPS/MRP/DRP Lower Level Requirements File10MWRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP34X: In-Memory Planning Advisor
16F34X200WPlanning Details Supply/Demand Work Table48SDRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP37: Quality Management
17F3711Test Results7TRRKCOCompany - Key (Related Order)StringGeneric Edit50
18F3711Z1Test Results Unedited Transaction Table20SZRKCOCompany - Key (Related Order)StringGeneric Edit50
19F37900Certificate of Analysis (COA) Extract7TRRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP40: Inventory/OP Base
20F4001ZBatch Receiver File - Order Headings33SYRKCOCompany - Key (Related Order)StringGeneric Edit50
21F40051Return Material Authorization3RDRKCOCompany - Key (Related Order)StringGeneric Edit50
22F4011ZBatch Receiver File - Order Details25SZRKCOCompany - Key (Related Order)StringGeneric Edit50
23F4201Z1Sales Order Header Unedited Transaction File23SYRKCOCompany - Key (Related Order)StringGeneric Edit50
24F4211Z1Sales Order Detail Unedited Transaction File25SZRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP41: Inventory Management
25F4118Container Deposit File8CNRKCOCompany - Key (Related Order)StringGeneric Edit50
26F41181Container Transaction File19CMRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP41F: Apparel Management
27FCW65Work Order Header for Style Items86OFRKCOCompany - Key (Related Order)StringGeneric Edit50
28FCW67Style Work Order Parts List20WMRKCOCompany - Key (Related Order)StringGeneric Edit50
29FCW68Style Work Order Routings68WLRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP42: Sales Management
30F4201Sales Order Header File10SHRKCOCompany - Key (Related Order)StringGeneric Edit50
31F42019Sales Order Header History File10SHRKCOCompany - Key (Related Order)StringGeneric Edit50
32F4211Sales Order Detail File12SDRKCOCompany - Key (Related Order)StringGeneric Edit50
33F42119Sales Order History File12SDRKCOCompany - Key (Related Order)StringGeneric Edit50
34F42199S.O. Detail Ledger File12SLRKCOCompany - Key (Related Order)StringGeneric Edit50
35F42565Invoice Print File40IWRKCOCompany - Key (Related Order)StringGeneric Edit50
36F42UI01SO Header Cache File (MBF)15ZHRKCOCompany - Key (Related Order)StringGeneric Edit50
37F42UI11SO Detail Cache File (MBF)16ZDRKCOCompany - Key (Related Order)StringGeneric Edit50
38F42UI520Pick Slips Header File34S8RKCOCompany - Key (Related Order)StringGeneric Edit50
39F42UI521Pick Slips Detail File12S9RKCOCompany - Key (Related Order)StringGeneric Edit50
TOP43: Procurement
40F4301Purchase Order Header9PHRKCOCompany - Key (Related Order)StringGeneric Edit50
41F4301ZPO Header Work File13PARKCOCompany - Key (Related Order)StringGeneric Edit50
42F4301Z1Purchase Order Header Unedited Transaction Table22SYRKCOCompany - Key (Related Order)StringGeneric Edit50
43F43080Approvals Fields Constants22PDRKCOCompany - Key (Related Order)StringGeneric Edit50
44F4311Purchase Order Detail File12PDRKCOCompany - Key (Related Order)StringGeneric Edit50
45F4311ZPurchase Order Generator File16PWRKCOCompany - Key (Related Order)StringGeneric Edit50
46F4311Z1Purchase Order Detail Unedited Transaction Table25SZRKCOCompany - Key (Related Order)StringGeneric Edit50
47F43199P.O. Detail Ledger File - Flexible Version12OLRKCOCompany - Key (Related Order)StringGeneric Edit50
48F43UI50DPO Print Detail Work File44PWRKCOCompany - Key (Related Order)StringGeneric Edit50
49F43UI50HPO Print Header Work File39PARKCOCompany - Key (Related Order)StringGeneric Edit50
TOP43E: Requisition Self Service
50F43E121eRequisition Receiver file11ERRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP43Q: Strategic Sourcing
51F43Q50Analyze Event Header15AVRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP45: Advanced Pricing
52F4079Rebate Transaction Detail22SVRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP47: Electronic Commerce
53F47011EDI Purchase Order Header - Inbound28SYRKCOCompany - Key (Related Order)StringGeneric Edit50
54F47012EDI Purchase Order Detail - Inbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
55F47016EDI Purchase Order Header - Outbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
56F47017EDI Purchase Order Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
57F47021EDI P.O. Acknowledgment Header - Inbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
58F47022EDI P.O. Acknowledgment Detail - Inbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
59F47026EDI P.O. Acknowledgment Header - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
60F47027EDI P.O. Acknowledgment Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
61F47031EDI Shipping Notice Header - Inbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
62F47032EDI Shipping Notice Detail - Inbound29SZRKCOCompany - Key (Related Order)StringGeneric Edit50
63F47037EDI Shipping Notice Detail - Outbound29SZRKCOCompany - Key (Related Order)StringGeneric Edit50
64F470371EDI Shipping Notice Detail - Outbound29SZRKCOCompany - Key (Related Order)StringGeneric Edit50
65F47046EDI Invoice Header (Sales) - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
66F47047EDI Invoice Detail (Sales) - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
67F47071EDI Receiving Advice Header - Inbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
68F47072EDI Receiving Advice Detail - Inbound27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
69F47076EDI Receiving Advice Header - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
70F47077EDI Receiving Advice Detail - Outbound27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
71F47091EDI Request for Quote Header - Inbound28SYRKCOCompany - Key (Related Order)StringGeneric Edit50
72F47092EDI Request for Quote Detail - Inbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
73F47096EDI Request for Quote Header - Outbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
74F47097EDI Request for Quote Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
75F47101EDI Response to RFQ Header - Inbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
76F47102EDI Response to RFQ Detail - Inbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
77F47106EDI Response to RFQ Header - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
78F47107EDI Response to RFQ Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
79F47131EDI Purchase Order Change Header - Inbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
80F47132EDI Purchase Order Change Detail - Inbound27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
81F47136EDI Purchase Order Change Header - Outbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
82F47137EDI Purchase Order Change Detail - Outbound27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
83F47141EDI P.O. Change Acknowledgment Header - Inbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
84F47142EDI P.O. Change Acknowledgment Detail - Inbound28SZRKCOCompany - Key (Related Order)StringGeneric Edit50
85F47146EDI P.O. Change Acknowledgment Header - Outbound26SYRKCOCompany - Key (Related Order)StringGeneric Edit50
86F47147EDI P.O. Change Acknowledgment Detail - Outbound28SZRKCOCompany - Key (Related Order)StringGeneric Edit50
87F47156EDI Shipping Schedule Header - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
88F47157EDI Shipping Schedule Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP48: Work Order Processing
89F4801Work Order Master File96WARKCOCompany - Key (Related Order)StringGeneric Edit50
90F4801SPurge - Work Order Master file96WARKCOCompany - Key (Related Order)StringGeneric Edit50
91F4801Z1Outbound Work Order Header115SYRKCOCompany - Key (Related Order)StringGeneric Edit50
92F48UI001X4801 Master Business Function Workfile99WARKCOCompany - Key (Related Order)StringGeneric Edit50
TOP49: Transportation Management
93F49T10Sales Order Release Staging Table34ORRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP54R: Rental Management
94F54R099Rental Contract Header Ledger8HLRKCOCompany - Key (Related Order)StringGeneric Edit50
95F54R10Rental Contract Header6CHRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP75I: India
96F75I3572Consignment - Stock Transfers11CSRKCOCompany - Key (Related Order)StringGeneric Edit50
97F75I3576Stock Transfer - Work Orders8SWRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP89: Conversion Programs
98F43199ATemp F43199 for ERP 9.0 Upgrade12OLRKCOCompany - Key (Related Order)StringGeneric Edit50
TOPF31: Lean Transactions
99FF31111Lean Transaction Parts List21PLRKCOCompany - Key (Related Order)StringGeneric Edit50
100FF31111SPurge - Lean Transaction Parts List21PRRKCOCompany - Key (Related Order)StringGeneric Edit50
101FF31112Routing Transaction Table66EHRKCOCompany - Key (Related Order)StringGeneric Edit50
102FF31112SPurge - Routing Transaction Table66ETRKCOCompany - Key (Related Order)StringGeneric Edit50
103FF31113Lean Transaction Labor Detail34LDRKCOCompany - Key (Related Order)StringGeneric Edit50
104FF31113SPurge - Lean Transaction Labor Detail34LRRKCOCompany - Key (Related Order)StringGeneric Edit50