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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

33 tables910 | 48S

48S: Service Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1910F48011WG296Service Billing Batch ControlBatch Input Files48S: Service BillingBusiness Data
2910F4805WK71Invoice Sequence/Summarization Table HeaderExtra Features Files48S: Service BillingBusiness Data
3910F48051WK102Invoice Sequence/Summarization Table DetailExtra Features Files48S: Service BillingBusiness Data
4910F48091WZ421Billing System ConstantsConstants Files48S: Service BillingBusiness Data
5910F48091CCE61Independent Revenue/Invoice Company ExceptionConstants Files48S: Service Billing
6910F48096WQ3710Billing Rate / Mark up TableExtra Features Files48S: Service BillingBusiness Data
7910F4812WD20328Billing Detail WorkfileTransaction Files48S: Service BillingBusiness Data
8910F48121WY151Generation Control File - Service BillingExtra Features Files48S: Service BillingBusiness Data
9910F48127WO205Tax Derivation InformationExtra Features Files48S: Service BillingBusiness Data
10910F48128WI131G/L Offset and Retainage InformationExtra Features Files48S: Service BillingBusiness Data
11910F4812HWD20322Billing Workfile HistoryHistory Files48S: Service BillingBusiness Data
12910F4812HSWD20320Billing Workfile History Purged SaveHistory Files48S: Service BillingBusiness Data
13910F4822W411213Invoice Summary Work FileTransaction Files48S: Service Billing
14910F48221WH192Service Billing Retention Release Cross Reference FileTransaction Files48S: Service BillingBusiness Data
15910F48229W8161Delete Invoices Audit TableHistory Files48S: Service BillingBusiness Data
16910F4823W0757Voucher SummaryTransaction Files48S: Service BillingBusiness Data
17910F4848SQ31Sequence/Summarization Data Item TableExtra Features Files48S: Service BillingBusiness Data
18910F48520AE2310Invoice Summary AccessFiles48S: Service BillingBusiness Data
19910F4858F792Layout Cross Reference TableExtra Features Files48S: Service BillingBusiness Data
20910F4860AF102Component Table MasterExtra Features Files48S: Service BillingBusiness Data
21910F4861AF134Component Table DetailExtra Features Files48S: Service BillingBusiness Data
22910F4862AF53Component Cross ReferenceExtra Features Files48S: Service BillingBusiness Data
23910F48S001WL71Draft and Final Invoice DocumentSecondary Master Files48S: Service BillingBusiness Data
24910F48S002WM61Draft and Final Cross Reference Work FileSecondary Master Files48S: Service BillingBusiness Data
25910F48S0618YT14725Payroll Reclassification WorkfileRegular Work Files48S: Service BillingBusiness Data
26910F48S411BZ233CSB Pay When Paid TableFiles48S: Service Billing
27910F48S58F7154Invoice Print Version Cross Reference TableExtra Features Files48S: Service BillingBusiness Data
28910F48S910W2884Billing Detail Journal WorkfileWork Files48S: Service BillingBusiness Data
29910F48S911W3524Summarized Journal WorkfileWork Files48S: Service BillingBusiness Data
30910F48S912W6313G/L LinkFiles48S: Service Billing
31910F48S95WV336Billing AAI InformationMaster Files48S: Service BillingBusiness Data
32910F48SUI01WD1992Billing Detail Print WorkfileWork Files48S: Service BillingBusiness Data
33910F48SUI02WD31Load domestic currency code - Billing SystemWork Files48S: Service BillingBusiness Data