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

87 COLUMNS | 14 INDEXES | Print definition?920 | 31 | F3111 TABLE

31: Shop Floor Control
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F3111WM8714Work Order Parts ListTransaction Files31: Shop Floor Control
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 F3111

TOP920 | 31 | F3111 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 | F3111 INDEXES

NumberDescription
1OrderNo OperSeqNo +A
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2OPSQSequence Number - OperationsAscending
3BSEQSequence - Bubble SequenceAscending
2CompItemNo CompBranch +A
ElementAliasDescriptionSequence
1CPITComponent Item Number - ShortAscending
2CMCUComponent BranchAscending
3DRQJDate - RequestedAscending
3BusinessUnit CompItemNo +A
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2CPITComponent Item Number - ShortAscending
3COBYCo-Products/By-Products/IntermediateAscending
4DOCODocument (Order No Invoice etc.)Ascending
4OrderNo OperSeqNo +B
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2OPSQSequence Number - OperationsAscending
3DRQJDate - RequestedAscending
4CMCUComponent BranchAscending
5LOCNLocationAscending
6LOTNLot/Serial NumberAscending
7CPITComponent Item Number - ShortAscending
5OrderNumber CompItmNo +A
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2CPITComponent Item Number - ShortAscending
3CMCUComponent BranchAscending
4DRQJDate - RequestedAscending
6Co_ByProducts OrderNo +A
ElementAliasDescriptionSequence
1COBYCo-Products/By-Products/IntermediateAscending
2DOCODocument (Order No Invoice etc.)Ascending
3OPSQSequence Number - OperationsAscending
7Co_ByProducts CompItem +A
ElementAliasDescriptionSequence
1COBYCo-Products/By-Products/IntermediateAscending
2CPITComponent Item Number - ShortAscending
3CMCUComponent BranchAscending
4DRQJDate - RequestedAscending
8UniqueKeyID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
11CompItemNo CompBranch +B
ElementAliasDescriptionSequence
1CPITComponent Item Number - ShortAscending
2CMCUComponent BranchAscending
3LOCNLocationAscending
4LOTNLot/Serial NumberAscending
5DOCODocument (Order No Invoice etc.)Ascending
12OrderNo OperSeqNo +C
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2OPSQSequence Number - OperationsAscending
3CPNBComponent Line Number BOMAscending
13OrderNo OrderType +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3CPNBComponent Line Number BOMAscending
14OrderNo RelatedOrder +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2RKCOCompany - Key (Related Order)Ascending
3RORNRelated PO/SO/WO NumberAscending
4RCTORelated PO/SO/WO Order TypeAscending
5RLLNRelated PO/SO Line NumberAscending
6CPITComponent Item Number - ShortAscending
15Co_ByProducts OrderNo ActIng +
ElementAliasDescriptionSequence
1COBYCo-Products/By-Products/IntermediateAscending
2DOCODocument (Order No Invoice etc.)Ascending
3AINGActive Ingredient FlagAscending
4OPSQSequence Number - OperationsAscending
16CompItemNo CompBranch +C
ElementAliasDescriptionSequence
1CPITComponent Item Number - ShortAscending
2CMCUComponent BranchAscending
3DOCODocument (Order No Invoice etc.)Ascending
4UORGUnits - Order/Transaction QuantityDescending