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
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

52 tables920 | 74R

74R: Russia
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F74R0001QA151Currency Codes to Words - 74RFiles74: EMEA Localization
2920F74R0005DR101User Defined Codes - RUS - 00 - 74RFiles74: EMEA Localization
3920F74R0007FS161Legal Document Footer Signature Setup - RUS - 00 - 74RFiles74: EMEA Localization
4920F74R0011IC81Batch Tag File - RUS - 09 - 74RFiles74: EMEA Localization
5920F74R0018TD8112Russian Tax File - 74RFiles74: EMEA Localization
6920F74R010GC91Constant for VAT - RUS - 00Files74R: Russia
7920F74R0100PC423Petty Cash Transactions - RUS - 00 - 74RFiles74: EMEA Localization
8920F74R012CD131Cash Documents Next Number Setup - RUS - 00Files74R: Russia
9920F74R013CA72Cash Account Setup - RUS - 00Files74R: Russia
10920F74R01TPT101Petty Cash Transactions Tag File - RUS - 00Files74R: Russia
11920F74R020GC71PettyCash Constants - RUS - 00Files74R: Russia
12920F74R0401AD152Adjustment to Voucher - RUS - 04 - 74RFiles74R: Russia
13920F74R0402CO162Correction to Voucher - RUS - 04 - 74RFiles74R: Russia
14920F74R0480RP92Pay Item Differences - RUS - 04 - 74RFiles74: EMEA Localization
15920F74R101TAB151Address Book Tag File - RUS - 01 - 74RFiles74: EMEA Localization
16920F74R201VM81VAT Accrual on Sales Method Setup - RUS - 42Files74R: Russia
17920F74R202TA71Transit VAT Account Setup - RUS - 42Files74R: Russia
18920F74R3031PI111Legal Document Address (Print Info) - RUS - 03B - 74RFiles74: EMEA Localization
19920F74R3032HF161Currency Code (Print Info) - RUS - 03BFiles74R: Russia
20920F74R3033DF191Line additional info (Print Info) - RUS - 03BFiles74R: Russia
21920F74R3034UM171Unit of Measure Relationship - RUS - 74RFiles74R: Russia
22920F74R3035CC151Currency Code Relationship - RUS - 74RFiles74R: Russia
23920F74R3036CO141Country of Origin Relationship - RUS - 74RFiles74R: Russia
24920F74R3037AR112Adjustment Invoice Relationship in AR/SOP - RUS - 74RFiles74R: Russia
25920F74R3038AI461Adjustment Invoice Header Info AR/SOP - RUS - 74RFiles74R: Russia
26920F74R310HE211Prepayment Header Tax File - RUS - 03BFiles74R: Russia
27920F74R311DE511Prepayment Detail Tax File - RUS - 03BFiles74R: Russia
28920F74R3B14TF181F03B14 Tag File - RUS - 03B - 74RFiles74: EMEA Localization
29920F74R400VR81Account Payable Setup for VAT Release - RUS - 00Files74R: Russia
30920F74R4014TF181F0414 Tag File - RUS - 04 - 74RFiles74: EMEA Localization
31920F74R410TH231Tax on Hold - RUS - 04Files74R: Russia
32920F74R420TR262Tax Releases - RUS - 04Files74R: Russia
33920F74R4500PO291Paymet Order Supplemental Data - RU - 04 - 74RFiles74: EMEA Localization
34920F74R5010RC91Revaluation Code By Class - RUS - 12 - 74RFiles74: EMEA Localization
35920F74R5110TF321F1201 Tag File - RUS - 12 - 74RFiles74: EMEA Localization
36920F74R9001CA152Correspondence Account Setup - RUS -09 - 74RFiles74: EMEA Localization
37920F74R9002GB469Correspondence Balance - RUS- 09 - 74RBalance Files74: EMEA Localization
38920F74R9003CM152Correspondence Method - RUS -09 - 74RFiles74: EMEA Localization
39920F74R9004CR212Correspondence Rules - RUS -09 - 74RFiles74: EMEA Localization
40920F74R9010PL192Profit & Loss - RUS - 09 - 74RFiles74: EMEA Localization
41920F74R9011CR373Correspondence Rules - RUS -09 - 74RFiles74: EMEA Localization
42920F74R9020SE131Setup G/L Reports - RUS - 09 - 74RFiles74: EMEA Localization
43920F74R9021DR191Report Detail Row Definition - RUS - 09 - 74RFiles74: EMEA Localization
44920F74R9022AG251Accounts Group Definition - RUS - 09 - 74RFiles74: EMEA Localization
45920F74R9023CO161Report Column Description - RUS - 09 - 74RFiles74: EMEA Localization
46920F74R9029OA281Open Accounts - RUS - 09 - 74RFiles74: EMEA Localization
47920F74R9030BS172Balance Sheet - RUS - 09 - 74RFiles74: EMEA Localization
48920F74R9040CE202Changes in Equity - RUS - 09 - 74RFiles74: EMEA Localization
49920F74R9050CF172Cash Flow - RUS - 09 - 74RFiles74: EMEA Localization
50920F74RUI31W1391VAT Sales Book Workfile - RUS - 03BFiles74R: Russia
51920F74RUI41W1401VAT Purchase Book Workfile - RUS - 04Files74R: Russia
52920F74RUI42W2141VAT Purchase Book Workfile II - RUS - 04Files74R: Russia