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
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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

129 columns | Print definition?920 | 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
3F03B117Revenue Recognition GL Info56RLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
4F03B119Revenue Recognition GL Info Audit54RNANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
5F03BUI04Work File for Integrity by Offset Account2W3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
6F09UI011Receipt Prepost Work File9GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP04: Accounts Payable
7F04UI004Integrity Report Worktable2RPANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
8F09UI005Tax Offsets User Index31GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP05T: Time Entry
9F06116Employee Transaction Detail File98YTANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
10F06116Z1Employee Transactions - Batch File112VLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
11F06116Z2ESS Timecard History112VMANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
12F06278Retro Timecard Detail File98YTANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
13F06290Payroll Accounting Journal Work File23YRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
14F063951Payroll Journal (Compressed) File3GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
15F069136Tip Disbursement14JEANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP07: Payroll
16F05290WF - Payroll Journal (Detail)3JRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
17F06270Retro Processing Parameter19JPANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
18F06490Payroll/Accounts Payable Ledger Detail6JRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
19F06491Payroll/Accounts Payable Ledger Detail6J6ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
20F0716701Employee Assignment T/E Template Information3EAANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
21F0716709Employee Assignment T/E Template Info History3EAANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
22F07490Payroll - Accounts Payable Detail (One World)6JRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
23F07491Payroll - Accounts Payable Summary File6J6ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP09: General Accounting
24F0911PPurge - Account Ledger14GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
25F0911RWF - Account Ledger Reconciliation14GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
26F0911Z1Journal Entry Transactions - Batch File31VNANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
27F0911Z4F0911 Interoperability Table36SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
28F0912Cost Allocations/Flex Budgeting15RJANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
29F0912AIndex Computation Entry File11RIANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
30F0912BVariable Allocation File12R#ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
31F0917Bank Statement Detail33GDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
32F09617Auto Bank Statement Detail9GMANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
33F097021WAccount Ledger to Account Master Work Table15TAANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
34F09UI015Indexed Computations Multi-Tiered Entries14GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
35F09UI016Account Balance Compare Exceptions14GWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
36F52G11Burdening Detail Ledger15BDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
37F52G11WFTemporary Burdened Detail Ledger Workfile15BWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP10: Financial Reporting
38F10UI003Dynamically Created Accounts6ACANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP12: Fixed Assets
39F12911ERPost G/L to FA Exceptions Work File5GLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP17C: Call Management
40F1760Time Entry16ZBANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP18: Timecard Automation
41F186301Timecard Templates8TTANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
42F186602Labor Rules Tag File104TFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP31: Shop Floor Control
43F31UI802Accumulate Amounts by Account2WGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
44F31UI803Work File for Summarizing Journal Entries2SGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
45F31UI804Exception Report Work FIle2WRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP39: Advanced Stock Valuation
46F3910G/L Adjustment Table9SCANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP40: Inventory/OP Base
47F4011ZBatch Receiver File - Order Details192SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
48F49211Sales Order Detail File - Tag File127UDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
49F49211Z1Sales Order Detail Tag Unedited Transaction File146S1ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
50F49219Sales Order Detail - Tag History File104UDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP40G: Grower Management
51F40G30SAssessments / Donations Workfile14ADANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP41: Inventory Management
52F41UI001Inventory Transactions Detail File165ITANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP42: Sales Management
53F42800G1Sales Update G Batch Detail Workfile11DGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
54F470371TTag for F470371- EDI shipping Notice Detail - Outbound5UZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP42B: Sales Order Entry
55F49299S.O. Detail Tag Ledger File127UDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43: Procurement
56F43080Approvals Fields Constants129PDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
57F4311Purchase Order Detail File125PDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
58F4311ZPurchase Order Generator File129PWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
59F4311Z1Purchase Order Detail Unedited Transaction Table138SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
60F43121Purchase Order Receiver File48PRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
61F43121Z1Receipts Unedited Transaction Table65SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
62F43147Freight Distribution Workfile21FDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
63F4314ZVoucher Match Selection File147PNANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
64F4316Purchase Order Multiple Account File7P3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
65F4316TPurchase Order Multiple Account Tag File7P3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
66F4317Purchase Order Detail Non-Billable9PDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
67F43199P.O. Detail Ledger File - Flexible Version125OLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
68F43UI50DPO Print Detail Work File36PWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43A: Purchase Order Receipt/Routing
69F43126Purchase Order Receiver Multiple Account10P4ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
70F43126TPurchase Order Receiver Multiple Account Tag File14P4ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
71F43127Purchase Order Receiver Non-Billable11PRANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43B: Voucher Match and Landed Cost
72F43146TVoucher Match Multiple Account Tag File8P5ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43C: Contracts
73F43C30Assessment Donations14ADANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43E: Requisition Self Service
74F43E16Requisition Multiple Account File7P3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP43Q: Strategic Sourcing
75F43Q11Event Detail12EDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP44H: Homebuilder Management
76F44H611Bid Details8BDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
77F44H611WBid Details Work File12BWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
78F44H711Lot Start Workfile72SWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
79F44H711ZHB Lot Start Unedited Transaction File85SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
80F44H71W1Lot Start Generation Workfile72GWANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
81F44H73W1Lot Start - P.O. / Committment Generation Work File44CGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP45: Advanced Pricing
82F4575Ship and Debit History54AHANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
83F4575TMPShip and Debit History - Temp Table54AHANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
84F4576Ship and Debit Claims82ACANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
85F4576TMPShip and Debit Claims- Temp Table82ACANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
86F4576Z1Ship and Debit Claims Unedited Transaction Table79Z1ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP47: Electronic Commerce
87F47012EDI Purchase Order Detail - Inbound193SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
88F47017EDI Purchase Order Detail - Outbound139SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
89F47022EDI P.O. Acknowledgment Detail - Inbound139SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
90F47027EDI P.O. Acknowledgment Detail - Outbound193SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
91F47042EDI Invoice Detail - Inbound49SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
92F47047EDI Invoice Detail (Sales) - Outbound193SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
93F47072EDI Receiving Advice Detail - Inbound140SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
94F47077EDI Receiving Advice Detail - Outbound140SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
95F47092EDI Request for Quote Detail - Inbound193SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
96F47097EDI Request for Quote Detail - Outbound139SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
97F47102EDI Response to RFQ Detail - Inbound139SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
98F47107EDI Response to RFQ Detail - Outbound192SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
99F47122EDI Product Activity Data Detail - Inbound68MJANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
100F47127EDI Product Activity Data Detail - Outbound68MJANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
101F47132EDI Purchase Order Change Detail - Inbound194SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
102F47137EDI Purchase Order Change Detail - Outbound140SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
103F47142EDI P.O. Change Acknowledgment Detail - Inbound141SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
104F47147EDI P.O. Change Acknowledgment Detail - Outbound195SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
105F47157EDI Shipping Schedule Detail - Outbound148SZANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP48S: Service Billing
106F48S910Billing Detail Journal Workfile23W2ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
107F48S911Summarized Journal Workfile21W3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP49: Transportation Management
108F4981Freight Audit History74FHANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP53: Change Management
109F5314Planned Change Order Master Table26D2ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
110F5315Change Order Master Table25D3ANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP74: EMEA Localization
111F749104Rows Definition - EMEA - 7417RDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
112F74UI90WF - Report Detail - EMEA - 747RDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
113F74UI91WF - Account Detail - EMEA - 749ADANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP74R: Russia
114F74R9022Accounts Group Definition - RUS - 09 - 74R6AGANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP74U: United Kingdom Localizations
115F74U0420SPC - Application Master - UK - 4394SEANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
116F74U0425SPC - Certificate Master - UK - 4396SFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
117F74U4316SPC - Purchase Order Line Additional Information - UK - 4342SCANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP74Z: Czech Republic
118F74Z0010Cash Desk Document Printed - CZE - 74Z10ZOANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP75C: China
119F75C015Cash Flow Data - China13CFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP75I: India
120F75I611TCS Prepayment Transaction File - IND-03B14TTANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP76A: Argentina
121F76A11Account ID Relationship - ARG - 00 - 76A3TFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP76B: Brazil
122F7611BNota Fiscal Detail - BRA - 4289FDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
123F76B837FCONT Account Balances - 76B5FBANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
124F76B935SPED Book Type Definition4BDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP76C: Colombia
125F76C9415Workfile for Dialy Book - COL - 097LDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
126F76C9F02DIAN Formats by AccountID - COL - 0920DFANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
TOP89: Conversion Programs
127F42119BSales Order History File - temporary for upgrade (2)21SDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
128F4211BSales Order Detail File - temporary for upgrade (2)21SDANIAccount Number - Input (Mode Unknown)StringGeneric Edit290
129F43199ATemp F43199 for ERP 9.0 Upgrade125OLANIAccount Number - Input (Mode Unknown)StringGeneric Edit290