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

148 columns | Print definition?910 | AEXP

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Taxes11TDAEXPAmount - 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
TOP40G: Grower Management
19F40G95Pay On Proceeds Log File13PPAEXPAmount - Extended PriceNumericGeneric Edit152
TOP41: Inventory Management
20F41UI001Inventory Transactions Detail File193ITAEXPAmount - Extended PriceNumericGeneric Edit152
TOP42: Sales Management
21F4211Sales Order Detail File76SDAEXPAmount - Extended PriceNumericGeneric Edit152
22F42119Sales Order History File76SDAEXPAmount - Extended PriceNumericGeneric Edit152
23F42199S.O. Detail Ledger File76SLAEXPAmount - Extended PriceNumericGeneric Edit152
24F42565Invoice Print File27IWAEXPAmount - Extended PriceNumericGeneric Edit152
25F42UI11SO Detail Cache File (MBF)64ZDAEXPAmount - Extended PriceNumericGeneric Edit152
26F42UI521Pick Slips Detail File71S9AEXPAmount - Extended PriceNumericGeneric Edit152
27F42UI800Sales Detail Work File - Sales Update19SDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP42B: Sales Order Entry
28F42420Audit Log Transaction20ALAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43: Procurement
29F43080Approvals Fields Constants2PDAEXPAmount - Extended PriceNumericGeneric Edit152
30F4311Purchase Order Detail File69PDAEXPAmount - Extended PriceNumericGeneric Edit152
31F4311ZPurchase Order Generator File73PWAEXPAmount - Extended PriceNumericGeneric Edit152
32F4311Z1Purchase Order Detail Unedited Transaction Table82SZAEXPAmount - Extended PriceNumericGeneric Edit152
33F43147Freight Distribution Workfile29FDAEXPAmount - Extended PriceNumericGeneric Edit152
34F4314ZVoucher Match Selection File69PNAEXPAmount - Extended PriceNumericGeneric Edit152
35F4316Purchase Order Multiple Account File32P3AEXPAmount - Extended PriceNumericGeneric Edit152
36F43199P.O. Detail Ledger File - Flexible Version69OLAEXPAmount - Extended PriceNumericGeneric Edit152
37F4343Purchase Rebate History22RHAEXPAmount - Extended PriceNumericGeneric Edit152
38F4371Suggested Reorder Stock Items15PDAEXPAmount - Extended PriceNumericGeneric Edit152
39F43UI50DPO Print Detail Work File16PWAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43E: Requisition Self Service
40F43E09F43E09 - Approvals Activity Table32AAAEXPAmount - Extended PriceNumericGeneric Edit152
41F43E11Requisition Detail27RDAEXPAmount - Extended PriceNumericGeneric Edit152
42F43E16Requisition Multiple Account File29P3AEXPAmount - Extended PriceNumericGeneric Edit152
43F43E20Shopping Cart Detail11SCAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43Q: Strategic Sourcing
44F43Q11Event Detail26EDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43S: Supplier Self Service
45F43001Procurement Self-Service Transaction Log21SAAEXPAmount - Extended PriceNumericGeneric Edit152
TOP44H: Homebuilder Management
46F44H611Bid Details49BDAEXPAmount - Extended PriceNumericGeneric Edit152
47F44H611WBid Details Work File53BWAEXPAmount - Extended PriceNumericGeneric Edit152
48F44H711Lot Start Workfile56SWAEXPAmount - Extended PriceNumericGeneric Edit152
49F44H711PAfter Start Purchasing18TPAEXPAmount - Extended PriceNumericGeneric Edit152
50F44H711ZHB Lot Start Unedited Transaction File69SZAEXPAmount - Extended PriceNumericGeneric Edit152
51F44H71W1Lot Start Generation Workfile56GWAEXPAmount - Extended PriceNumericGeneric Edit152
52F44H73W1Lot Start - P.O. / Committment Generation Work File30CGAEXPAmount - Extended PriceNumericGeneric Edit152
TOP45: Advanced Pricing
53F4576Z1Ship and Debit Claims Unedited Transaction Table143Z1AEXPAmount - Extended PriceNumericGeneric Edit152
TOP46: Warehouse Management
54F4942Z1Work File for F494233SYAEXPAmount - Extended PriceNumericGeneric Edit152
TOP47: Electronic Commerce
55F47012EDI Purchase Order Detail - Inbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
56F47017EDI Purchase Order Detail - Outbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
57F47022EDI P.O. Acknowledgment Detail - Inbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
58F47027EDI P.O. Acknowledgment Detail - Outbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
59F47037EDI Shipping Notice Detail - Outbound90SZAEXPAmount - Extended PriceNumericGeneric Edit152
60F470371EDI Shipping Notice Detail - Outbound101SZAEXPAmount - Extended PriceNumericGeneric Edit152
61F47042EDI Invoice Detail - Inbound60SZAEXPAmount - Extended PriceNumericGeneric Edit152
62F47044EDI Invoice Summary - Inbound26SWAEXPAmount - Extended PriceNumericGeneric Edit152
63F47047EDI Invoice Detail (Sales) - Outbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
64F47072EDI Receiving Advice Detail - Inbound84SZAEXPAmount - Extended PriceNumericGeneric Edit152
65F47077EDI Receiving Advice Detail - Outbound84SZAEXPAmount - Extended PriceNumericGeneric Edit152
66F47092EDI Request for Quote Detail - Inbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
67F47097EDI Request for Quote Detail - Outbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
68F47102EDI Response to RFQ Detail - Inbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
69F47107EDI Response to RFQ Detail - Outbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
70F47132EDI Purchase Order Change Detail - Inbound94SZAEXPAmount - Extended PriceNumericGeneric Edit152
71F47137EDI Purchase Order Change Detail - Outbound84SZAEXPAmount - Extended PriceNumericGeneric Edit152
72F47142EDI P.O. Change Acknowledgment Detail - Inbound85SZAEXPAmount - Extended PriceNumericGeneric Edit152
73F47147EDI P.O. Change Acknowledgment Detail - Outbound95SZAEXPAmount - Extended PriceNumericGeneric Edit152
74F47157EDI Shipping Schedule Detail - Outbound90SZAEXPAmount - Extended PriceNumericGeneric Edit152
75F47UI001ASN Extract Work File37SZAEXPAmount - Extended PriceNumericGeneric Edit152
TOP49: Transportation Management
76F4941Shipment Routing Steps36RSAEXPAmount - Extended PriceNumericGeneric Edit152
77F4942Shipment Detail20ISAEXPAmount - Extended PriceNumericGeneric Edit152
78F49633Load In-Transit Confirmed Quantities26IQAEXPAmount - Extended PriceNumericGeneric Edit152
79F49634Load In-Transit Confirmed Quantities Detail17QDAEXPAmount - Extended PriceNumericGeneric Edit152
80F49T10Sales Order Release Staging Table29ORAEXPAmount - Extended PriceNumericGeneric Edit152
TOP55: Reserved for Clients
81F55IF421Sales Order per BO82SDAEXPAmount - Extended PriceNumericGeneric Edit152
82F55IF425Sales Order per BO - 200582SDAEXPAmount - Extended PriceNumericGeneric Edit152
83F55IFALBEsportazione provvigioni da F42118PRAEXPAmount - Extended PriceNumericGeneric Edit152
84F55IFLOGhistorical log23HLAEXPAmount - Extended PriceNumericGeneric Edit152
85F55IFP01Kit Pricing File47KPAEXPAmount - Extended PriceNumericGeneric Edit152
86F55IFP05Sales Analyze by Product Group nad Sales Region4WFAEXPAmount - Extended PriceNumericGeneric Edit152
87F55IFP06Sales Analyze by Product Group nad Sales Region DETAIL8WFAEXPAmount - Extended PriceNumericGeneric Edit152
88F55IFPRMPromozioni ordini di vendita9PRAEXPAmount - Extended PriceNumericGeneric Edit152
89F55IFSFVEstrazione del venduto per Sales Force Automation24FSAEXPAmount - Extended PriceNumericGeneric Edit152
90F55PROVVEsportazione provvigioni da F42118PRAEXPAmount - Extended PriceNumericGeneric Edit152
91F55W0100Correction Invoice Print - WF177SDAEXPAmount - Extended PriceNumericGeneric Edit152
92F55W0105Correction Invoice Print - WF211WFAEXPAmount - Extended PriceNumericGeneric Edit152
93F55W0106Workfile for Simple Correction Invoice Print4WFAEXPAmount - Extended PriceNumericGeneric Edit152
94F59SHL02Souhrnné hlá?ení k DPH - sumární11SHAEXPAmount - Extended PriceNumericGeneric Edit152
95F74H1051Invoicing Workfile - New18IWAEXPAmount - Extended PriceNumericGeneric Edit152
96F59H0210Call Priority Setup4CPAEXPAmount - Extended PriceNumericGeneric Edit152
TOP74: EMEA Localization
97F740018DData extraction ESL - 7410DEAEXPAmount - Extended PriceNumericGeneric Edit152
98F740018WData extraction ESL - Workfile - 7410DEAEXPAmount - Extended PriceNumericGeneric Edit152
99F74093Worktable for Printing IVA Summary - Italy11HCAEXPAmount - Extended PriceNumericGeneric Edit152
100F7420033Sales Document Line (Print Info) - COMM - 4216PIAEXPAmount - Extended PriceNumericGeneric Edit152
101F7420034Price Adjustment (Print Info) - COMM - 4211PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP74R: CIS
102F74RUI31VAT Sales Book Workfile - RUS - 03B20W1AEXPAmount - Extended PriceNumericGeneric Edit152
103F74RUI41VAT Purchase Book Workfile - RUS - 0421W1AEXPAmount - Extended PriceNumericGeneric Edit152
TOP75C: China - Reporting System Only
104F75C001Chinese GUI cross reference file11CRAEXPAmount - Extended PriceNumericGeneric Edit152
TOP75I: India
105F75I017Sales Order Tag File IND 4223SOAEXPAmount - Extended PriceNumericGeneric Edit152
106F75I2213Setoff Temp Table13TTAEXPAmount - Extended PriceNumericGeneric Edit152
107F75I309Personal Consumption - CENVAT setoff - IND - 4132CSAEXPAmount - Extended PriceNumericGeneric Edit152
108F75I322Excise - Work File for F04211 & F410119Q3AEXPAmount - Extended PriceNumericGeneric Edit152
109F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)19Q3AEXPAmount - Extended PriceNumericGeneric Edit152
110F75I3574Consignment - Issues/Receipts Transactions19CTAEXPAmount - Extended PriceNumericGeneric Edit152
111F75I385RG23D Register - Issues - IND - 4217EDAEXPAmount - Extended PriceNumericGeneric Edit152
112F75I401Sales Form Information-IND-4232QAAEXPAmount - Extended PriceNumericGeneric Edit152
113F75I401CSales Form Information- Secondary24QAAEXPAmount - Extended PriceNumericGeneric Edit152
114F75I403Stock Transfer Details27ABAEXPAmount - Extended PriceNumericGeneric Edit152
115F75I403TTemp Data for F75i40330ABAEXPAmount - Extended PriceNumericGeneric Edit152
116F75I409Personal Consumption - VAT setoff - IND - 4122VSAEXPAmount - Extended PriceNumericGeneric Edit152
117F75I4223Sales Tax Summary/Detail29SDAEXPAmount - Extended PriceNumericGeneric Edit152
118F75I601TCS Register Details-IND-426TRAEXPAmount - Extended PriceNumericGeneric Edit152
119F75I604TCS Payment Details14TPAEXPAmount - Extended PriceNumericGeneric Edit152
120F75I605TCS Tax Amount5TAAEXPAmount - Extended PriceNumericGeneric Edit152
121F75I611TCS Prepayment Transaction File - IND-03B22TTAEXPAmount - Extended PriceNumericGeneric Edit152
122F75I735Order Detail by Service Category Code - IND - 75I18STAEXPAmount - Extended PriceNumericGeneric Edit152
TOP75T: Taiwan
123F75T42WWork file with union of F4211 and F4211925SWAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76A: Argentina
124F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
125F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
126F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
127F76AUI50VAT Perception Support RG 715 WF - ARG - 04 - 76A6WFAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
128F76111BNota Fiscal - Detail (Fiscal Books) - 4214QUAEXPAmount - Extended PriceNumericGeneric Edit152
129F76111BTConversion table for CFOP 5 digits - F76111B - 4214TAAEXPAmount - Extended PriceNumericGeneric Edit152
130F7611BNota Fiscal Detail - BRA - 4238FDAEXPAmount - Extended PriceNumericGeneric Edit152
131F761BAAS Fiscal file book - 0941FBAEXPAmount - Extended PriceNumericGeneric Edit152
132F76B102Verification ICMS / IPI - Statement - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
133F76B103Verification ICMS / IPI - Information - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
134F76B30Nota Fiscal Header/Table for Goods - IN68 - 4212MMAEXPAmount - Extended PriceNumericGeneric Edit152
135F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4220IMAEXPAmount - Extended PriceNumericGeneric Edit152
136F76B41Nota Fiscal Detail/Table for Services - IN68 - 4210ISAEXPAmount - Extended PriceNumericGeneric Edit152
137F76B411CIN86-Work Table for Services Outbound Nota Fiscal Det - 4211SDAEXPAmount - Extended PriceNumericGeneric Edit152
138F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4219CDAEXPAmount - Extended PriceNumericGeneric Edit152
139F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4119SDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76C: Colombia
140F76CUI02Tax Detail - Work File - COL - 76C14TDAEXPAmount - Extended PriceNumericGeneric Edit152
141F76CUI04Tax Detail for Distribution - Work File - COL - 76C15TDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76H: Chile
142F76H3B33Legal Document Tax (Print Info) - CHI - 03B - 76H7PIAEXPAmount - Extended PriceNumericGeneric Edit152
143F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H14PIAEXPAmount - Extended PriceNumericGeneric Edit152
144F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H11PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76V: Venezuela
145F76VLC01Purchase Register Temporal - VEN -04 - 76V8LCAEXPAmount - Extended PriceNumericGeneric Edit152
TOP80D: Plant Manager Dashboard
146F80D010Sales Order Fact11SFAEXPAmount - Extended PriceNumericGeneric Edit152
TOP89: Conversion Programs
147F43199ATemp F43199 for ERP 9.0 Upgrade69OLAEXPAmount - Extended PriceNumericGeneric Edit152
TOPH91: Design Tools
148F98TCDTLTable Conversion Detail9CDAEXPAmount - Extended PriceNumericGeneric Edit152