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

149 columns | Print definition?920 | AA

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