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

90 columns | Print definition?920 | DRIN | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006DZ1Business Unit Alternate Description Z file11SZDRINDirection IndicatorCharacterUDC10
2F0006Z1Cost Center Unedited Transaction Table9SZDRINDirection IndicatorCharacterUDC10
3F0006Z2Business Unit Master Z File8SZDRINDirection IndicatorCharacterUDC10
4F0010ZCompany Constants Z File10SZDRINDirection IndicatorCharacterUDC10
5F0048Code Mappings Master5CMDRINDirection IndicatorCharacterUDC10
6F0401Z1Supplier Master - Batch Upload9VODRINDirection IndicatorCharacterUDC10
TOP01: Address Book
7F0101Z2Address Book - Interoperability9SZDRINDirection IndicatorCharacterUDC10
8F01112Z1Batch - Related Person9PBDRINDirection IndicatorCharacterUDC10
9F0111Z1Batch Who's Who Information9BWDRINDirection IndicatorCharacterUDC10
10F01151Z1Batch - Electronic Address9EBDRINDirection IndicatorCharacterUDC10
11F0115Z1Phones - Interoperability10PIDRINDirection IndicatorCharacterUDC10
12F01161Z1Batch - Alternative Address9LBDRINDirection IndicatorCharacterUDC10
TOP03: Accounts Receivable
13F03012Z1Customer Master LOB-Batch Table9VODRINDirection IndicatorCharacterUDC10
TOP03B: Enhanced Accounts Receivable
14F03B11Z2F03B11 Interoperability Table9SYDRINDirection IndicatorCharacterUDC10
15F03B13Z2F03B13 Interoperability Table9SYDRINDirection IndicatorCharacterUDC10
16F03B14Z2F03B14 Interoperability Table9SZDRINDirection IndicatorCharacterUDC10
17F03B41Z1Inteoperability - Deductions Management9SZDRINDirection IndicatorCharacterUDC10
TOP04: Accounts Payable
18F0411Z3F0411 Interoperability Table9SZDRINDirection IndicatorCharacterUDC10
19F0413Z1F0413 Interoperability Table9SYDRINDirection IndicatorCharacterUDC10
20F0414Z1F0414 Interoperability Table9SZDRINDirection IndicatorCharacterUDC10
TOP05A: PeopleSoft HR & PR Foundation
21F060116ZUnedited Quick Hire Transaction File9SZDRINDirection IndicatorCharacterUDC10
TOP09: General Accounting
22F0911Z4F0911 Interoperability Table9SZDRINDirection IndicatorCharacterUDC10
TOP10: Financial Reporting
23F1001Z1Unedited MSC Interoperability Header Table9IADRINDirection IndicatorCharacterUDC10
24F1002Z1Unedited MSC Interoperability Table9SZDRINDirection IndicatorCharacterUDC10
TOP11: Multi Currency
25F0015Z1External Currency Exchange Rates9ZEDRINDirection IndicatorCharacterUDC10
TOP12: Fixed Assets
26F1201Z1Unedited Asset Master Transactions9FADRINDirection IndicatorCharacterUDC10
27F1217Z1Unedited Equipment Tag Transactions9WRDRINDirection IndicatorCharacterUDC10
28F1217Z2Unedited Equipment Tag Transactions9WRDRINDirection IndicatorCharacterUDC10
TOP13: Plant/Equipment Management
29F12120Z1Unedited Meter Reading Transactions9SZDRINDirection IndicatorCharacterUDC10
TOP13C: Condition-Base Maintenance
30F1310Z1Unedited Condition-Based Alerts9CBDRINDirection IndicatorCharacterUDC10
TOP16: Profit Management (EPS)
31F1602Z1External Cost Analyzer Balances - Interoperability Table9CZDRINDirection IndicatorCharacterUDC10
32F1632Z1External Driver Balances-Interoperability Table9CYDRINDirection IndicatorCharacterUDC10
TOP17: Customer Service Management
33F3111Z2Warranty Claim/Supplier Recovery processing9WPDRINDirection IndicatorCharacterUDC10
34F3112Z2Warranty Claim/Supplier Recovery processing9WLDRINDirection IndicatorCharacterUDC10
35F4801TZ2Warranty Claim/Supplier Recovery processing9WQDRINDirection IndicatorCharacterUDC10
36F4801Z2Warranty Claim/Supplier Recovery processing9WSDRINDirection IndicatorCharacterUDC10
TOP30: Product Data Management
37F0007Z1Work Day Calendar Transaction File9SZDRINDirection IndicatorCharacterUDC10
38F30006Z1Work Center Transaction File9SZDRINDirection IndicatorCharacterUDC10
39F3002Z1Bill of Material Transaction File9SZDRINDirection IndicatorCharacterUDC10
40F3003Z1Routing Transactions File9SZDRINDirection IndicatorCharacterUDC10
TOP31: Shop Floor Control
41F30161Z1Inbound Kanban Card Detail9SZDRINDirection IndicatorCharacterUDC10
42F3111Z1Outbound Work Order Parts List9SZDRINDirection IndicatorCharacterUDC10
43F31122Z1Work Order Time Transactions Unedited Transaction Table9SZDRINDirection IndicatorCharacterUDC10
44F3112Z1Outbound Work Order Routings9SZDRINDirection IndicatorCharacterUDC10
TOP31B: Blend Management
45F31B17Z1Operation EUR Transaction File9SZDRINDirection IndicatorCharacterUDC10
46F31B18Z1VBT Barrel Transaction File9SZDRINDirection IndicatorCharacterUDC10
47F31B19Z1Instructed Attributes Transaction File9SZDRINDirection IndicatorCharacterUDC10
48F31B31Z1Operations Composition Transaction File9SZDRINDirection IndicatorCharacterUDC10
49F31B34Z1Operations Style Transaction File9SZDRINDirection IndicatorCharacterUDC10
50F31B3CZ1Operations Cost Transaction File9SZDRINDirection IndicatorCharacterUDC10
51F31B52Z1Operations Equipment Transaction File9SZDRINDirection IndicatorCharacterUDC10
52F31B53Z1Operations Consumables Transaction File9SZDRINDirection IndicatorCharacterUDC10
53F31B65Z1Operations Transaction File9SZDRINDirection IndicatorCharacterUDC10
54F31B93Z1WIM Work Order Transaction File9SZDRINDirection IndicatorCharacterUDC10
55F31B97Z1Operations Resource Transaction File9SZDRINDirection IndicatorCharacterUDC10
56F31BQAZ1Operations Quality Test Transaction File12SZDRINDirection IndicatorCharacterUDC10
57F31BSPZ1Sample Transactions7STDRINDirection IndicatorCharacterUDC10
TOP36: Forecasting
58F3460Z1Forecast Unedited Transactions9FTDRINDirection IndicatorCharacterUDC10
TOP37: Quality Management
59F3711Z1Test Results Unedited Transaction Table9SZDRINDirection IndicatorCharacterUDC10
TOP40: Inventory/OP Base
60F4106NCBase Price Extraction9SZDRINDirection IndicatorCharacterUDC10
61F4201Z1Sales Order Header Unedited Transaction File9SYDRINDirection IndicatorCharacterUDC10
62F4211Z1Sales Order Detail Unedited Transaction File9SZDRINDirection IndicatorCharacterUDC10
63F49211Z1Sales Order Detail Tag Unedited Transaction File9S1DRINDirection IndicatorCharacterUDC10
TOP41: Inventory Management
64F4101Z1F4101 Item Master Unedited Transaction Table9SZDRINDirection IndicatorCharacterUDC10
65F4101Z1AF4101 Detail Item Master Unedited Transaction9SZDRINDirection IndicatorCharacterUDC10
66F41021Z1Item Location Unedited Transaction File9SZDRINDirection IndicatorCharacterUDC10
67F4105Z1Unedited Transaction Table - Item Cost9SZDRINDirection IndicatorCharacterUDC10
68F4141Z1F4141 Cycle Count Unedited Transaction Table9SZDRINDirection IndicatorCharacterUDC10
TOP43: Procurement
69F4301Z1Purchase Order Header Unedited Transaction Table9SYDRINDirection IndicatorCharacterUDC10
70F43092Z1Receipt Routing Unedited Transaction Table11SZDRINDirection IndicatorCharacterUDC10
71F4311Z1Purchase Order Detail Unedited Transaction Table9SZDRINDirection IndicatorCharacterUDC10
72F43121Z1Receipts Unedited Transaction Table9SZDRINDirection IndicatorCharacterUDC10
TOP44H: Homebuilder Management
73F44H101ZHB Community Master Unedited Transaction File9SZDRINDirection IndicatorCharacterUDC10
74F44H201ZHB Lot Master Unedited Transaction File9SZDRINDirection IndicatorCharacterUDC10
75F44H501ZHB Sales Master Unedited Transaction File9SZDRINDirection IndicatorCharacterUDC10
76F44H604ZHB Vendor Assignment Unedited Transaction File9SZDRINDirection IndicatorCharacterUDC10
77F44H711ZHB Lot Start Unedited Transaction File9SZDRINDirection IndicatorCharacterUDC10
TOP45: Advanced Pricing
78F4572Z1Live Promotions Interface - Inbound / Outbound16LPDRINDirection IndicatorCharacterUDC10
79F4572ZPPurge Live Promotions Interface16PGDRINDirection IndicatorCharacterUDC10
80F4576Z1Ship and Debit Claims Unedited Transaction Table9Z1DRINDirection IndicatorCharacterUDC10
TOP46: Warehouse Management
81F4611Z1Unedited Suggestion Table9SZDRINDirection IndicatorCharacterUDC10
82F4942Z1Work File for F49429SYDRINDirection IndicatorCharacterUDC10
TOP47: Electronic Commerce
83F47002Flat File Cross-Reference Table2SVDRINDirection IndicatorCharacterUDC10
TOP48: Work Order Processing
84F4801Z1Outbound Work Order Header9SYDRINDirection IndicatorCharacterUDC10
TOP70: Multi-National Products
85F70XMLZ1XML Transaction Interfase9SYDRINDirection IndicatorCharacterUDC10
TOP74: EMEA Localization
86F74XMLZ1XML Transaction Interface10SYDRINDirection IndicatorCharacterUDC10
TOP76B: Brazil
87F76B472Dynamic Formater Layout Transaction & Line Types - 03B2DDDRINDirection IndicatorCharacterUDC10
88F76B473Dynamic Formater Layouts Specification - 03B2DSDRINDirection IndicatorCharacterUDC10
89F76B474Dynamic Formater Bank Attributes - 03B3BADRINDirection IndicatorCharacterUDC10
TOP89: Conversion Programs
90F01111Z1Batch - Contact Information9CBDRINDirection IndicatorCharacterUDC10

User Defined Codes are, by design, customisable and thus will differ from system to system depending on the business requirements.

TOPUDC 00 / DN (Direction Indicator) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1         1Inbound N
2         2Outbound N