JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
6F4102IBItem Branch File
7F0411RPAccounts Payable Ledger
8F41021LIItem Location File
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F4211SDSales Order Detail File
3F4101IMItem Master
4F0101ABAddress Book Master
5F0911GLAccount Ledger
6F4102IBItem Branch File
7F4311PDPurchase Order Detail File
8F03B11RPCustomer Ledger
9F0411RPAccounts Payable Ledger
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

92 columns | Print definition?920 | DSVJ

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Taxes21TDDSVJDate - Service/TaxDateGeneric Edit60
2F0911Account Ledger96GLDSVJDate - Service/TaxDateGeneric Edit60
TOP03: Accounts Receivable
3F0311Accounts Receivable Ledger43RPDSVJDate - Service/TaxDateGeneric Edit60
TOP03B: Enhanced Accounts Receivable
4F03B11Customer Ledger45RPDSVJDate - Service/TaxDateGeneric Edit60
5F03B112Invoice Revisions48RWDSVJDate - Service/TaxDateGeneric Edit60
6F03B112PInvoice Revisions Purge File48RWDSVJDate - Service/TaxDateGeneric Edit60
7F03B117Revenue Recognition GL Info65RLDSVJDate - Service/TaxDateGeneric Edit60
8F03B119Revenue Recognition GL Info Audit65RNDSVJDate - Service/TaxDateGeneric Edit60
9F03B11PCustomer Ledger Purge File45RPDSVJDate - Service/TaxDateGeneric Edit60
10F03B11Z1Batch Invoices62VJDSVJDate - Service/TaxDateGeneric Edit60
11F03B11Z2F03B11 Interoperability Table58SYDSVJDate - Service/TaxDateGeneric Edit60
12F03B465A/R Netting Workfile17RODSVJDate - Service/TaxDateGeneric Edit60
13F03B575Auto Debit Invoice Select and Build54RDDSVJDate - Service/TaxDateGeneric Edit60
14F09UI011Receipt Prepost Work File36GLDSVJDate - Service/TaxDateGeneric Edit60
TOP04: Accounts Payable
15F0411Accounts Payable Ledger11RPDSVJDate - Service/TaxDateGeneric Edit60
16F0411AWF - 'As Of' Accounts Payable Ledger11RPDSVJDate - Service/TaxDateGeneric Edit60
17F0411PPurge - Accounts Payable Ledger11RPDSVJDate - Service/TaxDateGeneric Edit60
18F0411Z1Voucher Transactions - Batch Upload29VLDSVJDate - Service/TaxDateGeneric Edit60
19F0411Z3F0411 Interoperability Table33SZDSVJDate - Service/TaxDateGeneric Edit60
20F09UI005Tax Offsets User Index2GLDSVJDate - Service/TaxDateGeneric Edit60
21F09UI006Tax (F0018) Replica21TDDSVJDate - Service/TaxDateGeneric Edit60
TOP09: General Accounting
22F0911PPurge - Account Ledger96GLDSVJDate - Service/TaxDateGeneric Edit60
23F0911RWF - Account Ledger Reconciliation54GLDSVJDate - Service/TaxDateGeneric Edit60
24F0911Z1Journal Entry Transactions - Batch File113VNDSVJDate - Service/TaxDateGeneric Edit60
25F0911Z4F0911 Interoperability Table118SZDSVJDate - Service/TaxDateGeneric Edit60
26F0912Cost Allocations/Flex Budgeting28RJDSVJDate - Service/TaxDateGeneric Edit60
27F0912AIndex Computation Entry File24RIDSVJDate - Service/TaxDateGeneric Edit60
28F09UI015Indexed Computations Multi-Tiered Entries96GLDSVJDate - Service/TaxDateGeneric Edit60
29F52G11Burdening Detail Ledger36BDDSVJDate - Service/TaxDateGeneric Edit60
30F52G11WFTemporary Burdened Detail Ledger Workfile36BWDSVJDate - Service/TaxDateGeneric Edit60
TOP12: Fixed Assets
31F1205Equipment Messages14FTDSVJDate - Service/TaxDateGeneric Edit60
32F1205PEquipment Messages Purge Table14FTDSVJDate - Service/TaxDateGeneric Edit60
TOP15: Real Estate Management
33F151991G/L Transaction A/R Application Work File14NBDSVJDate - Service/TaxDateGeneric Edit60
TOP42: Sales Management
34F42800G1Sales Update G Batch Detail Workfile24DGDSVJDate - Service/TaxDateGeneric Edit60
TOP43: Procurement
35F43080Approvals Fields Constants38PDDSVJDate - Service/TaxDateGeneric Edit60
36F4311Purchase Order Detail File30PDDSVJDate - Service/TaxDateGeneric Edit60
37F4311ZPurchase Order Generator File34PWDSVJDate - Service/TaxDateGeneric Edit60
38F4311Z1Purchase Order Detail Unedited Transaction Table43SZDSVJDate - Service/TaxDateGeneric Edit60
39F43199P.O. Detail Ledger File - Flexible Version30OLDSVJDate - Service/TaxDateGeneric Edit60
TOP47: Electronic Commerce
40F470161EDI Purchase Order Additional Header - Outbound58S3DSVJDate - Service/TaxDateGeneric Edit60
41F47017EDI Purchase Order Detail - Outbound43SZDSVJDate - Service/TaxDateGeneric Edit60
42F470171EDI Purchase Order Additional Detail - Outbound40S4DSVJDate - Service/TaxDateGeneric Edit60
43F47022EDI P.O. Acknowledgment Detail - Inbound43SZDSVJDate - Service/TaxDateGeneric Edit60
44F47032EDI Shipping Notice Detail - Inbound43SZDSVJDate - Service/TaxDateGeneric Edit60
45F470461EDI Invoice Additional Header - Outbound59S3DSVJDate - Service/TaxDateGeneric Edit60
46F470471EDI Invoice Additional Detail - Outbound43S4DSVJDate - Service/TaxDateGeneric Edit60
47F47057EDI Payment Order Remittance Advice - Outbound42D3DSVJDate - Service/TaxDateGeneric Edit60
48F47057WEDI Payment Order Remittance Advice - Work42D3DSVJDate - Service/TaxDateGeneric Edit60
49F47072EDI Receiving Advice Detail - Inbound44SZDSVJDate - Service/TaxDateGeneric Edit60
50F47077EDI Receiving Advice Detail - Outbound44SZDSVJDate - Service/TaxDateGeneric Edit60
51F47097EDI Request for Quote Detail - Outbound43SZDSVJDate - Service/TaxDateGeneric Edit60
52F47102EDI Response to RFQ Detail - Inbound43SZDSVJDate - Service/TaxDateGeneric Edit60
53F471061EDI Response to RFQ Additional Header - Outbound59S3DSVJDate - Service/TaxDateGeneric Edit60
54F471071EDI Response to RFQ Additional Detail - Outbound43S4DSVJDate - Service/TaxDateGeneric Edit60
55F47137EDI Purchase Order Change Detail - Outbound44SZDSVJDate - Service/TaxDateGeneric Edit60
56F47142EDI P.O. Change Acknowledgment Detail - Inbound45SZDSVJDate - Service/TaxDateGeneric Edit60
57F47157EDI Shipping Schedule Detail - Outbound45SZDSVJDate - Service/TaxDateGeneric Edit60
TOP48S: Service Billing
58F4812Billing Detail Workfile47WDDSVJDate - Service/TaxDateGeneric Edit60
59F4812HBilling Workfile History47WDDSVJDate - Service/TaxDateGeneric Edit60
60F4812HSBilling Workfile History Purged Save47WDDSVJDate - Service/TaxDateGeneric Edit60
61F4822Invoice Summary Work File26W4DSVJDate - Service/TaxDateGeneric Edit60
62F4823Voucher Summary24W0DSVJDate - Service/TaxDateGeneric Edit60
63F48S910Billing Detail Journal Workfile78W2DSVJDate - Service/TaxDateGeneric Edit60
64F48S911Summarized Journal Workfile42W3DSVJDate - Service/TaxDateGeneric Edit60
65F48SUI01Billing Detail Print Workfile47WDDSVJDate - Service/TaxDateGeneric Edit60
TOP52G: Proj & Gov Contract Accounting
66F4822HInvoice Summary History26IHDSVJDate - Service/TaxDateGeneric Edit60
67F52G90Invoice Printing Work Table38WTDSVJDate - Service/TaxDateGeneric Edit60
TOP70: Multi-National Products
68F703030Legal Document Header Tag File - COMM - 03B9H1DSVJDate - Service/TaxDateGeneric Edit60
TOP74: EMEA Localization
69F740018DData extraction ESL - 7419DEDSVJDate - Service/TaxDateGeneric Edit60
70F740018OOriginal Transaction Detail for Data Extraction13OTDSVJDate - Service/TaxDateGeneric Edit60
71F740018WData extraction ESL - Workfile - 7419DEDSVJDate - Service/TaxDateGeneric Edit60
72F74093Worktable for Printing IVA Summary - Italy20HCDSVJDate - Service/TaxDateGeneric Edit60
73F74900Foreign Receivables and Payables - EMEA52RPDSVJDate - Service/TaxDateGeneric Edit60
TOP74H: Hungary
74F74H410Foreign Voucher Supplier Amounts - HUN - 74H9SADSVJDate - Service/TaxDateGeneric Edit60
TOP74R: Russia
75F74R0018Russian Tax File - 74R13TDDSVJDate - Service/TaxDateGeneric Edit60
76F74R4500Paymet Order Supplemental Data - RU - 04 - 74R15PODSVJDate - Service/TaxDateGeneric Edit60
TOP74U: United Kingdom Localizations
77F74U0405SPC Certificate Holding Table - UK - 439CHDSVJDate - Service/TaxDateGeneric Edit60
78F74U0420SPC - Application Master - UK - 4323SEDSVJDate - Service/TaxDateGeneric Edit60
79F74U0421Application Approval Invoice Overrides6IODSVJDate - Service/TaxDateGeneric Edit60
80F74U0425SPC - Certificate Master - UK - 4324SFDSVJDate - Service/TaxDateGeneric Edit60
TOP74Z: Czech Republic
81F74ZUI02Czech VAT Report - CZE - 74Z - Work File14CZDSVJDate - Service/TaxDateGeneric Edit60
TOP75C: China
82F75C010WAP & AR XML Workfile - China -75C32AADSVJDate - Service/TaxDateGeneric Edit60
TOP75I: India
83F75I100QTDS Form 26Q - WorkFile (Quarterly)37EFDSVJDate - Service/TaxDateGeneric Edit60
84F75I100WTDS Form 26 - WorkFile27EFDSVJDate - Service/TaxDateGeneric Edit60
TOP76A: Argentina
85F76A09Invoice Total - ARG - 03B - 76A30TTDSVJDate - Service/TaxDateGeneric Edit60
86F76A09PInvoice Total Purge - ARG - 03B - 76A30TTDSVJDate - Service/TaxDateGeneric Edit60
87F76A8001Generation SICORE's - Last Step -RG 738/99 - ARG - 04 - 76A11V2DSVJDate - Service/TaxDateGeneric Edit60
TOP76C: Colombia
88F76C031AA/R Customer ledger As Of - F76C031A - COL - 0444RPDSVJDate - Service/TaxDateGeneric Edit60
89F76C575Work File Magnetic Media - COL - 0414Q1DSVJDate - Service/TaxDateGeneric Edit60
90F76CT1Tributary Information - COL - 76C13TIDSVJDate - Service/TaxDateGeneric Edit60
91F76CT2Sales/Use/V.A.T. Tax File - COL - 76C13CTDSVJDate - Service/TaxDateGeneric Edit60
TOP89: Conversion Programs
92F43199ATemp F43199 for ERP 9.0 Upgrade30OLDSVJDate - Service/TaxDateGeneric Edit60