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

69 COLUMNS | 5 INDEXES | Print definition?812 | 37 | F40318 TABLE

37: Quality Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F40318QC695Preference Profile - Quality ManagementMaster 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 QCAN8, QCCS18, QCITM, QCIT18, QCEFTJ, QCEXDJ, QCMNQ, QCMXQ, QCUOM, QCSTAW, QCTXID, QCSTPR, QCOSEQ, QCEFFF, QCEFFT, QCQTSN, QCMCU, QCTSRT, QCQTST, QCTTTY, QCQREV, QCTSSP, QCMCU2, QCSY, QCRT, QCAMIN, QCAMAX, QCPMIN, QCPMAX, QCQTRG, QCQSSZ, QCQUM, QCQSMP, QCSMPC, QCACQT, QCACPC, QCPTTS, QCMFGR, QCMRRR, QCPRER, QCPRCR, QCMFGC, QCSHPR, QCBLKR, QCOPSQ, QCOPRS, QCBSEQ, QCTRT, QCTMHD, QCRSUM, QCNUMB, QCASTM, QCQPRP, QCTTST, QCMMCU, QCCDEC, QCURCD, QCURDT, QCURAT, QCURRF, QCURAB, QCUKID, QCACTN, QCUSER, QCPID, QCUPMJ, QCTDAY, QCJOBN, QCDERC FROM F40318

TOP812 | 37 | F40318 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1QCAN8Address NumberNumericUDC80 Allow NULL? 
2QCCS18Customer Group - Quality ManagementStringUDC (40 18)80 Allow NULL? 
3QCITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
4QCIT18Item Group - Quality ManagementStringUDC (40 68)80 Allow NULL? 
5QCEFTJDate - EffectiveDateGeneric Edit60
6QCEXDJDate - ExpiredDateGeneric Edit60
7QCMNQQuantity - FromNumericGeneric Edit152 Allow NULL? 
8QCMXQQuantity - ThruNumericGeneric Edit152 Allow NULL? 
9QCUOMUnit of Measure as InputStringUDC (00 UM)20 Allow NULL? 
10QCSTAWStatusCharacterUDC (00 WS)10 Allow NULL? 
11QCTXIDText ID NumberNumericGeneric Edit80 Allow NULL? 
12QCSTPRStatus - PreferenceCharacterUDC (40 PT)10 Allow NULL? 
13QCOSEQSequence NumberNumericGeneric Edit40 Allow NULL? 
14QCEFFFEffective - From DateDateGeneric Edit60
15QCEFFTEffective - Thru DateDateGeneric Edit60
16QCQTSNQuality Table Sequence NumberNumericGeneric Edit80 Allow NULL? 
17QCMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
18QCTSRTTest Sort Sequence NumberNumericGeneric Edit50 Allow NULL? 
19QCQTSTTest IDStringGeneric Edit250 Allow NULL? 
20QCTTTYTest TypeCharacterUDC (37 TY)10 Allow NULL? 
21QCQREVSpecification Revision LevelStringGeneric Edit30 Allow NULL? 
22QCTSSPTest/Specification flagCharacterUDC (37 TS)10 Allow NULL? 
23QCMCU2Business Unit 2StringGeneric Edit120 Allow NULL? 
24QCSYProduct CodeStringUDC (98 SY)40 Allow NULL? 
25QCRTUser Defined CodesStringGeneric Edit20 Allow NULL? 
26QCAMINAllowed Minimum ValueStringGeneric Edit150 Allow NULL? 
27QCAMAXAllowed Maximum ValueStringGeneric Edit150 Allow NULL? 
28QCPMINPreferred Minimum Value (future use)StringGeneric Edit150 Allow NULL? 
29QCPMAXPreferred Maximum Value (future use)StringGeneric Edit150 Allow NULL? 
30QCQTRGTarget ValueStringGeneric Edit150 Allow NULL? 
31QCQSSZSample SizeNumericGeneric Edit150 Allow NULL? 
32QCQUMSample Size Unit of MeasureStringUDC (37 UM)30 Allow NULL? 
33QCQSMPNumber of SamplesNumericGeneric Edit150 Allow NULL? 
34QCSMPCSample PercentageNumericGeneric Edit52 Allow NULL? 
35QCACQTAccept QuantityNumericGeneric Edit150 Allow NULL? 
36QCACPCAccept PercentageNumericGeneric Edit52 Allow NULL? 
37QCPTTSPrint TestCharacterUDC (37 PT)10 Allow NULL? 
38QCMFGRManufacturing OperationsCharacterGeneric Edit10 Allow NULL? 
39QCMRRRManufacturing Receipt RoutingCharacterGeneric Edit10 Allow NULL? 
40QCPRERPurchasing Receipt RoutingCharacterGeneric Edit10 Allow NULL? 
41QCPRCRPurchasing ReceiptsCharacterGeneric Edit10 Allow NULL? 
42QCMFGCManufacturing CompletionsCharacterGeneric Edit10 Allow NULL? 
43QCSHPRShip ConfirmCharacterGeneric Edit10 Allow NULL? 
44QCBLKRBulk ConfirmCharacterGeneric Edit10 Allow NULL? 
45QCOPSQSequence Number - OperationsNumericGeneric Edit52 Allow NULL? 
46QCOPRSSequence Number - OperationsNumericGeneric Edit30 Allow NULL? 
47QCBSEQSorszám - Buborék sorszámNumericGeneric Edit50 Allow NULL? 
48QCTRTType of RoutingStringUDC (40 TR)30 Allow NULL? 
49QCTMHDTest MethodStringGeneric Edit300 Allow NULL? 
50QCRSUMResults Unit of MeasureStringUDC (37 UM)30 Allow NULL? 
51QCNUMBAsset Item NumberNumericGeneric Edit80 Allow NULL? 
52QCASTMASTM ReferenceStringGeneric Edit300 Allow NULL? 
53QCQPRPPropertyStringUDC (37 PR)100 Allow NULL? 
54QCTTSTTiming of Test (Future Use)CharacterGeneric Edit10 Allow NULL? 
55QCMMCUBranchStringGeneric Edit120 Allow NULL? 
56QCCDECDisplay DecimalsCharacterGeneric Edit10 Allow NULL? 
57QCURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
58QCURDTUser Reserved DateDateGeneric Edit60
59QCURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
60QCURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
61QCURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
62QCUKIDUnique Key ID (Internal)NumericGeneric Edit150 Allow NULL? 
63QCACTNAction CodeCharacterGeneric Edit10 Allow NULL? 
64QCUSERUser IDStringGeneric Edit100 Allow NULL? 
65QCPIDProgram IDStringGeneric Edit100 Allow NULL? 
66QCUPMJDate - UpdatedDateGeneric Edit60
67QCTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
68QCJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
69QCDERCDerived CalculationStringGeneric Edit800 Allow NULL? 

TOP812 | 37 | F40318 INDEXES

NumberDescription
2AN8_CS18_ITM_IT18_MCU_TSRT (Primary/Unique)
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2CS18Customer Group - Quality ManagementAscending
3ITMItem Number - ShortAscending
4IT18Item Group - Quality ManagementAscending
5EXDJDate - ExpiredAscending
6MCUBusiness UnitAscending
7STAWStatusAscending
8EFFTEffective - Thru DateAscending
9QTSNQuality Table Sequence NumberAscending
10TSRTTest Sort Sequence NumberAscending
3TestID DetailBranchPlant
ElementAliasDescriptionSequence
1QTSTTest IDAscending
2MCU2Business Unit 2Ascending
3STAWStatusAscending
4Customer CustGroup Item +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2CS18Customer Group - Quality ManagementAscending
3ITMItem Number - ShortAscending
4IT18Item Group - Quality ManagementAscending
5EXDJDate - ExpiredAscending
6MCUBusiness UnitAscending
7STAWStatusAscending
8TSRTTest Sort Sequence NumberAscending
9EFFTEffective - Thru DateAscending
10QTSNQuality Table Sequence NumberAscending
5Customer CustGroup Item B +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2CS18Customer Group - Quality ManagementAscending
3ITMItem Number - ShortAscending
4IT18Item Group - Quality ManagementAscending
5EXDJDate - ExpiredAscending
6MCUBusiness UnitAscending
7STAWStatusAscending
8UKIDUnique Key ID (Internal)Ascending
6Customer CustGroup Item C +
ElementAliasDescriptionSequence
1AN8Address NumberAscending
2CS18Customer Group - Quality ManagementAscending
3ITMItem Number - ShortAscending
4IT18Item Group - Quality ManagementAscending
5STAWStatusAscending
6TSRTTest Sort Sequence NumberAscending