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

121 COLUMNS | 1 INDEXES | Print definition?920 | 41F | FCW65 TABLE

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920FCW65OF1211Work Order Header for Style ItemsFiles41F: Apparel Management
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 OFC9LANC, OFDCTO, OFDOCO, OFSFXO, OFRCTO, OFRORN, OFLNID, OFPTWO, OFPARS, OFTYPS, OFPRTS, OFDL01, OFSTCM, OFCO, OFMCU, OFMMCU, OFLOCN, OFAISL, OFBIN, OFSRST, OFDCG, OFSUB, OFAN8, OFANO, OFANSA, OFANPA, OFANP, OFDPL, OFANT, OFNAN8, OFTRDJ, OFSTRT, OFDRQJ, OFSTRX, OFDAP, OFDAT, OFPPDT, OFWR01, OFWR02, OFWR03, OFWR04, OFWR05, OFWR06, OFWR07, OFWR08, OFWR09, OFWR10, OFVR01, OFVR02, OFAMTO, OFSETC, OFBRT, OFPAYT, OFAMTC, OFHRSO, OFHRSC, OFAMTA, OFHRSA, OFSHNO, OFPBTM, OFTBM, OFTRT, OFSHTY, OFPEC, OFPPFG, OFBM, OFRTG, OFSPRT, OFUNCD, OFINDC, OFRESC, OFMOH, OFTDT, OFPOU, OFPC, OFLTLV, OFLTCM, OFCTS1, OFLOTN, OFLOTP, OFLOTG, OFRAT1, OFRAT2, OFDCT, OFSBLI, OFRKCO, OFBREV, OFRREV, OFDRWC, OFRTCH, OFPNRQ, OFREAS, OFPHSE, OFXDSP, OFBOMC, OFURCD, OFURDT, OFURAT, OFURAB, OFURRF, OFUSER, OFPID, OFJOBN, OFUPMJ, OFTDAY, OFAAID, OFNTST, OFXRTO, OFESDN, OFACDN, OFSAID, OFMPOS, OFAPRT, OFAMLC, OFAMMC, OFAMOT, OFLBAM, OFMTAM, OFC9COLL, OFC9SEAC, OFC9SEAY FROM FCW65

TOP920 | 41F | FCW65 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1OFC9LANCMaster Work OrderNumericGeneric Edit80 Allow NULL? 
2OFDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3OFDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
4OFSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
5OFRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
6OFRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
7OFLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
8OFPTWOPeg to Work OrderNumericGeneric Edit80 Allow NULL? 
9OFPARSNumber - Parent WO NumberStringGeneric Edit80 Allow NULL? 
10OFTYPSType - W.O.CharacterUDC (00 TY)10 Allow NULL? 
11OFPRTSPriority - W.O.CharacterUDC (00 PR)10 Allow NULL? 
12OFDL01DescriptionStringGeneric Edit300 Allow NULL? 
13OFSTCMStatus - CommentStringGeneric Edit300 Allow NULL? 
14OFCOCompanyStringGeneric Edit50 Allow NULL? 
15OFMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
16OFMMCUBranchStringGeneric Edit120 Allow NULL? 
17OFLOCNLocationStringGeneric Edit200 Allow NULL? 
18OFAISLAisleStringGeneric Edit80 Allow NULL? 
19OFBINBinStringGeneric Edit80 Allow NULL? 
20OFSRSTStatus Code W.O.StringUDC (00 SS)20 Allow NULL? 
21OFDCGDate - Status ChangedDateGeneric Edit60
22OFSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
23OFAN8Address NumberNumericGeneric Edit80 Allow NULL? 
24OFANOAddress Number - OriginatorNumericGeneric Edit80 Allow NULL? 
25OFANSAAddress Number - ManagerNumericGeneric Edit80 Allow NULL? 
26OFANPASupervisorNumericGeneric Edit80 Allow NULL? 
27OFANPAddress Number - Assigned ToNumericGeneric Edit80 Allow NULL? 
28OFDPLDate - W.O. Planned CompletedDateGeneric Edit60
29OFANTAddress Number - InspectorNumericGeneric Edit80 Allow NULL? 
30OFNAN8Next Address NumberNumericGeneric Edit80 Allow NULL? 
31OFTRDJDate - Order/TransactionDateGeneric Edit60
32OFSTRTDate - Start (Julian)DateGeneric Edit60
33OFDRQJDate - RequestedDateGeneric Edit60
34OFSTRXDate - Completion (Julian)DateGeneric Edit60
35OFDAPDate - Assigned toDateGeneric Edit60
36OFDATDate - Assigned to InspectorDateGeneric Edit60
37OFPPDTDate - Paper Printed DateDateGeneric Edit60
38OFWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
39OFWR02Categories - Work Order 02StringUDC (00 W2)30 Allow NULL? 
40OFWR03Categories - Work Order 03StringUDC (00 W3)30 Allow NULL? 
41OFWR04Categories - Work Order 04StringUDC (00 W4)30 Allow NULL? 
42OFWR05Categories - Work Order 05StringUDC (00 W5)30 Allow NULL? 
43OFWR06EnterpriseOne Consulting - StatusStringUDC (00 W6)30 Allow NULL? 
44OFWR07EnterpriseOne Consulting - Service TypeStringUDC (00 W7)30 Allow NULL? 
45OFWR08EnterpriseOne Consulting - Skill TypeStringUDC (00 W8)30 Allow NULL? 
46OFWR09E1 Consulting - Experience LevelStringUDC (00 W9)30 Allow NULL? 
47OFWR10Categories - Work Order 10StringUDC (00 W0)30 Allow NULL? 
48OFVR01ReferenceStringGeneric Edit250 Allow NULL? 
49OFVR02Reference 2StringGeneric Edit250 Allow NULL? 
50OFAMTOAmount - EstimatedNumericGeneric Edit152 Allow NULL? 
51OFSETCCrew SizeNumericGeneric Edit51 Allow NULL? 
52OFBRTRevenue Rate Markup OverrideNumericGeneric Edit152 Allow NULL? 
53OFPAYTPay/Deduction/Benefit TypeStringGeneric Edit50 Allow NULL? 
54OFAMTCAmount - Change to Original DollarsNumericGeneric Edit152 Allow NULL? 
55OFHRSOHours - EstimatedNumericGeneric Edit152 Allow NULL? 
56OFHRSCHours - Change to Original HoursNumericGeneric Edit152 Allow NULL? 
57OFAMTAAmount - ActualNumericGeneric Edit152 Allow NULL? 
58OFHRSAHours - ActualNumericGeneric Edit152 Allow NULL? 
59OFSHNOMessage NumberStringGeneric Edit100 Allow NULL? 
60OFPBTMTime - Beginning (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
61OFTBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
62OFTRTType of RoutingStringUDC (40 TR)30 Allow NULL? 
63OFSHTYWO Pick List PrintedCharacterUDC (H00 SH)10 Allow NULL? 
64OFPECPosting EditCharacterUDC (H00 PE)10 Allow NULL? 
65OFPPFGVariance FlagCharacterUDC (H00 PP)10 Allow NULL? 
66OFBMBill of Material (N)CharacterGeneric Edit10 Allow NULL? 
67OFRTGRoute Sheet (N)CharacterGeneric Edit10 Allow NULL? 
68OFSPRTWork Order Flash MessageCharacterUDC (00 WM)10 Allow NULL? 
69OFUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
70OFINDCIndented CodeCharacterGeneric Edit10 Allow NULL? 
71OFRESCResequence CodeNumericGeneric Edit52 Allow NULL? 
72OFMOHAmount - Miles or Hours (units)NumericGeneric Edit152 Allow NULL? 
73OFTDTDate - Scheduled TicklerDateGeneric Edit60
74OFPOUAmount - Memo Budget ChangesNumericGeneric Edit152 Allow NULL? 
75OFPCPercent CompleteNumericGeneric Edit50 Allow NULL? 
76OFLTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
77OFLTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
78OFCTS1Hours - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
79OFLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
80OFLOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
81OFLOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
82OFRAT1Ratio _ Critical Ratio Priority 1NumericGeneric Edit52 Allow NULL? 
83OFRAT2Ratio - Critical Ratio Priority 2NumericGeneric Edit52 Allow NULL? 
84OFDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
85OFSBLISubledger Inactive CodeCharacterUDC (00 SI)10 Allow NULL? 
86OFRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
87OFBREVBill Revision LevelStringGeneric Edit30 Allow NULL? 
88OFRREVRouting Revision LevelStringGeneric Edit30 Allow NULL? 
89OFDRWCDrawing ChangeCharacterGeneric Edit10 Allow NULL? 
90OFRTCHRouting ChangeCharacterGeneric Edit10 Allow NULL? 
91OFPNRQNew Part NumberCharacterGeneric Edit10 Allow NULL? 
92OFREASReason for ECOStringUDC (40 CR)20 Allow NULL? 
93OFPHSEPhase InStringUDC (40 PH)30 Allow NULL? 
94OFXDSPExisting DispositionStringUDC (40 ED)30 Allow NULL? 
95OFBOMCBOM ChangeCharacterGeneric Edit10 Allow NULL? 
96OFURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
97OFURDTUser Reserved DateDateGeneric Edit60
98OFURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
99OFURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
100OFURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
101OFUSERUser IDStringGeneric Edit100 Allow NULL? 
102OFPIDProgram IDStringGeneric Edit100 Allow NULL? 
103OFJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
104OFUPMJDate - UpdatedDateGeneric Edit60
105OFTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
106OFAAIDParent NumberNumericGeneric Edit80 Allow NULL? 
107OFNTSTNext Status - W.O.StringUDC (00 SS)20 Allow NULL? 
108OFXRTOCriticality - Work OrderNumericGeneric Edit40 Allow NULL? 
109OFESDNEstimated Downtime HoursNumericGeneric Edit52 Allow NULL? 
110OFACDNActual Downtime HoursNumericGeneric Edit52 Allow NULL? 
111OFSAIDService Address NumberNumericGeneric Edit80 Allow NULL? 
112OFMPOSMeter PositionNumericGeneric Edit30 Allow NULL? 
113OFAPRTApproval TypeStringUDC (48 AP)30 Allow NULL? 
114OFAMLCAmount - Estimated LaborNumericGeneric Edit152 Allow NULL? 
115OFAMMCAmount - Estimated MaterialNumericGeneric Edit152 Allow NULL? 
116OFAMOTAmount - Estimated OtherNumericGeneric Edit152 Allow NULL? 
117OFLBAMAmount - Actual LaborNumericGeneric Edit152 Allow NULL? 
118OFMTAMAmount - Actual MaterialNumericGeneric Edit152 Allow NULL? 
119OFC9COLLCollectionStringGeneric Edit100 Allow NULL? 
120OFC9SEACSeason CodeStringUDC (41F SE)20 Allow NULL? 
121OFC9SEAYSeason YearStringUDC (41F SY)40 Allow NULL? 

TOP920 | 41F | FCW65 INDEXES

NumberDescription
1C9LANC (Primary/Unique)
ElementAliasDescriptionSequence
1C9LANCMaster Work OrderAscending