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

84 tables920 | 41F

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F41F02WFS1232Style End Item WorkfileFiles41F: Apparel Management
2920F41F2019AP321Sales Order Header Style Items Tag History FileFiles41F: Apparel Management
3920F41F201TAP321Sales Order Header Style Items Tag FileFiles41F: Apparel Management
4920F41F301TAP331Purchase Order Header Style Items Tag FileFiles41F: Apparel Management
5920FCW01ST83Item Structure DetailFiles41F: Apparel Management
6920FCW011LT161Item Level TypeFiles41F: Apparel Management
7920FCW02IS3010Item Structure DefinitionFiles41F: Apparel Management
8920FCW02Z1RA281FCW02 Item Structure Definition Unedited Transaction TableFiles41F: Apparel Management
9920FCW03MG331Matrix GridFiles41F: Apparel Management
10920FCW031SP331Automatic Splitting by Size DefinitionFiles41F: Apparel Management
11920FCW05CS42Collection Structure DefinitionFiles41F: Apparel Management
12920FCW06CH212Collection HeaderFiles41F: Apparel Management
13920FCW07CD123Collection DetailFiles41F: Apparel Management
14920FCW08WK271Category Codes Work FileFiles41F: Apparel Management
15920FCW09WR621Item Revisions Work FileFiles41F: Apparel Management
16920FCW10WB1291Item Branch Work FileFiles41F: Apparel Management
17920FCW103WM121Style WO Component Scrap InformationFiles41F: Apparel Management
18920FCW105WF111Fair Share Sprinkling RateFiles41F: Apparel Management
19920FCW11WP271Item Base Price File Work FileFiles41F: Apparel Management
20920FCW12WC191Item Cost File Work FileFiles41F: Apparel Management
21920FCW13WL121Item Location Work FileFiles41F: Apparel Management
22920FCW14WT201Item Master Tag Work FileFiles41F: Apparel Management
23920FCW15WF151Work File F41171Files41F: Apparel Management
24920FCW16WF71Work File F4016Files41F: Apparel Management
25920FCW17WF121Work File F41002Files41F: Apparel Management
26920FCW18WF41Work File F49075Files41F: Apparel Management
27920FCW19WF181Work File F46010Files41F: Apparel Management
28920FCW20WX1211Matrix Work FileFiles41F: Apparel Management
29920FCW21WK111Work File Confirm ShipmentsFiles41F: Apparel Management
30920FCW22WL621Lot Master Work FileFiles41F: Apparel Management
31920FCW25WO71Enter Work Order Work FileFiles41F: Apparel Management
32920FCW31LV465Proposal Order Line DetailsFiles41F: Apparel Management
33920FCW32WS251Item Shipping Information (F4908) Work FileFiles41F: Apparel Management
34920FCW33PH332Price List HeaderFiles41F: Apparel Management
35920FCW34PD302Price List DetailFiles41F: Apparel Management
36920FCW35RO52Rounding MethodsFiles41F: Apparel Management
37920FCW36RR41Rounding RulesFiles41F: Apparel Management
38920FCW38TR53Price List Exchange RateFiles41F: Apparel Management
39920FCW39AC41Priority Value for Category CodesFiles41F: Apparel Management
40920FCW40TC41Price List GenerationFiles41F: Apparel Management
41920FCW41CR261Commitment RulesFiles41F: Apparel Management
42920FCW42TD111Price List Generation-Item ExceptionFiles41F: Apparel Management
43920FCW43MO491Proposal Processing DetailsFiles41F: Apparel Management
44920FCW44FP191Proposal Order DetailsFiles41F: Apparel Management
45920FCW45OL1131Matrix Purchase Order Other LocationFiles41F: Apparel Management
46920FCW46RT41Size Weights for ProposalsFiles41F: Apparel Management
47920FCW48BH121Bill of Material Association HeaderFiles41F: Apparel Management
48920FCW49BD164Bill of Material Association DetailFiles41F: Apparel Management
49920FCW50BX732Bill of Material Association MatrixFiles41F: Apparel Management
50920FCW51BU141BOM UsageFiles41F: Apparel Management
51920FCW52RC111Style Routing Master FileFiles41F: Apparel Management
52920FCW54WB41Bill of Material Work FileFiles41F: Apparel Management
53920FCW55CM71Collection Templates HeaderFiles41F: Apparel Management
54920FCW56MD162Collection Templates DetailFiles41F: Apparel Management
55920FCW57WF391Work File Additional System Information (F4101)Files41F: Apparel Management
56920FCW58WF171Item Master - Service/Warranty Extension (F4117) Work FileFiles41F: Apparel Management
57920FCW59WF271Bulk Item Master (F41011) Work FileFiles41F: Apparel Management
58920FCW60CM51CompositionsFiles41F: Apparel Management
59920FCW61SI301Additional Style Item InformationFiles41F: Apparel Management
60920FCW62WF61Compositions (FCW60) Work FileFiles41F: Apparel Management
61920FCW63WF221Additional Style Item Information Work FileFiles41F: Apparel Management
62920FCW64WX1491WO Receipts Matrix Entry Work FileFiles41F: Apparel Management
63920FCW65OF1211Work Order Header for Style ItemsFiles41F: Apparel Management
64920FCW66CR42Work Order Detail for Style ItemsFiles41F: Apparel Management
65920FCW67WM872Style Work Order Parts ListFiles41F: Apparel Management
66920FCW68WL821Style Work Order RoutingsFiles41F: Apparel Management
67920FCW69WP121Work Order Parts List IssuesFiles41F: Apparel Management
68920FCW70CB122Supplier Price/Catalog File - HeaderFiles41F: Apparel Management
69920FCW71CB352Supplier Price/Catalog File - DetailFiles41F: Apparel Management
70920FCW83PC161Work File F43090Files41F: Apparel Management
71920FCW84TR53Exchange Rate for Outsource OperationsFiles41F: Apparel Management
72920FCW85IE352Item Cost Component Add Ons Work FileFiles41F: Apparel Management
73920FCW86WF101BOM Quantity Work FileFiles41F: Apparel Management
74920FCW87LG111Style Item Balance Purge LogFiles41F: Apparel Management
75920FCW88LG121Style Item Master Purge LogFiles41F: Apparel Management
76920FCW89WM161Work Order Inventory Issues for Style ItemsFiles41F: Apparel Management
77920FCW91C982Work File for RCW02Files41F: Apparel Management
78920FCW93ST151Copy to Outsource Operations for Style ItemsFiles41F: Apparel Management
79920FCW94WK32Restore Composition Work FileFiles41F: Apparel Management
80920FCW96WO402Material AnalysisFiles41F: Apparel Management
81920FCW961DL212Simulation Detailed Parts ListFiles41F: Apparel Management
82920FCW962CL201Simulation Consolidated Parts ListFiles41F: Apparel Management
83920FCW963AC141Adjustment CalculationFiles41F: Apparel Management
84920FCW97GM392Grouping MessagesFiles41F: Apparel Management