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

100 columns | Print definition?920 | 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
30F03B423Sales Order Trigger Configuration15TCCARSCarrier NumberNumericGeneric Edit80
31F4020Freight/Additional Charges Rate Information4ARCARSCarrier NumberNumericGeneric Edit80
32F4201Sales Order Header File47SHCARSCarrier NumberNumericGeneric Edit80
33F42019Sales Order Header History File47SHCARSCarrier NumberNumericGeneric Edit80
34F4211Sales Order Detail File118SDCARSCarrier NumberNumericGeneric Edit80
35F42119Sales Order History File118SDCARSCarrier NumberNumericGeneric Edit80
36F42199S.O. Detail Ledger File118SLCARSCarrier NumberNumericGeneric Edit80
37F42565Invoice Print File90IWCARSCarrier NumberNumericGeneric Edit80
38F4290Delivery Note History10SECARSCarrier NumberNumericGeneric Edit80
39F42UI01SO Header Cache File (MBF)52ZHCARSCarrier NumberNumericGeneric Edit80
40F42UI12Sales Order Detail Cache 2 (MBF)44ZDCARSCarrier NumberNumericGeneric Edit80
41F42UI130Commitment Work File37ZCCARSCarrier NumberNumericGeneric Edit80
TOP42B: Sales Order Entry
42F42420Audit Log Transaction52ALCARSCarrier NumberNumericGeneric Edit80
TOP46: Warehouse Management
43F4600Warehouse Requests52R1CARSCarrier NumberNumericGeneric Edit80
44F4600PUWarehouse Requests - Purged50R1CARSCarrier NumberNumericGeneric Edit80
45F4611Warehouse Suggestions121R2CARSCarrier NumberNumericGeneric Edit80
46F4611PUWarehouse Suggestions - Purged120R2CARSCarrier NumberNumericGeneric Edit80
47F4611Z1Unedited Suggestion Table132SZCARSCarrier NumberNumericGeneric Edit80
48F46200Bulk Pick Requests26BRCARSCarrier NumberNumericGeneric Edit80
49F46200PUBulk Pick Requests - Purged26BRCARSCarrier NumberNumericGeneric Edit80
50F4942Z1Work File for F494239SYCARSCarrier NumberNumericGeneric Edit80
TOP47: Electronic Commerce
51F47011EDI Purchase Order Header - Inbound63SYCARSCarrier NumberNumericGeneric Edit80
52F47012EDI Purchase Order Detail - Inbound139SZCARSCarrier NumberNumericGeneric Edit80
53F47026EDI P.O. Acknowledgment Header - Outbound59SYCARSCarrier NumberNumericGeneric Edit80
54F47027EDI P.O. Acknowledgment Detail - Outbound139SZCARSCarrier NumberNumericGeneric Edit80
55F47037EDI Shipping Notice Detail - Outbound121SZCARSCarrier NumberNumericGeneric Edit80
56F470371EDI Shipping Notice Detail - Outbound137SZCARSCarrier NumberNumericGeneric Edit80
57F47046EDI Invoice Header (Sales) - Outbound59SYCARSCarrier NumberNumericGeneric Edit80
58F47047EDI Invoice Detail (Sales) - Outbound139SZCARSCarrier NumberNumericGeneric Edit80
59F470472EDI Invoice Expanded Detail (Sales)11S6CARSCarrier NumberNumericGeneric Edit80
60F47091EDI Request for Quote Header - Inbound63SYCARSCarrier NumberNumericGeneric Edit80
61F47092EDI Request for Quote Detail - Inbound139SZCARSCarrier NumberNumericGeneric Edit80
62F47106EDI Response to RFQ Header - Outbound59SYCARSCarrier NumberNumericGeneric Edit80
63F47107EDI Response to RFQ Detail - Outbound139SZCARSCarrier NumberNumericGeneric Edit80
64F47131EDI Purchase Order Change Header - Inbound60SYCARSCarrier NumberNumericGeneric Edit80
65F47132EDI Purchase Order Change Detail - Inbound140SZCARSCarrier NumberNumericGeneric Edit80
66F47146EDI P.O. Change Acknowledgment Header - Outbound60SYCARSCarrier NumberNumericGeneric Edit80
67F47147EDI P.O. Change Acknowledgment Detail - Outbound141SZCARSCarrier NumberNumericGeneric Edit80
TOP49: Transportation Management
68F49005Generate Tracking Number1TGCARSCarrier NumberNumericGeneric Edit80
69F490051Generate Tracking Number Segment1XGCARSCarrier NumberNumericGeneric Edit80
70F490052Generate Tracking Segment Next Number1YGCARSCarrier NumberNumericGeneric Edit80
71F490053Generate Tracking Number Separator1ZGCARSCarrier NumberNumericGeneric Edit80
72F4906Carrier Master1CMCARSCarrier NumberNumericGeneric Edit80
73F49110Transportation Bill of Lading Workfile16BWCARSCarrier NumberNumericGeneric Edit80
74F49130Shipment Document Workfile14BWCARSCarrier NumberNumericGeneric Edit80
75F4918Load Tender History3LTCARSCarrier NumberNumericGeneric Edit80
76F4941Shipment Routing Steps5RSCARSCarrier NumberNumericGeneric Edit80
77F49490Document Selection5TQCARSCarrier NumberNumericGeneric Edit80
78F4950Routing Entries4RTCARSCarrier NumberNumericGeneric Edit80
79F49501Intermodal Detail Routing Entries5RDCARSCarrier NumberNumericGeneric Edit80
80F4952Routing Restrictions3RECARSCarrier NumberNumericGeneric Edit80
81F4956Option and Equipment Inclusions/Exclusions2IXCARSCarrier NumberNumericGeneric Edit80
82F4957Transportation Confirmed Batch Shipment14BCCARSCarrier NumberNumericGeneric Edit80
83F49595Document Print - Document Summary23DKCARSCarrier NumberNumericGeneric Edit80
84F4960Load Header31TMCARSCarrier NumberNumericGeneric Edit80
85F4963Load In-transit10TICARSCarrier NumberNumericGeneric Edit80
86F49631Load In-transit Ledger19TOCARSCarrier NumberNumericGeneric Edit80
87F49695Document Register23DRCARSCarrier NumberNumericGeneric Edit80
88F4972Rate Detail5RXCARSCarrier NumberNumericGeneric Edit80
89F4974RateWare XL Rate Constants1RWCARSCarrier NumberNumericGeneric Edit80
90F4977Rate Parameters1MRCARSCarrier NumberNumericGeneric Edit80
91F4981Freight Audit History18FHCARSCarrier NumberNumericGeneric Edit80
92F49T10Sales Order Release Staging Table14ORCARSCarrier NumberNumericGeneric Edit80
93F49T20Shipment Staging Table21SSCARSCarrier NumberNumericGeneric Edit80
94F49T30Sales Confirm Staging Table23SOCARSCarrier NumberNumericGeneric Edit80
TOP54R: Rental Management
95F54R099Rental Contract Header Ledger62HLCARSCarrier NumberNumericGeneric Edit80
96F54R10Rental Contract Header60CHCARSCarrier NumberNumericGeneric Edit80
97F54R11Rental Contract Detail94CDCARSCarrier NumberNumericGeneric Edit80
98F54R199Rental Contract Detail Ledger90DLCARSCarrier NumberNumericGeneric Edit80
TOP74: EMEA Localization
99F7430030Legal Document Header (Print Info) - COMM - 03B25PICARSCarrier NumberNumericGeneric Edit80
TOP76H: Chile
100F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H47PICARSCarrier NumberNumericGeneric Edit80