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

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
9F4111ILItem Ledger File
10F0411RPAccounts Payable Ledger

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

63 columns | Print definition?920 | 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
5F01161DWCustomer Alternate Address Export9DWADD2Address Line 2StringGeneric Edit400
6F01161Z1Batch - Alternative Address19LBADD2Address Line 2StringGeneric Edit400
7F0118Postal Code Address4A7ADD2Address Line 2StringGeneric Edit400
TOP05: Time Accounting and HRM Base
8F054101Employee Personal Profile Information History Table15EHADD2Address Line 2StringGeneric Edit400
9F054101WEmployee Personal Profile Information Work Table15EPADD2Address Line 2StringGeneric Edit400
TOP05A: PeopleSoft HR & PR Foundation
10F05003Verification of Employment Data14EVADD2Address Line 2StringGeneric Edit400
11F060116ZUnedited Quick Hire Transaction File70SZADD2Address Line 2StringGeneric Edit400
TOP07: Payroll
12F074001New Hire Reporting Workfile - OneWorld Only13NHADD2Address Line 2StringGeneric Edit400
13F07880SUI Magnetic Media Workfile9YWADD2Address Line 2StringGeneric Edit400
14F8907422New Hire Detail File - Massachusetts (22)14MAADD2Address Line 2StringGeneric Edit400
15F8907427New Hire Detail File - Montana (27)35MTADD2Address Line 2StringGeneric Edit400
16F8907428New Hire Detail File - Nebraska(28)11NEADD2Address Line 2StringGeneric Edit400
17F8907444New Hire Detail File Transfer - Texas (44)9TXADD2Address Line 2StringGeneric Edit400
TOP08: Human Resources
18F083305Mail Merge Header/Detail9MMADD2Address 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
23F17311Equipment Master 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 & A - Outbound27D2ADD2Address Line 2StringGeneric Edit400
29F470561WEDI Payment Order Bank N & A - Work27D2ADD2Address Line 2StringGeneric Edit400
30F470562EDI Payment Order Vendor N & A - Outbound25D4ADD2Address Line 2StringGeneric Edit400
31F470562WEDI Payment Order Vendor N & A - Work25D4ADD2Address Line 2StringGeneric Edit400
32F470563EDI Payment Order Payee N & A - Outbound25D5ADD2Address Line 2StringGeneric Edit400
33F470563WEDI Payment Order Payee N & 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
38F49T50Order Release Location Staging12LOADD2Address Line 2StringGeneric Edit400
39F49T80Locations Staging Table10LCADD2Address Line 2StringGeneric Edit400
TOP54HS: Health & Safety Incident Mgt
40F54HS01Incident Master31S1ADD2Address Line 2StringGeneric Edit400
41F54HS01MIncident Master Change History34I1ADD2Address Line 2StringGeneric Edit400
42F54HS02Incident People41S2ADD2Address Line 2StringGeneric Edit400
43F54HS02MIncident People Change History44I2ADD2Address Line 2StringGeneric Edit400
TOP74: EMEA Localization
44F74101Additional Address Book & Vat Id Info via VIES - EU - 014VVADD2Address Line 2StringGeneric Edit400
45F74101WAdditional Address Book & Vat Id Info Work File - EU - 014VWADD2Address Line 2StringGeneric Edit400
46F7430031Legal Document Address (Print Info) - COMM - 03B9PIADD2Address Line 2StringGeneric Edit400
TOP74U: United Kingdom Localizations
47F74U4052Subcontractor Detail - CIS Monthly Return - UK - 046SMADD2Address Line 2StringGeneric Edit400
48F74UUI52Subcontractor Detail - XML WF CIS Monthly Return - UK - 046SMADD2Address Line 2StringGeneric Edit400
TOP75A: Australia
49F75A0010Australian Employee Termination Details58A0ADD2Address Line 2StringGeneric Edit400
50F75A0220Payment Summary Workfile7PSADD2Address Line 2StringGeneric Edit400
TOP75I: India
51F75I100QTDS Form 26Q - WorkFile (Quarterly)17EFADD2Address Line 2StringGeneric Edit400
52F75I100WTDS Form 26 - WorkFile17EFADD2Address Line 2StringGeneric Edit400
53F75I210Tax Registration Details - IND - 003CSADD2Address Line 2StringGeneric Edit400
54F75I303Excise - ARE1 Bond Master-IND-75I12Q2ADD2Address Line 2StringGeneric Edit400
55F75I305Excise - General Surety Bond11Q3ADD2Address Line 2StringGeneric Edit400
TOP76A: Argentina
56F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A18HFADD2Address Line 2StringGeneric Edit400
57F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A18HFADD2Address Line 2StringGeneric Edit400
58F76A82A/P Payment Control Group File - ARG - 04 - 76A27C6ADD2Address Line 2StringGeneric Edit400
59F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A18HFADD2Address Line 2StringGeneric Edit400
TOP76H: Chile
60F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H9PIADD2Address Line 2StringGeneric Edit400
TOP79A: Greenhouse Gas Accounting
61F79A75GHG Organization Name5GOADD2Address Line 2StringGeneric Edit400
TOPH90: EnterpriseOne TOOLS
62F012504Focus Registration17FOADD2Address Line 2StringGeneric Edit400
TOPH91: Design Tools
63F9801NEWEmployee Information - New Version5AAADD2Address Line 2StringGeneric Edit400