JDE TABLES

JD Edwards Enterprise One table definition reference

www.jdetables.com

Implementation Guides | 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
9F4801WAWork Order Master File
10F42119SDSales Order History File
PHPRef.com - the webs number one PHP Function reference tool

105 columns | Print definition?812 | JBST | STOCK UDC

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