JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
9F03012AICustomer Master by Line of Business
10F0006MCBusiness Unit Master

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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

201 columns | Print definition?812 | CTRY

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00021Next Numbers by Company/Fiscal Year - Automatic3NLCTRYCenturyNumericGeneric Edit20
2F00023Distributed Next Number Table6DNCTRYCenturyNumericGeneric Edit20
3F0007Work Day Calendar1CZCTRYCenturyNumericGeneric Edit20
4F0008Date Fiscal Patterns25CDCTRYCenturyNumericGeneric Edit20
5F00098Enable Distributed Next Numner5EDCTRYCenturyNumericGeneric Edit20
6F0902Account Balances2GBCTRYCenturyNumericGeneric Edit20
7F0911Account Ledger24GLCTRYCenturyNumericGeneric Edit20
8F1501Tenant/Lease Master32NECTRYCenturyNumericGeneric Edit20
9F49090Work Day Calendar1CZCTRYCenturyNumericGeneric Edit20
TOP02: Electronic Mail
10F0126Flash Schedule Master File4A#CTRYCenturyNumericGeneric Edit20
TOP03: Accounts Receivable
11F0311Accounts Receivable Ledger13RPCTRYCenturyNumericGeneric Edit20
TOP03B: Enhanced Accounts Receivable
12F03B08Credit/Collection Date Pattern2RDCTRYCenturyNumericGeneric Edit20
13F03B11Customer Ledger12RPCTRYCenturyNumericGeneric Edit20
14F03B112Invoice Revisions12RWCTRYCenturyNumericGeneric Edit20
15F03B112PInvoice Revisions Purge File12RWCTRYCenturyNumericGeneric Edit20
16F03B11PCustomer Ledger Purge File12RPCTRYCenturyNumericGeneric Edit20
17F03B11Z1Invoice Transactions - Batch File30VJCTRYCenturyNumericGeneric Edit20
18F03B11Z2F03B11 Interoperability Table25SYCTRYCenturyNumericGeneric Edit20
19F03B13Receipts Header File14RYCTRYCenturyNumericGeneric Edit20
20F03B13PReceipts Header Purge File14RYCTRYCenturyNumericGeneric Edit20
21F03B13Z2F03B13 Interoperability Table27SYCTRYCenturyNumericGeneric Edit20
22F03B14A/R Check Detail File15RZCTRYCenturyNumericGeneric Edit20
23F03B14PReceipts Detail Purge File15RZCTRYCenturyNumericGeneric Edit20
24F03B14Z2F03B14 Interoperability Table28SZCTRYCenturyNumericGeneric Edit20
25F03B16A/R Statistical History3RVCTRYCenturyNumericGeneric Edit20
26F03B465A/R Netting Workfile19ROCTRYCenturyNumericGeneric Edit20
27F03B575Auto Debit Invoice Select and Build15RDCTRYCenturyNumericGeneric Edit20
28F03B672Draft Remittance Work File - One World Only17RDCTRYCenturyNumericGeneric Edit20
29F03BUI04Work File for Integrity by Offset Account10W3CTRYCenturyNumericGeneric Edit20
30F09UI011Receipt Prepost Work File18GLCTRYCenturyNumericGeneric Edit20
TOP04: Accounts Payable
31F0411Accounts Payable Ledger16RPCTRYCenturyNumericGeneric Edit20
32F0411AWF - As Of - Accounts Payable Ledger16RPCTRYCenturyNumericGeneric Edit20
33F0411PPurge - Accounts Payable Ledger16RPCTRYCenturyNumericGeneric Edit20
34F0411Z1Voucher Transactions - Batch File34VLCTRYCenturyNumericGeneric Edit20
35F0411Z3F0411 Interoperability Table38SZCTRYCenturyNumericGeneric Edit20
36F0414Accounts Payable Matching Document Detail23RNCTRYCenturyNumericGeneric Edit20
37F0414AWF - As Of - Accounts Payable Payment Detail23RNCTRYCenturyNumericGeneric Edit20
38F0414PPurge - Accounts Payable Matching Document Detail23RNCTRYCenturyNumericGeneric Edit20
39F0414Z1F0414 Interoperability Table36SZCTRYCenturyNumericGeneric Edit20
40F09UI005Tax Offsets User Index15GLCTRYCenturyNumericGeneric Edit20
41F70404G/L Registration Balance File2Z7CTRYCenturyNumericGeneric Edit20
TOP05: Time Accounting and HRM Base
42F06145Calendar Month DBA Summary History File4YHCTRYCenturyNumericGeneric Edit20
43F0627Workers Compensation Summary History9JHCTRYCenturyNumericGeneric Edit20
TOP05T: Time Entry
44F06116Employee Transaction Detail File99YTCTRYCenturyNumericGeneric Edit20
45F06116Z1Employee Transactions - Batch File113VLCTRYCenturyNumericGeneric Edit20
46F0623Piecework History File8JLCTRYCenturyNumericGeneric Edit20
47F06278Retro Timecard Detail File99YTCTRYCenturyNumericGeneric Edit20
48F06290Payroll Accounting Journal Work File12YRCTRYCenturyNumericGeneric Edit20
49F063951Payroll Journal (Compressed) File4GLCTRYCenturyNumericGeneric Edit20
TOP06: Payroll (old) - Obsolete-do not reuse
50F06146Employee Transaction History Summary4YNCTRYCenturyNumericGeneric Edit20
TOP07: Payroll
51F05290WF - Payroll Journal (Detail)4JRCTRYCenturyNumericGeneric Edit20
52F06136Tax History7YZCTRYCenturyNumericGeneric Edit20
53F06136ATax Summary (Additional)12YZCTRYCenturyNumericGeneric Edit20
54F06148Tax Area Transaction History7Y@CTRYCenturyNumericGeneric Edit20
55F06156Pay Check History Summary34YUCTRYCenturyNumericGeneric Edit20
56F069066Pay Cycle Constant22JDCTRYCenturyNumericGeneric Edit20
57F07210Pay Cycle Parameters File90YDCTRYCenturyNumericGeneric Edit20
58F074001New Hire Reporting Workfile - OneWorld Only103NHCTRYCenturyNumericGeneric Edit20
59F07880SUI Magnetic Media Workfile86YWCTRYCenturyNumericGeneric Edit20
TOP09: General Accounting
60F0902BAccount Balances - 52 Period Accounting2GBCTRYCenturyNumericGeneric Edit20
61F0902PPurge - Account Balances2GBCTRYCenturyNumericGeneric Edit20
62F0902Z1Account Balances - Batch File2GBCTRYCenturyNumericGeneric Edit20
63F0911PPurge - Account Ledger24GLCTRYCenturyNumericGeneric Edit20
64F0911RWF - Acct Ledger File for Reconciliation24GLCTRYCenturyNumericGeneric Edit20
65F0911Z1Journal Entry Transactions - Batch File41VNCTRYCenturyNumericGeneric Edit20
66F0911Z4F0911 Interoperability Table46SZCTRYCenturyNumericGeneric Edit20
67F0912Cost Allocations/Flex Budgeting40RJCTRYCenturyNumericGeneric Edit20
68F0912AIndex Computation Entry File35RICTRYCenturyNumericGeneric Edit20
69F0912BVariable Allocation File7R#CTRYCenturyNumericGeneric Edit20
70F09UI004Variable Numerator Allocations work file15R#CTRYCenturyNumericGeneric Edit20
71F09UI014Annual Close Work Table6GBCTRYCenturyNumericGeneric Edit20
72F09UI015Indexed Computations Multi-Tiered Entries24GLCTRYCenturyNumericGeneric Edit20
73F09UI016Account Balance Compare Exceptions17GWCTRYCenturyNumericGeneric Edit20
TOP10: Financial Reporting
74F1001Multi-Site Consolidation Transfer File Header13GPCTRYCenturyNumericGeneric Edit20
75F1001Z1Unedited MSC Interoperability Header Table23IACTRYCenturyNumericGeneric Edit20
TOP12: Fixed Assets
76F1202Asset Account Balances File2FLCTRYCenturyNumericGeneric Edit20
77F1202PAsset Account Balances Purge Table2FLCTRYCenturyNumericGeneric Edit20
TOP13: Plant/Equipment Management
78F1303Billing Exception Days3FJCTRYCenturyNumericGeneric Edit20
TOP14: Modeling - Planning & Budgeting
79F14041Forecast Results - Detail9BZCTRYCenturyNumericGeneric Edit20
TOP15: Property Management
80F15011Billings Generation Control Master4NKCTRYCenturyNumericGeneric Edit20
81F15011BOW BIllings Generation Control Master4NKCTRYCenturyNumericGeneric Edit20
82F15013Sales Overage Master57NOCTRYCenturyNumericGeneric Edit20
83F1501BLease Master Header File39NECTRYCenturyNumericGeneric Edit20
84F1505HRevenue Fee Generation History12OKCTRYCenturyNumericGeneric Edit20
85F1505HBRevenue Fee Generation History8OKCTRYCenturyNumericGeneric Edit20
86F1511Tenant/Lease Billings Detail41NJCTRYCenturyNumericGeneric Edit20
87F1511BTenant/Lease Billings Detail Master41NJCTRYCenturyNumericGeneric Edit20
88F1511HTenant/Lease Billings Detail History41N#CTRYCenturyNumericGeneric Edit20
89F1511HBTenant/Lease Billings Detail History41NCCTRYCenturyNumericGeneric Edit20
90F1513FASB 13 Lease Control File4O3CTRYCenturyNumericGeneric Edit20
91F1513BFASB 13 Lease Control File4O3CTRYCenturyNumericGeneric Edit20
92F1532BExpense Participation Audit File11NTCTRYCenturyNumericGeneric Edit20
93F1540Sales Report Control File5NRCTRYCenturyNumericGeneric Edit20
94F1540BSales Report Control File11NRCTRYCenturyNumericGeneric Edit20
95F1541Tenant Sales History6N8CTRYCenturyNumericGeneric Edit20
96F15410Tenant Weekly Sales File7N9CTRYCenturyNumericGeneric Edit20
97F1541BTenant Sales History File7N8CTRYCenturyNumericGeneric Edit20
98F1541BWSales History Work File9OWCTRYCenturyNumericGeneric Edit20
99F1542Projected Sales8OJCTRYCenturyNumericGeneric Edit20
100F1543BTenant Sales Analysis Reporting File2OACTRYCenturyNumericGeneric Edit20
101F1547Sales Seasonality4OICTRYCenturyNumericGeneric Edit20
102F1550Escalation Index Master2NVCTRYCenturyNumericGeneric Edit20
TOP15L: Adv Real Estate Forecasting
103F15L108AREF Base Account Definition4ADCTRYCenturyNumericGeneric Edit20
104F15L109AREF Budget Results3BRCTRYCenturyNumericGeneric Edit20
105F15L110AREF Account Status4ASCTRYCenturyNumericGeneric Edit20
106F15L111AREF Account Status Detail4ADCTRYCenturyNumericGeneric Edit20
107F15L118AREF Base Account Definition Detail4DDCTRYCenturyNumericGeneric Edit20
108F15L301AREF Projected Sales7PSCTRYCenturyNumericGeneric Edit20
109F15L302AREF Prior Gross Billings12PGCTRYCenturyNumericGeneric Edit20
110F15L38AREF EP Billing Register7NZCTRYCenturyNumericGeneric Edit20
TOP17: Customer Service Management
111F1794Billing/Amort Control Master7NKCTRYCenturyNumericGeneric Edit20
TOP18: Resource Scheduling
112F186602Labor Rules Tag File105TFCTRYCenturyNumericGeneric Edit20
TOP30: Product Data Management
113F0007Z1Work Day Calendar Transaction File14SZCTRYCenturyNumericGeneric Edit20
114F3007Work Center Resource Units46WUCTRYCenturyNumericGeneric Edit20
TOP40: Inventory/OP Base
115F4011ZBatch Receiver File - Order Details169SZCTRYCenturyNumericGeneric Edit20
116F41112Item ASOF File3INCTRYCenturyNumericGeneric Edit20
117F4211Z1Sales Order Detail Unedited Transaction File155SZCTRYCenturyNumericGeneric Edit20
TOP41: Inventory Management
118F4115Item History3IHCTRYCenturyNumericGeneric Edit20
TOP42: Sales Management
119F4211Sales Order Detail File142SDCTRYCenturyNumericGeneric Edit20
120F42119Sales Order History File142SDCTRYCenturyNumericGeneric Edit20
121F42199S.O. Detail Ledger File142SLCTRYCenturyNumericGeneric Edit20
122F4229Sales Summary History File13SSCTRYCenturyNumericGeneric Edit20
123F42800G1Sales Update G Batch Detail Workfile19DGCTRYCenturyNumericGeneric Edit20
124F42UI01SO Header Cache File (MBF)112ZHCTRYCenturyNumericGeneric Edit20
125F42UI11SO Detail Cache File (MBF)101ZDCTRYCenturyNumericGeneric Edit20
TOP43: Procurement
126F43080Approvals Fields Constants120PDCTRYCenturyNumericGeneric Edit20
127F4311Purchase Order Detail File116PDCTRYCenturyNumericGeneric Edit20
128F4311ZPurchase Order Generator File120PWCTRYCenturyNumericGeneric Edit20
129F4311Z1Purchase Order Detail Unedited Transaction Table129SZCTRYCenturyNumericGeneric Edit20
130F4316Purchase Order Multiple Account File17P3CTRYCenturyNumericGeneric Edit20
131F43199P.O. Detail Ledger File - Flexible Version116OLCTRYCenturyNumericGeneric Edit20
TOP43E: Requisition Self Service
132F43E16Requisition Multiple Account File18P3CTRYCenturyNumericGeneric Edit20
TOP44H: Homebuilder Management
133F44H611Bid Details58BDCTRYCenturyNumericGeneric Edit20
134F44H611WBid Details Work File62BWCTRYCenturyNumericGeneric Edit20
135F44H711Lot Start Workfile66SWCTRYCenturyNumericGeneric Edit20
136F44H711ZHB Lot Start Unedited Transaction File79SZCTRYCenturyNumericGeneric Edit20
137F44H71W1Lot Start Generation Workfile66GWCTRYCenturyNumericGeneric Edit20
TOP47: Electronic Commerce
138F47012EDI Purchase Order Detail - Inbound170SZCTRYCenturyNumericGeneric Edit20
139F47017EDI Purchase Order Detail - Outbound130SZCTRYCenturyNumericGeneric Edit20
140F47022EDI P.O. Acknowledgment Detail - Inbound130SZCTRYCenturyNumericGeneric Edit20
141F47027EDI P.O. Acknowledgment Detail - Outbound170SZCTRYCenturyNumericGeneric Edit20
142F47032EDI Shipping Notice Detail - Inbound97SZCTRYCenturyNumericGeneric Edit20
143F47037EDI Shipping Notice Detail - Outbound148SZCTRYCenturyNumericGeneric Edit20
144F470371EDI Shipping Notice Detail - Outbound168SZCTRYCenturyNumericGeneric Edit20
145F47047EDI Invoice Detail (Sales) - Outbound170SZCTRYCenturyNumericGeneric Edit20
146F47056EDI Payment Order Header - Outbound36D1CTRYCenturyNumericGeneric Edit20
147F47056WEDI Payment Order Header - Work36D1CTRYCenturyNumericGeneric Edit20
148F47072EDI Receiving Advice Detail - Inbound131SZCTRYCenturyNumericGeneric Edit20
149F47077EDI Receiving Advice Detail - Outbound131SZCTRYCenturyNumericGeneric Edit20
150F47092EDI Request for Quote Detail - Inbound170SZCTRYCenturyNumericGeneric Edit20
151F47097EDI Request for Quote Detail - Outbound130SZCTRYCenturyNumericGeneric Edit20
152F47102EDI Response to RFQ Detail - Inbound130SZCTRYCenturyNumericGeneric Edit20
153F47107EDI Response to RFQ Detail - Outbound170SZCTRYCenturyNumericGeneric Edit20
154F47132EDI Purchase Order Change Detail - Inbound171SZCTRYCenturyNumericGeneric Edit20
155F47137EDI Purchase Order Change Detail - Outbound131SZCTRYCenturyNumericGeneric Edit20
156F47142EDI P.O. Change Acknowledgment Detail - Inbound132SZCTRYCenturyNumericGeneric Edit20
157F47147EDI P.O. Change Acknowledgment Detail - Outbound172SZCTRYCenturyNumericGeneric Edit20
158F47157EDI Shipping Schedule Detail - Outbound139SZCTRYCenturyNumericGeneric Edit20
TOP48S: Service Billing
159F4812Billing Detail Workfile17WDCTRYCenturyNumericGeneric Edit20
160F4812HBilling Workfile - History17WDCTRYCenturyNumericGeneric Edit20
161F4812HSBilling Workfile History Purged Save17WDCTRYCenturyNumericGeneric Edit20
162F48S910Billing Detail Journal File11W2CTRYCenturyNumericGeneric Edit20
163F48S911Compressed Journal File12W3CTRYCenturyNumericGeneric Edit20
164F48SUI01Billing Detail Print Workfile17WDCTRYCenturyNumericGeneric Edit20
TOP52: Contract Billing
165F5280Contract Revenue Summary File10GWCTRYCenturyNumericGeneric Edit20
166F5280WContract Revenue Summary Work File10GYCTRYCenturyNumericGeneric Edit20
TOP55: Reserved for Clients
167F550200Correspondent Accounts Report5WFCTRYCenturyNumericGeneric Edit20
168F55IF311As Of96RPCTRYCenturyNumericGeneric Edit20
169F55IF421Sales Order per BO158SDCTRYCenturyNumericGeneric Edit20
170F55IF425Sales Order per BO - 2005158SDCTRYCenturyNumericGeneric Edit20
171F55W0100Correction Invoice Print - WF1143SDCTRYCenturyNumericGeneric Edit20
172F74R0010Petty Cash Next Number Setup - RUS - 00 - 74R6PCCTRYCenturyNumericGeneric Edit20
173F74T550General Ledger Work File - Turkish27DKCTRYCenturyNumericGeneric Edit20
TOP74: EMEA Localization
174F74900Foreign Receivables and Payables - EMEA18RPCTRYCenturyNumericGeneric Edit20
175F74UI92WF - Account Cell Value - EMEA - 7423CVCTRYCenturyNumericGeneric Edit20
TOP74H: Hungary
176F741202Work File Accumulated Asset Movement Dep - HUN - 742WFCTRYCenturyNumericGeneric Edit20
TOP74P: Poland
177F74902TAccount Balance Tag File - COM - 09 - 74P2ATCTRYCenturyNumericGeneric Edit20
TOP74R: CIS
178F74R9002Correspondence Balance - RUS- 09 - 74R3GBCTRYCenturyNumericGeneric Edit20
TOP74U: United Kingdom Localizations
179F74U0212Accounting Billing Profile - 1523P8CTRYCenturyNumericGeneric Edit20
180F74U0213Weekly Accounting Profile - 1524PWCTRYCenturyNumericGeneric Edit20
181F74U02BTRecurring Billing Tag - 1518P6CTRYCenturyNumericGeneric Edit20
182F74U207BPeriodic Accounting Profile Status History - 156PACTRYCenturyNumericGeneric Edit20
183F74U207CWeekly Accounting Profile Status History - 155PHCTRYCenturyNumericGeneric Edit20
TOP74Y: Italy - Reporting System Only
184F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy32TICTRYCenturyNumericGeneric Edit20
TOP75A: Australia - Reporting System Only
185F75A0140Australian Group Certificates8ZGCTRYCenturyNumericGeneric Edit20
TOP76A: Argentina
186F76A391Adjustment Indexes - 76A2C1CTRYCenturyNumericGeneric Edit20
187F76A392Calculated costs header - 76A2C2CTRYCenturyNumericGeneric Edit20
188F76A393Calculated costs detail - 76A2C3CTRYCenturyNumericGeneric Edit20
189F76A394Adjustments - 76A2C4CTRYCenturyNumericGeneric Edit20
TOP76C: Colombia
190F76C031AA/R Customer ledger As Of - F76C031A - COL - 0412RPCTRYCenturyNumericGeneric Edit20
191F76C034AA/R Check Detail file As Of - COL - 76C15RZCTRYCenturyNumericGeneric Edit20
192F76C0902Debits and Credits T/B by object account - COL - 76C2GBCTRYCenturyNumericGeneric Edit20
193F76C575Work File Magnetic Media - COL - 043Q1CTRYCenturyNumericGeneric Edit20
194F76C9415Workfile for Dialy Book - COL - 0918LDCTRYCenturyNumericGeneric Edit20
195F76CT1Tributary Information - COL - 76C3TICTRYCenturyNumericGeneric Edit20
TOP76H: Chile
196F76H6112Actual Item ASOF File - CHI - 41 - 76H3ANCTRYCenturyNumericGeneric Edit20
197F76H902TAccount Balances Tag File - CHI - 09 - 76H2ATCTRYCenturyNumericGeneric Edit20
TOP77: Payroll (Canadian)
198F0713Tax History7YZCTRYCenturyNumericGeneric Edit20
199F0713SAVBackup Copy of F0713 For Tax Ledger Repost7YZCTRYCenturyNumericGeneric Edit20
TOP89: Conversion Programs
200F0902AAccount Debit Balances2GDCTRYCenturyNumericGeneric Edit20
201F43199ATemp F43199 for ERP 9.0 Upgrade116OLCTRYCenturyNumericGeneric Edit20