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
10F4111ILItem Ledger File

812: Top 10 requests

TablePrefixDescription
1F0911GLAccount Ledger
2F0101ABAddress Book Master
3F0411RPAccounts Payable Ledger
4F4311PDPurchase Order Detail File
5F4211SDSales 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
05A: PeopleSoft HR & PR Foundation
SchemaTablePrefixColumnsIndexesDescriptionTypeReportCategory
1920F0601161PT2131Point-In-Time Employee MasterHistory Files05A: PeopleSoft HR & PR FoundationBusiness Data
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns. For Create statements, use Allow Null checkboxes and default values inputs to tailor query as required.

SELECT PTEFTO, PTSVER, PTAN8, PTALPH, PTSSN, PTOEMP, PTSEX, PTMSTX, PTMSTI, PTWSPS, PTEIC, PTNDEP, PTEST, PTECNT, PTTARR, PTTARA, PTSCDC, PTHMST, PTWKSE, PTHMLC, PTLWK1, PTLWK2, PTHMCO, PTMCU, PTHMCU, PTSG, PTMAIL, PTPAST, PTPFRQ, PTSALY, PTPYCB, PTBCB, PTUN, PTJBCD, PTJBST, PTEEOJ, PTEEOM, PTTRS, PTWCMP, PTFLSA, PTWS, PTSHFT, PTLMTH, PTPBRT, PTLF, PTSAL, PTPHRT, PTPPRT, PTPWRN, PTHRTN, PTBRTN, PTSALN, PTSTDH, PTSTDD, PTSDYY, PTUSR, PTUFLG, PTNS, PTIFN, PTIMN, PTDOB, PTDSI, PTDT, PTDST, PTPSDT, PTPTDT, PTNRDT, PTNBDT, PTNPDT, PTLCDT, PTDR, PTCTDT, PTLADT, PTBSDT, PTCPDT, PTFICM, PTP001, PTP002, PTP003, PTP004, PTP005, PTP006, PTP007, PTP008, PTP009, PTP010, PTP011, PTP012, PTP013, PTP014, PTP015, PTP016, PTP017, PTP018, PTP019, PTP020, PTE001, PTE002, PTE003, PTE004, PTE005, PTE006, PTE007, PTE008, PTE009, PTE010, PTICC, PTNMAX, PTSOCC, PTIUSR, PTITRM, PTINBT, PTREGN, PTPSTP, PTIH, PTCCPR, PTADPN, PTTCNF, PTRAF, PTTIPE, PTRCCD, PTBDRT, PTBORN, PTNBDR, PTWET, PTAFLG, PTRMST, PTLMST, PTSMKR, PTCBAC, PTCBAF, PTPCCD, PTRCDT, PTLSDT, PTPADT, PTPYMH, PTUYST, PTDTSP, PTANN8, PTPPNB, PTPYDT, PTCBEN, PTDOBM, PTDSTM, PTPSAL, PTHIPN, PTCM, PTLSAL, PTDIVC, PTVSHF, PTPYRV, PTANPA, PTPGRD, PTPGRS, PTSLOC, PTNRVW, PTTINC, PTHM01, PTHM02, PTHM03, PTHM04, PTPOS, PTED01, PTED02, PTED03, PTED04, PTED05, PTED06, PTED07, PTED08, PTED09, PTED10, PTED11, PTED12, PTED13, PTED14, PTED15, PTED16, PTED17, PTED18, PTED19, PTED20, PTDEPT, PTFAGE, PTFSAL, PTADSD, PTCMPA, PTEPNT, PTJOBN, PTUSER, PTPID, PTUPMJ, PTK001, PTK002, PTK003, PTK004, PTK005, PTK006, PTK007, PTK008, PTK009, PTK010, PTATPY, PTPENS, PTORG, PTBENS, PTFTE, PTAAF, PTSUI, PTDTSF, PTSMOY, PTLDID, PTTTAR FROM F0601161

TOP920 | 05A | F0601161 COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1PTEFTODate - Effective OnDateGeneric Edit60
2PTSVERSnapshot VersionStringGeneric Edit100 Allow NULL? 
3PTAN8Address NumberNumericGeneric Edit80 Allow NULL? 
4PTALPHName - AlphaStringGeneric Edit400 Allow NULL? 
5PTSSNEmployee Tax IDStringGeneric Edit200 Allow NULL? 
6PTOEMPAdditional Employee NoStringGeneric Edit80 Allow NULL? 
7PTSEXGender (Male/Female)CharacterUDC (07 SG)10 Allow NULL? 
8PTMSTXMarital Status - TaxCharacterUDC (06 MS)10 Allow NULL? 
9PTMSTIMarital Status - State TaxCharacterUDC (06 MS)10 Allow NULL? 
10PTWSPSResidency StatusCharacterUDC (05 WS)10 Allow NULL? 
11PTEICEarned Income Credit StatusCharacterUDC (05 EI)10 Allow NULL? 
12PTNDEPDependentsNumericGeneric Edit20 Allow NULL? 
13PTESTEmployment StatusCharacterUDC (06 ES)10 Allow NULL? 
14PTECNTEmployee Classification StatusCharacterUDC (05A EC)10 Allow NULL? 
15PTTARRTax Area (Residence)StringGeneric Edit100 Allow NULL? 
16PTTARATax Area (Work)StringGeneric Edit100 Allow NULL? 
17PTSCDCSchool District CodeNumericUDC (07 SS)50 Allow NULL? 
18PTHMSTState - HomeStringUDC (06 SC)30 Allow NULL? 
19PTWKSEState - WorkingStringUDC (06 SC)30 Allow NULL? 
20PTHMLCLocation - Home CityStringUDC (06 W1)30 Allow NULL? 
21PTLWK1Location - Work CityStringUDC (06 W1)30 Allow NULL? 
22PTLWK2Location - Work CountyStringUDC (06 W2)30 Allow NULL? 
23PTHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
24PTMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
25PTHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
26PTSGLast Job WorkedStringGeneric Edit120 Allow NULL? 
27PTMAILRouting Code - CheckStringUDC (06 CR)100 Allow NULL? 
28PTPASTEmployee Pay StatusCharacterUDC (06 PS)10 Allow NULL? 
29PTPFRQPay FrequencyCharacterUDC (06 PF)10 Allow NULL? 
30PTSALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
31PTPYCBPay Cycle Bypass CountNumericGeneric Edit20 Allow NULL? 
32PTBCBBenefit Cycle Bypass CountNumericGeneric Edit20 Allow NULL? 
33PTUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
34PTJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
35PTJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
36PTEEOJJob Category (EEO)StringUDC (06 J)30 Allow NULL? 
37PTEEOMEthnic CodeStringUDC (06 M)20 Allow NULL? 
38PTTRSChange ReasonStringUDC (06 T)30 Allow NULL? 
39PTWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
40PTFLSAFLSA Exempt Y/NCharacterUDC (05 FL)10 Allow NULL? 
41PTWSWork Schedule CodeCharacterUDC (05A WS)10 Allow NULL? 
42PTSHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
43PTLMTHLabor Distribution MethodCharacterUDC (07 LT)10 Allow NULL? 
44PTPBRTRate - Distribution (or Billing)NumericGeneric Edit93 Allow NULL? 
45PTLFLabor Distribution MultiplierNumericGeneric Edit54 Allow NULL? 
46PTSALRate - Salary AnnualNumericGeneric Edit112 Allow NULL? 
47PTPHRTRate - HourlyNumericGeneric Edit93 Allow NULL? 
48PTPPRTRate - PieceworkNumericGeneric Edit93 Allow NULL? 
49PTPWRNRate (Piecework)at Next RaiseNumericGeneric Edit93 Allow NULL? 
50PTHRTNRate (Hourly) at Next RaiseNumericGeneric Edit93 Allow NULL? 
51PTBRTNRate (Billing) at Next RaiseNumericGeneric Edit93 Allow NULL? 
52PTSALNRate - Salary at Next RaiseNumericGeneric Edit112 Allow NULL? 
53PTSTDHHours - Standard per PayperiodNumericGeneric Edit52 Allow NULL? 
54PTSTDDHours - Standard per DayNumericGeneric Edit52 Allow NULL? 
55PTSDYYDays - Standard per YearNumericGeneric Edit52 Allow NULL? 
56PTUSRPayroll Lockout IdentificationStringGeneric Edit180 Allow NULL? 
57PTUFLGUpdate FlagCharacterGeneric Edit10 Allow NULL? 
58PTNSWork Tax Area SourceCharacterUDC (05 NS)10 Allow NULL? 
59PTIFNInitial - First Name (Govt Rpts)CharacterGeneric Edit10 Allow NULL? 
60PTIMNInitial - Middle Name (Govt Rpts)CharacterGeneric Edit10 Allow NULL? 
61PTDOBDate - BirthDateGeneric Edit60
62PTDSIDate - Original EmploymentDateGeneric Edit60
63PTDTDate - TerminatedDateGeneric Edit60
64PTDSTDate StartedDateGeneric Edit60
65PTPSDTDate - Pay StartsDateGeneric Edit60
66PTPTDTDate - Pay StopsDateGeneric Edit60
67PTNRDTDate - Next RaiseDateGeneric Edit60
68PTNBDTDate - New Bill RateDateGeneric Edit60
69PTNPDTDate - New PiecerateDateGeneric Edit60
70PTLCDTDate - Last CheckDateGeneric Edit60
71PTDRDate - Last RaiseDateGeneric Edit60
72PTCTDTDate - Last ContactDateGeneric Edit60
73PTLADTDate - LOA Expiration DateDateGeneric Edit60
74PTBSDTDate - BonusDateGeneric Edit60
75PTCPDTDate - Current PositionDateGeneric Edit60
76PTFICMTax Calc MethodCharacterUDC (06 TM)10 Allow NULL? 
77PTP001Category Codes - Payroll1StringUDC (06 01)30 Allow NULL? 
78PTP002Category Codes - Payroll2StringUDC (06 02)30 Allow NULL? 
79PTP003Category Codes - Payroll3StringUDC (06 03)30 Allow NULL? 
80PTP004Category Codes - Payroll4StringUDC (06 04)30 Allow NULL? 
81PTP005Category Codes - Payroll5StringUDC (06 05)30 Allow NULL? 
82PTP006Category Codes - Payroll6StringUDC (06 06)30 Allow NULL? 
83PTP007Category Codes - Payroll7StringUDC (06 07)30 Allow NULL? 
84PTP008Category Codes - Payroll8StringUDC (06 08)30 Allow NULL? 
85PTP009Category Codes - Payroll9StringUDC (06 09)30 Allow NULL? 
86PTP010Category Codes - Payroll10StringUDC (06 10)30 Allow NULL? 
87PTP011Category Codes - Payroll11StringUDC (06 11)30 Allow NULL? 
88PTP012Category Codes - Payroll12StringUDC (06 12)30 Allow NULL? 
89PTP013Category Codes - Payroll13StringUDC (06 13)30 Allow NULL? 
90PTP014Category Codes - Payroll14StringUDC (06 14)30 Allow NULL? 
91PTP015Category Codes - Payroll15StringUDC (06 15)30 Allow NULL? 
92PTP016Category Codes - Payroll16StringUDC (06 16)30 Allow NULL? 
93PTP017Category Codes - Payroll17StringUDC (06 17)30 Allow NULL? 
94PTP018Category Codes - Payroll18StringUDC (06 18)30 Allow NULL? 
95PTP019Category Codes - Payroll19StringUDC (06 19)30 Allow NULL? 
96PTP020Category Codes - Payroll20StringUDC (06 21)30 Allow NULL? 
97PTE001Eligibility Code 001CharacterUDC (05 YB)10 Allow NULL? 
98PTE002Eligibility Code 002CharacterUDC (05 YB)10 Allow NULL? 
99PTE003Eligibility Code 003CharacterUDC (05 YB)10 Allow NULL? 
100PTE004Eligibility Code 004CharacterUDC (05 YB)10 Allow NULL? 
101PTE005Eligibility Code 005CharacterUDC (05 YB)10 Allow NULL? 
102PTE006Eligibility Code 006CharacterUDC (05 YB)10 Allow NULL? 
103PTE007Eligibility Code 007CharacterUDC (05 YB)10 Allow NULL? 
104PTE008Eligibility Code 008CharacterUDC (05 YB)10 Allow NULL? 
105PTE009Eligibility Code 009CharacterUDC (05 YB)10 Allow NULL? 
106PTE010Eligibility Code 010CharacterUDC (05 YB)10 Allow NULL? 
107PTICCInterim Check CodeCharacterUDC (07 IC)10 Allow NULL? 
108PTNMAXAmount - Maximum Net PayNumericGeneric Edit152 Allow NULL? 
109PTSOCCStandard Occupational Class CodeStringUDC (06 SO)40 Allow NULL? 
110PTIUSRUser ID - Interim Check EntererStringGeneric Edit100 Allow NULL? 
111PTITRMTerminal Id - Interim CheckStringGeneric Edit100 Allow NULL? 
112PTINBTInterim Processing Batch FlagCharacterUDC10 Allow NULL? 
113PTREGNRegionStringUDC (06 RG)30 Allow NULL? 
114PTPSTPNo. of Pay Grade StepsStringGeneric Edit40 Allow NULL? 
115PTIHHours per Standard YearNumericGeneric Edit72 Allow NULL? 
116PTCCPRCountry CodeStringUDC (00 CN)30 Allow NULL? 
117PTADPNPre-Note CodeCharacterUDC (07 AE)10 Allow NULL? 
118PTTCNFThird Country National FlagCharacterGeneric Edit10 Allow NULL? 
119PTRAFResident Alien FlagCharacterGeneric Edit10 Allow NULL? 
120PTTIPEEmployee Code - Tipped(Y/N)CharacterUDC (05 YN)10 Allow NULL? 
121PTRCCDRecord TypeCharacterUDC (07 RC)10 Allow NULL? 
122PTBDRTRate - Recharge BurdenNumericGeneric Edit93 Allow NULL? 
123PTBORNRate - New Recharge Burden RateNumericGeneric Edit93 Allow NULL? 
124PTNBDRDate - New Bill RateDateGeneric Edit60
125PTWETSub Class - Workers CompCharacterUDC (07 WH)10 Allow NULL? 
126PTAFLGAddress FlagCharacterGeneric Edit10 Allow NULL? 
127PTRMSTMarital Status - Resident StateCharacterUDC (06 MS)10 Allow NULL? 
128PTLMSTLocal Area Marital StatusCharacterUDC (06 MS)10 Allow NULL? 
129PTSMKRFlag - Language PreferenceStringUDC (07 SN)20 Allow NULL? 
130PTCBACAmount - Cash AccumulatorNumericGeneric Edit32 Allow NULL? 
131PTCBAFFlag - Cash RoundingCharacterGeneric Edit10 Allow NULL? 
132PTPCCDPay Cycle CodeStringUDC (06 PY)50 Allow NULL? 
133PTRCDTDate - Employee RecallDateGeneric Edit60
134PTLSDTDate - LOA Beginning DateDateGeneric Edit60
135PTPADTDate - ParticipationDateGeneric Edit60
136PTPYMHMethod - Employee PaymentCharacterUDC10 Allow NULL? 
137PTUYSTProcessed Code - PayrollCharacterUDC10 Allow NULL? 
138PTDTSPDate - Time StampNumericGeneric Edit130 Allow NULL? 
139PTANN8Address Number-Provider/TrusteeNumericGeneric Edit80 Allow NULL? 
140PTPPNBPay Period NumberStringGeneric Edit30 Allow NULL? 
141PTPYDTDate - Pay Cycle ProcessedDateGeneric Edit60
142PTCBENCash BenefitCharacterUDC (05 YN)10 Allow NULL? 
143PTDOBMBirthday - MonthNumericGeneric Edit20 Allow NULL? 
144PTDSTMStartdate - MonthNumericGeneric Edit20 Allow NULL? 
145PTPSALRate - Previous SalaryNumericGeneric Edit112 Allow NULL? 
146PTHIPNMedical Plan IDStringGeneric Edit110 Allow NULL? 
147PTCMCredit MessageStringUDC (00 CM)20 Allow NULL? 
148PTLSALRate - Life Ins. Annual SalaryNumericGeneric Edit132 Allow NULL? 
149PTDIVCBenefit GroupStringGeneric Edit60 Allow NULL? 
150PTVSHFShares Flag - VotingCharacterUDC (05 YN)10 Allow NULL? 
151PTPYRVPrior Years for Calculating VestingNumericGeneric Edit53 Allow NULL? 
152PTANPASupervisorNumericGeneric Edit80 Allow NULL? 
153PTPGRDPay GradeStringGeneric Edit60 Allow NULL? 
154PTPGRSPay Grade StepStringGeneric Edit40 Allow NULL? 
155PTSLOCSalary Data LocalityStringUDC (06 SL)80 Allow NULL? 
156PTNRVWDate - Next ReviewDateGeneric Edit60
157PTTINCType of Increase Next ReviewCharacterUDC (06 RV)10 Allow NULL? 
158PTHM01EEO - I9 StatusCharacterUDC (07 HN)10 Allow NULL? 
159PTHM02EEO - VeteranCharacterUDC (05 HO)10 Allow NULL? 
160PTHM03EEO - Disabled VeteranCharacterUDC (05 HP)10 Allow NULL? 
161PTHM04EEO - DisabilityCharacterUDC (05 HQ)10 Allow NULL? 
162PTPOSPosition IDStringGeneric Edit80 Allow NULL? 
163PTED01Date - User Defined1DateGeneric Edit60
164PTED02Date - User Defined2DateGeneric Edit60
165PTED03Date - User Defined3DateGeneric Edit60
166PTED04Date - User Defined4DateGeneric Edit60
167PTED05Date - User Defined5DateGeneric Edit60
168PTED06Date - User Defined6DateGeneric Edit60
169PTED07Date - User Defined7DateGeneric Edit60
170PTED08Date - User Defined8DateGeneric Edit60
171PTED09Date - User Defined9DateGeneric Edit60
172PTED10Date - User Defined10DateGeneric Edit60
173PTED11Date - User Defined11DateGeneric Edit60
174PTED12Date - User Defined12DateGeneric Edit60
175PTED13Date - User Defined13DateGeneric Edit60
176PTED14Date - User Defined14DateGeneric Edit60
177PTED15Date - User Defined15DateGeneric Edit60
178PTED16Date - User Defined16DateGeneric Edit60
179PTED17Date - User Defined17DateGeneric Edit60
180PTED18Date - User Defined18DateGeneric Edit60
181PTED19Date - User Defined19DateGeneric Edit60
182PTED20Date - User Defined20DateGeneric Edit60
183PTDEPTDepartment CodeStringGeneric Edit120 Allow NULL? 
184PTFAGEAge - EmployeeNumericGeneric Edit30 Allow NULL? 
185PTFSALRate - Life Ins. Annual SalaryNumericGeneric Edit152 Allow NULL? 
186PTADSDDate - Adjusted Service DateDateGeneric Edit60
187PTCMPACompa-RatioNumericGeneric Edit52 Allow NULL? 
188PTEPNTJob Evaluation PointsNumericGeneric Edit50 Allow NULL? 
189PTJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
190PTUSERUser IDStringGeneric Edit100 Allow NULL? 
191PTPIDProgram IDStringGeneric Edit100 Allow NULL? 
192PTUPMJDate - UpdatedDateGeneric Edit60
193PTK001401(k) Non-Discrimination Test1CharacterGeneric Edit (05 OO)10 Allow NULL? 
194PTK002401(k) Non-Discrimination Test2CharacterGeneric Edit (05 YB)10 Allow NULL? 
195PTK003401(k) Non-Discrimination Test3CharacterGeneric Edit (05 YB)10 Allow NULL? 
196PTK004401(k) Non-Discrimination Test4CharacterGeneric Edit (05 YB)10 Allow NULL? 
197PTK005401(k) Non-Discrimination Test5CharacterGeneric Edit (05 YB)10 Allow NULL? 
198PTK006401(k) Non-Discrimination Test6CharacterGeneric Edit (05 YB)10 Allow NULL? 
199PTK007401(k) Non-Discrimination Test7CharacterGeneric Edit (05 YB)10 Allow NULL? 
200PTK008401(k) Non-Discrimination Test8CharacterGeneric Edit (05 YB)10 Allow NULL? 
201PTK009401(k) Non-Discrimination Test9CharacterGeneric Edit (05 YB)10 Allow NULL? 
202PTK010401(k) Non-Discrimination Test10CharacterGeneric Edit (05 YB)10 Allow NULL? 
203PTATPYPayroll Autopay PaytypeNumericUDC (06 20)30 Allow NULL? 
204PTPENSPension CodeCharacterUDC (05 YB)10 Allow NULL? 
205PTORGOrgeon InsuranceCharacterUDC (05A OR)10 Allow NULL? 
206PTBENSEmployee Benefit StatusCharacterUDC (06 EA)10 Allow NULL? 
207PTFTEFull Time EquivalentsNumericGeneric Edit92 Allow NULL? 
208PTAAFVacation FactorCharacterUDC (07 AA)10 Allow NULL? 
209PTSUISource of SUI ReportingCharacterUDC (05 SR)10 Allow NULL? 
210PTDTSFSalary Forecast Change DateDateGeneric Edit60
211PTSMOYPeriods Paid Per YearNumericGeneric Edit52 Allow NULL? 
212PTLDIDLabor Distribution Period IDStringUDC (05T LD)50 Allow NULL? 
213PTTTARTotal Time Accounting RulesCharacterUDC (05T TA)10 Allow NULL? 

TOP920 | 05A | F0601161 INDEXES

NumberDescription
1F0601161_1 (Primary/Unique)
ElementAliasDescriptionSequence
1EFTODate - Effective OnAscending
2SVERSnapshot VersionAscending
3AN8Address NumberAscending