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
3F0911GLAccount Ledger
4F4101IMItem Master
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

109 columns | Print definition?910 | 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
TOP37: Quality Management
11F37900Certificate of Analysis (COA) Extract76TRSOQSQuantity ShippedNumericGeneric Edit152
TOP40: Inventory/OP Base
12F4011ZBatch Receiver File - Order Details82SZSOQSQuantity ShippedNumericGeneric Edit152
13F4012ZWWF - Destination Quantity41SPSOQSQuantity ShippedNumericGeneric Edit152
14F4013ZKit Components Batch File8KSSOQSQuantity ShippedNumericGeneric Edit152
15F4211AUSales Order Detail Audit File38AUSOQSQuantity ShippedNumericGeneric Edit152
16F4211DTSales Order Detail Date Tracking File26DTSOQSQuantity ShippedNumericGeneric Edit152
17F4211Z1Sales Order Detail Unedited Transaction File79SZSOQSQuantity ShippedNumericGeneric Edit152
TOP40R: Demand Scheduling
18F40R41Demand History76DISOQSQuantity ShippedNumericGeneric Edit152
19F47UI002ASN Extract Packaging Work File36SPSOQSQuantity ShippedNumericGeneric Edit152
TOP41F: Apparel Management
20FCW105Fair Share Sprinkling Rate5WFSOQSQuantity ShippedNumericGeneric Edit152
21FCW21Work File Confirm Shipments11WKSOQSQuantity ShippedNumericGeneric Edit152
22FCW31Proposal Order Line Details16LVSOQSQuantity ShippedNumericGeneric Edit152
23FCW68Style Work Order Routings52WLSOQSQuantity ShippedNumericGeneric Edit152
24FCW963Adjustment Calculation9ACSOQSQuantity ShippedNumericGeneric Edit152
TOP42: Sales Management
25F420UI55Kit Balance Work File13UISOQSQuantity ShippedNumericGeneric Edit152
26F4211Sales Order Detail File66SDSOQSQuantity ShippedNumericGeneric Edit152
27F42119Sales Order History File66SDSOQSQuantity ShippedNumericGeneric Edit152
28F42199S.O. Detail Ledger File66SLSOQSQuantity ShippedNumericGeneric Edit152
29F42565Invoice Print File23IWSOQSQuantity ShippedNumericGeneric Edit152
30F4290Delivery Note History18SESOQSQuantity ShippedNumericGeneric Edit152
31F42UI11SO Detail Cache File (MBF)54ZDSOQSQuantity ShippedNumericGeneric Edit152
32F42UI12Sales Order Detail Cache 2 (MBF)75ZDSOQSQuantity ShippedNumericGeneric Edit152
33F42UI521Pick Slips Detail File62S9SOQSQuantity ShippedNumericGeneric Edit152
34F42UI800Sales Detail Work File - Sales Update45SDSOQSQuantity ShippedNumericGeneric Edit152
TOP42B: Sales Order Entry
35F42420Audit Log Transaction30ALSOQSQuantity ShippedNumericGeneric Edit152
TOP42W: Fulfillment Management
36F427UI01Release Fulfillment Work File9RFSOQSQuantity ShippedNumericGeneric Edit152
TOP43: Procurement
37F43121ZReceiver workfile48PWSOQSQuantity ShippedNumericGeneric Edit152
TOP43S: Supplier Self Service
38F43001Procurement Self-Service Transaction Log18SASOQSQuantity ShippedNumericGeneric Edit152
TOP45: Advanced Pricing
39F4573Free Goods Reference File7RFSOQSQuantity ShippedNumericGeneric Edit152
40F4576Ship and Debit Claims49ACSOQSQuantity ShippedNumericGeneric Edit152
41F4576TMPShip and Debit Claims- Temp Table49ACSOQSQuantity ShippedNumericGeneric Edit152
42F4576Z1Ship and Debit Claims Unedited Transaction Table62Z1SOQSQuantity ShippedNumericGeneric Edit152
TOP46: Warehouse Management
43F4942Z1Work File for F494227SYSOQSQuantity ShippedNumericGeneric Edit152
TOP47: Electronic Commerce
44F47012EDI Purchase Order Detail - Inbound83SZSOQSQuantity ShippedNumericGeneric Edit152
45F47027EDI P.O. Acknowledgment Detail - Outbound83SZSOQSQuantity ShippedNumericGeneric Edit152
46F47037EDI Shipping Notice Detail - Outbound80SZSOQSQuantity ShippedNumericGeneric Edit152
47F470371EDI Shipping Notice Detail - Outbound90SZSOQSQuantity ShippedNumericGeneric Edit152
48F47047EDI Invoice Detail (Sales) - Outbound83SZSOQSQuantity ShippedNumericGeneric Edit152
49F47092EDI Request for Quote Detail - Inbound83SZSOQSQuantity ShippedNumericGeneric Edit152
50F47107EDI Response to RFQ Detail - Outbound83SZSOQSQuantity ShippedNumericGeneric Edit152
51F47132EDI Purchase Order Change Detail - Inbound84SZSOQSQuantity ShippedNumericGeneric Edit152
52F47147EDI P.O. Change Acknowledgment Detail - Outbound85SZSOQSQuantity ShippedNumericGeneric Edit152
53F47UI001ASN Extract Work File35SZSOQSQuantity ShippedNumericGeneric Edit152
TOP48: Work Order Processing
54F4801Work Order Master File66WASOQSQuantity ShippedNumericGeneric Edit152
55F4801SPurge - Work Order Master file66WASOQSQuantity ShippedNumericGeneric Edit152
56F4801Z1Outbound Work Order Header85SYSOQSQuantity ShippedNumericGeneric Edit152
57F48UI001X4801 Master Business Function Workfile69WASOQSQuantity ShippedNumericGeneric Edit152
TOP49: Transportation Management
58F49110Transportation Bill of Lading Workfile40BWSOQSQuantity ShippedNumericGeneric Edit152
59F4942Shipment Detail12ISSOQSQuantity ShippedNumericGeneric Edit152
60F49621Load Compartment Detail28TDSOQSQuantity ShippedNumericGeneric Edit152
61F49634Load In-Transit Confirmed Quantities Detail10QDSOQSQuantity ShippedNumericGeneric Edit152
62F49T10Sales Order Release Staging Table24ORSOQSQuantity ShippedNumericGeneric Edit152
63F49T20Shipment Staging Table16SSSOQSQuantity ShippedNumericGeneric Edit152
64F49T30Sales Confirm Staging Table16SOSOQSQuantity ShippedNumericGeneric Edit152
TOP55: Reserved for Clients
65F55BC04HKivét fej tábla3KFSOQSQuantity ShippedNumericGeneric Edit152
66F55FR001Storno Bolle18SBSOQSQuantity ShippedNumericGeneric Edit152
67F55IF421Sales Order per BO72SDSOQSQuantity ShippedNumericGeneric Edit152
68F55IF425Sales Order per BO - 200572SDSOQSQuantity ShippedNumericGeneric Edit152
69F55IFALBEsportazione provvigioni da F42117PRSOQSQuantity ShippedNumericGeneric Edit152
70F55IFCSVTabella csv Stampa Fattura - UK8CSSOQSQuantity ShippedNumericGeneric Edit152
71F55IFLOGhistorical log16HLSOQSQuantity ShippedNumericGeneric Edit152
72F55IFP01Kit Pricing File30KPSOQSQuantity ShippedNumericGeneric Edit152
73F55IFSFVEstrazione del venduto per Sales Force Automation19FSSOQSQuantity ShippedNumericGeneric Edit152
74F55PROVVEsportazione provvigioni da F42117PRSOQSQuantity ShippedNumericGeneric Edit152
75F55TR565TEMP TABLO5TMSOQSQuantity ShippedNumericGeneric Edit152
76F55W0100Correction Invoice Print - WF167SDSOQSQuantity ShippedNumericGeneric Edit152
77F59H0220CRM Case Tag File - Proposals11CCSOQSQuantity ShippedNumericGeneric Edit152
78F59I0021P07 Shipment Details14PDSOQSQuantity ShippedNumericGeneric Edit152
79F59W0025P31 Palets Shipment - Shipment Template11STSOQSQuantity ShippedNumericGeneric Edit152
80F59W0027P31 Palets Shipment - Pallet Items5PLSOQSQuantity ShippedNumericGeneric Edit152
TOP74: EMEA Localization
81F7420033Sales Document Line (Print Info) - COMM - 4210PISOQSQuantity ShippedNumericGeneric Edit152
TOP75I: India
82F75I2213Setoff Temp Table11TTSOQSQuantity ShippedNumericGeneric Edit152
83F75I309Personal Consumption - CENVAT setoff - IND - 4130CSSOQSQuantity ShippedNumericGeneric Edit152
84F75I322Excise - Work File for F04211 & F410117Q3SOQSQuantity ShippedNumericGeneric Edit152
85F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)17Q3SOQSQuantity ShippedNumericGeneric Edit152
86F75I3451Excise - ARE3 Form Detail-IND-0016QDSOQSQuantity ShippedNumericGeneric Edit152
87F75I346Excise - D3-Form Table16Q9SOQSQuantity ShippedNumericGeneric Edit152
88F75I385RG23D Register - Issues - IND - 4215EDSOQSQuantity ShippedNumericGeneric Edit152
89F75I401Sales Form Information-IND-4231QASOQSQuantity ShippedNumericGeneric Edit152
90F75I401CSales Form Information- Secondary23QASOQSQuantity ShippedNumericGeneric Edit152
91F75I403Stock Transfer Details18ABSOQSQuantity ShippedNumericGeneric Edit152
92F75I403TTemp Data for F75i40321ABSOQSQuantity ShippedNumericGeneric Edit152
93F75I4213Setoff Report Data -IND -0025SOSOQSQuantity ShippedNumericGeneric Edit152
94F75I4223Sales Tax Summary/Detail14SDSOQSQuantity ShippedNumericGeneric Edit152
95F75I601TCS Register Details-IND-4221TRSOQSQuantity ShippedNumericGeneric Edit152
TOP75T: Taiwan
96F75T42WWork file with union of F4211 and F4211935SWSOQSQuantity ShippedNumericGeneric Edit152
TOP76A: Argentina
97F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A12DLSOQSQuantity ShippedNumericGeneric Edit152
98F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A12DLSOQSQuantity ShippedNumericGeneric Edit152
99F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A12DLSOQSQuantity ShippedNumericGeneric Edit152
TOP76H: Chile
100F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H7PISOQSQuantity ShippedNumericGeneric Edit152
101F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H7PISOQSQuantity ShippedNumericGeneric Edit152
102F76H6008Manufactured Items - CHI - 41 - 76H8IPSOQSQuantity ShippedNumericGeneric Edit152
TOP80D: Plant Manager Dashboard
103F80D010Sales Order Fact15SFSOQSQuantity ShippedNumericGeneric Edit152
TOPF31: Lean Transactions
104FF31011TransactionID Master File8EHSOQSQuantity ShippedNumericGeneric Edit152
105FF31011SPurge - TransactionID Master File8ERSOQSQuantity ShippedNumericGeneric Edit152
106FF31112Routing Transaction Table71EHSOQSQuantity ShippedNumericGeneric Edit152
107FF31112SPurge - Routing Transaction Table71ETSOQSQuantity ShippedNumericGeneric Edit152
108FF31113Lean Transaction Labor Detail26LDSOQSQuantity ShippedNumericGeneric Edit152
109FF31113SPurge - Lean Transaction Labor Detail26LRSOQSQuantity ShippedNumericGeneric Edit152