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

83 columns | Print definition?812 | SOQS

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17: Customer Service Management
1F3112Z2Warranty Claim/Supplier Recovery processing61WLSOQSQuantity ShippedNumericGeneric Edit152
2F4801Z2Warranty Claim/Supplier Recovery processing85WSSOQSQuantity ShippedNumericGeneric Edit152
TOP31: Shop Floor Control
3F3112Work Order Routing49WLSOQSQuantity ShippedNumericGeneric Edit152
4F31122Work Order Time Transactions28WTSOQSQuantity ShippedNumericGeneric Edit152
5F31122SPurge Work Order Time Transactions28WTSOQSQuantity ShippedNumericGeneric Edit152
6F31122Z1Work Order Time Transactions Unedited Transaction Table42SZSOQSQuantity ShippedNumericGeneric Edit152
7F3112SPurge Shop Floor Control Routing Instructions49WLSOQSQuantity ShippedNumericGeneric Edit152
8F3112Z1Outbound Work Order Routings61SZSOQSQuantity ShippedNumericGeneric Edit152
9F3114Rate Schedule Transaction File7IQSOQSQuantity ShippedNumericGeneric Edit152
10F31UI002User Index - Variances16IGSOQSQuantity ShippedNumericGeneric Edit152
11F4801SPurge - Work Order Master file66WASOQSQuantity ShippedNumericGeneric Edit152
12F4801Z1Outbound Work Order Header85SYSOQSQuantity ShippedNumericGeneric Edit152
TOP37: Quality Management
13F37900Certificate of Analysis (COA) Extract76TRSOQSQuantity ShippedNumericGeneric Edit152
TOP40: Inventory/OP Base
14F4011ZBatch Receiver File - Order Details82SZSOQSQuantity ShippedNumericGeneric Edit152
15F4012ZWWF - Destination Quantity41SPSOQSQuantity ShippedNumericGeneric Edit152
16F4013ZKit Components Batch File8KSSOQSQuantity ShippedNumericGeneric Edit152
17F4211AUSales Order Detail Audit File38AUSOQSQuantity ShippedNumericGeneric Edit152
18F4211DTSales Order Detail Date Tracking File26DTSOQSQuantity ShippedNumericGeneric Edit152
19F4211Z1Sales Order Detail Unedited Transaction File79SZSOQSQuantity ShippedNumericGeneric Edit152
TOP40R: Demand Scheduling
20F40R41Demand History76DISOQSQuantity ShippedNumericGeneric Edit152
21F47UI002ASN Extract Packaging Work File36SPSOQSQuantity ShippedNumericGeneric Edit152
TOP42: Sales Management
22F4211Sales Order Detail File66SDSOQSQuantity ShippedNumericGeneric Edit152
23F42119Sales Order History File66SDSOQSQuantity ShippedNumericGeneric Edit152
24F42199S.O. Detail Ledger File66SLSOQSQuantity ShippedNumericGeneric Edit152
25F42565Invoice Print File23IWSOQSQuantity ShippedNumericGeneric Edit152
26F4290Delivery Note History18SESOQSQuantity ShippedNumericGeneric Edit152
27F42UI11SO Detail Cache File (MBF)54ZDSOQSQuantity ShippedNumericGeneric Edit152
28F42UI12Sales Order Detail Cache 2 (MBF)75ZDSOQSQuantity ShippedNumericGeneric Edit152
29F42UI130Commitment Work File16ZCSOQSQuantity ShippedNumericGeneric Edit152
30F42UI521Pick Slips Detail File62S9SOQSQuantity ShippedNumericGeneric Edit152
31F42UI800Sales Detail Work File - Sales Update45SDSOQSQuantity ShippedNumericGeneric Edit152
TOP42B: Sales Order Entry
32F42420Audit Log Transaction30ALSOQSQuantity ShippedNumericGeneric Edit152
TOP43: Procurement
33F43121ZReceiver workfile48PWSOQSQuantity ShippedNumericGeneric Edit152
TOP43S: Supplier Self Service
34F43001Procurement Self-Service Transaction Log18SASOQSQuantity ShippedNumericGeneric Edit152
TOP45: Advanced Pricing
35F4573Free Goods Reference File7RFSOQSQuantity ShippedNumericGeneric Edit152
36F4576Ship and Debit Claims49ACSOQSQuantity ShippedNumericGeneric Edit152
37F4576TMPShip and Debit Claims- Temp Table49ACSOQSQuantity ShippedNumericGeneric Edit152
38F4576Z1Ship and Debit Claims Unedited Transaction Table62Z1SOQSQuantity ShippedNumericGeneric Edit152
TOP46: Warehouse Management
39F4942Z1Work File for F494227SYSOQSQuantity ShippedNumericGeneric Edit152
TOP47: Electronic Commerce
40F47012EDI Purchase Order Detail - Inbound83SZSOQSQuantity ShippedNumericGeneric Edit152
41F47027EDI P.O. Acknowledgment Detail - Outbound83SZSOQSQuantity ShippedNumericGeneric Edit152
42F47037EDI Shipping Notice Detail - Outbound80SZSOQSQuantity ShippedNumericGeneric Edit152
43F470371EDI Shipping Notice Detail - Outbound90SZSOQSQuantity ShippedNumericGeneric Edit152
44F47047EDI Invoice Detail (Sales) - Outbound83SZSOQSQuantity ShippedNumericGeneric Edit152
45F47092EDI Request for Quote Detail - Inbound83SZSOQSQuantity ShippedNumericGeneric Edit152
46F47107EDI Response to RFQ Detail - Outbound83SZSOQSQuantity ShippedNumericGeneric Edit152
47F47132EDI Purchase Order Change Detail - Inbound84SZSOQSQuantity ShippedNumericGeneric Edit152
48F47147EDI P.O. Change Acknowledgment Detail - Outbound85SZSOQSQuantity ShippedNumericGeneric Edit152
49F47UI001ASN Extract Work File35SZSOQSQuantity ShippedNumericGeneric Edit152
TOP48: Work Order Processing
50F4801Work Order Master File66WASOQSQuantity ShippedNumericGeneric Edit152
51F48UI001X4801 Master Business Function Workfile69WASOQSQuantity ShippedNumericGeneric Edit152
TOP49: Transportation Management
52F49110Transportation Bill of Lading Workfile40BWSOQSQuantity ShippedNumericGeneric Edit152
53F4942Shipment Detail12ISSOQSQuantity ShippedNumericGeneric Edit152
54F49621Load Compartment Detail28TDSOQSQuantity ShippedNumericGeneric Edit152
55F49634Load In-Transit Confirmed Quantities Detail10QDSOQSQuantity ShippedNumericGeneric Edit152
TOP55: Reserved for Clients
56F55BC04HKivét fej tábla3KFSOQSQuantity ShippedNumericGeneric Edit152
57F55FR001Storno Bolle18SBSOQSQuantity ShippedNumericGeneric Edit152
58F55IF421Sales Order per BO72SDSOQSQuantity ShippedNumericGeneric Edit152
59F55IF425Sales Order per BO - 200572SDSOQSQuantity ShippedNumericGeneric Edit152
60F55IFALBEsportazione provvigioni da F42117PRSOQSQuantity ShippedNumericGeneric Edit152
61F55IFCSVTabella csv Stampa Fattura - UK8CSSOQSQuantity ShippedNumericGeneric Edit152
62F55IFLOGhistorical log16HLSOQSQuantity ShippedNumericGeneric Edit152
63F55IFP01Kit Pricing File30KPSOQSQuantity ShippedNumericGeneric Edit152
64F55IFSFVEstrazione del venduto per Sales Force Automation19FSSOQSQuantity ShippedNumericGeneric Edit152
65F55PROVVEsportazione provvigioni da F42117PRSOQSQuantity ShippedNumericGeneric Edit152
66F55TR565TEMP TABLO5TMSOQSQuantity ShippedNumericGeneric Edit152
67F55W0100Correction Invoice Print - WF167SDSOQSQuantity ShippedNumericGeneric Edit152
68F59H0220CRM Case Tag File - Proposals11CCSOQSQuantity ShippedNumericGeneric Edit152
69F59I0021P07 Shipment Details14PDSOQSQuantity ShippedNumericGeneric Edit152
TOP74: EMEA Localization
70F7420033Sales Document Line (Print Info) - COMM - 4210PISOQSQuantity ShippedNumericGeneric Edit152
TOP76A: Argentina
71F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A12DLSOQSQuantity ShippedNumericGeneric Edit152
72F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A12DLSOQSQuantity ShippedNumericGeneric Edit152
73F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0012DLSOQSQuantity ShippedNumericGeneric Edit152
TOP76H: Chile
74F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H7PISOQSQuantity ShippedNumericGeneric Edit152
75F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H7PISOQSQuantity ShippedNumericGeneric Edit152
76F76H6008Manufactured Items - CHI - 41 - 76H8IPSOQSQuantity ShippedNumericGeneric Edit152
TOPD3N: dcLINK (data collection) - DSI
77FD3N421PPallet Tracking Table 37SHSOQSQuantity ShippedNumericGeneric Edit152
TOPF31: Lean Transactions
78FF31011TransactionID Master File8EHSOQSQuantity ShippedNumericGeneric Edit152
79FF31011SPurge - TransactionID Master File8ERSOQSQuantity ShippedNumericGeneric Edit152
80FF31112Routing Transaction Table71EHSOQSQuantity ShippedNumericGeneric Edit152
81FF31112SPurge - Routing Transaction Table71ETSOQSQuantity ShippedNumericGeneric Edit152
82FF31113Lean Transaction Labor Detail26LDSOQSQuantity ShippedNumericGeneric Edit152
83FF31113SPurge - Lean Transaction Labor Detail26LRSOQSQuantity ShippedNumericGeneric Edit152