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

78 columns | Print definition?910 | ANBY

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP40: Inventory/OP Base
1F4001ZBatch Receiver File - Order Headings70SYANBYBuyer NumberNumericGeneric Edit80
2F4011ZBatch Receiver File - Order Details137SZANBYBuyer NumberNumericGeneric Edit80
3F4012ZWWF - Destination Quantity26SPANBYBuyer NumberNumericGeneric Edit80
4F40500Commodity Structure Definitions7CCANBYBuyer NumberNumericGeneric Edit80
5F4201Z1Sales Order Header Unedited Transaction File59SYANBYBuyer NumberNumericGeneric Edit80
6F4211Z1Sales Order Detail Unedited Transaction File250SZANBYBuyer NumberNumericGeneric Edit80
TOP42: Sales Management
7F4201Sales Order Header File46SHANBYBuyer NumberNumericGeneric Edit80
8F42019Sales Order Header History File46SHANBYBuyer NumberNumericGeneric Edit80
9F4211Sales Order Detail File242SDANBYBuyer NumberNumericGeneric Edit80
10F42119Sales Order History File242SDANBYBuyer NumberNumericGeneric Edit80
11F42199S.O. Detail Ledger File242SLANBYBuyer NumberNumericGeneric Edit80
12F42UI01SO Header Cache File (MBF)51ZHANBYBuyer NumberNumericGeneric Edit80
13F42UI12Sales Order Detail Cache 2 (MBF)105ZDANBYBuyer NumberNumericGeneric Edit80
14F42UI520Pick Slips Header File38S8ANBYBuyer NumberNumericGeneric Edit80
15F470371TTag for F470371- EDI shipping Notice Detail - Outbound4UZANBYBuyer NumberNumericGeneric Edit80
TOP43: Procurement
16F4301Purchase Order Header43PHANBYBuyer NumberNumericGeneric Edit80
17F4301ZPO Header Work File47PAANBYBuyer NumberNumericGeneric Edit80
18F4301Z1Purchase Order Header Unedited Transaction Table56SYANBYBuyer NumberNumericGeneric Edit80
19F43080Approvals Fields Constants104PDANBYBuyer NumberNumericGeneric Edit80
20F4311Purchase Order Detail File100PDANBYBuyer NumberNumericGeneric Edit80
21F4311ZPurchase Order Generator File104PWANBYBuyer NumberNumericGeneric Edit80
22F4311Z1Purchase Order Detail Unedited Transaction Table113SZANBYBuyer NumberNumericGeneric Edit80
23F43199P.O. Detail Ledger File - Flexible Version100OLANBYBuyer NumberNumericGeneric Edit80
24F43UI50HPO Print Header Work File46PAANBYBuyer NumberNumericGeneric Edit80
TOP43E: Requisition Self Service
25F43E09F43E09 - Approvals Activity Table12AAANBYBuyer NumberNumericGeneric Edit80
26F43E11Requisition Detail9RDANBYBuyer NumberNumericGeneric Edit80
27F43E121eRequisition Receiver file8ERANBYBuyer NumberNumericGeneric Edit80
TOP43S: Supplier Self Service
28F43001Procurement Self-Service Transaction Log4SAANBYBuyer NumberNumericGeneric Edit80
TOP44H: Homebuilder Management
29F44H601Bid Header18BHANBYBuyer NumberNumericGeneric Edit80
30F44H611Bid Details56BDANBYBuyer NumberNumericGeneric Edit80
31F44H611WBid Details Work File60BWANBYBuyer NumberNumericGeneric Edit80
32F44H711Lot Start Workfile64SWANBYBuyer NumberNumericGeneric Edit80
33F44H711PAfter Start Purchasing36TPANBYBuyer NumberNumericGeneric Edit80
34F44H711ZHB Lot Start Unedited Transaction File77SZANBYBuyer NumberNumericGeneric Edit80
35F44H71W1Lot Start Generation Workfile64GWANBYBuyer NumberNumericGeneric Edit80
36F44H73W1Lot Start - P.O. / Committment Generation Work File78CGANBYBuyer NumberNumericGeneric Edit80
TOP47: Electronic Commerce
37F47011EDI Purchase Order Header - Inbound62SYANBYBuyer NumberNumericGeneric Edit80
38F47012EDI Purchase Order Detail - Inbound138SZANBYBuyer NumberNumericGeneric Edit80
39F47016EDI Purchase Order Header - Outbound58SYANBYBuyer NumberNumericGeneric Edit80
40F47017EDI Purchase Order Detail - Outbound114SZANBYBuyer NumberNumericGeneric Edit80
41F47021EDI P.O. Acknowledgment Header - Inbound58SYANBYBuyer NumberNumericGeneric Edit80
42F47022EDI P.O. Acknowledgment Detail - Inbound114SZANBYBuyer NumberNumericGeneric Edit80
43F47026EDI P.O. Acknowledgment Header - Outbound58SYANBYBuyer NumberNumericGeneric Edit80
44F47027EDI P.O. Acknowledgment Detail - Outbound138SZANBYBuyer NumberNumericGeneric Edit80
45F47031EDI Shipping Notice Header - Inbound53SYANBYBuyer NumberNumericGeneric Edit80
46F47032EDI Shipping Notice Detail - Inbound84SZANBYBuyer NumberNumericGeneric Edit80
47F47046EDI Invoice Header (Sales) - Outbound58SYANBYBuyer NumberNumericGeneric Edit80
48F47047EDI Invoice Detail (Sales) - Outbound138SZANBYBuyer NumberNumericGeneric Edit80
49F47071EDI Receiving Advice Header - Inbound59SYANBYBuyer NumberNumericGeneric Edit80
50F47072EDI Receiving Advice Detail - Inbound115SZANBYBuyer NumberNumericGeneric Edit80
51F47076EDI Receiving Advice Header - Outbound59SYANBYBuyer NumberNumericGeneric Edit80
52F47077EDI Receiving Advice Detail - Outbound115SZANBYBuyer NumberNumericGeneric Edit80
53F47091EDI Request for Quote Header - Inbound62SYANBYBuyer NumberNumericGeneric Edit80
54F47092EDI Request for Quote Detail - Inbound138SZANBYBuyer NumberNumericGeneric Edit80
55F47096EDI Request for Quote Header - Outbound58SYANBYBuyer NumberNumericGeneric Edit80
56F47097EDI Request for Quote Detail - Outbound114SZANBYBuyer NumberNumericGeneric Edit80
57F47101EDI Response to RFQ Header - Inbound58SYANBYBuyer NumberNumericGeneric Edit80
58F47102EDI Response to RFQ Detail - Inbound114SZANBYBuyer NumberNumericGeneric Edit80
59F47106EDI Response to RFQ Header - Outbound58SYANBYBuyer NumberNumericGeneric Edit80
60F47107EDI Response to RFQ Detail - Outbound138SZANBYBuyer NumberNumericGeneric Edit80
61F47131EDI Purchase Order Change Header - Inbound59SYANBYBuyer NumberNumericGeneric Edit80
62F47132EDI Purchase Order Change Detail - Inbound139SZANBYBuyer NumberNumericGeneric Edit80
63F47136EDI Purchase Order Change Header - Outbound58SYANBYBuyer NumberNumericGeneric Edit80
64F47137EDI Purchase Order Change Detail - Outbound115SZANBYBuyer NumberNumericGeneric Edit80
65F47141EDI P.O. Change Acknowledgment Header - Inbound59SYANBYBuyer NumberNumericGeneric Edit80
66F47142EDI P.O. Change Acknowledgment Detail - Inbound116SZANBYBuyer NumberNumericGeneric Edit80
67F47146EDI P.O. Change Acknowledgment Header - Outbound59SYANBYBuyer NumberNumericGeneric Edit80
68F47147EDI P.O. Change Acknowledgment Detail - Outbound140SZANBYBuyer NumberNumericGeneric Edit80
69F47156EDI Shipping Schedule Header - Outbound61SYANBYBuyer NumberNumericGeneric Edit80
70F47157EDI Shipping Schedule Detail - Outbound121SZANBYBuyer NumberNumericGeneric Edit80
TOP49: Transportation Management
71F49T10Sales Order Release Staging Table13ORANBYBuyer NumberNumericGeneric Edit80
72F49T100Procurement Freight Request staging table22OBANBYBuyer NumberNumericGeneric Edit80
TOP55: Reserved for Clients
73F55IF421Sales Order per BO130SDANBYBuyer NumberNumericGeneric Edit80
74F55IF425Sales Order per BO - 2005130SDANBYBuyer NumberNumericGeneric Edit80
75F55W0100Correction Invoice Print - WF1243SDANBYBuyer NumberNumericGeneric Edit80
TOP89: Conversion Programs
76F43199ATemp F43199 for ERP 9.0 Upgrade100OLANBYBuyer NumberNumericGeneric Edit80
TOPH91: Design Tools
77F98TC002Table Conversion Normalized 15TNANBYBuyer NumberNumericGeneric Edit80
78F98TC01Table Conversion UnNormalized7TCANBYBuyer NumberNumericGeneric Edit80