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
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

121 columns | Print definition?812 | AEXP

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File11TDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP04: Accounts Payable
2F09UI006Tax (F0018) Replica11TDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP17: Customer Service Management
3F1721Contract Detail74CDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP32: Configuration Management
4F3215Configurator Component Table22CCAEXPAmount - Extended PriceNumericGeneric Edit152
5F32159Configurator Component History Table22CHAEXPAmount - Extended PriceNumericGeneric Edit152
6F3216Configurator Price/Cost Table12PCAEXPAmount - Extended PriceNumericGeneric Edit152
7F32169Configurator Price/Cost History12KBAEXPAmount - Extended PriceNumericGeneric Edit152
TOP34: Requirements Planning
8F3460Forecast File8MFAEXPAmount - Extended PriceNumericGeneric Edit152
TOP36: Forecasting
9F3400Forecast Summary File18SGAEXPAmount - Extended PriceNumericGeneric Edit152
10F3460Z1Forecast Unedited Transactions21FTAEXPAmount - Extended PriceNumericGeneric Edit152
TOP40: Inventory/OP Base
11F40051Return Material Authorization34RDAEXPAmount - Extended PriceNumericGeneric Edit152
12F4011ZBatch Receiver File - Order Details92SZAEXPAmount - Extended PriceNumericGeneric Edit152
13F4012ZWWF - Destination Quantity31SPAEXPAmount - Extended PriceNumericGeneric Edit152
14F40332Preference Profile - Customer Freight14CFAEXPAmount - Extended PriceNumericGeneric Edit152
15F4211AUSales Order Detail Audit File34AUAEXPAmount - Extended PriceNumericGeneric Edit152
16F4211DTSales Order Detail Date Tracking File19DTAEXPAmount - Extended PriceNumericGeneric Edit152
17F4211Z1Sales Order Detail Unedited Transaction File89SZAEXPAmount - Extended PriceNumericGeneric Edit152
18F4215Shipment Header26XHAEXPAmount - Extended PriceNumericGeneric Edit152
TOP41: Inventory Management
19F41UI001Inventory Transactions Detail File193ITAEXPAmount - Extended PriceNumericGeneric Edit152
TOP42: Sales Management
20F4211Sales Order Detail File76SDAEXPAmount - Extended PriceNumericGeneric Edit152
21F42119Sales Order History File76SDAEXPAmount - Extended PriceNumericGeneric Edit152
22F42199S.O. Detail Ledger File76SLAEXPAmount - Extended PriceNumericGeneric Edit152
23F42565Invoice Print File27IWAEXPAmount - Extended PriceNumericGeneric Edit152
24F42UI11SO Detail Cache File (MBF)64ZDAEXPAmount - Extended PriceNumericGeneric Edit152
25F42UI521Pick Slips Detail File71S9AEXPAmount - Extended PriceNumericGeneric Edit152
26F42UI800Sales Detail Work File - Sales Update19SDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP42B: Sales Order Entry
27F42420Audit Log Transaction20ALAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43: Procurement
28F43080Approvals Fields Constants2PDAEXPAmount - Extended PriceNumericGeneric Edit152
29F4311Purchase Order Detail File69PDAEXPAmount - Extended PriceNumericGeneric Edit152
30F4311ZPurchase Order Generator File73PWAEXPAmount - Extended PriceNumericGeneric Edit152
31F4311Z1Purchase Order Detail Unedited Transaction Table82SZAEXPAmount - Extended PriceNumericGeneric Edit152
32F4314ZVoucher Match Selection File69PNAEXPAmount - Extended PriceNumericGeneric Edit152
33F4316Purchase Order Multiple Account File32P3AEXPAmount - Extended PriceNumericGeneric Edit152
34F43199P.O. Detail Ledger File - Flexible Version69OLAEXPAmount - Extended PriceNumericGeneric Edit152
35F4343Purchase Rebate History22RHAEXPAmount - Extended PriceNumericGeneric Edit152
36F4371Suggested Reorder Stock Items15PDAEXPAmount - Extended PriceNumericGeneric Edit152
37F43E09F43E09 - Approvals Activity Table32AAAEXPAmount - Extended PriceNumericGeneric Edit152
38F43UI50DPO Print Detail Work File16PWAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43E: Requisition Self Service
39F43E11Requisition Detail27RDAEXPAmount - Extended PriceNumericGeneric Edit152
40F43E16Requisition Multiple Account File29P3AEXPAmount - Extended PriceNumericGeneric Edit152
41F43E20Shopping Cart Detail11SCAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43Q: Strategic Sourcing
42F43Q11Event Detail26EDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43S: Supplier Self Service
43F43001Procurement Self-Service Transaction Log21SAAEXPAmount - Extended PriceNumericGeneric Edit152
TOP44H: Homebuilder Management
44F44H611Bid Details49BDAEXPAmount - Extended PriceNumericGeneric Edit152
45F44H611WBid Details Work File53BWAEXPAmount - Extended PriceNumericGeneric Edit152
46F44H711Lot Start Workfile56SWAEXPAmount - Extended PriceNumericGeneric Edit152
47F44H711PAfter Start Purchasing18TPAEXPAmount - Extended PriceNumericGeneric Edit152
48F44H711ZHB Lot Start Unedited Transaction File69SZAEXPAmount - Extended PriceNumericGeneric Edit152
49F44H71W1Lot Start Generation Workfile56GWAEXPAmount - Extended PriceNumericGeneric Edit152
50F44H73W1Lot Start - P.O. / Committment Generation Work File30CGAEXPAmount - Extended PriceNumericGeneric Edit152
TOP45: Advanced Pricing
51F4576Z1Ship and Debit Claims Unedited Transaction Table143Z1AEXPAmount - Extended PriceNumericGeneric Edit152
TOP46: Warehouse Management
52F4942Z1Work File for F494233SYAEXPAmount - Extended PriceNumericGeneric Edit152
TOP47: Electronic Commerce
53F47012EDI Purchase Order Detail - Inbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
54F47017EDI Purchase Order Detail - Outbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
55F47022EDI P.O. Acknowledgment Detail - Inbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
56F47027EDI P.O. Acknowledgment Detail - Outbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
57F47037EDI Shipping Notice Detail - Outbound90SZAEXPAmount - Extended PriceNumericGeneric Edit152
58F470371EDI Shipping Notice Detail - Outbound101SZAEXPAmount - Extended PriceNumericGeneric Edit152
59F47042EDI Invoice Detail - Inbound60SZAEXPAmount - Extended PriceNumericGeneric Edit152
60F47044EDI Invoice Summary - Inbound26SWAEXPAmount - Extended PriceNumericGeneric Edit152
61F47047EDI Invoice Detail (Sales) - Outbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
62F47072EDI Receiving Advice Detail - Inbound84SZAEXPAmount - Extended PriceNumericGeneric Edit152
63F47077EDI Receiving Advice Detail - Outbound84SZAEXPAmount - Extended PriceNumericGeneric Edit152
64F47092EDI Request for Quote Detail - Inbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
65F47097EDI Request for Quote Detail - Outbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
66F47102EDI Response to RFQ Detail - Inbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
67F47107EDI Response to RFQ Detail - Outbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
68F47132EDI Purchase Order Change Detail - Inbound94SZAEXPAmount - Extended PriceNumericGeneric Edit152
69F47137EDI Purchase Order Change Detail - Outbound84SZAEXPAmount - Extended PriceNumericGeneric Edit152
70F47142EDI P.O. Change Acknowledgment Detail - Inbound85SZAEXPAmount - Extended PriceNumericGeneric Edit152
71F47147EDI P.O. Change Acknowledgment Detail - Outbound95SZAEXPAmount - Extended PriceNumericGeneric Edit152
72F47157EDI Shipping Schedule Detail - Outbound90SZAEXPAmount - Extended PriceNumericGeneric Edit152
73F47UI001ASN Extract Work File37SZAEXPAmount - Extended PriceNumericGeneric Edit152
TOP49: Transportation Management
74F4941Shipment Routing Steps36RSAEXPAmount - Extended PriceNumericGeneric Edit152
75F4942Shipment Detail20ISAEXPAmount - Extended PriceNumericGeneric Edit152
76F49633Load In-Transit Confirmed Quantities26IQAEXPAmount - Extended PriceNumericGeneric Edit152
77F49634Load In-Transit Confirmed Quantities Detail17QDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP55: Reserved for Clients
78F55IF421Sales Order per BO82SDAEXPAmount - Extended PriceNumericGeneric Edit152
79F55IF425Sales Order per BO - 200582SDAEXPAmount - Extended PriceNumericGeneric Edit152
80F55IFALBEsportazione provvigioni da F42118PRAEXPAmount - Extended PriceNumericGeneric Edit152
81F55IFLOGhistorical log23HLAEXPAmount - Extended PriceNumericGeneric Edit152
82F55IFP01Kit Pricing File47KPAEXPAmount - Extended PriceNumericGeneric Edit152
83F55IFP05Sales Analyze by Product Group nad Sales Region4WFAEXPAmount - Extended PriceNumericGeneric Edit152
84F55IFP06Sales Analyze by Product Group nad Sales Region DETAIL8WFAEXPAmount - Extended PriceNumericGeneric Edit152
85F55IFPRMPromozioni ordini di vendita9PRAEXPAmount - Extended PriceNumericGeneric Edit152
86F55IFSFVEstrazione del venduto per Sales Force Automation24FSAEXPAmount - Extended PriceNumericGeneric Edit152
87F55PROVVEsportazione provvigioni da F42118PRAEXPAmount - Extended PriceNumericGeneric Edit152
88F55W0100Correction Invoice Print - WF177SDAEXPAmount - Extended PriceNumericGeneric Edit152
89F55W0105Correction Invoice Print - WF211WFAEXPAmount - Extended PriceNumericGeneric Edit152
90F55W0106Workfile for Simple Correction Invoice Print4WFAEXPAmount - Extended PriceNumericGeneric Edit152
91F59SHL02Souhrnné hlá?ení k DPH - sumární11SHAEXPAmount - Extended PriceNumericGeneric Edit152
92F74H1051Invoicing Workfile - New18IWAEXPAmount - Extended PriceNumericGeneric Edit152
93F59H0210Call Priority Setup4CPAEXPAmount - Extended PriceNumericGeneric Edit152
TOP74: EMEA Localization
94F74093Workfile for Printing IVA Summary - Italy11HCAEXPAmount - Extended PriceNumericGeneric Edit152
95F7420033Sales Document Line (Print Info) - COMM - 4216PIAEXPAmount - Extended PriceNumericGeneric Edit152
96F7420034Price Adjustment (Print Info) - COMM - 4211PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP75C: China - Reporting System Only
97F75C001Chinese GUI cross reference file11CRAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76A: Argentina
98F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
99F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
100F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0014DLAEXPAmount - Extended PriceNumericGeneric Edit152
101F76AUI50VAT Perception Support RG 715 WF - ARG - 04 - 76A6WFAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
102F76111BNota Fiscal - Detail (Fiscal Books) - 4214QUAEXPAmount - Extended PriceNumericGeneric Edit152
103F76111BTConversion table for CFOP 5 digits - F76111B - 4214TAAEXPAmount - Extended PriceNumericGeneric Edit152
104F7611BNota Fiscal Detail - Brazil38FDAEXPAmount - Extended PriceNumericGeneric Edit152
105F761BAAS Fiscal file book41FBAEXPAmount - Extended PriceNumericGeneric Edit152
106F76B102Verification ICMS / IPI - Statement - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
107F76B103Verification ICMS / IPI - Information - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
108F76B30Nota Fiscal Header/Table for Goods - IN68 - 4212MMAEXPAmount - Extended PriceNumericGeneric Edit152
109F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4220IMAEXPAmount - Extended PriceNumericGeneric Edit152
110F76B41Nota Fiscal Detail/Table for Services - IN68 - 4210ISAEXPAmount - Extended PriceNumericGeneric Edit152
111F76B411CIN86-Work Table for Services Outbound Nota Fiscal Det - 4211SDAEXPAmount - Extended PriceNumericGeneric Edit152
112F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4219CDAEXPAmount - Extended PriceNumericGeneric Edit152
113F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4119SDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76C: Colombia
114F76CUI02Tax Detail - Work File - COL - 76C14TDAEXPAmount - Extended PriceNumericGeneric Edit152
115F76CUI04Tax Detail for Distribution - Work File - COL - 76C15TDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76H: Chile
116F76H3B33Legal Document Tax (Print Info) - CHI - 03B - 76H7PIAEXPAmount - Extended PriceNumericGeneric Edit152
117F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H14PIAEXPAmount - Extended PriceNumericGeneric Edit152
118F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H11PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76V: Venezuela
119F76VLC01Purchase Register Temporal - VEN -04 - 76V8LCAEXPAmount - Extended PriceNumericGeneric Edit152
TOP89: Conversion Programs
120F43199ATemp F43199 for ERP 9.0 Upgrade69OLAEXPAmount - Extended PriceNumericGeneric Edit152
TOPH91: Design Tools
121F98TCDTLTable Conversion Detail9CDAEXPAmount - Extended PriceNumericGeneric Edit152