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

133 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
81F74H1051Invoicing Workfile - New18IWAEXPAmount - Extended PriceNumericGeneric Edit152
TOP74: EMEA Localization
82F740018DData extraction ESL - 7410DEAEXPAmount - Extended PriceNumericGeneric Edit152
83F740018WData extraction ESL - Workfile - 7410DEAEXPAmount - Extended PriceNumericGeneric Edit152
84F74093Worktable for Printing IVA Summary - Italy11HCAEXPAmount - Extended PriceNumericGeneric Edit152
85F7420033Sales Document Line (Print Info) - COMM - 4216PIAEXPAmount - Extended PriceNumericGeneric Edit152
86F7420034Price Adjustment (Print Info) - COMM - 4211PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP74R: CIS
87F74RUI31VAT Sales Book Workfile - RUS - 03B20W1AEXPAmount - Extended PriceNumericGeneric Edit152
88F74RUI41VAT Purchase Book Workfile - RUS - 0421W1AEXPAmount - Extended PriceNumericGeneric Edit152
TOP75C: China - Reporting System Only
89F75C001Chinese GUI cross reference file11CRAEXPAmount - Extended PriceNumericGeneric Edit152
TOP75I: India
90F75I017Sales Order Tag File IND 4223SOAEXPAmount - Extended PriceNumericGeneric Edit152
91F75I2213Setoff Temp Table13TTAEXPAmount - Extended PriceNumericGeneric Edit152
92F75I309Personal Consumption - CENVAT setoff - IND - 4132CSAEXPAmount - Extended PriceNumericGeneric Edit152
93F75I322Excise - Work File for F04211 & F410119Q3AEXPAmount - Extended PriceNumericGeneric Edit152
94F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)19Q3AEXPAmount - Extended PriceNumericGeneric Edit152
95F75I3574Consignment - Issues/Receipts Transactions19CTAEXPAmount - Extended PriceNumericGeneric Edit152
96F75I385RG23D Register - Issues - IND - 4217EDAEXPAmount - Extended PriceNumericGeneric Edit152
97F75I401Sales Form Information-IND-4232QAAEXPAmount - Extended PriceNumericGeneric Edit152
98F75I401CSales Form Information- Secondary24QAAEXPAmount - Extended PriceNumericGeneric Edit152
99F75I403Stock Transfer Details27ABAEXPAmount - Extended PriceNumericGeneric Edit152
100F75I403TTemp Data for F75i40330ABAEXPAmount - Extended PriceNumericGeneric Edit152
101F75I409Personal Consumption - VAT setoff - IND - 4122VSAEXPAmount - Extended PriceNumericGeneric Edit152
102F75I4223Sales Tax Summary/Detail29SDAEXPAmount - Extended PriceNumericGeneric Edit152
103F75I601TCS Register Details-IND-426TRAEXPAmount - Extended PriceNumericGeneric Edit152
104F75I604TCS Payment Details14TPAEXPAmount - Extended PriceNumericGeneric Edit152
105F75I605TCS Tax Amount5TAAEXPAmount - Extended PriceNumericGeneric Edit152
106F75I611TCS Prepayment Transaction File - IND-03B22TTAEXPAmount - Extended PriceNumericGeneric Edit152
107F75I735Order Detail by Service Category Code - IND - 75I18STAEXPAmount - Extended PriceNumericGeneric Edit152
TOP75T: Taiwan
108F75T42WWork file with union of F4211 and F4211925SWAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76A: Argentina
109F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
110F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
111F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
112F76AUI50VAT Perception Support RG 715 WF - ARG - 04 - 76A6WFAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76B: Brazil - Reporting System Only
113F76111BNota Fiscal - Detail (Fiscal Books) - 4214QUAEXPAmount - Extended PriceNumericGeneric Edit152
114F76111BTConversion table for CFOP 5 digits - F76111B - 4214TAAEXPAmount - Extended PriceNumericGeneric Edit152
115F7611BNota Fiscal Detail - BRA - 4238FDAEXPAmount - Extended PriceNumericGeneric Edit152
116F761BAAS Fiscal file book - 0941FBAEXPAmount - Extended PriceNumericGeneric Edit152
117F76B102Verification ICMS / IPI - Statement - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
118F76B103Verification ICMS / IPI - Information - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
119F76B30Nota Fiscal Header/Table for Goods - IN68 - 4212MMAEXPAmount - Extended PriceNumericGeneric Edit152
120F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4220IMAEXPAmount - Extended PriceNumericGeneric Edit152
121F76B41Nota Fiscal Detail/Table for Services - IN68 - 4210ISAEXPAmount - Extended PriceNumericGeneric Edit152
122F76B411CIN86-Work Table for Services Outbound Nota Fiscal Det - 4211SDAEXPAmount - Extended PriceNumericGeneric Edit152
123F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4219CDAEXPAmount - Extended PriceNumericGeneric Edit152
124F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4119SDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76C: Colombia
125F76CUI02Tax Detail - Work File - COL - 76C14TDAEXPAmount - Extended PriceNumericGeneric Edit152
126F76CUI04Tax Detail for Distribution - Work File - COL - 76C15TDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76H: Chile
127F76H3B33Legal Document Tax (Print Info) - CHI - 03B - 76H7PIAEXPAmount - Extended PriceNumericGeneric Edit152
128F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H14PIAEXPAmount - Extended PriceNumericGeneric Edit152
129F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H11PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76V: Venezuela
130F76VLC01Purchase Register Temporal - VEN -04 - 76V8LCAEXPAmount - Extended PriceNumericGeneric Edit152
TOP80D: Plant Manager Dashboard
131F80D010Sales Order Fact11SFAEXPAmount - Extended PriceNumericGeneric Edit152
TOP89: Conversion Programs
132F43199ATemp F43199 for ERP 9.0 Upgrade69OLAEXPAmount - Extended PriceNumericGeneric Edit152
TOPH91: Design Tools
133F98TCDTLTable Conversion Detail9CDAEXPAmount - Extended PriceNumericGeneric Edit152