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

154 columns | Print definition?920 | LNTY

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Taxes26TDLNTYLine TypeStringGeneric Edit20
2F004201Prepayment Transaction Table46PTLNTYLine TypeStringGeneric Edit20
TOP04: Accounts Payable
3F09UI006Tax (F0018) Replica26TDLNTYLine TypeStringGeneric Edit20
TOP13: Plant/Equipment Management
4F13017Equipment Parts List32PLLNTYLine TypeStringGeneric Edit20
5F3111IGSWO Parts for IGS Integration11IGLNTYLine TypeStringGeneric Edit20
TOP17: Customer Service Management
6F1721Contract Detail27CDLNTYLine TypeStringGeneric Edit20
7F1793S/WM Line Type Constants1LFLNTYLine TypeStringGeneric Edit20
8F3111Z2Warranty Claim/Supplier Recovery processing49WPLNTYLine TypeStringGeneric Edit20
TOP17C: Call Management
9F17111Base Warranty Defaults16BCLNTYLine TypeStringGeneric Edit20
10F1752Case Types4CTLNTYLine TypeStringGeneric Edit20
11F1755Case Master97ZALNTYLine TypeStringGeneric Edit20
TOP30: Product Data Management
12F300211Lean Multi Level Bill of Material Detail70EDLNTYLine TypeStringGeneric Edit20
13F3002Z1Bill of Material Transaction File64SZLNTYLine TypeStringGeneric Edit20
14F30UI016BOM Explosion Work File for BI18BELNTYLine TypeStringGeneric Edit20
TOP31: Shop Floor Control
15F3111Work Order Parts List36WMLNTYLine TypeStringGeneric Edit20
16F3111SPurge - Shop Floor Parts List36WMLNTYLine TypeStringGeneric Edit20
17F3111Z1Outbound Work Order Parts List49SZLNTYLine TypeStringGeneric Edit20
TOP32: Configuration Management
18F3209Configurator Constants5CFLNTYLine TypeStringGeneric Edit20
19F3215Configurator Component Table12CCLNTYLine TypeStringGeneric Edit20
20F32159Configurator Component History Table12CHLNTYLine TypeStringGeneric Edit20
21F3216Configurator Price/Cost Table5PCLNTYLine TypeStringGeneric Edit20
22F32169Configurator Price/Cost History5KBLNTYLine TypeStringGeneric Edit20
23F3290Configured Item Information7C3LNTYLine TypeStringGeneric Edit20
24F3293Assembly Inclusions Rules23KYLNTYLine TypeStringGeneric Edit20
TOP34: Requirements Planning
25F34004Demand/Supply Inclusion Rules3MGLNTYLine TypeStringGeneric Edit20
TOP34X: In-Memory Planning Advisor
26F34X310WPlanning Advisor BOM Component Detail Table22PDLNTYLine TypeStringGeneric Edit20
TOP40: Inventory/OP Base
27F3002Bill of Material Master File51IXLNTYLine TypeStringGeneric Edit20
28F3011Bill of Materials Change File51IZLNTYLine TypeStringGeneric Edit20
29F3013ECO Parts List Detail46CYLNTYLine TypeStringGeneric Edit20
30F30UI004Bill of Material Update Work File66WFLNTYLine TypeStringGeneric Edit20
31F4011ZBatch Receiver File - Order Details61SZLNTYLine TypeStringGeneric Edit20
32F4012ZWWF - Destination Quantity13SPLNTYLine TypeStringGeneric Edit20
33F4013ZKit Components Batch File19KSLNTYLine TypeStringGeneric Edit20
34F4015Order Templates9OTLNTYLine TypeStringGeneric Edit20
35F40203Order Activity Rules4FSLNTYLine TypeStringGeneric Edit20
36F40205Line Type Control Constants File1LFLNTYLine TypeStringGeneric Edit20
37F40205TLine Type Control Constants Tag File1OILNTYLine TypeStringGeneric Edit20
38F40300RPreference Resolution History - Master15PMLNTYLine TypeStringGeneric Edit20
39F40320Preference Profile - Multi Shipping/Receiving Locations20LPLNTYLine TypeStringGeneric Edit20
40F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations21LPLNTYLine TypeStringGeneric Edit20
41F40330Preference Profile - Document Set17DGLNTYLine TypeStringGeneric Edit20
42F40341Preference Profile - Next Order Status15NSLNTYLine TypeStringGeneric Edit20
43F40341RPreference Resolution Ledger - Next Order Status17NSLNTYLine TypeStringGeneric Edit20
44F40500Commodity Structure Definitions6CCLNTYLine TypeStringGeneric Edit20
45F40UI002Supplier History Rebuild -workfile9UTLNTYLine TypeStringGeneric Edit20
46F40UI74Price Adjustment History Work File41AWLNTYLine TypeStringGeneric Edit20
47F4207Price by Item16PMLNTYLine TypeStringGeneric Edit20
48F4211AUSales Order Detail Audit File6AULNTYLine TypeStringGeneric Edit20
49F4211DTSales Order Detail Date Tracking File5DTLNTYLine TypeStringGeneric Edit20
50F4211Z1Sales Order Detail Unedited Transaction File58SZLNTYLine TypeStringGeneric Edit20
TOP41: Inventory Management
51F4101Item Master73IMLNTYLine TypeStringGeneric Edit20
52F4101AItem File44IMLNTYLine TypeStringGeneric Edit20
53F4101Z1F4101 Item Master Unedited Transaction Table88SZLNTYLine TypeStringGeneric Edit20
54F4102Item Branch File68IBLNTYLine TypeStringGeneric Edit20
55F41181Container Transaction File12CMLNTYLine TypeStringGeneric Edit20
56F41291ZLanded Cost Cache Table25IGLNTYLine TypeStringGeneric Edit20
TOP41F: Apparel Management
57FCW09Item Revisions Work File10WRLNTYLine TypeStringGeneric Edit20
58FCW10Item Branch Work File6WBLNTYLine TypeStringGeneric Edit20
59FCW31Proposal Order Line Details7LVLNTYLine TypeStringGeneric Edit20
60FCW67Style Work Order Parts List42WMLNTYLine TypeStringGeneric Edit20
TOP42: Sales Management
61F03B423Sales Order Trigger Configuration4TCLNTYLine TypeStringGeneric Edit20
62F4020Freight/Additional Charges Rate Information7ARLNTYLine TypeStringGeneric Edit20
63F4211Sales Order Detail File45SDLNTYLine TypeStringGeneric Edit20
64F42119Sales Order History File45SDLNTYLine TypeStringGeneric Edit20
65F42199S.O. Detail Ledger File45SLLNTYLine TypeStringGeneric Edit20
66F4229Sales Summary History File2SSLNTYLine TypeStringGeneric Edit20
67F42565Invoice Print File32IWLNTYLine TypeStringGeneric Edit20
68F42UI11SO Detail Cache File (MBF)44ZDLNTYLine TypeStringGeneric Edit20
69F42UI130Commitment Work File42ZCLNTYLine TypeStringGeneric Edit20
70F42UI521Pick Slips Detail File40S9LNTYLine TypeStringGeneric Edit20
71F42UI800Sales Detail Work File - Sales Update56SDLNTYLine TypeStringGeneric Edit20
TOP42I: Outbound Inventory Management
72F42I015Outbound Inventory Agreement Transaction File4OILNTYLine TypeStringGeneric Edit20
73F42I02Outbound Inventory Agreement Acknowledge5OILNTYLine TypeStringGeneric Edit20
74F42I09Outbound Hold and Return Transactions9OILNTYLine TypeStringGeneric Edit20
TOP42W: Fulfilment Management
75F427UI01Release Fulfillment Work File24RFLNTYLine TypeStringGeneric Edit20
TOP43: Procurement
76F43080Approvals Fields Constants54PDLNTYLine TypeStringGeneric Edit20
77F4311Purchase Order Detail File46PDLNTYLine TypeStringGeneric Edit20
78F4311ZPurchase Order Generator File50PWLNTYLine TypeStringGeneric Edit20
79F4311Z1Purchase Order Detail Unedited Transaction Table59SZLNTYLine TypeStringGeneric Edit20
80F43121Purchase Order Receiver File43PRLNTYLine TypeStringGeneric Edit20
81F43121ZReceiver workfile80PWLNTYLine TypeStringGeneric Edit20
82F43121Z1Receipts Unedited Transaction Table60SZLNTYLine TypeStringGeneric Edit20
83F43147Freight Distribution Workfile15FDLNTYLine TypeStringGeneric Edit20
84F4314ZVoucher Match Selection File142PNLNTYLine TypeStringGeneric Edit20
85F43199P.O. Detail Ledger File - Flexible Version46OLLNTYLine TypeStringGeneric Edit20
86F43632ZOpen Purchase Order by Item Work File25OILNTYLine TypeStringGeneric Edit20
87F4371Suggested Reorder Stock Items22PDLNTYLine TypeStringGeneric Edit20
88F43UI50DPO Print Detail Work File34PWLNTYLine TypeStringGeneric Edit20
TOP43E: Requisition Self Service
89F43E11Requisition Detail35RDLNTYLine TypeStringGeneric Edit20
TOP43Q: Strategic Sourcing
90F43Q11Event Detail10EDLNTYLine TypeStringGeneric Edit20
TOP44H: Homebuilder Management
91F44H001HomeBuilder Constants14HCLNTYLine TypeStringGeneric Edit20
92F44H0011HomeBuilder Constants Lot Start Documents4LDLNTYLine TypeStringGeneric Edit20
93F44H611Bid Details38BDLNTYLine TypeStringGeneric Edit20
94F44H611WBid Details Work File42BWLNTYLine TypeStringGeneric Edit20
95F44H711Lot Start Workfile46SWLNTYLine TypeStringGeneric Edit20
96F44H711ZHB Lot Start Unedited Transaction File59SZLNTYLine TypeStringGeneric Edit20
97F44H71W1Lot Start Generation Workfile46GWLNTYLine TypeStringGeneric Edit20
98F44H73W1Lot Start - P.O. / Committment Generation Work File33CGLNTYLine TypeStringGeneric Edit20
TOP45: Advanced Pricing
99F4071Price Adjustment Type10ATLNTYLine TypeStringGeneric Edit20
100F4071PPrice Adjustment Type Purge11ATLNTYLine TypeStringGeneric Edit20
101F4073Free Goods Master File11FGLNTYLine TypeStringGeneric Edit20
102F4073PFree Goods Master File Purge12FGLNTYLine TypeStringGeneric Edit20
103F4511WPricing Structure View15APLNTYLine TypeStringGeneric Edit20
104F4575Ship and Debit History61AHLNTYLine TypeStringGeneric Edit20
105F4575TMPShip and Debit History - Temp Table61AHLNTYLine TypeStringGeneric Edit20
TOP46: Warehouse Management
106F4600Warehouse Requests42R1LNTYLine TypeStringGeneric Edit20
107F4600PUWarehouse Requests - Purged40R1LNTYLine TypeStringGeneric Edit20
108F4611Warehouse Suggestions119R2LNTYLine TypeStringGeneric Edit20
109F4611PUWarehouse Suggestions - Purged118R2LNTYLine TypeStringGeneric Edit20
110F4611Z1Unedited Suggestion Table130SZLNTYLine TypeStringGeneric Edit20
111F4942Z1Work File for F494218SYLNTYLine TypeStringGeneric Edit20
TOP46L: License Plating
112F46LUI01Assign/Remove Items To LP Work File33WFLNTYLine TypeStringGeneric Edit20
TOP47: Electronic Commerce
113F47012EDI Purchase Order Detail - Inbound62SZLNTYLine TypeStringGeneric Edit20
114F47017EDI Purchase Order Detail - Outbound60SZLNTYLine TypeStringGeneric Edit20
115F47022EDI P.O. Acknowledgment Detail - Inbound60SZLNTYLine TypeStringGeneric Edit20
116F47027EDI P.O. Acknowledgment Detail - Outbound62SZLNTYLine TypeStringGeneric Edit20
117F47032EDI Shipping Notice Detail - Inbound55SZLNTYLine TypeStringGeneric Edit20
118F47037EDI Shipping Notice Detail - Outbound62SZLNTYLine TypeStringGeneric Edit20
119F470371EDI Shipping Notice Detail - Outbound70SZLNTYLine TypeStringGeneric Edit20
120F47042EDI Invoice Detail - Inbound22SZLNTYLine TypeStringGeneric Edit20
121F47047EDI Invoice Detail (Sales) - Outbound62SZLNTYLine TypeStringGeneric Edit20
122F47072EDI Receiving Advice Detail - Inbound61SZLNTYLine TypeStringGeneric Edit20
123F47077EDI Receiving Advice Detail - Outbound61SZLNTYLine TypeStringGeneric Edit20
124F47092EDI Request for Quote Detail - Inbound62SZLNTYLine TypeStringGeneric Edit20
125F47097EDI Request for Quote Detail - Outbound60SZLNTYLine TypeStringGeneric Edit20
126F47102EDI Response to RFQ Detail - Inbound60SZLNTYLine TypeStringGeneric Edit20
127F47107EDI Response to RFQ Detail - Outbound62SZLNTYLine TypeStringGeneric Edit20
128F47132EDI Purchase Order Change Detail - Inbound63SZLNTYLine TypeStringGeneric Edit20
129F47137EDI Purchase Order Change Detail - Outbound61SZLNTYLine TypeStringGeneric Edit20
130F47142EDI P.O. Change Acknowledgment Detail - Inbound62SZLNTYLine TypeStringGeneric Edit20
131F47147EDI P.O. Change Acknowledgment Detail - Outbound64SZLNTYLine TypeStringGeneric Edit20
132F47157EDI Shipping Schedule Detail - Outbound64SZLNTYLine TypeStringGeneric Edit20
TOP54R: Rental Management
133F54R03Line Type and Action Association Header1LHLNTYLine TypeStringGeneric Edit20
134F54R031Line Type and Action Association Detail1LDLNTYLine TypeStringGeneric Edit20
135F54R11Rental Contract Detail22CDLNTYLine TypeStringGeneric Edit20
136F54R12Purchase Order Receiver Rentals File16RRLNTYLine TypeStringGeneric Edit20
137F54R199Rental Contract Detail Ledger18DLLNTYLine TypeStringGeneric Edit20
TOP73: M & D complementary products
138F7307Quantum Non-Stock Product Categories2VXLNTYLine TypeStringGeneric Edit20
TOP74: EMEA Localization
139F0018TIntrastat Revision15TDLNTYLine TypeStringGeneric Edit20
140F740018DData extraction ESL - 7420DELNTYLine TypeStringGeneric Edit20
141F740018WData extraction ESL - Workfile - 7420DELNTYLine TypeStringGeneric Edit20
142F74093Worktable for Printing IVA Summary - Italy25HCLNTYLine TypeStringGeneric Edit20
TOP74R: Russia
143F74R201VAT Accrual on Sales Method Setup - RUS - 422VMLNTYLine TypeStringGeneric Edit20
TOP75T: Taiwan
144F75T42WWork file with union of F4211 and F4211917SWLNTYLine TypeStringGeneric Edit20
TOP76B: Brazil
145F7611BNota Fiscal Detail - BRA - 4232FDLNTYLine TypeStringGeneric Edit20
146F761BAAS Fiscal file book - 0936FBLNTYLine TypeStringGeneric Edit20
TOP89: Conversion Programs
147F3296Needed for upgrade from Xe and below16KRLNTYLine TypeStringGeneric Edit20
148F32961Needed for upgrade from Xe and below4KLLNTYLine TypeStringGeneric Edit20
149F329611Needed for upgrade from Xe and below10KBLNTYLine TypeStringGeneric Edit20
150F43199ATemp F43199 for ERP 9.0 Upgrade46OLLNTYLine TypeStringGeneric Edit20
TOPF30L: DFM Line Design
151FF30L002DFM Bill of Material Master45DHLNTYLine TypeStringGeneric Edit20
152FF30L501DFM Item Definition Master47IBLNTYLine TypeStringGeneric Edit20
TOPF31: Lean Transactions
153FF31111Lean Transaction Parts List37PLLNTYLine TypeStringGeneric Edit20
154FF31111SPurge - Lean Transaction Parts List37PRLNTYLine TypeStringGeneric Edit20