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

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

197 columns | Print definition?812 | AID

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018RTax Reconciliation Repository10EDAIDAccount IDStringGeneric Edit80
2F0030Bank Transit Number Master File6AYAIDAccount IDStringGeneric Edit80
3F0030TBank Account X12 Information1AZAIDAccount IDStringGeneric Edit80
4F0901TAccount Master Tag File1GMAIDAccount IDStringGeneric Edit80
5F0901WSAccount - Word Search2WSAIDAccount IDStringGeneric Edit80
6F0902Account Balances1GBAIDAccount IDStringGeneric Edit80
7F0911Account Ledger16GLAIDAccount IDStringGeneric Edit80
TOP03B: Enhanced Accounts Receivable
8F03B11Customer Ledger16RPAIDAccount IDStringGeneric Edit80
9F03B11PCustomer Ledger Purge File16RPAIDAccount IDStringGeneric Edit80
10F03B11Z1Invoice Transactions - Batch File34VJAIDAccount IDStringGeneric Edit80
11F03B11Z2F03B11 Interoperability Table29SYAIDAccount IDStringGeneric Edit80
12F03B13Receipts Header File13RYAIDAccount IDStringGeneric Edit80
13F03B13PReceipts Header Purge File13RYAIDAccount IDStringGeneric Edit80
14F03B13Z2F03B13 Interoperability Table26SYAIDAccount IDStringGeneric Edit80
15F03B14A/R Check Detail File14RZAIDAccount IDStringGeneric Edit80
16F03B14PReceipts Detail Purge File14RZAIDAccount IDStringGeneric Edit80
17F03B14Z2F03B14 Interoperability Table27SZAIDAccount IDStringGeneric Edit80
18F03B575Auto Debit Invoice Select and Build19RDAIDAccount IDStringGeneric Edit80
19F03B672Draft Remittance Work File - One World Only16RDAIDAccount IDStringGeneric Edit80
20F09UI011Receipt Prepost Work File11GLAIDAccount IDStringGeneric Edit80
TOP04: Accounts Payable
21F09UI005Tax Offsets User Index6GLAIDAccount IDStringGeneric Edit80
TOP05: Time Accounting and HRM Base
22F0618Employee Transaction History96YTAIDAccount IDStringGeneric Edit80
TOP05T: Time Entry
23F0624Burden Distribution File17J#AIDAccount IDStringGeneric Edit80
24F06241Burden Distribution File17J#AIDAccount IDStringGeneric Edit80
25F069136Tip Disbursement13JEAIDAccount IDStringGeneric Edit80
TOP07: Payroll
26F07UI200Timecard History Work File98THAIDAccount IDStringGeneric Edit80
TOP08P: Position Control
27F081012Position Accounts6HCAIDAccount IDStringGeneric Edit80
TOP09: General Accounting
28F0901Account Master2GMAIDAccount IDStringGeneric Edit80
29F0901CAccount Category Codes1GMAIDAccount IDStringGeneric Edit80
30F0901DAccount Master - Alternate Description3LKAIDAccount IDStringGeneric Edit80
31F0902BAccount Balances - 52 Period Accounting1GBAIDAccount IDStringGeneric Edit80
32F0902PPurge - Account Balances1GBAIDAccount IDStringGeneric Edit80
33F0902Z1Account Balances - Batch File1GBAIDAccount IDStringGeneric Edit80
34F0911PPurge - Account Ledger16GLAIDAccount IDStringGeneric Edit80
35F0911RWF - Acct Ledger File for Reconciliation16GLAIDAccount IDStringGeneric Edit80
36F0911R1Account Reconciliations Header - OneWorld ONLY1GLAIDAccount IDStringGeneric Edit80
37F0911Z1Journal Entry Transactions - Batch File33VNAIDAccount IDStringGeneric Edit80
38F0911Z4F0911 Interoperability Table38SZAIDAccount IDStringGeneric Edit80
39F0912Cost Allocations/Flex Budgeting14RJAIDAccount IDStringGeneric Edit80
40F0912AIndex Computation Entry File10RIAIDAccount IDStringGeneric Edit80
41F0912BVariable Allocation File13R#AIDAccount IDStringGeneric Edit80
42F092181Online Consolidation Detail File6LRAIDAccount IDStringGeneric Edit80
43F09505WF - Bank File of Cleared Checks.1GNAIDAccount IDStringGeneric Edit80
44F09621Bank Account Cross Reference3GSAIDAccount IDStringGeneric Edit80
45F09628Auto Bank Statement Account Setup1GAAIDAccount IDStringGeneric Edit80
46F09UI004Variable Numerator Allocations work file8R#AIDAccount IDStringGeneric Edit80
47F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY13GLAIDAccount IDStringGeneric Edit80
48F09UI014Annual Close Work Table1GBAIDAccount IDStringGeneric Edit80
49F09UI015Indexed Computations Multi-Tiered Entries16GLAIDAccount IDStringGeneric Edit80
50F09UI016Account Balance Compare Exceptions4GWAIDAccount IDStringGeneric Edit80
TOP10: Financial Reporting
51F100901Level of Detail1FRAIDAccount IDStringGeneric Edit80
52F10430Multi-Site Consolidation - Account Structure9CFAIDAccount IDStringGeneric Edit80
53F10UI001Account Structure Build Workfile10CFAIDAccount IDStringGeneric Edit80
54F10UI003Dynamically Created Accounts9ACAIDAccount IDStringGeneric Edit80
TOP11: Multi Currency
55F1114Company Conversions Parameter File17C2AIDAccount IDStringGeneric Edit80
TOP12: Fixed Assets
56F1202Asset Account Balances File1FLAIDAccount IDStringGeneric Edit80
57F1202PAsset Account Balances Purge Table1FLAIDAccount IDStringGeneric Edit80
TOP13E: Equipment Cost Analysis
58F1383Equipment Analysis Costs6ECAIDAccount IDStringGeneric Edit80
TOP14: Modeling - Planning & Budgeting
59F1403Forecast Basis2BDAIDAccount IDStringGeneric Edit80
60F1404Forecast Results - Header2BYAIDAccount IDStringGeneric Edit80
61F14041Forecast Results - Detail2BZAIDAccount IDStringGeneric Edit80
TOP15: Property Management
62F1511Tenant/Lease Billings Detail16NJAIDAccount IDStringGeneric Edit80
63F15110BExpense Participation Class Account3OBAIDAccount IDStringGeneric Edit80
64F1511BTenant/Lease Billings Detail Master16NJAIDAccount IDStringGeneric Edit80
65F1511HTenant/Lease Billings Detail History16N#AIDAccount IDStringGeneric Edit80
66F1511HBTenant/Lease Billings Detail History16NCAIDAccount IDStringGeneric Edit80
67F1530Expense Participation Class Master9NGAIDAccount IDStringGeneric Edit80
68F1532BExpense Participation Audit File10NTAIDAccount IDStringGeneric Edit80
69F1533Tenant Class Account Exclusions4NMAIDAccount IDStringGeneric Edit80
70F1533BTenant Account Exclusions5NMAIDAccount IDStringGeneric Edit80
TOP15L: Adv Real Estate Forecasting
71F15L108AREF Base Account Definition2ADAIDAccount IDStringGeneric Edit80
72F15L109AREF Budget Results2BRAIDAccount IDStringGeneric Edit80
73F15L110AREF Account Status3ASAIDAccount IDStringGeneric Edit80
74F15L111AREF Account Status Detail3ADAIDAccount IDStringGeneric Edit80
75F15L118AREF Base Account Definition Detail2DDAIDAccount IDStringGeneric Edit80
76F15L120AREF Account Association3AAAIDAccount IDStringGeneric Edit80
77F15L38AREF EP Billing Register92NZAIDAccount IDStringGeneric Edit80
TOP16: Profit Management (EPS)
78F1602Cost Analyzer Balances3CBAIDAccount IDStringGeneric Edit80
79F1602Z1External Cost Analyzer Balances - Interoperability Table25CZAIDAccount IDStringGeneric Edit80
80F1611Cost Calculation Transactions10CTAIDAccount IDStringGeneric Edit80
TOP17: Customer Service Management
81F1721Contract Detail17CDAIDAccount IDStringGeneric Edit80
82F4801TZ2Warranty Claim/Supplier Recovery processing24WQAIDAccount IDStringGeneric Edit80
TOP31: Shop Floor Control
83F31UI802Accumulate Amounts by Account9WGAIDAccount IDStringGeneric Edit80
84F31UI803Work File for Summarizing Journal Entries9SGAIDAccount IDStringGeneric Edit80
85F4801Z1Outbound Work Order Header158SYAIDAccount IDStringGeneric Edit80
TOP31P: Engineer To Order
86F31P21Cost Classification Table4CCAIDAccount IDStringGeneric Edit80
TOP39: Advanced Stock Valuation
87F3910G/L Adjustment Table11SCAIDAccount IDStringGeneric Edit80
TOP40: Inventory/OP Base
88F4011ZBatch Receiver File - Order Details193SZAIDAccount IDStringGeneric Edit80
89F49211Sales Order Detail File - Tag File128UDAIDAccount IDStringGeneric Edit80
90F49211Z1Sales Order Detail Tag Unedited Transaction File147S1AIDAccount IDStringGeneric Edit80
91F49219Sales Order Detail - Tag History File105UDAIDAccount IDStringGeneric Edit80
TOP41: Inventory Management
92F4111Item Ledger File49ILAIDAccount IDStringGeneric Edit80
TOP42: Sales Management
93F42800G1Sales Update G Batch Detail Workfile12DGAIDAccount IDStringGeneric Edit80
94F470371TTag for F470371- EDI shipping Notice Detail - Outbound3UZAIDAccount IDStringGeneric Edit80
TOP42B: Sales Order Entry
95F49299S.O. Detail Tag Ledger File128UDAIDAccount IDStringGeneric Edit80
TOP43: Procurement
96F40910Commitment Integrity Report Work File3P#AIDAccount IDStringGeneric Edit80
97F43080Approvals Fields Constants3PDAIDAccount IDStringGeneric Edit80
98F4311Purchase Order Detail File126PDAIDAccount IDStringGeneric Edit80
99F4311ZPurchase Order Generator File130PWAIDAccount IDStringGeneric Edit80
100F4311Z1Purchase Order Detail Unedited Transaction Table139SZAIDAccount IDStringGeneric Edit80
101F43121Purchase Order Receiver File47PRAIDAccount IDStringGeneric Edit80
102F43121Z1Receipts Unedited Transaction Table64SZAIDAccount IDStringGeneric Edit80
103F4314ZVoucher Match Selection File146PNAIDAccount IDStringGeneric Edit80
104F4316Purchase Order Multiple Account File22P3AIDAccount IDStringGeneric Edit80
105F43199P.O. Detail Ledger File - Flexible Version126OLAIDAccount IDStringGeneric Edit80
106F43632ZOpen Purchase Order by Item Work File15OIAIDAccount IDStringGeneric Edit80
TOP43A: Purchase Order Receipt/Routing
107F43126Purchase Order Receiver Multiple Account9P4AIDAccount IDStringGeneric Edit80
TOP43E: Requisition Self Service
108F43E16Requisition Multiple Account File8P3AIDAccount IDStringGeneric Edit80
TOP43Q: Strategic Sourcing
109F43Q11Event Detail13EDAIDAccount IDStringGeneric Edit80
TOP44H: Homebuilder Management
110F44H611Bid Details9BDAIDAccount IDStringGeneric Edit80
111F44H611WBid Details Work File13BWAIDAccount IDStringGeneric Edit80
112F44H711Lot Start Workfile73SWAIDAccount IDStringGeneric Edit80
113F44H711ZHB Lot Start Unedited Transaction File86SZAIDAccount IDStringGeneric Edit80
114F44H71W1Lot Start Generation Workfile73GWAIDAccount IDStringGeneric Edit80
115F44H73W1Lot Start - P.O. / Committment Generation Work File43CGAIDAccount IDStringGeneric Edit80
116F44H73W2Lot Start - Budget Generation Workfile14BGAIDAccount IDStringGeneric Edit80
117F44H902WBudget Creation Workfile2WFAIDAccount IDStringGeneric Edit80
TOP47: Electronic Commerce
118F47012EDI Purchase Order Detail - Inbound194SZAIDAccount IDStringGeneric Edit80
119F47017EDI Purchase Order Detail - Outbound140SZAIDAccount IDStringGeneric Edit80
120F47022EDI P.O. Acknowledgment Detail - Inbound140SZAIDAccount IDStringGeneric Edit80
121F47027EDI P.O. Acknowledgment Detail - Outbound194SZAIDAccount IDStringGeneric Edit80
122F47042EDI Invoice Detail - Inbound48SZAIDAccount IDStringGeneric Edit80
123F47047EDI Invoice Detail (Sales) - Outbound194SZAIDAccount IDStringGeneric Edit80
124F47072EDI Receiving Advice Detail - Inbound141SZAIDAccount IDStringGeneric Edit80
125F47077EDI Receiving Advice Detail - Outbound141SZAIDAccount IDStringGeneric Edit80
126F47092EDI Request for Quote Detail - Inbound194SZAIDAccount IDStringGeneric Edit80
127F47097EDI Request for Quote Detail - Outbound140SZAIDAccount IDStringGeneric Edit80
128F47102EDI Response to RFQ Detail - Inbound140SZAIDAccount IDStringGeneric Edit80
129F47107EDI Response to RFQ Detail - Outbound193SZAIDAccount IDStringGeneric Edit80
130F47132EDI Purchase Order Change Detail - Inbound195SZAIDAccount IDStringGeneric Edit80
131F47137EDI Purchase Order Change Detail - Outbound141SZAIDAccount IDStringGeneric Edit80
132F47142EDI P.O. Change Acknowledgment Detail - Inbound142SZAIDAccount IDStringGeneric Edit80
133F47147EDI P.O. Change Acknowledgment Detail - Outbound196SZAIDAccount IDStringGeneric Edit80
134F47157EDI Shipping Schedule Detail - Outbound149SZAIDAccount IDStringGeneric Edit80
TOP48: Work Order Processing
135F4801STPurge - Work Order Master Tag File11WAAIDAccount IDStringGeneric Edit80
136F4801TWork Order Master Tag File11WAAIDAccount IDStringGeneric Edit80
TOP48S: Service Billing
137F4812Billing Detail Workfile6WDAIDAccount IDStringGeneric Edit80
138F4812HBilling Workfile - History6WDAIDAccount IDStringGeneric Edit80
139F4812HSBilling Workfile History Purged Save6WDAIDAccount IDStringGeneric Edit80
140F48S0618Payroll Reclassification Workfile96YTAIDAccount IDStringGeneric Edit80
141F48S910Billing Detail Journal File21W2AIDAccount IDStringGeneric Edit80
142F48S911Compressed Journal File19W3AIDAccount IDStringGeneric Edit80
143F48S912G/L Link File1W6AIDAccount IDStringGeneric Edit80
144F48SUI01Billing Detail Print Workfile6WDAIDAccount IDStringGeneric Edit80
TOP51: Job Costing
145F51901Cost Code Schedule1GPAIDAccount IDStringGeneric Edit80
146F51911Draw Reporting Master11GKAIDAccount IDStringGeneric Edit80
TOP53: Change Management
147F5314Planned Change Order Master Table25D2AIDAccount IDStringGeneric Edit80
148F5315Change Order Master Table24D3AIDAccount IDStringGeneric Edit80
TOP55: Reserved for Clients
149F091102Saldi F0911 dell'anno 20021GLAIDAccount IDStringGeneric Edit80
150F7460Next Auto Debit Number3QLAIDAccount IDStringGeneric Edit80
151F74H105SSlovakian Invoice Accounting Summary11ASAIDAccount IDStringGeneric Edit80
152F74R0010Petty Cash Next Number Setup - RUS - 00 - 74R2PCAIDAccount IDStringGeneric Edit80
153F74T205Checks Collected7CCAIDAccount IDStringGeneric Edit80
154F74TL005Account Table Turkish Localization9ATAIDAccount IDStringGeneric Edit80
155F74T550General Ledger Work File - Turkish6DKAIDAccount IDStringGeneric Edit80
156F74T550CAccount Table - Turkish Localization7ATAIDAccount IDStringGeneric Edit80
TOP74: EMEA Localization
157F74412Customer / Supplier Balance Workfile (A/R and A/P)5RPAIDAccount IDStringGeneric Edit80
158F74900Foreign Receivables and Payables - EMEA22RPAIDAccount IDStringGeneric Edit80
159F749104Rows Definition - EMEA - 7418RDAIDAccount IDStringGeneric Edit80
160F749111Account Group Detail- EMEA - 745AGAIDAccount IDStringGeneric Edit80
161F74S55Expenses and Exchange Rate for Payments - Spain8Q5AIDAccount IDStringGeneric Edit80
162F74UI91WF - Account Detail - EMEA - 747ADAIDAccount IDStringGeneric Edit80
TOP74H: Hungary
163F741202Work File Accumulated Asset Movement Dep - HUN - 741WFAIDAccount IDStringGeneric Edit80
TOP74P: Poland
164F74902TAccount Balance Tag File - COM - 09 - 74P1ATAIDAccount IDStringGeneric Edit80
165F74P03BWA/R Trial Balance - POL - 03B - 74P14P3AIDAccount IDStringGeneric Edit80
166F74P04WA/P Trial Balance Work Table - POL - 04 - 74P14P2AIDAccount IDStringGeneric Edit80
167F74P9100Cash Desk Transaction - POL - 74P12CDAIDAccount IDStringGeneric Edit80
TOP74R: CIS
168F74R0018Russian Tax File - 74R39TDAIDAccount IDStringGeneric Edit80
169F74R0100Petty Cash Transactions - RUS - 00 - 74R13PCAIDAccount IDStringGeneric Edit80
170F74R9029Open Accounts - RUS - 09 - 74R4OAAIDAccount IDStringGeneric Edit80
TOP75T: Taiwan
171F75T012GUI/VAT GL Account Mapping - 75T4GLAIDAccount IDStringGeneric Edit80
TOP76A: Argentina
172F760499AContract Withholding - Advances - ARG -04 - 048K8AIDAccount IDStringGeneric Edit80
173F76A11Account ID Relationship - ARG - 001TFAIDAccount IDStringGeneric Edit80
174F76A19Taxes - Tax Amounts by Invoice Suffix AGR20TIAIDAccount IDStringGeneric Edit80
175F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A20TIAIDAccount IDStringGeneric Edit80
176F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B38VKAIDAccount IDStringGeneric Edit80
177F76A32A/P Account ID Relationship - ARG - 04 - 041X3AIDAccount IDStringGeneric Edit80
178F76A42CERG G/L - Work File - ARG - 09 - 092TFAIDAccount IDStringGeneric Edit80
179F76AUI24Taxes Work File - ARG - 0017TIAIDAccount IDStringGeneric Edit80
180F76AUI81Draft - Invoices Work File - ARG - 03B - 76A13WFAIDAccount IDStringGeneric Edit80
TOP76B: Brazil - Reporting System Only
181F7611BNota Fiscal Detail - Brazil90FDAIDAccount IDStringGeneric Edit80
TOP76C: Colombia
182F76C031AA/R Customer ledger As Of - F76C031A - COL - 0416RPAIDAccount IDStringGeneric Edit80
183F76C034AA/R Check Detail file As Of - COL - 76C14RZAIDAccount IDStringGeneric Edit80
184F76C0902Debits and Credits T/B by object account - COL - 76C1GBAIDAccount IDStringGeneric Edit80
185F76C9415Workfile for Dialy Book - COL - 098LDAIDAccount IDStringGeneric Edit80
186F76CT2Sales/Use/V.A.T. Tax File - COL - 76C23CTAIDAccount IDStringGeneric Edit80
187F76CUI01Account Master - Work File - COL - 76C2GMAIDAccount IDStringGeneric Edit80
188F76CUI03Account Cat. Code - Work File - COL - 76C2GMAIDAccount IDStringGeneric Edit80
TOP76H: Chile
189F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H7I1AIDAccount IDStringGeneric Edit80
190F76H6005Account ID / Cost Type Relationship - CHI - 41 - 76H2ACAIDAccount IDStringGeneric Edit80
191F76H902TAccount Balances Tag File - CHI - 09 - 76H1ATAIDAccount IDStringGeneric Edit80
TOP83: Management Reporting - FASTR
192F83UI001Balance Audit Work File - (Financial Reporting)8R1AIDAccount IDStringGeneric Edit80
TOP89: Conversion Programs
193F0902AAccount Debit Balances1GDAIDAccount IDStringGeneric Edit80
194F42119BSales Order History File - temporary for upgrade (2)22SDAIDAccount IDStringGeneric Edit80
195F4211BSales Order Detail File - temporary for upgrade (2)22SDAIDAccount IDStringGeneric Edit80
196F43199ATemp F43199 for ERP 9.0 Upgrade126OLAIDAccount IDStringGeneric Edit80
TOPH95: Tech Resources/Applications
197F00166Media Object Categories30GTAIDAccount IDStringGeneric Edit80