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

92 columns | Print definition?920 | UPRC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP32: Configuration Management
1F32GOPConfigurator GOP7GPUPRCAmount - Price per UnitNumericGeneric Edit154
TOP36: Forecasting
2F34007Forecast Prices7FHUPRCAmount - Price per UnitNumericGeneric Edit154
TOP38: Agreement Management
3F38011Agreement Quantities16DFUPRCAmount - Price per UnitNumericGeneric Edit154
TOP40: Inventory/OP Base
4F40051Return Material Authorization33RDUPRCAmount - Price per UnitNumericGeneric Edit154
5F4011ZBatch Receiver File - Order Details91SZUPRCAmount - Price per UnitNumericGeneric Edit154
6F4012ZWWF - Destination Quantity30SPUPRCAmount - Price per UnitNumericGeneric Edit154
7F4013ZKit Components Batch File12KSUPRCAmount - Price per UnitNumericGeneric Edit154
8F40UI74Price Adjustment History Work File29AWUPRCAmount - Price per UnitNumericGeneric Edit154
9F4106Item Base Price File16BPUPRCAmount - Price per UnitNumericGeneric Edit154
10F4106NCBase Price Extraction18SZUPRCAmount - Price per UnitNumericGeneric Edit154
11F4211Z1Sales Order Detail Unedited Transaction File88SZUPRCAmount - Price per UnitNumericGeneric Edit154
TOP40G: Grower Management
12F40G150Crush and Purchase Report Details41CPUPRCAmount - Price per UnitNumericGeneric Edit154
TOP41F: Apparel Management
13FCW11Item Base Price File Work File15WPUPRCAmount - Price per UnitNumericGeneric Edit154
14FCW34Price List Detail16PDUPRCAmount - Price per UnitNumericGeneric Edit154
TOP42: Sales Management
15F4074Price Adjustment Ledger File23ALUPRCAmount - Price per UnitNumericGeneric Edit154
16F4211Sales Order Detail File75SDUPRCAmount - Price per UnitNumericGeneric Edit154
17F42119Sales Order History File75SDUPRCAmount - Price per UnitNumericGeneric Edit154
18F42199S.O. Detail Ledger File75SLUPRCAmount - Price per UnitNumericGeneric Edit154
19F42565Invoice Print File26IWUPRCAmount - Price per UnitNumericGeneric Edit154
20F42UI11SO Detail Cache File (MBF)63ZDUPRCAmount - Price per UnitNumericGeneric Edit154
21F42UI521Pick Slips Detail File70S9UPRCAmount - Price per UnitNumericGeneric Edit154
TOP42B: Sales Order Entry
22F42420Audit Log Transaction19ALUPRCAmount - Price per UnitNumericGeneric Edit154
23F42440Customer Segment Items6CSUPRCAmount - Price per UnitNumericGeneric Edit154
24F42UI440Customer Segment Items - Work File6CSUPRCAmount - Price per UnitNumericGeneric Edit154
TOP42I: Outbound Inventory Management
25F42I015Outbound Inventory Agreement Transaction File25OIUPRCAmount - Price per UnitNumericGeneric Edit154
26F42I07Outbound Inventory Agreement Details Change History17OQUPRCAmount - Price per UnitNumericGeneric Edit154
TOP42X: In-Memory Sales Advisor
27F42X010WLine Advisor Work File8USUPRCAmount - Price per UnitNumericGeneric Edit154
28F42X020WOrder Advisor Work File7XCUPRCAmount - Price per UnitNumericGeneric Edit154
29F42X050WOrder Level Upsell Candidate Items15CIUPRCAmount - Price per UnitNumericGeneric Edit154
30F42X201Profitability Simulator Saved Scenarios11PSUPRCAmount - Price per UnitNumericGeneric Edit154
TOP44H: Homebuilder Management
31F4459Material Item Pricing (World)6JLUPRCAmount - Price per UnitNumericGeneric Edit154
32F44H603Material Item Pricing12MPUPRCAmount - Price per UnitNumericGeneric Edit154
TOP45: Advanced Pricing
33F4075Price Variable Table4VBUPRCAmount - Price per UnitNumericGeneric Edit154
34F45521Price List Detail18PDUPRCAmount - Price per UnitNumericGeneric Edit154
35F4574Key Reference Table59KRUPRCAmount - Price per UnitNumericGeneric Edit154
36F4575Ship and Debit History25AHUPRCAmount - Price per UnitNumericGeneric Edit154
37F4575TMPShip and Debit History - Temp Table25AHUPRCAmount - Price per UnitNumericGeneric Edit154
38F4576Z1Ship and Debit Claims Unedited Transaction Table110Z1UPRCAmount - Price per UnitNumericGeneric Edit154
TOP47: Electronic Commerce
39F47012EDI Purchase Order Detail - Inbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
40F47027EDI P.O. Acknowledgment Detail - Outbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
41F47037EDI Shipping Notice Detail - Outbound89SZUPRCAmount - Price per UnitNumericGeneric Edit154
42F470371EDI Shipping Notice Detail - Outbound100SZUPRCAmount - Price per UnitNumericGeneric Edit154
43F47042EDI Invoice Detail - Inbound59SZUPRCAmount - Price per UnitNumericGeneric Edit154
44F47047EDI Invoice Detail (Sales) - Outbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
45F470473EDI Invoice Detail Charges15S7UPRCAmount - Price per UnitNumericGeneric Edit154
46F47062EDI Planning Schedule Detail - Inbound22MYUPRCAmount - Price per UnitNumericGeneric Edit154
47F47067EDI Planning Schedule Detail - Outbound22MYUPRCAmount - Price per UnitNumericGeneric Edit154
48F47082EDI Price Sales Catalog Detail - Inbound72FYUPRCAmount - Price per UnitNumericGeneric Edit154
49F47092EDI Request for Quote Detail - Inbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
50F47107EDI Response to RFQ Detail - Outbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
51F47132EDI Purchase Order Change Detail - Inbound93SZUPRCAmount - Price per UnitNumericGeneric Edit154
52F47147EDI P.O. Change Acknowledgment Detail - Outbound94SZUPRCAmount - Price per UnitNumericGeneric Edit154
53F47157EDI Shipping Schedule Detail - Outbound204SZUPRCAmount - Price per UnitNumericGeneric Edit154
TOP54R: Rental Management
54F54R11Rental Contract Detail107CDUPRCAmount - Price per UnitNumericGeneric Edit154
55F54R199Rental Contract Detail Ledger103DLUPRCAmount - Price per UnitNumericGeneric Edit154
TOP74: EMEA Localization
56F7420033Sales Document Line (Print Info) - COMM - 4214PIUPRCAmount - Price per UnitNumericGeneric Edit154
57F7420034Price Adjustment (Print Info) - COMM - 429PIUPRCAmount - Price per UnitNumericGeneric Edit154
TOP75C: China
58F75C001Chinese GUI cross reference file25CRUPRCAmount - Price per UnitNumericGeneric Edit154
59F75C4106Chinese Free Goods VAT base price - F75C4106 - 4110IBUPRCAmount - Price per UnitNumericGeneric Edit154
TOP75I: India
60F75I2213Setoff Temp Table12TTUPRCAmount - Price per UnitNumericGeneric Edit154
61F75I309Personal Consumption - CENVAT setoff - IND - 4131CSUPRCAmount - Price per UnitNumericGeneric Edit154
62F75I322Excise - Work File for F04211 & F410118Q3UPRCAmount - Price per UnitNumericGeneric Edit154
63F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)18Q3UPRCAmount - Price per UnitNumericGeneric Edit154
64F75I344YPrint ARE-1Bond Register-IND-0033CDUPRCAmount - Price per UnitNumericGeneric Edit154
65F75I3451Excise - ARE3 Form Detail-IND-0014QDUPRCAmount - Price per UnitNumericGeneric Edit154
66F75I385RG23D Register - Issues - IND - 4216EDUPRCAmount - Price per UnitNumericGeneric Edit154
67F75I401Sales Form Information-IND-4233QAUPRCAmount - Price per UnitNumericGeneric Edit154
68F75I401CSales Form Information- Secondary22QAUPRCAmount - Price per UnitNumericGeneric Edit154
69F75I4213Setoff Report Data -IND -0026SOUPRCAmount - Price per UnitNumericGeneric Edit154
70F75I4223Sales Tax Summary/Detail32SDUPRCAmount - Price per UnitNumericGeneric Edit154
71F75I601TCS Register Details-IND-4224TRUPRCAmount - Price per UnitNumericGeneric Edit154
TOP75T: Taiwan
72F75T005GUI/VAT Transaction Detail - 75T16TDUPRCAmount - Price per UnitNumericGeneric Edit154
73F75T0059GUI/VAT Transaction Detail History - 75T16TDUPRCAmount - Price per UnitNumericGeneric Edit154
74F75T005PGUI/VAT Transaction Detail POS - 75T17TDUPRCAmount - Price per UnitNumericGeneric Edit154
75F75T005TGUI/VAT Transaction Detail Temp - 75T16TDUPRCAmount - Price per UnitNumericGeneric Edit154
76F75T005ZGUI/VAT Transaction Detail - Work - 75T23ZDUPRCAmount - Price per UnitNumericGeneric Edit154
77F75T42WWork file with union of F4211 and F4211924SWUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76A: Argentina
78F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
79F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
80F76A393Calculated costs detail - 76A11C3UPRCAmount - Price per UnitNumericGeneric Edit154
81F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76B: Brazil
82F76111BNota Fiscal - Detail (Fiscal Books) - 4213QUUPRCAmount - Price per UnitNumericGeneric Edit154
83F76111BTConversion table for CFOP 5 digits - F76111B - 4213TAUPRCAmount - Price per UnitNumericGeneric Edit154
84F7611BNota Fiscal Detail - BRA - 4237FDUPRCAmount - Price per UnitNumericGeneric Edit154
85F761BAAS Fiscal file book - 0940FBUPRCAmount - Price per UnitNumericGeneric Edit154
86F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4219IMUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76H: Chile
87F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H12PIUPRCAmount - Price per UnitNumericGeneric Edit154
88F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H9PIUPRCAmount - Price per UnitNumericGeneric Edit154
89F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H11PIUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76P: Peru
90F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P9CZUPRCAmount - Price per UnitNumericGeneric Edit154
TOPH90: EnterpriseOne TOOLS
91F99DTLWorkflow Demonstration Sales Order Detail7WDUPRCAmount - Price per UnitNumericGeneric Edit154
92F99WFITMWorkflow Demonstration Item Table4WIUPRCAmount - Price per UnitNumericGeneric Edit154