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
10F4111ILItem Ledger File

812: Top 10 requests

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

165 columns | Print definition?920 | MMCU

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0007Workday Calendar2CZMMCUBranchStringGeneric Edit120
TOP04: Accounts Payable
2F09UI005Tax Offsets User Index29GLMMCUBranchStringGeneric Edit120
TOP12: Fixed Assets
3F1217Equipment Master Extension4WRMMCUBranchStringGeneric Edit120
4F1217PEquipment Master Extension Purge Table4WRMMCUBranchStringGeneric Edit120
5F1217Z1Unedited Equipment Tag Transactions17WRMMCUBranchStringGeneric Edit120
6F1217Z2Unedited Equipment Tag Transactions17WRMMCUBranchStringGeneric Edit120
TOP13: Plant/Equipment Management
7F13411PM Projections12RXMMCUBranchStringGeneric Edit120
TOP13E: Equipment Cost Analysis
8F1381Equipment Analysis Filters13EFMMCUBranchStringGeneric Edit120
TOP13R: Resource Assignments
9F48301Resource Assignments Constants2RXMMCUBranchStringGeneric Edit120
10F48307Resource Working Hours2RHMMCUBranchStringGeneric Edit120
11F48310Resource Master5RMMMCUBranchStringGeneric Edit120
TOP17: Customer Service Management
12F17113Assessor Defaults4ADMMCUBranchStringGeneric Edit120
13F1721Contract Detail46CDMMCUBranchStringGeneric Edit120
14F1775Claim Temporary Table27TCMMCUBranchStringGeneric Edit120
15F1791Entitlement Dates4EMMMCUBranchStringGeneric Edit120
16F3112Z2Warranty Claim/Supplier Recovery processing21WLMMCUBranchStringGeneric Edit120
17F41171Item Branch Master - Service/Warranty Extension2PBMMCUBranchStringGeneric Edit120
18F4801Z2Warranty Claim/Supplier Recovery processing34WSMMCUBranchStringGeneric Edit120
19F48164Failure Analysis Detail40KBMMCUBranchStringGeneric Edit120
TOP17C: Call Management
20F17111Base Warranty Defaults4BCMMCUBranchStringGeneric Edit120
21F1713ECOs Applied to Equipment7EEMMCUBranchStringGeneric Edit120
22F1755Case Master72ZAMMCUBranchStringGeneric Edit120
23F1790Product Family/Model Master11PMMMCUBranchStringGeneric Edit120
TOP30: Product Data Management
24F0007Z1Work Day Calendar Transaction File17SZMMCUBranchStringGeneric Edit120
25F30006Work Center Master File3IWMMCUBranchStringGeneric Edit120
26F30006Z1Work Center Transaction File16SZMMCUBranchStringGeneric Edit120
27F30008Work Center Rates File25IWMMCUBranchStringGeneric Edit120
28F300210Lean Multi Level Bill of Material Header4EHMMCUBranchStringGeneric Edit120
29F300211Lean Multi Level Bill of Material Detail8EDMMCUBranchStringGeneric Edit120
30F3002Z1Bill of Material Transaction File18SZMMCUBranchStringGeneric Edit120
31F300311Lean Multi-Level Routing Detail File4EHMMCUBranchStringGeneric Edit120
32F3003TRouting Tag File - not used in B9, obsolete in B103IRMMCUBranchStringGeneric Edit120
33F3003Z1Routing Transactions File18SZMMCUBranchStringGeneric Edit120
34F3007Work Center Resource Units4WUMMCUBranchStringGeneric Edit120
35F3009TManufacturing Constants Tag File - Needed for upgrade1IAMMCUBranchStringGeneric Edit120
36F3016Kanban Master12KMMMCUBranchStringGeneric Edit120
37F30UI008Bill of Material Comparison Work File6IJMMCUBranchStringGeneric Edit120
38F30UI014BOM Header Work File for BI2BHMMCUBranchStringGeneric Edit120
39F30UI015BOM Item Fact Work File for BI3BDMMCUBranchStringGeneric Edit120
40F30UI016BOM Explosion Work File for BI9BEMMCUBranchStringGeneric Edit120
TOP30A: Product Costing
41F300261Item Cost Component Detail4IEMMCUBranchStringGeneric Edit120
42F30UI012Work File for Parent Child6PCMMCUBranchStringGeneric Edit120
TOP31: Shop Floor Control
43F3102Production Cost33IGMMCUBranchStringGeneric Edit120
44F3102SPurge - Production Cost33IGMMCUBranchStringGeneric Edit120
45F3102WFProduction Cost Work File33IGMMCUBranchStringGeneric Edit120
46F3109Line/Item Relationship Master4IPMMCUBranchStringGeneric Edit120
47F31091Schedule Quantity Detail4IQMMCUBranchStringGeneric Edit120
48F31091SSchedule Quantity Detail Purge4IQMMCUBranchStringGeneric Edit120
49F3112Work Order Routing8WLMMCUBranchStringGeneric Edit120
50F31122Work Order Time Transactions9WTMMCUBranchStringGeneric Edit120
51F31122SPurge Work Order Time Transactions9WTMMCUBranchStringGeneric Edit120
52F31122Z1Work Order Time Transactions Unedited Transaction Table22SZMMCUBranchStringGeneric Edit120
53F3112SPurge Shop Floor Control Routing Instructions8WLMMCUBranchStringGeneric Edit120
54F3112Z1Outbound Work Order Routings21SZMMCUBranchStringGeneric Edit120
55F3114Rate Schedule Transaction File2IQMMCUBranchStringGeneric Edit120
56F3115Net Change Transaction table4NCMMCUBranchStringGeneric Edit120
57F3118Shortage Maintenance Master File1WNMMCUBranchStringGeneric Edit120
58F31UI006Line Scheduling Workbench - Work File3LSMMCUBranchStringGeneric Edit120
59F31UI427Labor Variance User Index9W1MMCUBranchStringGeneric Edit120
TOP31A: Manufacturing Accounting
60F30UI003WIP Revaluation Work File3WRMMCUBranchStringGeneric Edit120
TOP31B: Blend Management
61F31B07EUR Master File40EUMMCUBranchStringGeneric Edit120
62F31B5101Wine Premises Report Line Definition1WLMMCUBranchStringGeneric Edit120
63F31B5102Wine Premises Report Configuration1WCMMCUBranchStringGeneric Edit120
64F31B5103Wine Premises Report Operation Detail4ADMMCUBranchStringGeneric Edit120
65F31B5120Wine Premises Report Preview2WPMMCUBranchStringGeneric Edit120
66F31B60Operation Trace Track Workfile8OTMMCUBranchStringGeneric Edit120
67F31B61End Wine Lots Workfile4ELMMCUBranchStringGeneric Edit120
68F31B65Operation Header4OHMMCUBranchStringGeneric Edit120
69F31B65Z1Operations Transaction File24SZMMCUBranchStringGeneric Edit120
70F31BQAZ1Operations Quality Test Transaction File20SZMMCUBranchStringGeneric Edit120
TOP31P: Engineer To Order
71F31P11Project Quote Detail25QPMMCUBranchStringGeneric Edit120
72F31P21Cost Classification Table1CCMMCUBranchStringGeneric Edit120
TOP32: Configuration Management
73F3212Configurator Routings File4RCMMCUBranchStringGeneric Edit120
TOP33: Capacity Planning
74F3303Capacity Resource Profile5CTMMCUBranchStringGeneric Edit120
75F3312Capacity Pegging4CWMMCUBranchStringGeneric Edit120
76F33133Capacity Dates File1DCMMCUBranchStringGeneric Edit120
77F33UI001Shop Floor Control Routing Instructions4WLMMCUBranchStringGeneric Edit120
TOP34: Requirements Planning
78F3403Branch Relationships Master File1MPMMCUBranchStringGeneric Edit120
79F3404Co-Products Planning/Costing Table2PMMMCUBranchStringGeneric Edit120
80F3411MPS/MRP/DRP Message File4MMMMCUBranchStringGeneric Edit120
81F3412MPS/MRP/DRP Lower Level Requirements File6MWMMCUBranchStringGeneric Edit120
82F43213SRS Ship Dates6VPMMCUBranchStringGeneric Edit120
TOP34A: Advanced Planning & Scheduling
83F34A10APS Integration Constants49N0MMCUBranchStringGeneric Edit120
84F34A110Work Center Resource Table3N0MMCUBranchStringGeneric Edit120
85F34A120Routing Master Resource Table3N0MMCUBranchStringGeneric Edit120
86F34A160Work Center Resource Set2WRMMCUBranchStringGeneric Edit120
87F34A170Work Center Resource and Set XRef2WDMMCUBranchStringGeneric Edit120
88F34A180Routing Master Resource Set3RRMMCUBranchStringGeneric Edit120
89F34A190Routing Master Resource and Set XRef3RDMMCUBranchStringGeneric Edit120
90F34A32Star Item2GPMMCUBranchStringGeneric Edit120
91F34A40APS Integration Group Setup Table2N0MMCUBranchStringGeneric Edit120
92F34A60Last Outbound Purchase Order/Transfer Order3OBMMCUBranchStringGeneric Edit120
93F34A90Last Outbound Phantom Information2PIMMCUBranchStringGeneric Edit120
TOP34X: In-Memory Planning Advisor
94F34X200WPlanning Details Supply/Demand Work Table84SDMMCUBranchStringGeneric Edit120
95F34X310WPlanning Advisor BOM Component Detail Table15PDMMCUBranchStringGeneric Edit120
TOP37: Quality Management
96F3701Test Definitions Master File49QAMMCUBranchStringGeneric Edit120
97F3702Specifications Definitions Master File14QSMMCUBranchStringGeneric Edit120
98F3703Non-Conforming Material25QEMMCUBranchStringGeneric Edit120
99F3711Test Results81TRMMCUBranchStringGeneric Edit120
100F3711Z1Test Results Unedited Transaction Table94SZMMCUBranchStringGeneric Edit120
101F37900Certificate of Analysis (COA) Extract87TRMMCUBranchStringGeneric Edit120
102F40318Preference Profile - Quality Management55QCMMCUBranchStringGeneric Edit120
TOP40: Inventory/OP Base
103F3002Bill of Material Master File5IXMMCUBranchStringGeneric Edit120
104F30026Item Cost Component Add-Ons4IEMMCUBranchStringGeneric Edit120
105F3003Routing Master File5IRMMCUBranchStringGeneric Edit120
106F3009Job Shop Manufacturing Constants2IAMMCUBranchStringGeneric Edit120
107F3011Bill of Materials Change File5IZMMCUBranchStringGeneric Edit120
108F3013ECO Parts List Detail6CYMMCUBranchStringGeneric Edit120
109F3015Component Locator File7CQMMCUBranchStringGeneric Edit120
110F30UI002Bill of Material Structure Analysis Work File6IXMMCUBranchStringGeneric Edit120
111F30UI004Bill of Material Update Work File13WFMMCUBranchStringGeneric Edit120
112F30UI006Lot Tracking Work File9ILMMCUBranchStringGeneric Edit120
113F40051Return Material Authorization46RDMMCUBranchStringGeneric Edit120
114F40052Return Material Authorization Defaults3RVMMCUBranchStringGeneric Edit120
115F40318RPreference Resolution Ledger - Quality Management57QCMMCUBranchStringGeneric Edit120
TOP41: Inventory Management
116F4101Z1F4101 Item Master Unedited Transaction Table154SZMMCUBranchStringGeneric Edit120
117F4101Z1AF4101 Detail Item Master Unedited Transaction17SZMMCUBranchStringGeneric Edit120
118F41051Average Cost Work file3CHMMCUBranchStringGeneric Edit120
119F4111Item Ledger File18ILMMCUBranchStringGeneric Edit120
120F41UI001Inventory Transactions Detail File36ITMMCUBranchStringGeneric Edit120
TOP41F: Apparel Management
121FCW15Work File F411713WFMMCUBranchStringGeneric Edit120
122FCW48Bill of Material Association Header2BHMMCUBranchStringGeneric Edit120
123FCW49Bill of Material Association Detail2BDMMCUBranchStringGeneric Edit120
124FCW50Bill of Material Association Matrix2BXMMCUBranchStringGeneric Edit120
125FCW51BOM Usage2BUMMCUBranchStringGeneric Edit120
126FCW52Style Routing Master File2RCMMCUBranchStringGeneric Edit120
127FCW65Work Order Header for Style Items16OFMMCUBranchStringGeneric Edit120
128FCW67Style Work Order Parts List83WMMMCUBranchStringGeneric Edit120
129FCW68Style Work Order Routings9WLMMCUBranchStringGeneric Edit120
130FCW85Item Cost Component Add Ons Work File5IEMMCUBranchStringGeneric Edit120
131FCW86BOM Quantity Work File3WFMMCUBranchStringGeneric Edit120
132FCW93Copy to Outsource Operations for Style Items9STMMCUBranchStringGeneric Edit120
133FCW97Grouping Messages14GMMMCUBranchStringGeneric Edit120
TOP42X: In-Memory Sales Advisor
134F42X060WSupply Monitor Chart Work File5DCMMCUBranchStringGeneric Edit120
TOP47: Electronic Commerce
135F47122EDI Product Activity Data Detail - Inbound45MJMMCUBranchStringGeneric Edit120
136F47127EDI Product Activity Data Detail - Outbound45MJMMCUBranchStringGeneric Edit120
TOP48: Work Order Processing
137F4801Work Order Master File15WAMMCUBranchStringGeneric Edit120
138F4801SPurge - Work Order Master file15WAMMCUBranchStringGeneric Edit120
139F4801Z1Outbound Work Order Header34SYMMCUBranchStringGeneric Edit120
140F4808Order Routing Approval Master1CAMMCUBranchStringGeneric Edit120
141F48710Work Order Mass Update Template Table113WTMMCUBranchStringGeneric Edit120
142F48UI001X4801 Master Business Function Workfile18WAMMCUBranchStringGeneric Edit120
TOP75I: India
143F75I395BER - 5 (2)6ERMMCUBranchStringGeneric Edit120
144F75I395TER - 5 (temp)6ERMMCUBranchStringGeneric Edit120
145F75I396BER-610SEMMCUBranchStringGeneric Edit120
146F75I396TER-6 Temp10SEMMCUBranchStringGeneric Edit120
TOP76B: Brazil
147F76B3010Work Table for Item/Part List - 303IPMMCUBranchStringGeneric Edit120
TOP76H: Chile
148F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H25I1MMCUBranchStringGeneric Edit120
149F76H6003Indirect Costs Selection EPS F1642 - CHI - 41 - 76H26I2MMCUBranchStringGeneric Edit120
150F76H6004Item Cost Component WF - CHI - 41 - 76H5ICMMCUBranchStringGeneric Edit120
151F76H611Actual Item Ledger File - CHI - 41 - 76H18ALMMCUBranchStringGeneric Edit120
TOP79A: Greenhouse Gas Accounting
152F79A11GHG Ledger9GRMMCUBranchStringGeneric Edit120
153F79A11Z1GHG Ledger - Batch File27GLMMCUBranchStringGeneric Edit120
154F79A12GHG Ledger Audit10GRMMCUBranchStringGeneric Edit120
155F79AU11GHG Ledger Work Table12GRMMCUBranchStringGeneric Edit120
TOP89: Conversion Programs
156F49090Work Day Calendar (Used for Table Conversions ONLY)2CZMMCUBranchStringGeneric Edit120
TOPF31: Lean Transactions
157FF31010Production Master File6EHMMCUBranchStringGeneric Edit120
158FF31011TransactionID Master File30EHMMCUBranchStringGeneric Edit120
159FF31011SPurge - TransactionID Master File30ERMMCUBranchStringGeneric Edit120
160FF31111Lean Transaction Parts List7PLMMCUBranchStringGeneric Edit120
161FF31111SPurge - Lean Transaction Parts List7PRMMCUBranchStringGeneric Edit120
162FF31112Routing Transaction Table22EHMMCUBranchStringGeneric Edit120
163FF31112SPurge - Routing Transaction Table22ETMMCUBranchStringGeneric Edit120
164FF31113Lean Transaction Labor Detail11LDMMCUBranchStringGeneric Edit120
165FF31113SPurge - Lean Transaction Labor Detail11LRMMCUBranchStringGeneric Edit120