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 tables812 | 76H

76H: Chile
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F76H001LD153Legal Document Next Number - CHI - 03B - 76HFiles76: Latin American Localization
2812F76H002CO211Legal Company Constants - CHI - 00 - 76HConstants Files76: Latin American Localization
3812F76H003TT121Tax Area Type - CHI - 00 - 76HFiles76: Latin American Localization
4812F76H004TN72Tax Area Non-Reimbursable - CHI - 00 - 76HFiles76: Latin American Localization
5812F76H005LC101Legal Document Type - CHI - 00 - 76HFiles76: Latin American Localization
6812F76H006LR81Legal Document Type Relationship - CHI - 00 - 76HFiles76: Latin American Localization
7812F76H007LI81Legal Document Type - Print Template Id - CHI - 00 - 76HFiles76: Latin American Localization
8812F76H008CS91Legal Company Constants SOP - CHI - 42 - 76HFiles76: Latin American Localization
9812F76H010LC72Legal Company - CHI - 00 - 76HFiles76: Latin American Localization
10812F76H020NO131Tax rate columns reports set up - CHI - 00 - 76HFiles76: Latin American Localization
11812F76H101TAH261Address Book Tag File - CHI - 01 - 76HFiles76: Latin American Localization
12812F76H101ZAH291EDI - A/B Tag File - CHI - 76H - 76HFiles76: Latin American Localization
13812F76H211SL72Sales Order / Legal Document Relationship - CHI - 42 - 76HFiles76: Latin American Localization
14812F76H215IR111NC/ND - Invoice Related - CHI - 42 - 76HFiles76: Latin American Localization
15812F76H218TD322Taxes by Sales Order Line - CHI - 42 - 76HFiles76: Latin American Localization
16812F76H3B10RT322Header Tag File F03B11 - CHI - 01 - 76HFiles76: Latin American Localization
17812F76H3B15IR162NC/ND - Invoice Related - CHI - 03B - 76HFiles76: Latin American Localization
18812F76H3B1ZZT321F76H3B10 EDI Tag File - CHI - 03B - 76HFiles76: Latin American Localization
19812F76H3B20AD195Invoices not Printed - CHI - 03B - 76HFiles76: Latin American Localization
20812F76H3B30PT131Print Template Definition for Legal Documents - CHI - - 76HFiles76: Latin American Localization
21812F76H3B31PI651Legal Document Header (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
22812F76H3B32PI101Legal Document Detail (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
23812F76H3B33PI71Legal Document Tax (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
24812F76H3B34PI161Sales Document Line (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
25812F76H3B35PI111Price Adjustment (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
26812F76H3B36PI71Legal Document Attachment (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
27812F76H3B37PI71A/R Document Line (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
28812F76H3B38PI161Shipment Guide Line (Print Info) - CHI - 03B - 76HFiles76: Latin American Localization
29812F76H3B39UV121Legal Documents Print UBE and Versions - CHI - 03B - 76HFiles76: Latin American Localization
30812F76H3B40PI71A/P Document Line (Print Info) - CHI - 04Files76H: Chile
31812F76H3B50LP233Lot of Printing - Header - CHI - 03B - 76HFiles76: Latin American Localization
32812F76H3B51LD213Lot of Printing - Detail - CHI - 03B - 76HFiles76: Latin American Localization
33812F76H3B5ZIR182F76H3B15 EDI Tag File - CHI - 03B - 76HFiles76: Latin American Localization
34812F76H401DP181Documents Printed in A/P Legal Reports - CHI - 04 - 76HFiles76: Latin American Localization
35812F76H402LP182Chilean A/P Doc Lines Print Mark - CHI - 04 - 76HFiles76: Latin American Localization
36812F76H6001PH242Actual Cost Process Header - CHI - 41 - 76HFiles76: Latin American Localization
37812F76H6002I1322Indirect Costs Selection EPS F1602 - CHI - 41 - 76HFiles76: Latin American Localization
38812F76H6003I2332Indirect Costs Selection EPS F1642 - CHI - 41 - 76HFiles76: Latin American Localization
39812F76H6004IC111Item Cost Component WF - CHI - 41 - 76HFiles76: Latin American Localization
40812F76H6005AC111Account ID / Cost Type Relationship - CHI - 41 - 76HFiles76: Latin American Localization
41812F76H6006WO81Order Type / Type W.O. Allowed for Actual Cost - CHI - 76HFiles76: Latin American Localization
42812F76H6008IP151Manufactured Items - CHI - 41 - 76HFiles76: Latin American Localization
43812F76H6105AC141Item Actual Cost File - CHI - 41 - 76HFiles76: Latin American Localization
44812F76H611AL4910Actual Item Ledger File - CHI - 41 - 76HTransaction Files76: Latin American Localization
45812F76H6112AN471Actual Item ASOF File - CHI - 41 - 76HTransaction Files76: Latin American Localization
46812F76H6201RH201Replacement Cost Process Header - CHI - 41Files76H: Chile
47812F76H6205IR201Item Replacement Cost - CHI - 41Files76H: Chile
48812F76H902TAT462Account Balances Tag File - CHI - 09 - 76HFiles76: Latin American Localization
49812F76HUI31DR91Document Related Work File - CHI - 42 - 76HFiles76: Latin American Localization
50812F76HUI32WF291Workfile for R76H3B40 - CHI - 42 - 76HFiles76: Latin American Localization
51812F76HUI33WF211Workfile for R76H3B40 - CHI - 42 - 76HFiles76: Latin American Localization
52812F76HUI34OR91Order Related Work File - CHI - 42 - 76HFiles76: Latin American Localization
53812F76HUI50LP101Lot of Printing - Work File - CHI - 42 - 76HFiles76: Latin American Localization
54812F76HUI52DR141Document Selection Work File - CHI - 42 - 76HFiles76: Latin American Localization
55812F76HUI61ZT341Cache F76H3B1Z EDI Tag File - CHI - 03B - 76HFiles76: Latin American Localization