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

184 columns | Print definition?920 | GLC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger34GLGLCG/L OffsetStringGeneric Edit40
TOP03: Accounts Receivable
2F0311Accounts Receivable Ledger44RPGLCG/L OffsetStringGeneric Edit40
TOP03B: Enhanced Accounts Receivable
3F03B11Customer Ledger15RPGLCG/L OffsetStringGeneric Edit40
4F03B112Invoice Revisions24RWGLCG/L OffsetStringGeneric Edit40
5F03B112PInvoice Revisions Purge File24RWGLCG/L OffsetStringGeneric Edit40
6F03B117Revenue Recognition GL Info30RLGLCG/L OffsetStringGeneric Edit40
7F03B119Revenue Recognition GL Info Audit18RNGLCG/L OffsetStringGeneric Edit40
8F03B11PCustomer Ledger Purge File15RPGLCG/L OffsetStringGeneric Edit40
9F03B11Z1Batch Invoices33VJGLCG/L OffsetStringGeneric Edit40
10F03B11Z2F03B11 Interoperability Table28SYGLCG/L OffsetStringGeneric Edit40
11F03B13Receipts Header12RYGLCG/L OffsetStringGeneric Edit40
12F03B13PReceipts Header Purge File12RYGLCG/L OffsetStringGeneric Edit40
13F03B13Z2F03B13 Interoperability Table25SYGLCG/L OffsetStringGeneric Edit40
14F03B14Receipts Detail13RZGLCG/L OffsetStringGeneric Edit40
15F03B14PReceipts Detail Purge File13RZGLCG/L OffsetStringGeneric Edit40
16F03B14Z2F03B14 Interoperability Table26SZGLCG/L OffsetStringGeneric Edit40
17F03B41A/R Deduction Activity16RCGLCG/L OffsetStringGeneric Edit40
18F03B465A/R Netting Workfile21ROGLCG/L OffsetStringGeneric Edit40
19F03B575Auto Debit Invoice Select and Build18RDGLCG/L OffsetStringGeneric Edit40
20F03B672Draft Remittance15RDGLCG/L OffsetStringGeneric Edit40
21F09UI011Receipt Prepost Work File26GLGLCG/L OffsetStringGeneric Edit40
TOP04: Accounts Payable
22F0411Accounts Payable Ledger43RPGLCG/L OffsetStringGeneric Edit40
23F0411AWF - 'As Of' Accounts Payable Ledger43RPGLCG/L OffsetStringGeneric Edit40
24F0411PPurge - Accounts Payable Ledger43RPGLCG/L OffsetStringGeneric Edit40
25F0411Z1Voucher Transactions - Batch Upload61VLGLCG/L OffsetStringGeneric Edit40
26F0411Z3F0411 Interoperability Table66SZGLCG/L OffsetStringGeneric Edit40
27F0414Accounts Payable Matching Document Detail18RNGLCG/L OffsetStringGeneric Edit40
28F0414AWF - 'As Of' Accounts Payable Payment Detail18RNGLCG/L OffsetStringGeneric Edit40
29F0414PPurge - Accounts Payable Matching Document Detail18RNGLCG/L OffsetStringGeneric Edit40
30F0414Z1F0414 Interoperability Table31SZGLCG/L OffsetStringGeneric Edit40
31F04573A/P Payment Processing - Detail43KIGLCG/L OffsetStringGeneric Edit40
32F09UI005Tax Offsets User Index16GLGLCG/L OffsetStringGeneric Edit40
TOP07: Payroll
33F06491Payroll/Accounts Payable Ledger Detail17J6GLCG/L OffsetStringGeneric Edit40
34F07491Payroll - Accounts Payable Summary File17J6GLCG/L OffsetStringGeneric Edit40
TOP09: General Accounting
35F0911PPurge - Account Ledger34GLGLCG/L OffsetStringGeneric Edit40
36F0911RWF - Account Ledger Reconciliation31GLGLCG/L OffsetStringGeneric Edit40
37F0911Z1Journal Entry Transactions - Batch File51VNGLCG/L OffsetStringGeneric Edit40
38F0911Z4F0911 Interoperability Table56SZGLCG/L OffsetStringGeneric Edit40
39F0912Cost Allocations/Flex Budgeting20RJGLCG/L OffsetStringGeneric Edit40
40F0912AIndex Computation Entry File16RIGLCG/L OffsetStringGeneric Edit40
41F09UI015Indexed Computations Multi-Tiered Entries34GLGLCG/L OffsetStringGeneric Edit40
TOP15: Real Estate Management
42F15012Tenant E.P. Class Master15NSGLCG/L OffsetStringGeneric Edit40
43F15012BTenant E.P. Class Master17NSGLCG/L OffsetStringGeneric Edit40
44F15013Sales Overage Master52NOGLCG/L OffsetStringGeneric Edit40
45F15013BSales Overage Master File39NOGLCG/L OffsetStringGeneric Edit40
46F15014Product Scales Master12NPGLCG/L OffsetStringGeneric Edit40
47F15014BProduct Scales Master25NPGLCG/L OffsetStringGeneric Edit40
48F15015Minimum rent/recoveries Master8NQGLCG/L OffsetStringGeneric Edit40
49F15015BMin/Max Rents And Recoveries Master17NQGLCG/L OffsetStringGeneric Edit40
50F15016Tenant Escalation Master5NUGLCG/L OffsetStringGeneric Edit40
51F15016BTenant Escalation Master6NUGLCG/L OffsetStringGeneric Edit40
52F1502Recurring Billings Master6NFGLCG/L OffsetStringGeneric Edit40
53F1502BRecurring Billings Master6NFGLCG/L OffsetStringGeneric Edit40
54F1502WABRent Increase Amounts5NFGLCG/L OffsetStringGeneric Edit40
55F1502WBEstimated EP Recurring Billings8N4GLCG/L OffsetStringGeneric Edit40
56F1505Management Fee Master4NDGLCG/L OffsetStringGeneric Edit40
57F1505BManagement Fee Master6NDGLCG/L OffsetStringGeneric Edit40
58F1507Unit Master31NHGLCG/L OffsetStringGeneric Edit40
59F1511Tenant/Lease Billings Detail20NJGLCG/L OffsetStringGeneric Edit40
60F1511BLease Billings Master20NJGLCG/L OffsetStringGeneric Edit40
61F1511HTenant/Lease Billings Detail History20N#GLCG/L OffsetStringGeneric Edit40
62F1511HBLease Billings History20NCGLCG/L OffsetStringGeneric Edit40
63F1512Billing Code Extension1NAGLCG/L OffsetStringGeneric Edit40
64F1512DBilling Code Extension - Alternate Description1NAGLCG/L OffsetStringGeneric Edit40
65F151991G/L Transaction A/R Application Work File7NBGLCG/L OffsetStringGeneric Edit40
66F15199WG/L Transaction Summarization Work File4NBGLCG/L OffsetStringGeneric Edit40
67F1525A/R Fee Interest5N0GLCG/L OffsetStringGeneric Edit40
68F1525BFees and Interest5NMGLCG/L OffsetStringGeneric Edit40
69F1538WF - Expence Participation Register52NZGLCG/L OffsetStringGeneric Edit40
70F1538BEP Billing Register53NZGLCG/L OffsetStringGeneric Edit40
71F1565Security Deposit Master6JFGLCG/L OffsetStringGeneric Edit40
TOP15L: Adv Real Estate Forecasting
72F15L100AREF Building Constants25BCGLCG/L OffsetStringGeneric Edit40
73F15L1001AREF Building Constants Models25BMGLCG/L OffsetStringGeneric Edit40
74F15L112AREF Unit Assumptions Master Detail7ADGLCG/L OffsetStringGeneric Edit40
75F15L114AREF E.P. Rules Detail7EDGLCG/L OffsetStringGeneric Edit40
76F15L116AREF Recurring Bill Code Rules Detail4RDGLCG/L OffsetStringGeneric Edit40
77F15L302AREF Prior Gross Billings15PGGLCG/L OffsetStringGeneric Edit40
78F15L38AREF EP Billing Register57NZGLCG/L OffsetStringGeneric Edit40
79F15L402AREF Tenant Exclusion Rule Audit11SGGLCG/L OffsetStringGeneric Edit40
TOP17: Customer Service Management
80F1721Contract Detail24CDGLCG/L OffsetStringGeneric Edit40
TOP40: Inventory/OP Base
81F4011ZBatch Receiver File - Order Details168SZGLCG/L OffsetStringGeneric Edit40
82F40205Line Type Control Constants File14LFGLCG/L OffsetStringGeneric Edit40
83F40350Preference Profiles - Conatiner Deposit/Rental16OQGLCG/L OffsetStringGeneric Edit40
84F40500Commodity Structure Definitions8CCGLCG/L OffsetStringGeneric Edit40
85F40UI74Price Adjustment History Work File31AWGLCG/L OffsetStringGeneric Edit40
86F4211Z1Sales Order Detail Unedited Transaction File154SZGLCG/L OffsetStringGeneric Edit40
TOP41: Inventory Management
87F41181Container Transaction File25CMGLCG/L OffsetStringGeneric Edit40
88F41291ZLanded Cost Cache Table15IGGLCG/L OffsetStringGeneric Edit40
TOP42: Sales Management
89F4074Price Adjustment Ledger File25ALGLCG/L OffsetStringGeneric Edit40
90F4211Sales Order Detail File141SDGLCG/L OffsetStringGeneric Edit40
91F42119Sales Order History File141SDGLCG/L OffsetStringGeneric Edit40
92F42199S.O. Detail Ledger File141SLGLCG/L OffsetStringGeneric Edit40
93F42800G1Sales Update G Batch Detail Workfile87DGGLCG/L OffsetStringGeneric Edit40
94F42UI12Sales Order Detail Cache 2 (MBF)54ZDGLCG/L OffsetStringGeneric Edit40
95F42UI800Sales Detail Work File - Sales Update53SDGLCG/L OffsetStringGeneric Edit40
TOP43: Procurement
96F41291Item Cost Components15IGGLCG/L OffsetStringGeneric Edit40
97F43080Approvals Fields Constants119PDGLCG/L OffsetStringGeneric Edit40
98F4311Purchase Order Detail File115PDGLCG/L OffsetStringGeneric Edit40
99F4311ZPurchase Order Generator File119PWGLCG/L OffsetStringGeneric Edit40
100F4311Z1Purchase Order Detail Unedited Transaction Table128SZGLCG/L OffsetStringGeneric Edit40
101F43121Purchase Order Receiver File44PRGLCG/L OffsetStringGeneric Edit40
102F43121ZReceiver workfile32PWGLCG/L OffsetStringGeneric Edit40
103F43121Z1Receipts Unedited Transaction Table61SZGLCG/L OffsetStringGeneric Edit40
104F4314ZVoucher Match Selection File143PNGLCG/L OffsetStringGeneric Edit40
105F43199P.O. Detail Ledger File - Flexible Version115OLGLCG/L OffsetStringGeneric Edit40
106F4340Purchase Rebate Master File14RDGLCG/L OffsetStringGeneric Edit40
TOP43E: Requisition Self Service
107F43E11Requisition Detail32RDGLCG/L OffsetStringGeneric Edit40
TOP44H: Homebuilder Management
108F44H611Bid Details57BDGLCG/L OffsetStringGeneric Edit40
109F44H611WBid Details Work File61BWGLCG/L OffsetStringGeneric Edit40
110F44H711Lot Start Workfile65SWGLCG/L OffsetStringGeneric Edit40
111F44H711ZHB Lot Start Unedited Transaction File78SZGLCG/L OffsetStringGeneric Edit40
112F44H71W1Lot Start Generation Workfile65GWGLCG/L OffsetStringGeneric Edit40
113F44H73W1Lot Start - P.O. / Committment Generation Work File42CGGLCG/L OffsetStringGeneric Edit40
TOP45: Advanced Pricing
114F4071Price Adjustment Type7ATGLCG/L OffsetStringGeneric Edit40
115F4071PPrice Adjustment Type Purge8ATGLCG/L OffsetStringGeneric Edit40
116F4073Free Goods Master File10FGGLCG/L OffsetStringGeneric Edit40
117F4073PFree Goods Master File Purge11FGGLCG/L OffsetStringGeneric Edit40
118F4511WPricing Structure View12APGLCG/L OffsetStringGeneric Edit40
119F4575Ship and Debit History27AHGLCG/L OffsetStringGeneric Edit40
120F4575TMPShip and Debit History - Temp Table27AHGLCG/L OffsetStringGeneric Edit40
121F4576Z1Ship and Debit Claims Unedited Transaction Table112Z1GLCG/L OffsetStringGeneric Edit40
TOP47: Electronic Commerce
122F47012EDI Purchase Order Detail - Inbound169SZGLCG/L OffsetStringGeneric Edit40
123F47017EDI Purchase Order Detail - Outbound129SZGLCG/L OffsetStringGeneric Edit40
124F47022EDI P.O. Acknowledgment Detail - Inbound129SZGLCG/L OffsetStringGeneric Edit40
125F47027EDI P.O. Acknowledgment Detail - Outbound169SZGLCG/L OffsetStringGeneric Edit40
126F47037EDI Shipping Notice Detail - Outbound147SZGLCG/L OffsetStringGeneric Edit40
127F470371EDI Shipping Notice Detail - Outbound167SZGLCG/L OffsetStringGeneric Edit40
128F47047EDI Invoice Detail (Sales) - Outbound169SZGLCG/L OffsetStringGeneric Edit40
129F47057EDI Payment Order Remittance Advice - Outbound93D3GLCG/L OffsetStringGeneric Edit40
130F47057WEDI Payment Order Remittance Advice - Work93D3GLCG/L OffsetStringGeneric Edit40
131F47072EDI Receiving Advice Detail - Inbound130SZGLCG/L OffsetStringGeneric Edit40
132F47077EDI Receiving Advice Detail - Outbound130SZGLCG/L OffsetStringGeneric Edit40
133F47092EDI Request for Quote Detail - Inbound169SZGLCG/L OffsetStringGeneric Edit40
134F47097EDI Request for Quote Detail - Outbound129SZGLCG/L OffsetStringGeneric Edit40
135F47102EDI Response to RFQ Detail - Inbound129SZGLCG/L OffsetStringGeneric Edit40
136F47107EDI Response to RFQ Detail - Outbound169SZGLCG/L OffsetStringGeneric Edit40
137F47132EDI Purchase Order Change Detail - Inbound170SZGLCG/L OffsetStringGeneric Edit40
138F47137EDI Purchase Order Change Detail - Outbound130SZGLCG/L OffsetStringGeneric Edit40
139F47142EDI P.O. Change Acknowledgment Detail - Inbound131SZGLCG/L OffsetStringGeneric Edit40
140F47147EDI P.O. Change Acknowledgment Detail - Outbound171SZGLCG/L OffsetStringGeneric Edit40
141F47157EDI Shipping Schedule Detail - Outbound138SZGLCG/L OffsetStringGeneric Edit40
TOP48S: Service Billing
142F4812Billing Detail Workfile140WDGLCG/L OffsetStringGeneric Edit40
143F48128G/L Offset and Retainage Information4WIGLCG/L OffsetStringGeneric Edit40
144F4812HBilling Workfile History140WDGLCG/L OffsetStringGeneric Edit40
145F4812HSBilling Workfile History Purged Save140WDGLCG/L OffsetStringGeneric Edit40
146F4822Invoice Summary Work File21W4GLCG/L OffsetStringGeneric Edit40
147F4823Voucher Summary19W0GLCG/L OffsetStringGeneric Edit40
148F48S910Billing Detail Journal Workfile27W2GLCG/L OffsetStringGeneric Edit40
149F48S911Summarized Journal Workfile33W3GLCG/L OffsetStringGeneric Edit40
150F48S95Billing AAI Information12WVGLCG/L OffsetStringGeneric Edit40
151F48SUI01Billing Detail Print Workfile140WDGLCG/L OffsetStringGeneric Edit40
TOP49: Transportation Management
152F49004Mode of Transport Constants10CTGLCG/L OffsetStringGeneric Edit40
153F4978Charge Code Definitions2CGGLCG/L OffsetStringGeneric Edit40
TOP52: Contract Billing
154F5202Contract Billing Line Detail23G6GLCG/L OffsetStringGeneric Edit40
TOP52G: Proj & Gov Contract Accounting
155F4822HInvoice Summary History21IHGLCG/L OffsetStringGeneric Edit40
TOP74: EMEA Localization
156F74412Customer / Supplier Balance Worktable (A/P and A/R)6RPGLCG/L OffsetStringGeneric Edit40
157F74900Foreign Receivables and Payables - EMEA21RPGLCG/L OffsetStringGeneric Edit40
TOP74R: Russia
158F74R202Transit VAT Account Setup - RUS - 421TAGLCG/L OffsetStringGeneric Edit40
159F74R410Tax on Hold - RUS - 0418THGLCG/L OffsetStringGeneric Edit40
TOP74U: United Kingdom Localizations
160F74U0420SPC - Application Master - UK - 4320SEGLCG/L OffsetStringGeneric Edit40
161F74U0425SPC - Certificate Master - UK - 4321SFGLCG/L OffsetStringGeneric Edit40
162F74U25BTInterest Tag Table - 155PKGLCG/L OffsetStringGeneric Edit40
163F74U4312SPC - Purchase Order Additional Information - UK - 4326SCGLCG/L OffsetStringGeneric Edit40
164F74U4316SPC - Purchase Order Line Additional Information - UK - 4336SCGLCG/L OffsetStringGeneric Edit40
TOP74Y: Italy
165F743B14ISuspended IVA Generation - Receipt/Rebate Control-Ita - 03B23TIGLCG/L OffsetStringGeneric Edit40
TOP75I: India
166F75I101TDS Certificate Work Maintenance51QBGLCG/L OffsetStringGeneric Edit40
167F75I10ATDS Rate Maintenance File11QAGLCG/L OffsetStringGeneric Edit40
168F75I15ATDS Document Company Maintenance File10QCGLCG/L OffsetStringGeneric Edit40
169F75I731Service Tax A/R File - IND - 03B6STGLCG/L OffsetStringGeneric Edit40
170F75I741Service Tax A/P File - IND - 047STGLCG/L OffsetStringGeneric Edit40
171F75I791Item/Supplier Cost Components - IND - 43B16ISGLCG/L OffsetStringGeneric Edit40
TOP75T: Taiwan
172F75T42WWork file with union of F4211 and F4211932SWGLCG/L OffsetStringGeneric Edit40
TOP76A: Argentina
173F76A10Taxes - Tax Definition - ARG - 00 - 76A2TDGLCG/L OffsetStringGeneric Edit40
174F76AUI81Draft - Invoices Work File - ARG - 03B - 76A23WFGLCG/L OffsetStringGeneric Edit40
TOP76B: Brazil
175F7611BNota Fiscal Detail - BRA - 4240FDGLCG/L OffsetStringGeneric Edit40
176F761BAAS Fiscal file book - 0943FBGLCG/L OffsetStringGeneric Edit40
177F76B0401Tax Code - 049CTGLCG/L OffsetStringGeneric Edit40
178F76B0411Voucher Additional Information Brazil - 0418VBGLCG/L OffsetStringGeneric Edit40
179F76B409Taxes Setup by City and Service - BR - 047CSGLCG/L OffsetStringGeneric Edit40
180F76B473TF04573 Brazilian Temp WH File - BR - 0422W3GLCG/L OffsetStringGeneric Edit40
TOP76C: Colombia
181F76C031AA/R Customer ledger As Of - F76C031A - COL - 0415RPGLCG/L OffsetStringGeneric Edit40
182F76C034AA/R Check Detail file As Of - COL - 03B13RZGLCG/L OffsetStringGeneric Edit40
TOP76H: Chile
183F76HUI52Document Selection Work File - CHI - 42 - 76H12DRGLCG/L OffsetStringGeneric Edit40
TOP89: Conversion Programs
184F43199ATemp F43199 for ERP 9.0 Upgrade115OLGLCG/L OffsetStringGeneric Edit40