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

98 columns | Print definition?920 | SOQS

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP17: Customer Service Management
1F3112Z2Warranty Claim/Supplier Recovery processing61WLSOQSQuantity ShippedNumericGeneric Edit150
2F4801Z2Warranty Claim/Supplier Recovery processing85WSSOQSQuantity ShippedNumericGeneric Edit150
TOP31: Shop Floor Control
3F3112Work Order Routing49WLSOQSQuantity ShippedNumericGeneric Edit150
4F31122Work Order Time Transactions28WTSOQSQuantity ShippedNumericGeneric Edit150
5F31122SPurge Work Order Time Transactions28WTSOQSQuantity ShippedNumericGeneric Edit150
6F31122Z1Work Order Time Transactions Unedited Transaction Table42SZSOQSQuantity ShippedNumericGeneric Edit150
7F3112SPurge Shop Floor Control Routing Instructions49WLSOQSQuantity ShippedNumericGeneric Edit150
8F3112Z1Outbound Work Order Routings61SZSOQSQuantity ShippedNumericGeneric Edit150
9F3114Rate Schedule Transaction File7IQSOQSQuantity ShippedNumericGeneric Edit150
10F31UI002User Index - Variances16IGSOQSQuantity ShippedNumericGeneric Edit150
TOP31A: Manufacturing Accounting
11F30UI003WIP Revaluation Work File24WRSOQSQuantity ShippedNumericGeneric Edit150
TOP34X: In-Memory Planning Advisor
12F34X200WPlanning Details Supply/Demand Work Table36SDSOQSQuantity ShippedNumericGeneric Edit150
TOP37: Quality Management
13F37900Certificate of Analysis (COA) Extract76TRSOQSQuantity ShippedNumericGeneric Edit150
TOP40: Inventory/OP Base
14F4011ZBatch Receiver File - Order Details82SZSOQSQuantity ShippedNumericGeneric Edit150
15F4012ZWWF - Destination Quantity41SPSOQSQuantity ShippedNumericGeneric Edit150
16F4013ZKit Components Batch File8KSSOQSQuantity ShippedNumericGeneric Edit150
17F4211AUSales Order Detail Audit File38AUSOQSQuantity ShippedNumericGeneric Edit150
18F4211DTSales Order Detail Date Tracking File26DTSOQSQuantity ShippedNumericGeneric Edit150
19F4211Z1Sales Order Detail Unedited Transaction File79SZSOQSQuantity ShippedNumericGeneric Edit150
TOP40R: Demand Scheduling
20F40R41Demand History76DISOQSQuantity ShippedNumericGeneric Edit150
21F47UI002ASN Extract Packaging Work File36SPSOQSQuantity ShippedNumericGeneric Edit150
TOP41F: Apparel Management
22FCW105Fair Share Sprinkling Rate5WFSOQSQuantity ShippedNumericGeneric Edit150
23FCW21Work File Confirm Shipments11WKSOQSQuantity ShippedNumericGeneric Edit150
24FCW31Proposal Order Line Details16LVSOQSQuantity ShippedNumericGeneric Edit150
25FCW68Style Work Order Routings52WLSOQSQuantity ShippedNumericGeneric Edit150
26FCW963Adjustment Calculation9ACSOQSQuantity ShippedNumericGeneric Edit150
TOP42: Sales Management
27F420UI55Kit Balance Work File13UISOQSQuantity ShippedNumericGeneric Edit150
28F4211Sales Order Detail File66SDSOQSQuantity ShippedNumericGeneric Edit150
29F42119Sales Order History File66SDSOQSQuantity ShippedNumericGeneric Edit150
30F42199S.O. Detail Ledger File66SLSOQSQuantity ShippedNumericGeneric Edit150
31F42565Invoice Print File23IWSOQSQuantity ShippedNumericGeneric Edit150
32F4290Delivery Note History18SESOQSQuantity ShippedNumericGeneric Edit150
33F42UI11SO Detail Cache File (MBF)54ZDSOQSQuantity ShippedNumericGeneric Edit150
34F42UI12Sales Order Detail Cache 2 (MBF)75ZDSOQSQuantity ShippedNumericGeneric Edit150
35F42UI130Commitment Work File16ZCSOQSQuantity ShippedNumericGeneric Edit150
36F42UI521Pick Slips Detail File62S9SOQSQuantity ShippedNumericGeneric Edit150
37F42UI800Sales Detail Work File - Sales Update45SDSOQSQuantity ShippedNumericGeneric Edit150
TOP42B: Sales Order Entry
38F4211SWSales Order Detail Summary Work File9SSSOQSQuantity ShippedNumericGeneric Edit150
39F42420Audit Log Transaction30ALSOQSQuantity ShippedNumericGeneric Edit150
TOP42I: Outbound Inventory Management
40F42I02Outbound Inventory Agreement Acknowledge42OISOQSQuantity ShippedNumericGeneric Edit150
TOP42W: Fulfilment Management
41F427UI01Release Fulfillment Work File9RFSOQSQuantity ShippedNumericGeneric Edit150
TOP42X: In-Memory Sales Advisor
42F42X060WSupply Monitor Chart Work File28DCSOQSQuantity ShippedNumericGeneric Edit150
TOP43: Procurement
43F43121ZReceiver workfile48PWSOQSQuantity ShippedNumericGeneric Edit150
TOP43S: JSSS/Supplier Self Service
44F43001Procurement Self-Service Transaction Log18SASOQSQuantity ShippedNumericGeneric Edit150
TOP45: Advanced Pricing
45F4573Free Goods Reference File7RFSOQSQuantity ShippedNumericGeneric Edit150
46F4576Ship and Debit Claims49ACSOQSQuantity ShippedNumericGeneric Edit150
47F4576TMPShip and Debit Claims- Temp Table49ACSOQSQuantity ShippedNumericGeneric Edit150
48F4576Z1Ship and Debit Claims Unedited Transaction Table62Z1SOQSQuantity ShippedNumericGeneric Edit150
TOP46: Warehouse Management
49F4942Z1Work File for F494227SYSOQSQuantity ShippedNumericGeneric Edit150
TOP47: Electronic Commerce
50F47012EDI Purchase Order Detail - Inbound83SZSOQSQuantity ShippedNumericGeneric Edit150
51F47027EDI P.O. Acknowledgment Detail - Outbound83SZSOQSQuantity ShippedNumericGeneric Edit150
52F47037EDI Shipping Notice Detail - Outbound80SZSOQSQuantity ShippedNumericGeneric Edit150
53F470371EDI Shipping Notice Detail - Outbound90SZSOQSQuantity ShippedNumericGeneric Edit150
54F47047EDI Invoice Detail (Sales) - Outbound83SZSOQSQuantity ShippedNumericGeneric Edit150
55F47092EDI Request for Quote Detail - Inbound83SZSOQSQuantity ShippedNumericGeneric Edit150
56F47107EDI Response to RFQ Detail - Outbound83SZSOQSQuantity ShippedNumericGeneric Edit150
57F47132EDI Purchase Order Change Detail - Inbound84SZSOQSQuantity ShippedNumericGeneric Edit150
58F47147EDI P.O. Change Acknowledgment Detail - Outbound85SZSOQSQuantity ShippedNumericGeneric Edit150
59F47UI001ASN Extract Work File35SZSOQSQuantity ShippedNumericGeneric Edit150
TOP48: Work Order Processing
60F4801Work Order Master File66WASOQSQuantity ShippedNumericGeneric Edit150
61F4801SPurge - Work Order Master file66WASOQSQuantity ShippedNumericGeneric Edit150
62F4801Z1Outbound Work Order Header85SYSOQSQuantity ShippedNumericGeneric Edit150
63F48UI001X4801 Master Business Function Workfile69WASOQSQuantity ShippedNumericGeneric Edit150
TOP49: Transportation Management
64F49110Transportation Bill of Lading Workfile40BWSOQSQuantity ShippedNumericGeneric Edit150
65F4942Shipment Detail12ISSOQSQuantity ShippedNumericGeneric Edit150
66F49621Load Compartment Detail28TDSOQSQuantity ShippedNumericGeneric Edit150
67F49634Load In-Transit Confirmed Quantities Detail10QDSOQSQuantity ShippedNumericGeneric Edit150
68F49T10Sales Order Release Staging Table24ORSOQSQuantity ShippedNumericGeneric Edit150
69F49T20Shipment Staging Table16SSSOQSQuantity ShippedNumericGeneric Edit150
70F49T30Sales Confirm Staging Table16SOSOQSQuantity ShippedNumericGeneric Edit150
TOP74: EMEA Localization
71F7420033Sales Document Line (Print Info) - COMM - 4210PISOQSQuantity ShippedNumericGeneric Edit150
TOP75I: India
72F75I2213Setoff Temp Table11TTSOQSQuantity ShippedNumericGeneric Edit150
73F75I309Personal Consumption - CENVAT setoff - IND - 4130CSSOQSQuantity ShippedNumericGeneric Edit150
74F75I322Excise - Work File for F04211 & F410117Q3SOQSQuantity ShippedNumericGeneric Edit150
75F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)17Q3SOQSQuantity ShippedNumericGeneric Edit150
76F75I3451Excise - ARE3 Form Detail-IND-0016QDSOQSQuantity ShippedNumericGeneric Edit150
77F75I346Excise - D3-Form Table16Q9SOQSQuantity ShippedNumericGeneric Edit150
78F75I385RG23D Register - Issues - IND - 4215EDSOQSQuantity ShippedNumericGeneric Edit150
79F75I401Sales Form Information-IND-4231QASOQSQuantity ShippedNumericGeneric Edit150
80F75I401CSales Form Information- Secondary23QASOQSQuantity ShippedNumericGeneric Edit150
81F75I403Stock Transfer Details18ABSOQSQuantity ShippedNumericGeneric Edit150
82F75I403TTemp Data for F75i40321ABSOQSQuantity ShippedNumericGeneric Edit150
83F75I4213Setoff Report Data -IND -0025SOSOQSQuantity ShippedNumericGeneric Edit150
84F75I4223Sales Tax Summary/Detail14SDSOQSQuantity ShippedNumericGeneric Edit150
85F75I601TCS Register Details-IND-4221TRSOQSQuantity ShippedNumericGeneric Edit150
TOP75T: Taiwan
86F75T42WWork file with union of F4211 and F4211935SWSOQSQuantity ShippedNumericGeneric Edit150
TOP76A: Argentina
87F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A12DLSOQSQuantity ShippedNumericGeneric Edit150
88F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A12DLSOQSQuantity ShippedNumericGeneric Edit150
89F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A12DLSOQSQuantity ShippedNumericGeneric Edit150
TOP76H: Chile
90F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H7PISOQSQuantity ShippedNumericGeneric Edit150
91F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H7PISOQSQuantity ShippedNumericGeneric Edit150
92F76H6008Manufactured Items - CHI - 41 - 76H8IPSOQSQuantity ShippedNumericGeneric Edit150
TOPF31: Lean Transactions
93FF31011TransactionID Master File8EHSOQSQuantity ShippedNumericGeneric Edit150
94FF31011SPurge - TransactionID Master File8ERSOQSQuantity ShippedNumericGeneric Edit150
95FF31112Routing Transaction Table71EHSOQSQuantity ShippedNumericGeneric Edit150
96FF31112SPurge - Routing Transaction Table71ETSOQSQuantity ShippedNumericGeneric Edit150
97FF31113Lean Transaction Labor Detail26LDSOQSQuantity ShippedNumericGeneric Edit150
98FF31113SPurge - Lean Transaction Labor Detail26LRSOQSQuantity ShippedNumericGeneric Edit150