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

52 columns | Print definition?920 | YEXU

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP75I: India
1F75I001Legal Document Next Numbers - IND - 002NNYEXUExcise UnitNumericGeneric Edit80
2F75I008Purchase Order Receiver Tag File - IND - 4315POYEXUExcise UnitNumericGeneric Edit80
3F75I013Credit Distribution7PDYEXUExcise UnitNumericGeneric Edit80
4F75I017Sales Order Tag File IND 4212SOYEXUExcise UnitNumericGeneric Edit80
5F75I301Excise - Setup Master1Q1YEXUExcise UnitNumericGeneric Edit80
6F75I302Excise - Period Master1QAYEXUExcise UnitNumericGeneric Edit80
7F75I303Excise - ARE1 Bond Master-IND-75I1Q2YEXUExcise UnitNumericGeneric Edit80
8F75I304Excise - Cross Reference File1Q3YEXUExcise UnitNumericGeneric Edit80
9F75I305Excise - General Surety Bond1Q3YEXUExcise UnitNumericGeneric Edit80
10F75I3051Excise Fiscal Years1FYYEXUExcise UnitNumericGeneric Edit80
11F75I306Excise Account Master -IND-001EAYEXUExcise UnitNumericGeneric Edit80
12F75I3061Excise Account Master - Credit Redistribution -IND1ECYEXUExcise UnitNumericGeneric Edit80
13F75I310WVoucher Entry Record1REYEXUExcise UnitNumericGeneric Edit80
14F75I310YExcise - MODVAT / PLA Summary File1Q2YEXUExcise UnitNumericGeneric Edit80
15F75I311F75I310Y - Tag File1EBYEXUExcise UnitNumericGeneric Edit80
16F75I312Excise - Consignment/ Adjustment Detail File - ItemWise19Q1YEXUExcise UnitNumericGeneric Edit80
17F75I312YExcise-Consignment/Adjustment Detail -Item wise21Q1YEXUExcise UnitNumericGeneric Edit80
18F75I313YExcise - RG23A - II ChapterWise Transaction File1Q1YEXUExcise UnitNumericGeneric Edit80
19F75I314YExcise - RG23A - II Item Wise Transaction File1Q1YEXUExcise UnitNumericGeneric Edit80
20F75I315YExcise - PLA Chapter Wise Transaction File for Yarn Industry1Q2YEXUExcise UnitNumericGeneric Edit80
21F75I316YExcise - PLA Item Wise Transaction File1Q2YEXUExcise UnitNumericGeneric Edit80
22F75I317YExcise - RG23C - II Chapter Wise Transaction File1Q3YEXUExcise UnitNumericGeneric Edit80
23F75I318YExcise - RG23C - II Item Wise Transaction File1Q3YEXUExcise UnitNumericGeneric Edit80
24F75I319BExcise Amount - Transfer Detail File1R1YEXUExcise UnitNumericGeneric Edit80
25F75I319YExcise - Consolidated Excise Duty Payment2Q1YEXUExcise UnitNumericGeneric Edit80
26F75I320YExcise - Payment Details11QBYEXUExcise UnitNumericGeneric Edit80
27F75I322DExcise - Chapter wise temp file for F75I314/16/18(Ex - Amt)4QCYEXUExcise UnitNumericGeneric Edit80
28F75I322FExcise - Chapter wise temp file for F75I314/16/18 (F75I322D)4QCYEXUExcise UnitNumericGeneric Edit80
29F75I343Excise - Daywise Closing Balance1QAYEXUExcise UnitNumericGeneric Edit80
30F75I344Excise - ARE1 Bond Register1QBYEXUExcise UnitNumericGeneric Edit80
31F75I344CARE-1 Bond Register for Cancelled Receipts-IND-001CDYEXUExcise UnitNumericGeneric Edit80
32F75I344YPrint ARE-1Bond Register-IND-001CDYEXUExcise UnitNumericGeneric Edit80
33F75I345Excise - ARE3 Form Header Details-IND-001QRYEXUExcise UnitNumericGeneric Edit80
34F75I3451Excise - ARE3 Form Detail-IND-001QDYEXUExcise UnitNumericGeneric Edit80
35F75I345XExcise - ARE-3 Form Header for Yarn1QRYEXUExcise UnitNumericGeneric Edit80
36F75I346Excise - D3-Form Table1Q9YEXUExcise UnitNumericGeneric Edit80
37F75I354Excise ARE3 Tag file for Form Header IND 421QWYEXUExcise UnitNumericGeneric Edit80
38F75I357Consignment Header3CHYEXUExcise UnitNumericGeneric Edit80
39F75I3571Consignment - Work Orders3CWYEXUExcise UnitNumericGeneric Edit80
40F75I3572Consignment - Stock Transfers3CSYEXUExcise UnitNumericGeneric Edit80
41F75I3573Consignment - Order Items4COYEXUExcise UnitNumericGeneric Edit80
42F75I3574Consignment - Issues/Receipts Transactions3CTYEXUExcise UnitNumericGeneric Edit80
43F75I380Excise - RG-1 - Transaction File - IND3RGYEXUExcise UnitNumericGeneric Edit80
44F75I382Amount of Interest Paid per month - IND - 001IPYEXUExcise UnitNumericGeneric Edit80
45F75I390Work With Excise Reports14ERYEXUExcise UnitNumericGeneric Edit80
46F75I3901Work With Consignment - IND -433COYEXUExcise UnitNumericGeneric Edit80
47F75I396AER-6 - List of Finished goods manufactured7ESYEXUExcise UnitNumericGeneric Edit80
48F75I396BER-631SEYEXUExcise UnitNumericGeneric Edit80
49F75I396TER-6 Temp28SEYEXUExcise UnitNumericGeneric Edit80
50F75I397ER-6 Scrap12SCYEXUExcise UnitNumericGeneric Edit80
51F75I397BER-6 Scrap8ESYEXUExcise UnitNumericGeneric Edit80
52F75IEXCExcise Balance File lock1QZYEXUExcise UnitNumericGeneric Edit80