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

112 columns | Print definition?812 | 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
TOP42: Sales Management
21F4211Sales Order Detail File44SDDSC2Description - Line 2StringGeneric Edit300
22F42119Sales Order History File44SDDSC2Description - Line 2StringGeneric Edit300
23F42199S.O. Detail Ledger File44SLDSC2Description - Line 2StringGeneric Edit300
24F42565Invoice Print File19IWDSC2Description - Line 2StringGeneric Edit300
25F42UI11SO Detail Cache File (MBF)43ZDDSC2Description - Line 2StringGeneric Edit300
26F42UI521Pick Slips Detail File39S9DSC2Description - Line 2StringGeneric Edit300
TOP42B: Sales Order Entry
27F42420Audit Log Transaction44ALDSC2Description - Line 2StringGeneric Edit300
TOP43: Procurement
28F43080Approvals Fields Constants53PDDSC2Description - Line 2StringGeneric Edit300
29F4311Purchase Order Detail File45PDDSC2Description - Line 2StringGeneric Edit300
30F4311ZPurchase Order Generator File49PWDSC2Description - Line 2StringGeneric Edit300
31F4311Z1Purchase Order Detail Unedited Transaction Table58SZDSC2Description - Line 2StringGeneric Edit300
32F43121Z1Receipts Unedited Transaction Table115SZDSC2Description - Line 2StringGeneric Edit300
33F4314ZVoucher Match Selection File10PNDSC2Description - Line 2StringGeneric Edit300
34F43199P.O. Detail Ledger File - Flexible Version45OLDSC2Description - Line 2StringGeneric Edit300
35F4371Suggested Reorder Stock Items13PDDSC2Description - Line 2StringGeneric Edit300
36F43E09F43E09 - Approvals Activity Table25AADSC2Description - Line 2StringGeneric Edit300
37F43UI50DPO Print Detail Work File24PWDSC2Description - Line 2StringGeneric Edit300
TOP43E: Requisition Self Service
38F43E11Requisition Detail18RDDSC2Description - Line 2StringGeneric Edit300
TOP44H: Homebuilder Management
39F4450Lot Proceed Header (World)118JDDSC2Description - Line 2StringGeneric Edit300
40F4451Lot Proceed Detail (World)30JFDSC2Description - Line 2StringGeneric Edit300
41F4456Lot Proceed Entry (World)118JIDSC2Description - Line 2StringGeneric Edit300
42F4461Option Master (World)21JNDSC2Description - Line 2StringGeneric Edit300
43F44H301Plan Master19PMDSC2Description - Line 2StringGeneric Edit300
44F44H511Option Selections16OSDSC2Description - Line 2StringGeneric Edit300
45F44H511HOption Selection History17OHDSC2Description - Line 2StringGeneric Edit300
46F44H611Bid Details37BDDSC2Description - Line 2StringGeneric Edit300
47F44H611WBid Details Work File41BWDSC2Description - Line 2StringGeneric Edit300
48F44H711Lot Start Workfile43SWDSC2Description - Line 2StringGeneric Edit300
49F44H711PAfter Start Purchasing32TPDSC2Description - Line 2StringGeneric Edit300
50F44H711ZHB Lot Start Unedited Transaction File56SZDSC2Description - Line 2StringGeneric Edit300
51F44H71W1Lot Start Generation Workfile43GWDSC2Description - Line 2StringGeneric Edit300
52F44H73W1Lot Start - P.O. / Committment Generation Work File38CGDSC2Description - Line 2StringGeneric Edit300
TOP46: Warehouse Management
53F4600Warehouse Requests57R1DSC2Description - Line 2StringGeneric Edit300
54F4600PUWarehouse Requests - Purged55R1DSC2Description - Line 2StringGeneric Edit300
55F4611Warehouse Suggestions65R2DSC2Description - Line 2StringGeneric Edit300
56F4611PUWarehouse Suggestions - Purged64R2DSC2Description - Line 2StringGeneric Edit300
57F4611Z1Unedited Suggestion Table77SZDSC2Description - Line 2StringGeneric Edit300
TOP46L: License Plating
58F46LUI01Assign/Remove Items To LP Work File8WFDSC2Description - Line 2StringGeneric Edit300
TOP47: Electronic Commerce
59F47012EDI Purchase Order Detail - Inbound61SZDSC2Description - Line 2StringGeneric Edit300
60F47017EDI Purchase Order Detail - Outbound59SZDSC2Description - Line 2StringGeneric Edit300
61F47022EDI P.O. Acknowledgment Detail - Inbound59SZDSC2Description - Line 2StringGeneric Edit300
62F47027EDI P.O. Acknowledgment Detail - Outbound61SZDSC2Description - Line 2StringGeneric Edit300
63F47032EDI Shipping Notice Detail - Inbound54SZDSC2Description - Line 2StringGeneric Edit300
64F47037EDI Shipping Notice Detail - Outbound61SZDSC2Description - Line 2StringGeneric Edit300
65F470371EDI Shipping Notice Detail - Outbound69SZDSC2Description - Line 2StringGeneric Edit300
66F47042EDI Invoice Detail - Inbound51SZDSC2Description - Line 2StringGeneric Edit300
67F47047EDI Invoice Detail (Sales) - Outbound61SZDSC2Description - Line 2StringGeneric Edit300
68F47072EDI Receiving Advice Detail - Inbound60SZDSC2Description - Line 2StringGeneric Edit300
69F47077EDI Receiving Advice Detail - Outbound60SZDSC2Description - Line 2StringGeneric Edit300
70F47082EDI Price Sales Catalog Detail - Inbound20FYDSC2Description - Line 2StringGeneric Edit300
71F47092EDI Request for Quote Detail - Inbound61SZDSC2Description - Line 2StringGeneric Edit300
72F47097EDI Request for Quote Detail - Outbound59SZDSC2Description - Line 2StringGeneric Edit300
73F47102EDI Response to RFQ Detail - Inbound59SZDSC2Description - Line 2StringGeneric Edit300
74F47107EDI Response to RFQ Detail - Outbound61SZDSC2Description - Line 2StringGeneric Edit300
75F47122EDI Product Activity Data Detail - Inbound39MJDSC2Description - Line 2StringGeneric Edit300
76F47127EDI Product Activity Data Detail - Outbound39MJDSC2Description - Line 2StringGeneric Edit300
77F47132EDI Purchase Order Change Detail - Inbound62SZDSC2Description - Line 2StringGeneric Edit300
78F47137EDI Purchase Order Change Detail - Outbound60SZDSC2Description - Line 2StringGeneric Edit300
79F47142EDI P.O. Change Acknowledgment Detail - Inbound61SZDSC2Description - Line 2StringGeneric Edit300
80F47147EDI P.O. Change Acknowledgment Detail - Outbound63SZDSC2Description - Line 2StringGeneric Edit300
81F47157EDI Shipping Schedule Detail - Outbound62SZDSC2Description - Line 2StringGeneric Edit300
TOP55: Reserved for Clients
82F550200Correspondent Accounts Report13WFDSC2Description - Line 2StringGeneric Edit300
83F55IF421Sales Order per BO50SDDSC2Description - Line 2StringGeneric Edit300
84F55IF425Sales Order per BO - 200550SDDSC2Description - Line 2StringGeneric Edit300
85F55TR565TEMP TABLO3TMDSC2Description - Line 2StringGeneric Edit300
86F55W0100Correction Invoice Print - WF145SDDSC2Description - Line 2StringGeneric Edit300
87F59BO001Cash Journal Master File17CJDSC2Description - Line 2StringGeneric Edit300
88F59PO001Cash Journal Master File17CJDSC2Description - Line 2StringGeneric Edit300
89F74H1051Invoicing Workfile - New28IWDSC2Description - Line 2StringGeneric Edit300
90F59I0060Cycle Count Import Table13CCDSC2Description - Line 2StringGeneric Edit300
TOP74: EMEA Localization
91F7420033Sales Document Line (Print Info) - COMM - 428PIDSC2Description - Line 2StringGeneric Edit300
TOP76A: Argentina
92F760101AA/B Tag File - ARG18V0DSC2Description - Line 2StringGeneric Edit300
93F76A010ZF0101Z2 Argentinean Tag Table - ARG - 01 - 76A21V9DSC2Description - Line 2StringGeneric Edit300
94F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A9DLDSC2Description - Line 2StringGeneric Edit300
95F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A9DLDSC2Description - Line 2StringGeneric Edit300
96F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 009DLDSC2Description - Line 2StringGeneric Edit300
TOP76B: Brazil - Reporting System Only
97F76111BNota Fiscal - Detail (Fiscal Books) - 429QUDSC2Description - Line 2StringGeneric Edit300
98F76111BTConversion table for CFOP 5 digits - F76111B - 429TADSC2Description - Line 2StringGeneric Edit300
99F7611BNota Fiscal Detail - Brazil31FDDSC2Description - Line 2StringGeneric Edit300
100F761BAAS Fiscal file book35FBDSC2Description - Line 2StringGeneric Edit300
101F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4211IMDSC2Description - Line 2StringGeneric Edit300
TOP76H: Chile
102F76H101TAddress Book Tag File - CHI - 01 - 76H5AHDSC2Description - Line 2StringGeneric Edit300
103F76H101ZEDI - A/B Tag File - CHI - 76H - 76H8AHDSC2Description - Line 2StringGeneric Edit300
104F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H10PIDSC2Description - Line 2StringGeneric Edit300
105F76H3B38Shipment Guide Line (Print Info) - CHI - 03B - 76H10PIDSC2Description - Line 2StringGeneric Edit300
TOP76P: Peru
106F76P101TAddress Book Tag File - PER - 01 - 76P7APDSC2Description - Line 2StringGeneric Edit300
107F76P101ZEDI - A/B Tag File - PER - 76P - 76P10AHDSC2Description - Line 2StringGeneric Edit300
TOP89: Conversion Programs
108F43199ATemp F43199 for ERP 9.0 Upgrade45OLDSC2Description - Line 2StringGeneric Edit300
TOPF30L: DFM Line Design
109FF30L501DFM Item Definition Master7IBDSC2Description - Line 2StringGeneric Edit300
TOPF31: Lean Transactions
110FF31111Lean Transaction Parts List33PLDSC2Description - Line 2StringGeneric Edit300
111FF31111SPurge - Lean Transaction Parts List33PRDSC2Description - Line 2StringGeneric Edit300
TOPH91: Design Tools
112F98EVHDREvent Header File3EHDSC2Description - Line 2StringGeneric Edit300