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
3F9671SDSoftware Update Detail Table
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F41021LIItem Location File
10F03012AICustomer Master by Line of Business

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
9F4111ILItem Ledger File
10F0411RPAccounts Payable Ledger

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

78 COLUMNS | 2 INDEXES | Print definition?812 | 37 | F3701 TABLE

37: Quality Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F3701QA782Test Definitions Master FileMaster 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 QAQTST, QAMCU, QASTAW, QAEFFT, QAQTSN, QAEFFF, QADSC1, QATTTY, QANUMT, QASY, QART, QACDEC, QAQPRP, QAASTM, QAAMIN, QAPMIN, QAAMAX, QAPMAX, QAQTRG, QAQSSZ, QAQUM, QAQSMP, QAAVG, QATSDP, QAPTTS, QAPTTX, QAQTC1, QAQTC2, QAQTC3, QAQTC4, QAQTC5, QASMPC, QAACQT, QAACPC, QAQREV, QATMHD, QARSUM, QANUMB, QAQM01, QAQM02, QAQM03, QAQM04, QAQM05, QAQM06, QAQM07, QAQM08, QAQM09, QAQM10, QAMMCU, QADERC, QAURCD, QAURDT, QAURAT, QAURRF, QAURAB, QAACTN, QAUKID, QAUSER, QAPID, QAUPMJ, QATDAY, QAJOBN, QATSTRSNM, QARSCONVID, QARSDURDY, QATSTDURDY, QACHGTHRES, QAQMRF1, QAQMCD1, QAQMAB1, QAQMNUM1, QAQMDT1, QACRTLBTSK, QASMPMTHD, QASMPCNSL, QASMPCNTR, QASMPCLSR, QADLAB FROM F3701

TOP812 | 37 | F3701 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1QAQTSTTest IDStringGeneric Edit250 Allow NULL? 
2QAMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
3QASTAWStatusCharacterUDC (00 WS)10 Allow NULL? 
4QAEFFTEffective - Thru DateDateGeneric Edit60
5QAQTSNQuality Table Sequence NumberNumericGeneric Edit80 Allow NULL? 
6QAEFFFEffective - From DateDateGeneric Edit60
7QADSC1DescriptionStringGeneric Edit300 Allow NULL? 
8QATTTYTest TypeCharacterUDC (37 TY)10 Allow NULL? 
9QANUMTNumeric (1/0)CharacterGeneric Edit10 Allow NULL? 
10QASYProduct CodeStringUDC (98 SY)40 Allow NULL? 
11QARTUser Defined CodesStringGeneric Edit20 Allow NULL? 
12QACDECDisplay DecimalsCharacterGeneric Edit10 Allow NULL? 
13QAQPRPPropertyStringUDC (37 PR)100 Allow NULL? 
14QAASTMASTM ReferenceStringGeneric Edit300 Allow NULL? 
15QAAMINAllowed Minimum ValueStringGeneric Edit150 Allow NULL? 
16QAPMINPreferred Minimum Value (future use)StringGeneric Edit150 Allow NULL? 
17QAAMAXAllowed Maximum ValueStringGeneric Edit150 Allow NULL? 
18QAPMAXPreferred Maximum Value (future use)StringGeneric Edit150 Allow NULL? 
19QAQTRGTarget ValueStringGeneric Edit150 Allow NULL? 
20QAQSSZSample SizeNumericGeneric Edit150 Allow NULL? 
21QAQUMSample Size Unit of MeasureStringUDC (37 UM)30 Allow NULL? 
22QAQSMPNumber of SamplesNumericGeneric Edit150 Allow NULL? 
23QAAVGAverageCharacterGeneric Edit10 Allow NULL? 
24QATSDPDisplay/Evaluate TestCharacterUDC (37 DP)10 Allow NULL? 
25QAPTTSPrint TestCharacterUDC (37 PT)10 Allow NULL? 
26QAPTTXPrint Text (1/0)CharacterGeneric Edit10 Allow NULL? 
27QAQTC1Test Category Code 1StringUDC (37 T1)30 Allow NULL? 
28QAQTC2Test Category Code 2StringUDC (37 T2)30 Allow NULL? 
29QAQTC3Test Category Code 3StringUDC (37 T3)30 Allow NULL? 
30QAQTC4Test Category Code 4StringUDC (37 T4)30 Allow NULL? 
31QAQTC5Test Category Code 5StringUDC (37 T5)30 Allow NULL? 
32QASMPCSample PercentageNumericGeneric Edit52 Allow NULL? 
33QAACQTAccept QuantityNumericGeneric Edit150 Allow NULL? 
34QAACPCAccept PercentageNumericGeneric Edit52 Allow NULL? 
35QAQREVSpecification Revision LevelStringGeneric Edit30 Allow NULL? 
36QATMHDTest MethodStringGeneric Edit300 Allow NULL? 
37QARSUMResults Unit of MeasureStringUDC (37 UM)30 Allow NULL? 
38QANUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
39QAQM01Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
40QAQM02Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
41QAQM03Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
42QAQM04Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
43QAQM05Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
44QAQM06Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
45QAQM07Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
46QAQM08Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
47QAQM09Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
48QAQM10Quality Management StatusCharacterGeneric Edit10 Allow NULL? 
49QAMMCUBranchStringGeneric Edit120 Allow NULL? 
50QADERCDerived CalculationStringGeneric Edit800 Allow NULL? 
51QAURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
52QAURDTUser Reserved DateDateGeneric Edit60
53QAURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
54QAURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
55QAURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
56QAACTNAction CodeCharacterGeneric Edit10 Allow NULL? 
57QAUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
58QAUSERUser IDStringGeneric Edit100 Allow NULL? 
59QAPIDProgram IDStringGeneric Edit100 Allow NULL? 
60QAUPMJDate - UpdatedDateGeneric Edit60
61QATDAYTime of DayNumericGeneric Edit60 Allow NULL? 
62QAJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
63QATSTRSNMTest Result NameStringGeneric Edit300 Allow NULL? 
64QARSCONVIDResult Conversion IDStringGeneric Edit300 Allow NULL? 
65QARSDURDYResult Duration DaysNumericGeneric Edit30 Allow NULL? 
66QATSTDURDYTest Duration DaysNumericGeneric Edit30 Allow NULL? 
67QACHGTHRESChange ThresholdNumericGeneric Edit154 Allow NULL? 
68QAQMRF1Quality Mgmt Reference 1StringGeneric Edit300 Allow NULL? 
69QAQMCD1Quality Mgmt Code 1StringGeneric Edit30 Allow NULL? 
70QAQMAB1Quality Mgmt Number 1NumericGeneric Edit80 Allow NULL? 
71QAQMNUM1Quality Mgmt Numeric 1NumericGeneric Edit150 Allow NULL? 
72QAQMDT1Quality Mgmt Date 1DateGeneric Edit60
73QACRTLBTSKCreate Lab Task FlagCharacterGeneric Edit10 Allow NULL? 
74QASMPMTHDSample MethodStringUDC (37 SM)100 Allow NULL? 
75QASMPCNSLSample ConsolidationStringUDC (37 CN)20 Allow NULL? 
76QASMPCNTRSample ContainerStringUDC (37 CR)100 Allow NULL? 
77QASMPCLSRSample ClosureStringUDC (37 CL)100 Allow NULL? 
78QADLABDefault LabNumericGeneric Edit80 Allow NULL? 

TOP812 | 37 | F3701 INDEXES

NumberDescription
1Test ID Cost Center (Primary/Unique)
ElementAliasDescriptionSequence
1QTSTTest IDAscending
2MCUBusiness UnitAscending
3STAWStatusAscending
4EFFTEffective - Thru DateAscending
5QTSNQuality Table Sequence NumberAscending
2UKID
ElementAliasDescriptionSequence
1UKIDUnique Key ID (Internal)Ascending