JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

143 columns | Print definition?812 | PTC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0014Payment Terms1PNPTCPayment Terms CodeStringGeneric Edit30
2F00141Advanced Payment Terms1L3PTCPayment Terms CodeStringGeneric Edit30
3F00144Installment Payment Terms1L6PTCPayment Terms CodeStringGeneric Edit30
4F004201Prepayment Transaction Table48PTPTCPayment Terms CodeStringGeneric Edit30
TOP03: Accounts Receivable
5F0311Accounts Receivable Ledger56RPPTCPayment Terms CodeStringGeneric Edit30
TOP03B: Enhanced Accounts Receivable
6F03B11Customer Ledger55RPPTCPayment Terms CodeStringGeneric Edit30
7F03B112Invoice Revisions47RWPTCPayment Terms CodeStringGeneric Edit30
8F03B112PInvoice Revisions Purge File47RWPTCPayment Terms CodeStringGeneric Edit30
9F03B11PCustomer Ledger Purge File55RPPTCPayment Terms CodeStringGeneric Edit30
10F03B11Z1Invoice Transactions - Batch File72VJPTCPayment Terms CodeStringGeneric Edit30
11F03B11Z2F03B11 Interoperability Table68SYPTCPayment Terms CodeStringGeneric Edit30
12F03B20A/R Notification History38ZRPTCPayment Terms CodeStringGeneric Edit30
13F03B21A/R Notification History Detail22ZSPTCPayment Terms CodeStringGeneric Edit30
14F03B22A/R Fee Journal History17RSPTCPayment Terms CodeStringGeneric Edit30
15F03B575Auto Debit Invoice Select and Build64RDPTCPayment Terms CodeStringGeneric Edit30
TOP04: Accounts Payable
16F0411Accounts Payable Ledger54RPPTCPayment Terms CodeStringGeneric Edit30
17F0411AWF - As Of - Accounts Payable Ledger54RPPTCPayment Terms CodeStringGeneric Edit30
18F0411PPurge - Accounts Payable Ledger54RPPTCPayment Terms CodeStringGeneric Edit30
19F0411Z1Voucher Transactions - Batch File72VLPTCPayment Terms CodeStringGeneric Edit30
20F0411Z3F0411 Interoperability Table77SZPTCPayment Terms CodeStringGeneric Edit30
TOP07: Payroll
21F06492Payroll - Accounts Payable Control7JCPTCPayment Terms CodeStringGeneric Edit30
22F07492Payroll - Accounts Payable Control File7JCPTCPayment Terms CodeStringGeneric Edit30
TOP15: Property Management
23F1511Tenant/Lease Billings Detail27NJPTCPayment Terms CodeStringGeneric Edit30
24F1511BTenant/Lease Billings Detail Master27NJPTCPayment Terms CodeStringGeneric Edit30
25F1511HTenant/Lease Billings Detail History27N#PTCPayment Terms CodeStringGeneric Edit30
26F1511HBTenant/Lease Billings Detail History27NCPTCPayment Terms CodeStringGeneric Edit30
27F1525A/R Fee Interest34N0PTCPayment Terms CodeStringGeneric Edit30
28F1525BA/R Fee and Interest31NMPTCPayment Terms CodeStringGeneric Edit30
TOP17: Customer Service Management
29F1720Contract Header31CHPTCPayment Terms CodeStringGeneric Edit30
30F1721Contract Detail95CDPTCPayment Terms CodeStringGeneric Edit30
TOP17C: Call Management
31F1755Customer Call Master204ZAPTCPayment Terms CodeStringGeneric Edit30
32F1760Time Entry83ZBPTCPayment Terms CodeStringGeneric Edit30
TOP40: Inventory/OP Base
33F4001ZBatch Receiver File - Order Headings53SYPTCPayment Terms CodeStringGeneric Edit30
34F4011ZBatch Receiver File - Order Details103SZPTCPayment Terms CodeStringGeneric Edit30
35F40301Preference Profile - Payment Terms12PTPTCPayment Terms CodeStringGeneric Edit30
36F40301RPreference Resolution Ledger - Payment Terms14PTPTCPayment Terms CodeStringGeneric Edit30
37F40338Preference Profile - Payment Terms (Branch)14PTPTCPayment Terms CodeStringGeneric Edit30
38F40338RPreference Resolution Ledger - Payment Terms (Branch)16PTPTCPayment Terms CodeStringGeneric Edit30
39F4201Z1Sales Order Header Unedited Transaction File42SYPTCPayment Terms CodeStringGeneric Edit30
40F4211Z1Sales Order Detail Unedited Transaction File100SZPTCPayment Terms CodeStringGeneric Edit30
41F49211Sales Order Detail File - Tag File55UDPTCPayment Terms CodeStringGeneric Edit30
42F49211Z1Sales Order Detail Tag Unedited Transaction File68S1PTCPayment Terms CodeStringGeneric Edit30
43F49219Sales Order Detail - Tag History File55UDPTCPayment Terms CodeStringGeneric Edit30
TOP42: Sales Management
44F4201Sales Order Header File29SHPTCPayment Terms CodeStringGeneric Edit30
45F42019Sales Order Header History File29SHPTCPayment Terms CodeStringGeneric Edit30
46F4211Sales Order Detail File87SDPTCPayment Terms CodeStringGeneric Edit30
47F42119Sales Order History File87SDPTCPayment Terms CodeStringGeneric Edit30
48F42199S.O. Detail Ledger File87SLPTCPayment Terms CodeStringGeneric Edit30
49F42565Invoice Print File65IWPTCPayment Terms CodeStringGeneric Edit30
50F42UI01SO Header Cache File (MBF)34ZHPTCPayment Terms CodeStringGeneric Edit30
51F42UI12Sales Order Detail Cache 2 (MBF)26ZDPTCPayment Terms CodeStringGeneric Edit30
52F42UI520Pick Slips Header File31S8PTCPayment Terms CodeStringGeneric Edit30
53F42UI521Pick Slips Detail File80S9PTCPayment Terms CodeStringGeneric Edit30
TOP42B: Sales Order Entry
54F42420Audit Log Transaction61ALPTCPayment Terms CodeStringGeneric Edit30
55F49299S.O. Detail Tag Ledger File55UDPTCPayment Terms CodeStringGeneric Edit30
TOP43: Procurement
56F4301Purchase Order Header32PHPTCPayment Terms CodeStringGeneric Edit30
57F4301ZPO Header Work File36PAPTCPayment Terms CodeStringGeneric Edit30
58F4301Z1Purchase Order Header Unedited Transaction Table45SYPTCPayment Terms CodeStringGeneric Edit30
59F43080Approvals Fields Constants9PDPTCPayment Terms CodeStringGeneric Edit30
60F4311Purchase Order Detail File87PDPTCPayment Terms CodeStringGeneric Edit30
61F4311ZPurchase Order Generator File91PWPTCPayment Terms CodeStringGeneric Edit30
62F4311Z1Purchase Order Detail Unedited Transaction Table100SZPTCPayment Terms CodeStringGeneric Edit30
63F43121Purchase Order Receiver File33PRPTCPayment Terms CodeStringGeneric Edit30
64F43121ZReceiver workfile76PWPTCPayment Terms CodeStringGeneric Edit30
65F43121Z1Receipts Unedited Transaction Table50SZPTCPayment Terms CodeStringGeneric Edit30
66F4314ZVoucher Match Selection File132PNPTCPayment Terms CodeStringGeneric Edit30
67F43199P.O. Detail Ledger File - Flexible Version87OLPTCPayment Terms CodeStringGeneric Edit30
68F43UI50DPO Print Detail Work File55PWPTCPayment Terms CodeStringGeneric Edit30
69F43UI50HPO Print Header Work File35PAPTCPayment Terms CodeStringGeneric Edit30
TOP43C: Contracts
70F43C01Contract Header10CHPTCPayment Terms CodeStringGeneric Edit30
71F43C10Contract Block17CBPTCPayment Terms CodeStringGeneric Edit30
72F43C11Contract Detail29CDPTCPayment Terms CodeStringGeneric Edit30
73F43C20Contract Payee6CPPTCPayment Terms CodeStringGeneric Edit30
TOP43Q: Strategic Sourcing
74F43Q10Event Header13EHPTCPayment Terms CodeStringGeneric Edit30
75F43Q50Analyze Event Header25AVPTCPayment Terms CodeStringGeneric Edit30
TOP44H: Homebuilder Management
76F44H601Bid Header35BHPTCPayment Terms CodeStringGeneric Edit30
77F44H611Bid Details52BDPTCPayment Terms CodeStringGeneric Edit30
78F44H611WBid Details Work File56BWPTCPayment Terms CodeStringGeneric Edit30
79F44H711Lot Start Workfile59SWPTCPayment Terms CodeStringGeneric Edit30
80F44H711ZHB Lot Start Unedited Transaction File72SZPTCPayment Terms CodeStringGeneric Edit30
81F44H71W1Lot Start Generation Workfile59GWPTCPayment Terms CodeStringGeneric Edit30
82F44H73W1Lot Start - P.O. / Committment Generation Work File32CGPTCPayment Terms CodeStringGeneric Edit30
TOP45: Advanced Pricing
83F45520Price List Header12PHPTCPayment Terms CodeStringGeneric Edit30
TOP47: Electronic Commerce
84F47011EDI Purchase Order Header - Inbound48SYPTCPayment Terms CodeStringGeneric Edit30
85F47012EDI Purchase Order Detail - Inbound104SZPTCPayment Terms CodeStringGeneric Edit30
86F47016EDI Purchase Order Header - Outbound47SYPTCPayment Terms CodeStringGeneric Edit30
87F47017EDI Purchase Order Detail - Outbound101SZPTCPayment Terms CodeStringGeneric Edit30
88F47021EDI P.O. Acknowledgment Header - Inbound47SYPTCPayment Terms CodeStringGeneric Edit30
89F47022EDI P.O. Acknowledgment Detail - Inbound101SZPTCPayment Terms CodeStringGeneric Edit30
90F47026EDI P.O. Acknowledgment Header - Outbound44SYPTCPayment Terms CodeStringGeneric Edit30
91F47027EDI P.O. Acknowledgment Detail - Outbound104SZPTCPayment Terms CodeStringGeneric Edit30
92F47031EDI Shipping Notice Header - Inbound42SYPTCPayment Terms CodeStringGeneric Edit30
93F47032EDI Shipping Notice Detail - Inbound72SZPTCPayment Terms CodeStringGeneric Edit30
94F47037EDI Shipping Notice Detail - Outbound99SZPTCPayment Terms CodeStringGeneric Edit30
95F470371EDI Shipping Notice Detail - Outbound110SZPTCPayment Terms CodeStringGeneric Edit30
96F47041EDI Invoice Header - Inbound37SYPTCPayment Terms CodeStringGeneric Edit30
97F47042EDI Invoice Detail - Inbound83SZPTCPayment Terms CodeStringGeneric Edit30
98F47046EDI Invoice Header (Sales) - Outbound44SYPTCPayment Terms CodeStringGeneric Edit30
99F47047EDI Invoice Detail (Sales) - Outbound104SZPTCPayment Terms CodeStringGeneric Edit30
100F47057EDI Payment Order Remittance Advice - Outbound83D3PTCPayment Terms CodeStringGeneric Edit30
101F47057WEDI Payment Order Remittance Advice - Work83D3PTCPayment Terms CodeStringGeneric Edit30
102F47071EDI Receiving Advice Header - Inbound48SYPTCPayment Terms CodeStringGeneric Edit30
103F47072EDI Receiving Advice Detail - Inbound102SZPTCPayment Terms CodeStringGeneric Edit30
104F47076EDI Receiving Advice Header - Outbound48SYPTCPayment Terms CodeStringGeneric Edit30
105F47077EDI Receiving Advice Detail - Outbound102SZPTCPayment Terms CodeStringGeneric Edit30
106F47091EDI Request for Quote Header - Inbound48SYPTCPayment Terms CodeStringGeneric Edit30
107F47092EDI Request for Quote Detail - Inbound104SZPTCPayment Terms CodeStringGeneric Edit30
108F47096EDI Request for Quote Header - Outbound47SYPTCPayment Terms CodeStringGeneric Edit30
109F47097EDI Request for Quote Detail - Outbound101SZPTCPayment Terms CodeStringGeneric Edit30
110F47101EDI Response to RFQ Header - Inbound47SYPTCPayment Terms CodeStringGeneric Edit30
111F47102EDI Response to RFQ Detail - Inbound101SZPTCPayment Terms CodeStringGeneric Edit30
112F47106EDI Response to RFQ Header - Outbound44SYPTCPayment Terms CodeStringGeneric Edit30
113F47107EDI Response to RFQ Detail - Outbound104SZPTCPayment Terms CodeStringGeneric Edit30
114F47131EDI Purchase Order Change Header - Inbound45SYPTCPayment Terms CodeStringGeneric Edit30
115F47132EDI Purchase Order Change Detail - Inbound105SZPTCPayment Terms CodeStringGeneric Edit30
116F47136EDI Purchase Order Change Header - Outbound47SYPTCPayment Terms CodeStringGeneric Edit30
117F47137EDI Purchase Order Change Detail - Outbound102SZPTCPayment Terms CodeStringGeneric Edit30
118F47141EDI P.O. Change Acknowledgment Header - Inbound48SYPTCPayment Terms CodeStringGeneric Edit30
119F47142EDI P.O. Change Acknowledgment Detail - Inbound103SZPTCPayment Terms CodeStringGeneric Edit30
120F47146EDI P.O. Change Acknowledgment Header - Outbound45SYPTCPayment Terms CodeStringGeneric Edit30
121F47147EDI P.O. Change Acknowledgment Detail - Outbound106SZPTCPayment Terms CodeStringGeneric Edit30
122F47156EDI Shipping Schedule Header - Outbound50SYPTCPayment Terms CodeStringGeneric Edit30
123F47157EDI Shipping Schedule Detail - Outbound108SZPTCPayment Terms CodeStringGeneric Edit30
TOP48S: Service Billing
124F4822Invoice Summary Work File16W4PTCPayment Terms CodeStringGeneric Edit30
125F4823Voucher Summary14W0PTCPayment Terms CodeStringGeneric Edit30
TOP52: Contract Billing
126F5201Contract Master File40G4PTCPayment Terms CodeStringGeneric Edit30
TOP55: Reserved for Clients
127F55IF311As Of126RPPTCPayment Terms CodeStringGeneric Edit30
128F55IF421Sales Order per BO93SDPTCPayment Terms CodeStringGeneric Edit30
129F55IF425Sales Order per BO - 200593SDPTCPayment Terms CodeStringGeneric Edit30
130F55W0100Correction Invoice Print - WF188SDPTCPayment Terms CodeStringGeneric Edit30
131F74H1050Invoicing Workfile Header - New12IHPTCPayment Terms CodeStringGeneric Edit30
132F59H0210Call Priority Setup3CPPTCPayment Terms CodeStringGeneric Edit30
133F59H0220CRM Case Tag File - Proposals23CCPTCPayment Terms CodeStringGeneric Edit30
TOP74: EMEA Localization
134F7430030Legal Document Header (Print Info) - COMM - 03B6PIPTCPayment Terms CodeStringGeneric Edit30
135F74900Foreign Receivables and Payables - EMEA62RPPTCPayment Terms CodeStringGeneric Edit30
TOP76A: Argentina
136F76A21Credit Invoice Header - F76A21 - ARG - 3B - 76A17IHPTCPayment Terms CodeStringGeneric Edit30
137F76A21PCredit Invoice Header Purge - ARG - 03B - 76A17IHPTCPayment Terms CodeStringGeneric Edit30
138F76AUI51Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A8IKPTCPayment Terms CodeStringGeneric Edit30
TOP76B: Brazil - Reporting System Only
139F76B0401Tax Code - 0418CTPTCPayment Terms CodeStringGeneric Edit30
140F76B473TF04573 Brazilian Temp WH File - BR - 0426W3PTCPayment Terms CodeStringGeneric Edit30
TOP76C: Colombia
141F76C031AA/R Customer ledger As Of - F76C031A - COL - 0454RPPTCPayment Terms CodeStringGeneric Edit30
TOP76H: Chile
142F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H4PIPTCPayment Terms CodeStringGeneric Edit30
TOP89: Conversion Programs
143F43199ATemp F43199 for ERP 9.0 Upgrade87OLPTCPayment Terms CodeStringGeneric Edit30