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 TABLESv3

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

115 columns | 0 Comments0 | Print definition?920 | DSC2

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP13: Plant/Equipment Management
1F13017Equipment Parts List29PLDSC2Description - Line 2StringGeneric Edit300
TOP13R: Resource Assignments
2F48311Resource Assignments34RADSC2Description - Line 2StringGeneric Edit300
3F48311SPurge - Resource Assignments34RADSC2Description - Line 2StringGeneric Edit300
4F48316Maintenance Rescheduling Metrics13RSDSC2Description - Line 2StringGeneric Edit300
TOP17: Customer Service Management
5F1775Claim Temporary Table8TCDSC2Description - Line 2StringGeneric Edit300
6F3111Z2Warranty Claim/Supplier Recovery processing45WPDSC2Description - Line 2StringGeneric Edit300
TOP31: Shop Floor Control
7F3111Work Order Parts List32WMDSC2Description - Line 2StringGeneric Edit300
8F3111SPurge - Shop Floor Parts List32WMDSC2Description - Line 2StringGeneric Edit300
9F3111Z1Outbound Work Order Parts List45SZDSC2Description - Line 2StringGeneric Edit300
TOP40: Inventory/OP Base
10F4011ZBatch Receiver File - Order Details60SZDSC2Description - Line 2StringGeneric Edit300
11F4012ZWWF - Destination Quantity16SPDSC2Description - Line 2StringGeneric Edit300
12F4104Item Cross Reference File9IVDSC2Description - Line 2StringGeneric Edit300
13F4211Z1Sales Order Detail Unedited Transaction File57SZDSC2Description - Line 2StringGeneric Edit300
14F4220Basic Serial Numbers5SWDSC2Description - Line 2StringGeneric Edit300
TOP41: Inventory Management
15F4101Item Master5IMDSC2Description - Line 2StringGeneric Edit300
16F4101AItem File13IMDSC2Description - Line 2StringGeneric Edit300
17F4101DItem Master - Alternative Description6IMDSC2Description - Line 2StringGeneric Edit300
18F4101Z1F4101 Item Master Unedited Transaction Table20SZDSC2Description - Line 2StringGeneric Edit300
19F41UI001Inventory Transactions Detail File213ITDSC2Description - Line 2StringGeneric Edit300
TOP41B: Bulk Stock Management
20F41012Conversion Table Interface File10VADSC2Description - Line 2StringGeneric Edit300
TOP41F: Apparel Management
21F41F02WFStyle End Item Workfile4S1DSC2Description - Line 2StringGeneric Edit300
22FCW09Item Revisions Work File6WRDSC2Description - Line 2StringGeneric Edit300
23FCW31Proposal Order Line Details45LVDSC2Description - Line 2StringGeneric Edit300
24FCW67Style Work Order Parts List38WMDSC2Description - Line 2StringGeneric Edit300
TOP42: Sales Management
25F4211Sales Order Detail File44SDDSC2Description - Line 2StringGeneric Edit300
26F42119Sales Order History File44SDDSC2Description - Line 2StringGeneric Edit300
27F42199S.O. Detail Ledger File44SLDSC2Description - Line 2StringGeneric Edit300
28F42565Invoice Print File19IWDSC2Description - Line 2StringGeneric Edit300
29F42UI11SO Detail Cache File (MBF)43ZDDSC2Description - Line 2StringGeneric Edit300
30F42UI521Pick Slips Detail File39S9DSC2Description - Line 2StringGeneric Edit300
TOP42B: Sales Order Entry
31F42420Audit Log Transaction44ALDSC2Description - Line 2StringGeneric Edit300
TOP43: Procurement
32F43080Approvals Fields Constants53PDDSC2Description - Line 2StringGeneric Edit300
33F4311Purchase Order Detail File45PDDSC2Description - Line 2StringGeneric Edit300
34F4311ZPurchase Order Generator File49PWDSC2Description - Line 2StringGeneric Edit300
35F4311Z1Purchase Order Detail Unedited Transaction Table58SZDSC2Description - Line 2StringGeneric Edit300
36F43121Z1Receipts Unedited Transaction Table115SZDSC2Description - Line 2StringGeneric Edit300
37F4314ZVoucher Match Selection File10PNDSC2Description - Line 2StringGeneric Edit300
38F43199P.O. Detail Ledger File - Flexible Version45OLDSC2Description - Line 2StringGeneric Edit300
39F4371Suggested Reorder Stock Items13PDDSC2Description - Line 2StringGeneric Edit300
40F43UI50DPO Print Detail Work File24PWDSC2Description - Line 2StringGeneric Edit300
TOP43E: Requisition Self Service
41F43E09F43E09 - Approvals Activity Table25AADSC2Description - Line 2StringGeneric Edit300
42F43E11Requisition Detail18RDDSC2Description - Line 2StringGeneric Edit300
TOP44H: Homebuilder Management
43F4450Lot Proceed Header (World)118JDDSC2Description - Line 2StringGeneric Edit300
44F4451Lot Proceed Detail (World)30JFDSC2Description - Line 2StringGeneric Edit300
45F4456Lot Proceed Entry (World)118JIDSC2Description - Line 2StringGeneric Edit300
46F4461Option Master (World)21JNDSC2Description - Line 2StringGeneric Edit300
47F44H301Plan Master19PMDSC2Description - Line 2StringGeneric Edit300
48F44H511Option Selections16OSDSC2Description - Line 2StringGeneric Edit300
49F44H511HOption Selection History17OHDSC2Description - Line 2StringGeneric Edit300
50F44H611Bid Details37BDDSC2Description - Line 2StringGeneric Edit300
51F44H611WBid Details Work File41BWDSC2Description - Line 2StringGeneric Edit300
52F44H711Lot Start Workfile43SWDSC2Description - Line 2StringGeneric Edit300
53F44H711PAfter Start Purchasing32TPDSC2Description - Line 2StringGeneric Edit300
54F44H711ZHB Lot Start Unedited Transaction File56SZDSC2Description - Line 2StringGeneric Edit300
55F44H71W1Lot Start Generation Workfile43GWDSC2Description - Line 2StringGeneric Edit300
56F44H73W1Lot Start - P.O. / Committment Generation Work File38CGDSC2Description - Line 2StringGeneric Edit300
TOP46: Warehouse Management
57F4600Warehouse Requests57R1DSC2Description - Line 2StringGeneric Edit300
58F4600PUWarehouse Requests - Purged55R1DSC2Description - Line 2StringGeneric Edit300
59F4611Warehouse Suggestions65R2DSC2Description - Line 2StringGeneric Edit300
60F4611PUWarehouse Suggestions - Purged64R2DSC2Description - Line 2StringGeneric Edit300
61F4611Z1Unedited Suggestion Table77SZDSC2Description - Line 2StringGeneric Edit300
TOP46L: License Plating
62F46LUI01Assign/Remove Items To LP Work File8WFDSC2Description - Line 2StringGeneric Edit300
TOP47: Electronic Commerce
63F47012EDI Purchase Order Detail - Inbound61SZDSC2Description - Line 2StringGeneric Edit300
64F47017EDI Purchase Order Detail - Outbound59SZDSC2Description - Line 2StringGeneric Edit300
65F47022EDI P.O. Acknowledgment Detail - Inbound59SZDSC2Description - Line 2StringGeneric Edit300
66F47027EDI P.O. Acknowledgment Detail - Outbound61SZDSC2Description - Line 2StringGeneric Edit300
67F47032EDI Shipping Notice Detail - Inbound54SZDSC2Description - Line 2StringGeneric Edit300
68F47037EDI Shipping Notice Detail - Outbound61SZDSC2Description - Line 2StringGeneric Edit300
69F470371EDI Shipping Notice Detail - Outbound69SZDSC2Description - Line 2StringGeneric Edit300
70F47042EDI Invoice Detail - Inbound51SZDSC2Description - Line 2StringGeneric Edit300
71F47047EDI Invoice Detail (Sales) - Outbound61SZDSC2Description - Line 2StringGeneric Edit300
72F47072EDI Receiving Advice Detail - Inbound60SZDSC2Description - Line 2StringGeneric Edit300
73F47077EDI Receiving Advice Detail - Outbound60SZDSC2Description - Line 2StringGeneric Edit300
74F47082EDI Price Sales Catalog Detail - Inbound20FYDSC2Description - Line 2StringGeneric Edit300
75F47092EDI Request for Quote Detail - Inbound61SZDSC2Description - Line 2StringGeneric Edit300
76F47097EDI Request for Quote Detail - Outbound59SZDSC2Description - Line 2StringGeneric Edit300
77F47102EDI Response to RFQ Detail - Inbound59SZDSC2Description - Line 2StringGeneric Edit300
78F47107EDI Response to RFQ Detail - Outbound61SZDSC2Description - Line 2StringGeneric Edit300
79F47122EDI Product Activity Data Detail - Inbound39MJDSC2Description - Line 2StringGeneric Edit300
80F47127EDI Product Activity Data Detail - Outbound39MJDSC2Description - Line 2StringGeneric Edit300
81F47132EDI Purchase Order Change Detail - Inbound62SZDSC2Description - Line 2StringGeneric Edit300
82F47137EDI Purchase Order Change Detail - Outbound60SZDSC2Description - Line 2StringGeneric Edit300
83F47142EDI P.O. Change Acknowledgment Detail - Inbound61SZDSC2Description - Line 2StringGeneric Edit300
84F47147EDI P.O. Change Acknowledgment Detail - Outbound63SZDSC2Description - Line 2StringGeneric Edit300
85F47157EDI Shipping Schedule Detail - Outbound62SZDSC2Description - Line 2StringGeneric Edit300
TOP49: Transportation Management
86F49T100Procurement Freight Request staging table29OBDSC2Description - Line 2StringGeneric Edit300
TOP54R: Rental Management
87F54R11Rental Contract Detail11CDDSC2Description - Line 2StringGeneric Edit300
88F54R199Rental Contract Detail Ledger13DLDSC2Description - Line 2StringGeneric Edit300
TOP74: EMEA Localization
89F7420033Sales Document Line (Print Info) - COMM - 428PIDSC2Description - Line 2StringGeneric Edit300
TOP74U: United Kingdom Localizations
90F74U0424SPC Subcontractor Payment Liability - UK - 4331PLDSC2Description - Line 2StringGeneric Edit300
TOP75I: India
91F75I309Personal Consumption - CENVAT setoff - IND - 412CSDSC2Description - Line 2StringGeneric Edit300
92F75I346Excise - D3-Form Table36Q9DSC2Description - Line 2StringGeneric Edit300
93F75I385RG23D Register - Issues - IND - 4232EDDSC2Description - Line 2StringGeneric Edit300
94F75I409Personal Consumption - VAT setoff - IND - 412VSDSC2Description - Line 2StringGeneric Edit300
TOP75T: Taiwan
95F75T42WWork file with union of F4211 and F4211919SWDSC2Description - Line 2StringGeneric Edit300
TOP76A: Argentina
96F760101AA/B Tag Table - ARG - 04 - 76A18V0DSC2Description - Line 2StringGeneric Edit300
97F76A010ZF0101Z2 Argentinean Tag Table - ARG - 01 - 76A21V9DSC2Description - Line 2StringGeneric Edit300
98F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A9DLDSC2Description - Line 2StringGeneric Edit300
99F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A9DLDSC2Description - Line 2StringGeneric Edit300
100F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A9DLDSC2Description - Line 2StringGeneric Edit300
TOP76B: Brazil
101F76111BNota Fiscal - Detail (Fiscal Books) - 429QUDSC2Description - Line 2StringGeneric Edit300
102F76111BTConversion table for CFOP 5 digits - F76111B - 429TADSC2Description - Line 2StringGeneric Edit300
103F7611BNota Fiscal Detail - BRA - 4231FDDSC2Description - Line 2StringGeneric Edit300
104F761BAAS Fiscal file book - 0935FBDSC2Description - Line 2StringGeneric Edit300
105F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4211IMDSC2Description - Line 2StringGeneric Edit300
TOP76H: Chile
106F76H101TAddress Book Tag File - CHI - 01 - 76H5AHDSC2Description - Line 2StringGeneric Edit300
107F76H101ZEDI - A/B Tag File - CHI - 76H - 76H8AHDSC2Description - Line 2StringGeneric Edit300
108F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H10PIDSC2Description - Line 2StringGeneric Edit300
109F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H10PIDSC2Description - Line 2StringGeneric Edit300
TOP76P: Peru
110F76P101TAddress Book Tag File - PER - 01 - 76P7APDSC2Description - Line 2StringGeneric Edit300
111F76P101ZEDI - A/B Tag File - PER - 76P - 76P10AHDSC2Description - Line 2StringGeneric Edit300
TOP89: Conversion Programs
112F43199ATemp F43199 for ERP 9.0 Upgrade45OLDSC2Description - Line 2StringGeneric Edit300
TOPF30L: DFM Line Design
113FF30L501DFM Item Definition Master7IBDSC2Description - Line 2StringGeneric Edit300
TOPF31: Lean Transactions
114FF31111Lean Transaction Parts List33PLDSC2Description - Line 2StringGeneric Edit300
115FF31111SPurge - Lean Transaction Parts List33PRDSC2Description - Line 2StringGeneric Edit300

TOPUser Contributed Notes

There are no comments yet
Add comment

Feel you can add your value to this page with something useful - or wish to point out a 'gotcha' that the JDE community could benefit from avoiding? Please share it with the community using the form below. Please comment in English.

This is the name that will be displayed on the site. Un-check for anonymous posting
This will be displayed in a non-harvest-able format - e.g. joe dot bloggs at jdetables dot com. Un-check if you do not wish to display your e-mail address
This comment field will only except plain text. All mark-up will be stripped out
You're human right? Prove it! Please enter the full table name at row number 4
* = required field