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

163 columns | Print definition?910 | PNID

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