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
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
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

151 columns | Print definition?920 | RMK

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00092Supplemental Data18T3RMKName - RemarkStringGeneric Edit300
2F00189WF - Tax Reconciliation19TGRMKName - RemarkStringGeneric Edit300
3F0050Organization Structure Master File7MARMKName - RemarkStringGeneric Edit300
4F00692Cost Center Supplemental Data Codes7M2RMKName - RemarkStringGeneric Edit300
5F5301Change Request Master Table4DIRMKName - RemarkStringGeneric Edit300
TOP01: Address Book
6F0101Address Book Master63ABRMKName - RemarkStringGeneric Edit300
7F0101Z2Address Book - Interoperability76SZRMKName - RemarkStringGeneric Edit300
8F01092Supplemental Database - Code9A2RMKName - RemarkStringGeneric Edit300
9F0150Address Organization Structure Master7MARMKName - RemarkStringGeneric Edit300
10F01501Enhanced Parent Child9PRRMKName - RemarkStringGeneric Edit300
TOP03: Accounts Receivable
11F0311Accounts Receivable Ledger93RPRMKName - RemarkStringGeneric Edit300
12F0312A/R Batch Cash Application24RURMKName - RemarkStringGeneric Edit300
TOP03B: Enhanced Accounts Receivable
13F03B11Customer Ledger89RPRMKName - RemarkStringGeneric Edit300
14F03B112Invoice Revisions25RWRMKName - RemarkStringGeneric Edit300
15F03B112PInvoice Revisions Purge File25RWRMKName - RemarkStringGeneric Edit300
16F03B11PCustomer Ledger Purge File89RPRMKName - RemarkStringGeneric Edit300
17F03B11Z1Batch Invoices105VJRMKName - RemarkStringGeneric Edit300
18F03B11Z2F03B11 Interoperability Table102SYRMKName - RemarkStringGeneric Edit300
19F03B13Z1Electronic Receipts Input31RURMKName - RemarkStringGeneric Edit300
20F03B14Receipts Detail77RZRMKName - RemarkStringGeneric Edit300
21F03B14PReceipts Detail Purge File77RZRMKName - RemarkStringGeneric Edit300
22F03B14Z2F03B14 Interoperability Table90SZRMKName - RemarkStringGeneric Edit300
23F03B21A/R Notification History Detail14ZSRMKName - RemarkStringGeneric Edit300
24F03B22A/R Fee Journal History18RSRMKName - RemarkStringGeneric Edit300
25F03B31Customer Activity Log8ZGRMKName - RemarkStringGeneric Edit300
26F03B575Auto Debit Invoice Select and Build98RDRMKName - RemarkStringGeneric Edit300
TOP04: Accounts Payable
27F0411Accounts Payable Ledger71RPRMKName - RemarkStringGeneric Edit300
28F0411AWF - 'As Of' Accounts Payable Ledger71RPRMKName - RemarkStringGeneric Edit300
29F0411PPurge - Accounts Payable Ledger71RPRMKName - RemarkStringGeneric Edit300
30F0411Z1Voucher Transactions - Batch Upload89VLRMKName - RemarkStringGeneric Edit300
31F0411Z3F0411 Interoperability Table94SZRMKName - RemarkStringGeneric Edit300
32F0414Accounts Payable Matching Document Detail29RNRMKName - RemarkStringGeneric Edit300
33F0414AWF - 'As Of' Accounts Payable Payment Detail29RNRMKName - RemarkStringGeneric Edit300
34F0414PPurge - Accounts Payable Matching Document Detail29RNRMKName - RemarkStringGeneric Edit300
35F0414Z1F0414 Interoperability Table42SZRMKName - RemarkStringGeneric Edit300
36F04572A/P Payment Processing - Summary37KKRMKName - RemarkStringGeneric Edit300
37F04573A/P Payment Processing - Detail21KIRMKName - RemarkStringGeneric Edit300
38F09UI005Tax Offsets User Index32GLRMKName - RemarkStringGeneric Edit300
TOP05A: PeopleSoft HR & PR Foundation
39F08097HR Generic Table Ranges7H#RMKName - RemarkStringGeneric Edit300
TOP07: Payroll
40F06491Payroll/Accounts Payable Ledger Detail8J6RMKName - RemarkStringGeneric Edit300
41F07107Employee Wage Attachment Rules15JWRMKName - RemarkStringGeneric Edit300
42F07491Payroll - Accounts Payable Summary File8J6RMKName - RemarkStringGeneric Edit300
TOP08: Human Resources
43F08092Human Resources General Description-User Def Codes12JZRMKName - RemarkStringGeneric Edit300
TOP08P: Position Control
44F08111Position Budget Detail13HQRMKName - RemarkStringGeneric Edit300
45F08111PPurge - Position Budget Detail13HQRMKName - RemarkStringGeneric Edit300
TOP08W: Wage and Salary
46F082001Pay Grade/Salary Range Table8HSRMKName - RemarkStringGeneric Edit300
47F08201Salary Review Workfile46HRRMKName - RemarkStringGeneric Edit300
TOP09: General Accounting
48F0917Bank Statement Detail20GDRMKName - RemarkStringGeneric Edit300
49F09617Auto Bank Statement Detail23GMRMKName - RemarkStringGeneric Edit300
TOP12: Fixed Assets
50F1201Asset Master File51FARMKName - RemarkStringGeneric Edit300
51F1201PAsset Master Purge Table51FARMKName - RemarkStringGeneric Edit300
52F1201Z1Unedited Asset Master Transactions64FARMKName - RemarkStringGeneric Edit300
53F1204Location Tracking Table5FMRMKName - RemarkStringGeneric Edit300
54F1204PLocation Tracking Purge Table5FMRMKName - RemarkStringGeneric Edit300
55F12092Fixed Assets Supplemental Data Codes Type7F3RMKName - RemarkStringGeneric Edit300
TOP13: Plant/Equipment Management
56F1207Maintenance Schedule File9FWRMKName - RemarkStringGeneric Edit300
57F12071Equipment PM Schedule (Model)32FZRMKName - RemarkStringGeneric Edit300
58F1207PMaintenance Schedule Purge Table9FWRMKName - RemarkStringGeneric Edit300
59F1307Status History File14F1RMKName - RemarkStringGeneric Edit300
60F1307PStatus History Purge Table14F1RMKName - RemarkStringGeneric Edit300
TOP15: Real Estate Management
61F15012BTenant E.P. Class Master97NSRMKName - RemarkStringGeneric Edit300
62F15016Tenant Escalation Master35NURMKName - RemarkStringGeneric Edit300
63F15016BTenant Escalation Master36NURMKName - RemarkStringGeneric Edit300
64F1502Recurring Billings Master7NFRMKName - RemarkStringGeneric Edit300
65F1502BRecurring Billings Master7NFRMKName - RemarkStringGeneric Edit300
66F1502BDRecurring Billings Master - Alternate Description4NFRMKName - RemarkStringGeneric Edit300
67F1502WBEstimated EP Recurring Billings9N4RMKName - RemarkStringGeneric Edit300
68F15152Lease E.P. Caps21LCRMKName - RemarkStringGeneric Edit300
69F151521Lease E.P. Accounts Not Subject to Cap12LORMKName - RemarkStringGeneric Edit300
70F1530Expense Participation Class Master26NGRMKName - RemarkStringGeneric Edit300
71F15301E.P. Class Account Overrides24AORMKName - RemarkStringGeneric Edit300
72F1533BTenant Account Exclusions49NMRMKName - RemarkStringGeneric Edit300
TOP17C: Call Management
73F1731Equipment Master Location History11LQRMKName - RemarkStringGeneric Edit300
TOP40R: Demand Scheduling
74F471721EDI Demand Supplemental Data24EURMKName - RemarkStringGeneric Edit300
TOP41: Inventory Management
75F41092Item Supplemental Data Base User Defined Codes9T2RMKName - RemarkStringGeneric Edit300
76F4160Tag Inventory File20ITRMKName - RemarkStringGeneric Edit300
TOP43: Procurement
77F4301Purchase Order Header27PHRMKName - RemarkStringGeneric Edit300
78F4301ZPO Header Work File31PARMKName - RemarkStringGeneric Edit300
79F4301Z1Purchase Order Header Unedited Transaction Table40SYRMKName - RemarkStringGeneric Edit300
80F4314ZVoucher Match Selection File61PNRMKName - RemarkStringGeneric Edit300
81F4318Approval/Rejection Reasons7PYRMKName - RemarkStringGeneric Edit300
82F43UI50HPO Print Header Work File44PARMKName - RemarkStringGeneric Edit300
83F74U0142ACM - Application / Certificate Status History15DHRMKName - RemarkStringGeneric Edit300
TOP44H: Homebuilder Management
84F44H402Option Relationships12PKRMKName - RemarkStringGeneric Edit300
85F44H601Bid Header17BHRMKName - RemarkStringGeneric Edit300
86F44H711Lot Start Workfile44SWRMKName - RemarkStringGeneric Edit300
87F44H711ZHB Lot Start Unedited Transaction File57SZRMKName - RemarkStringGeneric Edit300
88F44H71W1Lot Start Generation Workfile44GWRMKName - RemarkStringGeneric Edit300
89F44H73W1Lot Start - P.O. / Committment Generation Work File72CGRMKName - RemarkStringGeneric Edit300
TOP47: Electronic Commerce
90F47016EDI Purchase Order Header - Outbound42SYRMKName - RemarkStringGeneric Edit300
91F47021EDI P.O. Acknowledgment Header - Inbound42SYRMKName - RemarkStringGeneric Edit300
92F47031EDI Shipping Notice Header - Inbound40SYRMKName - RemarkStringGeneric Edit300
93F47041EDI Invoice Header - Inbound51SYRMKName - RemarkStringGeneric Edit300
94F47042EDI Invoice Detail - Inbound89SZRMKName - RemarkStringGeneric Edit300
95F47057EDI Payment Order Remittance Advice - Outbound80D3RMKName - RemarkStringGeneric Edit300
96F47057WEDI Payment Order Remittance Advice - Work80D3RMKName - RemarkStringGeneric Edit300
97F47071EDI Receiving Advice Header - Inbound43SYRMKName - RemarkStringGeneric Edit300
98F47076EDI Receiving Advice Header - Outbound43SYRMKName - RemarkStringGeneric Edit300
99F47096EDI Request for Quote Header - Outbound42SYRMKName - RemarkStringGeneric Edit300
100F47101EDI Response to RFQ Header - Inbound42SYRMKName - RemarkStringGeneric Edit300
101F47114EDI Lockbox/Payment Detail - Payment18Z4RMKName - RemarkStringGeneric Edit300
102F47136EDI Purchase Order Change Header - Outbound42SYRMKName - RemarkStringGeneric Edit300
103F47141EDI P.O. Change Acknowledgment Header - Inbound43SYRMKName - RemarkStringGeneric Edit300
104F47156EDI Shipping Schedule Header - Outbound45SYRMKName - RemarkStringGeneric Edit300
TOP48: Work Order Processing
105F48092WO Supplemental DB User Defined7W8RMKName - RemarkStringGeneric Edit300
TOP48S: Service Billing
106F4822Invoice Summary Work File92W4RMKName - RemarkStringGeneric Edit300
107F4823Voucher Summary64W0RMKName - RemarkStringGeneric Edit300
TOP52: Contract Billing
108F5202Contract Billing Line Detail72G6RMKName - RemarkStringGeneric Edit300
TOP52G: Proj & Gov Contract Accounting
109F4822HInvoice Summary History92IHRMKName - RemarkStringGeneric Edit300
TOP53: Change Management
110F5301BChange Request Master Table5DIRMKName - RemarkStringGeneric Edit300
111F5301BZ1Change Request Master Table Workfile9DIRMKName - RemarkStringGeneric Edit300
TOP74: EMEA Localization
112F7430033A/R Document Line (Print Info) - COMM - 03B5PIRMKName - RemarkStringGeneric Edit300
TOP74P: Poland
113F74P03BWA/R Trial Balance - POL - 03B - 74P15P3RMKName - RemarkStringGeneric Edit300
114F74P04WA/P Trial Balance Work Table - POL - 04 - 74P15P2RMKName - RemarkStringGeneric Edit300
TOP74R: Russia
115F74R5110F1201 Tag File - RUS - 12 - 74R24TFRMKName - RemarkStringGeneric Edit300
TOP74U: United Kingdom Localizations
116F74U0118Payment Voucher Status History - 0414VHRMKName - RemarkStringGeneric Edit300
117F74U0205Payment Profile - 1532P8RMKName - RemarkStringGeneric Edit300
118F74U0405SPC Certificate Holding Table - UK - 4313CHRMKName - RemarkStringGeneric Edit300
119F74U0420SPC - Application Master - UK - 4374SERMKName - RemarkStringGeneric Edit300
120F74U0425SPC - Certificate Master - UK - 4376SFRMKName - RemarkStringGeneric Edit300
TOP75C: China
121F75C010WAP & AR XML Workfile - China -75C21AARMKName - RemarkStringGeneric Edit300
TOP75I: India
122F75I320YExcise - Payment Details37QBRMKName - RemarkStringGeneric Edit300
123F75I344YPrint ARE-1Bond Register-IND-0037CDRMKName - RemarkStringGeneric Edit300
124F75I346Excise - D3-Form Table29Q9RMKName - RemarkStringGeneric Edit300
125F75I701Bill of Entry - Header65QHRMKName - RemarkStringGeneric Edit300
TOP76A: Argentina
126F760473APCG Detail Information Tag Table - ARG - 04 - 76A12E5RMKName - RemarkStringGeneric Edit300
127F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A21DLRMKName - RemarkStringGeneric Edit300
128F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A21DLRMKName - RemarkStringGeneric Edit300
129F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A19IERMKName - RemarkStringGeneric Edit300
130F76A393Calculated costs detail - 76A21C3RMKName - RemarkStringGeneric Edit300
131F76A394Adjustments - 76A17C4RMKName - RemarkStringGeneric Edit300
132F76A8500Tag File F03B14 - ARG - 03B - 76A24TFRMKName - RemarkStringGeneric Edit300
133F76A8510Tag File F76A60 - ARG - 03B - 76A23TFRMKName - RemarkStringGeneric Edit300
134F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A28BERMKName - RemarkStringGeneric Edit300
135F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A21DLRMKName - RemarkStringGeneric Edit300
136F76AUI81Draft - Invoices Work File - ARG - 03B - 76A34WFRMKName - RemarkStringGeneric Edit300
137F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A43WFRMKName - RemarkStringGeneric Edit300
138F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A13WFRMKName - RemarkStringGeneric Edit300
TOP76B: Brazil
139F76B473TF04573 Brazilian Temp WH File - BR - 0432W3RMKName - RemarkStringGeneric Edit300
140F76B8602IN86-Work Table for Suppliers and Customers - 047PRRMKName - RemarkStringGeneric Edit300
TOP76C: Colombia
141F76C0003VAT Certificates Retention - COL - 76C8CRRMKName - RemarkStringGeneric Edit300
142F76C034AA/R Check Detail file As Of - COL - 03B74RZRMKName - RemarkStringGeneric Edit300
TOP76H: Chile
143F76H3B33Legal Document Tax (Print Info) - CHI - 03B - 76H5PIRMKName - RemarkStringGeneric Edit300
144F76H3B37A/R Document Line (Print Info) - CHI - 03B - 76H6PIRMKName - RemarkStringGeneric Edit300
145F76H3B40A/P Document Line (Print Info) - CHI - 046PIRMKName - RemarkStringGeneric Edit300
146F76H3B50Lot of Printing - Header - CHI - 03B - 76H8LPRMKName - RemarkStringGeneric Edit300
TOP76P: Peru
147F76P473TF04573 Tag File - PER - 04 - 76P12K3RMKName - RemarkStringGeneric Edit300
TOPF30L: DFM Line Design
148FF30L301DFM Customer Master5CMRMKName - RemarkStringGeneric Edit300
149FF30L401DFM Supplier Master4SMRMKName - RemarkStringGeneric Edit300
150FF30L601DFM Employee Master4EMRMKName - RemarkStringGeneric Edit300
TOPH90: EnterpriseOne TOOLS
151F0112Time Log Ledger File4PTRMKName - RemarkStringGeneric Edit300