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

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