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

166 columns | Print definition?812 | 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 - Summary File48KKEFTJDate - EffectiveDateGeneric Edit60
4F04573A/P Payment Processing - Detail File18KIEFTJDate - 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
8F1755Customer Call 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
TOP42: Sales Management
81F4020Freight/Additional Charges Rate Information13AREFTJDate - EffectiveDateGeneric Edit60
82F42430Customer Set3CSEFTJDate - EffectiveDateGeneric Edit60
TOP42B: Sales Order Entry
83F42440Customer Segment Items9CSEFTJDate - EffectiveDateGeneric Edit60
84F42UI440Customer Segment Items - Work File10CSEFTJDate - EffectiveDateGeneric Edit60
TOP43: Procurement
85F41061Supplier Price/Catalog File17CBEFTJDate - EffectiveDateGeneric Edit60
86F4340Purchase Rebate Master File5RDEFTJDate - EffectiveDateGeneric Edit60
TOP45: Advanced Pricing
87F4070Price Adjustment Schedule10SNEFTJDate - EffectiveDateGeneric Edit60
88F4072Price Adjustment Detail12ADEFTJDate - EffectiveDateGeneric Edit60
89F4072WPrice Adjustment Detail Work File12ADEFTJDate - EffectiveDateGeneric Edit60
90F4075Price Variable Table5VBEFTJDate - EffectiveDateGeneric Edit60
91F4077Rebate Thresholds8RTEFTJDate - EffectiveDateGeneric Edit60
92F4078Rebate Transaction Summary8RHEFTJDate - EffectiveDateGeneric Edit60
93F4079Rebate Transaction Detail7SVEFTJDate - EffectiveDateGeneric Edit60
94F4501Master Schedule Adjustment5MSEFTJDate - EffectiveDateGeneric Edit60
95F4502Free Goods Catalog3FGEFTJDate - EffectiveDateGeneric Edit60
96F4511WPricing Structure View49APEFTJDate - EffectiveDateGeneric Edit60
97F4551Basket Master Detail4BDEFTJDate - EffectiveDateGeneric Edit60
98F45520Price List Header7PHEFTJDate - EffectiveDateGeneric Edit60
99F45521Price List Detail4PDEFTJDate - EffectiveDateGeneric Edit60
100F45715Adjustment Balances10ABEFTJDate - EffectiveDateGeneric Edit60
101F4572Live Promotions X-Reference by Cost Type7XREFTJDate - EffectiveDateGeneric Edit60
102F4572Z1Live Promotions Interface - Inbound / Outbound21LPEFTJDate - EffectiveDateGeneric Edit60
103F4572ZPPurge Live Promotions Interface21PGEFTJDate - EffectiveDateGeneric Edit60
104F4574Key Reference Table18KREFTJDate - EffectiveDateGeneric Edit60
105F4575Ship and Debit History39AHEFTJDate - EffectiveDateGeneric Edit60
106F4575TMPShip and Debit History - Temp Table39AHEFTJDate - EffectiveDateGeneric Edit60
107F4576Z1Ship and Debit Claims Unedited Transaction Table117Z1EFTJDate - EffectiveDateGeneric Edit60
TOP46L: License Plating
108F46L010License Plate Segments3LSEFTJDate - EffectiveDateGeneric Edit60
109F46L011License Plate Next Numbers3LNEFTJDate - EffectiveDateGeneric Edit60
TOP47: Electronic Commerce
110F47082EDI Price Sales Catalog Detail - Inbound70FYEFTJDate - EffectiveDateGeneric Edit60
111F4780Address Cross-Reference5AXEFTJDate - EffectiveDateGeneric Edit60
TOP49: Transportation Management
112F490052Generate Tracking Segment Next Number4YGEFTJDate - EffectiveDateGeneric Edit60
113F49015Vehicle Status3STEFTJDate - EffectiveDateGeneric Edit60
114F49020Vehicle/Staff License Information8VLEFTJDate - EffectiveDateGeneric Edit60
115F49025Connected Vehicles (Conversion from World File)7CVEFTJDate - EffectiveDateGeneric Edit60
116F49030Vehicle Equipment (Conversion from World File)4VEEFTJDate - EffectiveDateGeneric Edit60
117F49040Vehicle Staff (Conversion from World File)4VSEFTJDate - EffectiveDateGeneric Edit60
118F49041Depot/Vehicle Staff3VSEFTJDate - EffectiveDateGeneric Edit60
119F49160Document Next Number5NNEFTJDate - EffectiveDateGeneric Edit60
120F49302Vehicle Equipment4VEEFTJDate - EffectiveDateGeneric Edit60
121F4935Connected Vehicle Header2VHEFTJDate - EffectiveDateGeneric Edit60
122F4936Connected Vehicle Detail2CWEFTJDate - EffectiveDateGeneric Edit60
123F4945Shipment Charges45SCEFTJDate - EffectiveDateGeneric Edit60
124F4950Routing Entries32RTEFTJDate - EffectiveDateGeneric Edit60
125F49501Intermodal Detail Routing Entries18RDEFTJDate - EffectiveDateGeneric Edit60
126F4956Option and Equipment Inclusions/Exclusions5IXEFTJDate - EffectiveDateGeneric Edit60
127F4972Rate Detail11RXEFTJDate - EffectiveDateGeneric Edit60
128F4977Rate Parameters19MREFTJDate - EffectiveDateGeneric Edit60
TOP55: Reserved for Clients
129F55IFPSKTabella Punti Promozioni4PPEFTJDate - EffectiveDateGeneric Edit60
130F59H0210Call Priority Setup5CPEFTJDate - EffectiveDateGeneric Edit60
131F59H0215Correctoin Default Line Type5CLEFTJDate - EffectiveDateGeneric Edit60
TOP74S: Spain
132F74S505Stamps (Timbres) Fee Header4SHEFTJDate - EffectiveDateGeneric Edit60
TOP74W: Sweden - Reporting System Only
133F74W203Debit Advice Invoice File - 74W9K3EFTJDate - EffectiveDateGeneric Edit60
TOP75C: China - Reporting System Only
134F75C4106Chinese Free Goods VAT base price - F75C41066IBEFTJDate - EffectiveDateGeneric Edit60
TOP76A: Argentina
135F760401AGross Income Withholding Percentage - ARG5K2EFTJDate - EffectiveDateGeneric Edit60
136F760402AV.A.T. withholding percentage - ARG3K1EFTJDate - EffectiveDateGeneric Edit60
137F760405AContract Withholding Percentage - ARG3K7EFTJDate - EffectiveDateGeneric Edit60
138F760410AEventual Services Withholding Percentage - ARG4K0EFTJDate - EffectiveDateGeneric Edit60
139F7607AWithholding Exempt Percentage - ARG - 04 - 043V4EFTJDate - EffectiveDateGeneric Edit60
140F76A003A/P Tag File - CAI Storage - ARG - 005RGEFTJDate - EffectiveDateGeneric Edit60
141F76A005CAI - Invoice range for Preprinters - ARG - 03B4RHEFTJDate - EffectiveDateGeneric Edit60
142F76A043A/P Tag File - CAI Storage - ARG - 045RGEFTJDate - EffectiveDateGeneric Edit60
143F76A12Taxes - Minimum Tax By Date - ARG - 002TMEFTJDate - EffectiveDateGeneric Edit60
144F76A13Taxes - Tax Values - ARG - 006TVEFTJDate - EffectiveDateGeneric Edit60
145F76A15Taxes - Effective and Expiration Dates - ARG - 004TEEFTJDate - EffectiveDateGeneric Edit60
146F76A16Taxes - Tax Groups - ARG - 004TGEFTJDate - EffectiveDateGeneric Edit60
147F76A41CERG G/L - Lot Detail - ARG - 09 - - 0915LDEFTJDate - EffectiveDateGeneric Edit60
148F76A48CERG A/P - Control Payments -ARG - 04 - 0414PIEFTJDate - EffectiveDateGeneric Edit60
149F76A49CERG A/R - Control Receipts - ARG - 03B - 03B14CREFTJDate - EffectiveDateGeneric Edit60
150F76A8011Supplier Information RG 726 - 048PAEFTJDate - EffectiveDateGeneric Edit60
151F76A8020Gross Income Exempt Percentage - ARG - 04 - 76A3EPEFTJDate - EffectiveDateGeneric Edit60
152F76A8030Taxes - Minimun Tax By Invoice - ARG - 03B - 76A2MTEFTJDate - EffectiveDateGeneric Edit60
153F76A8050Perceptions Exempt Percentages - 03B3PPEFTJDate - EffectiveDateGeneric Edit60
154F76A8090V.A.T. Witholding Percentage Rg7265VPEFTJDate - EffectiveDateGeneric Edit60
155F76A8230Percentages by state / agreement Gross Income - ARG - - 76A4C1EFTJDate - EffectiveDateGeneric Edit60
TOP76C: Colombia
156F76C0101A/B Tag File - COL - 76C6V0EFTJDate - EffectiveDateGeneric Edit60
157F76CI1Tax Parameters - COL - 76C6PIEFTJDate - EffectiveDateGeneric Edit60
158F76CI2Economic Activity - COL - 76C5AEEFTJDate - EffectiveDateGeneric Edit60
TOP76P: Peru
159F76P405IGV Withholding Percentage - PER - 04 - 76P3IGEFTJDate - EffectiveDateGeneric Edit60
160F76P410SPOT Withholdings Percentage - PER - 04 - 76P3SPEFTJDate - EffectiveDateGeneric Edit60
TOP76V: Venezuela
161F76V4020ISLR Withholdings Setup - VEN - 046WSEFTJDate - EffectiveDateGeneric Edit60
162F76V4025IM Withholdings Setup - VEN - 045WSEFTJDate - EffectiveDateGeneric Edit60
163F76V4030VAT Withholdings Setup - VEN - 043VWEFTJDate - EffectiveDateGeneric Edit60
TOP89: Conversion Programs
164F40344ATemporay Preference Profile - Sales Commission5SAEFTJDate - EffectiveDateGeneric Edit60
165F4072TEMPrice Adjustment Detail - Temp for Upgrade14ADEFTJDate - EffectiveDateGeneric Edit60
TOPH92: Interactive Engine/OL
166F00165TMedia Object Conversion Table11GDEFTJDate - EffectiveDateGeneric Edit60