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

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