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

87 tables920 | 74

74: EMEA Localization
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0018TTD461Intrastat RevisionConstants Files74: EMEA LocalizationBusiness Data
2920F00900IR131Year-End VAT Revision - ItalyTransaction Files09: General AccountingBusiness Data
3920F0091IF201A/B Vendor Information for Year-end IVA tape - ItalyTransaction Files04: Accounts PayableBusiness Data
4920F00918BB21Year-end IVA Tape Creation - ItalyWork Files04: Accounts PayableBusiness Data
5920F7400001NN101Legal Document Next Numbers - COMM - 00Files74: EMEA Localization
6920F7400002LD121Legal Document Types - COMM - 00Files74: EMEA Localization
7920F7400003RL91Legal Document Types / Document Types Relationship - COMM-00Files74: EMEA Localization
8920F7400004IP71Legal Document Issue Places - COMM - 00Files74: EMEA Localization
9920F7400006PD163Processed Documents in Legal Applications - COMM - 00Files74: EMEA Localization
10920F7400007BD101Business Unit / Doc Type Next Number - COMM - 00Files74: EMEA Localization
11920F740001SE71SEPA Account Setup - COMM - 74Files74: EMEA Localization
12920F7400010LC72Company Aditional Information - COMM - 00Files74: EMEA Localization
13920F740018AI131Intrastat Revision Additional - CZE - 74Files74: EMEA Localization
14920F740018DDE661Data extraction ESL - 74Files74: EMEA Localization
15920F740018OOT281Original Transaction Detail for Data ExtractionFiles74: EMEA Localization
16920F740018TTF151Tag File F0018 - EMEA - 74Files74: EMEA Localization
17920F740018WDE661Data extraction ESL - Workfile - 74Files74: EMEA Localization
18920F7400B1QA22Belgium VAT WorktableWork Files04: Accounts PayableBusiness Data
19920F7400C2DP42Obsolete - R7400C2 WorktableTransaction Files04: Accounts PayableBusiness Data
20920F7400C2AFC31French VAT on A/RTransaction Files04: Accounts PayableBusiness Data
21920F7400C3TG31French VAT on A/PTransaction Files04: Accounts PayableBusiness Data
22920F74030BA121Bank ID - ItalyTransaction Files04: Accounts PayableBusiness Data
23920F74030HNL392Dutch-Payments Bank InformationSecondary Master Files04: Accounts PayableBusiness Data
24920F74030HAST41Dutch-Next Batch Number and Sequence NumberSecondary Master Files04: Accounts PayableBusiness Data
25920F7404572KL141Detail Payment Instructions for German PaymentsSecondary Master Files04: Accounts PayableBusiness Data
26920F7404573KI201Detail Payment Instructions EXT. for German PaymentsSecondary Master Files04: Accounts PayableBusiness Data
27920F74091HA41Class/Register Setup - ItalyConstants Files04: Accounts PayableBusiness Data
28920F74092HB61IVA Balances History - ItalyHistory Files04: Accounts PayableBusiness Data
29920F74093HC681Worktable for Printing IVA Summary - ItalyWork Files04: Accounts PayableBusiness Data
30920F740931HD71IVA Summary Report Header - Worktable- ItalyConstants Files04: Accounts PayableBusiness Data
31920F741001TAT71Address Book Tag File - COMM - 01Files74: EMEA Localization
32920F74101VV201Additional Address Book & Vat Id Info via VIES - EU - 01Files74: EMEA Localization
33920F74101WVW231Additional Address Book & Vat Id Info Work File - EU - 01Files74: EMEA Localization
34920F7420011SL72Sales Order / Legal Document Relationship - COMM - 42Files74: EMEA Localization
35920F7420015SR63Invoices Related to Sales Order - COMM - 42Files74: EMEA Localization
36920F7420018ST151Taxes by Sales Order Line - COMM - 42Files74: EMEA Localization
37920F7420033PI231Sales Document Line (Print Info) - COMM - 42Files74: EMEA Localization
38920F7420034PI111Price Adjustment (Print Info) - COMM - 42Files74: EMEA Localization
39920F7420035PI51Item Cross-Reference (Print Info) - COMM - 42Files74: EMEA Localization
40920F7430010LD232Legal Document Header - COMM - 03BFiles74: EMEA Localization
41920F7430015DR63Invoices Related to AR DN/CN - COMM - 03BFiles74: EMEA Localization
42920F7430018TI151Taxes by A/R Invoice Line - COMM - 03BFiles74: EMEA Localization
43920F743002SM372SEPA MandateFiles74: EMEA Localization
44920F7430020HA152History AmendmentFiles74: EMEA Localization
45920F7430021DT131Print Templates Definition for Legal Documents - COMM - 03BFiles74: EMEA Localization
46920F7430022DL81Print Line Type Definition for Legal Documents - COMM - 03BFiles74: EMEA Localization
47920F7430023LD81Legal Documents Types / Print Template Relationship-COMM-03BFiles74: EMEA Localization
48920F7430024DU111Legal Documents Print UBEs & Versions - COMM -03BFiles74: EMEA Localization
49920F7430030PI341Legal Document Header (Print Info) - COMM - 03BFiles74: EMEA Localization
50920F7430031PI201Legal Document Address (Print Info) - COMM - 03BFiles74: EMEA Localization
51920F7430032PI111Legal Document Detail (Print Info) - COMM - 03BFiles74: EMEA Localization
52920F7430033PI141A/R Document Line (Print Info) - COMM - 03BFiles74: EMEA Localization
53920F7430034PI81Legal Document Attachment (Print Info) - COMM - 03BFiles74: EMEA Localization
54920F7430035PI81Taxes by Legal Document Line - COMM - 03BFiles74: EMEA Localization
55920F7430050BH111Print Batch Header - COMM - 03BFiles74: EMEA Localization
56920F7430051BD81Print Batch Detail - COMM - 03BFiles74: EMEA Localization
57920F74301BU21Bank Upload - ItalyTransaction Files04: Accounts PayableBusiness Data
58920F743011PE131Signed Invoices - COMM - 74Files74: EMEA Localization
59920F743011ZTK141Signed Batch Invoice - Tag Table -74Files74: EMEA Localization
60920F743012PE111Unsigned Invoices - COMM - 74Files74: EMEA Localization
61920F743013PE131Signed Invoices - COMM - 74Files74: EMEA Localization
62920F743013ZTK141Signed Batch Invoice - Tag Table -74Files74: EMEA Localization
63920F743025D141Print Template Definition Tag File - COMM - 03BFiles74: EMEA Localization
64920F743035DT141Display Taxes by Legal Document Line - COMM - 03BFiles74: EMEA Localization
65920F744101IN92Intrastat Supplier/Item Cross Reference TableConstants Files00: Foundation EnvironmentBusiness Data
66920F744102IB162Intrastat Commodity Code Additional InformationRegular Work Files00: Foundation EnvironmentBusiness Data
67920F744102TCC103Commodity Code Additional Inf Tag File - CZE - 74Files74: EMEA Localization
68920F74411RS352Withholding Tax Detail - ItalyTransaction Files04: Accounts PayableBusiness Data
69920F74412RP263Customer / Supplier Balance Worktable (A/P and A/R)Master Files74: EMEA LocalizationBusiness Data
70920F74413VC251VAT Ceiling Limit-ItalyBalance Files04: Accounts Payable
71920F7464108LO112Lot Additional Information - COMM - 41Files74: EMEA Localization
72920F74900RP741Foreign Receivables and Payables - EMEARegular Work Files04: Accounts PayableBusiness Data
73920F749101RD91Report Definition - EMEA - 74Files74: EMEA Localization
74920F749102SD161Section Definition - EMEA - 74Files74: EMEA Localization
75920F749103CD222Section Column Definition - EMEA - 74Files74: EMEA Localization
76920F749104RD331Rows Definition - EMEA - 74Files74: EMEA Localization
77920F749105ED172Cells Definition - EMEA - 74Files74: EMEA Localization
78920F749110AG122Account Group Definition - EMEA - 74Files74: EMEA Localization
79920F749111AG111Account Group Detail- EMEA - 74Files74: EMEA Localization
80920F74UI90RD361WF - Report Detail - EMEA - 74Files74: EMEA Localization
81920F74UI91AD201WF - Account Detail - EMEA - 74Files74: EMEA Localization
82920F74UI92CV291WF - Account Cell Value - EMEA - 74Files74: EMEA Localization
83920F74UI93CD72WF - Cost Center Detail - EMEA - 74Files74: EMEA Localization
84920F74UI94CC51WF - Cost Center Detail by Company - EMEA - 74Files74: EMEA Localization
85920F74UI95RH84WF - Report History - EMEA - 74Files74: EMEA Localization
86920F74XMLZ1SY502XML Transaction InterfaceFiles74: EMEA Localization
87920F74XMLZ2SY91XML Transaction Interface iSeries - COMMFiles74: EMEA Localization