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

48 columns | Print definition?812 | ADD2

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F004201Prepayment Transaction Table25PTADD2Address Line 2StringGeneric Edit400
TOP01: Address Book
2F0101Z2Address Book - Interoperability88SZADD2Address Line 2StringGeneric Edit400
3F0116Address by Date5ALADD2Address Line 2StringGeneric Edit400
4F01161Alternate Address6WLADD2Address Line 2StringGeneric Edit400
5F01161Z1Batch - Alternative Address19LBADD2Address Line 2StringGeneric Edit400
6F0118Postal Code Address4A7ADD2Address Line 2StringGeneric Edit400
TOP05: Time Accounting and HRM Base
7F054101Employee Personal Profile Information History Table15EHADD2Address Line 2StringGeneric Edit400
8F054101WEmployee Personal Profile Information Work Table15EPADD2Address Line 2StringGeneric Edit400
TOP05A: OW HR & PR Foundation
9F05003Verification of Employment Data14EVADD2Address Line 2StringGeneric Edit400
10F060116ZUnedited Quick Hire Transaction File70SZADD2Address Line 2StringGeneric Edit400
TOP07: Payroll
11F074001New Hire Reporting Workfile - OneWorld Only13NHADD2Address Line 2StringGeneric Edit400
12F07880SUI Magnetic Media Workfile9YWADD2Address Line 2StringGeneric Edit400
13F8907422New Hire Detail File - Massachusetts (22)14MAADD2Address Line 2StringGeneric Edit400
14F8907427New Hire Detail File - Montana (27)35MTADD2Address Line 2StringGeneric Edit400
15F8907428New Hire Detail File - Nebraska(28)11NEADD2Address Line 2StringGeneric Edit400
16F8907444New Hire Detail File Transfer - Texas (44)9TXADD2Address Line 2StringGeneric Edit400
TOP08: Human Resources
17F083305Mail Merge Header/Detail9MMADD2Address Line 2StringGeneric Edit400
TOP08A: eRecruit
18F08490Recruitment Information7RIADD2Address Line 2StringGeneric Edit400
TOP08AD: ADP Integration
19F05137ADP Employee Master Information54ADADD2Address Line 2StringGeneric Edit400
TOP08B: Benefits Administration
20F0833WFBenefit Statement Work file6WFADD2Address Line 2StringGeneric Edit400
TOP13C: Condition-Base Maintenance
21F1310Condition-Based Alerts48CAADD2Address Line 2StringGeneric Edit400
22F1310Z1Unedited Condition-Based Alerts62CBADD2Address Line 2StringGeneric Edit400
TOP17C: Call Management
23F17311Installed Base Location Details14LDADD2Address Line 2StringGeneric Edit400
TOP31B: Blend Management
24F31B01Winery Master5WIADD2Address Line 2StringGeneric Edit400
TOP40: Inventory/OP Base
25F4006Order Address Information7OAADD2Address Line 2StringGeneric Edit400
26F4006ZBatch Order Receiver - Order Address Information7OYADD2Address Line 2StringGeneric Edit400
TOP47: Electronic Commerce
27F47037EDI Shipping Notice Detail - Outbound206SZADD2Address Line 2StringGeneric Edit400
28F470561EDI Payment Order Bank N and A - Outbound27D2ADD2Address Line 2StringGeneric Edit400
29F470561WEDI Payment Order Bank N and A - Work27D2ADD2Address Line 2StringGeneric Edit400
30F470562EDI Payment Order Vendor N and A - Outbound25D4ADD2Address Line 2StringGeneric Edit400
31F470562WEDI Payment Order Vendor N and A - Work25D4ADD2Address Line 2StringGeneric Edit400
32F470563EDI Payment Order Payee N and A - Outbound25D5ADD2Address Line 2StringGeneric Edit400
33F470563WEDI Payment Order Payee N and A - Work25D5ADD2Address Line 2StringGeneric Edit400
34F4706EDI Order Address Information17ZAADD2Address Line 2StringGeneric Edit400
35F47081EDI Price Sales Catalog Header - Inbound21FVADD2Address Line 2StringGeneric Edit400
TOP49: Transportation Management
36F49130Shipment Document Workfile19BWADD2Address Line 2StringGeneric Edit400
37F49140SSCC Print Label Workfile11BWADD2Address Line 2StringGeneric Edit400
TOP74: EMEA Localization
38F7430031Legal Document Address (Print Info) - COMM - 03B9PIADD2Address Line 2StringGeneric Edit400
TOP74U: United Kingdom Localizations
39F74U4052Subcontractor Detail - CIS Monthly Return - UK - 046SMADD2Address Line 2StringGeneric Edit400
TOP75A: Australia - Reporting System Only
40F75A0010Australian Employee Termination Details58A0ADD2Address Line 2StringGeneric Edit400
41F75A0220Payment Summary Workfile7PSADD2Address Line 2StringGeneric Edit400
TOP76A: Argentina
42F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A18HFADD2Address Line 2StringGeneric Edit400
43F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A18HFADD2Address Line 2StringGeneric Edit400
44F76A82A/P Payment Control Group File - ARG - 04 - 76A27C6ADD2Address Line 2StringGeneric Edit400
45F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 0018HFADD2Address Line 2StringGeneric Edit400
TOP76H: Chile
46F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H9PIADD2Address Line 2StringGeneric Edit400
TOPH90: ONEWORLD TOOLS
47F012504Focus Registration17FOADD2Address Line 2StringGeneric Edit400
TOPH91: Design Tools
48F9801NEWEmployee Information - New Version5AAADD2Address Line 2StringGeneric Edit400