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

3 columns | Print definition?920 | METRIC | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F80D307Metric Action Cross Reference2HDMETRICMetric IDNumericUDC40
2F80D309Metric Series Cross Ref1MSMETRICMetric IDNumericUDC40
3F80D322UI Metric Group Detail3MDMETRICMetric IDNumericUDC40

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

TOPUDC 00 / MI (Metrics Identifier) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1      2000Days Sales Outstanding Y
2      2010Days Payables Outstanding Y
3      2020Cash to Cash Cycle Time Y
4      2100OnTime Shipment Cust Request Y
5      2110OnTime Shipment Promised Y
6      2111OnTime Shipment Promised Sum Y
7      2120Past Due Count Y
8      2121Past Due Amount Y
9      2130BackOrder Count Y
10      2131BackOrder Amount Y
11      2140Promise to Request Variance Y
12      2150Book to Ship Days Y
13      2200Days Sales in Inventory Y
14      2201Inventory Turns Y
15      2300On Time Production Completions Y
16      2310Actual Production versus Plan Y
17      2400Booked Order Value Y
18      2410Shipped Order Revenue Y
19      2411Revenue Trend by Brand 1 Y
20      2412Revenue Trend by Brand 2 Y
21      2413Revenue Trend by Branch 1 Y
22      2414Revenue Trend by Branch 2 Y
23      2415Revenue Trend by Product 1 Y
24      2416Revenue Trend by Product 2 Y
25      2420Projected Revenue Y
26      2430Backlog Y
27      2500Supplier On Time Delivery Y
28      2510Material Lead Time Exceptions Y
29      2520Pass Quality Y
30      3301AR Invoice and Receipt Amounts Y
31      3302AR Average Invoice Amounts Y
32      3303AR Invoice and Receipt counts Y
33      3305AR Open Chargeback Y
34      3306AR Open Chrgbck by Reason Cd Y
35      3307AR Total Chargeback Y
36      3308AR Total Chrgbck by Reason Cd Y
37      3309AR Delinquency Amounts Y
38      3310AR Delinquency Counts Y
39      3311AR Open Invoice Amount Y
40      3312AR Open Invoice Count Y
41      3313AR Discount Amount Y
42      3314AR Discount Percentage Y
43      3315DSO by Company Y
44      3316DSO by Customer Y
45      3344Unposted Trans Inc and Exp Y
46      3400AP Discount Amount Y
47      3401AP Discount Percentage Y
48      3402AP Open Voucher Amount Y
49      3403AP Open Voucher Count Y
50      3404AP Vouchers Paid Late Amount Y
51      3405AP Vouchers Paid Late Count Y
52      3406AP Voucher and Payment Amounts Y
53      3407AP Voucher and Payment Counts Y
54      3501Forecasted Cash Flow2Y
55      3502Profit Margin On Sales2Y
56      3503Return On Total Assets2Y
57      3504After tax Profit On Sales2Y
58      3505Return On Net Worth2Y
59      3506Current Ratio2Y
60      3507Quick Acid Test2Y
61      3508Times Interest Earned2Y
62      3509Debt To Total Assets2Y
63      3510Fixed Asset turnover2Y
64      3511Inventory Turnover2Y
65      3512Total Asset Turnover2Y
66      3513Operating Income Y
67      3514Operating Expense Y
68      3515Operating Profit Y
69      3516Most Profitable Brands Y
70      3517Most Profitable Customers Y
71      3518Most Profitable Products Y
72      5501Open Purchase Amount - Date Y
73      5502Open Purchase Amount-Commodity Y
74      5503Open Purchase Amount-Supplier Y
75      5504PO Count - Date Y
76      5505PO Count - Supplier Y
77      5506Average PO Amt - Date Y
78      5507Average PO Amt-Supp Y
79      5508Total Purchase Amount-Date Y
80      5509Total Purchase Amt-Supplier Y
81      5510Total Purchase Amt-LineType Y
82      5511Total Purchase Amt-Commodity Y
83      5521Blanket Purchase Amt-Date Y
84      5522Blanket Purchase Amount-Cmdty Y
85      5523Blanket Purchase Amt-Supplier Y
86      5524Agreement Purchase Amt-Date Y
87      5525Agreement Purchase Amt-Cmdty Y
88      5526Agreement Purchase Amt-Supp Y
89      5527Manual Priced PO Amount-Date Y
90      5528Manual Priced PO Amt-Cmdty Y
91      5529Manual Priced PO Amt-Supplier Y
92      5530Manual Priced PO Count-Date Y
93      5531Manual Priced PO Count-Cmdty Y
94      5532Manual Priced PO Count-Supp Y
95      5541Mtrl LeadTime Exc Count-Supp Y
96      5542Mtrl LeadTime Exc Percent-Supp Y
97      5561Disposition Quantity-Date Y
98      5562Disposition Quantity-Commodity Y
99      5563Disposition Quantity-Supplier Y
100      5564Disposition Amount-Date Y
101      5565Disposition Amount-Commodity Y
102      5566Disposition Amount-Supplier Y
103      5567Stock/Disposition Qty-Date Y
104      5568Stock/Disposition Qty-Cmdty Y
105      5569Stock/Disposition Qty-Supplier Y
106      5581In-Full Count-Supplier Y
107      5582In-Full Percent-Supplier Y
108      5583In-Spec Count-Supplier Y
109      5584In-Spec Percent-Supplier Y
110      5585On-Time Count-Supplier Y
111      5586On-Time Percent-Supplier Y
112      5601Price Variance Amt-Date Y
113      5602Price Variance Amt-Commodity Y
114      5603Price Variance Amt-Supplier Y
115      5604Price Variance Percent-Date Y
116      5605Price Variance Percent-Cmdty Y
117      5606Price Variance Percent-Supp Y
118      5621Sourcing Event Count-Date Y
119      5622Sourcing Event Count-Commodity Y
120      5623Sourcing Event Count-Supplier Y
121      5624Sourcing Award Amount-Date Y
122      5625Sourcing Award Amount-Cmdty Y
123      5626Sourcing Award Amount-Supplier Y
124      8000Metric Ids 8000 - 8999 N