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

76 columns | Print definition?920 | SHFT | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0007Workday Calendar5CZSHFTShift CodeCharacterUDC10
TOP05: Time Accounting and HRM Base
2F06106Employee Pay Instructions12YMSHFTShift CodeCharacterUDC10
3F0618Employee Transaction History34YTSHFTShift CodeCharacterUDC10
4F069126Union Rates File7YLSHFTShift CodeCharacterUDC10
5F0691261Additional Union Rates7YLSHFTShift CodeCharacterUDC10
6F06936Retro Pay Types Rate5JASHFTShift CodeCharacterUDC10
TOP05A: PeopleSoft HR & PR Foundation
7F060116Employee Master Information40YASHFTShift CodeCharacterUDC10
8F0601161Point-In-Time Employee Master42PTSHFTShift CodeCharacterUDC10
9F060116WEE Master Request File40YASHFTShift CodeCharacterUDC10
10F060116ZUnedited Quick Hire Transaction File40SZSHFTShift CodeCharacterUDC10
11F060119Employee Jobs History File15YESHFTShift CodeCharacterUDC10
TOP05T: Time Entry
12F06116Employee Transaction Detail File34YTSHFTShift CodeCharacterUDC10
13F06116Z1Employee Transactions - Batch File75VLSHFTShift CodeCharacterUDC10
14F06116Z2ESS Timecard History75VMSHFTShift CodeCharacterUDC10
15F06278Retro Timecard Detail File61YTSHFTShift CodeCharacterUDC10
16F069136Tip Disbursement7JESHFTShift CodeCharacterUDC10
17F06918PF - Piece Rate File5JNSHFTShift CodeCharacterUDC10
18F069246Shift Differential Table1Y3SHFTShift CodeCharacterUDC10
19F06932Classification/Pay Cross Reference5J4SHFTShift CodeCharacterUDC10
TOP06: Payroll (old) - Obsolete-do not reuse
20F060118Employee Jobs14YESHFTShift CodeCharacterUDC10
TOP07: Payroll
21F06270Retro Processing Parameter46JPSHFTShift CodeCharacterUDC10
22F0716701Employee Assignment T/E Template Information23EASHFTShift CodeCharacterUDC10
23F0716709Employee Assignment T/E Template Info History23EASHFTShift CodeCharacterUDC10
24F071861Stub Detail Piece Rate History File8Y8SHFTShift CodeCharacterUDC10
25F073521Stub Detail Piece Rate File8Y2SHFTShift CodeCharacterUDC10
26F07UI200Timecard History Work File37THSHFTShift CodeCharacterUDC10
TOP08A: eRecruit
27F08403Extended Applicant Information3EISHFTShift CodeCharacterUDC10
TOP08AD: ADP Integration
28F05137ADP Employee Master Information12ADSHFTShift CodeCharacterUDC10
29F051371ADP Employee DBA Instructions17ADSHFTShift CodeCharacterUDC10
TOP13R: Resource Assignments
30F48301Resource Assignments Constants5RXSHFTShift CodeCharacterUDC10
31F48307Resource Working Hours5RHSHFTShift CodeCharacterUDC10
32F48310Resource Master8RMSHFTShift CodeCharacterUDC10
33F48311Resource Assignments64RASHFTShift CodeCharacterUDC10
34F48311SPurge - Resource Assignments64RASHFTShift CodeCharacterUDC10
35F48316Maintenance Rescheduling Metrics6RSSHFTShift CodeCharacterUDC10
TOP17: Customer Service Management
36F3112Z2Warranty Claim/Supplier Recovery processing103WLSHFTShift CodeCharacterUDC10
37F4801TZ2Warranty Claim/Supplier Recovery processing18WQSHFTShift CodeCharacterUDC10
TOP18: Timecard Automation
38F186301Timecard Templates17TTSHFTShift CodeCharacterUDC10
39F186602Labor Rules Tag File46TFSHFTShift CodeCharacterUDC10
TOP30: Product Data Management
40F0007Z1Work Day Calendar Transaction File18SZSHFTShift CodeCharacterUDC10
41F3007Work Center Resource Units7WUSHFTShift CodeCharacterUDC10
42F3009TManufacturing Constants Tag File - Needed for upgrade7IASHFTShift CodeCharacterUDC10
TOP31: Shop Floor Control
43F30161Z1Inbound Kanban Card Detail17SZSHFTShift CodeCharacterUDC10
44F3109Line/Item Relationship Master13IPSHFTShift CodeCharacterUDC10
45F31091Schedule Quantity Detail8IQSHFTShift CodeCharacterUDC10
46F31091SSchedule Quantity Detail Purge8IQSHFTShift CodeCharacterUDC10
47F31122Work Order Time Transactions21WTSHFTShift CodeCharacterUDC10
48F31122SPurge Work Order Time Transactions21WTSHFTShift CodeCharacterUDC10
49F31122Z1Work Order Time Transactions Unedited Transaction Table34SZSHFTShift CodeCharacterUDC10
50F3112Z1Outbound Work Order Routings103SZSHFTShift CodeCharacterUDC10
51F3112Z1TOutbound Work Order Routings Tag Table - Needed for upgrade8SZSHFTShift CodeCharacterUDC10
52F3114Rate Schedule Transaction File5IQSHFTShift CodeCharacterUDC10
53F31UI006Line Scheduling Workbench - Work File7LSSHFTShift CodeCharacterUDC10
TOP40: Inventory/OP Base
54F3009Job Shop Manufacturing Constants35IASHFTShift CodeCharacterUDC10
TOP48: Work Order Processing
55F4801STPurge - Work Order Master Tag File5WASHFTShift CodeCharacterUDC10
56F4801TWork Order Master Tag File5WASHFTShift CodeCharacterUDC10
57F4801Z1Outbound Work Order Header151SYSHFTShift CodeCharacterUDC10
TOP48S: Service Billing
58F48S0618Payroll Reclassification Workfile34YTSHFTShift CodeCharacterUDC10
TOP49: Transportation Management
59F49040Vehicle Staff (Conversion from World File)6VSSHFTShift CodeCharacterUDC10
60F49041Depot/Vehicle Staff2VSSHFTShift CodeCharacterUDC10
61F4960Load Header17TMSHFTShift CodeCharacterUDC10
TOP54HS: Health & Safety Incident Mgt
62F54HS02Incident People33S2SHFTShift CodeCharacterUDC10
63F54HS02MIncident People Change History36I2SHFTShift CodeCharacterUDC10
TOP75Z: New Zealand
64F75Z0008New Zealand Special Rates7Z8SHFTShift CodeCharacterUDC10
TOP89: Conversion Programs
65F07186TPiece Rate History File8Y8SHFTShift CodeCharacterUDC10
66F07352TPiece Rate Stub Detail Tag File8Y2SHFTShift CodeCharacterUDC10
67F49090Work Day Calendar (Used for Table Conversions ONLY)7CZSHFTShift CodeCharacterUDC10
TOPF31: Lean Transactions
68FF31010Production Master File8EHSHFTShift CodeCharacterUDC10
69FF31011TransactionID Master File20EHSHFTShift CodeCharacterUDC10
70FF31011SPurge - TransactionID Master File20ERSHFTShift CodeCharacterUDC10
71FF31113Lean Transaction Labor Detail22LDSHFTShift CodeCharacterUDC10
72FF31113SPurge - Lean Transaction Labor Detail22LRSHFTShift CodeCharacterUDC10
TOPF34R: DFM Resource Management
73FF34R010Resource Design Master27RMSHFTShift CodeCharacterUDC10
74FF34R013Resource Simulation Demand Temp File7DTSHFTShift CodeCharacterUDC10
75FF34R014Resource Simulation Results Temp File5RTSHFTShift CodeCharacterUDC10
TOPF34S: DFM Production Sequencing
76FF34S002Daily Plan10DPSHFTShift CodeCharacterUDC10

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

TOPUDC 06 / SH (Shift Codes) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1 No Shift
2         1Days
3         2Second Shift
4         3Night Shift
5         4Holiday
6         GGraveyard
7         HHoliday
8         SStandard Shift 8 - 5