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
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

86 tables910 | 74

74: EMEA Localization
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F0018TTD461Intrastat RevisionConstants Files74: EMEA LocalizationBusiness Data
2910F00900IR131Year-End VAT Revision - ItalyTransaction Files09: General AccountingBusiness Data
3910F0091IF201A/B Vendor Information for Year-end IVA tape - ItalyTransaction Files04: Accounts PayableBusiness Data
4910F00918BB21Year-end IVA Tape Creation - ItalyWork Files04: Accounts PayableBusiness Data
5910F7400001NN101Legal Document Next Numbers - COMM - 00Files74: EMEA Localization
6910F7400002LD121Legal Document Types - COMM - 00Files74: EMEA Localization
7910F7400003RL91Legal Document Types / Document Types Relationship - COMM-00Files74: EMEA Localization
8910F7400004IP71Legal Document Issue Places - COMM - 00Files74: EMEA Localization
9910F7400006PD163Processed Documents in Legal Applications - COMM - 00Files74: EMEA Localization
10910F7400007BD101Business Unit / Doc Type Next Number - COMM - 00Files74: EMEA Localization
11910F740001SE71SEPA Account Setup - COMM - 74Files74: EMEA Localization
12910F7400010LC72Company Aditional Information - COMM - 00Files74: EMEA Localization
13910F740018AI131Intrastat Revision Additional - CZE - 74Files74: EMEA Localization
14910F740018DDE661Data extraction ESL - 74Files74: EMEA Localization
15910F740018OOT281Original Transaction Detail for Data ExtractionFiles74: EMEA Localization
16910F740018TTF151Tag File F0018 - EMEA - 74Files74: EMEA Localization
17910F740018WDE661Data extraction ESL - Workfile - 74Files74: EMEA Localization
18910F7400B1QA22Belgium VAT WorktableWork Files04: Accounts PayableBusiness Data
19910F7400C2DP42Obsolete - R7400C2 WorktableTransaction Files04: Accounts PayableBusiness Data
20910F7400C2AFC31French VAT on A/RTransaction Files04: Accounts PayableBusiness Data
21910F7400C3TG31French VAT on A/PTransaction Files04: Accounts PayableBusiness Data
22910F74030BA121Bank ID - ItalyTransaction Files04: Accounts PayableBusiness Data
23910F74030HNL392Dutch-Payments Bank InformationSecondary Master Files04: Accounts PayableBusiness Data
24910F74030HAST41Dutch-Next Batch Number and Sequence NumberSecondary Master Files04: Accounts PayableBusiness Data
25910F7404572KL141Detail Payment Instructions for German PaymentsSecondary Master Files04: Accounts PayableBusiness Data
26910F7404573KI201Detail Payment Instructions EXT. for German PaymentsSecondary Master Files04: Accounts PayableBusiness Data
27910F74091HA41Class/Register Setup - ItalyConstants Files04: Accounts PayableBusiness Data
28910F74092HB61IVA Balances History - ItalyHistory Files04: Accounts PayableBusiness Data
29910F74093HC681Worktable for Printing IVA Summary - ItalyWork Files04: Accounts PayableBusiness Data
30910F740931HD71IVA Summary Report Header - Worktable- ItalyConstants Files04: Accounts PayableBusiness Data
31910F741001TAT71Address Book Tag File - COMM - 01Files74: EMEA Localization
32910F74101VV201Additional Address Book & Vat Id Info via VIES - EU - 01Files74: EMEA Localization
33910F74101WVW231Additional Address Book & Vat Id Info Work File - EU - 01Files74: EMEA Localization
34910F7420011SL72Sales Order / Legal Document Relationship - COMM - 42Files74: EMEA Localization
35910F7420015SR62Invoices Related to Sales Order - COMM - 42Files74: EMEA Localization
36910F7420018ST151Taxes by Sales Order Line - COMM - 42Files74: EMEA Localization
37910F7420033PI231Sales Document Line (Print Info) - COMM - 42Files74: EMEA Localization
38910F7420034PI111Price Adjustment (Print Info) - COMM - 42Files74: EMEA Localization
39910F7420035PI51Item Cross-Reference (Print Info) - COMM - 42Files74: EMEA Localization
40910F7430010LD232Legal Document Header - COMM - 03BFiles74: EMEA Localization
41910F7430015DR62Invoices Related to AR DN/CN - COMM - 03BFiles74: EMEA Localization
42910F7430018TI151Taxes by A/R Invoice Line - COMM - 03BFiles74: EMEA Localization
43910F743002SM372SEPA MandateFiles74: EMEA Localization
44910F7430020HA152History AmendmentFiles74: EMEA Localization
45910F7430021DT131Print Templates Definition for Legal Documents - COMM - 03BFiles74: EMEA Localization
46910F7430022DL81Print Line Type Definition for Legal Documents - COMM - 03BFiles74: EMEA Localization
47910F7430023LD81Legal Documents Types / Print Template Relationship-COMM-03BFiles74: EMEA Localization
48910F7430024DU111Legal Documents Print UBEs & Versions - COMM -03BFiles74: EMEA Localization
49910F7430030PI341Legal Document Header (Print Info) - COMM - 03BFiles74: EMEA Localization
50910F7430031PI201Legal Document Address (Print Info) - COMM - 03BFiles74: EMEA Localization
51910F7430032PI111Legal Document Detail (Print Info) - COMM - 03BFiles74: EMEA Localization
52910F7430033PI141A/R Document Line (Print Info) - COMM - 03BFiles74: EMEA Localization
53910F7430034PI81Legal Document Attachment (Print Info) - COMM - 03BFiles74: EMEA Localization
54910F7430035PI81Taxes by Legal Document Line - COMM - 03BFiles74: EMEA Localization
55910F7430050BH111Print Batch Header - COMM - 03BFiles74: EMEA Localization
56910F7430051BD81Print Batch Detail - COMM - 03BFiles74: EMEA Localization
57910F74301BU21Bank Upload - ItalyTransaction Files04: Accounts PayableBusiness Data
58910F743011PE131Signed Invoices - COMM - 74Files74: EMEA Localization
59910F743011ZTK141Signed Batch Invoice - Tag Table -74Files74: EMEA Localization
60910F743012PE111Unsigned Invoices - COMM - 74Files74: EMEA Localization
61910F743025D141Print Template Definition Tag File - COMM - 03BFiles74: EMEA Localization
62910F743035DT141Display Taxes by Legal Document Line - COMM - 03BFiles74: EMEA Localization
63910F74405RC111Withholding Tax Codes-ItalyTransaction Files04: Accounts PayableBusiness Data
64910F744101IN92Intrastat Supplier/Item Cross Reference TableConstants Files00: Foundation EnvironmentBusiness Data
65910F744102IB162Intrastat Commodity Code Additional InformationRegular Work Files00: Foundation EnvironmentBusiness Data
66910F744102TCC103Commodity Code Additional Inf Tag File - CZE - 74Files74: EMEA Localization
67910F74411RS352Withholding Tax Detail - ItalyTransaction Files04: Accounts PayableBusiness Data
68910F74412RP263Customer / Supplier Balance Worktable (A/P and A/R)Master Files74: EMEA LocalizationBusiness Data
69910F74413VC251VAT Ceiling Limit-ItalyBalance Files04: Accounts Payable
70910F7464108LO112Lot Additional Information - COMM - 41Files74: EMEA Localization
71910F74900RP741Foreign Receivables and Payables - EMEARegular Work Files04: Accounts PayableBusiness Data
72910F749101RD91Report Definition - EMEA - 74Files74: EMEA Localization
73910F749102SD161Section Definition - EMEA - 74Files74: EMEA Localization
74910F749103CD222Section Column Definition - EMEA - 74Files74: EMEA Localization
75910F749104RD331Rows Definition - EMEA - 74Files74: EMEA Localization
76910F749105ED172Cells Definition - EMEA - 74Files74: EMEA Localization
77910F749110AG122Account Group Definition - EMEA - 74Files74: EMEA Localization
78910F749111AG111Account Group Detail- EMEA - 74Files74: EMEA Localization
79910F74UI90RD361WF - Report Detail - EMEA - 74Files74: EMEA Localization
80910F74UI91AD201WF - Account Detail - EMEA - 74Files74: EMEA Localization
81910F74UI92CV291WF - Account Cell Value - EMEA - 74Files74: EMEA Localization
82910F74UI93CD72WF - Cost Center Detail - EMEA - 74Files74: EMEA Localization
83910F74UI94CC51WF - Cost Center Detail by Company - EMEA - 74Files74: EMEA Localization
84910F74UI95RH84WF - Report History - EMEA - 74Files74: EMEA Localization
85910F74XMLZ1SY502XML Transaction InterfaceFiles74: EMEA Localization
86910F74XMLZ2SY91XML Transaction Interface iSeries - COMMFiles74: EMEA Localization