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 tables910 | 75I

75I: India
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F75I0002Q1123Additional Information Master for SOFiles75I: India
2910F75I001NN121Legal Document Next Numbers - IND - 00Files75I: India
3910F75I005TG81Tax Groups-IND-00Files75I: India
4910F75I006TS81O2C Tax Set up-IND-00Files75I: India
5910F75I007LC111Tax Setup P2P - IND - 43Files75I: India
6910F75I008PO382Purchase Order Receiver Tag File - IND - 43Files75I: India
7910F75I009IS72Item Attributes/Category Codes Mapping - IND - 41Files75I: India
8910F75I010AB101A/B Additional Tax Information - IN - 04Files75I: India
9910F75I011PD131Percentage-Credit DistributionFiles75I: India
10910F75I013PD161Credit DistributionFiles75I: India
11910F75I016CS92Chapter Number Set Up - IND - 41Files75I: India
12910F75I017SO361Sales Order Tag File IND 42Files75I: India
13910F75I022TH131F0411 Tag File Header - IND - 04Transaction Files75I: India
14910F75I031PI281Legal Document Address (Print Info) - IND - 00Files75I: India
15910F75I035DG71Display Taxes by Legal Document Line Tag File - IND - 03BFiles75I: India
16910F75I051IN131POT Setup - IND - 75IFiles75I: India
17910F75I052IN211Services Category Additional information - IND - 75IFiles75I: India
18910F75I053RA202Vouchers Generated for Reverse Charge AR IND - 75IFiles75I: India
19910F75I055RP272Vouchers Generated for Reverse Charge AP - IND - 04Files75I: India
20910F75I072TS212Tax Rules Setup - IND - 45Files75I: India
21910F75I100QB578TDS Ceritificate Master MaintenanceMaster Files75I: India
22910F75I100QEF801TDS Form 26Q - WorkFile (Quarterly)Files75I: India
23910F75I100WEF441TDS Form 26 - WorkFileFiles75I: India
24910F75I101QB633TDS Certificate Work MaintenanceFiles75I: India
25910F75I102QB141TDS Certificate Master Maintenance -Tag FileFiles75I: India
26910F75I103TA111TDS / TCS Acknowledgement NumberFiles75I: India
27910F75I104TD171TDS Certificate Master Maintenance Tag FileFiles75I: India
28910F75I10AQA272TDS Rate Maintenance FileMaster Files75I: India
29910F75I119TCN51Challan number wise amountFiles75I: India
30910F75I15AQC331TDS Document Company Maintenance FileMaster Files75I: India
31910F75I20AQD343TDS Document CompanyMaster Files75I: India
32910F75I210CS371Tax Registration Details - IND - 00Files75I: India
33910F75I211TR101Tax Registration Details Tag File-IND-00Files75I: India
34910F75I213TR141Tax Registration Details-Service Tax Tag File-IND-00Files75I: India
35910F75I215PR71Tax Reg. Detail - PAN Ref Tag File - IND -00Files75I: India
36910F75I220SC81State Level ConstantsFiles75I: India
37910F75I2213TT303Setoff Temp TableFiles75I: India
38910F75I2241VC291WorkFile for VAT/CST ReceivablesFiles75I: India
39910F75I2242DA202VAT- Deferred Amounts for the Purchase cycleFiles75I: India
40910F75I301Q1214Excise - Setup MasterMaster Files75I: India
41910F75I302QA351Excise - Period MasterMaster Files75I: India
42910F75I303Q2181Excise - ARE1 Bond Master-IND-75IMaster Files75I: India
43910F75I304Q382Excise - Cross Reference FileMaster Files75I: India
44910F75I305Q3182Excise - General Surety BondMaster Files75I: India
45910F75I3051FY171Excise Fiscal YearsFiles75I: India
46910F75I306EA91Excise Account Master -IND-00Files75I: India
47910F75I3061EC81Excise Account Master - Credit Redistribution -INDFiles75I: India
48910F75I309CS431Personal Consumption - CENVAT setoff - IND - 41Files75I: India
49910F75I310WRE111Voucher Entry RecordFiles75I: India
50910F75I310YQ21102Excise - MODVAT / PLA Summary FileTransaction Files75I: India
51910F75I311EB152F75I310Y - Tag FileFiles75I: India
52910F75I312Q1485Excise - Consignment/ Adjustment Detail File - ItemWiseTransaction Files75I: India
53910F75I312YQ1626Excise-Consignment/Adjustment Detail -Item wiseFiles75I: India
54910F75I313YQ1403Excise - RG23A - II ChapterWise Transaction FileTransaction Files75I: India
55910F75I314YQ1444Excise - RG23A - II Item Wise Transaction FileTransaction Files75I: India
56910F75I315YQ2402Excise - PLA Chapter Wise Transaction File for Yarn IndustryTransaction Files75I: India
57910F75I316YQ2433Excise - PLA Item Wise Transaction FileTransaction Files75I: India
58910F75I317YQ3392Excise - RG23C - II Chapter Wise Transaction FileTransaction Files75I: India
59910F75I318YQ3433Excise - RG23C - II Item Wise Transaction FileTransaction Files75I: India
60910F75I319BR1352Excise Amount - Transfer Detail FileFiles75I: India
61910F75I319YQ1421Excise - Consolidated Excise Duty PaymentTransaction Files75I: India
62910F75I320YQB561Excise - Payment DetailsTransaction Files75I: India
63910F75I322Q3302Excise - Work File for F04211 & F4101Work Files75I: India
64910F75I322DQC71Excise - Chapter wise temp file for F75I314/16/18(Ex - Amt)Work Files75I: India
65910F75I322EQ3342Excise - Work File for F04211 & F4101(Based on F75I322)Work Files75I: India
66910F75I322FQC111Excise - Chapter wise temp file for F75I314/16/18 (F75I322D)Work Files75I: India
67910F75I323RA181Purchase Order Receiver AR3 Information - IND - 43Files75I: India
68910F75I324Q3322Work File for ARE1 ARE3 IND 42Files75I: India
69910F75I331AI371Customer Master Tagfile - IND - 03BFiles75I: India
70910F75I343QA141Excise - Daywise Closing BalanceTransaction Files75I: India
71910F75I344QB283Excise - ARE1 Bond RegisterTransaction Files75I: India
72910F75I344CCD341ARE-1 Bond Register for Cancelled Receipts-IND-00Files75I: India
73910F75I344YCD474Print ARE-1Bond Register-IND-00Files75I: India
74910F75I345QR442Excise - ARE3 Form Header Details-IND-00Transaction Files75I: India
75910F75I3451QD251Excise - ARE3 Form Detail-IND-00Transaction Files75I: India
76910F75I345XQR462Excise - ARE-3 Form Header for YarnTransaction Files75I: India
77910F75I346Q9463Excise - D3-Form TableTransaction Files75I: India
78910F75I348CT141CT2/CT3 Annexure Certificate Master-IND-00Master Files75I: India
79910F75I354QW361Excise ARE3 Tag file for Form Header IND 42Files75I: India
80910F75I357CH474Consignment HeaderFiles75I: India
81910F75I3571CW481Consignment - Work OrdersFiles75I: India
82910F75I3572CS511Consignment - Stock TransfersFiles75I: India
83910F75I3573CO532Consignment - Order ItemsFiles75I: India
84910F75I3574CT623Consignment - Issues/Receipts TransactionsFiles75I: India
85910F75I3575CP451Consignment - Work Order Part List Items - BalancesFiles75I: India
86910F75I3576SW492Stock Transfer - Work OrdersFiles75I: India
87910F75I380RG875Excise - RG-1 - Transaction File - INDFiles75I: India
88910F75I382IP211Amount of Interest Paid per month - IND - 00Files75I: India
89910F75I385ED391RG23D Register - Issues - IND - 42Files75I: India
90910F75I390ER151Work With Excise ReportsFiles75I: India
91910F75I3901CO782Work With Consignment - IND -43Files75I: India
92910F75I395AER351ER - 5 (1)Files75I: India
93910F75I395BER531ER - 5 (2)Files75I: India
94910F75I395TER541ER - 5 (temp)Files75I: India
95910F75I396AES361ER-6 - List of Finished goods manufacturedFiles75I: India
96910F75I396BSE581ER-6Files75I: India
97910F75I396COB311Table for Opening Balance QuantityFiles75I: India
98910F75I396TSE571ER-6 TempFiles75I: India
99910F75I397SC321ER-6 ScrapFiles75I: India
100910F75I397BES371ER-6 ScrapFiles75I: India
101910F75I401QA343Sales Form Information-IND-42Master Files75I: India
102910F75I401CQA341Sales Form Information- SecondaryMaster Files75I: India
103910F75I402PT583Purchase Tax Form DetailsFiles75I: India
104910F75I402TPT581Purchase Tax Form Details -SecondaryFiles75I: India
105910F75I403AB371Stock Transfer DetailsFiles75I: India
106910F75I403TAB371Temp Data for F75i403Files75I: India
107910F75I404CP221Consolidated tax paymentFiles75I: India
108910F75I405DP222Deferred Input Tax CreditFiles75I: India
109910F75I406SB291State / Branch Plant Cross ReferenceFiles75I: India
110910F75I407IC311Item Category RelationshipFiles75I: India
111910F75I4074AL211Price Adj Ledger Tag File - 03BFiles75I: India
112910F75I408VC271VAT/CST Account MasterFiles75I: India
113910F75I409VS281Personal Consumption - VAT setoff - IND - 41Files75I: India
114910F75I411TF192F0411 Tag File - IN - 04Files75I: India
115910F75I421MA111Assign Price / Cost ElementsFiles75I: India
116910F75I4210FT161Sales Form Tracking - SecondaryFiles75I: India
117910F75I4213SO321Setoff Report Data -IND -00Files75I: India
118910F75I4216AB71Set Off Amount -INDFiles75I: India
119910F75I4223SD581Sales Tax Summary/DetailFiles75I: India
120910F75I4231PT291Purchase Tax Summary / DetailsFiles75I: India
121910F75I601TR332TCS Register Details-IND-42Files75I: India
122910F75I602IB302Item Branch Tagfile - IND - 41Files75I: India
123910F75I603TM141TCS Prepayment Master File - IND-03BFiles75I: India
124910F75I604TP231TCS Payment DetailsFiles75I: India
125910F75I605TA121TCS Tax AmountFiles75I: India
126910F75I611TT394TCS Prepayment Transaction File - IND-03BFiles75I: India
127910F75I612TP232TCS Prepayment To Tax AuthorityFiles75I: India
128910F75I701QH1074Bill of Entry - HeaderFiles75I: India
129910F75I704CR71Service Tax Cross Reference File - INDFiles75I: India
130910F75I731ST252Service Tax A/R File - IND - 03BFiles75I: India
131910F75I732ST181Service Tax A/R File Additional Info - IND - 03BFiles75I: India
132910F75I734PF81Service Tax Received File - IND - 03BFiles75I: India
133910F75I735ST412Order Detail by Service Category Code - IND - 75IFiles75I: India
134910F75I741ST282Service Tax A/P File - IND - 04Files75I: India
135910F75I742ST191Service Tax A/P File Additional Info - IND - 04Files75I: India
136910F75I744PF81Service Tax Payment File - IND - 04Files75I: India
137910F75I750CE222Service Tax Cenvat File -09 - INDFiles75I: India
138910F75I754AP131Advance Service Tax Payment File - IND -04Files75I: India
139910F75I760AB261Advance Service Tax Balance File - INDFiles75I: India
140910F75I790WT61Form ST-3 Working Table - IND - 09Files75I: India
141910F75I790TSF141ST-3 Section 5A - 5AA and 5B Setup fileFiles75I: India
142910F75I791IS293Item - Supplier Cost Components - IND - 43BMaster Files75I: India
143910F75IEXCQZ71Excise Balance File lockMaster Files75I: India
144910F75IUI01TW211eTCS Anuual Return - Work FileFiles75I: India
145910F75IUI7WF241Service Tax Credit Register - Work File - INDFiles75I: India