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

79 columns | Print definition?920 | DOCM

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03: Accounts Receivable
1F0311Accounts Receivable Ledger8RPDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
2F0312A/R Batch Cash Application18RUDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP04: Accounts Payable
3F0411Z1Voucher Transactions - Batch Upload147VLDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
4F0411Z3F0411 Interoperability Table141SZDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
5F0413Accounts Payable - Matching Document3RMDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
6F0413AWF - 'As Of' Accounts Payable Payment Register3RMDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
7F0413PPurge - Accounts Payable Matching Documents3RMDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
8F0413Z1F0413 Interoperability Table16SYDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
9F04572A/P Payment Processing - Summary9KKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP05: Time Accounting and HRM Base
10F0607Wage Attachment Ledger File5JIDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP05A: PeopleSoft HR & PR Foundation
11F06345Historical Payroll Register20JLDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP05T: Time Entry
12F06116Z1Employee Transactions - Batch File189VLDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
13F06116Z2ESS Timecard History189VMDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP07: Payroll
14F06053Interim Check Parameters File2YWDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
15F06156Pay Check History Summary2YUDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
16F06166Pay Check History Tax Ledger2YVDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
17F06166ATax Ledger (Additional)12YVDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
18F06270Retro Processing Parameter15JPDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
19F06350IWF - Paycheck (Interims)10Y4DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
20F06560Bank Reconciliation - Issue File2Y8DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
21F06561Bank Reconciliation - Paid File2Y9DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
22F07350Payment File43Y0DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
23F07351Payment Distribution File10Y1DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
24F07355Pre-Payroll Error File30Y5DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
25F07991Deduction, Benefit, Accrual History Conversion Data2YXDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
26F07992Payroll Tax History Conversion Data3YQDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP08B: Benefits Administration
27F08371Reimbursement Spending Account Claims File20B6DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP08U: PeopleSoft HR US
28F08360Nondiscrimination Groups26HEDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP09: General Accounting
29F0917Bank Statement Detail28GDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
30F09617Auto Bank Statement Detail31GMDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP17C: Call Management
31F1755Case Master87ZADOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP42: Sales Management
32F42005Sales Commission File4SCDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
33F42UI005Sales Commission File4SCDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP43: Procurement
34F44445ZSubcontractor Waiver3SWDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP45: Advanced Pricing
35F4576Ship and Debit Claims40ACDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
36F4576TMPShip and Debit Claims- Temp Table40ACDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
37F4576Z1Ship and Debit Claims Unedited Transaction Table53Z1DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP47: Electronic Commerce
38F47056EDI Payment Order Header - Outbound20D1DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
39F470561EDI Payment Order Bank N & A - Outbound15D2DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
40F470561WEDI Payment Order Bank N & A - Work17D2DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
41F470562EDI Payment Order Vendor N & A - Outbound14D4DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
42F470562WEDI Payment Order Vendor N & A - Work14D4DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
43F470563EDI Payment Order Payee N & A - Outbound14D5DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
44F470563WEDI Payment Order Payee N & A - Work14D5DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
45F47056WEDI Payment Order Header - Work20D1DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
46F47057EDI Payment Order Remittance Advice - Outbound20D3DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
47F47057WEDI Payment Order Remittance Advice - Work20D3DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
48F47113EDI Lockbox/Payment Detail - Batch11Z3DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
49F47114EDI Lockbox/Payment Detail - Payment12Z4DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP48S: Service Billing
50F4812Billing Detail Workfile57WDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
51F4812HBilling Workfile History57WDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
52F4812HSBilling Workfile History Purged Save57WDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
53F48SUI01Billing Detail Print Workfile57WDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP49: Transportation Management
54F49595Document Print - Document Summary20DKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
55F49695Document Register18DRDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP53: Change Management
56F5302F5302 World Specs44DKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
57F5311Change Request Details Table121DKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
58F5311Z1Change Request Details Table Workfile126DKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP70: Multi-National Products
59F704001Payment WH Info TEMP - COMM - 045PTDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
60F704002Payment WH Info - COMM - 044PFDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
61F704002PPayment WH Info Purge - COMM - 044PFDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP74S: Spain
62F74S55Expenses and Exchange Rate for Payments - Spain - 043Q5DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP75A: Australia
63F75A0201Recipient Created Tax Invoice Tag File7TFDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
64F75A0220Payment Summary Workfile2PSDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP75J: Japan
65F750411Withholding Tax Detail - Japan - 0413JXDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP76A: Argentina
66F760499AContract Withholding - Advances - ARG -04 - 76A7K8DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
67F76A09Invoice Total - ARG - 03B - 76A5TTDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
68F76A09PInvoice Total Purge - ARG - 03B - 76A5TTDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
69F76A19Taxes - Tax Amounts by Invoice Suffix - ARG - 03B - 76A6TIDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
70F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A6TIDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
71F76A19Z1Taxes - Tax Amounts by Invoice Suffix Batch Entry A - - 76A24VKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
72F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A18IEDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
73F76AUI24Taxes Work File - ARG - 03B - 76A6TIDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP76C: Colombia
74F76CUI02Tax Detail - Work File - COL - 76C7TDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP76M: Mexico
75F76M0414F0414 - Payment Detail Tag File - Mexico4RTDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
76F76M413Manual Payment Header Additional Details - MEX - 045MWDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
77F76M572A/P Header Withholding Summary Details - MEX - 046WSDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP77: Payroll (Canadian)
78F0716Pay Check History Tax Ledger - Canadian DB2YVDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP89: Conversion Programs
79F42005ASales Commission File - Temporary4SCDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80