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
3F0411RPAccounts Payable Ledger
4F4211SDSales Order Detail File
5F4311PDPurchase Order Detail File
6F0006MCBusiness Unit Master
7F0902GBAccount Balances
8F42119SDSales Order History File
9F03012AICustomer Master by Line of Business
10F4801WAWork Order Master File
PHPRef.com - the webs number one PHP Function reference tool

18 columns | Print definition?910 | SCOD | STOCK UDC

TableTable DescriptionColumn#PrefixAliasColumn DescriptionData TypeEdit TypeLengthDecimals
TOP05: Time Accounting and HRM Base
1F069016Payroll Tax Area Profile5YPSCODStatutory CodeStringUDC30
TOP07: Payroll
2F06136Tax History5YZSCODStatutory CodeStringUDC30
3F06136ATax Summary (Additional)11YZSCODStatutory CodeStringUDC30
4F06166Pay Check History Tax Ledger6YVSCODStatutory CodeStringUDC30
5F06166ATax Ledger (Additional)13YVSCODStatutory CodeStringUDC30
6F07212Paystub Retro Pay State Setup1Y2SCODStatutory CodeStringUDC30
7F074001New Hire Reporting Workfile - OneWorld Only45NHSCODStatutory CodeStringUDC30
8F074001RNew Hire Report Setup - OneWorld Only1NHSCODStatutory CodeStringUDC30
9F074001WSUI/New Hire Client loader for F074001R1NHSCODStatutory CodeStringUDC30
10F07500Geocoder Report Setup1GCSCODStatutory CodeStringUDC30
11F07824Company State/Local Control Table11JDSCODStatutory CodeStringUDC30
12F07831Employee State/Local Control Table19YBSCODStatutory CodeStringUDC30
13F078602State Mag Media Table5RSSCODStatutory CodeStringUDC30
14F07880SUI Magnetic Media Workfile19YWSCODStatutory CodeStringUDC30
15F8907427New Hire Detail File - Montana (27)54MTSCODStatutory CodeStringUDC30
TOP77: Payroll (Canadian)
16F0713Tax History5YZSCODStatutory CodeStringUDC30
17F0713SAVBackup Copy of F0713 For Tax Ledger Repost5YZSCODStatutory CodeStringUDC30
18F0716Pay Check History Tax Ledger - Canadian DB6YVSCODStatutory CodeStringUDC30

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

TOPUDC 06 / SC (Statutory Code) stock values

ValueDescriptionSpecial Handling CodeHard Coded
1          Federal (and default)N
2       *ARAdditional Local Residence TaxN
3       *ATAdditional Tax (Canada)N
4       *CCChild Care Deduction (Canada)N
5       *CROverride CPP Rate (Canada)N
6       *CXCPP Exemption (Canada)N
7       *FRFederal Override Rate (Canada)N
8       *FSFederal Supplemental OverrideN
9       *K3Additional Tax Credits(Canada)N
10       *NCNet Tax Credit Equival(Canada)N
11       *PAAdd'l Province Inc Tax(Canada)N
12       *PDProvincial Deduction (Canada)N
13       *PRProv. Override Rate (Canada)N
14       *PXProv. Add'l Deduction (Canada)N
15       *RDResidential Deduction (Canada)N
16       *SSState Supplemental OverrideN
17       31 Home State - New YorkN
18       AB AlbertaN
19       AK AlaskaN
20       AL AlabamaN
21       AR ArkansasN
22       ATHAL, AthensN
23       AZ ArizonaN
24       BC British ColumbiaN
25       BEDOhio, BethesdaN
26       BEOBethalN
27       BTHBethesdaN
28       CA CaliforniaN
29       CANOhio, CantonN
30       CN CanadaY
31       CO ColoradoN
32       COLOhio Columbus City Income TaxN
33       CT ConnecticutN
34       D  Denver City TaxN
35       DALTexas, DallasN
36       DC Dist. of ColumbiaN
37       DE DelawareN
38       DENColorado, DenverN
39       DETDetroitN
40       E  Denver City TaxN
41       FL FloridaN
42       FTWKentucky, Fort WrightN
43       GA GeorgiaN
44       GRNOhio, GreenvilleN
45       GWVGreen wood villageN
46       HI HawaiiN
47       HO Tx, HoustonN
48       IA IowaN
49       ID IdahoN
50       IL IllinoisN
51       IN IndianaN
52       INMIn, MarionN
53       KANKansas City, KansasN
54       KCJMissouri, K C Jackson CountyN
55       KCMMissouri, Kansas CityN
56       KENKentucky, Green CountyN
57       KS KansasN
58       KY KentuckyN
59       KYBKentucky, Bowling GreenN
60       KYCKentucky CountyN
61       LA LouisianaN
62       LATKansas, City of LathamN
63       LAXCalifornia, Los AngelesN
64       LB LabradorN
65       LEXKentucky, LexingtonN
66       MA MassachusettsN
67       MB ManitobaN
68       MD MarylandN
69       ME MaineN
70       MI MichiganN
71       MN MinnesotaN
72       MNTMontgomery CountyN
73       MO MissouriN
74       MS MississippiN
75       MT MontanaN
76       NB New BrunswickN
77       NBCCa, Newport BeachN
78       NC North CarolinaN
79       ND North DakotaN
80       NE NebraskaN
81       NF NewfoundlandN
82       NH New HampshireN
83       NJ New JerseyN
84       NL NewfoundlandY
85       NM New MexicoN
86       NS Nova ScotiaN
87       NT Northwest TerritoryN
88       NU NunavutY
89       NV NevadaN
90       NY New YorkN
91       NYCNew York CityN
92       NYLNY overrideN
93       OH OhioN
94       OHAOhio - Aberdeen CountyN
95       OHBOhio - Brown CountyN
96       OK OklahomaN
97       ON OntarioN
98       OR OregonN
99       P01PPIP Tax Rate CodeY
100       PA PennsylvaniaN
101       PACPenn. CityN
102       PADPaducah, KentuckyN
103       PANPenn School TaxN
104       PAOPennsylvania Occ TaxN
105       PE Prince Edward IslandN
106       PR Puerto RicoN
107       QC QuebecN
108       RI Rhode IslandN
109       SC South CarolinaN
110       SD South DakotaN
111       SF Ca, San MateoN
112       SK SaskatchewanN
113       STLMissouri, St LouisN
114       TN TennesseeN
115       TU Ok , TulsaN
116       TX TexasN
117       U01Ca. EI Rate - PrimaryN
118       U02Ca. EI Rate - SecondaryN
119       UT UtahN
120       VA VirginiaN
121       VT VermontN
122       WA WashingtonN
123       WI WisconsinN
124       WINIndiana, Winchester CountyN
125       WV West VirginiaN
126       WY WyomingN
127       YRKPA, City Of YorkN
128       YT Yukon TerritoryN
129       ZZ Other AreasN