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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

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

146 columns | Print definition?910 | 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
10F03B11Z1Batch Invoices72VJPTCPayment 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 Upload72VLPTCPayment 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
24F1511BLease Billings Master27NJPTCPayment Terms CodeStringGeneric Edit30
25F1511HTenant/Lease Billings Detail History27N#PTCPayment Terms CodeStringGeneric Edit30
26F1511HBLease Billings History27NCPTCPayment Terms CodeStringGeneric Edit30
27F1525A/R Fee Interest34N0PTCPayment Terms CodeStringGeneric Edit30
28F1525BFees and Interest31NMPTCPayment Terms CodeStringGeneric Edit30
TOP17: Customer Service Management
29F1720Contract Header31CHPTCPayment Terms CodeStringGeneric Edit30
30F1721Contract Detail95CDPTCPayment Terms CodeStringGeneric Edit30
TOP17C: Call Management
31F1755Case 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 Master40G4PTCPayment Terms CodeStringGeneric Edit30
TOP52G: Government Contracting
127F4822HInvoice Summary History16IHPTCPayment Terms CodeStringGeneric Edit30
128F52G01MProject and Government Contract Modifications45CMPTCPayment Terms CodeStringGeneric Edit30
TOP55: Reserved for Clients
129F74H1050Invoicing Workfile Header - New12IHPTCPayment Terms CodeStringGeneric Edit30
TOP70: Multi-National Products - obsolete-do not reuse
130F702033Sales Document Line Tag File - COMM - 4212D1PTCPayment Terms CodeStringGeneric Edit30
TOP74: EMEA Localization
131F7430030Legal Document Header (Print Info) - COMM - 03B6PIPTCPayment Terms CodeStringGeneric Edit30
132F74900Foreign Receivables and Payables - EMEA62RPPTCPayment Terms CodeStringGeneric Edit30
TOP74U: United Kingdom Localizations
133F74U0405SPC Certificate Holding Table - UK - 4314CHPTCPayment Terms CodeStringGeneric Edit30
134F74U0420SPC - Application Master - UK - 4335SEPTCPayment Terms CodeStringGeneric Edit30
135F74U0425SPC - Certificate Master - UK - 4337SFPTCPayment Terms CodeStringGeneric Edit30
TOP75I: India
136F75I10ATDS Rate Maintenance File10QAPTCPayment Terms CodeStringGeneric Edit30
137F75I15ATDS Document Company Maintenance File9QCPTCPayment Terms CodeStringGeneric Edit30
TOP76A: Argentina
138F76A21Credit Invoice Header - F76A21 - ARG - 3B - 76A17IHPTCPayment Terms CodeStringGeneric Edit30
139F76A21PCredit Invoice Header Purge - ARG - 03B - 76A17IHPTCPayment Terms CodeStringGeneric Edit30
140F76AUI51Credit Invoice - Create PGC Error and Wrn - ARG - 04 - 76A8IKPTCPayment Terms CodeStringGeneric Edit30
TOP76B: Brazil - Reporting System Only
141F76B0401Tax Code - 0418CTPTCPayment Terms CodeStringGeneric Edit30
142F76B406Taxes Setup by City Code - BR - 043TSPTCPayment Terms CodeStringGeneric Edit30
143F76B473TF04573 Brazilian Temp WH File - BR - 0426W3PTCPayment Terms CodeStringGeneric Edit30
TOP76C: Colombia
144F76C031AA/R Customer ledger As Of - F76C031A - COL - 0454RPPTCPayment Terms CodeStringGeneric Edit30
TOP76H: Chile
145F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H4PIPTCPayment Terms CodeStringGeneric Edit30
TOP89: Conversion Programs
146F43199ATemp F43199 for ERP 9.0 Upgrade87OLPTCPayment Terms CodeStringGeneric Edit30