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
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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

97 columns | Print definition?812 | RKCO

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17: Customer Service Management
1F3111Z2Warranty Claim/Supplier Recovery processing27WPRKCOCompany - Key (Related Order)StringGeneric Edit50
2F3112Z2Warranty Claim/Supplier Recovery processing76WLRKCOCompany - Key (Related Order)StringGeneric Edit50
3F4801Z2Warranty Claim/Supplier Recovery processing115WSRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP17C: Call Management
4F1755Customer Call Master78ZARKCOCompany - Key (Related Order)StringGeneric Edit50
TOP31: Shop Floor Control
5F3111Work Order Parts List14WMRKCOCompany - Key (Related Order)StringGeneric Edit50
6F3111SPurge - Shop Floor Parts List14WMRKCOCompany - Key (Related Order)StringGeneric Edit50
7F3111Z1Outbound Work Order Parts List27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
8F3112Work Order Routing64WLRKCOCompany - Key (Related Order)StringGeneric Edit50
9F3112SPurge Shop Floor Control Routing Instructions64WLRKCOCompany - Key (Related Order)StringGeneric Edit50
10F3112Z1Outbound Work Order Routings76SZRKCOCompany - Key (Related Order)StringGeneric Edit50
11F3118Shortage Maintenance Master File10WNRKCOCompany - Key (Related Order)StringGeneric Edit50
12F4801SPurge - Work Order Master file96WARKCOCompany - Key (Related Order)StringGeneric Edit50
13F4801Z1Outbound Work Order Header115SYRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP31P: Engineer To Order
14F31P10Project Quote Header23PQRKCOCompany - Key (Related Order)StringGeneric Edit50
15F31P11Project Quote Detail32QPRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP34: Requirements Planning
16F3412MPS/MRP/DRP Lower Level Requirements File10MWRKCOCompany - 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
TOP42: Sales Management
27F4201Sales Order Header File10SHRKCOCompany - Key (Related Order)StringGeneric Edit50
28F42019Sales Order Header History File10SHRKCOCompany - Key (Related Order)StringGeneric Edit50
29F4211Sales Order Detail File12SDRKCOCompany - Key (Related Order)StringGeneric Edit50
30F42119Sales Order History File12SDRKCOCompany - Key (Related Order)StringGeneric Edit50
31F42199S.O. Detail Ledger File12SLRKCOCompany - Key (Related Order)StringGeneric Edit50
32F42565Invoice Print File40IWRKCOCompany - Key (Related Order)StringGeneric Edit50
33F42UI01SO Header Cache File (MBF)15ZHRKCOCompany - Key (Related Order)StringGeneric Edit50
34F42UI11SO Detail Cache File (MBF)16ZDRKCOCompany - Key (Related Order)StringGeneric Edit50
35F42UI520Pick Slips Header File34S8RKCOCompany - Key (Related Order)StringGeneric Edit50
36F42UI521Pick Slips Detail File12S9RKCOCompany - Key (Related Order)StringGeneric Edit50
TOP43: Procurement
37F4301Purchase Order Header9PHRKCOCompany - Key (Related Order)StringGeneric Edit50
38F4301ZPO Header Work File13PARKCOCompany - Key (Related Order)StringGeneric Edit50
39F4301Z1Purchase Order Header Unedited Transaction Table22SYRKCOCompany - Key (Related Order)StringGeneric Edit50
40F43080Approvals Fields Constants22PDRKCOCompany - Key (Related Order)StringGeneric Edit50
41F4311Purchase Order Detail File12PDRKCOCompany - Key (Related Order)StringGeneric Edit50
42F4311ZPurchase Order Generator File16PWRKCOCompany - Key (Related Order)StringGeneric Edit50
43F4311Z1Purchase Order Detail Unedited Transaction Table25SZRKCOCompany - Key (Related Order)StringGeneric Edit50
44F43199P.O. Detail Ledger File - Flexible Version12OLRKCOCompany - Key (Related Order)StringGeneric Edit50
45F43UI50DPO Print Detail Work File44PWRKCOCompany - Key (Related Order)StringGeneric Edit50
46F43UI50HPO Print Header Work File39PARKCOCompany - Key (Related Order)StringGeneric Edit50
TOP43E: Requisition Self Service
47F43E121eRequisition Receiver file11ERRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP43Q: Strategic Sourcing
48F43Q50Analyze Event Header15AVRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP45: Advanced Pricing
49F4079Rebate Transaction Detail22SVRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP47: Electronic Commerce
50F47011EDI Purchase Order Header - Inbound28SYRKCOCompany - Key (Related Order)StringGeneric Edit50
51F47012EDI Purchase Order Detail - Inbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
52F47016EDI Purchase Order Header - Outbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
53F47017EDI Purchase Order Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
54F47021EDI P.O. Acknowledgment Header - Inbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
55F47022EDI P.O. Acknowledgment Detail - Inbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
56F47026EDI P.O. Acknowledgment Header - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
57F47027EDI P.O. Acknowledgment Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
58F47031EDI Shipping Notice Header - Inbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
59F47032EDI Shipping Notice Detail - Inbound29SZRKCOCompany - Key (Related Order)StringGeneric Edit50
60F47037EDI Shipping Notice Detail - Outbound29SZRKCOCompany - Key (Related Order)StringGeneric Edit50
61F470371EDI Shipping Notice Detail - Outbound29SZRKCOCompany - Key (Related Order)StringGeneric Edit50
62F47046EDI Invoice Header (Sales) - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
63F47047EDI Invoice Detail (Sales) - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
64F47071EDI Receiving Advice Header - Inbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
65F47072EDI Receiving Advice Detail - Inbound27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
66F47076EDI Receiving Advice Header - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
67F47077EDI Receiving Advice Detail - Outbound27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
68F47091EDI Request for Quote Header - Inbound28SYRKCOCompany - Key (Related Order)StringGeneric Edit50
69F47092EDI Request for Quote Detail - Inbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
70F47096EDI Request for Quote Header - Outbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
71F47097EDI Request for Quote Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
72F47101EDI Response to RFQ Header - Inbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
73F47102EDI Response to RFQ Detail - Inbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
74F47106EDI Response to RFQ Header - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
75F47107EDI Response to RFQ Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
76F47131EDI Purchase Order Change Header - Inbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
77F47132EDI Purchase Order Change Detail - Inbound27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
78F47136EDI Purchase Order Change Header - Outbound24SYRKCOCompany - Key (Related Order)StringGeneric Edit50
79F47137EDI Purchase Order Change Detail - Outbound27SZRKCOCompany - Key (Related Order)StringGeneric Edit50
80F47141EDI P.O. Change Acknowledgment Header - Inbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
81F47142EDI P.O. Change Acknowledgment Detail - Inbound28SZRKCOCompany - Key (Related Order)StringGeneric Edit50
82F47146EDI P.O. Change Acknowledgment Header - Outbound26SYRKCOCompany - Key (Related Order)StringGeneric Edit50
83F47147EDI P.O. Change Acknowledgment Detail - Outbound28SZRKCOCompany - Key (Related Order)StringGeneric Edit50
84F47156EDI Shipping Schedule Header - Outbound25SYRKCOCompany - Key (Related Order)StringGeneric Edit50
85F47157EDI Shipping Schedule Detail - Outbound26SZRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP48: Work Order Processing
86F4801Work Order Master File96WARKCOCompany - Key (Related Order)StringGeneric Edit50
87F48UI001X4801 Master Business Function Workfile99WARKCOCompany - Key (Related Order)StringGeneric Edit50
TOP55: Reserved for Clients
88F55IF421Sales Order per BO12SDRKCOCompany - Key (Related Order)StringGeneric Edit50
89F55IF425Sales Order per BO - 200512SDRKCOCompany - Key (Related Order)StringGeneric Edit50
90F55W0100Correction Invoice Print - WF113SDRKCOCompany - Key (Related Order)StringGeneric Edit50
TOP89: Conversion Programs
91F43199ATemp F43199 for ERP 9.0 Upgrade12OLRKCOCompany - Key (Related Order)StringGeneric Edit50
TOPF31: Lean Transactions
92FF31111Lean Transaction Parts List21PLRKCOCompany - Key (Related Order)StringGeneric Edit50
93FF31111SPurge - Lean Transaction Parts List21PRRKCOCompany - Key (Related Order)StringGeneric Edit50
94FF31112Routing Transaction Table66EHRKCOCompany - Key (Related Order)StringGeneric Edit50
95FF31112SPurge - Routing Transaction Table66ETRKCOCompany - Key (Related Order)StringGeneric Edit50
96FF31113Lean Transaction Labor Detail34LDRKCOCompany - Key (Related Order)StringGeneric Edit50
97FF31113SPurge - Lean Transaction Labor Detail34LRRKCOCompany - Key (Related Order)StringGeneric Edit50