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

130 COLUMNS | 17 INDEXES | Print definition?812 | 37 | F3711 TABLE

37: Quality Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F3711TR13017Test ResultsMaster 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 TRDOCO, TRDCTO, TRKCOO, TRLNID, TRRCTO, TRRORN, TRRKCO, TRRLLN, TRMCU, TRLOCN, TRLOTN, TRAN8, TRCS18, TRITM, TRIT18, TRQTST, TRMCU2, TRQSPC, TRHMCU, TRTSRT, TRQREV, TRQVAL, TRQPF, TRTOVR, TRMUSE, TRANO, TRQDAT, TRQTIM, TRQDSP, TRSNBR, TRQSMP, TRSMPC, TRACQT, TRACPC, TRSY, TRRT, TRAMIN, TRAMAX, TRPMIN, TRPMAX, TREFFF, TREFFT, TRQTRG, TRQSSZ, TRQASZ, TRQUM, TRPTTS, TRQTC1, TRQTC2, TRQTC3, TRQTC4, TRQTC5, TRTTTY, TRMFGR, TRMRRR, TRMFGC, TRPRCR, TRPRER, TRSHPR, TRBLKR, TROPSQ, TROPRS, TRBSEQ, TRTRT, TRTRP, TRTRPL, TRLCMP, TRVEHI, TRRSQQ, TRTTST, TRDFCW, TRQPCD, TRQTID, TRTMHD, TRRSUM, TRNUMB, TRASTM, TRQPRP, TRQDFC, TRQRTC, TRMMCU, TRCDEC, TRUKID, TRDERC, TRURCD, TRURDT, TRURAT, TRURRF, TRURAB, TRUSER, TRPID, TRUPMJ, TRTDAY, TRJOBN, TRWLOTN, TRWOPID, TRRSEXPD, TRWVID, TRWVTY, TRTSTRSNM, TRRSSTS, TRRSCONVID, TRFRMRSVAL, TRFRMRSUM, TRQMRF3, TRQMCD3, TRQMAB3, TRQMNUM3, TRQMDT3, TRQABLRUL, TRCDEC2, TRPRVQVAL, TRPRVQDAT, TRPRVRSNM, TRNUMT, TRNUMT3, TRPRVRSUM, TRDLAB, TRMELC, TRRNAMAX, TRRNAMIN, TRRNPMAX, TRRNPMIN, TRRNQTRG, TRBLUID, TRSBLUID, TRSY1, TRRT1, TRTSTRTY, TRWVNUM FROM F3711

TOP812 | 37 | F3711 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1TRDOCODocument (Order No Invoice etc.)NumericGeneric Edit80 Allow NULL? 
2TRDCTOOrder TypeStringUDC (00 DT)20 Allow NULL? 
3TRKCOOOrder Company (Order Number)StringGeneric Edit50 Allow NULL? 
4TRLNIDLine NumberNumericGeneric Edit63 Allow NULL? 
5TRRCTORelated PO/SO/WO Order TypeStringUDC (00 DT)20 Allow NULL? 
6TRRORNRelated PO/SO/WO NumberStringGeneric Edit80 Allow NULL? 
7TRRKCOCompany - Key (Related Order)StringGeneric Edit50 Allow NULL? 
8TRRLLNRelated PO/SO Line NumberNumericGeneric Edit73 Allow NULL? 
9TRMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
10TRLOCNLocationStringGeneric Edit200 Allow NULL? 
11TRLOTNLot/Serial NumberStringGeneric Edit300 Allow NULL? 
12TRAN8Address NumberNumericUDC80 Allow NULL? 
13TRCS18Customer Group - Quality ManagementStringUDC (40 18)80 Allow NULL? 
14TRITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
15TRIT18Item Group - Quality ManagementStringUDC (40 68)80 Allow NULL? 
16TRQTSTTest IDStringGeneric Edit250 Allow NULL? 
17TRMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
18TRQSPCSpecificationStringGeneric Edit250 Allow NULL? 
19TRHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
20TRTSRTTest Sort Sequence NumberNumericGeneric Edit50 Allow NULL? 
21TRQREVSpecification Revision LevelStringGeneric Edit30 Allow NULL? 
22TRQVALTest ValueStringGeneric Edit150 Allow NULL? 
23TRQPFPass/Fail (P/F)CharacterGeneric Edit10 Allow NULL? 
24TRTOVRTest override flagCharacterGeneric Edit10 Allow NULL? 
25TRMUSEUser IDStringGeneric Edit100 Allow NULL? 
26TRANOAddress Number - OriginatorNumericGeneric Edit80 Allow NULL? 
27TRQDATDate testedDateGeneric Edit60
28TRQTIMTime testedNumericGeneric Edit60 Allow NULL? 
29TRQDSPDisposition CodeStringUDC (37 DS)30 Allow NULL? 
30TRSNBRSample NumberNumericGeneric Edit150 Allow NULL? 
31TRQSMPNumber of SamplesNumericGeneric Edit150 Allow NULL? 
32TRSMPCSample PercentageNumericGeneric Edit52 Allow NULL? 
33TRACQTAccept QuantityNumericGeneric Edit150 Allow NULL? 
34TRACPCAccept PercentageNumericGeneric Edit52 Allow NULL? 
35TRSYProduct CodeStringUDC (98 SY)40 Allow NULL? 
36TRRTUser Defined CodesStringGeneric Edit20 Allow NULL? 
37TRAMINAllowed Minimum ValueStringGeneric Edit150 Allow NULL? 
38TRAMAXAllowed Maximum ValueStringGeneric Edit150 Allow NULL? 
39TRPMINPreferred Minimum Value (future use)StringGeneric Edit150 Allow NULL? 
40TRPMAXPreferred Maximum Value (future use)StringGeneric Edit150 Allow NULL? 
41TREFFFEffective - From DateDateGeneric Edit60
42TREFFTEffective - Thru DateDateGeneric Edit60
43TRQTRGTarget ValueStringGeneric Edit150 Allow NULL? 
44TRQSSZSample SizeNumericGeneric Edit150 Allow NULL? 
45TRQASZActual Sample SizeNumericGeneric Edit150 Allow NULL? 
46TRQUMSample Size Unit of MeasureStringUDC (37 UM)30 Allow NULL? 
47TRPTTSPrint TestCharacterUDC (37 PT)10 Allow NULL? 
48TRQTC1Test Category Code 1StringUDC (37 T1)30 Allow NULL? 
49TRQTC2Test Category Code 2StringUDC (37 T2)30 Allow NULL? 
50TRQTC3Test Category Code 3StringUDC (37 T3)30 Allow NULL? 
51TRQTC4Test Category Code 4StringUDC (37 T4)30 Allow NULL? 
52TRQTC5Test Category Code 5StringUDC (37 T5)30 Allow NULL? 
53TRTTTYTest TypeCharacterUDC (37 TY)10 Allow NULL? 
54TRMFGRManufacturing OperationsCharacterGeneric Edit10 Allow NULL? 
55TRMRRRManufacturing Receipt RoutingCharacterGeneric Edit10 Allow NULL? 
56TRMFGCManufacturing CompletionsCharacterGeneric Edit10 Allow NULL? 
57TRPRCRPurchasing ReceiptsCharacterGeneric Edit10 Allow NULL? 
58TRPRERPurchasing Receipt RoutingCharacterGeneric Edit10 Allow NULL? 
59TRSHPRShip ConfirmCharacterGeneric Edit10 Allow NULL? 
60TRBLKRBulk ConfirmCharacterGeneric Edit10 Allow NULL? 
61TROPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
62TROPRSSequence Number - OperationsNumericGeneric Edit30 Allow NULL? 
63TRBSEQSorszám - Buborék sorszámNumericGeneric Edit50 Allow NULL? 
64TRTRTType of RoutingStringUDC (40 TR)30 Allow NULL? 
65TRTRPTrip NumberNumericGeneric Edit80 Allow NULL? 
66TRTRPLLoad Leg NumberNumericGeneric Edit30 Allow NULL? 
67TRLCMPLogical Compartment NumberNumericGeneric Edit50 Allow NULL? 
68TRVEHIVehicle IDStringGeneric Edit120 Allow NULL? 
69TRRSQQResult Sort Sequence NumberNumericGeneric Edit50 Allow NULL? 
70TRTTSTTiming of Test (Future Use)CharacterGeneric Edit10 Allow NULL? 
71TRDFCWDefect Write CodeCharacterGeneric Edit10 Allow NULL? 
72TRQPCDQuality Application CodeStringUDC (37 AC)20 Allow NULL? 
73TRQTIDQuality Text ID NumberNumericGeneric Edit80 Allow NULL? 
74TRTMHDTest MethodStringGeneric Edit300 Allow NULL? 
75TRRSUMResults Unit of MeasureStringUDC (37 UM)30 Allow NULL? 
76TRNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
77TRASTMASTM ReferenceStringGeneric Edit300 Allow NULL? 
78TRQPRPPropertyStringUDC (37 PR)100 Allow NULL? 
79TRQDFCDefect SourceStringUDC (37 SR)30 Allow NULL? 
80TRQRTCRoot CauseStringUDC (37 RC)30 Allow NULL? 
81TRMMCUBranchStringGeneric Edit120 Allow NULL? 
82TRCDECDisplay DecimalsCharacterGeneric Edit10 Allow NULL? 
83TRUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
84TRDERCDerived CalculationStringGeneric Edit800 Allow NULL? 
85TRURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
86TRURDTUser Reserved DateDateGeneric Edit60
87TRURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
88TRURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
89TRURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
90TRUSERUser IDStringGeneric Edit100 Allow NULL? 
91TRPIDProgram IDStringGeneric Edit100 Allow NULL? 
92TRUPMJDate - UpdatedDateGeneric Edit60
93TRTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
94TRJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
95TRWLOTNBlend Lot NumberStringGeneric Edit300 Allow NULL? 
96TRWOPIDOperation IDIntegerGeneric Edit110 Allow NULL? 
97TRRSEXPDResult Expiration DateDateGeneric Edit60
98TRWVIDVessel IDNumericGeneric Edit80 Allow NULL? 
99TRWVTYVessel ClassCharacterGeneric Edit10 Allow NULL? 
100TRTSTRSNMTest Result NameStringGeneric Edit300 Allow NULL? 
101TRRSSTSResult Entry StatusCharacterGeneric Edit10 Allow NULL? 
102TRRSCONVIDResult Conversion IDStringGeneric Edit300 Allow NULL? 
103TRFRMRSVALFrom Result ValueStringGeneric Edit150 Allow NULL? 
104TRFRMRSUMFrom Result UMStringUDC (37 UM)30 Allow NULL? 
105TRQMRF3Quality Mgmt Reference 3StringGeneric Edit300 Allow NULL? 
106TRQMCD3Quality Mgmt Code 3StringGeneric Edit30 Allow NULL? 
107TRQMAB3Quality Mgmt Number 3NumericGeneric Edit80 Allow NULL? 
108TRQMNUM3Quality Mgmt Numeric 3NumericGeneric Edit150 Allow NULL? 
109TRQMDT3Quality Mgmt Date 3DateGeneric Edit60
110TRQABLRULQuality Assurance Blending RuleStringUDC (31B QB)50 Allow NULL? 
111TRCDEC2Display DecimalsCharacterGeneric Edit10 Allow NULL? 
112TRPRVQVALPrevious Test ValueStringGeneric Edit150 Allow NULL? 
113TRPRVQDATPrevious Date TestedDateGeneric Edit60
114TRPRVRSNMPrevious Result Name ValueStringGeneric Edit150 Allow NULL? 
115TRNUMTNumeric (1/0)CharacterGeneric Edit10 Allow NULL? 
116TRNUMT3Numeric (1/0)CharacterGeneric Edit10 Allow NULL? 
117TRPRVRSUMPrevious Result UOMStringUDC (37 UM)30 Allow NULL? 
118TRDLABDefault LabNumericGeneric Edit80 Allow NULL? 
119TRMELCMeasurement LocationStringUDC (13 LC)100 Allow NULL? 
120TRRNAMAXResult Name Allowed Maximum ValueStringGeneric Edit150 Allow NULL? 
121TRRNAMINResult Name Allowed Minimum ValueStringGeneric Edit150 Allow NULL? 
122TRRNPMAXResult Name Preferred Maximum ValueStringGeneric Edit150 Allow NULL? 
123TRRNPMINResult Name Preferred Minimum ValueStringGeneric Edit150 Allow NULL? 
124TRRNQTRGResult Name Target ValueStringGeneric Edit150 Allow NULL? 
125TRBLUIDBlock IdentifierNumericGeneric Edit80 Allow NULL? 
126TRSBLUIDBlock Descriptor IDNumericGeneric Edit50 Allow NULL? 
127TRSY1System CodeStringUDC (98 SY)40 Allow NULL? 
128TRRT1User Defined CodesStringGeneric Edit20 Allow NULL? 
129TRTSTRTYTest Reading TypeStringGeneric Edit30 Allow NULL? 
130TRWVNUMVessel NumberStringGeneric Edit300 Allow NULL? 

TOP812 | 37 | F3711 INDEXES

NumberDescription
1UniqueKeyID (Primary/Unique)
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending
4Document Document Type A
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5LOTNLot/Serial NumberAscending
6LOCNLocationAscending
7ITMItem Number - ShortAscending
8MCUBusiness UnitAscending
9SNBRSample NumberAscending
10TSRTTest Sort Sequence NumberAscending
7Lot Location Item Branch
ElementAliasDescriptionSequence
1LOTNLot/Serial NumberAscending
2LOCNLocationAscending
3ITMItem Number - ShortAscending
4MCUBusiness UnitAscending
5DOCODocument (Order No Invoice etc.)Ascending
6DCTOOrder TypeAscending
7KCOOOrder Company (Order Number)Ascending
8LNIDLine NumberAscending
9QTSTTest IDAscending
10MCU2Business Unit 2Ascending
8Document Document Type B
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5LOTNLot/Serial NumberAscending
6LOCNLocationAscending
7ITMItem Number - ShortAscending
8MCUBusiness UnitAscending
9TSRTTest Sort Sequence NumberAscending
10SNBRSample NumberAscending
9TripNumber LegNumber A
ElementAliasDescriptionSequence
1TRPTrip NumberAscending
2TRPLLoad Leg NumberAscending
3MCUBusiness UnitAscending
4LCMPLogical Compartment NumberAscending
5DOCODocument (Order No Invoice etc.)Ascending
6DCTOOrder TypeAscending
7KCOOOrder Company (Order Number)Ascending
8LNIDLine NumberAscending
9SNBRSample NumberAscending
10TSRTTest Sort Sequence NumberAscending
11TripNumber LegNumber B
ElementAliasDescriptionSequence
1TRPTrip NumberAscending
2TRPLLoad Leg NumberAscending
3MCUBusiness UnitAscending
4LCMPLogical Compartment NumberAscending
5DOCODocument (Order No Invoice etc.)Ascending
6DCTOOrder TypeAscending
7KCOOOrder Company (Order Number)Ascending
8LNIDLine NumberAscending
9QTSTTest IDAscending
10MCU2Business Unit 2Ascending
12TestID ShortItem Branch
ElementAliasDescriptionSequence
1QTSTTest IDAscending
2ITMItem Number - ShortAscending
3MCU2Business Unit 2Ascending
4MCUBusiness UnitAscending
5LOTNLot/Serial NumberAscending
6LOCNLocationAscending
7QPCDQuality Application CodeAscending
13Document Document Type C
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5SNBRSample NumberDescending
6TSRTTest Sort Sequence NumberAscending
14TestID Detail Branch
ElementAliasDescriptionSequence
1QTSTTest IDAscending
2MCU2Business Unit 2Ascending
15Branch Item TestID
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3QTSTTest IDAscending
4MCU2Business Unit 2Ascending
5LOTNLot/Serial NumberAscending
6LOCNLocationAscending
7DCTOOrder TypeAscending
8DOCODocument (Order No Invoice etc.)Ascending
16TripNumber LegNumber C
ElementAliasDescriptionSequence
1TRPTrip NumberAscending
2TRPLLoad Leg NumberAscending
3MCUBusiness UnitAscending
4LCMPLogical Compartment NumberAscending
5DOCODocument (Order No Invoice etc.)Ascending
6DCTOOrder TypeAscending
7KCOOOrder Company (Order Number)Ascending
8LNIDLine NumberAscending
9TSRTTest Sort Sequence NumberAscending
10SNBRSample NumberAscending
19Lot Test Sort Seq DESC
ElementAliasDescriptionSequence
1LOTNLot/Serial NumberAscending
2LOCNLocationAscending
3ITMItem Number - ShortAscending
4MCUBusiness UnitAscending
5DOCODocument (Order No Invoice etc.)Ascending
6DCTOOrder TypeAscending
7KCOOOrder Company (Order Number)Ascending
8LNIDLine NumberAscending
9QTSTTest IDAscending
10TSRTTest Sort Sequence NumberDescending
20Trip Test Sort Seq DESC
ElementAliasDescriptionSequence
1TRPTrip NumberAscending
2TRPLLoad Leg NumberAscending
3MCUBusiness UnitAscending
4LCMPLogical Compartment NumberAscending
5DOCODocument (Order No Invoice etc.)Ascending
6DCTOOrder TypeAscending
7KCOOOrder Company (Order Number)Ascending
8LNIDLine NumberAscending
9QTSTTest IDAscending
10TSRTTest Sort Sequence NumberDescending
21Document Document Type Full
ElementAliasDescriptionSequence
1DOCODocument (Order No Invoice etc.)Ascending
2DCTOOrder TypeAscending
3KCOOOrder Company (Order Number)Ascending
4LNIDLine NumberAscending
5LOTNLot/Serial NumberAscending
6LOCNLocationAscending
7MCUBusiness UnitAscending
8ITMItem Number - ShortAscending
9TRPTrip NumberAscending
10TRPLLoad Leg NumberAscending
11LCMPLogical Compartment NumberAscending
12TSRTTest Sort Sequence NumberAscending
22Branch WineLot
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2WLOTNBlend Lot NumberAscending
3TSTRSNMTest Result NameAscending
23Opid CostCenter BlendLot
ElementAliasDescriptionSequence
1WOPIDOperation IDAscending
2MCUBusiness UnitAscending
3WLOTNBlend Lot NumberAscending
4TSTRSNMTest Result NameAscending
24Equip Location Test ID +
ElementAliasDescriptionSequence
1NUMBAsset Item NumberAscending
2MELCMeasurement LocationAscending
3QTSTTest IDAscending
4TSRTTest Sort Sequence NumberAscending
5MCU2Business Unit 2Ascending
6QDATDate testedAscending
7QTIMTime testedAscending