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

119 columns | Print definition?812 | ANI

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0901WSAccount - Word Search3WSANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
2F0911Account Ledger14GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP03B: Enhanced Accounts Receivable
3F03BUI04Work File for Integrity by Offset Account2W3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
4F09UI011Receipt Prepost Work File9GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP04: Accounts Payable
5F04UI004Integrity Report Table F04UI0042RPANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
6F09UI005Tax Offsets User Index31GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP05T: Time Entry
7F06116Employee Transaction Detail File98YTANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
8F06116Z1Employee Transactions - Batch File112VLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
9F06278Retro Timecard Detail File98YTANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
10F06290Payroll Accounting Journal Work File23YRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
11F063951Payroll Journal (Compressed) File3GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
12F069136Tip Disbursement14JEANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP07: Payroll
13F05290WF - Payroll Journal (Detail)3JRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
14F06270Retro Processing Parameter19JPANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
15F06490Payroll/Accounts Payable Ledger Detail6JRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
16F06491Payroll/Accounts Payable Ledger Detail6J6ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
17F0716701Employee Assignment T/E Template Information3EAANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
18F0716709Employee Assignment T/E Template Info History3EAANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
19F07490Payroll - Accounts Payable Detail (One World)6JRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
20F07491Payroll - Accounts Payable Summary File6J6ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP09: General Accounting
21F0911PPurge - Account Ledger14GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
22F0911RWF - Acct Ledger File for Reconciliation14GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
23F0911Z1Journal Entry Transactions - Batch File31VNANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
24F0911Z4F0911 Interoperability Table36SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
25F0912Cost Allocations/Flex Budgeting15RJANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
26F0912AIndex Computation Entry File11RIANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
27F0912BVariable Allocation File12R#ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
28F0917Bank Statement Detail33GDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
29F09617Auto Bank Statement Detail9GMANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
30F09UI015Indexed Computations Multi-Tiered Entries14GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
31F09UI016Account Balance Compare Exceptions14GWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP10: Financial Reporting
32F10UI003Dynamically Created Accounts6ACANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP12: Fixed Assets
33F12911ERPost G/L to FA Exceptions Work File5GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP17C: Call Management
34F1760Time Entry16ZBANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP18: Resource Scheduling
35F186301Timecard Templates8TTANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
36F186602Labor Rules Tag File104TFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP31: Shop Floor Control
37F31UI802Accumulate Amounts by Account2WGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
38F31UI803Work File for Summarizing Journal Entries2SGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
39F31UI804Exception Report Work FIle2WRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP39: Advanced Stock Valuation
40F3910G/L Adjustment Table9SCANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP40: Inventory/OP Base
41F4011ZBatch Receiver File - Order Details192SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
42F49211Sales Order Detail File - Tag File127UDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
43F49211Z1Sales Order Detail Tag Unedited Transaction File146S1ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
44F49219Sales Order Detail - Tag History File104UDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP41: Inventory Management
45F41UI001Inventory Transactions Detail File165ITANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP42: Sales Management
46F42800G1Sales Update G Batch Detail Workfile11DGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
47F470371TTag for F470371- EDI shipping Notice Detail - Outbound5UZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP42B: Sales Order Entry
48F49299S.O. Detail Tag Ledger File127UDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43: Procurement
49F43080Approvals Fields Constants129PDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
50F4311Purchase Order Detail File125PDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
51F4311ZPurchase Order Generator File129PWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
52F4311Z1Purchase Order Detail Unedited Transaction Table138SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
53F43121Purchase Order Receiver File48PRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
54F43121Z1Receipts Unedited Transaction Table65SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
55F4314ZVoucher Match Selection File147PNANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
56F4316Purchase Order Multiple Account File7P3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
57F4316TPurchase Order Multiple Account Tag File7P3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
58F43199P.O. Detail Ledger File - Flexible Version125OLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
59F43UI50DPO Print Detail Work File36PWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43A: Purchase Order Receipt/Routing
60F43126Purchase Order Receiver Multiple Account10P4ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
61F43126TPurchase Order Receiver Multiple Account Tag File14P4ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43B: Voucher Match and Landed Cost
62F43146TVoucher Match Multiple Account Tag File8P5ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43C: Contracts
63F43C30Assessment Donations14ADANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43E: Requisition Self Service
64F43E16Requisition Multiple Account File7P3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43Q: Strategic Sourcing
65F43Q11Event Detail12EDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP44H: Homebuilder Management
66F44H611Bid Details8BDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
67F44H611WBid Details Work File12BWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
68F44H711Lot Start Workfile72SWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
69F44H711ZHB Lot Start Unedited Transaction File85SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
70F44H71W1Lot Start Generation Workfile72GWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
71F44H73W1Lot Start - P.O. / Committment Generation Work File44CGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP45: Advanced Pricing
72F4575Ship and Debit History54AHANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
73F4575TMPShip and Debit History - Temp Table54AHANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
74F4576Ship and Debit Claims82ACANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
75F4576TMPShip and Debit Claims- Temp Table82ACANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
76F4576Z1Ship and Debit Claims Unedited Transaction Table79Z1ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP47: Electronic Commerce
77F47012EDI Purchase Order Detail - Inbound193SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
78F47017EDI Purchase Order Detail - Outbound139SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
79F47022EDI P.O. Acknowledgment Detail - Inbound139SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
80F47027EDI P.O. Acknowledgment Detail - Outbound193SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
81F47042EDI Invoice Detail - Inbound49SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
82F47047EDI Invoice Detail (Sales) - Outbound193SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
83F47072EDI Receiving Advice Detail - Inbound140SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
84F47077EDI Receiving Advice Detail - Outbound140SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
85F47092EDI Request for Quote Detail - Inbound193SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
86F47097EDI Request for Quote Detail - Outbound139SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
87F47102EDI Response to RFQ Detail - Inbound139SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
88F47107EDI Response to RFQ Detail - Outbound192SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
89F47122EDI Product Activity Data Detail - Inbound68MJANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
90F47127EDI Product Activity Data Detail - Outbound68MJANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
91F47132EDI Purchase Order Change Detail - Inbound194SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
92F47137EDI Purchase Order Change Detail - Outbound140SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
93F47142EDI P.O. Change Acknowledgment Detail - Inbound141SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
94F47147EDI P.O. Change Acknowledgment Detail - Outbound195SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
95F47157EDI Shipping Schedule Detail - Outbound148SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP48S: Service Billing
96F48S910Billing Detail Journal File23W2ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
97F48S911Compressed Journal File21W3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP49: Transportation Management
98F4981Freight Audit History74FHANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP53: Change Management
99F5314Planned Change Order Master Table26D2ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
100F5315Change Order Master Table25D3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP55: Reserved for Clients
101F550200Correspondent Accounts Report3WFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
102F55IF421Sales Order per BO184SDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
103F55IF425Sales Order per BO - 2005184SDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
104F55IFP04Pozycje Budżetowe WF10WFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
105F55IFQUAWork file per quadrature F411119QUANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
106F59BO001Cash Journal Master File3CJANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
107F59PO001Cash Journal Master File3CJANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
108F59PO00FCash Journal Final Accounts1FAANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
109F59PO00NCash Journal Next Numbers1CNANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP74: EMEA Localization
110F749104Rows Definition - EMEA - 7417RDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
111F74UI90WF - Report Detail - EMEA - 747RDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
112F74UI91WF - Account Detail - EMEA - 749ADANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP74R: CIS
113F74R9022Accounts Group Definition - RUS - 09 - 74R6AGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP76A: Argentina
114F76A11Account ID Relationship - ARG - 003TFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP76B: Brazil - Reporting System Only
115F7611BNota Fiscal Detail - Brazil89FDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP76C: Colombia
116F76C9415Workfile for Dialy Book - COL - 097LDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP89: Conversion Programs
117F42119BSales Order History File - temporary for upgrade (2)21SDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
118F4211BSales Order Detail File - temporary for upgrade (2)21SDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
119F43199ATemp F43199 for ERP 9.0 Upgrade125OLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290