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
1812F44H501HLS1841Lot Sales 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 LSHBMCUS, LSHBLOT, LSCSSEQ, LSSHSEQ, LSACTVSEQ, LSMCU, LSHBAREA, LSCPHASE, LSBYR, LSMLTBYR, LSHBPLAN, LSHBELEV, LSSWING, LSSALLST, LSSALNXT, LSDCG, LSCONACT, LSHBSCS, LSSDJ, LSSRPDJ, LSSRDJ, LSCAPRVL, LSECDJ, LSCDJ, LSEDJ, LSCSRCD, LSCSN1, LSCSN2, LSCSN3, LSBHPRICE, LSLOTPREM, LSINCA1, LSINCA2, LSINCA3, LSUPG, LSNETBP, LSOPRV1, LSOPRV2, LSOPRV3, LSOPRV4, LSOPRV5, LSOPRV6, LSOPRV7, LSOPRV8, LSOPRV9, LSOPINCA, LSNETOPT, LSTOTSAL, LSANSM01, LSANSM02, LSANSM03, LSANSM04, LSANSM05, LSANSM06, LSANSM07, LSANSM08, LSANSM09, LSANSM10, LSCMPCT1, LSCMPCT2, LSCMPCT3, LSCMPCT4, LSCMPCT5, LSCMPCT6, LSCMPCT7, LSCMPCT8, LSCMPCT9, LSCMPCT10, LSCM1, LSCM2, LSCM3, LSCM4, LSCM5, LSCM6, LSCM7, LSCM8, LSCM9, LSCM10, LSLDR, LSLOANNUM, LSLOANTYP, LSMGA, LSINRTE, LSINRLCK, LSPXD, LSDNPT, LSEMD, LSDTKN, LSMAD, LSTAD, LSLADJ, LSCTG, LSCTGS, LSPTX, LSCTGJ, LSLRD, LSCCNVD, LSCLJ, LSCXD, LSCRD, LSCN1, LSCN2, LSLAG, LSDCAPPT, LSDCSTM, LSDCADT, LSCLT, LSTEDJ, LSTIDJ, LSTLN1, LSTLN2, LSTLN3, LSBSWD, LSBSWT, LSBAWD, LSUSD1, LSUSD2, LSUSD3, LSUSD4, LSUSD5, LSUSD6, LSUSD7, LSUSD8, LSUSD9, LSUSD10, LSUSD11, LSUSD12, LSUSD13, LSUSD14, LSUSD15, LSUSD16, LSUSD17, LSUSD18, LSUSD19, LSUSD20, LSUAMT01, LSUAMT02, LSUAMT03, LSUAMT04, LSUAMT05, LSUAMT06, LSUAMT07, LSUAMT08, LSUAMT09, LSUAMT10, LSSMC01, LSSMC02, LSSMC03, LSSMC04, LSSMC05, LSSMC06, LSSMC07, LSSMC08, LSSMC09, LSSMC10, LSUSAN01, LSUSAN02, LSUSAN03, LSUSAN04, LSUSAN05, LSHBST1, LSHBST2, LSHBST3, LSHBST4, LSHBST5, LSCONLST, LSCONNXT, LSLSTATHB, LSCONSSEQ, LSCTY1, LSADDS, LSADDZ, LSLOTADD, LSLPP, LSCRTU, LSCRTJ, LSCRTT, LSWRKSTNID, LSHBOPID, LSUPMB, LSUPMJ, LSUPMT, LSJOBN, LSPID FROM F44H501H

TOP812 | 44H | F44H501H COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1LSHBMCUSCommunityStringGeneric Edit120 Allow NULL? 
2LSHBLOTLot NumberStringGeneric Edit40 Allow NULL? 
3LSCSSEQSequence - Current SalesStringGeneric Edit30 Allow NULL? 
4LSSHSEQSequence - Lot Sales HistoryStringGeneric Edit30 Allow NULL? 
5LSACTVSEQActive Sales SequenceCharacterGeneric Edit10 Allow NULL? 
6LSMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
7LSHBAREAHomeBuilder Area IDStringUDC (00 05)30 Allow NULL? 
8LSCPHASEPhaseStringGeneric Edit30 Allow NULL? 
9LSBYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
10LSMLTBYRMultiple BuyersCharacterGeneric Edit10 Allow NULL? 
11LSHBPLANPlan NumberStringGeneric Edit40 Allow NULL? 
12LSHBELEVElevationStringGeneric Edit30 Allow NULL? 
13LSSWINGSwingCharacterUDC (44H2 SW)10 Allow NULL? 
14LSSALLSTSales Activity Code - LastStringUDC (44H0 RL)30 Allow NULL? 
15LSSALNXTSales Activity Code - NextStringUDC (44H0 RL)30 Allow NULL? 
16LSDCGDate - Status ChangedDateGeneric Edit60
17LSCONACTSold at Construction ActivityStringUDC (44H0 RL)30 Allow NULL? 
18LSHBSCSSales Contract StatusStringUDC (44H5 ST)30 Allow NULL? 
19LSSDJSales Date (Julian)DateGeneric Edit60
20LSSRPDJSale Reported Date (Julian)DateGeneric Edit60
21LSSRDJSale Ratified Date (Julian)DateGeneric Edit60
22LSCAPRVLCredit Approval Date (Julian)DateGeneric Edit60
23LSECDJProjected Close Date (Julian)DateGeneric Edit60
24LSCDJClose Date (Julian)DateGeneric Edit60
25LSEDJCancel Date (Julian)DateGeneric Edit60
26LSCSRCDCancel Sale Reason CodeStringUDC (44H5 CS)30 Allow NULL? 
27LSCSN1Cancel Sale Note 1StringGeneric Edit300 Allow NULL? 
28LSCSN2Cancel Sale Note 2StringGeneric Edit300 Allow NULL? 
29LSCSN3Cancel Sale Note 3StringGeneric Edit300 Allow NULL? 
30LSBHPRICEAmount - Base House Sales PriceNumericGeneric Edit152 Allow NULL? 
31LSLOTPREMAmount - Lot PremiumNumericGeneric Edit152 Allow NULL? 
32LSINCA1Amount - Incentive 1NumericGeneric Edit152 Allow NULL? 
33LSINCA2Amount - Incentive 2NumericGeneric Edit152 Allow NULL? 
34LSINCA3Amount - Incentive 3NumericGeneric Edit152 Allow NULL? 
35LSUPGAmount - UpgradeNumericGeneric Edit152 Allow NULL? 
36LSNETBPAmount - Net Base PriceNumericGeneric Edit152 Allow NULL? 
37LSOPRV1Amount - Option Revenue 1NumericGeneric Edit152 Allow NULL? 
38LSOPRV2Amount - Option Revenue 2NumericGeneric Edit152 Allow NULL? 
39LSOPRV3Amount - Option Revenue 3NumericGeneric Edit152 Allow NULL? 
40LSOPRV4Amount - Option Revenue 4NumericGeneric Edit152 Allow NULL? 
41LSOPRV5Amount - Option Revenue 5NumericGeneric Edit152 Allow NULL? 
42LSOPRV6Amount - Option Revenue 6NumericGeneric Edit152 Allow NULL? 
43LSOPRV7Amount - Option Revenue 7NumericGeneric Edit152 Allow NULL? 
44LSOPRV8Amount - Option Revenue 8NumericGeneric Edit152 Allow NULL? 
45LSOPRV9Amount - Option Revenue 9NumericGeneric Edit152 Allow NULL? 
46LSOPINCAAmount - Option IncentiveNumericGeneric Edit152 Allow NULL? 
47LSNETOPTAmount - Net Option PriceNumericGeneric Edit152 Allow NULL? 
48LSTOTSALAmount - Total Sales PriceNumericGeneric Edit152 Allow NULL? 
49LSANSM01Address Number - Sales Master 1NumericGeneric Edit80 Allow NULL? 
50LSANSM02Address Number - Sales Master 2NumericGeneric Edit80 Allow NULL? 
51LSANSM03Address Number - Sales Master 3NumericGeneric Edit80 Allow NULL? 
52LSANSM04Address Number - Sales Master 4NumericGeneric Edit80 Allow NULL? 
53LSANSM05Address Number - Sales Master 5NumericGeneric Edit80 Allow NULL? 
54LSANSM06Address Number - Sales Master 6NumericGeneric Edit80 Allow NULL? 
55LSANSM07Address Number - Sales Master 7NumericGeneric Edit80 Allow NULL? 
56LSANSM08Address Number - Sales Master 8NumericGeneric Edit80 Allow NULL? 
57LSANSM09Address Number - Sales Master 9NumericGeneric Edit80 Allow NULL? 
58LSANSM10Address Number - Sales Master 10NumericGeneric Edit80 Allow NULL? 
59LSCMPCT1Commission Percentage 1NumericGeneric Edit53 Allow NULL? 
60LSCMPCT2Commission Percentage 2NumericGeneric Edit53 Allow NULL? 
61LSCMPCT3Commission Percentage 3NumericGeneric Edit53 Allow NULL? 
62LSCMPCT4Commission Percentage 4NumericGeneric Edit53 Allow NULL? 
63LSCMPCT5Commission Percentage 5NumericGeneric Edit53 Allow NULL? 
64LSCMPCT6Commission Percentage 6NumericGeneric Edit53 Allow NULL? 
65LSCMPCT7Commission Percentage 7NumericGeneric Edit53 Allow NULL? 
66LSCMPCT8Commission Percentage 8NumericGeneric Edit53 Allow NULL? 
67LSCMPCT9Commission Percentage 9NumericGeneric Edit53 Allow NULL? 
68LSCMPCT10Commission Percentage 10NumericGeneric Edit53 Allow NULL? 
69LSCM1Amount - Commission 1NumericGeneric Edit152 Allow NULL? 
70LSCM2Amount - Commission 2NumericGeneric Edit152 Allow NULL? 
71LSCM3Amount - Commission 3NumericGeneric Edit152 Allow NULL? 
72LSCM4Amount - Commission 4NumericGeneric Edit150 Allow NULL? 
73LSCM5Amount - Commission 5NumericGeneric Edit152 Allow NULL? 
74LSCM6Amount - Commission 6NumericGeneric Edit152 Allow NULL? 
75LSCM7Amount - Commission 7NumericGeneric Edit152 Allow NULL? 
76LSCM8Amount - Commission 8NumericGeneric Edit152 Allow NULL? 
77LSCM9Amount - Commission 9NumericGeneric Edit152 Allow NULL? 
78LSCM10Amount - Commission 10NumericGeneric Edit152 Allow NULL? 
79LSLDRLender NumberNumericGeneric Edit80 Allow NULL? 
80LSLOANNUMLoan NumberStringGeneric Edit250 Allow NULL? 
81LSLOANTYPLoan TypeStringUDC (44H5 LT)100 Allow NULL? 
82LSMGAMortage_AmountNumericGeneric Edit152 Allow NULL? 
83LSINRTEInterest RateNumericGeneric Edit154 Allow NULL? 
84LSINRLCKInterest Rate Lock DateDateGeneric Edit60
85LSPXDPoints expiration dateDateGeneric Edit60
86LSDNPTDown PaymentNumericGeneric Edit152 Allow NULL? 
87LSEMDEarnest Money DepositNumericGeneric Edit152 Allow NULL? 
88LSDTKNAmount - Deposit TakenNumericGeneric Edit152 Allow NULL? 
89LSMADMortgage Approval Date (julian)DateGeneric Edit60
90LSTADTitle Appt. DateDateGeneric Edit60
91LSLADJLoan Application DateDateGeneric Edit60
92LSCTGContingent Sale FlagCharacterGeneric Edit10 Allow NULL? 
93LSCTGSContingent Sale TypeStringGeneric Edit80 Allow NULL? 
94LSPTXProperty TextStringGeneric Edit300 Allow NULL? 
95LSCTGJContingency Effective DateDateGeneric Edit60
96LSLRDListing Receipt DateDateGeneric Edit60
97LSCCNVDContingency Converted DateDateGeneric Edit60
98LSCLJConversion Loss DateDateGeneric Edit60
99LSCXDContingency Expiration DateDateGeneric Edit60
100LSCRDContingency Release DateDateGeneric Edit60
101LSCN1Contingent Note 1StringGeneric Edit300 Allow NULL? 
102LSCN2Contingent Note 2StringGeneric Edit300 Allow NULL? 
103LSLAGListing AgentNumericGeneric Edit80 Allow NULL? 
104LSDCAPPTDesign Center AppointmentDateGeneric Edit60
105LSDCSTMDesign Center Appointment TimeStringGeneric Edit80 Allow NULL? 
106LSDCADTActual Design Center AppointmentDateGeneric Edit60
107LSCLTChange LotStringGeneric Edit40 Allow NULL? 
108LSTEDJTransfer Buyer Date (Julian)DateGeneric Edit60
109LSTIDJTransfer Buyer In Date (Julian)DateGeneric Edit60
110LSTLN1Transfer Lot Note 1StringGeneric Edit300 Allow NULL? 
111LSTLN2Transfer Lot Note 2StringGeneric Edit300 Allow NULL? 
112LSTLN3Transfer Lot Note 3StringGeneric Edit300 Allow NULL? 
113LSBSWDBuyer Scheduled Walkthru DateDateGeneric Edit60
114LSBSWTBuyer Scheduled Walkthru TimeStringGeneric Edit80 Allow NULL? 
115LSBAWDBuyer Actual Walkthru DateDateGeneric Edit60
116LSUSD1User Date 1DateGeneric Edit60
117LSUSD2User Date 2DateGeneric Edit60
118LSUSD3User Date 3DateGeneric Edit60
119LSUSD4User Date 4DateGeneric Edit60
120LSUSD5User Date 5DateGeneric Edit60
121LSUSD6User Date 6DateGeneric Edit60
122LSUSD7User Date 7DateGeneric Edit60
123LSUSD8User Date 8DateGeneric Edit60
124LSUSD9User Date 9DateGeneric Edit60
125LSUSD10User Date 10DateGeneric Edit60
126LSUSD11User Date 11DateGeneric Edit60
127LSUSD12User Date 12DateGeneric Edit60
128LSUSD13User Date 13DateGeneric Edit60
129LSUSD14User Date 14DateGeneric Edit60
130LSUSD15User Date 15DateGeneric Edit60
131LSUSD16User Date 16DateGeneric Edit60
132LSUSD17User Date 17DateGeneric Edit60
133LSUSD18User Date 18DateGeneric Edit60
134LSUSD19User Date 19DateGeneric Edit60
135LSUSD20User Date 20DateGeneric Edit60
136LSUAMT01User Defined Amount 01NumericGeneric Edit152 Allow NULL? 
137LSUAMT02User Defined Amount 02NumericGeneric Edit152 Allow NULL? 
138LSUAMT03User Defined Amount 03NumericGeneric Edit152 Allow NULL? 
139LSUAMT04User Defined Amount 04NumericGeneric Edit152 Allow NULL? 
140LSUAMT05User Defined Amount 05NumericGeneric Edit152 Allow NULL? 
141LSUAMT06User Defined Amount 06NumericGeneric Edit152 Allow NULL? 
142LSUAMT07User Defined Amount 07NumericGeneric Edit152 Allow NULL? 
143LSUAMT08User Defined Amount 08NumericGeneric Edit152 Allow NULL? 
144LSUAMT09User Defined Amount 09NumericGeneric Edit152 Allow NULL? 
145LSUAMT10User Defined Amount 10NumericGeneric Edit154 Allow NULL? 
146LSSMC01Sales Category Code 1StringUDC (44H5 01)30 Allow NULL? 
147LSSMC02Sales Category Code 2StringUDC (44H5 02)30 Allow NULL? 
148LSSMC03Sales Category Code 3StringUDC (44H5 03)30 Allow NULL? 
149LSSMC04Sales Category Code 4StringUDC (44H5 04)30 Allow NULL? 
150LSSMC05Sales Category Code 5StringUDC (44H5 05)30 Allow NULL? 
151LSSMC06Sales Category Code 6StringUDC (44H5 06)30 Allow NULL? 
152LSSMC07Sales Category Code 7StringUDC (44H5 07)30 Allow NULL? 
153LSSMC08Sales Category Code 8StringUDC (44H5 08)30 Allow NULL? 
154LSSMC09Sales Category Code 9StringUDC (44H5 09)30 Allow NULL? 
155LSSMC10Sales Category Code 10StringUDC (44H5 10)30 Allow NULL? 
156LSUSAN01Address Number User Defined 01NumericGeneric Edit80 Allow NULL? 
157LSUSAN02Address Number User Defined 02NumericGeneric Edit80 Allow NULL? 
158LSUSAN03Address Number User Defined 03NumericGeneric Edit80 Allow NULL? 
159LSUSAN04Address Number User Defined 04NumericGeneric Edit80 Allow NULL? 
160LSUSAN05Address Number User Defined 05NumericGeneric Edit80 Allow NULL? 
161LSHBST1HomeBuilder Status Code 1CharacterGeneric Edit10 Allow NULL? 
162LSHBST2HomeBuilder Status Code 2CharacterGeneric Edit10 Allow NULL? 
163LSHBST3HomeBuilder Status Code 3CharacterGeneric Edit10 Allow NULL? 
164LSHBST4HomeBuilder Status Code 4CharacterGeneric Edit10 Allow NULL? 
165LSHBST5HomeBuilder Status Code 5CharacterGeneric Edit10 Allow NULL? 
166LSCONLSTConstruction Status Code LastStringUDC (44H0 RL)30 Allow NULL? 
167LSCONNXTConstruction Status Code NextStringUDC (44H0 RL)30 Allow NULL? 
168LSLSTATHBLot Status Code - HomeBuilderCharacterUDC (44H2 LS)10 Allow NULL? 
169LSCONSSEQConstruction Sequence NumberStringGeneric Edit30 Allow NULL? 
170LSCTY1CityStringGeneric Edit250 Allow NULL? 
171LSADDSStateStringUDC (00 S)30 Allow NULL? 
172LSADDZPostal CodeStringGeneric Edit120 Allow NULL? 
173LSLOTADDLot AddressStringGeneric Edit400 Allow NULL? 
174LSLPPAmount - Lot Premium PreviousNumericGeneric Edit152 Allow NULL? 
175LSCRTUCreated by userStringGeneric Edit100 Allow NULL? 
176LSCRTJDate - CreatedDateGeneric Edit60
177LSCRTTTime - CreatedNumericGeneric Edit60 Allow NULL? 
178LSWRKSTNIDOriginal Work Station IDStringGeneric Edit100 Allow NULL? 
179LSHBOPIDOriginal Program IDStringGeneric Edit100 Allow NULL? 
180LSUPMBUpdated By - UserStringGeneric Edit100 Allow NULL? 
181LSUPMJDate - UpdatedDateGeneric Edit60
182LSUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
183LSJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
184LSPIDProgram IDStringGeneric Edit100 Allow NULL? 

TOP812 | 44H | F44H501H INDEXES

NumberDescription
1HBMCUS HBLOT CSSEQ SHSEQ (Primary/Unique)
ElementAliasDescriptionSequence
1HBMCUSCommunityAscending
2HBLOTLot NumberAscending
3CSSEQSequence - Current SalesAscending
4SHSEQSequence - Lot Sales HistoryDescending