JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

70 COLUMNS | 4 INDEXES | Print definition?920 | 40 | F40051 TABLE

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F40051RD704Return Material AuthorizationMaster Files42B: Sales Order EntryBusiness 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 RDRORN, RDRCTO, RDRKCO, RDRLLN, RDRMAST, RDABCX, RDWHO, RDDL01, RDPHN1, RDAR1, RDISNO, RDDCTI, RDDOCZ, RDDOC, RDDCT, RDKCO, RDOGNO, RDDOCO, RDDCTO, RDKCOO, RDLNID, RDAN8, RDSHAN, RDOORN, RDOKCO, RDOCTO, RDPOLN, RDSFXO, RDITM, RDLITM, RDUOM, RDUORG, RDUPRC, RDAEXP, RDDRQJ, RDNUMB, RDDCD1, RDCPIT, RDCPIL, RDTRQT, RDEXPJ, RDAAID, RDDCD2, RDRCD1, RDTKBY, RDMMCU, RDURDT, RDURCD, RDURAB, RDURAT, RDURRF, RDUSER, RDPID, RDJOBN, RDCRTU, RDUPMJ, RDUPMT, RDSERN, RDLOTN, RDSOCLM, RDRTRND, RDRPRBL, RDDCFR, RDVR01, RDMCU2, RDMCU3, RDMCU4, RDMCU5, RDDOC1, RDDCT4 FROM F40051

TOP920 | 40 | F40051 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1RDRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
2RDRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
3RDRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
4RDRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
5RDRMASTReturned Material StatusStringUDC (40 RN)30 Allow NULL? 
6RDABCXDate - EffectiveDateGeneric Edit60
7RDWHOContact NameStringGeneric Edit1200 Allow NULL? 
8RDDL01DescriptionStringGeneric Edit300 Allow NULL? 
9RDPHN1Phone NumberStringGeneric Edit200 Allow NULL? 
10RDAR1Phone PrefixStringGeneric Edit60 Allow NULL? 
11RDISNOIssue NumberNumericGeneric Edit80 Allow NULL? 
12RDDCTIDocument Type - Invoice OnlyStringUDC (00 DI)20 Allow NULL? 
13RDDOCZDocument (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
14RDDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
15RDDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
16RDKCODocument CompanyStringGeneric Edit50 Allow NULL? 
17RDOGNOOriginal Line NumberNumericGeneric Edit73 Allow NULL? 
18RDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
19RDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
20RDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
21RDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
22RDAN8Address NumberNumericGeneric Edit80 Allow NULL? 
23RDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
24RDOORNOriginal Order NumberStringGeneric Edit80 Allow NULL? 
25RDOKCODocument Company (Original Order)StringGeneric Edit50 Allow NULL? 
26RDOCTOOriginal Order TypeStringUDC (00 DT)20 Allow NULL? 
27RDPOLNPurchase Order Line NumberNumericGeneric Edit73 Allow NULL? 
28RDSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
29RDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
30RDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
31RDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
32RDUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
33RDUPRCAmount - Price per UnitNumericGeneric Edit154 Allow NULL? 
34RDAEXPAmount - Extended PriceNumericGeneric Edit152 Allow NULL? 
35RDDRQJDate - RequestedDateGeneric Edit60
36RDNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
37RDDCD1Disposition Code 1StringUDC (17 P1)30 Allow NULL? 
38RDCPITComponent Item Number - ShortNumericGeneric Edit80 Allow NULL? 
39RDCPILComponent 2nd Item NumberStringGeneric Edit250 Allow NULL? 
40RDTRQTQuantity AvailableNumericGeneric Edit150 Allow NULL? 
41RDEXPJDate - Expected (Julian)DateGeneric Edit60
42RDAAIDParent NumberNumericGeneric Edit80 Allow NULL? 
43RDDCD2Disposition Code 2StringUDC (17 P2)30 Allow NULL? 
44RDRCD1Returned ReasonStringUDC (42 RC)30 Allow NULL? 
45RDTKBYOrder Taken ByStringGeneric Edit100 Allow NULL? 
46RDMMCUBranchStringGeneric Edit120 Allow NULL? 
47RDURDTUser Reserved DateDateGeneric Edit60
48RDURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
49RDURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
50RDURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
51RDURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
52RDUSERUser IDStringGeneric Edit100 Allow NULL? 
53RDPIDProgram IDStringGeneric Edit100 Allow NULL? 
54RDJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
55RDCRTUCreated by userStringGeneric Edit100 Allow NULL? 
56RDUPMJDate - UpdatedDateGeneric Edit60
57RDUPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 
58RDSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
59RDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
60RDSOCLMService Order ClaimStringGeneric Edit250 Allow NULL? 
61RDRTRNDReturnable FlagCharacterUDC (17 TF)10 Allow NULL? 
62RDRPRBLRepairable FlagCharacterUDC (17 TF)10 Allow NULL? 
63RDDCFRDocument Created for RMACharacterGeneric Edit10 Allow NULL? 
64RDVR01ReferenceStringGeneric Edit250 Allow NULL? 
65RDMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
66RDMCU3Business UnitStringGeneric Edit120 Allow NULL? 
67RDMCU4Business UnitStringGeneric Edit120 Allow NULL? 
68RDMCU5Business Unit - CostStringGeneric Edit120 Allow NULL? 
69RDDOC1Document (Order # Invoice etc.)NumericGeneric Edit80 Allow NULL? 
70RDDCT4Document TypeStringUDC (00 DT)20 Allow NULL? 

TOP920 | 40 | F40051 INDEXES

NumberDescription
1RMA Number Type Line (Primary/Unique)
ElementAliasDescriptionSequence
1RORNRelated PO/SO/WO NumberAscending
2RCTORelated PO/SO/WO Order TypeAscending
3RKCOCompany - Key (Related Order)Ascending
4RLLNRelated PO/SO Line NumberAscending
2RMA Number Type Line D
ElementAliasDescriptionSequence
1RORNRelated PO/SO/WO NumberAscending
2RKCOCompany - Key (Related Order)Ascending
3RCTORelated PO/SO/WO Order TypeAscending
4RLLNRelated PO/SO Line NumberDescending
3Service Order No
ElementAliasDescriptionSequence
1DOCDocument (Voucher Invoice etc.)Ascending
5OrdDoc# DocTyp KeyCom Line#
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending