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?812 | UORG

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00092Supplemental Data10T3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
2F0018Sales/Use/V.A.T. Tax File27TDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
3F004201Prepayment Transaction Table47PTUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP04: Accounts Payable
4F09UI006Tax (F0018) Replica27TDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP13: Plant/Equipment Management
5F3111IGSWO Parts for IGS Integration12IGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP17: Customer Service Management
6F1775Claim Temporary Table12TCUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
7F3111Z2Warranty Claim/Supplier Recovery processing53WPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
8F3112Z2Warranty Claim/Supplier Recovery processing59WLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
9F4801Z2Warranty Claim/Supplier Recovery processing82WSUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP30: Product Data Management
10F3019Kanban Replenishment Capacity4KRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP31: Shop Floor Control
11F3111Work Order Parts List40WMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
12F3111SPurge - Shop Floor Parts List40WMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
13F3111Z1Outbound Work Order Parts List53SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
14F3112Work Order Routing47WLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
15F3112SPurge Shop Floor Control Routing Instructions47WLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
16F3112Z1Outbound Work Order Routings59SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
17F3115Net Change Transaction table11NCUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
18F3118Shortage Maintenance Master File6WNUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
19F31UI006Line Scheduling Workbench - Work File23LSUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
20F4801SPurge - Work Order Master file63WAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
21F4801Z1Outbound Work Order Header82SYUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP31P: Engineer To Order
22F31P11Project Quote Detail24QPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP32: Configuration Management
23F3212Configurator Routings File11RCUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP33: Capacity Planning
24F3303Capacity Resource Profile7CTUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
25F3311Capacity Message File7CNUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
26F3312Capacity Pegging7CWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
27F33UI001Shop Floor Control Routing Instructions20WLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP34: Requirements Planning
28F3412MPS/MRP/DRP Lower Level Requirements File7MWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
29F3460Forecast File7MFUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP36: Forecasting
30F3400Forecast Summary File17SGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
31F3460Z1Forecast Unedited Transactions20FTUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP40: Inventory/OP Base
32F3462Forecast Shipment Summary6MBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
33F40051Return Material Authorization32RDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
34F4011ZBatch Receiver File - Order Details81SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
35F4012ZWWF - Destination Quantity29SPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
36F4013ZKit Components Batch File16KSUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
37F40300RPreference Resolution History - Master8PMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
38F40UI17Allocation Work File20ZGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
39F40UI74Price Adjustment History Work File42AWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
40F4211AUSales Order Detail Audit File36AUUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
41F4211Z1Sales Order Detail Unedited Transaction File78SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP40R: Demand Scheduling
42F471721EDI Demand Supplemental Data17EUUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP41: Inventory Management
43F41131Stranded Hard Commitments Table19IUUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
44F4118Container Deposit File6CNUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
45F41181Container Transaction File13CMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP42: Sales Management
46F4211Sales Order Detail File65SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
47F42119Sales Order History File65SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
48F42199S.O. Detail Ledger File65SLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
49F42UI11SO Detail Cache File (MBF)53ZDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
50F42UI11CCustomer Self Service Shopping Cart Workfile10SCUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
51F42UI521Pick Slips Detail File61S9UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
52F42UI800Sales Detail Work File - Sales Update44SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP42B: Sales Order Entry
53F42216WFPending Blanket Release Work File - F42216WF8PBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
54F42420Audit Log Transaction17ALUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43: Procurement
55F41061Supplier Price/Catalog File16CBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
56F43080Approvals Fields Constants68PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
57F4311Purchase Order Detail File61PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
58F4311ZPurchase Order Generator File65PWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
59F4311Z1Purchase Order Detail Unedited Transaction Table74SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
60F43121Purchase Order Receiver File66PRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
61F43121Z1Receipts Unedited Transaction Table83SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
62F4314ZVoucher Match Selection File166PNUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
63F4316Purchase Order Multiple Account File27P3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
64F43199P.O. Detail Ledger File - Flexible Version61OLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
65F4331Quantity Breaks File6P1UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
66F4343Purchase Rebate History18RHUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
67F43632ZOpen Purchase Order by Item Work File20OIUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
68F4371Suggested Reorder Stock Items19PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
69F43E09F43E09 - Approvals Activity Table27AAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
70F43UI50DPO Print Detail Work File10PWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43A: Purchase Order Receipt/Routing
71F43126Purchase Order Receiver Multiple Account28P4UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43E: Requisition Self Service
72F43E11Requisition Detail26RDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
73F43E16Requisition Multiple Account File27P3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43Q: Strategic Sourcing
74F43Q11Event Detail24EDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
75F43Q41Response Line8RBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
76F43Q51Analyze Event Detail15EDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43S: Supplier Self Service
77F43001Procurement Self-Service Transaction Log17SAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP44H: Homebuilder Management
78F4457Takeoff File (World)11JJUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
79F4458Takeoff (World)11JKUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
80F44H602Takeoff Master File14TOUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
81F44H602HTakeoff History File15THUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
82F44H602WTake Off Summary Workfile16TSUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
83F44H611Bid Details48BDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
84F44H611WBid Details Work File52BWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
85F44H711Lot Start Workfile54SWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
86F44H711PAfter Start Purchasing16TPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
87F44H711ZHB Lot Start Unedited Transaction File67SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
88F44H712Lot Start Workfile Takeoff Detail13STUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
89F44H71W1Lot Start Generation Workfile54GWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
90F44H73W1Lot Start - P.O. / Committment Generation Work File27CGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP45: Advanced Pricing
91F4073Free Goods Master File6FGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
92F45521Price List Detail6PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
93F45522Price List Level-Break Pattern4PLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
94F4574Key Reference Table65KRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP46: Warehouse Management
95F46130Putaway Reservations15R3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
96F46130PUPutaway Reservations - Purged15R3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP46L: License Plating
97F46LUI01Assign/Remove Items To LP Work File17WFUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP47: Electronic Commerce
98F47012EDI Purchase Order Detail - Inbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
99F47017EDI Purchase Order Detail - Outbound75SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
100F47022EDI P.O. Acknowledgment Detail - Inbound75SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
101F47027EDI P.O. Acknowledgment Detail - Outbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
102F47032EDI Shipping Notice Detail - Inbound58SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
103F47037EDI Shipping Notice Detail - Outbound79SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
104F470371EDI Shipping Notice Detail - Outbound89SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
105F47047EDI Invoice Detail (Sales) - Outbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
106F47072EDI Receiving Advice Detail - Inbound76SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
107F47077EDI Receiving Advice Detail - Outbound76SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
108F47092EDI Request for Quote Detail - Inbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
109F47097EDI Request for Quote Detail - Outbound75SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
110F47098EDI RFQ Detail Quantity - Outbound12SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
111F47102EDI Response to RFQ Detail - Inbound75SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
112F47103EDI Response to RFQ Detail Quantity - Inbound12SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
113F47107EDI Response to RFQ Detail - Outbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
114F47132EDI Purchase Order Change Detail - Inbound83SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
115F47137EDI Purchase Order Change Detail - Outbound76SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
116F47142EDI P.O. Change Acknowledgment Detail - Inbound77SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
117F47147EDI P.O. Change Acknowledgment Detail - Outbound84SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
118F47157EDI Shipping Schedule Detail - Outbound81SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
119F47UI001ASN Extract Work File46SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP48: Work Order Processing
120F4801Work Order Master File63WAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
121F48092WO Supplemental DB User Defined5W8UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
122F48UI001X4801 Master Business Function Workfile66WAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP55: Reserved for Clients
123F55IF421Sales Order per BO71SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
124F55IF425Sales Order per BO - 200571SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
125F55IFLOGhistorical log15HLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
126F55IFPRMPromozioni ordini di vendita7PRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
127F55IFQUAWork file per quadrature F411113QUUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
128F55IFTAATarget Area of Businness5TAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
129F55IFTARCustomer Target and Share Info5TAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
130F55IFWPSWF per Warranty Process Summarization7PSUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
131F55W0100Correction Invoice Print - WF166SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
132F74H1051Invoicing Workfile - New10IWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
133F59I0013Purchase Receipt - Orders10P1UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP74: EMEA Localization
134F74093Workfile for Printing IVA Summary - Italy26HCUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP75T: Taiwan
135F75T004GUI/VAT Transaction Header - 75T64THUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
136F75T0049GUI/VAT Transaction Header History - 75T64THUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
137F75T004PGUI/VAT Transaction Header POS - 75T64THUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
138F75T005GUI/VAT Transaction Detail - 75T9TDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
139F75T0059GUI/VAT Transaction Detail History - 75T9TDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
140F75T005PGUI/VAT Transaction Detail POS - 75T9TDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
141F75T005ZGUI/VAT Transaction Detail - Work - 75T15ZDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
142F76111BNota Fiscal - Detail (Fiscal Books) - 4210QUUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
143F76111BTConversion table for CFOP 5 digits - F76111B - 4210TAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
144F7611BNota Fiscal Detail - Brazil34FDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
145F761BAAS Fiscal file book38FBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
146F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4217IMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
147F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4216CDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
148F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4116SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
149F76B51Inventory Records Table - IN68 - 428RIUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
150F76B60Products Table - IN68 - 303PRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
151F76B61Packing and Raw Material Table - IN68 - 305IEUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP89: Conversion Programs
152F43199ATemp F43199 for ERP 9.0 Upgrade61OLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOPF31: Lean Transactions
153FF31112Routing Transaction Table41EHUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
154FF31112SPurge - Routing Transaction Table41ETUORGUnits - Order/Transaction QuantityNumericGeneric Edit152