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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail 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

66 columns | Print definition?812 | MNQ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP37: Quality Management
1F40318Preference Profile - Quality Management7QCMNQQuantity - FromNumericGeneric Edit152
TOP40: Inventory/OP Base
2F40301Preference Profile - Payment Terms7PTMNQQuantity - FromNumericGeneric Edit152
3F40301RPreference Resolution Ledger - Payment Terms9PTMNQQuantity - FromNumericGeneric Edit152
4F40302Preference Profile - Unit of Measure7PUMNQQuantity - FromNumericGeneric Edit152
5F40302RPreference Resolution Ledger - Pricing Unit Of Measure9PUMNQQuantity - FromNumericGeneric Edit152
6F40303Preference Profile - Revenue Cost Center7RVMNQQuantity - FromNumericGeneric Edit152
7F40303RPreference Resolution Ledger - Revenue Business Unit9RVMNQQuantity - FromNumericGeneric Edit152
8F40304Preference Profile - End Use7PEMNQQuantity - FromNumericGeneric Edit152
9F40304RPreference Resolution Ledger - End Use9PEMNQQuantity - FromNumericGeneric Edit152
10F40305Preference Profile - Print Messages7RMMNQQuantity - FromNumericGeneric Edit152
11F40305RPreference Resolution Ledger - Print Messages9RMMNQQuantity - FromNumericGeneric Edit152
12F40306Preference Profile - Inventory Sourcing7SRMNQQuantity - FromNumericGeneric Edit152
13F40307Preference Profile - Product Allocations7LAMNQQuantity - FromNumericGeneric Edit152
14F40308Preference Profile - Grade and Potency7GSMNQQuantity - FromNumericGeneric Edit152
15F40308RPreference Resolution Ledger - Grade and Potency9GSMNQQuantity - FromNumericGeneric Edit152
16F40309Preference Profile - Delivery Date7DYMNQQuantity - FromNumericGeneric Edit152
17F40309RPreference Resolution Ledger - Delivery Date9DYMNQQuantity - FromNumericGeneric Edit152
18F40310Preference Profile - Line of Business7LBMNQQuantity - FromNumericGeneric Edit152
19F40310RPreference Resolution Ledger - Line Of Business9LBMNQQuantity - FromNumericGeneric Edit152
20F40311Preference Profile - Price Code 17P1MNQQuantity - FromNumericGeneric Edit152
21F40311RPreference Resolution Ledger - User Defined Price Code #19P1MNQQuantity - FromNumericGeneric Edit152
22F40312Preference Profile - Price Code 27P2MNQQuantity - FromNumericGeneric Edit152
23F40312RPreference Resolution Ledger - User Defined Price Code #29P2MNQQuantity - FromNumericGeneric Edit152
24F40313Preference Profile - Price Code 37P3MNQQuantity - FromNumericGeneric Edit152
25F40313RPreference Resolution Ledger - User Defined Price Code #39P3MNQQuantity - FromNumericGeneric Edit152
26F40314Preference Profile - Price Adjustment Schedule7PJMNQQuantity - FromNumericGeneric Edit152
27F40314RPreference Resolution Ledger - Price Adjustment Schedule9PJMNQQuantity - FromNumericGeneric Edit152
28F40315Preference Profile - Invoice Cycling7PIMNQQuantity - FromNumericGeneric Edit152
29F40315RPreference Resolution Ledger - Invoice Cycle9PIMNQQuantity - FromNumericGeneric Edit152
30F40316Preference Profile - Order Preparation7OPMNQQuantity - FromNumericGeneric Edit152
31F40316RPreference Resolution Ledger - Order Preparation Days9OPMNQQuantity - FromNumericGeneric Edit152
32F40318RPreference Resolution Ledger - Quality Management9QCMNQQuantity - FromNumericGeneric Edit152
33F40320Preference Profile - Multi Shipping/Receiving Locations7LPMNQQuantity - FromNumericGeneric Edit152
34F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations8LPMNQQuantity - FromNumericGeneric Edit152
35F40329Preference Profile - Document Distribution7DDMNQQuantity - FromNumericGeneric Edit152
36F40330Preference Profile - Document Set7DGMNQQuantity - FromNumericGeneric Edit152
37F40331Preference Profile - Options and Equipment7OEMNQQuantity - FromNumericGeneric Edit152
38F40332Preference Profile - Customer Freight7CFMNQQuantity - FromNumericGeneric Edit152
39F40333Preference Profile - Carrier7CAMNQQuantity - FromNumericGeneric Edit152
40F40334Preference Profile - Mode of Transport7MTMNQQuantity - FromNumericGeneric Edit152
41F40338Preference Profile - Payment Terms (Branch)7PTMNQQuantity - FromNumericGeneric Edit152
42F40338RPreference Resolution Ledger - Payment Terms (Branch)9PTMNQQuantity - FromNumericGeneric Edit152
43F40339Preference Profile - Product Allocations (Branch)7LAMNQQuantity - FromNumericGeneric Edit152
44F40341Preference Profile - Next Order Status7NSMNQQuantity - FromNumericGeneric Edit152
45F40341RPreference Resolution Ledger - Next Order Status9NSMNQQuantity - FromNumericGeneric Edit152
46F40344Preference Profile - Sales Commission7SAMNQQuantity - FromNumericGeneric Edit152
47F40344RPreference Resolution Ledger - Sales Commission9SAMNQQuantity - FromNumericGeneric Edit152
48F40345Preference Profile - Customer Currency7CRMNQQuantity - FromNumericGeneric Edit152
49F40345RPreference Resolution Ledger - Customer Currency9CRMNQQuantity - FromNumericGeneric Edit152
50F40347Preference Profile - Pricing UOM (Branch)7RIMNQQuantity - FromNumericGeneric Edit152
51F40347RPreference Resolution Ledger - Pricing UOM (Branch)9RIMNQQuantity - FromNumericGeneric Edit152
52F40349Preference Profile - Revenue Business Unit (Branch)7RVMNQQuantity - FromNumericGeneric Edit152
53F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)9RVMNQQuantity - FromNumericGeneric Edit152
54F40350Preference Profiles - Conatiner Deposit/Rental7OQMNQQuantity - FromNumericGeneric Edit152
55F40UI17Allocation Work File17ZGMNQQuantity - FromNumericGeneric Edit152
56F40UI74Price Adjustment History Work File23AWMNQQuantity - FromNumericGeneric Edit152
TOP42: Sales Management
57F4074Price Adjustment Ledger File17ALMNQQuantity - FromNumericGeneric Edit152
TOP45: Advanced Pricing
58F4072Price Adjustment Detail11ADMNQQuantity - FromNumericGeneric Edit152
59F4072WPrice Adjustment Detail Work File11ADMNQQuantity - FromNumericGeneric Edit152
60F4511WPricing Structure View47APMNQQuantity - FromNumericGeneric Edit152
61F4574Key Reference Table64KRMNQQuantity - FromNumericGeneric Edit152
62F4575Ship and Debit History22AHMNQQuantity - FromNumericGeneric Edit152
63F4575TMPShip and Debit History - Temp Table22AHMNQQuantity - FromNumericGeneric Edit152
64F4576Z1Ship and Debit Claims Unedited Transaction Table108Z1MNQQuantity - FromNumericGeneric Edit152
TOP89: Conversion Programs
65F40344ATemporay Preference Profile - Sales Commission7SAMNQQuantity - FromNumericGeneric Edit152
66F4072TEMPrice Adjustment Detail - Temp for Upgrade13ADMNQQuantity - FromNumericGeneric Edit152