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
3F0911GLAccount Ledger
4F4101IMItem Master
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

123 columns | Print definition?812 | 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
4F04514WF - 1099 Combined Workfile (Merge of F045141 and F045143)5G1AAAmountNumericGeneric Edit152
5F045141WF - 1099 G/L Workfile5G1AAAmountNumericGeneric Edit152
6F045143WF - 1099 A/P WorkFile5G1AAAmountNumericGeneric Edit152
7F0457A/P Payment Tape File21KMAAAmountNumericGeneric Edit152
8F04UI004Integrity Report Table F04UI0046RPAAAmountNumericGeneric Edit152
TOP05T: Time Entry
9F063951Payroll Journal (Compressed) File19GLAAAmountNumericGeneric Edit152
TOP07: Payroll
10F05290WF - Payroll Journal (Detail)19JRAAAmountNumericGeneric Edit152
TOP09: General Accounting
11F0911PPurge - Account Ledger31GLAAAmountNumericGeneric Edit152
12F0911RWF - Acct Ledger File for Reconciliation28GLAAAmountNumericGeneric Edit152
13F0911R1Account Reconciliations Header - OneWorld ONLY4GLAAAmountNumericGeneric Edit152
14F0911Z1Journal Entry Transactions - Batch File48VNAAAmountNumericGeneric Edit152
15F0911Z4F0911 Interoperability Table53SZAAAmountNumericGeneric Edit152
16F0912Cost Allocations/Flex Budgeting31RJAAAmountNumericGeneric Edit152
17F0912AIndex Computation Entry File27RIAAAmountNumericGeneric Edit152
18F09505WF - Bank File of Cleared Checks.4GNAAAmountNumericGeneric Edit152
19F09522Cash Forecast Data6FDAAAmountNumericGeneric Edit152
20F09611Electronic Bank Statement Staging Detail13BGAAAmountNumericGeneric Edit152
21F09UI007Match Bank Tape to Recon File - ONE WORLD ONLY4GLAAAmountNumericGeneric Edit152
22F09UI013Company by Batch Out of Balance5GLAAAmountNumericGeneric Edit152
23F09UI015Indexed Computations Multi-Tiered Entries31GLAAAmountNumericGeneric Edit152
24F09UI618Auto Bank Statement Process Work Table22NBAAAmountNumericGeneric Edit152
TOP10: Financial Reporting
25F10UI520Cash Flow Statement Worktable4CWAAAmountNumericGeneric Edit152
TOP12: Fixed Assets
26F12911ERPost G/L to FA Exceptions Work File9GLAAAmountNumericGeneric Edit152
TOP14: Modeling - Planning & Budgeting
27F1403Forecast Basis22BDAAAmountNumericGeneric Edit152
28F14041Forecast Results - Detail10BZAAAmountNumericGeneric Edit152
TOP15: Property Management
29F1532BExpense Participation Audit File12NTAAAmountNumericGeneric Edit152
TOP16: Profit Management (EPS)
30F1611Cost Calculation Transactions6CTAAAmountNumericGeneric Edit152
TOP31: Shop Floor Control
31F31UI802Accumulate Amounts by Account4WGAAAmountNumericGeneric Edit152
32F31UI803Work File for Summarizing Journal Entries4SGAAAmountNumericGeneric Edit152
33F31UI804Exception Report Work FIle8WRAAAmountNumericGeneric Edit152
TOP31B: Blend Management
34F31B31CBlend Lot Costs7BCAAAmountNumericGeneric Edit152
35F31B66Blend Transactions12BTAAAmountNumericGeneric Edit152
TOP38: Agreement Management
36F38011Agreement Quantities10DFAAAmountNumericGeneric Edit152
37F38012Product Source/Destination Master12DPAAAmountNumericGeneric Edit152
38F38013Agreement Quantities Schedule9DQAAAmountNumericGeneric Edit152
39F38111Agreements Transaction Ledger51DZAAAmountNumericGeneric Edit152
40F38112Agreements Committed Quantities13DXAAAmountNumericGeneric Edit152
TOP39: Advanced Stock Valuation
41F3910G/L Adjustment Table10SCAAAmountNumericGeneric Edit152
TOP42: Sales Management
42F42800G1Sales Update G Batch Detail Workfile10DGAAAmountNumericGeneric Edit152
TOP43: Procurement
43F40910Commitment Integrity Report Work File6P#AAAmountNumericGeneric Edit152
44F4314ZVoucher Match Selection File77PNAAAmountNumericGeneric Edit152
TOP44H: Homebuilder Management
45F44H590Closing Worksheet Accounting Instructions15CIAAAmountNumericGeneric Edit152
46F44H591Closing Worksheet Entries16CWAAAmountNumericGeneric Edit152
47F44H73W2Lot Start - Budget Generation Workfile7BGAAAmountNumericGeneric Edit152
TOP48: Work Order Processing
48F4827Work Order Approval Routing6W5AAAmountNumericGeneric Edit152
TOP48S: Service Billing
49F48096Billing Rate / Mark up Table16WQAAAmountNumericGeneric Edit152
50F4812Billing Detail Workfile56WDAAAmountNumericGeneric Edit152
51F4812HBilling Workfile - History56WDAAAmountNumericGeneric Edit152
52F4812HSBilling Workfile History Purged Save56WDAAAmountNumericGeneric Edit152
53F4822Invoice Summary Work File42W4AAAmountNumericGeneric Edit152
54F4823Voucher Summary38W0AAAmountNumericGeneric Edit152
55F48520Invoice Summary Access23AEAAAmountNumericGeneric Edit152
56F48S910Billing Detail Journal File30W2AAAmountNumericGeneric Edit152
57F48S911Compressed Journal File26W3AAAmountNumericGeneric Edit152
58F48S912G/L Link File17W6AAAmountNumericGeneric Edit152
59F48SUI01Billing Detail Print Workfile56WDAAAmountNumericGeneric Edit152
TOP49: Transportation Management
60F49595Document Print - Document Summary14DKAAAmountNumericGeneric Edit152
61F49695Document Register12DRAAAmountNumericGeneric Edit152
TOP51: Job Costing
62F51911Draw Reporting Master17GKAAAmountNumericGeneric Edit152
TOP52: Contract Billing
63F5216Milestone/Progress Billing Information11A6AAAmountNumericGeneric Edit152
64F5280WContract Revenue Summary Work File16GYAAAmountNumericGeneric Edit152
TOP55: Reserved for Clients
65F091102Saldi F0911 dell'anno 20023GLAAAmountNumericGeneric Edit152
66F550200Correspondent Accounts Report10WFAAAmountNumericGeneric Edit152
67F5574T12Cash Flow Table -BO4CFAAAmountNumericGeneric Edit152
68F5574T14New Credit Analysis Report -BO11CAAAAmountNumericGeneric Edit152
69F55C001Daily Check Collection6C1AAAmountNumericGeneric Edit152
70F55IFP04Pozycje Budżetowe WF11WFAAAmountNumericGeneric Edit152
71F55IFQUAWork file per quadrature F411114QUAAAmountNumericGeneric Edit152
72F55IFRTtabella esportazione11RTAAAmountNumericGeneric Edit152
73F55IFVABOutput File di R55IFVALB5OZAAAmountNumericGeneric Edit152
74F55IFVALOutput File di R55IFVALOR11FAAAAmountNumericGeneric Edit152
75F55IFWKFWork File F0911_wkf script ribaltamento costi8WFAAAmountNumericGeneric Edit152
76F55PREMIPremi a cliente5PRAAAmountNumericGeneric Edit152
77F55SCONTSconti a cliente11SCAAAmountNumericGeneric Edit152
78F55TR002Discount Table7TTAAAmountNumericGeneric Edit152
79F59BO001Cash Journal Master File5CJAAAmountNumericGeneric Edit152
80F59PO001Cash Journal Master File5CJAAAmountNumericGeneric Edit152
81F59PO00FCash Journal Final Accounts3FAAAAmountNumericGeneric Edit152
82F74H1001Hierarchical Summary Work Table5HWAAAmountNumericGeneric Edit152
83F74H105SSlovakian Invoice Accounting Summary13ASAAAmountNumericGeneric Edit152
84F74TL004Trial Balance Temp File14TBAAAmountNumericGeneric Edit152
85F74T531Customer Ledger Tranaction File16CTAAAmountNumericGeneric Edit152
86F74T532Supplier Ledger Transaction File6SLAAAmountNumericGeneric Edit152
87F74T550General Ledger Work File - Turkish29DKAAAmountNumericGeneric Edit152
88F74T133Customer Year End Table4CTAAAmountNumericGeneric Edit152
89F74T134Supplier Year End Table4STAAAmountNumericGeneric Edit152
TOP74: EMEA Localization
90F7430035Taxes by Legal Document Line - COMM - 03B8PIAAAmountNumericGeneric Edit152
91F74411Withholding Tax Detail File-Italy33RSAAAmountNumericGeneric Edit152
TOP74R: CIS
92F74R5110F1201 Tag File - RUS - 12 - 74R9TFAAAmountNumericGeneric Edit152
93F74R9010Profit and Loss - RUS - 09 - 74R6PLAAAmountNumericGeneric Edit152
94F74R9011Correspondence Rules - RUS -09 - 74R18CRAAAmountNumericGeneric Edit152
95F74R9029Open Accounts - RUS - 09 - 74R14OAAAAmountNumericGeneric Edit152
96F74R9030Balance Sheet - RUS - 09 - 74R6BSAAAmountNumericGeneric Edit152
97F74R9040Changes in Equity - RUS - 09 - 74R6CEAAAmountNumericGeneric Edit152
TOP75A: Australia - Reporting System Only
98F75A0220Payment Summary Workfile21PSAAAmountNumericGeneric Edit152
TOP75J: Japan - Reporting System Only
99F750411Withholding Tax Detail Table - Japan17JXAAAmountNumericGeneric Edit152
TOP76A: Argentina
100F760499AContract Withholding - Advances - ARG -04 - 045K8AAAmountNumericGeneric Edit152
101F76A20Credit Invoice Constants - ARG - 03B - 76A8ICAAAmountNumericGeneric Edit152
102F76A42CERG G/L - Work File - ARG - 09 - 096TFAAAmountNumericGeneric Edit152
103F76AUI98Cost Account Work Table - Work in Progress Adjustment - 76A6CAAAAmountNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
104F7603B1A/R Additional Information - Brazil7CIAAAmountNumericGeneric Edit152
105F7603B1PArchive A/R Additional Information - Brazil - 03B7BPAAAmountNumericGeneric Edit152
106F76B0402IR Progressive - 041TPAAAmountNumericGeneric Edit152
107F76B0411Voucher Additional Information Brazil - 0415VBAAAmountNumericGeneric Edit152
108F76B10Account Ledger - IN68 - 097ARAAAmountNumericGeneric Edit152
109F76B411APIS - COFINS and CSLL bellow minimum - BR - 047WMAAAmountNumericGeneric Edit152
110F76B473TF04573 Brazilian Temp WH File - BR - 0417W3AAAmountNumericGeneric Edit152
111F76B64Balances/JE's w/ Currency Correction Table - IN68 - 1210BSAAAmountNumericGeneric Edit152
112F76B911IN86-Work Table for Journal Entries - 099BDAAAmountNumericGeneric Edit152
TOP76H: Chile
113F76H3B37A/R Document Line (Print Info) - CHI - 03B - 76H7PIAAAmountNumericGeneric Edit152
114F76H3B40A/P Document Line (Print Info) - CHI - 047PIAAAmountNumericGeneric Edit152
115F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H23I1AAAmountNumericGeneric Edit152
TOP76V: Venezuela
116F76V4010Tributary Unit Setup - 04 - VE4ISAAAmountNumericGeneric Edit152
117F76VLC01Purchase Register Temporal - VEN -04 - 76V5LCAAAmountNumericGeneric Edit152
TOP83: Management Reporting - FASTR
118F83UI001Balance Audit Work File - (Financial Reporting)16R1AAAmountNumericGeneric Edit152
TOP89: Conversion Programs
119F06116TNeeded for upgrade from Xe to B96YTAAAmountNumericGeneric Edit152
120F06116TZNeeded for upgrade from Xe to B97VLAAAmountNumericGeneric Edit152
121F0618TNeeded for upgrade from Xe to B96YTAAAmountNumericGeneric Edit152
TOPF31: Lean Transactions
122FF31113Lean Transaction Labor Detail52LDAAAmountNumericGeneric Edit152
123FF31113SPurge - Lean Transaction Labor Detail52LRAAAmountNumericGeneric Edit152