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

88 columns | Print definition?910 | TYTN | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0006Z1Cost Center Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
2F0046Processing Log5PLTYTNType - TransactionStringUDC80
3F0047Data Export Control1DETYTNType - TransactionStringUDC80
4F0401Z1Supplier Master - Batch Upload6VOTYTNType - TransactionStringUDC80
TOP01: Address Book
5F0101Z2Address Book - Interoperability6SZTYTNType - TransactionStringUDC80
6F01112Z1Batch - Related Person6PBTYTNType - TransactionStringUDC80
7F0111Z1Batch Who's Who Information6BWTYTNType - TransactionStringUDC80
8F01151Z1Batch - Electronic Address6EBTYTNType - TransactionStringUDC80
9F0115Z1Phones - Interoperability7PITYTNType - TransactionStringUDC80
10F01161Z1Batch - Alternative Address6LBTYTNType - TransactionStringUDC80
TOP03: Accounts Receivable
11F03012Z1Customer Master LOB-Batch Table6VOTYTNType - TransactionStringUDC80
TOP03B: Enhanced Accounts Receivable
12F03B11Z2F03B11 Interoperability Table6SYTYTNType - TransactionStringUDC80
13F03B13Z2F03B13 Interoperability Table6SYTYTNType - TransactionStringUDC80
14F03B14Z2F03B14 Interoperability Table6SZTYTNType - TransactionStringUDC80
15F03B41Z1Inteoperability - Deductions Management6SZTYTNType - TransactionStringUDC80
TOP04: Accounts Payable
16F0411Z3F0411 Interoperability Table6SZTYTNType - TransactionStringUDC80
17F0413Z1F0413 Interoperability Table6SYTYTNType - TransactionStringUDC80
18F0414Z1F0414 Interoperability Table6SZTYTNType - TransactionStringUDC80
TOP05A: OW HR & PR Foundation
19F060116ZUnedited Quick Hire Transaction File6SZTYTNType - TransactionStringUDC80
TOP09: General Accounting
20F0911Z4F0911 Interoperability Table6SZTYTNType - TransactionStringUDC80
TOP10: Financial Reporting
21F1001Z1Unedited MSC Interoperability Header Table6IATYTNType - TransactionStringUDC80
22F1002Z1Unedited MSC Interoperability Table6SZTYTNType - TransactionStringUDC80
TOP11: Multi Currency
23F0015Z1External Currency Exchange Rates6ZETYTNType - TransactionStringUDC80
TOP12: Fixed Assets
24F1201Z1Unedited Asset Master Transactions6FATYTNType - TransactionStringUDC80
25F1217Z1Unedited Equipment Tag Transactions6WRTYTNType - TransactionStringUDC80
26F1217Z2Unedited Equipment Tag Transactions6WRTYTNType - TransactionStringUDC80
TOP13: Plant/Equipment Management
27F12120Z1Unedited Meter Reading Transactions6SZTYTNType - TransactionStringUDC80
TOP13C: Condition-Base Maintenance
28F1310Z1Unedited Condition-Based Alerts6CBTYTNType - TransactionStringUDC80
TOP16: Profit Management (EPS)
29F1602Z1External Cost Analyzer Balances - Interoperability Table6CZTYTNType - TransactionStringUDC80
30F1632Z1External Driver Balances-Interoperability Table6CYTYTNType - TransactionStringUDC80
TOP17: Customer Service Management
31F3111Z2Warranty Claim/Supplier Recovery processing6WPTYTNType - TransactionStringUDC80
32F3112Z2Warranty Claim/Supplier Recovery processing6WLTYTNType - TransactionStringUDC80
33F4801TZ2Warranty Claim/Supplier Recovery processing6WQTYTNType - TransactionStringUDC80
34F4801Z2Warranty Claim/Supplier Recovery processing6WSTYTNType - TransactionStringUDC80
TOP30: Product Data Management
35F0007Z1Work Day Calendar Transaction File6SZTYTNType - TransactionStringUDC80
36F30006Z1Work Center Transaction File6SZTYTNType - TransactionStringUDC80
37F3002Z1Bill of Material Transaction File6SZTYTNType - TransactionStringUDC80
38F3003Z1Routing Transactions File6SZTYTNType - TransactionStringUDC80
TOP31: Shop Floor Control
39F30161Z1Inbound Kanban Card Detail6SZTYTNType - TransactionStringUDC80
40F3111Z1Outbound Work Order Parts List6SZTYTNType - TransactionStringUDC80
41F31122Z1Work Order Time Transactions Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
42F3112Z1Outbound Work Order Routings6SZTYTNType - TransactionStringUDC80
TOP31B: Blend Management
43F31B17Z1Operation EUR Transaction File6SZTYTNType - TransactionStringUDC80
44F31B18Z1VBT Barrel Transaction File6SZTYTNType - TransactionStringUDC80
45F31B19Z1Instructed Attributes Transaction File6SZTYTNType - TransactionStringUDC80
46F31B31Z1Operations Composition Transaction File6SZTYTNType - TransactionStringUDC80
47F31B34Z1Operations Style Transaction File6SZTYTNType - TransactionStringUDC80
48F31B3CZ1Operations Cost Transaction File6SZTYTNType - TransactionStringUDC80
49F31B52Z1Operations Equipment Transaction File6SZTYTNType - TransactionStringUDC80
50F31B53Z1Operations Consumables Transaction File6SZTYTNType - TransactionStringUDC80
51F31B65Z1Operations Transaction File6SZTYTNType - TransactionStringUDC80
52F31B93Z1WIM Work Order Transaction File6SZTYTNType - TransactionStringUDC80
53F31B97Z1Operations Resource Transaction File6SZTYTNType - TransactionStringUDC80
54F31BQAZ1Operations Quality Test Transaction File9SZTYTNType - TransactionStringUDC80
55F31BSPZ1Sample Transactions42STTYTNType - TransactionStringUDC80
TOP36: Forecasting
56F3460Z1Forecast Unedited Transactions6FTTYTNType - TransactionStringUDC80
TOP37: Quality Management
57F3711Z1Test Results Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
TOP40: Inventory/OP Base
58F4106NCBase Price Extraction6SZTYTNType - TransactionStringUDC80
59F4201Z1Sales Order Header Unedited Transaction File6SYTYTNType - TransactionStringUDC80
60F4211Z1Sales Order Detail Unedited Transaction File6SZTYTNType - TransactionStringUDC80
61F49211Z1Sales Order Detail Tag Unedited Transaction File6S1TYTNType - TransactionStringUDC80
TOP41: Inventory Management
62F4101Z1F4101 Item Master Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
63F4101Z1AF4101 Detail Item Master Unedited Transaction6SZTYTNType - TransactionStringUDC80
64F41021Z1Item Location Unedited Transaction File6SZTYTNType - TransactionStringUDC80
65F4105Z1Unedited Transaction Table - Item Cost6SZTYTNType - TransactionStringUDC80
66F4141Z1F4141 Cycle Count Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
TOP43: Procurement
67F4301Z1Purchase Order Header Unedited Transaction Table6SYTYTNType - TransactionStringUDC80
68F43092Z1Receipt Routing Unedited Transaction Table10SZTYTNType - TransactionStringUDC80
69F4311Z1Purchase Order Detail Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
70F43121Z1Receipts Unedited Transaction Table6SZTYTNType - TransactionStringUDC80
TOP44H: Homebuilder Management
71F44H101ZHB Community Master Unedited Transaction File6SZTYTNType - TransactionStringUDC80
72F44H201ZHB Lot Master Unedited Transaction File6SZTYTNType - TransactionStringUDC80
73F44H501ZHB Sales Master Unedited Transaction File6SZTYTNType - TransactionStringUDC80
74F44H604ZHB Vendor Assignment Unedited Transaction File6SZTYTNType - TransactionStringUDC80
75F44H711ZHB Lot Start Unedited Transaction File6SZTYTNType - TransactionStringUDC80
TOP45: Advanced Pricing
76F4576Z1Ship and Debit Claims Unedited Transaction Table6Z1TYTNType - TransactionStringUDC80
TOP46: Warehouse Management
77F4611Z1Unedited Suggestion Table6SZTYTNType - TransactionStringUDC80
78F4942Z1Work File for F49426SYTYTNType - TransactionStringUDC80
TOP47: Electronic Commerce
79F47002Flat File Cross-Reference Table1SVTYTNType - TransactionStringUDC80
TOP48: Work Order Processing
80F4801Z1Outbound Work Order Header6SYTYTNType - TransactionStringUDC80
TOP70: Multi-National Products - obsolete-do not reuse
81F70XMLZ1XML Transaction Interfase6SYTYTNType - TransactionStringUDC80
TOP74: EMEA Localization
82F74XMLZ1XML Transaction Interface7SYTYTNType - TransactionStringUDC80
TOP76B: Brazil - Reporting System Only
83F76B474Dynamic Formater Bank Attributes - 03B2BATYTNType - TransactionStringUDC80
84F76B474IFile Upload For Bank Transaction Inbound Process - 03B4BITYTNType - TransactionStringUDC80
85F76B475Dynamic Formater Bank Layout by Payment Instument - 03B2BLTYTNType - TransactionStringUDC80
86F76B476Dynamic Formater Bank Attributes Cross Reference - 03B2BXTYTNType - TransactionStringUDC80
87F76B477Dynamic Formater GL Bank Account File Numbers - 03B2BGTYTNType - TransactionStringUDC80
TOP89: Conversion Programs
88F01111Z1Batch - 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  810     InvoiceN
2  820     Payment OrderN
3  823     LockboxN
4  824     Application AdviceY
5  830     Planning ScheduleN
6  832     Price Sales CatalogN
7  840     Request for QuoteN
8  843     Response to RFQN
9  844     Claim NotificationN
10  845     Claim AcknowledgementN
11  849     Claim Status NotificationN
12  850     Purchase OrderN
13  852     Product Activity DataN
14  855     Purchase Order AcknowledgmentN
15  856     Shipment NoticeN
16  860     Purchase Order ChangeN
17  861     Receiving AdviceN
18  862     Shipping ScheduleN
19  865     Purchase Order Change Ack.N
20  867     Product Transfer and ResaleN
21  997     Functional AcknowledgmentY
22  APERAK  Application AdviceY
23  CBMALERTCondition-Based AlertsY
24  CONTRL  Functional AcknowledgmentY
25  CRTN0116F060116 - Export to Criterion1Y
26  CRTN8001F08001 - Export to Criterion1Y
27  CRTN8101F08101 - Export to Criterion1Y
28  DEBADV  LockboxN
29  DELFOR  Planning ScheduleN
30  DEMAND  Inbound DemandY
31  DESADV  Shipment NoticeY
32  IFTMAN  Receiving AdviceN
33  IFTMIN  shipment NoticeN
34  INVOIC  InvoiceN
35  INVRPT  Product Data ActivityN
36  JDEAB   Address BookY
37  JDEBOM  Bill of Material TransactionY
38  JDECM   Customer MasterY
39  JDECMP  CompletionsY
40  JDECSMS Customer Service ManagementY
41  JDECYCLEF4141 Process Cycle CountY
42  JDEEM   Equipment ManagementY
43  JDEEMPL Employee MasterY
44  JDEFA   Fixed AssetsY
45  JDEFC   Forecast TransactionY
46  JDEHQ   Hours and QuantitiesY
47  JDEIC   Inventory CostY
48  JDEII   Inventory IssuesY
49  JDEIL   Item LocationN
50  JDEINV  InvoicesNY
51  JDEITEM F4101 Process Item MasterY
52  JDEJE   Journal EntryY
53  JDEKNB  Inbound Kanban ProcessingY
54  JDEMCU  Cost CentersY
55  JDEMSG  Transaction for MessagesY
56  JDEPICK ITLS Pick Slips OW onlyY
57  JDEPL   WO Parts List TransactionY
58  JDEPOIN Inbound Purchase OrderN
59  JDEPOOUTPurchase Order OutboundY
60  JDEPRICEBase Price ExtractionY
61  JDEPYMNTOutbound PaymentsN
62  JDEQMTR Quality Mgmt Test ResultY
63  JDER    ReceiptsY
64  JDERC   A/R Cash ReceiptsY
65  JDEREC  ReceiptsNY
66  JDEROU  Routing TransactionN
67  JDERR   Receipts RoutingY
68  JDERTG  WO Routings TransactionY
69  JDESBF  Super BackflushY
70  JDESC   Shipment Confirmation1Y
71  JDESFJE Store Forward Journal EntryY
72  JDESHIP ITLS Shipment Confirm OW onlyY
73  JDESHIPIInbound ShipmentN
74  JDESM   Supplier MasterY
75  JDESOE  ITLS Sales Order Entry OW onlyY
76  JDESOOUTSales Order OutboundN
77  JDESUGSTWMS Inbound SuggestionY
78  JDETEIN Time Entry PC UploadY
79  JDETRV  EDI Transmission ValuesY
80  JDEVOUCHInbound VouchersY
81  JDEWC   Work Center TransactionY
82  JDEWCN  WIM ConsumableY
83  JDEWCO  WIM CompositionY
84  JDEWCST WIM CostY
85  JDEWDC  Work Day Calendar TransactionY
86  JDEWEQ  WIM EquipmentY
87  JDEWEUR WIM Multiple EURY
88  JDEWINS WIM Instructed AttributesY
89  JDEWO   Work Order Header TransactionY
90  JDEWOP  WIM OperationY
91  JDEWQA  WIM QualityY
92  JDEWRS  WIM ResourceY
93  JDEWSPL WIM SamplesY
94  JDEWST  WIM StyleY
95  JDEWVBT WIM VBT TransactionsY
96  JDEWWO  WIM Work OrderY
97  JDINV   InvoiceN
98  JEDTEIN Time Entry PC UploadY
99  ORDCHG  Purchase Order ChangeN
100  ORDERS  Purchase OrderN
101  ORDRSP  Purchase Order AcknowledgmentN
102  PAYEXT  Payment OrderN
103  PCRC8102Export to Personic1N
104  PRICAT  Price Sales CatalogN
105  PRSC0006F0006 - Export to Personic1Y
106  PRSC0116F060116 - Export to Personic1Y
107  PRSC116ZF060116z -Import from PersonicY
108  PRSC2001F082001 - Export to Personic1Y
109  PRSC8001F08001 - Export to Persionic1Y
110  PRSC8101F08101 - Export to Personic1Y
111  PRSC8102F08102 - Export to Personic1Y
112  QUOTES  Response to RFQN
113  REQUOT  Request for QuoteN
114  SLSRPT  Product Transfer and ResaleN
115  UDCADDS State1Y
116  UDCAT1  Search Type1Y
117  UDCCTR  Country Code1Y
118  UDCEEOJ EEO Job Category1Y
119  UDCEEOM Ethnic Code1Y
120  UDCEST  Employment Status1Y
121  UDCFLSA Overtime Extempt1Y
122  UDCJBCD Job Type1Y
123  UDCJBST Job Step1Y
124  UDCJGRP Job Group1Y
125  UDCJSTA Job Status1Y
126  UDCLNGP Language Preference1Y
127  UDCMAIL Check Route Code1Y
128  UDCMSTX Marital Status1Y
129  UDCP001 Category Code 11Y
130  UDCP0010Category Code 101Y
131  UDCP0011Category Code 111Y
132  UDCP0012Category Code 121Y
133  UDCP0013Category Code 131Y
134  UDCP0014Category Code 141Y
135  UDCP0015Category Code 151Y
136  UDCP0016Category Code 161Y
137  UDCP0017Category Code 171Y
138  UDCP0018Category Code 181Y
139  UDCP0019Category Code 191Y
140  UDCP002 Category Code 21Y
141  UDCP0020Category Code 201Y
142  UDCP003 Category Code 31Y
143  UDCP004 Category Code 41Y
144  UDCP005 Category Code 51Y
145  UDCP006 Category Code 61Y
146  UDCP007 Category Code 71Y
147  UDCP008 Category Code 81Y
148  UDCP009 Category Code 91Y
149  UDCP010 Category Code 101Y
150  UDCP011 Category Code 111Y
151  UDCP012 Category Code 121Y
152  UDCP013 Category Code 131Y
153  UDCP014 Category Code 141Y
154  UDCP015 Category Code 151Y
155  UDCP016 Categpru Code 161Y
156  UDCP017 Category Code 171Y
157  UDCP018 Category Code 181Y
158  UDCP019 Category Code 191Y
159  UDCP020 Category Code 201Y
160  UDCPAST Pay Status1Y
161  UDCPFRQ Pay Frequency1Y
162  UDCRCCD Record Type1Y
163  UDCREQS Requisition Status1Y
164  UDCSALU Prefix1Y
165  UDCSALY Pay Class1Y
166  UDCSEX  Gender1Y
167  UDCSHFT Shift Code1Y
168  UDCSLOC Locality1Y
169  UDCSUFF Suffix1Y
170  UDCTYC  Emer Contact Type1Y
171  UDCUN   Union1Y