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

55 tables920 | 76H

76H: Chile
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F76H001LD153Legal Document Next Number - CHI - 03B - 76HFiles76: Latin American Localization
2920F76H002CO211Legal Company Constants - CHI - 00 - 76HConstants Files76: Latin American Localization
3920F76H003TT121Tax Area Type - CHI - 00 - 76HFiles76: Latin American Localization
4920F76H004TN72Tax Area Non-Reimbursable - CHI - 00 - 76HFiles76: Latin American Localization
5920F76H005LC101Legal Document Type - CHI - 00 - 76HFiles76: Latin American Localization
6920F76H006LR81Legal Document Type Relationship - CHI - 00 - 76HFiles76: Latin American Localization
7920F76H007LI81Legal Document Type - Print Template Id - CHI - 00 - 76HFiles76: Latin American Localization
8920F76H008CS91Legal Company Constants SOP - CHI - 42 - 76HFiles76: Latin American Localization
9920F76H010LC72Legal Company - CHI - 00 - 76HFiles76: Latin American Localization
10920F76H020NO131Tax rate columns reports set up - CHI - 00 - 76HFiles76: Latin American Localization
11920F76H101TAH261Address Book Tag File - CHI - 01 - 76HFiles76: Latin American Localization
12920F76H101ZAH291EDI - A/B Tag File - CHI - 76H - 76HFiles76: Latin American Localization
13920F76H211SL72Sales Order / Legal Document Relationship - CHI - 42 - 76HFiles76: Latin American Localization
14920F76H215IR111NC/ND - Invoice Related - CHI - 42 - 76HFiles76: Latin American Localization
15920F76H218TD322Taxes by Sales Order Line - CHI - 42 - 76HFiles76: Latin American Localization
16920F76H3B10RT322Header Tag File F03B11 - CHI - 01 - 76HFiles76: Latin American Localization
17920F76H3B15IR162NC/ND - Invoice Related - CHI - 03B - 76HFiles76: Latin American Localization
18920F76H3B1ZZT321F76H3B10 EDI Tag File - CHI - 03B - 76HFiles76: Latin American Localization
19920F76H3B20AD195Invoices not Printed - CHI - 03B - 76HFiles76: Latin American Localization
20920F76H3B30PT131Print Template Definition for Legal Documents - CHI - - 76HFiles76: Latin American Localization
21920F76H3B31PI651Legal Document Header (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
22920F76H3B32PI101Legal Document Detail (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
23920F76H3B33PI71Legal Document Tax (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
24920F76H3B34PI161Sales Document Line (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
25920F76H3B35PI111Price Adjustment (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
26920F76H3B36PI71Legal Document Attachment (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
27920F76H3B37PI71A/R Document Line (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
28920F76H3B38PI161Shipment Guide Line (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
29920F76H3B39UV121Legal Documents Print UBE & Versions - CHI - 03B - 76HFiles76: Latin American Localization
30920F76H3B40PI71A/P Document Line (Print Info) - CHI - 04Files76H: Chile
31920F76H3B50LP213Lot of Printing - Header - CHI - 03B - 76HFiles76: Latin American Localization
32920F76H3B51LD193Lot of Printing - Detail - CHI - 03B - 76HFiles76: Latin American Localization
33920F76H3B5ZIR182F76H3B15 EDI Tag File - CHI - 03B - 76HFiles76: Latin American Localization
34920F76H401DP181Documents Printed in A/P Legal Reports - CHI - 04 - 76HFiles76: Latin American Localization
35920F76H402LP182Chilean A/P Doc Lines Print Mark - CHI - 04 - 76HFiles76: Latin American Localization
36920F76H6001PH242Actual Cost Process Header - CHI - 41 - 76HFiles76: Latin American Localization
37920F76H6002I1322Indirect Costs Selection EPS F1602 - CHI - 41 - 76HFiles76: Latin American Localization
38920F76H6003I2332Indirect Costs Selection EPS F1642 - CHI - 41 - 76HFiles76: Latin American Localization
39920F76H6004IC111Item Cost Component WF - CHI - 41 - 76HFiles76: Latin American Localization
40920F76H6005AC111Account ID / Cost Type Relationship - CHI - 41 - 76HFiles76: Latin American Localization
41920F76H6006WO81Order Type / Type W.O. Allowed for Actual Cost - CHI - 76HFiles76: Latin American Localization
42920F76H6008IP151Manufactured Items - CHI - 41 - 76HFiles76: Latin American Localization
43920F76H6105AC141Item Actual Cost File - CHI - 41 - 76HFiles76: Latin American Localization
44920F76H611AL4910Actual Item Ledger File - CHI - 41 - 76HTransaction Files76: Latin American Localization
45920F76H6112AN471Actual Item ASOF File - CHI - 41 - 76HTransaction Files76: Latin American Localization
46920F76H6201RH201Replacement Cost Process Header - CHI - 41Files76H: Chile
47920F76H6205IR201Item Replacement Cost - CHI - 41Files76H: Chile
48920F76H902TAT462Account Balances Tag File - CHI - 09 - 76HFiles76: Latin American Localization
49920F76HUI31DR91Document Related Work File - CHI - 42 - 76HFiles76: Latin American Localization
50920F76HUI32WF291Workfile for R76H3B40 - CHI - 42 - 76HFiles76: Latin American Localization
51920F76HUI33WF211Workfile for R76H3B40 - CHI - 42 - 76HFiles76: Latin American Localization
52920F76HUI34OR91Order Related Work File - CHI - 42 - 76HFiles76: Latin American Localization
53920F76HUI50LP101Lot of Printing - Work File - CHI - 42 - 76HFiles76: Latin American Localization
54920F76HUI52DR141Document Selection Work File - CHI - 42 - 76HFiles76: Latin American Localization
55920F76HUI61ZT341Cache F76H3B1Z EDI Tag File - CHI - 03B - 76HFiles76: Latin American Localization