JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

45 tables910 | 46

46: Warehouse Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4142CT402Warehouse Count TransactionsExtra Features Files46: Warehouse ManagementBusiness Data
2910F4600R19915Warehouse RequestsTransaction Files46: Warehouse ManagementBusiness Data
3910F4600PUR1951Warehouse Requests - PurgedPurge Files46: Warehouse ManagementBusiness Data
4910F4601TH171Warehouse Task HeaderTransaction Files46: Warehouse ManagementBusiness Data
5910F46011IQ353Item Unit Of Measure DefinitionSecondary Master Files46: Warehouse ManagementBusiness Data
6910F46012IS131Fixed LocationsExtra Features Files46: Warehouse ManagementBusiness Data
7910F46013EQ101Carton Recommendation RulesExtra Features Files46: Warehouse ManagementBusiness Data
8910F460131SP265Standard Pack Recommendation RulesFiles46: Warehouse ManagementBusiness Data
9910F46014RG132Replenishment GroupsMaster Files46: Warehouse ManagementBusiness Data
10910F46015RR222Replenishment Information by Random RuleMaster Files46: Warehouse ManagementBusiness Data
11910F460151MS72Mixed Sequenced Packing GroupsFiles46: Warehouse Management
12910F4601PUTH201Warehouse Task Header - PurgedPurge Files46: Warehouse ManagementBusiness Data
13910F4602IF9017Location Detail InformationBalance Files46: Warehouse ManagementBusiness Data
14910F46021LQ71Location CharacteristicsExtra Features Files46: Warehouse ManagementBusiness Data
15910F46022LT191Location DimensionsMaster Files46: Warehouse ManagementBusiness Data
16910F46024LC101Location CapacityExtra Features Files46: Warehouse ManagementBusiness Data
17910F46025MQ81Maximum Putaway Quantity by ZoneExtra Features Files46: Warehouse ManagementBusiness Data
18910F46026AC62Allowed Containers by LocationExtra Features Files46: Warehouse ManagementBusiness Data
19910F46027AV175Available Space TiebreakerBalance Files46: Warehouse ManagementBusiness Data
20910F46029LP163Proximity TiebreakerBalance Files46: Warehouse ManagementBusiness Data
21910F46051LY81Fixed Replenisment ZonesExtra Features Files46: Warehouse ManagementBusiness Data
22910F46091ID332Container and Carton CodesMaster Files46: Warehouse ManagementBusiness Data
23910F46092OZ62Order GroupsConstants Files46: Warehouse ManagementBusiness Data
24910F46093EM171Process Selection RulesConstants Files46: Warehouse ManagementBusiness Data
25910F46093TJC171Process Group Tag TableFiles46: Warehouse Management
26910F46095ET321Movement InstructionsConstants Files46: Warehouse ManagementBusiness Data
27910F46095TTD201Movement Instructions Tag TableFiles46: Warehouse Management
28910F46096OU62Unit Of Measure GroupsConstants Files46: Warehouse ManagementBusiness Data
29910F46098CB193Container Bill of MaterialFiles46: Warehouse Management
30910F4611R215914Warehouse SuggestionsTransaction Files46: Warehouse ManagementBusiness Data
31910F4611PUR21581Warehouse Suggestions - PurgedPurge Files46: Warehouse ManagementBusiness Data
32910F4611Z1SZ1661Unedited Suggestion TableTransaction Files46: Warehouse ManagementBusiness Data
33910F46130R3875Putaway ReservationsTransaction Files46: Warehouse ManagementBusiness Data
34910F46130PUR3901Putaway Reservations - PurgedPurge Files46: Warehouse ManagementBusiness Data
35910F4615CR386Carton RecommendationsFiles46: Warehouse ManagementBusiness Data
36910F4620CD658Carton Detail InformationFiles46: Warehouse Management
37910F46200BR354Bulk Pick RequestsWork Files46: Warehouse ManagementBusiness Data
38910F46200PUBR371Bulk Pick Requests - PurgedPurge Files46: Warehouse ManagementBusiness Data
39910F46201CC121Carton Charge Reference SetupFiles46: Warehouse Management
40910F4622UL181Unusable Label NumbersFiles46: Warehouse Management
41910F4625LN151Label Next NumbersFiles46: Warehouse Management
42910F46821LX73Random LocationsExtra Features Files46: Warehouse ManagementBusiness Data
43910F46822RQ113Random TablesExtra Features Files46: Warehouse ManagementBusiness Data
44910F46UI15RC396Carton Recommendations - Work FileFiles46: Warehouse ManagementBusiness Data
45910F4942Z1SY522Work File for F4942Transaction Files46: Warehouse ManagementBusiness Data