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

71 COLUMNS | 2 INDEXES | Print definition?910 | 40 | F30UI004 TABLE

40: Inventory/OP Base
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F30UI004WF712Bill of Material Update Work File"T" Work Files30: Product Data ManagementBusiness 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 WFCTID, WFPSQ, WFOKIT, WFOMCU, WFOTBM, WFOBQT, WFOUOM, WFOITM, WFCCMC, WFOCPN, WFLINS, WFKIT, WFMMCU, WFTBM, WFBQTY, WFUOM, WFITM, WFCMCU, WFCPNT, WFOEF, WFOET, WFNET, WFNEF, WFQNTY, WFUM, WFBREV, WFCMRV, WFTIC, WFECPR, WFRSQ, WFERR1, WFERR2, WFERR3, WFOPSQ, WFFORQ, WFOREV, WFUKID, WFMCU, WFRITM, WFTP, WFCPCN, WFCPNN, WFSBNT, WFCOBY, WFSRV, WFRVNO, WFTRV, WFERR4, WFERR5, WFITC, WFFSER, WFTSER, WFLOVD, WFPRIC, WFUNCS, WFFRGD, WFTHGD, WFFRMP, WFTHRP, WFOPTK, WFSCRP, WFFTRC, WFFORV, WFBSEQ, WFPRTA, WFLNTY, WFDSC1, WFFTRP, WFF$RP, WFCPNB, WFBSEQAN FROM F30UI004

TOP910 | 40 | F30UI004 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WFCTIDComputer IDStringGeneric Edit150 Allow NULL? 
2WFPSQPrimary Sequence NumberNumericGeneric Edit62 Allow NULL? 
3WFOKITParent (short) Item Number - OverridesNumericGeneric Edit80 Allow NULL? 
4WFOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
5WFOTBMType Bill of Material - OverridesStringUDC (40 TB)30 Allow NULL? 
6WFOBQTUnits - Batch Quantity OverridesNumericGeneric Edit152 Allow NULL? 
7WFOUOMUnit of Measure - OverrideStringUDC (00 UM)20 Allow NULL? 
8WFOITMItem Number - Short OverridesNumericGeneric Edit80 Allow NULL? 
9WFCCMCComponent Branch OverridesStringGeneric Edit120 Allow NULL? 
10WFOCPNComponent Line Number OverridesNumericGeneric Edit41 Allow NULL? 
11WFLINSWork Order - Line NumberNumericGeneric Edit92 Allow NULL? 
12WFKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
13WFMMCUBranchStringGeneric Edit120 Allow NULL? 
14WFTBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
15WFBQTYUnits - Batch QuantityNumericGeneric Edit152 Allow NULL? 
16WFUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
17WFITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
18WFCMCUComponent BranchStringGeneric Edit120 Allow NULL? 
19WFCPNTComponent Line NumberNumericGeneric Edit41 Allow NULL? 
20WFOEFOld Effective - From DateDateGeneric Edit60
21WFOETOld Effective - From DateDateGeneric Edit60
22WFNETNew Effective - Thru DateDateGeneric Edit60
23WFNEFNew Effective - From DateDateGeneric Edit60
24WFQNTYQuantity - Standard Required QuantityNumericGeneric Edit150 Allow NULL? 
25WFUMUnit of MeasureStringUDC (00 UM)20 Allow NULL? 
26WFBREVBill Revision LevelStringGeneric Edit30 Allow NULL? 
27WFCMRVComponent Revision LevelStringGeneric Edit30 Allow NULL? 
28WFTICType of Item ChangeCharacterUDC (H40 TI)10 Allow NULL? 
29WFECPRParent/Child RelationshipCharacterUDC (H40 EC)10 Allow NULL? 
30WFRSQRelated Sequence NumberNumericGeneric Edit62 Allow NULL? 
31WFERR1Data Field Error Code 1CharacterGeneric Edit10 Allow NULL? 
32WFERR2Data Field Error Code 2CharacterGeneric Edit10 Allow NULL? 
33WFERR3Data Field Error Code 3CharacterGeneric Edit10 Allow NULL? 
34WFOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
35WFFORQFixed or Variable QuantityCharacterUDC (H40 FO)10 Allow NULL? 
36WFOREVOld Revision Level - ToStringGeneric Edit30 Allow NULL? 
37WFUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
38WFMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
39WFRITMItem Number - RelatedNumericGeneric Edit80 Allow NULL? 
40WFTPType CodeStringGeneric Edit30 Allow NULL? 
41WFCPCNQuantity Canceled/Scrapped VarianceNumericGeneric Edit152 Allow NULL? 
42WFCPNNComponent Line NumberNumericGeneric Edit41 Allow NULL? 
43WFSBNTSubstitute Item Sequence NumberNumericGeneric Edit52 Allow NULL? 
44WFCOBYCo-Products/By-Products/IntermediateCharacterUDC (H40 CO)10 Allow NULL? 
45WFSRVRevision Level - Swap ToStringGeneric Edit30 Allow NULL? 
46WFRVNOLast Revision No.StringGeneric Edit20 Allow NULL? 
47WFTRVRevision Level - ToStringGeneric Edit30 Allow NULL? 
48WFERR4Data Field Error Code 4CharacterGeneric Edit10 Allow NULL? 
49WFERR5Data Field Error Code 5CharacterGeneric Edit10 Allow NULL? 
50WFITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
51WFFSEREffective From Serial NumberStringGeneric Edit250 Allow NULL? 
52WFTSEREffective Thru Serial NumberStringGeneric Edit250 Allow NULL? 
53WFLOVDLeadtime Offset DaysNumericGeneric Edit60 Allow NULL? 
54WFPRICUnit Price per PrimaryNumericGeneric Edit154 Allow NULL? 
55WFUNCSAmount - Unit CostNumericGeneric Edit154 Allow NULL? 
56WFFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
57WFTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
58WFFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
59WFTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
60WFOPTKOptional Item (Kit)CharacterUDC (H40 OP)10 Allow NULL? 
61WFSCRPPercent - Percent of ScrapNumericGeneric Edit52 Allow NULL? 
62WFFTRCRequiredCharacterGeneric Edit10 Allow NULL? 
63WFFORVDefault ComponentCharacterGeneric Edit10 Allow NULL? 
64WFBSEQSorszám - Buborék sorszámNumericGeneric Edit50 Allow NULL? 
65WFPRTAPartials Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
66WFLNTYLine TypeStringGeneric Edit20 Allow NULL? 
67WFDSC1DescriptionStringGeneric Edit300 Allow NULL? 
68WFFTRPFeature Planned PercentNumericGeneric Edit52 Allow NULL? 
69WFF$RPFeature Cost PercentNumericGeneric Edit52 Allow NULL? 
70WFCPNBComponent Line Number BOMNumericGeneric Edit82 Allow NULL? 
71WFBSEQANBubble Sequence Alpha NumericStringGeneric Edit50 Allow NULL? 

TOP910 | 40 | F30UI004 INDEXES

NumberDescription
1Primary Seq Parent Num....... (Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2CTIDComputer IDAscending
3PSQPrimary Sequence NumberAscending
4OKITParent (short) Item Number - OverridesAscending
5OMCUProject Business UnitAscending
6OTBMType Bill of Material - OverridesAscending
7OBQTUnits - Batch Quantity OverridesAscending
8OUOMUnit of Measure - OverrideAscending
9OITMItem Number - Short OverridesAscending
10CCMCComponent Branch OverridesAscending
2Primary Unique Key (Primary/Unique)
ElementAliasDescriptionSequence
1CTIDComputer IDAscending
2UKIDUnique Key ID (Internal)Ascending