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

37 columns | Print definition?920 | FLAG

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP75C: China
1F75C002Electronic Accounting Book21EAFLAGJournaling FlagCharacterGeneric Edit10
2F75C006Natural Account Structure Set Up11NAFLAGJournaling FlagCharacterGeneric Edit10
3F75C007China - Chart of Accounts Set Up18CAFLAGJournaling FlagCharacterGeneric Edit10
4F75C010WAP & AR XML Workfile - China -75C33AAFLAGJournaling FlagCharacterGeneric Edit10
5F75C911AAccount Ledger Processing Info- China - 098ALFLAGJournaling FlagCharacterGeneric Edit10
6F75CDXMDynamic XML Output Generator8DXFLAGJournaling FlagCharacterGeneric Edit10
7F75CUI05AP & AR Multiple Period XML Workfile - China -75C4MPFLAGJournaling FlagCharacterGeneric Edit10
8F75CUI3Financial Reporting Work FIle23CWFLAGJournaling FlagCharacterGeneric Edit10
TOP75I: India
9F75I100QTDS Form 26Q - WorkFile (Quarterly)39EFFLAGJournaling FlagCharacterGeneric Edit10
10F75I100WTDS Form 26 - WorkFile29EFFLAGJournaling FlagCharacterGeneric Edit10
11F75I15ATDS Document Company Maintenance File26QCFLAGJournaling FlagCharacterGeneric Edit10
12F75I20ATDS Document Company33QDFLAGJournaling FlagCharacterGeneric Edit10
13F75I2213Setoff Temp Table24TTFLAGJournaling FlagCharacterGeneric Edit10
14F75I2242VAT- Deferred Amounts for the Purchase cycle19DAFLAGJournaling FlagCharacterGeneric Edit10
15F75I313YExcise - RG23A - II ChapterWise Transaction File31Q1FLAGJournaling FlagCharacterGeneric Edit10
16F75I314YExcise - RG23A - II Item Wise Transaction File35Q1FLAGJournaling FlagCharacterGeneric Edit10
17F75I315YExcise - PLA Chapter Wise Transaction File for Yarn Industry29Q2FLAGJournaling FlagCharacterGeneric Edit10
18F75I316YExcise - PLA Item Wise Transaction File34Q2FLAGJournaling FlagCharacterGeneric Edit10
19F75I317YExcise - RG23C - II Chapter Wise Transaction File36Q3FLAGJournaling FlagCharacterGeneric Edit10
20F75I318YExcise - RG23C - II Item Wise Transaction File40Q3FLAGJournaling FlagCharacterGeneric Edit10
21F75I324Work File for ARE1 ARE3 IND 4225Q3FLAGJournaling FlagCharacterGeneric Edit10
22F75I344CARE-1 Bond Register for Cancelled Receipts-IND-005CDFLAGJournaling FlagCharacterGeneric Edit10
23F75I354Excise ARE3 Tag file for Form Header IND 4230QWFLAGJournaling FlagCharacterGeneric Edit10
24F75I357Consignment Header18CHFLAGJournaling FlagCharacterGeneric Edit10
25F75I3571Consignment - Work Orders19CWFLAGJournaling FlagCharacterGeneric Edit10
26F75I3572Consignment - Stock Transfers22CSFLAGJournaling FlagCharacterGeneric Edit10
27F75I3573Consignment - Order Items24COFLAGJournaling FlagCharacterGeneric Edit10
28F75I3574Consignment - Issues/Receipts Transactions33CTFLAGJournaling FlagCharacterGeneric Edit10
29F75I3575Consignment - Work Order Part List Items - Balances16CPFLAGJournaling FlagCharacterGeneric Edit10
30F75I3576Stock Transfer - Work Orders21SWFLAGJournaling FlagCharacterGeneric Edit10
31F75I380Excise - RG-1 - Transaction File - IND40RGFLAGJournaling FlagCharacterGeneric Edit10
32F75I3901Work With Consignment - IND -4337COFLAGJournaling FlagCharacterGeneric Edit10
33F75I601TCS Register Details-IND-4229TRFLAGJournaling FlagCharacterGeneric Edit10
34F75I701Bill of Entry - Header85QHFLAGJournaling FlagCharacterGeneric Edit10
35F75IUI7Service Tax Credit Register - Work File - IND3WFFLAGJournaling FlagCharacterGeneric Edit10
TOP76V: Venezuela
36F76VLO01Withholdings Temporal Table - VEN -04 - 76V5LOFLAGJournaling FlagCharacterGeneric Edit10
TOP89: Conversion Programs
37F75I101ATDS Ceritificate Master Tabel Extension10QBFLAGJournaling FlagCharacterGeneric Edit10