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

75 columns | Print definition?910 | 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
38F42UI521Pick Slips Detail File75S9UNCSAmount - Unit CostNumericGeneric Edit154
39F42UI800Sales Detail Work File - Sales Update52SDUNCSAmount - Unit CostNumericGeneric Edit154
TOP42B: Sales Order Entry
40F42420Audit Log Transaction37ALUNCSAmount - Unit CostNumericGeneric Edit154
41F42UI440Customer Segment Items - Work File7CSUNCSAmount - Unit CostNumericGeneric Edit154
TOP43: Procurement
42F4314ZVoucher Match Selection File67PNUNCSAmount - Unit CostNumericGeneric Edit154
43F4371Suggested Reorder Stock Items14PDUNCSAmount - Unit CostNumericGeneric Edit154
TOP45: Advanced Pricing
44F4073Free Goods Master File9FGUNCSAmount - Unit CostNumericGeneric Edit154
45F4073PFree Goods Master File Purge10FGUNCSAmount - Unit CostNumericGeneric Edit154
46F4576Z1Ship and Debit Claims Unedited Transaction Table144Z1UNCSAmount - Unit CostNumericGeneric Edit154
TOP47: Electronic Commerce
47F47012EDI Purchase Order Detail - Inbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
48F47027EDI P.O. Acknowledgment Detail - Outbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
49F47037EDI Shipping Notice Detail - Outbound94SZUNCSAmount - Unit CostNumericGeneric Edit154
50F470371EDI Shipping Notice Detail - Outbound105SZUNCSAmount - Unit CostNumericGeneric Edit154
51F47047EDI Invoice Detail (Sales) - Outbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
52F47092EDI Request for Quote Detail - Inbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
53F47107EDI Response to RFQ Detail - Outbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
54F47122EDI Product Activity Data Detail - Inbound43MJUNCSAmount - Unit CostNumericGeneric Edit154
55F47127EDI Product Activity Data Detail - Outbound43MJUNCSAmount - Unit CostNumericGeneric Edit154
56F47132EDI Purchase Order Change Detail - Inbound100SZUNCSAmount - Unit CostNumericGeneric Edit154
57F47147EDI P.O. Change Acknowledgment Detail - Outbound101SZUNCSAmount - Unit CostNumericGeneric Edit154
TOP49: Transportation Management
58F49631Load In-transit Ledger56TOUNCSAmount - Unit CostNumericGeneric Edit154
TOP75I: India
59F75I3901Work With Consignment - IND -4328COUNCSAmount - Unit CostNumericGeneric Edit154
60F75I395BER - 5 (2)23ERUNCSAmount - Unit CostNumericGeneric Edit154
61F75I395TER - 5 (temp)24ERUNCSAmount - Unit CostNumericGeneric Edit154
62F75I396BER-626SEUNCSAmount - Unit CostNumericGeneric Edit154
63F75I396TER-6 Temp25SEUNCSAmount - Unit CostNumericGeneric Edit154
TOP76A: Argentina
64F76A393Calculated costs detail - 76A12C3UNCSAmount - Unit CostNumericGeneric Edit154
65F76A396Item Valuation Cost Master - 76A6CSUNCSAmount - Unit CostNumericGeneric Edit154
TOP76B: Brazil - Reporting System Only
66F76B400AIN86-Work Table for Storage Control - 4116SCUNCSAmount - Unit CostNumericGeneric Edit154
67F76B50Item Ledger Table - IN68 - 4211CEUNCSAmount - Unit CostNumericGeneric Edit154
68F76B51Inventory Records Table - IN68 - 429RIUNCSAmount - Unit CostNumericGeneric Edit154
TOP76H: Chile
69F76H6105Item Actual Cost File - CHI - 41 - 76H9ACUNCSAmount - Unit CostNumericGeneric Edit154
70F76H611Actual Item Ledger File - CHI - 41 - 76H42ALUNCSAmount - Unit CostNumericGeneric Edit154
71F76H6205Item Replacement Cost - CHI - 4114IRUNCSAmount - Unit CostNumericGeneric Edit154
TOP79A: Greenhouse Gas Accounting
72F79A80GHG Carbon Permit Management7CPUNCSAmount - Unit CostNumericGeneric Edit154
TOPF30L: DFM Line Design
73FF30L002DFM Bill of Material Master47DHUNCSAmount - Unit CostNumericGeneric Edit154
TOPH90: ONEWORLD TOOLS
74F99DTLWorkflow Demonstration Sales Order Detail6WDUNCSAmount - Unit CostNumericGeneric Edit154
75F99WFITMWorkflow Demonstration Item Table3WIUNCSAmount - Unit CostNumericGeneric Edit154