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
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

66 columns | Print definition?920 | N001

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0002Next Numbers - Automatic12NNN001Next Number Range 1NumericGeneric Edit80
2F00021Next Numbers by Company/Fiscal Year - Automatic6NLN001Next Number Range 1NumericGeneric Edit80
3F00023Distributed Next Number Table12DNN001Next Number Range 1NumericGeneric Edit80
TOP04: Accounts Payable
4F0411XCM Voucher Cross Reference1CMN001Next Number Range 1NumericGeneric Edit80
TOP09: General Accounting
5F09218Online Consolidations Set-up File16LSN001Next Number Range 1NumericGeneric Edit80
6F092181Online Consolidation Detail File1LRN001Next Number Range 1NumericGeneric Edit80
TOP43: Procurement
7F4310XCM Purchase Order Cross Reference1CMN001Next Number Range 1NumericGeneric Edit80
TOP49: Transportation Management
8F49160Document Next Number7NNN001Next Number Range 1NumericGeneric Edit80
9F49170Load Next Numbers2NNN001Next Number Range 1NumericGeneric Edit80
TOP51: Job Costing
10F51002Job Cost Draws Next Number2GKN001Next Number Range 1NumericGeneric Edit80
TOP53: Change Management
11F5311XCM Change Order Cross Reference5CMN001Next Number Range 1NumericGeneric Edit80
TOP70: Multi-National Products
12F704001Payment WH Info TEMP - COMM - 0445PTN001Next Number Range 1NumericGeneric Edit80
13F704002Payment WH Info - COMM - 0444PFN001Next Number Range 1NumericGeneric Edit80
14F704002PPayment WH Info Purge - COMM - 0444PFN001Next Number Range 1NumericGeneric Edit80
TOP74: EMEA Localization
15F7400007Business Unit / Doc Type Next Number - COMM - 004BDN001Next Number Range 1NumericGeneric Edit80
TOP74R: Russia
16F74R0100Petty Cash Transactions - RUS - 00 - 74R32PCN001Next Number Range 1NumericGeneric Edit80
17F74R012Cash Documents Next Number Setup - RUS - 008CDN001Next Number Range 1NumericGeneric Edit80
TOP74W: Sweden
18F74W200A/P Payment Processing Sequence Numbers File - 74W9K0N001Next Number Range 1NumericGeneric Edit80
19F74W203Debit Advice Invoice File - 74W10K3N001Next Number Range 1NumericGeneric Edit80
TOP74Y: Italy
20F74YUI10Italy Customer Detail WF - ITA - 74Y2CDN001Next Number Range 1NumericGeneric Edit80
21F74YUI11Italy SupplierDetail WF - ITA - 74Y2SDN001Next Number Range 1NumericGeneric Edit80
TOP75I: India
22F75I100QTDS Form 26Q - WorkFile (Quarterly)9EFN001Next Number Range 1NumericGeneric Edit80
23F75I100WTDS Form 26 - WorkFile9EFN001Next Number Range 1NumericGeneric Edit80
TOP76A: Argentina
24F76001ANext Number File - ARG - 03B - 76A6NCN001Next Number Range 1NumericGeneric Edit80
25F760407AGross Income - State Set Up - ARG - 04 - 76A5K4N001Next Number Range 1NumericGeneric Edit80
26F76A8080Certificate Next Number RG 738/99- ARG - 04 - 76A4NNN001Next Number Range 1NumericGeneric Edit80
TOP76B: Brazil
27F7601BNota Fiscal Header - BRA - 423FHN001Next Number Range 1NumericGeneric Edit80
28F76101BNota Fiscal - Header (Fiscal Books) - 425QXN001Next Number Range 1NumericGeneric Edit80
29F7611BNota Fiscal Detail - BRA - 423FDN001Next Number Range 1NumericGeneric Edit80
30F76121BNota Fiscal Print Message Header - Brazil - 423FZN001Next Number Range 1NumericGeneric Edit80
31F7612BNota Fiscal Print Message - BRA - 424FYN001Next Number Range 1NumericGeneric Edit80
32F761BAAS Fiscal file book - 093FBN001Next Number Range 1NumericGeneric Edit80
33F76B001Nota Fiscal Taxes Header - Brazil - 423THN001Next Number Range 1NumericGeneric Edit80
34F76B011Nota Fiscal Taxes Detail - Brazil - 423TDN001Next Number Range 1NumericGeneric Edit80
35F76B012Nota Fiscal Detail - Tributary Situations - BRA3TSN001Next Number Range 1NumericGeneric Edit80
36F76B014Nota Fiscal Detail -Import - BRA - 76B3IMN001Next Number Range 1NumericGeneric Edit80
37F76B018Nota Fiscal Import Relationship - BRA - 76B3IRN001Next Number Range 1NumericGeneric Edit80
38F76B019Nota Fiscal Header -Exports - BRA - 76B3EXN001Next Number Range 1NumericGeneric Edit80
39F76B01T1NFe Header Tag File - 76B3FHN001Next Number Range 1NumericGeneric Edit80
40F76B01TENFe Header - 76B3FHN001Next Number Range 1NumericGeneric Edit80
41F76B02TENFe Header History - 76B3FHN001Next Number Range 1NumericGeneric Edit80
42F76B030NF Header PIS/COFINS Tag File - BRA - 76B3MTN001Next Number Range 1NumericGeneric Edit80
43F76B031NF Detail PIS/COFINS Tag File - BRA - 76B3PCN001Next Number Range 1NumericGeneric Edit80
44F76B036Fiscal Notes and Judicial Process Relationship - BRA - 76B3JRN001Next Number Range 1NumericGeneric Edit80
45F76B038Fiscal Notes and Administrative Process Relat. - BRA - 76B3ARN001Next Number Range 1NumericGeneric Edit80
46F76B0540Brazil Electronic Reporting Block B Worktable4BWN001Next Number Range 1NumericGeneric Edit80
47F76B0550Workfile Block C - BRA - 76B7BCN001Next Number Range 1NumericGeneric Edit80
48F76B0570Brazil Elect Rpt Block E Work table - BRA - 007WFN001Next Number Range 1NumericGeneric Edit80
49F76B060ePIS COFINS NF Worktable - BRA - 76B4NWN001Next Number Range 1NumericGeneric Edit80
50F76B0735Ato - Cotepe11 - Block E - Work File8WFN001Next Number Range 1NumericGeneric Edit80
51F76B1001Tag File F7601B Nota Fiscal Header - BRA - 76B3THN001Next Number Range 1NumericGeneric Edit80
52F76B1010Tag File F7611B Nota Fiscal Detail - BRA - 76B3TDN001Next Number Range 1NumericGeneric Edit80
53F76B1020NFe Access Authorized Person Setup by Nota Fiscal - BRA - 763APN001Next Number Range 1NumericGeneric Edit80
54F76B11TENFe Detail - 76B3FDN001Next Number Range 1NumericGeneric Edit80
55F76B12TENF-e Status Log - BRA - 76B4SLN001Next Number Range 1NumericGeneric Edit80
56F76B410CIN86-Work Table for Services Outbound Nota Fiscal Hea - 423SHN001Next Number Range 1NumericGeneric Edit80
57F76B410DIN86-Work Table for Merchandise Nota Fiscal Issued by - 423CHN001Next Number Range 1NumericGeneric Edit80
58F76B410EIN86-Work Table for Merchandise NF Issued by Supplier - 413SHN001Next Number Range 1NumericGeneric Edit80
59F76B410HINSS-Work Table for Services Third Party Inbound NF H - 423SIN001Next Number Range 1NumericGeneric Edit80
60F76B411CIN86-Work Table for Services Outbound Nota Fiscal Det - 423SDN001Next Number Range 1NumericGeneric Edit80
61F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 423CDN001Next Number Range 1NumericGeneric Edit80
62F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 413SDN001Next Number Range 1NumericGeneric Edit80
63F76B427Service Nota Fiscal Witholdings by Formula - BRA - 76B3SNN001Next Number Range 1NumericGeneric Edit80
64F76B428Service Nota Fiscal Witholdings by Service - BRA - 76B3SSN001Next Number Range 1NumericGeneric Edit80
65F76B429Service Nota Fiscal Wh by Formula Installment - BRA - 76B3SNN001Next Number Range 1NumericGeneric Edit80
66F76B561Selected NFe by Lot Work File - BRA - 76B5WFN001Next Number Range 1NumericGeneric Edit80