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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales Order Detail File
6F0006MCBusiness Unit Master
7F42119SDSales Order History File
8F0902GBAccount Balances
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

166 columns | Print definition?920 | PNID

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006DZ1Business Unit Alternate Description Z file13SZPNIDTrading Partner IDStringGeneric Edit150
2F0006Z1Cost Center Unedited Transaction Table12SZPNIDTrading Partner IDStringGeneric Edit150
3F0006Z2Business Unit Master Z File10SZPNIDTrading Partner IDStringGeneric Edit150
4F0010ZCompany Constants Z File12SZPNIDTrading Partner IDStringGeneric Edit150
5F0401Z1Supplier Master - Batch Upload12VOPNIDTrading Partner IDStringGeneric Edit150
TOP01: Address Book
6F0101Z2Address Book - Interoperability12SZPNIDTrading Partner IDStringGeneric Edit150
7F01112Z1Batch - Related Person12PBPNIDTrading Partner IDStringGeneric Edit150
8F0111Z1Batch Who's Who Information12BWPNIDTrading Partner IDStringGeneric Edit150
9F01151Z1Batch - Electronic Address12EBPNIDTrading Partner IDStringGeneric Edit150
10F0115Z1Phones - Interoperability13PIPNIDTrading Partner IDStringGeneric Edit150
11F01161Z1Batch - Alternative Address12LBPNIDTrading Partner IDStringGeneric Edit150
TOP03: Accounts Receivable
12F03012Z1Customer Master LOB-Batch Table12VOPNIDTrading Partner IDStringGeneric Edit150
TOP03B: Enhanced Accounts Receivable
13F03B11Z2F03B11 Interoperability Table12SYPNIDTrading Partner IDStringGeneric Edit150
14F03B13Z2F03B13 Interoperability Table12SYPNIDTrading Partner IDStringGeneric Edit150
15F03B14Z2F03B14 Interoperability Table12SZPNIDTrading Partner IDStringGeneric Edit150
16F03B41Z1Inteoperability - Deductions Management12SZPNIDTrading Partner IDStringGeneric Edit150
TOP04: Accounts Payable
17F0411Z3F0411 Interoperability Table12SZPNIDTrading Partner IDStringGeneric Edit150
18F0413Z1F0413 Interoperability Table12SYPNIDTrading Partner IDStringGeneric Edit150
19F0414Z1F0414 Interoperability Table12SZPNIDTrading Partner IDStringGeneric Edit150
TOP05A: PeopleSoft HR & PR Foundation
20F060116ZUnedited Quick Hire Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
TOP09: General Accounting
21F0911Z4F0911 Interoperability Table12SZPNIDTrading Partner IDStringGeneric Edit150
TOP10: Financial Reporting
22F1001Z1Unedited MSC Interoperability Header Table12IAPNIDTrading Partner IDStringGeneric Edit150
23F1002Z1Unedited MSC Interoperability Table12SZPNIDTrading Partner IDStringGeneric Edit150
TOP11: Multi Currency
24F0015Z1External Currency Exchange Rates12ZEPNIDTrading Partner IDStringGeneric Edit150
TOP12: Fixed Assets
25F1201Z1Unedited Asset Master Transactions12FAPNIDTrading Partner IDStringGeneric Edit150
26F1217Z1Unedited Equipment Tag Transactions12WRPNIDTrading Partner IDStringGeneric Edit150
27F1217Z2Unedited Equipment Tag Transactions12WRPNIDTrading Partner IDStringGeneric Edit150
TOP13: Plant/Equipment Management
28F12120Z1Unedited Meter Reading Transactions12SZPNIDTrading Partner IDStringGeneric Edit150
TOP13C: Condition-Base Maintenance
29F1310Z1Unedited Condition-Based Alerts12CBPNIDTrading Partner IDStringGeneric Edit150
TOP16: Profit Management (EPS)
30F1602Z1External Cost Analyzer Balances - Interoperability Table12CZPNIDTrading Partner IDStringGeneric Edit150
31F1632Z1External Driver Balances-Interoperability Table12CYPNIDTrading Partner IDStringGeneric Edit150
TOP17: Customer Service Management
32F3111Z2Warranty Claim/Supplier Recovery processing12WPPNIDTrading Partner IDStringGeneric Edit150
33F3112Z2Warranty Claim/Supplier Recovery processing12WLPNIDTrading Partner IDStringGeneric Edit150
34F4801TZ2Warranty Claim/Supplier Recovery processing12WQPNIDTrading Partner IDStringGeneric Edit150
35F4801Z2Warranty Claim/Supplier Recovery processing12WSPNIDTrading Partner IDStringGeneric Edit150
TOP30: Product Data Management
36F0007Z1Work Day Calendar Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
37F30006Z1Work Center Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
38F3002Z1Bill of Material Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
39F3003Z1Routing Transactions File12SZPNIDTrading Partner IDStringGeneric Edit150
TOP31: Shop Floor Control
40F30161Z1Inbound Kanban Card Detail12SZPNIDTrading Partner IDStringGeneric Edit150
41F3111Z1Outbound Work Order Parts List12SZPNIDTrading Partner IDStringGeneric Edit150
42F31122Z1Work Order Time Transactions Unedited Transaction Table12SZPNIDTrading Partner IDStringGeneric Edit150
43F3112Z1Outbound Work Order Routings12SZPNIDTrading Partner IDStringGeneric Edit150
TOP31B: Blend Management
44F31B17Z1Operation EUR Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
45F31B18Z1VBT Barrel Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
46F31B19Z1Instructed Attributes Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
47F31B31Z1Operations Composition Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
48F31B34Z1Operations Style Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
49F31B3CZ1Operations Cost Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
50F31B52Z1Operations Equipment Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
51F31B53Z1Operations Consumables Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
52F31B65Z1Operations Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
53F31B93Z1WIM Work Order Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
54F31B97Z1Operations Resource Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
55F31BQAZ1Operations Quality Test Transaction File15SZPNIDTrading Partner IDStringGeneric Edit150
TOP36: Forecasting
56F3460Z1Forecast Unedited Transactions12FTPNIDTrading Partner IDStringGeneric Edit150
TOP37: Quality Management
57F3711Z1Test Results Unedited Transaction Table12SZPNIDTrading Partner IDStringGeneric Edit150
TOP40: Inventory/OP Base
58F4001ZBatch Receiver File - Order Headings13SYPNIDTrading Partner IDStringGeneric Edit150
59F4011ZBatch Receiver File - Order Details13SZPNIDTrading Partner IDStringGeneric Edit150
60F4106NCBase Price Extraction12SZPNIDTrading Partner IDStringGeneric Edit150
61F4201Z1Sales Order Header Unedited Transaction File12SYPNIDTrading Partner IDStringGeneric Edit150
62F4211Z1Sales Order Detail Unedited Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
63F4215Shipment Header3XHPNIDTrading Partner IDStringGeneric Edit150
64F49211Z1Sales Order Detail Tag Unedited Transaction File12S1PNIDTrading Partner IDStringGeneric Edit150
TOP41: Inventory Management
65F4101Z1F4101 Item Master Unedited Transaction Table12SZPNIDTrading Partner IDStringGeneric Edit150
66F4101Z1AF4101 Detail Item Master Unedited Transaction12SZPNIDTrading Partner IDStringGeneric Edit150
67F41021Z1Item Location Unedited Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
68F4105Z1Unedited Transaction Table - Item Cost12SZPNIDTrading Partner IDStringGeneric Edit150
69F4141Z1F4141 Cycle Count Unedited Transaction Table12SZPNIDTrading Partner IDStringGeneric Edit150
TOP42: Sales Management
70F47027TTag for F47027 - EDI P.O. Acknowledgment Detail - Outbound29UZPNIDTrading Partner IDStringGeneric Edit150
71F47047TTag for F47047- EDI Invoice Detail (Sales) - Outbound29UZPNIDTrading Partner IDStringGeneric Edit150
72F47107TTag for F47107- EDI Response to RFQ Detail - Outbound29UZPNIDTrading Partner IDStringGeneric Edit150
73F47147TTag F47147 - EDI P.O. Change Acknowledgment Detail-Outbound29UZPNIDTrading Partner IDStringGeneric Edit150
TOP42B: Sales Order Entry
74F4011ZTBatch Receiver File - Order Details Tag14UZPNIDTrading Partner IDStringGeneric Edit150
75F47012TEDI Purchase Order Detail Tag - Inbound14UZPNIDTrading Partner IDStringGeneric Edit150
76F47092TEDI Request for Quote Detail Tag - Inbound14UZPNIDTrading Partner IDStringGeneric Edit150
77F47132TEDI Purchase Order Change Detail Tag - Inbound14UZPNIDTrading Partner IDStringGeneric Edit150
TOP43: Procurement
78F4301Z1Purchase Order Header Unedited Transaction Table12SYPNIDTrading Partner IDStringGeneric Edit150
79F43092Z1Receipt Routing Unedited Transaction Table13SZPNIDTrading Partner IDStringGeneric Edit150
80F4311Z1Purchase Order Detail Unedited Transaction Table12SZPNIDTrading Partner IDStringGeneric Edit150
81F43121Z1Receipts Unedited Transaction Table12SZPNIDTrading Partner IDStringGeneric Edit150
TOP44H: Homebuilder Management
82F44H101ZHB Community Master Unedited Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
83F44H201ZHB Lot Master Unedited Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
84F44H501ZHB Sales Master Unedited Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
85F44H604ZHB Vendor Assignment Unedited Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
86F44H711ZHB Lot Start Unedited Transaction File12SZPNIDTrading Partner IDStringGeneric Edit150
TOP45: Advanced Pricing
87F4576Z1Ship and Debit Claims Unedited Transaction Table12Z1PNIDTrading Partner IDStringGeneric Edit150
TOP46: Warehouse Management
88F4611Z1Unedited Suggestion Table12SZPNIDTrading Partner IDStringGeneric Edit150
89F4942Z1Work File for F494212SYPNIDTrading Partner IDStringGeneric Edit150
TOP47: Electronic Commerce
90F47006EDI Order Header - Outbound Tax Table14STPNIDTrading Partner IDStringGeneric Edit150
91F47007EDI Order Detail - Outbound Tax Table14DTPNIDTrading Partner IDStringGeneric Edit150
92F47011EDI Purchase Order Header - Inbound14SYPNIDTrading Partner IDStringGeneric Edit150
93F47011TXEDI Purchase Order Header Tax - Inbound14STPNIDTrading Partner IDStringGeneric Edit150
94F47012EDI Purchase Order Detail - Inbound14SZPNIDTrading Partner IDStringGeneric Edit150
95F47012TXEDI Purchase Order Detail Tax - Inbound14DTPNIDTrading Partner IDStringGeneric Edit150
96F47016EDI Purchase Order Header - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
97F470161EDI Purchase Order Additional Header - Outbound71S3PNIDTrading Partner IDStringGeneric Edit150
98F47017EDI Purchase Order Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
99F470171EDI Purchase Order Additional Detail - Outbound52S4PNIDTrading Partner IDStringGeneric Edit150
100F47021EDI P.O. Acknowledgment Header - Inbound14SYPNIDTrading Partner IDStringGeneric Edit150
101F47022EDI P.O. Acknowledgment Detail - Inbound14SZPNIDTrading Partner IDStringGeneric Edit150
102F47026EDI P.O. Acknowledgment Header - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
103F47027EDI P.O. Acknowledgment Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
104F47031EDI Shipping Notice Header - Inbound14SYPNIDTrading Partner IDStringGeneric Edit150
105F47032EDI Shipping Notice Detail - Inbound14SZPNIDTrading Partner IDStringGeneric Edit150
106F47036EDI Shipping Notice Header - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
107F47036XEDI Shipping Notice Header Tax - Outbound14STPNIDTrading Partner IDStringGeneric Edit150
108F47037EDI Shipping Notice Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
109F470371EDI Shipping Notice Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
110F470371XEDI Shipping Notice Detail Tax - Outbound17DTPNIDTrading Partner IDStringGeneric Edit150
111F47041EDI Invoice Header - Inbound14SYPNIDTrading Partner IDStringGeneric Edit150
112F47042EDI Invoice Detail - Inbound14SZPNIDTrading Partner IDStringGeneric Edit150
113F47044EDI Invoice Summary - Inbound14SWPNIDTrading Partner IDStringGeneric Edit150
114F47046EDI Invoice Header (Sales) - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
115F47047EDI Invoice Detail (Sales) - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
116F47056EDI Payment Order Header - Outbound14D1PNIDTrading Partner IDStringGeneric Edit150
117F47056WEDI Payment Order Header - Work14D1PNIDTrading Partner IDStringGeneric Edit150
118F47057EDI Payment Order Remittance Advice - Outbound14D3PNIDTrading Partner IDStringGeneric Edit150
119F47057WEDI Payment Order Remittance Advice - Work14D3PNIDTrading Partner IDStringGeneric Edit150
120F47061EDI Planning Schedule Header - Inbound14MJPNIDTrading Partner IDStringGeneric Edit150
121F47062EDI Planning Schedule Detail - Inbound14MYPNIDTrading Partner IDStringGeneric Edit150
122F47066EDI Planning Schedule Header - Outbound14MJPNIDTrading Partner IDStringGeneric Edit150
123F47067EDI Planning Schedule Detail - Outbound14MYPNIDTrading Partner IDStringGeneric Edit150
124F47071EDI Receiving Advice Header - Inbound14SYPNIDTrading Partner IDStringGeneric Edit150
125F47072EDI Receiving Advice Detail - Inbound14SZPNIDTrading Partner IDStringGeneric Edit150
126F47076EDI Receiving Advice Header - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
127F47077EDI Receiving Advice Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
128F47081EDI Price Sales Catalog Header - Inbound14FVPNIDTrading Partner IDStringGeneric Edit150
129F47082EDI Price Sales Catalog Detail - Inbound14FYPNIDTrading Partner IDStringGeneric Edit150
130F47091EDI Request for Quote Header - Inbound14SYPNIDTrading Partner IDStringGeneric Edit150
131F47091TXEDI Request for Quote Header Tax - Inbound14STPNIDTrading Partner IDStringGeneric Edit150
132F47092EDI Request for Quote Detail - Inbound14SZPNIDTrading Partner IDStringGeneric Edit150
133F47096EDI Request for Quote Header - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
134F47097EDI Request for Quote Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
135F47101EDI Response to RFQ Header - Inbound14SYPNIDTrading Partner IDStringGeneric Edit150
136F47102EDI Response to RFQ Detail - Inbound14SZPNIDTrading Partner IDStringGeneric Edit150
137F47106EDI Response to RFQ Header - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
138F47107EDI Response to RFQ Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
139F47111EDI Lockbox/Payment Header - Transaction14Z1PNIDTrading Partner IDStringGeneric Edit150
140F47112EDI Lockbox Header - Transaction14Z2PNIDTrading Partner IDStringGeneric Edit150
141F47121EDI Product Activity Data Header - Inbound14M1PNIDTrading Partner IDStringGeneric Edit150
142F47122EDI Product Activity Data Detail - Inbound14MJPNIDTrading Partner IDStringGeneric Edit150
143F47126EDI Product Activity Data Header - Outbound14M1PNIDTrading Partner IDStringGeneric Edit150
144F47127EDI Product Activity Data Detail - Outbound14MJPNIDTrading Partner IDStringGeneric Edit150
145F47131EDI Purchase Order Change Header - Inbound14SYPNIDTrading Partner IDStringGeneric Edit150
146F47131TXEDI Purchase Order Change Header Tax - Inbound14STPNIDTrading Partner IDStringGeneric Edit150
147F47132EDI Purchase Order Change Detail - Inbound14SZPNIDTrading Partner IDStringGeneric Edit150
148F47132TXEDI Purchase Order Change Detail Tax - Inbound14DTPNIDTrading Partner IDStringGeneric Edit150
149F47136EDI Purchase Order Change Header - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
150F47137EDI Purchase Order Change Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
151F47141EDI P.O. Change Acknowledgment Header - Inbound14SYPNIDTrading Partner IDStringGeneric Edit150
152F471411Purchase Order Edit Object Log Table5SZPNIDTrading Partner IDStringGeneric Edit150
153F47142EDI P.O. Change Acknowledgment Detail - Inbound14SZPNIDTrading Partner IDStringGeneric Edit150
154F47146EDI P.O. Change Acknowledgment Header - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
155F47147EDI P.O. Change Acknowledgment Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
156F47156EDI Shipping Schedule Header - Outbound14SYPNIDTrading Partner IDStringGeneric Edit150
157F47157EDI Shipping Schedule Detail - Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
158F4716EDI Item Text - Inbound/Outbound14SZPNIDTrading Partner IDStringGeneric Edit150
159F47181EDI Consumption Header (FUTURE)19EHPNIDTrading Partner IDStringGeneric Edit150
160F47182EDI Consumption Detail (FUTURE)28EDPNIDTrading Partner IDStringGeneric Edit150
161F47CTLEDI Lockbox/Payment Work File18Z5PNIDTrading Partner IDStringGeneric Edit150
TOP48: Work Order Processing
162F4801Z1Outbound Work Order Header12SYPNIDTrading Partner IDStringGeneric Edit150
TOP49: Transportation Management
163F47092TXEDI Request for Quote Detail Tax - Inbound14DTPNIDTrading Partner IDStringGeneric Edit150
TOP70: Multi-National Products
164F70XMLZ1XML Transaction Interfase12SYPNIDTrading Partner IDStringGeneric Edit150
TOP74: EMEA Localization
165F74XMLZ1XML Transaction Interface6SYPNIDTrading Partner IDStringGeneric Edit150
TOP89: Conversion Programs
166F01111Z1Batch - Contact Information12CBPNIDTrading Partner IDStringGeneric Edit150