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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

82 COLUMNS | 2 INDEXES | Print definition?812 | 44H | F44H301 TABLE

44H: Homebuilder Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F44H301PM822Plan MasterFiles44H: Homebuilder Management
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT PMHBMCUS, PMCPHASE, PMHBPLAN, PMHBELEV, PMHBAREA, PMBSP, PMBPP, PMSPJ, PMEXDE, PMMCUTJ, PMSCHTMPT, PMDL01, PMDL02, PMDL03, PMPMPT, PMPMPG, PMSQFEET, PMDSC1, PMDSC2, PMPLNMX, PMPLNMXRL, PMESTDISC1, PMESTDISC2, PMESTDISC3, PMOPTMGN1, PMOPTMGN2, PMOPTMGN3, PMOPTMGN4, PMOPTMGN5, PMESTOPR1, PMESTOPR2, PMESTOPR3, PMESTOPR4, PMESTOPR5, PMESTOPIN, PMESTPLANC, PMCSTAMT01, PMCSTAMT02, PMCSTAMT03, PMCSTAMT04, PMCSTAMT05, PMCSTAMT06, PMCSTAMT07, PMCSTAMT08, PMCSTAMT09, PMCSTAMT10, PMESTWKSL, PMPLC01, PMPLC02, PMPLC03, PMPLC04, PMPLC05, PMPLC06, PMPLC07, PMPLC08, PMPLC09, PMPLC10, PMPLC11, PMPLC12, PMPLC13, PMPLC14, PMPLC15, PMUSD1, PMUSD2, PMUSD3, PMUSD4, PMUSD5, PMCRTU, PMCRTJ, PMCRTT, PMWRKSTNID, PMHBOPID, PMUPMB, PMUPMJ, PMUPMT, PMJOBN, PMPID, PMHBST1, PMHBST2, PMHBST3, PMHBST4, PMHBST5 FROM F44H301

TOP812 | 44H | F44H301 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PMHBMCUSCommunityStringGeneric Edit120 Allow NULL? 
2PMCPHASEPhaseStringGeneric Edit30 Allow NULL? 
3PMHBPLANPlan NumberStringGeneric Edit40 Allow NULL? 
4PMHBELEVElevationStringGeneric Edit30 Allow NULL? 
5PMHBAREAHomeBuilder Area IDStringUDC (00 05)30 Allow NULL? 
6PMBSPAmount - Base PriceNumericGeneric Edit152 Allow NULL? 
7PMBPPAmount - Base Price PreviousNumericGeneric Edit152 Allow NULL? 
8PMSPJSales Price Effective DateDateGeneric Edit60
9PMEXDEExpiration DateDateGeneric Edit60
10PMMCUTJCost Code TemplateStringGeneric Edit120 Allow NULL? 
11PMSCHTMPTSchedule TemplateStringGeneric Edit120 Allow NULL? 
12PMDL01DescriptionStringGeneric Edit300 Allow NULL? 
13PMDL02Description 02StringGeneric Edit300 Allow NULL? 
14PMDL03Description 03StringGeneric Edit300 Allow NULL? 
15PMPMPTPlan Master Product TypeStringUDC (44H3 PT)30 Allow NULL? 
16PMPMPGPlan Master Product GroupStringUDC (44H3 PG)30 Allow NULL? 
17PMSQFEETSquare FeetNumericGeneric Edit72 Allow NULL? 
18PMDSC1DescriptionStringGeneric Edit300 Allow NULL? 
19PMDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
20PMPLNMXPlan MixNumericGeneric Edit80 Allow NULL? 
21PMPLNMXRLPlan Mix ReleaseNumericGeneric Edit80 Allow NULL? 
22PMESTDISC1Estimated Discount / Incentive1NumericGeneric Edit152 Allow NULL? 
23PMESTDISC2Estimated Discount / Incentive2NumericGeneric Edit152 Allow NULL? 
24PMESTDISC3Estimated Discount / Incentive3NumericGeneric Edit152 Allow NULL? 
25PMOPTMGN1Average Option Margin1NumericGeneric Edit31 Allow NULL? 
26PMOPTMGN2Average Option Margin2NumericGeneric Edit31 Allow NULL? 
27PMOPTMGN3Average Option Margin3NumericGeneric Edit31 Allow NULL? 
28PMOPTMGN4Average Option Margin4NumericGeneric Edit31 Allow NULL? 
29PMOPTMGN5Average Option Margin5NumericGeneric Edit31 Allow NULL? 
30PMESTOPR1Estimated Option Revenue1NumericGeneric Edit152 Allow NULL? 
31PMESTOPR2Estimated Option Revenue2NumericGeneric Edit152 Allow NULL? 
32PMESTOPR3Estimated Option Revenue3NumericGeneric Edit152 Allow NULL? 
33PMESTOPR4Estimated Option Revenue4NumericGeneric Edit152 Allow NULL? 
34PMESTOPR5Estimated Option Revenue5NumericGeneric Edit152 Allow NULL? 
35PMESTOPINAmount - Estimated Option IncentiveNumericGeneric Edit152 Allow NULL? 
36PMESTPLANCEstimated Plan CostNumericGeneric Edit152 Allow NULL? 
37PMCSTAMT01Average Other Cost 01NumericGeneric Edit152 Allow NULL? 
38PMCSTAMT02Average Other Cost 02NumericGeneric Edit152 Allow NULL? 
39PMCSTAMT03Average Other Cost 03NumericGeneric Edit152 Allow NULL? 
40PMCSTAMT04Average Other Cost 04NumericGeneric Edit152 Allow NULL? 
41PMCSTAMT05Average Other Cost 05NumericGeneric Edit152 Allow NULL? 
42PMCSTAMT06Average Other Cost 06NumericGeneric Edit152 Allow NULL? 
43PMCSTAMT07Average Other Cost 07NumericGeneric Edit152 Allow NULL? 
44PMCSTAMT08Average Other Cost 08NumericGeneric Edit152 Allow NULL? 
45PMCSTAMT09Average Other Cost 09NumericGeneric Edit152 Allow NULL? 
46PMCSTAMT10Average Other Cost 10NumericGeneric Edit152 Allow NULL? 
47PMESTWKSLEstimated Weekly SalesNumericGeneric Edit152 Allow NULL? 
48PMPLC01Plan Category 01StringUDC (44H3 01)30 Allow NULL? 
49PMPLC02Plan Category 02StringUDC (44H3 02)30 Allow NULL? 
50PMPLC03Plan Category 03StringUDC (44H3 03)30 Allow NULL? 
51PMPLC04Plan Category 04StringUDC (44H3 04)30 Allow NULL? 
52PMPLC05Plan Category 05StringUDC (44H3 05)30 Allow NULL? 
53PMPLC06Plan Category 06StringUDC (44H3 06)30 Allow NULL? 
54PMPLC07Plan Category 07StringUDC (44H3 07)30 Allow NULL? 
55PMPLC08Plan Category 08StringUDC (44H3 08)30 Allow NULL? 
56PMPLC09Plan Category 09StringUDC (44H3 09)30 Allow NULL? 
57PMPLC10Plan Category 10StringUDC (44H3 10)30 Allow NULL? 
58PMPLC11Plan Category 11StringUDC (44H3 11)100 Allow NULL? 
59PMPLC12Plan Category 12StringUDC (44H3 12)100 Allow NULL? 
60PMPLC13Plan Category 13StringUDC (44H3 13)100 Allow NULL? 
61PMPLC14Plan Category 14StringUDC (44H3 14)100 Allow NULL? 
62PMPLC15Plan Category 15StringUDC (44H3 15)100 Allow NULL? 
63PMUSD1User Date 1DateGeneric Edit60
64PMUSD2User Date 2DateGeneric Edit60
65PMUSD3User Date 3DateGeneric Edit60
66PMUSD4User Date 4DateGeneric Edit60
67PMUSD5User Date 5DateGeneric Edit60
68PMCRTUCreated by userStringGeneric Edit100 Allow NULL? 
69PMCRTJDate - CreatedDateGeneric Edit60
70PMCRTTTime - CreatedNumericGeneric Edit60 Allow NULL? 
71PMWRKSTNIDOriginal Work Station IDStringGeneric Edit100 Allow NULL? 
72PMHBOPIDOriginal Program IDStringGeneric Edit100 Allow NULL? 
73PMUPMBUpdated By - UserStringGeneric Edit100 Allow NULL? 
74PMUPMJDate - UpdatedDateGeneric Edit60
75PMUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
76PMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
77PMPIDProgram IDStringGeneric Edit100 Allow NULL? 
78PMHBST1HomeBuilder Status Code 1CharacterGeneric Edit10 Allow NULL? 
79PMHBST2HomeBuilder Status Code 2CharacterGeneric Edit10 Allow NULL? 
80PMHBST3HomeBuilder Status Code 3CharacterGeneric Edit10 Allow NULL? 
81PMHBST4HomeBuilder Status Code 4CharacterGeneric Edit10 Allow NULL? 
82PMHBST5HomeBuilder Status Code 5CharacterGeneric Edit10 Allow NULL? 

TOP812 | 44H | F44H301 INDEXES

NumberDescription
1HBMCUS CPHASE HBPLAN HBELEV (Primary/Unique)
ElementAliasDescriptionSequence
1HBMCUSCommunityAscending
2CPHASEPhaseAscending
3HBPLANPlan NumberAscending
4HBELEVElevationAscending
2CPHASE HBPLAN HBELEV
ElementAliasDescriptionSequence
1CPHASEPhaseAscending
2HBPLANPlan NumberAscending
3HBELEVElevationAscending