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
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

210 columns | Print definition?920 | FY

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00021Next Numbers by Company/Fiscal Year - Automatic4NLFYFiscal YearNumericGeneric Edit20
2F00023Distributed Next Number Table7DNFYFiscal YearNumericGeneric Edit20
3F0008Date Fiscal Patterns2CDFYFiscal YearNumericGeneric Edit20
4F00098Enable Distributed Next Numner6EDFYFiscal YearNumericGeneric Edit20
5F0902Account Balances3GBFYFiscal YearNumericGeneric Edit20
6F0911Account Ledger25GLFYFiscal YearNumericGeneric Edit20
7F097001WCompanies Out of Balance Work Table5CBFYFiscal YearNumericGeneric Edit20
TOP03: Accounts Receivable
8F0311Accounts Receivable Ledger12RPFYFiscal YearNumericGeneric Edit20
TOP03B: Enhanced Accounts Receivable
9F03B08Credit/Collection Date Pattern3RDFYFiscal YearNumericGeneric Edit20
10F03B11Customer Ledger11RPFYFiscal YearNumericGeneric Edit20
11F03B112Invoice Revisions11RWFYFiscal YearNumericGeneric Edit20
12F03B112PInvoice Revisions Purge File11RWFYFiscal YearNumericGeneric Edit20
13F03B117Revenue Recognition GL Info29RLFYFiscal YearNumericGeneric Edit20
14F03B119Revenue Recognition GL Info Audit17RNFYFiscal YearNumericGeneric Edit20
15F03B11PCustomer Ledger Purge File11RPFYFiscal YearNumericGeneric Edit20
16F03B11Z1Batch Invoices29VJFYFiscal YearNumericGeneric Edit20
17F03B11Z2F03B11 Interoperability Table24SYFYFiscal YearNumericGeneric Edit20
18F03B13Receipts Header15RYFYFiscal YearNumericGeneric Edit20
19F03B13PReceipts Header Purge File15RYFYFiscal YearNumericGeneric Edit20
20F03B13Z2F03B13 Interoperability Table28SYFYFiscal YearNumericGeneric Edit20
21F03B14Receipts Detail16RZFYFiscal YearNumericGeneric Edit20
22F03B14PReceipts Detail Purge File16RZFYFiscal YearNumericGeneric Edit20
23F03B14Z2F03B14 Interoperability Table29SZFYFiscal YearNumericGeneric Edit20
24F03B16A/R Statistical History4RVFYFiscal YearNumericGeneric Edit20
25F03B465A/R Netting Workfile18ROFYFiscal YearNumericGeneric Edit20
26F03B575Auto Debit Invoice Select and Build14RDFYFiscal YearNumericGeneric Edit20
27F03B672Draft Remittance18RDFYFiscal YearNumericGeneric Edit20
28F03BUI04Work File for Integrity by Offset Account9W3FYFiscal YearNumericGeneric Edit20
29F09UI011Receipt Prepost Work File19GLFYFiscal YearNumericGeneric Edit20
TOP04: Accounts Payable
30F0411Accounts Payable Ledger15RPFYFiscal YearNumericGeneric Edit20
31F0411AWF - 'As Of' Accounts Payable Ledger15RPFYFiscal YearNumericGeneric Edit20
32F0411PPurge - Accounts Payable Ledger15RPFYFiscal YearNumericGeneric Edit20
33F0411Z1Voucher Transactions - Batch Upload33VLFYFiscal YearNumericGeneric Edit20
34F0411Z3F0411 Interoperability Table37SZFYFiscal YearNumericGeneric Edit20
35F0414Accounts Payable Matching Document Detail22RNFYFiscal YearNumericGeneric Edit20
36F0414AWF - 'As Of' Accounts Payable Payment Detail22RNFYFiscal YearNumericGeneric Edit20
37F0414PPurge - Accounts Payable Matching Document Detail22RNFYFiscal YearNumericGeneric Edit20
38F0414Z1F0414 Interoperability Table35SZFYFiscal YearNumericGeneric Edit20
39F09UI005Tax Offsets User Index14GLFYFiscal YearNumericGeneric Edit20
TOP05: Time Accounting and HRM Base
40F0618Employee Transaction History66YTFYFiscal YearNumericGeneric Edit20
TOP05T: Time Entry
41F06116Employee Transaction Detail File66YTFYFiscal YearNumericGeneric Edit20
42F06116Z1Employee Transactions - Batch File80VLFYFiscal YearNumericGeneric Edit20
43F06116Z2ESS Timecard History80VMFYFiscal YearNumericGeneric Edit20
44F06278Retro Timecard Detail File66YTFYFiscal YearNumericGeneric Edit20
45F06290Payroll Accounting Journal Work File13YRFYFiscal YearNumericGeneric Edit20
46F063951Payroll Journal (Compressed) File5GLFYFiscal YearNumericGeneric Edit20
TOP06: Payroll (old) - Obsolete-do not reuse
47F069096Payroll General Constants23YKFYFiscal YearNumericGeneric Edit20
TOP07: Payroll
48F05290WF - Payroll Journal (Detail)5JRFYFiscal YearNumericGeneric Edit20
49F07491Payroll - Accounts Payable Summary File21J6FYFiscal YearNumericGeneric Edit20
50F07900Non Calendar Tax Fiscal Date Patterns2NCFYFiscal YearNumericGeneric Edit20
51F07UI200Timecard History Work File69THFYFiscal YearNumericGeneric Edit20
TOP08P: Position Control
52F08101Position Master1HPFYFiscal YearNumericGeneric Edit20
53F081012Position Accounts1HCFYFiscal YearNumericGeneric Edit20
54F08101PPurge - Position Master1HPFYFiscal YearNumericGeneric Edit20
TOP08R: Recruitment Management - (Appl. Track. & Req.)
55F08102Requisition Information5HNFYFiscal YearNumericGeneric Edit20
TOP09: General Accounting
56F0902BAccount Balances - 52 Period Accounting3GBFYFiscal YearNumericGeneric Edit20
57F0902PPurge - Account Balances3GBFYFiscal YearNumericGeneric Edit20
58F0902Z1Account Balances - Batch File3GBFYFiscal YearNumericGeneric Edit20
59F0911PPurge - Account Ledger25GLFYFiscal YearNumericGeneric Edit20
60F0911RWF - Account Ledger Reconciliation25GLFYFiscal YearNumericGeneric Edit20
61F0911Z1Journal Entry Transactions - Batch File42VNFYFiscal YearNumericGeneric Edit20
62F0911Z4F0911 Interoperability Table47SZFYFiscal YearNumericGeneric Edit20
63F0912Cost Allocations/Flex Budgeting38RJFYFiscal YearNumericGeneric Edit20
64F0912AIndex Computation Entry File33RIFYFiscal YearNumericGeneric Edit20
65F09360WOVFS Column List Work Table6CLFYFiscal YearNumericGeneric Edit20
66F09370WOVFS Balance Work Table4BWFYFiscal YearNumericGeneric Edit20
67F097031WAccount Balance to Account Master Work Table5ABFYFiscal YearNumericGeneric Edit20
68F09UI004Variable Numerator Allocations work file16R#FYFiscal YearNumericGeneric Edit20
69F09UI014Annual Close Work Table7GBFYFiscal YearNumericGeneric Edit20
70F09UI015Indexed Computations Multi-Tiered Entries25GLFYFiscal YearNumericGeneric Edit20
71F09UI016Account Balance Compare Exceptions9GWFYFiscal YearNumericGeneric Edit20
72F09UI123Advanced Variable Numerator Worktable17VWFYFiscal YearNumericGeneric Edit20
73F52G02Burdening Summarized Ledger3BSFYFiscal YearNumericGeneric Edit20
74F52G11Burdening Detail Ledger19BDFYFiscal YearNumericGeneric Edit20
75F52G11WFTemporary Burdened Detail Ledger Workfile19BWFYFiscal YearNumericGeneric Edit20
76F70UI001Work File for G/L by Cat. Code Localization2WAFYFiscal YearNumericGeneric Edit20
77F740911Work File for G/L Report by Category Code Localization2WAFYFiscal YearNumericGeneric Edit20
TOP10: Financial Reporting
78F1001Multi-Site Consolidation Transfer File Header12GPFYFiscal YearNumericGeneric Edit20
79F1001Z1Unedited MSC Interoperability Header Table22IAFYFiscal YearNumericGeneric Edit20
TOP12: Fixed Assets
80F1202Asset Account Balances File3FLFYFiscal YearNumericGeneric Edit20
81F1202PAsset Account Balances Purge Table3FLFYFiscal YearNumericGeneric Edit20
TOP14: Modeling - Planning & Budgeting
82F14041Forecast Results - Detail8BZFYFiscal YearNumericGeneric Edit20
TOP15L: Adv Real Estate Forecasting
83F15L108AREF Base Account Definition5ADFYFiscal YearNumericGeneric Edit20
84F15L109AREF Budget Results4BRFYFiscal YearNumericGeneric Edit20
85F15L110AREF Account Status5ASFYFiscal YearNumericGeneric Edit20
86F15L111AREF Account Status Detail5ADFYFiscal YearNumericGeneric Edit20
87F15L118AREF Base Account Definition Detail5DDFYFiscal YearNumericGeneric Edit20
88F15L38AREF EP Billing Register9NZFYFiscal YearNumericGeneric Edit20
TOP16: Profit Management (EPS)
89F1603Cost Analyzer View Structure15CVFYFiscal YearNumericGeneric Edit20
TOP17: Customer Service Management
90F1794Billing/Amort Control Master8NKFYFiscal YearNumericGeneric Edit20
TOP18: Timecard Automation
91F186602Labor Rules Tag File76TFFYFiscal YearNumericGeneric Edit20
TOP40: Inventory/OP Base
92F4011ZBatch Receiver File - Order Details170SZFYFiscal YearNumericGeneric Edit20
93F41112Item ASOF File2INFYFiscal YearNumericGeneric Edit20
94F4211Z1Sales Order Detail Unedited Transaction File156SZFYFiscal YearNumericGeneric Edit20
TOP41: Inventory Management
95F4115Item History4IHFYFiscal YearNumericGeneric Edit20
96F41UI001Inventory Transactions Detail File159ITFYFiscal YearNumericGeneric Edit20
TOP42: Sales Management
97F4211Sales Order Detail File143SDFYFiscal YearNumericGeneric Edit20
98F42119Sales Order History File143SDFYFiscal YearNumericGeneric Edit20
99F42199S.O. Detail Ledger File143SLFYFiscal YearNumericGeneric Edit20
100F4229Sales Summary History File14SSFYFiscal YearNumericGeneric Edit20
101F42800G1Sales Update G Batch Detail Workfile17DGFYFiscal YearNumericGeneric Edit20
102F42UI01SO Header Cache File (MBF)111ZHFYFiscal YearNumericGeneric Edit20
103F42UI11SO Detail Cache File (MBF)102ZDFYFiscal YearNumericGeneric Edit20
104F42UI800Sales Detail Work File - Sales Update33SDFYFiscal YearNumericGeneric Edit20
TOP43: Procurement
105F43080Approvals Fields Constants121PDFYFiscal YearNumericGeneric Edit20
106F4311Purchase Order Detail File117PDFYFiscal YearNumericGeneric Edit20
107F4311ZPurchase Order Generator File121PWFYFiscal YearNumericGeneric Edit20
108F4311Z1Purchase Order Detail Unedited Transaction Table130SZFYFiscal YearNumericGeneric Edit20
109F4316Purchase Order Multiple Account File16P3FYFiscal YearNumericGeneric Edit20
110F43199P.O. Detail Ledger File - Flexible Version117OLFYFiscal YearNumericGeneric Edit20
TOP43E: Requisition Self Service
111F43E16Requisition Multiple Account File17P3FYFiscal YearNumericGeneric Edit20
TOP44H: Homebuilder Management
112F44H611Bid Details59BDFYFiscal YearNumericGeneric Edit20
113F44H611WBid Details Work File63BWFYFiscal YearNumericGeneric Edit20
114F44H711Lot Start Workfile67SWFYFiscal YearNumericGeneric Edit20
115F44H711ZHB Lot Start Unedited Transaction File80SZFYFiscal YearNumericGeneric Edit20
116F44H71W1Lot Start Generation Workfile67GWFYFiscal YearNumericGeneric Edit20
TOP47: Electronic Commerce
117F47012EDI Purchase Order Detail - Inbound171SZFYFiscal YearNumericGeneric Edit20
118F47017EDI Purchase Order Detail - Outbound131SZFYFiscal YearNumericGeneric Edit20
119F47022EDI P.O. Acknowledgment Detail - Inbound131SZFYFiscal YearNumericGeneric Edit20
120F47027EDI P.O. Acknowledgment Detail - Outbound171SZFYFiscal YearNumericGeneric Edit20
121F47032EDI Shipping Notice Detail - Inbound98SZFYFiscal YearNumericGeneric Edit20
122F47037EDI Shipping Notice Detail - Outbound149SZFYFiscal YearNumericGeneric Edit20
123F470371EDI Shipping Notice Detail - Outbound169SZFYFiscal YearNumericGeneric Edit20
124F47047EDI Invoice Detail (Sales) - Outbound171SZFYFiscal YearNumericGeneric Edit20
125F47056EDI Payment Order Header - Outbound35D1FYFiscal YearNumericGeneric Edit20
126F47056WEDI Payment Order Header - Work35D1FYFiscal YearNumericGeneric Edit20
127F47072EDI Receiving Advice Detail - Inbound132SZFYFiscal YearNumericGeneric Edit20
128F47077EDI Receiving Advice Detail - Outbound132SZFYFiscal YearNumericGeneric Edit20
129F47092EDI Request for Quote Detail - Inbound171SZFYFiscal YearNumericGeneric Edit20
130F47097EDI Request for Quote Detail - Outbound131SZFYFiscal YearNumericGeneric Edit20
131F47102EDI Response to RFQ Detail - Inbound131SZFYFiscal YearNumericGeneric Edit20
132F47107EDI Response to RFQ Detail - Outbound171SZFYFiscal YearNumericGeneric Edit20
133F47132EDI Purchase Order Change Detail - Inbound172SZFYFiscal YearNumericGeneric Edit20
134F47137EDI Purchase Order Change Detail - Outbound132SZFYFiscal YearNumericGeneric Edit20
135F47142EDI P.O. Change Acknowledgment Detail - Inbound133SZFYFiscal YearNumericGeneric Edit20
136F47147EDI P.O. Change Acknowledgment Detail - Outbound173SZFYFiscal YearNumericGeneric Edit20
137F47157EDI Shipping Schedule Detail - Outbound140SZFYFiscal YearNumericGeneric Edit20
TOP48S: Service Billing
138F4812Billing Detail Workfile18WDFYFiscal YearNumericGeneric Edit20
139F4812HBilling Workfile History18WDFYFiscal YearNumericGeneric Edit20
140F4812HSBilling Workfile History Purged Save18WDFYFiscal YearNumericGeneric Edit20
141F48S0618Payroll Reclassification Workfile66YTFYFiscal YearNumericGeneric Edit20
142F48S910Billing Detail Journal Workfile10W2FYFiscal YearNumericGeneric Edit20
143F48S911Summarized Journal Workfile11W3FYFiscal YearNumericGeneric Edit20
144F48SUI01Billing Detail Print Workfile18WDFYFiscal YearNumericGeneric Edit20
TOP51F: Advanced Job Forecasting
145F51F100Job Forecast Header19QFFYFiscal YearNumericGeneric Edit20
146F51F120Job Forecast Header History20QKFYFiscal YearNumericGeneric Edit20
TOP51X: In-Memory Project Management
147F51X0902Ledger Balances Worktable6LBFYFiscal YearNumericGeneric Edit20
TOP52: Contract Billing
148F5280Contract Revenue Summary9GWFYFiscal YearNumericGeneric Edit20
149F5280WContract Revenue Summary Work File9GYFYFiscal YearNumericGeneric Edit20
TOP70: Multi-National Products
150F704001Payment WH Info TEMP - COMM - 0422PTFYFiscal YearNumericGeneric Edit20
151F704002Payment WH Info - COMM - 0421PFFYFiscal YearNumericGeneric Edit20
152F704002PPayment WH Info Purge - COMM - 0421PFFYFiscal YearNumericGeneric Edit20
153F704003Payment Done - Accum - COMM - 049PDFYFiscal YearNumericGeneric Edit20
TOP74: EMEA Localization
154F74413VAT Ceiling Limit-Italy3VCFYFiscal YearNumericGeneric Edit20
155F74900Foreign Receivables and Payables - EMEA17RPFYFiscal YearNumericGeneric Edit20
156F74UI92WF - Account Cell Value - EMEA - 7424CVFYFiscal YearNumericGeneric Edit20
TOP74F: France
157F74F200FEC - Sequence Type by CO - Fiscal Year - FR1CFFYFiscal YearNumericGeneric Edit20
158F74F210FEC - Last Sequence Number by CO-Fiscal Period - FR1FPFYFiscal YearNumericGeneric Edit20
TOP74H: Hungary
159F741202Work File Accumulated Asset Movement Dep - HUN - 743WFFYFiscal YearNumericGeneric Edit20
160F74H309Gains & Losses Unrealized Account ing - HUN - 03B21GLFYFiscal YearNumericGeneric Edit20
161F74H409A/P Gains & Losses Unrealized Accounting - HUN - 0421GLFYFiscal YearNumericGeneric Edit20
TOP74P: Poland
162F74902TAccount Balance Tag File - COM - 09 - 74P3ATFYFiscal YearNumericGeneric Edit20
TOP74R: Russia
163F74R012Cash Documents Next Number Setup - RUS - 002CDFYFiscal YearNumericGeneric Edit20
164F74R9002Correspondence Balance - RUS- 09 - 74R4GBFYFiscal YearNumericGeneric Edit20
165F74R9029Open Accounts - RUS - 09 - 74R6OAFYFiscal YearNumericGeneric Edit20
TOP74U: United Kingdom Localizations
166F74U0212Accounting Billing Profile - 1522P8FYFiscal YearNumericGeneric Edit20
167F74U0213Weekly Accounting Profile - 1523PWFYFiscal YearNumericGeneric Edit20
168F74U0412Application Commitment Workfile - UK - 436ACFYFiscal YearNumericGeneric Edit20
169F74U0414Certificate Commitment Workfile - UK - 436CCFYFiscal YearNumericGeneric Edit20
170F74U0416Purchase Order Commitment Workfile - UK - 436PCFYFiscal YearNumericGeneric Edit20
171F74U0420SPC - Application Master - UK - 4325SEFYFiscal YearNumericGeneric Edit20
172F74U0425SPC - Certificate Master - UK - 4326SFFYFiscal YearNumericGeneric Edit20
173F74U207BPeriodic Accounting Profile Status History - 157PAFYFiscal YearNumericGeneric Edit20
174F74U207CWeekly Accounting Profile Status History - 156PHFYFiscal YearNumericGeneric Edit20
TOP74Y: Italy
175F743B14ISuspended IVA Generation - Receipt/Rebate Control-Ita - 03B33TIFYFiscal YearNumericGeneric Edit20
TOP75C: China
176F75C014AP/AR Balances - China5BAFYFiscal YearNumericGeneric Edit20
177F75C015Cash Flow Data - China19CFFYFiscal YearNumericGeneric Edit20
178F75C902Subsidiary Balances File - China3SBFYFiscal YearNumericGeneric Edit20
TOP75I: India
179F75I101TDS Certificate Work Maintenance58QBFYFiscal YearNumericGeneric Edit20
TOP76A: Argentina
180F76A392Calculated costs header - 76A3C2FYFiscal YearNumericGeneric Edit20
181F76A393Calculated costs detail - 76A3C3FYFiscal YearNumericGeneric Edit20
182F76A394Adjustments - 76A3C4FYFiscal YearNumericGeneric Edit20
TOP76B: Brazil
183F76B0411Voucher Additional Information Brazil - 0410VBFYFiscal YearNumericGeneric Edit20
184F76B0770ICMS Period Balance by State and Company4ICFYFiscal YearNumericGeneric Edit20
185F76B0771IPI Period Balance by Company3IPFYFiscal YearNumericGeneric Edit20
186F76B473TF04573 Brazilian Temp WH File - BR - 0412W3FYFiscal YearNumericGeneric Edit20
187F76B837FCONT Account Balances - 76B3FBFYFiscal YearNumericGeneric Edit20
TOP76C: Colombia
188F76C0003VAT Certificates Retention - COL - 76C7CRFYFiscal YearNumericGeneric Edit20
189F76C031AA/R Customer ledger As Of - F76C031A - COL - 0411RPFYFiscal YearNumericGeneric Edit20
190F76C034AA/R Check Detail file As Of - COL - 03B16RZFYFiscal YearNumericGeneric Edit20
191F76C0902Debits and Credits T/B by object account - COL - 76C3GBFYFiscal YearNumericGeneric Edit20
192F76C575Work File Magnetic Media - COL - 044Q1FYFiscal YearNumericGeneric Edit20
193F76C9415Workfile for Dialy Book - COL - 0919LDFYFiscal YearNumericGeneric Edit20
194F76C9F02DIAN Formats by AccountID - COL - 0915DFFYFiscal YearNumericGeneric Edit20
195F76C9F11DIAN Formats File by Account Id - COL - 094DFFYFiscal YearNumericGeneric Edit20
196F76CT1Tributary Information - COL - 76C4TIFYFiscal YearNumericGeneric Edit20
197F76CT3VAT Certificates Retention - Work File - COL - 76C3T3FYFiscal YearNumericGeneric Edit20
TOP76H: Chile
198F76H6112Actual Item ASOF File - CHI - 41 - 76H2ANFYFiscal YearNumericGeneric Edit20
199F76H902TAccount Balances Tag File - CHI - 09 - 76H3ATFYFiscal YearNumericGeneric Edit20
TOP76P: Peru
200F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P2CZFYFiscal YearNumericGeneric Edit20
TOP76V: Venezuela
201F76V4581Withholding Historical File - VEN - 048HRFYFiscal YearNumericGeneric Edit20
202F76V4583Withholdings I.S.L.R. Fee 2 - VEN - 044TDFYFiscal YearNumericGeneric Edit20
203F76VTARTTemporal Table for Withholdings - VEN -04 - 76V8TRFYFiscal YearNumericGeneric Edit20
TOP79A: Greenhouse Gas Accounting
204F79A11GHG Ledger19GRFYFiscal YearNumericGeneric Edit20
205F79A11Z1GHG Ledger - Batch File37GLFYFiscal YearNumericGeneric Edit20
206F79A12GHG Ledger Audit20GRFYFiscal YearNumericGeneric Edit20
207F79AU11GHG Ledger Work Table22GRFYFiscal YearNumericGeneric Edit20
TOP83: Management Reporting - FASTR
208F83UI001Balance Audit Work File - (Financial Reporting)11R1FYFiscal YearNumericGeneric Edit20
TOP89: Conversion Programs
209F0902AAccount Debit Balances3GDFYFiscal YearNumericGeneric Edit20
210F43199ATemp F43199 for ERP 9.0 Upgrade117OLFYFiscal YearNumericGeneric Edit20