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
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

89 columns | Print definition?920 | KIT

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP12: Fixed Assets
1F1201Asset Master File80FAKITParent (short) Item NumberNumericGeneric Edit80
2F1201PAsset Master Purge Table80FAKITParent (short) Item NumberNumericGeneric Edit80
3F1201Z1Unedited Asset Master Transactions91FAKITParent (short) Item NumberNumericGeneric Edit80
TOP13: Plant/Equipment Management
4F13017Equipment Parts List3PLKITParent (short) Item NumberNumericGeneric Edit80
TOP13E: Equipment Cost Analysis
5F1381Equipment Analysis Filters15EFKITParent (short) Item NumberNumericGeneric Edit80
TOP17: Customer Service Management
6F3112Z2Warranty Claim/Supplier Recovery processing18WLKITParent (short) Item NumberNumericGeneric Edit80
7F48164Failure Analysis Detail39KBKITParent (short) Item NumberNumericGeneric Edit80
TOP17C: Call Management
8F1790Product Family/Model Master10PMKITParent (short) Item NumberNumericGeneric Edit80
TOP30: Product Data Management
9F300210Lean Multi Level Bill of Material Header2EHKITParent (short) Item NumberNumericGeneric Edit80
10F300211Lean Multi Level Bill of Material Detail6EDKITParent (short) Item NumberNumericGeneric Edit80
11F3002Z1Bill of Material Transaction File15SZKITParent (short) Item NumberNumericGeneric Edit80
12F300311Lean Multi-Level Routing Detail File3EHKITParent (short) Item NumberNumericGeneric Edit80
13F3003TRouting Tag File - not used in B9, obsolete in B102IRKITParent (short) Item NumberNumericGeneric Edit80
14F3003Z1Routing Transactions File15SZKITParent (short) Item NumberNumericGeneric Edit80
15F30UI010Bill Of Material Work File2WFKITParent (short) Item NumberNumericGeneric Edit80
16F30UI014BOM Header Work File for BI1BHKITParent (short) Item NumberNumericGeneric Edit80
17F30UI015BOM Item Fact Work File for BI2BDKITParent (short) Item NumberNumericGeneric Edit80
18F30UI016BOM Explosion Work File for BI2BEKITParent (short) Item NumberNumericGeneric Edit80
TOP30A: Product Costing
19F30UI012Work File for Parent Child7PCKITParent (short) Item NumberNumericGeneric Edit80
TOP31: Shop Floor Control
20F3112Work Order Routing5WLKITParent (short) Item NumberNumericGeneric Edit80
21F31122Work Order Time Transactions6WTKITParent (short) Item NumberNumericGeneric Edit80
22F31122SPurge Work Order Time Transactions6WTKITParent (short) Item NumberNumericGeneric Edit80
23F31122Z1Work Order Time Transactions Unedited Transaction Table19SZKITParent (short) Item NumberNumericGeneric Edit80
24F3112SPurge Shop Floor Control Routing Instructions5WLKITParent (short) Item NumberNumericGeneric Edit80
25F3112Z1Outbound Work Order Routings18SZKITParent (short) Item NumberNumericGeneric Edit80
TOP32: Configuration Management
26F3211Configurator Segment Detail5KZKITParent (short) Item NumberNumericGeneric Edit80
27F32119Configurator Segment Detail History5KSKITParent (short) Item NumberNumericGeneric Edit80
28F3212Configurator Routings File3RCKITParent (short) Item NumberNumericGeneric Edit80
29F3215Configurator Component Table13CCKITParent (short) Item NumberNumericGeneric Edit80
30F32159Configurator Component History Table13CHKITParent (short) Item NumberNumericGeneric Edit80
31F3282Configured Item/Rules Table Cross Reference4RKKITParent (short) Item NumberNumericGeneric Edit80
32F32821Rules Table Value Definition4RLKITParent (short) Item NumberNumericGeneric Edit80
33F3290Configured Item Information1C3KITParent (short) Item NumberNumericGeneric Edit80
34F3291Configured Item Segments1KWKITParent (short) Item NumberNumericGeneric Edit80
35F3292Cross Segment Editing Rules1KUKITParent (short) Item NumberNumericGeneric Edit80
36F32921Cross Segment Editing Rules - Values2KXKITParent (short) Item NumberNumericGeneric Edit80
37F32922Cross Segment Editing Rules - Range2KVKITParent (short) Item NumberNumericGeneric Edit80
38F3293Assembly Inclusions Rules2KYKITParent (short) Item NumberNumericGeneric Edit80
39F3295Needed for upgrade from Xe and below1KSKITParent (short) Item NumberNumericGeneric Edit80
TOP33: Capacity Planning
40F33UI001Shop Floor Control Routing Instructions1WLKITParent (short) Item NumberNumericGeneric Edit80
TOP34: Requirements Planning
41F3404Co-Products Planning/Costing Table13PMKITParent (short) Item NumberNumericGeneric Edit80
42F3412MPS/MRP/DRP Lower Level Requirements File5MWKITParent (short) Item NumberNumericGeneric Edit80
TOP34A: Advanced Planning & Scheduling
43F34A120Routing Master Resource Table2N0KITParent (short) Item NumberNumericGeneric Edit80
44F34A180Routing Master Resource Set2RRKITParent (short) Item NumberNumericGeneric Edit80
45F34A190Routing Master Resource and Set XRef2RDKITParent (short) Item NumberNumericGeneric Edit80
46F34A90Last Outbound Phantom Information1PIKITParent (short) Item NumberNumericGeneric Edit80
TOP34X: In-Memory Planning Advisor
47F34X200WPlanning Details Supply/Demand Work Table72SDKITParent (short) Item NumberNumericGeneric Edit80
48F34X310WPlanning Advisor BOM Component Detail Table12PDKITParent (short) Item NumberNumericGeneric Edit80
TOP40: Inventory/OP Base
49F3002Bill of Material Master File2IXKITParent (short) Item NumberNumericGeneric Edit80
50F3003Routing Master File2IRKITParent (short) Item NumberNumericGeneric Edit80
51F3011Bill of Materials Change File2IZKITParent (short) Item NumberNumericGeneric Edit80
52F3013ECO Parts List Detail5CYKITParent (short) Item NumberNumericGeneric Edit80
53F3015Component Locator File1CQKITParent (short) Item NumberNumericGeneric Edit80
54F30UI002Bill of Material Structure Analysis Work File5IXKITParent (short) Item NumberNumericGeneric Edit80
55F30UI004Bill of Material Update Work File12WFKITParent (short) Item NumberNumericGeneric Edit80
56F30UI006Lot Tracking Work File10ILKITParent (short) Item NumberNumericGeneric Edit80
57F4013ZKit Components Batch File7KSKITParent (short) Item NumberNumericGeneric Edit80
TOP41: Inventory Management
58F4101Z1F4101 Item Master Unedited Transaction Table16SZKITParent (short) Item NumberNumericGeneric Edit80
59F4101Z1AF4101 Detail Item Master Unedited Transaction18SZKITParent (short) Item NumberNumericGeneric Edit80
60F4111Item Ledger File17ILKITParent (short) Item NumberNumericGeneric Edit80
61F41UI001Inventory Transactions Detail File35ITKITParent (short) Item NumberNumericGeneric Edit80
TOP41F: Apparel Management
62FCW48Bill of Material Association Header1BHKITParent (short) Item NumberNumericGeneric Edit80
63FCW49Bill of Material Association Detail1BDKITParent (short) Item NumberNumericGeneric Edit80
64FCW50Bill of Material Association Matrix1BXKITParent (short) Item NumberNumericGeneric Edit80
65FCW51BOM Usage1BUKITParent (short) Item NumberNumericGeneric Edit80
66FCW52Style Routing Master File1RCKITParent (short) Item NumberNumericGeneric Edit80
67FCW68Style Work Order Routings6WLKITParent (short) Item NumberNumericGeneric Edit80
68FCW86BOM Quantity Work File2WFKITParent (short) Item NumberNumericGeneric Edit80
TOP75I: India
69F75I395BER - 5 (2)3ERKITParent (short) Item NumberNumericGeneric Edit80
70F75I395TER - 5 (temp)3ERKITParent (short) Item NumberNumericGeneric Edit80
71F75I396BER-62SEKITParent (short) Item NumberNumericGeneric Edit80
72F75I396TER-6 Temp3SEKITParent (short) Item NumberNumericGeneric Edit80
TOP76B: Brazil
73F76B3010Work Table for Item/Part List - 301IPKITParent (short) Item NumberNumericGeneric Edit80
TOP76H: Chile
74F76H611Actual Item Ledger File - CHI - 41 - 76H17ALKITParent (short) Item NumberNumericGeneric Edit80
TOP89: Conversion Programs
75F3294Needed for upgrade from Xe and below1KZKITParent (short) Item NumberNumericGeneric Edit80
76F32941Needed for upgrade from Xe and below1SMKITParent (short) Item NumberNumericGeneric Edit80
77F32942Needed for upgrade from Xe and below2SGKITParent (short) Item NumberNumericGeneric Edit80
78F32943Needed for upgrade from Xe and below1KOKITParent (short) Item NumberNumericGeneric Edit80
79F32944Needed for upgrade from Xe and below1KTKITParent (short) Item NumberNumericGeneric Edit80
80F32945Needed for upgrade from Xe and below2SIKITParent (short) Item NumberNumericGeneric Edit80
81F3296Needed for upgrade from Xe and below9KRKITParent (short) Item NumberNumericGeneric Edit80
TOPF31: Lean Transactions
82FF31011TransactionID Master File14EHKITParent (short) Item NumberNumericGeneric Edit80
83FF31011SPurge - TransactionID Master File14ERKITParent (short) Item NumberNumericGeneric Edit80
84FF31111Lean Transaction Parts List6PLKITParent (short) Item NumberNumericGeneric Edit80
85FF31111SPurge - Lean Transaction Parts List6PRKITParent (short) Item NumberNumericGeneric Edit80
86FF31112Routing Transaction Table13EHKITParent (short) Item NumberNumericGeneric Edit80
87FF31112SPurge - Routing Transaction Table13ETKITParent (short) Item NumberNumericGeneric Edit80
88FF31113Lean Transaction Labor Detail7LDKITParent (short) Item NumberNumericGeneric Edit80
89FF31113SPurge - Lean Transaction Labor Detail7LRKITParent (short) Item NumberNumericGeneric Edit80