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
2F9671SDSoftware Update Detail Table
3F0101ABAddress Book Master
4F4101IMItem Master
5F0911GLAccount Ledger
6F4311PDPurchase Order Detail File
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F03012AICustomer Master by Line of Business
10F41021LIItem Location File

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
10F4111ILItem Ledger File

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

73 columns | Print definition?812 | 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 File147VLDOCMDocument - 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 - Summary File9KKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP05: Time Accounting and HRM Base
10F0607Wage Attachment Ledger File5JIDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP05A: OW 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
TOP07: Payroll
13F06053Interim Check Parameters File2YWDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
14F06156Pay Check History Summary2YUDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
15F06166Pay Check History Tax Ledger2YVDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
16F06166ATax Ledger (Additional)12YVDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
17F06270Retro Processing Parameter15JPDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
18F06350IWF - Paycheck (Interims)10Y4DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
19F06560Bank Reconciliation - Issue File2Y8DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
20F06561Bank Reconciliation - Paid File2Y9DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
21F07350Payment File43Y0DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
22F07351Payment Distribution File10Y1DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
23F07355Pre-Payroll Error File30Y5DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
24F07991Deduction - Benefit - Accrual History Conversion Data2YXDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
25F07992Payroll Tax History Conversion Data3YQDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP08B: Benefits Administration
26F08371Reimbursement Spending Account Claims File20B6DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP08U: OW HR US
27F08360Nondiscrimination Groups26HEDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP09: General Accounting
28F0917Bank Statement Detail28GDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
29F09617Auto Bank Statement Detail31GMDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP17C: Call Management
30F1755Customer Call Master87ZADOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP42: Sales Management
31F42005Sales Commission File4SCDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
32F42UI005Sales Commission File4SCDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP43: Procurement
33F44445ZSubcontractor Waiver3SWDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP45: Advanced Pricing
34F4576Ship and Debit Claims40ACDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
35F4576TMPShip and Debit Claims- Temp Table40ACDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
36F4576Z1Ship and Debit Claims Unedited Transaction Table53Z1DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP47: Electronic Commerce
37F47056EDI Payment Order Header - Outbound20D1DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
38F470561EDI Payment Order Bank N and A - Outbound15D2DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
39F470561WEDI Payment Order Bank N and A - Work17D2DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
40F470562EDI Payment Order Vendor N and A - Outbound14D4DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
41F470562WEDI Payment Order Vendor N and A - Work14D4DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
42F470563EDI Payment Order Payee N and A - Outbound14D5DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
43F470563WEDI Payment Order Payee N and A - Work14D5DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
44F47056WEDI Payment Order Header - Work20D1DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
45F47057EDI Payment Order Remittance Advice - Outbound20D3DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
46F47057WEDI Payment Order Remittance Advice - Work20D3DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
47F47113EDI Lockbox/Payment Detail - Batch11Z3DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
48F47114EDI Lockbox/Payment Detail - Payment12Z4DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP48S: Service Billing
49F4812Billing Detail Workfile57WDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
50F4812HBilling Workfile - History57WDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
51F4812HSBilling Workfile History Purged Save57WDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
52F48SUI01Billing Detail Print Workfile57WDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP49: Transportation Management
53F49595Document Print - Document Summary20DKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
54F49695Document Register18DRDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP53: Change Management
55F5302F5302 World Specs44DKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
56F5311Change Request Details Table121DKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
57F5311Z1Change Request Details Table Workfile126DKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP74: EMEA Localization
58F74S55Expenses and Exchange Rate for Payments - Spain3Q5DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP75A: Australia - Reporting System Only
59F75A0201Recipient Created Tax Invoice Tag File7TFDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
60F75A0220Payment Summary Workfile2PSDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP75J: Japan - Reporting System Only
61F750411Withholding Tax Detail Table - Japan13JXDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP76A: Argentina
62F760499AContract Withholding - Advances - ARG -04 - 047K8DOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
63F76A09Invoice Total - ARG - 00 - 005TTDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
64F76A09PInvoice Total Purge - ARG - 03B - 76A5TTDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
65F76A19Taxes - Tax Amounts by Invoice Suffix AGR6TIDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
66F76A19PTaxes - Tax Amounts by Invoice Suffix Purge ARG - 03B - 76A6TIDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
67F76A19Z1Taxes - Tax Amounts by Invoice Suffix - Batch Entry A - 03B24VKDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
68F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A18IEDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
69F76AUI24Taxes Work File - ARG - 006TIDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP76C: Colombia
70F76CUI02Tax Detail - Work File - COL - 76C7TDDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP76M: Mexico
71F76M0414F0414 - Payment Detail Tag File - Mexico4RTDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP77: Payroll (Canadian)
72F0716Pay Check History Tax Ledger - Canadian DB2YVDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80
TOP89: Conversion Programs
73F42005ASales Commission File - Temporary4SCDOCMDocument - Matching(Payment or Item)NumericGeneric Edit80