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

125 COLUMNS | 2 INDEXES | Print definition?920 | 44H | F44H201 TABLE

44H: Homebuilder Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F44H201LM1252Lot 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 LMHBMCUS, LMHBLOT, 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 F44H201

TOP920 | 44H | F44H201 COLUMNS

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

TOP920 | 44H | F44H201 INDEXES

NumberDescription
1HBMCUS HBLOT (Primary/Unique)
ElementAliasDescriptionSequence
1HBMCUSCommunityAscending
2HBLOTLot NumberAscending
2HBMCUS HBPLAN HBELEV
ElementAliasDescriptionSequence
1HBMCUSCommunityAscending
2HBPLANPlan NumberAscending
3HBELEVElevationAscending