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

128 COLUMNS | 32 INDEXES | Print definition?812 | 48 | F4801 TABLE

48: Work Order Processing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4801WA12832Work Order Master FileMaster Files48: Work Order ProcessingAS400 Coexistence Tables
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 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, WADPL, WAANT, WANAN8, WATRDJ, WASTRT, WADRQJ, 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 FROM F4801

TOP812 | 48 | F4801 COLUMNS

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

TOP812 | 48 | F4801 INDEXES

NumberDescription
1Document Number (Primary/Unique)
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2ParentWO Category01 +G
ElementAliasDescriptionSequence
1PARSNumber - Parent WO NumberAscending
2WR01Categories - Work Order 01Ascending
3WR02Categories - Work Order 02Ascending
4WR03Categories - Work Order 03Ascending
5TYPSType - W.O.Ascending
6PRTSPriority - W.O.Ascending
7DOCODocument (Order No Invoice etc.)Ascending
3Address Number
ElementAliasDescriptionSequence
1AN8Address NumberAscending
4Item Branch
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MMCUBranchAscending
3DRQJDate - RequestedAscending
5Order Number Type
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
6address number phase +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2WR01Categories - Work Order 01Ascending
3DPLDate - W.O. Planned CompletedAscending
7reference status +d
ElementAliasDescriptionSequence
1VR01ReferenceAscending
2SRSTStatus Code W.O.Ascending
3DPLDate - W.O. Planned CompletedAscending
8originator status +d
ElementAliasDescriptionSequence
1ANOAddress Number - OriginatorAscending
2SRSTStatus Code W.O.Ascending
3DPLDate - W.O. Planned CompletedAscending
9business unit phase +d
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2WR01Categories - Work Order 01Ascending
3DPLDate - W.O. Planned CompletedAscending
10supervisor status +d
ElementAliasDescriptionSequence
1ANPASupervisorAscending
2SRSTStatus Code W.O.Ascending
3DPLDate - W.O. Planned CompletedAscending
11manager status +d
ElementAliasDescriptionSequence
1ANSAAddress Number - ManagerAscending
2SRSTStatus Code W.O.Ascending
3DPLDate - W.O. Planned CompletedAscending
12order date order number
ElementAliasDescriptionSequence
1TRDJDate - Order/TransactionAscending
2DOCODocument (Order No Invoice etc.)Ascending
13completed date order number
ElementAliasDescriptionSequence
1STRXDate - Completion (Julian)Ascending
2DOCODocument (Order No Invoice etc.)Ascending
14start date order number
ElementAliasDescriptionSequence
1STRTDate - Start (Julian)Ascending
2DOCODocument (Order No Invoice etc.)Ascending
15item number categorywo +c
ElementAliasDescriptionSequence
1NUMBAsset Item NumberAscending
2WR01Categories - Work Order 01Ascending
3WR02Categories - Work Order 02Ascending
4WR03Categories - Work Order 03Ascending
5TYPSType - W.O.Ascending
6PRTSPriority - W.O.Ascending
7DOCODocument (Order No Invoice etc.)Ascending
16WO Category Code W1
ElementAliasDescriptionSequence
1WR01Categories - Work Order 01Ascending
17WO Category Code W2
ElementAliasDescriptionSequence
1WR02Categories - Work Order 02Ascending
18WO Category Code W3
ElementAliasDescriptionSequence
1WR03Categories - Work Order 03Ascending
19WO Category Code W4
ElementAliasDescriptionSequence
1WR04Categories - Work Order 04Ascending
20WO Category Code W5
ElementAliasDescriptionSequence
1WR05Categories - Work Order 05Ascending
21WO Category Code W6
ElementAliasDescriptionSequence
1WR06EnterpriseOne Consulting - StatusAscending
22WO Category Code W7
ElementAliasDescriptionSequence
1WR07EnterpriseOne Consulting - Service TypeAscending
23WO Category Code W8
ElementAliasDescriptionSequence
1WR08EnterpriseOne Consulting - Skill TypeAscending
24WO Category Code W9
ElementAliasDescriptionSequence
1WR09E1 Consulting - Experience LevelAscending
25WO Category Code W0
ElementAliasDescriptionSequence
1WR10Categories - Work Order 10Ascending
29Document No. Sts Code +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2SRSTStatus Code W.O.Ascending
3STRXDate - Completion (Julian)Ascending
30Asset Status +
ElementAliasDescriptionSequence
1NUMBAsset Item NumberAscending
2SRSTStatus Code W.O.Ascending
3TRDJDate - Order/TransactionAscending
31Inventory Status +
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2SRSTStatus Code W.O.Ascending
3TRDJDate - Order/TransactionAscending
32Address Status +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2SRSTStatus Code W.O.Ascending
3TRDJDate - Order/TransactionAscending
33Work Order Status +
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2SRSTStatus Code W.O.Ascending
3TRDJDate - Order/TransactionAscending
34Related Order No Ty Co
ElementAliasDescriptionSequence
1RORNRelated PO/SO/WO NumberAscending
2RCTORelated PO/SO/WO Order TypeAscending
3RKCOCompany - Key (Related Order)Ascending
36PegToWo Doco
ElementAliasDescriptionSequence
1PTWOPeg to Work OrderAscending
2DOCODocument (Order No Invoice etc.)Ascending