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

145 tables920 | 75I

75I: India
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F75I0002Q1123Additional Information Master for SOFiles75I: India
2920F75I001NN121Legal Document Next Numbers - IND - 00Files75I: India
3920F75I005TG81Tax Groups-IND-00Files75I: India
4920F75I006TS81O2C Tax Set up-IND-00Files75I: India
5920F75I007LC111Tax Setup P2P - IND - 43Files75I: India
6920F75I008PO382Purchase Order Receiver Tag File - IND - 43Files75I: India
7920F75I009IS72Item Attributes/Category Codes Mapping - IND - 41Files75I: India
8920F75I010AB101A/B Additional Tax Information - IN - 04Files75I: India
9920F75I011PD131Percentage-Credit DistributionFiles75I: India
10920F75I013PD161Credit DistributionFiles75I: India
11920F75I016CS92Chapter Number Set Up - IND - 41Files75I: India
12920F75I017SO361Sales Order Tag File IND 42Files75I: India
13920F75I022TH131F0411 Tag File Header - IND - 04Transaction Files75I: India
14920F75I031PI281Legal Document Address (Print Info) - IND - 00Files75I: India
15920F75I035DG71Display Taxes by Legal Document Line Tag File - IND - 03BFiles75I: India
16920F75I051IN131POT Setup - IND - 75IFiles75I: India
17920F75I052IN211Services Category Additional information - IND - 75IFiles75I: India
18920F75I053RA202Vouchers Generated for Reverse Charge AR IND - 75IFiles75I: India
19920F75I055RP272Vouchers Generated for Reverse Charge AP - IND - 04Files75I: India
20920F75I072TS212Tax Rules Setup - IND - 45Files75I: India
21920F75I100QB588TDS Ceritificate Master MaintenanceMaster Files75I: India
22920F75I100QEF801TDS Form 26Q - WorkFile (Quarterly)Files75I: India
23920F75I100WEF441TDS Form 26 - WorkFileFiles75I: India
24920F75I101QB633TDS Certificate Work MaintenanceFiles75I: India
25920F75I102QB141TDS Certificate Master Maintenance -Tag FileFiles75I: India
26920F75I103TA111TDS / TCS Acknowledgement NumberFiles75I: India
27920F75I104TD171TDS Certificate Master Maintenance Tag FileFiles75I: India
28920F75I10AQA292TDS Rate Maintenance FileMaster Files75I: India
29920F75I119TCN51Challan number wise amountFiles75I: India
30920F75I15AQC341TDS Document Company Maintenance FileMaster Files75I: India
31920F75I20AQD353TDS Document CompanyMaster Files75I: India
32920F75I210CS371Tax Registration Details - IND - 00Files75I: India
33920F75I211TR101Tax Registration Details Tag File-IND-00Files75I: India
34920F75I213TR141Tax Registration Details-Service Tax Tag File-IND-00Files75I: India
35920F75I215PR71Tax Reg. Detail - PAN Ref Tag File - IND -00Files75I: India
36920F75I220SC81State Level ConstantsFiles75I: India
37920F75I2213TT303Setoff Temp TableFiles75I: India
38920F75I2241VC291WorkFile for VAT/CST ReceivablesFiles75I: India
39920F75I2242DA202VAT- Deferred Amounts for the Purchase cycleFiles75I: India
40920F75I301Q1214Excise - Setup MasterMaster Files75I: India
41920F75I302QA351Excise - Period MasterMaster Files75I: India
42920F75I303Q2181Excise - ARE1 Bond Master-IND-75IMaster Files75I: India
43920F75I304Q382Excise - Cross Reference FileMaster Files75I: India
44920F75I305Q3182Excise - General Surety BondMaster Files75I: India
45920F75I3051FY171Excise Fiscal YearsFiles75I: India
46920F75I306EA91Excise Account Master -IND-00Files75I: India
47920F75I3061EC81Excise Account Master - Credit Redistribution -INDFiles75I: India
48920F75I309CS431Personal Consumption - CENVAT setoff - IND - 41Files75I: India
49920F75I310WRE111Voucher Entry RecordFiles75I: India
50920F75I310YQ21102Excise - MODVAT / PLA Summary FileTransaction Files75I: India
51920F75I311EB152F75I310Y - Tag FileFiles75I: India
52920F75I312Q1485Excise - Consignment/ Adjustment Detail File - ItemWiseTransaction Files75I: India
53920F75I312YQ1626Excise-Consignment/Adjustment Detail -Item wiseFiles75I: India
54920F75I313YQ1403Excise - RG23A - II ChapterWise Transaction FileTransaction Files75I: India
55920F75I314YQ1444Excise - RG23A - II Item Wise Transaction FileTransaction Files75I: India
56920F75I315YQ2402Excise - PLA Chapter Wise Transaction File for Yarn IndustryTransaction Files75I: India
57920F75I316YQ2433Excise - PLA Item Wise Transaction FileTransaction Files75I: India
58920F75I317YQ3392Excise - RG23C - II Chapter Wise Transaction FileTransaction Files75I: India
59920F75I318YQ3433Excise - RG23C - II Item Wise Transaction FileTransaction Files75I: India
60920F75I319BR1352Excise Amount - Transfer Detail FileFiles75I: India
61920F75I319YQ1421Excise - Consolidated Excise Duty PaymentTransaction Files75I: India
62920F75I320YQB561Excise - Payment DetailsTransaction Files75I: India
63920F75I322Q3302Excise - Work File for F04211 & F4101Work Files75I: India
64920F75I322DQC71Excise - Chapter wise temp file for F75I314/16/18(Ex - Amt)Work Files75I: India
65920F75I322EQ3342Excise - Work File for F04211 & F4101(Based on F75I322)Work Files75I: India
66920F75I322FQC111Excise - Chapter wise temp file for F75I314/16/18 (F75I322D)Work Files75I: India
67920F75I323RA181Purchase Order Receiver AR3 Information - IND - 43Files75I: India
68920F75I324Q3322Work File for ARE1 ARE3 IND 42Files75I: India
69920F75I331AI371Customer Master Tagfile - IND - 03BFiles75I: India
70920F75I343QA141Excise - Daywise Closing BalanceTransaction Files75I: India
71920F75I344QB283Excise - ARE1 Bond RegisterTransaction Files75I: India
72920F75I344CCD341ARE-1 Bond Register for Cancelled Receipts-IND-00Files75I: India
73920F75I344YCD474Print ARE-1Bond Register-IND-00Files75I: India
74920F75I345QR442Excise - ARE3 Form Header Details-IND-00Transaction Files75I: India
75920F75I3451QD251Excise - ARE3 Form Detail-IND-00Transaction Files75I: India
76920F75I345XQR462Excise - ARE-3 Form Header for YarnTransaction Files75I: India
77920F75I346Q9463Excise - D3-Form TableTransaction Files75I: India
78920F75I348CT141CT2/CT3 Annexure Certificate Master-IND-00Master Files75I: India
79920F75I354QW361Excise ARE3 Tag file for Form Header IND 42Files75I: India
80920F75I357CH474Consignment HeaderFiles75I: India
81920F75I3571CW481Consignment - Work OrdersFiles75I: India
82920F75I3572CS511Consignment - Stock TransfersFiles75I: India
83920F75I3573CO532Consignment - Order ItemsFiles75I: India
84920F75I3574CT623Consignment - Issues/Receipts TransactionsFiles75I: India
85920F75I3575CP451Consignment - Work Order Part List Items - BalancesFiles75I: India
86920F75I3576SW492Stock Transfer - Work OrdersFiles75I: India
87920F75I380RG875Excise - RG-1 - Transaction File - INDFiles75I: India
88920F75I382IP211Amount of Interest Paid per month - IND - 00Files75I: India
89920F75I385ED391RG23D Register - Issues - IND - 42Files75I: India
90920F75I390ER151Work With Excise ReportsFiles75I: India
91920F75I3901CO782Work With Consignment - IND -43Files75I: India
92920F75I395AER351ER - 5 (1)Files75I: India
93920F75I395BER531ER - 5 (2)Files75I: India
94920F75I395TER541ER - 5 (temp)Files75I: India
95920F75I396AES361ER-6 - List of Finished goods manufacturedFiles75I: India
96920F75I396BSE601ER-6Files75I: India
97920F75I396COB311Table for Opening Balance QuantityFiles75I: India
98920F75I396TSE571ER-6 TempFiles75I: India
99920F75I397SC321ER-6 ScrapFiles75I: India
100920F75I397BES371ER-6 ScrapFiles75I: India
101920F75I401QA343Sales Form Information-IND-42Master Files75I: India
102920F75I401CQA341Sales Form Information- SecondaryMaster Files75I: India
103920F75I402PT583Purchase Tax Form DetailsFiles75I: India
104920F75I402TPT581Purchase Tax Form Details -SecondaryFiles75I: India
105920F75I403AB371Stock Transfer DetailsFiles75I: India
106920F75I403TAB371Temp Data for F75i403Files75I: India
107920F75I404CP221Consolidated tax paymentFiles75I: India
108920F75I405DP222Deferred Input Tax CreditFiles75I: India
109920F75I406SB291State / Branch Plant Cross ReferenceFiles75I: India
110920F75I407IC311Item Category RelationshipFiles75I: India
111920F75I4074AL211Price Adj Ledger Tag File - 03BFiles75I: India
112920F75I408VC271VAT/CST Account MasterFiles75I: India
113920F75I409VS281Personal Consumption - VAT setoff - IND - 41Files75I: India
114920F75I411TF192F0411 Tag File - IN - 04Files75I: India
115920F75I421MA111Assign Price / Cost ElementsFiles75I: India
116920F75I4210FT161Sales Form Tracking - SecondaryFiles75I: India
117920F75I4213SO321Setoff Report Data -IND -00Files75I: India
118920F75I4216AB71Set Off Amount -INDFiles75I: India
119920F75I4223SD581Sales Tax Summary/DetailFiles75I: India
120920F75I4231PT291Purchase Tax Summary / DetailsFiles75I: India
121920F75I601TR332TCS Register Details-IND-42Files75I: India
122920F75I602IB302Item Branch Tagfile - IND - 41Files75I: India
123920F75I603TM141TCS Prepayment Master File - IND-03BFiles75I: India
124920F75I604TP231TCS Payment DetailsFiles75I: India
125920F75I605TA121TCS Tax AmountFiles75I: India
126920F75I611TT394TCS Prepayment Transaction File - IND-03BFiles75I: India
127920F75I612TP232TCS Prepayment To Tax AuthorityFiles75I: India
128920F75I701QH1074Bill of Entry - HeaderFiles75I: India
129920F75I704CR71Service Tax Cross Reference File - INDFiles75I: India
130920F75I731ST252Service Tax A/R File - IND - 03BFiles75I: India
131920F75I732ST181Service Tax A/R File Additional Info - IND - 03BFiles75I: India
132920F75I734PF81Service Tax Received File - IND - 03BFiles75I: India
133920F75I735ST412Order Detail by Service Category Code - IND - 75IFiles75I: India
134920F75I741ST282Service Tax A/P File - IND - 04Files75I: India
135920F75I742ST191Service Tax A/P File Additional Info - IND - 04Files75I: India
136920F75I744PF81Service Tax Payment File - IND - 04Files75I: India
137920F75I750CE222Service Tax Cenvat File -09 - INDFiles75I: India
138920F75I754AP131Advance Service Tax Payment File - IND -04Files75I: India
139920F75I760AB261Advance Service Tax Balance File - INDFiles75I: India
140920F75I790WT61Form ST-3 Working Table - IND - 09Files75I: India
141920F75I790TSF141ST-3 Section 5A, 5AA and 5B Setup fileFiles75I: India
142920F75I791IS293Item/Supplier Cost Components - IND - 43BMaster Files75I: India
143920F75IEXCQZ71Excise Balance File lockMaster Files75I: India
144920F75IUI01TW211eTCS Anuual Return - Work FileFiles75I: India
145920F75IUI7WF241Service Tax Credit Register - Work File - INDFiles75I: India