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
3F9671SDSoftware Update Detail Table
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F41021LIItem Location File
10F03012AICustomer Master by Line of Business

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
9F4111ILItem Ledger File
10F0411RPAccounts Payable Ledger

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

39 columns | Print definition?920 | TBM | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP13: Plant/Equipment Management
1F13017Equipment Parts List14PLTBMType Bill of MaterialStringUDC30
2F13411PM Projections37RXTBMType Bill of MaterialStringUDC30
TOP17: Customer Service Management
3F3111Z2Warranty Claim/Supplier Recovery processing17WPTBMType Bill of MaterialStringUDC30
4F4801Z2Warranty Claim/Supplier Recovery processing90WSTBMType Bill of MaterialStringUDC30
5F48164Failure Analysis Detail41KBTBMType Bill of MaterialStringUDC30
TOP17C: Call Management
6F1790Product Family/Model Master12PMTBMType Bill of MaterialStringUDC30
TOP30: Product Data Management
7F300210Lean Multi Level Bill of Material Header3EHTBMType Bill of MaterialStringUDC30
8F300211Lean Multi Level Bill of Material Detail7EDTBMType Bill of MaterialStringUDC30
9F3002Z1Bill of Material Transaction File14SZTBMType Bill of MaterialStringUDC30
10F30UI014BOM Header Work File for BI4BHTBMType Bill of MaterialStringUDC30
11F30UI015BOM Item Fact Work File for BI4BDTBMType Bill of MaterialStringUDC30
12F30UI016BOM Explosion Work File for BI6BETBMType Bill of MaterialStringUDC30
TOP31: Shop Floor Control
13F3111Work Order Parts List4WMTBMType Bill of MaterialStringUDC30
14F3111SPurge - Shop Floor Parts List4WMTBMType Bill of MaterialStringUDC30
15F3111Z1Outbound Work Order Parts List17SZTBMType Bill of MaterialStringUDC30
TOP34X: In-Memory Planning Advisor
16F34X200WPlanning Details Supply/Demand Work Table61SDTBMType Bill of MaterialStringUDC30
17F34X310WPlanning Advisor BOM Component Detail Table13PDTBMType Bill of MaterialStringUDC30
TOP40: Inventory/OP Base
18F3002Bill of Material Master File1IXTBMType Bill of MaterialStringUDC30
19F30026Item Cost Component Add-Ons32IETBMType Bill of MaterialStringUDC30
20F3011Bill of Materials Change File1IZTBMType Bill of MaterialStringUDC30
21F3013ECO Parts List Detail11CYTBMType Bill of MaterialStringUDC30
22F30UI002Bill of Material Structure Analysis Work File9IXTBMType Bill of MaterialStringUDC30
23F30UI004Bill of Material Update Work File14WFTBMType Bill of MaterialStringUDC30
TOP41F: Apparel Management
24FCW48Bill of Material Association Header3BHTBMType Bill of MaterialStringUDC30
25FCW49Bill of Material Association Detail3BDTBMType Bill of MaterialStringUDC30
26FCW50Bill of Material Association Matrix3BXTBMType Bill of MaterialStringUDC30
27FCW51BOM Usage3BUTBMType Bill of MaterialStringUDC30
28FCW65Work Order Header for Style Items61OFTBMType Bill of MaterialStringUDC30
29FCW67Style Work Order Parts List10WMTBMType Bill of MaterialStringUDC30
30FCW85Item Cost Component Add Ons Work File33IETBMType Bill of MaterialStringUDC30
31FCW86BOM Quantity Work File4WFTBMType Bill of MaterialStringUDC30
TOP48: Work Order Processing
32F4801Work Order Master File71WATBMType Bill of MaterialStringUDC30
33F4801SPurge - Work Order Master file71WATBMType Bill of MaterialStringUDC30
34F4801Z1Outbound Work Order Header90SYTBMType Bill of MaterialStringUDC30
35F48710Work Order Mass Update Template Table97WTTBMType Bill of MaterialStringUDC30
36F48UI001X4801 Master Business Function Workfile74WATBMType Bill of MaterialStringUDC30
TOP76B: Brazil
37F76B3010Work Table for Item/Part List - 3014IPTBMType Bill of MaterialStringUDC30
TOP76H: Chile
38F76H6001Actual Cost Process Header - CHI - 41 - 76H14PHTBMType Bill of MaterialStringUDC30
TOPF31: Lean Transactions
39FF31010Production Master File32EHTBMType Bill of MaterialStringUDC30

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 40 / TB (Bill Type) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1       EEngineering BOM N
2       MStandard Manufacturing Bill
3       PBPlanning BOM Y
4       REPRepair N
5       RWKRework Bill
6       SPRSpare Parts Bill