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

69 COLUMNS | 1 INDEXES | Print definition?920 | 51F | F51F30W TABLE

51F: Advanced Job Forecasting
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F51F30WVF691View Forecast Work TableWork Files51F: Advanced Job Forecasting
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 VFUSER, VF51FFID, VFAID, VF51FAA02, VF51FAAVAR, VF51FAU02, VF51FAUVAR, VF51FPA02, VF51FPAVAR, VF51FPU02, VF51FPUVAR, VF51FBORGA, VF51FBORGU, VF51FHA01, VF51FHA02, VF51FHAVAR, VF51FHU01, VF51FHU02, VF51FHUVAR, VF51FAAPA1, VF51FAUPU1, VF51FREMA1, VF51FREMU1, VF51FPERCP, VF51FPERCU, VF51FEACA2, VF51FEACAV, VF51FEACU2, VF51FEACUV, VF51FTBCA2, VF51FTBCAV, VF51FTBCU2, VF51FTBCUV, VF51FETCA2, VF51FETCAV, VF51FETCU2, VF51FETCUV, VF51FJAHAV, VF51FJUHUV, VF51FFBA1, VF51FFBA2, VF51FFBAV, VF51FFBU1, VF51FFBU2, VF51FFBUV, VF51FPENAV, VF51FPENUV, VF51FCHGA2, VF51FCHGAV, VF51FCHGU2, VF51FCHGUV, VF51FJA02, VF51FJAVAR, VF51FJU02, VF51FJUVAR, VF51FFHA, VF51FFHU, VF51FJA03, VF51FJU03, VF51FLTVAL, VF51FLTV2, VF51FLTV3, VF51FLTV4, VF51FLTV5, VF51FLTV6, VF51FLTV7, VF51FLTV8, VF51FLTV9, VF51FLTV10 FROM F51F30W

TOP920 | 51F | F51F30W COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1VFUSERUser IDStringGeneric Edit100 Allow NULL? 
2VF51FFIDForecast IDNumericGeneric Edit150 Allow NULL? 
3VFAIDAccount IDStringGeneric Edit80 Allow NULL? 
4VF51FAA02Actual Amount - PriorNumericGeneric Edit152 Allow NULL? 
5VF51FAAVARActual Amount - VarianceNumericGeneric Edit152 Allow NULL? 
6VF51FAU02Actual Units - PriorNumericGeneric Edit152 Allow NULL? 
7VF51FAUVARActual Units - VarianceNumericGeneric Edit152 Allow NULL? 
8VF51FPA02Open Commitment Amount - PriorNumericGeneric Edit152 Allow NULL? 
9VF51FPAVAROpen Commitment Amount - VarianceNumericGeneric Edit152 Allow NULL? 
10VF51FPU02Open Commitment Units - PriorNumericGeneric Edit152 Allow NULL? 
11VF51FPUVAROpen Commitment Units - VarianceNumericGeneric Edit152 Allow NULL? 
12VF51FBORGAOriginal Budget AmountNumericGeneric Edit152 Allow NULL? 
13VF51FBORGUOriginal Budget UnitsNumericGeneric Edit152 Allow NULL? 
14VF51FHA01Projected Final Amount - CurrentNumericGeneric Edit152 Allow NULL? 
15VF51FHA02Projected Final Amount - PriorNumericGeneric Edit152 Allow NULL? 
16VF51FHAVARProjected Final Amount - VarianceNumericGeneric Edit152 Allow NULL? 
17VF51FHU01Projected Final Units - CurrentNumericGeneric Edit152 Allow NULL? 
18VF51FHU02Projected Final Units - PriorNumericGeneric Edit152 Allow NULL? 
19VF51FHUVARProjected Final Units - VarianceNumericGeneric Edit152 Allow NULL? 
20VF51FAAPA1Total Commitment AmountNumericGeneric Edit152 Allow NULL? 
21VF51FAUPU1Total Commitment UnitsNumericGeneric Edit152 Allow NULL? 
22VF51FREMA1Remaining Spend AmountNumericGeneric Edit152 Allow NULL? 
23VF51FREMU1Remaining Spend UnitsNumericGeneric Edit152 Allow NULL? 
24VF51FPERCPPercent Complete - AmountNumericGeneric Edit152 Allow NULL? 
25VF51FPERCUPercent Complete - UnitsNumericGeneric Edit152 Allow NULL? 
26VF51FEACA2Prior Revised EAC AmountNumericGeneric Edit152 Allow NULL? 
27VF51FEACAVRevised EAC Amount - VarianceNumericGeneric Edit152 Allow NULL? 
28VF51FEACU2Prior Revised EAC UnitsNumericGeneric Edit152 Allow NULL? 
29VF51FEACUVRevised EAC Units - VarianceNumericGeneric Edit152 Allow NULL? 
30VF51FTBCA2To-Be-Committed Amount - PriorNumericGeneric Edit152 Allow NULL? 
31VF51FTBCAVTo-Be-Committed Amount - VarianceNumericGeneric Edit152 Allow NULL? 
32VF51FTBCU2To-Be-Committed Units - PriorNumericGeneric Edit152 Allow NULL? 
33VF51FTBCUVTo-Be-Committed Units - VarianceNumericGeneric Edit152 Allow NULL? 
34VF51FETCA2Prior Revised ETC AmountNumericGeneric Edit152 Allow NULL? 
35VF51FETCAVRevised ETC Amount - VarianceNumericGeneric Edit152 Allow NULL? 
36VF51FETCU2Prior Revised ETC UnitsNumericGeneric Edit152 Allow NULL? 
37VF51FETCUVRevised ETC Units - VarianceNumericGeneric Edit152 Allow NULL? 
38VF51FJAHAVOver/Under Amount VarianceNumericGeneric Edit152 Allow NULL? 
39VF51FJUHUVOver/Under Units VarianceNumericGeneric Edit152 Allow NULL? 
40VF51FFBA1Forecasted Budget Amount - CurrentNumericGeneric Edit152 Allow NULL? 
41VF51FFBA2Forecasted Budget Amount - PriorNumericGeneric Edit152 Allow NULL? 
42VF51FFBAVForecasted Budget Amount - VarianceNumericGeneric Edit152 Allow NULL? 
43VF51FFBU1Forecasted Budget Units - CurrentNumericGeneric Edit152 Allow NULL? 
44VF51FFBU2Forecasted Budget Units - PriorNumericGeneric Edit152 Allow NULL? 
45VF51FFBUVForecasted Budget Units - VarianceNumericGeneric Edit152 Allow NULL? 
46VF51FPENAVPending Over/Under Amount VarianceNumericGeneric Edit152 Allow NULL? 
47VF51FPENUVPending Over/Under Units VarianceNumericGeneric Edit152 Allow NULL? 
48VF51FCHGA2Pending Change Order Amount - PriorNumericGeneric Edit152 Allow NULL? 
49VF51FCHGAVPending Change Order Amount - VarianceNumericGeneric Edit152 Allow NULL? 
50VF51FCHGU2Pending Change Order Units - PriorNumericGeneric Edit152 Allow NULL? 
51VF51FCHGUVPending Change Order Units - VarianceNumericGeneric Edit152 Allow NULL? 
52VF51FJA02Revised Budget Amount - PriorNumericGeneric Edit152 Allow NULL? 
53VF51FJAVARRevised Budget Amount - VarianceNumericGeneric Edit152 Allow NULL? 
54VF51FJU02Revised Budget Units - PriorNumericGeneric Edit152 Allow NULL? 
55VF51FJUVARRevised Budget Units - VarianceNumericGeneric Edit152 Allow NULL? 
56VF51FFHAForecasted Projected Final AmountNumericGeneric Edit152 Allow NULL? 
57VF51FFHUForecasted Projected Final UnitsNumericGeneric Edit152 Allow NULL? 
58VF51FJA03Revised Budget Amount - CurrentNumericGeneric Edit152 Allow NULL? 
59VF51FJU03Revised Budget Units - CurrentNumericGeneric Edit152 Allow NULL? 
60VF51FLTVALUser Defined Amount Or UnitsNumericGeneric Edit152 Allow NULL? 
61VF51FLTV2User Defined Amount Or Units 2NumericGeneric Edit152 Allow NULL? 
62VF51FLTV3User Defined Amount Or Units 3NumericGeneric Edit152 Allow NULL? 
63VF51FLTV4User Defined Amount Or Units 4NumericGeneric Edit152 Allow NULL? 
64VF51FLTV5User Defined Amount Or Units 5NumericGeneric Edit152 Allow NULL? 
65VF51FLTV6User Defined Amount Or Units 6NumericGeneric Edit152 Allow NULL? 
66VF51FLTV7User Defined Amount Or Units 7NumericGeneric Edit152 Allow NULL? 
67VF51FLTV8User Defined Amount Or Units 8NumericGeneric Edit152 Allow NULL? 
68VF51FLTV9User Defined Amount Or Units 9NumericGeneric Edit152 Allow NULL? 
69VF51FLTV10User Defined Amount Or Units 10NumericGeneric Edit152 Allow NULL? 

TOP920 | 51F | F51F30W INDEXES

NumberDescription
1USER ForecastID AID (Primary/Unique)
ElementAliasDescriptionSequence
1USERUser IDAscending
251FFIDForecast IDAscending
3AIDAccount IDAscending