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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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

187 columns | Print definition?812 | AITM

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0018Sales/Use/V.A.T. Tax File25TDAITM3rd Item NumberStringGeneric Edit250
2F4008Tax Areas22TAAITM3rd Item NumberStringGeneric Edit250
TOP04: Accounts Payable
3F09UI006Tax (F0018) Replica25TDAITM3rd Item NumberStringGeneric Edit250
TOP13: Plant/Equipment Management
4F13017Equipment Parts List8PLAITM3rd Item NumberStringGeneric Edit250
TOP17: Customer Service Management
5F1721Contract Detail41CDAITM3rd Item NumberStringGeneric Edit250
6F4801Z2Warranty Claim/Supplier Recovery processing78WSAITM3rd Item NumberStringGeneric Edit250
TOP30: Product Data Management
7F3002Z1Bill of Material Transaction File21SZAITM3rd Item NumberStringGeneric Edit250
8F3016Kanban Master5KMAITM3rd Item NumberStringGeneric Edit250
9F30UI008Bill of Material Comparison Work File13IJAITM3rd Item NumberStringGeneric Edit250
TOP30A: Product Costing
10F300261Item Cost Component Detail3IEAITM3rd Item NumberStringGeneric Edit250
TOP31: Shop Floor Control
11F3102Production Cost6IGAITM3rd Item NumberStringGeneric Edit250
12F3102SPurge - Production Cost6IGAITM3rd Item NumberStringGeneric Edit250
13F3109Line/Item Relationship Master3IPAITM3rd Item NumberStringGeneric Edit250
14F31091Schedule Quantity Detail3IQAITM3rd Item NumberStringGeneric Edit250
15F31091SSchedule Quantity Detail Purge3IQAITM3rd Item NumberStringGeneric Edit250
16F3118Shortage Maintenance Master File16WNAITM3rd Item NumberStringGeneric Edit250
17F4801SPurge - Work Order Master file59WAAITM3rd Item NumberStringGeneric Edit250
18F4801Z1Outbound Work Order Header78SYAITM3rd Item NumberStringGeneric Edit250
TOP31P: Engineer To Order
19F31P11Project Quote Detail23QPAITM3rd Item NumberStringGeneric Edit250
TOP32: Configuration Management
20F3291Configured Item Segments3KWAITM3rd Item NumberStringGeneric Edit250
21F3292Cross Segment Editing Rules3KUAITM3rd Item NumberStringGeneric Edit250
22F3293Assembly Inclusions Rules4KYAITM3rd Item NumberStringGeneric Edit250
TOP33: Capacity Planning
23F3303Capacity Resource Profile4CTAITM3rd Item NumberStringGeneric Edit250
TOP34: Requirements Planning
24F3406Customer Address Relationship4CRAITM3rd Item NumberStringGeneric Edit250
25F3460Forecast File3MFAITM3rd Item NumberStringGeneric Edit250
26F43211Supplier Schedule Master File4SSAITM3rd Item NumberStringGeneric Edit250
27F43213SRS Ship Dates10VPAITM3rd Item NumberStringGeneric Edit250
TOP36: Forecasting
28F3460Z1Forecast Unedited Transactions16FTAITM3rd Item NumberStringGeneric Edit250
TOP37: Quality Management
29F3703Non-Conforming Material7QEAITM3rd Item NumberStringGeneric Edit250
TOP40: Inventory/OP Base
30F3002Bill of Material Master File8IXAITM3rd Item NumberStringGeneric Edit250
31F30026Item Cost Component Add-Ons3IEAITM3rd Item NumberStringGeneric Edit250
32F3011Bill of Materials Change File8IZAITM3rd Item NumberStringGeneric Edit250
33F3462Forecast Shipment Summary3MBAITM3rd Item NumberStringGeneric Edit250
34F4011ZBatch Receiver File - Order Details51SZAITM3rd Item NumberStringGeneric Edit250
35F4012ZWWF - Destination Quantity20SPAITM3rd Item NumberStringGeneric Edit250
36F4015Order Templates6OTAITM3rd Item NumberStringGeneric Edit250
37F40UI002Supplier History Rebuild -workfile6UTAITM3rd Item NumberStringGeneric Edit250
38F40UI74Price Adjustment History Work File39AWAITM3rd Item NumberStringGeneric Edit250
39F4104Item Cross Reference File12IVAITM3rd Item NumberStringGeneric Edit250
40F4106Item Base Price File3BPAITM3rd Item NumberStringGeneric Edit250
41F4108Lot Master7IOAITM3rd Item NumberStringGeneric Edit250
42F41112Item ASOF File6INAITM3rd Item NumberStringGeneric Edit250
43F4209Held Orders12HOAITM3rd Item NumberStringGeneric Edit250
44F4211AUSales Order Detail Audit File18AUAITM3rd Item NumberStringGeneric Edit250
45F4211DTSales Order Detail Date Tracking File14DTAITM3rd Item NumberStringGeneric Edit250
46F4211Z1Sales Order Detail Unedited Transaction File48SZAITM3rd Item NumberStringGeneric Edit250
47F4220Basic Serial Numbers3SWAITM3rd Item NumberStringGeneric Edit250
TOP40G: Grower Management
48F40G02Grower Block61GBAITM3rd Item NumberStringGeneric Edit250
TOP40R: Demand Scheduling
49F40R10Demand Header7DHAITM3rd Item NumberStringGeneric Edit250
50F47172EDI Demand Detail16EDAITM3rd Item NumberStringGeneric Edit250
TOP41: Inventory Management
51F4101Item Master3IMAITM3rd Item NumberStringGeneric Edit250
52F4101AItem File11IMAITM3rd Item NumberStringGeneric Edit250
53F4101DItem Master - Alternative Description3IMAITM3rd Item NumberStringGeneric Edit250
54F4101Z1F4101 Item Master Unedited Transaction Table18SZAITM3rd Item NumberStringGeneric Edit250
55F4102Item Branch File3IBAITM3rd Item NumberStringGeneric Edit250
56F41021Z1Item Location Unedited Transaction File45SZAITM3rd Item NumberStringGeneric Edit250
57F4105Item Cost File3COAITM3rd Item NumberStringGeneric Edit250
58F4105Z1Unedited Transaction Table - Item Cost16SZAITM3rd Item NumberStringGeneric Edit250
59F4111Item Ledger File4ILAITM3rd Item NumberStringGeneric Edit250
60F41113Lot Ledger10I8AITM3rd Item NumberStringGeneric Edit250
61F4141Cycle Count Transaction File5PJAITM3rd Item NumberStringGeneric Edit250
62F4141Z1F4141 Cycle Count Unedited Transaction Table18SZAITM3rd Item NumberStringGeneric Edit250
63F4160Tag Inventory File27ITAITM3rd Item NumberStringGeneric Edit250
64F41UI001Inventory Transactions Detail File15ITAITM3rd Item NumberStringGeneric Edit250
TOP42: Sales Management
65F4211Sales Order Detail File35SDAITM3rd Item NumberStringGeneric Edit250
66F42119Sales Order History File35SDAITM3rd Item NumberStringGeneric Edit250
67F42199S.O. Detail Ledger File35SLAITM3rd Item NumberStringGeneric Edit250
68F4229Sales Summary History File6SSAITM3rd Item NumberStringGeneric Edit250
69F42UI11SO Detail Cache File (MBF)38ZDAITM3rd Item NumberStringGeneric Edit250
70F42UI11CCustomer Self Service Shopping Cart Workfile9SCAITM3rd Item NumberStringGeneric Edit250
71F42UI521Pick Slips Detail File30S9AITM3rd Item NumberStringGeneric Edit250
72F42UI800Sales Detail Work File - Sales Update14SDAITM3rd Item NumberStringGeneric Edit250
TOP42B: Sales Order Entry
73F42440Customer Segment Items2CSAITM3rd Item NumberStringGeneric Edit250
74F42UI440Customer Segment Items - Work File3CSAITM3rd Item NumberStringGeneric Edit250
TOP43: Procurement
75F41061Supplier Price/Catalog File5CBAITM3rd Item NumberStringGeneric Edit250
76F41291Item Cost Components4IGAITM3rd Item NumberStringGeneric Edit250
77F43080Approvals Fields Constants45PDAITM3rd Item NumberStringGeneric Edit250
78F43090Supplier/Item Relationships4PCAITM3rd Item NumberStringGeneric Edit250
79F43093Inspection/Sample Size Table4PEAITM3rd Item NumberStringGeneric Edit250
80F4311Purchase Order Detail File37PDAITM3rd Item NumberStringGeneric Edit250
81F4311ZPurchase Order Generator File41PWAITM3rd Item NumberStringGeneric Edit250
82F4311Z1Purchase Order Detail Unedited Transaction Table50SZAITM3rd Item NumberStringGeneric Edit250
83F43121Purchase Order Receiver File16PRAITM3rd Item NumberStringGeneric Edit250
84F43121ZReceiver workfile81PWAITM3rd Item NumberStringGeneric Edit250
85F43121Z1Receipts Unedited Transaction Table33SZAITM3rd Item NumberStringGeneric Edit250
86F4314ZVoucher Match Selection File115PNAITM3rd Item NumberStringGeneric Edit250
87F43199P.O. Detail Ledger File - Flexible Version37OLAITM3rd Item NumberStringGeneric Edit250
88F43632ZOpen Purchase Order by Item Work File14OIAITM3rd Item NumberStringGeneric Edit250
89F4371Suggested Reorder Stock Items11PDAITM3rd Item NumberStringGeneric Edit250
90F43E09F43E09 - Approvals Activity Table22AAAITM3rd Item NumberStringGeneric Edit250
91F43UI50DPO Print Detail Work File27PWAITM3rd Item NumberStringGeneric Edit250
TOP43C: Contracts
92F43C10Contract Block80CBAITM3rd Item NumberStringGeneric Edit250
93F43C11Contract Detail7CDAITM3rd Item NumberStringGeneric Edit250
TOP43E: Requisition Self Service
94F43E11Requisition Detail14RDAITM3rd Item NumberStringGeneric Edit250
TOP43Q: Strategic Sourcing
95F43Q11Event Detail8EDAITM3rd Item NumberStringGeneric Edit250
96F43Q41Response Line13RBAITM3rd Item NumberStringGeneric Edit250
97F43Q51Analyze Event Detail9EDAITM3rd Item NumberStringGeneric Edit250
TOP43S: Supplier Self Service
98F43001Procurement Self-Service Transaction Log12SAAITM3rd Item NumberStringGeneric Edit250
TOP44H: Homebuilder Management
99F44H602Takeoff Master File12TOAITM3rd Item NumberStringGeneric Edit250
100F44H602HTakeoff History File14THAITM3rd Item NumberStringGeneric Edit250
101F44H602WTake Off Summary Workfile15TSAITM3rd Item NumberStringGeneric Edit250
102F44H603Material Item Pricing9MPAITM3rd Item NumberStringGeneric Edit250
103F44H711Lot Start Workfile9SWAITM3rd Item NumberStringGeneric Edit250
104F44H711PAfter Start Purchasing21TPAITM3rd Item NumberStringGeneric Edit250
105F44H711ZHB Lot Start Unedited Transaction File22SZAITM3rd Item NumberStringGeneric Edit250
106F44H71W1Lot Start Generation Workfile10GWAITM3rd Item NumberStringGeneric Edit250
TOP45: Advanced Pricing
107F4072Price Adjustment Detail4ADAITM3rd Item NumberStringGeneric Edit250
108F4072WPrice Adjustment Detail Work File4ADAITM3rd Item NumberStringGeneric Edit250
109F4073Free Goods Master File5FGAITM3rd Item NumberStringGeneric Edit250
110F4077Rebate Thresholds7RTAITM3rd Item NumberStringGeneric Edit250
111F4511WPricing Structure View41APAITM3rd Item NumberStringGeneric Edit250
112F45521Price List Detail9PDAITM3rd Item NumberStringGeneric Edit250
113F45524Price List Item Selection5PIAITM3rd Item NumberStringGeneric Edit250
114F4572Z1Live Promotions Interface - Inbound / Outbound26LPAITM3rd Item NumberStringGeneric Edit250
115F4572ZPPurge Live Promotions Interface26PGAITM3rd Item NumberStringGeneric Edit250
116F4574Key Reference Table7KRAITM3rd Item NumberStringGeneric Edit250
117F4576Z1Ship and Debit Claims Unedited Transaction Table137Z1AITM3rd Item NumberStringGeneric Edit250
TOP46: Warehouse Management
118F4600Warehouse Requests16R1AITM3rd Item NumberStringGeneric Edit250
119F4600PUWarehouse Requests - Purged16R1AITM3rd Item NumberStringGeneric Edit250
120F4611Warehouse Suggestions20R2AITM3rd Item NumberStringGeneric Edit250
121F4611PUWarehouse Suggestions - Purged20R2AITM3rd Item NumberStringGeneric Edit250
122F4611Z1Unedited Suggestion Table33SZAITM3rd Item NumberStringGeneric Edit250
123F46130Putaway Reservations11R3AITM3rd Item NumberStringGeneric Edit250
124F46130PUPutaway Reservations - Purged11R3AITM3rd Item NumberStringGeneric Edit250
TOP46L: License Plating
125F46LUI01Assign/Remove Items To LP Work File6WFAITM3rd Item NumberStringGeneric Edit250
TOP47: Electronic Commerce
126F47012EDI Purchase Order Detail - Inbound51SZAITM3rd Item NumberStringGeneric Edit250
127F47017EDI Purchase Order Detail - Outbound50SZAITM3rd Item NumberStringGeneric Edit250
128F47022EDI P.O. Acknowledgment Detail - Inbound50SZAITM3rd Item NumberStringGeneric Edit250
129F47027EDI P.O. Acknowledgment Detail - Outbound51SZAITM3rd Item NumberStringGeneric Edit250
130F47032EDI Shipping Notice Detail - Inbound49SZAITM3rd Item NumberStringGeneric Edit250
131F47037EDI Shipping Notice Detail - Outbound51SZAITM3rd Item NumberStringGeneric Edit250
132F470371EDI Shipping Notice Detail - Outbound57SZAITM3rd Item NumberStringGeneric Edit250
133F47042EDI Invoice Detail - Inbound30SZAITM3rd Item NumberStringGeneric Edit250
134F47047EDI Invoice Detail (Sales) - Outbound51SZAITM3rd Item NumberStringGeneric Edit250
135F47062EDI Planning Schedule Detail - Inbound17MYAITM3rd Item NumberStringGeneric Edit250
136F47067EDI Planning Schedule Detail - Outbound17MYAITM3rd Item NumberStringGeneric Edit250
137F47072EDI Receiving Advice Detail - Inbound51SZAITM3rd Item NumberStringGeneric Edit250
138F47077EDI Receiving Advice Detail - Outbound51SZAITM3rd Item NumberStringGeneric Edit250
139F47082EDI Price Sales Catalog Detail - Inbound17FYAITM3rd Item NumberStringGeneric Edit250
140F47092EDI Request for Quote Detail - Inbound51SZAITM3rd Item NumberStringGeneric Edit250
141F47097EDI Request for Quote Detail - Outbound50SZAITM3rd Item NumberStringGeneric Edit250
142F47102EDI Response to RFQ Detail - Inbound50SZAITM3rd Item NumberStringGeneric Edit250
143F47107EDI Response to RFQ Detail - Outbound51SZAITM3rd Item NumberStringGeneric Edit250
144F47122EDI Product Activity Data Detail - Inbound24MJAITM3rd Item NumberStringGeneric Edit250
145F47127EDI Product Activity Data Detail - Outbound24MJAITM3rd Item NumberStringGeneric Edit250
146F47132EDI Purchase Order Change Detail - Inbound52SZAITM3rd Item NumberStringGeneric Edit250
147F47137EDI Purchase Order Change Detail - Outbound51SZAITM3rd Item NumberStringGeneric Edit250
148F47142EDI P.O. Change Acknowledgment Detail - Inbound52SZAITM3rd Item NumberStringGeneric Edit250
149F47147EDI P.O. Change Acknowledgment Detail - Outbound53SZAITM3rd Item NumberStringGeneric Edit250
150F47157EDI Shipping Schedule Detail - Outbound53SZAITM3rd Item NumberStringGeneric Edit250
TOP48: Work Order Processing
151F4801Work Order Master File59WAAITM3rd Item NumberStringGeneric Edit250
152F48UI001X4801 Master Business Function Workfile62WAAITM3rd Item NumberStringGeneric Edit250
TOP55: Reserved for Clients
153F554102WWork file F4102_wkf4IBAITM3rd Item NumberStringGeneric Edit250
154F55IF421Sales Order per BO41SDAITM3rd Item NumberStringGeneric Edit250
155F55IF425Sales Order per BO - 200541SDAITM3rd Item NumberStringGeneric Edit250
156F55IFLOGhistorical log10HLAITM3rd Item NumberStringGeneric Edit250
157F55W0100Correction Invoice Print - WF136SDAITM3rd Item NumberStringGeneric Edit250
158F74H1051Invoicing Workfile - New9IWAITM3rd Item NumberStringGeneric Edit250
159F59I0010P06 PO Receipts Buffer7BFAITM3rd Item NumberStringGeneric Edit250
160F59I0021P07 Shipment Details9PDAITM3rd Item NumberStringGeneric Edit250
161F59I0060Cycle Count Import Table5CCAITM3rd Item NumberStringGeneric Edit250
TOP74: EMEA Localization
162F74093Workfile for Printing IVA Summary - Italy24HCAITM3rd Item NumberStringGeneric Edit250
TOP75C: China - Reporting System Only
163F75C4106Chinese Free Goods VAT base price - F75C41067IBAITM3rd Item NumberStringGeneric Edit250
TOP75T: Taiwan
164F75T005GUI/VAT Transaction Detail - 75T6TDAITM3rd Item NumberStringGeneric Edit250
165F75T0059GUI/VAT Transaction Detail History - 75T6TDAITM3rd Item NumberStringGeneric Edit250
166F75T005PGUI/VAT Transaction Detail POS - 75T6TDAITM3rd Item NumberStringGeneric Edit250
167F75T005ZGUI/VAT Transaction Detail - Work - 75T12ZDAITM3rd Item NumberStringGeneric Edit250
TOP76B: Brazil - Reporting System Only
168F76111BNota Fiscal - Detail (Fiscal Books) - 427QUAITM3rd Item NumberStringGeneric Edit250
169F76111BTConversion table for CFOP 5 digits - F76111B - 427TAAITM3rd Item NumberStringGeneric Edit250
170F7611BNota Fiscal Detail - Brazil25FDAITM3rd Item NumberStringGeneric Edit250
171F761BAAS Fiscal file book30FBAITM3rd Item NumberStringGeneric Edit250
172F76B61Packing and Raw Material Table - IN68 - 303IEAITM3rd Item NumberStringGeneric Edit250
TOP76H: Chile
173F76H611Actual Item Ledger File - CHI - 41 - 76H4ALAITM3rd Item NumberStringGeneric Edit250
174F76H6112Actual Item ASOF File - CHI - 41 - 76H6ANAITM3rd Item NumberStringGeneric Edit250
TOP89: Conversion Programs
175F4072TEMPrice Adjustment Detail - Temp for Upgrade4ADAITM3rd Item NumberStringGeneric Edit250
176F43199ATemp F43199 for ERP 9.0 Upgrade37OLAITM3rd Item NumberStringGeneric Edit250
TOPF31: Lean Transactions
177FF31010Production Master File5EHAITM3rd Item NumberStringGeneric Edit250
178FF31011TransactionID Master File7EHAITM3rd Item NumberStringGeneric Edit250
179FF31011SPurge - TransactionID Master File7ERAITM3rd Item NumberStringGeneric Edit250
180FF31111Lean Transaction Parts List31PLAITM3rd Item NumberStringGeneric Edit250
181FF31111SPurge - Lean Transaction Parts List31PRAITM3rd Item NumberStringGeneric Edit250
182FF31112Routing Transaction Table16EHAITM3rd Item NumberStringGeneric Edit250
183FF31112SPurge - Routing Transaction Table16ETAITM3rd Item NumberStringGeneric Edit250
184FF31113Lean Transaction Labor Detail10LDAITM3rd Item NumberStringGeneric Edit250
185FF31113SPurge - Lean Transaction Labor Detail10LRAITM3rd Item NumberStringGeneric Edit250
186FF31200Production Costs5PCAITM3rd Item NumberStringGeneric Edit250
TOPH95: Tech Resources/Applications
187F00166Media Object Categories24GTAITM3rd Item NumberStringGeneric Edit250