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

6 columns | Print definition?910 | JBLC | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F0618Employee Transaction History130YTJBLCContract Labor CategoryStringUDC60
TOP05T: Time Entry
2F06116Employee Transaction Detail File200YTJBLCContract Labor CategoryStringUDC60
3F06116Z1Employee Transactions - Batch File210VLJBLCContract Labor CategoryStringUDC60
4F06116Z2ESS Timecard History210VMJBLCContract Labor CategoryStringUDC60
TOP18: Resource Scheduling
5F186602Labor Rules Tag File204TFJBLCContract Labor CategoryStringUDC60
TOP48S: Service Billing
6F48S0618Payroll Reclassification Workfile130YTJBLCContract Labor CategoryStringUDC60

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

TOPUDC 06 / G (Job Type) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          .N
2    #ALLOCAllocated Tips recordN
3    #SUMM Summarized Tips recordN
4    0A-0  ControllerN
5    0A-1  Accounting ManagerN
6    0A-10 Purchasing AgentN
7    0A-2  Senior AccountantN
8    0A-3  Financial AnalystN
9    0A-4  AccountantN
10    0P-0  Finance DirectorN
11    0P-1  Asst Finance DirectorN
12    0P-2  Accounts Payable ClerkN
13    0P-3  Accounts Receivable ClerkN
14    1M-1  MIS ManagerN
15    1M-2  IT ManagerN
16    1M-3  System AnalystN
17    1M-4  Programmer AnalystN
18    1M-5  ProgrammerN
19    2H-1  Human Resources ManagerN
20    2H-2  Employment RepresentativeN
21    2H-3  Compensation SpecialistN
22    2H-4  Benefits SpecialistN
23    2H-5  EEO SpecialistN
24    2H-6  InstructorN
25    3P-1  Payroll ManagerN
26    3P-2  Payroll AdministratorN
27    4A-1  Administrative AssistantN
28    4A-2  SecretaryN
29    4A-3  ClerkN
30    50PE  Project EngineerN
31    50PM  Project ManagerN
32    50SU  SuperintendentN
33    5J-1  City ManagerN
34    5J-2  County SupervisorN
35    5J-3  Purchasing ManagerN
36    5J-4  Fire FighterN
37    5J-5  ElectricianN
38    5J-6  Junior EngineerN
39    5J-7  NurseN
40    5J-8  TeacherN
41    5J-9  JourneymanN
42    61    ForemanN
43    62    ForemanN
44    63    Equipment OperatorN
45    64    EngineerN
46    64-1  DesignerN
47    64-5  Spec TypistN
48    65    DraftspersonN
49    66    ElectricianN
50    67    ElectricianN
51    68    TechnicianN
52    69    DriverN
53    6G-1  City ManagerN
54    6G-2  Purchasing ManagerN
55    6G-3  County SupervisorN
56    6G-4  Fire FighterN
57    6G-5  NurseN
58    6S-1  Security SupervisorN
59    6S-3  Security ScreenerN
60    6S-5  Security GuardN
61    7H-0  Hotel ManagerN
62    7H-1  Waiter/WaitressN
63    7H-2  HostessN
64    7H-3  HousekeeperN
65    7H-4  Service Worker (Bell Stand)N
66    7H-5  BartenderN
67    7H-6  Bus personN
68    7H-7  ChefN
69    8M-1  Maintenance EngineerN
70    8M-2  Distribution ManagerN
71    8M-3  ClerkN
72    8P-1  Plant ManagerN
73    8P-2  ForemanN
74    8P-3  Lathe OperatorN
75    8P-4  Setup PersonN
76    8P-5  Production WorkerN
77    8P-6  QA InspectorN
78    8P-7  Press OperatorN
79    8R-1  Maintenance Mechanic JuniorN
80    8R-2  Maintenance Electrician App 2N
81    8R-3  Maintenance Instruc. JuniorN
82    999   OtherN
83    9S-1  Sales ManagementN
84    9S-2  Sales RepresentativeN
85    A0    Chief Executive OfficerN
86    A1    PresidentN
87    A2    Vice PresidentN
88    ADMASSAdministrative AssistantN
89    BOARD Board of DirectorsN
90    CC200 Corporate ControllerN
91    CLERK ClerkN
92    M1    ManagerN
93    M200  ManagerN
94    MX801 AdministradorN
95    MX802 Jefe de OperacionesN
96    MX803 Asistente AdministrativaN
97    MX804 SupervisorN
98    MX810 Tecnico EspecialistaN
99    MX811 ElectricistaN
100    MX812 MecanicoN
101    MX813 Trabajos GeneralesN
102    MX820 Operario - EventualesN
103    PB-1  Planner/BuyerN
104    PRES  PresidentN
105    PROG  Associate ProgrammerN
106    PROGRAProgrammerN
107    SALREPSales RepresentativeN
108    SECRE SecretaryN
109    TRN1  TrainerN
110    TRNER TrainerN
111    TYPISTTypistN
112    VICPREVice PresidentN