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

110 COLUMNS | 7 INDEXES | Print definition?920 | 31 | F3112 TABLE

31: Shop Floor Control
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F3112WL1107Work Order RoutingTransaction 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 WLDOCO, WLDCTO, WLSFXO, WLTRT, WLKIT, WLKITL, WLKITA, WLMMCU, WLLINE, WLMCU, WLALD, WLDSC1, WLOPSQ, WLOPSC, WLOPST, WLINPE, WLTIMB, WLLAMC, WLBFPF, WLPPRF, WLJBCD, WLAN8, WLCRTR, WLSLTR, WLTRDJ, WLDRQJ, WLSTRT, WLSTRX, WLRSFT, WLSSFT, WLCSFT, WLLTPC, WLPOVR, WLOPYP, WLCPYP, WLNXOP, WLSETC, WLMOVD, WLQUED, WLRUNM, WLRUNL, WLSETL, WLMACA, WLLABA, WLSETA, WLOPSR, WLUORG, WLSOCN, WLSOQS, WLQMTO, WLPWRT, WLUOM, WLCTS2, WLCTS3, WLCTS4, WLCTS5, WLCTS6, WLAPID, WLSHNO, WLOMCU, WLOBJ, WLSUB, WLVEND, WLRKCO, WLRORN, WLRCTO, WLRLLN, WLDCT, WLURCD, WLURDT, WLURAT, WLURRF, WLURAB, WLUSER, WLPID, WLJOBN, WLUPMJ, WLTDAY, WLLOCN, WLRUC, WLCAPU, WLWMCU, WLCMHR, WLCLHR, WLCSHR, WLCOST, WLACTB, WLNUMB, WLCTS7, WLCTS8, WLCTS9, WLLABP, WLMACR, WLSETR, WLAPSC, WLSEST, WLSEET, WLTMCO, WLD2J, WLSTTI, WLCMPE, WLCMPC, WLCPLVLFR, WLCPLVLTO, WLCMRQ, WLANSA, WLANPA, WLANP, WLWSCHF, WLTRAF FROM F3112

TOP920 | 31 | F3112 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WLDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2WLDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3WLSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
4WLTRTType of RoutingStringUDC (40 TR)30 Allow NULL? 
5WLKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
6WLKITLKit - 2nd Item NumberStringGeneric Edit250 Allow NULL? 
7WLKITA3rd Item Number - KitStringGeneric Edit250 Allow NULL? 
8WLMMCUBranchStringGeneric Edit120 Allow NULL? 
9WLLINELine/Cell IdentifierStringGeneric Edit120 Allow NULL? 
10WLMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
11WLALDAuto Load DescriptionStringUDC (30 AL)40 Allow NULL? 
12WLDSC1DescriptionStringGeneric Edit300 Allow NULL? 
13WLOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
14WLOPSCType Operation CodeStringUDC (30 OT)20 Allow NULL? 
15WLOPSTOperation Status Code W.O.StringUDC (31 OS)20 Allow NULL? 
16WLINPEInspection CodeStringGeneric Edit20 Allow NULL? 
17WLTIMBTime Basis CodeCharacterUDC (30 TB)10 Allow NULL? 
18WLLAMCLabor or MachineCharacterUDC (H40 LA)10 Allow NULL? 
19WLBFPFPay Point CodeCharacterUDC (30 BF)10 Allow NULL? 
20WLPPRFPay Point StatusCharacterUDC (31 PP)10 Allow NULL? 
21WLJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
22WLAN8Address NumberNumericGeneric Edit80 Allow NULL? 
23WLCRTRCritical RatioNumericGeneric Edit74 Allow NULL? 
24WLSLTRSlack Time RatioNumericGeneric Edit74 Allow NULL? 
25WLTRDJDate - Order/TransactionDateGeneric Edit60
26WLDRQJDate - RequestedDateGeneric Edit60
27WLSTRTDate - Start (Julian)DateGeneric Edit60
28WLSTRXDate - Completion (Julian)DateGeneric Edit60
29WLRSFTShift Code - RequestedCharacterUDC10 Allow NULL? 
30WLSSFTShift Code - StartCharacterUDC10 Allow NULL? 
31WLCSFTShift Code - CompletedCharacterUDC10 Allow NULL? 
32WLLTPCPercent - Leadtime OverlapNumericGeneric Edit52 Allow NULL? 
33WLPOVRPercent - OverlapNumericGeneric Edit52 Allow NULL? 
34WLOPYPPercent - Operational Planned YieldNumericGeneric Edit52 Allow NULL? 
35WLCPYPPercent - Cumulative Planned YieldNumericGeneric Edit52 Allow NULL? 
36WLNXOPSequence Number - Next OperationNumericGeneric Edit52 Allow NULL? 
37WLSETCCrew SizeNumericGeneric Edit51 Allow NULL? 
38WLMOVDMove Hours - StandardNumericGeneric Edit52 Allow NULL? 
39WLQUEDQueue Hours - StandardNumericGeneric Edit52 Allow NULL? 
40WLRUNMRun Machine - StandardNumericGeneric Edit152 Allow NULL? 
41WLRUNLRun Labor - StandardNumericGeneric Edit152 Allow NULL? 
42WLSETLSetup Labor - StandardNumericGeneric Edit152 Allow NULL? 
43WLMACARun Machine - ActualNumericGeneric Edit152 Allow NULL? 
44WLLABARun Labor - ActualNumericGeneric Edit152 Allow NULL? 
45WLSETAHours - Setup Labor Hours - ActualNumericGeneric Edit152 Allow NULL? 
46WLOPSRFactor - Operation Shrinkage FactorNumericGeneric Edit154 Allow NULL? 
47WLUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
48WLSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
49WLSOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
50WLQMTOUnits - Quantity at OperationNumericGeneric Edit150 Allow NULL? 
51WLPWRTRate - PieceworkNumericGeneric Edit153 Allow NULL? 
52WLUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
53WLCTS2Hours - Unaccounted Setup LaborNumericGeneric Edit152 Allow NULL? 
54WLCTS3Hours - Unaccounted Machine HoursNumericGeneric Edit152 Allow NULL? 
55WLCTS4Amount - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
56WLCTS5Amount - Unaccounted Setup LaborNumericGeneric Edit152 Allow NULL? 
57WLCTS6Amount - Unaccounted MachineNumericGeneric Edit152 Allow NULL? 
58WLAPIDUnit or Tag NumberStringUDC120 Allow NULL? 
59WLSHNOMessage NumberStringGeneric Edit100 Allow NULL? 
60WLOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
61WLOBJObject AccountStringGeneric Edit60 Allow NULL? 
62WLSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
63WLVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
64WLRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
65WLRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
66WLRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
67WLRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
68WLDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
69WLURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
70WLURDTUser Reserved DateDateGeneric Edit60
71WLURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
72WLURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
73WLURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
74WLUSERUser IDStringGeneric Edit100 Allow NULL? 
75WLPIDProgram IDStringGeneric Edit100 Allow NULL? 
76WLJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
77WLUPMJDate - UpdatedDateGeneric Edit60
78WLTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
79WLLOCNLocationStringGeneric Edit200 Allow NULL? 
80WLRUCResource units consumedNumericGeneric Edit152 Allow NULL? 
81WLCAPUCapacity Unit of measureStringUDC (00 UM)20 Allow NULL? 
82WLWMCUWorkcenter BranchStringGeneric Edit120 Allow NULL? 
83WLCMHRRun Machine - CurrentNumericGeneric Edit152 Allow NULL? 
84WLCLHRRun Labor - CurrentNumericGeneric Edit152 Allow NULL? 
85WLCSHRSetup Labor - CurrentNumericGeneric Edit152 Allow NULL? 
86WLCOSTCost ComponentStringUDC (30 CA)30 Allow NULL? 
87WLACTBActivity-Based Costing Activity CodeStringGeneric Edit100 Allow NULL? 
88WLNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
89WLCTS7Amount - Unaccounted ScrapNumericGeneric Edit152 Allow NULL? 
90WLCTS8Units - Unaccounted ScrapNumericGeneric Edit150 Allow NULL? 
91WLCTS9Hours - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
92WLLABPRun Labor - RateNumericGeneric Edit152 Allow NULL? 
93WLMACRRun Machine - RateNumericGeneric Edit152 Allow NULL? 
94WLSETRSetup Labor - RateNumericGeneric Edit152 Allow NULL? 
95WLAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
96WLSESTTime - Scheduled Start (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
97WLSEETTime - Scheduled End (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
98WLTMCOTime - CompletedNumericGeneric Edit60 Allow NULL? 
99WLD2JDate - Actual StartDateGeneric Edit60
100WLSTTITime - Start (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
101WLCMPECompetency TypeStringUDC (05 CY)30 Allow NULL? 
102WLCMPCCompetency CodeStringGeneric Edit100 Allow NULL? 
103WLCPLVLFRCompetency Level FromNumericGeneric Edit63 Allow NULL? 
104WLCPLVLTOCompetency Level ToNumericGeneric Edit63 Allow NULL? 
105WLCMRQRule Match FlagCharacterGeneric Edit10 Allow NULL? 
106WLANSAAddress Number - ManagerNumericGeneric Edit80 Allow NULL? 
107WLANPASupervisorNumericGeneric Edit80 Allow NULL? 
108WLANPAddress Number - Assigned ToNumericGeneric Edit80 Allow NULL? 
109WLWSCHFMaintenance Schedule FlagCharacterUDC (13 WS)10 Allow NULL? 
110WLTRAFResources AssignedCharacterUDC (00 ZO)10 Allow NULL? 

TOP920 | 31 | F3112 INDEXES

NumberDescription
1OrderNo OperationSeqNo +A (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2OPSQSequence Number - OperationsAscending
3OPSCType Operation CodeAscending
4MCUBusiness UnitAscending
2BusinessUnit StartDate +A
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2STRTDate - Start (Julian)Ascending
3OPSQSequence Number - OperationsAscending
4DOCODocument (Order No Invoice etc.)Ascending
3BusinessUnit RequestedDate
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2DRQJDate - RequestedAscending
4Branch BusinessUnit +A
ElementAliasDescriptionSequence
1MMCUBranchAscending
2MCUBusiness UnitAscending
3WMCUWorkcenter BranchAscending
4OPSCType Operation CodeAscending
5DOCODocument (Order No Invoice etc.)Ascending
5AddressNo StartDate +A
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2STRTDate - Start (Julian)Ascending
3DOCODocument (Order No Invoice etc.)Ascending
4OPSQSequence Number - OperationsAscending
6Branch ParentItemNo +A
ElementAliasDescriptionSequence
1MMCUBranchAscending
2KITParent (short) Item NumberAscending
3DOCODocument (Order No Invoice etc.)Ascending
4OPSQSequence Number - OperationsAscending
7OrderNo OperSeqNo +A
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2OPSQSequence Number - OperationsAscending
3OPSCType Operation CodeAscending