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
9F4111ILItem Ledger File
10F4311PDPurchase Order Detail File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F4311PDPurchase Order Detail File
3F0101ABAddress Book Master
4F0006MCBusiness Unit Master
5F0411RPAccounts Payable Ledger
6F4211SDSales Order Detail File
7F42119SDSales Order History File
8F03012AICustomer Master by Line of Business
9F0902GBAccount Balances
10F4801WAWork Order Master File

149 columns | Print definition?812 | PNID

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