	Table	Prefix	Description
1	F4211	SD	Sales Order Detail File
2	F0101	AB	Address Book Master
3	F4101	IM	Item Master
4	F0911	GL	Account Ledger
5	F4311	PD	Purchase Order Detail File
6	F9671	SD	Software Update Detail Table
7	F4102	IB	Item Branch File
8	F0411	RP	Accounts Payable Ledger
9	F0006	MC	Business Unit Master
10	F41021	LI	Item Location File

	Table	Prefix	Description
1	F0011W	IC	F0011W - WF - Batch To Detail
2	F76AUI46	WF	CERG A/R -Work File - ARG - 03B - 76A
3	F4211	SD	Sales Order Detail File
4	F4101	IM	Item Master
5	F0101	AB	Address Book Master
6	F0911	GL	Account Ledger
7	F4102	IB	Item Branch File
8	F03B11	RP	Customer Ledger
9	F4111	IL	Item Ledger File
10	F4311	PD	Purchase Order Detail File

	Table	Prefix	Description
1	F0911	GL	Account Ledger
2	F4311	PD	Purchase Order Detail File
3	F0101	AB	Address Book Master
4	F0006	MC	Business Unit Master
5	F0411	RP	Accounts Payable Ledger
6	F4211	SD	Sales Order Detail File
7	F42119	SD	Sales Order History File
8	F03012	AI	Customer Master by Line of Business
9	F0902	GB	Account Balances
10	F4801	WA	Work Order Master File

208 COLUMNS | 2 INDEXES | 920 | 05A | F060116Z TABLE

	Schema	Table	Prefix	Columns	Indexes	Description	Type	Report	Category
05A: PeopleSoft HR & PR Foundation
1	920	F060116Z	SZ	208	2	Unedited Quick Hire Transaction File	Transaction Files	05A: PeopleSoft HR & PR Foundation	Business 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

TOP 920 | 05A | F060116Z COLUMNS

Column	Field	Description	Data Type	Edit Type	Length	Decimals	SQL Create Statement
1	SZEDUS	EDI - User ID	String	Generic Edit	10	0	Allow NULL?
2	SZEDBT	EDI - Batch Number	String	Generic Edit	15	0	Allow NULL?
3	SZEDTN	EDI - Transaction Number	String	Generic Edit	22	0	Allow NULL?
4	SZEDLN	EDI - Line Number	Numeric	Generic Edit	7	3	Allow NULL?
5	SZEDCT	EDI - Document Type	String	Generic Edit	2	0	Allow NULL?
6	SZTYTN	Type - Transaction	String	UDC (00 TT)	8	0	Allow NULL?
7	SZEDFT	EDI - Translation Format	String	Generic Edit	10	0	Allow NULL?
8	SZEDDT	EDI - Transmission Date	Date	Generic Edit	6	0
9	SZDRIN	Direction Indicator	Character	UDC (00 DN)	1	0	Allow NULL?
10	SZEDDL	EDI - Detail Lines Processed	Numeric	Generic Edit	5	0	Allow NULL?
11	SZEDSP	EDI - Successfully Processed	Character	Generic Edit	1	0	Allow NULL?
12	SZPNID	Trading Partner ID	String	Generic Edit	15	0	Allow NULL?
13	SZTNAC	Transaction Action	String	UDC (00 TA)	2	0	Allow NULL?
14	SZAN8	Address Number	Numeric	Generic Edit	8	0	Allow NULL?
15	SZALPH	Name - Alpha	String	Generic Edit	40	0	Allow NULL?
16	SZSALU	Salutation	String	UDC (06 SA)	5	0	Allow NULL?
17	SZSUFF	Suffix	String	UDC (06 SF)	5	0	Allow NULL?
18	SZMLNM	Name - Mailing	String	Generic Edit	40	0	Allow NULL?
19	SZSSN	Employee Tax ID	String	Generic Edit	20	0	Allow NULL?
20	SZAT1	Search Type	String	UDC (01 ST)	3	0	Allow NULL?
21	SZATE	Address Type - Employee	Character	UDC (H01 AR)	1	0	Allow NULL?
22	SZHMCO	Company - Home	String	Generic Edit	5	0	Allow NULL?
23	SZHMCU	Business Unit - Home	String	Generic Edit	12	0	Allow NULL?
24	SZANPA	Supervisor	Numeric	Generic Edit	8	0	Allow NULL?
25	SZJBCD	Job Type (Craft) Code	String	UDC (06 G)	6	0	Allow NULL?
26	SZJBST	Job Step	String	UDC (06 GS)	4	0	Allow NULL?
27	SZSAL	Rate - Salary Annual	Numeric	Generic Edit	11	2	Allow NULL?
28	SZPHRT	Rate - Hourly	Numeric	Generic Edit	9	3	Allow NULL?
29	SZDSI	Date - Original Employment	Date	Generic Edit	6	0
30	SZEEOM	Ethnic Code	String	UDC (06 M)	2	0	Allow NULL?
31	SZSEX	Gender (Male/Female)	Character	UDC (07 SG)	1	0	Allow NULL?
32	SZDOB	Date - Birth	Date	Generic Edit	6	0
33	SZCCPR	Country Code	String	UDC (00 CN)	3	0	Allow NULL?
34	SZHM01	EEO - I9 Status	Character	UDC (07 HN)	1	0	Allow NULL?
35	SZTARR	Tax Area (Residence)	String	Generic Edit	10	0	Allow NULL?
36	SZTARA	Tax Area (Work)	String	Generic Edit	10	0	Allow NULL?
37	SZMSTX	Marital Status - Tax	Character	UDC (06 MS)	1	0	Allow NULL?
38	SZMSTI	Marital Status - State Tax	Character	UDC (06 MS)	1	0	Allow NULL?
39	SZLMST	Local Area Marital Status	Character	UDC (06 MS)	1	0	Allow NULL?
40	SZSHFT	Shift Code	Character	UDC (06 SH)	1	0	Allow NULL?
41	SZMAIL	Routing Code - Check	String	UDC (06 CR)	10	0	Allow NULL?
42	SZSLOC	Salary Data Locality	String	UDC (06 SL)	8	0	Allow NULL?
43	SZPAST	Employee Pay Status	Character	UDC (06 PS)	1	0	Allow NULL?
44	SZEST	Employment Status	Character	UDC (06 ES)	1	0	Allow NULL?
45	SZSDYY	Days - Standard per Year	Numeric	Generic Edit	5	2	Allow NULL?
46	SZPSDT	Date - Pay Starts	Date	Generic Edit	6	0
47	SZMCU	Business Unit	String	Generic Edit	12	0	Allow NULL?
48	SZWSPS	Residency Status	Character	UDC (05 WS)	1	0	Allow NULL?
49	SZNS	Work Tax Area Source	Character	UDC (05 NS)	1	0	Allow NULL?
50	SZSUI	Source of SUI Reporting	Character	UDC (05 SR)	1	0	Allow NULL?
51	SZRCCD	Record Type	Character	UDC (07 RC)	1	0	Allow NULL?
52	SZFICM	Tax Calc Method	Character	UDC (06 TM)	1	0	Allow NULL?
53	SZAPPN	Period Number - Accounts Payable	Numeric	Generic Edit	2	0	Allow NULL?
54	SZHM02	EEO - Veteran	Character	UDC (05 HO)	1	0	Allow NULL?
55	SZHM03	EEO - Disabled Veteran	Character	UDC (05 HP)	1	0	Allow NULL?
56	SZHM04	EEO - Disability	Character	UDC (05 HQ)	1	0	Allow NULL?
57	SZPADT	Date - Participation	Date	Generic Edit	6	0
58	SZBENS	Employee Benefit Status	Character	UDC (06 EA)	1	0	Allow NULL?
59	SZPFRQ	Pay Frequency	Character	UDC (06 PF)	1	0	Allow NULL?
60	SZSALY	Pay Class (H/S/P)	Character	UDC (05A PK)	1	0	Allow NULL?
61	SZPGRD	Pay Grade	String	Generic Edit	6	0	Allow NULL?
62	SZPGRS	Pay Grade Step	String	Generic Edit	4	0	Allow NULL?
63	SZFLSA	FLSA Exempt Y/N	Character	UDC (05 FL)	1	0	Allow NULL?
64	SZWCMP	Worker's Comp. Insurance Code	String	UDC (00 W)	4	0	Allow NULL?
65	SZWET	Sub Class - Workers Comp	Character	UDC (07 WH)	1	0	Allow NULL?
66	SZUN	Union Code	String	UDC (06 UN)	6	0	Allow NULL?
67	SZDIVC	Benefit Group	String	Generic Edit	6	0	Allow NULL?
68	SZEEOJ	Job Category (EEO)	String	UDC (06 J)	3	0	Allow NULL?
69	SZADD1	Address Line 1	String	Generic Edit	40	0	Allow NULL?
70	SZADD2	Address Line 2	String	Generic Edit	40	0	Allow NULL?
71	SZADD3	Address Line 3	String	Generic Edit	40	0	Allow NULL?
72	SZADD4	Address Line 4	String	Generic Edit	40	0	Allow NULL?
73	SZCTY1	City	String	Generic Edit	25	0	Allow NULL?
74	SZADDS	State	String	UDC (00 S)	3	0	Allow NULL?
75	SZADDZ	Postal Code	String	Generic Edit	12	0	Allow NULL?
76	SZCTR	Country	String	UDC (00 CN)	3	0	Allow NULL?
77	SZAR1	Phone Prefix	String	Generic Edit	6	0	Allow NULL?
78	SZPH1	Phone Number	String	Generic Edit	20	0	Allow NULL?
79	SZAR3	Phone Area Code 3	String	Generic Edit	6	0	Allow NULL?
80	SZPH3	Phone Number	String	Generic Edit	20	0	Allow NULL?
81	SZWHO4	Contact Name 4	String	Generic Edit	40	0	Allow NULL?
82	SZAR4	Phone Area Code 4	String	Generic Edit	6	0	Allow NULL?
83	SZPH4	Phone Number	String	Generic Edit	20	0	Allow NULL?
84	SZREM1	Remark 1	String	Generic Edit	40	0	Allow NULL?
85	SZREQN	Number - Requisition	Numeric	Generic Edit	8	0	Allow NULL?
86	SZSALA	Rate - Salary Asking	Numeric	Generic Edit	11	2	Allow NULL?
87	SZSC01	Statutory Code 01	String	UDC (06 SC)	3	0	Allow NULL?
88	SZTRS	Change Reason	String	UDC (06 T)	3	0	Allow NULL?
89	SZEFTO	Date - Effective On	Date	Generic Edit	6	0
90	SZURCD	User Reserved Code	String	Generic Edit	2	0	Allow NULL?
91	SZURDT	User Reserved Date	Date	Generic Edit	6	0
92	SZURAT	User Reserved Amount	Numeric	Generic Edit	15	2	Allow NULL?
93	SZURAB	User Reserved Number	Numeric	Generic Edit	8	0	Allow NULL?
94	SZURRF	User Reserved Reference	String	Generic Edit	15	0	Allow NULL?
95	SZTORG	Transaction Originator	String	Generic Edit	10	0	Allow NULL?
96	SZUSER	User ID	String	Generic Edit	10	0	Allow NULL?
97	SZPID	Program ID	String	Generic Edit	10	0	Allow NULL?
98	SZJOBN	Work Station ID	String	Generic Edit	10	0	Allow NULL?
99	SZUPMJ	Date - Updated	Date	Generic Edit	6	0
100	SZTDAY	Time of Day	Numeric	Generic Edit	6	0	Allow NULL?
101	SZP001	Category Codes - Payroll1	String	UDC (06 01)	3	0	Allow NULL?
102	SZP002	Category Codes - Payroll2	String	UDC (06 02)	3	0	Allow NULL?
103	SZP003	Category Codes - Payroll3	String	UDC (06 03)	3	0	Allow NULL?
104	SZP004	Category Codes - Payroll4	String	UDC (06 04)	3	0	Allow NULL?
105	SZP005	Category Codes - Payroll5	String	UDC (06 05)	3	0	Allow NULL?
106	SZP006	Category Codes - Payroll6	String	UDC (06 06)	3	0	Allow NULL?
107	SZP007	Category Codes - Payroll7	String	UDC (06 07)	3	0	Allow NULL?
108	SZP008	Category Codes - Payroll8	String	UDC (06 08)	3	0	Allow NULL?
109	SZP009	Category Codes - Payroll9	String	UDC (06 09)	3	0	Allow NULL?
110	SZP010	Category Codes - Payroll10	String	UDC (06 10)	3	0	Allow NULL?
111	SZP011	Category Codes - Payroll11	String	UDC (06 11)	3	0	Allow NULL?
112	SZP012	Category Codes - Payroll12	String	UDC (06 12)	3	0	Allow NULL?
113	SZP013	Category Codes - Payroll13	String	UDC (06 13)	3	0	Allow NULL?
114	SZP014	Category Codes - Payroll14	String	UDC (06 14)	3	0	Allow NULL?
115	SZP015	Category Codes - Payroll15	String	UDC (06 15)	3	0	Allow NULL?
116	SZP016	Category Codes - Payroll16	String	UDC (06 16)	3	0	Allow NULL?
117	SZP017	Category Codes - Payroll17	String	UDC (06 17)	3	0	Allow NULL?
118	SZP018	Category Codes - Payroll18	String	UDC (06 18)	3	0	Allow NULL?
119	SZP019	Category Codes - Payroll19	String	UDC (06 19)	3	0	Allow NULL?
120	SZP020	Category Codes - Payroll20	String	UDC (06 21)	3	0	Allow NULL?
121	SZE001	Eligibility Code 001	Character	UDC (05 YB)	1	0	Allow NULL?
122	SZE002	Eligibility Code 002	Character	UDC (05 YB)	1	0	Allow NULL?
123	SZE003	Eligibility Code 003	Character	UDC (05 YB)	1	0	Allow NULL?
124	SZE004	Eligibility Code 004	Character	UDC (05 YB)	1	0	Allow NULL?
125	SZE005	Eligibility Code 005	Character	UDC (05 YB)	1	0	Allow NULL?
126	SZE006	Eligibility Code 006	Character	UDC (05 YB)	1	0	Allow NULL?
127	SZE007	Eligibility Code 007	Character	UDC (05 YB)	1	0	Allow NULL?
128	SZE008	Eligibility Code 008	Character	UDC (05 YB)	1	0	Allow NULL?
129	SZE009	Eligibility Code 009	Character	UDC (05 YB)	1	0	Allow NULL?
130	SZE010	Eligibility Code 010	Character	UDC (05 YB)	1	0	Allow NULL?
131	SZFTE	Full Time Equivalents	Numeric	Generic Edit	9	2	Allow NULL?
132	SZIH	Hours per Standard Year	Numeric	Generic Edit	7	2	Allow NULL?
133	SZCOUN	County	String	UDC (00 CT)	25	0	Allow NULL?
134	SZPOS	Position ID	String	Generic Edit	8	0	Allow NULL?
135	SZOEMP	Additional Employee No	String	Generic Edit	8	0	Allow NULL?
136	SZIFN	Initial - First Name (Govt Rpts)	Character	Generic Edit	1	0	Allow NULL?
137	SZIMN	Initial - Middle Name (Govt Rpts)	Character	Generic Edit	1	0	Allow NULL?
138	SZDTSP	Date - Time Stamp	Numeric	Generic Edit	13	0	Allow NULL?
139	SZED01	Date - User Defined1	Date	Generic Edit	6	0
140	SZED02	Date - User Defined2	Date	Generic Edit	6	0
141	SZED03	Date - User Defined3	Date	Generic Edit	6	0
142	SZED04	Date - User Defined4	Date	Generic Edit	6	0
143	SZED05	Date - User Defined5	Date	Generic Edit	6	0
144	SZED06	Date - User Defined6	Date	Generic Edit	6	0
145	SZED07	Date - User Defined7	Date	Generic Edit	6	0
146	SZED08	Date - User Defined8	Date	Generic Edit	6	0
147	SZED09	Date - User Defined9	Date	Generic Edit	6	0
148	SZED10	Date - User Defined10	Date	Generic Edit	6	0
149	SZED11	Date - User Defined11	Date	Generic Edit	6	0
150	SZED12	Date - User Defined12	Date	Generic Edit	6	0
151	SZED13	Date - User Defined13	Date	Generic Edit	6	0
152	SZED14	Date - User Defined14	Date	Generic Edit	6	0
153	SZED15	Date - User Defined15	Date	Generic Edit	6	0
154	SZED16	Date - User Defined16	Date	Generic Edit	6	0
155	SZED17	Date - User Defined17	Date	Generic Edit	6	0
156	SZED18	Date - User Defined18	Date	Generic Edit	6	0
157	SZED19	Date - User Defined19	Date	Generic Edit	6	0
158	SZED20	Date - User Defined20	Date	Generic Edit	6	0
159	SZK001	401(k) Non-Discrimination Test1	Character	Generic Edit (05 OO)	1	0	Allow NULL?
160	SZK002	401(k) Non-Discrimination Test2	Character	Generic Edit (05 YB)	1	0	Allow NULL?
161	SZK003	401(k) Non-Discrimination Test3	Character	Generic Edit (05 YB)	1	0	Allow NULL?
162	SZK004	401(k) Non-Discrimination Test4	Character	Generic Edit (05 YB)	1	0	Allow NULL?
163	SZK005	401(k) Non-Discrimination Test5	Character	Generic Edit (05 YB)	1	0	Allow NULL?
164	SZK006	401(k) Non-Discrimination Test6	Character	Generic Edit (05 YB)	1	0	Allow NULL?
165	SZK007	401(k) Non-Discrimination Test7	Character	Generic Edit (05 YB)	1	0	Allow NULL?
166	SZK008	401(k) Non-Discrimination Test8	Character	Generic Edit (05 YB)	1	0	Allow NULL?
167	SZK009	401(k) Non-Discrimination Test9	Character	Generic Edit (05 YB)	1	0	Allow NULL?
168	SZK010	401(k) Non-Discrimination Test10	Character	Generic Edit (05 YB)	1	0	Allow NULL?
169	SZLF	Labor Distribution Multiplier	Numeric	Generic Edit	5	4	Allow NULL?
170	SZLMTH	Labor Distribution Method	Character	UDC (07 LT)	1	0	Allow NULL?
171	SZRMST	Marital Status - Resident State	Character	UDC (06 MS)	1	0	Allow NULL?
172	SZSTDD	Hours - Standard per Day	Numeric	Generic Edit	5	2	Allow NULL?
173	SZSTDH	Hours - Standard per Payperiod	Numeric	Generic Edit	5	2	Allow NULL?
174	SZSMKR	Flag - Language Preference	String	UDC (07 SN)	2	0	Allow NULL?
175	SZTIPE	Employee Code - Tipped(Y/N)	Character	UDC (05 YN)	1	0	Allow NULL?
176	SZMSA	Marital Status - Actual	Character	UDC (07 MS)	1	0	Allow NULL?
177	SZADPN	Pre-Note Code	Character	UDC (07 AE)	1	0	Allow NULL?
178	SZAC01	Category Code - Address Book 01	String	UDC (01 01)	3	0	Allow NULL?
179	SZAC02	Category Code - Address Book 02	String	UDC (01 02)	3	0	Allow NULL?
180	SZAC03	Category Code - Address Book 03	String	UDC (01 03)	3	0	Allow NULL?
181	SZAC04	Category Code - Address Book 04	String	UDC (01 04)	3	0	Allow NULL?
182	SZAC05	Category Code - Address Book 05	String	UDC (01 05)	3	0	Allow NULL?
183	SZAC06	Category Code - Address Book 06	String	UDC (01 06)	3	0	Allow NULL?
184	SZAC07	Category Code - Address Book 07	String	UDC (01 07)	3	0	Allow NULL?
185	SZAC08	Category Code - Address Book 08	String	UDC (01 08)	3	0	Allow NULL?
186	SZAC09	Category Code - Address Book 09	String	UDC (01 09)	3	0	Allow NULL?
187	SZAC10	Category Code - Address Book 10	String	UDC (01 10)	3	0	Allow NULL?
188	SZAC11	Sales Region	String	UDC (01 11)	3	0	Allow NULL?
189	SZAC12	Category Code - Address Book 12	String	UDC (01 12)	3	0	Allow NULL?
190	SZAC13	Category Code - Address Book 13	String	UDC (01 13)	3	0	Allow NULL?
191	SZAC14	Category Code - Address Book 14	String	UDC (01 14)	3	0	Allow NULL?
192	SZAC15	Category Code - Address Book 15	String	UDC (01 15)	3	0	Allow NULL?
193	SZAC16	Category Code - Address Book 16	String	UDC (01 16)	3	0	Allow NULL?
194	SZAC17	Category Code - Address Book 17	String	UDC (01 17)	3	0	Allow NULL?
195	SZAC18	Category Code - Address Book 18	String	UDC (01 18)	3	0	Allow NULL?
196	SZAC19	Category Code - Address Book 19	String	UDC (01 19)	3	0	Allow NULL?
197	SZAC20	Category Code - Address Book 20	String	UDC (01 20)	3	0	Allow NULL?
198	SZAC21	Category Code - Address Book 21	String	UDC (01 21)	3	0	Allow NULL?
199	SZAC22	Category Code - Address Book 22	String	UDC (01 22)	3	0	Allow NULL?
200	SZAC23	Category Code - Address Book 23	String	UDC (01 23)	3	0	Allow NULL?
201	SZAC24	Category Code - Address Book 24	String	UDC (01 24)	3	0	Allow NULL?
202	SZAC25	Category Code - Address Book 25	String	UDC (01 25)	3	0	Allow NULL?
203	SZAC26	Category Code - Address Book 26	String	UDC (01 26)	3	0	Allow NULL?
204	SZAC27	Category Code - Address Book 27	String	UDC (01 27)	3	0	Allow NULL?
205	SZAC28	Category Code - Address Book 28	String	UDC (01 28)	3	0	Allow NULL?
206	SZAC29	Category Code - Address Book 29	String	UDC (01 29)	3	0	Allow NULL?
207	SZAC30	Category Code - Address Book 30	String	UDC (01 30)	3	0	Allow NULL?
208	SZORMCU	Organizational Business Unit	String	Generic Edit	12	0	Allow NULL?

TOP 920 | 05A | F060116Z INDEXES

Number

Description

User ID Batch Number +A (Primary/Unique)

Element	Alias	Description	Sequence
1	EDUS	EDI - User ID	Ascending
2	EDBT	EDI - Batch Number	Ascending
3	EDTN	EDI - Transaction Number	Ascending
4	EDLN	EDI - Line Number	Ascending

Address Number

Element	Alias	Description	Sequence
1	AN8	Address Number	Ascending

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

208 COLUMNS | 2 INDEXES | 920 | 05A | F060116Z TABLE

TOP 920 | 05A | F060116Z COLUMNS

TOP 920 | 05A | F060116Z INDEXES

JDE TABLES

JD Edwards Enterprise One table definition reference

jde.erpref.com

JDE TABLESv3

920: Top 10 requests

910: Top 10 requests

812: Top 10 requests

208 COLUMNS | 2 INDEXES | 920 | 05A | F060116Z TABLE

TOP920 | 05A | F060116Z COLUMNS

TOP920 | 05A | F060116Z INDEXES

TOP 920 | 05A | F060116Z COLUMNS

TOP 920 | 05A | F060116Z INDEXES