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
1920F060116ZSZ2082Unedited Quick Hire Transaction FileTransaction 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 SZEDUS, SZEDBT, SZEDTN, SZEDLN, SZEDCT, SZTYTN, SZEDFT, SZEDDT, SZDRIN, SZEDDL, SZEDSP, SZPNID, SZTNAC, SZAN8, SZALPH, SZSALU, SZSUFF, SZMLNM, SZSSN, SZAT1, SZATE, SZHMCO, SZHMCU, SZANPA, SZJBCD, SZJBST, SZSAL, SZPHRT, SZDSI, SZEEOM, SZSEX, SZDOB, SZCCPR, SZHM01, SZTARR, SZTARA, SZMSTX, SZMSTI, SZLMST, SZSHFT, SZMAIL, SZSLOC, SZPAST, SZEST, SZSDYY, SZPSDT, SZMCU, SZWSPS, SZNS, SZSUI, SZRCCD, SZFICM, SZAPPN, SZHM02, SZHM03, SZHM04, SZPADT, SZBENS, SZPFRQ, SZSALY, SZPGRD, SZPGRS, SZFLSA, SZWCMP, SZWET, SZUN, SZDIVC, SZEEOJ, SZADD1, SZADD2, SZADD3, SZADD4, SZCTY1, SZADDS, SZADDZ, SZCTR, SZAR1, SZPH1, SZAR3, SZPH3, SZWHO4, SZAR4, SZPH4, SZREM1, SZREQN, SZSALA, SZSC01, SZTRS, SZEFTO, SZURCD, SZURDT, SZURAT, SZURAB, SZURRF, SZTORG, SZUSER, SZPID, SZJOBN, SZUPMJ, SZTDAY, SZP001, SZP002, SZP003, SZP004, SZP005, SZP006, SZP007, SZP008, SZP009, SZP010, SZP011, SZP012, SZP013, SZP014, SZP015, SZP016, SZP017, SZP018, SZP019, SZP020, SZE001, SZE002, SZE003, SZE004, SZE005, SZE006, SZE007, SZE008, SZE009, SZE010, SZFTE, SZIH, SZCOUN, SZPOS, SZOEMP, SZIFN, SZIMN, SZDTSP, SZED01, SZED02, SZED03, SZED04, SZED05, SZED06, SZED07, SZED08, SZED09, SZED10, SZED11, SZED12, SZED13, SZED14, SZED15, SZED16, SZED17, SZED18, SZED19, SZED20, SZK001, SZK002, SZK003, SZK004, SZK005, SZK006, SZK007, SZK008, SZK009, SZK010, SZLF, SZLMTH, SZRMST, SZSTDD, SZSTDH, SZSMKR, SZTIPE, SZMSA, SZADPN, SZAC01, SZAC02, SZAC03, SZAC04, SZAC05, SZAC06, SZAC07, SZAC08, SZAC09, SZAC10, SZAC11, SZAC12, SZAC13, SZAC14, SZAC15, SZAC16, SZAC17, SZAC18, SZAC19, SZAC20, SZAC21, SZAC22, SZAC23, SZAC24, SZAC25, SZAC26, SZAC27, SZAC28, SZAC29, SZAC30, SZORMCU FROM F060116Z

TOP920 | 05A | F060116Z COLUMNS

ColumnFieldDescriptionData TypeEdit TypeLengthDecimalsSQL Create Statement
1SZEDUSEDI - User IDStringGeneric Edit100 Allow NULL? 
2SZEDBTEDI - Batch NumberStringGeneric Edit150 Allow NULL? 
3SZEDTNEDI - Transaction NumberStringGeneric Edit220 Allow NULL? 
4SZEDLNEDI - Line NumberNumericGeneric Edit73 Allow NULL? 
5SZEDCTEDI - Document TypeStringGeneric Edit20 Allow NULL? 
6SZTYTNType - TransactionStringUDC (00 TT)80 Allow NULL? 
7SZEDFTEDI - Translation FormatStringGeneric Edit100 Allow NULL? 
8SZEDDTEDI - Transmission DateDateGeneric Edit60
9SZDRINDirection IndicatorCharacterUDC (00 DN)10 Allow NULL? 
10SZEDDLEDI - Detail Lines ProcessedNumericGeneric Edit50 Allow NULL? 
11SZEDSPEDI - Successfully ProcessedCharacterGeneric Edit10 Allow NULL? 
12SZPNIDTrading Partner IDStringGeneric Edit150 Allow NULL? 
13SZTNACTransaction ActionStringUDC (00 TA)20 Allow NULL? 
14SZAN8Address NumberNumericGeneric Edit80 Allow NULL? 
15SZALPHName - AlphaStringGeneric Edit400 Allow NULL? 
16SZSALUSalutationStringUDC (06 SA)50 Allow NULL? 
17SZSUFFSuffixStringUDC (06 SF)50 Allow NULL? 
18SZMLNMName - MailingStringGeneric Edit400 Allow NULL? 
19SZSSNEmployee Tax IDStringGeneric Edit200 Allow NULL? 
20SZAT1Search TypeStringUDC (01 ST)30 Allow NULL? 
21SZATEAddress Type - EmployeeCharacterUDC (H01 AR)10 Allow NULL? 
22SZHMCOCompany - HomeStringGeneric Edit50 Allow NULL? 
23SZHMCUBusiness Unit - HomeStringGeneric Edit120 Allow NULL? 
24SZANPASupervisorNumericGeneric Edit80 Allow NULL? 
25SZJBCDJob Type (Craft) CodeStringUDC (06 G)60 Allow NULL? 
26SZJBSTJob StepStringUDC (06 GS)40 Allow NULL? 
27SZSALRate - Salary AnnualNumericGeneric Edit112 Allow NULL? 
28SZPHRTRate - HourlyNumericGeneric Edit93 Allow NULL? 
29SZDSIDate - Original EmploymentDateGeneric Edit60
30SZEEOMEthnic CodeStringUDC (06 M)20 Allow NULL? 
31SZSEXGender (Male/Female)CharacterUDC (07 SG)10 Allow NULL? 
32SZDOBDate - BirthDateGeneric Edit60
33SZCCPRCountry CodeStringUDC (00 CN)30 Allow NULL? 
34SZHM01EEO - I9 StatusCharacterUDC (07 HN)10 Allow NULL? 
35SZTARRTax Area (Residence)StringGeneric Edit100 Allow NULL? 
36SZTARATax Area (Work)StringGeneric Edit100 Allow NULL? 
37SZMSTXMarital Status - TaxCharacterUDC (06 MS)10 Allow NULL? 
38SZMSTIMarital Status - State TaxCharacterUDC (06 MS)10 Allow NULL? 
39SZLMSTLocal Area Marital StatusCharacterUDC (06 MS)10 Allow NULL? 
40SZSHFTShift CodeCharacterUDC (06 SH)10 Allow NULL? 
41SZMAILRouting Code - CheckStringUDC (06 CR)100 Allow NULL? 
42SZSLOCSalary Data LocalityStringUDC (06 SL)80 Allow NULL? 
43SZPASTEmployee Pay StatusCharacterUDC (06 PS)10 Allow NULL? 
44SZESTEmployment StatusCharacterUDC (06 ES)10 Allow NULL? 
45SZSDYYDays - Standard per YearNumericGeneric Edit52 Allow NULL? 
46SZPSDTDate - Pay StartsDateGeneric Edit60
47SZMCUBusiness UnitStringGeneric Edit120 Allow NULL? 
48SZWSPSResidency StatusCharacterUDC (05 WS)10 Allow NULL? 
49SZNSWork Tax Area SourceCharacterUDC (05 NS)10 Allow NULL? 
50SZSUISource of SUI ReportingCharacterUDC (05 SR)10 Allow NULL? 
51SZRCCDRecord TypeCharacterUDC (07 RC)10 Allow NULL? 
52SZFICMTax Calc MethodCharacterUDC (06 TM)10 Allow NULL? 
53SZAPPNPeriod Number - Accounts PayableNumericGeneric Edit20 Allow NULL? 
54SZHM02EEO - VeteranCharacterUDC (05 HO)10 Allow NULL? 
55SZHM03EEO - Disabled VeteranCharacterUDC (05 HP)10 Allow NULL? 
56SZHM04EEO - DisabilityCharacterUDC (05 HQ)10 Allow NULL? 
57SZPADTDate - ParticipationDateGeneric Edit60
58SZBENSEmployee Benefit StatusCharacterUDC (06 EA)10 Allow NULL? 
59SZPFRQPay FrequencyCharacterUDC (06 PF)10 Allow NULL? 
60SZSALYPay Class (H/S/P)CharacterUDC (05A PK)10 Allow NULL? 
61SZPGRDPay GradeStringGeneric Edit60 Allow NULL? 
62SZPGRSPay Grade StepStringGeneric Edit40 Allow NULL? 
63SZFLSAFLSA Exempt Y/NCharacterUDC (05 FL)10 Allow NULL? 
64SZWCMPWorker's Comp. Insurance CodeStringUDC (00 W)40 Allow NULL? 
65SZWETSub Class - Workers CompCharacterUDC (07 WH)10 Allow NULL? 
66SZUNUnion CodeStringUDC (06 UN)60 Allow NULL? 
67SZDIVCBenefit GroupStringGeneric Edit60 Allow NULL? 
68SZEEOJJob Category (EEO)StringUDC (06 J)30 Allow NULL? 
69SZADD1Address Line 1StringGeneric Edit400 Allow NULL? 
70SZADD2Address Line 2StringGeneric Edit400 Allow NULL? 
71SZADD3Address Line 3StringGeneric Edit400 Allow NULL? 
72SZADD4Address Line 4StringGeneric Edit400 Allow NULL? 
73SZCTY1CityStringGeneric Edit250 Allow NULL? 
74SZADDSStateStringUDC (00 S)30 Allow NULL? 
75SZADDZPostal CodeStringGeneric Edit120 Allow NULL? 
76SZCTRCountryStringUDC (00 CN)30 Allow NULL? 
77SZAR1Phone PrefixStringGeneric Edit60 Allow NULL? 
78SZPH1Phone NumberStringGeneric Edit200 Allow NULL? 
79SZAR3Phone Area Code 3StringGeneric Edit60 Allow NULL? 
80SZPH3Phone NumberStringGeneric Edit200 Allow NULL? 
81SZWHO4Contact Name 4StringGeneric Edit400 Allow NULL? 
82SZAR4Phone Area Code 4StringGeneric Edit60 Allow NULL? 
83SZPH4Phone NumberStringGeneric Edit200 Allow NULL? 
84SZREM1Remark 1StringGeneric Edit400 Allow NULL? 
85SZREQNNumber - RequisitionNumericGeneric Edit80 Allow NULL? 
86SZSALARate - Salary AskingNumericGeneric Edit112 Allow NULL? 
87SZSC01Statutory Code 01StringUDC (06 SC)30 Allow NULL? 
88SZTRSChange ReasonStringUDC (06 T)30 Allow NULL? 
89SZEFTODate - Effective OnDateGeneric Edit60
90SZURCDUser Reserved CodeStringGeneric Edit20 Allow NULL? 
91SZURDTUser Reserved DateDateGeneric Edit60
92SZURATUser Reserved AmountNumericGeneric Edit152 Allow NULL? 
93SZURABUser Reserved NumberNumericGeneric Edit80 Allow NULL? 
94SZURRFUser Reserved ReferenceStringGeneric Edit150 Allow NULL? 
95SZTORGTransaction OriginatorStringGeneric Edit100 Allow NULL? 
96SZUSERUser IDStringGeneric Edit100 Allow NULL? 
97SZPIDProgram IDStringGeneric Edit100 Allow NULL? 
98SZJOBNWork Station IDStringGeneric Edit100 Allow NULL? 
99SZUPMJDate - UpdatedDateGeneric Edit60
100SZTDAYTime of DayNumericGeneric Edit60 Allow NULL? 
101SZP001Category Codes - Payroll1StringUDC (06 01)30 Allow NULL? 
102SZP002Category Codes - Payroll2StringUDC (06 02)30 Allow NULL? 
103SZP003Category Codes - Payroll3StringUDC (06 03)30 Allow NULL? 
104SZP004Category Codes - Payroll4StringUDC (06 04)30 Allow NULL? 
105SZP005Category Codes - Payroll5StringUDC (06 05)30 Allow NULL? 
106SZP006Category Codes - Payroll6StringUDC (06 06)30 Allow NULL? 
107SZP007Category Codes - Payroll7StringUDC (06 07)30 Allow NULL? 
108SZP008Category Codes - Payroll8StringUDC (06 08)30 Allow NULL? 
109SZP009Category Codes - Payroll9StringUDC (06 09)30 Allow NULL? 
110SZP010Category Codes - Payroll10StringUDC (06 10)30 Allow NULL? 
111SZP011Category Codes - Payroll11StringUDC (06 11)30 Allow NULL? 
112SZP012Category Codes - Payroll12StringUDC (06 12)30 Allow NULL? 
113SZP013Category Codes - Payroll13StringUDC (06 13)30 Allow NULL? 
114SZP014Category Codes - Payroll14StringUDC (06 14)30 Allow NULL? 
115SZP015Category Codes - Payroll15StringUDC (06 15)30 Allow NULL? 
116SZP016Category Codes - Payroll16StringUDC (06 16)30 Allow NULL? 
117SZP017Category Codes - Payroll17StringUDC (06 17)30 Allow NULL? 
118SZP018Category Codes - Payroll18StringUDC (06 18)30 Allow NULL? 
119SZP019Category Codes - Payroll19StringUDC (06 19)30 Allow NULL? 
120SZP020Category Codes - Payroll20StringUDC (06 21)30 Allow NULL? 
121SZE001Eligibility Code 001CharacterUDC (05 YB)10 Allow NULL? 
122SZE002Eligibility Code 002CharacterUDC (05 YB)10 Allow NULL? 
123SZE003Eligibility Code 003CharacterUDC (05 YB)10 Allow NULL? 
124SZE004Eligibility Code 004CharacterUDC (05 YB)10 Allow NULL? 
125SZE005Eligibility Code 005CharacterUDC (05 YB)10 Allow NULL? 
126SZE006Eligibility Code 006CharacterUDC (05 YB)10 Allow NULL? 
127SZE007Eligibility Code 007CharacterUDC (05 YB)10 Allow NULL? 
128SZE008Eligibility Code 008CharacterUDC (05 YB)10 Allow NULL? 
129SZE009Eligibility Code 009CharacterUDC (05 YB)10 Allow NULL? 
130SZE010Eligibility Code 010CharacterUDC (05 YB)10 Allow NULL? 
131SZFTEFull Time EquivalentsNumericGeneric Edit92 Allow NULL? 
132SZIHHours per Standard YearNumericGeneric Edit72 Allow NULL? 
133SZCOUNCountyStringUDC (00 CT)250 Allow NULL? 
134SZPOSPosition IDStringGeneric Edit80 Allow NULL? 
135SZOEMPAdditional Employee NoStringGeneric Edit80 Allow NULL? 
136SZIFNInitial - First Name (Govt Rpts)CharacterGeneric Edit10 Allow NULL? 
137SZIMNInitial - Middle Name (Govt Rpts)CharacterGeneric Edit10 Allow NULL? 
138SZDTSPDate - Time StampNumericGeneric Edit130 Allow NULL? 
139SZED01Date - User Defined1DateGeneric Edit60
140SZED02Date - User Defined2DateGeneric Edit60
141SZED03Date - User Defined3DateGeneric Edit60
142SZED04Date - User Defined4DateGeneric Edit60
143SZED05Date - User Defined5DateGeneric Edit60
144SZED06Date - User Defined6DateGeneric Edit60
145SZED07Date - User Defined7DateGeneric Edit60
146SZED08Date - User Defined8DateGeneric Edit60
147SZED09Date - User Defined9DateGeneric Edit60
148SZED10Date - User Defined10DateGeneric Edit60
149SZED11Date - User Defined11DateGeneric Edit60
150SZED12Date - User Defined12DateGeneric Edit60
151SZED13Date - User Defined13DateGeneric Edit60
152SZED14Date - User Defined14DateGeneric Edit60
153SZED15Date - User Defined15DateGeneric Edit60
154SZED16Date - User Defined16DateGeneric Edit60
155SZED17Date - User Defined17DateGeneric Edit60
156SZED18Date - User Defined18DateGeneric Edit60
157SZED19Date - User Defined19DateGeneric Edit60
158SZED20Date - User Defined20DateGeneric Edit60
159SZK001401(k) Non-Discrimination Test1CharacterGeneric Edit (05 OO)10 Allow NULL? 
160SZK002401(k) Non-Discrimination Test2CharacterGeneric Edit (05 YB)10 Allow NULL? 
161SZK003401(k) Non-Discrimination Test3CharacterGeneric Edit (05 YB)10 Allow NULL? 
162SZK004401(k) Non-Discrimination Test4CharacterGeneric Edit (05 YB)10 Allow NULL? 
163SZK005401(k) Non-Discrimination Test5CharacterGeneric Edit (05 YB)10 Allow NULL? 
164SZK006401(k) Non-Discrimination Test6CharacterGeneric Edit (05 YB)10 Allow NULL? 
165SZK007401(k) Non-Discrimination Test7CharacterGeneric Edit (05 YB)10 Allow NULL? 
166SZK008401(k) Non-Discrimination Test8CharacterGeneric Edit (05 YB)10 Allow NULL? 
167SZK009401(k) Non-Discrimination Test9CharacterGeneric Edit (05 YB)10 Allow NULL? 
168SZK010401(k) Non-Discrimination Test10CharacterGeneric Edit (05 YB)10 Allow NULL? 
169SZLFLabor Distribution MultiplierNumericGeneric Edit54 Allow NULL? 
170SZLMTHLabor Distribution MethodCharacterUDC (07 LT)10 Allow NULL? 
171SZRMSTMarital Status - Resident StateCharacterUDC (06 MS)10 Allow NULL? 
172SZSTDDHours - Standard per DayNumericGeneric Edit52 Allow NULL? 
173SZSTDHHours - Standard per PayperiodNumericGeneric Edit52 Allow NULL? 
174SZSMKRFlag - Language PreferenceStringUDC (07 SN)20 Allow NULL? 
175SZTIPEEmployee Code - Tipped(Y/N)CharacterUDC (05 YN)10 Allow NULL? 
176SZMSAMarital Status - ActualCharacterUDC (07 MS)10 Allow NULL? 
177SZADPNPre-Note CodeCharacterUDC (07 AE)10 Allow NULL? 
178SZAC01Category Code - Address Book 01StringUDC (01 01)30 Allow NULL? 
179SZAC02Category Code - Address Book 02StringUDC (01 02)30 Allow NULL? 
180SZAC03Category Code - Address Book 03StringUDC (01 03)30 Allow NULL? 
181SZAC04Category Code - Address Book 04StringUDC (01 04)30 Allow NULL? 
182SZAC05Category Code - Address Book 05StringUDC (01 05)30 Allow NULL? 
183SZAC06Category Code - Address Book 06StringUDC (01 06)30 Allow NULL? 
184SZAC07Category Code - Address Book 07StringUDC (01 07)30 Allow NULL? 
185SZAC08Category Code - Address Book 08StringUDC (01 08)30 Allow NULL? 
186SZAC09Category Code - Address Book 09StringUDC (01 09)30 Allow NULL? 
187SZAC10Category Code - Address Book 10StringUDC (01 10)30 Allow NULL? 
188SZAC11Sales RegionStringUDC (01 11)30 Allow NULL? 
189SZAC12Category Code - Address Book 12StringUDC (01 12)30 Allow NULL? 
190SZAC13Category Code - Address Book 13StringUDC (01 13)30 Allow NULL? 
191SZAC14Category Code - Address Book 14StringUDC (01 14)30 Allow NULL? 
192SZAC15Category Code - Address Book 15StringUDC (01 15)30 Allow NULL? 
193SZAC16Category Code - Address Book 16StringUDC (01 16)30 Allow NULL? 
194SZAC17Category Code - Address Book 17StringUDC (01 17)30 Allow NULL? 
195SZAC18Category Code - Address Book 18StringUDC (01 18)30 Allow NULL? 
196SZAC19Category Code - Address Book 19StringUDC (01 19)30 Allow NULL? 
197SZAC20Category Code - Address Book 20StringUDC (01 20)30 Allow NULL? 
198SZAC21Category Code - Address Book 21StringUDC (01 21)30 Allow NULL? 
199SZAC22Category Code - Address Book 22StringUDC (01 22)30 Allow NULL? 
200SZAC23Category Code - Address Book 23StringUDC (01 23)30 Allow NULL? 
201SZAC24Category Code - Address Book 24StringUDC (01 24)30 Allow NULL? 
202SZAC25Category Code - Address Book 25StringUDC (01 25)30 Allow NULL? 
203SZAC26Category Code - Address Book 26StringUDC (01 26)30 Allow NULL? 
204SZAC27Category Code - Address Book 27StringUDC (01 27)30 Allow NULL? 
205SZAC28Category Code - Address Book 28StringUDC (01 28)30 Allow NULL? 
206SZAC29Category Code - Address Book 29StringUDC (01 29)30 Allow NULL? 
207SZAC30Category Code - Address Book 30StringUDC (01 30)30 Allow NULL? 
208SZORMCUOrganizational Business UnitStringGeneric Edit120 Allow NULL? 

TOP920 | 05A | F060116Z INDEXES

NumberDescription
1User ID Batch Number +A (Primary/Unique)
ElementAliasDescriptionSequence
1EDUSEDI - User IDAscending
2EDBTEDI - Batch NumberAscending
3EDTNEDI - Transaction NumberAscending
4EDLNEDI - Line NumberAscending
2Address Number
ElementAliasDescriptionSequence
1AN8Address NumberAscending