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

91 columns | Print definition?920 | TYTN | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006DZ1Business Unit Alternate Description Z file12SZTYTNType - TransactionStringUDC80
2F0006Z1Cost Center Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
3F0006Z2Business Unit Master Z File9SZTYTNType - TransactionStringUDC80
4F0010ZCompany Constants Z File11SZTYTNType - TransactionStringUDC80
5F0046Processing Log5PLTYTNType - TransactionStringUDC80
6F0047Data Export Control1DETYTNType - TransactionStringUDC80
7F0401Z1Supplier Master - Batch Upload6VOTYTNType - TransactionStringUDC80
TOP01: Address Book
8F0101Z2Address Book - Interoperability6SZTYTNType - TransactionStringUDC80
9F01112Z1Batch - Related Person6PBTYTNType - TransactionStringUDC80
10F0111Z1Batch Who's Who Information6BWTYTNType - TransactionStringUDC80
11F01151Z1Batch - Electronic Address6EBTYTNType - TransactionStringUDC80
12F0115Z1Phones - Interoperability7PITYTNType - TransactionStringUDC80
13F01161Z1Batch - Alternative Address6LBTYTNType - TransactionStringUDC80
TOP03: Accounts Receivable
14F03012Z1Customer Master LOB-Batch Table6VOTYTNType - TransactionStringUDC80
TOP03B: Enhanced Accounts Receivable
15F03B11Z2F03B11 Interoperability Table6SYTYTNType - TransactionStringUDC80
16F03B13Z2F03B13 Interoperability Table6SYTYTNType - TransactionStringUDC80
17F03B14Z2F03B14 Interoperability Table6SZTYTNType - TransactionStringUDC80
18F03B41Z1Inteoperability - Deductions Management6SZTYTNType - TransactionStringUDC80
TOP04: Accounts Payable
19F0411Z3F0411 Interoperability Table6SZTYTNType - TransactionStringUDC80
20F0413Z1F0413 Interoperability Table6SYTYTNType - TransactionStringUDC80
21F0414Z1F0414 Interoperability Table6SZTYTNType - TransactionStringUDC80
TOP05A: PeopleSoft HR & PR Foundation
22F060116ZUnedited Quick Hire Transaction File6SZTYTNType - TransactionStringUDC80
TOP09: General Accounting
23F0911Z4F0911 Interoperability Table6SZTYTNType - TransactionStringUDC80
TOP10: Financial Reporting
24F1001Z1Unedited MSC Interoperability Header Table6IATYTNType - TransactionStringUDC80
25F1002Z1Unedited MSC Interoperability Table6SZTYTNType - TransactionStringUDC80
TOP11: Multi Currency
26F0015Z1External Currency Exchange Rates6ZETYTNType - TransactionStringUDC80
TOP12: Fixed Assets
27F1201Z1Unedited Asset Master Transactions6FATYTNType - TransactionStringUDC80
28F1217Z1Unedited Equipment Tag Transactions6WRTYTNType - TransactionStringUDC80
29F1217Z2Unedited Equipment Tag Transactions6WRTYTNType - TransactionStringUDC80
TOP13: Plant/Equipment Management
30F12120Z1Unedited Meter Reading Transactions6SZTYTNType - TransactionStringUDC80
TOP13C: Condition-Base Maintenance
31F1310Z1Unedited Condition-Based Alerts6CBTYTNType - TransactionStringUDC80
TOP16: Profit Management (EPS)
32F1602Z1External Cost Analyzer Balances - Interoperability Table6CZTYTNType - TransactionStringUDC80
33F1632Z1External Driver Balances-Interoperability Table6CYTYTNType - TransactionStringUDC80
TOP17: Customer Service Management
34F3111Z2Warranty Claim/Supplier Recovery processing6WPTYTNType - TransactionStringUDC80
35F3112Z2Warranty Claim/Supplier Recovery processing6WLTYTNType - TransactionStringUDC80
36F4801TZ2Warranty Claim/Supplier Recovery processing6WQTYTNType - TransactionStringUDC80
37F4801Z2Warranty Claim/Supplier Recovery processing6WSTYTNType - TransactionStringUDC80
TOP30: Product Data Management
38F0007Z1Work Day Calendar Transaction File6SZTYTNType - TransactionStringUDC80
39F30006Z1Work Center Transaction File6SZTYTNType - TransactionStringUDC80
40F3002Z1Bill of Material Transaction File6SZTYTNType - TransactionStringUDC80
41F3003Z1Routing Transactions File6SZTYTNType - TransactionStringUDC80
TOP31: Shop Floor Control
42F30161Z1Inbound Kanban Card Detail6SZTYTNType - TransactionStringUDC80
43F3111Z1Outbound Work Order Parts List6SZTYTNType - TransactionStringUDC80
44F31122Z1Work Order Time Transactions Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
45F3112Z1Outbound Work Order Routings6SZTYTNType - TransactionStringUDC80
TOP31B: Blend Management
46F31B17Z1Operation EUR Transaction File6SZTYTNType - TransactionStringUDC80
47F31B18Z1VBT Barrel Transaction File6SZTYTNType - TransactionStringUDC80
48F31B19Z1Instructed Attributes Transaction File6SZTYTNType - TransactionStringUDC80
49F31B31Z1Operations Composition Transaction File6SZTYTNType - TransactionStringUDC80
50F31B34Z1Operations Style Transaction File6SZTYTNType - TransactionStringUDC80
51F31B3CZ1Operations Cost Transaction File6SZTYTNType - TransactionStringUDC80
52F31B52Z1Operations Equipment Transaction File6SZTYTNType - TransactionStringUDC80
53F31B53Z1Operations Consumables Transaction File6SZTYTNType - TransactionStringUDC80
54F31B65Z1Operations Transaction File6SZTYTNType - TransactionStringUDC80
55F31B93Z1WIM Work Order Transaction File6SZTYTNType - TransactionStringUDC80
56F31B97Z1Operations Resource Transaction File6SZTYTNType - TransactionStringUDC80
57F31BQAZ1Operations Quality Test Transaction File9SZTYTNType - TransactionStringUDC80
58F31BSPZ1Sample Transactions42STTYTNType - TransactionStringUDC80
TOP36: Forecasting
59F3460Z1Forecast Unedited Transactions6FTTYTNType - TransactionStringUDC80
TOP37: Quality Management
60F3711Z1Test Results Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
TOP40: Inventory/OP Base
61F4106NCBase Price Extraction6SZTYTNType - TransactionStringUDC80
62F4201Z1Sales Order Header Unedited Transaction File6SYTYTNType - TransactionStringUDC80
63F4211Z1Sales Order Detail Unedited Transaction File6SZTYTNType - TransactionStringUDC80
64F49211Z1Sales Order Detail Tag Unedited Transaction File6S1TYTNType - TransactionStringUDC80
TOP41: Inventory Management
65F4101Z1F4101 Item Master Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
66F4101Z1AF4101 Detail Item Master Unedited Transaction6SZTYTNType - TransactionStringUDC80
67F41021Z1Item Location Unedited Transaction File6SZTYTNType - TransactionStringUDC80
68F4105Z1Unedited Transaction Table - Item Cost6SZTYTNType - TransactionStringUDC80
69F4141Z1F4141 Cycle Count Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
TOP43: Procurement
70F4301Z1Purchase Order Header Unedited Transaction Table6SYTYTNType - TransactionStringUDC80
71F43092Z1Receipt Routing Unedited Transaction Table10SZTYTNType - TransactionStringUDC80
72F4311Z1Purchase Order Detail Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
73F43121Z1Receipts Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
TOP44H: Homebuilder Management
74F44H101ZHB Community Master Unedited Transaction File6SZTYTNType - TransactionStringUDC80
75F44H201ZHB Lot Master Unedited Transaction File6SZTYTNType - TransactionStringUDC80
76F44H501ZHB Sales Master Unedited Transaction File6SZTYTNType - TransactionStringUDC80
77F44H604ZHB Vendor Assignment Unedited Transaction File6SZTYTNType - TransactionStringUDC80
78F44H711ZHB Lot Start Unedited Transaction File6SZTYTNType - TransactionStringUDC80
TOP45: Advanced Pricing
79F4576Z1Ship and Debit Claims Unedited Transaction Table6Z1TYTNType - TransactionStringUDC80
TOP46: Warehouse Management
80F4611Z1Unedited Suggestion Table6SZTYTNType - TransactionStringUDC80
81F4942Z1Work File for F49426SYTYTNType - TransactionStringUDC80
TOP47: Electronic Commerce
82F47002Flat File Cross-Reference Table1SVTYTNType - TransactionStringUDC80
TOP48: Work Order Processing
83F4801Z1Outbound Work Order Header6SYTYTNType - TransactionStringUDC80
TOP70: Multi-National Products
84F70XMLZ1XML Transaction Interfase6SYTYTNType - TransactionStringUDC80
TOP74: EMEA Localization
85F74XMLZ1XML Transaction Interface7SYTYTNType - TransactionStringUDC80
TOP76B: Brazil
86F76B474Dynamic Formater Bank Attributes - 03B2BATYTNType - TransactionStringUDC80
87F76B474IFile Upload For Bank Transaction Inbound Process - 03B4BITYTNType - TransactionStringUDC80
88F76B475Dynamic Formater Bank Layout by Payment Instument - 03B2BLTYTNType - TransactionStringUDC80
89F76B476Dynamic Formater Bank Attributes Cross Reference - 03B2BXTYTNType - TransactionStringUDC80
90F76B477Dynamic Formater GL Bank Account File Numbers - 03B2BGTYTNType - TransactionStringUDC80
TOP89: Conversion Programs
91F01111Z1Batch - Contact Information6CBTYTNType - TransactionStringUDC80

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

TOPUDC 00 / TT (Transaction Type) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1  . N
2  809Fixed Assets1Y
3  810810/Invoice N
4  820Payment Order Y
5  823Lockbox Y
6  824Application Advice Y
7  830Planning Schedule Y
8  832Price Sales Catalog Y
9  840Request for Quote Y
10  843Response to RFQ Y
11  844Claim Notification Y
12  845Claim Acknowledgement Y
13  849Claim Status Notification Y
14  850Purchase Order Y
15  852Product Activity Data Y
16  855Purchase Order Acknowledgement Y
17  856Shipment Notice Y
18  860Purchase Order Change Y
19  861Receiving Advice Y
20  862Shipping Schedule Y
21  865Purchase Order Change Ack. Y
22  867Product Transfer and Release Y
23  997Functional Acknowledgment Y
24  APERAKApplication Advice Y
25  BRCOBESElectronic Receipts Brazil Y
26  BRPAGELElectronic Payment Brazil Y
27  CBMALERTCondition-Based Alerts Y
28  CONTRLFunctional Acknowledgment Y
29  CRTN0116F060116 - Export to Criterion1Y
30  CRTN8001F08001 - Export to Criterion1Y
31  CRTN8101F08101 - Export to Criterion1Y
32  DEBADVLockbox N
33  DELFORPlanning Schedule N
34  DEMANDInbound Demand Y
35  DESADVShipment Notice Y
36  IFTMANReceiving Advice N
37  IFTMINShipment Notice N
38  INVOICInvoice N
39  INVRPTProduct Data Activity N
40  JDEABAddress Book Y
41  JDEBOMBill of Material Transaction Y
42  JDECIContact Information Y
43  JDECMCustomer Master Y
44  JDECMPCompletions Y
45  JDECSMSCustomer Service Management Y
46  JDECYCLEF4141 Process Cycle Count Y
47  JDEEMEquipment Management Y
48  JDEEMPLEmployee Master Y
49  JDEFAFixed Assets Y
50  JDEFCForecast Transaction Y
51  JDEHQHours and Quantities Y
52  JDEICInventory Cost Y
53  JDEIIInventory Issues Y
54  JDEILItem Location N
55  JDEINVInvoicesNY
56  JDEITEMF4101 Process Item Master Y
57  JDEJEJournal Entry Y
58  JDEKNBInbound Kanban Processing Y
59  JDEMCUCost Centers Y
60  JDEMSGTransaction for Messages Y
61  JDEPICKITLS Pick Slips Y
62  JDEPLWO Parts List Transaction Y
63  JDEPOINInbound Purchase Order N
64  JDEPOOUTPurchase Order Outbound Y
65  JDEPRICEBase Price Extraction Y
66  JDEPYMNTOutbound Payments N
67  JDEQMTRQuality Mgmt Test Result Y
68  JDERReceipts Y
69  JDERCA/R Cash Receipts Y
70  JDERECReceiptsNY
71  JDEROURouting Transaction N
72  JDERRReceipts Routing Y
73  JDERTGWO Routings Transaction Y
74  JDESBFSuper Backflush Y
75  JDESCShipment Confirmation1Y
76  JDESFJEStore Forward Journal Entry Y
77  JDESHIPITLS Shipment Confirm Y
78  JDESHIPIInbound Shipment N
79  JDESMSupplier Master Y
80  JDESOEITLS Sales Order Entry Y
81  JDESOOUTSales Order Outbound N
82  JDESUGSTWMS Inbound Suggestion Y
83  JDETEINTime Entry PC Upload Y
84  JDETRVEDI Transmission Values Y
85  JDEVOUCHInbound/Outbound Vouchers Y
86  JDEWCWork Center Transaction Y
87  JDEWCNWIM Consumable Y
88  JDEWCOWIM Composition Y
89  JDEWCSTWIM Cost Y
90  JDEWDCWork Day Calendar Transaction Y
91  JDEWEQWIM Equipment Y
92  JDEWEURWIM Multiple EUR Y
93  JDEWINSWIM Instructed Attributes Y
94  JDEWOWork Order Header Transaction Y
95  JDEWOPWIM Operation Y
96  JDEWQAWIM Quality Y
97  JDEWRSWIM Resource Y
98  JDEWSPLWIM Samples Y
99  JDEWSTWIM Style Y
100  JDEWVBTWIM VBT Transactions Y
101  JDEWWOWIM Work Order Y
102  METERSInbound Meter Readings N
103  ORDCHGPurchase Order Change N
104  ORDERSPurchase Order N
105  ORDRSPPurchase Order Acknowledgment N
106  PAYEXTPayment Order N
107  PCRC8102Export to Personic1N
108  PRICATPrice Sales Catalog N
109  PRSC0006F0006 - Export to Personic1Y
110  PRSC0116F060116 - Export to Personic1Y
111  PRSC116ZF060116z -Import from Personic Y
112  PRSC2001F082001 - Export to Personic1Y
113  PRSC8001F08001 - Export to Persionic1Y
114  PRSC8101F08101 - Export to Personic1Y
115  PRSC8102F08102 - Export to Personic1Y
116  QUOTESResponse to RFQ N
117  REQUOTRequest for Quote N
118  SLSRPTProduct Transfer and Resale N
119  UDCADDSState1Y
120  UDCAT1Search Type1Y
121  UDCCTRCountry Code1Y
122  UDCEEOJEEO Job Category1Y
123  UDCEEOMEthnic Code1Y
124  UDCESTEmployment Status1Y
125  UDCFLSAOvertime Extempt1Y
126  UDCJBCDJob Type1Y
127  UDCJBSTJob Step1Y
128  UDCJGRPJob Group1Y
129  UDCJSTAJob Status1Y
130  UDCLNGPLanguage Preference1Y
131  UDCMAILCheck Route Code1Y
132  UDCMSTXMarital Status1Y
133  UDCP001Category Code 11Y
134  UDCP0010Category Code 101Y
135  UDCP0011Category Code 111Y
136  UDCP0012Category Code 121Y
137  UDCP0013Category Code 131Y
138  UDCP0014Category Code 141Y
139  UDCP0015Category Code 151Y
140  UDCP0016Category Code 161Y
141  UDCP0017Category Code 171Y
142  UDCP0018Category Code 181Y
143  UDCP0019Category Code 191Y
144  UDCP002Category Code 21Y
145  UDCP0020Category Code 201Y
146  UDCP003Category Code 31Y
147  UDCP004Category Code 41Y
148  UDCP005Category Code 51Y
149  UDCP006Category Code 61Y
150  UDCP007Category Code 71Y
151  UDCP008Category Code 81Y
152  UDCP009Category Code 91Y
153  UDCPASTPay Status1Y
154  UDCPFRQPay Frequency1Y
155  UDCRCCDRecord Type1Y
156  UDCREQSRequisition Status1Y
157  UDCSALUPrefix1Y
158  UDCSALYPay Class1Y
159  UDCSEXGender1Y
160  UDCSHFTShift Code1Y
161  UDCSLOCLocality1Y
162  UDCSUFFSuffix1Y
163  UDCTYCEmer Contact Type1Y
164  UDCUNUnion1Y