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
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

90 COLUMNS | 6 INDEXES | Print definition?920 | 30 | F3003Z1 TABLE

30: Product Data Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F3003Z1SZ906Routing Transactions FileTransaction Files30: Product Data 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, SZTRT, SZKIT, SZKITL, SZKITA, SZMMCU, SZALD, SZDSC1, SZLINE, SZMCU, SZOPSQ, SZEFFF, SZEFFT, SZBFPF, SZLAMC, SZTIMB, SZOPSR, SZBQTY, SZUOM, SZRUNM, SZRUNL, SZSETL, SZPWRT, SZSETC, SZMOVD, SZQUED, SZLTPC, SZPOVR, SZNXOP, SZCPYP, SZOPYP, SZAPID, SZSHNO, SZOPSC, SZINPE, SZJBCD, SZAN8, SZVEND, SZPOY, SZCOST, SZOMCU, SZOBJ, SZSUB, SZRREV, SZLOCN, SZRUC, SZCAPU, SZURCD, SZURDT, SZURAT, SZURRF, SZURAB, SZTORG, SZUSER, SZPID, SZUPMJ, SZTDAY, SZJOBN, SZNUMB, SZWMCU, SZACTB, SZCBCO, SZCICO, SZIMCO, SZMPRO, SZAPSC, SZMNSP, SZMXSP, SZCMPE, SZCMPC, SZCPLVLFR, SZCPLVLTO, SZCMRQ, SZANSA, SZANPA, SZANP, SZWSCHF, SZTRAF FROM F3003Z1

TOP920 | 30 | F3003Z1 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? 
14SZTRTType of RoutingStringUDC (40 TR)30 Allow NULL? 
15SZKITParent (short) Item NumberNumericGeneric Edit80 Allow NULL? 
16SZKITLKit - 2nd Item NumberStringGeneric Edit250 Allow NULL? 
17SZKITA3rd Item Number - KitStringGeneric Edit250 Allow NULL? 
18SZMMCUBranchStringGeneric Edit120 Allow NULL? 
19SZALDAuto Load DescriptionStringUDC (30 AL)40 Allow NULL? 
20SZDSC1DescriptionStringGeneric Edit300 Allow NULL? 
21SZLINELine/Cell IdentifierStringGeneric Edit120 Allow NULL? 
22SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
23SZOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
24SZEFFFEffective - From DateDateGeneric Edit60
25SZEFFTEffective - Thru DateDateGeneric Edit60
26SZBFPFPay Point CodeCharacterUDC (30 BF)10 Allow NULL? 
27SZLAMCLabor or MachineCharacterUDC (H40 LA)10 Allow NULL? 
28SZTIMBTime Basis CodeCharacterUDC (30 TB)10 Allow NULL? 
29SZOPSRFactor - Operation Shrinkage FactorNumericGeneric Edit154 Allow NULL? 
30SZBQTYUnits - Batch QuantityNumericGeneric Edit150 Allow NULL? 
31SZUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
32SZRUNMRun Machine - StandardNumericGeneric Edit152 Allow NULL? 
33SZRUNLRun Labor - StandardNumericGeneric Edit152 Allow NULL? 
34SZSETLSetup Labor - StandardNumericGeneric Edit152 Allow NULL? 
35SZPWRTRate - PieceworkNumericGeneric Edit153 Allow NULL? 
36SZSETCCrew SizeNumericGeneric Edit51 Allow NULL? 
37SZMOVDMove Hours - StandardNumericGeneric Edit52 Allow NULL? 
38SZQUEDQueue Hours - StandardNumericGeneric Edit52 Allow NULL? 
39SZLTPCPercent - Leadtime OverlapNumericGeneric Edit52 Allow NULL? 
40SZPOVRPercent - OverlapNumericGeneric Edit52 Allow NULL? 
41SZNXOPSequence Number - Next OperationNumericGeneric Edit52 Allow NULL? 
42SZCPYPPercent - Cumulative Planned YieldNumericGeneric Edit52 Allow NULL? 
43SZOPYPPercent - Operational Planned YieldNumericGeneric Edit52 Allow NULL? 
44SZAPIDUnit or Tag NumberStringUDC120 Allow NULL? 
45SZSHNOMessage NumberStringGeneric Edit100 Allow NULL? 
46SZOPSCType Operation CodeStringUDC (30 OT)20 Allow NULL? 
47SZINPEInspection CodeStringGeneric Edit20 Allow NULL? 
48SZJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
49SZAN8Address NumberNumericGeneric Edit80 Allow NULL? 
50SZVENDPrimary / Last Supplier NumberNumericGeneric Edit80 Allow NULL? 
51SZPOYPurchase Order (Y/N)CharacterUDC (00 MN)10 Allow NULL? 
52SZCOSTCost ComponentStringUDC (30 CA)30 Allow NULL? 
53SZOMCUProject Business UnitStringGeneric Edit120 Allow NULL? 
54SZOBJObject AccountStringGeneric Edit60 Allow NULL? 
55SZSUBSubsidiaryStringGeneric Edit80 Allow NULL? 
56SZRREVRouting Revision LevelStringGeneric Edit30 Allow NULL? 
57SZLOCNLocationStringGeneric Edit200 Allow NULL? 
58SZRUCResource units consumedNumericGeneric Edit152 Allow NULL? 
59SZCAPUCapacity Unit of measureStringUDC (00 UM)20 Allow NULL? 
60SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
61SZURDTUser Reserved DateDateGeneric Edit60
62SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
63SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
64SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
65SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
66SZUSERUser IDStringGeneric Edit100 Allow NULL? 
67SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
68SZUPMJDate - UpdatedDateGeneric Edit60
69SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
70SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
71SZNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
72SZWMCUWorkcenter BranchStringGeneric Edit120 Allow NULL? 
73SZACTBActivity-Based Costing Activity CodeStringGeneric Edit100 Allow NULL? 
74SZCBCOCo/By CounterIntegerGeneric Edit110 Allow NULL? 
75SZCICOComponent/Ingredient CounterIntegerGeneric Edit110 Allow NULL? 
76SZIMCOIntermediate CounterIntegerGeneric Edit110 Allow NULL? 
77SZMPROMinimum ProductionNumericGeneric Edit154 Allow NULL? 
78SZAPSCConstraints FlagCharacterUDC (42 AC)10 Allow NULL? 
79SZMNSPMinimum SeparationNumericGeneric Edit154 Allow NULL? 
80SZMXSPMaximum SeparationNumericGeneric Edit154 Allow NULL? 
81SZCMPECompetency TypeStringUDC (05 CY)30 Allow NULL? 
82SZCMPCCompetency CodeStringGeneric Edit100 Allow NULL? 
83SZCPLVLFRCompetency Level FromNumericGeneric Edit63 Allow NULL? 
84SZCPLVLTOCompetency Level ToNumericGeneric Edit63 Allow NULL? 
85SZCMRQRule Match FlagCharacterGeneric Edit10 Allow NULL? 
86SZANSAAddress Number - ManagerNumericGeneric Edit80 Allow NULL? 
87SZANPASupervisorNumericGeneric Edit80 Allow NULL? 
88SZANPAddress Number - Assigned ToNumericGeneric Edit80 Allow NULL? 
89SZWSCHFMaintenance Schedule FlagCharacterUDC (13 WS)10 Allow NULL? 
90SZTRAFResources AssignedCharacterUDC (00 ZO)10 Allow NULL? 

TOP920 | 30 | F3003Z1 INDEXES

NumberDescription
1User ID Batch Number A (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
2User ID Batch Number B
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDSPEDI - Successfully ProcessedAscending
3User ID Batch Number C
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDSPEDI - Successfully ProcessedAscending
4Batch Number Trans Number +
ElementAliasDescriptionSequence
1EDBTEDI - Batch NumberAscending
2EDTNEDI - Transaction NumberAscending
3MMCUBranchAscending
4KITParent (short) Item NumberAscending
5TRTType of RoutingAscending
6BQTYUnits - Batch QuantityAscending
6User ID Batch Number D
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
8User ID Batch Number E
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberDescending