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

73 columns | Print definition?920 | 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
5F01161DWCustomer Alternate Address Export8DWADD1Address Line 1StringGeneric Edit400
6F01161Z1Batch - Alternative Address18LBADD1Address Line 1StringGeneric Edit400
7F0118Postal Code Address3A7ADD1Address Line 1StringGeneric Edit400
TOP05: Time Accounting and HRM Base
8F054101Employee Personal Profile Information History Table14EHADD1Address Line 1StringGeneric Edit400
9F054101WEmployee Personal Profile Information Work Table14EPADD1Address Line 1StringGeneric Edit400
10F054111Employee Emergency Contact History Table8CHADD1Address Line 1StringGeneric Edit400
11F054111WEmployee Emergency Contact Work Table8ECADD1Address Line 1StringGeneric Edit400
TOP05A: PeopleSoft HR & PR Foundation
12F05003Verification of Employment Data13EVADD1Address Line 1StringGeneric Edit400
13F060116ZUnedited Quick Hire Transaction File69SZADD1Address Line 1StringGeneric Edit400
TOP07: Payroll
14F074001New Hire Reporting Workfile - OneWorld Only12NHADD1Address Line 1StringGeneric Edit400
15F07880SUI Magnetic Media Workfile8YWADD1Address Line 1StringGeneric Edit400
16F8907422New Hire Detail File - Massachusetts (22)5MAADD1Address Line 1StringGeneric Edit400
17F8907427New Hire Detail File - Montana (27)34MTADD1Address Line 1StringGeneric Edit400
18F8907428New Hire Detail File - Nebraska(28)10NEADD1Address Line 1StringGeneric Edit400
19F8907444New Hire Detail File Transfer - Texas (44)8TXADD1Address Line 1StringGeneric Edit400
TOP08: Human Resources
20F083305Mail Merge Header/Detail8MMADD1Address Line 1StringGeneric Edit400
TOP08AD: ADP Integration
21F05137ADP Employee Master Information53ADADD1Address Line 1StringGeneric Edit400
TOP08B: Benefits Administration
22F0833WFBenefit Statement Work file5WFADD1Address Line 1StringGeneric Edit400
TOP08U: PeopleSoft 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
26F17311Equipment Master 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 & A - Outbound26D2ADD1Address Line 1StringGeneric Edit400
33F470561WEDI Payment Order Bank N & A - Work26D2ADD1Address Line 1StringGeneric Edit400
34F470562EDI Payment Order Vendor N & A - Outbound24D4ADD1Address Line 1StringGeneric Edit400
35F470562WEDI Payment Order Vendor N & A - Work24D4ADD1Address Line 1StringGeneric Edit400
36F470563EDI Payment Order Payee N & A - Outbound24D5ADD1Address Line 1StringGeneric Edit400
37F470563WEDI Payment Order Payee N & 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
42F49T50Order Release Location Staging10LOADD1Address Line 1StringGeneric Edit400
43F49T80Locations Staging Table9LCADD1Address Line 1StringGeneric Edit400
TOP54HS: Health & Safety Incident Mgt
44F54HS01Incident Master30S1ADD1Address Line 1StringGeneric Edit400
45F54HS01MIncident Master Change History33I1ADD1Address Line 1StringGeneric Edit400
46F54HS02Incident People40S2ADD1Address Line 1StringGeneric Edit400
47F54HS02MIncident People Change History43I2ADD1Address Line 1StringGeneric Edit400
TOP74: EMEA Localization
48F74101Additional Address Book & Vat Id Info via VIES - EU - 013VVADD1Address Line 1StringGeneric Edit400
49F74101WAdditional Address Book & Vat Id Info Work File - EU - 013VWADD1Address Line 1StringGeneric Edit400
50F7430031Legal Document Address (Print Info) - COMM - 03B8PIADD1Address Line 1StringGeneric Edit400
TOP74B: Begium Localization
51F7403B11Belgium - Work File Yearly Vat Declaration Data3QAADD1Address Line 1StringGeneric Edit400
52F74B200Yearly/Quarterly VAT Listing - Belgium3VTADD1Address Line 1StringGeneric Edit400
TOP74U: United Kingdom Localizations
53F74U4052Subcontractor Detail - CIS Monthly Return - UK - 045SMADD1Address Line 1StringGeneric Edit400
54F74UUI52Subcontractor Detail - XML WF CIS Monthly Return - UK - 045SMADD1Address Line 1StringGeneric Edit400
TOP75A: Australia
55F75A0010Australian Employee Termination Details57A0ADD1Address Line 1StringGeneric Edit400
56F75A0220Payment Summary Workfile6PSADD1Address Line 1StringGeneric Edit400
TOP75C: China
57F75C001Chinese GUI cross reference file28CRADD1Address Line 1StringGeneric Edit400
TOP75I: India
58F75I100QTDS Form 26Q - WorkFile (Quarterly)16EFADD1Address Line 1StringGeneric Edit400
59F75I100WTDS Form 26 - WorkFile16EFADD1Address Line 1StringGeneric Edit400
60F75I210Tax Registration Details - IND - 002CSADD1Address Line 1StringGeneric Edit400
61F75I303Excise - ARE1 Bond Master-IND-75I10Q2ADD1Address Line 1StringGeneric Edit400
62F75I305Excise - General Surety Bond10Q3ADD1Address Line 1StringGeneric Edit400
TOP76A: Argentina
63F76A0209Header & Footer Invoice/ShipmentNote History WF - ARG - 76A17HFADD1Address Line 1StringGeneric Edit400
64F76A020PHeader/Footer Inv./ShipmentNote History WF Purge - AR - 76A17HFADD1Address Line 1StringGeneric Edit400
65F76A8002SICORE RG738 Withholding Entity - ARG - 04 - 76A3V3ADD1Address Line 1StringGeneric Edit400
66F76A82A/P Payment Control Group File - ARG - 04 - 76A26C6ADD1Address Line 1StringGeneric Edit400
67F76AUI20Header & Footer Invoice/ShipmentNote Workfile - ARG - - 76A17HFADD1Address Line 1StringGeneric Edit400
TOP76C: Colombia
68F76C571DIAN File Type 1 - COL - 0412R1ADD1Address Line 1StringGeneric Edit400
TOP76H: Chile
69F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H8PIADD1Address Line 1StringGeneric Edit400
TOP79A: Greenhouse Gas Accounting
70F79A75GHG Organization Name4GOADD1Address Line 1StringGeneric Edit400
TOPH90: EnterpriseOne TOOLS
71F012504Focus Registration16FOADD1Address Line 1StringGeneric Edit400
TOPH91: Design Tools
72F9801NEWEmployee Information - New Version4AAADD1Address Line 1StringGeneric Edit400
73F9801OLDEmployee Information - Old Version4AAADD1Address Line 1StringGeneric Edit400