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

164 columns | Print definition?812 | 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
6F03B11PCustomer Ledger Purge File15RPGLCG/L OffsetStringGeneric Edit40
7F03B11Z1Invoice Transactions - Batch File33VJGLCG/L OffsetStringGeneric Edit40
8F03B11Z2F03B11 Interoperability Table28SYGLCG/L OffsetStringGeneric Edit40
9F03B13Receipts Header File12RYGLCG/L OffsetStringGeneric Edit40
10F03B13PReceipts Header Purge File12RYGLCG/L OffsetStringGeneric Edit40
11F03B13Z2F03B13 Interoperability Table25SYGLCG/L OffsetStringGeneric Edit40
12F03B14A/R Check Detail File13RZGLCG/L OffsetStringGeneric Edit40
13F03B14PReceipts Detail Purge File13RZGLCG/L OffsetStringGeneric Edit40
14F03B14Z2F03B14 Interoperability Table26SZGLCG/L OffsetStringGeneric Edit40
15F03B41A/R Deduction Activity16RCGLCG/L OffsetStringGeneric Edit40
16F03B465A/R Netting Workfile21ROGLCG/L OffsetStringGeneric Edit40
17F03B575Auto Debit Invoice Select and Build18RDGLCG/L OffsetStringGeneric Edit40
18F03B672Draft Remittance Work File - One World Only15RDGLCG/L OffsetStringGeneric Edit40
19F09UI011Receipt Prepost Work File26GLGLCG/L OffsetStringGeneric Edit40
TOP04: Accounts Payable
20F0411Accounts Payable Ledger43RPGLCG/L OffsetStringGeneric Edit40
21F0411AWF - As Of - Accounts Payable Ledger43RPGLCG/L OffsetStringGeneric Edit40
22F0411PPurge - Accounts Payable Ledger43RPGLCG/L OffsetStringGeneric Edit40
23F0411Z1Voucher Transactions - Batch File61VLGLCG/L OffsetStringGeneric Edit40
24F0411Z3F0411 Interoperability Table66SZGLCG/L OffsetStringGeneric Edit40
25F0414Accounts Payable Matching Document Detail18RNGLCG/L OffsetStringGeneric Edit40
26F0414AWF - As Of - Accounts Payable Payment Detail18RNGLCG/L OffsetStringGeneric Edit40
27F0414PPurge - Accounts Payable Matching Document Detail18RNGLCG/L OffsetStringGeneric Edit40
28F0414Z1F0414 Interoperability Table31SZGLCG/L OffsetStringGeneric Edit40
29F04573A/P Payment Processing - Detail File43KIGLCG/L OffsetStringGeneric Edit40
30F09UI005Tax Offsets User Index16GLGLCG/L OffsetStringGeneric Edit40
TOP07: Payroll
31F06491Payroll/Accounts Payable Ledger Detail17J6GLCG/L OffsetStringGeneric Edit40
32F07491Payroll - Accounts Payable Summary File17J6GLCG/L OffsetStringGeneric Edit40
TOP09: General Accounting
33F0911PPurge - Account Ledger34GLGLCG/L OffsetStringGeneric Edit40
34F0911RWF - Acct Ledger File for Reconciliation31GLGLCG/L OffsetStringGeneric Edit40
35F0911Z1Journal Entry Transactions - Batch File51VNGLCG/L OffsetStringGeneric Edit40
36F0911Z4F0911 Interoperability Table56SZGLCG/L OffsetStringGeneric Edit40
37F0912Cost Allocations/Flex Budgeting20RJGLCG/L OffsetStringGeneric Edit40
38F0912AIndex Computation Entry File16RIGLCG/L OffsetStringGeneric Edit40
39F09UI015Indexed Computations Multi-Tiered Entries34GLGLCG/L OffsetStringGeneric Edit40
TOP15: Property Management
40F15012Tenant E.P. Class Master15NSGLCG/L OffsetStringGeneric Edit40
41F15012BTenant E.P. Class Master16NSGLCG/L OffsetStringGeneric Edit40
42F15013Sales Overage Master52NOGLCG/L OffsetStringGeneric Edit40
43F15013BSales Overage Master File39NOGLCG/L OffsetStringGeneric Edit40
44F15014Product Scales Master12NPGLCG/L OffsetStringGeneric Edit40
45F15014BProduct Scales Master25NPGLCG/L OffsetStringGeneric Edit40
46F15015Minimum rent/recoveries Master8NQGLCG/L OffsetStringGeneric Edit40
47F15015BMin/Max Rents And Recoveries Master17NQGLCG/L OffsetStringGeneric Edit40
48F15016Tenant Escalation Master5NUGLCG/L OffsetStringGeneric Edit40
49F15016BTenant Escalation Master6NUGLCG/L OffsetStringGeneric Edit40
50F1502Recurring Billings Master6NFGLCG/L OffsetStringGeneric Edit40
51F1502BRecurring Billings Master6NFGLCG/L OffsetStringGeneric Edit40
52F1502WABRent Increase Amounts5NFGLCG/L OffsetStringGeneric Edit40
53F1502WBEstimated EP Recurring Billing Work File (OneWorld)8N4GLCG/L OffsetStringGeneric Edit40
54F1505Management Fee Master4NDGLCG/L OffsetStringGeneric Edit40
55F1505BManagement Fee Master6NDGLCG/L OffsetStringGeneric Edit40
56F1507Unit Master File31NHGLCG/L OffsetStringGeneric Edit40
57F1511Tenant/Lease Billings Detail20NJGLCG/L OffsetStringGeneric Edit40
58F1511BTenant/Lease Billings Detail Master20NJGLCG/L OffsetStringGeneric Edit40
59F1511HTenant/Lease Billings Detail History20N#GLCG/L OffsetStringGeneric Edit40
60F1511HBTenant/Lease Billings Detail History20NCGLCG/L OffsetStringGeneric Edit40
61F1512Billing Code Extension1NAGLCG/L OffsetStringGeneric Edit40
62F1512DBilling Code Extension - Alternate Description1NAGLCG/L OffsetStringGeneric Edit40
63F151991G/L Transaction A/R Application Work File7NBGLCG/L OffsetStringGeneric Edit40
64F15199WG/L Transaction Summarization Work File4NBGLCG/L OffsetStringGeneric Edit40
65F1525A/R Fee Interest5N0GLCG/L OffsetStringGeneric Edit40
66F1525BA/R Fee and Interest5NMGLCG/L OffsetStringGeneric Edit40
67F1538WF - Expence Participation Register52NZGLCG/L OffsetStringGeneric Edit40
68F1538BEP Billing Register Work File53NZGLCG/L OffsetStringGeneric Edit40
69F1565Security Deposit Master6JFGLCG/L OffsetStringGeneric Edit40
TOP15L: Adv Real Estate Forecasting
70F15L100AREF Building Constants25BCGLCG/L OffsetStringGeneric Edit40
71F15L1001AREF Building Constants Models25BMGLCG/L OffsetStringGeneric Edit40
72F15L112AREF Unit Assumptions Master Detail7ADGLCG/L OffsetStringGeneric Edit40
73F15L114AREF E.P. Rules Detail7EDGLCG/L OffsetStringGeneric Edit40
74F15L116AREF Recurring Bill Code Rules Detail4RDGLCG/L OffsetStringGeneric Edit40
75F15L302AREF Prior Gross Billings15PGGLCG/L OffsetStringGeneric Edit40
76F15L38AREF EP Billing Register56NZGLCG/L OffsetStringGeneric Edit40
TOP17: Customer Service Management
77F1721Contract Detail24CDGLCG/L OffsetStringGeneric Edit40
TOP40: Inventory/OP Base
78F4011ZBatch Receiver File - Order Details168SZGLCG/L OffsetStringGeneric Edit40
79F40205Line Type Control Constants File14LFGLCG/L OffsetStringGeneric Edit40
80F40350Preference Profiles - Conatiner Deposit/Rental16OQGLCG/L OffsetStringGeneric Edit40
81F40500Commodity Structure Definitions8CCGLCG/L OffsetStringGeneric Edit40
82F40UI74Price Adjustment History Work File31AWGLCG/L OffsetStringGeneric Edit40
83F4211Z1Sales Order Detail Unedited Transaction File154SZGLCG/L OffsetStringGeneric Edit40
TOP41: Inventory Management
84F41181Container Transaction File25CMGLCG/L OffsetStringGeneric Edit40
85F41291ZLanded Cost Cache Table15IGGLCG/L OffsetStringGeneric Edit40
TOP42: Sales Management
86F4074Price Adjustment Ledger File25ALGLCG/L OffsetStringGeneric Edit40
87F4211Sales Order Detail File141SDGLCG/L OffsetStringGeneric Edit40
88F42119Sales Order History File141SDGLCG/L OffsetStringGeneric Edit40
89F42199S.O. Detail Ledger File141SLGLCG/L OffsetStringGeneric Edit40
90F42800G1Sales Update G Batch Detail Workfile87DGGLCG/L OffsetStringGeneric Edit40
91F42UI12Sales Order Detail Cache 2 (MBF)54ZDGLCG/L OffsetStringGeneric Edit40
92F42UI800Sales Detail Work File - Sales Update53SDGLCG/L OffsetStringGeneric Edit40
TOP43: Procurement
93F41291Item Cost Components15IGGLCG/L OffsetStringGeneric Edit40
94F43080Approvals Fields Constants119PDGLCG/L OffsetStringGeneric Edit40
95F4311Purchase Order Detail File115PDGLCG/L OffsetStringGeneric Edit40
96F4311ZPurchase Order Generator File119PWGLCG/L OffsetStringGeneric Edit40
97F4311Z1Purchase Order Detail Unedited Transaction Table128SZGLCG/L OffsetStringGeneric Edit40
98F43121Purchase Order Receiver File44PRGLCG/L OffsetStringGeneric Edit40
99F43121ZReceiver workfile32PWGLCG/L OffsetStringGeneric Edit40
100F43121Z1Receipts Unedited Transaction Table61SZGLCG/L OffsetStringGeneric Edit40
101F4314ZVoucher Match Selection File143PNGLCG/L OffsetStringGeneric Edit40
102F43199P.O. Detail Ledger File - Flexible Version115OLGLCG/L OffsetStringGeneric Edit40
103F4340Purchase Rebate Master File14RDGLCG/L OffsetStringGeneric Edit40
TOP43E: Requisition Self Service
104F43E11Requisition Detail32RDGLCG/L OffsetStringGeneric Edit40
TOP44H: Homebuilder Management
105F44H611Bid Details57BDGLCG/L OffsetStringGeneric Edit40
106F44H611WBid Details Work File61BWGLCG/L OffsetStringGeneric Edit40
107F44H711Lot Start Workfile65SWGLCG/L OffsetStringGeneric Edit40
108F44H711ZHB Lot Start Unedited Transaction File78SZGLCG/L OffsetStringGeneric Edit40
109F44H71W1Lot Start Generation Workfile65GWGLCG/L OffsetStringGeneric Edit40
110F44H73W1Lot Start - P.O. / Committment Generation Work File42CGGLCG/L OffsetStringGeneric Edit40
TOP45: Advanced Pricing
111F4071Price Adjustment Type7ATGLCG/L OffsetStringGeneric Edit40
112F4073Free Goods Master File10FGGLCG/L OffsetStringGeneric Edit40
113F4511WPricing Structure View12APGLCG/L OffsetStringGeneric Edit40
114F4575Ship and Debit History27AHGLCG/L OffsetStringGeneric Edit40
115F4575TMPShip and Debit History - Temp Table27AHGLCG/L OffsetStringGeneric Edit40
116F4576Z1Ship and Debit Claims Unedited Transaction Table112Z1GLCG/L OffsetStringGeneric Edit40
TOP47: Electronic Commerce
117F47012EDI Purchase Order Detail - Inbound169SZGLCG/L OffsetStringGeneric Edit40
118F47017EDI Purchase Order Detail - Outbound129SZGLCG/L OffsetStringGeneric Edit40
119F47022EDI P.O. Acknowledgment Detail - Inbound129SZGLCG/L OffsetStringGeneric Edit40
120F47027EDI P.O. Acknowledgment Detail - Outbound169SZGLCG/L OffsetStringGeneric Edit40
121F47037EDI Shipping Notice Detail - Outbound147SZGLCG/L OffsetStringGeneric Edit40
122F470371EDI Shipping Notice Detail - Outbound167SZGLCG/L OffsetStringGeneric Edit40
123F47047EDI Invoice Detail (Sales) - Outbound169SZGLCG/L OffsetStringGeneric Edit40
124F47057EDI Payment Order Remittance Advice - Outbound93D3GLCG/L OffsetStringGeneric Edit40
125F47057WEDI Payment Order Remittance Advice - Work93D3GLCG/L OffsetStringGeneric Edit40
126F47072EDI Receiving Advice Detail - Inbound130SZGLCG/L OffsetStringGeneric Edit40
127F47077EDI Receiving Advice Detail - Outbound130SZGLCG/L OffsetStringGeneric Edit40
128F47092EDI Request for Quote Detail - Inbound169SZGLCG/L OffsetStringGeneric Edit40
129F47097EDI Request for Quote Detail - Outbound129SZGLCG/L OffsetStringGeneric Edit40
130F47102EDI Response to RFQ Detail - Inbound129SZGLCG/L OffsetStringGeneric Edit40
131F47107EDI Response to RFQ Detail - Outbound169SZGLCG/L OffsetStringGeneric Edit40
132F47132EDI Purchase Order Change Detail - Inbound170SZGLCG/L OffsetStringGeneric Edit40
133F47137EDI Purchase Order Change Detail - Outbound130SZGLCG/L OffsetStringGeneric Edit40
134F47142EDI P.O. Change Acknowledgment Detail - Inbound131SZGLCG/L OffsetStringGeneric Edit40
135F47147EDI P.O. Change Acknowledgment Detail - Outbound171SZGLCG/L OffsetStringGeneric Edit40
136F47157EDI Shipping Schedule Detail - Outbound138SZGLCG/L OffsetStringGeneric Edit40
TOP48S: Service Billing
137F4812Billing Detail Workfile140WDGLCG/L OffsetStringGeneric Edit40
138F48128G/L Offset and Retainage Information4WIGLCG/L OffsetStringGeneric Edit40
139F4812HBilling Workfile - History140WDGLCG/L OffsetStringGeneric Edit40
140F4812HSBilling Workfile History Purged Save140WDGLCG/L OffsetStringGeneric Edit40
141F4822Invoice Summary Work File21W4GLCG/L OffsetStringGeneric Edit40
142F4823Voucher Summary19W0GLCG/L OffsetStringGeneric Edit40
143F48S910Billing Detail Journal File27W2GLCG/L OffsetStringGeneric Edit40
144F48S911Compressed Journal File33W3GLCG/L OffsetStringGeneric Edit40
145F48S95Billing AAI Information12WVGLCG/L OffsetStringGeneric Edit40
146F48SUI01Billing Detail Print Workfile140WDGLCG/L OffsetStringGeneric Edit40
TOP49: Transportation Management
147F49004Mode of Transport Constants10CTGLCG/L OffsetStringGeneric Edit40
148F4978Charge Code Definitions2CGGLCG/L OffsetStringGeneric Edit40
TOP52: Contract Billing
149F5202Contract Billing Line Detail23G6GLCG/L OffsetStringGeneric Edit40
TOP74: EMEA Localization
150F74412Customer / Supplier Balance Workfile (A/R and A/P)6RPGLCG/L OffsetStringGeneric Edit40
151F74900Foreign Receivables and Payables - EMEA21RPGLCG/L OffsetStringGeneric Edit40
TOP74U: United Kingdom Localizations
152F74U25BTInterest Tag Table - 155PKGLCG/L OffsetStringGeneric Edit40
TOP74Y: Italy - Reporting System Only
153F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy23TIGLCG/L OffsetStringGeneric Edit40
TOP76A: Argentina
154F76A10Taxes - Tax Definition - ARG - 00 - 002TDGLCG/L OffsetStringGeneric Edit40
155F76AUI81Draft - Invoices Work File - ARG - 03B - 76A23WFGLCG/L OffsetStringGeneric Edit40
TOP76B: Brazil - Reporting System Only
156F7611BNota Fiscal Detail - Brazil40FDGLCG/L OffsetStringGeneric Edit40
157F761BAAS Fiscal file book43FBGLCG/L OffsetStringGeneric Edit40
158F76B0401Tax Code - 049CTGLCG/L OffsetStringGeneric Edit40
159F76B0411Voucher Additional Information Brazil - 0418VBGLCG/L OffsetStringGeneric Edit40
160F76B473TF04573 Brazilian Temp WH File - BR - 0422W3GLCG/L OffsetStringGeneric Edit40
TOP76C: Colombia
161F76C031AA/R Customer ledger As Of - F76C031A - COL - 0415RPGLCG/L OffsetStringGeneric Edit40
162F76C034AA/R Check Detail file As Of - COL - 76C13RZGLCG/L OffsetStringGeneric Edit40
TOP76H: Chile
163F76HUI52Document Selection Work File - CHI - 42 - 76H12DRGLCG/L OffsetStringGeneric Edit40
TOP89: Conversion Programs
164F43199ATemp F43199 for ERP 9.0 Upgrade115OLGLCG/L OffsetStringGeneric Edit40