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

183 columns | Print definition?910 | EFTJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F4008Tax Areas14TAEFTJDate - EffectiveDateGeneric Edit60
TOP01: Address Book
2F01505Tier Descriptions5TDEFTJDate - EffectiveDateGeneric Edit60
TOP04: Accounts Payable
3F04572A/P Payment Processing - Summary48KKEFTJDate - EffectiveDateGeneric Edit60
4F04573A/P Payment Processing - Detail18KIEFTJDate - EffectiveDateGeneric Edit60
TOP09E: Expense Reimbursment
5F09E108Policy Edit Rules5PREFTJDate - EffectiveDateGeneric Edit60
6F09E118Expense Category / Report Type to Pay Type Mapping3PMEFTJDate - EffectiveDateGeneric Edit60
7F20103Employee Profile Definition10EPEFTJDate - EffectiveDateGeneric Edit60
TOP17C: Call Management
8F1755Case Master203ZAEFTJDate - EffectiveDateGeneric Edit60
9F1760Time Entry82ZBEFTJDate - EffectiveDateGeneric Edit60
TOP37: Quality Management
10F37014Test Result Conversions4RCEFTJDate - EffectiveDateGeneric Edit60
11F37015Test Result Conversion Tables5CTEFTJDate - EffectiveDateGeneric Edit60
12F40318Preference Profile - Quality Management5QCEFTJDate - EffectiveDateGeneric Edit60
TOP38: Agreement Management
13F38010Agreement Master16DNEFTJDate - EffectiveDateGeneric Edit60
14F38011Agreement Quantities14DFEFTJDate - EffectiveDateGeneric Edit60
15F38012Product Source/Destination Master19DPEFTJDate - EffectiveDateGeneric Edit60
16F38013Agreement Quantities Schedule6DQEFTJDate - EffectiveDateGeneric Edit60
17F38014Agreement Formulas and Factors23DREFTJDate - EffectiveDateGeneric Edit60
TOP40: Inventory/OP Base
18F4015Order Templates11OTEFTJDate - EffectiveDateGeneric Edit60
19F4016Print Messages3TUEFTJDate - EffectiveDateGeneric Edit60
20F40301Preference Profile - Payment Terms5PTEFTJDate - EffectiveDateGeneric Edit60
21F40301RPreference Resolution Ledger - Payment Terms7PTEFTJDate - EffectiveDateGeneric Edit60
22F40302Preference Profile - Unit of Measure5PUEFTJDate - EffectiveDateGeneric Edit60
23F40302RPreference Resolution Ledger - Pricing Unit Of Measure7PUEFTJDate - EffectiveDateGeneric Edit60
24F40303Preference Profile - Revenue Cost Center5RVEFTJDate - EffectiveDateGeneric Edit60
25F40303RPreference Resolution Ledger - Revenue Business Unit7RVEFTJDate - EffectiveDateGeneric Edit60
26F40304Preference Profile - End Use5PEEFTJDate - EffectiveDateGeneric Edit60
27F40304RPreference Resolution Ledger - End Use7PEEFTJDate - EffectiveDateGeneric Edit60
28F40305Preference Profile - Print Messages5RMEFTJDate - EffectiveDateGeneric Edit60
29F40305RPreference Resolution Ledger - Print Messages7RMEFTJDate - EffectiveDateGeneric Edit60
30F40306Preference Profile - Inventory Sourcing5SREFTJDate - EffectiveDateGeneric Edit60
31F40307Preference Profile - Product Allocations5LAEFTJDate - EffectiveDateGeneric Edit60
32F40308Preference Profile - Grade and Potency5GSEFTJDate - EffectiveDateGeneric Edit60
33F40308RPreference Resolution Ledger - Grade and Potency7GSEFTJDate - EffectiveDateGeneric Edit60
34F40309Preference Profile - Delivery Date5DYEFTJDate - EffectiveDateGeneric Edit60
35F40309RPreference Resolution Ledger - Delivery Date7DYEFTJDate - EffectiveDateGeneric Edit60
36F40310Preference Profile - Line of Business5LBEFTJDate - EffectiveDateGeneric Edit60
37F40310RPreference Resolution Ledger - Line Of Business7LBEFTJDate - EffectiveDateGeneric Edit60
38F40311Preference Profile - Price Code 15P1EFTJDate - EffectiveDateGeneric Edit60
39F40311RPreference Resolution Ledger - User Defined Price Code #17P1EFTJDate - EffectiveDateGeneric Edit60
40F40312Preference Profile - Price Code 25P2EFTJDate - EffectiveDateGeneric Edit60
41F40312RPreference Resolution Ledger - User Defined Price Code #27P2EFTJDate - EffectiveDateGeneric Edit60
42F40313Preference Profile - Price Code 35P3EFTJDate - EffectiveDateGeneric Edit60
43F40313RPreference Resolution Ledger - User Defined Price Code #37P3EFTJDate - EffectiveDateGeneric Edit60
44F40314Preference Profile - Price Adjustment Schedule5PJEFTJDate - EffectiveDateGeneric Edit60
45F40314RPreference Resolution Ledger - Price Adjustment Schedule7PJEFTJDate - EffectiveDateGeneric Edit60
46F40315Preference Profile - Invoice Cycling5PIEFTJDate - EffectiveDateGeneric Edit60
47F40315RPreference Resolution Ledger - Invoice Cycle7PIEFTJDate - EffectiveDateGeneric Edit60
48F40316Preference Profile - Order Preparation5OPEFTJDate - EffectiveDateGeneric Edit60
49F40316RPreference Resolution Ledger - Order Preparation Days7OPEFTJDate - EffectiveDateGeneric Edit60
50F40318RPreference Resolution Ledger - Quality Management7QCEFTJDate - EffectiveDateGeneric Edit60
51F40320Preference Profile - Multi Shipping/Receiving Locations5LPEFTJDate - EffectiveDateGeneric Edit60
52F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations6LPEFTJDate - EffectiveDateGeneric Edit60
53F40329Preference Profile - Document Distribution5DDEFTJDate - EffectiveDateGeneric Edit60
54F40330Preference Profile - Document Set5DGEFTJDate - EffectiveDateGeneric Edit60
55F40331Preference Profile - Options and Equipment5OEEFTJDate - EffectiveDateGeneric Edit60
56F40332Preference Profile - Customer Freight5CFEFTJDate - EffectiveDateGeneric Edit60
57F40333Preference Profile - Carrier5CAEFTJDate - EffectiveDateGeneric Edit60
58F40334Preference Profile - Mode of Transport5MTEFTJDate - EffectiveDateGeneric Edit60
59F40338Preference Profile - Payment Terms (Branch)5PTEFTJDate - EffectiveDateGeneric Edit60
60F40338RPreference Resolution Ledger - Payment Terms (Branch)7PTEFTJDate - EffectiveDateGeneric Edit60
61F40339Preference Profile - Product Allocations (Branch)5LAEFTJDate - EffectiveDateGeneric Edit60
62F40341Preference Profile - Next Order Status5NSEFTJDate - EffectiveDateGeneric Edit60
63F40341RPreference Resolution Ledger - Next Order Status7NSEFTJDate - EffectiveDateGeneric Edit60
64F40344Preference Profile - Sales Commission5SAEFTJDate - EffectiveDateGeneric Edit60
65F40344RPreference Resolution Ledger - Sales Commission7SAEFTJDate - EffectiveDateGeneric Edit60
66F40345Preference Profile - Customer Currency5CREFTJDate - EffectiveDateGeneric Edit60
67F40345RPreference Resolution Ledger - Customer Currency7CREFTJDate - EffectiveDateGeneric Edit60
68F40347Preference Profile - Pricing UOM (Branch)5RIEFTJDate - EffectiveDateGeneric Edit60
69F40347RPreference Resolution Ledger - Pricing UOM (Branch)7RIEFTJDate - EffectiveDateGeneric Edit60
70F40349Preference Profile - Revenue Business Unit (Branch)5RVEFTJDate - EffectiveDateGeneric Edit60
71F40349RPreference Resolution Ledger - Revenue Bus Unit (Branch)7RVEFTJDate - EffectiveDateGeneric Edit60
72F40350Preference Profiles - Conatiner Deposit/Rental5OQEFTJDate - EffectiveDateGeneric Edit60
73F40P01Promotion Header File6PHEFTJDate - EffectiveDateGeneric Edit60
74F40P011Promotion Deal Detail File23PDEFTJDate - EffectiveDateGeneric Edit60
75F40UI002Supplier History Rebuild -workfile11UTEFTJDate - EffectiveDateGeneric Edit60
76F40UI17Allocation Work File15ZGEFTJDate - EffectiveDateGeneric Edit60
77F4104Item Cross Reference File5IVEFTJDate - EffectiveDateGeneric Edit60
78F4106Item Base Price File14BPEFTJDate - EffectiveDateGeneric Edit60
79F4106NCBase Price Extraction20SZEFTJDate - EffectiveDateGeneric Edit60
80F49085Scheduled Invoice Date3IDEFTJDate - EffectiveDateGeneric Edit60
TOP41F: Apparel Management
81FCW11Item Base Price File Work File13WPEFTJDate - EffectiveDateGeneric Edit60
82FCW16Work File F40165WFEFTJDate - EffectiveDateGeneric Edit60
83FCW33Price List Header10PHEFTJDate - EffectiveDateGeneric Edit60
84FCW70Supplier Price/Catalog File - Header6CBEFTJDate - EffectiveDateGeneric Edit60
85FCW71Supplier Price/Catalog File - Detail28CBEFTJDate - EffectiveDateGeneric Edit60
86FCW93Copy to Outsource Operations for Style Items13STEFTJDate - EffectiveDateGeneric Edit60
TOP42: Sales Management
87F4020Freight/Additional Charges Rate Information13AREFTJDate - EffectiveDateGeneric Edit60
88F42430Customer Set3CSEFTJDate - EffectiveDateGeneric Edit60
TOP42B: Sales Order Entry
89F42440Customer Segment Items9CSEFTJDate - EffectiveDateGeneric Edit60
90F42UI440Customer Segment Items - Work File10CSEFTJDate - EffectiveDateGeneric Edit60
TOP42W: Fulfillment Management
91F4277760Service Level Rule Setup7SREFTJDate - EffectiveDateGeneric Edit60
TOP43: Procurement
92F41061Supplier Price/Catalog File17CBEFTJDate - EffectiveDateGeneric Edit60
93F4340Purchase Rebate Master File5RDEFTJDate - EffectiveDateGeneric Edit60
TOP45: Advanced Pricing
94F4070Price Adjustment Schedule10SNEFTJDate - EffectiveDateGeneric Edit60
95F4070PPrice Adjustment Schedule Purge11SNEFTJDate - EffectiveDateGeneric Edit60
96F4072Price Adjustment Detail12ADEFTJDate - EffectiveDateGeneric Edit60
97F4072PPrice Adjustment Detail Purge13ADEFTJDate - EffectiveDateGeneric Edit60
98F4072WPrice Adjustment Detail Work File12ADEFTJDate - EffectiveDateGeneric Edit60
99F4075Price Variable Table5VBEFTJDate - EffectiveDateGeneric Edit60
100F4077Rebate Thresholds8RTEFTJDate - EffectiveDateGeneric Edit60
101F4077PRebate Thresholds Purge9RTEFTJDate - EffectiveDateGeneric Edit60
102F4078Rebate Transaction Summary8RHEFTJDate - EffectiveDateGeneric Edit60
103F4079Rebate Transaction Detail7SVEFTJDate - EffectiveDateGeneric Edit60
104F4501Master Schedule Adjustment5MSEFTJDate - EffectiveDateGeneric Edit60
105F4502Free Goods Catalog3FGEFTJDate - EffectiveDateGeneric Edit60
106F4511WPricing Structure View49APEFTJDate - EffectiveDateGeneric Edit60
107F4551Basket Master Detail4BDEFTJDate - EffectiveDateGeneric Edit60
108F45520Price List Header7PHEFTJDate - EffectiveDateGeneric Edit60
109F45521Price List Detail4PDEFTJDate - EffectiveDateGeneric Edit60
110F45715Adjustment Balances10ABEFTJDate - EffectiveDateGeneric Edit60
111F4572Live Promotions X-Reference by Cost Type7XREFTJDate - EffectiveDateGeneric Edit60
112F4572Z1Live Promotions Interface - Inbound / Outbound21LPEFTJDate - EffectiveDateGeneric Edit60
113F4572ZPPurge Live Promotions Interface21PGEFTJDate - EffectiveDateGeneric Edit60
114F4574Key Reference Table18KREFTJDate - EffectiveDateGeneric Edit60
115F4575Ship and Debit History39AHEFTJDate - EffectiveDateGeneric Edit60
116F4575TMPShip and Debit History - Temp Table39AHEFTJDate - EffectiveDateGeneric Edit60
117F4576Z1Ship and Debit Claims Unedited Transaction Table117Z1EFTJDate - EffectiveDateGeneric Edit60
TOP46L: License Plating
118F46L010License Plate Segments3LSEFTJDate - EffectiveDateGeneric Edit60
119F46L011License Plate Next Numbers3LNEFTJDate - EffectiveDateGeneric Edit60
TOP47: Electronic Commerce
120F47082EDI Price Sales Catalog Detail - Inbound70FYEFTJDate - EffectiveDateGeneric Edit60
121F4780Address Cross-Reference5AXEFTJDate - EffectiveDateGeneric Edit60
TOP49: Transportation Management
122F490052Generate Tracking Segment Next Number4YGEFTJDate - EffectiveDateGeneric Edit60
123F49015Vehicle Status3STEFTJDate - EffectiveDateGeneric Edit60
124F49020Vehicle/Staff License Information8VLEFTJDate - EffectiveDateGeneric Edit60
125F49025Connected Vehicles (Conversion from World File)7CVEFTJDate - EffectiveDateGeneric Edit60
126F49030Vehicle Equipment (Conversion from World File)4VEEFTJDate - EffectiveDateGeneric Edit60
127F49040Vehicle Staff (Conversion from World File)4VSEFTJDate - EffectiveDateGeneric Edit60
128F49041Depot/Vehicle Staff3VSEFTJDate - EffectiveDateGeneric Edit60
129F49160Document Next Number5NNEFTJDate - EffectiveDateGeneric Edit60
130F49302Vehicle Equipment4VEEFTJDate - EffectiveDateGeneric Edit60
131F4935Connected Vehicle Header2VHEFTJDate - EffectiveDateGeneric Edit60
132F4936Connected Vehicle Detail2CWEFTJDate - EffectiveDateGeneric Edit60
133F4945Shipment Charges45SCEFTJDate - EffectiveDateGeneric Edit60
134F4950Routing Entries32RTEFTJDate - EffectiveDateGeneric Edit60
135F49501Intermodal Detail Routing Entries18RDEFTJDate - EffectiveDateGeneric Edit60
136F4956Option and Equipment Inclusions/Exclusions5IXEFTJDate - EffectiveDateGeneric Edit60
137F4972Rate Detail11RXEFTJDate - EffectiveDateGeneric Edit60
138F4974RateWare XL Rate Constants23RWEFTJDate - EffectiveDateGeneric Edit60
139F4977Rate Parameters19MREFTJDate - EffectiveDateGeneric Edit60
TOP74S: Spain
140F74S505Stamps (Timbres) Fee Header - 03B4SHEFTJDate - EffectiveDateGeneric Edit60
TOP74W: Sweden - Reporting System Only
141F74W203Debit Advice Invoice File - 74W9K3EFTJDate - EffectiveDateGeneric Edit60
TOP74Y: Italy - Reporting System Only
142F74Y170Contracts - IT - 007CTEFTJDate - EffectiveDateGeneric Edit60
TOP75C: China - Reporting System Only
143F75C4106Chinese Free Goods VAT base price - F75C4106 - 416IBEFTJDate - EffectiveDateGeneric Edit60
TOP75I: India
144F75I052Services Category Additional information - IND - 75I5INEFTJDate - EffectiveDateGeneric Edit60
145F75I072Tax Rules Setup - IND - 456TSEFTJDate - EffectiveDateGeneric Edit60
TOP75T: Taiwan
146F75T1113Taiwan Exchange Rate Update8TREFTJDate - EffectiveDateGeneric Edit60
TOP76A: Argentina
147F760401AGross Income Withholding Percentage - ARG - 04 - 76A5K2EFTJDate - EffectiveDateGeneric Edit60
148F760402AV.A.T. withholding percentage - ARG - 04 - 76A3K1EFTJDate - EffectiveDateGeneric Edit60
149F760405AContract Withholding Percentage - ARG - 04 - 76A3K7EFTJDate - EffectiveDateGeneric Edit60
150F760410AEventual Services Withholding Percentage - ARG - 04 - 76A4K0EFTJDate - EffectiveDateGeneric Edit60
151F7607AWithholding Exempt Percentage - ARG - 04 - 04 - 76A3V4EFTJDate - EffectiveDateGeneric Edit60
152F76A003A/P Tag File - CAI Storage - ARG - 04 - 76A5RGEFTJDate - EffectiveDateGeneric Edit60
153F76A005CAI - Invoice range for Preprinters - ARG - 03B4RHEFTJDate - EffectiveDateGeneric Edit60
154F76A043A/P Tag Table - CAI Storage - ARG - 04 - 76A5RGEFTJDate - EffectiveDateGeneric Edit60
155F76A050Small Contributor Limits - ARG - 042SCEFTJDate - EffectiveDateGeneric Edit60
156F76A12Taxes - Minimum Tax By Date - ARG - 00 - 76A2TMEFTJDate - EffectiveDateGeneric Edit60
157F76A13Taxes - Tax Values - ARG - 00 - 76A6TVEFTJDate - EffectiveDateGeneric Edit60
158F76A15Taxes - Effective and Expiration Dates - ARG - 00 - 76A4TEEFTJDate - EffectiveDateGeneric Edit60
159F76A16Taxes - Tax Groups - ARG - 00 - 76A4TGEFTJDate - EffectiveDateGeneric Edit60
160F76A41CERG G/L - Lot Detail - ARG - 09 - 76A15LDEFTJDate - EffectiveDateGeneric Edit60
161F76A48CERG A/P - Control Payments -ARG - 04 - 76A14PIEFTJDate - EffectiveDateGeneric Edit60
162F76A49CERG A/R - Control Receipts - ARG - 03B - 76A14CREFTJDate - EffectiveDateGeneric Edit60
163F76A8011Supplier Information RG 726 - ARG - 04 - 76A8PAEFTJDate - EffectiveDateGeneric Edit60
164F76A8020Gross Income Exempt Percentage - ARG - 04 - 76A3EPEFTJDate - EffectiveDateGeneric Edit60
165F76A8030Taxes - Minimun Tax By Invoice - ARG - 03B - 76A2MTEFTJDate - EffectiveDateGeneric Edit60
166F76A8050Perceptions Exempt Percentages - ARG - 03B - 76A3PPEFTJDate - EffectiveDateGeneric Edit60
167F76A8090V.A.T. Witholding Percentage Rg726 - ARG - 04 - 76A5VPEFTJDate - EffectiveDateGeneric Edit60
168F76A8230Percentages by state / agreement Gross Income - ARG - - 76A4C1EFTJDate - EffectiveDateGeneric Edit60
TOP76B: Brazil - Reporting System Only
169F76B210IR INSS Minimum Withholding Amount - BRA - 422MWEFTJDate - EffectiveDateGeneric Edit60
170F76B409Taxes Setup by City and Service - BR - 044CSEFTJDate - EffectiveDateGeneric Edit60
171F76B422Minimum Amounts to Withhold -BR- 76B2TKEFTJDate - EffectiveDateGeneric Edit60
TOP76C: Colombia
172F76C0101A/B Tag File - COL - 76C6V0EFTJDate - EffectiveDateGeneric Edit60
173F76CI1Tax Parameters - COL - 76C6PIEFTJDate - EffectiveDateGeneric Edit60
174F76CI2Economic Activity - COL - 76C5AEEFTJDate - EffectiveDateGeneric Edit60
TOP76P: Peru
175F76P405IGV Withholding Percentage - PER - 04 - 76P3IGEFTJDate - EffectiveDateGeneric Edit60
176F76P410SPOT Withholdings Percentage - PER - 04 - 76P3SPEFTJDate - EffectiveDateGeneric Edit60
TOP76V: Venezuela
177F76V4020ISLR Withholdings Setup - VEN - 046WSEFTJDate - EffectiveDateGeneric Edit60
178F76V4021ISLR Withholdings Setup Tag File - VEN - 045WTEFTJDate - EffectiveDateGeneric Edit60
179F76V4025IM Withholdings Setup - VEN - 045WSEFTJDate - EffectiveDateGeneric Edit60
180F76V4030VAT Withholdings Setup - VEN - 043VWEFTJDate - EffectiveDateGeneric Edit60
TOP89: Conversion Programs
181F40344ATemporay Preference Profile - Sales Commission5SAEFTJDate - EffectiveDateGeneric Edit60
182F4072TEMPrice Adjustment Detail - Temp for Upgrade14ADEFTJDate - EffectiveDateGeneric Edit60
TOPH92: Interactive Engine/OL
183F00165TMedia Object Conversion Table11GDEFTJDate - EffectiveDateGeneric Edit60