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

222 COLUMNS | 2 INDEXES | Print definition?910 | 48 | F4801Z1 TABLE

48: Work Order Processing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F4801Z1SY2222Outbound Work Order HeaderTransaction Files31: Shop Floor ControlBusiness 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 SYEDUS, SYEDBT, SYEDTN, SYEDLN, SYEDCT, SYTYTN, SYEDFT, SYEDDT, SYDRIN, SYEDDL, SYEDSP, SYPNID, SYTNAC, SYDCTO, SYRCD, SYDGL, SYLOTS, SYEXPR, SYLOT1, SYLOT2, SYDOCO, SYSFXO, SYRCTO, SYRORN, SYLNID, SYPTWO, SYPARS, SYTYPS, SYPRTS, SYDL01, SYSTCM, SYCO, SYMCU, SYMMCU, SYLOCN, SYAISL, SYBIN, SYSRST, SYDCG, SYSUB, SYAN8, SYANO, SYANSA, SYANPA, SYANP, SYDPL, SYANT, SYNAN8, SYTRDJ, SYSTRT, SYDRQJ, SYSTRX, SYDAP, SYDAT, SYPPDT, SYWR01, SYWR02, SYWR03, SYWR04, SYWR05, SYWR06, SYWR07, SYWR08, SYWR09, SYWR10, SYVR01, SYVR02, SYAMTO, SYSETC, SYBRT, SYPAYT, SYAMTC, SYHRSO, SYHRSC, SYAMTA, SYHRSA, SYITM, SYAITM, SYLITM, SYNUMB, SYAPID, SYUORG, SYSOBK, SYSOCN, SYSOQS, SYQTYT, SYUOM, SYSHNO, SYPBTM, SYTBM, SYTRT, SYSHTY, SYPEC, SYPPFG, SYBM, SYRTG, SYSPRT, SYUNCD, SYINDC, SYRESC, SYMOH, SYTDT, SYPOU, SYPC, SYLTLV, SYLTCM, SYCTS1, SYLOTN, SYLOTP, SYLOTG, SYRAT1, SYRAT2, SYDCT, SYSBLI, SYRKCO, SYBREV, SYRREV, SYDRWC, SYRTCH, SYPNRQ, SYREAS, SYPHSE, SYXDSP, SYBOMC, SYAAID, SYNTST, SYXRTO, SYESDN, SYACDN, SYSAID, SYMPOS, SYAPRT, SYAMLC, SYAMMC, SYAMOT, SYLBAM, SYMTAM, SYURCD, SYURDT, SYURAT, SYURAB, SYURRF, SYTORG, SYUSER, SYPID, SYJOBN, SYUPMJ, SYTDAY, SYLINE, SYMWDH, SYSHFT, SYSCSP, SYSRCN, SYLEDG, SYCTS4, SYCTS8, SYCTS7, SYAID, SYALSE, SYASID, SYATST, SYBSEQ, SYCHPR, SYCRCD, SYCRCE, SYCRCF, SYD5J, SYD6J, SYDRAW, SYDUAL, SYMPCE, SYMPRC, SYOBJ, SYOTAM, SYPRJM, SYPRRP, SYSHPP, SYSQOR, SYSRKF, SYSRNK, SYSSOQ, SYTRAF, SYUOM2, SYWR11, SYWR12, SYWR13, SYWR14, SYWR15, SYWR16, SYWR17, SYWR18, SYWR19, SYWR20, SYVFWO, SYPMTN, SYSEST, SYSEET, SYDSAVNAME, SYTIMEZONES, SYSEQN, SYPLMR, SYPLLB, SYPLOS, SYBGTC, SYTOEM, SYTOPL, SYPLSA, SYPLSU, SYESSA, SYESSU, SYACSA, SYACSU, SYOACM, SYRACM, SYLOTC, SYHPLF, SYXEVT, SYMCULT, SYWSCHF, SYDFMDP, SYPMPN, SYPNS FROM F4801Z1

TOP910 | 48 | F4801Z1 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SYEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2SYEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3SYEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4SYEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5SYEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6SYTYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7SYEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8SYEDDTEDI - Transmission DateDateGeneric Edit60
9SYDRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10SYEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11SYEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12SYPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13SYTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14SYDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
15SYRCDReason CodeStringUDC (42 RC)30 Allow NULL? 
16SYDGLDate - For G/L (and Voucher)DateGeneric Edit60
17SYLOTSLot Status CodeCharacterUDC (41 L)10 Allow NULL? 
18SYEXPRDate - ExpiredDateGeneric Edit60
19SYLOT1Memo Lot 1StringGeneric Edit300 Allow NULL? 
20SYLOT2Memo Lot 2StringGeneric Edit300 Allow NULL? 
21SYDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
22SYSFXOOrder SuffixStringGeneric Edit30 Allow NULL? 
23SYRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
24SYRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
25SYLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
26SYPTWOPeg to Work OrderNumericGeneric Edit80 Allow NULL? 
27SYPARSNumber - Parent WO NumberStringGeneric Edit80 Allow NULL? 
28SYTYPSType - W.O.CharacterUDC (00 TY)10 Allow NULL? 
29SYPRTSPriority - W.O.CharacterUDC (00 PR)10 Allow NULL? 
30SYDL01DescriptionStringGeneric Edit300 Allow NULL? 
31SYSTCMStatus - CommentStringGeneric Edit300 Allow NULL? 
32SYCOCompanyStringGeneric Edit50 Allow NULL? 
33SYMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
34SYMMCUBranchStringGeneric Edit120 Allow NULL? 
35SYLOCNLocationStringGeneric Edit200 Allow NULL? 
36SYAISLAisleStringGeneric Edit80 Allow NULL? 
37SYBINBinStringGeneric Edit80 Allow NULL? 
38SYSRSTStatus Code W.O.StringUDC (00 SS)20 Allow NULL? 
39SYDCGDate - Status ChangedDateGeneric Edit60
40SYSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
41SYAN8Address NumberNumericUDC80 Allow NULL? 
42SYANOAddress Number - OriginatorNumericGeneric Edit80 Allow NULL? 
43SYANSAAddress Number - ManagerNumericGeneric Edit80 Allow NULL? 
44SYANPASupervisorNumericGeneric Edit80 Allow NULL? 
45SYANPAddress Number - Assigned ToNumericGeneric Edit80 Allow NULL? 
46SYDPLDate - W.O. Planned CompletedDateGeneric Edit60
47SYANTAddress Number - InspectorNumericGeneric Edit80 Allow NULL? 
48SYNAN8Next Address NumberNumericGeneric Edit80 Allow NULL? 
49SYTRDJDate - Order/TransactionDateGeneric Edit60
50SYSTRTDate - Start (Julian)DateGeneric Edit60
51SYDRQJDate - RequestedDateGeneric Edit60
52SYSTRXDate - Completion (Julian)DateGeneric Edit60
53SYDAPDate - Assigned toDateGeneric Edit60
54SYDATDate - Assigned to InspectorDateGeneric Edit60
55SYPPDTDate - Paper Printed DateDateGeneric Edit60
56SYWR01Categories - Work Order 01StringUDC (00 W1)40 Allow NULL? 
57SYWR02Categories - Work Order 02StringUDC (00 W2)30 Allow NULL? 
58SYWR03Categories - Work Order 03StringUDC (00 W3)30 Allow NULL? 
59SYWR04Categories - Work Order 04StringUDC (00 W4)30 Allow NULL? 
60SYWR05Categories - Work Order 05StringUDC (00 W5)30 Allow NULL? 
61SYWR06EnterpriseOne Consulting - StatusStringUDC (00 W6)30 Allow NULL? 
62SYWR07EnterpriseOne Consulting - Service TypeStringUDC (00 W7)30 Allow NULL? 
63SYWR08EnterpriseOne Consulting - Skill TypeStringUDC (00 W8)30 Allow NULL? 
64SYWR09E1 Consulting - Experience LevelStringUDC (00 W9)30 Allow NULL? 
65SYWR10Categories - Work Order 10StringUDC (00 W0)30 Allow NULL? 
66SYVR01ReferenceStringGeneric Edit250 Allow NULL? 
67SYVR02Reference 2StringGeneric Edit250 Allow NULL? 
68SYAMTOAmount - EstimatedNumericGeneric Edit152 Allow NULL? 
69SYSETCCrew SizeNumericGeneric Edit51 Allow NULL? 
70SYBRTRevenue Rate Markup OverrideNumericGeneric Edit152 Allow NULL? 
71SYPAYTPay/Deduction/Benefit TypeStringGeneric Edit50 Allow NULL? 
72SYAMTCAmount - Change to Original DollarsNumericGeneric Edit152 Allow NULL? 
73SYHRSOHours - EstimatedNumericGeneric Edit152 Allow NULL? 
74SYHRSCHours - Change to Original HoursNumericGeneric Edit152 Allow NULL? 
75SYAMTAAmount - ActualNumericGeneric Edit152 Allow NULL? 
76SYHRSAHours - ActualNumericGeneric Edit152 Allow NULL? 
77SYITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
78SYAITM3rd Item NumberStringGeneric Edit250 Allow NULL? 
79SYLITM2nd Item NumberStringGeneric Edit250 Allow NULL? 
80SYNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
81SYAPIDUnit or Tag NumberStringUDC120 Allow NULL? 
82SYUORGUnits - Order/Transaction QuantityNumericGeneric Edit152 Allow NULL? 
83SYSOBKUnits - Qty Backordered/HeldNumericGeneric Edit152 Allow NULL? 
84SYSOCNUnits - Quantity Canceled/ScrappedNumericGeneric Edit152 Allow NULL? 
85SYSOQSQuantity ShippedNumericGeneric Edit152 Allow NULL? 
86SYQTYTUnits - Shipped to DateNumericGeneric Edit152 Allow NULL? 
87SYUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
88SYSHNOMessage NumberStringGeneric Edit100 Allow NULL? 
89SYPBTMTime - Beginning (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
90SYTBMType Bill of MaterialStringUDC (40 TB)30 Allow NULL? 
91SYTRTType of RoutingStringUDC (40 TR)30 Allow NULL? 
92SYSHTYWO Pick List PrintedCharacterUDC (H00 SH)10 Allow NULL? 
93SYPECPosting EditCharacterUDC (H00 PE)10 Allow NULL? 
94SYPPFGVariance FlagCharacterUDC (H00 PP)10 Allow NULL? 
95SYBMBill of Material (N)CharacterGeneric Edit10 Allow NULL? 
96SYRTGRoute Sheet (N)CharacterGeneric Edit10 Allow NULL? 
97SYSPRTWork Order Flash MessageCharacterUDC (00 WM)10 Allow NULL? 
98SYUNCDWork Order Freeze CodeCharacterUDC (H00 UN)10 Allow NULL? 
99SYINDCIndented CodeCharacterGeneric Edit10 Allow NULL? 
100SYRESCResequence CodeNumericGeneric Edit52 Allow NULL? 
101SYMOHAmount - Miles or Hours (units)NumericGeneric Edit152 Allow NULL? 
102SYTDTDate - Scheduled TicklerDateGeneric Edit60
103SYPOUAmount - Memo Budget ChangesNumericGeneric Edit152 Allow NULL? 
104SYPCPercent CompleteNumericGeneric Edit50 Allow NULL? 
105SYLTLVLeadtime LevelNumericGeneric Edit50 Allow NULL? 
106SYLTCMLeadtime CumulativeNumericGeneric Edit50 Allow NULL? 
107SYCTS1Hours - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
108SYLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
109SYLOTPLot PotencyNumericGeneric Edit153 Allow NULL? 
110SYLOTGLot GradeStringUDC (40 LG)30 Allow NULL? 
111SYRAT1Ratio _ Critical Ratio Priority 1NumericGeneric Edit52 Allow NULL? 
112SYRAT2Ratio - Critical Ratio Priority 2NumericGeneric Edit52 Allow NULL? 
113SYDCTDocument TypeStringUDC (00 DT)20 Allow NULL? 
114SYSBLISubledger Inactive CodeCharacterUDC (00 SI)10 Allow NULL? 
115SYRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
116SYBREVBill Revision LevelStringGeneric Edit30 Allow NULL? 
117SYRREVRouting Revision LevelStringGeneric Edit30 Allow NULL? 
118SYDRWCDrawing ChangeCharacterGeneric Edit10 Allow NULL? 
119SYRTCHRouting ChangeCharacterGeneric Edit10 Allow NULL? 
120SYPNRQNew Part NumberCharacterGeneric Edit10 Allow NULL? 
121SYREASReason for ECOStringUDC (40 CR)20 Allow NULL? 
122SYPHSEPhase InStringUDC (40 PH)30 Allow NULL? 
123SYXDSPExisting DispositionStringUDC (40 ED)30 Allow NULL? 
124SYBOMCBOM ChangeCharacterGeneric Edit10 Allow NULL? 
125SYAAIDParent NumberNumericGeneric Edit80 Allow NULL? 
126SYNTSTNext Status - W.O.StringUDC (00 SS)20 Allow NULL? 
127SYXRTOCriticality - Work OrderNumericGeneric Edit40 Allow NULL? 
128SYESDNEstimated Downtime HoursNumericGeneric Edit52 Allow NULL? 
129SYACDNActual Downtime HoursNumericGeneric Edit52 Allow NULL? 
130SYSAIDService Address NumberNumericGeneric Edit80 Allow NULL? 
131SYMPOSMeter PositionNumericGeneric Edit30 Allow NULL? 
132SYAPRTApproval TypeStringUDC (48 AP)30 Allow NULL? 
133SYAMLCAmount - Estimated LaborNumericGeneric Edit152 Allow NULL? 
134SYAMMCAmount - Estimated MaterialNumericGeneric Edit152 Allow NULL? 
135SYAMOTAmount - Estimated OtherNumericGeneric Edit152 Allow NULL? 
136SYLBAMAmount - Actual LaborNumericGeneric Edit152 Allow NULL? 
137SYMTAMAmount - Actual MaterialNumericGeneric Edit152 Allow NULL? 
138SYURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
139SYURDTUser Reserved DateDateGeneric Edit60
140SYURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
141SYURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
142SYURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
143SYTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
144SYUSERUser IDStringGeneric Edit100 Allow NULL? 
145SYPIDProgram IDStringGeneric Edit100 Allow NULL? 
146SYJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
147SYUPMJDate - UpdatedDateGeneric Edit60
148SYTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
149SYLINELine/Cell IdentifierStringGeneric Edit120 Allow NULL? 
150SYMWDHMonth/Week/Day/ShiftCharacterUDC (31 RP)10 Allow NULL? 
151SYSHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
152SYSCSPSchedule SpreadNumericGeneric Edit20 Allow NULL? 
153SYSRCNSerialized componentsCharacterUDC (31 SC)10 Allow NULL? 
154SYLEDGCost MethodStringUDC (40 CM)20 Allow NULL? 
155SYCTS4Amount - Unaccounted Direct LaborNumericGeneric Edit152 Allow NULL? 
156SYCTS8Units - Unaccounted ScrapNumericGeneric Edit152 Allow NULL? 
157SYCTS7Amount - Unaccounted ScrapNumericGeneric Edit152 Allow NULL? 
158SYAIDAccount IDStringGeneric Edit80 Allow NULL? 
159SYALSEAlert Sensitive TaskCharacterGeneric Edit10 Allow NULL? 
160SYASIDSerial NumberStringGeneric Edit250 Allow NULL? 
161SYATSTDate - Actual Start (Julian)DateGeneric Edit60
162SYBSEQSorszám - Buborék sorszámNumericGeneric Edit50 Allow NULL? 
163SYCHPRCharge Cost to Project AccountCharacterGeneric Edit10 Allow NULL? 
164SYCRCDCurrency Code - FromStringGeneric Edit30 Allow NULL? 
165SYCRCECurrency Code - SourceStringGeneric Edit30 Allow NULL? 
166SYCRCFCurrency Code - OriginStringGeneric Edit30 Allow NULL? 
167SYD5JDate - Other 5DateGeneric Edit60
168SYD6JDate - Other 6DateGeneric Edit60
169SYDRAWDrawing NumberStringGeneric Edit200 Allow NULL? 
170SYDUALDual Unit Of Measure ItemCharacterGeneric Edit10 Allow NULL? 
171SYMPCEProduction Costs ExistCharacterUDC (00 ZO)10 Allow NULL? 
172SYMPRCChanges to Parts And Routings AllowedCharacterUDC (00 ZO)10 Allow NULL? 
173SYOBJObject AccountStringGeneric Edit60 Allow NULL? 
174SYOTAMAmount - Actual OtherNumericGeneric Edit152 Allow NULL? 
175SYPRJMProject NumberNumericGeneric Edit80 Allow NULL? 
176SYPRRPDirect Project RelationshipCharacterGeneric Edit10 Allow NULL? 
177SYSHPPShip This PhaseCharacterUDC (00 ZO)10 Allow NULL? 
178SYSQORUnits - Secondary Quantity OrderedNumericGeneric Edit152 Allow NULL? 
179SYSRKFShrink Factor MethodCharacterUDC (H40 SR)10 Allow NULL? 
180SYSRNKShrink FactorNumericGeneric Edit152 Allow NULL? 
181SYSSOQSecondary Quantity CompletedNumericGeneric Edit150 Allow NULL? 
182SYTRAFResources AssignedCharacterUDC (00 ZO)10 Allow NULL? 
183SYUOM2Unit of Measure - SecondaryStringUDC (00 UM)20 Allow NULL? 
184SYWR11Categories - Work Order 11StringUDC (00 X1)30 Allow NULL? 
185SYWR12Categories - Work Order 12StringUDC (00 X2)30 Allow NULL? 
186SYWR13Categories - Work Order 13StringUDC (00 X3)30 Allow NULL? 
187SYWR14Categories - Work Order 14StringUDC (00 X4)30 Allow NULL? 
188SYWR15Categories - Work Order 15StringUDC (00 X5)30 Allow NULL? 
189SYWR16Categories - Work Order 16StringUDC (00 X6)30 Allow NULL? 
190SYWR17Categories - Work Order 17StringUDC (00 X7)30 Allow NULL? 
191SYWR18Categories - Work Order 18StringUDC (00 X8)30 Allow NULL? 
192SYWR19Categories - Work Order 19StringUDC (00 X9)30 Allow NULL? 
193SYWR20Categories - Work Order 20StringUDC (00 X0)30 Allow NULL? 
194SYVFWOFirm Work OrderCharacterGeneric Edit10 Allow NULL? 
195SYPMTNPromotion IDStringGeneric Edit120 Allow NULL? 
196SYSESTTime - Scheduled Start (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
197SYSEETTime - Scheduled End (HH/MM/SS)NumericGeneric Edit60 Allow NULL? 
198SYDSAVNAMEDaylight Savings Rule NameStringUDC100 Allow NULL? 
199SYTIMEZONESTime Zone ListStringUDC (H91 TZ)20 Allow NULL? 
200SYSEQNSequence NumberNumericGeneric Edit70 Allow NULL? 
201SYPLMRPlanned MaterialNumericGeneric Edit152 Allow NULL? 
202SYPLLBPlanned LaborNumericGeneric Edit152 Allow NULL? 
203SYPLOSPlanned OtherNumericGeneric Edit152 Allow NULL? 
204SYBGTCBudgeted CostNumericGeneric Edit152 Allow NULL? 
205SYTOEMTotal EstimatedNumericGeneric Edit152 Allow NULL? 
206SYTOPLTotal PlannedNumericGeneric Edit152 Allow NULL? 
207SYPLSAPlanned Special AmountNumericGeneric Edit152 Allow NULL? 
208SYPLSUPlanned Special UnitsNumericGeneric Edit152 Allow NULL? 
209SYESSAEstimated Special AmountNumericGeneric Edit152 Allow NULL? 
210SYESSUEstimated Special UnitsNumericGeneric Edit152 Allow NULL? 
211SYACSAActual Special AmountNumericGeneric Edit152 Allow NULL? 
212SYACSUActual Special UnitsNumericGeneric Edit152 Allow NULL? 
213SYOACMAmount Committed - OriginalNumericGeneric Edit152 Allow NULL? 
214SYRACMAmount Committed - RemainingNumericGeneric Edit152 Allow NULL? 
215SYLOTCLot Status Code ExpandedStringGeneric Edit30 Allow NULL? 
216SYHPLFHeld Parts List FlagCharacterGeneric Edit10 Allow NULL? 
217SYXEVTExternal Event FlagCharacterGeneric Edit10 Allow NULL? 
218SYMCULTLead CraftStringGeneric Edit120 Allow NULL? 
219SYWSCHFMaintenance Schedule FlagCharacterUDC (13 WS)10 Allow NULL? 
220SYDFMDPDFM Daily PlanCharacterGeneric Edit10 Allow NULL? 
221SYPMPNProduction NumberStringGeneric Edit300 Allow NULL? 
222SYPNSProduction Number ShortNumericGeneric Edit100 Allow NULL? 

TOP910 | 48 | F4801Z1 INDEXES

NumberDescription
1UserID Batch Transaction +A (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
2OrderNo Line Transaction +B
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2EDLNEDI - Line NumberAscending
3TYTNType - TransactionAscending
4TNACTransaction ActionAscending
5DRINDirection IndicatorAscending
6EDDLEDI - Detail Lines ProcessedAscending