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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

87 COLUMNS | 1 INDEXES | Print definition?920 | 31 | F3111S TABLE

31: Shop Floor Control
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F3111SWM871Purge - Shop Floor Parts ListPurge Files31: Shop Floor ControlBusiness 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 WMDOCO, WMDCTO, WMSFXO, WMTBM, WMFORQ, WMITC, WMCOBY, WMCOTY, WMCPNT, WMFRMP, WMTHRP, WMFRGD, WMTHGD, WMRKCO, WMRORN, WMRCTO, WMRLLN, WMOPSQ, WMBSEQ, WMRSCP, WMSCRP, WMREWP, WMASIP, WMCPYP, WMSTPP, WMLOVD, WMCPIT, WMCPIL, WMCPIA, WMCMCU, WMDSC1, WMDSC2, WMLOCN, WMLOTN, WMAN8, WMLNTY, WMSERN, WMTRDJ, WMDRQJ, WMUORG, WMTRQT, WMSOCN, WMSOBK, WMCTS1, WMQNTA, WMUM, WMEA, WMRTG, WMMTST, WMDCT, WMSHNO, WMMCU, WMOMCU, WMOBJ, WMSUB, WMCMRV, WMSTRX, WMPARS, WMCOMM, WMURCD, WMURDT, WMURAT, WMURRF, WMURAB, WMUSER, WMPID, WMJOBN, WMUPMJ, WMTDAY, WMUKID, WMVEND, WMPOC, WMCTS4, WMCTS7, WMCTS8, WMGLD, WMSBFL, WMAING, WMSSTQ, WMUOM2, WMAPSC, WMPSN, WMDLEJ, WMCOST, WMCHPP, WMCPNB, WMBSEQAN FROM F3111S

TOP920 | 31 | F3111S COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WMDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2WMDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3WMSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
4WMTBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
5WMFORQFixed or Variable QuantityCharacterUDC (H40 FO)10 Allow NULL? 
6WMITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
7WMCOBYCo-Products/By-Products/IntermediateCharacterUDC (H40 CO)10 Allow NULL? 
8WMCOTYComponent TypeCharacterUDC (H40 CP)10 Allow NULL? 
9WMCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
10WMFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
11WMTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
12WMFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
13WMTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
14WMRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
15WMRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
16WMRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
17WMRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
18WMOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
19WMBSEQSequence - Bubble SequenceNumericGeneric Edit50 Allow NULL? 
20WMRSCPResource PercentNumericGeneric Edit52 Allow NULL? 
21WMSCRPPercent - Percent of ScrapNumericGeneric Edit52 Allow NULL? 
22WMREWPPercent - ReworkNumericGeneric Edit52 Allow NULL? 
23WMASIPPercent - As isNumericGeneric Edit52 Allow NULL? 
24WMCPYPPercent - Cumulative Planned YieldNumericGeneric Edit52 Allow NULL? 
25WMSTPPOperation Scrap PercentNumericGeneric Edit52 Allow NULL? 
26WMLOVDLeadtime Offset DaysNumericGeneric Edit60 Allow NULL? 
27WMCPITComponent Item Number - ShortNumericGeneric Edit80 Allow NULL? 
28WMCPILComponent 2nd Item NumberStringGeneric Edit250 Allow NULL? 
29WMCPIAComponent 3rd Item NumberStringGeneric Edit250 Allow NULL? 
30WMCMCUComponent BranchStringGeneric Edit120 Allow NULL? 
31WMDSC1DescriptionStringGeneric Edit300 Allow NULL? 
32WMDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
33WMLOCNLocationStringGeneric Edit200 Allow NULL? 
34WMLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
35WMAN8Address NumberNumericGeneric Edit80 Allow NULL? 
36WMLNTYLine TypeStringGeneric Edit20 Allow NULL? 
37WMSERNSerial Number - LotStringGeneric Edit300 Allow NULL? 
38WMTRDJDate - Order/TransactionDateGeneric Edit60
39WMDRQJDate - RequestedDateGeneric Edit60
40WMUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
41WMTRQTQuantity AvailableNumericGeneric Edit150 Allow NULL? 
42WMSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
43WMSOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
44WMCTS1Hours - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
45WMQNTAUnits - Quantity CommitedNumericGeneric Edit150 Allow NULL? 
46WMUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
47WMEAAmount - Estimated CostNumericGeneric Edit152 Allow NULL? 
48WMRTGRoute Sheet (N)CharacterGeneric Edit10 Allow NULL? 
49WMMTSTMaterial Status Code W.O.StringUDC (31 MS)20 Allow NULL? 
50WMDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
51WMSHNOMessage NumberStringGeneric Edit100 Allow NULL? 
52WMMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
53WMOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
54WMOBJObject AccountStringGeneric Edit60 Allow NULL? 
55WMSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
56WMCMRVComponent Revision LevelStringGeneric Edit30 Allow NULL? 
57WMSTRXDate - Completion (Julian)DateGeneric Edit60
58WMPARSNumber - Parent WO NumberStringGeneric Edit80 Allow NULL? 
59WMCOMMCommitted (H/S)CharacterUDC (H42 CP)10 Allow NULL? 
60WMURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
61WMURDTUser Reserved DateDateGeneric Edit60
62WMURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
63WMURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
64WMURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
65WMUSERUser IDStringGeneric Edit100 Allow NULL? 
66WMPIDProgram IDStringGeneric Edit100 Allow NULL? 
67WMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
68WMUPMJDate - UpdatedDateGeneric Edit60
69WMTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
70WMUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
71WMVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
72WMPOCIssue and ReceiptCharacterUDC (43 IR)10 Allow NULL? 
73WMCTS4Amount - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
74WMCTS7Amount - Unaccounted ScrapNumericGeneric Edit152 Allow NULL? 
75WMCTS8Units - Unaccounted ScrapNumericGeneric Edit150 Allow NULL? 
76WMGLDG/L DateDateGeneric Edit60
77WMSBFLParts List Substitute FlagCharacterGeneric Edit10 Allow NULL? 
78WMAINGActive Ingredient FlagCharacterGeneric Edit10 Allow NULL? 
79WMSSTQSecondary Quantity Issued/CompletedNumericGeneric Edit150 Allow NULL? 
80WMUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
81WMAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
82WMPSNPick Slip NumberNumericGeneric Edit80 Allow NULL? 
83WMDLEJLot Effectivity DateDateGeneric Edit60
84WMCOSTCost ComponentStringUDC (30 CA)30 Allow NULL? 
85WMCHPPCritical Hold PropagationCharacterGeneric Edit10 Allow NULL? 
86WMCPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
87WMBSEQANBubble Sequence Alpha NumericStringGeneric Edit50 Allow NULL? 

TOP920 | 31 | F3111S INDEXES

NumberDescription
1UniqueKeyID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending