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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F42119SDSales Order History File
7F0006MCBusiness Unit Master
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

68 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
45F74H1051Invoicing Workfile - New17IWUPRCAmount - Price per UnitNumericGeneric Edit154
46F74H1057Invoice Line Pricing Information6IPUPRCAmount - Price per UnitNumericGeneric Edit154
TOP74: EMEA Localization
47F7420033Sales Document Line (Print Info) - COMM - 4214PIUPRCAmount - Price per UnitNumericGeneric Edit154
48F7420034Price Adjustment (Print Info) - COMM - 429PIUPRCAmount - Price per UnitNumericGeneric Edit154
TOP75C: China - Reporting System Only
49F75C4106Chinese Free Goods VAT base price - F75C410610IBUPRCAmount - Price per UnitNumericGeneric Edit154
TOP75T: Taiwan
50F75T005GUI/VAT Transaction Detail - 75T14TDUPRCAmount - Price per UnitNumericGeneric Edit154
51F75T0059GUI/VAT Transaction Detail History - 75T14TDUPRCAmount - Price per UnitNumericGeneric Edit154
52F75T005PGUI/VAT Transaction Detail POS - 75T14TDUPRCAmount - Price per UnitNumericGeneric Edit154
53F75T005ZGUI/VAT Transaction Detail - Work - 75T20ZDUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76A: Argentina
54F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
55F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A13DLUPRCAmount - Price per UnitNumericGeneric Edit154
56F76A393Calculated costs detail - 76A11C3UPRCAmount - Price per UnitNumericGeneric Edit154
57F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0013DLUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76B: Brazil - Reporting System Only
58F76111BNota Fiscal - Detail (Fiscal Books) - 4213QUUPRCAmount - Price per UnitNumericGeneric Edit154
59F76111BTConversion table for CFOP 5 digits - F76111B - 4213TAUPRCAmount - Price per UnitNumericGeneric Edit154
60F7611BNota Fiscal Detail - Brazil37FDUPRCAmount - Price per UnitNumericGeneric Edit154
61F761BAAS Fiscal file book40FBUPRCAmount - Price per UnitNumericGeneric Edit154
62F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4219IMUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76H: Chile
63F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H12PIUPRCAmount - Price per UnitNumericGeneric Edit154
64F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H9PIUPRCAmount - Price per UnitNumericGeneric Edit154
65F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H11PIUPRCAmount - Price per UnitNumericGeneric Edit154
TOP76P: Peru
66F76P393ZCalculated Costs detail Z1 - PER - 41 - 76P9CZUPRCAmount - Price per UnitNumericGeneric Edit154
TOPH90: ONEWORLD TOOLS
67F99DTLWorkflow Demonstration Sales Order Detail7WDUPRCAmount - Price per UnitNumericGeneric Edit154
68F99WFITMWorkflow Demonstration Item Table4WIUPRCAmount - Price per UnitNumericGeneric Edit154