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

67 COLUMNS | 2 INDEXES | Print definition?920 | 40R | F40R12 TABLE

40R: Demand Scheduling
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F40R12CQ672Cumulative QuantitiesFiles40R: Demand SchedulingBusiness 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 CQCUMID, CQMCU, CQCITM, CQAN8, CQSHAN, CQCSTPO, CQCUMUV1, CQCUMUV2, CQCUMUV3, CQCUMUT1, CQCUMUT2, CQCUMUT3, CQCUMTYPE, CQCUMADJ, CQSHPN, CQCUMREFNO, CQCUMS, CQCUMSADJ, CQADDJ, CQADTM, CQCCUMRQY, CQCCUMRDJ, CQCCUMRTM, CQCRQQYFM, CQCRQQYPN, CQCRQQYPS, CQCRQSDJFM, CQCRQSTMFM, CQCRQEDJFM, CQCRQETMFM, CQCRQSDJPN, CQCRQSTMPN, CQCRQEDJPN, CQCRQETMPN, CQCRQSDJPS, CQCRQSTMPS, CQCRQEDJPS, CQCRQETMPS, CQCCUMSQY, CQCCUMSDJ, CQCCUMSTM, CQCCUMSUOM, CQFBCUMQY, CQFBCUMSDJ, CQFBCUMEDJ, CQMTCUMQY, CQMTCUMSDJ, CQMTCUMEDJ, CQHFBCUMQY, CQHFBRLDJ, CQHFBRLNO, CQHMTCUMQY, CQHMTRLDJ, CQHMTRLNO, CQCUMRBDJ, CQCUMRBTM, CQURCD, CQURDT, CQURAT, CQURAB, CQURRF, CQUSER, CQPID, CQJOBN, CQUPMJ, CQTDAY, CQCUMATID FROM F40R12

TOP920 | 40R | F40R12 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1CQCUMIDCUM IDNumericGeneric Edit150 Allow NULL? 
2CQMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
3CQCITMItem Number - Customer/SupplierStringGeneric Edit250 Allow NULL? 
4CQAN8Address NumberNumericGeneric Edit80 Allow NULL? 
5CQSHANAddress Number - Ship ToNumericGeneric Edit80 Allow NULL? 
6CQCSTPOCustomer POStringGeneric Edit300 Allow NULL? 
7CQCUMUV1CUM User Field Value 1StringGeneric Edit300 Allow NULL? 
8CQCUMUV2CUM User Field Value 2StringGeneric Edit300 Allow NULL? 
9CQCUMUV3CUM User Field Value 3StringGeneric Edit300 Allow NULL? 
10CQCUMUT1CUM User Field Type 1StringUDC (40R UF)30 Allow NULL? 
11CQCUMUT2CUM User Field Type 2StringUDC (40R UF)30 Allow NULL? 
12CQCUMUT3CUM User Field Type 3StringUDC (40R UF)30 Allow NULL? 
13CQCUMTYPECUM TypeCharacterGeneric Edit10 Allow NULL? 
14CQCUMADJCode - CUM AdjustmentStringUDC (40R CA)20 Allow NULL? 
15CQSHPNShipment NumberNumericGeneric Edit80 Allow NULL? 
16CQCUMREFNOCUM Reference NumberStringGeneric Edit250 Allow NULL? 
17CQCUMSCUM Quantity ShippedNumericGeneric Edit150 Allow NULL? 
18CQCUMSADJCUM Shipped AdjustmentNumericGeneric Edit150 Allow NULL? 
19CQADDJDate - Actual Ship DateDateGeneric Edit60
20CQADTMActual Shipment TimeNumericGeneric Edit60 Allow NULL? 
21CQCCUMRQYCustomer CUM Received QuantityNumericGeneric Edit150 Allow NULL? 
22CQCCUMRDJDate - Customer CUM ReceivedDateGeneric Edit60
23CQCCUMRTMCustomer CUM Received TimeNumericGeneric Edit60 Allow NULL? 
24CQCRQQYFMCUM Required Quantity - FirmNumericGeneric Edit150 Allow NULL? 
25CQCRQQYPNCUM Required Quantity - PlanNumericGeneric Edit150 Allow NULL? 
26CQCRQQYPSCUM Required Quantity - Production SeqNumericGeneric Edit150 Allow NULL? 
27CQCRQSDJFMDate - Firm CUM Required StartDateGeneric Edit60
28CQCRQSTMFMCUM Required Start Time - FirmNumericGeneric Edit60 Allow NULL? 
29CQCRQEDJFMDate - Firm CUM Required EndDateGeneric Edit60
30CQCRQETMFMCUM Required End Time - FirmNumericGeneric Edit60 Allow NULL? 
31CQCRQSDJPNDate - Plan CUM Required StartDateGeneric Edit60
32CQCRQSTMPNCUM Required Start Time - PlanNumericGeneric Edit60 Allow NULL? 
33CQCRQEDJPNDate - Plan CUM Required EndDateGeneric Edit60
34CQCRQETMPNCUM Required End Time - PlanNumericGeneric Edit60 Allow NULL? 
35CQCRQSDJPSDate - Prod Seq CUM Required StartDateGeneric Edit60
36CQCRQSTMPSCUM Required Start Time - Prod SeqNumericGeneric Edit60 Allow NULL? 
37CQCRQEDJPSDate - Prod Seq CUM Required EndDateGeneric Edit60
38CQCRQETMPSCUM Required End Time - Prod SeqNumericGeneric Edit60 Allow NULL? 
39CQCCUMSQYCustomer CUM Shipped QuantityNumericGeneric Edit150 Allow NULL? 
40CQCCUMSDJDate - Customer CUM ShippedDateGeneric Edit60
41CQCCUMSTMCustomer CUM Shipped TimeNumericGeneric Edit60 Allow NULL? 
42CQCCUMSUOMCustomer CUM Shipped UOMStringGeneric Edit20 Allow NULL? 
43CQFBCUMQYFabrication CUM QuantityNumericGeneric Edit150 Allow NULL? 
44CQFBCUMSDJDate - Fabrication CUM StartDateGeneric Edit60
45CQFBCUMEDJDate - Fabrication CUM EndDateGeneric Edit60
46CQMTCUMQYMaterial CUM QuantityNumericGeneric Edit150 Allow NULL? 
47CQMTCUMSDJDate - Material CUM StartDateGeneric Edit60
48CQMTCUMEDJDate - Material CUM EndDateGeneric Edit60
49CQHFBCUMQYHigh Fabrication CUM QuantityNumericGeneric Edit150 Allow NULL? 
50CQHFBRLDJDate - High Fabrication ReleaseDateGeneric Edit60
51CQHFBRLNOHigh Fabrication Release NumberStringGeneric Edit100 Allow NULL? 
52CQHMTCUMQYHigh Material CUM QuantityNumericGeneric Edit150 Allow NULL? 
53CQHMTRLDJDate - High Material ReleaseDateGeneric Edit60
54CQHMTRLNOHigh Material Release NumberStringGeneric Edit100 Allow NULL? 
55CQCUMRBDJDate - CUM RollbackDateGeneric Edit60
56CQCUMRBTMCUM Rollback TimeNumericGeneric Edit60 Allow NULL? 
57CQURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
58CQURDTUser Reserved DateDateGeneric Edit60
59CQURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
60CQURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
61CQURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
62CQUSERUser IDStringGeneric Edit100 Allow NULL? 
63CQPIDProgram IDStringGeneric Edit100 Allow NULL? 
64CQJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
65CQUPMJDate - UpdatedDateGeneric Edit60
66CQTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
67CQCUMATIDCUM Attachment IDNumericGeneric Edit150 Allow NULL? 

TOP920 | 40R | F40R12 INDEXES

NumberDescription
1CUM ID (Primary/Unique)
ElementAliasDescriptionSequence
1CUMIDCUM IDAscending
2Alternate Key
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2CITMItem Number - Customer/SupplierAscending
3AN8Address NumberAscending
4SHANAddress Number - Ship ToAscending
5CSTPOCustomer POAscending
6CUMUV1CUM User Field Value 1Ascending
7CUMUV2CUM User Field Value 2Ascending
8CUMUV3CUM User Field Value 3Ascending
9CUMUT1CUM User Field Type 1Ascending
10CUMUT2CUM User Field Type 2Ascending
11CUMUT3CUM User Field Type 3Ascending
12CUMTYPECUM TypeAscending