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?812 | DEFI | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP40: Inventory/OP Base
1F46010Item Profile11IPDEFIDefinitionStringUDC100
TOP41: Inventory Management
2F4101WItem Profile Data15IMDEFIDefinitionStringUDC100
3F4101Z1AF4101 Detail Item Master Unedited Transaction95SZDEFIDefinitionStringUDC100
TOP46: Warehouse Management
4F46021Location Characteristics4LQDEFIDefinitionStringUDC100
5F46822Random Tables3RQDEFIDefinitionStringUDC100

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

TOPUDC 46 / DF (Random Characteristic Codes) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          .N
2A         `A` Sales Items
3AVERAGE   Average Random Characteristic
4B         `B` Sales Items
5BOOMER    Explosive Item CharacteristicN
6BULK      Bulk CharacteristicN
7C         `C` Sales Items
8CASE      Case Random Characteristic
9COLD      Cold
10CONTROL   Controlled Item Characteristic
11DARK      Low Light
12DRY       Dry
13EASY      Easy Access
14EXPENSIVE Hi Value Item Characteristic
15FAST      Fast Random Characteristic
16FROZEN    Frozen Temperature Charact.
17GOOD      Good Random Characteristic
18HAZ       Hazardous
19HEAVY     Heavy Characteristic
20HIGH      High Rack Storage
21HIVALU    Hi Value Item Characteristic
22L         Large Pallet 48"x48"
23LARGE     Oversize Item Characteristic
24LEVEL1    Level 1 CharacteristicN
25LEVEL2    Level 2 CharacteristicN
26LEVEL3    Level 3 CharacteristicN
27LEVEL4    Level 4 CharacteristicN
28LEVEL5    Level 5 CharacteristicN
29LOW       Low Random Characteristic
30MID       Mid Random Characteristic
31MSDS      MSDS Sheet Storage
32PICK      Pick Random Characteristic
33Q         Quarantine
34RACK      Rack Storage
35RAND      Rand Random Characteristic
36RETURN    Returned Item CharacteristicN
37RTK       Right to Know Characteristic
38S         Small Pallet 36"x48"
39SECURE    Security RequiredN
40SLOW      Slow Random Characteristic
41STD       Standard Item Characteristic
42TALL      Tall Item Characteristic
43TOPSEL    Top Seller or Fast Mover
44UFO       Unidentified Foreign Object