JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

81 COLUMNS | 1 INDEXES | Print definition?910 | 41 | F4101M TABLE

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4101MIM811Item Manufacturing DataSecondary Master Files41: Inventory 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 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, IMMOPTH, IMMCUTH, IMCUMTH, IMATPRN, IMATPCA, IMATPAC, IMVCPFC FROM F4101M

TOP910 | 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? 
66IMOPTHMinimum Operational ThresholdNumericGeneric Edit154 Allow NULL? 
67IMCUTHMinimum Cumulative ThresholdNumericGeneric Edit154 Allow NULL? 
68IMUMTHOperational Threshold 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? 
75IMMOPTHMaximum Operational ThresholdNumericGeneric Edit154 Allow NULL? 
76IMMCUTHMaximum Cumulative ThresholdNumericGeneric Edit154 Allow NULL? 
77IMCUMTHCumulative Threshold Unit of MeasureStringUDC (31B UM)30 Allow NULL? 
78IMATPRNATP Rule NameStringGeneric Edit800 Allow NULL? 
79IMATPCACheck ATPCharacterUDC (34A CA)10 Allow NULL? 
80IMATPACATP ComponentsStringUDC (34A AP)50 Allow NULL? 
81IMVCPFCATO Forecast ControlStringUDC (34A CF)200 Allow NULL? 

TOP910 | 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