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

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
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

149 COLUMNS | 1 INDEXES | Print definition?920 | 15 | F15211 TABLE

15: Real Estate Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F15211AT1491Real Estate AttributesFiles15: Real Estate 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 ATATTRIBTY, ATMCU, ATFLOR, ATUNIT, ATZCA001, ATZCA002, ATZCA003, ATZCA004, ATZCA005, ATZCA006, ATZCA007, ATZCA008, ATZCA009, ATZCA010, ATZCA011, ATZCA012, ATZCA013, ATZCA014, ATZCA015, ATZCA016, ATZCA017, ATZCA018, ATZCA019, ATZCA020, ATZCA021, ATZCA022, ATZCA023, ATZCA024, ATZCA025, ATZCA026, ATZCA027, ATZCA028, ATZCA029, ATZCA030, ATZCA031, ATZCA032, ATZCA033, ATZCA034, ATZCA035, ATZCA036, ATZCA037, ATZCA038, ATZCA039, ATZCA040, ATZCA041, ATZCA042, ATZCA043, ATZCA044, ATZCA045, ATZCA046, ATZCA047, ATZCA048, ATZCA049, ATZCA050, ATZCA051, ATZCA052, ATZCA053, ATZCA054, ATZCA055, ATZCA056, ATZCA057, ATZCA058, ATZCA059, ATZCA060, ATZCA061, ATZCA062, ATZCA063, ATZCA064, ATZCA065, ATZCA066, ATZCA067, ATZCA068, ATZCA069, ATZCA070, ATZCA071, ATZCA072, ATZCA073, ATZCA074, ATZCA075, ATZCA076, ATZCA077, ATZCA078, ATZCA079, ATZCA080, ATZCA081, ATZCA082, ATZCA083, ATZCA084, ATZCA085, ATZCA086, ATZCA087, ATZCA088, ATZCA089, ATZCA090, ATZCA091, ATZCA092, ATZCA093, ATZCA094, ATZCA095, ATZCA096, ATZCA097, ATZCA098, ATZCA099, ATZCA100, ATZCA101, ATZCA102, ATZCA103, ATZCA104, ATZCA105, ATZCA106, ATZCA107, ATZCA108, ATZCA109, ATZCA110, ATZCA111, ATZCA112, ATZCA113, ATZCA114, ATZCA115, ATZCA116, ATZCA117, ATZCA118, ATZCA119, ATZCA120, ATZCA121, ATZCA122, ATZCA123, ATZCA124, ATZCA125, ATZCA126, ATZCA127, ATZCA128, ATZCA129, ATZCA130, ATZCA131, ATZCA132, ATZCA133, ATZCA134, ATZCA135, ATZCA136, ATZCA137, ATZCA138, ATZCA139, ATZCA140, ATUSER, ATUPMT, ATUPMJ, ATPID, ATMKEY FROM F15211

TOP920 | 15 | F15211 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1ATATTRIBTYAttribute TypeCharacterUDC (15 UA)10 Allow NULL? 
2ATMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
3ATFLORNumber - FloorStringUDC (15 FL)40 Allow NULL? 
4ATUNITUnitStringGeneric Edit80 Allow NULL? 
5ATZCA001Attribute Amount 001NumericGeneric Edit100 Allow NULL? 
6ATZCA002Attribute Amount 002NumericGeneric Edit100 Allow NULL? 
7ATZCA003Attribute Amount 003NumericGeneric Edit100 Allow NULL? 
8ATZCA004Attribute Amount 004NumericGeneric Edit100 Allow NULL? 
9ATZCA005Attribute Amount 005NumericGeneric Edit100 Allow NULL? 
10ATZCA006Attribute Amount 006NumericGeneric Edit100 Allow NULL? 
11ATZCA007Attribute Amount 007NumericGeneric Edit100 Allow NULL? 
12ATZCA008Attribute Amount 008NumericGeneric Edit100 Allow NULL? 
13ATZCA009Attribute Amount 009NumericGeneric Edit100 Allow NULL? 
14ATZCA010Attribute Amount 010NumericGeneric Edit100 Allow NULL? 
15ATZCA011Attribute Amount 011NumericGeneric Edit100 Allow NULL? 
16ATZCA012Attribute Amount 012NumericGeneric Edit100 Allow NULL? 
17ATZCA013Attribute Amount 013NumericGeneric Edit100 Allow NULL? 
18ATZCA014Attribute Amount 014NumericGeneric Edit100 Allow NULL? 
19ATZCA015Attribute Amount 015NumericGeneric Edit100 Allow NULL? 
20ATZCA016Attribute Amount 016NumericGeneric Edit100 Allow NULL? 
21ATZCA017Attribute Amount 017NumericGeneric Edit100 Allow NULL? 
22ATZCA018Attribute Amount 018NumericGeneric Edit100 Allow NULL? 
23ATZCA019Attribute Amount 019NumericGeneric Edit100 Allow NULL? 
24ATZCA020Attribute Amount 020NumericGeneric Edit100 Allow NULL? 
25ATZCA021Attribute Amount 021NumericGeneric Edit100 Allow NULL? 
26ATZCA022Attribute Amount 022NumericGeneric Edit100 Allow NULL? 
27ATZCA023Attribute Amount 023NumericGeneric Edit100 Allow NULL? 
28ATZCA024Attribute Amount 024NumericGeneric Edit100 Allow NULL? 
29ATZCA025Attribute Amount 025NumericGeneric Edit100 Allow NULL? 
30ATZCA026Attribute Amount 026NumericGeneric Edit100 Allow NULL? 
31ATZCA027Attribute Amount 027NumericGeneric Edit100 Allow NULL? 
32ATZCA028Attribute Amount 028NumericGeneric Edit100 Allow NULL? 
33ATZCA029Attribute Amount 029NumericGeneric Edit100 Allow NULL? 
34ATZCA030Attribute Amount 030NumericGeneric Edit100 Allow NULL? 
35ATZCA031Attribute Amount 031NumericGeneric Edit100 Allow NULL? 
36ATZCA032Attribute Amount 032NumericGeneric Edit100 Allow NULL? 
37ATZCA033Attribute Amount 033NumericGeneric Edit100 Allow NULL? 
38ATZCA034Attribute Amount 034NumericGeneric Edit100 Allow NULL? 
39ATZCA035Attribute Amount 035NumericGeneric Edit100 Allow NULL? 
40ATZCA036Attribute Amount 036NumericGeneric Edit100 Allow NULL? 
41ATZCA037Attribute Amount 037NumericGeneric Edit100 Allow NULL? 
42ATZCA038Attribute Amount 038NumericGeneric Edit100 Allow NULL? 
43ATZCA039Attribute Amount 039NumericGeneric Edit100 Allow NULL? 
44ATZCA040Attribute Amount 040NumericGeneric Edit100 Allow NULL? 
45ATZCA041Attribute Amount 041NumericGeneric Edit100 Allow NULL? 
46ATZCA042Attribute Amount 042NumericGeneric Edit100 Allow NULL? 
47ATZCA043Attribute Amount 043NumericGeneric Edit100 Allow NULL? 
48ATZCA044Attribute Amount 044NumericGeneric Edit100 Allow NULL? 
49ATZCA045Attribute Amount 045NumericGeneric Edit100 Allow NULL? 
50ATZCA046Attribute Amount 046NumericGeneric Edit100 Allow NULL? 
51ATZCA047Attribute Amount 047NumericGeneric Edit100 Allow NULL? 
52ATZCA048Attribute Amount 048NumericGeneric Edit100 Allow NULL? 
53ATZCA049Attribute Amount 049NumericGeneric Edit100 Allow NULL? 
54ATZCA050Attribute Amount 050NumericGeneric Edit100 Allow NULL? 
55ATZCA051Attribute Amount 051NumericGeneric Edit100 Allow NULL? 
56ATZCA052Attribute Amount 052NumericGeneric Edit100 Allow NULL? 
57ATZCA053Attribute Amount 053NumericGeneric Edit100 Allow NULL? 
58ATZCA054Attribute Amount 054NumericGeneric Edit100 Allow NULL? 
59ATZCA055Attribute Amount 055NumericGeneric Edit100 Allow NULL? 
60ATZCA056Attribute Amount 056NumericGeneric Edit100 Allow NULL? 
61ATZCA057Attribute Amount 057NumericGeneric Edit100 Allow NULL? 
62ATZCA058Attribute Amount 058NumericGeneric Edit100 Allow NULL? 
63ATZCA059Attribute Amount 059NumericGeneric Edit100 Allow NULL? 
64ATZCA060Attribute Amount 060NumericGeneric Edit100 Allow NULL? 
65ATZCA061Attribute Amount 061NumericGeneric Edit100 Allow NULL? 
66ATZCA062Attribute Amount 062NumericGeneric Edit100 Allow NULL? 
67ATZCA063Attribute Amount 063NumericGeneric Edit100 Allow NULL? 
68ATZCA064Attribute Amount 064NumericGeneric Edit100 Allow NULL? 
69ATZCA065Attribute Amount 065NumericGeneric Edit100 Allow NULL? 
70ATZCA066Attribute Amount 066NumericGeneric Edit100 Allow NULL? 
71ATZCA067Attribute Amount 067NumericGeneric Edit100 Allow NULL? 
72ATZCA068Attribute Amount 068NumericGeneric Edit100 Allow NULL? 
73ATZCA069Attribute Amount 069NumericGeneric Edit100 Allow NULL? 
74ATZCA070Attribute Amount 070NumericGeneric Edit100 Allow NULL? 
75ATZCA071Attribute Amount 071NumericGeneric Edit100 Allow NULL? 
76ATZCA072Attribute Amount 072NumericGeneric Edit100 Allow NULL? 
77ATZCA073Attribute Amount 073NumericGeneric Edit100 Allow NULL? 
78ATZCA074Attribute Amount 074NumericGeneric Edit100 Allow NULL? 
79ATZCA075Attribute Amount 075NumericGeneric Edit100 Allow NULL? 
80ATZCA076Attribute Amount 076NumericGeneric Edit100 Allow NULL? 
81ATZCA077Attribute Amount 077NumericGeneric Edit100 Allow NULL? 
82ATZCA078Attribute Amount 078NumericGeneric Edit100 Allow NULL? 
83ATZCA079Attribute Amount 079NumericGeneric Edit100 Allow NULL? 
84ATZCA080Attribute Amount 080NumericGeneric Edit100 Allow NULL? 
85ATZCA081Attribute String 081StringGeneric Edit300 Allow NULL? 
86ATZCA082Attribute String 082StringGeneric Edit300 Allow NULL? 
87ATZCA083Attribute String 083StringGeneric Edit300 Allow NULL? 
88ATZCA084Attribute String 084StringGeneric Edit300 Allow NULL? 
89ATZCA085Attribute String 085StringGeneric Edit300 Allow NULL? 
90ATZCA086Attribute String 086StringGeneric Edit300 Allow NULL? 
91ATZCA087Attribute String 087StringGeneric Edit300 Allow NULL? 
92ATZCA088Attribute String 088StringGeneric Edit300 Allow NULL? 
93ATZCA089Attribute String 089StringGeneric Edit300 Allow NULL? 
94ATZCA090Attribute String 090StringGeneric Edit300 Allow NULL? 
95ATZCA091Attribute Date 091DateGeneric Edit60
96ATZCA092Attribute Date 092DateGeneric Edit60
97ATZCA093Attribute Date 093DateGeneric Edit60
98ATZCA094Attribute Date 094DateGeneric Edit60
99ATZCA095Attribute Date 095DateGeneric Edit60
100ATZCA096Attribute Date 096DateGeneric Edit60
101ATZCA097Attribute Date 097DateGeneric Edit60
102ATZCA098Attribute Date 098DateGeneric Edit60
103ATZCA099Attribute Date 099DateGeneric Edit60
104ATZCA100Attribute Date 100DateGeneric Edit60
105ATZCA101Attribute Date 101DateGeneric Edit60
106ATZCA102Attribute Date 102DateGeneric Edit60
107ATZCA103Attribute Date 103DateGeneric Edit60
108ATZCA104Attribute Date 104DateGeneric Edit60
109ATZCA105Attribute Date 105DateGeneric Edit60
110ATZCA106Attribute Date 106DateGeneric Edit60
111ATZCA107Attribute Date 107DateGeneric Edit60
112ATZCA108Attribute Date 108DateGeneric Edit60
113ATZCA109Attribute Date 109DateGeneric Edit60
114ATZCA110Attribute Date 110DateGeneric Edit60
115ATZCA111Attribute Date 111DateGeneric Edit60
116ATZCA112Attribute Date 112DateGeneric Edit60
117ATZCA113Attribute Date 113DateGeneric Edit60
118ATZCA114Attribute Date 114DateGeneric Edit60
119ATZCA115Attribute Date 115DateGeneric Edit60
120ATZCA116Attribute Date 116DateGeneric Edit60
121ATZCA117Attribute Date 117DateGeneric Edit60
122ATZCA118Attribute Date 118DateGeneric Edit60
123ATZCA119Attribute Date 119DateGeneric Edit60
124ATZCA120Attribute Date 120DateGeneric Edit60
125ATZCA121Attribute String 121StringGeneric Edit300 Allow NULL? 
126ATZCA122Attribute String 122StringGeneric Edit300 Allow NULL? 
127ATZCA123Attribute String 123StringGeneric Edit300 Allow NULL? 
128ATZCA124Attribute String 124StringGeneric Edit300 Allow NULL? 
129ATZCA125Attribute String 125StringGeneric Edit300 Allow NULL? 
130ATZCA126Attribute String 126StringGeneric Edit300 Allow NULL? 
131ATZCA127Attribute String 127StringGeneric Edit300 Allow NULL? 
132ATZCA128Attribute String 128StringGeneric Edit300 Allow NULL? 
133ATZCA129Attribute String 129StringGeneric Edit300 Allow NULL? 
134ATZCA130Attribute String 130StringGeneric Edit300 Allow NULL? 
135ATZCA131Attribute String 131StringGeneric Edit300 Allow NULL? 
136ATZCA132Attribute String 132StringGeneric Edit300 Allow NULL? 
137ATZCA133Attribute String 133StringGeneric Edit300 Allow NULL? 
138ATZCA134Attribute String 134StringGeneric Edit300 Allow NULL? 
139ATZCA135Attribute String 135StringGeneric Edit300 Allow NULL? 
140ATZCA136Attribute String 136StringGeneric Edit300 Allow NULL? 
141ATZCA137Attribute String 137StringGeneric Edit300 Allow NULL? 
142ATZCA138Attribute String 138StringGeneric Edit300 Allow NULL? 
143ATZCA139Attribute String 139StringGeneric Edit300 Allow NULL? 
144ATZCA140Attribute String 140StringGeneric Edit300 Allow NULL? 
145ATUSERUser IDStringGeneric Edit100 Allow NULL? 
146ATUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
147ATUPMJDate - UpdatedDateGeneric Edit60
148ATPIDProgram IDStringGeneric Edit100 Allow NULL? 
149ATMKEYMachine KeyStringGeneric Edit150 Allow NULL? 

TOP920 | 15 | F15211 INDEXES

NumberDescription
1Primary (Primary/Unique)
ElementAliasDescriptionSequence
1ATTRIBTYAttribute TypeAscending
2MCUBusiness UnitAscending
3FLORNumber - FloorAscending
4UNITUnitAscending