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

40 COLUMNS | 5 INDEXES | Print definition?812 | 51 | F5144 TABLE

51: Job Costing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F5144G7405Profit RecognitionHistory Files51: Job CostingAS400 Coexistence Tables
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 G7VERS, G7MCU, G7SBL, G7SBLT, G7DEF, G7RECM, G7TYRE, G7NNBR, G7PTTH, G7PTPC, G7COB, G7ROB, G7CCH, G7RCH, G7CATD, G7RATD, G7CPF, G7CPFA, G7RPF, G7RPFA, G7STML, G7CJTD, G7RJTD, G7CEPY, G7REPY, G7CEPQ, G7REPQ, G7CEPM, G7REPM, G7ZFU1, G7ZFU2, G7ZFU3, G7ULCK, G7DGEN, G7USER, G7PID, G7UPMJ, G7JOBN, G7UPMT, G7VER FROM F5144

TOP812 | 51 | F5144 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1G7VERSVersion HistoryStringGeneric Edit100 Allow NULL? 
2G7MCUBusiness UnitStringGeneric Edit120 Allow NULL? 
3G7SBLSubledger - G/LStringGeneric Edit80 Allow NULL? 
4G7SBLTSubledger TypeCharacterUDC (00 ST)10 Allow NULL? 
5G7DEFDate - EffectiveDateGeneric Edit60
6G7RECMMethod of RecognitionCharacterUDC (H50 RE)10 Allow NULL? 
7G7TYREType of RecordCharacterUDC (H50 TY)10 Allow NULL? 
8G7NNBRNext NumberNumericGeneric Edit90 Allow NULL? 
9G7PTTHDeferred Profit Recognizing MethodCharacterUDC (H50 PT)10 Allow NULL? 
10G7PTPCProfit Threshold PercentNumericGeneric Edit52 Allow NULL? 
11G7COBAmount - Original Cost BudgetNumericGeneric Edit152 Allow NULL? 
12G7ROBAmount - Original Revenue BudgetNumericGeneric Edit152 Allow NULL? 
13G7CCHCost ChangesNumericGeneric Edit152 Allow NULL? 
14G7RCHRevenue ChangesNumericGeneric Edit152 Allow NULL? 
15G7CATDActual Cost To DateNumericGeneric Edit152 Allow NULL? 
16G7RATDActual Revenue To DateNumericGeneric Edit152 Allow NULL? 
17G7CPFProjected Final CostNumericGeneric Edit152 Allow NULL? 
18G7CPFAProjected Final Cost AdjustedNumericGeneric Edit152 Allow NULL? 
19G7RPFProjected Final RevenueNumericGeneric Edit152 Allow NULL? 
20G7RPFAProjected Final Revenue AdjustedNumericGeneric Edit152 Allow NULL? 
21G7STMLAccrual/Deferral (Stored Materials)NumericGeneric Edit152 Allow NULL? 
22G7CJTDEarned Job To Date CostNumericGeneric Edit152 Allow NULL? 
23G7RJTDEarned Job To Date RevenueNumericGeneric Edit152 Allow NULL? 
24G7CEPYCost Earned End of Prior YearNumericGeneric Edit152 Allow NULL? 
25G7REPYRevn Earned End of Prior YearNumericGeneric Edit152 Allow NULL? 
26G7CEPQCost Earned End of Prior QuaterNumericGeneric Edit152 Allow NULL? 
27G7REPQRevenue Earned End of Prior QuaterNumericGeneric Edit152 Allow NULL? 
28G7CEPMCost Earned End of Prior PeriodNumericGeneric Edit152 Allow NULL? 
29G7REPMRevenue Earned End of Prior MonthNumericGeneric Edit152 Allow NULL? 
30G7ZFU1Record Requires Regeneration Y/NCharacterGeneric Edit10 Allow NULL? 
31G7ZFU2Future Use 2CharacterGeneric Edit10 Allow NULL? 
32G7ZFU3Future Use 3CharacterGeneric Edit10 Allow NULL? 
33G7ULCKUser ID - Profit Recognition LockStringGeneric Edit100 Allow NULL? 
34G7DGENDate - GenerationDateGeneric Edit60
35G7USERUser IDStringGeneric Edit100 Allow NULL? 
36G7PIDProgram IDStringGeneric Edit100 Allow NULL? 
37G7UPMJDate - UpdatedDateGeneric Edit60
38G7JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
39G7UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
40G7VERVersionStringGeneric Edit100 Allow NULL? 

TOP812 | 51 | F5144 INDEXES

NumberDescription
1Version Job A+ (Primary/Unique)
ElementAliasDescriptionSequence
1VERSVersion HistoryAscending
2MCUBusiness UnitAscending
3SBLSubledger - G/LAscending
4SBLTSubledger TypeAscending
5DEFDate - EffectiveAscending
6TYREType of RecordAscending
3Job Effective Date
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2DEFDate - EffectiveDescending
4Job Eff Dat SBL Rec Type
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2SBLSubledger - G/LAscending
3SBLTSubledger TypeAscending
4DEFDate - EffectiveAscending
5TYREType of RecordAscending
5Job EffDate RecTyp
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2DEFDate - EffectiveAscending
3TYREType of RecordAscending
6EffDate NN
ElementAliasDescriptionSequence
1DEFDate - EffectiveAscending
2NNBRNext NumberAscending