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

129 COLUMNS | 1 INDEXES | Print definition?920 | 41F | FCW10 TABLE

41F: Apparel Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920FCW10WB1291Item Branch Work FileFiles41F: 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 WBITM, WBMCU, WBEV01, WBSTKT, WBGLPT, WBLNTY, WBANPL, WBBUYR, WBVEND, WBINMG, WBCMGL, WBORIG, WBTAX1, WBTX, WBSRCE, WBLOTS, WBSRNR, WBCKAV, WBBACK, WBPRGR, WBRPRC, WBORPR, WBMMPC, WBSLD, WBABCS, WBABCM, WBABCI, WBSRP1, WBSRP2, WBSRP3, WBSRP4, WBSRP5, WBSRP6, WBSRP7, WBSRP8, WBSRP9, WBSRP0, WBCARS, WBCARP, WBSHCN, WBSHCM, WBCYCL, WBPRP1, WBPRP2, WBPRP3, WBPRP4, WBPRP5, WBPRP6, WBPRP7, WBPRP8, WBPRP9, WBPRP0, WBOPC, WBOPV, WBMPST, WBMPSP, WBMTF1, WBMTF2, WBMTF3, WBSETL, WBQUED, WBECO, WBECTY, WBECOD, WBPOC, WBAVRT, WBACQ, WBITC, WBTIMB, WBMERL, WBSRNK, WBSRKF, WBLTLV, WBLTMF, WBLTCM, WBLTPU, WBMRPP, WBFRMP, WBMLQ, WBOT1Y, WBSTDP, WBTHRP, WBOT2Y, WBSTDG, WBFRGD, WBTHGD, WBPRODM, WBPRODF, WBMCUZ, WBCCOST, WBRTRND, WBRPRBL, WBDCD1, WBDCD2, WBDCD3, WBDCD4, WBDCD5, WBROQI, WBRQMX, WBRQMN, WBROPI, WBMULT, WBUPC, WBSAFE, WBAING, WBBBDD, WBCMDM, WBLECM, WBLEDD, WBMLOT, WBPEFD, WBSBDD, WBU1DD, WBU2DD, WBU3DD, WBU4DD, WBU5DD, WBXDCK, WBLAF, WBLTFM, WBRWLA, WBLNPA, WBLOTC, WBAPSC, WBPRI1, WBPRI2, WBLTCV, WBASHL, WBCOORE FROM FCW10

TOP920 | 41F | FCW10 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1WBITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
2WBMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
3WBEV01J.D. EnterpriseOne Event Point 01CharacterGeneric Edit10 Allow NULL? 
4WBSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
5WBGLPTCategory - G/LStringUDC (41 9)40 Allow NULL? 
6WBLNTYLine TypeStringGeneric Edit20 Allow NULL? 
7WBANPLPlanner NumberNumericGeneric Edit80 Allow NULL? 
8WBBUYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
9WBVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
10WBINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
11WBCMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
12WBORIGCountry of OriginStringUDC (00 CN)30 Allow NULL? 
13WBTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
14WBTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
15WBSRCELayer Code - SourceCharacterUDC (H41 SR)10 Allow NULL? 
16WBLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
17WBSRNRSerial Number RequiredCharacterUDC (H41 NR)10 Allow NULL? 
18WBCKAVCheck Availability Y/NCharacterGeneric Edit10 Allow NULL? 
19WBBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
20WBPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
21WBRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
22WBORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
23WBMMPCMargin Maintenance (%)NumericGeneric Edit73 Allow NULL? 
24WBSLDDays - Shelf Life DaysNumericGeneric Edit60 Allow NULL? 
25WBABCSABC Code 1 - Sales - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
26WBABCMABC Code 1 - Margin - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
27WBABCIABC Code 3 - Investment - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
28WBSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
29WBSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
30WBSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
31WBSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
32WBSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
33WBSRP6Category Code 6StringUDC (41 06)60 Allow NULL? 
34WBSRP7Category Code 7StringUDC (41 07)60 Allow NULL? 
35WBSRP8Category Code 8StringUDC (41 08)60 Allow NULL? 
36WBSRP9Category Code 9StringUDC (41 09)60 Allow NULL? 
37WBSRP0Category Code 10StringUDC (41 10)60 Allow NULL? 
38WBCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
39WBCARPPreferred Carrier - PurchasingNumericGeneric Edit80 Allow NULL? 
40WBSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
41WBSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
42WBCYCLCycle Count CategoryStringUDC (41 8)30 Allow NULL? 
43WBPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
44WBPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
45WBPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
46WBPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
47WBPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
48WBPRP6Group - Item DimensionStringUDC (41 01)60 Allow NULL? 
49WBPRP7Group - Warehouse Process 1StringUDC (41 02)60 Allow NULL? 
50WBPRP8Group - Warehouse Process 2StringUDC (41 02)60 Allow NULL? 
51WBPRP9Group - Warehouse Process 3StringUDC (41 02)60 Allow NULL? 
52WBPRP0Item PoolStringUDC (41 05)60 Allow NULL? 
53WBOPCOrder Policy CodeCharacterUDC (H41 OP)10 Allow NULL? 
54WBOPVValue - Order PolicyNumericGeneric Edit150 Allow NULL? 
55WBMPSTPlanning CodeCharacterUDC (H41 MP)10 Allow NULL? 
56WBMPSPPlanning Time Fence RuleCharacterUDC (34 TF)10 Allow NULL? 
57WBMTF1Planning Time Fence DaysNumericGeneric Edit50 Allow NULL? 
58WBMTF2Freeze Time Fence DaysNumericGeneric Edit50 Allow NULL? 
59WBMTF3Message Time Fence DaysNumericGeneric Edit50 Allow NULL? 
60WBSETLSetup Labor - StandardNumericGeneric Edit152 Allow NULL? 
61WBQUEDQueue Hours - StandardNumericGeneric Edit52 Allow NULL? 
62WBECOECO NumberStringGeneric Edit120 Allow NULL? 
63WBECTYEngineering Change ReasonStringUDC (40 CR)20 Allow NULL? 
64WBECODDate - Engineering Change DateDateGeneric Edit60
65WBPOCIssue and ReceiptCharacterUDC (43 IR)10 Allow NULL? 
66WBAVRTReplenishment Hours - StandardNumericGeneric Edit152 Allow NULL? 
67WBACQQuantity - Accounting CostNumericGeneric Edit150 Allow NULL? 
68WBITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
69WBTIMBTime Basis CodeCharacterUDC (30 TB)10 Allow NULL? 
70WBMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
71WBSRNKShrink FactorNumericGeneric Edit152 Allow NULL? 
72WBSRKFShrink Factor MethodCharacterUDC (H40 SR)10 Allow NULL? 
73WBLTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
74WBLTMFLeadtime MFGNumericGeneric Edit50 Allow NULL? 
75WBLTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
76WBLTPULeadtime Per UnitNumericGeneric Edit52 Allow NULL? 
77WBMRPPFixed or Variable LeadtimeCharacterUDC (H41 MS)10 Allow NULL? 
78WBFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
79WBMLQQuantity - MFG LeadtimeNumericGeneric Edit150 Allow NULL? 
80WBOT1YPotency ControlCharacterGeneric Edit10 Allow NULL? 
81WBSTDPStandard PotencyNumericGeneric Edit73 Allow NULL? 
82WBTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
83WBOT2YGrade ControlCharacterGeneric Edit10 Allow NULL? 
84WBSTDGStandard GradeStringUDC (40 LG)30 Allow NULL? 
85WBFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
86WBTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
87WBPRODMProduct ModelStringUDC (17 PM)80 Allow NULL? 
88WBPRODFProduct FamilyStringUDC (17 PA)80 Allow NULL? 
89WBMCUZBusiness Unit - AltStringGeneric Edit120 Allow NULL? 
90WBCCOSTS/WM Cost ComponentStringUDC (30 CA)30 Allow NULL? 
91WBRTRNDReturnable FlagCharacterUDC (17 TF)10 Allow NULL? 
92WBRPRBLRepairable FlagCharacterUDC (17 TF)10 Allow NULL? 
93WBDCD1Disposition Code 1StringUDC (17 P1)30 Allow NULL? 
94WBDCD2Disposition Code 2StringUDC (17 P2)30 Allow NULL? 
95WBDCD3Disposition Code 3StringUDC (17 P3)30 Allow NULL? 
96WBDCD4Disposition Code 4StringUDC (17 P4)30 Allow NULL? 
97WBDCD5Disposition Code 5StringUDC (17 P5)30 Allow NULL? 
98WBROQIReorder Quantity - InputNumericGeneric Edit150 Allow NULL? 
99WBRQMXReorder Quantity - MaximumNumericGeneric Edit150 Allow NULL? 
100WBRQMNReorder Quantity - MinimumNumericGeneric Edit150 Allow NULL? 
101WBROPIReorder Point - InputNumericGeneric Edit150 Allow NULL? 
102WBMULTQuantity - Order Multiples (MRP)NumericGeneric Edit150 Allow NULL? 
103WBUPCUnits - Per ContainerNumericGeneric Edit150 Allow NULL? 
104WBSAFESafety StockNumericGeneric Edit150 Allow NULL? 
105WBAINGActive Ingredient FlagCharacterGeneric Edit10 Allow NULL? 
106WBBBDDBest Before Default DaysNumericGeneric Edit60 Allow NULL? 
107WBCMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
108WBLECMLot Expiraton Date Calculation MethodCharacterUDC (H41 EC)10 Allow NULL? 
109WBLEDDLot Effective Default DaysNumericGeneric Edit60 Allow NULL? 
110WBMLOTMix Dates / Lots (Y/N)CharacterGeneric Edit10 Allow NULL? 
111WBPEFDPurchasing Effective DaysNumericGeneric Edit60 Allow NULL? 
112WBSBDDSell By Default DaysNumericGeneric Edit60 Allow NULL? 
113WBU1DDUser Lot Date 1 Default DaysNumericGeneric Edit60 Allow NULL? 
114WBU2DDUser Lot Date 2 Default DaysNumericGeneric Edit60 Allow NULL? 
115WBU3DDUser Lot Date 3 Default DaysNumericGeneric Edit60 Allow NULL? 
116WBU4DDUser Lot Date 4 Default DaysNumericGeneric Edit60 Allow NULL? 
117WBU5DDUser Lot Date 5 Default DaysNumericGeneric Edit60 Allow NULL? 
118WBXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
119WBLAFLot Audit FlagCharacterGeneric Edit10 Allow NULL? 
120WBLTFMSpecial Lot FormatCharacterGeneric Edit10 Allow NULL? 
121WBRWLARestrict Work Order Lot AssignmentCharacterGeneric Edit10 Allow NULL? 
122WBLNPALot Number Pre-AssignmentCharacterGeneric Edit10 Allow NULL? 
123WBLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
124WBAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
125WBPRI1Priority One Alert LevelNumericGeneric Edit154 Allow NULL? 
126WBPRI2Priority Two Alert LevelNumericGeneric Edit154 Allow NULL? 
127WBLTCVLeadtime Conversion FactorNumericGeneric Edit157 Allow NULL? 
128WBASHLAllow Shipping of Held LotsCharacterGeneric Edit10 Allow NULL? 
129WBCOORECountry of Origin Required FlagCharacterGeneric Edit10 Allow NULL? 

TOP920 | 41F | FCW10 INDEXES

NumberDescription
1ITM/MCU/EV01 (Primary/Unique)
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3EV01J.D. EnterpriseOne Event Point 01Ascending