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

144 COLUMNS | 2 INDEXES | Print definition?812 | 37 | F3711Z1 TABLE

37: Quality Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F3711Z1SZ1442Test Results Unedited Transaction TableTransaction Files37: Quality ManagementNo
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, SZDOCO, SZDCTO, SZKCOO, SZLNID, SZRCTO, SZRORN, SZRKCO, SZRLLN, SZMCU, SZLOCN, SZLOTN, SZAN8, SZCS18, SZITM, SZIT18, SZQTST, SZMCU2, SZQSPC, SZHMCU, SZTSRT, SZQREV, SZQVAL, SZQPF, SZTOVR, SZMUSE, SZANO, SZQDAT, SZQTIM, SZQDSP, SZSNBR, SZQSMP, SZSMPC, SZACQT, SZACPC, SZSY, SZRT, SZAMIN, SZAMAX, SZPMIN, SZPMAX, SZEFFF, SZEFFT, SZQTRG, SZQSSZ, SZQASZ, SZQUM, SZPTTS, SZQTC1, SZQTC2, SZQTC3, SZQTC4, SZQTC5, SZTTTY, SZMFGR, SZMRRR, SZMFGC, SZPRCR, SZPRER, SZSHPR, SZBLKR, SZOPSQ, SZOPRS, SZBSEQ, SZTRT, SZTRP, SZTRPL, SZLCMP, SZVEHI, SZRSQQ, SZTTST, SZDFCW, SZQPCD, SZQTID, SZTMHD, SZRSUM, SZNUMB, SZASTM, SZQPRP, SZQDFC, SZQRTC, SZMMCU, SZCDEC, SZUKID, SZDERC, SZURCD, SZURDT, SZURAT, SZURRF, SZURAB, SZTORG, SZUSER, SZPID, SZUPMJ, SZTDAY, SZJOBN, SZQMRF3, SZQMCD3, SZQMAB3, SZQMNUM3, SZQMDT3, SZTSTRTY, SZMELC, SZPRVRSNM, SZPRVQVAL, SZPRVQDAT, SZPRVRSUM, SZDLAB, SZNUMT, SZNUMT3, SZRNAMAX, SZRNAMIN, SZRNPMAX, SZRNPMIN, SZRNQTRG, SZSY1, SZRT1, SZWVNUM, SZBLUID, SZSBLUID, SZWLOTN, SZWOPID, SZRSEXPD, SZWVID, SZWVTY, SZTSTRSNM, SZRSSTS, SZRSCONVID, SZFRMRSVAL, SZFRMRSUM, SZQABLRUL, SZCDEC2 FROM F3711Z1

TOP812 | 37 | F3711Z1 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? 
14SZDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
15SZDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
16SZKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
17SZLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
18SZRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
19SZRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
20SZRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
21SZRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
22SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
23SZLOCNLocationStringGeneric Edit200 Allow NULL? 
24SZLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
25SZAN8Address NumberNumericUDC80 Allow NULL? 
26SZCS18Customer Group - Quality ManagementStringUDC (40 18)80 Allow NULL? 
27SZITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
28SZIT18Item Group - Quality ManagementStringUDC (40 68)80 Allow NULL? 
29SZQTSTTest IDStringGeneric Edit250 Allow NULL? 
30SZMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
31SZQSPCSpecificationStringGeneric Edit250 Allow NULL? 
32SZHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
33SZTSRTTest Sort Sequence NumberNumericGeneric Edit50 Allow NULL? 
34SZQREVSpecification Revision LevelStringGeneric Edit30 Allow NULL? 
35SZQVALTest ValueStringGeneric Edit150 Allow NULL? 
36SZQPFPass/Fail (P/F)CharacterGeneric Edit10 Allow NULL? 
37SZTOVRTest override flagCharacterGeneric Edit10 Allow NULL? 
38SZMUSEUser IDStringGeneric Edit100 Allow NULL? 
39SZANOAddress Number - OriginatorNumericGeneric Edit80 Allow NULL? 
40SZQDATDate testedDateGeneric Edit60
41SZQTIMTime testedNumericGeneric Edit60 Allow NULL? 
42SZQDSPDisposition CodeStringUDC (37 DS)30 Allow NULL? 
43SZSNBRSample NumberNumericGeneric Edit150 Allow NULL? 
44SZQSMPNumber of SamplesNumericGeneric Edit150 Allow NULL? 
45SZSMPCSample PercentageNumericGeneric Edit52 Allow NULL? 
46SZACQTAccept QuantityNumericGeneric Edit150 Allow NULL? 
47SZACPCAccept PercentageNumericGeneric Edit52 Allow NULL? 
48SZSYProduct CodeStringUDC (98 SY)40 Allow NULL? 
49SZRTUser Defined CodesStringGeneric Edit20 Allow NULL? 
50SZAMINAllowed Minimum ValueStringGeneric Edit150 Allow NULL? 
51SZAMAXAllowed Maximum ValueStringGeneric Edit150 Allow NULL? 
52SZPMINPreferred Minimum Value (future use)StringGeneric Edit150 Allow NULL? 
53SZPMAXPreferred Maximum Value (future use)StringGeneric Edit150 Allow NULL? 
54SZEFFFEffective - From DateDateGeneric Edit60
55SZEFFTEffective - Thru DateDateGeneric Edit60
56SZQTRGTarget ValueStringGeneric Edit150 Allow NULL? 
57SZQSSZSample SizeNumericGeneric Edit150 Allow NULL? 
58SZQASZActual Sample SizeNumericGeneric Edit150 Allow NULL? 
59SZQUMSample Size Unit of MeasureStringUDC (37 UM)30 Allow NULL? 
60SZPTTSPrint TestCharacterUDC (37 PT)10 Allow NULL? 
61SZQTC1Test Category Code 1StringUDC (37 T1)30 Allow NULL? 
62SZQTC2Test Category Code 2StringUDC (37 T2)30 Allow NULL? 
63SZQTC3Test Category Code 3StringUDC (37 T3)30 Allow NULL? 
64SZQTC4Test Category Code 4StringUDC (37 T4)30 Allow NULL? 
65SZQTC5Test Category Code 5StringUDC (37 T5)30 Allow NULL? 
66SZTTTYTest TypeCharacterUDC (37 TY)10 Allow NULL? 
67SZMFGRManufacturing OperationsCharacterGeneric Edit10 Allow NULL? 
68SZMRRRManufacturing Receipt RoutingCharacterGeneric Edit10 Allow NULL? 
69SZMFGCManufacturing CompletionsCharacterGeneric Edit10 Allow NULL? 
70SZPRCRPurchasing ReceiptsCharacterGeneric Edit10 Allow NULL? 
71SZPRERPurchasing Receipt RoutingCharacterGeneric Edit10 Allow NULL? 
72SZSHPRShip ConfirmCharacterGeneric Edit10 Allow NULL? 
73SZBLKRBulk ConfirmCharacterGeneric Edit10 Allow NULL? 
74SZOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
75SZOPRSSequence Number - OperationsNumericGeneric Edit30 Allow NULL? 
76SZBSEQSorszám - Buborék sorszámNumericGeneric Edit50 Allow NULL? 
77SZTRTType of RoutingStringUDC (40 TR)30 Allow NULL? 
78SZTRPTrip NumberNumericGeneric Edit80 Allow NULL? 
79SZTRPLLoad Leg NumberNumericGeneric Edit30 Allow NULL? 
80SZLCMPLogical Compartment NumberNumericGeneric Edit50 Allow NULL? 
81SZVEHIVehicle IDStringGeneric Edit120 Allow NULL? 
82SZRSQQResult Sort Sequence NumberNumericGeneric Edit50 Allow NULL? 
83SZTTSTTiming of Test (Future Use)CharacterGeneric Edit10 Allow NULL? 
84SZDFCWDefect Write CodeCharacterGeneric Edit10 Allow NULL? 
85SZQPCDQuality Application CodeStringUDC (37 AC)20 Allow NULL? 
86SZQTIDQuality Text ID NumberNumericGeneric Edit80 Allow NULL? 
87SZTMHDTest MethodStringGeneric Edit300 Allow NULL? 
88SZRSUMResults Unit of MeasureStringUDC (37 UM)30 Allow NULL? 
89SZNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
90SZASTMASTM ReferenceStringGeneric Edit300 Allow NULL? 
91SZQPRPPropertyStringUDC (37 PR)100 Allow NULL? 
92SZQDFCDefect SourceStringUDC (37 SR)30 Allow NULL? 
93SZQRTCRoot CauseStringUDC (37 RC)30 Allow NULL? 
94SZMMCUBranchStringGeneric Edit120 Allow NULL? 
95SZCDECDisplay DecimalsCharacterGeneric Edit10 Allow NULL? 
96SZUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
97SZDERCDerived CalculationStringGeneric Edit800 Allow NULL? 
98SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
99SZURDTUser Reserved DateDateGeneric Edit60
100SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
101SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
102SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
103SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
104SZUSERUser IDStringGeneric Edit100 Allow NULL? 
105SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
106SZUPMJDate - UpdatedDateGeneric Edit60
107SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
108SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
109SZQMRF3Quality Mgmt Reference 3StringGeneric Edit300 Allow NULL? 
110SZQMCD3Quality Mgmt Code 3StringGeneric Edit30 Allow NULL? 
111SZQMAB3Quality Mgmt Number 3NumericGeneric Edit80 Allow NULL? 
112SZQMNUM3Quality Mgmt Numeric 3NumericGeneric Edit150 Allow NULL? 
113SZQMDT3Quality Mgmt Date 3DateGeneric Edit60
114SZTSTRTYTest Reading TypeStringGeneric Edit30 Allow NULL? 
115SZMELCMeasurement LocationStringUDC (13 LC)100 Allow NULL? 
116SZPRVRSNMPrevious Result Name ValueStringGeneric Edit150 Allow NULL? 
117SZPRVQVALPrevious Test ValueStringGeneric Edit150 Allow NULL? 
118SZPRVQDATPrevious Date TestedDateGeneric Edit60
119SZPRVRSUMPrevious Result UOMStringUDC (37 UM)30 Allow NULL? 
120SZDLABDefault LabNumericGeneric Edit80 Allow NULL? 
121SZNUMTNumeric (1/0)CharacterGeneric Edit10 Allow NULL? 
122SZNUMT3Numeric (1/0)CharacterGeneric Edit10 Allow NULL? 
123SZRNAMAXResult Name Allowed Maximum ValueStringGeneric Edit150 Allow NULL? 
124SZRNAMINResult Name Allowed Minimum ValueStringGeneric Edit150 Allow NULL? 
125SZRNPMAXResult Name Preferred Maximum ValueStringGeneric Edit150 Allow NULL? 
126SZRNPMINResult Name Preferred Minimum ValueStringGeneric Edit150 Allow NULL? 
127SZRNQTRGResult Name Target ValueStringGeneric Edit150 Allow NULL? 
128SZSY1System CodeStringUDC (98 SY)40 Allow NULL? 
129SZRT1User Defined CodesStringGeneric Edit20 Allow NULL? 
130SZWVNUMVessel NumberStringGeneric Edit300 Allow NULL? 
131SZBLUIDBlock IdentifierNumericGeneric Edit80 Allow NULL? 
132SZSBLUIDBlock Descriptor IDNumericGeneric Edit50 Allow NULL? 
133SZWLOTNBlend Lot NumberStringGeneric Edit300 Allow NULL? 
134SZWOPIDOperation IDIntegerGeneric Edit110 Allow NULL? 
135SZRSEXPDResult Expiration DateDateGeneric Edit60
136SZWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
137SZWVTYVessel ClassCharacterGeneric Edit10 Allow NULL? 
138SZTSTRSNMTest Result NameStringGeneric Edit300 Allow NULL? 
139SZRSSTSResult Entry StatusCharacterGeneric Edit10 Allow NULL? 
140SZRSCONVIDResult Conversion IDStringGeneric Edit300 Allow NULL? 
141SZFRMRSVALFrom Result ValueStringGeneric Edit150 Allow NULL? 
142SZFRMRSUMFrom Result UMStringUDC (37 UM)30 Allow NULL? 
143SZQABLRULQuality Assurance Blending RuleStringUDC (31B QB)50 Allow NULL? 
144SZCDEC2Display DecimalsCharacterGeneric Edit10 Allow NULL? 

TOP812 | 37 | F3711Z1 INDEXES

NumberDescription
1UniqueKeyID(Primary Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
2UserID Batch TransactionNo Lin (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending