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

136 COLUMNS | 1 INDEXES | Print definition?910 | 41 | F4101A TABLE

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4101AIM1361Item FileSecondary 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, IMLITM, IMAITM, IMDSC1, IMDSC2, IMSRTX, IMALN, IMCDCD, IMPDGR, IMDSGP, IMPRGR, IMRPRC, IMORPR, IMBUYR, IMVCUD, IMUOM1, IMUOM2, IMUOM3, IMUOM4, IMUOM6, IMUOM8, IMUOM9, IMUWUM, IMUVM1, IMSUTM, IMUMVW, IMGLPT, IMPLEV, IMPPLV, IMCLEV, IMCKAV, IMBPFG, IMSRCE, IMCOTY, IMSTKT, IMLNTY, IMCONT, IMBACK, IMIFLA, IMTFLA, IMINMG, IMABCS, IMABCM, IMABCI, IMOVR, IMWARR, IMCMCG, IMSRNR, IMPMTH, IMFIFO, IMLOTS, IMSLD, IMANPL, IMPCTM, IMMMPC, IMORDW, IMEXPD, IMDEFD, IMSFLT, IMMAKE, IMCOBY, IMLLX, IMCMGL, IMCOMH, IMVEND, IMORIG, IMWOMO, IMSERV, IMFUF1, IMTX, IMTAX1, IMMRPD, IMMRPC, IMMOVD, IMBQTY, IMLFDJ, IMMLOT, IMLOCN, IMLOTN, IMURCD, IMURDT, IMURAT, IMURAB, IMURRF, IMUSER, IMPID, IMJOBN, IMUPMJ, IMTDAY, IMTMPL, IMSEG1, IMSEG2, IMSEG3, IMSEG4, IMSEG5, IMSEG6, IMSEG7, IMSEG8, IMSEG9, IMSEG0, IMCMDM, IMDPPO, IMDUAL, IMLECM, IMMIC, IMXDCK, IMBBDD, IMAING, IMLEDD, IMPEFD, IMSBDD, IMU1DD, IMU2DD, IMU3DD, IMU4DD, IMU5DD, IMDLTL, IMLOTC, IMCMETH, IMLAF, IMLTFM, IMRWLA, IMLNPA, IMASHL, IMVMINV, IMTNAC, IMCOORE, IMPNYN FROM F4101A

TOP910 | 41 | F4101A 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? 
10IMLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
11IMAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
12IMDSC1DescriptionStringGeneric Edit300 Allow NULL? 
13IMDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
14IMSRTXSearch TextStringGeneric Edit300 Allow NULL? 
15IMALNSearch Text - CompressedStringGeneric Edit300 Allow NULL? 
16IMCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
17IMPDGRProduct GroupStringUDC (41B PG)30 Allow NULL? 
18IMDSGPDispatch GroupStringUDC (41B DG)30 Allow NULL? 
19IMPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
20IMRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
21IMORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
22IMBUYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
23IMVCUDCubic Dimensions - VolumeNumericGeneric Edit154 Allow NULL? 
24IMUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
25IMUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
26IMUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
27IMUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
28IMUOM6Unit of Measure - ShippingStringUDC (00 UM)20 Allow NULL? 
29IMUOM8Unit of Measure - ProductionStringUDC (00 UM)20 Allow NULL? 
30IMUOM9Unit of Measure - ComponentStringUDC (00 UM)20 Allow NULL? 
31IMUWUMUnit of Measure - WeightStringUDC (00 UM)20 Allow NULL? 
32IMUVM1Unit of Measure - VolumeStringUDC (00 UM)20 Allow NULL? 
33IMSUTMUnit of Measure - StockingStringUDC (00 UM)20 Allow NULL? 
34IMUMVWUnit of Measure - Volume or WeightCharacterUDC (39 VW)10 Allow NULL? 
35IMGLPTCategory - G/LStringUDC (41 9)40 Allow NULL? 
36IMPLEVLevel - Sales Base PriceCharacterUDC (H40 PL)10 Allow NULL? 
37IMPPLVLevel - Purchase PriceCharacterUDC (H40 PP)10 Allow NULL? 
38IMCLEVLevel - Inventory CostCharacterUDC (H40 CL)10 Allow NULL? 
39IMCKAVCheck Availability Y/NCharacterGeneric Edit10 Allow NULL? 
40IMBPFGBulk/Packed FlagCharacterUDC (41B BF)10 Allow NULL? 
41IMSRCELayer Code - SourceCharacterUDC (H41 SR)10 Allow NULL? 
42IMCOTYComponent TypeCharacterUDC (H40 CP)10 Allow NULL? 
43IMSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
44IMLNTYLine TypeStringGeneric Edit20 Allow NULL? 
45IMCONTContract - ItemCharacterGeneric Edit10 Allow NULL? 
46IMBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
47IMIFLAItem Flash MessageStringUDC (40 FL)20 Allow NULL? 
48IMTFLAStandard Unit of Measure ConversionStringUDC (H40 ST)20 Allow NULL? 
49IMINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
50IMABCSABC Code 1 - Sales - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
51IMABCMABC Code 1 - Margin - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
52IMABCIABC Code 3 - Investment - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
53IMOVRABC Code Override IndicatorCharacterGeneric Edit10 Allow NULL? 
54IMWARRType WarrantyStringGeneric Edit80 Allow NULL? 
55IMCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
56IMSRNRSerial Number RequiredCharacterUDC (H41 NR)10 Allow NULL? 
57IMPMTHMethod - Kit/Configurator PricingCharacterUDC (H41 PM)10 Allow NULL? 
58IMFIFOFIFO ProcessingCharacterGeneric Edit10 Allow NULL? 
59IMLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
60IMSLDDays - Shelf Life DaysNumericGeneric Edit60 Allow NULL? 
61IMANPLPlanner NumberNumericGeneric Edit80 Allow NULL? 
62IMPCTMPercent MarginNumericGeneric Edit73 Allow NULL? 
63IMMMPCMargin Maintenance (%)NumericGeneric Edit73 Allow NULL? 
64IMORDWOrder WithCharacterGeneric Edit10 Allow NULL? 
65IMEXPDExpedite Damper DaysNumericGeneric Edit50 Allow NULL? 
66IMDEFDDefer Damper DaysNumericGeneric Edit50 Allow NULL? 
67IMSFLTSafety LeadtimeNumericGeneric Edit50 Allow NULL? 
68IMMAKEMake/Buy CodeCharacterUDC (H40 MA)10 Allow NULL? 
69IMCOBYCo-Products/By-Products/IntermediateCharacterUDC (H40 CO)10 Allow NULL? 
70IMLLXLow Level CodeNumericGeneric Edit30 Allow NULL? 
71IMCMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
72IMCOMHCommitment - Specific (Days)NumericGeneric Edit30 Allow NULL? 
73IMVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
74IMORIGCountry of OriginStringUDC (00 CN)30 Allow NULL? 
75IMWOMOQuantity - Order Multiples (SO/PO)NumericGeneric Edit70 Allow NULL? 
76IMSERVService LevelNumericGeneric Edit70 Allow NULL? 
77IMFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
78IMTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
79IMTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
80IMMRPDItem Display CodeCharacterUDC (H41 MR)10 Allow NULL? 
81IMMRPCFlag - Net ChangeCharacterUDC (H41 MQ)10 Allow NULL? 
82IMMOVDMove Hours - StandardNumericGeneric Edit52 Allow NULL? 
83IMBQTYUnits - Batch QuantityNumericGeneric Edit152 Allow NULL? 
84IMLFDJDate - Future UseDateGeneric Edit60
85IMMLOTMix Dates / Lots (Y/N)CharacterGeneric Edit10 Allow NULL? 
86IMLOCNLocationStringGeneric Edit200 Allow NULL? 
87IMLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
88IMURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
89IMURDTUser Reserved DateDateGeneric Edit60
90IMURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
91IMURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
92IMURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
93IMUSERUser IDStringGeneric Edit100 Allow NULL? 
94IMPIDProgram IDStringGeneric Edit100 Allow NULL? 
95IMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
96IMUPMJDate - UpdatedDateGeneric Edit60
97IMTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
98IMTMPLTemplateStringGeneric Edit200 Allow NULL? 
99IMSEG1Segment 1StringGeneric Edit100 Allow NULL? 
100IMSEG2Segment 2StringGeneric Edit100 Allow NULL? 
101IMSEG3Segment 3StringGeneric Edit100 Allow NULL? 
102IMSEG4Segment 4StringGeneric Edit100 Allow NULL? 
103IMSEG5Segment 5StringGeneric Edit100 Allow NULL? 
104IMSEG6Segment 6StringGeneric Edit100 Allow NULL? 
105IMSEG7Segment 7StringGeneric Edit100 Allow NULL? 
106IMSEG8Segment 8StringGeneric Edit100 Allow NULL? 
107IMSEG9Segment 9StringGeneric Edit100 Allow NULL? 
108IMSEG0Segment 10StringGeneric Edit100 Allow NULL? 
109IMCMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
110IMDPPODual Picking Process OptionCharacterGeneric Edit10 Allow NULL? 
111IMDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
112IMLECMLot Expiraton Date Calculation MethodCharacterUDC (H41 EC)10 Allow NULL? 
113IMMICMatrix ControlledCharacterUDC (41 MA)10 Allow NULL? 
114IMXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
115IMBBDDBest Before Default DaysNumericGeneric Edit60 Allow NULL? 
116IMAINGActive Ingredient FlagCharacterGeneric Edit10 Allow NULL? 
117IMLEDDLot Effective Default DaysNumericGeneric Edit60 Allow NULL? 
118IMPEFDPurchasing Effective DaysNumericGeneric Edit60 Allow NULL? 
119IMSBDDSell By Default DaysNumericGeneric Edit60 Allow NULL? 
120IMU1DDUser Lot Date 1 Default DaysNumericGeneric Edit60 Allow NULL? 
121IMU2DDUser Lot Date 2 Default DaysNumericGeneric Edit60 Allow NULL? 
122IMU3DDUser Lot Date 3 Default DaysNumericGeneric Edit60 Allow NULL? 
123IMU4DDUser Lot Date 4 Default DaysNumericGeneric Edit60 Allow NULL? 
124IMU5DDUser Lot Date 5 Default DaysNumericGeneric Edit60 Allow NULL? 
125IMDLTLDual ToleranceNumericGeneric Edit72 Allow NULL? 
126IMLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
127IMCMETHMethod - Configurator CostingCharacterUDC (41 CM)10 Allow NULL? 
128IMLAFLot Audit FlagCharacterGeneric Edit10 Allow NULL? 
129IMLTFMSpecial Lot FormatCharacterGeneric Edit10 Allow NULL? 
130IMRWLARestrict Work Order Lot AssignmentCharacterGeneric Edit10 Allow NULL? 
131IMLNPALot Number Pre-AssignmentCharacterGeneric Edit10 Allow NULL? 
132IMASHLAllow Shipping of Held LotsCharacterGeneric Edit10 Allow NULL? 
133IMVMINVVendor Managed InventoryCharacterGeneric Edit10 Allow NULL? 
134IMTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
135IMCOORECountry of Origin Required FlagCharacterGeneric Edit10 Allow NULL? 
136IMPNYNProduction Number ControlledCharacterGeneric Edit10 Allow NULL? 

TOP910 | 41 | F4101A INDEXES

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