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

84 tables910 | 41F

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F41F02WFS1232Style End Item WorkfileFiles41F: Apparel Management
2910F41F2019AP321Sales Order Header Style Items Tag History FileFiles41F: Apparel Management
3910F41F201TAP321Sales Order Header Style Items Tag FileFiles41F: Apparel Management
4910F41F301TAP331Purchase Order Header Style Items Tag FileFiles41F: Apparel Management
5910FCW01ST83Item Structure DetailFiles41F: Apparel Management
6910FCW011LT161Item Level TypeFiles41F: Apparel Management
7910FCW02IS3010Item Structure DefinitionFiles41F: Apparel Management
8910FCW02Z1RA281FCW02 Item Structure Definition Unedited Transaction TableFiles41F: Apparel Management
9910FCW03MG331Matrix GridFiles41F: Apparel Management
10910FCW031SP331Automatic Splitting by Size DefinitionFiles41F: Apparel Management
11910FCW05CS42Collection Structure DefinitionFiles41F: Apparel Management
12910FCW06CH212Collection HeaderFiles41F: Apparel Management
13910FCW07CD123Collection DetailFiles41F: Apparel Management
14910FCW08WK271Category Codes Work FileFiles41F: Apparel Management
15910FCW09WR621Item Revisions Work FileFiles41F: Apparel Management
16910FCW10WB1291Item Branch Work FileFiles41F: Apparel Management
17910FCW103WM121Style WO Component Scrap InformationFiles41F: Apparel Management
18910FCW105WF111Fair Share Sprinkling RateFiles41F: Apparel Management
19910FCW11WP271Item Base Price File Work FileFiles41F: Apparel Management
20910FCW12WC191Item Cost File Work FileFiles41F: Apparel Management
21910FCW13WL121Item Location Work FileFiles41F: Apparel Management
22910FCW14WT201Item Master Tag Work FileFiles41F: Apparel Management
23910FCW15WF151Work File F41171Files41F: Apparel Management
24910FCW16WF71Work File F4016Files41F: Apparel Management
25910FCW17WF121Work File F41002Files41F: Apparel Management
26910FCW18WF41Work File F49075Files41F: Apparel Management
27910FCW19WF181Work File F46010Files41F: Apparel Management
28910FCW20WX1211Matrix Work FileFiles41F: Apparel Management
29910FCW21WK111Work File Confirm ShipmentsFiles41F: Apparel Management
30910FCW22WL621Lot Master Work FileFiles41F: Apparel Management
31910FCW25WO71Enter Work Order Work FileFiles41F: Apparel Management
32910FCW31LV465Proposal Order Line DetailsFiles41F: Apparel Management
33910FCW32WS251Item Shipping Information (F4908) Work FileFiles41F: Apparel Management
34910FCW33PH332Price List HeaderFiles41F: Apparel Management
35910FCW34PD302Price List DetailFiles41F: Apparel Management
36910FCW35RO52Rounding MethodsFiles41F: Apparel Management
37910FCW36RR41Rounding RulesFiles41F: Apparel Management
38910FCW38TR53Price List Exchange RateFiles41F: Apparel Management
39910FCW39AC41Priority Value for Category CodesFiles41F: Apparel Management
40910FCW40TC41Price List GenerationFiles41F: Apparel Management
41910FCW41CR261Commitment RulesFiles41F: Apparel Management
42910FCW42TD111Price List Generation-Item ExceptionFiles41F: Apparel Management
43910FCW43MO491Proposal Processing DetailsFiles41F: Apparel Management
44910FCW44FP191Proposal Order DetailsFiles41F: Apparel Management
45910FCW45OL1131Matrix Purchase Order Other LocationFiles41F: Apparel Management
46910FCW46RT41Size Weights for ProposalsFiles41F: Apparel Management
47910FCW48BH121Bill of Material Association HeaderFiles41F: Apparel Management
48910FCW49BD164Bill of Material Association DetailFiles41F: Apparel Management
49910FCW50BX732Bill of Material Association MatrixFiles41F: Apparel Management
50910FCW51BU141BOM UsageFiles41F: Apparel Management
51910FCW52RC111Style Routing Master FileFiles41F: Apparel Management
52910FCW54WB41Bill of Material Work FileFiles41F: Apparel Management
53910FCW55CM71Collection Templates HeaderFiles41F: Apparel Management
54910FCW56MD162Collection Templates DetailFiles41F: Apparel Management
55910FCW57WF391Work File Additional System Information (F4101)Files41F: Apparel Management
56910FCW58WF171Item Master - Service/Warranty Extension (F4117) Work FileFiles41F: Apparel Management
57910FCW59WF271Bulk Item Master (F41011) Work FileFiles41F: Apparel Management
58910FCW60CM51CompositionsFiles41F: Apparel Management
59910FCW61SI301Additional Style Item InformationFiles41F: Apparel Management
60910FCW62WF61Compositions (FCW60) Work FileFiles41F: Apparel Management
61910FCW63WF221Additional Style Item Information Work FileFiles41F: Apparel Management
62910FCW64WX1791WO Receipts Matrix Entry Work FileFiles41F: Apparel Management
63910FCW65OF1211Work Order Header for Style ItemsFiles41F: Apparel Management
64910FCW66CR42Work Order Detail for Style ItemsFiles41F: Apparel Management
65910FCW67WM872Style Work Order Parts ListFiles41F: Apparel Management
66910FCW68WL821Style Work Order RoutingsFiles41F: Apparel Management
67910FCW69WP121Work Order Parts List IssuesFiles41F: Apparel Management
68910FCW70CB122Supplier Price/Catalog File - HeaderFiles41F: Apparel Management
69910FCW71CB352Supplier Price/Catalog File - DetailFiles41F: Apparel Management
70910FCW83PC161Work File F43090Files41F: Apparel Management
71910FCW84TR53Exchange Rate for Outsource OperationsFiles41F: Apparel Management
72910FCW85IE352Item Cost Component Add Ons Work FileFiles41F: Apparel Management
73910FCW86WF101BOM Quantity Work FileFiles41F: Apparel Management
74910FCW87LG111Style Item Balance Purge LogFiles41F: Apparel Management
75910FCW88LG121Style Item Master Purge LogFiles41F: Apparel Management
76910FCW89WM161Work Order Inventory Issues for Style ItemsFiles41F: Apparel Management
77910FCW91C982Work File for RCW02Files41F: Apparel Management
78910FCW93ST151Copy to Outsource Operations for Style ItemsFiles41F: Apparel Management
79910FCW94WK32Restore Composition Work FileFiles41F: Apparel Management
80910FCW96WO402Material AnalysisFiles41F: Apparel Management
81910FCW961DL212Simulation Detailed Parts ListFiles41F: Apparel Management
82910FCW962CL201Simulation Consolidated Parts ListFiles41F: Apparel Management
83910FCW963AC141Adjustment CalculationFiles41F: Apparel Management
84910FCW97GM392Grouping MessagesFiles41F: Apparel Management