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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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

171 columns | Print definition?812 | LOTN

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP12: Fixed Assets
1F1217Equipment Master Extension53WRLOTNLot/Serial NumberStringGeneric Edit300
2F1217PEquipment Master Extension Purge Table53WRLOTNLot/Serial NumberStringGeneric Edit300
3F1217Z1Unedited Equipment Tag Transactions57WRLOTNLot/Serial NumberStringGeneric Edit300
4F1217Z2Unedited Equipment Tag Transactions57WRLOTNLot/Serial NumberStringGeneric Edit300
TOP13: Plant/Equipment Management
5F13017Equipment Parts List10PLLOTNLot/Serial NumberStringGeneric Edit300
TOP17: Customer Service Management
6F1721Contract Detail42CDLOTNLot/Serial NumberStringGeneric Edit300
7F3111Z2Warranty Claim/Supplier Recovery processing47WPLOTNLot/Serial NumberStringGeneric Edit300
8F4801Z2Warranty Claim/Supplier Recovery processing108WSLOTNLot/Serial NumberStringGeneric Edit300
TOP17C: Call Management
9F1755Customer Call Master73ZALOTNLot/Serial NumberStringGeneric Edit300
TOP30: Product Data Management
10F300211Lean Multi Level Bill of Material Detail62EDLOTNLot/Serial NumberStringGeneric Edit300
TOP30A: Product Costing
11F300261Item Cost Component Detail6IELOTNLot/Serial NumberStringGeneric Edit300
TOP31: Shop Floor Control
12F30161Z1Inbound Kanban Card Detail20SZLOTNLot/Serial NumberStringGeneric Edit300
13F3105Work Order LSN5ISLOTNLot/Serial NumberStringGeneric Edit300
14F3105SPurge Work Order LSN5ISLOTNLot/Serial NumberStringGeneric Edit300
15F3111Work Order Parts List34WMLOTNLot/Serial NumberStringGeneric Edit300
16F3111SPurge - Shop Floor Parts List34WMLOTNLot/Serial NumberStringGeneric Edit300
17F3111Z1Outbound Work Order Parts List47SZLOTNLot/Serial NumberStringGeneric Edit300
18F4801SPurge - Work Order Master file89WALOTNLot/Serial NumberStringGeneric Edit300
19F4801Z1Outbound Work Order Header108SYLOTNLot/Serial NumberStringGeneric Edit300
TOP31B: Blend Management
20F31B053Consumable Assignments10CALOTNLot/Serial NumberStringGeneric Edit300
21F31B07EUR Master File42EULOTNLot/Serial NumberStringGeneric Edit300
22F31B66Blend Transactions57BTLOTNLot/Serial NumberStringGeneric Edit300
23F31B84Operation Additives13OALOTNLot/Serial NumberStringGeneric Edit300
24F31B85Weigh Tag Master39WTLOTNLot/Serial NumberStringGeneric Edit300
25F31B85TWeigh Tag Master Tag Table7WTLOTNLot/Serial NumberStringGeneric Edit300
26F31B98Bottling Master6BMLOTNLot/Serial NumberStringGeneric Edit300
27F31B99Decant Detail7DDLOTNLot/Serial NumberStringGeneric Edit300
TOP32: Configuration Management
28F3215Configurator Component Table18CCLOTNLot/Serial NumberStringGeneric Edit300
29F32159Configurator Component History Table18CHLOTNLot/Serial NumberStringGeneric Edit300
30F3294Configured String History File4KZLOTNLot/Serial NumberStringGeneric Edit300
31F32943Configured String History - OneWorld4KOLOTNLot/Serial NumberStringGeneric Edit300
TOP34: Requirements Planning
32F3411MPS/MRP/DRP Message File31MMLOTNLot/Serial NumberStringGeneric Edit300
TOP37: Quality Management
33F3703Non-Conforming Material4QELOTNLot/Serial NumberStringGeneric Edit300
34F3711Test Results11TRLOTNLot/Serial NumberStringGeneric Edit300
35F3711Z1Test Results Unedited Transaction Table24SZLOTNLot/Serial NumberStringGeneric Edit300
36F37900Certificate of Analysis (COA) Extract10TRLOTNLot/Serial NumberStringGeneric Edit300
TOP40: Inventory/OP Base
37F30026Item Cost Component Add-Ons6IELOTNLot/Serial NumberStringGeneric Edit300
38F30UI006Lot Tracking Work File3ILLOTNLot/Serial NumberStringGeneric Edit300
39F40051Return Material Authorization59RDLOTNLot/Serial NumberStringGeneric Edit300
40F4011ZBatch Receiver File - Order Details53SZLOTNLot/Serial NumberStringGeneric Edit300
41F4012ZWWF - Destination Quantity25SPLOTNLot/Serial NumberStringGeneric Edit300
42F4106Item Base Price File6BPLOTNLot/Serial NumberStringGeneric Edit300
43F4108Lot Master1IOLOTNLot/Serial NumberStringGeneric Edit300
44F41112Item ASOF File9INLOTNLot/Serial NumberStringGeneric Edit300
45F4171Critical Hold Management2I1LOTNLot/Serial NumberStringGeneric Edit300
46F4207Price by Item25PMLOTNLot/Serial NumberStringGeneric Edit300
47F4211DTSales Order Detail Date Tracking File15DTLOTNLot/Serial NumberStringGeneric Edit300
48F4211Z1Sales Order Detail Unedited Transaction File50SZLOTNLot/Serial NumberStringGeneric Edit300
49F4220Basic Serial Numbers8SWLOTNLot/Serial NumberStringGeneric Edit300
TOP41: Inventory Management
50F4101AItem File87IMLOTNLot/Serial NumberStringGeneric Edit300
51F4101Z1F4101 Item Master Unedited Transaction Table185SZLOTNLot/Serial NumberStringGeneric Edit300
52F41021Item Location File4LILOTNLot/Serial NumberStringGeneric Edit300
53F410211Project Commitment Detail Table6PCLOTNLot/Serial NumberStringGeneric Edit300
54F41021AItem Location File - Temporary Upgrade4LILOTNLot/Serial NumberStringGeneric Edit300
55F41021WFF41021 Transaction Workfile8LWLOTNLot/Serial NumberStringGeneric Edit300
56F41021Z1Item Location Unedited Transaction File17SZLOTNLot/Serial NumberStringGeneric Edit300
57F4105Item Cost File6COLOTNLot/Serial NumberStringGeneric Edit300
58F41051Average Cost Work file5CHLOTNLot/Serial NumberStringGeneric Edit300
59F4105Z1Unedited Transaction Table - Item Cost19SZLOTNLot/Serial NumberStringGeneric Edit300
60F4111Item Ledger File7ILLOTNLot/Serial NumberStringGeneric Edit300
61F41113Lot Ledger4I8LOTNLot/Serial NumberStringGeneric Edit300
62F41131Stranded Hard Commitments Table3IULOTNLot/Serial NumberStringGeneric Edit300
63F4141Cycle Count Transaction File8PJLOTNLot/Serial NumberStringGeneric Edit300
64F4141Z1F4141 Cycle Count Unedited Transaction Table21SZLOTNLot/Serial NumberStringGeneric Edit300
65F4160Tag Inventory File6ITLOTNLot/Serial NumberStringGeneric Edit300
66F41UI001Inventory Transactions Detail File18ITLOTNLot/Serial NumberStringGeneric Edit300
67F41UI002Inventory Transactions Batch File8TILOTNLot/Serial NumberStringGeneric Edit300
TOP41B: Bulk Stock Management
68F41511Bulk Product Transaction File37PALOTNLot/Serial NumberStringGeneric Edit300
TOP42: Sales Management
69F4211Sales Order Detail File37SDLOTNLot/Serial NumberStringGeneric Edit300
70F42119Sales Order History File37SDLOTNLot/Serial NumberStringGeneric Edit300
71F42199S.O. Detail Ledger File37SLLOTNLot/Serial NumberStringGeneric Edit300
72F4239Last Customer Shipment7LCLOTNLot/Serial NumberStringGeneric Edit300
73F42565Invoice Print File119IWLOTNLot/Serial NumberStringGeneric Edit300
74F42UI11SO Detail Cache File (MBF)40ZDLOTNLot/Serial NumberStringGeneric Edit300
75F42UI12Sales Order Detail Cache 2 (MBF)73ZDLOTNLot/Serial NumberStringGeneric Edit300
76F42UI130Commitment Work File20ZCLOTNLot/Serial NumberStringGeneric Edit300
77F42UI521Pick Slips Detail File32S9LOTNLot/Serial NumberStringGeneric Edit300
78F42UI800Sales Detail Work File - Sales Update40SDLOTNLot/Serial NumberStringGeneric Edit300
TOP42B: Sales Order Entry
79F42420Audit Log Transaction24ALLOTNLot/Serial NumberStringGeneric Edit300
TOP43: Procurement
80F41291Item Cost Components7IGLOTNLot/Serial NumberStringGeneric Edit300
81F43080Approvals Fields Constants47PDLOTNLot/Serial NumberStringGeneric Edit300
82F43092Z1Receipt Routing Unedited Transaction Table46SZLOTNLot/Serial NumberStringGeneric Edit300
83F4311Purchase Order Detail File39PDLOTNLot/Serial NumberStringGeneric Edit300
84F4311ZPurchase Order Generator File43PWLOTNLot/Serial NumberStringGeneric Edit300
85F4311Z1Purchase Order Detail Unedited Transaction Table52SZLOTNLot/Serial NumberStringGeneric Edit300
86F43121Purchase Order Receiver File19PRLOTNLot/Serial NumberStringGeneric Edit300
87F43121ZReceiver workfile24PWLOTNLot/Serial NumberStringGeneric Edit300
88F43121Z1Receipts Unedited Transaction Table36SZLOTNLot/Serial NumberStringGeneric Edit300
89F4314ZVoucher Match Selection File118PNLOTNLot/Serial NumberStringGeneric Edit300
90F43199P.O. Detail Ledger File - Flexible Version39OLLOTNLot/Serial NumberStringGeneric Edit300
TOP45: Advanced Pricing
91F4574Key Reference Table10KRLOTNLot/Serial NumberStringGeneric Edit300
TOP46: Warehouse Management
92F4142Warehouse Count Transactions6CTLOTNLot/Serial NumberStringGeneric Edit300
93F4602Location Detail Information4IFLOTNLot/Serial NumberStringGeneric Edit300
94F46130Putaway Reservations13R3LOTNLot/Serial NumberStringGeneric Edit300
95F46130PUPutaway Reservations - Purged13R3LOTNLot/Serial NumberStringGeneric Edit300
TOP46L: License Plating
96F46L11License Plate Item Detail3IDLOTNLot/Serial NumberStringGeneric Edit300
97F46L12License Plate Commitment15LCLOTNLot/Serial NumberStringGeneric Edit300
98F46L42License Plate Cycle and Tag Count6CCLOTNLot/Serial NumberStringGeneric Edit300
99F46L99License Plate History9LMLOTNLot/Serial NumberStringGeneric Edit300
100F46LUI01Assign/Remove Items To LP Work File10WFLOTNLot/Serial NumberStringGeneric Edit300
TOP47: Electronic Commerce
101F47012EDI Purchase Order Detail - Inbound54SZLOTNLot/Serial NumberStringGeneric Edit300
102F47017EDI Purchase Order Detail - Outbound53SZLOTNLot/Serial NumberStringGeneric Edit300
103F47022EDI P.O. Acknowledgment Detail - Inbound53SZLOTNLot/Serial NumberStringGeneric Edit300
104F47027EDI P.O. Acknowledgment Detail - Outbound54SZLOTNLot/Serial NumberStringGeneric Edit300
105F47032EDI Shipping Notice Detail - Inbound52SZLOTNLot/Serial NumberStringGeneric Edit300
106F47037EDI Shipping Notice Detail - Outbound54SZLOTNLot/Serial NumberStringGeneric Edit300
107F470371EDI Shipping Notice Detail - Outbound60SZLOTNLot/Serial NumberStringGeneric Edit300
108F47042EDI Invoice Detail - Inbound34SZLOTNLot/Serial NumberStringGeneric Edit300
109F47047EDI Invoice Detail (Sales) - Outbound54SZLOTNLot/Serial NumberStringGeneric Edit300
110F47072EDI Receiving Advice Detail - Inbound54SZLOTNLot/Serial NumberStringGeneric Edit300
111F47077EDI Receiving Advice Detail - Outbound54SZLOTNLot/Serial NumberStringGeneric Edit300
112F47092EDI Request for Quote Detail - Inbound54SZLOTNLot/Serial NumberStringGeneric Edit300
113F47097EDI Request for Quote Detail - Outbound53SZLOTNLot/Serial NumberStringGeneric Edit300
114F47102EDI Response to RFQ Detail - Inbound53SZLOTNLot/Serial NumberStringGeneric Edit300
115F47107EDI Response to RFQ Detail - Outbound54SZLOTNLot/Serial NumberStringGeneric Edit300
116F47122EDI Product Activity Data Detail - Inbound26MJLOTNLot/Serial NumberStringGeneric Edit300
117F47127EDI Product Activity Data Detail - Outbound26MJLOTNLot/Serial NumberStringGeneric Edit300
118F47132EDI Purchase Order Change Detail - Inbound55SZLOTNLot/Serial NumberStringGeneric Edit300
119F47137EDI Purchase Order Change Detail - Outbound54SZLOTNLot/Serial NumberStringGeneric Edit300
120F47142EDI P.O. Change Acknowledgment Detail - Inbound55SZLOTNLot/Serial NumberStringGeneric Edit300
121F47147EDI P.O. Change Acknowledgment Detail - Outbound56SZLOTNLot/Serial NumberStringGeneric Edit300
122F47157EDI Shipping Schedule Detail - Outbound56SZLOTNLot/Serial NumberStringGeneric Edit300
TOP48: Work Order Processing
123F4801Work Order Master File89WALOTNLot/Serial NumberStringGeneric Edit300
124F48UI001X4801 Master Business Function Workfile92WALOTNLot/Serial NumberStringGeneric Edit300
TOP49: Transportation Management
125F4963Load In-transit5TILOTNLot/Serial NumberStringGeneric Edit300
126F49631Load In-transit Ledger33TOLOTNLot/Serial NumberStringGeneric Edit300
127F49632Load In-transit Left on Board5LBLOTNLot/Serial NumberStringGeneric Edit300
TOP55: Reserved for Clients
128F55IF421Sales Order per BO43SDLOTNLot/Serial NumberStringGeneric Edit300
129F55IF425Sales Order per BO - 200543SDLOTNLot/Serial NumberStringGeneric Edit300
130F55IFLOGhistorical log13HLLOTNLot/Serial NumberStringGeneric Edit300
131F55W0100Correction Invoice Print - WF138SDLOTNLot/Serial NumberStringGeneric Edit300
132F74H1051Invoicing Workfile - New12IWLOTNLot/Serial NumberStringGeneric Edit300
133F59H0220CRM Case Tag File - Proposals19CCLOTNLot/Serial NumberStringGeneric Edit300
134F59I0021P07 Shipment Details12PDLOTNLot/Serial NumberStringGeneric Edit300
135F59I0022P07 Shipment Details - Serial Numbers4PSLOTNLot/Serial NumberStringGeneric Edit300
136F59I0060Cycle Count Import Table7CCLOTNLot/Serial NumberStringGeneric Edit300
137F59I0065Cycle Count Summary Report7WFLOTNLot/Serial NumberStringGeneric Edit300
TOP74: EMEA Localization
138F7420033Sales Document Line (Print Info) - COMM - 429PILOTNLot/Serial NumberStringGeneric Edit300
139F7464108Lot Additional Information - COMM - 411LOLOTNLot/Serial NumberStringGeneric Edit300
TOP75C: China - Reporting System Only
140F75C4106Chinese Free Goods VAT base price - F75C41065IBLOTNLot/Serial NumberStringGeneric Edit300
TOP76A: Argentina
141F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A24DLLOTNLot/Serial NumberStringGeneric Edit300
142F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A24DLLOTNLot/Serial NumberStringGeneric Edit300
143F76A393Calculated costs detail - 76A9C3LOTNLot/Serial NumberStringGeneric Edit300
144F76A394Adjustments - 76A9C4LOTNLot/Serial NumberStringGeneric Edit300
145F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0024DLLOTNLot/Serial NumberStringGeneric Edit300
TOP76B: Brazil - Reporting System Only
146F7611BNota Fiscal Detail - Brazil29FDLOTNLot/Serial NumberStringGeneric Edit300
147F761BAAS Fiscal file book33FBLOTNLot/Serial NumberStringGeneric Edit300
148F76412Item Branch Regional Information - Brazil4IJLOTNLot/Serial NumberStringGeneric Edit300
TOP76H: Chile
149F76H6002Indirect Costs Selection EPS F1602 - CHI - 41 - 76H27I1LOTNLot/Serial NumberStringGeneric Edit300
150F76H6003Indirect Costs Selection EPS F1642 - CHI - 41 - 76H28I2LOTNLot/Serial NumberStringGeneric Edit300
151F76H6004Item Cost Component WF - CHI - 41 - 76H7ICLOTNLot/Serial NumberStringGeneric Edit300
152F76H6008Manufactured Items - CHI - 41 - 76H7IPLOTNLot/Serial NumberStringGeneric Edit300
153F76H6105Item Actual Cost File - CHI - 41 - 76H7ACLOTNLot/Serial NumberStringGeneric Edit300
154F76H611Actual Item Ledger File - CHI - 41 - 76H7ALLOTNLot/Serial NumberStringGeneric Edit300
155F76H6112Actual Item ASOF File - CHI - 41 - 76H9ANLOTNLot/Serial NumberStringGeneric Edit300
156F76H6205Item Replacement Cost - CHI - 417IRLOTNLot/Serial NumberStringGeneric Edit300
TOP76P: Peru
157F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P8CZLOTNLot/Serial NumberStringGeneric Edit300
TOP89: Conversion Programs
158F43199ATemp F43199 for ERP 9.0 Upgrade39OLLOTNLot/Serial NumberStringGeneric Edit300
TOPD3N: dcLINK (data collection) - DSI
159FD3N1611Pallet Tracking Table 23PDLOTNLot/Serial NumberStringGeneric Edit300
160FD3N161PPallet Tracking Table 45PHLOTNLot/Serial NumberStringGeneric Edit300
161FD3N4041Pallet Tracking Table 64CDLOTNLot/Serial NumberStringGeneric Edit300
162FD3N4116dcLINK Interface - Inventory Reclassification19IRLOTNLot/Serial NumberStringGeneric Edit300
163FD3N421PPallet Tracking Table 33SHLOTNLot/Serial NumberStringGeneric Edit300
164FD3N4950dcLINK Delivery Confirmation Work File10DCLOTNLot/Serial NumberStringGeneric Edit300
TOPF31: Lean Transactions
165FF31010Production Master File10EHLOTNLot/Serial NumberStringGeneric Edit300
166FF31011TransactionID Master File22EHLOTNLot/Serial NumberStringGeneric Edit300
167FF31011SPurge - TransactionID Master File22ERLOTNLot/Serial NumberStringGeneric Edit300
168FF31111Lean Transaction Parts List35PLLOTNLot/Serial NumberStringGeneric Edit300
169FF31111SPurge - Lean Transaction Parts List35PRLOTNLot/Serial NumberStringGeneric Edit300
TOPH91: Design Tools
170F98TC01Table Conversion UnNormalized4TCLOTNLot/Serial NumberStringGeneric Edit300
171F98TC03Table Conversion Normalized 24TNLOTNLot/Serial NumberStringGeneric Edit300