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
10F07831YBEmployee State/Local Control Table

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F4211SDSales Order Detail File
4F4311PDPurchase Order Detail File
5F0411RPAccounts Payable Ledger
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F03012AICustomer Master by Line of Business
9F42119SDSales Order History File
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

117 columns | Print definition?920 | JBST | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP00: Foundation Environment
1F0911Account Ledger91GLJBSTJob StepStringUDC40
TOP05: Time Accounting and HRM Base
2F050116WEmployee Master Integrations Work File8EMJBSTJob StepStringUDC40
3F05102Goal Master14SMJBSTJob StepStringUDC40
4F05105Goal Suggestions13GSJBSTJob StepStringUDC40
5F0609Deduction/Benefit/Accrual Ledger File19Y$JBSTJob StepStringUDC40
6F06106Employee Pay Instructions59YMJBSTJob StepStringUDC40
7F0618Employee Transaction History44YTJBSTJob StepStringUDC40
8F0619Benefit/Accrual Detail File19Y$JBSTJob StepStringUDC40
9F0625Change Code History File3JBJBSTJob StepStringUDC40
10F06251Step Progression Rate History File5JBJBSTJob StepStringUDC40
11F069106Union Benefits Master3Y1JBSTJob StepStringUDC40
12F069126Union Rates File6YLJBSTJob StepStringUDC40
13F0691261Additional Union Rates6YLJBSTJob StepStringUDC40
14F06915Holiday Table16JHJBSTJob StepStringUDC40
15F069150DBA Group Plan Group Limit Overrides4Y1JBSTJob StepStringUDC40
16F069162Job Type/ Item Cross Reference File2JHJBSTJob StepStringUDC40
17F06923Valid Job Type/ Step Constant3YHJBSTJob StepStringUDC40
18F06925Employee/Vendor Cross Reference4YGJBSTJob StepStringUDC40
19F06936Retro Pay Types Rate7JAJBSTJob StepStringUDC40
20F0709Deduction/Benefit/Accrual Ledger File24Y$JBSTJob StepStringUDC40
TOP05A: PeopleSoft HR & PR Foundation
21F060116Employee Master Information33YAJBSTJob StepStringUDC40
22F0601161Point-In-Time Employee Master35PTJBSTJob StepStringUDC40
23F060116WEE Master Request File33YAJBSTJob StepStringUDC40
24F060116ZUnedited Quick Hire Transaction File26SZJBSTJob StepStringUDC40
25F060119Employee Jobs History File4YEJBSTJob StepStringUDC40
26F06345Historical Payroll Register12JLJBSTJob StepStringUDC40
TOP05T: Time Entry
27F06022Employee Piecerate File20JAJBSTJob StepStringUDC40
28F06116Employee Transaction Detail File44YTJBSTJob StepStringUDC40
29F06116Z1Employee Transactions - Batch File56VLJBSTJob StepStringUDC40
30F06116Z2ESS Timecard History56VMJBSTJob StepStringUDC40
31F06278Retro Timecard Detail File42YTJBSTJob StepStringUDC40
32F06290Payroll Accounting Journal Work File19YRJBSTJob StepStringUDC40
33F063951Payroll Journal (Compressed) File28GLJBSTJob StepStringUDC40
34F06904Automatic Accounting Instructions20Y#JBSTJob StepStringUDC40
35F069136Tip Disbursement17JEJBSTJob StepStringUDC40
36F06918PF - Piece Rate File4JNJBSTJob StepStringUDC40
37F06932Classification/Pay Cross Reference2J4JBSTJob StepStringUDC40
TOP06: Payroll (old) - Obsolete-do not reuse
38F060118Employee Jobs4YEJBSTJob StepStringUDC40
39F060146Employees Pay Rate File5JIJBSTJob StepStringUDC40
TOP07: Payroll
40F05290WF - Payroll Journal (Detail)28JRJBSTJob StepStringUDC40
41F06270Retro Processing Parameter45JPJBSTJob StepStringUDC40
42F063106Deduction/Benefit Work File10Y7JBSTJob StepStringUDC40
43F07100CCQ WORKFILE5F7JBSTJob StepStringUDC40
44F0716701Employee Assignment T/E Template Information5EAJBSTJob StepStringUDC40
45F0716709Employee Assignment T/E Template Info History5EAJBSTJob StepStringUDC40
46F0717ROE Summary History41JFJBSTJob StepStringUDC40
47F071861Stub Detail Piece Rate History File7Y8JBSTJob StepStringUDC40
48F0719DBA Transaction Detail History24Y$JBSTJob StepStringUDC40
49F0729Employee DBA Override Instructions72Y9JBSTJob StepStringUDC40
50F073521Stub Detail Piece Rate File7Y2JBSTJob StepStringUDC40
51F07355Pre-Payroll Error File22Y5JBSTJob StepStringUDC40
52F074001New Hire Reporting Workfile - OneWorld Only82NHJBSTJob StepStringUDC40
53F07850Group Fund Setup7FGJBSTJob StepStringUDC40
54F07UI200Timecard History Work File47THJBSTJob StepStringUDC40
TOP08: Human Resources
55F0800601Organizational Business Unit/Job Cross-Reference3JCJBSTJob StepStringUDC40
56F0800605Job Type/Step Competencies2JCJBSTJob StepStringUDC40
57F0800609Gap Analysis Snapshot9YIJBSTJob StepStringUDC40
58F0800610Competencies in Structure and Job3JCJBSTJob StepStringUDC40
59F0800612User Defined Job Competency Description Reference10JCJBSTJob StepStringUDC40
60F08006WFJob Competency Default Overrides Work File8JCJBSTJob StepStringUDC40
61F08092Human Resources General Description-User Def Codes5JZJBSTJob StepStringUDC40
62F08093Human Resources General Description - Narration5JYJBSTJob StepStringUDC40
63F081161ACA Employee Eligibility27ADJBSTJob StepStringUDC40
64F0811619ACA Employee Eligibility Archive27ADJBSTJob StepStringUDC40
65F082003Grade/Step Progression Detail File6YWJBSTJob StepStringUDC40
66F083305Mail Merge Header/Detail23MMJBSTJob StepStringUDC40
67F087101Default Setup Tasks2DTJBSTJob StepStringUDC40
68F087711CBPA Appraisal Header16XJJBSTJob StepStringUDC40
69F08JDWF1Job Description Changes Integration Work File8JCJBSTJob StepStringUDC40
70F08JDWF2Job Description History Integration Work File4JHJBSTJob StepStringUDC40
TOP08AD: ADP Integration
71F051371ADP Employee DBA Instructions64ADJBSTJob StepStringUDC40
72F051372ADP Employee Job Master Information9ADJBSTJob StepStringUDC40
TOP08B: Benefits Administration
73F0833WFBenefit Statement Work file20WFJBSTJob StepStringUDC40
TOP08H: Health and Safety
74F08601Injury/Illness Case Master6HLJBSTJob StepStringUDC40
TOP08P: Position Control
75F08001Job information3JMJBSTJob StepStringUDC40
76F08005Business Unit/ Job Id. X-Ref3JVJBSTJob StepStringUDC40
77F08101Position Master15HPJBSTJob StepStringUDC40
78F08101PPurge - Position Master15HPJBSTJob StepStringUDC40
79F08111Position Budget Detail9HQJBSTJob StepStringUDC40
80F08111PPurge - Position Budget Detail9HQJBSTJob StepStringUDC40
TOP08R: Recruitment Management - (Appl. Track. & Req.)
81F08102Requisition Information14HNJBSTJob StepStringUDC40
82F08401Applicant Master8HAJBSTJob StepStringUDC40
83F08401WFApplicant Work File9XNJBSTJob StepStringUDC40
TOP08U: PeopleSoft HR US
84F08910COBRA Qualified Beneficiary File30J1JBSTJob StepStringUDC40
85F08920COBRA Coverage9JSJBSTJob StepStringUDC40
TOP08W: Wage and Salary
86F08201Salary Review Workfile16HRJBSTJob StepStringUDC40
87F08830WFCompensation Root Work Table32YNJBSTJob StepStringUDC40
TOP09: General Accounting
88F0911PPurge - Account Ledger91GLJBSTJob StepStringUDC40
89F0911Z1Journal Entry Transactions - Batch File108VNJBSTJob StepStringUDC40
90F0911Z4F0911 Interoperability Table113SZJBSTJob StepStringUDC40
91F09123Advanced Variable Numerator59VNJBSTJob StepStringUDC40
92F09UI015Indexed Computations Multi-Tiered Entries91GLJBSTJob StepStringUDC40
93F52G11Burdening Detail Ledger32BDJBSTJob StepStringUDC40
94F52G11WFTemporary Burdened Detail Ledger Workfile32BWJBSTJob StepStringUDC40
TOP12: Fixed Assets
95F1201Asset Master File84FAJBSTJob StepStringUDC40
96F1201PAsset Master Purge Table84FAJBSTJob StepStringUDC40
97F1201Z1Unedited Asset Master Transactions95FAJBSTJob StepStringUDC40
TOP18: Timecard Automation
98F186301Timecard Templates26TTJBSTJob StepStringUDC40
99F186602Labor Rules Tag File55TFJBSTJob StepStringUDC40
TOP42: Sales Management
100F42800G1Sales Update G Batch Detail Workfile77DGJBSTJob StepStringUDC40
TOP48S: Service Billing
101F48096Billing Rate / Mark up Table11WQJBSTJob StepStringUDC40
102F4812Billing Detail Workfile35WDJBSTJob StepStringUDC40
103F4812HBilling Workfile History35WDJBSTJob StepStringUDC40
104F4812HSBilling Workfile History Purged Save35WDJBSTJob StepStringUDC40
105F48S0618Payroll Reclassification Workfile44YTJBSTJob StepStringUDC40
106F48S910Billing Detail Journal Workfile49W2JBSTJob StepStringUDC40
107F48S911Summarized Journal Workfile40W3JBSTJob StepStringUDC40
108F48SUI01Billing Detail Print Workfile35WDJBSTJob StepStringUDC40
TOP52: Contract Billing
109F5212T and M, Unit Price and Lumpsum Cross Reference Accounts14G5JBSTJob StepStringUDC40
TOP52G: Proj & Gov Contract Accounting
110F52G21Contract Specific Labor Category Cross Reference14LRJBSTJob StepStringUDC40
111F52G90Invoice Printing Work Table44WTJBSTJob StepStringUDC40
TOP54HS: Health & Safety Incident Mgt
112F54HS02Incident People23S2JBSTJob StepStringUDC40
113F54HS02MIncident People Change History26I2JBSTJob StepStringUDC40
TOP75Z: New Zealand
114F75Z0008New Zealand Special Rates6Z8JBSTJob StepStringUDC40
TOP77: Payroll (Canadian)
115F07183Commission History Detail File12ZBJBSTJob StepStringUDC40
TOP89: Conversion Programs
116F07186TPiece Rate History File7Y8JBSTJob StepStringUDC40
117F07352TPiece Rate Stub Detail Tag File7Y2JBSTJob StepStringUDC40

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

TOPUDC 06 / GS (Job Step) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1  . N
2      1Level I (Entry Level) N
3      2Level II N
4      3Level III N
5      4Level IV N
6      5Level V N
7      9Level IX N
8      AApprentice N
9      A.1Apprentice 1 N
10      A.2Apprentice 2 N
11      A.3Apprentice 3 N
12      ARMArmed N
13      ARMNNot armed N
14      FOREForeman N
15      JJourneyman N
16      JRJunior N
17      MMaster N
18      PRPrincipal in charge N
19      SRSenior N