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

174 columns | Print definition?910 | UORG

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F00092Supplemental Data10T3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
2F0018Taxes27TDUORGUnits - 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
TOP31P: Engineer To Order
20F31P11Project Quote Detail24QPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP32: Configuration Management
21F3212Configurator Routings File11RCUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP33: Capacity Planning
22F3303Capacity Resource Profile7CTUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
23F3311Capacity Message File7CNUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
24F3312Capacity Pegging7CWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
25F33UI001Shop Floor Control Routing Instructions20WLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP34: Requirements Planning
26F3412MPS/MRP/DRP Lower Level Requirements File7MWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
27F3460Forecast File7MFUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP36: Forecasting
28F3400Forecast Summary File17SGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
29F3460Z1Forecast Unedited Transactions20FTUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP40: Inventory/OP Base
30F3462Forecast Shipment Summary6MBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
31F40051Return Material Authorization32RDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
32F4011ZBatch Receiver File - Order Details81SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
33F4012ZWWF - Destination Quantity29SPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
34F4013ZKit Components Batch File16KSUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
35F40300RPreference Resolution History - Master8PMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
36F40UI17Allocation Work File20ZGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
37F40UI74Price Adjustment History Work File42AWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
38F4211AUSales Order Detail Audit File36AUUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
39F4211Z1Sales Order Detail Unedited Transaction File78SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP40G: Grower Management
40F40G95Pay On Proceeds Log File15PPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP40R: Demand Scheduling
41F471721EDI Demand Supplemental Data17EUUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP41: Inventory Management
42F41131Stranded Hard Commitments Table19IUUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
43F4118Container Deposit File6CNUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
44F41181Container Transaction File13CMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP41F: Apparel Management
45FCW105Fair Share Sprinkling Rate4WFUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
46FCW25Enter Work Order Work File7WOUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
47FCW31Proposal Order Line Details15LVUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
48FCW44Proposal Order Details9FPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
49FCW66Work Order Detail for Style Items4CRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
50FCW67Style Work Order Parts List47WMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
51FCW68Style Work Order Routings50WLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
52FCW69Work Order Parts List Issues5WPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
53FCW71Supplier Price/Catalog File - Detail27CBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
54FCW89Work Order Inventory Issues for Style Items10WMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
55FCW96Material Analysis8WOUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
56FCW961Simulation Detailed Parts List14DLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
57FCW962Simulation Consolidated Parts List9CLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP42: Sales Management
58F420UI55Kit Balance Work File12UIUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
59F4211Sales Order Detail File65SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
60F42119Sales Order History File65SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
61F42199S.O. Detail Ledger File65SLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
62F42UI11SO Detail Cache File (MBF)53ZDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
63F42UI11CCustomer Self Service Shopping Cart Workfile10SCUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
64F42UI521Pick Slips Detail File61S9UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
65F42UI800Sales Detail Work File - Sales Update44SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP42B: Sales Order Entry
66F42216WFPending Blanket Release Work File - F42216WF8PBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
67F42420Audit Log Transaction17ALUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP42W: Fulfillment Management
68F427UI01Release Fulfillment Work File23RFUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43: Procurement
69F41061Supplier Price/Catalog File16CBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
70F43080Approvals Fields Constants68PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
71F4311Purchase Order Detail File61PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
72F4311ZPurchase Order Generator File65PWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
73F4311Z1Purchase Order Detail Unedited Transaction Table74SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
74F43121Purchase Order Receiver File66PRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
75F43121Z1Receipts Unedited Transaction Table83SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
76F43147Freight Distribution Workfile27FDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
77F4314ZVoucher Match Selection File166PNUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
78F4316Purchase Order Multiple Account File27P3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
79F43199P.O. Detail Ledger File - Flexible Version61OLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
80F4331Quantity Breaks File6P1UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
81F4343Purchase Rebate History18RHUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
82F43632ZOpen Purchase Order by Item Work File20OIUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
83F4371Suggested Reorder Stock Items19PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
84F43UI50DPO Print Detail Work File10PWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43A: Purchase Order Receipt/Routing
85F43126Purchase Order Receiver Multiple Account28P4UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43E: Requisition Self Service
86F43E09F43E09 - Approvals Activity Table27AAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
87F43E11Requisition Detail26RDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
88F43E16Requisition Multiple Account File27P3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43Q: Strategic Sourcing
89F43Q11Event Detail24EDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
90F43Q41Response Line8RBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
91F43Q51Analyze Event Detail15EDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP43S: Supplier Self Service
92F43001Procurement Self-Service Transaction Log17SAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP44H: Homebuilder Management
93F4457Takeoff File (World)11JJUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
94F4458Takeoff (World)11JKUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
95F44H602Takeoff Master File14TOUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
96F44H602HTakeoff History File15THUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
97F44H602WTake Off Summary Workfile16TSUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
98F44H611Bid Details48BDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
99F44H611WBid Details Work File52BWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
100F44H711Lot Start Workfile54SWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
101F44H711PAfter Start Purchasing16TPUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
102F44H711ZHB Lot Start Unedited Transaction File67SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
103F44H712Lot Start Workfile Takeoff Detail13STUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
104F44H71W1Lot Start Generation Workfile54GWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
105F44H73W1Lot Start - P.O. / Committment Generation Work File27CGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP45: Advanced Pricing
106F4073Free Goods Master File6FGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
107F4073PFree Goods Master File Purge7FGUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
108F45521Price List Detail6PDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
109F45522Price List Level-Break Pattern4PLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
110F4574Key Reference Table65KRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP46: Warehouse Management
111F46130Putaway Reservations15R3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
112F46130PUPutaway Reservations - Purged15R3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP46L: License Plating
113F46LUI01Assign/Remove Items To LP Work File17WFUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP47: Electronic Commerce
114F47012EDI Purchase Order Detail - Inbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
115F47017EDI Purchase Order Detail - Outbound75SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
116F47022EDI P.O. Acknowledgment Detail - Inbound75SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
117F47027EDI P.O. Acknowledgment Detail - Outbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
118F47032EDI Shipping Notice Detail - Inbound58SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
119F47037EDI Shipping Notice Detail - Outbound79SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
120F470371EDI Shipping Notice Detail - Outbound89SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
121F47047EDI Invoice Detail (Sales) - Outbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
122F47072EDI Receiving Advice Detail - Inbound76SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
123F47077EDI Receiving Advice Detail - Outbound76SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
124F47092EDI Request for Quote Detail - Inbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
125F47097EDI Request for Quote Detail - Outbound75SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
126F47098EDI RFQ Detail Quantity - Outbound12SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
127F47102EDI Response to RFQ Detail - Inbound75SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
128F47103EDI Response to RFQ Detail Quantity - Inbound12SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
129F47107EDI Response to RFQ Detail - Outbound82SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
130F47132EDI Purchase Order Change Detail - Inbound83SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
131F47137EDI Purchase Order Change Detail - Outbound76SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
132F47142EDI P.O. Change Acknowledgment Detail - Inbound77SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
133F47147EDI P.O. Change Acknowledgment Detail - Outbound84SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
134F47157EDI Shipping Schedule Detail - Outbound81SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
135F47UI001ASN Extract Work File47SZUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP48: Work Order Processing
136F4801Work Order Master File63WAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
137F4801SPurge - Work Order Master file63WAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
138F4801Z1Outbound Work Order Header82SYUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
139F48092WO Supplemental DB User Defined5W8UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
140F48UI001X4801 Master Business Function Workfile66WAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP55: Reserved for Clients
141F74H1051Invoicing Workfile - New10IWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP74: EMEA Localization
142F740018DData extraction ESL - 7421DEUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
143F740018WData extraction ESL - Workfile - 7421DEUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
144F74093Worktable for Printing IVA Summary - Italy26HCUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP75I: India
145F75I017Sales Order Tag File IND 4214SOUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
146F75I309Personal Consumption - CENVAT setoff - IND - 4129CSUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
147F75I322Excise - Work File for F04211 & F410116Q3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
148F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)16Q3UORGUnits - Order/Transaction QuantityNumericGeneric Edit152
149F75I344YPrint ARE-1Bond Register-IND-0035CDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
150F75I345XExcise - ARE-3 Form Header for Yarn38QRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
151F75I348CT2/CT3 Annexure Certificate Master-IND-007CTUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
152F75I385RG23D Register - Issues - IND - 4214EDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP75T: Taiwan
153F75T004GUI/VAT Transaction Header - 75T79THUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
154F75T0049GUI/VAT Transaction Header History - 75T79THUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
155F75T004PGUI/VAT Transaction Header POS - 75T76THUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
156F75T005GUI/VAT Transaction Detail - 75T11TDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
157F75T0059GUI/VAT Transaction Detail History - 75T11TDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
158F75T005PGUI/VAT Transaction Detail POS - 75T11TDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
159F75T005TGUI/VAT Transaction Detail Temp - 75T11TDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
160F75T005ZGUI/VAT Transaction Detail - Work - 75T18ZDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
161F75T42WWork file with union of F4211 and F4211922SWUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
162F76111BNota Fiscal - Detail (Fiscal Books) - 4210QUUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
163F76111BTConversion table for CFOP 5 digits - F76111B - 4210TAUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
164F7611BNota Fiscal Detail - BRA - 4234FDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
165F761BAAS Fiscal file book - 0938FBUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
166F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4217IMUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
167F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4216CDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
168F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4116SDUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
169F76B51Inventory Records Table - IN68 - 428RIUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
170F76B60Products Table - IN68 - 303PRUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
171F76B61Packing and Raw Material Table - IN68 - 305IEUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOP89: Conversion Programs
172F43199ATemp F43199 for ERP 9.0 Upgrade61OLUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
TOPF31: Lean Transactions
173FF31112Routing Transaction Table41EHUORGUnits - Order/Transaction QuantityNumericGeneric Edit152
174FF31112SPurge - Routing Transaction Table41ETUORGUnits - Order/Transaction QuantityNumericGeneric Edit152