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

57 columns | Print definition?812 | ADD1

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F004201Prepayment Transaction Table24PTADD1Address Line 1StringGeneric Edit400
TOP01: Address Book
2F0101Z2Address Book - Interoperability87SZADD1Address Line 1StringGeneric Edit400
3F0116Address by Date4ALADD1Address Line 1StringGeneric Edit400
4F01161Alternate Address5WLADD1Address Line 1StringGeneric Edit400
5F01161Z1Batch - Alternative Address18LBADD1Address Line 1StringGeneric Edit400
6F0118Postal Code Address3A7ADD1Address Line 1StringGeneric Edit400
TOP05: Time Accounting and HRM Base
7F054101Employee Personal Profile Information History Table14EHADD1Address Line 1StringGeneric Edit400
8F054101WEmployee Personal Profile Information Work Table14EPADD1Address Line 1StringGeneric Edit400
9F054111Employee Emergency Contact History Table8CHADD1Address Line 1StringGeneric Edit400
10F054111WEmployee Emergency Contact Work Table8ECADD1Address Line 1StringGeneric Edit400
TOP05A: OW HR & PR Foundation
11F05003Verification of Employment Data13EVADD1Address Line 1StringGeneric Edit400
12F060116ZUnedited Quick Hire Transaction File69SZADD1Address Line 1StringGeneric Edit400
TOP07: Payroll
13F074001New Hire Reporting Workfile - OneWorld Only12NHADD1Address Line 1StringGeneric Edit400
14F07880SUI Magnetic Media Workfile8YWADD1Address Line 1StringGeneric Edit400
15F8907422New Hire Detail File - Massachusetts (22)5MAADD1Address Line 1StringGeneric Edit400
16F8907427New Hire Detail File - Montana (27)34MTADD1Address Line 1StringGeneric Edit400
17F8907428New Hire Detail File - Nebraska(28)10NEADD1Address Line 1StringGeneric Edit400
18F8907444New Hire Detail File Transfer - Texas (44)8TXADD1Address Line 1StringGeneric Edit400
TOP08: Human Resources
19F083305Mail Merge Header/Detail8MMADD1Address Line 1StringGeneric Edit400
TOP08A: eRecruit
20F08490Recruitment Information6RIADD1Address Line 1StringGeneric Edit400
TOP08AD: ADP Integration
21F05137ADP Employee Master Information53ADADD1Address Line 1StringGeneric Edit400
TOP08B: Benefits Administration
22F0833WFBenefit Statement Work file5WFADD1Address Line 1StringGeneric Edit400
TOP08U: OW HR US
23F08995COBRA Notification History6H2ADD1Address Line 1StringGeneric Edit400
TOP13C: Condition-Base Maintenance
24F1310Condition-Based Alerts47CAADD1Address Line 1StringGeneric Edit400
25F1310Z1Unedited Condition-Based Alerts61CBADD1Address Line 1StringGeneric Edit400
TOP17C: Call Management
26F17311Installed Base Location Details13LDADD1Address Line 1StringGeneric Edit400
TOP31B: Blend Management
27F31B01Winery Master4WIADD1Address Line 1StringGeneric Edit400
TOP40: Inventory/OP Base
28F4006Order Address Information6OAADD1Address Line 1StringGeneric Edit400
29F4006ZBatch Order Receiver - Order Address Information6OYADD1Address Line 1StringGeneric Edit400
TOP44H: Homebuilder Management
30F4453Lot Master (World)8JBADD1Address Line 1StringGeneric Edit400
TOP47: Electronic Commerce
31F47037EDI Shipping Notice Detail - Outbound205SZADD1Address Line 1StringGeneric Edit400
32F470561EDI Payment Order Bank N and A - Outbound26D2ADD1Address Line 1StringGeneric Edit400
33F470561WEDI Payment Order Bank N and A - Work26D2ADD1Address Line 1StringGeneric Edit400
34F470562EDI Payment Order Vendor N and A - Outbound24D4ADD1Address Line 1StringGeneric Edit400
35F470562WEDI Payment Order Vendor N and A - Work24D4ADD1Address Line 1StringGeneric Edit400
36F470563EDI Payment Order Payee N and A - Outbound24D5ADD1Address Line 1StringGeneric Edit400
37F470563WEDI Payment Order Payee N and A - Work24D5ADD1Address Line 1StringGeneric Edit400
38F4706EDI Order Address Information16ZAADD1Address Line 1StringGeneric Edit400
39F47081EDI Price Sales Catalog Header - Inbound20FVADD1Address Line 1StringGeneric Edit400
TOP49: Transportation Management
40F49130Shipment Document Workfile18BWADD1Address Line 1StringGeneric Edit400
41F49140SSCC Print Label Workfile10BWADD1Address Line 1StringGeneric Edit400
TOP74: EMEA Localization
42F7430031Legal Document Address (Print Info) - COMM - 03B8PIADD1Address Line 1StringGeneric Edit400
TOP74B: Begium Localization
43F7403B11Belgium - Work File Yearly Vat Declaration Data3QAADD1Address Line 1StringGeneric Edit400
44F74B200Yearly/Quarterly VAT Listing - Belgium3VTADD1Address Line 1StringGeneric Edit400
TOP74U: United Kingdom Localizations
45F74U4052Subcontractor Detail - CIS Monthly Return - UK - 045SMADD1Address Line 1StringGeneric Edit400
TOP75A: Australia - Reporting System Only
46F75A0010Australian Employee Termination Details57A0ADD1Address Line 1StringGeneric Edit400
47F75A0220Payment Summary Workfile6PSADD1Address Line 1StringGeneric Edit400
TOP76A: Argentina
48F76A0209Header and Footer Invoice/ShipmentNote History WF - ARG - 76A17HFADD1Address Line 1StringGeneric Edit400
49F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A17HFADD1Address Line 1StringGeneric Edit400
50F76A8002SICORE RG738 Withholding Entity3V3ADD1Address Line 1StringGeneric Edit400
51F76A82A/P Payment Control Group File - ARG - 04 - 76A26C6ADD1Address Line 1StringGeneric Edit400
52F76AUI20Header and Footer Invoice/ShipmentNote Workfile - ARG - - 0017HFADD1Address Line 1StringGeneric Edit400
TOP76C: Colombia
53F76C571DIAN File Type 1 - COL - 0412R1ADD1Address Line 1StringGeneric Edit400
TOP76H: Chile
54F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H8PIADD1Address Line 1StringGeneric Edit400
TOPH90: ONEWORLD TOOLS
55F012504Focus Registration16FOADD1Address Line 1StringGeneric Edit400
TOPH91: Design Tools
56F9801NEWEmployee Information - New Version4AAADD1Address Line 1StringGeneric Edit400
57F9801OLDEmployee Information - Old Version4AAADD1Address Line 1StringGeneric Edit400