JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

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

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

166 columns | Print definition?910 | ALPH

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F004201Prepayment Transaction Table22PTALPHName - AlphaStringGeneric Edit400
TOP01: Address Book
2F0101Address Book Master4ABALPHName - AlphaStringGeneric Edit400
3F0101Z2Address Book - Interoperability17SZALPHName - AlphaStringGeneric Edit400
4F0111Address Book - Who's Who8WWALPHName - AlphaStringGeneric Edit400
5F0111Z1Batch Who's Who Information21BWALPHName - AlphaStringGeneric Edit400
6F01161DWCustomer Alternate Address Export6DWALPHName - AlphaStringGeneric Edit400
TOP02: Electronic Mail
7F0113Message Log Ledger File2ZZALPHName - AlphaStringGeneric Edit400
TOP03: Accounts Receivable
8F0311Accounts Receivable Ledger105RPALPHName - AlphaStringGeneric Edit400
TOP03B: Enhanced Accounts Receivable
9F00171Interoperability-Net Change Table2NCALPHName - AlphaStringGeneric Edit400
10F03B11Customer Ledger90RPALPHName - AlphaStringGeneric Edit400
11F03B11PCustomer Ledger Purge File90RPALPHName - AlphaStringGeneric Edit400
12F03B11Z1Batch Invoices106VJALPHName - AlphaStringGeneric Edit400
13F03B11Z2F03B11 Interoperability Table103SYALPHName - AlphaStringGeneric Edit400
14F03B13Receipts Header41RYALPHName - AlphaStringGeneric Edit400
15F03B13PReceipts Header Purge File41RYALPHName - AlphaStringGeneric Edit400
16F03B13Z2F03B13 Interoperability Table54SYALPHName - AlphaStringGeneric Edit400
17F03B15TF03B15 Tag Table4RTALPHName - AlphaStringGeneric Edit400
18F03B22A/R Fee Journal History19RSALPHName - AlphaStringGeneric Edit400
19F03B23A/R Fee Journal History Detail18RTALPHName - AlphaStringGeneric Edit400
20F03B575Auto Debit Invoice Select and Build99RDALPHName - AlphaStringGeneric Edit400
21F03B672Draft Remittance40RDALPHName - AlphaStringGeneric Edit400
TOP04: Accounts Payable
22F04572A/P Payment Processing - Summary15KKALPHName - AlphaStringGeneric Edit400
TOP05: Time Accounting and HRM Base
23F051171Goal Actions20GLALPHName - AlphaStringGeneric Edit400
TOP05A: OW HR & PR Foundation
24F05003Verification of Employment Data6EVALPHName - AlphaStringGeneric Edit400
25F060116Employee Master Information2YAALPHName - AlphaStringGeneric Edit400
26F0601161Point-In-Time Employee Master4PTALPHName - AlphaStringGeneric Edit400
27F060116WEE Master Request File2YAALPHName - AlphaStringGeneric Edit400
28F060116ZUnedited Quick Hire Transaction File15SZALPHName - AlphaStringGeneric Edit400
TOP05T: Time Entry
29F059063Employee Labor Distribution Period Overrides6EOALPHName - AlphaStringGeneric Edit400
30F06116Employee Transaction Detail File142YTALPHName - AlphaStringGeneric Edit400
31F06116Z1Employee Transactions - Batch File155VLALPHName - AlphaStringGeneric Edit400
32F06116Z2ESS Timecard History155VMALPHName - AlphaStringGeneric Edit400
33F06278Retro Timecard Detail File141YTALPHName - AlphaStringGeneric Edit400
34F069136Tip Disbursement4JEALPHName - AlphaStringGeneric Edit400
TOP07: Payroll
35F065016Automatic Bank Deposit Master3YGALPHName - AlphaStringGeneric Edit400
36F06560Bank Reconciliation - Issue File5Y8ALPHName - AlphaStringGeneric Edit400
37F06561Bank Reconciliation - Paid File5Y9ALPHName - AlphaStringGeneric Edit400
38F07350Payment File4Y0ALPHName - AlphaStringGeneric Edit400
39F07355Pre-Payroll Error File5Y5ALPHName - AlphaStringGeneric Edit400
40F074001New Hire Reporting Workfile - OneWorld Only8NHALPHName - AlphaStringGeneric Edit400
41F07621Employee Medical Leave Information5L1ALPHName - AlphaStringGeneric Edit400
42F07624Employee Medical Leave Change Information5L4ALPHName - AlphaStringGeneric Edit400
43F077011Tax History Integrity (Temp)7Y$ALPHName - AlphaStringGeneric Edit400
44F077011ATax History Integrity Additional (Temp)7Y$ALPHName - AlphaStringGeneric Edit400
45F077011BTax Integrity (PA Act32)7Y3ALPHName - AlphaStringGeneric Edit400
46F077021Transaction History Integrity(Temp)7Y$ALPHName - AlphaStringGeneric Edit400
47F07811Negative Amount Workfile4JEALPHName - AlphaStringGeneric Edit400
48F07855Employee Fund Allocation4AFALPHName - AlphaStringGeneric Edit400
49F07880SUI Magnetic Media Workfile24YWALPHName - AlphaStringGeneric Edit400
50F8907422New Hire Detail File - Massachusetts (22)4MAALPHName - AlphaStringGeneric Edit400
51F8907428New Hire Detail File - Nebraska(28)6NEALPHName - AlphaStringGeneric Edit400
TOP08: Human Resources
52F082003Grade/Step Progression Detail File3YWALPHName - AlphaStringGeneric Edit400
TOP08A: eRecruit
53F08496References3RFALPHName - AlphaStringGeneric Edit400
TOP08B: Benefits Administration
54F08380WFBatch Enrollment Work File3BEALPHName - AlphaStringGeneric Edit400
55F08381WFRecalculate Plan Option Costs3RCALPHName - AlphaStringGeneric Edit400
56F08901Participant file2HUALPHName - AlphaStringGeneric Edit400
TOP08R: Recruitment Management - (Appl. Track. & Req.)
57F08401Applicant Master2HAALPHName - AlphaStringGeneric Edit400
58F08401WFApplicant Work File3XNALPHName - AlphaStringGeneric Edit400
TOP08W: Wage and Salary
59F08201Salary Review Workfile5HRALPHName - AlphaStringGeneric Edit400
60F08830WFCompensation Root Work Table7YNALPHName - AlphaStringGeneric Edit400
TOP12: Fixed Assets
61F1205Equipment Messages2FTALPHName - AlphaStringGeneric Edit400
62F1205PEquipment Messages Purge Table2FTALPHName - AlphaStringGeneric Edit400
TOP15: Property Management
63F1538WF - Expence Participation Register2NZALPHName - AlphaStringGeneric Edit400
64F1538BEP Billing Register2NZALPHName - AlphaStringGeneric Edit400
65F1548Escalation Billing Register2N1ALPHName - AlphaStringGeneric Edit400
66F1548BEscalation Billing Register2N1ALPHName - AlphaStringGeneric Edit400
TOP15L: Adv Real Estate Forecasting
67F15L001WWork File for R15L0014Q1ALPHName - AlphaStringGeneric Edit400
TOP17C: Call Management
68F1757Task Master11ZAALPHName - AlphaStringGeneric Edit400
TOP18: Resource Scheduling
69F186602Labor Rules Tag File148TFALPHName - AlphaStringGeneric Edit400
TOP31B: Blend Management
70F31B02Staff Master3STALPHName - AlphaStringGeneric Edit400
71F31B111Work Group Staff Allocation9GSALPHName - AlphaStringGeneric Edit400
TOP40: Inventory/OP Base
72F40UI801Generic Error Table15ZBALPHName - AlphaStringGeneric Edit400
73F49211Sales Order Detail File - Tag File68UDALPHName - AlphaStringGeneric Edit400
74F49211Z1Sales Order Detail Tag Unedited Transaction File81S1ALPHName - AlphaStringGeneric Edit400
TOP40S: Supply Chain Self Service
75F4947SWSelf-Service Shipment Tracking Work File13SWALPHName - AlphaStringGeneric Edit400
TOP41: Inventory Management
76F41291ZLanded Cost Cache Table20IGALPHName - AlphaStringGeneric Edit400
TOP42: Sales Management
77F42UI11SO Detail Cache File (MBF)147ZDALPHName - AlphaStringGeneric Edit400
78F42UI800Sales Detail Work File - Sales Update39SDALPHName - AlphaStringGeneric Edit400
TOP42B: Sales Order Entry
79F49299S.O. Detail Tag Ledger File68UDALPHName - AlphaStringGeneric Edit400
TOP43E: Requisition Self Service
80F43E22Direct Connect Setup9PSALPHName - AlphaStringGeneric Edit400
TOP43Q: Strategic Sourcing
81F43Q10Event Header28EHALPHName - AlphaStringGeneric Edit400
82F43Q30Event Invited Bidders8EVALPHName - AlphaStringGeneric Edit400
83F43Q40Response Header18RAALPHName - AlphaStringGeneric Edit400
84F43Q50Analyze Event Header8AVALPHName - AlphaStringGeneric Edit400
TOP44H: Homebuilder Management
85F4454Vendor Assignment (World)8JGALPHName - AlphaStringGeneric Edit400
TOP47: Electronic Commerce
86F470373EDI ASN Shipping20AGALPHName - AlphaStringGeneric Edit400
87F470462EDI Invoice Expanded Header (Sales)9S5ALPHName - AlphaStringGeneric Edit400
88F470472EDI Invoice Expanded Detail (Sales)10S6ALPHName - AlphaStringGeneric Edit400
89F470561EDI Payment Order Bank N & A - Outbound23D2ALPHName - AlphaStringGeneric Edit400
90F470561WEDI Payment Order Bank N & A - Work25D2ALPHName - AlphaStringGeneric Edit400
91F470562EDI Payment Order Vendor N & A - Outbound23D4ALPHName - AlphaStringGeneric Edit400
92F470562WEDI Payment Order Vendor N & A - Work23D4ALPHName - AlphaStringGeneric Edit400
93F470563EDI Payment Order Payee N & A - Outbound23D5ALPHName - AlphaStringGeneric Edit400
94F470563WEDI Payment Order Payee N & A - Work23D5ALPHName - AlphaStringGeneric Edit400
95F47061EDI Planning Schedule Header - Inbound28MJALPHName - AlphaStringGeneric Edit400
96F47066EDI Planning Schedule Header - Outbound28MJALPHName - AlphaStringGeneric Edit400
97F47081EDI Price Sales Catalog Header - Inbound19FVALPHName - AlphaStringGeneric Edit400
98F47111EDI Lockbox/Payment Header - Transaction15Z1ALPHName - AlphaStringGeneric Edit400
99F47113EDI Lockbox/Payment Detail - Batch16Z3ALPHName - AlphaStringGeneric Edit400
100F47156EDI Shipping Schedule Header - Outbound93SYALPHName - AlphaStringGeneric Edit400
101F4780Address Cross-Reference7AXALPHName - AlphaStringGeneric Edit400
TOP49: Transportation Management
102F49130Shipment Document Workfile17BWALPHName - AlphaStringGeneric Edit400
103F49140SSCC Print Label Workfile9BWALPHName - AlphaStringGeneric Edit400
104F49T50Order Release Location Staging9LOALPHName - AlphaStringGeneric Edit400
105F49T70WCorporations Staging Work Table6CWALPHName - AlphaStringGeneric Edit400
106F49T80Locations Staging Table4LCALPHName - AlphaStringGeneric Edit400
107F49T80WLocations Staging Work Table6LWALPHName - AlphaStringGeneric Edit400
TOP55: Reserved for Clients
108F5574T12Cash Flow Table -BO3CFALPHName - AlphaStringGeneric Edit400
109F55ARAP1AR and AP temp table2ARALPHName - AlphaStringGeneric Edit400
110F55IF001Address Book Extension3EXALPHName - AlphaStringGeneric Edit400
111F55IF311As Of2RPALPHName - AlphaStringGeneric Edit400
112F55IF421Sales Order per BO210SDALPHName - AlphaStringGeneric Edit400
113F55IF425Sales Order per BO - 2005210SDALPHName - AlphaStringGeneric Edit400
114F55IFVABOutput File di R55IFVALB2OZALPHName - AlphaStringGeneric Edit400
115F55IFVALOutput File di R55IFVALOR5FAALPHName - AlphaStringGeneric Edit400
116F59I0022P07 Shipment Details - Serial Numbers6PSALPHName - AlphaStringGeneric Edit400
117F59W0010P00 Agilero Users - Profiles3AUALPHName - AlphaStringGeneric Edit400
TOP70: Multi-National Products - obsolete-do not reuse
118F703037Legal Document Contact Information - COMM - 03B5CIALPHName - AlphaStringGeneric Edit400
TOP74: EMEA Localization
119F74101Additional Address Book & Vat Id Info via VIES - EU - 012VVALPHName - AlphaStringGeneric Edit400
120F74101WAdditional Address Book & Vat Id Info Work File - EU - 012VWALPHName - AlphaStringGeneric Edit400
121F7430031Legal Document Address (Print Info) - COMM - 03B6PIALPHName - AlphaStringGeneric Edit400
TOP74B: Begium Localization
122F74B200Yearly/Quarterly VAT Listing - Belgium2VTALPHName - AlphaStringGeneric Edit400
TOP74Y: Italy - Reporting System Only
123F74Y015Yearly List Declaration - WF - IT - 0012YLALPHName - AlphaStringGeneric Edit400
124F74Y050Third party Black List Amounts - IT - 007THALPHName - AlphaStringGeneric Edit400
125F74YUI01Italy Legal Company WF - ITA - 74Y10LCALPHName - AlphaStringGeneric Edit400
TOP75I: India
126F75I100QTDS Form 26Q - WorkFile (Quarterly)15EFALPHName - AlphaStringGeneric Edit400
127F75I100WTDS Form 26 - WorkFile15EFALPHName - AlphaStringGeneric Edit400
128F75I303Excise - ARE1 Bond Master-IND-75I9Q2ALPHName - AlphaStringGeneric Edit400
129F75I305Excise - General Surety Bond9Q3ALPHName - AlphaStringGeneric Edit400
130F75I421Assign Price / Cost Elements4MAALPHName - AlphaStringGeneric Edit400
131F75I611TCS Prepayment Transaction File - IND-03B13TTALPHName - AlphaStringGeneric Edit400
TOP75J: Japan - Reporting System Only
132F75010Bank/Branch Master - Japan - 044J0ALPHName - AlphaStringGeneric Edit400
TOP75T: Taiwan
133F75T001GUI/VAT Declaration Site - 75T13DSALPHName - AlphaStringGeneric Edit400
134F75T004GUI/VAT Transaction Header - 75T68THALPHName - AlphaStringGeneric Edit400
135F75T0049GUI/VAT Transaction Header History - 75T68THALPHName - AlphaStringGeneric Edit400
136F75T004PGUI/VAT Transaction Header POS - 75T64THALPHName - AlphaStringGeneric Edit400
137F75T004ZGUI/VAT Transaction Header - Work - 75T44ZHALPHName - AlphaStringGeneric Edit400
TOP76A: Argentina
138F76A8001Generation SICOREs - Last Step -RG 738/99 - ARG - 04 - 76A19V2ALPHName - AlphaStringGeneric Edit400
139F76A8002SICORE RG738 Withholding Entity - ARG - 04 - 76A2V3ALPHName - AlphaStringGeneric Edit400
140F76A8014CITI Report - ARG - 04 - 76A5CTALPHName - AlphaStringGeneric Edit400
141F76A82A/P Payment Control Group File - ARG - 04 - 76A25C6ALPHName - AlphaStringGeneric Edit400
142F76AUI44CERG A/P - Worktable - ARG - 04 - 76A10WFALPHName - AlphaStringGeneric Edit400
143F76AUI46CERG A/R -Work File - ARG - 03B - 76A10WFALPHName - AlphaStringGeneric Edit400
TOP76B: Brazil - Reporting System Only
144F76B0520Address Book Brazilian Work File3ABALPHName - AlphaStringGeneric Edit400
145F76B103Verification ICMS / IPI - Information - 4211QDALPHName - AlphaStringGeneric Edit400
146F76B70Physical and Legal Person Table - IN68 - 428FJALPHName - AlphaStringGeneric Edit400
TOP76C: Colombia
147F76CT2Sales/Use/V.A.T. Tax File - COL - 76C26CTALPHName - AlphaStringGeneric Edit400
TOP76H: Chile
148F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H7PIALPHName - AlphaStringGeneric Edit400
149F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H16WFALPHName - AlphaStringGeneric Edit400
TOP76V: Venezuela
150F76VTARTTemporal Table for Withholdings - VEN -04 - 76V5TRALPHName - AlphaStringGeneric Edit400
TOP77: Payroll (Canadian)
151F77173ROE Summary History Work File2JFALPHName - AlphaStringGeneric Edit400
152F77200Canadian Employee Year-End Form Header - F7720011J5ALPHName - AlphaStringGeneric Edit400
153F77201TNegative Amount Print10NAALPHName - AlphaStringGeneric Edit400
154F77703Payroll History Audit Report - Worktable6ARALPHName - AlphaStringGeneric Edit400
TOP80D: Plant Manager Dashboard
155F80D120SOD Violations10SVALPHName - AlphaStringGeneric Edit400
TOP89: Conversion Programs
156F01111Z1Batch - Contact Information22CBALPHName - AlphaStringGeneric Edit400
TOP90CA: CRM Foundation
157F90CA041Employee and Subordinates3ESALPHName - AlphaStringGeneric Edit400
TOP90CB: CRM Sales Force Automation
158F90CB02EOpportunity_Employee Table3OEALPHName - AlphaStringGeneric Edit400
159F90CB040Qualification Table2QLALPHName - AlphaStringGeneric Edit400
TOPH90: ONEWORLD TOOLS
160F0112Time Log Ledger File2PTALPHName - AlphaStringGeneric Edit400
161F01131PPAT Message Control File3ZZALPHName - AlphaStringGeneric Edit400
162F01133PPAT Message Detail File3ZTALPHName - AlphaStringGeneric Edit400
TOPH91: Design Tools
163F9801NEWEmployee Information - New Version2AAALPHName - AlphaStringGeneric Edit400
164F9801OLDEmployee Information - Old Version2AAALPHName - AlphaStringGeneric Edit400
TOPH92: Interactive Engine/OL
165F98231DOMW Transfer Activity Rule Director - Detail1TDALPHName - AlphaStringGeneric Edit400
166F98231HOMW Transfer Activity Rule Director - Header1TRALPHName - AlphaStringGeneric Edit400