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

82 columns | Print definition?920 | UNCS

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03B: Enhanced Accounts Receivable
1F03B29Credit Insurance12IPUNCSAmount - Unit CostNumericGeneric Edit154
TOP13: Plant/Equipment Management
2F13017Equipment Parts List33PLUNCSAmount - Unit CostNumericGeneric Edit154
3F3111IGSWO Parts for IGS Integration9IGUNCSAmount - Unit CostNumericGeneric Edit154
TOP30: Product Data Management
4F300211Lean Multi Level Bill of Material Detail74EDUNCSAmount - Unit CostNumericGeneric Edit154
5F3002Z1Bill of Material Transaction File66SZUNCSAmount - Unit CostNumericGeneric Edit154
TOP31B: Blend Management
6F31B211Cost Groups Detail4CGUNCSAmount - Unit CostNumericGeneric Edit154
7F31B31CBlend Lot Costs6BCUNCSAmount - Unit CostNumericGeneric Edit154
8F31B3CZ1Operations Cost Transaction File21SZUNCSAmount - Unit CostNumericGeneric Edit154
9F31B66Blend Transactions11BTUNCSAmount - Unit CostNumericGeneric Edit154
TOP38: Agreement Management
10F38111Agreements Transaction Ledger53DZUNCSAmount - Unit CostNumericGeneric Edit154
TOP39: Advanced Stock Valuation
11F3908Item Pool Valuation Cost Master6CSUNCSAmount - Unit CostNumericGeneric Edit154
12F39120Temporary Period Build File for Stock Valuation10TFUNCSAmount - Unit CostNumericGeneric Edit154
13F39120WPeriod Detail Work File8TWUNCSAmount - Unit CostNumericGeneric Edit154
14F39121WAdditional Quantity Work File9AQUNCSAmount - Unit CostNumericGeneric Edit154
TOP40: Inventory/OP Base
15F3002Bill of Material Master File53IXUNCSAmount - Unit CostNumericGeneric Edit154
16F3011Bill of Materials Change File53IZUNCSAmount - Unit CostNumericGeneric Edit154
17F3013ECO Parts List Detail35CYUNCSAmount - Unit CostNumericGeneric Edit154
18F30UI004Bill of Material Update Work File55WFUNCSAmount - Unit CostNumericGeneric Edit154
19F4011ZBatch Receiver File - Order Details98SZUNCSAmount - Unit CostNumericGeneric Edit154
20F4012ZWWF - Destination Quantity32SPUNCSAmount - Unit CostNumericGeneric Edit154
21F4013ZKit Components Batch File13KSUNCSAmount - Unit CostNumericGeneric Edit154
22F4211Z1Sales Order Detail Unedited Transaction File95SZUNCSAmount - Unit CostNumericGeneric Edit154
TOP41: Inventory Management
23F4105Item Cost File9COUNCSAmount - Unit CostNumericGeneric Edit154
24F4105Z1Unedited Transaction Table - Item Cost22SZUNCSAmount - Unit CostNumericGeneric Edit154
25F4111Item Ledger File41ILUNCSAmount - Unit CostNumericGeneric Edit154
26F4133Usage Detail (FUTURE)21UDUNCSAmount - Unit CostNumericGeneric Edit154
27F4141Cycle Count Transaction File20PJUNCSAmount - Unit CostNumericGeneric Edit154
28F4141Z1F4141 Cycle Count Unedited Transaction Table35SZUNCSAmount - Unit CostNumericGeneric Edit154
29F4160Tag Inventory File25ITUNCSAmount - Unit CostNumericGeneric Edit154
30F41UI001Inventory Transactions Detail File20ITUNCSAmount - Unit CostNumericGeneric Edit154
31F41UI002Inventory Transactions Batch File9TIUNCSAmount - Unit CostNumericGeneric Edit154
TOP41B: Bulk Stock Management
32F41511Bulk Product Transaction File40PAUNCSAmount - Unit CostNumericGeneric Edit154
TOP41F: Apparel Management
33FCW12Item Cost File Work File8WCUNCSAmount - Unit CostNumericGeneric Edit154
TOP42: Sales Management
34F4211Sales Order Detail File82SDUNCSAmount - Unit CostNumericGeneric Edit154
35F42119Sales Order History File82SDUNCSAmount - Unit CostNumericGeneric Edit154
36F42199S.O. Detail Ledger File82SLUNCSAmount - Unit CostNumericGeneric Edit154
37F42UI11SO Detail Cache File (MBF)70ZDUNCSAmount - Unit CostNumericGeneric Edit154
38F42UI130Commitment Work File45ZCUNCSAmount - Unit CostNumericGeneric Edit154
39F42UI521Pick Slips Detail File75S9UNCSAmount - Unit CostNumericGeneric Edit154
40F42UI800Sales Detail Work File - Sales Update52SDUNCSAmount - Unit CostNumericGeneric Edit154
TOP42B: Sales Order Entry
41F42420Audit Log Transaction37ALUNCSAmount - Unit CostNumericGeneric Edit154
42F42UI440Customer Segment Items - Work File7CSUNCSAmount - Unit CostNumericGeneric Edit154
TOP42I: Outbound Inventory Management
43F42I015Outbound Inventory Agreement Transaction File33OIUNCSAmount - Unit CostNumericGeneric Edit154
TOP42X: In-Memory Sales Advisor
44F42X010WLine Advisor Work File29USUNCSAmount - Unit CostNumericGeneric Edit154
45F42X020WOrder Advisor Work File20XCUNCSAmount - Unit CostNumericGeneric Edit154
46F42X201Profitability Simulator Saved Scenarios9PSUNCSAmount - Unit CostNumericGeneric Edit154
TOP43: Procurement
47F4314ZVoucher Match Selection File67PNUNCSAmount - Unit CostNumericGeneric Edit154
48F4371Suggested Reorder Stock Items14PDUNCSAmount - Unit CostNumericGeneric Edit154
TOP45: Advanced Pricing
49F4073Free Goods Master File9FGUNCSAmount - Unit CostNumericGeneric Edit154
50F4073PFree Goods Master File Purge10FGUNCSAmount - Unit CostNumericGeneric Edit154
51F4576Z1Ship and Debit Claims Unedited Transaction Table144Z1UNCSAmount - Unit CostNumericGeneric Edit154
TOP47: Electronic Commerce
52F47012EDI Purchase Order Detail - Inbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
53F47027EDI P.O. Acknowledgment Detail - Outbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
54F47037EDI Shipping Notice Detail - Outbound94SZUNCSAmount - Unit CostNumericGeneric Edit154
55F470371EDI Shipping Notice Detail - Outbound105SZUNCSAmount - Unit CostNumericGeneric Edit154
56F47047EDI Invoice Detail (Sales) - Outbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
57F47092EDI Request for Quote Detail - Inbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
58F47107EDI Response to RFQ Detail - Outbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
59F47122EDI Product Activity Data Detail - Inbound43MJUNCSAmount - Unit CostNumericGeneric Edit154
60F47127EDI Product Activity Data Detail - Outbound43MJUNCSAmount - Unit CostNumericGeneric Edit154
61F47132EDI Purchase Order Change Detail - Inbound100SZUNCSAmount - Unit CostNumericGeneric Edit154
62F47147EDI P.O. Change Acknowledgment Detail - Outbound101SZUNCSAmount - Unit CostNumericGeneric Edit154
TOP49: Transportation Management
63F49631Load In-transit Ledger56TOUNCSAmount - Unit CostNumericGeneric Edit154
TOP54R: Rental Management
64F54R11Rental Contract Detail112CDUNCSAmount - Unit CostNumericGeneric Edit154
65F54R199Rental Contract Detail Ledger108DLUNCSAmount - Unit CostNumericGeneric Edit154
TOP75I: India
66F75I3901Work With Consignment - IND -4328COUNCSAmount - Unit CostNumericGeneric Edit154
67F75I395BER - 5 (2)23ERUNCSAmount - Unit CostNumericGeneric Edit154
68F75I395TER - 5 (temp)24ERUNCSAmount - Unit CostNumericGeneric Edit154
69F75I396BER-626SEUNCSAmount - Unit CostNumericGeneric Edit154
70F75I396TER-6 Temp25SEUNCSAmount - Unit CostNumericGeneric Edit154
TOP76A: Argentina
71F76A393Calculated costs detail - 76A12C3UNCSAmount - Unit CostNumericGeneric Edit154
72F76A396Item Valuation Cost Master - 76A6CSUNCSAmount - Unit CostNumericGeneric Edit154
TOP76B: Brazil
73F76B400AIN86-Work Table for Storage Control - 4116SCUNCSAmount - Unit CostNumericGeneric Edit154
74F76B50Item Ledger Table - IN68 - 4211CEUNCSAmount - Unit CostNumericGeneric Edit154
75F76B51Inventory Records Table - IN68 - 429RIUNCSAmount - Unit CostNumericGeneric Edit154
TOP76H: Chile
76F76H6105Item Actual Cost File - CHI - 41 - 76H9ACUNCSAmount - Unit CostNumericGeneric Edit154
77F76H611Actual Item Ledger File - CHI - 41 - 76H42ALUNCSAmount - Unit CostNumericGeneric Edit154
78F76H6205Item Replacement Cost - CHI - 4114IRUNCSAmount - Unit CostNumericGeneric Edit154
TOP79A: Greenhouse Gas Accounting
79F79A80GHG Carbon Permit Management7CPUNCSAmount - Unit CostNumericGeneric Edit154
TOPF30L: DFM Line Design
80FF30L002DFM Bill of Material Master47DHUNCSAmount - Unit CostNumericGeneric Edit154
TOPH90: EnterpriseOne TOOLS
81F99DTLWorkflow Demonstration Sales Order Detail6WDUNCSAmount - Unit CostNumericGeneric Edit154
82F99WFITMWorkflow Demonstration Item Table3WIUNCSAmount - Unit CostNumericGeneric Edit154