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
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

53 COLUMNS | 14 INDEXES | Print definition?920 | 49 | F4950 TABLE

49: Transportation Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F4950RT5314Routing EntriesMaster Files49: Transportation 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 RTORGN, RTADDO, RTCTRO, RTCARS, RTNMCU, RTRTN, RTMOT, RTCTY1, RTCOUN, RTADDS, RTADDZ, RTZON, RTCTR, RTCZON, RTSHAN, RTROUT, RTRSLA, RTDESC, RTFRSI, RTFRSC, RTFRCI, RTFRCG, RTCRCD, RTFRTP, RTRTGB, RTRTUM, RTDSTN, RTUMD1, RTLTDL, RTLTDT, RTPRFM, RTEFTJ, RTEXDJ, RTMCU, RTFCNM, RTURCD, RTURDT, RTURAT, RTURAB, RTURRF, RTUSER, RTPID, RTJOBN, RTUPMJ, RTTDAY, RTPRTE, RTCNMR, RTTX, RTTXA1, RTEXR1, RTTAX1, RTTXA2, RTEXR2 FROM F4950

TOP920 | 49 | F4950 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1RTORGNOrigin Address NumberNumericGeneric Edit80 Allow NULL? 
2RTADDOPostal Code - OriginStringGeneric Edit120 Allow NULL? 
3RTCTROOriginCountryStringUDC (00 CN)30 Allow NULL? 
4RTCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
5RTNMCUShipment DepotStringGeneric Edit120 Allow NULL? 
6RTRTNRoute NumberNumericGeneric Edit80 Allow NULL? 
7RTMOTMode of TransportStringUDC (00 TM)30 Allow NULL? 
8RTCTY1CityStringGeneric Edit250 Allow NULL? 
9RTCOUNCountyStringUDC (00 CT)250 Allow NULL? 
10RTADDSStateStringUDC (00 S)30 Allow NULL? 
11RTADDZPostal CodeStringGeneric Edit120 Allow NULL? 
12RTZONZone NumberStringUDC (40 ZN)30 Allow NULL? 
13RTCTRCountryStringUDC (00 CN)30 Allow NULL? 
14RTCZONCarrier ZoneStringUDC (49 CF)100 Allow NULL? 
15RTSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
16RTROUTRoute CodeStringUDC (42 RT)30 Allow NULL? 
17RTRSLARoute Selection AllowedStringGeneric Edit10 Allow NULL? 
18RTDESCDescriptionStringGeneric Edit300 Allow NULL? 
19RTFRSIInbound Freight Rate ScheduleStringUDC (49 BK)80 Allow NULL? 
20RTFRSCFreight Rate ScheduleStringUDC (49 BK)80 Allow NULL? 
21RTFRCIRate - Inbound Freight Charge RateNumericGeneric Edit154 Allow NULL? 
22RTFRCGRate - Freight Charge RateNumericGeneric Edit154 Allow NULL? 
23RTCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
24RTFRTPRate TypeCharacterUDC (49 BN)10 Allow NULL? 
25RTRTGBRate BasisCharacterUDC (49 CD)10 Allow NULL? 
26RTRTUMUnit of Measure - RateStringUDC (00 UM)20 Allow NULL? 
27RTDSTNDistanceNumericGeneric Edit50 Allow NULL? 
28RTUMD1Unit of Measure - DistanceStringUDC (00 UM)20 Allow NULL? 
29RTLTDLLead DaysNumericGeneric Edit50 Allow NULL? 
30RTLTDTTransit DaysNumericGeneric Edit50 Allow NULL? 
31RTPRFMPerformance RatingNumericGeneric Edit30 Allow NULL? 
32RTEFTJDate - EffectiveDateGeneric Edit60
33RTEXDJDate - ExpiredDateGeneric Edit60
34RTMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
35RTFCNMFunction NameStringGeneric Edit320 Allow NULL? 
36RTURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
37RTURDTUser Reserved DateDateGeneric Edit60
38RTURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
39RTURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
40RTURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
41RTUSERUser IDStringGeneric Edit100 Allow NULL? 
42RTPIDProgram IDStringGeneric Edit100 Allow NULL? 
43RTJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
44RTUPMJDate - UpdatedDateGeneric Edit60
45RTTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
46RTPRTEParent RouteCharacterGeneric Edit10 Allow NULL? 
47RTCNMRContract NumberStringGeneric Edit240 Allow NULL? 
48RTTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
49RTTXA1Tax Rate/AreaStringGeneric Edit100 Allow NULL? 
50RTEXR1Tax Expl Code 1StringUDC (00 EX)20 Allow NULL? 
51RTTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
52RTTXA2Tax Rate/Area 2StringGeneric Edit100 Allow NULL? 
53RTEXR2Tax Expl Code 2StringUDC (00 EX)20 Allow NULL? 

TOP920 | 49 | F4950 INDEXES

NumberDescription
2Route Number (Primary/Unique)
ElementAliasDescriptionSequence
1RTNRoute NumberAscending
6Routing Rule 2
ElementAliasDescriptionSequence
1ROUTRoute CodeAscending
9Routing Rule 3
ElementAliasDescriptionSequence
1ADDZPostal CodeAscending
2CTRCountryAscending
10Routing Rule 1
ElementAliasDescriptionSequence
1SHANAddress Number - Ship ToAscending
11Routing Rule 4
ElementAliasDescriptionSequence
1CZONCarrier ZoneAscending
12Routing Rule 5
ElementAliasDescriptionSequence
1CTY1CityAscending
2ADDSStateAscending
3CTRCountryAscending
13Routing Rule 6
ElementAliasDescriptionSequence
1COUNCountyAscending
2ADDSStateAscending
3CTRCountryAscending
14Routing Rule 7
ElementAliasDescriptionSequence
1ADDSStateAscending
2CTRCountryAscending
15Routing Rule 8
ElementAliasDescriptionSequence
1ZONZone NumberAscending
16Routing Rule 9
ElementAliasDescriptionSequence
1CTRCountryAscending
17Destination
ElementAliasDescriptionSequence
1CTY1CityAscending
2COUNCountyAscending
3ADDSStateAscending
4CTRCountryAscending
5ADDZPostal CodeAscending
6ZONZone NumberAscending
7CZONCarrier ZoneAscending
8SHANAddress Number - Ship ToAscending
9ROUTRoute CodeAscending
18Origin Address Number
ElementAliasDescriptionSequence
1ORGNOrigin Address NumberAscending
19Origin Depot
ElementAliasDescriptionSequence
1NMCUShipment DepotAscending
20Origin Postal Code
ElementAliasDescriptionSequence
1ADDOPostal Code - OriginAscending