JD Edwards Enterprise One table definition reference


Implementation Guides |  920 VMs | Schema:
920 910 812
System  Table 

JDE Ref icon of database logic symbolJDE TABLESv3Made in Britain

SAPTables.Net - the webs number one SAP Tables Definition reference

920: Top 10 requests

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

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

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

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