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

44 COLUMNS | 7 INDEXES | Print definition?920 | 34X | F34X310W TABLE

34X: In-Memory Planning Advisor
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F34X310WPD447Planning Advisor BOM Component Detail 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 PDUKID, PDJOBS, PD34XPITM, PDMCU0, PDLBOM, PD34XLBOMI, PDITM, PDLITM, PDAITM, PDOTBM, PD#BQT, PDKIT, PDTBM, PDCPNB, PDMMCU, PDCMCU, PD34XBQTY, PD34XBQTE, PD34XBQTEA, PDUM, PDSTKT, PDLNTY, PDSCRP, PDSRNK, PDSRKF, PDBRVN, PDOPSQ, PDOPSC, PDTYCOMP, PDSBNT, PDEFFF, PDEFFT, PDFSER, PDTSER, PDFORQ, PDDSC1, PDSUBAF, PDBREV, PDANPL, PDCMRV, PDRVNO, PDSELCB, PDUSER, PDUPMJ FROM F34X310W

TOP920 | 34X | F34X310W COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PDUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
2PDJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
3PD34XPITMParent ItemNumericGeneric Edit80 Allow NULL? 
4PDMCU0Business UnitStringGeneric Edit120 Allow NULL? 
5PDLBOMLevel of BOMNumericGeneric Edit150 Allow NULL? 
6PD34XLBOMIIndented BOM LevelStringGeneric Edit500 Allow NULL? 
7PDITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
8PDLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
9PDAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
10PDOTBMType Bill of Material - OverridesStringUDC (40 TB)30 Allow NULL? 
11PD#BQTUnits - Batch QuanityNumericGeneric Edit150 Allow NULL? 
12PDKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
13PDTBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
14PDCPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
15PDMMCUBranchStringGeneric Edit120 Allow NULL? 
16PDCMCUComponent BranchStringGeneric Edit120 Allow NULL? 
17PD34XBQTYBOM Component QuantityNumericGeneric Edit150 Allow NULL? 
18PD34XBQTEExtended BOM Component QuantityNumericGeneric Edit150 Allow NULL? 
19PD34XBQTEAAdjusted BOM Component QuantityNumericGeneric Edit150 Allow NULL? 
20PDUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
21PDSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
22PDLNTYLine TypeStringGeneric Edit20 Allow NULL? 
23PDSCRPPercent - Percent of ScrapNumericGeneric Edit52 Allow NULL? 
24PDSRNKShrink FactorNumericGeneric Edit152 Allow NULL? 
25PDSRKFShrink Factor MethodCharacterUDC (H40 SR)10 Allow NULL? 
26PDBRVNBOM Revision NumberNumericGeneric Edit150 Allow NULL? 
27PDOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
28PDOPSCType Operation CodeStringUDC (30 OT)20 Allow NULL? 
29PDTYCOMP Type of ComponentStringGeneric Edit20 Allow NULL? 
30PDSBNTSubstitute Item Sequence NumberNumericGeneric Edit52 Allow NULL? 
31PDEFFFEffective - From DateDateGeneric Edit60
32PDEFFTEffective - Thru DateDateGeneric Edit60
33PDFSEREffective From Serial NumberStringGeneric Edit250 Allow NULL? 
34PDTSEREffective Thru Serial NumberStringGeneric Edit250 Allow NULL? 
35PDFORQFixed or Variable QuantityCharacterUDC (H40 FO)10 Allow NULL? 
36PDDSC1DescriptionStringGeneric Edit300 Allow NULL? 
37PDSUBAFSub Assembly FlagCharacterGeneric Edit10 Allow NULL? 
38PDBREVBill Revision LevelStringGeneric Edit30 Allow NULL? 
39PDANPLPlanner NumberNumericGeneric Edit80 Allow NULL? 
40PDCMRVComponent Revision LevelStringGeneric Edit30 Allow NULL? 
41PDRVNOLast Revision No.StringGeneric Edit20 Allow NULL? 
42PDSELCBAdditional Selections - Check boxCharacterGeneric Edit10 Allow NULL? 
43PDUSERUser IDStringGeneric Edit100 Allow NULL? 
44PDUPMJDate - UpdatedDateGeneric Edit60

TOP920 | 34X | F34X310W INDEXES

NumberDescription
1JOBS UKID (Primary/Unique)
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2UKIDUnique Key ID (Internal)Ascending
2KIT. TBM MMCU ITM OPSQ
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2KITParent (short) Item NumberAscending
3TBMType Bill of MaterialAscending
4MMCUBranchAscending
5ITMItem Number - ShortAscending
6OPSQSequence Number - OperationsAscending
3KIT MMCU BRVN LBOM
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2KITParent (short) Item NumberAscending
3MMCUBranchAscending
4BRVNBOM Revision NumberAscending
5LBOMLevel of BOMAscending
4EndItem
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
234XPITMParent ItemAscending
3MCU0Business UnitAscending
4OTBMType Bill of Material - OverridesAscending
5#BQTUnits - Batch QuanityAscending
5EndItem + SubAssembly
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
234XPITMParent ItemAscending
3MCU0Business UnitAscending
4OTBMType Bill of Material - OverridesAscending
5#BQTUnits - Batch QuanityAscending
6KITParent (short) Item NumberAscending
7MMCUBranchAscending
8TBMType Bill of MaterialAscending
9UMUnit of MeasureAscending
7JOB USER ITM CMCU
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2USERUser IDAscending
3ITMItem Number - ShortAscending
4CMCUComponent BranchAscending
8JOB USER UPMJ
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2USERUser IDAscending
3UPMJDate - UpdatedAscending