JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool
44H: Homebuilder Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F44H101ZSZ1212HB Community Master Unedited Transaction FileFiles44H: 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 SZEDUS, SZEDBT, SZEDTN, SZEDLN, SZEDCT, SZTYTN, SZEDFT, SZEDDT, SZDRIN, SZEDDL, SZEDSP, SZPNID, SZTNAC, SZHBMCUS, SZCPHASE, SZPHSENB, SZHBAREA, SZDL01, SZNBRPHS, SZPMPT, SZPMPG, SZAN8MCUS, SZAN8SOF, SZAN8COF, SZAN8CM01, SZAN8CM02, SZAN8CM03, SZAN8CM04, SZAN8CM05, SZAN8CM06, SZAN8CM07, SZAN8CM08, SZAN8CM09, SZAN8CM10, SZAN8CM11, SZAN8CM12, SZAN8CM13, SZAN8CM14, SZAN8CM15, SZAN8CM16, SZAN8CM17, SZAN8CM18, SZAN8CM19, SZAN8CM20, SZAN8UR01, SZAN8UR02, SZAN8UR03, SZAN8UR04, SZAN8UR05, SZCONSSEQ, SZNBRLOT, SZNBRSLD, SZNBRCLSD, SZNBRSTRD, SZNBRFIN, SZAOCST01, SZAOCST02, SZAOCST03, SZAOCST04, SZAOCST05, SZAOREV01, SZAOREV02, SZAOREV03, SZAOREV04, SZAOREV05, SZCSTPCT01, SZCSTPCT02, SZCSTPCT03, SZCSTPCT04, SZCSTPCT05, SZCSTPCT06, SZCSTPCT07, SZCSTPCT08, SZCSTPCT09, SZCSTPCT10, SZHBRLTPC, SZHBRLTPS, SZINCMCU, SZWAMCU, SZCWTMPT, SZUAMT01, SZUAMT02, SZUAMT03, SZUAMT04, SZUAMT05, SZUAMT06, SZUAMT07, SZUAMT08, SZUAMT09, SZUAMT10, SZF1A, SZF2A, SZF3A, SZF4A, SZF5A, SZUSD1, SZUSD2, SZUSD3, SZUSD4, SZUSD5, SZUSD6, SZUSD7, SZUSD8, SZUSD9, SZUSD10, SZCRTU, SZCRTJ, SZCRTT, SZWRKSTNID, SZHBOPID, SZUPMB, SZUPMJ, SZUPMT, SZJOBN, SZPID, SZSCHENB, SZHBST1, SZHBST2, SZHBST3, SZHBST4, SZHBST5 FROM F44H101Z

TOP812 | 44H | F44H101Z COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SZEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2SZEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3SZEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4SZEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5SZEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6SZTYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7SZEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8SZEDDTEDI - Transmission DateDateGeneric Edit60
9SZDRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10SZEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11SZEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12SZPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13SZTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14SZHBMCUSCommunityStringGeneric Edit120 Allow NULL? 
15SZCPHASEPhaseStringGeneric Edit30 Allow NULL? 
16SZPHSENBPhase Enabling FlagCharacterGeneric Edit10 Allow NULL? 
17SZHBAREAHomeBuilder Area IDStringUDC (00 05)30 Allow NULL? 
18SZDL01DescriptionStringGeneric Edit300 Allow NULL? 
19SZNBRPHSNumber of PhasesNumericGeneric Edit30 Allow NULL? 
20SZPMPTPlan Master Product TypeStringUDC (44H3 PT)30 Allow NULL? 
21SZPMPGPlan Master Product GroupStringUDC (44H3 PG)30 Allow NULL? 
22SZAN8MCUSAddress Number - CommunityNumericGeneric Edit80 Allow NULL? 
23SZAN8SOFAddress Number - Sales OfficeNumericGeneric Edit80 Allow NULL? 
24SZAN8COFAddress Number - Construction OfficeNumericGeneric Edit80 Allow NULL? 
25SZAN8CM01Address Number - Community 01NumericGeneric Edit80 Allow NULL? 
26SZAN8CM02Address Number - Community 02NumericGeneric Edit80 Allow NULL? 
27SZAN8CM03Address Number - Community 03NumericGeneric Edit80 Allow NULL? 
28SZAN8CM04Address Number - Community 04NumericGeneric Edit80 Allow NULL? 
29SZAN8CM05Address Number - Community 05NumericGeneric Edit80 Allow NULL? 
30SZAN8CM06Address Number - Community 06NumericGeneric Edit80 Allow NULL? 
31SZAN8CM07Address Number - Community 07NumericGeneric Edit80 Allow NULL? 
32SZAN8CM08Address Number - Community 08NumericGeneric Edit80 Allow NULL? 
33SZAN8CM09Address Number - Community 09NumericGeneric Edit80 Allow NULL? 
34SZAN8CM10Address Number - Community 10NumericGeneric Edit80 Allow NULL? 
35SZAN8CM11Address Number - Community 11NumericGeneric Edit80 Allow NULL? 
36SZAN8CM12Address Number - Community 12NumericGeneric Edit80 Allow NULL? 
37SZAN8CM13Address Number - Community 13NumericGeneric Edit80 Allow NULL? 
38SZAN8CM14Address Number - Community 14NumericGeneric Edit80 Allow NULL? 
39SZAN8CM15Address Number - Community 15NumericGeneric Edit80 Allow NULL? 
40SZAN8CM16Address Number - Community 16NumericGeneric Edit80 Allow NULL? 
41SZAN8CM17Address Number - Community 17NumericGeneric Edit80 Allow NULL? 
42SZAN8CM18Address Number - Community 18NumericGeneric Edit80 Allow NULL? 
43SZAN8CM19Address Number - Community 19NumericGeneric Edit80 Allow NULL? 
44SZAN8CM20Address Number - Community 20NumericGeneric Edit80 Allow NULL? 
45SZAN8UR01Address Number - User Reserved 01NumericGeneric Edit80 Allow NULL? 
46SZAN8UR02Address Number - User Reserved 02NumericGeneric Edit80 Allow NULL? 
47SZAN8UR03Address Number - User Reserved 03NumericGeneric Edit80 Allow NULL? 
48SZAN8UR04Address Number - User Reserved 04NumericGeneric Edit80 Allow NULL? 
49SZAN8UR05Address Number - User Reserved 05NumericGeneric Edit80 Allow NULL? 
50SZCONSSEQConstruction Sequence NumberStringGeneric Edit30 Allow NULL? 
51SZNBRLOTNumber of LotsNumericGeneric Edit80 Allow NULL? 
52SZNBRSLDNumber of Sold LotsNumericGeneric Edit80 Allow NULL? 
53SZNBRCLSDNumber of Closed LotsNumericGeneric Edit80 Allow NULL? 
54SZNBRSTRDNumber of Started LotsNumericGeneric Edit80 Allow NULL? 
55SZNBRFINNumber of Finished LotsNumericGeneric Edit80 Allow NULL? 
56SZAOCST01Average Other Cost 01NumericGeneric Edit152 Allow NULL? 
57SZAOCST02Average Other Cost 02NumericGeneric Edit152 Allow NULL? 
58SZAOCST03Average Other Cost 03NumericGeneric Edit152 Allow NULL? 
59SZAOCST04Average Other Cost 04NumericGeneric Edit152 Allow NULL? 
60SZAOCST05Average Other Cost 05NumericGeneric Edit152 Allow NULL? 
61SZAOREV01Average Other Revenue 01NumericGeneric Edit152 Allow NULL? 
62SZAOREV02Average Other Revenue 02NumericGeneric Edit152 Allow NULL? 
63SZAOREV03Average Other Revenue 03NumericGeneric Edit152 Allow NULL? 
64SZAOREV04Average Other Revenue 04NumericGeneric Edit152 Allow NULL? 
65SZAOREV05Average Other Revenue 05NumericGeneric Edit152 Allow NULL? 
66SZCSTPCT01Average Cost Percentage 1NumericGeneric Edit52 Allow NULL? 
67SZCSTPCT02Average Cost Percentage 2NumericGeneric Edit52 Allow NULL? 
68SZCSTPCT03Average Cost Percentage 3NumericGeneric Edit52 Allow NULL? 
69SZCSTPCT04Average Cost Percentage 4NumericGeneric Edit52 Allow NULL? 
70SZCSTPCT05Average Cost Percentage 5NumericGeneric Edit52 Allow NULL? 
71SZCSTPCT06Average Cost Percentage 6NumericGeneric Edit52 Allow NULL? 
72SZCSTPCT07Average Cost Percentage 7NumericGeneric Edit52 Allow NULL? 
73SZCSTPCT08Average Cost Percentage 8NumericGeneric Edit52 Allow NULL? 
74SZCSTPCT09Average Cost Percentage 9NumericGeneric Edit52 Allow NULL? 
75SZCSTPCT10Average Cost Percentage 10NumericGeneric Edit52 Allow NULL? 
76SZHBRLTPCRule Type ConstructionStringUDC (44H0 RT)30 Allow NULL? 
77SZHBRLTPSRule Type SalesStringUDC (44H0 RT)30 Allow NULL? 
78SZINCMCUIncome Statement Business UnitStringGeneric Edit120 Allow NULL? 
79SZWAMCUWarranty Business UnitStringGeneric Edit120 Allow NULL? 
80SZCWTMPTClosing Worksheet TemplateStringGeneric Edit120 Allow NULL? 
81SZUAMT01User Defined Amount 01NumericGeneric Edit152 Allow NULL? 
82SZUAMT02User Defined Amount 02NumericGeneric Edit152 Allow NULL? 
83SZUAMT03User Defined Amount 03NumericGeneric Edit152 Allow NULL? 
84SZUAMT04User Defined Amount 04NumericGeneric Edit152 Allow NULL? 
85SZUAMT05User Defined Amount 05NumericGeneric Edit152 Allow NULL? 
86SZUAMT06User Defined Amount 06NumericGeneric Edit152 Allow NULL? 
87SZUAMT07User Defined Amount 07NumericGeneric Edit152 Allow NULL? 
88SZUAMT08User Defined Amount 08NumericGeneric Edit152 Allow NULL? 
89SZUAMT09User Defined Amount 09NumericGeneric Edit152 Allow NULL? 
90SZUAMT10User Defined Amount 10NumericGeneric Edit154 Allow NULL? 
91SZF1AFuture 1 AmountNumericGeneric Edit150 Allow NULL? 
92SZF2AFuture 2 AmountNumericGeneric Edit150 Allow NULL? 
93SZF3AFuture 3 AmountNumericGeneric Edit150 Allow NULL? 
94SZF4AFuture 4 AmountNumericGeneric Edit150 Allow NULL? 
95SZF5AFuture 5 AmountNumericGeneric Edit150 Allow NULL? 
96SZUSD1User Date 1DateGeneric Edit60
97SZUSD2User Date 2DateGeneric Edit60
98SZUSD3User Date 3DateGeneric Edit60
99SZUSD4User Date 4DateGeneric Edit60
100SZUSD5User Date 5DateGeneric Edit60
101SZUSD6User Date 6DateGeneric Edit60
102SZUSD7User Date 7DateGeneric Edit60
103SZUSD8User Date 8DateGeneric Edit60
104SZUSD9User Date 9DateGeneric Edit60
105SZUSD10User Date 10DateGeneric Edit60
106SZCRTUCreated by userStringGeneric Edit100 Allow NULL? 
107SZCRTJDate - CreatedDateGeneric Edit60
108SZCRTTTime - CreatedNumericGeneric Edit60 Allow NULL? 
109SZWRKSTNIDOriginal Work Station IDStringGeneric Edit100 Allow NULL? 
110SZHBOPIDOriginal Program IDStringGeneric Edit100 Allow NULL? 
111SZUPMBUpdated By - UserStringGeneric Edit100 Allow NULL? 
112SZUPMJDate - UpdatedDateGeneric Edit60
113SZUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
114SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
115SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
116SZSCHENBScheduling EnabledCharacterGeneric Edit10 Allow NULL? 
117SZHBST1HomeBuilder Status Code 1CharacterGeneric Edit10 Allow NULL? 
118SZHBST2HomeBuilder Status Code 2CharacterGeneric Edit10 Allow NULL? 
119SZHBST3HomeBuilder Status Code 3CharacterGeneric Edit10 Allow NULL? 
120SZHBST4HomeBuilder Status Code 4CharacterGeneric Edit10 Allow NULL? 
121SZHBST5HomeBuilder Status Code 5CharacterGeneric Edit10 Allow NULL? 

TOP812 | 44H | F44H101Z INDEXES

NumberDescription
1UserBatchTransLine (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
2CommunityPhaseNumber
ElementAliasDescriptionSequence
1HBMCUSCommunityAscending
2CPHASEPhaseAscending