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
44H: Homebuilder Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F44H201HLM1261Lot Master HistoryFiles44H: 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 LMHBMCUS, LMHBLOT, LMLHSEQ, LMLOTADD, LMCTY1, LMADDS, LMADDZ, LMLOTCMT, LMCPHASE, LMMCU, LMCONSSEQ, LMHBAREA, LMHBPLAN, LMHBELEV, LMSWING, LMPSG, LMLSWVER, LMLSWPEND, LMLSTATHB, LMOSELCF, LMCONNXT, LMCONLST, LMSSACS, LMDCG, LMUSC, LMHBSCS, LMCSSEQ, LMBYR, LMMCUTJ, LMSCHTMPT, LMLGLLOT, LMHBBLOCK, LMHBTRACT, LMPARC, LMPARCT, LMBUILD, LMUNT3, LMSFTL, LMWLT, LMDPLT, LMACLT, LMMDLHF, LMSPECHF, LMBSP, LMLTP, LMLPP, LMBLDR, LMAN8CM01, LMPTDJ, LMPHD, LMCTYJ, LMPMN, LMPRD, LMCPJ, LMATFN, LMRLSDTE, LMCOMJ, LMLSRJ, LMLCSJ, LMLCCJ, LMUCSMSF, LMUSD1, LMUSD2, LMUSD3, LMUSD4, LMUSD5, LMUSD6, LMUSD7, LMUSD8, LMUSD9, LMUSD10, LMUAMT01, LMUAMT02, LMUAMT03, LMUAMT04, LMUAMT05, LMUAMT06, LMOA1, LMOA2, LMUC01, LMUC02, LMUC03, LMUC04, LMUC05, LMUC06, LMLCC01, LMLCC02, LMLCC03, LMLCC04, LMLCC05, LMLCC06, LMLCC07, LMLCC08, LMLCC09, LMLCC10, LMACCL, LMCLRH, LMROF, LMBDC, LMFSC, LMCLPK, LMDOC01, LMDOC02, LMDOC03, LMDCT01, LMDCT02, LMDCT03, LMCDJ, LMSUB, LMCO, LMRLSN, LMHBST1, LMHBST2, LMHBST3, LMHBST4, LMHBST5, LMCRTU, LMCRTJ, LMCRTT, LMWRKSTNID, LMHBOPID, LMUPMB, LMUPMJ, LMUPMT, LMJOBN, LMPID FROM F44H201H

TOP910 | 44H | F44H201H COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1LMHBMCUSCommunityStringGeneric Edit120 Allow NULL? 
2LMHBLOTLot NumberStringGeneric Edit40 Allow NULL? 
3LMLHSEQLot History Sequence NumberNumericGeneric Edit30 Allow NULL? 
4LMLOTADDLot AddressStringGeneric Edit400 Allow NULL? 
5LMCTY1CityStringGeneric Edit250 Allow NULL? 
6LMADDSStateStringUDC (00 S)30 Allow NULL? 
7LMADDZPostal CodeStringGeneric Edit120 Allow NULL? 
8LMLOTCMTLot CommentStringGeneric Edit400 Allow NULL? 
9LMCPHASEPhaseStringGeneric Edit30 Allow NULL? 
10LMMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
11LMCONSSEQConstruction Sequence NumberStringGeneric Edit30 Allow NULL? 
12LMHBAREAHomeBuilder Area IDStringUDC (00 05)30 Allow NULL? 
13LMHBPLANPlan NumberStringGeneric Edit40 Allow NULL? 
14LMHBELEVElevationStringGeneric Edit30 Allow NULL? 
15LMSWINGSwingCharacterUDC (44H2 SW)10 Allow NULL? 
16LMPSGPosting StageNumericGeneric Edit30 Allow NULL? 
17LMLSWVERLot Start Workfile VersionStringGeneric Edit100 Allow NULL? 
18LMLSWPENDLot Start Workfile Pending RecordsCharacterGeneric Edit10 Allow NULL? 
19LMLSTATHBLot Status Code - HomeBuilderCharacterUDC (44H2 LS)10 Allow NULL? 
20LMOSELCFOption Selection Changed FlagCharacterGeneric Edit10 Allow NULL? 
21LMCONNXTConstruction Status Code NextStringUDC (44H0 RL)30 Allow NULL? 
22LMCONLSTConstruction Status Code LastStringUDC (44H0 RL)30 Allow NULL? 
23LMSSACSSales Status At Construction StartStringGeneric Edit30 Allow NULL? 
24LMDCGDate - Status ChangedDateGeneric Edit60
25LMUSCUser ID - Last ChangedStringGeneric Edit100 Allow NULL? 
26LMHBSCSSales Contract StatusStringUDC (44H5 ST)30 Allow NULL? 
27LMCSSEQSequence - Current SalesStringGeneric Edit30 Allow NULL? 
28LMBYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
29LMMCUTJCost Code TemplateStringGeneric Edit120 Allow NULL? 
30LMSCHTMPTSchedule TemplateStringGeneric Edit120 Allow NULL? 
31LMLGLLOTLegal Lot NumberStringGeneric Edit120 Allow NULL? 
32LMHBBLOCKHomebuilder BlockStringGeneric Edit120 Allow NULL? 
33LMHBTRACTHomebuilder Tract NumberStringGeneric Edit120 Allow NULL? 
34LMPARCParcel NumberStringGeneric Edit200 Allow NULL? 
35LMPARCTParcel Tax NumberStringGeneric Edit200 Allow NULL? 
36LMBUILDEquipment Location BuildingStringGeneric Edit250 Allow NULL? 
37LMUNT3UnitStringGeneric Edit80 Allow NULL? 
38LMSFTLLot Square FootageNumericGeneric Edit80 Allow NULL? 
39LMWLTWidth - LotNumericGeneric Edit82 Allow NULL? 
40LMDPLTDepth - LotNumericGeneric Edit82 Allow NULL? 
41LMACLTAcres - LotNumericGeneric Edit82 Allow NULL? 
42LMMDLHFModel Home FlagCharacterGeneric Edit10 Allow NULL? 
43LMSPECHFSpec House FlagCharacterGeneric Edit10 Allow NULL? 
44LMBSPAmount - Base PriceNumericGeneric Edit152 Allow NULL? 
45LMLTPAmount - Lot PremiumNumericGeneric Edit152 Allow NULL? 
46LMLPPAmount - Lot Premium PreviousNumericGeneric Edit152 Allow NULL? 
47LMBLDRBuilder NumberNumericGeneric Edit80 Allow NULL? 
48LMAN8CM01Address Number - Community 01NumericGeneric Edit80 Allow NULL? 
49LMPTDJPlot Approval DateDateGeneric Edit60
50LMPHDPQ Hold DateDateGeneric Edit60
51LMCTYJDate at CityDateGeneric Edit60
52LMPMNPermit NumberStringGeneric Edit120 Allow NULL? 
53LMPRDPermit Received DateDateGeneric Edit60
54LMCPJCompliance Date (Julian)DateGeneric Edit60
55LMATFNDate - Actual Finish (Julian)DateGeneric Edit60
56LMRLSDTEReleased for Sale Date (Julian)DateGeneric Edit60
57LMCOMJDate - Commitment StartDateGeneric Edit60
58LMLSRJDate - Release StatusDateGeneric Edit60
59LMLCSJDate - Construction StartDateGeneric Edit60
60LMLCCJDate - Construction CompleteDateGeneric Edit60
61LMUCSMSFUpdate CSMS FlagCharacterGeneric Edit10 Allow NULL? 
62LMUSD1User Date 1DateGeneric Edit60
63LMUSD2User Date 2DateGeneric Edit60
64LMUSD3User Date 3DateGeneric Edit60
65LMUSD4User Date 4DateGeneric Edit60
66LMUSD5User Date 5DateGeneric Edit60
67LMUSD6User Date 6DateGeneric Edit60
68LMUSD7User Date 7DateGeneric Edit60
69LMUSD8User Date 8DateGeneric Edit60
70LMUSD9User Date 9DateGeneric Edit60
71LMUSD10User Date 10DateGeneric Edit60
72LMUAMT01User Defined Amount 01NumericGeneric Edit152 Allow NULL? 
73LMUAMT02User Defined Amount 02NumericGeneric Edit152 Allow NULL? 
74LMUAMT03User Defined Amount 03NumericGeneric Edit152 Allow NULL? 
75LMUAMT04User Defined Amount 04NumericGeneric Edit152 Allow NULL? 
76LMUAMT05User Defined Amount 05NumericGeneric Edit152 Allow NULL? 
77LMUAMT06User Defined Amount 06NumericGeneric Edit152 Allow NULL? 
78LMOA1Other Amount 1NumericGeneric Edit150 Allow NULL? 
79LMOA2Other Amount 2NumericGeneric Edit150 Allow NULL? 
80LMUC01User Reason Code 01CharacterGeneric Edit10 Allow NULL? 
81LMUC02User Reason Code 02CharacterGeneric Edit10 Allow NULL? 
82LMUC03User Reason Code 03CharacterGeneric Edit10 Allow NULL? 
83LMUC04User Reason Code 04CharacterGeneric Edit10 Allow NULL? 
84LMUC05User Reason Code 05CharacterGeneric Edit10 Allow NULL? 
85LMUC06User Reason Code 06CharacterGeneric Edit10 Allow NULL? 
86LMLCC01Lot Category Code 01StringUDC (44H2 01)30 Allow NULL? 
87LMLCC02Lot Category Code 02StringUDC (44H2 02)30 Allow NULL? 
88LMLCC03Lot Category Code 03StringUDC (44H2 03)30 Allow NULL? 
89LMLCC04Lot Category Code 04StringUDC (44H2 04)30 Allow NULL? 
90LMLCC05Lot Category Code 05StringUDC (44H2 05)30 Allow NULL? 
91LMLCC06Lot Category Code 06StringUDC (44H2 06)30 Allow NULL? 
92LMLCC07Lot Category Code 07StringUDC (44H2 07)30 Allow NULL? 
93LMLCC08Lot Category Code 08StringUDC (44H2 08)30 Allow NULL? 
94LMLCC09Lot Category Code 09StringUDC (44H2 09)30 Allow NULL? 
95LMLCC10Lot Category Code 10StringUDC (44H2 10)30 Allow NULL? 
96LMACCLAccent ColorStringGeneric Edit150 Allow NULL? 
97LMCLRHColor HoldCharacterGeneric Edit10 Allow NULL? 
98LMROFRoof TileStringGeneric Edit150 Allow NULL? 
99LMBDCBody ColorStringGeneric Edit150 Allow NULL? 
100LMFSCFascia ColorStringGeneric Edit150 Allow NULL? 
101LMCLPKColor PackageStringGeneric Edit100 Allow NULL? 
102LMDOC01Close Document (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
103LMDOC02Final Document (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
104LMDOC03Cost Document NumberNumericGeneric Edit80 Allow NULL? 
105LMDCT01Close Document TypeStringUDC (00 DT)20 Allow NULL? 
106LMDCT02Final Document TypeStringUDC (00 DT)20 Allow NULL? 
107LMDCT03Cost Document TypeStringUDC (00 DT)20 Allow NULL? 
108LMCDJClose Date (Julian)DateGeneric Edit60
109LMSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
110LMCOCompanyStringGeneric Edit50 Allow NULL? 
111LMRLSNReleaseStringGeneric Edit30 Allow NULL? 
112LMHBST1HomeBuilder Status Code 1CharacterGeneric Edit10 Allow NULL? 
113LMHBST2HomeBuilder Status Code 2CharacterGeneric Edit10 Allow NULL? 
114LMHBST3HomeBuilder Status Code 3CharacterGeneric Edit10 Allow NULL? 
115LMHBST4HomeBuilder Status Code 4CharacterGeneric Edit10 Allow NULL? 
116LMHBST5HomeBuilder Status Code 5CharacterGeneric Edit10 Allow NULL? 
117LMCRTUCreated by userStringGeneric Edit100 Allow NULL? 
118LMCRTJDate - CreatedDateGeneric Edit60
119LMCRTTTime - CreatedNumericGeneric Edit60 Allow NULL? 
120LMWRKSTNIDOriginal Work Station IDStringGeneric Edit100 Allow NULL? 
121LMHBOPIDOriginal Program IDStringGeneric Edit100 Allow NULL? 
122LMUPMBUpdated By - UserStringGeneric Edit100 Allow NULL? 
123LMUPMJDate - UpdatedDateGeneric Edit60
124LMUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
125LMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
126LMPIDProgram IDStringGeneric Edit100 Allow NULL? 

TOP910 | 44H | F44H201H INDEXES

NumberDescription
1HBMCUS HBLOT (Primary/Unique)
ElementAliasDescriptionSequence
1HBMCUSCommunityAscending
2HBLOTLot NumberAscending
3LHSEQLot History Sequence NumberDescending