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

181 columns | Print definition?910 | 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
7F03B11Z1Batch Invoices33VJGLCG/L OffsetStringGeneric Edit40
8F03B11Z2F03B11 Interoperability Table28SYGLCG/L OffsetStringGeneric Edit40
9F03B13Receipts Header12RYGLCG/L OffsetStringGeneric Edit40
10F03B13PReceipts Header Purge File12RYGLCG/L OffsetStringGeneric Edit40
11F03B13Z2F03B13 Interoperability Table25SYGLCG/L OffsetStringGeneric Edit40
12F03B14Receipts Detail13RZGLCG/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 Remittance15RDGLCG/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 Upload61VLGLCG/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 - Detail43KIGLCG/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 - Account Ledger 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 Master17NSGLCG/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 Billings8N4GLCG/L OffsetStringGeneric Edit40
54F1505Management Fee Master4NDGLCG/L OffsetStringGeneric Edit40
55F1505BManagement Fee Master6NDGLCG/L OffsetStringGeneric Edit40
56F1507Unit Master31NHGLCG/L OffsetStringGeneric Edit40
57F1511Tenant/Lease Billings Detail20NJGLCG/L OffsetStringGeneric Edit40
58F1511BLease Billings Master20NJGLCG/L OffsetStringGeneric Edit40
59F1511HTenant/Lease Billings Detail History20N#GLCG/L OffsetStringGeneric Edit40
60F1511HBLease Billings 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
66F1525BFees and Interest5NMGLCG/L OffsetStringGeneric Edit40
67F1538WF - Expence Participation Register52NZGLCG/L OffsetStringGeneric Edit40
68F1538BEP Billing Register53NZGLCG/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 Register57NZGLCG/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
112F4071PPrice Adjustment Type Purge8ATGLCG/L OffsetStringGeneric Edit40
113F4073Free Goods Master File10FGGLCG/L OffsetStringGeneric Edit40
114F4073PFree Goods Master File Purge11FGGLCG/L OffsetStringGeneric Edit40
115F4511WPricing Structure View12APGLCG/L OffsetStringGeneric Edit40
116F4575Ship and Debit History27AHGLCG/L OffsetStringGeneric Edit40
117F4575TMPShip and Debit History - Temp Table27AHGLCG/L OffsetStringGeneric Edit40
118F4576Z1Ship and Debit Claims Unedited Transaction Table112Z1GLCG/L OffsetStringGeneric Edit40
TOP47: Electronic Commerce
119F47012EDI Purchase Order Detail - Inbound169SZGLCG/L OffsetStringGeneric Edit40
120F47017EDI Purchase Order Detail - Outbound129SZGLCG/L OffsetStringGeneric Edit40
121F47022EDI P.O. Acknowledgment Detail - Inbound129SZGLCG/L OffsetStringGeneric Edit40
122F47027EDI P.O. Acknowledgment Detail - Outbound169SZGLCG/L OffsetStringGeneric Edit40
123F47037EDI Shipping Notice Detail - Outbound147SZGLCG/L OffsetStringGeneric Edit40
124F470371EDI Shipping Notice Detail - Outbound167SZGLCG/L OffsetStringGeneric Edit40
125F47047EDI Invoice Detail (Sales) - Outbound169SZGLCG/L OffsetStringGeneric Edit40
126F47057EDI Payment Order Remittance Advice - Outbound93D3GLCG/L OffsetStringGeneric Edit40
127F47057WEDI Payment Order Remittance Advice - Work93D3GLCG/L OffsetStringGeneric Edit40
128F47072EDI Receiving Advice Detail - Inbound130SZGLCG/L OffsetStringGeneric Edit40
129F47077EDI Receiving Advice Detail - Outbound130SZGLCG/L OffsetStringGeneric Edit40
130F47092EDI Request for Quote Detail - Inbound169SZGLCG/L OffsetStringGeneric Edit40
131F47097EDI Request for Quote Detail - Outbound129SZGLCG/L OffsetStringGeneric Edit40
132F47102EDI Response to RFQ Detail - Inbound129SZGLCG/L OffsetStringGeneric Edit40
133F47107EDI Response to RFQ Detail - Outbound169SZGLCG/L OffsetStringGeneric Edit40
134F47132EDI Purchase Order Change Detail - Inbound170SZGLCG/L OffsetStringGeneric Edit40
135F47137EDI Purchase Order Change Detail - Outbound130SZGLCG/L OffsetStringGeneric Edit40
136F47142EDI P.O. Change Acknowledgment Detail - Inbound131SZGLCG/L OffsetStringGeneric Edit40
137F47147EDI P.O. Change Acknowledgment Detail - Outbound171SZGLCG/L OffsetStringGeneric Edit40
138F47157EDI Shipping Schedule Detail - Outbound138SZGLCG/L OffsetStringGeneric Edit40
TOP48S: Service Billing
139F4812Billing Detail Workfile140WDGLCG/L OffsetStringGeneric Edit40
140F48128G/L Offset and Retainage Information4WIGLCG/L OffsetStringGeneric Edit40
141F4812HBilling Workfile History140WDGLCG/L OffsetStringGeneric Edit40
142F4812HSBilling Workfile History Purged Save140WDGLCG/L OffsetStringGeneric Edit40
143F4822Invoice Summary Work File21W4GLCG/L OffsetStringGeneric Edit40
144F4823Voucher Summary19W0GLCG/L OffsetStringGeneric Edit40
145F48S910Billing Detail Journal Workfile27W2GLCG/L OffsetStringGeneric Edit40
146F48S911Summarized Journal Workfile33W3GLCG/L OffsetStringGeneric Edit40
147F48S95Billing AAI Information12WVGLCG/L OffsetStringGeneric Edit40
148F48SUI01Billing Detail Print Workfile140WDGLCG/L OffsetStringGeneric Edit40
TOP49: Transportation Management
149F49004Mode of Transport Constants10CTGLCG/L OffsetStringGeneric Edit40
150F4978Charge Code Definitions2CGGLCG/L OffsetStringGeneric Edit40
TOP52: Contract Billing
151F5202Contract Billing Line Detail23G6GLCG/L OffsetStringGeneric Edit40
TOP52G: Government Contracting
152F4822HInvoice Summary History21IHGLCG/L OffsetStringGeneric Edit40
TOP74: EMEA Localization
153F74412Customer / Supplier Balance Worktable (A/P and A/R)6RPGLCG/L OffsetStringGeneric Edit40
154F74900Foreign Receivables and Payables - EMEA21RPGLCG/L OffsetStringGeneric Edit40
TOP74R: CIS
155F74R202Transit VAT Account Setup - RUS - 421TAGLCG/L OffsetStringGeneric Edit40
156F74R410Tax on Hold - RUS - 0418THGLCG/L OffsetStringGeneric Edit40
TOP74U: United Kingdom Localizations
157F74U0420SPC - Application Master - UK - 4320SEGLCG/L OffsetStringGeneric Edit40
158F74U0425SPC - Certificate Master - UK - 4321SFGLCG/L OffsetStringGeneric Edit40
159F74U25BTInterest Tag Table - 155PKGLCG/L OffsetStringGeneric Edit40
160F74U4312SPC - Purchase Order Additional Information - UK - 4326SCGLCG/L OffsetStringGeneric Edit40
161F74U4316SPC - Purchase Order Line Additional Information - UK - 4336SCGLCG/L OffsetStringGeneric Edit40
TOP74Y: Italy - Reporting System Only
162F743B14ISuspended IVA Generation - Receipt/Rebate Control-Ita - 03B23TIGLCG/L OffsetStringGeneric Edit40
TOP75I: India
163F75I101TDS Certificate Work Maintenance51QBGLCG/L OffsetStringGeneric Edit40
164F75I10ATDS Rate Maintenance File11QAGLCG/L OffsetStringGeneric Edit40
165F75I15ATDS Document Company Maintenance File10QCGLCG/L OffsetStringGeneric Edit40
166F75I731Service Tax A/R File - IND - 03B6STGLCG/L OffsetStringGeneric Edit40
167F75I741Service Tax A/P File - IND - 047STGLCG/L OffsetStringGeneric Edit40
168F75I791Item - Supplier Cost Components - IND - 43B16ISGLCG/L OffsetStringGeneric Edit40
TOP75T: Taiwan
169F75T42WWork file with union of F4211 and F4211932SWGLCG/L OffsetStringGeneric Edit40
TOP76A: Argentina
170F76A10Taxes - Tax Definition - ARG - 00 - 76A2TDGLCG/L OffsetStringGeneric Edit40
171F76AUI81Draft - Invoices Work File - ARG - 03B - 76A23WFGLCG/L OffsetStringGeneric Edit40
TOP76B: Brazil - Reporting System Only
172F7611BNota Fiscal Detail - BRA - 4240FDGLCG/L OffsetStringGeneric Edit40
173F761BAAS Fiscal file book - 0943FBGLCG/L OffsetStringGeneric Edit40
174F76B0401Tax Code - 049CTGLCG/L OffsetStringGeneric Edit40
175F76B0411Voucher Additional Information Brazil - 0418VBGLCG/L OffsetStringGeneric Edit40
176F76B409Taxes Setup by City and Service - BR - 047CSGLCG/L OffsetStringGeneric Edit40
177F76B473TF04573 Brazilian Temp WH File - BR - 0422W3GLCG/L OffsetStringGeneric Edit40
TOP76C: Colombia
178F76C031AA/R Customer ledger As Of - F76C031A - COL - 0415RPGLCG/L OffsetStringGeneric Edit40
179F76C034AA/R Check Detail file As Of - COL - 03B13RZGLCG/L OffsetStringGeneric Edit40
TOP76H: Chile
180F76HUI52Document Selection Work File - CHI - 42 - 76H12DRGLCG/L OffsetStringGeneric Edit40
TOP89: Conversion Programs
181F43199ATemp F43199 for ERP 9.0 Upgrade115OLGLCG/L OffsetStringGeneric Edit40