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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

76 COLUMNS | 1 INDEXES | Print definition?920 | 32 | F3282 TABLE

32: Configuration Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F3282RK761Configured Item/Rules Table Cross ReferenceExtra Features Files32: Configuration ManagementBusiness Data
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 RKMCU, RKTBLC, RKRTBT, RKKIT, RKEFFF, RKEFFT, RKPEL1, RKSIT1, RKTMC1, RKPEL2, RKSIT2, RKTMC2, RKPEL3, RKSIT3, RKTMC3, RKPEL4, RKSIT4, RKTMC4, RKPEL5, RKSIT5, RKTMC5, RKPEL6, RKSIT6, RKTMC6, RKPEL7, RKSIT7, RKTMC7, RKPEL8, RKSIT8, RKTMC8, RKPEL9, RKSIT9, RKTMC9, RKPEL0, RKSIT0, RKTMC0, RKPEL11, RKSIT11, RKTMC11, RKPEL12, RKSIT12, RKTMC12, RKPEL13, RKSIT13, RKTMC13, RKPEL14, RKSIT14, RKTMC14, RKPEL15, RKSIT15, RKTMC15, RKPEL16, RKSIT16, RKTMC16, RKPEL17, RKSIT17, RKTMC17, RKPEL18, RKSIT18, RKTMC18, RKPEL19, RKSIT19, RKTMC19, RKPEL20, RKSIT20, RKTMC20, RKURCD, RKURDT, RKURAT, RKURAB, RKURRF, RKUSER, RKPID, RKJOBN, RKUPMJ, RKTDAY FROM F3282

TOP920 | 32 | F3282 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1RKMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
2RKTBLCRules Table NameStringUDC (32 TN)100 Allow NULL? 
3RKRTBTRule Table TypeCharacterUDC (32 TT)10 Allow NULL? 
4RKKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
5RKEFFFEffective - From DateDateGeneric Edit60
6RKEFFTEffective - Thru DateDateGeneric Edit60
7RKPEL1Number - Segment Number 1NumericGeneric Edit50 Allow NULL? 
8RKSIT1Item Number - Table Segment 1NumericGeneric Edit80 Allow NULL? 
9RKTMC1Table Segment Branch 1StringGeneric Edit120 Allow NULL? 
10RKPEL2Number - Segment Number 2NumericGeneric Edit50 Allow NULL? 
11RKSIT2Item Number - Table Segment 2NumericGeneric Edit80 Allow NULL? 
12RKTMC2Table Segment Branch 2StringGeneric Edit120 Allow NULL? 
13RKPEL3Number - Segment Number 3NumericGeneric Edit50 Allow NULL? 
14RKSIT3Item Number - Table Segment 3NumericGeneric Edit80 Allow NULL? 
15RKTMC3Table Segment Branch 3StringGeneric Edit120 Allow NULL? 
16RKPEL4Number - Segment Number 4NumericGeneric Edit50 Allow NULL? 
17RKSIT4Item Number - Table Segment 4NumericGeneric Edit80 Allow NULL? 
18RKTMC4Table Segment Branch 4StringGeneric Edit120 Allow NULL? 
19RKPEL5Number - Segment Number 5NumericGeneric Edit50 Allow NULL? 
20RKSIT5Item Number - Table Segment 5NumericGeneric Edit80 Allow NULL? 
21RKTMC5Table Segment Branch 5StringGeneric Edit120 Allow NULL? 
22RKPEL6Number - Segment Number 6NumericGeneric Edit50 Allow NULL? 
23RKSIT6Item Number - Table Segment 6NumericGeneric Edit80 Allow NULL? 
24RKTMC6Table Segment Branch 6StringGeneric Edit120 Allow NULL? 
25RKPEL7Number - Segment Number 7NumericGeneric Edit50 Allow NULL? 
26RKSIT7Item Number - Table Segment 7NumericGeneric Edit80 Allow NULL? 
27RKTMC7Table Segment Branch 7StringGeneric Edit120 Allow NULL? 
28RKPEL8Number - Segment Number 8NumericGeneric Edit50 Allow NULL? 
29RKSIT8Item Number - Table Segment 8NumericGeneric Edit80 Allow NULL? 
30RKTMC8Table Segment Branch 8StringGeneric Edit120 Allow NULL? 
31RKPEL9Number - Segment Number 9NumericGeneric Edit50 Allow NULL? 
32RKSIT9Item Number - Table Segment 9NumericGeneric Edit80 Allow NULL? 
33RKTMC9Table Segment Branch 9StringGeneric Edit120 Allow NULL? 
34RKPEL0Number - Segment Number 10NumericGeneric Edit50 Allow NULL? 
35RKSIT0Item Number - Table Segment 10NumericGeneric Edit80 Allow NULL? 
36RKTMC0Table Segment Branch 10StringGeneric Edit120 Allow NULL? 
37RKPEL11Number - Segment Number 11NumericGeneric Edit50 Allow NULL? 
38RKSIT11Item Number - Table Segment 11NumericGeneric Edit80 Allow NULL? 
39RKTMC11Table Segment Branch 11StringGeneric Edit120 Allow NULL? 
40RKPEL12Number - Segment Number 12NumericGeneric Edit50 Allow NULL? 
41RKSIT12Item Number - Table Segment 12NumericGeneric Edit80 Allow NULL? 
42RKTMC12Table Segment Branch 12StringGeneric Edit120 Allow NULL? 
43RKPEL13Number - Segment Number 13NumericGeneric Edit50 Allow NULL? 
44RKSIT13Item Number - Table Segment 13NumericGeneric Edit80 Allow NULL? 
45RKTMC13Table Segment Branch 13StringGeneric Edit120 Allow NULL? 
46RKPEL14Number - Segment Number 14NumericGeneric Edit50 Allow NULL? 
47RKSIT14Item Number - Table Segment 14NumericGeneric Edit80 Allow NULL? 
48RKTMC14Table Segment Branch 14StringGeneric Edit120 Allow NULL? 
49RKPEL15Number - Segment Number 15NumericGeneric Edit50 Allow NULL? 
50RKSIT15Item Number - Table Segment 15NumericGeneric Edit80 Allow NULL? 
51RKTMC15Table Segment Branch 15StringGeneric Edit120 Allow NULL? 
52RKPEL16Number - Segment Number 16NumericGeneric Edit50 Allow NULL? 
53RKSIT16Item Number - Table Segment 16NumericGeneric Edit80 Allow NULL? 
54RKTMC16Table Segment Branch 16StringGeneric Edit120 Allow NULL? 
55RKPEL17Number - Segment Number 17NumericGeneric Edit50 Allow NULL? 
56RKSIT17Item Number - Table Segment 17NumericGeneric Edit80 Allow NULL? 
57RKTMC17Table Segment Branch 17StringGeneric Edit120 Allow NULL? 
58RKPEL18Number - Segment Number 18NumericGeneric Edit50 Allow NULL? 
59RKSIT18Item Number - Table Segment 18NumericGeneric Edit80 Allow NULL? 
60RKTMC18Table Segment Branch 18StringGeneric Edit120 Allow NULL? 
61RKPEL19Number - Segment Number 19NumericGeneric Edit50 Allow NULL? 
62RKSIT19Item Number - Table Segment 19NumericGeneric Edit80 Allow NULL? 
63RKTMC19Table Segment Branch 19StringGeneric Edit120 Allow NULL? 
64RKPEL20Number - Segment Number 20NumericGeneric Edit50 Allow NULL? 
65RKSIT20Item Number - Table Segment 20NumericGeneric Edit80 Allow NULL? 
66RKTMC20Table Segment Branch 20StringGeneric Edit120 Allow NULL? 
67RKURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
68RKURDTUser Reserved DateDateGeneric Edit60
69RKURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
70RKURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
71RKURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
72RKUSERUser IDStringGeneric Edit100 Allow NULL? 
73RKPIDProgram IDStringGeneric Edit100 Allow NULL? 
74RKJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
75RKUPMJDate - UpdatedDateGeneric Edit60
76RKTDAYTime of DayNumericGeneric Edit60 Allow NULL? 

TOP920 | 32 | F3282 INDEXES

NumberDescription
1Rules Table Business Unit +A (Primary/Unique)
ElementAliasDescriptionSequence
1TBLCRules Table NameAscending
2MCUBusiness UnitAscending
3RTBTRule Table TypeAscending
4KITParent (short) Item NumberAscending