JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

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

201 columns | Print definition?812 | 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
13F3003Z1Routing Transactions File57SZLOCNLocationStringGeneric Edit200
14F3016Kanban Master9KMLOCNLocationStringGeneric Edit200
TOP30A: Product Costing
15F300261Item Cost Component Detail5IELOCNLocationStringGeneric Edit200
TOP31: Shop Floor Control
16F3105Work Order LSN8ISLOCNLocationStringGeneric Edit200
17F3105SPurge Work Order LSN8ISLOCNLocationStringGeneric Edit200
18F3111Work Order Parts List33WMLOCNLocationStringGeneric Edit200
19F3111SPurge - Shop Floor Parts List33WMLOCNLocationStringGeneric Edit200
20F3111Z1Outbound Work Order Parts List46SZLOCNLocationStringGeneric Edit200
21F3112Work Order Routing79WLLOCNLocationStringGeneric Edit200
22F3112SPurge Shop Floor Control Routing Instructions79WLLOCNLocationStringGeneric Edit200
23F3112STPurge Shop Floor Control Routing Instructions Tag Table10WLLOCNLocationStringGeneric Edit200
24F3112TShop Floor Control Routing Instructions Tag Table10WLLOCNLocationStringGeneric Edit200
25F3112Z1Outbound Work Order Routings97SZLOCNLocationStringGeneric Edit200
26F4801SPurge - Work Order Master file16WALOCNLocationStringGeneric Edit200
27F4801Z1Outbound Work Order Header35SYLOCNLocationStringGeneric Edit200
TOP31B: Blend Management
28F31B03Barrel Master Table11BMLOCNLocationStringGeneric Edit200
29F31B03EBarrel Inquiry Work File5BELOCNLocationStringGeneric Edit200
30F31B053Consumable Assignments9CALOCNLocationStringGeneric Edit200
31F31B07EUR Master File41EULOCNLocationStringGeneric Edit200
32F31B08Tank Master13TMLOCNLocationStringGeneric Edit200
33F31B101VBT Detail8VDLOCNLocationStringGeneric Edit200
34F31B110Mass Barrel Update16MBLOCNLocationStringGeneric Edit200
35F31B66Blend Transactions56BTLOCNLocationStringGeneric Edit200
36F31B84Operation Additives12OALOCNLocationStringGeneric Edit200
37F31B85Weigh Tag Master38WTLOCNLocationStringGeneric Edit200
38F31B85TWeigh Tag Master Tag Table6WTLOCNLocationStringGeneric Edit200
39F31B86Inventory By Vessel WorkFile8IVLOCNLocationStringGeneric Edit200
40F31B88Inventory By Vessel Workfile8IVLOCNLocationStringGeneric Edit200
41F31B98Bottling Master5BMLOCNLocationStringGeneric Edit200
42F31B99Decant Detail6DDLOCNLocationStringGeneric Edit200
TOP32: Configuration Management
43F3215Configurator Component Table17CCLOCNLocationStringGeneric Edit200
44F32159Configurator Component History Table17CHLOCNLocationStringGeneric Edit200
45F3294Configured String History File3KZLOCNLocationStringGeneric Edit200
46F32943Configured String History - OneWorld3KOLOCNLocationStringGeneric Edit200
TOP34: Requirements Planning
47F43213SRS Ship Dates16VPLOCNLocationStringGeneric Edit200
TOP37: Quality Management
48F3703Non-Conforming Material5QELOCNLocationStringGeneric Edit200
49F3711Test Results10TRLOCNLocationStringGeneric Edit200
50F3711Z1Test Results Unedited Transaction Table23SZLOCNLocationStringGeneric Edit200
51F37900Certificate of Analysis (COA) Extract11TRLOCNLocationStringGeneric Edit200
TOP38: Agreement Management
52F38111Agreements Transaction Ledger9DZLOCNLocationStringGeneric Edit200
TOP40: Inventory/OP Base
53F30026Item Cost Component Add-Ons5IELOCNLocationStringGeneric Edit200
54F3003Routing Master File55IRLOCNLocationStringGeneric Edit200
55F3003TRouting Tag File9IRLOCNLocationStringGeneric Edit200
56F30UI006Lot Tracking Work File25ILLOCNLocationStringGeneric Edit200
57F40052Return Material Authorization Defaults7RVLOCNLocationStringGeneric Edit200
58F4011ZBatch Receiver File - Order Details52SZLOCNLocationStringGeneric Edit200
59F4012ZWWF - Destination Quantity24SPLOCNLocationStringGeneric Edit200
60F40320Preference Profile - Multi Shipping/Receiving Locations15LPLOCNLocationStringGeneric Edit200
61F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations16LPLOCNLocationStringGeneric Edit200
62F4100Location Master2LMLOCNLocationStringGeneric Edit200
63F4106Item Base Price File5BPLOCNLocationStringGeneric Edit200
64F41112Item ASOF File8INLOCNLocationStringGeneric Edit200
65F4171Critical Hold Management3I1LOCNLocationStringGeneric Edit200
66F4211Z1Sales Order Detail Unedited Transaction File49SZLOCNLocationStringGeneric Edit200
67F4220Basic Serial Numbers9SWLOCNLocationStringGeneric Edit200
TOP41: Inventory Management
68F4100TLocation Master Tag File2LMLOCNLocationStringGeneric Edit200
69F4101AItem File86IMLOCNLocationStringGeneric Edit200
70F4101Z1F4101 Item Master Unedited Transaction Table184SZLOCNLocationStringGeneric Edit200
71F41021Item Location File3LILOCNLocationStringGeneric Edit200
72F410211Project Commitment Detail Table5PCLOCNLocationStringGeneric Edit200
73F41021AItem Location File - Temporary Upgrade3LILOCNLocationStringGeneric Edit200
74F41021WFF41021 Transaction Workfile7LWLOCNLocationStringGeneric Edit200
75F41021Z1Item Location Unedited Transaction File16SZLOCNLocationStringGeneric Edit200
76F41023Item Location Definition Table3ILLOCNLocationStringGeneric Edit200
77F4105Item Cost File5COLOCNLocationStringGeneric Edit200
78F41051Average Cost Work file4CHLOCNLocationStringGeneric Edit200
79F4105Z1Unedited Transaction Table - Item Cost18SZLOCNLocationStringGeneric Edit200
80F4111Item Ledger File6ILLOCNLocationStringGeneric Edit200
81F41113Lot Ledger8I8LOCNLocationStringGeneric Edit200
82F4141Cycle Count Transaction File7PJLOCNLocationStringGeneric Edit200
83F4141Z1F4141 Cycle Count Unedited Transaction Table20SZLOCNLocationStringGeneric Edit200
84F4160Tag Inventory File5ITLOCNLocationStringGeneric Edit200
85F41UI001Inventory Transactions Detail File17ITLOCNLocationStringGeneric Edit200
86F41UI002Inventory Transactions Batch File7TILOCNLocationStringGeneric Edit200
TOP41B: Bulk Stock Management
87F41512Gain/Loss Transactions File13PTLOCNLocationStringGeneric Edit200
TOP42: Sales Management
88F4211Sales Order Detail File36SDLOCNLocationStringGeneric Edit200
89F42119Sales Order History File36SDLOCNLocationStringGeneric Edit200
90F42199S.O. Detail Ledger File36SLLOCNLocationStringGeneric Edit200
91F42UI11SO Detail Cache File (MBF)39ZDLOCNLocationStringGeneric Edit200
92F42UI12Sales Order Detail Cache 2 (MBF)72ZDLOCNLocationStringGeneric Edit200
93F42UI130Commitment Work File19ZCLOCNLocationStringGeneric Edit200
94F42UI521Pick Slips Detail File31S9LOCNLocationStringGeneric Edit200
95F42UI800Sales Detail Work File - Sales Update41SDLOCNLocationStringGeneric Edit200
TOP42B: Sales Order Entry
96F42420Audit Log Transaction23ALLOCNLocationStringGeneric Edit200
TOP43: Procurement
97F41291Item Cost Components6IGLOCNLocationStringGeneric Edit200
98F43080Approvals Fields Constants46PDLOCNLocationStringGeneric Edit200
99F43092Purchase Order Receipt Routing File22PXLOCNLocationStringGeneric Edit200
100F43092Z1Receipt Routing Unedited Transaction Table35SZLOCNLocationStringGeneric Edit200
101F4311Purchase Order Detail File38PDLOCNLocationStringGeneric Edit200
102F4311ZPurchase Order Generator File42PWLOCNLocationStringGeneric Edit200
103F4311Z1Purchase Order Detail Unedited Transaction Table51SZLOCNLocationStringGeneric Edit200
104F43121Purchase Order Receiver File18PRLOCNLocationStringGeneric Edit200
105F43121ZReceiver workfile23PWLOCNLocationStringGeneric Edit200
106F43121Z1Receipts Unedited Transaction Table35SZLOCNLocationStringGeneric Edit200
107F4314ZVoucher Match Selection File117PNLOCNLocationStringGeneric Edit200
108F43199P.O. Detail Ledger File - Flexible Version38OLLOCNLocationStringGeneric Edit200
TOP43Q: Strategic Sourcing
109F43Q90Sourcing Constants7SCLOCNLocationStringGeneric Edit200
110F43Q92Adhoc Item Definition4AILOCNLocationStringGeneric Edit200
TOP45: Advanced Pricing
111F4574Key Reference Table9KRLOCNLocationStringGeneric Edit200
TOP46: Warehouse Management
112F4142Warehouse Count Transactions5CTLOCNLocationStringGeneric Edit200
113F46012Fixed Locations5ISLOCNLocationStringGeneric Edit200
114F4602Location Detail Information3IFLOCNLocationStringGeneric Edit200
115F46021Location Characteristics3LQLOCNLocationStringGeneric Edit200
116F46026Allowed Containers by Location2ACLOCNLocationStringGeneric Edit200
117F46027Available Space Tiebreaker4AVLOCNLocationStringGeneric Edit200
118F46029Proximity Tiebreaker4LPLOCNLocationStringGeneric Edit200
119F46051Fixed Replenisment Zones2LYLOCNLocationStringGeneric Edit200
120F46130Putaway Reservations12R3LOCNLocationStringGeneric Edit200
121F46130PUPutaway Reservations - Purged12R3LOCNLocationStringGeneric Edit200
122F46821Random Locations3LXLOCNLocationStringGeneric Edit200
TOP46L: License Plating
123F46L10License Plate Master5LMLOCNLocationStringGeneric Edit200
124F46L11License Plate Item Detail5IDLOCNLocationStringGeneric Edit200
125F46L12License Plate Commitment14LCLOCNLocationStringGeneric Edit200
126F46L30Location Capacity2LCLOCNLocationStringGeneric Edit200
127F46L42License Plate Cycle and Tag Count5CCLOCNLocationStringGeneric Edit200
128F46L99License Plate History6LMLOCNLocationStringGeneric Edit200
129F46LUI01Assign/Remove Items To LP Work File9WFLOCNLocationStringGeneric Edit200
130F46LUI03Assign/Remove Child LP Work File9WFLOCNLocationStringGeneric Edit200
TOP47: Electronic Commerce
131F47012EDI Purchase Order Detail - Inbound53SZLOCNLocationStringGeneric Edit200
132F47017EDI Purchase Order Detail - Outbound52SZLOCNLocationStringGeneric Edit200
133F47022EDI P.O. Acknowledgment Detail - Inbound52SZLOCNLocationStringGeneric Edit200
134F47027EDI P.O. Acknowledgment Detail - Outbound53SZLOCNLocationStringGeneric Edit200
135F47032EDI Shipping Notice Detail - Inbound51SZLOCNLocationStringGeneric Edit200
136F47037EDI Shipping Notice Detail - Outbound53SZLOCNLocationStringGeneric Edit200
137F470371EDI Shipping Notice Detail - Outbound59SZLOCNLocationStringGeneric Edit200
138F47042EDI Invoice Detail - Inbound33SZLOCNLocationStringGeneric Edit200
139F47047EDI Invoice Detail (Sales) - Outbound53SZLOCNLocationStringGeneric Edit200
140F47072EDI Receiving Advice Detail - Inbound53SZLOCNLocationStringGeneric Edit200
141F47077EDI Receiving Advice Detail - Outbound53SZLOCNLocationStringGeneric Edit200
142F47092EDI Request for Quote Detail - Inbound53SZLOCNLocationStringGeneric Edit200
143F47097EDI Request for Quote Detail - Outbound52SZLOCNLocationStringGeneric Edit200
144F47102EDI Response to RFQ Detail - Inbound52SZLOCNLocationStringGeneric Edit200
145F47107EDI Response to RFQ Detail - Outbound53SZLOCNLocationStringGeneric Edit200
146F47122EDI Product Activity Data Detail - Inbound25MJLOCNLocationStringGeneric Edit200
147F47127EDI Product Activity Data Detail - Outbound25MJLOCNLocationStringGeneric Edit200
148F47132EDI Purchase Order Change Detail - Inbound54SZLOCNLocationStringGeneric Edit200
149F47137EDI Purchase Order Change Detail - Outbound53SZLOCNLocationStringGeneric Edit200
150F47142EDI P.O. Change Acknowledgment Detail - Inbound54SZLOCNLocationStringGeneric Edit200
151F47147EDI P.O. Change Acknowledgment Detail - Outbound55SZLOCNLocationStringGeneric Edit200
152F47157EDI Shipping Schedule Detail - Outbound55SZLOCNLocationStringGeneric Edit200
TOP48: Work Order Processing
153F4801Work Order Master File16WALOCNLocationStringGeneric Edit200
154F48UI001X4801 Master Business Function Workfile19WALOCNLocationStringGeneric Edit200
TOP49: Transportation Management
155F4963Load In-transit16TILOCNLocationStringGeneric Edit200
156F49631Load In-transit Ledger35TOLOCNLocationStringGeneric Edit200
TOP55: Reserved for Clients
157F55BC02AP55BC02 Bevet worktable8BELOCNLocationStringGeneric Edit200
158F55BC03DLeltar tetelsor tabla3LDLOCNLocationStringGeneric Edit200
159F55IF421Sales Order per BO42SDLOCNLocationStringGeneric Edit200
160F55IF425Sales Order per BO - 200542SDLOCNLocationStringGeneric Edit200
161F55IFLOGhistorical log12HLLOCNLocationStringGeneric Edit200
162F55LOC01Lokasyon-Satisci Iliskisi1LOLOCNLocationStringGeneric Edit200
163F55W0100Correction Invoice Print - WF137SDLOCNLocationStringGeneric Edit200
164F74H1051Invoicing Workfile - New13IWLOCNLocationStringGeneric Edit200
165F59H0215Correctoin Default Line Type7CLLOCNLocationStringGeneric Edit200
166F59H0220CRM Case Tag File - Proposals18CCLOCNLocationStringGeneric Edit200
167F59I0010P06 PO Receipts Buffer8BFLOCNLocationStringGeneric Edit200
168F59I0011Purchase Receipt - Buffer9P1LOCNLocationStringGeneric Edit200
169F59I0012Purchase Receipt - Template10P1LOCNLocationStringGeneric Edit200
170F59I0021P07 Shipment Details11PDLOCNLocationStringGeneric Edit200
171F59I0060Cycle Count Import Table6CCLOCNLocationStringGeneric Edit200
172F59I0065Cycle Count Summary Report6WFLOCNLocationStringGeneric Edit200
TOP75C: China - Reporting System Only
173F75C4106Chinese Free Goods VAT base price - F75C41064IBLOCNLocationStringGeneric Edit200
TOP76A: Argentina
174F76A393Calculated costs detail - 76A8C3LOCNLocationStringGeneric Edit200
175F76A394Adjustments - 76A8C4LOCNLocationStringGeneric Edit200
TOP76B: Brazil - Reporting System Only
176F7611BNota Fiscal Detail - Brazil28FDLOCNLocationStringGeneric Edit200
177F761BAAS Fiscal file book32FBLOCNLocationStringGeneric Edit200
178F76412Item Branch Regional Information - Brazil3IJLOCNLocationStringGeneric Edit200
TOP76H: Chile
179F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H26I1LOCNLocationStringGeneric Edit200
180F76H6003Indirect Costs Selection EPS F1642 - CHI - 41 - 76H27I2LOCNLocationStringGeneric Edit200
181F76H6004Item Cost Component WF - CHI - 41 - 76H6ICLOCNLocationStringGeneric Edit200
182F76H6008Manufactured Items - CHI - 41 - 76H6IPLOCNLocationStringGeneric Edit200
183F76H6105Item Actual Cost File - CHI - 41 - 76H6ACLOCNLocationStringGeneric Edit200
184F76H611Actual Item Ledger File - CHI - 41 - 76H6ALLOCNLocationStringGeneric Edit200
185F76H6112Actual Item ASOF File - CHI - 41 - 76H8ANLOCNLocationStringGeneric Edit200
186F76H6205Item Replacement Cost - CHI - 416IRLOCNLocationStringGeneric Edit200
TOP76P: Peru
187F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P7CZLOCNLocationStringGeneric Edit200
TOP89: Conversion Programs
188F43199ATemp F43199 for ERP 9.0 Upgrade38OLLOCNLocationStringGeneric Edit200
TOPD3N: dcLINK (data collection) - DSI
189FD3N1601Pallet Tracking Table 14PHLOCNLocationStringGeneric Edit200
190FD3N161PPallet Tracking Table 47PHLOCNLocationStringGeneric Edit200
191FD3N4041Pallet Tracking Table 65CDLOCNLocationStringGeneric Edit200
TOPF30L: DFM Line Design
192FF30L930DFM Routings55LRLOCNLocationStringGeneric Edit200
TOPF31: Lean Transactions
193FF31010Production Master File9EHLOCNLocationStringGeneric Edit200
194FF31011TransactionID Master File21EHLOCNLocationStringGeneric Edit200
195FF31011SPurge - TransactionID Master File21ERLOCNLocationStringGeneric Edit200
196FF31111Lean Transaction Parts List34PLLOCNLocationStringGeneric Edit200
197FF31111SPurge - Lean Transaction Parts List34PRLOCNLocationStringGeneric Edit200
198FF31112Routing Transaction Table61EHLOCNLocationStringGeneric Edit200
199FF31112SPurge - Routing Transaction Table61ETLOCNLocationStringGeneric Edit200
TOPH91: Design Tools
200F98TC01Table Conversion UnNormalized3TCLOCNLocationStringGeneric Edit200
201F98TC03Table Conversion Normalized 23TNLOCNLocationStringGeneric Edit200