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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

51 COLUMNS | 1 INDEXES | Print definition?920 | 31B | F31B0740 TABLE

31B: Blend Management
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F31B0740PA511Planning AssumptionsFiles31B: Blend Management
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 PAEURID, PAMCU, PAACTIVITY, PAPLNTYP, PAPBEGDT, PAPENDDT, PAPQA1, PAPQA2, PAPQA3, PAPQA4, PAPQA5, PAPQA6, PAPQA7, PAPQA8, PAPQA9, PAPQA10, PAPUOM1, PAPUOM2, PAPUOM3, PAPUOM4, PAPUOM5, PAPUOM6, PAPUOM7, PAPUOM8, PAPUOM9, PAPUOM10, PAPQC1, PAPQC2, PAPQC3, PAPQC4, PAPQC5, PAPQC6, PAPQC7, PAPQC8, PAPQC9, PAPQC10, PAURAB, PAURAT, PAURCD, PAURDT, PAURRF, PAJOBN, PAPID, PATDAY, PAUPMJ, PAUSER, PAWAB, PAWCD, PAWMDT, PAWNUM, PAWRF FROM F31B0740

TOP920 | 31B | F31B0740 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PAEURIDEUR IdentifierNumericGeneric Edit100 Allow NULL? 
2PAMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
3PAACTIVITYActivityStringUDC (31B PA)100 Allow NULL? 
4PAPLNTYPPlan TypeCharacterUDC (31B PL)10 Allow NULL? 
5PAPBEGDTPlanning Begin DateDateGeneric Edit60
6PAPENDDTPlanning End DateDateGeneric Edit60
7PAPQA1Planning Quantity 1NumericGeneric Edit154 Allow NULL? 
8PAPQA2Planning Quantity 2NumericGeneric Edit154 Allow NULL? 
9PAPQA3Planning Quantity 3NumericGeneric Edit154 Allow NULL? 
10PAPQA4Planning Quantity 4NumericGeneric Edit154 Allow NULL? 
11PAPQA5Planning Quantity 5NumericGeneric Edit154 Allow NULL? 
12PAPQA6Planning Quantity 6NumericGeneric Edit154 Allow NULL? 
13PAPQA7Planning Quantity 7NumericGeneric Edit154 Allow NULL? 
14PAPQA8Planning Quantity 8NumericGeneric Edit154 Allow NULL? 
15PAPQA9Planning Quantity 9NumericGeneric Edit154 Allow NULL? 
16PAPQA10Planning Quantity 10NumericGeneric Edit154 Allow NULL? 
17PAPUOM1Planning UOM 1StringUDC (31B UM)20 Allow NULL? 
18PAPUOM2Planning UOM 2StringUDC (31B UM)20 Allow NULL? 
19PAPUOM3Planning UOM 3StringUDC (31B UM)20 Allow NULL? 
20PAPUOM4Planning UOM 4StringUDC (31B UM)20 Allow NULL? 
21PAPUOM5Planning UOM 5StringUDC (31B UM)20 Allow NULL? 
22PAPUOM6Planning UOM 6StringUDC (31B UM)20 Allow NULL? 
23PAPUOM7Planning UOM 7StringUDC (31B UM)20 Allow NULL? 
24PAPUOM8Planning UOM 8StringUDC (31B UM)20 Allow NULL? 
25PAPUOM9Planning UOM 9StringUDC (31B UM)20 Allow NULL? 
26PAPUOM10Planning UOM 10StringUDC (31B UM)20 Allow NULL? 
27PAPQC1Planning Quantity Code 1StringUDC (31B QC)100 Allow NULL? 
28PAPQC2Planning Quantity Code 2StringUDC (31B QC)100 Allow NULL? 
29PAPQC3Planning Quantity Code 3StringUDC (31B QC)100 Allow NULL? 
30PAPQC4Planning Quantity Code 4StringUDC (31B QC)100 Allow NULL? 
31PAPQC5Planning Quantity Code 5StringUDC (31B QC)100 Allow NULL? 
32PAPQC6Planning Quantity Code 6StringUDC (31B QC)100 Allow NULL? 
33PAPQC7Planning Quantity Code 7StringUDC (31B QC)100 Allow NULL? 
34PAPQC8Planning Quantity Code 8StringUDC (31B QC)100 Allow NULL? 
35PAPQC9Planning Quantity Code 9StringUDC (31B QC)100 Allow NULL? 
36PAPQC10Planning Quantity Code 10StringUDC (31B QC)100 Allow NULL? 
37PAURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
38PAURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
39PAURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
40PAURDTUser Reserved DateDateGeneric Edit60
41PAURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
42PAJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
43PAPIDProgram IDStringGeneric Edit100 Allow NULL? 
44PATDAYTime of DayNumericGeneric Edit60 Allow NULL? 
45PAUPMJDate - UpdatedDateGeneric Edit60
46PAUSERUser IDStringGeneric Edit100 Allow NULL? 
47PAWABBlend Mgmt NumberNumericGeneric Edit80 Allow NULL? 
48PAWCDBlend Mgmt CodeStringGeneric Edit30 Allow NULL? 
49PAWMDTBlend Mgmt DateDateGeneric Edit60
50PAWNUMBlend Mgmt NumericNumericGeneric Edit154 Allow NULL? 
51PAWRFBlend Mgmt ReferenceStringGeneric Edit300 Allow NULL? 

TOP920 | 31B | F31B0740 INDEXES

NumberDescription
1EURId Winery Activity PlanType (Primary/Unique)
ElementAliasDescriptionSequence
1EURIDEUR IdentifierAscending
2MCUBusiness UnitAscending
3ACTIVITYActivityAscending
4PLNTYPPlan TypeAscending