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

108 COLUMNS | 1 INDEXES | Print definition?920 | 44H | F44H101 TABLE

44H: Homebuilder Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F44H101CM1081Community Phase 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 CMHBMCUS, CMCPHASE, CMPHSENB, CMHBAREA, CMDL01, CMNBRPHS, CMPMPT, CMPMPG, CMAN8MCUS, CMAN8SOF, CMAN8COF, CMAN8CM01, CMAN8CM02, CMAN8CM03, CMAN8CM04, CMAN8CM05, CMAN8CM06, CMAN8CM07, CMAN8CM08, CMAN8CM09, CMAN8CM10, CMAN8CM11, CMAN8CM12, CMAN8CM13, CMAN8CM14, CMAN8CM15, CMAN8CM16, CMAN8CM17, CMAN8CM18, CMAN8CM19, CMAN8CM20, CMAN8UR01, CMAN8UR02, CMAN8UR03, CMAN8UR04, CMAN8UR05, CMCONSSEQ, CMNBRLOT, CMNBRSLD, CMNBRCLSD, CMNBRSTRD, CMNBRFIN, CMAOCST01, CMAOCST02, CMAOCST03, CMAOCST04, CMAOCST05, CMAOREV01, CMAOREV02, CMAOREV03, CMAOREV04, CMAOREV05, CMCSTPCT01, CMCSTPCT02, CMCSTPCT03, CMCSTPCT04, CMCSTPCT05, CMCSTPCT06, CMCSTPCT07, CMCSTPCT08, CMCSTPCT09, CMCSTPCT10, CMHBRLTPC, CMHBRLTPS, CMINCMCU, CMWAMCU, CMCWTMPT, CMUAMT01, CMUAMT02, CMUAMT03, CMUAMT04, CMUAMT05, CMUAMT06, CMUAMT07, CMUAMT08, CMUAMT09, CMUAMT10, CMF1A, CMF2A, CMF3A, CMF4A, CMF5A, CMUSD1, CMUSD2, CMUSD3, CMUSD4, CMUSD5, CMUSD6, CMUSD7, CMUSD8, CMUSD9, CMUSD10, CMCRTU, CMCRTJ, CMCRTT, CMWRKSTNID, CMHBOPID, CMUPMB, CMUPMJ, CMUPMT, CMJOBN, CMPID, CMSCHENB, CMHBST1, CMHBST2, CMHBST3, CMHBST4, CMHBST5 FROM F44H101

TOP920 | 44H | F44H101 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CMHBMCUSCommunityStringGeneric Edit120 Allow NULL? 
2CMCPHASEPhaseStringGeneric Edit30 Allow NULL? 
3CMPHSENBPhase Enabling FlagCharacterGeneric Edit10 Allow NULL? 
4CMHBAREAHomeBuilder Area IDStringUDC (00 05)30 Allow NULL? 
5CMDL01DescriptionStringGeneric Edit300 Allow NULL? 
6CMNBRPHSNumber of PhasesNumericGeneric Edit30 Allow NULL? 
7CMPMPTPlan Master Product TypeStringUDC (44H3 PT)30 Allow NULL? 
8CMPMPGPlan Master Product GroupStringUDC (44H3 PG)30 Allow NULL? 
9CMAN8MCUSAddress Number - CommunityNumericGeneric Edit80 Allow NULL? 
10CMAN8SOFAddress Number - Sales OfficeNumericGeneric Edit80 Allow NULL? 
11CMAN8COFAddress Number - Construction OfficeNumericGeneric Edit80 Allow NULL? 
12CMAN8CM01Address Number - Community 01NumericGeneric Edit80 Allow NULL? 
13CMAN8CM02Address Number - Community 02NumericGeneric Edit80 Allow NULL? 
14CMAN8CM03Address Number - Community 03NumericGeneric Edit80 Allow NULL? 
15CMAN8CM04Address Number - Community 04NumericGeneric Edit80 Allow NULL? 
16CMAN8CM05Address Number - Community 05NumericGeneric Edit80 Allow NULL? 
17CMAN8CM06Address Number - Community 06NumericGeneric Edit80 Allow NULL? 
18CMAN8CM07Address Number - Community 07NumericGeneric Edit80 Allow NULL? 
19CMAN8CM08Address Number - Community 08NumericGeneric Edit80 Allow NULL? 
20CMAN8CM09Address Number - Community 09NumericGeneric Edit80 Allow NULL? 
21CMAN8CM10Address Number - Community 10NumericGeneric Edit80 Allow NULL? 
22CMAN8CM11Address Number - Community 11NumericGeneric Edit80 Allow NULL? 
23CMAN8CM12Address Number - Community 12NumericGeneric Edit80 Allow NULL? 
24CMAN8CM13Address Number - Community 13NumericGeneric Edit80 Allow NULL? 
25CMAN8CM14Address Number - Community 14NumericGeneric Edit80 Allow NULL? 
26CMAN8CM15Address Number - Community 15NumericGeneric Edit80 Allow NULL? 
27CMAN8CM16Address Number - Community 16NumericGeneric Edit80 Allow NULL? 
28CMAN8CM17Address Number - Community 17NumericGeneric Edit80 Allow NULL? 
29CMAN8CM18Address Number - Community 18NumericGeneric Edit80 Allow NULL? 
30CMAN8CM19Address Number - Community 19NumericGeneric Edit80 Allow NULL? 
31CMAN8CM20Address Number - Community 20NumericGeneric Edit80 Allow NULL? 
32CMAN8UR01Address Number - User Reserved 01NumericGeneric Edit80 Allow NULL? 
33CMAN8UR02Address Number - User Reserved 02NumericGeneric Edit80 Allow NULL? 
34CMAN8UR03Address Number - User Reserved 03NumericGeneric Edit80 Allow NULL? 
35CMAN8UR04Address Number - User Reserved 04NumericGeneric Edit80 Allow NULL? 
36CMAN8UR05Address Number - User Reserved 05NumericGeneric Edit80 Allow NULL? 
37CMCONSSEQConstruction Sequence NumberStringGeneric Edit30 Allow NULL? 
38CMNBRLOTNumber of LotsNumericGeneric Edit80 Allow NULL? 
39CMNBRSLDNumber of Sold LotsNumericGeneric Edit80 Allow NULL? 
40CMNBRCLSDNumber of Closed LotsNumericGeneric Edit80 Allow NULL? 
41CMNBRSTRDNumber of Started LotsNumericGeneric Edit80 Allow NULL? 
42CMNBRFINNumber of Finished LotsNumericGeneric Edit80 Allow NULL? 
43CMAOCST01Average Other Cost 01NumericGeneric Edit152 Allow NULL? 
44CMAOCST02Average Other Cost 02NumericGeneric Edit152 Allow NULL? 
45CMAOCST03Average Other Cost 03NumericGeneric Edit152 Allow NULL? 
46CMAOCST04Average Other Cost 04NumericGeneric Edit152 Allow NULL? 
47CMAOCST05Average Other Cost 05NumericGeneric Edit152 Allow NULL? 
48CMAOREV01Average Other Revenue 01NumericGeneric Edit152 Allow NULL? 
49CMAOREV02Average Other Revenue 02NumericGeneric Edit152 Allow NULL? 
50CMAOREV03Average Other Revenue 03NumericGeneric Edit152 Allow NULL? 
51CMAOREV04Average Other Revenue 04NumericGeneric Edit152 Allow NULL? 
52CMAOREV05Average Other Revenue 05NumericGeneric Edit152 Allow NULL? 
53CMCSTPCT01Average Cost Percentage 1NumericGeneric Edit52 Allow NULL? 
54CMCSTPCT02Average Cost Percentage 2NumericGeneric Edit52 Allow NULL? 
55CMCSTPCT03Average Cost Percentage 3NumericGeneric Edit52 Allow NULL? 
56CMCSTPCT04Average Cost Percentage 4NumericGeneric Edit52 Allow NULL? 
57CMCSTPCT05Average Cost Percentage 5NumericGeneric Edit52 Allow NULL? 
58CMCSTPCT06Average Cost Percentage 6NumericGeneric Edit52 Allow NULL? 
59CMCSTPCT07Average Cost Percentage 7NumericGeneric Edit52 Allow NULL? 
60CMCSTPCT08Average Cost Percentage 8NumericGeneric Edit52 Allow NULL? 
61CMCSTPCT09Average Cost Percentage 9NumericGeneric Edit52 Allow NULL? 
62CMCSTPCT10Average Cost Percentage 10NumericGeneric Edit52 Allow NULL? 
63CMHBRLTPCRule Type ConstructionStringUDC (44H0 RT)30 Allow NULL? 
64CMHBRLTPSRule Type SalesStringUDC (44H0 RT)30 Allow NULL? 
65CMINCMCUIncome Statement Business UnitStringGeneric Edit120 Allow NULL? 
66CMWAMCUWarranty Business UnitStringGeneric Edit120 Allow NULL? 
67CMCWTMPTClosing Worksheet TemplateStringGeneric Edit120 Allow NULL? 
68CMUAMT01User Defined Amount 01NumericGeneric Edit152 Allow NULL? 
69CMUAMT02User Defined Amount 02NumericGeneric Edit152 Allow NULL? 
70CMUAMT03User Defined Amount 03NumericGeneric Edit152 Allow NULL? 
71CMUAMT04User Defined Amount 04NumericGeneric Edit152 Allow NULL? 
72CMUAMT05User Defined Amount 05NumericGeneric Edit152 Allow NULL? 
73CMUAMT06User Defined Amount 06NumericGeneric Edit152 Allow NULL? 
74CMUAMT07User Defined Amount 07NumericGeneric Edit152 Allow NULL? 
75CMUAMT08User Defined Amount 08NumericGeneric Edit152 Allow NULL? 
76CMUAMT09User Defined Amount 09NumericGeneric Edit152 Allow NULL? 
77CMUAMT10User Defined Amount 10NumericGeneric Edit154 Allow NULL? 
78CMF1AFuture 1 AmountNumericGeneric Edit150 Allow NULL? 
79CMF2AFuture 2 AmountNumericGeneric Edit150 Allow NULL? 
80CMF3AFuture 3 AmountNumericGeneric Edit150 Allow NULL? 
81CMF4AFuture 4 AmountNumericGeneric Edit150 Allow NULL? 
82CMF5AFuture 5 AmountNumericGeneric Edit150 Allow NULL? 
83CMUSD1User Date 1DateGeneric Edit60
84CMUSD2User Date 2DateGeneric Edit60
85CMUSD3User Date 3DateGeneric Edit60
86CMUSD4User Date 4DateGeneric Edit60
87CMUSD5User Date 5DateGeneric Edit60
88CMUSD6User Date 6DateGeneric Edit60
89CMUSD7User Date 7DateGeneric Edit60
90CMUSD8User Date 8DateGeneric Edit60
91CMUSD9User Date 9DateGeneric Edit60
92CMUSD10User Date 10DateGeneric Edit60
93CMCRTUCreated by userStringGeneric Edit100 Allow NULL? 
94CMCRTJDate - CreatedDateGeneric Edit60
95CMCRTTTime - CreatedNumericGeneric Edit60 Allow NULL? 
96CMWRKSTNIDOriginal Work Station IDStringGeneric Edit100 Allow NULL? 
97CMHBOPIDOriginal Program IDStringGeneric Edit100 Allow NULL? 
98CMUPMBUpdated By - UserStringGeneric Edit100 Allow NULL? 
99CMUPMJDate - UpdatedDateGeneric Edit60
100CMUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
101CMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
102CMPIDProgram IDStringGeneric Edit100 Allow NULL? 
103CMSCHENBScheduling EnabledCharacterGeneric Edit10 Allow NULL? 
104CMHBST1HomeBuilder Status Code 1CharacterGeneric Edit10 Allow NULL? 
105CMHBST2HomeBuilder Status Code 2CharacterGeneric Edit10 Allow NULL? 
106CMHBST3HomeBuilder Status Code 3CharacterGeneric Edit10 Allow NULL? 
107CMHBST4HomeBuilder Status Code 4CharacterGeneric Edit10 Allow NULL? 
108CMHBST5HomeBuilder Status Code 5CharacterGeneric Edit10 Allow NULL? 

TOP920 | 44H | F44H101 INDEXES

NumberDescription
1HBMCUS CPHASE (Primary/Unique)
ElementAliasDescriptionSequence
1HBMCUSCommunityAscending
2CPHASEPhaseAscending