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

65 tables812 | 44H

44H: Homebuilder Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4450JD1311Lot Proceed Header (World)Files44H: Homebuilder Management
2812F4451JF321Lot Proceed Detail (World)Files44H: Homebuilder Management
3812F4452JA191Plan Master (World)Files44H: Homebuilder Management
4812F4453JB261Lot Master (World)Files44H: Homebuilder Management
5812F4454JG81Vendor Assignment (World)Files44H: Homebuilder Management
6812F4455JH131Vendor Assignment (Takeoffs) (World)Files44H: Homebuilder Management
7812F4456JI1311Lot Proceed Entry (World)Files44H: Homebuilder Management
8812F4457JJ241Takeoff File (World)Files44H: Homebuilder Management
9812F4458JK241Takeoff (World)Files44H: Homebuilder Management
10812F4459JL351Material Item Pricing (World)Files44H: Homebuilder Management
11812F4461JN321Option Master (World)Files44H: Homebuilder Management
12812F44H001HC291HomeBuilder ConstantsFiles44H: Homebuilder Management
13812F44H0011LD171HomeBuilder Constants Lot Start DocumentsFiles44H: Homebuilder Management
14812F44H002AR251HomeBuilder Activity RulesFiles44H: Homebuilder Management
15812F44H0920ST191Extended Homebuilder Data TemplateFiles44H: Homebuilder Management
16812F44H0921EH181Extended Homebuilder Data HeadingsFiles44H: Homebuilder Management
17812F44H0929ED432Extended Homebuilder DataFiles44H: Homebuilder Management
18812F44H092HEH171Extended Homebuilder Data HeadingsFiles44H: Homebuilder Management
19812F44H092TST161Extended Homebuilder Data TemplateFiles44H: Homebuilder Management
20812F44H101CM1081Community Phase MasterFiles44H: Homebuilder Management
21812F44H101ZSZ1212HB Community Master Unedited Transaction FileFiles44H: Homebuilder Management
22812F44H201LM1252Lot MasterFiles44H: Homebuilder Management
23812F44H201HLM1261Lot Master HistoryFiles44H: Homebuilder Management
24812F44H201ZSZ1384HB Lot Master Unedited Transaction FileFiles44H: Homebuilder Management
25812F44H301PM822Plan MasterFiles44H: Homebuilder Management
26812F44H401OC833Option MasterFiles44H: Homebuilder Management
27812F44H4011OC781Option by CommunityFiles44H: Homebuilder Management
28812F44H401WOW891Option Master Work FileFiles44H: Homebuilder Management
29812F44H402PK372Option RelationshipsFiles44H: Homebuilder Management
30812F44H403OP211Option PreferencesFiles44H: Homebuilder Management
31812F44H4031OV221Option Preferences - Valid ValuesFiles44H: Homebuilder Management
32812F44H4101HI221Item Master HomeBuilder ExtensionFiles44H: Homebuilder Management
33812F44H501SM1741Sales Master TableFiles44H: Homebuilder Management
34812F44H501HLS1841Lot Sales HistoryFiles44H: Homebuilder Management
35812F44H501SSS1031Sales Statistics HistoryFiles44H: Homebuilder Management
36812F44H501WSS821Sales Statistics Work TableFiles44H: Homebuilder Management
37812F44H501ZSZ1872HB Sales Master Unedited Transaction FileFiles44H: Homebuilder Management
38812F44H511OS415Option SelectionsFiles44H: Homebuilder Management
39812F44H511HOH431Option Selection HistoryFiles44H: Homebuilder Management
40812F44H512PS191Option Preference SelectionsFiles44H: Homebuilder Management
41812F44H590CI262Closing Worksheet Accounting InstructionsFiles44H: Homebuilder Management
42812F44H591CW291Closing Worksheet EntriesFiles44H: Homebuilder Management
43812F44H592EM182Closing Worksheet Extended Data MappingFiles44H: Homebuilder Management
44812F44H599CM153Closing Worksheet Data MappingFiles44H: Homebuilder Management
45812F44H601BH581Bid HeaderFiles44H: Homebuilder Management
46812F44H602TO363Takeoff Master FileFiles44H: Homebuilder Management
47812F44H602HTH372Takeoff History FileFiles44H: Homebuilder Management
48812F44H602WTS252Take Off Summary WorkfileWork Files44H: Homebuilder Management
49812F44H603MP523Material Item PricingFiles44H: Homebuilder Management
50812F44H604VA303Vendor AssignmentFiles44H: Homebuilder Management
51812F44H604WVW312Vendor Assignment WorkfileFiles44H: Homebuilder Management
52812F44H604ZSZ432HB Vendor Assignment Unedited Transaction FileFiles44H: Homebuilder Management
53812F44H611BD897Bid DetailsFiles44H: Homebuilder Management
54812F44H611WBW933Bid Details Work FileFiles44H: Homebuilder Management
55812F44H711SW10515Lot Start WorkfileFiles44H: Homebuilder Management
56812F44H711PTP593After Start PurchasingFiles44H: Homebuilder Management
57812F44H711ZSZ1172HB Lot Start Unedited Transaction FileFiles44H: Homebuilder Management
58812F44H712ST241Lot Start Workfile Takeoff DetailFiles44H: Homebuilder Management
59812F44H71W1GW1042Lot Start Generation WorkfileFiles44H: Homebuilder Management
60812F44H73W1CG846Lot Start - P.O. / Committment Generation Work FileWork Files44H: Homebuilder Management
61812F44H73W2BG142Lot Start - Budget Generation WorkfileWork Files44H: Homebuilder Management
62812F44H790HM463Construction MilestonesFiles44H: Homebuilder Management
63812F44H902WWF31Budget Creation WorkfileFiles44H: Homebuilder Management
64812F44H9905MH11HomeBuilder Integrated AddressesFiles44H: Homebuilder Management
65812F44H9911MS31Milestone Status RulesFiles44H: Homebuilder Management