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

96 columns | Print definition?910 | 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
TOP44H: Homebuilder Management
25F4459Material Item Pricing (World)6JLUPRCAmount - Price per UnitNumericGeneric Edit154
26F44H603Material Item Pricing12MPUPRCAmount - Price per UnitNumericGeneric Edit154
TOP45: Advanced Pricing
27F4075Price Variable Table4VBUPRCAmount - Price per UnitNumericGeneric Edit154
28F45521Price List Detail18PDUPRCAmount - Price per UnitNumericGeneric Edit154
29F4574Key Reference Table59KRUPRCAmount - Price per UnitNumericGeneric Edit154
30F4575Ship and Debit History25AHUPRCAmount - Price per UnitNumericGeneric Edit154
31F4575TMPShip and Debit History - Temp Table25AHUPRCAmount - Price per UnitNumericGeneric Edit154
32F4576Z1Ship and Debit Claims Unedited Transaction Table110Z1UPRCAmount - Price per UnitNumericGeneric Edit154
TOP47: Electronic Commerce
33F47012EDI Purchase Order Detail - Inbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
34F47027EDI P.O. Acknowledgment Detail - Outbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
35F47037EDI Shipping Notice Detail - Outbound89SZUPRCAmount - Price per UnitNumericGeneric Edit154
36F470371EDI Shipping Notice Detail - Outbound100SZUPRCAmount - Price per UnitNumericGeneric Edit154
37F47042EDI Invoice Detail - Inbound59SZUPRCAmount - Price per UnitNumericGeneric Edit154
38F47047EDI Invoice Detail (Sales) - Outbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
39F470473EDI Invoice Detail Charges15S7UPRCAmount - Price per UnitNumericGeneric Edit154
40F47062EDI Planning Schedule Detail - Inbound22MYUPRCAmount - Price per UnitNumericGeneric Edit154
41F47067EDI Planning Schedule Detail - Outbound22MYUPRCAmount - Price per UnitNumericGeneric Edit154
42F47082EDI Price Sales Catalog Detail - Inbound72FYUPRCAmount - Price per UnitNumericGeneric Edit154
43F47092EDI Request for Quote Detail - Inbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
44F47107EDI Response to RFQ Detail - Outbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
45F47132EDI Purchase Order Change Detail - Inbound93SZUPRCAmount - Price per UnitNumericGeneric Edit154
46F47147EDI P.O. Change Acknowledgment Detail - Outbound94SZUPRCAmount - Price per UnitNumericGeneric Edit154
47F47157EDI Shipping Schedule Detail - Outbound204SZUPRCAmount - Price per UnitNumericGeneric Edit154
TOP55: Reserved for Clients
48F554077Custom Table for Free Items13RNUPRCAmount - Price per UnitNumericGeneric Edit154
49F55IF421Sales Order per BO81SDUPRCAmount - Price per UnitNumericGeneric Edit154
50F55IF425Sales Order per BO - 200581SDUPRCAmount - Price per UnitNumericGeneric Edit154
51F55IFFTTWork file gestione Sconti10ALUPRCAmount - Price per UnitNumericGeneric Edit154
52F55IFLOGhistorical log22HLUPRCAmount - Price per UnitNumericGeneric Edit154
53F55IFP01Kit Pricing File28KPUPRCAmount - Price per UnitNumericGeneric Edit154
54F55TR002Discount Table14TTUPRCAmount - Price per UnitNumericGeneric Edit154
55F55TR565TEMP TABLO6TMUPRCAmount - Price per UnitNumericGeneric Edit154
56F55W0100Correction Invoice Print - WF176SDUPRCAmount - Price per UnitNumericGeneric Edit154
57F74H1051Invoicing Workfile - New17IWUPRCAmount - Price per UnitNumericGeneric Edit154
58F74H1057Invoice Line Pricing Information6IPUPRCAmount - Price per UnitNumericGeneric Edit154
59F59H0220CRM Case Tag File - Proposals13CCUPRCAmount - Price per UnitNumericGeneric Edit154
TOP74: EMEA Localization
60F7420033Sales Document Line (Print Info) - COMM - 4214PIUPRCAmount - Price per UnitNumericGeneric Edit154
61F7420034Price Adjustment (Print Info) - COMM - 429PIUPRCAmount - Price per UnitNumericGeneric Edit154
TOP75C: China - Reporting System Only
62F75C001Chinese GUI cross reference file25CRUPRCAmount - Price per UnitNumericGeneric Edit154
63F75C4106Chinese Free Goods VAT base price - F75C4106 - 4110IBUPRCAmount - Price per UnitNumericGeneric Edit154
TOP75I: India
64F75I2213Setoff Temp Table12TTUPRCAmount - Price per UnitNumericGeneric Edit154
65F75I309Personal Consumption - CENVAT setoff - IND - 4131CSUPRCAmount - Price per UnitNumericGeneric Edit154
66F75I322Excise - Work File for F04211 & F410118Q3UPRCAmount - Price per UnitNumericGeneric Edit154
67F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)18Q3UPRCAmount - Price per UnitNumericGeneric Edit154
68F75I344YPrint ARE-1Bond Register-IND-0033CDUPRCAmount - Price per UnitNumericGeneric Edit154
69F75I3451Excise - ARE3 Form Detail-IND-0014QDUPRCAmount - Price per UnitNumericGeneric Edit154
70F75I385RG23D Register - Issues - IND - 4216EDUPRCAmount - Price per UnitNumericGeneric Edit154
71F75I401Sales Form Information-IND-4233QAUPRCAmount - Price per UnitNumericGeneric Edit154
72F75I401CSales Form Information- Secondary22QAUPRCAmount - Price per UnitNumericGeneric Edit154
73F75I4213Setoff Report Data -IND -0026SOUPRCAmount - Price per UnitNumericGeneric Edit154
74F75I4223Sales Tax Summary/Detail32SDUPRCAmount - Price per UnitNumericGeneric Edit154
75F75I601TCS Register Details-IND-4224TRUPRCAmount - Price per UnitNumericGeneric Edit154
TOP75T: Taiwan
76F75T005GUI/VAT Transaction Detail - 75T16TDUPRCAmount - Price per UnitNumericGeneric Edit154
77F75T0059GUI/VAT Transaction Detail History - 75T16TDUPRCAmount - Price per UnitNumericGeneric Edit154
78F75T005PGUI/VAT Transaction Detail POS - 75T17TDUPRCAmount - Price per UnitNumericGeneric Edit154
79F75T005TGUI/VAT Transaction Detail Temp - 75T16TDUPRCAmount - Price per UnitNumericGeneric Edit154
80F75T005ZGUI/VAT Transaction Detail - Work - 75T23ZDUPRCAmount - Price per UnitNumericGeneric Edit154
81F75T42WWork file with union of F4211 and F4211924SWUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76A: Argentina
82F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
83F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
84F76A393Calculated costs detail - 76A11C3UPRCAmount - Price per UnitNumericGeneric Edit154
85F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76B: Brazil - Reporting System Only
86F76111BNota Fiscal - Detail (Fiscal Books) - 4213QUUPRCAmount - Price per UnitNumericGeneric Edit154
87F76111BTConversion table for CFOP 5 digits - F76111B - 4213TAUPRCAmount - Price per UnitNumericGeneric Edit154
88F7611BNota Fiscal Detail - BRA - 4237FDUPRCAmount - Price per UnitNumericGeneric Edit154
89F761BAAS Fiscal file book - 0940FBUPRCAmount - Price per UnitNumericGeneric Edit154
90F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4219IMUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76H: Chile
91F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H12PIUPRCAmount - Price per UnitNumericGeneric Edit154
92F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H9PIUPRCAmount - Price per UnitNumericGeneric Edit154
93F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H11PIUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76P: Peru
94F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P9CZUPRCAmount - Price per UnitNumericGeneric Edit154
TOPH90: ONEWORLD TOOLS
95F99DTLWorkflow Demonstration Sales Order Detail7WDUPRCAmount - Price per UnitNumericGeneric Edit154
96F99WFITMWorkflow Demonstration Item Table4WIUPRCAmount - Price per UnitNumericGeneric Edit154