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

74 COLUMNS | 1 INDEXES | Print definition?812 | 41 | F4101M TABLE

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F4101MIM741Item Manufacturing DataSecondary Master Files41: Inventory ManagementNo
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 IMMCU, IMITM, IMSTAW, IMEFFT, IMDOC, IMDCT, IMEFFF, IMSERK, IMITBR, IMDRAW, IMRVNO, IMDSZE, IMMPST, IMSNS, IMLTLV, IMLTMF, IMLTCM, IMOPC, IMOPV, IMACQ, IMMLQ, IMLTPU, IMMPSP, IMMRPP, IMITC, IMMTF1, IMMTF2, IMMTF3, IMMTF4, IMMTF5, IMTIMB, IMQUED, IMSETL, IMOT1Y, IMOT2Y, IMSTDP, IMFRMP, IMTHRP, IMSRNK, IMSRKF, IMMERL, IMSTDG, IMFRGD, IMTHGD, IMECO, IMECTY, IMECOD, IMPOC, IMAVRT, IMPTSC, IMPRPO, IMUSER, IMPID, IMJOBN, IMUPMJ, IMTDAY, IMAING, IMCONB, IMPRI1, IMPRI2, IMGCMP, IMAPSC, IMLTCV, IMEXPI, IMKBIT, IMOPTH, IMCUTH, IMUMTH, IMLMFG, IMLINE, IMDFTPCT, IMDFENDITM, IMKANEXLL, IMSCPSELL FROM F4101M

TOP812 | 41 | F4101M COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1IMMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
2IMITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
3IMSTAWStatusCharacterUDC (00 WS)10 Allow NULL? 
4IMEFFTEffective - Thru DateDateGeneric Edit60
5IMDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
6IMDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
7IMEFFFEffective - From DateDateGeneric Edit60
8IMSERKKey Value Serial NumberNumericGeneric Edit150 Allow NULL? 
9IMITBRUpdate Item BranchCharacterGeneric Edit10 Allow NULL? 
10IMDRAWDrawing NumberStringGeneric Edit200 Allow NULL? 
11IMRVNOLast Revision No.StringGeneric Edit20 Allow NULL? 
12IMDSZEDrawing SizeCharacterGeneric Edit10 Allow NULL? 
13IMMPSTPlanning CodeCharacterUDC (H41 MP)10 Allow NULL? 
14IMSNSRound to Whole NumberCharacterUDC (H41 SN)10 Allow NULL? 
15IMLTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
16IMLTMFLeadtime MFGNumericGeneric Edit50 Allow NULL? 
17IMLTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
18IMOPCOrder Policy CodeCharacterUDC (H41 OP)10 Allow NULL? 
19IMOPVValue - Order PolicyNumericGeneric Edit150 Allow NULL? 
20IMACQQuantity - Accounting CostNumericGeneric Edit152 Allow NULL? 
21IMMLQQuantity - MFG LeadtimeNumericGeneric Edit152 Allow NULL? 
22IMLTPULeadtime Per UnitNumericGeneric Edit52 Allow NULL? 
23IMMPSPPlanning Time Fence RuleCharacterUDC (34 TF)10 Allow NULL? 
24IMMRPPFixed or Variable LeadtimeCharacterUDC (H41 MS)10 Allow NULL? 
25IMITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
26IMMTF1Planning Time Fence DaysNumericGeneric Edit50 Allow NULL? 
27IMMTF2Freeze Time Fence DaysNumericGeneric Edit50 Allow NULL? 
28IMMTF3Message Time Fence DaysNumericGeneric Edit50 Allow NULL? 
29IMMTF4MPS/MRP Time Fence 4NumericGeneric Edit50 Allow NULL? 
30IMMTF5Shipment Leadtime OffsetNumericGeneric Edit50 Allow NULL? 
31IMTIMBTime Basis CodeCharacterUDC (30 TB)10 Allow NULL? 
32IMQUEDQueue Hours - StandardNumericGeneric Edit52 Allow NULL? 
33IMSETLSetup Labor - StandardNumericGeneric Edit152 Allow NULL? 
34IMOT1YPotency ControlCharacterGeneric Edit10 Allow NULL? 
35IMOT2YGrade ControlCharacterGeneric Edit10 Allow NULL? 
36IMSTDPStandard PotencyNumericGeneric Edit73 Allow NULL? 
37IMFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
38IMTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
39IMSRNKShrink FactorNumericGeneric Edit152 Allow NULL? 
40IMSRKFShrink Factor MethodCharacterUDC (H40 SR)10 Allow NULL? 
41IMMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
42IMSTDGStandard GradeStringUDC (40 LG)30 Allow NULL? 
43IMFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
44IMTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
45IMECOECO NumberStringGeneric Edit120 Allow NULL? 
46IMECTYEngineering Change ReasonStringUDC (40 CR)20 Allow NULL? 
47IMECODDate - Engineering Change DateDateGeneric Edit60
48IMPOCIssue and ReceiptCharacterUDC (43 IR)10 Allow NULL? 
49IMAVRTReplenishment Hours - StandardNumericGeneric Edit152 Allow NULL? 
50IMPTSCMaterial StatusStringUDC (40 PS)20 Allow NULL? 
51IMPRPOGrade/Potency PricingCharacterUDC (40 LP)10 Allow NULL? 
52IMUSERUser IDStringGeneric Edit100 Allow NULL? 
53IMPIDProgram IDStringGeneric Edit100 Allow NULL? 
54IMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
55IMUPMJDate - UpdatedDateGeneric Edit60
56IMTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
57IMAINGActive Ingredient FlagCharacterGeneric Edit10 Allow NULL? 
58IMCONBConsumableCharacterGeneric Edit10 Allow NULL? 
59IMPRI1Priority One Alert LevelNumericGeneric Edit154 Allow NULL? 
60IMPRI2Priority Two Alert LevelNumericGeneric Edit154 Allow NULL? 
61IMGCMPCompositionCharacterGeneric Edit10 Allow NULL? 
62IMAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
63IMLTCVLeadtime Conversion FactorNumericGeneric Edit157 Allow NULL? 
64IMEXPIExplode Item (1/0)CharacterGeneric Edit10 Allow NULL? 
65IMKBITKanban ItemCharacterGeneric Edit10 Allow NULL? 
66IMOPTHOperational ThresholdNumericGeneric Edit154 Allow NULL? 
67IMCUTHCumulative ThresholdNumericGeneric Edit154 Allow NULL? 
68IMUMTHThreshold Unit of MeasureStringUDC (31B UM)30 Allow NULL? 
69IMLMFGLean Manufacturing FlagCharacterGeneric Edit10 Allow NULL? 
70IMLINELine/Cell IdentifierStringGeneric Edit120 Allow NULL? 
71IMDFTPCTTotal Product Cycle TimeNumericGeneric Edit205 Allow NULL? 
72IMDFENDITMDemand Flow End Item FlagCharacterGeneric Edit10 Allow NULL? 
73IMKANEXLLKanban Explode to Lower LevelCharacterGeneric Edit10 Allow NULL? 
74IMSCPSELLSellable ItemCharacterUDC (34A SA)10 Allow NULL? 

TOP812 | 41 | F4101M INDEXES

NumberDescription
1Branch Item + (Primary/Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3STAWStatusAscending
4EFFTEffective - Thru DateAscending
5DOCDocument (Voucher Invoice etc.)Ascending
6DCTDocument TypeAscending