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

55 columns | Print definition?812 | TXID

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP37: Quality Management
1F40318Preference Profile - Quality Management11QCTXIDText ID NumberNumericGeneric Edit80
TOP40: Inventory/OP Base
2F40301Preference Profile - Payment Terms10PTTXIDText ID NumberNumericGeneric Edit80
3F40301RPreference Resolution Ledger - Payment Terms12PTTXIDText ID NumberNumericGeneric Edit80
4F40302Preference Profile - Unit of Measure10PUTXIDText ID NumberNumericGeneric Edit80
5F40302RPreference Resolution Ledger - Pricing Unit Of Measure12PUTXIDText ID NumberNumericGeneric Edit80
6F40303Preference Profile - Revenue Cost Center10RVTXIDText ID NumberNumericGeneric Edit80
7F40303RPreference Resolution Ledger - Revenue Business Unit12RVTXIDText ID NumberNumericGeneric Edit80
8F40304Preference Profile - End Use10PETXIDText ID NumberNumericGeneric Edit80
9F40304RPreference Resolution Ledger - End Use12PETXIDText ID NumberNumericGeneric Edit80
10F40305Preference Profile - Print Messages10RMTXIDText ID NumberNumericGeneric Edit80
11F40305RPreference Resolution Ledger - Print Messages12RMTXIDText ID NumberNumericGeneric Edit80
12F40306Preference Profile - Inventory Sourcing10SRTXIDText ID NumberNumericGeneric Edit80
13F40307Preference Profile - Product Allocations10LATXIDText ID NumberNumericGeneric Edit80
14F40308Preference Profile - Grade and Potency10GSTXIDText ID NumberNumericGeneric Edit80
15F40308RPreference Resolution Ledger - Grade and Potency12GSTXIDText ID NumberNumericGeneric Edit80
16F40309Preference Profile - Delivery Date10DYTXIDText ID NumberNumericGeneric Edit80
17F40309RPreference Resolution Ledger - Delivery Date12DYTXIDText ID NumberNumericGeneric Edit80
18F40310Preference Profile - Line of Business10LBTXIDText ID NumberNumericGeneric Edit80
19F40310RPreference Resolution Ledger - Line Of Business12LBTXIDText ID NumberNumericGeneric Edit80
20F40311Preference Profile - Price Code 110P1TXIDText ID NumberNumericGeneric Edit80
21F40311RPreference Resolution Ledger - User Defined Price Code #112P1TXIDText ID NumberNumericGeneric Edit80
22F40312Preference Profile - Price Code 210P2TXIDText ID NumberNumericGeneric Edit80
23F40312RPreference Resolution Ledger - User Defined Price Code #212P2TXIDText ID NumberNumericGeneric Edit80
24F40313Preference Profile - Price Code 310P3TXIDText ID NumberNumericGeneric Edit80
25F40313RPreference Resolution Ledger - User Defined Price Code #312P3TXIDText ID NumberNumericGeneric Edit80
26F40314Preference Profile - Price Adjustment Schedule10PJTXIDText ID NumberNumericGeneric Edit80
27F40314RPreference Resolution Ledger - Price Adjustment Schedule12PJTXIDText ID NumberNumericGeneric Edit80
28F40315Preference Profile - Invoice Cycling10PITXIDText ID NumberNumericGeneric Edit80
29F40315RPreference Resolution Ledger - Invoice Cycle12PITXIDText ID NumberNumericGeneric Edit80
30F40316Preference Profile - Order Preparation10OPTXIDText ID NumberNumericGeneric Edit80
31F40316RPreference Resolution Ledger - Order Preparation Days12OPTXIDText ID NumberNumericGeneric Edit80
32F40318RPreference Resolution Ledger - Quality Management13QCTXIDText ID NumberNumericGeneric Edit80
33F40320Preference Profile - Multi Shipping/Receiving Locations10LPTXIDText ID NumberNumericGeneric Edit80
34F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations11LPTXIDText ID NumberNumericGeneric Edit80
35F40329Preference Profile - Document Distribution10DDTXIDText ID NumberNumericGeneric Edit80
36F40330Preference Profile - Document Set10DGTXIDText ID NumberNumericGeneric Edit80
37F40331Preference Profile - Options and Equipment10OETXIDText ID NumberNumericGeneric Edit80
38F40332Preference Profile - Customer Freight10CFTXIDText ID NumberNumericGeneric Edit80
39F40333Preference Profile - Carrier10CATXIDText ID NumberNumericGeneric Edit80
40F40334Preference Profile - Mode of Transport10MTTXIDText ID NumberNumericGeneric Edit80
41F40338Preference Profile - Payment Terms (Branch)10PTTXIDText ID NumberNumericGeneric Edit80
42F40338RPreference Resolution Ledger - Payment Terms (Branch)12PTTXIDText ID NumberNumericGeneric Edit80
43F40339Preference Profile - Product Allocations (Branch)10LATXIDText ID NumberNumericGeneric Edit80
44F40341Preference Profile - Next Order Status10NSTXIDText ID NumberNumericGeneric Edit80
45F40341RPreference Resolution Ledger - Next Order Status12NSTXIDText ID NumberNumericGeneric Edit80
46F40344Preference Profile - Sales Commission10SATXIDText ID NumberNumericGeneric Edit80
47F40344RPreference Resolution Ledger - Sales Commission12SATXIDText ID NumberNumericGeneric Edit80
48F40345Preference Profile - Customer Currency10CRTXIDText ID NumberNumericGeneric Edit80
49F40345RPreference Resolution Ledger - Customer Currency12CRTXIDText ID NumberNumericGeneric Edit80
50F40347Preference Profile - Pricing UOM (Branch)10RITXIDText ID NumberNumericGeneric Edit80
51F40347RPreference Resolution Ledger - Pricing UOM (Branch)12RITXIDText ID NumberNumericGeneric Edit80
52F40349Preference Profile - Revenue Business Unit (Branch)10RVTXIDText ID NumberNumericGeneric Edit80
53F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)12RVTXIDText ID NumberNumericGeneric Edit80
54F40350Preference Profiles - Conatiner Deposit/Rental10OQTXIDText ID NumberNumericGeneric Edit80
TOP89: Conversion Programs
55F40344ATemporay Preference Profile - Sales Commission10SATXIDText ID NumberNumericGeneric Edit80