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

142 columns | Print definition?812 | ALPH

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