JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

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

209 COLUMNS | 8 INDEXES | Print definition?920 | 41 | F4101 TABLE

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F4101IM2098Item MasterMaster 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 IMITM, IMLITM, IMAITM, IMDSC1, IMDSC2, IMSRTX, IMALN, IMSRP1, IMSRP2, IMSRP3, IMSRP4, IMSRP5, IMSRP6, IMSRP7, IMSRP8, IMSRP9, IMSRP0, IMPRP1, IMPRP2, IMPRP3, IMPRP4, IMPRP5, IMPRP6, IMPRP7, IMPRP8, IMPRP9, IMPRP0, IMCDCD, IMPDGR, IMDSGP, IMPRGR, IMRPRC, IMORPR, IMBUYR, IMDRAW, IMRVNO, IMDSZE, IMVCUD, IMCARS, IMCARP, IMSHCN, IMSHCM, IMUOM1, IMUOM2, IMUOM3, IMUOM4, IMUOM6, IMUOM8, IMUOM9, IMUWUM, IMUVM1, IMSUTM, IMUMVW, IMCYCL, IMGLPT, IMPLEV, IMPPLV, IMCLEV, IMPRPO, IMCKAV, IMBPFG, IMSRCE, IMOT1Y, IMOT2Y, IMSTDP, IMFRMP, IMTHRP, IMSTDG, IMFRGD, IMTHGD, IMCOTY, IMSTKT, IMLNTY, IMCONT, IMBACK, IMIFLA, IMTFLA, IMINMG, IMABCS, IMABCM, IMABCI, IMOVR, IMWARR, IMCMCG, IMSRNR, IMPMTH, IMFIFO, IMLOTS, IMSLD, IMANPL, IMMPST, IMPCTM, IMMMPC, IMPTSC, IMSNS, IMLTLV, IMLTMF, IMLTCM, IMOPC, IMOPV, IMACQ, IMMLQ, IMLTPU, IMMPSP, IMMRPP, IMITC, IMORDW, IMMTF1, IMMTF2, IMMTF3, IMMTF4, IMMTF5, IMEXPD, IMDEFD, IMSFLT, IMMAKE, IMCOBY, IMLLX, IMCMGL, IMCOMH, IMURCD, IMURDT, IMURAT, IMURAB, IMURRF, IMUSER, IMPID, IMJOBN, IMUPMJ, IMTDAY, IMUPCN, IMSCC0, IMUMUP, IMUMDF, IMUMS0, IMUMS1, IMUMS2, IMUMS3, IMUMS4, IMUMS5, IMUMS6, IMUMS7, IMUMS8, IMPOC, IMAVRT, IMEQTY, IMWTRQ, IMTMPL, IMSEG1, IMSEG2, IMSEG3, IMSEG4, IMSEG5, IMSEG6, IMSEG7, IMSEG8, IMSEG9, IMSEG0, IMMIC, IMAING, IMBBDD, IMCMDM, IMLECM, IMLEDD, IMPEFD, IMSBDD, IMU1DD, IMU2DD, IMU3DD, IMU4DD, IMU5DD, IMDLTL, IMDPPO, IMDUAL, IMXDCK, IMLAF, IMLTFM, IMRWLA, IMLNPA, IMLOTC, IMAPSC, IMAUOM, IMCONB, IMGCMP, IMPRI1, IMPRI2, IMASHL, IMVMINV, IMCMETH, IMEXPI, IMOPTH, IMCUTH, IMUMTH, IMLMFG, IMLINE, IMDFTPCT, IMKBIT, IMDFENDITM, IMKANEXLL, IMSCPSELL, IMMOPTH, IMMCUTH, IMCUMTH, IMATPRN, IMATPCA, IMATPAC, IMCOORE, IMVCPFC, IMPNYN FROM F4101

TOP920 | 41 | F4101 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1IMITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
2IMLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
3IMAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
4IMDSC1DescriptionStringGeneric Edit300 Allow NULL? 
5IMDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
6IMSRTXSearch TextStringGeneric Edit300 Allow NULL? 
7IMALNSearch Text - CompressedStringGeneric Edit300 Allow NULL? 
8IMSRP1Sales Catalog SectionStringUDC (41 S1)30 Allow NULL? 
9IMSRP2Sub SectionStringUDC (41 S2)30 Allow NULL? 
10IMSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
11IMSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
12IMSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
13IMSRP6Category Code 6StringUDC (41 06)60 Allow NULL? 
14IMSRP7Category Code 7StringUDC (41 07)60 Allow NULL? 
15IMSRP8Category Code 8StringUDC (41 08)60 Allow NULL? 
16IMSRP9Category Code 9StringUDC (41 09)60 Allow NULL? 
17IMSRP0Category Code 10StringUDC (41 10)60 Allow NULL? 
18IMPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
19IMPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
20IMPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
21IMPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
22IMPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
23IMPRP6Group - Item DimensionStringUDC (41 01)60 Allow NULL? 
24IMPRP7Group - Warehouse Process 1StringUDC (41 02)60 Allow NULL? 
25IMPRP8Group - Warehouse Process 2StringUDC (41 02)60 Allow NULL? 
26IMPRP9Group - Warehouse Process 3StringUDC (41 02)60 Allow NULL? 
27IMPRP0Item PoolStringUDC (41 05)60 Allow NULL? 
28IMCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
29IMPDGRProduct GroupStringUDC (41B PG)30 Allow NULL? 
30IMDSGPDispatch GroupStringUDC (41B DG)30 Allow NULL? 
31IMPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
32IMRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
33IMORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
34IMBUYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
35IMDRAWDrawing NumberStringGeneric Edit200 Allow NULL? 
36IMRVNOLast Revision No.StringGeneric Edit20 Allow NULL? 
37IMDSZEDrawing SizeCharacterGeneric Edit10 Allow NULL? 
38IMVCUDCubic Dimensions - VolumeNumericGeneric Edit154 Allow NULL? 
39IMCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
40IMCARPPreferred Carrier - PurchasingNumericGeneric Edit80 Allow NULL? 
41IMSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
42IMSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
43IMUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
44IMUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
45IMUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
46IMUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
47IMUOM6Unit of Measure - ShippingStringUDC (00 UM)20 Allow NULL? 
48IMUOM8Unit of Measure - ProductionStringUDC (00 UM)20 Allow NULL? 
49IMUOM9Unit of Measure - ComponentStringUDC (00 UM)20 Allow NULL? 
50IMUWUMUnit of Measure - WeightStringUDC (00 UM)20 Allow NULL? 
51IMUVM1Unit of Measure - VolumeStringUDC (00 UM)20 Allow NULL? 
52IMSUTMUnit of Measure - StockingStringUDC (00 UM)20 Allow NULL? 
53IMUMVWUnit of Measure - Volume or WeightCharacterUDC (39 VW)10 Allow NULL? 
54IMCYCLCycle Count CategoryStringUDC (41 8)30 Allow NULL? 
55IMGLPTCategory - G/LStringUDC (41 9)40 Allow NULL? 
56IMPLEVLevel - Sales Base PriceCharacterUDC (H40 PL)10 Allow NULL? 
57IMPPLVLevel - Purchase PriceCharacterUDC (H40 PP)10 Allow NULL? 
58IMCLEVLevel - Inventory CostCharacterUDC (H40 CL)10 Allow NULL? 
59IMPRPOGrade/Potency PricingCharacterUDC (40 LP)10 Allow NULL? 
60IMCKAVCheck Availability Y/NCharacterGeneric Edit10 Allow NULL? 
61IMBPFGBulk/Packed FlagCharacterUDC (41B BF)10 Allow NULL? 
62IMSRCELayer Code - SourceCharacterUDC (H41 SR)10 Allow NULL? 
63IMOT1YPotency ControlCharacterGeneric Edit10 Allow NULL? 
64IMOT2YGrade ControlCharacterGeneric Edit10 Allow NULL? 
65IMSTDPStandard PotencyNumericGeneric Edit73 Allow NULL? 
66IMFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
67IMTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
68IMSTDGStandard GradeStringUDC (40 LG)30 Allow NULL? 
69IMFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
70IMTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
71IMCOTYComponent TypeCharacterUDC (H40 CP)10 Allow NULL? 
72IMSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
73IMLNTYLine TypeStringGeneric Edit20 Allow NULL? 
74IMCONTContract - ItemCharacterGeneric Edit10 Allow NULL? 
75IMBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
76IMIFLAItem Flash MessageStringUDC (40 FL)20 Allow NULL? 
77IMTFLAStandard Unit of Measure ConversionStringUDC (H40 ST)20 Allow NULL? 
78IMINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
79IMABCSABC Code 1 - Sales - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
80IMABCMABC Code 1 - Margin - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
81IMABCIABC Code 3 - Investment - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
82IMOVRABC Code Override IndicatorCharacterGeneric Edit10 Allow NULL? 
83IMWARRType WarrantyStringGeneric Edit80 Allow NULL? 
84IMCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
85IMSRNRSerial Number RequiredCharacterUDC (H41 NR)10 Allow NULL? 
86IMPMTHMethod - Kit/Configurator PricingCharacterUDC (H41 PM)10 Allow NULL? 
87IMFIFOFIFO ProcessingCharacterGeneric Edit10 Allow NULL? 
88IMLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
89IMSLDDays - Shelf Life DaysNumericGeneric Edit60 Allow NULL? 
90IMANPLPlanner NumberNumericGeneric Edit80 Allow NULL? 
91IMMPSTPlanning CodeCharacterUDC (H41 MP)10 Allow NULL? 
92IMPCTMPercent MarginNumericGeneric Edit73 Allow NULL? 
93IMMMPCMargin Maintenance (%)NumericGeneric Edit73 Allow NULL? 
94IMPTSCMaterial StatusStringUDC (40 PS)20 Allow NULL? 
95IMSNSRound to Whole NumberCharacterUDC (H41 SN)10 Allow NULL? 
96IMLTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
97IMLTMFLeadtime MFGNumericGeneric Edit50 Allow NULL? 
98IMLTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
99IMOPCOrder Policy CodeCharacterUDC (H41 OP)10 Allow NULL? 
100IMOPVValue - Order PolicyNumericGeneric Edit150 Allow NULL? 
101IMACQQuantity - Accounting CostNumericGeneric Edit150 Allow NULL? 
102IMMLQQuantity - MFG LeadtimeNumericGeneric Edit150 Allow NULL? 
103IMLTPULeadtime Per UnitNumericGeneric Edit52 Allow NULL? 
104IMMPSPPlanning Time Fence RuleCharacterUDC (34 TF)10 Allow NULL? 
105IMMRPPFixed or Variable LeadtimeCharacterUDC (H41 MS)10 Allow NULL? 
106IMITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
107IMORDWOrder WithCharacterGeneric Edit10 Allow NULL? 
108IMMTF1Planning Time Fence DaysNumericGeneric Edit50 Allow NULL? 
109IMMTF2Freeze Time Fence DaysNumericGeneric Edit50 Allow NULL? 
110IMMTF3Message Time Fence DaysNumericGeneric Edit50 Allow NULL? 
111IMMTF4MPS/MRP Time Fence 4NumericGeneric Edit50 Allow NULL? 
112IMMTF5Shipment Leadtime OffsetNumericGeneric Edit50 Allow NULL? 
113IMEXPDExpedite Damper DaysNumericGeneric Edit50 Allow NULL? 
114IMDEFDDefer Damper DaysNumericGeneric Edit50 Allow NULL? 
115IMSFLTSafety LeadtimeNumericGeneric Edit50 Allow NULL? 
116IMMAKEMake/Buy CodeCharacterUDC (H40 MA)10 Allow NULL? 
117IMCOBYCo-Products/By-Products/IntermediateCharacterUDC (H40 CO)10 Allow NULL? 
118IMLLXLow Level CodeNumericGeneric Edit30 Allow NULL? 
119IMCMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
120IMCOMHCommitment - Specific (Days)NumericGeneric Edit30 Allow NULL? 
121IMURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
122IMURDTUser Reserved DateDateGeneric Edit60
123IMURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
124IMURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
125IMURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
126IMUSERUser IDStringGeneric Edit100 Allow NULL? 
127IMPIDProgram IDStringGeneric Edit100 Allow NULL? 
128IMJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
129IMUPMJDate - UpdatedDateGeneric Edit60
130IMTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
131IMUPCNUPC NumberStringGeneric Edit130 Allow NULL? 
132IMSCC0Aggregate SCC Code (PI=0)StringGeneric Edit140 Allow NULL? 
133IMUMUPUnit of Measure - UPCStringUDC (00 UM)20 Allow NULL? 
134IMUMDFUnit of Measure - Aggregate UPCStringUDC (00 UM)20 Allow NULL? 
135IMUMS0Unit of Measure - SCC(PI=0)StringUDC (00 UM)20 Allow NULL? 
136IMUMS1Unit of Measure - SCC(PI=1)StringUDC (00 UM)20 Allow NULL? 
137IMUMS2Unit of Measure - SCC(PI=2)StringUDC (00 UM)20 Allow NULL? 
138IMUMS3Unit of Measure - SCC(PI=3)StringUDC (00 UM)20 Allow NULL? 
139IMUMS4Unit of Measure - SCC(PI=4)StringUDC (00 UM)20 Allow NULL? 
140IMUMS5Unit of Measure - SCC(PI=5)StringUDC (00 UM)20 Allow NULL? 
141IMUMS6Unit of Measure - SCC(PI=6)StringUDC (00 UM)20 Allow NULL? 
142IMUMS7Unit of Measure - SCC(PI=7)StringUDC (00 UM)20 Allow NULL? 
143IMUMS8Unit of Measure - SCC(PI=8)StringUDC (00 UM)20 Allow NULL? 
144IMPOCIssue and ReceiptCharacterUDC (43 IR)10 Allow NULL? 
145IMAVRTReplenishment Hours - StandardNumericGeneric Edit152 Allow NULL? 
146IMEQTYContainer CodeStringUDC (46 EQ)50 Allow NULL? 
147IMWTRQItem Weight Required Y/NCharacterGeneric Edit10 Allow NULL? 
148IMTMPLTemplateStringGeneric Edit200 Allow NULL? 
149IMSEG1Segment 1StringGeneric Edit100 Allow NULL? 
150IMSEG2Segment 2StringGeneric Edit100 Allow NULL? 
151IMSEG3Segment 3StringGeneric Edit100 Allow NULL? 
152IMSEG4Segment 4StringGeneric Edit100 Allow NULL? 
153IMSEG5Segment 5StringGeneric Edit100 Allow NULL? 
154IMSEG6Segment 6StringGeneric Edit100 Allow NULL? 
155IMSEG7Segment 7StringGeneric Edit100 Allow NULL? 
156IMSEG8Segment 8StringGeneric Edit100 Allow NULL? 
157IMSEG9Segment 9StringGeneric Edit100 Allow NULL? 
158IMSEG0Segment 10StringGeneric Edit100 Allow NULL? 
159IMMICMatrix ControlledCharacterUDC (41 MA)10 Allow NULL? 
160IMAINGActive Ingredient FlagCharacterGeneric Edit10 Allow NULL? 
161IMBBDDBest Before Default DaysNumericGeneric Edit60 Allow NULL? 
162IMCMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
163IMLECMLot Expiraton Date Calculation MethodCharacterUDC (H41 EC)10 Allow NULL? 
164IMLEDDLot Effective Default DaysNumericGeneric Edit60 Allow NULL? 
165IMPEFDPurchasing Effective DaysNumericGeneric Edit60 Allow NULL? 
166IMSBDDSell By Default DaysNumericGeneric Edit60 Allow NULL? 
167IMU1DDUser Lot Date 1 Default DaysNumericGeneric Edit60 Allow NULL? 
168IMU2DDUser Lot Date 2 Default DaysNumericGeneric Edit60 Allow NULL? 
169IMU3DDUser Lot Date 3 Default DaysNumericGeneric Edit60 Allow NULL? 
170IMU4DDUser Lot Date 4 Default DaysNumericGeneric Edit60 Allow NULL? 
171IMU5DDUser Lot Date 5 Default DaysNumericGeneric Edit60 Allow NULL? 
172IMDLTLDual ToleranceNumericGeneric Edit72 Allow NULL? 
173IMDPPODual Picking Process OptionCharacterGeneric Edit10 Allow NULL? 
174IMDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
175IMXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
176IMLAFLot Audit FlagCharacterGeneric Edit10 Allow NULL? 
177IMLTFMSpecial Lot FormatCharacterGeneric Edit10 Allow NULL? 
178IMRWLARestrict Work Order Lot AssignmentCharacterGeneric Edit10 Allow NULL? 
179IMLNPALot Number Pre-AssignmentCharacterGeneric Edit10 Allow NULL? 
180IMLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
181IMAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
182IMAUOMAPS Planning UOMStringGeneric Edit90 Allow NULL? 
183IMCONBConsumableCharacterGeneric Edit10 Allow NULL? 
184IMGCMPCompositionCharacterGeneric Edit10 Allow NULL? 
185IMPRI1Priority One Alert LevelNumericGeneric Edit154 Allow NULL? 
186IMPRI2Priority Two Alert LevelNumericGeneric Edit154 Allow NULL? 
187IMASHLAllow Shipping of Held LotsCharacterGeneric Edit10 Allow NULL? 
188IMVMINVVendor Managed InventoryCharacterGeneric Edit10 Allow NULL? 
189IMCMETHMethod - Configurator CostingCharacterUDC (41 CM)10 Allow NULL? 
190IMEXPIExplode Item (1/0)CharacterGeneric Edit10 Allow NULL? 
191IMOPTHMinimum Operational ThresholdNumericGeneric Edit154 Allow NULL? 
192IMCUTHMinimum Cumulative ThresholdNumericGeneric Edit154 Allow NULL? 
193IMUMTHOperational Threshold Unit of MeasureStringUDC (31B UM)30 Allow NULL? 
194IMLMFGLean Manufacturing FlagCharacterGeneric Edit10 Allow NULL? 
195IMLINELine/Cell IdentifierStringGeneric Edit120 Allow NULL? 
196IMDFTPCTTotal Product Cycle TimeNumericGeneric Edit205 Allow NULL? 
197IMKBITKanban ItemCharacterGeneric Edit10 Allow NULL? 
198IMDFENDITMDemand Flow End Item FlagCharacterGeneric Edit10 Allow NULL? 
199IMKANEXLLKanban Explode to Lower LevelCharacterGeneric Edit10 Allow NULL? 
200IMSCPSELLSellable ItemCharacterUDC (34A SA)10 Allow NULL? 
201IMMOPTHMaximum Operational ThresholdNumericGeneric Edit154 Allow NULL? 
202IMMCUTHMaximum Cumulative ThresholdNumericGeneric Edit154 Allow NULL? 
203IMCUMTHCumulative Threshold Unit of MeasureStringUDC (31B UM)30 Allow NULL? 
204IMATPRNATP Rule NameStringGeneric Edit800 Allow NULL? 
205IMATPCACheck ATPCharacterUDC (34A CA)10 Allow NULL? 
206IMATPACATP ComponentsStringUDC (34A AP)50 Allow NULL? 
207IMCOORECountry of Origin Required FlagCharacterGeneric Edit10 Allow NULL? 
208IMVCPFCATO Forecast ControlStringUDC (34A CF)200 Allow NULL? 
209IMPNYNProduction Number ControlledCharacterGeneric Edit10 Allow NULL? 

TOP920 | 41 | F4101 INDEXES

NumberDescription
1Item Master (Primary/Unique)
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
22nd Item Number (Unique)
ElementAliasDescriptionSequence
1LITM2nd Item NumberAscending
33rd Item Number (Unique)
ElementAliasDescriptionSequence
1AITM3rd Item NumberAscending
4Search Text Compressed
ElementAliasDescriptionSequence
1ALNSearch Text - CompressedAscending
5Low level Code
ElementAliasDescriptionSequence
1LLXLow Level CodeDescending
6Segment1 Seg 2 +
ElementAliasDescriptionSequence
1SEG1Segment 1Ascending
2SEG2Segment 2Ascending
3SEG3Segment 3Ascending
4SEG4Segment 4Ascending
5SEG5Segment 5Ascending
6SEG6Segment 6Ascending
7SEG7Segment 7Ascending
8SEG8Segment 8Ascending
9SEG9Segment 9Ascending
10SEG0Segment 10Ascending
7Template
ElementAliasDescriptionSequence
1TMPLTemplateAscending
8Description Line1
ElementAliasDescriptionSequence
1DSC1DescriptionAscending