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
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

224 columns | Print definition?910 | LOCN

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP12: Fixed Assets
1F1217Equipment Master Extension54WRLOCNLocationStringGeneric Edit200
2F1217PEquipment Master Extension Purge Table54WRLOCNLocationStringGeneric Edit200
3F1217Z1Unedited Equipment Tag Transactions58WRLOCNLocationStringGeneric Edit200
4F1217Z2Unedited Equipment Tag Transactions58WRLOCNLocationStringGeneric Edit200
TOP13: Plant/Equipment Management
5F13017Equipment Parts List11PLLOCNLocationStringGeneric Edit200
TOP17: Customer Service Management
6F3111Z2Warranty Claim/Supplier Recovery processing46WPLOCNLocationStringGeneric Edit200
7F3112Z2Warranty Claim/Supplier Recovery processing97WLLOCNLocationStringGeneric Edit200
8F4801Z2Warranty Claim/Supplier Recovery processing35WSLOCNLocationStringGeneric Edit200
TOP30: Product Data Management
9F30006Work Center Master File4IWLOCNLocationStringGeneric Edit200
10F30006Z1Work Center Transaction File17SZLOCNLocationStringGeneric Edit200
11F300211Lean Multi Level Bill of Material Detail61EDLOCNLocationStringGeneric Edit200
12F300311Lean Multi-Level Routing Detail File41EHLOCNLocationStringGeneric Edit200
13F3003TRouting Tag File - not used in B9 - obsolete in B109IRLOCNLocationStringGeneric Edit200
14F3003Z1Routing Transactions File57SZLOCNLocationStringGeneric Edit200
15F3016Kanban Master9KMLOCNLocationStringGeneric Edit200
TOP30A: Product Costing
16F300261Item Cost Component Detail5IELOCNLocationStringGeneric Edit200
TOP31: Shop Floor Control
17F3105Work Order LSN8ISLOCNLocationStringGeneric Edit200
18F3105SPurge Work Order LSN8ISLOCNLocationStringGeneric Edit200
19F3111Work Order Parts List33WMLOCNLocationStringGeneric Edit200
20F3111SPurge - Shop Floor Parts List33WMLOCNLocationStringGeneric Edit200
21F3111Z1Outbound Work Order Parts List46SZLOCNLocationStringGeneric Edit200
22F3112Work Order Routing79WLLOCNLocationStringGeneric Edit200
23F3112SPurge Shop Floor Control Routing Instructions79WLLOCNLocationStringGeneric Edit200
24F3112STPurge Shop Floor Control Routing Instructions Tag Table10WLLOCNLocationStringGeneric Edit200
25F3112TShop Floor Control Routing Instructions Tag Table - Needed f10WLLOCNLocationStringGeneric Edit200
26F3112Z1Outbound Work Order Routings97SZLOCNLocationStringGeneric Edit200
TOP31B: Blend Management
27F31B03Barrel Master Table11BMLOCNLocationStringGeneric Edit200
28F31B03EBarrel Inquiry Work File5BELOCNLocationStringGeneric Edit200
29F31B053Consumable Assignments9CALOCNLocationStringGeneric Edit200
30F31B07EUR Master File41EULOCNLocationStringGeneric Edit200
31F31B08Tank Master13TMLOCNLocationStringGeneric Edit200
32F31B101VBT Detail8VDLOCNLocationStringGeneric Edit200
33F31B110Mass Barrel Update16MBLOCNLocationStringGeneric Edit200
34F31B45Additive Templates16ATLOCNLocationStringGeneric Edit200
35F31B46Consumable Templates13CTLOCNLocationStringGeneric Edit200
36F31B66Blend Transactions56BTLOCNLocationStringGeneric Edit200
37F31B84Operation Additives12OALOCNLocationStringGeneric Edit200
38F31B85Weigh Tag Master38WTLOCNLocationStringGeneric Edit200
39F31B88Inventory By Vessel Workfile8IVLOCNLocationStringGeneric Edit200
40F31B98Bottling Master5BMLOCNLocationStringGeneric Edit200
41F31B99Decant Detail6DDLOCNLocationStringGeneric Edit200
TOP32: Configuration Management
42F3215Configurator Component Table17CCLOCNLocationStringGeneric Edit200
43F32159Configurator Component History Table17CHLOCNLocationStringGeneric Edit200
TOP34: Requirements Planning
44F43213SRS Ship Dates16VPLOCNLocationStringGeneric Edit200
TOP37: Quality Management
45F3703Non-Conforming Material5QELOCNLocationStringGeneric Edit200
46F3711Test Results10TRLOCNLocationStringGeneric Edit200
47F3711Z1Test Results Unedited Transaction Table23SZLOCNLocationStringGeneric Edit200
48F37900Certificate of Analysis (COA) Extract11TRLOCNLocationStringGeneric Edit200
TOP38: Agreement Management
49F38111Agreements Transaction Ledger9DZLOCNLocationStringGeneric Edit200
TOP40: Inventory/OP Base
50F30026Item Cost Component Add-Ons5IELOCNLocationStringGeneric Edit200
51F3003Routing Master File55IRLOCNLocationStringGeneric Edit200
52F30UI006Lot Tracking Work File25ILLOCNLocationStringGeneric Edit200
53F40052Return Material Authorization Defaults7RVLOCNLocationStringGeneric Edit200
54F4011ZBatch Receiver File - Order Details52SZLOCNLocationStringGeneric Edit200
55F4012ZWWF - Destination Quantity24SPLOCNLocationStringGeneric Edit200
56F40320Preference Profile - Multi Shipping/Receiving Locations15LPLOCNLocationStringGeneric Edit200
57F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations16LPLOCNLocationStringGeneric Edit200
58F4100Location Master2LMLOCNLocationStringGeneric Edit200
59F4106Item Base Price File5BPLOCNLocationStringGeneric Edit200
60F41112Item ASOF File8INLOCNLocationStringGeneric Edit200
61F4171Critical Hold Management3I1LOCNLocationStringGeneric Edit200
62F4211Z1Sales Order Detail Unedited Transaction File49SZLOCNLocationStringGeneric Edit200
63F4220Basic Serial Numbers9SWLOCNLocationStringGeneric Edit200
TOP41: Inventory Management
64F4101AItem File86IMLOCNLocationStringGeneric Edit200
65F4101Z1F4101 Item Master Unedited Transaction Table184SZLOCNLocationStringGeneric Edit200
66F41021Item Location File3LILOCNLocationStringGeneric Edit200
67F410211Project Commitment Detail Table5PCLOCNLocationStringGeneric Edit200
68F41021AItem Location File - Temporary Upgrade3LILOCNLocationStringGeneric Edit200
69F41021TItem Location Tag File5LTLOCNLocationStringGeneric Edit200
70F41021WFF41021 Transaction Workfile7LWLOCNLocationStringGeneric Edit200
71F41021Z1Item Location Unedited Transaction File16SZLOCNLocationStringGeneric Edit200
72F41023Item Location Definition Table3ILLOCNLocationStringGeneric Edit200
73F4105Item Cost File5COLOCNLocationStringGeneric Edit200
74F41051Average Cost Work file4CHLOCNLocationStringGeneric Edit200
75F4105Z1Unedited Transaction Table - Item Cost18SZLOCNLocationStringGeneric Edit200
76F4111Item Ledger File6ILLOCNLocationStringGeneric Edit200
77F41113Lot Ledger8I8LOCNLocationStringGeneric Edit200
78F4141Cycle Count Transaction File7PJLOCNLocationStringGeneric Edit200
79F4141TCycle Count Transaction Tag File7PCLOCNLocationStringGeneric Edit200
80F4141Z1F4141 Cycle Count Unedited Transaction Table20SZLOCNLocationStringGeneric Edit200
81F4160Tag Inventory File5ITLOCNLocationStringGeneric Edit200
82F41UI001Inventory Transactions Detail File17ITLOCNLocationStringGeneric Edit200
83F41UI002Inventory Transactions Batch File7TILOCNLocationStringGeneric Edit200
TOP41B: Bulk Stock Management
84F41512Gain/Loss Transactions File13PTLOCNLocationStringGeneric Edit200
TOP41F: Apparel Management
85FCW103Style WO Component Scrap Information5WMLOCNLocationStringGeneric Edit200
86FCW11Item Base Price File Work File4WPLOCNLocationStringGeneric Edit200
87FCW12Item Cost File Work File4WCLOCNLocationStringGeneric Edit200
88FCW13Item Location Work File4WLLOCNLocationStringGeneric Edit200
89FCW20Matrix Work File21WXLOCNLocationStringGeneric Edit200
90FCW21Work File Confirm Shipments8WKLOCNLocationStringGeneric Edit200
91FCW22Lot Master Work File5WLLOCNLocationStringGeneric Edit200
92FCW31Proposal Order Line Details13LVLOCNLocationStringGeneric Edit200
93FCW33Price List Header14PHLOCNLocationStringGeneric Edit200
94FCW34Price List Detail14PDLOCNLocationStringGeneric Edit200
95FCW45Matrix Purchase Order Other Location9OLLOCNLocationStringGeneric Edit200
96FCW64WO Receipts Matrix Entry Work File24WXLOCNLocationStringGeneric Edit200
97FCW65Work Order Header for Style Items17OFLOCNLocationStringGeneric Edit200
98FCW67Style Work Order Parts List39WMLOCNLocationStringGeneric Edit200
99FCW85Item Cost Component Add Ons Work File6IELOCNLocationStringGeneric Edit200
100FCW93Copy to Outsource Operations for Style Items7STLOCNLocationStringGeneric Edit200
TOP42: Sales Management
101F420UI55Kit Balance Work File10UILOCNLocationStringGeneric Edit200
102F4211Sales Order Detail File36SDLOCNLocationStringGeneric Edit200
103F42119Sales Order History File36SDLOCNLocationStringGeneric Edit200
104F42199S.O. Detail Ledger File36SLLOCNLocationStringGeneric Edit200
105F42UI11SO Detail Cache File (MBF)39ZDLOCNLocationStringGeneric Edit200
106F42UI12Sales Order Detail Cache 2 (MBF)72ZDLOCNLocationStringGeneric Edit200
107F42UI521Pick Slips Detail File31S9LOCNLocationStringGeneric Edit200
108F42UI800Sales Detail Work File - Sales Update41SDLOCNLocationStringGeneric Edit200
TOP42B: Sales Order Entry
109F42420Audit Log Transaction23ALLOCNLocationStringGeneric Edit200
TOP42W: Fulfillment Management
110F427UI01Release Fulfillment Work File44RFLOCNLocationStringGeneric Edit200
TOP43: Procurement
111F41291Item Cost Components6IGLOCNLocationStringGeneric Edit200
112F43080Approvals Fields Constants46PDLOCNLocationStringGeneric Edit200
113F43092Purchase Order Receipt Routing File22PXLOCNLocationStringGeneric Edit200
114F43092Z1Receipt Routing Unedited Transaction Table35SZLOCNLocationStringGeneric Edit200
115F4311Purchase Order Detail File38PDLOCNLocationStringGeneric Edit200
116F4311ZPurchase Order Generator File42PWLOCNLocationStringGeneric Edit200
117F4311Z1Purchase Order Detail Unedited Transaction Table51SZLOCNLocationStringGeneric Edit200
118F43121Purchase Order Receiver File18PRLOCNLocationStringGeneric Edit200
119F43121ZReceiver workfile23PWLOCNLocationStringGeneric Edit200
120F43121Z1Receipts Unedited Transaction Table35SZLOCNLocationStringGeneric Edit200
121F4314ZVoucher Match Selection File117PNLOCNLocationStringGeneric Edit200
122F43199P.O. Detail Ledger File - Flexible Version38OLLOCNLocationStringGeneric Edit200
TOP43Q: Strategic Sourcing
123F43Q90Sourcing Constants7SCLOCNLocationStringGeneric Edit200
124F43Q92Adhoc Item Definition4AILOCNLocationStringGeneric Edit200
TOP45: Advanced Pricing
125F4574Key Reference Table9KRLOCNLocationStringGeneric Edit200
TOP46: Warehouse Management
126F4142Warehouse Count Transactions5CTLOCNLocationStringGeneric Edit200
127F46012Fixed Locations5ISLOCNLocationStringGeneric Edit200
128F4602Location Detail Information3IFLOCNLocationStringGeneric Edit200
129F46021Location Characteristics3LQLOCNLocationStringGeneric Edit200
130F46026Allowed Containers by Location2ACLOCNLocationStringGeneric Edit200
131F46027Available Space Tiebreaker4AVLOCNLocationStringGeneric Edit200
132F46029Proximity Tiebreaker4LPLOCNLocationStringGeneric Edit200
133F46051Fixed Replenisment Zones2LYLOCNLocationStringGeneric Edit200
134F46130Putaway Reservations12R3LOCNLocationStringGeneric Edit200
135F46130PUPutaway Reservations - Purged12R3LOCNLocationStringGeneric Edit200
136F46821Random Locations3LXLOCNLocationStringGeneric Edit200
TOP46L: License Plating
137F46L10License Plate Master5LMLOCNLocationStringGeneric Edit200
138F46L11License Plate Item Detail5IDLOCNLocationStringGeneric Edit200
139F46L12License Plate Commitment14LCLOCNLocationStringGeneric Edit200
140F46L30Location Capacity2LCLOCNLocationStringGeneric Edit200
141F46L42License Plate Cycle and Tag Count5CCLOCNLocationStringGeneric Edit200
142F46L99License Plate History6LMLOCNLocationStringGeneric Edit200
143F46LUI01Assign/Remove Items To LP Work File9WFLOCNLocationStringGeneric Edit200
144F46LUI03Assign/Remove Child LP Work File9WFLOCNLocationStringGeneric Edit200
TOP47: Electronic Commerce
145F47012EDI Purchase Order Detail - Inbound53SZLOCNLocationStringGeneric Edit200
146F47017EDI Purchase Order Detail - Outbound52SZLOCNLocationStringGeneric Edit200
147F47022EDI P.O. Acknowledgment Detail - Inbound52SZLOCNLocationStringGeneric Edit200
148F47027EDI P.O. Acknowledgment Detail - Outbound53SZLOCNLocationStringGeneric Edit200
149F47032EDI Shipping Notice Detail - Inbound51SZLOCNLocationStringGeneric Edit200
150F47037EDI Shipping Notice Detail - Outbound53SZLOCNLocationStringGeneric Edit200
151F470371EDI Shipping Notice Detail - Outbound59SZLOCNLocationStringGeneric Edit200
152F47042EDI Invoice Detail - Inbound33SZLOCNLocationStringGeneric Edit200
153F47047EDI Invoice Detail (Sales) - Outbound53SZLOCNLocationStringGeneric Edit200
154F47072EDI Receiving Advice Detail - Inbound53SZLOCNLocationStringGeneric Edit200
155F47077EDI Receiving Advice Detail - Outbound53SZLOCNLocationStringGeneric Edit200
156F47092EDI Request for Quote Detail - Inbound53SZLOCNLocationStringGeneric Edit200
157F47097EDI Request for Quote Detail - Outbound52SZLOCNLocationStringGeneric Edit200
158F47102EDI Response to RFQ Detail - Inbound52SZLOCNLocationStringGeneric Edit200
159F47107EDI Response to RFQ Detail - Outbound53SZLOCNLocationStringGeneric Edit200
160F47122EDI Product Activity Data Detail - Inbound25MJLOCNLocationStringGeneric Edit200
161F47127EDI Product Activity Data Detail - Outbound25MJLOCNLocationStringGeneric Edit200
162F47132EDI Purchase Order Change Detail - Inbound54SZLOCNLocationStringGeneric Edit200
163F47137EDI Purchase Order Change Detail - Outbound53SZLOCNLocationStringGeneric Edit200
164F47142EDI P.O. Change Acknowledgment Detail - Inbound54SZLOCNLocationStringGeneric Edit200
165F47147EDI P.O. Change Acknowledgment Detail - Outbound55SZLOCNLocationStringGeneric Edit200
166F47157EDI Shipping Schedule Detail - Outbound55SZLOCNLocationStringGeneric Edit200
TOP48: Work Order Processing
167F4801Work Order Master File16WALOCNLocationStringGeneric Edit200
168F4801SPurge - Work Order Master file16WALOCNLocationStringGeneric Edit200
169F4801Z1Outbound Work Order Header35SYLOCNLocationStringGeneric Edit200
170F48UI001X4801 Master Business Function Workfile19WALOCNLocationStringGeneric Edit200
TOP49: Transportation Management
171F4963Load In-transit16TILOCNLocationStringGeneric Edit200
172F49631Load In-transit Ledger35TOLOCNLocationStringGeneric Edit200
TOP55: Reserved for Clients
173F74H1051Invoicing Workfile - New13IWLOCNLocationStringGeneric Edit200
TOP70: Multi-National Products - obsolete-do not reuse
174F702033Sales Document Line Tag File - COMM - 4213D1LOCNLocationStringGeneric Edit200
TOP75C: China - Reporting System Only
175F75C4106Chinese Free Goods VAT base price - F75C4106 - 414IBLOCNLocationStringGeneric Edit200
TOP75I: India
176F75I301Excise - Setup Master4Q1LOCNLocationStringGeneric Edit200
177F75I309Personal Consumption - CENVAT setoff - IND - 4120CSLOCNLocationStringGeneric Edit200
178F75I312Excise - Consignment/ Adjustment Detail File - ItemWise13Q1LOCNLocationStringGeneric Edit200
179F75I312YExcise-Consignment/Adjustment Detail -Item wise15Q1LOCNLocationStringGeneric Edit200
180F75I314YExcise - RG23A - II Item Wise Transaction File9Q1LOCNLocationStringGeneric Edit200
181F75I316YExcise - PLA Item Wise Transaction File9Q2LOCNLocationStringGeneric Edit200
182F75I318YExcise - RG23C - II Item Wise Transaction File9Q3LOCNLocationStringGeneric Edit200
183F75I319YExcise - Consolidated Excise Duty Payment18Q1LOCNLocationStringGeneric Edit200
184F75I322Excise - Work File for F04211 & F41017Q3LOCNLocationStringGeneric Edit200
185F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)7Q3LOCNLocationStringGeneric Edit200
186F75I3451Excise - ARE3 Form Detail-IND-0011QDLOCNLocationStringGeneric Edit200
187F75I346Excise - D3-Form Table27Q9LOCNLocationStringGeneric Edit200
188F75I3574Consignment - Issues/Receipts Transactions23CTLOCNLocationStringGeneric Edit200
189F75I380Excise - RG-1 - Transaction File - IND24RGLOCNLocationStringGeneric Edit200
190F75I385RG23D Register - Issues - IND - 4229EDLOCNLocationStringGeneric Edit200
191F75I3901Work With Consignment - IND -4322COLOCNLocationStringGeneric Edit200
192F75I403Stock Transfer Details24ABLOCNLocationStringGeneric Edit200
193F75I403TTemp Data for F75i40327ABLOCNLocationStringGeneric Edit200
194F75I409Personal Consumption - VAT setoff - IND - 4115VSLOCNLocationStringGeneric Edit200
195F75I4213Setoff Report Data -IND -003SOLOCNLocationStringGeneric Edit200
196F75I791Item - Supplier Cost Components - IND - 43B7ISLOCNLocationStringGeneric Edit200
TOP76A: Argentina
197F76A393Calculated costs detail - 76A8C3LOCNLocationStringGeneric Edit200
198F76A394Adjustments - 76A8C4LOCNLocationStringGeneric Edit200
TOP76B: Brazil - Reporting System Only
199F7611BNota Fiscal Detail - BRA - 4228FDLOCNLocationStringGeneric Edit200
200F761BAAS Fiscal file book - 0932FBLOCNLocationStringGeneric Edit200
201F76412Item Branch Regional Information - Brazil - 413IJLOCNLocationStringGeneric Edit200
TOP76H: Chile
202F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H26I1LOCNLocationStringGeneric Edit200
203F76H6003Indirect Costs Selection EPS F1642 - CHI - 41 - 76H27I2LOCNLocationStringGeneric Edit200
204F76H6004Item Cost Component WF - CHI - 41 - 76H6ICLOCNLocationStringGeneric Edit200
205F76H6008Manufactured Items - CHI - 41 - 76H6IPLOCNLocationStringGeneric Edit200
206F76H6105Item Actual Cost File - CHI - 41 - 76H6ACLOCNLocationStringGeneric Edit200
207F76H611Actual Item Ledger File - CHI - 41 - 76H6ALLOCNLocationStringGeneric Edit200
208F76H6112Actual Item ASOF File - CHI - 41 - 76H8ANLOCNLocationStringGeneric Edit200
209F76H6205Item Replacement Cost - CHI - 416IRLOCNLocationStringGeneric Edit200
TOP76P: Peru
210F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P7CZLOCNLocationStringGeneric Edit200
TOP89: Conversion Programs
211F3294Needed for upgrade from Xe and below3KZLOCNLocationStringGeneric Edit200
212F32943Needed for upgrade from Xe and below3KOLOCNLocationStringGeneric Edit200
213F4100TOBSOLETE - Location Master Tag File2LMLOCNLocationStringGeneric Edit200
214F43199ATemp F43199 for ERP 9.0 Upgrade38OLLOCNLocationStringGeneric Edit200
TOPF30L: DFM Line Design
215FF30L930DFM Routings55LRLOCNLocationStringGeneric Edit200
TOPF31: Lean Transactions
216FF31010Production Master File9EHLOCNLocationStringGeneric Edit200
217FF31011TransactionID Master File21EHLOCNLocationStringGeneric Edit200
218FF31011SPurge - TransactionID Master File21ERLOCNLocationStringGeneric Edit200
219FF31111Lean Transaction Parts List34PLLOCNLocationStringGeneric Edit200
220FF31111SPurge - Lean Transaction Parts List34PRLOCNLocationStringGeneric Edit200
221FF31112Routing Transaction Table61EHLOCNLocationStringGeneric Edit200
222FF31112SPurge - Routing Transaction Table61ETLOCNLocationStringGeneric Edit200
TOPH91: Design Tools
223F98TC01Table Conversion UnNormalized3TCLOCNLocationStringGeneric Edit200
224F98TC03Table Conversion Normalized 23TNLOCNLocationStringGeneric Edit200