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

1 column | Print definition?910 | SERS | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F80D309Metric Series Cross Ref3MSSERSSeries DescriptionStringUDC40

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / SE (Series Description) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1      AAP Average PO AmountY
2      AAPOAgreement Purchase AmountY
3      ABPOBlanket Purchase AmountY
4      ACT ActualY
5      ADF Delinquency FeesY
6      ADSADiscount TakenY
7      ADSCDiscount AvailableY
8      AEXPActual Expense AmountY
9      AINCActual Income AmountY
10      AMADAmount AdjustedY
11      AMDCAmount ScrappedY
12      AMDJAmount RejectedY
13      AMDRAmount ReturnedY
14      AMDWAmount ReworkedY
15      AMPOManual Priced PO AmountY
16      AMT AmountY
17      AMTAActual AmountY
18      AMTBBudget AmountY
19      AOPOOpen Purchase AmountY
20      APAGAP Unposted AmountY
21      APDIPast Due InvoicesY
22      APRFActual Profit AmountY
23      ARAPAR Unposted AmountY
24      ATPOTotal Purchase AmountY
25      BACKBackorder Count - TotalY
26      BAK BacklogY
27      BEXPBudget Expense AmountY
28      BINCBudget Income AmountY
29      BKAABackorder Amount - AverageY
30      BKATBackorder Amount - TotalY
31      BKCABackorder Count - AverageY
32      BKCTBooked Order CountY
33      BOOKBook to Ship DaysY
34      BPRFBudget Profit AmountY
35      CAMTCash Flow AmountY
36      CASHCash to Cash DaysY
37      CCPICustomer with Past Due InvoiceY
38      CHBAChargeback AmountY
39      CMPOManual Priced PO CountY
40      CNT CountY
41      CPDIPast Due InvoicesY
42      CTPOPO CountY
43      DAYSDaysY
44      DCTADiscount Not TakenY
45      DNT Discount Not TakenY
46      DPO Days Payables OutstandingY
47      DSI Days Sales in InventoryY
48      DSO Days Sales OutstandingY
49      EAM EarnedY
50      EARL% EarlyY
51      ERLYEarlyY
52      GLP2Profit Margin PercentageY
53      GLP3Return on Assets PercentageY
54      GLP4After tax Profit PercentageY
55      GLP5Return on Net Worth PercentageY
56      GLR6Current RatioY
57      GLR7Quick Acid Test RatioY
58      GLR8Times Interest Earned RatioY
59      GLR9Debt To Total Assets RatioY
60      GLRAFixed Asset Turnover RatioY
61      GLRBInventory Turnover RatioY
62      GLRCTotal Asset Turnover RatioY
63      GOALGoalY
64      IFC In-Full CountY
65      IFP In-Full PercentY
66      INAAAverage Invoice AmountY
67      INAMInvoice AmountY
68      INCTInvoice CountY
69      ISC In-Spec CountY
70      ISP In-Spec PercentY
71      LAT LateY
72      LATE% LateY
73      LG  Lower GoalY
74      MPB Most Profitable BrandsY
75      MPC Most Profitable CustomersY
76      MPP Most Profitable ProductsY
77      OIC Open Invoiced CountY
78      ONTMOn TimeY
79      OT  % On TimeY
80      OTC On-Time CountY
81      OTP On-Time PercentY
82      OV  Open VouchersY
83      OVPDOpen Vouchers Past DueY
84      PAMTPast Due AmountY
85      PCNTPast Due CountY
86      PEL % Exceptions - LongerY
87      PES % Exceptions - ShorterY
88      PLA Paid Late AmountY
89      PLANPlannedY
90      PROJProjected RevenueY
91      PROTPercentage Receipts On TargetY
92      PVP Price Variance PercentageY
93      PYAMPayment AmountY
94      PYCTPayment CountY
95      QTYAQuantity AdjustedY
96      QTYCQuantity ScrappedY
97      QTYJQuantity RejectedY
98      QTYRQuantity ReturnedY
99      QTYSQuantity StockedY
100      QTYWQuantity ReworkedY
101      RCAMReceipt AmountY
102      RCCTReceipt CountY
103      REV Shipped Order RevenueY
104      REVARevenue AmountY
105      ROC Open Invoice AmountY
106      ROT Receipts On TargetY
107      SAA Sourcing Award AmountY
108      SADQSum Of Disposition QuantityY
109      SEC Sourcing Event CountY
110      SHPDOrders ShippedY
111      TEL Total Exceptions - LongerY
112      TES Total Exceptions - ShorterY
113      TF  Total FailedY
114      TOTLTotalY
115      TPVAPrice Variance AmountY
116      TR  Total ReceivedY
117      TURNNumber of TurnsY
118      UEAMUnearnedY
119      UG  Upper GoalY
120      VAL Booked Order ValueY
121      VARN% VarianceY
122      VARTVariance Lines CountY
123      VCAMVoucher AmountY
124      VCCTVoucher CountY