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
9F0006MCBusiness Unit Master
10F03012AICustomer Master by Line of Business

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
4F0411RPAccounts Payable Ledger
5F4311PDPurchase Order Detail File
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

57 columns | Print definition?910 | PTAX | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F0627Workers Compensation Summary History3JHPTAXTax TypeStringUDC20
2F069016Payroll Tax Area Profile4YPPTAXTax TypeStringUDC20
3F069016TPayroll Tax Area Profile - Tag File2YPPTAXTax TypeStringUDC20
4F069086Payroll Corporate Tax Identification3YIPTAXTax TypeStringUDC20
5F069117Tax Authority Tax Exemption File2YBPTAXTax TypeStringUDC20
6F069226Unemployment Insurance Rates3YHPTAXTax TypeStringUDC20
7F06926Tax Area/ Vendor Cross Reference2Y#PTAXTax TypeStringUDC20
TOP05A: OW HR & PR Foundation
8F06345Historical Payroll Register30JLPTAXTax TypeStringUDC20
TOP05T: Time Entry
9F0624Burden Distribution File4J#PTAXTax TypeStringUDC20
10F06241Burden Distribution File4J#PTAXTax TypeStringUDC20
TOP06: Payroll (old) - Obsolete-do not reuse
11F06017Employee Tax Exceptions/Overrides8YAPTAXTax TypeStringUDC20
TOP07: Payroll
12F06136Tax History4YZPTAXTax TypeStringUDC20
13F06136ATax Summary (Additional)4YZPTAXTax TypeStringUDC20
14F06136BTax Summary (PA ACT 32)4YZPTAXTax TypeStringUDC20
15F06166Pay Check History Tax Ledger5YVPTAXTax TypeStringUDC20
16F06166ATax Ledger (Additional)5YVPTAXTax TypeStringUDC20
17F06166BTax Ledger (PA ACT 32)5YVPTAXTax TypeStringUDC20
18F06350IWF - Paycheck (Interims)31Y4PTAXTax TypeStringUDC20
19F06490Payroll/Accounts Payable Ledger Detail13JRPTAXTax TypeStringUDC20
20F068500941 - Federal Tax History3YZPTAXTax TypeStringUDC20
21F0701731Compensation Overrides2YCPTAXTax TypeStringUDC20
22F0701732Additional Tax Overrides3AOPTAXTax TypeStringUDC20
23F0701734Prior Head Tax from a Previous Employer4Y3PTAXTax TypeStringUDC20
24F0701735Pretax Deduction Overrides2YCPTAXTax TypeStringUDC20
25F07186Stub Information History Table11Y8PTAXTax TypeStringUDC20
26F0724Burden Distribution File7YSPTAXTax TypeStringUDC20
27F07241Burden Distribution File7YSPTAXTax TypeStringUDC20
28F07352Stub Information File11Y2PTAXTax TypeStringUDC20
29F07353Tax Detail File4Y3PTAXTax TypeStringUDC20
30F07490Payroll - Accounts Payable Detail (One World)12JRPTAXTax TypeStringUDC20
31F077011Tax History Integrity (Temp)9Y$PTAXTax TypeStringUDC20
32F077011ATax History Integrity Additional (Temp)9Y$PTAXTax TypeStringUDC20
33F077011BTax Integrity (PA Act32)9Y3PTAXTax TypeStringUDC20
34F07811Negative Amount Workfile7JEPTAXTax TypeStringUDC20
35F07824Company State/Local Control Table10JDPTAXTax TypeStringUDC20
36F07831Employee State/Local Control Table10YBPTAXTax TypeStringUDC20
37F078504Vertex Geo Code to ADP Code3VAPTAXTax TypeStringUDC20
38F07940Set Vertex Tax Table1YYPTAXTax TypeStringUDC20
39F07992Payroll Tax History Conversion Data4YQPTAXTax TypeStringUDC20
TOP08: Human Resources
40F083303Benefit Statement Cross Reference Detail6CRPTAXTax TypeStringUDC20
TOP08AD: ADP Integration
41F051374ADP Employee Tax Withholding/Override Instructions10ADPTAXTax TypeStringUDC20
TOP48S: Service Billing
42F4812Billing Detail Workfile37WDPTAXTax TypeStringUDC20
43F4812HBilling Workfile History37WDPTAXTax TypeStringUDC20
44F4812HSBilling Workfile History Purged Save37WDPTAXTax TypeStringUDC20
45F48SUI01Billing Detail Print Workfile37WDPTAXTax TypeStringUDC20
TOP52: Contract Billing
46F5214Component Code/Burden Cross Reference Table9A4PTAXTax TypeStringUDC20
47F5215Component/Burden Billing Line Cross Reference Details11A5PTAXTax TypeStringUDC20
TOP75A: Australia - Reporting System Only
48F75A0003Australia/New Zealand tax calculation rules21ZRPTAXTax TypeStringUDC20
49F75A0500AU Bonus and Back Pay Tax Workfile6BPPTAXTax TypeStringUDC20
50F75A0501AU Bonus and Back Pay Tax History6THPTAXTax TypeStringUDC20
TOP75Z: New Zealand - Reporting System Only
51F75Z0009New Zealand Tax Detail Work File4TXPTAXTax TypeStringUDC20
52F75Z0010New Zealand Tax Detail Tag Table4TDPTAXTax TypeStringUDC20
TOP77: Payroll (Canadian)
53F06176Unemployment Insurance History File12YSPTAXTax TypeStringUDC20
54F0713Tax History4YZPTAXTax TypeStringUDC20
55F0713SAVBackup Copy of F0713 For Tax Ledger Repost4YZPTAXTax TypeStringUDC20
56F0716Pay Check History Tax Ledger - Canadian DB5YVPTAXTax TypeStringUDC20
57F77703Payroll History Audit Report - Worktable4ARPTAXTax TypeStringUDC20

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

TOPUDC 06 / TX (Payroll Taxes) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          DefaultN
2        #PPERS Group CodeN
3        #WWithholding TaxY
4        $HAccumulate Dollars & HoursN
5        $OAccumulate Dollars OnlyN
6        $UDo Not Accumulate Hrs or $N
7        * Non-TaxableN
8        *FNon-Taxable - SITN
9        *LNon-Taxable - CountyN
10        *MNon-Taxable - CityN
11        *NNon-Taxable - SchoolN
12        0 Not Assigned to Tax InputN
13        1 Assigned to Tax InputN
14        A Federal Income TaxN
15        B Earned Income Credit (EIC)N
16        B1State Earned Income CreditY
17        C Federal UnemploymentN
18        CACanada Federal Income TaxN
19        CBCanadian Pension Plan - empleeN
20        CCCanada Employ Ins. - empl'eeN
21        CDCanada Employ Ins. - empl'erN
22        CECanadian Pension Plan - emplyrN
23        CFProvincial Income TaxN
24        CGQuebec Provincial Plan EEN
25        CHQuebec Provincial Pension CO.N
26        CIExempt Hours - EI Exempt HoursN
27        CJProvincial Parental InsuranceY
28        CKProvincial Parental InsuranceY
29        D Social Security WithheldN
30        DTTip FICA W/HN
31        E Social Security PaidN
32        ETTip FICA Pd.N
33        EXExtra EmolumentN
34        F State Income TaxN
35        G State UnemploymentN
36        H State Unemployment (SUI)N
37        I State Disability (SDI)N
38        IVVoluntary Dis. (VDI)N
39        J State Disability (SDI)N
40        JVVoluntary Dis. (VDI)N
41        K Occupational Head TaxN
42        KPOccupational Head TaxY
43        L County Income TaxN
44        LALump Sum - AN
45        LBLump Sum - BN
46        LCLump Sum - CN
47        LDLump Sum - DY
48        LELump Sum - EY
49        LRCounty MCTMTY
50        M City Income TaxN
51        MHMental Health TaxY
52        MWMinimum WageY
53        N School TaxN
54        NHSchool District Head TaxY
55        O Supplemental Railroad TaxN
56        P Medicare WithheldN
57        PTTip Medicare WithheldN
58        Q Medicare PaidN
59        R Tier I WithheldN
60        RBTax RebateN
61        S Tier I PaidN
62        SLStudent LoanN
63        STState Payroll TaxN
64        T Tier II WithheldN
65        U Tier II PaidN
66        V Tier III - RURTN
67        W Workers Compensation Ins.N
68        X RUIA - Unemployment Ins.N
69        Y Property Damage/Bodily InjuryN
70        Z Weeks WorkedN