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
1910F44H501SSS1031Sales Statistics 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 SSHBMCUS, SSCPHASE, SSCENTYR, SSPTYPE, SSFRP, SSHBAREA, SSSSPED, SSCO, SSTSALES, SSTCANS, SSTRANO, SSTRANI, SSTCLOSE, SSTUNITS, SSTUNITR, SSSAS, SSSANS, SSUSAS, SSUSANS, SSSAC, SSSANC, SSSTARTS, SSTBKLG, SSTSALER, SSTCANR, SSTTROR, SSTTRIR, SSCLOSER, SSTBKLGR, SSTSP, SSOPRV1, SSOPRV2, SSOPRV3, SSOPRV4, SSOPRV5, SSOPRV6, SSOPRV7, SSOPRV8, SSOPRV9, SSSABHP, SSSALP, SSSAINC, SSSAUPG, SSCLBHP, SSCLLP, SSCLINC, SSCLUPG, SSTIBHP, SSTILP, SSTIINC, SSTIUPG, SSTOBHP, SSTOLPR, SSTOINC, SSTOUPG, SSCABHP, SSCALPR, SSCAINC, SSCAUPG, SSUAMT01, SSUAMT02, SSUAMT03, SSUAMT04, SSUAMT05, SSUAMT06, SSUAMT07, SSUAMT08, SSUAMT09, SSUAMT10, SSUAMT11, SSUAMT12, SSUTOT1, SSUTOT2, SSUTOT3, SSUTOT4, SSUTOT5, SSUTOT6, SSUTOT7, SSUTOT8, SSUTOT9, SSUTOT10, SSF1A, SSF2A, SSF3A, SSF4A, SSF5A, SSF6A, SSFTOT1, SSFTOT2, SSFTOT3, SSFTOT4, SSFTOT5, SSFTOT6, SSCRTU, SSCRTJ, SSCRTT, SSWRKSTNID, SSJPID, SSUPMB, SSUPMJ, SSUPMT, SSJOBN, SSPID FROM F44H501S

TOP910 | 44H | F44H501S COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SSHBMCUSCommunityStringGeneric Edit120 Allow NULL? 
2SSCPHASEPhaseStringGeneric Edit30 Allow NULL? 
3SSCENTYRCentury/YearNumericGeneric Edit40 Allow NULL? 
4SSPTYPEString - Period TypeCharacterGeneric Edit10 Allow NULL? 
5SSFRP52 Period Number - Financial ReportingNumericGeneric Edit20 Allow NULL? 
6SSHBAREAHomeBuilder Area IDStringUDC (00 05)30 Allow NULL? 
7SSSSPEDPeriod Ending Date (Julian)DateGeneric Edit60
8SSCOCompanyStringGeneric Edit50 Allow NULL? 
9SSTSALESNumeric - Number Of SalesNumericGeneric Edit50 Allow NULL? 
10SSTCANSNumeric - Number Of CancellationsNumericGeneric Edit50 Allow NULL? 
11SSTRANONumeric - Number Of Transfers OutNumericGeneric Edit50 Allow NULL? 
12SSTRANINumeric - Number Of Transfers InNumericGeneric Edit50 Allow NULL? 
13SSTCLOSENumeric - Number Of ClosingsNumericGeneric Edit50 Allow NULL? 
14SSTUNITSNumeric - Number Of UnitsNumericGeneric Edit50 Allow NULL? 
15SSTUNITRNumeric - Units Released for SaleNumericGeneric Edit50 Allow NULL? 
16SSSASNumeric - Sold and StartedNumericGeneric Edit50 Allow NULL? 
17SSSANSNumeric - Sold and Not StartedNumericGeneric Edit50 Allow NULL? 
18SSUSASNumeric - Unsold and StartedNumericGeneric Edit50 Allow NULL? 
19SSUSANSNumeric - Unsold and Not StartedNumericGeneric Edit50 Allow NULL? 
20SSSACNumeric - Sold and CompletedNumericGeneric Edit50 Allow NULL? 
21SSSANCNumeric - Sold and not CompletedNumericGeneric Edit50 Allow NULL? 
22SSSTARTSNumeric - Construction StartsNumericGeneric Edit50 Allow NULL? 
23SSTBKLGNumeric - TotalBacklogNumericGeneric Edit50 Allow NULL? 
24SSTSALERAmount - Total Gross Sales RevenueNumericGeneric Edit152 Allow NULL? 
25SSTCANRAmount - Cancellation Revenue LossNumericGeneric Edit152 Allow NULL? 
26SSTTRORAmount - Transfer Out Revenue LossNumericGeneric Edit152 Allow NULL? 
27SSTTRIRAmount - Tansfer In Revenue GainNumericGeneric Edit152 Allow NULL? 
28SSCLOSERAmount - Closing RevenueNumericGeneric Edit152 Allow NULL? 
29SSTBKLGRAmount - Backlog RevenueNumericGeneric Edit152 Allow NULL? 
30SSTSPAmount - Option Sales PriceNumericGeneric Edit152 Allow NULL? 
31SSOPRV1Amount - Option Revenue 1NumericGeneric Edit152 Allow NULL? 
32SSOPRV2Amount - Option Revenue 2NumericGeneric Edit152 Allow NULL? 
33SSOPRV3Amount - Option Revenue 3NumericGeneric Edit152 Allow NULL? 
34SSOPRV4Amount - Option Revenue 4NumericGeneric Edit152 Allow NULL? 
35SSOPRV5Amount - Option Revenue 5NumericGeneric Edit152 Allow NULL? 
36SSOPRV6Amount - Option Revenue 6NumericGeneric Edit152 Allow NULL? 
37SSOPRV7Amount - Option Revenue 7NumericGeneric Edit152 Allow NULL? 
38SSOPRV8Amount - Option Revenue 8NumericGeneric Edit152 Allow NULL? 
39SSOPRV9Amount - Option Revenue 9NumericGeneric Edit152 Allow NULL? 
40SSSABHPAmount - Sale Base House PriceNumericGeneric Edit152 Allow NULL? 
41SSSALPAmount - Sale Lot PremiumNumericGeneric Edit152 Allow NULL? 
42SSSAINCAmount - Sale IncentiveNumericGeneric Edit152 Allow NULL? 
43SSSAUPGAmount - Sale UpgradeNumericGeneric Edit152 Allow NULL? 
44SSCLBHPAmount - Close Base House PriceNumericGeneric Edit152 Allow NULL? 
45SSCLLPAmount - Close Lot PremiumNumericGeneric Edit152 Allow NULL? 
46SSCLINCAmount - Close IncentiveNumericGeneric Edit152 Allow NULL? 
47SSCLUPGAmount - Close UpgradeNumericGeneric Edit152 Allow NULL? 
48SSTIBHPAmount - Transfer In Base House PriceNumericGeneric Edit152 Allow NULL? 
49SSTILPAmount - Transfer In Lot PremiumNumericGeneric Edit152 Allow NULL? 
50SSTIINCAmount - Transfer In IncentiveNumericGeneric Edit152 Allow NULL? 
51SSTIUPGAmount - Transfer In UpgradeNumericGeneric Edit152 Allow NULL? 
52SSTOBHPAmount - Transfer Out Base House PriceNumericGeneric Edit152 Allow NULL? 
53SSTOLPRAmount - Transfer Out Lot PremiumNumericGeneric Edit152 Allow NULL? 
54SSTOINCAmount - Transfer Out IncentiveNumericGeneric Edit152 Allow NULL? 
55SSTOUPGAmount - Transfer Out UpgradeNumericGeneric Edit152 Allow NULL? 
56SSCABHPAmount - Cancellation Base House PriceNumericGeneric Edit152 Allow NULL? 
57SSCALPRAmount - Cancellation Lot PremiumNumericGeneric Edit152 Allow NULL? 
58SSCAINCAmount - Cancellation IncentiveNumericGeneric Edit152 Allow NULL? 
59SSCAUPGAmount - Cancellation UpgradeNumericGeneric Edit152 Allow NULL? 
60SSUAMT01User Defined Amount 01NumericGeneric Edit152 Allow NULL? 
61SSUAMT02User Defined Amount 02NumericGeneric Edit152 Allow NULL? 
62SSUAMT03User Defined Amount 03NumericGeneric Edit152 Allow NULL? 
63SSUAMT04User Defined Amount 04NumericGeneric Edit152 Allow NULL? 
64SSUAMT05User Defined Amount 05NumericGeneric Edit152 Allow NULL? 
65SSUAMT06User Defined Amount 06NumericGeneric Edit152 Allow NULL? 
66SSUAMT07User Defined Amount 07NumericGeneric Edit152 Allow NULL? 
67SSUAMT08User Defined Amount 08NumericGeneric Edit152 Allow NULL? 
68SSUAMT09User Defined Amount 09NumericGeneric Edit152 Allow NULL? 
69SSUAMT10User Defined Amount 10NumericGeneric Edit154 Allow NULL? 
70SSUAMT11User Defined Amount 11NumericGeneric Edit152 Allow NULL? 
71SSUAMT12User Defined Amount 12NumericGeneric Edit152 Allow NULL? 
72SSUTOT1Numeric - User Total 1NumericGeneric Edit50 Allow NULL? 
73SSUTOT2Numeric - User Total 2NumericGeneric Edit50 Allow NULL? 
74SSUTOT3Numeric - User Total 3NumericGeneric Edit50 Allow NULL? 
75SSUTOT4Numeric - User Total 4NumericGeneric Edit50 Allow NULL? 
76SSUTOT5Numeric - User Total 5NumericGeneric Edit50 Allow NULL? 
77SSUTOT6Numeric - User Total 6NumericGeneric Edit50 Allow NULL? 
78SSUTOT7Numeric - User Total 7NumericGeneric Edit50 Allow NULL? 
79SSUTOT8Numeric - User Total 8NumericGeneric Edit50 Allow NULL? 
80SSUTOT9Numeric - User Total 9NumericGeneric Edit50 Allow NULL? 
81SSUTOT10Numeric - User Total 10NumericGeneric Edit50 Allow NULL? 
82SSF1AFuture 1 AmountNumericGeneric Edit150 Allow NULL? 
83SSF2AFuture 2 AmountNumericGeneric Edit150 Allow NULL? 
84SSF3AFuture 3 AmountNumericGeneric Edit150 Allow NULL? 
85SSF4AFuture 4 AmountNumericGeneric Edit150 Allow NULL? 
86SSF5AFuture 5 AmountNumericGeneric Edit150 Allow NULL? 
87SSF6AFuture 6 AmountNumericGeneric Edit150 Allow NULL? 
88SSFTOT1Numeric - Future Total 1NumericGeneric Edit50 Allow NULL? 
89SSFTOT2Numeric - Future Total 2NumericGeneric Edit50 Allow NULL? 
90SSFTOT3Numeric - Future Total 3NumericGeneric Edit50 Allow NULL? 
91SSFTOT4Numeric - Future Total 4NumericGeneric Edit50 Allow NULL? 
92SSFTOT5Numeric - Future Total 5NumericGeneric Edit50 Allow NULL? 
93SSFTOT6Numeric - Future Total 6NumericGeneric Edit50 Allow NULL? 
94SSCRTUCreated by userStringGeneric Edit100 Allow NULL? 
95SSCRTJDate - CreatedDateGeneric Edit60
96SSCRTTTime - CreatedNumericGeneric Edit60 Allow NULL? 
97SSWRKSTNIDOriginal Work Station IDStringGeneric Edit100 Allow NULL? 
98SSJPIDProgram IDStringGeneric Edit100 Allow NULL? 
99SSUPMBUpdated By - UserStringGeneric Edit100 Allow NULL? 
100SSUPMJDate - UpdatedDateGeneric Edit60
101SSUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
102SSJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
103SSPIDProgram IDStringGeneric Edit100 Allow NULL? 

TOP910 | 44H | F44H501S INDEXES

NumberDescription
1hbmcus Cphase Centyr Ptype (Primary/Unique)
ElementAliasDescriptionSequence
1HBMCUSCommunityAscending
2CPHASEPhaseAscending
3CENTYRCentury/YearAscending
4PTYPEString - Period TypeAscending
5FRP52 Period Number - Financial ReportingAscending