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

127 COLUMNS | 2 INDEXES | Print definition?910 | 51 | F5111 TABLE

51: Job Costing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F5111FD1272Forecast DetailTransaction Files51: Job Costing
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 FDMCU, FDFORVER, FDAID, FDOBJ, FDSUB, FDATST, FDPNFN, FDGLDTE, FDDATPER, FDLDA, FDHEADDESC, FDACCTDESC, FDDAYSREM, FDREVBUD, FDBORG, FDITDACTUAL, FDDAILYRATE, FDETC, FDPFAA, FDCURACT, FDFCRMAA, FDFCAMT01, FDFCDAYS01, FDFCAMT02, FDFCDAYS02, FDFCAMT03, FDFCDAYS03, FDFCAMT04, FDFCDAYS04, FDFCAMT05, FDFCDAYS05, FDFCAMT06, FDFCDAYS06, FDFCAMT07, FDFCDAYS07, FDFCAMT08, FDFCDAYS08, FDFCAMT09, FDFCDAYS09, FDFCAMT10, FDFCDAYS10, FDFCAMT11, FDFCDAYS11, FDFCAMT12, FDFCDAYS12, FDFCAMT13, FDFCDAYS13, FDFCAMT14, FDFCDAYS14, FDFCAMT15, FDFCDAYS15, FDFCAMT16, FDFCDAYS16, FDFCAMT17, FDFCDAYS17, FDFCAMT18, FDFCDAYS18, FDFCAMT19, FDFCDAYS19, FDFCAMT20, FDFCDAYS20, FDFCAMT21, FDFCDAYS21, FDFCAMT22, FDFCDAYS22, FDFCAMT23, FDFCDAYS23, FDFCAMT24, FDFCDAYS24, FDFCAMT25, FDFCDAYS25, FDFCAMT26, FDFCDAYS26, FDFCAMT27, FDFCDAYS27, FDFCAMT28, FDFCDAYS28, FDFCAMT29, FDFCDAYS29, FDFCAMT30, FDFCDAYS30, FDFCAMT31, FDFCDAYS31, FDFCAMT32, FDFCDAYS32, FDFCAMT33, FDFCDAYS33, FDFCAMT34, FDFCDAYS34, FDFCAMT35, FDFCDAYS35, FDFCAMT36, FDFCDAYS36, FDFCAMT37, FDFCDAYS37, FDFCAMT38, FDFCDAYS38, FDFCAMT39, FDFCDAYS39, FDFCAMT40, FDFCDAYS40, FDFCAMT41, FDFCDAYS41, FDFCAMT42, FDFCDAYS42, FDFCAMT43, FDFCDAYS43, FDFCAMT44, FDFCDAYS44, FDFCAMT45, FDFCDAYS45, FDFCAMT46, FDFCDAYS46, FDFCAMT47, FDFCDAYS47, FDFCAMT48, FDFCDAYS48, FDCPYFRMVER, FDUSER, FDPID, FDUPMJ, FDUPMT, FDJOBN, FDRECTYPE1, FDCCT, FDSBL, FDSBLT FROM F5111

TOP910 | 51 | F5111 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1FDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
2FDFORVERForecast VersionStringGeneric Edit100 Allow NULL? 
3FDAIDAccount IDStringGeneric Edit80 Allow NULL? 
4FDOBJObject AccountStringGeneric Edit60 Allow NULL? 
5FDSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
6FDATSTDate - Actual Start (Julian)DateGeneric Edit60
7FDPNFNDate - Planned Finish (Julian)DateGeneric Edit60
8FDGLDTEGL DateDateGeneric Edit60
9FDDATPERDates or PercentCharacterGeneric Edit10 Allow NULL? 
10FDLDAAccount Level of DetailCharacterGeneric Edit10 Allow NULL? 
11FDHEADDESCAccount Header DescriptionStringGeneric Edit300 Allow NULL? 
12FDACCTDESCAccount DescriptionStringGeneric Edit300 Allow NULL? 
13FDDAYSREMDays RemainingNumericGeneric Edit40 Allow NULL? 
14FDREVBUDRevised BudgetNumericGeneric Edit152 Allow NULL? 
15FDBORGAmount - Original/Beginning BudgetNumericGeneric Edit152 Allow NULL? 
16FDITDACTUALITD ActualNumericGeneric Edit152 Allow NULL? 
17FDDAILYRATEDaily RateNumericGeneric Edit154 Allow NULL? 
18FDETCETCNumericGeneric Edit152 Allow NULL? 
19FDPFAAProjected Final AmountNumericGeneric Edit152 Allow NULL? 
20FDCURACTCurrent Month ActualNumericGeneric Edit152 Allow NULL? 
21FDFCRMAARemaining Amount to Allocate ForecastNumericGeneric Edit152 Allow NULL? 
22FDFCAMT01Forecasting Amount 01NumericGeneric Edit152 Allow NULL? 
23FDFCDAYS01Forecast Period Days 01NumericGeneric Edit40 Allow NULL? 
24FDFCAMT02Forecasting Amount 02NumericGeneric Edit152 Allow NULL? 
25FDFCDAYS02Forecast Period Days 02NumericGeneric Edit40 Allow NULL? 
26FDFCAMT03Forecasting Amount 03NumericGeneric Edit152 Allow NULL? 
27FDFCDAYS03Forecast Period Days 03NumericGeneric Edit40 Allow NULL? 
28FDFCAMT04Forecasting Amount 04NumericGeneric Edit152 Allow NULL? 
29FDFCDAYS04Forecast Period Days 04NumericGeneric Edit40 Allow NULL? 
30FDFCAMT05Forecasting Amount 05NumericGeneric Edit152 Allow NULL? 
31FDFCDAYS05Forecast Period Days 05NumericGeneric Edit40 Allow NULL? 
32FDFCAMT06Forecasting Amount 06NumericGeneric Edit152 Allow NULL? 
33FDFCDAYS06Forecast Period Days 06NumericGeneric Edit40 Allow NULL? 
34FDFCAMT07Forecasting Amount 07NumericGeneric Edit152 Allow NULL? 
35FDFCDAYS07Forecast Period Days 07NumericGeneric Edit40 Allow NULL? 
36FDFCAMT08Forecasting Amount 08NumericGeneric Edit152 Allow NULL? 
37FDFCDAYS08Forecast Period Days 08NumericGeneric Edit40 Allow NULL? 
38FDFCAMT09Forecasting Amount 09NumericGeneric Edit152 Allow NULL? 
39FDFCDAYS09Forecast Period Days 09NumericGeneric Edit40 Allow NULL? 
40FDFCAMT10Forecasting Amount 10NumericGeneric Edit152 Allow NULL? 
41FDFCDAYS10Forecast Period Days 10NumericGeneric Edit40 Allow NULL? 
42FDFCAMT11Forecasting Amount 11NumericGeneric Edit152 Allow NULL? 
43FDFCDAYS11Forecast Period Days 11NumericGeneric Edit40 Allow NULL? 
44FDFCAMT12Forecasting Amount 12NumericGeneric Edit152 Allow NULL? 
45FDFCDAYS12Forecast Period Days 12NumericGeneric Edit40 Allow NULL? 
46FDFCAMT13Forecasting Amount 13NumericGeneric Edit152 Allow NULL? 
47FDFCDAYS13Forecast Period Days 13NumericGeneric Edit40 Allow NULL? 
48FDFCAMT14Forecasting Amount 14NumericGeneric Edit152 Allow NULL? 
49FDFCDAYS14Forecast Period Days 14NumericGeneric Edit40 Allow NULL? 
50FDFCAMT15Forecasting Amount 15NumericGeneric Edit152 Allow NULL? 
51FDFCDAYS15Forecast Period Days 15NumericGeneric Edit40 Allow NULL? 
52FDFCAMT16Forecasting Amount 16NumericGeneric Edit152 Allow NULL? 
53FDFCDAYS16Forecast Period Days 16NumericGeneric Edit40 Allow NULL? 
54FDFCAMT17Forecasting Amount 17NumericGeneric Edit152 Allow NULL? 
55FDFCDAYS17Forecast Period Days 17NumericGeneric Edit40 Allow NULL? 
56FDFCAMT18Forecasting Amount 18NumericGeneric Edit152 Allow NULL? 
57FDFCDAYS18Forecast Period Days 18NumericGeneric Edit40 Allow NULL? 
58FDFCAMT19Forecasting Amount 19NumericGeneric Edit152 Allow NULL? 
59FDFCDAYS19Forecast Period Days 19NumericGeneric Edit40 Allow NULL? 
60FDFCAMT20Forecasting Amount 20NumericGeneric Edit152 Allow NULL? 
61FDFCDAYS20Forecast Period Days 20NumericGeneric Edit40 Allow NULL? 
62FDFCAMT21Forecasting Amount 21NumericGeneric Edit152 Allow NULL? 
63FDFCDAYS21Forecast Period Days 21NumericGeneric Edit40 Allow NULL? 
64FDFCAMT22Forecasting Amount 22NumericGeneric Edit152 Allow NULL? 
65FDFCDAYS22Forecast Period Days 22NumericGeneric Edit40 Allow NULL? 
66FDFCAMT23Forecasting Amount 23NumericGeneric Edit152 Allow NULL? 
67FDFCDAYS23Forecast Period Days 23NumericGeneric Edit40 Allow NULL? 
68FDFCAMT24Forecasting Amount 24NumericGeneric Edit152 Allow NULL? 
69FDFCDAYS24Forecast Period Days 24NumericGeneric Edit40 Allow NULL? 
70FDFCAMT25Forecasting Amount 25NumericGeneric Edit152 Allow NULL? 
71FDFCDAYS25Forecast Period Days 25NumericGeneric Edit40 Allow NULL? 
72FDFCAMT26Forecasting Amount 26NumericGeneric Edit152 Allow NULL? 
73FDFCDAYS26Forecast Period Days 26NumericGeneric Edit40 Allow NULL? 
74FDFCAMT27Forecasting Amount 27NumericGeneric Edit152 Allow NULL? 
75FDFCDAYS27Forecast Period Days 27NumericGeneric Edit40 Allow NULL? 
76FDFCAMT28Forecasting Amount 28NumericGeneric Edit152 Allow NULL? 
77FDFCDAYS28Forecast Period Days 28NumericGeneric Edit40 Allow NULL? 
78FDFCAMT29Forecasting Amount 29NumericGeneric Edit152 Allow NULL? 
79FDFCDAYS29Forecast Period Days 29NumericGeneric Edit40 Allow NULL? 
80FDFCAMT30Forecasting Amount 30NumericGeneric Edit152 Allow NULL? 
81FDFCDAYS30Forecast Period Days 30NumericGeneric Edit40 Allow NULL? 
82FDFCAMT31Forecasting Amount 31NumericGeneric Edit152 Allow NULL? 
83FDFCDAYS31Forecast Period Days 31NumericGeneric Edit40 Allow NULL? 
84FDFCAMT32Forecasting Amount 32NumericGeneric Edit152 Allow NULL? 
85FDFCDAYS32Forecast Period Days 32NumericGeneric Edit40 Allow NULL? 
86FDFCAMT33Forecasting Amount 33NumericGeneric Edit152 Allow NULL? 
87FDFCDAYS33Forecast Period Days 33NumericGeneric Edit40 Allow NULL? 
88FDFCAMT34Forecasting Amount 34NumericGeneric Edit152 Allow NULL? 
89FDFCDAYS34Forecast Period Days 34NumericGeneric Edit40 Allow NULL? 
90FDFCAMT35Forecasting Amount 35NumericGeneric Edit152 Allow NULL? 
91FDFCDAYS35Forecast Period Days 35NumericGeneric Edit40 Allow NULL? 
92FDFCAMT36Forecasting Amount 36NumericGeneric Edit152 Allow NULL? 
93FDFCDAYS36Forecast Period Days 36NumericGeneric Edit40 Allow NULL? 
94FDFCAMT37Forecasting Amount 37NumericGeneric Edit152 Allow NULL? 
95FDFCDAYS37Forecast Period Days 37NumericGeneric Edit40 Allow NULL? 
96FDFCAMT38Forecasting Amount 38NumericGeneric Edit152 Allow NULL? 
97FDFCDAYS38Forecast Period Days 38NumericGeneric Edit40 Allow NULL? 
98FDFCAMT39Forecasting Amount 39NumericGeneric Edit152 Allow NULL? 
99FDFCDAYS39Forecast Period Days 39NumericGeneric Edit40 Allow NULL? 
100FDFCAMT40Forecasting Amount 40NumericGeneric Edit152 Allow NULL? 
101FDFCDAYS40Forecast Period Days 40NumericGeneric Edit40 Allow NULL? 
102FDFCAMT41Forecasting Amount 41NumericGeneric Edit152 Allow NULL? 
103FDFCDAYS41Forecast Period Days 41NumericGeneric Edit40 Allow NULL? 
104FDFCAMT42Forecasting Amount 42NumericGeneric Edit152 Allow NULL? 
105FDFCDAYS42Forecast Period Days 42NumericGeneric Edit40 Allow NULL? 
106FDFCAMT43Forecasting Amount 43NumericGeneric Edit152 Allow NULL? 
107FDFCDAYS43Forecast Period Days 43NumericGeneric Edit40 Allow NULL? 
108FDFCAMT44Forecasting Amount 44NumericGeneric Edit152 Allow NULL? 
109FDFCDAYS44Forecast Period Days 44NumericGeneric Edit40 Allow NULL? 
110FDFCAMT45Forecasting Amount 45NumericGeneric Edit152 Allow NULL? 
111FDFCDAYS45Forecast Period Days 45NumericGeneric Edit40 Allow NULL? 
112FDFCAMT46Forecasting Amount 46NumericGeneric Edit152 Allow NULL? 
113FDFCDAYS46Forecast Period Days 46NumericGeneric Edit40 Allow NULL? 
114FDFCAMT47Forecasting Amount 47NumericGeneric Edit152 Allow NULL? 
115FDFCDAYS47Forecast Period Days 47NumericGeneric Edit40 Allow NULL? 
116FDFCAMT48Forecasting Amount 48NumericGeneric Edit152 Allow NULL? 
117FDFCDAYS48Forecast Period Days 48NumericGeneric Edit40 Allow NULL? 
118FDCPYFRMVERCopied From VersionStringGeneric Edit100 Allow NULL? 
119FDUSERUser IDStringGeneric Edit100 Allow NULL? 
120FDPIDProgram IDStringGeneric Edit100 Allow NULL? 
121FDUPMJDate - UpdatedDateGeneric Edit60
122FDUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
123FDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
124FDRECTYPE1Forecasting Record TypeCharacterGeneric Edit10 Allow NULL? 
125FDCCTMethod of ComputationCharacterUDC (51 MC)10 Allow NULL? 
126FDSBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
127FDSBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 

TOP910 | 51 | F5111 INDEXES

NumberDescription
1MCU Version Aid (Primary/Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2FORVERForecast VersionAscending
3AIDAccount IDAscending
2MCU Version
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2FORVERForecast VersionAscending