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
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

39 tables812 | 48S

48S: Service Billing
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1812F48011WG296Service Billing Batch ControlBatch Input Files48S: Service BillingNo
2812F4805WK71Invoice Sequence/Summarization Table HeaderExtra Features Files48S: Service BillingNo
3812F48051WK102Invoice Sequence/Summarization Table DetailExtra Features Files48S: Service BillingNo
4812F48091WZ351Billing System ConstantsConstants Files48S: Service BillingNo
5812F48096WQ3710Billing Rate / Mark up TableExtra Features Files48S: Service BillingNo
6812F4812WD19928Billing Detail WorkfileTransaction Files48S: Service BillingNo
7812F48121WY151Generation Control File - Service BillingExtra Features Files48S: Service BillingNo
8812F48127WO205Tax Derivation InformationExtra Features Files48S: Service BillingNo
9812F48128WI131G/L Offset and Retainage InformationExtra Features Files48S: Service BillingNo
10812F4812GWD262Retro Adjustment WorkfileFiles48S: Service Billing
11812F4812HWD19921Billing Workfile - HistoryHistory Files48S: Service BillingNo
12812F4812HSWD19920Billing Workfile History Purged SaveHistory Files48S: Service BillingBusiness Data
13812F4822W410411Invoice Summary Work FileTransaction Files48S: Service BillingNo
14812F48221WH192Service Billing Retention Release Cross Reference FileTransaction Files48S: Service BillingNo
15812F48229W8161Delete Invoices Audit TableHistory Files48S: Service BillingAS400 Coexistence Tables
16812F4823W0757Voucher SummaryTransaction Files48S: Service BillingNo
17812F4848SQ31Sequence/Summarization Data Item TableExtra Features Files48S: Service BillingNo
18812F48520AE2310Invoice Summary AccessFiles48S: Service BillingNo
19812F4858F792Layout Cross Reference TableExtra Features Files48S: Service BillingNo
20812F4860AF102Component Table MasterExtra Features Files48S: Service BillingAS400 Coexistence Tables
21812F4861AF134Component Table DetailExtra Features Files48S: Service BillingNo
22812F4862AF53Component Cross ReferenceExtra Features Files48S: Service BillingAS400 Coexistence Tables
23812F48S001WL71Draft and Final Invoice DocumentSecondary Master Files48S: Service BillingBusiness Data
24812F48S002WM61Draft and Final Cross Reference Work FileSecondary Master Files48S: Service BillingBusiness Data
25812F48S0618YT12925Payroll Reclassification WorkfileRegular Work Files48: Work Order ProcessingNo
26812F48S411BZ233CSB Pay When Paid TableFiles48S: Service Billing
27812F48S58F7154Invoice Print Version Cross Reference TableExtra Features Files48S: Service BillingNo
28812F48S80SD123Segment DefinitionFiles48S: Service Billing
29812F48S81CM111Burden Computation MethodFiles48S: Service Billing
30812F48S82BR193Burden Base RulesFiles48S: Service Billing
31812F48S83PD112Pool DefinitionFiles48S: Service Billing
32812F48S84PG103Pool Grouping CodesFiles48S: Service Billing
33812F48S85RT132Burden RatesFiles48S: Service Billing
34812F48S910W2883Billing Detail Journal FileWork Files48S: Service BillingNo
35812F48S911W3514Compressed Journal FileWork Files48S: Service BillingNo
36812F48S912W6313G/L Link FileFiles48S: Service BillingNo
37812F48S95WV336Billing AAI InformationMaster Files48S: Service BillingNo
38812F48SUI01WD1952Billing Detail Print WorkfileWork Files48S: Service BillingNo
39812F48SUI02WD31Load domestic currency code - Billing SystemWork Files48S: Service BillingNo