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

137 COLUMNS | 1 INDEXES | Print definition?920 | 48 | F48UI001 TABLE

48: Work Order Processing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F48UI001WA1371X4801 Master Business Function WorkfileRegular Work Files48: Work Order ProcessingBusiness 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 WAJOBS, WACTID, WAACTN, WADCTO, WADOCO, WASFXO, WARCTO, WARORN, WALNID, WAPTWO, WAPARS, WATYPS, WAPRTS, WADL01, WASTCM, WACO, WAMCU, WAMMCU, WALOCN, WAAISL, WABIN, WASRST, WADCG, WASUB, WAAN8, WAANO, WAANSA, WAANPA, WAANP, WAANT, WANAN8, WATRDJ, WASTRT, WADRQJ, WADPL, WASTRX, WADAP, WADAT, WAPPDT, WAWR01, WAWR02, WAWR03, WAWR04, WAWR05, WAWR06, WAWR07, WAWR08, WAWR09, WAWR10, WAVR01, WAVR02, WAAMTO, WASETC, WABRT, WAPAYT, WAAMTC, WAHRSO, WAHRSC, WAAMTA, WAHRSA, WAITM, WAAITM, WALITM, WANUMB, WAAPID, WAUORG, WASOBK, WASOCN, WASOQS, WAQTYT, WAUOM, WASHNO, WAPBTM, WATBM, WATRT, WASHTY, WAPEC, WAPPFG, WABM, WARTG, WASPRT, WAUNCD, WAINDC, WARESC, WAMOH, WATDT, WAPOU, WAPC, WALTLV, WALTCM, WACTS1, WALOTN, WALOTP, WALOTG, WARAT1, WARAT2, WADCT, WASBLI, WARKCO, WABREV, WARREV, WADRWC, WARTCH, WAPNRQ, WAREAS, WAPHSE, WAXDSP, WABOMC, WAURCD, WAURDT, WAURAT, WAURAB, WAURRF, WAUSER, WAPID, WAJOBN, WAUPMJ, WATDAY, WAAAID, WANTST, WAXRTO, WAESDN, WAACDN, WASAID, WAMPOS, WAAPRT, WAAMLC, WAAMMC, WAAMOT, WALBAM, WAMTAM, WAEV01, WATFLA, WAUOM1, WAEV02, WASTKT, WALNIX FROM F48UI001

TOP920 | 48 | F48UI001 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WAJOBSJob NumberNumericGeneric Edit80 Allow NULL? 
2WACTIDComputer IDStringGeneric Edit150 Allow NULL? 
3WAACTNAction CodeCharacterGeneric Edit10 Allow NULL? 
4WADCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
5WADOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
6WASFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
7WARCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
8WARORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
9WALNIDLine NumberNumericGeneric Edit63 Allow NULL? 
10WAPTWOPeg to Work OrderNumericGeneric Edit80 Allow NULL? 
11WAPARSNumber - Parent WO NumberStringGeneric Edit80 Allow NULL? 
12WATYPSType - W.O.CharacterUDC (00 TY)10 Allow NULL? 
13WAPRTSPriority - W.O.CharacterUDC (00 PR)10 Allow NULL? 
14WADL01DescriptionStringGeneric Edit300 Allow NULL? 
15WASTCMStatus - CommentStringGeneric Edit300 Allow NULL? 
16WACOCompanyStringGeneric Edit50 Allow NULL? 
17WAMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
18WAMMCUBranchStringGeneric Edit120 Allow NULL? 
19WALOCNLocationStringGeneric Edit200 Allow NULL? 
20WAAISLAisleStringGeneric Edit80 Allow NULL? 
21WABINBinStringGeneric Edit80 Allow NULL? 
22WASRSTStatus Code W.O.StringUDC (00 SS)20 Allow NULL? 
23WADCGDate - Status ChangedDateGeneric Edit60
24WASUBSubsidiaryStringGeneric Edit80 Allow NULL? 
25WAAN8Address NumberNumericGeneric Edit80 Allow NULL? 
26WAANOAddress Number - OriginatorNumericGeneric Edit80 Allow NULL? 
27WAANSAAddress Number - ManagerNumericGeneric Edit80 Allow NULL? 
28WAANPASupervisorNumericGeneric Edit80 Allow NULL? 
29WAANPAddress Number - Assigned ToNumericGeneric Edit80 Allow NULL? 
30WAANTAddress Number - InspectorNumericGeneric Edit80 Allow NULL? 
31WANAN8Next Address NumberNumericGeneric Edit80 Allow NULL? 
32WATRDJDate - Order/TransactionDateGeneric Edit60
33WASTRTDate - Start (Julian)DateGeneric Edit60
34WADRQJDate - RequestedDateGeneric Edit60
35WADPLDate - W.O. Planned CompletedDateGeneric Edit60
36WASTRXDate - Completion (Julian)DateGeneric Edit60
37WADAPDate - Assigned toDateGeneric Edit60
38WADATDate - Assigned to InspectorDateGeneric Edit60
39WAPPDTDate - Paper Printed DateDateGeneric Edit60
40WAWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
41WAWR02Categories - Work Order 02StringUDC (00 W2)30 Allow NULL? 
42WAWR03Categories - Work Order 03StringUDC (00 W3)30 Allow NULL? 
43WAWR04Categories - Work Order 04StringUDC (00 W4)30 Allow NULL? 
44WAWR05Categories - Work Order 05StringUDC (00 W5)30 Allow NULL? 
45WAWR06EnterpriseOne Consulting - StatusStringUDC (00 W6)30 Allow NULL? 
46WAWR07EnterpriseOne Consulting - Service TypeStringUDC (00 W7)30 Allow NULL? 
47WAWR08EnterpriseOne Consulting - Skill TypeStringUDC (00 W8)30 Allow NULL? 
48WAWR09E1 Consulting - Experience LevelStringUDC (00 W9)30 Allow NULL? 
49WAWR10Categories - Work Order 10StringUDC (00 W0)30 Allow NULL? 
50WAVR01ReferenceStringGeneric Edit250 Allow NULL? 
51WAVR02Reference 2StringGeneric Edit250 Allow NULL? 
52WAAMTOAmount - EstimatedNumericGeneric Edit152 Allow NULL? 
53WASETCCrew SizeNumericGeneric Edit51 Allow NULL? 
54WABRTRevenue Rate Markup OverrideNumericGeneric Edit152 Allow NULL? 
55WAPAYTPay/Deduction/Benefit TypeStringGeneric Edit50 Allow NULL? 
56WAAMTCAmount - Change to Original DollarsNumericGeneric Edit152 Allow NULL? 
57WAHRSOHours - EstimatedNumericGeneric Edit152 Allow NULL? 
58WAHRSCHours - Change to Original HoursNumericGeneric Edit152 Allow NULL? 
59WAAMTAAmount - ActualNumericGeneric Edit152 Allow NULL? 
60WAHRSAHours - ActualNumericGeneric Edit152 Allow NULL? 
61WAITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
62WAAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
63WALITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
64WANUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
65WAAPIDUnit or Tag NumberStringUDC120 Allow NULL? 
66WAUORGUnits - Order/Transaction QuantityNumericGeneric Edit150 Allow NULL? 
67WASOBKUnits - Qty Backordered/HeldNumericGeneric Edit150 Allow NULL? 
68WASOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit150 Allow NULL? 
69WASOQSQuantity ShippedNumericGeneric Edit150 Allow NULL? 
70WAQTYTUnits - Shipped to DateNumericGeneric Edit150 Allow NULL? 
71WAUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
72WASHNOMessage NumberStringGeneric Edit100 Allow NULL? 
73WAPBTMTime - Beginning (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
74WATBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
75WATRTType of RoutingStringUDC (40 TR)30 Allow NULL? 
76WASHTYWO Pick List PrintedCharacterUDC (H00 SH)10 Allow NULL? 
77WAPECPosting EditCharacterUDC (H00 PE)10 Allow NULL? 
78WAPPFGVariance FlagCharacterUDC (H00 PP)10 Allow NULL? 
79WABMBill of Material (N)CharacterGeneric Edit10 Allow NULL? 
80WARTGRoute Sheet (N)CharacterGeneric Edit10 Allow NULL? 
81WASPRTWork Order Flash MessageCharacterUDC (00 WM)10 Allow NULL? 
82WAUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
83WAINDCIndented CodeCharacterGeneric Edit10 Allow NULL? 
84WARESCResequence CodeNumericGeneric Edit52 Allow NULL? 
85WAMOHAmount - Miles or Hours (units)NumericGeneric Edit152 Allow NULL? 
86WATDTDate - Scheduled TicklerDateGeneric Edit60
87WAPOUAmount - Memo Budget ChangesNumericGeneric Edit152 Allow NULL? 
88WAPCPercent CompleteNumericGeneric Edit50 Allow NULL? 
89WALTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
90WALTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
91WACTS1Hours - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
92WALOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
93WALOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
94WALOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
95WARAT1Ratio _ Critical Ratio Priority 1NumericGeneric Edit52 Allow NULL? 
96WARAT2Ratio - Critical Ratio Priority 2NumericGeneric Edit52 Allow NULL? 
97WADCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
98WASBLISubledger Inactive CodeCharacterUDC (00 SI)10 Allow NULL? 
99WARKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
100WABREVBill Revision LevelStringGeneric Edit30 Allow NULL? 
101WARREVRouting Revision LevelStringGeneric Edit30 Allow NULL? 
102WADRWCDrawing ChangeCharacterGeneric Edit10 Allow NULL? 
103WARTCHRouting ChangeCharacterGeneric Edit10 Allow NULL? 
104WAPNRQNew Part NumberCharacterGeneric Edit10 Allow NULL? 
105WAREASReason for ECOStringUDC (40 CR)20 Allow NULL? 
106WAPHSEPhase InStringUDC (40 PH)30 Allow NULL? 
107WAXDSPExisting DispositionStringUDC (40 ED)30 Allow NULL? 
108WABOMCBOM ChangeCharacterGeneric Edit10 Allow NULL? 
109WAURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
110WAURDTUser Reserved DateDateGeneric Edit60
111WAURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
112WAURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
113WAURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
114WAUSERUser IDStringGeneric Edit100 Allow NULL? 
115WAPIDProgram IDStringGeneric Edit100 Allow NULL? 
116WAJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
117WAUPMJDate - UpdatedDateGeneric Edit60
118WATDAYTime of DayNumericGeneric Edit60 Allow NULL? 
119WAAAIDParent NumberNumericGeneric Edit80 Allow NULL? 
120WANTSTNext Status - W.O.StringUDC (00 SS)20 Allow NULL? 
121WAXRTOCriticality - Work OrderNumericGeneric Edit40 Allow NULL? 
122WAESDNEstimated Downtime HoursNumericGeneric Edit52 Allow NULL? 
123WAACDNActual Downtime HoursNumericGeneric Edit52 Allow NULL? 
124WASAIDService Address NumberNumericGeneric Edit80 Allow NULL? 
125WAMPOSMeter PositionNumericGeneric Edit30 Allow NULL? 
126WAAPRTApproval TypeStringUDC (48 AP)30 Allow NULL? 
127WAAMLCAmount - Estimated LaborNumericGeneric Edit152 Allow NULL? 
128WAAMMCAmount - Estimated MaterialNumericGeneric Edit152 Allow NULL? 
129WAAMOTAmount - Estimated OtherNumericGeneric Edit152 Allow NULL? 
130WALBAMAmount - Actual LaborNumericGeneric Edit152 Allow NULL? 
131WAMTAMAmount - Actual MaterialNumericGeneric Edit152 Allow NULL? 
132WAEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10 Allow NULL? 
133WATFLAStandard Unit of Measure ConversionStringUDC (H40 ST)20 Allow NULL? 
134WAUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
135WAEV02J.D. EnterpriseOne Event Point 02CharacterGeneric Edit10 Allow NULL? 
136WASTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
137WALNIXLine Number - X-REFNumericGeneric Edit63 Allow NULL? 

TOP920 | 48 | F48UI001 INDEXES

NumberDescription
1Job Number Computer ID +A (Primary/Unique)
ElementAliasDescriptionSequence
1JOBSJob NumberAscending
2CTIDComputer IDAscending
3LNIXLine Number - X-REFAscending
4EV01J.D. EnterpriseOne Event Point 01Ascending