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
4F0911GLAccount Ledger
5F4311PDPurchase Order Detail File
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F0006MCBusiness Unit Master
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
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
4F0411RPAccounts Payable Ledger
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

38 columns | Print definition?910 | PRTR

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F06106Employee Pay Instructions74YMPRTRTransaction No. - PayrollNumericGeneric Edit90
2F0618Employee Transaction History3YTPRTRTransaction No. - PayrollNumericGeneric Edit90
3F0709Deduction/Benefit/Accrual Ledger File9Y$PRTRTransaction No. - PayrollNumericGeneric Edit90
TOP05T: Time Entry
4F06116Employee Transaction Detail File3YTPRTRTransaction No. - PayrollNumericGeneric Edit90
5F06116Z1Employee Transactions - Batch File20VLPRTRTransaction No. - PayrollNumericGeneric Edit90
6F06116Z2ESS Timecard History20VMPRTRTransaction No. - PayrollNumericGeneric Edit90
7F0624Burden Distribution File1J#PRTRTransaction No. - PayrollNumericGeneric Edit90
8F06241Burden Distribution File1J#PRTRTransaction No. - PayrollNumericGeneric Edit90
9F06278Retro Timecard Detail File6YTPRTRTransaction No. - PayrollNumericGeneric Edit90
TOP06: Payroll (old) - Obsolete-do not reuse
10F0618TATemp table for F0618T for conversion2YTPRTRTransaction No. - PayrollNumericGeneric Edit90
TOP07: Payroll
11F0719DBA Transaction Detail History9Y$PRTRTransaction No. - PayrollNumericGeneric Edit90
12F0724Burden Distribution File1YSPRTRTransaction No. - PayrollNumericGeneric Edit90
13F07241Burden Distribution File1YSPRTRTransaction No. - PayrollNumericGeneric Edit90
14F0728Employee Paid Workers Compensation Transactions2YWPRTRTransaction No. - PayrollNumericGeneric Edit90
15F0729Employee DBA Override Instructions7Y9PRTRTransaction No. - PayrollNumericGeneric Edit90
16F07620Leave Transactions4LVPRTRTransaction No. - PayrollNumericGeneric Edit90
17F07623Employee FMLA Request Header4L3PRTRTransaction No. - PayrollNumericGeneric Edit90
18F07831Employee State/Local Control Table12YBPRTRTransaction No. - PayrollNumericGeneric Edit90
19F079430Prevailing Wage Transaction Detail3PWPRTRTransaction No. - PayrollNumericGeneric Edit90
20F079435Prevailing Wage Fringe Detail4PFPRTRTransaction No. - PayrollNumericGeneric Edit90
21F079440Prevailing Wage Transaction History3PWPRTRTransaction No. - PayrollNumericGeneric Edit90
22F079445Prevailing Wage Fringe History4PHPRTRTransaction No. - PayrollNumericGeneric Edit90
23F07UI200Timecard History Work File5THPRTRTransaction No. - PayrollNumericGeneric Edit90
TOP08AD: ADP Integration
24F051371ADP Employee DBA Instructions79ADPRTRTransaction No. - PayrollNumericGeneric Edit90
TOP08B: Benefits Administration
25F08371Reimbursement Spending Account Claims File29B6PRTRTransaction No. - PayrollNumericGeneric Edit90
TOP18: Resource Scheduling
26F186602Labor Rules Tag File1TFPRTRTransaction No. - PayrollNumericGeneric Edit90
TOP31: Shop Floor Control
27F31122Work Order Time Transactions5WTPRTRTransaction No. - PayrollNumericGeneric Edit90
28F31122SPurge Work Order Time Transactions5WTPRTRTransaction No. - PayrollNumericGeneric Edit90
29F31122Z1Work Order Time Transactions Unedited Transaction Table18SZPRTRTransaction No. - PayrollNumericGeneric Edit90
TOP48S: Service Billing
30F4812Billing Detail Workfile33WDPRTRTransaction No. - PayrollNumericGeneric Edit90
31F4812HBilling Workfile History33WDPRTRTransaction No. - PayrollNumericGeneric Edit90
32F4812HSBilling Workfile History Purged Save33WDPRTRTransaction No. - PayrollNumericGeneric Edit90
33F48S0618Payroll Reclassification Workfile3YTPRTRTransaction No. - PayrollNumericGeneric Edit90
34F48S910Billing Detail Journal Workfile79W2PRTRTransaction No. - PayrollNumericGeneric Edit90
35F48SUI01Billing Detail Print Workfile33WDPRTRTransaction No. - PayrollNumericGeneric Edit90
TOP75Z: New Zealand - Reporting System Only
36F75Z0006Leave Taken A.G.E. Work File2Z6PRTRTransaction No. - PayrollNumericGeneric Edit90
TOP89: Conversion Programs
37F06116TNeeded for upgrade from Xe to B91YTPRTRTransaction No. - PayrollNumericGeneric Edit90
38F0618TNeeded for upgrade from Xe to B91YTPRTRTransaction No. - PayrollNumericGeneric Edit90