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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

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

5 columns | Print definition?910 | CZON | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP49: Transportation Management
1F4941Shipment Routing Steps11RSCZONCarrier ZoneStringUDC100
2F4950Routing Entries14RTCZONCarrier ZoneStringUDC100
3F4951Carrier Zone Definitions2ZNCZONCarrier ZoneStringUDC100
4F4960Load Header36TMCZONCarrier ZoneStringUDC100
5F4981Freight Audit History58FHCZONCarrier ZoneStringUDC100

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

TOPUDC 49 / CF (Carrier Zone) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          .N
2EXZONE1   Zone 1N
3EXZONE10  Zone 10N
4EXZONE11  Zone 11N
5EXZONE12  Zone 12N
6EXZONE2   Zone 2N
7EXZONE3   Zone 3N
8EXZONE4   Zone 4N
9EXZONE5   Zone 5N
10EXZONE6   Zone 6N
11EXZONE7   Zone 7N
12EXZONE8   Zone 8N
13EXZONE9   Zone 9N
14LMZONE1   CorseN
15LMZONE2   Sud-OuestN
16LMZONE3   Sud-EstN
17LMZONE4   CentreN
18LMZONE5   EstN
19LMZONE6   OuestN
20LMZONE7   NordN
21WPINTZN901WP Zone 901 (Intl)N
22WPINTZN906WP Zone 906 (Intl)N
23WPINTZN907WP Zone 907 (Intl)N
24WPINTZN908WP Zone 908 (Intl)N
25WPZONE1   WP Zone 1N
26WPZONE10  WP Zone 10N
27WPZONE11  WP Zone 11N
28WPZONE12  WP Zone 12N
29WPZONE2   WP Zone 2N
30WPZONE3   WP Zone 3N
31WPZONE4   WP Zone 4N
32WPZONE5   WP Zone 5N
33WPZONE6   WP Zone 6N
34WPZONE7   WP Zone 7N
35WPZONE8   WP Zone 8N
36WPZONE9   WP Zone 9N