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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F03B11RPCustomer Ledger
8F4311PDPurchase Order Detail File
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

34 columns | Print definition?812 | AR1

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP01: Address Book
1F0101Z2Address Book - Interoperability96SZAR1Phone PrefixStringGeneric Edit60
2F0115Address Book - Contact Phone Numbers6WPAR1Phone PrefixStringGeneric Edit60
3F0115Z1Phones - Interoperability20PIAR1Phone PrefixStringGeneric Edit60
TOP05A: OW HR & PR Foundation
4F05003Verification of Employment Data8EVAR1Phone PrefixStringGeneric Edit60
5F060116ZUnedited Quick Hire Transaction File77SZAR1Phone PrefixStringGeneric Edit60
TOP07: Payroll
6F074001New Hire Reporting Workfile - OneWorld Only40NHAR1Phone PrefixStringGeneric Edit60
TOP08: Human Resources
7F054115Employee Phone Number History Table4HPAR1Phone PrefixStringGeneric Edit60
8F054115WEmployee Phone Number Work Table4PNAR1Phone PrefixStringGeneric Edit60
TOP08A: eRecruit
9F08490Recruitment Information15RIAR1Phone PrefixStringGeneric Edit60
10F08496References4RFAR1Phone PrefixStringGeneric Edit60
TOP08AD: ADP Integration
11F05137ADP Employee Master Information47ADAR1Phone PrefixStringGeneric Edit60
TOP13C: Condition-Base Maintenance
12F1310Condition-Based Alerts45CAAR1Phone PrefixStringGeneric Edit60
13F1310Z1Unedited Condition-Based Alerts59CBAR1Phone PrefixStringGeneric Edit60
TOP17: Customer Service Management
14F4801TZ2Warranty Claim/Supplier Recovery processing66WQAR1Phone PrefixStringGeneric Edit60
TOP17C: Call Management
15F1755Customer Call Master28ZAAR1Phone PrefixStringGeneric Edit60
16F1757Task Master17ZAAR1Phone PrefixStringGeneric Edit60
17F1758Time Zones1ZBAR1Phone PrefixStringGeneric Edit60
TOP40: Inventory/OP Base
18F40051Return Material Authorization10RDAR1Phone PrefixStringGeneric Edit60
TOP43Q: Strategic Sourcing
19F43Q10Event Header61EHAR1Phone PrefixStringGeneric Edit60
TOP47: Electronic Commerce
20F470561EDI Payment Order Bank N and A - Outbound19D2AR1Phone PrefixStringGeneric Edit60
21F470561WEDI Payment Order Bank N and A - Work21D2AR1Phone PrefixStringGeneric Edit60
22F470562EDI Payment Order Vendor N and A - Outbound19D4AR1Phone PrefixStringGeneric Edit60
23F470562WEDI Payment Order Vendor N and A - Work19D4AR1Phone PrefixStringGeneric Edit60
24F470563EDI Payment Order Payee N and A - Outbound19D5AR1Phone PrefixStringGeneric Edit60
25F470563WEDI Payment Order Payee N and A - Work19D5AR1Phone PrefixStringGeneric Edit60
TOP48: Work Order Processing
26F4801STPurge - Work Order Master Tag File53WAAR1Phone PrefixStringGeneric Edit60
27F4801TWork Order Master Tag File53WAAR1Phone PrefixStringGeneric Edit60
28F4817Service Order Extension5SRAR1Phone PrefixStringGeneric Edit60
TOP74: EMEA Localization
29F7430031Legal Document Address (Print Info) - COMM - 03B17PIAR1Phone PrefixStringGeneric Edit60
TOP74S: Spain
30F74S90Model 349 - Record Type 0 - Spain26Q0AR1Phone PrefixStringGeneric Edit60
TOP75T: Taiwan
31F75T001GUI/VAT Declaration Site - 75T15DSAR1Phone PrefixStringGeneric Edit60
TOPH90: ONEWORLD TOOLS
32F1761Electronic Help JDE Request Log19ZAAR1Phone PrefixStringGeneric Edit60
TOPH91: Design Tools
33F9801NEWEmployee Information - New Version8AAAR1Phone PrefixStringGeneric Edit60
34F9801OLDEmployee Information - Old Version7AAAR1Phone PrefixStringGeneric Edit60