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

262 COLUMNS | 1 INDEXES | Print definition?910 | 41 | F4101Z1 TABLE

41: Inventory Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4101Z1SZ2621F4101 Item Master Unedited Transaction TableMaster 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 SZEDUS, SZEDBT, SZEDTN, SZEDLN, SZEDCT, SZTYTN, SZEDFT, SZEDDT, SZDRIN, SZEDDL, SZEDSP, SZPNID, SZTNAC, SZITBR, SZITM, SZKIT, SZLITM, SZAITM, SZDSC1, SZDSC2, SZSRTX, SZALN, SZSRP1, SZSRP2, SZSRP3, SZSRP4, SZSRP5, SZSRP6, SZSRP7, SZSRP8, SZSRP9, SZSRP0, SZPRP1, SZPRP2, SZPRP3, SZPRP4, SZPRP5, SZPRP6, SZPRP7, SZPRP8, SZPRP9, SZPRP0, SZCDCD, SZPDGR, SZDSGP, SZPRGR, SZRPRC, SZORPR, SZBUYR, SZDRAW, SZRVNO, SZDSZE, SZVCUD, SZCARS, SZCARP, SZSHCN, SZSHCM, SZUOM1, SZUOM2, SZUOM3, SZUOM4, SZUOM6, SZUOM8, SZUOM9, SZUWUM, SZUVM1, SZSUTM, SZUMVW, SZCYCL, SZGLPT, SZPLEV, SZPPLV, SZCLEV, SZPRPO, SZCKAV, SZBPFG, SZSRCE, SZOT1Y, SZOT2Y, SZSTDP, SZFRMP, SZTHRP, SZSTDG, SZFRGD, SZTHGD, SZCOTY, SZSTKT, SZLNTY, SZCONT, SZBACK, SZIFLA, SZTFLA, SZINMG, SZABCS, SZABCM, SZABCI, SZOVR, SZWARR, SZCMCG, SZSRNR, SZPMTH, SZFIFO, SZLOTS, SZSLD, SZANPL, SZMPST, SZPCTM, SZMMPC, SZPTSC, SZSNS, SZLTLV, SZLTMF, SZLTCM, SZOPC, SZOPV, SZACQ, SZMLQ, SZLTPU, SZMPSP, SZMRPP, SZITC, SZORDW, SZMTF1, SZMTF2, SZMTF3, SZMTF4, SZMTF5, SZEXPD, SZDEFD, SZSFLT, SZMAKE, SZCOBY, SZLLX, SZCMGL, SZCOMH, SZAVRT, SZUPCN, SZSCC0, SZUMDF, SZUMS0, SZUMUP, SZUMS1, SZUMS2, SZUMS3, SZUMS4, SZUMS5, SZUMS6, SZUMS7, SZUMS8, SZWTRQ, SZEQTY, SZPOC, SZMCU, SZMMCU, SZVEND, SZORIG, SZROPI, SZROQI, SZRQMX, SZRQMN, SZWOMO, SZSERV, SZSAFE, SZFUF1, SZTX, SZTAX1, SZMRPD, SZMRPC, SZUPC, SZMERL, SZECO, SZECTY, SZECOD, SZMOVD, SZQUED, SZSETL, SZSRNK, SZSRKF, SZTIMB, SZBQTY, SZMULT, SZLFDJ, SZMLOT, SZLOCN, SZLOTN, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZSTAW, SZEFFT, SZDOC, SZDCT, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZTMPL, SZSEG1, SZSEG2, SZSEG3, SZSEG4, SZSEG5, SZSEG6, SZSEG7, SZSEG8, SZSEG9, SZSEG0, SZAING, SZCMDM, SZDPPO, SZDUAL, SZLECM, SZMIC, SZXDCK, SZDLTL, SZLEDD, SZPEFD, SZSBDD, SZU1DD, SZU2DD, SZU3DD, SZU4DD, SZU5DD, SZBBDD, SZLOTC, SZEXPI, SZCONB, SZPRI1, SZPRI2, SZGCMP, SZAPSC, SZCMETH, SZLAF, SZLTFM, SZRWLA, SZLNPA, SZASHL, SZVMINV, SZLTCV, SZOPTH, SZCUTH, SZUMTH, SZLMFG, SZLINE, SZDFTPCT, SZKBIT, SZDFENDITM, SZKANEXLL, SZSCPSELL, SZMOPTH, SZMCUTH, SZCUMTH, SZATPRN, SZATPCA, SZATPAC, SZCOORE, SZVCPFC, SZPNYN FROM F4101Z1

TOP910 | 41 | F4101Z1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SZEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2SZEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3SZEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4SZEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5SZEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6SZTYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7SZEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8SZEDDTEDI - Transmission DateDateGeneric Edit60
9SZDRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10SZEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11SZEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12SZPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13SZTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14SZITBRUpdate Item BranchCharacterGeneric Edit10 Allow NULL? 
15SZITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
16SZKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
17SZLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
18SZAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
19SZDSC1DescriptionStringGeneric Edit300 Allow NULL? 
20SZDSC2Description - Line 2StringGeneric Edit300 Allow NULL? 
21SZSRTXSearch TextStringGeneric Edit300 Allow NULL? 
22SZALNSearch Text - CompressedStringGeneric Edit300 Allow NULL? 
23SZSRP1Sales Rpt 01 - Product FamilyStringUDC (41 S1)30 Allow NULL? 
24SZSRP2Sales Rpt 02 - Family SectionStringUDC (41 S2)30 Allow NULL? 
25SZSRP3Sales Category Code 3StringUDC (41 S3)30 Allow NULL? 
26SZSRP4Sales Category Code 4StringUDC (41 S4)30 Allow NULL? 
27SZSRP5Sales Category Code 5StringUDC (41 S5)30 Allow NULL? 
28SZSRP6Sales Rpt 06 - Product Line (Revenue)StringUDC (41 06)60 Allow NULL? 
29SZSRP7Category Code 7StringUDC (41 07)60 Allow NULL? 
30SZSRP8Sales Rpt 08 - Product Discount GroupStringUDC (41 08)60 Allow NULL? 
31SZSRP9Category Code 9StringUDC (41 09)60 Allow NULL? 
32SZSRP0Category Code 10StringUDC (41 10)60 Allow NULL? 
33SZPRP1Commodity ClassStringUDC (41 P1)30 Allow NULL? 
34SZPRP2Commodity Sub ClassStringUDC (41 P2)30 Allow NULL? 
35SZPRP3Supplier Rebate CodeStringUDC (41 P3)30 Allow NULL? 
36SZPRP4Master Planning FamilyStringUDC (41 P4)30 Allow NULL? 
37SZPRP5Purchasing Category Code 5StringUDC (41 P5)30 Allow NULL? 
38SZPRP6Group - Item DimensionStringUDC (41 01)60 Allow NULL? 
39SZPRP7Group - Warehouse Process 1StringUDC (41 02)60 Allow NULL? 
40SZPRP8Group - Warehouse Process 2StringUDC (41 02)60 Allow NULL? 
41SZPRP9Group - Warehouse Process 3StringUDC (41 02)60 Allow NULL? 
42SZPRP0Item PoolStringUDC (41 05)60 Allow NULL? 
43SZCDCDCommodity CodeStringGeneric Edit150 Allow NULL? 
44SZPDGRProduct GroupStringUDC (41B PG)30 Allow NULL? 
45SZDSGPDispatch GroupStringUDC (41B DG)30 Allow NULL? 
46SZPRGRItem Price GroupStringUDC (40 PI)80 Allow NULL? 
47SZRPRCReprice (Basket Price) CategoryStringUDC (40 PI)80 Allow NULL? 
48SZORPROrder Reprice CategoryStringUDC (40 PI)80 Allow NULL? 
49SZBUYRBuyer NumberNumericGeneric Edit80 Allow NULL? 
50SZDRAWDrawing NumberStringGeneric Edit200 Allow NULL? 
51SZRVNOLast Revision No.StringGeneric Edit20 Allow NULL? 
52SZDSZEDrawing SizeCharacterGeneric Edit10 Allow NULL? 
53SZVCUDCubic Dimensions - VolumeNumericGeneric Edit154 Allow NULL? 
54SZCARSCarrier NumberNumericGeneric Edit80 Allow NULL? 
55SZCARPPreferred Carrier - PurchasingNumericGeneric Edit80 Allow NULL? 
56SZSHCNShipping Conditions CodeStringUDC (41 C)30 Allow NULL? 
57SZSHCMShipping Commodity ClassStringUDC (41 E)30 Allow NULL? 
58SZUOM1Unit of Measure - PrimaryStringUDC (00 UM)20 Allow NULL? 
59SZUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
60SZUOM3Unit of Measure - PurchasingStringUDC (00 UM)20 Allow NULL? 
61SZUOM4Unit of Measure - PricingStringUDC (00 UM)20 Allow NULL? 
62SZUOM6Unit of Measure - ShippingStringUDC (00 UM)20 Allow NULL? 
63SZUOM8Unit of Measure - ProductionStringUDC (00 UM)20 Allow NULL? 
64SZUOM9Unit of Measure - ComponentStringUDC (00 UM)20 Allow NULL? 
65SZUWUMUnit of Measure - WeightStringUDC (00 UM)20 Allow NULL? 
66SZUVM1Unit of Measure - VolumeStringUDC (00 UM)20 Allow NULL? 
67SZSUTMUnit of Measure - StockingStringUDC (00 UM)20 Allow NULL? 
68SZUMVWUnit of Measure - Volume or WeightCharacterUDC (39 VW)10 Allow NULL? 
69SZCYCLCycle Count CategoryStringUDC (41 8)30 Allow NULL? 
70SZGLPTCategory - G/LStringUDC (41 9)40 Allow NULL? 
71SZPLEVLevel - Sales Base PriceCharacterUDC (H40 PL)10 Allow NULL? 
72SZPPLVLevel - Purchase PriceCharacterUDC (H40 PP)10 Allow NULL? 
73SZCLEVLevel - Inventory CostCharacterUDC (H40 CL)10 Allow NULL? 
74SZPRPOGrade/Potency PricingCharacterUDC (40 LP)10 Allow NULL? 
75SZCKAVCheck Availability Y/NCharacterGeneric Edit10 Allow NULL? 
76SZBPFGBulk/Packed FlagCharacterUDC (41B BF)10 Allow NULL? 
77SZSRCELayer Code - SourceCharacterUDC (H41 SR)10 Allow NULL? 
78SZOT1YPotency ControlCharacterGeneric Edit10 Allow NULL? 
79SZOT2YGrade ControlCharacterGeneric Edit10 Allow NULL? 
80SZSTDPStandard PotencyNumericGeneric Edit73 Allow NULL? 
81SZFRMPFrom PotencyNumericGeneric Edit73 Allow NULL? 
82SZTHRPThru PotencyNumericGeneric Edit73 Allow NULL? 
83SZSTDGStandard GradeStringUDC (40 LG)30 Allow NULL? 
84SZFRGDFrom GradeStringUDC (40 LG)30 Allow NULL? 
85SZTHGDThru GradeStringUDC (40 LG)30 Allow NULL? 
86SZCOTYComponent TypeCharacterUDC (H40 CP)10 Allow NULL? 
87SZSTKTStocking TypeCharacterUDC (41 I)10 Allow NULL? 
88SZLNTYLine TypeStringGeneric Edit20 Allow NULL? 
89SZCONTContract - ItemCharacterGeneric Edit10 Allow NULL? 
90SZBACKBackorders Allowed (Y/N)CharacterGeneric Edit10 Allow NULL? 
91SZIFLAItem Flash MessageStringUDC (40 FL)20 Allow NULL? 
92SZTFLAStandard Unit of Measure ConversionStringUDC (H40 ST)20 Allow NULL? 
93SZINMGPrint MessageStringUDC (40 PM)100 Allow NULL? 
94SZABCSABC Code 1 - Sales - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
95SZABCMABC Code 1 - Margin - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
96SZABCIABC Code 3 - Investment - InventoryCharacterUDC (H41 AB)10 Allow NULL? 
97SZOVRABC Code Override IndicatorCharacterGeneric Edit10 Allow NULL? 
98SZWARRType WarrantyStringGeneric Edit80 Allow NULL? 
99SZCMCGCommission CategoryStringGeneric Edit80 Allow NULL? 
100SZSRNRSerial Number RequiredCharacterUDC (H41 NR)10 Allow NULL? 
101SZPMTHMethod - Kit/Configurator PricingCharacterUDC (H41 PM)10 Allow NULL? 
102SZFIFOFIFO ProcessingCharacterGeneric Edit10 Allow NULL? 
103SZLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
104SZSLDDays - Shelf Life DaysNumericGeneric Edit60 Allow NULL? 
105SZANPLPlanner NumberNumericGeneric Edit80 Allow NULL? 
106SZMPSTPlanning CodeCharacterUDC (H41 MP)10 Allow NULL? 
107SZPCTMPercent MarginNumericGeneric Edit73 Allow NULL? 
108SZMMPCMargin Maintenance (%)NumericGeneric Edit73 Allow NULL? 
109SZPTSCMaterial StatusStringUDC (40 PS)20 Allow NULL? 
110SZSNSRound to Whole NumberCharacterUDC (H41 SN)10 Allow NULL? 
111SZLTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
112SZLTMFLeadtime MFGNumericGeneric Edit50 Allow NULL? 
113SZLTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
114SZOPCOrder Policy CodeCharacterUDC (H41 OP)10 Allow NULL? 
115SZOPVValue - Order PolicyNumericGeneric Edit150 Allow NULL? 
116SZACQQuantity - Accounting CostNumericGeneric Edit152 Allow NULL? 
117SZMLQQuantity - MFG LeadtimeNumericGeneric Edit152 Allow NULL? 
118SZLTPULeadtime Per UnitNumericGeneric Edit52 Allow NULL? 
119SZMPSPPlanning Time Fence RuleCharacterUDC (34 TF)10 Allow NULL? 
120SZMRPPFixed or Variable LeadtimeCharacterUDC (H41 MS)10 Allow NULL? 
121SZITCIssue Type CodeCharacterUDC (41 IT)10 Allow NULL? 
122SZORDWOrder WithCharacterGeneric Edit10 Allow NULL? 
123SZMTF1Planning Time Fence DaysNumericGeneric Edit50 Allow NULL? 
124SZMTF2Freeze Time Fence DaysNumericGeneric Edit50 Allow NULL? 
125SZMTF3Message Time Fence DaysNumericGeneric Edit50 Allow NULL? 
126SZMTF4MPS/MRP Time Fence 4NumericGeneric Edit50 Allow NULL? 
127SZMTF5Shipment Leadtime OffsetNumericGeneric Edit50 Allow NULL? 
128SZEXPDExpedite Damper DaysNumericGeneric Edit50 Allow NULL? 
129SZDEFDDefer Damper DaysNumericGeneric Edit50 Allow NULL? 
130SZSFLTSafety LeadtimeNumericGeneric Edit50 Allow NULL? 
131SZMAKEMake/Buy CodeCharacterUDC (H40 MA)10 Allow NULL? 
132SZCOBYCo-Products/By-Products/IntermediateCharacterUDC (H40 CO)10 Allow NULL? 
133SZLLXLow Level CodeNumericGeneric Edit30 Allow NULL? 
134SZCMGLCommitment MethodCharacterUDC (H40 CM)10 Allow NULL? 
135SZCOMHCommitment - Specific (Days)NumericGeneric Edit30 Allow NULL? 
136SZAVRTReplenishment Hours - StandardNumericGeneric Edit152 Allow NULL? 
137SZUPCNUPC NumberStringGeneric Edit130 Allow NULL? 
138SZSCC0Aggregate SCC Code (PI=0)StringGeneric Edit140 Allow NULL? 
139SZUMDFUnit of Measure - Aggregate UPCStringUDC (00 UM)20 Allow NULL? 
140SZUMS0Unit of Measure - SCC(PI=0)StringUDC (00 UM)20 Allow NULL? 
141SZUMUPUnit of Measure - UPCStringUDC (00 UM)20 Allow NULL? 
142SZUMS1Unit of Measure - SCC(PI=1)StringUDC (00 UM)20 Allow NULL? 
143SZUMS2Unit of Measure - SCC(PI=2)StringUDC (00 UM)20 Allow NULL? 
144SZUMS3Unit of Measure - SCC(PI=3)StringUDC (00 UM)20 Allow NULL? 
145SZUMS4Unit of Measure - SCC(PI=4)StringUDC (00 UM)20 Allow NULL? 
146SZUMS5Unit of Measure - SCC(PI=5)StringUDC (00 UM)20 Allow NULL? 
147SZUMS6Unit of Measure - SCC(PI=6)StringUDC (00 UM)20 Allow NULL? 
148SZUMS7Unit of Measure - SCC(PI=7)StringUDC (00 UM)20 Allow NULL? 
149SZUMS8Unit of Measure - SCC(PI=8)StringUDC (00 UM)20 Allow NULL? 
150SZWTRQItem Weight Required Y/NCharacterGeneric Edit10 Allow NULL? 
151SZEQTYContainer CodeStringUDC (46 EQ)50 Allow NULL? 
152SZPOCIssue and ReceiptCharacterUDC (43 IR)10 Allow NULL? 
153SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
154SZMMCUBranchStringGeneric Edit120 Allow NULL? 
155SZVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
156SZORIGCountry of OriginStringUDC (00 CN)30 Allow NULL? 
157SZROPIReorder Point - InputNumericGeneric Edit152 Allow NULL? 
158SZROQIReorder Quantity - InputNumericGeneric Edit152 Allow NULL? 
159SZRQMXReorder Quantity - MaximumNumericGeneric Edit152 Allow NULL? 
160SZRQMNReorder Quantity - MinimumNumericGeneric Edit152 Allow NULL? 
161SZWOMOQuantity - Order Multiples (SO/PO)NumericGeneric Edit70 Allow NULL? 
162SZSERVService LevelNumericGeneric Edit70 Allow NULL? 
163SZSAFESafety StockNumericGeneric Edit152 Allow NULL? 
164SZFUF1AIA Document FlagCharacterUDC (H40 FU)10 Allow NULL? 
165SZTXPurchasing Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
166SZTAX1Sales Taxable (Y/N)CharacterUDC (H00 TV)10 Allow NULL? 
167SZMRPDItem Display CodeCharacterUDC (H41 MR)10 Allow NULL? 
168SZMRPCFlag - Net ChangeCharacterUDC (H41 MQ)10 Allow NULL? 
169SZUPCUnits - Per ContainerNumericGeneric Edit150 Allow NULL? 
170SZMERLItem Revision LevelStringGeneric Edit30 Allow NULL? 
171SZECOECO NumberStringGeneric Edit120 Allow NULL? 
172SZECTYEngineering Change ReasonStringUDC (40 CR)20 Allow NULL? 
173SZECODDate - Engineering Change DateDateGeneric Edit60
174SZMOVDMove Hours - StandardNumericGeneric Edit52 Allow NULL? 
175SZQUEDQueue Hours - StandardNumericGeneric Edit52 Allow NULL? 
176SZSETLSetup Labor - StandardNumericGeneric Edit152 Allow NULL? 
177SZSRNKShrink FactorNumericGeneric Edit152 Allow NULL? 
178SZSRKFShrink Factor MethodCharacterUDC (H40 SR)10 Allow NULL? 
179SZTIMBTime Basis CodeCharacterUDC (30 TB)10 Allow NULL? 
180SZBQTYUnits - Batch QuantityNumericGeneric Edit152 Allow NULL? 
181SZMULTQuantity - Order Multiples (MRP)NumericGeneric Edit152 Allow NULL? 
182SZLFDJDate - Future UseDateGeneric Edit60
183SZMLOTMix Dates / Lots (Y/N)CharacterGeneric Edit10 Allow NULL? 
184SZLOCNLocationStringGeneric Edit200 Allow NULL? 
185SZLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
186SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
187SZURDTUser Reserved DateDateGeneric Edit60
188SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
189SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
190SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
191SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
192SZSTAWStatusCharacterUDC (00 WS)10 Allow NULL? 
193SZEFFTEffective - Thru DateDateGeneric Edit60
194SZDOCDocument (Voucher Invoice etc.)NumericGeneric Edit80 Allow NULL? 
195SZDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
196SZUSERUser IDStringGeneric Edit100 Allow NULL? 
197SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
198SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
199SZUPMJDate - UpdatedDateGeneric Edit60
200SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
201SZTMPLTemplateStringGeneric Edit200 Allow NULL? 
202SZSEG1Segment 1StringGeneric Edit100 Allow NULL? 
203SZSEG2Segment 2StringGeneric Edit100 Allow NULL? 
204SZSEG3Segment 3StringGeneric Edit100 Allow NULL? 
205SZSEG4Segment 4StringGeneric Edit100 Allow NULL? 
206SZSEG5Segment 5StringGeneric Edit100 Allow NULL? 
207SZSEG6Segment 6StringGeneric Edit100 Allow NULL? 
208SZSEG7Segment 7StringGeneric Edit100 Allow NULL? 
209SZSEG8Segment 8StringGeneric Edit100 Allow NULL? 
210SZSEG9Segment 9StringGeneric Edit100 Allow NULL? 
211SZSEG0Segment 10StringGeneric Edit100 Allow NULL? 
212SZAINGActive Ingredient FlagCharacterGeneric Edit10 Allow NULL? 
213SZCMDMCommitment Date MethodCharacterUDC (H40 CD)10 Allow NULL? 
214SZDPPODual Picking Process OptionCharacterGeneric Edit10 Allow NULL? 
215SZDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
216SZLECMLot Expiraton Date Calculation MethodCharacterUDC (H41 EC)10 Allow NULL? 
217SZMICMatrix ControlledCharacterUDC (41 MA)10 Allow NULL? 
218SZXDCKCross-Docking FlagCharacterGeneric Edit10 Allow NULL? 
219SZDLTLDual ToleranceNumericGeneric Edit72 Allow NULL? 
220SZLEDDLot Effective Default DaysNumericGeneric Edit60 Allow NULL? 
221SZPEFDPurchasing Effective DaysNumericGeneric Edit60 Allow NULL? 
222SZSBDDSell By Default DaysNumericGeneric Edit60 Allow NULL? 
223SZU1DDUser Lot Date 1 Default DaysNumericGeneric Edit60 Allow NULL? 
224SZU2DDUser Lot Date 2 Default DaysNumericGeneric Edit60 Allow NULL? 
225SZU3DDUser Lot Date 3 Default DaysNumericGeneric Edit60 Allow NULL? 
226SZU4DDUser Lot Date 4 Default DaysNumericGeneric Edit60 Allow NULL? 
227SZU5DDUser Lot Date 5 Default DaysNumericGeneric Edit60 Allow NULL? 
228SZBBDDBest Before Default DaysNumericGeneric Edit60 Allow NULL? 
229SZLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
230SZEXPIExplode Item (1/0)CharacterGeneric Edit10 Allow NULL? 
231SZCONBConsumableCharacterGeneric Edit10 Allow NULL? 
232SZPRI1Priority One Alert LevelNumericGeneric Edit154 Allow NULL? 
233SZPRI2Priority Two Alert LevelNumericGeneric Edit154 Allow NULL? 
234SZGCMPCompositionCharacterGeneric Edit10 Allow NULL? 
235SZAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
236SZCMETHMethod - Configurator CostingCharacterUDC (41 CM)10 Allow NULL? 
237SZLAFLot Audit FlagCharacterGeneric Edit10 Allow NULL? 
238SZLTFMSpecial Lot FormatCharacterGeneric Edit10 Allow NULL? 
239SZRWLARestrict Work Order Lot AssignmentCharacterGeneric Edit10 Allow NULL? 
240SZLNPALot Number Pre-AssignmentCharacterGeneric Edit10 Allow NULL? 
241SZASHLAllow Shipping of Held LotsCharacterGeneric Edit10 Allow NULL? 
242SZVMINVVendor Managed InventoryCharacterGeneric Edit10 Allow NULL? 
243SZLTCVLeadtime Conversion FactorNumericGeneric Edit157 Allow NULL? 
244SZOPTHMinimum Operational ThresholdNumericGeneric Edit154 Allow NULL? 
245SZCUTHMinimum Cumulative ThresholdNumericGeneric Edit154 Allow NULL? 
246SZUMTHOperational Threshold Unit of MeasureStringUDC (31B UM)30 Allow NULL? 
247SZLMFGLean Manufacturing FlagCharacterGeneric Edit10 Allow NULL? 
248SZLINELine/Cell IdentifierStringGeneric Edit120 Allow NULL? 
249SZDFTPCTTotal Product Cycle TimeNumericGeneric Edit205 Allow NULL? 
250SZKBITKanban ItemCharacterGeneric Edit10 Allow NULL? 
251SZDFENDITMDemand Flow End Item FlagCharacterGeneric Edit10 Allow NULL? 
252SZKANEXLLKanban Explode to Lower LevelCharacterGeneric Edit10 Allow NULL? 
253SZSCPSELLSellable ItemCharacterUDC (34A SA)10 Allow NULL? 
254SZMOPTHMaximum Operational ThresholdNumericGeneric Edit154 Allow NULL? 
255SZMCUTHMaximum Cumulative ThresholdNumericGeneric Edit154 Allow NULL? 
256SZCUMTHCumulative Threshold Unit of MeasureStringUDC (31B UM)30 Allow NULL? 
257SZATPRNATP Rule NameStringGeneric Edit800 Allow NULL? 
258SZATPCACheck ATPCharacterUDC (34A CA)10 Allow NULL? 
259SZATPACATP ComponentsStringUDC (34A AP)50 Allow NULL? 
260SZCOORECountry of Origin Required FlagCharacterGeneric Edit10 Allow NULL? 
261SZVCPFCATO Forecast ControlStringUDC (34A CF)200 Allow NULL? 
262SZPNYNProduction Number ControlledCharacterGeneric Edit10 Allow NULL? 

TOP910 | 41 | F4101Z1 INDEXES

NumberDescription
2User Batch Trans No Line No (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending