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

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