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

205 columns | Print definition?812 | SBLT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0902Account Balances38GBSBLTSubledger TypeCharacterUDC10
2F0911Account Ledger21GLSBLTSubledger TypeCharacterUDC10
3F4096Sales Flex Accounting11FASBLTSubledger TypeCharacterUDC10
TOP03: Accounts Receivable
4F0311Accounts Receivable Ledger52RPSBLTSubledger TypeCharacterUDC10
TOP03B: Enhanced Accounts Receivable
5F03B11Customer Ledger53RPSBLTSubledger TypeCharacterUDC10
6F03B11PCustomer Ledger Purge File53RPSBLTSubledger TypeCharacterUDC10
7F03B11Z1Invoice Transactions - Batch File70VJSBLTSubledger TypeCharacterUDC10
8F03B11Z2F03B11 Interoperability Table66SYSBLTSubledger TypeCharacterUDC10
9F03B14A/R Check Detail File70RZSBLTSubledger TypeCharacterUDC10
10F03B14PReceipts Detail Purge File70RZSBLTSubledger TypeCharacterUDC10
11F03B14Z2F03B14 Interoperability Table83SZSBLTSubledger TypeCharacterUDC10
12F03B575Auto Debit Invoice Select and Build62RDSBLTSubledger TypeCharacterUDC10
13F09UI011Receipt Prepost Work File16GLSBLTSubledger TypeCharacterUDC10
TOP04: Accounts Payable
14F0411Accounts Payable Ledger51RPSBLTSubledger TypeCharacterUDC10
15F0411AWF - As Of - Accounts Payable Ledger51RPSBLTSubledger TypeCharacterUDC10
16F0411PPurge - Accounts Payable Ledger51RPSBLTSubledger TypeCharacterUDC10
17F0411Z1Voucher Transactions - Batch File69VLSBLTSubledger TypeCharacterUDC10
18F0411Z3F0411 Interoperability Table74SZSBLTSubledger TypeCharacterUDC10
19F09UI005Tax Offsets User Index35GLSBLTSubledger TypeCharacterUDC10
TOP05: Time Accounting and HRM Base
20F06106Employee Pay Instructions75YMSBLTSubledger TypeCharacterUDC10
21F0618Employee Transaction History18YTSBLTSubledger TypeCharacterUDC10
TOP05T: Time Entry
22F06116Employee Transaction Detail File18YTSBLTSubledger TypeCharacterUDC10
23F06116Z1Employee Transactions - Batch File35VLSBLTSubledger TypeCharacterUDC10
24F0623Piecework History File4JLSBLTSubledger TypeCharacterUDC10
25F0624Burden Distribution File12J#SBLTSubledger TypeCharacterUDC10
26F06241Burden Distribution File12J#SBLTSubledger TypeCharacterUDC10
27F06278Retro Timecard Detail File21YTSBLTSubledger TypeCharacterUDC10
28F06290Payroll Accounting Journal Work File8YRSBLTSubledger TypeCharacterUDC10
29F063951Payroll Journal (Compressed) File25GLSBLTSubledger TypeCharacterUDC10
30F06904Automatic Accounting Instructions15Y#SBLTSubledger TypeCharacterUDC10
31F069161Item Master Cross Reference File3JESBLTSubledger TypeCharacterUDC10
TOP07: Payroll
32F05290WF - Payroll Journal (Detail)25JRSBLTSubledger TypeCharacterUDC10
33F06490Payroll/Accounts Payable Ledger Detail23JRSBLTSubledger TypeCharacterUDC10
34F06491Payroll/Accounts Payable Ledger Detail16J6SBLTSubledger TypeCharacterUDC10
35F0716701Employee Assignment T/E Template Information17EASBLTSubledger TypeCharacterUDC10
36F0716709Employee Assignment T/E Template Info History17EASBLTSubledger TypeCharacterUDC10
37F0724Burden Distribution File15YSSBLTSubledger TypeCharacterUDC10
38F07241Burden Distribution File15YSSBLTSubledger TypeCharacterUDC10
39F07490Payroll - Accounts Payable Detail (One World)23JRSBLTSubledger TypeCharacterUDC10
40F07491Payroll - Accounts Payable Summary File16J6SBLTSubledger TypeCharacterUDC10
41F07UI200Timecard History Work File21THSBLTSubledger TypeCharacterUDC10
TOP08AD: ADP Integration
42F051371ADP Employee DBA Instructions80ADSBLTSubledger TypeCharacterUDC10
TOP08P: Position Control
43F081012Position Accounts5HCSBLTSubledger TypeCharacterUDC10
TOP09: General Accounting
44F0902BAccount Balances - 52 Period Accounting78GBSBLTSubledger TypeCharacterUDC10
45F0902PPurge - Account Balances38GBSBLTSubledger TypeCharacterUDC10
46F0902Z1Account Balances - Batch File41GBSBLTSubledger TypeCharacterUDC10
47F0911PPurge - Account Ledger21GLSBLTSubledger TypeCharacterUDC10
48F0911RWF - Acct Ledger File for Reconciliation21GLSBLTSubledger TypeCharacterUDC10
49F0911Z1Journal Entry Transactions - Batch File38VNSBLTSubledger TypeCharacterUDC10
50F0911Z4F0911 Interoperability Table43SZSBLTSubledger TypeCharacterUDC10
51F0912Cost Allocations/Flex Budgeting48RJSBLTSubledger TypeCharacterUDC10
52F0912AIndex Computation Entry File53RISBLTSubledger TypeCharacterUDC10
53F0912BVariable Allocation File16R#SBLTSubledger TypeCharacterUDC10
54F0917Bank Statement Detail36GDSBLTSubledger TypeCharacterUDC10
55F09617Auto Bank Statement Detail39GMSBLTSubledger TypeCharacterUDC10
56F09UI004Variable Numerator Allocations work file13R#SBLTSubledger TypeCharacterUDC10
57F09UI015Indexed Computations Multi-Tiered Entries21GLSBLTSubledger TypeCharacterUDC10
58F09UI016Account Balance Compare Exceptions6GWSBLTSubledger TypeCharacterUDC10
59F70UI001Work File for G/L by Cat. Code Localization10WASBLTSubledger TypeCharacterUDC10
60F740911Work File for G/L Report by Category Code Localization13WASBLTSubledger TypeCharacterUDC10
TOP09E: Expense Reimbursment
61F09E150Credit Card Transaction Interface Table10CISBLTSubledger TypeCharacterUDC10
62F20112Expense Report Detail60EDSBLTSubledger TypeCharacterUDC10
TOP10: Financial Reporting
63F1002Multi-Site Consolidation Transfer File12GQSBLTSubledger TypeCharacterUDC10
64F1002Z1Unedited MSC Interoperability Table21SZSBLTSubledger TypeCharacterUDC10
65F10471Elimination Rules (OW)9ERSBLTSubledger TypeCharacterUDC10
66F10UI006MSC - F1002 Elimination Work File11GESBLTSubledger TypeCharacterUDC10
TOP12: Fixed Assets
67F12002Default Accounting Constants22FDSBLTSubledger TypeCharacterUDC10
68F12003Default Depreciation Constants19FFSBLTSubledger TypeCharacterUDC10
69F1202Asset Account Balances File45FLSBLTSubledger TypeCharacterUDC10
70F1202PAsset Account Balances Purge Table45FLSBLTSubledger TypeCharacterUDC10
71F1204Location Tracking Table29FMSBLTSubledger TypeCharacterUDC10
72F1204PLocation Tracking Purge Table29FMSBLTSubledger TypeCharacterUDC10
73F12911ERPost G/L to FA Exceptions Work File20GLSBLTSubledger TypeCharacterUDC10
TOP13: Plant/Equipment Management
74F12120Z1Unedited Meter Reading Transactions23SZSBLTSubledger TypeCharacterUDC10
75F1304Equipment Location Billing10FNSBLTSubledger TypeCharacterUDC10
76F1305Equipment Distribution Rules10FVSBLTSubledger TypeCharacterUDC10
77F1306Meter Reading Estimates8F5SBLTSubledger TypeCharacterUDC10
78F1306PMeter Reading Estimates Purge Table8F5SBLTSubledger TypeCharacterUDC10
TOP13E: Equipment Cost Analysis
79F1383Equipment Analysis Costs8ECSBLTSubledger TypeCharacterUDC10
TOP15: Property Management
80F1502Recurring Billings Master54NFSBLTSubledger TypeCharacterUDC10
81F1502BRecurring Billings Master50NFSBLTSubledger TypeCharacterUDC10
82F1502WBEstimated EP Recurring Billing Work File (OneWorld)53N4SBLTSubledger TypeCharacterUDC10
83F1511Tenant/Lease Billings Detail55NJSBLTSubledger TypeCharacterUDC10
84F1511BTenant/Lease Billings Detail Master51NJSBLTSubledger TypeCharacterUDC10
85F1511HTenant/Lease Billings Detail History55N#SBLTSubledger TypeCharacterUDC10
86F1511HBTenant/Lease Billings Detail History51NCSBLTSubledger TypeCharacterUDC10
87F1532BExpense Participation Audit File15NTSBLTSubledger TypeCharacterUDC10
TOP15L: Adv Real Estate Forecasting
88F15L109AREF Budget Results6BRSBLTSubledger TypeCharacterUDC10
89F15L110AREF Account Status7ASSBLTSubledger TypeCharacterUDC10
90F15L111AREF Account Status Detail7ADSBLTSubledger TypeCharacterUDC10
TOP16: Profit Management (EPS)
91F1602Cost Analyzer Balances7CBSBLTSubledger TypeCharacterUDC10
92F1602Z1External Cost Analyzer Balances - Interoperability Table29CZSBLTSubledger TypeCharacterUDC10
93F1610Cost Calculation Definitions21CDSBLTSubledger TypeCharacterUDC10
94F1611Cost Calculation Transactions16CTSBLTSubledger TypeCharacterUDC10
95F1630Driver Definitions26CDSBLTSubledger TypeCharacterUDC10
96F1632Driver Balances7CBSBLTSubledger TypeCharacterUDC10
97F1632Z1External Driver Balances-Interoperability Table29CYSBLTSubledger TypeCharacterUDC10
98F16421Rate Master Detail File12RDSBLTSubledger TypeCharacterUDC10
TOP17: Customer Service Management
99F1721Contract Detail22CDSBLTSubledger TypeCharacterUDC10
TOP17C: Call Management
100F1760Time Entry2ZBSBLTSubledger TypeCharacterUDC10
TOP18: Resource Scheduling
101F186301Timecard Templates19TTSBLTSubledger TypeCharacterUDC10
102F186602Labor Rules Tag File32TFSBLTSubledger TypeCharacterUDC10
TOP40: Inventory/OP Base
103F4011ZBatch Receiver File - Order Details199SZSBLTSubledger TypeCharacterUDC10
104F4211Z1Sales Order Detail Unedited Transaction File178SZSBLTSubledger TypeCharacterUDC10
105F43800Summary Voucher Match11PRSBLTSubledger TypeCharacterUDC10
TOP41: Inventory Management
106F4111Item Ledger File58ILSBLTSubledger TypeCharacterUDC10
107F41UI001Inventory Transactions Detail File167ITSBLTSubledger TypeCharacterUDC10
TOP42: Sales Management
108F4211Sales Order Detail File165SDSBLTSubledger TypeCharacterUDC10
109F42119Sales Order History File165SDSBLTSubledger TypeCharacterUDC10
110F42199S.O. Detail Ledger File165SLSBLTSubledger TypeCharacterUDC10
111F42800G1Sales Update G Batch Detail Workfile21DGSBLTSubledger TypeCharacterUDC10
112F42UI12Sales Order Detail Cache 2 (MBF)59ZDSBLTSubledger TypeCharacterUDC10
113F42UI521Pick Slips Detail File116S9SBLTSubledger TypeCharacterUDC10
114F470371TTag for F470371- EDI shipping Notice Detail - Outbound57UZSBLTSubledger TypeCharacterUDC10
TOP42B: Sales Order Entry
115F42420Audit Log Transaction67ALSBLTSubledger TypeCharacterUDC10
TOP43: Procurement
116F40910Commitment Integrity Report Work File5P#SBLTSubledger TypeCharacterUDC10
117F43080Approvals Fields Constants5PDSBLTSubledger TypeCharacterUDC10
118F4311Purchase Order Detail File130PDSBLTSubledger TypeCharacterUDC10
119F4311ZPurchase Order Generator File134PWSBLTSubledger TypeCharacterUDC10
120F4311Z1Purchase Order Detail Unedited Transaction Table143SZSBLTSubledger TypeCharacterUDC10
121F43121Purchase Order Receiver File54PRSBLTSubledger TypeCharacterUDC10
122F43121ZReceiver workfile45PWSBLTSubledger TypeCharacterUDC10
123F43121Z1Receipts Unedited Transaction Table71SZSBLTSubledger TypeCharacterUDC10
124F4314ZVoucher Match Selection File154PNSBLTSubledger TypeCharacterUDC10
125F4316Purchase Order Multiple Account File13P3SBLTSubledger TypeCharacterUDC10
126F4316MModel Purchase Order Multiple Account File6P4SBLTSubledger TypeCharacterUDC10
127F43199P.O. Detail Ledger File - Flexible Version130OLSBLTSubledger TypeCharacterUDC10
128F43UI50DPO Print Detail Work File41PWSBLTSubledger TypeCharacterUDC10
TOP43A: Purchase Order Receipt/Routing
129F43126Purchase Order Receiver Multiple Account15P4SBLTSubledger TypeCharacterUDC10
TOP43E: Requisition Self Service
130F43E16Requisition Multiple Account File14P3SBLTSubledger TypeCharacterUDC10
TOP43Q: Strategic Sourcing
131F43Q11Event Detail17EDSBLTSubledger TypeCharacterUDC10
TOP44H: Homebuilder Management
132F4453Lot Master (World)19JBSBLTSubledger TypeCharacterUDC10
133F44H590Closing Worksheet Accounting Instructions11CISBLTSubledger TypeCharacterUDC10
134F44H591Closing Worksheet Entries14CWSBLTSubledger TypeCharacterUDC10
135F44H73W1Lot Start - P.O. / Committment Generation Work File46CGSBLTSubledger TypeCharacterUDC10
136F44H73W2Lot Start - Budget Generation Workfile6BGSBLTSubledger TypeCharacterUDC10
TOP45: Advanced Pricing
137F4575Ship and Debit History53AHSBLTSubledger TypeCharacterUDC10
138F4575TMPShip and Debit History - Temp Table53AHSBLTSubledger TypeCharacterUDC10
139F4576Ship and Debit Claims81ACSBLTSubledger TypeCharacterUDC10
140F4576TMPShip and Debit Claims- Temp Table81ACSBLTSubledger TypeCharacterUDC10
141F4576Z1Ship and Debit Claims Unedited Transaction Table78Z1SBLTSubledger TypeCharacterUDC10
TOP47: Electronic Commerce
142F47012EDI Purchase Order Detail - Inbound200SZSBLTSubledger TypeCharacterUDC10
143F47017EDI Purchase Order Detail - Outbound144SZSBLTSubledger TypeCharacterUDC10
144F47022EDI P.O. Acknowledgment Detail - Inbound144SZSBLTSubledger TypeCharacterUDC10
145F47027EDI P.O. Acknowledgment Detail - Outbound200SZSBLTSubledger TypeCharacterUDC10
146F47042EDI Invoice Detail - Inbound56SZSBLTSubledger TypeCharacterUDC10
147F47047EDI Invoice Detail (Sales) - Outbound200SZSBLTSubledger TypeCharacterUDC10
148F47057EDI Payment Order Remittance Advice - Outbound102D3SBLTSubledger TypeCharacterUDC10
149F47057WEDI Payment Order Remittance Advice - Work102D3SBLTSubledger TypeCharacterUDC10
150F47072EDI Receiving Advice Detail - Inbound145SZSBLTSubledger TypeCharacterUDC10
151F47077EDI Receiving Advice Detail - Outbound145SZSBLTSubledger TypeCharacterUDC10
152F47092EDI Request for Quote Detail - Inbound200SZSBLTSubledger TypeCharacterUDC10
153F47097EDI Request for Quote Detail - Outbound144SZSBLTSubledger TypeCharacterUDC10
154F47102EDI Response to RFQ Detail - Inbound144SZSBLTSubledger TypeCharacterUDC10
155F47107EDI Response to RFQ Detail - Outbound199SZSBLTSubledger TypeCharacterUDC10
156F47122EDI Product Activity Data Detail - Inbound71MJSBLTSubledger TypeCharacterUDC10
157F47127EDI Product Activity Data Detail - Outbound71MJSBLTSubledger TypeCharacterUDC10
158F47132EDI Purchase Order Change Detail - Inbound201SZSBLTSubledger TypeCharacterUDC10
159F47137EDI Purchase Order Change Detail - Outbound145SZSBLTSubledger TypeCharacterUDC10
160F47142EDI P.O. Change Acknowledgment Detail - Inbound146SZSBLTSubledger TypeCharacterUDC10
161F47147EDI P.O. Change Acknowledgment Detail - Outbound202SZSBLTSubledger TypeCharacterUDC10
162F47157EDI Shipping Schedule Detail - Outbound153SZSBLTSubledger TypeCharacterUDC10
TOP48S: Service Billing
163F4812Billing Detail Workfile12WDSBLTSubledger TypeCharacterUDC10
164F4812HBilling Workfile - History12WDSBLTSubledger TypeCharacterUDC10
165F4812HSBilling Workfile History Purged Save12WDSBLTSubledger TypeCharacterUDC10
166F4822Invoice Summary Work File20W4SBLTSubledger TypeCharacterUDC10
167F4823Voucher Summary18W0SBLTSubledger TypeCharacterUDC10
168F48S0618Payroll Reclassification Workfile18YTSBLTSubledger TypeCharacterUDC10
169F48S910Billing Detail Journal File20W2SBLTSubledger TypeCharacterUDC10
170F48S911Compressed Journal File18W3SBLTSubledger TypeCharacterUDC10
171F48S912G/L Link File4W6SBLTSubledger TypeCharacterUDC10
172F48S95Billing AAI Information19WVSBLTSubledger TypeCharacterUDC10
173F48SUI01Billing Detail Print Workfile12WDSBLTSubledger TypeCharacterUDC10
TOP51: Job Costing
174F5144Profit Recognition4G7SBLTSubledger TypeCharacterUDC10
175F51911Draw Reporting Master10GKSBLTSubledger TypeCharacterUDC10
TOP52: Contract Billing
176F5202Contract Billing Line Detail21G6SBLTSubledger TypeCharacterUDC10
177F5212T and M - Unit Price and Lumpsum Cross Reference Accounts12G5SBLTSubledger TypeCharacterUDC10
178F5280WContract Revenue Summary Work File21GYSBLTSubledger TypeCharacterUDC10
TOP53: Change Management
179F5302F5302 World Specs15DKSBLTSubledger TypeCharacterUDC10
TOP55: Reserved for Clients
180F74TL004Trial Balance Temp File11TBSBLTSubledger TypeCharacterUDC10
181F74T531Customer Ledger Tranaction File13CTSBLTSubledger TypeCharacterUDC10
182F74T532Supplier Ledger Transaction File13SLSBLTSubledger TypeCharacterUDC10
183F74T550General Ledger Work File - Turkish24DKSBLTSubledger TypeCharacterUDC10
TOP74: EMEA Localization
184F74900Foreign Receivables and Payables - EMEA60RPSBLTSubledger TypeCharacterUDC10
185F74S55Expenses and Exchange Rate for Payments - Spain10Q5SBLTSubledger TypeCharacterUDC10
TOP74H: Hungary
186F741202Work File Accumulated Asset Movement Dep - HUN - 747WFSBLTSubledger TypeCharacterUDC10
TOP74P: Poland
187F74902TAccount Balance Tag File - COM - 09 - 74P7ATSBLTSubledger TypeCharacterUDC10
TOP74R: CIS
188F74R9002Correspondence Balance - RUS- 09 - 74R42GBSBLTSubledger TypeCharacterUDC10
189F74R9029Open Accounts - RUS - 09 - 74R9OASBLTSubledger TypeCharacterUDC10
TOP76B: Brazil - Reporting System Only
190F7611BNota Fiscal Detail - Brazil94FDSBLTSubledger TypeCharacterUDC10
191F76B901IN86- Work Table for Account Master - 096BASBLTSubledger TypeCharacterUDC10
192F76B902IN86-Work Table for Account Balance - 097BCSBLTSubledger TypeCharacterUDC10
193F76B911IN86-Work Table for Journal Entries - 097BDSBLTSubledger TypeCharacterUDC10
TOP76C: Colombia
194F76C031AA/R Customer ledger As Of - F76C031A - COL - 0452RPSBLTSubledger TypeCharacterUDC10
195F76C034AA/R Check Detail file As Of - COL - 76C115RZSBLTSubledger TypeCharacterUDC10
196F76C0902Debits and Credits T/B by object account - COL - 76C19GBSBLTSubledger TypeCharacterUDC10
197F76C575Work File Magnetic Media - COL - 0420Q1SBLTSubledger TypeCharacterUDC10
198F76CT1Tributary Information - COL - 76C19TISBLTSubledger TypeCharacterUDC10
TOP76H: Chile
199F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H10I1SBLTSubledger TypeCharacterUDC10
200F76H6003Indirect Costs Selection EPS F1642 - CHI - 41 - 76H21I2SBLTSubledger TypeCharacterUDC10
201F76H6005Account ID / Cost Type Relationship - CHI - 41 - 76H4ACSBLTSubledger TypeCharacterUDC10
202F76H902TAccount Balances Tag File - CHI - 09 - 76H7ATSBLTSubledger TypeCharacterUDC10
TOP83: Management Reporting - FASTR
203F83UI001Balance Audit Work File - (Financial Reporting)13R1SBLTSubledger TypeCharacterUDC10
TOP89: Conversion Programs
204F0902AAccount Debit Balances7GDSBLTSubledger TypeCharacterUDC10
205F43199ATemp F43199 for ERP 9.0 Upgrade130OLSBLTSubledger TypeCharacterUDC10

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / ST (Subledger Type) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1         AAddress Book NumberN
2         CBusiness Unit Number
3         EEquipment Number
4         FCall NumberY
5         GService Contract HeaderY
6         IItem Number (Short)
7         JJob Change Request
8         LLease Number
9         MSummarized Work Order NumberN
10         OOrder Number
11         SStructured Subledger
12         UUnit Number
13         WWork Order Number
14         XUser Defined Subledger Type
15         Y- Another User Defined Type
16         Z- Define Types As Needed