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

48 COLUMNS | 1 INDEXES | Print definition?910 | 42W | F4277711 TABLE

42W: Fulfillment Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4277711RD481Service Level Rule DetailFiles42W: Fulfillment 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 RDKCOO, RDDOCO, RDDCTO, RDLNID, RDOSEQ, RDSLRULTYP, RDLNMNFLPR, RDSLOVRCD, RDLINSLMET, RDORMNFLPR, RDORDSLMET, RDSLCUSTFN, RDSLRELNUM, RDSLCANCEL, RDSLCNOVRD, RDSLPRTCOM, RDRQDQTY, RDSLORILIN, RDSLMTRLCH, RDSLRCHAR1, RDSLRCHAR2, RDSLRCHAR3, RDSLRSTRG1, RDSLRSTRG2, RDSLRSTRG3, RDSLRAMNT1, RDSLRAMNT2, RDSLRAMNT3, RDSLRNUMB1, RDSLRNUMB2, RDSLRNUMB3, RDSLRDATE1, RDSLRDATE2, RDSLRDATE3, RDSLRCODE1, RDSLRCODE2, RDSLRCODE3, RDURCD, RDURDT, RDURAT, RDURAB, RDURRF, RDUSER, RDPID, RDJOBN, RDUPMJ, RDTDAY, RDUTIME FROM F4277711

TOP910 | 42W | F4277711 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1RDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
2RDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
3RDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
4RDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5RDOSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
6RDSLRULTYPService Level Rule TypeStringUDC (42W RT)20 Allow NULL? 
7RDLNMNFLPRLine Minimum Fill PercentageNumericGeneric Edit154 Allow NULL? 
8RDSLOVRCDService Level Override Reason CodeStringUDC (42W RC)30 Allow NULL? 
9RDLINSLMETLine Service Level MetCharacterCheck Box10 Allow NULL? 
10RDORMNFLPROrder Minimum Fill PercentageNumericGeneric Edit154 Allow NULL? 
11RDORDSLMETOrder Service Level MetCharacterCheck Box10 Allow NULL? 
12RDSLCUSTFNService Level Custom FunctionStringGeneric Edit320 Allow NULL? 
13RDSLRELNUMService Level Release NumberNumericGeneric Edit60 Allow NULL? 
14RDSLCANCELService Level Cancel YNCharacterGeneric Edit10 Allow NULL? 
15RDSLCNOVRDService Level Cancel OverrideCharacterGeneric Edit10 Allow NULL? 
16RDSLPRTCOMService Level Partial CommitCharacterGeneric Edit10 Allow NULL? 
17RDRQDQTYRequested QuantityNumericGeneric Edit154 Allow NULL? 
18RDSLORILINService Level Original Line NumberNumericGeneric Edit63 Allow NULL? 
19RDSLMTRLCHService Level Rule Evaluation RequiredCharacterGeneric Edit10 Allow NULL? 
20RDSLRCHAR1Service Level Rule Character 1CharacterGeneric Edit10 Allow NULL? 
21RDSLRCHAR2Service Level Rule Character 2CharacterGeneric Edit10 Allow NULL? 
22RDSLRCHAR3Service Level Rule Character 3CharacterGeneric Edit10 Allow NULL? 
23RDSLRSTRG1Service Level Rule String 1StringGeneric Edit300 Allow NULL? 
24RDSLRSTRG2Service Level Rule String 2StringGeneric Edit300 Allow NULL? 
25RDSLRSTRG3Service Level Rule String 3StringGeneric Edit300 Allow NULL? 
26RDSLRAMNT1Service Level Rule Amount 1NumericGeneric Edit154 Allow NULL? 
27RDSLRAMNT2Service Level Rule Amount 2NumericGeneric Edit154 Allow NULL? 
28RDSLRAMNT3Service Level Rule Amount 3NumericGeneric Edit154 Allow NULL? 
29RDSLRNUMB1Service Level Rule Number 1NumericGeneric Edit80 Allow NULL? 
30RDSLRNUMB2Service Level Rule Number 2NumericGeneric Edit80 Allow NULL? 
31RDSLRNUMB3Service Level Rule Number 3NumericGeneric Edit80 Allow NULL? 
32RDSLRDATE1Service Level Rule Julian Date 1DateGeneric Edit60
33RDSLRDATE2Service Level Rule Julian Date 2DateGeneric Edit60
34RDSLRDATE3Service Level Rule Julian Date 3DateGeneric Edit60
35RDSLRCODE1Service Level Rule Code 1StringGeneric Edit20 Allow NULL? 
36RDSLRCODE2Service Level Rule Code 2StringGeneric Edit20 Allow NULL? 
37RDSLRCODE3Service Level Rule Code 3StringGeneric Edit20 Allow NULL? 
38RDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
39RDURDTUser Reserved DateDateGeneric Edit60
40RDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
41RDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
42RDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
43RDUSERUser IDStringGeneric Edit100 Allow NULL? 
44RDPIDProgram IDStringGeneric Edit100 Allow NULL? 
45RDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
46RDUPMJDate - UpdatedDateGeneric Edit60
47RDTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
48RDUTIMEUpdate Date and TimeJDE UTimeGeneric Edit110

TOP910 | 42W | F4277711 INDEXES

NumberDescription
1Order Number Order Type +A (Primary/Unique)
ElementAliasDescriptionSequence
1KCOOOrder Company (Order Number)Ascending
2DOCODocument (Order No Invoice etc.)Ascending
3DCTOOrder TypeAscending
4LNIDLine NumberAscending