JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
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
10F4111ILItem Ledger File

812: Top 10 requests

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

107 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
66F74H1001Hierarchical Summary Work Table5HWAAAmountNumericGeneric Edit152
67F74H105SSlovakian Invoice Accounting Summary13ASAAAmountNumericGeneric Edit152
68F74TL004Trial Balance Temp File14TBAAAmountNumericGeneric Edit152
69F74T531Customer Ledger Tranaction File16CTAAAmountNumericGeneric Edit152
70F74T532Supplier Ledger Transaction File6SLAAAmountNumericGeneric Edit152
71F74T550General Ledger Work File - Turkish29DKAAAmountNumericGeneric Edit152
72F74T133Customer Year End Table4CTAAAmountNumericGeneric Edit152
73F74T134Supplier Year End Table4STAAAmountNumericGeneric Edit152
TOP74: EMEA Localization
74F7430035Taxes by Legal Document Line - COMM - 03B8PIAAAmountNumericGeneric Edit152
75F74411Withholding Tax Detail File-Italy33RSAAAmountNumericGeneric Edit152
TOP74R: CIS
76F74R5110F1201 Tag File - RUS - 12 - 74R9TFAAAmountNumericGeneric Edit152
77F74R9010Profit and Loss - RUS - 09 - 74R6PLAAAmountNumericGeneric Edit152
78F74R9011Correspondence Rules - RUS -09 - 74R18CRAAAmountNumericGeneric Edit152
79F74R9029Open Accounts - RUS - 09 - 74R14OAAAAmountNumericGeneric Edit152
80F74R9030Balance Sheet - RUS - 09 - 74R6BSAAAmountNumericGeneric Edit152
81F74R9040Changes in Equity - RUS - 09 - 74R6CEAAAmountNumericGeneric Edit152
TOP75A: Australia - Reporting System Only
82F75A0220Payment Summary Workfile21PSAAAmountNumericGeneric Edit152
TOP75J: Japan - Reporting System Only
83F750411Withholding Tax Detail Table - Japan17JXAAAmountNumericGeneric Edit152
TOP76A: Argentina
84F760499AContract Withholding - Advances - ARG -04 - 045K8AAAmountNumericGeneric Edit152
85F76A20Credit Invoice Constants - ARG - 03B - 76A8ICAAAmountNumericGeneric Edit152
86F76A42CERG G/L - Work File - ARG - 09 - 096TFAAAmountNumericGeneric Edit152
87F76AUI98Cost Account Work Table - Work in Progress Adjustment - 76A6CAAAAmountNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
88F7603B1A/R Additional Information - Brazil7CIAAAmountNumericGeneric Edit152
89F7603B1PArchive A/R Additional Information - Brazil - 03B7BPAAAmountNumericGeneric Edit152
90F76B0402IR Progressive - 041TPAAAmountNumericGeneric Edit152
91F76B0411Voucher Additional Information Brazil - 0415VBAAAmountNumericGeneric Edit152
92F76B10Account Ledger - IN68 - 097ARAAAmountNumericGeneric Edit152
93F76B411APIS - COFINS and CSLL bellow minimum - BR - 047WMAAAmountNumericGeneric Edit152
94F76B473TF04573 Brazilian Temp WH File - BR - 0417W3AAAmountNumericGeneric Edit152
95F76B64Balances/JE's w/ Currency Correction Table - IN68 - 1210BSAAAmountNumericGeneric Edit152
96F76B911IN86-Work Table for Journal Entries - 099BDAAAmountNumericGeneric Edit152
TOP76H: Chile
97F76H3B37A/R Document Line (Print Info) - CHI - 03B - 76H7PIAAAmountNumericGeneric Edit152
98F76H3B40A/P Document Line (Print Info) - CHI - 047PIAAAmountNumericGeneric Edit152
99F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H23I1AAAmountNumericGeneric Edit152
TOP76V: Venezuela
100F76V4010Tributary Unit Setup - 04 - VE4ISAAAmountNumericGeneric Edit152
101F76VLC01Purchase Register Temporal - VEN -04 - 76V5LCAAAmountNumericGeneric Edit152
TOP83: Management Reporting - FASTR
102F83UI001Balance Audit Work File - (Financial Reporting)16R1AAAmountNumericGeneric Edit152
TOP89: Conversion Programs
103F06116TNeeded for upgrade from Xe to B96YTAAAmountNumericGeneric Edit152
104F06116TZNeeded for upgrade from Xe to B97VLAAAmountNumericGeneric Edit152
105F0618TNeeded for upgrade from Xe to B96YTAAAmountNumericGeneric Edit152
TOPF31: Lean Transactions
106FF31113Lean Transaction Labor Detail52LDAAAmountNumericGeneric Edit152
107FF31113SPurge - Lean Transaction Labor Detail52LRAAAmountNumericGeneric Edit152