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

57 COLUMNS | 1 INDEXES | Print definition?812 | 81A | F81A14 TABLE

81A: DREAMWriter Conversion Tool
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F81A14M6571DreamWriter Selection Values Interim TableFiles81A: DREAMWriter Conversion Tool
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 M6LDFR, M6PID, M6VERS, M6SQN, M6FLDN, M6FPID, M6BVER, M6VL01, M6VL02, M6VL03, M6VL04, M6VL05, M6VL06, M6VL07, M6VL08, M6VL09, M6VL10, M6VL11, M6VL12, M6VL13, M6VL14, M6VL15, M6VL16, M6VL17, M6VL18, M6VL19, M6VL20, M6VL21, M6VL22, M6VL23, M6VL24, M6VL25, M6VL26, M6VL27, M6VL28, M6VL29, M6VL30, M6VL31, M6VL32, M6VL33, M6VL34, M6VL35, M6VL36, M6VL37, M6VL38, M6VL39, M6VL40, M6VL41, M6VL42, M6VL43, M6VL44, M6VL45, M6LUS, M6FPD, M6UPMJ, M6JOBN, M6UPMT FROM F81A14

TOP812 | 81A | F81A14 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1M6LDFRLibrary Name - Data - FromStringGeneric Edit100 Allow NULL? 
2M6PIDProgram IDStringGeneric Edit100 Allow NULL? 
3M6VERSVersion HistoryStringGeneric Edit100 Allow NULL? 
4M6SQNOption Prompt LineNumericGeneric Edit30 Allow NULL? 
5M6FLDNData Field NameStringGeneric Edit60 Allow NULL? 
6M6FPIDEnterpriseOne Program IDStringGeneric Edit100 Allow NULL? 
7M6BVEREnterpriseOne VersionStringGeneric Edit100 Allow NULL? 
8M6VL01Selection Values 01StringGeneric Edit250 Allow NULL? 
9M6VL02Selection Values 02StringGeneric Edit250 Allow NULL? 
10M6VL03Selection Values 03StringGeneric Edit250 Allow NULL? 
11M6VL04Selection Values 04StringGeneric Edit250 Allow NULL? 
12M6VL05Selection Values 05StringGeneric Edit250 Allow NULL? 
13M6VL06Selection Values 06StringGeneric Edit250 Allow NULL? 
14M6VL07Selection Values 07StringGeneric Edit250 Allow NULL? 
15M6VL08Selection Values 08StringGeneric Edit250 Allow NULL? 
16M6VL09Selection Values 09StringGeneric Edit250 Allow NULL? 
17M6VL10Selection Values 10StringGeneric Edit250 Allow NULL? 
18M6VL11Selection Values 11StringGeneric Edit250 Allow NULL? 
19M6VL12Selection Values 12StringGeneric Edit250 Allow NULL? 
20M6VL13Selection Values 13StringGeneric Edit250 Allow NULL? 
21M6VL14Selection Values 14StringGeneric Edit250 Allow NULL? 
22M6VL15Selection Values 15StringGeneric Edit250 Allow NULL? 
23M6VL16Selection Values 16StringGeneric Edit250 Allow NULL? 
24M6VL17Selection Values 17StringGeneric Edit250 Allow NULL? 
25M6VL18Selection Values 18StringGeneric Edit250 Allow NULL? 
26M6VL19Selection Values 19StringGeneric Edit250 Allow NULL? 
27M6VL20Selection Values 20StringGeneric Edit250 Allow NULL? 
28M6VL21Selection Values 21StringGeneric Edit250 Allow NULL? 
29M6VL22Selection Values 22StringGeneric Edit250 Allow NULL? 
30M6VL23Selection Values 23StringGeneric Edit250 Allow NULL? 
31M6VL24Selection Values 24StringGeneric Edit250 Allow NULL? 
32M6VL25Selection Values 25StringGeneric Edit250 Allow NULL? 
33M6VL26Selection Values 26StringGeneric Edit250 Allow NULL? 
34M6VL27Selection Values 27StringGeneric Edit250 Allow NULL? 
35M6VL28Selection Values 28StringGeneric Edit250 Allow NULL? 
36M6VL29Selection Values 29StringGeneric Edit250 Allow NULL? 
37M6VL30Selection Values 30StringGeneric Edit250 Allow NULL? 
38M6VL31Selection Values 31StringGeneric Edit250 Allow NULL? 
39M6VL32Selection Values 32StringGeneric Edit250 Allow NULL? 
40M6VL33Selection Values 33StringGeneric Edit250 Allow NULL? 
41M6VL34Selection Values 34StringGeneric Edit250 Allow NULL? 
42M6VL35Selection Values 35StringGeneric Edit250 Allow NULL? 
43M6VL36Selection Values 36StringGeneric Edit250 Allow NULL? 
44M6VL37Selection Values 37StringGeneric Edit250 Allow NULL? 
45M6VL38Selection Values 38StringGeneric Edit250 Allow NULL? 
46M6VL39Selection Values 39StringGeneric Edit250 Allow NULL? 
47M6VL40Selection Values 40StringGeneric Edit250 Allow NULL? 
48M6VL41Selection Values 41StringGeneric Edit250 Allow NULL? 
49M6VL42Selection Values 42StringGeneric Edit250 Allow NULL? 
50M6VL43Selection Values 43StringGeneric Edit250 Allow NULL? 
51M6VL44Selection Values 44StringGeneric Edit250 Allow NULL? 
52M6VL45Selection Values 45StringGeneric Edit250 Allow NULL? 
53M6LUSUser MigrationStringGeneric Edit100 Allow NULL? 
54M6FPDProgram ID - Migration ProcessStringGeneric Edit100 Allow NULL? 
55M6UPMJDate - UpdatedDateGeneric Edit60
56M6JOBNWork Station IDStringGeneric Edit100 Allow NULL? 
57M6UPMTTime - Last UpdatedNumericGeneric Edit60 Allow NULL? 

TOP812 | 81A | F81A14 INDEXES

NumberDescription
1Key1 (Primary/Unique)
ElementAliasDescriptionSequence
1LDFRLibrary Name - Data - FromAscending
2PIDProgram IDAscending
3VERSVersion HistoryAscending
4SQNOption Prompt LineAscending