JDE TABLES

JD Edwards Enterprise One table definition reference

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

182 columns | Print definition?812 | 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
13F03B11Z1Invoice Transactions - Batch File29VJFYFiscal YearNumericGeneric Edit20
14F03B11Z2F03B11 Interoperability Table24SYFYFiscal YearNumericGeneric Edit20
15F03B13Receipts Header File15RYFYFiscal YearNumericGeneric Edit20
16F03B13PReceipts Header Purge File15RYFYFiscal YearNumericGeneric Edit20
17F03B13Z2F03B13 Interoperability Table28SYFYFiscal YearNumericGeneric Edit20
18F03B14A/R Check Detail File16RZFYFiscal 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 Remittance Work File - One World Only18RDFYFiscal 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 File33VLFYFiscal 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
40F06278Retro Timecard Detail File66YTFYFiscal YearNumericGeneric Edit20
41F06290Payroll Accounting Journal Work File13YRFYFiscal YearNumericGeneric Edit20
42F063951Payroll Journal (Compressed) File5GLFYFiscal YearNumericGeneric Edit20
TOP06: Payroll (old) - Obsolete-do not reuse
43F069096Payroll General Constants23YKFYFiscal YearNumericGeneric Edit20
TOP07: Payroll
44F05290WF - Payroll Journal (Detail)5JRFYFiscal YearNumericGeneric Edit20
45F07491Payroll - Accounts Payable Summary File21J6FYFiscal YearNumericGeneric Edit20
46F07900Non Calendar Tax Fiscal Date Patterns2NCFYFiscal YearNumericGeneric Edit20
47F07UI200Timecard History Work File69THFYFiscal YearNumericGeneric Edit20
TOP08P: Position Control
48F08101Position Master1HPFYFiscal YearNumericGeneric Edit20
49F081012Position Accounts1HCFYFiscal YearNumericGeneric Edit20
50F08101PPurge - Position Master1HPFYFiscal YearNumericGeneric Edit20
TOP08R: Recruitment Management - (Appl. Track. & Req.)
51F08102Requisition Information5HNFYFiscal YearNumericGeneric Edit20
TOP09: General Accounting
52F0902BAccount Balances - 52 Period Accounting3GBFYFiscal YearNumericGeneric Edit20
53F0902PPurge - Account Balances3GBFYFiscal YearNumericGeneric Edit20
54F0902Z1Account Balances - Batch File3GBFYFiscal YearNumericGeneric Edit20
55F0911PPurge - Account Ledger25GLFYFiscal YearNumericGeneric Edit20
56F0911RWF - Acct Ledger File for Reconciliation25GLFYFiscal YearNumericGeneric Edit20
57F0911Z1Journal Entry Transactions - Batch File42VNFYFiscal YearNumericGeneric Edit20
58F0911Z4F0911 Interoperability Table47SZFYFiscal YearNumericGeneric Edit20
59F0912Cost Allocations/Flex Budgeting38RJFYFiscal YearNumericGeneric Edit20
60F0912AIndex Computation Entry File33RIFYFiscal YearNumericGeneric Edit20
61F09UI004Variable Numerator Allocations work file16R#FYFiscal YearNumericGeneric Edit20
62F09UI014Annual Close Work Table7GBFYFiscal YearNumericGeneric Edit20
63F09UI015Indexed Computations Multi-Tiered Entries25GLFYFiscal YearNumericGeneric Edit20
64F09UI016Account Balance Compare Exceptions9GWFYFiscal YearNumericGeneric Edit20
65F70UI001Work File for G/L by Cat. Code Localization2WAFYFiscal YearNumericGeneric Edit20
66F740911Work File for G/L Report by Category Code Localization2WAFYFiscal YearNumericGeneric Edit20
TOP10: Financial Reporting
67F1001Multi-Site Consolidation Transfer File Header12GPFYFiscal YearNumericGeneric Edit20
68F1001Z1Unedited MSC Interoperability Header Table22IAFYFiscal YearNumericGeneric Edit20
TOP12: Fixed Assets
69F1202Asset Account Balances File3FLFYFiscal YearNumericGeneric Edit20
70F1202PAsset Account Balances Purge Table3FLFYFiscal YearNumericGeneric Edit20
TOP14: Modeling - Planning & Budgeting
71F14041Forecast Results - Detail8BZFYFiscal YearNumericGeneric Edit20
TOP15L: Adv Real Estate Forecasting
72F15L108AREF Base Account Definition5ADFYFiscal YearNumericGeneric Edit20
73F15L109AREF Budget Results4BRFYFiscal YearNumericGeneric Edit20
74F15L110AREF Account Status5ASFYFiscal YearNumericGeneric Edit20
75F15L111AREF Account Status Detail5ADFYFiscal YearNumericGeneric Edit20
76F15L118AREF Base Account Definition Detail5DDFYFiscal YearNumericGeneric Edit20
77F15L38AREF EP Billing Register8NZFYFiscal YearNumericGeneric Edit20
TOP16: Profit Management (EPS)
78F1603Cost Analyzer View Structure15CVFYFiscal YearNumericGeneric Edit20
TOP17: Customer Service Management
79F1794Billing/Amort Control Master8NKFYFiscal YearNumericGeneric Edit20
TOP18: Resource Scheduling
80F186602Labor Rules Tag File76TFFYFiscal YearNumericGeneric Edit20
TOP40: Inventory/OP Base
81F4011ZBatch Receiver File - Order Details170SZFYFiscal YearNumericGeneric Edit20
82F41112Item ASOF File2INFYFiscal YearNumericGeneric Edit20
83F4211Z1Sales Order Detail Unedited Transaction File156SZFYFiscal YearNumericGeneric Edit20
TOP41: Inventory Management
84F4115Item History4IHFYFiscal YearNumericGeneric Edit20
85F41UI001Inventory Transactions Detail File159ITFYFiscal YearNumericGeneric Edit20
TOP42: Sales Management
86F4211Sales Order Detail File143SDFYFiscal YearNumericGeneric Edit20
87F42119Sales Order History File143SDFYFiscal YearNumericGeneric Edit20
88F42199S.O. Detail Ledger File143SLFYFiscal YearNumericGeneric Edit20
89F4229Sales Summary History File14SSFYFiscal YearNumericGeneric Edit20
90F42800G1Sales Update G Batch Detail Workfile17DGFYFiscal YearNumericGeneric Edit20
91F42UI01SO Header Cache File (MBF)111ZHFYFiscal YearNumericGeneric Edit20
92F42UI11SO Detail Cache File (MBF)102ZDFYFiscal YearNumericGeneric Edit20
93F42UI800Sales Detail Work File - Sales Update33SDFYFiscal YearNumericGeneric Edit20
TOP43: Procurement
94F43080Approvals Fields Constants121PDFYFiscal YearNumericGeneric Edit20
95F4311Purchase Order Detail File117PDFYFiscal YearNumericGeneric Edit20
96F4311ZPurchase Order Generator File121PWFYFiscal YearNumericGeneric Edit20
97F4311Z1Purchase Order Detail Unedited Transaction Table130SZFYFiscal YearNumericGeneric Edit20
98F4316Purchase Order Multiple Account File16P3FYFiscal YearNumericGeneric Edit20
99F43199P.O. Detail Ledger File - Flexible Version117OLFYFiscal YearNumericGeneric Edit20
TOP43E: Requisition Self Service
100F43E16Requisition Multiple Account File17P3FYFiscal YearNumericGeneric Edit20
TOP44H: Homebuilder Management
101F44H611Bid Details59BDFYFiscal YearNumericGeneric Edit20
102F44H611WBid Details Work File63BWFYFiscal YearNumericGeneric Edit20
103F44H711Lot Start Workfile67SWFYFiscal YearNumericGeneric Edit20
104F44H711ZHB Lot Start Unedited Transaction File80SZFYFiscal YearNumericGeneric Edit20
105F44H71W1Lot Start Generation Workfile67GWFYFiscal YearNumericGeneric Edit20
TOP47: Electronic Commerce
106F47012EDI Purchase Order Detail - Inbound171SZFYFiscal YearNumericGeneric Edit20
107F47017EDI Purchase Order Detail - Outbound131SZFYFiscal YearNumericGeneric Edit20
108F47022EDI P.O. Acknowledgment Detail - Inbound131SZFYFiscal YearNumericGeneric Edit20
109F47027EDI P.O. Acknowledgment Detail - Outbound171SZFYFiscal YearNumericGeneric Edit20
110F47032EDI Shipping Notice Detail - Inbound98SZFYFiscal YearNumericGeneric Edit20
111F47037EDI Shipping Notice Detail - Outbound149SZFYFiscal YearNumericGeneric Edit20
112F470371EDI Shipping Notice Detail - Outbound169SZFYFiscal YearNumericGeneric Edit20
113F47047EDI Invoice Detail (Sales) - Outbound171SZFYFiscal YearNumericGeneric Edit20
114F47056EDI Payment Order Header - Outbound35D1FYFiscal YearNumericGeneric Edit20
115F47056WEDI Payment Order Header - Work35D1FYFiscal YearNumericGeneric Edit20
116F47072EDI Receiving Advice Detail - Inbound132SZFYFiscal YearNumericGeneric Edit20
117F47077EDI Receiving Advice Detail - Outbound132SZFYFiscal YearNumericGeneric Edit20
118F47092EDI Request for Quote Detail - Inbound171SZFYFiscal YearNumericGeneric Edit20
119F47097EDI Request for Quote Detail - Outbound131SZFYFiscal YearNumericGeneric Edit20
120F47102EDI Response to RFQ Detail - Inbound131SZFYFiscal YearNumericGeneric Edit20
121F47107EDI Response to RFQ Detail - Outbound171SZFYFiscal YearNumericGeneric Edit20
122F47132EDI Purchase Order Change Detail - Inbound172SZFYFiscal YearNumericGeneric Edit20
123F47137EDI Purchase Order Change Detail - Outbound132SZFYFiscal YearNumericGeneric Edit20
124F47142EDI P.O. Change Acknowledgment Detail - Inbound133SZFYFiscal YearNumericGeneric Edit20
125F47147EDI P.O. Change Acknowledgment Detail - Outbound173SZFYFiscal YearNumericGeneric Edit20
126F47157EDI Shipping Schedule Detail - Outbound140SZFYFiscal YearNumericGeneric Edit20
TOP48S: Service Billing
127F4812Billing Detail Workfile18WDFYFiscal YearNumericGeneric Edit20
128F4812HBilling Workfile - History18WDFYFiscal YearNumericGeneric Edit20
129F4812HSBilling Workfile History Purged Save18WDFYFiscal YearNumericGeneric Edit20
130F48S0618Payroll Reclassification Workfile66YTFYFiscal YearNumericGeneric Edit20
131F48S910Billing Detail Journal File10W2FYFiscal YearNumericGeneric Edit20
132F48S911Compressed Journal File11W3FYFiscal YearNumericGeneric Edit20
133F48SUI01Billing Detail Print Workfile18WDFYFiscal YearNumericGeneric Edit20
TOP52: Contract Billing
134F5280Contract Revenue Summary File9GWFYFiscal YearNumericGeneric Edit20
135F5280WContract Revenue Summary Work File9GYFYFiscal YearNumericGeneric Edit20
TOP55: Reserved for Clients
136F550200Correspondent Accounts Report6WFFYFiscal YearNumericGeneric Edit20
137F55IF311As Of95RPFYFiscal YearNumericGeneric Edit20
138F55IF421Sales Order per BO159SDFYFiscal YearNumericGeneric Edit20
139F55IF425Sales Order per BO - 2005159SDFYFiscal YearNumericGeneric Edit20
140F55W0100Correction Invoice Print - WF1144SDFYFiscal YearNumericGeneric Edit20
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
TOP74: EMEA Localization
149F74413VAT Ceiling Limit-Italy3VCFYFiscal YearNumericGeneric Edit20
150F74900Foreign Receivables and Payables - EMEA17RPFYFiscal YearNumericGeneric Edit20
151F74UI92WF - Account Cell Value - EMEA - 7424CVFYFiscal YearNumericGeneric Edit20
TOP74H: Hungary
152F741202Work File Accumulated Asset Movement Dep - HUN - 743WFFYFiscal YearNumericGeneric Edit20
TOP74P: Poland
153F74902TAccount Balance Tag File - COM - 09 - 74P3ATFYFiscal YearNumericGeneric Edit20
TOP74R: CIS
154F74R9002Correspondence Balance - RUS- 09 - 74R4GBFYFiscal YearNumericGeneric Edit20
155F74R9029Open Accounts - RUS - 09 - 74R6OAFYFiscal YearNumericGeneric Edit20
TOP74U: United Kingdom Localizations
156F74U0212Accounting Billing Profile - 1522P8FYFiscal YearNumericGeneric Edit20
157F74U0213Weekly Accounting Profile - 1523PWFYFiscal YearNumericGeneric Edit20
158F74U207BPeriodic Accounting Profile Status History - 157PAFYFiscal YearNumericGeneric Edit20
159F74U207CWeekly Accounting Profile Status History - 156PHFYFiscal YearNumericGeneric Edit20
TOP74Y: Italy - Reporting System Only
160F743B14ISuspended IVA Generation - Receipt/Rebate Control-Italy33TIFYFiscal YearNumericGeneric Edit20
TOP76A: Argentina
161F76A392Calculated costs header - 76A3C2FYFiscal YearNumericGeneric Edit20
162F76A393Calculated costs detail - 76A3C3FYFiscal YearNumericGeneric Edit20
163F76A394Adjustments - 76A3C4FYFiscal YearNumericGeneric Edit20
TOP76B: Brazil - Reporting System Only
164F76B0411Voucher Additional Information Brazil - 0410VBFYFiscal YearNumericGeneric Edit20
165F76B473TF04573 Brazilian Temp WH File - BR - 0412W3FYFiscal YearNumericGeneric Edit20
TOP76C: Colombia
166F76C0003VAT Certificates Retention - COL - 76C7CRFYFiscal YearNumericGeneric Edit20
167F76C031AA/R Customer ledger As Of - F76C031A - COL - 0411RPFYFiscal YearNumericGeneric Edit20
168F76C034AA/R Check Detail file As Of - COL - 76C16RZFYFiscal YearNumericGeneric Edit20
169F76C0902Debits and Credits T/B by object account - COL - 76C3GBFYFiscal YearNumericGeneric Edit20
170F76C575Work File Magnetic Media - COL - 044Q1FYFiscal YearNumericGeneric Edit20
171F76C9415Workfile for Dialy Book - COL - 0919LDFYFiscal YearNumericGeneric Edit20
172F76CT1Tributary Information - COL - 76C4TIFYFiscal YearNumericGeneric Edit20
173F76CT3VAT Certificates Retention - Work File - COL - 76C3T3FYFiscal YearNumericGeneric Edit20
TOP76H: Chile
174F76H6112Actual Item ASOF File - CHI - 41 - 76H2ANFYFiscal YearNumericGeneric Edit20
175F76H902TAccount Balances Tag File - CHI - 09 - 76H3ATFYFiscal YearNumericGeneric Edit20
TOP76P: Peru
176F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P2CZFYFiscal YearNumericGeneric Edit20
TOP76V: Venezuela
177F76V4581Withholding Historical File - VEN - 048HRFYFiscal YearNumericGeneric Edit20
178F76V4583Withholdings I.S.L.R. Fee 2 - VEN - 044TDFYFiscal YearNumericGeneric Edit20
179F76VTARTTemporal Table for Withholdings - VEN -04 - 76V8TRFYFiscal YearNumericGeneric Edit20
TOP83: Management Reporting - FASTR
180F83UI001Balance Audit Work File - (Financial Reporting)11R1FYFiscal YearNumericGeneric Edit20
TOP89: Conversion Programs
181F0902AAccount Debit Balances3GDFYFiscal YearNumericGeneric Edit20
182F43199ATemp F43199 for ERP 9.0 Upgrade117OLFYFiscal YearNumericGeneric Edit20