JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

136 columns | Print definition?812 | 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
8F01092Suplemental Data Base - Code9A2RMKName - RemarkStringGeneric Edit300
9F0150Address Organization Structure Master File - OSTP - PA8 - AN87MARMKName - 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
17F03B11Z1Invoice Transactions - Batch File105VJRMKName - RemarkStringGeneric Edit300
18F03B11Z2F03B11 Interoperability Table102SYRMKName - RemarkStringGeneric Edit300
19F03B13Z1Electronic Receipts Input31RURMKName - RemarkStringGeneric Edit300
20F03B14A/R Check Detail File77RZRMKName - 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 File89VLRMKName - 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 - Summary File37KKRMKName - RemarkStringGeneric Edit300
37F04573A/P Payment Processing - Detail File21KIRMKName - RemarkStringGeneric Edit300
38F09UI005Tax Offsets User Index32GLRMKName - RemarkStringGeneric Edit300
TOP05A: OW 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: Property Management
61F15016Tenant Escalation Master35NURMKName - RemarkStringGeneric Edit300
62F15016BTenant Escalation Master36NURMKName - RemarkStringGeneric Edit300
63F1502Recurring Billings Master7NFRMKName - RemarkStringGeneric Edit300
64F1502BRecurring Billings Master7NFRMKName - RemarkStringGeneric Edit300
65F1502BDRecurring Billings Master - Alternate Description4NFRMKName - RemarkStringGeneric Edit300
66F1502WBEstimated EP Recurring Billing Work File (OneWorld)9N4RMKName - RemarkStringGeneric Edit300
TOP17C: Call Management
67F1731Installed Base Location History11LQRMKName - RemarkStringGeneric Edit300
TOP40R: Demand Scheduling
68F471721EDI Demand Supplemental Data24EURMKName - RemarkStringGeneric Edit300
TOP41: Inventory Management
69F41092Item Supplemental Data Base User Defined Codes9T2RMKName - RemarkStringGeneric Edit300
70F4160Tag Inventory File20ITRMKName - RemarkStringGeneric Edit300
TOP43: Procurement
71F4301Purchase Order Header27PHRMKName - RemarkStringGeneric Edit300
72F4301ZPO Header Work File31PARMKName - RemarkStringGeneric Edit300
73F4301Z1Purchase Order Header Unedited Transaction Table40SYRMKName - RemarkStringGeneric Edit300
74F4314ZVoucher Match Selection File61PNRMKName - RemarkStringGeneric Edit300
75F4318Approval/Rejection Reasons7PYRMKName - RemarkStringGeneric Edit300
76F43UI50HPO Print Header Work File44PARMKName - RemarkStringGeneric Edit300
TOP44H: Homebuilder Management
77F44H402Option Relationships12PKRMKName - RemarkStringGeneric Edit300
78F44H601Bid Header17BHRMKName - RemarkStringGeneric Edit300
79F44H711Lot Start Workfile44SWRMKName - RemarkStringGeneric Edit300
80F44H711ZHB Lot Start Unedited Transaction File57SZRMKName - RemarkStringGeneric Edit300
81F44H71W1Lot Start Generation Workfile44GWRMKName - RemarkStringGeneric Edit300
82F44H73W1Lot Start - P.O. / Committment Generation Work File72CGRMKName - RemarkStringGeneric Edit300
TOP47: Electronic Commerce
83F47016EDI Purchase Order Header - Outbound42SYRMKName - RemarkStringGeneric Edit300
84F47021EDI P.O. Acknowledgment Header - Inbound42SYRMKName - RemarkStringGeneric Edit300
85F47031EDI Shipping Notice Header - Inbound40SYRMKName - RemarkStringGeneric Edit300
86F47041EDI Invoice Header - Inbound51SYRMKName - RemarkStringGeneric Edit300
87F47042EDI Invoice Detail - Inbound89SZRMKName - RemarkStringGeneric Edit300
88F47057EDI Payment Order Remittance Advice - Outbound80D3RMKName - RemarkStringGeneric Edit300
89F47057WEDI Payment Order Remittance Advice - Work80D3RMKName - RemarkStringGeneric Edit300
90F47071EDI Receiving Advice Header - Inbound43SYRMKName - RemarkStringGeneric Edit300
91F47076EDI Receiving Advice Header - Outbound43SYRMKName - RemarkStringGeneric Edit300
92F47096EDI Request for Quote Header - Outbound42SYRMKName - RemarkStringGeneric Edit300
93F47101EDI Response to RFQ Header - Inbound42SYRMKName - RemarkStringGeneric Edit300
94F47114EDI Lockbox/Payment Detail - Payment18Z4RMKName - RemarkStringGeneric Edit300
95F47136EDI Purchase Order Change Header - Outbound42SYRMKName - RemarkStringGeneric Edit300
96F47141EDI P.O. Change Acknowledgment Header - Inbound43SYRMKName - RemarkStringGeneric Edit300
97F47156EDI Shipping Schedule Header - Outbound45SYRMKName - RemarkStringGeneric Edit300
TOP48: Work Order Processing
98F48092WO Supplemental DB User Defined7W8RMKName - RemarkStringGeneric Edit300
TOP48S: Service Billing
99F4822Invoice Summary Work File92W4RMKName - RemarkStringGeneric Edit300
100F4823Voucher Summary64W0RMKName - RemarkStringGeneric Edit300
TOP52: Contract Billing
101F5202Contract Billing Line Detail72G6RMKName - RemarkStringGeneric Edit300
TOP53: Change Management
102F5301BChange Request Master Table5DIRMKName - RemarkStringGeneric Edit300
103F5301BZ1Change Request Master Table Workfile9DIRMKName - RemarkStringGeneric Edit300
TOP55: Reserved for Clients
104F74U0142ACM - Application / Certificate Status History15DHRMKName - RemarkStringGeneric Edit300
TOP74: EMEA Localization
105F7430033A/R Document Line (Print Info) - COMM - 03B5PIRMKName - RemarkStringGeneric Edit300
TOP74P: Poland
106F74P03BWA/R Trial Balance - POL - 03B - 74P15P3RMKName - RemarkStringGeneric Edit300
107F74P04WA/P Trial Balance Work Table - POL - 04 - 74P15P2RMKName - RemarkStringGeneric Edit300
TOP74R: CIS
108F74R5110F1201 Tag File - RUS - 12 - 74R24TFRMKName - RemarkStringGeneric Edit300
TOP74U: United Kingdom Localizations
109F74U0118Payment Voucher Status History14VHRMKName - RemarkStringGeneric Edit300
110F74U0205Payment Profile - 1532P8RMKName - RemarkStringGeneric Edit300
TOP76A: Argentina
111F760473APCG Detail Information Tag File - ARG - 0412E5RMKName - RemarkStringGeneric Edit300
112F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A21DLRMKName - RemarkStringGeneric Edit300
113F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A21DLRMKName - RemarkStringGeneric Edit300
114F76A24Credit Invoice Information - Accounts Payable - ARG - - 76A19IERMKName - RemarkStringGeneric Edit300
115F76A393Calculated costs detail - 76A21C3RMKName - RemarkStringGeneric Edit300
116F76A394Adjustments - 76A17C4RMKName - RemarkStringGeneric Edit300
117F76A8500Tag File F03B14 - ARG - 03B - 76A24TFRMKName - RemarkStringGeneric Edit300
118F76A8510Tag File F76A60 - ARG - 03B - 76A23TFRMKName - RemarkStringGeneric Edit300
119F76A85Z1Tag File F76A60 Batch Entry - ARG - 03B - 76A28BERMKName - RemarkStringGeneric Edit300
120F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0021DLRMKName - RemarkStringGeneric Edit300
121F76AUI81Draft - Invoices Work File - ARG - 03B - 76A34WFRMKName - RemarkStringGeneric Edit300
122F76AUI83Draft - Application Drafts - Invoices Work File - ARG - 76A43WFRMKName - RemarkStringGeneric Edit300
123F76AUI89Work File to Generate ND/NC Gain/Loss - ARG - 03B - 76A13WFRMKName - RemarkStringGeneric Edit300
TOP76B: Brazil - Reporting System Only
124F76B473TF04573 Brazilian Temp WH File - BR - 0432W3RMKName - RemarkStringGeneric Edit300
125F76B8602IN86-Work Table for Suppliers and Customers - 047PRRMKName - RemarkStringGeneric Edit300
TOP76C: Colombia
126F76C0003VAT Certificates Retention - COL - 76C8CRRMKName - RemarkStringGeneric Edit300
127F76C034AA/R Check Detail file As Of - COL - 76C74RZRMKName - RemarkStringGeneric Edit300
TOP76H: Chile
128F76H3B33Legal Document Tax (Print Info) - CHI - 03B - 76H5PIRMKName - RemarkStringGeneric Edit300
129F76H3B37A/R Document Line (Print Info) - CHI - 03B - 76H6PIRMKName - RemarkStringGeneric Edit300
130F76H3B40A/P Document Line (Print Info) - CHI - 046PIRMKName - RemarkStringGeneric Edit300
131F76H3B50Lot of Printing - Header - CHI - 03B - 76H8LPRMKName - RemarkStringGeneric Edit300
TOP76P: Peru
132F76P473TF04573 Tag File - PER - 04 - 76P12K3RMKName - RemarkStringGeneric Edit300
TOPF30L: DFM Line Design
133FF30L301DFM Customer Master5CMRMKName - RemarkStringGeneric Edit300
134FF30L401DFM Supplier Master4SMRMKName - RemarkStringGeneric Edit300
135FF30L601DFM Employee Master4EMRMKName - RemarkStringGeneric Edit300
TOPH90: ONEWORLD TOOLS
136F0112Time Log Ledger File4PTRMKName - RemarkStringGeneric Edit300