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

42 COLUMNS | 9 INDEXES | Print definition?812 | 41B | F41515 TABLE

41B: Bulk Stock Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F41515PQ429Multi-Meter ReadingsTransaction Files41B: Bulk Stock ManagementAS400 Coexistence Tables
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 PQMETN, PQITM, PQMCU, PQTKID, PQPPRR, PQPNCR, PQTTRE, PQBUM0, PQAMBI, PQAMBU, PQNRDJ, PQRDTM, PQRECS, PQMETS, PQTMCP, PQLRST, PQNRST, PQTHDT, PQMCYN, PQUSER, PQPID, PQJOBN, PQUPMJ, PQTDAY, PQSTOK, PQBUM4, PQWGTR, PQBUM5, PQSTUM, PQBUM6, PQTEMP, PQSTPU, PQDNTY, PQDNTP, PQDETP, PQVCF, PQURRF, PQDTPU, PQURDT, PQURCD, PQURAT, PQURAB FROM F41515

TOP812 | 41B | F41515 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PQMETNMeter NumberStringGeneric Edit100 Allow NULL? 
2PQITMItem Number - ShortNumericGeneric Edit80 Allow NULL? 
3PQMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
4PQTKIDTank IDStringGeneric Edit80 Allow NULL? 
5PQPPRRUnits - Previous Total Throughput Qty.NumericGeneric Edit150 Allow NULL? 
6PQPNCRClosing ReadingNumericGeneric Edit150 Allow NULL? 
7PQTTREThroughput CalculatedNumericGeneric Edit152 Allow NULL? 
8PQBUM0Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
9PQAMBIQuantity - Ambient In Inventory UnitsNumericGeneric Edit152 Allow NULL? 
10PQAMBUUnit of Measure - Ambient VolumeStringUDC (00 UM)20 Allow NULL? 
11PQNRDJDate - New Closing ReadingDateGeneric Edit60
12PQRDTMTime - ReadingNumericGeneric Edit60 Allow NULL? 
13PQRECSReconciled (Y/N)CharacterUDC (41B RP)10 Allow NULL? 
14PQMETSMeter StatusCharacterUDC (41B MS)10 Allow NULL? 
15PQTMCPTemperature Compensated Y/NCharacterGeneric Edit10 Allow NULL? 
16PQLRSTReconciliation Status - CurrentNumericUDC (41B RC)30 Allow NULL? 
17PQNRSTReconciliation Status - NextNumericUDC (41B RC)30 Allow NULL? 
18PQTHDTThroughput Reconciled DateDateGeneric Edit60
19PQMCYNMeter Correction FlagCharacterGeneric Edit10 Allow NULL? 
20PQUSERUser IDStringGeneric Edit100 Allow NULL? 
21PQPIDProgram IDStringGeneric Edit100 Allow NULL? 
22PQJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
23PQUPMJDate - UpdatedDateGeneric Edit60
24PQTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
25PQSTOKVolume - StandardNumericGeneric Edit152 Allow NULL? 
26PQBUM4Unit of Measure 4StringUDC (00 UM)20 Allow NULL? 
27PQWGTRWeight ResultNumericGeneric Edit152 Allow NULL? 
28PQBUM5Unit of Measure 5StringUDC (00 UM)20 Allow NULL? 
29PQSTUMQuantity - Primary Stock Accounting UnitNumericGeneric Edit152 Allow NULL? 
30PQBUM6Unit of MeasureStringUDC (00 UM)20 Allow NULL? 
31PQTEMPTemperatureNumericGeneric Edit72 Allow NULL? 
32PQSTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
33PQDNTYDensityNumericGeneric Edit72 Allow NULL? 
34PQDNTPDensity Type - At Standard TemperatureCharacterUDC (41B DT)10 Allow NULL? 
35PQDETPDensity TemperatureNumericGeneric Edit72 Allow NULL? 
36PQVCFVolume Correction FactorNumericGeneric Edit74 Allow NULL? 
37PQURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
38PQDTPUTemperature TypeCharacterUDC (41B TP)10 Allow NULL? 
39PQURDTUser Reserved DateDateGeneric Edit60
40PQURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
41PQURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
42PQURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 

TOP812 | 41B | F41515 INDEXES

NumberDescription
1Branch Item Meter Close Date (Primary/Unique)
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3METNMeter NumberAscending
4NRDJDate - New Closing ReadingAscending
5RDTMTime - ReadingAscending
2Branch Meter Reconciliation
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2METNMeter NumberAscending
3RECSReconciled (Y/N)Ascending
3Meter Branch Status Date Time
ElementAliasDescriptionSequence
1METNMeter NumberAscending
2MCUBusiness UnitAscending
3METSMeter StatusAscending
4NRDJDate - New Closing ReadingAscending
5RDTMTime - ReadingAscending
4Item Branch Sts Dte Time DSND
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3METSMeter StatusAscending
4NRDJDate - New Closing ReadingDescending
5RDTMTime - ReadingDescending
5Branch Item Rec Flag Date Time
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3LRSTReconciliation Status - CurrentAscending
4MCYNMeter Correction FlagAscending
5NRDJDate - New Closing ReadingAscending
6RDTMTime - ReadingAscending
7METNMeter NumberAscending
6Branch Item ReconciledDte DSND
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3THDTThroughput Reconciled DateDescending
7Branch Item RecStatus Flag Mtr
ElementAliasDescriptionSequence
1MCUBusiness UnitAscending
2ITMItem Number - ShortAscending
3LRSTReconciliation Status - CurrentAscending
4MCYNMeter Correction FlagAscending
5METNMeter NumberAscending
6NRDJDate - New Closing ReadingAscending
7RDTMTime - ReadingAscending
8Item Branch Status Date Time
ElementAliasDescriptionSequence
1ITMItem Number - ShortAscending
2MCUBusiness UnitAscending
3METSMeter StatusAscending
4NRDJDate - New Closing ReadingAscending
5RDTMTime - ReadingAscending
9Meter Branch Sts Dte Time DSND
ElementAliasDescriptionSequence
1METNMeter NumberAscending
2MCUBusiness UnitAscending
3METSMeter StatusAscending
4NRDJDate - New Closing ReadingDescending
5RDTMTime - ReadingDescending