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

36 tables920 | 48S

48S: Service Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F48011WG296Service Billing Batch ControlBatch Input Files48S: Service BillingBusiness Data
2920F4805WK71Invoice Sequence/Summarization Table HeaderExtra Features Files48S: Service BillingBusiness Data
3920F48051WK102Invoice Sequence/Summarization Table DetailExtra Features Files48S: Service BillingBusiness Data
4920F48091WZ421Billing System ConstantsConstants Files48S: Service BillingBusiness Data
5920F48091CCE61Independent Revenue/Invoice Company ExceptionConstants Files48S: Service Billing
6920F48096WQ3710Billing Rate / Mark up TableExtra Features Files48S: Service BillingBusiness Data
7920F4812WD20328Billing Detail WorkfileTransaction Files48S: Service BillingBusiness Data
8920F48121WY151Generation Control File - Service BillingExtra Features Files48S: Service BillingBusiness Data
9920F48127WO205Tax Derivation InformationExtra Features Files48S: Service BillingBusiness Data
10920F48128WI131G/L Offset and Retainage InformationExtra Features Files48S: Service BillingBusiness Data
11920F4812HWD20322Billing Workfile HistoryHistory Files48S: Service BillingBusiness Data
12920F4812HSWD20320Billing Workfile History Purged SaveHistory Files48S: Service BillingBusiness Data
13920F4822W411213Invoice Summary Work FileTransaction Files48S: Service Billing
14920F48221WH192Service Billing Retention Release Cross Reference FileTransaction Files48S: Service BillingBusiness Data
15920F48229W8161Delete Invoices Audit TableHistory Files48S: Service BillingBusiness Data
16920F4823W0757Voucher SummaryTransaction Files48S: Service BillingBusiness Data
17920F48423SD81Service Billing Trigger DateFiles48S: Service Billing
18920F48424ST151Service Billing Trigger HierarchyFiles48S: Service Billing
19920F48426ST221Service Billing Trigger ConfigurationFiles48S: Service Billing
20920F4848SQ31Sequence/Summarization Data Item TableExtra Features Files48S: Service BillingBusiness Data
21920F48520AE2310Invoice Summary AccessFiles48S: Service BillingBusiness Data
22920F4858F792Layout Cross Reference TableExtra Features Files48S: Service BillingBusiness Data
23920F4860AF102Component Table MasterExtra Features Files48S: Service BillingBusiness Data
24920F4861AF134Component Table DetailExtra Features Files48S: Service BillingBusiness Data
25920F4862AF53Component Cross ReferenceExtra Features Files48S: Service BillingBusiness Data
26920F48S001WL71Draft and Final Invoice DocumentSecondary Master Files48S: Service BillingBusiness Data
27920F48S002WM61Draft and Final Cross Reference Work FileSecondary Master Files48S: Service BillingBusiness Data
28920F48S0618YT14725Payroll Reclassification WorkfileRegular Work Files48S: Service BillingBusiness Data
29920F48S411BZ233CSB Pay When Paid TableFiles48S: Service Billing
30920F48S58F7154Invoice Print Version Cross Reference TableExtra Features Files48S: Service BillingBusiness Data
31920F48S910W2884Billing Detail Journal WorkfileWork Files48S: Service BillingBusiness Data
32920F48S911W3524Summarized Journal WorkfileWork Files48S: Service BillingBusiness Data
33920F48S912W6313G/L LinkFiles48S: Service Billing
34920F48S95WV336Billing AAI InformationMaster Files48S: Service BillingBusiness Data
35920F48SUI01WD1992Billing Detail Print WorkfileWork Files48S: Service BillingBusiness Data
36920F48SUI02WD31Load domestic currency code - Billing SystemWork Files48S: Service BillingBusiness Data