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

51 columns | Print definition?812 | UPMB

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP44H: Homebuilder Management
1F44H001HomeBuilder Constants25HCUPMBUpdated By - UserStringGeneric Edit100
2F44H0011HomeBuilder Constants Lot Start Documents13LDUPMBUpdated By - UserStringGeneric Edit100
3F44H002HomeBuilder Activity Rules21ARUPMBUpdated By - UserStringGeneric Edit100
4F44H0920Extended Homebuilder Data Template15STUPMBUpdated By - UserStringGeneric Edit100
5F44H0921Extended Homebuilder Data Headings14EHUPMBUpdated By - UserStringGeneric Edit100
6F44H0929Extended Homebuilder Data39EDUPMBUpdated By - UserStringGeneric Edit100
7F44H092HExtended Homebuilder Data Headings13EHUPMBUpdated By - UserStringGeneric Edit100
8F44H092TExtended Homebuilder Data Template12STUPMBUpdated By - UserStringGeneric Edit100
9F44H101Community Phase Master98CMUPMBUpdated By - UserStringGeneric Edit100
10F44H101ZHB Community Master Unedited Transaction File111SZUPMBUpdated By - UserStringGeneric Edit100
11F44H201Lot Master121LMUPMBUpdated By - UserStringGeneric Edit100
12F44H201HLot Master History122LMUPMBUpdated By - UserStringGeneric Edit100
13F44H201ZHB Lot Master Unedited Transaction File134SZUPMBUpdated By - UserStringGeneric Edit100
14F44H301Plan Master73PMUPMBUpdated By - UserStringGeneric Edit100
15F44H401Option Master79OCUPMBUpdated By - UserStringGeneric Edit100
16F44H4011Option by Community74OCUPMBUpdated By - UserStringGeneric Edit100
17F44H401WOption Master Work File85OWUPMBUpdated By - UserStringGeneric Edit100
18F44H402Option Relationships33PKUPMBUpdated By - UserStringGeneric Edit100
19F44H403Option Preferences17OPUPMBUpdated By - UserStringGeneric Edit100
20F44H4031Option Preferences - Valid Values18OVUPMBUpdated By - UserStringGeneric Edit100
21F44H4101Item Master HomeBuilder Extension18HIUPMBUpdated By - UserStringGeneric Edit100
22F44H501Sales Master Table170SMUPMBUpdated By - UserStringGeneric Edit100
23F44H501HLot Sales History180LSUPMBUpdated By - UserStringGeneric Edit100
24F44H501SSales Statistics History99SSUPMBUpdated By - UserStringGeneric Edit100
25F44H501WSales Statistics Work Table79SSUPMBUpdated By - UserStringGeneric Edit100
26F44H501ZHB Sales Master Unedited Transaction File183SZUPMBUpdated By - UserStringGeneric Edit100
27F44H511Option Selections37OSUPMBUpdated By - UserStringGeneric Edit100
28F44H511HOption Selection History39OHUPMBUpdated By - UserStringGeneric Edit100
29F44H512Option Preference Selections15PSUPMBUpdated By - UserStringGeneric Edit100
30F44H590Closing Worksheet Accounting Instructions22CIUPMBUpdated By - UserStringGeneric Edit100
31F44H591Closing Worksheet Entries25CWUPMBUpdated By - UserStringGeneric Edit100
32F44H592Closing Worksheet Extended Data Mapping14EMUPMBUpdated By - UserStringGeneric Edit100
33F44H599Closing Worksheet Data Mapping11CMUPMBUpdated By - UserStringGeneric Edit100
34F44H601Bid Header54BHUPMBUpdated By - UserStringGeneric Edit100
35F44H602Takeoff Master File27TOUPMBUpdated By - UserStringGeneric Edit100
36F44H602HTakeoff History File28THUPMBUpdated By - UserStringGeneric Edit100
37F44H603Material Item Pricing48MPUPMBUpdated By - UserStringGeneric Edit100
38F44H604Vendor Assignment25VAUPMBUpdated By - UserStringGeneric Edit100
39F44H604WVendor Assignment Workfile27VWUPMBUpdated By - UserStringGeneric Edit100
40F44H604ZHB Vendor Assignment Unedited Transaction File38SZUPMBUpdated By - UserStringGeneric Edit100
41F44H611Bid Details85BDUPMBUpdated By - UserStringGeneric Edit100
42F44H611WBid Details Work File89BWUPMBUpdated By - UserStringGeneric Edit100
43F44H711Lot Start Workfile101SWUPMBUpdated By - UserStringGeneric Edit100
44F44H711PAfter Start Purchasing55TPUPMBUpdated By - UserStringGeneric Edit100
45F44H711ZHB Lot Start Unedited Transaction File113SZUPMBUpdated By - UserStringGeneric Edit100
46F44H712Lot Start Workfile Takeoff Detail20STUPMBUpdated By - UserStringGeneric Edit100
47F44H71W1Lot Start Generation Workfile100GWUPMBUpdated By - UserStringGeneric Edit100
48F44H790Construction Milestones42HMUPMBUpdated By - UserStringGeneric Edit100
TOP76V: Venezuela
49F76V4580Retention Parameters - VEN - 04 - 76V9RTUPMBUpdated By - UserStringGeneric Edit100
50F76V4581Withholding Historical File - VEN - 0428HRUPMBUpdated By - UserStringGeneric Edit100
51F76V4583Withholdings I.S.L.R. Fee 2 - VEN - 0413TDUPMBUpdated By - UserStringGeneric Edit100