JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.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
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

135 columns | Print definition?920 | 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
TOP42I: Outbound Inventory Management
29F42I015Outbound Inventory Agreement Transaction File27OIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP42X: In-Memory Sales Advisor
30F42X010WLine Advisor Work File9USAEXPAmount - Extended PriceNumericGeneric Edit152
31F42X041WOrder Upsell Item Group Opportunities WF14BRAEXPAmount - Extended PriceNumericGeneric Edit152
32F42X050WOrder Level Upsell Candidate Items16CIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43: Procurement
33F43080Approvals Fields Constants2PDAEXPAmount - Extended PriceNumericGeneric Edit152
34F4311Purchase Order Detail File69PDAEXPAmount - Extended PriceNumericGeneric Edit152
35F4311ZPurchase Order Generator File73PWAEXPAmount - Extended PriceNumericGeneric Edit152
36F4311Z1Purchase Order Detail Unedited Transaction Table82SZAEXPAmount - Extended PriceNumericGeneric Edit152
37F43147Freight Distribution Workfile29FDAEXPAmount - Extended PriceNumericGeneric Edit152
38F4314ZVoucher Match Selection File69PNAEXPAmount - Extended PriceNumericGeneric Edit152
39F4316Purchase Order Multiple Account File32P3AEXPAmount - Extended PriceNumericGeneric Edit152
40F43199P.O. Detail Ledger File - Flexible Version69OLAEXPAmount - Extended PriceNumericGeneric Edit152
41F4343Purchase Rebate History22RHAEXPAmount - Extended PriceNumericGeneric Edit152
42F4371Suggested Reorder Stock Items15PDAEXPAmount - Extended PriceNumericGeneric Edit152
43F43UI50DPO Print Detail Work File16PWAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43E: Requisition Self Service
44F43E09F43E09 - Approvals Activity Table32AAAEXPAmount - Extended PriceNumericGeneric Edit152
45F43E11Requisition Detail27RDAEXPAmount - Extended PriceNumericGeneric Edit152
46F43E16Requisition Multiple Account File29P3AEXPAmount - Extended PriceNumericGeneric Edit152
47F43E20Shopping Cart Detail11SCAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43Q: Strategic Sourcing
48F43Q11Event Detail26EDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP43S: JSSS/Supplier Self Service
49F43001Procurement Self-Service Transaction Log21SAAEXPAmount - Extended PriceNumericGeneric Edit152
TOP44H: Homebuilder Management
50F44H611Bid Details49BDAEXPAmount - Extended PriceNumericGeneric Edit152
51F44H611WBid Details Work File53BWAEXPAmount - Extended PriceNumericGeneric Edit152
52F44H711Lot Start Workfile56SWAEXPAmount - Extended PriceNumericGeneric Edit152
53F44H711PAfter Start Purchasing18TPAEXPAmount - Extended PriceNumericGeneric Edit152
54F44H711ZHB Lot Start Unedited Transaction File69SZAEXPAmount - Extended PriceNumericGeneric Edit152
55F44H71W1Lot Start Generation Workfile56GWAEXPAmount - Extended PriceNumericGeneric Edit152
56F44H73W1Lot Start - P.O. / Committment Generation Work File30CGAEXPAmount - Extended PriceNumericGeneric Edit152
TOP45: Advanced Pricing
57F4576Z1Ship and Debit Claims Unedited Transaction Table143Z1AEXPAmount - Extended PriceNumericGeneric Edit152
TOP46: Warehouse Management
58F4942Z1Work File for F494233SYAEXPAmount - Extended PriceNumericGeneric Edit152
TOP47: Electronic Commerce
59F47012EDI Purchase Order Detail - Inbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
60F47017EDI Purchase Order Detail - Outbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
61F47022EDI P.O. Acknowledgment Detail - Inbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
62F47027EDI P.O. Acknowledgment Detail - Outbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
63F47037EDI Shipping Notice Detail - Outbound90SZAEXPAmount - Extended PriceNumericGeneric Edit152
64F470371EDI Shipping Notice Detail - Outbound101SZAEXPAmount - Extended PriceNumericGeneric Edit152
65F47042EDI Invoice Detail - Inbound60SZAEXPAmount - Extended PriceNumericGeneric Edit152
66F47044EDI Invoice Summary - Inbound26SWAEXPAmount - Extended PriceNumericGeneric Edit152
67F47047EDI Invoice Detail (Sales) - Outbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
68F47072EDI Receiving Advice Detail - Inbound84SZAEXPAmount - Extended PriceNumericGeneric Edit152
69F47077EDI Receiving Advice Detail - Outbound84SZAEXPAmount - Extended PriceNumericGeneric Edit152
70F47092EDI Request for Quote Detail - Inbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
71F47097EDI Request for Quote Detail - Outbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
72F47102EDI Response to RFQ Detail - Inbound83SZAEXPAmount - Extended PriceNumericGeneric Edit152
73F47107EDI Response to RFQ Detail - Outbound93SZAEXPAmount - Extended PriceNumericGeneric Edit152
74F47132EDI Purchase Order Change Detail - Inbound94SZAEXPAmount - Extended PriceNumericGeneric Edit152
75F47137EDI Purchase Order Change Detail - Outbound84SZAEXPAmount - Extended PriceNumericGeneric Edit152
76F47142EDI P.O. Change Acknowledgment Detail - Inbound85SZAEXPAmount - Extended PriceNumericGeneric Edit152
77F47147EDI P.O. Change Acknowledgment Detail - Outbound95SZAEXPAmount - Extended PriceNumericGeneric Edit152
78F47157EDI Shipping Schedule Detail - Outbound90SZAEXPAmount - Extended PriceNumericGeneric Edit152
79F47UI001ASN Extract Work File37SZAEXPAmount - Extended PriceNumericGeneric Edit152
TOP49: Transportation Management
80F4941Shipment Routing Steps36RSAEXPAmount - Extended PriceNumericGeneric Edit152
81F4942Shipment Detail20ISAEXPAmount - Extended PriceNumericGeneric Edit152
82F49633Load In-Transit Confirmed Quantities26IQAEXPAmount - Extended PriceNumericGeneric Edit152
83F49634Load In-Transit Confirmed Quantities Detail17QDAEXPAmount - Extended PriceNumericGeneric Edit152
84F49T10Sales Order Release Staging Table29ORAEXPAmount - Extended PriceNumericGeneric Edit152
TOP74: EMEA Localization
85F740018DData extraction ESL - 7410DEAEXPAmount - Extended PriceNumericGeneric Edit152
86F740018WData extraction ESL - Workfile - 7410DEAEXPAmount - Extended PriceNumericGeneric Edit152
87F74093Worktable for Printing IVA Summary - Italy11HCAEXPAmount - Extended PriceNumericGeneric Edit152
88F7420033Sales Document Line (Print Info) - COMM - 4216PIAEXPAmount - Extended PriceNumericGeneric Edit152
89F7420034Price Adjustment (Print Info) - COMM - 4211PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP74R: Russia
90F74RUI31VAT Sales Book Workfile - RUS - 03B20W1AEXPAmount - Extended PriceNumericGeneric Edit152
91F74RUI41VAT Purchase Book Workfile - RUS - 0421W1AEXPAmount - Extended PriceNumericGeneric Edit152
TOP75C: China
92F75C001Chinese GUI cross reference file11CRAEXPAmount - Extended PriceNumericGeneric Edit152
TOP75I: India
93F75I017Sales Order Tag File IND 4223SOAEXPAmount - Extended PriceNumericGeneric Edit152
94F75I2213Setoff Temp Table13TTAEXPAmount - Extended PriceNumericGeneric Edit152
95F75I309Personal Consumption - CENVAT setoff - IND - 4132CSAEXPAmount - Extended PriceNumericGeneric Edit152
96F75I322Excise - Work File for F04211 & F410119Q3AEXPAmount - Extended PriceNumericGeneric Edit152
97F75I322EExcise - Work File for F04211 & F4101(Based on F75I322)19Q3AEXPAmount - Extended PriceNumericGeneric Edit152
98F75I3574Consignment - Issues/Receipts Transactions19CTAEXPAmount - Extended PriceNumericGeneric Edit152
99F75I385RG23D Register - Issues - IND - 4217EDAEXPAmount - Extended PriceNumericGeneric Edit152
100F75I401Sales Form Information-IND-4232QAAEXPAmount - Extended PriceNumericGeneric Edit152
101F75I401CSales Form Information- Secondary24QAAEXPAmount - Extended PriceNumericGeneric Edit152
102F75I403Stock Transfer Details27ABAEXPAmount - Extended PriceNumericGeneric Edit152
103F75I403TTemp Data for F75i40330ABAEXPAmount - Extended PriceNumericGeneric Edit152
104F75I409Personal Consumption - VAT setoff - IND - 4122VSAEXPAmount - Extended PriceNumericGeneric Edit152
105F75I4223Sales Tax Summary/Detail29SDAEXPAmount - Extended PriceNumericGeneric Edit152
106F75I601TCS Register Details-IND-426TRAEXPAmount - Extended PriceNumericGeneric Edit152
107F75I604TCS Payment Details14TPAEXPAmount - Extended PriceNumericGeneric Edit152
108F75I605TCS Tax Amount5TAAEXPAmount - Extended PriceNumericGeneric Edit152
109F75I611TCS Prepayment Transaction File - IND-03B22TTAEXPAmount - Extended PriceNumericGeneric Edit152
110F75I735Order Detail by Service Category Code - IND - 75I18STAEXPAmount - Extended PriceNumericGeneric Edit152
TOP75T: Taiwan
111F75T42WWork file with union of F4211 and F4211925SWAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76A: Argentina
112F76A0219Detail Lines Invoice/ShipmentNote History WF - ARG - - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
113F76A021PDetail Lines Inv./ShipmentNote History WF Purge - ARG - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
114F76AUI21Detail Lines Invoice/ShipmentNote Workfile - ARG - 03 - 76A14DLAEXPAmount - Extended PriceNumericGeneric Edit152
115F76AUI50VAT Perception Support RG 715 WF - ARG - 04 - 76A6WFAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76B: Brazil
116F76111BNota Fiscal - Detail (Fiscal Books) - 4214QUAEXPAmount - Extended PriceNumericGeneric Edit152
117F76111BTConversion table for CFOP 5 digits - F76111B - 4214TAAEXPAmount - Extended PriceNumericGeneric Edit152
118F7611BNota Fiscal Detail - BRA - 4238FDAEXPAmount - Extended PriceNumericGeneric Edit152
119F761BAAS Fiscal file book - 0941FBAEXPAmount - Extended PriceNumericGeneric Edit152
120F76B102Verification ICMS / IPI - Statement - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
121F76B103Verification ICMS / IPI - Information - 428QDAEXPAmount - Extended PriceNumericGeneric Edit152
122F76B30Nota Fiscal Header/Table for Goods - IN68 - 4212MMAEXPAmount - Extended PriceNumericGeneric Edit152
123F76B31Nota Fiscal Detail/Table for Goods - IN68 - 4220IMAEXPAmount - Extended PriceNumericGeneric Edit152
124F76B41Nota Fiscal Detail/Table for Services - IN68 - 4210ISAEXPAmount - Extended PriceNumericGeneric Edit152
125F76B411CIN86-Work Table for Services Outbound Nota Fiscal Det - 4211SDAEXPAmount - Extended PriceNumericGeneric Edit152
126F76B411DIN86-Work Table for Merchandise Nota Fiscal Issued by - 4219CDAEXPAmount - Extended PriceNumericGeneric Edit152
127F76B411EIN86-Work Table for Merchandise NF Issued by Supplier - 4119SDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76C: Colombia
128F76CUI02Tax Detail - Work File - COL - 76C14TDAEXPAmount - Extended PriceNumericGeneric Edit152
129F76CUI04Tax Detail for Distribution - Work File - COL - 76C15TDAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76H: Chile
130F76H3B33Legal Document Tax (Print Info) - CHI - 03B - 76H7PIAEXPAmount - Extended PriceNumericGeneric Edit152
131F76H3B34Sales Document Line (Print Info) - CHI - 03B - 76H14PIAEXPAmount - Extended PriceNumericGeneric Edit152
132F76H3B35Price Adjustment (Print Info) - CHI - 03B - 76H11PIAEXPAmount - Extended PriceNumericGeneric Edit152
TOP76V: Venezuela
133F76VLC01Purchase Register Temporal - VEN -04 - 76V8LCAEXPAmount - Extended PriceNumericGeneric Edit152
TOP89: Conversion Programs
134F43199ATemp F43199 for ERP 9.0 Upgrade69OLAEXPAmount - Extended PriceNumericGeneric Edit152
TOPH91: Design Tools
135F98TCDTLTable Conversion Detail9CDAEXPAmount - Extended PriceNumericGeneric Edit152