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

98 COLUMNS | 7 INDEXES | Print definition?920 | 34X | F34X200W TABLE

34X: In-Memory Planning Advisor
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F34X200WSD987Planning Details Supply/Demand Work TableFiles34X: In-Memory Planning Advisor
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 SDUSER, SDJOBS, SDITM, SDMCU, SD34XSDDJ, SD34XSDDJU, SD34XSDC, SD34XSDDS, SD34XSDC1, SDDOCO, SDDCTO, SDKCOO, SDSFXO, SDLNID, SD34XSDC2, SD34XUKID1, SD34XUKID4, SDUOM, SDLOCN, SDLOTN, SDSTRT, SD34XSTRJU, SDDRQJ, SD34XDRQJU, SDTRDJ, SDPDDJ, SDDLEJ, SDMMEJ, SD34XSDQ, SD34XSDQU, SDUOPN, SDUORG, SDUCHG, SDSOCN, SDQTYT, SDSOQS, SDQTYO, SDTRQT, SDQNTA, SDFQT, SDAN8, SD34XVENDU, SDSRST, SDUNCD, SDDL01, SDRORN, SDRCTO, SDRKCO, SDRLLN, SDPRJM, SD34XPRJMU, SDPNS, SDPMPN, SD34XPMPNU, SDROSID, SDROID, SDSY, SDOIND, SDWODTF, SDLOTP, SDTBM, SDRTG, SDSHPP, SDPARS, SDACTO, SDYR, SDMWDH, SDSHAN, SDSO11, SD34XUKID2, SD34XUKID3, SDKIT, SDSRDM, SDLOVD, SDPLNK, SDPQOH, SDQTTR, SDQTIN, SDQTO1, SDQTO2, SD34XEXLQ, SD34XHLQ, SD34XPDSQ, SDMMCU, SDLOTG, SD34XSDQP, SD34XSDQPU, SD34XQCF, SD34XDCF, SD34XDSPF, SD34XEXCF, SDNXTR, SDLTTR, SD34XIMPL, SDUPMJ, SD34XLATN, SD34XAA, SD34XUA FROM F34X200W

TOP920 | 34X | F34X200W COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SDUSERUser IDStringGeneric Edit100 Allow NULL? 
2SDJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
3SDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
4SDMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
5SD34XSDDJUnadjusted DateDateGeneric Edit60
6SD34XSDDJUAdjusted DateDateGeneric Edit60
7SD34XSDCSupply Demand CodeCharacterGeneric Edit10 Allow NULL? 
8SD34XSDDSSupply Demand DescriptionCharacterUDC (34X SD)10 Allow NULL? 
9SD34XSDC1Supply Demand Category 1StringUDC (34X C1)30 Allow NULL? 
10SDDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
11SDDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
12SDKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
13SDSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
14SDLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
15SD34XSDC2Supply/Demand String KeyStringGeneric Edit400 Allow NULL? 
16SD34XUKID1Unique Key ID Internal New OrderNumericGeneric Edit150 Allow NULL? 
17SD34XUKID4Supply/Demand Numeric KeyNumericGeneric Edit150 Allow NULL? 
18SDUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
19SDLOCNLocationStringGeneric Edit200 Allow NULL? 
20SDLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
21SDSTRTDate - Start (Julian)DateGeneric Edit60
22SD34XSTRJUAdjusted Start DateDateGeneric Edit60
23SDDRQJDate - RequestedDateGeneric Edit60
24SD34XDRQJUAdjusted Request DateDateGeneric Edit60
25SDTRDJDate - Order/TransactionDateGeneric Edit60
26SDPDDJDate - Scheduled PickDateGeneric Edit60
27SDDLEJLot Effectivity DateDateGeneric Edit60
28SDMMEJDate - Lot ExpirationDateGeneric Edit60
29SD34XSDQUnadjusted QuantityNumericGeneric Edit150 Allow NULL? 
30SD34XSDQUAdjusted QuantityNumericGeneric Edit150 Allow NULL? 
31SDUOPNUnits - OpenNumericGeneric Edit150 Allow NULL? 
32SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
33SDUCHGUnits - On HoldNumericGeneric Edit150 Allow NULL? 
34SDSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
35SDQTYTUnits - Shipped to DateNumericGeneric Edit150 Allow NULL? 
36SDSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
37SDQTYOUnits - At OperationNumericGeneric Edit150 Allow NULL? 
38SDTRQTQuantity AvailableNumericGeneric Edit150 Allow NULL? 
39SDQNTAUnits - Quantity CommitedNumericGeneric Edit150 Allow NULL? 
40SDFQTQuantity - ForecastNumericGeneric Edit150 Allow NULL? 
41SDAN8Address NumberNumericGeneric Edit80 Allow NULL? 
42SD34XVENDUOverride Supplier NumberNumericGeneric Edit80 Allow NULL? 
43SDSRSTStatus Code W.O.StringUDC (00 SS)20 Allow NULL? 
44SDUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
45SDDL01DescriptionStringGeneric Edit300 Allow NULL? 
46SDRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
47SDRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
48SDRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
49SDRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
50SDPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
51SD34XPRJMUOverride Project NumberNumericGeneric Edit80 Allow NULL? 
52SDPNSProduction Number ShortNumericGeneric Edit100 Allow NULL? 
53SDPMPNProduction NumberStringGeneric Edit300 Allow NULL? 
54SD34XPMPNUOverride Production NumberStringGeneric Edit300 Allow NULL? 
55SDROSIDRelated Order Set IdentifierNumericGeneric Edit150 Allow NULL? 
56SDROIDRelated Order IdentifierNumericGeneric Edit80 Allow NULL? 
57SDSYProduct CodeStringUDC (98 SY)40 Allow NULL? 
58SDOINDOrder IndicatorNumericGeneric Edit80 Allow NULL? 
59SDWODTFWork Order Type FlagCharacterGeneric Edit10 Allow NULL? 
60SDLOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
61SDTBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
62SDRTGRoute Sheet (N)CharacterGeneric Edit10 Allow NULL? 
63SDSHPPShip This PhaseCharacterUDC (00 ZO)10 Allow NULL? 
64SDPARSNumber - Parent WO NumberStringGeneric Edit80 Allow NULL? 
65SDACTOActive Operation (Y/N)CharacterGeneric Edit10 Allow NULL? 
66SDYRYear - Calendar YearNumericGeneric Edit20 Allow NULL? 
67SDMWDHMonth/Week/Day/ShiftCharacterUDC (31 RP)10 Allow NULL? 
68SDSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
69SDSO11Transfer/Direct Ship/Intercompany FlagCharacterGeneric Edit10 Allow NULL? 
70SD34XUKID2Unique Key ID Internal Update QuantityNumericGeneric Edit150 Allow NULL? 
71SD34XUKID3Unique Key ID Internal Update DateNumericGeneric Edit150 Allow NULL? 
72SDKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
73SDSRDMSource Demand for ReplenishmentNumericGeneric Edit80 Allow NULL? 
74SDLOVDLeadtime Offset DaysNumericGeneric Edit60 Allow NULL? 
75SDPLNKPegging Record Link (Internal)NumericGeneric Edit150 Allow NULL? 
76SDPQOHQuantity on Hand - Primary unitsNumericGeneric Edit150 Allow NULL? 
77SDQTTRUnits - In Transit - Primary unitsNumericGeneric Edit150 Allow NULL? 
78SDQTINUnits - In Inspection - Primary unitsNumericGeneric Edit150 Allow NULL? 
79SDQTO1Units - In Operation 1 - Primary unitsNumericGeneric Edit150 Allow NULL? 
80SDQTO2Units - In Operation 2 - Primary unitsNumericGeneric Edit150 Allow NULL? 
81SD34XEXLQExpired Lots QuantityNumericGeneric Edit150 Allow NULL? 
82SD34XHLQHeld Lots QuantityNumericGeneric Edit150 Allow NULL? 
83SD34XPDSQPast Due Supply QuantityNumericGeneric Edit150 Allow NULL? 
84SDMMCUBranchStringGeneric Edit120 Allow NULL? 
85SDLOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
86SD34XSDQPUnadjusted Quantity PrimaryNumericGeneric Edit150 Allow NULL? 
87SD34XSDQPUAdjusted Quantity PrimaryNumericGeneric Edit150 Allow NULL? 
88SD34XQCFQuantity Changed FlagCharacterGeneric Edit10 Allow NULL? 
89SD34XDCFDate Changed FlagCharacterGeneric Edit10 Allow NULL? 
90SD34XDSPFHide Record FlagCharacterGeneric Edit10 Allow NULL? 
91SD34XEXCFExclude From Chart FlagCharacterGeneric Edit10 Allow NULL? 
92SDNXTRStatus Code - NextStringUDC (40 AT)30 Allow NULL? 
93SDLTTRStatus Code - LastStringUDC (40 AT)30 Allow NULL? 
94SD34XIMPLImplement Supply Changes FlagCharacterGeneric Edit10 Allow NULL? 
95SDUPMJDate - UpdatedDateGeneric Edit60
96SD34XLATNLeadtime AlertIntegerGeneric Edit110 Allow NULL? 
97SD34XAAAdjusted Quantity AvailableNumericGeneric Edit150 Allow NULL? 
98SD34XUAUnadjusted Quantity AvailableNumericGeneric Edit150 Allow NULL? 

TOP920 | 34X | F34X200W INDEXES

NumberDescription
1USER JOBS ITM MCU 34XSDDJ + (Primary/Unique)
ElementAliasDescriptionSequence
1USERUser IDAscending
2JOBSJob NumberAscending
3ITMItem Number - ShortAscending
4MCUBusiness UnitAscending
534XSDDJUnadjusted DateAscending
634XSDC1Supply Demand Category 1Ascending
7DOCODocument (Order No Invoice etc.)Ascending
8DCTOOrder TypeAscending
9KCOOOrder Company (Order Number)Ascending
10SFXOOrder SuffixAscending
11LNIDLine NumberAscending
1234XSDC2Supply/Demand String KeyAscending
1334XUKID1Unique Key ID Internal New OrderAscending
1434XUKID4Supply/Demand Numeric KeyAscending
15UOMUnit of Measure as InputAscending
2USER JOBS ITM MCU 34XSDDJU +
ElementAliasDescriptionSequence
1USERUser IDAscending
2JOBSJob NumberAscending
3ITMItem Number - ShortAscending
4MCUBusiness UnitAscending
534XSDDJUAdjusted DateAscending
634XSDCSupply Demand CodeAscending
734XSDC1Supply Demand Category 1Ascending
8DOCODocument (Order No Invoice etc.)Ascending
9DCTOOrder TypeAscending
10KCOOOrder Company (Order Number)Ascending
11SFXOOrder SuffixAscending
12LNIDLine NumberAscending
1334XSDC2Supply/Demand String KeyAscending
1434XUKID1Unique Key ID Internal New OrderAscending
1534XUKID4Supply/Demand Numeric KeyAscending
16UOMUnit of Measure as InputAscending
3UPMJ
ElementAliasDescriptionSequence
1UPMJDate - UpdatedAscending
4USER JOBS UPMJ
ElementAliasDescriptionSequence
1USERUser IDAscending
2JOBSJob NumberAscending
3UPMJDate - UpdatedAscending
5USER JOBS ITM MCU 34XSDDJ +B
ElementAliasDescriptionSequence
1USERUser IDAscending
2JOBSJob NumberAscending
3ITMItem Number - ShortAscending
4MCUBusiness UnitAscending
534XSDDJUnadjusted DateAscending
634XSDC1Supply Demand Category 1Ascending
734XSDC2Supply/Demand String KeyAscending
6USER JOBS ITM MCU 34XSDDJ +C
ElementAliasDescriptionSequence
1USERUser IDAscending
2JOBSJob NumberAscending
3ITMItem Number - ShortAscending
4MCUBusiness UnitAscending
534XSDDJUnadjusted DateAscending
634XSDDSSupply Demand DescriptionDescending
7USER JOBS MCU ITM UOM
ElementAliasDescriptionSequence
1USERUser IDAscending
2JOBSJob NumberAscending
3MCUBusiness UnitAscending
4ITMItem Number - ShortAscending
5UOMUnit of Measure as InputAscending