JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

Implementation Guides | 920 VMs | 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
6F9671SDSoftware Update Detail Table
7F4102IBItem Branch File
8F0411RPAccounts Payable Ledger
9F0006MCBusiness Unit Master
10F41021LIItem Location File

910: Top 10 requests

TablePrefixDescription
1F0011WICF0011W - WF - Batch To Detail
2F76AUI46WFCERG A/R -Work File - ARG - 03B - 76A
3F4211SDSales Order Detail File
4F4101IMItem Master
5F0101ABAddress Book Master
6F0911GLAccount Ledger
7F4102IBItem Branch File
8F03B11RPCustomer Ledger
9F4311PDPurchase Order Detail File
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4311PDPurchase Order Detail File
4F0411RPAccounts Payable Ledger
5F0006MCBusiness Unit Master
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File

106 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
78F74H1051Invoicing Workfile - New18IWAEXPAmount - Extended PriceNumericGeneric Edit152
TOP74: EMEA Localization
79F74093Workfile for Printing IVA Summary - Italy11HCAEXPAmount - Extended PriceNumericGeneric Edit152
80F7420033Sales Document Line (Print Info) - COMM - 4216PIAEXPAmount - Extended PriceNumericGeneric Edit152
81F7420034Price Adjustment (Print Info) - COMM - 4211PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP75C: China - Reporting System Only
82F75C001Chinese GUI cross reference file11CRAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76A: Argentina
83F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
84F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
85F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 00 - 0014DLAEXPAmount - Extended PriceNumericGeneric Edit152
86F76AUI50VAT Perception Support RG 715 WF - ARG - 04 - 76A6WFAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
87F76111BNota Fiscal - Detail (Fiscal Books) - 4214QUAEXPAmount - Extended PriceNumericGeneric Edit152
88F76111BTConversion table for CFOP 5 digits - F76111B - 4214TAAEXPAmount - Extended PriceNumericGeneric Edit152
89F7611BNota Fiscal Detail - Brazil38FDAEXPAmount - Extended PriceNumericGeneric Edit152
90F761BAAS Fiscal file book41FBAEXPAmount - Extended PriceNumericGeneric Edit152
91F76B102Verification ICMS / IPI - Statement - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
92F76B103Verification ICMS / IPI - Information - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
93F76B30Nota Fiscal Header/Table for Goods - IN68 - 4212MMAEXPAmount - Extended PriceNumericGeneric Edit152
94F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4220IMAEXPAmount - Extended PriceNumericGeneric Edit152
95F76B41Nota Fiscal Detail/Table for Services - IN68 - 4210ISAEXPAmount - Extended PriceNumericGeneric Edit152
96F76B411CIN86-Work Table for Services Outbound Nota Fiscal Det - 4211SDAEXPAmount - Extended PriceNumericGeneric Edit152
97F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4219CDAEXPAmount - Extended PriceNumericGeneric Edit152
98F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4119SDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76C: Colombia
99F76CUI02Tax Detail - Work File - COL - 76C14TDAEXPAmount - Extended PriceNumericGeneric Edit152
100F76CUI04Tax Detail for Distribution - Work File - COL - 76C15TDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76H: Chile
101F76H3B33Legal Document Tax (Print Info) - CHI - 03B - 76H7PIAEXPAmount - Extended PriceNumericGeneric Edit152
102F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H14PIAEXPAmount - Extended PriceNumericGeneric Edit152
103F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H11PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76V: Venezuela
104F76VLC01Purchase Register Temporal - VEN -04 - 76V8LCAEXPAmount - Extended PriceNumericGeneric Edit152
TOP89: Conversion Programs
105F43199ATemp F43199 for ERP 9.0 Upgrade69OLAEXPAmount - Extended PriceNumericGeneric Edit152
TOPH91: Design Tools
106F98TCDTLTable Conversion Detail9CDAEXPAmount - Extended PriceNumericGeneric Edit152