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
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

142 columns | Print definition?910 | 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
TOP40: Inventory/OP Base
26F3002Bill of Material Master File51IXLNTYLine TypeStringGeneric Edit20
27F3011Bill of Materials Change File51IZLNTYLine TypeStringGeneric Edit20
28F3013ECO Parts List Detail46CYLNTYLine TypeStringGeneric Edit20
29F30UI004Bill of Material Update Work File66WFLNTYLine TypeStringGeneric Edit20
30F4011ZBatch Receiver File - Order Details61SZLNTYLine TypeStringGeneric Edit20
31F4012ZWWF - Destination Quantity13SPLNTYLine TypeStringGeneric Edit20
32F4013ZKit Components Batch File19KSLNTYLine TypeStringGeneric Edit20
33F4015Order Templates9OTLNTYLine TypeStringGeneric Edit20
34F40203Order Activity Rules4FSLNTYLine TypeStringGeneric Edit20
35F40205Line Type Control Constants File1LFLNTYLine TypeStringGeneric Edit20
36F40300RPreference Resolution History - Master15PMLNTYLine TypeStringGeneric Edit20
37F40320Preference Profile - Multi Shipping/Receiving Locations20LPLNTYLine TypeStringGeneric Edit20
38F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations21LPLNTYLine TypeStringGeneric Edit20
39F40330Preference Profile - Document Set17DGLNTYLine TypeStringGeneric Edit20
40F40341Preference Profile - Next Order Status15NSLNTYLine TypeStringGeneric Edit20
41F40341RPreference Resolution Ledger - Next Order Status17NSLNTYLine TypeStringGeneric Edit20
42F40500Commodity Structure Definitions6CCLNTYLine TypeStringGeneric Edit20
43F40UI002Supplier History Rebuild -workfile9UTLNTYLine TypeStringGeneric Edit20
44F40UI74Price Adjustment History Work File41AWLNTYLine TypeStringGeneric Edit20
45F4207Price by Item16PMLNTYLine TypeStringGeneric Edit20
46F4211AUSales Order Detail Audit File6AULNTYLine TypeStringGeneric Edit20
47F4211DTSales Order Detail Date Tracking File5DTLNTYLine TypeStringGeneric Edit20
48F4211Z1Sales Order Detail Unedited Transaction File58SZLNTYLine TypeStringGeneric Edit20
TOP41: Inventory Management
49F4101Item Master73IMLNTYLine TypeStringGeneric Edit20
50F4101AItem File44IMLNTYLine TypeStringGeneric Edit20
51F4101Z1F4101 Item Master Unedited Transaction Table88SZLNTYLine TypeStringGeneric Edit20
52F4102Item Branch File68IBLNTYLine TypeStringGeneric Edit20
53F41181Container Transaction File12CMLNTYLine TypeStringGeneric Edit20
54F41291ZLanded Cost Cache Table25IGLNTYLine TypeStringGeneric Edit20
TOP41F: Apparel Management
55FCW09Item Revisions Work File10WRLNTYLine TypeStringGeneric Edit20
56FCW10Item Branch Work File6WBLNTYLine TypeStringGeneric Edit20
57FCW31Proposal Order Line Details7LVLNTYLine TypeStringGeneric Edit20
58FCW67Style Work Order Parts List42WMLNTYLine TypeStringGeneric Edit20
TOP42: Sales Management
59F4020Freight/Additional Charges Rate Information7ARLNTYLine TypeStringGeneric Edit20
60F4211Sales Order Detail File45SDLNTYLine TypeStringGeneric Edit20
61F42119Sales Order History File45SDLNTYLine TypeStringGeneric Edit20
62F42199S.O. Detail Ledger File45SLLNTYLine TypeStringGeneric Edit20
63F4229Sales Summary History File2SSLNTYLine TypeStringGeneric Edit20
64F42565Invoice Print File32IWLNTYLine TypeStringGeneric Edit20
65F42UI11SO Detail Cache File (MBF)44ZDLNTYLine TypeStringGeneric Edit20
66F42UI521Pick Slips Detail File40S9LNTYLine TypeStringGeneric Edit20
67F42UI800Sales Detail Work File - Sales Update56SDLNTYLine TypeStringGeneric Edit20
TOP42W: Fulfillment Management
68F427UI01Release Fulfillment Work File24RFLNTYLine TypeStringGeneric Edit20
TOP43: Procurement
69F43080Approvals Fields Constants54PDLNTYLine TypeStringGeneric Edit20
70F4311Purchase Order Detail File46PDLNTYLine TypeStringGeneric Edit20
71F4311ZPurchase Order Generator File50PWLNTYLine TypeStringGeneric Edit20
72F4311Z1Purchase Order Detail Unedited Transaction Table59SZLNTYLine TypeStringGeneric Edit20
73F43121Purchase Order Receiver File43PRLNTYLine TypeStringGeneric Edit20
74F43121ZReceiver workfile80PWLNTYLine TypeStringGeneric Edit20
75F43121Z1Receipts Unedited Transaction Table60SZLNTYLine TypeStringGeneric Edit20
76F43147Freight Distribution Workfile15FDLNTYLine TypeStringGeneric Edit20
77F4314ZVoucher Match Selection File142PNLNTYLine TypeStringGeneric Edit20
78F43199P.O. Detail Ledger File - Flexible Version46OLLNTYLine TypeStringGeneric Edit20
79F43632ZOpen Purchase Order by Item Work File25OILNTYLine TypeStringGeneric Edit20
80F4371Suggested Reorder Stock Items22PDLNTYLine TypeStringGeneric Edit20
81F43UI50DPO Print Detail Work File34PWLNTYLine TypeStringGeneric Edit20
TOP43E: Requisition Self Service
82F43E11Requisition Detail35RDLNTYLine TypeStringGeneric Edit20
TOP43Q: Strategic Sourcing
83F43Q11Event Detail10EDLNTYLine TypeStringGeneric Edit20
TOP44H: Homebuilder Management
84F44H001HomeBuilder Constants14HCLNTYLine TypeStringGeneric Edit20
85F44H0011HomeBuilder Constants Lot Start Documents4LDLNTYLine TypeStringGeneric Edit20
86F44H611Bid Details38BDLNTYLine TypeStringGeneric Edit20
87F44H611WBid Details Work File42BWLNTYLine TypeStringGeneric Edit20
88F44H711Lot Start Workfile46SWLNTYLine TypeStringGeneric Edit20
89F44H711ZHB Lot Start Unedited Transaction File59SZLNTYLine TypeStringGeneric Edit20
90F44H71W1Lot Start Generation Workfile46GWLNTYLine TypeStringGeneric Edit20
91F44H73W1Lot Start - P.O. / Committment Generation Work File33CGLNTYLine TypeStringGeneric Edit20
TOP45: Advanced Pricing
92F4071Price Adjustment Type10ATLNTYLine TypeStringGeneric Edit20
93F4071PPrice Adjustment Type Purge11ATLNTYLine TypeStringGeneric Edit20
94F4073Free Goods Master File11FGLNTYLine TypeStringGeneric Edit20
95F4073PFree Goods Master File Purge12FGLNTYLine TypeStringGeneric Edit20
96F4511WPricing Structure View15APLNTYLine TypeStringGeneric Edit20
97F4575Ship and Debit History61AHLNTYLine TypeStringGeneric Edit20
98F4575TMPShip and Debit History - Temp Table61AHLNTYLine TypeStringGeneric Edit20
TOP46: Warehouse Management
99F4600Warehouse Requests42R1LNTYLine TypeStringGeneric Edit20
100F4600PUWarehouse Requests - Purged40R1LNTYLine TypeStringGeneric Edit20
101F4611Warehouse Suggestions119R2LNTYLine TypeStringGeneric Edit20
102F4611PUWarehouse Suggestions - Purged118R2LNTYLine TypeStringGeneric Edit20
103F4611Z1Unedited Suggestion Table130SZLNTYLine TypeStringGeneric Edit20
104F4942Z1Work File for F494218SYLNTYLine TypeStringGeneric Edit20
TOP46L: License Plating
105F46LUI01Assign/Remove Items To LP Work File33WFLNTYLine TypeStringGeneric Edit20
TOP47: Electronic Commerce
106F47012EDI Purchase Order Detail - Inbound62SZLNTYLine TypeStringGeneric Edit20
107F47017EDI Purchase Order Detail - Outbound60SZLNTYLine TypeStringGeneric Edit20
108F47022EDI P.O. Acknowledgment Detail - Inbound60SZLNTYLine TypeStringGeneric Edit20
109F47027EDI P.O. Acknowledgment Detail - Outbound62SZLNTYLine TypeStringGeneric Edit20
110F47032EDI Shipping Notice Detail - Inbound55SZLNTYLine TypeStringGeneric Edit20
111F47037EDI Shipping Notice Detail - Outbound62SZLNTYLine TypeStringGeneric Edit20
112F470371EDI Shipping Notice Detail - Outbound70SZLNTYLine TypeStringGeneric Edit20
113F47042EDI Invoice Detail - Inbound22SZLNTYLine TypeStringGeneric Edit20
114F47047EDI Invoice Detail (Sales) - Outbound62SZLNTYLine TypeStringGeneric Edit20
115F47072EDI Receiving Advice Detail - Inbound61SZLNTYLine TypeStringGeneric Edit20
116F47077EDI Receiving Advice Detail - Outbound61SZLNTYLine TypeStringGeneric Edit20
117F47092EDI Request for Quote Detail - Inbound62SZLNTYLine TypeStringGeneric Edit20
118F47097EDI Request for Quote Detail - Outbound60SZLNTYLine TypeStringGeneric Edit20
119F47102EDI Response to RFQ Detail - Inbound60SZLNTYLine TypeStringGeneric Edit20
120F47107EDI Response to RFQ Detail - Outbound62SZLNTYLine TypeStringGeneric Edit20
121F47132EDI Purchase Order Change Detail - Inbound63SZLNTYLine TypeStringGeneric Edit20
122F47137EDI Purchase Order Change Detail - Outbound61SZLNTYLine TypeStringGeneric Edit20
123F47142EDI P.O. Change Acknowledgment Detail - Inbound62SZLNTYLine TypeStringGeneric Edit20
124F47147EDI P.O. Change Acknowledgment Detail - Outbound64SZLNTYLine TypeStringGeneric Edit20
125F47157EDI Shipping Schedule Detail - Outbound64SZLNTYLine TypeStringGeneric Edit20
TOP73: M & D complementary products
126F7307Quantum Non-Stock Product Categories2VXLNTYLine TypeStringGeneric Edit20
TOP74: EMEA Localization
127F0018TIntrastat Revision15TDLNTYLine TypeStringGeneric Edit20
128F740018DData extraction ESL - 7420DELNTYLine TypeStringGeneric Edit20
129F740018WData extraction ESL - Workfile - 7420DELNTYLine TypeStringGeneric Edit20
130F74093Worktable for Printing IVA Summary - Italy25HCLNTYLine TypeStringGeneric Edit20
TOP74R: CIS
131F74R201VAT Accrual on Sales Method Setup - RUS - 422VMLNTYLine TypeStringGeneric Edit20
TOP75T: Taiwan
132F75T42WWork file with union of F4211 and F4211917SWLNTYLine TypeStringGeneric Edit20
TOP76B: Brazil - Reporting System Only
133F7611BNota Fiscal Detail - BRA - 4232FDLNTYLine TypeStringGeneric Edit20
134F761BAAS Fiscal file book - 0936FBLNTYLine TypeStringGeneric Edit20
TOP89: Conversion Programs
135F3296Needed for upgrade from Xe and below16KRLNTYLine TypeStringGeneric Edit20
136F32961Needed for upgrade from Xe and below4KLLNTYLine TypeStringGeneric Edit20
137F329611Needed for upgrade from Xe and below10KBLNTYLine TypeStringGeneric Edit20
138F43199ATemp F43199 for ERP 9.0 Upgrade46OLLNTYLine TypeStringGeneric Edit20
TOPF30L: DFM Line Design
139FF30L002DFM Bill of Material Master45DHLNTYLine TypeStringGeneric Edit20
140FF30L501DFM Item Definition Master47IBLNTYLine TypeStringGeneric Edit20
TOPF31: Lean Transactions
141FF31111Lean Transaction Parts List37PLLNTYLine TypeStringGeneric Edit20
142FF31111SPurge - Lean Transaction Parts List37PRLNTYLine TypeStringGeneric Edit20