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

174 COLUMNS | 1 INDEXES | Print definition?910 | 44H | F44H501 TABLE

44H: Homebuilder Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F44H501SM1741Sales Master TableFiles44H: 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 SMHBMCUS, SMHBLOT, SMCSSEQ, SMACTVSEQ, SMMCU, SMHBAREA, SMCPHASE, SMBYR, SMMLTBYR, SMHBPLAN, SMHBELEV, SMSWING, SMSALLST, SMSALNXT, SMDCG, SMCONACT, SMHBSCS, SMSDJ, SMSRPDJ, SMSRDJ, SMCAPRVL, SMECDJ, SMCDJ, SMEDJ, SMCSRCD, SMCSN1, SMCSN2, SMCSN3, SMBHPRICE, SMLOTPREM, SMINCA1, SMINCA2, SMINCA3, SMUPG, SMNETBP, SMOPRV1, SMOPRV2, SMOPRV3, SMOPRV4, SMOPRV5, SMOPRV6, SMOPRV7, SMOPRV8, SMOPRV9, SMOPINCA, SMNETOPT, SMTOTSAL, SMANSM01, SMANSM02, SMANSM03, SMANSM04, SMANSM05, SMANSM06, SMANSM07, SMANSM08, SMANSM09, SMANSM10, SMCMPCT1, SMCMPCT2, SMCMPCT3, SMCMPCT4, SMCMPCT5, SMCMPCT6, SMCMPCT7, SMCMPCT8, SMCMPCT9, SMCMPCT10, SMCM1, SMCM2, SMCM3, SMCM4, SMCM5, SMCM6, SMCM7, SMCM8, SMCM9, SMCM10, SMLDR, SMLOANNUM, SMLOANTYP, SMMGA, SMINRTE, SMINRLCK, SMPXD, SMDNPT, SMEMD, SMDTKN, SMMAD, SMTAD, SMLADJ, SMCTG, SMCTGS, SMPTX, SMCTGJ, SMLRD, SMCCNVD, SMCLJ, SMCXD, SMCRD, SMCN1, SMCN2, SMLAG, SMDCAPPT, SMDCSTM, SMDCADT, SMCLT, SMTEDJ, SMTIDJ, SMTLN1, SMTLN2, SMTLN3, SMBSWD, SMBSWT, SMBAWD, SMUSD1, SMUSD2, SMUSD3, SMUSD4, SMUSD5, SMUSD6, SMUSD7, SMUSD8, SMUSD9, SMUSD10, SMUSD11, SMUSD12, SMUSD13, SMUSD14, SMUSD15, SMUSD16, SMUSD17, SMUSD18, SMUSD19, SMUSD20, SMUAMT01, SMUAMT02, SMUAMT03, SMUAMT04, SMUAMT05, SMUAMT06, SMUAMT07, SMUAMT08, SMUAMT09, SMUAMT10, SMSMC01, SMSMC02, SMSMC03, SMSMC04, SMSMC05, SMSMC06, SMSMC07, SMSMC08, SMSMC09, SMSMC10, SMUSAN01, SMUSAN02, SMUSAN03, SMUSAN04, SMUSAN05, SMHBST1, SMHBST2, SMHBST3, SMHBST4, SMHBST5, SMCRTU, SMCRTJ, SMCRTT, SMWRKSTNID, SMHBOPID, SMUPMB, SMUPMJ, SMUPMT, SMJOBN, SMPID FROM F44H501

TOP910 | 44H | F44H501 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SMHBMCUSCommunityStringGeneric Edit120 Allow NULL? 
2SMHBLOTLot NumberStringGeneric Edit40 Allow NULL? 
3SMCSSEQSequence - Current SalesStringGeneric Edit30 Allow NULL? 
4SMACTVSEQActive Sales SequenceCharacterGeneric Edit10 Allow NULL? 
5SMMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
6SMHBAREAHomeBuilder Area IDStringUDC (00 05)30 Allow NULL? 
7SMCPHASEPhaseStringGeneric Edit30 Allow NULL? 
8SMBYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
9SMMLTBYRMultiple BuyersCharacterGeneric Edit10 Allow NULL? 
10SMHBPLANPlan NumberStringGeneric Edit40 Allow NULL? 
11SMHBELEVElevationStringGeneric Edit30 Allow NULL? 
12SMSWINGSwingCharacterUDC (44H2 SW)10 Allow NULL? 
13SMSALLSTSales Activity Code - LastStringUDC (44H0 RL)30 Allow NULL? 
14SMSALNXTSales Activity Code - NextStringUDC (44H0 RL)30 Allow NULL? 
15SMDCGDate - Status ChangedDateGeneric Edit60
16SMCONACTSold at Construction ActivityStringUDC (44H0 RL)30 Allow NULL? 
17SMHBSCSSales Contract StatusStringUDC (44H5 ST)30 Allow NULL? 
18SMSDJSales Date (Julian)DateGeneric Edit60
19SMSRPDJSale Reported Date (Julian)DateGeneric Edit60
20SMSRDJSale Ratified Date (Julian)DateGeneric Edit60
21SMCAPRVLCredit Approval Date (Julian)DateGeneric Edit60
22SMECDJProjected Close Date (Julian)DateGeneric Edit60
23SMCDJClose Date (Julian)DateGeneric Edit60
24SMEDJCancel Date (Julian)DateGeneric Edit60
25SMCSRCDCancel Sale Reason CodeStringUDC (44H5 CS)30 Allow NULL? 
26SMCSN1Cancel Sale Note 1StringGeneric Edit300 Allow NULL? 
27SMCSN2Cancel Sale Note 2StringGeneric Edit300 Allow NULL? 
28SMCSN3Cancel Sale Note 3StringGeneric Edit300 Allow NULL? 
29SMBHPRICEAmount - Base House Sales PriceNumericGeneric Edit152 Allow NULL? 
30SMLOTPREMAmount - Lot PremiumNumericGeneric Edit152 Allow NULL? 
31SMINCA1Amount - Incentive 1NumericGeneric Edit152 Allow NULL? 
32SMINCA2Amount - Incentive 2NumericGeneric Edit152 Allow NULL? 
33SMINCA3Amount - Incentive 3NumericGeneric Edit152 Allow NULL? 
34SMUPGAmount - UpgradeNumericGeneric Edit152 Allow NULL? 
35SMNETBPAmount - Net Base PriceNumericGeneric Edit152 Allow NULL? 
36SMOPRV1Amount - Option Revenue 1NumericGeneric Edit152 Allow NULL? 
37SMOPRV2Amount - Option Revenue 2NumericGeneric Edit152 Allow NULL? 
38SMOPRV3Amount - Option Revenue 3NumericGeneric Edit152 Allow NULL? 
39SMOPRV4Amount - Option Revenue 4NumericGeneric Edit152 Allow NULL? 
40SMOPRV5Amount - Option Revenue 5NumericGeneric Edit152 Allow NULL? 
41SMOPRV6Amount - Option Revenue 6NumericGeneric Edit152 Allow NULL? 
42SMOPRV7Amount - Option Revenue 7NumericGeneric Edit152 Allow NULL? 
43SMOPRV8Amount - Option Revenue 8NumericGeneric Edit152 Allow NULL? 
44SMOPRV9Amount - Option Revenue 9NumericGeneric Edit152 Allow NULL? 
45SMOPINCAAmount - Option IncentiveNumericGeneric Edit152 Allow NULL? 
46SMNETOPTAmount - Net Option PriceNumericGeneric Edit152 Allow NULL? 
47SMTOTSALAmount - Total Sales PriceNumericGeneric Edit152 Allow NULL? 
48SMANSM01Address Number - Sales Master 1NumericGeneric Edit80 Allow NULL? 
49SMANSM02Address Number - Sales Master 2NumericGeneric Edit80 Allow NULL? 
50SMANSM03Address Number - Sales Master 3NumericGeneric Edit80 Allow NULL? 
51SMANSM04Address Number - Sales Master 4NumericGeneric Edit80 Allow NULL? 
52SMANSM05Address Number - Sales Master 5NumericGeneric Edit80 Allow NULL? 
53SMANSM06Address Number - Sales Master 6NumericGeneric Edit80 Allow NULL? 
54SMANSM07Address Number - Sales Master 7NumericGeneric Edit80 Allow NULL? 
55SMANSM08Address Number - Sales Master 8NumericGeneric Edit80 Allow NULL? 
56SMANSM09Address Number - Sales Master 9NumericGeneric Edit80 Allow NULL? 
57SMANSM10Address Number - Sales Master 10NumericGeneric Edit80 Allow NULL? 
58SMCMPCT1Commission Percentage 1NumericGeneric Edit53 Allow NULL? 
59SMCMPCT2Commission Percentage 2NumericGeneric Edit53 Allow NULL? 
60SMCMPCT3Commission Percentage 3NumericGeneric Edit53 Allow NULL? 
61SMCMPCT4Commission Percentage 4NumericGeneric Edit53 Allow NULL? 
62SMCMPCT5Commission Percentage 5NumericGeneric Edit53 Allow NULL? 
63SMCMPCT6Commission Percentage 6NumericGeneric Edit53 Allow NULL? 
64SMCMPCT7Commission Percentage 7NumericGeneric Edit53 Allow NULL? 
65SMCMPCT8Commission Percentage 8NumericGeneric Edit53 Allow NULL? 
66SMCMPCT9Commission Percentage 9NumericGeneric Edit53 Allow NULL? 
67SMCMPCT10Commission Percentage 10NumericGeneric Edit53 Allow NULL? 
68SMCM1Amount - Commission 1NumericGeneric Edit152 Allow NULL? 
69SMCM2Amount - Commission 2NumericGeneric Edit152 Allow NULL? 
70SMCM3Amount - Commission 3NumericGeneric Edit152 Allow NULL? 
71SMCM4Amount - Commission 4NumericGeneric Edit150 Allow NULL? 
72SMCM5Amount - Commission 5NumericGeneric Edit152 Allow NULL? 
73SMCM6Amount - Commission 6NumericGeneric Edit152 Allow NULL? 
74SMCM7Amount - Commission 7NumericGeneric Edit152 Allow NULL? 
75SMCM8Amount - Commission 8NumericGeneric Edit152 Allow NULL? 
76SMCM9Amount - Commission 9NumericGeneric Edit152 Allow NULL? 
77SMCM10Amount - Commission 10NumericGeneric Edit152 Allow NULL? 
78SMLDRLender NumberNumericGeneric Edit80 Allow NULL? 
79SMLOANNUMLoan NumberStringGeneric Edit250 Allow NULL? 
80SMLOANTYPLoan TypeStringUDC (44H5 LT)100 Allow NULL? 
81SMMGAMortage_AmountNumericGeneric Edit152 Allow NULL? 
82SMINRTEInterest RateNumericGeneric Edit154 Allow NULL? 
83SMINRLCKInterest Rate Lock DateDateGeneric Edit60
84SMPXDPoints expiration dateDateGeneric Edit60
85SMDNPTDown PaymentNumericGeneric Edit152 Allow NULL? 
86SMEMDEarnest Money DepositNumericGeneric Edit152 Allow NULL? 
87SMDTKNAmount - Deposit TakenNumericGeneric Edit152 Allow NULL? 
88SMMADMortgage Approval Date (julian)DateGeneric Edit60
89SMTADTitle Appt. DateDateGeneric Edit60
90SMLADJLoan Application DateDateGeneric Edit60
91SMCTGContingent Sale FlagCharacterGeneric Edit10 Allow NULL? 
92SMCTGSContingent Sale TypeStringGeneric Edit80 Allow NULL? 
93SMPTXProperty TextStringGeneric Edit300 Allow NULL? 
94SMCTGJContingency Effective DateDateGeneric Edit60
95SMLRDListing Receipt DateDateGeneric Edit60
96SMCCNVDContingency Converted DateDateGeneric Edit60
97SMCLJConversion Loss DateDateGeneric Edit60
98SMCXDContingency Expiration DateDateGeneric Edit60
99SMCRDContingency Release DateDateGeneric Edit60
100SMCN1Contingent Note 1StringGeneric Edit300 Allow NULL? 
101SMCN2Contingent Note 2StringGeneric Edit300 Allow NULL? 
102SMLAGListing AgentNumericGeneric Edit80 Allow NULL? 
103SMDCAPPTDesign Center AppointmentDateGeneric Edit60
104SMDCSTMDesign Center Appointment TimeStringGeneric Edit80 Allow NULL? 
105SMDCADTActual Design Center AppointmentDateGeneric Edit60
106SMCLTChange LotStringGeneric Edit40 Allow NULL? 
107SMTEDJTransfer Buyer Date (Julian)DateGeneric Edit60
108SMTIDJTransfer Buyer In Date (Julian)DateGeneric Edit60
109SMTLN1Transfer Lot Note 1StringGeneric Edit300 Allow NULL? 
110SMTLN2Transfer Lot Note 2StringGeneric Edit300 Allow NULL? 
111SMTLN3Transfer Lot Note 3StringGeneric Edit300 Allow NULL? 
112SMBSWDBuyer Scheduled Walkthru DateDateGeneric Edit60
113SMBSWTBuyer Scheduled Walkthru TimeStringGeneric Edit80 Allow NULL? 
114SMBAWDBuyer Actual Walkthru DateDateGeneric Edit60
115SMUSD1User Date 1DateGeneric Edit60
116SMUSD2User Date 2DateGeneric Edit60
117SMUSD3User Date 3DateGeneric Edit60
118SMUSD4User Date 4DateGeneric Edit60
119SMUSD5User Date 5DateGeneric Edit60
120SMUSD6User Date 6DateGeneric Edit60
121SMUSD7User Date 7DateGeneric Edit60
122SMUSD8User Date 8DateGeneric Edit60
123SMUSD9User Date 9DateGeneric Edit60
124SMUSD10User Date 10DateGeneric Edit60
125SMUSD11User Date 11DateGeneric Edit60
126SMUSD12User Date 12DateGeneric Edit60
127SMUSD13User Date 13DateGeneric Edit60
128SMUSD14User Date 14DateGeneric Edit60
129SMUSD15User Date 15DateGeneric Edit60
130SMUSD16User Date 16DateGeneric Edit60
131SMUSD17User Date 17DateGeneric Edit60
132SMUSD18User Date 18DateGeneric Edit60
133SMUSD19User Date 19DateGeneric Edit60
134SMUSD20User Date 20DateGeneric Edit60
135SMUAMT01User Defined Amount 01NumericGeneric Edit152 Allow NULL? 
136SMUAMT02User Defined Amount 02NumericGeneric Edit152 Allow NULL? 
137SMUAMT03User Defined Amount 03NumericGeneric Edit152 Allow NULL? 
138SMUAMT04User Defined Amount 04NumericGeneric Edit152 Allow NULL? 
139SMUAMT05User Defined Amount 05NumericGeneric Edit152 Allow NULL? 
140SMUAMT06User Defined Amount 06NumericGeneric Edit152 Allow NULL? 
141SMUAMT07User Defined Amount 07NumericGeneric Edit152 Allow NULL? 
142SMUAMT08User Defined Amount 08NumericGeneric Edit152 Allow NULL? 
143SMUAMT09User Defined Amount 09NumericGeneric Edit152 Allow NULL? 
144SMUAMT10User Defined Amount 10NumericGeneric Edit154 Allow NULL? 
145SMSMC01Sales Category Code 1StringUDC (44H5 01)30 Allow NULL? 
146SMSMC02Sales Category Code 2StringUDC (44H5 02)30 Allow NULL? 
147SMSMC03Sales Category Code 3StringUDC (44H5 03)30 Allow NULL? 
148SMSMC04Sales Category Code 4StringUDC (44H5 04)30 Allow NULL? 
149SMSMC05Sales Category Code 5StringUDC (44H5 05)30 Allow NULL? 
150SMSMC06Sales Category Code 6StringUDC (44H5 06)30 Allow NULL? 
151SMSMC07Sales Category Code 7StringUDC (44H5 07)30 Allow NULL? 
152SMSMC08Sales Category Code 8StringUDC (44H5 08)30 Allow NULL? 
153SMSMC09Sales Category Code 9StringUDC (44H5 09)30 Allow NULL? 
154SMSMC10Sales Category Code 10StringUDC (44H5 10)30 Allow NULL? 
155SMUSAN01Address Number User Defined 01NumericGeneric Edit80 Allow NULL? 
156SMUSAN02Address Number User Defined 02NumericGeneric Edit80 Allow NULL? 
157SMUSAN03Address Number User Defined 03NumericGeneric Edit80 Allow NULL? 
158SMUSAN04Address Number User Defined 04NumericGeneric Edit80 Allow NULL? 
159SMUSAN05Address Number User Defined 05NumericGeneric Edit80 Allow NULL? 
160SMHBST1HomeBuilder Status Code 1CharacterGeneric Edit10 Allow NULL? 
161SMHBST2HomeBuilder Status Code 2CharacterGeneric Edit10 Allow NULL? 
162SMHBST3HomeBuilder Status Code 3CharacterGeneric Edit10 Allow NULL? 
163SMHBST4HomeBuilder Status Code 4CharacterGeneric Edit10 Allow NULL? 
164SMHBST5HomeBuilder Status Code 5CharacterGeneric Edit10 Allow NULL? 
165SMCRTUCreated by userStringGeneric Edit100 Allow NULL? 
166SMCRTJDate - CreatedDateGeneric Edit60
167SMCRTTTime - CreatedNumericGeneric Edit60 Allow NULL? 
168SMWRKSTNIDOriginal Work Station IDStringGeneric Edit100 Allow NULL? 
169SMHBOPIDOriginal Program IDStringGeneric Edit100 Allow NULL? 
170SMUPMBUpdated By - UserStringGeneric Edit100 Allow NULL? 
171SMUPMJDate - UpdatedDateGeneric Edit60
172SMUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
173SMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
174SMPIDProgram IDStringGeneric Edit100 Allow NULL? 

TOP910 | 44H | F44H501 INDEXES

NumberDescription
1HBMCUS HBLOT CSSEQ(desending) (Primary/Unique)
ElementAliasDescriptionSequence
1HBMCUSCommunityAscending
2HBLOTLot NumberAscending
3CSSEQSequence - Current SalesDescending