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

93 columns | Print definition?812 | CARS

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0401Z1Supplier Master - Batch File56VOCARSCarrier NumberNumericGeneric Edit80
TOP01: Address Book
2F0401Supplier Master42A6CARSCarrier NumberNumericGeneric Edit80
TOP03: Accounts Receivable
3F03012Customer Master by Line of Business89AICARSCarrier NumberNumericGeneric Edit80
4F03012Z1Customer Master LOB-Batch File102VOCARSCarrier 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
25F41UI001Inventory Transactions Detail File75ITCARSCarrier NumberNumericGeneric Edit80
TOP41B: Bulk Stock Management
26F41509Four-Point Analysis Maintenance File10PGCARSCarrier NumberNumericGeneric Edit80
TOP42: Sales Management
27F4020Freight/Additional Charges Rate Information4ARCARSCarrier NumberNumericGeneric Edit80
28F4201Sales Order Header File47SHCARSCarrier NumberNumericGeneric Edit80
29F42019Sales Order Header History File47SHCARSCarrier NumberNumericGeneric Edit80
30F4211Sales Order Detail File118SDCARSCarrier NumberNumericGeneric Edit80
31F42119Sales Order History File118SDCARSCarrier NumberNumericGeneric Edit80
32F42199S.O. Detail Ledger File118SLCARSCarrier NumberNumericGeneric Edit80
33F42565Invoice Print File90IWCARSCarrier NumberNumericGeneric Edit80
34F4290Delivery Note History10SECARSCarrier NumberNumericGeneric Edit80
35F42UI01SO Header Cache File (MBF)52ZHCARSCarrier NumberNumericGeneric Edit80
36F42UI12Sales Order Detail Cache 2 (MBF)44ZDCARSCarrier NumberNumericGeneric Edit80
37F42UI130Commitment Work File37ZCCARSCarrier NumberNumericGeneric Edit80
TOP42B: Sales Order Entry
38F42420Audit Log Transaction52ALCARSCarrier NumberNumericGeneric Edit80
TOP46: Warehouse Management
39F4600Warehouse Requests52R1CARSCarrier NumberNumericGeneric Edit80
40F4600PUWarehouse Requests - Purged50R1CARSCarrier NumberNumericGeneric Edit80
41F4611Warehouse Suggestions121R2CARSCarrier NumberNumericGeneric Edit80
42F4611PUWarehouse Suggestions - Purged120R2CARSCarrier NumberNumericGeneric Edit80
43F4611Z1Unedited Suggestion Table132SZCARSCarrier NumberNumericGeneric Edit80
44F46200Bulk Pick Requests26BRCARSCarrier NumberNumericGeneric Edit80
45F46200PUBulk Pick Requests - Purged26BRCARSCarrier NumberNumericGeneric Edit80
46F4942Z1Work File for F494239SYCARSCarrier NumberNumericGeneric Edit80
TOP47: Electronic Commerce
47F47011EDI Purchase Order Header - Inbound63SYCARSCarrier NumberNumericGeneric Edit80
48F47012EDI Purchase Order Detail - Inbound139SZCARSCarrier NumberNumericGeneric Edit80
49F47026EDI P.O. Acknowledgment Header - Outbound59SYCARSCarrier NumberNumericGeneric Edit80
50F47027EDI P.O. Acknowledgment Detail - Outbound139SZCARSCarrier NumberNumericGeneric Edit80
51F47037EDI Shipping Notice Detail - Outbound121SZCARSCarrier NumberNumericGeneric Edit80
52F470371EDI Shipping Notice Detail - Outbound137SZCARSCarrier NumberNumericGeneric Edit80
53F47046EDI Invoice Header (Sales) - Outbound59SYCARSCarrier NumberNumericGeneric Edit80
54F47047EDI Invoice Detail (Sales) - Outbound139SZCARSCarrier NumberNumericGeneric Edit80
55F470472EDI Invoice Expanded Detail (Sales)11S6CARSCarrier NumberNumericGeneric Edit80
56F47091EDI Request for Quote Header - Inbound63SYCARSCarrier NumberNumericGeneric Edit80
57F47092EDI Request for Quote Detail - Inbound139SZCARSCarrier NumberNumericGeneric Edit80
58F47106EDI Response to RFQ Header - Outbound59SYCARSCarrier NumberNumericGeneric Edit80
59F47107EDI Response to RFQ Detail - Outbound139SZCARSCarrier NumberNumericGeneric Edit80
60F47131EDI Purchase Order Change Header - Inbound60SYCARSCarrier NumberNumericGeneric Edit80
61F47132EDI Purchase Order Change Detail - Inbound140SZCARSCarrier NumberNumericGeneric Edit80
62F47146EDI P.O. Change Acknowledgment Header - Outbound60SYCARSCarrier NumberNumericGeneric Edit80
63F47147EDI P.O. Change Acknowledgment Detail - Outbound141SZCARSCarrier NumberNumericGeneric Edit80
TOP49: Transportation Management
64F49005Generate Tracking Number1TGCARSCarrier NumberNumericGeneric Edit80
65F490051Generate Tracking Number Segment1XGCARSCarrier NumberNumericGeneric Edit80
66F490052Generate Tracking Segment Next Number1YGCARSCarrier NumberNumericGeneric Edit80
67F490053Generate Tracking Number Separator1ZGCARSCarrier NumberNumericGeneric Edit80
68F4906Carrier Master1CMCARSCarrier NumberNumericGeneric Edit80
69F49110Transportation Bill of Lading Workfile16BWCARSCarrier NumberNumericGeneric Edit80
70F49130Shipment Document Workfile14BWCARSCarrier NumberNumericGeneric Edit80
71F4918Load Tender History3LTCARSCarrier NumberNumericGeneric Edit80
72F4941Shipment Routing Steps5RSCARSCarrier NumberNumericGeneric Edit80
73F49490Document Selection5TQCARSCarrier NumberNumericGeneric Edit80
74F4950Routing Entries4RTCARSCarrier NumberNumericGeneric Edit80
75F49501Intermodal Detail Routing Entries5RDCARSCarrier NumberNumericGeneric Edit80
76F4952Routing Restrictions3RECARSCarrier NumberNumericGeneric Edit80
77F4956Option and Equipment Inclusions/Exclusions2IXCARSCarrier NumberNumericGeneric Edit80
78F4957Transportation Confirmed Batch Shipment14BCCARSCarrier NumberNumericGeneric Edit80
79F49595Document Print - Document Summary23DKCARSCarrier NumberNumericGeneric Edit80
80F4960Load Header31TMCARSCarrier NumberNumericGeneric Edit80
81F4963Load In-transit10TICARSCarrier NumberNumericGeneric Edit80
82F49631Load In-transit Ledger19TOCARSCarrier NumberNumericGeneric Edit80
83F49695Document Register23DRCARSCarrier NumberNumericGeneric Edit80
84F4972Rate Detail5RXCARSCarrier NumberNumericGeneric Edit80
85F4977Rate Parameters1MRCARSCarrier NumberNumericGeneric Edit80
86F4981Freight Audit History18FHCARSCarrier NumberNumericGeneric Edit80
TOP55: Reserved for Clients
87F55FR001Storno Bolle10SBCARSCarrier NumberNumericGeneric Edit80
88F55IF421Sales Order per BO131SDCARSCarrier NumberNumericGeneric Edit80
89F55IF425Sales Order per BO - 2005131SDCARSCarrier NumberNumericGeneric Edit80
90F55IF565Invoice Work file Extension23EXCARSCarrier NumberNumericGeneric Edit80
91F55W0100Correction Invoice Print - WF1119SDCARSCarrier NumberNumericGeneric Edit80
TOP74: EMEA Localization
92F7430030Legal Document Header (Print Info) - COMM - 03B25PICARSCarrier NumberNumericGeneric Edit80
TOP76H: Chile
93F76H3B31Legal Document Header (Print Info) - CHI - 03B - 76H47PICARSCarrier NumberNumericGeneric Edit80