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

77 columns | Print definition?812 | UPRC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP36: Forecasting
1F34007Forecast Prices7FHUPRCAmount - Price per UnitNumericGeneric Edit154
TOP38: Agreement Management
2F38011Agreement Quantities16DFUPRCAmount - Price per UnitNumericGeneric Edit154
TOP40: Inventory/OP Base
3F40051Return Material Authorization33RDUPRCAmount - Price per UnitNumericGeneric Edit154
4F4011ZBatch Receiver File - Order Details91SZUPRCAmount - Price per UnitNumericGeneric Edit154
5F4012ZWWF - Destination Quantity30SPUPRCAmount - Price per UnitNumericGeneric Edit154
6F4013ZKit Components Batch File12KSUPRCAmount - Price per UnitNumericGeneric Edit154
7F40UI74Price Adjustment History Work File29AWUPRCAmount - Price per UnitNumericGeneric Edit154
8F4106Item Base Price File16BPUPRCAmount - Price per UnitNumericGeneric Edit154
9F4106NCBase Price Extraction18SZUPRCAmount - Price per UnitNumericGeneric Edit154
10F4211Z1Sales Order Detail Unedited Transaction File88SZUPRCAmount - Price per UnitNumericGeneric Edit154
TOP40G: Grower Management
11F40G150Crush and Purchase Report Details41CPUPRCAmount - Price per UnitNumericGeneric Edit154
TOP42: Sales Management
12F4074Price Adjustment Ledger File23ALUPRCAmount - Price per UnitNumericGeneric Edit154
13F4211Sales Order Detail File75SDUPRCAmount - Price per UnitNumericGeneric Edit154
14F42119Sales Order History File75SDUPRCAmount - Price per UnitNumericGeneric Edit154
15F42199S.O. Detail Ledger File75SLUPRCAmount - Price per UnitNumericGeneric Edit154
16F42565Invoice Print File26IWUPRCAmount - Price per UnitNumericGeneric Edit154
17F42UI11SO Detail Cache File (MBF)63ZDUPRCAmount - Price per UnitNumericGeneric Edit154
18F42UI521Pick Slips Detail File70S9UPRCAmount - Price per UnitNumericGeneric Edit154
TOP42B: Sales Order Entry
19F42420Audit Log Transaction19ALUPRCAmount - Price per UnitNumericGeneric Edit154
20F42440Customer Segment Items6CSUPRCAmount - Price per UnitNumericGeneric Edit154
21F42UI440Customer Segment Items - Work File6CSUPRCAmount - Price per UnitNumericGeneric Edit154
TOP44H: Homebuilder Management
22F4459Material Item Pricing (World)6JLUPRCAmount - Price per UnitNumericGeneric Edit154
23F44H603Material Item Pricing12MPUPRCAmount - Price per UnitNumericGeneric Edit154
TOP45: Advanced Pricing
24F4075Price Variable Table4VBUPRCAmount - Price per UnitNumericGeneric Edit154
25F45521Price List Detail18PDUPRCAmount - Price per UnitNumericGeneric Edit154
26F4574Key Reference Table59KRUPRCAmount - Price per UnitNumericGeneric Edit154
27F4575Ship and Debit History25AHUPRCAmount - Price per UnitNumericGeneric Edit154
28F4575TMPShip and Debit History - Temp Table25AHUPRCAmount - Price per UnitNumericGeneric Edit154
29F4576Z1Ship and Debit Claims Unedited Transaction Table110Z1UPRCAmount - Price per UnitNumericGeneric Edit154
TOP47: Electronic Commerce
30F47012EDI Purchase Order Detail - Inbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
31F47027EDI P.O. Acknowledgment Detail - Outbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
32F47037EDI Shipping Notice Detail - Outbound89SZUPRCAmount - Price per UnitNumericGeneric Edit154
33F470371EDI Shipping Notice Detail - Outbound100SZUPRCAmount - Price per UnitNumericGeneric Edit154
34F47042EDI Invoice Detail - Inbound59SZUPRCAmount - Price per UnitNumericGeneric Edit154
35F47047EDI Invoice Detail (Sales) - Outbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
36F470473EDI Invoice Detail Charges15S7UPRCAmount - Price per UnitNumericGeneric Edit154
37F47062EDI Planning Schedule Detail - Inbound22MYUPRCAmount - Price per UnitNumericGeneric Edit154
38F47067EDI Planning Schedule Detail - Outbound22MYUPRCAmount - Price per UnitNumericGeneric Edit154
39F47082EDI Price Sales Catalog Detail - Inbound72FYUPRCAmount - Price per UnitNumericGeneric Edit154
40F47092EDI Request for Quote Detail - Inbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
41F47107EDI Response to RFQ Detail - Outbound92SZUPRCAmount - Price per UnitNumericGeneric Edit154
42F47132EDI Purchase Order Change Detail - Inbound93SZUPRCAmount - Price per UnitNumericGeneric Edit154
43F47147EDI P.O. Change Acknowledgment Detail - Outbound94SZUPRCAmount - Price per UnitNumericGeneric Edit154
44F47157EDI Shipping Schedule Detail - Outbound204SZUPRCAmount - Price per UnitNumericGeneric Edit154
TOP55: Reserved for Clients
45F55IF421Sales Order per BO81SDUPRCAmount - Price per UnitNumericGeneric Edit154
46F55IF425Sales Order per BO - 200581SDUPRCAmount - Price per UnitNumericGeneric Edit154
47F55IFFTTWork file gestione Sconti10ALUPRCAmount - Price per UnitNumericGeneric Edit154
48F55IFLOGhistorical log22HLUPRCAmount - Price per UnitNumericGeneric Edit154
49F55IFP01Kit Pricing File28KPUPRCAmount - Price per UnitNumericGeneric Edit154
50F55TR002Discount Table14TTUPRCAmount - Price per UnitNumericGeneric Edit154
51F55TR565TEMP TABLO6TMUPRCAmount - Price per UnitNumericGeneric Edit154
52F55W0100Correction Invoice Print - WF176SDUPRCAmount - Price per UnitNumericGeneric Edit154
53F74H1051Invoicing Workfile - New17IWUPRCAmount - Price per UnitNumericGeneric Edit154
54F74H1057Invoice Line Pricing Information6IPUPRCAmount - Price per UnitNumericGeneric Edit154
55F59H0220CRM Case Tag File - Proposals13CCUPRCAmount - 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 - Reporting System Only
58F75C4106Chinese Free Goods VAT base price - F75C410610IBUPRCAmount - Price per UnitNumericGeneric Edit154
TOP75T: Taiwan
59F75T005GUI/VAT Transaction Detail - 75T14TDUPRCAmount - Price per UnitNumericGeneric Edit154
60F75T0059GUI/VAT Transaction Detail History - 75T14TDUPRCAmount - Price per UnitNumericGeneric Edit154
61F75T005PGUI/VAT Transaction Detail POS - 75T14TDUPRCAmount - Price per UnitNumericGeneric Edit154
62F75T005ZGUI/VAT Transaction Detail - Work - 75T20ZDUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76A: Argentina
63F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
64F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
65F76A393Calculated costs detail - 76A11C3UPRCAmount - Price per UnitNumericGeneric Edit154
66F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0013DLUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76B: Brazil - Reporting System Only
67F76111BNota Fiscal - Detail (Fiscal Books) - 4213QUUPRCAmount - Price per UnitNumericGeneric Edit154
68F76111BTConversion table for CFOP 5 digits - F76111B - 4213TAUPRCAmount - Price per UnitNumericGeneric Edit154
69F7611BNota Fiscal Detail - Brazil37FDUPRCAmount - Price per UnitNumericGeneric Edit154
70F761BAAS Fiscal file book40FBUPRCAmount - Price per UnitNumericGeneric Edit154
71F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4219IMUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76H: Chile
72F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H12PIUPRCAmount - Price per UnitNumericGeneric Edit154
73F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H9PIUPRCAmount - Price per UnitNumericGeneric Edit154
74F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H11PIUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76P: Peru
75F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P9CZUPRCAmount - Price per UnitNumericGeneric Edit154
TOPH90: ONEWORLD TOOLS
76F99DTLWorkflow Demonstration Sales Order Detail7WDUPRCAmount - Price per UnitNumericGeneric Edit154
77F99WFITMWorkflow Demonstration Item Table4WIUPRCAmount - Price per UnitNumericGeneric Edit154