JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

168 columns | Print definition?910 | AA

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018RTax Reconciliation Repository11EDAAAmountNumericGeneric Edit152
2F0911Account Ledger31GLAAAmountNumericGeneric Edit152
TOP03B: Enhanced Accounts Receivable
3F03BUI04Work File for Integrity by Offset Account6W3AAAmountNumericGeneric Edit152
TOP04: Accounts Payable
4F045141099 Merged Worktables (F045141:F045143)5G1AAAmountNumericGeneric Edit152
5F0451411099 G/L Worktable5G1AAAmountNumericGeneric Edit152
6F0451431099 A/P Worktable5G1AAAmountNumericGeneric Edit152
7F0451451099 Securities Identification File4G2AAAmountNumericGeneric Edit152
8F0457A/P Payment Tape21KMAAAmountNumericGeneric Edit152
9F04614T5018 Tax File7CTAAAmountNumericGeneric Edit152
10F046141T5018 Tax Workfile6CUAAAmountNumericGeneric Edit152
11F04UI004Integrity Report Worktable6RPAAAmountNumericGeneric Edit152
TOP05T: Time Entry
12F063951Payroll Journal (Compressed) File19GLAAAmountNumericGeneric Edit152
TOP07: Payroll
13F05290WF - Payroll Journal (Detail)19JRAAAmountNumericGeneric Edit152
TOP09: General Accounting
14F0911PPurge - Account Ledger31GLAAAmountNumericGeneric Edit152
15F0911RWF - Account Ledger Reconciliation28GLAAAmountNumericGeneric Edit152
16F0911R1Account Reconciliations Header - OneWorld ONLY4GLAAAmountNumericGeneric Edit152
17F0911Z1Journal Entry Transactions - Batch File48VNAAAmountNumericGeneric Edit152
18F0911Z4F0911 Interoperability Table53SZAAAmountNumericGeneric Edit152
19F0912Cost Allocations/Flex Budgeting31RJAAAmountNumericGeneric Edit152
20F0912AIndex Computation Entry File27RIAAAmountNumericGeneric Edit152
21F09505WF - Bank File of Cleared Checks.4GNAAAmountNumericGeneric Edit152
22F09522Cash Forecast Data6FDAAAmountNumericGeneric Edit152
23F09611Electronic Bank Statement Staging Detail13BGAAAmountNumericGeneric Edit152
24F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY4GLAAAmountNumericGeneric Edit152
25F09UI013Company by Batch Out of Balance5GLAAAmountNumericGeneric Edit152
26F09UI015Indexed Computations Multi-Tiered Entries31GLAAAmountNumericGeneric Edit152
27F09UI123Advanced Variable Numerator Worktable20VWAAAmountNumericGeneric Edit152
28F09UI618Auto Bank Statement Process Work Table22NBAAAmountNumericGeneric Edit152
29F52G11Burdening Detail Ledger22BDAAAmountNumericGeneric Edit152
30F52G11WFTemporary Burdened Detail Ledger Workfile22BWAAAmountNumericGeneric Edit152
31F52G31WFReburdening Transactions Workfile7RBAAAmountNumericGeneric Edit152
32F52G60Burden Rate Calculations Workfile17BWAAAmountNumericGeneric Edit152
TOP10: Financial Reporting
33F10UI520Cash Flow Statement Worktable4CWAAAmountNumericGeneric Edit152
TOP12: Fixed Assets
34F12911ERPost G/L to FA Exceptions Work File9GLAAAmountNumericGeneric Edit152
TOP14: Modeling - Planning & Budgeting
35F1403Forecast Basis22BDAAAmountNumericGeneric Edit152
36F14041Forecast Results - Detail10BZAAAmountNumericGeneric Edit152
TOP15: Property Management
37F1532BExpense Participation Audit File12NTAAAmountNumericGeneric Edit152
38F1539AEP Billing Account Adjustments Audit11AUAAAmountNumericGeneric Edit152
TOP16: Profit Management (EPS)
39F1611Cost Calculation Transactions6CTAAAmountNumericGeneric Edit152
TOP31: Shop Floor Control
40F31UI802Accumulate Amounts by Account4WGAAAmountNumericGeneric Edit152
41F31UI803Work File for Summarizing Journal Entries4SGAAAmountNumericGeneric Edit152
42F31UI804Exception Report Work FIle8WRAAAmountNumericGeneric Edit152
TOP31B: Blend Management
43F31B31CBlend Lot Costs7BCAAAmountNumericGeneric Edit152
44F31B66Blend Transactions12BTAAAmountNumericGeneric Edit152
TOP38: Agreement Management
45F38011Agreement Quantities10DFAAAmountNumericGeneric Edit152
46F38012Product Source/Destination Master12DPAAAmountNumericGeneric Edit152
47F38013Agreement Quantities Schedule9DQAAAmountNumericGeneric Edit152
48F38111Agreements Transaction Ledger51DZAAAmountNumericGeneric Edit152
49F38112Agreements Committed Quantities13DXAAAmountNumericGeneric Edit152
TOP39: Advanced Stock Valuation
50F3910G/L Adjustment Table10SCAAAmountNumericGeneric Edit152
TOP42: Sales Management
51F42800G1Sales Update G Batch Detail Workfile10DGAAAmountNumericGeneric Edit152
TOP43: Procurement
52F40910Commitment Integrity Report Work File6P#AAAmountNumericGeneric Edit152
53F4314ZVoucher Match Selection File77PNAAAmountNumericGeneric Edit152
TOP44H: Homebuilder Management
54F44H590Closing Worksheet Accounting Instructions15CIAAAmountNumericGeneric Edit152
55F44H591Closing Worksheet Entries16CWAAAmountNumericGeneric Edit152
56F44H73W2Lot Start - Budget Generation Workfile7BGAAAmountNumericGeneric Edit152
TOP48: Work Order Processing
57F4827Work Order Approval Routing6W5AAAmountNumericGeneric Edit152
TOP48S: Service Billing
58F48096Billing Rate / Mark up Table16WQAAAmountNumericGeneric Edit152
59F4812Billing Detail Workfile56WDAAAmountNumericGeneric Edit152
60F4812HBilling Workfile History56WDAAAmountNumericGeneric Edit152
61F4812HSBilling Workfile History Purged Save56WDAAAmountNumericGeneric Edit152
62F4822Invoice Summary Work File42W4AAAmountNumericGeneric Edit152
63F4823Voucher Summary38W0AAAmountNumericGeneric Edit152
64F48520Invoice Summary Access23AEAAAmountNumericGeneric Edit152
65F48S910Billing Detail Journal Workfile30W2AAAmountNumericGeneric Edit152
66F48S911Summarized Journal Workfile26W3AAAmountNumericGeneric Edit152
67F48S912G/L Link17W6AAAmountNumericGeneric Edit152
68F48SUI01Billing Detail Print Workfile56WDAAAmountNumericGeneric Edit152
TOP49: Transportation Management
69F49595Document Print - Document Summary14DKAAAmountNumericGeneric Edit152
70F49695Document Register12DRAAAmountNumericGeneric Edit152
TOP51: Job Costing
71F51911Draw Reporting Master17GKAAAmountNumericGeneric Edit152
TOP52: Contract Billing
72F5216Milestone/Progress Billing Information11A6AAAmountNumericGeneric Edit152
73F5280WContract Revenue Summary Work File16GYAAAmountNumericGeneric Edit152
TOP52G: Government Contracting
74F4822HInvoice Summary History42IHAAAmountNumericGeneric Edit152
TOP55: Reserved for Clients
75F091102Saldi F0911 dell'anno 20023GLAAAmountNumericGeneric Edit152
76F550200Correspondent Accounts Report10WFAAAmountNumericGeneric Edit152
77F5574T12Cash Flow Table -BO4CFAAAmountNumericGeneric Edit152
78F5574T14New Credit Analysis Report -BO11CAAAAmountNumericGeneric Edit152
79F55C001Daily Check Collection6C1AAAmountNumericGeneric Edit152
80F55IF05Pozycje Budżetowe WF13WFAAAmountNumericGeneric Edit152
81F55IFN5Pozycje Budżetowe WF15WFAAAmountNumericGeneric Edit152
82F55IFP04Pozycje Budżetowe WF11WFAAAmountNumericGeneric Edit152
83F55IFPN4Pozycje Budżetowe WF13WFAAAmountNumericGeneric Edit152
84F55IFQUAWork file per quadrature F411114QUAAAmountNumericGeneric Edit152
85F55IFRTtabella esportazione11RTAAAmountNumericGeneric Edit152
86F55IFVABOutput File di R55IFVALB5OZAAAmountNumericGeneric Edit152
87F55IFVALOutput File di R55IFVALOR11FAAAAmountNumericGeneric Edit152
88F55IFWKFWork File F0911_wkf script ribaltamento costi8WFAAAmountNumericGeneric Edit152
89F55PREMIPremi a cliente5PRAAAmountNumericGeneric Edit152
90F55SCONTSconti a cliente11SCAAAmountNumericGeneric Edit152
91F55TR002Discount Table7TTAAAmountNumericGeneric Edit152
92F59BO001Cash Journal Master File5CJAAAmountNumericGeneric Edit152
93F59PO001Cash Journal Master File5CJAAAmountNumericGeneric Edit152
94F59PO00FCash Journal Final Accounts3FAAAAmountNumericGeneric Edit152
95F74H1001Hierarchical Summary Work Table5HWAAAmountNumericGeneric Edit152
96F74H105SSlovakian Invoice Accounting Summary13ASAAAmountNumericGeneric Edit152
97F74TL004Trial Balance Temp File14TBAAAmountNumericGeneric Edit152
98F74T531Customer Ledger Tranaction File16CTAAAmountNumericGeneric Edit152
99F74T532Supplier Ledger Transaction File6SLAAAmountNumericGeneric Edit152
100F74T550General Ledger Work File - Turkish29DKAAAmountNumericGeneric Edit152
101F74T133Customer Year End Table4CTAAAmountNumericGeneric Edit152
102F74T134Supplier Year End Table4STAAAmountNumericGeneric Edit152
TOP74: EMEA Localization
103F7430035Taxes by Legal Document Line - COMM - 03B8PIAAAmountNumericGeneric Edit152
104F743035Display Taxes by Legal Document Line - COMM - 03B10DTAAAmountNumericGeneric Edit152
105F74411Withholding Tax Detail - Italy33RSAAAmountNumericGeneric Edit152
TOP74R: CIS
106F74R5110F1201 Tag File - RUS - 12 - 74R9TFAAAmountNumericGeneric Edit152
107F74R9010Profit & Loss - RUS - 09 - 74R6PLAAAmountNumericGeneric Edit152
108F74R9011Correspondence Rules - RUS -09 - 74R18CRAAAmountNumericGeneric Edit152
109F74R9029Open Accounts - RUS - 09 - 74R14OAAAAmountNumericGeneric Edit152
110F74R9030Balance Sheet - RUS - 09 - 74R6BSAAAmountNumericGeneric Edit152
111F74R9040Changes in Equity - RUS - 09 - 74R6CEAAAmountNumericGeneric Edit152
TOP74U: United Kingdom Localizations
112F74U0408SPC Lower Level Retention - UK - 439LRAAAmountNumericGeneric Edit152
113F74U0409SPC Lower Level MCD - UK - 439LMAAAmountNumericGeneric Edit152
114F74U0445SPC Accounts Payable Match Doc Detail Tag File - UK - 4312RNAAAmountNumericGeneric Edit152
TOP74Z: Czech Republic
115F74Z0010Cash Desk Document Printed - CZE - 74Z11ZOAAAmountNumericGeneric Edit152
116F74ZUI01Corresponding Accounts7CZAAAmountNumericGeneric Edit152
TOP75A: Australia - Reporting System Only
117F75A0220Payment Summary Workfile21PSAAAmountNumericGeneric Edit152
TOP75C: China - Reporting System Only
118F75C014AP/AR Balances - China9BAAAAmountNumericGeneric Edit152
119F75C015Cash Flow Data - China24CFAAAmountNumericGeneric Edit152
120F75C202Asset Disposal Amounts - CHINA10DAAAAmountNumericGeneric Edit152
121F75C910China Reports Balance -CNAO V27CFAAAmountNumericGeneric Edit152
TOP75I: India
122F75I100TDS Ceritificate Master Maintenance12QBAAAmountNumericGeneric Edit152
123F75I100QTDS Form 26Q - WorkFile (Quarterly)13EFAAAmountNumericGeneric Edit152
124F75I100WTDS Form 26 - WorkFile13EFAAAmountNumericGeneric Edit152
125F75I101TDS Certificate Work Maintenance13QBAAAmountNumericGeneric Edit152
126F75I119TChallan number wise amount2CNAAAmountNumericGeneric Edit152
127F75I2241WorkFile for VAT/CST Receivables15VCAAAmountNumericGeneric Edit152
128F75I2242VAT- Deferred Amounts for the Purchase cycle11DAAAAmountNumericGeneric Edit152
129F75I3051Excise Fiscal Years13FYAAAmountNumericGeneric Edit152
130F75I322Excise - Work File for F04211 & F410120Q3AAAmountNumericGeneric Edit152
131F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)24Q3AAAmountNumericGeneric Edit152
132F75I344CARE-1 Bond Register for Cancelled Receipts-IND-0016CDAAAmountNumericGeneric Edit152
133F75I382Amount of Interest Paid per month - IND - 006IPAAAmountNumericGeneric Edit152
134F75I421Assign Price / Cost Elements5MAAAAmountNumericGeneric Edit152
135F75I4223Sales Tax Summary/Detail34SDAAAmountNumericGeneric Edit152
136F75I732Service Tax A/R File Additional Info - IND - 03B11STAAAmountNumericGeneric Edit152
137F75I742Service Tax A/P File Additional Info - IND - 0412STAAAmountNumericGeneric Edit152
TOP75J: Japan - Reporting System Only
138F750411Withholding Tax Detail - Japan - 0417JXAAAmountNumericGeneric Edit152
TOP76A: Argentina
139F760499AContract Withholding - Advances - ARG -04 - 76A5K8AAAmountNumericGeneric Edit152
140F76A20Credit Invoice Constants - ARG - 03B - 76A8ICAAAmountNumericGeneric Edit152
141F76A42CERG G/L - Work File - ARG - 09 - 76A6TFAAAmountNumericGeneric Edit152
142F76AUI98Cost Account Work Table - Work in Progress Adjustment - 76A6CAAAAmountNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
143F7603B1A/R Additional Information - Brazil - 03B7CIAAAmountNumericGeneric Edit152
144F7603B1PArchive A/R Additional Information - Brazil - 03B7BPAAAmountNumericGeneric Edit152
145F76B0402IR Progressive - 041TPAAAmountNumericGeneric Edit152
146F76B0411Voucher Additional Information Brazil - 0415VBAAAmountNumericGeneric Edit152
147F76B0540Brazil Electronic Reporting Block B Worktable14BWAAAmountNumericGeneric Edit152
148F76B10Account Ledger - IN68 - 097ARAAAmountNumericGeneric Edit152
149F76B411APIS - COFINS and CSLL bellow minimum - BR - 047WMAAAmountNumericGeneric Edit152
150F76B473TF04573 Brazilian Temp WH File - BR - 0417W3AAAmountNumericGeneric Edit152
151F76B64Balances/JEs w/ Currency Correction Table - IN68 - 1210BSAAAmountNumericGeneric Edit152
152F76B911IN86-Work Table for Journal Entries - 099BDAAAmountNumericGeneric Edit152
TOP76H: Chile
153F76H3B37A/R Document Line (Print Info) - CHI - 03B - 76H7PIAAAmountNumericGeneric Edit152
154F76H3B40A/P Document Line (Print Info) - CHI - 047PIAAAmountNumericGeneric Edit152
155F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H23I1AAAmountNumericGeneric Edit152
TOP76M: Mexico
156F76M413Manual Payment Header Additional Details - MEX - 049MWAAAmountNumericGeneric Edit152
157F76M414A/P Matching Detail Withholding Information - MEX - 045MWAAAmountNumericGeneric Edit152
158F76M572A/P Header Withholding Summary Details - MEX - 047WSAAAmountNumericGeneric Edit152
159F76M573PCG Detail Withholding Amounts - MEX - 0411WDAAAmountNumericGeneric Edit152
TOP76V: Venezuela
160F76V4010Tributary Unit Setup - 04 - VE4ISAAAmountNumericGeneric Edit152
161F76VLC01Purchase Register Temporal - VEN -04 - 76V5LCAAAmountNumericGeneric Edit152
TOP80D: Plant Manager Dashboard
162F80D221General Ledger Aggregate Table4GLAAAmountNumericGeneric Edit152
TOP83: Management Reporting - FASTR
163F83UI001Balance Audit Work File - (Financial Reporting)16R1AAAmountNumericGeneric Edit152
TOP89: Conversion Programs
164F06116TNeeded for upgrade from Xe to B96YTAAAmountNumericGeneric Edit152
165F06116TZNeeded for upgrade from Xe to B97VLAAAmountNumericGeneric Edit152
166F0618TNeeded for upgrade from Xe to B96YTAAAmountNumericGeneric Edit152
TOPF31: Lean Transactions
167FF31113Lean Transaction Labor Detail52LDAAAmountNumericGeneric Edit152
168FF31113SPurge - Lean Transaction Labor Detail52LRAAAmountNumericGeneric Edit152