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
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
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 tables812 | 74

74: EMEA Localization
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F0018TTD461Intrastat RevisionConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
2812F00900IR131Year-End VAT Revision File - ItalyTransaction Files04: Accounts PayableAS400 Coexistence Tables
3812F0091IF201A/B Vendor Information for Year-end IVA tape - ItalyTransaction Files04: Accounts PayableAS400 Coexistence Tables
4812F00918BB21Year-end IVA Tape Creation - ItalyWork Files04: Accounts PayableAS400 Coexistence Tables
5812F7400001NN101Legal Document Next Numbers - COMM - 00Files74: EMEA Localization
6812F7400002LD121Legal Document Types - COMM - 00Files74: EMEA Localization
7812F7400003RL91Legal Document Types / Document Types Relationship - COMM-00Files74: EMEA Localization
8812F7400004IP71Legal Document Issue Places - COMM - 00Files74: EMEA Localization
9812F7400006PD163Processed Documents in Legal Applications - COMM - 00Files74: EMEA Localization
10812F7400007BD101Business Unit / Doc Type Next Number - COMM - 00Files74: EMEA Localization
11812F7400010LC72Company Aditional Information - COMM - 00Files74: EMEA Localization
12812F740018AI131Intrastat Revision Additional - CZE - 74Files74: EMEA Localization
13812F740018TTF151Tag File F0018 - EMEA - 74Files74: EMEA Localization
14812F7400B1QA22Belgium VAT Work FileWork Files04: Accounts PayableAS400 Coexistence Tables
15812F7400C2DP42Obsolete - R7400C2 Work FileTransaction Files04: Accounts PayableAS400 Coexistence Tables
16812F7400C2AFC31Tag file for R7400C2-French VAT on A/RTransaction Files04: Accounts PayableAS400 Coexistence Tables
17812F7400C3TG31R7400C3 Work FileTransaction Files04: Accounts PayableAS400 Coexistence Tables
18812F74030BA121Bank ID - ItalyTransaction Files04: Accounts PayableAS400 Coexistence Tables
19812F74030GAY171Germany-Bank Transit Number Master File Addtl InformationSecondary Master Files04: Accounts PayableAS400 Coexistence Tables
20812F74030HNL392Dutch-Payments Bank InformationSecondary Master Files04: Accounts PayableAS400 Coexistence Tables
21812F74030HAST41Dutch-Next Batch Number and Sequence NumberSecondary Master Files04: Accounts PayableAS400 Coexistence Tables
22812F7404572KL141Detail Payment Instructions for German PaymentsSecondary Master Files04: Accounts PayableAS400 Coexistence Tables
23812F7404573KI201Detail Payment Instructions EXT. for German PaymentsSecondary Master Files04: Accounts PayableAS400 Coexistence Tables
24812F74091HA41Class/Register Setup - ItalyConstants Files04: Accounts PayableAS400 Coexistence Tables
25812F74092HB61IVA Balances History - ItalyHistory Files04: Accounts PayableAS400 Coexistence Tables
26812F74093HC681Workfile for Printing IVA Summary - ItalyWork Files04: Accounts PayableAS400 Coexistence Tables
27812F740931HD71IVA Summary Report Header File - Work File-ItalyConstants Files04: Accounts PayableAS400 Coexistence Tables
28812F741001TAT71Address Book Tag File - COMM - 01Files74: EMEA Localization
29812F7420011SL72Sales Order / Legal Document Relationship - COMM - 42Files74: EMEA Localization
30812F7420015SR62Invoices Related to Sales Order - COMM - 42Files74: EMEA Localization
31812F7420018ST151Taxes by Sales Order Line - COMM - 42Files74: EMEA Localization
32812F7420033PI231Sales Document Line (Print Info) - COMM - 42Files74: EMEA Localization
33812F7420034PI111Price Adjustment (Print Info) - COMM - 42Files74: EMEA Localization
34812F7430010LD232Legal Document Header - COMM - 03BFiles74: EMEA Localization
35812F7430015DR62Invoices Related to AR DN/CN - COMM - 03BFiles74: EMEA Localization
36812F7430018TI151Taxes by A/R Invoice Line - COMM - 03BFiles74: EMEA Localization
37812F7430021DT131Print Templates Definition for Legal Documents - COMM - 03BFiles74: EMEA Localization
38812F7430022DL81Print Line Type Definition for Legal Documents - COMM - 03BFiles74: EMEA Localization
39812F7430023LD81Legal Documents Types / Print Template Relationship-COMM-03BFiles74: EMEA Localization
40812F7430024DU111Legal Documents Print UBEs and Versions - COMM -03BFiles74: EMEA Localization
41812F7430030PI341Legal Document Header (Print Info) - COMM - 03BFiles74: EMEA Localization
42812F7430031PI201Legal Document Address (Print Info) - COMM - 03BFiles74: EMEA Localization
43812F7430032PI111Legal Document Detail (Print Info) - COMM - 03BFiles74: EMEA Localization
44812F7430033PI141A/R Document Line (Print Info) - COMM - 03BFiles74: EMEA Localization
45812F7430034PI81Legal Document Attachment (Print Info) - COMM - 03BFiles74: EMEA Localization
46812F7430035PI81Taxes by Legal Document Line - COMM - 03BFiles74: EMEA Localization
47812F7430050BH111Print Batch Header - COMM - 03BFiles74: EMEA Localization
48812F7430051BD81Print Batch Detail - COMM - 03BFiles74: EMEA Localization
49812F74301BU21Bank Table Upload - ItalyTransaction Files04: Accounts PayableAS400 Coexistence Tables
50812F74405RC111Withholding Tax Codes-ItalyTransaction Files04: Accounts PayableAS400 Coexistence Tables
51812F744101IN92Intrastat Supplier/Item Cross Reference TableConstants Files00: Foundation EnvironmentAS400 Coexistence Tables
52812F744102IB162Intrastat Commodity Code Additional InformationRegular Work Files00: Foundation EnvironmentAS400 Coexistence Tables
53812F744102TCC103Commodity Code Additional Inf Tag File - CZE - 74Files74: EMEA Localization
54812F74411RS352Withholding Tax Detail File-ItalyTransaction Files04: Accounts PayableAS400 Coexistence Tables
55812F74412RP263Customer / Supplier Balance Workfile (A/R and A/P)Master Files04: Accounts PayableNo
56812F74413VC251VAT Ceiling Limit-ItalyBalance Files04: Accounts PayableNo
57812F7464108LO112Lot Additional Information - COMM - 41Files74: EMEA Localization
58812F74900RP741Foreign Receivables and Payables - EMEARegular Work Files04: Accounts PayableAS400 Coexistence Tables
59812F749101RD91Report Definition - EMEA - 74Files74: EMEA Localization
60812F749102SD161Section Definition - EMEA - 74Files74: EMEA Localization
61812F749103CD222Section Column Definition - EMEA - 74Files74: EMEA Localization
62812F749104RD331Rows Definition - EMEA - 74Files74: EMEA Localization
63812F749105ED172Cells Definition - EMEA - 74Files74: EMEA Localization
64812F749110AG122Account Group Definition - EMEA - 74Files74: EMEA Localization
65812F749111AG111Account Group Detail- EMEA - 74Files74: EMEA Localization
66812F74S55Q5181Expenses and Exchange Rate for Payments - SpainMaster Files04: Accounts PayableAS400 Coexistence Tables
67812F74SCSBCS182C.S.B. Bank File - SpainMaster Files04: Accounts PayableAS400 Coexistence Tables
68812F74UI90RD361WF - Report Detail - EMEA - 74Files74: EMEA Localization
69812F74UI91AD201WF - Account Detail - EMEA - 74Files74: EMEA Localization
70812F74UI92CV291WF - Account Cell Value - EMEA - 74Files74: EMEA Localization
71812F74UI93CD72WF - Cost Center Detail - EMEA - 74Files74: EMEA Localization
72812F74UI94CC51WF - Cost Center Detail by Company - EMEA - 74Files74: EMEA Localization
73812F74UI95RH84WF - Report History - EMEA - 74Files74: EMEA Localization