JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

99 columns | Print definition?910 | CARS

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0401Z1Supplier Master - Batch Upload56VOCARSCarrier NumberNumericGeneric Edit80
TOP01: Address Book
2F0401Supplier Master42A6CARSCarrier NumberNumericGeneric Edit80
TOP03: Accounts Receivable
3F03012Customer Master by Line of Business89AICARSCarrier NumberNumericGeneric Edit80
4F03012Z1Customer Master LOB-Batch Table102VOCARSCarrier NumberNumericGeneric Edit80
TOP31B: Blend Management
5F31B96Bill Of Lading Details5BDCARSCarrier NumberNumericGeneric Edit80
TOP34A: Advanced Planning & Scheduling
6F34A40APS Integration Group Setup Table24N0CARSCarrier NumberNumericGeneric Edit80
TOP40: Inventory/OP Base
7F4001ZBatch Receiver File - Order Headings71SYCARSCarrier NumberNumericGeneric Edit80
8F4011ZBatch Receiver File - Order Details138SZCARSCarrier NumberNumericGeneric Edit80
9F4012ZWWF - Destination Quantity27SPCARSCarrier NumberNumericGeneric Edit80
10F40300RPreference Resolution History - Master14PMCARSCarrier NumberNumericGeneric Edit80
11F40305Preference Profile - Print Messages30RMCARSCarrier NumberNumericGeneric Edit80
12F40306Preference Profile - Inventory Sourcing16SRCARSCarrier NumberNumericGeneric Edit80
13F40309Preference Profile - Delivery Date16DYCARSCarrier NumberNumericGeneric Edit80
14F40309RPreference Resolution Ledger - Delivery Date18DYCARSCarrier NumberNumericGeneric Edit80
15F40320Preference Profile - Multi Shipping/Receiving Locations16LPCARSCarrier NumberNumericGeneric Edit80
16F40320RPreference Resolution Ledger - Multi ShiP/Rec Locations17LPCARSCarrier NumberNumericGeneric Edit80
17F40330Preference Profile - Document Set15DGCARSCarrier NumberNumericGeneric Edit80
18F4201Z1Sales Order Header Unedited Transaction File60SYCARSCarrier NumberNumericGeneric Edit80
19F4211Z1Sales Order Detail Unedited Transaction File131SZCARSCarrier NumberNumericGeneric Edit80
TOP40S: Supply Chain Self Service
20F4947SWSelf-Service Shipment Tracking Work File12SWCARSCarrier NumberNumericGeneric Edit80
TOP41: Inventory Management
21F4101Item Master39IMCARSCarrier NumberNumericGeneric Edit80
22F4101CItem Category Codes30IMCARSCarrier NumberNumericGeneric Edit80
23F4101Z1F4101 Item Master Unedited Transaction Table54SZCARSCarrier NumberNumericGeneric Edit80
24F4102Item Branch File64IBCARSCarrier NumberNumericGeneric Edit80
25F4132Usage Header (FUTURE)14UHCARSCarrier NumberNumericGeneric Edit80
26F41UI001Inventory Transactions Detail File75ITCARSCarrier NumberNumericGeneric Edit80
TOP41B: Bulk Stock Management
27F41509Four-Point Analysis Maintenance File10PGCARSCarrier NumberNumericGeneric Edit80
TOP41F: Apparel Management
28FCW08Category Codes Work File13WKCARSCarrier NumberNumericGeneric Edit80
29FCW10Item Branch Work File38WBCARSCarrier NumberNumericGeneric Edit80
TOP42: Sales Management
30F4020Freight/Additional Charges Rate Information4ARCARSCarrier NumberNumericGeneric Edit80
31F4201Sales Order Header File47SHCARSCarrier NumberNumericGeneric Edit80
32F42019Sales Order Header History File47SHCARSCarrier NumberNumericGeneric Edit80
33F4211Sales Order Detail File118SDCARSCarrier NumberNumericGeneric Edit80
34F42119Sales Order History File118SDCARSCarrier NumberNumericGeneric Edit80
35F42199S.O. Detail Ledger File118SLCARSCarrier NumberNumericGeneric Edit80
36F42565Invoice Print File90IWCARSCarrier NumberNumericGeneric Edit80
37F4290Delivery Note History10SECARSCarrier NumberNumericGeneric Edit80
38F42UI01SO Header Cache File (MBF)52ZHCARSCarrier NumberNumericGeneric Edit80
39F42UI12Sales Order Detail Cache 2 (MBF)44ZDCARSCarrier NumberNumericGeneric Edit80
TOP42B: Sales Order Entry
40F42420Audit Log Transaction52ALCARSCarrier NumberNumericGeneric Edit80
TOP46: Warehouse Management
41F4600Warehouse Requests52R1CARSCarrier NumberNumericGeneric Edit80
42F4600PUWarehouse Requests - Purged50R1CARSCarrier NumberNumericGeneric Edit80
43F4611Warehouse Suggestions121R2CARSCarrier NumberNumericGeneric Edit80
44F4611PUWarehouse Suggestions - Purged120R2CARSCarrier NumberNumericGeneric Edit80
45F4611Z1Unedited Suggestion Table132SZCARSCarrier NumberNumericGeneric Edit80
46F46200Bulk Pick Requests26BRCARSCarrier NumberNumericGeneric Edit80
47F46200PUBulk Pick Requests - Purged26BRCARSCarrier NumberNumericGeneric Edit80
48F4942Z1Work File for F494239SYCARSCarrier NumberNumericGeneric Edit80
TOP47: Electronic Commerce
49F47011EDI Purchase Order Header - Inbound63SYCARSCarrier NumberNumericGeneric Edit80
50F47012EDI Purchase Order Detail - Inbound139SZCARSCarrier NumberNumericGeneric Edit80
51F47026EDI P.O. Acknowledgment Header - Outbound59SYCARSCarrier NumberNumericGeneric Edit80
52F47027EDI P.O. Acknowledgment Detail - Outbound139SZCARSCarrier NumberNumericGeneric Edit80
53F47037EDI Shipping Notice Detail - Outbound121SZCARSCarrier NumberNumericGeneric Edit80
54F470371EDI Shipping Notice Detail - Outbound137SZCARSCarrier NumberNumericGeneric Edit80
55F47046EDI Invoice Header (Sales) - Outbound59SYCARSCarrier NumberNumericGeneric Edit80
56F47047EDI Invoice Detail (Sales) - Outbound139SZCARSCarrier NumberNumericGeneric Edit80
57F470472EDI Invoice Expanded Detail (Sales)11S6CARSCarrier NumberNumericGeneric Edit80
58F47091EDI Request for Quote Header - Inbound63SYCARSCarrier NumberNumericGeneric Edit80
59F47092EDI Request for Quote Detail - Inbound139SZCARSCarrier NumberNumericGeneric Edit80
60F47106EDI Response to RFQ Header - Outbound59SYCARSCarrier NumberNumericGeneric Edit80
61F47107EDI Response to RFQ Detail - Outbound139SZCARSCarrier NumberNumericGeneric Edit80
62F47131EDI Purchase Order Change Header - Inbound60SYCARSCarrier NumberNumericGeneric Edit80
63F47132EDI Purchase Order Change Detail - Inbound140SZCARSCarrier NumberNumericGeneric Edit80
64F47146EDI P.O. Change Acknowledgment Header - Outbound60SYCARSCarrier NumberNumericGeneric Edit80
65F47147EDI P.O. Change Acknowledgment Detail - Outbound141SZCARSCarrier NumberNumericGeneric Edit80
TOP49: Transportation Management
66F49005Generate Tracking Number1TGCARSCarrier NumberNumericGeneric Edit80
67F490051Generate Tracking Number Segment1XGCARSCarrier NumberNumericGeneric Edit80
68F490052Generate Tracking Segment Next Number1YGCARSCarrier NumberNumericGeneric Edit80
69F490053Generate Tracking Number Separator1ZGCARSCarrier NumberNumericGeneric Edit80
70F4906Carrier Master1CMCARSCarrier NumberNumericGeneric Edit80
71F49110Transportation Bill of Lading Workfile16BWCARSCarrier NumberNumericGeneric Edit80
72F49130Shipment Document Workfile14BWCARSCarrier NumberNumericGeneric Edit80
73F4918Load Tender History3LTCARSCarrier NumberNumericGeneric Edit80
74F4941Shipment Routing Steps5RSCARSCarrier NumberNumericGeneric Edit80
75F49490Document Selection5TQCARSCarrier NumberNumericGeneric Edit80
76F4950Routing Entries4RTCARSCarrier NumberNumericGeneric Edit80
77F49501Intermodal Detail Routing Entries5RDCARSCarrier NumberNumericGeneric Edit80
78F4952Routing Restrictions3RECARSCarrier NumberNumericGeneric Edit80
79F4956Option and Equipment Inclusions/Exclusions2IXCARSCarrier NumberNumericGeneric Edit80
80F4957Transportation Confirmed Batch Shipment14BCCARSCarrier NumberNumericGeneric Edit80
81F49595Document Print - Document Summary23DKCARSCarrier NumberNumericGeneric Edit80
82F4960Load Header31TMCARSCarrier NumberNumericGeneric Edit80
83F4963Load In-transit10TICARSCarrier NumberNumericGeneric Edit80
84F49631Load In-transit Ledger19TOCARSCarrier NumberNumericGeneric Edit80
85F49695Document Register23DRCARSCarrier NumberNumericGeneric Edit80
86F4972Rate Detail5RXCARSCarrier NumberNumericGeneric Edit80
87F4974RateWare XL Rate Constants1RWCARSCarrier NumberNumericGeneric Edit80
88F4977Rate Parameters1MRCARSCarrier NumberNumericGeneric Edit80
89F4981Freight Audit History18FHCARSCarrier NumberNumericGeneric Edit80
90F49T10Sales Order Release Staging Table14ORCARSCarrier NumberNumericGeneric Edit80
91F49T20Shipment Staging Table21SSCARSCarrier NumberNumericGeneric Edit80
92F49T30Sales Confirm Staging Table23SOCARSCarrier NumberNumericGeneric Edit80
TOP55: Reserved for Clients
93F55FR001Storno Bolle10SBCARSCarrier NumberNumericGeneric Edit80
94F55IF421Sales Order per BO131SDCARSCarrier NumberNumericGeneric Edit80
95F55IF425Sales Order per BO - 2005131SDCARSCarrier NumberNumericGeneric Edit80
96F55IF565Invoice Work file Extension23EXCARSCarrier NumberNumericGeneric Edit80
97F55W0100Correction Invoice Print - WF1119SDCARSCarrier NumberNumericGeneric Edit80
TOP74: EMEA Localization
98F7430030Legal Document Header (Print Info) - COMM - 03B25PICARSCarrier NumberNumericGeneric Edit80
TOP76H: Chile
99F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H47PICARSCarrier NumberNumericGeneric Edit80