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

149 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
76F74H1001Hierarchical Summary Work Table5HWAAAmountNumericGeneric Edit152
77F74H105SSlovakian Invoice Accounting Summary13ASAAAmountNumericGeneric Edit152
78F74TL004Trial Balance Temp File14TBAAAmountNumericGeneric Edit152
79F74T531Customer Ledger Tranaction File16CTAAAmountNumericGeneric Edit152
80F74T532Supplier Ledger Transaction File6SLAAAmountNumericGeneric Edit152
81F74T550General Ledger Work File - Turkish29DKAAAmountNumericGeneric Edit152
82F74T133Customer Year End Table4CTAAAmountNumericGeneric Edit152
83F74T134Supplier Year End Table4STAAAmountNumericGeneric Edit152
TOP74: EMEA Localization
84F7430035Taxes by Legal Document Line - COMM - 03B8PIAAAmountNumericGeneric Edit152
85F743035Display Taxes by Legal Document Line - COMM - 03B10DTAAAmountNumericGeneric Edit152
86F74411Withholding Tax Detail - Italy33RSAAAmountNumericGeneric Edit152
TOP74R: CIS
87F74R5110F1201 Tag File - RUS - 12 - 74R9TFAAAmountNumericGeneric Edit152
88F74R9010Profit & Loss - RUS - 09 - 74R6PLAAAmountNumericGeneric Edit152
89F74R9011Correspondence Rules - RUS -09 - 74R18CRAAAmountNumericGeneric Edit152
90F74R9029Open Accounts - RUS - 09 - 74R14OAAAAmountNumericGeneric Edit152
91F74R9030Balance Sheet - RUS - 09 - 74R6BSAAAmountNumericGeneric Edit152
92F74R9040Changes in Equity - RUS - 09 - 74R6CEAAAmountNumericGeneric Edit152
TOP74U: United Kingdom Localizations
93F74U0408SPC Lower Level Retention - UK - 439LRAAAmountNumericGeneric Edit152
94F74U0409SPC Lower Level MCD - UK - 439LMAAAmountNumericGeneric Edit152
95F74U0445SPC Accounts Payable Match Doc Detail Tag File - UK - 4312RNAAAmountNumericGeneric Edit152
TOP74Z: Czech Republic
96F74Z0010Cash Desk Document Printed - CZE - 74Z11ZOAAAmountNumericGeneric Edit152
97F74ZUI01Corresponding Accounts7CZAAAmountNumericGeneric Edit152
TOP75A: Australia - Reporting System Only
98F75A0220Payment Summary Workfile21PSAAAmountNumericGeneric Edit152
TOP75C: China - Reporting System Only
99F75C014AP/AR Balances - China9BAAAAmountNumericGeneric Edit152
100F75C015Cash Flow Data - China24CFAAAmountNumericGeneric Edit152
101F75C202Asset Disposal Amounts - CHINA10DAAAAmountNumericGeneric Edit152
102F75C910China Reports Balance -CNAO V27CFAAAmountNumericGeneric Edit152
TOP75I: India
103F75I100TDS Ceritificate Master Maintenance12QBAAAmountNumericGeneric Edit152
104F75I100QTDS Form 26Q - WorkFile (Quarterly)13EFAAAmountNumericGeneric Edit152
105F75I100WTDS Form 26 - WorkFile13EFAAAmountNumericGeneric Edit152
106F75I101TDS Certificate Work Maintenance13QBAAAmountNumericGeneric Edit152
107F75I119TChallan number wise amount2CNAAAmountNumericGeneric Edit152
108F75I2241WorkFile for VAT/CST Receivables15VCAAAmountNumericGeneric Edit152
109F75I2242VAT- Deferred Amounts for the Purchase cycle11DAAAAmountNumericGeneric Edit152
110F75I3051Excise Fiscal Years13FYAAAmountNumericGeneric Edit152
111F75I322Excise - Work File for F04211 & F410120Q3AAAmountNumericGeneric Edit152
112F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)24Q3AAAmountNumericGeneric Edit152
113F75I344CARE-1 Bond Register for Cancelled Receipts-IND-0016CDAAAmountNumericGeneric Edit152
114F75I382Amount of Interest Paid per month - IND - 006IPAAAmountNumericGeneric Edit152
115F75I421Assign Price / Cost Elements5MAAAAmountNumericGeneric Edit152
116F75I4223Sales Tax Summary/Detail34SDAAAmountNumericGeneric Edit152
117F75I732Service Tax A/R File Additional Info - IND - 03B11STAAAmountNumericGeneric Edit152
118F75I742Service Tax A/P File Additional Info - IND - 0412STAAAmountNumericGeneric Edit152
TOP75J: Japan - Reporting System Only
119F750411Withholding Tax Detail - Japan - 0417JXAAAmountNumericGeneric Edit152
TOP76A: Argentina
120F760499AContract Withholding - Advances - ARG -04 - 76A5K8AAAmountNumericGeneric Edit152
121F76A20Credit Invoice Constants - ARG - 03B - 76A8ICAAAmountNumericGeneric Edit152
122F76A42CERG G/L - Work File - ARG - 09 - 76A6TFAAAmountNumericGeneric Edit152
123F76AUI98Cost Account Work Table - Work in Progress Adjustment - 76A6CAAAAmountNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
124F7603B1A/R Additional Information - Brazil - 03B7CIAAAmountNumericGeneric Edit152
125F7603B1PArchive A/R Additional Information - Brazil - 03B7BPAAAmountNumericGeneric Edit152
126F76B0402IR Progressive - 041TPAAAmountNumericGeneric Edit152
127F76B0411Voucher Additional Information Brazil - 0415VBAAAmountNumericGeneric Edit152
128F76B0540Brazil Electronic Reporting Block B Worktable14BWAAAmountNumericGeneric Edit152
129F76B10Account Ledger - IN68 - 097ARAAAmountNumericGeneric Edit152
130F76B411APIS - COFINS and CSLL bellow minimum - BR - 047WMAAAmountNumericGeneric Edit152
131F76B473TF04573 Brazilian Temp WH File - BR - 0417W3AAAmountNumericGeneric Edit152
132F76B64Balances/JEs w/ Currency Correction Table - IN68 - 1210BSAAAmountNumericGeneric Edit152
133F76B911IN86-Work Table for Journal Entries - 099BDAAAmountNumericGeneric Edit152
TOP76H: Chile
134F76H3B37A/R Document Line (Print Info) - CHI - 03B - 76H7PIAAAmountNumericGeneric Edit152
135F76H3B40A/P Document Line (Print Info) - CHI - 047PIAAAmountNumericGeneric Edit152
136F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H23I1AAAmountNumericGeneric Edit152
TOP76M: Mexico
137F76M413Manual Payment Header Additional Details - MEX - 049MWAAAmountNumericGeneric Edit152
138F76M414A/P Matching Detail Withholding Information - MEX - 045MWAAAmountNumericGeneric Edit152
139F76M572A/P Header Withholding Summary Details - MEX - 047WSAAAmountNumericGeneric Edit152
140F76M573PCG Detail Withholding Amounts - MEX - 0411WDAAAmountNumericGeneric Edit152
TOP76V: Venezuela
141F76V4010Tributary Unit Setup - 04 - VE4ISAAAmountNumericGeneric Edit152
142F76VLC01Purchase Register Temporal - VEN -04 - 76V5LCAAAmountNumericGeneric Edit152
TOP80D: Plant Manager Dashboard
143F80D221General Ledger Aggregate Table4GLAAAmountNumericGeneric 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