JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

161 columns | Print definition?920 | 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
24F085590Disability and Veteran Status History Table2DSALPHName - AlphaStringGeneric Edit400
25F085590WDisability Status Work Table2DSALPHName - AlphaStringGeneric Edit400
26F085605WVeteran Status Work Table2VSALPHName - AlphaStringGeneric Edit400
TOP05A: PeopleSoft HR & PR Foundation
27F05003Verification of Employment Data6EVALPHName - AlphaStringGeneric Edit400
28F060116Employee Master Information2YAALPHName - AlphaStringGeneric Edit400
29F0601161Point-In-Time Employee Master4PTALPHName - AlphaStringGeneric Edit400
30F060116WEE Master Request File2YAALPHName - AlphaStringGeneric Edit400
31F060116ZUnedited Quick Hire Transaction File15SZALPHName - AlphaStringGeneric Edit400
TOP05T: Time Entry
32F059063Employee Labor Distribution Period Overrides6EOALPHName - AlphaStringGeneric Edit400
33F06116Employee Transaction Detail File142YTALPHName - AlphaStringGeneric Edit400
34F06116Z1Employee Transactions - Batch File155VLALPHName - AlphaStringGeneric Edit400
35F06116Z2ESS Timecard History155VMALPHName - AlphaStringGeneric Edit400
36F06278Retro Timecard Detail File141YTALPHName - AlphaStringGeneric Edit400
37F069136Tip Disbursement4JEALPHName - AlphaStringGeneric Edit400
TOP07: Payroll
38F055011WAuto Deposit Instructions Work File3ADALPHName - AlphaStringGeneric Edit400
39F065016Automatic Bank Deposit Master3YGALPHName - AlphaStringGeneric Edit400
40F06560Bank Reconciliation - Issue File5Y8ALPHName - AlphaStringGeneric Edit400
41F06561Bank Reconciliation - Paid File5Y9ALPHName - AlphaStringGeneric Edit400
42F07350Payment File4Y0ALPHName - AlphaStringGeneric Edit400
43F07355Pre-Payroll Error File5Y5ALPHName - AlphaStringGeneric Edit400
44F074001New Hire Reporting Workfile - OneWorld Only8NHALPHName - AlphaStringGeneric Edit400
45F07621Employee Medical Leave Information5L1ALPHName - AlphaStringGeneric Edit400
46F07624Employee Medical Leave Change Information5L4ALPHName - AlphaStringGeneric Edit400
47F077011Tax History Integrity (Temp)7Y$ALPHName - AlphaStringGeneric Edit400
48F077011ATax History Integrity Additional (Temp)7Y$ALPHName - AlphaStringGeneric Edit400
49F077011BTax Integrity (PA Act32)7Y3ALPHName - AlphaStringGeneric Edit400
50F077021Transaction History Integrity(Temp)7Y$ALPHName - AlphaStringGeneric Edit400
51F07811Negative Amount Workfile4JEALPHName - AlphaStringGeneric Edit400
52F07855Employee Fund Allocation4AFALPHName - AlphaStringGeneric Edit400
53F07880SUI Magnetic Media Workfile24YWALPHName - AlphaStringGeneric Edit400
54F8907422New Hire Detail File - Massachusetts (22)4MAALPHName - AlphaStringGeneric Edit400
55F8907428New Hire Detail File - Nebraska(28)6NEALPHName - AlphaStringGeneric Edit400
TOP08: Human Resources
56F081161ACA Employee Eligibility14ADALPHName - AlphaStringGeneric Edit400
57F0811619ACA Employee Eligibility Archive14ADALPHName - AlphaStringGeneric Edit400
58F082003Grade/Step Progression Detail File3YWALPHName - AlphaStringGeneric Edit400
TOP08B: Benefits Administration
59F08380WFBatch Enrollment Work File3BEALPHName - AlphaStringGeneric Edit400
60F08381WFRecalculate Plan Option Costs3RCALPHName - AlphaStringGeneric Edit400
61F08901Participant file2HUALPHName - AlphaStringGeneric Edit400
TOP08R: Recruitment Management - (Appl. Track. & Req.)
62F08401Applicant Master2HAALPHName - AlphaStringGeneric Edit400
63F08401WFApplicant Work File3XNALPHName - AlphaStringGeneric Edit400
TOP08W: Wage and Salary
64F08201Salary Review Workfile5HRALPHName - AlphaStringGeneric Edit400
65F08830WFCompensation Root Work Table7YNALPHName - AlphaStringGeneric Edit400
TOP12: Fixed Assets
66F1205Equipment Messages2FTALPHName - AlphaStringGeneric Edit400
67F1205PEquipment Messages Purge Table2FTALPHName - AlphaStringGeneric Edit400
TOP15: Real Estate Management
68F1538WF - Expence Participation Register2NZALPHName - AlphaStringGeneric Edit400
69F1538BEP Billing Register2NZALPHName - AlphaStringGeneric Edit400
70F1548Escalation Billing Register2N1ALPHName - AlphaStringGeneric Edit400
71F1548BEscalation Billing Register2N1ALPHName - AlphaStringGeneric Edit400
TOP15L: Adv Real Estate Forecasting
72F15L001WWork File for R15L0014Q1ALPHName - AlphaStringGeneric Edit400
TOP17C: Call Management
73F1757Task Master11ZAALPHName - AlphaStringGeneric Edit400
TOP18: Timecard Automation
74F186602Labor Rules Tag File148TFALPHName - AlphaStringGeneric Edit400
TOP31B: Blend Management
75F31B02Staff Master3STALPHName - AlphaStringGeneric Edit400
76F31B111Work Group Staff Allocation9GSALPHName - AlphaStringGeneric Edit400
TOP40: Inventory/OP Base
77F40UI801Generic Error Table15ZBALPHName - AlphaStringGeneric Edit400
78F49211Sales Order Detail File - Tag File68UDALPHName - AlphaStringGeneric Edit400
79F49211Z1Sales Order Detail Tag Unedited Transaction File81S1ALPHName - AlphaStringGeneric Edit400
TOP40S: Supply Chain Self Service
80F4947SWSelf-Service Shipment Tracking Work File13SWALPHName - AlphaStringGeneric Edit400
TOP41: Inventory Management
81F41291ZLanded Cost Cache Table20IGALPHName - AlphaStringGeneric Edit400
TOP42: Sales Management
82F42UI11SO Detail Cache File (MBF)147ZDALPHName - AlphaStringGeneric Edit400
83F42UI800Sales Detail Work File - Sales Update39SDALPHName - AlphaStringGeneric Edit400
TOP42B: Sales Order Entry
84F49299S.O. Detail Tag Ledger File68UDALPHName - AlphaStringGeneric Edit400
TOP43E: Requisition Self Service
85F43E22Direct Connect Setup9PSALPHName - AlphaStringGeneric Edit400
TOP43Q: Strategic Sourcing
86F43Q10Event Header28EHALPHName - AlphaStringGeneric Edit400
87F43Q30Event Invited Bidders8EVALPHName - AlphaStringGeneric Edit400
88F43Q40Response Header18RAALPHName - AlphaStringGeneric Edit400
89F43Q50Analyze Event Header8AVALPHName - AlphaStringGeneric Edit400
TOP44H: Homebuilder Management
90F4454Vendor Assignment (World)8JGALPHName - AlphaStringGeneric Edit400
TOP47: Electronic Commerce
91F470373EDI ASN Shipping20AGALPHName - AlphaStringGeneric Edit400
92F470462EDI Invoice Expanded Header (Sales)9S5ALPHName - AlphaStringGeneric Edit400
93F470472EDI Invoice Expanded Detail (Sales)10S6ALPHName - AlphaStringGeneric Edit400
94F470561EDI Payment Order Bank N & A - Outbound23D2ALPHName - AlphaStringGeneric Edit400
95F470561WEDI Payment Order Bank N & A - Work25D2ALPHName - AlphaStringGeneric Edit400
96F470562EDI Payment Order Vendor N & A - Outbound23D4ALPHName - AlphaStringGeneric Edit400
97F470562WEDI Payment Order Vendor N & A - Work23D4ALPHName - AlphaStringGeneric Edit400
98F470563EDI Payment Order Payee N & A - Outbound23D5ALPHName - AlphaStringGeneric Edit400
99F470563WEDI Payment Order Payee N & A - Work23D5ALPHName - AlphaStringGeneric Edit400
100F47061EDI Planning Schedule Header - Inbound28MJALPHName - AlphaStringGeneric Edit400
101F47066EDI Planning Schedule Header - Outbound28MJALPHName - AlphaStringGeneric Edit400
102F47081EDI Price Sales Catalog Header - Inbound19FVALPHName - AlphaStringGeneric Edit400
103F47111EDI Lockbox/Payment Header - Transaction15Z1ALPHName - AlphaStringGeneric Edit400
104F47113EDI Lockbox/Payment Detail - Batch16Z3ALPHName - AlphaStringGeneric Edit400
105F47156EDI Shipping Schedule Header - Outbound93SYALPHName - AlphaStringGeneric Edit400
106F4780Address Cross-Reference7AXALPHName - AlphaStringGeneric Edit400
TOP49: Transportation Management
107F49130Shipment Document Workfile17BWALPHName - AlphaStringGeneric Edit400
108F49140SSCC Print Label Workfile9BWALPHName - AlphaStringGeneric Edit400
109F49T50Order Release Location Staging9LOALPHName - AlphaStringGeneric Edit400
110F49T70WCorporations Staging Work Table6CWALPHName - AlphaStringGeneric Edit400
111F49T80Locations Staging Table4LCALPHName - AlphaStringGeneric Edit400
112F49T80WLocations Staging Work Table6LWALPHName - AlphaStringGeneric Edit400
TOP70: Multi-National Products
113F703037Legal Document Contact Information - COMM - 03B5CIALPHName - AlphaStringGeneric Edit400
TOP74: EMEA Localization
114F74101Additional Address Book & Vat Id Info via VIES - EU - 012VVALPHName - AlphaStringGeneric Edit400
115F74101WAdditional Address Book & Vat Id Info Work File - EU - 012VWALPHName - AlphaStringGeneric Edit400
116F7430031Legal Document Address (Print Info) - COMM - 03B6PIALPHName - AlphaStringGeneric Edit400
TOP74B: Begium Localization
117F74B200Yearly/Quarterly VAT Listing - Belgium2VTALPHName - AlphaStringGeneric Edit400
TOP74L: Portugal
118F74LUI01Referential Account Details - Temp Table - 74L6TTALPHName - AlphaStringGeneric Edit400
TOP74Y: Italy
119F74Y015Yearly List Declaration - WF - IT - 0012YLALPHName - AlphaStringGeneric Edit400
120F74Y050Third party Black List Amounts - IT - 007THALPHName - AlphaStringGeneric Edit400
121F74YUI01Italy Legal Company WF - ITA - 74Y10LCALPHName - AlphaStringGeneric Edit400
TOP75I: India
122F75I100QTDS Form 26Q - WorkFile (Quarterly)15EFALPHName - AlphaStringGeneric Edit400
123F75I100WTDS Form 26 - WorkFile15EFALPHName - AlphaStringGeneric Edit400
124F75I303Excise - ARE1 Bond Master-IND-75I9Q2ALPHName - AlphaStringGeneric Edit400
125F75I305Excise - General Surety Bond9Q3ALPHName - AlphaStringGeneric Edit400
126F75I421Assign Price / Cost Elements4MAALPHName - AlphaStringGeneric Edit400
127F75I611TCS Prepayment Transaction File - IND-03B13TTALPHName - AlphaStringGeneric Edit400
TOP75J: Japan
128F75010Bank/Branch Master - Japan - 044J0ALPHName - AlphaStringGeneric Edit400
TOP75T: Taiwan
129F75T001GUI/VAT Declaration Site - 75T13DSALPHName - AlphaStringGeneric Edit400
130F75T004GUI/VAT Transaction Header - 75T68THALPHName - AlphaStringGeneric Edit400
131F75T0049GUI/VAT Transaction Header History - 75T68THALPHName - AlphaStringGeneric Edit400
132F75T004PGUI/VAT Transaction Header POS - 75T64THALPHName - AlphaStringGeneric Edit400
133F75T004ZGUI/VAT Transaction Header - Work - 75T44ZHALPHName - AlphaStringGeneric Edit400
TOP76A: Argentina
134F76A8001Generation SICORE's - Last Step -RG 738/99 - ARG - 04 - 76A19V2ALPHName - AlphaStringGeneric Edit400
135F76A8002SICORE RG738 Withholding Entity - ARG - 04 - 76A2V3ALPHName - AlphaStringGeneric Edit400
136F76A8014CITI Report - ARG - 04 - 76A5CTALPHName - AlphaStringGeneric Edit400
137F76A82A/P Payment Control Group File - ARG - 04 - 76A25C6ALPHName - AlphaStringGeneric Edit400
138F76AUI44CERG A/P - Worktable - ARG - 04 - 76A10WFALPHName - AlphaStringGeneric Edit400
139F76AUI46CERG A/R -Work File - ARG - 03B - 76A10WFALPHName - AlphaStringGeneric Edit400
TOP76B: Brazil
140F76B0520Address Book Brazilian Work File3ABALPHName - AlphaStringGeneric Edit400
141F76B103Verification ICMS / IPI - Information - 4211QDALPHName - AlphaStringGeneric Edit400
142F76B70Physical and Legal Person Table - IN68 - 428FJALPHName - AlphaStringGeneric Edit400
TOP76C: Colombia
143F76CT2Sales/Use/V.A.T. Tax File - COL - 76C26CTALPHName - AlphaStringGeneric Edit400
TOP76H: Chile
144F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H7PIALPHName - AlphaStringGeneric Edit400
145F76HUI32Workfile for R76H3B40 - CHI - 42 - 76H16WFALPHName - AlphaStringGeneric Edit400
TOP76V: Venezuela
146F76VTARTTemporal Table for Withholdings - VEN -04 - 76V5TRALPHName - AlphaStringGeneric Edit400
TOP77: Payroll (Canadian)
147F77173ROE Summary History Work File2JFALPHName - AlphaStringGeneric Edit400
148F77200Canadian Employee Year-End Form Header - F7720011J5ALPHName - AlphaStringGeneric Edit400
149F77201TNegative Amount Print10NAALPHName - AlphaStringGeneric Edit400
150F77703Payroll History Audit Report - Worktable6ARALPHName - AlphaStringGeneric Edit400
TOP89: Conversion Programs
151F01111Z1Batch - Contact Information22CBALPHName - AlphaStringGeneric Edit400
TOP90CA: CRM Foundation
152F90CA041Employee and Subordinates3ESALPHName - AlphaStringGeneric Edit400
TOP90CB: CRM Sales Force Automation
153F90CB02EOpportunity_Employee Table3OEALPHName - AlphaStringGeneric Edit400
154F90CB040Qualification Table2QLALPHName - AlphaStringGeneric Edit400
TOPH90: EnterpriseOne TOOLS
155F0112Time Log Ledger File2PTALPHName - AlphaStringGeneric Edit400
156F01131PPAT Message Control File3ZZALPHName - AlphaStringGeneric Edit400
157F01133PPAT Message Detail File3ZTALPHName - AlphaStringGeneric Edit400
TOPH91: Design Tools
158F9801NEWEmployee Information - New Version2AAALPHName - AlphaStringGeneric Edit400
159F9801OLDEmployee Information - Old Version2AAALPHName - AlphaStringGeneric Edit400
TOPH92: Interactive Engine/OL
160F98231DOMW Transfer Activity Rule Director - Detail1TDALPHName - AlphaStringGeneric Edit400
161F98231HOMW Transfer Activity Rule Director - Header1TRALPHName - AlphaStringGeneric Edit400