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

136 columns | Print definition?812 | LNTY

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File26TDLNTYLine 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
7F1793CSMS Line Type Constants1LFLNTYLine TypeStringGeneric Edit20
8F3111Z2Warranty Claim/Supplier Recovery processing49WPLNTYLine TypeStringGeneric Edit20
TOP17C: Call Management
9F17111Base Warranty Defaults16BCLNTYLine TypeStringGeneric Edit20
10F1752Call Types4CTLNTYLine TypeStringGeneric Edit20
11F1755Customer Call Master97ZALNTYLine TypeStringGeneric Edit20
TOP30: Product Data Management
12F300211Lean Multi Level Bill of Material Detail70EDLNTYLine TypeStringGeneric Edit20
13F3002Z1Bill of Material Transaction File64SZLNTYLine TypeStringGeneric Edit20
TOP31: Shop Floor Control
14F3111Work Order Parts List36WMLNTYLine TypeStringGeneric Edit20
15F3111SPurge - Shop Floor Parts List36WMLNTYLine TypeStringGeneric Edit20
16F3111Z1Outbound Work Order Parts List49SZLNTYLine TypeStringGeneric Edit20
TOP32: Configuration Management
17F3209Configurator Constants5CFLNTYLine TypeStringGeneric Edit20
18F3215Configurator Component Table12CCLNTYLine TypeStringGeneric Edit20
19F32159Configurator Component History Table12CHLNTYLine TypeStringGeneric Edit20
20F3216Configurator Price/Cost Table5PCLNTYLine TypeStringGeneric Edit20
21F32169Configurator Price/Cost History5KBLNTYLine TypeStringGeneric Edit20
22F3290Configured Item Information7C3LNTYLine TypeStringGeneric Edit20
23F3293Assembly Inclusions Rules23KYLNTYLine TypeStringGeneric Edit20
24F3296Configurator Level/Sequence File16KRLNTYLine TypeStringGeneric Edit20
25F32961Configurator Cost/Price Adjustment File4KLLNTYLine TypeStringGeneric Edit20
26F329611Configurator Detail Cost/Price Adjustment Table10KBLNTYLine TypeStringGeneric Edit20
TOP34: Requirements Planning
27F34004Demand/Supply Inclusion Rules3MGLNTYLine TypeStringGeneric Edit20
TOP40: Inventory/OP Base
28F3002Bill of Material Master File51IXLNTYLine TypeStringGeneric Edit20
29F3011Bill of Materials Change File51IZLNTYLine TypeStringGeneric Edit20
30F3013ECO Parts List Detail46CYLNTYLine TypeStringGeneric Edit20
31F30UI004Bill of Material Update Work File66WFLNTYLine TypeStringGeneric Edit20
32F4011ZBatch Receiver File - Order Details61SZLNTYLine TypeStringGeneric Edit20
33F4012ZWWF - Destination Quantity13SPLNTYLine TypeStringGeneric Edit20
34F4013ZKit Components Batch File19KSLNTYLine TypeStringGeneric Edit20
35F4015Order Templates9OTLNTYLine TypeStringGeneric Edit20
36F40203Order Activity Rules4FSLNTYLine TypeStringGeneric Edit20
37F40205Line Type Control Constants File1LFLNTYLine 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
TOP42: Sales Management
57F4020Freight/Additional Charges Rate Information7ARLNTYLine TypeStringGeneric Edit20
58F4211Sales Order Detail File45SDLNTYLine TypeStringGeneric Edit20
59F42119Sales Order History File45SDLNTYLine TypeStringGeneric Edit20
60F42199S.O. Detail Ledger File45SLLNTYLine TypeStringGeneric Edit20
61F4229Sales Summary History File2SSLNTYLine TypeStringGeneric Edit20
62F42565Invoice Print File32IWLNTYLine TypeStringGeneric Edit20
63F42UI11SO Detail Cache File (MBF)44ZDLNTYLine TypeStringGeneric Edit20
64F42UI130Commitment Work File42ZCLNTYLine TypeStringGeneric Edit20
65F42UI521Pick Slips Detail File40S9LNTYLine TypeStringGeneric Edit20
66F42UI800Sales Detail Work File - Sales Update56SDLNTYLine TypeStringGeneric Edit20
TOP43: Procurement
67F43080Approvals Fields Constants54PDLNTYLine TypeStringGeneric Edit20
68F4311Purchase Order Detail File46PDLNTYLine TypeStringGeneric Edit20
69F4311ZPurchase Order Generator File50PWLNTYLine TypeStringGeneric Edit20
70F4311Z1Purchase Order Detail Unedited Transaction Table59SZLNTYLine TypeStringGeneric Edit20
71F43121Purchase Order Receiver File43PRLNTYLine TypeStringGeneric Edit20
72F43121ZReceiver workfile80PWLNTYLine TypeStringGeneric Edit20
73F43121Z1Receipts Unedited Transaction Table60SZLNTYLine TypeStringGeneric Edit20
74F4314ZVoucher Match Selection File142PNLNTYLine TypeStringGeneric Edit20
75F43199P.O. Detail Ledger File - Flexible Version46OLLNTYLine TypeStringGeneric Edit20
76F43632ZOpen Purchase Order by Item Work File25OILNTYLine TypeStringGeneric Edit20
77F4371Suggested Reorder Stock Items22PDLNTYLine TypeStringGeneric Edit20
78F43UI50DPO Print Detail Work File34PWLNTYLine TypeStringGeneric Edit20
TOP43E: Requisition Self Service
79F43E11Requisition Detail35RDLNTYLine TypeStringGeneric Edit20
TOP43Q: Strategic Sourcing
80F43Q11Event Detail10EDLNTYLine TypeStringGeneric Edit20
TOP44H: Homebuilder Management
81F44H001HomeBuilder Constants14HCLNTYLine TypeStringGeneric Edit20
82F44H0011HomeBuilder Constants Lot Start Documents4LDLNTYLine TypeStringGeneric Edit20
83F44H611Bid Details38BDLNTYLine TypeStringGeneric Edit20
84F44H611WBid Details Work File42BWLNTYLine TypeStringGeneric Edit20
85F44H711Lot Start Workfile46SWLNTYLine TypeStringGeneric Edit20
86F44H711ZHB Lot Start Unedited Transaction File59SZLNTYLine TypeStringGeneric Edit20
87F44H71W1Lot Start Generation Workfile46GWLNTYLine TypeStringGeneric Edit20
88F44H73W1Lot Start - P.O. / Committment Generation Work File33CGLNTYLine TypeStringGeneric Edit20
TOP45: Advanced Pricing
89F4071Price Adjustment Type10ATLNTYLine TypeStringGeneric Edit20
90F4073Free Goods Master File11FGLNTYLine TypeStringGeneric Edit20
91F4511WPricing Structure View15APLNTYLine TypeStringGeneric Edit20
92F4575Ship and Debit History61AHLNTYLine TypeStringGeneric Edit20
93F4575TMPShip and Debit History - Temp Table61AHLNTYLine TypeStringGeneric Edit20
TOP46: Warehouse Management
94F4600Warehouse Requests42R1LNTYLine TypeStringGeneric Edit20
95F4600PUWarehouse Requests - Purged40R1LNTYLine TypeStringGeneric Edit20
96F4611Warehouse Suggestions119R2LNTYLine TypeStringGeneric Edit20
97F4611PUWarehouse Suggestions - Purged118R2LNTYLine TypeStringGeneric Edit20
98F4611Z1Unedited Suggestion Table130SZLNTYLine TypeStringGeneric Edit20
99F4942Z1Work File for F494218SYLNTYLine TypeStringGeneric Edit20
TOP46L: License Plating
100F46LUI01Assign/Remove Items To LP Work File33WFLNTYLine TypeStringGeneric Edit20
TOP47: Electronic Commerce
101F47012EDI Purchase Order Detail - Inbound62SZLNTYLine TypeStringGeneric Edit20
102F47017EDI Purchase Order Detail - Outbound60SZLNTYLine TypeStringGeneric Edit20
103F47022EDI P.O. Acknowledgment Detail - Inbound60SZLNTYLine TypeStringGeneric Edit20
104F47027EDI P.O. Acknowledgment Detail - Outbound62SZLNTYLine TypeStringGeneric Edit20
105F47032EDI Shipping Notice Detail - Inbound55SZLNTYLine TypeStringGeneric Edit20
106F47037EDI Shipping Notice Detail - Outbound62SZLNTYLine TypeStringGeneric Edit20
107F470371EDI Shipping Notice Detail - Outbound70SZLNTYLine TypeStringGeneric Edit20
108F47042EDI Invoice Detail - Inbound22SZLNTYLine TypeStringGeneric Edit20
109F47047EDI Invoice Detail (Sales) - Outbound62SZLNTYLine TypeStringGeneric Edit20
110F47072EDI Receiving Advice Detail - Inbound61SZLNTYLine TypeStringGeneric Edit20
111F47077EDI Receiving Advice Detail - Outbound61SZLNTYLine TypeStringGeneric Edit20
112F47092EDI Request for Quote Detail - Inbound62SZLNTYLine TypeStringGeneric Edit20
113F47097EDI Request for Quote Detail - Outbound60SZLNTYLine TypeStringGeneric Edit20
114F47102EDI Response to RFQ Detail - Inbound60SZLNTYLine TypeStringGeneric Edit20
115F47107EDI Response to RFQ Detail - Outbound62SZLNTYLine TypeStringGeneric Edit20
116F47132EDI Purchase Order Change Detail - Inbound63SZLNTYLine TypeStringGeneric Edit20
117F47137EDI Purchase Order Change Detail - Outbound61SZLNTYLine TypeStringGeneric Edit20
118F47142EDI P.O. Change Acknowledgment Detail - Inbound62SZLNTYLine TypeStringGeneric Edit20
119F47147EDI P.O. Change Acknowledgment Detail - Outbound64SZLNTYLine TypeStringGeneric Edit20
120F47157EDI Shipping Schedule Detail - Outbound64SZLNTYLine TypeStringGeneric Edit20
TOP55: Reserved for Clients
121F55IF421Sales Order per BO51SDLNTYLine TypeStringGeneric Edit20
122F55IF425Sales Order per BO - 200551SDLNTYLine TypeStringGeneric Edit20
123F55IFSFVEstrazione del venduto per Sales Force Automation30FSLNTYLine TypeStringGeneric Edit20
124F55W0100Correction Invoice Print - WF146SDLNTYLine TypeStringGeneric Edit20
125F59H0215Correctoin Default Line Type3CLLNTYLine TypeStringGeneric Edit20
126F59H0220CRM Case Tag File - Proposals10CCLNTYLine TypeStringGeneric Edit20
TOP73: M & D complementary products
127F7307Quantum Non-Stock Product Categories2VXLNTYLine TypeStringGeneric Edit20
TOP74: EMEA Localization
128F0018TIntrastat Revision15TDLNTYLine TypeStringGeneric Edit20
129F74093Workfile for Printing IVA Summary - Italy25HCLNTYLine TypeStringGeneric Edit20
TOP76B: Brazil - Reporting System Only
130F7611BNota Fiscal Detail - Brazil32FDLNTYLine TypeStringGeneric Edit20
131F761BAAS Fiscal file book36FBLNTYLine TypeStringGeneric Edit20
TOP89: Conversion Programs
132F43199ATemp F43199 for ERP 9.0 Upgrade46OLLNTYLine TypeStringGeneric Edit20
TOPF30L: DFM Line Design
133FF30L002DFM Bill of Material Master45DHLNTYLine TypeStringGeneric Edit20
134FF30L501DFM Item Definition Master47IBLNTYLine TypeStringGeneric Edit20
TOPF31: Lean Transactions
135FF31111Lean Transaction Parts List37PLLNTYLine TypeStringGeneric Edit20
136FF31111SPurge - Lean Transaction Parts List37PRLNTYLine TypeStringGeneric Edit20