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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP03B: Enhanced Accounts Receivable
1F03B29Credit Insurance Table12IPUNCSAmount - 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 File18SZUNCSAmount - 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
26F4141Cycle Count Transaction File20PJUNCSAmount - Unit CostNumericGeneric Edit154
27F4141Z1F4141 Cycle Count Unedited Transaction Table35SZUNCSAmount - Unit CostNumericGeneric Edit154
28F4160Tag Inventory File25ITUNCSAmount - Unit CostNumericGeneric Edit154
29F41UI001Inventory Transactions Detail File20ITUNCSAmount - Unit CostNumericGeneric Edit154
30F41UI002Inventory Transactions Batch File9TIUNCSAmount - Unit CostNumericGeneric Edit154
TOP41B: Bulk Stock Management
31F41511Bulk Product Transaction File40PAUNCSAmount - Unit CostNumericGeneric Edit154
TOP42: Sales Management
32F4211Sales Order Detail File82SDUNCSAmount - Unit CostNumericGeneric Edit154
33F42119Sales Order History File82SDUNCSAmount - Unit CostNumericGeneric Edit154
34F42199S.O. Detail Ledger File82SLUNCSAmount - Unit CostNumericGeneric Edit154
35F42UI11SO Detail Cache File (MBF)70ZDUNCSAmount - Unit CostNumericGeneric Edit154
36F42UI130Commitment Work File45ZCUNCSAmount - Unit CostNumericGeneric Edit154
37F42UI521Pick Slips Detail File75S9UNCSAmount - Unit CostNumericGeneric Edit154
38F42UI800Sales Detail Work File - Sales Update52SDUNCSAmount - Unit CostNumericGeneric Edit154
TOP42B: Sales Order Entry
39F42420Audit Log Transaction37ALUNCSAmount - Unit CostNumericGeneric Edit154
40F42UI440Customer Segment Items - Work File7CSUNCSAmount - Unit CostNumericGeneric Edit154
TOP43: Procurement
41F4314ZVoucher Match Selection File67PNUNCSAmount - Unit CostNumericGeneric Edit154
42F4371Suggested Reorder Stock Items14PDUNCSAmount - Unit CostNumericGeneric Edit154
TOP45: Advanced Pricing
43F4073Free Goods Master File9FGUNCSAmount - Unit CostNumericGeneric Edit154
44F4576Z1Ship and Debit Claims Unedited Transaction Table144Z1UNCSAmount - Unit CostNumericGeneric Edit154
TOP47: Electronic Commerce
45F47012EDI Purchase Order Detail - Inbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
46F47027EDI P.O. Acknowledgment Detail - Outbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
47F47037EDI Shipping Notice Detail - Outbound94SZUNCSAmount - Unit CostNumericGeneric Edit154
48F470371EDI Shipping Notice Detail - Outbound105SZUNCSAmount - Unit CostNumericGeneric Edit154
49F47047EDI Invoice Detail (Sales) - Outbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
50F47092EDI Request for Quote Detail - Inbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
51F47107EDI Response to RFQ Detail - Outbound99SZUNCSAmount - Unit CostNumericGeneric Edit154
52F47122EDI Product Activity Data Detail - Inbound43MJUNCSAmount - Unit CostNumericGeneric Edit154
53F47127EDI Product Activity Data Detail - Outbound43MJUNCSAmount - Unit CostNumericGeneric Edit154
54F47132EDI Purchase Order Change Detail - Inbound100SZUNCSAmount - Unit CostNumericGeneric Edit154
55F47147EDI P.O. Change Acknowledgment Detail - Outbound101SZUNCSAmount - Unit CostNumericGeneric Edit154
TOP49: Transportation Management
56F49631Load In-transit Ledger56TOUNCSAmount - Unit CostNumericGeneric Edit154
TOP55: Reserved for Clients
57F55IF120Period Detail Work File Copy8TWUNCSAmount - Unit CostNumericGeneric Edit154
58F55IF421Sales Order per BO88SDUNCSAmount - Unit CostNumericGeneric Edit154
59F55IF425Sales Order per BO - 200588SDUNCSAmount - Unit CostNumericGeneric Edit154
60F55IFALBEsportazione provvigioni da F42119PRUNCSAmount - Unit CostNumericGeneric Edit154
61F55IFP01Kit Pricing File29KPUNCSAmount - Unit CostNumericGeneric Edit154
62F55IFPRMPromozioni ordini di vendita4PRUNCSAmount - Unit CostNumericGeneric Edit154
63F55PROVVEsportazione provvigioni da F42119PRUNCSAmount - Unit CostNumericGeneric Edit154
64F55W0100Correction Invoice Print - WF183SDUNCSAmount - Unit CostNumericGeneric Edit154
65F59H0220CRM Case Tag File - Proposals15CCUNCSAmount - Unit CostNumericGeneric Edit154
TOP76A: Argentina
66F76A393Calculated costs detail - 76A12C3UNCSAmount - Unit CostNumericGeneric Edit154
67F76A396Item Valuation Cost Master - 76A6CSUNCSAmount - Unit CostNumericGeneric Edit154
TOP76B: Brazil - Reporting System Only
68F76B400AIN86-Work Table for Storage Control - 4116SCUNCSAmount - Unit CostNumericGeneric Edit154
69F76B50Item Ledger Table - IN68 - 4211CEUNCSAmount - Unit CostNumericGeneric Edit154
70F76B51Inventory Records Table - IN68 - 429RIUNCSAmount - Unit CostNumericGeneric Edit154
TOP76H: Chile
71F76H6105Item Actual Cost File - CHI - 41 - 76H9ACUNCSAmount - Unit CostNumericGeneric Edit154
72F76H611Actual Item Ledger File - CHI - 41 - 76H42ALUNCSAmount - Unit CostNumericGeneric Edit154
73F76H6205Item Replacement Cost - CHI - 4114IRUNCSAmount - Unit CostNumericGeneric Edit154
TOPD3N: dcLINK (data collection) - DSI
74FD3N4116dcLINK Interface - Inventory Reclassification18IRUNCSAmount - Unit CostNumericGeneric Edit154
TOPF30L: DFM Line Design
75FF30L002DFM Bill of Material Master47DHUNCSAmount - Unit CostNumericGeneric Edit154
TOPH90: ONEWORLD TOOLS
76F99DTLWorkflow Demonstration Sales Order Detail6WDUNCSAmount - Unit CostNumericGeneric Edit154
77F99WFITMWorkflow Demonstration Item Table3WIUNCSAmount - Unit CostNumericGeneric Edit154