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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

93 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
TOP74: EMEA Localization
65F7420033Sales Document Line (Print Info) - COMM - 4210PISOQSQuantity ShippedNumericGeneric Edit152
TOP75I: India
66F75I2213Setoff Temp Table11TTSOQSQuantity ShippedNumericGeneric Edit152
67F75I309Personal Consumption - CENVAT setoff - IND - 4130CSSOQSQuantity ShippedNumericGeneric Edit152
68F75I322Excise - Work File for F04211 & F410117Q3SOQSQuantity ShippedNumericGeneric Edit152
69F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)17Q3SOQSQuantity ShippedNumericGeneric Edit152
70F75I3451Excise - ARE3 Form Detail-IND-0016QDSOQSQuantity ShippedNumericGeneric Edit152
71F75I346Excise - D3-Form Table16Q9SOQSQuantity ShippedNumericGeneric Edit152
72F75I385RG23D Register - Issues - IND - 4215EDSOQSQuantity ShippedNumericGeneric Edit152
73F75I401Sales Form Information-IND-4231QASOQSQuantity ShippedNumericGeneric Edit152
74F75I401CSales Form Information- Secondary23QASOQSQuantity ShippedNumericGeneric Edit152
75F75I403Stock Transfer Details18ABSOQSQuantity ShippedNumericGeneric Edit152
76F75I403TTemp Data for F75i40321ABSOQSQuantity ShippedNumericGeneric Edit152
77F75I4213Setoff Report Data -IND -0025SOSOQSQuantity ShippedNumericGeneric Edit152
78F75I4223Sales Tax Summary/Detail14SDSOQSQuantity ShippedNumericGeneric Edit152
79F75I601TCS Register Details-IND-4221TRSOQSQuantity ShippedNumericGeneric Edit152
TOP75T: Taiwan
80F75T42WWork file with union of F4211 and F4211935SWSOQSQuantity ShippedNumericGeneric Edit152
TOP76A: Argentina
81F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A12DLSOQSQuantity ShippedNumericGeneric Edit152
82F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A12DLSOQSQuantity ShippedNumericGeneric Edit152
83F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A12DLSOQSQuantity ShippedNumericGeneric Edit152
TOP76H: Chile
84F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H7PISOQSQuantity ShippedNumericGeneric Edit152
85F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H7PISOQSQuantity ShippedNumericGeneric Edit152
86F76H6008Manufactured Items - CHI - 41 - 76H8IPSOQSQuantity ShippedNumericGeneric Edit152
TOP80D: Plant Manager Dashboard
87F80D010Sales Order Fact15SFSOQSQuantity ShippedNumericGeneric Edit152
TOPF31: Lean Transactions
88FF31011TransactionID Master File8EHSOQSQuantity ShippedNumericGeneric Edit152
89FF31011SPurge - TransactionID Master File8ERSOQSQuantity ShippedNumericGeneric Edit152
90FF31112Routing Transaction Table71EHSOQSQuantity ShippedNumericGeneric Edit152
91FF31112SPurge - Routing Transaction Table71ETSOQSQuantity ShippedNumericGeneric Edit152
92FF31113Lean Transaction Labor Detail26LDSOQSQuantity ShippedNumericGeneric Edit152
93FF31113SPurge - Lean Transaction Labor Detail26LRSOQSQuantity ShippedNumericGeneric Edit152